'; # id="surveyNavigation"
}
// Prikazemo drugi nivo navigacije
private function secondNavigation(){
global $lang, $site_url, $admin_type;
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
# ajaxa se poslje skupaj z ajaxom, da ob updatu vemo kaksen 'a' je bil na originalni strani
# (drugace se ob updatu z ajaxom informacija o 'a'ju zgubi)
$get = $_GET['a'];
if (isset ($_GET['ajaxa']))
$get = $_GET['ajaxa'];
if (trim($get) == '') {
$get = A_BRANCHING;
}
//*** druga vrstica navigacije ***//
echo '
}
}
// Prikazemo dodaten tretji nivo navigacije po potrebi
private function thirdNavigation(){
global $global_user_id;
$podstran = '';
if($_GET['a'] == 'theme-editor'){
$podstran = 'theme-editor';
}
elseif($_GET['a'] == A_COLLECT_DATA_EXPORT){
$podstran = 'export';
}
elseif($_GET['a'] == A_HIERARHIJA && ($_GET['m'] == M_ANALIZE)){
$podstran = 'means';
}
// Zavihki TESTIRANJE
elseif($_GET['a'] == 'testiranje' && $_GET['m'] == 'predvidenicas'){
$podstran = 'ocena_trajanja';
}
elseif($_GET['a'] == 'testiranje' && $_GET['m'] == 'cas'){
$podstran = 'dejanski_casi';
}
elseif($_GET['a'] == 'komentarji_anketa'){
$podstran = 'komentarji_anketa';
}
elseif($_GET['a'] == 'komentarji'){
$podstran = 'komentarji';
}
// Zavihki PODATKI
elseif($_GET['a'] == 'data'){
if(!isset($_GET['m']) || $_GET['m'] == 'view'){
$podstran = 'data';
}
elseif($_GET['m'] == 'quick_edit'){
$podstran = 'quick_edit';
}
elseif($_GET['m'] == 'variables'){
$podstran = 'variables';
}
}
// Zavihki ANALIZA
elseif($_GET['a'] == 'analysis' && $_GET['m'] != 'anal_arch' && $_GET['m'] != 'vizualizacija'){
if (isset($_GET['podstran'])) {
$podstran = $_GET['podstran'];
}
else if (isset($_POST['podstran'])) {
$podstran = $_POST['podstran'];
}
else if (isset($_GET['m'])) {
$podstran = $_GET['m'];
}
else {
$podstran = M_ANALYSIS_SUMMARY;
}
}
// Zavihki STATUS
elseif($_GET['a'] == 'reporti'){
$podstran = 'status';
}
elseif($_GET['a'] == 'usable_resp'){
$podstran = 'usable_resp';
}
elseif($_GET['a'] == 'AAPOR'){
$podstran = 'aapor';
}
elseif($_GET['a'] == 'reminder_tracking'){
$podstran = 'reminder_tracking';
}
elseif($_GET['a'] == 'para_graph'){
$podstran = 'para_graph';
}
elseif($_GET['a'] == 'nonresponse_graph'){
$podstran = 'para_analysis_graph';
}
// Izrisemo ustrezen meni, ce je prisoten
if($podstran != ''){
SurveyStatusProfiles::Init($this->anketa, $global_user_id);
$SSH = new SurveyStaticHtml($this->anketa);
$SSH->displayTopSettings($podstran);
}
}
// Pohendla prikazovanje vsebine ankete
private function displayAnketa(){
global $global_user_id;
// Prikazemo meni na levi po potrebi glede na podstran
$this->displayLeftMenu();
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
if(!$userAccess->checkUserAccess()){
$userAccess->displayNoAccess();
return;
}
// Prikazemo glavni del urejanja ankete
$this->displayAnketaMain();
}
// Prikazemo glavni del urejanja ankete
private function displayAnketaMain(){
echo '
';
// Ustrezno redirectamo anketo na ustrezno stran
if ($_GET['a'] == 'redirectLink') {
// Preverimo, če gre za anketo, ki vsebuje hierarhijo
unset($_SESSION['hierarhija'][$this->anketa]);
if(SurveyInfo::checkSurveyModule('hierarhija', $this->anketa))
$_SESSION['hierarhija'][$this->anketa]['type'] = \Hierarhija\HierarhijaHelper::preveriTipHierarhije($this->anketa);
$this->redirectLink();
}
// Kreira arhiv
elseif ($_GET['a'] == 'backup_create') {
$sas = new SurveyAdminSettings();
$sas->backup_create();
}
// Skopira anketo na drugo stran
elseif ($_GET['a'] == 'anketa_copy') {
$sas = new SurveyAdminSettings();
$sas->anketa_copy();
}
// Restore ankete
elseif ($_GET['a'] == 'backup_restore') {
$sas = new SurveyAdminSettings();
$sas->backup_restore();
}
// Prikazemo arhive
elseif(in_array($_GET['a'], ['arhivi', 'tracking', 'tracking-hierarhija'])){
$this->displayAnketaTabArhiv();
}
// Prikazemo vsebino glede na zavihek
else{
switch($this->first_action){
// Zavihek status
case NAVI_STATUS:
$this->displayAnketaTabStatus();
break;
// Zavihek urejanje
case NAVI_UREJANJE:
$this->displayAnketaTabUrejanje();
break;
// Zavihek testiranje
case NAVI_TESTIRANJE:
$this->displayAnketaTabTestiranje();
break;
// Zavihek objava
case NAVI_OBJAVA:
$this->displayAnketaTabObjava();
break;
// Zavihek podatki
case NAVI_RESULTS:
$this->displayAnketaTabPodatki();
break;
// Zavihek analize
case NAVI_ANALYSIS:
$this->displayAnketaTabAnalize();
break;
// Zavihek hierarhija
case NAVI_HIERARHIJA:
$this->displayAnketaTabHierarhija();
break;
default:
break;
}
}
echo '
';
}
// Prikazemo levi meni po potrebi
private function displayLeftMenu(){
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
// Levi meni v nastavitvah ankete
if ($_GET['a'] == 'nastavitve'
|| $_GET['a'] == 'urejanje'
|| $_GET['a'] == 'alert'
|| $_GET['a'] == 'dostop'
|| $_GET['a'] == 'jezik'
|| $_GET['a'] == 'osn_pod'
|| $_GET['a'] == 'piskot'
|| $_GET['a'] == 'trajanje'
|| $_GET['a'] == 'forma'
|| $_GET['a'] == 'metadata'
|| $_GET['a'] == 'mobile_settings'
|| $_GET['a'] == A_PRIKAZ
|| $_GET['a'] == A_MISSING
|| $_GET['a'] == A_SKUPINE
|| $_GET['a'] == A_EXPORTSETTINGS
|| $_GET['a'] == A_GDPR
|| $_GET['a'] == 'uporabnost'
|| ($_GET['a'] == 'hierarhija_superadmin' && $hierarhija_type < 5)
|| $_GET['a'] == 'kviz'
|| $_GET['a'] == 'voting'
|| $_GET['a'] == 'slideshow'
|| $_GET['a'] == 'vnos'
|| $_GET['a'] == A_TELEPHONE
|| $_GET['a'] == A_CHAT
|| $_GET['a'] == A_PANEL
|| $_GET['a'] == A_FIELDWORK
|| $_GET['a'] == A_MAZA
|| $_GET['a'] == A_WPN
|| $_GET['a'] == 'social_network'
|| $_GET['a'] == A_360
|| $_GET['a'] == A_360_1KA
|| $_GET['a'] == 'evoli'
|| $_GET['a'] == 'evoli_teammeter'
|| $_GET['a'] == 'evoli_quality_climate'
|| $_GET['a'] == 'evoli_teamship_meter'
|| $_GET['a'] == 'evoli_organizational_employeeship_meter'
|| $_GET['a'] == 'evoli_employmeter'
|| $_GET['a'] == 'mfdps'
|| $_GET['a'] == 'borza'
|| $_GET['a'] == 'mju'
|| $_GET['a'] == 'excell_matrix'
|| $_GET['a'] == 'advanced_paradata'
|| $_GET['a'] == 'json_survey_export'
){
echo '
isAnketar ? ' style="display:none;"' : '').'>';
echo '
';
$this->showGlobalSettingsLinks();
echo '
';
if ($this->survey_type > 1) {
echo '
isAnketar ? ' style="display:none;"' : '').'>';
$this->showAdvancedModulesLinks();
echo '
';
}
echo '
isAnketar ? ' style="display:none;"' : '').'>';
$this->showAdditionalSettingsLinks();
echo '
';
echo '
';
}
// Uvoz podatkov levi meni
elseif ($_GET['a'] == A_COLLECT_DATA && in_array($_GET['m'], ['append', 'merge', 'upload_xls', 'append_xls'])) {
echo '
';
echo '
';
$this->showImportLinks();
echo '
';
echo '
';
}
// Kalkulacija podatkov levi meni
elseif ($_GET['a'] == A_COLLECT_DATA && in_array($_GET['m'], ['calculation', 'coding_auto', 'coding', M_COLLECT_DATA_RECODING])) {
echo '
';
echo '
';
$this->showcalculationsLinks();
echo '
';
echo '
';
}
// Izvoz podatkov levi meni
elseif ($_GET['a'] == A_COLLECT_DATA_EXPORT) {
echo '
';
echo '
';
$this->showExportLinks();
echo '
';
echo '
';
}
// Arhiv levi meni
elseif(in_array($_GET['a'], ['arhivi', 'tracking', 'tracking-hierarhija']) || in_array($_GET['m'], ['anal_arch', 'view_archive'])){
echo '
';
echo '
';
$SSH = new SurveyStaticHtml($this->anketa);
$SSH->displayArchiveNavigation();
echo '
';
echo '
';
}
}
private function displayAnketaTabStatus(){
// Osnovni statusi
if ($_GET['a'] == A_REPORTI) {
Common::deletePreviewData($this->anketa);
$ss = new SurveyStatistic();
$ss->Init($this->anketa);
echo '
';
$ss->Display();
echo '
';
}
// prikaze reporte
elseif ($_GET['a'] == 'AAPOR') {
$ss = new SurveyStatistic();
$ss->Init($this->anketa);
echo '
';
$ss->DisplayAaporCalculations();
echo '
';
}
// prikaze grafe neodgovorov
elseif ($_GET['a'] == A_NONRESPONSE_GRAPH) {
echo '
';
$SPA = new SurveyParaAnalysis($this->anketa);
$SPA->DisplayGraph();
echo '
';
}
// prikaze stevilo neodgovorov za posamezne respondente
elseif ($_GET['a'] == A_USABLE_RESP) {
echo '
';
$SUR = new SurveyUporabnost($this->anketa);
$SUR->displayUporabnost();
echo '
';
}
// prikaze modul kakovost
elseif ($_GET['a'] == A_KAKOVOST_RESP) {
echo '
';
$SUR = new SurveyKakovost($this->anketa);
$SUR->displayKakovost();
echo '
';
}
// Prikaze analizo hitrosti respondenta
elseif ($_GET['a'] == A_SPEEDER_INDEX) {
echo '
';
$SUR = new SurveySpeedIndex($this->anketa);
$SUR->displaySpeedIndex();
echo '
';
}
// prikaze stevilo znakov v anketi, stevilo besed...
elseif ($_GET['a'] == A_TEXT_ANALYSIS) {
echo '
';
$STA = new SurveyTextAnalysis($this->anketa);
$STA->displayTable();
echo '
';
}
// analize editiranja
elseif ($_GET['a'] == A_EDITS_ANALYSIS) {
$sea = new SurveyEditsAnalysis($this->anketa);
echo '
';
$sea->displayTable();
echo '
';
}
// prikaze analizo lokacij na podlagi ip stevilk
elseif ($_GET['a'] == A_GEOIP_LOCATION) {
echo '
';
$STA = new SurveyGeoIP($this->anketa);
$STA->displayData();
echo '
';
}
// prikaze analizo opozoril
elseif ($_GET['a'] == A_REMINDER_TRACKING) {
echo '
';
$SRT = new SurveyReminderTracking($this->anketa);
$SRT->displayTable();
echo '
';
}
// prikaze analizo anket za evalvacijo (ul)
elseif ($_GET['a'] == A_UL_EVALVATION) {
$EVAL = new Evalvacija($this->anketa);
$EVAL->displayStats();
}
// prikaze grafe parapodatkov (js, device type, browser...)
elseif ($_GET['a'] == A_PARA_GRAPH) {
echo '
';
$SPG = new SurveyParaGraph($this->anketa, $skipInit = true);
$SPG->DisplayParaGraph($this->anketa);
echo '
';
}
// prikaze reporte
elseif ($_GET['a'] == 'langStatistic') {
$ss = new SurveyStatistic();
$ss->Init($this->anketa);
echo '
';
$ss->DisplayLangStatistic();
echo '
';
}
}
private function displayAnketaTabUrejanje(){
// Prikaze branching
if ($_GET['a'] == 'branching' || !isset($_GET['a']) || $_GET['a'] == '') {
$bn = new Branching($this->anketa);
$bn->display_new();
return;
}
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
echo '
';
// Prikaze nastavitve
if ($_GET['a'] == 'nastavitve'
|| $_GET['a'] == 'urejanje'
|| $_GET['a'] == 'dostop'
|| $_GET['a'] == 'jezik'
|| $_GET['a'] == 'osn_pod'
|| $_GET['a'] == 'piskot'
|| $_GET['a'] == 'trajanje'
|| $_GET['a'] == 'forma'
|| $_GET['a'] == 'metadata'
|| $_GET['a'] == 'mobile_settings'
|| $_GET['a'] == A_PRIKAZ
|| $_GET['a'] == A_EXPORTSETTINGS
|| $_GET['a'] == A_GDPR
) {
$sas = new SurveyAdminSettings();
$sas->anketa_nastavitve_global();
}
elseif ($_GET['a'] == 'prevajanje' || $_GET['a'] == 'prevajanje2') {
$p = new Prevajanje($this->anketa);
$p->prevajaj();
}
elseif ($_GET['a'] == 'tema') {
$st = new SurveyTheme($this->anketa);
$st->displayGroup();
}
elseif ($_GET['a'] == 'theme-editor') {
$ste = new SurveyTheme($this->anketa);
$ste->displayEditing();
}
// nastavitve manjkajočih vrednosti za anketos
elseif ($_GET['a'] == A_MISSING) {
$smv = new SurveyMissingValues($this->anketa);
$smv->displayMissingForSurvey();
}
// skupine respondentov
elseif ($_GET['a'] == A_SKUPINE) {
$ss = new SurveySkupine($this->anketa);
$ss->displayEdit();
}
// prikaze nastavitve za obvescanje
elseif ($_GET['a'] == 'alert') {
$sas = new SurveyAdminSettings();
$sas->alert_nastavitve();
}
// Prikaze urejanje teme
elseif ($_GET['a'] == 'edit_css') {
$sas = new SurveyAdminSettings();
$sas->anketa_editcss();
}
// Napredni moduli
elseif ($_GET['a'] == 'uporabnost'
|| ($_GET['a'] == 'hierarhija_superadmin' && $hierarhija_type < 5)
|| $_GET['a'] == 'kviz'
|| $_GET['a'] == 'voting'
|| $_GET['a'] == 'slideshow'
|| $_GET['a'] == 'vnos'
|| $_GET['a'] == A_TELEPHONE
|| $_GET['a'] == A_CHAT
|| $_GET['a'] == A_PANEL
|| $_GET['a'] == A_FIELDWORK
|| $_GET['a'] == A_MAZA
|| $_GET['a'] == A_WPN
|| $_GET['a'] == 'social_network'
|| $_GET['a'] == A_360
|| $_GET['a'] == A_360_1KA
|| $_GET['a'] == 'evoli'
|| $_GET['a'] == 'evoli_teammeter'
|| $_GET['a'] == 'evoli_quality_climate'
|| $_GET['a'] == 'evoli_teamship_meter'
|| $_GET['a'] == 'evoli_organizational_employeeship_meter'
|| $_GET['a'] == 'evoli_employmeter'
|| $_GET['a'] == 'mfdps'
|| $_GET['a'] == 'borza'
|| $_GET['a'] == 'mju'
|| $_GET['a'] == 'excell_matrix'
|| $_GET['a'] == 'advanced_paradata'
|| $_GET['a'] == 'json_survey_export'
) {
$sas = new SurveyAdminSettings();
$sas->showAdvancedModules();
}
echo '
';
}
private function displayAnketaTabTestiranje(){
if ($_GET['a'] == 'komentarji') {
$sas = new SurveyAdminSettings();
$sas->testiranje_komentarji();
}
elseif ($_GET['a'] == 'komentarji_anketa') {
$sas = new SurveyAdminSettings();
$sas->testiranje_komentarji_anketa();
}
elseif (trim($_GET['m']) == '' || $_GET['m'] == 'diagnostika') {
$sd = new SurveyDiagnostics($this->anketa);
$sd->doDiagnostics();
$sd->displayDiagnostic();
}
elseif ($_GET['m'] == 'predvidenicas' || $_GET['m'] == 'cas') {
$sas = new SurveyAdminSettings();
$sas->tabTestiranje();
}
elseif($_GET['a'] == A_TESTIRANJE) {
$sas = new SurveyAdminSettings();
$sas->tabTestiranje();
}
}
private function displayAnketaTabObjava(){
if ($_GET['a'] == A_VABILA) {
echo '
';
$sas = new SurveyAdminSettings();
$sas->anketa_vabila();
echo '
';
}
elseif ($_GET['a'] == A_INVITATIONS) {
$SI = new SurveyInvitationsNew($this->anketa);
$SI->action($_GET['m']);
}
}
private function displayAnketaTabPodatki(){
// Izvoz podatkov
if ($_GET['a'] == A_COLLECT_DATA_EXPORT) {
if ($_GET['m'] == 'excel_xls_mfdps') {
$mfdps = new SurveyMFDPS($this->anketa);
if (isset($_GET['n']) && $_GET['n'] == 'izv')
$mfdps->executeExportIzvajalci();
else
$mfdps->executeExportPredmeti();
}
elseif ($_GET['m'] == 'excel_xls_mju') {
$mju = new SurveyMJU($this->anketa);
$mju->executeExport();
}
else {
echo '
';
Common::deletePreviewData($this->anketa);
$sas = new SurveyAdminSettings();
$sas->displayIzvozi();
echo '
';
echo '
';
}
}
elseif ($_GET['m'] == '' || $_GET['m'] == 'view' || $_GET['m'] == 'edit' || $_GET['m'] == 'print' || $_GET['m'] == 'monitoring') {
Common::deletePreviewData($this->anketa);
echo '
';
$SDS = new SurveyDataDisplay($this->anketa);
$SDS->displayFilters();
$SDS->displayVnosiHTML();
echo '
'; // div_analiza_data
}
elseif ($_GET['m'] == M_COLLECT_DATA_VARIABLE_VIEW) {
$vv = VariableView::instance();
$vv->init($this->anketa);
$vv->displayVariables();
}
elseif ($_GET['m'] == 'calculation') {
$spp = new SurveyPostProcess($this->anketa);
$spp->displayTab();
}
elseif ($_GET['m'] == 'coding_auto') {
$spp = new SurveyPostProcess($this->anketa);
$spp->displayCodingAuto();
}
elseif ($_GET['m'] == 'coding') {
$spp = new SurveyPostProcess($this->anketa);
$spp->displayCoding();
}
elseif ($_GET['m'] == M_COLLECT_DATA_RECODING) {
$SR = new SurveyRecoding($this->anketa);
$SR->DisplaySettings();
}
elseif ($_GET['m'] == 'quick_edit') {
Common::deletePreviewData($this->anketa);
echo '
';
$SDS = new SurveyDataDisplay($this->anketa);
$SDS->displayQuickEditFilters();
$SDS->displayQuickEdit();
echo '
'; // div_analiza_data
}
elseif ($_GET['m'] == 'append' || $_GET['m'] == 'merge') {
$spp = new SurveyAppendMerge($this->anketa);
$spp->display($_GET['m'] == 'merge' ? true : false);
}
elseif ($_GET['m'] == 'upload_xls') {
$spp = new SurveyAppendMerge($this->anketa);
$spp->upload_xls();
}
elseif ($_GET['m'] == 'append_xls') {
$spp = new SurveyAppendMerge($this->anketa);
$spp->append_xls();
}
elseif ($_GET['m'] == 'evoli') {
// Posebno PDF porocilo za Evoli
// Dobimo usr_id za katerega pripravljamo porocilo
$usr_id = (isset($_GET['usr_id']) && $_GET['usr_id'] > 0) ? $_GET['usr_id'] : 0;
$evoli = new SurveyEvoli($this->anketa);
$evoli->executeExport($usr_id);
}
elseif ($_GET['m'] == 'evoli_employmeter') {
// Posebno PDF porocilo za Evoli
// Dobimo usr_id za katerega pripravljamo porocilo
$usr_id = (isset($_GET['usr_id']) && $_GET['usr_id'] > 0) ? $_GET['usr_id'] : 0;
$em = new SurveyEmployMeter($this->anketa);
$em->executeExport($usr_id);
}
elseif ($_GET['m'] == 'mfdps') {
// Posebno PDF porocilo za MFDPS
// Dobimo usr_id za katerega pripravljamo porocilo
$usr_id = (isset($_GET['usr_id']) && $_GET['usr_id'] > 0) ? $_GET['usr_id'] : 0;
$mfdps = new SurveyMFDPS($this->anketa);
$mfdps->executePDFExport($usr_id);
}
elseif ($_GET['m'] == 'borza') {
// Posebni grafi za BORZA
// Dobimo usr_id za katerega pripravljamo porocilo
$usr_id = (isset($_GET['usr_id']) && $_GET['usr_id'] > 0) ? $_GET['usr_id'] : 0;
$borza = new SurveyBORZA($this->anketa);
$borza->executeChartExport($usr_id);
}
}
private function displayAnketaTabAnalize(){
$this->podstran = isset($_GET['m']) ? $_GET['m'] : M_ANALYSIS_STATISTICS;
// Povprečje pri hierarhiji in onemogočene ostale možnosti
if ($this->podstran == M_ANALYSIS_MEANS_HIERARHY || SurveyInfo::getInstance()->checkSurveyModule('hierarhija')) {
SurveyAnalysis::Init($this->anketa);
$HA = new HierarhijaAnalysis($this->anketa);
$HA->Display();
}
// V kolikor gre za običajno analizo potem prikažemo vse opcije
else {
switch ($this->podstran) {
case M_ANALYSIS_LINKS : // linki za vprašalnik
SurveyAnalysis::Init($this->anketa);
SurveyAnalysis::DisplayReportsLinks();
break;
case M_ANALYSIS_CREPORT : // porocilo po meri
SurveyAnalysis::Init($this->anketa);
SurveyAnalysis::DisplayFilters();
echo '
';
$SCM = new SurveyCustomReport($this->anketa);
$SCM->displayReport();
echo '
';
break;
case M_ANALYSIS_MEANS:
SurveyAnalysis::Init($this->anketa);
$SM = new SurveyMeans($this->anketa);
$SM->Display();
break;
case M_ANALYSIS_TTEST :
SurveyAnalysis::Init($this->anketa);
$STT = new SurveyTTest($this->anketa);
$STT->Display();
break;
case M_ANALYSIS_BREAK :
$SB = new SurveyBreak($this->anketa);
$SB->Display();
break;
case M_ANALYSIS_PARA :
$SPA = new SurveyParaAnalysis($this->anketa);
$SPA->Display();
break;
case M_ANALYSIS_CHARTS :
SurveyChart::Init($this->anketa);
SurveyChart::display();
break;
case M_ANALYSIS_MULTICROSSTABS :
$SMC = new SurveyMultiCrosstabs($this->anketa);
$SMC->display();
break;
// Vizualizacija (R modul)
case M_ANALYSIS_VIZUALIZACIJA :
$sv = new SurveyVizualizacija($this->anketa);
$sv->display();
break;
// 360 stopinjske analize (adecco)
case M_ANALYSIS_360 :
$S360 = new Survey360($this->anketa);
$S360->displayReports();
break;
// 360 stopinjske analize (1ka)
case M_ANALYSIS_360_1KA :
$S360 = new Survey3601ka($this->anketa);
$S360->displayReports();
break;
// HEATMAP
case M_ANALYSIS_HEATMAP :
SurveyHeatMap::Init($this->anketa);
SurveyHeatMap::display($this->spremenljivka);
break;
default:
if (isset($_GET['podstran'])) {
$podstran = $_GET['podstran'];
} else if (isset($_POST['podstran'])) {
$podstran = $_POST['podstran'];
} else if (isset($_GET['m'])) {
$podstran = $_GET['m'];
} else {
$podstran = M_ANALYSIS_SUMMARY;
}
SurveyAnalysis::Init($this->anketa);
SurveyAnalysis::DisplayFilters();
if ($_GET['m'] == M_ANALYSIS_CROSSTAB) {
echo '
';
}
echo '
';
SurveyAnalysis::Display();
echo '
'; // div_analiza_data
break;
}
}
}
private function displayAnketaTabArhiv(){
echo '
';
$sas = new SurveyAdminSettings();
if ($_GET['m'] == 'data') {
$sas->arhivi_data();
}
else if ($_GET['m'] == 'testdata') {
$sas->arhivi_testdata();
}
else if ($_GET['m'] == 'survey' || $_GET['m'] == 'survey_data') {
$sas->arhivi_survey();
}
else if ($_GET['a'] == 'tracking') {
if($_GET['d'] == 'download')
return TrackingClass::init()->filter([20,21,22])->csvExport();
TrackingClass::init()->filter([20,21,22])->trackingDisplay();
}
else if ($_GET['a'] == 'tracking-hierarhija') {
if($_GET['m'] == 'udelezenci') {
if ($_GET['d'] == 'download')
return TrackingClass::init()->filter(22, true)->csvExport();
return TrackingClass::init()->filter(22, true)->trackingDisplay();
}
if ($_GET['d'] == 'download')
return TrackingClass::init()->filter([20,21], true)->csvExport();
return TrackingClass::init()->filter([20,21], true)->trackingDisplay();
}
else {
$sas->arhivi();
}
echo '
';
}
private function displayAnketaTabHierarhija(){
echo '
';
$hir_nav = new \Hierarhija\Hierarhija($this->anketa);
$hir_nav->displayHierarhijaNavigation();
echo '
';
echo '
';
$hierarhija = new \Hierarhija\Hierarhija($this->anketa);
// m=uredi-sifrante
if ($_GET['m'] == M_ADMIN_UREDI_SIFRANTE) {
$hierarhija->hierarhijaSuperadminSifranti();
}
elseif ($_GET['m'] == M_ADMIN_UVOZ_SIFRANTOV) {
$hierarhija->hierarhijaSuperadminUvoz();
}
elseif ($_GET['m'] == M_ANALIZE) {
// V kolikor gre za poročila po meri
if($_GET['r'] == 'custom'){
$HC = new \Hierarhija\HierarhijaPorocilaClass($this->anketa);
$HC->izvoz();
}
else{
$HA = new HierarhijaAnalysis($this->anketa);
$HA->Display();
}
}
elseif ($_GET['m'] == M_ADMIN_AKTIVACIJA) {
$hierarhija->aktivacijaHierarhijeInAnkete();
}
elseif ($_GET['m'] == M_HIERARHIJA_STATUS) {
$hierarhija->statistikaHierjearhije();
}
elseif($_GET['m'] == M_UREDI_UPORABNIKE && $_GET['izvoz'] == 1) {
// za vse ostalo je uredi uporabnike - M_UREDI_UPORABNIKE
\Hierarhija\HierarhijaIzvoz::getInstance($this->anketa)->csvIzvozVsehUporabnikov();
}
else {
// za vse ostalo je ure uredi uporabnike - M_UREDI_UPORABNIKE
$hierarhija->izberiDodajanjeUporabnikovNaHierarhijo();
}
echo '
';
echo '
';
}
function showExportLinks()
{
global $lang;
global $site_url;
global $site_path;
global $admin_type;
global $global_user_id;
if (trim($_GET['m']) == '') {
$_GET['m'] = M_EXPORT_SPSS;
}
echo '
';
}
function showcalculationsLinks(){
global $lang;
global $site_url;
global $site_path;
global $admin_type;
global $global_user_id;
echo '
';
}
function showImportLinks(){
global $lang;
global $site_url;
global $site_path;
global $admin_type;
global $global_user_id;
echo '
';
}
function showGlobalSettingsLinks(){
global $lang;
global $site_url;
global $site_path;
global $admin_type;
global $global_user_id;
$get = $_GET['a'];
$d = new Dostop();
echo '
' . $lang['srv_survey_settings'] . ' ';
echo '
';
}
function showAdditionalSettingsLinks()
{
global $lang;
global $site_url;
global $site_path;
global $admin_type;
global $global_user_id;
$get = $_GET['a'];
$d = new Dostop();
echo '
' . $lang['set_links'] . ' ';
echo '
';
}
// Linki za napredne module
private function showAdvancedModulesLinks()
{
global $lang;
global $site_url;
global $site_path;
global $admin_type;
global $global_user_id;
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
$get = $_GET['a'];
$row = SurveyInfo::getInstance()->getSurveyRow();
$d = new Dostop();
if ($d->checkDostopAktiven()) {
$userAccess = UserAccess::getInstance($global_user_id);
echo '
' . $lang['srv_moduli'] . ' ';
echo '
';
}
}
/**
* prikaze seznam anket in polje za dodajanje na prvi strani
*
*/
private function displaySeznamAnket(){
global $lang, $site_url, $global_user_id, $admin_type, $site_domain;
# naložimo razred z seznamom anket
$SL = new SurveyList();
$SLCount = $SL->countSurveys();
$SLCountPhone = $SL->countPhoneSurveys();
// VSEBINA POSAMEZNEGA TABA PRI MOJIH ANKETAH
echo '
';
// izpis pregledovanja
if ((!isset($_GET['a']) && !isset($_GET['anketa'])) || ($_GET['a'] == 'pregledovanje')) {
if ($SLCount > 0) {
echo '
';
$SL->getSurveys();
echo '
';
}
else {
$newSurvey = new NewSurvey();
if (isset($_GET['b']) && $_GET['b'] == 'new_survey'){
echo '
';
$newSurvey->displayNewSurveyPage();
echo '
';
}
else{
echo '
';
$newSurvey->displayNoSurveySequence();
echo '
';
}
}
}
// Izpis okna za ustvarjanje ankete (enako kot ce nimamo nobene ankete)
if ($_GET['a'] == 'ustvari_anketo') {
echo '
';
$newSurvey = new NewSurvey();
$newSurvey->displayNewSurveyPage();
echo '
';
}
// izpis pregledovanja
if ($_GET['a'] == 'phoneSurveys') {
if ($SLCountPhone > 0) {
echo '
';
$SL->getSurveys();
echo '
';
}
else {
echo '
';
$newSurvey = new NewSurvey();
$newSurvey->displayNewSurveyPage();
echo '
';
}
}
// izpis diagnostike
if ($_GET['a'] == 'diagnostics' && !isset ($_GET['t'])) {
echo '
';
$sa = new SurveyAktivnost();
$sa->diagnostics();
echo '
';
}
// izpis uporabnikov
if ($_GET['a'] == 'diagnostics' && $_GET['t'] == 'uporabniki') {
$sas = new SurveyAdminSettings();
echo '
';
if($_GET['m'] == 'sa-modul') {
$sas->SAuserListIndex();
}
elseif($_GET['m'] == 'izbrisani'){
$sas->deletedUsersList();
}
elseif($_GET['m'] == 'nepotrjeni'){
$sas->unconfirmedMailUsersList();
}
elseif($_GET['m'] == 'odjavljeni'){
$sas->unsignedUsersList();
}
elseif($_GET['m'] == 'all'){
$sas->allUsersList();
}
else {
$sas->assignedUsersList();
}
echo '
';
}
if ($_GET['a'] == 'diagnostics' && $_GET['t'] == 'time_span') {
$sa = new SurveyAktivnost();
echo '
';
$sa->diagnostics_time_span();
echo '
';
}
if ($_GET['a'] == 'diagnostics' && $_GET['t'] == 'time_span_daily') {
$sa = new SurveyAktivnost();
echo '
';
$sa->diagnostics_time_span_daily();
echo '
';
}
if ($_GET['a'] == 'diagnostics' && $_GET['t'] == 'time_span_monthly') {
$sa = new SurveyAktivnost();
echo '
';
$sa->diagnostics_time_span_monthly();
echo '
';
}
if ($_GET['a'] == 'diagnostics' && $_GET['t'] == 'time_span_yearly') {
$sa = new SurveyAktivnost();
echo '
';
$sa->diagnostics_time_span_yearly();
echo '
';
}
if ($_GET['a'] == 'diagnostics' && $_GET['t'] == 'paradata') {
$sa = new SurveyAktivnost();
echo '
';
$sa->diagnostics_paradata();
echo '
';
}
// izpis nastavitev
if ($_GET['a'] == 'nastavitve') {
echo '
';
if (($_GET['m'] == 'system' || $_GET['m'] == '')) {
$sas = new SurveyAdminSettings();
$sas->anketa_nastavitve_system();
}
if ($_GET['m'] == 'predvidenicasi' && $this->user_role_cehck(U_ROLE_ADMIN)) {
$sas = new SurveyAdminSettings();
$sas->anketa_nastavitve_predvidenicasi();
}
if ($_GET['m'] == 'global') {
$sas = new SurveyAdminSettings();
$sas->anketa_nastavitve_global();
}
if ($_GET['m'] == 'nice_links' && $this->user_role_cehck(U_ROLE_ADMIN)) {
$sas = new SurveyAdminSettings();
$sas->anketa_nice_links();
}
if ($_GET['m'] == 'anketa_admin' && $this->user_role_cehck(U_ROLE_ADMIN)) {
$sas = new SurveyAdminSettings();
$sas->anketa_admin();
}
if ($_GET['m'] == 'anketa_deleted' && $this->user_role_cehck(U_ROLE_ADMIN)) {
$sas = new SurveyAdminSettings();
$sas->anketa_deleted();
}
if ($_GET['m'] == 'data_deleted' && $this->user_role_cehck(U_ROLE_ADMIN)) {
$sas = new SurveyAdminSettings();
$sas->data_deleted();
}
if ($_GET['m'] == 'global_user_settings') {
$sas = new SurveyAdminSettings();
$sas->globalUserSettings();
}
if ($_GET['m'] == 'global_user_myProfile') {
$sas = new SurveyAdminSettings();
$sas->globalUserMyProfile();
}
echo '
';
}
if ($_GET['a'] == 'knjiznica') {
if (!isset ($_GET['t'])) { // zavihek sistemske ankete
$_tab = 2;
$_prva = 1;
}
else if ($_GET['t'] == 'moje_ankete') { // zavihek moje ankete
$_tab = 3;
$_prva = 1;
}
$f = new Library(array('tab' => $_tab, 'prva' => $_prva));
echo '
';
echo '
';
$f->display_folders();
echo '
';
echo '
';
}
// izpis obvestil
if ($_GET['a'] == 'obvestila') {
echo '
';
$NO = new Notifications();
$NO->display();
echo '
';
}
// izpis obvestil
if ($_GET['a'] == 'narocila') {
if($admin_type == 0 && isset($_GET['m']) && $_GET['m'] == 'placila'){
echo '
';
$UP = new UserPlacila();
$UP->displayPlacila();
echo '
';
}
else{
echo '
';
$UN = new UserNarocila();
if($admin_type == 0)
$UN->displayNarocilaTableAdmin();
else
$UN->displayNarocila();
echo '
';
}
}
// nastavitve za gdpr
if ($_GET['a'] == 'gdpr') {
echo '
';
if (!isset($_GET['m']) || $_GET['m'] == 'gdpr_user') {
$gdpr = new GDPR();
$gdpr->displayGDPRUser();
}
elseif ($_GET['m'] == 'gdpr_survey_list') {
$gdpr = new GDPR();
$gdpr->displayGDPRSurveyList();
}
elseif ($_GET['m'] == 'gdpr_requests') {
$gdpr = new GDPR();
$gdpr->displayGDPRRequests();
}
elseif ($_GET['m'] == 'gdpr_requests_all') {
if($admin_type == 0){
$gdpr = new GDPR();
$gdpr->displayGDPRRequestsAll();
}
}
elseif ($_GET['m'] == 'gdpr_dpa') {
$gdpr = new GDPR();
$gdpr->displayGDPRDPA();
}
echo '
';
}
// nastavitve, izvozi... za UL evalvacije
if ($_GET['a'] == 'ul_evalvation') {
if (!isset($_GET['t']) || $_GET['t'] == 'export') {
echo '
';
$EVAL = new Evalvacija();
$EVAL->displayExport();
echo '
';
}
elseif ($_GET['t'] == 'import') {
echo '
';
$EVAL = new Evalvacija();
$EVAL->displayImport();
echo '
';
}
elseif ($_GET['t'] == 'emailing') {
echo '
';
$EVAL = new Evalvacija();
$EVAL->displayEmailing();
echo '
';
}
elseif ($_GET['t'] == 'test') {
echo '
';
$EVAL = new Evalvacija();
$EVAL->displayTestSurveys();
echo '
';
}
elseif ($_GET['t'] == 'gc') {
echo '
';
$GC = new GC();
$GC->displayGC();
echo '
';
}
}
// Konec moje_ankete_edit
echo '
';
}
/**
* vrne kodo ankete, ki se jo uporabi za embed
*
*/
function getEmbed($js = true)
{
global $site_url;
//return '<iframe id="1ka" src="'.$site_url.'main/survey/index.php?anketa='.$this->anketa.'" scrolling="auto" frameborder="0" width="100%"></iframe><script type="text/javascript">function r(){var a=window.location.hash.replace("#","");if(a.length==0)return;document.getElementById("1ka").style.height=a+"px";window.location.hash=""};window.setInterval(\\\'r()\\\',100);</script>';
$iframe = '
';
$javascript = '';
if ($js)
return htmlentities($iframe . $javascript, ENT_QUOTES);
else
return htmlentities($iframe, ENT_QUOTES);
}
function check_online_users(){
global $global_user_id;
global $lang;
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
$sqlx = sisplet_query("SELECT uid FROM srv_dostop WHERE ank_id = '$this->anketa'");
if (mysqli_num_rows($sqlx) <= 1) return;
$sql = sisplet_query("SELECT DISTINCT user FROM srv_tracking".$this->db_table." WHERE ank_id='$this->anketa' AND user != '$global_user_id' AND datetime > NOW() - INTERVAL 15 MINUTE");
if (!$sql) return;
if (mysqli_num_rows($sql) > 0 && $hierarhija_type < 5) {
echo '
';
}
}
function request_help(){
global $lang;
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
if ($hierarhija_type == 10) {
echo '
';
return '';
}
echo '
';
echo '';
echo ' ';
echo '';
$this->request_help_content();
echo ' '; // expanded-tooltip bottom
echo ' '; // request-help
}
function request_help_content(){
global $lang;
$row = SurveyInfo::getInstance()->getSurveyRow();
echo '
' . $lang['srv_dostopmail_1'] . ' ';
$d = new Dostop();
$users = $d->getDostop();
if (is_countable($users[2]) && count($users[2]) > 0) {
echo '
' . $lang['srv_users'] . ': ';
if ($d->checkDostopAktiven()) echo ' (' . $lang['srv_add_edit'] . ' )';
echo '
';
}
if (is_countable($users[1]) && count($users[1]) > 0) {
echo '
' . $lang['managers'] . ': ';
if ($d->checkDostopAktiven()) echo ' (' . $lang['srv_add_edit'] . ' )';
echo '
';
}
echo '
' . $lang['srv_request_help_txt3'] . ' ' . Help::display('help-centre') . '' . $lang['hour_remove'] . ' )';
} else {
echo '' . $lang['srv_dostop_admin'] . ' ';
}
echo '
';
echo '
';
}
function displaySecondNavigationLinks($navigation = 0)
{
global $lang, $site_url;
global $global_user_id;
$row = SurveyInfo::getInstance()->getSurveyRow();
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
if ($navigation == 0) {
# stran status (reporti) ali urejanje
if ($this->first_action == NAVI_UREJANJE || $_GET['a'] == '' || $_GET['a'] == A_REPORTI) {
if ($_GET['a'] == '' || $_GET['a'] == 'branching') {
if ($row['toolbox'] <= 2) {
$row['toolbox'] == 1 ? $preklop = 3 : $preklop = 4;
echo '
';
echo ' ';
} else {
$row['toolbox'] == 3 ? $preklop = 1 : $preklop = 2;
echo '
';
echo ' ';
}
}
$p = new Prevajanje($this->anketa);
global $lang1;
$lang_more = '';
$sqll = sisplet_query("SELECT dostop FROM srv_dostop WHERE ank_id='$this->anketa' AND uid='$global_user_id'");
$rowl = mysqli_fetch_array($sqll);
$dostop = explode(',', $rowl['dostop']);
if (!in_array('edit', $dostop)) {
$sqll = sisplet_query("SELECT lang_id FROM srv_dostop_language WHERE ank_id='$this->anketa' AND uid='$global_user_id'");
if (mysqli_num_rows($sqll) == 1) {
$rowl = mysqli_fetch_array($sqll);
$p->include_lang($rowl['lang_id']);
$lang_more = ' | ' . $lang['lang_short'];
$p->include_base_lang();
}
}
if ($lang_more == '' && isset($_GET['lang_id'])) {
$p->include_lang((int)$_GET['lang_id']);
$lang_more = ' | ' . $lang['lang_short'];
$p->include_base_lang();
}
}
if (($_GET['a'] == A_COLLECT_DATA || $_GET['a'] == A_USABLE_RESP || $_GET['a'] == A_KAKOVOST_RESP || $_GET['a'] == A_SPEEDER_INDEX || $_GET['a'] == A_REMINDER_TRACKING || $_GET['a'] == A_TEXT_ANALYSIS || $_GET['a'] == A_EDITS_ANALYSIS || $_GET['a'] == A_ANALYSIS) && $_GET['m'] != 'analysis_links' && $_GET['m'] != 'anal_arch')
$this->displayExportHover($navigation);
} else if ($navigation == 1) {
# stran status (reporti) ali urejanje
if ($this->first_action == NAVI_UREJANJE || $_GET['a'] == '' || $_GET['a'] == 'reporti') {
// V kolikor imamo hierarhijo potem je tudi možnost kopiranja ankete in hierarhije
if($_GET['a'] == A_HIERARHIJA_SUPERADMIN)
echo '
';
// Uvoz iz besedila
if($this->second_action == NAVI_UREJANJE_BRANCHING || $_GET['a'] == ''){
if($userAccess->checkUserAccess($what='ustvari_anketo_from_text'))
echo '
';
else
echo '
';
}
# kopiranje
echo '
';
# brisanje
echo '
';
if ($this->second_action == NAVI_UREJANJE_BRANCHING || $_GET['a'] == 'reporti' || ($_GET['a'] == A_HIERARHIJA_SUPERADMIN && $_GET['m'] == 'analize'))
$this->displayExportHover($navigation);
}
// Pri komentarjih imamo izvoz pdf/rtf
if ($_GET['a'] == 'komentarji') {
$this->displayExportHover($navigation);
}
}
}
// Ikona in hover div za izvoz
function displayExportHover($navigation){
global $lang, $site_url, $global_user_id, $admin_type;
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
$hidden_icon = (in_array($_GET['m'], array(M_ANALYSIS_CROSSTAB, M_ANALYSIS_MULTICROSSTABS, M_ANALYSIS_MEANS, M_ANALYSIS_TTEST, M_ANALYSIS_BREAK))) ? 'hidden' : '';
echo '
';
echo ' ';
echo '
';
// Javascript s katerim povozimo urlje za izvoze, ki niso na voljo v paketu
global $app_settings;
if($app_settings['commercial_packages'] == true){
echo '';
}
}
function survey_icon_add_comment(){
global $lang, $site_url, $admin_type, $global_user_id;
SurveyInfo::getInstance()->SurveyInit($this->anketa);
$row = SurveyInfo::getInstance()->getSurveyRow();
SurveySetting::getInstance()->Init($this->anketa);
$survey_comment_viewadminonly = SurveySetting::getInstance()->getSurveyMiscSetting('survey_comment_viewadminonly');
$survey_comment_viewauthor = SurveySetting::getInstance()->getSurveyMiscSetting('survey_comment_viewauthor');
$sortpostorder = SurveySetting::getInstance()->getSurveyMiscSetting('sortpostorder');
$view = 1;
$sas = new SurveyAdminSettings();
$survey_comment = SurveySetting::getInstance()->getSurveyMiscSetting('survey_comment');
$userAccess = UserAccess::getInstance($global_user_id);
if (($admin_type <= $survey_comment && $survey_comment != '') or $sas->testiranje_komentarji_komentarji_na_anketo(false) > 0) {
$show_survey_comment = $_GET['show_survey_comment'];
$comment_count = $sas->testiranje_komentarji_count();
$comment_count_text = ($comment_count['survey_admin']['unresolved'] + $comment_count['survey_resp']['unresolved']);
if (($row['forum'] == 0 || $row['thread'] == 0) && $comment_count_text == '0') {
if($userAccess->checkUserAccess('komentarji')){
echo '';
}
else{
echo '';
}
}
else {
$sqlf = sisplet_query("SELECT COUNT(*) AS count FROM post WHERE tid='$row[thread]'");
$rowf = mysqli_fetch_array($sqlf);
$rowf['count']--; //zaradi 1. avtomatskega posta
// Shranimo naslov za js qtip box
$comment_qip_title = $lang['srv_comments_anketa_ured'] .
' (' . $comment_count['survey_admin']['unresolved'] . '/' . $comment_count['survey_admin']['all'] . ')'
. '';
echo '';
if($userAccess->checkUserAccess('komentarji')){
echo '';
}
else{
echo '';
}
}
if($userAccess->checkUserAccess('komentarji'))
echo '';
}
}
/**
* @desc uploada skin
*/
function upload_skin()
{
global $site_path;
global $lang;
global $global_user_id;
if (isset ($_FILES['fajl']['name'])) {
$mini = $_FILES['fajl']['name'];
// skin
if ((strtolower(substr($mini, -4, 4)) == '.css' || (strtolower(substr($mini, -4, 4)) == '.zip'))
&& strpos(strtolower($mini), ".exe") === false
&& strpos(strtolower($mini), ".bat") === false
&& strpos(strtolower($mini), ".com") === false
&& strpos(strtolower($mini), ".vbs") === false
&& strpos(strtolower($mini), ".pl") === false
&& strpos(strtolower($mini), ".php") === false
) {
$sql = sisplet_query("SELECT usr_id, skin FROM srv_theme_profiles WHERE id = '" . $_GET['profile'] . "'");
$row = mysqli_fetch_array($sql);
$user_id = $row['usr_id'];
// ce ima svojo temo, jo zbrisemo
if (strpos($row['skin'], $user_id . '_') !== false) {
$dir = $site_path . 'main/survey/skins/';
unlink($dir . $row['skin'] . '.css');
}
// Odzipaj ga
if (strtolower(substr($mini, -4, 4)) == '.zip') {
if (!is_file($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4)))
mkdir($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4));
$file = $site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/' . $user_id . '_' . $_FILES['fajl']['name'];
move_uploaded_file($_FILES['fajl']['tmp_name'], $file);
exec('unzip -d ' . $site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . ' ' . $file);
copy($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/' . substr($_FILES['fajl']['name'], 0, -4) . ".css", $site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . ".css");
// malo kvazi varnosti
unlink($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/*.php');
unlink($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/*.exe');
unlink($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/*.pl');
unlink($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/*.bat');
unlink($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/*.vbs');
unlink($site_path . 'main/survey/skins/' . $user_id . '_' . substr($_FILES['fajl']['name'], 0, -4) . '/*.py');
} else {
$file = $site_path . 'main/survey/skins/' . $user_id . '_' . $_FILES['fajl']['name'];
move_uploaded_file($_FILES['fajl']['tmp_name'], $file);
}
$s = sisplet_query("UPDATE srv_theme_profiles SET skin='" . str_replace('.css', '', $user_id . '_' . $mini) . "' WHERE id = '" . $_GET['profile'] . "'");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
header('Location: index.php?anketa=' . $this->anketa . '&a=theme-editor&t=css&profile=' . $_GET['profile']);
// slika
} elseif ((strtolower(substr($mini, -4, 4)) == '.jpg' || (strtolower(substr($mini, -4, 4)) == '.jpeg') || (strtolower(substr($mini, -4, 4)) == '.gif') || (strtolower(substr($mini, -4, 4)) == '.png'))
&& strpos(strtolower($mini), ".exe") === false
&& strpos(strtolower($mini), ".bat") === false
&& strpos(strtolower($mini), ".com") === false
&& strpos(strtolower($mini), ".vbs") === false
&& strpos(strtolower($mini), ".pl") === false
&& strpos(strtolower($mini), ".php") === false
) {
if ($_GET['logo'] == 1) {
$replace = array(' ', '+');
$logo = 'logo_' . $this->anketa . '_' . str_replace($replace, '_', $_FILES['fajl']['name']) . '';
$file = $site_path . 'main/survey/uploads/' . $logo;
$fileExt = pathinfo($_FILES['fajl']['name'], PATHINFO_EXTENSION);
[$width, $height] = getimagesize($_FILES['fajl']['tmp_name']);
// If logo too large resize uploaded logo to max 150px height
if($height > 150){
$new_h = 150;
$resize_percent = $new_h / $height;
$new_w = $width * $resize_percent;
switch($fileExt){
case 'jpg':
case 'jpeg':
$resourceType = imagecreatefromjpeg($_FILES['fajl']['tmp_name']);
$imageLayer = imagecreatetruecolor($new_w, $new_h);
imagecopyresampled($imageLayer, $resourceType, 0,0,0,0, $new_w, $new_h, $width, $height);
imagejpeg($imageLayer, $_FILES['fajl']['tmp_name']);
break;
case 'png':
$resourceType = imagecreatefrompng($_FILES['fajl']['tmp_name']);
$imageLayer = imagecreatetruecolor($new_w, $new_h);
imagecopyresampled($imageLayer, $resourceType, 0,0,0,0, $new_w, $new_h, $width, $height);
imagepng($imageLayer, $_FILES['fajl']['tmp_name']);
break;
case 'gif':
$resourceType = imagecreatefromgif($_FILES['fajl']['tmp_name']);
$imageLayer = imagecreatetruecolor($new_w, $new_h);
imagecopyresampled($imageLayer, $resourceType, 0,0,0,0, $new_w, $new_h, $width, $height);
imagegif($imageLayer, $_FILES['fajl']['tmp_name']);
break;
}
}
move_uploaded_file($_FILES['fajl']['tmp_name'], $file);
sisplet_query("UPDATE srv_theme_profiles SET logo = '$logo' WHERE id = '" . $_GET['profile'] . "'");
header('Location: index.php?anketa=' . $this->anketa . '&a=theme-editor&profile=' . $_GET['profile']);
}
else {
$file = $site_path . 'main/survey/uploads/' . $this->uid() . '_' . $_FILES['fajl']['name'];
move_uploaded_file($_FILES['fajl']['tmp_name'], $file);
header('Location: index.php?anketa=' . $this->anketa . '&a=theme-editor&t=css&profile=' . $_GET['profile']);
}
} else {
echo '
';
}
}
}
/**
* ankete najprej ne zbrisemo zares, ampak samo oznacimo, da je bila izbrisana
*
* uporablja se tudi v API
*
* @param mixed $anketa
*/
function anketa_delete($anketa)
{
global $site_path, $global_user_id;
if (!$anketa) return;
// zbrisemo zakesiran query v seji
if (session_id() == '') {
session_start();
}
unset($_SESSION['query']);
unset($_SESSION['result']);
// pošiljanje obvestil ob izbrisu ankete
SurveyAlert::getInstance()->Init($anketa, $global_user_id);
SurveyAlert::getInstance()->sendMailDelete();
$s = sisplet_query("UPDATE srv_anketa SET active='-1', edit_time=NOW() WHERE id = '$anketa'");
Common::RemoveNiceUrl($anketa);
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
}
/** brisanje anket
*
* @param $anketa
* @return unknown_type
*
*/
function anketa_delete_from_db($anketa)
{
global $site_path, $global_user_id;
if (!$anketa) return;
// zbrisemo zakesiran query v seji
if (session_id() == '') {
session_start();
}
unset($_SESSION['query']);
unset($_SESSION['result']);
// pošiljanje obvestil ob izbrisu ankete
//SurveyAlert::getInstance()->Init($anketa, $global_user_id);
//SurveyAlert::getInstance()->sendMailDelete();
$sql = sisplet_query("SELECT id FROM srv_grupa WHERE ank_id = '$anketa'");
while ($row = mysqli_fetch_array($sql)) {
$sql1 = sisplet_query("SELECT id FROM srv_spremenljivka WHERE gru_id='$row[id]'");
while ($row1 = mysqli_fetch_array($sql1)) {
$sql2 = sisplet_query("DELETE FROM srv_vrednost WHERE spr_id = '$row1[id]'");
}
$sql2 = sisplet_query("DELETE FROM srv_spremenljivka WHERE gru_id = '$row[id]'");
# tabela srv_user_grupa
$sql2 = sisplet_query("DELETE FROM srv_user_grupa WHERE gru_id = '$row[id]'");
# tabela srv_user_grupa_active
$sql2 = sisplet_query("DELETE FROM srv_user_grupa" . $this->db_table . " WHERE gru_id = '$row[id]'");
}
$sql2 = sisplet_query("DELETE FROM srv_grupa WHERE ank_id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_alert WHERE ank_id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_dostop WHERE ank_id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_user WHERE ank_id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_anketa WHERE backup = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_anketa WHERE id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_tracking".$this->db_table." WHERE id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_library_anketa WHERE ank_id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_survey_misc WHERE sid = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_variable_profiles WHERE sid = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_glasovanje WHERE ank_id = '$anketa'");
$sql2 = sisplet_query("DELETE FROM srv_survey_misc WHERE sid = '$anketa'");
# Pobrisemo srv_condition_vre
$sql2 = sisplet_query("DELETE FROM srv_condition_vre WHERE cond_id IN (SELECT id FROM srv_condition WHERE if_id IN (SELECT element_if FROM srv_branching WHERE ank_id = '$anketa' AND element_if > 0))");
#Pobrisemo srv_condition_grid
$sql2 = sisplet_query("DELETE FROM srv_condition_grid WHERE cond_id IN (SELECT id FROM srv_condition WHERE if_id IN (SELECT element_if FROM srv_branching WHERE ank_id = '$anketa' AND element_if > 0));");
#Pobrisemo srv_calculation
$sql2 = sisplet_query("DELETE FROM srv_calculation WHERE cnd_id IN (SELECT id FROM srv_condition WHERE if_id IN (SELECT element_if FROM srv_branching WHERE ank_id = '$anketa' AND element_if > 0));");
#pobrisemo srv_condition
$sql2 = sisplet_query("DELETE FROM srv_condition WHERE if_id IN (SELECT element_if FROM srv_branching WHERE ank_id = '$anketa' AND element_if > 0);");
#pobrisemo srv_if
$sql2 = sisplet_query("DELETE FROM srv_if WHERE id IN (SELECT element_if FROM srv_branching WHERE ank_id = '$anketa' AND element_if > 0);");
# sedaj lahko pobrisemo tudi branching
$sql2 = sisplet_query("DELETE FROM srv_branching WHERE ank_id = '$anketa'");
Common::RemoveNiceUrl($anketa);
// kaj pa tabele:
//srv_grid
// srv_call_....
// srv_data_.... // vsi podatki
// srv_userbase_setting
// srv_user_setting_for_survey
}
/**
* @desc popravimo cas in userja popravka
* ta funkcija je skopirana v common. tole pustimo, da ne bojo kaksne napake...
*/
function updateEditStamp()
{
Common::updateEditStamp();
}
/**
* @desc ustvari novo anketo
*/
function nova_anketa($naslov = null, $intro_opomba = '', $akronim = null, $survey_type = 2, $skin = '1kaBlue')
{
global $lang;
global $site_url;
global $global_user_id;
// zbrisemo zakesiran query v seji
if (session_id() == '') {
session_start();
}
unset($_SESSION['query']);
unset($_SESSION['result']);
$sql = sisplet_query("SELECT lang FROM users WHERE id = '$global_user_id'");
$row = mysqli_fetch_array($sql);
$lang_admin = $row['lang'];
$res = sisplet_query("SELECT value FROM misc WHERE what='SurveyCookie'");
[$SurveyCookie] = mysqli_fetch_row($res);
$text = '';
$url = $site_url;
#če naslov ni podan ali če je uporabnik pusti nespremenjen input box za ime ankete (==> Ime ankete) zgeneriramo novo ime
if ($naslov == null || $naslov == $lang['srv_novaanketa_polnoime']) {
$naslov = 'Test ' . rand(100, 999);
}
if ($akronim == null || $akronim == $lang['srv_novaanketa_ime_respondenti']) {
$akronim = $naslov;
}
$starts = $_POST['starts'] ? "'" . $_POST['starts'] . "'" : "NOW()";
$expire = $_POST['expire'] ? "'" . $_POST['expire'] . "'" : "NOW() + INTERVAL 3 MONTH ";
// Nastavimo jezik - admin in response jezik je vedno enak nastavitvi, ki jo ima uporabnik a default
$lang_admin = ((int)$lang_admin > 0) ? $lang_admin : 1;
$lang_resp = $lang_admin;
# ali ima uporabnik nastavljeno da je anketa privzeto aktivna:
$autoActiveSurvey = (int)UserSetting::getInstance()->getUserSetting('autoActiveSurvey');
# ali ima uporabnik nastavljeno da so komentarji privzeto aktivirani
$activeComments = (int)UserSetting::getInstance()->getUserSetting('activeComments');
# ali ima uporabnik nastavljeno da je uvod privzeto skrit
$showIntro = (int)UserSetting::getInstance()->getUserSetting('showIntro');
# ali ima uporabnik nastavljeno da je zakljucek privzeto skrit
$showConcl = (int)UserSetting::getInstance()->getUserSetting('showConcl');
# ali ima uporabnik nastavljeno da je naslov ankete privzeto skrit
$showSurveyTitle = (int)UserSetting::getInstance()->getUserSetting('showSurveyTitle');
// Nastavimo se mobilni skin glede na osnovnega
$mobile_skin = 'MobileBlue';
if(in_array($skin, array('1kaBlue', '1kaRed', '1kaOrange', '1kaGreen', '1kaPurple', '1kaBlack'))){
$mobile_skin = str_replace('1ka', 'Mobile', $skin);
}
elseif(in_array($skin, array('Uni', 'Fdv', 'Cdi'))){
$mobile_skin = 'Mobile'.$skin;
}
$sql = sisplet_query("INSERT INTO srv_anketa (id, naslov, akronim, db_table, starts, expire, dostop, insert_uid, insert_time, edit_uid, edit_time, cookie, text, url, intro_opomba, show_intro, show_concl, survey_type, lang_admin, lang_resp, active, skin, mobile_skin) " .
"VALUES ('', '$naslov', '$akronim', '1', $starts, $expire, '0', '$global_user_id', NOW(), '$global_user_id', NOW(), '$SurveyCookie', '$text', '$url', '$intro_opomba', '$showIntro', '$showConcl', '$survey_type', '$lang_admin', '$lang_resp', '$autoActiveSurvey', '$skin', '$mobile_skin')");
if (!$sql) {
$error = mysqli_error($GLOBALS['connect_db']);
}
$anketa = mysqli_insert_id($GLOBALS['connect_db']);
// Dodan pogoj ce pride do problema pri ustvarjanju (ker ank_id==0 zacikla zadevo)
if($anketa != 0){
// Updatamo srv_activity, ce je anketa aktivna - drugace se ne zabelezi ok ko se deaktivira
if ($autoActiveSurvey == 1) {
$activity_insert_string = "INSERT INTO srv_activity (sid, starts, expire, uid) VALUES('" . $anketa . "', $starts, $expire, '" . $global_user_id . "' );";
$sql_insert = sisplet_query($activity_insert_string);
}
// vnesemo tudi 1. grupo aka page
$sql = sisplet_query("INSERT INTO srv_grupa (id, ank_id, naslov, vrstni_red) VALUES ('', '$anketa', '$lang[srv_stran] 1', '1')");
//ce se nimamo vprasanja v glasovanju ga ustvarimo
if ($survey_type == 0) {
$sqlGrupe = sisplet_query("SELECT id, naslov FROM srv_grupa g WHERE g.ank_id='$anketa' ORDER BY g.vrstni_red");
$rowGrupe = mysqli_fetch_assoc($sqlGrupe);
$grupa = $rowGrupe['id'];
$b = new Branching($this->anketa);
$spr_id = $b->nova_spremenljivka($grupa, 1, 1);
//napolnimo bazo srv_glasovanje
$sqlG = sisplet_query("INSERT INTO srv_glasovanje (ank_id, spr_id) VALUES ('$anketa', '$spr_id')");
//napolnimo vrednosti
Vprasanje::change_tip($spr_id, 1);
//napolnimo vrednosti vprasanja
$values = "";
for ($i = 1; $i <= $row['size']; $i++) {
if ($values != "") $values .= ",";
$values .= " ('$spremenljivka', '$i', '$i') ";
}
$sql1 = sisplet_query("INSERT INTO srv_vrednost (spr_id, variable, vrstni_red) VALUES $values");
//popravljanje default nastavitev - stat=0, show_intro=0
$sqlSpr = sisplet_query("UPDATE srv_spremenljivka SET stat = '0' WHERE id = '$spr_id'");
$sqlAnk = sisplet_query("UPDATE srv_anketa SET show_intro = '0', show_concl = '0', progressbar = '0', countType = '0', akronim = ' ' WHERE id = '$anketa'");
// vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
}
//popravljanje default nastavitev pri formi - show_intro=0, show_concl=0, trajanje->neomejeno
if ($survey_type == 1) {
$sqlAnk = sisplet_query("UPDATE srv_anketa SET show_intro = '0', show_concl = '0', expire = '" . PERMANENT_DATE . "' WHERE id = '$anketa'");
}
// Popravimo default prikazovanje naslova ankete za respondente
if ($showSurveyTitle == 0) {
SurveySetting::getInstance()->Init($anketa);
SurveySetting::getInstance()->setSurveyMiscSetting('survey_hide_title', 1);
}
// Updatamo nastavitev za komentarje (ce so po defaultu vklopljeni)
if ($activeComments == 1) {
SurveySetting::getInstance()->Init($anketa);
SurveySetting::getInstance()->setSurveyMiscSetting('survey_comment', 3);
SurveySetting::getInstance()->setSurveyMiscSetting('survey_comment_viewadminonly', 3);
SurveySetting::getInstance()->setSurveyMiscSetting('question_note_view', 3);
SurveySetting::getInstance()->setSurveyMiscSetting('question_note_write', 0);
SurveySetting::getInstance()->setSurveyMiscSetting('question_comment', 3);
SurveySetting::getInstance()->setSurveyMiscSetting('question_comment_viewadminonly', 3);
SurveySetting::getInstance()->setSurveyMiscSetting('question_resp_comment', 1);
SurveySetting::getInstance()->setSurveyMiscSetting('question_resp_comment_viewadminonly', 3);
SurveySetting::getInstance()->setSurveyMiscSetting('survey_comment_resp', 4);
SurveySetting::getInstance()->setSurveyMiscSetting('survey_comment_viewadminonly_resp', 4);
}
// dodamo se uporabnika v dostop
$uid = $this->uid();
$sql = sisplet_query("INSERT INTO srv_dostop (ank_id, uid) VALUES ('$anketa', '$uid')");
// Nastavimo obvescanje pri aktivaciji (default ob kreiranju ankete)
SurveyAlert::getInstance()->Init($anketa, $global_user_id);
SurveyAlert::setDefaultAlertActivation();
// Nastavimo obvescanje pri poteku ankete (default ob kreiranju ankete)
SurveyAlert::setDefaultAlertBeforeExpire();
// uporabniku dodamo anketo se v knjiznico "moje ankete"
// torej uporabniku ne bomo avtomatsko dodali ankete v knjiznico "moje ankete"
//$sqlk = sisplet_query("SELECT * FROM srv_library_folder WHERE uid='$uid' AND tip='1' AND parent='0'");
//$rowk = mysqli_fetch_array($sqlk);
//sisplet_query("INSERT INTO srv_library_anketa (ank_id, uid, folder) VALUES ('$anketa', '$uid', '$rowk[id]')");
return $anketa;
}
else{
echo 'Napaka pri ustvarjanju ankete!';
die();
}
}
/**
* @desc vpise novo spremenljivko v bazo (lahko je skopirana)
*/
function nova_spremenljivka($grupa, $grupa_vrstni_red, $vrstni_red, $kuki = 0){
// ce se slucajno se kje klice
$b = new Branching($this->anketa);
return $b->nova_spremenljivka($grupa, $grupa_vrstni_red, $vrstni_red, $kuki);
}
/**
* preveri, ce v branchingu lahko zbrisemo spremenljivko (da ni v kaksnem pogoju)
*
* @param mixed $spremenljivka
*/
function check_spremenljivka_delete($spremenljivka)
{
$sql = sisplet_query("SELECT * FROM srv_condition WHERE spr_id='$spremenljivka'");
if (mysqli_num_rows($sql) > 0)
return false;
return true;
}
/**
* zbrise spremenljivko
*
* @param mixed $spremenljivka
*/
function brisi_spremenljivko($spremenljivka)
{
if ($spremenljivka > 0) {
$rowg = Cache::srv_spremenljivka($spremenljivka);
// pri brisanju multiple grid vprasanja, moramo pobrisate tudi vse child spremenljivke (ker kljuci niso nastavljeni)
if ($rowg['tip'] == 24) {
$sqld = sisplet_query("SELECT spr_id FROM srv_grid_multiple WHERE parent='$spremenljivka'");
while ($rowd = mysqli_fetch_array($sqld)) {
sisplet_query("DELETE FROM srv_spremenljivka WHERE id='$rowd[spr_id]'");
}
}
// Poiscemo ce imamo kaksen pogoj na posamezni vrednosti in ga pobrisemo (drugace ostane vezava na pogoj)
$sqlC = sisplet_query("SELECT if_id FROM srv_vrednost WHERE spr_id='$spremenljivka' AND if_id>'0'");
while ($rowC = mysqli_fetch_array($sqlC)) {
$if = $rowC['if_id'];
$sqlCV = sisplet_query("SELECT id FROM srv_condition WHERE if_id = '$if'");
while ($rowCV = mysqli_fetch_array($sqlCV))
sisplet_query("DELETE FROM srv_condition_vre WHERE cond_id='$rowCV[id]'");
sisplet_query("DELETE FROM srv_condition WHERE if_id = '$if'");
sisplet_query("DELETE FROM srv_if WHERE id = '$if'");
}
$sql = sisplet_query("DELETE FROM srv_vrednost WHERE spr_id='$spremenljivka'");
$sql = sisplet_query("DELETE FROM srv_grid WHERE spr_id='$spremenljivka'");
$sql = sisplet_query("DELETE FROM srv_spremenljivka WHERE id='$spremenljivka'");
// Prej je bilo tako in je bila težava pri brisanju iz api-ja, ker gru_id ni bil definiran
$grupa = $rowg['gru_id'];
$this->repareSpremenljivka($grupa);
$sql = sisplet_query("SELECT parent FROM srv_branching WHERE element_spr = '$spremenljivka'");
$row = mysqli_fetch_array($sql);
sisplet_query("DELETE FROM srv_branching WHERE element_spr = '$spremenljivka'");
$b = new Branching($this->anketa);
$b->repare_branching($row['parent']);
$b->repare_vrstni_red();
$b->trim_grupe();
}
}
/**
* @desc preveri, ce ze obstaja variabla s takim imenom - ob rocnem spremninjanju imena
*/
function check_spremenljivka_variable($spremenljivka, $variable)
{
global $lang;
if ($this->anketa > 0) {
$sql_check = sisplet_query("SELECT id FROM srv_spremenljivka s, srv_grupa g WHERE s.id!='$spremenljivka' AND s.variable='$variable' AND g.ank_id='$this->anketa' AND g.id=s.gru_id");
if (!$sql_check)
echo mysqli_error($GLOBALS['connect_db']);
if (mysqli_num_rows($sql_check) > 0) {
echo $lang['srv_variable_error'];
}
}
}
/**
* @desc prikaze nas clipboard
*/
function clipboard_display($spremenljivka = 0, $if = 0)
{
global $lang;
return; // tega ne rabimo vec
$cut = $_POST['cut'];
if ($cut == 1)
setcookie('srv_cut_' . $this->anketa, '1');
else
setcookie('srv_cut_' . $this->anketa, '', time() - 3600);
if ($spremenljivka > 0)
setcookie('srv_clipboard_' . $this->anketa, $spremenljivka);
elseif ($if > 0) setcookie('srv_clipboard_' .
$this->anketa, 'if_' . $if);
elseif ($_COOKIE['srv_clipboard_' . $this->anketa] > 0 && $spremenljivka != -1)
$spremenljivka = $_COOKIE['srv_clipboard_' . $this->anketa];
elseif (substr($_COOKIE['srv_clipboard_' . $this->anketa], 3) > 0 && $spremenljivka != -1)
$if = substr($_COOKIE['srv_clipboard_' . $this->anketa], 3);
// prikazemo spremenljivko
if ($spremenljivka > 0) {
$row = Cache::srv_spremenljivka($spremenljivka);
echo '
' . $lang['srv_copied_spr'] . ':
';
echo '
' . strip_tags($row['naslov']) . ' (' . $row['variable'] . ')
';
}
// prikazemo if
if ($if > 0) {
$sql = sisplet_query("SELECT tip, label FROM srv_if WHERE id = '$if'");
$row = mysqli_fetch_array($sql);
$b = new Branching($this->anketa);
if ($row['tip'] == 0) {
echo '
' . $lang['srv_copied_if'] . ':
';
echo '
' . $b->conditions_display($if) . '
';
} else {
echo '
' . $lang['srv_copied_block'] . ':
';
echo '
' . $row['label'] . '
';
}
}
if ($spremenljivka > 0 || $if > 0) {
echo '
' . $lang['srv_copy_remove'] . '
';
echo '';
}
// zbrisemo iz clipboarda (kukija)
if ($spremenljivka == -1) {
setcookie('srv_clipboard_' . $this->anketa, '', time() - 3600);
setcookie('srv_cut_' . $this->anketa, '', time() - 3600);
echo '';
}
}
/**
* @desc prestevilci variable vseh vprasanj v anketi
*/
function prestevilci($spremenljivka = 0, $all = false)
{
Common::getInstance()->Init($this->anketa);
Common::getInstance()->prestevilci($spremenljivka, $all);
}
/**
* @desc prestevilci ife
*/
function prestevilci_if($parent = 0, & $number = 1)
{
Common::getInstance()->Init($this->anketa);
Common::getInstance()->prestevilci_if($parent, $number);
}
/**
* @desc popravi celotno anketo
*/
function repareAnketa($anketa = 0)
{
if ($anketa == 0)
$anketa = $this->anketa;
Common::repareAnketa($anketa);
}
/**
* @desc popravi vrstni red v tabeli srv_grupa
*/
function repareGrupa($anketa)
{
Common::repareGrupa($anketa);
}
/**
* @desc popravi vrstni red v tabeli srv_spremenljivka
*/
function repareSpremenljivka($grupa)
{
Common::repareSpremenljivka($grupa);
}
/**
* @desc popravi vrstni red v tabeli srv_vrednost
*/
function repareVrednost($spremenljivka)
{
Common::repareVrednost($spremenljivka);
}
/**
* @desc preveri pravice trenutnega userja za urejanje ankete
*/
function checkDostop($anketa = 0)
{
$d = new Dostop();
return $d->checkDostop($anketa);
}
/**
* preveri nivo dostopa za uporabnika (ce je aktiven ali pasiven)
*/
function checkDostopAktiven($anketa = 0)
{
$d = new Dostop();
return $d->checkDostopAktiven($anketa);
}
/**
* @desc Vrne ID trenutnega uporabnika (ce ni prijavljen vrne 0)
*/
function uid()
{
global $global_user_id;
return $global_user_id;
}
/**
* @desc Vrne vse uporabnike iz baze
*/
static function db_select_users()
{
return sisplet_query("SELECT name, surname, id, email FROM users ORDER BY name ASC");
}
/**
* @desc Vrne podatke o uporabniku
*/
static function db_select_user($uid)
{
return sisplet_query("SELECT * FROM users WHERE id='$uid'");
}
/**
* TODO ???
*
* @param mixed $spremenljivka
*/
function addMissingGrids($spremenljivka)
{
$row = Cache::srv_spremenljivka($spremenljivka);
$maxGrids = $row['grids'];
// najprej pobrišemo polja 99,98,97 (na koncu jih spet dodamo)
$deleteString = "DELETE FROM srv_grid WHERE spr_id='" . $spremenljivka . "' AND (id IN (99,98,97))";
$sqlD = sisplet_query($deleteString);
$sqlGrids = sisplet_query("SELECT id, vrstni_red FROM srv_grid WHERE spr_id='$spremenljivka' ORDER BY id");
$countGrids = mysqli_num_rows($sqlGrids);
// če imamo v gridu več spremenljivk kot jih rabimo jih pobrišemo
if ($countGrids > $maxGrids) {
$deleteString = "DELETE FROM srv_grid WHERE spr_id='" . $spremenljivka . "' AND id > $maxGrids";
$deleteQuery = sisplet_query($deleteString);
}
// dodamo manjkajoče spremenljivke
if ($countGrids < $maxGrids) {
for ($i = $countGrids + 1; $i <= $maxGrids; $i++) {
$rowG = mysqli_fetch_array($sqlGrids);
if ($rowG['vrstni_red'] != $i) {
//nastavimo id na najvecji v vprasanju
$sqlID = sisplet_query("SELECT MAX(id) FROM srv_grid WHERE spr_id='$spremenljivka' ");
$rowID = mysqli_fetch_array($sqlID);
$newId = $rowID['MAX(id)'] + 1;
$insertString = "INSERT INTO srv_grid (id, spr_id, vrstni_red, variable) VALUES ('$newId', '$spremenljivka', '$i', '$i')";
$sqlInsert = sisplet_query($insertString);
}
}
}
$this->repareVrednost($spremenljivka);
// nato samo še dodamo sistemske če je potrebno
$_otherStatus = array(99 => "-99", 98 => "-98", 97 => "-97");
$_otherStatusFields = array(
99 => 'undecided',
98 => 'rejected',
97 => 'inappropriate'
);
$_otherStatusDefaults = array(
99 => 'Ne vem',
98 => 'Zavrnil',
97 => 'Neustrezno'
);
$_updateState = "";
foreach ($_otherStatus as $status => $statusVariable) {
// dodamo samo če je čekirano polje v spremenljivki
if ($row[$_otherStatusFields[$status]] == 1) {
$sqlUD = sisplet_query("SELECT id FROM srv_grid WHERE spr_id='$spremenljivka' AND vrstni_red='" . $status . "'");
$rowUD = mysqli_fetch_array($sqlUD);
if ($rowUD == FALSE) {
$sqlUD2 = sisplet_query("SELECT MAX(vrstni_red) FROM srv_grid WHERE spr_id='$spremenljivka' ");
$rowUD2 = mysqli_fetch_array($sqlUD2);
//nastavimo id na najvecji v vprasanju
$id = $rowUD2['MAX(vrstni_red)'] + 1;
//vnesemo polje (ne vem, zavrnil, neustrezno) v bazo (default vrednosti: NE VEM, vrstni_red 99, variable 99
$sqlUD3String = "INSERT INTO srv_grid (id, spr_id, naslov, vrstni_red, variable) " .
"VALUES ('$status', '$spremenljivka', '" . $_otherStatusDefaults[$status] . "', '" . $status . "', '" . $statusVariable . "')";
$sqlUD3 = sisplet_query($sqlUD3String);
}
}
}
}
/**
* TODO ???
*
* @param mixed $spremenljivka
*/
function getSpremenljivkaZaporedna($spremenljivka)
{
$rowSpr = Cache::srv_spremenljivka($spremenljivka);
// Preštejemo koliko vprašanj je bilo do sedaj na prejšnih straneh
$sqlg = sisplet_query("SELECT vrstni_red FROM srv_grupa WHERE id='" . $rowSpr['gru_id'] . "'");
$rowg = mysqli_fetch_assoc($sqlg);
$vrstni_red = $rowg['vrstni_red'];
$sqlCountPast = sisplet_query("SELECT count(*) as cnt FROM srv_spremenljivka s, srv_grupa g WHERE g.ank_id='$this->anketa' AND s.gru_id=g.id AND g.vrstni_red < '$vrstni_red' ORDER BY g.vrstni_red ASC, s.vrstni_red ASC");
$rowCount = mysqli_fetch_assoc($sqlCountPast);
$offset = $rowCount['cnt'];
// preštejemo katera premenljivka je trenutna
$stringCountPast = "SELECT count(*) as cnt FROM srv_spremenljivka WHERE gru_id = '" . $rowSpr['gru_id'] . "' AND vrstni_red <= '" . $rowSpr['vrstni_red'] . "' ORDER BY vrstni_red ASC";
$sqlCountPast = sisplet_query($stringCountPast);
$rowCountPast = mysqli_fetch_assoc($sqlCountPast);
return $offset + $rowCountPast['cnt'];
}
/**
* @desc Če je anketa aktivna, preverimo da ni slučajno potekel čas aktivnosti,
* če je, jo deaktiviramo
*/
function checkSurveyActive($anketa = null)
{
// pretecena anketa, kontroliramo datum na: starts in expire
sisplet_query("UPDATE srv_anketa SET active = '0' WHERE id='" . ($anketa ? $anketa : $this->anketa) . "' AND active = '1' AND expire < CURDATE()");
SurveyInfo:: getInstance()->SurveyInit($this->anketa);
// vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
$sqls = sisplet_query("SELECT active FROM srv_anketa WHERE id='" . ($anketa ? $anketa : $this->anketa) . "'");
$rows = mysqli_fetch_assoc($sqls);
return $rows['active'];
}
/**
* preview
*
*/
private function getTipPreviewHtml(){
global $lang;
global $global_user_id;
// Predpregled tipa vprašanj - prikazujemo samo kadar smo v urejanju ankete
if (!$this->anketa > 0)
return;
if ( ($_GET['a'] != '' || !isset($_GET['anketa'])) && $_GET['a'] != 'branching' )
return;
echo '
';
echo '
';
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
// tip 9999 - IF
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_toolbox_if'];
echo '
';
if(!$userAccess->checkUserAccess($what='if')){
$userAccess->displayNoAccessText($what='if');
}
echo '
';
// tip 9998 - Block
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_toolbox_block'];
echo '
';
if(!$userAccess->checkUserAccess($what='block')){
$userAccess->displayNoAccessText($what='block');
}
echo '
';
// tip 9997 - Loop
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_toolbox_loop'];
echo '
';
if(!$userAccess->checkUserAccess($what='loop')){
$userAccess->displayNoAccessText($what='loop');
}
echo '
';
// tip 1_1 - radio
echo '
';
// echo '
Primer tipa vprašanj: radio.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t1'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 1_10 - gdpr
echo '
';
// echo '
Primer tipa vprašanj: radio.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_gdpr_intro_title'] . '
';
echo '
' . $lang['srv_gdpr_intro'] . '.
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 1 - radio (horizontalno)
echo '
';
// echo '
Primer tipa vprašanj: radio.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
';
// tip 1_2 - radio (horizontalno - nova vrstica)
echo '
';
// echo '
Primer tipa vprašanj: radio.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
';
// tip 1_5 - radio potrditev
echo '
';
// echo '
Primer tipa vprašanj: radio.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t1_5'] . '
';
echo '
';
echo '
';
echo '
';
// tip 1_6 - select box
echo '
';
// echo '
Primer tipa vprašanj: radio.
';
//echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t3'] . '
';
echo '
' . $lang['srv_tip_sample_t3_oc'] . ' ' . $lang['srv_tip_sample_t3_oc'] . ' ' . $lang['srv_tip_sample_t3_oc'] . '
';
echo '
';
echo '
';
// tip 1_8 - Drag-drop
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
//echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t1'] . '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t1_o1'] . '
';
echo '
' . $lang['srv_tip_sample_t1_o2'] . '
';
echo '
' . $lang['srv_tip_sample_t1_o3'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 1_9 - custom radio picture
echo '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t1'] . '
';
// star
echo '
';
for ($i = 1; $i < 4; $i++) {
echo '
';
}
echo '
';
// thumb
echo '
';
for ($i = 1; $i < 4; $i++) {
echo '
';
}
echo '
';
//smiley
echo '
';
for ($i = 1; $i < 4; $i++) {
echo '
';
}
echo '
';
// heart
echo '
';
for ($i = 1; $i < 4; $i++) {
echo '
';
}
echo '
';
// flag
echo '
';
for ($i = 1; $i < 4; $i++) {
echo '
';
}
echo '
';
// user
echo '
';
for ($i = 1; $i < 4; $i++) {
echo '
';
}
echo '
';
echo '
';
echo '
';
// tip 1_10 - Image HotSpot
echo '
';
// echo '
Primer tipa vprašanj: label.
';
//echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_hotspot_preview_text_radio'] . '
';
echo '
';
echo '
';
echo '
';
// tip 1_11 - Vizualna anlaogna skala
echo '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t1'] . '
';
echo '
';
for ($i = 1; $i < 7; $i++) {
echo '
';
}
echo '
';
echo '
';
echo '
';
// tip 2 - checkbox
echo '
';
// echo '
Primer tipa vprašanj: checkbox.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t2'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 2_1 - check(horizontalno)
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
';
// tip 2_2 - check (horizontalno - nova vrstica)
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
';
// tip 2_8 - Drag-drop
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t1'] . '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t1_o1'] . '
';
echo '
' . $lang['srv_tip_sample_t1_o2'] . '
';
echo '
' . $lang['srv_tip_sample_t1_o3'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 2_10 - Image HotSpot
echo '
';
// echo '
Primer tipa vprašanj: label.
';
//echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_hotspot_preview_text_checkbox'] . '
';
echo '
';
echo '
';
echo '
';
// tip 3 - select
echo '
';
// echo '
Primer tipa vprašanj: select.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t3'] . '
';
echo '
' . $lang['srv_tip_sample_t3_oc'] . '
';
echo '
';
echo '
';
// tip 21 - besedilo*
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21'] . '
';
echo '
';
echo '
';
echo '
';
// tip 21_1 - cpatcha
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21_1_o1'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 21_2 - email
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21_2_o1'] . '
';
echo '
(' . $lang['srv_email_example'] . ')
';
echo '
';
echo '
' . $lang['srv_email_example_txt'] . '
';
echo '
';
echo '
';
// tip 21_3 - url
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21_3_o1'] . '
';
echo '
(' . $lang['srv_url_example'] . ')
';
echo '
';
echo '
';
echo '
';
// tip 21_4 - upload
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21_4_o1'] . '
';
echo '
';
echo '
';
echo '
';
// tip 21_5 - textbox box
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21'] . '
';
echo '
';
echo '
';
echo '
';
// tip 21_6 - elektronski podpis
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21_6'] . '
';
echo '
';
echo '
';
echo '
';
echo '
'.$lang['srv_signature_name'].'
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_signature')){
$userAccess->displayNoAccessText($what='question_type_signature');
}
echo '
';
// tip 21_7 - fotografija
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t21_7'] . '
';
echo '
';
echo '
';
echo '
';
// tip 5 - label
echo '
';
// echo '
Primer tipa vprašanj: label.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t5'] . '
';
echo '
';
echo '
';
// tip 5_2 - nagovor za aktivacijo chata
echo '
';
// echo '
Primer tipa vprašanj: text.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_chat_question_text'] . '
';
echo '
'.$lang['srv_chat_turn_on'].'
';
echo '
';
echo '
';
// tip 26 - lokacija
echo '
';
// echo '
Primer tipa vprašanj: label.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t26_1'] . '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_location')){
$userAccess->displayNoAccessText($what='question_type_location');
}
echo '
';
// tip 26_2 - multi lokacija
echo '
';
// echo '
Primer tipa vprašanj: label.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t26_2'] . '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_location')){
$userAccess->displayNoAccessText($what='question_type_location');
}
echo '
';
// tip 26_1 - moja lokacija
echo '
';
// echo '
Primer tipa vprašanj: label.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t26_1'] . '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_location')){
$userAccess->displayNoAccessText($what='question_type_location');
}
echo '
';
// tip 6 - multigrid
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6'] . '
';
echo '
' . $lang['srv_tip_sample_t6_o1'] . ' ' . $lang['srv_tip_sample_t6_o2'] . ' ' . $lang['srv_tip_sample_t6_o3'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_1 - multigrid (semanticni diferencial)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t61'] . ':
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_2 - multigrid (dropdown)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6'] . '
';
echo '
' . $lang['srv_tip_sample_t6_v1'] . '
' . $lang['srv_tip_sample_t6_o1'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_v2'] . '
' . $lang['srv_tip_sample_t6_o1'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_v3'] . '
' . $lang['srv_tip_sample_t6_o1'] . ' ';
echo '
';
echo '
';
echo '
';
// tip 6_3 - multigrid (double grid)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6'] . '
';
echo '
' . $lang['srv_tip_sample_t6_v1'] . ' ' . $lang['srv_tip_sample_t6_v3'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_o1'] . ' ' . $lang['srv_tip_sample_t6_o2'] . ' ' . $lang['srv_tip_sample_t6_o3'] . ' ' . $lang['srv_tip_sample_t6_o1'] . ' ' . $lang['srv_tip_sample_t6_o2'] . ' ' . $lang['srv_tip_sample_t6_o3'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_4 - multigrid (one against another)
echo '
';
// echo '
Primer tipa vprašanj: one against another.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_4'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_5 - multigrid (max diff)
echo '
';
// echo '
Primer tipa vprašanj: max diff.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_5'] . '
';
echo '
' . $lang['srv_tip_sample_t6_5_c1'] . '
' . $lang['srv_tip_sample_t6_5_c2'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_6 - multigrid (select box)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_6'] . '
';
echo '
' . $lang['srv_tip_sample_t6_6_v1'] . '
' . $lang['srv_tip_sample_t6_6_o1a'] . ' ' . $lang['srv_tip_sample_t6_6_o2a'] . ' ' . $lang['srv_tip_sample_t6_6_o3a'] . ' ' . $lang['srv_tip_sample_t6_6_o4a'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_6_v2'] . '
' . $lang['srv_tip_sample_t6_6_o1b'] . ' ' . $lang['srv_tip_sample_t6_6_o2b'] . ' ' . $lang['srv_tip_sample_t6_6_o3b'] . ' ' . $lang['srv_tip_sample_t6_6_o4b'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_6_v3'] . '
' . $lang['srv_tip_sample_t6_6_o1c'] . ' ' . $lang['srv_tip_sample_t6_6_o2c'] . ' ' . $lang['srv_tip_sample_t6_6_o3c'] . ' ' . $lang['srv_tip_sample_t6_6_o4c'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_6_v4'] . '
' . $lang['srv_tip_sample_t6_6_o1d'] . ' ' . $lang['srv_tip_sample_t6_6_o2d'] . ' ' . $lang['srv_tip_sample_t6_6_o3d'] . ' ' . $lang['srv_tip_sample_t6_6_o4d'] . ' ';
echo '
';
echo '
';
echo '
';
// tip 6_8 - multigrid (Tabela Da/Ne)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6'] . '
';
echo '
' . $lang['srv_tip_sample_t6_8_o1'] . ' ' . $lang['srv_tip_sample_t6_8_o2'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_9 - Drag-drop
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
'; //$lang['srv_new_question_icon']
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t6'] . '
';
echo '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t6_v1'] . '
';
echo '
' . $lang['srv_tip_sample_t6_v2'] . '
';
echo '
' . $lang['srv_tip_sample_t6_v3'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
//echo ''.$lang['srv_tip_sample_t6_o1'].'
tralrarla
'.$lang['srv_tip_sample_t6_o2'].'
'.$lang['srv_tip_sample_t6_o3'].'
' . $lang['srv_tip_sample_t6_o1'] . '
'; //izpis "naslova" okvirja
echo '
' . "\n"; //izpis okvirja
echo '
' . $lang['srv_tip_sample_t6_o2'] . '
'; //izpis "naslova" okvirja
echo '
' . "\n"; //izpis okvirja
echo '
' . $lang['srv_tip_sample_t6_o3'] . '
'; //izpis "naslova" okvirja
echo '
' . "\n"; //izpis okvirja
echo ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 6_10 - Image HotSpot
echo '
';
// echo '
Primer tipa vprašanj: label.
';
//echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_hotspot_preview_text_radio_grid'] . '
';
echo '
';
echo '
';
echo '
';
// tip 16 - multicheckbox
echo '
';
// echo '
Primer tipa vprašanj: multicheckbox.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t16'] . '
';
echo '
' . $lang['srv_tip_sample_t16_o1'] . ' ' . $lang['srv_tip_sample_t16_o2'] . ' ' . $lang['srv_tip_sample_t16_o3'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 19 - multitext
echo '
';
// echo '
Primer tipa vprašanj: multitext.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t19'] . '
';
echo '
' . $lang['srv_tip_sample_t19_o1'] . ' ' . $lang['srv_tip_sample_t19_o2'] . ' ' . $lang['srv_tip_sample_t19_o3'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 20 - multinumber
echo '
';
// echo '
Primer tipa vprašanj: multinumber.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t20'] . '
';
echo '
' . $lang['srv_tip_sample_t20_o1'] . ' ' . $lang['srv_tip_sample_t20_o2'] . ' ' . $lang['srv_tip_sample_t20_o3'] . ' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
// tip 7 - number
echo '
';
// echo '
Primer tipa vprašanj: number.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t7'] . '
';
echo '
' . $lang['srv_tip_sample_t7_o1'] . '
';
echo '
';
echo '
';
// tip 7_2 - slider
echo '
';
// echo '
Primer tipa vprašanj: number.
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t7_2'] . '
';
echo '
';
echo '
';
echo '
';
// tip 8 - datum
echo '
';
// echo '
Primer tipa vprašanj: datum.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t8'] . '
';
echo '
';
echo '
';
echo '
';
// tip 17 - Razvrščanje prestavljanje (default)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t17'] . '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t17_o1'] . '
';
echo '
' . $lang['srv_tip_sample_t17_o2'] . '
';
echo '
' . $lang['srv_tip_sample_t17_o3'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_ranking')){
$userAccess->displayNoAccessText($what='question_type_ranking');
}
echo '
';
// tip 171 - Razvrščanje ostevilcevanje (design = 1)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t171'] . '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_ranking')){
$userAccess->displayNoAccessText($what='question_type_ranking');
}
echo '
';
// tip 172 - Razvrščanje premikanje (design = 2)
echo '
';
// echo '
Primer tipa vprašanj: multigrid.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t172'] . '
';
echo '
' . $lang['srv_tip_sample_t172_o1'] . '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t172_o2'] . '
';
echo '
';
echo '
' . $lang['srv_tip_sample_t172_o3'] . '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_ranking')){
$userAccess->displayNoAccessText($what='question_type_ranking');
}
echo '
';
// tip 18 - vsota
echo '
';
// echo '
Primer tipa vprašanj: vsota.
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_sum')){
$userAccess->displayNoAccessText($what='question_type_sum');
}
echo '
';
// tip 24 - Kombinirana tabela
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_survey_table_multiple'];
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_multitable')){
$userAccess->displayNoAccessText($what='question_type_multitable');
}
echo '
';
// tip 27 - Heatmap
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_vprasanje_heatmap'];
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_heatmap')){
$userAccess->displayNoAccessText($what='question_type_heatmap');
}
echo '
';
// tip 22 - Kalkulacija
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_vprasanje_tip_long_22'];
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_calculation')){
$userAccess->displayNoAccessText($what='question_type_calculation');
}
echo '
';
// tip 25 - Kvota
echo '
';
echo '
' . $lang['srv_new_question_icon'] . ' ';
echo '
';
echo $lang['srv_vprasanje_tip_long_25'];
echo '
';
if(!$userAccess->checkUserAccess($what='question_type_quota')){
$userAccess->displayNoAccessText($what='question_type_quota');
}
echo '
';
// tip 9 - SN-imena
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t9'] . ':
';
echo '
';
echo '
';
echo '
';
if(!$userAccess->checkUserAccess($what='social_network')){
$userAccess->displayNoAccessText($what='social_network');
}
echo '
';
// tip 9_1 - SN-imena - fiksno st. polj
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
';
// tip 9_2 - SN-imena - 1 textbox
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
' . $lang['srv_tip_sample_t9'] . ':
';
echo '
';
echo '
';
echo '
';
// tip 9_3 - SN-imena - vnos stevila polj
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
echo '
';
// demografska vprasanja
include_once('../../main/survey/app/global_function.php');
$Survey = new \App\Controllers\SurveyController(true);
save('forceShowSpremenljivka', true);
$dem = Array('XSPOL', 'XSTAR2a4', 'XZST1surs4', 'XDS2a4', 'XIZ1a2', 'XLOKACREGk', 'XPODJPRIH');
foreach ($dem AS $key) {
$id = Demografija::getInstance()->getSpremenljivkaID($key);
if ($id > 0) {
echo '
';
echo '
' . $lang['srv_new_question'] . ' ';
echo '
';
\App\Controllers\Vprasanja\VprasanjaController::getInstance()->displaySpremenljivka($id);
echo '
';
echo '
';
}
}
echo '
';
echo '
'; // tip_preview
}
/**
* porihtana funkcija, da poklice SurveyRespondents::checkSystemVariables(), ki je zadolzena za dodajanje sistemskih spremenljivk
*
* @param mixed $phone
* @param mixed $email
*/
function createUserbaseSystemVariable($phone, $email, $language = 0)
{
$user_base = 0;
$cookie = -1;
$rowb = SurveyInfo::getInstance()->getSurveyRow();
$phone = (int)(SurveyInfo::getInstance()->checkSurveyModule('phone') || (int)$phone == 1);
$email = (int)(SurveyInfo::getInstance()->checkSurveyModule('email') || (int)$email == 1);
$variables = array();
if ($phone == 1) {
array_push($variables, "telefon");
$user_base = 1;
}
if ($email == 1) {
array_push($variables, "email");
$user_base = 1;
}
if ($language == 1) {
array_push($variables, "language");
}
SurveyRespondents:: getInstance()->Init($this->anketa);
SurveyRespondents:: checkSystemVariables($variables);
if ($rowb['user_base'] != $user_base || (int)SurveyInfo::getInstance()->checkSurveyModule('phone') != $phone || (int)SurveyInfo::getInstance()->checkSurveyModule('email') != $email) {// nastavimo še userbase
// v userbase vedno prikazujemo uvod
if ($user_base == 1)
$intro = " '1' ";
else
$intro = " show_intro ";
$sql = sisplet_query("UPDATE srv_anketa SET user_base='$user_base', phone='$phone', email='$email', show_intro=$intro WHERE id='" . $this->anketa . "'");
// vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
}
return SurveyInfo::getInstance()->getSurveyRow();
}
/**
* TODO ***
*
* @param mixed $curent_id
* @param mixed $errorMsg
*/
function show_email_invitation_templates($curent_id = 1, $errorMsg = null)
{
global $lang;
echo '
';
echo 'Predloge: ';
echo '';
echo '
';
$sql_email_invitations_profiles = sisplet_query("SELECT id, name FROM srv_userbase_invitations");
while ($row_email_invitations_profiles = mysqli_fetch_assoc($sql_email_invitations_profiles)) {
echo '
' . $row_email_invitations_profiles['name'] . '
';
}
echo '
';
echo '
';
$this->show_email_invitation_values($curent_id, $errorMsg);
echo '
';
echo '
';
echo ' ';
echo '';
}
/**
* TODO ????
*
* @param mixed $curent_id
* @param mixed $errorMsg
*/
function show_email_invitation_values($curent_id = 1, $errorMsg = null)
{
global $lang;
$sql_email_invitations_profiles = sisplet_query("SELECT name, subject, text FROM srv_userbase_invitations WHERE id = '" . $curent_id . "'");
$row_email_invitations_profiles = mysqli_fetch_assoc($sql_email_invitations_profiles);
$temp_name = $row_email_invitations_profiles['name'];
$temp_subject = $row_email_invitations_profiles['subject'];
$temp_text = $row_email_invitations_profiles['text'];
if ($errorMsg != null) {
echo '
' . $errorMsg . '
';
}
echo '
';
echo '
Ime: ';
echo '
';
echo '
Zadeva: ';
echo '
';
echo '
' . $lang['text'] . ': ';
echo '
' . $temp_text . '
';
echo '
';
echo '
';
echo '
';
if ($curent_id > 1) {
$confirmDelete = "Ali ste prepričani da želite izbristai predlogo: " . $temp_name . "?";
echo '
';
echo '
';
}
echo '
';
}
/**
* TODO ???
*
* @param mixed $curent_id
* @param mixed $errorMsg
*/
function show_userbase_respondents_lists($curent_id = null, $errorMsg = null)
{
echo '
Liste respondentov' . ' ';
$sql_lists = sisplet_query("SELECT id FROM srv_userbase_respondents_lists");
$numRows = mysqli_num_rows($sql_lists);
// print_r(SurveyRespondents :: getInstance() ->getSurveyId());
// print_r(SurveyRespondents :: getInstance() ->getGlobalUserId());
// print_r(SurveyRespondents :: getInstance() ->getCurentProfileId());
// print_r(SurveyRespondents :: getInstance() ->getProfiles());
if ($numRows == 0) {
echo '' . ($errorMsg != null ? $errorMsg . '
' : '') . 'Ni shranjenih list respondentov!
';
echo '
';
$sql_email_invitations_profiles = sisplet_query("SELECT id, name FROM srv_userbase_respondents_lists");
while ($row_email_invitations_profiles = mysqli_fetch_assoc($sql_email_invitations_profiles)) {
echo '
' . $row_email_invitations_profiles['name'] . '
';
}
echo '
';
echo '
';
$this->show_userbase_list_respondents($curent_id, $errorMsg);
echo '
';
echo '
';
echo '';
echo '';
}
echo '';
}
/**
* TODO ???
*
* @param mixed $id
* @param mixed $errorMsg
*/
function show_userbase_list_respondents($id = null, $errorMsg = null)
{
global $lang;
if ($errorMsg != null) {
echo '
' . $errorMsg . '
';
}
// preberemo ime liste in sistemske spremenljivke
$sqlLista = sisplet_query("SELECT name, variables FROM srv_userbase_respondents_lists WHERE id = '" . $id . "'");
$rowLista = mysqli_fetch_assoc($sqlLista);
// preberemo respondente
$_respondenti = array();
$sqlRespondenti = sisplet_query("SELECT line FROM srv_userbase_respondents WHERE list_id = '" . $id . "'");
while ($row_respondenti = mysqli_fetch_assoc($sqlRespondenti)) {
$_respondenti[] = $row_respondenti['line'];
}
if ($_respondenti)
$respondenti = implode("
", $_respondenti);
echo '
';
echo '
' . $lang['srv_userbase_list_name'] . ': ';
echo '
';
echo '
' . $lang['srv_userbase_variables'] . ': ';
echo '
';
echo '
' . $lang['srv_userbase_respondents'] . ': ';
echo '
' . $respondenti . '
';
echo '
';
echo '
';
if ($id > 0) {
echo '
';
$confirmDelete = $lang['srv_userbase_confirm_delete_list'] . $rowLista['name'] . "?";
echo '
';
echo '
';
echo '
';
}
}
/**
* TODO ???
*
* @param mixed $mailto_radio
* @param mixed $mailto_status
*/
function show_mailto_users($mailto_radio, $mailto_status = null)
{
global $lang;
$arrayMailtoSqlString = $this->getMailtoSqlString($mailto_radio, $mailto_status);
$errorMsg = $arrayMailtoSqlString['errorMsg'];
$sqlString = $arrayMailtoSqlString['sqlString'];
echo '
' . $lang['srv_mail_to_user_list'] . ': ';
if ($errorMsg == null) {
$sqlUsers = sisplet_query($sqlString);
if (mysqli_num_rows($sqlUsers) > 0) {
while ($rowUsers = mysqli_fetch_array($sqlUsers)) {
$sqlUser = sisplet_query("SELECT d.text FROM srv_data_text".$this->db_table." d, srv_spremenljivka s , srv_grupa g " .
" WHERE d.spr_id=s.id AND d.usr_id='" . $rowUsers['id'] . "' AND " .
" s.variable = 'email' AND g.ank_id='" . $this->anketa . "' AND s.gru_id=g.id
");
if (!$sqlUser) echo mysqli_error($GLOBALS['connect_db']);
$rowUser = mysqli_fetch_array($sqlUser);
if ($rowUser['text'] != "" && $rowUser['text'] != NULL) {
echo '' . $rowUser['text'] . ' (status: ' . $rowUsers['status'] . ' - ' . $lang['srv_userstatus_' . $rowUsers['status']] . ')
';
} else {
echo '' . $lang['srv_respondent_email_missing'] . ' (status: ' . $rowUsers['status'] . ' - ' . $lang['srv_userstatus_' . $rowUsers['status']] . ')
';
}
}
} else {
$errorMsg = $lang['srv_mail_to_user_no_data'];
}
}
if ($errorMsg != null) {
echo '' . $errorMsg . '
';
}
/** Odpre okno za predogled poslanega e-maila obveščanja z pripadajočim seznamom uporabnikov
*
* @param mixed $mailto_radio
* @param mixed $mailto_status
*/
function preview_mailto_email($mailto_radio, $mailto_status)
{
global $site_url, $lang;
// preberemo vsebino sporočila
$sql_userbase = sisplet_query("SELECT * FROM srv_userbase_setting WHERE ank_id = '$this->anketa'");
if (mysqli_num_rows($sql_userbase) > 0) {
// anketa že ima nastavljen text
$row_userbase = mysqli_fetch_assoc($sql_userbase);
} else {
// anketa še nima nastavljenega teksta, preberemo privzetega (id=1) iz tabele srv_userbase_invitations
$sql_userbase_invitations = sisplet_query("SELECT * FROM srv_userbase_invitations WHERE id = 1");
$row_userbase = mysqli_fetch_assoc($sql_userbase_invitations);
}
// poiščemo sistemske spremenljivke iz vsebine
preg_match_all("/#(.*?)#/s", $row_userbase['text'], $sisVars);
$sisVars = $sisVars[1];
// Poiščemo še sistemske spremenljivke iz ankete
$sqlSistemske = sisplet_query("SELECT s.id, s.naslov, s.variable FROM srv_spremenljivka s, srv_grupa g WHERE s.sistem='1' AND s.gru_id=g.id AND g.ank_id='" . $this->anketa . "' ORDER BY g.vrstni_red, s.vrstni_red");
if (mysqli_num_rows($sqlSistemske) > 0) {
while ($rowSistemske = mysqli_fetch_assoc($sqlSistemske)) {
if (!isset($sisVars[strtoupper($rowSistemske['variable'])]))
$sisVars[] = strtoupper($rowSistemske['variable']);
}
}
// preberemo prejemnike
$arrayMailtoSqlString = $this->getMailtoSqlString($mailto_radio, $mailto_status);
$errorMsg = $arrayMailtoSqlString['errorMsg'];
$sqlString = $arrayMailtoSqlString['sqlString'];
$usrArray = array();
if ($errorMsg == null) {
$sqlUsers = sisplet_query($sqlString);
if (mysqli_num_rows($sqlUsers) > 0) {
//while ($rowUsers = mysqli_fetch_array($sqlUsers)) {
// naredimo samo za prvega userja
while ($rowUsers = mysqli_fetch_array($sqlUsers)) {
# ali imamo ustrezne sistemske spremenljivke (predvsem e-mail)
$valid_user = false;
$tmpUser = array();
$tmpUser['cookie'] = $rowUsers['cookie'];
$tmpUser['pass'] = $rowUsers['pass'];
$tmpUser ['status'] = $rowUsers['status'];
$tmpUser ['label'] = $lang['srv_userstatus_' . $rowUsers['status']];
// dodamo sistemske spremenljivke in poiščemo njihove vrednosti
foreach ($sisVars as $sysVar) {
$sqlUser = sisplet_query("SELECT d.text FROM srv_data_text".$this->db_table." d, srv_spremenljivka s , srv_grupa g
WHERE d.spr_id=s.id AND d.usr_id='" . $rowUsers['id'] . "' AND
s.variable = '" . strtolower($sysVar) . "' AND g.ank_id='" . $this->anketa . "' AND s.sistem = 1 AND s.gru_id=g.id
");
if (!$sqlUser)
echo mysqli_error($GLOBALS['connect_db']);
$rowUser = mysqli_fetch_assoc($sqlUser);
if ($rowUser['text'] != null && $rowUser['text'] != '') {
$tmpUser[strtolower($sysVar)] = $rowUser['text'];
}
# če mamo email in je vnešen je uporabnik veljaven
if (strtolower($sysVar) == 'email' && $rowUser['text'] != null && $rowUser['text'] != '') {
$valid_user = true;
}
}
if ($valid_user) {
$usrArray[$rowUsers['id']] = $tmpUser;
}
}
} else {
$errorMsg = "Ni uporabnikov ki ustrezajo izbranim pogojem!";
}
}
$frstUser = current($usrArray);
// cookie, email poberemo od prvega uporabnika
$url = SurveyInfo::getSurveyLink() . '?code=' . $frstUser['pass'] . '';
$unsubscribe = $site_url . 'admin/survey/unsubscribe.php?anketa=' . $this->anketa . '&code=' . $frstUser['pass'] . '';
// zamenjamo sistemske vrednosti
$content = $row_userbase['text'];
// za staro verzijo
$content = str_replace('[URL]', '#URL#', $content);
$content = str_replace('[CODE]', '#CODE#', $content);
$content = str_replace(array(
'#URL#',
'#CODE#'
), array(
'
' . $url . ' ',
$frstUser['pass']
), $content);
$content = str_replace('#UNSUBSCRIBE#', '
' . $lang['user_bye_hl'] . ' ', $content);
// poiščemo prestale variable katere je potrebno zamenjati
preg_match_all("/#(.*?)#/s", $content, $toReplace);
foreach ($toReplace[0] as $key => $seed) {
$content = str_replace($toReplace[0][$key], $frstUser[strtolower($toReplace[1][$key])], $content);
}
$subject = $row_userbase['subject'];
// izpišemo vsebino
echo '
';
echo '
';
echo 'Prejemniki:';
echo '
';
$brdr_top = "";
foreach ($usrArray as $user) {
echo '
' . $user['email'] . '
';
}
echo '
';
echo '
';
echo '
';
echo 'Naslov:';
echo '
';
echo '
';
echo $subject;
echo '
';
echo '
';
echo 'Vsebina:';
echo '
';
echo '
';
echo $content;
echo '
';
//text samo pri previewju v formi (hitro posiljanje mailov)
if ($_GET['a'] == 'form_send_email') {
echo '
';
echo 'S potrditvijo boste zgornje vabilo poslali. Če bi želeli spreminjati nagovor, pojdite v napredne opcije.';
echo '
';
}
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
}
/**
* TODO ???
*
* @param mixed $mailto_radio
* @param mixed $mailto_status
* @return mixed
*/
function getMailtoSqlString($mailto_radio, $mailto_status = null)
{
$sqlString = null;
$errorMsg = null;
//v odvisnosti od statusa polovimo emaile in jih zlistamo na levi strani
if ($mailto_radio == 'all') {
$sqlString = "SELECT id, last_status as status, cookie, pass FROM srv_user WHERE ank_id = '" . $this->anketa . "' AND unsubscribed='0'";
} elseif ($mailto_radio == 'norsp') {
$sqlString = "SELECT st.status, usr_tbl.* FROM srv_userstatus AS st LEFT JOIN ( SELECT max(s.datetime) as statusdatetime, u.* FROM srv_user as u" .
" LEFT JOIN srv_userstatus AS s ON u.id = s.usr_id AND u.unsubscribed='0' WHERE u.ank_id = '" . $this->anketa . "' AND recnum = '0' GROUP BY s.usr_id) AS usr_tbl ON st.usr_id = usr_tbl.id " .
" WHERE usr_tbl.statusdatetime = st.datetime ORDER BY st.status";
} elseif ($mailto_radio == 'rsp') {
$sqlString = "SELECT st.status, usr_tbl.* FROM srv_userstatus AS st LEFT JOIN ( SELECT max(s.datetime) as statusdatetime, u.* FROM srv_user as u" .
" LEFT JOIN srv_userstatus AS s ON u.id = s.usr_id AND u.unsubscribed='0' WHERE u.ank_id = '" . $this->anketa . "' AND recnum > '0' GROUP BY s.usr_id) AS usr_tbl ON st.usr_id = usr_tbl.id " .
" WHERE usr_tbl.statusdatetime = st.datetime ORDER BY st.status";
} elseif ($mailto_radio == 'status') {
if (!isset ($mailto_status) || $mailto_status == null || $mailto_status == "") {
$errorMsg = "Status ni izbran!";
} else {
// nardimo string statusov
$sqlString = "SELECT id, last_status as status, cookie, pass FROM srv_user WHERE ank_id = '" . $this->anketa . "' AND unsubscribed='0' AND last_status IN (" . $mailto_status . ") ORDER BY last_status";
}
} else {
$errorMsg = "Napaka!";
}
return array(
'sqlString' => $sqlString,
'errorMsg' => $errorMsg
);
}
/** Preveri ali uporabnik ustreza minimalni zahtevi statusa
*
* @param $minimum_role_request minimalna zahteva (lahko podamo kot array posamezno)
* @return true/false
*/
function user_role_cehck($minimum_role_request = U_ROLE_ADMIN)
{
global $admin_type;
if (is_array($minimum_role_request) && count($minimum_role_request) > 0) { // ce podamo kot array preverimo za vsak zapis posebej
foreach ($minimum_role_request as $role) {
if ($admin_type == $role)
return true;
}
} else {
if ($admin_type <= $minimum_role_request)
return true;
}
return false;
}
var $getSurvey_type = null;
function getSurvey_type($sid)
{
if ($this->getSurvey_type != null)
return $this->getSurvey_type;
// polovimo tip ankete
SurveyInfo::getInstance()->SurveyInit($sid);
$this->getSurvey_type = SurveyInfo::getInstance()->getSurveyColumn("survey_type");
return $this->getSurvey_type;
}
/**
* prikaze infobox
*
*/
function displayInfoBox()
{
// klicemo iz SurveyInfo
SurveyInfo::getInstance()->SurveyInit($this->anketa);
SurveyInfo::getInstance()->DisplayInfoBox();
}
/**
* TODO ????
*
* @param mixed $grupa
* @param mixed $editmode
*/
function showEditPageDiv($grupa, $editmode = false){
global $lang;
if (!$editmode && SurveyInfo::getInstance()->checkSurveyModule('uporabnost')) {
SurveySetting::getInstance()->Init($this->anketa);
$link = SurveySetting::getInstance()->getSurveyMiscSetting('uporabnost_link_' . $grupa);
if (strlen($link) > 7)
echo ', Link: ' . $link;
}
echo '
';
if ($editmode) {
//polovimo ime grupe
$sql = sisplet_query("SELECT id, naslov FROM srv_grupa WHERE id = '$grupa'");
$row = mysqli_fetch_array($sql);
echo ' ';
}
/**
* TODO ???
*
* @param mixed $anketa
*/
private static $checkAnketaExist = array();
function checkAnketaExist($anketa = 0)
{
if ($anketa == 0)
$anketa = $this->anketa;
if (isset(self::$checkAnketaExist[$anketa]))
return self::$checkAnketaExist[$anketa];
$sqlString = "SELECT count(*) FROM srv_anketa WHERE active >= '0' AND id = '" . $anketa . "'";
$sqlQuery = sisplet_query($sqlString);
$sqlRow = mysqli_fetch_array($sqlQuery);
self::$checkAnketaExist[$anketa] = ($sqlRow[0] > 0) ? true : false;
return self::$checkAnketaExist[$anketa];
}
/**
* TODO ???
*
* @param mixed $needed
*/
function alert_add_necessary_sysvar($needed = array(), $updateUserBase = false)
{
global $lang;
if (is_array($needed) && count($needed) > 0) {
$needed = $needed;
} else {
$needed = array('email', 'ime');
}
SurveyRespondents::Init($this->anketa);
SurveyRespondents::checkSystemVariables($needed, $updateUserBase);
return $needed;
}
/**
* TODO ???
*
*/
function alert_change_user_from_cms()
{
global $lang;
// nastavimo respondent iz cms
echo $lang['srv_alert_respondent_cms'];
$mysqlUpdate = sisplet_query("UPDATE srv_anketa SET user_from_cms = '1' WHERE id='" . $this->anketa . "'");
// vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
if (!$mysqlUpdate) {
echo mysqli_error($GLOBALS['connect_db']);
} else {
echo $lang['srv_alert_respondent_cms_note_ok'];
echo '
';
}
}
/**
* TODO ???
*
*/
function anketa_aktivacija_note()
{
global $lang;
$row = SurveyInfo::getInstance()->getSurveyRow();
if ($row['active'] == 0) {
echo $lang['srv_url_survey_not_active'];
echo '
';
echo ' ';
echo ' ' . $lang['srv_anketa_setActive'] . ' ';
echo ' ';
echo ' ';
} else {
echo $lang['srv_url_intro_active'];
echo '
';
echo ' ';
echo ' ' . $lang['srv_anketa_setNoActive'] . ' ';
echo ' ';
echo ' ';
}
}
/** prikaze div da so nastavitve shranjene in ga nato skrije
*
*/
function displaySuccessSave()
{
global $lang;
echo $lang['srv_success_save'];
}
/** pravilno redirekta admin url ankete
* če je anketa aktivna gre na dashboard
* če anketa ni aktivna gre na:
* - v primeru da še ni bila kativirana gre na urejanje
* - v primeru da je bila aktivirana (je pretekla) gre na dashboard
*/
function redirectLink()
{
global $site_url;
# ugotovimo ali je uporabnik telefonski anketar
if ($this->isAnketar) {
#če je anketar lahko samo kliče
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_TELEPHONE . '&m=start_call');
exit();
}
// v kolikor je aktivna hierarhija preusmerimo uporabnika na status od hierarhije
if (SurveyInfo::getInstance()->checkSurveyModule('hierarhija')) {
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
// v kolikor je uporabnik admin, ga preusmerimo na dostop za administratorje
if($hierarhija_type < 5){
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_HIERARHIJA_SUPERADMIN . '&m='.M_HIERARHIJA_STATUS);
exit();
}
// vse ostale uporabnike preusmerimo na običajni pogled hierarhije
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_HIERARHIJA. '&m='.M_HIERARHIJA_STATUS);
exit();
}
# če nima dostopa do statusa ali urejanja je potreben redirekt kam drugam
$d = new Dostop();
if (!$d->checkDostopSub('edit') || !$d->checkDostopSub('dashboard')) {
// Po prioriteti vrstni red strani kamor preusmerimo ce ima uporabnik dostop
if ($d->checkDostopSub('edit')) {
header('Location: index.php?anketa=' . $this->anketa);
die();
} elseif ($d->checkDostopSub('dashboard')) {
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_REPORTI);
die();
} elseif ($d->checkDostopSub('test')) {
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_TESTIRANJE);
die();
} elseif ($d->checkDostopSub('publish')) {
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_VABILA);
die();
} elseif ($d->checkDostopSub('data')) {
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_COLLECT_DATA);
die();
} elseif ($d->checkDostopSub('analyse')) {
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_ANALYSIS);
die();
} else {
header('location: ' . $site_url . 'admin/survey/');
die();
}
}
# ugotovimo status ankete
SurveyInfo::getInstance()->SurveyInit($this->anketa);
if (SurveyInfo::getSurveyColumn('active') == 1) {
# anketa je aktivna, gremo na dashboard
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_REPORTI);
exit();
}
else {
# preverimo ali je bila anketa že aktivirana
$activity = SurveyInfo:: getSurveyActivity();
$_last_active = end($activity);
if (isset($_last_active) && $_last_active != null) {
# anketa je že bila aktivirana in je potekla gremo na dashboard
header('Location: index.php?anketa=' . $this->anketa . '&a=' . A_REPORTI);
exit();
} else {
# anketa še ni bila aktivirana gremo na urejanje
header('Location: index.php?anketa=' . $this->anketa);
exit();
}
}
die();
}
function displayAktivnost()
{
global $lang, $site_url, $admin_type;
$hierarhija_type = (!empty($_SESSION['hierarhija'][$this->anketa]['type']) ? $_SESSION['hierarhija'][$this->anketa]['type'] : null);
SurveyInfo::getInstance()->SurveyInit($this->anketa);
$row = SurveyInfo::getInstance()->getSurveyRow();
SurveySetting::getInstance()->Init($this->anketa);
if ($row['active'] == 1) // preverimo če je čas aktivacije potekel potem anketo deaktiviramo
$row['active'] = $this->checkSurveyActive();
$link = SurveyInfo::getSurveyLink();
$activity = SurveyInfo:: getSurveyActivity();
$_last_active = end($activity);
$preview_disableif = SurveySetting::getInstance()->getSurveyMiscSetting('preview_disableif');
$preview_disablealert = SurveySetting::getInstance()->getSurveyMiscSetting('preview_disablealert');
$preview_displayifs = SurveySetting::getInstance()->getSurveyMiscSetting('preview_displayifs');
$preview_displayvariables = SurveySetting::getInstance()->getSurveyMiscSetting('preview_displayvariables');
$preview_hidecomment = SurveySetting::getInstance()->getSurveyMiscSetting('preview_hidecomment');
$preview_options = '' . ($preview_disableif == 1 ? '&disableif=1' : '') . ($preview_disablealert == 1 ? '&disablealert=1' : '') . ($preview_displayifs == 1 ? '&displayifs=1' : '') . ($preview_displayvariables == 1 ? '&displayvariables=1' : '') . ($preview_hidecomment == 1 ? '&hidecomment=1' : '') . '';
// Predogled in testiranje (ikona monitor)
echo '
';
echo ' ';
echo '' . $lang['srv_monitor_toolbox_title'] . ' ';
echo '';
// Ce imamo izklopljene mobilne prilagoditve ne pustimo preview-ja na mobile, ker itak ne prikaze scalano
$mobile_friendly = SurveySetting::getInstance()->getSurveyMiscSetting('mobile_friendly');
if($mobile_friendly != '0'){
echo '' . $lang['srv_preview'] . ' PC ';
echo ' (' . $lang['srv_preview_mobile'] . ' , ';
echo '' . $lang['srv_preview_tablet'] . ' )' . $lang['srv_preview'] . ' PC
';
// V formi in glasovanju nimamo testnih vnosov
if ($this->survey_type != 0 && $this->survey_type != 1) {
echo '';
echo '' . $lang['srv_survey_testdata'] . ' ';
echo ' ';
echo ' '; // expanded-tooltip bottom
echo ' '; // request-help
# url ankete
echo '
';
if ($row['active'] == 1 && !SurveyInfo::getInstance()->checkSurveyModule('hierarhija')) {
echo '';
//echo ' ';
} elseif (SurveyInfo::getInstance()->checkSurveyModule('hierarhija')) {
echo ''.$site_url.'sa ';
} else {
echo $link;
}
echo ' ';
$d = new Dostop();
if ($d->checkDostopAktiven()) {
echo '
';
if (SurveyInfo::getSurveyColumn('active') == 1) {
# anketa je aktivna
# V kolikor gre za hierarhijo in uporabnik ni administrator hierarhije
if (SurveyInfo::getInstance()->checkSurveyModule('hierarhija')){
if ($hierarhija_type == 1) {
echo '';
} else{
echo ' ';
}
}else {
echo ' ';
}
echo 'ON
';
echo ' ';
} else {
$anketa_active = "anketa_active('" . $this->anketa . "','" . $row['active'] . "'); ";
//Preden anketo aktiviramo preverimo, če gre tudi za izgradnjo hierarhije in če anketa še ni bila aktivirana
if (SurveyInfo::getInstance()->checkSurveyModule('hierarhija')){
if ($hierarhija_type == 1) {
echo '';
} else{
echo ' ';
}
}else {
echo ' ';
}
if ((int)$_last_active > 0) {
# anketa je zaključena
echo 'OFF
';
} else {
# anketa je neaktivna
echo 'OFF
';
}
echo ' ';
}
// Ce ima uporabnik prepreceno moznost odklepanja ankete, anketo ima vedno zaklenjeno če je vklopljena hierarhija
$prevent_unlock = (SurveyInfo::getSurveyModules('hierarhija') == 2 || $d->checkDostopSub('lock') && $row['locked'] == 1 && ($admin_type != 0 && $admin_type != 1)) ? 1 : 0;
if ($prevent_unlock == 1) {
echo '';
echo ' ';
} else {
# zaklepanje
//echo '';
} else {
echo ' ';
}
echo ' ';
}
echo ' ';
}
# Objava na FB, twitter, .... share pac
if ($row['active'] == 1 && false) {
# NE PRIKAZUJEMO IKONIC
$sqlu = sisplet_query("SELECT email FROM users WHERE id='" . $this->uid() . "'");
$rowu = mysqli_fetch_array($sqlu);
if ($rowu['email'] == '') {
$sqlm = sisplet_query("SELECT value FROM misc WHERE what = 'AlertFrom'");
$rowm = mysqli_fetch_array($sqlm);
$rowu['email'] = $rowm['value'];
}
?>
anketa;
$qry = sisplet_query($str);
if (mysqli_num_rows($qry) == 0) {
# če anketa še ni bila kativirana jo aktiviramo za tri mesece
$row = SurveyInfo::getInstance()->getSurveyRow();
#(3) čim klikne na OBJAVA naj se zadeva tudi ze kar aktivira (kot bi kliknil na AKTIVIRAJ (vendar brez popupa in dajte daafulut trajanje na 3 miesece.
if ($row['active'] != 1) {
$uString = "UPDATE srv_anketa SET active = '1', starts=NOW(), expire = date_add(NOW(), INTERVAL 3 MONTH) WHERE id='" . $this->anketa . "'";
$s = sisplet_query($uString);
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
#updejtamo še stv_activity
$uString = "INSERT INTO srv_activity (sid, starts, expire, uid) VALUES ('" . $this->anketa . "', NOW(), date_add(NOW(), INTERVAL 3 MONTH), '" . $global_user_id . "')";
$s = sisplet_query($uString);
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
SurveyInfo:: getInstance()->SurveyInit($this->anketa);
# vsilimo refresh podatkov
SurveyInfo:: getInstance()->resetSurveyData();
}
}
}
}
?>
' . $errorMsg . '
uporabi predlogo
uredi predlogo
izbriši predlogo
' . $lang['srv_userbase_add_list'] . '
' . $lang['srv_userbase_edit_list'] . '
' . $lang['srv_userbase_delete_list'] . '![' . $lang['srv_editirajgrupo'] . '](img_' . $this->skin . '/edit_gray.png)
![' . $lang['srv_brisigrupo'] . '](img_' . $this->skin . '/delete_gray.png)
';
}
}
/**
* TODO ???
*
*/
function anketa_aktivacija_note()
{
global $lang;
$row = SurveyInfo::getInstance()->getSurveyRow();
if ($row['active'] == 0) {
echo $lang['srv_url_survey_not_active'];
echo ' .'.png)