<?php
/**
 * Dashboard - Main dashboard for all user roles
 */

require_once __DIR__ . '/config/database.php';
require_once __DIR__ . '/config/settings.php';
require_once __DIR__ . '/includes/functions.php';

startSession();
requireLogin();

$user_id = $_SESSION['user_id'];
$role = $_SESSION['role'];
$full_name = $_SESSION['full_name'];

try {
    $conn = getDbConnection();
    
    if ($role === 'supplier') {
        // SUPPLIER DASHBOARD - Fixed calculation with subqueries
        
        // Get total supply - all time
        $sql = "SELECT COALESCE(SUM(total_amount), 0) as total_supply,
                       COUNT(*) as supply_count
                FROM supply 
                WHERE supplier_id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $user_id);
        $stmt->execute();
        $result = $stmt->get_result();
        $supply_stats = $result->fetch_assoc();
        
        // Get total payments received - all time - FIXED with direct query
        $sql = "SELECT COALESCE(SUM(amount), 0) as total_paid,
                       COUNT(*) as payment_count
                FROM payment_settlements 
                WHERE supplier_id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $user_id);
        $stmt->execute();
        $result = $stmt->get_result();
        $payment_stats = $result->fetch_assoc();
        
        // Calculate pending
        $pending_amount = $supply_stats['total_supply'] - $payment_stats['total_paid'];
        
        // Get recent supplies
        $sql = "SELECT s.*, f.fish_name, f.fish_name_tamil
                FROM supply s
                LEFT JOIN fish_types f ON s.fish_id = f.fish_id
                WHERE s.supplier_id = ?
                ORDER BY s.created_at DESC
                LIMIT 5";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $user_id);
        $stmt->execute();
        $result = $stmt->get_result();
        
        $recent_supplies = [];
        while ($row = $result->fetch_assoc()) {
            $recent_supplies[] = $row;
        }
        
    } elseif ($role === 'manager' || $role === 'admin') {
        // ADMIN/MANAGER DASHBOARD
        
        // Get today's sales
        $sql = "SELECT COALESCE(SUM(total_amount), 0) as today_sales,
                       COUNT(*) as sale_count
                FROM sales 
                WHERE DATE(sale_date) = CURDATE()";
        $result = $conn->query($sql);
        $today_sales = $result->fetch_assoc();
        
        // Get this month's sales
        $sql = "SELECT COALESCE(SUM(total_amount), 0) as month_sales
                FROM sales 
                WHERE MONTH(sale_date) = MONTH(CURDATE()) 
                AND YEAR(sale_date) = YEAR(CURDATE())";
        $result = $conn->query($sql);
        $month_sales = $result->fetch_assoc();
        
        // Get pending payments - FIXED with subqueries
        $sql = "SELECT COUNT(*) as supplier_count,
                       COALESCE(SUM(pending), 0) as total_pending
                FROM (
                    SELECT 
                        u.user_id,
                        COALESCE((SELECT SUM(total_amount) FROM supply WHERE supplier_id = u.user_id), 0) - 
                        COALESCE((SELECT SUM(amount) FROM payment_settlements WHERE supplier_id = u.user_id), 0) as pending
                    FROM users u
                    WHERE u.role = 'supplier' AND u.status = 'active'
                ) as pending_calc
                WHERE pending > 0";
        $result = $conn->query($sql);
        $pending_payments = $result->fetch_assoc();
        
        // Get total supply cost this month
        $sql = "SELECT COALESCE(SUM(total_amount), 0) as month_supply
                FROM supply 
                WHERE MONTH(supply_date) = MONTH(CURDATE()) 
                AND YEAR(supply_date) = YEAR(CURDATE())";
        $result = $conn->query($sql);
        $month_supply = $result->fetch_assoc();
        
        // Get total expenses this month
        $sql = "SELECT COALESCE(SUM(total_amount), 0) as month_expenses
                FROM expenses 
                WHERE MONTH(expense_date) = MONTH(CURDATE()) 
                AND YEAR(expense_date) = YEAR(CURDATE())";
        $result = $conn->query($sql);
        $month_expenses = $result->fetch_assoc();
        
        // Calculate profit
        $month_profit = $month_sales['month_sales'] - $month_supply['month_supply'] - $month_expenses['month_expenses'];
        
        // Get recent activity
        $sql = "SELECT * FROM activity_logs 
                ORDER BY created_at DESC 
                LIMIT 10";
        $result = $conn->query($sql);
        
        $recent_activity = [];
        while ($row = $result->fetch_assoc()) {
            $recent_activity[] = $row;
        }
    }
    
    // Get recent activity for current user
    $sql = "SELECT * FROM activity_logs 
            WHERE user_id = ?
            ORDER BY created_at DESC 
            LIMIT 10";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    $user_activity = [];
    while ($row = $result->fetch_assoc()) {
        $user_activity[] = $row;
    }
    
} catch (Exception $e) {
    $error = "Error loading dashboard: " . $e->getMessage();
}

