MAINHACK

Viewing / Editing File: Viewpayment.php

<?php 
//  ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include("functions.php");
 //error_reporting(0);
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {
   $s_code = $_SESSION['s_code_Xw2119904'];
$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($s_code));
$row = $stmt->fetch();
$logo = $row['logo'];
    if(empty($logo)){
      header("Location:complete-process");
    } else {

$academic_year = isset($_GET['academic_year']) ? mysqli_real_escape_string($new, $_GET['academic_year']) : '';

$where = "";
if (!empty($academic_year)) {
    $where = " AND stud_payment.academic_year = '$academic_year'";
}

// === FETCH DATA ===
$query = "
    SELECT enrol_generic.indexNo, enrol_generic.stud_name, enrol_generic.s_code,
           stud_payment.access_code, stud_payment.amount, stud_payment.pstatus,
           stud_payment.academic_year, MAX(stud_payment.datepaid) AS datepaid
    FROM enrol_generic
    INNER JOIN stud_payment ON stud_payment.indexNumber = enrol_generic.indexNo
    WHERE enrol_generic.s_code = '$s_code' $where
    GROUP BY enrol_generic.indexNo
";
$regis = mysqli_query($new, $query);

// === ANALYTICS ===
$total_students = mysqli_num_rows($regis);
$total_paid = 0;
$total_unpaid = 0;
$total_amount = 0;

$data = [];
if ($total_students > 0) {
    mysqli_data_seek($regis, 0);
    while ($row = mysqli_fetch_assoc($regis)) {
        $data[] = $row;
        $total_amount += $row['amount'];
        if ($row['pstatus'] == 'Paid') {
            $total_paid++;
        } else {
            $total_unpaid++;
        }
    }
}

// if ($_SERVER['REQUEST_METHOD'] === 'POST') {
//     $indexNo  = mysqli_real_escape_string($new, $_POST['indexNo']);
//     $new_s_code = mysqli_real_escape_string($new, $_POST['s_code']);

//     $update = mysqli_query($new, "
//         UPDATE stud_payment 
//         SET s_code = '$new_s_code' 
//         WHERE indexNumber = '$indexNo'
//     ");

//        $updatee = mysqli_query($new, "
//         UPDATE enrol_generic 
//         SET access = '$indexNo' 
//         WHERE indexNo = '$indexNo'
//     ");

//     if ($update) {

//         header("Location: ".$_SERVER['HTTP_REFERER']."?success=1");
        
//         exit();
//     } else {
//         echo "Error updating record: " . mysqli_error($new);
//     }
// }

}
}

?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ALL PAYMENT MADE </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Themesbrand" name="author" />

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />
  <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

</head>

<body>

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">ALL PAYMENT MADE</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">ALL PAYMENT MADE<</li>
</ol>
</div>

</div>
</div>
</div>

<div class="table-responsive">
      <table id="datatable-buttons" class="table table-bordered table-striped table-hover align-middle text-nowrap w-100">
        <thead class="table-dark">
          <tr>
            <th>#</th>
            <th>Student Name</th>
            <th>Index No.</th>
            <th>Access Code</th>
            <th>Amount</th>
            <th>Status</th>
            <th>Date Paid</th>
            <th>Academic year</th>
          </tr>
        </thead>

<tbody>
          <?php 
          $cnt = 1;
          $regis = mysqli_query(
              $new,
              "SELECT enrol_generic.indexNo, enrol_generic.stud_name, enrol_generic.s_code,
                      stud_payment.access_code, stud_payment.amount, stud_payment.pstatus,stud_payment.academic_year, 
                      MAX(stud_payment.datepaid) AS datepaid
               FROM enrol_generic
               INNER JOIN stud_payment ON stud_payment.indexNumber = enrol_generic.indexNo
               WHERE enrol_generic.s_code = '$s_code'
               GROUP BY enrol_generic.indexNo"
          );

if (mysqli_num_rows($regis) > 0) {
              while ($dothis = mysqli_fetch_array($regis)) {
                  $modalId = 'editModal_' . $cnt; // unique modal ID per row
          ?>
          <tr>
            <td><?php echo $cnt++; ?></td>
            <td><?php echo htmlspecialchars($dothis['stud_name']); ?></td>
            <td><?php echo htmlspecialchars($dothis['indexNo']); ?></td>
            <td><?php echo htmlspecialchars($dothis['access_code']); ?></td>
            <td><?php echo htmlspecialchars($dothis['amount']); ?></td>
            <td>
              <?php if ($dothis['pstatus'] == 'Paid') { ?>
                <span class="badge bg-success">Paid</span>
              <?php } else { ?>
                <span class="badge bg-danger"><?php echo htmlspecialchars($dothis['pstatus']); ?></span>
              <?php } ?>
            </td>
            <td><?php echo htmlspecialchars($dothis['datepaid']); ?></td>
            <td><?php echo htmlspecialchars($dothis['academic_year']); ?></td>
          </tr>

<?php 
              }
          } else {
              echo "<tr><td colspan='9' class='text-center text-danger'>No records found</td></tr>";
          }
          ?>
        </tbody>
      </table>
    </div>

</div>
</div>

<?php include("includes/footer.php");?>
</div>

</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: Viewpayment.php

Server Info

System Features

User Info