public function show($time = "") { if (empty($time)) { $time = date("Y"); } $regions = Region::regionsArr(); $districts = District::districtsArr(); $facility_levels = FacilityLevel::facilityLevelsArr(); $count_positives = Sample::countPositives($time); $av_positivity = Sample::avPositivity($time); $count_positives_arr = Sample::countPositives2($time); $av_positivity_arr = Sample::avPositivity2($time); return view('db/show', compact("time", "regions", "districts", "facility_levels", "count_positives", "av_positivity", "count_positives_arr", "av_positivity_arr")); }
public static function avPositivity($year = "") { if (empty($year)) { $year = date("Y"); } $res_all = Sample::select(\DB::raw("count(s.id) AS num"))->from("dbs_samples AS s")->whereYear('s.date_results_entered', '=', $year)->get()->first(); $ttl_num = $res_all->num; $ttl_pos = Sample::countPositives($year); $ttl_av = $ttl_num > 0 ? $ttl_pos / $ttl_num * 100 : 0; return round($ttl_av, 1); }