function activateProducts($products_id)
{
$sda = array();
$sda['active_status'] = '1';
$sda['active_date'] = date('Y-m-d H:i:s');
$filter_active = "products_id IN (" . (is_array($products_id) ? implode(',', $products_id) : $products_id) . ")";
tep_db_perform('jng_sp_catalog', $sda, 'update', $filter_active);
setTradebyteNeedReupload($products_id);
}
$sda = array('products_length' => $products_length, 'is_virtual' => $is_virtual);
$exist_query = tep_db_query("SELECT pnc.products_id FROM products_non_configurator pnc WHERE pnc.products_id={$products_id}");
if (tep_db_num_rows($exist_query) > 0) {
tep_db_perform('products_non_configurator', $sda, 'update', "products_id={$products_id}");
} else {
$sda['products_id'] = $products_id;
tep_db_perform('products_non_configurator', $sda);
}
$sda_sp = array('length' => $products_length);
tep_db_perform('jng_sp_catalog', $sda_sp, 'update', "products_id={$products_id}");
}
$sql_data_array['sample_created'] = isset($_POST['sample_created']) ? tep_db_prepare_input($_POST['sample_created']) : '0';
$sql_data_array['is_outsourced'] = isset($_POST['is_outsourced']) ? tep_db_prepare_input($_POST['is_outsourced']) : '0';
$sql_data_array['is_wholesale'] = isset($_POST['is_wholesale']) ? tep_db_prepare_input($_POST['is_wholesale']) : '0';
tep_db_perform('products', $sql_data_array, 'update', "products_id = '" . (int) $products_id . "'");
setTradebyteNeedReupload($products_id);
}
}
//START TEMPLATE
$products_entry = '';
if (isset($_GET['products_id'])) {
$products_id = tep_db_prepare_input($_GET['products_id']);
$product_data = $class_pm->retrieveDetail($products_id, 'p,pc,pnc,cat,pci,pl');
} elseif (isset($_POST['products_id'])) {
//REDIRECT LINK IF AN ORDER IS FOUND BY POST
if (isset($_POST['products_id'])) {
$products_entry = tep_db_prepare_input($_POST['products_id']);
}
if (strlen($products_entry) == 13) {
use_class('products_ean');
$class_ean = new products_ean();
/**
* Update products price for JNG and All SP
* @param int $products_id
* @param float $price Send null to skip updating price
* @param float $price_old Send null to skip updating price_old
* @return void
*/
function updatePrice($products_id, $price, $price_old)
{
$sda = array();
if (!is_null($price)) {
$sda['price'] = $price;
}
if (!is_null($price_old)) {
$sda['price_old'] = $price_old;
}
if (count($sda) > 0) {
tep_db_perform('products_articles', $sda, 'update', "products_id = '{$products_id}'");
$sda['image_uploaded'] = '0';
tep_db_perform('jng_sp_catalog', $sda, 'update', "products_id = '{$products_id}'");
setTradebyteNeedReupload($products_id);
$sda = array();
if (!is_null($price)) {
$sda['products_price'] = $price;
}
if (!is_null($price_old)) {
$sda['products_price_old'] = $price_old;
}
tep_db_perform('products', $sda, 'update', "products_id = '{$products_id}'");
$this->stockUpdateTBNeedUpdateStatus(WAREHOUSE_ID_FOR_HANDLING_ORDERS, $products_id, 1);
if (isset($sda['products_price'])) {
$this->updateMargin($products_id);
}
}
}
