No.	Designation	Name	Status	Remark	Date & Time
{{$key+1}}	{{ucwords($val->designation)}}	{{ucwords($val->logs_creator)}}	{{ucwords(str_replace('_', ' ', $val->status))}}	{{ucwords($val->remark)}}	{{ \Carbon\Carbon::parse($val->created_at)->format('d-m-Y h:i A') }}
Logs Not Created...

Personal Details

Booking Date	:	{{ date('d-m-Y',strtotime($data->booking_date)) ?? 'N/A' }}	Customer Name	:	{{ $data->customer_name ?? 'N/A' }}
Branch	:	{{ $data->branch_name ?? 'N/A' }}	RTO Type	:	@php $customer_type = $data->customer_type; if ($customer_type == 'bh_parsing') { $rto_type = 'BH Passing'; } else { $rto_type = ucwords(str_replace('_', ' ', $data->customer_type)); } @endphp {{ $rto_type ?? 'N/A' }}
Customer Type	:	{{ $data->customer_type_nm ?? 'N/A' }}	Company Name	:	{{ $data->company_name ?? 'N/A' }}
E-Invoice Applicable	:	{{ ucwords($data->einvoicing_applicable) ?? 'N/A' }}	GST	:	{{ $data->gst ?? 'N/A' }}
Address Correspondence	:	{{ $data->address ?? 'N/A' }}	Registration Correspondence	:	{{ $data->registration ?? 'N/A' }}
E-Mail	:	{{ $data->email ?? 'N/A' }}	Mobile Number	:	{{ $data->contact_number ?? 'N/A' }}
PAN No	:	{{ $data->pan_number ?? 'N/A' }}	Aadhar No	:	{{ $data->adhar_number ?? 'N/A' }}
Voter ID No	:	{{ $data->licance_number ?? 'N/A' }}	Date of Birth	:	{{ $data->dob ? \Carbon\Carbon::parse($data->dob)->format('d-m-Y') : 'N/A' }}
Nominee Name	:	{{ $data->nominee_name ?? 'N/A' }}	Nominee Relation	:	{{ $data->nominee_reletion ?? 'N/A' }}
Nominee Age	:	{{ $data->nominee_age ?? 'N/A' }}	Occupation	:	{{ $data->occupation ?? 'N/A' }}
Nominee DOB	:	{{ $data->nominee_dob ? \Carbon\Carbon::parse($data->nominee_dob)->format('d-m-Y') : 'N/A' }}	Anniversary DOB	:	{{ $data->anniversary_date ? \Carbon\Carbon::parse($data->anniversary_date)->format('d-m-Y') : 'N/A' }}

Car Details

Car Model	:	{{ $data->car_model_name ?? 'N/A' }}	Sales Person Name	:	{{ $data->sales_person_name ?? 'N/A' }}
Car Variant	:	{{ $data->car_varient_name ?? 'N/A' }}	Team Leader Name	:	{{ $data->team_name ?? 'N/A' }}
Exterior Color	:	{{ $data->exteriorcolor_name ?? 'N/A' }}	Fuel Type	:	{{ $fule->fule_name ?? 'N/A' }}
Interior Color	:	{{$data->interiorcolor_name ?? 'N/A' }}	Key Number	:	{{$data->key_number ?? 'N/A' }}
VIN Number	:	{{$data->vin_number ?? 'N/A' }}	MFG Year	:	{{$data->manufacturing_year ?? 'N/A' }}
Engine Number	:	{{$data->engine_number ?? 'N/A' }}	Remarks	:	{{ $data->step1_remarks ?? 'N/A' }}

On Road Price

@php $on_road_price = $data->on_road_price ?? 0; $total_discount = $data->offer_amount ?? 0; $total_payment_received = ($data->booking_amount ?? 0) + ($data->dp_amount ?? 0) + ($data->net_disbusment ?? 0) + ($data->total_exchange_amount ?? 0); $finance_dis = ($data->offer_ib_amount ?? 0) + ($data->offer_kin_amount ?? 0) + ($data->finance_discount ?? 0) + ($data->way_off ?? 0) + ($data->tl_discount ?? 0) + ($data->sm_discount ?? 0) + ($data->gm_discount ?? 0) + ($data->bh_discount ?? 0) + ($data->ceo_discount ?? 0) + ($data->md_discount ?? 0) + ($data->foc_accessories ?? 0); $due_amount = $on_road_price - $total_payment_received - $finance_dis; $total_ofr_discount = ($data->offer_ib_amount ?? 0) + ($data->offer_kin_amount ?? 0) + ($data->exchange_bonus ?? 0) + ($data->finance_discount ?? 0) + ($data->way_off ?? 0) + ($data->tl_discount ?? 0) + ($data->sm_discount ?? 0) + ($data->gm_discount ?? 0) + ($data->bh_discount ?? 0) + ($data->ceo_discount ?? 0) + ($data->md_discount ?? 0) + ($data->foc_accessories ?? 0); $final_total = $on_road_price - $total_ofr_discount; $total_accessories = ($accessory_sum ?? 0) + ($data->other_accesssories_prise ?? 0); $rto_tax = ($data->registration_tax_id ?? 0) + ($data->rto_custom_handling_charges ?? 0); @endphp

