diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyMissingProfiles.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyMissingProfiles.php | 643 |
1 files changed, 643 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyMissingProfiles.php b/admin/survey/classes/class.SurveyMissingProfiles.php new file mode 100644 index 0000000..d957a29 --- /dev/null +++ b/admin/survey/classes/class.SurveyMissingProfiles.php @@ -0,0 +1,643 @@ +<?php
+/** @author: Gorazd Veselič
+ *
+ * @Desc: za upravljanje z profili missingov za analize
+
+ * @Date: 28.09.2010
+ */
+
+session_start();
+define('SMP_DEFAULT_PROFILE', 1);
+
+class SurveyMissingProfiles
+{
+ static private $sid = null; # id ankete
+ static private $uid = null; # id userja
+ static private $inited = false; # ali so profili ze inicializirani
+ static private $currentProfileId = null; # trenutno profil
+ static private $profiles = array(); # seznam vseh profilov od uporabnika
+ static private $smv = null; # manjkajoče vrednosti
+
+
+ // lurker je mal poseben, ker je neodvisen od ostalih (user je npr. 6 in lurker)
+// static private $allStatus = array('null',0,1,2,3,4,5,6,'lurker'); // Statusi anket katere štejemo kot ustrezne
+// static private $appropriateStatus = array(6,5); // Statusi anket katere štejemo kot ustrezne
+// static private $unAppropriateStatus = array(4,3,2,1,0); // Statusi anket katere štejemo kot neustrezne
+// static private $unKnownStatus = array('null'); // Statusi anket katere štejemo kot neustrezne
+// # za awk komando
+// static private $_AWK_FILTER_TEXT = array(6=>'6',5=>'5',4=>'4',3=>'3',2=>'2',1=>'^1',0=>'0','null'=>'-1'); # texti za statuse. 6=>'6',5=>'5',4=>'4',3=>'3',2=>'2',1=>'^1',0=>'0',null=>'-1' Pri 1 je ^pomemben, če ne lahko vzame tudi -1
+
+ static function Init($sid, $uid = null) {
+ # nastavimo surveyId
+ self::setSId($sid);
+ self::$smv = new SurveyMissingValues($sid);
+ self::$smv -> Init();
+ # nastavimo userja
+ self::setGlobalUserId($uid);
+ SurveyUserSetting :: getInstance()->Init(self::$sid, self::getGlobalUserId());
+ if (self::$inited == false) {
+ self::$inited = self :: RefreshData();
+ }
+ }
+
+ static function RefreshData() {
+
+ self::$profiles = array();
+ # dodamo sejo če obstaja
+
+ if (isset($_SESSION['missingProfile'])) {
+ self::$profiles[$_SESSION['missingProfile']['id']] = $_SESSION['missingProfile'];
+ }
+ # dodamo sistemske profile, skreiramo jih "on the fly"
+ self :: addSystemProfiles();
+
+ # preberemo podatke vseh porfilov ki so na voljo in jih dodamo v array
+ $stringSelect = "SELECT * FROM srv_missing_profiles WHERE uid = '".self::getGlobalUserId()."' OR (uid = '0' AND `system` = 1) ORDER BY id";
+ $querySelect = sisplet_query($stringSelect);
+
+ if (mysqli_num_rows($querySelect)) {
+ while ( $rowSelect = mysqli_fetch_assoc($querySelect) ) {
+ self::$profiles[$rowSelect['id']] = $rowSelect;
+ }
+ }
+ # poiscemo privzet profil
+ self::$currentProfileId = SurveyUserSetting :: getInstance()->getSettings('default_missing_profile');
+
+ if (!self::$currentProfileId || self::$currentProfileId == 1)
+ self::$currentProfileId = 1;
+
+ # ce imamo nastavljen curent pid in profil z tem pid ne obstaja nastavomo na privzet profil
+ if (self::$currentProfileId != 1) {
+ if (!isset(self::$profiles[self::$currentProfileId])) {
+ self::$currentProfileId = 1;
+ self::setDefaultProfileId(self::$currentProfileId);
+ }
+ }
+
+ # ce ne obstajajo podatki za cpid damo error
+ if (!isset(self::$profiles[self::$currentProfileId])) {
+ die("Profile data is missing!");
+ return false;
+ } else {
+ return true;
+ }
+
+ }
+ static function DisplayProfile( $pid = null) {
+ global $lang;
+
+ echo '<h2>'.$lang['srv_missing_settings'].'</h2>';
+
+ echo '<div class="popup_close"><a href="#" onClick="missingProfileAction(\'cancle\'); return false;">✕</a></div>';
+
+ if ($pid == null ) {
+ $pid = self::$currentProfileId;
+ }
+
+ if ( self::$currentProfileId != SMP_DEFAULT_PROFILE ) {
+ echo '<div id="not_default_setting">';
+ echo $lang['srv_not_default_setting'];
+ echo '</div><br class="clr displayNone">';
+ }
+
+
+ echo ' <div id="missing_profile_holder">';
+ self :: DisplayProfileOptions($pid);
+ echo ' </div>';
+
+
+ echo ' <div id="missing_profile_data_holder">';
+ self :: DisplayProfileData($pid);
+ echo ' </div>';
+
+
+ // GUMBI
+ echo '<div style="margin: 15px 0 0 0; float:right;">';
+ # shrani kot seja
+ if (self::$profiles[$pid]['system'] == 1 || $pid == -1) {
+ $run_lbl = $lang['srv_run_as_session_profile'];
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="missingProfileAction(\'runSession\'); return false;"><span>'.$run_lbl.'</span></a></span></span>';
+ } else {
+ # shrani - pozeni
+ $run_lbl = $lang['srv_run_profile'];
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="missingProfileAction(\'run\'); return false;"><span>'.$run_lbl.'</span></a></span></span>';
+ }
+ # shrani kot nov profil
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="missingProfileAction(\'newName\'); return false;"><span>'.$lang['srv_create_new_profile'].'</span></a></span></span>';
+ # preklici - zapri
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="missingProfileAction(\'cancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>';
+ echo '</div>';
+
+
+ // cover Div
+ echo '<div id="missingProfileCoverDiv"></div>'."\n";
+
+ // div za shranjevanje novega profila
+ echo '<div id="newProfile">'.$lang['srv_missing_profile_name'].': '."\n";
+ echo '<input id="newProfileName" name="newProfileName" type="text" size="45" />'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="missingProfileAction(\'newSave\'); return false;"><span>'.$lang['srv_save_profile'].'</span></a></span></span>'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="missingProfileAction(\'newCancle\');; return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>'."\n";
+ echo '</div>'."\n";
+
+ // div za preimenovanje
+ echo '<div id="renameProfileDiv">'.$lang['srv_missing_profile_name'].': '."\n";
+ echo '<input id="renameProfileName" name="renameProfileName" type="text" value="' . self::$profiles[$pid]['name'] . '" size="45" />'."\n";
+ echo '<input id="renameProfileId" type="hidden" value="' . $pid . '" />'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="missingProfileAction(\'rename\'); return false;"><span>'.$lang['srv_rename_profile_yes'].'</span></a></span></span>'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="missingProfileAction(\'renameCancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>'."\n";
+ echo '</div>'."\n";
+
+ // div za brisanje
+ echo '<div id="deleteProfileDiv">'.$lang['srv_missing_profile_delete_confirm'].': <b>' . self::$profiles[$pid]['name'] . '</b>?'."\n";
+ echo '<input id="deleteProfileId" type="hidden" value="' . $pid . '" />'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_gray" href="#" onclick="missingProfileAction(\'deleteCancle\'); return false;"><span>'.$lang['srv_close_profile'].'</span></a></span></span>'."\n";
+ echo '<span class="floatRight spaceLeft" ><span class="buttonwrapper"><a class="ovalbutton ovalbutton_orange" href="#" onclick="missingProfileAction(\'deleteConfirm\'); return false;"><span>'.$lang['srv_delete_profile_yes'].'</span></a></span></span>'."\n";
+ echo '</div>'."\n";
+
+
+ }
+
+ static function DisplayProfileData($pid) {
+ global $lang;
+ $curentProfileData = self :: getProfileValues($pid);
+
+ $_tpes_array = array(MISSING_TYPE_DESCRIPTOR=>$lang['srv_analiza_arhiviraj_type_'.MISSING_TYPE_DESCRIPTOR],MISSING_TYPE_FREQUENCY=>$lang['srv_analiza_arhiviraj_type_'.MISSING_TYPE_FREQUENCY],MISSING_TYPE_CROSSTAB=>$lang['srv_analiza_arhiviraj_type_'.MISSING_TYPE_CROSSTAB]);
+ $_sys_missings = self::$smv->GetMissingValuesForSurvey();
+ $_sys_unset = self::$smv->GetUnsetValuesForSurvey();
+ echo '<div id="infoMissingProfile">' . $lang['srv_missing_profile_title1'] . '</div >';
+ echo '<div id="missingProfileFieldsetHolder1">'.NEW_LINE;
+
+ echo '<fieldset id="missingProfileFieldset">'.NEW_LINE;
+ echo '<legend>' . $lang['srv_missing_profile_title2'] . '</legend>'.NEW_LINE;
+ foreach ($_tpes_array AS $tkey => $tlabel) {
+ echo '<div style="float:left; width:100px; text-align:center;">'. $tlabel .'</div>'.NEW_LINE;
+ }
+ echo '<div class="clr"></div>'.NEW_LINE;
+ echo '<form name="" id="" autocomplete="off">'.NEW_LINE;
+ # loop sozi sistemske missinge
+ foreach ($_sys_unset as $mkey => $mvalue) {
+ # loop skozi tipe
+ foreach ($_tpes_array AS $tkey => $tlabel) {
+ echo '<div style="float:left; width:100px; text-align:center;">'.NEW_LINE;
+ echo '<input name="profile_value[]" type="checkbox" id="mv_'.$tkey.'_'.$mkey . '"' .
+ (isset($curentProfileData[$tkey][$mkey]) ? ' checked' : '').
+ '/>'.NEW_LINE;
+ echo '</div>'.NEW_LINE;
+ }
+ echo '<div style="float:left; width:150px;">'.NEW_LINE;
+ echo '(' . $mkey . ") " . $mvalue;
+ echo '</div>'.NEW_LINE;
+ echo '<div class="clr"></div>'.NEW_LINE;
+ }
+ echo '</form>'.NEW_LINE;
+ echo '</fieldset>'.NEW_LINE;
+
+ echo '<fieldset id="missingProfileFieldset">'.NEW_LINE;
+ echo '<legend>' . $lang['srv_missing_profile_title3'] . '</legend>'.NEW_LINE;
+ foreach ($_tpes_array AS $tkey => $tlabel) {
+ echo '<div style="float:left; width:100px; text-align:center;">'. $tlabel .'</div>'.NEW_LINE;
+ }
+ echo '<div class="clr"></div>'.NEW_LINE;
+ echo '<form name="" id="" autocomplete="off">'.NEW_LINE;
+ # loop sozi sistemske missinge
+ foreach ($_sys_missings as $mkey => $mvalue) {
+ # loop skozi tipe
+ foreach ($_tpes_array AS $tkey => $tlabel) {
+ echo '<div style="float:left; width:100px; text-align:center;">'.NEW_LINE;
+ echo '<input name="profile_value[]" type="checkbox" id="mv_'.$tkey.'_'.$mkey . '"' .
+ (isset($curentProfileData[$tkey][$mkey]) ? ' checked' : '').
+ '/>'.NEW_LINE;
+ echo '</div>'.NEW_LINE;
+ }
+ echo '<div style="float:left; width:150px;">'.NEW_LINE;
+ echo '(' . $mkey . ") " . $mvalue;
+ echo '</div>'.NEW_LINE;
+ echo '<div class="clr"></div>'.NEW_LINE;
+ }
+ echo '</form>'.NEW_LINE;
+ echo '</fieldset>'.NEW_LINE;
+ echo '</div>'.NEW_LINE;
+
+ echo '<div id="missingProfileFieldsetHolder1">'.NEW_LINE;
+ echo '<fieldset id="missingProfileFieldset">';
+ echo '<legend>'.$lang['srv_missing_profile_title5'].'</legend>';
+ # prikažemo še radio gumbe za način prikaza MV
+
+ $radio_selected = self::$profiles[$pid]['display_mv_type'];
+ echo '<div style="margin-bottom:8px;">';
+ echo '<input name="display_mv_type" id="display_mv_type_0" type="radio" value="0"'.($radio_selected == 0 ? ' checked' : '').'><label for="display_mv_type_0">'.$lang['srv_missing_profile_display_radio0'].'</label>';
+ echo ' <input name="display_mv_type" id="display_mv_type_1" type="radio" value="1"'.($radio_selected == 1 ? ' checked' : '').'><label for="display_mv_type_1">'.$lang['srv_missing_profile_display_radio1'].'</label>';
+ echo ' <input name="display_mv_type" id="display_mv_type_2" type="radio" value="2"'.($radio_selected == 2 ? ' checked' : '').'><label for="display_mv_type_2">'.$lang['srv_missing_profile_display_radio2'].'</label>';
+ echo '</div>';
+ echo '<div style=" width:auto; text-align:left;">'.NEW_LINE;
+ echo '<input name="show_zerro" id="show_zerro" type="checkbox" ' .
+ (self::$profiles[$pid]['show_zerro'] == 1 ? ' checked="checked"' : '') . ' autocomplete="off"/>'.NEW_LINE;
+ echo $lang['srv_missing_profile_other_show_zerro'];
+ echo '</div>'.NEW_LINE;
+ echo '<div style=" width:auto; text-align:left;">'.NEW_LINE;
+ echo '<input name="merge_missing" id="merge_missing" type="checkbox" ' .
+ (self::$profiles[$pid]['merge_missing'] == 1 ? ' checked="checked"' : '') . ' autocomplete="off"/>'.NEW_LINE;
+ echo $lang['srv_missing_profile_other_merge_missing'];
+ echo '</div>';
+ echo ' <div class="clr"></div>';
+ echo '</fieldset>';
+ echo '</div>'.NEW_LINE;
+ }
+
+ static function DisplayProfileOptions($pid) {
+ global $lang;
+
+ echo '<div id="missing_profile" class="select">';
+ foreach ( self::$profiles as $key => $profile ) {
+
+ echo '<div id="missing_profile_'.$profile['id'].'" class="option' . ($profile['id'] == $pid ? ' active' : '') . '" value="' . $profile['id'] . '">';
+
+ echo $profile['name'];
+
+ if($profile['id'] == $pid){
+ if (self::$profiles[$pid]['system'] != 1 ) {
+ echo '<a href="#" title="'.$lang['srv_delete_profile'].'" onclick="missingProfileAction(\'deleteAsk\'); return false;"><span class="faicon delete_circle icon-orange_link floatRight" style="margin-top:1px;"></span></a>'."\n";
+ }
+ if (self::$profiles[$pid]['system'] != 1 && $pid != -1) {
+ echo '<a href="#" title="'.$lang['srv_rename_profile'].'" onclick="missingProfileAction(\'renameAsk\'); return false;"><span class="faicon edit floatRight spaceRight"></span></a>'."\n";
+ }
+ }
+
+ echo '</div>';
+ }
+ echo '</div>';
+
+ echo '<script>';
+ echo '$(function() {';
+ echo 'scrollToProfile("#missing_profile_'.$pid.'");';
+ echo '});';
+ echo '</script>';
+
+ }
+
+ /** klici ajax funkcij
+ *
+ */
+ static function ajax() {
+
+ $pid = $_POST['pid'];
+ switch ($_GET['a']) {
+ case 'change_profile' :
+ self :: setDefaultProfileId($pid);
+ break;
+
+ break;
+ case 'show_profile' :
+ self :: DisplayProfile($pid);
+ break;
+ case 'run_profile' :
+ self :: SaveProfile($pid);
+ self :: setDefaultProfileId($pid);
+ break;
+ case 'delete_profile':
+ self :: DeleteProfile($pid);
+ self :: setDefaultProfileId(1);
+ break;
+ case 'save_profile':
+ $new_id = self :: saveNewProfile();
+ self :: setDefaultProfileId($new_id);
+ echo $new_id;
+ break;
+ case 'rename_profile':
+ $_rename = self :: RenameProfile($pid);
+ echo $_rename;
+ break;
+
+ default:
+ echo 'ERROR! Missing function for action: '.$_GET['a'].'!';
+ break;
+ }
+ }
+
+ /** getProfiles
+ *
+ */
+ static function getProfiles() {
+ return self::$profiles;
+ }
+
+ static public function getProfile($pid) {
+ return self::$profiles[$pid];
+ }
+
+ /** setSurveyId
+ *
+ */
+ static function setSId($surveyId) {
+ self::$sid = $surveyId;
+ }
+
+ /** setGlobalUserId
+ *
+ */
+ static function setGlobalUserId($uid = null) {
+ if ($uid == null) {
+ global $global_user_id;
+ self::$uid = $global_user_id;
+ } else {
+ self::$uid = $uid;
+ }
+ }
+
+ /** getGlobalUserId
+ *
+ */
+ static function getGlobalUserId() {
+ return self::$uid;
+ }
+ static function getCurentProfileId() {
+ return self::$currentProfileId;
+ }
+ /**
+ *
+ * @param unknown_type $pid
+ */
+ static function setCurentProfileId($pid) {
+ # ce je seja, preverimo ali obstaja cene nardimo privzetega 1
+ if ($pid == -1) {
+ if (!(isset($_SESSION['missingProfile']['-1'])))
+ $pid = 1;
+ } else if (!$pid) {
+ $pid = 1;
+ }
+
+ return self::$currentProfileId = $pid;
+ }
+
+ static function setDefaultProfileId($pid) {
+ # ce je seja, preverimo ali obstaja cene nardimo privzetega 1
+ if ($pid == -1) {
+ if (!(isset($_SESSION['missingProfile']))) {
+ $pid = 1;
+ }
+ } else if (!$pid) {
+ $pid = 1;
+ }
+
+ SurveyUserSetting :: getInstance()->saveSettings('default_missing_profile', $pid);
+ self::$currentProfileId = $pid;
+ return true;
+ }
+
+ static function SaveProfile($pid) {
+ global $lang;
+ $insert_id = 0;
+ $missing_values = $_POST['missing_values'];
+ $display_mv_type = isset($_POST['display_mv_type']) ? $_POST['display_mv_type'] : 0;
+
+ if (isset($pid) && $pid != null) {
+ # ce mamo sistemski profil ga ne shranjujemo
+ $checkSelect = "SELECT * as cnt FROM srv_missing_profiles WHERE id = '".$pid."' and `system` = 1";
+ $checkQry = sisplet_query($checkSelect);
+ if (mysqli_num_rows($checkQry) > 0) {
+ return $pid;
+ }
+
+ $show_zerro = (isset($_POST['show_zerro']) && $_POST['show_zerro'] == 'true') ? 1 : 0;
+ $merge_missing = (isset($_POST['merge_missing']) && $_POST['merge_missing'] == 'true') ? 1 : 0;
+
+ # ce imamo session pozenemo kot sejo
+ if ($pid == -1) {
+ $missing_values = explode(',',$missing_values);
+ $_SESSION['missingProfile'] = array('id'=>'-1','uid'=>0,'name'=>$lang['srv_temp_profile'],'system'=>0, 'display_mv_type'=>$display_mv_type, 'show_zerro'=>$show_zerro, 'merge_missing'=>$merge_missing);
+ # pobrišemo predhodne nastavitve
+ unset($_SESSION['missingProfile']['values']);
+ if (count($missing_values) > 0) {
+ foreach ($missing_values as $_missing_value) {
+ $_missing_value = substr($_missing_value,3);
+ list($type,$key) = explode('_',$_missing_value);
+ $_SESSION['missingProfile']['values'][$type][$key] = true;
+ }
+ }
+ return -1;
+ }
+ # imamo podatke, updejtamo profil v bazi (profili z id 1,2,3 so sitemski)
+ if ($pid > 3) {
+ # shranimo morebitno spremembo nastavitve display_mv_type
+ $updateString = "UPDATE srv_missing_profiles SET display_mv_type='".$display_mv_type."', show_zerro='".$show_zerro."', merge_missing='".$merge_missing."' WHERE id='".$pid."' AND `system` = 0";
+ $updatequery = sisplet_query($updateString);
+
+ # najprej pobrišemo stare podatke za ta profil
+ $stringDelete = "DELETE FROM srv_missing_profiles_values WHERE missing_pid ='".$pid."'";
+ $deleteQuery = sisplet_query($stringDelete);
+
+ # shranimo nove vrednosti
+ $missing_values = explode(',',$missing_values);
+ if (count($missing_values ) > 0) {
+ $insertString = "INSERT INTO srv_missing_profiles_values (missing_pid, missing_value, type) VALUES";
+ $prefix = '';
+
+ foreach ($missing_values as $_missing_value) {
+ $_missing_value = substr($_missing_value,3);
+ list($type,$key) = explode('_',$_missing_value);
+ $insertString .= $prefix . " (".$pid.", ".$key.", ".$type.")";
+ $prefix = ',';
+ }
+ $queryInsert = sisplet_query($insertString)
+ or die(mysqli_error($GLOBALS['connect_db']));
+ }
+ }
+ return $pid;
+ }
+
+ }
+
+ static function saveNewProfile() {
+
+ $name = $_POST['name'];
+ $missing_values = $_POST['missing_values'];
+ $display_mv_type = isset($_POST['display_mv_type']) ? $_POST['display_mv_type'] : 0;
+
+ $insert_id = 0;
+ if (isset($name) && $name != null ) {
+ # imamo podatke, vstavimo nov profil v bazo
+ $show_zerro = (isset($_POST['show_zerro']) && $_POST['show_zerro'] == 'true') ? 1 : 0;
+ $merge_missing = (isset($_POST['merge_missing']) && $_POST['merge_missing'] == 'true') ? 1 : 0;
+
+ $insertString = "INSERT INTO srv_missing_profiles (uid,name,system,display_mv_type,show_zerro,merge_missing) VALUES ('".self::getGlobalUserId()."', '".$name."', 0, '".$display_mv_type."', '".$show_zerro."', '".$merge_missing."')";
+ $queryInsert = sisplet_query($insertString);
+ $insert_id = mysqli_insert_id($GLOBALS['connect_db']);
+ if ($insert_id > 0) {
+ # če je insert id <= 3 ga popravimo da je večji od 3.
+ if ($insert_id <= 3) {
+ $selectId = "SELECT max(id) FROM srv_missing_profiles";
+ list($maxInseredId) = mysqli_fetch_row(sisplet_query($selectId));
+ $newInsert_id = max(4,$maxInseredId);
+ $updateString = "UPDATE srv_missing_profiles SET id='".$newInsert_id."' WHERE id='".$insert_id."'";
+ $updatequery = sisplet_query($updateString);
+ $insert_id = $newInsert_id;
+ }
+
+ self::$profiles[$insert_id] = array('id'=>$insert_id,'uid'=>self::getGlobalUserId(),'name'=>$name,'system'=>0);
+
+ # shranimo nove vrednosti
+ $missing_values = explode(',',$missing_values);
+ if (count($missing_values ) > 0) {
+ $insertString = "INSERT INTO srv_missing_profiles_values (missing_pid, missing_value, type) VALUES";
+ $prefix = '';
+
+ foreach ($missing_values as $_missing_value) {
+ $_missing_value = substr($_missing_value,3);
+ list($type,$key) = explode('_',$_missing_value);
+ $insertString .= $prefix . " (".$insert_id.", ".$key.", ".$type.")";
+ $prefix = ',';
+ }
+ $queryInsert = sisplet_query($insertString);
+ }
+
+ } else {
+
+ }
+ }
+ return $insert_id;
+ }
+
+ static function RenameProfile($pid) {
+ $name = $_POST['name'];
+ if (isset($pid) && $pid != null && isset($name) && $name != null ) {
+ $updateString = "UPDATE srv_missing_profiles SET name = '".$name."' WHERE id = ".$pid;
+ $updated = sisplet_query($updateString);
+ if ($updated) {
+ return 0;
+ } else {
+ return mysqli_error($GLOBALS['connect_db']);
+ }
+ } else {
+ if (!isset($pid) || $pid == null || trim($pid) == '') {
+ return 'Invalid profile Id';
+ } else if (!isset($name) || $name == null || trim($name) == '') {
+ return 'Invalid profile name';
+ } else {
+ return 'Error!';
+ }
+ }
+
+ }
+
+ static function DeleteProfile($pid) {
+ if ($pid == -1) {
+ unset($_SESSION['missingProfile']);
+ }
+ # izbrišemo lahko samo nesistemske profile
+ if (self::$profiles[$pid]['system'] != 1) {
+ # zaradi ključev se avtomatsko pobriše tudi: srv_missing_profiles_values
+ $sqlDelete = sisplet_query("DELETE FROM srv_missing_profiles WHERE id = '$pid' AND `system` != '1'");
+ }
+ }
+
+ static function DisplayLink($hideAdvanced = true) {
+ global $lang;
+ // profili missingov
+ $missingProfiles = self :: getProfiles();
+ $izbranMissingProfile = self :: getCurentProfileId();
+
+ $css = ($izbranMissingProfile == SMP_DEFAULT_PROFILE ? ' gray' : '');
+ if ($hideAdvanced == false || $izbranMissingProfile != SMP_DEFAULT_PROFILE ) {
+ echo '<li class="space"> </li>';
+ echo '<li>';
+ echo '<span class="as_link'.$css.'" id="link_missing_profile" title="' . $lang['srv_analiza_setup_profile'] . '" onClick="show_missing_profiles();">' . $lang['srv_analiza_setup_profile'] . '</span>'."\n";
+ echo '</li>';
+
+ }
+ }
+
+ /** Ustvarimo tri sistemske profile ustvarimo jih navidezno
+ *
+ * Brez manjkajočih vrednosti - ne prikazuje manjkajočih vrednosti (display_mv_type = 0)
+ * Skupaj MV - prikaže samo skupaj manjkajoče vrednosti (display_mv_type = 1)
+ * Podrobno MV - prikaže razširjeno manjkajoče vrednosti (display_mv_type = 2)
+ */
+ static function addSystemProfiles() {
+ global $lang;
+
+ # skreiramo 3 sistemske manjkajoče profile
+ for ( $i = 1; $i <= 3; $i++ ) {
+ self::$profiles[$i] = array('id'=>$i,'uid'=>self::getGlobalUserId(),'name'=>$lang['srv_missing_profiles_profile'.$i.'_lbl'],'system'=>1, 'display_mv_type'=>(int)$i-1);
+ }
+ }
+
+ /** Vrenmo podatke o izbranem profilu v obliki arraya
+ *
+ * @param unknown_type $pid
+ */
+ static function getProfileValues($pid) {
+ $result = array();
+
+ if ($pid == -1) {
+ # beremo iz seje
+ if (isset($_SESSION['missingProfile'])) {
+ $result = $_SESSION['missingProfile']['values'];
+ return $result;
+ } else {
+ $pid = 1;
+ }
+ }
+ # če je sistemski profil preberemo iz avtomatsko skreiranih
+ if ( ($pid < 3 && $pid >= 0) || (isset(self::$profiles[$pid]) && self::$profiles[$pid]['system'] == 1)) {
+ # imamo sistemski profil, preberemo podatke ki so bili skreirani "on the fly"
+ #najprej poiščemo sistemske missinge
+ $_sys_missings = self::$smv->GetMissingValuesForSurvey();
+ $_sys_unset = self::$smv->GetUnsetValuesForSurvey(array(2,3));
+
+ # sistemske missinge (-1,-2,-3,-4) dodamo k vsem profilom
+ if (count($_sys_missings) > 0) {
+ foreach($_sys_missings AS $key => $value) {
+ $result[MISSING_TYPE_DESCRIPTOR][$key] = true;
+ $result[MISSING_TYPE_FREQUENCY][$key] = true;
+ $result[MISSING_TYPE_CROSSTAB][$key] = true;
+ }
+
+ }
+ # neopredeljene vrednosti (-99,-98,-97) dodamo samo k opisnim in krostabulacijam
+ if (count($_sys_unset) > 0) {
+ foreach($_sys_unset AS $key => $value) {
+ $result[MISSING_TYPE_DESCRIPTOR][$key] = true;
+ $result[MISSING_TYPE_CROSSTAB][$key] = true;
+ }
+
+ }
+ } else {
+ $selectString = "SELECT missing_value, type FROM srv_missing_profiles_values WHERE missing_pid = '".$pid."'";
+ $querySelect = sisplet_query($selectString);
+ if (mysqli_num_rows($querySelect)) {
+ while ( $rowSelect = mysqli_fetch_assoc($querySelect) ) {
+ $result[$rowSelect['type']][$rowSelect['missing_value']] = true;
+ }
+ }
+ }
+
+ return $result;
+ }
+
+ /*
+ * type = 1 => opisne
+ * type = 2 => frekvence
+ */
+ static function GetMissingValuesForAnalysis($type,$pid=null) {
+ $result = array();
+
+ #poiščemo sistemske missinge, z labele
+
+ $_survey_missings = self::$smv->GetMissingValuesForSurvey(array(1,2,3));
+
+ if ($pid == null)
+ {
+ $pid = self::$currentProfileId;
+ }
+ $curentProfileData = self :: getProfileValues($pid);
+ if (count($curentProfileData[$type]) > 0) {
+ foreach ($curentProfileData[$type] AS $key => $is_set) {
+ $result[$key] = isset($_survey_missings[$key]) ? $_survey_missings[$key] : $key;
+ }
+ }
+ return $result;
+
+ }
+}
+
+?>
|