Convert query from Mysql to Eloquent Laravel

Question

I need Help to Convert Mysql Query to Eloquent Laravel

 SELECT SUM((id_user=7) * `commission_agent`) AS sum7,SUM((id_user=8) * `commission_agent`) as sum8 FROM agents_commission

Victor · Accepted Answer · 2015-02-10 15:06:00Z

1

if you have the agents commission model set up correctly, you can use something like:

AgentCommission::select(DB::raw("SUM((id_user=7) *commission_agent) AS sum7,SUM((id_user=8) *commission_agent) as sum8"))->from(agents_commission)->get();

edited Feb 10, 2015 at 15:06

answered Feb 10, 2015 at 14:59

Victor

5661 gold badge10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Victor Over a year ago

@muhammad what problem are you having?

Collectives™ on Stack Overflow

Convert query from Mysql to Eloquent Laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related