package cn.ksource.web.controller.tj;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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

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

import org.apache.axis.client.HappyClient;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import cn.ksource.beans.CMDB_CI_BASE;
import cn.ksource.beans.SPARE_PART;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.JsonUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.WebUtil;
import cn.ksource.web.Constants;
import cn.ksource.web.facade.bpbj.SparePartsFacade;
import cn.ksource.web.facade.customermanage.CustomerManageFacade;
import cn.ksource.web.facade.tj.CiStatisFacade;
import cn.ksource.web.facade.tj.SparePartStatisFacade;

@RequestMapping("/business/pages/tj/sparePartStatis/")
@Controller
public class sparePartStatisController {
	@Resource
	private SparePartStatisFacade sparePartStatisfacade;
	
	@Resource
	private CustomerManageFacade customerFacade;
    @Resource
    private SparePartsFacade sparePartsFacade;
	
	/**
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value="spareTypeChart.html",method=RequestMethod.GET)
	public String spareTypeChart(Model model,HttpServletRequest request,HttpServletResponse response) {
		return "/business/pages/tj/sparePartStatis/spareTypeChart";
	}
	
	/**
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value="spareCountChart.html",method=RequestMethod.GET)
	public String ciTypetj(Model model,HttpServletRequest request,HttpServletResponse response) {
		List lv1List = sparePartStatisfacade.getSpareCategoryList( null);
		model.addAttribute("lv1List", lv1List);
		return "/business/pages/tj/sparePartStatis/spareCountChart";
	}

	/**
	 * 获取设备分类下拉列表
	 * @param request
	 * @param response
	 */
	@RequestMapping("getCategotyList.html")
	public void getCategotyList(HttpServletRequest request,HttpServletResponse response){
		String lv1Id = request.getParameter("lv1Id");
		List list = sparePartStatisfacade.getSpareCategoryList(lv1Id);
		WebUtil.write(response, JsonUtil.list2Json(list));
	}
	/**
	 * 备品备件出入库统计
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value="deliveryTypetj.html",method=RequestMethod.GET)
	public String deliveryTypetj(Model model,HttpServletRequest request,HttpServletResponse response) {
		String endYear = DateUtil.getToday("yyyy");
		model.addAttribute("lastYear", Integer.valueOf(endYear)-1);
		model.addAttribute("year", Integer.valueOf(endYear));
		model.addAttribute("flowYear", Integer.valueOf(endYear)-2);
		return "/business/pages/tj/sparePartStatis/deliveryTypetj";
	}
	/**
	 * 
	 * @param model
	 * @param request
	 * @param response
	 */
	@RequestMapping(value="deliveryDatatj.html",method=RequestMethod.POST)
	public void deliveryDatatj(Model model,HttpServletRequest request,HttpServletResponse response){
	
        String cate_id = request.getParameter("cate_id");
		String year = request.getParameter("year");
		String beginTime= "";
		String endTime = "";
		//List<List> series = new ArrayList<List>();
		List<Map> series = new ArrayList<Map>();
		List<Integer> rksls = new ArrayList<Integer>();
		List<Integer> cksls = new ArrayList<Integer>();
		List<Integer> slsls = new ArrayList<Integer>();
		  Map rk=new HashMap();
		  Map ck=new HashMap();
		  Map sl=new HashMap();
		  
		for(int i=1;i<12;i++){
			String month="";
			if(i<10){
				month ="0"+i;
			}else{
			    month=String.valueOf(i);
			}
			beginTime=year+month+"00";
			endTime = year+month+"33";
		   List<Map> list = sparePartStatisfacade.getSpareTableTypeChart(cate_id,beginTime,endTime,"bjcrktj");
		   if(list!=null){
			   for(Map map:list){
				   Integer rksl=Integer.valueOf(ConvertUtil.obj2StrBlank(map.get("rksl")));
				   Integer cksl=Integer.valueOf(ConvertUtil.obj2StrBlank(map.get("cksl")));
				   Integer slsl=Integer.valueOf(ConvertUtil.obj2StrBlank(map.get("slsl")));
				   rksls.add(rksl);
				   cksls.add(cksl);
				   slsls.add(slsl);
			   }
		   }
		}
		rk.put("name", "入库数量");
		rk.put("data", rksls);
		
		ck.put("name", "出库数量");
		ck.put("data", cksls);
		
		sl.put("name", "申领数量");
		sl.put("data", slsls);
		series.add(rk);
		series.add(ck);
		series.add(sl);
		System.out.print(JsonUtil.obj2Json(series));
		
		WebUtil.write(response,JsonUtil.obj2Json(series));
	}
	/**
	 * 
	 * @param model
	 * @param request
	 * @param response
	 */
	@RequestMapping(value="spareTypeChart.html",method=RequestMethod.POST)
	public void ciTypeChart(Model model,HttpServletRequest request,HttpServletResponse response){
		String lv1Id = request.getParameter("lv1Id");
		String lv2Id = request.getParameter("lv2Id");
		String queryType = request.getParameter("queryType");
		List<Map> resMap = sparePartStatisfacade.getCiTypeChart(lv1Id,lv2Id,queryType);
		System.out.print(JsonUtil.list2Json(resMap));
		WebUtil.write(response, JsonUtil.list2Json(resMap));
	}
	/**
	 * 备品备件数量统计报表
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("spareTypeTableIndex.html")
	public String spareTypeTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
		Long currentTime = DateUtil.getCurrentDate8();
		String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
		model.addAttribute("beginTime", last1MonthTime);
		model.addAttribute("endTime",  currentTime);
		return "/business/pages/tj/sparePartStatis/spareTypeTableIndex";
	}
	/**
	 * 备品备件数量统计数据
	 * @param model
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("spareTypeTableData.html")
	public String ciTypeTable(Model model,HttpServletRequest request,HttpServletResponse response){
		String cate_id = request.getParameter("cate_id");
		String beginTime = request.getParameter("beginTime");
		String endTime = request.getParameter("endTime");
		List list = sparePartStatisfacade.getSpareTableTypeChart(cate_id,beginTime,endTime,"bjsltj");
		model.addAttribute("resMap", list);
		return "/business/pages/tj/sparePartStatis/spareTypeTableData";
	}
		/**
		 * 备件申领统计
		 * @param request
		 * @param response
		 * @return
		 */
		@RequestMapping("stockTypetj.html")
		public String stockTypetj(Model model,HttpServletRequest request,HttpServletResponse response){
			Long currentTime = DateUtil.getCurrentDate8();
			String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
			model.addAttribute("beginTime", last1MonthTime);
			model.addAttribute("endTime",  currentTime);
			//项目列表
		    List<Map> cusList = sparePartsFacade.getCustomerList();
		    model.addAttribute("customers", cusList);
		    List lv1List = sparePartStatisfacade.getSpareCategoryList( null);
			model.addAttribute("lv1List", lv1List);
			return "/business/pages/tj/sparePartStatis/stockTypetj";
		}
		/**
		 * 备件申领统计数据
		 * @param model
		 * @param request
		 * @param response
		 */
		@RequestMapping(value="stockTypeDatetj.html",method=RequestMethod.POST)
		public void stockTypeDatatj(Model model,HttpServletRequest request,HttpServletResponse response){
			Map chartMap = sparePartStatisfacade.incidentInfluenceCol(request);
			WebUtil.write(response, JsonUtil.map2Json(chartMap));
		}
	
