@extends('layouts.master')

@section('title', 'Account Statement | Alboosh - Timeless authenticity, born of the desert')

@section('title-topbar', __('basic.account statement'))


<!-- css insert -->
@section('css')

<!-- select 2 -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-rc.0/css/select2.min.css"
    integrity="sha512-aD9ophpFQ61nFZP6hXYu4Q/b/USW7rpLCQLX6Bi0WJHXNO7Js/fUENpBQf/+P4NtpzNX0jSgR5zVvPOJp+W2Kg=="
    crossorigin="anonymous" referrerpolicy="no-referrer" />


<!-- tables -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.0.1/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.2/css/dataTables.bootstrap5.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.0.1/css/buttons.bootstrap5.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/autofill/2.3.9/css/autoFill.bootstrap5.min.css">


<!-- datepicker time and date -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/flatpickr/4.6.13/flatpickr.min.css"
    integrity="sha512-MQXduO8IQnJVq1qmySpN87QQkiR1bZHtorbJBD0tzy7/0U9+YIC93QWHeGTEoojMVHWWNkoCp8V6OzVSYrX0oQ=="
    crossorigin="anonymous" referrerpolicy="no-referrer" />
<link rel="stylesheet" href="https://fastly.jsdelivr.net/npm/flatpickr@4.6.13/dist/plugins/monthSelect/style.min.css">

@endsection

<!-- content insert -->
@section('content')

