public static function totalMonthlyCoverage() { $visitClass = Customer::select('class')->where('mr_id', \Auth::user()->id)->get()->toArray(); $totalVisitsCount = VisitClass::whereIn('name', $visitClass)->sum('visits_count'); $actualVisitsCount = Report::where('mr_id', \Auth::user()->id)->where('month', date('M') . '-' . date('Y'))->count(); return number_format($actualVisitsCount / $totalVisitsCount * 100, 2); }
public function search() { $classes = VisitClass::all(); $specialties = Customer::select('specialty')->distinct()->get(); $MRs = Employee::where('level_id', 7)->get(); $dataView = ['classes' => $classes, 'specialties' => $specialties, 'MRs' => $MRs]; return view('admin.search.coverage.search', $dataView); }
public static function getNextId() { $id = Customer::select("customer_id")->orderBy("customer_id", 'decs')->first()->customer_id + 1; if ($id) { return $id; } return 1; }
public function search() { $classes = VisitClass::all(); $employees = Employee::select('id')->where('manager_id', \Auth::user()->id)->get(); $specialties = Customer::select('specialty')->whereIn('mr_id', $employees)->distinct()->get(); $MRs = Employee::where('manager_id', \Auth::user()->id)->get(); $dataView = ['classes' => $classes, 'specialties' => $specialties, 'MRs' => $MRs]; return view('am.search.coverage.search', $dataView); }
public function tires() { $customers = Customer::select(["customer_id", "name"])->orderBy('name')->get(); return view('tire.tires', compact('customers')); }
public function getCustomers() { return Customer::select(['customer_id', 'name'])->orderBy('name')->get(); }
/** * Search Customer function */ public function search(Request $request) { $keywords = $request->input('keywords'); $column = ['id', 'created_at', 'owner', 'rego', 'make', 'model', 'colour']; $customers = Customer::select($column)->where('owner', 'like', '%' . $keywords . '%')->orWhere('rego', 'like', '%' . $keywords . '%')->orWhere('make', 'like', '%' . $keywords . '%')->orWhere('model', 'like', '%' . $keywords . '%')->orWhere('colour', 'like', '%' . $keywords . '%')->get(); return view('crashzone.partials.search_result', compact('customers')); }
public function create() { $customers = Customer::select(["customer_id", "name"])->orderBy('name')->get(); return view('order.create_order', compact("customers")); }
public function specialtyCoverageStats($mrId) { $totalVisits = []; $actualVisits = []; $specialtyCoverage = []; $specialty = NULL; $counter = 0; $allSpecialties = Customer::select('specialty')->where('mr_id', $mrId)->get()->toArray(); $allCustomersSpecialties = Customer::whereIn('specialty', $allSpecialties)->get()->toArray(); // Get all medical rep customers specialties foreach ($allCustomersSpecialties as $singleCustomer) { $allSpecialtyClasses[$singleCustomer['specialty']] = Customer::select('class')->where('specialty', $singleCustomer['specialty'])->get()->toArray(); } // Get all customer classes based on specialty foreach ($allSpecialtyClasses as $specialty => $specialtyClasses) { // Calculate total visits based on classes and specialty foreach ($specialtyClasses as $singleSpecialtyClass) { if (isset($totalVisits[$specialty])) { $totalVisits[$specialty] += VisitClass::where('name', $singleSpecialtyClass)->first()->visits_count; } else { $totalVisits[$specialty] = VisitClass::where('name', $singleSpecialtyClass)->first()->visits_count; } } } // Get all doctors visited $doctorsVisited = Report::select('doctor_id')->where('month', date('M-Y'))->where('mr_id', $mrId)->get()->toArray(); foreach ($doctorsVisited as $singleDoctor) { // calculate actual visits $specialty = Customer::select('specialty')->findOrFail($singleDoctor)->first()->specialty; if (isset($actualVisits[$specialty])) { $actualVisits[$specialty] += 1; } else { $actualVisits[$specialty] = 1; } } foreach ($allCustomersSpecialties as $singleCustomerSpecialty) { $specialty = $singleCustomerSpecialty['specialty']; $specialtyCoverage[$specialty] = 0; if (isset($specialtyCoverage[$specialty]) && isset($actualVisits[$specialty]) && isset($totalVisits[$specialty])) { $specialtyCoverage[$specialty] = number_format($actualVisits[$specialty] / $totalVisits[$specialty] * 100, 2); } } foreach ($specialtyCoverage as $specialty => $percentage) { if (isset($specialtyCoverage[$specialty])) { $stats[$counter]['label'] = $specialty; $stats[$counter]['data'] = $percentage; } $counter++; } return $stats; }