/**
* @param Request $request
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function preview_dental_billform(Request $request)
{
$rules = ['exam_from' => 'required|date|before:exam_to', 'exam_to' => 'required|date|after:exam_from', 'dentist_id' => 'required'];
$this->validate($request, $rules);
$from = Carbon::parse($request->input('exam_from'));
$to = Carbon::parse($request->input('exam_to'));
$dents = Dental::getBilling($request->input('dentist_id'), $from, $to)->get();
$data = ['data' => $dents, 'from' => $from, 'to' => $to, 'rspan' => 8, 'rptTitle' => 'Billing Report', 'pageTitle' => 'ODRMS - Reports - Dental Billing Report'];
return view('reports.dental-billing', $data);
}
public function dentalform($pid, $tno)
{
$dental = Dental::with('patient.agency', 'dentist')->where('trans_no', '=', $tno)->firstOrFail();
$data = ['res' => $dental, 'pageTitle' => 'Dental Form - ' . $dental->patient->name];
return view('reports.dental', $data);
}
public static function getBilling($dentist, $from, $to)
{
return Dental::with('patient.agency', 'dentist')->where('dentist_id', '=', $dentist)->where('exam_dt', '>=', $from)->where('exam_dt', '<=', $to);
}
