$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";
            $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'";
$keywords = '';
if (isset($_POST['me_action'])) {
        } 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.');
    }
}
if (isset($_SESSION['sp-products-finalize']['keywords'])) {
    $keywords = $_SESSION['sp-products-finalize']['keywords'];
    $filter_query .= " AND (";
 /**
  * Use this function to check if an EAN should be auto cancel for AMVD
  * @param String $ean EAN code
  * @param Array $ean_detail_info the result of function getAMVD_AutoCancelSupportingData()
  * @param Array $sp_specsets result of "load_config('sp-specific-settings');" dont send anything for auto load
  * @return Boolean true = EAN should be cancelled
  */
 function checkAMVD_AutoCancelRule($ean, $ean_detail_info, $sp_specsets = null, $deactivate_products = true)
 {
     if (is_null($sp_specsets)) {
         $sp_specsets = load_config('sp-specific-settings');
     }
     $auto_cancel_rule = false;
     if (!is_null($ean_detail_info) && isset($ean_detail_info[$ean])) {
         $auto_cancel_rule = $ean_detail_info[$ean]['active_status'] == '0';
         if (!$auto_cancel_rule) {
             $auto_cancel_rule = !in_array($ean_detail_info[$ean]['products_id'], explode(',', $sp_specsets['amvd-autocancel-excludepids'])) && $ean_detail_info[$ean]['active_age'] >= $sp_specsets['amvd-autocancel-productsage'] && $ean_detail_info[$ean]['total_sold'] <= $sp_specsets['amvd-autocancel-articlesold'] && $ean_detail_info[$ean]['total_sold_products'] <= $sp_specsets['amvd-autocancel-productsold'];
         }
     }
     if ($auto_cancel_rule && $ean_detail_info[$ean]['active_status'] != '0' && $deactivate_products) {
         global $class_jc;
         if (!is_object($class_jc)) {
             use_class('jng_sp_catalog');
             $class_jc = new jng_sp_catalog();
         }
         $class_jc->deactivateProduct($ean_detail_info[$ean]['jng_sp_catalog_id']);
     }
     return $auto_cancel_rule;
 }