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,a.update_time,
a.update_user_id,(select k.name from core_user k where k.id=a.update_user_id) as updateUserName,
b.mobile_phone,IFNULL(b.nick_name,f.name) as nickName,b.user_type,c.order_status,c.order_id,a.examine_time,a.`status`,a.pay_type,a.create_user_id ,
IFNULL((select d.role_name from xzx_user_role_info d where d.role_code= f.user_type),'普通用户') as roleName,
IFNULL(f.user_type,b.user_type) as userType
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
LEFT JOIN xzx_user_other_info f ON a.create_user_id = f.user_id 
where 1=1 
@if(!isEmpty(status)){
     and a.status=#status#
@}
@if(!isEmpty(nickName)){
    and (b.nick_name=#nickName# or f.nick_name=#nickName#)
@}
@if(!isEmpty(mobilePhone)){
    and b.mobile_phone=#mobilePhone#
@}
@if(!isEmpty(payType)){
    and a.pay_type=#payType#
@}
@if(!isEmpty(startTime)){
        and a.create_time>=#startTime#
    @}
@if(!isEmpty(endTime)){
            and a.create_time<=#endTime#
        @} 
@if(!isEmpty(partnerIds)){
         and f.partner_id in ( #join(partnerIds)# ) 
    @}           
group by a.create_time desc
limit #page#,#limit#

queryMoneyListCount

select count(k.pId) from (
    SELECT a.pay_order_id as pId 
    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
    LEFT JOIN xzx_user_other_info f ON a.create_user_id = f.user_id 
    where 1=1 
                    @if(!isEmpty(status)){
                         and a.status=#status#
                    @}
                    @if(!isEmpty(nickName)){
                         and (b.nick_name=#nickName# or f.nick_name=#nickName#)
                    @}
                    @if(!isEmpty(mobilePhone)){
                        and b.mobile_phone=#mobilePhone#
                    @}
                    @if(!isEmpty(payType)){
                             and a.pay_type=#payType#
                    @}
                     @if(!isEmpty(startTime)){
                                and a.create_time>=#startTime#
                            @}
                    @if(!isEmpty(endTime)){
                                    and a.create_time<=#endTime#
                                @} 
                    @if(!isEmpty(partnerIds)){
                              and f.partner_id in ( #join(partnerIds)# ) 
                    @}        
                    group by a.create_time desc) k

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 
        @if(!isEmpty(status)){
             status=#status#
        @}
        @if(!isEmpty(payFlag)){
             ,pay_flag=#payFlag#
        @}
        @if(!isEmpty(unpassReason)){
             ,unpass_reason=#unpassReason#
        @}
    WHERE pay_order_id = #payOrderId#   

updateMoneyByAccountId

    UPDATE xzx_account_info SET 
        money=#money#
    WHERE account_id = #accountId#  

updateParterAccount

UPDATE xzx_partner_account SET 
     hbb=#money#
 WHERE account = #accountId#

updateParterAccount1

UPDATE xzx_account_info SET 
     money=#money#
 WHERE account_id = #accountId#     

updatePlatformMoney

UPDATE xzx_platform_account_info SET 
     field_value=#money#
 WHERE field_key = 'money'  

updatePlatformHbb

UPDATE xzx_platform_account_info SET 
         field_value=#hbb#
     WHERE field_key = 'hbb'      

insertPlatFormLog
===
INSERT INTO xzx_platform_account_log
(type, old_money, money, new_money,
old_hbb, hbb, new_hbb, create_user_id,
create_time, create_user_type, create_user_name,
create_user_mobile, flow_no)
VALUES ('1', #oldMoney#, #money#, #newMoney#,
#oldHbb#, #hbb#,#newHbb#, #createUserId#, #createTime#,#createUserType#,
#createUserName#, #createUserMobile#, #flowNo#)

updateMoneyApi

    UPDATE xzx_pay_request_info SET pay_flag=#payFlag#,unpass_reason=#unpassReason#
    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

queryPayInfoDetailHS

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_other_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#

queryRechangeApiDetail

 select a.*,
 b.nick_name as nickName,
 b.user_type as userType,
 b.mobile_phone as mobilePhone,
 IFNULL((select d.role_name from xzx_user_role_info d where d.role_code= f.user_type),'普通用户') as roleName,
 IFNULL(f.name,b.name) as name
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 f ON a.create_user_id = f.user_id  
where a.pay_order_id=#payOrderId# 
and a.create_user_id = b.user_id    

queryApprovalType

select config_value from xzx_sys_config_info where config_type_code='APPROVAL_TYPE'

queryStorageMoneyApi

    select a.storage_id,
    a.storage_user_id,
    a.storage_user_name,
    a.storage_user_phone,
    a.storage_time,
    a.storage_weight,
    a.storage_money 
    from xzx_order_storage_info a
    left join xzx_user_other_info b on a.storage_user_id=b.user_id
    where a.storage_status=0 
     @if(!isEmpty(startTime)){
             and a.storage_time>=#startTime#
     @}     
     @if(!isEmpty(endTime)){
             and a.storage_time<=#endTime#
     @} 
      @if(!isEmpty(storageUserName)){
             and (a.storage_user_name like #"%"+storageUserName+"%"# or a.storage_user_phone like #"%"+storageUserName+"%"#) 
      @}     
      @if(!isEmpty(storageUserPhone)){
             and a.storage_user_phone=#storageUserPhone#
      @}  
        @if(!isEmpty(partnerIds)){
                       and b.partner_id in ( #join(partnerIds)# )
                @} 
      limit #page#,#limit#  

queryStorageMoneyToday

    select 
    sum(a.storage_money) as money 
    from xzx_order_storage_info a
     left join xzx_user_other_info b on a.storage_user_id=b.user_id
    where storage_status=0 
     @if(!isEmpty(startTime)){
             and a.storage_time>=#startTime#
     @}     
     @if(!isEmpty(endTime)){
             and a.storage_time<=#endTime#
     @} 
       @if(!isEmpty(partnerIds)){
                                          and b.partner_id in ( #join(partnerIds)# )
                                   @}  

queryStorageMoneyApiCount

 select count(k.sId) from (
    select a.storage_id as sId
    from xzx_order_storage_info a 
    left join xzx_user_other_info b on a.storage_user_id=b.user_id
    where a.storage_status=0 
     @if(!isEmpty(startTime)){
             and a.storage_time>=#startTime#
     @}     
     @if(!isEmpty(endTime)){
             and a.storage_time<=#endTime#
     @} 
      @if(!isEmpty(storageUserName)){
             and (a.storage_user_name like #"%"+storageUserName+"%"# or a.storage_user_phone like #"%"+storageUserName+"%"#) 
      @}     
      @if(!isEmpty(storageUserPhone)){
             and a.storage_user_phone=#storageUserPhone#
      @}  
      @if(!isEmpty(partnerIds)){
                                 and b.partner_id in ( #join(partnerIds)# )
                          @} 
     ) k 

queryMoneyTodayList

select IFNULL(sum(money),0) from xzx_pay_request_info where pay_type=4
@if(!isEmpty(startTime)){
                 and create_time>=#startTime#
 @} 
@if(!isEmpty(endTime)){
                  and create_time<=#endTime#
@}
@if(!isEmpty(status)){
                 and status=#status#
@}  
@if(!isEmpty(payOrderIds)){
                     and pay_order_id in ( #join(payOrderIds)#)
    @}  

queryUserOrderList

        select a.order_id as orderId,c.complete_time as completeTime,
        sum(b.money) as money,sum(b.weight) as weight,
        a.create_time as createTime,a.rela_phone as phone from xzx_order_info a
        left join xzx_order_detail_info c on a.order_id=c.order_id
        left join xzx_order_item_info b on a.order_id=b.order_id 
        where a.del_flag=0 
        and a.order_status in (4,5) 
        and a.order_id=c.order_id
        @if(!isEmpty(phone)){
                 and a.rela_phone=#phone#
        @}
        @if(!isEmpty(receiverPhone)){
                 and c.receiver_phone=#receiverPhone#
        @}
        group by a.order_id  
        limit #page#,#limit# 

queryUserOrderCount
===
select count(k.orderId) from (
select a.order_id as orderId from xzx_order_info a
left join xzx_order_detail_info c on a.order_id=c.order_id
left join xzx_order_item_info b on a.order_id=b.order_id
where a.del_flag=0
and a.order_status in (4,5)
and a.order_id=c.order_id
@if(!isEmpty(phone)){
and a.rela_phone=#phone#
@}
@if(!isEmpty(receiverPhone)){
and c.receiver_phone=#receiverPhone#
@}
group by a.order_id )k

queryRechangeApiList

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,a.pay_time,
IFNULL((select d.role_name from xzx_user_role_info d where role_code= c.user_type limit 1),'普通用户') as roleName,
e.partner_name as partnerName,e.mobile_phone as partnerPhone,e.partner_type as partnerType,a.pay_img,a.unpass_reason,a.fee
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 
left join xzx_city_partner e on a.create_user_id=e.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# or b.mobile_phone like #"%"+mobilePhone+"%"# or c.mobile_phone like #"%"+mobilePhone+"%"# or e.mobile_phone like #"%"+mobilePhone+"%"# )
@}
@if(!isEmpty(name)){
     and b.name=#name#
@}
@if(!isEmpty(startTime)){
     and a.create_time>=#startTime#
@}
@if(!isEmpty(endTime)){
     and a.create_time<=#endTime#
@}
@if(!isEmpty(partnerIds)){
         and c.partner_id in ( #join(partnerIds)# )
    @} 

group by a.create_time desc
limit #page#,#limit#

queryRechangeListApiCount

select count(k.count) from (  select count(*) as count 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 
 left join xzx_city_partner e on a.create_user_id=e.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# or b.mobile_phone like #"%"+mobilePhone+"%"# or c.mobile_phone like #"%"+mobilePhone+"%"# or e.mobile_phone like #"%"+mobilePhone+"%"#)
@}
@if(!isEmpty(name)){
     and b.name=#name#
@}
  @if(!isEmpty(partnerIds)){
              and c.partner_id in ( #join(partnerIds)# )
@} 
 group by a.create_time desc) k

queryUserOrderMoneyAndWeight

        select 
        IFNULL(sum(b.money),0) as money,IFNULL(sum(b.weight),0) as weight
        from xzx_order_info a
        left join xzx_order_detail_info c on a.order_id=c.order_id
        left join xzx_order_item_info b on a.order_id=b.order_id 
        where a.del_flag=0 
        and a.order_status in (4,5) 
        and a.order_id=c.order_id
         @if(!isEmpty(phone)){
                and a.rela_phone=#phone#
         @}
         @if(!isEmpty(receiverPhone)){
                and c.receiver_phone=#receiverPhone#
         @}
        group by a.order_id  

queryUserOrderByStorageId

   select order_id from xzx_order_storage_info
    where storage_status=0 
   @if(!isEmpty(storageId)){
          AND storage_id=#storageId#
   @} 

queryStorageMoneyDetailApi

        select a.order_id as orderId,c.complete_time as completeTime,
        sum(b.money) as money,sum(b.weight) as weight,
        a.create_time as createTime,a.rela_phone as phone from xzx_order_info a
        left join xzx_order_detail_info c on a.order_id=c.order_id
        left join xzx_order_item_info b on a.order_id=b.order_id 
        where a.del_flag=0 
        and a.order_status in (4,5) 
        and a.order_id=c.order_id
        and a.order_id in (#join(orderIds)#)
        group by a.order_id  
        limit #page#,#limit# 

queryMoneyAndWeightByOrderIds

        select 
        IFNULL(sum(b.money),0) as money,IFNULL(sum(b.weight),0) as weight
        from xzx_order_info a
        left join xzx_order_detail_info c on a.order_id=c.order_id
        left join xzx_order_item_info b on a.order_id=b.order_id 
        where a.del_flag=0 
        and a.order_status in (4,5) 
        and a.order_id=c.order_id
        and a.order_id in (#join(orderIds)#)
        group by a.order_id  

queryRechangeMoney

 select sum(k.money) from ( select IFNULL(sum(a.money),0) as money
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 in ( #join(status)#)
@}
@if(!isEmpty(payType)){
     and a.pay_type=#payType#
@}
@if(!isEmpty(startTime)){
     and a.create_time>=#startTime#
@}
@if(!isEmpty(endTime)){
     and a.create_time<=#endTime#
@}
@if(!isEmpty(partnerIds)){
         and c.partner_id in ( #join(partnerIds)# )
    @}
group by a.create_time desc )k                        

quotaDetail

        select storage_time as storageTime,
         storage_weight as weight,storage_money as money
        from xzx_order_storage_info 
        where storage_status=0 
        and receiver=#userId#
        @if(!isEmpty(startTime)){
                 and storage_time>=#startTime#
            @}
            @if(!isEmpty(endTime)){
                 and storage_time<=#endTime#
            @}
        limit #page#,#limit# 

quotaDetailCount

   select count(k.storageId) from (
        select storage_id as storageId
        from xzx_order_storage_info 
        where storage_status=0 
        and receiver=#userId#
        @if(!isEmpty(startTime)){
                             and storage_time>=#startTime#
                        @}
                        @if(!isEmpty(endTime)){
                             and storage_time<=#endTime#
                        @}  
         )k                         

endStorageTime

 select  storage_time 
 from    xzx_order_storage_info 
 where   storage_status=0  
 order by storage_time asc limit 1   

getAccountByUserId

select * from xzx_account_info where user_id=#userId# and del_flag=0 

updatePackUserAccount

update xzx_account_info set money=#money# where user_id=#userId# and del_flag=0 

getPartnerAccountByUserId

select * from xzx_partner_account where user_id=#userId# and del_flag=0 

queryRemittanceInfo

select * from xzx_remittance_user where pay_order_id=#payOrderId# limit 1         

queryTypeDesc

select config_value_name from xzx_sys_config_info where config_type_code=#type#

updateParterAccountLog

update xzx_partner_account_log set money=#money# ,
hbb=#hbb#,approver=#approver# ,approver_time=#approverTime#,
approver_status=#approverStatus#, update_time=#updateTime#   
where flow_no=#flowNo#                    

getAccountLogByOrderId

select * from xzx_account_log where order_id=#orderId#                                              

queryWtList

select * from xzx_rebate_rule_price where rule_id=#ruleId#