function getOrderForUser($user) { $data = array(); $order = DB::query("SELECT * FROM orders WHERE user_id=%s", $user->data["uid"]); $categories = DB::query("SELECT * FROM category_items"); foreach ($order as $o) { $time = $o["time"]; $catname = whereArray($categories, "id", $o["service_id"])["name"]; $address = UserManager::getAddressFor($o["user_id"]); $user = DB::queryOneRow("SELECT * FROM accounts WHERE uid=%s", $o["user_id"]); $items = UserManager::getItemsForCart($o["user_id"], $o["id"]); $address_str = sprintf("%s (%s) <br>%s, %s. %s", $address["street"], $address["apartment"], $address["city"], $address["state"], $address["zip"]); $odata = array($time, $catname, $user["name"], $address_str, $items["html"], $items["price"]); array_push($data, $odata); } return $data; }
public function getOrder($order_id) { $order = DB::queryOneRow("SELECT * FROM orders WHERE user_id=%s and id=%d", $this->id, $order_id); $categories = DB::query("SELECT * FROM category_items"); $time = $order["time"]; $catname = whereArray($categories, "id", $order["service_id"])["name"]; $address = UserManager::getAddressFor($order["user_id"]); $user = DB::queryOneRow("SELECT * FROM accounts WHERE uid=%s", $order["user_id"]); $items = UserManager::getItemsForCart($order["user_id"], $order["id"]); $address_str = sprintf("%s %s \n%s, %s. %s", $address["street"], $address["apartment"], $address["city"], $address["state"], $address["zip"]); return array('time' => $time, 'service' => $catname, 'recipient' => $user['name'], 'phone' => $user['phone'], 'email' => $user['email'], 'address' => $address_str, 'items' => $items['html'], 'price' => $items['price'], 'payment_type' => $order['payment_cc'] ? 'Credit Card' : 'Duke Card'); }