public function getStatistic()
{
$result = ViewPage::select(DB::raw("COUNT(id) AS count_view, DATE_FORMAT(`created_at`, '%Y-%m-%d') as this_day"))->where("model", 'like', Input::get("model"))->where("id_record", Input::get("idPage"))->where("created_at", ">=", Input::get("start"))->where("created_at", "<=", Input::get("end") . " 23:59:59")->groupBy('this_day')->get();
foreach ($result as $k => $r) {
$data[$k]['label'] = $r->this_day;
$data[$k]['value'] = $r->count_view;
}
if (!isset($data)) {
$data[0]['label'] = "нет просмотров";
$data[0]['value'] = "0";
}
return json_encode($data);
}
public function setView()
{
ViewPage::create(array("model" => get_class($this), "id_record" => $this->id));
}
