GSYH/WEB-INF/classes/com/zhcs/dt/controller/information/annualPlan/AnnualPlanController.java

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

import java.io.File;
import java.io.IOException;
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 net.sf.json.JSONArray;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;

import com.alibaba.fastjson.JSON;
import com.zhcs.dt.controller.base.BaseController;
import com.zhcs.dt.entity.Page;
import com.zhcs.dt.service.information.annualPlan.AnnualPlanManager;
import com.zhcs.dt.service.information.annualPlan.ImportDoc;
import com.zhcs.dt.util.AppUtil;
import com.zhcs.dt.util.Jurisdiction;
import com.zhcs.dt.util.PageData;
import com.zhcs.dt.util.Tools;

/** 
 * 类名称：年度养护计划
 * 创建人：Yuanf
 * 创建时间：2018-11-12
 */
@Controller
@RequestMapping(value="/annualPlan")
class AnnualPlanController extends BaseController {
	//String menuUrl = "annualPlan/list.do"; //菜单地址(权限用)
	@Resource(name="annualPlanService")
	private AnnualPlanManager annualPlanService;
	List<String> newTables = new ArrayList<String>();
	String[] tabls = {"annual_plan_list","annual_plan_comp_list","annual_report_list","annual_table_list",
			"highway_prevention_project_dettable","highway_repair_project_dettable","highway_test_project_dettable",
			"highway_scientific_project_dettable","highway_equipment_overhaul_project_dettable","highway_special_project_dettable",
			"highway_technica_statable","highway_traiffcinfo_sumtable","highway_daily_plan_statable",
			"highway_prevention_project_dettable_cost","highway_repair_project_dettable_cost","highway_scientific_project_dettable_cost",
			"highway_special_project_dettable_cost","highway_test_project_dettable_cost","modify_info_record",
			"highway_emergency_project_dettable","highway_emergency_project_dettable_cost",
			"highway_reserve_fees_sumtable","highway_reserve_fees_sumtable_total",
			"monthly_daily_completion","monthly_daily_report_list",
			"monthly_emergency_completion","monthly_report_list",
			"monthly_equipment_overhaul_completion","monthly_equipment_overhaul_report_list",
			"monthly_prevention_completion","monthly_prevention_report_list",
			"monthly_repair_completion","monthly_repair_report_list",
			"monthly_scientific_project_completion","monthly_scientific_report_list",
			"monthly_special_completion","monthly_special_report_list",
			"monthly_test_project_completion","monthly_test_report_list","monthly_plan_record",
			"highway_technica_statable","highway_traiffcinfo_sumtable","highway_quality_goals_table"};
	
