{
$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']);
}
echo '<table border=1><tr><td>Sr.No.</td><td>LSM Name</td><td>Date of Allotment of Work(dd-mm-yyyy)</td><td>Date of Starting Work(dd-mm-yyyy)</td><td>Date of Ending Work(dd-mm-yyyy)</td><td>Extraction/Carriage Rate(per Qtls)</td><td>Tranportation Rate(per Qtls)</td></tr>';
$i = 1;
while ($row = mysql_fetch_array($rs)) {
$lsmname = $row['LSMName'];
$alotdate = getDDMMYY($row['alotdate']) == '00-00-0000' ? "No Alotement" : getDDMMYY($row['alotdate']);
if ($row['fromdate'] == '0000-00-00' and $row['todate'] == '0000-00-00') {
$fromdate = "Not Started to work";
$todate = "NA";
} else {
if ($row['fromdate'] == '0000-00-00' and $row['todate'] != '0000-00-00') {
$fromdate = "Never Worked";
$todate = getDDMMYY($row['todate']);
} else {
$fromdate = getDDMMYY($row['fromdate']);
$todate = $todate = getDDMMYY($row['todate']);
}
}
$ratecar = $row['ratecar'];
$ratetrans = $row['ratetrans'];
echo '<tr><td>' . $i . '</td><td>' . $lsmname . '</td><td>' . $alotdate . '</td><td>' . $fromdate . '</td><td>' . $todate . '</td><td>' . $ratecar . '</td><td>' . $ratetrans . '</td></tr>';
$i++;
}
echo '</table>';
?>
</div>
<br />
<tr><td> Enter the negotiated rate for extraction/carriage (per Qtls)*</td><td><input type="text" name="ratecar" /></td></tr>
<tr><td> Enter the negotiated rate for transportation (per Qtls)*</td><td><input type="text" name="ratetrans" /></td></tr>
<tr><td colspan=2><font color=red> Fields Marked with * can no be altered later....</font></td></tr>
</table>
<?php
} else {
?>
<table border =0>
<tr><td width="274">LSM Name</td>
<td width="221"><?php
echo $alotinfo['lsmname'];
?>
</td></tr>
<tr><td> Date of Allotment of the work</td><td><?php
echo getDDMMYY($alotinfo['alotdate']) . ' (dd-mm-yyyy)';
?>
</td></tr>
<tr><td> Date of starting the work</td><td><select name="fromday"><option value=0>Day</option><?php
$day = range(1, 31);
foreach ($day as $d) {
echo '<option value=' . $d . '>' . $d . '</option>';
}
echo '</select>';
?>
<select name="frommon" ><option value=0>Month</option><?php
$months = array(1 => 'Jan', 'Feb', 'March', 'April', 'May', 'June', 'July', 'Aug', 'Sept', 'Oct', 'Nov', 'Dec');
foreach ($months as $k => $m) {
echo '<option value=' . $k . '>' . $m . '</option>';
$ratetrans = $row['ratetrans'];
?>
<form method="post" enctype="multipart/form-data" name="form1" onsubmit="return check();" action="show_lsmdetailsD.php">
<font size="4"><?php
echo "Enter the date of ending work for Lot Number " . $lot . "/" . $year . "(" . getExten($lot, $divi) . ")";
?>
</font>
<table border =0>
<tr><td width="274">Current LSM Name</td>
<td width="221"><?php
echo $lsmname;
?>
</td></tr>
<tr><td width="274">Date of starting work</td>
<td width="221"><?php
echo getDDMMYY($fromdate) . "(dd-mm-yyyy)";
?>
</td></tr>
<tr><td> Negotiated rate for extraction/carriage (per Qtls)</td><td><?php
echo $ratecar;
?>
</td></tr>
<tr><td> Enter the negotiated rate for transportation (per Qtls)</td><td><?php
echo $ratetrans;
?>
</td></tr>
<tr><td colspan="2">Enter the ending date of work and click next to deallocate the LSM</td></tr>
<tr><td> Date of ending the work</td><td><select name="fromday"><option value=0>Day</option><?php
$day = range(1, 31);
<div style="float: right"><font size=2><?php
date_default_timezone_set('Asia/Calcutta');
print date("jS F Y, g:i A");
?>
</font></div>
</h1>
<br>
<form method="post" enctype="multipart/form-data" name="form1"
onsubmit="return check();" action="save_lsm.php">
<font size="4"><?php
echo "Showing LSM details for Lot Number " . $lot . "/" . $year . "(" . getExten($lot, $divi) . ") for review before save </font>";
echo ' <table border =0>
<tr><td> LSM Name</td><td>' . $_POST['lsmname'] . '</td></tr>
<tr><td> Date of Allotment the work</td><td>' . getDDMMYY($_SESSION['alotdate']) . ' (dd-mm-yyyy)</td></tr>
<tr><td> Date of starting the work</td><td>' . getDDMMYY($_SESSION['fromdate']) . ' (dd-mm-yyyy)</td></tr>
<tr><td> Negotiated rate for Extraction/carriage (per Qtls)</td><td>' . $_POST['ratecar'] . '</td></tr>
<tr><td>Negotiated rate for transportation (per Qtls)</td><td>' . $_POST['ratetrans'] . '</td></tr>
</table>';
echo ' <br><input id="inputsubmit1" type="submit" style="background-color:#b6e38e; width: 60px;" name="inputsubmit1" value="Save" />
<br> ';
?>
</p>
</form>
</div>
<br />
<div style="float: right"><font size=2><?php
date_default_timezone_set('Asia/Calcutta');
print date("jS F Y, g:i A");
?>
</font></div>
</h1>
<br>
<form method="post" enctype="multipart/form-data" name="form1"
onsubmit="return check();" action="delete_lsm.php">
<font size="4"><?php
echo "Showing LSM details for Lot Number " . $lot . "/" . $year . "(" . getExten($lot, $divi) . ") for review before save </font>";
echo ' <table border =0>
<tr><td> LSM Name</td><td>' . $_POST['lsmname'] . '</td></tr>
<tr><td> Date of starting the work</td><td>' . getDDMMYY($_SESSION['fromdate']) . ' (dd-mm-yyyy)</td></tr>
<tr><td> Date of ending the work</td><td>' . getDDMMYY($_SESSION['todate']) . ' (dd-mm-yyyy)</td></tr>
<tr><td> Negotiated rate for Extraction/carriage (per Qtls)</td><td>' . $_POST['ratecar'] . '</td></tr>
<tr><td>Negotiated rate for transportation (per Qtls)</td><td>' . $_POST['ratetrans'] . '</td></tr>
</table>';
echo ' <br><input id="inputsubmit1" type="submit" style="background-color:#b6e38e; width: 60px;" name="inputsubmit1" value="Save" />
<br> ';
?>
</p>
</form>
</div>
<br />
