| | |
|---|
| | | NVL ( b."actual_fund", 0 )) noPay |
|---|
| | | FROM |
|---|
| | | sjzt_md."tb_project" a |
|---|
| | | LEFT JOIN ( SELECT * FROM sjzt_md."tb_project_schedule" |
|---|
| | | LEFT JOIN ( |
|---|
| | | SELECT "tb_project_id",sum("actual_fund") "actual_fund" FROM sjzt_md."tb_project_schedule" |
|---|
| | | WHERE 1=1 |
|---|
| | | <if test="params.tbYear != null and params.tbYear !=''"> |
|---|
| | | AND "year" = #{params.tbYear} |
|---|
| | |
|---|
| | | <if test="params.tbMonth != null and params.tbMonth !=''"> |
|---|
| | | AND "month" = #{params.tbMonth} |
|---|
| | | </if> |
|---|
| | | group by "tb_project_id" |
|---|
| | | ) b ON a."guid" = b."tb_project_id" |
|---|
| | | </select> |
|---|
| | | <select id="getStatisticsPies" resultType="cn.gistack.sm.sjztmd.vo.StatisticsPrice"> |
|---|
