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);
}
