| Server IP : 199.250.214.225 / Your IP : 18.219.155.102 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']) )
{
$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']);
}
//
//$result = mysql_query("select * from tblper order by surname, othernames");
?>
<?php
$db = mysqli_connect("localhost","sanfas93_payroll","_nicn.payroll","sanfas93_payroll");
$getSignatory = mysqli_query($db, "select * from tblsignatory");
$sql = mysqli_query($db, "select * from signatory where month='January' and year ='2018' ");
$check = mysqli_num_rows($sql);
if($check === 0)
{
$name1 = '';
$name2 = '';
$name3 = '';
$phone1 = '';
$phone2 = '';
$phone3 = '';
}
else
{
$sign1 = mysqli_query($db, "select * from signatory where month='January' and year ='2018' and sequence = 1");
$s1 = mysqli_fetch_assoc($sign1);
$sign2 = mysqli_query($db, "select * from signatory where month='$month' and year ='$year' and sequence = 2");
$s2 = mysqli_fetch_assoc($sign2);
$sign3 = mysqli_query($db, "select * from signatory where month='$month' and year ='$year' and sequence = 3");
$s3 = mysqli_fetch_assoc($sign3);
echo $name1 = $s1['name'];
$name2 = $s2['name'];
$name3 = $s3['name'];
$phone1 = $s1['phone'];
$phone2 = $s2['phone'];
$phone3 = $s3['phone'];
}
?>
<!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="eschedule.php"; // If you use this code with a different page ( or file ) name then change this
@$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 = 10; // No of records to be shown per page.
$this1 = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
if ($cadre != "CR")
{
$query="SELECT PER.fileNo, PY.fileNo, PER.bank, BK.bank, PY.month, PY.year, PER.accNo, BK.sort_code,PER.surname, PER.first_name, PER.othernames,
PY.totalEmolu, PER.bank_branch, BK.code, PER.accNo, BK.sort_code, BK.code, 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') and (PER.bankGroup ='$bgroup')";
}
else
{
$query="SELECT PER.fileNo, PY.fileNo, PER.bank, BK.bank, PY.month, PY.year, PER.surname, PER.first_name, PER.othernames, PY.totalEmolu,
PER.bank_branch, BK.code, PER.accNo, BK.sort_code, BK.code as CR_CODE
FROM tblper AS PER, tbl_conpayment AS PY, tbl_conbank AS BK
WHERE (BK.division = 'LAGOS' and BK.bank = PER.bank) and(PER.bank = BK.bank AND PER.bank = '$bkname') and (PER.bankGroup ='$bgroup') and (PY.rank = '$cadre') AND
(PY.month = '$mth' AND PY.year = '$yr') AND (PER.fileNo = PY.fileNo) ORDER BY PY.basic_salary desc 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 NIGERIA
<br />
</strong></div></td>
</tr>
<tr>
<td colspan="3"><div align="center">10, PORT HARCOURT CRESENT, AREA 11, GARKI, ABUJA<br />
ACCOUNT NUMBER: <?php if($cadre == "CR") echo "2004656203";
else
echo "0003690917"; ?><br />
E-PAYMENT SCHEDULE</div></td>
</tr>
<tr>
<td width="723"><div align="left">The Branch Manager,<br />
<?php
if($cadre == "CR")
echo "First Bank of Nigeria,<br>
Adeola Odeku,Victoria Island,<br>
Lagos, Nigeria.<b>";
else
{
echo "Guaranty Trust Bank,<br />
Broad Street,<br />
Lagos, Nigeria. <br />";
}
?>
</div></td>
<td width="405" colspan="2"><div align="left">Reference No:Con/<?php echo date('Y'); ?>/1<?php echo $rows['code'];//date('d/m/Y');?>/A<br />
Code:<?php if ($cadre == "CR") echo $rows['CR_CODE']; else echo $rows['code']; ?> <br />
Sort Code: <?php echo $rows['sort_code'];?><br />
Division: <b><?php echo $rows['division'];?></b>
</div></td>
</tr>
<tr>
<td colspan="3"><table width="1177" border="1" align="center" cellpadding="0" cellspacing="0" background="images/bg_1.png" class="tblborder">
<tr>
<td width="36"><div align="center"><strong>S/N</strong></div></td>
<td width="286"><div align="center"><strong>BENEFICIARY</strong></div> <div align="center"></div> <div align="center"></div></td>
<td width="214"><strong>BANK </strong></td>
<td width="70"><strong>BRANCH</strong></td>
<td width="175"><div align="center"><strong>ACC NUMBER</strong></div></td>
<td width="107"><div align="center"><strong>AMOUNT</strong>(<img src="images/naira.jpg" width="15" height="13" />)</div></td>
<td width="204"><strong>PURPOSE OF PAYMENT</strong></td>
</tr>
<?php
$sn = 1;
$total =0;
//while($rows = mysql_fetch_array($result))
//{
do {
//$total = $total + $rows['totalEmolu'];
?>
<tr>
<td align="center"> <?php echo $sn; ?></td>
<td align="left"> <?php echo $rows['surname'].', '.$rows['first_name']." ".$rows['othernames']; ?> </td>
<td align="left"><?php echo $rows['bank']; ?></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>
<td align="center"><div align="left"><?php echo $rows['month'].' '. $rows['year']; ?> Staff Salary</div></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 colspan="5"><div align="center">
<?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 />
<?php echo "Please credit the account(s) of the above listed beneficiary(s) and debit our account above with: <img src='images/naira.jpg' width='15' height='13' /><b>".number_format($total, 2, '.', ',')."</b><br>" ;
$money_split = explode('.', $total);
?>
<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"><br /></span>
</div><br /></td>
</tr>
<tr>
<td colspan="0" align="left"><strong>ALL DUE PROCESS COMPLIED WITH</strong></strong></td>
</tr>
<tr>
<td width="385"><div align="left"><strong>Authorized Signatory</strong><br />
</div></td>
<td width="167"><div align="left"><br />
</div></td>
<td width="1" rowspan="9"> </td>
<td colspan="2"><div align="left"><strong>Submitted For Confirmation by</strong><br />
</div></td>
</tr>
<tr>
<td align="left">Name: <?php echo $name1; ?></td>
<td> </td>
<td colspan="2" align="left">Name: <?php echo $name3; ?></td>
</tr>
<tr>
<td align="left" valign="top">Signature:<br />
Date:</td>
<td valign="top"><img src="images/sch.jpg" alt="sch" width="120" height="85" align="left" /></td>
<td width="448" align="left" valign="top">Signature:<br />
Date:</td>
<td width="181" valign="top"><div align="left"><img src="images/sch.jpg" alt="sch" width="120" height="85" align="left" /></div></td>
</tr>
<tr>
<td align="left">Tel No: <?php echo $phone1; ?></td>
<td> </td>
<td colspan="2" align="left">Tel No: <?php echo $phone1; ?></td>
</tr>
<tr>
<td align="left" width = 385><strong>Authorized Signatory</strong></td>
<td> </td>
<td colspan="2"><div align="left"><strong>Confirmed Before Me</strong><br />
</div></td>
</tr>
<tr>
<td align="left">Name: <?php echo $name2; ?></td>
<td> </td>
<td colspan="2" align="left">Name:</td>
</tr>
<tr>
<td valign="top" align="left">Signature:<br />
Date:</td>
<td valign="top"><img src="images/sch.jpg" alt="sch" width="120" height="85" align="left" /></td>
<td valign="top" align="left">Signature:<br />
Date:</td>
<td valign="top"><img src="images/sch.jpg" alt="sch" width="120" height="85" align="left" /></td>
</tr>
<tr>
<td align="left">Tel No: <?php echo $phone3; ?>
<?php
//require_once 'convertAmount.php';
//echo convert_number_to_words(12);
// one hundred and twenty-three million, four hundred and fifty-six thousand, seven hundred and eighty-nine
//echo convert_number_to_words(123456789.123);
// one hundred and twenty-three million, four hundred and fifty-six thousand, seven hundred and eighty-nine point one two three
//echo convert_number_to_words(-1922685.477);
// negative one million, nine hundred and twenty-two thousand, six hundred and eighty-five point four seven seven
// float rounding can be avoided by passing the number as a string
//echo convert_number_to_words(125.45); // rounds the fractional part
// one hundred and twenty-three billion, four hundred and fifty-six million, seven hundred and eighty-nine thousand, one hundred and twenty-three point one two
//echo convert_number_to_words('123456789123.12345'); // does not round
?></td>
<td> </td>
<td colspan="2" align="left">Tel No:</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();
?>