ExamineResultsController.java 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264
  1. package com.zhcs.dt.controller.information.examineResults;
  2. import java.text.SimpleDateFormat;
  3. import java.util.ArrayList;
  4. import java.util.Date;
  5. import java.util.HashMap;
  6. import java.util.List;
  7. import java.util.Map;
  8. import javax.annotation.Resource;
  9. import javax.servlet.http.HttpServletRequest;
  10. import org.springframework.stereotype.Controller;
  11. import org.springframework.web.bind.annotation.RequestBody;
  12. import org.springframework.web.bind.annotation.RequestMapping;
  13. import org.springframework.web.bind.annotation.ResponseBody;
  14. import org.springframework.web.servlet.ModelAndView;
  15. import com.zhcs.dt.controller.base.BaseController;
  16. import com.zhcs.dt.controller.information.annualPlan.ShowTableRecodUtil;
  17. import com.zhcs.dt.entity.Page;
  18. import com.zhcs.dt.service.information.annualPlan.impl.AnnualDailyCompService;
  19. import com.zhcs.dt.service.information.examineResults.ExamineResultsManager;
  20. import com.zhcs.dt.util.AppUtil;
  21. import com.zhcs.dt.util.Jurisdiction;
  22. import com.zhcs.dt.util.PageData;
  23. import net.sf.json.JSONArray;
  24. import net.sf.json.JSONObject;
  25. /**
  26. * 类名称:年度养护计划 创建人:Yuanf 创建时间:2018-11-12
  27. */
  28. @Controller
  29. @RequestMapping(value = "/examineResults")
  30. class ExamineResultsController extends BaseController {
  31. String menuUrl = "examineResults/list.do"; // 菜单地址(权限用)
  32. @Resource(name = "examineResultsService")
  33. private ExamineResultsManager examineResultsService;
  34. @Resource(name = "annualDailyCompService")
  35. private AnnualDailyCompService annualDailyCompService;
  36. private ShowTableRecodUtil showTableRecodUtil = new ShowTableRecodUtil();
  37. /**
  38. * 列表
  39. *
  40. * @param page
  41. * @throws Exception
  42. */
  43. @RequestMapping(value = "/list1")
  44. public ModelAndView list(Page page) throws Exception {
  45. logBefore(logger, Jurisdiction.getUsername() + "月度养护计划实施情况");
  46. // if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
  47. // //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
  48. ModelAndView mv = this.getModelAndView();
  49. PageData pd = new PageData();
  50. pd = this.getPageData();
  51. String keywords = pd.getString("keywords"); // 关键词检索条件
  52. if (null != keywords && !"".equals(keywords)) {
  53. pd.put("keywords", keywords.trim());
  54. }
  55. page.setPd(pd);
  56. List<PageData> varList = examineResultsService.list(page); // 列出Attached列表
  57. mv.setViewName("information/examineResults/examineResults_list");
  58. mv.addObject("varList", varList);
  59. mv.addObject("pd", pd);
  60. mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
  61. return mv;
  62. }
  63. /**
  64. *
  65. * @Title: getexamine
  66. * @Description: 养护计划考核
  67. * @param @return
  68. * @param @throws Exception
  69. * @return ModelAndView
  70. * @throws
  71. */
  72. @RequestMapping(value = "/list")
  73. public ModelAndView getexamine() throws Exception {
  74. logBefore(logger, Jurisdiction.getUsername() + "月度养护计划实施情况");
  75. ModelAndView mv = this.getModelAndView();
  76. PageData pd = new PageData();
  77. pd = this.getPageData();
  78. List<PageData> yearList = examineResultsService.queryAnnualPlanYear();
  79. pd.put("yearList", yearList);
  80. //年份默认第一条
  81. if(pd.get("year") == null && !yearList.isEmpty() )
  82. pd.put("year", yearList.get(0).get("year"));
  83. List<PageData> varList = examineResultsService.queryExamineResultByYear(pd);
  84. mv.setViewName("information/examineResults/examineResults_list");
  85. mv.addObject("varList", varList);
  86. mv.addObject("pd", pd);
  87. mv.addObject("year", pd.get("year"));
  88. mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
  89. return mv;
  90. }
  91. /**
  92. *
  93. * @Title: saveData
  94. * @Description: 保存
  95. * @param @param request
  96. * @param @param data
  97. * @param @return
  98. * @param @throws Exception
  99. * @return Object
  100. * @throws
  101. */
  102. @RequestMapping(value = "/saveData")
  103. @ResponseBody
  104. public Object saveData() throws Exception {
  105. PageData pd = new PageData();
  106. pd = this.getPageData();
  107. JSONArray jsonarray = JSONArray.fromObject(pd.get("data"));
  108. List<PageData> d = dealData(jsonarray);
  109. String year = pd.get("year").toString();
  110. PageData data = new PageData();
  111. data.put("year", year);
  112. data.put("data", d);
  113. examineResultsService.saveBatch(data);
  114. Map<String,String> map = new HashMap<String,String>();
  115. map.put("result", "success");
  116. return AppUtil.returnObject(new PageData(), map);
  117. }
  118. /**
  119. * 显示对应的报表列表
  120. *
  121. * @param
  122. * @throws Exception
  123. */
  124. @RequestMapping(value = "/goReport")
  125. public ModelAndView goReport() throws Exception {
  126. ModelAndView mv = this.getModelAndView();
  127. PageData pd = new PageData();
  128. pd = this.getPageData();
  129. mv.setViewName("information/monthProgress/monthProgress_list2");
  130. /*
  131. * mv.addObject("varList", varList); mv.addObject("pd", pd);
  132. */
  133. mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
  134. return mv;
  135. }
  136. /**
  137. * 显示、编辑子表格
  138. *
  139. * @param
  140. * @throws Exception
  141. */
  142. @RequestMapping(value = "/showTableRecod")
  143. public ModelAndView showTableRecod() throws Exception {
  144. ModelAndView mv = this.getModelAndView();
  145. PageData pd = new PageData();
  146. pd = this.getPageData();
  147. // List<PageData> varList = monthProgressService.findTableById(pd); //获取对应的表格列表
  148. mv.setViewName("information/monthProgress/monthProgress_edit");
  149. // mv.addObject("varList", varList);
  150. mv.addObject("pd", pd);
  151. mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
  152. return mv;
  153. }
  154. public List<PageData> dealData(JSONArray jsonarray) throws Exception {
  155. List<PageData> pdList = new ArrayList<PageData>();
  156. if (jsonarray.size() > 0) {
  157. for (int i = 0; i < jsonarray.size(); i++) {
  158. PageData pd = new PageData();
  159. JSONObject job = jsonarray.getJSONObject(i);
  160. pd.put("COMPANY_ID", job.get("COMPANY_ID"));
  161. pd.put("COMPANY", job.get("COMPANY"));
  162. pd.put("YEAR", job.get("YEAR"));
  163. pd.put("BZZL", job.get("BZZL"));
  164. pdList.add(pd);
  165. }
  166. }
  167. return pdList;
  168. }
  169. /* *//**
  170. * 显示、编辑子表格
  171. *
  172. * @param
  173. * @throws Exception
  174. */
  175. /*
  176. * @RequestMapping(value="/showTableRecod") public ModelAndView
  177. * showTableRecod()throws Exception{ ModelAndView mv = this.getModelAndView();
  178. * PageData pd = new PageData(); pd = this.getPageData(); List<PageData> varList
  179. * = monthProgressService.showTableRecod(pd); //根据ID读取
  180. * mv.setViewName("information/monthProgress/monthProgress_edit");
  181. * mv.addObject("varList", varList); mv.addObject("pd", pd);
  182. * mv.addObject("QX",Jurisdiction.getHC()); //按钮权限 return mv; }
  183. *
  184. *//**
  185. * 去新增页面
  186. *
  187. * @param
  188. * @throws Exception
  189. */
  190. /*
  191. * @RequestMapping(value="/goAdd") public ModelAndView goAdd()throws Exception{
  192. * ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd =
  193. * this.getPageData(); List<PageData> varList =
  194. * monthProgressService.getReportType(pd); //获取报告类型
  195. * mv.setViewName("information/monthProgress/monthProgress_add");
  196. * mv.addObject("varList", varList); mv.addObject("msg", "save");
  197. * mv.addObject("pd", pd); return mv; }
  198. *
  199. *//**
  200. * 保存
  201. *
  202. * @param
  203. * @throws Exception
  204. *//*
  205. * @RequestMapping(value="/save") public ModelAndView save() throws Exception{
  206. * logBefore(logger, Jurisdiction.getUsername()+"新增monthProgress");
  207. * if(!Jurisdiction.buttonJurisdiction(menuUrl, "add")){return null;} //校验权限
  208. * ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd =
  209. * this.getPageData(); pd.put("NAME",
  210. * pd.get("YEAR")+"年"+pd.get("COMPANY")+pd.get("REPORTTYPE")); pd.put("CTIME",
  211. * Tools.date2Str(new Date())); //创建时间 pd.put("MTIME", Tools.date2Str(new
  212. * Date())); //修改时间 pd.put("STATUS", "新建"); //创建时间
  213. * monthProgressService.saveAnnualPlan(pd); // pd =
  214. * annualPlanService.findById(pd); // Page page = new Page(); // List<PageData>
  215. * varList = annualPlanService.list(page); //列出annualPlan列表 //
  216. * mv.setViewName("information/annualPlan/annualPlan_list"); //
  217. * mv.addObject("varList", varList); mv.addObject("pd", pd);
  218. * mv.addObject("msg","success"); mv.setViewName("save_result"); return mv; }
  219. */
  220. /* *//**
  221. * 导出到excel
  222. *
  223. * @param
  224. * @throws Exception
  225. *//*
  226. * @RequestMapping(value="/excel") public ModelAndView exportExcel() throws
  227. * Exception{ logBefore(logger,
  228. * Jurisdiction.getUsername()+"导出annualPlan到excel");
  229. * if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
  230. * ModelAndView mv = new ModelAndView(); PageData pd = new PageData(); pd =
  231. * this.getPageData(); Map<String,Object> dataMap = new
  232. * HashMap<String,Object>(); List<String> titles = new ArrayList<String>();
  233. * titles.add("名称"); //1 titles.add("描述"); //2 titles.add("价格"); //3
  234. * titles.add("创建时间"); //4 dataMap.put("titles", titles); List<PageData>
  235. * varOList = annualPlanService.listAll(pd); List<PageData> varList = new
  236. * ArrayList<PageData>(); for(int i=0;i<varOList.size();i++){ PageData vpd = new
  237. * PageData(); vpd.put("var1", varOList.get(i).getString("NAME")); //1
  238. * vpd.put("var2", varOList.get(i).getString("FDESCRIBE")); //2 vpd.put("var3",
  239. * varOList.get(i).get("PRICE").toString()); //3 vpd.put("var4",
  240. * varOList.get(i).getString("CTIME")); //4 varList.add(vpd); }
  241. * dataMap.put("varList", varList); ObjectExcelView erv = new ObjectExcelView();
  242. * mv = new ModelAndView(erv,dataMap); return mv; }
  243. */
  244. }