@extends('layout.main') @section('content')
@if(session()->has('message'))
  <div class="alert alert-success alert-dismissible text-center"><button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>{!! session()->get('message') !!}</div> 
@endif
<section class="forms">
    <div class="container-fluid">
        <h3>{{trans('file.Account Statement')}}</h3>
        <strong>{{trans('file.Account')}}:</strong> {{$lims_account_data->name}} [{{$lims_account_data->account_no}}]
    </div>
    <div class="table-responsive mb-4">
        <table id="account-table" class="table table-hover">
            <thead>
                <tr>
                    <th class="not-exported"></th>
                    <th>{{trans('file.date')}}</th>
                    <th>{{trans('file.reference')}}</th>
                    <th>{{trans('file.Credit')}}</th>
                    <th>{{trans('file.Debit')}}</th>
                    <th>{{trans('file.Balance')}}</th>
                </tr>
            </thead>
            <tbody>
                @foreach($credit_list as $key=>$credit)
                @php $balance = $balance + $credit->amount; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($credit->created_at->toDateString()))}}</td>
                    <td>{{$credit->payment_reference}}</td>
                    <td class="text-right">{{number_format((float)$credit->amount, 0, '.', '.')}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($recieved_money_transfer_list as $key=>$recieved_money)
                @php $balance = $balance + $recieved_money->amount; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($recieved_money->created_at->toDateString()))}}</td>
                    <td>{{$recieved_money->reference_no}}</td>
                    <td class="text-right">{{number_format((float)$recieved_money->amount, 0, '.', '.')}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($debit_list as $key=>$debit)
                @php $balance = $balance - $debit->amount; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($debit->created_at->toDateString()))}}</td>
                    <td>{{$debit->payment_reference}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$debit->amount, 0, '.', '.')}}</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($return_list as $key=>$return)
                @php $balance = $balance - $return->grand_total; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($return->created_at->toDateString()))}}</td>
                    <td>{{$return->reference_no}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$return->grand_total, 0, '.', '.')}}</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($purchase_return_list as $key=>$return)
                @php $balance = $balance + $return->grand_total; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($return->created_at->toDateString()))}}</td>
                    <td>{{$return->reference_no}}</td>
                    <td class="text-right">{{number_format((float)$return->grand_total, 0, '.', '.')}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($expense_list as $key=>$expense)
                @php $balance = $balance - $expense->amount; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($expense->created_at->toDateString()))}}</td>
                    <td>{{$expense->reference_no}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$expense->amount, 0, '.', '.')}}</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($payroll_list as $key=>$payroll)
                @php $balance = $balance - $payroll->amount; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($payroll->created_at->toDateString()))}}</td>
                    <td>{{$payroll->reference_no}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$payroll->amount, 0, '.', '.')}}</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach

                @foreach($sent_money_transfer_list as $key=>$sent_money)
                @php $balance = $balance - $sent_money->amount; @endphp
                <tr>
                    <td class="text-center">{{$key}}</td>
                    <td class="text-center">{{date($general_setting->date_format, strtotime($sent_money->created_at->toDateString()))}}</td>
                    <td>{{$sent_money->reference_no}}</td>
                    <td class="text-right">0</td>
                    <td class="text-right">{{number_format((float)$sent_money->amount, 0, '.', '.')}}</td>
                    <td class="text-right">{{number_format((float)$balance, 0, '.', '.')}}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</section>

<script type="text/javascript">
    $("ul#account").siblings('a').attr('aria-expanded','true');
    $("ul#account").addClass("show");
    $("ul#account #account-statement-menu").addClass("active");

    $("table").css({ "color": "#000000" });
    $("th").css({ "border": "1px solid #333333", "text-align": "center" });
    $("td").css({ "border": "1px solid #333333" });

    var table = $('#account-table').DataTable( {
        "order": [],
        'language': {
            'lengthMenu': '_MENU_ {{trans("file.records per page")}}',
             "info":      '<small>{{trans("file.Showing")}} _START_ - _END_ (_TOTAL_)</small>',
            "search":  '{{trans("file.Search")}}',
            'paginate': {
                    'previous': '<i class="dripicons-chevron-left"></i>',
                    'next': '<i class="dripicons-chevron-right"></i>'
            }
        },
        'columnDefs': [
            {
                "orderable": false,
                'targets': 0
            },
            {
                'render': function(data, type, row, meta){
                    if(type === 'display'){
                        data = '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>';
                    }

                   return data;
                },
                'checkboxes': {
                   'selectRow': true,
                   'selectAllRender': '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>'
                },
                'targets': [0]
            }
        ],
        'select': { style: 'multi',  selector: 'td:first-child'},
        'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
        dom: '<"row"lfB>rtip',
        buttons: [
            {
                extend: 'pdf',
                text: '{{trans("file.PDF")}}',
                exportOptions: {
                    columns: ':visible:Not(.not-exported)',
                    rows: ':visible'
                }
            },
            {
                extend: 'csv',
                text: '{{trans("file.CSV")}}',
                exportOptions: {
                    columns: ':visible:Not(.not-exported)',
                    rows: ':visible'
                }
            },
            {
                extend: 'print',
                text: '{{trans("file.Print")}}',
                messageTop: function(){
                    return `
                        <div> 
                            <div style="display:flex;justify-content: center">
                                <div style="padding-right: 15px"> 
                                    <img src="{{url('public/logo', $general_setting->site_logo)}}" width="65">
                                </div>
                                <div> 
                                    <h4 style="text-align:left;color:red;">{{trans('file.Company name system')}}</h4> 
                                    <p style="text-align:left;color:red;">{{trans('file.Company address system')}}</p> 
                                </div>
                            </div>
                            <div style="text-align:center;">         
                                <br>                
                                <h3 style="text-transform: uppercase" class="modal-title text-center container-fluid">{{trans('file.Account Statement')}}</h3>
                            </div>
                        </div>
                    `;
                },
                exportOptions: {
                    columns: ':visible:Not(.not-exported)',
                    rows: ':visible'
                },
                customize: function ( doc ) {
                    $(doc.document.body).find('table td').css('border', '1px solid #333333');
                    $(doc.document.body).find('table th').css({'border': '1px solid #333333', "text-align": "center"});;
                    $(doc.document.body).find('table td:nth-child(1)').css('text-align', 'center');
                    $(doc.document.body).find('table td:nth-child(3), table td:nth-child(4), table td:nth-child(5)').css('text-align', 'right');
                },
            },
            {
                extend: 'colvis',
                text: '{{trans("file.Column visibility")}}',
                columns: ':gt(0)'
            },
        ],
    } );

</script>
@endsection