Customer Payment Status
Ex Showroom	{{ $data->ex_showroom_price ?? 'N/A' }}
TCS 1% (5% if Link Status No.)	{{ $data->tcs_tax_id ?? 'N/A' }}
RTO (6%/12%/5%)	{{ $rto_tax }}
Municipal Tax	{{ $data->municipal_tax_id ?? 'N/A' }}
Municipal Custom Handling Charges	{{ $data->municipal_custom_handling_charges ?? 'N/A' }}
Insurance	{{ $data->insurance_id ?? 'N/A' }}
Road Side Assist	{{ $data->rsa_amount ?? 'N/A' }}
CCS	{{ $data->ccs_amount ?? 'N/A' }}
Extended Warranty	{{ $data->extand_warranties_amount ?? 'N/A' }}
MCP / MCP +
Fastag	{{ $data->brand_name ?? 'N/A' }}
Accessories	{{$total_accessories ?? '0'}}
Other_1	{{ $data->other_one_name ?? 'N/A' }}
Other_2	{{ $data->other_two_name ?? 'N/A' }}
On Road Price (A)	{{ $data->on_road_price ?? 'N/A' }}
Less: Total Discount (B)	{{ $total_ofr_discount ?? 'N/A' }}
Final Deal On Road (A - B = C)	{{$final_total}}

Booking Amt.	{{ $data->booking_amount ?? 'N/A' }}
Down Payment	{{ $data->dp_amount ?? 'N/A' }}
Finance Disb. Amt.	{{$data->net_disbusment ?? 'N/A'}}
Exchange Amt.	{{ $data->total_exchange_amount ?? 'N/A' }}
Total Payment Received (D)	{{ $total_payment_received }}
Due Amount (+)/Refund (-) (C - D)	{{$due_amount}}

@php $customer_type = $data->customer_type; if ($customer_type == 'bh_parsing') { $rto_type = 'BH Passing'; } else { $rto_type = ucwords(str_replace('_', ' ', $data->customer_type)); } @endphp

Discount Breakdown
Price List	{{ $price_list_name[0]->price_list_name ?? 'N/A' }}
Adhar/Pan Link Status	{{ucwords($data->aadhar_pan_link)}}
RTO Type	{{ $rto_type ?? 'N/A' }}
Customer Type	{{ ucwords($data->customer_type_nm) ?? 'N/A' }}
Customer Address	RMC ({{ ucwords(str_replace('_', '-', $data->municipal_tax_type)) }})
{{$data->registration}}
Insurance Company	{{ $ObfInsurance->company_name ?? 'N/A' }}
Insurance Remark	{{ $data->step3_remarks ?? 'N/A' }}
Package (RSA)	{{ $data->rsa_name ?? 'N/A' }}
Package (CCS)	{{ $data->ccs_name ?? 'N/A' }}
Package (EW)	{{ $data->extand_warranties_years}}
Package (MCP)
Fastag Com. Name	{{ $data->brand_name ?? 'N/A' }}

Shimav Kia Offer	{{ $data->offer_ib_amount ?? '0' }}
KIN Offer	{{ $data->offer_kin_amount ?? '0' }}
Finance Disc	{{ $data->finance_discount ?? '0' }}
FOC Accessories	{{ $data->foc_accessories ?? '0' }}
KEC Discount	{{ $data->way_off ?? '0' }}
TL Discount	{{ $data->tl_discount ?? '0' }}
SM Discount	{{ $data->sm_discount ?? '0' }}
GM Discount	{{ $data->gm_discount ?? '0' }}
BH Discount	{{ $data->bh_discount ?? '0' }}
C.E.O Discount	{{ $data->ceo_discount ?? '0' }}
MD Discount	{{ $data->md_discount ?? '0' }}
Total Discount (B)	{{$total_ofr_discount}}

Bank Name	{{ $data->finance_name }}
Finance By	{{ ucwords(str_replace("_", " ", $data->finance_type))}}
Exchange Car Name	{{ $data->trade_car_name }}

Finance Details

