{{ $get_quotation->quotation_no }} Lum Sum @if ($get_quotation->status == 0) Pending @endif

Travocom

3184 Spruce Drive Pittsburgh, PA 15201

support@travocom.com

09-00-78601


Quotatation To:
{{ $get_customer->customer_name }}

{{ $get_customer->customer_email }}

{{ $get_customer->customer_cell }}

Quotation No:

{{ $get_quotation->quotation_no }}

Quotation Date:

{{ $get_quotation->created_at->format('d M Y') }}

Quotation Summary
{{-- --}} {{-- {{dd($quotation_details)}} --}} @foreach ($quotation_details as $key => $q_details) @php $decode_all_entries = json_decode($q_details->all_entries); $decode_person_pricing_details = json_decode($q_details->person_pricing_details); $decode_sub_total_details = json_decode($q_details->sub_total_details); // dd($decode_person_pricing_details); @endphp @if ($q_details->services_type == 'Visa') {{-- {{dd($decode_sub_total_details)}} --}} @elseif ($q_details->services_type == 'Air Ticket') @elseif($q_details->services_type == 'Land Services') @elseif($q_details->services_type == 'Hotel') @endif {{-- --}} {{-- --}} {{-- {{dd($decode_sub_total_details[0])}} --}} @endforeach
@if (isset($decode_sub_total_details[0]->lum_sum_adult_total_selling_price)) {{-- {{dd($decode_sub_total_details)}} --}} @else {{-- {{dd($decode_sub_total_details)}} --}} {{-- --}} @endif
No. Description Service TypeSub Total Discount Total
{{ $key = $key + 1 }}
@if ($q_details->services_type == 'Visa') @php $get_size = sizeof($decode_all_entries); // dd($decode_all_entries); // dd($hotel_json_decode_person_pricing_details); $i = 0; @endphp @for ($i; $i < $get_size; $i++) {{-- --}} {{-- --}} {{-- --}} @endfor
Visa Service Adult CP Children CP Infant CP
@php $visa_name = App\Visa_rates::where('id_visa_rates', $decode_all_entries[$i]->visa_service) ->select('name') ->first(); @endphp {{ $visa_name->name }} {{ $decode_person_pricing_details[$i]->visa_adult_cost_price }} {{ $decode_person_pricing_details[$i]->visa_children_cost_price }} {{ $decode_person_pricing_details[$i]->visa_infant_cost_price }} NO: {{ $decode_person_pricing_details[$i]->visa_no_of_adults }} CP: {{ $decode_person_pricing_details[$i]->visa_adult_cost_price }} SP: {{ $decode_person_pricing_details[$i]->visa_adult_selling_price }} NO: {{ $decode_person_pricing_details[$i]->visa_no_of_children }} CP: {{ $decode_person_pricing_details[$i]->visa_children_cost_price }} SP: {{ $decode_person_pricing_details[$i]->visa_children_selling_price }} NO: {{ $decode_person_pricing_details[$i]->visa_no_of_infant }} CP: {{ $decode_person_pricing_details[$i]->visa_infant_cost_price }} SP: {{ $decode_person_pricing_details[$i]->visa_infant_selling_price }}
@elseif($q_details->services_type == 'Air Ticket') @php // dd($decode_person_pricing_details); $get_size = sizeof($decode_all_entries); // dd($hotel_json_decode_person_pricing_details); $i = 0; @endphp @for ($i; $i < $get_size; $i++) @php $get_airline_name = App\airlines::where('id_airlines', $decode_all_entries[$i]->airline_name) ->select('Airline') ->first(); @endphp {{-- --}} @endfor
Airline Name Flight No Airline Arrival Date Airline Arrival Destination Airline Departure Destination
{{ $get_airline_name?->Airline }} {{ $decode_all_entries[$i]->flight_number }} {{ $decode_all_entries[$i]->airline_arrival_date }} {{ $decode_all_entries[$i]->airline_arrival_destination }} {{ $decode_all_entries[$i]->airline_departure_destination }} NO: {{ $decode_person_pricing_details[0]->airline_no_of_adult }} CP: {{ $decode_person_pricing_details[0]->airline_adult_cost_price }} SP: {{ $decode_person_pricing_details[0]->airline_adult_selling_price }} NO: {{ $decode_person_pricing_details[0]->airline_no_of_children }} CP: {{ $decode_person_pricing_details[0]->airline_children_cost_price }} SP: {{ $decode_person_pricing_details[0]->airline_children_selling_price }} NO: {{ $decode_person_pricing_details[0]->airline_no_infants }} CP: {{ $decode_person_pricing_details[0]->airline_infant_cost_price }} SP: {{ $decode_person_pricing_details[0]->airline_infant_selling_price }}
@php // dd($decode_person_pricing_details); $get_size = sizeof($decode_all_entries); // dd($hotel_json_decode_person_pricing_details); $i = 0; @endphp @for ($i; $i < $get_size; $i++) @php $get_airline_name = App\airlines::where('id_airlines', $decode_all_entries[$i]->airline_name) ->select('Airline') ->first(); @endphp {{-- --}} @endfor
Arrival Time Departure Time Airline Flight Class Adult Children Infant
{{ $decode_all_entries[$i]->arrival_time }} {{ $decode_all_entries[$i]->departure_time }} {{ $decode_all_entries[$i]->airline_flight_class }} {{ $decode_person_pricing_details[0]->airline_adult_cost_price }} {{ $decode_person_pricing_details[0]->airline_children_cost_price }} {{ $decode_person_pricing_details[0]->airline_infant_cost_price }} NO: {{ $decode_person_pricing_details[0]->airline_no_of_adult }} CP: {{ $decode_person_pricing_details[0]->airline_adult_cost_price }} SP: {{ $decode_person_pricing_details[0]->airline_adult_selling_price }} NO: {{ $decode_person_pricing_details[0]->airline_no_of_children }} CP: {{ $decode_person_pricing_details[0]->airline_children_cost_price }} SP: {{ $decode_person_pricing_details[0]->airline_children_selling_price }} NO: {{ $decode_person_pricing_details[0]->airline_no_infants }} CP: {{ $decode_person_pricing_details[0]->airline_infant_cost_price }} SP: {{ $decode_person_pricing_details[0]->airline_infant_selling_price }}
@elseif($q_details->services_type == 'Land Services') @php // dd($decode_all_entries); // dd($decode_person_pricing_details); $get_size = sizeof($decode_person_pricing_details); // dd($decode_all_entries); $i = 0; @endphp @for ($i; $i < $get_size; $i++) {{-- {{dd($decode_all_entries)}} --}} @php $get_land_services_name = App\Landservicestypes::where('id_land_and_services_types', $decode_all_entries[0]->land_service) ->select('service_name') ->join('land_services_types', 'land_services_types.id_land_services_types', '=', 'land_and_services_types.name') ->first(); // dd($get_land_services_name); @endphp @isset($decode_all_entries[$i]->land_service) @endisset @isset($decode_all_entries[$i]->transport) @endisset @isset($decode_all_entries[$i]->land_services_route) @endisset {{-- {{dd($decode_person_pricing_details)}} --}} @endfor
Land Service Transport Route
{{ $get_land_services_name->service_name }} {{ $decode_all_entries[$i]->transport }} {{ $decode_all_entries[$i]->land_services_route }}
@elseif($q_details->services_type == 'Hotel') @php // dd($decode_all_entries); // dd($decode_person_pricing_details); $get_size = sizeof($decode_person_pricing_details); // dd($hotel_json_decode_person_pricing_details); $i = 0; @endphp @for ($i; $i < $get_size; $i++) @php $get_hotel_name = App\hotels::where('id_hotels', $decode_all_entries[$i]->hotel_name) ->select('hotel_name') ->first(); $get_room_type = App\room_type::where('id_room_types', $decode_all_entries[$i]->room_type) ->select('name') ->first(); @endphp @endfor
Hotel Name Room Type Qty Nights Hotel Addon
{{ $get_hotel_name?->hotel_name }} {{ $get_room_type?->name }} {{ $decode_person_pricing_details[$i]->hotel_qty }} {{ $decode_person_pricing_details[$i]->hotel_nights }} {{ $decode_all_entries[$i]->hotel_addon != 'Select Addon' ? $decode_all_entries[$i]->hotel_addon : '-' }}
@php // dd($decode_all_entries); // dd($decode_person_pricing_details); $get_size = sizeof($decode_person_pricing_details); // dd($hotel_json_decode_person_pricing_details); $i = 0; @endphp @for ($i; $i < $get_size; $i++) @php $get_hotel_name = App\hotels::where('id_hotels', $decode_all_entries[$i]->hotel_name) ->select('hotel_name') ->first(); $get_room_type = App\room_type::where('id_room_types', $decode_all_entries[$i]->room_type) ->select('name') ->first(); @endphp @endfor
Hotel Check In Hotel Check Out Adult Children Infant
{{ $decode_all_entries[$i]->hotel_check_in }} {{ $decode_all_entries[$i]->hotel_check_out }} {{ $decode_person_pricing_details[$i]->hotel_adult_cost_price }} {{ $decode_person_pricing_details[$i]->hotel_children_cost_price }} {{ $decode_person_pricing_details[$i]->hotel_infant_cost_price }}
@endif
{{ $q_details->services_type }} {{ $decode_sub_total_details[0]->visa_total_cost_price }} {{ $decode_sub_total_details[0]->visa_discount ? $decode_sub_total_details[0]->visa_discount : '-' }} {{ $decode_sub_total_details[0]->visa_total }} {{ $decode_sub_total_details[0]->airline_total }} {{ $decode_sub_total_details[0]->airline_discount ? $decode_sub_total_details[0]->airline_discount : '-' }} {{ $decode_sub_total_details[0]->airline_total }} {{ $decode_sub_total_details[0]->land_services_sub_total }} {{ $decode_sub_total_details[0]->land_services_discount ? $decode_sub_total_details[0]->land_services_discount : '-' }} {{ $decode_sub_total_details[0]->land_services_total }} {{ $decode_sub_total_details[0]->hotel_total_cost_price }} {{ $decode_sub_total_details[0]->hotel_discount ? $decode_sub_total_details[0]->hotel_discount : '-' }} {{ $decode_sub_total_details[0]->hotel_total }}{{$decode_sub_total_details[0]->visa_total_cost_price}}{{ $decode_sub_total_details[0]->visa_discount }}
Total Adult Selling Price : {{ $decode_sub_total_details[0]->lum_sum_adult_total_selling_price }}/-
Total Children Selling Price : {{ $decode_sub_total_details[0]->lum_sum_children_total_selling_price }}/-
Total Infant Selling Price : {{ $decode_sub_total_details[0]->lum_sum_infant_total_selling_price }}/-
Lum Sum Profit
{{ $decode_sub_total_details[0]->lum_sum_profit }}/-
Total Adult Selling Price : {{ $decode_person_pricing_details[0]->lum_sum_adult_total_selling_price }}/-
Total Children Selling Price : {{ $decode_person_pricing_details[0]->lum_sum_children_total_selling_price }}/-
Total Infant Selling Price : {{ $decode_person_pricing_details[0]->lum_sum_infant_total_selling_price }}/-
Discount {{ $discount }}/-
Lum Sum Profit
{{ $decode_person_pricing_details[0]->lum_sum_profit }}/-
Total

{{ $total }}/-