public function get_customer_assignment_status() { if (Request::input('key') && Request::input('key') == '8855a5gp2C6577') { $a = Assignment::groupBy('customer_id')->get(); foreach ($a as $key => $value) { $cusID = $value->customer_id; $customer[$key]['customer_id'] = $cusID; $customer[$key]['open'] = Assignment::where('customer_id', $cusID)->where('status', 1)->count(); $customer[$key]['closed'] = Assignment::where('customer_id', $cusID)->where('status', 0)->count(); } return $customer; } else { return 'You do not have permission to view this page'; } }