Exemplo n.º 1
0
{
    $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 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp
&nbsp &nbsp &nbsp &nbsp Divisional Forest Officer<br>
Forest Working Division, <?php 
echo strtoupper($_SESSION['fwd']);
Exemplo n.º 2
0
Arquivo: print.php Projeto: hpie/hpie 
$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 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp