public function saveAction()
{
$url = $this->_getParam('url');
$toy_id = $this->_getParam('toy_id');
$data = array('clicks_datetime' => time() + 10 * 60 * 60, 'clicks_url' => $url, 'clicks_toy_id' => $toy_id, 'clicks_user_uid' => USER_UID);
$Clicks = new Clicks();
$Clicks->insert($data);
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
}
public function showClicksAction()
{
$period_type = $this->_getParam('period_type');
$period_type = $period_type ? $period_type : 1;
// today as default
$this->view->period_type = $period_type;
$this->view->ar_periods = array('1' => 'Сегодня', '2' => 'Вчера', '3' => 'Позавчера', '4' => 'За неделю', '5' => 'За 2 недели');
switch ($period_type) {
case 1:
$t = time() + 10 * 60 * 60;
$date_begin = strtotime(date('Y', $t) . '/' . date('m', $t) . '/' . date('d', $t) . ' 00:00:01');
$date_end = strtotime(date('Y', $t) . '/' . date('m', $t) . '/' . date('d', $t) . ' 23:59:59');
break;
case 2:
$t = time() + 10 * 60 * 60 - 24 * 60 * 60;
$date_begin = strtotime(date('Y', $t) . '/' . date('m', $t) . '/' . date('d', $t) . ' 00:00:01');
$date_end = strtotime(date('Y', $t) . '/' . date('m', $t) . '/' . date('d', $t) . ' 23:59:59');
break;
case 3:
$t = time() + 10 * 60 * 60 - 24 * 60 * 60 * 2;
$date_begin = strtotime(date('Y', $t) . '/' . date('m', $t) . '/' . date('d', $t) . ' 00:00:01');
$date_end = strtotime(date('Y', $t) . '/' . date('m', $t) . '/' . date('d', $t) . ' 23:59:59');
break;
case 4:
$t1 = time() + 10 * 60 * 60 - 24 * 60 * 60 * 7;
$t2 = time() + 10 * 60 * 60;
$date_begin = strtotime(date('Y', $t1) . '/' . date('m', $t1) . '/' . date('d', $t1) . ' 00:00:01');
$date_end = strtotime(date('Y', $t2) . '/' . date('m', $t2) . '/' . date('d', $t2) . ' 23:59:59');
break;
case 5:
$t1 = time() + 10 * 60 * 60 - 24 * 60 * 60 * 7 * 2;
$t2 = time() + 10 * 60 * 60;
$date_begin = strtotime(date('Y', $t1) . '/' . date('m', $t1) . '/' . date('d', $t1) . ' 00:00:01');
$date_end = strtotime(date('Y', $t2) . '/' . date('m', $t2) . '/' . date('d', $t2) . ' 23:59:59');
break;
case 6:
break;
}
$Clicks = new Clicks();
$clicks = $Clicks->get_clicks($date_begin, $date_end);
$this->view->date_begin = $date_begin;
$this->view->date_end = $date_end;
$this->view->clicks = $clicks;
//echo date('d.m.Y H:i:s',$date_begin)."<br>";
//echo date('d.m.Y H:i:s',$date_end);
//exit;
//SELECT date(from_unixtime( 1314262160 ) )
}
