/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(ReportFormRequest $request)
{
$report = new \App\Model\Report();
$report->user_id = $request->get('user_id');
$report->website_id = $request->get('website_id');
$report->save();
return redirect('/analisi/reports')->with('custom_success', 'Your report has been created! ');
}
public function indoor_test_summary_range(ReportFormRequest $request)
{
$start_date = $request->input('starting_date');
$end_date = $request->input('ending_date');
$xray = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('digital_xray');
$ultrasonogram = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('ultrasonogram');
$ecg = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('ecg');
$digital_ecg = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('digital_ecg');
$endoscopy = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('endoscopy');
$blood_grouping = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('blood_grouping');
$blood_cs = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('blood_cs');
$blood_cbc = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('blood_cbc');
$urine = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('urine');
$hbs_normal = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('hbs_normal');
$ct_scan = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('ct_scan');
$stool = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('stool');
$operation_bill = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('operation_bill');
$dr_bill = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('dr_bill');
$service_bill = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('service_bill');
$medicine_bill = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('medicine_bill');
$cabin_bill = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('cabin_bill');
$others_bill = DB::table('indoor_patients')->whereBetween('arrival_date', array($start_date, $end_date))->sum('others_bill');
return view('Report.range_indoor_test_balance', compact('start_date', 'end_date', 'xray', 'ultrasonogram', 'ecg', 'digital_ecg', 'endoscopy', 'blood_grouping', 'blood_cs', 'blood_cbc', 'urine', 'hbs_normal', 'ct_scan', 'stool', 'operation_bill', 'dr_bill', 'service_bill', 'medicine_bill', 'cabin_bill', 'others_bill'));
}
