function listVariantsSpecials()
{
global $toC_Json, $osC_Language, $osC_Database;
require_once 'includes/classes/currencies.php';
$osC_Currencies = new osC_Currencies();
$osC_CategoryTree = new osC_CategoryTree_Admin();
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$search = !empty($_REQUEST['search']) ? $_REQUEST['search'] : null;
$manufacturers_id = !empty($_REQUEST['manufacturers_id']) ? $_REQUEST['manufacturers_id'] : null;
$current_category_id = end(explode('_', empty($_REQUEST['category_id']) ? 0 : $_REQUEST['category_id']));
$in_categories = array();
if ($current_category_id > 0) {
$osC_CategoryTree->setBreadcrumbUsage(false);
$in_categories = array($current_category_id);
foreach ($osC_CategoryTree->getTree($current_category_id) as $category) {
$in_categories[] = $category['id'];
}
}
//get the variants specials
$result = osC_Specials_Admin::getVariantsSpecials($start, $limit, $in_categories, $search, $manufacturers_id);
$records = array();
if (count($result['special_products']) > 0) {
foreach ($result['special_products'] as $special_product) {
$records[] = array('specials_id' => $special_product['specials_id'], 'products_id' => $special_product['products_id'], 'products_name' => $special_product['products_name'], 'products_price' => $special_product['products_price'], 'specials_new_products_price' => '<span class="oldPrice">' . $osC_Currencies->format($special_product['products_price']) . '</span> <span class="specialPrice">' . $osC_Currencies->format($special_product['variants_specials_price']) . '</span>');
}
}
$response = array(EXT_JSON_READER_TOTAL => $result['total'], EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
