Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/vkmobiles/admin

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: reports-purchases.php

<!doctype html>
<html lang="en">

<?php include('includes/head.php')?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

<?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<?php
                // Include database connection
                include('includes/db.php');

// Set default date range (last 30 days)
                $end_date = date('Y-m-d');
                $start_date = date('Y-m-d', strtotime('-30 days'));

// Get filter parameters
                $report_type = isset($_GET['report_type']) ? $_GET['report_type'] : 'monthly';
                $start_date = isset($_GET['start_date']) ? $_GET['start_date'] : $start_date;
                $end_date = isset($_GET['end_date']) ? $_GET['end_date'] : $end_date;
                $supplier_id = isset($_GET['supplier_id']) ? intval($_GET['supplier_id']) : 0;
                $status = isset($_GET['status']) ? $_GET['status'] : '';

// Build WHERE conditions for queries
                $where_conditions = array();
                $params = array();
                $param_types = '';

// Date range filter
                $where_conditions[] = "order_date BETWEEN ? AND ?";
                $params[] = $start_date;
                $params[] = $end_date;
                $param_types .= 'ss';

// Supplier filter
                if ($supplier_id > 0) {
                    $where_conditions[] = "supplier_id = ?";
                    $params[] = $supplier_id;
                    $param_types .= 'i';
                }

// Status filter
                if (!empty($status)) {
                    $where_conditions[] = "status = ?";
                    $params[] = $status;
                    $param_types .= 's';
                }

$where_sql = !empty($where_conditions) ? "WHERE " . implode(" AND ", $where_conditions) : "";
                ?>

