MAINHACK

Viewing / Editing File: index.php

<?php 
 include("functions.php");
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:auth/");
 } else {
   $s_code = $_SESSION['s_code_Xw2119904'];
      $uname = $_SESSION['name_Xw2119904'];

$stmt = $con->prepare("SELECT * FROM schools WHERE user_name = ? AND school_code = ?");
$stmt->execute(array($uname, $s_code));
$userstatus = $stmt->fetchAll();

// Initialize $namee to prevent potential errors
$namee = null;

foreach ($userstatus as $sta) {
    $namee = $sta['user_name'];
    $userid = $sta['id'];
    $school_name = $sta['school_name'];
}

$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 {

$total_students = [];
$stmt = $new->prepare("SELECT COUNT(aid) AS total FROM enrol_generic WHERE s_code = ?");
$stmt->bind_param("s", $s_code);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$total_students[] = (int)$row['total'];
}
$stmt->close();

$total_registered = [];
$stmt = $new->prepare("SELECT COUNT(id) AS total FROM enrol_details WHERE s_code = ?");
$stmt->bind_param("s", $s_code);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$total_registered[] = (int)$row['total'];
}
$stmt->close();

$total_unregistered = [];
$stmt = $new->prepare("SELECT COUNT(aid) AS total FROM enrol_generic LEFT JOIN enrol_details ON enrol_generic.indexNo = enrol_details.index_no WHERE enrol_generic.s_code = ? AND enrol_details.index_no IS NULL");
$stmt->bind_param("s", $s_code);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$total_unregistered[] = (int)$row['total'];
}
$stmt->close();

// Prepare data for the second chart (Total Payments)
$total_payment_count = [];
$stmt = $new->prepare("SELECT COUNT(pid) AS total FROM stud_payment WHERE s_code = ?");
$stmt->bind_param("s", $s_code);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$total_payment_count[] = (int)$row['total'];
}
$stmt->close();

$total_payment_amount = [];
$stmt = $new->prepare("SELECT SUM(amount) AS amount FROM stud_payment WHERE s_code = ?");
$stmt->bind_param("s", $s_code);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$total_payment_amount[] = (float)$row['amount'];
}
$stmt->close();

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Dashboard | Online Admission Portal</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
<meta content="Themesbrand" name="author" />

<link href="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.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" />

#container {
    height: 450px;
}

.highcharts-data-table table {
    font-family: Verdana, sans-serif;
    border-collapse: collapse;
    border: 1px solid #ebebeb;
    margin: 10px auto;
    text-align: center;
    width: 100%;
    max-width: 500px;
}

.highcharts-data-table caption {
    padding: 1em 0;
    font-size: 1.2em;
    color: #555;
}

.highcharts-data-table th {
    font-weight: 600;
    padding: 0.5em;
}

.highcharts-data-table td,
.highcharts-data-table th,
.highcharts-data-table caption {
    padding: 0.5em;
}

.highcharts-data-table thead tr,
.highcharts-data-table tr:nth-child(even) {
    background: #f8f8f8;
}

.highcharts-data-table tr:hover {
    background: #f1f7ff;
}

