public function actionIndex()
{
$this->pageName = Yii::t('StatsModule.default', 'BROWSERS');
$this->breadcrumbs = array(Yii::t('StatsModule.default', 'MODULE_NAME') => array('/admin/shop'), $this->pageName);
$stats = Yii::app()->stats->initRun();
$zp = $stats['zp'];
if ($this->sort == "hi") {
$z = "SELECT req, COUNT(req) cnt FROM cms_surf WHERE";
$z .= $zp . " AND dt >= '{$this->sdate}' AND dt <= '{$this->fdate}' GROUP BY req ORDER BY 2 DESC";
$res = Yii::app()->db->createCommand($z)->queryAll();
$z2 = "SELECT SUM(t.cnt) as cnt FROM (" . $z . ") t";
$r = Yii::app()->db->createCommand($z2)->queryRow();
} else {
$z = "CREATE TEMPORARY TABLE IF NOT EXISTS tmp_surf SELECT ip, req FROM cms_surf WHERE";
$z .= $zp . " AND dt >= '{$this->sdate}' AND dt <= '{$this->fdate}' GROUP BY ip, req";
$z2 = "SELECT req, COUNT(req) cnt FROM tmp_surf GROUP BY req ORDER BY 2 DESC";
$transaction = Yii::app()->db->beginTransaction();
try {
Yii::app()->db->createCommand($z)->execute();
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
}
$res = Yii::app()->db->createCommand($z2)->queryAll();
$z3 = "SELECT SUM(t.cnt) as cnt FROM (" . $z2 . ") t";
$transaction2 = Yii::app()->db->beginTransaction();
try {
Yii::app()->db->createCommand($z)->execute();
$transaction2->commit();
} catch (Exception $e) {
$transaction2->rollBack();
}
$r = Yii::app()->db->createCommand($z3)->queryRow();
}
$cnt = $r['cnt'];
$k = 0;
foreach ($res as $row) {
if ($k == 0) {
$max = $row['cnt'];
}
if ($row['req'] == "") {
$row['req'] = "<font color=grey>неизвестно</font>";
}
$k++;
$result[] = array('num' => $k, 'req' => Html::link($row['req'], $row['req'], array('traget' => '_blank')), 'h' => $row['cnt'], 'graphic' => "<img align=left src=/stats/px" . ($this->sort == "hi" ? "h" : "u") . ".gif width=" . ceil($row['cnt'] * 100 / $max) . " height=11 border=0>", 'pracent' => number_format($row['cnt'] * 100 / $cnt, 1, ',', ''), 'detail' => Html::link('>>>', "?pz=1&tz=1&item=req&s_date=" . StatsHelper::dtconv($this->sdate) . "&f_date=" . StatsHelper::dtconv($this->fdate) . "&qs=" . urlencode($row['req']) . "&sort=" . (empty($this->sort) ? "ho" : $this->sort), array('traget' => '_blank')));
}
$dataProvider = new CArrayDataProvider($result, array('sort' => array('attributes' => array('ip' => array('asc' => 'ip DESC', 'desc' => 'ip ASC'), 'refer' => array('asc' => 'refer DESC', 'desc' => 'refer ASC'))), 'pagination' => array('pageSize' => 10)));
$this->render('index', array('dataProvider' => $dataProvider));
}
function getScaledSkillScore($studentId, $skillId, $debug = false)
{
// Special case for persistence, which has two parts that need to be scaled independently
if ($skillId == "persistence") {
// Scale the two parts indpendently, and weight them equally
return ($this->getScaledSkillScore($studentId, "persistence_attempts", $debug) + $this->getScaledSkillScore($studentId, "persistence_watched", $debug)) / 2;
}
$scoreResults = Students::find(["columns" => "{$skillId}"]);
$studentId = str_replace("'", "", $studentId);
$rawScores = array_column($scoreResults->toArray(), "{$skillId}");
$rawScore = Students::findFirst("email = '{$studentId}'")->{$skillId};
$scaledScore = StatsHelper::calculateScaledScore($rawScores, $rawScore);
if ($debug) {
echo "All scores for skill {$skillId}: \n";
foreach ($rawScores as $s) {
echo "{$s}\n";
}
echo "Raw {$skillId} score for student {$studentId} is {$rawScore}, and scaled score is {$scaledScore}\n";
}
return round($scaledScore * 100) / 10;
}
public function actionDetail($detail)
{
$group = $_GET['group'];
if (file_exists("detail.dat") and $group != "false") {
$group = "true";
}
if ($group != "true") {
echo "<table id=table align=center width=100% cellpadding=5 cellspacing=1 border=0><tr class=h><td width=35>Время</td><td>Referer</td><td width=90>IP-адрес <a class=d href=\"?detail=" . $detail . "&group=true\"\"\">±</a></td><td>Хост</td><td>User-Agent</td><td>Страница</td></tr>";
// $r = mysql_query("SELECT tm,refer,ip,proxy,host,lang,user,req FROM cms_surf WHERE dt='" . $detail . "' ORDER BY i DESC");
$sql = "SELECT tm,refer,ip,proxy,host,lang,user,req FROM cms_surf WHERE dt='" . $detail . "' ORDER BY i DESC";
$command = Yii::app()->db->createCommand($sql);
foreach ($command->queryAll() as $row) {
//while ($row = mysql_fetch_row($r)) {
if ($s == "s2") {
$s = "s1";
echo "<tr class=s1>";
} else {
$s = "s2";
echo "<tr class=s2>";
}
echo "<td>" . $row['tm'] . "</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;'>";
$refer = $this->Ref($row['refer']);
if (is_array($refer)) {
list($engine, $query) = $refer;
if ($engine == "G" and !empty($query) and stristr($row['refer'], "/url?")) {
$row['refer'] = str_replace("/url?", "/search?", $row['refer']);
}
echo_se($engine);
if (empty($query)) {
$query = "<font color=grey>неизвестно</font>";
}
echo ": <a target=_blank href=\"" . $row['refer'] . "\">" . $query . "</a></td>";
} else {
if ($refer == "") {
echo "<font color=grey>неизвестно</font>";
} else {
echo "<a target=_blank href=\"" . $row['refer'] . "\">";
if (stristr(urldecode($row['refer']), "xn--")) {
$IDN = new idna_convert(array('idn_version' => 2008));
echo $IDN->decode(urldecode($row['refer']));
} else {
echo urldecode($row['refer']);
}
echo "</a></td>";
}
}
if ($row['ip'] != "unknown") {
echo "<td><a target=_blank href=\"?item=ip&qs=" . $row['ip'] . "\">" . $row['ip'] . "</a>";
} else {
echo "<td><font color=grey>неизвестно</font>";
}
if ($row['proxy'] != "") {
echo "<br><a target=_blank href=\"?item=ip&qs=" . $row['proxy'] . "\">через proxy</a>";
}
echo "</td>";
if ($row['host'] == "") {
echo "<td><font color=grey>неизвестно</font>";
} else {
echo "<td><a target=_blank href=\"http://www.tcpiputils.com/browse/ip-address/" . ($row['proxy'] != "" ? $row['proxy'] : $row['ip']) . "\">" . $row['host'] . "</a>";
}
if ($row['lang'] != "") {
echo "<br>Язык: " . (!empty(StatsHelper::$LANG[mb_strtoupper($row['lang'])]) ? StatsHelper::$LANG[mb_strtoupper($row['lang'])] : "<font color=grey>неизвестно</font>");
if (file_exists("/stats/flags/" . mb_strtolower(StatsHelper::$LANG[mb_strtoupper($row['lang'])]) . ".gif")) {
echo " <img align=absmiddle src=/stats/flags/" . mb_strtolower(StatsHelper::$LANG[mb_strtoupper($row['lang'])]) . ".gif width=16 height=12>";
}
}
echo "</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;'>";
if (!$this->is_robot($row['user'], $row['host'])) {
$brw = StatsHelper::GetBrowser($row['user']);
if ($brw != "") {
echo "<img src=/stats/browsers/{$brw} width=16 height=16 align=absmiddle> ";
}
}
echo $row['user'] . "</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;' nowrap><a target=_blank href=" . $row['req'] . ">" . $row['req'] . "</a></td>";
echo "</tr>";
}
echo "<tr class=h><td></td><td></td><td></td><td></td><td></td><td></td></tr></table>";
//norm(0);
} else {
echo "<table id=table align=center width=100% cellpadding=5 cellspacing=1 border=0><tr class=h><td width=90>IP-адрес <a class=d href=\"?detail=" . $detail . "&group=false\"\"\">±</a></td><td>Хост</td><td>User-Agent</td><td width=30%>Referer</td><td width=35>Время</td><td>Страница</td></tr>";
$sql = "SELECT tm,refer,ip,proxy,host,lang,user,req FROM cms_surf WHERE dt='" . $detail . "' ORDER BY i DESC";
$command = Yii::app()->db->createCommand($sql);
foreach ($command->queryAll() as $r) {
//print_r($r);
//die;
//$rs = mysql_query("SELECT tm,refer,ip,proxy,host,lang,user,req FROM cms_surf WHERE dt='" . $detail . "' ORDER BY i DESC");
// while ($r = mysql_fetch_row($rs))
$row[$r['ip']][] = array($r['tm'], $r['refer'], $r['ip'], $r['proxy'], $r['host'], $r['lang'], $r['user']);
foreach ($row as $ip => $val) {
if ($s == "s2") {
$s = "s1";
echo "<tr class=s1>";
} else {
$s = "s2";
echo "<tr class=s2>";
}
if ($ip != "unknown") {
echo "<td rowspan=" . count($val) . "><a target=_blank href=\"?item=ip&qs=" . $ip . "\">" . $ip . "</a>";
} else {
echo "<td><font color=grey>неизвестно</font>";
}
if ($val[0][2] != "") {
echo "<br><a target=_blank href=\"?item=ip&qs=" . $val[0][2] . "\">через proxy</a>";
}
echo "</td>";
$skip = 0;
foreach ($val as $k => $rw) {
if ($skip != 0) {
echo "<tr class=" . $s . ">";
}
$skip = 1;
if ($rw[3] == "") {
echo "<td><font color=grey>неизвестно</font>";
} else {
echo "<td><a target=_blank href=\"http://www.tcpiputils.com/browse/ip-address/" . ($rw[2] != "" ? $rw[2] : $ip) . "\">" . $rw[3] . "</a>";
}
if ($rw[4] != "") {
echo "<br>Язык: " . (!empty(StatsHelper::$LANG[mb_strtoupper($rw[4])]) ? $lang[mb_strtoupper($rw[4])] : "<font color=grey>неизвестно</font>");
if (file_exists("flags/" . mb_strtolower(StatsHelper::$LANG[mb_strtoupper($rw[4])]) . ".gif")) {
echo " <img align=absmiddle src=flags/" . mb_strtolower(StatsHelper::$LANG[mb_strtoupper($rw[4])]) . ".gif width=16 height=12>";
}
}
echo "</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;'>";
if (!$this->is_robot($rw[5], $rw[3])) {
$brw = StatsHelper::GetBrowser($rw[5]);
if ($brw != "") {
echo "<img src=browsers/{$brw} width=16 height=16 align=absmiddle> ";
}
}
echo $rw[5] . "</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;'>";
$refer = $this->Ref($rw[1]);
if (is_array($refer)) {
list($engine, $query) = $refer;
if ($engine == "G" and !empty($query) and stristr($rw[1], "/url?")) {
$rw[1] = str_replace("/url?", "/search?", $rw[1]);
}
echo_se($engine);
if (empty($query)) {
$query = "<font color=grey>неизвестно</font>";
}
echo ": <a target=_blank href=\"" . $rw[1] . "\">" . $query . "</a></td>";
} else {
if ($refer == "") {
echo "<font color=grey>неизвестно</font>";
} else {
echo "<a target=_blank href=\"" . $row[1] . "\">";
if (stristr(urldecode($rw[1]), "xn--")) {
$IDN = new idna_convert(array('idn_version' => 2008));
echo $IDN->decode(urldecode($rw[1]));
} else {
echo urldecode($rw[1]);
}
echo "</a></td>";
}
}
echo "<td>" . $rw[0] . "</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;' nowrap><a target=_blank href=" . $rw[6] . ">" . $rw[6] . "</a></td>";
echo "</tr>";
}
}
}
echo "<tr class=h><td></td><td></td><td></td><td></td><td></td><td></td></tr></table>";
}
}
$k++;
$vse += $val;
echo "<tr>";
echo "<td>{$k}</td>";
if ($tm != "23") {
$tm2 = $tm + 1;
} else {
$tm2 = "00";
}
if (strlen($tm2) == 1) {
$tm2 = "0" . $tm2;
}
$par = $tm . ':00 - ' . $tm2 . ':00';
$times[] = $par;
$test[] = array('y' => (int) $val, 'url' => "?pz=1&item=tm&s_date=" . StatsHelper::dtconv($this->sdate) . "&f_date=" . StatsHelper::dtconv($this->fdate) . "&qs=" . $tm . ":&sort=" . (empty($this->sort) ? "ho" : $this->sort));
echo "<td align=left><a target=_blank href=\"?pz=1&item=tm&s_date=" . StatsHelper::dtconv($this->sdate) . "&f_date=" . StatsHelper::dtconv($this->fdate) . "&qs=" . $tm . ":&sort=" . (empty($this->sort) ? "ho" : $this->sort) . "\">{$tm}:00 - {$tm2}:00</a></td>";
echo "<td>{$val}</td>";
echo "<td><img align=left src=/stats/px" . ($this->sort == "hi" ? "h" : "u") . ".gif width=" . ceil($val * 100 / $mmx) . " height=11 border=0></td>";
echo "<td>" . number_format($val * 100 / $cnt, 1, '.', '') . "</td></tr>";
}
?>
</table>
<?php
} else {
Yii::app()->tpl->alert('info', 'Нет данных');
}
$this->Widget('ext.highcharts.HighchartsWidget', array('scripts' => array('columnrange', 'modules/exporting', 'themes/grid'), 'options' => array('chart' => array('type' => 'column', 'animation' => false, 'backgroundColor' => array('linearGradient' => array(0, 0, 0, 500), 'stops' => array(array(0, 'rgb(255, 255, 255)'), array(1, 'rgb(200, 200, 255)')))), 'credits' => array('enabled' => false), 'exporting' => array('buttons' => array('contextButton' => array('menuItems' => array(array('text' => 'Export to PNG (small)', 'onclick' => 'js:function () {
this.exportChart({
width: 250
});
?>
<table class="tDefault tMedia">
<thead>
<tr>
<th>Дата</th>
<th>Последние <?php
echo $n;
?>
других сайта</th>
<th>Время / Страница</th>
</tr>
</thead>
<?php
foreach ($items as $ref) {
echo "<tr>";
echo "<td title=" . StatsHelper::$MONTH[substr($ref['dt'], 4, 2)] . ">" . StatsHelper::$DAY[$ref['day']] . StatsHelper::dtconv($ref['dt']) . "</td>";
echo "<td class='textL'><a target=_blank href=\"" . $ref['refer'] . "\">";
if (stristr(urldecode($ref['refer']), "xn--")) {
$IDN = new idna_convert(array('idn_version' => 2008));
echo $IDN->decode(urldecode($ref['refer']));
} else {
echo urldecode($ref['refer']);
}
echo "</a></td>";
echo "<td class='textL'>" . $ref['tm'] . " <a target=_blank href=" . $ref['req'] . ">" . $ref['req'] . "</a></td></tr>";
}
?>
</table>
<?php
Yii::app()->tpl->closeWidget();
break;
case "mozilla.gif":
echo "Mozilla";
break;
case "safari.png":
echo "Apple Safari";
break;
case "mac.gif":
echo "Macintosh";
break;
case "maxthon.png":
echo "Maxthon (MyIE)";
break;
default:
echo "другие";
break;
}
echo "</a></td>";
echo "<td>{$val}</td>";
echo "<td><img align=left src=/stats/px" . ($this->sort == "hi" ? "h" : "u") . ".gif width=" . ceil($val * 100 / $mmx) . " height=11 border=0></td>";
echo "<td>" . number_format($val * 100 / $cnt, 1, ',', '') . "</td>";
echo "<td><a class=d target=_blank href=\"/admin/stats/browsers/view?pos=10&s_date=" . StatsHelper::dtconv($this->sdate) . "&f_date=" . StatsHelper::dtconv($this->fdate) . "&brw=" . (empty($brw) ? "другие" : $brw) . "&sort=" . (empty($this->sort) ? "ho" : $this->sort) . "\">>>></a></td></tr>";
}
?>
</table>
<?php
} else {
Yii::app()->tpl->alert('info', 'Нет данных');
}
Yii::app()->tpl->closeWidget();
запроса</th>
<th>Время / Страница</th>
</tr>
</thead>
<?php
foreach ($items as $ref) {
$refer = StatsHelper::Ref($ref['refer']);
if (is_array($refer)) {
list($engine, $query) = $refer;
if ($engine == "G" and !empty($query) and stristr($ref['refer'], "/url?")) {
$ref['refer'] = str_replace("/url?", "/search?", $ref['refer']);
}
echo "<tr>";
echo "<td nowrap title=" . StatsHelper::$MONTH[substr($ref['dt'], 4, 2)] . ">" . StatsHelper::$DAY[$ref['day']] . StatsHelper::dtconv($ref['dt']) . "</td>";
echo "<td align=center>";
StatsHelper::echo_se($engine);
if (empty($query)) {
$query = "<font color=grey>неизвестно</font>";
}
echo "</td><td align=left style='overflow: hidden;text-overflow: ellipsis;'><a target=_blank href=\"" . $ref['refer'] . "\">" . $query . "</a></td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;' nowrap>" . $ref['tm'] . " <a target=_blank href=" . $ref['req'] . ">" . $ref['req'] . "</a></td></tr>";
}
}
?>
</table>
<?php
Yii::app()->tpl->closeWidget();
?>
</th>
<th>График</th>
<th>%</th>
</tr>
<?php
foreach ($items as $row) {
if ($row['user'] == "") {
$row['user'] = "******";
}
if ($k == 0) {
$max = $row['cnt'];
}
if ($k == $pos) {
break;
}
$k++;
$vse += $row['cnt'];
echo '<tr>';
echo "<td>{$k}</td>";
echo "<td align=left style='overflow: hidden;text-overflow: ellipsis;'><a target=_blank href=\"?tz=1&pz=1&item=user&s_date=" . StatsHelper::dtconv($this->sdate) . "&f_date=" . StatsHelper::dtconv($this->fdate) . "&qs=" . $row['user'] . "&sort=" . (empty($this->sort) ? "ho" : $this->sort) . "\">" . $row['user'] . "</a></td>";
echo "<td>" . $row['cnt'] . "</td>";
echo "<td><img align=left src=/stats/px" . ($this->sort == "hi" ? "h" : "u") . ".gif width=" . ceil($row['cnt'] * 100 / $max) . " height=11 border=0></td>";
echo "<td>" . number_format($row['cnt'] * 100 / $cnt, 1, ',', '') . "</td>";
echo "</tr>";
}
?>
</table>
<?php
Yii::app()->tpl->closeWidget();
public function getToday()
{
foreach (StatsMainh::model()->findAll() as $rw) {
$dt_i = $rwz["dt"][] = $rw->dt;
$rwz["cnt1"][$dt_i] = $rw->cnt1;
$rwz["cnt2"][$dt_i] = $rw->cnt2;
$rwz["cnt3"][$dt_i] = $rw->cnt3;
$rwz["cnt4"][$dt_i] = $rw->cnt4;
$rwz["cnt5"][$dt_i] = $rw->cnt5;
}
foreach (StatsMainp::model()->findAll() as $rww) {
$dt_i = $rww["dt"] . $rww->god;
$rwzz[$dt_i]["cnt1"] = $rww->cnt1;
$rwzz[$dt_i]["cnt2"] = $rww->cnt2;
$rwzz[$dt_i]["cnt3"] = $rww->cnt3;
$rwzz[$dt_i]["cnt4"] = $rww->cnt4;
$rwzz[$dt_i]["cnt5"] = $rww->cnt5;
}
list($s_date, $f_date) = str_replace("+", "", array('13.03.2015', '15.03.2015'));
$sdate = StatsHelper::dtconv2(trim($s_date));
$fdate = StatsHelper::dtconv2(trim($f_date));
/* if ($robots = file(Yii::getPathOfAlias('webroot.stats') . "/robots.dat")) {
$i = 0;
for ($i = 0; $i < count($robots); $i++)
$robots[$i] = iconv("CP1251", "UTF-8", $robots[$i]);
foreach ($robots as $val) {
list($rb1, $rb2) = explode("|", $val);
$rb2 = trim($rb2);
$this->rbd[$i++] = rtrim($rb1);
if (!empty($rb2))
$rbdn[$rb2][] = rtrim($rb1);
$robo[] = $rb2;
}
}
if ($hosts = file(Yii::getPathOfAlias('webroot.stats') . "/hosts.dat")) {
$i = 0;
for ($i = 0; $i < count($hosts); $i++)
$hosts[$i] = iconv("CP1251", "UTF-8", $hosts[$i]);
foreach ($hosts as $val) {
list($hb1, $hb2) = explode("|", $val);
$hb2 = trim($hb2);
$hbd[$i++] = rtrim($hb1);
if (!empty($hb2))
$hbdn[$hb2][] = rtrim($hb1);
$robo[] = $hb2;
}
}
$this->robo = array_unique($robo); */
$iniRun = $this->initRun();
$this->rbd = $iniRun['rbd'];
$hbd = $iniRun['hbd'];
foreach ($this->rbd as $val) {
$zp .= " LOWER(user) NOT LIKE '%" . mb_strtolower($val) . "%' AND";
}
if (filesize(Yii::getPathOfAlias('webroot.stats') . "/hosts.dat")) {
foreach ($hbd as $val) {
$zp .= " LOWER(host) NOT LIKE '%" . mb_strtolower($val) . "%' AND";
}
}
$zp .= " LOWER(user) NOT LIKE '' AND";
if (file_exists(Yii::getPathOfAlias('webroot.stats') . "/skip.dat")) {
if ($skip = file(Yii::getPathOfAlias('webroot.stats') . "/skip.dat")) {
foreach ($skip as $vl) {
list($s1, $s2) = explode("|", $vl);
$zp2 .= " {$s1} NOT LIKE '%" . rtrim($s2) . "%' AND";
}
}
}
$zp .= $zp2;
$this->_zp = substr($zp, 0, -4);
if ($se_m = file(Yii::getPathOfAlias('webroot.stats') . "/se.dat")) {
for ($i = 0; $i < count($se_m); $i++) {
$se_m[$i] = iconv("CP1251", "UTF-8", $se_m[$i]);
}
foreach ($se_m as $vl) {
list($s1, $s2, $s3) = explode("|", $vl);
$se_n[$s1] = rtrim($s3);
$se_nn[$s1] = $s2;
}
}
if (file_exists(Yii::getPathOfAlias('webroot.stats') . "/fix.dat")) {
if ($fx_m = file(Yii::getPathOfAlias('webroot.stats') . "/fix.dat")) {
$this->_zfx = "";
$pf = "";
for ($i = 0; $i < count($fx_m); $i++) {
$fx_m[$i] = iconv("CP1251", "UTF-8", $fx_m[$i]);
}
foreach ($fx_m as $vl) {
list($s1, $s2, $s3) = explode("|", $vl);
$this->_zfx .= $pf . "LOWER(" . $s1 . ") LIKE '%" . mb_strtolower($s2) . "%'";
$pf = " OR ";
$s3 = rtrim($s3);
if (!empty($s3)) {
$fxn[$s3][] = $s1 . "|" . $s2;
}
$fxo[] = $s3;
}
}
}
foreach ($se_nn as $val) {
$this->_cse_m .= " OR LOWER(refer) LIKE '%{$val}%'";
$this->_cot_m .= " AND LOWER(refer) NOT LIKE '%{$val}%'";
}
$c = 0;
$sdate = 0;
$all_uniqs = 0;
$all_hits = 0;
$all_se = 0;
$all_other = 0;
$all_fix = 0;
// $r = Yii::app()->db->createCommand();
// $r->selectDistinct('day, dt');
// $r->from('cms_surf');
// $r->order('i');
$i = 0;
//$res1 = $r->queryRow();
// $fdate = $res1['dt'];
$visits = $this->visits(date('Ymd'));
$system = $this->visitSystem(date('Ymd'));
return array('hosts' => $visits['hosts'], 'hits' => $visits['hits'], 'search' => $system['search'], 'sites' => $system['sites']);
}
public function actionView()
{
$this->pageName = 'dsadsa';
$pos = $_GET['pos'];
$engin = $_GET['engin'];
$dy = $_GET['dy'];
$domen = $_GET['domen'];
$brw = $_GET['brw'];
$str_f = $_GET['str_f'];
$qq = $_GET['qq'];
$vse = 0;
$k = 0;
if (empty($pos)) {
$pos = 99999;
}
if ($this->sort == "hi") {
$sql = "SELECT user, COUNT(user) cnt FROM cms_surf WHERE";
if (!empty($str_f)) {
$sql .= " user LIKE '%{$str_f}%' AND";
}
//StatsHelper::GetBrw($brw)
$sql .= $this->_zp . " AND dt >= '{$this->sdate}' AND dt <= '{$this->fdate}' " . (isset($brw) ? StatsHelper::GetBrw($brw) : "") . " GROUP BY user ORDER BY 2 DESC";
//$res = mysql_query($z);
$res = Yii::app()->db->createCommand($sql);
$full_sql = "SELECT SUM(t.cnt) as cnt FROM (" . $sql . ") t";
$r = Yii::app()->db->createCommand($full_sql);
} else {
$sql = "CREATE TEMPORARY TABLE tmp_surf SELECT ip, user FROM cms_surf WHERE";
if (!empty($str_f)) {
$sql .= " user LIKE '%{$str_f}%' AND";
}
$sql .= $this->_zp . " AND dt >= '{$this->sdate}' AND dt <= '{$this->fdate}' " . (isset($brw) ? StatsHelper::GetBrw($brw) : "") . " GROUP BY ip" . (!isset($brw) ? ",user" : "");
$sql2 = "SELECT user, COUNT(user) cnt FROM tmp_surf GROUP BY user ORDER BY 2 DESC";
$res = Yii::app()->db->createCommand($sql);
$transaction = Yii::app()->db->beginTransaction();
try {
Yii::app()->db->createCommand($sql2)->execute();
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
}
$z3 = "SELECT SUM(t.cnt) as cnt FROM (" . $sql2 . ") t";
$transaction2 = Yii::app()->db->beginTransaction();
try {
Yii::app()->db->createCommand($sql)->execute();
$transaction2->commit();
} catch (Exception $e) {
$transaction2->rollBack();
}
$r = Yii::app()->db->createCommand($z3);
}
$smd = $r->queryRow();
$cnt = $smd['cnt'];
if (!empty($brw)) {
switch ($brw) {
case "ie.png":
$browserName = "MS Internet Explorer";
break;
case "opera.png":
$browserName = "Opera";
break;
case "firefox.png":
$browserName = "Firefox";
break;
case "chrome.png":
$browserName = "Google Chrome";
break;
case "mozilla.gif":
$browserName = "Mozilla";
break;
case "safari.png":
$browserName = "Apple Safari";
break;
case "mac.gif":
$browserName = "Macintosh";
break;
case "maxthon.png":
$browserName = "Maxthon (MyIE)";
break;
default:
$browserName = "другие";
break;
}
}
$this->render('view', array('items' => $res->queryAll(), 'cnt' => $cnt, 'max' => $max, 'browserName' => $browserName, 'vse' => $vse, 'k' => $k, 'pos' => $pos));
}
public function actionHosts($date)
{
$this->pageName = 'Hosts';
$stats = Yii::app()->stats->initRun();
$zp = $stats['zp'];
$sql = "SELECT tm,refer,ip,proxy,host,lang,user,req from cms_surf WHERE dt='" . $date . "' AND " . $zp . " GROUP BY ip ORDER BY i DESC";
$cmd = Yii::app()->db->createCommand($sql);
$result = array();
foreach ($cmd->queryAll(false) as $row) {
$refer = StatsHelper::Ref($row[1]);
if (is_array($refer)) {
list($engine, $query) = $refer;
$refer1 = StatsHelper::checkSearchEngine($row[1], $engine, $query);
} else {
$refer1 = StatsHelper::checkIdna($row);
}
$result[] = array('time' => $row[0], 'refer' => $refer1, 'ip' => StatsHelper::getRowIp($row[2], $row[3]), 'host' => StatsHelper::getRowHost($row[2], $row[3], $row[4], $row[5]), 'user_agent' => StatsHelper::getRowUserAgent($row[6], $row[1]), 'timelink' => Html::link($row[7], $row[7]));
}
$dataProvider = new CArrayDataProvider($result, array('sort' => array('attributes' => array('ip' => array('asc' => 'ip DESC', 'desc' => 'ip ASC'), 'refer' => array('asc' => 'refer DESC', 'desc' => 'refer ASC'), 'time' => array('asc' => 'time DESC', 'desc' => 'time ASC'))), 'pagination' => array('pageSize' => 10)));
$this->render('hosts', array('dataProvider' => $dataProvider));
}
