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(); }
public static function collect_Filter_Data($selectPart, $groupByPart, $jsonTag, $tablename, $querypart, &$jsonOutput, $includeIdInLabel = false) { $queryVars = projectsettings\settingsGateway::getInstance(); $query = "SELECT " . implode(",", $selectPart) . " " . "FROM {$tablename} {$querypart} " . "GROUP BY " . implode(",", $groupByPart) . " " . "HAVING PRIMARY_LABEL <>'' " . "ORDER BY PRIMARY_LABEL ASC "; $result = $queryVars->queryHandler->runQuery($query, $queryVars->linkid, db\ResultTypes::$TYPE_OBJECT); foreach ($result as $key => $data) { $dataVal = in_array('PRIMARY_ID', $groupByPart) ? $data['PRIMARY_ID'] : $data['PRIMARY_LABEL']; $temp = array('data' => htmlspecialchars($dataVal), 'label' => $includeIdInLabel ? htmlspecialchars_decode($data['PRIMARY_LABEL'] . " ( " . $data['PRIMARY_ID'] . " ) ") : htmlspecialchars_decode($data['PRIMARY_LABEL']), 'label_hash_secondary' => htmlspecialchars_decode($data['PRIMARY_LABEL'] . " #" . $data['SECONDARY_LABEL'])); $jsonOutput[$jsonTag][] = $temp; } }
public function __construct($settingVars) { $this->queryVars = projectsettings\settingsGateway::getInstance(); $this->settingVars = $settingVars; }
public static function calculate_Ty_And_Ly_WeekRange_From_TimeFrame($timeFrame, $settingVars) { $queryVars = projectsettings\settingsGateway::getInstance(); //setting "TO" variables to LATEST YEAR AND IT'S LATEST WEEK $query = "SELECT " . $settingVars->yearperiod . " AS YEAR" . "," . $settingVars->weekperiod . " AS WEEK " . "FROM " . $settingVars->timeHelperTables . $settingVars->timeHelperLink . " " . "GROUP BY YEAR,WEEK " . "ORDER BY YEAR DESC,WEEK DESC " . "LIMIT 0,1"; //print $query;exit; $result = $queryVars->queryHandler->runQuery($query, $queryVars->linkid, db\ResultTypes::$TYPE_ARRAY); $data = $result[0]; self::$ToWeek = $data[1]; self::$ToYear = $data[0]; //setting "FROM" variables depends on passed $limit $query = "SELECT " . $settingVars->yearperiod . " AS YEAR" . "," . $settingVars->weekperiod . " AS WEEK " . "FROM " . $settingVars->timeHelperTables . $settingVars->timeHelperLink . " " . "GROUP BY YEAR,WEEK " . "ORDER BY YEAR DESC,WEEK DESC " . "LIMIT " . ($timeFrame - 1) . ",1"; //print $query;exit; $result = $queryVars->queryHandler->runQuery($query, $queryVars->linkid, db\ResultTypes::$TYPE_ARRAY); $data = $result[0]; self::$FromWeek = $data[1]; self::$FromYear = $data[0]; //PREPARE TY AND LY WEEKRANGE TO USE IN QUERY self::prepareTyLyWeekRange($settingVars); }