<?php

global $db;
require_once '../confy.php';
require_once '../functions.php';
tep_db_connect();
use_class('jng_sp_catalog');
$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 '.';