@extends('backend.layouts.master')
@section('title')
Report - {{ $title }}
@endsection

@section('styles')
<style>
    .bootstrap-switch-large {
        width: 200px;
    }
</style>
@endsection
@section('navbar-content')
<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">
                    Report </h1>
            </div><!-- /.col -->

        </div><!-- /.row -->
    </div><!-- /.container-fluid -->
</div>
@endsection

@section('admin-content')
<div class="row">
    <div class="col-md-12">
        @if (\Session::has('errorrs'))

        <div class="card bg-warning">
            <div class="card-header">
                {!! \Session::get('errorrs') !!}
            </div>
        </div>
        @endif
    </div>
    <div class="col-md-12">
        <form action="{{ route('report.custledger.custledger')}}" method="POST" enctype="multipart/form-data">
            @csrf
            <div class="card card-outline card-info no-print">
                <div class="card-body">
                    <div class="row  no-print">
                        <div class="box-header with-border" style="cursor: pointer;">
                            <h6 class="box-title">
                                <i class="fa fa-filter" aria-hidden="true"></i> Filters
                            </h6>
                        </div>
                    </div>

                    <div class="row no-print">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>Date Range:</label>
                                <input type="text" class="form-control " name="dateRange" value="" id="reservation" />
                                @error('dateRange')
                                <span class="error text-red text-bold"> {{ $message }}</span>
                                @enderror
                            </div>
                        </div>


                        <div class="col-md-3">
                            <div class="form-group">
                                <label>Customer </label>
                                <select class="form-control select2" name="customer_id" id="customer_id">
                                    <option selected  value="all">All Customer</option>
                                    <x-account :selectVal="$request->customer_id" :setAccounts="$ledgers" />
                                </select>
                                @error('customer_id')
                                <span class="error text-red text-bold"> {{ $message }}</span>
                                @enderror
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>&nbsp;</label><br>
                                <button type="submit" class="btn btn-sm btn-success"><i class="fa fa-search"></i>
                                    Search</button>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div id="load_data"></div>
        </form>
    </div>

    @if (isset($customerLedger) && !empty($customerLedger))
    <div class="col-md-12">
        <div class="card card-default">
            <div class="card-header no-print">
                <h3 class="card-title">Customer ledger Report</h3>
                <a onclick="window.print()" target="_blank" class="btn btn-default float-right my-2 no-print"><i
                        class="fas fa-print"></i>
                    Print</a>
                <div id="tableActions" class=" float-right my-2 no-print"></div>
            </div>

            <div class="card-body">

                <div class="invoice p-3 mb-3">
                    <div class="row">
                        <div class="col-12 table-responsive">
                            <table class="table  table-bordered">
                                <tr>

                                    <td style="text-align: center">
                                        @if (isset($companyInfo->logo))
                                        <a href="{{ route('home') }}">
                                            <img width="200px" src="{{ asset('/backend/logo/' . $companyInfo->logo) }}"
                                                style="" alt="">
                                        </a>
                                        @endif
                                    </td>
                                    <td width="70%" style="text-align: center">
                                        <h3>Customer Ledger </h3>
                                        <h4><b>From Date: {{ $from_date }}</b>, <b>To date: {{ $to_date }} </b></h4>
                                    </td>
                                </tr>
                            </table>
                            <table id="datatablexcel" class="table  table-bordered">
                                <thead>
                                    <tr>
                                        <th colspan="10">
                                            <i class="fa fa-circle"></i> Ledger Details
                                        </th>
                                    </tr>
                                    <tr>
                                        <th>SL</th>
                                        <th>Invoice</th>
                                        <th>Account Name</th>
                                        <th>Note</th>
                                        <th>Debit</th>
                                        <th>Credit</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $i=1;
                                    $debitTotal =0;
                                    $creditTotal =0;
                                    @endphp
                                    @foreach ($customerLedger as $item)
                                    @if ($item->account_id != 5)
                                    @php
                                    $debitTotal += $item->debit;
                                    $creditTotal += $item->credit;

                                    $url = "#";
                                     if($item->type == "sale"){
                                         $url = route('sale.sale.show',$item->table_id);
                                     }

                                    @endphp
                                    <tr>
                                        <td>{{ $i++; }}</td>
                                        <td><a href="{{ $url }}"> {{ $item->invoice}} </a></td>
                                        <td>{{$item->account->account_name ?? ""}}</td>
                                        <td align="right">{{ $item->remark}}</td>
                                        <td align="right">{{ $item->debit}}</td>
                                        <td align="right">{{ $item->credit}}</td>
                                    </tr>
                                    @endif
                                    @endforeach
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th colspan="4" style="text-align: center">Total</th>
                                        <th style="text-align: right;">{{ $debitTotal}}</th>
                                        <th style="text-align: right;">{{ $creditTotal}}</th>
                                    </tr>
                                    <tr>
                                        <th colspan="4" style="text-align: center">Remaining</th>

                                        <th colspan="2" style="text-align: right;">{{ $debitTotal - $creditTotal }}</th>
                                    </tr>
                                </tfoot>

                            </table>
                        </div>
                        <div class="col-md-4  float-left">
                            <br>
                            <br>

                            <p>Prepared By:_____________<br />
                                Date:____________________
                            </p>
                        </div>
                        <div class="col-md-6 text-center">
                        </div>
                        <div class="col-md-2  ">
                            <br>
                            <br>
                            <p>Approved By:________________<br />
                                Date:_________________</p>
                        </div>

                        <hr>


                        <div class="col-md-12 bg-success" style="text-align: center">
                            Thank you for choosing  {{ $companyInfo->company_name ?? 'N/A' }}  products.
                            We believe you will be satisfied by our services.
                        </div>
                        <!-- /.col -->



                    </div>
                    <!-- Table row -->

                </div>

            </div>
        </div>
    </div>

    @endif
    <!-- /.col-->
</div>
@endsection
@section('scripts')
@include('backend.pages.reports.excel')

@endsection
