@extends('layouts.main')

@section('content')
<div class="content-wrapper">
    <div class="content-header">
        <h1 class="h3 mb-3">Cement Sales Report</h1>
    </div>

    <div class="container-fluid">

        {{-- FILTER --}}
        <div class="card mb-4">
            <div class="card-body">
                <form method="GET" action="{{ route('reports.cement_sales') }}">
                    <div class="row">

                        <div class="col-md-3">
                            <label>Start Date</label>
                            <input type="date" name="start_date" class="form-control"
                                   value="{{ request('start_date', $startDate->format('Y-m-d')) }}">
                        </div>

                        <div class="col-md-3">
                            <label>End Date</label>
                            <input type="date" name="end_date" class="form-control"
                                   value="{{ request('end_date', $endDate->format('Y-m-d')) }}">
                        </div>

                        {{-- ✅ ADDED: WORKSTATION DROPDOWN --}}
                        <div class="col-md-3">
                            <label>Work Station (Optional)</label>
                            <select name="work_station_id" class="form-control select2">
                                <option value="">All Work Stations</option>
                                @foreach(($workStations ?? collect()) as $ws)
                                    <option value="{{ $ws->id }}"
                                        {{ (string)request('work_station_id') === (string)$ws->id ? 'selected' : '' }}>
                                        {{ $ws->name ?? ('WorkStation #'.$ws->id) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-3 d-flex align-items-end">
                            <button class="btn btn-primary w-100">
                                <i class="fa fa-filter"></i> Filter
                            </button>
                        </div>
                    </div>

                    {{-- EXPORT BUTTONS --}}
                    <div class="row mt-3">
                        <div class="col-md-12 d-flex gap-2 flex-wrap">

                            <a class="btn btn-success"
                               href="{{ route('reports.cement_report.export_excel', request()->query()) }}">
                                <i class="fa fa-file-excel"></i> Export Excel
                            </a>

                            <a class="btn btn-danger"
                               target="_blank"
                               href="{{ route('reports.cement_report.export_pdf', request()->query()) }}">
                                <i class="fa fa-file-pdf"></i> Export PDF
                            </a>

                            <a href="{{ route('reports.cement_report') }}"
                               class="btn btn-outline-secondary">
                                Reset
                            </a>

                        </div>
                    </div>
                    {{-- /EXPORT BUTTONS --}}
                </form>
            </div>
        </div>

        {{-- SALES TABLE --}}
        <div class="card mb-4">
            <div class="card-header bg-success text-white">
                <h5 class="mb-0">Cement Sales</h5>
            </div>
            <div class="card-body table-responsive">
                <table class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th>Payment Mode</th>
                            <th class="text-end">Qty</th>
                            <th class="text-end">Buying</th>
                            <th class="text-end">Selling</th>
                            <th class="text-end">Revenue</th>
                            <th class="text-end">Profit</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($sales as $s)
                        @php
                            // Ensure these are numeric when displayed
                            $buy = (float) str_replace(',', '', (string)($s->buying_price ?? 0));
                            $sell = (float) str_replace(',', '', (string)($s->selling_price ?? 0));
                        @endphp
                        <tr>
                            <td>{{ optional($s->created_at)->format('d M Y') }}</td>
                            <td>{{ ucfirst($s->payment_mode) }}</td>
                            <td class="text-end">{{ number_format($s->quantity) }}</td>
                            <td class="text-end">{{ number_format($buy, 2) }}</td>
                            <td class="text-end">{{ number_format($sell, 2) }}</td>
                            <td class="text-end">{{ number_format($s->revenue, 2) }}</td>
                            <td class="text-end {{ $s->profit < 0 ? 'text-danger' : 'text-success' }}">
                                {{ number_format($s->profit, 2) }}
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>

        {{-- PROFIT & LOSS --}}
        <div class="card">
            <div class="card-header bg-white text-white">
                <h5 class="mb-0">Profit & Loss Summary</h5>
            </div>
            <div class="card-body">

                <div class="row mb-4">
                    <div class="col-md-3">
                        <div class="p-3 border rounded bg-light">
                            <small>Total Quantity</small>
                            <h5>{{ number_format($pl['qty']) }} Bags</h5>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="p-3 border rounded bg-light">
                            <small>Total Cost</small>
                            <h5>{{ number_format($pl['cost'], 2) }}</h5>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="p-3 border rounded bg-light">
                            <small>Total Revenue</small>
                            <h5>{{ number_format($pl['revenue'], 2) }}</h5>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="p-3 border rounded {{ $pl['profit'] < 0 ? 'bg-danger text-white' : 'bg-success text-white' }}">
                            <small>Net Profit</small>
                            <h5>{{ number_format($pl['profit'], 2) }}</h5>
                        </div>
                    </div>
                </div>

                <table class="table table-bordered">
                    <tr>
                        <th>Cash Sales</th>
                        <td class="text-end">{{ number_format($pl['cash'], 2) }}</td>
                    </tr>
                    <tr>
                        <th>Loan Sales</th>
                        <td class="text-end">{{ number_format($pl['loan'], 2) }}</td>
                    </tr>
                    <tr>
                        <th>Creditor Sales</th>
                        <td class="text-end">{{ number_format($pl['creditor'], 2) }}</td>
                    </tr>
                    <tr class="table-secondary">
                        <th>Total Revenue</th>
                        <th class="text-end">{{ number_format($pl['revenue'], 2) }}</th>
                    </tr>
                    <tr class="table-primary">
                        <th>Net Profit</th>
                        <th class="text-end">{{ number_format($pl['profit'], 2) }}</th>
                    </tr>
                </table>

            </div>
        </div>

    </div>
</div>
@endsection

@section('scripts')
<script>
    $(document).ready(function() {
        $('.select2').select2({ theme: 'bootstrap4' });

        $('input[name="start_date"]').change(function() {
            $('input[name="end_date"]').attr('min', $(this).val());
        });

        $('input[name="end_date"]').change(function() {
            $('input[name="start_date"]').attr('max', $(this).val());
        });
    });
</script>
@endsection