@if($is_finance_display_filds == 1) @if(!empty($Inventory_data)) @endif

Finance Required	:	{{ucwords($data->finance_required)}}	Finance	:	{{ $data->finance_name ?? 'N/A' }}
Repo Rate	:	{{ $data->repo_rate ?? 'N/A' }}	Net Disbusment Amount	:	{{ $data->net_disbusment ?? 'N/A' }}
Loan Amount	:	{{ $data->loan_amount ?? 'N/A' }}	Processing Fee	:	{{ $data->processing_fee ?? 'N/A' }}
Finance Discount	:	{{ $data->finance_discount ?? 'N/A' }}	Payout	:	{{ $data->payout ?? 'N/A' }}
Pay Booster	:	{{ucwords($data->pay_booster)}}	Allocation Date	:	{{ date('d-m-Y',strtotime($Inventory_data->updated_at)) ?? 'N/A' }}
Aging Days	:	{{ now()->diffInDays($Inventory_data->kin_invoice_date) ?? '' }}	Kin Invoice Date	:	{{ date('d-m-Y',strtotime($Inventory_data->kin_invoice_date)) ?? 'N/A' }}
Allocation Count: {{ $Inventory_data->allocation_count ?? 'N/A' }}	Disbursement Field	:	{{ucwords($data->disbursement)}}
Finance Type	:	{{ucwords(str_replace('_', ' ', $data->finance_type))}}	Payout Amount	:	{{$data->payout_amount}}
Lumsum Amount	:	{{$data->lumsum_amount}}	Total Payout	:	{{$data->total_payout_amount}}
Remarks	:	{{$data->step2_remarks ?? 'N/A'}}

@endif

Insurance Details

@php $ncb = ''; if(isset($ObfInsurance->ncb) && $ObfInsurance->ncb != null){ $ncb = $ObfInsurance->ncb; } @endphp @php $documents = []; if(isset($ObfInsurance->documents) && $ObfInsurance->documents != null){ $documents = $ObfInsurance->documents; } @endphp

Insurance	:	@if(isset($ObfInsurance) && !empty($ObfInsurance)) @if($ObfInsurance->insurance_exist == 1) Yes @else if($ObfInsurance->insurance_exist == 2) No @endif @else No @endif	NCB - No Claim Bonus	:	@if($ncb =='yes' \|\| $ncb == '') Yes @endif @if($ncb == 'no') No @endif
Date of Insurance	:	{{ $ObfInsurance->date_of_insurance ?? 'N/A' }}	@php $time_of_insurance = ''; if(isset($ObfInsurance->time_of_insurance) && $ObfInsurance->time_of_insurance != null){ $time_of_insurance = $ObfInsurance->time_of_insurance; } @endphp Time of Insurance	:	{{ $ObfInsurance->time_of_insurance ?? 'N/A' }}
Last Date of Insurance	:	{{ $ObfInsurance->last_time_of_insurance ?? '' }}	Company Name	:	{{ $ObfInsurance->company_name ?? 'N/A' }}
Amount	:	{{ $ObfInsurance->ncb_amount ?? 'N/A' }}	Policy Number	:	{{ $ObfInsurance->policy_number ?? 'N/A' }}
@php $insurance_status = ''; if(isset($ObfInsurance->insurance_status) && $ObfInsurance->insurance_status != null){ $insurance_status = $ObfInsurance->insurance_status; } @endphp Status	:	@if($insurance_status == '1' \|\| $insurance_status == '') Activate @endif @if($insurance_status == '0') Deactivate @endif
Tyer 1	:	{{ $ObfInsurance->tyre_no1 ?? 'N/A' }}	Tyer 2	:	{{ $ObfInsurance->tyre_no2 ?? 'N/A' }}
Tyer 3	:	{{ $ObfInsurance->tyre_no3 ?? 'N/A' }}	Tyer 4	:	{{ $ObfInsurance->tyre_no4 ?? 'N/A' }}
Tyer 5	:	{{ $ObfInsurance->tyre_no5 ?? 'N/A' }}	Remarks	:	{{ $data->step3_remarks ?? 'N/A' }}

RTO Details

RTO Type	:	{{ucwords(str_replace('_', ' ', $data->rto_type))}}	Registration Date	:	{{ $data->registration_date ?? 'N/A' }}
Application Number	:	{{ $data->application_number ?? 'N/A' }}	Temporary Number	:	{{ $data->temporary_number ?? 'N/A' }}
Final amount	:	{{ $data->final_amount ?? 'N/A' }}	Vehicle Number	:	{{ $data->vehicle_number ?? 'N/A' }}
Status	:	@if($data->rto_status == '1') Activate @endif @if($data->rto_status != '1') Deactivate @endif	Number Plate	:	{{ $data->number_plate ?? '' }}
Remarks	:	{{ $data->step4_remarks ?? 'N/A' }}