<div class="container-fluid px-2 mt-3">

    <!-- page title link -->
    <div class="d-flex align-items-center justify-content-between mb-3 hide_in_print">

        <span class="mb-0 me-1">
            <a class="link-cust-text text-gray-200 fw-light" href="{{ route('sett.home') }}">{{ __('basic.dashboard') }}
                |</a>
            <a class="text-gray-300">{{ __('basic.account statement') }}</a>
        </span>

        <div class="d-flex justify-content-center mt-2 mt-md-0">

            <a href="{{ route('sett.acc_entry.create') }}"
                class=" text-gray-400 bg-white btn btn-sm shadow-sm b-r-l-cont p-2 px-4 me-2"><i
                    class="fas fa-plus fa-sm me-1"></i> {{ __('basic.new entry') }}</a>


            <a class="text-gray-400 bg-white btn btn-sm shadow-sm b-r-l-cont p-2 px-4 me-2 printPage"><i
                    class="fas fa-print fa-sm me-1"></i> {{ __('basic.print') }}</a>


            <a class="btn btn-sm status-col-link cancel-color-btn shadow-sm b-r-l-cont p-2 px-4 me-2 "
                data-bs-toggle="modal" data-bs-target="#delete_modal{{ $account->id }}"><i
                    class="fas fa-trash fa-sm me-1"></i> {{
                __('basic.delete account') }}</a>

            <!-- Modal -->
            <div class="modal fade" id="delete_modal{{ $account->id }}" tabindex="-1"
                aria-labelledby="exampleModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-dialog-centered modal-dialog-scrollable ">
                    <div class="modal-content b-r-s-cont border-0">

                        <div class="modal-header">
                            <div class="modal-title" id="exampleModalLabel"><i class="fas fa-trash me-1"></i>
                                {{ __('basic.delete') }}</div>
                            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                        </div>

                        <form action="{{ route('sett.acc_account.destroy', 'test') }}" method="post">
                            {{ method_field('delete') }}
                            {{ csrf_field() }}

                            <!-- Modal content -->
                            <div class="modal-body px-4">
                                <div class="modal-body delete-conf-input text-center py-0">
                                    <p class="mb-0">{{ __('basic.delete message') }}</p><br>
                                    <input type="hidden" name="item_id" value="{{ $account->id }}">
                                </div>
                            </div>

                            <div class="modal-footer">
                                <div class="left-side">
                                    <button type="button" class="btn btn-default btn-link" data-bs-dismiss="modal">{{
                                        __('basic.never mind') }}</button>
                                </div>
                                <div class="divider"></div>
                                <div class="right-side">
                                    <button type="submit" class="btn btn-default btn-link text-red">{{
                                        __('basic.delete') }}
                                    </button>
                                </div>

                            </div>
                        </form>

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


            <a class="main-color-bg text-white btn btn-sm shadow-sm b-r-l-cont p-2 px-4 me-1" data-bs-toggle="modal"
                data-bs-target="#new_record"><i class="fas fa-filter fa-sm me-1"></i> {{ __('basic.search filter')
                }}</a>

            <!-- Modal for search filtering -->
            <div class="modal fade" id="new_record" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
                aria-hidden="true">
                <div class="modal-dialog modal-dialog-centered modal-dialog-scrollable">

                    <form class="mb-0" action="{{ route('sett.acc_account.show', $account->id) }}" method="GET"
                        style="display: contents">

                        <div class="modal-content b-r-s-cont border-0">
                            <div class="modal-header">
                                <h5 class="modal-title" id="exampleModalLabel"><i class="fas fa-clipboard me-1"></i>
                                    {{ __('basic.search filter') }}</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"
                                    aria-label="Close"></button>
                            </div>

                            <!-- Modal content -->
                            <div class="modal-body px-5 py-3">

                                <div class="row">

                                    <div class="me-2 mb-3">
                                        <label class="form-label">{{ __('basic.date') }}
                                            <small>({{ __('basic.required') }})</small></label>
                                        <select id="date_filter" name="date_serc"
                                            class="js-example-basic-single js-example-basic-single select2-hidden-accessible">
                                            <option value="last_week">
                                                {{ __('basic.last week')}}
                                            </option>
                                            <option value="last_month">
                                                {{ __('basic.last month')}}
                                            </option>
                                            <option value="this_month">
                                                {{ __('basic.this month')}}
                                            </option>
                                            <option selected value="this_year">
                                                {{ __('basic.this year')}}
                                            </option>
                                            <option value="last_year">
                                                {{ __('basic.last year')}}
                                            </option>
                                            <option value="date_between">
                                                {{ __('basic.date')}}
                                            </option>
                                        </select>
                                    </div>

                                    <div class="col-12 mb-2" id="date_between_cont" style="display: none">
                                        <label class="form-label">{{ __('basic.date between') }}
                                            <small>({{ __('basic.required') }})</small></label>
                                        <div class="input-group">
                                            <div class="input-group-prepend">
                                                <div class="input-group-text"><i class="bi bi-calendar2-week-fill"></i>
                                                </div>
                                            </div>
                                            <input name="day_srch" type="text"
                                                class="form-control datepicker_time bg-white"
                                                value="{{ request()->get('day_srch') }}" placeholder="YYYY/MM/DD HM"
                                                data-enable-time="true">

                                        </div>
                                        @error('date')
                                        <span class="error-msg-form">
                                            {{ $message }}
                                        </span>
                                        @enderror
                                    </div>


                                </div>

                            </div>

                            <div class="modal-footer">
                                <div class="left-side">
                                    <button type="button" class="btn btn-default btn-link" data-bs-dismiss="modal">{{
                                        __('basic.never mind') }}</button>
                                </div>
                                <div class="divider"></div>
                                <div class="right-side">
                                    <button type="submit" class="btn btn-default btn-link main-color">{{
                                        __('basic.search') }}</button>
                                </div>
                            </div>
                        </div>
                    </form>

                </div>

            </div>

        </div>

    </div>

    <div class="text-center mb-4">
        <h5 class="fw-bold">{{ __('basic.account statement') }}</h5>
        <h6 class="text-gray-500">{{ $account->name }}</h6>
        <h6 class="text-gray-500">
            <span>{{ __('basic.from') }} </span> {{ $date_from }}
            <span>{{ __('basic.to') }} </span> {{ $date_to }}
        </h6>
        <h6 class="text-gray-900">
            <span class="text-gray-400">{{ __('basic.currency') }} </span> {{ $system_currency->name }}
        </h6>
    </div>


    <div class="row">

        <div class="col-12">

            <div class="card card-input shadow mb-3 pb-3">
                <!-- Card Header - Dropdown -->
                <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
                    <h6 class="m-0 fw-bold text-gray-500"><i class="fas fa-chart-bar me-1"></i>
                        {{ __('basic.account statement') }}</h6>
                </div>

                <!-- Card Body -->
                <div class="card-body">

                    <div class="table-responsive data_table_style_2_cont">
                        <table class="table display datatable-modal data_table_style_2" id="p-lab-table" width="100%"
                            cellspacing="0">
                            <thead>
                                <tr>
                                    <th class="text-xxs">{{ __('basic.transaction') }}</th>
                                    <th class="text-xxs text-center">{{ __('basic.debit') }}</th>
                                    <th class="text-xxs text-center">{{ __('basic.credit') }}</th>
                                    <th class="text-xxs text-center">{{ __('basic.current balance') }}</th>
                                    <th class="text-xxs text-center"></th>
                                </tr>
                            </thead>
                            <tbody>

                                @php
                                $total_debit = 0;
                                $total_credit = 0;
                                $net_balance = 0;
                                @endphp
                                @foreach ($account->entry_items as $item)
                                <tr>

                                    <td>
                                        <div class="d-flex align-content-center">

                                            @php
                                            $icon = "fas fa-wallet";
                                            $icon_color = "main-color";
                                            @endphp

                                            <h2 class="me-2">
                                                <i class="{{ $icon . " " . $icon_color }}"></i>
                                            </h2>
                                            <div>
                                                <h6 class="mb-0">
                                                    {{ "(". $item->entry->new_id . ")" . $item->date }}
                                                </h6>
                                                <p class="text-gray-300">{{ $item->description . "(". $item->code . ")"
                                                    }}</p>
                                            </div>
                                        </div>
                                    </td>

                                    @php
                                    $total_debit += $item->debit_local;
                                    $total_credit += $item->credit_local;
                                    $net_balance += $item->account_balance_local;
                                    @endphp
                                    <td>
                                        <h6 class="text-center">
                                            {{ $item->debit_local }} <small class="text-gray-300 text-xxxs">
                                                {{ $system_currency->code }}
                                            </small>
                                        </h6>
                                        @if($item->entry->currency_rate)
                                        <h6 class="text-center text-gray-300">
                                            {{ $item->debit }} <small class="text-gray-300 text-xxxs">
                                                {{ $item->currency->code }}
                                            </small>
                                        </h6>
                                        @endif
                                    </td>


                                    <td>
                                        <h6 class="text-center">
                                            {{ $item->credit_local .' ' . $system_currency->code}}
                                        </h6>
                                        @if($item->entry->currency_rate)
                                        <h6 class="text-center text-gray-300">
                                            {{ $item->credit }} <small class="text-gray-300 text-xxxs">
                                                {{ $item->currency->code }}
                                            </small>
                                        </h6>
                                        @endif
                                    </td>

                                    <td>
                                        <h5 class="text-center fw-bold">
                                            {{ $item->account_balance_local .' ' . $system_currency->code}}
                                        </h5>
                                        @if($item->entry->currency_rate)
                                        <h6 class="text-center text-gray-300">
                                            {{ $item->account_balance }} <small class="text-gray-300 text-xxxs">
                                                {{ $item->currency->code }}
                                            </small>
                                        </h6>
                                        @endif
                                    </td>

                                    <td class="text-center">
                                        <a href="{{ route('sett.acc_entry.show', $item->acc_entry_id) }}"
                                            class="btn btn-sm status-col-link status-col-link not_accepted-color-btn b-r-xs mb-1"
                                            title="edit"><i class="fas fa-eye"></i></a>
                                    </td>

                                </tr>
                                @endforeach

                            </tbody>

                            <tfoot>
                                <tr>
                                    <th class="fw-bold text-s">{{ __('basic.total') }}
                                    </th>
                                    <th class="text-center fw-bold text-s2">
                                        {{ $total_debit }}
                                    </th>
                                    <th class="text-center fw-bold text-s2">
                                        {{ $total_credit }}
                                    </th>
                                    <th class="text-center fw-bold text-s2">
                                        {{ $net_balance }}
                                    </th>
                                    <th></th>
                                </tr>
                            </tfoot>

                        </table>
                    </div>

                </div>
            </div>

        </div>
    </div>


    @endsection

    <!-- js insert -->
    @section('js')

    <!-- select 2 -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-rc.0/js/select2.min.js"
        integrity="sha512-4MvcHwcbqXKUHB6Lx3Zb5CEAVoE9u84qN+ZSMM6s7z8IeJriExrV3ND5zRze9mxNlABJ6k864P/Vl8m0Sd3DtQ=="
        crossorigin="anonymous" referrerpolicy="no-referrer"></script>
    <script>
        $(document).ready(function() {
                $('.js-example-basic-single').select2({
                    dropdownParent: $("#new_record"),
                });

                //hide search
                $('.select2-no-search').select2({
                    minimumResultsForSearch: -1
                });
            });
    </script>

    {{-- data table --}}

    <script>
        $(document).ready(function() {

        var table = $('.p-lab-table').DataTable({
                        lengthChange: false,
                        "pageLength": 10,
                        "order": [
                            [0, "DESC"]
                        ],
                        buttons: {
                            dom: {
                                button: {
                                    className: 'btn btn-table-export me-0' //Primary class for all buttons
                                }
                            },
                            buttons: [{extend: 'copyHtml5',footer: true},
                                { extend: 'excelHtml5', footer: true },
                                { extend: 'pdfHtml5', footer: true },
                                {  extend: 'print', footer: true}
                            ]
                        }
                    }

            );
            table.buttons().container()
                .appendTo('.p-lab-table_wrapper .col-md-6:eq(0)');
    });

    </script>


    <!-- jquery ui datepicker -->
    <script type="text/javascript"
        src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js"></script>
    <script>
        $(function() {
                $('.hasdatetimepicker').datepicker({
                    todayHighlight: true,
                    format: "mm-yyyy",
                    viewMode: "months",
                    minViewMode: "months"
                });
            });
    </script>


    <!-- -- datatables plugin -- -->
    <script type="text/javascript" src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/1.11.3/js/dataTables.bootstrap5.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/2.0.1/js/dataTables.buttons.min.js">
    </script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/2.0.1/js/buttons.bootstrap5.min.js">
    </script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js">
    </script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js">
    </script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/2.0.1/js/buttons.html5.min.js"></script>
    <script type="text/javascript" language="javascript"
        src="https://cdn.datatables.net/buttons/2.0.1/js/buttons.print.min.js"></script>

    <script type="text/javascript" language="javascript"
        src="https://cdn.datatables.net/buttons/2.0.1/js/buttons.colVis.min.js"></script>
    <script
        src="https://nightly.datatables.net/fixedheader/js/dataTables.fixedHeader.js?_=f0de745b101295e88f1504c17177ff49">
    </script>



    <script>
        $(document).ready(function() {


                var table = $('#p-lab-table').DataTable({
                lengthChange: false,
                "pageLength": 10,
                "order": [
                [0, "DESC"]
                ],
                buttons: {
                    dom: {
                    button: {
                    className: 'btn btn-table-export me-0' //Primary class for all buttons
                    }
                    },
                    buttons: [{extend: 'copyHtml5',footer: true},
                    { extend: 'excelHtml5', footer: true },
                    { extend: 'pdfHtml5', footer: true },
                    { extend: 'print', footer: true}
                    ]
                }
                }
                );
                table.buttons().container()
                .appendTo('#p-lab-table_wrapper .col-md-6:eq(0)');
        });

    </script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/flatpickr/4.6.13/flatpickr.min.js"
        integrity="sha512-K/oyQtMXpxI4+K0W7H25UopjM8pzq0yrVdFdG21Fh5dBe91I40pDd9A4lzNlHPHBIP2cwZuoxaUSX0GJSObvGA=="
        crossorigin="anonymous" referrerpolicy="no-referrer"></script>

    <script>
        $(document).ready(function() {

        //-------- datepicker time --------
        $('.datepicker_time').flatpickr({
            mode: "range",
            enableTime: false,
            dateFormat: "Y-m-d",
            locale: {
                rangeSeparator: 'to'
            },
        });

    })

    $('#date_filter').on('change', function(e) {

        var value = $(this).val();

        if(value === "date_between"){
            $('#date_between_cont').show();
        }else{
            $('#date_between_cont').hide();
        }
    });

    </script>


    <script>
        $('.printPage').click(function(){
            window.print();
            return false;
        });
    </script>


    @endsection