Esempio n. 1
0
 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);
 }
Esempio n. 2
0
 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);
 }