<?php

 $prog='';
 $prog="report/test_plain.php";
$sec_title1="Overview";
$sec_title2='';
$sec_title3='';
$sec_title4=" ";    //backorder title
$sec_title5="Quick Links";
$sec_title6="Forms";
$sec_title7='';
$sec_title8='';
$sec_title9='';
$sec_title10='';
$sec_title1000='';
$cust_id=0;
$display_listCL='';
 $display_listCLim='';
$title="Customer Service";




$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/GoTool/forms/htm/form$form_id.htm\" target=\"blank\">$form_name</a>     -    
<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_overview ='';

$display_notices .="
<a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=16&bod2=65\">New Registrations</a>:$num16_3<br/>

<hr><hr>
Waiting Approval<br/><br/>



";
      $sec_title1000="";


   require($vqmod->modCheck('admin/GoTool/forms/cust_id.php'));



$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>   ";      //   collaspe

 $display_answer2='';      //No collaspe below

 $display_answer2 .="

 <table><tr><td>
<h3 id=\"section1000\"> $sec_title1000<span></span><h3>
<iframe name=\"GoTool\" border=\"0\" width=\"800\" height=\"800\" source=\"GoTool/report/test.php?token=$tok\"></iframe>
 </td></tr></table>   ";


 $display_left="

 <p><font face=Arial><h1>Find Customer</h1></p>
<FORM  name=\"formcheck\" target=\"GoTool\" METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
    <p>By Find Company Name</p>
	<p><input type=\"text\" name=\"author\" size=\"20\"></p>
    <input type=\"hidden\" name=\"jedID2\" value=\"1\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>

</form>
    <p>Or</p>
<FORM  name=\"formcheck\" target=\"GoTool\" METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
    <p>By Dealer ID</p>
		<p><input type=\"text\" name=\"telephone\" size=\"20\"></p>

    <input type=\"hidden\" name=\"jedID2\" value=\"2\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>

</form>
    <p>Or</p>
<FORM  name=\"formcheck2\" target=\"GoTool\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
	<p><b>by Phone Number</b></p>
	<p><input type=\"text\" name=\"telephone\" size=\"20\"></p>
    <input type=\"hidden\" name=\"jedID2\" value=\"2\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>

</form>
   	<p>Or</p>
<FORM  name=\"formcheck3\" target=\"GoTool\" METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">

   <p><b>By Machine Serial Number<b></p>
	<p><input type=\"text\" name=\"serialA\" size=\"20\"></p>
    <input type=\"hidden\" name=\"jedID2\" value=\"3\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>
                                                  </font>
</form>                   <br/><br/>

 <FORM  name=\"formcheck3\" target=\"GoTool\" METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">

   <p><b>Add Comment to Dealer Profile<b></p>
    <select size=1 name=cust_idD >
                  <option selected value=$cust_id> $FCL[$cust_id]</option>
                 $display_listCL
                  </select>     <br/><br/>

                  Problem Category
		<select size=\"1\" name=\"prob\">
		<option value=\"Other\">Other</option>
		<option value=\"Upper Body\">Upper Body</option>
		<option value=\"Lower Body\">Lower Body</option>
		<option value=\"Electrical\">Electrical</option>
		<option value=\"Hydraulic\">Hydraulic</option>
		</select>      <br/><br/>

	<textarea name=\"add_comment\" cols=\"20\" rows=\"4\">Add Comment</textarea>
    <input type=\"hidden\" name=\"jedID2\" value=\"1000\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>
                                                  </font>
</form>


 ";



 $heading_title="Customer Service";



           $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>
      ";

      $display_backorder2='';

//$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 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";

?>