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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyDeclareprojectLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyYearMultipleoptionsLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyHighleveltalentsLk[].class); System.err.println("requestListrequestListrequestListrequestList:{}" + JSON.toJSONString(requestList)); try { List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyHignendproductLk[].class); try { List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyIurLk[].class); try { List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyProductLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyTechrequirementLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyIntellectualpropertyLk[].class); try { List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyStaffInfo[].class); try { List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyResearchfindingLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanySpecialtyLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyLabLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyProjectLk[].class); List resultList = new ArrayList(); 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 requestList = Util.fromJson2List(Util.toJson(requestModel.getData()), CompanyAbutmentStatus[].class); List resultList = new ArrayList(); 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 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 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 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 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; } }