}}) |
:: General Insurance Renewal Policy Report (D/L) ::
@php
$date_type = "All";
if($response['date_type'] == '-1'){
$date_type = "All";
}else if($response['date_type'] == '0'){
$date_type = "Renewal";
}else if($response['date_type'] == '1'){
$date_type = "Renewed";
}else if($response['date_type'] == '2'){
$date_type = "Can Not Renew";
}
@endphp
@if($response['start_date'] != 'not selected')
From Date :- {{ $response['start_date'] }}
@endif
| {{ $date_type }} |
@if($response['end_date'] != 'not selected')
To Date :- {{ $response['end_date'] }}
@endif
|
Page :- {{ $key + 1 }} > {{ $response['count'] }} |
@php
$dateTime = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
$date = $dateTime->format("d/m/y H:i");
$sumAssuredTotal = 0;
$totalPremiumTotal = 0;
$groupName = [];
$groupSumAssuredTotal = 0;
$groupTotalPremiumTotal = 0;
$carriedOverGroupTotals = $response['ongoingGroupTotals'];
@endphp
@foreach ($value as $key1 => $value1)
@php
$sumAssuredTotal += $value1['sum_assured'];
$totalPremiumTotal += $value1['total_amount'];
$groupSumAssuredTotal += $value1['sum_assured'];
$groupTotalPremiumTotal += $value1['total_amount'];
$group = $value1['group'];
// if (!isset($carriedOverGroupTotals[$group]['calculated'])) {
// $carriedOverGroupTotals[$group]['calculated'] = false;
// }
// $isLastInGroup = false;
// if (isset($value[$key1 + 1])) {
// $isLastInGroup = $value[$key1 + 1]['group'] !== $value1['group'];
// } else {
// $isLastInGroup = true; // Last record overall
// }
$isLastInGroup = false;
if (isset($response['ongoingGroupTotals'][$group]['last_record']) &&
$response['ongoingGroupTotals'][$group]['last_record'] === $value1) {
$isLastInGroup = true;
}
@endphp
@if($response['type'] == "group-wise" && !in_array($value1['group'],$groupName))
| Group |
{{$value1['group']}} |
@php
// Add group to the array after displaying it
$groupName[] = $value1['group'];
@endphp
@endif
| Sr.No. |
Risk Due Date |
Insurance Type |
Broker |
Insurance Co. Name |
Policy Holder Name |
Division |
Vehicle Reg.No. |
Policy No. |
Total Amount |
@if ($key1 % 2 == 0)
| {{ $key1 + 1 }} |
@else
{{ $key1 + 1 }} |
@endif
@if($value1['risk_to_date'] == null && ($value1['mode'] == 'Single' || $value1['mode'] == 'Till Termination'))
Till Termination of transit as per duration clause |
@else
{{ dateDMYFormat($value1['risk_to_date']) }} |
@endif
{{ $value1['insurance_type'] }} |
{{ $value1['broker'] }} |
{{ $value1['insurance_company'] }} |
{{ $value1['policy_holder_name'] }} |
{{ $value1['division'] }} |
{{ $value1['vehicle_no'] }} |
{{ $value1['current_policy_number'] }} |
| Renewal Status |
TP Due Date |
Mode |
Agency |
Sub Agent Name |
Mobile No. |
W/App No. |
Segment |
Vehicle Name |
Sum Assured |
@if ($value1['renewal_status'] == '0')
@if (($currentDate >= $riskDate && $riskDate >= $prevDate) || ($currentDate <= $riskDate && $riskDate <= $nextDate))
| Renew |
@else
Not Renew |
@endif
@else
Renewed |
@endif
@if ($value1['tp_due_date'])
{{ dateDMYFormat($value1['tp_due_date']) }} |
@else
|
@endif
{{ $value1['mode'] }} |
{{ $value1['agency'] }} |
{{ $value1['sub_agent'] }} |
{{ $value1['mobile_number'] }} |
{{ $value1['whatsapp_number'] }} |
{{ $value1['segment'] }} |
{{ $value1['vehicle_name'] }} |
{{ $value1['sum_assured'] }} |
{{ $value1['total_amount'] }} |
@if ($response['type'] == "group-wise" && $isLastInGroup)
| Group Total |
Sum Assured |
Total Premium |
| {{ number_format($carriedOverGroupTotals[$group]['sum_assured'], 2) }} |
{{ number_format($carriedOverGroupTotals[$group]['total_amount'], 2) }} |
@php
// Mark as rendered to avoid duplication
unset($response['ongoingGroupTotals'][$group]['last_record']);
@endphp
@endif
@endforeach
@if ($response['type'] != "group-wise")
| Page total |
Sum Assured |
Total Premium |
| {{ number_format($sumAssuredTotal, 2) }} |
{{ number_format($totalPremiumTotal, 2) }} |
@endif
@if ($key + 1 == $response['count'])
| REPORT TOTAL |
Sum Assured |
Total Premium |
| {{ number_format($response['sumAssuredTotal'], 2) }} |
{{ number_format($response['totalPremiumTotal'], 2) }} |
@endif