<?php 
include("../../include/dbconnect.php");
?>
<title> Schedules 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 >Schedules edit</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="update.php?record=<?echo($record);?>">
<?php 

$result=mysql_query("select record,order_no,order_date,schedule_no,schedule_date,order_qty,schedule_qty,issued_qty,balance_qty,due_date,part_qty1,due_date1,part_qty2,due_date2,part_qty3,due_date3,part_qty4,due_date4,part_qty5,due_date5,rate,tentative_qty,open_order,plan_month,plan_year,plan_type,inv_nos,inv_date,delivery_dates,app_qty,app_status,rejected_qty,min_no,return_date,remarks FROM orders where record ='$record' ") or die(mysql_error());
 $row1=mysql_fetch_row($result);
?>

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

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

<tr><td width="210"  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Order No </font></td><td width="300"  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="order_no" value = <?php echo("'$row1[1]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Order Date </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="order_date" value = <?php echo("'$row1[2]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Challan No </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="schedule_no" value = <?php echo("'$row1[3]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Challan Date </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="schedule_date" value = <?php echo("'$row1[4]'");?>>  </td></tr>



<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Ordered Qty</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="order_qty" value = <?php echo("'$row1[5]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Schedule Qty</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="schedule_qty" value = <?php echo("'$row1[6]'");?>>  </td></tr>


<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Issued Qty</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="issued_qty" value = <?php echo("'$row1[7]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Balance Qty</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="balance_qty" value = <?php echo("'$row1[8]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Due Date </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="due_date" value = <?php echo("'$row1[9]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Part Qty 1</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="part_qty1" value = <?php echo("'$row1[10]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Due Date for Part Qty 1 </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="due_date1" value = <?php echo("'$row1[11]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF"  color="#0033FF">Part Qty 2</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="part_qty2" value = <?php echo("'$row1[12]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Due Date for Part Qty 2 </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="due_date2" value = <?php echo("'$row1[13]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Part Qty 3</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="part_qty3" value = <?php echo("'$row1[14]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Due Date for Part Qty 3 </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="due_date3" value = <?php echo("'$row1[15]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Part Qty 4</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="part_qty4" value = <?php echo("'$row1[16]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Due Date for Part Qty 4 </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="due_date4" value = <?php echo("'$row1[17]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Part Qty 5</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="part_qty5" value = <?php echo("'$row1[18]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Due Date for Part Qty 5 </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="due_date5" value = <?php echo("'$row1[19]'");?>>  </td></tr>

<tr><td bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Rate </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=10 size="10" name="rate" value = <?php echo("'$row1[20]'");?>></td></tr>


<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Type of Order  </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=10 size="10" name="plan_type" value = <?php echo($row1[25]);?>></td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Invoice Nos</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="inv_nos" value = <?php echo("'$row1[26]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Invoice Date </font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="inv_date" value = <?php echo("'$row1[27]'");?>>  </td></tr>



<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Approved Qty</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="app_qty" value = <?php echo("'$row1[29]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Approval Status</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="app_status" value = <?php echo("'$row1[30]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Rejected Qty</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="rejected_qty" value = <?php echo("'$row1[31]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Min No</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="min_no" value = <?php echo("'$row1[32]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Returned Date</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='20' name="return_date" value = <?php echo("'$row1[33]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd" face="Arial, Helvetica, sans-serif"  color="#0033FF">Remarks</font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size='50' name="remarks" value = <?php echo("'$row1[34]'");?>>  </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>