	/**列表
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value="/list")
	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.put("USERNAME", Jurisdiction.getUsername().toString());
		//通过username获取对应的公司和路段，控股集团管理员只可以看到状态为“待审批”和“已完成”的计划，路公司管理员和路段管理员可以看到本公司所有计划,admin没有权限控制
		PageData userInfo = annualPlanService.getCompanyAndRoad(Jurisdiction.getUsername().toString());	//通过username获取公司和路段
		System.out.println("^^^^^^^^^^^^^^COMPANY:"+userInfo.get("COMPANY").toString());
		//通过ROLE_ID获取角色
		String roleName = annualPlanService.getRoleName(userInfo.get("ROLE_ID").toString());
		pd = this.getPageData();
		String keywords = pd.getString("keywords");				//关键词检索条件
		if(null != keywords && !"".equals(keywords)){
			pd.put("keywords", keywords.trim());
		}
		List<PageData>	varList = new ArrayList<PageData>();
		if(!"控股集团管理员".equalsIgnoreCase(roleName)){
			pd.put("COMPANY", userInfo.get("COMPANY"));
			varList = annualPlanService.getPlanList(pd);	//列出年度计划列表
			mv.setViewName("information/annualPlan/annualPlan_list");
			mv.addObject("varList", varList);
		}else{
			//varList = annualPlanService.getKGPlanList(pd);	//列出年度计划列表
			List<String> yearList = annualPlanService.getKGPlanYearList(pd);	//列出状态不为编制中、新建的年度计划列表
			mv.setViewName("information/annualPlan/annualPlan_kg_list");
			mv.addObject("varList", yearList);
		}
		mv.addObject("pd", pd);
		mv.addObject("userInfo", userInfo);
		mv.addObject("roleName", roleName);
		mv.addObject("QX",Jurisdiction.getHC());	//按钮权限
		return mv;
	}
	
	 /**显示对应的报表列表
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/goReport")
	public ModelAndView goReport(Model model)throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		//List<PageData>	varList = annualPlanService.findTableById(pd);	//获取对应的表格列表
		List<PageData>	varList = annualPlanService.findReportById(pd);	//获取对应的报表列表
		JSONArray arr = JSONArray.fromObject(varList);
		String json = arr.toString();
//		json = json.replaceAll("MENU_ID", "id").replaceAll("PARENT_ID", "pId").replaceAll("MENU_NAME", "name").replaceAll("subMenu", "nodes").replaceAll("hasMenu", "checked").replaceAll("MENU_URL", "url");
		model.addAttribute("zTreeNodes", json);
//		mv.addObject("MENU_ID",MENU_ID);
		mv.setViewName("information/annualPlan/annualPlan_report_list");
		mv.addObject("varList", varList);
		mv.addObject("pd", pd);
		mv.addObject("QX",Jurisdiction.getHC());	//按钮权限
		return mv;
	}
	
	 /**显示对应的子表格列表
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/goSonTable")
	public ModelAndView goSonTable()throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		List<PageData>	varList = annualPlanService.findTableById(pd);	//获取对应的表格列表
		mv.setViewName("information/annualPlan/annualPlan_list");
		mv.addObject("varList", varList);
		mv.addObject("pd", pd);
		mv.addObject("QX",Jurisdiction.getHC());	//按钮权限
		return mv;
	}
	
	 /**查询显示报告列表和表格列表
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/showReportAndTable")
	public ModelAndView showReportAndTable(Model model)throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		//String planID = pd.getString("ID");
		String planStatus = annualPlanService.getPlanStatus(pd);	//根据year\company_id查询当前plan状态
		pd.put("STATUS", planStatus);
		List<PageData>	varList = annualPlanService.showReportList(pd);	//根据PLANID读取相关report信息
		if(pd.get("ROLENAME").toString().equalsIgnoreCase("路段管理员")){
			List<PageData> reportList = new ArrayList<PageData>();
			String[] roads = pd.get("ROAD").toString().split(",");
			for(int i = 0; i < roads.length; i++){
				for(PageData reportInfo : varList){
					if(reportInfo.get("ROAD_NAME") != null){
						if(reportInfo.get("ROAD_NAME").toString().trim().equalsIgnoreCase(roads[i].trim())){
							reportList.add(reportInfo);
						}
					}
				}
			}
			varList = reportList;
		}else{
			List<PageData>	subReportList = new ArrayList<PageData>();
			for(PageData var : varList){
				if(var.get("ROAD_ID") == null){
					mv.addObject("reportInfo", var);
				}else{
					subReportList.add(var);
				}
			}
			varList = subReportList;
		}
//		JSONArray arr = JSONArray.fromObject(varList);
//		String json = arr.toString();
//		json = json.replaceAll("ID", "id").replaceAll("PLANID", "pId").replaceAll("NAME", "name");
//		model.addAttribute("zTreeNodes", json);
		
		String reportid = null;
		String reportName = null;
		//用于显示界面右边表格信息
		List<PageData>	vartableList = null;
		if(pd.get("REPORTID") != null){
			for(PageData var : varList){
				if(var.get("ID").toString().equalsIgnoreCase(pd.get("REPORTID").toString())){
					reportName = var.get("NAME").toString();
				}
			}
			vartableList = annualPlanService.getTableList(pd);	//根据reportID读取相关table信息	
			mv.addObject("selectReport", reportName);
		}else{
			for(PageData reportpd : varList){
				reportid = reportpd.getString("ID");
				reportName = reportpd.getString("NAME");
				if(reportName.indexOf("年度养护计划分报告") > 0){
					pd.put("REPORTID", reportid);
					pd.put("ROAD_ID", reportpd.get("ROAD_ID"));
					pd.put("ROAD", reportpd.get("ROAD_NAME"));
					vartableList = annualPlanService.getTableList(pd);	//根据reportID读取相关table信息	
					mv.addObject("selectReport", reportName);
					Object rcStatus = "编制中";
					for(PageData tpd : vartableList){
						if(tpd.get("NAME") != null){
							if(tpd.get("NAME").toString().contains("日常养护计划统计表")){
								rcStatus = tpd.get("STATUS");
								mv.addObject("rcStatus", rcStatus);
							}
						}
					}
					break;
				}
			}
		}
		mv.setViewName("information/annualPlan/annualPlan_report_list");
		mv.addObject("varList", varList);
		mv.addObject("vartableList", vartableList);
		mv.addObject("pd", pd);
		mv.addObject("QX",Jurisdiction.getHC());	//按钮权限
		return mv;
	}
	
		/**查询显示表格列表
		 * @param
		 * @throws Exception
		 */
		@RequestMapping(value="/getTableListInfoReport")
		@ResponseBody
		public Object getTableListInfoReport()throws Exception{
			Map<String,Object> map = new HashMap<String,Object>();
			String errInfo = "success";
			PageData pd = new PageData();
			pd = this.getPageData();
			List<PageData>  vartableList = annualPlanService.getTableList(pd);	//根据reportID读取相关table信息	
			List<PageData> pdList = new ArrayList<PageData>();
			PageData picpd = new PageData();
			for(PageData tpd :vartableList){
				PageData pdf = new PageData();
				pdf.put("NAME", tpd.get("NAME"));
				pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
				picpd.put("COMPANY_ID", tpd.get("COMPANY_ID"));
				pdf.put("COMPANY_NAME", tpd.get("COMPANY_NAME"));
				pdf.put("YEAR", tpd.get("YEAR"));
				picpd.put("YEAR", tpd.get("YEAR"));
				pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
				pdf.put("ROAD_NAME", tpd.get("ROAD_NAME"));
				pdf.put("TYPE", tpd.get("TYPE"));
				pdf.put("CTIME", tpd.get("CTIME"));
				pdf.put("MTIME", tpd.get("MTIME"));
				pdf.put("STATUS", tpd.get("STATUS"));
				pdList.add(pdf);
			}
			map.put("list", pdList);
			map.put("result", errInfo);				//返回结果
			List<PageData>  picList = annualPlanService.getPictureList(picpd);	//根据reportID读取相关table信息	
			map.put("picList", picList);
			return AppUtil.returnObject(new PageData(), map);
		}
	 /**查询显示表格列表
	 * @param
	 * @throws Exception
	 * zhangyn 2019.3.20修改
	 */
	@RequestMapping(value="/getTableListInfo")
	@ResponseBody
	public Object getTableListInfo()throws Exception{
		Map<String,Object> map = new HashMap<String,Object>();
		String errInfo = "success";
		PageData pd = new PageData();
		pd = this.getPageData();
		
//		List<PageData>  vartableList_new = annualPlanService.getTableList(pd);	//根据reportID读取相关table信息	
//		System.out.println("vartableList_new"+vartableList_new);
		String planStatus = annualPlanService.getPlanStatus(pd);   //获取年计划状态		
		pd.put("TYPE", "highway_annual_plan_sumtable");
		String  highwayplanStatus = annualPlanService.getTableListRC(pd);  //高速公路年度养护计划汇总表
		pd.put("TYPE", "highway_daily_plan_statable");
		String  rcStatus = annualPlanService.getTableListRC(pd);
		//获取基本信息的三张表状态值
		pd.put("TYPE", "highway_technica_statable");   //高速公路道路技术状况现状统计表
		String  baseStatus1 = annualPlanService.getTableListRC(pd);
		pd.put("TYPE", "highway_traiffcinfo_sumtable");   //高速公路交通等信息综合统计表
		String  baseStatus2 = annualPlanService.getTableListRC(pd);
		pd.put("TYPE", "highway_quality_goals_table");   //高速公路养护质量目标表
		String  baseStatus3 = annualPlanService.getTableListRC(pd);
		
		pd.put("TYPE", "highway_prevention_project_dettable");
		pd.put("PROJECT_NAME", "高速公路预防养护计划立项详表---");
		List<PageData>  vartableList = annualPlanService.getTableListYFYH(pd);
		
		
		List<PageData> pdListPrevent = new ArrayList<PageData>();
		for(PageData tpd :vartableList){
			PageData pdf = new PageData();
			if(tpd.get("PROJECT_NAME") !=null && !tpd.get("PROJECT_NAME").equals("")) {
				pdf.put("PROJECT_NAME", tpd.get("PROJECT_NAME"));
			}else{
				pdf.put("PROJECT_NAME", "");
			}
			if(tpd.get("CATEGORY") !=null && !tpd.get("CATEGORY").equals("")) {
				pdf.put("CATEGORY", tpd.get("CATEGORY"));
			}else {
				pdf.put("CATEGORY","");
			}
			if(tpd.get("PROJECT_SCALE") !=null && !tpd.get("PROJECT_SCALE").equals("")) {
				pdf.put("PROJECT_SCALE", tpd.get("PROJECT_SCALE"));
			}else {
				pdf.put("PROJECT_SCALE","");
			}
			if(tpd.get("QUANTITIES") !=null && !tpd.get("QUANTITIES").equals("")) {
				pdf.put("QUANTITIES", tpd.get("QUANTITIES"));
			}else {
				pdf.put("QUANTITIES", "");
			}
			if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")) {
				pdf.put("PROJECT_COST", tpd.get("PROJECT_COST"));
			}else {
				pdf.put("PROJECT_COST", "");
			}
			if("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus)){
				if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("")){
					pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
				}else{
					pdf.put("AUDIT_FEE", tpd.get("PROJECT_COST"));
				}
			}else{
				pdf.put("AUDIT_FEE", "");
			}
//			if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
//				pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
//			}else {
//				pdf.put("AUDIT_FEE", "");
//			}
			if(tpd.get("AUDIT_MAKER") !=null && !tpd.get("AUDIT_MAKER").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("AUDIT_MAKER", tpd.get("AUDIT_MAKER"));
			}else {
				pdf.put("AUDIT_MAKER", "");
			}
			if(tpd.get("STATUS") !=null && !tpd.get("STATUS").equals("")) {
				pdf.put("STATUS", tpd.get("STATUS"));
			}else {
				pdf.put("STATUS", "");
			}
			
