<?php include("../../include/dbconnect.php");?>
<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<title>WPT WILSON PRESS TOOLS</title>

<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";
	}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
.style1 {font-size: 14pt}
-->
</style>

</head>

<body lang=EN-US>

<div class=Section1>

<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
 style='border-collapse:collapse;border:none'>
 <tr>
  <td width=590 colspan=7 valign=top style='width:6.15in;border:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><b><i><span
  style='font-size:14.0pt'>WPT WILSON PRESS TOOLS</span></i></b></p>
  <p class=MsoNormal>                                         <span
  style='font-size:10.0pt'>Admn. Office &amp; Works</span></p>
  <p class=MsoNormal><span style='font-size:10.0pt'>                                                    
  572, Avanashi Road, Coimbatore – 641 037.</span></p>
  <p class=MsoNormal><span style='font-size:10.0pt'>                                      
           Phone : 0422-2214605, 2215965 Fax : 0422-2211407</span></p>
  <p class=MsoNormal><span style='font-size:10.0pt'>                                       
          Email : wilpretool@yahoo.com</span></p>
  <p class=MsoNormal>&nbsp;</p>  </td>
 </tr>
 <form name="myForm02" method="Post"  action="editsave.php">
<?php 
//echo "rec" . "$record";

$query = mysql_query("SELECT  distinct record, bcode,  quot_refno, quot_refdt, attn, yr_refno, yr_refdt, enquiry_refno, enquiry_refdt, prodcode, drawing_no, prodname, rawoffer, rawrate, rawcost, invper, invcost, processcost, admnexp, scrapcost, tlcost, delperiod, st, exduty, pandf, payterms, price, subtot, tot, rawwgt FROM quotation WHERE record ='$record'") or die( mysql_error() );;

//$result1=mysql_query($query) or die('Queryproblem: ' . mysql_error() . '<br />Executed query: ' . $query);

$row3=mysql_fetch_row($query);

