select *, pm.PROJECT_CODE_ PC, bc.CONTRACT_AMOUNT_ contractAmount
from biz_change_management bcm
left join biz_project_management pm on bcm.PROJECT_ID_ = pm.ID_
left join biz_contract bc on bc.ID_ = bcm.CHANGE_CONTRACT_ID_
${ew.customSqlSegment}
SELECT
a.CHANGE_TYPE_ type,
SUM(a.CHANGE_PRICE_ ) total
FROM
biz_change_management a LEFT JOIN biz_project_management b ON a.PROJECT_ID_=b.ID_
WHERE a.IS_DELE_ = 0 AND a.CHANGE_TYPE_ is not null AND a.CHANGE_TYPE_ != ''
AND a.PROJECT_ID_ = #{statisticsVo.projectId}
AND b.PROJECT_TYPE_ = #{statisticsVo.type}
AND a.CHANGE_DATE_ >= #{statisticsVo.startTime}
AND a.CHANGE_DATE_ <= #{statisticsVo.endTime}
GROUP BY
a.CHANGE_TYPE_
ORDER BY
a.CHANGE_TYPE_
SELECT
MONTH(a.CHANGE_DATE_) mouth,
COUNT(*) total
FROM
biz_change_management a LEFT JOIN biz_project_management b ON a.PROJECT_ID_=b.ID_
WHERE a.IS_DELE_ = 0 AND a.CHANGE_DATE_ is not null
AND a.PROJECT_ID_ = #{statisticsVo.projectId}
AND b.PROJECT_TYPE_ = #{statisticsVo.type}
AND a.CHANGE_DATE_ >= #{statisticsVo.startTime}
AND a.CHANGE_DATE_ <= #{statisticsVo.endTime}
GROUP BY
MONTH(a.CHANGE_DATE_)
ORDER BY
MONTH(a.CHANGE_DATE_)
SELECT SUM(bcm.CHANGE_PRICE_) total
from biz_change_management bcm
left join biz_project_management pm on bcm.PROJECT_ID_ = pm.ID_
left join biz_contract bc on bc.ID_ = bcm.CHANGE_CONTRACT_ID_
and bcm.IS_DELE_ = 0
and pm.IS_DELE_ = 0
and pm.VALID_FLAG_ = 1
-- and bc.IS_DELE_ = 0
and bcm.PROJECT_ID_ = #{pid}