<?php

  // $text_overview="Quick Links";

$sec_title1="Overview";
$sec_title2='';
$sec_title3='';
$sec_title4="";
$sec_title5="Quick Links";
$sec_title6="Forms";
$sec_title7='';
$sec_title8='';
$sec_title9='';
$sec_title10='';
$num1aa='';
$blink='';
 $display_listCL='';
$display_notices1='';
$display_listCLim='';
$cust_id='';

$total_pr='';

$sql33 ="SELECT * FROM $table_name108 WHERE enable = 1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num1aa[0] = mysql_num_rows($result33); //total machines

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=1 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num1aa[1] = 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());
  $num1aa[2] = 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());
  $num1aa[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());
   $num1aa[4] = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=5 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[5] = 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());
  $num1aa[6] = 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());
   $num1aa[7] = 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());
   $num1aa[8] = 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());
 $num1aa[9] = 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());
   $num1aa[10] = 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());
   $num1aa[11] = mysql_num_rows($result33);


  $result33 = @mysql_query($sql33,$connection) or die(mysql_error());
       // $row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
  while ($row22 = mysql_fetch_array($result33)) {
         $total_pr= $total_pr+ $row22['van47'];
}

include("cust_id.php");

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=12 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num1aa[12] = 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());
  $num1aa[13] = 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());
   $num1aa[14] = 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());
   $num1aa[15] = 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());
 $num1aa[16] = 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());
   $num1aa[17] = 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());
  $num1aa[18] = 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());
   $num1aa[13] = 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());
   $num1aa[14] = 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());
   $num1aa[15] = 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());
   $num1aa[16] = 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());
   $num1aa[17] = 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());
   $num1aa[18] = mysql_num_rows($result33);

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=19 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[19] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=20 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[20] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=21 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[21] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=22 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[22] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=23 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[23] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=24 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[24] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=25 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[25] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=26 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[26] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=27 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[27] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=28 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[28] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=29 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[29] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=30 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[30] = mysql_num_rows($result33);


$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=31 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
   $num1aa[31] = mysql_num_rows($result33);


  $result33 = @mysql_query($sql33,$connection) or die(mysql_error());
       // $row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
  while ($row22 = mysql_fetch_array($result33)) {
         $total_pr= $total_pr+ $row22['van47'];
}

$sql33 ="SELECT * FROM $table_name96 WHERE status = 3 AND form_id=12 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
  $num1aa[12] = 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());
  $num1aa[13] = 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());
   $num1aa[14] = 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());
   $num1aa[15] = 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());
 $num1aa[16] = 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());
   $num1aa[17] = 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());
  $num1aa[18] = mysql_num_rows($result33);


   $instock = 7;
 $backorder =9;
 $outofstock =5;
 $orders_backordered=27;
$blink="";
$quote1=$instock;
// $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;
         }


  $sql33 ="SELECT * FROM $table_name93 WHERE (group_owner='$user_gid' OR group_owner=1) AND 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 $form_name     -    
<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 * FROM $table_name96 WHERE status = 3 AND form_id='$form_id' ";
//$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
//$num1aa = mysql_num_rows($result33);


$display_notices1 .="

<a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=$form_id&bod2=65\">$form_name</a>:$num1aa[$form_id] <br/>

";


}


$display_notices .="Awaiting Approval <br/> $display_notices1";


 $hi="$hi3<br/> User ID: $hi2 - Group:$hi1 <br />";
  $hi4="";
  $hi4 .="


  <a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=1\">Warehouse Entries</a> <br/>
  <a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=11\">Purchase Requests</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/>


 ";

 $display_overview .="
  <select size=1 name=cust_idD >
                  <option selected value=$cust_id> Locate Credit Limit</option>
                 $display_listCLim
                  </select><br/>

                  <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/>
              <a href=\"$loc2/admin/GoTool/special/special.php?jed=4&pit=0&token=$tok&log=$logged/ \">Total Machines in the System</a>: $num1aa[0]<br />
           ";

           $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 .="
   

     ";

    }}


$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>";

$tabby="";

$tabby.="<div class=\"vtabs\"><a href=\"#tab-stat\">Statistics</a><a href=\"#tab-notices0\">Latest Sales</a><a href=\"#tab-notices1\">Latest Backorders</a> <a href=\"#tab-notices\">Latest Notices</a>
<a href=\"#tab-links\">Quick Links</a></div>";


$display_sales0.="
<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> ;"


?>