.order-card {
    color: #fff;
}
.bg-c-blue {
    background: linear-gradient(45deg,#2e5cb8,#73b4ff);
}

.bg-c-green {
    background: linear-gradient(45deg,#2d8659,#59e0c5);
}

.bg-c-yellow {
    background: linear-gradient(45deg,#FFB64D,#ffcb80);
}

.bg-c-red {
    background: linear-gradient(45deg,#b30000,#b30000);
}

.bg-c-pink {
    background: linear-gradient(45deg,#FF5370,#ff869a);
}

.card {
    border-radius: 5px;
    -webkit-box-shadow: 0 1px 2.94px 0.06px rgba(4,26,55,0.16);
    box-shadow: 0 1px 2.94px 0.06px rgba(4,26,55,0.16);
    border: none;
    margin-bottom: 30px;
    -webkit-transition: all 0.3s ease-in-out;
    transition: all 0.3s ease-in-out;
}

.card .card-block {
    padding: 25px;
}

.order-card i {
    font-size: 26px;
}

.f-left {
    float: left;
}

.f-right {
    float: right;
}

.highcharts-credits {
display: none !important;
}
</style>

</head>

<?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">Dashboard</h4>

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

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

<?php 
if($namee != "Admin"){?>
 <?php 
$permission_name = 'dashboard';
if (has_permission($userid, $permission_name,'can_view', $new)) {?>

<div class="row">
<div class="col-md-4 col-xl-4">
  <div class="card bg-c-blue order-card">
    <div class="card-block">
      <h6 class="m-b-20" style="color:#fff">Placed by CSSPS</h6>
      <p style="color:#fff">
        Total: <span id="cssps-total">…</span><br/>
        Males: <span id="cssps-male">…</span><br/>
        Females: <span id="cssps-female">…</span><br/>
        Boarding: <span id="cssps-boarding">…</span><br/>
        Day: <span id="cssps-day">…</span>
      </p>
    </div>
  </div>
</div>

<div class="col-md-4 col-xl-4">
  <div class="card bg-c-green order-card">
    <div class="card-block">
      <h6 class="m-b-20" style="color:#fff">Completed online Admission</h6>
      <p style="color:#fff">
        Total: <span id="completed-total">…</span><br/>
        Males: <span id="completed-male">…</span><br/>
        Females: <span id="completed-female">…</span><br/>
        Boarding: <span id="completed-boarding">…</span><br/>
        Day: <span id="completed-day">…</span>
      </p>
    </div>
  </div>
</div>

<div class="col-md-4 col-xl-4">
  <div class="card bg-c-red order-card">
    <div class="card-block">
      <h6 class="m-b-20" style="color:#fff">Yet to perform Online Admission</h6>
      <p style="color:#fff">
        Total: <span id="pending-total">…</span><br/>
        Males: <span id="pending-male">…</span><br/>
        Females: <span id="pending-female">…</span><br/>
        Boarding: <span id="pending-boarding">…</span><br/>
        Day: <span id="pending-day">…</span>
      </p>
    </div>
  </div>
</div>

</div>

<?php } else {?>

<div class="card-body">
    <h3>My Subject</h3>
<table style="color: red;" id="datatable-buttons" class="table table-bordered dt-responsive nowrap w-100" >
<thead>
<tr>
<th>#</th>
<th>Programme</th>
<th>Subject name</th>
<th>Class name</th>
<th>Semester</th>
<th>View students</th>
</tr>
</thead>
<tbody>
<?php 
$cnt = 1;
  $select = mysqli_query($new,"SELECT * FROM teacher_subjects WHERE s_code = '$s_code' AND teacher_id = '$uname' ORDER BY id DESC");
 while ($getdata = mysqli_fetch_array($select)) {
        $houseID = $getdata['id'];
?>
<tr>
<td><?php echo $cnt++;?></td>
<td><?php echo $getdata['programe'];?></td>
<td><?php echo $getdata['subject_name'];?></td>
<td><?php echo $getdata['classname'];?></td>
<td><?php echo $getdata['semester'];?></td>
<td><a class="btn btn-primary" href="myclassstudents?classname=<?php echo urlencode($getdata['classname']); ?>&schoolcode=<?php echo urlencode($s_code); ?>">
    <i class="fa fa-eye"></i>
</a>
</td>
<?php }?>
</tr>

</tbody>
</table>
</div>

<?php }?>

<?php } else {?>

</div>
</div>

<?php }?>

</div>

</div>

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

</div>

async function load() {
    try {
      const res = await fetch(`dashboard_counts.php?s_code=${encodeURIComponent(window.S_CODE)}`, {
        headers: { 'Accept': 'application/json' },
        cache: 'no-store'    // or 'force-cache' if you add proper cache headers on PHP
      });
      if (!res.ok) throw new Error('Network response was not ok');
      const json = await res.json();

fill('cssps',    json.card1 || {});
      fill('completed',json.card2 || {});
      fill('pending',  json.card3 || {});
    } catch (e) {
      console.error(e);
      // fail gracefully
      ['cssps','completed','pending'].forEach(p => fill(p, {total:0,male:0,female:0,boarding:0,day:0}));
    }
  }

// Kick off after first paint
  if (document.readyState === 'loading') {
    document.addEventListener('DOMContentLoaded', load);
  } else {
    load();
  }
})();
</script>

<?php
$stmt = $new->prepare("
   SELECT
     COUNT(DISTINCT ed.index_no) AS total_registered,
     SUM(CASE WHEN LOWER(eg.gender)='male' THEN 1 ELSE 0 END) AS male,
     SUM(CASE WHEN LOWER(eg.gender)='female' THEN 1 ELSE 0 END) AS female,
     SUM(CASE WHEN LOWER(eg.status)='boarding' THEN 1 ELSE 0 END) AS boarding,
     SUM(CASE WHEN LOWER(eg.status)='day' THEN 1 ELSE 0 END) AS day
   FROM enrol_details ed
   JOIN (
       SELECT DISTINCT indexNo, gender, status
       FROM enrol_generic
       WHERE s_code = ?
   ) eg ON ed.index_no = eg.indexNo
   WHERE ed.s_code = ? AND ed.raw_score IS NOT NULL
");
$stmt->bind_param("ss", $s_code, $s_code);
$stmt->execute();
$result = $stmt->get_result();
$stats = $result->fetch_assoc();

$totalQuery = $new->prepare("
    SELECT COUNT(DISTINCT indexNo) AS total
    FROM enrol_generic
    WHERE s_code = ?
");
$totalQuery->bind_param("s", $s_code);
$totalQuery->execute();
$totalResult = $totalQuery->get_result();
$totalStudents = (int)$totalResult->fetch_assoc()['total'];

$totalRegistered = (int)$stats['total_registered'];
$totalUnregistered = $totalStudents - $totalRegistered;
?>

Highcharts.chart('container', chartOptions);
</script>

xAxis: {
    categories: ['Count', 'Total amount'],
    crosshair: true,
    accessibility: {
      description: 'Payment'
    }
  },

plotOptions: {
    series: {
      borderWidth: 0,
      dataLabels: {
        enabled: true,
        format: '{point.y:.1f}'
      }
    }
  },

series: [
    {
      name: 'Total Count',
      data: [<?php 
   
        $select_count = mysqli_query(
          $new,
          "SELECT COUNT(*) AS total FROM (
              SELECT indexNumber
              FROM stud_payment
              WHERE s_code = '$s_code' AND indexNumber <> ''
              GROUP BY indexNumber
          ) t"
        );

while($count = mysqli_fetch_array($select_count)){
          $totalcount = $count['total'];
          echo "".$totalcount.",";
        }
      ?>]
    },
    {
      name: 'Total amount',
      data: [<?php 
     
        $totalpay = mysqli_query(
          $new,
          "SELECT SUM(amount) AS amount FROM (
              SELECT indexNumber, MAX(amount) AS amount
              FROM stud_payment
              WHERE s_code = '$s_code' AND indexNumber <> ''
              GROUP BY indexNumber
          ) t"
        );

while($payment = mysqli_fetch_array($totalpay)){
          $money = $payment['amount'];
          echo "".$money.",";
        }
      ?>]
    }
  ]
});
</script>

<!--    <script>
     Highcharts.chart('container1', {
    chart: {
        type: 'column'
    },
    title: {
        text: 'TOTAL PAYMENTS',
        align: 'left'
    },
  
    xAxis: {
        categories: ['Count', 'Total amount'],
        crosshair: true,
        accessibility: {
            description: 'Payment'
        }
    },

tooltip: {
headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
'<td style="padding:0"><b>{point.y:.1f}</b></td></tr>',
footerFormat: '</table>',
shared: true,
useHTML: true
},
plotOptions: {
series: {
borderWidth: 0,
dataLabels: {
enabled: true,
format: '{point.y:.1f}'
}
}
},
    series: [
        {
            name: 'Total Count',
            data: [<?php 
$select_count = mysqli_query($new,"SELECT count(pid) as total FROM stud_payment WHERE s_code = '$s_code'");

while($cunt = mysqli_fetch_array($select_count)){
 $totalcount = $cunt['total'];
  echo "".$totalcount.",";
}?>]
        },
        {
            name: 'Total amount',
            data: [<?php 
$totalpay = mysqli_query($new,"SELECT sum(amount) as amount FROM stud_payment WHERE s_code = '$s_code' and indexNumber != ''");
 while($payment = mysqli_fetch_array($totalpay)){
 $money = $payment['amount'];
 echo "".$money.",";
}
?>]
        }
    ]
});
</script>
 -->

<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/apexcharts/apexcharts.min.js"></script>

<script src="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="assets/libs/admin-resources/jquery.vectormap/maps/jquery-jvectormap-world-mill-en.js"></script>

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

</body>

</html>
<?php } }?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: index.php

Server Info

System Features

User Info