public function run()
{
DB::table('menus')->delete();
DB::table('dish_menu')->delete();
DB::table('recommendations')->delete();
$menu = new Menu();
$menu->menu_date = "2014-03-30";
$menu->save();
foreach (Dish::all() as $dish) {
$menu->dishes()->save($dish);
}
$menu = new Menu();
$menu->menu_date = "2014-04-23";
$menu->save();
foreach (Dish::all() as $dish) {
$menu->dishes()->save($dish);
}
$recommendation = new Recommendation();
$recommendation->menu_id = 1;
$recommendation->recommendation = "Today, we has abcxyz for menu 1";
$recommendation->save();
$recommendation = new Recommendation();
$recommendation->menu_id = 2;
$recommendation->recommendation = "Today, we has abcxyz for menu 2";
$recommendation->save();
}
public function postEditDish($id)
{
/* validate input */
$validator = Validator::make(Input::all(), array("name" => "required|unique:dishes", "price" => "required|integer", "description" => "required"));
/* if validated */
if ($validator->passes()) {
/* get input */
$dish = Dish::find($id);
$dish->name = Input::get("name");
$dish->price = Input::get("price");
$dish->description = Input::get("description");
if (Input::has("new_category")) {
$category = DishCategory::where("name", "=", Input::get("new_category"))->first();
if ($category) {
$dish->dish_category_id = $category->id;
} else {
$category = new DishCategory();
$category->name = Input::get("new_category");
$category->save();
$dish->dish_category_id = $category->id;
}
} else {
$dish->dish_category_id = Input::get("dish_category_id");
}
$dish->save();
return Redirect::to("admin/dish/edit_dish/{$dish->id}")->with('message', 'Dish edited!');
} else {
return Redirect::to("admin/dish/edit_dish/{$dish->id}")->withErrors($validator);
}
// end validation
}
public function postCreateMenu()
{
/* validate input */
$validator = Validator::make(Input::all(), array("menu_date" => "required|date_format:Y-m-d", "dishes" => "required", "recommendation" => "required"));
/* if validated */
if ($validator->passes()) {
/* get input */
$menu = new Menu();
$menu->menu_date = Input::get("menu_date");
$menu->save();
$recommendation = new Recommendation();
$recommendation->menu_id = $menu->id;
$recommendation->recommendation = Input::get("recommendation");
$recommendation->save();
foreach (Input::get('dishes') as $dishId) {
$menu->dishes()->save(Dish::find((int) $dishId));
}
return Redirect::to('admin/menu/create_menu')->with('message', 'Menu added!');
} else {
return Redirect::to('admin/menu/create_menu')->withErrors($validator);
}
// end validation
}
public function postDeleteDish($id = null)
{
if (!isset($id) or is_null($id)) {
return Redirect::to('/admin/dishes');
}
$dish = Dish::find($id);
if (is_null($dish)) {
return Redirect::to('/admin/dishes');
}
$dish->delete();
return Redirect::to('/admin/dishes');
}
<?php
require_once '../admin/classes/connection.class.php';
require_once '../admin/classes/dish.class.php';
?>
<div class="col-md-4">
<h2>Ai-La Special Dishes</h2>
<table class="table table-bordered">
<?php
$featureObj = new Dish();
$view = $featureObj->viewdish();
// echo '<pre>';
// print_r($view);
// echo '<pre>';
?>
<?php
foreach ($view as $value) {
?>
<tr>
<td><?php
echo $value['dish_title'];
?>
</td>
<td><?php
echo $value['dish_price'];
?>
</td>
<?php
require_once '../classes/connection.class.php';
require_once '../classes/dish.class.php';
require_once '../classes/locate.class.php';
if (isset($_POST['submit'])) {
$dish_id = $_POST['dish_id'];
$dish_title = $_POST['title'];
$dish_price = $_POST['price'];
}
$updatedishObject = new Dish();
$updatedishObject->setdishID($dish_id);
$updatedishObject->setdishTitle($dish_title);
$updatedishObject->setdishprice($dish_price);
$flag = $updatedishObject->updatedish();
// echo '<pre>';
// print_r($flag);
// echo '</pre>';
// exit;
if ($flag) {
$_SESSION['dish_updated'] = $err = "The dish has been updated successfully";
new Locate('../index.php?page=dish&action=view');
} else {
$_SESSION['dish_not_updated'] = $err = "The dish couldn't be updated";
new Locate('../index.php?page=dish&action=view');
}
/**
* add a dish order to a delivery
*
* @param $deliveryId
* @param $dishId
* @return \Illuminate\Http\RedirectResponse
*/
public function postAddOrder($deliveryId, $dishId)
{
$delivery = Delivery::find($deliveryId);
$dish = Dish::find($dishId);
// if delivery and dish is not loaded correctly
if (!$delivery || !$dish) {
return Redirect::back()->with('errors', new MessageBag(['An error has occurred.']));
}
// if delivery closed
if (!$delivery->is_active) {
return Redirect::back()->with('errors', new MessageBag(['Delivery already closed.']));
}
// place order
$order = new Order();
// attach to relations
$order->user()->associate(Auth::user());
$order->delivery()->associate($delivery);
$order->dish()->associate($dish);
$order->save();
// messages
$messages = new MessageBag();
$messages->add('success', 'Successfully ordered a dish!');
$messages->add('success', 'The order has been attached to the delivery.');
return Redirect::back()->with('messages', $messages);
}
/**
* Update data of a dish
* @param Dish $dish
*/
public function update(Dish $dish)
{
$query = $this->_db->prepare('UPDATE dish SET name = :name, origin = :origin, time_to_cook = :time_to_cook WHERE dish_id = :dish_id');
$query->execute(array('name' => $dish->getName(), 'origin' => $dish->getOrigin(), 'time_to_cook' => $dish->getTimeToCook(), 'dish_id' => $dish->getDishId()));
}
<?php
require_once 'classes/connection.class.php';
require_once 'classes/dish.class.php';
$viewobj = new Dish();
$views = $viewobj->viewdish();
/*echo '<pre>';
print_r($views);
echo '</pre>';*/
?>
<table class="table" width="698" border="1">
<tbody>
<tr>
<th width="71" scope="row"><strong>dishID</strong></th>
<td width="47"><strong>dish Title</strong></td>
<td width="69"><strong>dish Price</strong></td>
<td colspan="2"><strong>Action</strong></td>
</tr>
<?php
if (sizeof($views > 0)) {
foreach ($views as $value) {
?>
<tr>
<th scope="row"> <?php
echo $value['dish_id'];
public function get_dishdata_by_id($dishid)
{
$dish_data = Dish::findFirst($dishid)->toArray();
return $dish_data;
}
<?php
//require_once('../bootstrap.php');
//session_start();
require_once 'classes/connection.class.php';
require_once 'classes/dish.class.php';
require_once 'classes/locate.class.php';
$dish_id = isset($_GET['dish_id']) ? $_GET['dish_id'] : '';
$objdelete = new Dish();
$objdelete->setdishID($dish_id);
$flag = $objdelete->deletedish();
/*echo $objdelete->sql;
exit;*/
/*echo '<pre>';
print_r($flag);
echo'</pre>';
exit;*/
if ($flag) {
//echo "post already deleted";
new Locate('index.php?page=dish&action=view');
$_SESSION['msg'] = $objdelete->msg = "dish deleted sucessfully";
} else {
header('location:../index.php?page=dish&action=view&err=dishnotdeleted');
}
<?php
session_start();
require_once '../classes/connection.class.php';
require_once '../classes/dish.class.php';
$adddishobj = new Dish();
/*echo '<pre>';
print_r($adddishobj);
echo '</pre>';
exit;
*/
$dish_id = mysqli_real_escape_string($adddishobj->conxn, $_POST['dish_id']);
$dish_title = mysqli_real_escape_string($adddishobj->conxn, $_POST['title']);
$dish_price = mysqli_real_escape_string($adddishobj->conxn, $_POST['price']);
$adddishobj->setdishID($dish_id);
$adddishobj->setdishTitle($dish_title);
$adddishobj->setdishprice($dish_price);
//$adduserobj->setError($er);
//$adduserobj->setMessage($msg);
$adddishobj->adddish();
/*echo '<pre>';
print_r ($adduserobj);
echo '</pre>';
exit;*/
if ($adddishobj) {
header('location:../index.php?page=dish&action=view');
$_SESSION['msg'] = $adddishobj->msg = "The dish has been added sucessfully";
} else {
echo $_SESSION['msg'] = $adddishobj->msg = "Sorry the dish has not been added, please try again later";
}
<?php
include 'classes/connection.class.php';
include 'classes/dish.class.php';
$dish_id = isset($_GET['dish_id']) ? (int) $_GET['dish_id'] : '';
$objdish = new Dish();
$objdish->setdishID($dish_id);
$views = $objdish->viewdish();
/*echo '<pre>';
print_r($views);
echo '</pre>';*/
foreach ($views as $value) {
?>
<form name="form1" method="post" action="process/process_update_dish.php">
<table width="669" border="1">
<tbody>
<tr>
<th colspan="2" scope="row">Please Edit dish</th>
</tr>
<tr>
<th scope="row">Title</th>
<td>
<input type="text" name="title" value="
<?php
echo $value['dish_title'];
?>
"/>
</tr>
<tr>
public function run()
{
DB::table('dish_categories')->delete();
DB::table('dish_images')->delete();
DB::table('dishes')->delete();
$dishCategory = new DishCategory();
$dishCategory->name = "category1";
$dishCategory->save();
$dish = new Dish();
$dish->name = "Boiled Eggs";
$dish->dish_category_id = $dishCategory->id;
$dish->price = 10;
$dish->description = "this is item1 by country1";
$dish->save();
$dishImage = new DishImage();
$dishImage->dish_id = $dish->id;
$dishImage->link = "http://besthomechef.com.au/wp/wp-content/uploads/2012/11/hard-boiled-eggs.jpg";
$dishImage->save();
$dishCategory = new DishCategory();
$dishCategory->name = "category2";
$dishCategory->save();
$dish = new Dish();
$dish->name = "Pancake";
$dish->dish_category_id = $dishCategory->id;
$dish->price = 20;
$dish->description = "this is item2 by country2";
$dish->save();
$dishImage = new DishImage();
$dishImage->dish_id = $dish->id;
$dishImage->link = "http://besthomechef.com.au/wp/wp-content/uploads/2012/11/hard-boiled-eggs.jpg";
$dishImage->save();
$dishCategory = new DishCategory();
$dishCategory->name = "category3";
$dishCategory->save();
$dish = new Dish();
$dish->name = "Pasta Bolognese";
$dish->dish_category_id = $dishCategory->id;
$dish->price = 30;
$dish->description = "this is item3 by country3";
$dish->save();
$dishImage = new DishImage();
$dishImage->dish_id = $dish->id;
$dishImage->link = "http://besthomechef.com.au/wp/wp-content/uploads/2012/11/hard-boiled-eggs.jpg";
$dishImage->save();
$dish = new Dish();
$dish->name = "Beef Stroganoff";
$dish->dish_category_id = $dishCategory->id;
$dish->price = 30;
$dish->description = "this is item3 by country3";
$dish->save();
$dishImage = new DishImage();
$dishImage->dish_id = $dish->id;
$dishImage->link = "http://besthomechef.com.au/wp/wp-content/uploads/2012/11/hard-boiled-eggs.jpg";
$dishImage->save();
$dish = new Dish();
$dish->name = "Beef Wellington";
$dish->dish_category_id = $dishCategory->id;
$dish->price = 30;
$dish->description = "this is item3 by country3";
$dish->save();
$dishImage = new DishImage();
$dishImage->dish_id = $dish->id;
$dishImage->link = "http://besthomechef.com.au/wp/wp-content/uploads/2012/11/hard-boiled-eggs.jpg";
$dishImage->save();
$dish = new Dish();
$dish->name = "Caesar Salad";
$dish->dish_category_id = $dishCategory->id;
$dish->price = 30;
$dish->description = "this is item3 by country3";
$dish->save();
$dishImage = new DishImage();
$dishImage->dish_id = $dish->id;
$dishImage->link = "http://besthomechef.com.au/wp/wp-content/uploads/2012/11/hard-boiled-eggs.jpg";
$dishImage->save();
}
public function dishes()
{
$flash_string = '';
if (Session::exists('account')) {
$flash_string = Session::flash('account');
}
$user = new User();
if ($user->isLoggedIn()) {
//The products table will be rendered on the view page
$dishes = Dish::toArray();
$this->view('account/dishes', ['register' => true, 'loggedIn' => 1, 'flash' => $flash_string, 'name' => $user->data()->name, 'page_name' => 'Dishes', 'dishes' => json_encode($dishes), 'user_id' => $user->data()->id]);
} else {
Session::flash('home', 'You have been logged out, please log back in');
Redirect::to('home');
}
}
/**
* @param int $storeId
*/
private function createNewDish($storeId)
{
$faker = $this->getFakeGenerator();
Dish::create(array('store_id' => $storeId, 'store_dish_id' => $faker->numberBetween(1, 99), 'name' => $faker->word, 'price' => $faker->randomFloat(2, '2.00', '12.99') * 100));
}
