????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................<?php
ob_start();
include('session.php');
include 'connection.php';

$userId = $_SESSION['userid'];

// Total Admission for logged in user
$total_admissions_overall = 0;
$resCount = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE addedby = '$userId'");
if ($resCount) { $total_admissions_overall = (int)$resCount->fetch_assoc()['cnt']; }

// Admissions Today for logged in user
$today_admissions = 0;
$resToday = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE DATE(created_at) = CURDATE() AND addedby = '$userId'");
if ($resToday) { $today_admissions = (int)$resToday->fetch_assoc()['cnt']; }

// Admissions in Last 7 Days for logged in user
$last7_admissions = 0;
$res7 = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND addedby = '$userId'");
if ($res7) { $last7_admissions = (int)$res7->fetch_assoc()['cnt']; }

// Admissions in Last 30 Days for logged in user
$last30_admissions = 0;
$res30 = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND addedby = '$userId'");
if ($res30) { $last30_admissions = (int)$res30->fetch_assoc()['cnt']; }

// Fee Report SQL Start Here
// Totals for logged in user records (fees with addedby, accounts without)
$summaryall = ['total_received' => 0, 'total_due' => 0];
$summary_sql = "
    SELECT 
        (SELECT COALESCE(SUM(received_amount), 0) 
         FROM fees 
         WHERE addedby = '$userId') AS total_received,
        (SELECT COALESCE(SUM(due_amount), 0) 
         FROM accounts) AS total_due";

if ($res = $conn->query($summary_sql)) {
    if ($row = $res->fetch_assoc()) {
        $summaryall = $row;
    }
}

// Totals FEE Course Amount (no addedby filter for accounts table)
$summarytotal = ['total_fees' => 0, 'total_due' => 0];
$summary_sql = "
   SELECT 
        COALESCE(SUM(total_fee), 0) AS total_fees
    FROM (
        SELECT admission_no, total_fee
        FROM fees
        WHERE addedby = '$userId'
        GROUP BY admission_no
    ) AS unique_fees,
        (SELECT COALESCE(SUM(due_amount), 0) 
         FROM accounts) AS total_due";

if ($res = $conn->query($summary_sql)) {
    if ($row = $res->fetch_assoc()) {
        $summarytotal = $row;
    }
}

// For last 30 days received amount for logged in user
$summary30all = ['today_received' => 0, 'total_received' => 0];
$last30From = date('Y-m-d', strtotime('-29 days'));
$todayDate = date('Y-m-d');

// Today received for logged in user
$today_sql = "SELECT COALESCE(SUM(received_amount), 0) AS total_today
              FROM fees
              WHERE payment_date = '$todayDate' AND addedby = '$userId'";
if ($resT = $conn->query($today_sql)) {
    if ($rowT = $resT->fetch_assoc()) {
        $summary30all['today_received'] = $rowT['total_today'];
    }
}

// Total received in last 30 days for logged in user
$total30_sql = "SELECT COALESCE(SUM(received_amount), 0) AS total_received
                FROM fees
                WHERE payment_date >= '$last30From' AND addedby = '$userId'";
if ($res30 = $conn->query($total30_sql)) {
    if ($row30 = $res30->fetch_assoc()) {
        $summary30all['total_received'] = $row30['total_received'];
    }
}

// Query 2: Total due for logged in user
$summaryd = ['total_received' => 0, 'due_amount' => 0];
$due_sql = "SELECT 
        COALESCE(SUM(due_amount), 0) AS due_amount
    FROM (
        SELECT admission_no, due_amount
        FROM fees
        WHERE addedby = '$userId'
        GROUP BY admission_no
    ) AS unique_fees ";
if ($res2 = $conn->query($due_sql)) {
    if ($row2 = $res2->fetch_assoc()) {
        $summaryd['due_amount'] = $row2['due_amount'];
    }
}

// Query 2: Total due from accounts (no addedby filter)
$summaryd = ['total_received' => 0, 'total_due' => 0];
$due_sql = "SELECT COALESCE(SUM(f.due_amount), 0) AS total_due
    FROM fees f
    INNER JOIN (
        SELECT admission_no, MAX(created_at) AS latest_created
        FROM fees
        WHERE addedby = '$userId'
        GROUP BY admission_no
    ) latest_fees 
    ON f.admission_no = latest_fees.admission_no AND f.created_at = latest_fees.latest_created
    WHERE f.addedby = '$userId'";
