function getProductBySku($sku)
{
global $database, $logger;
$logger->debug(get_class($this) . "::getProductBySku({$sku})");
$prod = new Product();
$ps_prod = new ps_product();
$ps_cat = new ps_product_category();
$query = "select product_id from #__vm_product where product_sku=" . $sku;
$database->loadQuery($query);
$id = $db->loadResult();
$prod->setOid($id);
$prod->setName($ps_prod->get_field('product_name'));
$prod->setFlypage($ps_prod->get_flypage($id));
$prod->setCategoryId($ps_cat->get_cid($id));
return $prod;
}
public static function generateProducts()
{
//read in xml document(products)
$doc = simplexml_load_file(APPLICATION_PATH . '/../products.xml');
foreach ($doc->category as $cat) {
$categoryObj = new Category();
$categoryObj->setUrlKey($cat->urlkey);
$categoryObj->setName($cat->name);
$categoryObj->save();
}
foreach ($doc->product as $product) {
$productObj = new Product();
$productObj->setName($product->name);
$productObj->setPrice($product->price);
$productObj->setSku($product->sku);
$productObj->setDateCreated(date('d-m-Y H:i:s', time()));
$productObj->setUrlKey($product->urlkey);
$productObj->setProductImage($product->image);
$productObj->setCategoryId($product->category);
$productObj->save();
}
}
<?php
if (!isset($system) || $system != 'yes') {
die("<H2>You are not allowed to view this resource</H2>");
}
//fetch brand_details
$brand_details = $db->get_results("SELECT * FROM brand ORDER BY b_name");
//fetch category_details
$category_details = $db->get_results("SELECT * FROM category ORDER BY c_name");
require_once './classes/class.product.php';
if (isset($_POST['search_product'])) {
$p_b_id = $_POST['p_b_id'];
$p_c_id = $_POST['p_c_id'];
$product = new Product();
$product->setBrandId($p_b_id);
$product->setCategoryId($p_c_id);
$product_details = $product->productinfo();
}
//fetch product_details
/* $product_details=$db->get_results("SELECT * FROM product ORDER BY p_name");
//fetch product_details_qty */
$product_details_qty = $db->get_results("SELECT * FROM product ORDER BY p_name");
if (isset($_POST['search_product'])) {
$all_product_details = $db->get_results("SELECT * FROM product_stock_location WHERE psl_s_id='{$a_s_id}'");
}
