public static function unsubscribe($id) { $idsToDelete = Lunch::byUser($id)->get()->lists('id'); Lunch::whereIn('id', $idsToDelete)->delete(); Sub::whereIn('lunch_id', $idsToDelete)->delete(); return ['delete' => $idsToDelete]; }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('lunchs')->delete(); for ($i = 0; $i < count($this->items); $i++) { $row = array_combine(['name', 'description', 'meal1_id', 'meal2_id', 'garnish_id', 'salad_id', 'drink_id', 'price', 'image'], $this->items[$i]); $lunch = Lunch::create($row); $lunch->additions()->attach([1, 2, 3]); } }
/** * Show the form for edit subscription * * @return Response */ public function showSubs($id) { $lunchs = Lunch::with('meal1', 'meal2', 'garnish', 'salad', 'drink', 'additions')->where('user_id', 0)->get(); $meal1 = Meal1::all(); $meal2 = Meal2::all(); $garnishs = Garnish::all(); $salads = Salad::all(); $drinks = Drink::all(); $additions = Addition::all(); $user = User::findOrFail($id); $subs = Sub::with('lunch.meal1', 'lunch.meal2', 'lunch.garnish', 'lunch.salad', 'lunch.drink')->byUser($id)->get(); $daysOfWeek = trans('vars.day_of_week'); return view('admin.subs.save', compact('user', 'subs', 'lunchs', 'meal1', 'meal2', 'garnishs', 'salads', 'drinks', 'additions', 'daysOfWeek')); }
/** * Show the application welcome screen to the user. * * @return Response */ public function index() { $lunchs = Lunch::whereUserId(NULL)->with('meal1', 'meal2', 'garnish', 'salad', 'drink', 'additions')->get(); $meal1 = Meal1::all(); $meal2 = Meal2::all(); $garnishs = Garnish::all(); $salads = Salad::all(); $drinks = Drink::all(); $additions = Addition::all(); $daysOfWeek = trans('vars.day_of_week'); $subs = Auth::user() ? Sub::with('lunch.meal1', 'lunch.meal2', 'lunch.garnish', 'lunch.salad', 'lunch.drink', 'lunch.additions')->byUser(Auth::user()->id)->get() : false; $user = Auth::user() ? User::with('contact')->find(Auth::user()->id) : false; $lunchCount = 3; $menuCount = 5; return view('app', compact('user', 'subs', 'lunchs', 'meal1', 'meal2', 'garnishs', 'salads', 'drinks', 'additions', 'daysOfWeek', 'lunchCount', 'menuCount')); }
public function saveInfo(Lunch $item, Request $request) { $item->saveImage($item, $request); $additionList = $request->input('addition_list') ?: []; $item->additions()->sync($additionList); }