a.id AS "id", a.member_code AS "memberCode", a.member_name AS "memberName", a.order_code AS "orderCode", a.total_price AS "totalPrice", a.payment_way AS "paymentWay", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.add_time AS "addTime", a.receiver AS "receiver", a.receive_del AS "receiveDel", a.receive_province AS "receiveProvince", a.receive_city AS "receiveCity", a.receive_area AS "receiveArea", a.receive_address AS "receiveAddress", a.receive_post_code AS "receivePostCode", a.project_id AS "projectId", a.project_name AS "projectName", a.locked AS "locked", 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.is_recharge AS "isRecharge", a.is_buying AS "isBuying", a.source AS "source", a.transaction_id AS "transactionId", a.coupon_num AS "couponNum" id AS "id", member_code AS "memberCode", member_name AS "memberName", order_code AS "orderCode", total_price AS "totalPrice", payment_way AS "paymentWay", payment_state AS "paymentState", payment_time AS "paymentTime", add_time AS "addTime", receiver AS "receiver", receive_del AS "receiveDel", receive_province AS "receiveProvince", receive_city AS "receiveCity", receive_area AS "receiveArea", receive_address AS "receiveAddress", receive_post_code AS "receivePostCode", project_id AS "projectId", project_name AS "projectName", locked AS "locked", create_by AS "createBy.id", create_date AS "createDate", update_by AS "updateBy.id", update_date AS "updateDate", remarks AS "remarks", del_flag AS "delFlag", is_recharge AS "isRecharge", is_buying AS "isBuying", source AS "source", transaction_id AS "transactionId", coupon_num AS "couponNum" UPDATE ${tableName} SET running_number = #{runningNumber} WHERE id = #{id} UPDATE dog_birth_certificate SET running_number = #{runningNumber} WHERE fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} AND del_flag = '0' AND ifnull(review_state,'0') = '0' UPDATE ${tableName} SET remarks = concat(IFNULL(remarks,''),'[system]'), del_flag = "1" WHERE id = #{id} AND payment_state = '1' SELECT member_code AS memberCode, member_name AS memberName, create_date AS createDate, order_code AS orderCode, id AS id, substring(remarks, 7) AS remark FROM payment_order WHERE del_flag = '0' AND payment_state = '1' AND create_by = #{createBy.id} AND remarks LIKE CONCAT('%',#{remark},'%') AND date_format(create_date, '%Y-%m-%d') = ]]> date_format(#{beginCreateDate}, '%Y-%m-%d') AND date_format(create_date, '%Y-%m-%d') date_format(#{endCreateDate}, '%Y-%m-%d') ORDER BY create_date DESC UPDATE dog_birth_certificate SET remarks = concat(IFNULL(remarks,''),'[system]'), del_flag = "1" WHERE fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} AND payment_state = '1' SELECT FROM payment_order a WHERE a.id = #{id} SELECT FROM payment_order a WHERE a.order_code = #{orderCode} SELECT FROM payment_order a a.del_flag = #{DEL_FLAG_NORMAL} AND a.is_recharge != '1' AND a.is_recharge = #{isRecharge} AND a.member_code = #{memberCode} AND a.payment_state = #{paymentState} AND a.member_name = #{memberName} AND a.create_by = #{createBy.id} AND a.order_code = #{orderCode} AND a.total_price = #{totalPrice} AND a.project_name LIKE concat('%',#{projectName},'%') AND date_format(a.add_time, '%Y-%m-%d') = ]]> date_format(#{beginAddTime}, '%Y-%m-%d') AND date_format(a.add_time, '%Y-%m-%d') date_format(#{endAddTime}, '%Y-%m-%d') ORDER BY ${page.orderBy} ORDER BY a.create_date DESC SELECT count(1) FROM payment_order a a.del_flag = #{DEL_FLAG_NORMAL} AND a.is_recharge != '1' AND a.is_recharge = #{isRecharge} AND a.member_code = #{memberCode} AND a.payment_state = #{paymentState} AND a.member_name = #{memberName} AND a.create_by = #{createBy.id} AND a.order_code = #{orderCode} AND a.total_price = #{totalPrice} AND a.project_name LIKE concat('%',#{projectName},'%') AND date_format(a.add_time, '%Y-%m-%d') = ]]> date_format(#{beginAddTime}, '%Y-%m-%d') AND date_format(a.add_time, '%Y-%m-%d') date_format(#{endAddTime}, '%Y-%m-%d') SELECT FROM payment_order a 1=1 AND a.del_flag =#{delFlagsss} AND a.is_recharge != '1' AND a.is_recharge = #{isRecharge} AND a.member_code = #{memberCode} AND a.payment_state = #{paymentState} AND a.member_name = #{memberName} AND a.create_by = #{createBy.id} AND a.order_code = #{orderCode} AND a.total_price = #{totalPrice} AND a.project_name LIKE concat('%',#{projectName},'%') AND date_format(a.add_time, '%Y-%m-%d') = ]]> date_format(#{beginAddTime}, '%Y-%m-%d') AND date_format(a.add_time, '%Y-%m-%d') date_format(#{endAddTime}, '%Y-%m-%d') AND del_flag = '0' ORDER BY ${page.orderBy} ORDER BY a.create_date DESC SELECT count(1) FROM payment_order a 1=1 AND a.del_flag =#{delFlagsss} AND a.is_recharge != '1' AND a.is_recharge = #{isRecharge} AND a.member_code = #{memberCode} AND a.payment_state = #{paymentState} AND a.member_name = #{memberName} AND a.create_by = #{createBy.id} AND a.order_code = #{orderCode} AND a.total_price = #{totalPrice} AND a.project_name LIKE concat('%',#{projectName},'%') AND date_format(a.add_time, '%Y-%m-%d') = ]]> date_format(#{beginAddTime}, '%Y-%m-%d') AND date_format(a.add_time, '%Y-%m-%d') date_format(#{endAddTime}, '%Y-%m-%d') AND del_flag = '0' SELECT SUM( CASE WHEN a.del_flag = '0' AND a.is_recharge != '1' AND a.is_recharge = #{isRecharge} AND a.member_code = #{memberCode} AND a.payment_state = #{paymentState} AND a.member_name = #{memberName} AND a.order_code = #{orderCode} AND a.total_price = #{totalPrice} AND a.project_name LIKE concat('%',#{projectName},'%') AND date_format(a.add_time, '%Y-%m-%d') = ]]> date_format(#{beginAddTime}, '%Y-%m-%d') AND date_format(a.add_time, '%Y-%m-%d') date_format(#{endAddTime}, '%Y-%m-%d') THEN total_price ELSE 0 END) AS total_price FROM payment_order a SELECT FROM payment_order a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO payment_order( id, member_code, member_name, order_code, total_price, payment_way, payment_state, payment_time, add_time, receiver, receive_del, receive_province, receive_city, receive_area, receive_address, receive_post_code, project_id, project_name, locked, create_by, create_date, update_by, update_date, remarks, del_flag, is_recharge, is_buying, source, transaction_id, coupon_num ) VALUES ( #{id}, #{memberCode}, #{memberName}, #{orderCode}, #{totalPrice}, #{paymentWay}, #{paymentState}, #{paymentTime}, #{addTime}, #{receiver}, #{receiveDel}, #{receiveProvince}, #{receiveCity}, #{receiveArea}, #{receiveAddress}, #{receivePostCode}, #{projectId}, #{projectName}, #{locked}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{isRecharge}, #{isBuying}, #{source}, #{transactionId}, #{couponNum} ) UPDATE payment_order SET member_code = #{memberCode}, member_name = #{memberName}, order_code = #{orderCode}, total_price = #{totalPrice}, payment_way = #{paymentWay}, payment_state = #{paymentState}, payment_time = #{paymentTime}, add_time = #{addTime}, receiver = #{receiver}, receive_del = #{receiveDel}, receive_province = #{receiveProvince}, receive_city = #{receiveCity}, receive_area = #{receiveArea}, receive_address = #{receiveAddress}, receive_post_code = #{receivePostCode}, project_id = #{projectId}, project_name = #{projectName}, locked = #{locked}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, transaction_id = #{transactionId}, coupon_num = #{couponNum} WHERE id = #{id} UPDATE payment_order SET remarks = concat(IFNULL(remarks,''),'[sys-del-',CURRENT_DATE,' ',CURRENT_TIME,']',IFNULL(#{remarks},'')), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE payment_order SET locked = #{locked} WHERE id = #{id} SELECT from payment_order a where a.order_code = #{pedigreeNum} SELECT from payment_order a where a.order_code in #{item} SELECT from payment_order a where a.create_date <= #{date} and a.payment_state = '1' and a.del_flag = '0' SELECT COUNT(1) FROM payment_order a WHERE a.member_code = #{memberCode} AND a.payment_state = #{paymentState} AND del_flag= '0' AND is_recharge = '0' SELECT a.account_balance,IFNULL(b.in_price,0.00) as in_price,IFNULL(c.out_price,0.00) as out_price,IFNULL(d.three_price, 0.00) AS three_price FROM ( select account_balance from sys_member where member_code=#{memberCode} ) AS a, ( select sum(payment_amount) as in_price from payment_record where charging_item_id=0 and del_flag=0 and payment_state=2 and member_code=#{memberCode} ) AS b, ( select sum(payment_amount) as out_price from payment_record where charging_item_id!=0 and del_flag=0 and payment_state=2 and member_code=#{memberCode} ) AS c, ( select sum(payment_amount) as three_price from payment_record where payment_way!='cku.org' and payment_way!='25' and charging_item_id!=0 and del_flag=0 and payment_state=2 and member_code=#{memberCode} ) AS d 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 po.member_code, po.member_name, pod.business_id, pod.business_name, pod.business_table, pcig.department, po.order_code, po.payment_time, pod.total_price, pod.update_date, pod.business_refund_state, pod.business_refund_reason, pod.business_refund_time, pod.business_ids, pod.business_order_code, sad.cycle_sign AS "cycleSign", sad.show_main_id AS "showMainId", sad.discount_sign AS "discountSign" from payment_order po join ( SELECT sum( total_price ) AS total_price, max( business_refund_time ) AS business_refund_time, max( update_date ) AS update_date, max( business_refund ) AS business_refund, max( business_refund_state ) AS business_refund_state, max( business_refund_reason ) AS business_refund_reason, max( business_name ) AS business_name, max( business_ids ) AS business_ids, max( business_table ) AS business_table, order_code, business_id, business_order_code FROM payment_order_detail WHERE business_refund_state IS NOT NULL GROUP BY order_code, business_id, business_order_code ) pod on po.order_code = pod.order_code join payment_charging_item_group pcig on pod.business_id = pcig.id LEFT JOIN show_apply_discount sad on po.order_code = sad.running_number where pod.business_refund_state is not null AND (po.member_code like CONCAT('%', #{memberCode}, '%') or po.member_name like CONCAT('%', #{memberCode}, '%')) AND pcig.department = #{department} AND po.order_code like CONCAT('%', #{orderCode}, '%') AND pod.business_refund_state = #{businessRefundState} AND date_format(pod.business_refund_time, '%Y-%m-%d') = ]]> date_format(#{beginUpdateDate}, '%Y-%m-%d') AND date_format(pod.business_refund_time, '%Y-%m-%d') date_format(#{endUpdateDate}, '%Y-%m-%d') order by pod.business_refund_time desc,pod.update_date desc select review_state from ${table} where id in #{item} update ${table} set review_state ='3' , review_remarks=#{vo.reviewRemarks}, update_date=#{vo.updateDate}, update_by=#{vo.updateBy.id} where id in #{item} SELECT a.payment_way,a.payment_time,a.total_price FROM payment_order a left join payment_order_detail b on a.order_code=b.order_code a.del_flag = #{DEL_FLAG_NORMAL} AND a.payment_state = #{paymentState} AND a.member_code = #{memberCode} AND a.create_by = #{createBy.id} and b.charging_item_id in ('0','27') and b.charging_item_id not in ('0','27') AND date_format(a.payment_time, '%Y-%m-%d') = ]]> date_format(#{beginAddTime}, '%Y-%m-%d') AND date_format(a.payment_time, '%Y-%m-%d') date_format(#{endAddTime}, '%Y-%m-%d') ORDER BY ${page.orderBy} ORDER BY a.create_date DESC SELECT FROM payment_order a WHERE a.id = #{id} FOR UPDATE SELECT a.* FROM payment_order a LEFT JOIN payment_order_detail pod ON pod.order_code=a.order_code WHERE a.del_flag = '0' AND pod.del_flag = '0' AND pod.business_order_code = #{businessOrderCode} LIMIT 1 SELECT group_concat(a.id) FROM ${tableName} a WHERE a.del_flag = '0' AND a.running_number = #{orderCode} GROUP BY a.running_number SELECT FROM payment_order order_code in #{runningNumber} 1=2 UPDATE ckuoa.dog_birth_certificate SET temp_member_code=breeder_member_code, temp_user_name=breeder WHERE birth_cer_reg_code= ( SELECT birth_code FROM dog_chip WHERE id=#{dogChipId});