ttc_5.0/ttc-app/src/main/java/cn/ubitech/ttc/controller/DataToolsController.java

package cn.ubitech.ttc.controller;

import cn.ubitech.ttc.common.ImageSpiderCommon;
import cn.ubitech.ttc.common.Util;
import cn.ubitech.ttc.entity.*;
import cn.ubitech.ttc.model.common.*;
import cn.ubitech.ttc.model.datatools.dataentry.ConnectioninfoModel;
import cn.ubitech.ttc.model.export.InterviewExportParam;
import cn.ubitech.ttc.model.organization.OrganizationModel;
import cn.ubitech.ttc.model.researchcost.CheckParam;
import cn.ubitech.ttc.model.user.RoleModel;
import cn.ubitech.ttc.model.user.RolePageModel;
import cn.ubitech.ttc.service.impl.datatools.DataEntryServiceImpl;
import cn.ubitech.ttc.service.impl.datatools.InterviewDataEntryServiceImpl;
import cn.ubitech.ttc.service.impl.label.LabelRecordServiceImpl;
import cn.ubitech.ttc.service.impl.message.HomePageMessageService;
import cn.ubitech.ttc.service.impl.mybaits.*;
import cn.ubitech.ttc.service.impl.resource.ResourceServiceImpl;
import com.alibaba.fastjson.JSON;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.mock.web.MockMultipartFile;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.stream.Collectors;

/**
 * code is far away from bug with the animal protecting
 * ┏┓　　　┏┓
 * ┏┛┻━━━┛┻┓
 * ┃　　　　　　　┃
 * ┃　　　━　　　┃
 * ┃　┳┛　┗┳　┃
 * ┃　　　　　　　┃
 * ┃　　　┻　　　┃
 * ┃　　　　　　　┃
 * ┗━┓　　　┏━┛
 * 　　┃　　　┃神兽保佑
 * 　　┃　　　┃代码无BUG！
 * 　　┃　　　┗━━━┓
 * 　　┃　　　　　　　┣┓
 * 　　┃　　　　　　　┏┛
 * 　　┗┓┓┏━┳┓┏┛
 * 　　　┃┫┫　┃┫┫
 * 　　　┗┻┛　┗┻┛
 *
 * @author chen.cong
 * @version 3.0
 * @Date: Create in 2018/5/31 15:28
 * @Modifyed By:
 * @Description: 数据录入
 */
@RestController
@RequestMapping("/data")
@Api(description = "数据录入相关接口")
public class DataToolsController {
    @Autowired
    private InterviewDataEntryServiceImpl interviewDataEntryService;
    @Autowired
    private OrganizationInfoServiceImpl organizationInfoServiceImpl;
    @Autowired
    private OrgStatsDataServiceImpl orgStatsDataService;
    @Autowired
    private DataEntryServiceImpl dataEntryServiceImpl;
    @Autowired
    private ResourceServiceImpl resourceServiceImpl;
    @Autowired
    private HomePageMessageService homePageMessageService;
    @Autowired
    private ImageSpiderCommon imageSpiderCommon;

