exit;
}
if (!$is_directdownload) {
echo '<html>';
echo '<body>';
echo '<h1>CAT XML Generator</h1>';
echo '<div>';
}
$bgst = Product::getOldProductFunction()->retrieveBestGoodSettings();
$hide_extreme_flag = $bgst['hidenostock_xtreme'] == '1';
$hide_hard_flag = $bgst['hidenostock_hard'] == '1';
$hide_nostock_flag = $bgst['hidenostock_somesp'] == '1';
$products_stock = Product::getOldProductFunction()->stockRetrieveAll(WAREHOUSE_ID_PRODUCTS_HAMBURG);
if ($is_use_new_function) {
$sp = new SalesPartner($jng_sp_id);
$products = $sp->getProductsCatalog($catalog_status, $category_top_id);
/* For Direct Testing (Don't forget also comment ...$sp->getProductsCatalog... above)
$products_id = '53727,53773,54197,54864,61608,61759,62014';
$products = $sp->getProductsCatalogByProductsID($catalog_status, $category_top_id, $products_id);
*/
} else {
$products = $class_jc->retrieveCatalogForUpload($jng_sp_id);
//$products = $class_jc->retrieveCatalogForUpload($jng_sp_id,false,"jc.products_id IN (74458,74459,74468,74469,74470,74482,74484,73637,73664,73672,73694,73699,73700,73701,73705,73710,73713,73720,73733,73735,73737,73826,74142,74155,74156,74159,74165,74171,74177,74183,74187,74190,74574,74683)");
}
$total_products_exported = count($products);
if ($total_products_exported == 0) {
$content = 'There is no active product to be exported';
} else {
$error = false;
//EAN IS NOW A REQUIREMENT FOR ALL SP, SO MUST CHECK FOR ALL FIRST
$product_articles = array();
use_class('ProductAttribute');
use_class('jng_sp_orders');
use_class('elements_stock');
use_class('elements_order');
$class_s = new styles();
$class_jo = new jng_sp_orders();
$class_es = new elements_stock();
//$class_pb = new products_brand();
$class_pm = new products_minierp();
//$class_jc = new jng_sp_catalog();
//$class_do = new depot_orders();
//$class_pmat = new products_materials();
//$class_pa = new products_articles();
//$class_e = new element();
$sp = new SalesPartner('1004');
$sp->getProductsCatalog('all', '1');
/*
$prev_month_day_start = date('Y-m-01 00:00:00', strtotime(date('Y-m')." -2 month"));
$prev_month_day_end = date('Y-m-t 23:59:59', strtotime($prev_month_day_start));
echo $prev_month_day_start;
echo $prev_month_day_end;
*/
//$pid_array = array('74487','51215','74668');
/*
$pq = "SELECT pd.products_id, pd2.diamond_total_weight FROM products_description pd";
$pq .= " LEFT JOIN jng_sp_catalog jc ON jc.products_id = pd.products_id";
$pq .= " LEFT JOIN products_description2 pd2 ON pd2.products_id = pd.products_id";
$pq .= " LEFT JOIN products p ON p.products_id = pd.products_id";
//$pq .= " WHERE jc.jng_sp_id = 5 AND pd.language_id = 2 AND p.active_status = 1 AND jc.active_status = 1";
$pq .= " WHERE pd.language_id = 2 AND p.active_status = 1 AND jc.active_status = 1";
//$pq .= " WHERE pd.language_id = 2 AND p.active_status = 1 AND jc.active_status = 1 AND pd.products_id = '73637'";
