select *, pm.OWNER_UNIT_ ownerUnit
from biz_progress_manage_report bpmr
left join biz_project_management pm on bpmr.PROJECT_ID_ = pm.ID_
left join biz_contract bc on bpmr.CONTRACT_ID_ = bc.ID_
${ew.customSqlSegment}
SELECT SUM(PROGRESS_DESCRIPTION_)
FROM biz_progress_manage_report
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
AND PORT_DATE_ < #{portDate}
AND CONTRACT_ID_ = #{contractId}
SELECT
MONTH(a.PORT_DATE_) mouth,
SUM(a.PROGRESS_DESCRIPTION_ ) investmentTotal,
SUM(a.ENGINEERING_CHANGE_) outputTotal
FROM
BIZ_PROGRESS_MANAGE_REPORT 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.PORT_DATE_ >= #{statisticsVo.startTime}
AND a.PORT_DATE_ <= #{statisticsVo.endTime}
GROUP BY
MONTH(a.PORT_DATE_)
ORDER BY
MONTH(a.PORT_DATE_)
select *
from biz_progress_manage_report
where IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId,jdbcType=VARCHAR}
ORDER BY PORT_DATE_ DESC LIMIT 1
SELECT
b.PROJECT_OVERVIEW as projectOvervie,
a.PROJECT_ID_ as projectId,
a.PORT_DATE_ as portDate,
a.IMAGE_PROGRESS_ as imageProgress,
a.ENGINEERING_CHANGE_ as engineeringChange,
a.WEEKLY_MOUTHLY_WORK_ as weeklyMouthlyWork
FROM
( SELECT SUM( PROGRESS_DESCRIPTION_ / 0.75 ) AS PROJECT_OVERVIEW, PROJECT_ID_ FROM biz_progress_manage_report WHERE IS_DELE_ = '0' AND PROJECT_ID_ = #{projectId} ) b
left JOIN(
SELECT
*
FROM
biz_progress_manage_report
WHERE
IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
AND DATE_FORMAT( PORT_DATE_, '%Y-%m' ) = #{portDate}
ORDER BY
PORT_DATE_ DESC
LIMIT 1
) a
ON a.PROJECT_ID_ = b.PROJECT_ID_
SELECT distinct (PROJECT_ID_)
FROM BIZ_PROGRESS_MANAGE
where IS_DELE_ = '0'
select * from biz_progress_manage_report
where IS_DELE_ = '0'
and PROJECT_ID_ = #{projectId}
SELECT SUM(PROGRESS_DESCRIPTION_)
FROM biz_progress_manage_report
WHERE IS_DELE_ = '0'
AND PROJECT_ID_ = #{projectId}
AND PORT_DATE_ <= #{portDate}
AND ID_ != #{id}