select
@pageTag(){
t.*
@}
from xzx_user_share_info t
where 1=1
@//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行
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#
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
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+"%"#
@}
select t.* from xzx_platform_capital_info t where t.share_id=#shareId# LIMIT #page#, #limit#
select count(k.id) from (select t.id as id from xzx_platform_capital_info t where t.share_id=#shareId#)k
select rule_name from xzx_user_redpaper_rule where del_flag=0 and rule_type=7 and status=1
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#
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)# )
@}
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)# )
@}
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#)
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?"":"," )#
@}
@}
update xzx_rebate_weight_price set del_flag=1 where rule_id=#ruleId#
select * from xzx_rebate_weight_price where rule_id=#ruleId#
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
select * from xzx_weight_item_price where status in (1,3) and receiver=#receiver#
select title from xzx_package_goods_info where item_type=#itemType#
select * from xzx_user_redpaper_rule where rule_type=7
@if(!isEmpty(partnerIds)){
AND partner_id in ( #join(partnerIds)# )
@}
select * from xzx_user_redpaper_rule where rule_type=7
AND timing=#timing# and start_time<=#time1# and end_time>=#time1#
select * from xzx_rebate_weight_price where rule_id=#ruleId#
select * from xzx_rebate_weight_price_log where rule_id=#ruleId#
group by product_type order by create_time desc
update xzx_weight_item_price set status= #status# where id= #id#
update xzx_weight_item_price_log set del_flag=1 where item_id=#itemId#
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#
select user_id from xzx_user_other_info
where user_type=2 and del_flag=0
@if(!isEmpty(partnerId)){
And partner_id=#partnerId#
@}
select * from xzx_weight_item_price where status=1
and receiver=#receiver#
select * from xzx_weight_item_price where status in (1,3) and receiver in ( #join(receiverList)#)
select * from xzx_sys_config_info where config_group='PACKAGE_TYPE'
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)# )
@}