@extends('admin.layout.app')
@section('title', 'Estimation')
@push('headerscript')
    <style>
        .arabic-font {
            margin-right: 20px !important;
            font-family: 'Noto Sans Arabic';
            font-size: 13px;
            color: black;
        }

        .detail-text {
            color: black;
            font-size: 15px;
            font-weight: bold;
        }

        .detail-text1 {
            color: black;
            font-size: 15px;
            padding-left: 15px;
        }

        @media print {
            .content-page {
                margin-left: 0;
            }
        }

        .table-invoice > thead > tr > th {
            padding-top: 0px;
        }

        @media (max-width: 600px) {
            #logo_image_images {
                width: 280px;
            }
        }
    </style>
@endpush
@section('content')
    <div class="content" style="color: black;">
        <div class="container">
            <div class="row">
                <div class="col-xs-6">
                    <h4 class="page-title">Estimation</h4>
                </div>
                <div class="col-xs-6 text-right">
                    <ol class="breadcrumb">
                        <li>
                            <a href="{{ route('estimation.index') }}">List</a>
                        </li>
                        <li>
                            <a href="{{ route('estimation.edit', $estimation->id) }}">Edit</a>
                        </li>
                        <li>
                            <a href="{{ route('estimationPdfView', $estimation->id) }}" target="_blank"
                               class="btn btn-inverse waves-effect waves-light"><i class="fa fa-print"></i></a>
                        </li>
                        <li>
                            <button onclick="sendEmail({{$estimation->id}}, 'estimation','{{ $estimation->customer ? $estimation->customer->email : '' }}')" title="send email"
                                    class="btn btn-danger waves-effect waves-light"><i class="fa fa-envelope"></i>
                            </button>
                        </li>
                        <li>
                            <button
                                onclick="whatsapp('{{ $estimation->customer ? $estimation->customer->contact_number : '' }}')"
                                title="whatsapp" class="btn btn-success waves-effect waves-light">
                                <i class="fa fa-whatsapp"></i>
                            </button>
                        </li>
                    </ol>
                </div>
            </div>
            <div class="row">
                <div class="col-md-12 ">
                    <div class="panel panel-default">
                        <!-- <div class="panel-heading">
                                    <h4>Invoice</h4>
                                </div> -->
                        <div class="panel-body">
                            <div class="row">
                                <div class="col-md-4 col-xs-12">
                                    <div class="">
                                        <p>
                                            <img src="{{ url('storage/' . Helper::getBusinessData()->logo_image) }}"
                                                 alt="logo" width="250" id="logo_image_images">
                                        </p>
                                    </div>
                                </div>
                                <div class="col-md-8 col-xs-12">
                                    <div class="text-center">
                                        <h2 class="text-black">{{ Helper::getBusinessData()->business_name }}</h2>
                                        <h4 class="text-black">{{ Helper::getBusinessData()->address }}</h4>
                                        <h5 class="text-black">{{Helper::getBusinessData()->email_id}} &nbsp;&nbsp;
                                            &nbsp;&nbsp;
                                            {{Helper::getBusinessData()->web_link}} &nbsp;&nbsp; &nbsp;&nbsp;
                                            {{Helper::getBusinessData()->contact_no}}</h5>
                                    </div>
                                </div>
                            </div>

                            <div class="m-h-50"></div>
                            <hr style="border-top: 2px solid black;" class="m-t-20 m-b-0">
                            <div class="row">
                                <div class="col-md-4 col-xs-6">
                                    <p class="pull-left m-l-15"><strong>Est
                                            :</strong> {{ $estimation->estimation_number }}</p>
                                </div>
                                <div class="col-md-4 col-xs-12">
                                    <h3 class="text-center m-t-5 m-b-5"><b>ESTIMATION</b></h3>
                                </div>
                                <div class="col-md-4 col-xs-6">
                                    <p class="text-right m-r-15"><strong>
                                            Date: </strong> {{ date('d-M-Y', strtotime($estimation->estimation_date)) }}
                                    </p>
                                </div>
                            </div>
                            <hr style="border-top: 2px solid black;" class="m-0">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="table-responsive table-padding">
                                        <table class="table-without-border">
                                            <thead>
                                            <tr>
                                                <th style="width: 7%"></th>
                                                <th style="width: 70%"></th>
                                                <th style="width: 7%"></th>
                                                <th style="width: 20%"></th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <tr class="m-t-5">
                                                <td>
                                                    <span class="detail-text">Name</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customer?->name }}</span>
                                                </td>
                                                <td>
                                                    <span class="detail-text">Plate No.</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customerVehicle ?  $estimation->customerVehicle->plate_number:' '}}</span>
                                                </td>
                                            </tr>
                                            <tr class="m-t-5">
                                                <td>
                                                    <span class="detail-text">Contact</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customer?->contact_number }}</span>
                                                </td>
                                                <td>
                                                    <span class="detail-text">Emirates</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customerVehicle->emirates }}</span>
                                                </td>
                                            </tr>
                                            <tr class="m-t-5">
                                                <td>
                                                    <span class="detail-text">Address</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customer?->address }}</span>
                                                </td>
                                                <td>
                                                    <span class="detail-text">Brand</span>

                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customerVehicle->vehicleBrand->vehicle_brand }}</span>
                                                </td>
                                            </tr>
                                            <tr class="m-t-5">
                                                <td>
                                                    <span class="detail-text">VIN No.</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customerVehicle->vin_number }}</span>
                                                </td>
                                                <td>
                                                    <span class="detail-text">Model</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customerVehicle->vehicleModel->vehicle_model }}</span>
                                                </td>
                                            </tr>
                                            <tr class="m-t-5">
                                                <td>
                                                    <span class="detail-text">TRN</span>
                                                </td>
                                                <td>
                                                    : <span
                                                        class="detail-text1">{{ $estimation->customer?->vat_number }}</span>
                                                </td>
                                                <td>
                                                    <span class="detail-text">Created By</span>
                                                </td>
                                                <td>
                                                    : <span class="detail-text1">{{ $estimation->created_by }}</span>
                                                </td>
                                            </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            @if ($estimation->estimationJobDescriptions)
                                <div class="row">
                                    <div class="col-md-12 col-xs-12">
                                        <h4 class="p-0 m-0">Customer Complaints</h4>
                                        <div class="table-responsive" style="border: none;">
                                            <table class="table table-invoice m-0">
                                                <thead>
                                                <tr>
                                                    <th style="width: 5%"></th>
                                                    <th style="width: 90%"><strong>Description</strong></th>
                                                </tr>
                                                </thead>
                                                <tbody>
                                                                                                @foreach ($estimation->estimationJobDescriptions as $estimation_detail)
                                                    <tr>
                                                        <td>
                                                            {{ $i . '.' }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->job_description }}
                                                        </td>
                                                    </tr>
                                                                                                    @endforeach
                                                </tbody>
                                            </table>
                                            <br>
                                        </div>
                                    </div>

                                </div>
                            @endif
                                                        @if (count($estimation->estimationSpareParts) > 0)
                                <div class="row">
                                    <div class="col-md-12">
                                        <h4 class="p-0 m-0">Spare Parts</h4>
                                        <div class="table-responsive">
                                            <table class="table table-invoice  m-0">
                                                <thead>
                                                <tr>
                                                    <th style="width: 5%"></th>
                                                    <th style="width: 50%"><strong>Parts Description</strong></th>
                                                    <th style="width: 10%;">Unit Price</th>
                                                    <th style="width: 10%;">Qty.</th>
                                                    <th style="width: 10%;">Amount</th>
                                                    <th style="width: 10%">5% Vat</th>
                                                    <th style="width: 10%">Net Total</th>
                                                </tr>
                                                </thead>
                                                <tbody>

                                                @foreach ($estimation->estimationSpareParts as $estimation_detail)
                                                    <tr>
                                                        <td>
                                                            {{ $i . '.' }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->sparePart->part_description }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->sp_selling_price }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->quantity }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->quantity * $estimation_detail->sp_selling_price }}
                                                        </td>
                                                        <td>
                                                            @if ($estimation->show_vat == 'yes')
                                                                {{ $estimation_detail->quantity * $estimation_detail->sp_selling_price * 0.05 }}
                                                            @else
                                                                {{ 0 }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            @if ($estimation->show_vat == 'yes')
                                                                {{ number_format($estimation_detail->quantity * $estimation_detail->sp_selling_price + $estimation_detail->quantity * $estimation_detail->sp_selling_price * 0.05, 2) }}
                                                            @else
                                                                {{ $estimation_detail->quantity * $estimation_detail->sp_selling_price }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                                                                    @endforeach
                                                </tbody>
                                            </table>
                                            <p class="text-right m-r-15"><strong>Total Spare Parts</strong>
                                                : <strong>{{ number_format($total_spare_part, 2) }}</strong>
                                            </p>
                                        </div>
                                    </div>
                                </div>
                            @endif
                                                        @if (count($estimation->estimationServices) > 0)

                                <div class="row">
                                    <div class="col-md-12">
                                        <h3 class="p-b-0 m-b-0">Services</h3>
                                        <div class="table-responsive">
                                            <table class="table m-t-5 table-invoice">
                                                <thead>
                                                <tr>
                                                    <th style="width: 5%"></th>
                                                    <th style="width: 50%"><strong>Work Description</strong></th>
                                                    <th style="width: 10%">Time</th>
                                                    <th style="width: 10%">Selling Price</th>
                                                    <th style="width: 10%">Amount</th>
                                                    <th style="width: 10%">5% Vat</th>
                                                    <th style="width: 10%">Net Total</th>
                                                </tr>
                                                </thead>
                                                <tbody>

                                                @foreach ($estimation->estimationServices as $estimation_detail)
                                                    <tr>
                                                        <td>
                                                            {{ $i . '.' }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->service->service_name }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->s_time }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->s_selling_price }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_detail->s_selling_price * $estimation_detail->s_time }}
                                                        </td>
                                                        <td>
                                                            @if ($estimation->show_vat == 'yes')
                                                                {{ $estimation_detail->s_selling_price * $estimation_detail->s_time * 0.05 }}
                                                            @else
                                                                {{ 0 }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            @if ($estimation->show_vat == 'yes')
                                                                {{ number_format($estimation_detail->s_selling_price * $estimation_detail->s_time + $estimation_detail->s_selling_price * $estimation_detail->s_time * 0.05, 2) }}
                                                            @else
                                                                {{ $estimation_detail->s_selling_price * $estimation_detail->s_time }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                                                                    @endforeach
                                                </tbody>
                                            </table>
                                            <p class="text-right m-r-15 "><strong>Total Services </strong>
                                                : <strong>{{ number_format($total_service, 2) }}</strong></p>
                                        </div>
                                    </div>
                                </div>
                            @endif
                                                        @if (count($estimation->estimationSubletServices) > 0)

                                <div class="row ">
                                    <div class="col-md-12 col-xs-12 m-0">
                                        <h5 class="p-0 m-0" style="color: black">Sublet Service</h5>
                                        <div class="table-responsive m-0" style="border: none;">
                                            <table class="table table-invoice m-0">
                                                <thead>
                                                <tr>
                                                    <th style="width: 5%"></th>
                                                    <th style="width: 50%"><strong>Sublet Description</strong></th>
                                                    <th style="width: 10%;">Time</th>
                                                    <th style="width: 10%;">Selling price</th>
                                                    <th style="width: 10%;">Amount</th>
                                                    <th style="width: 10%">5% Vat</th>
                                                    <th style="width: 10%">Net Total</th>
                                                </tr>
                                                </thead>
                                                <tbody>
                                                @foreach ($estimation->estimationSubletServices as $estimation_sublet_service)
                                                    <tr>
                                                        <td>
                                                            {{ $i . '.' }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_sublet_service->service->service_name }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_sublet_service->ss_time }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_sublet_service->ss_selling_price }}
                                                        </td>
                                                        <td>
                                                            {{ $estimation_sublet_service->ss_time * $estimation_sublet_service->ss_selling_price }}
                                                        </td>
                                                        <td>
                                                            @if ($estimation->show_vat == 'yes')
                                                                {{ $estimation_sublet_service->ss_time * $estimation_sublet_service->ss_selling_price * 0.05 }}
                                                            @else
                                                                {{ 0 }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            @if ($estimation->show_vat == 'yes')
                                                                {{ $estimation_sublet_service->ss_time * $estimation_sublet_service->ss_selling_price + $estimation_sublet_service->ss_time * $estimation_sublet_service->ss_selling_price * 0.05 }}
                                                            @else
                                                                {{ $estimation_sublet_service->ss_time * $estimation_sublet_service->ss_selling_price }}
                                                            @endif
                                                        </td>
                                                    </tr>
                                                                                                    @endforeach
                                                </tbody>
                                            </table>
                                            <p class="text-right m-r-15 m-b-0"><strong>Total Sublet Service
                                                    Cost: </strong>
                                                : <strong>{{ number_format($total_sublet_service, 2) }}</strong>
                                            </p>
                                        </div>
                                    </div>
                                </div>
                            @endif

                            <div class="row m-t-50">
                                                                <div class="col-md-8 col-sm-7 col-xs-6 ">
                                    <div>
                                        <h6>Remark : </h6>
                                    </div>
                                    <div class="clearfix m-t-40">
                                        <h5 class="text-inverse font-600 text-black">Total Amount In Words :
                                            @php
                                                $total_amount =
                                                  $spare_part_gross+ $service_gross + $sublet_gross+
                                                    $total_vat;
                                                $t_amount = new NumberFormatter('en', NumberFormatter::SPELLOUT);
                                                $num = explode('.', $total_amount);

                                                function capitalizeWords($str)
                                                {
                                                    return ucwords(strtolower($str));
                                                }

                                                $dollars_in_words = $t_amount->format($num[0]);
                                                $dollars_in_words_capitalized = capitalizeWords($dollars_in_words);

                                                $cents_in_words = isset($num[1])
                                                    ? $t_amount->format($num[1]) . ' Fils Only'
                                                    : 'Only';
                                                $cents_in_words_capitalized = capitalizeWords($cents_in_words);
                                            @endphp
                                            AED <span>{{ $dollars_in_words_capitalized }}
                                            </span>{{ $cents_in_words_capitalized }}
                                        </h5>

                                    </div>
                                </div>
                                <div class="col-md-4 col-sm-5 col-xs-6 ">
                                    <table class="table table-bordered table-amount text-right m-0">
                                        <tbody>
                                        <tr>
                                            <td>Gross Amount AED</td>
                                            <td>{{ number_format($spare_part_gross+ $service_gross + $sublet_gross, 2) }}
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>5% VAT</td>
                                            <td>{{ number_format($total_vat, 2) }}</td>
                                        </tr>
                                        <tr>
                                            <td><strong>Net Total AED</strong></td>
                                            <td>
                                                <strong>{{ number_format($spare_part_gross+ $service_gross + $sublet_gross+$total_vat , 2) }}</strong>
                                            </td>
                                        </tr>
                                        </tbody>
                                    </table>
                                </div>
                                <div class="col-xs-12">
                                    <h5 class="m-0"><b>Conditions of Estimate:-</b></h5>
                                    <ol>
                                        <li>
                                            <small>
                                                After dismantling, if any additional work or spare parts not covered
                                                by this estimate then a supplemnetary estimate will be
                                                provided. </small>
                                        </li>
                                        <li><small> All deliveries are subject to availability of spare
                                                parts </small></li>
                                        <li><small> Spare parts price subject to change without prior notice prices
                                                prevailing at the time of actual delivery shall be charged. </small>
                                        </li>
                                        <li><small> This estimate is valid for 15 days only,from the date.</small>
                                        </li>
                                    </ol>
                                </div>
                            </div>
                            <p>I/we hereby accept the terms mentioned above.</p>
                            <p>Name.................................................................. <span
                                    class="m-r-15"></span>
                                Signature.............................................................</p>
                            <hr>
                            <div class="hidden-print">
                                <div class="pull-right" id="pdf_button">
                                    <a href="{{ route('estimationPdfView', $estimation->id) }}" target="_blank"
                                       class="btn btn-inverse waves-effect waves-light"><i class="fa fa-print"></i></a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    @include('admin.advisor.models.sendMail')
    @include('admin.advisor.models.whatsapp')
@endsection
@push('footerscript')
    <script>
        document.addEventListener('DOMContentLoaded', function () {
            var content = document.getElementById('content');
            var footer = document.getElementById('footer');
            // Calculate available space
            var availableSpace = document.body.offsetHeight - content.offsetHeight;

            if (footer.offsetHeight > availableSpace) {
                // Add a page break before the footer
                var pageBreak = document.createElement('div');
                pageBreak.classList.add('page-break');
                content.appendChild(pageBreak);
            }
        });
    </script>
    <script>
        $(window).load(function () {
            $('#pdf_button').find('i').trigger('click');
        });

        function sendEmail(id, inspection, email) {
            $('#uid').val(id);
            $('#type').val(inspection);
            $('#email').val(email);
            $('#email-pdf-modal').modal('show');
        }

        $('.number').keyup(function (e) {
            if (/\D/g.test(this.value)) {
                this.value = this.value.replace(/\D/g, '');
            }
        });


        function whatsapp(mobile) {
            $('#whatsapp_no').val(mobile);
            $('#whatsapp-pdf-modal').modal('show');
        }
    </script>
@endpush