BudgetDimFunctionDetailController.java 16 KB

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