$page_title = 'Dashboard';
require_once __DIR__ . '/includes/header.php';
?>

<h1 class="page-title">🏠 Dashboard</h1>

<?php if (isset($error)): ?>
<div class="alert alert-error"><?php echo htmlspecialchars($error); ?></div>
<?php endif; ?>

<?php if ($role === 'supplier'): ?>
<!-- SUPPLIER DASHBOARD -->

<!-- Main Statistics -->
<div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(300px, 1fr)); gap: 1.5rem; margin-bottom: 2rem;">
    <div class="stat-card" style="background: linear-gradient(135deg, #28a745, #218838);">
        <div class="stat-label">My Total Supply</div>
        <div class="stat-value">₹<?php echo number_format($supply_stats['total_supply'], 2); ?></div>
        <div class="stat-info">All time total</div>
    </div>
    
    <div class="stat-card" style="background: linear-gradient(135deg, #dc3545, #c82333);">
        <div class="stat-label">My Pending Payment</div>
        <div class="stat-value">₹<?php echo number_format($pending_amount, 2); ?></div>
        <div class="stat-info">Amount owed to me</div>
    </div>
</div>

<!-- Quick Actions -->
<div class="card">
    <h2 class="card-title">Quick Actions</h2>
    <div style="display: flex; gap: 1rem; flex-wrap: wrap;">
        <a href="/supply/add_supply.php" class="btn btn-primary">📦 Add Supply</a>
        <a href="/supply/view_supplies.php" class="btn btn-info">📋 View My Supplies</a>
        <a href="/reports/user_report.php" class="btn btn-secondary">📊 My Report</a>
    </div>
</div>

<!-- Recent Supplies -->
<?php if (!empty($recent_supplies)): ?>
<div class="card">
    <h2 class="card-title">Recent Activity</h2>
    <div class="table-responsive">
        <table>
            <thead>
                <tr>
                    <th>Action</th>
                    <th>Table</th>
                    <th>Time</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($user_activity as $activity): ?>
                <tr>
                    <td><?php echo htmlspecialchars($activity['action']); ?></td>
                    <td><?php echo htmlspecialchars($activity['table_name'] ?? '-'); ?></td>
                    <td><?php echo date('d-m-Y H:i', strtotime($activity['created_at'])); ?></td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    </div>
</div>
<?php endif; ?>

<?php elseif ($role === 'manager' || $role === 'admin'): ?>
<!-- ADMIN/MANAGER DASHBOARD -->

<!-- Today's Summary -->
<div class="card" style="background: linear-gradient(135deg, #17a2b8, #138496); color: white; margin-bottom: 2rem;">
    <h2 style="color: white; margin-top: 0;">📅 Today's Sales</h2>
    <div style="font-size: 3rem; font-weight: 700; margin: 1rem 0;">
        ₹<?php echo number_format($today_sales['today_sales'], 2); ?>
    </div>
    <p style="opacity: 0.9; margin: 0;"><?php echo $today_sales['sale_count']; ?> transactions today</p>