			pdf.put("NAME", tpd.get("NAME"));
			pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
			pdf.put("COMPANY", tpd.get("COMPANY"));
			pdf.put("YEAR", tpd.get("YEAR"));
			pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
			pdf.put("ROAD", tpd.get("ROAD"));
			
			pdListPrevent.add(pdf);
		}
		
		pd.put("TYPE", "highway_repair_project_dettable");
		pd.put("PROJECT_NAME", "高速公路修复养护计划立项详表---");
		List<PageData>  xfvartableList = annualPlanService.getTableListYFYH(pd);
		
		List<PageData> pdListRepair = new ArrayList<PageData>();
		for(PageData tpd :xfvartableList){
			PageData pdf = new PageData();
			if(tpd.get("PROJECT_NAME") !=null && !tpd.get("PROJECT_NAME").equals("")) {
				pdf.put("PROJECT_NAME", tpd.get("PROJECT_NAME"));
			}else{
				pdf.put("PROJECT_NAME", "");
			}
			if(tpd.get("CATEGORY") !=null && !tpd.get("CATEGORY").equals("")) {
				pdf.put("CATEGORY", tpd.get("CATEGORY"));
			}else {
				pdf.put("CATEGORY","");
			}
			if(tpd.get("PROJECT_SCALE") !=null && !tpd.get("PROJECT_SCALE").equals("")) {
				pdf.put("PROJECT_SCALE", tpd.get("PROJECT_SCALE"));
			}else {
				pdf.put("PROJECT_SCALE","");
			}
			if(tpd.get("QUANTITIES") !=null && !tpd.get("QUANTITIES").equals("")) {
				pdf.put("QUANTITIES", tpd.get("QUANTITIES"));
			}else {
				pdf.put("QUANTITIES", "");
			}
			if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")) {
				pdf.put("PROJECT_COST", tpd.get("PROJECT_COST"));
			}else {
				pdf.put("PROJECT_COST", "");
			}
			if("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus)){
				if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("")){
					pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
				}else{
					if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")){
						pdf.put("AUDIT_FEE", tpd.get("PROJECT_COST"));
					}else{
						pdf.put("AUDIT_FEE", "");
					}
				}
			}else{
				pdf.put("AUDIT_FEE", "");
			}
//			if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
//				pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
//			}else {
//				pdf.put("AUDIT_FEE", "");
//			}
			if(tpd.get("AUDIT_MAKER") !=null && !tpd.get("AUDIT_MAKER").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("AUDIT_MAKER", tpd.get("AUDIT_MAKER"));
			}else {
				pdf.put("AUDIT_MAKER", "");
			}
			if(tpd.get("STATUS") !=null && !tpd.get("STATUS").equals("")) {
				pdf.put("STATUS", tpd.get("STATUS"));
			}else {
				pdf.put("STATUS", "");
			}
			pdf.put("NAME", tpd.get("NAME"));
			pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
			pdf.put("COMPANY", tpd.get("COMPANY"));
			pdf.put("YEAR", tpd.get("YEAR"));
			pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
			pdf.put("ROAD", tpd.get("ROAD"));
			
			pdListRepair.add(pdf);
		}
		
		pd.put("TYPE", "highway_special_project_dettable");
		pd.put("PROJECT_NAME", "高速公路专项养护计划立项详表---");
		List<PageData>  zxvartableList = annualPlanService.getTableListYFYH(pd);
		
		List<PageData> pdListSpecial = new ArrayList<PageData>();
		for(PageData tpd :zxvartableList){
			PageData pdf = new PageData();
			if(tpd.get("PROJECT_NAME") !=null && !tpd.get("PROJECT_NAME").equals("")) {
				pdf.put("PROJECT_NAME", tpd.get("PROJECT_NAME"));
			}else{
				pdf.put("PROJECT_NAME", "");
			}
			if(tpd.get("CATEGORY") !=null && !tpd.get("CATEGORY").equals("")) {
				pdf.put("CATEGORY", tpd.get("CATEGORY"));
			}else {
				pdf.put("CATEGORY","");
			}
			if(tpd.get("PROJECT_SCALE") !=null && !tpd.get("PROJECT_SCALE").equals("")) {
				pdf.put("PROJECT_SCALE", tpd.get("PROJECT_SCALE"));
			}else {
				pdf.put("PROJECT_SCALE","");
			}
			if(tpd.get("QUANTITIES") !=null && !tpd.get("QUANTITIES").equals("")) {
				pdf.put("QUANTITIES", tpd.get("QUANTITIES"));
			}else {
				pdf.put("QUANTITIES", "");
			}
			if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")) {
				pdf.put("PROJECT_COST", tpd.get("PROJECT_COST"));
			}else {
				pdf.put("PROJECT_COST", "");
			}
			if("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus)){
				if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("")){
					pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
				}else{
					if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")){
						pdf.put("AUDIT_FEE", tpd.get("PROJECT_COST"));
					}else{
						pdf.put("AUDIT_FEE", "");
					}
				}
			}else{
				pdf.put("AUDIT_FEE", "");
			}
