@extends('layouts.master')

@section('title', 'General Ledger Entry | Alboosh - Timeless authenticity, born of the desert')

@section('title-topbar', __('basic.general ledger'))


<!-- 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.quotation') }}</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="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.general_ledger') }}" 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" required>

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

                                    <div class="me-2 mb-3">
                                        <label class="form-label">{{ __('basic.account') }}
                                            <small>({{ __('basic.required') }})</small></label>
                                        <select name="account_serc"
                                            class="js-example-basic-single js-example-basic-single select2-hidden-accessible">
                                            <option value="all">{{ __('basic.all') }}</option>
                                            @foreach ($accounts_filter as $item)
                                            <option value="{{ $item->id }}">
                                                {{ $item->name . " - ". $item->code }}
                                            </option>
                                            @endforeach
                                        </select>
                                    </div>


                                </div>

                            </div>

                            <div class="modal-footer">
                                <div class="left-side">
                                    <button type="button" class="btn btn-default btn-link" data-bs-dismiss="modal">Never
                                        Mind</button>
                                </div>
                                <div class="divider"></div>
                                <div class="right-side">
                                    <button type="submit" class="btn btn-default btn-link main-color">Search</button>
                                </div>
                            </div>
                        </div>
                    </form>

                </div>

            </div>
        </div>

    </div>


    <div class="text-center mb-4">
        <h5 class="fw-bold">{{ __('basic.general ledger') }}</h5>
        <h6 class="text-gray-500">{{ $company_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>
    @foreach ($accounts as $item)

    <div class="row mb-0">

        <div class="col-12">

            <div class="card card-input shadow mb-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>
                        {{ $item->name }} <span> {{ $item->code }}</span></h6>
                </div>


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

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

                            @php
                            $total_debit = 0;
                            $total_credit = 0;
                            $total_amount = 0;
                            @endphp
                            <tbody>
                                @foreach ($item->entry_items as $item_ent)
                                <tr>

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

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

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

                                    <td>
                                        {{ $item_ent->entry->worker->full_name}}
                                    </td>

                                    <td>
                                        @php
                                        $total_debit += $item_ent->debit_local;
                                        @endphp
                                        @if($item_ent->debit_local !== '0.00')
                                        {{ $item_ent->debit_local }} <small class="text-gray-300 text-xxxs">
                                            {{ $system_currency->code }}
                                        </small>
                                        @endif
                                    </td>

                                    <td>
                                        @php
                                        $total_credit += $item_ent->credit_local;
                                        @endphp
                                        @if($item_ent->credit_local !== '0.00')
                                        {{ $item_ent->credit_local }} <small class="text-gray-300 text-xxxs">
                                            {{ $system_currency->code }}
                                        </small>
                                        @endif
                                    </td>

                                    <td>
                                        @php
                                        //if it is credit
                                        if ($item->origin == 0) {
                                        if ($item_ent->credit_local > 0) {
                                        //more credit and the acc origin is credit, balance will be +
                                        $new_acc_balance = $item_ent->credit_local + $total_amount;
                                        } else {
                                        //more debit and the acc origin is credit, balance will be -
                                        $new_acc_balance = $total_amount - $item_ent->debit_local;
                                        }
                                        } else {
                                        if ($item_ent->debit_local > 0) {
                                        //more debit and the acc origin is debit, balance will be +
                                        $new_acc_balance = $item_ent->debit_local + $total_amount;
                                        } else {
                                        //more credit and the acc origin is debit, balance will be -
                                        $new_acc_balance = $total_amount - $item_ent->credit_local;
                                        }
                                        }
                                        @endphp
                                        <p class="text-center fw-bold">
                                            {{ $new_acc_balance }} <small class="text-gray-300 text-xxxs">
                                                {{ $system_currency->code }}
                                            </small>

                                            @php
                                            $total_amount = $new_acc_balance;
                                            @endphp
                                        </p>
                                    </td>

                                    <td class="text-center hide_in_print">
                                        <a href="{{ route('sett.acc_entry.show', $item_ent->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 colspan="2" class="text-start fw-bold text-s">{{ __('basic.total') }}</th>
                                    <th class="fw-bold text-s2">
                                        {{ $total_debit }} <small class="text-gray-300 text-xxxs"></small>
                                    </th>
                                    <th class="fw-bold text-s2">
                                        {{ $total_credit }} <small class="text-gray-300 text-xxxs"></small>
                                    </th>
                                    <th class="fw-bold text-s2 text-center">
                                        {{ $total_amount }} <small class="text-gray-300 text-xxxs"></small>
                                    </th>
                                    <th></th>
                                </tr>
                            </tfoot>


                        </table>
                    </div>

                </div>
            </div>

        </div>
    </div>

    @endforeach

    <div class="d-flex mt-4 justify-content-end">
        {{ $accounts->appends(request()->input())->links() }}
    </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>


    <!-- datapicker date and time -->
    <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 src="https://fastly.jsdelivr.net/npm/flatpickr@4.6.13/dist/plugins/monthSelect/index.min.js"></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