location = ($location ? $location : $deflt2docs_location);
$this->date = ($date ? $date : date('Y-m-d'));
$this->enddate = $enddate;
}
public function get_form($module) {
global $visits_statistics_form, $visits_statistics_main_line, $visits_statistics_service_line, $visits_statistics_shortcut_button;
global $empr_visits_statistics_active;
if (!$empr_visits_statistics_active) {
return '';
}
$this->get_config();
$html = $visits_statistics_form;
$html = str_replace('!!module!!', $module, $html);
$html = str_replace('!!visits_statistics_date!!', formatdate($this->date), $html);
$visits_statistics_shortcuts_buttons = '';
$visits_statistics_main_lines = '';
foreach (self::$config['main'] as $type => $main) {
$line = $visits_statistics_main_line;
if ($main['show_shortcut']) {
$line = str_replace('!!visits_statistics_color!!', '', $line);
} else {
$line = str_replace('!!visits_statistics_color!!', '', $line);
}
$line = str_replace('!!visits_statistics_main_name!!', $main['name'], $line);
$line = str_replace('!!visits_statistics_main_counter!!', $this->get_counter($type), $line);
$visits_statistics_main_lines.= $line;
$button = $visits_statistics_shortcut_button;
$button = str_replace('!!counter_type!!', $type, $button);
$button = str_replace('!!visits_statistics_color!!', $main['color'], $button);
$button = str_replace('!!visits_statistics_title!!', $main['name'], $button);
if ($main['show_shortcut']) {
$visits_statistics_shortcuts_buttons.= $button;
}
}
$visits_statistics_service_lines = '';
$current_category = 0;
$close_row = false;
foreach (self::$config['services'] as $type => $service) {
$line = $visits_statistics_service_line;
if ($service['show_shortcut']) {
$line = str_replace('!!visits_statistics_color!!', '', $line);
} else {
$line = str_replace('!!visits_statistics_color!!', '', $line);
}
$line = str_replace('!!visits_statistics_service_name!!', $service['name'], $line);
$line = str_replace('!!visits_statistics_service_counter!!', $this->get_counter($type), $line);
if ($service['category'] && ($service['category'] != $current_category)) {
if ($close_row) {
$visits_statistics_service_lines.= ' | ';
}
$close_row = false;
$visits_statistics_service_lines.= ''.self::$config['categories'][$service['category']]['name'].' | ';
}
$current_category = $service['category'];
if (!$close_row) {
$visits_statistics_service_lines.= '';
}
$visits_statistics_service_lines.= $line;
if ($close_row) {
$visits_statistics_service_lines.= '
';
$close_row = false;
} else {
$close_row = true;
}
$button = $visits_statistics_shortcut_button;
$button = str_replace('!!counter_type!!', $type, $button);
$button = str_replace('!!visits_statistics_color!!', $service['color'], $button);
$button = str_replace('!!visits_statistics_title!!', $service['name'], $button);
if ($service['show_shortcut']) {
$visits_statistics_shortcuts_buttons.= $button;
}
}
if ($close_row) {
$visits_statistics_service_lines.= ' | ';
}
$html = str_replace('!!visits_statistics_main_lines!!', $visits_statistics_main_lines, $html);
$html = str_replace('!!visits_statistics_service_lines!!', $visits_statistics_service_lines, $html);
$html = str_replace('!!visits_statistics_shortcuts_buttons!!', $visits_statistics_shortcuts_buttons, $html);
return $html;
}
protected function get_sql_clause() {
$clause = ' visits_statistics_location = "'.$this->location.'"';
if ($this->enddate) {
return $clause.' and DATE(visits_statistics_date) <= "'.$this->date.'" and DATE(visits_statistics_date) >= "'.$this->enddate.'" ';
}
return $clause.' and DATE(visits_statistics_date) = "'.$this->date.'" ';
}
protected function get_statistics() {
if (isset($this->statistics)) {
return $this->statistics;
}
$query = 'select DATE(visits_statistics_date) as date, visits_statistics_type as type, count(*) as value from visits_statistics where '.$this->get_sql_clause().' GROUP BY DATE(visits_statistics_date), visits_statistics_type';
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
if (!isset($this->statistics[$row->date])) {
$this->statistics[$row->date] = array();
}
$this->statistics[$row->date][$row->type] = $row->value;
}
}
return $this->statistics;
}
protected function get_counter($type) {
global $visits_statistics_form_counter;
$this->get_statistics();
$count = 0;
if (isset($this->statistics[$this->date][$type])) {
$count = $this->statistics[$this->date][$type];
}
$html = $visits_statistics_form_counter;
$html = str_replace('!!counter_type!!', $type, $html);
$html = str_replace('!!count!!', $count, $html);
return $html;
}
public function add_visit($type) {
if (!$type) return false;
$query = 'INSERT INTO visits_statistics (visits_statistics_date, visits_statistics_location, visits_statistics_type) VALUES (NOW(), "'.$this->location.'", "'.$type.'")';
pmb_mysql_query($query);
}
public function remove_visit($type) {
if (!$type) return false;
$query = 'DELETE FROM visits_statistics WHERE visits_statistics_id in (SELECT * FROM (SELECT MAX(visits_statistics_id) FROM visits_statistics WHERE DATE(visits_statistics_date) = "'.$this->date.'" and visits_statistics_type = "'.$type.'") AS vs)';
pmb_mysql_query($query);
}
public function update_visits($type, $value) {
if (!$type) return false;
$this->get_statistics();
if (!isset($this->statistics[$this->date][$type])) {
$this->statistics[$this->date][$type] = 0;
}
$value = $value*1;
if ($value < 0) {
$value = 0;
}
// La valeur est supérieure à ce qui est en base, on ajoute des visites
if ($this->statistics[$this->date][$type] < $value) {
for ($i = $this->statistics[$this->date][$type]; $i < $value; $i++) {
$this->add_visit($type);
}
}
// La valeur est inférieure à ce qui est en base, on supprimes des visites
if ($this->statistics[$this->date][$type] > $value) {
for ($i = $value; $i < $this->statistics[$this->date][$type]; $i++) {
$this->remove_visit($type);
}
}
}
protected function get_config(){
global $include_path, $base_path, $charset;
if (isset(self::$config)) {
return self::$config;
}
if(file_exists($include_path.'/visits_statistics/config_subst.xml')){
$xmlFile = $include_path.'/visits_statistics/config_subst.xml';
}elseif(file_exists($include_path.'/visits_statistics/config.xml')){
$xmlFile = $include_path.'/visits_statistics/config.xml';
}else{
//pas de fichier à analyser
return false;
}
$fileInfo = pathinfo($xmlFile);
$tempFile = $base_path."/temp/XML".preg_replace("/[^a-z0-9]/i","",$fileInfo['dirname'].$fileInfo['filename'].$charset).".tmp";
if (!file_exists($tempFile) || (filemtime($xmlFile) > filemtime($tempFile))) {
//Le fichier XML original a-t-il été modifié ultérieurement ?
//on va re-générer le pseudo-cache
if(file_exists($tempFile)){
unlink($tempFile);
}
//Parse le fichier dans un tableau
$fp=fopen($xmlFile,"r") or die("Can't find XML file ".$xmlFile);
$xml=fread($fp, filesize($xmlFile));
fclose($fp);
$xml_2_analyze=_parser_text_no_function_($xml, 'STATS');
self::$config = array(
'main' => array(),
'services' => array(),
'categories' => array()
);
if (isset($xml_2_analyze['MAIN'])) {
foreach ($xml_2_analyze['MAIN'] as $main) {
self::$config['main'][$main['TYPE']] = array(
'name' => get_msg_to_display($main['NAME']),
'color' => $main['COLOR'],
'shortcut' => (isset($main['SHORTCUT']) ? $main['SHORTCUT'] : ''),
'show_shortcut' => ((isset($main['SHOW_SHORTCUT']) && ($main['SHOW_SHORTCUT'] == 'yes')) ? true : false)
);
}
}
if (isset($xml_2_analyze['SERVICES'][0]['SERVICE'])) {
foreach ($xml_2_analyze['SERVICES'][0]['SERVICE'] as $service) {
self::$config['services'][$service['TYPE']] = array(
'name' => get_msg_to_display($service['NAME']),
'color' => $service['COLOR'],
'shortcut' => (isset($service['SHORTCUT']) ? $service['SHORTCUT'] : ''),
'show_shortcut' => ((isset($service['SHOW_SHORTCUT']) && ($service['SHOW_SHORTCUT'] == 'yes')) ? true : false),
'category' => (isset($service['CATEGORY']) ? $service['CATEGORY'] : 0)
);
}
}
if (isset($xml_2_analyze['CATEGORIES']) && isset($xml_2_analyze['CATEGORIES'][0]['CATEGORY'])) {
foreach ($xml_2_analyze['CATEGORIES'][0]['CATEGORY'] as $category) {
self::$config['categories'][$category['ID']] = array(
'name' => get_msg_to_display($category['NAME'])
);
}
}
$tmp = fopen($tempFile, "wb");
fwrite($tmp, serialize(self::$config));
fclose($tmp);
} else if (file_exists($tempFile)){
$tmp = fopen($tempFile, "r");
self::$config = unserialize(fread($tmp, filesize($tempFile)));
fclose($tmp);
}
return self::$config;
}
public function get_json_statistics() {
$this->get_statistics();
return encoding_normalize::json_encode($this->statistics[$this->date]);
}
}