{
$rs = mysql_query("select alotdate from current_lsm where year='{$kapa}' and division='{$divi}' and lotno='{$lotno}' and todate='0000-00-00'");
$row = mysql_fetch_array($rs);
return $row['alotdate'];
}
echo "<table width=900px border=1><tr><td>S.No.</td><td>Lot No.</td><td>Range</td><td>Unit</td><td>Forests</td><td>Name of LSM</td><td>Date of Allotment(dd-mm-yy)</td><td>Working from date(dd-mm-yyyy)</td><td>Forest Division</td></tr>";
$i = 1;
while ($row = mysql_fetch_array($datan)) {
$lotno = $row['lotno'];
$currlot = addslashes($lotno);
$frange = $row['frange'];
$divi = $row['division'];
$lsmname = getLSMname($currlot, $divi, $kapa);
$fromdate = getlsmDateStart($currlot, $divi, $kapa) == '0000-00-00' ? "NOT STARTED YET" : getDDMMYY(getlsmDateStart($currlot, $divi, $kapa));
$alotdate = getlsmDateAlot($currlot, $divi, $kapa);
echo "<tr><td>" . $i . "</td><td>" . $lotno . "/" . $kapa . "(" . getExten($currlot, $divi) . ")</td><td>" . $frange . "</td><td>" . getUnit($currlot, $divi) . "</td><td>" . getForests($currlot, $divi, $kapa) . "</td><td>" . $lsmname . "</td><td>" . getDDMMYY($alotdate) . "</td><td>" . $fromdate . "</td><td>" . $divi . "</td></tr>";
$i++;
}
echo "</table>";
?>
<br>
<br>
<br>
<br>
<h3>Divisional Manager                
                       
                       
                       
        Divisional Forest Officer<br>
Forest Working Division, <?php
echo strtoupper($_SESSION['fwd']);
$datan = mysql_query("SELECT DISTINCT lotno, division, frange,rsd FROM verify where division='{$divi}' and year='{$kapa}' order by lotno") or die("No table");
$i = 1;
$ttl = 0;
$ttl1 = 0;
$ttl2 = 0;
echo "<table width=900px border=1><tr><td>S.No.</td><td>Lot No.</td><td>Unit</td><td>Range</td><td>Forests</td><td>Name of RSD</td><td>Forest Division</td><td>Actual No. of Blazes</td><td>No. of Blazes Declared Fit after Verification</td><td>No. of Blazes Declared Unfit</td></tr>";
while ($row = mysql_fetch_array($datan)) {
$lotno = $row['lotno'];
$currlot = addslashes($lotno);
$divi = $row['division'];
$frange = $row['frange'];
$rsd = $row['rsd'];
$totBlaze = getTotBlazes($currlot, $divi, $kapa);
$fitBlaze = getFitBlazes($currlot, $divi, $kapa);
$unfitBlaze = $totBlaze - $fitBlaze;
echo "<tr><td>" . $i . "</td><td>" . $lotno . "/" . $kapa . "(" . getExten($currlot, $divi) . ")</td><td>" . getUnit($currlot, $divi) . "</td><td>" . $frange . "</td><td>" . getForests($currlot, $divi, $kapa) . "</td><td>" . $rsd . "</td><td>" . $divi . "</td><td>" . $totBlaze . "</td><td>" . $fitBlaze . "</td><td>" . $unfitBlaze . "</td></tr>";
$ttl += $totBlaze;
$ttl1 += $fitBlaze;
$ttl2 += $unfitBlaze;
$i++;
}
echo "<tr><td colspan=7><b><font color=red>Total</td><td><b><font color=red>" . $ttl . "</td><td><b><font color=red>" . $ttl1 . "</td><td><b><font color=red>" . $ttl2 . "</td></tr>";
echo "</table>";
?>
<br>
<br>
<br>
<br>
<h3>Divisional Manager                
                       
                       
