package cn.com.lzt.duties.controller; import cn.com.lzt.duties.entity.DutiesEntity; import cn.com.lzt.duties.service.DutiesServiceI; import cn.com.lzt.post.entity.PostEntity; import org.apache.commons.lang.StringUtils; import org.apache.log4j.Logger; import org.jeecgframework.core.beanvalidator.BeanValidators; import org.jeecgframework.core.common.controller.BaseController; import org.jeecgframework.core.common.dao.jdbc.JdbcDao; import org.jeecgframework.core.common.exception.BusinessException; import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery; 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.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.*; /** * @Title: Controller * @Description: 职务 * @author onlineGenerator * @date 2017-10-10 14:23:13 * @version V1.0 * */ @Controller @RequestMapping("/dutiesController") public class DutiesController extends BaseController { /** * Logger for this class */ private static final Logger logger = Logger.getLogger(DutiesController.class); @Autowired private DutiesServiceI dutiesService; @Autowired private SystemService systemService; @Autowired private Validator validator; /** * 职务列表 页面跳转 * * @return */ @RequestMapping(params = "list") public ModelAndView list(HttpServletRequest request) { return new ModelAndView("cn/com/lzt/duties/dutiesList"); } /** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @RequestMapping(params = "datagrid") public void datagrid(DutiesEntity duties,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(DutiesEntity.class, dataGrid); if(StringUtil.isEmpty(duties.getId())){ cq.isNull("parentDutiesid"); }else{ cq.eq("parentDutiesid", duties.getId()); duties.setId(null); } if(!StringUtil.isEmpty(duties.getDutiesName())){ duties.setDutiesName("*" + duties.getDutiesName() + "*"); } //查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, duties, request.getParameterMap()); try{ //自定义追加查询条件 String[] status = new String[]{Globals.Enabled_Status.toString(), Globals.Disabled_Status.toString()}; cq.in("status", status); 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.dutiesService.getDataGridReturn(cq, true); TagUtil.treegrid(response, dataGrid); } /** * 删除职务 * * @return */ @RequestMapping(params = "doDel") @ResponseBody public AjaxJson doDel(DutiesEntity duties, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); duties = systemService.getEntity(DutiesEntity.class, duties.getId()); message = "职务删除成功"; try{ dutiesService.delete(duties); 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 = "logicDel") @ResponseBody public AjaxJson logicDel(String id, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); DutiesEntity duties = systemService.getEntity(DutiesEntity.class, id); message = "职务 删除成功"; try{ List childList = getAllChildrenList(duties.getId(), null, null); childList.add(duties);// 加入父节点 for(int i=0; i checkPostName(DutiesEntity duties, HttpServletRequest request) { Boolean flag = dutiesService.findDutyByDutiesName(duties); Map res = new HashMap(); res.put("flag",flag); return res; } /** * 添加职务 * * @param ids * @return */ @RequestMapping(params = "doAdd") @ResponseBody public AjaxJson doAdd(DutiesEntity duties, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = "职务添加成功"; try{ if(StringUtil.isEmpty(duties.getParentDutiesid())){ duties.setParentDutiesid(null); String localMaxCode = getMaxLocalCode(null); duties.setDutiesCode(YouBianCodeUtil.getNextYouBianCode(localMaxCode)); }else{ DutiesEntity d = dutiesService.findUniqueByProperty(DutiesEntity.class, "id", duties.getParentDutiesid()); String localMaxCode = getMaxLocalCode(d.getDutiesCode()); duties.setDutiesCode(YouBianCodeUtil.getSubYouBianCode(d.getDutiesCode(), localMaxCode)); } duties.setStatus(Globals.Enabled_Status.toString()); duties.setDeleteFlag(Globals.Delete_Normal.toString()); dutiesService.save(duties); 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(DutiesEntity duties, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = "职务更新成功"; DutiesEntity t = dutiesService.get(DutiesEntity.class, duties.getId()); try { MyBeanUtils.copyBeanNotNull2Bean(duties, t); if(StringUtil.isEmpty(t.getParentDutiesid())){ t.setParentDutiesid(null); } dutiesService.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(DutiesEntity duties, HttpServletRequest req) { if (StringUtil.isNotEmpty(duties.getId())) { duties = dutiesService.getEntity(DutiesEntity.class, duties.getId()); req.setAttribute("dutiesPage", duties); } return new ModelAndView("cn/com/lzt/duties/duties-add"); } /** * 职务编辑页面跳转 * * @return */ @RequestMapping(params = "goUpdate") public ModelAndView goUpdate(DutiesEntity duties, HttpServletRequest req) { if (StringUtil.isNotEmpty(duties.getId())) { duties = dutiesService.getEntity(DutiesEntity.class, duties.getId()); if(duties!=null && duties.getParentDutiesid()!=null){ DutiesEntity parentDuties = dutiesService.getEntity(DutiesEntity.class, duties.getParentDutiesid()); duties.setParentDuties(parentDuties); } req.setAttribute("dutiesPage", duties); // 岗位名 String postName = ""; if(duties.getPost() != null && duties.getPost().length()>0) { PostEntity postEntity = systemService.getEntity(PostEntity.class, duties.getPost()); if(postEntity != null) { postName = postEntity.getPostName(); } } req.setAttribute("postName", postName); } return new ModelAndView("cn/com/lzt/duties/duties-update"); } /** * 导入功能跳转 * * @return */ @RequestMapping(params = "upload") public ModelAndView upload(HttpServletRequest req) { req.setAttribute("controller_name","dutiesController"); return new ModelAndView("common/upload/pub_excel_upload"); } /** * 导出excel * * @param request * @param response */ @RequestMapping(params = "exportXls") public String exportXls(DutiesEntity duties,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { CriteriaQuery cq = new CriteriaQuery(DutiesEntity.class, dataGrid); org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, duties, request.getParameterMap()); List dutiess = this.dutiesService.getListByCriteriaQuery(cq,false); modelMap.put(NormalExcelConstants.FILE_NAME,"职务"); modelMap.put(NormalExcelConstants.CLASS,DutiesEntity.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("职务列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,dutiess); return NormalExcelConstants.JEECG_EXCEL_VIEW; } /** * 导出excel 使模板 * * @param request * @param response */ @RequestMapping(params = "exportXlsByT") public String exportXlsByT(DutiesEntity duties,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { modelMap.put(NormalExcelConstants.FILE_NAME,"职务"); modelMap.put(NormalExcelConstants.CLASS,DutiesEntity.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 listDutiesEntitys = ExcelImportUtil.importExcel(file.getInputStream(),DutiesEntity.class,params); for (DutiesEntity duties : listDutiesEntitys) { dutiesService.save(duties); } 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 listDutiess=dutiesService.getList(DutiesEntity.class); return listDutiess; } @RequestMapping(value = "/{id}", method = RequestMethod.GET) @ResponseBody public ResponseEntity get(@PathVariable("id") String id) { DutiesEntity task = dutiesService.get(DutiesEntity.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 DutiesEntity duties, UriComponentsBuilder uriBuilder) { //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息. Set> failures = validator.validate(duties); if (!failures.isEmpty()) { return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST); } //保存 try{ dutiesService.save(duties); } catch (Exception e) { e.printStackTrace(); return new ResponseEntity(HttpStatus.NO_CONTENT); } //按照Restful风格约定,创建指向新任务的url, 也可以直接返回id或对象. String id = duties.getId(); URI uri = uriBuilder.path("/rest/dutiesController/" + 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 DutiesEntity duties) { //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息. Set> failures = validator.validate(duties); if (!failures.isEmpty()) { return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST); } //保存 try{ dutiesService.saveOrUpdate(duties); } 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) { dutiesService.deleteEntityById(DutiesEntity.class, id); } @RequestMapping(params = "getDepartInfo") @ResponseBody public AjaxJson getDepartInfo(HttpServletRequest request, HttpServletResponse response){ AjaxJson j = new AjaxJson(); String orgIds = request.getParameter("orgIds"); /*String[] ids = new String[]{}; if(StringUtils.isNotBlank(orgIds)){ orgIds = orgIds.substring(0, orgIds.length()-1); ids = orgIds.split("\\,"); }*/ String codeFilter = request.getParameter("codeFilter"); String parentid = request.getParameter("parentid"); List tSDeparts = new ArrayList(); StringBuffer hql = new StringBuffer(" from DutiesEntity t where 1=1 and deleteFlag <> '1' and status <> '1'"); if(codeFilter != null && codeFilter.length()>0) { String[] splits = codeFilter.split(";"); if(splits != null && splits.length>0) { hql.append("and ( duties_code like '" + splits[0] +"'"); for(int i=1 ; splits.length>1 && i> dateList = new ArrayList>(); if(tSDeparts.size()>0){ Map map = null; String sql = null; Object[] params = null; for(DutiesEntity depart:tSDeparts){ map = new HashMap(); map.put("id", depart.getId()); map.put("name", depart.getDutiesName()); if(StringUtils.isNotBlank(orgIds)){ if(orgIds.equals(depart.getId())){ map.put("checked", true); } } if(StringUtils.isNotBlank(parentid)){ map.put("pId", parentid); } else{ map.put("pId", ""); } //根据id判断是否有子节点 sql = "select count(1) from t_bus_duties t where t.parent_dutiesid =? and delete_flag <> '1' and status <> '1'"; params = new Object[]{depart.getId()}; long count = this.systemService.getCountForJdbcParam(sql, params); if(count>0){ map.put("isParent",true); } dateList.add(map); } } net.sf.json.JSONArray jsonArray = net.sf.json.JSONArray.fromObject(dateList); j.setMsg(jsonArray.toString()); return j; } //-------------------------------------------------------------------------------------- /** * 生成code * @param parentCode * @return */ private synchronized String getMaxLocalCode(String parentCode){ if(oConvertUtils.isEmpty(parentCode)){ parentCode = ""; } int localCodeLength = parentCode.length() + YouBianCodeUtil.zhanweiLength; StringBuilder sb = new StringBuilder(); sb.append("SELECT duties_code FROM t_bus_duties"); if(ResourceUtil.getJdbcUrl().indexOf(JdbcDao.DATABSE_TYPE_SQLSERVER)!=-1){ sb.append(" where LEN(duties_code) = ").append(localCodeLength); }else{ sb.append(" where LENGTH(duties_code) = ").append(localCodeLength); } if(oConvertUtils.isNotEmpty(parentCode)){ sb.append(" and duties_code like '").append(parentCode).append("%'"); } sb.append(" ORDER BY duties_code DESC"); List> objMapList = dutiesService.findForJdbc(sb.toString(), 1, 1); String returnCode = null; if(objMapList!=null && objMapList.size()>0){ returnCode = (String)objMapList.get(0).get("duties_code"); } return returnCode; } /** * 启用 * * @author zhijia.wang */ @RequestMapping(params = "enable") @ResponseBody public AjaxJson enable(String id, HttpServletRequest req) { AjaxJson j = new AjaxJson(); String message = null; DutiesEntity duties = dutiesService.getEntity(DutiesEntity.class, id); try{ List childList = getAllParentList(duties.getParentDutiesid(), null, null); childList.add(duties);// 加入父节点 for(int i=0; i childList = getAllChildrenList(id, null, null); childList.add(duties);// 加入父节点 for(int i=0; i getAllChildrenList(String pid, List entryList, List childList) { if(childList == null){ childList = new ArrayList(); } final String hql = "from DutiesEntity where parentDutiesid=? "; entryList = dutiesService.findHql(hql, pid); for (DutiesEntity entry : entryList) { // 遍历出父id等于参数的id,add进子节点集合 if (entry.getParentDutiesid().equals(pid)) { // 递归遍历下一级 getAllChildrenList(entry.getId(), entryList, childList); childList.add(entry); } } return childList; } /** * 获取某个子节点上面的所有父节点 * * @param childId 父ID * @param entryList 当前节点的所有父节点列表(for循环用) * @param childList 所有父节点列表 * @return */ private List getAllParentList(String pid, List entryList, List parentList) { if(parentList == null){ parentList = new ArrayList(); } final String hql = "from DutiesEntity where id=? "; entryList = dutiesService.findHql(hql, pid); for (DutiesEntity entry : entryList) { // 遍历出父id等于参数的id,add进父节点集合 if (entry.getId().equals(pid)) { // 递归遍历下一级 getAllParentList(entry.getParentDutiesid(), entryList, parentList); parentList.add(entry); } } return parentList; } }