/**
* 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;
}
}
