| Server IP : 199.250.214.225 / Your IP : 3.149.228.172 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');
//require_once('business logic/classes/operations.php');
$user = new User();
$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['rk']) and isset($_SESSION['mth']) and isset($_SESSION['yr']) and isset($_SESSION['rpt'])
and isset($_SESSION['bank']) and isset($_SESSION['bankGroup']) and isset($_SESSION['bgroup']))
{
$rk = mysql_real_escape_string($_SESSION['rk']);//$_SESSION['schqc']..$_SESSION['mqc']...$_SESSION['yqc']
$mth = mysql_real_escape_string($_SESSION['mth']);
$yr = mysql_real_escape_string($_SESSION['yr']);
//$dv= mysql_real_escape_string($_SESSION['dv']);
$j_name= mysql_real_escape_string($_SESSION['judge_name']);
$c_state = mysql_real_escape_string($_SESSION['current_state']);
$rpt= mysql_real_escape_string($_SESSION['rpt']);
$bk= mysql_real_escape_string($_SESSION['bank']);
$bg= mysql_real_escape_string($_SESSION['bankGroup']);
$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>
<script type="text/javascript" src="js/number_to_word.js"></script>
<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-family: Verdana, Geneva, sans-serif;
font-size: 15px;
}
-->
</style>
</head>
<body onload="lookup()">
<p>
<?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.bankGroup='$bgroup') and (PER.current_state = '$c_state') ORDER by PER.grade desc";
}
else if($type == "PERSONAL ASSISTANT")
{
$sql = "SELECT PA.name as pa_name, PY.fileNo, PY.tax, PY.rent_water, 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, tblpersonalassistant as PA WHERE (PER.fileNo = PA.fileNo) and (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 = $j_name) 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 (PY.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.nhf, PY.j_contribution, 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.bankGroup ='$bgroup') ORDER by PER.grade desc" ;
}
$getData = mysql_query($sql) or die(mysql_error());
$num_record = mysql_num_rows($getData);//for the purpose of personal assistant
$data = mysql_fetch_assoc($getData);
if ($rpt =='1' )//
{
if($data['current_state'] == "ABUJA")
$address = 'FEDERAL INLAND REVENUE SERVICE, ABUJA';
else{
$address = $data['current_state']." STATE INLAND REVENUE, ".$data['current_state'];//default is here
//ENUGU STATE INTERNAL REVENUE,ENUGU
}
}
?>
</p>
<p><br />
</p>
<p> </p>
<p><br />
<br />
</p>
<div align="center">
<table width="1122" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><div align="center"><strong>
<span class="FED"> FEDERAL GOVERNMENT OF NIGERIA</span><br />
PAYMENT VOUCHER</strong></div></td>
</tr>
<tr>
<td width="877"><div align="left"><strong>Subhead</strong>: <?php echo $data['subhead']; ?><br />
<strong>Classification Code</strong>: <?php echo $data['classCode']; ?><br />
<strong>Payee</strong>: <?php
if ($type =='PERSONAL ASSISTANT')
{
echo $data['pa_name'];
}
else
{
if (isset($address))
{
echo $address ;
}
else
{
echo $data['address'];
}
}
?><br />
<!--<strong>Address</strong>.............................................--></div></td>
<td colspan="2" valign="top"><div align="left">
<strong>Treasury F1</strong><br />
Date Printed: <?php echo Date("l F d, Y");//date('d-m-Y');?><br />
</div></td>
</tr>
<tr>
<td colspan="2"><div align="left"><a href="userArea.php">Departmental No NICN/PE/..........................</a></div></td>
<td width="244"><strong>
<?php
echo $bk." ".$bg;
?>
</strong></td>
</tr>
<tr>
<td colspan="2"><strong><?php //if isset()
if ($rpt =='5')
echo $staffname;//$data['rank'];
?>
</strong>
</td>
<td> </td>
</tr>
<tr>
<td colspan="3"><div align="left"></div></td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3"><table width="943" border="1" align="center" cellpadding="10" cellspacing="0" class="tblborder">
<tr>
<td width="61"><div align="center"><strong>Date</strong></div></td>
<td width="517"><div align="center"><strong>Detailed Description of Service/Work</strong></div> <div align="center"></div> <div align="center"></div></td>
<td width="44"><div align="center"><strong>Rate </strong></div></td>
<td width="231"> <img src="images/naira.jpg" alt="" width="15" height="13" /> K</td>
</tr>
<?php
$sn = 1;
$total = 0;
?>
<tr>
<td align="center"><strong><?php echo $data['month'].' '. $data['year']; ?></strong></td>
<td align="left">Payment to the above named Organisation being <strong><?php echo $data['name']; ?> </strong>deduction made from the salary of <strong>
<?php //if isset()
echo $data['title']." ".$data['surname']." ".$data['first_name']." ".$data['othernames'];
?></strong><?php if(mysql_num_rows($getData) > 1)
echo " and others ";
?>
for the month of <?php echo $data['month'].' '. $data['year']; ?><br />
P\V No.............</td>
<td colspan="2" align="center"><div align="left"></div></td>
</tr>
</table>
</td>
</tr>
<?php
if($type == "PERSONAL ASSISTANT")
$pa_sum = $data[$val];
do {
//<?php
$sn;
$total = $total + $data[$val];
} while ($data = mysql_fetch_assoc($getData));
?>
</table>
<table width="1145" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="106"> </td>
<td width="281" align="right"></td>
<td width="340" align="center"> </td>
<td width="418" valign="bottom"><strong>Grand Total:</strong> <img src="images/naira.jpg" width="15" height="13" /><?php
if($type == "PERSONAL ASSISTANT")
$total = $pa_sum;
echo number_format($total, 2, '.', ',');?></td>
</tr>
<tr>
<td> </td>
<td colspan="3">.....................................................................................................................................................................................................</td>
</tr>
<tr>
<td> </td>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="2" valign="top"><div align="left">
<p><strong> PAYABLE:</strong> LAGOS<br />
Name:...................................................................<br />
Signature:..............................................................<br />
Date:.....................................................................<br />
Division:
..............................................................<br />
</p>
<p><br />
Paying Officer:.....................................................<br />
Signature: ............................................................<br />
Name in Block<br />
<br />
</p>
</div></td>
<td colspan="2"><div align="left">
<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>
<p><strong>CERTIFICATION</strong><br />
I certify the above amount is correct and was incurred under the Authority quoted that the service have been dully performed, that the rate/price charged is according to regulations and correct is fair and reasonable.<br />
<strong>Amount</strong>:<span id="result"></span>
</p>
<p>
<br />
Place: LAGOS<br />
<br />
Designation:
<strong>CR</strong> Signature:<br />
<br />
Date:...............................................<br />
<br />
Signature: ...................................................................<br />
</p>
</div></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();
?>