public function create($doctorId = NULL) { $description_names = Customer::distinct()->select('description_name')->where('mr_id', \Auth::user()->id)->get(); $doctors = Customer::where('mr_id', \Auth::user()->id)->get(); $products = Product::where('line_id', Employee::find(\Auth::user()->id)->line_id)->get(); $gifts = Gift::all(); $allManagers = Employee::yourManagers(\Auth::user()->id); $dataView = ['description_names' => $description_names, 'doctors' => $doctors, 'products' => $products, 'gifts' => $gifts, 'doctorId' => !empty($doctorId) ? $doctorId : '', 'allManagers' => $allManagers]; if (!empty($doctorId)) { \Session::set('planned_visit', 1); } return view('mr.report.create', $dataView); }
public function create($doctorId = NULL) { $AMIds = Employee::select('id')->where('manager_id', 1)->get(); $employees = Employee::select('id')->whereIn('manager_id', $AMIds)->get(); $description_names = Customer::distinct()->select('description_name')->whereIn('mr_id', $employees)->get(); $doctors = Customer::whereIn('mr_id', $employees)->get(); $employeesLines = Employee::select('line_id')->where('manager_id', 4)->get(); $products = Product::where('line_id', $employeesLines)->get(); $gifts = Gift::all(); $dataView = ['description_names' => $description_names, 'doctors' => $doctors, 'products' => $products, 'gifts' => $gifts, 'doctorId' => !empty($doctorId) ? $doctorId : '']; return view('sm.report.create', $dataView); }