⚝
One Hat Cyber Team
⚝
Your IP:
216.73.217.37
Server IP:
15.235.14.176
Server:
Linux server2.ihostph.com 4.18.0-553.30.1.el8_10.x86_64 #1 SMP Tue Nov 26 02:30:26 EST 2024 x86_64
Server Software:
Apache
PHP Version:
8.1.34
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
gracious
/
verification.graciousphils.com
/
View File Name :
verificationPosting.php
<!doctype html> <?php include 'connection.php'; if(isset($_SESSION['user']) && $_SESSION['position'] == 2){ ?> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Bootstrap CSS --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-+0n0xVW2eSR5OomGNYDnhzAbDsOXxcvSN1TPprVMTNDbiYZCxYbOOl7+AMvyTG2x" crossorigin="anonymous"> <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.0.1/css/bootstrap.min.css"/> <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css"/> <link rel="stylesheet" type="text/css" href="styles.css"> <title>VERIFICATION+</title> <style type="text/css"> .dataTables_length { margin-bottom: 5px; } .requestModal input, .requestModal textarea{ background-color: transparent !important; border:0px transparent !important; } .requestModal label{ } </style> </head> <body> <?php include 'navBar.php'; ?> <?php $st = $pdo->prepare("select * from tblrequests where status = 'Complete' order by request_id DESC"); $st->execute(); ?> <br> <div class="container"> <div class="row"> <h2 class="col-lg-6 offset-lg-3 text-center">Verification Posting</h2> </div> <div class="row mb-2"> </div> <div class="row"> <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12"> <table id="example" class="table table-bordered display compact" style="width: 100%;"> <thead> <tr class="text-center table-dark"> <th>Client No.</th> <th>Pensioner Name</th> <th>Sales Office</th> <th>Date Requested</th> <th>Date Received</th> <th>Batch</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php while ($data = $st->fetch()){ ?> <tr class="text-center"> <td><?php echo $data['clientNumber'];?></td> <td><?php echo $data['pensionerName'];?></td> <td><?php echo $data['salesOffice'];?></td> <td><?php echo $data['dateRequested'];?></td> <td><?php echo $data['receiveDate'];?></td> <td><?php echo $data['v1Batch'];?></td> <td><?php echo $data['status'];?></td> <td> <button type="button" class="btn btn-secondary text-white" name="btnLastTrans" data-bs-toggle="modal" data-bs-target="<?php echo '#modal' . $data['request_id'];?>"> View </button> </td> </tr> <!-- Start of Last Transaction Modal --> <div class="modal fade requestModal" id="<?php echo 'modal' . $data['request_id'];?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl"> <div class="modal-content text-black"> <div class="modal-header"> <h5 class="modal-title" id="exampleModalLabel">VERIFICATION+ FORM OVERVIEW</h5> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <form method="POST" action="requestAction.php"> <div class="modal-body"> <div class="col-lg-12"> <h6 class="text-muted">Client Information</h6> </div> <div class="row"> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalClientType" value="<?php echo $data['clientType']; ?>" readonly> <label for="modalClientType">Client Type</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalClientNumber" value="<?php echo $data['clientNumber']; ?>" readonly> <label for="modalClientNumber">Client I.D No.</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalSalesOffice" value="<?php echo $data['salesOffice']; ?>" readonly> <label for="modalSalesOffice">Sales Office</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalPensionProvider" value="<?php echo $data['pensionProvider']; ?>" readonly> <label for="modalPensionProvider">Pens. Provider Type</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalPensionAcountNumber" value="<?php echo $data['pensionAccountNumber']; ?>" readonly> <label for="modalPensionAcountNumber">Pens. Acct. Number</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalPensionType" value="<?php echo $data['pensionType']; ?>" readonly> <label for="modalPensionType">Pens. Type</label> </div> </div> </div> <div class="row"> <div class="col-lg-4 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalMemberName" value="<?php echo $data['memberName']; ?>" readonly> <label for="modalMemberName">Member's Name</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalMemberBirthday" value="<?php echo $data['memberBirthday']; ?>" readonly> <label for="modalMemberBirthday">Birthdate</label> </div> </div> <div class="col-lg-4 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalPensionerName" value="<?php echo $data['pensionerName']; ?>" readonly> <label for="modalPensionerName">Pensioner's Name</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalPensionerBirthday" value="<?php echo $data['pensionerBirthday']; ?>" readonly> <label for="modalPensionerBirthday">Birthdate</label> </div> </div> </div> <div class="row"> <div class="col-lg-12 mb-2"> <div class="form-floating"> <input type="text" class="form-control" id="modalAddress" name="address" value="<?php echo $data['address']; ?>" readonly> <label for="modalAddress">Address</label> </div> </div> </div> <div class="row"> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalInvestigationType" value="<?php echo $data['investigationType']; ?>" readonly> <label for="modalInvestigationType">Investigation Type</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalContactNumber" value="<?php echo $data['contactNumber']; ?>" readonly> <label for="modalContactNumber">Contact Number</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalSmAccount" value="<?php echo $data['smAccount']; ?>" readonly> <label for="modalSmAccount">Social Media Acct.</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalBankName" value="<?php echo $data['bankName']; ?>" readonly> <label for="modalBankName">Bank Name</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalAccountNumber" value="<?php echo $data['bankAccountNumber']; ?>" readonly> <label for="modalAccountNumber">Account Number</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <input type="text" class="form-control" name="modalPensionAmount" value="<?php echo $data['pensionAmount']; ?>" readonly> <label for="modalPensionAmount">Pension Amount</label> </div> </div> </div> <div class="row"> <div class="col-lg-12 mb-2"> <div class="form-floating"> <textarea class="form-control" name="remarks" id="modalRemarks" style="resize: none;height:100px;" placeholder=""><?php echo $data['remarks']; ?></textarea> <label for="modalRemarks">Remarks</label> </div> </div> </div> <div class="col-lg-12"> <h6 class="text-muted">Verification Results</h6> </div> <div class="row mb-2"> <div class="col-lg-2 mb-2"> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <?php if($data['v1Result']=="Passed"){ $color = "green"; } else{ $color = "red"; } ?> <input type="text" class="form-control" name="modalV1Result" style="color: <?php echo $color;?>;font-weight: bold;" value="<?php echo $data['v1Result']; ?>" readonly> <label for="modalV1Result">V1 Result</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <?php if($data['v2Result']=="Passed"){ $color = "green"; } else{ $color = "red"; } ?> <input type="text" class="form-control" name="modalV2Result" style="color: <?php echo $color;?>;font-weight: bold;" value="<?php echo $data['v2Result']; ?>" readonly> <label for="modalV2Result">V2 Result</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <?php if($data['v3Result']=="Passed"){ $color = "green"; } else if($data['v3Result']=="Failed"){ $color = "red"; } else{ $color = "black"; } ?> <input type="text" class="form-control" name="modalV3Result" style="color: <?php echo $color;?>;font-weight: bold;" value="<?php echo $data['v3Result']; ?>" readonly> <label for="modalV3Result">V3 Result</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <?php if($data['v4Result']=="Passed"){ $color = "green"; } else if($data['v4Result']=="Failed"){ $color = "red"; } else{ $color = "black"; } ?> <input type="text" class="form-control" name="modalV4Result" style="color: <?php echo $color;?>;font-weight: bold;" value="<?php echo $data['v4Result']; ?>" readonly> <label for="modalV4Result">V4 Result</label> </div> </div> </div> </div> <div class="col-lg-7 mb-2"> <div class="form-floating"> <textarea class="form-control" name="remarks" id="modalVerificationRemarks" style="resize: none;height:250px;" placeholder="" readonly><?php echo "V1 Remarks: " . $data['v1Remarks'] ." -" . $data['v1By']. "\n" . "V2 Remarks: " . $data['v2Remarks'] ." -" . $data['v2By']. "\n" . "V3 Remarks: " . $data['v3Remarks'] ." -" . $data['v3By']. "\n" . "V4 Remarks: " . $data['v4Remarks'] ." -" . $data['v4By']. "\n\n" . "No Reply Lending: " . $data['v3NoReply']; ?> </textarea> <label for="modalVerificationRemarks">Remarks</label> </div> </div> <div class="col-lg-3 mb-2"> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <input type="text" class="form-control" name="modalV2BankName" value="<?php echo $data['v2BankName']; ?>" readonly> <label for="modalV2BankName">Bank Name</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <input type="text" class="form-control" name="modalV2BankAccountNumber" value="<?php echo $data['v2BankAccountNumber']; ?>" readonly> <label for="modalV2BankAccountNumber">Account No.</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <input type="text" class="form-control" name="modalV2PensionAmount" value="<?php echo $data['v2PensionAmount']; ?>" readonly> <label for="modalV2PensionAmount">Pension Amount</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <div class="form-floating"> <input type="text" class="form-control" name="modalV2SSSVerifier" value="<?php echo $data['v2SSSVerifier']; ?>" readonly> <label for="modalV2SSSVerifier">SSS/GSIS Verifier</label> </div> </div> </div> </div> </div> <div class="row"> <div class="col-lg-3"> <div class="form-floating"> <input type="text" class="form-control" name="modalV4Batman" value="<?php echo $data['v4Batman']; ?>" readonly> <label for="modalV4Batman">Batman</label> </div> </div> <div class="col-lg-3"> <div class="form-floating"> <input type="text" class="form-control" name="modalV4VisitDate" value="<?php echo $data['v4VisitDate']; ?>" readonly> <label for="modalV4VisitDate">Visit Date</label> </div> </div> <div class="col-lg-3"> <div class="form-floating"> <input type="text" class="form-control" name="modalV1Time" value="<?php echo $data['v1Time']; ?>" readonly> <label for="modalV1Time">Time Received</label> </div> </div> <div class="col-lg-3"> <div class="form-floating"> <input type="text" class="form-control" name="modalV1Batch" value="<?php echo $data['v1Batch']; ?>" readonly> <label for="modalV1Batch">Batch</label> </div> </div> </div> <div class="row mt-4"> <div class="col-lg-12"> <button type="submit" name="btnPost" class="btn btn-primary w-100">Post</button> </div> </div> </form> </div> </div> </div> </div> <!-- End of Last Transaction Modal --> <?php } ?> </tbody> </table> </div> </div> </div> <!-- Optional JavaScript; choose one of the two! --> <!-- Option 1: Bootstrap Bundle with Popper --> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/js/bootstrap.bundle.min.js" integrity="sha384-gtEjrD/SeCtmISkJkNUaaKMoLD0//ElJ19smozuHV6z3Iehds+3Ulb9Bn9Plx0x4" crossorigin="anonymous"></script> <script src="https://code.jquery.com/jquery-3.5.1.js"></script> <script src="https://cdn.datatables.net/1.10.25/js/jquery.dataTables.min.js"></script> <script> $(document).ready(function() { $('#example').DataTable({ ordering: false }); } ); </script> <!-- Option 2: Separate Popper and Bootstrap JS --> <!-- <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/js/bootstrap.min.js" integrity="sha384-Atwg2Pkwv9vp0ygtn1JAojH0nYbwNJLPhwyoVbhoPwBhjQPR5VtM2+xf0Uwh9KtT" crossorigin="anonymous"></script> --> </body> </html> <?php } else{ session_destroy(); header("location:index.php"); } ?>