| "; $mysql = "select distinct dt.fdepttype,ftypedesc from masdept_type dt inner join masdept dp on dt.fdepttype = dp.fdepttype " . $user_dept . " order by ftypeordr"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) > 1) { echo ""; } while ($myrow = mysqli_fetch_assoc($myres)) { echo ""; } echo ""; ?> |
Department Details
";
$mysql = "select * from masdept_type order by ftypeordr";
$myres = mysqli_query($mycon, $mysql);
if (mysqli_num_rows($myres) > 1) {
echo "";
}
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
";
$mysql = "select * from masempl where femplstat='T' and fusertype in (select fusertype from sys_user_type where fuserordr<2) order by femplname";
$myres = mysqli_query($mycon, $mysql);
if (mysqli_num_rows($myres) > 1) {
echo "";
}
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
Attendance Details
";
$mysql = "select * from mastime order by ftimecode";
$myres = mysqli_query($mycon, $mysql);
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
";
$mysql = "select * from mastime order by ftimecode";
$myres = mysqli_query($mycon, $mysql);
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
";
$mysql = "select * from mastime order by ftimecode";
$myres = mysqli_query($mycon, $mysql);
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
";
$mysql = "select * from mastime order by ftimecode";
$myres = mysqli_query($mycon, $mysql);
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
Salary Details
";
$mysql = "select * from masbank order by fbankname";
$myres = mysqli_query($mycon, $mysql);
if (mysqli_num_rows($myres) > 1) {
echo "";
}
while ($myrow = mysqli_fetch_assoc($myres)) {
echo "";
}
echo "";
?>
Expenses Details
Location Details