if ($res2 = $conn->query($due_sql)) {
    if ($row2 = $res2->fetch_assoc()) {
        $summaryd['total_due'] = $row2['total_due'];
    }
}

// Totals: Today and last 7 days for logged in user
$summary7all = ['today_received' => 0, 'total_received' => 0];
$last7From = date('Y-m-d', strtotime('-6 days'));

// Today received for logged in user
$today_sql = "SELECT COALESCE(SUM(received_amount), 0) AS total_today
              FROM fees
              WHERE payment_date = '$todayDate' AND addedby = '$userId'";
if ($resT = $conn->query($today_sql)) {
    if ($rowT = $resT->fetch_assoc()) {
        $summary7all['today_received'] = $rowT['total_today'];
    }
}

// Last 7 days received for logged in user
$received_sql = "SELECT COALESCE(SUM(received_amount), 0) AS total_received
                 FROM fees
                 WHERE payment_date >= '$last7From' AND addedby = '$userId'";
if ($res1 = $conn->query($received_sql)) {
    if ($row1 = $res1->fetch_assoc()) {
        $summary7all['total_received'] = $row1['total_received'];
    }
}

// Expense Report for logged in user
$total_expenses = 0;
$check_total_sql = "SELECT COUNT(*) as total_count FROM expenses WHERE addedby = '$userId'";
$check_result = mysqli_query($conn, $check_total_sql);
if ($check_result) {
    $total_expenses = mysqli_fetch_assoc($check_result)['total_count'];
}

// Total amount for logged in user
$total_amount_sql = "SELECT SUM(amount) as total FROM expenses WHERE addedby = '$userId'";
$total_result = mysqli_query($conn, $total_amount_sql);
$total_amount = mysqli_fetch_assoc($total_result)['total'] ?? 0;

// Today's Expenses for logged in user
$today_sql = "SELECT SUM(amount) as today FROM expenses WHERE DATE(date) = CURDATE() AND addedby = '$userId'";
$today_result = mysqli_query($conn, $today_sql);
$today_amount = mysqli_fetch_assoc($today_result)['today'] ?? 0;

// Last 7 Days Expenses for logged in user
$last_7_days_sql = "SELECT SUM(amount) as week FROM expenses WHERE date >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND addedby = '$userId'";
$last_7_days_result = mysqli_query($conn, $last_7_days_sql);
$last_7_days_amount = mysqli_fetch_assoc($last_7_days_result)['week'] ?? 0;

// Last Month Expenses for logged in user
$last_month_sql = "SELECT SUM(amount) as month FROM expenses WHERE date >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND addedby = '$userId'";
$last_month_result = mysqli_query($conn, $last_month_sql);
$last_month_amount = mysqli_fetch_assoc($last_month_result)['month'] ?? 0;

 

?>



<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Dashboard | Xcel Technical Institute</title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" href="../images/favicon.png">
    <!-- Base Styling  -->
    <link rel="stylesheet" href="assets/main/css/fonts.css">
    <link rel="stylesheet" href="assets/main/css/style.css">
    <script src="https://code.jquery.com/jquery-3.6.4.min.js" integrity="sha256-oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl+cbzUq8=" crossorigin="anonymous"></script>

    <style>



.order-card {
    color: #fff;
}

