]*>( |\s)*<\/p>/i', '', $mail_content);
$data['params'] = $params;$data['client_logo'] = $client_logo;
$data['mail_content'] = $mail_content;
$mail_content = view('mail_template', $data);
$wholeData = ['mail' => $mail, 'subject' => $subject, 'message' => $mail_content, 'bcc' => $client_data['common_mails'], 'reply_to' => $client_data['reply_to'], 'common' => $common];
return $wholeData;
} else if ($action == 'member_review_and_summary_mail') {
$array_list = $params['array_list']; //employeee lst
$client_policy_id = $params['client_policy_id'];
$emp_code = $params['emp_code'];
$client_id = $params['client_id'];
$common = $params['common'];
$clientModel = new ClientModel();
$notificationModel = new NotificationModel();
$clientPolicyModel = new ClientPolicyModel();
$PolicyPremium1Model = new PolicyPremium1Model();
$PolicyPremium2Model = new PolicyPremium2Model();
$client_data = $clientModel->where('id', $client_id)->first();
$notification_data = $notificationModel->where('client_id', $client_id)->where('template_name', $action)->first();
$params['client_data'] = $client_data;
// dd($notification_data);
if (isset($notification_data) && $notification_data['enabled'] == 1) {
$mail_content = $notification_data['mail_content'];
$subject = $notification_data['subject'];
$app_link = $_ENV['App_Url'];
$nhance_logo = $_ENV['NHANCE_LOGO'];
$client_logo = base_url() . "public/uploads/logo/" . $client_data['client_logo'];
// $client_logo = $nhance_logo;
$mail_content = str_replace(["[[client_name]]", "{{client_name}}"], $client_data['client_name'], $mail_content);
$mail_content = str_replace(["[[nhance_logo]]", "{{nhance_logo}}"], "
", $mail_content);
$mail_content = str_replace(["[[client_logo]]", "{{client_logo}}"], "
", $mail_content);
$mail_content = str_replace(["[[app_link]]", "{{app_link}}"], "Review Details", $mail_content);
// Step 1: Replace the placeholder with an HTML table structure
$mail = '';
$table_content = '';
$addtional_premium = 0;
$gst = 0;
$Addon_list = [];
$name = '';
$employee_mobile_no = '';
$emp_code = '';
// is_premium_summery: 0=hide all, 1=full premium/GST + summary, 2=hide columns but summary as Policy Name/Total
$show_full_premium_breakdown = false;
// echo '';
// dd($array_list); die;
foreach ($array_list as $item) {
$payable_employee_array = [];
if (count($item) != 0) {
$table_content .= 'Policy Type :';
$temp_data = '';
$policy_name = '';
$is_addon = '';
$rowspan = count($item) ?? 2;
$is_si_set = 0;
foreach ($item as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
// dd($policy_premium_data);
if ($inner_item['payable_employee'] == 1 && $client_policy_data['policy_type_id'] == 2) {
$payable_employee_array['emp_data'][] = $inner_item;
}
// dd($policy_premium_data);
$policy_name = $inner_item['policy_name'];
if ($inner_item['relationship'] == 'Self') {
// $emp_code = '(' . $inner_item['emp_code'] . ')';
$emp_code = ' ( Employee Code : ' . $inner_item['emp_code'] . ')';
$mail = $inner_item['email_corporate'];
$name = $inner_item['name'];
$employee_mobile_no = $inner_item['mobile'];
}
$si = '';
$premium = '';
$gst_forself = '';
$is_premium_summery = (int) ($client_policy_data['is_premium_summery'] ?? 0);
$show_premium_columns = ($is_premium_summery === 1);
if ($policy_premium_data['premium_type'] == 2) {
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
} else {
if ($inner_item['relationship'] == 'Self') {
$payable_employee_array['si_amount'] = $inner_item['basic_cover_si'];
$payable_employee_array['self_premium'] = $inner_item['rata_premimum'];
$payable_employee_array['self_gst'] = $inner_item['gst'];
}
empty($inner_item['basic_cover_si']) ? $si = 0 : $si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
}
// Premium summery for show and hide the Additional premium data
if ($show_premium_columns) {
$premium = '₹ ' . format_indian_number(round($inner_item['rata_premimum']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
}
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
if ($policy_premium_data['premium_type'] == 2) {
$temp_data .= '' . $si . ' | ';
} else {
// $temp_data .= (($si != 0 && count($item) != 1) ? ('' . $si . ' | ') : ($si == 0 ? "" : '' . $si . ' | ') );
if ($si != 0 && count($item) != 1 && $is_si_set == 0) {
$temp_data .= '' . $si . ' | ';
$is_si_set = 1;
} else {
if ($is_si_set == 1) {
$temp_data .= '';
} else {
$temp_data .= '' . $si . ' | ';
}
}
}
// Only Display SI Topup and Dependent Addon
if (($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) && $show_premium_columns) {
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
}
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$is_premium_summery = (int) ($client_policy_data['is_premium_summery'] ?? 0);
$show_premium_columns = ($is_premium_summery === 1);
$include_addon_summary = in_array($is_premium_summery, [1, 2], true);
$table_content .= $policy_name_for_policy_type . '
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if (($is_addon == 2 || $is_addon == 3) && $show_premium_columns) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
Policy Type :';
$temp_data = '';
$is_addon = '';
$rowspan = count($payable_employee_array['emp_data']) ?? 2;
$self_si_amount = $payable_employee_array['si_amount'] ?? 0;
$self_premium = $payable_employee_array['self_premium'] ?? 0;
$self_gst = $payable_employee_array['self_gst'] ?? 0;
// dd($payable_employee_array['si_amount'], $self_si_amount);
foreach ($payable_employee_array['emp_data'] as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
// dd($policy_premium_data);
$si = '';
$premium = '';
$gst_forself = '';
$is_premium_summery = (int) ($client_policy_data['is_premium_summery'] ?? 0);
// value 2: hide Premium/GST columns even for payable-by-employee rows
$show_premium_columns = ($is_premium_summery === 1)
|| ($inner_item['payable_employee'] == 1 && $is_premium_summery !== 2);
if ($policy_premium_data['premium_type'] == 2) {
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
} else {
empty($self_si_amount) ? $si = 0 : $si = '₹ ' . format_indian_number($self_si_amount);
}
if ($policy_premium_data['premium_type'] == 1) {
empty($self_premium) ? $premium = 0 : $premium = '₹ ' . format_indian_number($self_premium);
empty($self_gst) ? $gst_forself = 0 : $gst_forself = '₹ ' . format_indian_number($self_gst);
} else {
$premium = '₹ ' . format_indian_number(round($inner_item['rata_premimum']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
}
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
// dd($si);
// Premium summery for show and hide the Additional premium data
if ($show_premium_columns) {
if ($policy_premium_data['premium_type'] == 2) {
$temp_data .= '' . $si . ' | ';
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
} else {
if ($policy_premium_data['premium_type'] == 1) {
$temp_data .= (($si != 0 && count($item) != 1) ? ('' . $si . ' | ') : ($si == 0 ? "" : '' . $si . ' | '));
$temp_data .= (($premium != 0 && count($item) != 1) ? ('' . $premium . ' | ') : ($premium == 0 ? "" : '' . $premium . ' | '));
$temp_data .= (($gst_forself != 0 && count($item) != 1) ? ('' . $gst_forself . ' | ') : ($gst_forself == 0 ? "" : '' . $gst_forself . ' | '));
} else {
$temp_data .= (($si != 0 && count($item) != 1) ? ('' . $si . ' | ') : ($si == 0 ? "" : '' . $si . ' | '));
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
}
$self_si_amount = 0;
$self_premium = 0;
$self_gst = 0;
}
} else {
$temp_data .= '' . $si . ' | ';
}
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$is_premium_summery = (int) ($client_policy_data['is_premium_summery'] ?? 0);
$show_premium_columns = ($is_premium_summery === 1)
|| ($inner_item['payable_employee'] == 1 && $is_premium_summery !== 2);
$include_addon_summary = ($inner_item['payable_employee'] == 1)
|| in_array($is_premium_summery, [1, 2], true);
$table_content .= $policy_name_for_policy_type . ' ( Payable By Employee )
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Premium summery for show and hide the Additional premium data
if ($show_premium_columns) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
';
$table_content .= '
';
// Center align for table header and body
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
if ($show_full_premium_breakdown) {
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
}
// is_premium_summery == 2: label as Total Premium
$total_label = $show_full_premium_breakdown ? 'Total' : 'Total Premium';
$table_content .= '' . $total_label . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$sum_total = 0;
foreach ($Addon_list as $key => $value) {
$total_addon = $value['gst'] + $value['addtional_premium'];
$sum_total += $total_addon;
$table_content .= '';
$table_content .= '| ' . $value['policy_name'] . ' | ';
if ($show_full_premium_breakdown) {
$table_content .= '₹' . format_indian_number($value['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($value['gst']) . ' | ';
}
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
}
$sum_total_words = numberToWords($sum_total);
$table_content .= '';
if ($show_full_premium_breakdown) {
$table_content .= ' | | Total | ';
} else {
$table_content .= '' . $total_label . ' | ';
}
$table_content .= '₹' . format_indian_number($sum_total) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '
' . $sum_total_words . '
';
}
// dd($payable_employee_array, $Addon_list);
// print_r($table_content); die;
$mail_content = str_replace(["[[member_name]]", "{{member_name}}"], $name . $emp_code, $mail_content);
$mail_content = str_replace(["[[member_mobile]]", "{{member_mobile}}"], $employee_mobile_no, $mail_content);
$mail_content = str_replace(["[[member_summary]]", "{{member_summary}}"], $table_content, $mail_content);
$mail_content = preg_replace('/]*>( |\s)*<\/p>/i', '', $mail_content);
$data['params'] = $params;$data['client_logo'] = $client_logo;
$data['mail_content'] = $mail_content;
$mail_content = view('mail_template', $data);
$wholeData[] = ['mail' => $mail, 'subject' => $subject, 'message' => $mail_content, 'bcc' => $client_data['common_mails'], 'reply_to' => $client_data['reply_to'], 'common' => $common];
return $wholeData;
}
} else if ($action == 'account_maneger_summary_mail') {
$client_id = $params['client_id'];
$client_policy_id = $params['client_policy_id'];
$common = $params['common'];
$clientModel = new ClientModel();
$notificationModel = new NotificationModel();
$clientRMModel = new ClientRMModel();
$clientPolicyModel = new ClientPolicyModel();
$PolicyPremium1Model = new PolicyPremium1Model();
$PolicyPremium2Model = new PolicyPremium2Model();
$client_data = $clientModel->where('id', $client_id)->first();
$params['client_data'] = $client_data;
$notification_data = $notificationModel->where('client_id', $client_id)->where('template_name', $action)->first();
if (isset($notification_data) && $notification_data['enabled'] == 1) {
$client_rm_data = $clientRMModel->where('client_id', $client_id)->where('is_active', 1)->findAll();
$user_list = [];
foreach ($client_rm_data as $key => $value) {
if ($value['level'] == 3) {
$userModel = new UserModel();
$user_data = $userModel->where('id', $value['user_id'])->first();
$user_list[] = $user_data;
}
}
$mail_content = $notification_data['mail_content'];
$subject = $notification_data['subject'];
$app_link = $_ENV['App_Url'];
$nhance_logo = $_ENV['NHANCE_LOGO'];
$client_logo = base_url() . "public/uploads/logo/" . $client_data['client_logo'];
// $client_logo = $nhance_logo;
$mail_content = str_replace(["[[client_name]]", "{{client_name}}"], $client_data['client_name'], $mail_content);
$mail_content = str_replace(["[[nhance_logo]]", "{{nhance_logo}}"], "", $mail_content);
$mail_content = str_replace(["[[client_logo]]", "{{client_logo}}"], "", $mail_content);
$mail_content = str_replace(["[[app_link]]", "{{app_link}}"], "Review Details", $mail_content);
// Step 1: Replace the placeholder with an HTML table structure
$mail = '';
$table_content = '';
$addtional_premium = 0;
$gst = 0;
$array_list = $params['array_list'];
$Addon_list = [];
foreach ($array_list as $item) {
$payable_employee_array = [];
if (count($item) != 0) {
$table_content .= 'Policy Type :';
$temp_data = '';
$policy_name = '';
$is_addon = '';
foreach ($item as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
if ($inner_item['payable_employee'] == 1 && $client_policy_data['policy_type_id'] == 2) {
$payable_employee_array[] = $inner_item;
}
$policy_name = $inner_item['policy_name'];
if ($inner_item['relationship'] == 'Self') {
// $emp_code = ' (' . $inner_item['emp_code'] . ')';
$emp_code = ' ( Employee Code : ' . $inner_item['emp_code'] . ')';
} else {
$emp_code = '';
}
$si = '';
$premium = '';
$gst_forself = '';
// if(checkFamilyFloaters($policy_premium_data, $client_policy_data, $inner_item)){
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
$premium = '₹ ' . format_indian_number(round($inner_item['premium']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
// }
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . $emp_code . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
$temp_data .= '' . $si . ' | ';
// Only Display SI Topup and Dependent Addon
if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
}
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$table_content .= $policy_name_for_policy_type . '
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if ($is_addon == 2 || $is_addon == 3) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
Policy Type :';
$temp_data = '';
$is_addon = '';
foreach ($payable_employee_array as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
$si = '';
$premium = '';
$gst_forself = '';
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
$premium = '₹ ' . format_indian_number(round($inner_item['rata_premimum']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
$temp_data .= '' . $si . ' | ';
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$table_content .= $policy_name_for_policy_type . ' ( Payable By Employee )
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
';
$table_content .= '
';
// Center align for table header and body
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
$table_content .= 'Total | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$sum_total = 0;
foreach ($Addon_list as $key => $value) {
$total_addon = $value['gst'] + $value['addtional_premium'];
$sum_total += $total_addon;
$table_content .= '';
$table_content .= '| ' . $value['policy_name'] . ' | ';
$table_content .= '₹' . format_indian_number($value['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($value['gst']) . ' | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
}
$sum_total_words = numberToWords($sum_total);
$table_content .= '';
$table_content .= ' | | Total | ';
$table_content .= '₹' . format_indian_number($sum_total) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '
' . $sum_total_words . '
';
}
$mail_content = str_replace(["[[member_summary]]", "{{member_summary}}"], $table_content, $mail_content);
$account_manager_mail_list = [];
if (isset($user_list)) {
foreach ($user_list as $key => $value) {
$full_name = $value['first_name'] . ' ' . $value['last_name'];
$mail_content = str_replace(["[[member_name]]", "{{member_name}}"], $full_name, $mail_content);
$mail_content = preg_replace('/]*>( |\s)*<\/p>/i', '', $mail_content);
$data['params'] = $params;$data['client_logo'] = $client_logo;
$data['mail_content'] = $mail_content;
$mail_content = view('mail_template', $data);
$wholeData[] = ['mail' => $value['email'], 'subject' => $subject, 'message' => $mail_content, 'reply_to' => $client_data['reply_to'], 'common' => $common];
// $wholeData[] = ['mail' => $value['email'], 'subject' => $subject,'message'=> $mail_content, 'bcc'=> $client_data['common_mails'}};
}
return $wholeData;
}
}
} //else if($action == 'client_hr_summary_mail'){
// $client_id = $params['client_id'];
// $client_policy_id = $params['client_policy_id'];
// $common = $params['common'];
// data: name: name:
// $clientModel = new ClientModel();
// $clientPolicyModel = new ClientPolicyModel();
// $PolicyPremium1Model = new PolicyPremium1Model();
// $PolicyPremium2Model = new PolicyPremium2Model();
// $client_data =$clientModel->where('id', $client_id)->first();
// $notificationModel = new NotificationModel();
// $notification_data = $notificationModel->where('client_id' ,$client_id)->where('template_name', $action)->first();
// $clientRMModel =new ClientRMModel();
// if (isset($notification_data['enabled']) && $notification_data['enabled'] == 1) {
// $client_rm_data= $clientRMModel->where('client_id', $client_id)->where('is_active',1)->findAll();
// $user_list= [];
// foreach ($client_rm_data as $key => $value) {
// if($value['level'] == 3){
// $userModel = new UserModel();
// $user_data = $userModel->where('id', $value['user_id'])->first();
// $user_list[]=$user_data;
// }
// }
// $mail_content = $notification_data['mail_content'];
// $subject = $notification_data['subject'];
// $app_link = $_ENV['App_Url'];
// $nhance_logo = $_ENV['NHANCE_LOGO'];
// $client_logo = base_url() . "public/uploads/logo/" . $client_data['client_logo'];
// // $client_logo = $nhance_logo;
// $mail_content = str_replace(["[[nhance_logo]]", "{{nhance_logo}}"], "", $mail_content);
// $mail_content = str_replace(["[[client_logo]]", "{{client_logo}}"], "", $mail_content);
// $mail_content = str_replace(["[[client_name]]", "{{client_name}}"], $client_data['client_name'], $mail_content);
// $mail_content = str_replace(["[[app_link]]", "{{app_link}}"], "Review Details", $mail_content);
// // Step 1: Replace the placeholder with an HTML table structure
// $mail = '';
// $table_content = '';
// $addtional_premium = 0;
// $gst = 0;
// $array_list = $params['array_list'];
// $Addon_list = [];
// foreach ($array_list as $item) {
// $payable_employee_array = [];
// if (count($item) != 0) {
// $table_content .= 'Policy Type :';
// $temp_data = '';
// $policy_name = '';
// $is_addon = '';
// foreach ($item as $inner_item) {
// //getting policy premium data
// $client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
// if($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7 ){
// $policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }else{
// $policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }
// //end of getting policy premium data
// if($inner_item['payable_employee'] == 1 && $client_policy_data['policy_type_id'] == 2){
// $payable_employee_array[] = $inner_item;
// }
// $policy_name = $inner_item['policy_name'];
// if ($inner_item['relationship'] == 'Self') {
// $emp_code = ' (' . $inner_item['emp_code'] . ')';
// } else {
// $emp_code = '';
// }
// $si = '';
// $premium = '';
// $gst_forself = '';
// // dd($policy_premium_data, $client_policy_data, $inner_item);
// // if(checkFamilyFloaters($policy_premium_data, $client_policy_data, $inner_item)){
// $si = '₹ ' .format_indian_number($inner_item['basic_cover_si']);
// $premium = '₹ ' .format_indian_number(round($inner_item['premium']));
// $gst_forself = '₹ ' .format_indian_number(round($inner_item['gst']));
// // }
// $temp_data .= '';
// $temp_data .= '| ' . $inner_item['name'] . $emp_code . ' | ';
// $temp_data .= '' . $inner_item['relationship'] . ' | ';
// $temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
// $temp_data .= '' . $si . ' | ';
// // Only Display SI Topup and Dependent Addon
// if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
// $temp_data .= '' . $premium . ' | ';
// $temp_data .= '' . $gst_forself . ' | ';
// }
// $temp_data .= '
';
// $is_addon = $inner_item['is_addon'];
// if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
// $addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
// $gst = $inner_item['gst'] + $gst;
// }
// }
// $policy_name_for_policy_type = $inner_item['policy_name'];
// if($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3){
// $policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
// }
// $table_content .= $policy_name_for_policy_type . '
';
// $table_content .= '
';
// // Add text-align: center to the table head
// $table_content .= '';
// $table_content .= '';
// $table_content .= '| Name | ';
// $table_content .= 'Relation | ';
// $table_content .= 'Date Of Birth | ';
// $table_content .= 'Sum Insured | ';
// // Only Display SI Topup and Dependent Addon
// if ($is_addon == 2 || $is_addon == 3) {
// $table_content .= 'Premium | ';
// $table_content .= 'GST | ';
// }
// $table_content .= '
';
// $table_content .= '';
// // Add text-align: center to the table body
// $table_content .= '' . $temp_data . '';
// $table_content .= '
Policy Type :';
// $temp_data = '';
// $is_addon = '';
// foreach ($payable_employee_array as $inner_item) {
// //getting policy premium data
// $client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
// if($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7 ){
// $policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }else{
// $policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }
// //end of getting policy premium data
// $si = '';
// $premium = '';
// $gst_forself = '';
// $si = '₹ ' .format_indian_number($inner_item['basic_cover_si']);
// $premium = '₹ ' .format_indian_number(round($inner_item['rata_premimum']));
// $gst_forself = '₹ ' .format_indian_number(round($inner_item['gst']));
// $temp_data .= '';
// $temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
// $temp_data .= '' . $inner_item['relationship'] . ' | ';
// $temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
// $temp_data .= '' . $si . ' | ';
// $temp_data .= '' . $premium . ' | ';
// $temp_data .= '' . $gst_forself . ' | ';
// $temp_data .= '
';
// $is_addon = $inner_item['is_addon'];
// $addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
// $gst = $inner_item['gst'] + $gst;
// }
// $policy_name_for_policy_type = $inner_item['policy_name'];
// if($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3){
// $policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
// }
// $table_content .= $policy_name_for_policy_type . ' ( Payable By Employee )
';
// $table_content .= '
';
// // Add text-align: center to the table head
// $table_content .= '';
// $table_content .= '';
// $table_content .= '| Name | ';
// $table_content .= 'Relation | ';
// $table_content .= 'Date Of Birth | ';
// $table_content .= 'Sum Insured | ';
// $table_content .= 'Premium | ';
// $table_content .= 'GST | ';
// $table_content .= '
';
// $table_content .= '';
// // Add text-align: center to the table body
// $table_content .= '' . $temp_data . '';
// $table_content .= '
';
// $table_content .= '
';
// // Center align for table header and body
// $table_content .= '';
// $table_content .= '';
// $table_content .= '| Policy Name | ';
// $table_content .= 'Additional Premium | ';
// $table_content .= 'GST | ';
// $table_content .= 'Total | ';
// $table_content .= '
';
// $table_content .= '';
// $table_content .= '';
// $sum_total = 0;
// foreach ($Addon_list as $key => $value) {
// $total_addon = $value['gst'] + $value['addtional_premium'];
// $sum_total += $total_addon;
// $table_content .= '';
// $table_content .= '| ' . $value['policy_name'] . ' | ';
// $table_content .= '₹' . format_indian_number($value['addtional_premium']) . ' | ';
// $table_content .= '₹' . format_indian_number($value['gst']) . ' | ';
// $table_content .= '₹' . format_indian_number($total_addon) . ' | ';
// $table_content .= '
';
// }
// $sum_total_words = numberToWords($sum_total);
// $table_content .= '';
// $table_content .= ' | | Total | ';
// $table_content .= '₹' . format_indian_number($sum_total) . ' | ';
// $table_content .= '
';
// $table_content .= '';
// $table_content .= '
' . $sum_total_words . '
';
// }
// $mail_content = str_replace(["[[member_summary]]", "{{member_summary}}"], $table_content , $mail_content);
// $hr_mails = $client_data['hr_mails'];
// $mail_array = explode(',', $hr_mails);
// $mail_array = array_map('trim', $mail_array);
// $wholeData = [];
// foreach ($mail_array as $key => $value) {
//
//
// $mail_content = preg_replace('/]*>( |\s)*<\/p>/i', '', $mail_content);
// $data['params'] = $params;$data['client_logo'] = $client_logo;
// $data['mail_content'] = $mail_content;
// $mail_content = view('mail_template',$data);
// $mail_content = $header_of_mail .
// '
//
//
// |
// ' . $mail_content . '
// |
//
//
//
';
// dd($array_list); die;
foreach ($array_list as $item) {
$payable_employee_array = [];
if (count($item) != 0) {
$table_content .= 'Policy Type :';
$temp_data = '';
$policy_name = '';
$is_addon = '';
$rowspan = count($item) ?? 2;
$is_si_set = 0;
foreach ($item as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
// dd($policy_premium_data);
if ($inner_item['payable_employee'] == 1 && $client_policy_data['policy_type_id'] == 2) {
$payable_employee_array['emp_data'][] = $inner_item;
}
// dd($policy_premium_data);
$policy_name = $inner_item['policy_name'];
if ($inner_item['relationship'] == 'Self') {
// $emp_code = '(' . $inner_item['emp_code'] . ')';
$emp_code = ' ( Employee Code : ' . $inner_item['emp_code'] . ')';
$mail = $inner_item['email_corporate'];
$name = $inner_item['name'];
$employee_mobile_no = $inner_item['mobile'];
}
$si = '';
$premium = '';
$gst_forself = '';
if ($policy_premium_data['premium_type'] == 2) {
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
} else {
if ($inner_item['relationship'] == 'Self') {
$payable_employee_array['si_amount'] = $inner_item['basic_cover_si'];
$payable_employee_array['self_premium'] = $inner_item['rata_premimum'];
$payable_employee_array['self_gst'] = $inner_item['gst'];
}
empty($inner_item['basic_cover_si']) ? $si = 0 : $si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
}
// Premium summery for show and hide the Additional premium data
if ($client_policy_data['is_premium_summery'] == 1) {
$premium = '₹ ' . format_indian_number(round($inner_item['rata_premimum']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
}
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
if ($policy_premium_data['premium_type'] == 2) {
$temp_data .= '' . $si . ' | ';
} else {
// $temp_data .= (($si != 0 && count($item) != 1) ? ('' . $si . ' | ') : ($si == 0 ? "" : '' . $si . ' | ') );
if ($si != 0 && count($item) != 1 && $is_si_set == 0) {
$temp_data .= '' . $si . ' | ';
$is_si_set = 1;
} else {
if ($is_si_set == 1) {
$temp_data .= '';
} else {
$temp_data .= '' . $si . ' | ';
}
}
}
// Only Display SI Topup and Dependent Addon
if (($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) && $client_policy_data['is_premium_summery'] == 1) {
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
}
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$table_content .= $policy_name_for_policy_type . '
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if (($is_addon == 2 || $is_addon == 3) && $client_policy_data['is_premium_summery'] == 1) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
Policy Type :';
$temp_data = '';
$is_addon = '';
$rowspan = count($payable_employee_array['emp_data']) ?? 2;
$self_si_amount = $payable_employee_array['si_amount'] ?? 0;
$self_premium = $payable_employee_array['self_premium'] ?? 0;
$self_gst = $payable_employee_array['self_gst'] ?? 0;
// dd($payable_employee_array['si_amount'], $self_si_amount);
foreach ($payable_employee_array['emp_data'] as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
// dd($policy_premium_data);
$si = '';
$premium = '';
$gst_forself = '';
if ($policy_premium_data['premium_type'] == 2) {
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
} else {
empty($self_si_amount) ? $si = 0 : $si = '₹ ' . format_indian_number($self_si_amount);
}
if ($policy_premium_data['premium_type'] == 1) {
empty($self_premium) ? $premium = 0 : $premium = '₹ ' . format_indian_number($self_premium);
empty($self_gst) ? $gst_forself = 0 : $gst_forself = '₹ ' . format_indian_number($self_gst);
} else {
$premium = '₹ ' . format_indian_number(round($inner_item['rata_premimum']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
}
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
// dd($si);
// Premium summery for show and hide the Additional premium data
if ($inner_item['payable_employee'] == 1 || $client_policy_data['is_premium_summery'] == 1) {
if ($policy_premium_data['premium_type'] == 2) {
$temp_data .= '' . $si . ' | ';
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
} else {
if ($policy_premium_data['premium_type'] == 1) {
$temp_data .= (($si != 0 && count($item) != 1) ? ('' . $si . ' | ') : ($si == 0 ? "" : '' . $si . ' | '));
$temp_data .= (($premium != 0 && count($item) != 1) ? ('' . $premium . ' | ') : ($premium == 0 ? "" : '' . $premium . ' | '));
$temp_data .= (($gst_forself != 0 && count($item) != 1) ? ('' . $gst_forself . ' | ') : ($gst_forself == 0 ? "" : '' . $gst_forself . ' | '));
} else {
$temp_data .= (($si != 0 && count($item) != 1) ? ('' . $si . ' | ') : ($si == 0 ? "" : '' . $si . ' | '));
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
}
$self_si_amount = 0;
$self_premium = 0;
$self_gst = 0;
}
} else {
$temp_data .= '' . $si . ' | ';
}
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$table_content .= $policy_name_for_policy_type . ' ( Payable By Employee )
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Premium summery for show and hide the Additional premium data
if ($inner_item['payable_employee'] == 1 || $client_policy_data['is_premium_summery'] == 1) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
';
$table_content .= '
';
// Center align for table header and body
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
$table_content .= 'Total | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$sum_total = 0;
foreach ($Addon_list as $key => $value) {
$total_addon = $value['gst'] + $value['addtional_premium'];
$sum_total += $total_addon;
$table_content .= '';
$table_content .= '| ' . $value['policy_name'] . ' | ';
$table_content .= '₹' . format_indian_number($value['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($value['gst']) . ' | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
}
$sum_total_words = numberToWords($sum_total);
$table_content .= '';
$table_content .= ' | | Total | ';
$table_content .= '₹' . format_indian_number($sum_total) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '
' . $sum_total_words . '
';
}
// dd($payable_employee_array, $Addon_list);
// print_r($table_content); die;
$mail_content = str_replace(["[[member_name]]", "{{member_name}}"], $name . $emp_code, $mail_content);
$mail_content = str_replace(["[[member_mobile]]", "{{member_mobile}}"], $employee_mobile_no, $mail_content);
$mail_content = str_replace(["[[member_summary]]", "{{member_summary}}"], $table_content, $mail_content);
$mail_content = preg_replace('/]*>( |\s)*<\/p>/i', '', $mail_content);
$data['params'] = $params;$data['client_logo'] = $client_logo;
$data['mail_content'] = $mail_content;
$mail_content = view('mail_template', $data);
$wholeData[] = ['mail' => $mail, 'subject' => $subject, 'message' => $mail_content, 'bcc' => $client_data['common_mails'], 'reply_to' => $client_data['reply_to'], 'common' => $common];
return $wholeData;
}
} else if ($action == 'account_maneger_summary_mail') {
$client_id = $params['client_id'];
$client_policy_id = $params['client_policy_id'];
$common = $params['common'];
$clientModel = new ClientModel();
$notificationModel = new NotificationModel();
$clientRMModel = new ClientRMModel();
$clientPolicyModel = new ClientPolicyModel();
$PolicyPremium1Model = new PolicyPremium1Model();
$PolicyPremium2Model = new PolicyPremium2Model();
$client_data = $clientModel->where('id', $client_id)->first();
$params['client_data'] = $client_data;
$notification_data = $notificationModel->where('client_id', $client_id)->where('template_name', $action)->first();
if (isset($notification_data) && $notification_data['enabled'] == 1) {
$client_rm_data = $clientRMModel->where('client_id', $client_id)->where('is_active', 1)->findAll();
$user_list = [];
foreach ($client_rm_data as $key => $value) {
if ($value['level'] == 3) {
$userModel = new UserModel();
$user_data = $userModel->where('id', $value['user_id'])->first();
$user_list[] = $user_data;
}
}
$mail_content = $notification_data['mail_content'];
$subject = $notification_data['subject'];
$app_link = $_ENV['App_Url'];
$nhance_logo = $_ENV['NHANCE_LOGO'];
$client_logo = base_url() . "public/uploads/logo/" . $client_data['client_logo'];
// $client_logo = $nhance_logo;
$mail_content = str_replace(["[[client_name]]", "{{client_name}}"], $client_data['client_name'], $mail_content);
$mail_content = str_replace(["[[nhance_logo]]", "{{nhance_logo}}"], "", $mail_content);
$mail_content = str_replace(["[[client_logo]]", "{{client_logo}}"], "", $mail_content);
$mail_content = str_replace(["[[app_link]]", "{{app_link}}"], "Review Details", $mail_content);
// Step 1: Replace the placeholder with an HTML table structure
$mail = '';
$table_content = '';
$addtional_premium = 0;
$gst = 0;
$array_list = $params['array_list'];
$Addon_list = [];
foreach ($array_list as $item) {
$payable_employee_array = [];
if (count($item) != 0) {
$table_content .= 'Policy Type :';
$temp_data = '';
$policy_name = '';
$is_addon = '';
foreach ($item as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
if ($inner_item['payable_employee'] == 1 && $client_policy_data['policy_type_id'] == 2) {
$payable_employee_array[] = $inner_item;
}
$policy_name = $inner_item['policy_name'];
if ($inner_item['relationship'] == 'Self') {
// $emp_code = ' (' . $inner_item['emp_code'] . ')';
$emp_code = ' ( Employee Code : ' . $inner_item['emp_code'] . ')';
} else {
$emp_code = '';
}
$si = '';
$premium = '';
$gst_forself = '';
// if(checkFamilyFloaters($policy_premium_data, $client_policy_data, $inner_item)){
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
$premium = '₹ ' . format_indian_number(round($inner_item['premium']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
// }
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . $emp_code . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
$temp_data .= '' . $si . ' | ';
// Only Display SI Topup and Dependent Addon
if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
}
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$table_content .= $policy_name_for_policy_type . '
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if ($is_addon == 2 || $is_addon == 3) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
Policy Type :';
$temp_data = '';
$is_addon = '';
foreach ($payable_employee_array as $inner_item) {
//getting policy premium data
$client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
if ($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7) {
$policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
} else {
$policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
}
//end of getting policy premium data
$si = '';
$premium = '';
$gst_forself = '';
$si = '₹ ' . format_indian_number($inner_item['basic_cover_si']);
$premium = '₹ ' . format_indian_number(round($inner_item['rata_premimum']));
$gst_forself = '₹ ' . format_indian_number(round($inner_item['gst']));
$temp_data .= '';
$temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
$temp_data .= '' . $inner_item['relationship'] . ' | ';
$temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
$temp_data .= '' . $si . ' | ';
$temp_data .= '' . $premium . ' | ';
$temp_data .= '' . $gst_forself . ' | ';
$temp_data .= '
';
$is_addon = $inner_item['is_addon'];
$addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
$gst = $inner_item['gst'] + $gst;
}
$policy_name_for_policy_type = $inner_item['policy_name'];
if ($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3) {
$policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
}
$table_content .= $policy_name_for_policy_type . ' ( Payable By Employee )
';
$table_content .= '
';
// Add text-align: center to the table head
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
$table_content .= '
';
$table_content .= '';
// Add text-align: center to the table body
$table_content .= '' . $temp_data . '';
$table_content .= '
';
$table_content .= '
';
// Center align for table header and body
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
$table_content .= 'Total | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$sum_total = 0;
foreach ($Addon_list as $key => $value) {
$total_addon = $value['gst'] + $value['addtional_premium'];
$sum_total += $total_addon;
$table_content .= '';
$table_content .= '| ' . $value['policy_name'] . ' | ';
$table_content .= '₹' . format_indian_number($value['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($value['gst']) . ' | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
}
$sum_total_words = numberToWords($sum_total);
$table_content .= '';
$table_content .= ' | | Total | ';
$table_content .= '₹' . format_indian_number($sum_total) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '
' . $sum_total_words . '
';
}
$mail_content = str_replace(["[[member_summary]]", "{{member_summary}}"], $table_content, $mail_content);
$account_manager_mail_list = [];
if (isset($user_list)) {
foreach ($user_list as $key => $value) {
$full_name = $value['first_name'] . ' ' . $value['last_name'];
$mail_content = str_replace(["[[member_name]]", "{{member_name}}"], $full_name, $mail_content);
$mail_content = preg_replace('/]*>( |\s)*<\/p>/i', '', $mail_content);
$data['params'] = $params;$data['client_logo'] = $client_logo;
$data['mail_content'] = $mail_content;
$mail_content = view('mail_template', $data);
$wholeData[] = ['mail' => $value['email'], 'subject' => $subject, 'message' => $mail_content, 'reply_to' => $client_data['reply_to'], 'common' => $common];
// $wholeData[] = ['mail' => $value['email'], 'subject' => $subject,'message'=> $mail_content, 'bcc'=> $client_data['common_mails'}};
}
return $wholeData;
}
}
} //else if($action == 'client_hr_summary_mail'){
// $client_id = $params['client_id'];
// $client_policy_id = $params['client_policy_id'];
// $common = $params['common'];
// data: name: name:
// $clientModel = new ClientModel();
// $clientPolicyModel = new ClientPolicyModel();
// $PolicyPremium1Model = new PolicyPremium1Model();
// $PolicyPremium2Model = new PolicyPremium2Model();
// $client_data =$clientModel->where('id', $client_id)->first();
// $notificationModel = new NotificationModel();
// $notification_data = $notificationModel->where('client_id' ,$client_id)->where('template_name', $action)->first();
// $clientRMModel =new ClientRMModel();
// if (isset($notification_data['enabled']) && $notification_data['enabled'] == 1) {
// $client_rm_data= $clientRMModel->where('client_id', $client_id)->where('is_active',1)->findAll();
// $user_list= [];
// foreach ($client_rm_data as $key => $value) {
// if($value['level'] == 3){
// $userModel = new UserModel();
// $user_data = $userModel->where('id', $value['user_id'])->first();
// $user_list[]=$user_data;
// }
// }
// $mail_content = $notification_data['mail_content'];
// $subject = $notification_data['subject'];
// $app_link = $_ENV['App_Url'];
// $nhance_logo = $_ENV['NHANCE_LOGO'];
// $client_logo = base_url() . "public/uploads/logo/" . $client_data['client_logo'];
// // $client_logo = $nhance_logo;
// $mail_content = str_replace(["[[nhance_logo]]", "{{nhance_logo}}"], "", $mail_content);
// $mail_content = str_replace(["[[client_logo]]", "{{client_logo}}"], "", $mail_content);
// $mail_content = str_replace(["[[client_name]]", "{{client_name}}"], $client_data['client_name'], $mail_content);
// $mail_content = str_replace(["[[app_link]]", "{{app_link}}"], "Review Details", $mail_content);
// // Step 1: Replace the placeholder with an HTML table structure
// $mail = '';
// $table_content = '';
// $addtional_premium = 0;
// $gst = 0;
// $array_list = $params['array_list'];
// $Addon_list = [];
// foreach ($array_list as $item) {
// $payable_employee_array = [];
// if (count($item) != 0) {
// $table_content .= 'Policy Type :';
// $temp_data = '';
// $policy_name = '';
// $is_addon = '';
// foreach ($item as $inner_item) {
// //getting policy premium data
// $client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
// if($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7 ){
// $policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }else{
// $policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }
// //end of getting policy premium data
// if($inner_item['payable_employee'] == 1 && $client_policy_data['policy_type_id'] == 2){
// $payable_employee_array[] = $inner_item;
// }
// $policy_name = $inner_item['policy_name'];
// if ($inner_item['relationship'] == 'Self') {
// $emp_code = ' (' . $inner_item['emp_code'] . ')';
// } else {
// $emp_code = '';
// }
// $si = '';
// $premium = '';
// $gst_forself = '';
// // dd($policy_premium_data, $client_policy_data, $inner_item);
// // if(checkFamilyFloaters($policy_premium_data, $client_policy_data, $inner_item)){
// $si = '₹ ' .format_indian_number($inner_item['basic_cover_si']);
// $premium = '₹ ' .format_indian_number(round($inner_item['premium']));
// $gst_forself = '₹ ' .format_indian_number(round($inner_item['gst']));
// // }
// $temp_data .= '';
// $temp_data .= '| ' . $inner_item['name'] . $emp_code . ' | ';
// $temp_data .= '' . $inner_item['relationship'] . ' | ';
// $temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
// $temp_data .= '' . $si . ' | ';
// // Only Display SI Topup and Dependent Addon
// if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
// $temp_data .= '' . $premium . ' | ';
// $temp_data .= '' . $gst_forself . ' | ';
// }
// $temp_data .= '
';
// $is_addon = $inner_item['is_addon'];
// if ($inner_item['is_addon'] == 2 || $inner_item['is_addon'] == 3) {
// $addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
// $gst = $inner_item['gst'] + $gst;
// }
// }
// $policy_name_for_policy_type = $inner_item['policy_name'];
// if($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3){
// $policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
// }
// $table_content .= $policy_name_for_policy_type . '
';
// $table_content .= '
';
// // Add text-align: center to the table head
// $table_content .= '';
// $table_content .= '';
// $table_content .= '| Name | ';
// $table_content .= 'Relation | ';
// $table_content .= 'Date Of Birth | ';
// $table_content .= 'Sum Insured | ';
// // Only Display SI Topup and Dependent Addon
// if ($is_addon == 2 || $is_addon == 3) {
// $table_content .= 'Premium | ';
// $table_content .= 'GST | ';
// }
// $table_content .= '
';
// $table_content .= '';
// // Add text-align: center to the table body
// $table_content .= '' . $temp_data . '';
// $table_content .= '
Policy Type :';
// $temp_data = '';
// $is_addon = '';
// foreach ($payable_employee_array as $inner_item) {
// //getting policy premium data
// $client_policy_data = $clientPolicyModel->where('id', $inner_item['client_policy_id'])->first();
// if($client_policy_data['policy_type_id'] == 1 || $client_policy_data['policy_type_id'] == 6 || $client_policy_data['policy_type_id'] == 7 ){
// $policy_premium_data = $PolicyPremium1Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }else{
// $policy_premium_data = $PolicyPremium2Model->where('client_policy_id', $inner_item['client_policy_id'])->where('is_active', '1')->first();
// }
// //end of getting policy premium data
// $si = '';
// $premium = '';
// $gst_forself = '';
// $si = '₹ ' .format_indian_number($inner_item['basic_cover_si']);
// $premium = '₹ ' .format_indian_number(round($inner_item['rata_premimum']));
// $gst_forself = '₹ ' .format_indian_number(round($inner_item['gst']));
// $temp_data .= '';
// $temp_data .= '| ' . $inner_item['name'] . ($inner_item['relationship'] == 'Self' ? ' (' . $inner_item['emp_code'] . ')' : '') . ' | ';
// $temp_data .= '' . $inner_item['relationship'] . ' | ';
// $temp_data .= '' . \DateTime::createFromFormat('Y-m-d', $inner_item['dob'])->format('d-m-Y') . ' | ';
// $temp_data .= '' . $si . ' | ';
// $temp_data .= '' . $premium . ' | ';
// $temp_data .= '' . $gst_forself . ' | ';
// $temp_data .= '
';
// $is_addon = $inner_item['is_addon'];
// $addtional_premium = $inner_item['rata_premimum'] + $addtional_premium;
// $gst = $inner_item['gst'] + $gst;
// }
// $policy_name_for_policy_type = $inner_item['policy_name'];
// if($client_policy_data['policy_type_id'] == 3 && $client_policy_data['is_addon'] == 3){
// $policy_name_for_policy_type = 'Add-On Group Medical Coverage for Parents';
// }
// $table_content .= $policy_name_for_policy_type . ' ( Payable By Employee )
';
// $table_content .= '
';
// // Add text-align: center to the table head
// $table_content .= '';
// $table_content .= '';
// $table_content .= '| Name | ';
// $table_content .= 'Relation | ';
// $table_content .= 'Date Of Birth | ';
// $table_content .= 'Sum Insured | ';
// $table_content .= 'Premium | ';
// $table_content .= 'GST | ';
// $table_content .= '
';
// $table_content .= '';
// // Add text-align: center to the table body
// $table_content .= '' . $temp_data . '';
// $table_content .= '
';
// $table_content .= '
';
// // Center align for table header and body
// $table_content .= '';
// $table_content .= '';
// $table_content .= '| Policy Name | ';
// $table_content .= 'Additional Premium | ';
// $table_content .= 'GST | ';
// $table_content .= 'Total | ';
// $table_content .= '
';
// $table_content .= '';
// $table_content .= '';
// $sum_total = 0;
// foreach ($Addon_list as $key => $value) {
// $total_addon = $value['gst'] + $value['addtional_premium'];
// $sum_total += $total_addon;
// $table_content .= '';
// $table_content .= '| ' . $value['policy_name'] . ' | ';
// $table_content .= '₹' . format_indian_number($value['addtional_premium']) . ' | ';
// $table_content .= '₹' . format_indian_number($value['gst']) . ' | ';
// $table_content .= '₹' . format_indian_number($total_addon) . ' | ';
// $table_content .= '
';
// }
// $sum_total_words = numberToWords($sum_total);
// $table_content .= '';
// $table_content .= ' | | Total | ';
// $table_content .= '₹' . format_indian_number($sum_total) . ' | ';
// $table_content .= '
';
// $table_content .= '';
// $table_content .= '
' . $sum_total_words . '
';
// }
// $mail_content = str_replace(["[[member_summary]]", "{{member_summary}}"], $table_content , $mail_content);
// $hr_mails = $client_data['hr_mails'];
// $mail_array = explode(',', $hr_mails);
// $mail_array = array_map('trim', $mail_array);
// $wholeData = [];
// foreach ($mail_array as $key => $value) {
//
//
// $mail_content = preg_replace('/]*>( |\s)*<\/p>/i', '', $mail_content);
// $data['params'] = $params;$data['client_logo'] = $client_logo;
// $data['mail_content'] = $mail_content;
// $mail_content = view('mail_template',$data);
// $mail_content = $header_of_mail .
// '
//
//
// |
// ' . $mail_content . '
// |
//
//
//
Policy Type :';
$policy_name = $array_list['policy_name'];
if ($array_list['relationship'] == 'Self') {
// $emp_code = ' (' . $array_list['emp_code'] . ')';
$emp_code = ' ( Employee Code : ' . $array_list['emp_code'] . ')';
} else {
$emp_code = '';
}
// Start table row
$table_content .= $policy_name . '
';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if (($array_list['is_addon'] == 2 || $array_list['is_addon'] == 3) && $show_premium_columns) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Table body with details
$table_content .= '';
$table_content .= '';
$table_content .= '| ' . nl2br(wordwrap($array_list['name'] . $emp_code, 11, "\n", true)) . ' | ';
$table_content .= '' . $array_list['relationship'] . ' | ';
$table_content .= '' . \DateTime::createFromFormat('Y-m-d', $array_list['dob'])->format('d-m-Y') . ' | ';
$table_content .= '₹' . format_indian_number($array_list['basic_cover_si']) . ' | ';
if (($array_list['is_addon'] == 2 || $array_list['is_addon'] == 3) && $show_premium_columns) {
$table_content .= '₹' . format_indian_number(round($array_list['premium'])) . ' | ';
$table_content .= '₹' . format_indian_number(round($array_list['gst'])) . ' | ';
}
$table_content .= '
';
$table_content .= '';
$table_content .= '
';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
if ($show_full_premium_breakdown) {
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
}
// is_premium_summery == 2: label as Total Premium
$total_label = $show_full_premium_breakdown ? 'Total' : 'Total Premium';
$table_content .= '' . $total_label . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$total_addon = $Addon_list[0]['gst'] + $Addon_list[0]['addtional_premium'];
$table_content .= '';
$table_content .= '| ' . $Addon_list[0]['policy_name'] . ' | ';
if ($show_full_premium_breakdown) {
$table_content .= '₹' . format_indian_number($Addon_list[0]['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($Addon_list[0]['gst']) . ' | ';
}
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
$sum_total_words = numberToWords($total_addon);
$table_content .= '';
if ($show_full_premium_breakdown) {
$table_content .= ' | | Total | ';
} else {
$table_content .= '' . $total_label . ' | ';
}
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '
Policy Type :';
$policy_name = $array_list['policy_name'];
if ($array_list['relationship'] == 'Self') {
// $emp_code = ' (' . $array_list['emp_code'] . ')';
$emp_code = ' ( Employee Code : ' . $array_list['emp_code'] . ')';
} else {
$emp_code = '';
}
// Start table row
$table_content .= $policy_name . '
';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if ($array_list['is_addon'] == 2 || $array_list['is_addon'] == 3) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Table body with details
$table_content .= '';
$table_content .= '';
$table_content .= '| ' . nl2br(wordwrap($array_list['name'] . $emp_code, 11, "\n", true)) . ' | ';
$table_content .= '' . $array_list['relationship'] . ' | ';
$table_content .= '' . \DateTime::createFromFormat('Y-m-d', $array_list['dob'])->format('d-m-Y') . ' | ';
$table_content .= '₹' . format_indian_number($array_list['basic_cover_si']) . ' | ';
if ($array_list['is_addon'] == 2 || $array_list['is_addon'] == 3) {
$table_content .= '₹' . format_indian_number(round($array_list['premium'])) . ' | ';
$table_content .= '₹' . format_indian_number(round($array_list['gst'])) . ' | ';
}
$table_content .= '
';
$table_content .= '';
$table_content .= '
';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
$table_content .= 'Total | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$total_addon = $Addon_list[0]['gst'] + $Addon_list[0]['addtional_premium'];
$table_content .= '';
$table_content .= '| ' . $Addon_list[0]['policy_name'] . ' | ';
$table_content .= '₹' . format_indian_number($Addon_list[0]['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($Addon_list[0]['gst']) . ' | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
$sum_total_words = numberToWords($total_addon);
$table_content .= '';
$table_content .= ' | | Total | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '
Policy Type :';
$policy_name = $array_list['policy_name'];
if ($array_list['relationship'] == 'Self') {
$emp_code = ' (' . $array_list['emp_code'] . ')';
} else {
$emp_code = '';
}
// Start table row
$table_content .= $policy_name . '
';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$table_content .= '| Name | ';
$table_content .= 'Relation | ';
$table_content .= 'Date Of Birth | ';
$table_content .= 'Sum Insured | ';
// Only Display SI Topup and Dependent Addon
if ($array_list['is_addon'] == 2 || $array_list['is_addon'] == 3) {
$table_content .= 'Premium | ';
$table_content .= 'GST | ';
}
$table_content .= '
';
$table_content .= '';
// Table body with details
$table_content .= '';
$table_content .= '';
$table_content .= '| ' . nl2br(wordwrap($array_list['name'] . $emp_code, 11, "\n", true)) . ' | ';
$table_content .= '' . $array_list['relationship'] . ' | ';
$table_content .= '' . \DateTime::createFromFormat('Y-m-d', $array_list['dob'])->format('d-m-Y') . ' | ';
$table_content .= '₹' . format_indian_number($array_list['basic_cover_si']) . ' | ';
if ($array_list['is_addon'] == 2 || $array_list['is_addon'] == 3) {
$table_content .= '₹' . format_indian_number(round($array_list['premium'])) . ' | ';
$table_content .= '₹' . format_indian_number(round($array_list['gst'])) . ' | ';
}
$table_content .= '
';
$table_content .= '';
$table_content .= '
';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$table_content .= '| Policy Name | ';
$table_content .= 'Additional Premium | ';
$table_content .= 'GST | ';
$table_content .= 'Total | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '';
$total_addon = $Addon_list[0]['gst'] + $Addon_list[0]['addtional_premium'];
$table_content .= '';
$table_content .= '| ' . $Addon_list[0]['policy_name'] . ' | ';
$table_content .= '₹' . format_indian_number($Addon_list[0]['addtional_premium']) . ' | ';
$table_content .= '₹' . format_indian_number($Addon_list[0]['gst']) . ' | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
$sum_total_words = numberToWords($total_addon);
$table_content .= '';
$table_content .= ' | | Total | ';
$table_content .= '₹' . format_indian_number($total_addon) . ' | ';
$table_content .= '
';
$table_content .= '';
$table_content .= '