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); } } }