if ($_POST['me_action'] == 'SEARCHPRODUCTS') {
$keywords = tep_db_prepare_input($_POST['keywords']);
if ($keywords == '') {
unset($_SESSION['sp-products-finalize']['keywords']);
} else {
$_SESSION['sp-products-finalize']['keywords'] = $keywords;
}
} elseif ($_POST['me_action'] == 'UPDATEACTIVESTATUS') {
//first deactivate all products in the current page
$all_cids = explode(',', tep_db_prepare_input($_POST['cids']));
$cids_to_activate = isset($_POST['cb_product']) && is_array($_POST['cb_product']) ? $_POST['cb_product'] : array();
foreach ($all_cids as $cid) {
$catalog = $class_jc->retrieveDetail($cid);
if (in_array($cid, $cids_to_activate)) {
if ($catalog['active_status'] != '1') {
$class_jc->activateProduct($cid);
}
} else {
if ($catalog['active_status'] != '0') {
$class_jc->deactivateProduct($cid);
}
}
}
}
}
if (isset($_GET['delete']) && $_GET['delete'] != '') {
$jng_sp_catalog_id = tep_db_prepare_input($_GET['delete']);
$delete_check = tep_db_query("SELECT jng_sp_catalog_id FROM jng_sp_catalog WHERE jng_sp_catalog_id={$jng_sp_catalog_id}");
if (tep_db_num_rows($delete_check) == 0) {
$messagebox->add('1 Product is successfully removed from database.');
}
$product_ids[] = 32316;
$product_ids[] = 32317;
$product_ids[] = 32314;
$product_ids[] = 32315;
//var_dump($product_ids);die();
$added_to_catalog = 0;
$activated = 0;
$deactivated = 0;
foreach ($product_ids as $product_id) {
$check_query = tep_db_query("SELECT jng_sp_catalog_id, active_status FROM jng_sp_catalog WHERE jng_sp_id=2 AND products_id={$product_id}");
if (tep_db_num_rows($check_query) == 0) {
$insert_id = $class_jc->addProduct('2', $product_id);
if ($insert_id > 0) {
$added_to_catalog++;
}
} else {
$cat = tep_db_fetch_array($check_query);
if ($cat['active_status'] == '0') {
$class_jc->activateProduct($cat['jng_sp_catalog_id']);
$activated++;
} else {
$class_jc->deactivateProduct($cat['jng_sp_catalog_id']);
$deactivated++;
}
}
}
echo "Success add {$added_to_catalog} to OTTO product_catalog";
echo '<br />';
echo "Success activating {$activated} OTTO product_catalog";
echo '<br />';
echo "Success deactivating {$deactivated} OTTO product_catalog";
if ($jng_sp_id == '0') {
//JNG ACTIVATION
$sda = array('products_status' => $status);
if ($status == '1') {
$active_date = date('Y-m-d H:i:s');
$sda['products_last_modified'] = $active_date;
}
tep_db_perform('products', $sda, 'update', "products_id={$products_id}");
} else {
//SP ACTIVATION
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
$cat = $class_jc->retrieveDetail(null, $jng_sp_id, $products_id);
$catalog_id = $cat['jng_sp_catalog_id'];
if ($status == '1') {
$class_jc->activateProduct($catalog_id);
} else {
$class_jc->deactivateProduct($catalog_id);
}
}
$result = array();
$result['jng_sp_id'] = $jng_sp_id;
$result['products_id'] = $products_id;
$result['status'] = $status;
ajaxReturn($result);
}
}
//FILTER OPTIONS
$products_id_limit = 49360;
//LAST PRODUCT ID CREATED WITH CONFIGURATOR
$filter_query = " WHERE p.active_status='1'";
