package cn.com.lzt.projectpostgeneral.controller; import cn.com.lzt.projectpostdetail.entity.ProjectPostDetailEntity; import cn.com.lzt.projectpostdetail.service.ProjectPostDetailServiceI; import cn.com.lzt.projectpostgeneral.dto.ProjectPostGeneralDto; import cn.com.lzt.projectpostgeneral.entity.ProjectPostGeneralEntity; import cn.com.lzt.projectpostgeneral.service.ProjectPostGeneralServiceI; import org.apache.log4j.Logger; import org.jeecgframework.core.beanvalidator.BeanValidators; import org.jeecgframework.core.common.controller.BaseController; import org.jeecgframework.core.common.exception.BusinessException; import org.jeecgframework.core.common.model.json.AjaxJson; import org.jeecgframework.core.common.model.json.DataGrid; import org.jeecgframework.core.constant.Globals; import org.jeecgframework.core.util.*; import org.jeecgframework.minidao.pojo.MiniDaoPage; import org.jeecgframework.poi.excel.ExcelImportUtil; import org.jeecgframework.poi.excel.entity.ExportParams; import org.jeecgframework.poi.excel.entity.ImportParams; import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants; import org.jeecgframework.tag.core.easyui.TagUtil; import org.jeecgframework.web.system.service.SystemService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.HttpHeaders; import org.springframework.http.HttpStatus; import org.springframework.http.MediaType; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.MultipartHttpServletRequest; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.util.UriComponentsBuilder; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.validation.ConstraintViolation; import javax.validation.Validator; import java.io.IOException; import java.net.URI; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.Set; /** * @Title: Controller * @Description: 项目岗位总览表 * @author onlineGenerator * @date 2017-10-16 11:56:52 * @version V1.0 * */ @Controller @RequestMapping("/projectPostGeneralController") public class ProjectPostGeneralController extends BaseController { /** * Logger for this class */ private static final Logger logger = Logger.getLogger(ProjectPostGeneralController.class); @Autowired private ProjectPostGeneralServiceI projectPostGeneralService; @Autowired private SystemService systemService; @Autowired private Validator validator; @Autowired private ProjectPostDetailServiceI projectPostDetailService; /** * 项目岗位总览表列表 页面跳转 * * @return */ @RequestMapping(params = "list") public ModelAndView list(HttpServletRequest request) { return new ModelAndView("cn/com/lzt/projectpostgeneral/projectPostGeneralList"); } /** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @RequestMapping(params = "datagrid") public void datagrid(ProjectPostGeneralDto projectPostGeneralDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { /*CriteriaQuery cq = new CriteriaQuery(ProjectPostGeneralEntity.class, dataGrid); //查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, projectPostGeneral, request.getParameterMap()); try{ //自定义追加查询条件 String myPId=projectPostGeneral.getPid(); if(myPId!=null&&myPId.length()>0&&myPId.indexOf(",")!=-1){ cq.eq("pid", myPId.substring(0, myPId.indexOf(","))); } cq.eq("deleteFlag", Globals.Delete_Normal.toString()); //排序 Map map = new HashMap(); map.put("createDate", "desc"); cq.setOrder(map); }catch (Exception e) { throw new BusinessException(e.getMessage()); } cq.add(); this.projectPostGeneralService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid);*/ String myPId=projectPostGeneralDto.getPid(); if(myPId!=null&&myPId.length()>0&&myPId.indexOf(",")!=-1){ projectPostGeneralDto.setPid(myPId.substring(0, myPId.indexOf(","))); } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); MiniDaoPage projectPostGeneralDtoList = projectPostGeneralService.getProjectPostGeneralDtoPage(projectPostGeneralDto, dataGrid.getPage(), dataGrid.getRows(),authSql); dataGrid.setTotal(projectPostGeneralDtoList.getTotal()); dataGrid.setResults(projectPostGeneralDtoList.getResults()); TagUtil.datagrid(response, dataGrid); } /** * 删除项目岗位总览表 * * @return */ @RequestMapping(params = "doDel") @ResponseBody public AjaxJson doDel(ProjectPostGeneralEntity projectPostGeneral, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); projectPostGeneral = systemService.getEntity(ProjectPostGeneralEntity.class, projectPostGeneral.getId()); message = "项目岗位删除成功"; try{ projectPostGeneralService.delete(projectPostGeneral); systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO); }catch(Exception e){ e.printStackTrace(); message = "项目岗位删除失败"; throw new BusinessException(e.getMessage()); } j.setMsg(message); return j; } /** * 批量删除项目岗位总览表 * * @return */ @RequestMapping(params = "doBatchDel") @ResponseBody public AjaxJson doBatchDel(String ids,HttpServletRequest request){ String message = null; AjaxJson j = new AjaxJson(); message = "项目岗位总览删除成功"; try{ for(String id:ids.split(",")){ ProjectPostGeneralEntity projectPostGeneral = systemService.getEntity(ProjectPostGeneralEntity.class, id ); projectPostGeneralService.delete(projectPostGeneral); systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO); } }catch(Exception e){ e.printStackTrace(); message = "项目岗位总览删除失败"; throw new BusinessException(e.getMessage()); } j.setMsg(message); return j; } /** * 添加项目岗位总览表 * * @param ids * @return */ @RequestMapping(params = "doAdd") @ResponseBody public AjaxJson doAdd(ProjectPostGeneralEntity projectPostGeneral, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = "项目岗位添加成功"; try{ projectPostGeneralService.save(projectPostGeneral); systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO); }catch(Exception e){ e.printStackTrace(); message = "项目岗位添加失败"; throw new BusinessException(e.getMessage()); } j.setMsg(message); return j; } /** * 更新项目岗位总览表 * * @param ids * @return */ @RequestMapping(params = "doUpdate") @ResponseBody public AjaxJson doUpdate(ProjectPostGeneralEntity projectPostGeneral, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = "项目岗位更新成功"; ProjectPostGeneralEntity t = projectPostGeneralService.get(ProjectPostGeneralEntity.class, projectPostGeneral.getId()); try { MyBeanUtils.copyBeanNotNull2Bean(projectPostGeneral, t); projectPostGeneralService.saveOrUpdate(t); systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO); } catch (Exception e) { e.printStackTrace(); message = "项目岗位更新失败"; throw new BusinessException(e.getMessage()); } j.setMsg(message); return j; } /** * 项目岗位总览表新增页面跳转 * * @return */ @RequestMapping(params = "goAdd") public ModelAndView goAdd(ProjectPostGeneralEntity projectPostGeneral, HttpServletRequest req) { if (StringUtil.isNotEmpty(projectPostGeneral.getId())) { projectPostGeneral = projectPostGeneralService.getEntity(ProjectPostGeneralEntity.class, projectPostGeneral.getId()); req.setAttribute("projectPostGeneralPage", projectPostGeneral); } return new ModelAndView("cn/com/lzt/projectpostgeneral/projectPostGeneral-add"); } /** * 项目岗位总览表编辑页面跳转 * * @return */ @RequestMapping(params = "goUpdate") public ModelAndView goUpdate(ProjectPostGeneralEntity projectPostGeneral, HttpServletRequest req) { if (StringUtil.isNotEmpty(projectPostGeneral.getId())) { projectPostGeneral = projectPostGeneralService.getEntity(ProjectPostGeneralEntity.class, projectPostGeneral.getId()); req.setAttribute("projectPostGeneralPage", projectPostGeneral); } return new ModelAndView("cn/com/lzt/projectpostgeneral/projectPostGeneral-update"); } /** * 导入功能跳转 * * @return */ @RequestMapping(params = "upload") public ModelAndView upload(HttpServletRequest req) { req.setAttribute("controller_name","projectPostGeneralController"); return new ModelAndView("common/upload/pub_excel_upload"); } /** * 导出excel * * @param request * @param response */ @RequestMapping(params = "exportXls") public String exportXls(ProjectPostGeneralDto projectPostGeneralDto,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { /*//获取项目名称 List departList=systemService.queryDict("t_s_depart", "id", "departname"); Map departMap=new HashMap(); for (int i = 0; i < departList.size(); i++) { departMap.put(departList.get(i).getTypecode(), departList.get(i).getTypename()); } //获取用户名称 List baseUserList=systemService.queryDict("t_s_base_user", "id", "realname"); Map baseUserMap=new HashMap(); for (int i = 0; i < baseUserList.size(); i++) { baseUserMap.put(baseUserList.get(i).getTypecode(), baseUserList.get(i).getTypename()); } //标题 该list中用于存储标题的信息，每一个ExcelExportEntity 表示一列，根据List 的入栈顺序，由左至右，一次排序 List entityList = new ArrayList(); ExcelExportEntity head1=new ExcelExportEntity("项目名称", "pid", 15); entityList.add(head1); ExcelExportEntity head2=new ExcelExportEntity("岗位分配", "overallSituation", 15); entityList.add(head2); ExcelExportEntity head3=new ExcelExportEntity("分配人", "setterId", 15); entityList.add(head3); //组建数据集 List> dataResult = new ArrayList>(); List projectPostGeneralEntityList=new ArrayList(); StringBuffer hql = new StringBuffer(" from ProjectPostGeneralEntity t where 1=1 and t.deleteFlag = '0' "); if(projectPostGeneral.getPid()!=null&&projectPostGeneral.getPid().length()>0){ hql.append(" and t.pid = ? "); projectPostGeneralEntityList = projectPostGeneralService.findHql(hql.toString(),projectPostGeneral.getPid()); }else{ projectPostGeneralEntityList = projectPostGeneralService.findHql(hql.toString()); } for (int i = 0; i < projectPostGeneralEntityList.size(); i++) { Map map = new HashMap(); map.put("pid", departMap.get(projectPostGeneralEntityList.get(i).getPid())); map.put("overallSituation", projectPostGeneralEntityList.get(i).getOverallSituation()); map.put("setterId", baseUserMap.get(projectPostGeneralEntityList.get(i).getSetterId())); dataResult.add(map); } modelMap.put(MapExcelConstants.ENTITY_LIST, entityList); modelMap.put(MapExcelConstants.MAP_LIST, dataResult); modelMap.put(NormalExcelConstants.FILE_NAME,"项目岗位设定"); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("项目岗位设定", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); return MapExcelConstants.JEECG_MAP_EXCEL_VIEW;*/ String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); List projectPostGeneralDtoList=null; try { projectPostGeneralDtoList = projectPostGeneralService.getProjectPostGeneralDtoExport(projectPostGeneralDto, authSql); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } modelMap.put(NormalExcelConstants.FILE_NAME,"项目岗位设定"); modelMap.put(NormalExcelConstants.CLASS,ProjectPostGeneralDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("项目岗位设定", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,projectPostGeneralDtoList); return NormalExcelConstants.JEECG_EXCEL_VIEW; /*CriteriaQuery cq = new CriteriaQuery(ProjectPostGeneralEntity.class, dataGrid); org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, projectPostGeneral, request.getParameterMap()); List projectPostGenerals = this.projectPostGeneralService.getListByCriteriaQuery(cq,false); modelMap.put(NormalExcelConstants.FILE_NAME,"项目岗位总览表"); modelMap.put(NormalExcelConstants.CLASS,ProjectPostGeneralEntity.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("项目岗位总览表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,projectPostGenerals); return NormalExcelConstants.JEECG_EXCEL_VIEW;*/ } /** * 导出excel 使模板 * * @param request * @param response */ @RequestMapping(params = "exportXlsByT") public String exportXlsByT(ProjectPostGeneralEntity projectPostGeneral,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { modelMap.put(NormalExcelConstants.FILE_NAME,"项目岗位总览"); modelMap.put(NormalExcelConstants.CLASS,ProjectPostGeneralEntity.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("项目岗位总览列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList()); return NormalExcelConstants.JEECG_EXCEL_VIEW; } @SuppressWarnings("unchecked") @RequestMapping(params = "importExcel", method = RequestMethod.POST) @ResponseBody public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) { AjaxJson j = new AjaxJson(); MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request; Map fileMap = multipartRequest.getFileMap(); for (Map.Entry entity : fileMap.entrySet()) { MultipartFile file = entity.getValue();// 获取上传文件对象 ImportParams params = new ImportParams(); params.setTitleRows(2); params.setHeadRows(1); params.setNeedSave(true); try { List listProjectPostGeneralEntitys = ExcelImportUtil.importExcel(file.getInputStream(),ProjectPostGeneralEntity.class,params); for (ProjectPostGeneralEntity projectPostGeneral : listProjectPostGeneralEntitys) { projectPostGeneralService.save(projectPostGeneral); } j.setMsg("文件导入成功！"); } catch (Exception e) { j.setMsg("文件导入失败！"); logger.error(ExceptionUtil.getExceptionMessage(e)); }finally{ try { file.getInputStream().close(); } catch (IOException e) { e.printStackTrace(); } } } return j; } @RequestMapping(method = RequestMethod.GET) @ResponseBody public List list() { List listProjectPostGenerals=projectPostGeneralService.getList(ProjectPostGeneralEntity.class); return listProjectPostGenerals; } @RequestMapping(value = "/{id}", method = RequestMethod.GET) @ResponseBody public ResponseEntity get(@PathVariable("id") String id) { ProjectPostGeneralEntity task = projectPostGeneralService.get(ProjectPostGeneralEntity.class, id); if (task == null) { return new ResponseEntity(HttpStatus.NOT_FOUND); } return new ResponseEntity(task, HttpStatus.OK); } @RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE) @ResponseBody public ResponseEntity create(@RequestBody ProjectPostGeneralEntity projectPostGeneral, UriComponentsBuilder uriBuilder) { //调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息. Set> failures = validator.validate(projectPostGeneral); if (!failures.isEmpty()) { return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST); } //保存 try{ projectPostGeneralService.save(projectPostGeneral); } catch (Exception e) { e.printStackTrace(); return new ResponseEntity(HttpStatus.NO_CONTENT); } //按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象. String id = projectPostGeneral.getId(); URI uri = uriBuilder.path("/rest/projectPostGeneralController/" + id).build().toUri(); HttpHeaders headers = new HttpHeaders(); headers.setLocation(uri); return new ResponseEntity(headers, HttpStatus.CREATED); } @RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE) public ResponseEntity update(@RequestBody ProjectPostGeneralEntity projectPostGeneral) { //调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息. Set> failures = validator.validate(projectPostGeneral); if (!failures.isEmpty()) { return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST); } //保存 try{ projectPostGeneralService.saveOrUpdate(projectPostGeneral); } catch (Exception e) { e.printStackTrace(); return new ResponseEntity(HttpStatus.NO_CONTENT); } //按Restful约定，返回204状态码, 无内容. 也可以返回200状态码. return new ResponseEntity(HttpStatus.NO_CONTENT); } @RequestMapping(value = "/{id}", method = RequestMethod.DELETE) @ResponseStatus(HttpStatus.NO_CONTENT) public void delete(@PathVariable("id") String id) { projectPostGeneralService.deleteEntityById(ProjectPostGeneralEntity.class, id); } @RequestMapping(params = "projectSelect") public String projectSelect(HttpServletRequest req) { // req.setAttribute("orgIds", req.getParameter("orgIds")); return "cn/com/lzt/projectpostgeneral/projectSelect"; } /** * 保存新增/更新的行数据项目岗位总览表 * 同时更新项目岗位明细表 * @author zbw * 2017-10-18 * @param projectPostGeneral * @param request * @return */ @RequestMapping(params = "saveRows") @ResponseBody public AjaxJson saveRows(ProjectPostDetailEntity projectPostDetailEntity,String overallSituation, HttpServletRequest request){ AjaxJson j = new AjaxJson(); if(projectPostDetailEntity.getPid()!=null&&projectPostDetailEntity.getPid().length()>0){ projectPostDetailEntity.setPid(projectPostDetailEntity.getPid().split(",")[0]); } if(projectPostDetailEntity.getPostid()!=null&&projectPostDetailEntity.getPostid().length()>0){ projectPostDetailEntity.setPostid(projectPostDetailEntity.getPostid().split(",")[0]); } try { j=projectPostGeneralService.saveProjectPostGeneralEntity(projectPostDetailEntity,overallSituation); if(j.isSuccess()){ j.setMsg("保存成功"); }else{ j.setMsg("保存失败"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return j; } /** * 逻辑删除项目岗位总览表 * 同时逻辑删除项目岗位明细表数据 * @author zbw * 2017-10-18 * @param projectPostDetail * @param request * @return */ @RequestMapping(params = "logicDelProjectPostGeneralAndProjectPostDetail") @ResponseBody public AjaxJson logicDelProjectPostGeneralAndProjectPostDetail(ProjectPostGeneralEntity projectPostGeneralEntity, HttpServletRequest request) { AjaxJson j = new AjaxJson(); try { j=projectPostGeneralService.logicDelProjectPostGeneralEntity(projectPostGeneralEntity); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return j; } /** * 逻辑删除项目岗位明细表数据 * 同时更新项目岗位总览表 * @author zbw * 2017-11-28 * @param projectPostDetailEntity * @param overallSituation * @param request * @return */ @RequestMapping(params = "logicDelProjectPostDetailUpdateProjectPostGeneral") @ResponseBody public AjaxJson logicDelProjectPostDetailUpdateProjectPostGeneral(ProjectPostDetailEntity projectPostDetailEntity,String overallSituation, HttpServletRequest request) { AjaxJson j = new AjaxJson(); try { j=projectPostGeneralService.logicDelProjectPostDetailUpdateProjectPostGeneral(projectPostDetailEntity,overallSituation); if(j.isSuccess()){ j.setMsg("操作成功"); }else{ j.setMsg("操作失败"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return j; } /** * 异步验证项目名称是否已存在 * @author zbw * 2017-11-12 * @param projectPostGeneral * @param request * @return */ @RequestMapping(params = "ajaxCheckProjectName") @ResponseBody public AjaxJson ajaxCheckProjectName(ProjectPostGeneralEntity projectPostGeneral, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = ""; StringBuffer hql = new StringBuffer(" from ProjectPostGeneralEntity t where delete_flag = '0' and t.pid=? "); List projectPostGeneralList = projectPostGeneralService.findHql(hql.toString(), projectPostGeneral.getPid().split(",")[0]); if(projectPostGeneralList.size()!=0){ j.setSuccess(false); message="项目名称已存在"; } j.setMsg(message); return j; } /** * 验证项目岗位名称是否存在 * @author zbw * 2017-11-28 * @param projectPostDetailEntity * @param request * @return */ @RequestMapping(params = "ajaxCheckPtjPostName") @ResponseBody public AjaxJson ajaxCheckPtjPostName(ProjectPostDetailEntity projectPostDetailEntity, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = ""; StringBuffer hql = new StringBuffer(" from ProjectPostDetailEntity t where delete_flag = '0' and t.pid=? "); List projectPostDetailList = projectPostGeneralService.findHql(hql.toString(), projectPostDetailEntity.getPid().split(",")[0]); for (int i = 0; i < projectPostDetailList.size(); i++) { if(projectPostDetailEntity.getId()!=null&&projectPostDetailEntity.getId().length()!=0){ if(!projectPostDetailList.get(i).getId().equals(projectPostDetailEntity.getId())){ if(projectPostDetailList.get(i).getPtjPostName().equals(projectPostDetailEntity.getPtjPostName())){ j.setSuccess(false); message="项目岗位名称已存在"; break; } } }else{ if(projectPostDetailList.get(i).getPtjPostName().equals(projectPostDetailEntity.getPtjPostName())){ j.setSuccess(false); message="项目岗位名称已存在"; break; } } } j.setMsg(message); return j; } }