ID_, OPERATE_TIME_, OPERATE_USER_ID_, OPERATE_USER_NAME_, NOTICE_ID_, NOTICE_CODE_, NOTICE_NAME_, NOTICE_DETAILED_ID_, PROCURE_ORG_ID_, PROCURE_ORG_CODE_, PROCURE_ORG_NAME_, QUOTATION_ID_, QUOTATION_ORG_ID_, QUOTATION_ORG_NAME_, QUOTATION_ORG_CODE_, QUOTATION_PRICE_, EVALUATING_METHODS_, EVALUATION_ID_, EVALUATION_CODE_, EVALUATION_NAME_, EVALUATION_SCORE_, SCORE_, REMARKS_, SN_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ select * from biz_bid_evaluation ${ew.customSqlSegment} SELECT SUM(SCORE_) FROM biz_bid_evaluation WHERE NOTICE_ID_ = #{noticeId} AND QUOTATION_ORG_ID_ = #{quoOrgId} AND IS_DELE_ = '0' SELECT NOTICE_ID_,QUOTATION_ORG_ID_,SUM(SCORE_) as 'SCORE_',row_number() over ( order by SUM(SCORE_) desc) as 'rank' FROM biz_bid_evaluation WHERE NOTICE_ID_ = #{noticeId} AND IS_DELE_ = '0' GROUP BY QUOTATION_ORG_ID_; SELECT a.*,b.MAT_PLATCODE_,b.MAT_CATEGORY_CODE_,b.MAT_CODE_,b.MAT_NAME_,b.MAT_MATERIAL_, b.MAT_SPEC_,b.MAT_NUM_,b.MAT_UNIT_,b.DEMAND_DATE,b.MAT_BRAND_, b.MAT_BASE_EXT_,b.MAT_OTHER_EXT_,b.TAX_RATE_,b.UNLOAD_ADDRESS_, b.MAXIMUM_PRICE_LIMIT_,b.REMARKS_ as 'matRemarks',b.PLAN_CODE_, b.ACCEPTANCE_TIME_,b.PENDING_TIME_,b.MAT_ID_,c.TENDER_EXPLAIN_, c.IS_TAX_,b.PURCHASING_APPLICATION_DETAIL_ID_,b.PURCHASING_APPLICATION_ID_ FROM biz_bid_evaluation a LEFT JOIN (SELECT * FROM biz_mat_approval_details WHERE IS_DELE_ = '0') b ON a.NOTICE_DETAILED_ID_ = b.ID_ LEFT JOIN biz_bidding_quotation c ON a.QUOTATION_ID_ = c.ID_ ${ew.customSqlSegment} SELECT a.*,b.MAT_PLATCODE_,b.MAT_CATEGORY_CODE_,b.MAT_CODE_,b.MAT_NAME_,b.MAT_MATERIAL_, b.MAT_SPEC_,b.MAT_NUM_,b.MAT_UNIT_,b.DEMAND_DATE,b.MAT_BRAND_, b.MAT_BASE_EXT_,b.MAT_OTHER_EXT_,b.TAX_RATE_,b.UNLOAD_ADDRESS_, b.MAXIMUM_PRICE_LIMIT_,b.REMARKS_ as 'matRemarks',b.PLAN_CODE_, b.ACCEPTANCE_TIME_,b.PENDING_TIME_,b.MAT_ID_,c.TENDER_EXPLAIN_, c.IS_TAX_,b.PROJECT_INFO_ID_,b.PROJECT_LEDGER_ID_,b.DETAIL_TYPE_, b.PROJECT_SOURCE_TYPE_,b.PLANNED_PRICE_,b.SERVICE_START_TIME_, b.SERVICE_END_TIME_,b.BUILDING_AREA_,b.CONSTRUCTION_ENGINEERING_, b.EQUIPMENT_PROCUREMENT_,b.OTHER_EXPENSES_,b.EQUIPMENT_CLASSIFICATION_, b.TECHNICAL_REQUIREMENT_,b.PROJECT_STATUS_,b.PROJECT_DESCRIPT_, b.PERSON_LIABLE_ID_,b.PERSON_LIABLE_NAME_,b.PERSON_LIABLE_PHONE_, b.BOND_ FROM biz_bid_evaluation a LEFT JOIN (SELECT * FROM biz_project_approval_details WHERE IS_DELE_ = '0') b ON a.NOTICE_DETAILED_ID_ = b.ID_ LEFT JOIN biz_bidding_quotation c ON a.QUOTATION_ID_ = c.ID_ ${ew.customSqlSegment}