FHlogController.java 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. package com.zhcs.dt.controller.system.fhlog;
  2. import java.io.PrintWriter;
  3. import java.text.DateFormat;
  4. import java.text.SimpleDateFormat;
  5. import java.util.ArrayList;
  6. import java.util.Date;
  7. import java.util.HashMap;
  8. import java.util.List;
  9. import java.util.Map;
  10. import javax.annotation.Resource;
  11. import org.springframework.beans.propertyeditors.CustomDateEditor;
  12. import org.springframework.stereotype.Controller;
  13. import org.springframework.web.bind.WebDataBinder;
  14. import org.springframework.web.bind.annotation.InitBinder;
  15. import org.springframework.web.bind.annotation.RequestMapping;
  16. import org.springframework.web.bind.annotation.ResponseBody;
  17. import org.springframework.web.servlet.ModelAndView;
  18. import com.zhcs.dt.controller.base.BaseController;
  19. import com.zhcs.dt.entity.Page;
  20. import com.zhcs.dt.service.system.fhlog.FHlogManager;
  21. import com.zhcs.dt.util.AppUtil;
  22. import com.zhcs.dt.util.Jurisdiction;
  23. import com.zhcs.dt.util.ObjectExcelView;
  24. import com.zhcs.dt.util.PageData;
  25. /**
  26. * 说明:操作日志记录
  27. * 创建人:FH Q313596790
  28. * 创建时间:2016-05-10
  29. */
  30. @Controller
  31. @RequestMapping(value="/fhlog")
  32. public class FHlogController extends BaseController {
  33. String menuUrl = "fhlog/list.do"; //菜单地址(权限用)
  34. @Resource(name="fhlogService")
  35. private FHlogManager fhlogService;
  36. /**删除
  37. * @param out
  38. * @throws Exception
  39. */
  40. @RequestMapping(value="/delete")
  41. public void delete(PrintWriter out) throws Exception{
  42. logBefore(logger, Jurisdiction.getUsername()+"删除FHlog");
  43. if(!Jurisdiction.buttonJurisdiction(menuUrl, "del")){return;} //校验权限
  44. PageData pd = new PageData();
  45. pd = this.getPageData();
  46. fhlogService.delete(pd);
  47. out.write("success");
  48. out.close();
  49. }
  50. /**列表
  51. * @param page
  52. * @throws Exception
  53. */
  54. @RequestMapping(value="/list")
  55. public ModelAndView list(Page page) throws Exception{
  56. logBefore(logger, Jurisdiction.getUsername()+"列表FHlog");
  57. //if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;} //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
  58. ModelAndView mv = this.getModelAndView();
  59. PageData pd = new PageData();
  60. pd = this.getPageData();
  61. String keywords = pd.getString("keywords"); //关键词检索条件
  62. if(null != keywords && !"".equals(keywords)){
  63. pd.put("keywords", keywords.trim());
  64. }
  65. String lastStart = pd.getString("lastStart"); //开始时间
  66. String lastEnd = pd.getString("lastEnd"); //结束时间
  67. if(lastStart != null && !"".equals(lastStart)){
  68. pd.put("lastStart", lastStart+" 00:00:00");
  69. }
  70. if(lastEnd != null && !"".equals(lastEnd)){
  71. pd.put("lastEnd", lastEnd+" 00:00:00");
  72. }
  73. page.setPd(pd);
  74. List<PageData> varList = fhlogService.list(page); //列出FHlog列表
  75. mv.setViewName("system/fhlog/fhlog_list");
  76. mv.addObject("varList", varList);
  77. mv.addObject("pd", pd);
  78. mv.addObject("QX",Jurisdiction.getHC()); //按钮权限
  79. return mv;
  80. }
  81. /**批量删除
  82. * @param
  83. * @throws Exception
  84. */
  85. @RequestMapping(value="/deleteAll")
  86. @ResponseBody
  87. public Object deleteAll() throws Exception{
  88. logBefore(logger, Jurisdiction.getUsername()+"批量删除FHlog");
  89. if(!Jurisdiction.buttonJurisdiction(menuUrl, "del")){return null;} //校验权限
  90. PageData pd = new PageData();
  91. Map<String,Object> map = new HashMap<String,Object>();
  92. pd = this.getPageData();
  93. List<PageData> pdList = new ArrayList<PageData>();
  94. String DATA_IDS = pd.getString("DATA_IDS");
  95. if(null != DATA_IDS && !"".equals(DATA_IDS)){
  96. String ArrayDATA_IDS[] = DATA_IDS.split(",");
  97. fhlogService.deleteAll(ArrayDATA_IDS);
  98. pd.put("msg", "ok");
  99. }else{
  100. pd.put("msg", "no");
  101. }
  102. pdList.add(pd);
  103. map.put("list", pdList);
  104. return AppUtil.returnObject(pd, map);
  105. }
  106. /**导出到excel
  107. * @param
  108. * @throws Exception
  109. */
  110. @RequestMapping(value="/excel")
  111. public ModelAndView exportExcel() throws Exception{
  112. logBefore(logger, Jurisdiction.getUsername()+"导出FHlog到excel");
  113. if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
  114. ModelAndView mv = new ModelAndView();
  115. PageData pd = new PageData();
  116. pd = this.getPageData();
  117. Map<String,Object> dataMap = new HashMap<String,Object>();
  118. List<String> titles = new ArrayList<String>();
  119. titles.add("用户名"); //1
  120. titles.add("操作时间"); //2
  121. titles.add("事件"); //3
  122. dataMap.put("titles", titles);
  123. List<PageData> varOList = fhlogService.listAll(pd);
  124. List<PageData> varList = new ArrayList<PageData>();
  125. for(int i=0;i<varOList.size();i++){
  126. PageData vpd = new PageData();
  127. vpd.put("var1", varOList.get(i).getString("USERNAME")); //1
  128. vpd.put("var2", varOList.get(i).getString("CZTIME")); //2
  129. vpd.put("var3", varOList.get(i).getString("CONTENT")); //3
  130. varList.add(vpd);
  131. }
  132. dataMap.put("varList", varList);
  133. ObjectExcelView erv = new ObjectExcelView();
  134. mv = new ModelAndView(erv,dataMap);
  135. return mv;
  136. }
  137. @InitBinder
  138. public void initBinder(WebDataBinder binder){
  139. DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
  140. binder.registerCustomEditor(Date.class, new CustomDateEditor(format,true));
  141. }
  142. }