<?php

  // $text_overview="Quick Links";
  $prod_table='';
  $prod_table1='';
 $prog='';
 $i='';
 $prog="report/test_sales.php";
$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);

   $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);


  $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_name93 WHERE (group_owner='$user_gid' OR form_id=11 ) 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_notices1 .="

 <a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=14&bod2=65\">Sales Quotes: $num1aa[14]</a> <br/>
  <a href=\"$loc2/admin/index.php?route=GoTool/forms&amp;token=$tok&log=$logged&fid=4&bod2=65\">Order Acknowledgements :$num1aa[4]</a> <br/>

 ";

$display_notices .="Awaiting Approval <br/> $display_notices1";



 $hi="$hi3<br/> User ID: $hi2 - Group:$hi1 <br />";
  $hi4="";


  $hi4="
      <a href=\"$loc2/admin/GoTool/special/special.php?jed=4&pit=1&token=$tok&log=$logged/ \">Latest 5 Machines</a><br/>
               <a href=\"$loc2/admin/GoTool/special/special.php?jed=2&pit=1&token=$tok&log=$logged/ \">Latest 5 Logistics Entries</a><br/>
                 <a href=\"$loc2/admin/GoTool/special/special.php?jed=0&pit=1&token=$tok&log=$logged/ \">Latest 5 Machines Production</a><br/>
        <a href=\"$loc2/admin/GoTool/special/special.php?jed=4&pit=1/ \">Machine Serial</a><br/>
           <a href=\"$loc2/admin/GoTool/special/administrator/main.php?/ \">Editing Records</a><br/>
";

 $display_overview .="  Number of quotes started by Regions: 0   <br/>
                    <a href=\"$loc2/admin/GoTool/special/special.php?jed=2&pit=1&token=$tok&log=$logged/\">Number</a> of machines in Transit from Sany China: 0   <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 />

Machines sold this year: <br />
Machines sold this time period: <br />
Machines sold last year: <br />
Number of Quotes Generated last 90 days: <br />
Number of Quotes converted to sales: <br />

 ";


    $sql331 ="SELECT * FROM $table_name105 WHERE enable > 0 Order by id DESC limit 5";
  $result331 = @mysql_query($sql331,$connection) or die(mysql_error());
  while ($row23 = mysql_fetch_array($result331)) {
             $id=  $row23['id'];
             $Type=$row23['Type'];
$Model=$row23['Model'];
$Dealer_id=$row23['Dealer_ID'];
$Customer=$row23['Customer'];
$PO=$row23['PO'];
$S_N=$row23['S_N'];
$SANY_SERIAL=$row23['SANY_SERIAL'];
$PO_Configuration=$row23['PO_Configuration'];
$Invoice_Date=$row23['Invoice_Date'];
$Original_Due_Date=$row23['Original_Due_Date'];
$Collection_Date=$row23['Collection_Date'];
$Sales_Status=$row23['Sales_Status'];
$Stock_Contract_No=$row23['Stock_Contract_No'];
$Requested_ETA=$row23['Requested_ETA'];
$Vessel_Date=$row23['Vessel_Date'];
$Actual_ETA=$row23['Actual_ETA'];
$Stock_Contract_Config=$row23['Stock_Contract_Config'];
$Key_Availability=$row23['Key_Availability'];
$Production_ShippingStatus=$row23['Production_ShippingStatus'];
$Other=$row23['Other'];
$enable=$row23['enable'];


  $prod_table .="

      <td>$id
      <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"21\">
	<input type=\"hidden\" name=\"map_id\" value=\"$id\">
<input type=\"submit\" value=\"VIEW \" name=\"B3\">
              </form>

      </td>
        <td>$Type</td>
        <td>$Model</td>

        <td>$Customer</td>
        <td>$PO</td>
        <td>  $S_N
        <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"51\">
    <input type=\"text\" size=\"15\" name=\"tied\" value=\"$S_N\">
	<input type=\"hidden\" name=\"map_id\" value=\"$id\">
<input type=\"submit\" value=\"UPDATE \" name=\"B3\">
              </form>

        </td>
        <td> $SANY_SERIAL
                <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"5\">
    <input type=\"text\" size=\"15\" name=\"tied\" value=\"$SANY_SERIAL\">
	<input type=\"hidden\" name=\"map_id\" value=\"$id\">
<input type=\"submit\" value=\"UPDATE \" name=\"B3\">
              </form>
        </td>
        <td>$PO_Configuration</td>
        <td>$Invoice_Date</td>

        <td>$Collection_Date</td>
        <td>$Sales_Status</td>
        <td>$Stock_Contract_No</td>

    <td>$Stock_Contract_Config</td>
       <td>
        <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"5\">
	<input type=\"hidden\" name=\"map_id\" value=\"$id\">
<input type=\"submit\" value=\"UPDATE \" name=\"B3\">
              </form>
       </td>


        </tr>






    ";


       }


  $prod_table1 .="

  <table><tr><td>
   <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"3\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
