@extends('layouts.app')

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

@section('style')
<style>
</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">
                            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--}}

                <table class="m_datatable table table-striped- table-bordered table-hover table-checkable" id="ib-report">
                    <thead>
                    <tr>
                        <th>Account No</th>
                        <th>Name</th>
                        <th>Deposit</th>
                        <th>Withdraw</th>
                        <th>IN/OUT</th>
                        <th>Volume</th>
                        <th>Profit</th>
                        <th>Floating PnL</th>
                        <th>Equity</th>
                        <th>Prev Balance</th>
                    </tr>
                    </thead>
                    <tbody></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 ac_no = "{{ $account_no }}";
        var startDate = "{{ $startDate }}";
        var endDate = "{{ $endDate }}";
        var table,startDateDataTable,endDateDataTable;
        $(document).ready(function () {
            Daterangepicker.init();
                $('#ib-report').each(function() {
                    table = $(this).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,5,6,7,8,9]
                                        },
                                        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,5,6,7,8,9]
                                        },
                                        title : '',
                                        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':!0,
                        'searchDelay':500,
                        'processing':!0,
                        "oLanguage": {
                            "sProcessing": '<div class="m-loader m-loader--brand m-loader--left"><span>Please wait...</span></div>',
                        },
                        "serverSide": true,
                        "ajax": {
                            "url": base_url+"/ib-report-datatable/"+ac_no+"?startDate="+startDate+"&endDate="+endDate,
                            "type": "GET",
                            "data": function(d) {
                                d.startDate = startDateDataTable;
                                d.endDate = endDateDataTable;
                            },
                        },
                        "order": [[ 0, "desc" ]],
                        "dom":
                            "<'row'<'col-sm-12'tr>>" +
                            "<'row'<'col-sm-12 col-md-6'l><'col-sm-12 col-md-6'p>>",
                        "aoColumns": [
                            { data: 'LOGIN', name: 'LOGIN'},
                            { data: 'NAME', name: 'NAME'},
                            { data: 'TDEPOSIT', name: 'TDEPOSIT'},
                            { data: 'TWITHDRAW', name: 'TWITHDRAW'},
                            { data: 'inout', name: 'inout'},
                            { data: 'TLOT', name: 'TLOT'},
                            { data: 'TPROFIT', name: 'TPROFIT'},
                            { data: 'floatingPnL', name: 'floatingPnL'},
                            { data: 'EQUITY', name: 'EQUITY'},
                            { data: 'PREVBALANCE', name: 'PREVBALANCE'},
                        ]
                    });

                    // Export Datatables
				 $('#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);
				});
            //  ------------------------------------------------ Code of Search For Live Client Start -----------------------------------------

            

                   
                });
            });
       
    var isFirstTime = true;
    var Daterangepicker = function() {
        var daterangepickerInit = function(e) {
            if ($('#daterangepicker').length == 0) {
                return;
            }

            var picker = $('#daterangepicker');
            var starts = moment();
            var start = moment('{{$startDate}}');
            var end = moment('{{$endDate}}');
            function cb(start, end) {
                var title = '';
                var range = '';
                if (start.date() == moment().date()) {
                    title = 'Today:';
                    range = start.format('MMM D');
                } else if (start.date() == moment().subtract(1, 'days').date()) {
                    title = 'Yesterday:';
                    range = start.format('MMM D');
                } else {
                    range = start.format('D MMM YY') + ' - ' + end.format('D MMM YY');
                }
                picker.find('.m-subheader__daterange-date').html(range);
                picker.find('.m-subheader__daterange-title').html(title);
                reloadData(start,end);
            }
            function reloadData(start,end){
                if(isFirstTime){
                    isFirstTime = false;
                    return;
                }
                var startDate = start.format('YYYY-MM-DD');
                var endDate = end.format('YYYY-MM-DD');
                window.location.href = base_url+"/ib-report/"+ac_no+"?startDate="+startDate+"&endDate="+endDate;
                mApp.blockPage({
                    overlayColor: '#000000',
                    type: 'loader',
                    state: 'primary',
                    message: 'Processing...'
                });
            }
            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()],
                    // 'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')],
                    'All time': [moment().subtract(30, 'year').startOf('month'), moment().endOf('month')],
                }
            }, cb);

            cb(start, end);
        }
        return {
            init: function() {
                daterangepickerInit();
            }
        };
    }();
    </script>
@endsection