$bkquery = mysql_query("SELECT bcode, prodname, drawing_no, prodcode
FROM product WHERE prodcode = '$row3[2]' AND bcode = '$row3[1]'")or die( mysql_error() );
$row2 = mysql_fetch_row($bkquery);

$stQuery = mysql_query("select bcode,name,unit, address1, address2, city, buyertype from buy  where bcode= '$row3[1]' order by name")or die( mysql_error() );
$row1 = mysql_fetch_row($stQuery);

?>
<input type="hidden" name="enqrefno" value="<? echo($row3[4]); ?>">
<input type="hidden" name="enqrefdt" value="<? echo($row3[5]); ?>">
<input type="hidden" name="rec" value="<? echo($row3[0]); ?>">
<input type="hidden" name="prodcode" value="<? echo($row3[9]); ?>">
<input type="hidden" name="bcode" value="<? echo($row3[1]); ?>">

<SCRIPT LANGUAGE="JavaScript" src="../../include/CalendarPopup.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
var cal = new CalendarPopup();
</SCRIPT>
<?
if(empty($sdt))
{
  $sdt=strftime ("%d/%m/%Y", mktime (0,0,0,date("m"),date("d"),date("Y"))); 
}?>
 <tr>
  <td width=295 colspan=3 valign=top style='width:221.35pt;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>To</p>
  <p class=MsoNormal>M/s.<span class="style1">
    <INPUT style="border: 0px solid #000000;" VALUE="<?=$row1[1]?>" size="40"  >
  </span></p>
  <p class=MsoNormal style1><INPUT  style="border: 0px solid #000000;"  VALUE="<?=$row1[2]?>" size="35"  </p>
  <p class=MsoNormal style1> <INPUT style="border: 0px solid #000000;" VALUE="<?=$row1[3]?>"  size="35"</p>
  <p class=MsoNormal> <span class="style1"><INPUT  style="border: 0px solid #000000;"VALUE="<?=$row1[4]?>" size="35" </span></p>  </td>
  <td width=295 colspan=4 valign=top style='width:221.45pt;border-top:none;
  border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><b>QUOTATION</b></p>
  <p align="left" class=MsoNormal>Quotation No :<input style="border: 0px solid #000000;" type="text" name="quot_refno" value="<? echo($row3[2]); ?>"></p>  
  <p align="left" class=MsoNormal>Quotation Date :
  <INPUT NAME="quot_refdt" TYPE="text" class="text_box_button" VALUE="<? echo($row3[3]); ?>" SIZE="15" readonly  >
   </p>
  <p align="left" class=MsoNormal>Kind Attn : <input style="border: 0px solid #000000;" type="text" name="attn" value="<? echo($row3[4]); ?>"></p>  </p>
  <p align="left" class=MsoNormal>Your Ref : <input type="text"  style="border: 0px solid #000000;"  onKeyPress="return event.keyCode!=13"   name="yr_refno"  value= "<? echo($row3[5]); ?>" > </p>
  
    
      <div align="left">
        <?
$ydt = date(d).'/'.date(m).'/'.date(Y); 
?>
      </div>
      <p align="left" class=MsoNormal>Date : <INPUT NAME="yr_refdt" TYPE="text" class="text_box_button" VALUE="<? echo($row3[6]); ?>"SIZE="15" readonly  ><A HREF="#" onClick="cal.select(document.myForm02.sdt,'anchor1','dd/MM/yyyy'); return false;"NAME="anchor1" ID="anchor1"><img  src="../../images/cal.gif" border="0"></A> <BR>
  </p>

  <p class=MsoNormal>&nbsp;</p>  </td>
 </tr>
 <tr>
  <td width=590 colspan=7 valign=top style='width:6.15in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>We thank you very much for your enquiry,</p>
  <p class=MsoNormal>We offer below our lowest rate, which will be most
  competive and acceptable to you</p>  </td>
 </tr>
 <tr>
  <td width=47 valign=top style='width:35.15pt;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>S.No</p>  </td>
  <td width=128 valign=top style='width:96.15pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>DRAWING NO</p>  </td>
  <td width=200 colspan=3 valign=top style='width:150.1pt;border-top:none;
  border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>DESCRIPTION</p>  </td>
  <td width=97 valign=top style='width:72.8pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>MATERIAL OFFERED</p>  </td>
  <td width=118 valign=top style='width:88.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal>PRICE / UNIT Rs.</p>  </td>
 </tr>
 <tr style='height:260.5pt'>
  <td width=47 valign=top style='width:35.15pt;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:260.5pt'>
  <p class=MsoNormal> <INPUT style="border: 0px solid #000000;" VALUE="1" size="5" readonly  >&nbsp;</p>  </td>
  <td width=128 valign=top style='width:96.15pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt;height:260.5pt'>
  <p class=MsoNormal><INPUT style="border: 0px solid #000000;" VALUE="<?=$row3[10]?>" name= "drawing_no" readonly> &nbsp;</p>  </td>
  <td width=200 colspan=3 valign=top style='width:150.1pt;border-top:none;
  border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt;height:260.5pt'>
  <p class=MsoNormal> <INPUT style="border: 0px solid #000000;" VALUE="<?=$row3[11]?>" name="prodname" readonly>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>Raw Material :<input style="border: 0px solid #000000;" type="text" name="rawwgt" value="<?=$row3[29]?>" size="5"> @<input style="border: 0px solid #000000;" type="text" name="rawrate" value="<?=$row3[13]?>"  size="1"></p>
  <p class=MsoNormal> </p>
  <p class=MsoNormal> <input type="text" style="border: 0px solid #000000;" name="invper" value="<? echo($row3[15]); ?>" size="1">%Inventory Carrying Cost:</p>
  <p class=MsoNormal>Process Cost :</p>
  <p class=MsoNormal>O.H. &amp; Margin :           </p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;(-)Scrap realization    </p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;&nbsp;Tool Cost :             </p>
    <p class=MsoNormal>&nbsp;</p></td>
  <td width=97 valign=top style='width:72.8pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt;height:260.5pt'>
  <p class=MsoNormal><input type="text"  style="border: 0px solid #000000;" name="rawoffer" value="<?=$row3[12]?>"  size="15"></p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal> </p>
  <p class=MsoNormal>
    <input type="text" name="invcost" style="border: 0px solid #000000;" value="<? echo($row3[16]); ?>" size="15"></p>
    <p class=MsoNormal>&nbsp;</p>
  <p align="right" class=MsoNormal><input type="text" style="border: 0px solid #000000;" name="processcost" value="<?=$row3[17]?>"  size="15"></p>
  <p align="right" class=MsoNormal><input type="text" style="border: 0px solid #000000;" name="admnexp" value="<?=$row3[18]?>"  size="15">
    <input type="text" name="rawcost" style="border: 0px solid #000000;" value="<?=$row3[14]?>"  size="15">
  </p>
  <div style='border-top:solid windowtext 1.0pt;border-left:none;border-right:none;padding:1.0pt 0in 1.0pt 0in'>
    <p align="right" class=MsoNormal style='border:none;padding:0in'><strong>
      <input type="text" style="border: 0px solid #000000;" name="subtot" value="<? echo($row3[27]); ?>" size="15">  
      </strong></p>
  </div>
  <p align="right" class=MsoNormal><input type="text" style="border: 0px solid #000000;" name="scrapcost" value="<? echo($row3[19]); ?>" size="15"></p>
   <div style='border-top:solid windowtext 1.0pt;border-left:none;border-right:none;padding:1.0pt 0in 1.0pt 0in'>
    <p align="right" class=MsoNormal style='border:none;padding:0in'><input type="text" style="border: 0px solid #000000;" name="tot" value="<? echo($row3[28]); ?>" size="15">  </p>
  </div>
  <p align="right" class=MsoNormal>&nbsp;&nbsp;<input type="text" style="border: 0px solid #000000;" name="tlcost" value="<? echo($row3[20]); ?>" size="15"></p>  </td>
  <td width=118 valign=top style='width:88.6pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt;height:260.5pt'>
  <p class=MsoNormal>  <input type="text"  style="border: 0px solid #000000;"  onKeyPress="return event.keyCode!=13"   name="price"  value= "<? echo($row3[26]); ?>" >&nbsp;</p>  </td>
 </tr>
 <tr style='height:17.5pt'>
  <td width=331 colspan=4 valign=top style='width:3.45in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal>Delivery Period :<input type="text" style="border: 0px solid #000000;" name="delperiod" value="<? echo($row3[21]); ?>" size="40"></p>  </td>
  <td width=259 colspan=3 rowspan=5 valign=top style='width:2.7in;border-top:
  none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal>Thanking You,</p>
  <p class=MsoNormal>Yours Faithfully,</p>
  <p class=MsoNormal><b>For Wilson Press Tools</b></p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>&nbsp;</p>
  <p class=MsoNormal>                        Authorised Signatory</p>  </td>
 </tr>
 <tr style='height:17.5pt'>
  <td width=331 colspan=4 valign=top style='width:3.45in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal>Sales Tax :<input type="text" style="border: 0px solid #000000;" name="st" value="<? echo($row3[22]); ?>" size="40"></p>  </td>
 </tr>
 <tr style='height:17.5pt'>
  <td width=331 colspan=4 valign=top style='width:3.45in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal>Excise Duty :<input type="text" style="border: 0px solid #000000;" name="exduty" value="<? echo($row3[23]); ?>" size="40"></p>  </td>
 </tr>
 <tr style='height:17.5pt'>
  <td width=331 colspan=4 valign=top style='width:3.45in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal>P &amp; F Charges :<input type="text" style="border: 0px solid #000000;" name="pandf" value="<? echo($row3[24]); ?>" size="40"></p>  </td>
 </tr>
 <tr style='height:17.5pt'>
  <td width=331 colspan=4 valign=top style='width:3.45in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal>Payment Terms :<input type="text" style="border: 0px solid #000000;" name="payterms" value="<? echo($row3[25]); ?>" size="40"></p>  </td>
 </tr>
 <tr style='height:17.5pt'>
  <td width=590 colspan=7 valign=top style='width:6.15in;border:solid windowtext 1.0pt;
  border-top:none;padding:0in 5.4pt 0in 5.4pt;height:17.5pt'>
  <p class=MsoNormal><i><span style='font-size:9.0pt'>SPECIALISTS IN TOOLINGS /
  SHEETMETAL BLANKINGS / FORMINGS AND PRESSED COMPONENTS</span></i></p>  </td>
 </tr>
 <tr height=0>
  <td width=47 style='border:none'></td>
  <td width=128 style='border:none'></td>
  <td width=120 style='border:none'></td>
  <td width=36 style='border:none'></td>
  <td width=44 style='border:none'></td>
  <td width=97 style='border:none'></td>
  <td width=118 style='border:none'></td>
 </tr>
</table>

<p class=MsoNormal>&nbsp;</p>

</div>
</form>
</html>


