diff options
Diffstat (limited to 'admin/survey/classes/class.RecodeValues.php')
| -rw-r--r-- | admin/survey/classes/class.RecodeValues.php | 971 |
1 files changed, 971 insertions, 0 deletions
diff --git a/admin/survey/classes/class.RecodeValues.php b/admin/survey/classes/class.RecodeValues.php new file mode 100644 index 0000000..eef65b0 --- /dev/null +++ b/admin/survey/classes/class.RecodeValues.php @@ -0,0 +1,971 @@ +<?php
+
+class RecodeValues {
+ private static $anketa = null; # trenutna anketa
+ private static $spremenljivka = null; # trenutna spremenljivka
+ private static $db_table = ''; # aktivnost
+ private static $sprInfo = null; # podatki o trenutni spremenljivki
+ private static $cacheSpremenljivka = null; # zakeširani podatki spremenljivke
+ private static $smv = null; # manjkajoe vrednosti ankete
+ private static $options = null; # možne izbire manjkajočih vrednosti
+ private static $variables = null; # Variable vprašanja
+ private static $_operators = array( # operatorji
+ '0'=>'==', # ==
+ '1'=>'≠', # ≠
+ '2'=>'<', # <
+ '3'=>'>', # >
+ '4'=>'<=', # <=
+ '5'=>'>=', # >=
+ '6'=>'interval' # interval
+ );
+
+ /**
+ * konstruktor
+ *
+ * @param mixed $anketa
+ */
+
+ function __construct ($anketa = 0, $spremenljivka = 0) {
+ if ((int)$anketa > 0 && (int)$spremenljivka > 0) {
+ self::$anketa = $anketa;
+ self::$spremenljivka = $spremenljivka;
+
+ SurveyInfo::getInstance()->SurveyInit($anketa);
+ if (SurveyInfo::getInstance()->getSurveyColumn('db_table') == 1)
+ self::$db_table = '_active';
+
+ # polovimo manjkajoče privzete vrednosti ankete
+ self::$smv = new SurveyMissingValues(self::$anketa);
+ self::$smv -> Init();
+
+ self::$cacheSpremenljivka = Cache::srv_spremenljivka(self::$spremenljivka);
+ }
+ }
+
+ public static function DisplayMissingValuesForQuestion($displayForm=true) {
+ global $lang;
+
+ echo '<form name="spremenljivka_recode" method="post">';
+ echo '<div id="recodeToNewSpr">';
+ self::displayRecodeType();
+ echo '</div>';
+ echo '</form>';
+ }
+
+
+ /** Naloži manjkajoče vrednosti za spremenljivko
+ *
+ *
+ * Enter description here ...
+ */
+ private static function LoadSpremenljivkaMissingValues($spremenljivka=null) {
+ global $lang;
+ if ($spremenljivka == null) {
+ $spremenljivka = self::$spremenljivka;
+ }
+
+ $cacheSpremenljivka = Cache::srv_spremenljivka($spremenljivka);
+
+ self::$options = array();
+ self::$variables = array();
+ if ((int)$spremenljivka > 0) {
+ self::$options['_0_'] = array('naslov'=>$lang['srv_recode_type0'], 'variable'=>null, 'type'=>0);
+ switch ($cacheSpremenljivka['tip']) {
+ case 1: # radio
+ case 3: # select
+ $sql1 = sisplet_query("SELECT id, naslov, variable FROM srv_vrednost WHERE spr_id = '".$spremenljivka."' ORDER BY vrstni_red ASC");
+ if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+ if (mysqli_num_rows($sql1)) {
+
+ while ($row1 = mysqli_fetch_assoc($sql1)) {
+ self::$variables[$row1['id']] = array('naslov'=>$row1['naslov'], 'variable'=>$row1['variable']);
+ self::$options[$row1['id']] = array('naslov'=>$row1['naslov'], 'variable'=>$row1['variable'], 'type'=>0);
+ }
+ }
+ break;
+ case 17: # razvrščanje
+ $sql1 = sisplet_query("SELECT id, naslov, vrstni_red FROM srv_vrednost WHERE spr_id = '".$spremenljivka."' ORDER BY vrstni_red ASC");
+ if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+ if (mysqli_num_rows($sql1)) {
+ while ($row1 = mysqli_fetch_assoc($sql1)) {
+ self::$variables[$row1['id']] = array('naslov'=>$row1['naslov'], 'variable'=>$row1['vrstni_red']);
+ self::$options[$row1['id']] = array('naslov'=>$row1['naslov'], 'variable'=>$row1['vrstni_red'], 'type'=>0);
+ }
+ }
+ break;
+ case 2: # checkbox
+ self::$variables['1'] = array('naslov'=>'izbran', 'variable'=>'1');
+ self::$variables['0'] = array('naslov'=>'neizbran', 'variable'=>'0');
+ self::$options['1'] = array('naslov'=>'izbran', 'variable'=>'1', 'type'=>0);
+ self::$options['0'] = array('naslov'=>'neizbran', 'variable'=>'0', 'type'=>0);
+ break;
+ case 6: # multiradio
+ case 19: # multitext
+ case 20: # multinumber
+ $sql1 = sisplet_query("SELECT naslov, variable FROM srv_grid WHERE spr_id='".$spremenljivka."' ORDER BY vrstni_red ASC");
+ if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+ if (mysqli_num_rows($sql1)) {
+ while ($row1 = mysqli_fetch_assoc($sql1)) {
+ self::$variables[$row1['variable']] = array('naslov'=>$row1['naslov'], 'variable'=>$row1['variable']);
+ self::$options[$row1['variable']] = array('naslov'=>$row1['naslov'], 'variable'=>$row1['variable']);
+ }
+ }
+ break;
+ case 16: # multicheckbox
+ self::$variables['0'] = array('naslov'=>'izbran', 'variable'=>'0');
+ self::$variables['1'] = array('naslov'=>'neizbran', 'variable'=>'1');
+ self::$options['0'] = array('naslov'=>'izbran', 'variable'=>'0', 'type'=>0);
+ self::$options['1'] = array('naslov'=>'neizbran', 'variable'=>'1', 'type'=>0);
+ break;
+ }
+ }
+ # dodamo manjkajoče vrednosti če še niso
+ # preberemo možne manjkajoče vrednosti
+ $smvs = self::$smv-> GetSystemFlterByType(array(1));
+ # zgeneriramo matriko izbranih manjkajočih vrednosti za anketo (anketne oz. sistemske mv)
+ self::$options['_1_'] = array('naslov'=>$lang['srv_recode_type1'], 'variable'=>null, 'type'=>0);
+ if (count($smvs)> 0) {
+ foreach ($smvs AS $key => $value) {
+ self::$options[$key] = array('naslov'=>$value, 'variable'=>$key, 'type'=>1);
+ }
+ }
+ $smvs = self::$smv-> GetSystemFlterByType(array(2,3));
+ # zgeneriramo matriko izbranih manjkajočih vrednosti za anketo (anketne oz. sistemske mv)
+ self::$options['_2_'] = array('naslov'=>$lang['srv_recode_type2'], 'variable'=>null, 'type'=>0);
+ if (count($smvs)> 0) {
+ foreach ($smvs AS $key => $value) {
+ self::$options[$key] = array('naslov'=>$value, 'variable'=>$key, 'type'=>2);
+ }
+ }
+ }
+
+ private static function show_new_mv_div() {
+ echo '<div id="vprasanje_recode_new">';
+ self::show_new_mv();
+ echo '</div>';
+ }
+
+ private static function show_new_mv() {
+ global $lang;
+
+ echo 'Izberi vrednost:';
+ echo '<input id="new_mv_value" type="text" size="5" autocomplete="off">';
+
+ echo '<br/>';
+ echo self::$spremenljivka;
+ echo '<br/>';
+
+ echo '<span class="buttonwrapper spaceRight floatRight">';
+ echo '<a class="ovalbutton ovalbutton_orange" href="/" onclick="new_mv_add(\''.self::$spremenljivka.'\'); return false;"><span>'.$lang['add'].'</span></a>';
+ echo '</span>';
+
+ echo '<span class="buttonwrapper spaceRight floatRight">';
+ echo '<a class="ovalbutton ovalbutton_gray" href="/" onclick="show_new_mv_cancel(); return false;"><span>'.$lang['srv_cancel'].'</span></a>';
+ echo '</span>';
+ }
+
+ private static function new_mv_add() {
+ echo 'Napaka!!!';
+ self::show_new_mv();
+ }
+
+ public static function Ajax() {
+ switch ($_GET['a']) {
+ case 'show_new_mv':
+ self::show_new_mv_div();
+ break;
+ case 'new_mv_add':
+ #self::new_mv_add();
+ break;
+ case 'refresh_mv':
+ self::DisplayMissingValuesForQuestion();
+ break;
+
+ case 'add_new_numeric':
+ self::AddNewNumericRecode();
+ break;
+ case 'changeRecodeType':
+ self::changeRecodeType();
+ break;
+ default:
+# print_r($_POST);
+# print_r($_GET);
+ break;
+ }
+ }
+
+ public function removeRecodeForQuestion() {
+ if ((int)self::$anketa > 0 && (int)self::$spremenljivka > 0) {
+ # odstranimo rekodiranje za spremenljivko
+ $sql = sisplet_query("DELETE FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ # preverimo ali imamo rekodiranje v novo spremenljivko, če ja, kasneje ponudimo tud izbris psremenljivke
+ $qry = sisplet_query("SELECT to_spr_id FROM srv_recode_spremenljivka WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'");
+ list($spr_id) = mysqli_fetch_row($qry);
+ # pobrišemo še zapise v srv_recode_vrednost in srv_recode spremenljika
+ $sql = sisplet_query("DELETE FROM srv_recode_spremenljivka WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ $sql = sisplet_query("DELETE FROM srv_recode_vrednost WHERE ank_id = '".self::$anketa."' AND spr1 = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ sisplet_query("COMMIT");
+ return (int)$spr_id;
+ } else {
+ return 0;
+ }
+ }
+
+ public function SetUpMissingValuesForQuestion() {
+ if ((int)self::$anketa > 0 ) {
+ # pobrišemo rekodirane vrednosti za morebitno rekodiranje v novo spremenljivko
+ if (isset($_REQUEST['recodeToSpr']) && (int)$_REQUEST['recodeToSpr'] > 0) {
+ $sql = sisplet_query("DELETE FROM srv_recode_vrednost WHERE ank_id = '".self::$anketa."' AND spr2 = '".(int)$_REQUEST['recodeToSpr']."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+ }
+
+
+ # če imamo spremembe je potrebno na novo zgenerirati datoteko
+ $strSelect = "SELECT search, value, operator FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."' ORDER BY vrstni_red";
+ $sqlSelect = sisplet_query($strSelect);
+ $rowsBefore = array();
+ $rowsAfter = array();
+ while (list($search, $value, $operator) = mysqli_fetch_row($sqlSelect)) {
+ $rowsBefore[] = $search."_".$value."_".(int)$operator;
+ }
+
+ # pobrišemo vse obstoječe zamenjave
+ $sql = sisplet_query("DELETE FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ #rekodiramo kategorije
+ if ( isset($_REQUEST['edit_recode_mv']) ) {
+ # dodamo potrebne zamenjave za
+ $_for_replace = "";
+ foreach ($_REQUEST as $key => $value) {
+ $_tmp_value = substr($key, 5);
+ if (substr($key, 0, 5) == 'MVFQ_' && $_tmp_value != $value) {
+ if ($_for_replace != "") { $_for_replace .= ","; }
+ $_for_replace .= " ('".self::$anketa."', '".self::$spremenljivka."', '$_tmp_value', '$value') ";
+ }
+ }
+
+
+ # če moramo uporabiti zamenjave:
+ if ($_for_replace != "") {
+ $insertString = 'INSERT INTO srv_recode (ank_id, spr_id, search, value) VALUES '.$_for_replace;
+ $sql1 = sisplet_query($insertString);
+ }
+ } else if( isset($_REQUEST['edit_recode_number']) ){
+ # rekodiramo numerične
+ $recoded = array();
+ if (isset($_REQUEST['recode_number_operator'])) {
+ foreach ($_REQUEST['recode_number_operator'] as $key => $value) {
+ $recoded[$key]['operator'] = $value;
+ }
+ }
+ if (isset($_REQUEST['recode_number_search'])) {
+ foreach ($_REQUEST['recode_number_search'] as $key => $value) {
+ $recoded[$key]['search'] = trim($value);
+ }
+ }
+ if (isset($_REQUEST['recode_number_search1'])) {
+ foreach ($_REQUEST['recode_number_search1'] as $key => $value) {
+ $recoded[$key]['search1'] = trim($value);
+ }
+ }
+ if (isset($_REQUEST['recode_number_search2'])) {
+ foreach ($_REQUEST['recode_number_search2'] as $key => $value) {
+ $recoded[$key]['search2'] = trim($value);
+ }
+ }
+ if (isset($_REQUEST['recode_number_value'])) {
+ foreach ($_REQUEST['recode_number_value'] as $key => $value) {
+ $recoded[$key]['value'] = trim($value);
+ }
+ }
+ # pripravimo query
+ if (count($recoded) > 0) {
+ $_for_replace = "";
+ $already_set = array();
+ $vrstni_red = 1;
+ foreach ($recoded AS $rKey => $recode) {
+ $opreand = (int)$recode['operator'];
+ if ( $opreand != 6) {
+ $_search = $recode['search'];
+ } else {
+ $_search = $recode['search1'].','.$recode['search2'];
+ }
+ if ( $_search != '' && $recode['value'] != ''
+ #preprečimo zamenjavo iste vrednosti z istim operatorejm.
+ && !( isset($already_set[$_search.'_'.$recode['operator']] ))
+ ) {
+ if ($_for_replace != "") {
+ $_for_replace .= ",";
+ }
+
+ $_for_replace .= " ('".self::$anketa."', '".self::$spremenljivka."', '$vrstni_red', '$_search', '".trim($recode['value'])."', '".(int)trim($recode['operator'])."') ";
+
+ $already_set[$_search.'_'.$recode['operator']] = true;
+ }
+ $vrstni_red ++;
+ }
+ if ($_for_replace != "") {
+ # izvedemo insert query
+ $insertString = 'INSERT INTO srv_recode (ank_id, spr_id, vrstni_red, search, value, operator) VALUES '.$_for_replace;
+ $sql1 = sisplet_query($insertString);
+ if (!$sql1) {
+ print_r(mysqli_error($GLOBALS['connect_db']));
+ }
+ }
+ }
+
+ }
+ sisplet_query("COMMIT");
+
+ # če imamo spremembe je potrebno na novo zgenerirati datoteko
+ $strSelect = "SELECT search, value, operator FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."' ORDER BY vrstni_red";
+ $sqlSelect = sisplet_query($strSelect);
+ while (list($search, $value, $operator) = mysqli_fetch_row($sqlSelect)) {
+ $rowsAfter[] = $search."_".$value."_".(int)$operator;
+ }
+ if ( (count( array_diff($rowsBefore, $rowsAfter) ) + count( array_diff($rowsAfter, $rowsBefore) ) ) > 0) {
+ # array-a nista enaka, imamo spremembe
+ # pobrišimo datoteko, da se podatki zgenerirajo na novo
+ global $site_path;
+ $data_file_name = $site_path.'admin/survey/SurveyData/export_data_'.self::$anketa.'.dat';
+ if (file_exists($data_file_name)) {
+ unlink($data_file_name);
+ }
+ return true;
+
+ }
+ return false;
+ }
+ return false;
+ }
+
+
+ public function SetRecodeNumberNewVrednost() {
+ if ((int)self::$anketa > 0 && (int)$_REQUEST['recode_type']== 1 && (int)$_REQUEST['edit_recode_number'] == 1) {
+
+ # pobrišemo rekodirane vrednosti za morebitno rekodiranje v novo spremenljivko
+ if ((int)self::$spremenljivka > 0) {
+ $sql = sisplet_query("DELETE FROM srv_recode_vrednost WHERE ank_id = '".self::$anketa."' AND spr1 = '".(int)self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+ }
+
+ # pobrišemo vse mmorebitne obstoječe zamenjave za normalni number
+ $sql = sisplet_query("DELETE FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ # pobrišemo vse morebitne obstoječe zamenjave za number
+ $sql = sisplet_query("DELETE FROM srv_recode_number WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+
+ if( isset($_REQUEST['recode_number_vrednost']) ){
+ # rekodiramo numerične
+ $recoded = array();
+ if (isset($_REQUEST['recode_number_operator'])) {
+ foreach ($_REQUEST['recode_number_operator'] as $key => $value) {
+ $recoded[$key]['operator'] = $value;
+ }
+ }
+ if (isset($_REQUEST['recode_number_search'])) {
+ foreach ($_REQUEST['recode_number_search'] as $key => $value) {
+ $recoded[$key]['search'] = trim($value);
+ }
+ }
+ if (isset($_REQUEST['recode_number_search1'])) {
+ foreach ($_REQUEST['recode_number_search1'] as $key => $value) {
+ $recoded[$key]['search1'] = trim($value);
+ }
+ }
+ if (isset($_REQUEST['recode_number_search2'])) {
+ foreach ($_REQUEST['recode_number_search2'] as $key => $value) {
+ $recoded[$key]['search2'] = trim($value);
+ }
+ }
+ if (isset($_REQUEST['recode_number_vrednost'])) {
+ foreach ($_REQUEST['recode_number_vrednost'] as $key => $value) {
+ $recoded[$key]['value'] = trim($value);
+ }
+ }
+ # pripravimo query
+ if (count($recoded) > 0) {
+ $_for_replace = "";
+ $already_set = array();
+ $vrstni_red = 1;
+ foreach ($recoded AS $rKey => $recode) {
+ $opreand = (int)$recode['operator'];
+ if ( $opreand != 6) {
+ $_search = $recode['search'];
+ } else {
+ $_search = $recode['search1'].','.$recode['search2'];
+ }
+ if ( $_search != '' && $recode['value'] != ''
+ #preprečimo zamenjavo iste vrednosti z istim operatorejm.
+ && !( isset($already_set[$_search.'_'.$recode['operator']] ))
+ ) {
+ if ($_for_replace != "") {
+ $_for_replace .= ",";
+ }
+
+ $_for_replace .= " ('".self::$anketa."', '".self::$spremenljivka."', '$vrstni_red', '$_search', '".trim($recode['value'])."', '".(int)trim($recode['operator'])."') ";
+
+ $already_set[$_search.'_'.$recode['operator']] = true;
+ }
+ $vrstni_red ++;
+ }
+ if ($_for_replace != "") {
+ # izvedemo insert query
+ $insertString = 'INSERT INTO srv_recode_number (ank_id, spr_id, vrstni_red, search, vred_id, operator) VALUES '.$_for_replace;
+ $sql1 = sisplet_query($insertString);
+ if (!$sql1) {
+ print_r(mysqli_error($GLOBALS['connect_db']));
+ }
+ }
+ }
+
+ }
+ sisplet_query("COMMIT");
+ }
+ return false;
+ }
+
+ public function AddNewNumericRecode() {
+ global $lang;
+
+ $recode_type = (int)$_POST['recode_type'];
+
+ self::LoadSpremenljivkaMissingValues();
+
+ if ( $recode_type == 0) {
+ echo '<li>';
+ echo '<span class="faicon move_updown moveY"></span>';
+ printf($lang['srv_recode_number_if'],self::$cacheSpremenljivka['variable']);
+ echo ' <select name="recode_number_operator[]" onChange="recode_operator_changed(this);">';
+ foreach (self::$_operators AS $value => $operator) {
+ $selected = ($value == '0') ? ' selected="selected"' : '';
+ echo '<option value="'.$value.'"'.$selected.'>'.$operator.'</option>';
+ }
+ echo '</select>';
+ #echo ' <input type="text" name="recode_number_search[]" value="0" size="5" autocomplete="off"/>';
+
+ echo '<span class="recode_int_first">';
+ echo ' <input type="text" name="recode_number_search[]" value="0" size="12" autocomplete="off"/>';
+ echo '</span>';
+ echo '<span class="recode_int_seccond hidden">';
+ echo ' [<input type="text" name="recode_number_search1[]" value="0" size="5" autocomplete="off"/>,';
+ echo '<input type="text" name="recode_number_search2[]" value="1" size="5" autocomplete="off"/>]';
+ echo '</span>';
+
+ echo ' '.$lang['srv_recode_number_to'];
+
+ echo '<select name="recode_number_type[]" onChange="recode_number_type_changed(this);">';
+ foreach (self::$options AS $oKey => $option) {
+ if ($option['variable'] == null && $oKey != '_0_') {
+ echo '<option disabled="disabled">'.$option['naslov'].'</option>';
+ $_value = null;
+ } else {
+ $_value = ($oKey == '_0_') ? '_' : $option['variable'];
+ $_selected = ($oKey == '_0_') ? 'selected="selected"' : '';
+ $_label = ($oKey == '_0_') ? $option['naslov'] : ' '.$option['naslov'].' ['.$option['variable'].']';
+ echo '<option value="'.$_value.'" '.$_selected.'>'.$_label.'</option>';
+ }
+ }
+ echo '</select>';
+
+ echo ' <input type="text" name="recode_number_value[]" value="0" size="5" autocomplete="off"/>';
+ echo ' <span class="floatRight spaceRight faicon delete_circle icon-orange_link" onclick="recode_delete_numeric(\''.self::$spremenljivka.'\',this);"></span>';
+ echo '</li>';
+ } else {
+ # polovimo osnovne lastnosti rekodiranja
+ $selectString = "SELECT to_spr_id FROM srv_recode_spremenljivka WHERE ank_id='".self::$anketa."' AND spr_id='".self::$spremenljivka."'";
+ $sqlSelect = sisplet_query($selectString);
+ if (!$sqlSelect) echo mysqli_error($GLOBALS['connect_db']);
+ list($to_spr_id) = mysqli_fetch_row($sqlSelect);
+
+ self::LoadSpremenljivkaMissingValues($to_spr_id);
+ $new_spr_vrednosti = self::$options;
+ self::LoadSpremenljivkaMissingValues(self::$spremenljivka);
+
+
+ echo '<li>';
+ echo '<span class="faicon move_updown moveY"></span>';
+ printf($lang['srv_recode_number_if'],self::$cacheSpremenljivka['variable']);
+ echo ' <select name="recode_number_operator[]" onChange="recode_operator_changed(this);">';
+ foreach (self::$_operators AS $value => $operator) {
+ $selected = ($value == '0') ? ' selected="selected"' : '';
+ echo '<option value="'.$value.'"'.$selected.'>'.$operator.'</option>';
+ }
+ echo '</select>';
+ #echo ' <input type="text" name="recode_number_search[]" value="0" size="5" autocomplete="off"/>';
+
+ echo '<span class="recode_int_first">';
+ echo ' <input type="text" name="recode_number_search[]" value="0" size="12" autocomplete="off"/>';
+ echo '</span>';
+ echo '<span class="recode_int_seccond hidden">';
+ echo ' [<input type="text" name="recode_number_search1[]" value="0" size="5" autocomplete="off"/>,';
+ echo '<input type="text" name="recode_number_search2[]" value="1" size="5" autocomplete="off"/>]';
+ echo '</span>';
+
+ echo ' '.$lang['srv_recode_number_to'];
+ # imamo rekodiranje v novo spremenljivko
+ $recode['vred_id'] = '-1';
+
+ echo '<select name="recode_number_vrednost[]">';
+ if (is_array($new_spr_vrednosti) && count($new_spr_vrednosti)>0) {
+ foreach ($new_spr_vrednosti AS $oKey => $option) {
+ if ($option['variable'] == null) {
+ echo '<option disabled="disabled">'.$option['naslov'].'</option>';
+ } else {
+ $_selected = ($recode['vred_id'] == $option['variable']) ? ' selected="selected"' : '';
+ $_label = $option['naslov'].' ['.$option['variable'].']';
+ echo '<option value="'.$option['variable'].'"'.$_selected.'> '.$_label.'</option>';
+ }
+ # $_label = $option['naslov'].' ['.$option['variable'].']';
+ # echo '<option value="'.$option['id'].'" '.$_selected.'>'.$_label.'</option>';
+ }
+ }
+ echo '</select>';
+
+ echo ' <span class="floatRight spaceRight faicon delete_circle icon-orange_link" onclick="recode_delete_numeric(\''.self::$spremenljivka.'\',this);"></span>';
+ echo '</li>';
+ }
+
+ return;
+ }
+
+ public function hasRecodedValues() {
+ #preštejemo koliko rekodiranj imamo za spremenljivko
+ $strSelect = "SELECT count(*) FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."'";
+ $sqlSelect = sisplet_query($strSelect);
+ list($count) = mysqli_fetch_row($sqlSelect);
+ return (int)$count;
+ }
+
+
+ public function changeRecodeType() {
+ $insertString = "INSERT INTO srv_recode_spremenljivka (ank_id, spr_id, recode_type, to_spr_id) VALUES ('".self::$anketa."', '".self::$spremenljivka."', '".(int)$_POST['recode_type']."', '".(int)$_POST['recodeToSpr']."') ON DUPLICATE KEY UPDATE recode_type = '".(int)$_POST['recode_type']."', to_spr_id = '".(int)$_POST['recodeToSpr']."'";
+ $sqlInsert = sisplet_query($insertString);
+ self::displayRecodeType();
+ }
+
+ public static function displayRecodeType() {
+ global $lang;
+ $tip = self::$cacheSpremenljivka['tip'];
+ if (in_array($tip, array(
+ 1, # radio
+ 2, # checkbox
+ 3, # select
+ 6, # multiradio
+ 16, # multicheck
+ 17 # razvrščanje
+ ))) {
+ $displayType=1;
+ } else if (in_array($tip, array(
+ 7, # number
+ 18, # vsota
+ 20, # multinumber
+ 22, # multinumber
+ 21, # textovni
+ ))) {
+ $displayType=2;
+ }
+ # polovimo osnovne lastnosti rekodiranja
+ $selectString = "SELECT recode_type, to_spr_id FROM srv_recode_spremenljivka WHERE ank_id='".self::$anketa."' AND spr_id='".self::$spremenljivka."'";
+ $sqlSelect = sisplet_query($selectString);
+ if (!$sqlSelect) echo mysqli_error($GLOBALS['connect_db']);
+ list($recode_type, $to_spr_id) = mysqli_fetch_row($sqlSelect);
+
+ if ((int)$recode_type == 0) {
+ self::LoadSpremenljivkaMissingValues(self::$spremenljivka);
+ # polovimo missinge za spremenljivko
+ $strSelect = "SELECT search, value, operator FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."' ORDER BY vrstni_red";
+ $sqlSelect = sisplet_query($strSelect);
+ if (!$sqlSelect) echo mysqli_error($GLOBALS['connect_db']);
+ $recoded = array();
+ if (mysqli_num_rows($sqlSelect)) {
+ while ($rowSelect = mysqli_fetch_assoc($sqlSelect)) {
+ $recoded[$rowSelect['search'].'_'.$rowSelect['operator']] = array('search'=>$rowSelect['search'],'value'=>$rowSelect['value'],'operator'=>$rowSelect['operator']);
+ }
+ }
+ } else {
+
+ if ($displayType == 1) {
+ # polovimo še vrednosti če imamo rekodirano v drugo spremenljivko
+ $qry_str = "select vre1, spr2, vre2 from srv_recode_vrednost WHERE ank_id = '".self::$anketa."' AND spr1 = '".self::$spremenljivka."'";
+ $sql = sisplet_query($qry_str);
+ $recodedFrom = array();
+ while (list($vre1, $spr1, $vre2) = mysqli_fetch_row($sql)) {
+ $recodedFrom[$vre1] = $vre2;
+ }
+ } else {
+ # polovimo missinge za spremenljivko
+ $strSelect = "SELECT search, vred_id, operator FROM srv_recode_number WHERE ank_id = '".self::$anketa."' AND spr_id = '".self::$spremenljivka."' ORDER BY vrstni_red";
+ $sqlSelect = sisplet_query($strSelect);
+ if (!$sqlSelect) echo mysqli_error($GLOBALS['connect_db']);
+ $recoded = array();
+ if (mysqli_num_rows($sqlSelect)) {
+ while ($rowSelect = mysqli_fetch_assoc($sqlSelect)) {
+ $recoded[$rowSelect['search'].'_'.$rowSelect['operator']] = array('search'=>$rowSelect['search'],'vred_id'=>$rowSelect['vred_id'],'operator'=>$rowSelect['operator']);
+ }
+ }
+ }
+
+ self::LoadSpremenljivkaMissingValues($to_spr_id);
+ $new_spr_vrednosti = self::$options;
+ self::LoadSpremenljivkaMissingValues(self::$spremenljivka);
+
+ # preverimo ali spremenljvka obstaja
+ #$new_spr_vrednosti = array();
+ if ((int)$to_spr_id > 0) {
+ $sqlSpremenljivka = sisplet_query("SELECT s.naslov, s.variable, s.tip FROM srv_spremenljivka s WHERE s.id = '$to_spr_id'");
+ $rowSpremenljivka = mysqli_fetch_assoc($sqlSpremenljivka);
+
+ if (mysqli_num_rows($sqlSpremenljivka) == 0) {
+ $to_spr_id = 0;
+ }
+ }
+ }
+
+ echo '<input type="hidden" name="anketa" value="'.self::$anketa.'" autocomplete="off"/>';
+ echo '<input type="hidden" name="spr_id" value="'.self::$spremenljivka.'" autocomplete="off"/>';
+ echo '<input type="hidden" name="recodeToSpr" value="'.$to_spr_id.'" autocomplete="off"/>';
+ echo '<input type="hidden" id="recIsCharts" value="'.((int)(($_GET['t'] == 'charts')||((int)$_POST['recIsCharts'] == 1)) ).'" autocomplete="off"/>';
+
+
+ if ( $_GET['t'] == 'charts' || $_POST['recIsCharts'] == 1 ) {
+ # če smo v grafih in smo na spremenljivki katera je že rekodirana iz druge, potem onemogočimo nadaljnje kodiranje
+ $strSel = "SELECT count(*) FROM srv_recode_spremenljivka WHERE to_spr_id = '".self::$spremenljivka."'";
+ $qry = sisplet_query($strSel);
+ list($cnt) = mysqli_fetch_row($qry);
+ if ((int)$cnt > 0) {
+ echo $lang['srv_recoded_advancetNote_recoded3'];
+ echo self::$cacheSpremenljivka['variable'].' - '.self::$cacheSpremenljivka['naslov'];
+ echo $lang['srv_recoded_advancetNote_recoded4'];
+ return;
+ }
+ }
+
+
+ if (self::$cacheSpremenljivka['tip'] == 1 || self::$cacheSpremenljivka['tip'] == 3 || self::$cacheSpremenljivka['tip'] == 7) {
+
+ if ( (int)$recode_type == 1 && ((int)(($_GET['t'] == 'charts')||((int)$_POST['recIsCharts'] == 1))) ) {
+ echo '<br/>';
+ echo $lang['srv_recoded_advancetNote'].'<a href="index.php?anketa='.self::$anketa.'&a='.A_COLLECT_DATA.'&m='.M_COLLECT_DATA_RECODING.'">'.$lang['srv_here'].'</a>';
+ echo Help::display('srv_recode_chart_advanced');
+ echo '<br/>';
+ echo '<br/>';
+ echo $lang['srv_recoded_advancetNote_recoded1'];
+ echo self::$cacheSpremenljivka['variable'];
+ echo ' - '.strip_tags(self::$cacheSpremenljivka['naslov']);
+ echo $lang['srv_recoded_advancetNote_recoded2'];
+ echo $rowSpremenljivka['variable'].' - '.$rowSpremenljivka['naslov'];
+ return;
+ }
+ $sugestedName = strip_tags(self::$cacheSpremenljivka['naslov'].' - recoded');
+ echo'<div id="divRecodeSprOption">';
+ echo '<label>'.$lang['srv_recode_to_spr'].'</label>';
+ if ( $_GET['t'] == 'charts' || $_POST['recIsCharts'] == 1 ) {
+ echo $lang['srv_recode_to_spr_same'];
+ } else {
+ echo '<label><input type="radio" name="recode_type" value="0" '.((int)$recode_type == 0 ? ' checked="checked"' : '').'onchange="changeRecodeType();return false;">'.$lang['srv_recode_to_spr_same'].'</label>';
+ echo '<label><input type="radio" name="recode_type" value="1" '.((int)$recode_type == 1 ? ' checked="checked"' : '').'onchange="changeRecodeType();return false;">'.$lang['srv_recode_to_spr_new'].'</label>';
+ }
+ echo '</div>';
+ if ((int)$recode_type == 1) {
+
+ echo'<span id="divRecodeSprNew" class="floatRecodeSpremenljivka">';
+
+ if ((int)$to_spr_id == 0) {
+ echo '<div class="new-spr" style="text-align: right">';
+ echo $lang['srv_recode_to_spr_add_spr'].'<br/>';
+ echo '<div id="coding_spr_new" >';
+ echo '<p>'.$lang['srv_recode_to_spr_name'].' <input type="text" id="rec_spremenljivka_naslov" name="spremenljivka_naslov" default="1" contenteditable="true" value="'.$sugestedName.'" style="width: 123px" />';
+ #echo '<a href="#" onclick="recodeSpremenljivkaNew(); return false;">'.$lang['add'].'</a>';
+ echo '<a href="#" onclick="recodeSpremenljivkaNew(); return false;""><span class="faicon add small" title="'.$lang['add'].'"></span></a>';
+ echo '</p>';
+ echo '</div>';
+ echo '</div>';
+ } else {
+ echo '<strong>'.$rowSpremenljivka['variable'].' - '.skrajsaj(strip_tags($rowSpremenljivka['naslov']), 40).'</strong><br/><br/>';
+ $sql1 = sisplet_query("SELECT naslov FROM srv_vrednost WHERE spr_id='$to_spr_id' ORDER BY vrstni_red ASC");
+ while ($row1 = mysqli_fetch_array($sql1)) {
+ if ($rowSpremenljivka['tip'] == 1) {
+ echo '<input type="radio" onclick="return false;" /><label> '.$row1['naslov'].'</label>';
+ echo '<br/>';
+ }
+ }
+ if (mysqli_num_rows($sql1) == 0) {
+ echo ' '.$lang['srv_novavrednost'].': '; $margin='0';
+ } else { $margin = '23px';
+ }
+ echo '<input type="text" name="vrednost_new" value="" '.(mysqli_num_rows($sql1)>0?' placeholder="'.$lang['srv_novavrednost'].'" ':'').' style="margin-left:'.$margin.'; width: 80px" /> ';
+ echo '<a href="#" onclick="recodeVrednostNew(); return false;"><span class="faicon add small icon-as_link" title="'.$lang['add'].'"></span></a>';
+ echo '<br>Napredne spremembe:'.Help::display('srv_recode_advanced_edit');
+ }
+ echo '</span>';
+ }
+ echo'<br class="clr" />';
+ }
+ if ( $displayType == 1 ) {
+ if (count(self::$variables)> 0) {
+ if ((int)$recode_type == 0) {
+ echo '<input type="hidden" name="edit_recode_mv" value="1" autocomplete="off"/>';
+ } else {
+ # rekodiramo v novo spremenljivko
+ echo '<input type="hidden" name="edit_recode_nsmv" value="1" autocomplete="off"/>';
+ }
+ //echo '<table style="width:65% !important;">';
+ echo '<table class="question_recode_table">';
+ echo '<tr>';
+ echo '<th class="halfWidth" colspan="2">';
+ echo $lang['srv_recode_original'];
+ echo '</th>';
+ echo '<td rowspan="2" style="vertical-align:top;"> <span class="sprites arrow_switch"></span> </td>';
+ echo '<th class="halfWidth" rowspan="2" style="vertical-align:top;">';
+ echo $lang['srv_recode_to'];
+ echo '</th>';
+ echo '</tr>';
+
+ echo '<tr>';
+ echo '<td class="halfWidth anl_ac gray">';
+ echo $lang['srv_recode_to_label'];
+ echo '</td>';
+ echo '<td class="halfWidth anl_ac gray">';
+ echo $lang['srv_recode_to_value'];
+ echo '</td>';
+ echo '</tr>';
+
+ foreach (self::$variables AS $vKey => $variable) {
+ echo '<tr>';
+ echo '<td class="anl_ac">';
+ echo $variable['naslov'];
+ echo '</td>';
+ echo '<td class="anl_ac">';
+ echo ' ['.$variable['variable'].']';
+ echo '</td>';
+ # spacer
+ echo '<td> </td>';
+ #
+ echo '<td>';
+ if ((int)$recode_type == 0) {
+ # imamo klasično rekodiranje
+ echo '<select name="MVFQ_'.$variable['variable'].'">';
+ foreach (self::$options AS $oKey => $option) {
+
+ if ($option['variable'] == null) {
+ echo '<option disabled="disabled">'.$option['naslov'].'</option>';
+ } else {
+ $_selected = ((isset($recoded[$variable['variable'].'_0']) && $recoded[$variable['variable'].'_0']['value'] == $option['variable'])
+ || (!isset($recoded[$variable['variable'].'_0']) && $variable['variable'] == $option['variable'])) ? 'selected="selected"' : '';
+ $_label = (( $variable['variable'] == $option['variable']))
+ ? '('.$lang['srv_recode_valid'].') '.$option['naslov'].' ['.$option['variable'].']'
+ : $option['naslov'].' ['.$option['variable'].']';
+ echo '<option value="'.$option['variable'].'" '.$_selected.'> '.$_label.'</option>';
+ }
+ }
+ echo '</select>';
+ } else {
+ # imamo rekodiranje v novo spremenljivko
+
+ if (!isset($recodedFrom[$vKey])) {
+ $recodedFrom[$vKey] = '-1';
+ }
+ echo '<select name="MVSNFQ_'.$vKey.'">';
+ if (is_array($new_spr_vrednosti) && count($new_spr_vrednosti)>0) {
+ foreach ($new_spr_vrednosti AS $oKey => $option) {
+ if ($option['variable'] == null) {
+ echo '<option disabled="disabled">'.$option['naslov'].'</option>';
+ } else {
+
+ if (is_numeric($oKey)) {
+ $_selected = (isset($recodedFrom[$vKey]) && $recodedFrom[$vKey] == $oKey)
+ ? ' selected="selected"'
+ : '';
+ $_label = $option['naslov'].' ['.$option['variable'].']';
+ $value = (int)$oKey;
+ } else {
+ $_selected = (isset($recodedFrom[$vKey]) && $recodedFrom[$vKey] == $option['variable'])
+ ? ' selected="selected"'
+ : '';
+ $_label = $option['naslov'].' ['.$option['variable'].']';
+ $value = (int)$option['type'] == 0 && (int)$option['id'] > 0 ? $option['id'] : $option['variable'];
+ }
+ echo '<option value="'.$value.'" '.$_selected.'> '.$_label.'</option>';
+ }
+ }
+ }
+ echo '</select>';
+ }
+ echo '</td>';
+ echo '</tr>';
+ }
+ echo '</table>';
+ }
+ } else if ( $displayType == 2) {
+ # number
+ if ((int)$recode_type == 0) {
+ echo '<input type="hidden" name="edit_recode_number" value="1" autocomplete="off"/>';
+ echo '<ul id="recode_number_sort" class="recode_number_sort">';
+ if (count($recoded)> 0) {
+ foreach ($recoded AS $rKey => $recode) {
+
+ echo '<li>';
+ echo '<span class="faicon move_updown moveY"></span>';
+ printf($lang['srv_recode_number_if'],self::$cacheSpremenljivka['variable']);
+ echo ' <select name="recode_number_operator[]" onChange="recode_operator_changed(this);">';
+ foreach (self::$_operators AS $value => $operator) {
+ $selected = ($value == $recode['operator']) ? ' selected="selected"' : '';
+ echo '<option value="'.$value.'"'.$selected.'>'.$operator.'</option>';
+ }
+ echo '</select>';
+ $rSearchInterval = explode(',',$recode['search']);
+
+ echo '<span class="recode_int_first'.($recode['operator'] != 6 ? '' : ' hidden').'">';
+ echo ' <input type="text" name="recode_number_search[]" value="'.($rSearchInterval[0]).'" size="12" autocomplete="off"/>';
+ echo '</span>';
+ echo '<span class="recode_int_seccond'.($recode['operator'] != 6 ? ' hidden' : '').'">';
+ echo ' [<input type="text" name="recode_number_search1[]" value="'.($rSearchInterval[0]).'" size="5" autocomplete="off"/>,';
+ echo '<input type="text" name="recode_number_search2[]" value="'.($rSearchInterval[1]).'" size="5" autocomplete="off"/>]';
+ echo '</span>';
+
+ echo ' '.$lang['srv_recode_number_to'];
+ $is_missing_value = false;
+ echo '<select name="recode_number_type" onChange="recode_number_type_changed(this);">';
+ foreach (self::$options AS $oKey => $option) {
+ if ($oKey == '_0_' || $oKey == '_1_' || $oKey == '_2_') {
+ # privzeto izberemo prvi odgovor - veljavni, nato spodaj popravimo
+ $_value = ($oKey == '_0_') ? '_' : null;
+ $_selected = ($oKey == '_0_' ? 'selected="selected"' : 'disabled="disabled"');
+ $_label = $option['naslov'];
+ } else {
+ $_value = $option['variable'];
+ if ($oKey == $recode['value']) {
+ $is_missing_value = true;
+ $_selected = 'selected="selected"';
+ } else {
+ $_selected = '';
+ }
+ $_label = ' '.$option['naslov'].' ['.$option['variable'].']';
+ }
+ echo '<option value="'.$_value.'" '.$_selected.'>'.$_label.'</option>';
+ }
+ echo '</select>';
+
+ echo ' <input type="text" name="recode_number_value[]" value="'.$recode['value'].'" size="5" '.($is_missing_value ? ' class="hidden"' : '').' autocomplete="off"/>';
+ echo ' <span class="floatRight spaceRight faicon delete_circle icon-orange_link" onclick="recode_delete_numeric(\''.self::$spremenljivka.'\',this);"></span>';
+ echo '</li>';
+ }
+ }
+ echo '</ul>';
+ echo '<script>$(\'#recode_number_sort\').sortable({ items: \'li\', axis: \'y\', scroll: \'false\', handle: \'span.move_updown\', forcePlaceholderSize: \'true\', placeholder: "ui-recode-placeholder"});</script>';
+ echo '<span onclick="recode_add_numeric(\''.self::$spremenljivka.'\');" class="pointer"><span class="faicon add small icon-as_link" title="'.$lang['srv_recode_add_number'].'"></span> '.$lang['srv_recode_add_number'].'</span>';
+ } else {
+
+ # number
+ # recode to new spr
+ echo '<input type="hidden" name="edit_recode_number" value="1" autocomplete="off"/>';
+ echo '<ul id="recode_number_sort" class="recode_number_sort">';
+ if (count($recoded)> 0) {
+ foreach ($recoded AS $rKey => $recode) {
+
+ echo '<li>';
+ echo '<span class="faicon move_updown moveY"></span>';
+ printf($lang['srv_recode_number_if'],self::$cacheSpremenljivka['variable']);
+ echo ' <select name="recode_number_operator[]" onChange="recode_operator_changed(this);">';
+ foreach (self::$_operators AS $value => $operator) {
+ $selected = ($value == $recode['operator']) ? ' selected="selected"' : '';
+ echo '<option value="'.$value.'"'.$selected.'>'.$operator.'</option>';
+ }
+ echo '</select>';
+ $rSearchInterval = explode(',',$recode['search']);
+
+ echo '<span class="recode_int_first'.($recode['operator'] != 6 ? '' : ' hidden').'">';
+ echo ' <input type="text" name="recode_number_search[]" value="'.($rSearchInterval[0]).'" size="12" autocomplete="off"/>';
+ echo '</span>';
+ echo '<span class="recode_int_seccond'.($recode['operator'] != 6 ? ' hidden' : '').'">';
+ echo ' [<input type="text" name="recode_number_search1[]" value="'.($rSearchInterval[0]).'" size="5" autocomplete="off"/>,';
+ echo '<input type="text" name="recode_number_search2[]" value="'.($rSearchInterval[1]).'" size="5" autocomplete="off"/>]';
+ echo '</span>';
+
+ echo ' '.$lang['srv_recode_number_to'];
+ if (!isset($recodedFrom[$rKey])) {
+ $recodedFrom[$rKey] = '-1';
+ }
+ # imamo rekodiranje v novo spremenljivko
+ echo '<select name="recode_number_vrednost[]">';
+ if (is_array($new_spr_vrednosti) && count($new_spr_vrednosti)>0) {
+ foreach ($new_spr_vrednosti AS $oKey => $option) {
+ if ($option['variable'] == null) {
+ echo '<option disabled="disabled">'.$option['naslov'].'</option>';
+ } else {
+ if ($option['type'] == 0) {
+ $value = $oKey;
+ $_selected = ($recode['vred_id'] == $oKey) ? ' selected="selected"' : '';
+ } else {
+ $value = $option['variable'];
+ $_selected = ($recode['vred_id'] == $option['variable']) ? ' selected="selected"' : '';
+ }
+
+ $_label = $option['naslov'].' ['.$option['variable'].']';
+ echo '<option value="'.$value.'"'.$_selected.'> '.$_label.'</option>';
+ }
+
+
+
+ # $_label = $option['naslov'].' ['.$option['variable'].']';
+ # echo '<option value="'.$option['id'].'" '.$_selected.'>'.$_label.'</option>';
+ }
+ }
+ echo '</select>';
+ echo ' <span class="floatRight spaceRight faicon delete_circle icon-orange_link" onclick="recode_delete_numeric(\''.self::$spremenljivka.'\',this);"></span>';
+ echo '</li>';
+ }
+ }
+ echo '</ul>';
+ echo '<script>$(\'#recode_number_sort\').sortable({ items: \'li\', axis: \'y\', scroll: \'false\', handle: \'span.move_updown\', forcePlaceholderSize: \'true\', placeholder: "ui-recode-placeholder"});</script>';
+ echo '<span onclick="recode_add_numeric(\''.self::$spremenljivka.'\');" class="pointer"><span class="faicon add small icon-as_link" title="'.$lang['srv_recode_add_number'].'"></span> '.$lang['srv_recode_add_number'].'</span>'; }
+ } else {
+ echo '<br>'.$lang['srv_recoding_not_set_jet'].'('.$tip.')<br>';
+ }
+ }
+
+ function SetRecodeNewVrednost() {
+ # pobrišemo morebtne vrednosti v srv_recode (če je bilo predhodno nastavljeno klasično rekodiranje)
+ $sqlD = sisplet_query("DELETE FROM srv_recode WHERE ank_id = '".self::$anketa."' AND spr_id = '".$_REQUEST['spr_id']."'");
+ if (!$sqlD) echo mysqli_error($GLOBALS['connect_db']);
+ sisplet_query("COMMIT");
+
+ $newSpr = $_REQUEST['recodeToSpr'];
+ $_for_replace = "";
+ if ((int)$newSpr > 0)
+ foreach ($_REQUEST as $key => $newVrednost) {
+ if (substr($key, 0, 7) == 'MVSNFQ_' && trim($newVrednost) != '') {
+ # id stare vrednosti
+ $oldVrednost = substr($key, 7);
+ if ($_for_replace != "") {
+ $_for_replace .= ",";
+ }
+ $_for_replace .= " ('".self::$anketa."','".self::$spremenljivka."','$oldVrednost','$newSpr','$newVrednost') ";
+ }
+
+ }
+ # najprej pobrišemo vse obstoječe vrednosti
+ $sql = sisplet_query("DELETE FROM srv_recode_vrednost WHERE ank_id = '".self::$anketa."' AND spr1 = '".self::$spremenljivka."'");
+ if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+ sisplet_query("COMMIT");
+
+ # če moramo uporabiti zamenjave:
+ if ($_for_replace != "") {
+ $insertString = 'INSERT INTO srv_recode_vrednost (ank_id, spr1, vre1, spr2, vre2) VALUES '.$_for_replace;
+ $sql1 = sisplet_query($insertString);
+ }
+ sisplet_query("COMMIT");
+
+ }
+
+}
\ No newline at end of file |