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']);
}
