queryByCondition
===


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

batchDelXzxUserShareInfoByIds
===
* 批量逻辑删除
    update xzx_user_share_info set del_flag = 1 where id  in( #join(ids)#)

queryShareInfoList
===
      select a.id,
          a.register_time,
          b.nick_name as name,
          a.mobile_phone, 
          c.nick_name as registerName,
          a.register_mobile_phone,
          IFNULL(a.reward_money,0) as rewardMoney,
          IFNULL((select sum(d.order_money) from xzx_platform_capital_info d where d.share_id=a.id),0) as orderMoney,
          b.user_id,
          x.invited_user_id as invitedUserId
      from xzx_user_share_info a
      left join xzx_user_info b on b.mobile_phone=a.mobile_phone and b.del_flag=0 and b.user_type=1
      left join xzx_user_info c on c.mobile_phone=a.register_mobile_phone and c.del_flag=0 and c.user_type=1
      left join (
         select d.invited_user_id,d.share_id,n.partner_id from  xzx_platform_capital_info d
         left join xzx_order_info m on d.order_id=m.order_id
         left join xzx_user_other_info n on m.receiver=n.user_id
      ) x on x.share_id=a.id 
      where  1=1
       @if(!isEmpty(mobilePhone)){
               AND  a.mobile_phone like #"%"+mobilePhone+"%"#
       @}     
       @if(!isEmpty(registerMobilePhone)){
               AND  a.register_mobile_phone like #"%"+registerMobilePhone+"%"# 
       @}
       @if(!isEmpty(registerName)){
               AND  c.nick_name like #"%"+registerName+"%"#
       @}
       @if(!isEmpty(name)){
               AND  b.nick_name like #"%"+name+"%"#
       @} 
       @if(!isEmpty(startTime)){
                      AND  a.register_time>=#startTime#
              @} 
        @if(!isEmpty(endTime)){
                       AND  a.register_time<=#endTime#
               @}
       @if(!isEmpty(partnerIds)){
                              AND  x.partner_id in ( #join(partnerIds)# )
                      @}                 
       LIMIT #page#, #limit#

queryShareInfoCount
===
           select count(k.id) from (
             select a.id as id
                   from xzx_user_share_info a
                   left join xzx_user_info b on b.mobile_phone=a.mobile_phone and b.del_flag=0 and b.user_type=1
                   left join xzx_user_info c on c.mobile_phone=a.register_mobile_phone and c.del_flag=0 and c.user_type=1
                   left join (
                            select d.invited_user_id,d.share_id,n.partner_id from  xzx_platform_capital_info d
                            left join xzx_order_info m on d.order_id=m.order_id
                            left join xzx_user_other_info n on m.receiver=n.user_id
                         ) x on x.share_id=a.id 
                   where  1=1
                    @if(!isEmpty(mobilePhone)){
                            AND  a.mobile_phone like #"%"+mobilePhone+"%"#
                    @}     
                    @if(!isEmpty(registerMobilePhone)){
                            AND  a.register_mobile_phone like #"%"+registerMobilePhone+"%"# 
                    @}
                    @if(!isEmpty(registerName)){
                            AND  c.nick_name like #"%"+registerName+"%"#
                    @}
                    @if(!isEmpty(name)){
                            AND  b.nick_name like #"%"+name+"%"#
                    @} 
                    @if(!isEmpty(startTime)){
                                          AND  a.register_time>=#startTime#
                                  @} 
                            @if(!isEmpty(endTime)){
                                           AND  a.register_time<=#endTime#
                                   @}  
                     @if(!isEmpty(partnerIds)){
                                                  AND  x.partner_id in ( #join(partnerIds)# )
                                          @}                 
           )k
           
totalAmount
===

                              select IFNULL(sum(a.reward_money),0) as rewardMoney
                               from xzx_user_share_info a
                               left join xzx_user_info b on b.mobile_phone=a.mobile_phone and b.del_flag=0 and b.user_type=1
                               left join xzx_user_info c on c.mobile_phone=a.register_mobile_phone and c.del_flag=0 and c.user_type=1
                               where  1=1
                                @if(!isEmpty(mobilePhone)){
                                        AND  a.mobile_phone like #"%"+mobilePhone+"%"#
                                @}     
                                @if(!isEmpty(registerMobilePhone)){
                                        AND  a.register_mobile_phone like #"%"+registerMobilePhone+"%"# 
                                @}
                                @if(!isEmpty(registerName)){
                                        AND  c.name like #"%"+registerName+"%"#
                                @}
                                @if(!isEmpty(name)){
                                        AND  b.name like #"%"+name+"%"#
                                @}    

queryShareOrderList
===
    select t.* from xzx_platform_capital_info t where t.share_id=#shareId# LIMIT #page#, #limit#  

queryShareOrderCount
===
    select count(k.id) from (select t.id as id from xzx_platform_capital_info t where t.share_id=#shareId#)k  
queryRuleOpen
===
    select rule_name from xzx_user_redpaper_rule where del_flag=0 and rule_type=7 and status=1
queryWeightOrderList
===
     select a.create_time,a.order_id,IFNULL(b.nick_name,j.name) as nickName,b.mobile_phone,
            a.money as royaltyMoney,k.orderMoney,k.orderWeight as designatedWeight,k.hhrMoney as partnerMoney 
     from xzx_pay_info a
     left join xzx_order_info n on a.order_id=n.order_id
     left join xzx_user_info b on a.create_user_id = b.user_id
     left join xzx_user_other_info j on a.create_user_id = j.user_id
     left join (
        select sum(d.money) as orderMoney,sum(d.weight) as orderWeight,c.create_user_id as user_id,c.order_id,e.money as hhrMoney
         from xzx_order_info c 
        left join xzx_order_item_info d on c.order_id=d.order_id
        left join xzx_partner_account_log e on c.order_id=e.flow_no
        where e.type=3 group by c.order_id
     )k on k.order_id = a.order_id
     where a.pay_type=13 
     @if(!isEmpty(fenceIds)){
          AND  n.town_id  in ( #join(fenceIds)# )
     @}
     @if(!isEmpty(startTime)){
               AND  a.create_time>=#startTime#
     @}
     @if(!isEmpty(endTime)){
               AND  a.create_time<=#endTime#
     @}
     @if(!isEmpty(mobilePhone)){
         AND  (b.mobile_phone like #"%"+mobilePhone+"%"# or 
               b.nick_name =#nickName#) 
     @}         
     group by a.order_id order by create_time desc
     limit #page#, #limit#
queryTotalRoyaltyMoney
===
    select sum(a.money) from   xzx_pay_info a 
    left join xzx_order_info n on a.order_id=n.order_id
    left join xzx_user_info b on a.create_user_id= b.user_id
    where a.pay_type=13  and b.user_type=1
     @if(!isEmpty(fenceIds)){
        AND  n.town_id  in ( #join(fenceIds)# )
     @}
queryWeightOrderCount
===
     select count(x.order_id) from (
             select a.order_id
             from xzx_pay_info a
             left join xzx_user_info b on a.create_user_id = b.user_id
             left join xzx_order_info n on a.order_id=n.order_id
             left join xzx_user_other_info j on a.create_user_id = j.user_id
             left join (
                select sum(d.money) as orderMoney,sum(d.weight) as orderWeight,c.create_user_id as user_id,c.order_id,e.money as hhrMoney
                 from xzx_order_info c 
                left join xzx_order_item_info d on c.order_id=d.order_id
                left join xzx_partner_account_log e on c.order_id=e.flow_no
                where e.type=3 group by c.order_id
             )k on k.order_id = a.order_id
             where a.pay_type=13  
             @if(!isEmpty(fenceIds)){
                       AND  n.town_id  in ( #join(fenceIds)# )
             @} 
             @if(!isEmpty(startTime)){
                       AND  a.create_time>=#startTime#
             @}
             @if(!isEmpty(endTime)){
                       AND  a.create_time<=#endTime#
             @} 
             @if(!isEmpty(mobilePhone)){
                       AND  (b.mobile_phone like #"%"+mobilePhone+"%"# or 
                             b.nick_name =#nickName#) 
             @}              
             group by a.order_id order by a.create_time desc
     )x   
     
queryFenceByPartnerIds
===     
     select fence_id from xzx_partner_fence where  1=1 and del_flag=0
      @if(!isEmpty(partnerIds)){
               AND partner_id in ( #join(partnerIds)# )
       @} 

addRoyaltyRule
===
    INSERT INTO `xzx_rebate_weight_price` (`product_type`, `money`, `weight`, `rule_id`, `package_id`, `create_time`, `start_time`, `end_time`) 
    VALUES (#productType#, #money#, #weight#, #ruleId#, #packageId#, #createTime#, #startTime#, #endTime#)    

insertPriceHistory
===
    INSERT INTO `xzx_rebate_weight_price` (`product_type`, `money`, `weight`, `rule_id`, `package_id`, `create_time`, `start_time`, `end_time`) 
    VALUES 
    @for(info in list){
             (#info.productType#,#info.money#,#info.weight#,#info.ruleId#,#info.packageId#,#info.createTime#,#info.startTime#,#info.endTime#)
              @if(!isEmpty(info.productType)){
                 #text(infoLP.last?"":"," )#
              @} 
           @}

deleteByRuleId
===
    update xzx_rebate_weight_price  set del_flag=1 where rule_id=#ruleId#

queryOldItemList
===
    select * from xzx_rebate_weight_price where rule_id=#ruleId#       
queryRoyaltyManage
===
     select a.`name` as name,
     a.mobile_phone as mobilePhone,
     '回收员' as roleName,
     sum(b.settlement) as settlementMoney,
     sum(unSettlement) as royaltyMoney,
     a.user_id as receiver 
     from xzx_user_other_info a 
     left join xzx_weight_item_price_log b on a.user_id=b.receiver
     left join xzx_weight_item_price c on a.user_id=c.receiver
     where a.del_flag=0 and a.user_type=2
     @if(!isEmpty(name)){
          AND (a.name like #"%"+name+"%"#  or a.mobile_phone like #"%"+name+"%"#)  
     @}
     @if(!isEmpty(partnerIds)){
          AND a.partner_id in ( #join(partnerIds)# )
     @} 
     group by a.user_id    
     limit #page#, #limit#   
     
queryRoyaltyManageCount 
===
     select count(k.num) from (
     select IFNULL(count(a.user_id),0) as num
     from xzx_user_other_info a 
     left join xzx_weight_item_price_log b on a.user_id=b.receiver
     left join xzx_weight_item_price c on a.user_id=c.receiver
     where  a.del_flag=0 and a.user_type=2
     @if(!isEmpty(name)){
        AND (a.name like #"%"+name+"%"#  or a.mobile_phone like #"%"+name+"%"#)  
     @}
     @if(!isEmpty(partnerIds)){
          AND a.partner_id in ( #join(partnerIds)# )
     @}  
     group by a.user_id  
     )k  

queryWeightItemList
===
    select * from xzx_weight_item_price where status in (1,3) and receiver=#receiver#

queryGoodsById
===
    select title from xzx_package_goods_info where item_type=#itemType#
    
        
queryRoyalty
===
    select * from xzx_user_redpaper_rule where rule_type=7 
    @if(!isEmpty(partnerIds)){
              AND partner_id in ( #join(partnerIds)# )
    @}
     
queryRoyaltyByTimming
===
    select * from xzx_user_redpaper_rule where rule_type=7 
              AND timing=#timing# and start_time<=#time1# and end_time>=#time1#

        
queryRulePriceList
===
    select * from xzx_rebate_weight_price where rule_id=#ruleId#
   

queryRoyaltyHistory
===
    select * from xzx_rebate_weight_price_log where rule_id=#ruleId#
    group by product_type order by create_time desc   
        
updateRoyaltyRule
===
    update xzx_weight_item_price set status= #status# where id= #id#

deleteBylogId
===
    update xzx_weight_item_price_log   set del_flag=1 where item_id=#itemId#  
insertRoyaltyLog
===
     INSERT INTO `xzx_weight_item_price_log` (`item_id`, `settlement`, `unSettlement`, `total_settlement`, `create_time`,  `receiver`) 
     VALUES (#itemId#, #settlement#, #unSettlement#, #totalSettlement#, #createTime#, #receiver#) 
updateUserAccount
===   
     update xzx_account_info set  
       money=#money#
       @if(!isEmpty(overdraftLimit)){
           ,  overdraft_limit=#overdraftLimit#
       @}
      where account_id=#accountId# 
queryOtherByPartnerId
===
    select user_id from xzx_user_other_info 
    where user_type=2 and del_flag=0
    @if(!isEmpty(partnerId)){
                And   partner_id=#partnerId#
        @}
queryWeightItemByHsyList1
===
     select * from xzx_weight_item_price where status=1
     and receiver=#receiver#      
queryWeightItemByHsyList
===
     select * from xzx_weight_item_price where status in (1,3) and receiver in ( #join(receiverList)#)   
     
queryPackageType
===
    select * from xzx_sys_config_info where config_group='PACKAGE_TYPE' 

queryPackageGoods
===
    select title,item_type  from xzx_package_goods_info  
    where del_flag=0 and price is not null     
    @if(!isEmpty(packageId)){
                  AND package_id in ( #join(packageId)# )
        @}