PHP MenuItem::where方法代码示例

 public function testMovingNodeNotAffectingOtherMenu()
 {
     $node = MenuItem::where('menu_id', '=', 1)->first();
     $node->down();
     $node = MenuItem::where('menu_id', '=', 2)->first();
     $this->assertEquals(1, $node->getLft());
 }

 public function deleteCategoryInfo($slug)
 {
     $results = \MenuCategory::where('menu_category_slug', '=', $slug)->get();
     foreach ($results as $result) {
         $id = $result->menu_category_id;
     }
     $items_using_cat = \MenuItem::where('menu_item_category_fk', '=', $id)->get();
     foreach ($items_using_cat as $item_using_cat) {
         if ($item_using_cat) {
             return \Redirect::to("admin/category/edit/{$slug}")->with('message', '<div class="alert alert-dismissible alert-danger alert-link">Unable to delete category. Please make sure no items are using this category.</p></div>');
         }
     }
     //if an item exists that has this cat's fk, reload the page with an error
     if (\Auth::check()) {
         \DB::beginTransaction();
         try {
             $statement = \MenuCategory::find($id);
             $statement->delete();
         } catch (ValidationException $e) {
             DB::rollback();
             throw $e;
         }
         \DB::commit();
         return \Redirect::to('admin')->with('message', '<div class="alert alert-dismissible alert-success alert-link">Category has been deleted</p></div>');
     }
     return \Redirect::to('admin');
 }

 public function showSingle($slug)
 {
     $slugs = MenuItem::where('menu_item_slug', '=', $slug)->get();
     foreach ($slugs as $slug) {
         $slug = $slug->menu_item_id;
     }
     return View::make('menu-items.single-item')->withSlug($slug);
 }

 public function getItemInfo($slug)
 {
     $results = \MenuItem::where('menu_item_slug', '=', $slug)->get();
     foreach ($results as $result) {
         $id = $result->menu_item_id;
         $menu_item_name = $result->menu_item_name;
     }
     return \View::make('menu-items.delete')->withSlug($slug)->withMenuItemName($menu_item_name);
 }

 public function nameToSlug($validated)
 {
     $slug = \Input::get('name');
     $slug = preg_replace('#[ -]+#', '-', $slug);
     $slug = strtolower($slug);
     $results = \MenuItem::where('menu_item_slug', '=', $slug)->get(array('menu_item_slug', 'menu_item_id'));
     $slug_check = "";
     foreach ($results as $result) {
         $slug_check = $result->menu_item_slug;
     }
     if ($slug_check !== $slug) {
         return true;
     }
     return false;
 }

 public function returnAllMenuInfo($slug)
 {
     $results = \MenuItem::where('menu_item_slug', '=', $slug)->get(array('menu_item_description', 'menu_item_picture_uri', 'menu_item_name', 'menu_item_slug', 'menu_item_id', 'menu_item_category_fk', 'menu_item_short', 'menu_item_price'));
     foreach ($results as $result) {
         $menu_item_description = $result->menu_item_description;
         $menu_item_name = $result->menu_item_name;
         $menu_item_picture_uri = $result->menu_item_picture_uri;
         $menu_item_id = $result->menu_item_id;
         $slug = $result->menu_item_slug;
         $menu_item_category_fk = $result->menu_item_category_fk;
         $menu_item_short = $result->menu_item_short;
         $menu_item_price = $result->menu_item_price;
     }
     function getCategories()
     {
         $category = array();
         $categories = \MenuCategory::get();
         foreach ($categories as $cat) {
             $cat_name = $cat->menu_category_name;
             $cat_id = $cat->menu_category_id;
             $category[$cat_id] = $cat_name;
         }
         return $category;
     }
     function getDefault($menu_item_category_fk)
     {
         $results = \MenuCategory::where('menu_category_id', '=', $menu_item_category_fk)->get(array('menu_category_id'));
         foreach ($results as $result) {
             $category = $result->menu_category_id;
         }
         return $category;
     }
     $categories = getCategories();
     $default = "";
     if (isset($menu_item_category_fk)) {
         $default = getDefault($menu_item_category_fk);
     }
     if (\Auth::check()) {
         if (!isset($menu_item_description)) {
             return \Redirect::to('admin');
         }
         return \View::make('menu-items.edit')->withMenuItemDescription($menu_item_description)->withMenuItemPictureUri($menu_item_picture_uri)->withMenuItemName($menu_item_name)->withMenuItemShort($menu_item_short)->withSlug($slug)->withCategories($categories)->withDefault($default)->withMenuItemPrice($menu_item_price);
     }
     return \Redirect::to('admin');
 }

 public function checkNameMatch($slug)
 {
     $get_name = \MenuItem::where('menu_item_slug', '=', $slug)->get(array('menu_item_name'));
     foreach ($get_name as $name) {
         $name = $name->menu_item_name;
     }
     //-----------
     $nameprep = \Input::get('name');
     $nameprep = preg_replace('#[ -]+#', '-', $nameprep);
     $nameprep = strtolower($nameprep);
     //------------
     $name_check = \MenuItem::where('menu_item_slug', '=', $nameprep)->get(array('menu_item_name'));
     foreach ($name_check as $get_name) {
         $name_check = $get_name->menu_item_name;
     }
     $result = strcasecmp($name, $name_check);
     if ($result === 0) {
         return true;
     }
     return false;
 }

 public function getallmenus()
 {
     $menuliist = MenuItem::where("menu", Input::get("menu"))->orderBy("label", "asc")->lists("label", "id");
     $menuliist[0] = "Select parent";
     $html = '	<label for="label">MenuItem</label>';
     $html .= Form::select('parent', $menuliist, Input::get("parent"), array("class" => "form-control", "id" => "parentselect"));
     return $html;
 }

 public function updateMenuItem($slug)
 {
     $validate = new Validate();
     $validator = $validate->Validate();
     if (\Auth::check()) {
         $check = new CheckEditedItem();
         $slugcheck = $check->checkSlugMatch($slug);
         $namecheck = $check->checkNameMatch($slug);
         $idcheck = $check->checkIdMatch($slug);
         $results = \MenuItem::where('menu_item_slug', '=', $slug)->get(array('menu_item_description', 'menu_item_picture_uri', 'menu_item_name', 'menu_item_slug', 'menu_item_id', 'menu_item_short', 'menu_item_category_fk', 'menu_item_price'));
         foreach ($results as $result) {
             $menu_item_description = $result->menu_item_description;
             $menu_item_name = $result->menu_item_name;
             $menu_item_picture_uri = $result->menu_item_picture_uri;
             $slug = $result->menu_item_slug;
             $id = $result->menu_item_id;
             $menu_item_short = $result->menu_item_short;
             $menu_item_category_fk = $result->menu_item_category_fk;
             $menu_item_price = $result->menu_item_price;
         }
         if ($validator->fails()) {
             return \Redirect::back()->withErrors($validator);
         }
         if ($idcheck === true) {
             \DB::beginTransaction();
             try {
                 $slug = strtolower($slug);
                 $statement = \MenuItem::find($id);
                 $statement->menu_item_description = \Input::get('description');
                 if (\Input::hasFile('Upload')) {
                     $name = \Input::file('Upload')->getClientOriginalName();
                     \Input::file('Upload')->move('uploads', $name);
                     $statement->menu_item_picture_uri = '/uploads/' . $name;
                 }
                 $statement->menu_item_short = \Input::get('desc');
                 $statement->menu_item_price = \Input::get('price');
                 $statement->menu_item_category_fk = \Input::get('category');
                 $statement->save();
             } catch (ValidationException $e) {
                 DB::rollback();
                 throw $e;
             }
             \DB::commit();
             return \Redirect::to('admin/edit/' . $slug)->with('message', '<div class="alert alert-dismissible alert-success alert-link"><button type="button" class="close" data-dismiss="alert">×</button>Saved at: ' . link_to('/menu/' . $slug) . '</p></div>');
         }
         if ($slugcheck === false || $namecheck === false) {
             $slug = \Input::get('name');
             $slug = preg_replace('#[ -]+#', '-', $slug);
             $slug = strtolower($slug);
             $results = \MenuItem::where('menu_item_slug', '=', $slug)->get(array('menu_item_id'));
             foreach ($results as $result) {
                 $check_id = $result->menu_item_id;
             }
             if (isset($check_id)) {
                 return \Redirect::back()->withErrors($validator)->withInput(array('name', 'description', 'category', 'desc', 'price'))->with('message', '<p class="alert alert-dismissible alert-danger alert-link">An item with the same name already exists');
             }
             \DB::beginTransaction();
             try {
                 $statement = \MenuItem::find($id);
                 $statement->menu_item_name = \Input::get('name');
                 $statement->menu_item_description = \Input::get('description');
                 if (\Input::hasFile('Upload')) {
                     $name = \Input::file('Upload')->getClientOriginalName();
                     \Input::file('Upload')->move('uploads', $name);
                     $statement->menu_item_picture_uri = '/uploads/' . $name;
                 }
                 $statement->menu_item_slug = $slug;
                 $statement->menu_item_price = \Input::get('price');
                 $statement->menu_item_short = \Input::get('desc');
                 $statement->menu_item_category_fk = \Input::get('category');
                 $statement->save();
             } catch (ValidationException $e) {
                 DB::rollback();
                 throw $e;
             }
             \DB::commit();
             return \Redirect::to('admin/edit/' . $slug)->with('message', '<div class="alert alert-dismissible alert-success alert-link"><button type="button" class="close" data-dismiss="alert">×</button>Saved at: ' . link_to('/menu/' . $slug) . '</p></div>');
         }
         return \Redirect::to('admin/edit/' . $slug)->withErrors($validator)->withInput(array('name', 'description', 'category', 'desc', 'price'))->with('message', '<p class="alert alert-dismissible alert-danger alert-link">An item with the same name already exists');
     }
 }