public static function deleteItem($updatePackage)
{
$connect = databaseController::connectToDatabase();
$db = mysqli_real_escape_string($connect, $updatePackage['db']);
$id = mysqli_real_escape_string($connect, $updatePackage['id']);
$idType = mysqli_real_escape_string($connect, $updatePackage['idType']);
$sqlStatement = "DELETE FROM " . $db . " WHERE " . $idType . "= " . $id;
mysqli_query($connect, $sqlStatement);
echo 'deleted';
}
public static function updateItem($updatePackage)
{
$connect = databaseController::connectToDatabase();
$type = mysqli_real_escape_string($connect, $updatePackage['type']);
$db = mysqli_real_escape_string($connect, $updatePackage['db']);
$text = mysqli_real_escape_string($connect, $updatePackage['text']);
$id = mysqli_real_escape_string($connect, $updatePackage['id']);
$idType = mysqli_real_escape_string($connect, $updatePackage['idType']);
$sqlStatement = "UPDATE " . $db . " SET " . $type . "='" . $text . "' WHERE " . $idType . "=" . $id;
mysqli_query($connect, $sqlStatement);
}
public static function itemCreate($createPackage)
{
$connect = databaseController::connectToDatabase();
$restaurantAssociation = $createPackage['associatedRestaurantName'];
$groupAssociation = $createPackage['associatedGroupName'];
$categoryAssociation = $createPackage['associatedCategoryName'];
$name = mysqli_real_escape_string($connect, $createPackage['menuItemName']);
$description = mysqli_real_escape_string($connect, $createPackage['menuItemDescription']);
$price = mysqli_real_escape_string($connect, $createPackage['pricingOption']);
$sqlStatement = "INSERT INTO `ivars235_joomla`.`menuitem` (`iid`, `restaurantassociation`, `groupassociation`, `categoryassociation`, `iname`, `idescription`, `iprice`) VALUES ('','" . $restaurantAssociation . "','" . $groupAssociation . "','" . $categoryAssociation . "','" . $name . "','" . $description . "','" . $price . "')";
mysqli_query($connect, $sqlStatement);
}
public static function userVerify($usertest)
{
$username = $usertest["username"];
$apikey = $usertest["apikey"];
$connect = databaseController::connectToDatabase();
$sqlStatement = "SELECT * from ivars235_joomla.menu_users WHERE username='******' AND apikey='" . $apikey . "'";
$arr = array();
$result = mysqli_query($connect, $sqlStatement);
while ($row = mysqli_fetch_assoc($result)) {
$arr[] = $row;
}
if (count($arr) != 1) {
return false;
} else {
session_start();
$_SESSION["loggedin"] = "loggedin";
echo "clear";
}
}
<?php
/**
* Created by PhpStorm.
* User: eric
* Date: 8/29/2015
* Time: 11:40 AM
*/
$restaurantInfo = databaseController::getRestaurantList();
$groupInfo = databaseController::getGroupList();
$categoryInfo = databaseController::getCategoryList();
?>
<link href="/menuCreator/css/menuitemStyling.css" rel="stylesheet" />
<section class="menuItemCreator menuCreator">
<h2>Welcome To The Restaurant Creator</h2>
<p>From here you can create a new Menu Item. Simply fill in the form below.</p>
<p>In this tool, menu items are defined as the actual items people will order.</p>
<form id="menuItem" name="menuItem" class="menuItem">
<input type="hidden" name="creationType" value="menuitem" />
<label for="associatedRestaurantName">Associated Restaurant Name: </label>
<select id="associatedRestaurantName" class="associatedRestaurantName" name="associatedRestaurantName">
<option value="">Select A Restaurant...</option>
<?php
foreach ($restaurantInfo as $restaurants) {
echo '<option value="' . $restaurants["rid"] . '">' . $restaurants["rname"] . '</option>';
}
foreach ($restaurantInfo as $restaurant) {
$restaurantName = strtolower(str_replace(" ", "-", $restaurant["rname"]));
$restGroups = databaseController::getGroupListByRestaurantId($restaurant["rid"]);
//NEED TO SEPARATE OUT BY CATEGORY WITHIN RESTAURANT
echo '<article data-id="' . $restaurant["rid"] . '" class="restaurantItems ' . $restaurantName . '">';
echo '<h3>' . $restaurant["rname"] . ' Items</h3>';
//SPIT OUT EACH GROUP
foreach ($restGroups as $restGroup) {
$groupID = $restGroup["gid"];
$groupCategories = databaseController::getCategoryListByGroupId($groupID);
echo "<article data-restaurant='" . $restGroup['restaurantassociation'] . "' data-groupID='" . $groupID . "' class='restaurantGroup'>";
echo "<strong>" . $restGroup['gname'] . "</strong><br />";
//SPIT OUT EACH CATEGORY
foreach ($groupCategories as $groupCategory) {
$catID = $groupCategory["cid"];
$menuItems = databaseController::getItemListByCategoryId($catID);
echo "<article data-catID='" . $catID . "'>";
echo "<strong>" . $groupCategory['cname'] . "</strong><br />";
//SPIT OUT EACH MENU ITEM
foreach ($menuItems as $menuItem) {
$menuItem["activeStatus"] == 1 ? $activeStatus = "active" : ($activeStatus = "inactive");
?>
<article class="restaurants mainParent <?php
echo $activeStatus;
?>
" data-groupID="<?php
echo $menuItem["groupassociation"];
?>
" data-restaurantID="<?php
echo $menuItem["restaurantassociation"];
</select>
<select class="groupSep" id="associatedGroupName">
<option>Select A Group...</option>
<?php
foreach ($groupInfo as $group) {
echo '<option style="display:none" data-restaurantassociation="' . $group["restaurantassociation"] . '" value=' . $group["gid"] . '>' . $group["gname"] . '</option>';
}
?>
</select>
<section class="restaurantInfo menuCreator updateContainer">
<?php
foreach ($restaurantInfo as $restaurant) {
$restaurantName = strtolower(str_replace(" ", "-", $restaurant["rname"]));
$catGroups = databaseController::getCategoryListByRestaurantId($restaurant["rid"]);
echo '<article data-restid="' . $restaurant['rid'] . '" class="restaurantCategories ' . $restaurantName . '">';
echo $restaurant["rname"] . " Categories";
foreach ($catGroups as $catGroup) {
?>
<?php
$catGroup["activeStatus"] == 1 ? $activeStatus = "active" : ($activeStatus = "inactive");
?>
<article data-associatedgroup="<?php
echo $catGroup['groupassociation'];
?>
" class="restaurants mainParent <?php
echo $activeStatus;
?>
" data-dbName="menucategory" data-idType="cid" data-neededId="<?php
//TODO: Filter by restaurant
//TODO: CLick on restaurant name first and then refresh the section with that restaurants groups
?>
<link href="/menuCreator/css/menugroupStyling.css" rel="stylesheet" />
<section class="restaurantCreator menuCreator updateContainer">
<h2>Welcome To The Restaurant Creator</h2>
<p>From here you can update your groups to add categories and menu items to. Simply click the edit button next to the desired field.</p>
<section class="groupInfo">
<?php
foreach ($restaurantInfo as $restaurant) {
$restaurantName = strtolower(str_replace(" ", "-", $restaurant["rname"]));
$restGroups = databaseController::getGroupListByRestaurantId($restaurant["rid"]);
echo '<article class="restaurantGroups ' . $restaurantName . '">';
echo $restaurant["rname"] . " Groups";
foreach ($restGroups as $restGroup) {
?>
<?php
$restGroup["activeStatus"] == 1 ? $activeStatus = "active" : ($activeStatus = "inactive");
?>
<article class="restaurants mainParent <?php
echo $activeStatus;
?>
" data-dbName="menugroup" data-idType="gid" data-neededId="<?php
echo $restGroup["gid"];
?>
<?php
/**
* Created by PhpStorm.
* User: eric
* Date: 8/29/2015
* Time: 11:40 AM
*/
$restaurantInfo = databaseController::getRestaurantList();
$groupInfo = databaseController::getGroupList();
?>
<link href="/menuCreator/css/menucategoryStyling.css" rel="stylesheet" />
<section class="menuCategoryCreator menuCreator">
<h2>Welcome To The Restaurant Creator</h2>
<p>From here you can create a new Menu Category to add menu items to. Simply fill in the form below.</p>
<p>In this tool, menu categories are defined as Appetizer, Entrees, Desserts etc...</p>
<form id="menuCategory" name="menuCategory" class="menuCategory">
<input type="hidden" name="creationType" value="menucategory" />
<label for="associatedRestaurantName">Associated Restaurant Name: </label>
<select id="associatedRestaurantName" class="associatedRestaurantName" name="associatedRestaurantName">
<option value="">Select A Restaurant...</option>
<?php
foreach ($restaurantInfo as $restaurants) {
echo '<option value="' . $restaurants["rid"] . '">' . $restaurants["rname"] . '</option>';
}
?>
</select>
<?php
/**
* Created by PhpStorm.
* User: eric
* Date: 8/29/2015
* Time: 11:39 AM
*/
//TODO: Create database table for menugroup
//TODO: Grab Restaurant Names for dropdown
$restaurantInfo = databaseController::getRestaurantList();
?>
<section class="menuGroupCreator menuCreator">
<h2>Welcome To The Restaurant Creator</h2>
<p>From here you can create a new Menu Group to add categories and menu items to. Simply fill in the form below.</p>
<p>In this tool, menu groups are defined as Lunch, Dinner, Fresh Sheet etc...</p>
<form id="menuGroup" name="menuGroup" class="menuGroup">
<input type="hidden" name="creationType" value="menugroup" />
<label for="associatedRestaurantName">Associated Restaurant Name: </label>
<select id="associatedRestaurantName" class="associatedRestaurantName" name="associatedRestaurantName">
<option value="">Select A Restaurant...</option>
<?php
foreach ($restaurantInfo as $restaurants) {
echo '<option value="' . $restaurants["rid"] . '">' . $restaurants["rname"] . '</option>';
}
?>
</select>
public static function getItemListByCategoryId($categoryID)
{
$connect = databaseController::connectToDatabase();
$sql = "SELECT * from ivars235_joomla.menuitem WHERE categoryassociation =" . $categoryID . " ORDER BY ivars235_joomla.menuitem.item_order ASC ";
$arr = array();
$result = mysqli_query($connect, $sql);
while ($row = mysqli_fetch_assoc($result)) {
$arr[] = $row;
}
return $arr;
}
