id, cku_id, username, MailAddressID, OrderID, sp_integral, SP_prices, OrderUndo, OrderUndoTime, OrderUndoType, OrderConfirm, OrderConfirmTime, PayConfirm, PayConfirmTime, PayInfo, ExpressConfirm, ExpressConfirmTime, ExpressCompany, ExpressNumber, add_time, out_trade_no, locked OrderRemarks select , from SP_OrderInfo where id = #{id,jdbcType=VARCHAR} select total_price SP_prices,payment_state PayConfirm from payment_order where order_code = #{OrderID,jdbcType=VARCHAR} and member_code = #{ckuId,jdbcType=VARCHAR} and del_flag = '0' update payment_order set payment_state = '2',payment_time = SYSDATE(),payment_way='25' where order_code = #{orderID} delete from SP_OrderInfo where id = #{id,jdbcType=VARCHAR} insert into SP_OrderInfo (id, cku_id, username, MailAddressID, OrderID, sp_integral, SP_prices, OrderUndo, OrderUndoTime, OrderUndoType, OrderConfirm, OrderConfirmTime, PayConfirm, PayConfirmTime, PayInfo, ExpressConfirm, ExpressConfirmTime, ExpressCompany, ExpressNumber, add_time, out_trade_no, locked, OrderRemarks) values (#{id,jdbcType=VARCHAR}, #{ckuId,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{mailaddressid,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{spIntegral,jdbcType=INTEGER}, #{spPrices,jdbcType=DECIMAL}, #{orderundo,jdbcType=CHAR}, #{orderundotime,jdbcType=TIMESTAMP}, #{orderundotype,jdbcType=CHAR}, #{orderconfirm,jdbcType=CHAR}, #{orderconfirmtime,jdbcType=TIMESTAMP}, #{payconfirm,jdbcType=CHAR}, #{payconfirmtime,jdbcType=TIMESTAMP}, #{payinfo,jdbcType=VARCHAR}, #{expressconfirm,jdbcType=CHAR}, #{expressconfirmtime,jdbcType=TIMESTAMP}, #{expresscompany,jdbcType=VARCHAR}, #{expressnumber,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{outTradeNo,jdbcType=VARCHAR}, #{locked,jdbcType=CHAR}, #{orderremarks,jdbcType=LONGVARCHAR}) insert into payment_order id, member_code, member_name, MailAddressID, order_code, sp_integral, total_price, OrderUndo, OrderUndoTime, OrderUndoType, payment_state, payment_time, PayInfo, ExpressConfirm, ExpressConfirmTime, ExpressCompany, ExpressNumber, add_time, out_trade_no, locked, OrderRemarks, del_flag, create_date, create_by, source, #{id,jdbcType=VARCHAR}, #{ckuId,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{mailaddressid,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{spIntegral,jdbcType=INTEGER}, #{spPrices,jdbcType=DECIMAL}, #{orderundo,jdbcType=CHAR}, #{orderundotime,jdbcType=TIMESTAMP}, #{orderundotype,jdbcType=CHAR}, #{payconfirm,jdbcType=CHAR}, #{payconfirmtime,jdbcType=TIMESTAMP}, #{payinfo,jdbcType=VARCHAR}, #{expressconfirm,jdbcType=CHAR}, #{expressconfirmtime,jdbcType=TIMESTAMP}, #{expresscompany,jdbcType=VARCHAR}, #{expressnumber,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{outTradeNo,jdbcType=VARCHAR}, #{locked,jdbcType=CHAR}, #{orderremarks,jdbcType=LONGVARCHAR}, #{delFlag,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{ckuId,jdbcType=VARCHAR}, #{loginType,jdbcType=VARCHAR}, update SP_OrderInfo cku_id = #{ckuId,jdbcType=VARCHAR}, username = #{username,jdbcType=VARCHAR}, MailAddressID = #{mailaddressid,jdbcType=INTEGER}, OrderID = #{orderid,jdbcType=VARCHAR}, sp_integral = #{spIntegral,jdbcType=INTEGER}, SP_prices = #{spPrices,jdbcType=DECIMAL}, OrderUndo = #{orderundo,jdbcType=CHAR}, OrderUndoTime = #{orderundotime,jdbcType=TIMESTAMP}, OrderUndoType = #{orderundotype,jdbcType=CHAR}, OrderConfirm = #{orderconfirm,jdbcType=CHAR}, OrderConfirmTime = #{orderconfirmtime,jdbcType=TIMESTAMP}, PayConfirm = #{payconfirm,jdbcType=CHAR}, PayConfirmTime = #{payconfirmtime,jdbcType=TIMESTAMP}, PayInfo = #{payinfo,jdbcType=VARCHAR}, ExpressConfirm = #{expressconfirm,jdbcType=CHAR}, ExpressConfirmTime = #{expressconfirmtime,jdbcType=TIMESTAMP}, ExpressCompany = #{expresscompany,jdbcType=VARCHAR}, ExpressNumber = #{expressnumber,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, out_trade_no = #{outTradeNo,jdbcType=VARCHAR}, locked = #{locked,jdbcType=CHAR}, OrderRemarks = #{orderremarks,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=VARCHAR} update SP_OrderInfo set cku_id = #{ckuId,jdbcType=VARCHAR}, username = #{username,jdbcType=VARCHAR}, MailAddressID = #{mailaddressid,jdbcType=INTEGER}, OrderID = #{orderid,jdbcType=VARCHAR}, sp_integral = #{spIntegral,jdbcType=INTEGER}, SP_prices = #{spPrices,jdbcType=DECIMAL}, OrderUndo = #{orderundo,jdbcType=CHAR}, OrderUndoTime = #{orderundotime,jdbcType=TIMESTAMP}, OrderUndoType = #{orderundotype,jdbcType=CHAR}, OrderConfirm = #{orderconfirm,jdbcType=CHAR}, OrderConfirmTime = #{orderconfirmtime,jdbcType=TIMESTAMP}, PayConfirm = #{payconfirm,jdbcType=CHAR}, PayConfirmTime = #{payconfirmtime,jdbcType=TIMESTAMP}, PayInfo = #{payinfo,jdbcType=VARCHAR}, ExpressConfirm = #{expressconfirm,jdbcType=CHAR}, ExpressConfirmTime = #{expressconfirmtime,jdbcType=TIMESTAMP}, ExpressCompany = #{expresscompany,jdbcType=VARCHAR}, ExpressNumber = #{expressnumber,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, out_trade_no = #{outTradeNo,jdbcType=VARCHAR}, locked = #{locked,jdbcType=CHAR}, OrderRemarks = #{orderremarks,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=VARCHAR} update SP_OrderInfo set cku_id = #{ckuId,jdbcType=VARCHAR}, username = #{username,jdbcType=VARCHAR}, MailAddressID = #{mailaddressid,jdbcType=INTEGER}, OrderID = #{orderid,jdbcType=VARCHAR}, sp_integral = #{spIntegral,jdbcType=INTEGER}, SP_prices = #{spPrices,jdbcType=DECIMAL}, OrderUndo = #{orderundo,jdbcType=CHAR}, OrderUndoTime = #{orderundotime,jdbcType=TIMESTAMP}, OrderUndoType = #{orderundotype,jdbcType=CHAR}, OrderConfirm = #{orderconfirm,jdbcType=CHAR}, OrderConfirmTime = #{orderconfirmtime,jdbcType=TIMESTAMP}, PayConfirm = #{payconfirm,jdbcType=CHAR}, PayConfirmTime = #{payconfirmtime,jdbcType=TIMESTAMP}, PayInfo = #{payinfo,jdbcType=VARCHAR}, ExpressConfirm = #{expressconfirm,jdbcType=CHAR}, ExpressConfirmTime = #{expressconfirmtime,jdbcType=TIMESTAMP}, ExpressCompany = #{expresscompany,jdbcType=VARCHAR}, ExpressNumber = #{expressnumber,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, out_trade_no = #{outTradeNo,jdbcType=VARCHAR}, locked = #{locked,jdbcType=CHAR} where id = #{id,jdbcType=VARCHAR} SELECT TOP ${count} * FROM SP_OrderInfo WHERE id NOT IN ( SELECT TOP ${indexNum} id FROM SP_OrderInfo WHERE cku_id =#{ckuId} AND PayConfirm =${PayConfirm} ORDER BY PayConfirmTime DESC ) AND cku_id =#{ckuId} AND PayConfirm =${PayConfirm} ORDER BY PayConfirmTime DESC SELECT spa.charging_item_id pid, spa.num pcount, sp.order_code orderID, sp.add_time add_time, sp.total_price SP_prices, sp.payment_state PayConfirm, case when ckup.name like '%犬只参赛费%' then '犬只参赛费' else ckup.name end orderType, ( CASE paylist.payment_way WHEN '1' THEN '支付宝充值' WHEN '2' THEN '建行网银充值' WHEN '3' THEN '现金缴纳' WHEN '4' THEN '邮局汇款' WHEN '5' THEN '挂账转入' WHEN '6' THEN '兴业银行充值' WHEN '8' THEN '巡回收入' WHEN '9' THEN '系统导入' WHEN '10' THEN '其他会员转入' WHEN '20' THEN '财务往来' WHEN '21' THEN '比赛现场收入' WHEN '22' THEN '财务往来' WHEN '24' THEN '微信支付' WHEN 'cku.org' THEN '余额支付' END ) AS moneyWay FROM payment_order sp RIGHT JOIN payment_order_detail spa ON sp.order_code = spa.order_code LEFT JOIN payment_charging_item ckup ON spa.charging_item_id = ckup.id LEFT JOIN payment_record paylist on spa.order_code = paylist.running_number WHERE spa.member_code = #{ckuId} AND spa.charging_item_id IN ('45','140','141','142','219','220','221','222') AND sp.payment_state = #{PayConfirm} AND sp.del_flag = '0' and spa.del_flag = '0' ORDER BY sp.payment_time DESC limit ${indexNum},${count} SELECT COUNT(orders.id) FROM payment_order orders,payment_order_detail cart WHERE orders.order_code=cart.order_code AND orders.member_code=#{ckuId} AND orders.payment_state=#{PayConfirm} AND cart.charging_item_id IN('45','140','141','142','219','220','221','222') AND orders.del_flag = '0' AND cart.del_flag = '0' select count(*) from payment_order where member_code=#{ckuId} AND payment_state='1' and del_flag = '0' and is_recharge != '1' update payment_order set del_flag = '1' where order_code = #{orderId} SELECT count(*) FROM payment_cart a a.del_flag = '0' AND a.member_code = #{memberCode}