@if ($q_details->services_type == $services_type)
{{ $key = $key + 1 }} |
@endif
@if ($q_details->services_type == 'Visa' && $services_type == 'Visa')
Visa Service |
Adult CP |
Children CP |
Infant CP |
Adult SP |
Children SP |
Infant SP |
@foreach ($visa_json_decode_all_entries as $key_visa => $visa_all_entries)
@php
$visa_name = App\Visa_rates::where('id_visa_rates', $visa_all_entries->visa_service)->first();
$issue_visa_adult_cp = $hotel_json_decode_person_pricing_details[0]->visa_adult_cost_price;
$issue_visa_children_cp = $hotel_json_decode_person_pricing_details[0]->visa_children_cost_price;
$issue_visa_infant_cp = $hotel_json_decode_person_pricing_details[0]->visa_infant_cost_price;
$issue_visa_adult_sp = $hotel_json_decode_person_pricing_details[0]->visa_adult_selling_price;
$issue_visa_children_sp = $hotel_json_decode_person_pricing_details[0]->visa_children_selling_price;
$issue_visa_infant_sp = $hotel_json_decode_person_pricing_details[0]->visa_infant_selling_price;
$issue_q_detail_id = $q_details->id_quotation_details;
$issue_q_id = $q_details->quotation_id;
$issue_service_type = $q_details->services_type;
$issue_inq_id = $q_details->inquiry_id;
$issue_legs = $key_visa;
@endphp
{{ $visa_name->name }}
|
{{-- {{dd(get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'adult'))}} --}}
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'adult') != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'adult') : $land_services_json_decode_person_pricing_details[0]->visa_adult_cost_price }}
|
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'children') != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'children') : $land_services_json_decode_person_pricing_details[0]->visa_children_cost_price }}
|
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'infant') != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'infant') : $land_services_json_decode_person_pricing_details[0]->visa_infant_cost_price }}
|
{{ $land_services_json_decode_person_pricing_details[0]->visa_adult_selling_price }}
|
{{ $land_services_json_decode_person_pricing_details[0]->visa_children_selling_price }}
|
{{ $land_services_json_decode_person_pricing_details[0]->visa_infant_selling_price }}
|
|
@endforeach
Quotation ROE: {{$q_details->default_rate_of_exchange_amt}} - {{$q_details->default_rate_of_exchange}} = Total (Quotation ROE): 0 = Total (Today ROE: 0 - ): 0
@elseif($q_details->services_type == 'Air Ticket' && $services_type == 'Air Ticket')
Airline Name |
Flight No |
Adult CP |
Children CP |
Infant CP |
Adult SP |
Children SP |
Infant SP |
{{-- {{dd($get_sub_total_entries)}} --}}
@foreach ($air_ticket_json_decode_all_entries as $key_airline => $air_ticket_all_entries)
@php
$issue_airline_adult_cp = $get_sub_total_entries[0]->airline_adult_cost_price;
$issue_airline_children_cp = $get_sub_total_entries[0]->airline_children_cost_price;
$issue_airline_infant_cp = $get_sub_total_entries[0]->airline_infant_cost_price;
$issue_airline_adult_sp = $get_sub_total_entries[0]->airline_adult_selling_price;
$issue_airline_children_sp = $get_sub_total_entries[0]->airline_children_selling_price;
$issue_airline_infant_sp = $get_sub_total_entries[0]->airline_infant_selling_price;
$issue_q_detail_id = $q_details->id_quotation_details;
$issue_q_id = $q_details->quotation_id;
$issue_service_type = $q_details->services_type;
$issue_inq_id = $q_details->inquiry_id;
$issue_legs = $key_airline;
@endphp
@php
$get_airline_name = App\airlines::where('id_airlines', $air_ticket_all_entries->airline_name)
->select('Airline')
->first();
@endphp
{{ $get_airline_name->Airline }}
|
{{ $air_ticket_all_entries?->flight_number }}
|
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'adult') != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'adult') : $get_sub_total_entries[0]->airline_adult_cost_price }}
|
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'children') != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'children') : $get_sub_total_entries[0]->airline_children_cost_price }}
|
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'infant') != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs, 'infant') : $get_sub_total_entries[0]->airline_infant_cost_price }}
|
{{ $get_sub_total_entries[0]->airline_adult_selling_price }}
|
{{ $get_sub_total_entries[0]->airline_children_selling_price }}
|
{{ $get_sub_total_entries[0]->airline_infant_selling_price }}
|
@endforeach
Airline Arrival Date |
Airline Arrival Destination |
Airline Departure Destination |
Arrival Time |
Departure Time |
Airline Flight Class |
@foreach ($air_ticket_json_decode_all_entries as $air_ticket_all_entries)
{{ $air_ticket_all_entries?->airline_arrival_date }}
|
{{ $air_ticket_all_entries?->airline_arrival_destination }}
|
{{ $air_ticket_all_entries?->airline_departure_destination }}
|
{{ $air_ticket_all_entries?->arrival_time }}
|
{{ $air_ticket_all_entries?->departure_time }}
|
{{ $air_ticket_all_entries?->airline_flight_class }}
|
@endforeach
@elseif($q_details->services_type == 'Land Services' && $services_type == 'Land Services')
Land Service Name |
Transport |
Route |
Cost Price |
Selling Price |
@foreach ($land_services_json_decode_all_entries as $key_land => $land_services_all_entries)
{{-- {{ dd($land_services_json_decode_person_pricing_details) }} --}}
{{-- @foreach ($land_services_json_decode_person_pricing_details as $land_pricing) --}}
@php
$get_land_services_name = App\Landservicestypes::where('id_land_and_services_types', $land_services_all_entries->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
{{ $get_land_services_name->service_name }}
|
{{ $land_services_all_entries?->transport }}
|
{{ $land_services_all_entries?->land_services_route }}
|
@php
$issue_cp = $land_services_json_decode_person_pricing_details[$key_land]->land_services_cost_price;
$issue_sp = $land_services_json_decode_person_pricing_details[$key_land]->land_services_selling_price;
$issue_q_detail_id = $q_details->id_quotation_details;
$issue_q_id = $q_details->quotation_id;
$issue_service_type = $q_details->services_type;
$issue_inq_id = $q_details->inquiry_id;
$issue_legs = $key_land;
// dd($issue_q_details);
@endphp
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs) != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs) : $land_services_json_decode_person_pricing_details[$key_land]->land_services_cost_price }}
|
{{ $land_services_json_decode_person_pricing_details[$key_land]->land_services_selling_price }}
|
{{-- @endforeach --}}
@endforeach
Quotation ROE: {{$q_details->default_rate_of_exchange_amt}} - {{$q_details->default_rate_of_exchange}} = Total (Quotation ROE): 0 = Total (Today ROE: 0 - ): 0
@elseif($q_details->services_type == 'Hotel' && $services_type == 'Hotel')
S.No |
Hotel Name |
Room Type |
Qty |
Nights |
Hotel Addon |
Send Verification |
@php
$get_size_hotel_name = sizeof($hotel_json_decode_all_entries);
// dd($hotel_json_decode_all_entries);
$i = 0;
@endphp
@for ($i; $i < $get_size_hotel_name; $i++)
{{ $i + 1 }} |
@php
$get_hotel_name = App\hotels::where('id_hotels', $hotel_json_decode_all_entries[$i]->hotel_name)
->select('hotel_name')
->first();
$get_room_type = App\room_type::where('id_room_types', $hotel_json_decode_all_entries[$i]->room_type)
->select('name')
->first();
@endphp
{{ $get_hotel_name?->hotel_name }}
|
{{ $get_room_type?->name }}
|
{{ $hotel_json_decode_person_pricing_details[$i]->hotel_qty }}
|
{{ $hotel_json_decode_all_entries[$i]->hotel_nights }}
|
{{ $hotel_json_decode_all_entries[$i]->hotel_addon != 'Select Addon' ? $hotel_json_decode_all_entries[$i]->hotel_addon : '-' }}
|
@php
// dd(check_issuance_verification(null, $q_details->quotation_id, $i, 'Hotel'));
@endphp
@if($get_rejected_issuance?->service_type == \Crypt::decrypt(request()->services_type))
@elseif($get_rejected_issuance?->service_type !== \Crypt::decrypt(request()->services_type))
@endif
|
@endfor
S.No |
Cost Price |
Selling Price |
Hotel Check In |
Hotel Check Out |
@php
$get_size_hotel_name = sizeof($hotel_json_decode_all_entries);
// dd($hotel_json_decode_person_pricing_details);
$i = 0;
@endphp
@for ($i; $i < $get_size_hotel_name; $i++)
{{ $i + 1 }} |
@php
$issue_cp = $hotel_json_decode_person_pricing_details[$i]->hotel_cost_price;
$issue_sp = $hotel_json_decode_person_pricing_details[$i]->hotel_selling_price;
$issue_q_detail_id = $q_details->id_quotation_details;
$issue_q_id = $q_details->quotation_id;
$issue_service_type = $q_details->services_type;
$issue_inq_id = $q_details->inquiry_id;
$issue_legs = $i;
// dd($issue_q_details);
@endphp
{{ get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs) != null ? get_issuance_cost_price($issue_q_id, $issue_service_type, $issue_legs) : $hotel_json_decode_person_pricing_details[$i]->hotel_cost_price }}
|
{{ $hotel_json_decode_person_pricing_details[$i]->hotel_selling_price }}
|
{{ $hotel_json_decode_all_entries[$i]->hotel_check_in }}
|
{{ $hotel_json_decode_all_entries[$i]->hotel_check_out }}
|
@endfor
Quotation ROE: {{$q_details->default_rate_of_exchange_amt}} - {{$q_details->default_rate_of_exchange}} = Total (Quotation ROE): 0 = Total (Today ROE: 0 - ): 0
@endif
|
{{-- {{dd($q_details)}} --}}
@if ($q_details->services_type == $services_type)
{{ $q_details->services_type }} |
@endif
@if ($q_details->services_type == 'Visa' && $services_type == 'Visa')
{{ $get_sub_total_entries[0]->visa_total_selling_price }} |
@elseif ($q_details->services_type == 'Air Ticket' && $services_type == 'Air Ticket')
{{ $get_sub_total_entries[0]->airline_total_selling_price }}
|
@elseif($q_details->services_type == 'Land Services' && $services_type == 'Land Services')
{{ $q_details->sub_total }} |
@elseif($q_details->services_type == 'Hotel' && $services_type == 'Hotel')
{{ $get_sub_total_entries[0]->hotel_total_selling_price }}
|
@endif
@if ($q_details->services_type == $services_type)
{{ $q_details->discount }} |
{{ $q_details->total }} |
@endif
@endforeach