Example #1
0
		public static function getByOrderItem($id)
		{
			global $db;
			//get order item from database
			$orderItemSQL = "SELECT * FROM order_items WHERE order_itemid=?";
			$values = array($id);
			$orderItem = $db->qwv($orderItemSQL, $values);
			
			if( $orderItem[0]['isCustomized'] )
			{
				//get customization from database
				$customizationSQL = "SELECT * FROM customizations WHERE order_itemid=?";
				$values = array($orderItem[0]['order_itemid']);
				$customizations = $db->qwv($customizationSQL, $values);
			}
			return Customization::wrap($customizations);
		}