TBusBaseWagestrategyController.java 14 KB

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