<?php

 $prog='';
 $prog="report/test_plain.php";
$sec_title1="Overview";
$sec_title2='';
$sec_title3='';
$sec_title4="Orders Affected by Back Order";
$sec_title5="Quick Links";
$sec_title6="Forms";
$sec_title7='';
$sec_title8='';
$sec_title9='';
$sec_title10='';
$sec_title1000='';
$num1aa='';

$display_forms_Parts='';


$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num1_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=2 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num2_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=3 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num3_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=4 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num4_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=4 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num5_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=6 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num6_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=7 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num7_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=8 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num8_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=9 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num9_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=10 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num10_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=11 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num11_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=12 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num12_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=13 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num13_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=14 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num14_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=15 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num15_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=16 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num16_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=17 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num17_1 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 1 AND form_id=18 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num18_1 = mysql_num_rows($result33);




$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num1_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=2 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num2_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=3 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num3_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=4 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num4_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=4 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num5_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=6 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num6_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=7 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num7_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=8 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num8_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=9 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num9_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=10 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num10_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=11 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num11_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=12 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num12_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=13 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num13_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=14 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num14_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=15 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num15_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=16 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num16_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=17 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num17_3 = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=18 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num18_3 = mysql_num_rows($result33);


  // $text_overview="Quick Links";

//$display_forms="";
   $instock = 7;
 $backorder =9;
 $outofstock =5;
 $orders_backordered=27;
$blink="";
$quote1=$instock;


  $sql33 ="SELECT * FROM $table_name93 WHERE enabled > 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     
<a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&bod2=55&log=$logged&fid=$form_id\"><div class=\"bbutton2\">Start New Forms</div></a> <a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=$form_id\"><div class=\"bbutton2\">View/Edit (Unsubmitted) Forms</div></a><br/><br/>";



$display_forms_Parts .=" Form ID: $form_id     
<a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&bod2=55&log=$logged&fid=$form_id\"><div class=\"bbutton2\">Start New Forms</div></a> <a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=$form_id\"><div class=\"bbutton2\">View/Edit (Unsubmitted) Forms</div></a><br/><br/>";
}



// $sql33 ="SELECT SUM(quantity)AS instock2 FROM $table_name54 WHERE stock_status_id = '$quote1' ";
  $sql33 ="SELECT SUM(quantity)AS instock2, SUM(cost * 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="User ID: $hi2 - Group:$hi1";
  $hi4="";
  $hi4 .="

  <a href=\"$loc2/admin/index.php?route=GoTool/machine&amp;token=$tok&log=$logged\">$text_bob4</a> <br/>
              <a href=\"$loc2/admin/index.php?route=GoTool/part&amp;token=$tok&log=$logged\">$text_bob5</a> <br/>
             <a href=\"$loc2/admin/index.php?route=GoTool/po&amp;token=$tok&log=$logged\">$text_bob3</a>  <br/>
              <a href=\"$loc2/admin/index.php?route=GoTool/test&amp;token=$tok&log=$logged\">$text_bob2</a>  <br/>
              <a href=\"$loc2/admin/index.php?route=sale/order&amp;token=$tok\">Orders</a>  <br/>
             <a href=\"$loc2/admin/index.php?route=sale/order_entry&amp;token=$tok\">Order Entry</a>  <br/>
             <a href=\"$loc2/admin/index.php?route=catalog/product_extra&amp;token=$tok\">Inventory</a>  <br/>
              <a href=\"$loc2/admin/index.php?route=catalog/product2&amp;token=$tok\">Inventory Detail</a>  <br/>
               <a href=\"$loc2/admin/index.php?route=catalog/product2&amp;token=$tok\">Barcode</a>  <br/>
                <a href=\"$loc2/admin/index.php?route=GoTool/barcodeprint&amp;token=$tok&log=$logged\">Barcode Batch Printing</a>  <br/>
               <a href=\"$loc2/admin/index.php?route=GoTool/pick&amp;token=$tok&log=$logged\">Pick Tickets</a>  <br/>
               <a href=\"$loc2/admin/index.php?route=GoTool/back&amp;token=$tok&log=$logged\">Back Order System</a>  <br/><br/>
               <hr><hr>
		<a href=\"$loc2/admin/guides/SanyQuickstart.pdf\" target=\"blank\">Quick Start Guide to Go Tool</a>  <br/>
		<a href=\"$loc2/admin/guides/SanyIPOD.pdf\" target=\"blank\">Quick Start Guide to Go Tool -IPOD</a> <br/>
		<a href=\"$loc2/admin/guides/TrainingInventory73012.pdf\" target=\"blank\">Go Tool Guide to Inventory Management</a>  <br/>	
		<a href=\"$loc2/admin/guides/BarcodeBatch.pdf\" target=\"blank\">Barcode Batch Printing Guide</a>  <br/>		

 ";

 $display_overview .="
               <a href=\"$loc2/admin/index.php?route=catalog/product2&amp;token=$tok\">Parts</a> in Stock: $instock2<br />
              <a href=\"$loc2/admin/index.php?route=GoTool/back&amp;token=$tok&log=$logged\">Parts in Backorder</a>: $backorder2<br />
              Parts in Low Quantity (1 or less):  $outofstock2<br />
              Estimated Inventory Value:$ $instockV2<br/>";

