package com.hxzkoa.controller;

import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.hibernate.dialect.function.VarArgsSQLFunction;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

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;*/
import com.hxzkoa.util.Config;
import com.hxzkoa.util.ExcelUtils;
import com.hxzkoa.util.HttpUtil;
import com.hxzkoa.util.ModifyConfig;
import com.hxzkoa.util.PageUtil;
import com.hxzkoa.util.RequestUtils;

import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import net.sf.json.JSONObject;

@Controller
public class BasicInfoController {
	@Autowired
	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) {
		String toPage = "forward:/hxzk/basicInfo/iconManagement.jsp";
		List<tb_icon> iconManagementList = basicInfoService.getIconManagement(1);
		int count = basicInfoService.getIconManagementCount();
		int curPage = 1;
		request.setAttribute("iconManagementList", iconManagementList);
		int minPage = PageUtil.getMinPage(count);
		request.setAttribute("pageList", PageUtil.getPage(minPage));
		request.setAttribute("curPage", curPage);
		return toPage;
	}

	@ResponseBody
	@RequestMapping(value = "/iconManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
	public String iconManagement_page(HttpServletRequest request) {
		String pageStr = request.getParameter("page");
		String curPageStr = request.getParameter("curPage");
		int count = basicInfoService.getIconManagementCount();
		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_icon> iconManagementList = basicInfoService.getIconManagement(page);
		List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
		JSONObject json = new JSONObject();
		json.put("dataList", iconManagementList);
		json.put("pageList", pageList);
		json.put("curPage", page);
		return json.toString();
	}

	@RequestMapping(value = "/uploadIcon.do")
	public String upload(@RequestParam("file") MultipartFile[] files, HttpServletRequest request) {
		String toPage = "redirect:/iconManagement.do";
		String filePath1 = Config.getIconPath() + "/";
		String filePath2 = request.getServletContext().getRealPath("/") + "hxzk/image/targeticon/";
		try {
			File existFile1 = new File(filePath1);
			if (!existFile1.exists()) {
				existFile1.mkdir();
			}
			for (MultipartFile file : files) {
				file.transferTo(new File(filePath1 + file.getOriginalFilename()));
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		try {
			File existFile2 = new File(filePath2);
			if (!existFile2.exists()) {
				existFile2.mkdir();
			}
			for (MultipartFile file : files) {
				file.transferTo(new File(filePath2 + file.getOriginalFilename()));
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		return toPage;
	}

	@RequestMapping(value = "/iconManagement_add.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void iconManagement_add(HttpServletRequest request) {
		tb_icon icon = new tb_icon();
		icon.setIcon_name(request.getParameter("name"));
		icon.setIcon_adress("image/targeticon/" + request.getParameter("filePath"));
		icon.setBeizhu(request.getParameter("beizhu"));
		basicInfoService.iconManagement_add(icon);
	}

	@RequestMapping(value = "/iconManagement_check.do", method = { RequestMethod.POST, RequestMethod.GET })
	@ResponseBody
	public String iconManagement_check(HttpServletRequest request) {
		String iconName = (request.getParameter("name"));
		int exist = basicInfoService.iconManagement_check(iconName);
		return String.valueOf(exist);
	}

	@ResponseBody
	@RequestMapping(value = "/iconManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void iconManagement_delete(HttpServletRequest request) {
		String checkValStr = request.getParameter("checkVal");
		checkValStr = checkValStr.replaceAll("\"", "");
		String[] checkVal = checkValStr.split(",");
		basicInfoService.iconManagement_delete(checkVal);
	}

	@RequestMapping(value = "/departmentManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
	public String departmentManagement(HttpServletRequest request) {
		String toPage = "forward:/hxzk/basicInfo/departmentManagement.jsp";
		List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement(1);
		request.setAttribute("departmentManagementList", departmentManagementList);
		List<tb_icon> iconList = basicInfoService.getIconList();
		request.setAttribute("iconList", iconList);
		int curPage = 1;
		int count = basicInfoService.getDepartmentManagementCount();
		int minPage = PageUtil.getMinPage(count);
		request.setAttribute("pageList", PageUtil.getPage(minPage));
		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 })
	public String departmentManagement_page(HttpServletRequest request) {
		String pageStr = request.getParameter("page");
		String curPageStr = request.getParameter("curPage");
		int count = basicInfoService.getDepartmentManagementCount();
		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_department> departmentManagementList = basicInfoService.getDepartmentManagement(page);
		List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
		JSONObject json = new JSONObject();
		json.put("dataList", departmentManagementList);
		json.put("pageList", pageList);
		json.put("curPage", page);
		return json.toString();
	}

	@ResponseBody
	@RequestMapping(value = "/departmentManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
	public String departmentManagement_search(HttpServletRequest request) {
		String input = request.getParameter("input");
		int curPage = 1;
		List<Integer> pageList = new ArrayList<Integer>();
		List<tb_department> departmentManagementList = basicInfoService.searchDepartmentManagement(input);
		pageList.add(1);
		JSONObject json = new JSONObject();
		json.put("dataList", departmentManagementList);
		json.put("pageList", pageList);
		json.put("curPage", curPage);
		return json.toString();
	}

	@ResponseBody
	@RequestMapping(value = "/departmentManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void departmentManagement_delete(HttpServletRequest request) {
		String checkValStr = request.getParameter("checkVal");
		checkValStr = checkValStr.replaceAll("\"", "");
		String[] checkVal = checkValStr.split(",");
		basicInfoService.departmentManagement_delete(checkVal);
		for(int i = 0;i < checkVal.length;i++) {
			String xieyi = "BSTOCS1,DELETEBUMEN,"+checkVal[i]+",END";
			Udp_Out.udp_to_cs(xieyi);
		}
	}

	@ResponseBody
	@RequestMapping(value = "/departmentManagement_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void departmentManagement_deleteAll(HttpServletRequest request) {
		basicInfoService.departmentManagement_deleteAll();
		String xieyi = "BSTOCS1,DELETEALLBUMEN,END";
		Udp_Out.udp_to_cs(xieyi);
	}

	@RequestMapping(value = "/departmentManagement_add.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void departmentManagement_add(HttpServletRequest request) {
		tb_department department = new tb_department();
		department.setDepartmentName(request.getParameter("addName"));
		department.setIconadress(request.getParameter("addIcon"));
		basicInfoService.departmentManagement_add(department);
		String xieyi = "BSTOCS1,ADDBUMEN,"+department.getDepartmentName()+","+department.getIconadress()+",END";
		Udp_Out.udp_to_cs(xieyi);
	}

	@RequestMapping(value = "/departmentManagement_check.do", method = { RequestMethod.POST, RequestMethod.GET })
	@ResponseBody
	public String departmentManagement_check(HttpServletRequest request) {
		String name = (request.getParameter("name"));
		int exist = basicInfoService.departmentManagement_check(name);
		return String.valueOf(exist);
	}

	@RequestMapping(value = "/departmentManagement_modify.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void departmentManagement_modify(HttpServletRequest request) {
		tb_department department = new tb_department();
		department.setId(Integer.parseInt(request.getParameter("id")));
		department.setDepartmentName(request.getParameter("addName"));
		department.setIconadress(request.getParameter("addIcon"));
		basicInfoService.departmentManagement_modify(department);
		String xieyi = "BSTOCS1,ALTERBUMEN,"+department.getDepartmentName()+","+department.getIconadress()+",END";
		Udp_Out.udp_to_cs(xieyi);
	}

	// 对象转数组
	public static List<Object[]> objectToArray(List<tb_department> departmentManagementList) {
		List<Object[]> reList = new ArrayList<>();
		for (int i = 0; i < departmentManagementList.size(); i++) {
			List<String> words = new ArrayList<String>();
			tb_department department = (tb_department) departmentManagementList.get(i);
			words.add(department.getDepartmentName());
			words.add(department.getIconadress());
			words.add(String.valueOf(department.getAddtime()));
			String[] array = words.toArray(new String[0]);
			reList.add(array);
		}
		return reList;
	}

	@ResponseBody
	@RequestMapping(value = "/departmentManagement_export.do", method = { RequestMethod.POST, RequestMethod.GET })
	public String departmentManagement_export(HttpServletRequest request, HttpServletResponse response) {
		String toPage = "forward:/hxzk/basicInfo/departmentManagement.jsp";
		List<tb_department> departmentManagementList = basicInfoService.getDepartmentManagement();
		String[] rowName = { "部门名称", "图标预览", "添加时间" };
		List<Object[]> dataList = objectToArray(departmentManagementList);
		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 = "/personManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
	public String personManagement(HttpServletRequest request) {
		String toPage = "forward:/hxzk/basicInfo/personManagement.jsp";
		List<tb_person> personManagementList = basicInfoService.getPersonManagement(1);
		request.setAttribute("personManagementList", personManagementList);
		List<tb_department> departmentList = basicInfoService.getDepartmentList();
		request.setAttribute("departmentList", departmentList);
		int curPage = 1;
		int count = basicInfoService.getPersonManagementCount();
		int minPage = PageUtil.getMinPage(count);
		request.setAttribute("pageList", PageUtil.getPage(minPage));
		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 })
	public String personManagement_page(HttpServletRequest request) {
		String pageStr = request.getParameter("page");
		String curPageStr = request.getParameter("curPage");
		int count = basicInfoService.getPersonManagementCount();
		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.getPersonManagement(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_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 })
	public String personManagement_search(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.searchPersonManagement(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.searchPersonManagement(input);
			pageList.add(1);
			json.put("dataList", personManagementList);
			json.put("pageList", pageList);
			json.put("curPage", curPage);
		}
		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 })
	public void personManagement_delete(HttpServletRequest request) {
		String checkValStr = request.getParameter("checkVal");
		checkValStr = checkValStr.replaceAll("\"", "");
		String[] checkVal = checkValStr.split(",");
		for (int i = 0; i < checkVal.length; i++) {
			basicInfoService.personManagement_delete(checkVal[i]);
			String xieyi = "BSTOCS1,DELETEFPERSON,"+checkVal[i]+",END";
			Udp_Out.udp_to_cs(xieyi);
		}
		// 删除tb_person同时需要删除标签 
		labelService.labelManagement_delete(checkVal);
	}

	@ResponseBody
	@RequestMapping(value = "/personManagement_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void personManagement_deleteAll(HttpServletRequest request) {
		basicInfoService.personManagement_deleteAll();
		String xieyi = "BSTOCS1,DELETEALLPERSON,END";
		Udp_Out.udp_to_cs(xieyi);
		// 删除tb_person同时需要删除标签 
		labelService.labelManagement_deleteAll();
	}

	@RequestMapping(value = "/personManagement_modify.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void personManagement_modify(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"));
		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);
		// 修改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 = "/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) {
		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.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.getPersonManagement(1);
		request.setAttribute("personManagementList", personManagementList);
		List<tb_department> departmentList = basicInfoService.getDepartmentList();
		request.setAttribute("departmentList", departmentList);
		int curPage = 1;
		int count = basicInfoService.getPersonManagementCount();
		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 = "/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) {
		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_sex());
			words.add(person.getP_department());
			words.add(person.getP_phone());
			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[]> 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<>();
			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_sex());
				words.add(person.getP_department());
				words.add(person.getP_phone());
				String[] array = words.toArray(new String[0]);
				reList.add(array);
			}
			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 })
	public String personManagement_export(HttpServletRequest request, HttpServletResponse response) {
		String toPage = "forward:/hxzk/basicInfo/personmentManagement.jsp";
		List<tb_person> personList = basicInfoService.getPersonManagement();
		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_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";
		List<tb_person> personTemplateList = basicInfoService.getPersonManagementTemplate(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;
	}
	
	@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 {
		String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
		tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
		//显示sql
		String sqlString =  "UPDATE tb_person SET p_kaoqin = "+person.getP_kaoqing() +"WHERE p_tagid= +"+person.getP_tagid();
		String messageJson =  GetNowTime.timestamp2()+ " 收："+ sqlString ;
		String BaowenPath = Config.getBaowenConfig();
		String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
		if (baowenStatus.equals("1")){
			/* Udp_Receive.mysqlMessage.add(messageJson); */
		}
		//
		basicInfoService.person_modify_kaoqin(person);
	}
	@RequestMapping(value = "/person_bw_power.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void person_bw_power(HttpServletRequest request) throws IOException {
		String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
		tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
		//显示sql
		String sqlString =  "UPDATE tb_person SET p_kaoqin = "+person.getP_kaoqing() +"WHERE p_tagid= +"+person.getP_tagid();
		String messageJson =  GetNowTime.timestamp2()+ " 收："+ sqlString ;
		String BaowenPath = Config.getBaowenConfig();
		String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
		if (baowenStatus.equals("1")){
			/* Udp_Receive.mysqlMessage.add(messageJson); */
		}
		//
		basicInfoService.person_modify_power(person);
	}
	
	@RequestMapping(value = "/person_bw_SOS.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void person_bw_SOS(HttpServletRequest request) throws IOException {
		String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
		tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
		//显示sql
		String sqlString =  "UPDATE tb_person SET p_sos = "+person.getP_sos() +"WHERE p_tagid= +"+person.getP_tagid();
		String messageJson =  GetNowTime.timestamp2()+ " 收："+ sqlString ;
		String BaowenPath = Config.getBaowenConfig();
		String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
		if (baowenStatus.equals("1")){
			/* Udp_Receive.mysqlMessage.add(messageJson); */
		}
		//
		basicInfoService.person_modify_sos(person);
	}
	
	@RequestMapping(value = "/person_bw_warning.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void person_bw_warning(HttpServletRequest request) throws IOException {
		String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
		tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
		//显示sql
		String sqlString =  "UPDATE tb_person SET p_sos = "+person.getP_sos() +"WHERE p_tagid= +"+person.getP_tagid();
		String messageJson =  GetNowTime.timestamp2()+ " 收："+ sqlString ;
		String BaowenPath = Config.getBaowenConfig();
		String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
		if (baowenStatus.equals("1")){
			/* Udp_Receive.mysqlMessage.add(messageJson); */
		}
		//
		basicInfoService.person_modify_warning(person);
	}
	
	@RequestMapping(value = "/person_bw_XYF.do", method = { RequestMethod.POST, RequestMethod.GET })
	public void person_bw_XYF(HttpServletRequest request) throws IOException {
		String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
		tb_person person = (tb_person) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_person.class);
		//显示sql
		String sqlString =  "UPDATE tb_person SET p_x = "+person.getP_x()+",p_y = "+person.getP_y()+",p_floor = "+person.getP_floor()+"WHERE p_tagid= "+person.getP_tagid();
		String messageJson =  GetNowTime.timestamp2()+ " 收："+ sqlString ;
		String BaowenPath = Config.getBaowenConfig();
		String baowenStatus = ModifyConfig.readData(BaowenPath, "baowenSwitch");
		if (baowenStatus.equals("1")){
			/* Udp_Receive.mysqlMessage.add(messageJson); */
		}
		//
		basicInfoService.person_modify_XYF(person);
	}

}