.c-blue {
    background: linear-gradient(45deg,#4099ff,#73b4ff);
}

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

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

.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;
}



 .summary-row{ display:flex; gap:12px; flex-wrap:wrap; margin-bottom:12px; }
        .summary-box{ background:#e9ecef;padding:15px;border-radius:6px;min-width:220px; border:1px solid #dee2e6; }
        .summary-title{ font-weight:600;color:#000000;margin-bottom:6px; }
        .summary-value{ font-size:18px;color:#fff; }

    

    .card {
    border: none;
    border-radius: 8px;
    box-shadow: 0 0.15rem 1.75rem 0 rgba(58, 59, 69, 0.15);
}
.card-body {
    padding: 1.25rem;
}
.card-title {
    margin-bottom: 0.5rem;
    font-size: 0.9rem;
    font-weight: bold;
    text-transform: uppercase;
}
</style>
</head>

<body>
    <div id="main-wrapper" class="show">


      <?php
         include "sidebar.php";
         ?>


         <?php
         include "header.php";
         ?>


        <!-- start section content -->
        <div class="content-body">
            <div class="warper container-fluid">
                <div class="row page-titles mx-0">
                    <div class="col-lg-12 p-md-0">
                        <h4 class="text-primary"><span class="names">Welcome to Invoice Panel</span></h4>
                        <h6 class="mb-0">Xcel</h6>
                    </div>
                </div>
                <div class="new-patients main_container">
                    
                    
                               
<div class="container">
    <div class="row">
        <h1>Dashboard </h1>
       
                                <h3 style="margin-bottom: 16px; margin-top: 16px;">Admission Report</h3>

         <div class="summary-row">
         <a href="admission.php" style="text-decoration: none;">
    <div class="summary-box" style="
        background-color: #f6c23e;
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <div class="summary-title" style="color: #000;">Your Total Admissions</div>
        <div class="summary-value" style="color: #000000;">
            <?php echo (int)$total_admissions_overall; ?>
        </div>
    </div>
</a>

<a href="admission.php" style="text-decoration: none;">
                                    <div class="summary-box" style="
        background-color: #1cc88a; 
        /* color: white;  */
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <div class="summary-title">Admissions Today</div>
        <div class="summary-value" style="color:#000000;"><?php echo (int)$today_admissions; ?></div>
    </div>
</a>

<a href="admission.php" style="text-decoration: none;">
    <div class="summary-box" style="
        background-color: #f6c23e; 
        /* color: white;  */
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <div class="summary-title">Last 7 Days</div>
        <div class="summary-value" style="color:#000000;"><?php echo (int)$last7_admissions; ?></div>
    </div>
</a>


<a href="admission.php" style="text-decoration: none;">
    <div class="summary-box" style="
        background-color: #1cc88a; 
        /* color: white;  */
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <div class="summary-title">Last 30 Days</div>
        <div class="summary-value" style="color:#000000;"><?php echo (int)$last30_admissions; ?></div>
    </div>
</a>

      
                                </div>


                                <!-- Fee Report -->

                                <h3 style="margin-bottom: 16px; margin-top: 16px;">Fee Report</h3>

                                 <div class="row" style="margin-bottom: 15px;">
                                    
                                 <div class="col-md-3">
    <a href="fee-report.php" style="text-decoration: none; color: inherit;">
        <div class="summary-box" style="
            background-color: #f6c23e;
            padding: 20px; 
            border-radius: 10px; 
            box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
        ">
            <h5 style="margin: 0 0 12px 0; font-weight: 600;">Totals</h5>
            <div>Total Fees: <strong>₹<?php echo number_format((float)$summarytotal['total_fees'], 2); ?></strong></div>
            <div>Received: <strong>₹<?php echo number_format((float)$summaryall['total_received'], 2); ?></strong></div>
            <!-- <div>Due: <strong>₹<?php echo number_format((float)$summaryall['total_due'], 2); ?></strong></div> -->
        </div>
    </a>
</div>


                                        <div class="col-md-3">
                                        <a href="fee-report.php" style="text-decoration: none; color: inherit;">
    <div class="summary-box" style="
        background-color: #1cc88a;
        /* color: white;  */
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <h5 style="margin: 0 0 12px 0; font-weight: 600;">Last 30days</h5>
        <div>Received: <strong>₹<?php echo number_format((float)$summary30all['total_received'], 2); ?></strong></div>
         <div>Total Due: <strong>₹<?php echo number_format((float)$summaryd['total_due'], 2); ?></strong></div>
    </div>
                                        </a>
</div>


                                        <div class="col-md-3">
                                        <a href="fee-report.php" style="text-decoration: none; color: inherit;">
    <div class="summary-box" style="
        background-color: #f6c23e;
        /* color: white;  */
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <h5 style="margin: 0 0 12px 0; font-weight: 600;">Last 7days</h5>
        <div>Received: <strong>₹<?php echo number_format((float)$summary7all['total_received'], 2); ?></strong></div>
         <div>Total Due: <strong>₹<?php echo number_format((float)$summaryd['total_due'], 2); ?></strong></div>
    </div>
                                        </a>
</div>

                                        <div class="col-md-3">
                                        <a href="fee-report.php" style="text-decoration: none; color: inherit;">

    <div class="summary-box" style="
        background-color: #1cc88a;
        /* color: white;  */
        padding: 20px; 
        border-radius: 10px; 
        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);
    ">
        <h5 style="margin: 0 0 12px 0; font-weight: 600;">Today</h5>
        <div>Received: <strong>₹<?php echo number_format((float)$summary7all['today_received'], 2); ?></strong></div>
         <div>Total Due: <strong>₹<?php echo number_format((float)$summaryd['total_due'], 2); ?></strong></div>
    </div>
    </a>
</div>

                                    </div>
                                 

 



                                    <!-- Expenses -->
                                <h3 style="margin-bottom: 16px; margin-top: 16px;">Expense Report</h3>

                                <div class="col-xl-3 col-lg-6 col-md-6 mb-3">
    <a href="expense.php" style="text-decoration: none; color: inherit;">
        <div class="card" style="background-color: #f6c23e;">
            <div class="card-body">
                <h5 class="card-title">Total Expenses</h5>
                <h6 class="mb-0" style="color:#000000">₹<?php echo number_format($total_amount, 2); ?></h6>
            </div>
        </div>
    </a>
</div>

        
        <!-- Today's Expenses -->
        <div class="col-xl-3 col-lg-6 col-md-6 mb-3">
        <a href="expense.php" style="text-decoration: none; color: inherit;">
            <div class="card" style="background-color: #1cc88a;">
                <div class="card-body">
                    <h5 class="card-title">Today's Expenses</h5>
                    <h6 class="mb-0" style="color:#000000">₹<?php echo number_format($today_amount, 2); ?></h6>
                </div>
            </div>
        </a>
        </div>
        
        <!-- Last 7 Days -->
        <div class="col-xl-3 col-lg-6 col-md-6 mb-3">
        <a href="expense.php" style="text-decoration: none; color: inherit;">
            <div class="card" style="background-color: #f6c23e;">
                <div class="card-body">
                    <h5 class="card-title">Last 7 Days</h5>
                    <h6 class="mb-0" style="color:#000000">₹<?php echo number_format($last_7_days_amount, 2); ?></h6>
                </div>
            </div>
        </a>
        </div>
        
        <!-- Last Month -->
        <div class="col-xl-3 col-lg-6 col-md-6 mb-3">
        <a href="expense.php" style="text-decoration: none; color: inherit;">
            <div class="card" style="background-color: #1cc88a;">
                <div class="card-body">
                    <h5 class="card-title">Last 30 Days</h5>
                    <h6 class="mb-0" style="color:#000000">₹<?php echo number_format($last_month_amount, 2); ?></h6>
                </div>
            </div>
        </a>
        </div>
                                     
      
    
	</div>
</div>
        
            </div>
        </div>
        <!-- End section content -->


        <?php
   include('footer.php');
?>


    </div>
    <script type="text/javascript">
    $(".remove").click(function(){
        var idk = $(this).parents("tr").attr("id");
        console.log(idk);

        if(confirm('Are you sure to remove this record ?'))
        {
            $.get("home.php?idk="+idk, function(data, status){
               $("#"+idk).remove();
                    alert("Record removed successfully");  
        });
            
        }
    });


</script>

    

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.js"></script>

    <!-- Moment -->
    <script src="assets/plugins/moment/moment.min.js"></script>

    <!-- Date Range Picker -->
    <script src="assets/plugins/daterangepicker/daterangepicker.min.js"></script>

    <!-- Datatable -->
    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="assets/js/init-tdatatable.js"></script>

    <!-- Chart js -->
    <script src="assets/plugins/chart/chart/Chart.min.js"></script>
    <script src="assets/js/charts-custom.js"></script>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

</body>
</html>