@extends('layouts.admin')


@push('styles')
<link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


<style type="text/css">
    .btn_mt {
        margin-top: 31px;
    }
</style>
@endpush


@section('content')

<!-- Main content -->
<section class="content">
    <div class="container-fluid pt-2">

        <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-info">

                <!-- form start -->
                <form method="GET" action="{{ route('report.monthlyReport') }}">
                    <div class="card-body">
                        <div class="row">

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="month">Month</label>
                                    <select name="month" id="month" class="form-control form-control-sm">
                                        <option value="">Select Month</option>
                                        @foreach(range(1,12) as $m)
                                        <option value="{{ $m }}" {{ request('month') == $m ? 'selected' : '' }}>
                                            {{ DateTime::createFromFormat('!m', $m)->format('F') }}
                                        </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="year">Year</label>
                                    <select name="year" id="year" class="form-control form-control-sm" required>
                                        <option value="">Select Year</option>
                                        @foreach(range(date('Y'), date('Y') - 10) as $y)
                                        <option value="{{ $y }}" {{ request('year') == $y ? 'selected' : '' }}>
                                            {{ $y }}
                                        </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <button type="submit" style="margin-top: 30px;" class="btn btn-sm btn-primary btn_mt">Search</button>
                                <a href="{{ route('report.monthlyReport') }}" style="margin-top: 30px;"
                                    class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                            </div>

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

            </div>
        </div>

        <!-- /.card -->

        <div class="row">
            <!-- left column -->
            <div class="col-md-12">

                <div class="card card-info">
                    <div class="card-header">
                        <h3 class="card-title">Monthly Expense & Purchase Report</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <table id="example1" class="table table-bordered table-striped">
                            <thead class="thead-light">
                                <tr>
                                    <th>Year</th>
                                    <th>Month</th>
                                    <th>Sale Amount</th>
                                    <th>Purchase Total</th>
                                    <th>Purchase (%)</th>
                                    <th>Expense</th>
                                    <th>Expense (%)</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                // Create a combined array of all unique year-month keys
                                $keys = [];

                                foreach ($saleAmounts as $row) {
                                $keys[$row->year . '-' . $row->month] = true;
                                }
                                foreach ($dir_exp as $row) {
                                $keys[$row->year . '-' . $row->month] = true;
                                }
                                foreach ($inDir_exp as $row) {
                                $keys[$row->year . '-' . $row->month] = true;
                                }
                                foreach ($purchase as $row) {
                                $keys[$row->year . '-' . $row->month] = true;
                                }


                                @endphp

                                @foreach(array_keys($keys) as $key)
                                @php
                                [$y, $m] = explode('-', $key);

                                $sale = $saleAmounts->firstWhere(fn($r) => $r->year == $y && $r->month == $m);
                                $dir = $dir_exp->firstWhere(fn($r) => $r->year == $y && $r->month == $m);
                                $indir = $inDir_exp->firstWhere(fn($r) => $r->year == $y && $r->month == $m);
                                $pur = $purchase->firstWhere(fn($r) => $r->year == $y && $r->month == $m);
                                $saleTotal = $sale->total ?? 0;
                                $purchaseTotal = $pur->total ?? 0;
                                $expenseTotal = ($dir->amount ?? 0) + ($indir->amount ?? 0);

                                $purchasePercent = $saleTotal > 0
                                ? ($purchaseTotal / $saleTotal) * 100
                                : 0;

                                $expensePercent = $saleTotal > 0
                                ? ($expenseTotal / $saleTotal) * 100
                                : 0;
                                @endphp
                                <tr>
                                    <td>{{ $y }}</td>
                                    <td>{{ DateTime::createFromFormat('!m', $m)->format('F') }}</td>
                                    <td>{{ number_format($sale->total ?? 0, 2) }}</td>
                                    <td>{{ number_format($pur->total ?? 0, 2) }}</td>
                                    <td>{{ number_format($purchasePercent, 2) }}%</td>
                                    <td>{{ number_format(($dir->amount ?? 0) + ($indir->amount ?? 0), 2) }}</td>
                                    <td>{{ number_format($expensePercent, 2) }}%</td>
                                </tr>
                                @endforeach
                            </tbody>
                            <div class="col-md-6">
                                <tfoot class="font-weight-bold">
                                    <tr>
                                        @php
                                        $totalSale = $saleAmounts->sum('total');
                                        $totalPurchase = $purchase->sum('total');
                                        $totalExpense = $dir_exp->sum('amount') + $inDir_exp->sum('amount');

                                        $totalPurchasePercent = $totalSale > 0
                                        ? ($totalPurchase / $totalSale) * 100
                                        : 0;

                                        $totalExpensePercent = $totalSale > 0
                                        ? ($totalExpense / $totalSale) * 100
                                        : 0;
                                        @endphp

                                        <td colspan="2">Total</td>
                                        <td>{{ number_format($saleAmounts->sum('total'), 2) }}</td>

                                        <td>{{ number_format($purchase->sum('total'), 2) }}</td>
                                        <td>{{ number_format($totalPurchasePercent, 2) }}%</td>
                                        <td>{{ number_format($dir_exp->sum('amount') + $inDir_exp->sum('amount'), 2) }}</td>
                                        <td>{{ number_format($totalExpensePercent, 2) }}%</td>
                                    </tr>
                                </tfoot>
                            </div>

                        </table>
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!--/.col (left) -->
            <!-- right column -->

            <!--/.col (right) -->
        </div>
        <!-- /.row -->
    </div><!-- /.container-fluid -->
</section>
<!-- /.content -->

@endsection

@push('scripts')
<script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

<script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>
<script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
<script src="{{ asset('plugins/moment/moment.min.js') }}"></script>
<script src="{{ asset('plugins/inputmask/jquery.inputmask.min.js') }}"></script>

<script>
    $(function() {


        $('#formdate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('#todate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('.select2').select2();

        $('.select2bs4').select2({
            theme: 'bootstrap4'
        });


        $("#example1").DataTable({
            "responsive": true,
            "lengthChange": false,
            "autoWidth": false,
            buttons: [{
                    extend: 'excel',
                    title: 'Product List'
                },
                {
                    extend: 'pdf',
                    title: 'Product List'
                },
                {
                    extend: 'print',
                    title: 'Product List'
                },
                'colvis'
            ]

        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

        $('#example2').DataTable({
            "paging": true,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });

    });
</script>
@endpush