@extends('layouts.template')

@section('template')
<!-- Content Header -->
<section class="content-header">
    <h1>
        CUSTOMER LEDGER 
            @if(isset($customer_ledgers))
            :: 
            <span class="text text-danger">{{ $current_customer->customer_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">Customer Ledger</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content">
            <div class="row">
            <!--
                <div class="col-md-3"> 
                    <div class="panel panel-primary">
                        <div class="panel-heading">
                            Transaction
                        </div>
                        <div class="panel-body">
                            <form class="form" action="{{ url('customer/transaction') }}" 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="">Type*</label>
                                    <select name="type" class="form-control select2" required>
                                        <option value="Receive">Receive Money</option>
                                        <option value="Discount">Discount</option>

                                    </select>
                                </div>
                                <div class="form-group">
                                    <label for="">Select a Customer*</label>
                                    <select name="customer_id" id="customer_id" class="form-control select2"  required > 
                                        <option value="">---Select---</option>
                                    @foreach($customers as $customer)
                                        <option value="{{ $customer->customer_id }}">{{ $customer->customer_name }}</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 transaction" ></textarea>
                                </div>
                                <div class="form-group">
                                    <label for="">Payment Method*</label>
                                    <select name="bank_account_id" class="form-control select2" 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-warning" value="Save"/>
                                </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>
            -->
                <!-- /MODAL -->
                <div class="modal fade" id="modal-default">
                  <div class="modal-dialog">
                    <div class="modal-content">
                      <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                          <span aria-hidden="true">&times;</span></button>
                        <h4 class="modal-title">Transaction Info</h4>
                      </div>
                      <div class="modal-body">
                        <form class="form" action="{{ url('customer/transaction') }}" 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="">Type*</label>
                                <select name="type" class="form-control " required>
                                    <option value="Receive">Receive Money</option>
                                    <option value="Discount">Discount</option>

                                </select>
                            </div>
                            <div class="form-group">
                                <label for="">Select a Customer*</label>
                                <select name="customer_id" id="customer_id" class="form-control "  required > 
                                    <option value="">---Select---</option>
                                @foreach($customers as $customer)
                                    <option value="{{ $customer->customer_id }}">{{ $customer->customer_name }}</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 transaction" ></textarea>
                            </div>
                            <div class="form-group">
                                <label for="">Payment Method*</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>
                      <div class="modal-footer">
                        <button type="submit" class="btn btn-success pull-left">Save changes</button>
                        <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                        </form>
                      </div>
                    </div>
                  </div>
                </div>
                <!-- /MODAL -->
            
                    
                    <div class="col-md-12">
                        <div class="panel panel-primary">
                            <div class="panel-heading">
                                Select Customer 
                                <!-- <button type="button" class="btn btn-default btn-sm" data-toggle="modal" data-target="#modal-default"><i class="fa fa-money"></i> Make Transaction
                                  </button> -->
                            </div>
                            <div class="panel-body">
                                <form class="form" action="{{ url('ledger/customer') }}" 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 Customer*</label>
                                            <select name="customer_id" id="supplier_id" class="form-control select2"  required onchange='if(this.value != "") { this.form.submit(); }'> 
                                                <option value="">---Select---</option>
                                            @foreach($customers as $customer)
                                                <option value="{{ $customer->customer_id }}">{{ $customer->customer_name }}</option>
                                            @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-9">
                                        <div class="form-group">
                                        <br>
                                        @if(isset($customer_ledgers))
                                            <a class="btn btn-warning btn-xs pull-right" href="{{ url('/ledger/customer-ledger-pdf/'.$current_customer->customer_id ) }}" target="_blank">Print/Download as PDF</a> 
                                        @endif
                                        </div>
                                    </div>  
                                </form>
                            </div>
                        </div>   
                    </div>    
                    <!-- MESSAGES-->
                    @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 
                    <!-- MESSAGES-->
                    @if(isset($current_customer))
                    <div class="col-md-12">   
                    <div class="panel panel-primary">
                        <div class="panel-heading">
                            List Transactions
                        </div>
                        <div class="panel-body">             
                            <div class="table-responsive">
                                <table class="table-bordered" id="purchase_details" width="100%">
                                    <thead>
                                        <tr>
                                            <th style="text-align:left" height="25">Srl</th>
                                            <th style="text-align:left">Date</th>
                                            <th style="text-align:left">Invoice #</th>
                                            <th style="text-align:left">Type</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($current_customer))
                                        <tr>
                                            <td height="25">{{ 0 }}</td>
                                            <td>----/--/--</td>
                                            <td>NA</td>
                                            <td>Openig balance</td>
                                            <td></td>
                                            <td style="text-align:right">{{ number_format($current_customer->op_bal_debit,2) }}</td>
                                            <td style="text-align:right">{{ number_format($current_customer->op_bal_credit,2) }}</td>
                                        </tr>
                                        
                                        @php 
                                            $sum_debit += $current_customer->op_bal_debit; 
                                            $sum_credit += $current_customer->op_bal_credit;
                                        @endphp
                                        @endif
                                        @if(isset($customer_ledgers))
                                            @foreach($customer_ledgers as $key => $customer_ledger)
                                            <tr>
                                                <td height="25">{{ ++$key}}</td>
                                                <td>{{ $customer_ledger->transaction_date }}</td>
                                                <td>{{ $customer_ledger->getMemo->memo_no }}</td>
                                                <td>{{ $customer_ledger->tran_ref_name }}</td>
                                                <td>{{ $customer_ledger->particulars }}</td>
                                                <td style="text-align:right">{{ number_format($customer_ledger->debit,2) }}</td>
                                                <td style="text-align:right">{{ number_format($customer_ledger->credit,2) }}</td>
                                            </tr>
                                            @php $sum_debit += $customer_ledger->debit; $sum_credit += $customer_ledger->credit; @endphp
                                            @endforeach
                                        @endif
                                    </tbody>

                                    <tbody>
                                        <tr>
                                            <th style="text-align:left" height="25"></th>
                                            <th style="text-align:left"></th>
                                            <th style="text-align:left"></th>
                                            <th style="text-align:left"></th>
                                             <th style="text-align:left"></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"></th>
                                            <th style="text-align:left"></th>
                                            <th style="text-align:left"></th>
                                            <th style="text-align:left"></th>
                                            <th style="text-align:left"></th>
                                            <th style="text-align:right">Balance</th>
                                            @if($sum_credit-$sum_debit >= 0)
                                            <th class="btn btn-success pull-right" style="text-align:right">{{ number_format($sum_credit-$sum_debit,2) }} Cr</th>
                                            @else
                                            <th class="btn btn-danger pull-right" style="text-align:right">{{ number_format($sum_debit-$sum_credit,2) }} Dr</th>
                                            @endif  
                                        </tr>
                                    </tbody>
                                </table>
                            </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>