/** * Update a new task: load date and forward to view * * @param Request $request, Task $task * @return view */ public function stats_month(Request $request) { $categories = Countercategory::where('inactive', '!=', '1')->orderBy('name')->get(); //handle categories filter if ($request->category_id) { if ($request->category_id > 0) { $request->session()->put('counter_category_id', $request->category_id); $request->session()->put('counter_category', Countercategory::find($request->category_id)->name); } else { $request->session()->put('counter_category_id', False); $request->session()->put('counter_category', "All Categories"); } } $ses_category = $request->session()->get('counter_category'); $ses_category_id = $request->session()->get('counter_category_id'); //handle months $months = DB::table('counters')->select(DB::raw('distinct CONCAT(YEAR(date), "-", MONTH(date)) AS date'))->orderby('date')->get(); if ($ses_category_id > 0) { $counters = DB::table('counters')->leftjoin('countercategories', 'counters.counter_category_id', '=', 'countercategories.id')->select('counters.id as cid', 'countercategories.name as cname', 'countercategories.id as ccid', DB::raw('extract(month from date) as month'), DB::raw('extract(year from date) as year'), DB::raw('count(counters.id) as items'))->where('counter_category_id', '=', $ses_category_id)->groupBy('month', 'year')->orderBy('date')->get(); } else { $counters = DB::table('counters')->leftjoin('countercategories', 'counters.counter_category_id', '=', 'countercategories.id')->select('counters.id as cid', 'countercategories.name as cname', 'countercategories.id as ccid', DB::raw('extract(month from date) as month'), DB::raw('extract(year from date) as year'), DB::raw('count(counters.id) as items'))->groupBy('month', 'year')->orderBy('date')->get(); } return view('counters.stats_month', ['cats' => $counters, 'categories' => $categories, 'category' => $ses_category]); }
/** * Destroy the given task. * * @param Request $request * @param Task $task * @return Response */ public function destroy(Request $request, Countercategory $countercategory) { $countercategory->delete(); $request->session()->flash('alert-success', 'Counter Category was successful deleted!'); $page = $request->session()->get('countercategories_page'); return redirect('/countercategories?page=' . $page); }