TBActivitiUserOtherController.java 18 KB

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