@extends('layouts.template')

@section('template')
<style type="text/css" media="print">
    @page 
    {
        size: auto;   /* auto is the initial value */
        margin: 0mm;  /* this affects the margin in the printer settings */

    }
    @media print {
      #dontPrint {
        display: none;
      }
      #printObject{
        margin: 5%;
      }

    }
</style>
<section class="content-header">
    <h1>
        GROUP ACCOUNT LEDGER 
        </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 Account Ledger</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content">
    <div class="row">
        <div class="col-md-12" id="dontPrint">
            <div class="panel panel-primary">
                <div class="panel-heading">     
                List Group Account
                </div>

                <div class="panel-body"> 
                <div class="col-md-12">
                    <form class="form" action="{{ url('ledger/account/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 > 
                                    <option value="">---Select---</option>
                                @foreach($accountGroups as $data)
                                    <option value="{{ $data->id }}" @if(isset($current_account_group->id)) @if($data->id == $current_account_group->id) selected @endif @endif>{{ $data->name }}</option>
                                @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="">From</label>
                                <input type="text" id="datepicker" autocomplete="off" name="start_date" id="start_date" class="form-control input-sm" @if(isset($start_date)) value="{{ $start_date }}"@endif  required/>
                            </div>
                        </div>    
                        <div class="col-md-2">
                            <div class="form-group">
                                 <label for="">To</label>
                                 <input type="text" id="datepicker2" autocomplete="off" name="end_date" id="end_date" class="form-control input-sm" @if(isset($end_date)) value="{{ $end_date }}"@endif required onchange='if(this.value != "") { this.form.submit(); }'/>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="form-group">
                                 <br>
                                 <input type="submit"  class="btn btn-success btn-sm" value="Submit" />
                            </div>
                        </div> 
                    </form>
                </div> 
                </div>  
            </div>
        </div>
        @if(isset($end_date))
        <div class="col-md-12" id="printObject">
            <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;width: 3%;" height="25">Srl</th>
                                        <th style="text-align:left;width: 12%;">Date</th>
                                        <th style="text-align:left;width: 25%;">Account</th>
                                        <th style="text-align:left;width: 25%;">Particular</th>
                                        <th style="text-align:right;width: 15%;">Debit</th>
                                        <th style="text-align:right;width: 15%;">Credit</th>
                                    </tr>
                                </thead>

                                <tbody>
                                    @php $sum_debit = 0; $sum_credit = 0;  @endphp
                                    @if(isset($group_account_ledgers))
                                    
                                    
                                    @php 
                                        $sum_debit += 0;
                                        $sum_credit += 0; 
                                    @endphp
                                    @endif
                                    @if(isset($group_account_ledgers))
                                        @foreach($group_account_ledgers as $key => $data)
                                        <tr>
                                            <td>{{ ++$key}}</td>
                                            <td>{{ date('F j,Y',strtotime($data->transaction_date)) }}</td>
                                            <td>{{ $data->bank_name }}</td>
                                            <td>{{ $data->transaction_description }} <b>Ref:</b> {{ $data->voucher_ref }}</td>
                                            <td style="text-align:right">{{ number_format($data->deposit,2) }}</td>
                                            <td style="text-align:right">{{ number_format($data->expense,2) }}</td>
                                        </tr>
                                        @php $sum_debit += $data->deposit; $sum_credit += $data->expense; @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>
        @endif
    </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>