Fasttag Details

Fasttag number	:	{{ $data->fasttag_number ?? 'N/A' }}	Brand	:	{{ $data->fasttag_brand ?? 'N/A' }}
Date of issue	:	{{ date('d-m-Y',strtotime($data->date_of_issue)) ?? 'N/A' }}	Amount	:	{{ $data->fasttag_amount ?? 'N/A' }}
Opening stock	:	{{ $data->opening_stock ?? 'N/A' }}	Status	:	@if($data->fasttag_status == '1') Activate @endif @if($data->fasttag_status != '1') Deactivate @endif
Remarks	:	{{ $data->step5_remarks ?? 'N/A' }}

Reverse Calculation
Booking Date	{!! \Carbon\Carbon::parse($make_deal_data->booking_date)->format('d-m-Y') !!}		KEC	{!! $make_deal_data->sales_person_name !!}
Customer Name	{!! $make_deal_data->customer_name !!}		TL	{!! strtoupper($make_deal_data->team_name) !!}
Location (Branch)	{!! strtoupper($make_deal_data->branch_name) !!}
Vin No.	{!! $make_deal_data->vin_number !!}
{!! $make_deal_data->car_model_name !!}	Purchase Price	Aging Days	Remark	Ex Showroom Price	Deal
{!! $make_deal_data->car_varient_name !!}	{!! $make_deal_data->purchase_price !!}	{!! $make_deal_data->aging_days !!}	{!! $make_deal_data->remark !!}	{!! $price_list_name_data->basic ?? 0 !!}	{{ $make_deal_data->deal_amt ?? 0 }}
GST @ {!! $price_list_name_data->gst_percentage !!}%	{{ $make_deal_data->purchase_gst_tax_deal ?? 0 }}	{!! $price_list_name_data->gst_amount !!}			{{ $make_deal_data->gst_tax_deal ?? 0 }}
Cess @ {!! $price_list_name_data->cess_percentage !!}%	{!! $price_list_name_data->cess_amount !!}				{{ $make_deal_data->cess_tax_deal ?? 0 }}
TCS @ 1%	{!! $make_deal_data->tcs_tax_id !!}				{{ $make_deal_data->tcs_tax_deal ?? 0 }}
Municipal Tax	{!! $make_deal_data->municipal_tax_id !!}				{{ $make_deal_data->municipal_tax_deal ?? 0 }}
Municipal Custom Handling Charges	{!! $make_deal_data->municipal_custom_handling_charges !!}				{{ $make_deal_data->municipal_custom_handling_charges_deal ?? 0 }}
RTO	{!! $make_deal_data->registration_tax_id !!}				{{ $make_deal_data->rto_deal ?? 0 }}
RTO Custom Handling Charges	{!! $make_deal_data->rto_custom_handling_charges ?? 0 !!}				{{ $make_deal_data->rto_cutom_handling_charges_deal ?? '' }}
INSURANCE	{!! $make_deal_data->insurance_id ?? 0 !!}				{{ $make_deal_data->insurance_deal ?? 0 }}
Fastag	{!! $make_deal_data->fasttag_amount_new ?? 0 !!}				{!! $make_deal_data->fasttag_amount_new ?? 0 !!}
EW	{!! $make_deal_data->extand_warranties_amount ?? 0!!}				{!! $make_deal_data->extand_warranties_amount ?? 0 !!}
Accessories	{!! $accessory_sum ?? 0 !!}				{!! $accessory_sum ?? 0 !!}
Other Accessories	{!! $make_deal_data->other_accesssories_prise ?? 0 !!}				{!! $make_deal_data->other_accesssories_prise ?? 0 !!}
{{ $make_deal_data->rsa_type == 'RSA' ? 'RSA' : ($make_deal_data->ccs_type == 'CCS' ? 'CCS' : 'RSA / CCS') }}	{!! $make_deal_data->rsa_amount ?? $make_deal_data->ccs_amount ?? 0 !!}				{!! $make_deal_data->rsa_amount ?? $make_deal_data->ccs_amount ?? 0 !!}
MCP	{!! $make_deal_data->mcp_amount ?? 0 !!}				{!! $make_deal_data->mcp_amount ?? 0 !!}

Total On Road Price
Accepted Deal	{{ $make_deal_data->final_deal_amt ?? $make_deal_data->final_on_road_price_after_way_off }}				{!! $make_deal_data->final_deal_amt ?? '' !!}
Difference