@extends('admin.layout.master')
@section('title', __('obs.ledger_report'))
@section('custom_style')
    <style>
        /* input[type=text],
        input[type=file],
        input[type=number],
        input[type=date] {
            height: 24px !important;
        } */

        .padding_apply {
            padding-left: 1px;
        }

        .table thead th {
            border: 1px solid black !important;
            text-align: center;
            vertical-align: middle;
        }

        .table tbody td {
            border: 1px solid black !important;
            vertical-align: middle;
            padding: 2px 5px;
        }
    </style>
@endsection
@section('content')
    <div class="card sina-card">
        @include('admin.layout.title_header', ['title' => __('obs.ledger_report')])

        <div class="card-body">
            <form action="" method="get" class="mb-0">
                {{-- <form action="{{route(Request::route()->getName())}}" method="get"> --}}
                <div class="row g-2">
                    {{-- @if (current_warehouse() == current_store())
                        <div class="col-md-2">
                            <label for="warehouse_id">{{ __('obs.hotel') }}</label>
                            @include('admin.inputs.warehouse_select', ['index' => true])
                        </div>
                    @endif --}}
                    <div class="col-lg-2 col-md-3">
                        <label for="pay_type">{{ __('obs.c_center') }}</label>
                        {{-- <div class="col-5 px-0">
                        </div>
                        <div class="col-7 px-0"> --}}
                        <div class="d-flex">
                            <select name="cost_center_id" id="cost_center_id" class="form-select select_2">
                                <option value="0">{{ __('obs.all') }}</option>
                                @forelse ($cost_centers as $cost_center)
                                    <option value="{{ $cost_center->id }}">{{ $cost_center->name }}</option>
                                @empty
                                @endforelse
                            </select>
                        </div>
                        {{-- </div> --}}
                    </div>
                    <div class="col-lg-2 col-md-4">
                        <label for="cost_id">{{ __('obs.ledger') }}</label>
                        <div class="d-flex">
                            <select name="ledger_id" id="ledger_id" required class="form-select">
                                @if (Request()->ledger_id)
                                    <option value="{{ Request()->ledger_id }}">
                                        {{ $ledger->name . ' - ' . $ledger->auto_code }}
                                    </option>
                                @endif
                            </select>
                        </div>
                    </div>
                    <div class="col-lg-1 col-md-2">
                        <label for="cost_id">{{ __('obs.skip_zero') }}</label>
                        <div class="d-flex">
                            <select name="skip_zero" class="form-select select_2" id="skip_zero" required>
                                <option value="0" @if (Request()->skip_zero == 0) selected @endif>{{ 'YES' }}
                                </option>
                                <option value="1" @if (Request()->skip_zero == 1) selected @endif>
                                    {{ 'NO' }}</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-lg-1 col-md-2">
                        <label for="cost_id">{{ __('obs.month_wise') }}</label>
                        <div class="d-flex">
                            <select name="monthwise_data" class="form-select select_2" id="monthwise_data" required>
                                <option value="0" @if (Request()->monthwise_data == 0) selected @endif>
                                    {{ 'YES' }}
                                </option>
                                <option value="1" @if (Request()->monthwise_data == 1) selected @endif>
                                    {{ 'NO' }}</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-lg-2 col-md-3">
                        <label for="warehouse_id">{{ __('obs.store') }}</label>
                        <div class="d-flex">
                            <select name="warehouse_id" id="warehouse_id" class="form-select select_2" multiple>
                                @forelse (adminAsignedWarehouseList() as $wh)
                                    <option value="{{ $wh->id }}" {{ $wh->id == Request()->warehouse_id || ($wh->id == current_store() && current_store() != current_warehouse()) ? 'selected' : '' }}>{{ $wh->name_eng }}</option>
                                @empty
                                @endforelse
                            </select>
                        </div>
                    </div>
                    <div class="col-md-1">
                        <label for="approve_status">{{__('obs.status')}}</label>
                        <div class="d-flex">
                            <select name="approve_status" id="approve_status" class="form-select select_2">
                                <option value="">{{__('obs.all')}}</option>
                                <option value="1" selected>{{__('obs.approved')}}</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <label for="cost_id">{{ __('obs.date_range') }}</label>
                        <div class="d-flex">
                            {!! getDateInput('start_date', 'start_date', Request()->start_date) !!}
                            <label class="input-group-text">{{ __('obs.date_to') }}</label>
                            {!! getDateInput('end_date', 'end_date', Request()->end_date) !!}
                            <div class="input-group-append">
                                <button type="button" onclick="getReport()"
                                    class="btn btn-danger h-100">
                                    <span class="fa fa-search"></span>
                                </button>
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-1 col-md-1">
                        <input type="checkbox" name="new" id="new" value="1">
                        <label for="new">{{ __('obs.new') }}</label>
                    </div>
                </div>
            </form>
        </div>

        <div id="">
            <input type="hidden" id="marketing_admin" value="{{ marketing_customer() ? 1 : 0 }}">
            <input type="hidden" id="type" value="{{ $type }}">
            <div class="row" id="divTableDataHolder">
                <div class="col-md-12" id="report_html"> </div>
            </div>
        </div>
    </div>
    @include('admin.global.loader')

