<?php
$logo="";
 $prog='';
 $i='';
 $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_listMchDL='';
   $display_listMchMDL=''; 
     $display_listMchT='';
   $gbad='';


$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/>
               <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'));
 require($vqmod->modCheck('admin/GoTool/forms/mach_id.php'));

$hi2 = sprintf($this->user->getId());

 $sql35 ="SELECT * FROM .$table_name113 WHERE agent_id = '$hi2' Order by create_date DESC limit 5 ";
        $result225 = @mysql_query($sql35,$connection) or die(mysql_error());
         while ($row1225 = mysql_fetch_array($result225)) {
          $form_id=  $row1225['form_id'];
            $map_id=  $row1225['map_id'];
            $map_id2=  $row1225['map_id2'];    //record
         $app_id=  $row1225['app_id'];     //order
          $map_id=  $row1225['map_id'];
          $comment23=  $row1225['van3'];
$tied="$map_id-$app_id";
$id2=  $row1225['customer_id'];
          $cat23=  $row1225['prob'];
          $status= $row1225['status'];
          $model2= $row1225['van21'];
          $serial2= $row1225['van22'];
          if ($status==1){
          $status2="Open";
          }else {
          $status2="Closed";
          }
          $commentdate=  $row1225['create_date'];

          $display_commentU .="<tr> <td class=\"left\">$form_id-$map_id-$app_id </td><td class=\"left\">$commentdate</td><td>$cat23</td><td>$model2</td><td>$serial2</td><td>$status2</td> <td class=\"left\">$comment23</td>
<td class=\"left\"><FORM  name=\"formcheck3\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
	<input type=\"hidden\" name=\"tied\" value=\"$tied\">
<input type=\"hidden\" name=\"map_id\" value=\"$map_id\">
    	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    <input type=\"hidden\" name=\"jedID2\" value=\"1006\"  />
    <input type=\"hidden\" name=\"cust_idD\" value=\"$id2\">
   <input type=\"submit\" value=\"Show Complete Ticket\" name=\"B1\">

</form></td>
<td class=\"left\"> <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"9012\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"2\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
<input type=\"hidden\" name=\"tied\" value=\"$tied\">
  <input type=\"hidden\" name=\"cust_idD\" value=\"$id2\">
<input type=\"submit\" value=\"Add Note\" name=\"B2\">
              </form>  </td></tr> ";
          }

$display_commentUU .="<table  class=\"list\">
<thead>
<tr>
 <td class=\"left\"> Ticket Id</td>
 <td class=\"left\"> Date</td>
 <td class=\"left\"> Category</td>
  <td class=\"left\"> Model</td>
  <td class=\"left\"> Serial</td>
 <td class=\"left\"> Status</td>
 <td class=\"left\"> Comment</td> <td class=\"left\"> Review</td><td class=\"left\"> Action</td>  </tr> </thead>
     $display_commentU
    </table>   ";


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

 ";

$display_left ='';

 $heading_title="Customer Service";


     $display_backorder .="";


          $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='';


$display_customerserv .="


<img border=\"0\" src=\"$loc2/admin/GoTool/forms/fill/Sany_horiz_logo.png\" width=\"230\" height=\"67\"><br/>
Your Last 5 Tickets:<br/>
$display_commentUU <br><br>
 <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
	<input id=\"cust_name\" type=\"text\" name=\"cust_name\" value=\"\" size=\"40\" />
	<input type=\"hidden\" name=\"cust_idD\" value=\"\" />
    <input type=\"hidden\" name=\"jedID5\" value=\"5000\"  />
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\" />
	<input type=\"submit\" value=\"Retrieve Machines\" name=\"B1\">
 </form>
<p style=\"margin-top: 0; margin-bottom: 0\"><font face=\"Arial\" size=\"2\">Ticket $van[1]

<table><tr><td><a href=\"$loc2/admin/index.php?route=catalog/product2&amp;token=$tok\">Parts</a></td><td><FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"0\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"2\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
<input type=\"submit\" value=\"Customers\" name=\"B2\">
              </form> </td> <td>Attachments</td></td><td>Feedback</td></tr></table>

</font></p>

<p style=\"margin-top: 0; margin-bottom: 0\"><font face=\"Arial\" size=\"2\">Date:
$van[2]&nbsp;&nbsp;&nbsp;&nbsp; Status:
$van[3]&nbsp;&nbsp;&nbsp; </font></p>
<p style=\"margin-top: 0; margin-bottom: 0\">&nbsp;</p>
 <FORM  name=\"formcheck344\" target=\"GoTool\" METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
<table border=\"0\" width=\"100%\" cellspacing=\"4\">

 <tr>
		<td width=\"16%\"><font face=\"Arial\" size=\"2\">Contact Name</font></td>
		<td width=\"33%\"><font face=\"Arial\" size=\"2\">Contact Phone</font></td>
		<td width=\"28%\"><font face=\"Arial\" size=\"2\">Contact Email</font></td>
		<td width=\"20%\"><font face=\"Arial\" size=\"2\">
