queryByCondition
===


    select 
    @pageTag(){
    t.*
    @}
    from xzx_user_redpaper_info t
    where 1=1  
    @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
    @if(!isEmpty(id)){
        and  t.id =#id#
    @}
    @if(!isEmpty(createTime)){
        and  t.create_time =#createTime#
    @}
    @if(!isEmpty(receiveUserId)){
        and  t.receive_user_id =#receiveUserId#
    @}
    
    
    

batchDelXzxUserRedpaperInfoByIds
===

* 批量逻辑删除

    update xzx_user_redpaper_info set del_flag = 1 where id  in( #join(ids)#)
    
redPaperList
===
    select a.code ,a.receive_user_id ,a.rule_id,a.receive_time,
    (select nick_name from xzx_user_info where user_id =receive_user_id ) as name,
    (select mobile_phone from xzx_user_info where user_id =receive_user_id ) as mobilePhone,
    a.receive_time,a.money,a.receive_flag 
    from xzx_user_redpaper_info a
    where 1=1
    @if(!isEmpty(startTime)){
         AND  a.receive_time>= #startTime#
    @} 
    @if(!isEmpty(endTime)){
         AND  a.receive_time<= #endTime#
    @} 
    @if(!isEmpty(receiveFlag)){
         AND  a.receive_flag= #receiveFlag#
    @} 
     @if(!isEmpty(partnerIds)){
                     AND  a.create_user_id in ( #join(partnerIds)# )
            @}     
    LIMIT #page#, #limit#   

redPaperCount
=== 
    select count(k.code) from (
    select a.code
    from xzx_user_redpaper_info a
    where 1=1
    @if(!isEmpty(startTime)){
         AND  a.receive_time>= #startTime#
    @} 
    @if(!isEmpty(endTime)){
         AND  a.receive_time<= #endTime#
    @} 
    @if(!isEmpty(receiveFlag)){
         AND  a.receive_flag= #receiveFlag#
    @} 
      @if(!isEmpty(partnerIds)){
                          AND  a.create_user_id in ( #join(partnerIds)# )
                 @}   
    )k
    
redPaperTotal
=== 
        select IFNULL(sum(a.money),0) as money,IFNULL(count(a.id),0) as count
        from xzx_user_redpaper_info a
        where 1=1 and a.receive_flag is not null
            @if(!isEmpty(startTime)){
                 AND  a.receive_time>= #startTime#
            @} 
            @if(!isEmpty(endTime)){
                 AND  a.receive_time<= #endTime#
            @} 
            @if(!isEmpty(receiveFlag)){
                 AND  a.receive_flag= #receiveFlag#
            @} 
             @if(!isEmpty(partnerIds)){
                                     AND a.create_user_id in ( #join(partnerIds)# )
                            @} 

batchInsertPaperInfo
===
    insert  xzx_user_redpaper_info (code,create_time,
      money,rule_id,total_amount,create_user_id)  values
       @for(info in list){
         (#info.code#,#info.createTime#,#info.money#,#info.ruleId#,#info.totalAmount#,#info.createUserId#)
          @if(!isEmpty(info.code)){
             #text(infoLP.last?"":"," )#
          @} 
       @}

queryRuleByDay
===
    select * from xzx_user_redpaper_rule where del_flag=0 and rule_type=1
    @if(!isEmpty(partnerId)){
        AND  partner_id= #partnerId#
    @}        
    @if(!isEmpty(day)){
        AND  end_time<#day#
    @}

queryMoneyByRuleId
===
    select IFNULL(sum(money),0) from  xzx_user_redpaper_info 
    where rule_id=#ruleId#   and receive_user_id is null