/** * Function is used to check the product sku * * * @return array */ function checkProductSku() { include 'classes/Core/Settings/CManageProducts.php'; echo Core_Settings_CManageProducts::checkProductSku(); }
/** * Function gets the product details and sub category details for the selected product id. * * * @return string */ function editSubCategory() { $id = $_GET['prodid']; if ((int) $id > 0) { $sql = 'select * from products_table where product_id=' . $id; $obj = new Bin_Query(); $obj->executeQuery($sql); $sqlid = "SELECT category_id,category_parent_id FROM category_table where category_id in(select category_id from products_table where category_id='" . $obj->records[0]['category_id'] . "')"; $query = new Bin_Query(); $query->executeQuery($sqlid); $category = Core_Settings_CManageProducts::displayCategory($query->records[0]['category_parent_id']); $sqlid = 'select category_id from category_table where category_id in(select sub_category_id from products_table where product_id=' . $id . ')'; $query = new Bin_Query(); $query->executeQuery($sqlid); $subcat = Core_Settings_CManageProducts::displaySubCategory($query->records[0]['category_id']); return $subcat; } }