select *, bc.CONTRACT_AMOUNT_ contractAmount
from biz_progress_manage bpm
left join biz_project_management pm on bpm.PROJECT_ID_ = pm.ID_
left join biz_contract bc on bpm.CONTRACT_ID_ = bc.ID_
${ew.customSqlSegment}
SELECT
MONTH(a.REGISTER_DATE_) mouth,
SUM(a.PAYEE_AMOUNT_TOTAL_ ) paymentTotal
FROM
BIZ_PROGRESS_MANAGE a LEFT JOIN biz_project_management b ON a.PROJECT_ID_=b.ID_
WHERE a.IS_DELE_ = 0
AND a.PROJECT_ID_ = #{statisticsVo.projectId}
AND b.PROJECT_TYPE_ = #{statisticsVo.type}
AND a.REGISTER_DATE_ >= #{statisticsVo.startTime}
AND a.REGISTER_DATE_ <= #{statisticsVo.endTime}
GROUP BY
MONTH(a.REGISTER_DATE_)
ORDER BY
MONTH(a.REGISTER_DATE_)
SELECT SUM(PAYEE_AMOUNT_TOTAL_) AS total
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
AND REGISTER_DATE_ <= #{registerDate}
AND CONTRACT_ID_ = #{contractId}
SELECT SUM(PAYEE_AMOUNT_TOTAL_) AS total
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
AND REGISTER_DATE_ < #{registerDate}
AND ID_ != #{id}
AND CONTRACT_ID_ = #{contractId}
SELECT SUM(PAYEE_AMOUNT_TOTAL_)
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0' AND PURPOSE_ = '1'
AND PROJECT_ID_ = #{projectId}
AND REGISTER_DATE_ <= #{registerDate}
SELECT SUM(PAYEE_AMOUNT_TOTAL_)
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0' AND PURPOSE_ != '1'
AND PROJECT_ID_ = #{projectId}
AND REGISTER_DATE_ <= #{registerDate}
SELECT
a.ID_ AS id,
a.PROJECT_ID_ AS projectId,
a.REGISTER_DATE_ AS registerDate,
a.PURPOSE_ AS purpose,
TRUNCATE (( a.TOTAL_INVESTMENT_ / 10000 ), 0 ) AS totalInvestment,
b.amountAppropriated,
(b.amountAppropriated/(a.TOTAL_INVESTMENT_/10000)) AS measurementData,
TRUNCATE(b.amountAppropriated/0.75, 0) AS outputValue,
a.REMARKS_ AS remarks
FROM
BIZ_PROGRESS_MANAGE a,
( SELECT TRUNCATE(SUM( PAYEE_AMOUNT_TOTAL_ )/10000, 0) AS amountAppropriated FROM BIZ_PROGRESS_MANAGE WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{vo.projectId}
AND PURPOSE_ = #{vo.purpose}
AND REGISTER_DATE_ <= #{vo.registerDate}
) b
WHERE
a.IS_DELE_ = '0'
AND a.PROJECT_ID_ = #{vo.projectId}
AND a.PURPOSE_ = #{vo.purpose}
AND a.REGISTER_DATE_ <= #{vo.registerDate}
ORDER BY
a.REGISTER_DATE_ DESC
LIMIT 1
SELECT SUM(PAYEE_AMOUNT_TOTAL_)
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
SELECT SUM(PAYEE_AMOUNT_TOTAL_)
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
AND PURPOSE_ = #{purpose}
SELECT IFNULL(SUM(PAYEE_AMOUNT_TOTAL_),"0") FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{pid}
AND PURPOSE_ NOT IN
#{listItem}
SELECT distinct (PROJECT_ID_)
FROM BIZ_PROGRESS_MANAGE
where IS_DELE_ = '0'
and PURPOSE_ = '1'
select * from biz_progress_manage
where IS_DELE_ = '0'
and PURPOSE_ = '1'
and PROJECT_ID_ = #{projectId}
and CONTRACT_ID_ is not null
SELECT SUM(PAYEE_AMOUNT_TOTAL_)
FROM BIZ_PROGRESS_MANAGE
WHERE IS_DELE_ = '0' AND PURPOSE_ = '1'
AND PROJECT_ID_ = #{projectId}
AND CONTRACT_ID_ = #{contractId}
AND REGISTER_DATE_ <= #{registerDate}
AND ID_ != #{id}