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