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