function show_cto_balance($office_id = '') { $data = array(); $this->Employee->fields = array('id', 'employee_id', 'office_id', 'lname', 'fname', 'mname'); $data['rows'] = $this->Employee->get_employee_list(Session::get('office_id'), ''); if ($office_id != '') { $data['rows'] = $this->Employee->get_employee_list($office_id, ''); } // foreach ($data['rows'] as $row) { $c = CompensatoryTimeoff::where('employee_id', '=', $row['employee_id'])->where('type', '=', 'balance')->first(); if ($c == null) { $c = new CompensatoryTimeoff(); $c->employee_id = $row['employee_id']; $c->status = 'active'; $c->type = 'balance'; $c->save(); } } return View::make('ajax/show_cto_balance', $data); }