<?php 
include("../../include/dbconnect.php");
?>
<title> Labour Invoices details edit</title>
<body bgcolor="#ffffff"  topmargin=0>
<center>
<table cellpadding=0 cellspacing=4 width=590>
<tr>
<td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font ><b>Labour Invoices  details edit</b></font></td>
</tr><tr valign="top"><td colspan=2>
<font >&nbsp;</font>
</td>
</tr>
</table>
<table border=0 cellpadding=3 cellspacing=4 width="590">
<form name="form1" method="POST"  action="inv_update.php?record=<?echo($record);?>">
<?php 

$result =mysql_query("select record,invno,invdate,compcode,prodcode,drawing_no,quantity,rate,value,packing_percent,packing_amt,bed,bed_amt,cess,cess_amt,vat_percent,vat_amount,freight,total,round_off,gtotal,invstatus,po_no,po_date,schedule_no,schedule_date,month,year,labourinv.remarks,reference,prepare_time,remove_time,account_year from labourinv where record ='$record' ") or die(mysql_error());
$row1=mysql_fetch_row($result);
?>

<table border="0" cellspacing="1" cellpadding="4" align="center" width="500" bgcolor="#999999">
        

<input type="hidden" name="record" value="<? echo($row1[0]); ?>">

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Printing Status</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="invstatus" value = <?php echo("'$row1[21]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Labour Inv No </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="invno" value = <?php echo("'$row1[1]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Invoice Date </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="invdate" value = <?php echo("'$row1[2]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Compcode </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="compcode" value = <?php echo("'$row1[3]'");?>>  </td></tr>

<tr><td bgcolor="#FFFFFF"><font class="sbd"><b>Product Code </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=14 size="14" readonly name="prodcode" value = <?php echo("'$row1[4]'");?>></td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Drawing No</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="drawing_no" value = <?php echo("'$row1[5]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Quantity </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=8 size="10" name="quantity" value = <?php echo($row1[6]);?>></td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Rate  </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=8 size="10" name="rate" value = <?php echo($row1[7]);?>></td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Value </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="value" value = <?php echo("'$row1[8]'");?>>  </td></tr>


<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Round_off</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="round_off" value = <?php echo("'$row1[19]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Grand Total</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="gtotal" value = <?php echo("'$row1[20]'");?>>  </td></tr>


<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Order No</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="po_no" value = <?php echo("'$row1[22]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Order  Date</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="po_date" value = <?php echo("'$row1[23]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Challan No</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="schedule_no" value = <?php echo("'$row1[24]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Challan Date</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="schedule_date" value = <?php echo("'$row1[25]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Month</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="month" value = <?php echo("'$row1[26]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Year</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="year" value = <?php echo("'$row1[27]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Schedule No</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="remarks" value = <?php echo("'$row1[28]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Reference</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="reference" value = <?php echo("'$row1[29]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Account Year</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="account_year" value = <?php echo("'$row1[32]'");?>>  </td></tr>
<tr>
<td align=right>
 <blockquote>  <input  type =submit name=submit value = "Update"></td> <td><input type =submit name=submit value = "Delete"></blockquote>
</table>

<br><br><font size=1><center><a href= "index.html">Return to index page</center></font>
                                                                             
</body>
</form>