<input type=\"submit\" value=\"Show All \" name=\"B3\">
              </form>

  </td><td>
  <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID5\" value=\"1\"  />
  	<input type=\"hidden\" name=\"gbad\" value=\"7\">
	<input type=\"hidden\" name=\"map_id\" value=\"$id\">
<input type=\"submit\" value=\"ADD Record \" name=\"B3\">
              </form>

  </td></tr></tr></table>

   <table class=\"list\">
  <thead>
         <tr>
        <td class=\"filterable\">#</td>
        <td class=\"filterable\">Type</td>
        <td class=\"filterable\">Model</td>

        <td class=\"filterable\">Customer</td>
        <td class=\"filterable\">PO</td>
        <td class=\"filterable\">S/N</td>
         <td class=\"filterable\">SANY SERIAL</td>
        <td class=\"filterable\">PO Configuration</td>
        <td class=\"filterable\">Invoice Date</td>

        <td class=\"filterable\">Collection Date</td>
        <td class=\"filterable\">Sales Status</td>
        <td class=\"filterable\">Stock Contract No</td>
                <td class=\"filterable\">Stock Contract Config</td>

        <td class=\"filterable\">Action</td>
         </tr>
         </thead><tbody>
         <tr class=\"filter\">
          <td align=\"right\"><input type=\"text\" name=\"filter_id\" value=\"\" size=\"3\" onkeyup=\"Table.filter(this,this)\"/></td>
          <td align=\"right\"><input type=\"text\" name=\"filter_type\" value=\"\" size=\"3\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_model\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>

<td align=\"right\"><input type=\"text\" name=\"filter_customer\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_PO\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_SN\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_SANY_Serial\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>

<td align=\"right\"><input type=\"text\" name=\"filter_Org\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_Status\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_contract\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"right\"><input type=\"text\" name=\"filter_Config2\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>
 <td align=\"right\"><input type=\"text\" name=\"filter_Config\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>

<td align=\"right\"><input type=\"text\" name=\"filter_act\" value=\"\" size=\"12\" onkeyup=\"Table.filter(this,this)\"/></td>
    </tr>

         $prod_table </tbody>
         </table>









  ";


    $heading_title="SALES";

     $display_block_call=''; //use for special announcements

    $display_block_call55 .="




    <img border=\"0\" src=\"$loc2/admin/GoTool/forms/fill/Sany_horiz_logo.png\" width=\"230\" height=\"67\"> <br/>

     <h3 class=\"collapsible\" id=\"section1\">$sec_title1<span></span><h3>
<div class=\"container\">
    <div class=\"content\">

    <table><tr><td width=\"450\">$display_overview</td> <td width=\"450\">$display_notices</td></tr></table>


    </div>
</div>

  <h3 class=\"collapsible\" id=\"section2\">Last 5 Crane Production Entries<span></span><h3>
<div class=\"container\">
    <div class=\"content\">

$prod_table1


    </div>
</div>

  <h3 class=\"collapsible\" id=\"section3\">Last 5 Logistic Entries<span></span><h3>
<div class=\"container\">
    <div class=\"content\">

    <table><tr><td width=\"450\">$display_overview</td> <td width=\"450\">$display_notices</td></tr></table>


    </div>
</div>

  <h3 class=\"collapsible\" id=\"section4\">Last 5 Machine Serial Numbers Issued<span></span><h3>
<div class=\"container\">
    <div class=\"content\">

    <table><tr><td width=\"450\">$display_overview</td> <td width=\"450\">$display_notices</td></tr></table>


    </div>
</div>

<h3 class=\"collapsible\" id=\"section5\">Quick Links<span></span><h3>
<div class=\"container\">
    <div class=\"content\">

        <p>$hi4</p>
    </div>
</div>

<h3 class=\"collapsible\" id=\"section6\">$sec_title6<span></span><h3>
<div class=\"container\">
    <div class=\"content\">

        <p>$display_forms</p>
    </div>
</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 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> ;"










?>