TalentSubsidyStrategyController.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406
  1. package cn.com.lzt.talentsubsidy.controller;
  2. import cn.com.lzt.talentsubsidy.entity.TalentSubsidyStrategyEntity;
  3. import cn.com.lzt.talentsubsidy.service.TalentSubsidyStrategyServiceI;
  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-10-23 10:14:27
  68. * @version V1.0
  69. *
  70. */
  71. @Controller
  72. @RequestMapping("/talentSubsidyStrategyController")
  73. public class TalentSubsidyStrategyController extends BaseController {
  74. /**
  75. * Logger for this class
  76. */
  77. private static final Logger logger = Logger.getLogger(TalentSubsidyStrategyController.class);
  78. @Autowired
  79. private TalentSubsidyStrategyServiceI talentSubsidyStrategyService;
  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/talentsubsidy/talentSubsidyStrategyList");
  92. }
  93. /**
  94. * easyui AJAX请求数据
  95. *
  96. * @param request
  97. * @param response
  98. * @param dataGrid
  99. * @param user
  100. */
  101. @RequestMapping(params = "datagrid")
  102. public void datagrid(TalentSubsidyStrategyEntity talentSubsidyStrategy,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
  103. CriteriaQuery cq = new CriteriaQuery(TalentSubsidyStrategyEntity.class, dataGrid);
  104. //查询条件组装器
  105. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, talentSubsidyStrategy, request.getParameterMap());
  106. try{
  107. //自定义追加查询条件
  108. }catch (Exception e) {
  109. throw new BusinessException(e.getMessage());
  110. }
  111. cq.add();
  112. this.talentSubsidyStrategyService.getDataGridReturn(cq, true);
  113. TagUtil.datagrid(response, dataGrid);
  114. }
  115. /**
  116. * 删除公司级人才津贴设定
  117. *
  118. * @return
  119. */
  120. @RequestMapping(params = "doDel")
  121. @ResponseBody
  122. public AjaxJson doDel(TalentSubsidyStrategyEntity talentSubsidyStrategy, HttpServletRequest request) {
  123. String message = null;
  124. AjaxJson j = new AjaxJson();
  125. talentSubsidyStrategy = systemService.getEntity(TalentSubsidyStrategyEntity.class, talentSubsidyStrategy.getId());
  126. message = "公司级人才津贴设定删除成功";
  127. try{
  128. talentSubsidyStrategyService.delete(talentSubsidyStrategy);
  129. systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
  130. }catch(Exception e){
  131. e.printStackTrace();
  132. message = "公司级人才津贴设定删除失败";
  133. throw new BusinessException(e.getMessage());
  134. }
  135. j.setMsg(message);
  136. return j;
  137. }
  138. /**
  139. * 批量删除公司级人才津贴设定
  140. *
  141. * @return
  142. */
  143. @RequestMapping(params = "doBatchDel")
  144. @ResponseBody
  145. public AjaxJson doBatchDel(String ids,HttpServletRequest request){
  146. String message = null;
  147. AjaxJson j = new AjaxJson();
  148. message = "公司级人才津贴设定删除成功";
  149. try{
  150. for(String id:ids.split(",")){
  151. TalentSubsidyStrategyEntity talentSubsidyStrategy = systemService.getEntity(TalentSubsidyStrategyEntity.class,
  152. id);
  153. talentSubsidyStrategyService.delete(talentSubsidyStrategy);
  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. * @param ids
  168. * @return
  169. */
  170. @RequestMapping(params = "doAdd")
  171. @ResponseBody
  172. public AjaxJson doAdd(TalentSubsidyStrategyEntity talentSubsidyStrategy, HttpServletRequest request) {
  173. String message = null;
  174. AjaxJson j = new AjaxJson();
  175. message = "公司级人才津贴设定添加成功";
  176. try{
  177. talentSubsidyStrategy.setDeleteFlag("0");
  178. talentSubsidyStrategyService.save(talentSubsidyStrategy);
  179. systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
  180. }catch(Exception e){
  181. e.printStackTrace();
  182. message = "公司级人才津贴设定添加失败";
  183. throw new BusinessException(e.getMessage());
  184. }
  185. j.setMsg(message);
  186. return j;
  187. }
  188. /**
  189. * 更新公司级人才津贴设定
  190. *
  191. * @param ids
  192. * @return
  193. */
  194. @RequestMapping(params = "doUpdate")
  195. @ResponseBody
  196. public AjaxJson doUpdate(TalentSubsidyStrategyEntity talentSubsidyStrategy, HttpServletRequest request) {
  197. String message = null;
  198. AjaxJson j = new AjaxJson();
  199. message = "公司级人才津贴设定更新成功";
  200. TalentSubsidyStrategyEntity t = talentSubsidyStrategyService.get(TalentSubsidyStrategyEntity.class, talentSubsidyStrategy.getId());
  201. try {
  202. MyBeanUtils.copyBeanNotNull2Bean(talentSubsidyStrategy, t);
  203. talentSubsidyStrategyService.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(TalentSubsidyStrategyEntity talentSubsidyStrategy, HttpServletRequest req) {
  220. if (StringUtil.isNotEmpty(talentSubsidyStrategy.getId())) {
  221. talentSubsidyStrategy = talentSubsidyStrategyService.getEntity(TalentSubsidyStrategyEntity.class, talentSubsidyStrategy.getId());
  222. req.setAttribute("talentSubsidyStrategyPage", talentSubsidyStrategy);
  223. }
  224. return new ModelAndView("cn/com/lzt/talentsubsidy/talentSubsidyStrategy-add");
  225. }
  226. /**
  227. * 公司级人才津贴设定编辑页面跳转
  228. *
  229. * @return
  230. */
  231. @RequestMapping(params = "goUpdate")
  232. public ModelAndView goUpdate(TalentSubsidyStrategyEntity talentSubsidyStrategy, HttpServletRequest req) {
  233. if (StringUtil.isNotEmpty(talentSubsidyStrategy.getId())) {
  234. talentSubsidyStrategy = talentSubsidyStrategyService.getEntity(TalentSubsidyStrategyEntity.class, talentSubsidyStrategy.getId());
  235. req.setAttribute("talentSubsidyStrategyPage", talentSubsidyStrategy);
  236. }
  237. return new ModelAndView("cn/com/lzt/talentsubsidy/talentSubsidyStrategy-update");
  238. }
  239. /**
  240. * 导入功能跳转
  241. *
  242. * @return
  243. */
  244. @RequestMapping(params = "upload")
  245. public ModelAndView upload(HttpServletRequest req) {
  246. req.setAttribute("controller_name","talentSubsidyStrategyController");
  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(TalentSubsidyStrategyEntity talentSubsidyStrategy,HttpServletRequest request,HttpServletResponse response
  257. , DataGrid dataGrid,ModelMap modelMap) {
  258. CriteriaQuery cq = new CriteriaQuery(TalentSubsidyStrategyEntity.class, dataGrid);
  259. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, talentSubsidyStrategy, request.getParameterMap());
  260. List<TalentSubsidyStrategyEntity> talentSubsidyStrategys = this.talentSubsidyStrategyService.getListByCriteriaQuery(cq,false);
  261. modelMap.put(NormalExcelConstants.FILE_NAME,"公司级人才津贴设定");
  262. modelMap.put(NormalExcelConstants.CLASS,TalentSubsidyStrategyEntity.class);
  263. modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("公司级人才津贴设定列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
  264. "导出信息"));
  265. modelMap.put(NormalExcelConstants.DATA_LIST,talentSubsidyStrategys);
  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(TalentSubsidyStrategyEntity talentSubsidyStrategy,HttpServletRequest request,HttpServletResponse response
  276. , DataGrid dataGrid,ModelMap modelMap) {
  277. modelMap.put(NormalExcelConstants.FILE_NAME,"公司级人才津贴设定");
  278. modelMap.put(NormalExcelConstants.CLASS,TalentSubsidyStrategyEntity.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<TalentSubsidyStrategyEntity> listTalentSubsidyStrategyEntitys = ExcelImportUtil.importExcel(file.getInputStream(),TalentSubsidyStrategyEntity.class,params);
  299. for (TalentSubsidyStrategyEntity talentSubsidyStrategy : listTalentSubsidyStrategyEntitys) {
  300. talentSubsidyStrategyService.save(talentSubsidyStrategy);
  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<TalentSubsidyStrategyEntity> list() {
  319. List<TalentSubsidyStrategyEntity> listTalentSubsidyStrategys=talentSubsidyStrategyService.getList(TalentSubsidyStrategyEntity.class);
  320. return listTalentSubsidyStrategys;
  321. }
  322. @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  323. @ResponseBody
  324. public ResponseEntity<?> get(@PathVariable("id") String id) {
  325. TalentSubsidyStrategyEntity task = talentSubsidyStrategyService.get(TalentSubsidyStrategyEntity.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 TalentSubsidyStrategyEntity talentSubsidyStrategy, UriComponentsBuilder uriBuilder) {
  334. //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
  335. Set<ConstraintViolation<TalentSubsidyStrategyEntity>> failures = validator.validate(talentSubsidyStrategy);
  336. if (!failures.isEmpty()) {
  337. return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
  338. }
  339. //保存
  340. try{
  341. talentSubsidyStrategyService.save(talentSubsidyStrategy);
  342. } catch (Exception e) {
  343. e.printStackTrace();
  344. return new ResponseEntity(HttpStatus.NO_CONTENT);
  345. }
  346. //按照Restful风格约定,创建指向新任务的url, 也可以直接返回id或对象.
  347. String id = talentSubsidyStrategy.getId();
  348. URI uri = uriBuilder.path("/rest/talentSubsidyStrategyController/" + 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 TalentSubsidyStrategyEntity talentSubsidyStrategy) {
  355. //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
  356. Set<ConstraintViolation<TalentSubsidyStrategyEntity>> failures = validator.validate(talentSubsidyStrategy);
  357. if (!failures.isEmpty()) {
  358. return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
  359. }
  360. //保存
  361. try{
  362. talentSubsidyStrategyService.saveOrUpdate(talentSubsidyStrategy);
  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. talentSubsidyStrategyService.deleteEntityById(TalentSubsidyStrategyEntity.class, id);
  374. }
  375. }