@extends('admin.layout.master')
@section('title')
{{ $current_route->{'name_' . trans('admin.lang')} }}
@stop
@section('page-breadcrumb')
@include('admin.layout.breadcrumb_view')
@stop
@section('page-actions')
@include('admin.accounts_reports.parts.buttons')
@stop
@section('page-content')
<form role="form" method="post" action="" id="sale_return_form">
    <div class="row mb-3">
        <div class="form-group col-md-3 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-3 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)
    @php
        $digits = $system_settings->system_digit ?? config('app.system_digit', 2);
        $lang = trans('admin.lang');

        $sumOpeningMadeen = 0; $sumOpeningDaen = 0;
        $sumPeriodMadeen  = 0; $sumPeriodDaen  = 0;
        $sumTotalMadeen   = 0; $sumTotalDaen   = 0;
        $sumFinalMadeen   = 0; $sumFinalDaen   = 0;
    @endphp

    <div class="table-responsive">
        <table id="datatable-buttons" class="table table-bordered table-hover">
            <thead>

            @if ($start_date || $end_date)
                <tr>
                    <th colspan="11" style="text-align: center">
                        <b>@Lang('admin.start_date'):</b>{{ $start_date ?: '-' }} -  <b>@Lang('admin.end_date'):</b>{{ $end_date ?: '-' }}
                    </th>
                </tr>
            @endif
            <tr>
                <th rowspan="2">@Lang('admin.account-id')</th>
                <th rowspan="2">@Lang('admin.account-code')</th>
                <th rowspan="2">@Lang('admin.account_name')</th>
                <th colspan="2" class="text-center">مجموع حركات العام الماضي + القيود الافتتاحية في العام الجديد</th>
                <th colspan="2" class="text-center">رصيد الفترة المطلوبة</th>
                <th colspan="2" class="text-center">مجموع المجموعتين الثانية والثالثة</th>
                <th colspan="2" class="text-center">الرصيد النهائي</th>
            </tr>
            <tr>
                <th>@Lang('admin.madeen')</th>
                <th>@Lang('admin.daen')</th>
                <th>@Lang('admin.madeen')</th>
                <th>@Lang('admin.daen')</th>
                <th>@Lang('admin.madeen')</th>
                <th>@Lang('admin.daen')</th>
                <th>@Lang('admin.madeen')</th>
                <th>@Lang('admin.daen')</th>
            </tr>
            </thead>
            <tbody>
            @foreach($results as $row)
                @php
                    $accName = ($lang === 'ar') ? ($row->account_name_ar ?? '') : ($row->account_name_en ?? '');

                    $opening_madeen = (float) ($row->opening_madeen ?? 0);
                    $opening_daen   = (float) ($row->opening_daen ?? 0);

                    $period_madeen  = (float) ($row->period_madeen ?? 0);
                    $period_daen    = (float) ($row->period_daen ?? 0);

                    $total_madeen   = (float) ($row->total_madeen ?? 0);
                    $total_daen     = (float) ($row->total_daen ?? 0);

                    $final_balance  = (float) ($row->final_balance ?? 0);
                    $final_madeen   = $final_balance > 0 ? $final_balance : 0;
                    $final_daen     = $final_balance < 0 ? abs($final_balance) : 0;

                    $sumOpeningMadeen += $opening_madeen;
                    $sumOpeningDaen   += $opening_daen;
                    $sumPeriodMadeen  += $period_madeen;
                    $sumPeriodDaen    += $period_daen;
                    $sumTotalMadeen   += $total_madeen;
                    $sumTotalDaen     += $total_daen;
                    $sumFinalMadeen   += $final_madeen;
                    $sumFinalDaen     += $final_daen;
                @endphp
                <tr>
                    <td>{{ $row->account_id ?? '' }}</td>
                    <td>{{ $row->account_code ?? '' }}</td>
                    <td>{{ $accName }}</td>
                    <td>{{ number_format($opening_madeen, $digits) }}</td>
                    <td>{{ number_format($opening_daen, $digits) }}</td>
                    <td>{{ number_format($period_madeen, $digits) }}</td>
                    <td>{{ number_format($period_daen, $digits) }}</td>
                    <td>{{ number_format($total_madeen, $digits) }}</td>
                    <td>{{ number_format($total_daen, $digits) }}</td>
                    <td>{{ number_format($final_madeen, $digits) }}</td>
                    <td>{{ number_format($final_daen, $digits) }}</td>
                </tr>
            @endforeach
            </tbody>
            <tfoot>
            <tr>
                <td></td>
                <td></td>
                <td>@Lang('admin.total')</td>
                <td>{{ number_format($sumOpeningMadeen, $digits) }}</td>
                <td>{{ number_format($sumOpeningDaen, $digits) }}</td>
                <td>{{ number_format($sumPeriodMadeen, $digits) }}</td>
                <td>{{ number_format($sumPeriodDaen, $digits) }}</td>
                <td>{{ number_format($sumTotalMadeen, $digits) }}</td>
                <td>{{ number_format($sumTotalDaen, $digits) }}</td>
                <td>{{ number_format($sumFinalMadeen, $digits) }}</td>
                <td>{{ number_format($sumFinalDaen, $digits) }}</td>
            </tr>
            </tfoot>
        </table>
    </div>
@endif
@stop
@section('css')
<style>
    .main-content {
        overflow: initial;
    }
</style>
@stop
@section('js')
<script>
    var link = "