select *, pm.OWNER_UNIT_ ownerUnit from biz_bidding_management bbm left join biz_project_management pm on bbm.PROJECT_ID_ = pm.ID_ ${ew.customSqlSegment} where bbm.IS_DELE_ = '0' and pm.IS_DELE_ = '0'and pm.VALID_FLAG_ = 1 and bbm.ID_ = #{id,jdbcType=VARCHAR} INSERT INTO BIZ_BIDDING_MANAGEMENT (ID_) VALUES (#{entity.id}) SELECT a.BIDDING_CHARGE_TYPE_ type, COUNT( * ) total FROM BIZ_BIDDING_MANAGEMENT a LEFT JOIN biz_project_management b ON a.PROJECT_ID_=b.ID_ WHERE a.BIDDING_CHARGE_TYPE_ is not null AND a.BIDDING_CHARGE_TYPE_ != '' AND a.IS_DELE_ = 0 AND a.PROJECT_ID_ = #{statisticsVo.projectId} AND b.PROJECT_TYPE_ = #{statisticsVo.type} AND a.COMMENCEMENT_DATE_ >= #{statisticsVo.startTime} AND a.COMMENCEMENT_DATE_ <= #{statisticsVo.endTime} GROUP BY a.BIDDING_CHARGE_TYPE_ ORDER BY a.BIDDING_CHARGE_TYPE_