id_, code_, apply_title_, application_dept_, application_dept_name_, application_date_, applicant_, application_case_, approver_, approved_date_, status_, confirm_date_, sn_, memo_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_, last_time_, version_ update CMGT_MATERIAL_PURCHASING set IS_DELE_ = '1' where ID_ = #{id} and IS_DELE_ = '0' SELECT d.quantity_, m.*, d.material_info_id_ FROM cmgt_material_info m LEFT JOIN ( SELECT material_info_id_, SUM(quantity_) AS quantity_ FROM cmgt_material_purchasing_detail purchasing_id_ in #{id} GROUP BY material_info_id_ ) d ON d.material_info_id_ = m.ID_ WHERE d.material_info_id_ IS NOT NULL SELECT d.quantity_, m.*, d.material_info_id_,q.quantity_ as remainingQuantity FROM cmgt_material_info m LEFT JOIN ( SELECT material_info_id_, SUM(quantity_) AS quantity_ FROM cmgt_material_purchasing_detail purchasing_id_ in #{id} GROUP BY material_info_id_ ) d ON d.material_info_id_ = m.ID_ LEFT JOIN cmgt_material_quantity q on q.material_id_ = d.material_info_id_ WHERE d.material_info_id_ IS NOT NULL