function deleteProductAllLanes($upc)
{
$FANNIE_OP_DB = FannieConfig::config('OP_DB');
$FANNIE_LANES = FannieConfig::config('LANES');
$laneupdate_sql = FannieDB::get($FANNIE_OP_DB);
for ($i = 0; $i < count($FANNIE_LANES); $i++) {
$tmp = new SQLManager($FANNIE_LANES[$i]['host'], $FANNIE_LANES[$i]['type'], $FANNIE_LANES[$i]['op'], $FANNIE_LANES[$i]['user'], $FANNIE_LANES[$i]['pw']);
if (!isset($tmp->connections[$FANNIE_LANES[$i]['op']]) || $tmp->connections[$FANNIE_LANES[$i]['op']] === false) {
// connect failed
continue;
}
$delQ = $tmp->prepare_statement("DELETE FROM products WHERE upc=?");
$delR = $tmp->exec_statement($delQ, array($upc), $FANNIE_LANES[$i]['op']);
}
}
$dbc = new SQLManager($FANNIE_SERVER, $FANNIE_SERVER_DBMS, $FANNIE_OP_DB, $FANNIE_SERVER_USER, $FANNIE_SERVER_PW);
$p1 = $dbc->prepare_statement("SELECT upc FROM productUser where upc=?");
$p2 = $dbc->prepare_statement("SELECT upc FROM products WHERE upc=?");
$upP = $dbc->prepare_statement("UPDATE productUser SET photo=? WHERE upc=?");
$dh = opendir('new');
while (($file = readdir($dh)) !== False) {
$exts = explode(".", $file);
$e = strtolower(array_pop($exts));
if ($e != "png" && $e != "gif" && $e != "jpg" && $e != "jpeg") {
continue;
}
$u = array_pop($exts);
if (!is_numeric($u)) {
continue;
}
$upc = str_pad($u, 13, '0', STR_PAD_LEFT);
$r1 = $dbc->exec_statement($p1, array($upc));
if ($dbc->num_rows($r1) > 0) {
echo "UPC {$upc} found in productUser\n";
$upR = $dbc->exec_statement($upP, array($file, $upc));
rename('new/' . $file, 'done/' . $file);
rename('new/' . $u . '.thumb.' . $e, 'done/' . $u . '.thumb.' . $e);
} else {
$r2 = $dbc->exec_statement($p2, array($upc));
if ($dbc->num_rows($r2) > 0) {
echo "UPC {$upc} found in products\n";
} else {
echo "UPC {$upc} not found\n";
}
}
}
