| Server IP : 199.250.214.225 / Your IP : 3.147.6.205 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 login/classes/.php');
require_once('business logic/classes/users.php');
require_once('business logic/classes/operations.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");
}
$topetotal = 0;
if (isset($_SESSION['schqc']) and isset($_SESSION['mqc']) and isset($_SESSION['yqc']) and isset($_SESSION['cadre']))
{
$bkname = mysql_real_escape_string($_SESSION['schqc']);//$_SESSION['schqc']..$_SESSION['mqc']...$_SESSION['yqc']
$mth = mysql_real_escape_string($_SESSION['mqc']);
$yr = mysql_real_escape_string($_SESSION['yqc']);
$cadre = mysql_real_escape_string($_SESSION['cadre']);
$bgroup = mysql_real_escape_string($_SESSION['bgroup']);
//$division= mysql_real_escape_string($_SESSION['division']);
}
?>
<!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...::...Bank Schedule</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;
}
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
$page_name="con_schedule.php"; // If you use this code with a different page ( or file ) name then change this
////// starting of drop down to select number of records per page /////
/*$totalAmt = mysql_query("SELECT PY.totalEmolu
FROM tblper AS PER,tblpayment AS PY,tblbank AS BK
WHERE (PER.bank = BK.name and PER.bank = '$bkname') and (PY.month = '$mth' and PY.year= '$yr') and (PER.division = '$division') and (PER.bankGroup = '$bankGroup') and (PER.fileNo = PY.fileNo)")
or die ('Amount Conversion Error: '.mysql_error()) ;
$rowAmt = mysql_fetch_assoc($totalAmt);
$total = 0;
do {
$total +=$rowAmt['totalEmolu'];
}*/
//while ($rowAmt = mysql_fetch_assoc($totalAmt));
//{
//}
//
@$limit=$_GET['limit']; // Read the limit value from query string.
$start=$_GET['start'];
if(strlen($start) > 0 and !is_numeric($start)){
echo "Data Error";
exit;
}
$eu = ($start - 0);
$limit = 50; // No of records to be shown per page.
$this1 = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
//
$query2="SELECT PER.fileNo,PY.fileNo,PER.bank,BK.bank,PY.month,PY.year, PER.division
FROM tblper AS PER,tbl_conpayment AS PY,tbl_conbank AS BK
WHERE (PER.bank = BK.bank and PER.bank = '$bkname') and (PY.month = '$mth' and PY.year= '$yr') and (PER.fileNo = PY.fileNo) and
(PY.rank = '$cadre') ";
$result2=mysql_query($query2)or die ( 'here 1 '.mysql_error());
$nume=mysql_num_rows($result2);
//
$query="SELECT PER.fileNo,PY.fileNo,PER.bank,BK.bank,PY.month,PY.year,PER.surname,PER.first_name, PER.othernames,PER.accNo,PER.bank_branch,
BK.sort_code,PY.totalEmolu,PER.division,PER.bank_branch,BK.code
FROM tblper AS PER,tbl_conpayment AS PY,tbl_conbank AS BK
WHERE (PER.bank = BK.bank) and (PER.bank = '$bkname') and (PER.bankGroup = '$bgroup') and (PY.month = '$mth' and PY.year= '$yr') and (PER.fileNo = PY.fileNo) and
(PY.rank = '$cadre') limit $eu, $limit" ;
$result=mysql_query($query) or die ( 'here 2 '.mysql_error());//limit $eu, $limit
$rows = mysql_fetch_assoc($result)
//..,PER.accNo,PER.surname,PER.othernames,Bk.branch,BK.sort_code,SUM(PY.totalEmolu) AS netEmolu
//$bk=mysql_fetch_array($result);...............limit $eu, $limit
?>
<div align="center">
<table width="1122" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><div align="center"><strong>
<?php ;//require_once('header.php');?>
NATIONAL INDUSTRIAL COURT
<br />
</strong></div></td>
</tr>
<tr>
<td colspan="3"><div align="center">C.P.O<br />
31, LUGARD AVENUE, IKOYI, LAGOS<br />
BANK SCHEDULE</div></td>
</tr>
<tr>
<td width="723"><div align="left">The Branch Manager,<br />
First Bank of Nigeria,<br />
Adeola Odeku,Victoria Island,<br />
Lagos, Nigeria. <br />
</div></td>
<td width="405" colspan="2"><div align="left">
<p>To be attached to P.V. No.:<br />
Month:<?php echo $rows['month']." ".$rows['year'];?><br />
Date Printed: <?php echo date('d/m/Y');?><br />
<strong>Bank: <?php echo $rows['bank']." ".$bankGroup; ?></strong></p>
</div></td>
</tr>
<tr>
<td colspan="3">Schedule of accounts to be credited on the morning ___________________. In respect of the enclose remittance of #______________<br /></td>
</tr>
<tr>
<td colspan="3"><table width="988" border="1" align="center" cellpadding="0" cellspacing="0" background="images/bg_1.png" class="tblborder">
<tr>
<td width="50"><strong>S/N</strong></td>
<td width="407"><div align="center"><strong>BENEFICIARY</strong></div> <div align="center"></div> <div align="center"></div></td>
<td width="185"><strong>BRANCH</strong></td>
<td width="175"><div align="center"><strong>ACC NUMBER</strong></div></td>
<td width="159"><div align="center"><strong>AMOUNT</strong>(<img src="images/naira.jpg" width="15" />)</div></td>
</tr>
<?php
$sn = 1;
$total =0;
//while($rows = mysql_fetch_array($result))
//{
do {
//$total = $total + $rows['totalEmolu'];
?>
<tr>
<td align="left"><?php echo $sn; ?></td>
<td align="left"> <?php echo $rows['surname'].', '.$rows['first_name']." ".$rows['othernames']; ?> </td>
<td align="left"><?php echo $rows['bank_branch']; ?></td>
<td align="center"> <?php echo $rows['accNo'] ;?></td>
<td align="center"> <?php echo number_format($rows['totalEmolu'], 2, '.', ',');//$rows['totalEmolu']; ?></td>
</tr>
<?php
++$sn;
$total = $total + $rows['totalEmolu'];
} while ($rows = mysql_fetch_assoc($result));
//$topetotal = $total;
?>
</table>
<table width="1202" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="1181"><div align="center"></div></td>
</tr>
<tr>
<td><table width="831" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="391"><?php echo $rows['bank']; ?></td>
<td width="110"> </td>
<td width="330"><?php
if($nume > $limit ){ // Let us display bottom links if sufficient records are there for paging
/////////////// Start the bottom links with Prev and next link with page numbers /////////////////
echo "<table align = 'center' width='80%'><tr><td align='left' width='30%'>";
//// if our variable $back is equal to 0 or more then only we will display the link to move back ////////
if($back >=0) {
print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREV</font></a>";
}
//////////////// Let us display the page links at center. We will not display the current page as a link ///////////
echo "</td><td align=center width='30%'>";
$i=0;
$l=1;
for($i=0;$i < $nume;$i=$i+$limit){
if($i <> $eu){
echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> ";
}
else { echo "<font face='Verdana' size='4' color=red>$l</font>";} /// Current page is not displayed as link and given font color red
$l=$l+1;
}
echo "</td><td align='right' width='30%'>";
///////////// If we are not in the last page then Next link will be displayed. Here we check that /////
if($this1 < $nume) {
print "<a href='$page_name?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";}
echo "</td></tr></table>";
}
// end
//if checking sufficient records are there to display bottom navigational link.
?>
<br />
Total: <img src="images/naira.jpg" width="15" /><?php echo "<b>".number_format($total, 2, '.', ',')."</b><br>" ;
?>
<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>
</td>
</tr>
<tr>
<td colspan="3"><p> </p>
<p><strong>AMOUNT IN WORDS:</strong> <span id="result"></span></p></td>
</tr>
<tr>
<td colspan="3"><br />
<strong>CERTIFICATE </strong>It is hereby certified that the above accounts will be credited on the date indicated to the respective accounts of the persons named above</td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2">______________________Manager</td>
</tr>
</table></td>
</tr>
<tr>
<td>..............................................................................................................................................................................................................................................................</td>
</tr>
</table></td>
</tr>
</table>
<form>
<div align="center"></div>
</form>
</div>
</body>
</html>
<?php
//mysql_free_result($viewSch);
//session_unregister($_SESSION['schqc']);
//session_unregister($_SESSION['mqc']);
//session_unregister($_SESSION['yqc']);
//
//echo 'the vak::::::'.$_SESSION['schqc'];
$user->close();
?>