@extends('fronted.layout.main')
<style>
    .amount-cell {
        text-align: justify;
        width: 250px;
    }

    .table-striped td,
    .table-striped th {
        vertical-align: middle;
    }

    .year-item {
        position: relative;
    }

    .month-list {
        display: none;
        position: absolute;
        left: -100%;
        top: 10%;
        min-width: 100%;
    }

    .year-item:hover .month-list:not(.quater-list) {
        display: block;
    }

    .quater-list-item {
        position: relative;
    }

    .quater-list {
        display: none;
        position: absolute;
        left: -85%;
        top: 10;
        min-width: 100%;
    }

    .quater-list-item:hover .quater-list {
        display: block;
    }
</style>
@section('adcontent')
    <div class="mb-5 container" id="business-dashboard">
        <h4 class="text-center mt-4 mb-0 shadow bg-white rounded p-1">Profit Loss Report</h4>
        <div class="d-flex justify-content-end align-middle mt-2 gap-2">
            <div class="attendaceFilterBox">
                <div class="d-flex justify-content-end align-items-center">
                    <form id="filter" action="{{ route('profit.loss.report') }}" method="GET">
                        <div class="d-flex justify-content-between g-5 gap-3 align-items-center">
                            <div class="dropdown">
                                <button class="btn btn-secondary dropdown-toggle mb-1 btn-sm" type="button"
                                    id="yearDropdown" data-bs-toggle="dropdown" aria-expanded="false">
                                    Filter
                                </button>
                                <ul class="dropdown-menu" aria-labelledby="yearDropdown">
                                    @foreach ($filterData as $year => $months)
                                        <li class="year-item" data-year="{{ $year }}">
                                            <a class="dropdown-item" href="#">
                                                <i class="fa-solid fa-caret-left me-3"></i>{{ $year }}
                                            </a>
                                            <ul class="dropdown-menu month-list" aria-labelledby="year{{ $year }}">
                                                @foreach ($months as $key => $month)
                                                    @if (is_array($month))
                                                        <li class="quater-list-item">
                                                            <a class="dropdown-item" href="#">
                                                                <i class="fa-solid fa-caret-left me-3"></i>
                                                                {{ $key }} is month
                                                            </a>
                                                            <ul class="dropdown-menu quater-list"
                                                                aria-labelledby="year{{ $year }}-{{ $key }}">
                                                                @foreach ($month as $q => $v)
                                                                    <li>
                                                                        <button class="dropdown-item" type="submit"
                                                                            name="filter"
                                                                            value='{"year": "{{ $year }}", "filter": "{{ $key }}", "quater": "{{ $v }}"}'>
                                                                            {{ $q }}
                                                                        </button>
                                                                    </li>
                                                                @endforeach
                                                            </ul>
                                                        </li>
                                                    @else
                                                        <li>
                                                            <button class="dropdown-item" type="submit" name="filter"
                                                                value='{"year": "{{ $year }}", "filter": "{{ $month }}"}'>
                                                                {{ $key }}
                                                            </button>
                                                        </li>
                                                    @endif
                                                @endforeach
                                            </ul>
                                        </li>
                                    @endforeach
                                </ul>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <div>
                <form id="filterForm" action="{{ route('profit.loss.report.download') }}" method="GET">
                    <input type="hidden" name="filter"
                        value="{{ is_array($filterSelectedData) ? json_encode($filterSelectedData) : null }}">
                    <button type="button" id="downloadProfitLossReport" class="btn btn-warning btn-sm">Download</button>
                </form>

            </div>
        </div>

        <div class="container-fluid p-0 mt-2 mb-3">
            <div class="d-flex justify-content-between align-items-center flex-wrap gap-2">
                <div class="p-0 m-0">
                    <div class="bg-white text-center shadow rounded py-2 px-4">
                        <i class="fa-solid fa-receipt" style="color: #fbf309;"></i>
                        <p class="text-nowrap m-0 d-inline-block table-box-text">Sale</p>
                        <p class="fs-6 m-0 text-center fw-bold">
                            <i class="fa-solid fa-indian-rupee-sign me-1" style="color: #222325;">
                            </i>
                            <span class="text-dark" id="TotalSaleAmount">
                                {{ number_format($SaleAmount, 2) }}
                            </span>
                        </p>
                    </div>
                </div>
                <div class="p-0 m-0">
                    <div class="bg-white text-center shadow py-2 px-4 rounded ">
                        <i class="fa-sharp fa-solid fa-hand-holding-dollar" style="color: #fbf309;"></i>
                        <p class="text-nowrap m-0 d-inline-block table-box-text">Expenses</p>
                        <p class="fs-6 m-0 text-center fw-bold">
                            <i class="fa-solid fa-indian-rupee-sign me-1" style="color: #222325;">
                            </i>
                            <span class="text-dark" id="TotalExpensesAmount">
                                {{ number_format($ExpenseAmount, 2) }}
                            </span>
                        </p>
                    </div>
                </div>
                <div class="p-0 m-0">
                    <div class="bg-white text-center shadow py-2 px-4 rounded">
                        <i class="fa-solid fa-arrow-up" style="color: #fbf309;"></i>
                        <p class="text-nowrap m-0 d-inline-block table-box-text" id="gross-text">Gross
                            {{ $grossProfit < 0 ? 'Loss' : 'Profit' }} </p>
                        <p class="fs-6 m-0 text-center fw-bold" id="grossAmount">
                            @if ($grossProfit < 0)
                                <span class="text-warning" id="GrossProfiltAmount">
                                    <i class="fa-solid fa-indian-rupee-sign me-1"></i>
                                    {{ number_format(abs($grossProfit), 2) }}
                                </span>
                            @else
                                <span class="text-success" id="GrossProfiltAmount">
                                    <i class="fa-solid fa-indian-rupee-sign me-1"></i>
                                    {{ number_format(abs($grossProfit), 2) }}
                                </span>
                            @endif
                        </p>
                    </div>
                </div>
                <div class="p-0 m-0">
                    <div class="bg-white text-center shadow py-2 px-4 rounded">
                        <i class="fa-sharp fa-solid fa-hand-holding-dollar" style="color: #fbf309;"></i>
                        <p class="text-nowrap m-0 d-inline-block table-box-text" id="net-text">Net
                            {{ $netProfit < 0 ? 'Loss' : 'Profit' }}</p>
                        <p class="fs-6 m-0 text-center fw-bold" id="netAmount">
                            @if ($netProfit < 0)
                                <span class="text-warning"id="NetProfiltAmount">
                                    <i class="fa-solid fa-indian-rupee-sign me-1"></i>
                                    {{ number_format(abs($netProfit), 2) }}
                                </span>
                            @else
                                <span class="text-success"id="NetProfiltAmount">
                                    <i class="fa-solid fa-indian-rupee-sign me-1"></i>
                                    {{ number_format(abs($netProfit), 2) }}
                                </span>
                            @endif
                        </p>
                    </div>
                </div>
            </div>
        </div>
        <div class="mb-3">
            <div class="bg-light rounded">
                <div class="table-responsive">
                    <table class="table table-striped align-middle">
                        <thead class="table-dark">
                            <tr>
                                <th>Sale Description</th>
                                <th>Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>
                                    Reg Sale(Direct)
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($regSaletoTalAmount - $totalRegWavedAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>Reg Sale Waved(Indirect)</td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($totalRegWavedAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>Custom Sale(Direct)</td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($customeSaleTotalAmount - $totalCustomWavedAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>Custom Sale Waved(Indirect)</td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($totalCustomWavedAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <th>Total</th>
                                <th class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($regSaletoTalAmount + $customeSaleTotalAmount, 2) }}
                                </th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <div class="mb-3">
            <div class="bg-light rounded">
                <div class="table-responsive">
                    <table class="table table-striped align-middle">
                        <thead class="table-dark">
                            <tr>
                                <th>Expense Description</th>
                                <th>Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>
                                    Expenses
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($ExpenseAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <th>Total</th>
                                <th class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($ExpenseAmount, 2) }}
                                </th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <div class="mb-3">
            <div class="bg-light rounded">
                <div class="table-responsive">
                    <table class="table table-striped align-middle">
                        <thead class="table-dark">
                            <tr>
                                <th>Final Report</th>
                                <th>Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>
                                    Total Sale
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($SaleAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Total Expenses
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($ExpenseAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Gross Profit
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format(abs($grossProfit), 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Total Waved
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($totalCustomWavedAmount + $totalRegWavedAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>Taxes({{ $gstPersentag }}%)</td>
                                <td class="amount-cell">
                                    @php
                                        $netProfit = 0;
                                        $gstAmount = 0;
                                        $netProfit = $grossProfit - ($totalCustomWavedAmount + $totalRegWavedAmount);
                                        $gstAmount = ($netProfit * $gstPersentag) / 100;
                                    @endphp
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format($gstAmount, 2) }}
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Net Profit
                                </td>
                                <td class="amount-cell">
                                    <i class="fa-solid fa-indian-rupee-sign"></i>
                                    {{ number_format(abs($netProfit - $gstAmount), 2) }}
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

    </div>
    <script>
        function filterDateSelected(selectedOption) {
            if (selectedOption === 'custom') {
                $('#customDateRange').show();
                $('#quterType').hide();
            } else if (selectedOption === 'quarter') {
                $("#quterType").show();
                $('#customDateRange').hide();
            } else {
                $('#customDateRange').hide();
                $('#quterType').hide();
            }
        }

        // Bind the change event to the select element
        $('#dateFilter').change(function() {
            var selectedOption = $(this).val();
            filterDateSelected(selectedOption);
        });

        $(document).ready(function() {
            $("#filterBtn").on('click', function() {
                $("#filterForm").attr('action', "{{ route('profit.loss.report') }}").submit();
            })
            $("#filterForm").on('submit', function(event) {
                event.preventDefault();

                $(this).off('submit').submit();

            });

            $("#downloadProfitLossReport").on('click', function() {
                $("#filterForm").attr('action', "{{ route('profit.loss.report.download') }}").submit();
            });
        });
    </script>
@endsection