@extends('admin.layout.master')
@section('title')
    @Lang('admin.tax_return')
@stop
@section('page-breadcrumb')
    @include('admin.layout.breadcrumb_view')
@stop
@section('page-actions')
    @include('admin.report_vat.parts.buttons')
@stop
@section('page-content')
    <h4 class="card-title">@Lang('admin.tax_return')</h4>
    <form role="form" method="post" action="" id="sale_return_form">
        <div class="row mb-3">
            <div class="form-group col-md-2 col-sm-12">
                <label for="start_date">@Lang('admin.from_inv_date')</label>
                <div class="input-group" id="datepicker1">
                    <input type="text" autocomplete="off" class="form-control" value="{{ $start_date }}"
                           name="start_date" data-date-format="yyyy-mm-dd" data-provide="datepicker"
                           data-date-container='#datepicker1'>
                    <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                </div>
            </div>
            <div class="form-group col-md-2 col-sm-12">
                <label for="start_date">@Lang('admin.to_inv_date')</label>
                <div class="input-group" id="datepicker2">
                    <input type="text" autocomplete="off" class="form-control" value="{{ $end_date }}" name="end_date"
                           data-date-format="yyyy-mm-dd" data-provide="datepicker" data-date-container='#datepicker2'>
                    <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                </div>
            </div>
            <div class="form-group col-md-3 col-sm-12">
                <label for="start_date">&nbsp;</label><br>
                <button id="Save" name="Save" type="submit" class="btn btn btn-success">@Lang('admin.generate')</button>
            </div>
        </div>
        {{ csrf_field() }}
    </form>
    @if($results)
        <div class="table-responsive">
            <table id="datatable-buttons" class="table table-bordered table-hover">
                <thead>
                @if ($start_date || $end_date)
                    <tr>
                        <th colspan="5" style="text-align: center">
                            <b>@Lang('admin.start_date'):</b>{{ $start_date }} - <b>@Lang('admin.end_date')
                                :</b>{{ $end_date }}
                        </th>
                    </tr>
                @endif
                <tr>
                    <td>Tax Description</td>
                    <td>Tax Code</td>
                    <td>Amount (SAR)</td>
                    <td>Adjustments (SAR)</td>
                    <td>VAT Amount (SAR)</td>
                </tr>
                </thead>

                <tbody>
                @php
                    $total_p1 = 0;
                    $total_n1 = 0;
                    $total_s11 = 0;
                    $total_sale_amount = 0;
                    $final_p_row = 0;
                    $saleTotalsPrinted = false;

                    // Helper (من غير دوال خارجية)
                    $get = fn($arr, $key) => (float) ($arr[$key] ?? 0);
                @endphp

                @foreach ($tax_returns as $item)
                    @php
                        $taxId = $item->tax_id;
                        $taxRate = (float) ($item->tax->value ?? 0); // مثال: 0.15
                        $taxDiv  = (1 + $taxRate);                  // (1 + tax)
                    @endphp

                    @if($item->tax_type == 1)
                        @php
                            $total_sales          = $get($total_sale_invoice, $taxId);
                            $total_return_sales   = $get($total_sale_return_invoice, $taxId);
                            $total_notice_credit  = $get($total_notice_creditor_invoice, $taxId);
                            $total_notice_debit   = $get($total_notice_debit_invoice, $taxId);

                            $total_s = ($total_sales - $total_return_sales);
                            $total_n = ($total_notice_debit - $total_notice_credit);

                            // VAT = Net / (1+rate) * rate
                            $final_sale_row = ($taxDiv > 0)
                                ? (($total_s + $total_n) / $taxDiv * $taxRate)
                                : 0;

                            $total_s11 += $total_s;
                            $total_n1  += $total_n;
                            $total_sale_amount += $final_sale_row;
                        @endphp

                        <tr>
                            <td>{{ $item->name }}</td>
                            <td>{{ $item->tax->name }}</td>
                            <td>{{ $total_s }}</td>
                            <td>{{ $total_n }}</td>
                            <td>{{ $final_sale_row }}</td>
                        </tr>
                    @else
                        @if(!$saleTotalsPrinted)
                            @php $saleTotalsPrinted = true; @endphp
                            <tr>
                                <td>Total Sales</td>
                                <td>-</td>
                                <td>{{ $total_s11 }}</td>
                                <td>{{ $total_n1 }}</td>
                                <td>{{ $total_sale_amount }}</td>
                            </tr>
                        @endif

                        @php
                            $total_purchase        = $get($total_purshase_invoice, $taxId);
                            $total_purchase_return = $get($total_purshase_return_invoice, $taxId);

                            $total_p = ($total_purchase - $total_purchase_return);

                            $total_p12 = ($taxDiv > 0)
                                ? ($total_p / $taxDiv * $taxRate)
                                : 0;

                            $total_p1 += $total_p;
                            $final_p_row += $total_p12;
                        @endphp

                        <tr>
                            <td>{{ $item->name }}</td>
                            <td>{{ $item->tax->name }}</td>
                            <td>{{ $total_p }}</td>
                            <td></td>
                            <td>{{ $total_p12 }}</td>
                        </tr>
                    @endif
                @endforeach

                <tr>
                    <td>Total Purchases</td>
                    <td>-</td>
                    <td>{{ $total_p1 }}</td>
                    <td>-</td>
                    <td>{{ $final_p_row }}</td>
                </tr>

                @php
                    $netVat = $total_sale_amount - $final_p_row;
                @endphp

                <tr>
                    <th>Total VAT due for current period</th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th>{{ $netVat }}</th>
                </tr>
                <tr>
                    <th>Corrections from previous period (between SAR +/- 15,000)</th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                </tr>
                <tr>
                    <th>VAT credit carried forward from previous period</th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                </tr>
                <tr>
                    <th>Net VAT due (or reclaimed)</th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th>{{ $netVat }}</th>
                </tr>
                </tbody>
            </table>
        </div>
    @endif
@stop
@section('css')
    <style>
        .main-content {
            overflow: initial;
        }
    </style>
@stop
@section('js')
    <script>
        var link = "