diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyExportProfiles.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyExportProfiles.php | 291 |
1 files changed, 291 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyExportProfiles.php b/admin/survey/classes/class.SurveyExportProfiles.php new file mode 100644 index 0000000..f34e7b0 --- /dev/null +++ b/admin/survey/classes/class.SurveyExportProfiles.php @@ -0,0 +1,291 @@ +<?php
+/**
+ * Created on 6.4.2010
+ *
+ * @author: Gorazd Veselič
+ *
+ * @desc: za shranjevanje in nalaganje profilov izvozov
+ *
+ * funkcije:
+ *
+ *
+ */
+session_start();
+class SurveyExportProfiles
+{
+ static private $instance; // instanca razreda (razred kreiramo samo enkrat)
+ static private $userId = null; // user id
+ static private $surveyId = null; // id ankete
+
+ static private $availableProfiles = array(); // array kamor shranimo vse doseglijive profile
+ static private $profilesData = array(); // array kamor shranimo podatke o trenutnem profilu
+
+ protected function __construct() {}
+
+ final private function __clone() {}
+
+ /** Poskrbimo za samo eno instanco razreda
+ *
+ */
+ static function getInstance()
+ {
+ if(!self::$instance)
+ {
+ self::$instance = new SurveyVariablesProfiles();
+ }
+ return self::$instance;
+ }
+
+ /** Inicializacija
+ *
+ */
+ static function Init($sid, $uid, $doRefresh=true) {
+ session_start();
+ self::setSurveyId($sid);
+ self::setUserId($uid);
+ self::checkBaseProfileExisit();
+ if ($doRefresh==true) {
+ //poiščemo vse dosegljive profile
+ self::refreshAvailableProfiles();
+ }
+ }
+
+
+ static function getSurveyId() { return self::$surveyId; }
+ static function setSurveyId($sid) { self::$surveyId = $sid; }
+ static function getUserId() { return self::$userId; }
+ static function setUserId($uid) { self::$userId = $uid; }
+
+ static function getAvailableProfiles() { return self::$availableProfiles; }
+
+ static function checkBaseProfileExisit() {
+ global $lang;
+
+ $selectCheckProfile = "SELECT id FROM srv_variable_profiles WHERE id='1' AND sid = '" . self::getSurveyId() . "' AND uid = '" . self::getUserId() . "'";
+ $sqlCheckProfile = sisplet_query($selectCheckProfile);
+
+ // če ne obstaja noben profil, kreiramo novega sistemskega - Vse spremenljivke.
+ if (!mysqli_num_rows($sqlCheckProfile)) {
+ $stringInsert = "INSERT INTO srv_variable_profiles (id, sid, uid, name, system) " .
+ "VALUES ('1', '" . self::getSurveyID() . "', '" . self::getUserID() . "','".$lang['srv_variable_profile_new_all']."', '1')";
+ sisplet_query($stringInsert) or die(mysqli_error($GLOBALS['connect_db']));
+ }
+
+ return 1;
+ }
+
+ static function refreshAvailableProfiles() {
+ // počistimo
+ self::$availableProfiles = array();
+ // dodamo profil iz seje če obstaja
+ $sid = self::getSurveyId();
+ if ( isset($_SESSION['variables_profile'][$sid])) {
+ self::$availableProfiles[0] = array( 'id' => $_SESSION['variables_profile'][$sid]['id'],
+ 'name' => $_SESSION['variables_profile'][$sid]['name'],
+ 'system'=> $_SESSION['variables_profile'][$sid]['system'],
+ 'variables'=> $_SESSION['variables_profile'][$sid]['variables']);
+ }
+
+ $selectSqlProfile = "SELECT * FROM srv_variable_profiles WHERE sid = '" . self::getSurveyId() . "' AND uid = '" . self::getUserId() . "' ORDER BY id";
+ $sqlProfileSetting = sisplet_query($selectSqlProfile);
+ while ($rowProfileSetting = mysqli_fetch_assoc($sqlProfileSetting)) {
+ self::$availableProfiles[$rowProfileSetting['id']] = $rowProfileSetting;
+ }
+ }
+
+
+ static function getProfileData($pid) {
+ // preverimo ali smo v razredu že lovili podatke za ta profil, potem jih preberemo čene jih osvežimo
+ if ( isset( self::$profilesData[$pid] ) ) {
+ return self::$profilesData[$pid];
+ } else {
+ $result = self::refreshProfileData($pid);
+ // rezultat si zapomnimo
+ self::$profilesData[$pid] = $result;
+ return self::$profilesData[$pid];
+ }
+ }
+
+
+ static function refreshProfileData($pid) {
+ // preberemo iz seje če obstaja zapis, čene preberemo privzet zapis (id=1)
+ if ($pid == 0) { // če je seja vrnemo sejo
+ // preberemo iz seje če obstaja zapis, čene preberemo privzet zapis (id=1)
+ if ( isset($_SESSION['variables_profile'][self::getSurveyId()]) ) {
+ return $_SESSION['variables_profile'][self::getSurveyId()];
+ } else
+ $pid = 1;
+ }
+
+ // polovimo podatke iz baze
+ // prvo polovimo nastavitve profila (id,name, system, variables)
+ $selectSqlProfile = "SELECT * FROM srv_variable_profiles WHERE id = '".$pid."' AND sid = '". self::getSurveyID()."' AND uid='". self::getUserID()."'";
+ $sqlProfileSetting = sisplet_query($selectSqlProfile);
+ $rowProfileSetting = mysqli_fetch_assoc($sqlProfileSetting);
+ $result = array( 'id' => $rowProfileSetting['id'],
+ 'name' => $rowProfileSetting['name'],
+ 'system' => $rowProfileSetting['system'],
+ 'variables'=> array());
+ // variable vrnemo kot array $key == $value;
+ foreach (explode(',',$rowProfileSetting['variables']) as $vriabla ){
+
+ if ($vriabla)
+ $result['variables'][$vriabla] = $vriabla;
+ }
+ // string iz baze za variables razbijemo v array
+ return $result;
+ }
+
+ static function getProfileVariables($pid) {
+
+ $_pd = self::getProfileData($pid);
+ return $_pd['variables'];
+ }
+ static function setProfileVariables($pid, $variables) {
+ if ($pid == 0) {
+ $sid = self::getSurveyId();
+ // nastavimo kot sejo
+ if ( !isset($_SESSION['variables_profile'][$sid]) ) {
+ global $lang;
+ //kreiramo začasin profil
+ $_SESSION['variables_profile'][$sid]['id'] = '0';
+ $_SESSION['variables_profile'][$sid]['name'] = $lang['srv_missing_profile_temp'];
+ $_SESSION['variables_profile'][$sid]['system'] = '0';
+ }
+ // počistimo stare vrednosti
+ $_SESSION['variables_profile'][$sid]['variables'] = array();
+ foreach (explode(',',$variables) as $vriabla ){
+ if ($vriabla)
+ $_SESSION['variables_profile'][$sid]['variables'][$vriabla] = $vriabla;
+ }
+ // dodoamo še v class
+ self::$availableProfiles[0] = array( 'id' => $_SESSION['variables_profile'][$sid]['id'],
+ 'name' => $_SESSION['variables_profile'][$sid]['name'],
+ 'system'=> $_SESSION['variables_profile'][$sid]['system'],
+ 'variables'=> $_SESSION['variables_profile'][$sid]['variables']);
+ } else {
+
+ $updateString = "UPDATE srv_variable_profiles SET variables = '" . $variables . "' WHERE id = '" . $pid . "' AND sid = '". self::getSurveyID()."' AND uid='". self::getUserID()."'";
+
+ $sqlupdate = sisplet_query($updateString) or die(mysqli_error($GLOBALS['connect_db']));
+ self::$availableProfiles[$pid]['variables'] = array();
+ foreach (explode(',',$variables) as $vriabla ){
+ if ($vriabla)
+ self::$availableProfiles[$pid]['variables'][$vriabla] = $vriabla;
+ }
+ }
+ }
+
+ function getAvailableVariables ($assArray = false) {
+ $variablesFilter = array ();
+ $sqlSpremenljivkeAnkete = sisplet_query("SELECT s.tip, s.naslov, s.variable, s.id, s.textfield, s.textfield_label FROM srv_grupa g, srv_spremenljivka s WHERE g.ank_id='".self::getSurveyID()."' AND g.id=s.gru_id ORDER BY g.vrstni_red ASC, s.vrstni_red ASC");
+ while ($rowSpremenljivkeAnkete = mysqli_fetch_assoc($sqlSpremenljivkeAnkete)) {
+ $value = $rowSpremenljivkeAnkete['id'];
+ $text = strip_tags("(" . $rowSpremenljivkeAnkete['variable'] . ") - " . $rowSpremenljivkeAnkete['naslov']);
+ if ($assArray)
+ $variablesFilter[] = $value;
+ else
+ $variablesFilter[] = array (
+ 'value' => $value,
+ 'text' => $text
+ );
+ }
+ return $variablesFilter;
+ }
+
+ static function checkDefaultProfile($dvp) {
+ // preverimo ali izbran privzet profil obstaja
+ if ($dvp == 0) { //preverimo sejo
+ if ( isset($_SESSION['variables_profile'][self::getSurveyId()]) ) {
+ return $_SESSION['variables_profile'][self::getSurveyId()]['id'];
+ } else { // morali bi imeti sejo pa je ni, zato nastavimo na privzetega (1)
+ $dvp = 1;
+ }
+ }
+
+ if ($dvp > 0 ) {
+ $stringSelect = "SELECT id FROM srv_variable_profiles WHERE id = '" . $dvp . "'";
+ $sqlSelect = sisplet_query($stringSelect);
+
+ if (mysqli_num_rows($sqlSelect) > 0) {// profil obstaja
+ $rowSelect = mysqli_fetch_assoc($sqlSelect);
+ return $rowSelect['id'];
+ }
+ }
+
+ // če ne izberemo osnovni profil
+ return self::checkBaseProfileExisit();
+ }
+
+ static function newProfileVariables($profileName=null, $data) {
+ global $global_user_id, $lang;
+ $profileId = -1;
+ $numrows = -1;
+
+ // ime profila preverima ali obstaja
+ if (!$profileName || $profileName == null || $profileName == "")
+ $profileName = $lang['srv_new_profile_name'];
+
+ do { // preverimo ali ime že obstaja
+ $selectSqlProfile = "SELECT * FROM srv_variable_profiles WHERE name = '" . $profileName . "' AND sid = '" . self::getSurveyID() . "' AND uid = '" . self::getUserID() . "'";
+ $sqlProfileSetting = sisplet_query($selectSqlProfile);
+ $numrows = mysqli_num_rows($sqlProfileSetting);
+ if ($numrows != 0) { // ime že obstaja zgeneriramo novo
+ srand(time());
+ $profileName .= rand(0, 9);
+ }
+ } while ($numrows != 0);
+
+ // poiščemo zadnji id
+ $selectProfileId = "SELECT max(id) as last_id FROM srv_variable_profiles WHERE sid = '" . self::getSurveyID() . "' AND uid = '" . self::getUserID() . "'";
+ $sqlProfileId = sisplet_query($selectProfileId);
+ $rowProfileId = mysqli_fetch_assoc($sqlProfileId);
+ $profileId = $rowProfileId['last_id']+1;
+ $stringInsert = "INSERT INTO srv_variable_profiles (id, sid, uid, name, system, variables) " .
+ "VALUES ('".$profileId."', '" . self::getSurveyID() . "', '" . self::getUserID() . "', '" . $profileName . "', '0', '".$data."')";
+ sisplet_query($stringInsert);
+ $insertId = mysqli_insert_id($GLOBALS['connect_db']);
+ if ($insertId > 1) {
+ $profileId = $insertId;
+ }
+ return $profileId;
+
+ }
+
+ function deleteVariableProfile($profileId) {
+ if ($profileId == 0 ) { // seja -
+ unset($_SESSION['variables_profile'][self::getSurveyId()]);
+ } else {
+ $deleteString = "DELETE FROM srv_variable_profiles WHERE id = '" . $profileId . "' AND `system` != '1'";
+ $sqlDelete = sisplet_query($deleteString);
+ }
+
+ return self::checkBaseProfileExisit();
+ }
+ function renameVariableProfile($profileId, $newProfileName) {
+ global $lang;
+ $sqlInsert = -1;
+ if ( $profileId != null && $profileId != "" && $profileId > 1) {
+ if ( $newProfileName == null || $newProfileName == "" ) {
+ $newProfileName = $lang['srv_new_profile_name'];
+ }
+
+ $numrows = -1;
+ do { // preverimo ali ime že obstaja
+ $selectSqlProfile = "SELECT * FROM srv_variable_profiles WHERE name = '" . $newProfileName . "' AND sid = '" . self::getSurveyID() . "' AND uid = '" . self::getUserID() . "'";
+ $sqlProfileSetting = sisplet_query($selectSqlProfile);
+
+ $numrows = mysqli_num_rows($sqlProfileSetting);
+ if ($numrows != 0) { // ime že obstaja zgeneriramo novo
+ srand(time());
+ $newProfileName .= rand(0, 9);
+ }
+ } while ($numrows != 0);
+
+ $updateString = "UPDATE srv_variable_profiles SET name = '" . $newProfileName . "' WHERE id = '" . $profileId . "'";
+ $sqlInsert = sisplet_query($updateString);
+ }
+ return $sqlInsert;
+ }
+}
+?>
|