1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312 |
- package com.ghsc.partybuild.controller;
- import com.fasterxml.jackson.core.type.TypeReference;
- import com.fasterxml.jackson.databind.ObjectMapper;
- import com.github.pagehelper.PageInfo;
- import com.ghsc.partybuild.controller.jsonmodel.RequsetData;
- import com.ghsc.partybuild.model.*;
- import com.ghsc.partybuild.service.PartyService;
- import com.ghsc.partybuild.service.PartyTwoService;
- import com.ghsc.partybuild.service.UserService;
- import com.ghsc.partybuild.util.*;
- import com.ghsc.partybuild.vo.*;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.web.bind.annotation.*;
- import javax.servlet.http.HttpServletResponse;
- import java.math.BigDecimal;
- import java.util.*;
- @RestController
- @RequestMapping(value = "/api/partyTowExt")
- public class PartyTwoController {
- @Autowired
- private PartyTwoService partyTwoService;
- @Autowired
- private MapUtils mapUtils;
- @Autowired
- private StringUtils stringUtils;
- @Autowired
- private DateUtils dateUtils;
- @Autowired
- private UserService userService;
- @Autowired
- private PartyService partyService;
- @ResponseBody
- @GetMapping("/getDnpxxxList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getDnpxxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer honourLevel,
- @RequestParam(required = false) String honourName,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) Integer pxlx, @RequestParam(required = false) String ssdzzdm ,@RequestParam(required = false)Integer honourType) {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getDnpxxxList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, honourLevel, honourName, beginTime, endTime, zzfbType, pxlx, ssdzzdm,honourType));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getDnpxxx")
- public RequsetData<DjDnpxxx> getDnpxxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc, @RequestParam(required = false) String pxlx) {
- RequsetData<DjDnpxxx> res = new RequsetData<>();
- DjDnpxxx model = partyTwoService.getDnpxxx(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjDnpxxx();
- model.setId(uuid.toString());
- model.setDzzdm(dzzdm);
- model.setDzzmc(dzzmc);
- model.setPxlx(pxlx);
- model.setIscommend(0);
- } else {
- List<DjDnpxry> rylist = partyTwoService.getDnpxryList(model.getId());
- Map<String, Object> extdata = new HashMap<>(10);
- /* List<String> userid = new ArrayList<>();
- List<String> username = new ArrayList<>();
- for (DjDnpxry ry : rylist) {
- userid.add(ry.getUserid());
- username.add(ry.getUsername());
- }
- extdata.put("userid", String.join(",", userid));
- extdata.put("username", String.join(",", username));*/
- res.setExtdata(extdata);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveDnpxxx")
- public RequsetData<String> saveDnpxxx(@RequestBody Map<String, Object> reqMap) {
- ObjectMapper mapper = new ObjectMapper();
- RequsetData<String> res = new RequsetData<String>();
- try {
- DjDnpxxx model = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjDnpxxx.class);
- UserItemVo[] recordList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<UserItemVo[]>() {
- });
- res = partyTwoService.saveDnpxxx(model, recordList);
- } catch (Exception e) {
- e.printStackTrace();
- }
- return res;
- }
- @ResponseBody
- @GetMapping("/delDnpxxx")
- public RequsetData<Integer> delDnpxxx(@RequestParam("id") String id, @RequestParam(required = false) String userid) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delDnpxxx(id, userid);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportDnpxxx", method = RequestMethod.GET)
- public void exportDnpxxx(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer honourLevel,
- @RequestParam(required = false) String honourName,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType,
- @RequestParam(required = false) Integer pxlx) throws Exception {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getDnpxxxList(1, 100000, dzzdm, dzzmc, username, rybm, honourLevel, honourName, beginTime, endTime, zzfbType, pxlx, null,null).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("党内评先信息");
- List<String> titles = new ArrayList();
- titles.add("荣誉名称");
- //titles.add("评先类型");
- if (pxlx == 1) {
- titles.add("姓名");
- }
- titles.add("所属党组织");
- titles.add("获得荣誉时间");
- titles.add("等级");
- titles.add("荣誉类型");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("HONOURNAME"));
- //row.add("1".equals((String) item.get("PXLX")) ? "个人" : "组织");
- if (pxlx == 1) {
- row.add(item.get("USERNAME"));
- }
- row.add(item.get("DZZMC"));
- row.add(dateUtils.strFormat(item.get("HONOURTIME").toString()));
- row.add(item.get("LEVELNAME"));
- row.add(item.get("HONOURTYPENAME"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "党内评先信息.xlsx", data);
- }
- @ResponseBody
- @RequestMapping("/saveDnghbf")
- public RequsetData<String> saveDnghbf(@RequestBody Map<String, Object> reqMap) {
- RequsetData<String> res = new RequsetData<String>();
- int count = 0;
- String message = "";
- ObjectMapper mapper = new ObjectMapper();
- try {
- DjDnghbf dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjDnghbf.class);
- List<DjDnghbfmx> recordList = JsonMapper.jsonToObject(reqMap.get("recordList").toString(), new TypeReference<List<DjDnghbfmx>>() {
- });
- count = partyTwoService.saveDnghbf(dataModel, recordList, userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
- } catch (Exception e) {
- e.printStackTrace();
- message = e.getMessage();
- }
- if (count > 0) {
- res.setSuccess(true);
- res.setMsg("操作成功!");
- } else {
- res.setSuccess(false);
- res.setMsg("操作失败!" + message);
- }
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveDnghbfmx")
- public RequsetData<String> saveDnghbfmx(@RequestBody DjDnghbfmx bfmx) {
- RequsetData<String> res = new RequsetData<String>();
- int count = 0;
- count = partyTwoService.saveDnghbfmx(bfmx);
- if (count > 0) {
- res.setSuccess(true);
- res.setMsg("操作成功!");
- } else {
- res.setSuccess(false);
- res.setMsg("操作失败!");
- }
- return res;
- }
- @ResponseBody
- @RequestMapping("/getDnghbf")
- public RequsetData<DjDnghbf> getDnghbf(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
- RequsetData<DjDnghbf> res = new RequsetData<>();
- DjDnghbf model = partyTwoService.getDnghbf(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjDnghbf();
- model.setId(uuid.toString());
- model.setDzzdm(dzzdm);
- model.setDzzmc(dzzmc);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @GetMapping("/getDnghbfList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer careType,
- @RequestParam(required = false) Integer zzfbType,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer helpformType) {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getDnghbfList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, careType, zzfbType, beginTime, endTime, helpformType));
- return result;
- }
- @ResponseBody
- @GetMapping("/getDnghbfDetailsList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfDetailsList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer careType,
- @RequestParam(required = false) Integer zzfbType) {
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getDnghbfDetailsList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, careType, zzfbType));
- return result;
- }
- @ResponseBody
- @GetMapping("/getDnghbfmxList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfmxList(
- @RequestParam(required = false) String dnghbId) {
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getDnghbfmxList(1, 10000, dnghbId));
- return result;
- }
- @ResponseBody
- @GetMapping("/delDnghbf")
- public RequsetData<Integer> delDnghbf(@RequestParam("id") String id, @RequestParam(required = false) String ghmxid) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delDnghbf(id, ghmxid);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportDnghbf", method = RequestMethod.GET)
- public void exportDnghbf(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer careType,
- @RequestParam(required = false) Integer zzfbType,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer helpformType) throws Exception {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getDnghbfList(1, 100000, dzzdm, dzzmc, username, rybm, careType, zzfbType, beginTime, endTime, helpformType).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("党内评先信息");
- List<String> titles = new ArrayList();
- titles.add("姓名");
- titles.add("所属党支部");
- titles.add("帮扶时间");
- titles.add("帮扶形式");
- titles.add("慰问金额");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("USERNAME"));
- row.add(item.get("SZDZZMC"));
- row.add(dateUtils.strFormat(item.get("CAREDATE").toString()));
- row.add(item.get("HELPFORMTYPENAME"));
- row.add(item.get("AMOUNT"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "党内关怀帮扶.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getZtdrxxList")
- public RequsetData<PageInfo<DjZtdrxxVo>> getZtdrxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String title,
- @RequestParam(required = false) Integer subjectType,
- @RequestParam(required = false) String location,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType) {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<DjZtdrxxVo>> result = new RequsetData<>();
- result.setItem(partyTwoService.getZtdrxxList(pageIndex, pageSize, dzzdm, dzzmc, title, subjectType, location, beginTime, endTime, zzfbType));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getZtdrxx")
- public RequsetData<DjZtdrxx> getZtdrxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
- RequsetData<DjZtdrxx> res = new RequsetData<>();
- DjZtdrxx model = partyTwoService.getZtdrxx(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjZtdrxx();
- model.setId(uuid.toString());
- model.setDzzdm(dzzdm);
- model.setDzzmc(dzzmc);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveZtdrxx")
- public RequsetData<String> saveZtdrxx(@RequestBody DjZtdrxx model) {
- RequsetData<String> res = partyTwoService.saveZtdrxx(model);
- return res;
- }
- @ResponseBody
- @GetMapping("/delZtdrxx")
- public RequsetData<Integer> delZtdrxx(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delZtdrxx(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportZtdrxx", method = RequestMethod.GET)
- public void exportZtdrxx(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) Integer honourLevel,
- @RequestParam(required = false) String honourName,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType) throws Exception {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<DjZtdrxxVo> dataList = partyTwoService.getZtdrxxList(1, 100000, dzzdm, dzzmc, username, honourLevel, honourName, beginTime, endTime, zzfbType).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("主题党日信息");
- List<String> titles = new ArrayList();
- titles.add("所属党组织");
- titles.add("时间");
- titles.add("地点");
- titles.add("主题");
- titles.add("内容");
- titles.add("类别");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (DjZtdrxxVo item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.getDzzmc());
- row.add(dateUtils.strFormat_short(item.getActivitytime().toString()));
- row.add(item.getLocation());
- row.add(item.getTitle());
- row.add(item.getSubjectcontent());
- row.add(item.getSubjecttypename());
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "主题党日信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getZzsrList")
- public RequsetData<PageInfo<DjZzsrVo>> getZzsrList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String title,
- @RequestParam(required = false) Integer subjectType,
- @RequestParam(required = false) String location,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType) {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<DjZzsrVo>> result = new RequsetData<>();
- result.setItem(partyTwoService.getZzsrList(pageIndex, pageSize, dzzdm, dzzmc, title, subjectType, location, beginTime, endTime, zzfbType));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getZzsr")
- public RequsetData<DjZzsr> getZzsr(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
- RequsetData<DjZzsr> res = new RequsetData<>();
- DjZzsr model = partyTwoService.getZzsr(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjZzsr();
- model.setId(uuid.toString());
- model.setDzzdm(dzzdm);
- model.setDzzmc(dzzmc);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveZzsr")
- public RequsetData<String> saveZzsr(@RequestBody DjZzsr model) {
- RequsetData<String> res = partyTwoService.saveZzsr(model);
- return res;
- }
- @ResponseBody
- @GetMapping("/delZzsr")
- public RequsetData<Integer> delZzsr(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delZzsr(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportZzsr", method = RequestMethod.GET)
- public void exportZzsr(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) Integer honourLevel,
- @RequestParam(required = false) String honourName,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType) throws Exception {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<DjZzsrVo> dataList = partyTwoService.getZzsrList(1, 100000, dzzdm, dzzmc, username, honourLevel, honourName, beginTime, endTime, zzfbType).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("政治生日信息");
- List<String> titles = new ArrayList();
- titles.add("所属党组织");
- titles.add("时间");
- titles.add("地点");
- titles.add("主题");
- titles.add("内容");
- titles.add("类别");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (DjZzsrVo item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.getDzzmc());
- row.add(dateUtils.strFormat_short(item.getActivitytime().toString()));
- row.add(item.getLocation());
- row.add(item.getTitle());
- row.add(item.getSubjectcontent());
- row.add(item.getSubjecttypename());
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "政治生日信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getParyDjkpList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getParyDjkpList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String selectdzzmc,
- @RequestParam(required = false) Integer year,
- @RequestParam(required = false) Integer showdxz,
- @RequestParam(required = false) Integer showdw,
- @RequestParam(required = false) Integer showdzb,
- @RequestParam(required = false) String selectdzzdm) {
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- List<String> selectdzzdmList = new ArrayList<>();
- if (!stringUtils.IsNullOrEmpty(selectdzzdm)) {
- selectdzzdmList = Arrays.asList(selectdzzdm.split(","));
- }
- result.setItem(partyTwoService.getParyDjkpList(pageIndex, pageSize, dzzdm,selectdzzmc, showdxz, year, showdw,showdzb,selectdzzdmList));
- return result;
- }
- @ResponseBody
- @GetMapping("/getDjkpxxList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getDjkpxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) Integer year,
- @RequestParam(required = false) Integer judgeLevel,
- @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) String ssdzzdm,
- @RequestParam(required = false) Integer showdw) {
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getDjkpxxList(pageIndex, pageSize, dzzdm, dzzmc, judgeLevel, year, zzfbType, ssdzzdm, showdw));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getDjkpxx")
- public RequsetData<DjDjkpxx> getDjkpxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
- RequsetData<DjDjkpxx> res = new RequsetData<>();
- DjDjkpxx model = partyTwoService.getDjkpxx(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjDjkpxx();
- model.setId(uuid.toString());
- model.setDzzdm(dzzdm);
- model.setDzzmc(dzzmc);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveDjkpxx")
- public RequsetData<String> saveDjkpxx(@RequestBody DjDjkpxx model) {
- RequsetData<String> res = partyTwoService.saveDjkpxx(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveDjkpxxByList")
- public RequsetData<String> saveDjkpxxByList(@RequestBody Map<String, Object> reqMap) {
- RequsetData<String> res = new RequsetData<String>();
- int count = 0;
- String message = "";
- try {
- List<DjDjkpxx> dataList = JsonMapper.jsonToObject(reqMap.get("dataList").toString(), new TypeReference<List<DjDjkpxx>>() {
- });
- count = partyTwoService.saveDjkpxxByList(dataList, userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
- } catch (Exception e) {
- e.printStackTrace();
- message = e.getMessage();
- }
- if (count > 0) {
- res.setSuccess(true);
- res.setMsg("操作成功!");
- } else {
- res.setSuccess(false);
- res.setMsg("操作失败!" + message);
- }
- return res;
- }
- @ResponseBody
- @GetMapping("/delDjkpxx")
- public RequsetData<Integer> delDjkpxx(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delDjkpxx(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportDjkpxx", method = RequestMethod.GET)
- public void exportDjkpxx(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) Integer year,
- @RequestParam(required = false) Integer judgeLevel,
- @RequestParam(required = false) Integer zzfbType,
- @RequestParam(required = false) Integer showdw) throws Exception {
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getDjkpxxList(1, 100000, dzzdm, dzzmc, year, judgeLevel, zzfbType, null, showdw).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("党建考评信息");
- List<String> titles = new ArrayList();
- titles.add("所属党组织");
- titles.add("年度");
- titles.add("第一季度评分");
- titles.add("第二季度评分");
- titles.add("第三季度评分");
- titles.add("第四季度评分");
- /* if (showdw == 1) {
- titles.add("年度评分");
- }*/
- titles.add("评定等级");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("DZZMC"));
- row.add(item.get("YEAR"));
- row.add(item.get("QUARTER1"));
- row.add(item.get("QUARTER2"));
- row.add(item.get("QUARTER3"));
- row.add(item.get("QUARTER4"));
- /* if (showdw == 1) {
- row.add(item.get("ANNUALSCORE"));
- }*/
- row.add(item.get("JUDGELEVELNAME"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "党建考评信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getJlcfxxList")
- public RequsetData<PageInfo<DjJlcfxxVo>> getJlcfxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer offenceType,
- @RequestParam(required = false) Integer punishType,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType) {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<DjJlcfxxVo>> result = new RequsetData<>();
- result.setItem(partyTwoService.getJlcfxxList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, offenceType, punishType, beginTime, endTime, zzfbType));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getJlcfxx")
- public RequsetData<DjJlcfxx> getJlcfxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
- RequsetData<DjJlcfxx> res = new RequsetData<>();
- DjJlcfxx model = partyTwoService.getJlcfxx(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjJlcfxx();
- model.setId(uuid.toString());
- model.setDzzdm(dzzdm);
- model.setDzzmc(dzzmc);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveJlcfxx")
- public RequsetData<String> saveJlcfxx(@RequestBody DjJlcfxx model) {
- RequsetData<String> res = partyTwoService.saveJlcfxx(model);
- return res;
- }
- @ResponseBody
- @GetMapping("/delJlcfxx")
- public RequsetData<Integer> delJlcfxx(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delJlcfxx(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportJlcfxx", method = RequestMethod.GET)
- public void exportJlcfxx(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) Integer offenceType,
- @RequestParam(required = false) Integer punishType,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) Integer zzfbType) throws Exception {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<DjJlcfxxVo> dataList = partyTwoService.getJlcfxxList(1, 100000, dzzdm, dzzmc, username, rybm, offenceType, punishType, beginTime, endTime, zzfbType).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("党员受党的纪律处分信息");
- List<String> titles = new ArrayList();
- titles.add("姓名");
- titles.add("所属党组织");
- titles.add("批准日期");
- titles.add("处分类型");
- titles.add("违纪行为");
- titles.add("批准单位");
- titles.add("文号");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (DjJlcfxxVo item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.getUsername());
- row.add(item.getDzzmc());
- row.add(dateUtils.strFormat_short(item.getApprovaldate().toString()));
- row.add(item.getPunishtypename());
- row.add(item.getOffence());
- row.add(item.getUnit());
- row.add(item.getSymbol());
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "党员受党的纪律处分信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getTaskList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getTaskList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String taskUser,
- @RequestParam(required = false) String taskName,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) String userid,
- @RequestParam(required = false) String day,
- @RequestParam(required = false) Integer isreceive) {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getTaskList(pageIndex, pageSize, username, taskUser, taskName, beginTime, endTime, day, userid,isreceive));
- return result;
- }
- @ResponseBody
- @GetMapping("/getTaskUserList")
- public RequsetData<List<DjTaskusers>> getTaskUserList(@RequestParam(required = false) String taskid) {
- RequsetData<List<DjTaskusers>> result = new RequsetData<>();
- result.setItem(partyTwoService.getTaskUserList(taskid));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getTask")
- public RequsetData<DjTask> getTask(@RequestParam(required = false) String id) {
- RequsetData<DjTask> res = new RequsetData<>();
- DjTask model = partyTwoService.getTask(id);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjTask();
- model.setId(uuid.toString());
- model.setTasktime(new Date());
- model.setCreateuserid(userService.getLoginUser().getUserid());
- model.setCreateusername(userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
- }else{
- Map<String, Object> extdata=new HashMap<String, Object>();
- extdata.put("isReceiveTask",partyTwoService.isReceiveTask(id,userService.getLoginUser().getUserid()));
- res.setExtdata(extdata);
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @RequestMapping("/receiveTask")
- public RequsetData<Integer> receiveTask(@RequestParam(required = false) String id) {
- int count = partyTwoService.receiveTask(id, userService.getLoginUser().getUserid());
- RequsetData<Integer> res = new RequsetData<>();
- res.setItem(count);
- return res;
- }
- @ResponseBody
- @RequestMapping("/resetSubmit")
- public RequsetData<Integer> resetSubmit(@RequestParam(required = false) String id) {
- int count = partyTwoService.resetSubmit(id);
- RequsetData<Integer> res = new RequsetData<>();
- res.setItem(count);
- return res;
- }
- @ResponseBody
- @RequestMapping("/saveTask")
- public RequsetData<String> saveTask(@RequestBody Map<String, Object> reqMap) {
- RequsetData<String> res = new RequsetData<String>();
- int count = 0;
- String message = "";
- ObjectMapper mapper = new ObjectMapper();
- try {
- DjTask dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjTask.class);
- List<DjTaskusers> userList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<List<DjTaskusers>>() {
- });
- List<QtTaskpubcolumn> columnList =
- JsonMapper.jsonToObject(reqMap.get("columnList").toString(), new TypeReference<List<QtTaskpubcolumn>>() {
- });
- String flowId = reqMap.get("flowId").toString();
- count = partyTwoService.saveTask(dataModel, userList, columnList,userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
- } catch (Exception e) {
- e.printStackTrace();
- message = e.getMessage();
- }
- if (count > 0) {
- res.setSuccess(true);
- res.setMsg("操作成功!");
- } else {
- res.setSuccess(false);
- res.setMsg("操作失败!" + message);
- }
- return res;
- }
- @RequestMapping(value = "/exportTask", method = RequestMethod.GET)
- public void exportTask(HttpServletResponse response,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String taskUser,
- @RequestParam(required = false) String taskName,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) String userid,
- @RequestParam(required = false) String day) throws Exception {
- beginTime = dateUtils.strFormat_short(beginTime);
- endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getTaskList(1, 9999, username, taskUser, taskName, beginTime, endTime, day, userid,null).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("通知信息");
- List<String> titles = new ArrayList();
- titles.add("任务名称");
- titles.add("接收人");
- titles.add("下达时间");
- titles.add("截止时间");
- titles.add("发送部门");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("TASKNAME"));
- row.add(item.get("USERNAME"));
- row.add(dateUtils.strFormat_long(item.get("TASKTIME").toString()));
- row.add(dateUtils.strFormat_long(item.get("ENDTIME").toString()));
- row.add(item.get("SENDDEPART"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "任务信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/delTask")
- public RequsetData<Integer> delTask(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delTask(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @ResponseBody
- @GetMapping("/taskterminate")
- public RequsetData<Integer> taskterminate(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.terminateTask(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("终止失败!");
- } else {
- result.setMsg("终止成功!");
- }
- return result;
- }
- @ResponseBody
- @GetMapping("/getPartyTotalInfo")
- public RequsetData<HashMap<String, Object>> getPartyTotalInfo(@RequestParam("dzzdm") String dzzdm, @RequestParam("yearMonth") String yearMonth, @RequestParam("year") String year) {
- RequsetData<HashMap<String, Object>> result = new RequsetData<>();
- result.setItem(partyTwoService.getPartyTotalInfo(dzzdm, yearMonth, year));
- return result;
- }
- @ResponseBody
- @GetMapping("/getfundsBudgetList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getfundsBudgetList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) Integer year) {
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getfundsBudgetList(pageIndex, pageSize, dzzdm, dzzmc, year));
- return result;
- }
- @ResponseBody
- @RequestMapping("/getfundsBudget")
- public RequsetData<DjFundsbudget> getfundsBudget(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
- RequsetData<DjFundsbudget> res = new RequsetData<>();
- DjFundsbudget model = partyTwoService.getfundsBudget(id);
- Map<String, Object> map = new HashMap<>(10);
- if (model == null) {
- UUID uuid = UUID.randomUUID();
- model = new DjFundsbudget();
- model.setFundsbudgetid(uuid.toString());
- model.setPartycode(dzzdm);
- map.put("dzzmc", dzzmc);
- } else {
- map.put("dzzmc", partyService.getPartyByDm(dzzdm).getDzzmc());
- }
- res.setItem(model);
- res.setExtdata(map);
- return res;
- }
- @ResponseBody
- @RequestMapping("/savefundsBudget")
- public RequsetData<String> savefundsBudget(@RequestBody DjFundsbudget model) {
- RequsetData<String> res = partyTwoService.savefundsBudget(model);
- return res;
- }
- @ResponseBody
- @GetMapping("/delfundsBudget")
- public RequsetData<Integer> delfundsBudget(@RequestParam("id") String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.delfundsBudget(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @RequestMapping(value = "/exportfundsBudget", method = RequestMethod.GET)
- public void exportfundsBudget(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) Integer year) throws Exception {
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getfundsBudgetList(1, 100000, dzzdm, dzzmc, year).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("党组织工作经费预算信息");
- List<String> titles = new ArrayList();
- titles.add("所属党组织");
- titles.add("年度");
- titles.add("预算费用(万元)");
- titles.add("活动经费(万元)");
- titles.add("奖励经费(万元)");
- titles.add("去年实际支出(万元)");
- titles.add("与上年比增减(万元)");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("DZZMC"));
- row.add(item.get("YEAR"));
- row.add(item.get("BUDGETFUNDS"));
- row.add(item.get("ACTIVITYFUNDS"));
- row.add(item.get("REWARDFUNDS"));
- row.add(item.get("ACTUALEXPEND"));
- row.add(item.get("GRDATION"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "党组织工作经费预算信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getZtdrSummary")
- public RequsetData<PageInfo<HashMap<String, Object>>> getZtdrSummary(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String dzzdm, @RequestParam(required = false) Integer year) {
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getZtdrSummary(pageIndex, pageSize, dzzdm, year));
- return result;
- }
- @RequestMapping(value = "/exportZtdrSummary", method = RequestMethod.GET)
- public void exportZtdrSummary(HttpServletResponse response,
- @RequestParam(required = false) String dzzmc,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) Integer year) throws Exception {
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getZtdrSummary(1, 100000, dzzdm, year).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("党内生活统计信息");
- List<String> titles = new ArrayList();
- titles.add("所属党组织");
- titles.add("年度");
- titles.add("党员大会");
- titles.add("支委会");
- titles.add("党小组会");
- titles.add("党课");
- titles.add("主题党日");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("DZZMC"));
- row.add(item.get("YEAR"));
- row.add(item.get("党员大会"));
- row.add(item.get("支委会"));
- row.add(item.get("党小组会"));
- row.add(item.get("党课"));
- row.add(item.get("主题党日"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "党内生活统计信息.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getMzpyjgList")
- public RequsetData<List<HashMap<String, Object>>> getMzpyjgList() {
- RequsetData<List<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getMzpyjgList());
- return result;
- }
- @ResponseBody
- @GetMapping("/getMzpyxxList")
- public RequsetData<PageInfo<HashMap<String, Object>>> getMzpyxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) String pyjg) {
- // beginTime = dateUtils.strFormat_short(beginTime);
- // endTime = dateUtils.strFormat_short(endTime);
- RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
- result.setItem(partyTwoService.getMzpyxxList(pageIndex, pageSize, username, rybm, dzzdm, beginTime, endTime, pyjg));
- return result;
- }
- @RequestMapping(value = "/exportMzpyxx", method = RequestMethod.GET)
- public void exportMzpyxx(HttpServletResponse response,
- @RequestParam(required = false) String rybm,
- @RequestParam(required = false) String dzzdm,
- @RequestParam(required = false) String username,
- @RequestParam(required = false) String beginTime,
- @RequestParam(required = false) String endTime,
- @RequestParam(required = false) String pyjg) throws Exception {
- // beginTime = dateUtils.strFormat_short(beginTime);
- // endTime = dateUtils.strFormat_short(endTime);
- /**查询数据**/
- List<HashMap<String, Object>> dataList = partyTwoService.getMzpyxxList(1, 9999, username, rybm, dzzdm, beginTime, endTime, pyjg).getList();
- ExcelHelper excelHelper = new ExcelHelper();
- ExcelHelper.ExcelData data = excelHelper.new ExcelData();
- //列名
- data.setName("民主评议信息");
- List<String> titles = new ArrayList();
- titles.add("所属党组织");
- titles.add("姓名");
- titles.add("开展评议日期");
- titles.add("结束评议日期");
- titles.add("评议结果");
- data.setTitles(titles);
- //数据
- List<List<Object>> rows = new ArrayList();
- for (HashMap<String, Object> item : dataList) {
- List<Object> row = new ArrayList();
- row.add(item.get("DZZMC"));
- row.add(item.get("XM"));
- row.add(item.get("KZPYRQ"));
- row.add(item.get("JSPYRQ"));
- row.add(item.get("PYJGMC"));
- rows.add(row);
- }
- data.setRows(rows);
- excelHelper.exportExcel(response, "民主评议信息集.xlsx", data);
- }
- @ResponseBody
- @GetMapping("/getMzpyById")
- public RequsetData<ZzMzpyxxVo> getMzpyById(@RequestParam(required = false) String id) {
- RequsetData<ZzMzpyxxVo> res = new RequsetData<>();
- ZzMzpyxxVo model = partyTwoService.getMzpyById(id);
- if (model == null || (model != null && stringUtils.IsNullOrEmpty(model.getMzpyxxbs()))) {
- UUID uuid = UUID.randomUUID();
- model = new ZzMzpyxxVo();
- model.setMzpyxxbs(uuid.toString());
- }
- res.setItem(model);
- return res;
- }
- @ResponseBody
- @PostMapping("/saveMzpy")
- public RequsetData<String> saveMzpy(@RequestBody ZzMzpyxxVo data) {
- RequsetData<String> res = new RequsetData<String>();
- int count = partyTwoService.saveMzpy(data);
- if (count > 0) {
- res.setSuccess(true);
- res.setMsg("保存成功!");
- } else {
- res.setSuccess(false);
- res.setMsg("保存失败!");
- }
- return res;
- }
- @ResponseBody
- @GetMapping("/deleteMzpy")
- public RequsetData<Integer> deleteMzpy(String id) {
- RequsetData<Integer> result = new RequsetData<>();
- int row = partyTwoService.deleteMzpyById(id);
- result.setItem(row);
- if (row == 0) {
- result.setSuccess(false);
- result.setMsg("删除失败!");
- } else {
- result.setMsg("删除成功!");
- }
- return result;
- }
- @ResponseBody
- @GetMapping("/getleaderUserList")
- 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) {
- RequsetData<PageInfo<HashMap<String, Object>> > result = new RequsetData<>();
- result.setItem(partyTwoService.getleaderUserList(pageIndex,pageSize,username,usertype));
- return result;
- }
- @ResponseBody
- @RequestMapping("/importDnghbf")
- public RequsetData<List<Map<String, Object>>> importDnghbf(HttpServletResponse response,@RequestBody Map<String, Object> reqMap) {
- ArrayList<Map<String, Object>> dnghbflist = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<ArrayList<Map<String, Object>>>() {
- });
- RequsetData<List<Map<String, Object>>> result = new RequsetData<>();
- try {
- List<Map<String, Object>> errorInfo = partyTwoService.importDnghbf(dnghbflist);
- if (errorInfo.size() == 0) {
- result.setSuccess(true);
- result.setMsg("导入成功。");
- } else {
- result.setSuccess(false);
- result.setMsg("导入失败,详情请下载错误提示文件查看。");
- result.setItem(errorInfo);
- }
- } catch (Exception ex) {
- result.setSuccess(false);
- result.setMsg("导入失败," + ex.getMessage());
- }
- return result;
- }
- }
|