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