INSERT INTO eb_js_pay_trade create_time, amount, business_partner_seq, old_business_partner_seq, business_code, income_account_no, outcome_account_no, in_uni_id, req_seq_id, hf_seq_id, trans_finish_time, trade_type, trade_status, good_desc, remark, uni_id, error_msg, wx_data, alipay_data, pay_info = #{payInfo}, qr_code = #{qrCode}, #{createTime}, #{amount}, #{businessPartnerSeq}, #{oldBusinessPartnerSeq}, #{businessCode}, #{incomeAccountNo}, #{outcomeAccountNo}, #{inUniId}, #{reqSeqId}, #{hfSeqId}, #{transFinishTime}, #{tradeType}, #{tradeStatus}, #{goodDesc}, #{remark}, #{uniId}, #{errorMsg}, #{wxData}, #{alipayData}, pay_info = #{payInfo}, qr_code = #{qrCode}, UPDATE eb_js_pay_trade SET update_time=#{updateTime}, trans_finish_time=#{transFinishTime}, trade_status = #{tradeStatus}, error_msg = #{errorMsg}, WHERE id = #{id} SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, old_business_partner_seq oldBusinessPartnerSeq, business_code businessCode, trade_type tradeType, trade_status tradeStatus, commission_amount commissionAmount, error_msg errorMsg, wx_data wxData, alipay_data alipayData, pay_info payInfo, qr_code qrCode, uni_id uniId FROM eb_js_pay_trade WHERE id = #{id} SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, old_business_partner_seq oldBusinessPartnerSeq, business_code businessCode, req_seq_id reqSeqId, hf_seq_id hfSeqId, income_account_no incomeAccountNo, outcome_account_no outcomeAccountNo, in_uni_id inUniId, good_desc goodDesc, remark, trans_finish_time transFinishTime, trade_type tradeType, trade_status tradeStatus, commission_amount commissionAmount, error_msg errorMsg, wx_data wxData, alipay_data alipayData, pay_info payInfo, qr_code qrCode, uni_id uniId FROM eb_js_pay_trade WHERE hf_seq_id = #{hfSeqId} SELECT count(1) FROM eb_js_pay_trade WHERE business_partner_seq = #{businessPartnerSeq} AND trade_type = #{tradeType} AND trade_status='成功' SELECT count(1) FROM eb_js_pay_trade WHERE (business_partner_seq in (SELECT order_no FROM eb_order WHERE plat_order_no=#{businessPartnerSeq}) OR business_partner_seq = (SELECT plat_order_no FROM eb_order WHERE order_no=#{businessPartnerSeq})) AND trade_type = #{tradeType} AND trade_status='1' SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, old_business_partner_seq oldBusinessPartnerSeq, business_code businessCode, req_seq_id reqSeqId, hf_seq_id hfSeqId, income_account_no incomeAccountNo, outcome_account_no outcomeAccountNo, in_uni_id inUniId, good_desc goodDesc, commission_amount commissionAmount, remark, trans_finish_time transFinishTime, trade_type tradeType, trade_status tradeStatus, error_msg errorMsg, wx_data wxData, alipay_data alipayData, pay_info payInfo, qr_code qrCode, uni_id uniId FROM eb_js_pay_trade WHERE business_partner_seq = #{businessPartnerSeq} AND trade_status='1' SELECT id, create_time createTime, amount, req_seq_id reqSeqId, hf_seq_id hfSeqId, business_partner_seq businessPartnerSeq, old_business_partner_seq oldBusinessPartnerSeq, business_code businessCode, trade_type tradeType, trade_status tradeStatus, commission_amount commissionAmount, error_msg errorMsg, wx_data wxData, alipay_data alipayData, pay_info payInfo, qr_code qrCode, uni_id uniId FROM eb_js_pay_trade WHERE 1=1 AND business_partner_seq = #{businessPartnerSeq} AND business_code = #{businessCode} SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, old_business_partner_seq oldBusinessPartnerSeq, business_code businessCode, req_seq_id reqSeqId, hf_seq_id hfSeqId, income_account_no incomeAccountNo, outcome_account_no outcomeAccountNo, in_uni_id inUniId, good_desc goodDesc, remark, trans_finish_time transFinishTime, trade_type tradeType, trade_status tradeStatus, error_msg errorMsg, wx_data wxData, alipay_data alipayData, pay_info payInfo, qr_code qrCode, uni_id uniId FROM eb_js_pay_trade WHERE uni_id = #{uniId} AND id = #{id} AND INSTR(comment,#{comment}) AND trade_status = #{tradeStatus}