';
if($lang_admin == 1){
echo ' English';
}
else{
echo ' Slovenščina';
}
echo '
';
}
/** Seznam vseh anket ki so na voljo posameznemu uporabniku
*
*/
function reloadSurveys() {
# polovimo seznam uporabnikovih anket
$this->dostopCondition = null;
$this->surveys_ids = array();
$stringSurveyList = "SELECT id, backup, active, folder, dostop FROM srv_anketa sa WHERE sa.backup='0' AND sa.id > 0 AND sa.active >= 0 AND sa.invisible = '0' ".$this->getFolderCondition().$this->getDostopAnketa();
$sqlSurveyList = sisplet_query($stringSurveyList);
while ( $rowSurveyList = mysqli_fetch_assoc($sqlSurveyList)) {
$this->surveys_ids[$rowSurveyList['id']] = $rowSurveyList['id'];
}
}
function setUserId() {
# nastavimo filter po userju
if ($_GET['a'] == 'surveyList_user' && (int)$_POST['uid'] > 0 && ($_POST['list_user_type'] == 'i' || $_POST['list_user_type'] == 'e')) {
$_SESSION['sl_uid'] = (int)$_POST['uid'];
$_SESSION['sl_typ'] = $_POST['list_user_type'];
$this->user_id = (int)$_POST['uid'];
} else {
unset($_SESSION['sl_uid']);
unset($_SESSION['sl_typ']);
$this->user_id = null;
}
$this->reloadSurveys();
# posodobimo podatke prikazanih anket
$this -> refreshData();
}
function setUserLanguage() {
# nastavimo filter po userju
if ( isset($_POST['lang_id']) && (int)$_POST['lang_id']) {
$_SESSION['sl_lang_id'] = (int)$_POST['lang_id'];
$this->lang_id = (int)$_POST['lang_id'];
} else {
unset($_SESSION['sl_lang_id']);
$this->lang_id = 0;
}
$this->reloadSurveys();
# posodobimo podatke prikazanih anket
$this -> refreshData();
}
function setUserGDPR() {
# nastavimo filter po GDPR anketah
if ( isset($_POST['gdpr']) && (int)$_POST['gdpr']) {
$_SESSION['sl_gdpr'] = (int)$_POST['gdpr'];
$this->gdpr = (int)$_POST['gdpr'];
} else {
unset($_SESSION['sl_gdpr']);
$this->gdpr = 0;
}
$this->reloadSurveys();
# posodobimo podatke prikazanih anket
$this -> refreshData();
}
function setUserLibrary() {
# nastavimo filter po folderju knjiznice
if ( isset($_POST['currentLibrary']) && (int)$_POST['currentLibrary']) {
$_SESSION['currentLibrary'] = (int)$_POST['currentLibrary'];
$this->currentLibrary = (int)$_POST['currentLibrary'];
} else {
unset($_SESSION['currentLibrary']);
$this->currentLibrary = 0;
}
$this->reloadSurveys();
# posodobimo podatke prikazanih anket
$this -> refreshData();
}
/** Polovimo podatke anket in jih izrišemo
*
*/
public function getSurveys() {
global $global_user_id;
global $lang;
// Gumba za ustvarjanje ankete - nekatere niso prikazane pri searchu
if($this->isSearch != 1){
// Gumb za ustvarjanje ankete
if(DomainChange::check1kaDomainChange() && DomainChange::getInstance($global_user_id)->domainChangeLimits()){
/*echo '';
$this->new_anketa_div();
echo '
';*/
}
else{
echo '';
$this->new_anketa_div();
echo '
';
}
}
// Druga vrstica - filtri in iskanje
echo '';
// Nastavitve zgoraj - nekatere niso prikazane pri searchu
if($this->isSearch != 1){
// Okno za search po mojeih anketah
echo '
';
// Izris seznama anket
if($this->show_folders == 1 && $this->isSearch != 1){
echo '';
$this->displaySearch();
echo '
';
// Paginacija
echo '';
$this->displayPagiantion();
echo '
';
// Filtri na desni
if($this->onlyPhone == false){
echo '';
// Preklop na pogled s folderji (samo ce imamo nov vmesnik)
//echo '
';
}
}
else{
// Okno z nastavitvami searcha
echo '';
$this->displayFolderSwitch();
//echo '
';
// Gumb za filtriranje
//echo '';
$this->displayFilterButton();
//echo '
';
// Gumb za sortiranje
echo '';
$this->displaySortButton();
echo '
';
echo '';
$this->displaySearchSettings();
echo '
';
}
echo '';
// Loop po vseh folderjih prvega nivoja - samo na prvi strani
if($this->pageno == 1){
// Plus za dodajanje folderja
echo '';
$sql = sisplet_query("SELECT * FROM srv_mysurvey_folder WHERE usr_id='$global_user_id' AND parent='0' ORDER BY naslov ASC");
if(mysqli_num_rows($sql) > 0) {
while($row = mysqli_fetch_array($sql)){
echo '
';
}
// Ce ne prikazujemo map je vse po starem
else{
echo '';
$this->displayNewFolder($row);
echo '
';
}
}
}
// Na koncu se izpisemo ankete ki niso v nobenem folderju
$row = array('id'=>0, 'naslov'=>$lang['srv_mySurvey_unallocated']);
echo '';
$this->displayNewFolder($row);
echo '
';
echo '';
echo '';
$this->displayNewSurveyList($folder=-1);
echo '
';
}
// Paginacija - se na dnu - ni prikazana pri searchu
if($this->isSearch != 1){
echo '';
echo '
';
}
// Klik izven "Vec" - zapremo okno
echo '';
}
/** Kreacija nove ankete
*/
function new_anketa_div(){
global $lang;
global $admin_type;
global $site_url;
echo '';
echo ' ';
echo '';
// uporabniki z vklopljeno moznostjo imajo tudi hitro ustvarjanje ankete (brez vnosa imena in izbire skina)
$oneclickCreateMySurveys = UserSetting::getInstance()->getUserSetting('oneclickCreateMySurveys');
if ($oneclickCreateMySurveys == 1) {
echo '';
}
}
function displayNewSurveyList($folder=0) {
global $lang;
global $site_url;
global $global_user_id;
if (SRV_LIST_GET_AS_LIST == true) {
$ankete = $this->getSurveysAsListNew($folder);
echo '';
echo '';
if ($count = count($ankete)) {
// Naslov za search
if($this->isSearch == 1){
if($count == 1)
$hits = $lang['s_hits_1'];
elseif($count == 2)
$hits = $lang['s_hits_2'];
elseif($count == 3 || $count == 4)
$hits = $lang['s_hits_34'];
else
$hits = $lang['s_hits'];
// Ce imamo vec kot 1000 zadetkov izpisemo samo 1000 in opozorilo
if($count < 1000)
$cnt_text = '('.$count.' '.$hits.')';
else
$cnt_text = '('.$lang['s_hits_1000'].')';
echo ''.$lang['s_search_mySurvey_title'].' '.$cnt_text.':';
}
echo '';
$this->displayPagiantion();
echo '
';
echo '| '; echo $this->createOrderUrlNew(1, $lang['title']); echo ' | '; // Trajanje - status echo ''; echo $this->createOrderUrlNew(18, 'Status'); echo ' | '; // Ustvarjeno echo ''; echo $this->createOrderUrlNew(10, $lang['srv_created']); echo ' | '; // Zadnji vnos echo ''; echo $this->createOrderUrlNew(16, $lang['srv_last_insrt']); echo ' | '; // Sprememba echo ''; echo $this->createOrderUrlNew(14, $lang['change']); echo ' | '; // Ostalo echo ''; echo $lang['more2']; echo ' | '; echo '
| ';
if(strlen($anketa['naslov']) > 60)
$text = substr($anketa['naslov'],0,60);
else
$text = $anketa['naslov'];
// Ce gre za search moramo ustrezno pobarvati najden del besede
$text_searched = $text;
if($this->isSearch == 1 && $this->searchSettings['stype'] == '0'){
foreach($this->searchStringProcessed as $search_word){
// Pobarvamo najden niz v naslovu ankete
preg_match_all("/$search_word+/i", $text_searched, $matches);
if (is_array($matches[0]) && count($matches[0]) >= 1) {
// Drugace vcasih pobrise presledek, ne vem kako drugace resit:)
$text_searched = str_replace(' ', ' ', $text_searched);
$text_searched = str_replace($matches[0][0], ''.$matches[0][0].'', $text_searched);
}
}
}
// Zgornja vrstica
echo ' ';
echo ' '.$text_searched.'';
echo ' ';
// Spodnja vrstica
echo '';
if($anketa['mobile_created'] == '1')
echo 'M';
if($anketa['survey_type'] == 0)
echo $lang['srv_vrsta_survey_type_0'];
elseif($anketa['survey_type'] == 1)
echo $lang['srv_vrsta_survey_type_1'];
elseif(SurveyInfo::checkSurveyModule('hierarhija', $anketa['id']))
echo $lang['srv_vrsta_survey_type_10'];
else
echo $lang['srv_vrsta_survey_type_2'];
echo ', '.$lang['srv_h_sl_stvprasanj'].': '. $anketa['variables'];
echo ' ';
echo ' | ';
// Trajanje - status
echo '';
if ($anketa['active'] == 1) {
$now = time();
$do = explode('.', $anketa['trajanjedo']);
$do = strtotime($do[0].'.'.$do[1].'.20'.$do[2]);
$trajanje = $do - $now;
$trajanje = floor($trajanje/60/60/24) + 1;
if($trajanje >= 0){
// Ce je aktivna za vec kot 2000 dni je trajna
if($trajanje > 2000){
$status_text = $lang['srv_trajna_anketa'];
}
else{
$status_text = $lang['more'].' '.$trajanje.' '.$lang['hour_days'];
}
}
else{
$status_text = $lang['srv_trajna_anketa'];
}
$status_color = 'green';
}
else {
$sqlA = sisplet_query("SELECT sid FROM srv_activity WHERE sid='".$anketa['id']."'");
if (mysqli_num_rows($sqlA) > 0) {
# anketa je zaključena
$status_text = $lang['srv_survey_list_closed'];
$status_color = 'blue';
}
else {
# anketa je neaktivna
$status_text = $lang['srv_survey_list_inpreparation'];
$status_color = 'gray';
}
}
echo ' '.$status_text.' ';
echo ' | ';
// Ustvarjeno
echo '';
// Ce gre za search moramo ustrezno pobarvati najden del besede
$name_searched = $anketa['i_name'];
$surname_searched = $anketa['i_surname'];
if($this->isSearch == 1 && $this->searchSettings['stype'] == '1'){
foreach($this->searchStringProcessed as $search_word){
// Pobarvamo najden niz v imenu
preg_match_all("/$search_word+/i", $name_searched, $matches);
if (is_array($matches[0]) && count($matches[0]) >= 1) {
foreach ($matches[0] as $match) {
$name_searched = str_replace($match, ''.$match.'', $name_searched);
}
}
// Pobarvamo najden niz v priimku
preg_match_all("/$search_word+/i", $surname_searched, $matches);
if (is_array($matches[0]) && count($matches[0]) >= 1) {
foreach ($matches[0] as $match) {
$surname_searched = str_replace($match, ''.$match.'', $surname_searched);
}
}
}
}
$i_time = substr($anketa['i_time'], 0, 8);
$i_time = explode('.', $i_time);
echo ' ';
echo $i_time[0].'.'.$i_time[1].'.20'.$i_time[2];
echo ' ';
echo '';
echo $name_searched.' '.$surname_searched;
echo ' ';
echo ' | ';
// Zadnji vnos
echo '';
echo ' ';
if($anketa['answers'] > 0){
$v_time = substr($anketa['v_time_last'], 0, 8);
$v_time = explode('.', $v_time);
// Nimamo parapodatkov
if($anketa['v_time_last'] == '00.00.00 0:00')
echo $lang['srv_survey_list_no_paradata'];
else
echo $v_time[0].'.'.$v_time[1].'.20'.$v_time[2];
}
else{
echo '/';
}
echo ' ';
echo '';
echo $lang['srv_info_answers_no'].': '.$anketa['answers'];
echo ' ';
echo ' | ';
// Sprememba
echo '';
echo ' ';
$e_time = substr($anketa['e_time'], 0, 8);
$e_time = explode('.', $e_time);
echo $e_time[0].'.'.$e_time[1].'.20'.$e_time[2];
echo ' ';
echo '';
echo ' '.$anketa['e_email'].'';
echo ' ';
echo ' | ';
// Ostalo
echo '';
echo ' ';
// Hover okno
echo ' ';
echo '
| ';
echo '
';
echo '';
echo ' '.$folder['naslov'].'';
// Dodaten div za klik za razpiranje
echo '';
// Ikona za dodajanje folderja
echo '
';
echo '';
$this->displayNewSurveyList($folder=0);
echo '
';
}
else{
echo '';
// Puscica za odpiranje/zapiranje
echo '';
// Ikona mape
echo '';
// Naslov folderja
echo '
';
echo ''.$folder['naslov'].'
';
echo '';
// Dodaten div za klik za razpiranje
echo '';
echo '';
$this->displayNewSurveyList($folder['id']);
// Izpisemo se vse folderje znotraj trenutnega folderja
$sql = sisplet_query("SELECT * FROM srv_mysurvey_folder WHERE usr_id='$global_user_id' AND parent='".$folder['id']."' ORDER BY id DESC");
if(mysqli_num_rows($sql) > 0) {
while($row = mysqli_fetch_array($sql)){
echo '
';
}
}
/** Prikažemo navigacijo po straneh rezultatov
*
*/
function displayPagiantion() {
global $site_url, $lang;
//$this->max_pages = 100;
# ali sploh izrisujemo paginacijo
if ($this->max_pages > 1) {
if ($this->onlyPhone == false) {
$baseUrl = $site_url."admin/survey/index.php?pageno=";
} else {
$baseUrl = $site_url."admin/survey/index.php?a=phoneSurveys&pageno=";
}
# povezava na prejšnjo stran
$prev_page = $this->pageno - 1;
if($prev_page >= 1) {
echo '';
$this->displayNewFolder($row);
echo '
';
}
}
echo '';
}
else {
# brez href povezave
echo '
';
}
# povezave za vmesne strani
$middle = $this->max_pages / 2;
$skipped = false;
for($a = 1; $a <= $this->max_pages; $a++) {
if ($this->max_pages < ((SRV_LIST_GROUP_PAGINATE+1) * 2) || $a <= SRV_LIST_GROUP_PAGINATE || $a > ($this->max_pages-SRV_LIST_GROUP_PAGINATE)
|| ( abs($a-$this->pageno) < SRV_LIST_GROUP_PAGINATE)) {
if ($skipped == true) {
echo '
. . .
';
$skipped = false;
}
if($a == $this->pageno) {
# brez href povezave
echo ''.$a.'
';
}
else {
echo ''.$a.'
';
}
}
else {
$skipped = true;
}
}
# povezava na naslednjo stran
$next_page = $this->pageno + 1;
if($next_page <= $this->max_pages) {
echo '';
}
else {
# brez href povezave
echo '
';
}
}
}
// Prikazemo gumb za sortiranje seznama anket
protected function displaySortButton(){
global $lang, $site_url;
echo '';
echo '
';
echo '
';
}
// Prikazemo gumb za filtriranje seznama anket
protected function displayFilterButton(){
global $lang, $site_url, $admin_languages;
echo '- ';
if($this->sorttype == 2){
$sort = 1;
$img_src = 'sort_ascending';
}
else{
$sort = 2;
$img_src = 'sort_descending';
}
echo '
- sortby == 1 ? ' class="active"' : '').'>'.$lang['sort_by_title'].' '; echo '
- sortby == 6 ? ' class="active"' : '').'>'.$lang['sort_by_qcount'].' '; echo '
- sortby == 5 ? ' class="active"' : '').'>'.$lang['sort_by_answercount'].' '; echo '
- sortby == 16 ? ' class="active"' : '').'>'.$lang['sort_by_insert'].' '; echo '
- sortby == 14 ? ' class="active"' : '').'>'.$lang['sort_by_edit'].' '; echo '
- sortby == 18 ? ' class="active"' : '').'>Status '; echo '
- sortby == 7 ? ' class="active"' : '').'>
- sortby == 7 ? ' class="active"' : '').'>'.$lang['sort_by_author'].'
';
echo ' - sortby == 11 ? ' class="active"' : '').' style="border:0;">'.$lang['sort_by_editor'].' '; echo '
user_id || $this->lang_id != 0 || $this->gdpr != 0) ? 'class="active"' : '').'>';
echo '';
echo '
';
}
// Prikazemo preklop med navadnim pogledom in pogledom s folderji
protected function displayFolderSwitch(){
global $lang, $global_user_id, $site_url;
// Preverimo, ce je funkcionalnost v paketu, ki ga ima uporabnik
$userAccess = UserAccess::getInstance($global_user_id);
// Ce ni na voljo
if(!$userAccess->checkUserAccess('my_survey_folders')){
echo '';
echo '
';
echo '- ';
# filter po uporabniku
echo '
- '; echo ''.$lang['srv_list_author'].''; // Ce preklapljamo v searchu moramo refreshati celo stran (druga js funkcija) $reload = ($this->isSearch == 1) ? '_reload' : ''; echo 'user_id ? 'checked="checked"' : '').' onclick="surveyList_user'.$reload.'(\'clr\',\'0\');"> '; echo 'user_id ? 'checked="checked"' : '').' onclick="surveyList_user'.$reload.'(\'uid\',\''.$this->g_uid.'\');"> '; echo ' '; # filter po jeziku echo '
- '; echo ''.$lang['srv_sl_set_language'].''; echo 'lang_id == 0 ? 'checked="checked"' : '').' onclick="surveyList_language'.$reload.'(\'0\');"> '; echo 'lang_id == 1 ? 'checked="checked"' : '').' onclick="surveyList_language'.$reload.'(\'1\');"> '; echo 'lang_id == 2 ? 'checked="checked"' : '').' onclick="surveyList_language'.$reload.'(\'2\');"> '; echo ' '; # filter po GDPR anketah echo '
- '; echo ''.$lang['srv_gdpr'].''; echo 'gdpr == 0 ? 'checked="checked"' : '').' onclick="surveyList_gdpr'.$reload.'(\'0\');"> '; echo 'gdpr == 1 ? 'checked="checked"' : '').' onclick="surveyList_gdpr'.$reload.'(\'1\');"> '; echo ' '; echo '
';
echo $lang['srv_mySurvey_show_folders'];
echo ' ';
echo '
';
}
else{
echo '';
echo ' '.$lang['srv_mySurvey_show_folders'].'';
// Stikalo za folderje
if($this->show_folders == 1)
echo ' ';
else
echo ' ';
echo '
';
}
}
private function displaySettingsUrl() {
global $lang;
echo ' '.$lang['settings'].'';
echo '';
}
// Prikazemo nastavitve za napredno iskanje ce iscemo po anketah
protected function displaySearchSettings(){
global $lang;
global $site_url;
// NAPREDNE NASTAVITVE ISKANJA
$show_advanced_search = false;
if($this->searchSettings['sstatus'] != '0'
|| $this->searchSettings['sidatefrom'] != ''
|| $this->searchSettings['sidateto'] != ''
|| $this->searchSettings['sedatefrom'] != ''
|| $this->searchSettings['sedateto'] != ''){
$show_advanced_search = true;
}
echo '';
}
// Prikazemo search okno za iskanje po anketah
public function displaySearch(){
global $lang;
global $site_url;
echo '';
}
/** polovimo nastavitve prikaza za posameznega uporabnika
*
*/
private function getSettings($display_default = false) {
$defaultOrder = $this->dataFields;
$resultArray = array();
$izBaze = false;
if ($this->g_uid > 0) {
$saved_surveyList_string = UserSetting::getInstance()->getUserSetting('survey_list_order');
$saved_surveyList_visible_string = UserSetting::getInstance()->getUserSetting('survey_list_visible');
$saved_surveyList_visible = array_unique(explode(",",isset($saved_surveyList_visible_string)?$saved_surveyList_visible_string:''));
if (isset($saved_surveyList_string) && $saved_surveyList_string != "" && !$display_default ) {
$saved_surveyList_order = array_unique(explode(",",$saved_surveyList_string));
$izBaze = true;
// uporabimo shranjene nastavitve
foreach ( $saved_surveyList_order as $order) {
if (in_array($order,$saved_surveyList_visible))
{
$defaultOrder[$order]['visible'] = 1;
} else {
$defaultOrder[$order]['visible'] = 0;
}
if (isset($defaultOrder[$order]['order_by']) && isset($defaultOrder[$order]))
{
$resultArray[$defaultOrder[$order]['order_by']] = $defaultOrder[$order];
if (isset($defaultOrder[$order]))
{
unset($defaultOrder[$order]);
}
}
}
}
}
// za vse ostalo uporabimo privzete nastavitve
foreach ( $defaultOrder as $order)
{
if ($izBaze)
{
$order['visible'] = 0; // ponastavimo vidnost ?e imamo iz baze
}
if (isset($order['order_by']))
{
$resultArray[$order['order_by']] = $order;
}
}
return $resultArray;
}
private function getSurveysAsList() {
$result = array();
// ce imas hkrati dostop do ankete (srv_dostop) in preko managerskega dostopa (srv_dostop_manage) se brez DISTINCT podvajajo ankete
$stringSurveyList = "SELECT DISTINCT sa.id, sa.folder, '1' as del, sa.naslov, sa.active, sa.edit_time, ";
$stringSurveyList .= ( $this->settingsArray['lib_glb']['visible'] == 1 ) ? 'sal.lib_glb AS lib_glb, ' :'';
$stringSurveyList .= ( $this->settingsArray['lib_usr']['visible'] == 1 ) ? 'sal.lib_usr AS lib_usr, ' : '';
$stringSurveyList .= ( $this->settingsArray['e_name']['visible'] == 1 || $this->settingsArray['e_surname']['visible'] == 1 || $this->settingsArray['e_email']['visible'] == 1 )
? "sa.edit_uid, sal.e_name AS e_name, sal.e_surname AS e_surname, sal.e_email AS e_email, " : '';
$stringSurveyList .= ( $this->settingsArray['i_name']['visible'] == 1 || $this->settingsArray['i_surname']['visible'] == 1 || $this->settingsArray['i_email']['visible'] == 1 )
? "sa.insert_uid, sal.i_name AS i_name, sal.i_surname AS i_surname, sal.i_email AS i_email, " : '';
$stringSurveyList .= ( $this->settingsArray['edit_time']['visible'] == 1 ) ? "date_format(edit_time, '%d.%m.%y %k:%i') AS e_time, " : '';
$stringSurveyList .= ( $this->settingsArray['insert_time']['visible'] == 1 ) ? "date_format(insert_time, '%d.%m.%y %k:%i') AS i_time, " : '';
$stringSurveyList .= ( $this->settingsArray['vnos_time_first']['visible'] == 1 || $this->settingsArray['vnos_time_last']['visible'] == 1)
? "date_format(sal.a_first, '%d.%m.%y %k:%i') AS v_time_first, date_format(sal.a_last, '%d.%m.%y %k:%i') AS v_time_last, " : '';
$stringSurveyList .= "sal.answers as answers, "; // vedno prestejemo odgovore
$stringSurveyList .= ( $this->settingsArray['variables']['visible'] == 1 ) ? "sal.variables as variables, " : '';
$stringSurveyList .= ( $this->settingsArray['trajanjeod']['visible'] == 1 ) ? "date_format(sa.starts, '%d.%m.%y') as trajanjeod, " : '';
$stringSurveyList .= ( $this->settingsArray['trajanjedo']['visible'] == 1 ) ? "date_format(sa.expire, '%d.%m.%y') as trajanjedo, " : '';
$stringSurveyList .= ( $this->settingsArray['approp']['visible'] == 1 ) ? "approp, " : '';
$stringSurveyList .= "sd.canEdit, sa.survey_type "; // tega pustim tukaj, da ni problemov z vejico
$stringSurveyList .= "FROM srv_anketa sa ";
$stringSurveyList .= "LEFT OUTER JOIN srv_survey_list AS sal ON sal.id = sa.id " ;
# kdo lahko ureja anketo (briše)
// tega substringy se ne da dodatno razbit z prepareSubquery, ker selectamo 2 elementa...
$stringSurveyList .= "LEFT OUTER JOIN (SELECT 1 AS canEdit, ank_id FROM srv_dostop WHERE FIND_IN_SET('edit', dostop ) ='1' AND aktiven = '1' AND uid = '$this->g_uid' OR uid IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT user FROM srv_dostop_manage WHERE manager = '".$this->g_uid."'")).")) AS sd ON sd.ank_id = sa.id " ;
#$stringSurveyList .= "LEFT OUTER JOIN (SELECT ank_id, FIND_IN_SET('edit', dostop ) AS canEdit FROM srv_dostop WHERE aktiven = '1' AND uid = '$this->g_uid') AS sd ON sd.ank_id = sa.id " ;
$stringSurveyList .= "WHERE sa.backup='0' AND sa.id>0 AND active >= '0' AND invisible = '0' ";
//$stringSurveyList .= $this->getFolderCondition();
$stringSurveyList .= $this->getLanguageLimit();
$stringSurveyList .= $this->getDostopAnketa();
$stringSurveyList .= $this->getOrderString();
$stringSurveyList .= $this->getLimitString();
$sqlSurveyList = sisplet_query($stringSurveyList);
if (!$sqlSurveyList) {
print_r("ERROR in query:");
print_r($stringSurveyList);
echo mysqli_error($GLOBALS['connect_db']);
}
$ids = array();
while ($rowSurveyList = mysqli_fetch_assoc($sqlSurveyList)) {
$result[] = $rowSurveyList;
}
return $result;
}
// Dobimo seznam anket za nov prikaz (starega se naceloma ne uporablja vec)
private function getSurveysAsListNew($folder=0) {
$result = array();
// ce imas hkrati dostop do ankete (srv_dostop) in preko managerskega dostopa (srv_dostop_manage) se brez DISTINCT podvajajo ankete
$stringSurveyList = "SELECT DISTINCT sa.id, sa.folder, '1' as del, sa.naslov, sa.active, sa.mobile_created, sa.edit_time, ";
$stringSurveyList .= 'sal.lib_glb AS lib_glb, ';
$stringSurveyList .= 'sal.lib_usr AS lib_usr, ';
$stringSurveyList .= "sa.edit_uid, sal.e_name AS e_name, sal.e_surname AS e_surname, sal.e_email AS e_email, ";
$stringSurveyList .= "sa.insert_uid, sal.i_name AS i_name, sal.i_surname AS i_surname, sal.i_email AS i_email, ";
$stringSurveyList .= "date_format(edit_time, '%d.%m.%y %k:%i') AS e_time, ";
$stringSurveyList .= "date_format(insert_time, '%d.%m.%y %k:%i') AS i_time, ";
$stringSurveyList .= "date_format(sal.a_first, '%d.%m.%y %k:%i') AS v_time_first, date_format(sal.a_last, '%d.%m.%y %k:%i') AS v_time_last, ";
$stringSurveyList .= "sal.answers as answers, "; // vedno prestejemo odgovore
$stringSurveyList .= "sal.variables as variables, ";
$stringSurveyList .= "date_format(sa.starts, '%d.%m.%y') as trajanjeod, ";
$stringSurveyList .= "date_format(sa.expire, '%d.%m.%y') as trajanjedo, ";
$stringSurveyList .= "approp, ";
$stringSurveyList .= "sd.canEdit, sa.survey_type "; // tega pustim tukaj, da ni problemov z vejico
if($folder > 0)
$stringSurveyList .= ", sf.folder as mysurvey_folder ";
// Ce searchamo po besedah dodamo se uvod, zakljucek, naslove vprasanj in vrednosti vprasanj
if($this->isSearch == 1 && $this->searchSettings['stype'] == '2'){
$stringSurveyList .= ", sa.introduction AS introduction, sa.conclusion AS conclusion ";
$stringSurveyList .= ", sg.id AS sg_id, sg.ank_id AS sg_ank_id ";
$stringSurveyList .= ", ss.id AS ss_id, ss.naslov AS ss_naslov, ss.gru_id AS ss_gru_id ";
$stringSurveyList .= ", sv.id AS sv_id, sv.naslov AS sv_naslov, sv.spr_id AS sv_spr_id ";
}
$stringSurveyList .= "FROM srv_anketa sa ";
$stringSurveyList .= "LEFT OUTER JOIN srv_survey_list AS sal ON sal.id = sa.id " ;
$stringSurveyList .= "LEFT OUTER JOIN srv_library_anketa AS sla ON sla.ank_id = sa.id " ;
# kdo lahko ureja anketo (briše)
// tega substringy se ne da dodatno razbit z prepareSubquery, ker selectamo 2 elementa...
$stringSurveyList .= "LEFT OUTER JOIN (SELECT 1 AS canEdit, ank_id FROM srv_dostop WHERE FIND_IN_SET('edit', dostop ) ='1' AND aktiven = '1' AND uid = '$this->g_uid' OR uid IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT user FROM srv_dostop_manage WHERE manager = '".$this->g_uid."'")).")) AS sd ON sd.ank_id = sa.id " ;
#$stringSurveyList .= "LEFT OUTER JOIN (SELECT ank_id, FIND_IN_SET('edit', dostop ) AS canEdit FROM srv_dostop WHERE aktiven = '1' AND uid = '$this->g_uid') AS sd ON sd.ank_id = sa.id " ;
if($folder > 0)
$stringSurveyList .= "LEFT OUTER JOIN srv_mysurvey_anketa AS sf ON sf.ank_id = sa.id ";
// Ce iscemo po kljucnih besedah moramo dodat se tabele srv_grupa, srv_spremenljivka in srv_vrednost
if($this->isSearch == 1 && $this->searchSettings['stype'] == '2'){
$stringSurveyList .= "LEFT OUTER JOIN srv_grupa AS sg ON sg.ank_id = sa.id ";
$stringSurveyList .= "LEFT OUTER JOIN srv_spremenljivka AS ss ON ss.gru_id = sg.id ";
$stringSurveyList .= "LEFT OUTER JOIN srv_vrednost AS sv ON sv.spr_id = ss.id ";
}
// Ce iscemo po imenu ankete moramo dodat se tabele srv_nice_links za lepe linke
if($this->isSearch == 1 && $this->searchSettings['stype'] == '0'){
$stringSurveyList .= "LEFT OUTER JOIN srv_nice_links AS nl ON sa.id = nl.ank_id ";
}
$stringSurveyList .= "WHERE sa.backup='0' AND sa.id>0 AND active >= '0' AND invisible = '0' ";
//$stringSurveyList .= $this->getFolderCondition();
//$stringSurveyList .= $this->getLibraryCondition(); // Tega ni vec ker imamo nove folderje v mojih anketah
if($folder > 0)
$stringSurveyList .= "AND sf.usr_id='$this->g_uid' AND sf.folder='$folder' ";
elseif($folder == 0)
$stringSurveyList .= "AND NOT EXISTS (SELECT * FROM srv_mysurvey_anketa sma WHERE sma.ank_id=sa.id AND sma.usr_id='$this->g_uid') ";
// GDPR filter
if($this->gdpr == 1)
$stringSurveyList .= "AND EXISTS (SELECT * FROM srv_gdpr_anketa sgdpr WHERE sgdpr.ank_id=sa.id) ";
elseif($this->gdpr == 2)
$stringSurveyList .= "AND NOT EXISTS (SELECT * FROM srv_gdpr_anketa sgdpr WHERE sgdpr.ank_id=sa.id) ";
// Ce izvajamo search po anketah
if($this->isSearch == 1){
// Filter glede na search
$stringSurveyList .= $this->getSearchString();
// Filter glede na jezik ankete
$stringSurveyList .= $this->getLanguageLimit();
// Filter glede na dostop do ankete
$stringSurveyList .= $this->getDostopAnketa();
// Vrstni red anket
$stringSurveyList .= $this->getOrderString();
// Ce iscemo po kljucnih besedah moramo na koncu grupirat po anketi
if($this->searchSettings['stype'] == '2'){
//$stringSurveyList .= " GROUP BY id";
//$stringSurveyList .= " LIMIT 1000";
}
else{
// Limit anket
//$stringSurveyList .= $this->getLimitString();
$stringSurveyList .= " LIMIT 1000";
}
}
else{
// Filter glede na jezik ankete
$stringSurveyList .= $this->getLanguageLimit();
// Filter glede na dostop do ankete
$stringSurveyList .= $this->getDostopAnketa();
// Vrstni red anket
$stringSurveyList .= $this->getOrderString();
// Limit anket
$stringSurveyList .= $this->getLimitString();
}
$sqlSurveyList = sisplet_query($stringSurveyList);
if (!$sqlSurveyList) {
print_r("ERROR in query:");
print_r($stringSurveyList);
echo mysqli_error($GLOBALS['connect_db']);
}
while ($rowSurveyList = mysqli_fetch_assoc($sqlSurveyList)) {
$result[$rowSurveyList['id']] = $rowSurveyList;
}
return $result;
}
// Enostaven seznam anket za mobilno aplikacijo
public function getSurveysSimple($ank_id = 0, $limit = '', $mobile_created = -1, $include_folders=false) {
$result = array();
// ce imas hkrati dostop do ankete (srv_dostop) in preko managerskega dostopa (srv_dostop_manage) se brez DISTINCT podvajajo ankete
$stringSurveyList = "SELECT DISTINCT sa.id, sa.folder, '1' as del, sa.naslov, sa.active, sa.mobile_created, sa.block_ip, ";
//$stringSurveyList .= 'sal.lib_glb AS lib_glb, ';
//$stringSurveyList .= 'sal.lib_usr AS lib_usr, ';
$stringSurveyList .= "sa.edit_uid, sal.e_name AS e_name, sal.e_surname AS e_surname, sal.e_email AS e_email, ";
$stringSurveyList .= "sa.insert_uid, sal.i_name AS i_name, sal.i_surname AS i_surname, sal.i_email AS i_email, ";
$stringSurveyList .= "date_format(edit_time, '%d.%m.%y %k:%i') AS e_time, ";
$stringSurveyList .= "date_format(insert_time, '%d.%m.%y %k:%i') AS i_time, ";
$stringSurveyList .= "date_format(sal.a_first, '%d.%m.%y %k:%i') AS v_time_first, date_format(sal.a_last, '%d.%m.%y %k:%i') AS v_time_last, ";
$stringSurveyList .= "sal.answers as answers, "; // vedno prestejemo odgovore
$stringSurveyList .= "sal.approp as approp, "; // vedno prestejemo odgovore
$stringSurveyList .= "sal.variables as variables, ";
$stringSurveyList .= "date_format(sa.starts, '%d.%m.%y') as trajanjeod, ";
$stringSurveyList .= "date_format(sa.expire, '%d.%m.%y') as trajanjedo, ";
$stringSurveyList .= "sa.survey_type "; // tega pustim tukaj, da ni problemov z vejico
$stringSurveyList .= "FROM srv_anketa sa ";
$stringSurveyList .= "LEFT OUTER JOIN srv_survey_list AS sal ON sal.id = sa.id " ;
$stringSurveyList .= "LEFT OUTER JOIN srv_library_anketa AS sla ON sla.ank_id = sa.id " ;
# kdo lahko ureja anketo (briše)
// tega substringy se ne da dodatno razbit z prepareSubquery, ker selectamo 2 elementa...
$stringSurveyList .= "LEFT OUTER JOIN (SELECT 1 AS canEdit, ank_id FROM srv_dostop WHERE FIND_IN_SET('edit', dostop ) ='1' AND aktiven = '1' AND uid = '$this->g_uid' OR uid IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT user FROM srv_dostop_manage WHERE manager = '".$this->g_uid."'")).")) AS sd ON sd.ank_id = sa.id " ;
$stringSurveyList .= "WHERE sa.backup='0' AND sa.id>0 AND active >= '0' AND invisible = '0' ";
if($mobile_created == 1)
$stringSurveyList .= "AND sa.mobile_created='".$mobile_created."' ";
if(!$include_folders)
$stringSurveyList .= "AND NOT EXISTS (SELECT * FROM srv_mysurvey_anketa sma WHERE sma.ank_id=sa.id AND sma.usr_id='$this->g_uid') ";
// Ce imamo podan ank_id vrnemo samo za 1 anketo
if($ank_id > 0)
$stringSurveyList .= "AND sa.id='".$_GET['ank_id']."' ";
//$stringSurveyList .= $this->getLanguageLimit();
$stringSurveyList .= $this->getDostopAnketa();
//$stringSurveyList .= $this->getOrderString();
//$stringSurveyList .= $this->getLimitString();
//$stringSurveyList .= 'ORDER BY upper(naslov) ASC';
//zacasno zaradi aplikacije
if($mobile_created == 1)
$stringSurveyList .= "ORDER BY edit_time DESC";
else
$stringSurveyList .= 'ORDER BY sal.a_last DESC';
//@Uros dodal, da vrne samo doloceno stevilo zadnjih anktivnih anket, ce je nastavljeno
if($limit != '' && $limit != 0)
$stringSurveyList .= ' limit '.$limit;
$sqlSurveyList = sisplet_query($stringSurveyList);
while ($rowSurveyList = mysqli_fetch_assoc($sqlSurveyList)) {
// Pretvorimo vse v utf - drugace vcasih ne dela json_encode
foreach($rowSurveyList as $key => $val){
//$rowSurveyList[$key] = utf8_encode($val);
$rowSurveyList[$key] = mb_convert_encoding($val, 'HTML-ENTITIES', "UTF-8");
}
$result[] = $rowSurveyList;
}
return $result;
}
protected function createOrderUrlNew($id, $txt) {
global $site_url;
if (!isset($id) || $id == null || $id == "") {
$id=1;
}
if ($this->sortby != $id ) {
$result=''.$txt.'
';
}
else {
if ($this->sorttype == 2) {
$result=''.$txt.'
';
}
else {
$result=''.$txt.'
';
}
}
return $result;
}
private function echoText($text, $type = 'text', $id = null,$options=array()) {
global $lang;
global $site_url;
if ( $type == 'text') {
$result = ( isset($text) && $text != null && $text != "") ? $text : " ";
} elseif ($type == 'naslov') {
$result = ''.$text.'';
} elseif ($type == 'active') {
$result = '' .
' '.
'';
} elseif ($type == 'delete') {
if ((int)$options['anketa_canEdit'] > 0) {
$result = '' .
''.
'';
} else {
$result=' ';
}
} elseif ($type == 'lib_glb') {
if ($this->g_adminType == 0) {
// samo admin lahko dodaja in odstranjuje v sistemsko knjiznico
$result = ''.
''.
'';
} else {
$result = ''.
''.
'';
}
} elseif ($type == 'lib_usr') {
$result = ''.
''.
'';
} elseif ($type == 'survey_type') {
if ($text == '3') {
$text = '2';
}
$result = $lang['srv_vrsta_survey_type_'.$text];
} elseif ($type == 'euid' || $type == 'iuid') {
$text = iconv("iso-8859-2", "utf-8",$text);
if ($options['anketa_is_copy']) {
$result = $lang['srv_survey_is_copy'];
} else {
$result = ( isset($text) && $text != null && $text != "")
? ''.$text.'' :
" ";
// echoText($text, 'text', $id, $options );
}
} else {
$this->echoText($text, 'text', $id, $options );
}
echo (isset($result) && $result != "" && $result != null) ? $result : " ";
}
/**
* polovimo shranjene ?irine za polja
*/
private function getCssSetings() {
global $global_user_id;
$result_old_data = array();
if ($this->g_uid > 0) {
// najprej iz nastavitev preberemo obstoje?e shranjene ?irine
$saved_old_data_string = UserSetting::getInstance()->getUserSetting('survey_list_widths');
if (isset($saved_old_data_string) && $saved_old_data_string != null && $saved_old_data_string != "" ) {
$old_data = array_unique(explode(";",$saved_old_data_string));
foreach ( $old_data as $tmp_old_data ) {
$_tmp_old_data = array_unique(explode(",",$tmp_old_data));
$result_old_data[$_tmp_old_data[0]] = $_tmp_old_data[1];
}
}
}
return $result_old_data;
}
/** Izrišemo div z nastavitvami
*
* Enter description here ...
* @param unknown_type $display_default
*/
public function displaySettings($display_default = false) {
global $site_url, $lang;
# izpisemo dive
$settingsArray = $this->getSettings();
echo '';
echo '';
echo '';
$grupaName = "";
$zastopaneGrupe = array();
echo '';
echo '';
echo '';
$grupaName = "";
}
// preverimo ali naredimo novo grupo (Vnesel / urejal)
if (isset($opcija['header_grupa']) && $grupaName == "") { // smo v grupi polj pod in imamo podpolja: ime priimek, email, datum
// imamo začtek grupe
echo '';
echo ' ';
$grupaName = "";
}
echo '
';
echo '- ';
foreach ( $settingsArray as $opcija ) {
// preverimo ali je nova grupa
if ((!isset($opcija['header_grupa']) && $grupaName != "") || // nismo več v grupi stara še obstaja
( isset($opcija['header_grupa']) && $grupaName != "" && $opcija['header_grupa'] != $grupaName)) { // smo v grupi ampak ime ni enako prejšnjemu
echo '
';
echo '
';
echo '
';
echo '';
echo '';
echo '
';
echo '';
echo '- ';
$grupaName = $opcija['header_grupa'];
$zastopaneGrupe[] = $opcija['header_grupa'];
}
if (!isset($opcija['header_grupa'])) {
echo '
- ';
echo '';
// ?e je viden ali ?e je id = 1 (ime ankete) potem dodamo checkbox (imena ankete ne moremo izklju?it)
echo '';
echo $lang['srv_h_'.$opcija['header_field']];
echo '';
echo ' ';
} else {
echo '
- ';
echo '';
// ?e je viden ali ?e je id = 1 (ime ankete) potem dodamo checkbox (imena ankete ne moremo izklju?it)
echo '';
echo $lang['srv_'.$opcija['header_grupa']]. " - ";
echo $lang['srv_h_'.$opcija['header_field']];
echo '';
echo ' ';
}
}
// na koncu ?e preverimo ali imamo kon?ano grupo ?ene nardimo zaključna diva
if ($grupaName != "") {
echo '
';
echo '
'.$lang['srv_sl_error_msg'].'';
echo '
';
echo '';
echo ''.$lang['srv_sl_error_msg'].''.$lang['srv_sl_setting_show'].''.$lang['srv_sl_setting_records'];
echo '
';
echo '';
echo ' ';
echo ' ';
echo ' ';
echo '';
echo '
';
echo '
'.$lang['srv_default'].'
'.$lang['srv_cancel'].'
'.$lang['save'].'