queryCuserMoneyLog

SELECT a.pay_order_id,b.money, b.create_time, b.status, c.withdraw_money FROM xzx_pay_info a 
LEFT JOIN xzx_pay_request_info b ON a.pay_order_id = b.pay_order_id
LEFT JOIN xzx_account_info c ON a.account_id=c.account_id
WHERE c.user_id=#userId#
@if(!isEmpty(payType)){
    AND a.pay_type=#payType#
@}
@if(!isEmpty(tStatus)){
    AND a.status=#tStatus#
@}
@if(!isEmpty(tStatus)){
    AND b.status=#tStatus#
@}
limit #page#,#limit#

queryCuserMoneyLogCount

SELECT count(*) FROM xzx_pay_info a 
LEFT JOIN xzx_pay_request_info b ON a.pay_order_id = b.pay_order_id
LEFT JOIN xzx_account_info c ON a.account_id=c.account_id
WHERE c.user_id=#userId#
@if(!isEmpty(payType)){
    AND a.pay_type=#payType#
@}
@if(!isEmpty(tStatus)){
    AND b.status=#tStatus#
@}
@if(!isEmpty(xStatus)){
    AND a.status=#xStatus#
@}

queryMoneyList

SELECT a.pay_order_id,a.create_time,a.money,a.unpass_reason,a.pay_flag, a.wxpay_flag,a.examine_time,
b.mobile_phone,b.nick_name,b.user_type,c.order_status,a.examine_time,a.`status`,a.pay_type 
FROM xzx_pay_request_info a
LEFT JOIN xzx_user_info b ON a.create_user_id = b.user_id
LEFT JOIN xzx_order_info c ON a.order_id = c.order_id
where 1=1
@if(!isEmpty(status)){
     and a.status=#status#
@}
@if(!isEmpty(nickName)){
    and b.nick_name=#nickName#
@}
@if(!isEmpty(mobilePhone)){
    and b.mobile_phone=#mobilePhone#
@}
@if(!isEmpty(payType)){
         and a.pay_type=#payType#
@}
group by a.create_time desc
limit #page#,#limit#

queryOtherMoneyList

SELECT a.pay_order_id,a.create_time,a.money,a.unpass_reason,a.pay_flag, a.wxpay_flag,a.examine_time,
b.mobile_phone,b.nick_name,b.user_type,c.order_status,a.examine_time,a.`status`,a.pay_type,a.create_user_id 
FROM xzx_pay_request_info a
LEFT JOIN xzx_user_other_info b ON a.create_user_id = b.user_id
LEFT JOIN xzx_order_info c ON a.order_id = c.order_id
where 1=1
@if(!isEmpty(status)){
     and a.status=#status#
@}
@if(!isEmpty(nickName)){
    and b.nick_name=#nickName#
@}
@if(!isEmpty(mobilePhone)){
    and b.mobile_phone=#mobilePhone#
@}
@if(!isEmpty(payType)){
         and a.pay_type=#payType#
@}
group by a.create_time desc
limit #page#,#limit#

queryMoneyListCount

SELECT count(*) 
FROM xzx_pay_request_info a
LEFT JOIN xzx_user_info b ON a.create_user_id = b.user_id
LEFT JOIN xzx_order_info c ON a.order_id = c.order_id

queryMoney

SELECT * FROM xzx_pay_request_info a where 1=1
@if(!isEmpty(payOrderId)){
     and a.pay_order_id=#payOrderId#
@}

updateMoney

UPDATE `xzx_pay_request_info` SET 
@trim(){
    @if(!isEmpty(status)){
         status=#status#,
    @}
    @if(!isEmpty(payFlag)){
         pay_flag=#payFlag#,
    @}
    @if(!isEmpty(unpassReason)){
         unpass_reason=#unpassReason#,
    @}
    @if(!isEmpty(updateTime)){
         update_time=#updateTime#,
    @}
    @if(!isEmpty(updateUserId)){
         update_user_id=#updateUserId#,
    @}
@}
WHERE `pay_order_id` = #payOrderId#

queryRechangeList

select a.pay_order_id, a.create_time, a.money, IFNULL(b.nick_name,c.nick_name) as nickName, 
b.user_type,IFNULL(b.mobile_phone,c.mobile_phone) as mobilePhone,a.status, b.name,
IFNULL((select d.role_name from xzx_user_role_info d where role_code= c.user_type limit 1),'普通用户') as roleName
from xzx_pay_info a 
left join xzx_user_info b on a.create_user_id=b.user_id 
left join xzx_user_other_info c on a.create_user_id=c.user_id 
where 1=1
@if(!isEmpty(status)){
     and a.status=#status#
@}
@if(!isEmpty(payType)){
     and a.pay_type=#payType#
@}
@if(!isEmpty(nickName)){
     and b.nick_name=#nickName#
@}
@if(!isEmpty(name)){
     and b.name=#name#
@}
@if(!isEmpty(mobilePhone)){
     and b.mobile_phone=#mobilePhone#
@} 
group by a.create_time desc
limit #page#,#limit#

queryRechangeListCount

select count(*) from xzx_pay_info a 
left join xzx_user_info b on a.create_user_id=b.user_id 
where 1=1
@if(!isEmpty(status)){
     and a.status=#status#
@}
@if(!isEmpty(payType)){
     and a.pay_type=#payType#
@}
@if(!isEmpty(nickName)){
     and b.nick_name=#nickName#
@}
@if(!isEmpty(name)){
     and b.name=#name#
@}
@if(!isEmpty(mobilePhone)){
     and b.mobile_phone=#mobilePhone#
@}

updateMoneyApi

    UPDATE xzx_pay_request_info SET pay_flag=#payFlag#,unpass_reason=#unpassReason#,update_time=SYSDATE()
    WHERE pay_order_id = #payOrderId#     

queryPayInfoDetail

select a.*,b.nick_name as nickName ,
 b.user_type as userType,
 b.avatar as avatar,
 b.mobile_phone as mobilePhone
from xzx_pay_request_info a,xzx_user_info b   where a.pay_order_id=#payOrderId# and a.create_user_id = b.user_id        

queryPayInfoUserRole

select role_name as roleName from xzx_user_role_info where role_code=#userType#

queryApprovalType

select config_value from xzx_sys_config_info where config_type_code='APPROVAL_TYPE'