/**
* {@inheritDoc}
*/
public function render()
{
$this->addJs('jquery-ui/jquery-ui.js');
$this->addCss('jquery-ui/jquery-ui.css');
$this->addCss('jquery-ui/jquery-ui.theme.css');
$this->addJs('js/date-picker.js');
$this->addCss('css/datepicker.css');
return $this->makePartial('widget', ['current' => date('Y-m-d'), 'week' => DatePicker::dateAgo('-1 week'), 'month' => DatePicker::dateAgo('-1 month'), 'year' => DatePicker::dateAgo('-1 year')]);
}
public static function processQuery($query, $timestamp, $limit, $cacheKey, $reset = false)
{
$get = Request::all();
if (empty($get)) {
$get = ['from' => DatePicker::dateAgo('-1 week'), 'to' => date('Y-m-d')];
}
$cacheKey .= $get['from'] . $get['to'];
if ($reset) {
Cache::forget($cacheKey);
}
return Cache::remember($cacheKey, GraphReport::getCacheTime(), function () use($query, $timestamp, $limit, $get) {
return $query->where($timestamp, '<=', $get['to'])->where($timestamp, '>=', $get['from'])->take($limit)->get();
});
}
