|
<action name="queryV_R_BProjectStatisticsAction" procedure="bizQueryProcedure">
<permission name="range" type="List"/>
<private name="concept" type="String" value="V_R_BProjectStatistics"/>
<private name="select" type="String" value="V_R_BProjectStatistics.*"/>
<private name="from" type="String" value="V_R_BProjectStatistics V_R_BProjectStatistics"/>
<private name="aggregate" type="String" value="sum(C13) as C13, sum(C14) as C14, sum(C15) as C15, sum(C17) as C17, sum(C19) as C19, SUM(CASE WHEN C6 = '否' THEN C20 WHEN C6 = '是' AND C20 < 0 THEN C20 ELSE 0 END) AS C20, sum(C23) as C23, sum(C24) as C24, sum(C25) as C25, sum(C26) as C26, sum(C27) as C27, sum(C28) as C28, sum(C29) as C29, sum(C31) as C31, sum(C32) as C32, sum(C33) as C33, sum(C34) as C34, sum(C35) as C35, sum(C36) as C36,sum(vTotalPaymentByCont) as vTotalPaymentByCont,sum(vTotalAmountByCont) as vTotalAmountByCont,sum(vAccumulatedReceivable) as vAccumulatedReceivable,sum(V_R_BProjectStatistics.fSafeConstructCost) AS vSafeConstructCost,sum(V_R_BProjectStatistics.fAccruedAmt) AS vAccruedAmt,SUM(CASE WHEN C6 = '否' THEN C20 WHEN C6 = '是' AND C20 < 0 THEN C20 ELSE 0 END)+sum(17) AS vExpectWholeIncome,sum(V_R_BProjectStatistics.fCashDeposit) AS vCashDeposit,sum(V_R_BProjectStatistics.fManagersNum) AS vManagersNum,sum(V_R_BProjectStatistics.fDepositPsnNum) AS vDepositPsnNum"/>
<private name="dataModel" type="String" value="/BCEG/ECON/data"/>
<private name="fnModel" type="String"/>
<protected name="condition" type="String"/>
<public name="distinct" type="Boolean" value="false"/>
<public name="idColumn" type="String" value="V_R_BProjectStatistics"/>
<public name="filter" type="String"/>
<public name="limit" type="Integer"/>
<public name="offset" type="Integer"/>
<public name="columns" type="String"/>
<public name="orderBy" type="String"/>
<public name="aggregateColumns" type="String"/>
<public name="variables" type="Map"/>
<label language="zh_CN">在施项目经济指标台账查询</label>
</action>
|
|