| | |
|---|
| | | public FieldSetEntity getContractInfoByName(FieldSetEntity fs) throws BaseException { |
|---|
| | | FieldSetEntity fss = baseDao.getFieldSetEntity(CmnConst.LX_PROJECT_CONTRACT_INFO,fs.getUUID(),true); |
|---|
| | | FieldSetEntity fsProject = baseDao.getFieldSetEntity(CmnConst.PRODUCT_PROJECT_BUSINESS,fss.getString("project_uuid"),false); |
|---|
| | | FieldSetEntity fsCustomer = baseDao.getFieldSet("product_project_customer", fsProject.getString("customer_name"), false); |
|---|
| | | FieldSetEntity contractName = baseDao.getFieldSetEntityBySQL("SELECT sum(invoice_amount) invoice_amount FROM product_project_contract_invoice_info WHERE contract_invoice_uuid in(SELECT uuid FROM product_project_contract_invoice where contract_name=?)", new String[]{fs.getString("uuid")},false); |
|---|
| | | if (contractName==null||StringUtils.isEmpty(contractName.getString("invoice_amount"))){ |
|---|
| | | fss.setValue("invoice_amount",0); |
|---|
| | | }else { |
|---|
| | | fss.setValue("invoice_amount",contractName.getString("invoice_amount")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | fss.setValue("customer_name", fsCustomer.getString("customer_name")); |
|---|
| | | fss.setValue("collection_amount",0); |
|---|
| | | fss.setValue("project_num",fsProject.getString("project_num")); |
|---|
| | | fss.setValue("project_name",fsProject.getString("project_name")); |
|---|
