$flush_query = tep_db_query("TRUNCATE TABLE products_bundle");
$flush_query = tep_db_query("UPDATE products SET products_bundle_id=0");
$pids = array();
$q = tep_db_query("SELECT jc.products_id, jc.price, p.products_brand_id FROM jng_sp_catalog jc LEFT JOIN products p ON p.products_id=jc.products_id WHERE jc.jng_sp_id=2 AND jc.active_status='1'");
while ($r = tep_db_fetch_array($q)) {
$products[] = $r;
}
$bundles = array();
$jng_sp_id = 2;
$counter = 0;
$products_attached = array();
foreach ($products as $product) {
if (!in_array($product['products_id'], $products_attached)) {
$counter++;
//$list = $class_pl->retrieveList($pid);
$list = $class_pl->retrieveForCatalog($product, $jng_sp_id, 'C', 7);
$bundle_nd = 'Auto Set ' . $counter;
$bundles[$counter] = new products_bundle();
$bundles[$counter]->create($bundle_nd, $bundle_nd);
$bundles[$counter]->productAdd($product['products_id']);
$products_attached[] = $product['products_id'];
foreach ($list as $l) {
if (!in_array($l['links_id'], $products_attached)) {
$bundles[$counter]->productAdd($l['links_id']);
$products_attached[] = $l['links_id'];
}
}
}
}
echo "{$counter} Bundle is created";
tep_db_close();
if ($p['use_logo'] == '1') {
$brand_id = '';
if ($p['products_brand_id'] == '0') {
$brand_id = $sp_detail['brand_id'];
} else {
if ($p['sp_brand_id'] != '') {
$brand_id = $p['sp_brand_id'];
}
}
if ($brand_id != '') {
$xml_content .= writeXMLline('P_BRAND_ID', $brand_id, 1);
$xml_content .= writeLine();
}
}
//XML PRODUCT LINKS
$product_links = $class_pl->retrieveForCatalog($p, $jng_sp_id, 'C', 20);
$xml_content .= generateXMLproductsLink($product_links, 'CROSS');
$product_links = $class_pl->retrieveForCatalog($p, $jng_sp_id, 'U', 1);
$xml_content .= generateXMLproductsLink($product_links, 'UPSELLING');
$product_links = $class_pl->retrieveForCatalog($p, $jng_sp_id, 'A', 5);
$xml_content .= generateXMLproductsLink($product_links, 'ACCESSORY');
$product_links = $class_pl->retrieveForCatalog($p, $jng_sp_id, 'D', 5);
//$xml_content .= generateXMLproductsLink($product_links, 'DEVICE');
$xml_content .= generateXMLproductsLink($product_links, 'ACCESSORY');
//XML PRODUCT STRUCTURE (Nav IDs)
$xml_content .= writeXMLopen('P_STRUCTURE', 1);
$xml_content .= writeXMLline('STRUCTURE_NAV_ID_PRI', $pri_navid, 2);
if (isset($sec_navid) && is_array($sec_navid) && count($sec_navid) > 0) {
foreach ($sec_navid as $navid) {
$xml_content .= writeXMLline('STRUCTURE_NAV_ID_SEC', $navid, 2);
}
if ($p['categories_id'] == '2') {
$product_images[] = DIR_FS_SUPPORTS . 'AM.VD-ImageAdditional-Necklace.jpg';
}
if (!in_array($p['jng_sp_catalog_id'], $upload_image_log)) {
$upload_image_log[] = $p['jng_sp_catalog_id'];
}
} else {
$nousableimage[] = $p['products_id'];
}
} else {
$nousableimage[] = $p['products_id'];
}
}
//FIND ACCESSORIES USED BY PRODUCT
$product_accessories = array();
$product_accessories = $class_pl->retrieveForCatalog($p, $jng_sp_id, 'A', 5);
if (count($product_accessories) > 0) {
$accessories_data[$p['products_ean']] = $product_accessories;
}
//ADD BRAND DESCRIPTION TO PRODUCT DESCRIPTION
$pdes = nl2br($p['description']);
//if ($brandlist[$p['products_brand_id']]['brand_description']!='') $pdes .= '<br/ ><br/ ><br/ >'.$brandlist[$p['products_brand_id']]['brand_description'];
$xmldata = array();
if ($p['image_uploaded'] == '1' || count($product_images) > 0) {
//OTHER ARTICLES (ADDITIONAL LENGTH, ETC)
//$limit_nonarticle = 50;
//if (!isset($nonarticle)) $nonarticle = 0;
$articles = $product_articles[$p['products_id']];
$articles_total = count($articles);
$total_articles = 1;
if ($articles_total > 0 && !in_array($p['categories_id'], $category_ignore_articles)) {
