| Server IP : 199.250.214.225 / Your IP : 18.220.139.204 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/consolidated/ |
Upload File : |
<?php
require_once('business logic/classes/users.php');
$user = new User();
//$oper =new Operations();
$uid = $_SESSION['uid'];
$access = $_SESSION['acc'];
//
if (!$user->get_session())
{
header("location:myown_mainpage.php?you are not login");
}
//
if (isset($_GET['q']) and $_GET['q'] == 'logout')
{
$user->user_logout();
header("location:myown_mainpage.php? you are log out");
}
if (isset($_SESSION['rpt']) and isset($_SESSION['rk']) and isset($_SESSION['mth']) and isset($_SESSION['yr']) and
isset($_SESSION['bank']) and isset($_SESSION['bgroup']) )
{
$rk = mysql_real_escape_string($_SESSION['rk']);//$_SESSION['schqc']..$_SESSION['mqc']...$_SESSION['yqc']
$mth = mysql_real_escape_string($_SESSION['mth']);
$judge_no = mysql_real_escape_string($_SESSION['judge_no']);
$yr = mysql_real_escape_string($_SESSION['yr']);
$rpt= mysql_real_escape_string($_SESSION['rpt']);
$bk= mysql_real_escape_string($_SESSION['bank']);
$division= mysql_real_escape_string($_SESSION['division']);
$c_state= mysql_real_escape_string($_SESSION['current_state']);
$bgroup= mysql_real_escape_string($_SESSION['bgroup']);
}
//
//$result = mysql_query("select * from tblper order by surname, othernames");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="images/favicon.ico">
<title>National Industrial Court of Nigeria...::...Report</title>
<style type="text/css">
<!--
.style25 { font-family: Verdana, Arial, Helvetica, sans-serif;
color: #FF0000;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
body {
background-image: url(images/nicn_bg.jpg);
}
.tblborder {
border-top-width: 1px;
border-right-width: 1px;
border-bottom-width: 1px;
border-left-width: 1px;
border-top-style: dotted;
border-right-style: dotted;
border-bottom-style: dotted;
border-left-style: dotted;
}
.FED { color: #008000;
}
body,td,th {
font-size: 15px;
font-family: Verdana, Geneva, sans-serif;
}
-->
</style>
<script type="text/javascript" src="js/number_to_word.js">
</script>
</head>
<body onload="lookup();">
<?php
$rpt = intval($rpt);
switch($rpt)
{
case 1:
{
$type ='PAYE';
$val ='tax';
break;
}
case 2:
{
$type ='RENT AND WATER';
$val ='rent_water';
break;
}
case 3:
{
$type ='NATIONAL HOUSING FUND';
$val ='nhf';
break;
}
case 4:
{
$type ='LOAN';
$val ='loan';
break;
}
case 5:
{
$type ='PERSONAL ASSISTANT';
$val ='personal_assistant_deduct';
break;
}
case 6:
{
$type ='MOTOR ADV';
$val ='motorAdv';
break;
}
case 7:
{
$type ='PENSION';
$val ='pension';
break;
}
case 8:
{
$type ='NICN COOP';
$val ='nicncoop';
break;
}
default:
{
$type ='JUDGES CONTRIBUTION';
$val ='j_contribution';
break;
}
}
if($type == "PAYE")
{
$sql = "SELECT PY.fileNo, PY.tax, PY.rent_water, PER.current_state, PY.pension, PY.nhf, PY.loan,PY.personal_assistant_deduct,
PY.pension, PY.motorAdv, PY.month, PY.year, PY.rank, PER.division, PER.fileNo, PER.rank, ADR.name, ADR.address, ADR.determinant, ADM.name, ADM.subhead, ADM.classCode, PER.title, PER.surname, PER.first_name, PER.othernames, PER.bank FROM tblper AS PER,tbl_conpayment AS PY, tbladdress AS ADR, admincode AS ADM WHERE (PY.fileNo = PER.fileNo) and (ADR.name = ADM.name and ADM.name = '$type') and (month = '$mth') and (year = '$yr') and (PY.$val!=0) and (PY.rank ='$rk') and (PER.bank ='$bk') and (PER.current_state = '$c_state') ORDER by PER.grade desc";
}
if($type == "PERSONAL ASSISTANT")
{
$sql = "SELECT PY.fileNo, PY.tax, PY.rent_water, PY.pension, PY.nhf, PY.loan, PY.personal_assistant_deduct, PY.nicncoop, PY.j_contribution,
PY.pension, PY.motorAdv, PY.month, PY.year, PY.rank, PER.division, PER.fileNo, PER.rank, ADR.name, ADR.address, ADR.determinant, ADM.name, ADM.subhead, ADM.classCode, PER.title, PER.surname, PER.first_name, PER.othernames, PER.bank FROM tblper AS PER, tbl_conpayment AS PY, tbladdress AS ADR, admincode AS ADM WHERE (PY.fileNo = PER.fileNo) and (ADR.name = ADM.name and ADM.name = '$type') and (month = '$mth') and (year = '$yr') and (PY.$val!=0) and (PER.fileNo = $judge_no) ORDER by PER.grade desc";
}
else if($type == "JUDGES CONTRIBUTION")
{
$sql = "SELECT PY.fileNo, PY.tax, PY.rent_water, PY.pension, PY.nhf, PY.loan, PY.personal_assistant_deduct, PY.nicncoop,
PY.j_contribution, PY.pension, PY.motorAdv, PY.month, PY.year, PY.rank, PER.division, PER.fileNo, PER.rank, ADR.name, ADR.address,
ADR.determinant, ADM.name, ADM.subhead, ADM.classCode, PER.title, PER.surname, PER.first_name, PER.othernames, PER.bank FROM tblper
AS PER, tbl_conpayment AS PY, tbladdress AS ADR, admincode AS ADM WHERE (PY.fileNo = PER.fileNo) and (ADR.name = ADM.name and
ADM.name ='$type') and (month = '$mth') and (year = '$yr') and (PY.$val!=0) and (PER.rank ='$rk') and (PER.bank ='$bk')
ORDER by PER.grade desc";
}
else
{
$sql = "SELECT PY.fileNo, PY.tax, PY.rent_water, PY.pension, PY.nhf, PY.loan, PY.personal_assistant_deduct, PY.nicncoop, PY.j_contribution,
PY.pension, PY.motorAdv, PY.month, PY.year, PY.rank, PER.division, PER.fileNo, PER.rank, ADR.name, ADR.address, ADR.determinant, ADM.name, ADM.subhead, ADM.classCode, PER.title, PER.surname, PER.first_name, PER.othernames, PER.bank FROM tblper AS PER, tbl_conpayment AS PY, tbladdress AS ADR, admincode AS ADM WHERE (PY.fileNo = PER.fileNo) and (ADR.name = ADM.name and ADM.name = '$type') and (month = '$mth') and (year = '$yr') and (PY.$val!=0) and (PER.rank ='$rk') and (PER.bank ='$bk') and (PER.bankGroup ='$bgroup') ORDER by PER.grade desc";
}
$getData = mysql_query($sql)
or die (mysql_error());
$num_record = mysql_num_rows($getData); //for personal assistant purpose
$data = mysql_fetch_assoc($getData);
if ($rpt =='1' )//
{
if ($dv == "Abuja" )//determinant
{
$address = 'FEDERAL INLAND REVENUE SERVICE,ABUJA';
//break;
}
else if ($dv == "Lagos")
$address = 'LAGOS STATE INTERNAL REVENUE,LAGOS';
else if ($dv == "Kano")//
$address = 'KANO STATE INTERNAL REVENUE,KANO';
else if ($dv == "Calabar")//
$address = 'CROSS RIVER STATE INTERNAL REVENUE,CALABAR';
else
$address = 'JOS Address';//default is here
//ENUGU STATE INTERNAL REVENUE,ENUGU
}
if ($rpt =='5')
{
if ($rk == "S")
{
$address = 'THE GEN. SEC. A.S.C.O.N 2/4 ARAOTI STR., OFF MONTGOMERY';
$staffname = 'Senior Staff';
}
else if ( $rk =="J" )
{
$address= 'THE GEN. SEC N.C.S.U 24 JEBBA STR., EBUTE-METTA WEST';
$staffname = 'Junior Staff';
}
else if ($rk == "D" )//
{
$address = 'THE GEN. SEC. A.U.P.C.T.R.E. 9,AJE STR,SABO, YABA,LAGOS';
$staffname = 'Driver ';
}
else //
{
$address = 'THE GEN. SEC N.C.S.U.T & A STAFF 283. HERBERT MACUULAY WAYS';
$staffname = 'Typist';
}
//else
//$data['address'] = 'ENUGU STATE INTERNAL REVENUE,ENUGU';//default is here
}
?>
<div align="center">
<table width="1122" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><div align="center">
<h2 class="FED">FEDERAL GOVERNMENT OF NIGERIA</h2>
ADVICE OF DEDUCTION FROM SALARY
</div></td>
</tr>
<tr>
<td width="808"><div align="left"><strong>Subhead</strong>: <?php echo $data['subhead']; ?><br />
<strong>Classification Code</strong>: <?php echo $data['classCode']; ?><br />
</div></td>
<td width="320" colspan="2" valign="top"><div align="left">
<strong>TF. 209(1962 R)</strong><br />
Date Printed: <?php echo Date("l F d, Y");//date('d-m-Y');?><br />
<strong>
<?php
echo $data['bank']." ".$bankGroup;
?>
</strong> <br />
</div></td>
</tr>
<tr>
<td colspan="3"><div align="right"><a href="userArea.php">Home</a></div></td>
</tr>
<tr>
<td colspan="3"><div align="center"><strong><?php
if($type == "PERSONAL ASSISTANT")
echo $data['surname']."'s Personal Assistant";
else
echo $data['name']; ?></strong></div></td>
</tr>
<tr>
<td colspan="3"><strong><?php echo $dv;?> Division</strong></td>
</tr>
<tr>
<td colspan="3"><table width="858" border="1" align="center" cellpadding="6" cellspacing="0" class="tblborder">
<tr>
<td width="33"><div align="center"><strong>S/N</strong></div></td>
<td width="415"><div align="left"><strong>FULL NAME</strong></div>
<div align="center"></div> <div align="center"></div></td>
<td width="342"><div align="center"><strong>AMOUNT</strong>(<img src="images/naira.jpg" width="15" height="13" />)</div></td>
</tr>
<?php
$sn = 1;
$total =0;
//while($rows = mysql_fetch_array($result))
//{
do {
?>
<tr>
<td align="center"> <?php echo $sn; ?></td>
<td align="left"> <?php
if ($type == 'PERSONAL ASSISTANT')
echo $data['name'];
else
echo $data['surname'].', '.$data['first_name']." ".$data['othernames'];
?></td>
<td align="center"><?php
if($type == 'PERSONAL ASSISTANT')
{
$data[$val] = $data['personal_assistant_deduct']/$num_record;
echo number_format($data[$val], 2, '.', ',');
}
else
echo number_format($data[$val], 2, '.', ',');//$rows['totalEmolu']; ?></td>
</tr>
<?php
++$sn;
$total = $total + $data[$val];
} while ($data = mysql_fetch_assoc($getData));
?>
</table>
<table width="1128" border="0" cellpadding="6" cellspacing="0">
<tr>
<td width="159"> </td>
<td width="417" align="right"></td>
<td colspan="2" align="center"><div align="left"><strong>Grand Total:</strong> <img src="images/naira.jpg" alt="" width="15" height="13" /><?php echo number_format($total, 2, '.', ',');?></div></td>
</tr>
<tr>
<td> </td>
<td colspan="3">.....................................................................................................................................................................................................<br />
<br /></td>
</tr>
<tr>
<td colspan="4" valign="top"><div align="left"><strong>AMOUNT IN WORDS:</strong>
<script type="text/javascript">
var amount = "";
var amount = "<?php echo number_format($total, 2, '.', '') ; ?>";
var money = amount.split('.');
function lookup()
{
var words;
var naira = money[0];
var kobo = money[1];
var word1 = toWords(naira)+" naira";
var word2 = ", "+toWords(kobo)+" kobo";
if(kobo != "00")
words = word1+word2;
else
words = word1;
document.getElementById('result').innerHTML = words.toUpperCase();
}
</script>
<span id="result"></span>
<br />
</div></td
></tr>
<tr>
<td colspan="4" valign="top">Signature of Paying in Officer:...................................................................................................Signature of Receiving Officer:.....................................................................................</td>
</tr>
<tr>
<td colspan="4" valign="top">Name:......................................................................................................................................Name................................................................................................................................</td>
</tr>
<tr>
<td colspan="3" valign="top">(BLOCK LETTERS)</td>
<td width="547" valign="top">(BLOCK LETTERS)</td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td colspan="2"><form>
<div align="center">
<input type="button" value="Print" onClick="window.print()" >
</div>
</form> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
<?php
$user->close();
?>