function listProducts()
{
global $toC_Json, $osC_Database, $osC_Language;
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$osC_Tax = new osC_Tax_Admin();
$Qtc = $osC_Database->query('select tax_class_id, tax_class_title from :table_tax_class order by tax_class_title');
$Qtc->bindTable(':table_tax_class', TABLE_TAX_CLASS);
$Qtc->execute();
$tax_class_array = array();
while ($Qtc->next()) {
$tax_class_array[$Qtc->valueInt('tax_class_id')] = $osC_Tax->getTaxRate($Qtc->valueInt('tax_class_id'));
}
$Qproducts = $osC_Database->query('select p.products_id, pd.products_name, p.products_tax_class_id from :table_products p, :table_products_description pd where p.products_id = pd.products_id and pd.language_id = :language_id and p.products_type <> :products_type');
$Qproducts->appendQuery(' order by pd.products_name');
$Qproducts->bindTable(':table_products', TABLE_PRODUCTS);
$Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qproducts->bindInt(':language_id', $osC_Language->getID());
$Qproducts->bindInt(':products_type', PRODUCT_TYPE_GIFT_CERTIFICATE);
$Qproducts->setExtBatchLimit($start, $limit);
$Qproducts->execute();
$records = array();
while ($Qproducts->next()) {
$rate = $Qproducts->valueInt('products_tax_class_id') == 0 ? 0 : $tax_class_array[$Qproducts->valueInt('products_tax_class_id')];
$records[] = array('products_id' => $Qproducts->value('products_id'), 'products_name' => $Qproducts->value('products_name'), 'rate' => $rate);
}
$response = array(EXT_JSON_READER_TOTAL => $Qproducts->getBatchSize(), EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
function getTaxClasses()
{
global $toC_Json, $osC_Database, $osC_Language;
require_once 'includes/classes/tax.php';
$osC_Tax = new osC_Tax_Admin();
$Qtc = $osC_Database->query('select tax_class_id, tax_class_title from :table_tax_class order by tax_class_title');
$Qtc->bindTable(':table_tax_class', TABLE_TAX_CLASS);
$Qtc->execute();
$tax_class_array = array(array('id' => '0', 'rate' => '0', 'text' => $osC_Language->get('none')));
while ($Qtc->next()) {
$tax_class_array[] = array('id' => $Qtc->valueInt('tax_class_id'), 'rate' => $osC_Tax->getTaxRate($Qtc->valueInt('tax_class_id')), 'text' => $Qtc->value('tax_class_title'));
}
$response = array(EXT_JSON_READER_ROOT => $tax_class_array);
echo $toC_Json->encode($response);
}
function listProducts()
{
global $toC_Json, $osC_Database, $osC_Language;
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$variants = isset($_POST['variants']) ? $_POST['variants'] : 0;
$osC_Tax = new osC_Tax_Admin();
$Qtc = $osC_Database->query('select tax_class_id, tax_class_title from :table_tax_class order by tax_class_title');
$Qtc->bindTable(':table_tax_class', TABLE_TAX_CLASS);
$Qtc->execute();
$tax_class_array = array();
while ($Qtc->next()) {
$tax_class_array[$Qtc->valueInt('tax_class_id')] = $osC_Tax->getTaxRate($Qtc->valueInt('tax_class_id'));
}
//get the variants products
if ($variants == 1) {
$result = osC_Specials_Admin::getVariantsProducts($start, $limit);
//get the general products
} else {
$result = osC_Specials_Admin::getProducts($start, $limit);
}
$records = array();
if (count($result['products']) > 0) {
foreach ($result['products'] as $product) {
$rate = $product['products_tax_class_id'] == 0 ? 0 : $tax_class_array[$product['products_tax_class_id']];
$records[] = array('products_id' => $product['products_id'], 'products_name' => $product['products_name'], 'rate' => $rate);
}
}
$response = array(EXT_JSON_READER_TOTAL => $result['total'], EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
