insertPaylog

INSERT INTO `xzx_pay_request_log`
(`id`, `user_id`, `money`, `create_time`, `pay_status`, `wx_openid`, `account_before_money`, `account_id`, `request_params`) 
VALUES (#id#, #userId#, #money#, #createTime#, #payStatus#, #wxOpenid#, #accountBeforeMoney#, #accountId#, #requestParams#);

updatePaylogResponseData

update `xzx_pay_request_log` set response_data=#responseData#, pay_status=#payStatus# where id=#id#

updateAccountMoney

update `xzx_account_info` set money=money-#money#
 where account_id=#accountId# 

updateAccountMoneyDouble

update `xzx_account_info` set money=#money#
 where account_id=#accountId# 

updatePaylogMoney

update `xzx_pay_request_log` set account_after_money=#accountAfterMoney#
   , pay_status=#payStatus# where id=#id#

updatePaylogRemark

update `xzx_pay_request_log` set remark=#remark# where id=#id#

insertMessage

insert into xzx_sys_message (message, user_id, mobile_phone, create_time, create_user_id, message_type, message_sub_type_name,flag)
     values (
        #message#, #userId#, #mobilePhone#, #createTime#, #userId#, #messageType#, #messageSubTypeName#,2
     )

addReason

update `xzx_pay_request_info` set status=3,unpass_reason=#reason# where pay_order_id=#payOrderId#  

insertAccountLog

insert into xzx_account_log (account_id, old_money, new_money, old_limit, new_limit, old_fixed_limit, new_fixed_limit,create_user_id,create_time,channel_type,order_id)
     values (
        #accountId#, #oldMoney#, #newMoney#, #oldLimit#, #newLimit#, #oldFixedLimit#, #newFixedLimit#,#createUserId#,#createTime#,#channelType#,#orderId#
     )         

queryPAccountByAccountId

select * from xzx_partner_account where account=#accountId# and del_flag=0