ProcessRoleDepartMapController.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409
  1. package cn.com.lzt.process.roledepartmap.controller;
  2. import cn.com.lzt.process.roledepartmap.entity.ProcessRoleDepartMapEntity;
  3. import cn.com.lzt.process.roledepartmap.service.ProcessRoleDepartMapServiceI;
  4. import java.util.ArrayList;
  5. import java.util.List;
  6. import java.text.SimpleDateFormat;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;
  9. import org.apache.commons.lang.xwork.StringUtils;
  10. import org.apache.log4j.Logger;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Controller;
  13. import org.springframework.ui.ModelMap;
  14. import org.springframework.web.bind.annotation.RequestMapping;
  15. import org.springframework.web.bind.annotation.ResponseBody;
  16. import org.springframework.web.servlet.ModelAndView;
  17. import org.jeecgframework.core.common.controller.BaseController;
  18. import org.jeecgframework.core.common.exception.BusinessException;
  19. import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
  20. import org.jeecgframework.core.common.model.common.TreeChildCount;
  21. import org.jeecgframework.core.common.model.json.AjaxJson;
  22. import org.jeecgframework.core.common.model.json.DataGrid;
  23. import org.jeecgframework.core.constant.Globals;
  24. import org.jeecgframework.core.util.StringUtil;
  25. import org.jeecgframework.tag.core.easyui.TagUtil;
  26. import org.jeecgframework.web.system.pojo.base.TSDepart;
  27. import org.jeecgframework.web.system.service.SystemService;
  28. import org.jeecgframework.core.util.MyBeanUtils;
  29. import java.io.OutputStream;
  30. import org.jeecgframework.core.util.BrowserUtils;
  31. import org.jeecgframework.poi.excel.ExcelExportUtil;
  32. import org.jeecgframework.poi.excel.ExcelImportUtil;
  33. import org.jeecgframework.poi.excel.entity.ExportParams;
  34. import org.jeecgframework.poi.excel.entity.ImportParams;
  35. import org.jeecgframework.poi.excel.entity.TemplateExportParams;
  36. import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
  37. import org.jeecgframework.poi.excel.entity.vo.TemplateExcelConstants;
  38. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  39. import org.jeecgframework.core.util.ResourceUtil;
  40. import java.io.IOException;
  41. import org.springframework.web.bind.annotation.RequestMethod;
  42. import org.springframework.web.multipart.MultipartFile;
  43. import org.springframework.web.multipart.MultipartHttpServletRequest;
  44. import java.util.Map;
  45. import java.util.HashMap;
  46. import org.jeecgframework.core.util.ExceptionUtil;
  47. import org.springframework.http.ResponseEntity;
  48. import org.springframework.stereotype.Controller;
  49. import org.springframework.web.bind.annotation.PathVariable;
  50. import org.springframework.web.bind.annotation.RequestBody;
  51. import org.springframework.web.bind.annotation.RequestMapping;
  52. import org.springframework.web.bind.annotation.RequestMethod;
  53. import org.springframework.web.bind.annotation.ResponseBody;
  54. import org.springframework.web.bind.annotation.ResponseStatus;
  55. import org.springframework.http.HttpHeaders;
  56. import org.springframework.http.HttpStatus;
  57. import org.jeecgframework.core.beanvalidator.BeanValidators;
  58. import java.util.Set;
  59. import javax.validation.ConstraintViolation;
  60. import javax.validation.Validator;
  61. import java.net.URI;
  62. import org.springframework.http.MediaType;
  63. import org.springframework.web.util.UriComponentsBuilder;
  64. /**
  65. * @Title: Controller
  66. * @Description: 审批角色部门关联
  67. * @author onlineGenerator
  68. * @date 2021-03-05 10:51:28
  69. * @version V1.0
  70. *
  71. */
  72. @Controller
  73. @RequestMapping("/processRoleDepartMapController")
  74. public class ProcessRoleDepartMapController extends BaseController {
  75. /**
  76. * Logger for this class
  77. */
  78. private static final Logger logger = Logger.getLogger(ProcessRoleDepartMapController.class);
  79. @Autowired
  80. private ProcessRoleDepartMapServiceI processRoleDepartMapService;
  81. @Autowired
  82. private SystemService systemService;
  83. @Autowired
  84. private Validator validator;
  85. /**
  86. * 审批角色部门关联列表 页面跳转
  87. *
  88. * @return
  89. */
  90. @RequestMapping(params = "list")
  91. public ModelAndView list(HttpServletRequest request) {
  92. return new ModelAndView("cn/com/lzt/process/roledepartmap/processRoleDepartMapList");
  93. }
  94. /**
  95. * easyui AJAX请求数据
  96. *
  97. * @param request
  98. * @param response
  99. * @param dataGrid
  100. * @param user
  101. */
  102. @RequestMapping(params = "datagrid")
  103. public void datagrid(ProcessRoleDepartMapEntity processRoleDepartMap,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
  104. CriteriaQuery cq = new CriteriaQuery(ProcessRoleDepartMapEntity.class, dataGrid);
  105. //查询条件组装器
  106. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, processRoleDepartMap, request.getParameterMap());
  107. try{
  108. //自定义追加查询条件
  109. }catch (Exception e) {
  110. throw new BusinessException(e.getMessage());
  111. }
  112. cq.add();
  113. this.processRoleDepartMapService.getDataGridReturn(cq, true);
  114. TagUtil.datagrid(response, dataGrid);
  115. }
  116. /**
  117. * 删除审批角色部门关联
  118. *
  119. * @return
  120. */
  121. @RequestMapping(params = "doDel")
  122. @ResponseBody
  123. public AjaxJson doDel(ProcessRoleDepartMapEntity processRoleDepartMap, HttpServletRequest request) {
  124. String message = null;
  125. AjaxJson j = new AjaxJson();
  126. processRoleDepartMap = systemService.getEntity(ProcessRoleDepartMapEntity.class, processRoleDepartMap.getId());
  127. message = "审批角色部门关联删除成功";
  128. try{
  129. processRoleDepartMapService.delete(processRoleDepartMap);
  130. systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
  131. }catch(Exception e){
  132. e.printStackTrace();
  133. message = "审批角色部门关联删除失败";
  134. throw new BusinessException(e.getMessage());
  135. }
  136. j.setMsg(message);
  137. return j;
  138. }
  139. /**
  140. * 批量删除审批角色部门关联
  141. *
  142. * @return
  143. */
  144. @RequestMapping(params = "doBatchDel")
  145. @ResponseBody
  146. public AjaxJson doBatchDel(String ids,HttpServletRequest request){
  147. String message = null;
  148. AjaxJson j = new AjaxJson();
  149. message = "审批角色部门关联删除成功";
  150. try{
  151. for(String id:ids.split(",")){
  152. ProcessRoleDepartMapEntity processRoleDepartMap = systemService.getEntity(ProcessRoleDepartMapEntity.class,
  153. id
  154. );
  155. processRoleDepartMapService.delete(processRoleDepartMap);
  156. systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
  157. }
  158. }catch(Exception e){
  159. e.printStackTrace();
  160. message = "审批角色部门关联删除失败";
  161. throw new BusinessException(e.getMessage());
  162. }
  163. j.setMsg(message);
  164. return j;
  165. }
  166. /**
  167. * 添加审批角色部门关联
  168. *
  169. * @return
  170. */
  171. @RequestMapping(params = "doAdd")
  172. @ResponseBody
  173. public AjaxJson doAdd(ProcessRoleDepartMapEntity processRoleDepartMap, HttpServletRequest request) {
  174. if(StringUtils.isNotBlank(processRoleDepartMap.getId())){
  175. return doUpdate(processRoleDepartMap,request);
  176. }
  177. String message = null;
  178. AjaxJson j = new AjaxJson();
  179. message = "审批角色部门关联添加成功";
  180. try{
  181. processRoleDepartMapService.save(processRoleDepartMap);
  182. systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
  183. }catch(Exception e){
  184. e.printStackTrace();
  185. message = "审批角色部门关联添加失败";
  186. throw new BusinessException(e.getMessage());
  187. }
  188. j.setMsg(message);
  189. return j;
  190. }
  191. /**
  192. * 更新审批角色部门关联
  193. *
  194. * @return
  195. */
  196. @RequestMapping(params = "doUpdate")
  197. @ResponseBody
  198. public AjaxJson doUpdate(ProcessRoleDepartMapEntity processRoleDepartMap, HttpServletRequest request) {
  199. String message = null;
  200. AjaxJson j = new AjaxJson();
  201. message = "审批角色部门关联更新成功";
  202. ProcessRoleDepartMapEntity t = processRoleDepartMapService.get(ProcessRoleDepartMapEntity.class, processRoleDepartMap.getId());
  203. try {
  204. MyBeanUtils.copyBeanNotNull2Bean(processRoleDepartMap, t);
  205. processRoleDepartMapService.saveOrUpdate(t);
  206. systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
  207. } catch (Exception e) {
  208. e.printStackTrace();
  209. message = "审批角色部门关联更新失败";
  210. throw new BusinessException(e.getMessage());
  211. }
  212. j.setMsg(message);
  213. return j;
  214. }
  215. /**
  216. * 审批角色部门关联新增页面跳转
  217. *
  218. * @return
  219. */
  220. @RequestMapping(params = "goAdd")
  221. public ModelAndView goAdd(ProcessRoleDepartMapEntity processRoleDepartMap, HttpServletRequest req) {
  222. if (StringUtil.isNotEmpty(processRoleDepartMap.getId())) {
  223. processRoleDepartMap = processRoleDepartMapService.getEntity(ProcessRoleDepartMapEntity.class, processRoleDepartMap.getId());
  224. req.setAttribute("processRoleDepartMapPage", processRoleDepartMap);
  225. }
  226. return new ModelAndView("cn/com/lzt/process/roledepartmap/processRoleDepartMap-add");
  227. }
  228. /**
  229. * 审批角色部门关联编辑页面跳转
  230. *
  231. * @return
  232. */
  233. @RequestMapping(params = "goUpdate")
  234. public ModelAndView goUpdate(ProcessRoleDepartMapEntity processRoleDepartMap, HttpServletRequest req) {
  235. if (StringUtil.isNotEmpty(processRoleDepartMap.getId())) {
  236. processRoleDepartMap = processRoleDepartMapService.getEntity(ProcessRoleDepartMapEntity.class, processRoleDepartMap.getId());
  237. req.setAttribute("entity", processRoleDepartMap);
  238. }
  239. return new ModelAndView("cn/com/lzt/process/roledepartmap/processRoleDepartMap-add");
  240. }
  241. /**
  242. * 导入功能跳转
  243. *
  244. * @return
  245. */
  246. @RequestMapping(params = "upload")
  247. public ModelAndView upload(HttpServletRequest req) {
  248. req.setAttribute("controller_name","processRoleDepartMapController");
  249. return new ModelAndView("common/upload/pub_excel_upload");
  250. }
  251. /**
  252. * 导出excel
  253. *
  254. * @param request
  255. * @param response
  256. */
  257. @RequestMapping(params = "exportXls")
  258. public String exportXls(ProcessRoleDepartMapEntity processRoleDepartMap,HttpServletRequest request,HttpServletResponse response
  259. , DataGrid dataGrid,ModelMap modelMap) {
  260. CriteriaQuery cq = new CriteriaQuery(ProcessRoleDepartMapEntity.class, dataGrid);
  261. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, processRoleDepartMap, request.getParameterMap());
  262. List<ProcessRoleDepartMapEntity> processRoleDepartMaps = this.processRoleDepartMapService.getListByCriteriaQuery(cq,false);
  263. modelMap.put(NormalExcelConstants.FILE_NAME,"审批角色部门关联");
  264. modelMap.put(NormalExcelConstants.CLASS,ProcessRoleDepartMapEntity.class);
  265. modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("审批角色部门关联列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
  266. "导出信息"));
  267. modelMap.put(NormalExcelConstants.DATA_LIST,processRoleDepartMaps);
  268. return NormalExcelConstants.JEECG_EXCEL_VIEW;
  269. }
  270. /**
  271. * 导出excel 使模板
  272. *
  273. * @param request
  274. * @param response
  275. */
  276. @RequestMapping(params = "exportXlsByT")
  277. public String exportXlsByT(ProcessRoleDepartMapEntity processRoleDepartMap,HttpServletRequest request,HttpServletResponse response
  278. , DataGrid dataGrid,ModelMap modelMap) {
  279. modelMap.put(NormalExcelConstants.FILE_NAME,"审批角色部门关联");
  280. modelMap.put(NormalExcelConstants.CLASS,ProcessRoleDepartMapEntity.class);
  281. modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("审批角色部门关联列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
  282. "导出信息"));
  283. modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
  284. return NormalExcelConstants.JEECG_EXCEL_VIEW;
  285. }
  286. @SuppressWarnings("unchecked")
  287. @RequestMapping(params = "importExcel", method = RequestMethod.POST)
  288. @ResponseBody
  289. public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
  290. AjaxJson j = new AjaxJson();
  291. MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
  292. Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
  293. for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
  294. MultipartFile file = entity.getValue();// 获取上传文件对象
  295. ImportParams params = new ImportParams();
  296. params.setTitleRows(2);
  297. params.setHeadRows(1);
  298. params.setNeedSave(true);
  299. try {
  300. List<ProcessRoleDepartMapEntity> listProcessRoleDepartMapEntitys = ExcelImportUtil.importExcel(file.getInputStream(),ProcessRoleDepartMapEntity.class,params);
  301. for (ProcessRoleDepartMapEntity processRoleDepartMap : listProcessRoleDepartMapEntitys) {
  302. processRoleDepartMapService.save(processRoleDepartMap);
  303. }
  304. j.setMsg("文件导入成功!");
  305. } catch (Exception e) {
  306. j.setMsg("文件导入失败!");
  307. logger.error(ExceptionUtil.getExceptionMessage(e));
  308. }finally{
  309. try {
  310. file.getInputStream().close();
  311. } catch (IOException e) {
  312. e.printStackTrace();
  313. }
  314. }
  315. }
  316. return j;
  317. }
  318. @RequestMapping(method = RequestMethod.GET)
  319. @ResponseBody
  320. public List<ProcessRoleDepartMapEntity> list() {
  321. List<ProcessRoleDepartMapEntity> listProcessRoleDepartMaps=processRoleDepartMapService.getList(ProcessRoleDepartMapEntity.class);
  322. return listProcessRoleDepartMaps;
  323. }
  324. @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  325. @ResponseBody
  326. public ResponseEntity<?> get(@PathVariable("id") String id) {
  327. ProcessRoleDepartMapEntity task = processRoleDepartMapService.get(ProcessRoleDepartMapEntity.class, id);
  328. if (task == null) {
  329. return new ResponseEntity(HttpStatus.NOT_FOUND);
  330. }
  331. return new ResponseEntity(task, HttpStatus.OK);
  332. }
  333. @RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
  334. @ResponseBody
  335. public ResponseEntity<?> create(@RequestBody ProcessRoleDepartMapEntity processRoleDepartMap, UriComponentsBuilder uriBuilder) {
  336. //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
  337. Set<ConstraintViolation<ProcessRoleDepartMapEntity>> failures = validator.validate(processRoleDepartMap);
  338. if (!failures.isEmpty()) {
  339. return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
  340. }
  341. //保存
  342. try{
  343. processRoleDepartMapService.save(processRoleDepartMap);
  344. } catch (Exception e) {
  345. e.printStackTrace();
  346. return new ResponseEntity(HttpStatus.NO_CONTENT);
  347. }
  348. //按照Restful风格约定,创建指向新任务的url, 也可以直接返回id或对象.
  349. String id = processRoleDepartMap.getId();
  350. URI uri = uriBuilder.path("/rest/processRoleDepartMapController/" + id).build().toUri();
  351. HttpHeaders headers = new HttpHeaders();
  352. headers.setLocation(uri);
  353. return new ResponseEntity(headers, HttpStatus.CREATED);
  354. }
  355. @RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
  356. public ResponseEntity<?> update(@RequestBody ProcessRoleDepartMapEntity processRoleDepartMap) {
  357. //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
  358. Set<ConstraintViolation<ProcessRoleDepartMapEntity>> failures = validator.validate(processRoleDepartMap);
  359. if (!failures.isEmpty()) {
  360. return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
  361. }
  362. //保存
  363. try{
  364. processRoleDepartMapService.saveOrUpdate(processRoleDepartMap);
  365. } catch (Exception e) {
  366. e.printStackTrace();
  367. return new ResponseEntity(HttpStatus.NO_CONTENT);
  368. }
  369. //按Restful约定,返回204状态码, 无内容. 也可以返回200状态码.
  370. return new ResponseEntity(HttpStatus.NO_CONTENT);
  371. }
  372. @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
  373. @ResponseStatus(HttpStatus.NO_CONTENT)
  374. public void delete(@PathVariable("id") String id) {
  375. processRoleDepartMapService.deleteEntityById(ProcessRoleDepartMapEntity.class, id);
  376. }
  377. }