}
}
//начинаем парсить
//print_r($array);
if (!empty($array)) {
for ($z = 0; $z < count($array); $z++) {
$file = $root . "/dbf/" . $array[$z];
$dbf = new dbf_class($file);
//echo "<br />".$array[$i];
//echo str_replace('.dbf', '', $array[$z]);
$num_rec = $dbf->dbf_num_rec;
$header = $dbf->getheader();
//echo "<br />";
$num_field = $dbf->dbf_num_field;
for ($i = 0; $i < $num_rec; $i++) {
$row = $dbf->getRow($i);
$sql = "SELECT CODE2 FROM " . strtolower(str_replace('.dbf', '', $array[$z])) . " WHERE CODE2='" . iconv('windows-1251', 'utf-8', $row[0]) . "'";
$db->query($sql);
if ($db->getCount() > 0) {
//если есть обновляем данные
for ($j = 0; $j < $num_field; $j++) {
$row[$j] = trim($row[$j]);
if (!empty($row[$j])) {
//echo iconv('windows-1251', 'utf-8', $row[$j])." | ";
$field = array();
$field_val = array();
for ($j = 0; $j < $num_field; $j++) {
$row[$j] = trim($row[$j]);
if (!empty($row[$j])) {
array_push($field, iconv('windows-1251', 'utf-8', $header[$j]));
array_push($field_val, iconv('windows-1251', 'utf-8', $row[$j]));
}
// open in read-write mode
if (function_exists('dbase_open')) {
// only if php was compiled with dbase support
$updatemsg .= "Packing database.<br/>";
$dbo = dbase_open('datastore/hkmatrix.dbf', 2);
// expunge the database
dbase_pack($dbo);
}
$dbr = new dbf_class('datastore/hkmatrix.dbf');
$num_rec = $dbr->dbf_num_rec;
$field_num = $dbr->dbf_num_field;
//print" Num_rec: $num_rec Num_field $field_num <br>";
for ($i = 0; $i < $num_rec; $i++) {
//print"<br> Record : $i <br>================<br>";
$row = $dbr->getRow($i);
if (is_array($row)) {
$rowkeys = array_keys($row);
$sql = "INSERT INTO hkmatrix (custgroup,refnum,prodgroup,supplier,prodcode,matrix,discount,contract,trade,retail,date_on,date_off,break1,break2,break3,break4,break5,break6,break7,price1,price2,price3,price4,price5,price6,price7,text,type) VALUES (";
$k = 0;
//build SQL from db columns
foreach ($rowkeys as $key) {
if ($row[$key] == NULL) {
$row[$key] = '';
}
$sql .= "'{$row[$key]}'";
if ($k != count($rowkeys) - 1) {
$sql .= ",";
}
$k++;
}
$field_num = $dbf->dbf_num_field;
$endexct = $timer->end();
if ($cli == "0") {
echo '<form method="post" action="./update.php">';
echo '<table id="hkstock" border=0 width="100%" cellspacing=0 class="tablesorter">';
//echo $hdrrow;
echo '<tbody>';
}
for ($i = 0; $i < $num_rec; $i++) {
$stockcount = 0;
$insert = array();
$webready = "0";
$checksupp = FALSE;
$newsupplier = NULL;
$newmodel = NULL;
if ($row = $dbf->getRow($i)) {
if (!empty($row[0])) {
// in case there is nothing in the dbf prodcode field continue looping thru records
$resultsweb = $db->Query("SELECT * FROM import_webstock WHERE prodcode='" . $row[0] . "' ");
if ($resultsweb) {
$row2 = $db->RowArray();
//print_r($row2);
} else {
$row2 = array();
}
if (isset($row2['webready']) == "1") {
$webready = "1";
}
if ($row[124] == "Y" || $row[124] == "y") {
$webready = "1";
}
