CODEWITHSUNDEEP
laravel-4eloquent
mohammad
mohammad

Reputation: 21

Convert query from Mysql to Eloquent Laravel

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

Upvotes: 0

Views: 120

Answers (1)

Victor
Victor

Reputation: 556

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();

Upvotes: 1

Related Questions