接口需求文档

1、接口需求说明文档一、项目1.2项目参数说明别名参数名称参数修改类型修改类型长度备注项目编号projectNumbervarchar120后台生存项目名称projectNamevarchar120必填项目管理单位projectManageUserint11默认值项目进度projectSchedulevarchar120必填项目进度：已立项、进行中、已完结；注（客户端判断）项目进度名称项目日期startDatedate0立项日期，必填批准立项文号approveFilevarchar120无，非必填项目预算projectFinancialprojectFinancialstrvarchardecim

2、al12项目预算=拆迁资金+建设资金+其他资金调整预算=拆迁资金+建设资金+其他资金预算、拆迁资金、建设资金为手动输入，其他资金计算出；拆迁资金removeCapital1removeCapital1strvarchardecimal12建设资金buildCapital1buildCapital1strvarchardecimal12其他Other1Other1strvarchardecimal12调整预算adjustmentFinancialadjustmentFinancialstrvarcharvarchar255拆迁资金removeCapital2removeCapital2strva

3、rchardecimal12建设资金buildCapital2buildCapital2strvarchardecimal12其他Other2Other2strvarchardecimal12调整批文号projectAccumulativevarchar120非必填调整后总额adjustlnvestmentadjustlnvestmentstrvarchardecimal12调整后总额=项目预算+调整预算预算、拆迁资金、建设资金为手动输入，其他财政资金financeCapitalfinanceCapitalstrvarchardecimal12融资资金financingCapitalfinan

4、cingCapitalstrvarchardecimal12资金计算出；其他资金otherCapitalotherCapitalstrvarchardecimal12街镇自筹higherCapitahigherCapitastrvarchardecimal12必须等于调整后总额附件上传projectapprovalfilevarchar2000非必填项目状态stateint111未提交2待审核3已审核4已完结二、合同2.1合同对应字段说明注：金额以修改后的为准别名参数名称类型参数修改类型修改长度备注资金来源capitalsourcevarchar120回显信息如果资金来源为街镇自筹，合同状态就

5、为3审核状态如果资金来源不为街镇自筹，合同状态就为1未审状态项目年度projectyearvarchar120回显信息（项目日期）项目名称projectidint11回显信息项目管理单位constructiounoitidint11下拉菜单，默认为城建投合同名称capitalnamevarchar120必填合同编号capitalnovarchar120必填（唯一性）招标办备案编号servenovarchar255非必填合同签订日期contractdatedate0（签订时间）必填合同类型capitaltypevarchar255必填合同类型：勘察设计监理咨询合同、拆迁补偿合同、施工合同、设备采

6、购合同、其他合同、管理费用；注（客户端判断）施工单位roadworkunitvarchar255必填施工单位账号constructionunitaccountvarchar255必填施工单位账号开户银行constructionunitbankvarchar255必填项目进度articleschedulevarchar255必填项目进度：签订合同、合同执行中、竣工验收、完成财评、完成审计审核、质保结束；注（客户端判断）合同价格capitalpricedecimalcapitalpricestrvarchar12必填追加金额addmoneydecimaladdmoneystrvarchar12合同

7、总金额contractmoneycountdecimalcontractmoneycountstrvarchar12竣工验收时间checkdatedate0非必填财评审核金额investmentmoneycountdecimalinvestmentmoneycountstrvarchar12必填财评审核时间auditdatedate0非必填审计局审计价格instancepricedecimalinstancepricestrvarchar12非必填审计局审计时间reviewdatedate0非必填审结文号concludenumbervarchar255非必填审结备注concluderemark

8、svarchar255非必填质保金额warrantymoneydecimalwarrantymoneystrvarchar12非必填质保期限warrantydatedate0非必填合同附件contractattachmentvarchar2550非必填资金审批附件capitalcapitalvarchar2550非必填备注remarks4varchar255非必填姓名（填单人）loginusernamevarchar255默认值合同状态contractstateint111未提交2待审核3已审核4完结2.2合同预付节点2.2.1合同预付节点对应字段说明别名参数名称类型长度备注付款次数prepa

9、ynumberint11下拉菜单合同编号contractidvarchar255合同idrealcontractidint11付款次数下拉菜苒单值：数字110预付节点名称nodetextvarchar255下拉菜单预付节点名称：合同预付款、合同进度款、完成竣工验收、完成财评审核、合同质保金、其他付款；注（客户端判断）预付日期expectdatadate0必填支付比例prepayscalefloat0必填金额moneyfloat0必填是否完结isfinishedint11下拉菜单是否完结：未完结0、已完结1；2.3合同审核后修改查看字段别名参数名称类型长度备注主键IDint10contracti

10、d合同idint11capitalsource资金来源varchar120responsibilitymain项目责任主体varchar120projecttype项目类型varchar120projectid项目idint11projectyear项目年度varchar120capitalname合同名称varchar120capitalno合同编号varchar120capitaltype合同类型varchar255projectaddress项目地址varchar255replyfile批复文件varchar255capitalpricestr合同价格varcharcontractdat

11、e合同签定时期date0constructionunitid建设单位IDint11roadworkunit施工单位varchar255roadworkdate施工时间date0projectfeature工程特征varchar255instancepricestr审订价格varcharreviewdate审订时间date0reviewprice评审价格decimal12auditdate审计时间date0projectschedule工程已支付进度float255projectmoneybalance工程资金余额decimal12moneyproportion资金支付比例decimal12ch

12、eckdate竣工验收时间date0warrantymoneystr质保金额varchar12warrantydate质保期限date0loginusername登陆人姓名varchar255articleschedule项目进度varchar255contractattachment合同附件varchar255capitalcapital资金审批附件varchar255biddingno中标通知书编号varchar255serveno备案的编号varchar255contractstate合同状态int11constructionunitaccount施工单位账号varchar255cons

13、tructionunitbank施工单位开户银行varchar255addmoneystr添加金额varcharcontractmoneycountstr合同总金额varcharconcludenumber审结文号varchar255concluderemarks审结备注varchar255remarks3审核意见varchar255paymode付款方式varchar255remarks4varchar255contracttotalmoneystr合同累计付款余额varcharinvestmentmoneycountstr财评审核金额varchar三、资金拨付申请3.1资金拨付对应字段说明

14、别名参数名称类型长度参数修改类型修改备注申请付款日期applydatedate0默认值附件上传uploadfilevarchar2550非必填行政区划checkexplainvarchar255默认值（望城区）申请付款金额paymentmoneydecimal12paymentmoneystrvarchar必填拨付资金来源sourcesvarchar255必填（下拉菜单）拨付资金来源：财政资金、融资资金、体质分成、街镇自筹、上级资金；注（客户端判断）资金来源明细sourcesdetailvarchar255必填付款单位账号payunitidvarchar255默认值（国库集中支付）收款单位ro

15、adworkunitvarchar255回显收款单位开户行constructionunitbankvarchar255回显收款单位账号constructionunitaccountvarchar255回显申请依据remarkvarchar255非必填单据状态stateint111新增2提交4审核通过5完结合同资金来源为街镇自筹，资金拨付状态就为审核通过申请人gatbanknamevarchar255默认值（城建投）3.2资金申请记录字段说明别名参数名称类型长度备注审核状态（同单据状态）stateint111新增2提交4审核通过5完结单据编号receiptsidvarchar255回显审核角色checkrolevarchar255回显审核人checkuservarchar255回显审核时间paymentdatedate0回显审核金额paymentmoneydecimal12等于申请付款金额合同余额contractbalancedecimal12累计已支付金额=申请付款金