'); //$GDPRintro = $this->encodeTextHere($GDPRintro); $GDPRintro = LatexDocument::encodeText($GDPRintro, 0, 0, 0, 'gdpr'); $tex .= ' \textbf{'.$GDPRintro.'} '; //radio buttona if($export_subtype=='q_empty'){ //ce je prazen vprasalnik $radioButtonTex = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio}"); $tex .= '\\\\'.$radioButtonTex.' '.$lang['srv_gdpr_intro_no']; $tex .= '\\\\'.$radioButtonTex.' '.$lang['srv_gdpr_intro_yes']; }else{ //pridobitev ID grupe $sqlGrupeStringGDPR = "SELECT id FROM srv_grupa WHERE ank_id='".$this->anketa."' ORDER BY vrstni_red"; $sqlGrupeGDPR = sisplet_query($sqlGrupeStringGDPR); $rowGrupeGDPR = mysqli_fetch_array( $sqlGrupeGDPR ); $grupa = $rowGrupeGDPR['id']; //pridobitev ID grupe - konec //pridobitev informacije obiska strani oz. ankete $sqlStringStran = "SELECT time_edit FROM srv_user_grupa".$this->db_table." WHERE usr_id='".$this->usr_id."' AND gru_id='".$grupa."'"; $sqlStran = sisplet_query($sqlStringStran); $rowStran = mysqli_fetch_array( $sqlStran ); $stran = $rowStran['time_edit']; //pridobitev informacije obiska strani oz. ankete - konec if($stran){ $radioButtonTexNo = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio}"); $radioButtonTexYes = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio2}"); }else{ $radioButtonTexNo = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio2}"); $radioButtonTexYes = ("\\includegraphics[scale=".RADIO_BTN_SIZE."]{".$this->path2Images."radio}"); } $tex .= '\\\\'.$radioButtonTexNo.' '.$lang['srv_gdpr_intro_no']; $tex .= '\\\\'.$radioButtonTexYes.' '.$lang['srv_gdpr_intro_yes']; } //radio buttona - konec $tex .= $this->texNewLine; $tex .= $this->texNewLine; } // ce obstaja intro izpisemo intro - pri izpisu vprasalnika brez odgovorov (ce smo na prvi strani moramo biti v razsirjenem nacinu) if( ($surveyExpanded != 0 || $this->type != 1) && $this->showIntro == 1 ){ if ( SurveyInfo::getInstance()->getSurveyShowIntro() ) { //preverjanje, ali je prevod if(isset($_GET['language'])){ //$this->language = $_GET['language']; $this->language = isset($_GET['language'])?$_GET['language']:null; $prevod = 1; }else{ $prevod = 0; } //preverjanje, ali je prevod - konec if($prevod){ //ce je prevod ankete $spr_id_uvod = -1; $sqll = sisplet_query("SELECT naslov, info FROM srv_language_spremenljivka WHERE ank_id='".$this->anketa."' AND spr_id='".$spr_id_uvod."' AND lang_id='".$this->language."'"); $rowl = mysqli_fetch_array($sqll); //pridobi prevod uvoda v ustreznem jeziku $intro = $rowl['naslov']; //prevod uvoda v ustreznem jeziku }else{ $sqlIntroString = "SELECT introduction FROM srv_anketa WHERE id=".$this->anketa." "; $sqlIntro = sisplet_query($sqlIntroString); $rowl = mysqli_fetch_array($sqlIntro); //pridobi besedilu uvoda $intro = $rowl['introduction']; //prevod uvoda v ustreznem jeziku } $tex .= LatexDocument::encodeText($intro, 0, 0, 0, 'intro'); if($intro){ $tex .= "\r\n"; $tex .= $this->texNewLine; $tex .= $this->texNewLine; } } } $sqlGrupeString = "SELECT id FROM srv_grupa WHERE ank_id='".$this->anketa."' ORDER BY vrstni_red"; $sqlGrupe = sisplet_query($sqlGrupeString); //echo "__________________________________
"; //echo "Funkcija displaySurvey user: $this->usr_id
"; if($this->export_format == 'rtf'){ $tex .= $this->texNewLine; } $question = new LatexSurveyElement($this->anketa, $this->export_format, 0, $this->usr_id, $export_subtype, $language); ######## while ( $rowGrupe = mysqli_fetch_assoc( $sqlGrupe ) ) { // sprehodmo se skozi grupe ankete $this->grupa = $rowGrupe['id']; // Pogledamo prvo spremenljivko v grupi ce je v loopu $sql = sisplet_query("SELECT id FROM srv_spremenljivka WHERE gru_id='".$this->grupa."' AND visible='1' ORDER BY vrstni_red ASC"); $row = mysqli_fetch_array($sql); // ce je ima loop za parenta $if_id = isset(($row['id']))?$this->find_parent_loop($row['id']):null; if ($if_id > 0 && ($export_subtype=='q_data'||$export_subtype=='q_data_all')){ //ce je loop in (je izpis odgovorov respondentov) $texLoop = ''; $sql1 = sisplet_query("SELECT if_id FROM srv_loop WHERE if_id = '$if_id'"); $row1 = mysqli_fetch_array($sql1); $this->loop_id = $this->findNextLoopId($row1['if_id']); //echo "Loop id: ".$this->loop_id."
"; //echo " id: ".$row['id']."
"; $if = Cache::srv_if($if_id); //echo "If label: ".$if['label']."
"; //echo "If : ".print_r($if)."
"; $loop_title = $if['label']; // gremo cez vse spremenljivke v trenutnem loopu while($this->loop_id != null){ //echo "Loop id: ".$this->loop_id."
"; // Izrisemo naslov loopa $tex .= $this->dataPiping($loop_title); $zaporedna = 0; //TODO: TUdi tu se celotna spremenljivka prenaša naprej $sqlSpremenljivke = sisplet_query("SELECT id, tip, visible, sistem, variable, naslov, info, orientation, dostop, grids, ranking_k, enota, grid_subtitle1, grid_subtitle2, text_kosov, text_orientation, signature, upload, size, design, vsota FROM srv_spremenljivka WHERE gru_id='".$this->grupa."' AND visible='1' ORDER BY vrstni_red ASC"); while ($rowSpremenljivke = mysqli_fetch_assoc($sqlSpremenljivke)) { // sprehodimo se skozi spremenljivke grupe $spremenljivka = $rowSpremenljivke['id']; if ($rowSpremenljivke['visible'] == 0 || !( ($this->admin_type <= $rowSpremenljivke['dostop'] && $this->admin_type>=0) || ($this->admin_type==-1 && $rowSpremenljivke['dostop']==4) ) ) { //echo "ni admin za sprem: ".$rowSpremenljivke['id']."
"; continue; } if($export_subtype=='q_data'||$export_subtype=='q_data_all'){ //ce je vprasalnik s podatki za enega ali vse respondente $preveriSpremenljivko = $this->checkSpremenljivkaData($spremenljivka, $this->loop_id); }else{ //ce je prazen vprasalnik ali vprasalnik s komentarji $preveriSpremenljivko = $this->checkSpremenljivka($spremenljivka); } //if ( $this->checkSpremenljivka ($spremenljivka) /*|| $this->showIf == 1*/ ) if ($preveriSpremenljivko) { // lahko izrišemo spremenljivke // po potrebi obarvamo vprašanja //$this->pdf->SetTextColor(0); if ($rowSpremenljivke['visible'] == 0) { if ($rowSpremenljivke['sistem'] == 1) { // če je oboje = vijolčno //$this->pdf->SetTextColor(128,0,128); } else { // Če je skrito = rdeče //$this->pdf->SetTextColor(255,0,0); } } else if ($rowSpremenljivke['sistem'] == 1) { //$this->pdf->SetTextColor(0,0,255); } // če imamo številčenje Type = 1 potem številčimo V1 if (SurveyInfo::getInstance()->getSurveyCountType()) $zaporedna++; $stevilcenje = ( SurveyInfo::getInstance()->getSurveyCountType() ) ? ( ( SurveyInfo::getInstance()->getSurveyCountType() == 2 ) ? $rowSpremenljivke['variable'].") " : $zaporedna.") " ) : null; // Izpis vprasalnika z rezultati // Ce imamo kombinirano tabelo pogledamo ce prikazujemo katero od podtabel if($rowSpremenljivke['tip'] == 24){ $subGrids = array(); $showGridMultiple = false; // Loop po podskupinah gridov $sqlSubGrid = sisplet_query("SELECT m.spr_id, s.tip, s.enota FROM srv_grid_multiple m, srv_spremenljivka s WHERE m.parent='".$spremenljivka."' AND m.spr_id=s.id"); while($rowSubGrid = mysqli_fetch_array($sqlSubGrid)){ if(in_array($rowSubGrid['spr_id'],$tmp_svp_pv) || count($tmp_svp_pv) == 0){ $showGridMultiple = true; break; } } } // ce je nastavljen profil s filtriranimi spremenljivkami if(in_array($spremenljivka,$tmp_svp_pv) || count($tmp_svp_pv) == 0 || ($rowSpremenljivke['tip'] == 24 && $showGridMultiple) || $rowSpremenljivke['tip'] == 5){ $this->currentHeight = 0; //izpisi tekst vprasanja $tex .= $question->displayQuestionText($rowSpremenljivke, $stevilcenje, $export_subtype, $preveriSpremenljivko, $this->loop_id, $export_data_type); //izpisi tekst vprasanja //izpisi odgovore $tex .= $question->displayAnswers($rowSpremenljivke, $export_subtype, $preveriSpremenljivko, $export_data_type, $this->loop_id); //izpisi odgovore } } } $this->loop_id = $this->findNextLoopId(); //ce je prazen vprasalnik, ustavi if($export_subtype=='q_empty'){ break; } } } // Navadne spremenljivke ki niso v loopu else{ //echo "Ni v loop-u
"; $loop_id = 'IS NULL'; $zaporedna = 0; //TODO: Omenjen query je potrebno optimizirati in da se naprej samo prenaša ID, ki se potem v podfunkcijah kliče ustrezen query // trenutno se potrebuje: id, tip, visible, sistem, variable, params $sqlSpremenljivke = sisplet_query("SELECT id, tip, visible, sistem, variable, params, dostop, naslov, orientation, info, grids, ranking_k, enota, grid_subtitle1, grid_subtitle2, text_kosov, text_orientation, signature, upload, size, design, vsota FROM srv_spremenljivka WHERE gru_id='".$this->grupa."' AND visible='1' ORDER BY vrstni_red ASC"); while ($rowSpremenljivke = mysqli_fetch_assoc($sqlSpremenljivke)){ // sprehodimo se skozi spremenljivke grupe $spremenljivka = $rowSpremenljivke['id']; if ($rowSpremenljivke['visible'] == 0 || !( ($this->admin_type <= $rowSpremenljivke['dostop'] && $this->admin_type>=0) || ($this->admin_type==-1 && $rowSpremenljivke['dostop']==4) ) ) { //echo "ni admin za sprem: ".$rowSpremenljivke['id']."
"; continue; } //echo "Ni v loop-u:".$rowSpremenljivke['tip']."
"; if($export_subtype=='q_data'||$export_subtype=='q_data_all'){ //ce je vprasalnik s podatki za enega ali vse respondente $preveriSpremenljivko = $this->checkSpremenljivkaData($spremenljivka, $loop_id); }else{ //ce je prazen vprasalnik ali vprasalnik s komentarji $preveriSpremenljivko = $this->checkSpremenljivka($spremenljivka); } if ($preveriSpremenljivko) { // lahko izrišemo spremenljivke // po potrebi obarvamo vprašanja //$this->pdf->SetTextColor(0); if ($rowSpremenljivke['visible'] == 0) { if ($rowSpremenljivke['sistem'] == 1) { // če je oboje = vijolčno //$this->pdf->SetTextColor(128,0,128); } else { // Če je skrito = rdeče //$this->pdf->SetTextColor(255,0,0); } } else if ($rowSpremenljivke['sistem'] == 1) //$this->pdf->SetTextColor(0,0,255); // če imamo številčenje Type = 1 potem številčimo V1 if (SurveyInfo::getInstance()->getSurveyCountType()) $zaporedna++; $stevilcenje = ( SurveyInfo::getInstance()->getSurveyCountType() ) ? ( ( SurveyInfo::getInstance()->getSurveyCountType() == 2 ) ? $rowSpremenljivke['variable'].") " : $zaporedna.") " ) : null; $this->currentHeight = 0; // izpis skrcenega vprasalnika (samo pri izpisu iz urejanja) if($surveyExpanded == 0 && $this->type == 1){ //$this->outputVprasanjeCollapsed($rowSpremenljivke, $stevilcenje); } // izpis navadnega vprasalnika else{ //echo "while stavek za".$rowSpremenljivke['id']."
"; $tex .= $question->displayQuestionText($rowSpremenljivke, $stevilcenje, $export_subtype, $preveriSpremenljivko, $this->loop_id, $export_data_type); //izpisi tekst vprasanja $tex .= $question->displayAnswers($rowSpremenljivke, $export_subtype, $preveriSpremenljivko, $export_data_type, $this->loop_id); //izpisi odgovore } //$this->pdf->Ln(LINE_BREAK); } } //echo "Končni tex brez loopa: ".$tex."
"; } //$tex .= $this->texBigSkip; if($this->export_format == 'rtf'){ $tex .= $this->texBigSkip; } //$tex .= $texLoop; //echo "Končni tex: ".$tex."
"; } //echo "Končni tex: ".$tex."
"; // če izpisujemo grupo, ne izpisujemo zakljucka if ( !$this->getGrupa() ){ if ( SurveyInfo::getInstance()->getSurveyShowConcl() && SurveyInfo::getInstance()->getSurveyConcl() ) { // ce obstaja footer izpisemo footer } } // Izpis grafa in tabele za NIJZ na koncu dokumenta global $site_domain; if( ($site_domain == 'test.1ka.si' && $this->anketa == '8892') || ($site_domain == 'anketa.nijz.si' && $this->anketa == '126738') ){ // Page break $tex .= '\cleardoublepage'; // Naslov "Ocena bivalnega okolja" $tex .= '\begin{center} \textbf{Ocena bivalnega okolja} \end{center}'; $nijz = new SurveyNIJZ($this->anketa, $this->usr_id); // Latex nijz slika grafa $tex .= $nijz->displayRadarLatex(); // Latex nijz tabela $tex .= $nijz->displayTableLatex(); } return $tex; } #funkcija, ki skrbi za izpis praznega vprasalnika in vprasalnika z odgovori enega respondenta - konec #funkcija, ki skrbi za izpis vseh odgovorov (vsi respondenti -> max 300) //po outputAllResults() iz class.pdfIzvozResults.php public function displayAllSurveys($export_subtype='', $export_format='', $export_data_type=''){ global $lang, $site_url; $tex = ''; $izbranStatusProfile = SurveyStatusProfiles :: getStatusAsQueryString(); $sqluString = "SELECT id, last_status, lurker, recnum FROM srv_user WHERE ank_id = '".$this->anketa."' ".$izbranStatusProfile." AND deleted='0' AND preview='0' ORDER BY recnum"; //echo $sqluString; $sqlu = sisplet_query($sqluString); $numOfUsers = mysqli_num_rows($sqlu); //stevilo respondentov if($numOfUsers > 300){ $tex .= $lang['srv_export_all_respondent_data_error'].' ('.$numOfUsers.').'; } else{ //za vsak user oz respondent while($rowu = mysqli_fetch_array($sqlu)){ //belezenje statusa switch($rowu['last_status']){ case '0': $status = $lang['srv_userstatus_0']; break; case '1': $status = $lang['srv_userstatus_1']; break; case '2': $status = $lang['srv_userstatus_2']; break; case '3': $status = $lang['srv_userstatus_3']; break; case '4': $status = $lang['srv_userstatus_4']; break; case '5': $status = $lang['srv_userstatus_5']; break; case '6': $status = $lang['srv_userstatus_6']; $status .= ($rowu['lurker'] == '1') ? ' - lurker' : ''; break; } #prenos odgovorov vsakega respondenta na novo stran, če je to potrebno //if($this->exportDataPageBreak == 1){ //ce mora vsak respondent imeti svoje odgovore na svoji strani if($this->exportDataPageBreak == 1 && $export_format == 'pdf'){ //ce mora vsak respondent imeti svoje odgovore na svoji strani in je pdf izvoz, saj za rtf pagebreak ne deluje $tex .= $this->texPageBreak; } #prenos odgovorov vsakega respondenta na novo stran, če je to potrebno - konec //$this->export_data_show_recnum = 1; #izpis statusa respondenta in anketiranja if($this->export_data_show_recnum == 1){ //ce je potrebno pokazati stevilko respondenta $tex .= '{\\Large Status '.$rowu['last_status'].' - '.$status.' (Recnum '.$rowu['recnum'].')} '.$this->texNewLine.' \\par '; }else{ $tex .= '{\\Large Status '.$rowu['last_status'].' - '.$status.$this->texNewLine.' \\par}'; } #izpis statusa respondenta in anketiranja - konec #izpis odgovorov posameznega userja $this->usr_id = $rowu['id']; #za pridobitev jezika respondenta if ($this->usr_id != '') { $sqlL = sisplet_query("SELECT language FROM srv_user WHERE id = '$this->usr_id ' "); $rowL = mysqli_fetch_array($sqlL); $language = $rowL['language']; } #za pridobitev jezika respondenta - konec $tex .= $this->displaySurvey($export_subtype, $export_data_type, $language); #izpis odgovorov posameznega userja - konec } } return $tex; } #funkcija, ki skrbi za izpis vseh odgovorov (vsi respondenti -> max 300) - konec #funkcija, ki skrbi za izpis praznega vprasalnika s komentarji //po outputCommentaries() iz class.pdfIzvoz.php public function displaySurveyCommentaries($export_subtype='', $export_data_type=''){ global $lang; global $site_url; global $admin_type; global $global_user_id; $texBigSkip = '\bigskip'; $tex = ''; $this->commentType = (isset($_GET['only_unresolved'])) ? $_GET['only_unresolved'] : 1; $f = new Forum; $c = 0; $b = new Branching($this->anketa); $rowi = SurveyInfo::getInstance()->getSurveyRow(); SurveySetting::getInstance()->Init($this->anketa); $question_resp_comment_viewadminonly = SurveySetting::getInstance()->getSurveyMiscSetting('question_resp_comment_viewadminonly'); $question_comment_viewadminonly = SurveySetting::getInstance()->getSurveyMiscSetting('question_comment_viewadminonly'); $question_comment_viewauthor = SurveySetting::getInstance()->getSurveyMiscSetting('question_comment_viewauthor'); $sortpostorder = SurveySetting::getInstance()->getSurveyMiscSetting('sortpostorder'); $question_note_view = SurveySetting::getInstance()->getSurveyMiscSetting('question_note_view'); $addfieldposition = SurveySetting::getInstance()->getSurveyMiscSetting('addfieldposition'); $commentmarks = SurveySetting::getInstance()->getSurveyMiscSetting('commentmarks'); $commentmarks_who = SurveySetting::getInstance()->getSurveyMiscSetting('commentmarks_who'); $sqlString = "SELECT s.* FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='".$this->anketa."' ORDER BY g.vrstni_red ASC, s.vrstni_red ASC"; $sql = sisplet_query($sqlString); $question = new LatexSurveyElement($this->anketa, $this->export_format, 0, 0, 0); if ( mysqli_num_rows($sql) > 0 && ( (int)$question_resp_comment_viewadminonly + (int)$question_comment_viewadminonly ) > 0 ) { $zaporedna = 0; while ($row = mysqli_fetch_array($sql)) { $sql1 = sisplet_query("SELECT thread, note FROM srv_spremenljivka WHERE id = '$row[id]'"); $row1 = mysqli_fetch_array($sql1); $orderby = $sortpostorder == 1 ? 'DESC' : 'ASC' ; $tid = $row1['thread']; $only_unresolved = " "; $only_unresolved2 = " "; if ($this->commentType == 1) $only_unresolved = " AND ocena <= 1 "; if ($this->commentType == 1) $only_unresolved2 = " AND text2 <= 1 "; if ($this->commentType == 2) $only_unresolved = " AND ocena = 0 "; if ($this->commentType == 2) $only_unresolved2 = " AND text2 = 0 "; if ($this->commentType == 3) $only_unresolved = " AND ocena = 1 "; if ($this->commentType == 3) $only_unresolved2 = " AND text2 = 1 "; if ($this->commentType == 4) $only_unresolved = " AND ocena = 2 "; if ($this->commentType == 4) $only_unresolved2 = " AND text2 = 2 "; if ($this->commentType == 5) $only_unresolved = " AND ocena = 3 "; if ($this->commentType == 5) $only_unresolved2 = " AND text2 = 3 "; // če imamo številčenje Type = 1 potem številčimo V1 if (SurveyInfo::getInstance()->getSurveyCountType()) $zaporedna++; $stevilcenje = ( SurveyInfo::getInstance()->getSurveyCountType() ) ? ( ( SurveyInfo::getInstance()->getSurveyCountType() == 2 ) ? $row['variable'].") " : $zaporedna.") " ) : null; $tema_vsebuje = substr($lang['srv_forum_intro'],0,10); // da ne prikazujemo 1. default sporocila if ($admin_type <= $question_comment_viewadminonly) { // vidi vse komentarje $sqlt = sisplet_query("SELECT uid, time, vsebina FROM post WHERE vsebina NOT LIKE '%{$tema_vsebuje}%' AND tid='$tid' $only_unresolved ORDER BY time $orderby, id $orderby"); } elseif ($question_comment_viewauthor==1) { // vidi samo svoje komentarje $sqlt = sisplet_query("SELECT uid, time, vsebina FROM post WHERE vsebina NOT LIKE '%{$tema_vsebuje}%' AND tid='$tid' $only_unresolved AND uid='$global_user_id' ORDER BY time $orderby, id $orderby"); } else { // ne vidi nobenih komentarjev $sqlt = sisplet_query("SELECT uid, time, vsebina FROM post WHERE 1=0"); } $sql2 = sisplet_query("SELECT COUNT(*) AS count FROM srv_data_text".$this->db_table." WHERE spr_id='0' AND vre_id='$row[id]' $only_unresolved2"); $row2 = mysqli_fetch_array($sql2); if ( mysqli_num_rows($sqlt) > 0 || $row2['count'] > 0 || $row1['note'] != '') { $c++; $preveriSpremenljivko = 0; //ni potrebno $tex .= $question->displayQuestionText($row, $stevilcenje, $export_subtype, $preveriSpremenljivko, null, $export_data_type); //izpisi tekst vprasanja $tex .= $question->displayAnswers($row, $export_subtype, $preveriSpremenljivko, $export_data_type, null); //izpisi odgovore if ($admin_type <= $question_note_view || $question_note_view == '') { if ($row1['note'] != '') { //$tex .= $texNewLine; $tex .= $this->texNewLine; $tex .= LatexDocument::encodeText($lang['hour_comment']); //$tex .= $texNewLine; $tex .= $this->texNewLine; $tex .= LatexDocument::encodeText($row1['note']); } } // komentarji na vprasanje if ($row1['thread'] > 0) { if (mysqli_num_rows($sqlt) > 0) { //$tex .= $texNewLine; $tex .= $this->texNewLine; $tex .= '\textcolor{komentar}{\textbf{'.LatexDocument::encodeText($lang['srv_admin_comment']).'}}'; //izpis naslova komentarjev $tex .= '\\\\'; $i = 0; while ($rowt = mysqli_fetch_array($sqlt)) { $tex .= '\textbf{'.LatexDocument::encodeText($f->user($rowt['uid'])).'}'; //izpis imena trenutnega urednika $tex .= LatexDocument::encodeText(' ('.$f->datetime1($rowt['time']).'):'); //izpis datuma komentarja $tex .= '\\\\'; // Popravimo vsebino ce imamo replike $vsebina = $rowt['vsebina']; $odgovori = explode("