47 lines
1.3 KiB
PHP
47 lines
1.3 KiB
PHP
<?php
|
|
include('top.php');
|
|
?>
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
|
<tr>
|
|
<td height="350" valign="top" style="padding:10px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
|
|
<tr>
|
|
<td><fieldset class="bdr1" >
|
|
<legend class="heading1">Information Notes
|
|
</legend>
|
|
<center>
|
|
<?php
|
|
if(isset($hid) && $hid=='1')
|
|
{
|
|
$hid=0;
|
|
$sq="SELECT purchase_order_no, delivery_date, item_desc_new, delivery_destination, qty, remarks
|
|
FROM purchase_order_delivery_schedule
|
|
ORDER BY purchase_order_no ASC, delivery_date ASC";
|
|
$re=mysqli_query($conn,$sq);
|
|
$i=1;
|
|
while ($ro=@mysqli_fetch_array($re))
|
|
{
|
|
@extract($ro);
|
|
$sql="UPDATE purchase_order_delivery_schedule SET ds_id='".$i."' WHERE purchase_order_no='".$purchase_order_no."' AND delivery_date='".$delivery_date."' AND item_desc_new='".addslashes($item_desc_new)."' AND delivery_destination='".addslashes($delivery_destination)."' AND qty='".$qty."' AND remarks='".addslashes($remarks)."'";
|
|
$res=@mysqli_query($conn,$sql);
|
|
$i++;
|
|
//if($i==5)
|
|
//{
|
|
//break;
|
|
// }
|
|
|
|
}
|
|
echo "DONE";
|
|
}
|
|
?>
|
|
<form name="f1" method="post" action="<?php echo $this_script?>">
|
|
<input type="hidden" name="hid" value="1" />
|
|
<input type="submit" value="GO" />
|
|
</form>
|
|
</center>
|
|
</fieldset>
|
|
</td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<?php include('footer.php'); ?>
|