<?
session_start();

 $brcode=$_SESSION['brcode'];
$user=$_SESSION['user'];
$level=$_SESSION['level'];

include_once("test.php");
include_once('opendb.php');
?>

<style>
 td{font-family:arial;font-size:14;color:black;background-color:ivory}
 th{font-family:arial;font-size:14;color:black;background-color:ivory}
 body{background-color:ivory}
 input
  {border-style:ridge;
   border-color:#22437f;
   background-color:white;
   height:25px;
   border-size=1;
   font-family:sans-serif;
   color:BLACK;
  }
</style>

<center>
<p>&nbsp;<p>&nbsp;<p>&nbsp;
<FONT FACE='ARIAL BLACK'>
SELECT DATE FOR Accounts Payables Ageing
</FONT>
<form action='debtagingcryear.php' method='post'>
<table border=1 width=500>
<tr><td>As ON</td><td>
<input type=text name=d1 value='<?print date("d",time());?>' size=1>
<input type=text name=m1 value='<?print date("m",time());?>' size=1>
<input type=text name=y1 value='<?print date("Y",time());?>' size=3>
</td></tr>
<tr><td>Period </td><td>
Days <input type=text name='p1' size=2 value='365'>
Days <input type=text name='p2' size=2 value='730'>
Days <input type=text name='p3' size=4 value='1095'>
Days <input type=text name='p4' size=4 value='1095'>

</td></tr>

<tr>
<td>Ledger Group</td>
<td><select name='jtype'>
<option value='Sundry Creditors'>Sundry Creditors</option>
<?
$qry=mysqli_query($db,"select distinct grp from  ledger order by grp ASC");
while($row=mysqli_fetch_array($qry))
{
?>
       <option value='<? echo $row['grp'] ?>'><? echo $row['grp'] ?></option>
<?
}
?>
</select>
</td></tr>

<tr><td colspan=2 align=center><input type=submit value="Show"></td></tr>
</table>
</form>
