@extends('admin.layouts.app')
@section('title', 'Client Due Details Report')
@push('styles')
    <style>
        td, th {
            border: 1px solid #000 !important;
        }
        .table>:not(caption)>*>* {
            padding: 2px 4px !important;
        }
    </style>
@endpush
@section('container')
    <!-- Page-Title -->
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <div class="float-end">

                </div>
                <h4 class="page-title">Client Due Details Report</h4>
            </div>
            <!--end page-title-box-->
        </div>
        <!--end col-->
    </div>
    <!-- end page title end breadcrumb -->

    <div class="row">
        @if (session('success'))
            <div class="alert alert-info">
                {{ session('success') }}
            </div>
        @endif
        @if (session('error'))
            <div class="alert alert-danger">
                {{ session('error') }}
            </div>
        @endif
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <form action="">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">Client</label>
                                    <div class="form-group">
                                        <select name="client" id="client" class="form-control select2">
                                            <option value="">All Client</option>
                                            @foreach ($clients as $client)
                                                <option {{ request()->client == $client->id ? 'selected' : '' }}
                                                        value="{{ $client->id }}">{{ $client->name }} - {{ $client->address }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">Client Reference</label>
                                    <div class="form-group">
                                        <select name="client_reference" id="client_reference" class="form-control select2">
                                            <option value="">All Client Reference</option>
                                            @foreach ($clientReferences as $clientReference)
                                                <option {{ request()->client_reference == $clientReference->id ? 'selected' : '' }}
                                                        value="{{ $clientReference->id }}">{{ $clientReference->name }} - {{ $clientReference->address }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3"  style="display: none">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">Start Date</label>
                                    <div class=form-group">
                                        <input type="date" name="start_date" id="start_date" value="{{ old('start_date', request()->start_date??date('Y-m-d')) }}" class="form-control">
                                        @error('start_date')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3" style="display: none">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">End Date</label>
                                    <div class="form-group">
                                        <input type="date" name="end_date" id="end_date"
                                            value="{{ old('end_date', request()->end_date??date('Y-m-d')) }}" class="form-control">
                                        @error('end_date')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                            <div class="col-2">
                                <div class="text-start">
                                    <button class="btn btn-primary" style="margin-top: 35px;" type="submit">Search</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>


            </div>
            <!--end card-header-->
            @if(count($alldata)>0)
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header with-border">
                                <button class="pull-right btn btn-primary" onclick="getprint('prinarea')">Print</button>
                            </div>
                        </div>
                    </div>
                </div>
                <div id="prinarea">
                    <div class="card-body">
                        <div class="card-header with-border text-center">
                            <h1 class="card-title mb-0" style="font-size: 25px;">Client Due Details Report</h1>
                            <h3 class="card-title" style="font-size: 16px;">Date: {{ date('d-m-Y') }}</h3>
                        </div>
                        <table class="table table-bordered">
                            <tr>
                                <th>SL</th>
                                <th>Account Name</th>
                                <th>Address</th>
                                <th>Ref.</th>
                                <th width="12%">Last sale</th>
                                <th width="13%">Payment date</th>
{{--                                <th class="print-remove">B/F</th>--}}
{{--                                <th class="print-remove">Dr. Amount</th>--}}
{{--                                <th class="print-remove">Cr. Amount</th>--}}
                                <th class="text-end">Balance</th>
                            </tr>
                            @php
                                $total = 0;
                            @endphp
                           @foreach ($alldata as $index => $data)
                            @php
                                $total += $data['balance'];
                            @endphp
                               <tr>
                                    <td>{{ $index+1 }}</td>
                                    <td>{{ $data['account_name'] }}</td>
                                    <td>{{ $data['address'] }}</td>
                                    <td>{{ $data['client_reference_name'] }}</td>
                                    <td>{{ ($data['last_sale_date']) }}</td>
                                    <td>{{ ($data['last_payment_date']) }}</td>
{{--                                    <td class="print-remove">{{ number_format($data['previous_balance'],2) }}</td>--}}
{{--                                    <td class="print-remove">{{ number_format($data['debit'],2) }}</td>--}}
{{--                                    <td class="print-remove">{{ number_format($data['credit'],2) }}</td>--}}
                                    <td  class="text-right">{{ number_format($data['balance'],2) }}</td>
                               </tr>
                           @endforeach
                           <tr>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
                               <th></th>
{{--                               <th class="print-remove"></th>--}}
{{--                               <th class="print-remove"></th>--}}
{{--                               <th class="print-remove"></th>--}}
                                <th class="text-center">Total</th>
                                <th  align="right">{{ number_format($total,2) }}</th>
                           </tr>
                        </table>
                    </div>
                </div>
            @endif
            <!--end card-body-->
        </div>
        <!--end card-->
    </div> <!-- end col -->


    </div> <!-- end row -->
@endsection
@push('scripts')
    <script>
        var APP_URL = '{!! url()->full()  !!}';
        function getprint(print) {
            $('.print-remove').remove();
            $('body').html($('#'+print).html());
            window.print();
            window.location.replace(APP_URL)
        }
        $(function () {
            $('.select2').select2();
        });
    </script>
@endpush