[ad_1]
public function getNCBPEmployees() {
$driver="Driver";
$other = ['Batching Plant Operator', 'Helper', 'Silo Helper', 'Quality Control', 'Warehouseman', 'Managing Director', 'CFO'];
$ncbp_emp_positions = Positions::select(
'positions.id',
'positions.name as language'
)
->where('name', 'LIKE', '%Driver%')
->orWhereIn('name', $other)
->get()->toArray();
foreach ($ncbp_emp_positions as $key=>$position){
$subQuery = Employees::select(DB::raw('CONCAT(employees.first_name,\' \', employees.last_name) AS name'))
->join('employees_positions', 'employees_positions.employees_id', '=', 'employees.id')
->where('employees_positions.positions_id', '=', $position['id'])
->get()->toArray();
if(!isset($ncbp_emp_positions[$key]['libs'])){
$ncbp_emp_positions[$key]['libs'] = array();
}
$ncbp_emp_positions[$key]['libs'] = $subQuery;
unset($ncbp_emp_positions[$key]['id']);
}
dd($ncbp_emp_positions);
exit();
return $ncbp_emp_positions;
}
[ad_2]