";
}
echo " | \n";
echo "{$parts[$i]['Part_No']} | \n";
if($parts[$i]['Part_Res_Flag'] == 0)
{
echo "{$parts[$i]['Part_Desc']} | \n";
}
else
{
echo "{$parts[$i]['Part_Desc']} (Discontinued) | \n";
}
echo "{$parts[$i]['Part_Type']} | \n";
echo "{$parts[$i]['Part_Unit_Qty']}/{$parts[$i]['Part_Unit']} | \n";
if($parts[$i]['Part_OnDemand'] == '1')
{
echo "On Demand | ";
}
else
{
$part_tot = $parts[$i]['Part_Unit_Qty'] * $parts[$i]['Part_Inv_Qty'];
echo "{$part_tot} | \n";
$query2 = "SELECT * FROM orders,order_items WHERE orders.Order_ID = order_items.Order_ID AND orders.Order_Status = 'o' and order_items.Part_ID = '{$parts[$i]['Part_ID']}'";
$result2 = mysqli_query($cxn,$query2) or die ("Query died: category");
$n2=1;
$n_orders2 = 0;
if (mysqli_num_rows($result2)==0)
{
echo "{$part_tot} | \n";
}
else
{
while($row2 = mysqli_fetch_assoc($result2))
{
foreach($row2 as $field => $value)
{
$orders2[$n2][$field]=$value;
}
$n2++;
}
$n_orders2 = sizeof($orders2);
$totpend = 0;
for ($j=1;$j<=$n_orders2;$j++)
{
$totpend = $totpend + $orders2[$j]['Order_Amount'];
}
foreach ($orders2 as $key => $value) {
unset($orders2[$key]);
}
$future_order = $parts[$i]['Part_Inv_Qty'] - $totpend;
$future_total = $future_order * $parts[$i]['Part_Unit_Qty'];
echo "$future_total | \n";
}
}
echo "
\n";
}
echo "