public function getOperators($company_id) { $department_ids = Department::where('company_id', $company_id)->lists('id'); $operators = []; if (sizeof($department_ids) > 0) { $operator_ids = OperatorsDepartment::whereIn('department_id', $department_ids)->lists('user_id'); if (sizeof($operator_ids) > 0) { $operators = User::whereIn('id', $operator_ids)->get(); } } foreach ($operators as $operator) { $department_id = OperatorsDepartment::where('user_id', $operator->id)->pluck("department_id"); $department = Department::find($department_id); $company = Company::find($department->company_id); $operator->department = $department; $operator->company = $company; } $this->data['operators'] = $operators; return View::make('companies.operators', $this->data); }
public function transfer($onlineusers_id) { $online_users = OnlineUsers::find($onlineusers_id); $companies = Company::all(); $this->data['operators'] = []; if (sizeof($companies) > 0) { $departments = Department::where('company_id', $online_users->company_id)->get(); $department_ids = Department::where('company_id', $online_users->company_id)->lists('id'); if (sizeof($department_ids) > 0) { $operator_ids = OperatorsDepartment::whereIn('department_id', $department_ids)->lists('user_id'); if (sizeof($operator_ids) > 0) { $this->data['operators'] = User::whereIn('id', $operator_ids)->get(); } } } else { $departments = []; } $this->data['companies'] = $companies; $this->data['departments'] = $departments; $this->data['online_users'] = $online_users; $this->data['company_id'] = $online_users->company_id; $this->data['department_id'] = $online_users->department_id; $this->data['customer'] = User::find($online_users->user_id); return View::make('conversations.transfer', $this->data); }