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