$display_notices .="

Waiting Approval<br/><br/>


<a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=1&bod2=65\">Warehouse Entry</a>:$num1_3<br/>
<a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=2&bod2=65\">Delivery Order</a>:$num2_3<br/>



";
      $sec_title1000="Detailed Search Results";

$display_answer2="


 <table><tr><td>
<h3 class=\"collapsible\" id=\"section1000\"> $sec_title1000<span></span><h3>
<div class=\"container\">
<iframe name=\"GoTool\" border=\"0\" width=\"800\" height=\"800\" source=\"GoTool/report/test.php?token=$tok\"></iframe>
</div>
 </td></tr></table>   ";


 $display_left="

 
 ";







           $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 ="<td class=\"center\" colspan=\"6\">No Orders are affected by Back Order</td>";

  }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 .="





       <tr>
                <td class=\"right\">$order_idV</td>
                <td class=\"left\">$cust_nameF<br/> $companyV</td>
                <td class=\"left\">$statusVV</td>
                 <td class=\"left\">$po</td>
                <td class=\"left\">$dateModified</td>
                <td class=\"right\">$ $total2</td>
                <td class=\"right\">  [ <a href=\"$loc2/admin/index.php?route=sale/order/info&amp;token=$tok&amp;order_id=$order_idV\">View</a> ]
                  </td>
              </tr>

     ";

    }}


          $display_backorder2 .="
      
 
          <table class=\"list\">
            <thead>
              <tr>
                <td class=\"right\">$column_order</td>
                <td class=\"left\">$column_customer</td>
                <td class=\"left\">$column_status</td>
                <td class=\"left\">PO / Payment</td>
                <td class=\"left\">Last Updated</td>
                <td class=\"right\">$column_total</td>
                <td class=\"right\">$column_action</td>
              </tr>
            </thead>
            <tbody>
            $display_backorder
            </tbody>
          </table>
      ";

//$tabby.="<div class=\"vtabs\"><a href=\"#tab-stat\">Statistics</a><a href=\"#tab-notices\">Latest Notices</a>
//<a href=\"#tab-links\">Quick Links</a></div>";


$george=" <h3 class=\"collapsible\" id=\"section1000\">Parts<span></span><h3>
<div class=\"container\">
<a href=\"$loc2/admin/index.php?route=sale/order&amp;token=$tok\"><b>Orders</b></a> <br/><br/> <br/>

 <b>Back Orders</b> $display_backorder2<br/> $hi4<br/>$display_forms_Parts</div></div>";

$tabby="";

$tabby.="<div class=\"vtabs\"><a href=\"#tab-stat\">Statistics</a><a href=\"#tab-notices0\">Latest Orders</a><a href=\"#tab-notices1\">Latest Backorders</a> <a href=\"#tab-notices\">Latest Notices</a>
<a href=\"#tab-links\">Quick Links</a><a href=\"#tab-forms\">Forms</a></div>";


$display_sales0.="
 <a href=\"javascript:toggleDiv('myContent1');\" style=\"background-color: #a81d1d; padding: 5px 10px; text-decoration: none;\"><font color=white><b>Latest Orders</b></font></a>
<div id=\"myContent1\" style=\"background-color: #FFFFFF; padding: 5px 10px;\">  
<div class=\"dashboard-heading\">$text_latest_10_orders</div>
        <div class=\"dashboard-content\">
<table class=\"list\">
            <thead>
              <tr>
                <td class=\"right\">$column_order</td>
                <td class=\"left\">$column_customer</td>
                <td class=\"left\">$column_status</td>
                <td class=\"left\">$column_date_added</td>
                <td class=\"right\">$column_total</td>
                <td class=\"right\">$column_action</td>
              </tr>
            </thead>
            <tbody> ;"



// $sql33 ="SELECT * FROM .$table_name93 WHERE enabled > 0";

 //$sql33a ="SELECT * FROM .$table_name41 WHERE order_id ='$order_idV' ";

//$joey="cat";

?>