项目库导入 __FDIGNpKZD4IqfM2Ji1G __FDIGNpKZD4IqfM2Ji1G 16 2048 1536 rollback 1645092338484 项目档案 0 412 357 142 34 projectLibrary 1645092341812 建设年度 0 26 204 142 34 year false 1645092338484 1645092341812 false false 459;199;412;357 1645092351980 1645092375172 计划开始时间 0 27 149 142 34 startData false 1645092338484 1645092375172 false false 725;213;412;357 1645092999684 1645093003716 项目状态 0 50 46 142 34 projectStatus false 1645093004276 项目名称 0 23 380 142 34 projectName false 1645093004548 项目编号 0 24 319 142 34 projectNumber false (function(){ println(@quot;我执行了导入脚本@quot;) //获取项目名称 var projectName = getItemValueAsString(@quot;projectName@quot;); //获取项目编号 var projectNumber = getItemValueAsString(@quot;projectNumber@quot;); //获取建设阶段 var phase = getItemValueAsString(@quot;phase@quot;); //获取建设年度 var year = getItemValueAsString(@quot;year@quot;); //获取计划开工时间 var startData = getItemValueAsString(@quot;startData@quot;); //获取计划竣工时间 var endData = getItemValueAsString(@quot;endData@quot;); //获取项目状态 var projectStatus = getItemValueAsString(@quot;projectStatus@quot;); //获取项目优先级 var projectPriority = getItemValueAsString(@quot;projectPriority@quot;); //获取采购方式 var procurementMethod = getItemValueAsString(@quot;procurementMethod@quot;); //获取项目分类 var projectType = getItemValueAsString(@quot;projectType@quot;); //获取所属单位 var unit = getItemValueAsString(@quot;unit@quot;); //根据所属单位名称获取所属单位id var unitid=getDeptIdByNameAndLevel(unit,1); //获取所属部门 var depart = getItemValueAsString(@quot;depart@quot;); //根据所属部门名称获取所属部门id var departid=getDeptIdByNameAndLevel(depart,1); //获取项目负责人名称 var projectLeader = getItemValueAsString(@quot;projectLeader@quot;); //获取项目负责人号码 var projectLeaderPhone = getItemValueAsString(@quot;projectLeaderPhone@quot;); //获取项目经理名称 var projectManager = getItemValueAsString(@quot;projectManager@quot;); //获取项目经理号码 var projectManagerPhone = getItemValueAsString(@quot;projectManagerPhone@quot;); //获取合同总金额 var contractGrandTotal = getItemValueAsString(@quot;contractGrandTotal@quot;); //获取说明 var explain = getItemValueAsString(@quot;explain@quot;); //获取项目计划总投资 var planInvestment = getItemValueAsString(@quot;planInvestment@quot;); //获取自有资金 var ownAmount = getItemValueAsString(@quot;ownAmount@quot;); //获取上年实际完成投资额 var lastYearComplete = getItemValueAsString(@quot;lastYearComplete@quot;); //获取上年末累计完成投资额 var lastYearUncomplete = getItemValueAsString(@quot;lastYearUncomplete@quot;); //获取已执行金额 var executedAmount = getItemValueAsString(@quot;executedAmount@quot;); //获取本年自有资金 var nowAmount = getItemValueAsString(@quot;nowAmount@quot;); //获取本年外部贷款 var nowLoan = getItemValueAsString(@quot;nowLoan@quot;); //获取本年其他资金 var nowOtherAmount = getItemValueAsString(@quot;nowOtherAmount@quot;); //获取本年主业资金 var nowMainAmount = getItemValueAsString(@quot;nowMainAmount@quot;); //获取本年非主业资金 var nowUnmainAmount = getItemValueAsString(@quot;nowUnmainAmount@quot;); //获取本年计划投资总额 var nowPlanInvestment = getItemValueAsString(@quot;nowPlanInvestment@quot;); //获取计划建设周期 var constructionCycle = getItemValueAsString(@quot;constructionCycle@quot;); //获取项目预期收益 var expectReturn = getItemValueAsString(@quot;expectReturn@quot;); //获取项目预期成本 var expectCost = getItemValueAsString(@quot;expectCost@quot;); //获取建设背景 var background = getItemValueAsString(@quot;background@quot;); //获取建设目标 var target = getItemValueAsString(@quot;target@quot;); //获取建设内容 var content = getItemValueAsString(@quot;content@quot;); //获取建设必要性 var necessity = getItemValueAsString(@quot;necessity@quot;); //获取调研情况 var research = getItemValueAsString(@quot;research@quot;); //获取成效分析 var results = getItemValueAsString(@quot;results@quot;); //获取备注 var note = getItemValueAsString(@quot;note@quot;); var process = getDocumentProcess(); var formProcess = getFormProcess(); //预算-需求信息 var subform = formProcess.doView(@quot;__LKbGIWE7gRFzroL11Zy@quot;); //需求上报表单Id var doc1 = process.doNew(subform,getWebUser(),createParamsTable()); var demandId = getId(); //项目名称 doc1.addStringItem(@quot;projectName@quot;,projectName); //项目编号 doc1.addStringItem(@quot;projectNumber@quot;,projectNumber); //建设阶段 doc1.addStringItem(@quot;phase@quot;,phase); //建设年度 doc1.addStringItem(@quot;year@quot;,year); //计划开工时间 doc1.addStringItem(@quot;startData@quot;,startData); //计划竣工时间 doc1.addStringItem(@quot;endData@quot;,endData); //项目优先级 doc1.addStringItem(@quot;projectPriority@quot;,projectPriority); //项目分类 doc1.addStringItem(@quot;projectType@quot;,projectType); //所属单位 doc1.addStringItem(@quot;unit@quot;,unitid); //所属部门 doc1.addStringItem(@quot;depart@quot;,departid); //项目负责人名称 doc1.addStringItem(@quot;head@quot;,projectLeader); //项目计划总投资 doc1.addStringItem(@quot;planInvestment@quot;,planInvestment); //自有资金 doc1.addStringItem(@quot;ownAmount@quot;,ownAmount); //上年实际完成投资额 doc1.addStringItem(@quot;lastYearComplete@quot;,lastYearComplete); //上年末累计完成投资额 doc1.addStringItem(@quot;lastYearUncomplete@quot;,lastYearUncomplete); //已执行金额 doc1.addStringItem(@quot;executedAmount@quot;,executedAmount); //本年自有资金 doc1.addStringItem(@quot;nowAmount@quot;,nowAmount); //本年外部贷款 doc1.addStringItem(@quot;nowLoan@quot;,nowLoan); //本年其他资金 doc1.addStringItem(@quot;nowOtherAmount@quot;,nowOtherAmount); //本年主业资金 doc1.addStringItem(@quot;nowMainAmount@quot;,nowMainAmount); //本年非主业资金 doc1.addStringItem(@quot;nowUnmainAmount@quot;,nowUnmainAmount); //本年计划投资总额 doc1.addStringItem(@quot;nowPlanInvestment@quot;,nowPlanInvestment); //计划建设周期 doc1.addStringItem(@quot;constructionCycle@quot;,constructionCycle); //项目预期收益 doc1.addStringItem(@quot;expectReturn@quot;,expectReturn); //项目预期成本 doc1.addStringItem(@quot;expectCost@quot;,expectCost); //建设背景 doc1.addStringItem(@quot;background@quot;,background); //建设目标 doc1.addStringItem(@quot;target@quot;,target); //建设内容 doc1.addStringItem(@quot;content@quot;,content); //建设必要性 doc1.addStringItem(@quot;necessity@quot;,necessity); //调研情况 doc1.addStringItem(@quot;research@quot;,research); //成效分析 doc1.addStringItem(@quot;results@quot;,results); //备注 doc1.addStringItem(@quot;note@quot;,note); //年度预算通过状态 doc1.addStringItem(@quot;subStatus@quot;,1); println(@quot;doc1:---------------------@gt;@quot;+doc1); var sql = @quot;select id from tlk_milepost where item_projectId='@quot;+demandId+@quot;' @quot;; var datas = queryByDSName(@quot;rtproject@quot;,sql); if(!datas.size()@gt;0){ var process = getDocumentProcess(); var formProcess = getFormProcess(); var docInfo = formProcess.doView(@quot;__TMD5uq8WChDenuuH1VV@quot;); //立项阶段 var ProposalStage = [@quot;立项上报@quot;,@quot;项目评审@quot;,@quot;项目签报@quot;]; for(var i=0;i@lt;ProposalStage.length;i++){ var node = ProposalStage[i]; var ProposalStageInfoDoc = process.doNew(docInfo,getWebUser(),createParamsTable()); ProposalStageInfoDoc.addStringItem(@quot;nodeName@quot;,node); ProposalStageInfoDoc.addStringItem(@quot;type@quot;,@quot;项目立项@quot;); ProposalStageInfoDoc.addStringItem(@quot;sequence@quot;,i); ProposalStageInfoDoc.addStringItem(@quot;projectId@quot;,demandId); process.doCreate(ProposalStageInfoDoc); } //采购阶段 var acquisitionPhase = [@quot;采购方案编写@quot;,@quot;采购方案评审@quot;,@quot;采购方案审批@quot;,@quot;采购谈判@quot;,@quot;集团与科研院合同签订@quot;]; for(var i=0;i@lt;acquisitionPhase.length;i++){ var node = acquisitionPhase[i]; var acquisitionPhaseInfoDoc = process.doNew(docInfo,getWebUser(),createParamsTable()); acquisitionPhaseInfoDoc.addStringItem(@quot;nodeName@quot;,node); acquisitionPhaseInfoDoc.addStringItem(@quot;type@quot;,@quot;项目采购@quot;); acquisitionPhaseInfoDoc.addStringItem(@quot;sequence@quot;,i); acquisitionPhaseInfoDoc.addStringItem(@quot;projectId@quot;,demandId); process.doCreate(acquisitionPhaseInfoDoc); } //执行阶段 var executePhase = [@quot;确定招标机构@quot;,@quot;发标@quot;,@quot;开标@quot;,@quot;科研院与成交人合同签订@quot;,@quot;项目启动会@quot;,@quot;项目实施@quot;]; for(var i=0;i@lt;executePhase.length;i++){ var node = executePhase[i]; var executePhaseInfoDoc = process.doNew(docInfo,getWebUser(),createParamsTable()); executePhaseInfoDoc.addStringItem(@quot;nodeName@quot;,node); executePhaseInfoDoc.addStringItem(@quot;type@quot;,@quot;项目执行@quot;); executePhaseInfoDoc.addStringItem(@quot;sequence@quot;,i); executePhaseInfoDoc.addStringItem(@quot;projectId@quot;,demandId); process.doCreate(executePhaseInfoDoc); } //验收阶段 var DemonstrationPhase = [@quot;验收准备@quot;,@quot;验收申请@quot;,@quot;验收审批@quot;]; for(var i=0;i@lt;DemonstrationPhase.length;i++){ var node = DemonstrationPhase[i]; var DemonstrationPhaseInfoDoc = process.doNew(docInfo,getWebUser(),createParamsTable()); DemonstrationPhaseInfoDoc.addStringItem(@quot;nodeName@quot;,node); DemonstrationPhaseInfoDoc.addStringItem(@quot;type@quot;,@quot;项目验收@quot;); DemonstrationPhaseInfoDoc.addStringItem(@quot;sequence@quot;,i); DemonstrationPhaseInfoDoc.addStringItem(@quot;projectId@quot;,demandId); process.doCreate(DemonstrationPhaseInfoDoc); } } process.doCreate(doc1); /* var sqlc=@quot;update tlk_budgetdemand set ITEM_BUDGETID='@quot;+BudgetId+@quot;' where ITEM_DEMANDID='@quot;+attDemandId+@quot;' and (ITEM_BUDGETID is null or ITEM_BUDGETID = '' )@quot;; updateByDSName(@quot;rtproject@quot;,sqlc); println(@quot;sql123-------@gt;@quot;+sqlc); */ //新项目计划上报 var processm = getDocumentProcess(); var formProcessm = getFormProcess(); var subformm = formProcessm.doView(@quot;__niYNqOG27CLK7fxfm3Y@quot;); //项目立项-新项目立项管理-新项目立项-项目计划上报表单Id var doc2 = processm.doNew(subformm,getWebUser(),createParamsTable()); //需求id doc2.addStringItem(@quot;demandId@quot;,demandId); //项目编号 doc2.addStringItem(@quot;projectNumber@quot;,projectNumber); //项目负责人名字 doc2.addStringItem(@quot;projectLeaderName@quot;,projectLeader); //项目负责人号码 doc2.addStringItem(@quot;projectLeaderPhone@quot;,projectLeaderPhone); //项目经理名称 doc2.addStringItem(@quot;ProjectManagername@quot;,projectManager); //项目经理号码 doc2.addStringItem(@quot;projectManagerPhone@quot;,projectManagerPhone); //采购方式 doc2.addStringItem(@quot;procurementMethod@quot;,procurementMethod); processm.doCreate(doc2); println(@quot;导入脚本结束@quot;) })() 1645092338484 1645093003716 false false 27;214;412;357 1645093062452 1645092338484 1645093004548 false false 28;166;412;357 1645093093749 1645092338484 1645093004276 false false 42;115;412;357 1645093119396 1645093122868 所属部门 0 568 46 142 34 depart false 1645093123548 所属单位 0 471 46 142 34 unit false 1645093124380 项目负责人 0 666 47 142 34 projectLeader false 1645093124691 项目优先级 0 153 46 142 34 projectPriority false 1645093125012 项目分类 0 370 46 142 34 projectType false 1645093126796 项目负责人手机号 0 762 48 142 34 projectLeaderPhone false 1645092338484 1645093124691 false false 188;55;412;357 1645093221524 1645092338484 1645093124380 false false 291;57;412;357 1645093313772 1645093338244 项目经理手机号 0 769 197 142 34 projectManagerPhone false 1645093338708 项目计划总投资 0 769 251 142 34 planInvestment false 1645093339365 采购方式 0 260 47 142 34 procurementMethod false 1645093339796 自有资金 0 769 306 142 34 ownAmount false 1645093340164 项目经理 0 768 129 142 34 projectManager false 1645093340492 计划结束时间 0 28 96 142 34 endData false 1645093340948 建设阶段 0 24 259 142 34 phase false 1645092338484 1645093125012 false false 83;52;412;357 1645093450749 1645092338484 1645093126796 false false 402;51;412;357 1645093486252 1645092338484 1645093123548 false false 515;53;412;357 1645093511932 1645092338484 1645093122868 false false 629;54;412;357 1645093535644 1645092338484 1645093340948 false false 26;251;412;357 1645097665270 1645092338484 1645093340492 false false 58;47;412;357 1645097808991 1645092338484 1645093339365 false false 744;206;412;357 1645097937678 1645092338484 1645093340164 false false 768;129;412;357 1645098006343 1645092338484 1645093338244 false false 769;197;412;357 1645098052614 1645092338484 1645093338708 false false 769;251;412;357 1645098079350 1645092338484 1645093339796 false false 769;306;412;357 1645098102838 1645098106230 上年实际完成投资额 0 768 362 142 34 lastYearComplete false 1645098106743 上年末累计完成投资额 0 768 425 142 34 lastYearUncomplete false 1645098107223 已执行金额 0 767 487 142 34 executedAmount false 1645098107558 本年自有资金 0 751 543 142 34 nowAmount false 1645098108039 本年外部贷款 0 650 546 142 34 nowLoan false 1645098108639 本年其他资金 0 545 548 142 34 nowOtherAmount false 1645098109222 本年主业资金 0 443 547 142 34 nowMainAmount false 1645098109783 本年非主业资金 0 344 547 142 34 nowUnmainAmount false 1645092338484 1645098106230 false false 768;362;412;357 1645098181518 1645092338484 1645098106743 false false 768;425;412;357 1645098206183 1645092338484 1645098107223 false false 767;487;412;357 1645098228839 1645092338484 1645098107558 false false 649;489;412;357 1645098251678 1645092338484 1645098108039 false false 526;490;412;357 1645098275438 1645092338484 1645098108639 false false 417;490;412;357 1645098296559 1645092338484 1645098109222 false false 308;491;412;357 1645098318455 1645092338484 1645098109783 false false 201;491;412;357 1645098343062 1645098345582 本年计划投资总额 0 237 547 142 34 nowPlanInvestment false 1645092338484 1645098345582 false false 66;474;412;357 1645098363230 1645257252201 合同总金额 0 127 541 142 34 contractGrandTotal false 1645257256702 说明 0 41 460 142 34 explain false 1645257267170 备注 0 35 525 142 34 note false 1645257252201 1645092338484 false false 412;357;70;523 1645260930316 1645257267170 1645092338484 false false 412;357;24;477 1645260935639 1645257256702 1645092338484 false false 412;357;25;434 1645260937994 ]]> /uploads/exceltemplate/项目档案模板.xlsx