queryByCondition
===
    select 
    @pageTag(){
    t.*
    @}
    from xzx_user_redpaper_rule t
    where 1=1  and t.del_flag=0 
    @if(!isEmpty(ruleName)){
        and  t.rule_name =#ruleName#
    @}
    @if(!isEmpty(ruleType)){
            and  t.rule_type =#ruleType#
    @}
    @if(!isEmpty(partnerId)){
            and  t.partner_id =#partnerId#
    @}

    

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


queryRebateList
===
    select a.create_time,a.order_id,b.nick_name,b.mobile_phone,
           IFNULL(sum(c.weight),0) as designatedWeight,a.order_money,
           a.royalty_money,a.user_id,a.invited_user_id,
           (select d.applicable_object from xzx_user_redpaper_rule d where a.rule_id=d.id) as applicableObject 
    from xzx_platform_capital_info a 
    left join xzx_user_info b on b.user_id=a.user_id
    left join xzx_order_item_info c on c.order_id=a.order_id
    left join(
           select m.partner_id,n.order_id from xzx_user_other_info m
           LEFT JOIN xzx_order_info n on n.receiver=m.user_id
        )j on a.order_id = j.order_id
    where a.rule_type=3 and a.royalty_money>0
     and b.del_flag=0 and b.user_type=1
        @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 like #"%"+mobilePhone+"%"#
        @}
        @if(!isEmpty(partnerIds)){
                                      AND  j.partner_id in ( #join(partnerIds)# )
                              @}    
        group by a.order_id order by a.create_time desc
         LIMIT #page#, #limit#
        
        
queryRebateCount
===
    select count(k.id) from (
                select a.id as id
                from xzx_platform_capital_info a 
                left join xzx_user_info b on b.user_id=a.user_id 
                left join xzx_order_item_info c on c.order_id=a.order_id
                left join(
                       select m.partner_id,n.order_id from xzx_user_other_info m
                       LEFT JOIN xzx_order_info n on n.receiver=m.user_id
                    )j on a.order_id = j.order_id
                where a.rule_type=3 and a.royalty_money>0
                    and b.del_flag=0 and b.user_type=1 
                    @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 like #"%"+mobilePhone+"%"#
                    @} 
                     @if(!isEmpty(partnerIds)){
                         AND  j.partner_id in ( #join(partnerIds)# )
                     @}    
                    group by a.order_id 
                )k 
                
queryUserOrderIds
===
    select a.order_id from xzx_order_info a
    left join xzx_order_detail_info b on b.order_id=a.order_id
    where a.order_status in (4,5,7)  
    @if(!isEmpty(completeTime)){
        and  b.complete_time <= #completeTime#
    @} 
    @if(!isEmpty(userId)){
        and  a.create_user_id = #userId#
    @} 

queryAfterWeightByOrderIds
===
    select sum(weight) from xzx_order_item_info where order_id in   (#join(orderIds)#)  

queryTotalAmountByParam
===
     select sum(a.royalty_money)
                     from xzx_platform_capital_info a 
                     left join xzx_user_info b on b.user_id=a.user_id and b.del_flag=0 and b.user_type=1 
                     left join(
                            select m.partner_id,n.order_id from xzx_user_other_info m
                            LEFT JOIN xzx_order_info n on n.receiver=m.user_id
                         )j on a.order_id = j.order_id
                     where a.rule_type=3
                         @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 like #"%"+mobilePhone+"%"#
                         @}   
                          @if(!isEmpty(partnerIds)){
                             AND  j.partner_id in ( #join(partnerIds)# )
                           @}  

queryTotalOrderMoney
===
         select sum(money) from xzx_order_item_info where order_id in   (#join(orderIds)#)  

queryRedpaperList
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =1 
      and del_flag=0      
      @if(!isEmpty(startTime)){
           and  end_time>=#startTime#
      @}                          

queryShareListByTime
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =2 
      and del_flag=0      
      @if(!isEmpty(startTime)){
           and  (end_time>=#startTime# or end_time>=#endTime#)
      @}
      @if(!isEmpty(partnerId)){
                 and  partner_id=#partnerId#
      @} else {
                and partner_id is null
            @}  
      
queryCommListByTime
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =8
      and del_flag=0      
      @if(!isEmpty(startTime)){
           and  (end_time>=#startTime# or end_time>=#endTime#)
      @} 
      @if(!isEmpty(id)){
                 and  id<>#id#
            @}           
queryRedpaperListStartAndEnd
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =1 
      and del_flag=0      
      @if(!isEmpty(startTime)){
           and  (end_time>=#startTime# or end_time>=#endTime#)
      @} 
      @if(!isEmpty(partnerId)){
                 and  partner_id=#partnerId#
      @} else {
          and partner_id is null
      @}  
queryRebateRuleList
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =3 
      and del_flag=0 
      @if(!isEmpty(partnerId)){
                       and  partner_id=#partnerId#
            @} else {
                and partner_id is null
            @}  
queryCommissioList
===
         select * from  xzx_user_redpaper_rule 
              where   rule_type =8
              and del_flag=0 
              
queryWeightRuleList
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =5 
      and del_flag=0
      @if(!isEmpty(partnerId)){
                             and  partner_id=#partnerId#
                  @} else {
                      and partner_id is null
                  @}    
queryAccountList
===
    select a.create_time as commissionTime,a.flow_no as orderNo,sum(b.money) as orderMoney,
    a.money as commissionEarn,a.create_user_name as partnerName,
    a.create_user_mobile as mobile from xzx_platform_account_log a
    left join xzx_order_item_info b on a.flow_no=b.order_id
    where type=4 
    @if(!isEmpty(partnerName)){
        and (a.create_user_name like #"%"+partnerName+"%"#  or mobile like #"%"+partnerName+"%"#)
    @} 
    @if(!isEmpty(startTime)){
        and a.create_time>=#startTime#
    @}
    @if(!isEmpty(endTime)){
        and a.create_time<=#endTime#
    @}  
    group by a.flow_no order by a.create_time desc
    LIMIT #page#, #limit#

queryTotalCommissionMoney
===
    select 
    IFNULL(sum(a.money),0) from xzx_platform_account_log a
    left join xzx_order_item_info b on a.flow_no=b.order_id
    where type=4 
    @if(!isEmpty(partnerName)){
        and (a.create_user_name like #"%"+partnerName+"%"#  or mobile like #"%"+partnerName+"%"#)
    @} 
    @if(!isEmpty(startTime)){
        and a.create_time>=#startTime#
    @}
    @if(!isEmpty(endTime)){
        and a.create_time<=#endTime#
    @}  
    group by a.flow_no order by a.create_time desc
    
queryAccountListCount
===
    select count(a.flow_no) from xzx_platform_account_log a
    left join xzx_order_item_info b on a.flow_no=b.order_id
    where type=4 
    @if(!isEmpty(partnerName)){
        and (a.create_user_name like #"%"+partnerName+"%"#  or mobile like #"%"+partnerName+"%"#)
    @} 
    @if(!isEmpty(startTime)){
        and a.create_time>=#startTime#
    @}
    @if(!isEmpty(endTime)){
        and a.create_time<=#endTime#
    @}  
    group by a.flow_no order by a.create_time desc
    LIMIT #page#, #limit#
        
queryRoyalRuleList
===
      select * from  xzx_user_redpaper_rule 
      where   rule_type =7
      @if(!isEmpty(packageId)){
                       and package_id=#packageId# 
                  @}  
      @if(!isEmpty(partnerId)){
                 and partner_id=#partnerId#
            @}  
      
      and del_flag=0  
                         
queryRebateRulePriceList
===
      select * from  xzx_rebate_rule_price 
        where   rule_id =#ruleId# order by sort asc
        

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