项目库导入
__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