PartyTwoController.java 58 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312
  1. package com.ghsc.partybuild.controller;
  2. import com.fasterxml.jackson.core.type.TypeReference;
  3. import com.fasterxml.jackson.databind.ObjectMapper;
  4. import com.github.pagehelper.PageInfo;
  5. import com.ghsc.partybuild.controller.jsonmodel.RequsetData;
  6. import com.ghsc.partybuild.model.*;
  7. import com.ghsc.partybuild.service.PartyService;
  8. import com.ghsc.partybuild.service.PartyTwoService;
  9. import com.ghsc.partybuild.service.UserService;
  10. import com.ghsc.partybuild.util.*;
  11. import com.ghsc.partybuild.vo.*;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.web.bind.annotation.*;
  14. import javax.servlet.http.HttpServletResponse;
  15. import java.math.BigDecimal;
  16. import java.util.*;
  17. @RestController
  18. @RequestMapping(value = "/api/partyTowExt")
  19. public class PartyTwoController {
  20. @Autowired
  21. private PartyTwoService partyTwoService;
  22. @Autowired
  23. private MapUtils mapUtils;
  24. @Autowired
  25. private StringUtils stringUtils;
  26. @Autowired
  27. private DateUtils dateUtils;
  28. @Autowired
  29. private UserService userService;
  30. @Autowired
  31. private PartyService partyService;
  32. @ResponseBody
  33. @GetMapping("/getDnpxxxList")
  34. public RequsetData<PageInfo<HashMap<String, Object>>> getDnpxxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  35. @RequestParam(required = false) String dzzmc,
  36. @RequestParam(required = false) String dzzdm,
  37. @RequestParam(required = false) String username,
  38. @RequestParam(required = false) String rybm,
  39. @RequestParam(required = false) Integer honourLevel,
  40. @RequestParam(required = false) String honourName,
  41. @RequestParam(required = false) String beginTime,
  42. @RequestParam(required = false) String endTime,
  43. @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) Integer pxlx, @RequestParam(required = false) String ssdzzdm ,@RequestParam(required = false)Integer honourType) {
  44. beginTime = dateUtils.strFormat_short(beginTime);
  45. endTime = dateUtils.strFormat_short(endTime);
  46. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  47. result.setItem(partyTwoService.getDnpxxxList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, honourLevel, honourName, beginTime, endTime, zzfbType, pxlx, ssdzzdm,honourType));
  48. return result;
  49. }
  50. @ResponseBody
  51. @RequestMapping("/getDnpxxx")
  52. public RequsetData<DjDnpxxx> getDnpxxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc, @RequestParam(required = false) String pxlx) {
  53. RequsetData<DjDnpxxx> res = new RequsetData<>();
  54. DjDnpxxx model = partyTwoService.getDnpxxx(id);
  55. if (model == null) {
  56. UUID uuid = UUID.randomUUID();
  57. model = new DjDnpxxx();
  58. model.setId(uuid.toString());
  59. model.setDzzdm(dzzdm);
  60. model.setDzzmc(dzzmc);
  61. model.setPxlx(pxlx);
  62. model.setIscommend(0);
  63. } else {
  64. List<DjDnpxry> rylist = partyTwoService.getDnpxryList(model.getId());
  65. Map<String, Object> extdata = new HashMap<>(10);
  66. /* List<String> userid = new ArrayList<>();
  67. List<String> username = new ArrayList<>();
  68. for (DjDnpxry ry : rylist) {
  69. userid.add(ry.getUserid());
  70. username.add(ry.getUsername());
  71. }
  72. extdata.put("userid", String.join(",", userid));
  73. extdata.put("username", String.join(",", username));*/
  74. res.setExtdata(extdata);
  75. }
  76. res.setItem(model);
  77. return res;
  78. }
  79. @ResponseBody
  80. @RequestMapping("/saveDnpxxx")
  81. public RequsetData<String> saveDnpxxx(@RequestBody Map<String, Object> reqMap) {
  82. ObjectMapper mapper = new ObjectMapper();
  83. RequsetData<String> res = new RequsetData<String>();
  84. try {
  85. DjDnpxxx model = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjDnpxxx.class);
  86. UserItemVo[] recordList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<UserItemVo[]>() {
  87. });
  88. res = partyTwoService.saveDnpxxx(model, recordList);
  89. } catch (Exception e) {
  90. e.printStackTrace();
  91. }
  92. return res;
  93. }
  94. @ResponseBody
  95. @GetMapping("/delDnpxxx")
  96. public RequsetData<Integer> delDnpxxx(@RequestParam("id") String id, @RequestParam(required = false) String userid) {
  97. RequsetData<Integer> result = new RequsetData<>();
  98. int row = partyTwoService.delDnpxxx(id, userid);
  99. result.setItem(row);
  100. if (row == 0) {
  101. result.setSuccess(false);
  102. result.setMsg("删除失败!");
  103. } else {
  104. result.setMsg("删除成功!");
  105. }
  106. return result;
  107. }
  108. @RequestMapping(value = "/exportDnpxxx", method = RequestMethod.GET)
  109. public void exportDnpxxx(HttpServletResponse response,
  110. @RequestParam(required = false) String dzzmc,
  111. @RequestParam(required = false) String dzzdm,
  112. @RequestParam(required = false) String username,
  113. @RequestParam(required = false) String rybm,
  114. @RequestParam(required = false) Integer honourLevel,
  115. @RequestParam(required = false) String honourName,
  116. @RequestParam(required = false) String beginTime,
  117. @RequestParam(required = false) String endTime,
  118. @RequestParam(required = false) Integer zzfbType,
  119. @RequestParam(required = false) Integer pxlx) throws Exception {
  120. beginTime = dateUtils.strFormat_short(beginTime);
  121. endTime = dateUtils.strFormat_short(endTime);
  122. /**查询数据**/
  123. List<HashMap<String, Object>> dataList = partyTwoService.getDnpxxxList(1, 100000, dzzdm, dzzmc, username, rybm, honourLevel, honourName, beginTime, endTime, zzfbType, pxlx, null,null).getList();
  124. ExcelHelper excelHelper = new ExcelHelper();
  125. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  126. //列名
  127. data.setName("党内评先信息");
  128. List<String> titles = new ArrayList();
  129. titles.add("荣誉名称");
  130. //titles.add("评先类型");
  131. if (pxlx == 1) {
  132. titles.add("姓名");
  133. }
  134. titles.add("所属党组织");
  135. titles.add("获得荣誉时间");
  136. titles.add("等级");
  137. titles.add("荣誉类型");
  138. data.setTitles(titles);
  139. //数据
  140. List<List<Object>> rows = new ArrayList();
  141. for (HashMap<String, Object> item : dataList) {
  142. List<Object> row = new ArrayList();
  143. row.add(item.get("HONOURNAME"));
  144. //row.add("1".equals((String) item.get("PXLX")) ? "个人" : "组织");
  145. if (pxlx == 1) {
  146. row.add(item.get("USERNAME"));
  147. }
  148. row.add(item.get("DZZMC"));
  149. row.add(dateUtils.strFormat(item.get("HONOURTIME").toString()));
  150. row.add(item.get("LEVELNAME"));
  151. row.add(item.get("HONOURTYPENAME"));
  152. rows.add(row);
  153. }
  154. data.setRows(rows);
  155. excelHelper.exportExcel(response, "党内评先信息.xlsx", data);
  156. }
  157. @ResponseBody
  158. @RequestMapping("/saveDnghbf")
  159. public RequsetData<String> saveDnghbf(@RequestBody Map<String, Object> reqMap) {
  160. RequsetData<String> res = new RequsetData<String>();
  161. int count = 0;
  162. String message = "";
  163. ObjectMapper mapper = new ObjectMapper();
  164. try {
  165. DjDnghbf dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjDnghbf.class);
  166. List<DjDnghbfmx> recordList = JsonMapper.jsonToObject(reqMap.get("recordList").toString(), new TypeReference<List<DjDnghbfmx>>() {
  167. });
  168. count = partyTwoService.saveDnghbf(dataModel, recordList, userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
  169. } catch (Exception e) {
  170. e.printStackTrace();
  171. message = e.getMessage();
  172. }
  173. if (count > 0) {
  174. res.setSuccess(true);
  175. res.setMsg("操作成功!");
  176. } else {
  177. res.setSuccess(false);
  178. res.setMsg("操作失败!" + message);
  179. }
  180. return res;
  181. }
  182. @ResponseBody
  183. @RequestMapping("/saveDnghbfmx")
  184. public RequsetData<String> saveDnghbfmx(@RequestBody DjDnghbfmx bfmx) {
  185. RequsetData<String> res = new RequsetData<String>();
  186. int count = 0;
  187. count = partyTwoService.saveDnghbfmx(bfmx);
  188. if (count > 0) {
  189. res.setSuccess(true);
  190. res.setMsg("操作成功!");
  191. } else {
  192. res.setSuccess(false);
  193. res.setMsg("操作失败!");
  194. }
  195. return res;
  196. }
  197. @ResponseBody
  198. @RequestMapping("/getDnghbf")
  199. public RequsetData<DjDnghbf> getDnghbf(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
  200. RequsetData<DjDnghbf> res = new RequsetData<>();
  201. DjDnghbf model = partyTwoService.getDnghbf(id);
  202. if (model == null) {
  203. UUID uuid = UUID.randomUUID();
  204. model = new DjDnghbf();
  205. model.setId(uuid.toString());
  206. model.setDzzdm(dzzdm);
  207. model.setDzzmc(dzzmc);
  208. }
  209. res.setItem(model);
  210. return res;
  211. }
  212. @ResponseBody
  213. @GetMapping("/getDnghbfList")
  214. public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  215. @RequestParam(required = false) String dzzmc,
  216. @RequestParam(required = false) String dzzdm,
  217. @RequestParam(required = false) String username,
  218. @RequestParam(required = false) String rybm,
  219. @RequestParam(required = false) Integer careType,
  220. @RequestParam(required = false) Integer zzfbType,
  221. @RequestParam(required = false) String beginTime,
  222. @RequestParam(required = false) String endTime,
  223. @RequestParam(required = false) Integer helpformType) {
  224. beginTime = dateUtils.strFormat_short(beginTime);
  225. endTime = dateUtils.strFormat_short(endTime);
  226. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  227. result.setItem(partyTwoService.getDnghbfList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, careType, zzfbType, beginTime, endTime, helpformType));
  228. return result;
  229. }
  230. @ResponseBody
  231. @GetMapping("/getDnghbfDetailsList")
  232. public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfDetailsList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  233. @RequestParam(required = false) String dzzmc,
  234. @RequestParam(required = false) String dzzdm,
  235. @RequestParam(required = false) String username,
  236. @RequestParam(required = false) String rybm,
  237. @RequestParam(required = false) Integer careType,
  238. @RequestParam(required = false) Integer zzfbType) {
  239. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  240. result.setItem(partyTwoService.getDnghbfDetailsList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, careType, zzfbType));
  241. return result;
  242. }
  243. @ResponseBody
  244. @GetMapping("/getDnghbfmxList")
  245. public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfmxList(
  246. @RequestParam(required = false) String dnghbId) {
  247. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  248. result.setItem(partyTwoService.getDnghbfmxList(1, 10000, dnghbId));
  249. return result;
  250. }
  251. @ResponseBody
  252. @GetMapping("/delDnghbf")
  253. public RequsetData<Integer> delDnghbf(@RequestParam("id") String id, @RequestParam(required = false) String ghmxid) {
  254. RequsetData<Integer> result = new RequsetData<>();
  255. int row = partyTwoService.delDnghbf(id, ghmxid);
  256. result.setItem(row);
  257. if (row == 0) {
  258. result.setSuccess(false);
  259. result.setMsg("删除失败!");
  260. } else {
  261. result.setMsg("删除成功!");
  262. }
  263. return result;
  264. }
  265. @RequestMapping(value = "/exportDnghbf", method = RequestMethod.GET)
  266. public void exportDnghbf(HttpServletResponse response,
  267. @RequestParam(required = false) String dzzmc,
  268. @RequestParam(required = false) String dzzdm,
  269. @RequestParam(required = false) String username,
  270. @RequestParam(required = false) String rybm,
  271. @RequestParam(required = false) Integer careType,
  272. @RequestParam(required = false) Integer zzfbType,
  273. @RequestParam(required = false) String beginTime,
  274. @RequestParam(required = false) String endTime,
  275. @RequestParam(required = false) Integer helpformType) throws Exception {
  276. beginTime = dateUtils.strFormat_short(beginTime);
  277. endTime = dateUtils.strFormat_short(endTime);
  278. /**查询数据**/
  279. List<HashMap<String, Object>> dataList = partyTwoService.getDnghbfList(1, 100000, dzzdm, dzzmc, username, rybm, careType, zzfbType, beginTime, endTime, helpformType).getList();
  280. ExcelHelper excelHelper = new ExcelHelper();
  281. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  282. //列名
  283. data.setName("党内评先信息");
  284. List<String> titles = new ArrayList();
  285. titles.add("姓名");
  286. titles.add("所属党支部");
  287. titles.add("帮扶时间");
  288. titles.add("帮扶形式");
  289. titles.add("慰问金额");
  290. data.setTitles(titles);
  291. //数据
  292. List<List<Object>> rows = new ArrayList();
  293. for (HashMap<String, Object> item : dataList) {
  294. List<Object> row = new ArrayList();
  295. row.add(item.get("USERNAME"));
  296. row.add(item.get("SZDZZMC"));
  297. row.add(dateUtils.strFormat(item.get("CAREDATE").toString()));
  298. row.add(item.get("HELPFORMTYPENAME"));
  299. row.add(item.get("AMOUNT"));
  300. rows.add(row);
  301. }
  302. data.setRows(rows);
  303. excelHelper.exportExcel(response, "党内关怀帮扶.xlsx", data);
  304. }
  305. @ResponseBody
  306. @GetMapping("/getZtdrxxList")
  307. public RequsetData<PageInfo<DjZtdrxxVo>> getZtdrxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  308. @RequestParam(required = false) String dzzmc,
  309. @RequestParam(required = false) String dzzdm,
  310. @RequestParam(required = false) String title,
  311. @RequestParam(required = false) Integer subjectType,
  312. @RequestParam(required = false) String location,
  313. @RequestParam(required = false) String beginTime,
  314. @RequestParam(required = false) String endTime,
  315. @RequestParam(required = false) Integer zzfbType) {
  316. beginTime = dateUtils.strFormat_short(beginTime);
  317. endTime = dateUtils.strFormat_short(endTime);
  318. RequsetData<PageInfo<DjZtdrxxVo>> result = new RequsetData<>();
  319. result.setItem(partyTwoService.getZtdrxxList(pageIndex, pageSize, dzzdm, dzzmc, title, subjectType, location, beginTime, endTime, zzfbType));
  320. return result;
  321. }
  322. @ResponseBody
  323. @RequestMapping("/getZtdrxx")
  324. public RequsetData<DjZtdrxx> getZtdrxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
  325. RequsetData<DjZtdrxx> res = new RequsetData<>();
  326. DjZtdrxx model = partyTwoService.getZtdrxx(id);
  327. if (model == null) {
  328. UUID uuid = UUID.randomUUID();
  329. model = new DjZtdrxx();
  330. model.setId(uuid.toString());
  331. model.setDzzdm(dzzdm);
  332. model.setDzzmc(dzzmc);
  333. }
  334. res.setItem(model);
  335. return res;
  336. }
  337. @ResponseBody
  338. @RequestMapping("/saveZtdrxx")
  339. public RequsetData<String> saveZtdrxx(@RequestBody DjZtdrxx model) {
  340. RequsetData<String> res = partyTwoService.saveZtdrxx(model);
  341. return res;
  342. }
  343. @ResponseBody
  344. @GetMapping("/delZtdrxx")
  345. public RequsetData<Integer> delZtdrxx(@RequestParam("id") String id) {
  346. RequsetData<Integer> result = new RequsetData<>();
  347. int row = partyTwoService.delZtdrxx(id);
  348. result.setItem(row);
  349. if (row == 0) {
  350. result.setSuccess(false);
  351. result.setMsg("删除失败!");
  352. } else {
  353. result.setMsg("删除成功!");
  354. }
  355. return result;
  356. }
  357. @RequestMapping(value = "/exportZtdrxx", method = RequestMethod.GET)
  358. public void exportZtdrxx(HttpServletResponse response,
  359. @RequestParam(required = false) String dzzmc,
  360. @RequestParam(required = false) String dzzdm,
  361. @RequestParam(required = false) String username,
  362. @RequestParam(required = false) Integer honourLevel,
  363. @RequestParam(required = false) String honourName,
  364. @RequestParam(required = false) String beginTime,
  365. @RequestParam(required = false) String endTime,
  366. @RequestParam(required = false) Integer zzfbType) throws Exception {
  367. beginTime = dateUtils.strFormat_short(beginTime);
  368. endTime = dateUtils.strFormat_short(endTime);
  369. /**查询数据**/
  370. List<DjZtdrxxVo> dataList = partyTwoService.getZtdrxxList(1, 100000, dzzdm, dzzmc, username, honourLevel, honourName, beginTime, endTime, zzfbType).getList();
  371. ExcelHelper excelHelper = new ExcelHelper();
  372. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  373. //列名
  374. data.setName("主题党日信息");
  375. List<String> titles = new ArrayList();
  376. titles.add("所属党组织");
  377. titles.add("时间");
  378. titles.add("地点");
  379. titles.add("主题");
  380. titles.add("内容");
  381. titles.add("类别");
  382. data.setTitles(titles);
  383. //数据
  384. List<List<Object>> rows = new ArrayList();
  385. for (DjZtdrxxVo item : dataList) {
  386. List<Object> row = new ArrayList();
  387. row.add(item.getDzzmc());
  388. row.add(dateUtils.strFormat_short(item.getActivitytime().toString()));
  389. row.add(item.getLocation());
  390. row.add(item.getTitle());
  391. row.add(item.getSubjectcontent());
  392. row.add(item.getSubjecttypename());
  393. rows.add(row);
  394. }
  395. data.setRows(rows);
  396. excelHelper.exportExcel(response, "主题党日信息.xlsx", data);
  397. }
  398. @ResponseBody
  399. @GetMapping("/getZzsrList")
  400. public RequsetData<PageInfo<DjZzsrVo>> getZzsrList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  401. @RequestParam(required = false) String dzzmc,
  402. @RequestParam(required = false) String dzzdm,
  403. @RequestParam(required = false) String title,
  404. @RequestParam(required = false) Integer subjectType,
  405. @RequestParam(required = false) String location,
  406. @RequestParam(required = false) String beginTime,
  407. @RequestParam(required = false) String endTime,
  408. @RequestParam(required = false) Integer zzfbType) {
  409. beginTime = dateUtils.strFormat_short(beginTime);
  410. endTime = dateUtils.strFormat_short(endTime);
  411. RequsetData<PageInfo<DjZzsrVo>> result = new RequsetData<>();
  412. result.setItem(partyTwoService.getZzsrList(pageIndex, pageSize, dzzdm, dzzmc, title, subjectType, location, beginTime, endTime, zzfbType));
  413. return result;
  414. }
  415. @ResponseBody
  416. @RequestMapping("/getZzsr")
  417. public RequsetData<DjZzsr> getZzsr(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
  418. RequsetData<DjZzsr> res = new RequsetData<>();
  419. DjZzsr model = partyTwoService.getZzsr(id);
  420. if (model == null) {
  421. UUID uuid = UUID.randomUUID();
  422. model = new DjZzsr();
  423. model.setId(uuid.toString());
  424. model.setDzzdm(dzzdm);
  425. model.setDzzmc(dzzmc);
  426. }
  427. res.setItem(model);
  428. return res;
  429. }
  430. @ResponseBody
  431. @RequestMapping("/saveZzsr")
  432. public RequsetData<String> saveZzsr(@RequestBody DjZzsr model) {
  433. RequsetData<String> res = partyTwoService.saveZzsr(model);
  434. return res;
  435. }
  436. @ResponseBody
  437. @GetMapping("/delZzsr")
  438. public RequsetData<Integer> delZzsr(@RequestParam("id") String id) {
  439. RequsetData<Integer> result = new RequsetData<>();
  440. int row = partyTwoService.delZzsr(id);
  441. result.setItem(row);
  442. if (row == 0) {
  443. result.setSuccess(false);
  444. result.setMsg("删除失败!");
  445. } else {
  446. result.setMsg("删除成功!");
  447. }
  448. return result;
  449. }
  450. @RequestMapping(value = "/exportZzsr", method = RequestMethod.GET)
  451. public void exportZzsr(HttpServletResponse response,
  452. @RequestParam(required = false) String dzzmc,
  453. @RequestParam(required = false) String dzzdm,
  454. @RequestParam(required = false) String username,
  455. @RequestParam(required = false) Integer honourLevel,
  456. @RequestParam(required = false) String honourName,
  457. @RequestParam(required = false) String beginTime,
  458. @RequestParam(required = false) String endTime,
  459. @RequestParam(required = false) Integer zzfbType) throws Exception {
  460. beginTime = dateUtils.strFormat_short(beginTime);
  461. endTime = dateUtils.strFormat_short(endTime);
  462. /**查询数据**/
  463. List<DjZzsrVo> dataList = partyTwoService.getZzsrList(1, 100000, dzzdm, dzzmc, username, honourLevel, honourName, beginTime, endTime, zzfbType).getList();
  464. ExcelHelper excelHelper = new ExcelHelper();
  465. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  466. //列名
  467. data.setName("政治生日信息");
  468. List<String> titles = new ArrayList();
  469. titles.add("所属党组织");
  470. titles.add("时间");
  471. titles.add("地点");
  472. titles.add("主题");
  473. titles.add("内容");
  474. titles.add("类别");
  475. data.setTitles(titles);
  476. //数据
  477. List<List<Object>> rows = new ArrayList();
  478. for (DjZzsrVo item : dataList) {
  479. List<Object> row = new ArrayList();
  480. row.add(item.getDzzmc());
  481. row.add(dateUtils.strFormat_short(item.getActivitytime().toString()));
  482. row.add(item.getLocation());
  483. row.add(item.getTitle());
  484. row.add(item.getSubjectcontent());
  485. row.add(item.getSubjecttypename());
  486. rows.add(row);
  487. }
  488. data.setRows(rows);
  489. excelHelper.exportExcel(response, "政治生日信息.xlsx", data);
  490. }
  491. @ResponseBody
  492. @GetMapping("/getParyDjkpList")
  493. public RequsetData<PageInfo<HashMap<String, Object>>> getParyDjkpList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam(required = false) String dzzdm,
  494. @RequestParam(required = false) String selectdzzmc,
  495. @RequestParam(required = false) Integer year,
  496. @RequestParam(required = false) Integer showdxz,
  497. @RequestParam(required = false) Integer showdw,
  498. @RequestParam(required = false) Integer showdzb,
  499. @RequestParam(required = false) String selectdzzdm) {
  500. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  501. List<String> selectdzzdmList = new ArrayList<>();
  502. if (!stringUtils.IsNullOrEmpty(selectdzzdm)) {
  503. selectdzzdmList = Arrays.asList(selectdzzdm.split(","));
  504. }
  505. result.setItem(partyTwoService.getParyDjkpList(pageIndex, pageSize, dzzdm,selectdzzmc, showdxz, year, showdw,showdzb,selectdzzdmList));
  506. return result;
  507. }
  508. @ResponseBody
  509. @GetMapping("/getDjkpxxList")
  510. public RequsetData<PageInfo<HashMap<String, Object>>> getDjkpxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  511. @RequestParam(required = false) String dzzmc,
  512. @RequestParam(required = false) String dzzdm,
  513. @RequestParam(required = false) Integer year,
  514. @RequestParam(required = false) Integer judgeLevel,
  515. @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) String ssdzzdm,
  516. @RequestParam(required = false) Integer showdw) {
  517. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  518. result.setItem(partyTwoService.getDjkpxxList(pageIndex, pageSize, dzzdm, dzzmc, judgeLevel, year, zzfbType, ssdzzdm, showdw));
  519. return result;
  520. }
  521. @ResponseBody
  522. @RequestMapping("/getDjkpxx")
  523. public RequsetData<DjDjkpxx> getDjkpxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
  524. RequsetData<DjDjkpxx> res = new RequsetData<>();
  525. DjDjkpxx model = partyTwoService.getDjkpxx(id);
  526. if (model == null) {
  527. UUID uuid = UUID.randomUUID();
  528. model = new DjDjkpxx();
  529. model.setId(uuid.toString());
  530. model.setDzzdm(dzzdm);
  531. model.setDzzmc(dzzmc);
  532. }
  533. res.setItem(model);
  534. return res;
  535. }
  536. @ResponseBody
  537. @RequestMapping("/saveDjkpxx")
  538. public RequsetData<String> saveDjkpxx(@RequestBody DjDjkpxx model) {
  539. RequsetData<String> res = partyTwoService.saveDjkpxx(model);
  540. return res;
  541. }
  542. @ResponseBody
  543. @RequestMapping("/saveDjkpxxByList")
  544. public RequsetData<String> saveDjkpxxByList(@RequestBody Map<String, Object> reqMap) {
  545. RequsetData<String> res = new RequsetData<String>();
  546. int count = 0;
  547. String message = "";
  548. try {
  549. List<DjDjkpxx> dataList = JsonMapper.jsonToObject(reqMap.get("dataList").toString(), new TypeReference<List<DjDjkpxx>>() {
  550. });
  551. count = partyTwoService.saveDjkpxxByList(dataList, userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
  552. } catch (Exception e) {
  553. e.printStackTrace();
  554. message = e.getMessage();
  555. }
  556. if (count > 0) {
  557. res.setSuccess(true);
  558. res.setMsg("操作成功!");
  559. } else {
  560. res.setSuccess(false);
  561. res.setMsg("操作失败!" + message);
  562. }
  563. return res;
  564. }
  565. @ResponseBody
  566. @GetMapping("/delDjkpxx")
  567. public RequsetData<Integer> delDjkpxx(@RequestParam("id") String id) {
  568. RequsetData<Integer> result = new RequsetData<>();
  569. int row = partyTwoService.delDjkpxx(id);
  570. result.setItem(row);
  571. if (row == 0) {
  572. result.setSuccess(false);
  573. result.setMsg("删除失败!");
  574. } else {
  575. result.setMsg("删除成功!");
  576. }
  577. return result;
  578. }
  579. @RequestMapping(value = "/exportDjkpxx", method = RequestMethod.GET)
  580. public void exportDjkpxx(HttpServletResponse response,
  581. @RequestParam(required = false) String dzzmc,
  582. @RequestParam(required = false) String dzzdm,
  583. @RequestParam(required = false) Integer year,
  584. @RequestParam(required = false) Integer judgeLevel,
  585. @RequestParam(required = false) Integer zzfbType,
  586. @RequestParam(required = false) Integer showdw) throws Exception {
  587. /**查询数据**/
  588. List<HashMap<String, Object>> dataList = partyTwoService.getDjkpxxList(1, 100000, dzzdm, dzzmc, year, judgeLevel, zzfbType, null, showdw).getList();
  589. ExcelHelper excelHelper = new ExcelHelper();
  590. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  591. //列名
  592. data.setName("党建考评信息");
  593. List<String> titles = new ArrayList();
  594. titles.add("所属党组织");
  595. titles.add("年度");
  596. titles.add("第一季度评分");
  597. titles.add("第二季度评分");
  598. titles.add("第三季度评分");
  599. titles.add("第四季度评分");
  600. /* if (showdw == 1) {
  601. titles.add("年度评分");
  602. }*/
  603. titles.add("评定等级");
  604. data.setTitles(titles);
  605. //数据
  606. List<List<Object>> rows = new ArrayList();
  607. for (HashMap<String, Object> item : dataList) {
  608. List<Object> row = new ArrayList();
  609. row.add(item.get("DZZMC"));
  610. row.add(item.get("YEAR"));
  611. row.add(item.get("QUARTER1"));
  612. row.add(item.get("QUARTER2"));
  613. row.add(item.get("QUARTER3"));
  614. row.add(item.get("QUARTER4"));
  615. /* if (showdw == 1) {
  616. row.add(item.get("ANNUALSCORE"));
  617. }*/
  618. row.add(item.get("JUDGELEVELNAME"));
  619. rows.add(row);
  620. }
  621. data.setRows(rows);
  622. excelHelper.exportExcel(response, "党建考评信息.xlsx", data);
  623. }
  624. @ResponseBody
  625. @GetMapping("/getJlcfxxList")
  626. public RequsetData<PageInfo<DjJlcfxxVo>> getJlcfxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  627. @RequestParam(required = false) String dzzmc,
  628. @RequestParam(required = false) String dzzdm,
  629. @RequestParam(required = false) String username,
  630. @RequestParam(required = false) String rybm,
  631. @RequestParam(required = false) Integer offenceType,
  632. @RequestParam(required = false) Integer punishType,
  633. @RequestParam(required = false) String beginTime,
  634. @RequestParam(required = false) String endTime,
  635. @RequestParam(required = false) Integer zzfbType) {
  636. beginTime = dateUtils.strFormat_short(beginTime);
  637. endTime = dateUtils.strFormat_short(endTime);
  638. RequsetData<PageInfo<DjJlcfxxVo>> result = new RequsetData<>();
  639. result.setItem(partyTwoService.getJlcfxxList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, offenceType, punishType, beginTime, endTime, zzfbType));
  640. return result;
  641. }
  642. @ResponseBody
  643. @RequestMapping("/getJlcfxx")
  644. public RequsetData<DjJlcfxx> getJlcfxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
  645. RequsetData<DjJlcfxx> res = new RequsetData<>();
  646. DjJlcfxx model = partyTwoService.getJlcfxx(id);
  647. if (model == null) {
  648. UUID uuid = UUID.randomUUID();
  649. model = new DjJlcfxx();
  650. model.setId(uuid.toString());
  651. model.setDzzdm(dzzdm);
  652. model.setDzzmc(dzzmc);
  653. }
  654. res.setItem(model);
  655. return res;
  656. }
  657. @ResponseBody
  658. @RequestMapping("/saveJlcfxx")
  659. public RequsetData<String> saveJlcfxx(@RequestBody DjJlcfxx model) {
  660. RequsetData<String> res = partyTwoService.saveJlcfxx(model);
  661. return res;
  662. }
  663. @ResponseBody
  664. @GetMapping("/delJlcfxx")
  665. public RequsetData<Integer> delJlcfxx(@RequestParam("id") String id) {
  666. RequsetData<Integer> result = new RequsetData<>();
  667. int row = partyTwoService.delJlcfxx(id);
  668. result.setItem(row);
  669. if (row == 0) {
  670. result.setSuccess(false);
  671. result.setMsg("删除失败!");
  672. } else {
  673. result.setMsg("删除成功!");
  674. }
  675. return result;
  676. }
  677. @RequestMapping(value = "/exportJlcfxx", method = RequestMethod.GET)
  678. public void exportJlcfxx(HttpServletResponse response,
  679. @RequestParam(required = false) String dzzmc,
  680. @RequestParam(required = false) String dzzdm,
  681. @RequestParam(required = false) String username,
  682. @RequestParam(required = false) String rybm,
  683. @RequestParam(required = false) Integer offenceType,
  684. @RequestParam(required = false) Integer punishType,
  685. @RequestParam(required = false) String beginTime,
  686. @RequestParam(required = false) String endTime,
  687. @RequestParam(required = false) Integer zzfbType) throws Exception {
  688. beginTime = dateUtils.strFormat_short(beginTime);
  689. endTime = dateUtils.strFormat_short(endTime);
  690. /**查询数据**/
  691. List<DjJlcfxxVo> dataList = partyTwoService.getJlcfxxList(1, 100000, dzzdm, dzzmc, username, rybm, offenceType, punishType, beginTime, endTime, zzfbType).getList();
  692. ExcelHelper excelHelper = new ExcelHelper();
  693. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  694. //列名
  695. data.setName("党员受党的纪律处分信息");
  696. List<String> titles = new ArrayList();
  697. titles.add("姓名");
  698. titles.add("所属党组织");
  699. titles.add("批准日期");
  700. titles.add("处分类型");
  701. titles.add("违纪行为");
  702. titles.add("批准单位");
  703. titles.add("文号");
  704. data.setTitles(titles);
  705. //数据
  706. List<List<Object>> rows = new ArrayList();
  707. for (DjJlcfxxVo item : dataList) {
  708. List<Object> row = new ArrayList();
  709. row.add(item.getUsername());
  710. row.add(item.getDzzmc());
  711. row.add(dateUtils.strFormat_short(item.getApprovaldate().toString()));
  712. row.add(item.getPunishtypename());
  713. row.add(item.getOffence());
  714. row.add(item.getUnit());
  715. row.add(item.getSymbol());
  716. rows.add(row);
  717. }
  718. data.setRows(rows);
  719. excelHelper.exportExcel(response, "党员受党的纪律处分信息.xlsx", data);
  720. }
  721. @ResponseBody
  722. @GetMapping("/getTaskList")
  723. public RequsetData<PageInfo<HashMap<String, Object>>> getTaskList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  724. @RequestParam(required = false) String username,
  725. @RequestParam(required = false) String taskUser,
  726. @RequestParam(required = false) String taskName,
  727. @RequestParam(required = false) String beginTime,
  728. @RequestParam(required = false) String endTime,
  729. @RequestParam(required = false) String userid,
  730. @RequestParam(required = false) String day,
  731. @RequestParam(required = false) Integer isreceive) {
  732. beginTime = dateUtils.strFormat_short(beginTime);
  733. endTime = dateUtils.strFormat_short(endTime);
  734. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  735. result.setItem(partyTwoService.getTaskList(pageIndex, pageSize, username, taskUser, taskName, beginTime, endTime, day, userid,isreceive));
  736. return result;
  737. }
  738. @ResponseBody
  739. @GetMapping("/getTaskUserList")
  740. public RequsetData<List<DjTaskusers>> getTaskUserList(@RequestParam(required = false) String taskid) {
  741. RequsetData<List<DjTaskusers>> result = new RequsetData<>();
  742. result.setItem(partyTwoService.getTaskUserList(taskid));
  743. return result;
  744. }
  745. @ResponseBody
  746. @RequestMapping("/getTask")
  747. public RequsetData<DjTask> getTask(@RequestParam(required = false) String id) {
  748. RequsetData<DjTask> res = new RequsetData<>();
  749. DjTask model = partyTwoService.getTask(id);
  750. if (model == null) {
  751. UUID uuid = UUID.randomUUID();
  752. model = new DjTask();
  753. model.setId(uuid.toString());
  754. model.setTasktime(new Date());
  755. model.setCreateuserid(userService.getLoginUser().getUserid());
  756. model.setCreateusername(userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
  757. }else{
  758. Map<String, Object> extdata=new HashMap<String, Object>();
  759. extdata.put("isReceiveTask",partyTwoService.isReceiveTask(id,userService.getLoginUser().getUserid()));
  760. res.setExtdata(extdata);
  761. }
  762. res.setItem(model);
  763. return res;
  764. }
  765. @ResponseBody
  766. @RequestMapping("/receiveTask")
  767. public RequsetData<Integer> receiveTask(@RequestParam(required = false) String id) {
  768. int count = partyTwoService.receiveTask(id, userService.getLoginUser().getUserid());
  769. RequsetData<Integer> res = new RequsetData<>();
  770. res.setItem(count);
  771. return res;
  772. }
  773. @ResponseBody
  774. @RequestMapping("/resetSubmit")
  775. public RequsetData<Integer> resetSubmit(@RequestParam(required = false) String id) {
  776. int count = partyTwoService.resetSubmit(id);
  777. RequsetData<Integer> res = new RequsetData<>();
  778. res.setItem(count);
  779. return res;
  780. }
  781. @ResponseBody
  782. @RequestMapping("/saveTask")
  783. public RequsetData<String> saveTask(@RequestBody Map<String, Object> reqMap) {
  784. RequsetData<String> res = new RequsetData<String>();
  785. int count = 0;
  786. String message = "";
  787. ObjectMapper mapper = new ObjectMapper();
  788. try {
  789. DjTask dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjTask.class);
  790. List<DjTaskusers> userList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<List<DjTaskusers>>() {
  791. });
  792. List<QtTaskpubcolumn> columnList =
  793. JsonMapper.jsonToObject(reqMap.get("columnList").toString(), new TypeReference<List<QtTaskpubcolumn>>() {
  794. });
  795. String flowId = reqMap.get("flowId").toString();
  796. count = partyTwoService.saveTask(dataModel, userList, columnList,userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
  797. } catch (Exception e) {
  798. e.printStackTrace();
  799. message = e.getMessage();
  800. }
  801. if (count > 0) {
  802. res.setSuccess(true);
  803. res.setMsg("操作成功!");
  804. } else {
  805. res.setSuccess(false);
  806. res.setMsg("操作失败!" + message);
  807. }
  808. return res;
  809. }
  810. @RequestMapping(value = "/exportTask", method = RequestMethod.GET)
  811. public void exportTask(HttpServletResponse response,
  812. @RequestParam(required = false) String username,
  813. @RequestParam(required = false) String taskUser,
  814. @RequestParam(required = false) String taskName,
  815. @RequestParam(required = false) String beginTime,
  816. @RequestParam(required = false) String endTime,
  817. @RequestParam(required = false) String userid,
  818. @RequestParam(required = false) String day) throws Exception {
  819. beginTime = dateUtils.strFormat_short(beginTime);
  820. endTime = dateUtils.strFormat_short(endTime);
  821. /**查询数据**/
  822. List<HashMap<String, Object>> dataList = partyTwoService.getTaskList(1, 9999, username, taskUser, taskName, beginTime, endTime, day, userid,null).getList();
  823. ExcelHelper excelHelper = new ExcelHelper();
  824. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  825. //列名
  826. data.setName("通知信息");
  827. List<String> titles = new ArrayList();
  828. titles.add("任务名称");
  829. titles.add("接收人");
  830. titles.add("下达时间");
  831. titles.add("截止时间");
  832. titles.add("发送部门");
  833. data.setTitles(titles);
  834. //数据
  835. List<List<Object>> rows = new ArrayList();
  836. for (HashMap<String, Object> item : dataList) {
  837. List<Object> row = new ArrayList();
  838. row.add(item.get("TASKNAME"));
  839. row.add(item.get("USERNAME"));
  840. row.add(dateUtils.strFormat_long(item.get("TASKTIME").toString()));
  841. row.add(dateUtils.strFormat_long(item.get("ENDTIME").toString()));
  842. row.add(item.get("SENDDEPART"));
  843. rows.add(row);
  844. }
  845. data.setRows(rows);
  846. excelHelper.exportExcel(response, "任务信息.xlsx", data);
  847. }
  848. @ResponseBody
  849. @GetMapping("/delTask")
  850. public RequsetData<Integer> delTask(@RequestParam("id") String id) {
  851. RequsetData<Integer> result = new RequsetData<>();
  852. int row = partyTwoService.delTask(id);
  853. result.setItem(row);
  854. if (row == 0) {
  855. result.setSuccess(false);
  856. result.setMsg("删除失败!");
  857. } else {
  858. result.setMsg("删除成功!");
  859. }
  860. return result;
  861. }
  862. @ResponseBody
  863. @GetMapping("/taskterminate")
  864. public RequsetData<Integer> taskterminate(@RequestParam("id") String id) {
  865. RequsetData<Integer> result = new RequsetData<>();
  866. int row = partyTwoService.terminateTask(id);
  867. result.setItem(row);
  868. if (row == 0) {
  869. result.setSuccess(false);
  870. result.setMsg("终止失败!");
  871. } else {
  872. result.setMsg("终止成功!");
  873. }
  874. return result;
  875. }
  876. @ResponseBody
  877. @GetMapping("/getPartyTotalInfo")
  878. public RequsetData<HashMap<String, Object>> getPartyTotalInfo(@RequestParam("dzzdm") String dzzdm, @RequestParam("yearMonth") String yearMonth, @RequestParam("year") String year) {
  879. RequsetData<HashMap<String, Object>> result = new RequsetData<>();
  880. result.setItem(partyTwoService.getPartyTotalInfo(dzzdm, yearMonth, year));
  881. return result;
  882. }
  883. @ResponseBody
  884. @GetMapping("/getfundsBudgetList")
  885. public RequsetData<PageInfo<HashMap<String, Object>>> getfundsBudgetList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  886. @RequestParam(required = false) String dzzmc,
  887. @RequestParam(required = false) String dzzdm,
  888. @RequestParam(required = false) Integer year) {
  889. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  890. result.setItem(partyTwoService.getfundsBudgetList(pageIndex, pageSize, dzzdm, dzzmc, year));
  891. return result;
  892. }
  893. @ResponseBody
  894. @RequestMapping("/getfundsBudget")
  895. public RequsetData<DjFundsbudget> getfundsBudget(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
  896. RequsetData<DjFundsbudget> res = new RequsetData<>();
  897. DjFundsbudget model = partyTwoService.getfundsBudget(id);
  898. Map<String, Object> map = new HashMap<>(10);
  899. if (model == null) {
  900. UUID uuid = UUID.randomUUID();
  901. model = new DjFundsbudget();
  902. model.setFundsbudgetid(uuid.toString());
  903. model.setPartycode(dzzdm);
  904. map.put("dzzmc", dzzmc);
  905. } else {
  906. map.put("dzzmc", partyService.getPartyByDm(dzzdm).getDzzmc());
  907. }
  908. res.setItem(model);
  909. res.setExtdata(map);
  910. return res;
  911. }
  912. @ResponseBody
  913. @RequestMapping("/savefundsBudget")
  914. public RequsetData<String> savefundsBudget(@RequestBody DjFundsbudget model) {
  915. RequsetData<String> res = partyTwoService.savefundsBudget(model);
  916. return res;
  917. }
  918. @ResponseBody
  919. @GetMapping("/delfundsBudget")
  920. public RequsetData<Integer> delfundsBudget(@RequestParam("id") String id) {
  921. RequsetData<Integer> result = new RequsetData<>();
  922. int row = partyTwoService.delfundsBudget(id);
  923. result.setItem(row);
  924. if (row == 0) {
  925. result.setSuccess(false);
  926. result.setMsg("删除失败!");
  927. } else {
  928. result.setMsg("删除成功!");
  929. }
  930. return result;
  931. }
  932. @RequestMapping(value = "/exportfundsBudget", method = RequestMethod.GET)
  933. public void exportfundsBudget(HttpServletResponse response,
  934. @RequestParam(required = false) String dzzmc,
  935. @RequestParam(required = false) String dzzdm,
  936. @RequestParam(required = false) Integer year) throws Exception {
  937. /**查询数据**/
  938. List<HashMap<String, Object>> dataList = partyTwoService.getfundsBudgetList(1, 100000, dzzdm, dzzmc, year).getList();
  939. ExcelHelper excelHelper = new ExcelHelper();
  940. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  941. //列名
  942. data.setName("党组织工作经费预算信息");
  943. List<String> titles = new ArrayList();
  944. titles.add("所属党组织");
  945. titles.add("年度");
  946. titles.add("预算费用(万元)");
  947. titles.add("活动经费(万元)");
  948. titles.add("奖励经费(万元)");
  949. titles.add("去年实际支出(万元)");
  950. titles.add("与上年比增减(万元)");
  951. data.setTitles(titles);
  952. //数据
  953. List<List<Object>> rows = new ArrayList();
  954. for (HashMap<String, Object> item : dataList) {
  955. List<Object> row = new ArrayList();
  956. row.add(item.get("DZZMC"));
  957. row.add(item.get("YEAR"));
  958. row.add(item.get("BUDGETFUNDS"));
  959. row.add(item.get("ACTIVITYFUNDS"));
  960. row.add(item.get("REWARDFUNDS"));
  961. row.add(item.get("ACTUALEXPEND"));
  962. row.add(item.get("GRDATION"));
  963. rows.add(row);
  964. }
  965. data.setRows(rows);
  966. excelHelper.exportExcel(response, "党组织工作经费预算信息.xlsx", data);
  967. }
  968. @ResponseBody
  969. @GetMapping("/getZtdrSummary")
  970. public RequsetData<PageInfo<HashMap<String, Object>>> getZtdrSummary(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  971. @RequestParam(required = false) String dzzdm, @RequestParam(required = false) Integer year) {
  972. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  973. result.setItem(partyTwoService.getZtdrSummary(pageIndex, pageSize, dzzdm, year));
  974. return result;
  975. }
  976. @RequestMapping(value = "/exportZtdrSummary", method = RequestMethod.GET)
  977. public void exportZtdrSummary(HttpServletResponse response,
  978. @RequestParam(required = false) String dzzmc,
  979. @RequestParam(required = false) String dzzdm,
  980. @RequestParam(required = false) Integer year) throws Exception {
  981. /**查询数据**/
  982. List<HashMap<String, Object>> dataList = partyTwoService.getZtdrSummary(1, 100000, dzzdm, year).getList();
  983. ExcelHelper excelHelper = new ExcelHelper();
  984. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  985. //列名
  986. data.setName("党内生活统计信息");
  987. List<String> titles = new ArrayList();
  988. titles.add("所属党组织");
  989. titles.add("年度");
  990. titles.add("党员大会");
  991. titles.add("支委会");
  992. titles.add("党小组会");
  993. titles.add("党课");
  994. titles.add("主题党日");
  995. data.setTitles(titles);
  996. //数据
  997. List<List<Object>> rows = new ArrayList();
  998. for (HashMap<String, Object> item : dataList) {
  999. List<Object> row = new ArrayList();
  1000. row.add(item.get("DZZMC"));
  1001. row.add(item.get("YEAR"));
  1002. row.add(item.get("党员大会"));
  1003. row.add(item.get("支委会"));
  1004. row.add(item.get("党小组会"));
  1005. row.add(item.get("党课"));
  1006. row.add(item.get("主题党日"));
  1007. rows.add(row);
  1008. }
  1009. data.setRows(rows);
  1010. excelHelper.exportExcel(response, "党内生活统计信息.xlsx", data);
  1011. }
  1012. @ResponseBody
  1013. @GetMapping("/getMzpyjgList")
  1014. public RequsetData<List<HashMap<String, Object>>> getMzpyjgList() {
  1015. RequsetData<List<HashMap<String, Object>>> result = new RequsetData<>();
  1016. result.setItem(partyTwoService.getMzpyjgList());
  1017. return result;
  1018. }
  1019. @ResponseBody
  1020. @GetMapping("/getMzpyxxList")
  1021. public RequsetData<PageInfo<HashMap<String, Object>>> getMzpyxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
  1022. @RequestParam(required = false) String rybm,
  1023. @RequestParam(required = false) String dzzdm,
  1024. @RequestParam(required = false) String username,
  1025. @RequestParam(required = false) String beginTime,
  1026. @RequestParam(required = false) String endTime,
  1027. @RequestParam(required = false) String pyjg) {
  1028. // beginTime = dateUtils.strFormat_short(beginTime);
  1029. // endTime = dateUtils.strFormat_short(endTime);
  1030. RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
  1031. result.setItem(partyTwoService.getMzpyxxList(pageIndex, pageSize, username, rybm, dzzdm, beginTime, endTime, pyjg));
  1032. return result;
  1033. }
  1034. @RequestMapping(value = "/exportMzpyxx", method = RequestMethod.GET)
  1035. public void exportMzpyxx(HttpServletResponse response,
  1036. @RequestParam(required = false) String rybm,
  1037. @RequestParam(required = false) String dzzdm,
  1038. @RequestParam(required = false) String username,
  1039. @RequestParam(required = false) String beginTime,
  1040. @RequestParam(required = false) String endTime,
  1041. @RequestParam(required = false) String pyjg) throws Exception {
  1042. // beginTime = dateUtils.strFormat_short(beginTime);
  1043. // endTime = dateUtils.strFormat_short(endTime);
  1044. /**查询数据**/
  1045. List<HashMap<String, Object>> dataList = partyTwoService.getMzpyxxList(1, 9999, username, rybm, dzzdm, beginTime, endTime, pyjg).getList();
  1046. ExcelHelper excelHelper = new ExcelHelper();
  1047. ExcelHelper.ExcelData data = excelHelper.new ExcelData();
  1048. //列名
  1049. data.setName("民主评议信息");
  1050. List<String> titles = new ArrayList();
  1051. titles.add("所属党组织");
  1052. titles.add("姓名");
  1053. titles.add("开展评议日期");
  1054. titles.add("结束评议日期");
  1055. titles.add("评议结果");
  1056. data.setTitles(titles);
  1057. //数据
  1058. List<List<Object>> rows = new ArrayList();
  1059. for (HashMap<String, Object> item : dataList) {
  1060. List<Object> row = new ArrayList();
  1061. row.add(item.get("DZZMC"));
  1062. row.add(item.get("XM"));
  1063. row.add(item.get("KZPYRQ"));
  1064. row.add(item.get("JSPYRQ"));
  1065. row.add(item.get("PYJGMC"));
  1066. rows.add(row);
  1067. }
  1068. data.setRows(rows);
  1069. excelHelper.exportExcel(response, "民主评议信息集.xlsx", data);
  1070. }
  1071. @ResponseBody
  1072. @GetMapping("/getMzpyById")
  1073. public RequsetData<ZzMzpyxxVo> getMzpyById(@RequestParam(required = false) String id) {
  1074. RequsetData<ZzMzpyxxVo> res = new RequsetData<>();
  1075. ZzMzpyxxVo model = partyTwoService.getMzpyById(id);
  1076. if (model == null || (model != null && stringUtils.IsNullOrEmpty(model.getMzpyxxbs()))) {
  1077. UUID uuid = UUID.randomUUID();
  1078. model = new ZzMzpyxxVo();
  1079. model.setMzpyxxbs(uuid.toString());
  1080. }
  1081. res.setItem(model);
  1082. return res;
  1083. }
  1084. @ResponseBody
  1085. @PostMapping("/saveMzpy")
  1086. public RequsetData<String> saveMzpy(@RequestBody ZzMzpyxxVo data) {
  1087. RequsetData<String> res = new RequsetData<String>();
  1088. int count = partyTwoService.saveMzpy(data);
  1089. if (count > 0) {
  1090. res.setSuccess(true);
  1091. res.setMsg("保存成功!");
  1092. } else {
  1093. res.setSuccess(false);
  1094. res.setMsg("保存失败!");
  1095. }
  1096. return res;
  1097. }
  1098. @ResponseBody
  1099. @GetMapping("/deleteMzpy")
  1100. public RequsetData<Integer> deleteMzpy(String id) {
  1101. RequsetData<Integer> result = new RequsetData<>();
  1102. int row = partyTwoService.deleteMzpyById(id);
  1103. result.setItem(row);
  1104. if (row == 0) {
  1105. result.setSuccess(false);
  1106. result.setMsg("删除失败!");
  1107. } else {
  1108. result.setMsg("删除成功!");
  1109. }
  1110. return result;
  1111. }
  1112. @ResponseBody
  1113. @GetMapping("/getleaderUserList")
  1114. public RequsetData<PageInfo<HashMap<String, Object>> > getleaderUserList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,@RequestParam(required = false) String username,@RequestParam(required = false) Integer usertype) {
  1115. RequsetData<PageInfo<HashMap<String, Object>> > result = new RequsetData<>();
  1116. result.setItem(partyTwoService.getleaderUserList(pageIndex,pageSize,username,usertype));
  1117. return result;
  1118. }
  1119. @ResponseBody
  1120. @RequestMapping("/importDnghbf")
  1121. public RequsetData<List<Map<String, Object>>> importDnghbf(HttpServletResponse response,@RequestBody Map<String, Object> reqMap) {
  1122. ArrayList<Map<String, Object>> dnghbflist = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<ArrayList<Map<String, Object>>>() {
  1123. });
  1124. RequsetData<List<Map<String, Object>>> result = new RequsetData<>();
  1125. try {
  1126. List<Map<String, Object>> errorInfo = partyTwoService.importDnghbf(dnghbflist);
  1127. if (errorInfo.size() == 0) {
  1128. result.setSuccess(true);
  1129. result.setMsg("导入成功。");
  1130. } else {
  1131. result.setSuccess(false);
  1132. result.setMsg("导入失败,详情请下载错误提示文件查看。");
  1133. result.setItem(errorInfo);
  1134. }
  1135. } catch (Exception ex) {
  1136. result.setSuccess(false);
  1137. result.setMsg("导入失败," + ex.getMessage());
  1138. }
  1139. return result;
  1140. }
  1141. }