function getLatestWeek() { $query = "SELECT MAX(" . $this->settingVars->yearperiod . ") FROM " . $this->settingVars->timeHelperTables . " " . $this->settingVars->timeHelperLink; $result = $this->queryVars->queryHandler->runQuery($query, $this->queryVars->linkid, db\ResultTypes::$TYPE_ARRAY); $data = $result[0]; filters\timeFilter::$ToYear = $data[0]; filters\timeFilter::$FromYear = filters\timeFilter::$ToYear; $query = "SELECT MAX(" . $this->settingVars->weekperiod . ")" . ",MIN(" . $this->settingVars->weekperiod . ") " . "FROM " . $this->settingVars->timeHelperTables . $this->settingVars->timeHelperLink . " AND " . $this->settingVars->yearperiod . "=" . filters\timeFilter::$ToYear; $result = $this->queryVars->queryHandler->runQuery($query, $this->queryVars->linkid, db\ResultTypes::$TYPE_ARRAY); $data = $result[0]; filters\timeFilter::$ToWeek = $data[0]; filters\timeFilter::$FromWeek = $data[1]; //USEFUL WHEN DEBUGGING, DON'T DELETE //print 'Max Week: '.filters\timeFilter::$ToWeek." Min Week: ".filters\timeFilter::$FromWeek; //exit; filters\timeFilter::getExtraSlice($this->settingVars); }