@extends('layouts.app')

@section('sidebar')
    @include('sidebar')
@stop

@section('style')
<style>
    .amount{
        font-size: 16px;
        font-weight: 600;
    }
</style>
@endsection

@section('content')
    <div class="m-subheader ">
        <div class="d-flex align-items-center">
            <div class="mr-auto">
                <h3 class="m-subheader__title ">Statement</h3>
            </div>
            <div>
                <span class="m-subheader__daterange pull-right" id="daterangepicker">
                    <span class="m-subheader__daterange-label">
                        <span class="m-subheader__daterange-title"></span>
                        <span class="m-subheader__daterange-date m--font-brand"></span>
                    </span>
                    <a href="#" class="btn btn-sm btn-brand m-btn m-btn--icon m-btn--icon-only m-btn--custom m-btn--pill">
                        <i class="la la-angle-down"></i>
                    </a>
                </span>
            </div>
        </div>
    </div>
    <div class="m-content">
        <div class="m-portlet m-portlet--full-height ">
            <div class="m-portlet__head">
                <div class="m-portlet__head-caption">
                    <div class="m-portlet__head-title">
                        <h3 class="m-portlet__head-text">
                            All Statement
                        </h3>
                    </div>
                </div>

                <!-- Export Option Start -->
                <div class="m-portlet__head-tools">
                    <ul class="m-portlet__nav">
                        <li class="m-portlet__nav-item m-dropdown m-dropdown--inline m-dropdown--arrow m-dropdown--align-right m-dropdown--align-push pull-right" m-dropdown-toggle="hover" aria-expanded="true">
                            <a href="#" class="m-portlet__nav-link m-dropdown__toggle dropdown-toggle btn btn--sm m-btn--pill btn-secondary m-btn m-btn--label-brand">
                                Export
                            </a>
                            <div class="m-dropdown__wrapper" style="z-index: 101;">
                                <span class="m-dropdown__arrow m-dropdown__arrow--right m-dropdown__arrow--adjust" style="left: auto; right: 36px;"></span>
                                <div class="m-dropdown__inner">
                                    <div class="m-dropdown__body">
                                        <div class="m-dropdown__content">
                                            <ul class="m-nav">
                                                <li class="m-nav__section m-nav__section--first">
                                                    <span class="m-nav__section-text">Export Tools</span>
                                                </li>
                                                <li class="m-nav__item">
                                                    <a href="#" class="m-nav__link" id="export_print">
                                                        <i class="m-nav__link-icon la la-print"></i>
                                                        <span class="m-nav__link-text">Print</span>
                                                    </a>
                                                </li>
                                                <li class="m-nav__item">
                                                    <a href="#" class="m-nav__link" id="export_excel">
                                                        <i class="m-nav__link-icon la la-file-excel-o"></i>
                                                        <span class="m-nav__link-text">Excel</span>
                                                    </a>
                                                </li>
                                            </ul>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </li>
                    </ul>
                </div>
                <!-- Export Option End -->
            </div>

            
            <div class="m-portlet__body">
                {{--@if(Session::has('success'))--}}
                    {{--<div class="alert alert-success">--}}
                        {{--{!! Session::get('success') !!}--}}
                    {{--</div>--}}
                {{--@endif--}}
                @php
                    $totals = [
                        'deposit_usd' => 0, 'deposit_inr' => 0,
                        'withdraw_usd' => 0, 'withdraw_inr' => 0,
                        'available_usd' => 0, 'available_inr' => 0,
                    ];
                @endphp

                <table class="m_datatable table table-striped- table-bordered table-hover table-checkable" id="statement">
                    <thead>
                    <tr>
                        <th>Bank Name</th>
                        <th>Type</th>
                        <th>Total Deposit</th>
                        <th>Total Withdraw</th>
                        <th>Available</th>
                    </tr>
                    </thead>
                    <tbody>
                        @foreach ($finalOutput as $data)
                         @php
                            $totals['deposit_usd'] += $data['total_deposit_amount_dollar'];
                            $totals['deposit_inr'] += $data['total_deposit_amount_inr'];
                            $totals['withdraw_usd'] += $data['total_withdraw_amount_dollar'];
                            $totals['withdraw_inr'] += $data['total_withdraw_amount_inr'];
                            $totals['available_usd'] += $data['available_dollar'];
                            $totals['available_inr'] += $data['available_inr'];
                        @endphp
                            <tr>
                                @if($data['type'] == 'WireTransfer')
                                    <td><a href="{{ url('wire-bank/statement/'.Hasher::encode($data['bank_id']).'?startDate='.$newstartDate.'&endDate='.$newendDate) }}" target="_blank">{{ $data['name'] ?? 'N/A' }}</a></td>
                                @elseif($data['type'] == 'LocalExchange')
                                    <td><a href="{{ url('local-exchange/statement/'.Hasher::encode($data['bank_id']).'?startDate='.$newstartDate.'&endDate='.$newendDate) }}" target="_blank">{{ $data['name'] ?? 'N/A' }}</a></td>
                                @else
                                    <td><a href="{{ url('crypto/statement/'.Hasher::encode($data['bank_id']).'?startDate='.$newstartDate.'&endDate='.$newendDate) }}" target="_blank">{{ $data['name'] ?? 'N/A' }}</a></td>
                                @endif
                                    
                                <td>{{ $data['type'] }}</td>
                                <td><span class="amount text-success">{{ number_format($data['total_deposit_amount_dollar'], 2) }}</span> USD <br> <span class="amount text-brand">{{ number_format($data['total_deposit_amount_inr'], 2) }}</span> {{ $data['name'] == 'UAE OFFICE' ? 'AED' : ($data['name'] == 'Mobile Money' ? 'GHS' : ($data['name'] == 'Mau Bank Ltd' ? 'USD' : 'INR')) }}</td>
                                <td><span class="amount text-danger">{{ number_format($data['total_withdraw_amount_dollar'], 2) }}</span> USD <br> <span class="amount">{{ number_format($data['total_withdraw_amount_inr'], 2) }}</span> {{ $data['name'] == 'UAE OFFICE' ? 'AED' : ($data['name'] == 'Mobile Money' ? 'GHS' : ($data['name'] == 'Mau Bank Ltd' ? 'USD' : 'INR')) }} </td>
                                <td><span class="amount text-primary">{{ number_format($data['available_dollar'], 2) }}</span> USD <br><span class="amount">{{ number_format($data['available_inr'], 2) }}</span> {{ $data['name'] == 'UAE OFFICE' ? 'AED' : ($data['name'] == 'Mobile Money' ? 'GHS' : ($data['name'] == 'Mau Bank Ltd' ? 'USD' : 'INR')) }}</td>
                            </tr>
                        @endforeach
                        
                       <tfoot style="background: rgba(0, 0, 0, 0.2);
    box-shadow: #c4c5d6 0px 5px 15px; font-size : 15px">
