@extends('layouts.template')

@section('template')
<!-- Content Header -->
<section class="content-header">
    <h1>
        Expense Account Ledger 
            @if(isset($expense_account_ledgers))
            :: 
            <span class="text text-danger">{{ $current_expense_account->expense_head }}</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">Expense Account Ledger</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content">
    
            <div class="row">
                <!--
                <div class="col-md-3"> 
                    <div class="panel panel-default">
                        <div class="panel-body">
                    <h4><i class="fa fa-plus" aria-hidden="true"></i> Transaction</h4>
                    <form class="form" action="{{ url('expense/store') }}" method="post">
                        {{ csrf_field() }}
                        <div class="form-group">
                            <label for="">Date*</label>
                            <input type="date" name="date" class="form-control" value="@php echo date('Y-m-d'); @endphp"/>
                        </div>
                        <div class="form-group">
                            <label for="">Head Name*</label>
                            <select name="expense_head_id" class="form-control" required>
                                <option value="">--- Select ---</option>
                                @foreach($expenseAccounts as $key => $expenseAccount)
                                <option value="{{ $expenseAccount->expense_head_id }}">{{ $expenseAccount->expense_head }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="">Amount*</label>
                            <input type="number" name="amount" class="form-control" placeholder="Ënter Amount" required/>
                            @if($errors->has('amount'))
                                <span class="text-danger">{{ $errors->first('amount')}}</span>
                            @endif
                        </div>
                        <div class="form-group">
                            <label for="">Description</label>
                            <textarea rows="2" name="description" class="form-control"  placeholder="Description about head" ></textarea>
                        </div>
                        <div class="form-group">
                            <label for="">Pay Via</label>
                            <select name="bank_account_id" class="form-control" required>
                                <option value="">--- Select ---</option>
                                @foreach($accounts as $key => $account)
                                <option value="{{ $account->bank_account_id }}">{{ $account->bank_name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group">
                            <input type="submit" class="btn btn-success" value="Create"/>
                        </div>
                    </form>
                    @if(Session::has('success'))
                    <div class="alert alert-success" id="success">
                        {{Session::get('success')}}
                        @php
                        Session::forget('success');
                        @endphp
                    </div>
                    @endif
                    @if(Session::has('update'))
                    <div class="alert alert-warning" id="update">
                        {{Session::get('update')}}
                        @php
                        Session::forget('update');
                        @endphp
                    </div>
                    @endif
                    @if(Session::has('delete'))
                    <div class="alert alert-danger" id="delete">
                        {{Session::get('delete')}}
                        @php
                        Session::forget('delete');
                        @endphp
                    </div>
                    @endif
                </div>
            </div>
        </div>
    -->
            <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') }}" 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 an Account*</label>
                                    <select name="expense_head_id" id="expense_head_id" class="form-control select2"  required onchange='if(this.value != "") { this.form.submit(); }'> 
                                        <option value="">---Select---</option>
                                    @foreach($expenseAccounts as $expenseAccount)
                                        <option value="{{ $expenseAccount->expense_head_id }}">{{ $expenseAccount->expense_head }}</option>
                                    @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-9">
                                <div class="form-group">
                                <br>
                                @if(isset($expense_account_ledgers))
                                    <a class="btn btn-warning btn-xs pull-right" href="{{ url('/ledger/expense-ledger-pdf/'.$current_expense_account->expense_head_id ) }}" target="_blank">Print/Download as PDF</a> 
                                @endif
                                </div>
                            </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">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))
                                <tr>
                                    <td>{{ 0 }}</td>
                                    <td>-/-/-</td>
                                    <td>Openig balance</td>
                                    <td style="text-align:right">{{ number_format($current_expense_account->opening_balance,2) }}</td>
                                    <td style="text-align:right">0.00</td>
                                </tr>
                                
                                @php 
                                    $sum_debit += $current_expense_account->opening_balance; 
                                    $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->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="3">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="4">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>