public function defaultAction() { // Line chart $memcache = new \Memcached(); $stats1 = $memcache->get('stats1'); if ($stats1 === false) { $stats = Stat::select(DB::raw('max(`packages`) as packages'), DB::raw('sum(`added`) as added'), DB::raw('date(`created_at`) as date'))->orderBy('date', 'asc')->groupBy('date')->get(); $stats1 = [['Date', 'Total', 'New']]; foreach ($stats as $stat) { $stats1[] = [$stat->date, (int) $stat->packages, (int) $stat->added]; } $memcache->set('stats1', $stats1, self::DAY); } // Domain table $memcache = new \Memcached(); $stats2 = $memcache->get('stats2'); if ($stats2 === false) { $stats2 = Package::select(['domain', DB::raw('count(domain) as count')])->groupBy('domain')->where('domain', '<>', '')->orderBy('count', 'desc')->get()->toArray(); $memcache->set('stats2', $stats2, self::DAY); } // Types table $memcache = new \Memcached(); $stats3 = $memcache->get('stats3'); if ($stats3 === false || true) { $stats3 = Package::select(['type', DB::raw('count(type) as count')])->groupBy('type')->where('type', '<>', '')->having('count', '>', 9)->orderBy('count', 'desc')->get()->toArray(); $memcache->set('stats3', $stats3, self::DAY); } $this->_setTitle('Stats'); return new StatsView($stats1, $stats2, $stats3); }
public function ajaxSearchPackageTypes() { $data = $this->_getRequest()->query->all(); $type = Arrays::value($data, 'search', ''); $memcache = new \Memcached(); $key = 'searchTypes-' . $type; $searchTypes = $memcache->get($key); if ($searchTypes === false) { $paginate = Package::select('type')->where('type', '<>', '')->where('type', 'like', '%' . $type . '%')->groupBy('type')->orderBy('type', 'asc')->get(); $searchTypes = []; foreach ($paginate as $item) { $searchTypes[] = ['id' => $item->type, 'text' => $item->type]; } $memcache->set($key, $searchTypes, self::WEEK); } return ['results' => $searchTypes, 'lastPage' => 1]; }