0) {
$this->ank_id = $anketa;
// polovimo vrsto tabel (aktivne / neaktivne)
SurveyInfo :: getInstance()->SurveyInit($this->ank_id);
if (SurveyInfo::getInstance()->getSurveyColumn('db_table') == 1) {
$this->db_table = '_active';
}
// Inicializiramo in polovimo nastavitve missing profila
SurveyStatusProfiles::Init($this->ank_id);
SurveyUserSetting::getInstance()->Init($this->ank_id, $global_user_id);
SurveyStatusProfiles::Init($this->ank_id);
SurveyMissingProfiles :: Init($this->ank_id,$global_user_id);
SurveyConditionProfiles :: Init($this->ank_id, $global_user_id);
SurveyZankaProfiles :: Init($this->ank_id, $global_user_id);
SurveyTimeProfiles :: Init($this->ank_id, $global_user_id);
SurveyDataSettingProfiles :: Init($this->ank_id);
#inicializiramo class za datoteke
$SDF = SurveyDataFile::get_instance();
$SDF->init($anketa);
$this->headFileName = $SDF->getHeaderFileName();
$this->dataFileName = $SDF->getDataFileName();
$this->dataFileStatus = $SDF->getStatus();
SurveyAnalysis::Init($this->ank_id);
//polovimo podatke o nastavitvah trenutnega profila (missingi..)
SurveyAnalysis::$missingProfileData = SurveyMissingProfiles::getProfile(SurveyAnalysis::$currentMissingProfile);
#preberemo HEADERS iz datoteke
SurveyAnalysis::$_HEADERS = unserialize(file_get_contents($this->headFileName));
# odstranimo sistemske variable tipa email, ime, priimek, geslo
SurveyAnalysis::removeSystemVariables();
# polovimo frekvence
SurveyAnalysis::getFrequencys();
$this->creportProfile = SurveyUserSetting :: getInstance()->getSettings('default_creport_profile');
$this->creportProfile = isset($this->creportProfile) && $this->creportProfile != '' ? $this->creportProfile : 0;
$this->creportAuthor = SurveyUserSetting :: getInstance()->getSettings('default_creport_author');
$this->creportAuthor = isset($this->creportAuthor) && $this->creportAuthor != '' ? $this->creportAuthor : $global_user_id;
$this->expanded = (isset($_GET['expanded'])) ? $_GET['expanded'] : 0;
}
else {
echo 'Invalid Survey ID!';
exit();
}
}
// Izrisemo izdelano porocilo
function displayReport(){
global $lang;
global $global_user_id;
# zakeširamo vsebino, in jo nato po potrebi zapišpemo v html
if ($this->returnAsHtml != false) {
ob_start();
}
if ($this->isArchive == false && $this->publicCReport == false) {
echo '';
echo ''.$lang['srv_custom_report_list'].' ';
echo '
';
// Naslov
echo '';
// Profil
if($this->creportProfile == 0){
$what = 'creport_default_profile_name';
$sql = sisplet_query("SELECT value FROM srv_user_setting_for_survey WHERE sid='$this->ank_id' AND uid='$this->creportAuthor' AND what='$what'");
if(mysqli_num_rows($sql) == 0){
$name = $lang['srv_custom_report_default'];
}
else{
$row = mysqli_fetch_array($sql);
$name = $row['value'];
}
}
else{
$profile = $this->getProfile($this->creportProfile);
$name = $profile['name'];
}
echo '';
echo $lang['srv_custom_report_profile'].': "'.$name.'" ';
echo ' ';
echo ' ';
// Edit in add porocilo
echo '';
echo ' ';
echo $lang['srv_custom_report_base'].': ';
echo '';
echo ' '.$lang['srv_custom_report_base_0'].' ';
echo ' '.$lang['srv_sumarnik'].' ';
echo ' '.$lang['srv_frequency'].' ';
echo ' '.$lang['srv_descriptor'].' ';
echo ' '.$lang['srv_analiza_charts'].' ';
echo ' ';
echo ' ';
}
echo '
';
// Stevilo vseh porocil
$sqlC = sisplet_query("SELECT id FROM srv_custom_report_profiles WHERE ank_id='$this->ank_id' AND usr_id='$global_user_id'");
$report_count = mysqli_num_rows($sqlC);
if($report_count > 0)
echo ''.$lang['srv_custom_report_count'].': '.($report_count + 1).'
';
// Preklop na skrcen/razsirjen pogled in predogled
if ($this->isArchive == false && $this->publicCReport == false) {
echo '';
}
}
echo '';
// ce arhiviramo imamo razsirjene elemente
$this->expanded = ($this->isArchive == false && $this->publicCReport == false) ? $this->expanded : 1;
// Naslov porocila
if ($this->isArchive == false && $this->publicCReport == false) {
$this->displayTitle();
}
$sql = sisplet_query("SELECT * FROM srv_custom_report WHERE ank_id='$this->ank_id' AND usr_id='$this->creportAuthor' AND profile='$this->creportProfile' ORDER BY vrstni_red ASC");
$counter = mysqli_num_rows($sql);
if($counter > 0){
echo '
';
if ($this->isArchive == false && $this->publicCReport == false) {
echo '';
echo '
';
$this->addNewElement(-1);
echo '
';
echo '
';
// Pagebreak
if($row['type'] == '-1'){
if ($this->isArchive == false && $this->publicCReport == false){
$this->displayBreak($row);
}
}
else{
echo '';
$this->displayReportElement($row['id'], $this->expanded);
echo '
';
}
if ($this->isArchive == false && $this->publicCReport == false) {
echo '';
if($row['vrstni_red'] < $counter){
echo '
';
$this->addNewElement($row['id']);
echo '
';
}
echo '
';
}
echo ' ';
}
else
echo '
';
if ($this->isArchive == false && $this->publicCReport == false) {
// Dodajanje novega porocila
echo '
';
echo '
';
$this->addNewElement();
echo '
';
}
echo '
';
// Tip izpisa (sums, freq, opisne...)
echo '';
// Ce ni izbrana
if ( $reportElement['type'] == null || $reportElement['type'] == 0 ) {
echo ''. $lang['srv_custom_report_select_type'] . ' ';
}
echo ''.$lang['srv_sumarnik'].' ';
echo ''.$lang['srv_frequency'].' ';
echo ''.$lang['srv_descriptor_short'].' ';
echo ''.$lang['srv_chart'].' ';
echo ''.$lang['srv_crosstabs'].' ';
echo ''.$lang['srv_multicrosstab'].' ';
echo ''.$lang['srv_means_label'].' ';
echo ''.$lang['srv_ttest'].' ';
echo ''.$lang['srv_break'].' ';
echo ' ';
// Izbira spremenljivke za enojne elemente
if($reportElement['type'] > 0 && $reportElement['type'] < 5){
// Izbira spremneljivke
echo ' ';
// Ce ni izbrana
if ( $reportElement['spr1'] == null || $reportElement['spr1'] == '' ) {
echo ''. $lang['srv_select_spr'] . ' ';
}
# preberemo header
foreach (SurveyAnalysis::$_HEADERS AS $spid => $spremenljivka) {
# preverjamo ali je meta
if (($spremenljivka['tip'] != 'm'
&& in_array($spremenljivka['tip'], SurveyAnalysis::$_FILTRED_TYPES ))
/*&& in_array($spremenljivka['tip'],array(1,2,3,6,7,8,16,17,18,20) )*/) {
# preverimo ali prikazujemo spremenljivko, glede na veljavne odgovore
$only_valid = 0;
if (count($spremenljivka['grids']) > 0) {
foreach ($spremenljivka['grids'] AS $gid => $grid) {
# dodamo dodatne vrstice z albelami grida
if (count($grid['variables']) > 0 )
foreach ($grid['variables'] AS $vid => $variable ){
$_sequence = $variable['sequence']; # id kolone z podatki
$only_valid += (int)SurveyAnalysis::$_FREQUENCYS[$_sequence]['validCnt'];
}
}
}
// Ce ja kaksen veljaven oz ce prikazujemo tudi prazne
if(SurveyDataSettingProfiles :: getSetting('hideEmpty') != 1 || $only_valid > 0){
$text = (strlen($spremenljivka['naslov']) > 60) ? substr($spremenljivka['naslov'], 0, 57).'...' : $spremenljivka['naslov'];
$text = '('.$spremenljivka['variable'].') '.$text;
echo ''.$text.' ';
}
}
}
echo ' ';
}
// Nastavitve za CROSSTABE
elseif($reportElement['type'] == 5){
$variables = $this->classInstance->getVariableList();
// Nastavljeni variabli
$crossData1 = explode("-", $reportElement['spr1']);
$crossData2 = explode("-", $reportElement['spr2']);
// Izbira spremneljivke 1
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr1'] == null || $reportElement['spr1'] == 0 ) {
echo ''. $lang['srv_analiza_crosstab_izberi_prvo'] . ' ';
}
foreach ($variables as $variable) {
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
echo ' ';
// Izbira spremneljivke 2
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr2'] == null || $reportElement['spr2'] == 0 ) {
echo ''. $lang['srv_analiza_crosstab_izberi_drugo'] . ' ';
}
foreach ($variables as $variable) {
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-'.$variable['grd_id'];
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
echo ' ';
// Izbira podtipa (tabela / graf)
echo ' '.$lang['srv_multicrosstab_exist'].' ';
}
else{
// Izbira ze ustvarjene tabele
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr1'] == null || $reportElement['spr1'] == 0 ) {
echo ''. $lang['srv_multicrosstab_select'] . ' ';
}
foreach($mc_tables as $table){
echo ''.$table['name'].' ';
}
echo ' ';
}
}
// Nastavitve za MEANS
elseif($reportElement['type'] == 6){
$variables1 = $this->classInstance->getVariableList(1);
$variables2 = $this->classInstance->getVariableList(2);
// Nastavljeni variabli
$meanData1 = explode("-", $reportElement['spr1']);
$meanData2 = explode("-", $reportElement['spr2']);
// Izbira spremneljivke 1
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr1'] == null || $reportElement['spr1'] == 0 ) {
echo ''. $lang['srv_means_izberi_prvo'] . ' ';
}
foreach ($variables1 as $variable) {
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
echo ' ';
// Izbira spremneljivke 2
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr2'] == null || $reportElement['spr2'] == 0 ) {
echo ''. $lang['srv_means_izberi_drugo'] . ' ';
}
foreach ($variables2 as $variable) {
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
echo ' ';
// Izbira podtipa (tabela / graf)
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr1'] == null || $reportElement['spr1'] == 0 ) {
echo ''. $lang['srv_ttest_select1_option'] . ' ';
}
foreach ($variables as $variable) {
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
echo ' ';
// Izbira spremneljivke 2
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr2'] == null || $reportElement['spr2'] == 0 ) {
echo ''. $lang['srv_ttest_select2_option'] . ' ';
}
foreach ($numerus as $variable) {
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
echo ' ';
// Izbira podtipa (tabela / graf)
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr1'] == null || $reportElement['spr1'] == 0){
echo ''. $lang['srv_break_select1_option'] . ' ';
}
if (count($variables)) {
foreach ($variables as $variable) {
$value = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
echo ' ';
$text = ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' )) . $variable['variableNaslov'];
$text = (strlen($text) > 60) ? substr($text, 0, 57).'...' : $text;
echo $text;
echo ' ';
}
}
echo ' ';
// Izbira spremneljivke 2
$variables = $this->getBreakDependentVariableList();
echo ' ';
# ce prva variabla ni izbrana, dodamo tekst za izbiro prve variable
if ( $reportElement['spr2'] == null || $reportElement['spr2'] == 0 ) {
echo ''. $lang['srv_break_select2_option'] . ' ';
}
foreach ($variables as $variable) {
// Ce ni ista kot prva izbrana
if($variable['spr_id'] != $breakData1[1]){
$text = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
$value = $variable['sequence'].'-'.$variable['spr_id'].'-'.$variable['grd_id'];
echo ' '
. ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' ))
. $text . ' ';
}
}
echo ' ';
// Izbira podtipa (tabela / graf)
echo '
';
}
}
// Nastavitve na dnu
function displayBottomSettings(){
global $site_path;
global $lang;
echo '';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
$ttestData1 = explode("-", $reportElement['spr1']);
$spr = $ttestData1[1];
$check1 = $ttestData1[3];
$check2 = $ttestData1[4];
# poiscemo pripadajoce variable
$_spr_data = $this->classInstance->_HEADERS[$spr];
echo $lang['srv_ttest_kategories_note'].' ('.$_spr_data['variable'].') '.$_spr_data['naslov'];
echo '
';
}
function displayReportElementHead($reportElement, $expanded, $title=' '){
global $lang;
if ($this->isArchive == false && $this->publicCReport == false) {
echo '';
// Popravimo naslov ce je textovni element
if($reportElement['type'] == 8){
$title = substr(strip_tags($reportElement['text']), 0, 30);
if(strlen(strip_tags($reportElement['text'])) > 30)
$title .= '...';
$subtitle = '('.$lang['text'].')';
$title .= '
'.$subtitle.' ';
}
echo '
';
echo $title;
echo '
';
// Ikone za razsiritev, kopiranje, brisanje posameznega elementa
echo '
';
// Print element
echo '
';
echo '
';
$what = 'creport_title_profile_'.$this->creportProfile;
$sql = sisplet_query("SELECT value FROM srv_user_setting_for_survey WHERE sid='$this->ank_id' AND uid='$this->creportAuthor' AND what='$what'");
if(mysqli_num_rows($sql) == 0){
$titleString = $lang['export_analisys_creport'].': '.SurveyInfo::getInstance()->getSurveyTitle();
}
else{
$row = mysqli_fetch_array($sql);
$titleString = $row['value'];
}
echo '
';
echo $titleString;
echo '
';
echo '
'.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($expanded != 0)
SurveyAnalysis::displaySums($reportElement['spr1']);
echo '
';
}
// Izrisemo sumarnik element
function displayFreq($reportElement, $expanded){
global $lang;
// Naslov
$spr = SurveyAnalysis::$_HEADERS[$reportElement['spr1']];
if($reportElement['spr1'] == '')
$title = $lang['srv_select_spr'];
else
$title = $spr['variable'].' - '.$spr['naslov'];
$subtitle = '('.$lang['srv_frequency'].')';
$title .= ' '.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($expanded != 0)
SurveyAnalysis::displayFrequency($reportElement['spr1']);
echo '
';
}
// Izrisemo sumarnik element
function displayDesc($reportElement, $expanded){
global $lang;
// Naslov
$spr = SurveyAnalysis::$_HEADERS[$reportElement['spr1']];
if($reportElement['spr1'] == '')
$title = $lang['srv_select_spr'];
else
$title = $spr['variable'].' - '.$spr['naslov'];
$subtitle = '('.$lang['srv_descriptor'].')';
$title .= ' '.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($expanded != 0){
SurveyAnalysis::displayDescriptives($reportElement['spr1']);
// Na novo napolnimo headers ker se resetira??
SurveyAnalysis::$_HEADERS = unserialize(file_get_contents($this->headFileName));
}
echo '
';
}
// Izrisemo sumarnik element
function displayChart($reportElement, $expanded){
global $lang;
// Naslov
$spr = SurveyAnalysis::$_HEADERS[$reportElement['spr1']];
if($reportElement['spr1'] == '')
$title = $lang['srv_select_spr'];
else
$title = $spr['variable'].' - '.$spr['naslov'];
$subtitle = '('.$lang['srv_chart'].')';
$title .= ' '.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($expanded != 0){
SurveyChart::Init($this->ank_id);
if ($this->returnAsHtml != false) {
SurveyChart::setUpReturnAsHtml(true);
SurveyChart::setUpIsForArchive(true);
}
SurveyChart::displaySingle($reportElement['spr1']);
}
echo '
';
echo '';
}
//izrisemo crosstab element
function displayCrosstab($reportElement, $expanded){
global $lang;
// Ustvarimo instanco razreda
$this->classInstance = new SurveyCrosstabs();
$this->classInstance->Init($this->ank_id);
// Napolnimo podatke crosstabu
$crossData1 = explode("-", $reportElement['spr1']);
$crossData2 = explode("-", $reportElement['spr2']);
$this->classInstance->setVariables($crossData1[0],$crossData1[1],$crossData1[2],$crossData2[0],$crossData2[1],$crossData2[2]);
// Naslov
if($reportElement['spr1'] == '' || $reportElement['spr2'] == '')
$title = $lang['srv_select_spr'];
else{
$show_variables_values = true;
$spr1 = $this->classInstance->_HEADERS[$crossData1[1]];
$spr2 = $this->classInstance->_HEADERS[$crossData2[1]];
# za multicheckboxe popravimo naslov, na podtip
$sub_q1 = null;
$sub_q2 = null;
if ($spr1['tip'] == '6' || $spr1['tip'] == '7' || $spr1['tip'] == '16' || $spr1['tip'] == '17' || $spr1['tip'] == '18' || $spr1['tip'] == '19' || $spr1['tip'] == '20' || $spr1['tip'] == '21' ) {
foreach ($spr1['grids'] AS $grid) {
foreach ($grid['variables'] AS $variable) {
if ($variable['sequence'] == $v_first['seq']) {
$sub_q1 .= strip_tags($spr1['naslov']);
if ($show_variables_values == true ) {
$sub_q1 .= ' ('.strip_tags($spr1['variable']).')';
}
if ($spr1['tip'] == '16') {
$sub_q1 .= ''.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($reportElement['spr1'] != '' && $reportElement['spr2'] != '' && $expanded != 0){
// Izrisemo tabelo
if($reportElement['sub_type'] == 0){
$this->classInstance->showChart = false;
$this->classInstance->displayCrosstabsTable();
}
// Izrisemo graf
else{
$tableChart = new SurveyTableChart($this->ank_id, $this->classInstance, 'crosstab');
$tableChart->display();
}
}
echo '
';
}
// Izrisemo multicrosstab tabelo
function displayMulticrosstab($reportElement, $expanded){
global $lang;
global $global_user_id;
// Ustvarimo instanco razreda
$this->classInstance = new SurveyMultiCrosstabs($this->ank_id);
// Naslov
if($reportElement['spr1'] == '')
$title = $lang['srv_select_spr'];
else{
// Trenutna aktivna tabela
$sql = sisplet_query("SELECT * FROM srv_mc_table WHERE id='$reportElement[spr1]' AND ank_id='$this->ank_id' AND usr_id='$this->creportAuthor'");
$current_table = mysqli_fetch_array($sql);
$title = $current_table['name'];
}
$subtitle = '('.$lang['srv_multicrosstabs'].')';
$title .= ' '.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($expanded != 0 && $current_table != null){
$this->classInstance->table_id = $current_table['id'];
$this->classInstance->table_settings[$current_table['id']] = array(
'title' => $current_table['title'],
'numerus' => $current_table['numerus'],
'percent' => $current_table['percent'],
'sums' => $current_table['sums'],
'navVsEno' => $current_table['navVsEno'],
'avgVar' => $current_table['avgVar'],
'delezVar' => $current_table['delezVar'],
'delez' => $current_table['delez']
);
$this->classInstance->getVariableList();
// Izris tabele
echo '
';
$this->classInstance->displayTable();
echo '
';
}
echo '
'.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($reportElement['spr1'] != '' && $reportElement['spr2'] != '' && $expanded != 0){
// Izrisemo tabelo
if($reportElement['sub_type'] == 0){
$this->classInstance->displayMeansTable($means);
}
// Izrisemo graf
else{
$tableChart = new SurveyTableChart($this->ank_id, $this->classInstance, 'mean');
$tableChart->display();
}
}
echo '
';
}
//izrisemo ttest element
function displayTTest($reportElement, $expanded){
global $lang;
// Ustvarimo instanco razreda
$this->classInstance = new SurveyTTest($this->ank_id);
// Naslov
if($reportElement['spr1'] == '' || $reportElement['spr2'] == ''){
$title = $lang['srv_select_spr'];
}
else{
$label2 = strip_tags($this->getTTestLabel($reportElement['spr2']));
$label1 = strip_tags($this->getTTestLabel($reportElement['spr1']));
$title = $label1 . ' / ' . $label2;
}
$subtitle = '('.$lang['srv_ttest']. ($reportElement['sub_type'] == 1 ? ' - '.$lang['srv_chart'] : '') .')';
$title .= ' '.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($expanded != 0){
// Nastavimo session da lahko pravilno izrisemo tabelo/graf
$ttestData1 = explode("-", $reportElement['spr1']);
$ttestData2 = explode("-", $reportElement['spr2']);
if(count($ttestData1) == 5 && count($ttestData2) == 3){
$dataArray = array();
$dataArray['spr2'] = $ttestData1[1];
$dataArray['grid2'] = $ttestData1[2];
$dataArray['seq2'] = $ttestData1[0];
$dataArray['label2'] = $label1;
$dataArray['sub_conditions'][0] = $ttestData1[3];
$dataArray['sub_conditions'][1] = $ttestData1[4];
$dataArray['variabla'][0]['seq'] = $ttestData2[0];
$dataArray['variabla'][0]['spr'] = $ttestData2[1];
$dataArray['variabla'][0]['grd'] = $ttestData2[2];
// Shranimo spremenjene nastavitve v bazo
SurveyUserSession::Init($this->ank_id);
$sessionData = SurveyUserSession::getData('ttest');
$sessionData = $dataArray;
SurveyUserSession::saveData($sessionData, 'ttest');
// Ustvarimo instanco razreda
$this->classInstance = new SurveyTTest($this->ank_id);
// Izrisemo tabelo
if($reportElement['sub_type'] == 0){
$variables1 = $this->classInstance->getSelectedVariables();
foreach ($variables1 AS $v_first) {
$ttest = $this->classInstance->createTTest($v_first, $sessionData['sub_conditions']);
$this->classInstance->displayTtestTable($ttest);
}
}
// Izrisemo graf
else{
$tableChart = new SurveyTableChart($this->ank_id, $this->classInstance, 'ttest');
$tableChart->display();
}
}
}
echo '
';
}
function getTTestLabel($spr){
$data = explode("-", $spr);
$spid = $data[1];
$seq = $data[0];
$grid = $data[2];
$spr_data = $this->classInstance->_HEADERS[$spid];
if ($grid == 'undefined') {
# imamp lahko ve� variabel
foreach ($spr_data['grids'] as $gkey => $grid ) {
foreach ($grid['variables'] as $vkey => $variable) {
$sequence = $variable['sequence'];
if ($sequence == $seq) {
$sprLabel = '('.$variable['variable'].') '. $variable['naslov'];
}
}
}
} else {
# imamo subgrid
$sprLabel = '('.$spr_data['grids'][$grid]['variable'].') '. $spr_data['grids'][$grid]['naslov'];
}
return $sprLabel;
}
function displayRazbitje($reportElement, $expanded){
global $lang;
// Ustvarimo instanco razreda
$this->classInstance = new SurveyBreak($this->ank_id);
// Naslov
if($reportElement['spr1'] == '' || $reportElement['spr2'] == ''){
$title = $lang['srv_select_spr'];
}
else{
$breakData1 = explode("-", $reportElement['spr1']);
$breakData2 = explode("-", $reportElement['spr2']);
$label1 = '';
$variables = $this->classInstance->getVariableList(2);
foreach ($variables as $variable) {
if($breakData1[0] == $variable['sequence']){
$label1 = ( (int)$variable['sub'] == 0 ? '' : ( (int)$variable['sub'] == 1 ? ' ' : ' ' )) . $variable['variableNaslov'];
$label1 = (strlen($label1) > 60) ? substr($label1, 0, 57).'...' : $label1;
break;
}
}
$label2 = '';
$variables = $this->getBreakDependentVariableList();
foreach ($variables as $variable) {
if($breakData2[0] == $variable['sequence']){
//$label2 = $variable['variableNaslov'];
$label2 = (strlen($variable['variableNaslov']) > 60) ? substr($variable['variableNaslov'], 0, 57).'...' : $variable['variableNaslov'];
break;
}
}
$title = $label1 . ' / ' . $label2;
}
$subtitle = '('.$lang['srv_break']. ($reportElement['sub_type'] == 1 ? ' - '.$lang['srv_chart'] : '') .')';
$title .= ' '.$subtitle.' ';
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded, $title);
// Nastavitve elementa
$this->displayReportElementSettings($reportElement, $expanded);
// Izpis tabele ali grafa za posamezen vnos
echo '';
if($reportElement['spr1'] != '' && $reportElement['spr2'] != '' && $expanded != 0){
# ali prikazujemo procente
$this->classInstance->break_percent = true; /*isset($_SESSION['break_percent']) && (int)$_SESSION['break_percent'] == 0 ? false : true;*/
$spr = $breakData1[1];
# poiščemo pripadajoče variable
$_spr_data = $this->classInstance->_HEADERS[$breakData1[1]];
# poiščemo sekvenco
$sekvenca = $breakData1[0];
# poiščemo opcije
$opcije = $_spr_data['options'];
if ((int)$_spr_data['tip'] != 2) {
$seqences[] = $sekvenca;
$options = $opcije;
} else {
# za checkboxe imamo več sekvenc
$seqences = explode('_',$_spr_data['sequences']);
$options[1] = $opcije[1];
}
# za vsako opcijo posebej izračunamo povprečja za vse spremenljivke
$frequencys = array();
if (count($seqences) > 0) {
foreach ($seqences as $seq) {
if (count($options) > 0) {
foreach ($options as $oKey => $option) {
# zloopamo skozi variable
$oKeyfrequencys = $this->classInstance->getAllFrequencys($oKey, $seq, $spr);
if ($oKeyfrequencys != null) {
$frequencys[$seq][$oKey] = $oKeyfrequencys;
}
}
}
}
}
// Nastavimo odvisno spremenljivko
$spr2 = $this->classInstance->_HEADERS[$breakData2[1]];
$spr2['id'] = $breakData2[1];
// Nastavimo se katero podtabelo izrisemo (sekvenca odvisne spr)
$spr2['break_sub_table']['sequence'] = $breakData2[0];
foreach ($spr2['grids'] AS $gkey => $grid) {
if($spr2['break_sub_table']['sequence'] == $grid['variables'][0]['sequence']){
$spr2['break_sub_table']['key'] = $gkey;
break;
}
}
// Nastavimo se prvo spremenljivko in sekvenco (potrebno pri crosstabih ker se drugace to vlece iz SESSIONA)
$spr2['creport_first_spr']['seq'] = $breakData1[0];
$spr2['creport_first_spr']['spr'] = $breakData1[1];
// Izrisemo tabelo
if($reportElement['sub_type'] == 0){
$this->classInstance->break_charts = 0;
$this->classInstance->displayBreakSpremenljivka($spr,$frequencys,$spr2);
}
// Izrisemo graf
else{
$this->classInstance->break_charts = 1;
$this->classInstance->displayBreakSpremenljivka($spr,$frequencys,$spr2);
}
}
echo '
';
}
/** funkcija vrne seznam primern variabel za crostabe
*
*/
function getBreakDependentVariableList() {
$variablesList = array();
# zloopamo skozi header in dodamo variable (potrebujemo posamezne sekvence)
foreach ($this->classInstance->_HEADERS AS $skey => $spremenljivka) {
$tip = $spremenljivka['tip'];
$_dropdown_condition = (is_numeric($tip) && $tip != 5 && $tip != 8 && $tip != 9) ? true : false;
if ($_dropdown_condition) {
$cnt_all = (int)$spremenljivka['cnt_all'];
if ( $cnt_all == '1' || in_array($tip, array(1,2,3,4,7,17,18,21,22,25)) || ($tip == 6 && $spremenljivka['enota'] == 2) ) {
# pri tipu radio ali select dodamo tisto variablo ki ni polje "drugo"
if ($tip == 1 || $tip == 3 ) {
if (count($spremenljivka['grids']) == 1 ) {
# če imamo samo en grid ( lahko je več variabel zaradi polja drugo.
$grid = $spremenljivka['grids'][0];
if (count ($grid['variables']) > 0) {
foreach ($grid['variables'] AS $vid => $variable ){
if ($variable['other'] != 1) {
# imampo samo eno sekvenco grids[0]variables[0]
$variablesList[] = array(
'tip'=>$tip,
'spr_id'=>$skey,
'sequence'=>$spremenljivka['grids'][0]['variables'][$vid]['sequence'],
'variableNaslov'=>'('.$spremenljivka['variable'].') '.strip_tags($spremenljivka['naslov']),
'canChoose'=>true,
'sub'=>0);
}
}
}
}
}
else {
# imampo samo eno sekvenco grids[0]variables[0]
$variablesList[] = array(
'tip'=>$tip,
'spr_id'=>$skey,
'sequence'=>$spremenljivka['grids'][0]['variables'][0]['sequence'],
'variableNaslov'=>'('.$spremenljivka['variable'].') '.strip_tags($spremenljivka['naslov']),
'canChoose'=>true,
'sub'=>0);
}
}
else if ($cnt_all > 1){
# imamo več skupin ali podskupin, zato zlopamo skozi gride in variable
if (count($spremenljivka['grids']) > 0 ) {
$variablesList[] = array(
'tip'=>$tip,
'variableNaslov'=>'('.$spremenljivka['variable'].') '.strip_tags($spremenljivka['naslov']),
'canChoose'=>false,
'sub'=>0);
# ali imamo en grid, ali več (tabele
if (count($spremenljivka['grids']) == 1 ) {
# če imamo samo en grid ( lahko je več variabel zaradi polja drugo.
$grid = $spremenljivka['grids'][0];
if (count ($grid['variables']) > 0) {
foreach ($grid['variables'] AS $vid => $variable ){
if ($variable['other'] != 1) {
$variablesList[] = array(
'tip'=>$tip,
'spr_id'=>$skey,
'sequence'=>$variable['sequence'],
'variableNaslov'=>'('.$variable['variable'].') '.strip_tags($variable['naslov']),
'canChoose'=>true,
'sub'=>1);
}
}
}
} elseif($tip == 6) {
# imamo več gridov - tabele
foreach($spremenljivka['grids'] AS $gid => $grid) {
$sub = 0;
if ($grid['variable'] != '') {
$sub++;
$variablesList[] = array(
'tip'=>$tip,
'variableNaslov'=>'('.$grid['variable'].') '.strip_tags($grid['naslov']),
'canChoose'=>false,
'sub'=>$sub);
}
if (count ($grid['variables']) > 0) {
$sub++;
foreach ($grid['variables'] AS $vid => $variable ){
if ($variable['other'] != 1) {
$variablesList[] = array(
'tip'=>$tip,
'spr_id'=>$skey,
'sequence'=>$variable['sequence'],
'variableNaslov'=>'('.$variable['variable'].') '.strip_tags($variable['naslov']),
'canChoose'=>true,
'sub'=>$sub);
}
}
}
}
} else {
foreach($spremenljivka['grids'] AS $gid => $grid) {
$sub = 0;
if ($grid['variable'] != '') {
$sub++;
$variablesList[] = array(
'tip'=>$tip,
'spr_id'=>$skey,
'grd_id'=>$gid,
'sequence'=>$grid['variables'][0]['sequence'],
'variableNaslov'=>'('.$grid['variable'].') '.strip_tags($grid['naslov']),
'canChoose'=>true,
'sub'=>1);
}
}
}
}
}
}
}
return $variablesList;
}
// Izrisemo page break med elementi
function displayBreak($reportElement){
global $lang;
echo '';
echo ' ';
}
// Izrisemo element z besedilom
function displayText($reportElement, $expanded){
global $lang;
// Glava elementa (naslov, ikone...)
$this->displayReportElementHead($reportElement, $expanded);
echo '';
/*if($expanded == 1){
echo '
';
echo '
';
}*/
//else{
if ($this->isArchive == false && $this->publicCReport == false) {
echo '
';
}
echo '
isArchive == false && $this->publicCReport == false ? ' contenteditable="true"':'').' el_id="'.$reportElement['id'].'">';
echo $reportElement['text'];
echo '
';
//}
echo '
'.$lang['srv_custom_report_profile_title'].' ';
echo '';
// Prednastavljen profil
echo '
';
echo ''.$default_name.'
';
// Loop po lastnih porocilih
$sql = sisplet_query("SELECT * FROM srv_custom_report_profiles WHERE ank_id='$this->ank_id' AND usr_id='$global_user_id'");
while($row = mysqli_fetch_array($sql)){
echo ''.$row['name'].'
';
// Preberemo cas kreiranja porocila
if($this->creportProfile == $row['id'])
$time_created = $row['time_created'];
}
// Loop po deljenih porocilih drugih urednikov ankete
$sqlA = sisplet_query("SELECT s.*, u.email FROM srv_custom_report_share s, users u WHERE ank_id='$this->ank_id' AND share_usr_id='$global_user_id' AND u.id=s.author_usr_id");
while($rowA = mysqli_fetch_array($sqlA)){
// Ce gre za osnovno porocilo ki ga ne more pobrisati
if($rowA['profile_id'] == 0){
// Dobimo ime osnovnega porocila
$what = 'creport_default_profile_name';
$sqlN = sisplet_query("SELECT value FROM srv_user_setting_for_survey WHERE sid='$this->ank_id' AND uid='".$rowA['author_usr_id']."' AND what='$what'");
if(mysqli_num_rows($sqlN) == '0'){
$default_name = $lang['srv_custom_report_default'];
}
else{
$rowN = mysqli_fetch_array($sqlN);
$default_name = ($rowN['value'] == '') ? $lang['srv_custom_report_default'] : $rowN['value'];
}
echo '';
echo $default_name . ' ('.$rowA['email'].')';
echo '
';
}
// Ce gre za dodatno porocilo ga imamo normalno v bazi
else{
$sql = sisplet_query("SELECT * FROM srv_custom_report_profiles WHERE ank_id='$this->ank_id' AND usr_id='".$rowA['author_usr_id']."'");
while($row = mysqli_fetch_array($sql)){
echo '';
echo $row['name'] . ' ('.$rowA['email'].')';
echo '
';
// Preberemo cas kreiranja porocila
if($this->creportProfile == $row['id'])
$time_created = $row['time_created'];
}
}
}
echo ' ';
// Ce je izbran custom profil imamo na dnu gumba brisi in preimenuj, pri default pa samo preimenuj
// Preimenuje, brise in share lahko samo za lastna porocila
if($this->creportAuthor == $global_user_id){
echo '
';
}
// Preberemo najkasneje editiran element (cas spreminjanja)
$sqlt = sisplet_query("SELECT MAX(time_edit) FROM srv_custom_report WHERE ank_id='$this->ank_id' AND usr_id='$this->creportAuthor' AND profile='$this->creportProfile'");
if(mysqli_num_rows($sqlt) > 0){
$rowt = mysqli_fetch_array($sqlt);
$time_edit = $rowt['MAX(time_edit)'];
}
else
$time_edit = $time_created;
// Cas kreirranja in urejanja profila
echo '
';
if($time_created != '' && $time_created != '0000-00-00 00:00:00'){
$time_created = strtotime($time_created);
echo $lang['srv_custom_report_time_created'].': '.date("d.m.Y H:i", $time_created).' '.date("d.m.Y H:i", $time_edit).' ';
}
echo '
';
echo '
'."\n";
echo '';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
'."\n";
}
public function getProfile($profile_id){
global $global_user_id;
$sql = sisplet_query("SELECT * FROM srv_custom_report_profiles WHERE ank_id='$this->ank_id' AND usr_id='$this->creportAuthor' AND id='$profile_id'");
$profile = mysqli_fetch_array($sql);
return $profile;
}
public function getTitle(){
global $global_user_id;
global $lang;
$what = 'creport_title_profile_'.$this->creportProfile;
$sql = sisplet_query("SELECT value FROM srv_user_setting_for_survey WHERE sid='$this->ank_id' AND uid='$this->creportAuthor' AND what='$what'");
if(mysqli_num_rows($sql) == 0){
$titleString = $lang['export_analisys_creport'].': '.SurveyInfo::getInstance()->getSurveyTitle();
}
else{
$row = mysqli_fetch_array($sql);
$titleString = $row['value'];
}
return $titleString;
}
public function displayPublicCReport($properties) {
global $lang;
global $site_url;
header('Cache-Control: no-cache');
header('Pragma: no-cache');
$anketa = $this->ank_id;
$this->creportProfile = $properties['creportProfile'];
$this->creportAuthor = $properties['creportAuthor'];
if ($anketa > 0) {
$sql = sisplet_query("SELECT lang_admin FROM srv_anketa WHERE id = '$anketa'");
$row = mysqli_fetch_assoc($sql);
$lang_admin = $row['lang_admin'];
} else {
$sql = sisplet_query("SELECT value FROM misc WHERE what = 'SurveyLang_admin'");
$row = mysqli_fetch_assoc($sql);
$lang_admin = $row['value'];
}
#izpišemo HTML
echo '';
echo '';
echo '';
echo ''.$lang['srv_publc_creport_title_for'] .$titleString.' ';
echo ''.$titleString.' ';
echo '';
# ponastavimo nastavitve- filter
self::displayReport();
echo '
';
echo '';
echo '
';
echo '
';
echo '
'.$lang['srv_custom_report_link'].' '.$lang['export_analisys_creport'].': '.SurveyInfo::getInstance()->getSurveyTitle().' ';
$this->setUpReturnAsHtml(false);
$this->setUpIsForArchive(true);
$this->expanded = 1;
$this->displayReport();
echo '';
echo '
';
//echo '
';
echo '
';
echo '
'.$lang['srv_custom_report_comments_alert'.$type].'
';
echo '';
}
// Dodajanje vseh elementov istega tipa v report
if($_GET['a'] == 'all_elements_add'){
$type = (isset($_POST['type'])) ? $_POST['type'] : 0;
$sql = sisplet_query("SELECT MAX(vrstni_red) FROM srv_custom_report WHERE ank_id='$this->ank_id' AND usr_id='$this->creportAuthor' AND profile='$this->creportProfile'");
if(mysqli_num_rows($sql) > 0){
$row = mysqli_fetch_assoc($sql);
$vrstni_red = $row['MAX(vrstni_red)'] + 1;
}
else
$vrstni_red = 1;
// Vstavljamo BREAK
if($type == 9){
// Ustvarimo instanco breaka
$this->classInstance = new SurveyBreak($this->ank_id);
$spr1 = (isset($_POST['spr1'])) ? $_POST['spr1'] : 0;
$spremenljivka = explode("-", $spr1);
$sub_type = (isset($_POST['sub_type'])) ? $_POST['sub_type'] : 0;
// Loop po odvisnih spremenljivkah in variablah
$variables = $this->getBreakDependentVariableList();
foreach ($variables as $variable) {
// Ce ne gre za disablan element in ne gre za isto spremenljivko kot spr1
if((int)$variable['canChoose'] == 1 && $variable['spr_id'] != $spremenljivka[1]){
$spr2 = $variable['sequence'].'-'.$variable['spr_id'].'-undefined';
// Vstavimo element v bazo
$sqlInsert = sisplet_query("INSERT INTO srv_custom_report (ank_id, usr_id, vrstni_red, type, sub_type, spr1, spr2, profile, time_edit) VALUES('$this->ank_id', '$this->creportAuthor', '$vrstni_red', '9', '$sub_type', '$spr1', '$spr2', '$this->creportProfile', NOW())");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
$vrstni_red++;
}
}
}
// Vstavljamo ostale osnove (sums, grafi, freq, desc)
else{
# preberemo header
foreach (SurveyAnalysis::$_HEADERS AS $spid => $spremenljivka) {
# preverjamo ali je meta
if ($spremenljivka['tip'] != 'm' && in_array($spremenljivka['tip'], SurveyAnalysis::$_FILTRED_TYPES )){
# preverimo ali prikazujemo spremenljivko, glede na veljavne odgovore
$only_valid = 0;
if (count($spremenljivka['grids']) > 0) {
foreach ($spremenljivka['grids'] AS $gid => $grid) {
# dodamo dodatne vrstice z albelami grida
if (count($grid['variables']) > 0 )
foreach ($grid['variables'] AS $vid => $variable ){
$_sequence = $variable['sequence']; # id kolone z podatki
$only_valid += (int)SurveyAnalysis::$_FREQUENCYS[$_sequence]['validCnt'];
}
}
}
// Ce ja kaksen veljaven oz ce prikazujemo tudi prazne
if(SurveyDataSettingProfiles :: getSetting('hideEmpty') != 1 || $only_valid > 0){
$sqlInsert = sisplet_query("INSERT INTO srv_custom_report (ank_id, usr_id, vrstni_red, type, spr1, profile, time_edit) VALUES('$this->ank_id', '$this->creportAuthor', '$vrstni_red', '$type', '$spid', '$this->creportProfile', NOW())");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
$vrstni_red++;
}
}
}
}
//$this->displayReport();
}
// Odpremo okno za izbiro/save profila
if($_GET['a'] == 'creport_show_profiles') {
$this->displaySettingsProfiles();
}
// Spreminjamo profil
if($_GET['a'] == 'creport_change_profile') {
if (isset ($_POST['id']))
$id = $_POST['id'];
if (isset ($_POST['author']))
$author = $_POST['author'];
$this->creportProfile = $id;
$this->creportAuthor = $author;
$this->displaySettingsProfiles();
}
// preimenujemo profil
if($_GET['a'] == 'renameProfile') {
if (isset ($_POST['id']))
$id = $_POST['id'];
if (isset ($_POST['name']))
$name = $_POST['name'];
// Default profil shranimo drugam ker ga ni v bazi (prevec komplikacij ker je bilo to naknadno delano)
if($id == 0){
$what = 'creport_default_profile_name';
$sql = sisplet_query("INSERT INTO srv_user_setting_for_survey (sid, uid, what, value) VALUES ('$this->ank_id', '$global_user_id', '$what', '$name') ON DUPLICATE KEY UPDATE value='$name'");
}
else
$sql = sisplet_query("UPDATE srv_custom_report_profiles SET name='$name' WHERE id='$id'");
$this->displaySettingsProfiles();
}
// pobrisemo profil
if($_GET['a'] == 'deleteProfile') {
if (isset ($_POST['id']))
$id = $_POST['id'];
$sql = sisplet_query("DELETE FROM srv_custom_report_profiles WHERE ank_id='$this->ank_id' AND usr_id='$global_user_id' AND id='$id'");
$sql = sisplet_query("DELETE FROM srv_custom_report WHERE ank_id='$this->ank_id' AND usr_id='$global_user_id' AND profile='$id'");
$this->displaySettingsProfiles();
}
// shranimo kot nov profil
if($_GET['a'] == 'newProfile') {
if (isset ($_POST['name']))
$name = $_POST['name'];
if (isset ($_POST['comment']))
$comment = $_POST['comment'];
$sql = sisplet_query("INSERT INTO srv_custom_report_profiles (ank_id, usr_id, name, time_created) VALUES('$this->ank_id', '$global_user_id', '$name', NOW())");
$profile_id = mysqli_insert_id($GLOBALS['connect_db']);
SurveyUserSetting :: getInstance()->saveSettings('default_creport_profile', $profile_id);
$this->creportProfile = $profile_id;
SurveyUserSetting :: getInstance()->saveSettings('default_creport_author', $global_user_id);
$this->creportAuthor = $global_user_id;
// Dodamo se komentar porocila
$what = 'creport_comment_profile_'.$this->creportProfile;
if($comment != ''){
$s = sisplet_query("INSERT INTO srv_user_setting_for_survey (sid, uid, what, value) VALUES ('$this->ank_id', '$global_user_id', '$what', '$comment') ON DUPLICATE KEY UPDATE value='$comment'");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
}
else{
$s = sisplet_query("DELETE FROM srv_user_setting_for_survey WHERE sid='$this->ank_id' AND uid='$global_user_id' AND what='$what'");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
}
//$this->displaySettingsProfiles();
}
// pozenemo izbran profil
if($_GET['a'] == 'use_creport_profile') {
if (isset ($_POST['id']))
$id = $_POST['id'];
if (isset ($_POST['author']))
$author = $_POST['author'];
SurveyUserSetting :: getInstance()->saveSettings('default_creport_profile', $id);
SurveyUserSetting :: getInstance()->saveSettings('default_creport_author', $author);
//$this->displayReport();
}
// urejanje komentarja profila
if($_GET['a'] == 'edit_profile_comment') {
$what = 'creport_comment_profile_'.$this->creportProfile;
if($value != ''){
$s = sisplet_query("INSERT INTO srv_user_setting_for_survey (sid, uid, what, value) VALUES ('$this->ank_id', '$global_user_id', '$what', '$value') ON DUPLICATE KEY UPDATE value='$value'");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
}
else{
$s = sisplet_query("DELETE FROM srv_user_setting_for_survey WHERE sid='$this->ank_id' AND uid='$global_user_id' AND what='$what'");
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
}
}
// prikazemo deljenje profila z drugimi uredniki
if($_GET['a'] == 'shareProfileShow') {
echo ''.$lang['srv_custom_report_share_long'].': '."\n";
if (isset ($_POST['id'])){
$id = $_POST['id'];
// Loop cez vse urednike ankete z dostopom do analiz
$d = new Dostop();
$users = $d->getUsersDostop();
foreach($users as $user){
if($user['id'] != $global_user_id){
$sql = sisplet_query("SELECT * FROM srv_custom_report_share WHERE ank_id='".$this->ank_id."' AND profile_id='".$id."' AND author_usr_id='".$global_user_id."' AND share_usr_id='".$user['id']."' LIMIT 1");
$checked = (mysqli_num_rows($sql) > 0) ? ' checked="checked"' : '';
echo ''.$user['email'].' '.$lang['srv_custom_report_share'].' '.$lang['srv_close_profile'].' 
'.$lang['hour_print2'].'!['.$lang['hour_print2'].'](icons/icons/printer.png){kind=icon}
'.$lang['hour_print2'].'