3.7

fxl

2023-03-07 52cffc4ab8e9787a6f233295502c7c9788dddae1

 src/main/java/com/hxzkoa/controller/BasicInfoController.java

@@ -21,11 +21,13 @@
import com.hxzkoa.json.tb_department;
import com.hxzkoa.json.tb_icon;
import com.hxzkoa.json.tb_led;
import com.hxzkoa.json.tb_nav;
import com.hxzkoa.json.tb_person;
import com.hxzkoa.json.tb_realkaoqing;
import com.hxzkoa.json.tb_tag;
import com.hxzkoa.services.BasicInfoService;
import com.hxzkoa.services.LabelService;
import com.hxzkoa.services.ZhwService;
import com.hxzkoa.udp.GetNowTime;
import com.hxzkoa.udp.Udp_Out;
/*import com.hxzkoa.udp.Udp_Receive;*/
@@ -47,6 +49,8 @@
   private BasicInfoService basicInfoService;
   @Autowired
   private LabelService labelService;
   @Autowired
   private ZhwService zhwService;

   @RequestMapping(value = "/iconManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String iconManagement(HttpServletRequest request) {
@@ -160,6 +164,17 @@
      request.setAttribute("curPage", curPage);
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/jiedepartment.do", method = { RequestMethod.POST, RequestMethod.GET })
   public JSONObject jiedepartment(HttpServletRequest request) {
      JSONObject json = new JSONObject();
      List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement2();
      List<tb_nav> navList = zhwService.getnav();
      json.put("dataList", departmentManagementList);
      json.put("dataList2", navList);
      return json;
   }

   @ResponseBody
   @RequestMapping(value = "/departmentManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -308,6 +323,51 @@
      request.setAttribute("curPage", curPage);
      return toPage;
   }
	
   @RequestMapping(value = "/cheliangManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String cheliangManagement(HttpServletRequest request) {
      String toPage = "forward:/hxzk/basicInfo/cheliangManagement.jsp";
      List<tb_person> personManagementList = basicInfoService.getPersonManagement2(1);
      request.setAttribute("personManagementList", personManagementList);
      List<tb_department> departmentList = basicInfoService.getDepartmentList();
      request.setAttribute("departmentList", departmentList);
      int curPage = 1;
      int count = basicInfoService.getPersonManagementCount2();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      return toPage;
   }
	
   @RequestMapping(value = "/wuziManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String wuziManagement(HttpServletRequest request) {
      String toPage = "forward:/hxzk/basicInfo/wuziManagement.jsp";
      List<tb_person> personManagementList = basicInfoService.getPersonManagement3(1);
      request.setAttribute("personManagementList", personManagementList);
      List<tb_department> departmentList = basicInfoService.getDepartmentList();
      request.setAttribute("departmentList", departmentList);
      int curPage = 1;
      int count = basicInfoService.getPersonManagementCount3();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      return toPage;
   }
	
   @RequestMapping(value = "/personManagement2.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement2(HttpServletRequest request) {
      String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
      List<tb_person> personManagementList = basicInfoService.getPersonManagement4(1);
      request.setAttribute("personManagementList", personManagementList);
      List<tb_department> departmentList = basicInfoService.getDepartmentList();
      request.setAttribute("departmentList", departmentList);
      int curPage = 1;
      int count = basicInfoService.getPersonManagementCount4();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      return toPage;
   }

   @ResponseBody
   @RequestMapping(value = "/personManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -337,6 +397,93 @@
      json.put("curPage", page);
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_page2.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_page2(HttpServletRequest request) {
      String pageStr = request.getParameter("page");
      String curPageStr = request.getParameter("curPage");
      int count = basicInfoService.getPersonManagementCount2();
      int minPage = PageUtil.getMinPage(count);
      int curPage = Integer.parseInt(curPageStr);
      int page = 1;
      if ("pre".equals(pageStr)) {
         if (curPage > 1) {
            page = curPage - 1;
         }
      } else if ("next".equals(pageStr)) {
         if (curPage < minPage) {
            page = curPage + 1;
         }
      } else {
         page = Integer.parseInt(pageStr);
      }
      List<tb_person> personManagementList = basicInfoService.getPersonManagement2(page);
      List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
      JSONObject json = new JSONObject();
      json.put("dataList", personManagementList);
      json.put("pageList", pageList);
      json.put("curPage", page);
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_page3.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_page3(HttpServletRequest request) {
      String pageStr = request.getParameter("page");
      String curPageStr = request.getParameter("curPage");
      int count = basicInfoService.getPersonManagementCount3();
      int minPage = PageUtil.getMinPage(count);
      int curPage = Integer.parseInt(curPageStr);
      int page = 1;
      if ("pre".equals(pageStr)) {
         if (curPage > 1) {
            page = curPage - 1;
         }
      } else if ("next".equals(pageStr)) {
         if (curPage < minPage) {
            page = curPage + 1;
         }
      } else {
         page = Integer.parseInt(pageStr);
      }
      List<tb_person> personManagementList = basicInfoService.getPersonManagement3(page);
      List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
      JSONObject json = new JSONObject();
      json.put("dataList", personManagementList);
      json.put("pageList", pageList);
      json.put("curPage", page);
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_page4.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_page4(HttpServletRequest request) {
      String pageStr = request.getParameter("page");
      String curPageStr = request.getParameter("curPage");
      int count = basicInfoService.getPersonManagementCount4();
      int minPage = PageUtil.getMinPage(count);
      int curPage = Integer.parseInt(curPageStr);
      int page = 1;
      if ("pre".equals(pageStr)) {
         if (curPage > 1) {
            page = curPage - 1;
         }
      } else if ("next".equals(pageStr)) {
         if (curPage < minPage) {
            page = curPage + 1;
         }
      } else {
         page = Integer.parseInt(pageStr);
      }
      List<tb_person> personManagementList = basicInfoService.getPersonManagement4(page);
      List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
      JSONObject json = new JSONObject();
      json.put("dataList", personManagementList);
      json.put("pageList", pageList);
      json.put("curPage", page);
      return json.toString();
   }

   @ResponseBody
   @RequestMapping(value = "/personManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -364,6 +511,87 @@
      }
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_search2.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_search2(HttpServletRequest request) throws IOException {
      JSONObject json = new JSONObject();
      String input = request.getParameter("input");
      if (("").equals(input) || input == null) {
         String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
         tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
         input = tag.getTag_id();
         List<tb_person> personManagementList = basicInfoService.searchPersonManagement2(input);
         if (personManagementList.size()>0){
            json.put("result", personManagementList.get(0));
         } else {
            json.put("result", "null");
         }
      } else {
         int curPage = 1;
         List<Integer> pageList = new ArrayList<Integer>();
         List<tb_person> personManagementList = basicInfoService.searchPersonManagement2(input);
         pageList.add(1);
         json.put("dataList", personManagementList);
         json.put("pageList", pageList);
         json.put("curPage", curPage);
      }
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_search3.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_search3(HttpServletRequest request) throws IOException {
      JSONObject json = new JSONObject();
      String input = request.getParameter("input");
      if (("").equals(input) || input == null) {
         String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
         tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
         input = tag.getTag_id();
         List<tb_person> personManagementList = basicInfoService.searchPersonManagement3(input);
         if (personManagementList.size()>0){
            json.put("result", personManagementList.get(0));
         } else {
            json.put("result", "null");
         }
      } else {
         int curPage = 1;
         List<Integer> pageList = new ArrayList<Integer>();
         List<tb_person> personManagementList = basicInfoService.searchPersonManagement3(input);
         pageList.add(1);
         json.put("dataList", personManagementList);
         json.put("pageList", pageList);
         json.put("curPage", curPage);
      }
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_search4.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_search4(HttpServletRequest request) throws IOException {
      JSONObject json = new JSONObject();
      String input = request.getParameter("input");
      if (("").equals(input) || input == null) {
         String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
         tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
         input = tag.getTag_id();
         List<tb_person> personManagementList = basicInfoService.searchPersonManagement4(input);
         if (personManagementList.size()>0){
            json.put("result", personManagementList.get(0));
         } else {
            json.put("result", "null");
         }
      } else {
         int curPage = 1;
         List<Integer> pageList = new ArrayList<Integer>();
         List<tb_person> personManagementList = basicInfoService.searchPersonManagement4(input);
         pageList.add(1);
         json.put("dataList", personManagementList);
         json.put("pageList", pageList);
         json.put("curPage", curPage);
      }
      return json.toString();
   }

   @ResponseBody
   @RequestMapping(value = "/personManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -398,6 +626,8 @@
      person.setP_name(request.getParameter("p_name"));
      person.setP_sex(request.getParameter("p_sex"));
      person.setP_phone(request.getParameter("p_phone"));
//    List<tb_department> departments = basicInfoService.searchDepartmentManagement(request.getParameter("p_department"));
//    person.setP_image(departments.get(0).getIconadress());
      basicInfoService.personManagement_modify(person);
      String xieyi = "BSTOCS1,ALTERPERSON,"+person.getP_name()+","+person.getP_tagid()+","+person.getP_sex()+","+person.getP_department()+","+person.getP_phone()+",END";
      Udp_Out.udp_to_cs(xieyi);
@@ -409,6 +639,24 @@
         labelService.labelManagement_modify(tag);
      }
   }
	
   @RequestMapping(value = "/personManagement_modify2.do", method = { RequestMethod.POST, RequestMethod.GET })
   public void personManagement_modify2(HttpServletRequest request) {
      tb_person person = new tb_person();
      person.setP_tagid(request.getParameter("p_tagid"));
      person.setP_department(request.getParameter("p_department"));
      person.setP_name(request.getParameter("p_name"));
      basicInfoService.personManagement_modify2(person);
      String xieyi = "BSTOCS1,ALTERCAR,"+person.getP_name()+","+person.getP_tagid()+","+person.getP_department()+",END";
      Udp_Out.udp_to_cs(xieyi);
      // 修改tb_person同时需要修改标签 需要先查再改否则覆盖空
      List<tb_tag> searchLabelManagement = labelService.searchLabelManagement(person.getP_tagid());
      if(searchLabelManagement!=null){
         tb_tag tag = searchLabelManagement.get(0);
         tag.setState(person.getP_name());
         labelService.labelManagement_modify(tag);
      }
   }

   @RequestMapping(value = "/uploadPerson.do")
   public String uploadPerson(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
@@ -477,6 +725,214 @@
      file.delete();
      return toPage;
   }
	
   @RequestMapping(value = "/uploadPerson2.do")
   public String uploadPerson2(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
      String toPage = "forward:/hxzk/basicInfo/cheliangManagement.jsp";
      String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
      String filename = files[0].getOriginalFilename();
      try {
         File existFile = new File(filePath);
         if (!existFile.exists()) {
            existFile.mkdir();
         }
         for (MultipartFile file : files) {
            file.transferTo(new File(filePath + file.getOriginalFilename()));
            ////System.out.print(file.getOriginalFilename());
         }
      } catch (IOException e) {
         e.printStackTrace();
      }
      int result = 0;
      String path = filePath + filename;
      // 选取Excel文件得到工作薄
      Workbook workbook;
      try {
         File file = new File(path);
         workbook = Workbook.getWorkbook(file);
         // 选择工作表，通过Workbook的getSheet方法选择第一个工作表（从0开始）
         Sheet sheet = workbook.getSheet(0);
         int rows = sheet.getRows();
         // 选择Cell，读取单元格 通过Sheet的getCell方法选择位置为C2的单元格（两个参数都从0开始）
         for (int i = 3; i < rows; i++) {
            // 读取信息，通过Cell的getContents方法读取单元格的值把单元格中的信息以字符的形式读取出来
            String p_name = sheet.getCell(0, i).getContents();
            String p_tagid = sheet.getCell(1, i).getContents();
            String p_sex = "";
            String p_department = sheet.getCell(2, i).getContents();
            String p_phone = "";
            if (!("").equals(p_tagid)) {
               tb_person person = new tb_person();
               person.setP_name(p_name);
               person.setP_tagid(p_tagid);
               person.setP_sex(p_sex);
               person.setP_department(p_department);
               person.setP_phone(p_phone);
               basicInfoService.personManagement_add(person);
               result = 1;
            }
         }
         // 释放资源
         workbook.close();
      } catch (BiffException e) {
         e.printStackTrace();
      } catch (IOException e) {
         e.printStackTrace();
      }
      request.setAttribute("resultList", result);
      List<tb_person> personManagementList = basicInfoService.getPersonManagement2(1);
      request.setAttribute("personManagementList", personManagementList);
      List<tb_department> departmentList = basicInfoService.getDepartmentList();
      request.setAttribute("departmentList", departmentList);
      int curPage = 1;
      int count = basicInfoService.getPersonManagementCount2();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      File file = new File(path);
      file.delete();
      return toPage;
   }
	
   @RequestMapping(value = "/uploadPerson3.do")
   public String uploadPerson3(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
      String toPage = "forward:/hxzk/basicInfo/wuziManagement.jsp";
      String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
      String filename = files[0].getOriginalFilename();
      try {
         File existFile = new File(filePath);
         if (!existFile.exists()) {
            existFile.mkdir();
         }
         for (MultipartFile file : files) {
            file.transferTo(new File(filePath + file.getOriginalFilename()));
            ////System.out.print(file.getOriginalFilename());
         }
      } catch (IOException e) {
         e.printStackTrace();
      }
      int result = 0;
      String path = filePath + filename;
      // 选取Excel文件得到工作薄
      Workbook workbook;
      try {
         File file = new File(path);
         workbook = Workbook.getWorkbook(file);
         // 选择工作表，通过Workbook的getSheet方法选择第一个工作表（从0开始）
         Sheet sheet = workbook.getSheet(0);
         int rows = sheet.getRows();
         // 选择Cell，读取单元格 通过Sheet的getCell方法选择位置为C2的单元格（两个参数都从0开始）
         for (int i = 3; i < rows; i++) {
            // 读取信息，通过Cell的getContents方法读取单元格的值把单元格中的信息以字符的形式读取出来
            String p_name = sheet.getCell(0, i).getContents();
            String p_tagid = sheet.getCell(1, i).getContents();
            String p_sex = "";
            String p_department = sheet.getCell(2, i).getContents();
            String p_phone = "";
            if (!("").equals(p_tagid)) {
               tb_person person = new tb_person();
               person.setP_name(p_name);
               person.setP_tagid(p_tagid);
               person.setP_sex(p_sex);
               person.setP_department(p_department);
               person.setP_phone(p_phone);
               basicInfoService.personManagement_add(person);
               result = 1;
            }
         }
         // 释放资源
         workbook.close();
      } catch (BiffException e) {
         e.printStackTrace();
      } catch (IOException e) {
         e.printStackTrace();
      }
      request.setAttribute("resultList", result);
      List<tb_person> personManagementList = basicInfoService.getPersonManagement3(1);
      request.setAttribute("personManagementList", personManagementList);
      List<tb_department> departmentList = basicInfoService.getDepartmentList();
      request.setAttribute("departmentList", departmentList);
      int curPage = 1;
      int count = basicInfoService.getPersonManagementCount3();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      File file = new File(path);
      file.delete();
      return toPage;
   }
	
   @RequestMapping(value = "/uploadPerson4.do")
   public String uploadPerson4(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
      String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
      String filePath = request.getServletContext().getRealPath("/") + "hxzk\\upload\\";
      String filename = files[0].getOriginalFilename();
      try {
         File existFile = new File(filePath);
         if (!existFile.exists()) {
            existFile.mkdir();
         }
         for (MultipartFile file : files) {
            file.transferTo(new File(filePath + file.getOriginalFilename()));
            ////System.out.print(file.getOriginalFilename());
         }
      } catch (IOException e) {
         e.printStackTrace();
      }
      int result = 0;
      String path = filePath + filename;
      // 选取Excel文件得到工作薄
      Workbook workbook;
      try {
         File file = new File(path);
         workbook = Workbook.getWorkbook(file);
         // 选择工作表，通过Workbook的getSheet方法选择第一个工作表（从0开始）
         Sheet sheet = workbook.getSheet(0);
         int rows = sheet.getRows();
         // 选择Cell，读取单元格 通过Sheet的getCell方法选择位置为C2的单元格（两个参数都从0开始）
         for (int i = 3; i < rows; i++) {
            // 读取信息，通过Cell的getContents方法读取单元格的值把单元格中的信息以字符的形式读取出来
            String p_name = sheet.getCell(0, i).getContents();
            String p_tagid = sheet.getCell(1, i).getContents();
            String p_sex = sheet.getCell(2, i).getContents();
            String p_department = sheet.getCell(3, i).getContents();
            String p_phone = sheet.getCell(4, i).getContents();
            if (!("").equals(p_tagid)) {
               tb_person person = new tb_person();
               person.setP_name(p_name);
               person.setP_tagid(p_tagid);
               person.setP_sex(p_sex);
               person.setP_department(p_department);
               person.setP_phone(p_phone);
               basicInfoService.renyuandaoru(person);
               tb_tag tag = new tb_tag();
               tag.setState(p_name);
               tag.setTag_id(p_tagid);
               labelService.updatetagname(tag);
               result = 1;
            }
         }
         // 释放资源
         workbook.close();
      } catch (BiffException e) {
         e.printStackTrace();
      } catch (IOException e) {
         e.printStackTrace();
      }
      request.setAttribute("resultList", result);
      List<tb_person> personManagementList = basicInfoService.getPersonManagement4(1);
      request.setAttribute("personManagementList", personManagementList);
      List<tb_department> departmentList = basicInfoService.getDepartmentList();
      request.setAttribute("departmentList", departmentList);
      int curPage = 1;
      int count = basicInfoService.getPersonManagementCount4();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      File file = new File(path);
      file.delete();
      return toPage;
   }

   // 对象转数组
   public static List<Object[]> personobjectToArray(List<tb_person> personList) {
@@ -499,6 +955,24 @@
      return reList;
   }
   
   public static List<Object[]> personobjectToArray2(List<tb_person> personList) {
      List<Object[]> reList = new ArrayList<>();
      for (int i = 0; i < personList.size(); i++) {
         List<String> words = new ArrayList<String>();
         tb_person person = (tb_person) personList.get(i);
         words.add(String.valueOf(person.getId()));
         words.add(person.getP_name());
         words.add(person.getP_tagid());
         words.add(person.getP_department());
         words.add(person.getP_power());
         words.add(person.getP_image());
         words.add(person.getP_addtiem());
         String[] array = words.toArray(new String[0]);
         reList.add(array);
      }
      return reList;
   }
	
   // 对象转数组
      public static List<Object[]> personTemplateobjectToArray(List<tb_person> personList) {
         List<Object[]> reList = new ArrayList<>();
@@ -515,6 +989,20 @@
         }
         return reList;
      }
		
      public static List<Object[]> personTemplateobjectToArray2(List<tb_person> personList) {
         List<Object[]> reList = new ArrayList<>();
         for (int i = 0; i < personList.size(); i++) {
            List<String> words = new ArrayList<String>();
            tb_person person = (tb_person) personList.get(i);
            words.add(person.getP_name());
            words.add(person.getP_tagid());
            words.add(person.getP_department());
            String[] array = words.toArray(new String[0]);
            reList.add(array);
         }
         return reList;
      }

   @ResponseBody
   @RequestMapping(value = "/personManagement_export.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -541,6 +1029,78 @@
   }
   
   @ResponseBody
   @RequestMapping(value = "/personManagement_export2.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_export2(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/cheliangmentManagement.jsp";
      List<tb_person> personList = basicInfoService.getPersonManagement2();
      String[] rowName = { "序号", "车辆名称", "标签ID", "部门", "电量%", "图标", "添加时间" };
      List<Object[]> dataList = personobjectToArray2(personList);
      ExcelUtils excel = new ExcelUtils("车辆管理", rowName, dataList);
      OutputStream out;
      try {
         String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
         String headStr = "attachment; filename=\"" + fileName + "\"";
         response.setContentType("APPLICATION/OCTET-STREAM");
         response.setHeader("Content-Disposition", headStr);
         out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_export3.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_export3(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/wuzimentManagement.jsp";
      List<tb_person> personList = basicInfoService.getPersonManagement3();
      String[] rowName = { "序号", "物资名称", "标签ID", "部门", "电量%", "图标", "添加时间" };
      List<Object[]> dataList = personobjectToArray2(personList);
      ExcelUtils excel = new ExcelUtils("物资管理", rowName, dataList);
      OutputStream out;
      try {
         String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
         String headStr = "attachment; filename=\"" + fileName + "\"";
         response.setContentType("APPLICATION/OCTET-STREAM");
         response.setHeader("Content-Disposition", headStr);
         out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_export4.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_export4(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
      List<tb_person> personList = basicInfoService.getPersonManagement4();
      String[] rowName = { "序号", "姓名", "标签ID", "性别", "部门", "电话", "电量%", "图标", "添加时间" };
      List<Object[]> dataList = personobjectToArray(personList);
      ExcelUtils excel = new ExcelUtils("人员管理", rowName, dataList);
      OutputStream out;
      try {
         String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
         String headStr = "attachment; filename=\"" + fileName + "\"";
         response.setContentType("APPLICATION/OCTET-STREAM");
         response.setHeader("Content-Disposition", headStr);
         out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_exportTemplate.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_exportTemplate(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
@@ -564,6 +1124,77 @@
      return toPage;
   }
   
   @ResponseBody
   @RequestMapping(value = "/personManagement_exportTemplate2.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_exportTemplate2(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/cheliangmentManagement.jsp";
      List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate2(1);
      String[] rowName = { "车辆名称", "标签ID", "部门"};
      List<Object[]> dataList = personTemplateobjectToArray2(personTemplateList);
      ExcelUtils excel = new ExcelUtils("车辆管理", rowName, dataList);
      OutputStream out;
      try {
         String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
         String headStr = "attachment; filename=\"" + fileName + "\"";
         response.setContentType("APPLICATION/OCTET-STREAM");
         response.setHeader("Content-Disposition", headStr);
         out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_exportTemplate3.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_exportTemplate3(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/wuzimentManagement.jsp";
      List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate3(1);
      String[] rowName = { "物资名称", "标签ID", "部门"};
      List<Object[]> dataList = personTemplateobjectToArray2(personTemplateList);
      ExcelUtils excel = new ExcelUtils("物资管理", rowName, dataList);
      OutputStream out;
      try {
         String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
         String headStr = "attachment; filename=\"" + fileName + "\"";
         response.setContentType("APPLICATION/OCTET-STREAM");
         response.setHeader("Content-Disposition", headStr);
         out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/personManagement_exportTemplate4.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String personManagement_exportTemplate4(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
      List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate4(1);
      String[] rowName = { "姓名", "标签ID", "性别", "部门", "电话"};
      List<Object[]> dataList = personTemplateobjectToArray(personTemplateList);
      ExcelUtils excel = new ExcelUtils("人员管理", rowName, dataList);
      OutputStream out;
      try {
         String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
         String headStr = "attachment; filename=\"" + fileName + "\"";
         response.setContentType("APPLICATION/OCTET-STREAM");
         response.setHeader("Content-Disposition", headStr);
         out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      return toPage;
   }

   @RequestMapping(value = "/person_bw_kaoqin.do", method = { RequestMethod.POST, RequestMethod.GET })
   public void person_bw_kaoqin(HttpServletRequest request) throws IOException {