Horje
laravel group by on subquery Code Example
group by laravel 
$user_info = DB::table('usermetas')
                 ->select('browser', DB::raw('count(*) as total'))
                 ->groupBy('browser')
                 ->get();
Source: stackoverflow.com
laravel group by on subquery 
return DB::table('candidates AS c')
    ->select( DB::raw('c.name AS c_name,j.name AS j_name,t.questions AS questions, count(g.grade) as countGrade'))
    ->join('job_openings AS j', 'c.fk_id_job_opening', '=','j.id_job_opening')
    ->join('interview_templates AS t', 'j.fk_id_template', '=', 't.id_template')
    ->join('responses AS r', 'r.fk_id_candidate', '=', 'c.id_candidate')
    ->join('grades AS g', 'r.id_response', '=', 'g.fk_id_response')
    ->where('g.fk_id_user',Auth::id())
    ->groupBy('c_name', 'j_name', 'questions')
    ->get();
Source: stackoverflow.com
laravel group by with where clause 
$groupedSalesCampaign = Order::with('Campaign')
            ->where('isapproved','=','Y')
            ->groupBy('campaign_id')
            ->orderBy(DB::raw('COUNT(id)','desc'))
            ->get(array(DB::raw('COUNT(id) as totalsales'),'campaign_id'));
Source: stackoverflow.com



Php

Related
init hook wordpress Code Example init hook wordpress Code Example
stream_set_blocking Code Example stream_set_blocking Code Example
render vs redirect laravel exception Code Example render vs redirect laravel exception Code Example
laravel api too many requests Code Example laravel api too many requests Code Example
php get content phpinfo without show Code Example php get content phpinfo without show Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje