anketa = $anketa;
SurveyInfo::getInstance()->SurveyInit($anketa);
$this->db_table = SurveyInfo::getInstance()->getSurveyArchiveDBString();
}
function Ajax() {
switch ($_GET['a']) {
case 'showQuestionRecode':
$this->showQuestionRecode();
break;
case 'saveQuestionRecode':
$this->saveQuestionRecode();
break;
case 'removeQuestionRecode':
$this->removeQuestionRecode();
break;
case 'add_new_numeric':
$this->addNewNumeric();
break;
case 'changeRecodeType':
$this->changeRecodeType();
break;
case 'recodeSpremenljivkaNew':
$this->recodeSpremenljivkaNew();
break;
case 'recodeVrednostNew':
$this->recodeVrednostNew();
break;
case 'runRecodeVredonosti':
$this->runRecodeVredonosti();
break;
case 'removeSpremenljivka':
$this->removeSpremenljivka();
break;
case 'enableRecodeVariable':
$this->enableRecodeVariable();
break;
case 'visibleRecodeVariable':
$this->visibleRecodeVariable();
break;
default:
print_r("
Class:SurveyRecoding");
print_r($_POST);
print_r($_GET);
exit();
break;
}
}
function DisplaySettings() {
global $lang;
echo '
';
$this->DisplayDashboard();
}
function showQuestionRecode() {
global $lang;
$spr_id = $_POST['spr_id'];
if ((int)$spr_id > 0 && (int)$this->anketa > 0) {
$qry_str = "SELECT naslov, variable FROM srv_spremenljivka WHERE id = '$spr_id'";
$qry = sisplet_query($qry_str);
$spr_row = mysqli_fetch_assoc($qry);
echo '
';*/
return true;
}
return false;
}
function removeSpremenljivka() {
$spr_id = (int)$_POST['spr_id'];
if ($spr_id > 0) {
$s = sisplet_query("DELETE FROM srv_spremenljivka WHERE id = '$spr_id'");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
}
}
function DisplayDashboard() {
global $lang;
# zloopamo skozi vse spremenljivke
$qry_str = "SELECT s.id, s.tip, s.variable, s.naslov FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$this->anketa' ORDER BY g.vrstni_red ASC, s.vrstni_red ASC";
$sql = sisplet_query($qry_str);
$all_recoded = array();
if (mysqli_num_rows($sql) > 0) {
while (list($spr_id, $tip, $variable, $naslov) = mysqli_fetch_row($sql)) {
# preverimo ali je rekodirana v novo spremenljivko
# preverimo ali imamo rekodiranje v novo spremenljivko, če ja, kasneje ponudimo tud izbris psremenljivke
$qry = sisplet_query("SELECT to_spr_id, usr_id, rec_date FROM srv_recode_spremenljivka WHERE ank_id = '".$this->anketa."' AND spr_id = '".$spr_id."'");
list($to_spr_id,$usr_id,$rec_date) = mysqli_fetch_row($qry);
if ((int)$to_spr_id > 0) {
$row_to_spr_id = Cache::srv_spremenljivka($to_spr_id);
$sel = "select count(*) from srv_recode_vrednost where ank_id = '".$this->anketa."' AND spr1 = '$spr_id' GROUP BY spr1";
$qry = sisplet_query($sel);
list($cnt1) = mysqli_fetch_row($qry);
if ((int)$cnt1 > 0) {
$all_recoded[] = array('txt'=>sprintf($lang['srv_recode_summary_new_spr'],$variable, $row_to_spr_id['variable'],strip_tags($row_to_spr_id['naslov']),(int)$cnt1),'usr_id'=>$usr_id,'rec_date'=>$rec_date);
}
# lahko da je numerična
$sel = "select count(*) from srv_recode_number where ank_id = '".$this->anketa."' AND spr_id = '$spr_id'";
$qry = sisplet_query($sel);
list($cnt1) = mysqli_fetch_row($qry);
if ((int)$cnt1 > 0) {
$all_recoded[] = array('txt'=>sprintf($lang['srv_recode_summary_new_spr'],$variable, $row_to_spr_id['variable'],strip_tags($row_to_spr_id['naslov']),(int)$cnt1),'usr_id'=>$usr_id,'rec_date'=>$rec_date);
}
} else {
$strSelect = "SELECT count(*) FROM srv_recode WHERE ank_id = '".$this->anketa."' AND spr_id = '$spr_id' GROUP BY spr_id";
$qry = sisplet_query($strSelect);
list($cnt2) = mysqli_fetch_row($qry);
if ((int)$cnt2 > 0) {
$all_recoded[] = array('txt'=>sprintf($lang['srv_recode_summary_same_spr'],$variable,(int)$cnt2),'usr_id'=>$usr_id,'rec_date'=>$rec_date);
}
}
}
}
if (count($all_recoded) == 0) {
echo $lang['srv_recode_summary_nothing'];
}
else {
#var_dump($all_recoded);#
echo '+ '.$lang['srv_recode_summary'].'';
echo '- '.$lang['srv_recode_summary'].'';
echo '
';
}
echo '';
}
function recalculateRecode() {
# pobrišemo vse obstoječe zamenjane vrednosti ankete
#$strDel = "DELETE FROM srv_data_vrednost".$this->db_table." WHERE spr_id IN (SELECT to_spr_id from srv_recode_spremenljivka where ank_id = '".$this->anketa."')";
#posodobljen query.. zdaj bi moglo letel :)
$strDel = "DELETE sdv.* FROM srv_data_vrednost".$this->db_table." AS sdv INNER JOIN srv_recode_spremenljivka AS srs ON sdv.spr_id = srs.to_spr_id WHERE srs.ank_id = '".$this->anketa."'";
$qD = sisplet_query($strDel);
if (!$qD) echo mysqli_error($GLOBALS['connect_db']);
sisplet_query("COMMIT");
# najprej za katagorialne
#updejtamo samo tiste katere so omogočene
$sel = "select spr1,vre1,spr2,vre2 from srv_recode_vrednost WHERE ank_id = '".$this->anketa."' AND spr2 IN( SELECT to_spr_id from srv_recode_spremenljivka where ank_id = '".$this->anketa."' AND enabled='1' AND recode_type IN ('0','1'))";
$qry = sisplet_query($sel);
while (list($spr1, $vre1, $spr2, $vre2) = mysqli_fetch_row($qry)) {
# podvojimo polja za novo variablo za vse userje in loope z novimi vrednostmi
$insert = "INSERT INTO srv_data_vrednost".$this->db_table." (spr_id,vre_id,usr_id,loop_id)"
." (SELECT \"$spr2\",\"$vre2\",usr_id,loop_id FROM srv_data_vrednost".$this->db_table." WHERE spr_id='$spr1' AND vre_id='$vre1')"
." ON DUPLICATE KEY UPDATE vre_id=\"$vre2\"";
$qryI = sisplet_query($insert);
sisplet_query("COMMIT");
}
# potem še za numerične
$_operators = array( # operatorji
'0'=>'==', # ==
'1'=>'<>', # <>
'2'=>'<', # <
'3'=>'>', # >
'4'=>'<=', # <=
'5'=>'>=', # >=
'6'=>'interval' # interval
);
#updejtamo samo tiste katere so omogočene
$sprMapping = array();
$selS ="SELECT spr_id, to_spr_id from srv_recode_spremenljivka where ank_id = '".$this->anketa."' AND enabled='1' AND recode_type='1'";
$qryS = sisplet_query($selS);
while ($rowS = mysqli_fetch_assoc($qryS)) {
$sprMapping[$rowS['spr_id']] = $rowS['to_spr_id'];
}
$sel = "select * from srv_recode_number WHERE ank_id = '".$this->anketa."' AND spr_id IN( SELECT spr_id from srv_recode_spremenljivka where ank_id = '".$this->anketa."' AND enabled='1' AND recode_type='1') ORDER BY spr_id, vrstni_red";
$qry = sisplet_query($sel);
while ($row = mysqli_fetch_assoc($qry)) {
if($row['operator'] != '6') {
$selU = "SELECT ".$sprMapping[$row['spr_id']].", ".$row['vred_id'].", usr_id, loop_id FROM srv_data_text".$this->db_table." WHERE spr_id='$row[spr_id]' AND vre_id='0' AND text ".$_operators[$row['operator']]." $row[search]";
} else {
$_search = explode(',',$row['search']);
$selU = "SELECT ".$sprMapping[$row['spr_id']].", ".$row['vred_id'].", usr_id, loop_id FROM srv_data_text".$this->db_table." WHERE spr_id='$row[spr_id]' AND vre_id='0' AND text BETWEEN ".(int)$_search[0]." AND ".(int)$_search[1];
}
$insert = "INSERT INTO srv_data_vrednost".$this->db_table." (spr_id,vre_id,usr_id,loop_id) ($selU) ON DUPLICATE KEY UPDATE vre_id='".$row['vred_id']."'";
$qryI = sisplet_query($insert);
sisplet_query("COMMIT");
}
unset($_SESSION['showRunRecodeButton'][$this->anketa]);
session_commit();
Common::updateEditStamp();
}
}
?>