queryByCondition

select 
@pageTag(){
t.*
@}
from xzx_city_partner t
where 1=1  
@//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
and #function("xzxCityPartner.query")#

batchDelXzxCityPartnerByIds

• 批量逻辑删除

  update xzx_city_partner set del_flag = 1 where id in( #join(ids)#)

insertGaodeInfo

 insert  xzx_partner_gaode (partner_id,partner_key,
       town_id,create_time,del_flag,city_id,address_area)  values
        @for(info in gaodeModels){
          (#info.partnerId#,#info.partnerKey#,#info.townId#,#info.createTime#,#info.delFlag#,#info.cityId#,#info.addressArea#)
           @if(!isEmpty(info.townId)){
              #text(infoLP.last?"":"," )#
           @} 
        @}

deletePartnerTownCode

 update xzx_partner_gaode set del_flag=1 where  partner_id=#partnerId#          

queryPartnerById

select * from xzx_city_partner where id=#id#   and del_flag=0

queryPartnerKeyByOrder

 select a.* from xzx_city_partner a 
 left join (select c.partner_id,b.order_id from xzx_order_info b
            left join xzx_user_other_info c on b.receiver=c.user_id  ) m
      on a.id=m.partner_id      
 where  a.del_flag=0 and m.order_id=#orderId#

queryEntityByUserIds

 select * from   xzx_city_partner where user_id like   #"%"+userId+"%"#  and del_flag=0

queryGaodeAreaByPackageId

 select * from xzx_partner_gaode where partner_id=#partnerId#  and del_flag=0   

queryGaodeByParentner

select city_id from xzx_partner_gaode where del_flag=0 and partner_id=#partnerId# and partner_id<>partner_key group by city_id

queryAreaByParentner

select b.level_1_name as provinceName,b.level_2_name as cityName,b.level_3_name as townName 
from xzx_partner_gaode a
LEFT JOIN xzx_sys_address_level_info b on a.town_id = b.level_3_id
    where 1=1 and partner_id<>partner_key and del_flag=0
     @if(!isEmpty(partnerId)){
         and  a.partner_id= #partnerId#
     @}

queryCityPartner

select a.id,a.partner_name,a.mobile_phone,a.account_no,IFNULL(sum(b.money),0) as czMoney,
       IFNULL(sum(c.money),0) as txMoney,a.effective_statr_time,a.effective_end_time,a.create_time,a.prohibit ,a.packing_station,
       a.partner_type,a.password,a.id_card as idCard,a.attachment_id,a.attachment_id1,a.email,a.user_id,a.partner_key as partnerKeys
from xzx_city_partner a
LEFT JOIN xzx_pay_info b ON a.user_id = b.create_user_id
LEFT JOIN xzx_pay_request_info c ON a.user_id=c.create_user_id
LEFT JOIN xzx_account_info d ON a.user_id = d.user_id
WHERE a.del_flag=0 
@if(!isEmpty(prohibit)){
            and  a.prohibit = #prohibit#
    @}
@if(!isEmpty(startTime)){
        and  a.create_time >= #startTime#
@}
@if(!isEmpty(endTime)){
        and  a.create_time <= #endTime#
@}
@if(!isEmpty(name)){
        and  (a.partner_name like #"%"+name+"%"# or a.mobile_phone like #"%"+name+"%"# or a.packing_station like #"%"+name+"%"# )
@}
@if(!isEmpty(partnerType)){
            and  a.partner_type = #partnerType#
@}
@if(!isEmpty(partnerIdList)){
        and  (a.id in ( #join(partnerIdList)# ) or  a.packing_station =#packingStation#)
@}
GROUP BY a.id  order by a.create_time desc
limit #page#, #limit#  

queryCityPartnerCount
===
select count(k.id) from (
select a.id as id
from xzx_city_partner a
WHERE a.del_flag=0
@if(!isEmpty(prohibit)){
and a.prohibit = #prohibit#
@}
@if(!isEmpty(startTime)){
and a.create_time >= #startTime#
@}
@if(!isEmpty(endTime)){
and a.create_time <= #endTime#
@}
@if(!isEmpty(name)){
and (a.partner_name like #"%"+name+"%"# or a.mobile_phone like #"%"+name+"%"# or a.packing_station like #"%"+name+"%"# )
@}
@if(!isEmpty(partnerType)){
and a.partner_type = #partnerType#
@}
@if(!isEmpty(partnerIdList)){
and (a.id in ( #join(partnerIdList)# ) or a.packing_station =#packingStation#)
@}
GROUP BY a.id
)k

queryFenceNameList

select b.fence_name,b.id from xzx_partner_fence a 
left join xzx_electronic_fence b on a.fence_id = b.id
where a.partner_id=#id# and b.del_flag=0 and a.del_flag=0 

queryAccountByPartnerId

select IFNULL(hbb,0) from xzx_partner_account where user_id=#userId#  limit 1      

queryPartnerByOther

select a.* from xzx_city_partner a
left join xzx_user_other_info b on a.id=b.partner_id
where b.user_id=#receiver# 
group by a.id

queryDetailsPresentation

 select x.flowNo,x.payName,x.payTime,x.money,x.partnerName,x.payStatus,x.mobilePhone,x.partnerType from (
 select a.pay_order_id as flowNo,'充值' as payName,a.create_time as payTime,a.money as money,b.partner_name as partnerName,
 a.status as payStatus,b.mobile_phone as mobilePhone,b.partner_type as partnerType
 from xzx_pay_info a  
 LEFT JOIN xzx_city_partner b ON a.create_user_id = b.user_id
 where 1=1 and b.user_id is not null
       @if(!isEmpty(userId)){
               and a.create_user_id =#userId#
       @}
       @if(!isEmpty(payType)){
            and  a.pay_type = #payType#
       @}
       @if(!isEmpty(payStatus)){
            and  a.status = #payStatus#
       @}
       @if(!isEmpty(startTime)){
            and  a.create_time >= #startTime#
       @}
       @if(!isEmpty(endTime)){
            and  a.create_time <= #endTime#
       @}
       @if(!isEmpty(name)){
             and  (b.mobile_phone like #"%"+name+"%"#  or b.partner_name like #"%"+name+"%"#)
       @}
       @if(!isEmpty(partnerIds)){
             and b.id in ( #join(partnerIds)#)
       @}
 UNION ALL
 select c.pay_order_id as flowNo,'提现' as payName,c.create_time as payTime,c.money as money,d.partner_name as partnerName,
 c.status as payStatus,d.mobile_phone as mobilePhone,d.partner_type as partnerType
  from xzx_pay_request_info c
 LEFT JOIN xzx_city_partner d ON c.create_user_id=d.user_id
 where 1=1 and d.user_id is not null
            @if(!isEmpty(userId)){
                              and c.create_user_id =#userId#
            @}
            @if(!isEmpty(payType)){
                 and  c.pay_type = #payType#
            @}
            @if(!isEmpty(payStatus)){
                 and  c.status = #payStatus#
            @}
            @if(!isEmpty(startTime)){
                 and  c.create_time >= #startTime#
            @}
            @if(!isEmpty(endTime)){
                 and  c.create_time <= #endTime#
            @}
            @if(!isEmpty(name)){
                  and  (d.mobile_phone like #"%"+name+"%"#  or d.partner_name like #"%"+name+"%"#)
            @}
            @if(!isEmpty(partnerIds)){
                  and d.id in ( #join(partnerIds)#)
            @}                  
 ) x order by x.payTime desc
 LIMIT #page#, #limit#

queryDetailsPresentationCount
===
select count(k.flowNo) from (
select a.pay_order_id as flowNo
from xzx_pay_info a
LEFT JOIN xzx_city_partner b ON a.create_user_id = b.user_id
where 1=1
@if(!isEmpty(userId)){
and a.create_user_id =#userId#
@}
@if(!isEmpty(payType)){
and a.pay_type = #payType#
@}
@if(!isEmpty(payStatus)){
and a.status = #payStatus#
@}
@if(!isEmpty(startTime)){
and a.create_time >= #startTime#
@}
@if(!isEmpty(endTime)){
and a.create_time <= #endTime#
@}
@if(!isEmpty(name)){
and (b.mobile_phone like #"%"+name+"%"# or b.partner_name like #"%"+name+"%"#)
@}
@if(!isEmpty(partnerIds)){
and b.id in ( #join(partnerIds)#)
@}
UNION ALL
select c.pay_order_id as flowNo
from xzx_pay_request_info c
LEFT JOIN xzx_city_partner d ON c.create_user_id=d.user_id
where 1=1
@if(!isEmpty(userId)){
and c.create_user_id =#userId#
@}
@if(!isEmpty(payType)){
and c.pay_type = #payType#
@}
@if(!isEmpty(payStatus)){
and c.status = #payStatus#
@}
@if(!isEmpty(startTime)){
and c.create_time >= #startTime#
@}
@if(!isEmpty(endTime)){
and c.create_time <= #endTime#
@}
@if(!isEmpty(name)){
and (d.mobile_phone like #"%"+name+"%"# or d.partner_name like #"%"+name+"%"#)
@}
@if(!isEmpty(partnerIds)){
and d.id in ( #join(partnerIds)#)
@}
)k

queryAreaLongiLati

select * from xzx_longi_lati where 1=1 and name=#name# limit 1

queryAreaLongiLatiList

select level_3_id from xzx_sys_address_level_info where 1=1 and level_2_name=#city#

queryAreaCityList

select  level_2_id from xzx_sys_address_level_info where 1=1 and level_2_name=#city# limit 1

queryAreaProvinceList

select  level_1_id from xzx_sys_address_level_info where 1=1 and level_1_name=#city# limit 1

queryAreaTownList

select  level_3_id from xzx_sys_address_level_info where 1=1 and level_3_name=#city# limit 1

queryGaodeByTownId

select partner_id from xzx_partner_gaode where town_id = #townId# and del_flag=0 and partner_id<>partner_key limit 1

queryPartnerByCity

select  partner_id from xzx_partner_gaode where del_flag=0 and partner_id<>partner_key and city_id=#city# limit 1

addPayInfo1

INSERT INTO `xzx_pay_info` (`pay_order_id`, `order_id`, `create_user_id`, `money`, 
`account_id`, `pay_type`, `open_id`, `status`, `create_time`, `check_num`, `pay_img`, `pay_time`)
 VALUES (#payOrderId#, NULL, #createUserId#, #money#, #accountId#, 
#payType#, NULL, #status#, SYSDATE(), NULL, #payImg#, #payTime#) 

updateAccountPartner

 update xzx_account_info set money=#money# where user_id=#userId#    

updatePartnerAccount

 update xzx_partner_account set 
 hbb=#hbb# 
 @if(!isEmpty(overdraftLimit)){
    ,  overdraft_limit=#overdraftLimit#
  @} 
 where user_id=#userId# 

updatePackageAccount

 update xzx_partner_account set overdraft_limit=#overdraftLimit#,fixed_limit=#fixedLimit# where user_id=#userId#                         

addPayInfo

INSERT INTO `xzx_pay_info` (`pay_order_id`, `order_id`, `create_user_id`, `money`, 
`account_id`, `pay_type`, `open_id`, `status`, `create_time`, `check_num`, `pay_img`, `pay_time`)
 VALUES (#payOrderId#, NULL, #createUserId#, #money#, #accountId#, 
'1', NULL, #status#, SYSDATE(), NULL, #payImg#, #payTime#) 

addPartnerAccountLog

INSERT INTO `xzx_partner_account_log` (`account_id`, `flow_no`, `type`, `create_time`, 
`money`,  `account_money`, `hbb`, `user_name`, `user_phone`, `role_name`, `approver_status`, `del_flag`)
 VALUES (#accountId#, #flowNo#, #type#, #createTime#, #money#, 
#accountMoney#, #hbb#, #userName#, #userPhone#, #roleName#, #approverStatus#, #delFlag#) 

insertRemittance

    INSERT INTO `xzx_remittance_user`
     (`recharge_name`, `recharge_phone`, `company`, `company_account`, `bank_name`, `create_time`, `update_time`,`create_user_id`,`pay_order_id`)
     VALUES (#rechargeName#, #rechargePhone#, #company#, 
      #companyAccount#, #bankName#, #createTime#, NULL,#createUserId#,#payOrderId#)

queryPayInfoById

select * from xzx_pay_info where pay_order_id=#payOrderId#

updatePayInfoPass

 update  xzx_pay_info set 
 status=#status# 
 @if(!isEmpty(unpassReason)){
     ,  unpass_reason=#unpassReason#
 @}                              
 where pay_order_id=#payOrderId#  

queryPartnerFenceList

select a.* from  xzx_electronic_fence a
where a.del_flag=0 and 
a.id not in (select b.fence_id from xzx_partner_fence b 
             where b.fence_id=a.id and b.del_flag=0
             @if(!isEmpty(id)){
                   and  b.partner_id<>#id#
             @}
)
group by a.id order by a.create_time desc

queryPartnerFenceListByUser

    select a.* from  xzx_electronic_fence a
    left join xzx_partner_fence b on a.id=b.fence_id 
    where a.del_flag=0 and b.del_flag=0
    @if(!isEmpty(partnerIds)){
         and  b.partner_id=#partnerIds#
    @}
    group by a.id order by a.create_time desc

queryPartnerFenceAllList

select a.* from  xzx_electronic_fence a
where a.del_flag=0
group by a.id order by a.create_time desc

queryPartnerByMobile

select * from xzx_city_partner where del_flag=0 
@if(!isEmpty(mobilePhone)){
      and mobile_phone=#mobilePhone# 
@}
@if(!isEmpty(partnerType)){
      and partner_type=#partnerType# 
@}
@if(!isEmpty(partnerName)){
      and partner_name=#partnerName# 
@}
@if(!isEmpty(partnerIdList)){
      and id in ( #join(partnerIdList)# )
@}

queryCitysByPartnerId

select city_id from xzx_partner_gaode where del_flag=0 and partner_id=#pid# group by city_id

queryCityNameById

select level_2_name from xzx_sys_address_level_info where level_2_id=#cityId# group by level_2_name             

queryElectronicFenceByPartner

select count(id) from xzx_partner_fence where 
partner_id=#partnerId# 
and del_flag=0 

queryPartnerAdmin

select * from core_user where id=#id#  

queryAllCityPartnerList

select * from xzx_city_partner 
where del_flag=0
@if(!isEmpty(partnerId)){
    and (id=#partnerId# or packing_station=#partnerId#)
@}

insertGaodeSid

insert into xzx_partner_trace (partner_id, partner_key, partner_service_id, partner_service_type, create_time, del_flag)
     values (
        #partnerId#, #partnerKey#, #partnerServiceId#, #partnerServiceType#, #createTime#, #delFlag#
     )   

querySidListByPartnerId

 select partner_service_id from xzx_partner_trace where   partner_id=#partnerId# and del_flag=0 

deleteGaodeService

update xzx_partner_trace set del_flag=1 where  partner_id=#partnerId# and del_flag=0

querySidByPid

select partner_service_id from xzx_partner_trace where del_flag=0 and partner_service_type=#serviceType# and partner_id=#partnerId#  limit 1          

queryTownIdsByPartnerId

select town_id from xzx_partner_gaode where del_flag=0 and partner_id=#partnerId#   

queryTownIdsByPartnerIdList

select town_id from xzx_partner_gaode where del_flag=0 and partner_id in ( #join(partnerIdList)#)                       

queryUserModelbyPartnerId

select a.* from xzx_user_other_info a
left join xzx_order_info b on b.receiver=a.user_id
 where a.del_flag=0  
 @if(!isEmpty(partnerId)){
     and a.partner_id in ( #join(partnerId)#)
 @} 
  @if(!isEmpty(userType)){
        and  a.user_type=#userType#
  @}
  @if(!isEmpty(userId)){
        and  a.user_id=#userId#
  @}
  @if(!isEmpty(orderId)){
       and  b.order_id=#orderId#
  @}
  @if(!isEmpty(userName)){
              and  (a.name like #"%"+userId+"%"#  or a.mobile_phone like #"%"+userId+"%"#)
        @}

querySidByPartnerId

select partner_service_id from xzx_partner_trace where del_flag=0 and partner_id=#partnerId#
@if(!isEmpty(type)){
            and  partner_service_type=#type#
 @}    

queryOrderById

select trace_id from   xzx_order_info where order_id =#orderId# 
@if(!isEmpty(receiver)){
                    and  a.receiver=#userId#
         @}  
    @if(!isEmpty(startTime)){
                        and  b.receive_time>=#startTime#
             @} 
     @if(!isEmpty(endTime)){
                            and  b.receive_time<=#endTime#
                 @}

queryOrderByIds
===
select a.trace_id from xzx_order_info a
left join xzx_order_detail_info b on a.order_id=b.order_id
where a.del_flag=0
@if(!isEmpty(receiver)){
and a.receiver=#userId#
@}
@if(!isEmpty(startTime)){
and b.receive_time>=#startTime#
@}
@if(!isEmpty(endTime)){
and b.receive_time<=#endTime#
@}

deletePartnerAccount

update xzx_partner_account set del_flag= #delFlag# where user_id=#userId# and del_flag=0   

deleteAccountByUserId

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

queryPartnerAccountLog

select flow_no as flowNo,IFNULL(account_money,0) as account,
hbb as money,IFNULL(money,0) as hbb,
user_name as userName,user_phone as userPhone,
type,role_name as roleName ,approver,approver_time,create_time
from xzx_partner_account_log where account_id=#accountId#  
@if(!isEmpty(startTime)){
                        and  create_time>=#startTime#
             @} 
@if(!isEmpty(endTime)){
                            and  create_time<=#endTime#
                 @}    
@if(!isEmpty(type)){
                                and  type=#type#
                     @}     
@if(!isEmpty(userName)){
                                and  (user_name  like #"%"+userName+"%"# or user_phone  like #"%"+userName+"%"#)

                     @}    
 limit #page#,#limit#  

queryPartnerAccountLogCount

select count(id) from xzx_partner_account_log where account_id=#accountId#  
@if(!isEmpty(startTime)){
       and  create_time>=#startTime#
@} 
@if(!isEmpty(endTime)){
       and  create_time<=#endTime#
@}    
@if(!isEmpty(type)){
       and  type=#type#
@}     
@if(!isEmpty(userName)){
       and  (user_name  like #"%"+userName+"%"# or user_phone  like #"%"+userName+"%"#)                          
@}

queryAdminAccountLog

select create_time,flow_no as flowNo,IFNULL(new_money,0) as accountMoney,IFNULL(money,0) as money,IFNULL(new_hbb,0) as hbb,create_user_name as userName,create_user_mobile as userPhone,type,create_user_type as roleName from xzx_platform_account_log
 where 1=1  
@if(!isEmpty(startTime)){
     and  create_time>=#startTime#
@} 
@if(!isEmpty(endTime)){
     and  create_time<=#endTime#
@}    
@if(!isEmpty(type)){
     and  type=#type#
@}
@if(!isEmpty(userName)){
           and  (create_user_name  like #"%"+userName+"%"# or create_user_mobile  like #"%"+userName+"%"#)                          
    @}         
 limit #page#,#limit#  

queryAdminAccountLogCount

select count(id) from xzx_platform_account_log where 1=1  
@if(!isEmpty(startTime)){
       and  create_time>=#startTime#
@} 
@if(!isEmpty(endTime)){
       and  create_time<=#endTime#
@}    
@if(!isEmpty(type)){
       and  type=#type#
@}     
@if(!isEmpty(userName)){
               and  (create_user_name  like #"%"+userName+"%"# or create_user_mobile  like #"%"+userName+"%"#)                          
        @} 

queryAccountByAdminId

select group_concat(field_value) as account from xzx_platform_account_info;

queryAccountIdByUserId

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

queryAccountLogByAccount

 select IFNULL(c.name,n.nick_name) as userName,a.*,
    IFNULL(c.mobile_phone,n.mobile_phone) as mobilePhone,
    IFNULL(c.user_type,'1') as userType from xzx_account_log a 
    left join xzx_account_info d on a.account_id=d.account_id
    left join ( select k.name,k.mobile_phone,k.user_type,k.user_id,k.partner_id from xzx_user_other_info k where k.del_flag=0) c on a.create_user_id = c.user_id
    left join ( select m.mobile_phone,m.nick_name,m.user_id from xzx_user_info m where m.del_flag=0)n on a.create_user_id=n.user_id 
     where  d.del_flag=0  
 @if(!isEmpty(userName)){
     and  (c.name  like #"%"+userName+"%"# or c.mobile_phone  like #"%"+userName+"%"# or n.mobile_phone like #"%"+userName+"%"#)                                
 @} 
 @if(!isEmpty(startTime)){
       and  a.create_time>=#startTime#                             
  @}
 @if(!isEmpty(endTime)){
      and  a.create_time<=#endTime#                                 
 @}
  @if(!isEmpty(typeList)){
     and  a.channel_type in ( #join(typeList)#)                          
  @}
 @if(!isEmpty(channelType)){
           and  a.channel_type=#channelType#                                 
 @}
 @if(!isEmpty(accountId)){
                and  a.account_id=#accountId#                                 
      @}
 @if(!isEmpty(partnerIds)){
           and  c.partner_id in ( #join(partnerIds)# )                                
 @} 
 order by  a.create_time desc        
limit #page#,#limit#    

queryAccountLogByAccountCount

select count(k.id) from (
select a.id from xzx_account_log a
left join xzx_account_info d on a.account_id=d.account_id
        left join ( select k.name,k.mobile_phone,k.user_type,k.user_id,k.partner_id from xzx_user_other_info k where k.del_flag=0) c on a.create_user_id = c.user_id
        left join ( select m.mobile_phone,m.nick_name,m.user_id from xzx_user_info m where m.del_flag=0)n on a.create_user_id=n.user_id 
         where  d.del_flag=0  
 @if(!isEmpty(userName)){
          and  (c.name  like #"%"+userName+"%"# or c.mobile_phone  like #"%"+userName+"%"# or n.mobile_phone like #"%"+userName+"%"#)                                
      @} 
      @if(!isEmpty(startTime)){
            and  a.create_time>=#startTime#                             
       @}
      @if(!isEmpty(endTime)){
           and  a.create_time<=#endTime#                                 
      @}
      @if(!isEmpty(typeList)){
                 and  a.channel_type in ( #join(typeList)#)                          
      @}
      @if(!isEmpty(channelType)){
                and  a.channel_type=#channelType#                                 
      @} 
      @if(!isEmpty(accountId)){
                          and  a.account_id=#accountId#                                 
                @}
      @if(!isEmpty(partnerIds)){
                     and  c.partner_id in ( #join(partnerIds)# )                                
           @}   
) k 

queryPartnerCityById

 select b.level_1_id as pId,b.level_1_name as pName,b.level_2_id as cId,b.level_2_name as cName,a.town_id as cityId,b.level_3_name as cityName from xzx_partner_gaode a
 left join xzx_sys_address_level_info b on a.town_id=b.level_3_id
  where a.del_flag=0 and partner_id<>partner_key and a.town_id is not null
  @if(!isEmpty(id)){
        and  a.partner_id=#id#                                 
  @} 

queryGaodeByCid

  select b.level_2_id as code,b.level_2_name as value from xzx_partner_gaode a
       left join xzx_sys_address_level_info b on a.town_id=b.level_3_id
        where a.del_flag=0  and partner_id<>partner_key and a.town_id is not null and b.level_1_id = #pid#
        @if(!isEmpty(id)){
              and  a.partner_id=#id#                                 
        @}
        group by b.level_2_id 

queryGaodeByTid

  select b.level_3_id as code,b.level_3_name as value from xzx_partner_gaode a
       left join xzx_sys_address_level_info b on a.town_id=b.level_3_id
        where a.del_flag=0 and partner_id<>partner_key and a.town_id is not null and b.level_2_id = #cid#
        @if(!isEmpty(id)){
              and  a.partner_id=#id#                                 
        @}

queryPidBypartnerId

 select b.level_1_id as code,b.level_1_name as value from xzx_partner_gaode a
 left join xzx_sys_address_level_info b on a.town_id=b.level_3_id
  where a.del_flag=0 and partner_id<>partner_key and a.town_id is not null
  @if(!isEmpty(id)){
        and  a.partner_id=#id#                                 
  @}  
  group by b.level_1_id    

queryCityPartnerByPhone

select id from xzx_city_partner where del_flag=0 and mobile_phone=#mobilePhone#

updateAccountType

update xzx_account_info set is_prohibit=#isProhibit# where account_id=#accountId#

deleteUserByPartnerId

update  xzx_user_other_info set del_flag=1  where partner_id=#id# and del_flag=0   

deleteAccount

update xzx_account_info set del_flag=1 where account_id=#accountId#    

queryPartnerGaode

 select count(a.id) from xzx_partner_gaode a
  left join xzx_sys_address_level_info b on a.town_id =b.level_3_id
  where level_3_name in  ( #join(areaList)#) and a.del_flag=0

queryCityPartnerForOtherUser

select * from xzx_user_other_info where del_flag=0 and user_type=#userType#
   @if(!isEmpty(partnerIds)){
             and  partner_id in ( #join(partnerIds)# )                           
   @}      

queryOrderByHsy

select a.order_id,c.complete_time,a.address from xzx_order_info a
left join xzx_user_other_info b on a.receiver= b.user_id
left join xzx_order_detail_info c on a.order_id=c.order_id
where a.del_flag<>1 and b.del_flag=0 and b.user_type=2
and order_status in (4,5,7) and a.create_type in (1,3)
@if(!isEmpty(startTime)){
    and  c.complete_time>=#startTime#                           
@} 
@if(!isEmpty(endTime)){
    and  c.complete_time<=#endTime#                           
@}
@if(!isEmpty(userId)){
    and  b.user_id=#userId#                           
@}  

queryPartnerName

select * from xzx_city_partner where del_flag=0 and partner_type=1
 @if(!isEmpty(partnerIds)){
     AND id in ( #join(partnerIds)# )                       
 @}   

queryPackageByPartner

select * from xzx_city_partner where del_flag=0 and partner_type=2 and prohibit=0

queryAllUserByPid

   select b.* from xzx_user_info b
   left join xzx_user_address_info c on b.user_id=c.user_id
   where  b.del_flag=0 and c.flag=1
   @if(!isEmpty(userName)){
        and (b.name like #"%"+userName+"%"# or b.mobile_phone like #"%"+userName+"%"#)                    
   @}
   @if(!isEmpty(roleType)){
        AND b.user_type =#roleType#                      
   @}
   @if(!isEmpty(townIds)){
        AND c.township_id in (#join(townIds)#)                 
   @}       

queryOtherUserByPid

select * from xzx_user_other_info 
where del_flag=0 
@if(!isEmpty(pid)){
         AND (partner_id =#pid# or   partner_id in (#join(packageStationList)#)  )                 
@} 
@if(!isEmpty(userName)){
              and (name like #"%"+userName+"%"# or mobile_phone like #"%"+userName+"%"#)                    
@}
@if(!isEmpty(roleType)){
      AND user_type =#roleType#                      
@}  

queryAccountByUserIds

select * from xzx_account_info where  del_flag=0 
@if(!isEmpty(userIds)){
     AND user_id in ( #join(userIds)# )                       
@}
@if(!isEmpty(isProhibit)){
     AND is_prohibit = #isProhibit#                 
@} 
order by CAST(money AS DECIMAL) desc 
limit #page#,#limit#     

queryAccountByUserIdsCount

 select count(account_id)   
 from xzx_account_info where  del_flag=0 
 @if(!isEmpty(userIds)){
        AND user_id in ( #join(userIds)# )                       
 @} 
 @if(!isEmpty(isProhibit)){
        AND is_prohibit =#isProhibit#                       
 @}
 order by  money desc

updateAccountLimit

 update  xzx_account_info set fixed_limit=#fixedLimit#,overdraft_limit=#overdraftLimit# where account_id=#accountId#

updateAccountLimitByPid

 update  xzx_account_info set fixed_limit=0,overdraft_limit=0 
 where user_id in ( #join(userIds)#)

queryUserIdsByPid

select user_id from xzx_user_other_info where partner_id=#partnerId#

queryAccountByAccountId

select * from  xzx_account_info where account_id=#accountId#    

queryAllUserIds

 select k.userId from (
             select a.user_id as userId,a.name as userName,a.mobile_phone as mobilePhone,a.regist_time as createTime from xzx_user_info a where a.del_flag=0
             union all
             select b.user_id as userId,b.name as userName,b.mobile_phone as mobilePhone,b.regist_time as createTime from xzx_user_other_info b where b.del_flag=0
             union all
             select c.user_id as userId,c.partner_name as userName,c.mobile_phone as mobilePhone,c.create_time as createTime from xzx_city_partner c where c.del_flag=0   
            ) k  
  where 1=1 
  @if(!isEmpty(userName)){
          and (k.userName like #"%"+userName+"%"# or k.mobilePhone like #"%"+userName+"%"#)
  @} 
  order by k.createTime desc    

queryPackageIdList

select id from xzx_city_partner where del_flag=0 and partner_type=2 and packing_station=#partnerId#