public function initiate($settingVars) { $this->settingVars = $settingVars; $this->queryVars = projectsettings\settingsGateway::getInstance(); $this->ValueVolume = getValueVolume($this->settingVars); filters\timeFilter::getSlice($this->settingVars); $this->jsonOutput = array(); }
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); }
public function fetch_all_timeSelection_data() { $timeSelectionDataCollectors = new datahelper\Time_Selection_DataCollectors($this->settingVars); filters\timeFilter::getYTD($this->settingVars); //ALTERNATIVE OF getSlice WHEN THE PROJECT IS LOADING FOR FIRST TIME //COLLECT TIME SELECTION DATA if ($_REQUEST['includeFutureDates'] == 'true') { switch ($this->settingVars->timeSelectionUnit) { case 'week': $timeSelectionDataCollectors->getAllWeek_with_future_dates($this->jsonOutput); break; case 'month': $timeSelectionDataCollectors->getAllMonth_with_future_dates($this->jsonOutput); break; default: $timeSelectionDataCollectors->getAllWeek_with_future_dates($this->jsonOutput); } } else { $timeSelectionDataCollectors->getAllWeek($this->jsonOutput); } $timeSelectionDataCollectors->getAllDates($this->jsonOutput); }