//			if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
//				pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
//			}else {
//				pdf.put("AUDIT_FEE", "");
//			}
			if(tpd.get("AUDIT_MAKER") !=null && !tpd.get("AUDIT_MAKER").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("AUDIT_MAKER", tpd.get("AUDIT_MAKER"));
			}else {
				pdf.put("AUDIT_MAKER", "");
			}
			if(tpd.get("STATUS") !=null && !tpd.get("STATUS").equals("")) {
				pdf.put("STATUS", tpd.get("STATUS"));
			}else {
				pdf.put("STATUS", "");
			}
			pdf.put("NAME", tpd.get("NAME"));
			pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
			pdf.put("COMPANY", tpd.get("COMPANY"));
			pdf.put("YEAR", tpd.get("YEAR"));
			pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
			pdf.put("ROAD", tpd.get("ROAD"));
			
			pdListSpecial.add(pdf);
		}
		
		//试验检测项目
		pd.put("TYPE", "highway_test_project_dettable");
		pd.put("PROJECT_NAME", "高速公路试验检测项目计划立项详表---");
		List<PageData>  syjctableList = annualPlanService.getTableListYFYH(pd);
		
		List<PageData> pdListTest = new ArrayList<PageData>();
		for(PageData tpd :syjctableList){
			PageData pdf = new PageData();
			if(tpd.get("PROJECT_NAME") !=null && !tpd.get("PROJECT_NAME").equals("")) {
				pdf.put("PROJECT_NAME", tpd.get("PROJECT_NAME"));
			}else{
				pdf.put("PROJECT_NAME", "");
			}
			if(tpd.get("CATEGORY") !=null && !tpd.get("CATEGORY").equals("")) {
				pdf.put("CATEGORY", tpd.get("CATEGORY"));
			}else {
				pdf.put("CATEGORY","");
			}
			if(tpd.get("CONTENT") !=null && !tpd.get("CONTENT").equals("")) {
				pdf.put("CONTENT", tpd.get("CONTENT"));
			}else {
				pdf.put("CONTENT_SCHEME","");
			}
			if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")) {
				pdf.put("PROJECT_COST", tpd.get("PROJECT_COST"));
			}else {
				pdf.put("PROJECT_COST", "");
			}
			if("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus)){
				if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("")){
					pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
				}else{
					if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")){
						pdf.put("AUDIT_FEE", tpd.get("PROJECT_COST"));
					}else{
						pdf.put("AUDIT_FEE", "");
					}
				}
			}else{
				pdf.put("AUDIT_FEE", "");
			}
//			if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
//				pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
//			}else {
//				pdf.put("AUDIT_FEE", "");
//			}
			if(tpd.get("AUDIT_MAKER") !=null && !tpd.get("AUDIT_MAKER").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("AUDIT_MAKER", tpd.get("AUDIT_MAKER"));
			}else {
				pdf.put("AUDIT_MAKER", "");
			}
			if(tpd.get("STATUS") !=null && !tpd.get("STATUS").equals("")) {
				pdf.put("STATUS", tpd.get("STATUS"));
			}else {
				pdf.put("STATUS", "");
			}
			pdf.put("NAME", tpd.get("NAME"));
			pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
			pdf.put("COMPANY", tpd.get("COMPANY"));
			pdf.put("YEAR", tpd.get("YEAR"));
			pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
			pdf.put("ROAD", tpd.get("ROAD"));
			
			pdListTest.add(pdf);
		}
		//路科研项目
		pd.put("TYPE", "highway_scientific_project_dettable");
		pd.put("PROJECT_NAME", "高速公路科研项目计划立项详表---");
		List<PageData>  lkytableList = annualPlanService.getTableListYFYH(pd);
		
		List<PageData> pdListScience = new ArrayList<PageData>();
		for(PageData tpd :lkytableList){
			PageData pdf = new PageData();
			if(tpd.get("PROJECT_NAME") !=null && !tpd.get("PROJECT_NAME").equals("")) {
				pdf.put("PROJECT_NAME", tpd.get("PROJECT_NAME"));
			}else{
				pdf.put("PROJECT_NAME", "");
			}
			if(tpd.get("CATEGORY") !=null && !tpd.get("CATEGORY").equals("")) {
				pdf.put("CATEGORY", tpd.get("CATEGORY"));
			}else {
				pdf.put("CATEGORY","");
			}
			if(tpd.get("CONTENT") !=null && !tpd.get("CONTENT").equals("")) {
				pdf.put("CONTENT", tpd.get("CONTENT"));
			}else {
				pdf.put("CONTENT","");
			}
			if(tpd.get("YEAR_COST") !=null && !tpd.get("YEAR_COST").equals("")) {
				pdf.put("YEAR_COST", tpd.get("YEAR_COST"));
			}else {
				pdf.put("YEAR_COST", "");
			}
			if("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus)){
				if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("")){
					pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
				}else{
					if(tpd.get("YEAR_COST") !=null && !tpd.get("YEAR_COST").equals("")){
						pdf.put("AUDIT_FEE", tpd.get("YEAR_COST"));
					}else{
						pdf.put("AUDIT_FEE", "");
					}
				}
			}else{
				pdf.put("AUDIT_FEE", "");
			}
