select * from biz_estimate be left join biz_project_management pm on be.PROJECT_ID_ = pm.ID_ ${ew.customSqlSegment} where be.IS_DELE_ = '0' and pm.IS_DELE_ = '0' and pm.VALID_FLAG_ = 1 and be.ID_ = #{id,jdbcType=VARCHAR} SELECT IFNULL(SUM(PAYEE_AMOUNT_TOTAL_),"0") FROM BIZ_PROGRESS_MANAGE WHERE IS_DELE_ = '0' AND DATE_FORMAT(REGISTER_DATE_,'%Y') = #{year} AND PROJECT_ID_ = #{pid}