public static function getByID($oiID) { $db = Database::get(); $data = $db->GetRow("SELECT * FROM VividStoreOrderItems WHERE oiID=?", $oiID); if (!empty($data)) { $item = new OrderItem(); $item->setPropertiesFromArray($data); } return $item instanceof OrderItem ? $item : false; }
public function getOrderItems() { $db = Database::get(); $rows = $db->GetAll("SELECT * FROM VividStoreOrderItems WHERE oID=?", $this->oID); $items = array(); foreach ($rows as $row) { $items[] = OrderItem::getByID($row['oiID']); } return $items; }
public function getOrderItems() { $orders = $this->getResults(); $orderItems = array(); $db = Database::get(); foreach ($orders as $order) { $oID = $order->getOrderID(); $OrderOrderItems = $db->GetAll("SELECT * FROM VividStoreOrderItems WHERE oID=?", $oID); foreach ($OrderOrderItems as $oi) { $oi = VividOrderItem::getByID($oi['oiID']); $orderItems[] = $oi; } } return $orderItems; }