Claim Consolidated Report

Sr.No.	Intimation Date	Intimation Type	Claim Type	Payment Pathway	Policy Number	Policy Holder Name
{{$value1['sr_no']}}	{{$value1['intimation_date']}}	{{$value1['intimation_type']}}	{{$value1['claim_type']}}	{{$value1['payment_pathway']}}	{{$value1['policy_number']}}	{{$value1['policy_holder_name']}}
Garage Name	Vehicle Reg. No.	Hospital Admission Date	Hospital Discharge Date	Reason Of Claim	Claim Transaction Date	Claim Lodged Amount	Patient / Benificier Name
{{$value1['garage_name']}}	{{$value1['vehicle_no']}}	{{$value1['hospital_admission_date']}}	{{$value1['hospital_discharge_date']}}	{{$value1['reason_of_claim']}}	{{$value1['claim_transaction_date']}}	{{$value1['claim_lodged_amt']}}	{{$value1['patient_name']}}
Policy Claim Count	Query Date	Query Submited Date	Query Count	Settled Transaction Date	Insurance Comp. Name
{{$value1['claim_count']}}	{{$value1['query_date']}}	{{$value1['query_submited_date']}}	{{$value1['query_count']}}	{{$value1['settled_transaction_date']}}	{{$value1['insurance_company_name']}}
Settled Amount	Difference Amount	Pre-Post Claim Date	Pre-Post Claim Amount	Reject Transaction Date	Reject Reason
{{$value1['settled_amt']}}	{{$value1['difference_amt']}}	{{$value1['pre_post_claim_date']}}	{{$value1['pre_post_claim_amt']}}	{{$value1['reject_transaction_date']}}	@foreach($value1['reject_reason'] as $key2 => $value2) {{$value2}} @endforeach
Deduction Claim Date	Deduction Claim Amount	Going To Court Tr. Date	Court Settled Tr. Date	Court Settled Amount	Court Reason/ Settled Remarks
{{$value1['deduction_claim_date']}}	{{$value1['deduction_claim_amt']}}	{{$value1['going_to_court_transaction_date']}}	{{$value1['court_settled_transaction_date']}}	{{$value1['court_settled_amt']}}	{{$value1['going_to_court_reason']}}
Re-Open Transaction Date	Cashless Transaction Date	Cashless Settled Amount	Created Date	Created By	Modified Date	Modified By
{{$value1['re_open_transaction_date']}}	{{$value1['cashless_transaction_date']}}	{{$value1['cashless_settled_amt']}}	{{$value1['created_at']}}	{{$value1['created_by']}}	{{$value1['updated_at']}}	{{$value1['modified_by']}}

Sr.No.

Intimation Date

Intimation Type

Claim Type

Payment Pathway

Policy Number

Policy Holder Name

Garage Name

Vehicle Reg. No.

Hospital Admission Date

Hospital Discharge Date

Reason Of Claim

Claim Transaction Date

Claim Lodged Amount

Patient / Benificier Name

Policy Claim Count

Query Date

Query Submited Date

Query Count

Settled Transaction Date

Insurance Comp. Name

Settled Amount

Difference Amount

Pre-Post Claim Date

Pre-Post Claim Amount

Reject Transaction Date

Reject Reason

@foreach($value1['reject_reason'] as $key2 => $value2) {{$value2}} @endforeach

Deduction Claim Date

Deduction Claim Amount

Going To Court Tr. Date

Court Settled Tr. Date

Court Settled Amount

Court Reason/ Settled Remarks

Re-Open Transaction Date

Cashless Transaction Date

Cashless Settled Amount

Created Date

Created By

Modified Date

Modified By

Page total	Total Claim Lodged Amount	Total Settled Amount	Total Difference Amount	Total Pre-Post Claim Amount	Total Deduction Claim Amount	Total Court Settled Amount	Total Cashless Settled Amount
{{ $response['totalAmounts']['total_claim_lodged_amt'] }}	{{ $response['totalAmounts']['total_settled_amt'] }}	{{ $response['totalAmounts']['total_diff_amt'] }}	{{ $response['totalAmounts']['total_pre_post_amt'] }}	{{ $response['totalAmounts']['total_deduction_amt'] }}	{{ $response['totalAmounts']['total_court_settled_amt'] }}	{{ $response['totalAmounts']['total_cashless_settled_amt'] }}

Page total

Total Claim Lodged Amount

Total Settled Amount

Total Difference Amount

Total Pre-Post Claim Amount

Total Deduction Claim Amount

Total Court Settled Amount