	  /**
		 * 项目备件申领统计
		 * @param request
		 * @param response
		 * @return
		 */
		@RequestMapping("projectSpareTableIndex.html")
		public String projectSpareTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
			Long currentTime = DateUtil.getCurrentDate8();
			String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
			model.addAttribute("beginTime", last1MonthTime);
			model.addAttribute("endTime",  currentTime);
			//项目列表
			  List<Map> cusList = sparePartsFacade.getCustomerList();
			  model.addAttribute("customers", cusList);
			return "/business/pages/tj/sparePartStatis/projectSpareTableIndex";
		}
		/**
		 * 项目备件申领统计数据
		 * @param model
		 * @param request
		 * @param response
		 * @return
		 */
		@RequestMapping("projectSpareTableData.html")
		public String projectSpareTableData(Model model,HttpServletRequest request,HttpServletResponse response){
			String customer_id = request.getParameter("customer_id");
			String beginTime = request.getParameter("beginTime");
			String endTime = request.getParameter("endTime");
			List list = sparePartStatisfacade.getProjectSpareTableTypeChart(customer_id,beginTime,endTime);
			model.addAttribute("resMap", list);
			return "/business/pages/tj/sparePartStatis/projectSpareTableData";
		}
		
		 /**
		 * 供应商统计
		 * @param request
		 * @param response
		 * @return
		 */
		@RequestMapping("supplierSpareCountTableIndex.html")
		public String SupplierSpareCountTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
			Long currentTime = DateUtil.getCurrentDate8();
			String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
			model.addAttribute("beginTime", last1MonthTime);
			model.addAttribute("endTime",  currentTime);
			//项目列表
			  List<Map> cusList = sparePartsFacade.getCustomerList();
			  model.addAttribute("customers", cusList);
			return "/business/pages/tj/sparePartStatis/supplierSpareCountTableIndex";
		}
		/**
		 * 供应商统计数据
		 * @param model
		 * @param request
		 * @param response
		 * @return
		 */
		@RequestMapping("supplierSpareCountTableData.html")
		public String supplierSpareCountTableData(Model model,HttpServletRequest request,HttpServletResponse response){
			String cate_id = request.getParameter("cate_id");
			String beginTime = request.getParameter("beginTime");
			String endTime = request.getParameter("endTime");
			String pxtj = request.getParameter("pxtj");
			String pxlx = request.getParameter("pxlx");
			List list = sparePartStatisfacade.getSupplierSpareTableTypeChart(cate_id,beginTime,endTime,pxtj,pxlx);
			model.addAttribute("resMap", list);
			return "/business/pages/tj/sparePartStatis/supplierSpareCountTableData";
		}
		
	/**
	 * 备件明细报表
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("spareSpartTableIndex.html")
	public String spareSpartTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
		Long currentTime = DateUtil.getCurrentDate8();
		String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
		model.addAttribute("beginTime", last1MonthTime);
		model.addAttribute("endTime",  currentTime);
		//项目列表
	    List<Map> cusList = sparePartsFacade.getCustomerList();
	    model.addAttribute("customers", cusList);
	  //供应商
	    List<Map> supplierList = sparePartsFacade.getSupplierList();
	    model.addAttribute("supplierList", supplierList);
		return "/business/pages/tj/sparePartStatis/spareSpartTableIndex";
	}
	/**
	 * 备件明细报表
	 * @param model
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("spareSpartTableData.html")
	public String spareSpartTableData(Model model,HttpServletRequest request,HttpServletResponse response){
		List<Map> ciList = sparePartStatisfacade.getSpareMainufacturerChart(request);
		if(ciList!=null && ciList.size()>0){
			for(Map map:ciList){
				String  ciId = ConvertUtil.obj2StrBlank(map.get("ID"));
				Map baseMsg = new SPARE_PART(ciId).getBeanMapById();
				//查询所有扩展数据的信息，以Map形式返回
				Map resultMap = sparePartStatisfacade.queryStorageData(ciId);
				Map data = (Map)resultMap.get("data");
				Map label = (Map)resultMap.get("label");
				map.put("baseMsg", baseMsg);
	//			map.put("groupProps", groupProps);
				map.put("dataAll", data);
				map.put("labelAll", label);
				
			}
			String cate_id=request.getParameter("cate_id");
			if(StringUtil.isNotBlank(cate_id)){
				List groupProps = sparePartStatisfacade.queryGroupPropsTwo(cate_id);
				model.addAttribute("groupProps", groupProps);
			}
			Map props = sparePartStatisfacade.queryCommonProps(cate_id);
			model.addAttribute("props", props);
			model.addAttribute("ciList", ciList);
		}
		
		
		return "/business/pages/tj/sparePartStatis/spareSpartTableData";
	}
	
	
	/**
	 * 加盟商设备报表
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("/ciMainufacturerTableIndex.html")
	public String ciMainufacturerTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
		List cusList = customerFacade.getCusList();
		
		Map<String,String> MainufacturerfMap = Constants.CMDB_MAINUFACTURER_MAP;
		List MainufacturerfList = new ArrayList<Map>();
		for(String key : MainufacturerfMap.keySet()){
			Map tempMap = new HashMap();
			tempMap.put("id", key);
			tempMap.put("value", MainufacturerfMap.get(key));
			MainufacturerfList.add(tempMap);
		}
		model.addAttribute("cusList", cusList);
		model.addAttribute("MainufacturerfList", MainufacturerfList);
		return "/business/pages/tj/ciStatis/ciMainufacturerTableIndex";
	}
	
}