";
$result5 = mysql_query($query5);
//if (!mysql_num_rows($result5)) continue;
while($row5 = mysql_fetch_array($result5))
{
$artSKU = trim($row5["CatalogSK"]);
$artSize = $row5["SubDeptName4"];
}
//for gallery wraps...
if (substr($frameSKU,0,3) == "GAL") {
// echo $frameSKU . "
";
if ($artSize == 'Customary 16" X 20"' ) $frameSKU = "GALWRP14X18";
else if ($artSize == 'Classic 20" X 24"' ) $frameSKU = "GALWRP18X22";
else if ($artSize == 'Square 24" X 24"' ) $frameSKU = "GALWRP22X22";
else if ($artSize == 'Large 24" X 36"' ) $frameSKU = "GALWRP22X34";
else if ($artSize == 'Extra Large 30" X 40"' ) $frameSKU = "GALWRP28X38";
else if ($artSize == 'Oversized 36" X 48"' ) $frameSKU = "GALWRP34X46";
}
$query4 = "SELECT * FROM `catalogcity` WHERE UPPER(CatalogSK) = '" . $frameSKU . "' || UPPER(CatalogSK) = 'FR-" . $frameSKU . "' LIMIT 1;";
//echo $query4 . "
";
$result4 = mysql_query($query4);
//if (!mysql_num_rows($result4)) continue;
if($row4 = mysql_fetch_array($result4))
{
$frameSKU = trim($row4["CatalogSK"]);
$frameTitle = trim($row4["Ordertext"]);
$frameExt = $row4["FrameWidth"] . '" X ' . $row4["FrameHeight"] . '"';
$frameInStockMsg = "CAN BE OFFERED";
$msgColor = "green";
$msgTotal = "Total price:";
}
else
{
if ($filterOffer == "checked") continue; //continue if filtering of none available frame items.
$frameInStockMsg = "CANNOT BE OFFERED";
$msgColor = "#AE0011";
$msgTotal = "Painting only price:";
}
$artPrice = $myrow["artPrice"];
$framePrice = $myrow["framePrice"];
$totalPrice = $myrow["Price"];
//CHANGE TO Communictor DB
$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase2, $sConn)
or die("Couldn't connect to database $dbDatabase2");
// $query1 = "SELECT * FROM `peachtree` JOIN `parts` ON `itemID` = `partno` WHERE `itemID` NOT LIKE '%FR-%' AND `itemID` NOT LIKE 'X%' AND `parts`.`active` = 1 ORDER BY `peachtree`.`$sortwith` DESC";
// $query1 = "SELECT * FROM `peachtree` LEFT JOIN `parts` ON `itemID` = `partno` WHERE `itemID` = '$artSKU' LIMIT 1";
if (substr($artSKU,-1) == 'P') $artSKUpre = substr($artSKU, 0, -1);
else $artSKUpre = $artSKU;
$query1 = "SELECT * FROM `parts` WHERE UPPER(`partno`) = '$artSKUpre' LIMIT 1";
//echo $query1 . "
";
$result = mysql_query($query1);
while($myrow = mysql_fetch_array($result))
{
$partid = $myrow["partno"];
if ($frameSKU != "")
{
/**************frames *************/
$id_frame = "NOT IN COMMUNICATOR PARTS";
//$query2 = "SELECT * FROM `peachtree` LEFT JOIN `parts` ON `itemID` = `partno` WHERE `itemID` = '$frameSKU' LIMIT 1";
$query2 = "SELECT * FROM `parts` WHERE `partno` = '$frameSKU' LIMIT 1";
//echo $query2;
$resultFrame = mysql_query($query2);
while($rowFrame = mysql_fetch_array($resultFrame))
{
$id_frame = ""; //$rowFrame["itemID"];
$units_sold_frame = $rowFrame["unit_sold"];
$sales_frame = $rowFrame["sales"];
$qty_on_hand_frame = $rowFrame["qty_on_hand"];
}
/**************frames *************/
}
//START - ADD QTY ON ORDER AND ACCEPTED
$queryTrans = "SELECT partid, unit_sold, sales, qty_on_hand, active, artimage, qty_available FROM parts WHERE `partno` ='" . $partid . "' LIMIT 1;";
$transResult = mysql_query($queryTrans);
$rowTrans = mysql_fetch_array($transResult, MYSQL_NUM);
if ( $rowTrans[0] != "" )
{
$partid1 = $rowTrans[0];
$active = $rowTrans[4];
$units_sold = $rowTrans[1];
$sales = $rowTrans[2];
$qty_on_hand = $rowTrans[3];
$qty_available = $rowTrans[6];
$query1 = "SELECT quantity,qtyaccepted,qtyReceived,cost FROM `orderlines` WHERE STATUS <> 'Closed' AND STATUS <> 'Cancelled' AND (partid='" . $partid1 . "' or partid= '" . $partid . "');";
//echo $query1;
$result3 = mysql_query($query1);
//$rowOnOrder = mysql_fetch_array($result3, MYSQL_NUM);
$qty_on_order = 0;
$qty_accept = 0;
$qty_received = 0;
while($rowOnOrder = mysql_fetch_array($result3))
{
if ( $rowOnOrder[0] != NULL )
{
$qty_on_order += $rowOnOrder[0];
$qty_accept += $rowOnOrder[1];
$qty_received += $rowOnOrder[2];
$costOnHand = $rowOnOrder[3];
}
}
}
else {
$qty_on_order = 0;
$qty_accept = 0;
$qty_received = 0;
}
$name = addslashes($myrow["name"]);
$qty_remaining = $qty_on_order - $qty_received;
}
$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");
$qtyOnHandArt = $qty_on_hand;
$qtyOnHandFrames = $qty_on_hand_frame;
$qtyAvailable = $qty_available;
$unitsSoldArt = $units_sold;
$unitsSoldFrames = $units_sold_frame;
$dollarsSold = $sales;
$qtyRemain = $qty_remaining;
$idFrame = $id_frame;
//CHANGE BACK TO Sorter DB
$altImage = "overstock/rooms/" . $SKU . ".jpg";
if (!file_exists($altImage)) $altImage = "overstock/rooms/" . $SKU . "R.jpg";
if (file_exists($altImage)) {
$altImageDone2 = "http://www.overstockart.net/sorter/" . $altImage;
$checkAlt2 = 'ROOM IMAGE AVAILABLE';
}
else {
$checkAlt2 = 'NO ROOM IMAGE';
$altImageDone2 = "";
}
/***************START UPC MODULE******************/
//select from database all the referers
/*$dbQuery = "SELECT * FROM `upc_manager` ORDER BY `upc5` DESC LIMIT 1";
$resultUPC = mysql_query($dbQuery) or die("Couldn't get the Contacts 2");
$rowUPC = mysql_fetch_array($resultUPC);
$upc5 = $rowUPC['upc5'] + 1; //find the last upc and add 1 for frames*/
//Fetch first available upc5 codes:
$dbQuery = "SELECT `upc5` FROM `upc_open` WHERE 1 ORDER BY `upc5` ASC LIMIT 1";
$result = mysql_query($dbQuery) or die("Couldn't get the Contacts");
$row = mysql_fetch_array($result);
$upc5 = $row['upc5']; //find the next open upc
//check if SKU has a UPC code in the UPC manager:
$num_rows_upc = 0;
$queryCheck = "SELECT * FROM `upc_manager` WHERE `CatalogSK` = '" . $SKU . "'";
$resultCheck = mysql_query($queryCheck);
$num_rows_upc = mysql_num_rows($resultCheck);
if ( $num_rows_upc > 0)
{
$queryUPC = "SELECT * FROM `upc_manager` WHERE `CatalogSK` = '" . $SKU . "' LIMIT 1";
$resultUPC = mysql_query($queryUPC);
while($rowUPC = mysql_fetch_array($resultUPC))
{
if ($rowUPC["UPC"] != "")
$upc = $rowUPC["UPC"];
else
{
$upc = createUPC($upc5);
$query = "UPDATE `upc_manager` SET `UPC` = '" . $upc . "', `upc5` = '" . $upc5 . "' WHERE `CatalogSK` = '" . $SKU . "';";
//$query = "INSERT INTO upc_manager (CatalogSK, UPC) VALUES ('$SKU', '$upc');";
mysql_query($query) or die("Couldn't MOD row to UPC manager $SKU, $upc");
$queryDelete = "DELETE FROM `upc_open` WHERE `upc5` = '$upc5';";
mysql_query($queryDelete);
}
}
}
else {
$upc = createUPC($upc5);
$query = "INSERT INTO upc_manager (CatalogSK, UPC, upc5) VALUES ('$SKU', '$upc', '$upc5');";
mysql_query($query) or die("Couldn't add row to UPC manager $SKU, $upc");
//echo $query . "
";
$queryDelete = "DELETE FROM `upc_open` WHERE `upc5` = '$upc5';";
mysql_query($queryDelete);
}
/***************END UPC MODULE******************/
$recomended_qty = 0;
$dConn = mysql_select_db($dbDatabase2, $sConn) or die("Couldn't connect to database $dbDatabase2");
$queryTrans = "SELECT partid,closeout,active FROM parts WHERE partno ='" . $artSKU . "' LIMIT 1;";
$transResult = mysql_query($queryTrans);
$row = mysql_fetch_array($transResult, MYSQL_NUM);
$partidTest = $row[0];
$closeout = $row[1];
$active = $row[2];
if($partidTest == "") $border = "#c6f2bd";
else $border = "#FFFFFF";
if($closeout == '1')
$closeoutdisplay = "
closeout";
else
$closeoutdisplay = "";
$borderOnHand = "";
if ($qtyOnHandArt > 0)
{
$borderOutofStock = "";
$boldOutofStock = "#000000;";
}
else
{
//echo "less then 1" . ;
$borderOutofStock = "border: medium #ae0011 dashed;";
$boldOutofStock = "#ae0011;";
}
$i == 0 ? $color = "#FFFFFF" : $color = "#DDDDDD";
$i == 0 ? $class = "normal" : $class = "normal2";
$i == 0 ? $i = 1 : $i = 0;
?>
" bgcolor="" style="color:; ">
|
" . $artSKU . "" . $artName . " " . $msgTotal . " $" . $totalPrice. " " . $closeoutdisplay; ?>
" . $amazonSKU . " " . $upc . " Art Price: $" . $artPrice . " " . $checkAlt2 . ""; ?>
DISCONTINUED!"; ?>
|
" . $idFrame . " " . $frameInStockMsg . "" . $frameTitle . "Ext. Dimensions: " . $frameExt . " Price: $" . $framePrice; ?>
Frame units sold:
Frames Qty on Hand:
$now;";
//echo $queryCount;
$resultCount = mysql_query($queryCount);
while ($rowCount = mysql_fetch_array($resultCount))
{
//AND `DateEnd` < $twomonth
//AND `DateEnd` > $now
//echo $queryCount;
$framepn = $rowCount[1];
$frame_units = $rowCount[0];
$endEvent = $rowCount[2];
$typeEvent = $rowCount[3];
$companyEvent = $rowCount[4];
$startEvent = $rowCount[5];
if($typeEvent == 6)
$totalMyhabitOnEvent += $frame_units;
else if($startEvent < $twomonth)
{ //1401771600 < 1400170231
//echo $companyEvent . " DATE:" . date("m-d-Y",$startEvent) . " PN: " . $framepn . " COUNT: " . $frame_units . " ";
$totalUnitsOnEvent += $frame_units;
}
//echo $queryCount;
}
if ($totalUnitsOnEvent > 0)
{
$onEventTxt = " ";
}
else $onEventTxt = "";
echo $onEventTxt ;
$dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase");
?>
|
PO #" . $orderID . " ![\""](\"http://www.overstockart.net/sorter/overstock/") "; ?> |
Qty Available: " . $qtyAvailable; ?>
";?>
Units sold:
|
Order Date:
Expected Delivery:
|
On Order:
Confirmed:
Cancelled:
Received:
On Shipment:
Qty Left: |
|
|
![](\"images/clock.svg\")