<div class="row">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_orders_sql = "SELECT COUNT(*) as total_orders FROM purchase_orders $where_sql";
                                            if (!empty($params)) {
                                                $stmt = $conn->prepare($total_orders_sql);
                                                $stmt->bind_param($param_types, ...$params);
                                                $stmt->execute();
                                                $result = $stmt->get_result();
                                            } else {
                                                $result = $conn->query($total_orders_sql);
                                            }
                                            echo $result->fetch_assoc()['total_orders'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Orders</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shopping-cart display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            ₹<?php
                                            $total_amount_sql = "SELECT COALESCE(SUM(total_amount), 0) as total_amount FROM purchase_orders $where_sql";
                                            if (!empty($params)) {
                                                $stmt = $conn->prepare($total_amount_sql);
                                                $stmt->bind_param($param_types, ...$params);
                                                $stmt->execute();
                                                $result = $stmt->get_result();
                                            } else {
                                                $result = $conn->query($total_amount_sql);
                                            }
                                            echo number_format($result->fetch_assoc()['total_amount'], 0);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Purchase Value</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-rupee-sign display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $avg_order_sql = "SELECT COALESCE(AVG(total_amount), 0) as avg_order FROM purchase_orders $where_sql AND total_amount > 0";
                                            if (!empty($params)) {
                                                $avg_order_sql = "SELECT COALESCE(AVG(total_amount), 0) as avg_order FROM purchase_orders $where_sql AND total_amount > 0";
                                                $stmt = $conn->prepare($avg_order_sql);
                                                $stmt->bind_param($param_types, ...$params);
                                                $stmt->execute();
                                                $result = $stmt->get_result();
                                            } else {
                                                $result = $conn->query($avg_order_sql);
                                            }
                                            echo '₹' . number_format($result->fetch_assoc()['avg_order'], 0);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Average Order Value</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-chart-line display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $top_supplier_sql = "SELECT s.name, COUNT(po.id) as order_count 
                                                               FROM purchase_orders po 
                                                               LEFT JOIN suppliers s ON po.supplier_id = s.id 
                                                               $where_sql 
                                                               GROUP BY po.supplier_id 
                                                               ORDER BY order_count DESC 
                                                               LIMIT 1";
                                            // Replace WHERE conditions for this specific query
                                            $top_where_sql = $where_sql;
                                            if (!empty($top_where_sql)) {
                                                $top_where_sql = str_replace("order_date", "po.order_date", $top_where_sql);
                                                $top_where_sql = str_replace("supplier_id", "po.supplier_id", $top_where_sql);
                                                $top_where_sql = str_replace("status", "po.status", $top_where_sql);
                                            }
                                            
                                            $top_supplier_sql = "SELECT s.name, COUNT(po.id) as order_count 
                                                               FROM purchase_orders po 
                                                               LEFT JOIN suppliers s ON po.supplier_id = s.id 
                                                               $top_where_sql 
                                                               GROUP BY po.supplier_id 
                                                               ORDER BY order_count DESC 
                                                               LIMIT 1";
                                            
                                            if (!empty($params)) {
                                                $stmt = $conn->prepare($top_supplier_sql);
                                                $stmt->bind_param($param_types, ...$params);
                                                $stmt->execute();
                                                $result = $stmt->get_result();
                                            } else {
                                                $result = $conn->query($top_supplier_sql);
                                            }
                                            $top_supplier = $result->fetch_assoc();
                                            echo $top_supplier ? $top_supplier['order_count'] : 0;
                                            ?>
                                        </h4>
                                        <p class="mb-0">Top Supplier Orders</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-trophy display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <?php if ($top_supplier): ?>
                                <div class="mt-2">
                                    <small><?php echo htmlspecialchars($top_supplier['name']); ?></small>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">Purchase Analytics & Reports</h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                            <i class="fas fa-file-excel me-2"></i>Export to Excel
                                        </button>
                                        <button type="button" class="btn btn-danger" onclick="window.print()">
                                            <i class="fas fa-print me-2"></i>Print Report
                                        </button>
                                        <a href="inventory-purchase.php" class="btn btn-outline-primary">
                                            <i class="fas fa-shopping-cart me-2"></i>Purchase Orders
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">
                                                    <i class="fas fa-filter me-2"></i>Report Filters
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <form method="GET" action="" id="reportFilters">
                                                    <div class="row">
                                                        <div class="col-md-3">
                                                            <div class="mb-3">
                                                                <label for="report_type" class="form-label">Report Type</label>
                                                                <select class="form-select" id="report_type" name="report_type">
                                                                    <option value="daily" <?php echo $report_type == 'daily' ? 'selected' : ''; ?>>Daily</option>
                                                                    <option value="weekly" <?php echo $report_type == 'weekly' ? 'selected' : ''; ?>>Weekly</option>
                                                                    <option value="monthly" <?php echo $report_type == 'monthly' ? 'selected' : ''; ?>>Monthly</option>
                                                                    <option value="quarterly" <?php echo $report_type == 'quarterly' ? 'selected' : ''; ?>>Quarterly</option>
                                                                    <option value="yearly" <?php echo $report_type == 'yearly' ? 'selected' : ''; ?>>Yearly</option>
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-2">
                                                            <div class="mb-3">
                                                                <label for="start_date" class="form-label">Start Date</label>
                                                                <input type="date" class="form-control" id="start_date" name="start_date" value="<?php echo $start_date; ?>">
                                                            </div>
                                                        </div>
                                                        <div class="col-md-2">
                                                            <div class="mb-3">
                                                                <label for="end_date" class="form-label">End Date</label>
                                                                <input type="date" class="form-control" id="end_date" name="end_date" value="<?php echo $end_date; ?>">
                                                            </div>
                                                        </div>
                                                        <div class="col-md-2">
                                                            <div class="mb-3">
                                                                <label for="supplier_id" class="form-label">Supplier</label>
                                                                <select class="form-select" id="supplier_id" name="supplier_id">
                                                                    <option value="">All Suppliers</option>
                                                                    <?php
                                                                    $suppliers_sql = "SELECT * FROM suppliers WHERE status = 'active' ORDER BY name";
                                                                    $suppliers_result = $conn->query($suppliers_sql);
                                                                    while($supplier = $suppliers_result->fetch_assoc()) {
                                                                        $selected = $supplier_id == $supplier['id'] ? 'selected' : '';
                                                                        echo '<option value="' . $supplier['id'] . '" ' . $selected . '>' . htmlspecialchars($supplier['name']) . '</option>';
                                                                    }
                                                                    ?>
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-2">
                                                            <div class="mb-3">
                                                                <label for="status" class="form-label">Status</label>
                                                                <select class="form-select" id="status1" name="status">
                                                                    <option value="">All Status</option>
                                                                    <option value="pending" <?php echo $status == 'pending' ? 'selected' : ''; ?>>Pending</option>
                                                                    <option value="shipped" <?php echo $status == 'shipped' ? 'selected' : ''; ?>>Shipped</option>
                                                                    <option value="completed" <?php echo $status == 'completed' ? 'selected' : ''; ?>>Completed</option>
                                                                    <option value="cancelled" <?php echo $status == 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-1">
                                                            <div class="mb-3">
                                                                <label class="form-label">&nbsp;</label>
                                                                <button type="submit" class="btn btn-primary w-100">
                                                                    <i class="fas fa-search"></i>
                                                                </button>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    
                                                    <div class="row">
                                                        <div class="col-12">
                                                            <div class="d-flex gap-2 flex-wrap">
                                                                <small class="text-muted me-2">Quick Filters:</small>
                                                                <button type="button" class="btn btn-sm btn-outline-secondary" onclick="setDateRange(7)">Last 7 Days</button>
                                                                <button type="button" class="btn btn-sm btn-outline-secondary" onclick="setDateRange(30)">Last 30 Days</button>
                                                                <button type="button" class="btn btn-sm btn-outline-secondary" onclick="setDateRange(90)">Last 90 Days</button>
                                                                <button type="button" class="btn btn-sm btn-outline-secondary" onclick="setDateRange(365)">Last Year</button>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">
                                                    <i class="fas fa-chart-bar me-2"></i>Monthly Purchase Trend
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-bordered table-hover">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Month</th>
                                                                <th>Number of Orders</th>
                                                                <th>Total Purchase Value</th>
                                                                <th>Average Order Value</th>
                                                                <th>Growth Rate</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            $monthly_trend_sql = "SELECT 
                                                                DATE_FORMAT(order_date, '%Y-%m') as month,
                                                                COUNT(*) as order_count,
                                                                COALESCE(SUM(total_amount), 0) as total_amount,
                                                                COALESCE(AVG(total_amount), 0) as avg_amount
                                                                FROM purchase_orders 
                                                                WHERE order_date BETWEEN ? AND ?
                                                                GROUP BY DATE_FORMAT(order_date, '%Y-%m')
                                                                ORDER BY month DESC
                                                                LIMIT 12";
                                                            
                                                            $stmt = $conn->prepare($monthly_trend_sql);
                                                            $stmt->bind_param('ss', $start_date, $end_date);
                                                            $stmt->execute();
                                                            $monthly_result = $stmt->get_result();
                                                            
                                                            $previous_amount = 0;
                                                            $first_row = true;
                                                            
                                                            while ($month = $monthly_result->fetch_assoc()) {
                                                                $growth_rate = 0;
                                                                if (!$first_row && $previous_amount > 0) {
                                                                    $growth_rate = (($month['total_amount'] - $previous_amount) / $previous_amount) * 100;
                                                                }
                                                                $previous_amount = $month['total_amount'];
                                                                $first_row = false;
                                                                
                                                                $growth_class = $growth_rate > 0 ? 'text-success' : ($growth_rate < 0 ? 'text-danger' : 'text-muted');
                                                                $growth_icon = $growth_rate > 0 ? 'fa-arrow-up' : ($growth_rate < 0 ? 'fa-arrow-down' : 'fa-minus');
                                                            ?>
                                                            <tr>
                                                                <td><strong><?php echo date('F Y', strtotime($month['month'] . '-01')); ?></strong></td>
                                                                <td><?php echo $month['order_count']; ?> orders</td>
                                                                <td><strong class="text-success">₹<?php echo number_format($month['total_amount'], 2); ?></strong></td>
                                                                <td>₹<?php echo number_format($month['avg_amount'], 2); ?></td>
                                                                <td class="<?php echo $growth_class; ?>">
                                                                    <i class="fas <?php echo $growth_icon; ?> me-1"></i>
                                                                    <?php echo number_format(abs($growth_rate), 1); ?>%
                                                                </td>
                                                            </tr>
                                                            <?php } ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-md-6">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">
                                                    <i class="fas fa-truck me-2"></i>Top Suppliers by Purchase Value
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-bordered table-hover">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Supplier</th>
                                                                <th>Orders</th>
                                                                <th>Total Value</th>
                                                                <th>Avg. Order</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            // Build supplier query with proper WHERE conditions
                                                            $supplier_where_sql = $where_sql;
                                                            if (!empty($supplier_where_sql)) {
                                                                $supplier_where_sql = str_replace("order_date", "po.order_date", $supplier_where_sql);
                                                                $supplier_where_sql = str_replace("supplier_id", "po.supplier_id", $supplier_where_sql);
                                                                $supplier_where_sql = str_replace("status", "po.status", $supplier_where_sql);
                                                            }
                                                            
                                                            $top_suppliers_sql = "SELECT 
                                                                s.name,
                                                                COUNT(po.id) as order_count,
                                                                COALESCE(SUM(po.total_amount), 0) as total_amount,
                                                                COALESCE(AVG(po.total_amount), 0) as avg_amount
                                                                FROM purchase_orders po
                                                                LEFT JOIN suppliers s ON po.supplier_id = s.id
                                                                $supplier_where_sql
                                                                GROUP BY po.supplier_id
                                                                ORDER BY total_amount DESC
                                                                LIMIT 10";
                                                            
                                                            if (!empty($params)) {
                                                                $stmt = $conn->prepare($top_suppliers_sql);
                                                                $stmt->bind_param($param_types, ...$params);
                                                                $stmt->execute();
                                                                $suppliers_result = $stmt->get_result();
                                                            } else {
                                                                $suppliers_result = $conn->query($top_suppliers_sql);
                                                            }
                                                            
                                                            while ($supplier = $suppliers_result->fetch_assoc()) {
                                                            ?>
                                                            <tr>
                                                                <td>
                                                                    <div class="d-flex align-items-center">
                                                                        <div class="flex-shrink-0">
                                                                            <div class="avatar-xs bg-light rounded-circle">
                                                                                <i class="fas fa-truck font-size-13 text-primary"></i>
                                                                            </div>
                                                                        </div>
                                                                        <div class="flex-grow-1 ms-2">
                                                                            <h6 class="mb-0"><?php echo htmlspecialchars($supplier['name']); ?></h6>
                                                                        </div>
                                                                    </div>
                                                                </td>
                                                                <td><?php echo $supplier['order_count']; ?></td>
                                                                <td><strong class="text-success">₹<?php echo number_format($supplier['total_amount'], 2); ?></strong></td>
                                                                <td>₹<?php echo number_format($supplier['avg_amount'], 2); ?></td>
                                                            </tr>
                                                            <?php } ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="col-md-6">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">
                                                    <i class="fas fa-chart-pie me-2"></i>Purchase Status Distribution
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-bordered table-hover">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Status</th>
                                                                <th>Orders</th>
                                                                <th>Total Value</th>
                                                                <th>Percentage</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            $status_distribution_sql = "SELECT 
                                                                status,
                                                                COUNT(*) as order_count,
                                                                COALESCE(SUM(total_amount), 0) as total_amount
                                                                FROM purchase_orders
                                                                $where_sql
                                                                GROUP BY status
                                                                ORDER BY total_amount DESC";
                                                            
                                                            if (!empty($params)) {
                                                                $stmt = $conn->prepare($status_distribution_sql);
                                                                $stmt->bind_param($param_types, ...$params);
                                                                $stmt->execute();
                                                                $status_result = $stmt->get_result();
                                                            } else {
                                                                $status_result = $conn->query($status_distribution_sql);
                                                            }
                                                            
                                                            $total_orders = 0;
                                                            $total_amount = 0;
                                                            $status_data = array();
                                                            
                                                            while ($status_row = $status_result->fetch_assoc()) {
                                                                $total_orders += $status_row['order_count'];
                                                                $total_amount += $status_row['total_amount'];
                                                                $status_data[] = $status_row;
                                                            }
                                                            
                                                            foreach ($status_data as $status_row) {
                                                                $percentage = $total_orders > 0 ? ($status_row['order_count'] / $total_orders) * 100 : 0;
                                                                
                                                                $status_badge = '';
                                                                switch($status_row['status']) {
                                                                    case 'completed':
                                                                        $status_badge = '<span class="badge bg-success">Completed</span>';
                                                                        break;
                                                                    case 'pending':
                                                                        $status_badge = '<span class="badge bg-warning">Pending</span>';
                                                                        break;
                                                                    case 'shipped':
                                                                        $status_badge = '<span class="badge bg-info">Shipped</span>';
                                                                        break;
                                                                    case 'cancelled':
                                                                        $status_badge = '<span class="badge bg-danger">Cancelled</span>';
                                                                        break;
                                                                }
                                                            ?>
                                                            <tr>
                                                                <td><?php echo $status_badge; ?></td>
                                                                <td><?php echo $status_row['order_count']; ?></td>
                                                                <td><strong class="text-success">₹<?php echo number_format($status_row['total_amount'], 2); ?></strong></td>
                                                                <td>
                                                                    <div class="progress" style="height: 20px;">
                                                                        <div class="progress-bar" role="progressbar" 
                                                                             style="width: <?php echo $percentage; ?>%;" 
                                                                             aria-valuenow="<?php echo $percentage; ?>" 
                                                                             aria-valuemin="0" 
                                                                             aria-valuemax="100">
                                                                            <?php echo number_format($percentage, 1); ?>%
                                                                        </div>
                                                                    </div>
                                                                </td>
                                                            </tr>
                                                            <?php } ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">
                                                    <i class="fas fa-list me-2"></i>Detailed Purchase Orders
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-bordered table-hover" id="purchaseOrdersTable">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>PO Number</th>
                                                                <th>Supplier</th>
                                                                <th>Order Date</th>
                                                                <th>Status</th>
                                                                <th>Items</th>
                                                                <th>Total Amount</th>
                                                                <th>Expected Date</th>
                                                                <th>Days to Deliver</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            // Build detailed orders query with proper WHERE conditions
                                                            $detailed_where_sql = $where_sql;
                                                            if (!empty($detailed_where_sql)) {
                                                                $detailed_where_sql = str_replace("order_date", "po.order_date", $detailed_where_sql);
                                                                $detailed_where_sql = str_replace("supplier_id", "po.supplier_id", $detailed_where_sql);
                                                                $detailed_where_sql = str_replace("status", "po.status", $detailed_where_sql);
                                                            }
                                                            
                                                            $detailed_orders_sql = "SELECT 
                                                                po.*,
                                                                s.name as supplier_name,
                                                                (SELECT COUNT(*) FROM purchase_order_items WHERE purchase_order_id = po.id) as item_count,
                                                                DATEDIFF(po.expected_date, po.order_date) as delivery_days
                                                                FROM purchase_orders po
                                                                LEFT JOIN suppliers s ON po.supplier_id = s.id
                                                                $detailed_where_sql
                                                                ORDER BY po.order_date DESC";
                                                            
                                                            if (!empty($params)) {
                                                                $stmt = $conn->prepare($detailed_orders_sql);
                                                                $stmt->bind_param($param_types, ...$params);
                                                                $stmt->execute();
                                                                $orders_result = $stmt->get_result();
                                                            } else {
                                                                $orders_result = $conn->query($detailed_orders_sql);
                                                            }
                                                            
                                                            while ($order = $orders_result->fetch_assoc()) {
                                                                $status_badge = '';
                                                                switch($order['status']) {
                                                                    case 'pending':
                                                                        $status_badge = '<span class="badge bg-warning"><i class="fas fa-clock me-1"></i>Pending</span>';
                                                                        break;
                                                                    case 'shipped':
                                                                        $status_badge = '<span class="badge bg-info"><i class="fas fa-shipping-fast me-1"></i>Shipped</span>';
                                                                        break;
                                                                    case 'completed':
                                                                        $status_badge = '<span class="badge bg-success"><i class="fas fa-check-circle me-1"></i>Completed</span>';
                                                                        break;
                                                                    case 'cancelled':
                                                                        $status_badge = '<span class="badge bg-danger"><i class="fas fa-times-circle me-1"></i>Cancelled</span>';
                                                                        break;
                                                                }
                                                                
                                                                $delivery_class = $order['delivery_days'] > 7 ? 'text-warning' : 'text-success';
                                                            ?>
                                                            <tr>
                                                                <td>
                                                                    <strong class="text-primary"><?php echo $order['po_number']; ?></strong>
                                                                </td>
                                                                <td><?php echo htmlspecialchars($order['supplier_name']); ?></td>
                                                                <td><?php echo date('M j, Y', strtotime($order['order_date'])); ?></td>
                                                                <td><?php echo $status_badge; ?></td>
                                                                <td>
                                                                    <span class="badge bg-secondary"><?php echo $order['item_count']; ?> items</span>
                                                                </td>
                                                                <td>
                                                                    <strong class="text-success">₹<?php echo number_format($order['total_amount'], 2); ?></strong>
                                                                </td>
                                                                <td><?php echo date('M j, Y', strtotime($order['expected_date'])); ?></td>
                                                                <td class="<?php echo $delivery_class; ?>">
                                                                    <strong><?php echo $order['delivery_days']; ?> days</strong>
                                                                </td>
                                                            </tr>
                                                            <?php } ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

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

</div>
            
        </div>

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

</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

<link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css">
<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>

// Set default date range to last 30 days if not set
    const urlParams = new URLSearchParams(window.location.search);
    if (!urlParams.has('start_date')) {
        const thirtyDaysAgo = new Date();
        thirtyDaysAgo.setDate(thirtyDaysAgo.getDate() - 30);
        document.getElementById('start_date').value = thirtyDaysAgo.toISOString().split('T')[0];
    }
    
    if (!urlParams.has('end_date')) {
        document.getElementById('end_date').value = new Date().toISOString().split('T')[0];
    }
});

