| Server IP : 199.250.214.225 / Your IP : 3.143.25.65 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
session_start();
require_once('business logic/classes/users.php');
if(isset($_POST['action']))
{
$month = trim($_POST['month']);
$year = trim($_POST['year']);
header("location:editSignatory.php?month=$month&year=$year");
}
$con = mysqli_connect("localhost","sanfas93_payroll","_nicn.payroll","sanfas93_payroll");
if(isset($_POST['submit']))
{
$bankGroup = mysqli_real_escape_string($con,$_POST['bankgroup']);
$bank = mysqli_real_escape_string($con,$_POST['bank']);
$year = mysqli_real_escape_string($con,$_POST['year']);
$division = mysqli_real_escape_string($con,$_POST['division']);
$rank = mysqli_real_escape_string($con,$_POST['rank']);
$_SESSION['division'] = $_POST['division'];
header("location:penames.php?bank=$bank&bgroup=$bankGroup&yr=$year&div=$division&rk=$rank");
}
$arrears = mysqli_query($con, "select * from tblarrears where year = 2016 and fileno = 1002");
foreach ($arrears as $key) {
$key['oldGrade'];
}
$allbanklist = mysqli_query($con,"select DISTINCT a.bank from tblper a join tblbanklist b where a.bank = b.bank ");
$divs = mysqli_query($con,"select * from tbldivision");
?>
<?php
$getSignatory1 = mysqli_query($con, 'select * from tblsignatory where category = 1 order by rank');
$getSignatory2 = mysqli_query($con, 'select * from tblsignatory where category = 2 ');
$getSignatory3 = mysqli_query($con, 'select * from tblsignatory where category = 3 ');
?>
<?php
if(isset($_POST['action']))
{
$month = trim($_POST['month']);
$year = trim($_POST['year']);
// header("location:editSignatory.php?month='.$month.'&year='.$year.'");
// $data['getSignatory1'] = mysqli_query($con, "select from signatory where category = 1 order by rank" );
// $data['getSignatory2'] = mysqli_query($con, "select from signatory where category = 2" );
//$data['getSignatory3'] = mysqli_query($con, "select from signatory where category = 3" );
/*$count = DB::table('signatory')->where('month','=',$month)->where('year','=',$year)->count();
if($count > 1)
{
$s1 = mysqli_query($con, "select from signatory where month = '$month' and year = '$year' and sequence =1" );
$signatory1 = mysqli_fetch_assoc($s1);
$s2 = mysqli_query($con, "select from signatory where month = '$month' and year = '$year' and sequence =2" );
$signatory2 = mysqli_fetch_assoc($s);
$s3 = mysqli_query($con, "select from signatory where month = '$month' and year = '$year' and sequence =3" );
$signatory3 = mysqli_fetch_assoc($s3);
}*/
}
?>
<?php
//require_once('business login/classes/.php');
$user = new User();
$uid = $_SESSION['uid'];
$access = $_SESSION['acc'];
//
if($access > 2)
header("location:delay.php");
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");
}
//
?>
<!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...::...Classification Code</title>
<link href="css/payroll.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/jQuery-2.2.0.min.js"></script>
<script type="text/javascript">
$( function() {
$("#signatory1").on('change', function(){
var id = $(this).val();
//alert(id);
//$token = $("input[name='_token']").val();
$.ajax({
// headers: {'X-CSRF-TOKEN': $token},
url: 'getSignatoryAjax.php',
type: "post",
data: {'signid': id},
success: function(datas){
console.log(datas.phoneno);
//alert(datas.phoneno);
$('#phone1').val(datas.phoneno);
$('#name1').val(datas.fullname);
}
});
});
$("#signatory2").on('change', function(){
var id = $(this).val();
//alert(id);
//$token = $("input[name='_token']").val();
$.ajax({
//headers: {'X-CSRF-TOKEN': $token},
url: 'getSignatoryAjax.php',
type: "post",
data: {'signid': id},
success: function(datas){
console.log(datas.phoneno);
//alert(datas.phoneno);
$('#phone2').val(datas.phoneno);
$('#name2').val(datas.fullname);
}
});
});
$("#signatory3").on('change', function(){
var id = $(this).val();
//alert(id);
//$token = $("input[name='_token']").val();
$.ajax({
// headers: {'X-CSRF-TOKEN': $token},
url: 'getSignatoryAjax.php',
type: "post",
data: {'signid': id},
success: function(datas){
console.log(datas.phoneno);
//alert(datas.phoneno);
$('#phone3').val(datas.phoneno);
$('#name3').val(datas.fullname);
}
});
});
});
</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;
}
.inputs { background-color: #ffffff;
margin: 2px;
padding: 2px;
border: 1px solid #FF8A00;
color:#000;
}
-->
select
{
color:#000;
}
</style>
<script language="javascript" type="text/javascript">
function submitregistration() {
var form = document.login;
if(form.name.value == "")
{
alert( "Enter Bank Name" );
return false;
}
else if(form.branch.value == "")
{
alert( "Enter Bank Branch" );
return false;
}
else if( form.sort_code.value == "")
{
alert( "Enter Sort Code " );
return false;
}
else if( form.rank.value == "")
{
alert( "Enter rank " );
return false;
}
else if( form.bank.value == "")
{
alert( "Select Bank " );
return false;
}
else if( form.division.value == "")
{
alert( "Select Division " );
return false;
}
else if( form.year.value == "")
{
alert( "Enter Year " );
return false;
}
}
</script>
<script language="javascript" src="js/cal2.js">
/*
Xin's Popup calendar script- Xin Yang (http://www.yxscripts.com/)
Script featured on/available at http://www.dynamicdrive.com/
This notice must stay intact for use
*/
</script>
<script language="javascript" src="js/cal_conf2.js"></script>
</head>
<body onLoad="document.login.name.focus()">
<table width="744" border="0" cellpadding="0" cellspacing="0" class="container" align="center" >
<!--DWLayoutTable-->
<tr>
<td width="800" height="42" colspan="2" valign="top"><?php require_once('header.php');?></td>
</tr>
<tr>
<td height="19" colspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="bottomborder">
<!--DWLayoutTable-->
<tr>
<td width="33%"> <a href="userArea.php">Home</a> </td>
<td width="67%"><?php
//$user->getLink($access);
$user->get_fullname($uid);
?><a href="?q=logout">Logout</a> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="243" valign="top"><?php require('links.php');?>
<br /></td>
<td valign="top"><table width="310" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="310" colspan="3"><br />
<fieldset>
<legend>Consolidated Payroll Report<br />
</legend>
<form method="post" action="">
<table width="100%">
<tr>
<td>
<label for="bankGroup">Month</label>
<select name="month" id="month" class="form-control">
<option value=""></option>
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
</td>
<td>
<label for="workingState">Year</label>
<select name="year" id="year" class="form-control">
<option></option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
<option value="2030">2030</option>
<option value="2031">2031</option>
<option value="2032">2032</option>
<option value="2033">2033</option>
<option value="2024">2034</option>
<option value="2035">2035</option>
<option value="2036">2036</option>
<option value="2037">2037</option>
<option value="2038">2038</option>
<option value="2039">2039</option>
<option value="2040">2040</option>
</select>
</td>
</tr>
<tr>
<td><button name="action" id="action" class="btn btn-success" type="submit">SAVE</button></td>
<td> </td>
</tr>
</table>
</form>
</fieldset></td>
</tr>
</table></td>
</tr>
<tr>
<td height="20" colspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td>
</td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<?php $user->close();?>