ID_, COMPANY_ID_, COMPANY_NAME_, WORK_ORDER_INFORMATION_ID_, CONTRACT_ITEM_ID_, SORT_, NUMBER_, SUBJECT_NAME_, FINE_SUBJECT_NAME_, SPEC_, PRICE_, AMOUNT_, MONEY_, RECEIVER_PRICE_, RECEIVER_AMOUNT_, RECEIVER_MONEY_, AUDIT_PRICE_, AUDIT_AMOUNT_, AUDIT_MONEY_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_ SELECT * FROM BIZ_BILL_OF_QUANTITIES ${ew.customSqlSegment} SELECT b.*,a.JOB_NUMBER_ as jobNumber FROM biz_work_order_information a INNER JOIN biz_bill_of_quantities b on a.ID_ = b.WORK_ORDER_INFORMATION_ID_ and WORK_ORDER_INFORMATION_ID_ in #{item} SELECT f.*, e.JOB_NUMBER_ AS jobNumber , e.create_time_ AS debitTime, e.POSITION_ AS position FROM ( SELECT c.ID_, c.JOB_NUMBER_, c.POSITION_, d.create_time_ FROM ( SELECT a.ID_, a.JOB_NUMBER_, a.POSITION_, b.id_ proId FROM biz_work_order_information a INNER JOIN bpm_pro_inst b ON a.ID_ = b.biz_key_ AND a.ID_ IN #{item} ) c LEFT JOIN bpm_check_opinion d ON c.proId = d.proc_inst_id_ AND d.task_key_ = "UserTask4" ) e INNER JOIN biz_bill_of_quantities f ON e.ID_ = f.WORK_ORDER_INFORMATION_ID_