';
$this->displaySearchSettings();
echo '
';
echo '';
}
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 '| '; echo ' | '; // Tip ankete (forma, navadna, glasovanje) //echo ''; // Aktivnost ankete echo ' | '; // Naslov echo ' | '; echo $this->createOrderUrlNew(1, $lang['title']); echo ' | '; // Trajanje - status echo ''; echo $this->createOrderUrlNew(18, 'Status'); echo ' | '; // Tip + st. vprasanj echo ''; echo ''; echo $this->createOrderUrlNew(19, $lang['srv_tip']); echo ' | '; // Zadnji vnos echo ''; echo $this->createOrderUrlNew(16, $lang['srv_last_insrt']); echo ' | '; // Sprememba echo ''; echo $this->createOrderUrlNew(14, $lang['change']); echo ' | '; // Ikona1 echo ''; // Ikona2 echo ' | '; echo ' |
| '; //var_dump($anketa); echo ''; echo ' | '; // Aktivnost - neaktivna, aktivna, zakljucena echo ''; if ($anketa['active'] == 1) { echo ''; } else { $sqlA = sisplet_query("SELECT sid FROM srv_activity WHERE sid='".$anketa['id']."'"); if (mysqli_num_rows($sqlA) > 0) { # anketa je zaključena echo ''; } else { # anketa je neaktivna echo ''; } } echo ' | '; // Naslov 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) {
foreach ($matches[0] as $match) {
$text_searched = str_replace($match, ''.$match.'', $text_searched);
}
}
}
}
echo '';
echo ''.$text_searched.'';
echo '';
$i_time = substr($anketa['i_time'], 0, 8);
$i_time = explode('.', $i_time);
echo ' '; if($anketa['mobile_created'] == '1') echo 'M'; // 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); } } } } echo $lang['srv_h_sl_avtor'].': '.$name_searched.' '.$surname_searched.', '.$i_time[0].'.'.$i_time[1].'.20'.$i_time[2].''; 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) echo $lang['srv_trajna_anketa']; else echo $lang['more'].' '.$trajanje.' '.$lang['hour_days']; } else{ echo $lang['srv_trajna_anketa']; } } else { $sqlA = sisplet_query("SELECT sid FROM srv_activity WHERE sid='".$anketa['id']."'"); if (mysqli_num_rows($sqlA) > 0) { # anketa je zaključena echo $lang['srv_survey_list_closed']; } else { # anketa je neaktivna echo $lang['srv_survey_list_inpreparation']; } } echo ' | '; // Tip + st. vprasanj echo '';
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 ' | ';
// Zadnji vnos
echo '';
if($anketa['answers'] > 0){
$v_time = substr($anketa['v_time_last'], 0, 8);
$v_time = explode('.', $v_time);
echo $v_time[0].'.'.$v_time[1].'.20'.$v_time[2].' '; } else{ echo '/ '; } echo ''.$lang['srv_info_answers'].': '.$anketa['answers'].''; echo ' | ';
// Sprememba
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 ''.$anketa['e_email'].''; echo ''; echo ' | ';
// Knjiznica - uporabnik
echo ''; echo ''; echo ''; echo ''; echo ' | '; // Knjiznica - global (samo admin) echo ''; if ($this->g_adminType == 0){ echo ''; echo ''; echo ''; } echo ' | '; echo '
';
$this->displayNewSurveyList($folder=0);
echo '
';
}
else{
echo '';
if($folder['open'] == 1)
echo '';
else
echo '';
// Naslov folderja
echo ' '.$folder['naslov'].'';
// Ikona za dodajanje folderja
echo ' ';
// Ikona za brisanje folderja
echo ' ';
// Ikona za kopiranje folderja - samo admini
if($admin_type == 0)
echo ' ';
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('');
echo('');
} else {
# brez href povezave
//echo('';
$this->displayNewFolder($row);
echo '
';
}
}
echo ''.$lang['previous_page_short'].'
');
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('');
}
} else {
$skipped = true;
}
}
# povezava na naslednjo stran
$next_page = $this->pageno + 1;
if($next_page <= $this->max_pages) {
//echo('');
echo('');
} else {
# brez href povezave
//echo(''.$lang['next_page_short'].'
');
echo('');
}
}
}
// Prikazemo gumb za sortiranje seznama anket
private function displaySortButton(){
global $lang, $site_url;
echo $lang['orderby'];
//echo '
';
echo '';
echo '
';
}
// Prikazemo gumb za filtriranje seznama anket
private 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"' : '').'>'.$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 $lang['srv_analiza_filter'];
//echo ' ';
echo '
';
}
// Prikazemo preklop med navadnim pogledom in pogledom s folderji
private function displayFolderSwitch(){
global $lang, $global_user_id;
// 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 '
';
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 '
gdpr == 2 ? 'checked="checked"' : '').' onclick="surveyList_gdpr'.$reload.'(\'2\');"> '; echo ' ';
echo '
';
echo $lang['srv_mySurvey_show_folders'];
echo '
';
}
else{
echo 'show_folders == 1 ? ' class="active"' : '').' onClick="switchFolder(\''.$this->show_folders.'\');">';
echo $lang['srv_mySurvey_show_folders'];
echo '
';
}
}
private function displaySettingsUrl() {
global $lang;
echo ' '.$lang['settings'].'';
echo '';
}
// Prikazemo nastavitve za napredno iskanje ce iscemo po anketah
private function displaySearchSettings(){
global $lang;
global $site_url;
// Posebej imamo skrito polje s parametri da jih ohranimo pri ajax klicih
echo '';
echo ''.$lang['s_search_settings_my'].'';
echo '';
// JS za koledar
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(",",$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 ";
}
$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;
}
private function createOrderUrl($id=null, $txt) {
if (!isset($id) || $id == null || $id == "") {
$id=1;
}
if ($this->sortby != $id ) {
$img_src = 'sort_unsorted';
$result=''.$txt.'
';
} else {
if ($this->sorttype == 2) {
$img_src = 'sort_ascending';
$result=''.$txt.'
';
} else {
$img_src = 'sort_descending';
$result=''.$txt.'
';
}
}
return $result;
}
private function createOrderUrlNew($id=null, $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 '';
echo '';
}
public function displayListQickInfo() {
# prikažemo hitri povzetek anket uporabnika
# preštejemo zadnje ankete v 12 urah
$ank1hour = "SELECT id FROM srv_anketa sa WHERE sa.backup='0' AND sa.id > 0 AND sa.active >= 0 AND invisible = '0' AND (sa.insert_time > (DATE_SUB(CURDATE(), INTERVAL 1 HOUR)) || sa.edit_time > (DATE_SUB(CURDATE(), INTERVAL 1 HOUR)) ) ".$this->getDostopAnketa();
$ank12hour = "SELECT id FROM srv_anketa sa WHERE sa.backup='0' AND sa.id > 0 AND sa.active >= 0 AND invisible = '0' AND (sa.insert_time > (DATE_SUB(CURDATE(), INTERVAL 12 HOUR)) || sa.edit_time > (DATE_SUB(CURDATE(), INTERVAL 12 HOUR)) ) ".$this->getDostopAnketa();
$ank24hour = "SELECT id FROM srv_anketa sa WHERE sa.backup='0' AND sa.id > 0 AND sa.active >= 0 AND invisible = '0' AND (sa.insert_time > (DATE_SUB(CURDATE(), INTERVAL 24 HOUR)) || sa.edit_time > (DATE_SUB(CURDATE(), INTERVAL 23 HOUR)) ) ".$this->getDostopAnketa();
$qry1hour = sisplet_query($ank1hour);
$qry12hour = sisplet_query($ank12hour);
$qry24hour = sisplet_query($ank24hour);
$cnt1hour = mysqli_num_rows($qry1hour);
$cnt12hour = mysqli_num_rows($qry12hour);
$cnt24hour = mysqli_num_rows($qry24hour);
}
// Vrne stevilo vseh anket
public function countSurveys() {
return count($this->surveys_ids);
}
// Vrne stevilo vseh anket v rootu (ce imamo folderje)
public function countRootSurveys() {
global $global_user_id;
// Poiscemo vse ankete v custom folderjih
$sql = sisplet_query("SELECT ank_id FROM srv_mysurvey_anketa WHERE usr_id='$global_user_id'");
// Vrnemo razliko v stevilu anket (odstejemo ankete v custom folderjih)
$survey_count = count($this->surveys_ids);
if(mysqli_num_rows($sql) > 0)
$survey_count -= mysqli_num_rows($sql);
return $survey_count;
}
/** Anketam ki so potekle popravimo aktivnost
*
*/
public function checkSurveyExpire() {
//v primeru maza moramo sporociti vsem aplikacijam deaktivacijo ankete
if(Common::checkModule('maza')){
$maza = new MAZA();
$maza -> maza_check_expired_surveys();
}
# Anketam ki so potekle popravimo aktivnost
sisplet_query("UPDATE srv_anketa SET active = '0' WHERE active = '1' AND expire < CURDATE()");
// vsilimo refresh podatkov
SurveyInfo :: getInstance()->resetSurveyData();
}
/** GETERS && SETTERS **/
/* GETERS */
private function getParentFolder() { return $this->parentFolder; }
private function getCurrentFolder() { return $this->currentFolder; }
public function getDef_Rows_per_page() { return SRV_LIST_REC_PER_PAGE; }
/** vrne sql pogoj za folderje na podlagi trenutnega folderja */
private function getFolderCondition () {
if ($this->folderCondition == null) {
$resultString = " AND 0";
#$this->folders = array();
$folderArray = $this->getFolderTreeAsArray($this->getCurrentFolder());
if ( count( $folderArray ) > 0) {
$prefix="";
$resultString = " AND sa.folder IN (";
foreach ($folderArray as $fid => $fname) {
$resultString .= $prefix.$fid;
$prefix=",";
}
$resultString .=") ";
}
$this->folderCondition = $resultString;
}
return $this->folderCondition;
}
/** vrne array z folderjem in subfolderji (če je SRV_LIST_GET_SUB_FOLDERS = true) */
function getFolderTreeAsArray($parent) {
# če ni dodan parent ga dodamo
if (!isset($this->folders[$parent])) {
$parentSql = sisplet_query('SELECT id, naslov FROM srv_folder WHERE id="'.$parent.'";');
if (mysqli_num_rows($parentSql)>0) {
$rowParent = mysqli_fetch_assoc($parentSql);
$this->folders[$rowParent['id']] = $rowParent['naslov'];
}
}
if (SRV_LIST_GET_SUB_FOLDERS || $parent == 0) {
$result = sisplet_query('SELECT id, naslov FROM srv_folder WHERE parent="'.$parent.'";');
while ($row = mysqli_fetch_array($result)) {
$this->folders[$row['id']] = $row['naslov'];
$this->getFolderTreeAsArray($row['id']);
}
}
return $this->folders;
}
/** vrne sql pogoj za ankete v moji knjiznici na podlagi trenutnega folderja */
private function getLibraryCondition () {
if ($this->currentLibrary == null) {
$resultString = '';
}
else{
$children = array();
$children = $this->getLibraryChildren($this->currentLibrary, $children);
$childrenString = '';
if(!empty($children))
$childrenString = ','.implode(',', $children);
//$resultString = " AND sla.ank_id=sa.id AND sla.folder='".$this->currentLibrary."'";
$resultString = " AND sla.ank_id=sa.id AND sla.folder IN (".$this->currentLibrary . $childrenString.")";
}
$this->libraryCondition = $resultString;
return $this->libraryCondition;
}
private function getLibraryChildren($folder_id, $children){
// Pridobimo vse childe
$sql = sisplet_query("SELECT id, parent FROM srv_library_folder WHERE parent='".$folder_id."'");
// Izstopni pogoj
if(mysqli_num_rows($sql) == 0)
return ($children);
while($row = mysqli_fetch_array($sql)){
$children[] = $row['id'];
$children2 = $this->getLibraryChildren($row['id'], $children);
$children = array_merge($children, $children2);
}
return array_unique($children);
}
/** vrne sql string za omejevanje dostopa uporabniku */
function getLanguageLimit() {
global $global_admin_type;
if ((int)$this->lang_id > 0) {
return " AND lang_admin ='".(int)$this->lang_id."'";
}
}
/** vrne sql string za omejevanje dostopa uporabniku */
function getDostopAnketa() {
global $global_admin_type;
global $global_user_id;
if ($this->dostopCondition == null) {
// posebej za managerje, ki vidijo ankete svojih uporabnikov
$manage = '';
#generalni dostop glede na tip uporabnikov --> $admin_type <= $row['dostop']
# posebej dostop za vsazga userja posebej --> sisplet_query("SELECT * FROM srv_dostop WHERE ank_id = '$anketa' AND uid='$uid'") -> if (mysqli_num_rows($sql) > 0)
if ($this->user_id == null) {
if ($this->g_adminType == 1 || $this->g_adminType == 0)
$manage = " OR uid IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT user FROM srv_dostop_manage WHERE manager = '".$this->g_uid."' ")).") ";
$this->dostopCondition = (SRV_LIST_CHECK_DOSTOP ? " AND (sa.id IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT ank_id FROM srv_dostop WHERE uid='".$this->g_uid."' $manage"))."))" : "");
}
else {
if ($this->g_adminType == 1 || $this->g_adminType == 0)
$manage = " OR uid IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT user FROM srv_dostop_manage WHERE manager = '".$this->g_uid."'")).") ";
$this->dostopCondition = (SRV_LIST_CHECK_DOSTOP ? " AND (insert_uid = '".$this->user_id."') AND (sa.id IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT ank_id FROM srv_dostop WHERE uid='".$this->g_uid."' $manage"))."))" : "");
}
# če ni admin odstranimo ankete kjer je uporabnik označen samo kot anketar
if ( true /*$this->g_adminType != '0'*/ ) {
$this->dostopCondition .= " AND sa.id".($this->onlyPhone == false ? " NOT":"")." IN"
." (SELECT ank_id FROM srv_dostop AS sd WHERE sd.aktiven = '1' AND sd.uid = '$this->g_uid' AND FIND_IN_SET('phone',sd.dostop )>0 AND FIND_IN_SET('edit',sd.dostop ) = 0) ";
}
else {
}
}
// meta admin vidi kao spet vse
if ( Dostop::isMetaAdmin() ) {
if ($this->user_id == null) {
$this->dostopCondition = (SRV_LIST_CHECK_DOSTOP ? " AND (sa.dostop >= '".$this->g_adminType."' OR sa.id IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT ank_id FROM srv_dostop WHERE uid='".$this->g_uid."' $manage"))."))" : "");
}
// filtriranje
else {
$manage = " OR uid IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT user FROM srv_dostop_manage WHERE manager = '".$this->g_uid."'")).") ";
$this->dostopCondition = (SRV_LIST_CHECK_DOSTOP ? " AND (insert_uid = '".$this->user_id."') AND (sa.id IN (".SurveyCopy::prepareSubquery(sisplet_query("SELECT ank_id FROM srv_dostop WHERE uid='".$this->g_uid."' $manage"))."))" : "");
}
// Včasih se za meta admina nekaj porusi in ne prikaze nobene ankete...
//$this->dostopCondition = '';
}
return $this->dostopCondition;
}
/** vrne order string za SQL s katerim sortiramo */
private function getOrderString() {
if (!isset($this->sortby) || (int)$this->sortby == 0) {
$this->sortby = SRV_LIST_ORDER_BY;
}
if (isset($this->order_by_options[$this->sortby])) {
$order_by = $this->order_by_options[$this->sortby];
} else {
$order_by = $this->order_by_options[SRV_LIST_ORDER_BY];
}
// UPPER damo, ker drugace sortira najprej vlke crke potem pa male
if($this->sortby == 1 || $this->sortby == 7 || $this->sortby == 11){
// Zamenjamo nacin sortiranja pri besedilu (drugace zacnemo od zadaj)
$sorttype = ($this->sorttype == 1) ? 2 : 1;
$result = " ORDER BY upper(" . $order_by . ") " . $this->sort_types_options[$sorttype];
}
// Dodamo opcije sortiranja pri statusu (18), ker ni dovolj sortiranje po "expired"
elseif($this->sortby == 18){
$sorttypeReverse = ($this->sorttype == 1) ? 2 : 1;
$result = " ORDER BY
sa.active ".$this->sort_types_options[$this->sorttype].",
(SELECT IF(COUNT(sac.sid) > 0, 1, 0) FROM srv_activity sac WHERE sac.sid=sa.id) ".$this->sort_types_options[$this->sorttype].",
".$order_by." ".$this->sort_types_options[$sorttypeReverse];
}
else
$result = " ORDER BY " . $order_by . " ".$this->sort_types_options[$this->sorttype];
return $result;
}
/** vrne Limit string za SQL s katerim prika?emo posamezno stran */
private function getLimitString() {
$result = " LIMIT " . ($this->pageno * $this->rec_per_page - $this->rec_per_page) . ", " . $this->rec_per_page;
return $result;
}
// vrne sql string za search po anketah glede na nastavitve searcha
private function getSearchString(){
$search_text = mysqli_real_escape_string($GLOBALS['connect_db'], $this->searchString);
$search_text = stripslashes(stripslashes($search_text));
// Vse gre v lowerstring
$search_text = strtolower($search_text);
// Ce gre za string v narekovajih
if($search_text[0] == '"' && $search_text[strlen($search_text) - 1] == '"'){
$search_text = trim($search_text, '"');
$this->searchStringProcessed[] = $search_text;
$search_text = '%'.$search_text.'%';
}
else{
// Sklanjamo po search besedi - ce gre za search po naslovu ali kljucnih besedah
if ($this->searchSettings['stype'] == '0' || $this->searchSettings['stype'] == '2') {
// odstrani vse zvezdice in pluse in skrajsaj besede za dva znaka, dodaj *.
$search_text = explode (" ", $search_text);
for ($a=0; $a'.$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'].'