@extends('layouts.template')

@section('template')
<!-- Content Header -->
<section class="content-header">
    <h1>
        GROUP Expense Account Ledger 
            @if(isset($expense_account_ledgers))
            :: 
            <span class="text text-danger">{{ $current_expense_group->name }}</span>
            @endif
        </h1>
    <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
        <li class="active">Group Expense Account Ledger</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content">
    
            <div class="row">

            <div class="col-md-12">
                <div class="panel panel-primary">
                    <div class="panel-heading">     
                    List Expense
                    </div>

                    <div class="panel-body"> 
                    <div class="col-md-12">
                        <form class="form" action="{{ url('ledger/expense/group') }}" id="date_form" method="post">
                            {!! csrf_field() !!}
                            <input type="hidden" name="_token" value="{{ csrf_token() }}">   
                            <div class="col-md-3">
                                
                                <div class="form-group">
                                    <label for="">Select a group*</label>
                                    <select name="id" id="id" class="form-control select2"  required onchange='if(this.value != "") { this.form.submit(); }'> 
                                        <option value="">---Select---</option>
                                    @foreach($expenseGroups as $data)
                                        <option value="{{ $data->id }}">{{ $data->name }}</option>
                                    @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-9">

                            </div>  
                        </form>
                    </div> 
                    </div>  
                </div>
            </div>
                <div class="col-md-12">
                <div class="panel panel-primary">          
                    <div class="panel-heading">     
                    List Transaction
                    </div>

                    <div class="panel-body"> 
                    <div class="col-md-12">              
                    <div class="table-responsive">
                        <table class="table-bordered" id="" width="100%">
                            <thead>
                                <tr>
                                    <th style="text-align:left" height="30">Srl</th>
                                    <th style="text-align:left">Date</th>
                                    <th style="text-align:left">Account</th>
                                    <th style="text-align:left">Particular</th>
                                    <th style="text-align:left">Debit</th>
                                    <th style="text-align:left">Credit</th>
                                </tr>
                            </thead>

                            <tbody>
                                @php $sum_debit = 0; $sum_credit = 0;  @endphp
                                @if(isset($expense_account_ledgers))
                                
                                
                                @php 
                                    $sum_debit += 0;
                                    $sum_credit += 0; 
                                @endphp
                                @endif
                                @if(isset($expense_account_ledgers))
                                    @foreach($expense_account_ledgers as $key => $expense_account_ledger)
                                    <tr>
                                        <td>{{ ++$key}}</td>
                                        <td>{{ $expense_account_ledger->date }}</td>
                                        <td>{{ $expense_account_ledger->expense_head }}</td>
                                        <td>{{ $expense_account_ledger->description }}</td>
                                        <td style="text-align:right">{{ number_format($expense_account_ledger->amount,2) }}</td>
                                        <td style="text-align:right">0.00</td>
                                    </tr>
                                    @php $sum_debit += $expense_account_ledger->amount; $sum_credit += 0; @endphp
                                    @endforeach
                                @endif
                            </tbody>

                            <tbody>
                                <tr>
                                    <th style="text-align:left" colspan="4">Total</th>
                                    <th style="text-align:right">{{ number_format($sum_debit,2) }}</th>
                                    <th style="text-align:right">{{ number_format($sum_credit,2) }}</th>
                                </tr>
                                <tr>
                                    <th style="text-align:left" colspan="5">Balance</th>
                                    @if($sum_credit-$sum_debit > 0)
                                    <th style="text-align:right">{{ number_format($sum_credit-$sum_debit,2) }} Cr</th>
                                    @else
                                    <th style="text-align:right">{{ number_format($sum_debit-$sum_credit,2) }} Dr</th>
                                    @endif  
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>    
        </div>
    </div>
</section>
<!-- End Main Content -->
@endsection

<script>
    $("#submit").click(function() {   //button id
        var myForm = $("#dateform");  //form id
        myForm.submit(function(e){
        e.preventDefault();
        var formData = myForm.serialize();
            $.ajax({
                url:'{{url('report/date-to-date-sales-report')}}',
                type:'post',
                data:formData,
                success:function(data){
                //  alert('Successfully Retrived');
                //  $('#start_date,#end_date').val('');
                },
                error: function (data) {
                    alert('Something Went Wrong');
                }
            });
        });
    });    
</script>