ID_, PROJECT_NUMBER_, NOTICE_TITLE_, ESTABLISHMENT_NAME_, MAT_IF_PLAT_, AFFILIATED_USER_ID_, AFFILIATED_USER_NAME_, CONTACTS_PHONE_, AFFILIATED_ORG_ID_, AFFILIATED_ORG_CODE_, AFFILIATED_ORG_NAME_, PROCURE_ORG_ID_, PROCURE_ORG_CODE_, PROCURE_ORG_NAME_, AFFILIATED_DATE_, IS_TAX_, RELEASE_METHOD_, PROCURE_TYPE_, HAS_QUALIFICATION_, HAS_SUBPACKAGE_, HAS_BOND_, BOND_, BOND_FILE_URL_, QUOTATION_METHOD_, ACCEPTANCE_TIME_, PENDING_TIME_, QUALIFICATIONS_COUTENT_, NOTICE_RELEASE_TIME_, RAISING_QUESTIONS_DEADLINE_TIME_, CLARIFICATION_SUPPLEMENT_DEADLINE_TIME_, RESPONSE_TIME_DEADLINE_, BIDDING_START_TIME_, BIDDING_END_TIME_, NOTICE_OFF_TIME_, EVALUATION_START_TIME_, EVALUATION_END_TIME_, APPLICATION_TYPE_, QUOTATION_TEMPLATE_, EVALUATION_METHOD_, EVALUATION_TEMPLATE_ID_, QUOTATION_ROUNDS_, BID_STATUS_, QUALIFICATION_METHOD_, GENERATE_DUPLICATE_CONTRACTS_, WIN_BID_VALIDITY, REMARKS_, 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_mat_approval WHERE IS_DELE_ = '0' AND ID_ = #{id} SELECT * FROM biz_mat_approval ${ew.customSqlSegment} SELECT a.* FROM (SELECT *,date_add(WIN_NOTICE_TIME_, interval WIN_BID_VALIDITY day) as validityDate FROM biz_mat_approval) a ${ew.customSqlSegment} SELECT ID_ FROM biz_mat_approval ${ew.customSqlSegment} SELECT notice.*,IFNULL(part.STATUS_,0) as 'joinStatus',part.id_ as partId FROM biz_mat_approval notice LEFT JOIN ( SELECT * FROM biz_user_participation WHERE NOTICE_TYPE_ = 1 AND IS_DELE_ = '0') part ON notice.ID_ = part.NOTICE_ID_ ${ew.customSqlSegment} SELECT notice.* FROM biz_mat_approval notice LEFT JOIN biz_user_participation part ON notice.ID_ = part.NOTICE_ID_ ${ew.customSqlSegment}