crm.e5.pl/modules/EcmStockStates/rebuildState.php

<?php
require_once("modules/EcmStockStates/EcmStockState.php");
$ss = new EcmStockState();
set_time_limit(1000000);

$codes = explode("|", $_GET['code']);

var_dump($codes);

$db = $GLOBALS['db'];
foreach ($codes as $code) {
    if ($code == "") continue;
    $z2 = $db->query("select id from ecmproducts where code='$code' and deleted=0");

    while ($p = $db->fetchByAssoc($z2)) {

        $w = $db->query("select id from ecmstocks where deleted='0'");
        while ($r = $db->fetchByAssoc($w)) {
            $ss->UpdateStockState($r['id'], $p['id']);
        }
        $w = $db->query("select quantity,stock_name,price,product_code from ecmstockstates where product_id='" . $p['id'] . "' and deleted='0'");
        while ($s = $db->fetchByAssoc($w)) {
            echo $s['product_code'] . " " . $s['stock_name'] . " " . $s['quantity'] . " " . $s['price'] . "<br>";
        }
    }
}