$class_jc = new jng_sp_catalog(); use_class('products_articles'); $class_pa = new products_articles(); use_class('products_ean'); $class_ean = new products_ean(); $jng_sp_id = '1'; $products = $class_jc->retrieveCatalogForUpload($jng_sp_id); $counter_p = 0; $counter_a = 0; foreach ($products as $p) { if ($p['products_ean'] == '') { $class_ean->attachToProduct($p['products_id']); $counter_p++; } $articles = $class_pa->retrieveList($p['products_id']); foreach ($articles as $a) { if ($a['length'] != $p['length']) { if ($a['products_ean'] == '') { $class_ean->attactToArticle($a['products_articles_id']); $counter_a++; } } } echo '.'; } $content .= '<br />'; $content = "Total Products: {$counter_p}"; $content .= '<br />'; $content .= "Total Articles: {$counter_a}"; echo $content; tep_db_close();
/** * Handle POST/GET Action that related to products_articles */ function processAction() { if (isset($_POST['me_action']) && $_POST['me_action'] == 'PRODUCTSARTICLES') { switch ($_POST['act']) { case 'ADDEANTOPRODUCT': $products_id = tep_db_prepare_input($_POST['products_id']); use_class('products_ean'); $class_ean = new products_ean(); $result = $class_ean->attachToProduct($products_id); break; case 'ADDEANTOARTICLE': $article_id = tep_db_prepare_input($_POST['article_id']); use_class('products_ean'); $class_ean = new products_ean(); $ean_no = $class_ean->attactToArticle($article_id); $result = "{$article_id},{$ean_no}"; break; case 'ADD': $products_id = tep_db_prepare_input($_POST['products_id']); $price = tep_db_prepare_input($_POST['new_price']); $price_old = tep_db_prepare_input($_POST['new_price_old']); $length = tep_db_prepare_input($_POST['new_length']); $options = array(); $options['length'] = $length; $prepared = true; $products_articles_id = $this->add($products_id, $price, $price_old, $options, $prepared); if ($products_articles_id == 0) { $result .= '0'; } else { //$result = '<tr><td>Other Length <sup class="red">new</sup></td><td>'.$length.'cm = '.$price.' EUR</td>'; $result .= '<tr>'; $result .= '<td class="green">New</td>'; $result .= '<td class="notice">Unset</td>'; $result .= '<td>' . $length . '</td>'; //$result .= '<td>'.$price.'</td>'; //$result .= '<td>'.$price_old.'</td>'; $result .= '<td colspan="2"><a href="">Refresh Page</a> for action links</td>'; $result .= '</tr>'; } break; case 'UPDATE': $options = array(); $options['length'] = $_POST['new_length']; $result = $this->update($_POST['products_articles_id'], $_POST['new_price'], $_POST['new_price_old'], $options); break; case 'REMOVE': $result = $this->remove($_POST['products_articles_id']); break; case 'ARTICLEACTIVATION': $paid = tep_db_prepare_input($_POST['paid']); $status = tep_db_prepare_input($_POST['status']); $this->setActiveStatus($paid, $status); $result = array(); $result['paid'] = $paid; $result['status'] = $status; $result['success'] = '1'; ajaxReturn($result); exit; break; } echo utf8_encode($result); exit; } }
function saveLength($products_id, $def_length, $add_length) { use_class('products_articles'); use_class('products_ean'); $class_pa = new products_articles(); $class_ean = new products_ean(); $sda = array('products_length' => $def_length); $product = $this->retrieveDetail($products_id, 'cat,pnc'); if (!is_array($product['pnc'])) { $sda['products_id'] = $products_id; tep_db_perform('products_non_configurator', $sda); } else { tep_db_perform('products_non_configurator', $sda, 'update', "products_id={$products_id}"); } $sda = array('length' => $def_length); tep_db_perform('jng_sp_catalog', $sda, 'update', "products_id={$products_id}"); $p_ean = $class_ean->getEAN($products_id); if ($p_ean == '') { $class_ean->attachToProduct($products_id); } if (is_array($add_length) && count($add_length) > 0) { foreach ($add_length as $l) { $paid = $class_pa->add($products_id, 0, 0, array('length' => $l), true); $class_ean->attactToArticle($paid); } } }