public static function regionsArr()
{
$arr = array();
foreach (Region::all() as $region) {
$arr[$region->id] = $region->region;
}
return $arr;
}
public static function regionsFacilitiesInit()
{
$arr = array();
$res = Region::rightjoin('districts AS d', 'd.id', '=', 'f.districtID')->rightjoin('regions AS r', 'r.id', '=', 'd.regionID')->select('regionID', 'region', 'f.id AS facility_id')->from('facilities AS f')->get();
foreach ($res as $row) {
$arr[$row->regionID][$row->facility_id] = 0;
}
return $arr;
}
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"));
}
private static function regionMonthsInit()
{
$regions = Location\Region::regionsArr();
$months = \MyHTML::initMonths();
$ret = [];
foreach ($regions as $regID => $reg) {
$ret[$regID] = $months;
}
return $ret;
}