0 $partnosearch GROUP BY `partno`;";
//echo $queryClipped;
$resultClipped = mysqli_query($db,$queryClipped);
$i = 0;
while ($rowClipped = mysqli_fetch_array($resultClipped,MYSQLI_ASSOC))
{
$SKU = $rowClipped["partno"];
$qty_clipped = $rowClipped["qty_clipped"];
$partid = $rowClipped["partid"];
$partno = $rowClipped["partno"];
$pnchina = $rowClipped["pnchina"];
$paintingname = $rowClipped["paintingname"];
$artist = $rowClipped["artist"];
$cost = $rowClipped["cost"];
$artimage = $rowClipped["artimage"];
$countDays = $rowClipped["CountDays"];
$qty_on_hand = $row["qty_on_hand"];
mysqli_select_db($db,$dbname2);
$queryEventItem = "SELECT *,SUM(qty) AS sumItems FROM `eventItems` WHERE `SKU` LIKE '%" . $partno . "%' AND (`DateClipStart` <= '$now' AND `DateClipEnd` >= '$now') LIMIT 1;"; //`SKU` LIKE '%" . $partno . "%'
//echo $queryEventItem;
$resultEventItem = mysqli_query($db,$queryEventItem);
while ($rowEventItem = mysqli_fetch_array($resultEventItem,MYSQLI_ASSOC))
{
$mainSKU = $rowEventItem["SKU"];
$sumItems = $rowEventItem["sumItems"];
$SKU = $rowEventItem["artSKU"];
$eventID = $rowEventItem["eventID"];
$eventPrimary = $rowEventItem["primary"];
$queryEvent = "SELECT * FROM `saleEvents` WHERE `eventID` = '$eventID';";
$resultEvent = mysqli_query($db,$queryEvent);
$rowEvent = mysqli_fetch_array($resultEvent,MYSQLI_ASSOC);
//echo $queryEvent;
$eventCompany = $rowEvent["Company"];
$eventName = $rowEvent["Name"];
$eventDateStart = $rowEvent["DateStart"];
$eventDateEnd = $rowEvent["DateEnd"];
$eventClipStart = $rowEvent["DateClipStart"];
$eventClipEnd = $rowEvent["DateClipEnd"];
}
mysqli_select_db($db,$dbname);
//IF SHOWBONLY ITEMS TO REMOVE FROM CLIPPED
if($eventClipStart > 0 && $showOnly == "ON") continue;
$artSKU = strtoupper(substr($SKU,0,strpos($SKU,"-")));
$frameSKU = strtoupper(substr($SKU,strpos($SKU,"-")+1));
if ($artSKU == "")
{
$SKU = $SKU;
}
else
{
$SKU = $artSKU;
}
if (substr($SKU,strlen($SKU)-1,1) == "P")
$SKU = substr($SKU,0,-1); //removes last character in case it is Back Order
if(!in_array($SKU,$product_array))
{
$product_array[] = $SKU;
}
else continue;
$query1 = "SELECT ol.orderid,ol.quantity,ol.status,ol.qtyaccepted,ol.qtyReceived,ol.enddate,ol.cost,o.ordernumber FROM `orderlines` AS ol LEFT JOIN `orders` AS o ON o.`orderid` = ol.`orderid` WHERE ol.`status` <> 'Closed' AND ol.`status` <> 'Cancelled' AND ol.`partid`='" . $partid . "';";
//echo $query1;
$result3 = mysqli_query($db,$query1);
//$rowOnOrder = mysqli_fetch_array($result3, MYSQLI_NUM);
$qty_on_order = 0;
$qty_accept = 0;
$qty_received = 0;
$orderList = "";
while($rowOnOrder = mysqli_fetch_array($result3,MYSQLI_ASSOC))
{
$orderid = $rowOnOrder["orderid"];
$ordernum = $rowOnOrder["orderid"];
/*$lineid = $rowOnOrder["line_id"];*/
$status = $rowOnOrder["status"];
/*$quantity = $rowOnOrder["quantity"];
$qtyaccepted = $rowOnOrder["qtyaccepted"];
$qtyReceived = $rowOnOrder["qtyReceived"];*/
/*$startdate = $rowOnOrder["startdate"]; //number_format($rowOnOrder["sales"],2,'.',',');
$comments = $rowOnOrder["comments"];*/
$enddate = $rowOnOrder["enddate"];
/*$cost = $rowOnOrder["cost"];*/
$status_color = "#000000";
$query4 = "SELECT color FROM status WHERE status= '" . $status . "';";
$status1 = mysqli_query($db,$query4);
$row = mysqli_fetch_array($status1, MYSQLI_NUM);
$status_color = $row[0];
$orderList .= "
" . $ordernum . " Status:
" . $status . ""; //" End Date: " .$enddate . "
";
$qty_on_order += $rowOnOrder["quantity"];
$qty_accept += $rowOnOrder["qtyaccepted"];
$qty_received += $rowOnOrder["qtyReceived"];
}
$qty_remaining = $qty_on_order - $qty_received; //remove the qty received from order
$flag = "#000000";
$i == 0 ? $color = "#FFFFFF" : $color = "#DDDDDD";
$i == 0 ? $class = "normal" : $class = "normal2";
$i == 0 ? $i = 1 : $i = 0;
?>
" bgcolor="" style="color:;">
" . $partno . '
' . $pnchina; ?>
' . $artist . '
cost $: ' . $cost;
if($lineid != "")
{
?>
Edit Order Line |
0)
echo "
Qty on Hand: " . $qty_on_hand. "";
?>
0)
{
echo $eventCompany . "
" . $eventName . "
Start:" . date('F j, Y',$eventDateStart) . "
Ending:" . date('F j, Y',$eventDateEnd);
echo "
Start Clipping:" . date('F j, Y',$eventClipStart) . "
End Clipping:" . date('F j, Y',$eventClipEnd);
}
else echo "REMOVE FROM CLIPPED ASAP!";
?>
|
0)
echo "![](\"images/alert.png\")
" . $countBackorder . " On Backorder!";
mysqli_select_db($db,$dbname);
echo 'Qty on Event: ';
?>
$qty_on_hand) echo "
Qty on Event exceeds On Hand!!!";
echo '
Quantity Clipped: ' ; //. $qty_clipped;
?>
$qty_clipped) echo "Qty on Event exceeds Clipped!!!";
?> |
Qty Ordered: ' . $qty_on_order . '
Qty Received: ' . $qty_received . '
Qty Remaining: ' . $qty_remaining . '
Qty Dry & Ready: ' . $qty_accept;
if ( $etaDate != "" ) { echo "
ETA Date:
" . $dateETAformat . ""; }
else echo "
NO ETA DATE"; // $myrow["etaDate"]
?>
|
|
 |
";
echo "