function sp_addProductToCatalog($jng_sp_id, $product_id) { use_class('Product'); use_class('jng_sp'); use_class('products_minierp'); use_class('jng_sp_catalog'); use_class('jng_sp_catalog_params'); $class_sp = new jng_sp(); $class_pm = new products_minierp(); $class_jc = new jng_sp_catalog(); $class_jcp = new jng_sp_catalog_params(); $sp_detail = $class_sp->retrieveDetail($jng_sp_id); $sp_used_selling_points = getSalesPartnerUseSellingPoint(); $sp_used_selling_points_amde = getSalesPartnerUseSellingPoint(true); if (!is_array($product_id)) { $product_id = explode(',', $product_id); } $new_id = array(); foreach ($product_id as $pid) { $check_exist = $class_jc->retrieveDetail(null, $jng_sp_id, $pid); if ($check_exist === false) { $obj_product = new Product($pid); $product_data_raw = $class_pm->retrieveDetail($pid); $products_selling_points = ''; $psp = $product_data_raw['pd'][2]['products_selling_points']; $pspa = $product_data_raw['pd'][2]['products_selling_points_amde']; if (in_array($jng_sp_id, $sp_used_selling_points)) { $products_selling_points = $psp; } elseif (in_array($jng_sp_id, $sp_used_selling_points_amde)) { $products_selling_points = $pspa; } if (!is_null($obj_product->id)) { $desc = $product_data_raw['pd'][$sp_detail['languages_id']]; $product = array(); $product['products_length'] = $product_data_raw['pnc']['products_length']; $product['products_name'] = $desc['products_name']; $product['products_description'] = $desc['products_description']; $product['products_head_keywords_tag'] = $desc['products_head_keywords_tag']; $article_number = str_replace('-', '_', $obj_product->code); $price_uvp = $obj_product->getPriceUVP(); $price_default = $obj_product->getPriceDefault(); //TODO: USE B2B FLAG if ($jng_sp_id == '5') { $product_price = $obj_product->getPriceSellingDefaultB2B($price_uvp, $jng_sp_id); $product_price_old = 0; $product_price_new = 0; $active_status = '1'; } else { $product_price = $price_default; $product_price_old = $price_uvp > $price_default ? $price_uvp : 0; $product_price_new = 0; $active_status = '0'; } $product_name = $product['products_name']; $product_desc = $product['products_description']; $keywords_ok = array(); $keywords_temp = str_replace('|||', ',', $product['products_head_keywords_tag']); $keywords_split = explode(',', $keywords_temp); foreach ($keywords_split as $kws) { $kws = trim($kws); if ($kws != '') { $rule1 = strpos($product_name, $kws) === false; $rule2 = strpos($product_desc, $kws) === false; $rule3 = strpos($kws, 'cm') === false; if ($rule1 && $rule2 && $rule3) { $keywords_ok[] = $kws; } } } $product_keywords = count($keywords_ok) > 0 ? implode(', ', $keywords_ok) : ''; $product_length = $product['products_length'] == '' ? '0' : $product['products_length']; //Retrieve Products Color and connect it with SP Colors $color_pattern_id = $class_pm->loadColorPattern($obj_product->id); $sp_params_raw = $class_jcp->load($jng_sp_id, 'C'); $sp_params = array(); foreach ($sp_params_raw as $spr) { if (in_array($spr['param_id'], $color_pattern_id)) { $sp_params[] = $spr['param_value']; } } $product_color = implode(', ', $sp_params); //Retrieve Products Materials and connect it with SP Materials $products_materials_id = $class_pm->loadProductMaterials($obj_product->id); $sp_params_raw = $class_jcp->load($jng_sp_id, 'M'); $sp_params = array(); foreach ($sp_params_raw as $spr) { if (in_array($spr['param_id'], $products_materials_id)) { $sp_params[] = $spr['param_value']; } } $product_material = implode(', ', $sp_params); $date_added = date('Y-m-d H:i:s'); //Retrieve Max Resourcing Days $elmax_rd_query = "SELECT pe.products_id, MAX(es.resourcing_day) AS max_res_day"; $elmax_rd_query .= " FROM products_use_elements pe"; $elmax_rd_query .= " LEFT JOIN elements_stock es ON es.elements_id=pe.elements_id"; $elmax_rd_query .= " WHERE pe.products_id = {$obj_product->id}"; $elmax_rd_query .= " GROUP BY pe.products_id"; $elmax_rd_result = tep_db_query($elmax_rd_query); $elmax_rd = tep_db_fetch_array($elmax_rd_result); $resplacement_days = $elmax_rd['max_res_day'] == '' ? '0' : $elmax_rd['max_res_day']; //INSERT DATA $sda = array('jng_sp_id' => $jng_sp_id, 'products_id' => $obj_product->id, 'article_number' => $article_number, 'price' => $product_price, 'price_old' => $product_price_old, 'price_new' => $product_price_new, 'name' => $product_name, 'description' => $product_desc, 'keywords' => $product_keywords, 'length' => $product_length, 'color' => $product_color, 'material' => $product_material, 'use_logo' => '1', 'status_image' => '0', 'date_added' => $date_added, 'replacement_days' => $resplacement_days, 'products_selling_points' => $products_selling_points, 'active_status' => $active_status); tep_db_perform('jng_sp_catalog', $sda); $new_id[] = tep_db_insert_id(); } } } return $new_id; }
<?php global $db; require_once '../confy.php'; require_once '../functions.php'; require_once '../functions-2.php'; tep_db_connect(); $jng_sp_id = '1'; use_class('jng_sp_catalog_params'); $class_jcp = new jng_sp_catalog_params(); use_class('products_minierp'); $class_pm = new products_minierp(); $colors_raw = $class_jcp->load($jng_sp_id, 'C'); $colors = array(); foreach ($colors_raw as $cr) { $colors[$cr['param_value']] = $cr['param_id']; } $materials_raw = $class_jcp->load($jng_sp_id, 'M'); $materials = array(); foreach ($materials_raw as $mr) { $materials[$mr['param_id']] = $mr['param_value']; } $q = "SELECT products_id, color, material FROM jng_sp_catalog WHERE jng_sp_id={$jng_sp_id}"; $r = tep_db_query($q); while ($row = tep_db_fetch_array($r)) { $products_id = $row['products_id']; $ca = explode(',', $row['color']); foreach ($ca as $key => $c) { $ca[$key] = trim($c); } $color_pattern_id = array();
foreach ($brands as $b) { $param_id = $b['products_brand_id']; $param_name = $b['brand_name']; $sp_brands = $class_pb->getSPbrands($param_id); $param_value = $sp_brands[$jng_sp_id]; $checked = $param_value != '' ? 'checked="checked"' : ''; $result .= '<tr>'; $result .= '<td width="20"><input type="checkbox" id="param_id_' . $param_code . $param_id . '" class="param_id" value="' . $param_id . '" ' . $checked . ' /></td>'; $result .= '<td width="150"><label for="param_id_' . $param_code . $param_id . '">' . $param_name . '</label></td>'; $result .= '<td><input type="text" id="param_value_' . $param_id . '" class="input param_value" value="' . $param_value . '" /></td>'; $result .= '<td id="param_status_' . $param_code . $param_id . '"></td>'; $result .= '</tr>'; } $result .= '</table></div>'; } else { $params_raw = $class_jpc->load($jng_sp_id, $param_code); $params = array(); foreach ($params_raw as $pr) { $params[$pr['param_id']] = $pr['param_value']; } if ($_GET['tab'] == 'C') { use_service('color_pattern'); $class_cp = new color_pattern(); $cp_list = $class_cp->retrieveListGrid(SERVICECLIENTCODE, null, LANGUAGEID); $result .= '<div><table class="form" border="0" cellpadding="0" cellspacing="0">'; foreach ($cp_list['Data'] as $cp) { $param_id = $cp['color_pattern_id']; $param_name = $cp['name']; if (isset($params[$cp['color_pattern_id']])) { $checked = 'checked="checked"'; $param_value = $params[$cp['color_pattern_id']];
function saveColors($products_id, $colors) { global $class_pm, $class_jc; $color_pattern_id = explode(',', $colors); $class_pm->setColorPattern($products_id, $color_pattern_id); use_class('jng_sp_catalog_params'); $class_jcp = new jng_sp_catalog_params(); $q = tep_db_query("SELECT jng_sp_catalog_id, jng_sp_id FROM jng_sp_catalog WHERE products_id={$products_id}"); $sp_list = array(); while ($row = tep_db_fetch_array($q)) { $sp_list[$row['jng_sp_catalog_id']] = $row['jng_sp_id']; } foreach ($sp_list as $catalog_id => $jng_sp_id) { $sp_params_raw = $class_jcp->load($jng_sp_id, 'C'); $sp_params = array(); foreach ($sp_params_raw as $spr) { if (in_array($spr['param_id'], $color_pattern_id)) { $sp_params[] = $spr['param_value']; } } $sda = array('color' => implode(', ', $sp_params)); $class_jc->updateField($catalog_id, $sda); } }
$result['languages_id'] = $languages_id; $result['keywords'] = $keywords; $result['autokw-amvd'] = addAutoKeywords($keywords, 188, $name, $products_colors); $result['autokw-otde'] = otdeAutoKeywords($name, strtoupper($products_brand['brand_name']), $class_pm->retrieveCategoryName($pdata['categories_id'], '2')); ajaxReturn($result); exit; } elseif ($_POST['me_action'] == "SAVECOLORS") { $color_pattern_id = $_POST['colors'] == '' ? array() : explode(',', $_POST['colors']); $class_pm->setColorPattern($products_id, $color_pattern_id); $q = tep_db_query("SELECT jng_sp_catalog_id, jng_sp_id FROM jng_sp_catalog WHERE products_id={$products_id}"); $sp_list = array(); while ($row = tep_db_fetch_array($q)) { $sp_list[$row['jng_sp_catalog_id']] = $row['jng_sp_id']; } foreach ($sp_list as $catalog_id => $jng_sp_id) { $sp_params_raw = $class_jcp->load($jng_sp_id, 'C'); $sp_params = array(); foreach ($sp_params_raw as $spr) { if (in_array($spr['param_id'], $color_pattern_id)) { $sp_params[] = $spr['param_value']; } } $sda = array('color' => implode(', ', $sp_params)); $class_jc->updateField($catalog_id, $sda); } $products_data = $class_pm->retrieveDetail($products_id, 'pd'); $products_colors = $class_pm->loadColorPatternNames($products_id); $result = array(); $result['type'] = 'col'; $result['lidcol'] = implode(',', array_keys($products_colors)); foreach ($products_colors as $lid => $procols) {