@extends('admin.layouts.app')
@section('title', 'Client Due List')
@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</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-4">
                                <div class="mb-3 row">
                                    <label class="col-sm-4 col-form-label text-end">Client</label>
                                    <div class="col-sm-8">
                                        <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 }}</option>
                                            @endforeach
                                        </select>
                                        @error('client')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-5">
                                <button class="btn btn-info" type="submit">Search</button>
                                <button class="btn btn-success" name="excel_export" value="excel_export" type="submit">Excel Export</button>
                                <button class="pull-right btn btn-primary" onclick="getprint('prinarea')">Print</button>

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


            </div>
            <!--end card-header-->
            <div class="card-body">
                <div id="prinarea">
                    <div class="card-header with-border text-center">
                        <h1 class="card-title" style="font-size: 25px;">Client Due Report</h1>
                    </div>
                    @php
                        $advance = 0;
                        $due = 0;
                    @endphp
                    @foreach($resultClients as $resultClient)
                        @if($resultClient->due != 0)
                            @php
                                if ($resultClient->due < 0) {
                                    $advance += $resultClient->due;
                                } else {
                                    $due += $resultClient->due;
                                }
                            @endphp
                        @endif
                    @endforeach

                    <table class="table table-bordered">
                        <thead>
                        <tr>
                            <th colspan="7" class="text-end">Total</th>
                            <th class="text-end">{{ number_format(abs($advance), 2) }}</th>
                            <th class="text-end">{{ number_format($due, 2) }}</th>
                        </tr>
                        <tr>
                            <th>SL</th>
                            <th class="text-center">Customer</th>
                            <th class="text-center">Address</th>
                            <th class="text-center">Ref. Name</th>
                            <th class="text-end">Total</th>
                            <th class="text-end">Paid</th>
                            <th class="text-end">Return</th>
                            <th class="text-end">Advance</th>
                            <th class="text-end">Due</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach($resultClients as $index => $resultClient)
                            @if($resultClient->due != 0)
                                <tr>
                                    <td>{{ $index + 1 }}</td>
                                    <td>{{ $resultClient->name }}</td>
                                    <td>{{ $resultClient->address }}</td>
                                    <td>{{ $resultClient->clientReference->name ?? '' }}</td>
                                    <td class="text-end">{{ number_format($resultClient->total, 2) }}</td>
                                    <td class="text-end">{{ number_format($resultClient->paid, 2) }}</td>
                                    <td class="text-end">{{ number_format($resultClient->return, 2) }}</td>
                                    <td class="text-end">
                                        @if($resultClient->due < 0)
                                            {{ number_format(abs($resultClient->due), 2) }}
                                        @endif
                                    </td>
                                    <td class="text-end">
                                        @if($resultClient->due > 0)
                                            {{ number_format($resultClient->due, 2) }}
                                        @endif
                                    </td>
                                </tr>
                            @endif
                        @endforeach
                        </tbody>
                        <tfoot>
                        <tr>
                            <th colspan="7" class="text-end">Total</th>
                            <th class="text-end">{{ number_format(abs($advance), 2) }}</th>
                            <th class="text-end">{{ number_format($due, 2) }}</th>
                        </tr>
                        <tr>
                            <th colspan="7" class="text-end">Total Due</th>
                            <th class="text-end" colspan="2">{{ number_format($due - abs($advance), 2) }}</th>
                        </tr>
                        </tfoot>
                    </table>
                </div>
{{--                <div id="prinarea">--}}
{{--                    <div class="card-header with-border text-center">--}}
{{--                        <h1 class="card-title" style="font-size: 25px;">Client Due Report</h1>--}}
{{--                    </div>--}}
{{--                    @php--}}
{{--                        $advance = 0;--}}
{{--                        $due = 0;--}}
{{--                    @endphp--}}
{{--                    @foreach($resultClients as $index=>$resultClient)--}}
{{--                        @if($resultClient->due != 0)--}}
{{--                            @php--}}
{{--                                if ($resultClient->due < 0){--}}
{{--                                    $advance += $resultClient->due;--}}
{{--                                }else{--}}
{{--                                    $due += $resultClient->due;--}}
{{--                                }--}}
{{--                            @endphp--}}
{{--                        @endif--}}
{{--                    @endforeach--}}
{{--                    <table class="table table-bordered">--}}
{{--                        <thead>--}}
{{--                            <tr>--}}
{{--                                <th colspan="5" class="text-end">Total</th>--}}
{{--                                <th class="text-end">{{ number_format(abs($advance),2) }}</th>--}}
{{--                                <th class="text-end">{{ number_format($due,2) }}</th>--}}
{{--                            </tr>--}}
{{--                            <tr>--}}
{{--                                <th>SL</th>--}}
{{--                                <th class="text-center">Customer</th>--}}
{{--                                <th class="text-end">Total</th>--}}
{{--                                <th class="text-end">Paid</th>--}}
{{--                                <th class="text-end">Return</th>--}}
{{--                                <th class="text-end">Advance</th>--}}
{{--                                <th class="text-end">Due</th>--}}
{{--                            </tr>--}}
{{--                        </thead>--}}

{{--                        <tbody>--}}
{{--                            @foreach($resultClients as $index=>$resultClient)--}}
{{--                                @if($resultClient->due != 0)--}}
{{--                                    <tr>--}}
{{--                                        <td>{{ $index+1 }}</td>--}}
{{--                                        <td>{{ $resultClient->name }}</td>--}}
{{--                                        <td class="text-end">{{ $resultClient->total }}</td>--}}
{{--                                        <td class="text-end">{{ $resultClient->paid }}</td>--}}
{{--                                        <td class="text-end">{{ $resultClient->return }}</td>--}}
{{--                                        <td class="text-end">@if($resultClient->due < 0){{ abs($resultClient->due) }}@endif</td>--}}
{{--                                        <td class="text-end">@if($resultClient->due > 0){{ $resultClient->due }}@endif</td>--}}
{{--                                    </tr>--}}
{{--                                @endif--}}
{{--                            @endforeach--}}
{{--                        </tbody>--}}
{{--                        <tfoot>--}}
{{--                            <tr>--}}
{{--                                <th colspan="5" class="text-end">Total</th>--}}
{{--                                <th class="text-end">{{ number_format(abs($advance),2) }}</th>--}}
{{--                                <th class="text-end">{{ number_format($due,2) }}</th>--}}
{{--                            </tr>--}}
{{--                            <tr>--}}
{{--                                <th colspan="5" class="text-end">Total Due</th>--}}
{{--                                <th class="text-end" colspan="2">{{ number_format($due-abs($advance),2) }}</th>--}}
{{--                            </tr>--}}
{{--                        </tfoot>--}}
{{--                    </table>--}}
{{--                </div>--}}
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div> <!-- end col -->

@endsection


@push('scripts')
    <script>
        var APP_URL = '{!! url()->full()  !!}';
        function getprint(print) {

            $('body').html($('#'+print).html());
            window.print();
            window.location.replace(APP_URL)
        }
        $(function () {
            $('.select2').select2();
        });
    </script>
@endpush