Total Cashless Settled Amount

REPORT TOTAL	Total Claim Lodged Amount	Total Settled Amount	Total Difference Amount	Total Pre-Post Claim Amount	Total Deduction Claim Amount	Total Court Settled Amount	Total Cashless Settled Amount
{{ $response['totalAmounts']['total_claim_lodged_amt'] }}	{{ $response['totalAmounts']['total_settled_amt'] }}	{{ $response['totalAmounts']['total_diff_amt'] }}	{{ $response['totalAmounts']['total_pre_post_amt'] }}	{{ $response['totalAmounts']['total_deduction_amt'] }}	{{ $response['totalAmounts']['total_court_settled_amt'] }}	{{ $response['totalAmounts']['total_cashless_settled_amt'] }}

REPORT TOTAL

Total Claim Lodged Amount

Total Settled Amount

Total Difference Amount

Total Pre-Post Claim Amount

Total Deduction Claim Amount

Total Court Settled Amount

Total Cashless Settled Amount

:: Claim Consolidated Report ::

@if($response['start_date'] != 'not selected') From Date :- {{ $response['start_date'] }} @endif | {{ $response['date_type'] }} | @if($response['end_date'] != 'not selected') To Date :- {{ $response['end_date'] }} @endif

Page :- {{ $key + 1 }} > {{ $response['count'] }}

@php $sumAssuredTotal = 0; @endphp @foreach ($value as $key1 => $value1) @php $sumAssuredTotal += $value1['sum_assured']; @endphp @if ($key1 % 2 == 0) @else @endif @if($value1['risk_to_date'] == null && ($value1['mode'] == 'Single' || $value1['mode'] == 'Till Termination')) @else @endif @if ($value1['tp_due_date'] != NULL) @else @endif

Sr.No.	Intimation Date	Intimation Type	Claim Type	Payment Pathway	Policy Holder Name		Patient / Benificier Name	Policy Number	Policy Claim Count	Insurance Comp. Name
{{ $key1 + 1 }}	{{ $key1 + 1 }}	{{ dateDMYFormat($value1['transaction_date']) }}	{{ $value1['policy_holder_name'] }}	{{ $value1['insurance_company'] }}	{{ dateDMYFormat($value1['risk_from_date']) }}	{{ $value1['current_policy_number'] }}		{{ $value1['previous_policy_number'] }}	{{ $value1['vehicle_no'] }}	{{ $value1['vehicle_name'] }}
		Hospital Admission Date	Hospital DIscharge Date	Reason Of Claim	Claim Transaction Date	Claim Lodged Amount	Query Date	Query Submited Date	Query Count	Settled Transaction Date
		{{ $value1['insurance_type'] }}	{{ $value1['group'] }}	{{ $value1['sub_agent'] }}	Till Termination of transit as per duration clause	{{ dateDMYFormat($value1['risk_to_date']) }}	{{ number_format($value1['sum_assured'], 2) }}	{{ number_format($value1['tax_amount'], 2) }}	{{ $value1['bank'] }}
		Broker	Mob No.	W/App No.	Division	TPA Due Date	Basic Premium	Total Amount	Remarks
		{{ $value1['broker'] }}	{{ $value1['mobile_number'] }}	{{ $value1['whatsapp_number'] }}	{{ $value1['division'] }}	{{ dateDMYFormat($value1['tp_due_date']) }}		{{ number_format($value1['basic_amount'], 2) }}	{{ number_format($value1['total_amount'], 2) }}	{{ substr($value1['remark'], 0, 150) }}
		Agency	E-Mail Id		Segment	Mode	TPA Premium	For Comm. Amt
		{{ $value1['agency'] }}	{{ $value1['email'] }}		{{ $value1['segment'] }}	{{ $value1['mode'] }}	{{ number_format($value1['tpa_premium'], 2) }}	{{ number_format($value1['net_commisionable_amount'], 2) }}

@endforeach

Page total		Total Amount
Page total		{{ number_format($sumAssuredTotal, 2) }}

@if ($key + 1 == $response['count'])

REPORT TOTAL		Total Amount
REPORT TOTAL		{{ number_format($response['sumAssuredTotal'], 2) }}

@endif @php $dateTime = new DateTime('now', new DateTimeZone('Asia/Kolkata')); $date = $dateTime->format("d/m/y H:i A"); @endphp

User :- {{ ucfirst($response['username']) }}	Date :- {{ $date }}
User :- {{ ucfirst($response['username']) }}	It is Online Computer Generated Report. # If any Discrepancy please contact to us.	Date :- {{ $date }}