Exemple #1
0
 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);
 }