Laravel model 大神帮个忙 DB:select 转 model
select p301_id, a.pg_name as p301_name, a.pg_income as p301_income, sum(p301_money) as p301_money, admin_id, sum(admin_money) as admin_money \
from (\
select from (\ select sum(p_money) as p301_money,p.p_id as p301_id, p.tableid from log_partner as p \
left join pg_admin as a on a.pg_id = p.p_id\
where a.pg_level = 301 and to_char(p.created, 'yyyy-mm-dd') between '{$Arr['S_Date_S']}' and '{$Arr['S_Date_E']}' \
group by p.p_id,p.tableid \
) as p301 \
left join (\
select from (\ select sum(p_money) as admin_money, p.p_id as admin_id, p.tableid as a_tableid from log_partner as p \
left join pg_admin as a on a.pg_id = p.p_id\
where a.pg_id = 'Admin_Master' and to_char(p.created, 'yyyy-mm-dd') between '{$Arr['S_Date_S']}' and '{$Arr['S_Date_E']}' \
group by p.p_id,p.tableid\
) as dd\ ) as padmin on p301.tableid = padmin.a_tableid) as cc \
inner join pg_admin as a on a.pg_id = cc.p301_id \
group by p301_id, admin_id, a.pg_name, a.pg_income
本作品采用《CC 协议》,转载必须注明作者和本文链接
推荐文章: