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');
}
}
