<?php
/***************************************
* Description:
* Autor: Robert Šmalc
* Created date: 09.03.2016
*****************************************/
namespace App\Controllers;
// Osnovni razredi
use App\Controllers\StatisticController as Statistic;
use App\Controllers\Vprasanja\VprasanjaController as Vprasanja;
use App\Controllers\LanguageController as Language;
use App\Models\Model;
use Common;
use Branching;
use SurveyAdvancedParadataLog;
use SurveySetting;
use MailAdapter;
use GDPR;
use AppSettings;
use SurveyEmailAccess;
class AjaxController extends Controller
{
//ajax zahteve
public function __construct(){
if(empty($_GET['a'])){
return '';
}
// inicializiramo jezik za multilang anketo
Language::getInstance()->multilang_init();
if ($_GET['a'] == 'accept_droppable') {
$this->ajax_accept_droppable();
}
elseif ($_GET['a'] == 'accept_ranking') {
$this->ajax_accept_ranking();
}
elseif ($_GET['a'] == 'accept_dragdrop1') {
$this->ajax_accept_dragdrop1();
}
elseif ($_GET['a'] == 'get_dragdrop1_data') {
$this->ajax_get_dragdrop1_data();
}
elseif ($_GET['a'] == 'delete_dragdrop1_data') {
$this->ajax_delete_dragdrop1_data();
}
elseif ($_GET['a'] == 'delete_dragdrop2_data') {
$this->ajax_delete_dragdrop2_data();
}
elseif ($_GET['a'] == 'accept_dragdrop_grid') {
$this->ajax_accept_dragdrop_grid();
}
elseif ($_GET['a'] == 'accept_sortable_ranking') {
$this->ajax_accept_sortable_ranking();
}
elseif ($_GET['a'] == 'edit_size') {
$this->ajax_edit_size();
}
elseif ($_GET['a'] == 'dodaj_ime') {
$this->ajax_dodaj_ime();
}
elseif ($_GET['a'] == 'spol') {
$this->ajax_glasovanje_spol();
}
elseif ($_GET['a'] == 'vote_spol') {
$this->ajax_glasovanje_vote_spol();
}
elseif ($_GET['a'] == 'captcha') {
$this->ajax_captcha();
}
elseif ($_GET['a'] == 'skin') {
$this->ajax_skin();
}
elseif ($_GET['a'] == 'grupa_for_if') {
$this->ajax_grupa_for_if();
}
elseif ($_GET['a'] == 'enable_comments') {
$this->ajax_enable_comments();
}
elseif ($_GET['a'] == 'continue_later') {
$this->ajax_continue_later();
}
elseif ($_GET['a'] == 'continue_later_send') {
$this->ajax_continue_later_send();
}
elseif ($_GET['a'] == 'usr_id_data') {
$this->ajax_delete_signature_data();
}
elseif ($_GET['a'] == 'get_tip_opozorila') {
$this->ajax_get_tip_opozorila();
}
// genericna resitev za vse nadaljne
else {
$ajax = 'ajax_' . $_GET['a'];
if (method_exists($this, $ajax))
return $this->$ajax ();
else
echo 'method ' . $ajax . ' does not exist';
}
}
/************************************************
* Get instance
************************************************/
private static $_instance;
public static function getInstance()
{
if (self::$_instance)
return self::$_instance;
return new AjaxController();
}
public function ajax_delete_signature_data()
{
$usr_id = $_POST['usr_id'];
$anketa = $_POST['anketa'];
$spr_id = $_POST['spr_id'];
$vre_id = $_POST['vre_id'];
//$sqlsignaturefilename = sisplet_query("SELECT filename FROM srv_data_upload WHERE usr_id = '" . $usr_id . "'");
$sqlsignaturefilename = sisplet_query("SELECT filename FROM srv_data_upload WHERE usr_id = '" . $usr_id . "' AND code = '" . $spr_id . "' ");
if (mysqli_num_rows($sqlsignaturefilename) > 0) {
$rowSignatureFilename = mysqli_fetch_array($sqlsignaturefilename);
$file_2_delete = $rowSignatureFilename[0];
}
//echo $file_2_delete;
//$path = self::$site_url.'main/survey/uploads/'.$file_2_delete; //tale varianta ne omogoča brisanje na disku
$path = survey_path('uploads/' . $file_2_delete);
//echo $path;
if (is_file($path)) { //če slikovna datoteka podpisa obstaja
unlink($path); //zbriši datoteko
}
//sisplet_query("DELETE FROM srv_data_upload WHERE usr_id='" . get('usr_id') . "' AND ank_id='$anketa'");//zbriši iz baze info datoteki podpisa
sisplet_query("DELETE FROM srv_data_upload WHERE usr_id='" . get('usr_id') . "' AND ank_id='$anketa' AND code='$spr_id'");//zbriši iz baze info datoteki podpisa
sisplet_query("DELETE FROM srv_data_text" . get('db_table') . " WHERE usr_id='" . get('usr_id') . "' AND spr_id='$spr_id' AND vre_id='$vre_id'");//zbriši iz baze info o vnesenem imenu
}
// sprememba skina
public function ajax_skin()
{
$mobile = (int)$_GET['mobile'];
setcookie('mobile', $mobile, 0, '/');
header("Location: " . $_SERVER['HTTP_REFERER']);
}
//za izris vprasanj pri antonucci designu 1
public function ajax_edit_size()
{
$spremenljivka = $_POST['spremenljivka'];
$size = $_POST['size'];
//sisplet_query("UPDATE srv_spremenljivka SET size='$size' WHERE id='$spremenljivka'");
for ($i = 0; $i < $size; $i++) {
echo ' <p><input type="text" name="vrednost_' . $spremenljivka . '[]" id="vrednost_' . $spremenljivka . '" size="40" onkeyup="checkBranching();" value=""></p>' . "\n";
}
}
//antonucci design 2
public function ajax_dodaj_ime()
{
$spremenljivka = $_POST['spremenljivka'];
$ime = $_POST['ime'];
//sisplet_query("UPDATE srv_spremenljivka SET size='$size' WHERE id='$spremenljivka'");
echo ' <p><input type="text" value="' . $ime . '" disabled=true name="vrednost_' . $spremenljivka . '[]" id="vrednost_' . $spremenljivka . '" size="40" onkeyup="checkBranching();" value=""></p>' . "\n";
echo ' <p><input type="text" size="40" disabled=true></p>' . "\n";
echo ' <p><input type="text" size="40" disabled=true></p>' . "\n";
echo ' <p><input type="text" size="40" disabled=true></p>' . "\n";
}
public function ajax_accept_droppable()
{
$child = $_POST['child'];
$parent = $_POST['parent'];
if ($parent == 'half2_1') {
//poiscemo usr_id
$sql0 = sisplet_query("SELECT usr_id FROM srv_data_imena WHERE id='$child'");
$row0 = mysqli_fetch_array($sql0);
$usr_id = $row0[0];
//poiscemo najvecji count
$sql = sisplet_query("SELECT MAX(countE) FROM srv_data_imena WHERE (usr_id='" . get('usr_id') . "' AND (emotion=1 AND emotionINT=0))");
if (mysqli_num_rows($sql) > 0) {
$row = mysqli_fetch_array($sql);
$count = $row['MAX(countE)'];
}
$count++;
//update baze
sisplet_query("UPDATE srv_data_imena SET emotion=1, countE='$count' WHERE id='$child'");
} elseif ($parent == 'half2_2') {
//poiscemo usr_id
$sql0 = sisplet_query("SELECT usr_id FROM srv_data_imena WHERE id='$child'");
$row0 = mysqli_fetch_array($sql0);
$usr_id = $row0[0];
//poiscemo najvecji count
$sql = sisplet_query("SELECT MAX(countS) FROM srv_data_imena WHERE (usr_id='" . get('usr_id') . "' AND (social=1 AND socialINT=0))");
if (mysqli_num_rows($sql) > 0) {
$row = mysqli_fetch_array($sql);
$count = $row['MAX(countS)'];
}
$count++;
//update baze
sisplet_query("UPDATE srv_data_imena SET social=1, countS='$count' WHERE id='$child'");
} elseif ($parent == 'half2_3') {
$count = 1;
//update baze
sisplet_query("UPDATE srv_data_imena SET emotionINT=1, countE='$count' WHERE id='$child'");
} elseif ($parent == 'half2_4') {
$count = 1;
//update baze
sisplet_query("UPDATE srv_data_imena SET socialINT=1, countS='$count' WHERE id='$child'");
} //leva stran - brisemo iz baze (emotion)
elseif ($parent == 'half_1') {
//preuredimo ostale counterje
$sql = sisplet_query("SELECT countE, usr_id FROM srv_data_imena WHERE id='$child'");
$row = mysqli_fetch_array($sql);
$counter = $row[0];
$usr_id = $row[1];
$sql1 = sisplet_query("SELECT * FROM srv_data_imena WHERE usr_id='" . get('usr_id') . "' AND (countE > '$counter') ORDER BY countE");
while ($row1 = mysqli_fetch_array($sql1)) {
$count = $row1['countE'];
$count--;
sisplet_query("UPDATE srv_data_imena SET countE='$count' WHERE id='$row1[id]'");
}
//update baze
sisplet_query("UPDATE srv_data_imena SET emotion=0, countE=0 WHERE id='$child'");
} //leva stran - brisemo iz baze (druzenje)
elseif ($parent == 'half_2') {
//preuredimo ostale counterje
$sql = sisplet_query("SELECT countS, usr_id FROM srv_data_imena WHERE id='$child'");
$row = mysqli_fetch_array($sql);
$counter = $row[0];
$usr_id = $row[1];
$sql1 = sisplet_query("SELECT * FROM srv_data_imena WHERE usr_id='" . get('usr_id') . "' AND (countS > '$counter') ORDER BY countS");
while ($row1 = mysqli_fetch_array($sql1)) {
$count = $row1['countS'];
$count--;
sisplet_query("UPDATE srv_data_imena SET countS='$count' WHERE id='$row1[id]'");
}
//update baze
sisplet_query("UPDATE srv_data_imena SET social=0, countS=0 WHERE id='$child'");
} //leva stran - brisemo iz baze (emotionINT)
elseif ($parent == 'half_3') {
//update baze
sisplet_query("UPDATE srv_data_imena SET emotionINT=0, countE=0 WHERE id='$child'");
} //leva stran - brisemo iz baze (druzenjeINT)
elseif ($parent == 'half_4') {
//update baze
sisplet_query("UPDATE srv_data_imena SET socialINT=0, countS=0 WHERE id='$child'");
}
//izpisemo ime v divu po loadu
$sql1 = sisplet_query("SELECT text FROM srv_data_imena WHERE id='$child'");
$value = mysqli_fetch_array($sql1);
echo $value[0];
}
/**
* @desc poskrbi za shranjevanje vrednosti 99,98,97
*/
//zapisovanje v bazo pri ranking dropih (n>k, n=k)
public function ajax_accept_ranking()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$usr_id = $_POST['usr_id'];
$order = $_POST['order'];
// Popravimo da se po ajax-u ohrani jezik
if (isset($_POST['lang_id'])) {
$lang_id = save('lang_id', $_POST['lang_id'], 1);
$file = lang_path($lang_id);
if (@include($file))
$_SESSION['langX'] = lang_path($lang_id, 1);
}
// Napredni parapodatki - za ranking je lažje če je kar tukaj
/*if (SurveyAdvancedParadataLog::getInstance()->paradataEnabled()){
SurveyAdvancedParadataLog::getInstance()->logData(0, $usr_id, 'data change', '', $spremenljivka, $order);
}*/
$exploded = explode('&', $order);
//najprej pobrisemo iz baze vse vnose
sisplet_query("DELETE FROM srv_data_rating WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "'");
//sortiranje (vnos v srv_data_rating)
$i = 1;
foreach ($exploded AS $key) {
$key = str_replace('handle_', '', $key);
$explode = explode('[]=', $key);
if ($explode[1] != 0)
sisplet_query("INSERT INTO srv_data_rating (spr_id, vre_id, usr_id, vrstni_red) VALUES ('$spremenljivka', '$explode[1]', '" . get('usr_id') . "', '$i')");
$i++;
}
Vprasanja::getInstance()->displayVnos($spremenljivka);
echo '<div id="clr" class="clr"></div>';
}
//zapisovanje v bazo in brisanje pri drag drop
public function ajax_accept_dragdrop1()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$vre_id = $_POST['vre_id'];
$usr_id = $_POST['usr_id'];
$anketa = $_POST['anketa'];
$data_calculation = $_POST['data_calculation'];
$tip = $_POST['tip'];
$cat_right = $_POST['cat_right'];
$other_present = $_POST['other_present'];
$other = $_POST['other'];
$row = Model::select_from_srv_spremenljivka($spremenljivka);
//( ( (tip == 1 && other == 0 && cat_right) ) || ( (tip == 2) && (other_present != 0) ) || ( (other != 0) ) )
if (($tip == 1 && $cat_right && $other == 0) || (($tip == 2) && ($other_present != 0)) || (($other != 0))) {
sisplet_query("DELETE FROM srv_data_vrednost" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "'");
}
sisplet_query("INSERT INTO srv_data_vrednost" . get('db_table') . " (spr_id, vre_id, usr_id) VALUES ('$spremenljivka', '$vre_id', '" . get('usr_id') . "')");
}
//asinhrono pobiranje podatkov za ureditev missing
public function ajax_get_dragdrop1_data(){
Model::user_not_lurker();
$anketa = $_GET['anketa'];
$spremenljivka = $_GET['spremenljivka'];
$vre_id = array();
$sql1 = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id='$spremenljivka'");
$num = mysqli_num_rows($sql1);
while ($row1 = mysqli_fetch_array($sql1)) {
array_push($vre_id, $row1['id']);
}
echo json_encode($vre_id);
}
//brisanje odgovorov iz baze pri drag drop
public function ajax_delete_dragdrop1_data()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$usr_id = $_POST['usr_id'];
$vre_id = $_POST['vre_id'];
$anketa = $_POST['anketa'];
sisplet_query("DELETE FROM srv_data_vrednost" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' AND vre_id='$vre_id'");
}
//brisanje odgovorov iz baze pri drag drop, ko imamo missing-e
public function ajax_delete_dragdrop2_data()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$usr_id = $_POST['usr_id'];
$vre_id = $_POST['vre_id'];
$anketa = $_POST['anketa'];
sisplet_query("DELETE FROM srv_data_vrednost" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "'");
}
//zapisovanje v bazo pri drag drop v grid
public function ajax_accept_dragdrop_grid()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$vre_id = $_POST['vre_id'];
$usr_id = $_POST['usr_id'];
$tip = $_POST['tip'];
$anketa = $_POST['anketa'];
$indeks = $_POST['indeks'];
$last_vre_id = $_POST['last_vre_id'];
$cat_right = $_POST['cat_right'];
$vre_id_present = $_POST['vre_id_present'];
//vnesi podatke v bazo
if ($tip == 6) {
sisplet_query("INSERT INTO srv_data_grid" . get('db_table') . " (spr_id, vre_id, usr_id, grd_id) VALUES ('$spremenljivka', '$vre_id', '" . get('usr_id') . "', '$indeks')");
} else if ($tip == 16) {
sisplet_query("INSERT INTO srv_data_checkgrid" . get('db_table') . " (spr_id, vre_id, usr_id, grd_id) VALUES ('$spremenljivka', '$vre_id', '" . get('usr_id') . "', '$indeks')");
}
}
//brisanje odgovorov iz baze pri drag drop - tabela - vec odgovorov
public function ajax_delete_dragdrop_grid_data()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$usr_id = $_POST['usr_id'];
$vre_id = $_POST['vre_id'];
$anketa = $_POST['anketa'];
$indeks = $_POST['indeks'];
//brisi podatke iz baze
sisplet_query("DELETE FROM srv_data_checkgrid" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' AND vre_id='$vre_id' AND grd_id = '$indeks' ");
}
//brisanje odgovorov iz baze pri drag drop
public function ajax_delete_dragdrop_grid_data_1()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$usr_id = $_POST['usr_id'];
$vre_id = $_POST['vre_id'];
$anketa = $_POST['anketa'];
$indeks = $_POST['indeks'];
sisplet_query("DELETE FROM srv_data_grid" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' AND vre_id='$vre_id' AND grd_id = '$indeks'");
}
//
//brisanje odgovorov iz baze pri drag drop grid, ko se klikne gumb Ponastavi
public function ajax_delete_dragdrop_grid_data_reset()
{
Model::user_not_lurker();
$spremenljivka = $_POST['spremenljivka'];
$usr_id = $_POST['usr_id'];
$anketa = $_POST['anketa'];
$tip = $_POST['tip'];
if($tip == 6){
sisplet_query("DELETE FROM srv_data_grid" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' ");
}else if($tip == 16){
sisplet_query("DELETE FROM srv_data_checkgrid" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' ");
}
}
//izpis statistike glede na spol
public function ajax_glasovanje_spol()
{
$spremenljivka = $_POST['spremenljivka'];
$spol = $_POST['spol'];
Statistic::displayStatGlasovanje($spremenljivka, $spol);
}
/**
* preveri, ce je captcha koda pravilno vnesena (preko ajaxa)
*
*/
public function ajax_captcha(){
$text = strtoupper($_GET['text']);
$code = $_GET['code'];
$spr_id = $_GET['spr_id'];
$usr_id = $_GET['usr_id'];
$recaptchaResponse = $_POST['g-recaptcha-response'];
$request = file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=".AppSettings::getInstance()->getSetting('google-secret_captcha')."&response=".$recaptchaResponse);
// zdaj pa zabeleži mail (pred pošiljanjem)
// zdaj pa še v bazi tistih ki so se ročno dodali
if(strstr($request,"true")){
echo '1';
}
else {
echo '0';
}
}
/**
* poisce v kateri grupi/strani se pojavi if za redirect tabov
*
*/
public function ajax_grupa_for_if($parent = 0){
$parent_if = $_POST['parent_if'];
if ($parent > 0) $parent_if = $parent;
ob_start();
$b = new Branching(get('anketa'));
$spr = $b->find_first_in_if($parent_if);
ob_clean();
$row = Model::select_from_srv_spremenljivka($spr);
if ($parent == 0)
echo $row['gru_id'];
return $row['gru_id'];
}
/**
* vklopi komentarje na anketo (v previewu je ta možnost)
*
*/
public function ajax_enable_comments(){
ob_clean();
SurveySetting::getInstance()->Init((int)$_POST['anketa']);
SurveySetting::getInstance()->setSurveyMiscSetting('question_resp_comment', '1');
SurveySetting::getInstance()->setSurveyMiscSetting('question_resp_comment_viewadminonly', '3');
}
public function ajax_continue_later(){
save('lang_id', (int)$_GET['language']);
save('anketa', (int)$_POST['anketa']);
$url = $_POST['url'] . '&return=1';
SurveySetting::getInstance()->Init(get('anketa'));
if (get('lang_id') != null) $_lang = '_' . get('lang_id'); else $_lang = '';
$srv_continue_later_txt = SurveySetting::getInstance()->getSurveyMiscSetting('srvlang_srv_continue_later_txt' . $_lang);
if ($srv_continue_later_txt == '') $srv_continue_later_txt = self::$lang['srv_continue_later_txt'];
$srv_continue_later_email = SurveySetting::getInstance()->getSurveyMiscSetting('srvlang_srv_continue_later_email' . $_lang);
if ($srv_continue_later_email == '') $srv_continue_later_email = self::$lang['srv_continue_later_email'];
$srv_forma_send = SurveySetting::getInstance()->getSurveyMiscSetting('srvlang_srv_forma_send' . $_lang);
if ($srv_forma_send == '') $srv_forma_send = self::$lang['srv_forma_send'];
echo '<div id="continue_later">';
echo '<p>' . $srv_continue_later_txt . ':</p><p class="url">' . $url . '</p>';
echo '<input type="hidden" name="url" id="url" value="' . $url . '">';
echo '<p>' . $srv_continue_later_email . ': <input type="email" name="email" id="email" value="" placeholder="' . self::$lang['srv_email_example2'] . '"> <button class="blue send_later" type="submit" onclick="continue_later_send(\'' . self::$site_url . '\', \'' . get('lang_id') . '\'); return false;">' . $srv_forma_send . '</button></p>';
echo '</div>';
}
public function ajax_continue_later_send(){
global $mysql_database_name;
ob_clean();
$s = self::$lang['srv_continue_later_subject'];
if($mysql_database_name == 'vprasalnikirsrssi')
$t = self::$lang['srv_continue_later_content_rs-rs'] . ': <a href="' . $_POST['url'] . '">' . $_POST['url'] . '</a>';
else
$t = self::$lang['srv_continue_later_content'] . ': <a href="' . $_POST['url'] . '">' . $_POST['url'] . '</a>';
// Podpis
$signature = Common::getEmailSignature();
$t .= $signature;
$mail = $_POST['email'];
if ($mail == '') return;
try {
$MA = new MailAdapter(get('anketa'), $type='alert');
$MA->addRecipients($mail);
$result = $MA->sendMail(stripslashes($t), $s);
}
catch (Exception $e) {
}
}
public function ajax_return_edit_send(){
global $mysql_database_name;
ob_clean();
$s = self::$lang['srv_return_edit_subject'];
$t = self::$lang['srv_return_edit_content'] . ': <a href="' . $_POST['url'] . '">' . $_POST['url'] . '</a>';
// Podpis
$signature = Common::getEmailSignature();
$t .= $signature;
$mail = $_POST['email'];
if ($mail == ''){
echo self::$lang['srv_continue_later_fail'];
return;
}
try {
$MA = new MailAdapter(get('anketa'), $type='alert');
$MA->addRecipients($mail);
$result = $MA->sendMail(stripslashes($t), $s);
}
catch (Exception $e) {
echo self::$lang['srv_continue_later_fail'];
return;
}
echo self::$lang['srv_continue_later_success'];
}
public function ajax_get_tip_opozorila() {
$spr_id = $_POST['spr_id'];
//poberi podatke o na trenutnem obmocju
$sqlR = sisplet_query("SELECT reminder FROM srv_validation WHERE spr_id = $spr_id");
$rowR = mysqli_fetch_assoc($sqlR);
$tip_opozorila = $rowR['reminder'];
echo $tip_opozorila;
}
// Izpisemo seznam starih odgovorov v popup (dodatna nastavitev pri text vprasanju)
public function ajax_show_prevAnswers_all() {
$spremenljivka = $_POST['spremenljivka'];
echo '<h2>'.self::$lang['srv_prevAnswers'].'</h2>';
$sql = sisplet_query("SELECT text FROM srv_data_text" . get('db_table') . " WHERE spr_id='".$spremenljivka."' AND usr_id!='".get('usr_id')."' ORDER BY id DESC");
while($row = mysqli_fetch_array($sql)){
echo '<p>';
echo $row['text'];
echo '</p>';
}
// Gumb zapri
echo '<div class="button_holder">';
echo ' <button class="medium blue" onClick="hide_prevAnswers_all(\''.$spremenljivka.'\'); return false;">'.self::$lang['srv_zapri'].'</button>';
echo '</div>';
echo '<script>
$("#fade").on("click", function() {
hide_prevAnswers_all(\''.$spremenljivka.'\');
});</script>';
}
// Izpisemo seznam starih odgovorov v popup (dodatna nastavitev pri text vprasanju)
public function ajax_show_gdpr_about() {
global $lang;
$anketa = $_POST['anketa'];
$gdpr_settings = GDPR::getSurveySettings($anketa);
echo '<h2>'.$lang['srv_gdpr_survey_gdpr_about'].'</h2>';
if($gdpr_settings['about'] == ''){
$about_array = GDPR::getGDPRInfoArray($anketa);
$about_text = GDPR::getGDPRTextFromArray($about_array, $type='html');
echo $about_text;
}
else{
echo nl2br($gdpr_settings['about']);
}
// Gumb zapri
echo '<div class="button_holder">';
echo ' <button class="medium blue" onClick="hide_gdpr_about(); return false;">'.$lang['srv_zapri'].'</button>';
echo '</div>';
echo '<script>
$("#fade").on("click", function() {
hide_gdpr_about();
});</script>';
}
// Izpisemo popup s pogoji uporabe za modul dostop z emailom (mju)
public function ajax_show_email_access_terms() {
global $lang;
$anketa = $_POST['anketa'];
echo '<h2>'.$lang['user_agreement'].'</h2>';
$sea = new SurveyEmailAccess($anketa);
$terms_text = $sea->getEmailAccessSettings('terms_text');
echo nl2br($terms_text);
// Gumb zapri
echo '<div class="button_holder">';
echo ' <button class="medium blue" onClick="hide_email_access_terms(); return false;">'.$lang['srv_zapri'].'</button>';
echo '</div>';
echo '<script>
$("#fade").on("click", function() {
hide_email_access_terms();
});</script>';
}
// Shranimo vrstni red pri randomizaciji (blokov ali vprasanj)
public function ajax_save_randomization_order() {
$usr_id = mysqli_real_escape_string($GLOBALS['connect_db'], $_POST['usr_id']);
$randomization_type = mysqli_real_escape_string($GLOBALS['connect_db'], $_POST['randomization_type']);
$vrstni_red = stripcslashes($_POST['order']);
$vrstni_red = str_replace('"', "", substr($vrstni_red, 1, -1));
// Random vrstni red VPRASANJ oz. BLOKOV znotraj bloka
// ID bloka znotraj katerega so random elementi
$parent_block_id = mysqli_real_escape_string($GLOBALS['connect_db'], $_POST['parent_block_id']);
$sql = sisplet_query("INSERT INTO srv_data_random_blockContent
(usr_id, block_id, vrstni_red)
VALUES
('".$usr_id."', '".$parent_block_id."', '".$vrstni_red."')
ON DUPLICATE KEY UPDATE vrstni_red='".$vrstni_red."'
");
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
}
}
