public function __construct()
{
$this->months = \MyHTML::initMonths();
$this->mongo = Mongo::connect();
$this->conditions = $this->_setConditions();
//$this->middleware('auth');
}
private static function districtMonthsInit()
{
$districts = Location\District::districtsArr();
$months = \MyHTML::initMonths();
$ret = [];
foreach ($districts as $dID => $d) {
$ret[$dID] = $months;
}
return $ret;
}
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;
}
