<?php
global $site_path;
include_once('../../function.php');
include_once('../survey/definition.php');
//require_once('../exportclases/class.enka.pdf.php');
define("ALLOW_HIDE_ZERRO_REGULAR", false); // omogočimo delovanje prikazovanja/skrivanja ničelnih vnosti za navadne odgovore
define("ALLOW_HIDE_ZERRO_MISSING", true); // omogočimo delovanje prikazovanja/skrivanja ničelnih vnosti za missinge
define("NUM_DIGIT_AVERAGE", 2); // stevilo digitalnih mest za povprecje
define("NUM_DIGIT_DEVIATION", 2); // stevilo digitalnih mest za povprecje
define("M_ANALIZA_DESCRIPTOR", "descriptor");
define("M_ANALIZA_FREQUENCY", "frequency");
define("RADIO_BTN_SIZE", 3);
define("CHCK_BTN_SIZE", 3);
define("LINE_BREAK", 6);
define ('FRAME_TEXT_WIDTH', 0.3);
define ('FRAME_WIDTH', 480);
define ('FRAME_HEIGTH', 203);
define ('GRAPH_LINE_WIDTH', 0.15);
define ('GRAPH_LINE_LENGTH_MAX', 7);
/** Class za generacijo pdf-a
*
* @desc: po novem je potrebno form elemente generirati ro�no kot slike
*
*/
class LatexEditsAnalysis {
var $anketa;// = array(); // trenutna anketa
var $pi=array('canCreate'=>false); // za shrambo parametrov in sporocil
var $pdf;
var $currentStyle;
var $db_table = '';
public static $ss = null; //SurveyStatistic class
public static $sas = null; // $sas = new SurveyAdminSettings();class
protected $texNewLine = '\\\\ ';
protected $texBigSkip = '\bigskip';
protected $texSmallSkip = '\smallskip';
protected $horizontalLineTex = "\\hline ";
//nastavitve za prikazovanje
protected $seansa = '30';
protected $times = '1 month';
protected $status = 0;
protected $from = '';
protected $to = '';
protected $period = 'day';
protected $user = 'all';
//nastavitve za prikazovanje - konec
protected $interval;
protected $data;
protected $statuses;
protected $sum_data;
protected $texTimeEdits='';
protected $vrsticaTex = array();
protected $seanse = null;
protected $timings = null;
protected $interval_criteria = array();
public static $spremenljivka=null;
public static $sea = null; //SurveyEditsAnalysis class
/**
* @desc konstruktor
*/
function __construct ($anketa = null, $ssData = null)
{
global $site_path;
global $global_user_id;
global $lang;
//error_log(json_encode($_GET));
// preverimo ali imamo stevilko ankete
if ( is_numeric($anketa) )
{
$this->anketa['id'] = $anketa;
//$this->anketa['podstran'] = $podstran; //pokomentirano, ker se ne uporablja nikjer in je težava s PHP8
}
else
{
$this->pi['msg'] = "Anketa ni izbrana!";
$this->pi['canCreate'] = false;
return false;
}
$this->sea=new SurveyEditsAnalysis($this->anketa['id']);
if ($_GET['seansa'] > 0){
//if (isset ($_GET['seansa'])){
$seansa = $_GET['seansa'];
}else{
$seansa = '30';
}
if (isset ($_GET['time'])){
$time = $_GET['time'];
}else{
$time = '1 month';
}
if (isset ($_GET['status'])){
$status = $_GET['status'];
}else{
$status = 0;
}
if (isset ($_GET['from'])){
$from = $_GET['from'];
}else{
$from = '';
}
if (isset ($_GET['to'])){
$to = $_GET['to'];
}else{
$to = '';
}
if (isset ($_GET['user'])){
$user = $_GET['user'];
}else{
$user = 'all';
}
if (isset ($_GET['period'])){
$period = $_GET['period'];
}else{
$period = 'day';
}
$this->seansa = $seansa;
$this->times = $time;
$this->status = $status;
$this->from = $from;
$this->to = $to;
$this->period = $period;
$this->user = $user;
// Legenda statusov
$this->statuses = array(
-1 => $lang['srv_vsi'],
0 => $lang['srv_urejanje'],
1 => $lang['import_data'],
2 => $lang['export_analisys'],
3 => $lang['srv_reporti'],
4 => $lang['srv_podatki'],
5 => $lang['srv_inv_nav_email'],
20 => $lang['srv_hierarchy'], // Splošni podatki o hierarhiji
21 => $lang['srv_hierarchy_structure'], // Grajenje hierarhije
22 => $lang['srv_hierarchy_users'], // Urejanje uporabnikov
);
// Legenda seans
$this->seanse = array(
5 => $lang['srv_edits_analysis_seansa_5min'],
10 => $lang['srv_edits_analysis_seansa_10min'],
30 => $lang['srv_edits_analysis_seansa_30min'], // Grajenje hierarhije
60 => $lang['srv_edits_analysis_seansa_60min'], // Urejanje uporabnikov
);
// Legenda casov
$this->timings = array(
'lifetime' => $lang['srv_edits_analysis_period_lifetime'],
'1 hour' => $lang['srv_diagnostics_1 hour'],
'6 hour' => $lang['srv_diagnostics_6 hour'],
'12 hour' => $lang['srv_diagnostics_12 hour'],
'1 day' => $lang['srv_diagnostics_1 day'],
'2 day' => $lang['srv_diagnostics_2 day'],
'5 day' => $lang['srv_diagnostics_5 day'],
'7 day' => $lang['srv_diagnostics_7 day'],
'14 day' => $lang['srv_diagnostics_14 day'],
'1 month' => $lang['srv_diagnostics_1 month'],
'3 month' => $lang['srv_diagnostics_3 month'],
'6 month' => $lang['srv_diagnostics_6 month'],
'99date' => $lang['srv_diagnostics_choose_date'],
);
// Legenda intervalov
$this->interval_criteria = array(
'hour' => $lang['srv_statistic_period_hour_period'],
'day' => $lang['srv_statistic_period_day_period'],
);
//print_r($_GET);
//create iterval - SQL where statement
$this->interval = $this->sea->createInterval($time, $from, $to);
//get object of all edits data
$this->data = $this->sea->getData($status, $this->interval);
$sum_data = $this->TimeEdits($this->data['timeEdits'], $this->seansa*60, $status);
$this->sum_data = $sum_data;
$this->sas = new SurveyAdminSettings(0,$this->anketa['id']);
//ustvarimo SurveyStatistic objekt in mu napolnimo variable
$this->ss = new SurveyStatistic();
$this->ss->Init($this->anketa['id'],true);
/*
$this->ss->realUsersByStatus_base = $ssData[0];
$this->ss->type = $ssData[1];
$this->ss->period = $ssData[2];
*/
/* intervali se več ne pošiljajo preko get, ker se polovijo iz porfila
if($ssData[1] != 'undefined')
$this->ss->startDate = $ssData[1];
if($ssData[2] != 'undefined')
$this->ss->endDate = $ssData[2];
$this->ss->type = $ssData[3];
$this->ss->period = $ssData[4];
//$this->ss->isDefaultFilters = false;
*/
//if ( SurveyInfo::getInstance()->SurveyInit($this->anketa['id']) && $this->init())
if ( SurveyInfo::getInstance()->SurveyInit($this->anketa['id']))
{
$this->anketa['uid'] = $global_user_id;
SurveyUserSetting::getInstance()->Init($this->anketa['id'], $this->anketa['uid']);
}
else
return false;
// ce smo prisli do tu je vse ok
$this->pi['canCreate'] = true;
return true;
}
// SETTERS && GETTERS
function checkCreate()
{
return $this->pi['canCreate'];
}
function getFile($fileName='')
{
//Close and output PDF document
ob_end_clean();
$this->pdf->Output($fileName, 'I');
}
public function displayEditAnalysis() {
global $lang;
$texEditAnalysis = '';
// imamo vnose, prikažemo statistiko
//$this->ss->PrepareDateView();
//$this->ss->PrepareStatusView();
//naslov izvoza
//$texEditAnalysis .= $this->returnBold($lang['srv_edits_analysis']).$this->texNewLine.$this->texNewLine;
$texEditAnalysis .= '\MakeUppercase{\huge \textbf{Status - '.$lang['srv_edits_analysis'].'}}'.$this->texBigSkip.$this->texNewLine;
//$texStatus .= '\begin{tableStatus}'; /*zacetek environmenta z manjsim fontom*/
$texEditAnalysis .= '\begin{tableStatus}'; /*zacetek environmenta z manjsim fontom*/
//vrstica z nastavitvami #########################
$texEditAnalysis .= $this->returnBold($lang['srv_edits_analysis_seansa']).''.$this->seanse[$this->seansa].' '.$this->returnBold($lang['status']).''.$this->statuses[$this->status].' '.$this->returnBold($lang['in']).':'.$this->timings[$this->times].''.$this->returnBold($lang['srv_diagnostics_orfrom']).' '.$this->from.' '.$this->returnBold($lang['srv_diagnostics_to']).' '.$this->to.'';
$texEditAnalysis .= $this->texBigSkip.$this->texNewLine;
if(is_countable($this->data) && sizeof($this->data) == 0){
$texEditAnalysis .= $lang['srv_edits_analysis_no_data'];
}
else{
//Akcije urejanja #########################
$texEditAnalysis .= $this->DisplayCounter();
//prostor med tabelama
$texEditAnalysis .= $this->texBigSkip.$this->texBigSkip.$this->texNewLine;
//Neprekinjeno urejanje #########################
$texEditAnalysis .= $this->DisplayContinu();
//prostor med tabelama
//$texEditAnalysis .= $this->texBigSkip.$this->texBigSkip.$this->texNewLine;
$texEditAnalysis .= $this->texBigSkip.$this->texBigSkip;
//Podrobnosti urejanja #########################
$texEditAnalysis .= $this->DisplayTimeEdits();
}
//$texStatus .= '\end{tableStatus}'; /*zakljucek environmenta z manjsim fontom*/
$texEditAnalysis .= '\end{tableStatus}'; /*zakljucek environmenta z manjsim fontom*/
//echo $texEditAnalysis;
return $texEditAnalysis;
}
/** Funkcija prikaze Akcije urejanja
*
*/
function DisplayCounter() {
global $lang;
global $site_url;
$tex = '';
//naslov okvirja
$titleText = LatexDocument::encodeText($lang['srv_edits_analysis_counter']).$this->texNewLine;
$title = $this->returnBoldAndRed($titleText);
if(is_countable($this->data) && sizeof($this->data) == 0)
$tex .= $lang['srv_edits_analysis_no_data'];
else{
$sum_data = $this->sum_data;
//izpis stevila urejevalcev
$tex .= $lang['srv_edits_analysis_counter_editors'].': '.sizeof($sum_data).$this->texBigSkip.$this->texNewLine;
$sum_akcij = 0;
$sum_time = 0;
$sum_seans = 0;
//Priprava parametrov za tabelo s podatki o anketi
$steviloStolpcevParameterTabular = 4;
$steviloOstalihStolpcev = $steviloStolpcevParameterTabular - 1; /*stevilo stolpcev brez prvega stolpca, ki ima fiksno sirino*/
$sirinaOstalihStolpcev = 0.9/$steviloOstalihStolpcev;
$parameterTabular = '';
$export_format = 'pdf';
for($i = 0; $i < $steviloStolpcevParameterTabular; $i++){
//ce je prvi stolpec
if($i == 0){
//$parameterTabular .= ($export_format == 'pdf' ? 'X|' : 'l|');
$parameterTabular .= 'l|';
}elseif($i == $steviloOstalihStolpcev){
//$parameterTabular .= ($export_format == 'pdf' ? 'C' : 'c');
$parameterTabular .='c';
}else{
//$parameterTabular .= ($export_format == 'pdf' ? 'C|' : 'c|');
$parameterTabular .= 'c|';
}
}
//Priprava parametrov za tabelo s podatki o anketi - konec
//zacetek latex tabele z obrobo za prvo tabelo
$pdfTable = 'tabular';
$rtfTable = 'tabular';
$pdfTableWidth = 1;
$rtfTableWidth = 1;
$tex .= $this->StartLatexTable($export_format, $parameterTabular, $pdfTable, $rtfTable, $pdfTableWidth, $rtfTableWidth); /*zacetek tabele*/
//Priprava parametrov za tabelo s podatki o anketi - konec
//Priprava podatkov za izpis vrstic tabele in njihov izpis
$prvaVrstica = array();
$prvaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_counter_editor']);
$prvaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_time_time']);
$prvaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_num_sessions']);
$prvaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_time_actions']);
$tex .= $this->tableRow($prvaVrstica); //Izpis 1. vrstice tabele
foreach ($sum_data as $key => $value) {
$vrsticaPodatki = array();
$vrsticaPodatki[] = $key;
$vrsticaPodatki[] = $this->sea->calculateTimeFromSeconds($value['time_sum']);
$vrsticaPodatki[] = $value['st_seans_sum'];
$vrsticaPodatki[] = $value['st_akcij_sum'];
$tex .= $this->tableRow($vrsticaPodatki); //Izpis vrstic tabele s podatki
$sum_akcij += $value['st_akcij_sum'];
$sum_time += $value['time_sum'];
$sum_seans += $value['st_seans_sum'];
}
// vsota veljavnih
$vrsticaSum = array();
$vrsticaSum[] = LatexDocument::encodeText($lang['srv_edits_analysis_time_total']);
$vrsticaSum[] = $this->sea->calculateTimeFromSeconds($sum_time);
$vrsticaSum[] = $sum_seans;
$vrsticaSum[] = $sum_akcij;
$tex .= $this->tableRow($vrsticaSum); //Izpis vrstice s sumo
//Priprava podatkov za izpis vrstic tabele in njihov izpis - konec
//zaljucek latex tabele s podatki
$tex .= "\\end{".$pdfTable."}";
//zaljucek latex tabele s podatki - konec
}
//izpis tabele v okvir
//$texText = $this->FrameText($title.$tex);
$texText = ($title.$tex);
//echo $tex;
return $texText;
}
/** Funkcija prikaze Neprekinjeno urejanje
*
*/
function DisplayContinu() {
global $lang;
$tex = '';
$sum_data = $this->sum_data;
//naslov okvirja
$titleText = LatexDocument::encodeText($lang['srv_edits_analysis_countinu']).$this->texNewLine;
$title = $this->returnBoldAndRed($titleText);
//izpis nastavitev
if($this->user == 'all'){
$user = $lang['srv_edits_analysis_counter_all'];
}else{
foreach ($sum_data as $email => $row) {
if($row['user_id'] == $this->user){
$user = $email;
}
}
}
$tex .= $lang['srv_edits_analysis_counter_editors'].': '.$user.'; '.$lang['srv_statistic_period'].': '.$this->interval_criteria[$this->period].$this->texBigSkip.$this->texNewLine;
//izpis nastavitev - konec
$interval_criteria = $this->period;
$user_criteria = $this->user;
$continu_data = $this->sea->continuEditsQuery($this->status, $this->interval, $interval_criteria, $user_criteria);
$data = $continu_data;
##################
$maxValue = 0;
$interval_seconds = ($interval_criteria == 'day') ? 86400 : 3600;
$interval_crit = ($interval_criteria == 'day') ? '' : ' H';
if ($data) {
$temp_time = null;
//units
$zapored = 0;
$results = array();
foreach ($data as $row) {
if($temp_time == null){
//$format = 'Y-m-d'.$interval_crit;
$temp_time = DateTime::createFromFormat('Y-m-d'.$interval_crit, $row['formatdate']);
//$temp_time = DateTime::createFromFormat($format, $row['formatdate']);
}
else{
//calculate seconds between actions (rounded on 3600 or 86400)
$interval = $this->sea->calculateTimeBetweenActions($temp_time, DateTime::createFromFormat('Y-m-d'.$interval_crit, $row['formatdate']));
//if interval between actions are 1 unit (1 hour or 1 day), add it to continued editing session
if((float) $interval/$interval_seconds-$zapored < 2){
$zapored++;
//set maxValue, needed for width of bars
$maxValue = max($maxValue, $zapored);
}
//interval is more than 1 unit apart, not in continued editing session
else{
//if there is continued editing session until previous action, store it to array - ignore otherwise
if($zapored > 0){
array_push($results, array('time' => $temp_time, 'zapored' => $zapored));
}
//restart all
$temp_time = DateTime::createFromFormat('Y-m-d'.$interval_crit, $row['formatdate']);
$zapored = 0;
}
}
}
//if there is continued editing session in last actions, store it to array - ignore otherwise
if($zapored > 0){
//$this->ContinuRow($temp_time, $zapored, $maxValue, $value);
array_push($results, array('time' => $temp_time, 'zapored' => $zapored));
}
if(!$results){
//$this->echoNoData();
$tex .= LatexDocument::encodeText($lang['srv_no_data']).$this->texNewLine;
}
else{
//Priprava parametrov za tabelo s podatki o anketi
$steviloStolpcevParameterTabular = 2;
$steviloOstalihStolpcev = $steviloStolpcevParameterTabular - 1; /*stevilo stolpcev brez prvega stolpca, ki ima fiksno sirino*/
$sirinaOstalihStolpcev = 0.9/$steviloOstalihStolpcev;
$parameterTabular = '';
$export_format = 'pdf';
//$parameterTabular = '|';
for($i = 0; $i < $steviloStolpcevParameterTabular; $i++){
if($i == 0){
$parameterTabular .= ($export_format == 'pdf' ? '>{\hsize=.3\hsize}X' : 'l'); //fiksna sirina prvega stolpca, da sprejme datum in uro
}else{
$parameterTabular .= ($export_format == 'pdf' ? 'X' : 'l');
}
}
$pdfTable = 'tabularx';
$rtfTable = 'tabular';
$pdfTableWidth = 1;
$rtfTableWidth = 1;
$tex .= $this->StartLatexTable($export_format, $parameterTabular, $pdfTable, $rtfTable, $pdfTableWidth, $rtfTableWidth);
//Priprava parametrov za tabelo s podatki o anketi - konec
//Priprava podatkov za izpis vrstic tabele in izpis vrstic
//reduce bars a little
$maxValue *= GRAPH_REDUCE;//najvecje stevilo
//draw all data and bars
foreach ($results as $row) {
$text = $this->ContinuRow($row['time'], $row['zapored'], $maxValue, $interval_criteria);
$tex .= $this->displayLineWithGraph($text, ($row['zapored']+1), $maxValue);
}
//Priprava podatkov za izpis vrstic tabele in izpis vrstic - konec
//zaljucek latex tabele s podatki
$tex .= "\\end{".$pdfTable."}";
//zaljucek latex tabele s podatki - konec
}
} else{
//$this->echoNoData();
$tex .= LatexDocument::encodeText($lang['srv_no_data']).$this->texNewLine;
}
#################
//izpis tabele in besedila v okvir
//$texText = $this->FrameText($title.$tex);
$texText = ($title.$tex);
return $texText;
}
/**
* Returns time string in exact format
* @param type $temp_time - the last edit
* @param type $zapored - hour of continuoed editing
* @param type $maxValue - max value of bars
* @param type $interval_criteria - criteria for interval - continued 'day' or 'hour'
*/
function ContinuRow($temp_time=null, $zapored=null, $maxValue=null, $interval_criteria=null){
$s_time = '';
$time_last = clone $temp_time;
//edit DateTime get starting of continued editting session by subtracting units
$temp_time->modify('- '.$zapored.' '.$interval_criteria);
//if hour criteria
if($interval_criteria == 'hour'){
//add 1 hour because of from to view
$time_last->modify('+ 1 '.$interval_criteria);
$s_time = $temp_time->format('Y-m-d H:00') .' - '. $time_last->format('H:00');
}
elseif($interval_criteria == 'day'){
$s_time = $temp_time->format('Y-m-d') .' - '. $time_last->format('Y-m-d');
}
return $s_time;
}
/** Funkcija prikaze Podrobnosti urejanja
*
*/
function DisplayTimeEdits() {
global $lang;
$tex = '';
$sum_data = $this->sum_data;
//naslov okvirja
$titleText = LatexDocument::encodeText($lang['srv_edits_analysis_editing_details']).$this->texNewLine;
$title = $this->returnBoldAndRed($titleText);
$tex .= $this->texTimeEdits;
//izpis tabele in besedila v okvir
//$texText = $this->FrameText($title.$tex);
$texText = ($title.$tex);
return $texText;
}
/*Skrajsa tekst in doda '...' na koncu*/
function snippet($text='', $length=64, $tail="..."){
$text = trim($text);
$txtl = strlen($text);
if($txtl > $length)
{
for($i=1;$text[$length-$i]!=" ";$i++)
{
if($i == $length)
{
return substr($text,0,$length) . $tail;
}
}
$text = substr($text,0,$length-$i+1) . $tail;
}
return $text;
}
function setUserId($usrId=null) {$this->anketa['uid'] = $usrId;}
function getUserId() {return ($this->anketa['uid'])?$this->anketa['uid']:false;}
function formatNumber($value=null, $digit=0, $sufix="")
{
if ( $value <> 0 && $value != null )
$result = round($value,$digit);
else
$result = "0";
$result = number_format($result, $digit, ',', '.').$sufix;
return $result;
}
#moja funkcija encodeText
function encodeText($text=''){
// popravimo sumnike ce je potrebno
//$text = html_entity_decode($text, ENT_NOQUOTES, 'UTF-8');
//$text = str_replace("š","š",$text);
//echo "Encoding ".$text."</br>";
if($text == ''){ //ce ni teksta, vrni se
return;
}
$textOrig = $text;
$findme = '<br />';
$findmeLength = strlen($findme);
$findImg = '<img';
$findImgLength = strlen($findImg);
$pos = strpos($text, $findme);
$posImg = strpos($text, $findImg);
//ureditev izrisa slike
if($posImg !== false){
$numOfImgs = substr_count($text, $findImg); //stevilo '<br />' v tekstu
$posImg = strpos($text, $findImg);
$textPrej = '';
$textPotem = '';
for($i=0; $i<$numOfImgs; $i++){
$posImg = strpos($text, $findImg);
$textPrej = substr($text, 0, $posImg); //tekst do img
$textPotem = substr($text, $posImg); //tekst po img, z vkljuceno hmlt kodo z img
$posImgEnd = strpos($textPotem, '/>'); //pozicija, kjer se konca html koda za img
$textPotem = substr($textPotem, $posImgEnd+strlen('/>')); //tekst od konca html kode za img dalje
$text = $textPrej.' '.PIC_SIZE_ANS."{".$this->getImageName($text, 0, '<img')."}".' '.$textPotem;
}
//pred ureditvijo posebnih karakterjev, odstrani del teksta s kodo za sliko, da se ne pojavijo tezave zaradi imena datoteke od slike
$findImgCode = '\includegraphics';
$posOfImgCode = strpos($text, $findImgCode);
//echo $posOfImgCode."</br>";
$textToImgCode = substr($text, 0, $posOfImgCode); //tekst do $findImgCode
//echo $textToImgCode."</br>";
$textFromImgCode = substr($text, $posOfImgCode); //tekst po $findImgCode
//echo $textFromImgCode."</br>";
$findImgCodeEnd = '}';
//$posOfImgCodeEnd = strpos($text, $findImgCodeEnd);
$posOfImgCodeEnd = strpos($textFromImgCode, $findImgCodeEnd);
//echo $posOfImgCodeEnd."</br>";
$textAfterImgCode = substr($textFromImgCode, $posOfImgCodeEnd+1); //tekst po $findImgCodeEnd
//echo $textAfterImgCode."</br>";
$textOfImgCode = substr($text, $posOfImgCode, $posOfImgCodeEnd+1);
//echo $textOfImgCode."</br>";
$text = $textToImgCode.$textAfterImgCode;
//pred ureditvijo posebnih karakterjev, odstrani del teksta s kodo za sliko, da se ne pojavijo tezave zaradi imena datoteke od slike - konec
}
//ureditev izrisa slike - konec
//ureditev posebnih karakterjev za Latex http://www.cespedes.org/blog/85/how-to-escape-latex-special-characters, https://en.wikibooks.org/wiki/LaTeX/Special_Characters#Other_symbols
$text = str_replace('\\','\textbackslash{} ',$text);
//$text = str_replace('{','\{',$text);
//$text = str_replace('}','\}',$text);
$text = str_replace('$','\$ ',$text);
$text = str_replace('#','\# ',$text);
$text = str_replace('%','\% ',$text);
$text = str_replace('€','\euro',$text);
$text = str_replace('^','\textasciicircum{} ',$text);
//$text = str_replace('_','\_ ',$text);
$text = str_replace('_','\_',$text);
$text = str_replace('~','\textasciitilde{} ',$text);
$text = str_replace('&','\&',$text);
$text = str_replace('&','\&',$text);
//$text = str_replace('<','\textless ',$text);
$text = str_replace('<','\textless',$text);
//$text = str_replace('>','\textgreater ',$text);
$text = str_replace('>','\textgreater',$text);
$text = str_replace(' ',' ',$text);
//ureditev posebnih karakterjev za Latex - konec
//po ureditvi posebnih karakterjev, dodati del teksta s kodo za sliko, ce je slika prisotna
if($posImg !== false){
$text = substr_replace($text, $textOfImgCode, $posOfImgCode, 0);
}
//po ureditvi posebnih karakterjev, dodati del teksta s kodo za sliko, ce je slika prisotna
if($pos === false && $posImg === false) { //v tekstu ni br in img
//return $text;
/* echo "encode pred strip: ".$text."</br>";
echo "encode po strip: ".strip_tags($text)."</br>";
return strip_tags($text); */
}else { //v tekstu sta prisotna br ali img
$text2Return = ''; //tekst ki bo vrnjen
//ureditev preureditev html kode za novo vrstico v latex, ureditev prenosa v novo vrstico
if($pos !== false){
$pos = strpos($text, $findme);
$numOfBr = substr_count($text, $findme); //stevilo '<br />' v tekstu
for($i=0; $i<$numOfBr; $i++){
if($i == 0){ //ce je prvi najdeni '<br />'
$textPrej = substr($text, 0, $pos);
$textPotem = substr($text, $pos+$findmeLength);
if($i == $numOfBr-1){
$text2Return .= $textPrej.' \break '.$textPotem;
}else{
$text2Return .= $textPrej.' \break ';
}
}else{ //drugace
$pos = strpos($textPotem, $findme);
$textPrej = substr($textPotem, 0, $pos);
$textPotem = substr($textPotem, $pos+$findmeLength);
if($i == $numOfBr-1){
$text2Return .= $textPrej.' \break '.$textPotem;
}else{
$text2Return .= $textPrej.' \break ';
}
}
}
$text = $text2Return;
}
//ureditev preureditev html kode za novo vrstico v latex, ureditev prenosa v novo vrstico - konec
/* echo "encode pred strip: ".$text."</br>";
echo "encode po strip: ".strip_tags($text)."</br>";
return strip_tags($text); //vrni tekst brez html tag-ov */
}
//preveri, ce je url v besedilu (http:// ... ) in uredi Latex izpis le-tega
$findHttp = 'http://';
$findHttps = 'https://';
$posHttp = strpos($text, $findHttp);
$posHttps = strpos($text, $findHttps);
if($posHttp !== false || $posHttps !== false) { //v imamo URL naslov
$space = ' ';
if($posHttp !== false){
$text = substr_replace($text, $space, ($posHttp+7), 0);
}elseif($posHttps !== false){
$text = substr_replace($text, $space, ($posHttps+8), 0);
}
}
//preveri, ce je url v besedilu (http:// ... ) in uredi Latex izpis le-tega - konec
return strip_tags($text); //vrni tekst brez html tag-ov
}
function returnBold($text=''){
$boldedText = '';
$boldedText .= '\textbf{'.$text.'}';
return $boldedText;
}
function returnBoldAndRed($text=''){
//$this->naslovnicaUkaz .= ' {\\textcolor{red}{'.$lang['srv_survey_non_active1'].'}} \\\\';
$tex = '';
$tex .= ' {\\textcolor{red}{'.$text.'}} ';
return $tex;
}
#funkcija, ki skrbi za izpis latex kode za zacetek tabele ##################################################################################
#argumenti 1. export_format, 2. parametri tabele, 3. tip tabele za pdf, 4. tip tabele za rtf, 5. sirina pdf tabele (delez sirine strani), 6. sirina rtf tabele (delez sirine strani)
function StartLatexTable($export_format='', $parameterTabular='', $pdfTable='', $rtfTable='', $pdfTableWidth='', $rtfTableWidth=''){
$tex = '';
//$tex .= '\keepXColumns';
if($export_format == 'pdf'){
$tex .= '\begin{'.$pdfTable.'}';
if($pdfTable=='tabularx'){
//$tex .= '{'.$pdfTableWidth.'\textwidth}';
$tex .= '{\hsize}';
}
$tex .= '{ '.$parameterTabular.' }';
}elseif($export_format == 'rtf'){
$tex .= '\begin{'.$rtfTable.'}';
if($rtfTable=='tabular*'){
$tex .= '{'.$pdfTableWidth.'\textwidth}';
}
$tex .= '{ '.$parameterTabular.' }';
}
return $tex;
}
#funkcija, ki skrbi za izpis latex kode za zacetek tabele - konec ##########################################################################
//omogoca izpis okvirja z dolocene sirine in visine s tekstom dolocene sirine
function FrameText($text=''){
$framedText = '';
//$framedText .= '\framebox('.FRAME_WIDTH.','.FRAME_HEIGTH.')[t]{ \parbox[t]{'.FRAME_TEXT_WIDTH.'\textwidth}{'.$this->texSmallSkip.$text.'} }';
$framedText .= '\framebox('.FRAME_WIDTH.','.FRAME_HEIGTH.')[t]{ \parbox[t]{'.FRAME_WIDTH.'pt}{'.$this->texSmallSkip.$text.'} }';
return $framedText;
}
//function tableRow($arrayText, $brezHline=0, $brezNoveVrstice=0, $nadaljevanjeVrstice=0, $steviloPodstolpcev){
function tableRow($arrayText=null, $brezHline=0, $brezNoveVrstice=0, $nadaljevanjeVrstice=0, $color='', $export_format = null, $steviloPodstolpcev = null){
$tableRow = '';
/*$linecount = $this->pdf->getNumLines(LatexDocument::encodeText($arrayText[1]), 90);
$linecount == 1 ? $height = 4.7 : $height = 4.7 + ($linecount-1)*3.3;*/
$height = 1; //$height = $this->getCellHeight(LatexDocument::encodeText($arrayText[1]), 90);
/* if($arrayParams['align2'] != 'C')
$arrayParams['align2'] = 'L'; */
if($export_format == 'pdf'){
if($color=='blue'){
$cellBgColor = 'cyan';
}elseif($color=='red'){
$cellBgColor = 'pink';
}
$cellColoring = ' \cellcolor{'.$cellBgColor.'} ';
}else{
$cellColoring = '';
}
for($i=0;$i<count($arrayText);$i++){
//echo "array text: ".$arrayText[$i]."</br>";
if($color!=''){ //ce je potrebno besedilo dolocene barve
$text = $cellColoring.''.$this->coloredTextLatex($color, $arrayText[$i]);
}else{
$text = $arrayText[$i];
}
if($i==0&&!$nadaljevanjeVrstice&&!count($steviloPodstolpcev)){
$tableRow .= $text;
}
elseif($i==0&&!$nadaljevanjeVrstice&&count($steviloPodstolpcev)){
$tableRow .= ' \multicolumn{'.$steviloPodstolpcev[$i].'}{c|}{ '.$text.' }';
}elseif(count($steviloPodstolpcev)){ //ce rabimo multicolumn
$tableRow .= ' & \multicolumn{'.$steviloPodstolpcev[$i].'}{c|}{ '.$text.' }';
}
else{
$tableRow .= ' & '.$text;
}
}
if(!$brezNoveVrstice){
$tableRow .= $this->texNewLine; /*nova vrstica*/
}
if (!$brezHline) { //dodaj se horizontal line, ce je to potrebno (po navadi vse povsod razen npr. za tabelo s st. odklonom in povprecjem)
if($export_format != 'xls'){
$tableRow .= $this->horizontalLineTex; /*obroba*/
}
}
//echo "Vrstica tabele: ".$tableRow."</br>";
return $tableRow;
}
//funkcija, ki skrbi za izris grafa ustrezne dolzine
function drawGraphLatex($graphLineLength=null, $value=null){
$texGraph = '';
$texGraph .= '\begin{tikzpicture} \fill[crtaGraf] (0,0) -- ('.$graphLineLength.',0) -- ('.$graphLineLength.','.GRAPH_LINE_WIDTH.') -- (0,'.GRAPH_LINE_WIDTH.') -- (0,0); \end{tikzpicture} '.$value;
return $texGraph;
}
function displayLineWithGraph($text='', $value=null, $maxValue=null){
$texStatusLine = '';
$vrsticaPodatki = array();
$vrsticaPodatki[] = $text;
if($value){ //ce vrednost ni nula
$graphLineLength = (GRAPH_LINE_LENGTH_MAX/$maxValue)*$value;
$vrsticaPodatki[] = $this->drawGraphLatex($graphLineLength, $value);
}else{
$vrsticaPodatki[] = 0;
}
$texStatusLine .= $this->tableRow($vrsticaPodatki,1);
return $texStatusLine;
}
function TimeEdits($data=null, $seansa=null, $status=null){
global $lang;
$tex = '';
$sum_data = array();
$datetime_last = null;
$datetime_start = null;
$st_akcij = 0;
$st_akcij_sum = 0;
$st_seans_sum = 0;
$time_sum = 0;
$user_temp = null;
$user_id = 0;
$row_id = 0;
$action_type = null;
$action_type_sum = null;
$statuses = null;
if($status == -1){
$statuses = array(
0 => array("name"=>$lang['srv_urejanje'], "sum"=>0),
1 => array("name"=>$lang['import_data'], "sum"=>0),
2 => array("name"=>$lang['export_analisys'], "sum"=>0),
3 => array("name"=>$lang['srv_reporti'], "sum"=>0),
4 => array("name"=>$lang['srv_podatki'], "sum"=>0),
5 => array("name"=>$lang['srv_inv_nav_email'], "sum"=>0),
//20 => array("name"=>$lang['srv_hierarchy'], "sum"=>0),// Splošni podatki o hierarhiji
//21 => array("name"=>$lang['srv_hierarchy_structure'], "sum"=>0),// Grajenje hierarhije
//22 => array("name"=>$lang['srv_hierarchy_users'], "sum"=>0),// Urejanje uporabnikov
);
$action_type = $statuses;
$action_type_sum = $statuses;
}
else if($status == 0){
$statuses = array();
$action_type = array();
$action_type_sum = array();
}
//echo '<h2>'.$lang["srv_edits_analysis_editing_details"].'</h2>';
foreach ($data as $rowGrupa) {
//$post = $this->convertToJSON($rowGrupa['post']);
$akcija = null;
if($status == -1)
$akcija = $rowGrupa['status'];
else if($status == 0){
$get = $this->convertToJSON($rowGrupa['get']);
$akcija = $get['a'];
}
//zacetek risanja
if(!isset($user_temp)){
$user_temp = $rowGrupa['email'];
$user_id = $rowGrupa['id'];
//izpis zacetka tabele za prvega urejevalca (prvi dve vrstici z naslovi)
$tex .= $this->zacetekTabelePodrobnostiLatex($user_temp, $status, $user_id);
//izpis zacetka tabele za prvega urejevalca (prvi dve vrstici z naslovi) - konec
}
//naslednji editor
else if($user_temp != $rowGrupa['email']){
//Priprava podatkov za izpis vrstic tabele in izpis vrstic /////////////////////////////////////////////////////
$time_sum += (float) $this -> TimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type, $user_id.'_'.$row_id);
//Izpis posameznih vrstic
foreach($this->vrsticaTex as $vrstica){
$tex .= $vrstica;
}
//Izpis posameznih vrstic - konec
//izrisi se zadnjo vrstico prejsnjega urejevalca
//izpis vrstice podatkov za Skupaj
$tex .= $this -> echoTimeEditsFootRow($time_sum, $st_akcij_sum, $action_type_sum, $user_id.'_sum');
//izpis vrstice podatkov za Skupaj - konec
//izrisi se zadnjo vrstico prejsnjega urejevalca - konec
//Priprava podatkov za izpis vrstic tabele in izpis vrstic - konec /////////////////////////////////////////////
//zaljucek latex tabele s podatki za prvega urejevalca
$tex .= $this->konecTabelePodrobnostiLatex();
//zaljucek latex tabele s podatki za prvega urejevalca - konec
//prostor po tabeli
$tex .= $this->texBigSkip;
$tex .=$this->texNewLine;
//prostor po tabeli - konec
$sum_data[$user_temp]['time_sum']=$time_sum;
$sum_data[$user_temp]['st_akcij_sum']=$st_akcij_sum;
$sum_data[$user_temp]['st_seans_sum']=$st_seans_sum;
$sum_data[$user_temp]['user_id']=$user_id;
$action_type_sum = $statuses;
//nova tabela - nov urejevalec
$user_temp = $rowGrupa['email'];
$user_id = $rowGrupa['id'];
$this->vrsticaTex = array(); //resetiranje polja s kodo vrstic ostalih urejevalcev
//izpis zacetka tabele za naslednje urejevalce (prvi dve vrstici z naslovi)
$tex .= $this->zacetekTabelePodrobnostiLatex($user_temp, $status, $user_id);
//izpis zacetka tabele za naslednje urejevalce (prvi dve vrstici z naslovi) - konec
//ponastavi spremenljivke
$datetime_last = null;
$datetime_start = null;
$st_akcij = 0;
$st_akcij_sum = 0;
$st_seans_sum = 0;
$time_sum = 0;
}
//izpis vrstic
//nov start seanse
if(!isset($datetime_start)){
$datetime_start = new DateTime($rowGrupa['datetime']);
$st_akcij++;
$st_seans_sum++;
$action_type = $statuses;
}
//se ni druge akcije
else if(!isset($datetime_last)){
$temp_time = new DateTime($rowGrupa['datetime']);
$interval = $this->sea->calculateTimeBetweenActions($datetime_start, $temp_time);
//ce je akcija od starta v kriteriju seanse, jo dodaj k seansi
if($interval <= $seansa){
$datetime_last = clone $temp_time;
$st_akcij++;
}
//akcija je izven kriterija seanse, izpisi samo to akcijo
else{
$datetime_last = clone $datetime_start;
$datetime_last->add(new DateInterval('PT5S'));
$time_sum += (float) $this -> TimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type, $user_id.'_'.$row_id);
$st_akcij = 1;
$st_seans_sum++;
$datetime_start = clone $temp_time;
$datetime_last = null;
$action_type = $statuses;
}
}
//seasna ze ima vsaj dve akciji
else{
$temp_time = new DateTime($rowGrupa['datetime']);
$interval = $this->sea->calculateTimeBetweenActions($datetime_last, $temp_time);
//ce je akcija od prejsnje v kriteriju seanse, jo dodaj k seansi
if($interval <= $seansa){
$datetime_last = clone $temp_time;
$st_akcij++;
}
//akcija je izven kriterija seanse, izpisi vse prejsnje akcije
else{
$time_sum += (float) $this -> TimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type, $user_id.'_'.$row_id);
$st_akcij = 1;
$st_seans_sum++;
$datetime_start = clone $temp_time;
$datetime_last = null;
$action_type = $statuses;
}
}
$st_akcij_sum++;
$row_id++;
if($status == -1){
$action_type[$akcija]['sum'] ++;
$action_type_sum[$akcija]['sum'] ++;
}
else if($status == 0){
$action_type[$akcija] = isset($action_type[$akcija]) ? $action_type[$akcija]+1 : 1;
$action_type_sum[$akcija] = isset($action_type_sum[$akcija]) ? $action_type_sum[$akcija]+1 : 1;
}
}
//izrisi se zadnjo vrstico, ki jo ni foreach ter footer
if($datetime_last == null){
$datetime_last = clone $datetime_start;
$datetime_last->add(new DateInterval('PT5S'));
}
$time_sum += (float) $this -> TimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type, $user_id.'_'.$row_id);
//Izpis posameznih vrstic
foreach($this->vrsticaTex as $vrstica){
$tex .= $vrstica;
}
//Izpis posameznih vrstic - konec
$tex .= $this -> echoTimeEditsFootRow($time_sum, $st_akcij_sum, $action_type_sum, $user_id.'_sum');
//Priprava podatkov za izpis vrstic tabele in izpis vrstic - konec
//zaljucek latex tabele s podatki
$tex .= $this->konecTabelePodrobnostiLatex();
//zaljucek latex tabele s podatki - konec
$this->texTimeEdits = $tex;
//echo "tex: ".$tex."</br>";
$sum_data[$user_temp]['time_sum']=$time_sum;
$sum_data[$user_temp]['st_akcij_sum']=$st_akcij_sum;
$sum_data[$user_temp]['st_seans_sum']=$st_seans_sum;
$sum_data[$user_temp]['user_id']=$user_id;
/* echo "time_sum: ".$time_sum."</br>";
echo "st_akcij_sum: ".$st_akcij_sum."</br>";
echo "st_seans_sum: ".$st_seans_sum."</br>";
echo "user_id: ".$user_id."</br>";
echo "action_type_sum: ".$action_type_sum."</br>"; */
//echo '</table>';
return $sum_data;
}
/**
* Nastavi in izrise vrstico urejanja
*
* @param type $datetime_start - datetime start of editing
* @param type $datetime_last - datetime end of editing
* @param type $st_akcij - num ob actions during editing
* @param type $action_type - string of type of action
* @param type $row_id - int sequence nuber of row (unique, for this site, no need to be ID)
* @return type int - calculated second of editing session
*/
function TimeEditsRow($datetime_start=null, $datetime_last=null, $st_akcij=null, $action_type = null, $row_id = null){
$seconds = 0;
$tex = '';
//create string of actions type
$action_type_string = ($action_type != null) ? $this -> createActionsTypeString($action_type, $row_id) : null;
if(isset($datetime_last)){
$seconds = $this->sea->calculateTimeBetweenActions($datetime_start, $datetime_last);
$this->vrsticaTex[] = $this -> echoTimeEditsRow($datetime_last->format('Y-m-d H:i:s') .' - '. $datetime_start->format('Y-m-d H:i:s'), $this->sea->calculateTimeFromSeconds($seconds), $st_akcij, $action_type_string);
}
//ce je samo ena akcija
else{
$this->vrsticaTex[] = $this -> echoTimeEditsRow($datetime_start->format('Y-m-d H:i:s'), 0 ,1, $action_type_string);
}
return $seconds;
}
/**
* Convert false JSON (with keys without quotes and no stat and end braces)
* from DB to valid JSON
* @param type $toJSON string to convert to JSON (with keys without
* quotes and no stat and end braces)
* @return type valid converted JSON
*/
function convertToJSON($toJSON=''){
$toJSON = preg_replace('/("(.*?)"|(\w+))(\s*:\s*(".*?"|.))/s', '"$2$3"$4', $toJSON);
$toJSON = '{'.$toJSON.'}';
return json_decode($toJSON, true);
}
/**
* Izrise vrstico urejanja
* @param type $datetime - string from to editing
* @param type $cas_seanse - editing time
* @param type $st_akcij - num of editing actions
* @param type $action_type - string of type of action
*/
function echoTimeEditsRow($datetime=null, $cas_seanse=null, $st_akcij=null, $action_type = null){
$tex = '';
$latexVrstica = array();
//casovni razpon urejanja
$latexVrstica[] = LatexDocument::encodeText($datetime);
//cas urejanja
$latexVrstica[] = LatexDocument::encodeText($cas_seanse);
//stevilo akcij
$latexVrstica[] = LatexDocument::encodeText($st_akcij);
if($action_type != null){
//vrsta akcij
$latexVrstica[] = LatexDocument::encodeText($action_type.' ');
}
$tex .= $this->tableRow($latexVrstica);
//echo $tex;
return $tex;
}
/**
* Create/convert array of action types to string for table cell
* @param type $action_type - array of action types
* @param type $row_id - int sequence nuber of row (unique user int and row in table)
* @return string - converter array to string to put it in table cell
*/
function createActionsTypeString($action_type=array(), $row_id=null){
$action_type_string = '';
//urejanje - ali drug specificen status
if(!isset($action_type[0]['sum'])){
global $lang;
$i = 0;
foreach ($action_type as $key => $at){
/* if($i == 3)
$action_type_string .= '<div class="srv_edits_analysis_'.$row_id.' as_link" onclick="$(\'.srv_edits_analysis_'.$row_id.'\').toggle();">'.$lang['srv_more'].'</div>';
if($i < 3)
$action_type_string .= '<div>'.$key.' ('.$at.')'.'</div>';
else
$action_type_string .= '<div class="srv_edits_analysis_'.$row_id.' displayNone">'.$key.' ('.$at.')'.'</div>';
$i++; */
$action_type_string .= $key.' ('.$at.')'.'; ';
}
/* if($i > 3)
$action_type_string .= '<div class="srv_edits_analysis_'.$row_id.' as_link displayNone" onclick="$(\'.srv_edits_analysis_'.$row_id.'\').toggle();">'.$lang['srv_less'].'</div>'; */
}
//vsi statusi
else{
foreach ($action_type as $at){
if($at['sum'] > 0){
if($action_type_string != '')
$action_type_string .= ' ';
$action_type_string .= $at['name'].' ('.$at['sum'].')';
}
}
}
return $action_type_string;
}
/**
* Izrise total/footer vrstico urejanja
* @param type $time - seconds of editing
* @param type $st_akcij - num of editing actions
* @param type $action_type - string of type of actions
* @param type $row_id - int sequence nuber of user (unique, for this site, no need to be ID)
*/
function echoTimeEditsFootRow($time=null, $st_akcij=null, $action_type = null, $row_id = 0){
global $lang;
$tex = '';
$vrsticaPodatkovSkupaj = array();
//casovni razpon urejanja
$vrsticaPodatkovSkupaj[] = $this->returnBold(LatexDocument::encodeText($lang['srv_edits_analysis_time_total']));
//cas urejanja
$vrsticaPodatkovSkupaj[] = $this->returnBold($this->sea->calculateTimeFromSeconds($time));
//stevilo akcij
$vrsticaPodatkovSkupaj[] = $this->returnBold($st_akcij);
if($action_type != null){
//vrsta akcij
$vrsticaPodatkovSkupaj[] = $this->returnBold(LatexDocument::encodeText($this->createActionsTypeString($action_type, $row_id)));
}
$tex .= $this->tableRow($vrsticaPodatkovSkupaj); //Izpis vrstic tabele s podatki o sumi
return $tex;
}
function zacetekTabelePodrobnostiLatex($user_temp=null, $status=null, $user_id=null){
global $lang;
$tex = '';
//Priprava parametrov za tabelo s podatki o anketi
$steviloStolpcevParameterTabular = 4;
$steviloOstalihStolpcev = $steviloStolpcevParameterTabular - 1; /*stevilo stolpcev brez prvega stolpca, ki ima fiksno sirino*/
$sirinaOstalihStolpcev = 0.9/$steviloOstalihStolpcev;
$parameterTabular = '';
$export_format = 'pdf';
$parameterTabular = '|';
for($i = 0; $i < $steviloStolpcevParameterTabular; $i++){
/* if($i == 0){
$parameterTabular .= ($export_format == 'pdf' ? '>{\hsize=.3\hsize}X' : 'l'); //fiksna sirina prvega stolpca, da sprejme datum in uro
}else{
$parameterTabular .= ($export_format == 'pdf' ? 'X' : 'l');
} */
$parameterTabular .= ($export_format == 'pdf' ? 'C|' : 'c|');
}
$pdfTable = 'tabularx';
$rtfTable = 'tabular';
$pdfTableWidth = 1;
$rtfTableWidth = 1;
$tex .= $this->StartLatexTable($export_format, $parameterTabular, $pdfTable, $rtfTable, $pdfTableWidth, $rtfTableWidth);
//Priprava parametrov za tabelo s podatki o anketi - konec
//Priprava podatkov za izpis vrstic tabele in izpis vrstic
if($export_format != 'xls'){
$tex .= $this->horizontalLineTex;
}
$prvaVrstica = array();
$prvaVrstica[] = ' \multicolumn{'.$steviloStolpcevParameterTabular.'}{|c|}{ '.$user_temp.' }';
$tex .= $this->tableRow($prvaVrstica);
$drugaVrstica = array();
$drugaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_time_span']);
$drugaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_time_time']);
$drugaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_time_actions']);
if($status < 1){
$drugaVrstica[] = LatexDocument::encodeText($lang['srv_edits_analysis_action_type']);
}else{
$drugaVrstica[] = '';
}
$tex .= $this->tableRow($drugaVrstica);
return $tex;
}
function konecTabelePodrobnostiLatex(){
$tex = "\\end{tabularx}";
return $tex;
}
#funkcija, ki skrbi za pridobitev imena slike, ki jo je potrebno izrisati ######################################
function getImageName($text='', $sprId=null, $findme='', $vre_id=0, $img_id=0){
global $site_path, $site_url;
$imageName = '';
self::$spremenljivka = $sprId;
if($text == 'hotspot' && $findme == 'hotspot_image='){
$sqlParametrov = sisplet_query("SELECT params FROM srv_spremenljivka WHERE id='".$sprId."'");
$rowParametrov = mysqli_fetch_row($sqlParametrov);
$text = $rowParametrov[0];
}
$pos = strpos($text, $findme); //najdi pozicijo teksta v $findme
//echo "text za echo: ".$text."</br>";
//if($pos!=''){ //ce je slika v bazi
if($pos!=''||$pos==0){ //ce je slika v bazi
$imageName = substr($text,$pos); //pokazi le del text od besedila $findme dalje (vkljucno z besedilom)
//echo "imageName prej: ".$imageName."</br>";
//$findme = $site_path.'uploadi/editor/';
$findme = $site_url.'uploadi/editor/';
//$findme = 'uploadi/editor/';
//$findme = 'editor/';
//echo "findme: ".$findme."</br>";
$pos = strpos($imageName, $findme); //najdi pozicijo teksta v $findme
//echo "najdi tole: ".$findme."</br>";
//echo "najdi tukaj: ".$imageName."</br>";
//echo "pozicija tega: ".$pos."</br>";
if($pos){ //ce je slika na strezniku
$slikaNaStrezniku = 1;
}else{//ce slike ni na strezniku
$slikaNaStrezniku = 0;
}
//echo "ali je slika na strežniku: ".$slikaNaStrezniku."</br>";
if($slikaNaStrezniku==1){ //ce je slika na strezniku
$findEditor = 'editor/';
$posEditor = strpos($imageName, $findEditor); //najdi pozicijo teksta v $findEditor
$imageName = substr($imageName,$posEditor+7); //pokazi le del params od besedila 'editor/' dalje, brez besedila 'editor/'
//echo "imagename : ".$imageName."</br>";
$pos = $this->getEndPosition($imageName); //najdi pozicijo konca URL slike
$imageExtension = substr($imageName, $pos-3, 3); //pridobi koncnico slike (za gif je potrebno sliko pretvoriti v png, saj latex ne podpira gif)
$imageName = substr($imageName, 0, $pos); //pokazi le del params od zacetka besedila do '"' oz. konca URL slike
$path = $site_path.'uploadi/editor/'.$imageName;
//$path = $site_url.'uploadi/editor/'.$imageName;
if($imageExtension == 'gif'){ //ce je slika gif, jo je potrebno pretvoriti v png
$this->convertGifToPng($path, $slikaNaStrezniku);
}
if($imageExtension == 'jpg' || $imageExtension == 'peg'){ //ce je slika jpg ali jpeg, jo je potrebno pretvoriti v png
$this->convertJpgToPng($path, $slikaNaStrezniku, $imageExtension);
}
}elseif($slikaNaStrezniku==0){ //ce slike ni na strezniku
//echo "vre_id: $vre_id </br>";
$imageName = $this->getOnlineImageName($imageName, $slikaNaStrezniku, $vre_id, $img_id); //pridobi njen URL
}
$imageName = substr($imageName, 0, strrpos($imageName, '.'));
}
//echo "imagename pred return: ".$imageName."</br>";
return $imageName;
}
#funkcija, ki skrbi za pridobitev imena slike, ki jo je potrebno izrisati - konec ###############################
function getEndPosition($imageName=''){
$findme = '"';
$pos = strpos($imageName, $findme); //najdi pozicijo teksta '"'
return $pos;
}
function convertGifToPng($path='', $slikaNaStrezniku=null){
//echo "path: ".$path."</br>";
$image = imagecreatefromgif($path); //pripravi sliko iz gif za pretvorbo
$imageName = substr($path, 0, -3); //ime slike brez extension-a
//echo $imageName."</br>";
$imageNamePNG = $imageName.'png'; //ime slike z ustreznim extension
imagepng($image, $imageNamePNG); //pretvori pripravljeno gif sliko v png
if($slikaNaStrezniku==0){ //ce slika je iz URL in ni na strezniku, GIF izbrisi
unlink($imageName.'gif'); //izbrisi gif sliko
}
}
function convertJpgToPng($path='', $slikaNaStrezniku=null, $imageExtension=''){
$image = imagecreatefromjpeg($path); //pripravi sliko iz jpg za pretvorbo
$imageName = substr($path, 0, strrpos($path, '.')); //ime slike brez extension-a
//echo $imageName."</br>";
$imageNamePNG = $imageName.'.png'; //ime slike z ustreznim extension
imagepng($image, $imageNamePNG); //pretvori pripravljeno jpg sliko v png
//echo "pretvorba v png: ".$imageNamePNG."</br>";
//echo "xtens: ".$imageExtension."</br>";
//$origExtension = strrchr($path, '.');
//echo "ali je slika na strežniku: ".$slikaNaStrezniku."</br>";
if($slikaNaStrezniku==0){ //ce slika je iz URL in ni na strezniku, izbrisi jo
//echo "tukaj </br>";
if($imageExtension == 'jpg'){
unlink($imageName.'.'.$imageExtension); //izbrisi sliko
}elseif($imageExtension == 'peg'){
unlink($imageName.'.j'.$imageExtension); //izbrisi sliko
}
}
}
#funkcija, ki skrbi za pridobitev slike, ki se nahaja nekje online in jo je potrebno izrisati, in vrne lokalno ime slike ######################################
function getOnlineImageName($imageName='', $slikaNaStrezniku=null, $vre_id=null, $img_id=0){
global $site_path;
//echo "imageName v getOnlineImageName nekje vmes 1: ".$imageName."</br>";
$row = Cache::srv_spremenljivka(self::$spremenljivka);
//echo "sprem: ".self::$spremenljivka."</br>";
$spremenljivkaParams = new enkaParameters($row['params']);
//echo "params: ".$spremenljivkaParams->get('hotspot_image')."</br>";
$imageNameTmp = $spremenljivkaParams->get('hotspot_image');
//if($imageNameTmp!=''){ //ce je hotspot
if($imageNameTmp!=''&&$vre_id==0){ //ce je hotspot
$imageName = $imageNameTmp;
}
$findHttp = 'http';
$posHttp = strpos($imageName, $findHttp);
$imageName = substr($imageName,$posHttp); //besedilo do zacetka http
$pos = $this->getEndPosition($imageName); //najdi pozicijo konca URL slike
$imageName = substr($imageName, 0, $pos); //pokazi le del params od zacetka besedila do '"' oz. konca URL slike
//echo "imageName v getOnlineImageName nekje vmes 2: ".$imageName."</br>";
$imageExtension = substr($imageName, $pos-3, 3); //pridobi koncnico slike
//echo "imageExtension: ".$imageExtension."</br>";
//if($imageExtension!='jpg'&&$imageExtension!='png'&&$imageExtension!='gif'&&$imageExtension!='jpeg'){ //ce ni veljavnen extension, spremeni ga v png
if($imageExtension=='jpg'||$imageExtension=='gif'||$imageExtension=='jpeg'){ //ce ni veljavnen extension, spremeni ga v png
//echo "spremeni extension </br>";
$imageExtension='png';
}
if($vre_id){ //ce se pridobiva imena tmp slik iz vrednosti vprasanja
//$imgFilename = self::$spremenljivka.'_'.$vre_id.'_tmpImage.'.$imageExtension; //tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
$imgFilename = self::$spremenljivka.'_'.$vre_id.'_tmpImage_'.$img_id.'.'.$imageExtension; //tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
}else{
//$imgFilename = self::$spremenljivka.'_tmpImage.'.$imageExtension; //tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
$imgFilename = self::$spremenljivka.'_tmpImage_'.$img_id.'.'.$imageExtension; //tmp ime slike, ki je sestavljeno iz id spremenljivke+tmpImage+extension
}
$pathDir = $site_path.'uploadi/editor/'; //pot za novo mapo, kjer se bodo shranjevale slike za trenutno anketo
$path = $pathDir.$imgFilename; //pot do datoteke z imenom datoteke
# ukaz za pretakanje slike
if(IS_WINDOWS){
//za windows sisteme //powershell -command "& { iwr URL -OutFile 'PATH' }"
$command = 'powershell -command "& { iwr \''.$imageName.'\' -OutFile \''.$path.'\' }"';
//$command = 'wget -O \''.$imageName.'\' -O '.$path.' ';
}elseif(IS_LINUX){
//za linux sisteme //exec('wget URL -P PATH ');
//$command = 'wget \''.$imageName.'\' -P '.$path.' ';
$command = 'wget -O '.$path.' \''.$imageName.'\' ';
//echo "ukaz za pobiranje: $command </br>";
}
//echo "command: ".$command."</br>";
exec($command); //pretoci sliko
//$path = $pathDir.$imgFilename; //pot do datoteke z imenom datoteke
/* if($imageExtension == 'gif'){ //ce je slika gif, jo je potrebno pretvoriti v png, saj latex ne podpira gif
$this->convertGifToPng($path, $slikaNaStrezniku);
} */
//echo "imgfilename na koncu: ".$imgFilename."</br>";
if($imageExtension != 'png'){ //ce slika ni png, jo pretvori
if($imageExtension == 'gif'){ //ce je slika gif, jo je potrebno pretvoriti v png, saj latex ne podpira gif
$this->convertGifToPng($path, $slikaNaStrezniku);
}else{
$this->convertJpgToPng($path, $slikaNaStrezniku, $imageExtension);
}
}
//echo "imgfilename na koncu: ".$imgFilename."</br>";
return $imgFilename;
}
#funkcija, ki skrbi za pridobitev slike, ki se nahaja nekje online in jo je potrebno izrisati, in vrne lokalno ime slike - konec ###############################
function coloredTextLatex($color='', $text=''){
$coloredText = '';
$coloredText .= '\textcolor{'.$color.'}{'.$text.'}';
return $coloredText;
}
}
?>
