";
$result5 = mysql_query($query5);
if (!mysql_num_rows($result5)){ $num_rows = $num_rows - 1; continue;}
//for gallery wraps...
if (substr($frameSKU,0,3) == "GAL") {
while($myrow = mysql_fetch_array($result5))
{
//echo $frameSKU . "
";
$artSize = $myrow["SubDeptName4"];
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)) { $num_rows = $num_rows - 1; continue;}
}
if ($num_rows < 1) echo "NO ART SELECTED";
$query3 = "SELECT * FROM `hiresolution` WHERE `checked` = '1' $qty_cnd $sale_cnd $filter1_cnd $amazon_filter_cnd $heyneedle_filter_cnd $overstock_filter_cnd $shopnbc_filter_cnd $atg_filter_cnd $wayfair_filter_cnd $kohls_filter_cnd $sears_ca_filter_cnd ORDER BY `" . $sortwith . "` DESC;";
//WHERE SKU='KL837-FR-655G20X24'
//`checked` = '1' ORDER BY `unitsSoldArt` DESC,`dollarsSold` DESC, `SKU` DESC;
//echo $query3;
$result2 = mysql_query($query3) or die("Couldn't add row 1");
$num_rows = mysql_num_rows($result2);
while($myrow = mysql_fetch_array($result2))
{
$SKU = $myrow["SKU"];
$artName = $myrow["artName"];
$artSKU = trim($myrow["artSKU"]);
$frameSKU = trim($myrow["frameSKU"]);
$dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase2");
$query5 = "SELECT * FROM `catalogcity` WHERE UPPER(CatalogSK) = '" . $artSKU . "' || UPPER(CatalogSK) = '" . $artSKU . "P' LIMIT 1;";
//echo $query5 . "
";
$result5 = mysql_query($query5);
if (!mysql_num_rows($result5)) continue;
//for gallery wraps...
if (substr($frameSKU,0,3) == "GAL") {
while($myrow = mysql_fetch_array($result5))
{
//echo $frameSKU . "
";
$artSize = $myrow["SubDeptName4"];
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;
while($row4 = mysql_fetch_array($result4))
{
$frameSKU = trim($row4["CatalogSK"]);
$frameTitle = trim($row4["Ordertext"]);
$frameExt = $row4["FrameWidth"] . '" X ' . $row4["FrameHeight"] . '"';
}
$artPrice = $myrow["artPrice"];
$framePrice = $myrow["framePrice"];
$totalPrice = $myrow["totalPrice"];
$qtyOnHandArt = $myrow["qtyOnHandArt"];
$qtyOnHandFrames = $myrow["qtyOnHandFrames"];
$unitsSoldArt = $myrow["unitsSoldArt"];
$unitsSoldFrames = $myrow["unitsSoldFrames"];
$dollarsSold = $myrow["dollarsSold"];
$qtyRemain = $myrow["qtyRemain"];
$idFrame = $myrow["idFrame"];
$altImage = "overstock/rooms/" . $artSKU . "-" . $frameSKU . ".jpg";
if (!file_exists($altImage)) $altImage = "overstock/rooms/" . $artSKU . "-" . $frameSKU . "R.jpg";
if (file_exists($altImage)) {
$altImageDone2 = "http://www.overstockart.net/sorter/" . $altImage;
$checkAlt2 = 'ROOM IMAGE AVAILABLE';
}
else {
$checkAlt2 = 'NO ROOM IMAGE';
$altImageDone2 = "";
}
if( ($qtyOnHandArt + $qtyRemain ) < ($units_sold/$factor))
$flag = "#ae0011; font-weight:bold;";
else $flag = "#000000";
$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:; ">
" . $countItems; ?> |
" . $artSKU . "
" . $artName . "
Price: $" . $artPrice . "
" . $closeoutdisplay; ?>
DISCONTINUED!"; ?>
|
" . $idFrame . "
" . $frameTitle . "
Ext. Dimensions: " . $frameExt . "
Price: $" . $framePrice; ?>
Frame units sold:
Frames Qty on Hand:
" . $SKU . "
Total price: $" . $totalPrice . "
" . $checkAlt2 . ""; ?> |
![\""](\"http://www.overstockart.net/sorter/overstock/") "; ?> |
Units sold:
|
|
|
"; ?> |
|