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'