AAAAacademiac/www/administrator/components/com_csvi/models/fields/csvivirtuemartorderitemproduct.php000060400000003505151466410100030641 0ustar00homeinput; $template = $jinput->get('template', null, null); $db = JFactory::getDbo(); $products = $template->get('orderitemproduct', 'orderitem', array(), null); $skus = implode(',', $products); if (!empty($skus)) { foreach ($products as $pkey => $product) { $products[$pkey] = $db->Quote($product); } $q = "SELECT DISTINCT product_sku, product_name FROM #__virtuemart_products p, #__virtuemart_order_items o WHERE p.virtuemart_product_id = o.virtuemart_product_id AND p.product_sku IN (".skus.") ORDER BY product_name;"; $db->setQuery($q); $orderitemproducts = $db->loadObjectList(); if (empty($orderitemproducts)) $orderitemproducts = array(); return array_merge(parent::getOptions(), $orderitemproducts); } else return parent::getOptions(); } } ?>