//			if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
//				pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
//			}else {
//				pdf.put("AUDIT_FEE", "");
//			}
			if(tpd.get("AUDIT_MAKER") !=null && !tpd.get("AUDIT_MAKER").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("AUDIT_MAKER", tpd.get("AUDIT_MAKER"));
			}else {
				pdf.put("AUDIT_MAKER", "");
			}
			if(tpd.get("MATTER_YEAR") !=null && !tpd.get("MATTER_YEAR").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("MATTER_YEAR", tpd.get("MATTER_YEAR"));
			}else {
				pdf.put("MATTER_YEAR", "");
			}
			if(tpd.get("MATTER_NEW_CARRY") !=null && !tpd.get("MATTER_NEW_CARRY").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("MATTER_NEW_CARRY", tpd.get("MATTER_NEW_CARRY"));
			}else {
				pdf.put("MATTER_NEW_CARRY", "");
			}
			if(tpd.get("MATTER_COUSULT") !=null && !tpd.get("MATTER_COUSULT").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("MATTER_COUSULT", tpd.get("MATTER_COUSULT"));
			}else {
				pdf.put("MATTER_COUSULT", "");
			}
			if(tpd.get("STATUS") !=null && !tpd.get("STATUS").equals("")) {
				pdf.put("STATUS", tpd.get("STATUS"));
			}else {
				pdf.put("STATUS", "");
			}
			pdf.put("NAME", tpd.get("NAME"));
			pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
			pdf.put("COMPANY", tpd.get("COMPANY"));
			pdf.put("YEAR", tpd.get("YEAR"));
			pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
			pdf.put("ROAD", tpd.get("ROAD"));
			
			pdListScience.add(pdf);
		}
		
		//设备大修
		pd.put("TYPE", "highway_equipment_overhaul_project_dettable");
		pd.put("PROJECT_NAME", "高速公路设备大修项目计划立项详表---");
		List<PageData>  sbdxtableList = annualPlanService.getTableListYFYH(pd);
		
		List<PageData> pdListEquip = new ArrayList<PageData>();
		for(PageData tpd :sbdxtableList){
			PageData pdf = new PageData();
			if(tpd.get("PROJECT_NAME") !=null && !tpd.get("PROJECT_NAME").equals("")) {
				pdf.put("PROJECT_NAME", tpd.get("PROJECT_NAME"));
			}else{
				pdf.put("PROJECT_NAME", "");
			}
			if(tpd.get("CATEGORY") !=null && !tpd.get("CATEGORY").equals("")) {
				pdf.put("CATEGORY", tpd.get("CATEGORY"));
			}else {
				pdf.put("CATEGORY","");
			}
			if(tpd.get("CONTENT") !=null && !tpd.get("CONTENT").equals("")) {
				pdf.put("CONTENT", tpd.get("CONTENT"));
			}else {
				pdf.put("CONTENT","");
			}
			if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")) {
				pdf.put("PROJECT_COST", tpd.get("PROJECT_COST"));
			}else {
				pdf.put("PROJECT_COST", "");
			}
			if("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus)){
				if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("")){
					pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
				}else{
					if(tpd.get("PROJECT_COST") !=null && !tpd.get("PROJECT_COST").equals("")){
						pdf.put("AUDIT_FEE", tpd.get("PROJECT_COST"));
					}else{
						pdf.put("AUDIT_FEE", "");
					}
				}
			}else{
				pdf.put("AUDIT_FEE", "");
			}
