예제 #1
0
 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';
     }
 }