package com.zhcs.dt.controller.information.examineResults;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.zhcs.dt.controller.base.BaseController;
import com.zhcs.dt.controller.information.annualPlan.ShowTableRecodUtil;
import com.zhcs.dt.entity.Page;
import com.zhcs.dt.service.information.annualPlan.impl.AnnualDailyCompService;
import com.zhcs.dt.service.information.examineResults.ExamineResultsManager;
import com.zhcs.dt.util.AppUtil;
import com.zhcs.dt.util.Jurisdiction;
import com.zhcs.dt.util.PageData;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

/**
 * 类名称：年度养护计划 创建人：Yuanf 创建时间：2018-11-12
 */
@Controller
@RequestMapping(value = "/examineResults")
class ExamineResultsController extends BaseController {
	String menuUrl = "examineResults/list.do"; // 菜单地址(权限用)
	@Resource(name = "examineResultsService")
	private ExamineResultsManager examineResultsService;
	@Resource(name = "annualDailyCompService")
	private AnnualDailyCompService annualDailyCompService;
	private ShowTableRecodUtil showTableRecodUtil = new ShowTableRecodUtil();

	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/list1")
	public ModelAndView list(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "月度养护计划实施情况");
		// if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
		// //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		String keywords = pd.getString("keywords"); // 关键词检索条件
		if (null != keywords && !"".equals(keywords)) {
			pd.put("keywords", keywords.trim());
		}
		page.setPd(pd);
		List<PageData> varList = examineResultsService.list(page); // 列出Attached列表
		mv.setViewName("information/examineResults/examineResults_list");
		mv.addObject("varList", varList);
		mv.addObject("pd", pd);
		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
		return mv;
	}

	
	/**
	 * 
	* @Title: getexamine
	* @Description: 养护计划考核
	* @param @return
	* @param @throws Exception
	* @return ModelAndView
	* @throws
	 */
	@RequestMapping(value = "/list")
	public ModelAndView getexamine() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "月度养护计划实施情况");
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		
		List<PageData> yearList = examineResultsService.queryAnnualPlanYear();
		pd.put("yearList", yearList);
		
		//年份默认第一条
		if(pd.get("year") == null && !yearList.isEmpty() ) 
			pd.put("year", yearList.get(0).get("year"));
		
		List<PageData> varList = examineResultsService.queryExamineResultByYear(pd);
		mv.setViewName("information/examineResults/examineResults_list");
		mv.addObject("varList", varList);
		mv.addObject("pd", pd);
		mv.addObject("year", pd.get("year"));
		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
		return mv;
	}

	/**
	 * 
	* @Title: saveData
	* @Description: 保存
	* @param @param request
	* @param @param data
	* @param @return
	* @param @throws Exception
	* @return Object
	* @throws
	 */
	@RequestMapping(value = "/saveData")
	@ResponseBody
	public Object saveData() throws Exception {
		
		PageData pd = new PageData();
		pd = this.getPageData();
		JSONArray jsonarray = JSONArray.fromObject(pd.get("data"));
		List<PageData> d = dealData(jsonarray);
		String year = pd.get("year").toString();
		PageData data = new PageData();
		data.put("year", year);
		data.put("data", d);
		examineResultsService.saveBatch(data);
		Map<String,String> map = new HashMap<String,String>();
		map.put("result", "success");
		return AppUtil.returnObject(new PageData(), map);
	}

	/**
	 * 显示对应的报表列表
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/goReport")
	public ModelAndView goReport() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		mv.setViewName("information/monthProgress/monthProgress_list2");
		/*
		 * mv.addObject("varList", varList); mv.addObject("pd", pd);
		 */
		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
		return mv;
	}

	/**
	 * 显示、编辑子表格
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/showTableRecod")
	public ModelAndView showTableRecod() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
//		List<PageData>	varList = monthProgressService.findTableById(pd);	//获取对应的表格列表
		mv.setViewName("information/monthProgress/monthProgress_edit");
//		mv.addObject("varList", varList);
		mv.addObject("pd", pd);
		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
		return mv;
	}
	
	public List<PageData> dealData(JSONArray jsonarray) throws Exception {
		List<PageData> pdList = new ArrayList<PageData>();
		if (jsonarray.size() > 0) {
			for (int i = 0; i < jsonarray.size(); i++) {
				PageData pd = new PageData();
				JSONObject job = jsonarray.getJSONObject(i);
				pd.put("COMPANY_ID", job.get("COMPANY_ID"));
				pd.put("COMPANY", job.get("COMPANY"));
				pd.put("YEAR", job.get("YEAR"));
				pd.put("BZZL", job.get("BZZL"));
				pdList.add(pd);
			}
		}
		return pdList;
	}

	/* *//**
			 * 显示、编辑子表格
			 * 
			 * @param
			 * @throws Exception
			 */
	/*
	 * @RequestMapping(value="/showTableRecod") public ModelAndView
	 * showTableRecod()throws Exception{ ModelAndView mv = this.getModelAndView();
	 * PageData pd = new PageData(); pd = this.getPageData(); List<PageData> varList
	 * = monthProgressService.showTableRecod(pd); //根据ID读取
	 * mv.setViewName("information/monthProgress/monthProgress_edit");
	 * mv.addObject("varList", varList); mv.addObject("pd", pd);
	 * mv.addObject("QX",Jurisdiction.getHC()); //按钮权限 return mv; }
	 * 
	 *//**
		 * 去新增页面
		 * 
		 * @param
		 * @throws Exception
		 */
	/*
	 * @RequestMapping(value="/goAdd") public ModelAndView goAdd()throws Exception{
	 * ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd =
	 * this.getPageData(); List<PageData> varList =
	 * monthProgressService.getReportType(pd); //获取报告类型
	 * mv.setViewName("information/monthProgress/monthProgress_add");
	 * mv.addObject("varList", varList); mv.addObject("msg", "save");
	 * mv.addObject("pd", pd); return mv; }
	 * 
	 *//**
		 * 保存
		 * 
		 * @param
		 * @throws Exception
		 *//*
			 * @RequestMapping(value="/save") public ModelAndView save() throws Exception{
			 * logBefore(logger, Jurisdiction.getUsername()+"新增monthProgress");
			 * if(!Jurisdiction.buttonJurisdiction(menuUrl, "add")){return null;} //校验权限
			 * ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd =
			 * this.getPageData(); pd.put("NAME",
			 * pd.get("YEAR")+"年"+pd.get("COMPANY")+pd.get("REPORTTYPE")); pd.put("CTIME",
			 * Tools.date2Str(new Date())); //创建时间 pd.put("MTIME", Tools.date2Str(new
			 * Date())); //修改时间 pd.put("STATUS", "新建"); //创建时间
			 * monthProgressService.saveAnnualPlan(pd); // pd =
			 * annualPlanService.findById(pd); // Page page = new Page(); // List<PageData>
			 * varList = annualPlanService.list(page); //列出annualPlan列表 //
			 * mv.setViewName("information/annualPlan/annualPlan_list"); //
			 * mv.addObject("varList", varList); mv.addObject("pd", pd);
			 * mv.addObject("msg","success"); mv.setViewName("save_result"); return mv; }
			 */

	/*	 *//**
			 * 导出到excel
			 * 
			 * @param
			 * @throws Exception
			 *//*
				 * @RequestMapping(value="/excel") public ModelAndView exportExcel() throws
				 * Exception{ logBefore(logger,
				 * Jurisdiction.getUsername()+"导出annualPlan到excel");
				 * if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
				 * ModelAndView mv = new ModelAndView(); PageData pd = new PageData(); pd =
				 * this.getPageData(); Map<String,Object> dataMap = new
				 * HashMap<String,Object>(); List<String> titles = new ArrayList<String>();
				 * titles.add("名称"); //1 titles.add("描述"); //2 titles.add("价格"); //3
				 * titles.add("创建时间"); //4 dataMap.put("titles", titles); List<PageData>
				 * varOList = annualPlanService.listAll(pd); List<PageData> varList = new
				 * ArrayList<PageData>(); for(int i=0;i<varOList.size();i++){ PageData vpd = new
				 * PageData(); vpd.put("var1", varOList.get(i).getString("NAME")); //1
				 * vpd.put("var2", varOList.get(i).getString("FDESCRIBE")); //2 vpd.put("var3",
				 * varOList.get(i).get("PRICE").toString()); //3 vpd.put("var4",
				 * varOList.get(i).getString("CTIME")); //4 varList.add(vpd); }
				 * dataMap.put("varList", varList); ObjectExcelView erv = new ObjectExcelView();
				 * mv = new ModelAndView(erv,dataMap); return mv; }
				 */

}