@extends('voyager::master')
@section('page_title', __('voyager::generic.viewing').' '.$dataType->getTranslatedAttribute('display_name_plural'))
@section('content')
    <div class="page-content browse container-fluid supervisor-status-report-browse">
        @include('voyager::alerts')
        <div class="content-main">
            <div class="col-md-12">
                <div class="panel panel-bordered supervisor-status-report-panel ">
                    <div class="panel-body">
                        <div class="row">

                            <div class="panel-head col-sm-12 col-12">
                                {{ __('messages.admin.Accounting-report-by-account') }}
                                <div class="panel-head-icons">
                                @if($request->has('search'))
                                    <a href="{{ route('voyager.accounting-report-by-account.index', ['action' => 'print','from_date'=>$request->from_date,'to_date'=>$request->to_date,'account_id'=>$request->account_id]) }}"
                                       class="pull-left btn-printer-icon" target="_blank">
                                        <i class="icon icon-printer11"></i>
                                    </a>
                                @endif

                            </div>
                        </div>
                        <div class="col-lg-12">
                            <form action="{{ route('voyager.accounting-report-by-account.index') }}" method="get">
                                <div class="form-group row">
                                    <div class="col-md-10">
                                        <label for="account_id" class="col-form-label col-form-label-sm">
                                            کود الحساب:</label>
                                        <select class="form-control select2" name="account_id" required>
                                            <option value="">إختر الحساب</option>
                                            @foreach($accounts as $account)
                                                <option value="{{ $account->id }}"
                                                        @if($account->id == $request->account_id) selected @endif>{{ $account->name }}</option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <div class="col-md-5">
                                        @php
                                            $date = \Carbon\Carbon::now();
                                            $previous_date = $date->subMonth()->format('Y-m-d');
                                        @endphp
                                        <label for="from_date" class="col-form-label col-form-label-sm">
                                            من تاریخ:</label>
                                        <input type="date" id="from_date" class="form-control" name="from_date"
                                               value="{{ $request->get('from_date',$previous_date) }}">
                                    </div>
                                    <div class="col-md-5">
                                        <label for="to_date" class="col-form-label col-form-label-sm">
                                            الی تاریخ:</label>
                                        <input type="date" id="to_date" class="form-control" name="to_date"
                                               value="{{ $request->get('to_date', date('Y-m-d') ) }}">
                                    </div>
                                    <div class="col-md-2">
                                        <div class=" btns-group-center mt-0">
                                            <button type="submit" class="btn btn-info" name="search"
                                                    style="margin-top: 25px;">بحث
                                            </button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                    <!-- Begin: Show data -->
                    <div class="col-12">
                        @if($request->has('search'))
                            <div class="row m-0">
                                <div class="col-md-12 col-browse">
                                    <div class="">
                                        <table class="table table-bordered">
                                            <thead>
                                            <tr>
                                                <th>مستند</th>
                                                <th>البیان</th>
                                                <th>دائن</th>
                                                <th>مدین</th>
                                                <th>رقم سند</th>
                                                <th>تاریخ القید</th>
                                                <th>قید</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @if (isset($result))
                                                @php
                                                    $total_credit = 0;
                                                    $total_debit = 0;
                                                @endphp
                                                @foreach($result['transactions'] as $record)
                                                    @php
                                                            $detail_transaction=$record->getTransactiondetails->where('account_id', $request->account_id)->first();
                                                            $total_credit += $detail_transaction->credit_amount;
                                                            $total_debit +=  $detail_transaction->debit_amount;
                                                    @endphp
                                                    <tr class="text-center">
                                                        <td>
                                                            0
                                                        </td>
                                                        <td>{{ $record['description'] }}</td>
                                                        <td>@convert($detail_transaction['credit_amount'],0) </td>
                                                        <td>@convert($detail_transaction['debit_amount'],0) </td>
                                                        <td>{{ $detail_transaction['id'] }}</td>
                                                        <td>{{ $record['transaction_date'] }}</td>
                                                        <td>{{ $record['id'] }}</td>
                                                    </tr>
                                                @endforeach
                                            @endif
                                            </tbody>
                                            <tfoot>
                                            <tr class="sum-tr text-center">
                                                <td colspan="2"> اجمالی مدین - دائن</td>
                                                <td>@convert($total_credit,0)</td>
                                                <td>@convert($total_debit,0)</td>
                                                <td colspan="3"></td>
                                            </tr>
                                            <tr class="sum-tr text-center">
                                                <td colspan="2">صافی الحساب</td>
                                                <td colspan="2" dir="ltr">@convert($total_credit - $total_debit,0)</td>
                                                <td colspan="3"></td> </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                </div>

                                <div class="col-lg-12 text-center">
                                    <div class="form-group btns-group-center">
                                        @if($request->has('search'))
                                            <a href="{{ route('voyager.accounting-report-by-account.index', ['action' => 'print','from_date'=>$request->from_date,'to_date'=>$request->to_date,'account_id'=>$request->account_id ]) }}"
                                               class=" btn btn-printer" target="_blank">
                                                {{ __('messages.print') }}
                                            </a>
                                        @endif
                                    </div>
                                </div>

                                @endif
                                <!-- End: Show data -->
                            </div>
                    </div>
                </div>
            </div>
        </div>

        @stop

        @section('css')
            @if(!$dataType->server_side && config('dashboard.data_tables.responsive'))
                <link rel="stylesheet" href="{{ voyager_asset('lib/css/responsive.dataTables.min.css') }}">
            @endif
        @stop

        @section('javascript')
            <!-- DataTables -->
            @if(!$dataType->server_side && config('dashboard.data_tables.responsive'))
                <script src="{{ voyager_asset('lib/js/dataTables.responsive.min.js') }}"></script>
    @endif
@stop