function returnOrderedFeed($t, $s, $f, $c) { if ($t == -1 | $s == -1 | $c == -1) { return ""; } $service = DB::queryOneRow("SELECT id FROM categories WHERE id=%s", $s); $companies = DB::query("SELECT name, id, category_id FROM category_items WHERE category_id=%s AND id=%d", $service["id"], $c); $orders = array(); $now = new DateTime("now"); $addressCache = array(); foreach ($companies as $company) { if ($company["name"]) { $q = DB::query("SELECT * FROM orders WHERE service_id=%s AND category_id=%s", $company["category_id"], $company["id"]); } foreach ($q as $order) { if (!array_key_exists($order["user_id"], $addressCache)) { $addressCache[$order["user_id"]] = UserManager::getAddressFor($order["user_id"]); } $addr = refineArray(array($addressCache[$order["user_id"]]), array("street", "apartment", "city", "state", "zip"))[0]; $di = $now->diff(new DateTime($order["time"])); if ($di->d <= $t) { $items = UserManager::getItemsForCart($order["user_id"], $order["id"]); //$order["cart_id"]); $userdata = DB::queryOneRow("SELECT * FROM accounts WHERE uid=%s", $order["user_id"]); $userdata = refineArray(array($userdata), array("name", "email", "phone"))[0]; $nonOrderedOrder = array_merge($order, array_merge(array("compName" => $company["name"], "items" => $items["html"], "price" => $items["price"]), $addr, $userdata)); $sortOrder = array("time", "compName", 5, 6, 7, 0, 1, 2, 3, 4, "items", "price"); $nonOrderedOrder_trimmed = refineArray(array($nonOrderedOrder), $sortOrder)[0]; // time, restname, username, email, phone, street, apt, city, state, zip, items, total // array_multisort($nonOrderedOrder_trimmed, $sortOrder); $orderedOrder = $nonOrderedOrder_trimmed; $orderedOrder["category_id"] = $nonOrderedOrder["category_id"]; $orderedOrder["campus"] = $nonOrderedOrder["campus"]; $orderedOrder["timeSince"] = $di->d; $orders[] = $orderedOrder; } } } $keys = array("category_id", "timeSince", "campus"); $orders = array_orderby($orders, $keys[$f - 1], SORT_ASC); $orders = refineArrayReductively($orders, array("category_id", "campus", "timeSince")); return $orders; // t = time, s = service, f = filter, c = company }
<input type="button" class="setting-save-text" value="Save"> </div>'; $html_2 = ' <form class="ulform" enctype="multipart/form-data" id="setting-%s" action="/includes/accounts/exec-admin-change-setting.php" method="POST"> <span class="setting-name">%s:</span> <img height="150px" width="200px" class="setting-value" src="images/%s"> <input type="hidden" name="type" value="2"> <input type="hidden" name="name" value="None"> <input name="userfile" type="file" /> <input type="submit" class="setting-save" value="Upload"> </form>'; $settings_1 = DB::query("SELECT name, display, value FROM settings WHERE type=1"); $settings_1 = refineArray($settings_1, array("name", "display", "value")); echo htmlLoop($settings_1, "", $html_1, ""); $settings_2 = DB::query("SELECT name, display, value FROM settings WHERE type=2"); $settings_2 = refineArray($settings_2, array("name", "display", "value")); echo htmlLoop($settings_2, "", $html_2, ""); ?> <script> // change setting $(".ulform").each(function(i){ var name = $(this).attr("id").split("-")[1] $(this).children('input[name=name]').val(name); }) $(".setting-save-text").on('click', function(e){ var parent = $(this).parent() var name = $(parent).attr("id").split("-")[1]
function displayAdminSettingsPage() { $html_1 = ' <div id="setting-%s"> <span class="setting-name">%s:</span> <span class="setting-value">%s</span> <input type="text" class="setting-value-input" placeholder="New Value"> <input type="button" class="setting-save-text" value="Save"> </div>'; $html_2 = ' <form class="ulform" enctype="multipart/form-data" id="setting-%s" action="/includes/accounts/exec-admin-change-setting.php" method="POST"> <span class="setting-name">%s:</span> <img height="150px" width="200px" class="setting-value" src="images/%s"> <input type="hidden" name="type" value="2"> <input type="hidden" name="name" value="None"> <input name="settingsfile" type="file" /> <input type="submit" class="setting-save" value="Upload"> </form>'; $settings_1 = DB::query("SELECT name, display, value FROM settings WHERE type=1"); $settings_1 = refineArray($settings_1, array("name", "display", "value")); echo htmlLoop($settings_1, "", $html_1, ""); $settings_2 = DB::query("SELECT name, display, value FROM settings WHERE type=2"); $settings_2 = refineArray($settings_2, array("name", "display", "value")); echo htmlLoop($settings_2, "", $html_2, ""); }