//			if(tpd.get("AUDIT_FEE") !=null && !tpd.get("AUDIT_FEE").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
//				pdf.put("AUDIT_FEE", tpd.get("AUDIT_FEE"));
//			}else {
//				pdf.put("AUDIT_FEE", "");
//			}
			if(tpd.get("AUDIT_MAKER") !=null && !tpd.get("AUDIT_MAKER").equals("") && ("审批通过".equalsIgnoreCase(planStatus) || "控股驳回".equalsIgnoreCase(planStatus))) {
				pdf.put("AUDIT_MAKER", tpd.get("AUDIT_MAKER"));
			}else {
				pdf.put("AUDIT_MAKER", "");
			}
			if(tpd.get("STATUS") !=null && !tpd.get("STATUS").equals("")) {
				pdf.put("STATUS", tpd.get("STATUS"));
			}else {
				pdf.put("STATUS", "");
			}
			pdf.put("NAME", tpd.get("NAME"));
			pdf.put("COMPANY_ID", tpd.get("COMPANY_ID"));
			pdf.put("COMPANY", tpd.get("COMPANY"));
			pdf.put("YEAR", tpd.get("YEAR"));
			pdf.put("ROAD_ID", tpd.get("ROAD_ID"));
			pdf.put("ROAD", tpd.get("ROAD"));
			
			pdListEquip.add(pdf);
		}
		map.put("highwayplanStatus", highwayplanStatus);
		map.put("rcStatus", rcStatus);//日常计划状态
		map.put("baseStatus1", baseStatus1);
		map.put("baseStatus2", baseStatus2);
		map.put("baseStatus3", baseStatus3);		
		map.put("list1", pdListPrevent);//预防养护
		map.put("list2", pdListRepair);//修复养护
		map.put("list3", pdListSpecial);//专项养护
		map.put("list4", pdListTest);//试验检测
		map.put("list5", pdListScience);//公路科研项目
		map.put("list6", pdListEquip);//设备大修
		map.put("result", errInfo);				//返回结果
		return AppUtil.returnObject(new PageData(), map);
	}
	
	 /**显示、编辑子表格内容
	 * @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 = annualPlanService.showTableRecod(pd);	//根据ID读取
		mv.setViewName("information/annualPlan/annualPlan_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 = annualPlanService.getReportType(pd);	//获取报告类型
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy");
        Date date = new Date();
        String currentYear = sdf.format(date);
        List<String> yearItems = new ArrayList<String>();
        for(int i= -4; i < 6; i++){
        	Integer intyear = Integer.parseInt(currentYear);
        	yearItems.add(String.valueOf(intyear + i));
        }
		mv.setViewName("information/annualPlan/annualPlan_add");
		//mv.addObject("varList", varList);
		mv.addObject("msg", "save");
		mv.addObject("yearList", yearItems);
		mv.addObject("currentYear", currentYear);
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**新增报告和子表格的关系(新建年底计划，同时新建完成情况汇总)
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/save")
	public ModelAndView save() throws Exception{
		logBefore(logger, Jurisdiction.getUsername()+"新增annualPlan");
		//if(!Jurisdiction.buttonJurisdiction(menuUrl, "add")){return null;} //校验权限
		List<PageData> reportList = new ArrayList<PageData>();
		List<PageData> tableList = new ArrayList<PageData>();
		
		List<PageData> reportCompList = new ArrayList<PageData>();
		List<PageData> tableCompList = new ArrayList<PageData>();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		String planID = this.get32UUID();
		pd.put("ID", planID);//主键
		pd.put("NAME", pd.get("YEAR")+"年"+pd.get("COMPANY")+"年度养护计划");
		//设置查询oa_department的动态表名
		PageData cpPd = new PageData();
		String oa_department_table = "oa_department_"+pd.get("YEAR");
		cpPd.put("table", oa_department_table);
		cpPd.put("NAME", pd.get("COMPANY").toString());
		PageData companypd = (PageData)annualPlanService.getCompanyID(cpPd);  //通过路公司名获取路公司ID和父节点id
		String companyID = companypd.getString("BIANMA");
		String DEPARTMENT_ID = companypd.getString("DEPARTMENT_ID");		
		pd.put("COMPANY_ID", companyID);
		pd.put("COMPANY_NAME", pd.get("COMPANY"));
		//pd.put("DEPARTMENT_ID", DEPARTMENT_ID);
		pd.put("CTIME", Tools.date2Str(new Date()));	//创建时间
		pd.put("MTIME", Tools.date2Str(new Date()));	//修改时间
		pd.put("STATUS", "新建");	//创建时间
		annualPlanService.addAnnualPlan(pd);   //新建年度计划
		
		boolean hasNoCompList = false;
		String planCompID = this.get32UUID();
		List<PageData> compList = annualPlanService.getAnnualPlanComp(pd);
		if(compList.size() == 0){
			hasNoCompList = true;			
			pd.put("COMPID", planCompID);//主键	
			pd.put("COMPNAME", pd.get("YEAR")+"年"+pd.get("COMPANY")+"养护计划完成情况");
			annualPlanService.addAnnualPlanComp(pd);   //新建年度计划完成情况
		}
		
		pd.put("NAME", "年度养护计划总报告");		
		String reportID = this.get32UUID();
		pd.put("ID", reportID);//主键
		pd.put("PLANID", planID);
		reportList.add(pd);
		
		
		pd.put("COMPNAME", "年度养护计划完成情况总报告");
		String reportCompID = this.get32UUID();
		pd.put("COMPID", reportCompID);//主键
		pd.put("COMPPLANID", planCompID);
		pd.put("COMPNAME", "养护计划完成情况总报告");		
		reportCompList.add(pd);
		
		List<PageData> tableTypeList = annualPlanService.getTableType(); //获取表格类型	
		for(PageData tableInfo : tableTypeList){
			PageData tablepd = new PageData();
			tablepd.put("YEAR", pd.get("YEAR"));
			tablepd.put("NAME", pd.get("YEAR")+"年"+pd.get("COMPANY")+tableInfo.getString("TABLE_NAME"));
			tablepd.put("TYPE", tableInfo.getString("TABLE_TYPE"));
			tablepd.put("COMPANY_ID", companyID);
			tablepd.put("COMPANY_NAME", pd.get("COMPANY"));				
			tablepd.put("CTIME", Tools.date2Str(new Date()));	//创建时间
			tablepd.put("MTIME", Tools.date2Str(new Date()));	//修改时间
			tablepd.put("STATUS", "自动统计");	//创建时间
			tablepd.put("ROAD_NAME", "");
			tablepd.put("ROAD_ID", "");
			if(tableInfo.get("REPORT_ID").toString().equalsIgnoreCase("2")){
				tablepd.put("REPORTID", reportID);
				tableList.add(tablepd);
			}
			if(tableInfo.get("REPORT_ID").toString().equalsIgnoreCase("1")){  //完成情况总报告
				tablepd.put("COMPREPORTID", reportCompID);
				tablepd.put("COMPNAME", tableInfo.getString("TABLE_NAME"));
				tablepd.put("COMPTYPE", tableInfo.getString("TABLE_TYPE"));
				tableCompList.add(tablepd);
			}
		}
		
		cpPd.put("DEPARTMENT_ID", DEPARTMENT_ID);
		List<PageData> roadpdList = annualPlanService.getRoadInfo(cpPd); //通过父节点ID获取路段信息		
		for(PageData reportinfo : roadpdList){
			PageData reportpd = new PageData();
			reportID = this.get32UUID();
			reportpd.put("ID", reportID);//主键
			reportpd.put("PLANID", planID);
			reportpd.put("YEAR", pd.get("YEAR"));
			reportpd.put("ROAD_NAME", reportinfo.getString("NAME"));
			reportpd.put("ROAD_ID", reportinfo.getString("BIANMA"));
			reportpd.put("NAME", reportinfo.getString("NAME")+"年度养护计划分报告");
			reportpd.put("COMPANY_ID", companyID);
			reportpd.put("COMPANY_NAME", pd.get("COMPANY"));
			//reportpd.put("DEPARTMENT_ID", DEPARTMENT_ID);
			reportpd.put("CTIME", Tools.date2Str(new Date()));	//创建时间
			reportpd.put("MTIME", Tools.date2Str(new Date()));	//修改时间
			reportpd.put("STATUS", "新建");	//创建时间
			reportList.add(reportpd);

			reportCompID = this.get32UUID();     //完成情况分报告ID
			reportpd.put("COMPID", reportCompID);//主键
			reportpd.put("COMPPLANID", planCompID);	
			reportpd.put("COMPNAME", reportinfo.getString("NAME")+"养护计划完成情况分报告");
			reportCompList.add(reportpd);
			
			for(PageData tableInfo : tableTypeList){
				PageData tablepdroad = new PageData();	
				tablepdroad.put("YEAR", pd.get("YEAR"));
				tablepdroad.put("COMPANY_ID", companyID);
				tablepdroad.put("COMPANY_NAME", pd.get("COMPANY"));
				tablepdroad.put("ROAD_NAME", reportinfo.getString("NAME"));
				tablepdroad.put("ROAD_ID", reportinfo.getString("BIANMA"));					
				tablepdroad.put("CTIME", Tools.date2Str(new Date()));	//创建时间
				tablepdroad.put("MTIME", Tools.date2Str(new Date()));	//修改时间
				tablepdroad.put("STATUS", "自动统计");
				
				if(tableInfo.get("REPORT_ID").toString().equalsIgnoreCase("3")){	
					tablepdroad.put("REPORTID", reportID);
					tablepdroad.put("NAME", tableInfo.getString("TABLE_NAME"));
					tablepdroad.put("TYPE", tableInfo.getString("TABLE_TYPE"));					
					tableList.add(tablepdroad);
				}
				if(tableInfo.get("REPORT_ID").toString().equalsIgnoreCase("6")){
					tablepdroad.put("STATUS", "新建");
					tablepdroad.put("REPORTID", reportID);
					tablepdroad.put("NAME", tableInfo.getString("TABLE_NAME"));
					tablepdroad.put("TYPE", tableInfo.getString("TABLE_TYPE"));					
					tableList.add(tablepdroad);
				}
				if(tableInfo.get("REPORT_ID").toString().equalsIgnoreCase("4")){
					tablepdroad.put("COMPREPORTID", reportCompID);
					tablepdroad.put("COMPNAME", tableInfo.getString("TABLE_NAME"));
					tablepdroad.put("COMPTYPE", tableInfo.getString("TABLE_TYPE"));
					tableCompList.add(tablepdroad);
				}
			}
		}
		annualPlanService.addAnnualReport(reportList);
		annualPlanService.addAnnualTable(tableList);
		if(hasNoCompList){
			annualPlanService.addAnnualCompReport(reportCompList);
			annualPlanService.addAnnualCompTable(tableCompList);
		}
		mv.addObject("pd", pd);
	    mv.setViewName("save_result");	
		return mv;
	}
	
	/**判断年度计划是否已存在
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/hasPlan")
	@ResponseBody
	public Object hasPlan()throws Exception{
		Map<String,String> map = new HashMap<String,String>();
		PageData pd = new PageData();
		pd = this.getPageData();
		String msg = "success";
		//查询系统已存在的养护计划
		List<PageData> planPd = annualPlanService.getPlanByCompanyAndYear(pd);
		if(planPd.size() > 0){
			msg = "已存在相同的养护计划，新建失败";
		}
		map.put("result", msg);
		return AppUtil.returnObject(new PageData(), map);
	}
	
	/**删除年度计划和其下面的报告、表格
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/delAnnualPlan")
	@ResponseBody
	public Object delAnnualPlan()throws Exception{
		Map<String,String> map = new HashMap<String,String>();
		PageData pd = new PageData();
		pd = this.getPageData();
		try{
			PageData planPd = annualPlanService.getYearAndCompanyByID(pd);  //通过ANNUALPLAN_ID获取报告的年份和公司
			/*annualPlanService.delAnnualPlan(pd);	//删除年度计划
			List<String> reportIDList = annualPlanService.getReportID(pd);  //获取年度计划对应的报告ID
			annualPlanService.delReport(pd); //删除报告
			annualPlanService.delTables(reportIDList); //删除表格列表
			for(String tableName : tabls){
				planPd.put("TABLE_NAME", tableName);
				annualPlanService.delAllSumTables(planPd); //删除子表数据
			}	*/