</div>

<!-- Monthly Statistics -->
<div class="stats-grid">
    <div class="stat-card" style="background: linear-gradient(135deg, #28a745, #218838);">
        <div class="stat-label">This Month's Sales</div>
        <div class="stat-value">₹<?php echo number_format($month_sales['month_sales'], 2); ?></div>
        <div class="stat-info">Total revenue</div>
    </div>
    
    <div class="stat-card" style="background: linear-gradient(135deg, #17a2b8, #138496);">
        <div class="stat-label">Supply Cost</div>
        <div class="stat-value">₹<?php echo number_format($month_supply['month_supply'], 2); ?></div>
        <div class="stat-info">This month</div>
    </div>
    
    <div class="stat-card" style="background: linear-gradient(135deg, #ffc107, #e0a800);">
        <div class="stat-label">Expenses</div>
        <div class="stat-value">₹<?php echo number_format($month_expenses['month_expenses'], 2); ?></div>
        <div class="stat-info">This month</div>
    </div>
    
    <div class="stat-card" style="background: linear-gradient(135deg, <?php echo $month_profit >= 0 ? '#6f42c1, #5a32a3' : '#dc3545, #c82333'; ?>);">
        <div class="stat-label"><?php echo $month_profit >= 0 ? 'Profit' : 'Loss'; ?></div>
        <div class="stat-value">₹<?php echo number_format(abs($month_profit), 2); ?></div>
        <div class="stat-info">This month</div>
    </div>
</div>

<!-- Pending Payments Alert -->
<?php if ($pending_payments['total_pending'] > 0): ?>
<div class="card" style="background: #fff3cd; border-left: 4px solid #ffc107;">
    <h3 style="margin-top: 0; color: #856404;">⚠️ Pending Supplier Payments</h3>
    <div style="display: flex; justify-content: space-between; align-items: center;">
        <div>
            <p style="margin: 0; color: #856404;">
                <strong><?php echo $pending_payments['supplier_count']; ?> suppliers</strong> have pending payments totaling 
                <strong style="font-size: 1.25rem; color: #dc3545;">₹<?php echo number_format($pending_payments['total_pending'], 2); ?></strong>
            </p>
        </div>
        <a href="/supply/pending_payments.php" class="btn btn-warning">View Pending Payments</a>
    </div>
</div>
<?php endif; ?>

<!-- Quick Actions -->
<div class="card">
    <h2 class="card-title">Quick Actions</h2>
    <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 1rem;">
        <a href="/sales/add_sale.php" class="btn btn-success">💰 Add Sale</a>
        <a href="/supply/add_supply.php" class="btn btn-primary">📦 Add Supply</a>
        <a href="/expenses/add_expense.php" class="btn btn-warning">💸 Add Expense</a>
        <a href="/supply/pending_payments.php" class="btn btn-danger">💵 Settle Payment</a>
        <a href="/reports/user_report.php" class="btn btn-info">📊 View Reports</a>
        <?php if ($role === 'admin'): ?>
        <a href="/users/add_user.php" class="btn btn-secondary">👤 Add User</a>
        <?php endif; ?>
    </div>
</div>

<!-- Recent Activity -->
<?php if (!empty($recent_activity)): ?>
<div class="card">
    <h2 class="card-title">Recent Activity</h2>
    <div class="table-responsive">
        <table>
            <thead>
                <tr>
                    <th>Action</th>
                    <th>Table</th>
                    <th>Time</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($recent_activity as $activity): ?>
                <tr>
                    <td><?php echo htmlspecialchars($activity['action']); ?></td>
                    <td><?php echo htmlspecialchars($activity['table_name'] ?? '-'); ?></td>
                    <td><?php echo date('d-m-Y H:i', strtotime($activity['created_at'])); ?></td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    </div>
</div>
<?php endif; ?>

<?php endif; ?>

<?php require_once __DIR__ . '/includes/footer.php'; ?>