a.id AS "id", a.member_code AS "memberCode", a.member_name AS "memberName", a.charging_item_id AS "chargingItemId", a.charging_item_name AS "chargingItemName", a.num AS "num", a.price AS "price", a.total_price AS "totalPrice", a.add_time AS "addTime", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.business_order_code AS "businessOrderCode", a.business_table AS "businessTable", a.business_ids AS "businessIds", a.coupon_num AS "couponNum", a.business_id as "businessId", a.business_name as "businessName", a.business_refund AS "businessRefund" SELECT FROM payment_cart a WHERE a.id = #{id} SELECT FROM payment_cart a a.del_flag = #{DEL_FLAG_NORMAL} AND a.id = #{id} AND a.member_code = #{memberCode} AND a.business_table = #{businessTable} AND a.business_ids = #{businessIds} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM payment_cart a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO payment_cart( id, member_code, member_name, charging_item_id, charging_item_name, num, price, total_price, add_time, create_by, create_date, update_by, update_date, remarks, del_flag, business_order_code, business_table, business_ids, coupon_num, business_id, business_name, business_refund ) VALUES ( #{id}, #{memberCode}, #{memberName}, #{chargingItemId}, #{chargingItemName}, #{num}, #{price}, #{totalPrice}, #{addTime}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{businessOrderCode}, #{businessTable}, #{businessIds}, #{couponNum}, #{businessId}, #{businessName}, #{businessRefund} ) UPDATE payment_cart SET member_code = #{memberCode}, member_name = #{memberName}, charging_item_id = #{chargingItemId}, charging_item_name = #{chargingItemName}, num = #{num}, price = #{price}, total_price = #{totalPrice}, add_time = #{addTime}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, business_table = #{businessTable}, business_ids = #{businessIds}, coupon_num = #{couponNum}, business_id=#{businessId}, business_name=#{businessName}, business_refund=#{businessRefund} WHERE id = #{id} UPDATE payment_cart SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} DELETE FROM payment_cart where business_ids = #{businessIds} DELETE FROM payment_cart where member_code = #{memberCode} AND business_order_code = #{businessOrderCode} DELETE from ${tableName} WHERE id = #{id} AND payment_state = '1' UPDATE dog_birth_certificate SET del_flag = '1' WHERE fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} AND payment_state = '1' SELECT FROM payment_cart a WHERE a.business_ids = #{businessIds} AND a.business_table = #{businessTable} AND a.del_flag = '0' LIMIT 1 SELECT FROM payment_cart a WHERE a.member_code = #{memberCode} AND a.business_order_code = #{businessOrderCode} AND a.del_flag = '0' UPDATE sys_coupon SET target_id = NULL, useState='0' WHERE target_id = #{businessIds} UPDATE sys_coupon SET useState='0', target_id=#{pedigreeCertified} WHERE target_id = #{businessIds} SELECT ,b.dept FROM payment_cart a left join payment_charging_item b on a.charging_item_id=b.id WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id in ( #{item} ) SELECT a.* FROM payment_cart a WHERE a.del_flag = '0' AND a.member_code = #{memberCode} AND a.business_id= #{businessId}