{% extends 'base.html' %}
{% block title %}Production Reports - Jambo Management System{% endblock %}

{% block content %}
<div class="container-fluid py-4">
    <!-- Header -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <h2 class="mb-0">
                    <i class="fas fa-chart-line text-primary me-2"></i>
                    Production Reports Dashboard
                </h2>
                <div>
                    <button class="btn btn-success me-2" onclick="exportToExcel()">
                        <i class="fas fa-file-excel me-1"></i> Export to Excel
                    </button>
                    <button class="btn btn-info" onclick="refreshData()">
                        <i class="fas fa-sync-alt me-1"></i> Refresh
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Statistics Cards -->
    <div class="row mb-4">
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-primary shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">
                                Total Productions (30 Days)
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800" id="totalProductions">
                                {{ stats[0] or 0 }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-industry fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-success shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                Total Pieces (30 Days)
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800" id="totalPieces">
                                {{ stats[1] or 0 }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-boxes fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-info shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                                Total Yards (30 Days)
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800" id="totalYards">
                                {{ stats[2] or 0 }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-ruler fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-left-warning shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                                Avg Pieces/Production
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800" id="avgPieces">
                                {{ "%.0f"|format(stats[3] or 0) }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-chart-bar fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-filter me-1"></i> Report Filters
                    </h6>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-3">
                            <label class="form-label">Date From</label>
                            <input type="date" class="form-control" id="dateFrom">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">Date To</label>
                            <input type="date" class="form-control" id="dateTo">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">Customer</label>
                            <input type="text" class="form-control" id="customerFilter" placeholder="Search customer...">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">Jambo No</label>
                            <input type="text" class="form-control" id="jamboFilter" placeholder="Search jambo...">
                        </div>
                    </div>
                    <div class="row mt-3">
                        <div class="col-12">
                            <button class="btn btn-primary" onclick="generateDetailedReport()">
                                <i class="fas fa-search me-1"></i> Generate Report
                            </button>
                            <button class="btn btn-secondary ms-2" onclick="clearFilters()">
                                <i class="fas fa-times me-1"></i> Clear Filters
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Charts Row -->
    <div class="row mb-4">
        <div class="col-xl-8 col-lg-7">
            <div class="card shadow mb-4">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-chart-area me-1"></i> Daily Production Trend (Last 7 Days)
                    </h6>
                </div>
                <div class="card-body">
                    <canvas id="dailyProductionChart" width="100%" height="40"></canvas>
                </div>
            </div>
        </div>

        <div class="col-xl-4 col-lg-5">
            <div class="card shadow mb-4">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-chart-pie me-1"></i> Top Customers (30 Days)
                    </h6>
                </div>
                <div class="card-body">
                    <div id="topCustomersChart"></div>
                </div>
            </div>
        </div>
    </div>

    <!-- Detailed Report Table -->
    <div class="row">
        <div class="col-12">
            <div class="card shadow mb-4">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-table me-1"></i> Detailed Production Report
                    </h6>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered" id="productionTable" width="100%" cellspacing="0">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Order No</th>
                                    <th>Customer</th>
                                    <th>Size</th>
                                    <th>Colour</th>
                                    <th>Micron</th>
                                    <th>Pieces</th>
                                    <th>Yards</th>
                                    <th>Jambo No</th>
                                    <th>Shifts</th>
                                    <th>Pieces/Shift</th>
                                </tr>
                            </thead>
                            <tbody id="productionTableBody">
                                {% for prod in recent_productions %}
                                <tr>
                                    <td>{{ prod[0] }}</td>
                                    <td>{{ prod[1] }}</td>
                                    <td>{{ prod[2] }}</td>
                                    <td>{{ prod[3] }}</td>
                                    <td>{{ prod[4] }}</td>
                                    <td>{{ prod[5] }}</td>
                                    <td>{{ prod[6] }}</td>
                                    <td>{{ prod[7] }}</td>
                                    <td>{{ prod[8] }}</td>
                                    <td>{{ prod[9] or '-' }}</td>
                                    <td>{{ prod[10] or '-' }}</td>
                                </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Loading Modal -->
<div class="modal fade" id="loadingModal" tabindex="-1">
    <div class="modal-dialog modal-sm">
        <div class="modal-content">
            <div class="modal-body text-center">
                <div class="spinner-border text-primary" role="status">
                    <span class="visually-hidden">Loading...</span>
                </div>
                <p class="mt-2">Generating Report...</p>
            </div>
        </div>
    </div>
</div>
{% endblock %}

{% block scripts %}
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script>
let dailyProductionChart;
let productionTable;

$(document).ready(function() {
    // Initialize DataTable
    productionTable = $('#productionTable').DataTable({
        responsive: true,
        ordering: true,
        searching: true,
        paging: true,
        info: true,
        pageLength: 25,
        language: { "emptyTable": "No production data found." }
    });

    // Initialize charts
    initializeCharts();
    
    // Load summary data
    loadSummaryData();
});

function initializeCharts() {
    // Daily Production Chart
    const ctx = document.getElementById('dailyProductionChart').getContext('2d');
    dailyProductionChart = new Chart(ctx, {
        type: 'line',
        data: {
            labels: [{% for day in daily_productions %}'{{ day[0] }}'{% if not loop.last %}, {% endif %}{% endfor %}],
            datasets: [{
                label: 'Pieces Produced',
                data: [{% for day in daily_productions %}{{ day[1] or 0 }}{% if not loop.last %}, {% endif %}{% endfor %}],
                borderColor: 'rgb(75, 192, 192)',
                backgroundColor: 'rgba(75, 192, 192, 0.2)',
                tension: 0.1
            }, {
                label: 'Yards Used',
                data: [{% for day in daily_productions %}{{ day[2] or 0 }}{% if not loop.last %}, {% endif %}{% endfor %}],
                borderColor: 'rgb(255, 99, 132)',
                backgroundColor: 'rgba(255, 99, 132, 0.2)',
                tension: 0.1
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            scales: {
                y: {
                    beginAtZero: true
                }
            }
        }
    });
}

function loadSummaryData() {
    $.ajax({
        url: '/api/production/reports/summary',
        method: 'GET',
        success: function(response) {
            if (response.success) {
                updateSummaryCards(response);
            }
        },
        error: function(xhr, status, error) {
            console.error('Error loading summary data:', error);
        }
    });
}

function updateSummaryCards(data) {
    // Update summary cards with real-time data
    $('#totalProductions').text(data.this_month.count);
    $('#totalPieces').text(data.this_month.pieces);
    $('#totalYards').text(data.this_month.yards);
    
    if (data.this_month.count > 0) {
        $('#avgPieces').text(Math.round(data.this_month.pieces / data.this_month.count));
    }
}

function generateDetailedReport() {
    const filters = {
        date_from: $('#dateFrom').val(),
        date_to: $('#dateTo').val(),
        customer: $('#customerFilter').val(),
        jambo_no: $('#jamboFilter').val()
    };

    $('#loadingModal').modal('show');

    $.ajax({
        url: '/api/production/reports/detailed',
        method: 'POST',
        contentType: 'application/json',
        data: JSON.stringify(filters),
        success: function(response) {
            $('#loadingModal').modal('hide');
            if (response.success) {
                updateProductionTable(response.productions);
            } else {
                alert('Error generating report: ' + response.message);
            }
        },
        error: function(xhr, status, error) {
            $('#loadingModal').modal('hide');
            alert('Error generating report: ' + error);
        }
    });
}

function updateProductionTable(productions) {
    productionTable.clear();
    
    productions.forEach(function(prod) {
        productionTable.row.add([
            prod.production_date,
            prod.order_no,
            prod.customer_name,
            prod.size,
            prod.colour,
            prod.micron,
            prod.produced_pieces,
            prod.yards_used,
            prod.jambo_no,
            prod.shifts_used || '-',
            prod.pieces_per_shift || '-'
        ]);
    });
    
    productionTable.draw();
}

function clearFilters() {
    $('#dateFrom').val('');
    $('#dateTo').val('');
    $('#customerFilter').val('');
    $('#jamboFilter').val('');
    generateDetailedReport();
}

function refreshData() {
    loadSummaryData();
    generateDetailedReport();
}

function exportToExcel() {
    const table = document.getElementById('productionTable');
    const wb = XLSX.utils.table_to_book(table, {sheet: "Production Report"});
    XLSX.writeFile(wb, 'Production_Report_' + new Date().toISOString().split('T')[0] + '.xlsx');
}

// Auto-refresh every 5 minutes
setInterval(function() {
    loadSummaryData();
}, 300000);
</script>

<style>
.border-left-primary {
    border-left: 0.25rem solid #4e73df !important;
}
.border-left-success {
    border-left: 0.25rem solid #1cc88a !important;
}
.border-left-info {
    border-left: 0.25rem solid #36b9cc !important;
}
.border-left-warning {
    border-left: 0.25rem solid #f6c23e !important;
}
.text-gray-800 {
    color: #5a5c69 !important;
}
.text-gray-300 {
    color: #dddfeb !important;
}
.text-xs {
    font-size: 0.7rem;
}
.font-weight-bold {
    font-weight: 700 !important;
}
</style>
{% endblock %}