コード例 #1
0
 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);
 }