// Export functions
function exportToExcel() {
    // Create a simple Excel export
    const table = document.getElementById('purchaseOrdersTable');
    const html = table.outerHTML;
    
    // Create a blob and download
    const blob = new Blob([html], {type: 'application/vnd.ms-excel'});
    const url = URL.createObjectURL(blob);
    const a = document.createElement('a');
    a.href = url;
    a.download = 'purchase-report-<?php echo date('Y-m-d'); ?>.xls';
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
    URL.revokeObjectURL(url);
    
    // Show success message
    showAlert('Report exported to Excel successfully!', 'success');
}

function exportToPDF() {
    // Show message about PDF export
    showAlert('PDF export feature would be implemented with a PDF library like jsPDF or TCPDF.', 'info');
}

function saveAsImage() {
    // Show message about image export
    showAlert('Image export feature would be implemented with html2canvas library.', 'info');
}

// Quick date range filters
function setDateRange(days) {
    const endDate = new Date();
    const startDate = new Date();
    startDate.setDate(startDate.getDate() - days);
    
    document.getElementById('start_date').value = startDate.toISOString().split('T')[0];
    document.getElementById('end_date').value = endDate.toISOString().split('T')[0];
    document.getElementById('reportFilters').submit();
}
</script>

</body>
</html>

<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: reports-purchases.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation