blob: 511e6481090769438bea9d4ff1c76e9dca74aab7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
|
<?php
/**
* Piwik - Open source web analytics
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*
* @category Piwik_Plugins
* @package DevicesDetection
*/
namespace Piwik\Plugins\DevicesDetection;
use Piwik\Common;
use Piwik\Db;
use Piwik\Piwik;
use Piwik\View;
use Piwik\ViewDataTable\Factory;
use UserAgentParserEnhanced;
class Controller extends \Piwik\Plugin\Controller
{
public function index()
{
$view = new View('@DevicesDetection/index');
$view->deviceTypes = $view->deviceModels = $view->deviceBrands = $view->osReport = $view->browserReport = "blank";
$view->deviceTypes = $this->getType(true);
$view->deviceBrands = $this->getBrand(true);
$view->deviceModels = $this->getModel(true);
$view->osReport = $this->getOsFamilies(true);
$view->browserReport = $this->getBrowserFamilies(true);
return $view->render();
}
public function getType()
{
return $this->renderReport(__FUNCTION__);
}
public function getBrand()
{
return $this->renderReport(__FUNCTION__);
}
public function getModel()
{
return $this->renderReport(__FUNCTION__);
}
public function getOsFamilies()
{
return $this->renderReport(__FUNCTION__);
}
public function getOsVersions()
{
return $this->renderReport(__FUNCTION__);
}
public function getBrowserFamilies()
{
return $this->renderReport(__FUNCTION__);
}
public function getBrowserVersions()
{
return $this->renderReport(__FUNCTION__);
}
/**
* You may manually call this controller action to force re-processing of past user agents
*/
public function refreshParsedUserAgents()
{
Piwik::checkUserIsSuperUser();
$q = "SELECT idvisit, config_debug_ua FROM " . Common::prefixTable("log_visit");
$res = Db::fetchAll($q);
$output = '';
foreach ($res as $rec) {
$UAParser = new UserAgentParserEnhanced($rec['config_debug_ua']);
$UAParser->parse();
$output .= "Processing idvisit = " . $rec['idvisit'] . "<br/>";
$output .= "UserAgent string: " . $rec['config_debug_ua'] . "<br/> Decoded values:";
$uaDetails = $this->getArray($UAParser);
var_export($uaDetails);
$output .= "<hr/>";
$this->updateVisit($rec['idvisit'], $uaDetails);
unset($UAParser);
}
$output .= "Please remember to truncate your archives !";
return $output;
}
private function getArray(UserAgentParserEnhanced $UAParser)
{
$UADetails['config_browser_name'] = $UAParser->getBrowser("short_name");
$UADetails['config_browser_version'] = $UAParser->getBrowser("version");
$UADetails['config_os'] = $UAParser->getOs("short_name");
$UADetails['config_os_version'] = $UAParser->getOs("version");
$UADetails['config_device_type'] = $UAParser->getDevice();
$UADetails['config_device_model'] = $UAParser->getModel();
$UADetails['config_device_brand'] = $UAParser->getBrand();
return $UADetails;
}
private function updateVisit($idVisit, $uaDetails)
{
$q = "UPDATE " . Common::prefixTable("log_visit") . " SET " .
"config_browser_name = '" . $uaDetails['config_browser_name'] . "' ," .
"config_browser_version = '" . $uaDetails['config_browser_version'] . "' ," .
"config_os = '" . $uaDetails['config_os'] . "' ," .
"config_os_version = '" . $uaDetails['config_os_version'] . "' ," .
"config_device_type = " . (isset($uaDetails['config_device_type']) ? "'" . $uaDetails['config_device_type'] . "'" : "NULL") . " ," .
"config_device_model = " . (isset($uaDetails['config_device_model']) ? "'" . $uaDetails['config_device_model'] . "'" : "NULL") . " ," .
"config_device_brand = " . (isset($uaDetails['config_device_brand']) ? "'" . $uaDetails['config_device_brand'] . "'" : "NULL") . "
WHERE idvisit = " . $idVisit;
Db::query($q);
}
}
|
