$sql = new SQLManager($FANNIE_SERVER, $FANNIE_SERVER_DBMS, $FANNIE_OP_DB, $FANNIE_SERVER_USER, $FANNIE_SERVER_PW);
$upc = null;
$prevDept = null;
$q = "select u.upc,u.modified,dept,user from prodUpdate\nas u inner join products as p on p.upc=u.upc\norder by u.upc,u.modified";
if ($FANNIE_SERVER_DBMS == "MSSQL") {
$q = str_replace("user", "[user]", $q);
}
$r = $sql->query($q);
while ($w = $sql->fetch_row($r)) {
if ($upc === null || $upc != $w['upc']) {
// next item, get previous
// date and price from compressed
// history if available
$upc = $w['upc'];
$prevDept = null;
$prevDate = null;
$chkR = $sql->query("SELECT modified,dept_ID FROM\n prodDepartmentHistory WHERE upc='{$upc}'\n ORDER BY modified DESC");
if ($sql->num_rows($chkR) > 0) {
$chk = $sql->fetch_row($chkR);
$prevDate = $chk['modified'];
$prevDept = $chk['dept_ID'];
}
}
if ($prevDept != $w['dept']) {
// price changed
$ins = sprintf("INSERT INTO prodDepartmentHistory\n (upc,modified,dept_ID,uid)\n VALUES (%s,%s,%d,%d)", $sql->escape($upc), $sql->escape($w['modified']), $w['dept'], $w['user']);
$sql->query($ins);
}
$prevDept = $w['dept'];
$prevDate = $w['modified'];
}
$sql = new SQLManager($FANNIE_SERVER, $FANNIE_SERVER_DBMS, $FANNIE_OP_DB, $FANNIE_SERVER_USER, $FANNIE_SERVER_PW);
$upc = null;
$prevPrice = null;
$q = "select u.upc,u.modified,price,user from prodUpdate\nas u inner join products as p on p.upc=u.upc\norder by u.upc,u.modified";
if ($FANNIE_SERVER_DBMS == "MSSQL") {
$q = str_replace("user", "[user]", $q);
}
$r = $sql->query($q);
while ($w = $sql->fetch_row($r)) {
if ($upc === null || $upc != $w['upc']) {
// next item, get previous
// date and price from compressed
// history if available
$upc = $w['upc'];
$prevPrice = null;
$prevDate = null;
$chkR = $sql->query("SELECT modified,price FROM\n prodPriceHistory WHERE upc='{$upc}'\n ORDER BY modified DESC");
if ($sql->num_rows($chkR) > 0) {
$chk = $sql->fetch_row($chkR);
$prevDate = $chk['modified'];
$prevPrice = $chk['price'];
}
}
if ($prevPrice != $w['price']) {
// price changed
$ins = sprintf("INSERT INTO prodPriceHistory\n (upc,modified,price,uid)\n VALUES (%s,%s,%.2f,%d)", $sql->escape($upc), $sql->escape($w['modified']), $w['price'], $w['user']);
$sql->query($ins);
}
$prevPrice = $w['price'];
$prevDate = $w['modified'];
}
