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 avPositivity2($year = "") { if (empty($year)) { $year = date("Y"); } $res = Sample::select(\DB::raw("month(date_results_entered) AS mth,count(s.id) AS num"))->from("dbs_samples AS s")->whereYear('s.date_results_entered', '=', $year)->groupby('mth')->get(); $mths_with_p_nrs = Sample::countPositives2($year); $months = \MyHTML::initMonths(); foreach ($res as $k) { $ttl_num = $k->num; $ttl_pos = $mths_with_p_nrs[$k->mth]; $av = $ttl_num > 0 ? $ttl_pos / $ttl_num * 100 : 0; $months[$k->mth] = round($av, 1); } return $months; }