//			List<PageData> tableList = new ArrayList<PageData>();
			for(String tableName : tabls){
				planPd.put("TABLE_NAME", tableName);				
				annualPlanService.delAllTables(planPd); //删除报告
			}			
			map.put("result", "success");
		}catch(Exception e){
			map.put("result", "删除失败");
		}
		return AppUtil.returnObject(new PageData(), map);
	}	
	
	/**新增立项详表新增弹出页面
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/addNewTablePanel")
	public ModelAndView addNewTablePanel()throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		List<PageData> varList = annualPlanService.getDetTableType();	//获取立项详表报告类型
		//通过reportid获取对应的路段信息
		PageData roadInfo = annualPlanService.getRoadInfoByReportID(pd);
		pd.put("ROAD_NAME", roadInfo.get("ROAD"));
		pd.put("ROAD_ID", roadInfo.get("ROAD_ID"));
		mv.setViewName("information/annualPlan/annualPlan_addNewTable");
		mv.addObject("varList", varList);
		mv.addObject("msg", "addNewTable");
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**只有路段分报告可以新增立项详表
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/addNewTable")
	@ResponseBody
	public Object addNewTable()throws Exception{
		Map<String,String> map = new HashMap<String,String>();
		PageData pd = new PageData();
		pd = this.getPageData();
		//List<PageData> varList = annualPlanService.getDetTableType();	//获取立项详表报告类型
		//通过reportid获取对应的路段信息
		try{
			PageData roadInfo = annualPlanService.getRoadInfoByReportID(pd);
			pd.put("ROAD_NAME", roadInfo.get("ROAD"));
			pd.put("ROAD_ID", roadInfo.get("ROAD_ID"));
//			mv.setViewName("information/annualPlan/annualPlan_addNewTable");
//			mv.addObject("varList", varList);
//			mv.addObject("pd", pd);
			map.put("result", "success");			
		}catch(Exception e){
			map.put("result", "只有路段分报告可以增加立项详表");
		}		
		return AppUtil.returnObject(new PageData(), map);
	}
	
	/**显示立项详表新增弹出页面
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/showNewTable")
	public ModelAndView showNewTable()throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		List<PageData> varList = annualPlanService.getDetTableType();	//获取立项详表报告类型
		mv.setViewName("information/annualPlan/annualPlan_addNewTable");
		mv.addObject("varList", varList);
		mv.addObject("msg", "save");
		mv.addObject("pd", pd);
		return mv;
	}
	
	@RequestMapping(value="/changeTableName")
	@ResponseBody
	public Object changeTableName() throws Exception{
		PageData pd = new PageData();
	    pd = this.getPageData();
	    String name = pd.getString("PROJECT_NAME");
	    pd.put("NAME", name);
	    pd.put("CTIME", Tools.date2Str(new Date()));
	    pd.put("MTIME", Tools.date2Str(new Date()));
	    pd.put("STATUS", "编制中");
	    annualPlanService.changeTableName(pd);	//在table_list中新增立项详表名称
		Map<String,Object> map = new HashMap<String,Object>();
	    map.put("msg","success");
        return AppUtil.returnObject(new PageData(), map);
	}
	
	@RequestMapping(value="/addNewTableInfo")
	@ResponseBody
	public Object addNewTableInfo() throws Exception{
		PageData pd = new PageData();
	    pd = this.getPageData();
//	    String name = pd.getString("PROJECT_NAME");
//	    pd.put("NAME", name);
	    Map<String,Object> map = new HashMap<String,Object>();
	    if(!hasBetTable(pd)){
		    //获取reportId "2017年高管中心宁连、宁洛及金马高速年度养护计划分报告"
	//    	String reportName = pd.getString("YEAR")+"年" + pd.getString("COMPANY") + pd.getString("ROAD") + "年度养护计划分报告";
	//    	String reportId = annualPlanService.getTableReportID(reportName); //get annual_report_list id
	//    	//在annual_table_list表中新增一条立项详情表记录       
	//    	pd.put("REPORTID", reportId);
	    	pd.put("CTIME", Tools.date2Str(new Date()));	//创建时间
			pd.put("MTIME", Tools.date2Str(new Date()));	//修改时间
			pd.put("STATUS", "编制中");	//修改时间
		    annualPlanService.addNewTableInfo(pd);	//insert annual_table_list新增立项详表			
		    map.put("msg","success");
	    }else{
	    	map.put("msg","已存在相同立项表");
	    }
        return AppUtil.returnObject(new PageData(), map);
	}
	
	public boolean hasBetTable(PageData pd) throws Exception{
		boolean flag = false;
	    List<PageData> tableInfo = annualPlanService.getTableInfo(pd);
	    if(tableInfo.size() > 0){
	    	flag = true;
	    }
        return flag;
	}
	
	/**删除立项表
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/delTable")
	@ResponseBody
	public Object delTable()throws Exception{
		Map<String,String> map = new HashMap<String,String>();
		PageData pd = new PageData();
		pd = this.getPageData();
		String msg = "删除立项表成功";
		try{
			annualPlanService.delRecordFromTable(pd); //删除table_lis中的表数据
			pd.put("TABLE_NAME", pd.get("TYPE"));
			if(pd.get("NAME") != null){
				if(pd.get("NAME").toString().contains("---")){
					pd.put("PROJECT_NAME", pd.get("NAME").toString().split("---")[1]);
				}
			}
			annualPlanService.delDettRecord(pd); //删除主表数据
			annualPlanService.delModifyRecord(pd); //删除留痕表中的主表数据
			annualPlanService.delMonthPlanRecord(pd); //删除对应立项表月度计划数据
			Map<String, String> relationMap = new HashMap<String, String>();
			relationMap.put("highway_prevention_project_dettable", "monthly_prevention_completion");
			relationMap.put("highway_repair_project_dettable", "monthly_repair_completion");
			relationMap.put("highway_emergency_project_dettable", "monthly_emergency_completion");
			relationMap.put("highway_equipment_overhaul_project_dettable", "monthly_equipment_overhaul_completion");
			relationMap.put("highway_scientific_project_dettable", "monthly_scientific_project_completion");
			relationMap.put("highway_special_project_dettable", "monthly_special_completion");
			relationMap.put("highway_test_project_dettable", "monthly_test_project_completion");
			if(pd.get("TYPE") != null){
				String tableName = relationMap.get(pd.get("TYPE").toString());
				pd.put("MTABLE_NAME", tableName);
			}
			annualPlanService.delMonthlyRecord(pd); //删除月度完成情况中的相应项目
			
			annualPlanService.delDettRecord(pd); //删除主表关联的cost表数据
			pd.put("TABLE_NAME", pd.get("TYPE") + "_cost");
			annualPlanService.delModifyRecord(pd); //删除留痕表中的主表关联的cost表数据
		}catch(Exception e){
			msg = "删除立项表失败";
		}
		map.put("result", msg);
		return AppUtil.returnObject(new PageData(), map);
	}
	
	/**判断是否存在立项表
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/hasDettTable")
	@ResponseBody
	public Object hasDettTable()throws Exception{
		Map<String,String> map = new HashMap<String,String>();
		PageData pd = new PageData();
		pd = this.getPageData();
		String result = "success";
		String msg="";
		try{
			List<PageData> dettTables = annualPlanService.getDettTables(pd); //获取年度计划中的立项表
			if(dettTables.size() == 0){
				msg = "该年度计划中不包含立项表，";
			}
		}catch(Exception e){
			result = "fail";
			msg = "查询年度计划中立项表失败";
		}
		map.put("result", result);
		map.put("msg", msg);
		return AppUtil.returnObject(new PageData(), map);
	}

	/**
	 * 
	* @Title: saveRecord
	* @Description: 保存点击记录
	* @param @return
	* @param @throws Exception
	* @return Object
	* @throws
	 */
	@RequestMapping(value="/saveRecord")
	@ResponseBody
	public Object saveRecord()throws Exception{
		Map<String,String> map = new HashMap<String,String>();
		PageData pd = new PageData();
		pd = this.getPageData();
		String result = "success";
		String msg="";
		try{
			pd.put("userName", Jurisdiction.getUsername());
			annualPlanService.saveRecord(pd); //获取年度计划中的立项表
		}catch(Exception e){
			e.printStackTrace();
			result = "fail";
		}
		map.put("result", result);
		map.put("msg", msg);
		return AppUtil.returnObject(new PageData(), map);
	}

	/**
	 * 
	* @Title: queryRecord
	* @Description: 查询点击记录
	* @param @return
	* @param @throws Exception
	* @return Object
	* @throws
	 */
	@RequestMapping(value="/queryRecord")
	@ResponseBody
	public Object queryRecord()throws Exception{
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userName", Jurisdiction.getUsername());
		PageData record = annualPlanService.queryLocationRecord(pd);
		return record;
	}
	
	/**
	* 有file文件时
	* @param movieDto 封装了需要传递过来的参数
	* @param file 图片file
	*/
	@RequestMapping("/editMovieInfo")
	@ResponseBody
	public Object editMovieInfo(HttpServletRequest request, MultipartFile file) {
		Map<String,String> map = new HashMap<String,String>();
		try {
			PageData pd = new PageData();
			pd = this.getPageData();
			String path = request.getSession().getServletContext().getRealPath("upload");			
			String fileName = ImportDoc.getNowTime() + "-" + file.getOriginalFilename();
			File targetFile = new File(path, fileName);
			String filePath = targetFile.getAbsolutePath();
			System.out.println(filePath);			
			if (!targetFile.exists()) {
				targetFile.mkdirs();
			}		
			file.transferTo(targetFile);
			pd.put("PIC_NAME", fileName);
			pd.put("CTIME", Tools.date2Str(new Date()));
			annualPlanService.addPictureInfo(pd); //上传成功的图片信息保存到数据库
			map.put("result", "true");
		} catch (IllegalStateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			map.put("result", "false");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			map.put("result", "false");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			map.put("result", "false");
		}
		return AppUtil.returnObject(new PageData(), map);
	}
	
	/**
	* 删除图片
	* @param movieDto 封装了需要传递过来的参数
	* @param file 图片file
	*/
	@RequestMapping("/deletePicture")
	@ResponseBody
	public Object deletePicture(HttpServletRequest request) {
		Map<String,String> map = new HashMap<String,String>();
		try {
			PageData pd = new PageData();
			pd = this.getPageData();		
			String fileName = pd.get("NAME").toString();
			if(new File(request.getSession().getServletContext().getRealPath("/upload") + "/"+fileName).exists()){
				new File(request.getSession().getServletContext().getRealPath("/upload") + "/"+fileName).delete();
				annualPlanService.deletePictureInfo(pd); //删除数据库中的图片记录
			}	
			map.put("result", "true");
		} catch (IllegalStateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			map.put("result", "false");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			map.put("result", "false");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			map.put("result", "false");
		}
		return AppUtil.returnObject(new PageData(), map);
	}
	
	/**查看图片
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value="/showPicture")
	public ModelAndView showPicture()throws Exception{
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		String name = pd.get("name").toString();
		mv.setViewName("information/annualPlan/showPicture");
		mv.addObject("pd", pd);
		return mv;
	}
}