data['title'] = 'Menu Addons'; $this->data['categories'] = \App\MenuCategories::all(); $menu_items = DB::table('menu_items')->where('status',1)->get(); if(!empty($menu_items)){ foreach($menu_items as $row){ $row->prices = DB::table('menu_item_prices')->where('menu_id',$row->id)->get(); } } $this->data['menu_items'] = $menu_items; $default_addons = DB::table('menu_addons_default')->get(); foreach ($default_addons as $row) { $row->menu_addons_details = DB::table('menu_addons_details_default')->where('menu_addon_id',$row->id)->get(); } $this->data['default_addons'] = $default_addons; return view('admin.menu.addons', $this->data); } /* | getMenuItemsByCategory |-------------------------------------------------------------------------- */ public function getMenuItemsByCategory(Request $request) { $currency = env('CURRENCY'); $menuitems = DB::table('menu_item_prices as mp') ->leftJoin('menu_items as mi', 'mi.id', '=', 'mp.menu_id') ->where('mi.category_id',$request->id) ->select('mp.*','mi.menu_item_name')->get(); if(!empty($menuitems)){ ob_start(); ?>
Not found.
data['title'] = 'Assign Addons to Menu Items'; $menu_items = DB::table('menu_items')->where('status',1)->get(); if(!empty($menu_items)){ foreach($menu_items as $row){ $row->prices = DB::table('menu_item_prices')->where('menu_id',$row->id)->get(); } } $this->data['menu_items'] = $menu_items; $default_addons = DB::table('menu_addons_default')->get(); foreach ($default_addons as $row) { $row->menu_addons_details = DB::table('menu_addons_details_default')->where('menu_addon_id',$row->id)->get(); } $this->data['default_addons'] = $default_addons; return view('admin.menu.addons_assign', $this->data); } /* | saveAssignAddons |-------------------------------------------------------------------------- */ public function saveAssignAddons(Request $request) { if($request->menu_item_id != '' && $request->menu_addon_id != ''){ foreach($request->menu_addon_id as $row){ $default_addons = DB::table('menu_addons_default')->where('id',$row)->first(); $default_addons_details = DB::table('menu_addons_details_default')->where('menu_addon_id',$row)->get(); $ma = new \App\MenuAddons; $ma->menu_item_id = $request->menu_item_id; $ma->title = $default_addons->title; $ma->type = $default_addons->type; $ma->save(); foreach($default_addons_details as $row){ $mad = new \App\MenuAddonsDetails; $mad->menu_addon_id = $ma->id; $mad->addon_name = $row->addon_name; $mad->addon_price = $row->addon_price? $row->addon_price : ''; $mad->save(); } } } $request->session()->flash('message', 'Task was successful!'); return back(); } /* | new_addons |-------------------------------------------------------------------------- */ public function new_addons(Request $request) { $this->data['title'] = 'Add New Addons'; $menu_items = DB::table('menu_items')->where('status',1)->get(); if(!empty($menu_items)){ foreach($menu_items as $row){ $row->prices = DB::table('menu_item_prices')->where('menu_id',$row->id)->get(); } } $this->data['menu_items'] = $menu_items; return view('admin.menu.addons_new', $this->data); } /* | save_addons |-------------------------------------------------------------------------- */ public function save_addons(Request $request) { if($request->addontype == 'default'){ $dma = new \App\MenuAddonsDefault; $dma->title = $request->title; $dma->type = $request->type; $dma->save(); $addons = $request->addon_name; foreach($addons as $k => $v){ $dmad = new \App\MenuAddonsDetailsDefault; $dmad->menu_addon_id = $dma->id; $dmad->addon_name = $request->addon_name[$k]; $dmad->addon_price = $request->addon_price[$k]? $request->addon_price[$k] : ''; $dmad->save(); } }else{ $ma = new \App\MenuAddons; $ma->menu_item_id = $request->menu_item_id; $ma->title = $request->title; $ma->type = $request->type; $ma->save(); $addons = $request->addon_name; foreach($addons as $k => $v){ $mad = new \App\MenuAddonsDetails; $mad->menu_addon_id = $ma->id; $mad->addon_name = $request->addon_name[$k]; $mad->addon_price = $request->addon_price[$k]? $request->addon_price[$k] : ''; $mad->save(); } } $request->session()->flash('message', 'Task was successful!'); return back(); } /* | get_addons_by_menu_item |-------------------------------------------------------------------------- */ public function get_addons_by_menu_item(Request $request) { $addons = DB::table('menu_addons')->where('menu_item_id',$request->id)->get(); foreach ($addons as $row) { $row->menu_addons_details = DB::table('menu_addons_details')->where('menu_addon_id',$row->id)->get(); } if(!empty($addons)){ ob_start();?> name?>No Addons against this menu item.
id){ DB::table('menu_addons')->where('id',$request->id)->delete(); $delete_addon_details = DB::table('menu_addons_details')->where('menu_addon_id',$request->id)->delete(); return response()->json($delete_addon_details); } abort(404); } /* | delete_addon_detail |-------------------------------------------------------------------------- */ public function delete_addon_detail(Request $request){ if($request->id){ $delete = DB::table('menu_addons_details')->where('id',$request->id)->delete(); return response()->json($delete); } abort(404); } /* | update_addon |-------------------------------------------------------------------------- */ public function update_addon(Request $request) { if($request->id != ''){ DB::table('menu_addons')->where('id', $request->id)->update(['title'=>$request->title]); $addon = DB::table('menu_addons')->where('id',$request->id)->first(); return response()->json($addon); }else{ return response()->json(false); } } /* | update_addon_detail |-------------------------------------------------------------------------- */ public function update_addon_detail(Request $request) { if($request->id != ''){ DB::table('menu_addons_details')->where('id', $request->id)->update(['addon_name'=>$request->addon_name,'addon_price'=>$request->addon_price]); $menu_addons_details = DB::table('menu_addons_details')->where('id',$request->id)->first(); return response()->json($menu_addons_details); }else{ return response()->json(false); } } /* | new_addon_detail |-------------------------------------------------------------------------- */ public function addNewAddonDetail(Request $request) { if($request->id != ''){ $mad = new \App\MenuAddonsDetails; $mad->menu_addon_id = $request->id; $mad->addon_name = $request->addon_name; $mad->addon_price = $request->addon_price? $request->addon_price : ''; $mad->save(); return response()->json($mad); }else{ return response()->json(false); } } }