MMessageTemplateController.java 14 KB

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