Dealer</font></td>
	</tr>
	<tr>
		<td width=\"16%\" height=\"26\">
		<input id=\"contact_name\" type=\"text\" name=\"5\" size=\"24\" value=\"$van[5]\"></td>
		<td height=\"26\" width=\"33%\">
		<input id=\"phone\" type=\"text\" name=\"6\" size=\"24\" value=\"$van[6]\"></td>
		<td height=\"26\" width=\"28%\">
		<input id=\"email\" type=\"text\" name=\"14\" size=\"34\" value=\"$van[14]\"></td>
		<td id=\"dealer_id\" height=\"26\" width=\"20%\">
		<input type=\"hidden\" name=\"cust_idD\" value=\"\" />
		</td>
	</tr>
	<tr>
		<td width=\"16%\">&nbsp;</td>
		<td width=\"33%\">&nbsp;</td>
		<td width=\"28%\">&nbsp;</td>
		<td width=\"20%\">&nbsp;</td>
	</tr>
	<tr>
		<td width=\"16%\"><font face=\"Arial\" size=\"2\">Product Type</font></td>
		<td width=\"33%\"><font face=\"Arial\" size=\"2\">Model</font></td>
		<td width=\"28%\"><font face=\"Arial\" size=\"2\">Serial Number</font></td>
		<td width=\"20%\">&nbsp;</td>
	</tr>
	<tr>
		<td width=\"16%\"><select size=1 name=7 >
                  <option selected value=$van[7]> $van[7]</option>
                  $display_listMchT
                  </select></td>
		<td width=\"33%\"><select size=1 name=8 >
               <option selected value=$van[8]> $van[8]</option>
                 $display_listMchMDL
                  </select></td>
		<td width=\"28%\"><input type=\"text\" name=\"9\" size=\"34\" value=\"$van[9]\"></td>
		<td width=\"20%\">&nbsp;</td>
	</tr>
	<tr>
		<td width=\"16%\"><font face=\"Arial\" size=\"2\">Call Type</font></td>
		<td width=\"33%\"><font face=\"Arial\" size=\"2\">Priority Code</font></td>
		<td width=\"28%\"><font face=\"Arial\" size=\"2\">Assigned Region</font></td>
		<td width=\"20%\"><font face=\"Arial\" size=\"2\">Assigned Person/Group</font></td>
	</tr>
	<tr>
		<td width=\"16%\"><select size=1 name=10 >
                  <option selected value=$van[10]> $van[10]</option>
                 <option value=Parts> Parts</option>
<option value=Service>Service</option>
<option value=Other>Other</option>
                  </select></td>
		<td width=\"33%\">
<select size=1 name=11 >
<option value=\"INB\">INB: Inbound spk w/:</option>
<option value=\"EMA\">EMA: E-mail from</option>
<option value=\"NA\">NA:No Answer</option>
<option value=\"Te-S\">Te-S: Telephone Service</option>
<option value=\"Te- C\">Te-C:&nbsp;Telephone Company </option>
<option value=\"WR\">WR: Warranty Request received</option>
<option value=\"WRR\">WRR: Warranty Registion Received</option>
<option value=\"TDLM\">TDLM: Telephone D/ Left Message</option>
<option value=\"WP\">WP:  Warranty has been process</option>
<option value=\"OB\">OB:  Outbound calls</option></select></td>
		<td width=\"28%\"><input type=\"text\" name=\"14\" size=\"34\" value=\"$van[14]\"></td>
		<td width=\"20%\"><input type=\"text\" name=\"15\" size=\"26\" value=\"$van[15]\"></td>
	</tr>
	<tr>


    	<tr>
		<td width=\"200\">&nbsp;</td>
		<td width=\"419\">&nbsp;</td>
		<td width=\"247\">&nbsp;</td>
		<td>Problem Type: <select size=\"1\" name=\"prob\">
        <option value=\"Other\">Other</option>
			<option value=\"Upper\">Upper</option>
			<option value=\"Lower\">Lower</option>
			<option value=\"Electrical\">Electrical</option>
			<option value=\"Hydraulic\">Hydraulic</option>
			<option value=\"Shipping\">Shipping</option>
			</select> </td>
	</tr>

	<tr>
		<td colspan=\"4\"><font face=\"Arial\" size=\"2\">Add Comment</font></td>
	</tr>
	<tr>
		<td colspan=\"4\"><textarea rows=\"3\" name=\"add_comment\" cols=\"100\">$van[18]</textarea></td>
	</tr>

	<tr>
		<td colspan=\"4\">
          </p>
        <input type=\"hidden\" name=\"jedID2\" value=\"1000\"  />
<input type=\"hidden\" name=\"m\" value=\"$i\"  />
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
   <input type=\"submit\" value=\"Add Comment\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"> </form>
<br/><br/>


		<p style=\"margin-top: 0; margin-bottom: 0\" align=\"right\">
		<font face=\"Arial\" size=\"2\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <table><tr><td>

		Cancel </td><td>
          <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1006\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"2\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
<input type=\"submit\" value=\"Show All Tickets\" name=\"B2\">
              </form>   </td><td>

   <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1006\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"3\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
<input type=\"submit\" value=\"Show All Open Tickets\" name=\"B3\">
              </form>    </td><td>


   <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1006\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"4\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
<input type=\"submit\" value=\"Show All Closed Tickets\" name=\"B4\">
              </form>  </td><td>

        Feedback  </td><td> Claims  </td><td>
		RMA& </td></tr>  </table>


        </td>
	</tr>
         </table>
                    </div>


  <div class=\"slide-out-div\">
            <a class=\"handle\">Search Menu</a>
            <p><font face=Arial><h1>Find Customer</h1></p>
<FORM  name=\"formcheck\"  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=\"jedID5\" value=\"5000\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>

</form>

<FORM  name=\"formcheck\"  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=\"jedID5\" value=\"5000\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>

</form>

<FORM  name=\"formcheck2\" 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=\"jedID5\" value=\"5000\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>

</form>
 
<FORM  name=\"formcheck3\"  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=\"5000\"  />
	<p><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>
                                                  </font>
</form>                   <br/><br/>


        </div>
        

";


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

?>