    /**
     * 根据角色获取所有模版
     *
     * @param roleModel
     * @return
     */
    @RequestMapping(value = "/pageList", method = RequestMethod.POST)
    @ApiOperation(value = "获取模板", notes = "根据角色获取所有模版")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "roleModel", value = "角色的model")
    })
    public ResultModel getRolePageList(@RequestBody RoleModel roleModel) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = interviewDataEntryService.getRolePageList(roleModel, roleModel.getNode());
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
        }
        return resultModel;
    }

    /**
     * 根据模版id获取所有模块
     *
     * @param rolePageModel
     * @return
     */
    @RequestMapping(value = "/pageSectionList", method = RequestMethod.POST)
    @ApiOperation(value = "获取模板", notes = "根据模版id获取所有模块")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "rolePageModel", value = "角色的model")
    })
    public ResultModel getRolePageSectionList(@RequestBody RolePageModel rolePageModel) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = interviewDataEntryService.getRolePageSectionList(rolePageModel.getId());
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
        }
        return resultModel;
    }

    /**
     * 走访基本信息
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/orginfo", method = RequestMethod.POST)
    @ApiOperation(value = "更新机构", notes = "新建或者更新机构基本信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为ConnectioninfoModel")
    })
    public ResultModel insertOrUpdateOrgInfo(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            OrganizationModel connectioninfoModel = Util.fromJson(Util.toJson(requestModel.getData()), OrganizationModel.class);
            resultModel.setData(interviewDataEntryService.update(connectioninfoModel, requestModel.getNode(), requestModel.getUserid()));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 走访基本信息
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/conninfo", method = RequestMethod.POST)
    @ApiOperation(value = "走访基本信息", notes = "新建或者更新走访基本信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为ConnectioninfoModel")
    })
    public ResultModel insertOrUpdateConnectionInfo(@RequestBody RequestModel requestModel) {
        System.out.println("interview/conninfo 新建或者更新走访基本信息:" + JSON.toJSONString(requestModel));
        ResultModel resultModel = new ResultModel();
        try {
            ConnectioninfoModel connectioninfoModel = Util.fromJson(Util.toJson(requestModel.getData()), ConnectioninfoModel.class);
            String pagetitle = requestModel.getPagetitle();
            //通过ISINSERTFLAG来判断是新建还是编辑
            Util.judgeIsInsertFalg(connectioninfoModel);
            System.err.println("connectioninfoModelconnectioninfoModel:" + JSON.toJSONString(connectioninfoModel));
            resultModel.setData(interviewDataEntryService.insertOrUpdate(connectioninfoModel, requestModel.getNode(), requestModel.getPagecode(), pagetitle));
            //桐庐录入需求功能
            interviewDataEntryService.insertTLDemand(connectioninfoModel, requestModel);
            //插入资源库数据的机构相同时，便于前端给出提示
            if (Util.IS_HAS_SAME_ORG == true) {
                resultModel.setMessage("已有同名资源，请重新输入！");
            }
            //走访入录成功后，消息表中插入一条消息
            homePageMessageService.insertMessageToDB(requestModel, connectioninfoModel);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        } finally {
            //是否已有同名资源标志归位
            Util.IS_HAS_SAME_ORG = false;
        }
        return resultModel;
    }

    /**
     * 新增货修改走访申报项目接口
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/declareproject", method = RequestMethod.POST)
    @ApiOperation(value = "项目申报", notes = "新建或者更新项目申报信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyDeclareprojectLk的list")
    })
    public ResultModel insertOrUpdateCompanyDeclareproject(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyDeclareprojectLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyDeclareprojectLk[].class);
            List<CompanyDeclareprojectLk> resultList = new ArrayList<CompanyDeclareprojectLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyDeclareprojectLk result = interviewDataEntryService.insertOrUpdate(l);
                    resultList.add(result);
                });
            }

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

            resultModel.setData(resultList);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改走访研发投入，销售收入、净利润、上缴税收，工程中心情况 接口
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/yearmultipleoptions", method = RequestMethod.POST)
    @ApiOperation(value = "研发投入、销售收入、净利润、上缴税收、工程中心",
            notes = "新建或者更新研发投入、销售收入、净利润、上缴税收、工程中心信息，统一为一个接口")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyYearMultipleoptionsLk的list")
    })
    public ResultModel insertOrUpdateCompanyYearMultipleoptions(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyYearMultipleoptionsLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyYearMultipleoptionsLk[].class);
            List<CompanyYearMultipleoptionsLk> resultList = new ArrayList<CompanyYearMultipleoptionsLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyYearMultipleoptionsLk result = interviewDataEntryService.insertOrUpdate(l);
                    resultList.add(result);
                });
            }

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

            resultModel.setData(resultList);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改高端人才信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/highleveltalents", method = RequestMethod.POST)
    @ApiOperation(value = "高端人才", notes = "新建或者更新高端人才信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyHighleveltalentsLk的list")
    })
    public ResultModel insertOrUpdateCompanyHighleveltalents(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        List<CompanyHighleveltalentsLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyHighleveltalentsLk[].class);
        System.err.println("requestListrequestListrequestListrequestList:{}" + JSON.toJSONString(requestList));
        try {
            List<CompanyHighleveltalentsLk> resultList = new ArrayList<CompanyHighleveltalentsLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyHighleveltalentsLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改高端产品
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/hignendproduct", method = RequestMethod.POST)
    @ApiOperation(value = "高端产品", notes = "新建或者更新高端产品信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyHignendproductLk的list")
    })
    public ResultModel insertOrUpdateCompanyHignendproduct(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        List<CompanyHignendproductLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyHignendproductLk[].class);
        try {
            List<CompanyHignendproductLk> resultList = new ArrayList<CompanyHignendproductLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyHignendproductLk result = interviewDataEntryService.insertOrUpdate(l);
                    resultList.add(result);
                });
            }
            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

            resultModel.setData(resultList);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改产学研
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/iur", method = RequestMethod.POST)
    @ApiOperation(value = "产学研", notes = "新建或者更新产学研信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyIurLk的list")
    })
    public ResultModel insertOrUpdateCompanyIur(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        List<CompanyIurLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyIurLk[].class);
        try {
            List<CompanyIurLk> resultList = new ArrayList<CompanyIurLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyIurLk result = interviewDataEntryService.insertOrUpdate(l);
                    resultList.add(result);
                });
            }

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

            resultModel.setData(resultList);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改公司产品
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/product", method = RequestMethod.POST)
    @ApiOperation(value = "产品", notes = "新建或者更新产品信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyProductLk的list")
    })
    public ResultModel insertOrUpdateCompanyProduct(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
        if (requestModel.getPagecode() == 1000027L && "桐庐需求录入".equals(requestModel.getPagetitle()) && "330122000".equals(requestModel.getNode())) {
            //桐庐需求录入功能添加产品
            interviewDataEntryService.insertTLProduct(requestModel);
        } else {
            List<CompanyProductLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyProductLk[].class);
                List<CompanyProductLk> resultList = new ArrayList<CompanyProductLk>();
                if (requestList != null && requestList.size() > 0) {
                    requestList.forEach(l -> {
                        CompanyProductLk result = interviewDataEntryService.insertOrUpdate(l);
                        resultList.add(result);
                    });
                }
                //资源库新建资源后，往sys_message表中插入一条数据
                homePageMessageService.insertOtherResourceToDB(requestModel, requestList);
                resultModel.setData(resultList);
            }
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改公司技术需求
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/techrequirement", method = RequestMethod.POST)
    @ApiOperation(value = "技术需求", notes = "新建或者更新技术需求信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyTechrequirementLk的list")
    })
    public ResultModel insertOrUpdateCompanyTechrequirement(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyTechrequirementLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyTechrequirementLk[].class);
            List<CompanyTechrequirementLk> resultList = new ArrayList<CompanyTechrequirementLk>();

            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyTechrequirementLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改专利信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/intellectualproperty", method = RequestMethod.POST)
    @ApiOperation(value = "专利", notes = "新建或者更新专利信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyIntellectualpropertyLk的list")
    })
    public ResultModel insertOrUpdateCompanyIntellectualproperty(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        List<CompanyIntellectualpropertyLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyIntellectualpropertyLk[].class);
        try {
            List<CompanyIntellectualpropertyLk> resultList = new ArrayList<CompanyIntellectualpropertyLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyIntellectualpropertyLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改企业对接信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/saveOrupdateAbut", method = RequestMethod.POST)
    @ApiOperation(value = "对接信息", notes = "新建或者更新企业对接信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyAbutLk")
    })
    public ResultModel saveOrupdateAbut(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        String tasktitle = "";

        if(requestModel.getData() instanceof HashMap){
            HashMap map = (HashMap)requestModel.getData();
            tasktitle = String.valueOf(map.get("tasktitle"));
        }

        String node = requestModel.getNode();

        CompanyAbutLk companyAbutLk = Util.fromJson(Util.toJson(requestModel.getData()), CompanyAbutLk.class);
        try {
            resultModel.setData(interviewDataEntryService.insertOrUpdate(companyAbutLk, tasktitle, node));

            //保存到对接入录标签表中
//            if (Util.ISINSERTFLAG) {//新增
//                labelRecordService.saveEntryLabel(requestModel.getNode(), companyAbutLk.getCreator(),
//                        companyAbutLk.getCompanyid(), companyAbutLk.getLabelname(), companyAbutLk.getTitle(), true);
//            } else {//编辑
//                labelRecordService.saveEntryLabel(requestModel.getNode(), companyAbutLk.getCreator(),
//                        companyAbutLk.getCompanyid(), companyAbutLk.getLabelname(), companyAbutLk.getTitle(), false);
//            }
            //任务对接录入后，往sys_message表中插入一条数据
            homePageMessageService.insertAbutToDB(requestModel, companyAbutLk);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改专利信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/staffinfo", method = RequestMethod.POST)
    @ApiOperation(value = "人力资源", notes = "新建或者更新人力资源信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyStaffInfo的list")
    })
    public ResultModel insertOrUpdateCompanyStaffInfo(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        List<CompanyStaffInfo> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyStaffInfo[].class);
        try {
            List<CompanyStaffInfo> resultList = new ArrayList<CompanyStaffInfo>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyStaffInfo result = interviewDataEntryService.insertOrUpdate(l, requestModel.getUserid());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改成果信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/researchfinding", method = RequestMethod.POST)
    @ApiOperation(value = "成果", notes = "新建或者更新成果信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyResearchfindingLk的list")
    })
    public ResultModel insertOrUpdateCompanyResearchfinding(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyResearchfindingLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyResearchfindingLk[].class);
            List<CompanyResearchfindingLk> resultList = new ArrayList<CompanyResearchfindingLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyResearchfindingLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改特色专业信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/specialty", method = RequestMethod.POST)
    @ApiOperation(value = "特色专业", notes = "新建或者更新特色专业信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanySpecialtyLk的list")
    })
    public ResultModel insertOrUpdateCompanySpecialty(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanySpecialtyLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanySpecialtyLk[].class);
            List<CompanySpecialtyLk> resultList = new ArrayList<CompanySpecialtyLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanySpecialtyLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增或修改实验室信息表
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/lab", method = RequestMethod.POST)
    @ApiOperation(value = "实验室", notes = "新建或者更新实验室信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyLabLk的list")
    })
    public ResultModel insertOrUpdateCompanyLab(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyLabLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyLabLk[].class);
            List<CompanyLabLk> resultList = new ArrayList<CompanyLabLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyLabLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增货修改走访申报项目接口
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/project", method = RequestMethod.POST)
    @ApiOperation(value = "项目发布", notes = "新建或者更新项目发布信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyProject的list")
    })
    public ResultModel insertOrUpdateCompanyProjectLk(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyProjectLk> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyProjectLk[].class);
            List<CompanyProjectLk> resultList = new ArrayList<CompanyProjectLk>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyProjectLk result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 新增货修改走访申报项目接口
     *
     * @param requestModel
     * @return
     */
    @RequestMapping(value = "/interview/abutment", method = RequestMethod.POST)
    @ApiOperation(value = "对接进度", notes = "新建或者更新项目发布信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "通用请求接口，data中为CompanyAbutmentStatus的list")
    })
    public ResultModel insertOrUpdateCompanyAbutmentStatus(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<CompanyAbutmentStatus> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyAbutmentStatus[].class);
            List<CompanyAbutmentStatus> resultList = new ArrayList<CompanyAbutmentStatus>();
            if (requestList != null && requestList.size() > 0) {
                requestList.forEach(l -> {
                    CompanyAbutmentStatus result = interviewDataEntryService.insertOrUpdate(l, requestModel.getNode());
                    resultList.add(result);
                });
            }
            resultModel.setData(resultList);

            //资源库新建资源后，往sys_message表中插入一条数据
            homePageMessageService.insertOtherResourceToDB(requestModel, requestList);

        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 我的走访列表(分页)
     *
     * @param userid 用户id
     * @param funid  所属功能：1走访、2录入等
     * @return
     */
    @RequestMapping(value = "/interview/myinfolist/{keyword}/{userid}/{pagenum}/{funid}/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "我的走访、录入", notes = "分页获取我的走访和录入")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "keyword", paramType = "path", dataType = "String", value = "关键词"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "pagenum", paramType = "path", dataType = "int", value = "页码，默认从1开始"),
            @ApiImplicitParam(name = "funid", paramType = "path", dataType = "int", value = "所属功能：1走访、2录入"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点")
    })
    public ResultModel getMyInterviewList(@PathVariable String keyword, @PathVariable long userid, @PathVariable int pagenum, @PathVariable int funid, @PathVariable String node) {
        ResultModel resultModel = new ResultModel();
        try {
            PageModel pageModel = new PageModel();
            pageModel.setStartIndex(pagenum);
            pageModel.setCurrentPage(pagenum);
            // pageModel.setPageSize(Constant.PAGE_SIZE);
            resultModel = interviewDataEntryService.getMyConnectioninfoList(pageModel, userid, keyword.trim(), funid,node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 我的走访列表
     *
     * @param userid 用户id
     * @param funid  所属功能：1走访、2录入等
     * @return
     */
    @RequestMapping(value = "/interview/myinfolist/all/{userid}/{funid}/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "我的走访、录入", notes = "获取全部我的走访和录入")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "funid", paramType = "path", dataType = "int", value = "所属功能：1走访、2录入"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点")
    })
    public ResultModel getMyInterviewInfoList(@PathVariable long userid, @PathVariable int funid, @PathVariable String node) {
        System.out.println("我的走访:userid:" + userid + ",funid:" + funid + ",node:" + node);
        ResultModel resultModel = new ResultModel();
        try {
            // PageModel pageModel = new PageModel();
            // pageModel.setStartIndex(pagenum);
            // pageModel.setCurrentPage(pagenum);
            // pageModel.setPageSize(Constant.PAGE_SIZE);
            resultModel = interviewDataEntryService.getMyInterviewInfoList(userid, funid, node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 云走访列表(列表模式)
     *
     * @param userid  用户id
     * @param keyword 搜索关键词
     * @param pagenum 页码
     * @param funid   所属功能：1走访、2录入等
     * @return
     */
    @Deprecated
    @RequestMapping(value = {"/interview/allinfolist/{keyword}/{userid}/{pagenum}/{funid}",
            "/interview/allinfolist/{keyword}/{userid}/{pagenum}/{funid}/{node}"}, method = RequestMethod.GET)
    @ApiOperation(value = "云走访列表(列表模式)", notes = "通过关键词、模板分页查询云走访列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "keyword", paramType = "path", dataType = "String", value = "关键词"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "pagenum", paramType = "path", dataType = "int", value = "页码，默认从1开始"),
            @ApiImplicitParam(name = "funid", paramType = "path", dataType = "int", value = "所属功能：1走访、2录入"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "所属节点号", defaultValue = "000000000")
    })
    public ResultModel getAllInterviewList(@PathVariable String keyword, @PathVariable long userid, @PathVariable int pagenum, @PathVariable int funid,
                                           @PathVariable(required = false) String node) {
        ResultModel resultModel = new ResultModel();
        try {
            PageModel pageModel = new PageModel();
            pageModel.setStartIndex(pagenum);
            pageModel.setCurrentPage(pagenum);
            pageModel.setPageSize(Constant.PAGE_SIZE);
            resultModel = interviewDataEntryService.getAllConnectioninfoList(pageModel, userid, keyword.trim(), funid, node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 云走访列表(列表模式)
     *
     * @param userid  用户id
     * @param keyword 搜索关键词
     * @param pagenum 页码
     * @param funid   所属功能：1走访、2录入等
     * @return
     */
    @RequestMapping(value = {"/interview/infolistforall/{keyword}/{userid}/{pagenum}/{funid}",
            "/interview/infolistforall/{keyword}/{userid}/{pagenum}/{funid}/{node}"}, method = RequestMethod.GET)
    @ApiOperation(value = "云走访列表(列表模式)", notes = "通过关键词、模板分页查询云走访列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "keyword", paramType = "path", dataType = "String", value = "关键词"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "pagenum", paramType = "path", dataType = "int", value = "页码，默认从1开始"),
            @ApiImplicitParam(name = "funid", paramType = "path", dataType = "int", value = "所属功能：1走访、2录入"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "所属节点号", defaultValue = "000000000")
    })
    public ResultModel getAllViewInterviewList(@PathVariable String keyword, @PathVariable long userid, @PathVariable int pagenum, @PathVariable int funid,
                                               @PathVariable(required = false) String node) {
        ResultModel resultModel = new ResultModel();
        try {
            PageModel pageModel = new PageModel();
            pageModel.setStartIndex(pagenum);
            pageModel.setCurrentPage(pagenum);
//            pageModel.setPageSize(Constant.PAGE_SIZE);
            resultModel = interviewDataEntryService.getAllViewConnectioninfoList(pageModel, userid, keyword.trim(), funid, node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }

        return resultModel;
    }

    /**
     * 历史走访信息
     *
     * @param userid  用户id
     * @param keyword 搜索关键词
     * @param pagenum 页码
     * @return
     */
    @RequestMapping(value = {"/interview/historyinfolist/{keyword}/{userid}/{orgid}/{pagenum}/{funid}",
            "/interview/historyinfolist/{keyword}/{userid}/{orgid}/{pagenum}/{funid}/{node}"}, method = RequestMethod.GET)
    @ApiOperation(value = "历史走访信息", notes = "通过关键词、模板分页查询历史走访列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "keyword", paramType = "path", dataType = "String", value = "关键词"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "oid", paramType = "path", dataType = "long", value = "机构的id"),
            @ApiImplicitParam(name = "pagenum", paramType = "path", dataType = "int", value = "页码，默认从1开始"),
            @ApiImplicitParam(name = "funid", paramType = "path", dataType = "int", value = "所属功能：1走访、2录入"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "所属节点号", defaultValue = "000000000")
    })
    public ResultModel getHistoryInterviewList(@PathVariable String keyword, @PathVariable long userid, @PathVariable long orgid,
                                               @PathVariable int pagenum, @PathVariable int funid,
                                               @PathVariable(required = false) String node) {
        ResultModel resultModel = new ResultModel();
        try {
            PageModel pageModel = new PageModel();
            pageModel.setStartIndex(pagenum);
            pageModel.setCurrentPage(pagenum);
            pageModel.setPageSize(Constant.PAGE_SIZE);
            resultModel = interviewDataEntryService.getHistoryConnectioninfoList(pageModel, userid, keyword.trim(), orgid, funid, node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 通过数据录入id查询录入的所有信息
     *
     * @param connid 履历id
     * @param userid 用户id
     * @return
     */
    @RequestMapping(value = "/interview/conndetail/{connid}/{userid}/{node}/{pagecode}/{innertype}", method = RequestMethod.GET)
    @ApiOperation(value = "走访详情", notes = "通过走访id查询走访详情")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "connid", paramType = "path", dataType = "long", value = "走访id"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点号"),
            @ApiImplicitParam(name = "pagecode", paramType = "path", dataType = "int", value = "页面编号"),
            @ApiImplicitParam(name = "innertype", paramType = "path", dataType = "int", value = "内部类型（通常用于单个表有多个属性）")
    })
    public ResultModel getConnectioninfoDetailByConnid(@PathVariable long connid, @PathVariable Long userid,
                                                       @PathVariable String node, @PathVariable Integer pagecode, @PathVariable Integer innertype) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(interviewDataEntryService.getConnectioninfoDetail(connid, userid, node, pagecode, innertype));
//            //详情页显示自定义标签
//            resultModel.setOtherObj(labelRecordService.userSettingLabelList(node, connid));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * @param connid
     * @param userid
     * @param node
     * @param pagecode
     * @param innertype
     * @return
     */
    @RequestMapping(value = "/interviewOtherDetail/conndetail/{connid}/{userid}/{node}/{pagecode}/{innertype}", method = RequestMethod.GET)
    @ApiOperation(value = "走访详情附属信息", notes = "通过走访id查询走访详情附属信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "connid", paramType = "path", dataType = "long", value = "走访id"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点号"),
            @ApiImplicitParam(name = "pagecode", paramType = "path", dataType = "int", value = "页面编号"),
            @ApiImplicitParam(name = "innertype", paramType = "path", dataType = "int", value = "内部类型（通常用于单个表有多个属性）")
    })
    public ResultModel getConnectioninfoAllDetail(@PathVariable long connid, @PathVariable Long userid,
                                                  @PathVariable String node, @PathVariable Integer pagecode, @PathVariable Integer innertype) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(interviewDataEntryService.getConnectioninfoAllDetail(connid, userid, node, pagecode, innertype));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 根据orgid获取对应的机构信息
     *
     * @param orgid 机构id
     * @return
     * @author yun.jia
     * @version 1.0, 2018年6月29日
     */
    @RequestMapping(value = "/org/id/{orgid}/{userid}/{node}/{pagecode}/{innertype}", method = RequestMethod.GET)
    @ApiOperation(value = "机构信息", notes = "通过走访id查询走访详情")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "orgid", paramType = "path", dataType = "long", value = "机构id"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点号"),
                @ApiImplicitParam(name = "pagecode", paramType = "path", dataType = "int", value = "页面编号"),
            @ApiImplicitParam(name = "innertype", paramType = "path", dataType = "int", value = "内部类型（通常用于单个表有多个属性）")
    })
    public ResultModel getOrganizationModelByOrgid(@PathVariable Long orgid, @PathVariable long userid, @PathVariable String node,
                                                   @PathVariable Integer pagecode, @PathVariable Integer innertype) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(organizationInfoServiceImpl.getOrganizationModelByOrgid(orgid, userid, node, pagecode, innertype));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 根据orgname获取对应的机构信息
     *
     * @param orgname
     * @param userid
     * @param pagenum
     * @param node
     * @param pagecode
     * @param innertype
     * @param orgTypeSign
     * @return
     */
    @RequestMapping(value = "/org/name/{orgname}/{userid}/{pagenum}/{node}/{pagecode}/{innertype}/{orgTypeSign}", method = RequestMethod.GET)
    @ApiOperation(value = "机构联想", notes = "分页获取联想的机构，用于走访、录入时调取机构的信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "orgname", paramType = "path", dataType = "String", value = "机构名称"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "long", value = "用户id"),
            @ApiImplicitParam(name = "pagenum", paramType = "path", dataType = "int", value = "页码，默认从1开始"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点号"),
            @ApiImplicitParam(name = "pagecode", paramType = "path", dataType = "int", value = "页面编号"),
            @ApiImplicitParam(name = "innertype", paramType = "path", dataType = "int", value = "内部类型（通常用于单个表有多个属性）"),
            @ApiImplicitParam(name = "orgTypeSign", paramType = "path", dataType = "String", value = "挂靠机构，为1时即查找挂靠机构")

    })
    public ResultModel getOrganizationModelByOrgname(@PathVariable String orgname, @PathVariable long userid, @PathVariable int pagenum,
                                                     @PathVariable String node,
                                                     @PathVariable Integer pagecode, @PathVariable Integer innertype,
                                                     @PathVariable String orgTypeSign) {

        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(organizationInfoServiceImpl.getSignOrgOrOrganizationMode(orgname, userid, pagenum, node, 0, innertype, orgTypeSign));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }


    /**
     * 根据orgname获取对应的机构信息
     *
     * @param oid
     * @param userid
     * @param node
     * @param pagecode
     * @param innertype
     * @return
     */
    @RequestMapping(value = "/org/staffinfo/{oid}/{userid}/{node}/{pagecode}/{innertype}", method = RequestMethod.GET)
    @ApiOperation(value = "人力资源联想", notes = "通过机构id获取人力资源id")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "oid", paramType = "path", dataType = "String", value = "机构id"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "String", value = "用户")
    })
    public ResultModel getCompanyStaffInfoByOid(@PathVariable long oid, @PathVariable long userid,
                                                @PathVariable String node, @PathVariable Integer pagecode, @PathVariable Integer innertype) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(interviewDataEntryService.getCompanyStaffInfoByOid(oid, userid, node, 0, innertype));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 根据Integer datatype,  String datatimeyear, String datatimemonth, String orgid获取对应的机构报表详情
     *
     * @param orgid
     * @param datatype
     * @param datatimeyear
     * @param datatimemonth
     * @return
     */
    @RequestMapping(value = "/orgstats/query/{orgid}/{datatype}/{datatimeyear}/{datatimemonth}", method = RequestMethod.GET)
    @ApiOperation(value = "报表数据查询", notes = "通过机构id、时间进行查询报表的详细数据")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "orgid", paramType = "path", dataType = "long", value = "机构id，如：806"),
            @ApiImplicitParam(name = "datatype", paramType = "path", dataType = "Integer", value = "数据类型，0总量 1增量,如：0"),
            @ApiImplicitParam(name = "datatimeyear", paramType = "path", dataType = "String", value = "年份，如：2018"),
            @ApiImplicitParam(name = "datatimemonth", paramType = "path", dataType = "String", value = "月，如:1-6月"),
    })
    public ResultModel getOrgstatsDatalist(@PathVariable Long orgid, @PathVariable Integer datatype, @PathVariable String datatimeyear, @PathVariable String datatimemonth) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = orgStatsDataService.getOrgstatsDatalist(datatype, datatimeyear, datatimemonth, orgid);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/orgstats/save", method = RequestMethod.POST)
    @ApiOperation(value = "报表数据新增或编辑", notes = "报表数据新增或编辑")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "requestModel")
    })
    public ResultModel saveOrgstatsDatalist(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            List<OrgStatsData> requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), OrgStatsData[].class);
            resultModel = orgStatsDataService.saveOrgstatsDatalist(requestList, requestModel.getUserid());
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/orgstats/orglist/{nodeid}/{key}/{pagenum}/{pagesize}", method = RequestMethod.GET)
    @ApiOperation(value = "报表企业列表查询", notes = "通过节点id查询节点下企业列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "nodeid", paramType = "path", dataType = "String", value = "所在节点id，如：320117001"),
            @ApiImplicitParam(name = "key", paramType = "path", dataType = "String", value = "关键词，可以为空"),
            @ApiImplicitParam(name = "pagenum", paramType = "path", dataType = "int", value = "页码，默认从1开始"),
            @ApiImplicitParam(name = "pagesize", paramType = "path", dataType = "int", value = "每页显示，默认15"),
    })
    public ResultModel getOrgstatsOrglist(@PathVariable String nodeid, @PathVariable int pagenum, @PathVariable int pagesize, @PathVariable String key) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = orgStatsDataService.getOrgstatsCompanylist(nodeid, key.trim(), pagenum, pagesize);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/orgstats/count/{nodeid}/{datatype}", method = RequestMethod.GET)
    @ApiOperation(value = "节点下报表总数", notes = "通过节点id查询节点下报表总数")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "nodeid", paramType = "path", dataType = "String", value = "所在节点id，如：320117001"),
            @ApiImplicitParam(name = "datatype", paramType = "path", dataType = "Integer", value = "数据类型，0总量 1增量,如：0")
    })
    public ResultModel getOrgstatsDataCount(@PathVariable String nodeid, @PathVariable Integer datatype) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = orgStatsDataService.getstatsCount(nodeid, datatype);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 获取资源库的走访履历
     *
     * @param resid
     * @param node
     * @param pagecode
     * @param userid
     * @return
     */
    @RequestMapping(value = "/resconn/{resid}/{node}/{pagecode}/{userid}", method = RequestMethod.GET)
    @ApiOperation(value = "资源库下的走访履历", notes = "通过资源id查询走访履历")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "resid", paramType = "path", dataType = "Long", value = "资源id"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "所在节点id，如：320117001"),
            @ApiImplicitParam(name = "pagecode", paramType = "path", dataType = "Integer", value = "页面编号，如是资源库下的履历则传入资源库对应的pagecode"),
            @ApiImplicitParam(name = "userid", paramType = "path", dataType = "Long", value = "用户id")
    })
    public ResultModel getResConnHistory(@PathVariable Long resid, @PathVariable String node, @PathVariable Integer pagecode,
                                         @PathVariable Long userid) {
        ResultModel resultModel = new ResultModel();
        try {
            List<ConnectioninfoModel> connectioninfoModelList = dataEntryServiceImpl.getDataentryDetail(resid, userid);
            connectioninfoModelList = connectioninfoModelList.stream().filter(l -> resourceServiceImpl.
                    judgeResourceConnectHistory(node, pagecode, l.getTemplettype())).collect(Collectors.toList());
            resultModel.setData(connectioninfoModelList);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 通过企业名判断该企业是否已存在
     *
     * @param orgName
     * @return
     */
    @RequestMapping(value = "/org/exist/{orgName}/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "通过企业名判断该企业是否已存在", notes = "通过企业名判断该企业是否已存在")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "orgName", paramType = "path", dataType = "String", value = "企业名称"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点信息")
    })
    public ResultModel getResConnHistory(@PathVariable String orgName, @PathVariable String node) {
        ResultModel resultModel = new ResultModel();
        try {
            dataEntryServiceImpl.judgeOrgIsExist(resultModel, orgName, node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 通过企业名判断该企业是否已存在于资源库
     * @param orgName
     * @return
     */
    @RequestMapping(value = "/resource/org/exist/{orgName}/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "通过企业名判断该企业是否已存在于资源库", notes = "通过企业名判断该企业是否已存在于资源库")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "orgName", paramType = "path", dataType = "String", value = "企业名称"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "String", value = "节点信息")
    })
    public ResultModel judgeOrgExistResource(@PathVariable String orgName, @PathVariable String node) {
        ResultModel resultModel = new ResultModel();
        try {
            dataEntryServiceImpl.judgeOrgExistResource(resultModel, orgName, node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/technical/contract/get/{contractid}", method = RequestMethod.GET)
    @ApiOperation(value = "获取签订技术合同时的上传的图片", notes = "获取签订技术合同时的上传的图片")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "contractid", paramType = "path", dataType = "long", value = "技术合同id")
    })
    public ResultModel judgeOrgExistResource(@PathVariable Long contractid) {
        ResultModel resultModel = new ResultModel();
        try {
            List<SystemPicture> systemPictureList = dataEntryServiceImpl.getContractPhoto(contractid);
            resultModel.setData(systemPictureList);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/saveUnion", method = RequestMethod.POST)
    @ApiOperation(value = "联盟编辑", notes = "联盟编辑")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "requestModel", value = "requestModel，requestModel中data为联盟库数据")
    })
    public ResultModel saveUnion(@RequestBody RequestModel requestModel) {
        ResultModel resultModel = new ResultModel();
        try {
            dataEntryServiceImpl.saveUnion(requestModel);
            resultModel.setData("");
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/conn/id/get/{title}", method = RequestMethod.GET)
    @ApiOperation(value = "由名称查询对接id", notes = "由名称查询对接id")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "title", paramType = "path", dataType = "String", value = "对接名称")
    })
    public ResultModel getConnId(@PathVariable String title) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(dataEntryServiceImpl.getConnId(title));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/monthReport/list/{oid}/{year}/{month}/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "查询企业的月报表信息", notes = "查询企业的月报表信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "oid", paramType = "path", dataType = "long", value = "企业id"),
            @ApiImplicitParam(name = "year", paramType = "path", dataType = "String", value = "年份"),
            @ApiImplicitParam(name = "month", paramType = "path", dataType = "String", value = "月份"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "long", value = "节点")
    })
    public ResultModel getMonthReportList(@PathVariable long oid, @PathVariable String year, @PathVariable String month, @PathVariable long node) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(dataEntryServiceImpl.getMonthReportList(oid, year, month, node));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/Report/month/list/{oid}/{year}/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "查询企业的月报表信息的月份", notes = "查询企业的月报表信息的月份")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "oid", paramType = "path", dataType = "long", value = "企业id"),
            @ApiImplicitParam(name = "year", paramType = "path", dataType = "String", value = "年份"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "long", value = "节点")
    })
    public ResultModel getReportMonthList(@PathVariable long oid, @PathVariable String year, @PathVariable long node) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(dataEntryServiceImpl.getReportMonthList(oid, year, node));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/Report/year/list/{oid}/{node}/{flag}",method = RequestMethod.GET)
    @ApiOperation(value = "查询企业的月报表信息的年份", notes = "查询企业的 月报表信息的年份")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "oid", paramType = "path", dataType = "long", value = "企业id"),
            @ApiImplicitParam(name = "node", paramType = "path", dataType = "long", value = "节点"),
            @ApiImplicitParam(name = "flag", paramType = "path", dataType = "boolean", value = "标志是否与走访录入有关（true,有关）")
    })
    public ResultModel getReportYearList(@PathVariable long oid, @PathVariable long node, @PathVariable boolean flag) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(dataEntryServiceImpl.getReportYearList(oid, node, flag));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }
    @RequestMapping(value = "/cooperate/list/{node}",method = RequestMethod.GET)
    @ApiOperation(value = "获取产学研补助审核列表", notes = "获取产学研补助审核列表")
    @ApiImplicitParams({ @ApiImplicitParam(name = "node", paramType = "path", dataType = "long", value = "节点") })
    public ResultModel getCooperateList(@PathVariable long node) {
        ResultModel resultModel = new ResultModel();
        try {
            List<String> hasAuths = new ArrayList<>();
            hasAuths.add("2865");
            hasAuths.add("2880");
            hasAuths.add("3040");
            resultModel.setOtherObj(hasAuths);
            resultModel.setData(dataEntryServiceImpl.getCooperateList(node));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }
    @RequestMapping(value = "/techContract/contractid/get/{technicalcontractid}",method = RequestMethod.GET)
    @ApiOperation(value = "通过technicalcontractid获取TechnicalContract数据", notes = "通过technicalcontractid获取TechnicalContract数据")
    @ApiImplicitParams({ @ApiImplicitParam(name = "int", paramType = "path", dataType = "String", value = "技术合同id") })
    public ResultModel getTechContractByContractid(@PathVariable int technicalcontractid) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel.setData(dataEntryServiceImpl.getTechContractByContractid(technicalcontractid));
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/cooperation/report/export", method = RequestMethod.POST)
    @ApiOperation(value = "产学研补助导出功能", notes = "产学研补助导出功能")
    @ApiImplicitParams({
    })
    public ResultModel exportCooperationReport(@RequestBody RequestModel requestModel, HttpServletResponse response) {
        ResultModel resultModel = new ResultModel();
        try {
            HSSFWorkbook workbook = dataEntryServiceImpl.exportCooperationReport(requestModel);
            //文档输出
            Long time = new Date().getTime();
            String path = time + ".xls";
            FileOutputStream out = new FileOutputStream(path);
            workbook.write(out);
            out.close();
            SystemPicture systemPicture = new SystemPicture();
            try {
                File file = new File(path);
                FileInputStream input = new FileInputStream(new File(path));
                MultipartFile multipartFile = new MockMultipartFile("file", file.getName(), "text/plain", IOUtils.toByteArray(input));
                if (!multipartFile.isEmpty()) {
                    String[] filename = imageSpiderCommon.getImagePath(multipartFile).toString().split(",");
                    systemPicture.setPhotoName(filename[0].trim());//缩略图
                    systemPicture.setOriginalName(filename[1].trim());//放大图
                    systemPicture.setSourceName(filename[2].trim());//原图
                    if(StringUtils.isBlank(systemPicture.getSourceName())){
                        systemPicture.setSourceName(filename[4].trim());//原图
                    }
                    systemPicture.setSourceSize(filename[3].trim());//大小
                    String fileExtName = filename[0].trim().substring(filename[0].trim().lastIndexOf(".") + 1);
                    System.out.println(fileExtName);
                    systemPicture.setDoctype(Util.getAttachmentType(fileExtName));
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
            resultModel.setData(systemPicture);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
            throw new RuntimeException("产学研补助导出功能出现异常");
        }
        return resultModel;
    }
    @RequestMapping(value = "/cooperation/report/share/{demandid}", method = RequestMethod.GET)
    @ApiOperation(value = "产学研补助共享功能", notes = "产学研补助共享功能")
    @ApiImplicitParams({ @ApiImplicitParam(name = "demandid", paramType = "path", dataType = "Long", value = "产学研补助id") })
    public ResultModel shareCooperationReport(@PathVariable Long demandid) {
        ResultModel resultModel = new ResultModel();
        try {
            dataEntryServiceImpl.shareCooperationReport(demandid);
            resultModel.setData("");
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    /**
     * 获取桐庐科技局成员的走访记录信息。
     *
     * @param interviewExportParam
     * @return
     */
    @RequestMapping(value = "/sel/interviewinfo", method = RequestMethod.POST)
    @ApiOperation(value = "导出桐庐科技局成员提交的走访记录信息", notes = "导出桐庐科技局成员提交的走访记录信息接口")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "roleModel", value = "角色的model")
    })
    public ResultModel selInterviewinfo(@RequestBody InterviewExportParam interviewExportParam) {
        System.err.println("sel interviewExportParam:" + JSON.toJSONString(interviewExportParam));
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = interviewDataEntryService.exportInterviewinfo(interviewExportParam);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
        }
        return resultModel;
    }



    /**
     * 导出桐庐科技局成员提交的走访记录信息。
     *
     * @param interviewExportParam
     * @return
     */
    @RequestMapping(value = "/export/interviewinfo", method = RequestMethod.POST)
    @ApiOperation(value = "导出桐庐科技局成员提交的走访记录信息", notes = "导出桐庐科技局成员提交的走访记录信息接口")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "roleModel", value = "角色的model")
    })
    public ResultModel exportInterviewinfo(@RequestBody InterviewExportParam interviewExportParam) {
        System.err.println("export interviewExportParam:" + JSON.toJSONString(interviewExportParam));
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = interviewDataEntryService.exportInterviewinfo(interviewExportParam);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
        }
        return resultModel;
    }

    /**
     * 获取导出走访记录基本信息字段。
     *
     * @param
     * @return
     */
    @RequestMapping(value = "/sel/basic/param/{node}", method = RequestMethod.GET)
    @ApiOperation(value = "获取导出走访记录基本信息字段", notes = "获取导出走访记录基本信息字段接口")
    public ResultModel selBasicParam(@PathVariable String node) {
        ResultModel resultModel = new ResultModel();
        try {
            resultModel = interviewDataEntryService.selBasicParam(node);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
        }
        return resultModel;
    }

    @RequestMapping(value = "/cooperate/research/list",method = RequestMethod.POST)
    @ApiOperation(value = "获取研发后补助审核列表", notes = "获取研发后补助审核列表")
    public ResultModel getCooperateOrResearchList(@RequestBody CheckParam checkParam) {
        System.out.println("checkParam:" + JSON.toJSONString(checkParam));
        ResultModel resultModel = new ResultModel();
        try {

            // resultModel.setData(dataEntryServiceImpl.getCooperateOrResearchList(checkParam));
            return dataEntryServiceImpl.getCooperateOrResearchList(checkParam);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/research/cost/detail/{detailId}/{type}",method = RequestMethod.GET)
    @ApiOperation(value = "根据id获取研发后补助详情接口", notes = "根据id获取研发后补助详情接口")
    @ApiImplicitParams({ @ApiImplicitParam(name = "Integer", paramType = "path", dataType = "String", value = "研发后补助id") })
    public ResultModel getResearchDetailsById(@PathVariable Integer detailId,@PathVariable Integer type) {
        ResultModel resultModel = new ResultModel();
        try {
            return dataEntryServiceImpl.getResearchDetailsById(detailId,type);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

    @RequestMapping(value = "/sel/subsidies/{nodeId}/{pageNum}",method = RequestMethod.GET)
    @ApiOperation(value = "获取杭州市补助名单列表", notes = "获取杭州市补助名单列表接口")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "Integer", paramType = "path", dataType = "String", value = "研发后补助id")
    })
    public ResultModel getHzSubsidiesList(@PathVariable String nodeId,@PathVariable Integer pageNum) {
        ResultModel resultModel = new ResultModel();
        try {
            return interviewDataEntryService.getHzSubsidiesList(nodeId,pageNum);
        } catch (Exception e) {
            resultModel.setCode(Constant.INTERFACE_STATUS_CODE_3351);
            resultModel.setData(e.toString());
            e.printStackTrace();
        }
        return resultModel;
    }

}