@endsection
@section('script')
    <script>
        $(document).ready(() => {
            let ledger_id = $('#ledger_id').val();
            if (ledger_id) {
                getReport();
            }
        })
        $('#ledger_id').select2({
            minimumInputLength: 3,
            // tags: [],
            ajax: {
                url: "{{ route('accounts_settings.ledger_search') }}",
                dataType: 'json',
                type: "GET",
                quietMillis: 50,
                data: function(term) {
                    return {
                        _token: $("input[name='_token']").val(),
                        marketing_admin: $("#marketing_admin").val(),
                        search_type: 2,
                        group_code: null,
                        name: term
                    };
                },
                processResults: function(data) {
                    return {
                        results: $.map(data, function(item) {
                            return {
                                text: item.auto_code + ' -- ' + item.name,
                                id: item.id
                            }
                        })
                    };
                }
            }
        });
        $('#cost_center_id').select2();
        $('#skip_zero').select2();
        const showButton = (type) => {
            if (type == 3) {
                $('.hidden_create_btn').hide();
                $('.hidden_edit_btn').hide();
            } else if (type == 1) {
                $('.hidden_create_btn').show();
                $('.hidden_edit_btn').hide();
            } else {
                $('.hidden_edit_btn').show();
                $('.hidden_create_btn').hide();
            }
        }
        const showHiddenRow = (type) => {
            $('.hidden_row').toggle('slow');
            const rowspan_class = document.getElementsByClassName("rowspan_class");
            for (let i = 0; i < rowspan_class.length; i++) {
                // console.log(rowspan_class[i].getAttribute('data-rowspan'));
                rowspan_class[i].setAttribute('rowspan', (parseInt(rowspan_class[i].getAttribute('rowspan')) > 1 ? 1 :
                    rowspan_class[i].getAttribute('data-rowspan')));
            }
        }
        async function multi_api_yield_calls(urls, pageSize) {
            let start = 0;
            for await (const pageData of fetch_ledger_view_data(urls, pageSize)) {
                //console.log(pageData); // Process each paginated data chunk here
                //console.log(urls[start]);
                if (urls[start].start_page == undefined)
                    $(".item_tbody").append(pageData);
                else
                    setReportHtml(pageData);
                if (urls.length - 1 == start)
                    $('#loader').hide();
                start++;
            }
        }

        function fetchData(url) {
            return new Promise((resolve, reject) => {
                const xhr = new XMLHttpRequest();
                xhr.onreadystatechange = function() {
                    if (xhr.readyState === XMLHttpRequest.DONE) {
                        if (xhr.status === 200) {
                            const data = (xhr.responseText);
                            resolve(data);
                        } else {
                            reject(new Error('Error fetching data'));
                        }
                    }
                };
                xhr.open('GET', url);
                xhr.send();
            });
        }

        function objectToQueryString(obj) {
            const queryString = Object.keys(obj)
                .map(key => `${encodeURIComponent(key)}=${encodeURIComponent(obj[key])}`)
                .join('&');
            return queryString;
        }
        async function* fetch_ledger_view_data(urls, pageSize) {
            let page = 1;
            let total_len = urls.length - 1;
            let link = "{{ route('reports.ledger_view_api') }}";
            for (let i = 0; i < urls.length; i++) {
                if (i > 0)
                    urls[i].only_tr = 1;
                const data = await fetchData(`${link}?${objectToQueryString(urls[i])}`);
                yield data;
                // await ajaxCall(link, 'GET', urls[i], (data) => {
                //     yield data;
                // });
            }
        }

        function formatDateDMY(date) {
            const day = date.getDate();
            const month = date.getMonth() + 1; // Month is 0-indexed
            const year = date.getFullYear();
            return `${day}-${month}-${year}`;
        }

        function getMonthsBetweenDates(startDate, endDate, data_param) {
            let months = [];
            let currentDate = new Date(startDate);
            // Iterate through each month until the endDate
            while (currentDate <= endDate) {
                let input_params = JSON.parse(JSON.stringify(data_param));
                let year = currentDate.getFullYear();
                let month = currentDate.getMonth() + 1; // Month starts from 0
                let monthStartDate = new Date(year, month - 1, 1);
                let monthEndDate = new Date(year, month, 0); // Get last day of month
                // Adjust endDate for the last month
                if (currentDate.getMonth() === endDate.getMonth() && currentDate.getFullYear() === endDate.getFullYear()) {
                    monthEndDate = endDate;
                }
                input_params.start_date = formatDateDMY(monthStartDate);
                input_params.end_date = formatDateDMY(monthEndDate);
                months.push(input_params);
                // months.push({
                //     start: monthStartDate,
                //     end: monthEndDate
                // });
                // Move to the next month
                currentDate.setMonth(currentDate.getMonth() + 1);
            }
            return months;
        }

        function parseDate(dateString) {
            const parts = dateString.split('-');
            // Month is 0-indexed, so subtract 1 from parsed month
            return new Date(parts[2], parts[1] - 1, parts[0]);
        }
        const setReportHtml = data => {
            //$('#report_html').html(data);
            $('#report_html').append(data);
            //$('#loader').hide();
        }

        // // Example usage:
        // const startDate = new Date('2024-03-15'); // Start date
        // const endDate = new Date('2024-07-10'); // End date
        //console.log(monthsBetween);

        const getReport = (with_all_opposite = null) => {
            let ledger_id = $('#ledger_id').val();
            let link = "{{ route('reports.ledger_view_api') }}";
            let data_param = {
                new: $("#new").is(':checked')?1:0,
                type: $("#type").val(),
                cost_center_id: $('#cost_center_id').val(),
                ledger_id: $('#ledger_id').val(),
                skip_zero: $('#skip_zero').val(),
                start_date: $('#start_date').val(),
                end_date: $('#end_date').val(),
                warehouse_id: $('#warehouse_id').val(),
                approve_status: $('#approve_status').val(),
                with_all_opposite: with_all_opposite
            }
            
            const setReportHtml = data => {
                //$('#report_html').html(data);
                $('#report_html').append(data);
                $('#loader').hide();
            }
            if (ledger_id) {
                $('#loader').show();
                $('#report_html').empty();
                var monthwise_data = Number($("#monthwise_data").val());
                //alert(monthwise_data);
                if (monthwise_data) {
                    const startDate = new Date(parseDate(data_param.start_date)); // Start date
                    const endDate = new Date(parseDate(data_param.end_date)); // End date
                    const gen_dates = getMonthsBetweenDates(startDate, endDate, data_param);
                    const len = gen_dates.length - 1;
                    gen_dates[0].start_date = data_param.start_date;
                    gen_dates[0].start_page = 1;
                    gen_dates[len].end_page = 1;
                    multi_api_yield_calls(gen_dates);
                } else
                    ajaxCall(link, 'GET', data_param, setReportHtml);
            } else {
                Swal.fire('please ! Select Ledger First', '', 'warning');
            }
        }
    </script>
@stop