| | |
|---|
| | | .select(" ( select ifnull( sum( CASE WHEN t.bill_type = 0 and yw.REVENUE_TYPE = 0 THEN yw.ACT_RECEIVABLE_FEE when t.bill_type = 0 and yw.REVENUE_TYPE = 1 then -yw.ACT_RECEIVABLE_FEE when t.bill_type = 1 and yw.REVENUE_TYPE = 0 then -yw.ACT_RECEIVABLE_FEE else yw.ACT_RECEIVABLE_FEE END),0) from yw_contract_revenue yw where yw.bill_id = t.id and yw.status = 0 and yw.isdeleted = 0 ) as actReceivableFee ") |
|---|
| | | .selectAs(YwContract::getCode,YwContractBill::getContractCode) |
|---|
| | | .selectAs(YwCustomer::getName,YwContractBill::getCustomerName) |
|---|
| | | .selectAs(Company::getId,YwContractBill::getCompanyId) |
|---|
| | | .selectAs(Company::getName,YwContractBill::getCompanyName) |
|---|
| | | .selectAs(SystemUser::getRealname,YwContractBill::getRealname) |
|---|
| | | .leftJoin(YwContract.class,YwContract::getId,YwContractBill::getContractId) |
|---|
