@extends('admin.layouts.app')
@section('title', 'Client Ledger Details')
@push('styles')
@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 Ledger Details</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 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="">Select 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-3">
                                <div class="mb-3 row">
                                    <label class="col-sm-4 col-form-label text-end">Start Date</label>
                                    <div class="col-sm-8">
                                        <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">
                                <div class="mb-3 row">
                                    <label class="col-sm-4 col-form-label text-end">End Date</label>
                                    <div class="col-sm-8">
                                        <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-3">
                                <div class="text-end">
                                    <button class="btn btn-primary" type="submit">Search</button>
                                    <button class="btn btn-success" name="excel_export" value="excel_export" type="submit">Excel Export</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>


            </div>
            <!--end card-header-->
            <div class="card-body">
                <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">
                    @if($clientName)
                        <div class="card-header with-border text-center">
                            <h1 class="card-title" style="font-size: 25px;">{{ config('app.name') }}</h1>
                            <p style="font-size: 15px;margin: 0;">{{ config('app.address') }}</p>
                            <p style="font-size: 15px;">Account Name: {{ $clientName }}</p>
                        </div>
                        <h4 class="text-end">Opening Balance: {{ number_format($opening_balance,2) }}</h4>
                    @endif
                    <table class="table table-bordered">
                        <tr>
                            <th>Date</th>
                            <th>Voucher</th>
                            <th>Product Details</th>
                            <th>Rate</th>
                            <th>Pch. Qty</th>
                            <th>Sale/Return Qty</th>
                            <th class="text-end">Debit</th>
                            <th class="text-end">Credit</th>
                            <th class="text-end">Due Balance</th>

                        </tr>
                        <tr>
                            <td>{{ date('d-m-Y',strtotime(request('start_date'))) }}</td>
                            <td>Opening Balance</td>
                            <td></td>
                            <td class="text-end"></td>
                            <td class="text-end"></td>
                            <td class="text-end"></td>
                            <td class="text-end"></td>
                            <td class="text-end">

                            </td>
                            <td class="text-end">{{ number_format($opening_balance, 2) }}</td>
                        </tr>
                        @php
                            $total_due = $opening_balance;

                            $t_invoice = 0;
                            $t_expense = 0;
                            $t_return = 0;
                            $t_payment = 0;
                            $t_discount = 0;
                            $t_due = 0;
                        @endphp

                        @foreach ($allData as $key => $data)
                            @php
                                if(!$data['orderId']){
                                    $total_due += $data['invoice'] + $data['expense'] - $data['return'] - $data['payment'] - $data['discount'];
                                    $t_invoice += $data['invoice'];
                                    $t_expense += $data['expense'];
                                    $t_return += $data['return'];
                                    $t_payment += $data['payment'];
                                    $t_discount += $data['discount'];
                                    $t_due = $total_due;
                                }
                                if ($data['orderId']){
                                    $orderItems = \App\Models\SaleOrderDetail::where('sale_order_id',$data['orderId'])->get();
                                }
                            @endphp
{{--                            {{ dd($orderItems) }}--}}
                            @if($data['orderId'] && $data['type']=='SALE')
                                @foreach($orderItems as $orderItem)
                                    @php
                                        $total_due += $orderItem->total_amount;
                                        $t_invoice += $orderItem->total_amount;
                                        $t_return += 0;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ $orderItem->product->name??'' }}</td>
                                        <td class="text-end">{{ number_format($orderItem->unit_price,2) }}</td>
                                        <td class="text-end">{{ number_format(0,2) }}</td>
                                        <td class="text-end">{{ number_format($orderItem->quantity,2) }}</td>
                                        <td class="text-end">{{ number_format($orderItem->total_amount,2) }}</td>
                                        <td class="text-end">
                                            {{ number_format(0,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endforeach
                                @php
                                    $saleOrder = \App\Models\SaleOrder::find($data['orderId']);
                                @endphp
                                @if($saleOrder->transport_cost > 0)
                                    @php
                                        $total_due += $saleOrder->transport_cost;
                                        $t_invoice += $saleOrder->transport_cost;
                                        $t_return += 0;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ 'Transport Cost' }}</td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end">{{ number_format($saleOrder->transport_cost,2) }}</td>
                                        <td class="text-end">
                                            {{ number_format(0,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endif
                                @if($saleOrder->labour_charge > 0)
                                    @php
                                        $total_due += $saleOrder->labour_charge;
                                        $t_invoice += $saleOrder->labour_charge;
                                        $t_return += 0;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ 'Labour Charge' }}</td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end">{{ number_format($saleOrder->labour_charge,2) }}</td>
                                        <td class="text-end">
                                            {{ number_format(0,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endif
                                @if($saleOrder->sales_goods_return > 0)
                                    @php
                                        $total_due -= $saleOrder->sales_goods_return;
                                        $t_invoice -= 0;
                                        $t_return += $saleOrder->sales_goods_return;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ 'Sales Goods Return' }}</td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end">
                                            {{ number_format(0,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($saleOrder->sales_goods_return,2) }}</td>

                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endif
                                @if($saleOrder->old_battery > 0)
                                    @php
                                        $total_due -= $saleOrder->old_battery;
                                        $t_invoice -= 0;
                                        $t_return += $saleOrder->old_battery;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ 'Old Battery' }}</td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end">
                                            {{ number_format(0,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($saleOrder->old_battery,2) }}</td>

                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endif
                                @if($saleOrder->discount_total > 0)
                                    @php
                                        $total_due -= $saleOrder->discount_total;
                                        $t_invoice -= 0;
                                        $t_return += $saleOrder->discount_total;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ 'Order discount' }}</td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end"></td>
                                        <td class="text-end">{{ number_format(0,2) }}</td>
                                        <td class="text-end">
                                            {{ number_format($saleOrder->discount_total,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endif
                            @elseif($data['orderId'] && $data['type']=='RETURN')
                                @foreach($orderItems as $orderItem)
                                    @php
                                        $total_due -= $orderItem->total_amount;
                                        $t_invoice += 0;
                                        $t_return += $orderItem->total_amount;
                                        $t_payment += 0;
                                        $t_due = $total_due;
                                    @endphp
                                    <tr>
                                        <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                        <td>{{ $data['particular'] }}</td>
                                        <td>{{ $orderItem->product->name??'' }}</td>
                                        <td class="text-end">{{ number_format($orderItem->unit_price,2) }}</td>
                                        <td class="text-end">{{ number_format(0,2) }}</td>
                                        <td class="text-end">{{ number_format($orderItem->quantity,2) }}</td>
                                        <td class="text-end">{{ number_format(0,2) }}</td>
                                        <td class="text-end">
                                            {{ number_format($orderItem->total_amount,2) }}
                                        </td>
                                        <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                    </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td>{{ date('d-m-Y',strtotime($data['date'])) }}</td>
                                    <td>{{ $data['particular'] }}</td>
                                    <td class="text-end"></td>
                                    <td class="text-end"></td>
                                    <td class="text-end"></td>
                                    <td class="text-end"></td>
                                    <td class="text-end">
                                        {{ $data['invoice'] == 0 ? number_format($data['expense'],2) : number_format($data['invoice'], 2) }}
                                    </td>
                                    <td class="text-end">
                                        @if($data['return'] != 0)
                                            {{ number_format($data['return']) }}
                                        @elseif($data['payment'] != 0)
                                            {{ number_format($data['payment']) }}
                                        @elseif($data['discount'] != 0)
                                            {{ number_format($data['discount']) }}
                                        @endif
                                    </td>
                                    <td class="text-end">{{ number_format($total_due, 2) }}</td>
                                </tr>
                            @endif
                        @endforeach
                        <tr>
                            <td colspan="6" class="text-end"><strong>Total</strong> </td>
                            <td class="text-end"><strong>{{ number_format($t_invoice+$t_expense, 2) }}</strong> </td>
                            <td class="text-end"><strong>{{ number_format($t_payment+$t_return+$t_discount, 2) }} </strong></td>
                            <td class="text-end"><strong>{{ number_format($t_due, 2) }}</strong> </td>

                        </tr>
                    </table>
                </div>
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div> <!-- end col -->


    </div> <!-- end row -->
@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