diff options
Diffstat (limited to 'admin/survey/classes/surveyAnalysis/class.SurveyEditsAnalysis.php')
| -rw-r--r-- | admin/survey/classes/surveyAnalysis/class.SurveyEditsAnalysis.php | 984 |
1 files changed, 984 insertions, 0 deletions
diff --git a/admin/survey/classes/surveyAnalysis/class.SurveyEditsAnalysis.php b/admin/survey/classes/surveyAnalysis/class.SurveyEditsAnalysis.php new file mode 100644 index 0000000..b1b7b5f --- /dev/null +++ b/admin/survey/classes/surveyAnalysis/class.SurveyEditsAnalysis.php @@ -0,0 +1,984 @@ +<?php
+/**
+ * Analize urejanja
+ *
+ * Author: Uroš Podkrižnik
+ * Created: 14.4.2017
+ */
+
+define('GRAPH_REDUCE', '1.22'); # količnik za koliko zmanjšamo širino grafa da ne prebije
+
+class SurveyEditsAnalysis{
+
+ private $anketa; # id ankete
+ private $db_table; # katere tabele uporabljamo
+
+
+ function __construct($anketa){
+ if ((int)$anketa > 0){
+
+ $this->anketa = $anketa;
+
+ # polovimo vrsto tabel (aktivne / neaktivne)
+ SurveyInfo :: getInstance()->SurveyInit($this->anketa);
+ if (SurveyInfo::getInstance()->getSurveyColumn('db_table') == 1) {
+ $this->db_table = '_active';
+ }
+ }
+ else {
+ echo 'Invalid Survey ID!';
+ exit();
+ }
+ }
+
+
+ function displayTable(){
+ global $lang;
+
+ // Legenda statusov
+ $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
+ );
+
+ //se ponovi v funkciji ajax_drawContinuEditsTable
+ if ($_GET['seansa'] > 0)
+ $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 = '';
+
+ echo '<form id="diagnostics_form" action="index.php" method="get">';
+
+ echo '<input type="hidden" name="a" value="edits_analysis" />';
+ echo '<input type="hidden" name="anketa" value="'.$this->anketa.'" />';
+
+ echo ''.$lang['srv_edits_analysis_seansa'].' <select name="seansa" onchange="this.form.submit();">';
+ echo '<option value="5"' . ($seansa == '5' ? ' selected' : '') . '>'.$lang['srv_edits_analysis_seansa_5min'].'</option>';
+ echo '<option value="10"' . ($seansa == '10' ? ' selected' : '') . '>'.$lang['srv_edits_analysis_seansa_10min'].'</option>';
+ echo '<option value="30"' . ($seansa == '30' ? ' selected' : '') . '>'.$lang['srv_edits_analysis_seansa_30min'].'</option>';
+ echo '<option value="60"' . ($seansa == '60' ? ' selected' : '') . '>'.$lang['srv_edits_analysis_seansa_1h'].'</option>';
+ echo '</select> ';
+
+ echo ''.$lang['status'].' <select name="status" id="edits_analysis_status" onchange="this.form.submit();">';
+ echo '<option value="-1"' . ($status == -1 ? ' selected' : '') . '>'.$statuses[-1].'</option>';
+ echo '<option value="0"' . ($status == 0 ? ' selected' : '') . '>'.$statuses[0].'</option>';
+ echo '<option value="1"' . ($status == 1 ? ' selected' : '') . '>'.$statuses[1].'</option>';
+ echo '<option value="2"' . ($status == 2 ? ' selected' : '') . '>'.$statuses[2].'</option>';
+ echo '<option value="3"' . ($status == 3 ? ' selected' : '') . '>'.$statuses[3].'</option>';
+ echo '<option value="4"' . ($status == 4 ? ' selected' : '') . '>'.$statuses[4].'</option>';
+ echo '<option value="5"' . ($status == 5 ? ' selected' : '') . '>'.$statuses[5].'</option>';
+ /*echo '<option value="20"' . ($status == 20 ? ' selected' : '') . '>'.$statuses[20].'</option>';
+ echo '<option value="21"' . ($status == 21 ? ' selected' : '') . '>'.$statuses[21].'</option>';
+ echo '<option value="22"' . ($status == 22 ? ' selected' : '') . '>'.$statuses[22].'</option>';*/
+ echo '</select> '.$lang['srv_diagnostics_in'].' ';
+
+ echo '<select id="diagnostics_date_selected" name="time" onchange="diagnosticsChooseDate();">';
+ /*echo '<option value="10 minute"' . ($time == '10 minute' ? ' selected' : '') . '>'.$lang['srv_diagnostics_10 minute'].'</option>';
+ echo '<option value="30 minute"' . ($time == '30 minute' ? ' selected' : '') . '>'.$lang['srv_diagnostics_30 minute'].'</option>';*/
+ echo '<option value="lifetime"' . ($time == 'lifetime' ? ' selected' : '') . '>'.$lang['srv_edits_analysis_period_lifetime'].'</option>';
+ echo '<option value="1 hour"' . ($time == '1 hour' ? ' selected' : '') . '>'.$lang['srv_diagnostics_1 hour'].'</option>';
+ echo '<option value="6 hour"' . ($time == '6 hour' ? ' selected' : '') . '>'.$lang['srv_diagnostics_6 hour'].'</option>';
+ echo '<option value="12 hour"' . ($time == '12 hour' ? ' selected' : '') . '>'.$lang['srv_diagnostics_12 hour'].'</option>';
+ echo '<option value="1 day"' . ($time == '1 day' ? ' selected' : '') . '>'.$lang['srv_diagnostics_1 day'].'</option>';
+ echo '<option value="2 day"' . ($time == '2 day' ? ' selected' : '') . '>'.$lang['srv_diagnostics_2 day'].'</option>';
+ echo '<option value="5 day"' . ($time == '5 day' ? ' selected' : '') . '>'.$lang['srv_diagnostics_5 day'].'</option>';
+ echo '<option value="7 day"' . ($time == '7 day' ? ' selected' : '') . '>'.$lang['srv_diagnostics_7 day'].'</option>';
+ echo '<option value="14 day"' . ($time == '14 day' ? ' selected' : '') . '>'.$lang['srv_diagnostics_14 day'].'</option>';
+ echo '<option value="1 month"' . ($time == '1 month' ? ' selected' : '') . '>'.$lang['srv_diagnostics_1 month'].'</option>';
+ echo '<option value="3 month"' . ($time == '3 month' ? ' selected' : '') . '>'.$lang['srv_diagnostics_3 month'].'</option>';
+ echo '<option value="6 month"' . ($time == '6 month' ? ' selected' : '') . '>'.$lang['srv_diagnostics_6 month'].'</option>';
+ echo '<option id="option_99date" value="99date"' . ($time == '99date' ? ' selected' : '') . '>'.$lang['srv_diagnostics_choose_date'].'</option>';
+ echo '</select> ';
+
+ // Datum - od
+ echo ''.$lang['srv_diagnostics_orfrom'].' <input type="text" id="from" name="from" value="' . $from . '" '. ($time != '99date' ? ' disabled' : '') .' />';
+ echo ' <span class="faicon calendar_icon icon-as_link" onclick="changeSelectOption()" id="from_img"></span>';
+
+ // Datum - do
+ echo ' '.$lang['srv_diagnostics_to'].' <input type="text" id="to" name="to" value="' . $to . '" '. ($time != '99date' ? ' disabled' : '') .'/>';
+ echo ' <span class="faicon calendar_icon icon-as_link" onclick="changeSelectOption()" id="to_img"></span>';
+
+ echo '<input type="submit" class="spaceLeft pointer" value="'.$lang['hour_show'].'" />';
+
+ echo '</form><div>';
+
+ //create iterval - SQL where statement
+ $interval = $this->createInterval($time, $from, $to);
+ //get object of all edits data
+ $data = $this->getData($status, $interval);
+
+ if(sizeof($data) == 0)
+ $this->echoNoData();
+ else{
+ echo '<div id="edits_analysis_time_tables">';
+ echo '<div>';
+ $sum_data = $this->drawTimeEdits($data['timeEdits'], $seansa*60, $status);
+ echo '</div>';
+ $this->GraphData($this->graphQuery($status, $interval));
+ echo '</div>';
+
+ echo '<table class="dashboard" id="edits_analysis_info">';
+ echo '<tr>';
+
+ //draw edits counter and sums of editors
+ $this->drawCountEdits($sum_data);
+
+ //draw continuous editing box
+ $continu_data = $this->continuEditsQuery($status, $interval);
+ $this->drawContinuEdits($continu_data, $sum_data);
+
+ echo '</tr>';
+ echo '</table>';
+
+ //prestavi vse tabele na konec, da bo info na vrhu
+ echo'<script>var myElement = document.getElementById("edits_analysis_time_tables");'
+ . 'myElement.parentNode.appendChild(myElement);</script>';
+
+
+ }
+ echo '</div>';
+ }
+
+ function GraphData($data){
+ global $lang, $site_url;
+
+ //error_log(json_encode($data));
+ //$DataSetJson = json_decode('{"Data":[{"Vrednosti":5,"Vrednosti2":2,"Name":0,"Variable":"0-1000"},{"Vrednosti":20,"Vrednosti2":15,"Name":1,"Variable":"1001-5000"},{"Vrednosti":20,"Vrednosti2":20,"Name":2,"Variable":"5001-10000"},{"Vrednosti":0,"Vrednosti2":8,"Name":3,"Variable":"10001-50000"}],'
+ // . '"DataDescription":{"Position":"Variable","Format":{"X":"number","Y":"number"},"Unit":{"X":null,"Y":null},"Values":["Vrednosti", "Vrednosti2"],"Description":{"Vrednosti":"prvi-prvi-prvi-prvi-prvi", "Vrednosti2":"drugi-drugi-drugi-drugi-drugi"}},"numerus":45,"average":4721,"Other":[]}');
+
+ //polnimo podatke
+ $DataSet = new pData;
+
+ $vrednosti = array();
+ $vrednostiVariable = array();
+ $avg_count = 0;
+ $avg_sum = 0;
+
+ /*foreach ($DataSetJson->Data as $value){
+ $vrednosti[] = $value->Vrednosti;
+ $vrednosti2[] = $value->Vrednosti2;
+ $avg_sum+=$value->Vrednosti;
+ $vrednostiVariable[] = $value->Variable;
+ $avg_count++;
+ }*/
+
+ $start_date = new DateTime($data['first_date']);
+ $temp_date = $start_date;
+ $end_date = new DateTime($data['last_date']);
+
+ $diff = $this->differDateTimeInDays($start_date, $end_date);
+ $DayFormat = '';
+ $DayIncrease = 'month';
+ if($diff < 32){
+ $DayFormat = '-d';
+ $DayIncrease = 'day';
+ }
+ else
+ $temp_date->setDate($start_date->format('Y'), $start_date->format('m'), 1);
+
+ while ($temp_date <= $end_date){
+ foreach($data['edits'] as $user=>$value){
+ $datestring = $temp_date->format('Y-m'.$DayFormat);
+ $cnt = isset($value[$datestring]) ? $value[$datestring] : 0;
+ $vrednosti[$user][] = $cnt;
+
+ $avg_sum+=$cnt;
+ }
+
+ $vrednostiVariable[] = $datestring;
+ $avg_count++;
+ $temp_date->modify('+1 '.$DayIncrease);
+ }
+
+ foreach($data['edits'] as $user=>$value){
+ $DataSet->AddPoint($vrednosti[$user],$user);
+ $DataSet->AddSerie($user);
+ $DataSet->SetSerieName($user,$user);
+ }
+
+ // nastavimo NUMERUS, ki se izpise pod legendo
+ $numerus = $avg_sum;
+ $DataSet->SetNumerus($numerus);
+
+ // nastavimo POVPRECJE
+ $avg = ($avg_count > 0) ? $avg_sum / $avg_count : 0;
+ $DataSet->SetAverage(round($avg, 1));
+
+
+ $DataSet->AddPoint($vrednostiVariable,"Variable");
+
+ $DataSet->SetAbsciseLabelSerie("Variable");
+ //$DataSet->SetYAxisUnit("null");
+ $DataSet->SetYAxisFormat("number");
+
+ $Cache = new pCache(dirname(__FILE__).'/../../pChart/Cache/');
+ $ID = self::generateChartId($DataSet->GetNumerus());
+
+ echo '<div style="margin-top:-2.5em;">';
+ echo '<div class="chart_holder" style="margin: auto !important; width: auto !important;" id="chart_edits_'.$this->anketa.'">';
+ echo '<div class="chart_title" style="width: auto !important">'. $lang['srv_edits_analysis_graph'];
+ echo '<span class="numerus">';
+ echo '(n = '.$DataSet->GetNumerus().')';
+ echo '</span>';
+ echo '</div>';
+
+ if(!$Cache->isInCache($ID, $DataSet->GetData())){
+ $graph = SurveyChart::createLine($DataSet, null, 1);
+ $Cache->WriteToCache($ID,$DataSet->GetData(),$graph);
+ }
+
+ // dobimo ime slike c cache-u
+ $imgName = $Cache->GetHash($ID,$DataSet->GetData());
+ $imgPath = 'pChart/Cache/'.$imgName;
+
+ $imgUrl = $site_url . 'admin/survey/' . $imgPath;
+
+ echo '<div class="chart_img" style="float: none !important" title="'.$lang['srv_edits_analysis_graph'].'">';
+ // dodamo timestamp ker browser shrani sliko v cache in jo v dolocenih primerih ajaxa ne refresha
+ echo '<img src="'.$imgUrl.'?'.time().'" />';
+ echo '</div></div></div>';
+ }
+
+ /**
+ * Run querry for action times
+ * @param type $status - int of status
+ * @param type $interval - where clause for time interval
+ * @return type array of results from DB
+ */
+ function graphQuery($status, $interval){
+ $sql2 = "SELECT min(DATE_FORMAT(st.datetime, '%Y-%m-%d')) as first_date, max(DATE_FORMAT(st.datetime, '%Y-%m-%d')) as last_date"
+ . " FROM srv_tracking$this->db_table st, users u WHERE st.ank_id='$this->anketa' AND u.id = st.user ".
+ ($status != -1 ? "AND st.status=$status " : "") ."$interval ";
+ $output2=sisplet_query($sql2, 'obj');
+
+ $diff = $this->differDateTimeInDays(new DateTime($output2->first_date), new DateTime($output2->last_date));
+ $queryDayFormat = '';
+ $queryDayGroup = '';
+ if($diff < 32){
+ $queryDayFormat = '-%d';
+ $queryDayGroup = ', DAY(st.datetime)';
+ }
+
+ $sql = "SELECT count(*) as cnt, u.email, u.id, DATE_FORMAT(st.datetime, '%Y-%m$queryDayFormat') as date"
+ . " FROM srv_tracking$this->db_table st, users u WHERE st.ank_id='$this->anketa' AND u.id = st.user ".
+ ($status != -1 ? "AND st.status=$status " : "") ."$interval "
+ . "GROUP BY u.email, YEAR(st.datetime), MONTH(st.datetime)$queryDayGroup "
+ . "ORDER BY u.email, date ASC";
+ $output=sisplet_query($sql, 'array');
+
+ $data = array('edits'=>array(), 'first_date'=>$output2->first_date, 'last_date'=>$output2->last_date);
+ foreach($output as $row){
+ $data['edits'][$row['email']][$row['date']]=$row['cnt'];
+ }
+ return $data;
+ }
+
+ private function differDateTimeInDays($start_date, $end_date){
+ return $end_date->diff($start_date)->format("%a");
+ }
+
+ // Zgeneriramo ID grafa za hash
+ private function generateChartId($numerus){
+ $ID = $this->anketa.'_chart_'.$numerus.'edits_analysis';
+ return $ID;
+ }
+
+ /**
+ * Get data to show in table
+ *
+ * @param type $status - status or type of edits
+ * @param type $interval - where statement including interval for SQL
+ * @return type
+ */
+ function getData($status, $interval){
+ $data = array();
+
+ $data_temp = $this->timeEditsQuery($status, $interval);
+
+ if(sizeof($data_temp) == 0)
+ return array();
+ else
+ $data['timeEdits'] = $data_temp;
+
+ return $data;
+ }
+
+ /**
+ * Create interval for SQL query from criteria
+ *
+ * @param type $time - time selected from dropdown
+ * @param type $from - from calendat
+ * @param type $to - to calendar
+ * @return type - string WHERE statement
+ */
+ function createInterval($time, $from, $to){
+ if($time == 'lifetime' || ($time == '99date' && $from == '' && $to == ''))
+ $interval = "";
+ else if ($from == '' && $to == '')
+ $interval = "AND st.datetime > NOW() - INTERVAL $time";
+ else if ($to == '')
+ $interval = "AND '$from' <= st.datetime";
+ else if ($from == '')
+ $interval = "AND st.datetime <= '$to'";
+ else
+ $interval = "AND '$from' <= st.datetime AND st.datetime <= '$to'";
+
+ return $interval;
+ }
+
+ /**
+ * Run querry for action times
+ * @param type $status - int of status
+ * @param type $interval - where clause for time interval
+ * @return type array of results from DB
+ */
+ function timeEditsQuery($status, $interval){
+ $sql = "SELECT u.email, u.id, st.datetime". ($status == 0 ? ", st.get, st.post" : "") . ($status == -1 ? ", st.status" : "")
+ . " FROM srv_tracking$this->db_table st, users u WHERE st.ank_id='$this->anketa' AND u.id = st.user ".
+ ($status != -1 ? "AND st.status=$status " : "") ."$interval ORDER BY u.email, st.datetime DESC";
+ return sisplet_query($sql, 'array');
+ }
+
+ /**
+ * Draw box of number of edit actions
+ * @global type $lang
+ * @param type $data - object data of sums
+ */
+ function drawCountEdits($data){
+ global $lang;
+
+ echo '<td>';
+ $sum_akcij = 0;
+ $sum_time = 0;
+ $sum_seans = 0;
+
+ echo '<div class="dashboard_cell" name="div_edits_analysis_counter" id="div_edits_analysis_counter" >'."\n";
+ echo '<span class="floatLeft dashboard_title">'.$lang['srv_edits_analysis_counter'];
+ echo '</span>';
+
+ echo '<br class="clr"/><br/>';
+
+ echo '<span class="dashboard_status_span">' . $lang['srv_edits_analysis_counter_editors'] .' :</span>' . sizeof($data).'<br/><br/>';
+ echo '<table id="tbl_answ_state">';
+ echo '<tr class="anl_dash_bb "><th><strong>'.$lang['srv_edits_analysis_counter_editor'].'</strong></th>'
+ . '<td><strong>'.$lang['srv_edits_analysis_time_time'].'</strong></td>'
+ . '<td><strong>'.$lang['srv_edits_analysis_num_sessions'].'</strong></td>'
+ . '<td><strong>'.$lang['srv_edits_analysis_time_actions'].'</strong></td></tr>';
+
+ foreach ($data as $key => $value) {
+ $this->echoCountEditsRow($key, $this->calculateTimeFromSeconds($value['time_sum']), $value['st_akcij_sum'], $value['st_seans_sum'], $value['user_id']);
+ $sum_akcij += $value['st_akcij_sum'];
+ $sum_time += $value['time_sum'];
+ $sum_seans += $value['st_seans_sum'];
+ }
+
+ // vsota vlejavnih
+ $this->echoCounterEditsFootRow($sum_time, $sum_akcij, $sum_seans);
+ echo '</table>';
+ echo '</div>';
+ echo '</td>';
+ }
+
+ /**
+ * Run querry for continuous editing
+ * @param type $status - int of status
+ * @param type $interval - where clause for time interval
+ * @param type $interval_criteria - criteria for interval - continued 'day' or 'hour'
+ * @return type array of results from DB
+ */
+ function continuEditsQuery($status, $interval, $interval_criteria = 'day', $user_criteria = 'all'){
+ $interval_criteria = ($interval_criteria == 'day') ? '' : ' %H';
+
+ $sqlString = "SELECT DATE_FORMAT(st.datetime, '%Y-%m-%d$interval_criteria') AS formatdate, count(*) as cnt FROM srv_tracking$this->db_table st WHERE ank_id = '$this->anketa' ".
+ ($status != -1 ? "AND st.status=$status " : "")."".
+ ($user_criteria != 'all' ? "AND st.user=$user_criteria " : "")."$interval GROUP BY formatdate ORDER BY formatdate desc";
+
+ return sisplet_query($sqlString, 'array');
+ }
+
+ /**
+ * Draw box of continuous editing
+ * @global type $lang
+ * @param type $data - object data of continued editing
+ * @param type $sum_data - object data of sums
+ * @param type $interval_criteria - criteria for interval - continued 'day' or 'hour'
+ */
+ function drawContinuEdits($data, $sum_data, $interval_criteria = 'day'){
+ global $lang;
+
+ echo '<td>';
+ echo '<div class="dashboard_cell" name="div_edits_analysis_countinu" id="div_edits_analysis_countinu" >'."\n";
+ echo '<span class="floatLeft dashboard_title">'.$lang['srv_edits_analysis_countinu'];
+ echo '</span>';
+
+ echo '<br class="clr"/><br/>';
+
+ //user/s
+ echo '<span id="span_timelineDropDownType">';
+ echo $lang['srv_edits_analysis_counter_editor'].': ';
+ echo '<select id="edits_analysis_continu_user" name="edits_analysis_continu_user" onchange="editsAnalysisContinuousEditing();">';
+ echo '<option value="all" selected>'.$lang['srv_edits_analysis_counter_all'].'</option>';
+ foreach ($sum_data as $email => $row) {
+ echo '<option value="'.$row['user_id'].'">'.$email.'</option>';
+ }
+ echo '</select> ';
+ echo '</span>';
+
+ // Oblika
+ echo '<span>';
+ echo '<label>'.$lang['srv_statistic_period'].'</label>:'."\n";
+ echo '<select id="edits_analysis_continu_period" name="edits_analysis_continu_period" size="1" autocomplete="off" onchange="editsAnalysisContinuousEditing();">'."\n";
+ echo '<option value="hour" '.(($interval_criteria == "hour") ? "selected" : "").'>'.$lang['srv_statistic_period_hour_period'].'</option>';
+ echo '<option value="day" '.(($interval_criteria == "day") ? "selected" : "").'>'.$lang['srv_statistic_period_day_period'].'</option>';
+ echo '</select>'."\n";
+ echo '</span>';
+
+ //data table
+ echo '<div name="edits_analysis_continu_table" id="edits_analysis_continu_table" >'."\n";
+ //draw table
+ $this->drawContinuEditsTable($data, $interval_criteria);
+ echo '</div>';
+ }
+
+ /**
+ * Draw table with bars od continued editing
+ * @param type $data - object data of continued editing
+ * @param type $interval_criteria - criteria for interval - continued 'day' or 'hour'
+ */
+ function drawContinuEditsTable($data, $interval_criteria = 'day'){
+ $maxValue = 0;
+
+ $interval_seconds = ($interval_criteria == 'day') ? 86400 : 3600;
+ $interval_crit = ($interval_criteria == 'day') ? '' : ' H';
+
+ echo '<table class="survey_referals_tbl">'."\n";
+ if ($data) {
+ $temp_time = null;
+ //units
+ $zapored = 0;
+ $results = array();
+
+ foreach ($data as $row) {
+ if($temp_time == null)
+ $temp_time = DateTime::createFromFormat('Y-m-d'.$interval_crit, $row['formatdate']);
+ else{
+ //calculate seconds between actions (rounded on 3600 or 86400)
+ $interval = $this->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($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->drawContinuRow($temp_time, $zapored, $maxValue, $value);
+ array_push($results, array('time' => $temp_time, 'zapored' => $zapored));
+
+ if(!$results)
+ $this->echoNoData();
+ else{
+ //reduce bars a little
+ $maxValue *= GRAPH_REDUCE;//najvecje stevilo
+ //draw all data and bars
+ foreach ($results as $row) {
+ $this->drawContinuRow($row['time'], $row['zapored'], $maxValue, $interval_criteria);
+ }
+ }
+ } else
+ $this->echoNoData();
+
+ echo '</table>'."\n";
+ }
+
+ /**
+ * Draws a row with bar of continuous editing
+ * @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 drawContinuRow($temp_time, $zapored, $maxValue, $interval_criteria){
+ $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');
+ }
+ else if($interval_criteria == 'day')
+ $s_time = $temp_time->format('Y-m-d') .' - '. $time_last->format('Y-m-d');
+
+ //echo data
+ echo '<tr>'."\n";
+ echo '<td style="width:90px;">' . $s_time . '</td>'."\n";
+ $width = ($maxValue && $zapored) ? (round($zapored / $maxValue * 100, 0)) : "0";
+ echo '<td style=""><div class="graph_db" style="text-align:right; float:left; width:'.$width.'%"> </div><span style="display:block; margin:auto; margin-left:5px; width:20px; float:left">'.($zapored+1).'</span></td>'."\n";
+ echo '</tr>'."\n";
+ }
+
+ /**
+ * Draw box of editing times
+ * @param type $data - $data['timeEdits']
+ * @param type $seansa - cas nastavljene dolzine seanse v min
+ * @param type $status - code of status criteria
+ * @return Object - object of editors e.g. {admin:{time_sum:500, st_akcij_sum:30, st_seans_sum:5}, ...}
+ */
+ function drawTimeEdits($data, $seansa, $status){
+ global $lang;
+
+ $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'];
+ echo '<table class="text_analysis_table floatLeft" border="1">'; //border zaradi printa - css na strani ga povozi
+ $this->echoTimeTalbeHeader($user_temp, $status, $user_id);
+ }
+
+ //naslednji editor
+ else if($user_temp != $rowGrupa['email']){
+ //izrisi se zadnjo vrstico prejsnjega urejevalca
+ $time_sum += $this -> drawTimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type, $user_id.'_'.$row_id);
+ $this -> echoTimeEditsFootRow($time_sum, $st_akcij_sum, $action_type_sum, $user_id.'_sum');
+ $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->echoTimeTalbeHeader($user_temp, $status, $user_id);
+
+ //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->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 += $this -> drawTimeEditsRow($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->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 += $this -> drawTimeEditsRow($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 += $this -> drawTimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type, $user_id.'_'.$row_id);
+ $this -> echoTimeEditsFootRow($time_sum, $st_akcij_sum, $action_type_sum, $user_id.'_sum');
+ $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 '</table>';
+
+ return $sum_data;
+ }
+
+ /**
+ * Izrisi header tabele za cas urejanja vsakega urejevalca
+ * @param type $user_temp - email of user
+ * @param type $status - status from criteria
+ * @param type $user_num - int sequence nuber of user (unique, for this site, no need to be ID)
+ */
+ function echoTimeTalbeHeader($user_temp, $status, $user_num){
+ global $lang;
+
+ echo '<tr id="edits_analysis_user_'.$user_num.'"><th colspan="100"><strong>'.$user_temp.'</strong></th></tr>';
+ echo '<tr><th>'.$lang['srv_edits_analysis_time_span'].'</th><th>'.$lang['srv_edits_analysis_time_time'].
+ '</th><th>'.$lang['srv_edits_analysis_time_actions'].'</th>'.($status < 1 ? '<th>'.$lang['srv_edits_analysis_action_type'].'</th>' : '').'</tr>';
+ }
+
+ /**
+ * Nastavi in kasneje 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 drawTimeEditsRow($datetime_start, $datetime_last, $st_akcij, $action_type = null, $row_id = null){
+ $seconds = 0;
+
+ //create string of actions type
+ $action_type_string = ($action_type != null) ? $this -> createActionsTypeString($action_type, $row_id) : null;
+
+ if(isset($datetime_last)){
+ $seconds = $this->calculateTimeBetweenActions($datetime_start, $datetime_last);
+ $this -> echoTimeEditsRow($datetime_last->format('Y-m-d H:i:s') .' - '. $datetime_start->format('Y-m-d H:i:s'),
+ $this->calculateTimeFromSeconds($seconds), $st_akcij, $action_type_string);
+ }
+ //ce je samo ena akcija
+ else
+ $this -> echoTimeEditsRow($datetime_start->format('Y-m-d H:i:s'), 0 ,1, $action_type_string);
+
+ return $seconds;
+ }
+
+ /**
+ * 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, $row_id){
+ $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++;
+ }
+ 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 .= '</br>';
+ $action_type_string .= $at['name'].' ('.$at['sum'].')';
+ }
+ }
+ }
+ return $action_type_string;
+ }
+
+ /**
+ * 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, $cas_seanse, $st_akcij, $action_type = null){
+ //casovni razpon urejanja
+ echo '<tr><td>'.$datetime.'</td>';
+ //cas urejanja
+ echo '<td>'.$cas_seanse.'</td>';
+ //stevilo akcij
+ echo '<td>'.$st_akcij.'</td>';
+ if($action_type != null)
+ //vrsta akcij
+ echo '<td>'.$action_type.'</td>';
+ echo '</tr>';
+ }
+
+ /**
+ * Izrise vrstico editor info
+ * @param type $user - string of editor
+ * @param type $time_sum - editing time
+ * @param type $st_akcij - num of sum editing actions
+ * @param type $st_seans_sum - num of sessions
+ * @param type $user_num - int sequence nuber of user (unique user int and row in table)
+ */
+ function echoCountEditsRow($user, $time_sum, $st_akcij, $st_seans_sum, $user_num){
+ //casovni razpon urejanja
+ echo '<tr><th><a href="#edits_analysis_user_'.$user_num.'">'.$user.'</a></th>';
+ //cas urejanja
+ echo '<td>'.$time_sum.'</td>';
+ //stevilo seans
+ echo '<td>'.$st_seans_sum.'</td>';
+ //stevilo akcij
+ echo '<td>'.$st_akcij.'</td>';
+ echo '</tr>';
+ }
+
+ /**
+ * 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, $st_akcij, $action_type = null, $row_id = 0){
+ global $lang;
+
+ //casovni razpon urejanja
+ echo '<tr class="colored"><td>'.$lang['srv_edits_analysis_time_total'].'</td>';
+ //cas urejanja
+ echo '<td>'.$this->calculateTimeFromSeconds($time).'</td>';
+ //stevilo akcij
+ echo '<td>'.$st_akcij.'</td>';
+ if($action_type != null)
+ //vrsta akcij
+ echo '<td>'.$this->createActionsTypeString($action_type, $row_id).'</td>';
+ echo '</tr>';
+ }
+
+ /**
+ * Izrise total/footer vrstico urejanja
+ * @param type $time - seconds of editing
+ * @param type $st_akcij - num of editing actions
+ * @param type $st_seans_sum - num of sessions
+ */
+ function echoCounterEditsFootRow($time, $st_akcij, $st_seans_sum){
+ global $lang;
+
+ //casovni razpon urejanja
+ echo '<tr class="anl_dash_bt full strong"><th>'.$lang['srv_edits_analysis_time_total'].'</th>';
+ //cas urejanja
+ echo '<td>'.$this->calculateTimeFromSeconds($time).'</td>';
+ //stevilo seans
+ echo '<td>'.$st_seans_sum.'</td>';
+ //stevilo akcij
+ echo '<td>'.$st_akcij.'</td>';
+ echo '</tr>';
+ }
+
+ /**
+ * Calculate
+ * @param type $datetime_start - datetime start of editing
+ * @param type $datetime_last - datetime end of editing
+ * @return type - float in time in minutes between actions
+ */
+ function calculateTimeBetweenActions($datetime_start, $datetime_last){
+ return abs($datetime_last ->getTimestamp() - $datetime_start->getTimestamp());
+ }
+
+ /**
+ * Get readable time from seconds
+ * @param type $seconds - time in seconds
+ * @return type string - readable time
+ */
+ function calculateTimeFromSeconds($seconds){
+ $hours = floor($seconds / 3600);
+ $mins = floor($seconds / 60 % 60);
+ $secs = floor($seconds % 60);
+
+ return sprintf('%02d:%02d:%02d', $hours, $mins, $secs);
+ }
+
+ /**
+ * 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);
+ }
+
+ /**
+ * Echo 'no data in DB'
+ */
+ function echoNoData(){
+ global $lang;
+ echo '<p><b>'.$lang['srv_edits_analysis_no_data'].'</b></p>'."\n";
+ }
+
+ function ajax_drawContinuEditsTable(){
+ if (isset ($_POST['user']))
+ $user = $_POST['user'];
+ else
+ $user = 'all';
+ if (isset ($_POST['period']))
+ $period = $_POST['period'];
+ else
+ $period = 'day';
+ if (isset($_POST['time']))
+ $time = $_POST['time'];
+ else
+ $time = '1 month';
+ if (isset ($_POST['status']))
+ $status = $_POST['status'];
+ else
+ $status = 0;
+ if (isset ($_POST['from']))
+ $from = $_POST['from'];
+ else
+ $from = '';
+ if (isset ($_POST['to']))
+ $to = $_POST['to'];
+ else
+ $to = '';
+
+ //create iterval - SQL where statement
+ $interval = $this->createInterval($time, $from, $to);
+
+ //get data
+ $data = $this->continuEditsQuery($status, $interval, $period, $user);
+
+ //draw table
+ $this->drawContinuEditsTable($data, $period);
+ }
+
+ function getList($status, $interval){
+ $sql = "SELECT st.datetime, u.email, st.post, st.get FROM srv_tracking$this->db_table st, users u WHERE st.ank_id='$this->anketa' AND u.id = st.user ". ($status != -1 ? "AND st.status=$status " : "") ."$interval";
+
+ // Loop cez vse vrednosti v vprasanjih na straneh v anketi
+ $sqlGrupa = sisplet_query($sql);
+
+ $vrstic = 0;
+ while($rowGrupa = mysqli_fetch_array($sqlGrupa)){
+ $vrstic++;
+ }
+ }
+
+}
\ No newline at end of file |