diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyTimeProfiles.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyTimeProfiles.php | 707 |
1 files changed, 707 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyTimeProfiles.php b/admin/survey/classes/class.SurveyTimeProfiles.php new file mode 100644 index 0000000..0c88b11 --- /dev/null +++ b/admin/survey/classes/class.SurveyTimeProfiles.php @@ -0,0 +1,707 @@ +<?php
+/**
+ * Created on 13.01.2011
+ *
+ * @author: Gorazd Veselič
+ */
+
+
+
+define('STP_INTERVAL_1_DAY', '1 day'); # previdno pri spremembi tekstov, ker gre za PHP veljavne stringe za računanje z datumi
+define('STP_INTERVAL_2_DAY', '2 day');
+define('STP_INTERVAL_5_DAY', '5 day');
+define('STP_INTERVAL_7_DAY', '7 day');
+define('STP_INTERVAL_14_DAY', '14 day');
+define('STP_INTERVAL_1_MONTH', '1 month');
+define('STP_INTERVAL_3_MONTH', '3 month');
+define('STP_INTERVAL_6_MONTH', '6 month');
+
+
+define('STP_DEFAULT_PROFILE', 0);
+
+class SurveyTimeProfiles {
+
+ static private $surveyId = null;
+ static private $uId = null;
+
+ static private $currentProfileId = null; # trenutno profil
+ static private $profiles = array(); # seznam vseh profilov od uporabnika
+
+ static private $start_date = null; # začetek ankete
+ static private $end_date = null; # konec ankete
+
+ static private $STP_ARRAYS = array( STP_INTERVAL_1_DAY,
+ STP_INTERVAL_2_DAY,
+ STP_INTERVAL_5_DAY,
+ STP_INTERVAL_7_DAY,
+ STP_INTERVAL_14_DAY,
+ STP_INTERVAL_1_MONTH,
+ STP_INTERVAL_3_MONTH,
+ STP_INTERVAL_6_MONTH); // array možnih intervalov za dropdown
+
+ static function getSurveyId() { return self::$surveyId; }
+ static function getGlobalUserId() { return self::$uId; }
+ static function getCurentProfileId() { return (int)self::$currentProfileId; }
+
+ /** Inizializacija, poišče id privzetega profila in prebere vse profiel ki jih ima uporabnik na voljo
+ *
+ * @param $_surveyId
+ */
+ static function Init($_surveyId)
+ {
+
+ global $global_user_id, $lang;
+
+ if ($_surveyId && $global_user_id)
+ {
+ self::$surveyId = $_surveyId;
+ self::$uId = $global_user_id;
+
+ # inicializiramo datoteko z nastavitvami
+ SurveyUserSetting :: getInstance()->Init(self::$surveyId, self::$uId);
+ # preverimo ali ima uporabnik nastavljen privzet profil
+ $dsp = SurveyUserSetting :: getInstance()->getSettings('default_time_profile');
+
+ if ( $dsp == null ) {
+ # nastavimo privzet profil v clas
+ $dsp = 0;
+ }
+
+ #dodamo profil iz seje
+ if ( (int)$dsp == -1 ) {
+ if ( isset($_SESSION['time_profile'][self::$surveyId])) {
+ #dodamo profil iz seje
+ self::$profiles['-1'] = array('id'=>'-1',
+ 'name'=>$lang['srv_temp_profile'],
+ 'type'=>$_SESSION['time_profile'][self::$surveyId]['type'],
+ 'starts'=>$_SESSION['time_profile'][self::$surveyId]['starts'],
+ 'ends'=>$_SESSION['time_profile'][self::$surveyId]['ends'],
+ 'interval_txt'=>$_SESSION['time_profile'][self::$surveyId]['interval_txt']);
+ $dsp = -1;
+
+ } else {
+ // ni v seji, naredimo privzetega
+ $dsp = 0;
+ }
+ }
+
+ # če mamo spremembo shranimo
+ self::SetDefaultProfileId((int)$dsp);
+
+ #dodamo privzet profil
+ # datum od, "ce ni podan vzamemo kreacijo ankete
+ SurveyInfo :: getInstance()->SurveyInit(self::getSurveyId());
+
+ self::$start_date = date(STP_DATE_FORMAT, strtotime(SurveyInfo::getInstance()->getSurveyInsertDate()));
+
+ # datum do, "ce ni podan vzamemo danasnji dan
+ self::$end_date = date(STP_DATE_FORMAT);// ce ne,
+
+ # dodamo sistemski profil
+ self::$profiles['0'] = array( 'id'=>0,
+ 'type'=>0,
+ 'name'=>$lang['srv_default_profile'],
+ 'starts'=>self::$start_date,
+ 'ends'=>self::$end_date,
+ 'interval_txt'=>'');
+
+ # poiščemo še seznam vseh ostalih profilov uporabnika
+ $stringSelect = "SELECT id, name, type, DATE_FORMAT(starts,'".STP_CALENDAR_DATE_FORMAT."') AS starts, DATE_FORMAT(ends,'".STP_CALENDAR_DATE_FORMAT."') AS ends, interval_txt FROM srv_time_profile WHERE uid = '".self::getGlobalUserId()."' || uid = '0' ORDER BY id";
+ $querySelect = sisplet_query($stringSelect);
+
+ while ( $rowSelect = mysqli_fetch_assoc($querySelect) ) {
+ self::$profiles[$rowSelect['id']] = array( 'id'=>$rowSelect['id'],
+ 'name'=>$rowSelect['name'],
+ 'type'=>$rowSelect['type'],
+ 'starts'=>$rowSelect['starts'],
+ 'ends'=>$rowSelect['ends'],
+ 'interval_txt'=>$rowSelect['interval_txt']);
+ }
+
+ # nastavimo id profil klassa na izbran
+ self::$currentProfileId = (int)$dsp;
+
+ return true;
+ } else {
+ return false;
+ }
+ }
+
+ static function getSystemDefaultProfile() {
+ return (int)STP_DEFAULT_PROFILE;
+ }
+
+ /** Vrne podatke trenutno izbranega profofila
+ *
+ */
+ static function GetCurentProfileData() {
+ return self::$profiles[self::$currentProfileId];
+ }
+
+ /** Vrne podatke podanega profofila
+ *
+ */
+ static function GetProfileData($pid) {
+ return self::$profiles[$pid];
+ }
+
+ public function getProfileName($pid) {
+ return self::$profiles[$pid]['name'];
+ }
+
+ /** Vrne array z start date in end date
+ *
+ */
+ static function GetDates($forceDefaultFilter = false) {
+ if ($forceDefaultFilter == false) {
+ $_profile_data = self :: GetCurentProfileData();
+ # ali imam o privzete datume filtra
+ $is_default_dates = ((int)$_profile_data['id'] == 0 ? true : false);
+ } else {
+ # zaradi možnosti masovnega zbiranja vsilimo privzet datum
+ $_profile_data = self::$profiles[0];
+ # ali imam o privzete datume filtra
+ $is_default_dates = true;
+ }
+
+ # nastavimo start date in end date
+ if ($_profile_data['interval_txt'] != '') {
+ # ce imamo nastavljen datum preko intervala
+ $end_date = date(STP_OUTPUT_DATE_FORMAT);
+ $start_date = date(STP_OUTPUT_DATE_FORMAT,strtotime(date(STP_OUTPUT_DATE_FORMAT, strtotime($end_date)) . ' - '.$_profile_data['interval_txt']));
+
+ } else if ($_profile_data['starts'] != '' && $_profile_data['ends'] != '') {
+ # imamo podana oba datuma
+ $start_date = date(STP_OUTPUT_DATE_FORMAT,strtotime($_profile_data['starts']));
+ $end_date = date(STP_OUTPUT_DATE_FORMAT,strtotime($_profile_data['ends']));
+ } else {
+ # napaka vzamemo datum kreacije ankete in današnji datum
+ $start_date = date(STP_OUTPUT_DATE_FORMAT,strtotime(SurveyInfo::getInstance()->getSurveyInsertDate()));
+ $end_date = date(STP_OUTPUT_DATE_FORMAT);;
+
+ }
+ # končni datum po potrebi zmanjšamo na današnji datum
+ if (strtotime($end_date) > strtotime(date(STP_OUTPUT_DATE_FORMAT))) {
+ $end_date = date(STP_OUTPUT_DATE_FORMAT);
+ }
+ return array('start_date'=>$start_date, 'end_date'=>$end_date, 'is_default_dates' => $is_default_dates);
+ }
+
+ /** Pridobimo seznam vseh list uporabnika
+ * v obliki arraya
+ */
+ static function getProfiles() {
+ return self::$profiles;
+ }
+
+ /* Vrne ID in ime trenutno izbranega profila
+ *
+ */
+ function getCurentProfile() {
+ return array('id'=>self::$currentProfileId,'name'=>self::$profiles[self::$currentProfileId]['name']);
+ }
+
+ /** Ponastavi id privzetega profila
+ *
+ */
+ static function SetDefaultProfile($pid) {
+ self::SetDefaultProfileId($pid);
+ }
+
+ static function SetDefaultProfileId($pid) {
+
+ self::$currentProfileId = (int)$pid;
+
+ $saved = SurveyUserSetting :: getInstance()->saveSettings('default_time_profile',(int)$pid);
+ }
+
+ static function ChooseProfile($pid) {
+ # če smo izbrali drug profil resetiramo še profil profilov na trenutne nastavitve
+ SurveyUserSetting :: getInstance()->saveSettings('default_profileManager_pid', '0');
+
+ self::SetDefaultProfileId((int)$pid);
+ self::$currentProfileId = (int)$pid;
+
+ }
+
+ /**
+ *
+ */
+ static function SaveProfile($pid,$type,$startDate,$endDate,$stat_interval) {
+ global $lang;
+ if ((int)$pid == 0 ) {
+ # imamo privzet profil
+ self :: ChooseProfile((int)$pid);
+ $updated = true;
+ } else if ((int)$pid > 0) {
+ # shranimo v bazo
+ if ((int)$type == 0) { # $type = '0';
+ # shranjujemo od - do
+ $stat_interval = '';
+ $_startDate = date(STP_OUTPUT_DATE_FORMAT, strtotime($startDate));
+ $_endDate = date(STP_OUTPUT_DATE_FORMAT, strtotime($endDate));
+
+ $update = "UPDATE srv_time_profile SET starts = '".$_startDate."', ends='".$_endDate."', type='".$type."', interval_txt = '' WHERE id = '".$pid."'";
+ } else { # $type = '1';
+ # shranjujemo interval
+ $startDate = '';
+ $endDate = '';
+ $type = '1';
+ $update = "UPDATE srv_time_profile SET starts = '0000-00-00 00:00:00', ends='0000-00-00 00:00:00', type='".$type."', interval_txt = '".$stat_interval."' WHERE id = '".$pid."'";
+ }
+
+ $updated = sisplet_query($update);
+ # ce je bili updejt ok posodobimo se vrednost v profilu
+ if ($updated) {
+ self::$profiles[$pid]['type'] = $type;
+ self::$profiles[$pid]['starts'] = $startDate;
+ self::$profiles[$pid]['ends'] = $endDate;
+ self::$profiles[$pid]['interval_txt'] = $stat_interval;
+ }
+
+ # nastavimo privzet profil na trenutnega
+ self :: ChooseProfile((int)$pid);
+
+ } else {
+ # shranjujenmo v sejo
+ $_SESSION['time_profile'][self::$surveyId] = array('id'=>'-1',
+ 'name'=>$lang['srv_temp_profile']);
+
+ if ((int)$type == 0) { # $type = '0';
+ # shranjujemo od - do
+ $_SESSION['time_profile'][self::$surveyId]['type'] = '0';
+ $_SESSION['time_profile'][self::$surveyId]['starts'] = date(STP_OUTPUT_DATE_FORMAT, strtotime($startDate));
+ $_SESSION['time_profile'][self::$surveyId]['ends'] = date(STP_OUTPUT_DATE_FORMAT, strtotime($endDate));
+ unset($_SESSION['time_profile'][self::$surveyId]['interval_txt']);
+ } else {
+ $_SESSION['time_profile'][self::$surveyId]['type'] = '1';
+ $_SESSION['time_profile'][self::$surveyId]['interval_txt'] = $stat_interval;
+ unset($_SESSION['time_profile'][self::$surveyId]['starts']);
+ unset($_SESSION['time_profile'][self::$surveyId]['ends']);
+ }
+ self::$profiles[$pid] = $_SESSION['time_profile'][self::$surveyId];
+
+ $updated = true;
+ self :: ChooseProfile((int)$pid);
+
+ }
+ return $updated;
+ }
+
+ static function RenameProfile($pid, $name) {
+
+ if (isset($pid) && $pid > 0 && isset($name) && trim($name) != "") {
+ // popravimo podatek za variables
+ $stringUpdate = "UPDATE srv_time_profile SET name = '".$name."' WHERE id = '".$pid."'";
+ $updated = sisplet_query($stringUpdate);
+ return $updated;
+ } else {
+ return -1;
+ }
+ }
+
+ static function DeleteProfile($pid = 0) {
+
+ if (isset($pid) && $pid == -1) {
+ unset($_SESSION['time_profile'][self::$surveyId] );
+ } else if (isset($pid) && $pid > 0) {
+ // Izbrišemo profil in nastavimo privzetega
+ $stringUpdate = "DELETE FROM srv_time_profile WHERE id = '".$pid."'";
+ $updated = sisplet_query($stringUpdate);
+ }
+ # nastavimo privzet profil
+ self::ChooseProfile('0');
+ }
+
+ /** Funkcija kreira nov profil
+ *
+ */
+ function createProfile($type,$startDate,$endDate,$stat_interval,$name=null) {
+ global $lang;
+ if ($name == null || trim($name) == '' ) {
+ $name = $lang['srv_new_profile'];
+ }
+
+ if ($type == '0') {
+ # shranjujemo od - do
+ $startDate = date(STP_OUTPUT_DATE_FORMAT, strtotime($startDate));
+ $endDate = date(STP_OUTPUT_DATE_FORMAT, strtotime($endDate));
+ $stat_interval = '';
+ } else {
+ # shranjujemo interval
+ $startDate = '0000-00-00';
+ $endDate = '0000-00-00';
+ $type = '1';
+ }
+
+ $iStr = "INSERT INTO srv_time_profile (id,uid,name,type,starts,ends,interval_txt)".
+ " VALUES (NULL, '".self::$uId."', '".$name."', '".$type."', '".$startDate."', '".$endDate."', '".$stat_interval."')";
+
+ $ins = sisplet_query($iStr);
+ $id = mysqli_insert_id($GLOBALS['connect_db']);
+
+ if ($id > 0) {
+ self :: ChooseProfile($id);
+ } else {
+ self :: ChooseProfile(0);
+ }
+
+ return;
+ }
+
+ /** prikažemo dropdown z izbranim profilom in link do nastavitev profila
+ *
+ *
+ */
+ static function DisplayLink($hideAdvanced = true, $showseperator = true) {
+ global $lang;
+
+ $profiles = self :: getProfiles();
+ $izbranProfil = self :: getCurentProfileId();
+
+ $css = ($izbranProfil == STP_DEFAULT_PROFILE ? ' gray' : '');
+ if ($hideAdvanced == false || $izbranProfil != STP_DEFAULT_PROFILE) {
+ if ($showseperator == true) {
+ echo '<li class="space"> </li>';
+ }
+ echo '<li>';
+ echo '<span class="as_link'.$css.'" id="link_time_profile" title="' . $lang['srv_time_profile_link_title'] . '" onClick="timeProfileAction(\'showProfiles\');">' . $lang['srv_time_profile_link'] . '</span>';
+ echo '</li>';
+
+ }
+ }
+
+
+ /** Funkcija prikaze izbor datuma
+ *
+ */
+ static function displayProfiles($current_pid = null) {
+ global $lang;
+ $_all_profiles = self::getProfiles();
+
+ // Naslov
+ echo '<h2>'.$lang['srv_obdobje_settings'].'</h2>';
+
+ echo '<div class="popup_close"><a href="#" onClick="timeProfileAction(\'cancel\'); return false;">✕</a></div>';
+
+ if ($current_pid == null) {
+ $current_pid = self::getCurentProfileId();
+ }
+ $currentFilterProfile = $_all_profiles[$current_pid];
+
+ if ( $current_pid != STP_DEFAULT_PROFILE ) {
+ echo '<div id="not_default_setting">';
+ echo $lang['srv_not_default_setting'];
+ echo '</div><br class="clr displayNone">';
+ }
+
+ echo '<div class="time_profile_left_right floatLeft">';
+ echo '<div class="time_profile_holder">';
+ # zlistamo vse profile
+
+ echo '<div id="time_profile" class="select">';
+
+ if (count($_all_profiles)) {
+ foreach ($_all_profiles as $id=>$profile) {
+
+ echo '<div class="option' . ($current_pid == $id ? ' active' : '') . '" id="time_profile_' . $id . '" value="'.$id.'">';
+
+ echo $profile['name'];
+
+ if($current_pid == $id){
+ # privzetega profila ne moremo ne zbrisat ne preimenovat
+ if ($current_pid != 0) {
+ echo '<a href="#" title="'.$lang['srv_delete_profile'].'" onclick="timeProfileAction(\'show_delete\'); return false;"><span class="faicon delete_circle icon-orange_link floatRight" style="margin-top:1px;"></span></a>';
+ }
+ if ($current_pid > 0) {
+ echo '<a href="#" title="'.$lang['srv_rename_profile'].'" onclick="timeProfileAction(\'show_rename\'); return false;"><span class="faicon edit floatRight spaceRight"></span></a>';
+ }
+ }
+
+ echo '</div>';
+ }
+ }
+ echo ' </div>'; // time_profile
+ echo '</div>'; //time_profile_holder
+
+ echo '</div>'; //time_profile_left
+
+
+ echo '<div class="time_profile_left_right floatRight">';
+ echo '<div id="time_profile_content">';
+ self::DisplayProfileData($current_pid);
+ echo '</div>'; // time_profile_content
+ echo '</div>'; // time_profile_right
+
+
+ echo '<div class="time_profile_button_right_holder floatRight">';
+ if ($current_pid == 0) {
+ echo '<span class="floatRight" title="'.$lang['srv_run_as_session_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="timeProfileAction(\'run_session_profile\'); return false;"><span>'.$lang['srv_run_as_session_profile'] . '</span></a></div></span>';
+# echo '<span class="floatRight spaceRight" title="'.$lang['srv_save_run_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'run_profile\'); return false;"><span>'.$lang['srv_run_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_create_new_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'show_create\'); return false;"><span>'.$lang['srv_create_new_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_close_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'cancel\'); return false;"><span>'.$lang['srv_close_profile'] . '</span></a></div></span>';
+ } else if ($current_pid == -1) {
+ echo '<span class="floatRight" title="'.$lang['srv_run_as_session_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="timeProfileAction(\'run_session_profile\'); return false;"><span>'.$lang['srv_run_as_session_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_create_new_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'show_create\'); return false;"><span>'.$lang['srv_create_new_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_close_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'cancel\'); return false;"><span>'.$lang['srv_close_profile'] . '</span></a></div></span>';
+ } else {
+ echo '<span class="floatRight" title="'.$lang['srv_save_run_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="timeProfileAction(\'run_profile\'); return false;"><span>'.$lang['srv_run_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_run_as_session_profile'] . '"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'run_session_profile\'); return false;"><span>'.$lang['srv_run_as_session_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_create_new_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'show_create\'); return false;"><span>'.$lang['srv_create_new_profile'] . '</span></a></div></span>';
+ echo '<span class="floatRight spaceRight" title="'.$lang['srv_close_profile'].'"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'cancel\'); return false;"><span>'.$lang['srv_close_profile'] . '</span></a></div></span>';
+
+ }
+ echo '</div>'; // time_profile_button_right_holder
+
+
+ // cover Div
+ echo '<div id="timeProfileCoverDiv"></div>';
+
+ // div za kreacijo novega
+ echo '<div id="newProfileDiv">'.$lang['srv_missing_profile_name'].': ';
+ echo '<input id="newProfileName" name="newProfileName" type="text" value="" size="50" />';
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="timeProfileAction(\'do_create\'); return false;"><span>'.$lang['srv_analiza_arhiviraj_save'].'</span></a></span></span>';
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'cancel_create\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
+ echo '</div>';
+
+ // div za preimenovanje
+ echo '<div id="renameProfileDiv">'.$lang['srv_missing_profile_name'].': ';
+ echo '<input id="renameProfileName" name="renameProfileName" type="text" value="' . $currentFilterProfile['name'] . '" size="50" />';
+ echo '<input id="renameProfileId" type="hidden" value="' . $currentFilterProfile['id'] . '" />';
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="timeProfileAction(\'do_rename\'); return false;"><span>'.$lang['srv_rename_profile_yes'].'</span></a></span></span>';
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'cancel_rename\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
+ echo '</div>';
+
+ // div za brisanje
+ echo '<div id="deleteProfileDiv">'.$lang['srv_missing_profile_delete_confirm'].': <b>' . $currentFilterProfile['name'] . '</b>?';
+ echo '<input id="deleteProfileId" type="hidden" value="' . $currentFilterProfile['id'] . '" />';
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="timeProfileAction(\'do_delete\'); return false;"><span>'.$lang['srv_delete_profile_yes'].'</span></a></span></span>';
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="timeProfileAction(\'cancel_delete\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
+ echo '</div>';
+ }
+
+ /** Funkcija prikaze osnovnih informacije profila
+ *
+ */
+ static function DisplayProfileData($current_pid) {
+ global $lang;
+ # podatki profila
+ $p_data = self::GetProfileData($current_pid);
+
+ #kateri nacin imamo ali type (od - do) ali inervalsko (zadnjih....)
+ # ce je podan string interval imamo intervalno
+ $type = $p_data['type'];
+ if ( $type == '0') {
+ $time = '';
+ } else {
+ $p_data['starts'] = date(STP_DATE_FORMAT,strtotime(SurveyInfo::getInstance()->getSurveyInsertDate()));
+ $p_data['ends'] = date(STP_DATE_FORMAT);
+ $time = $p_data['interval_txt'];
+ }
+
+ echo '<input type="radio" name="type" id="time_date_type" value="0" '.($type == '0' ? ' checked="checked"' : '').' autocomplete="off"><label> ' . $lang['srv_time_profile_from'] . ': </label>';
+ echo '<input id="startDate" type="text" name="startDate" value="' . $p_data['starts'] . '" onclick="changeTimeProfileType();" readonly="true" '.' autocomplete="off"/> ';
+ echo '<span class="faicon calendar_icon icon-as_link" id="starts_img"></span>';
+ echo '<label> ' . $lang['srv_time_profile_to'] . ': </label>';
+ echo '<input id="endDate" type="text" name="endDate" value="' . $p_data['ends'] . '" onclick="changeTimeProfileType();" readonly="true" '.'cautocomplete="off"/> ';
+ echo '<span class="faicon calendar_icon icon-as_link" id="expire_img"></span>' . "\n" ;
+ echo '<br />';
+ echo '<p><input type="radio" name="type" id="time_date_interval" value="1" '.($type == '0' ? '' : ' checked="checked"').' autocomplete="off">'.$lang['srv_statistic_period_label'].':';
+ echo '<select name="stat_interval" id="stat_interval" onclick="changeTimeProfileType(\'interval\');" '.'autocomplete="off">';
+ echo '<option value="" selected="true">'.$lang['srv_time_profile_choose_interval'].'</option>';
+ foreach (self::$STP_ARRAYS as $INTERVAL) {
+ echo '<option value="'.$INTERVAL.'"' . ($time == $INTERVAL ? ' selected' : '') . '>'.$lang['srv_diagnostics_'.$INTERVAL].'</option>';
+ }
+ echo '</select>';
+ echo '</p>';
+
+ echo '<script type="text/javascript">';
+ # za profil id=0 (privzet profil ne pustimo spreminjat
+ echo
+ ' Calendar.setup({' . "\n" .
+ ' inputField : "startDate",' . "\n" .
+ ' ifFormat : "'.STP_CALENDAR_DATE_FORMAT.'",' . "\n" .
+ ' button : "starts_img",' . "\n" .
+ ' singleClick : true,' . "\n" .
+ ' onUpdate : changeTimeProfileType' . "\n" .
+ ' });' . "\n" .
+ ' Calendar.setup({' . "\n" .
+ ' inputField : "endDate",' . "\n" .
+ ' ifFormat : "'.STP_CALENDAR_DATE_FORMAT.'",' . "\n" .
+ ' button : "expire_img",' . "\n" .
+ ' singleClick : true,' . "\n" .
+ ' onUpdate : changeTimeProfileType' . "\n" .
+ ' })';
+
+ echo '</script>';
+
+ }
+
+ public static function ajax() {
+ switch ($_GET['a']) {
+ case 'showProfile':
+ self::displayProfiles($_POST['pid']);
+ break;
+ case 'createProfile':
+ self::createNewProfile();
+ break;
+ case 'changeProfile':
+ self::ChooseProfile($_POST['pid']);
+ break;
+ case 'renameProfile':
+ self::RenameProfile($_POST['pid'], $_POST['name']);
+ break;
+ case 'deleteProfile':
+ self::DeleteProfile($_POST['pid']);
+ break;
+ case 'saveProfile':
+ self::SaveProfile($_POST['pid'],$_POST['type'],$_POST['startDate'],$_POST['endDate'],$_POST['stat_interval']);
+ break;
+ default:
+ print_r("<pre>");
+ print_r($_POST);
+ print_r($_GET);
+ break;
+ }
+ }
+
+ /** Kreira nov profil z datumom od začetka ankete do danes
+ *
+ */
+ public static function createNewProfile() {
+ global $lang;
+
+ if ($_POST['profileName'] == null || trim($_POST['profileName']) == '' ) {
+ $_POST['profileName'] = $lang['srv_new_profile'];
+ }
+
+ $type = '0';;
+ $stat_interval = '';
+
+ $startdate = date(STP_OUTPUT_DATE_FORMAT, strtotime(self::$start_date));
+ $enddate = date(STP_OUTPUT_DATE_FORMAT, strtotime(self::$end_date));
+
+ $iStr = "INSERT INTO srv_time_profile (id,uid,name,type,starts,ends,interval_txt)".
+ " VALUES (NULL, '".self::getGlobalUserId()."', '".$_POST['profileName']."', '".$type."', '".$startdate."', '".$enddate."', '".$stat_interval."')";
+
+ $ins = sisplet_query($iStr);
+ $id = mysqli_insert_id($GLOBALS['connect_db']);
+
+ if ($id > 0) {
+ self::ChooseProfile($id);
+ } else {
+ $id = 0;
+ self::ChooseProfile($id);
+ }
+
+ return $id;
+ }
+
+ /** Vrne filter v obliki stringa primernega za uporabo filtriranja z AWK
+ *
+ */
+ public static function getFilterForAWK ($sequenca = null) {
+ # če manjka sekvenca mamo napako in ne delamo filtra
+ if ($sequenca == null || $sequenca == '') {
+ return '';
+ }
+
+ $_profile = self::GetCurentProfileData();
+ #za privzet porfil id = 0 ne delamo časovnih omejitev
+ if ($_profile['id'] == '0') {
+ return '';
+ } else {
+ # odvisno od tipa profila pripravimo omejitve datuma
+ $set=false;
+
+ if ($_profile['type'] == '0') {
+ $result = '(';
+ $prefix = '';
+ # imamo range od - do
+ # spremenimo oba datuma v unixtime
+
+ $startUnixDate = date("U", strtotime($_profile['starts']));
+ $endUnixDate = date("U", strtotime($_profile['ends']));
+
+ if ((int)$startUnixDate > 0 ) {
+ $result .= '$'.$sequenca. ' > ' . $startUnixDate;
+ $prefix = ' && ';
+ $set=true;
+ }
+ if ((int)$endUnixDate > 0 ) {
+ # + 86 400 seconds = one day
+ $result .= $prefix. '$'.$sequenca. ' < ' . ($endUnixDate+ 86400) ;
+ $set=true;
+ }
+ $result .= ')';
+
+ } else {
+ #imamo interval zadnjih XXX dni
+
+ $date = date("Y-m-d");// current date
+ $unix_date = strtotime(date("Y-m-d", strtotime($date)) . " -".$_profile['interval_txt']);
+
+ if ((int)$unix_date > 0 && $_profile['interval_txt'] != null && $_profile['interval_txt'] =! '') {
+ $result = '($'.$sequenca. ' > ' . $unix_date.')';
+ $set=true;
+ }
+ }
+ if ($set == true) {
+ return $result;
+ }
+ }
+
+
+ }
+
+ /** Izpišemo opozorilo če ni privzet profil
+ *
+ */
+ static function printIsDefaultProfile() {
+ global $lang;
+ if (self::$currentProfileId != 0) {
+ $cp_data = self::GetCurentProfileData();
+ echo '<div id="timeProfileDafaultNote">';
+
+ # odvisno od tipa profila izpišemo ali obdobje ali interval
+ if ($cp_data['type'] == 0) {
+ # obdobje: od - do
+ echo $lang['srv_time_profile_filter_dates'];
+ echo date(STP_DATE_FORMAT, strtotime($cp_data['starts']));
+ echo $lang['srv_time_profile_filter_dates_2'];
+ echo date(STP_DATE_FORMAT, strtotime($cp_data['ends']));
+ } else {
+ # interval: zadnjih x dni
+ echo $lang['srv_time_profile_filter_period'];
+ echo ($lang['srv_diagnostics_'.$cp_data['interval_txt']]);
+ }
+
+ echo ' ';
+ echo '<span class="as_link" id="link_time_profile_edit">'.$lang['srv_profile_edit'].'</span>';
+ echo ' ';
+ echo '<span class="as_link" id="link_time_profile_remove">'.$lang['srv_profile_remove'].'</span>';
+ echo '</div>';
+ echo '<br class="clr"/>';
+
+ return true;
+
+ } else {
+ return false;
+ }
+ }
+
+ /** preveri obstoj profila in vrne enak id če obstaja, če ne vrne id privzetega profila
+ *
+ * @param unknown_type $pid
+ * @return unknown
+ */
+ function checkProfileExist($pid)
+ {
+ if (isset(self::$profiles[$pid]))
+ {
+ return true;
+ }
+ return false;
+ }
+}
+?>
\ No newline at end of file |