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)); }
public function actionIndex() { $this->pageName = Yii::t('StatsModule.default', 'MODULE_NAME'); $this->breadcrumbs = array(Yii::t('StatsModule.default', 'MODULE_NAME') => array('/admin/shop'), $this->pageName); $result = array(); $stats = Yii::app()->stats; $s = $stats->initRun(); foreach (StatsMainh::model()->findAll(array('order' => '`t`.`i` ASC')) 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; } $c = 0; $all_uniqs = 0; $all_hits = 0; $all_se = 0; $all_other = 0; $all_fix = 0; $sdate = 0; $r = Yii::app()->db->createCommand(); $r->selectDistinct('day, dt'); $r->from('cms_surf'); $r->order('i DESC'); $res = $r->queryRow(false); //$sql = "SELECT DISTINCT day,dt from cms_surf ORDER BY i"; //$cmd = Yii::app()->db->createCommand($sql)->queryRow(); //unset($res[count($res)-1]); $fdate = date('Ymd'); foreach ($r->queryAll() as $dtm) { if (substr($sdate, 4, 2) != substr($dtm['dt'], 4, 2) and $sdate != 0) { $c++; } $sdate = $dtm['dt']; if ($dtm['dt'] != $fdate and !empty($rwz["cnt2"][$dtm['dt']])) { $m_uniqs[$dtm['dt']] = $rwz["cnt1"][$dtm['dt']]; $m_hits[$dtm['dt']] = $rwz["cnt2"][$dtm['dt']]; } else { //die(print_r($this->c_uniqs_hits($dtm[1]['dt']))); list($m_uniqs[$dtm['dt']], $m_hits[$dtm['dt']]) = $stats->countVisits($dtm['dt']); } } $sdate = $res['dt']; $i = 0; //mysql_data_seek($r, 0); $max_hits = max($m_hits); foreach ($r->queryAll() as $row) { $dt = $row['dt']; if ($dt != $fdate and isset($rwz["cnt3"][$dt])) { $m_se[$dt] = $rwz["cnt3"][$dt]; $m_other[$dt] = $rwz["cnt4"][$dt]; $m_fix[$dt] = $rwz["cnt5"][$dt]; } else { $m_se[$dt] = $stats->countSearchEngine($dt); $m_other[$dt] = $stats->countOther($dt); if ($stats->fx) { $m_fix[$dt] = $stats->countFix($dt); } else { $m_fix[$dt] = 0; } //if (isset($rwz)) { if ($dt != $fdate and !in_array($dt, $rwz["dt"])) { // die('save'); $sql_insert = "INSERT INTO cms_mainh(dt,cnt1,cnt2,cnt3,cnt4,cnt5) VALUES('" . $dt . "','" . $m_uniqs[$dt] . "','" . $m_hits[$dt] . "','" . $m_se[$dt] . "','" . $m_other[$dt] . "','" . $m_fix[$dt] . "')"; Yii::app()->db->createCommand($sql_insert)->execute(); $sql_del = "DELETE me FROM cms_mainh as me, cms_mainh as clone WHERE me.dt = clone.dt AND me.i > clone.i"; Yii::app()->db->createCommand($sql_del)->execute(); //mysql_query("INSERT INTO mainh(dt,cnt1,cnt2,cnt3,cnt4,cnt5) VALUES('" . $dt . "','" . $m_uniqs[$dt] . "','" . $m_hits[$dt] . "','" . $m_se[$dt] . "','" . $m_other[$dt] . "','" . $m_fix[$dt] . "')"); //mysql_query("DELETE me FROM mainh as me, mainh as clone WHERE me.dt = clone.dt AND me.i > clone.i"); } // } } if ($m_uniqs[$dt] == $m_hits[$dt]) { $graphic = "<img src=/stats/pxu.gif width=" . ceil(372 * $m_uniqs[$dt] / $max_hits) . " height=11 border=0>"; } else { $graphic = "<img src=/stats/pxu.gif width=" . round(372 * $m_uniqs[$dt] / $max_hits) . " height=11 border=0><img src=/stats/pxh.gif width=" . (ceil(372 * $m_hits[$dt] / $max_hits) - ceil(372 * $m_uniqs[$dt] / $max_hits) - 1) . " height=11 border=0>"; } $result[] = array('date' => StatsHelper::$DAY[$row['day']] . StatsHelper::dtconv($dt), 'graphic' => $graphic, 'hosts' => Html::link($m_uniqs[$dt], '/admin/stats/detail/hosts/?date=' . $dt), 'hits' => Html::link($m_hits[$dt], '/admin/stats/detail/hits/?date=' . $dt), 'search' => Html::link($m_se[$dt], '/admin/stats/detail/search/?date=' . $dt), 'sites' => Html::link($m_other[$dt], '/admin/stats/detail/other/?date=' . $dt)); } $dataProvider = new CArrayDataProvider($result, array('sort' => array('attributes' => array('date' => array('asc' => 'date DESC', 'desc' => 'date ASC'))), 'pagination' => array('pageSize' => 10))); $this->render('index', array('dataProvider' => $dataProvider)); }
$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> <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();