0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
while ($row22 = mysql_fetch_array($result33)) {
$form_id= $row22['form_id'];
$form_name= $row22['form_name'];
$display_forms .=" Form ID: $form_id $form_name -
Start/View/Edit Forms
";
}
// $sql33 ="SELECT SUM(quantity)AS instock2 FROM $table_name54 WHERE stock_status_id = '$quote1' ";
$sql33 ="SELECT SUM(quantity)AS instock2, SUM(price*.3 * quantity) AS InvValue FROM $table_name54 WHERE stock_status_id = '$quote1' ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
$instock2= $row22['instock2'];
$instockV2= $row22['InvValue'];
$instockV2=number_format($instockV2,2);
if ($instock2 ==$blink) {
$instock2=0;
}
$quote1=$backorder;
//$sql33 ="SELECT SUM(quantity)AS instock2 FROM $table_name54 WHERE stock_status_id = '$quote1' ";
// $result33 = @mysql_query($sql33,$connection) or die(mysql_error());
// $row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
// $backorder2= $row22['instock2'];
// if ($backorder2 ==$blink) {
// $backorder2=0;
// }
$sql33 ="SELECT * FROM $table_name90 where enabled=1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$num33 = mysql_num_rows($result33);
$backorder2=$num33;
if ($backorder2 ==$blink) {
$backorder2=0;
}
//$quote1=$outofstock;
//$quote1=2;
// $sql33 ="SELECT SUM(quantity)AS instock2 FROM .$table_name54 WHERE stock_status_id = '$quote1' ";
$sql33 ="SELECT product_id FROM .$table_name54 WHERE quantity < '$quote1' AND status=1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$num33 = mysql_num_rows($result33);
// $row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
// $outofstock2= $row22['instock2'];
$outofstock2=$num33;
if ($outofstock2 ==$blink) {
$outofstock2=0;
}
$hi="$hi3
User ID: $hi2
Group:$hi1
";
$hi4="";
$hi4 .="
$text_bob4
$text_bob5
$text_bob3
$text_bob2
Orders
Order Entry
Inventory
Inventory Detail
Barcode
Barcode Batch Printing
Pick Tickets
Back Order System
Quick Start Guide to Go Tool
Quick Start Guide to Go Tool -IPOD
Go Tool Guide to Inventory Management
Barcode Batch Printing Guide
";
$display_normal .="
Parts in Stock: $instock2
Parts in Backorder: $backorder2
Parts in Low Quantity (1 or less): $outofstock2
Estimated Inventory Value (30% of list):$ $instockV2";
$quote1 =$orders_backordered;
$sql33 ="SELECT distinct(order_id) FROM $table_name90 WHERE enabled =1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$num33 = mysql_num_rows($result33);
if ($num33 <1){
$display_backorder ="No Orders are affected by Back Order | ";
}else{
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
while ($row22 = mysql_fetch_array($result33)) {
// $row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
$order_idV= $row22['order_id'];
$sql33a ="SELECT * FROM .$table_name41 WHERE order_id ='$order_idV' ";
$result33a = @mysql_query($sql33a,$connection) or die(mysql_error());
while ($row22a = mysql_fetch_array($result33a)) {
$customerF= $row22a['firstname'];
$customerL= $row22a['firstname'];
$cust_nameF="$customerF $customerL";
$companyV= $row22a['payment_company'];
$po= $row22a['payment_method'];
$statusVV= "Back Ordered";
$dateModified= $row22a['date_modified'];
$total2= $row22a['total'];
$total2=number_format($total2,2);
}
$display_backorder .="
| $order_idV |
$cust_nameF
$companyV |
$statusVV |
$po |
$dateModified |
$ $total2 |
[ View ]
|
";
}}
$display_backorder2 .="
Orders Affected by Back Orders
| $column_order |
$column_customer |
$column_status |
PO / Payment |
Last Updated |
$column_total |
$column_action |
$display_backorder
";
//$tabby.="";
$tabby="";
$tabby.="";
$display_sales0.="
$text_latest_10_orders
| $column_order |
$column_customer |
$column_status |
$column_date_added |
$column_total |
$column_action |
;"
// $sql33 ="SELECT * FROM .$table_name93 WHERE enabled > 0";
//$sql33a ="SELECT * FROM .$table_name41 WHERE order_id ='$order_idV' ";
//$joey="cat";
?>