ID_, VALUATION_CONFIGURATION_ID_, VALUATION_CONFIGURATION_NAME_, VALUATION_CONFIGURATION_CODE_, ENTERPRISE_ID_, ENTERPRISE_CODE_, INITIATOR_ID_, INITIATOR_ACCOUNT_, INITIATOR_NAME_, SUPPLIER_ENTERPRISE_ID_, SUPPLIER_NAME_, SUPPLIER_NUMBER_, ASSESSMENT_TYPE_, ASSESSMENT_START_DATE_, ASSESSMENT_END_DATE_, ASSESSMENT_YEAR_, ASSESSMENT_MONTH_, ASSESSMENT_QUATER_, DESC_, TOTAL_SCORE_, OPERATION_SCORE_, LEVEL_, ASSESSMENT_RESULT_, STATUS_, SEQ_, REMARKS_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ SELECT eva.VALUATION_CONFIGURATION_ID_, eva.VALUATION_CONFIGURATION_NAME_, eva.VALUATION_CONFIGURATION_CODE_, eva.ENTERPRISE_ID_, eva.ENTERPRISE_CODE_, eva.ENTERPRISE_NAME_, eva.SUPPLIER_CATEGORY_ID_, eva.SUPPLIER_CATEGORY_CODE_, eva.SUPPLIER_CATEGORY_NAME_, eva.INITIATOR_ID_, eva.INITIATOR_ACCOUNT_, eva.INITIATOR_NAME_, eva.ASSESSMENT_START_DATE_, eva.ASSESSMENT_END_DATE_, eva.ASSESSMENT_YEAR_, eva.ASSESSMENT_MONTH_, eva.ASSESSMENT_QUATER_, eva.ASSESSMENT_TYPE_, eva.DESC_, result.SUPPLIER_ID_, result.SUPPLIER_NAME_, result.SUPPLIER_CODE_, result.TOTAL_SCORE_, result.OPERATION_SCORE_, result.LEVEL_, result.ASSESSMENT_RESULT_, result.PROCESS_TYPE_, result.STATUS_, result.ID_ FROM biz_supplier_performance_evaluation eva INNER JOIN biz_supplier_performance_evaluation_result result ON eva.ID_=result.EVALUATION_ID_ ${ew.customSqlSegment} SELECT eva.*, CASE WHEN TOTAL_NUM = FINISH_NUM THEN 2 WHEN FINISH_NUM > 0 THEN 1 WHEN FINISH_NUM = 0 THEN 0 END AS isOpt FROM biz_supplier_performance_evaluation eva INNER JOIN ( SELECT er.PERFORMANCE_EVALUATION_ID_, COUNT(ur.ID_) AS TOTAL_NUM, COUNT(CASE WHEN ur.STATUS_ = 1 THEN 1 END) AS FINISH_NUM FROM biz_supplier_performance_evaluation_rating_user ur INNER JOIN biz_supplier_performance_evaluation_rating er ON ur.EVALUATION_RATING_ID_ = er.ID_ WHERE ur.IS_DELE_ = '0' AND er.IS_DELE_ = '0' AND RATING_ACCOUNT_ = #{account} GROUP BY PERFORMANCE_EVALUATION_ID_ ) rat ON eva.ID_ = rat.PERFORMANCE_EVALUATION_ID_ ${ew.customSqlSegment} SELECT eva.VALUATION_CONFIGURATION_ID_, eva.VALUATION_CONFIGURATION_NAME_, eva.VALUATION_CONFIGURATION_CODE_, eva.ENTERPRISE_ID_, eva.ENTERPRISE_CODE_, eva.ENTERPRISE_NAME_, eva.SUPPLIER_CATEGORY_ID_, eva.SUPPLIER_CATEGORY_CODE_, eva.SUPPLIER_CATEGORY_NAME_, eva.INITIATOR_ID_, eva.INITIATOR_ACCOUNT_, eva.INITIATOR_NAME_, eva.ASSESSMENT_START_DATE_, eva.ASSESSMENT_END_DATE_, eva.ASSESSMENT_YEAR_, eva.ASSESSMENT_MONTH_, eva.ASSESSMENT_QUATER_, eva.ASSESSMENT_TYPE_, eva.DESC_, er.SUPPLIER_ID_, er.SUPPLIER_NAME_, er.SUPPLIER_CODE_, er.TOTAL_SCORE_, er.OPERATION_SCORE_, er.LEVEL_, er.ASSESSMENT_RESULT_, er.PROCESS_TYPE_, er.STATUS_, er.ID_, nt.notification_status_ AS notificationStatus, nt.id_ AS notificationId, rt.id_ AS reportId, CASE WHEN rt.correction_status_ IS NULL AND er.PROCESS_TYPE_='2' THEN '0' ELSE rt.correction_status_ END AS correctionStatus FROM biz_supplier_performance_evaluation eva INNER JOIN biz_supplier_performance_evaluation_result er ON eva.ID_=er.EVALUATION_ID_ INNER JOIN biz_supplier_performance_evaluation_notification nt ON er.ID_ = nt.PERFORMANCE_EVALUATION_ID_ LEFT JOIN biz_supplier_performance_evaluation_correction_report rt ON rt.notification_id_=nt.ID_ ${ew.customSqlSegment} SELECT rt.SUPPLIER_ID_, rt.SUPPLIER_NAME_, rt.SUPPLIER_CODE_, ru.ID_, ru.OPERATION_SCORE_, ru.STATUS_, ru.RATING_ID_, ru.RATING_ACCOUNT_, ru.RATING_NAME_, ru.RATING_TIME_, ru.SCORE_, ru.PERFORMANCE_EVALUATION_ID_, ru.EVALUATION_RATING_ID_ FROM biz_supplier_performance_evaluation_result rt INNER JOIN biz_supplier_performance_evaluation_rating rat ON rt.ID_ = rat.PERFORMANCE_EVALUATION_RESULT_ID_ INNER JOIN biz_supplier_performance_evaluation_rating_user ru ON rat.ID_ = ru.EVALUATION_RATING_ID_ WHERE rt.IS_DELE_ = '0' AND rat.IS_DELE_ = '0' AND ru.IS_DELE_ = '0' AND ru.RATING_ACCOUNT_=#{account} AND rat.PERFORMANCE_EVALUATION_DETAILS_ID_=#{detailsId} AND rt.EVALUATION_ID_=#{evaluationId} SELECT *, CASE WHEN TOTAL_NUM = FINISH_NUM THEN 2 WHEN FINISH_NUM > 0 THEN 1 WHEN FINISH_NUM = 0 THEN 0 END AS isOpt FROM ( SELECT er.PERFORMANCE_EVALUATION_RESULT_ID_, ur.RATING_ACCOUNT_, ur.RATING_NAME_, COUNT( ur.ID_ ) AS TOTAL_NUM, COUNT( CASE WHEN ur.STATUS_ = 1 THEN 1 END ) AS FINISH_NUM FROM biz_supplier_performance_evaluation_rating_user ur INNER JOIN biz_supplier_performance_evaluation_rating er ON ur.EVALUATION_RATING_ID_ = er.ID_ WHERE ur.IS_DELE_ = '0' AND er.IS_DELE_ = '0' GROUP BY er.PERFORMANCE_EVALUATION_RESULT_ID_, ur.RATING_ACCOUNT_, ur.RATING_NAME_ ) AS temp WHERE PERFORMANCE_EVALUATION_RESULT_ID_=#{id} SELECT e.COMPANY_NAME_ AS enterpriseName, temp.ENTERPRISE_ID_ AS enterpriseId, temp.assessType, temp.assessYear, temp.assessQuarter, temp.assessMonth, temp.reviewedNum, temp.notRatedNum, temp.excellentNum, temp.fineNum, temp.qualifiedNum, temp.improveNum, temp.disqualifiedNum FROM biz_enterprise e INNER JOIN ( SELECT eva.ENTERPRISE_ID_, eva.ASSESSMENT_TYPE_ AS assessType, eva.ASSESSMENT_YEAR_ AS assessYear, eva.ASSESSMENT_QUATER_ AS assessQuarter, eva.ASSESSMENT_MONTH_ AS assessMonth, COUNT(CASE WHEN result.STATUS_ IN ('1', '4') THEN 1 END) AS reviewedNum, COUNT(CASE WHEN result.STATUS_ IN ('2', '3') THEN 1 END) AS notRatedNum, COUNT(CASE WHEN result.STATUS_ IN ('1', '4') AND result.LEVEL_ = '1' THEN 1 END) AS excellentNum, COUNT(CASE WHEN result.STATUS_ IN ('1', '4') AND result.LEVEL_ = '2' THEN 1 END) AS fineNum, COUNT(CASE WHEN result.STATUS_ IN ('1', '4') AND result.LEVEL_ = '3' THEN 1 END) AS qualifiedNum, COUNT(CASE WHEN result.STATUS_ IN ('1', '4') AND result.LEVEL_ = '4' THEN 1 END) AS improveNum, COUNT(CASE WHEN result.STATUS_ IN ('1', '4') AND result.LEVEL_ = '5' THEN 1 END) AS disqualifiedNum FROM biz_supplier_performance_evaluation eva INNER JOIN biz_supplier_performance_evaluation_result result ON eva.ID_ = result.EVALUATION_ID_ WHERE eva.IS_DELE_ = '0' AND result.IS_DELE_ = '0' GROUP BY eva.ENTERPRISE_ID_, eva.ASSESSMENT_TYPE_, eva.ASSESSMENT_YEAR_, eva.ASSESSMENT_QUATER_, eva.ASSESSMENT_MONTH_ ) temp ON e.ORG_ID_ = temp.ENTERPRISE_ID_ ${ew.customSqlSegment}