<tr >
    <th colspan="2">Total</th>
    <th>
        <span class="text-success">{{ number_format($totals['deposit_usd'], 2) }}</span> USD <br>
        <span class="text-brand">{{ number_format($totals['deposit_inr'], 2) }}</span> INR
    </th>
    <th>
        <span class="text-danger">{{ number_format($totals['withdraw_usd'], 2) }}</span> USD <br>
        <span>{{ number_format($totals['withdraw_inr'], 2) }}</span> INR
    </th>
    <th>
        <span class="text-primary">{{ number_format($totals['available_usd'], 2) }}</span> USD <br>
        <span>{{ number_format($totals['available_inr'], 2) }}</span> INR
    </th>
</tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection

@section('script')
    {{ Html::script('custom/datatables/datatables.bundle.js') }}
    {{ Html::script('custom/eModal/eModal.js') }}
    <script type="text/javascript">
        var startDate = "{{ $startDate }}";
        var endDate = "{{ $endDate }}";
        
        var table;
        $(document).ready(function () {
            // DataTable initialization
            table = $('#statement').DataTable({
                // Export Buttons Start
                buttons: [
                    // Print Button
                    {
                        action: function (e, dt, button, config) {
                            dt.one('preXhr', function (e, s, data) {
                                data.length = -1;
                            }).one('draw', function (e, settings, json, xhr) {
                                var printButtonConfig = $.fn.DataTable.ext.buttons.print;
                                var addOptions = {
                                    exportOptions: {
                                        rows: ':visible',
                                        columns: [0, 1, 2, 3, 4]
                                    },
                                    title: '',
                                    messageTop: '<img alt="Logo" src="{{ asset("images/logo.png") }}" height="50px" width="150px" style="display: block;margin-left: auto;margin-right: auto;"><br><h3 style="font-size: 12px; text-align: center;">Suite 305 , Griffith Corporate Center , Beachmount, Kngstown , St. Vincent and the Grenadines.</h3><br><div style="border-bottom: 5px solid #C0C0C0;"></div><br>'
                                };
                                $.extend(true, printButtonConfig, addOptions);
                                printButtonConfig.action(e, dt, button, printButtonConfig);
                            }).draw();
                        }
                    },
                    // Export As Excel
                    {
                        action: function (e, dt, button, config) {
                            dt.one('preXhr', function (e, s, data) {
                                data.length = -1;
                            }).one('draw', function (e, settings, json, xhr) {
                                var exelButtonConfig = $.fn.DataTable.ext.buttons.excelHtml5;
                                var addOptions = {
                                    exportOptions: {
                                        rows: ':visible',
                                        columns: [0, 1, 2, 3, 4]
                                    },
                                    filename: function () {
                                        var d = new Date();
                                        var n = d.getTime();
                                        return 'SevenStarFX_' + n;
                                    }
                                };
                                $.extend(true, exelButtonConfig, addOptions);
                                exelButtonConfig.action(e, dt, button, exelButtonConfig);
                            }).draw();
                        }
                    }
                ],
                // Export Buttons End
                'responsive': true,
                'searchDelay': 500,
                'processing': true,
                "oLanguage": {
                    "sProcessing": '<div class="m-loader m-loader--brand m-loader--left"><span>Please wait...</span></div>',
                },
                "order": [[0, "desc"]]
            });

            // Export DataTables buttons
            $('#export_print').on('click', function (e) {
                // Page BlockUI
                $.blockUI({ message: '<img src="{{ URL::to("images/loading.svg") }}" height="100%" width="100%" />', css: { border: 'none', backgroundColor: 'transparent', top: '0%', bottom: '0%' } });
                
                e.preventDefault();
                table.button(0).trigger();
                
                setTimeout(function () {
                    $.unblockUI();
                }, 3000);
            });

            $('#export_excel').on('click', function (e) {
                // Page BlockUI
                $.blockUI({ message: '<img src="{{ URL::to("images/loading.svg") }}" height="100%" width="100%" />', css: { border: 'none', backgroundColor: 'transparent', top: '0%', bottom: '0%' } });
                
                e.preventDefault();
                table.button(1).trigger();
                
                setTimeout(function () {
                    $.unblockUI();
                }, 3000);
            });
        });

        /*** Start Date Range Filter ***/
        jQuery(document).ready(function () {
    Daterangepicker.init();
});
var isFirstTime = true;
var Daterangepicker = function () {
    var daterangepickerInit = function () {
        if ($('#daterangepicker').length == 0) {
            console.error('Daterangepicker element not found!');
            return;
        }

        var picker = $('#daterangepicker');
        var start = moment('{{ $startDate }}', 'YYYY-MM-DD');
        var end = moment('{{ $endDate }}', 'YYYY-MM-DD');
        
        if (!start.isValid()) {
            console.error('Invalid startDate format!');
            start = moment(); // Default to the current date
        }
        if (!end.isValid()) {
            console.error('Invalid endDate format!');
            end = moment(); // Default to the current date
        }

        // Callback for updating UI with selected date range
        function cb(start, end) {
            var title = '';
            var range = '';

            if (start.isSame(moment(), 'day')) {
                title = 'Today:';
                range = start.format('MMM D');
            } else if (start.isSame(moment().subtract(1, 'days'), 'day')) {
                title = 'Yesterday:';
                range = start.format('MMM D');
            } else {
                range = start.format('D MMM YY') + ' - ' + end.format('D MMM YY');
            }

            // Update the UI elements with the selected date range
            picker.find('.m-subheader__daterange-date').html(range);
            picker.find('.m-subheader__daterange-title').html(title);
            
            // Call reloadData to handle the date change
            reloadData(start, end);
        }

        // Function to reload data based on the selected date range
        function reloadData(start, end) {
            if(isFirstTime){
                isFirstTime = false;
                return;
            }
                
            var startDate = start.format('YYYY-MM-DD');
            var endDate = end.format('YYYY-MM-DD');

            console.log("Reloading data with:", startDate, endDate); // Debugging line to ensure this is being called

            // Example: Replace `base_url` with your actual base URL variable
            window.location.href = base_url + '/super-admin/bank-statement?startDate=' + startDate + '&endDate=' + endDate;
            
            // Block page UI during processing
            mApp.blockPage({
                overlayColor: '#000000',
                type: 'loader',
                state: 'primary',
                message: 'Processing...'
            });
        }

        // Initialize the daterangepicker
        picker.daterangepicker({
            locale: {
                format: 'DD/MM/YYYY'
            },
            direction: mUtil.isRTL(),
            startDate: start,
            endDate: end,
            opens: 'left',
            ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
                'This Year': [moment().startOf('year'), moment().endOf('year')],
                'Last Year': [moment().subtract(364, 'days'), moment()],
                'All time': [moment().subtract(30, 'year').startOf('month'), moment().endOf('month')]
            }
        }, cb);

        // Initial call to update UI with selected date range
        cb(start, end);
    }

    return {
        init: function () {
            daterangepickerInit();
        }
    };
}();


    </script>
@endsection