@extends('layouts.master')

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

@section('title-topbar', __('basic.trial balance'))


<!-- 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.trial balance') }}</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.trial_balance') }}" 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>

                            </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.trial balance') }}</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>


    <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">
                    <div class="table-responsive">
                        <table class="table display datatable-modal mb-0" id="p-lab-table" width="100%" cellspacing="0">
                            <thead>
                                <tr style="border-bottom: 0px solid transparent;">
                                    <td colspan="2" width="40%">
                                        {{ __('basic.account') }}
                                    </td>

                                    <td width="20%">
                                        {{ __('basic.debit') }}
                                    </td>

                                    <td width="20%">
                                        {{ __('basic.credit') }}
                                    </td>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>

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

                    @php
                    $total_balance_debit = 0;
                    $total_balance_credit = 0;
                    @endphp

                    @foreach ($accounts as $item)

                    <h6 class="text-gray-700 fw-bold">{{$item->main_acc_name }}</h6>

                    @php
                    $total_debit = 0;
                    $total_credit = 0;
                    @endphp

                    @foreach ($item->sub_accounts as $item_acc)

                    <div class="table-responsive px-0 px-md-4">
                        <table class="table display datatable-modal mb-0" id="p-lab-table" width="100%" cellspacing="0">

                            <tbody>
                                <tr>
                                    <td colspan="2" width="40%">
                                        {{ $item_acc->name }}
                                    </td>

                                    <td width="20%">
                                        @php
                                        $total_debit += $item_acc->entry_items->sum('debit_local');
                                        @endphp
                                        {{ $item_acc->entry_items->sum('debit_local') }}
                                    </td>

                                    <td width="20%">
                                        @php
                                        $total_credit += $item_acc->entry_items->sum('credit_local');
                                        @endphp
                                        {{ $item_acc->entry_items->sum('credit_local') }}
                                    </td>
                                </tr>
                            </tbody>


                        </table>
                    </div>

                    @endforeach


                    <!-- Card Header - Dropdown -->
                    <div
                        class="card-header py-3 d-flex flex-row align-items-center justify-content-between mb-3 table_normal_show_total">
                        <div class="table-responsive">
                            <table class="table display datatable-modal mb-0" id="p-lab-table" width="100%"
                                cellspacing="0">
                                <thead>
                                    <tr style="border-bottom: 0px solid transparent;">
                                        <td colspan="2" width="40%" class="fw-bold">
                                            {{ __('basic.total') }}
                                        </td>
                                        <td width="20%" class="fw-bold">
                                            @php
                                            $total_balance_debit += $total_debit;
                                            $total_balance_credit += $total_credit;
                                            @endphp
                                            {{ $total_debit }}
                                        </td>
                                        <td width="20%" class="fw-bold">
                                            {{ $total_credit }}
                                        </td>
                                    </tr>
                                </thead>
                            </table>
                        </div>
                    </div>

                    @endforeach


                    <!-- Card Header - Dropdown -->
                    <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between table_normal_show_total"
                        style="background-color: #e5e5e5;">
                        <div class="table-responsive">
                            <table class="table display datatable-modal mb-0" id="p-lab-table" width="100%"
                                cellspacing="0">
                                <thead>
                                    <tr style="border-bottom: 0px solid transparent;">
                                        <td colspan="2" width="40%" class="fw-bold fs-4">
                                            {{ __('basic.total') }}
                                        </td>
                                        <td width="20%" class="fw-bold fs-4">
                                            {{ $total_balance_debit }}
                                        </td>
                                        <td width="20%" class="fw-bold fs-4">
                                            {{ $total_balance_credit }}
                                        </td>
                                    </tr>
                                </thead>
                            </table>
                        </div>
                    </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>


    <!-- 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