samedi 23 mars 2019

How to get data in single array

I am trying to get data from db into a single array

This what i have tried

foreach ($userid as &$user){
        foreach ($list1 as $day){
        //Get Total Number of Personal Leads By User ID & Requested week Through Each Day
        $personalleads = \DB::table('leads') 
        ->where('owned_by_id', $id) // User ID
        ->where('lead_source_id', 7) // 7 = Personal Lead
        ->whereRaw("DATE(created_at) = '$day'") // get week through GET request & Query the data
        ->groupBy('created_at')
        ->get(); // Get All Data
        $user->pleads = $personalleads->count();

        //Get Total Number of leads Created by Managers By User ID & Requested week Through Each Day
        $managerleads = \DB::table('leads') 
        ->where('owned_by_id', $id) // User ID
        ->where('lead_source_id', 3) // 3 = Manager Lead
        ->whereRaw("DATE(created_at) = '$day'") // get week through GET request & Query the data
        ->groupBy('created_at')
        ->get(); // Get All Data
        $user->mleads = $managerleads->count();

         //Get Total Number of leads Created by Admins By User ID & Requested week Through Each Day
        $adminleads = \DB::table('leads') 
        ->where('owned_by_id', $id) // User ID
        ->where('lead_source_id', 4) // 4 = Admin Lead
        ->whereRaw("DATE(created_at) = '$day'") // get week through GET request & Query the data
        ->groupBy('created_at')
        ->get(); // Get All Data
        $user->aleads = $adminleads->count();
        echo ($userid);
        }
    }

I Expect

[{"userid":1,"pleads":2,"mleads":1,"aleads":1},{"userid":1,"pleads":0,"mleads":0,"aleads":0},{"userid":1,"pleads":0,"mleads":0,"aleads":0},{"userid":1,"pleads":1,"mleads":0,"aleads":0},{"userid":1,"pleads":1,"mleads":0,"aleads":0},{"userid":1,"pleads":1,"mleads":0,"aleads":0},{"userid":1,"pleads":0,"mleads":0,"aleads":0}]

What i get

[{"userid":1,"pleads":2,"mleads":1,"aleads":1}][{"userid":1,"pleads":0,"mleads":0,"aleads":0}][{"userid":1,"pleads":0,"mleads":0,"aleads":0}][{"userid":1,"pleads":1,"mleads":0,"aleads":0}][{"userid":1,"pleads":1,"mleads":0,"aleads":0}][{"userid":1,"pleads":1,"mleads":0,"aleads":0}][{"userid":1,"pleads":0,"mleads":0,"aleads":0}][]

Thank you very much



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire