V1rus Private

Viewing: admin.php

<?php
$page_title = 'Dashboard - Inventory System';
require_once('includes/load.php');
page_require_level(1);

// Get current store
$current_store_id = get_current_store_id();
$current_store_name = get_current_store_name();
$today = date('Y-m-d');

// Calculate today's financial data
global $db;

// Get opening balance (yesterday's closing)
$yesterday = date('Y-m-d', strtotime('-1 day'));
$opening_sql = "SELECT SUM(total) as yesterday_sales 
                FROM sales 
                WHERE store_id = '{$current_store_id}' 
                AND DATE(date) = '{$yesterday}'";
$opening_result = $db->query($opening_sql);
$yesterday_sales = $opening_result ? ($opening_result->fetch_assoc()['yesterday_sales'] ?? 0) : 0;

// For demo purposes, using yesterday's sales as opening balance
// In real scenario, you would have a proper opening balance system
$opening_balance = $yesterday_sales;

// Get inward value (products added today)
$inward_sql = "SELECT SUM(sale_price * quantity) as inward_value 
               FROM products 
               WHERE store_id = '{$current_store_id}' 
               AND DATE(date) = '{$today}'";
$inward_result = $db->query($inward_sql);
$inward_value = $inward_result ? ($inward_result->fetch_assoc()['inward_value'] ?? 0) : 0;

// Get actual sale value (regular sales today)
$sales_sql = "SELECT SUM(total) as actual_sale_value 
              FROM sales 
              WHERE store_id = '{$current_store_id}' 
              AND DATE(date) = '{$today}'
              AND is_transferred_out = 0";
$sales_result = $db->query($sales_sql);
$actual_sale_value = $sales_result ? ($sales_result->fetch_assoc()['actual_sale_value'] ?? 0) : 0;

// Get transferred stock value IN (products marked as transferred today)
$transferred_in_sql = "SELECT SUM(sale_price * quantity) as transferred_in_value 
                       FROM products 
                       WHERE store_id = '{$current_store_id}' 
                       AND DATE(date) = '{$today}'
                       AND is_transferred = 1";
$transferred_in_result = $db->query($transferred_in_sql);
$transferred_in_value = $transferred_in_result ? ($transferred_in_result->fetch_assoc()['transferred_in_value'] ?? 0) : 0;

// Get transferred stock value OUT (transferred out sales today)
$transferred_out_sql = "SELECT SUM(total) as transferred_out_value 
                        FROM sales 
                        WHERE store_id = '{$current_store_id}' 
                        AND DATE(date) = '{$today}'
                        AND is_transferred_out = 1";
$transferred_out_result = $db->query($transferred_out_sql);
$transferred_out_value = $transferred_out_result ? ($transferred_out_result->fetch_assoc()['transferred_out_value'] ?? 0) : 0;

// Get online payment (online sales today)
$online_sql = "SELECT SUM(total) as online_payment 
               FROM sales 
               WHERE store_id = '{$current_store_id}' 
               AND DATE(date) = '{$today}'
               AND payment_type = 'online'";
$online_result = $db->query($online_sql);
$online_payment = $online_result ? ($online_result->fetch_assoc()['online_payment'] ?? 0) : 0;

// Get expense (from ledger table today)
$expense_sql = "SELECT SUM(amount) as expense 
                FROM ledger 
                WHERE store_id = '{$current_store_id}' 
                AND DATE(date) = '{$today}'
                AND type = 'expense'";
$expense_result = $db->query($expense_sql);
$expense = $expense_result ? ($expense_result->fetch_assoc()['expense'] ?? 0) : 0;

// Calculate closing balance (Night Cash)
$closing_balance = $opening_balance + $actual_sale_value + $transferred_in_value - $transferred_out_value - $expense;
?>

<?php include_once('layouts/header.php'); ?>

<div class="row">
    <div class="col-md-12">
        <?php echo display_msg($msg); ?>
    </div>
</div>

<!-- Store Header -->
<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading text-center">
                <strong>
                    <span class="glyphicon glyphicon-dashboard"></span>
                    <span>Today's Financial Summary - <?php echo $current_store_name; ?></span>
                    <small class="text-muted">(<?php echo date('F j, Y'); ?>)</small>
                </strong>
            </div>
        </div>
    </div>
</div>

<!-- Today's Financial Summary -->
<div class="row">
    <!-- OPENING BALANCE -->
    <div class="col-md-3">
        <div class="panel panel-primary">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($opening_balance, 2); ?></div>
                        <div>OPENING BALANCE</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-time"></span>
                Start of Day
            </div>
        </div>
    </div>

    <!-- INWARD VALUE -->
    <div class="col-md-3">
        <div class="panel panel-info">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($inward_value, 2); ?></div>
                        <div>INWARD VALUE</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-arrow-down"></span>
                Products Added Today
            </div>
        </div>
    </div>

    <!-- ACTUAL SALE VALUE -->
    <div class="col-md-3">
        <div class="panel panel-success">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($actual_sale_value, 2); ?></div>
                        <div>ACTUAL SALE VALUE</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-shopping-cart"></span>
                Regular Sales
            </div>
        </div>
    </div>

    <!-- TRANSFERRED STOCK VALUE (IN) -->
    <div class="col-md-3">
        <div class="panel panel-warning">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($transferred_in_value, 2); ?></div>
                        <div>TRANSFERRED STOCK VALUE (IN)</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-log-in"></span>
                Transferred In Products
            </div>
        </div>
    </div>
</div>

<div class="row">
    <!-- TRANSFERRED STOCK VALUE (OUT) -->
    <div class="col-md-3">
        <div class="panel panel-warning">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($transferred_out_value, 2); ?></div>
                        <div>TRANSFERRED STOCK VALUE (OUT)</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-log-out"></span>
                Transferred Out Sales
            </div>
        </div>
    </div>

    <!-- CLOSING BALANCE -->
    <div class="col-md-3">
        <div class="panel panel-danger">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($closing_balance, 2); ?></div>
                        <div>CLOSING BALANCE</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-time"></span>
                Night Cash
            </div>
        </div>
    </div>

    <!-- ONLINE PAYMENT -->
    <div class="col-md-3">
        <div class="panel panel-info">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($online_payment, 2); ?></div>
                        <div>ONLINE PAYMENT</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-credit-card"></span>
                Digital Payments
            </div>
        </div>
    </div>

    <!-- EXPENSE -->
    <div class="col-md-3">
        <div class="panel panel-default">
            <div class="panel-heading text-center">
                <div class="row">
                    <div class="col-xs-12">
                        <div class="huge">₹<?php echo number_format($expense, 2); ?></div>
                        <div>EXPENSE</div>
                    </div>
                </div>
            </div>
            <div class="panel-footer text-center">
                <span class="glyphicon glyphicon-minus"></span>
                Today's Expenses
            </div>
        </div>
    </div>
</div>

<!-- Quick Summary -->
<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading text-center">
                <strong>
                    <span class="glyphicon glyphicon-stats"></span>
                    <span>Today's Quick Summary</span>
                </strong>
            </div>
            <div class="panel-body">
                <div class="row text-center">
                    <div class="col-md-3">
                        <div class="well">
                            <h4>Net Cash Flow</h4>
                            <h3 class="text-<?php echo ($actual_sale_value - $expense) >= 0 ? 'success' : 'danger'; ?>">
                                ₹<?php echo number_format($actual_sale_value - $expense, 2); ?>
                            </h3>
                            <small>Sales - Expenses</small>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="well">
                            <h4>Stock Movement</h4>
                            <h3 class="text-info">
                                ₹<?php echo number_format($inward_value + $transferred_in_value - $transferred_out_value, 2); ?>
                            </h3>
                            <small>Inward - Outward</small>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="well">
                            <h4>Total Transactions</h4>
                            <h3 class="text-primary">
                                <?php 
                                $total_sales_sql = "SELECT COUNT(*) as total FROM sales WHERE store_id = '{$current_store_id}' AND DATE(date) = '{$today}'";
                                $total_sales_result = $db->query($total_sales_sql);
                                $total_transactions = $total_sales_result ? $total_sales_result->fetch_assoc()['total'] : 0;
                                echo $total_transactions;
                                ?>
                            </h3>
                            <small>Today's Sales Count</small>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="well">
                            <h4>Cash in Hand</h4>
                            <h3 class="text-success">
                                ₹<?php echo number_format($actual_sale_value - $online_payment - $expense, 2); ?>
                            </h3>
                            <small>Physical Cash</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Quick Actions -->
<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading text-center">
                <strong>
                    <span class="glyphicon glyphicon-flash"></span>
                    <span>Quick Actions</span>
                </strong>
            </div>
            <div class="panel-body text-center">
                <a href="add_sale.php" class="btn btn-success btn-lg">
                    <span class="glyphicon glyphicon-plus"></span> Add Sale
                </a>
                <a href="add_product.php" class="btn btn-primary btn-lg">
                    <span class="glyphicon glyphicon-plus"></span> Add Product
                </a>
                <a href="sales.php" class="btn btn-info btn-lg">
                    <span class="glyphicon glyphicon-list"></span> View All Sales
                </a>
                <a href="sales_report.php" class="btn btn-warning btn-lg">
                    <span class="glyphicon glyphicon-report"></span> Generate Report
                </a>
            </div>
        </div>
    </div>
</div>

<style>
.huge {
    font-size: 30px;
    font-weight: bold;
}
.panel-heading {
    padding: 15px 10px;
}
.panel-footer {
    padding: 10px;
    font-size: 12px;
}
.well {
    background: #f8f9fa;
    border: 1px solid #dee2e6;
    border-radius: 5px;
    padding: 15px;
}
.well h4 {
    margin-top: 0;
    color: #495057;
}
.well h3 {
    margin: 10px 0;
}
</style>

<?php include_once('layouts/footer.php'); ?>
User / IP	: 216.73.217.108
Host / Server	: 190.92.174.125 / aerosofthealthcare.com
System	: Linux s3739.bom1.stableserver.net 4.18.0-513.24.1.lve.2.el8.x86_64 #1 SMP Fri May 24 12:42:50 UTC 2024 x86_64