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);
}
