/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $menuOption = "analitics"; $restaurant = Restaurant::where('user_id', Auth::user()->id)->first(); $dishes = Dish::where('restaurant_id', $restaurant->id)->get(); $categories = Category::where('restaurant_id', $restaurant->id)->get(); $dishesIds = Dish::where('restaurant_id', $restaurant->id)->lists('id'); $categoriesIds = Category::where('restaurant_id', $restaurant->id)->lists('id'); $dishesAnalytics = Analitic::where('related_table', 'dishes')->whereIn('related_id', $dishesIds)->get(); $firstDay = Analitic::where('related_table', 'dishes')->whereIn('related_id', $dishesIds)->min('date'); $categoriesAnalytics = Analitic::where('related_table', 'categories')->whereIn('related_id', $categoriesIds)->get(); return view('backend.pages.analitics')->with(compact('dishesAnalytics', 'menuOption')); }
function userDishAnalytic() { $input = Input::all(); $analytic = Analitic::where('related_table', 'dishes')->where('related_id', $input['dish_id'])->where('date', Carbon::now())->first(); if (!$analytic) { $analytic = new Analitic(); $analytic->related_table = "dishes"; $analytic->related_id = $input['dish_id']; $analytic->date = Carbon::now(); $analytic->events = 1; if ($analytic->save()) { return Json::success(); } else { return Json::error('error'); } } else { $analytic->events = $analytic->events++; if ($analytic->save()) { return Json::success(); } else { return Json::error('error'); } } }