@extends('layouts.app', ['pageSlug' => 'customerlist'])

@section('content')
<div class="splynx_top_nav">
    <div style="float: left">
        <ul class="splynx_breadcrumbs">
            <li><span>Report</span></li>
        </ul>
    </div>
    <div class="clearfix"></div>
</div>
<div class="spl-page-panel">   
    <div class="row">
       @include('admin.customer.report.report-partial')
        <div class="tab-content">
            <div class="tab-pane active" id="balancesheet" role="tabpanel">
                <div class="col-md-12">
                    <h5>Balance Sheet
                    </h5>
                    <br>
                    <form method="GET" action="{{route('customer.balancesheet')}}">
                        <div class="row">
                            <div class="col-md-3">		
                                <div class="form-group">
                                    <label>Min Date</label>
        							<input type="text" name="min" class="form-control report_date" placeholder="Min Date"/ autocomplete="off" value="{{$min != null ? $min : date('y-m-d')}}">
        						</div>
        					</div> 
        					<div class="col-md-3">		
                                <div class="form-group">
                                    <label>Max Date</label>
        							<input type="text" name="max" class="form-control report_date" placeholder="Max Date"/ autocomplete="off" value="{{$max != null ? $max : date('y-m-d')}}">
        						</div>
        					</div>
                            <div class="col-md-3">
            				    <button type="submit" class="btn btn-primary" title="Search" style="margin-top: 20px;">Search</button>
            				</div>
            			</div>
                    </form>
                    <div class="p-3">
                        <table id="custom_table1" class="table table-striped table-bordered">
                            <thead>
                                <th>#</th>
                                <th>Date</th>
                                <th>Title</th>
                                <th>Type</th>
                                <th>Method</th>
                                <th>Receipt No.</th>
                                <th>Income</th>
                                <th>Expenses</th>
                                <th>Balance</th>
                            </thead>
                            <tbody>
                                                                @foreach($allpayments as $pay)
                                @php
                                  $balance = $pay->type == 'income' ?  $balance + $pay->amount : $balance - $pay->amount;
                                @endphp
                                <tr>
                                    <td>{{++$index}}</td>
                                    <td>{{ formatYmd($pay->date) }}</td> 
                                    <td>{{ $pay->title }}</td> 
                                    <td>{{ isset($pay->method) ? $pay->method : '' }}</td> 
                                    <td>{{ isset($pay->paytype) ? $pay->paytype : '' }}</td> 
                                    <td>{{ isset($pay->receipt_no) ? $pay->receipt_no : '' }}</td> 
                                    <td>{{ $pay->type == 'income' ? round($pay->amount,2) : '-'}}</td> 
                                    <td>{{ $pay->type == 'expense' ? round($pay->amount,2) : '-'}}</td> 
                                    <td>{{ round($balance,2)}}</td>
                                </tr>
                                @endforeach
                                @if(count($allpayments) > 0)
                                <tfoot><tr><th></th><th></th><th></th><th></th><th>TOTAL</th><th></th><th></th><th></th><th>{{ round($balance,2)}}</th></tr></tfoot>
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div> 
        </div>
    </div>
</div>

@endsection

@push('js')
<script>
   $(document).ready(function(){

       $('.select2').select2();

       $('.table').dataTable({
            "pageLength": 20, 
            'stateSave': true,
            "footerCallback": function ( row, data, start, end, display ) {
                var api = this.api(), data;
     
                // Remove the formatting to get integer data for summation
                var intVal = function (i) {
                    return typeof i === 'string' ?
                        i.replace(/[\$,]/g, '')*1 :
                        typeof i === 'number' ?
                            i : 0;
                };
     
                // Total over this page
                pageTotal = api
                    .column( 6, { page: 'current'} )
                    .data()
                    .reduce( function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0 );
     
                // Update footer
                $( api.column( 6 ).footer() ).html(
                    pageTotal
                );
            }
        });

       $('#cashout_pdf_btn').click(function(){
        dialog.dialog( "open" );
            
       });

       $( ".report_date" ).datepicker({
            dateFormat : 'yy-mm-dd'
        });
        
   });
    
</script>
    
@endpush