select *, pm.RESPONSIBLE_UNIT_ pRUnit, pm.COMPLETION_TIME_ pCTime, pm.COMMENCEMENT_TIME_ pCommTime, pm.PROJECT_TYPE_ pType, pm.PROJECT_NAME_ pName, pm.PROJECT_CODE_ pCode from biz_decision_annual_plan bdap left join biz_project_management pm on bdap.PROJECT_ID_ = pm.ID_ ${ew.customSqlSegment} where bdap.IS_DELE_ = '0' -- and pm.IS_DELE_ = '0' and pm.VALID_FLAG_ = 1 and bdap.ID_ = #{id,jdbcType=VARCHAR} SELECT SUM(INVESTMENT1_) '01',SUM(INVESTMENT2_) '02',SUM(INVESTMENT3_) '03',SUM(INVESTMENT4_) '04', SUM(INVESTMENT5_) '05',SUM(INVESTMENT6_) '06',SUM(INVESTMENT7_) '07',SUM(INVESTMENT8_) '08', SUM(INVESTMENT9_) '09',SUM(INVESTMENT10_) '10',SUM(INVESTMENT11_) '11',SUM(INVESTMENT12_) '12' FROM biz_decision_annual_plan WHERE IS_DELE_ = 0 AND PROJECT_ID_ = #{statisticsVo.projectId} AND PROJECT_TYPE_ = #{statisticsVo.type}