public static function getFoodById($id)
{
self::$db = Database::getDB();
$query = "select * from food where Food_id='{$id}'";
$result = self::$db->query($query);
$item = $result->fetch();
$food = new Food($item["Food_Catagory"], $item["Food_Price"], $item["Food_Instock"], $item["Food_description"], $item["Food_mark"], $item["Food_Name"], $item["Food_Image"], $item["Discount_price"], $item["Viewed_times"], $item["Sales_volume"]);
$food->setId($item["Food_id"]);
return $food;
}
public static function getfood($food_id)
{
global $db;
$query = "SELECT * FROM foods WHERE foodID = {$food_id}";
$result = $db->query($query);
$row = $result->fetch();
$category = CategoryRepository::getCategory($row['categoryID']);
$food = new Food($row['calories'], $row['foodTitle'], $row['foodPrice'], $category);
$food->setId($row['foodID']);
return $food;
}
public static function Page($array)
{
$log_user = Tool::getLoginUser();
if ($array[0] == CREATE) {
header("Location:../?menu=" . PAGE_FOOD . "&" . VIEW . "=" . CREATE);
} elseif ($array[0] == EDIT) {
$food = new Food();
$food->setId($_GET['id']);
$food->readDatabase();
SessionHandlers::saveSession($user, 'edit_food');
header("Location:../?menu=" . PAGE_FOOD . "&" . VIEW . "=" . EDIT);
} elseif ($array[0] == SHOWHIDE) {
header("Location:../?menu=" . PAGE_FOOD . "&cache=" . $_GET['cache']);
} elseif ($array[0] == REFRESH) {
header("Location:../?menu=" . PAGE_FOOD);
} elseif ($array[0] == FRAME) {
$food = new Food();
//print_r($food->readDatabaseAll ());
SessionHandlers::saveSession($food->readDatabaseAll(), 'foodList');
header("Location:../?menu=" . PAGE_FOOD . "&" . VIEW . "=" . FRAME);
} else {
echo "page not found";
}
exit;
}
