File: /home/cafsindia/crm_cafsindia_com/application/helpers/table_helper.php
<?php
/**CAFS - START**/
function get_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('report' => "Reports")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_open_leads_table_headers(){
$CI =& get_instance();
$headers = array(
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
array('ncd' => "NCD"),
array('created_date' => "Genrated On"),
// array('remark' => "Remark"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_closed_leads_table_headers(){
$CI =& get_instance();
$emp_cat = $CI->session->userdata('emp_category');
$emp_role = $CI->session->userdata('emp_role');
if($emp_cat === "2"){
$append = array('met_date' => "Met Date");
}else{
$append = array('lead_type' => "Type");
}
//if(($emp_role === "5") || ($emp_role === "1")){
$view = array('view' => "view Login");
//}
$headers = array(
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
$append,
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
array('ncd' => "NCD"),
array('log_date' => "Login Date"),
array('premium' => "Premium"),
// array('created_date' => "Genrated On"),
//array('remark' => "Remark"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
$view,
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_dropped_leads_table_headers(){
$CI =& get_instance();
$headers = array(
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
//array('ncd' => "NCD"),
array('created_date' => "Genrated On"),
//array('remark' => "Remark"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_all_leads_table_headers(){
$CI =& get_instance();
$headers = array(
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
array('ncd' => "NCD"),
array('created_date' => "Genrated On"),
//array('remark' => "Remark"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_all_leads_data_row($all_leads, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $CI->session->userdata('emp_id');
$emp_role = $CI->session->userdata('emp_role');
$current_control = $all_leads->current_control;
if($all_leads->current_control === "MIS"){
$cc_name = "MIS";
}else
if($all_leads->current_control === "HC"){
$cc_name = "HC";
}else
if($all_leads->current_control === "Completed"){
$cc_name = "Completed";
}else{
$cc_name_info = $CI->Employee->get_info_empid($all_leads->current_control);
$cc_name = $cc_name_info->first_name;
}
$ow_name_info = $CI->Employee->get_info_empid($all_leads->created_by);
$ow_name = $ow_name_info->first_name;
$created_date = date('d-m-Y',strtotime($all_leads->created_date));
$ncd = date('d-m-Y',strtotime($all_leads->ncd));
$d = date("d");
$m = date("m");
$y = date("Y");
$chkDate = explode("-", $ncd);
if($controller_name === "closed_leads"){
$log_date = "-";
$clr ="style='color:red;'";
if($all_leads->log_date){
$clr ="";
$log_date = date('d-m-Y',strtotime($all_leads->log_date));
}
if(($all_leads->statusname === "Login") || ($all_leads->statusname === "Collected") || ($all_leads->prospect_name === "Login")){
$clr ="style='color:green'";
}
}else{
$clr ="";
if((($chkDate[0] < $d) && ($chkDate[1] <= $m)) || ($chkDate[1] < $m) || ($chkDate[2] < $y)){
if(($all_leads->statusname === "Login") || ($all_leads->statusname === "Collected") || ($all_leads->prospect_name === "Login")){
$clr ="style='color:green'";
}else
if(($all_leads->statusname === "Collection") || ($all_leads->statusname === "Fixed")){
$clr ="style='color:red'";
}else{
$clr ="style='color:red;'";
}
}
}
$premium = "-";
if($all_leads->premium){
$premium = $all_leads->premium;
}
$met_date = date('d-m-Y',strtotime($all_leads->met_date));
$row = array (
'lead_id' => "$all_leads->leads_id",
'cust_name' => "<sapn $clr>$all_leads->cust_name</span>",
'cust_mobile' => "<sapn $clr>$all_leads->cust_mobile</span>",
'cat_name' => "<sapn $clr>$all_leads->cat_name</span>",
'lead_type' => "<sapn $clr>$all_leads->lead_type</span>",
'lead_status' => "<sapn $clr>$all_leads->statusname</span>",
'prospect_level' => "<sapn $clr>$all_leads->prospect_name</span>",
'ncd' => "<sapn $clr class='sapce_wrap'>$ncd</span>",
'log_date' => "<sapn $clr>$log_date</span>",
'premium' => "<sapn $clr>$premium</span>",
'created_date' => "<sapn $clr class='sapce_wrap'>$created_date</span>",
'met_date' => "<sapn $clr>$met_date</span>",
'created_by' => "<sapn $clr>$ow_name</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
);
$row['view'] = anchor("all_leads/view_login/$all_leads->cust_id",'<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"Login Details"));
if($emp_id === $current_control){
$row['edit'] = anchor("all_leads/view/$all_leads->leads_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Lead"));
}else{
$row['edit'] = anchor("all_leads/view/$all_leads->leads_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Lead"));
}
return $row;
}
function get_other_campaigns_table_headers(){
$CI =& get_instance();
$headers = array(
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
//array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
array('expected_login' => "Premium"),
array('ncd' => "NCD"),
//array('remark' => "Remark"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_other_campaigns_row($all_leads, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $CI->session->userdata('emp_id');
$emp_role = $CI->session->userdata('emp_role');
$current_control = $all_leads->current_control;
if($all_leads->current_control === "MIS"){
$cc_name = "MIS";
}else
if($all_leads->current_control === "HC"){
$cc_name = "HC";
}else
if($all_leads->current_control === "MF"){
$cc_name = "MF";
}else
if($all_leads->current_control === "Completed"){
$cc_name = "Completed";
}else{
$cc_name_info = $CI->Employee->get_info_empid($all_leads->current_control);
$cc_name = $cc_name_info->first_name;
}
$ow_name_info = $CI->Employee->get_info_empid($all_leads->created_by);
$ow_name = $ow_name_info->first_name;
$ncd = date('d-m-Y',strtotime($all_leads->ncd));
$d = date("d");
$m = date("m");
$y = date("Y");
$chkDate = explode("-", $ncd);
$clr ="";
if($all_leads->prospect_name !== "Login"){
if((($chkDate[0] < $d) && ($chkDate[1] <= $m)) || ($chkDate[1] < $m) || ($chkDate[2] < $y)){
$clr ="style='color:red;'";
}
}
$expected_login = $all_leads->expected_login;
if(!$all_leads->expected_login){
$expected_login = "-";
}
$row = array (
'lead_id' => $all_leads->leads_id,
'cust_name' => "<sapn $clr>$all_leads->cust_name</span>",
'cust_mobile' => "<sapn $clr>$all_leads->cust_mobile</span>",
'cat_name' => "<sapn $clr>$all_leads->cat_name</span>",
'lead_type' => "<sapn $clr>$all_leads->lead_type</span>",
'lead_status' => "<sapn $clr>$all_leads->statusname</span>",
'prospect_level' => "<sapn $clr>$all_leads->prospect_name</span>",
'expected_login' => "<sapn $clr class='sapce_wrap'>$expected_login</span>",
'ncd' => "<sapn $clr>$ncd</span>",
//'remark' => "<sapn $clr>$all_leads->remarks</span>",
'created_by' => "<sapn $clr>$ow_name</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
);
if($emp_id === $current_control){
$row['edit'] = anchor($controller_name."/view/$all_leads->leads_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Lead"));
}else{
$row['edit'] = anchor($controller_name."/view/$all_leads->leads_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Lead"));
}
return $row;
}
/**CAFS - START**/
function get_transfer_table_headers(){
$CI =& get_instance();
$headers = array(
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
array('ncd' => "NCD"),
array('created_date' => "Genrated On"),
// array('remark' => "Remark"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_transfer_data_row($all_leads, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $CI->session->userdata('emp_id');
$emp_role = $CI->session->userdata('emp_role');
$current_control = $all_leads->current_control;
if($all_leads->current_control === "MIS"){
$cc_name = "MIS";
}else
if($all_leads->current_control === "HC"){
$cc_name = "HC";
}else
if($all_leads->current_control === "Completed"){
$cc_name = "Completed";
}else{
$cc_name_info = $CI->Employee->get_info_empid($all_leads->current_control);
$cc_name = $cc_name_info->first_name;
}
$ow_name_info = $CI->Employee->get_info_empid($all_leads->created_by);
$ow_name = $ow_name_info->first_name;
$created_date = date('d-m-Y',strtotime($all_leads->created_date));
$ncd = date('d-m-Y',strtotime($all_leads->ncd));
$d = date("d");
$m = date("m");
$y = date("Y");
$chkDate = explode("-", $ncd);
if($controller_name === "closed_leads"){
$log_date = "-";
$clr ="style='color:red;'";
if($all_leads->log_date){
$clr ="";
$log_date = date('d-m-Y',strtotime($all_leads->log_date));
}
if(($all_leads->statusname === "Login") || ($all_leads->statusname === "Collected") || ($all_leads->prospect_name === "Login")){
$clr ="style='color:green'";
}
}else{
$clr ="";
if((($chkDate[0] < $d) && ($chkDate[1] <= $m)) || ($chkDate[1] < $m) || ($chkDate[2] < $y)){
if(($all_leads->statusname === "Login") || ($all_leads->statusname === "Collected") || ($all_leads->prospect_name === "Login")){
$clr ="style='color:green'";
}else
if(($all_leads->statusname === "Collection") || ($all_leads->statusname === "Fixed")){
$clr ="style='color:red'";
}else{
$clr ="style='color:red;'";
}
}
}
$expected_login = "-";
if($all_leads->expected_login){
$expected_login = $all_leads->expected_login;
}
$row = array (
'lead_id' => "$all_leads->leads_id",
'cust_name' => "<sapn $clr>$all_leads->cust_name</span>",
'cust_mobile' => "<sapn $clr>$all_leads->cust_mobile</span>",
'cat_name' => "<sapn $clr>$all_leads->cat_name</span>",
'lead_type' => "<sapn $clr>$all_leads->lead_type</span>",
'lead_status' => "<sapn $clr>$all_leads->statusname</span>",
'prospect_level' => "<sapn $clr>$all_leads->prospect_name</span>",
'ncd' => "<sapn $clr class='sapce_wrap'>$ncd</span>",
'log_date' => "<sapn $clr>$log_date</span>",
'expected_login' => "<sapn $clr>$expected_login</span>",
'created_date' => "<sapn $clr class='sapce_wrap'>$created_date</span>",
//'remark' => "<sapn $clr>$all_leads->remarks</span>",
'created_by' => "<sapn $clr>$ow_name</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
);
// if($emp_id === $current_control){
// $row['edit'] = anchor("all_leads/view/$all_leads->leads_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Lead"));
// }else{
// $row['edit'] = anchor("all_leads/view/$all_leads->leads_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Lead"));
// }
return $row;
}
function get_mis_table_headers(){
$CI =& get_instance();
$headers = array(
// array('leads_id' => "leads_id"),
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('cat_name' => "Category"),
array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
array('policy_no' => "Policy No"),
array('rm_name' => "RM Name"),
array('log_date' => "Login Date"),
array('count' => "Products"),
array('net_premium' => "Premium"),
array('created_by' => "Owner"),
array('current_control' => "MIS Status"),
array('view' => "View Policy"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_mis_data_row($all_leads, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $CI->session->userdata('emp_id');
$emp_role = $CI->session->userdata('emp_role');
$current_control = $all_leads->current_control;
if($all_leads->current_control === "MIS"){
$cc_name = "Pending";
}else
if($all_leads->current_control === "HC"){
$cc_name = "Pending";
}else
if($all_leads->current_control === "Completed"){
$cc_name = "Completed";
}else{
$cc_name_info = $CI->Employee->get_info_empid($all_leads->current_control);
$cc_name = $cc_name_info->first_name;
}
$issuance_status = $all_leads->issuance_status;
if($issuance_status === "Medical Declined"){
$cc_name = "Dropped";
}else
if($issuance_status === "Cheque Dishonor"){
$cc_name = "Dropped";
}else
if($issuance_status === "Freelook"){
$cc_name = "Dropped";
}
$ow_name_info = $CI->Employee->get_info_empid($all_leads->created_by);
$ow_name = $ow_name_info->first_name;
$ncd = date('d-m-Y',strtotime($all_leads->ncd));
$log_date = "-";
$clr ="style='color:red;'";
if($all_leads->log_date){
$clr ="";
$log_date = date('d-m-Y',strtotime($all_leads->log_date));
}
$policy_no = $all_leads->policy_no;
if(!$policy_no){
$policy_no = "-";
}
$d = date("d");
$m = date("m");
$y = date("Y");
$chkDate = explode("-", $ncd);
$tot_premium = "-";
$net_premium = $all_leads->net_premium;
$rider_net_premium = $all_leads->rider_net_premium;
$tot_premium = $net_premium + $rider_net_premium;
if(!$tot_premium){
$tot_premium = "-";
}
if($all_leads->reName){
$name = $all_leads->reName;
}else
if($all_leads->rmName){
$name = $all_leads->rmName;
}else{
$name = $ow_name;
}
$cust_name = substr($all_leads->cust_name,0,12);
$row = array (
'leads_id' => "<sapn $clr>$all_leads->leads_id</span>",
'cust_name' => "<sapn $clr>$cust_name</span>",
'cust_mobile' => "<sapn $clr>$all_leads->cust_mobile</span>",
'cat_name' => "<sapn $clr>$all_leads->cat_name</span>",
'lead_type' => "<sapn $clr>$all_leads->lead_type</span>",
'lead_status' => "<sapn $clr>$all_leads->statusname</span>",
'prospect_level' => "<sapn $clr>$all_leads->prospect_name</span>",
'policy_no' => "<sapn $clr>$policy_no</span>",
'rm_name' => "<sapn $clr>$name</span>",
'log_date' => "<sapn $clr>$log_date</span>",
'count' => "<sapn $clr>$all_leads->count</span>",
'net_premium' => "<sapn $clr>$tot_premium</span>",
//'remark' => "<sapn $clr>$all_leads->remarks</span>",
'created_by' => "<sapn $clr>$ow_name</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
);
$row['view'] = anchor("mis/view_login/$all_leads->cust_id",'<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"Login Details"));
if($current_control === "MIS"){
$row['edit'] = anchor("mis/view/$all_leads->leads_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg', 'title'=>"Update Lead"));
}else{
$row['edit'] = anchor("mis/view/$all_leads->leads_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Lead"));
}
return $row;
// $row['edit'] = anchor("mis/view/$all_leads->leads_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg','title'=>"Update Lead"));
// return $row;
}
function get_hc_table_headers(){
$CI =& get_instance();
$headers = array(
//array('leads_id' => "leads_id"),
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
//array('cat_name' => "Category"),
//array('lead_type' => "Type"),
array('lead_status' => "Status"),
array('prospect_level' => "Prospect"),
//array('ncd' => "NCD"),
//array('remark' => "Remark"),
array('log_date' => "Login Date"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_hc_data_row($all_leads, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $CI->session->userdata('emp_id');
$emp_role = $CI->session->userdata('emp_role');
$current_control = $all_leads->current_control;
if($all_leads->current_control === "MIS"){
$cc_name = "MIS";
}else
if($all_leads->current_control === "HC"){
$cc_name = "HC";
}else
if($all_leads->current_control === "Completed"){
$cc_name = "Completed";
}else{
$cc_name_info = $CI->Employee->get_info_empid($all_leads->current_control);
$cc_name = $cc_name_info->first_name;
}
$ow_name_info = $CI->Employee->get_info_empid($all_leads->created_by);
$ow_name = $ow_name_info->first_name;
$ncd = date('d-m-Y',strtotime($all_leads->ncd));
$d = date("d");
$m = date("m");
$y = date("Y");
$chkDate = explode("-", $ncd);
// $clr ="";
// if(($chkDate[0] < $d) || ($chkDate[1] < $m) || ($chkDate[2] < $y)){
// $clr ="style='color:red;'";
// }
$clr ="style='color:red;'";
if($all_leads->log_date){
$clr ="";
$log_date = date('d-m-Y',strtotime($all_leads->log_date));
}
$row = array (
'leads_id' => "<sapn $clr>$all_leads->leads_id</span>",
'cust_name' => "<sapn $clr>$all_leads->cust_name</span>",
'cust_mobile' => "<sapn $clr>$all_leads->cust_mobile</span>",
'cat_name' => "<sapn $clr>$all_leads->cat_name</span>",
'lead_type' => "<sapn $clr>$all_leads->lead_type</span>",
'lead_status' => "<sapn $clr>$all_leads->statusname</span>",
'prospect_level' => "<sapn $clr>$all_leads->prospect_name</span>",
'ncd' => "<sapn $clr>$ncd</span>",
'log_date' => "<sapn $clr>$log_date</span>",
//'remark' => "<sapn $clr>$all_leads->remarks</span>",
'created_by' => "<sapn $clr>$ow_name</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
);
if($current_control === "HC"){
$row['edit'] = anchor($controller_name."/view/$all_leads->leads_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg', 'title'=>"Update Happy Calling"));
}else{
$row['edit'] = anchor($controller_name."/view/$all_leads->leads_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Lead"));
}
return $row;
}
function get_renewal_table_headers(){
$CI =& get_instance();
$headers = array(
array('view_policy' => "Policy"),
array('view' => "History"),
array('cust_name' => "Customer"),
array('cust_mobile' => "Mobile #"),
array('policy_no' => "Policy No"),
array('sum_assured' => "Sum Assured"),
array('issued_date' => "Issued Date"),
array('paying_year' => "Paid"),
array('vendor' => "Company"),
array('product_name' => "Plan"),
array('net_premium' => "Net Premium"),
array('premium' => "Premium"),
array('renewal_status' => "Status"),
array('renewal_date' => "Due Date"),
array('ncd' => "NCD"),
array('created_by' => "Source"),
// array('current_control' => "Current Control"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_renewal_data_row($all_leads, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $CI->session->userdata('emp_id');
$emp_role = $CI->session->userdata('emp_role');
$current_control = $all_leads->current_control;
//Get Source
if($all_leads->current_control === "MIS"){
$cc_name = "MIS";
}else
if($all_leads->current_control === "HC"){
$cc_name = "HC";
}else
if($all_leads->current_control === "Completed"){
$cc_name = "Completed";
}else{
$cc_name_info = $CI->Employee->get_info_empid($all_leads->current_control);
$cc_name = $cc_name_info->first_name;
}
$created = $all_leads->created_by;
$rm_name = $all_leads->rm_name;
if($rm_name){
$name_info = $CI->Renewal_model->get_rm_name($rm_name);
}else{
$name_info = $CI->Renewal_model->get_leader($created);
}
$renewal_date = date('d-m-Y',strtotime($all_leads->renewal_date));
$ncd = date('d-m-Y',strtotime($all_leads->ncd));
$issued_date = date('d-m-Y',strtotime($all_leads->issued_date));
if($ncd === "01-01-1970"){
$ncd = $renewal_date;
}
$d = date("d");
$m = date("m");
$y = date("Y");
$chkDate = explode("-", $renewal_date);
$clr ="";
if((($chkDate[0] < $d) && ($chkDate[1] <= $m)) || ($chkDate[1] < $m) || ($chkDate[2] < $y)){
//$clr ="style='color:red;'";
}
$policy_style ='text-transform: uppercase;';
$renew_status = $all_leads->renew_status;
if((!$renew_status) || ($renew_status === "Renewed")){
$renew_status = "Inforce";
}
$paying_year = $all_leads->paying_year;
if(!$paying_year){
$paying_year = 1;
}
$policy_no = $all_leads->new_policy;
if(!$policy_no){
$policy_no = $all_leads->policy;
}
$row = array (
'lead_id' => "<sapn $clr>$all_leads->lead_id</span>",
'cust_name' => "<sapn $clr>$all_leads->cust_name</span>",
'cust_mobile' => "<sapn $clr>$all_leads->cust_mobile</span>",
'sum_assured' => "<sapn $clr>$all_leads->sum_assured</span>",
'issued_date' => "<sapn $clr>$issued_date</span>",
'paying_year' => "<sapn $clr>$paying_year</span>",
'renewal_status' => "<sapn $clr>$renew_status</span>",
'vendor' => "<sapn $clr>$all_leads->vendor</span>",
'product_name' => "<sapn $clr>$all_leads->product_name</span>",
'policy_no' => "<sapn $policy_style>$policy_no</span>",
'ncd' => "<sapn $clr>$ncd</span>",
'renewal_date' => "<sapn $clr>$renewal_date</span>",
'net_premium' => "<sapn $clr>$all_leads->net_premium</span>",
'premium' => "<sapn $clr>$all_leads->overall_total_premium</span>",
'created_by' => "<sapn $clr>$name_info</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
);
$row['view_policy'] = anchor("renewal/view_login/$all_leads->cust_id",'<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"Login Details"));
$row['view'] = anchor($controller_name."/view_history/$all_leads->renewal_id",'<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"Renewal History"));
//if($current_control === "Completed"){
$row['edit'] = anchor($controller_name."/view/$all_leads->renewal_id", '<span class="fa fa-pencil-square-o"></span>', array('class'=>'modal-dlg', 'title'=>"Update Renewal",'data-btn-submit' => $CI->lang->line('common_submit'),));
// }
//else{
// $row['edit'] = anchor($controller_name."/view/$all_leads->renewal_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Lead"));
// }
return $row;
}
function get_team_manage_table_headers(){
$CI =& get_instance();
$headers = array(
array('team.team_id' => $CI->lang->line('team_id')),
array('teamname' => $CI->lang->line('team_name')),
array('category' => $CI->lang->line('category')),
array('teamleader' => $CI->lang->line('team_leader')),
//array('manager' => $CI->lang->line('manager')),
//array('teammembers' => $CI->lang->line('team_members')),
);
if($CI->Employee->has_grant('messages', $CI->session->userdata('team_id'))){
$headers[] = array('messages' => '', 'sortable' => FALSE);
}
return transform_headers($headers);
}
function get_team_data_row($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'team.team_id' => $person->team_id,
'teamname' => $person->teamname,
'category' => $person->cat_name,
'teamleader' => $person->first_name,
//'manager' => $person->manager,
'teammembers' => $person->teammembers,
'messages' => empty($person->phone_number) ? '' : anchor("Messages/view/$person->team_id", '<span class="glyphicon glyphicon-phone"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
'edit' => anchor($controller_name."/view/$person->team_id", '<span class="glyphicon glyphicon-edit"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_people_manage_table_headers()
{
$CI =& get_instance();
$headers = array(
array('people.person_id' => $CI->lang->line('common_id')),
array('cust_name' => $CI->lang->line('common_cust_name')),
array('cust_address' => $CI->lang->line('common_cust_address')),
array('email' => $CI->lang->line('common_email')),
array('phone_number' => $CI->lang->line('common_phone_number'))
);
//print_r($headers);die();
if($CI->Employee->has_grant('messages', $CI->session->userdata('person_id')))
{
$headers[] = array('messages' => '', 'sortable' => FALSE);
}
return transform_headers($headers);
}
function get_person_data_row($person, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'people.person_id' => $person->cust_id,
'cust_name' => $person->cust_name,
'cust_address' => $person->cust_address,
'email' => empty($person->cust_email) ? '' : mailto($person->cust_email, $person->cust_email),
'phone_number' => $person->cust_mobile,
'messages' => empty($person->phone_number) ? '' : anchor("Messages/view/$person->person_id", '<span class="glyphicon glyphicon-phone"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
'edit' => anchor($controller_name."/view/$person->cust_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
//Get Company Details
function get_company_manage_table_headers()
{
$CI =& get_instance();
$headers = array(
array('vendor_id' => $CI->lang->line('common_id')),
array('vendorcompanyname' => $CI->lang->line('common_company_name')),
array('category' => $CI->lang->line('common_category')),
array('vendor_desc' => $CI->lang->line('common_description'))
);
return transform_headers($headers);
}
function get_company_data_row($company, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'vendor_id' => $company->vendor_id,
'vendorcompanyname' => $company->vendorcompanyname,
'category' => $company->cat_name,
'vendor_desc' => $company->vendordesc,
'edit' => anchor($controller_name."/view/$company->vendor_id", '<span class="fa fa-pencil-square-o"></span>',
array('class' => 'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => $CI->lang->line($controller_name.'_update'))
));
}
function get_employee_manage_table_headers()
{
$CI =& get_instance();
$headers = array(
array('people.person_id' => "S No"),
array('username' => "Employee ID"),
array('created_on' => "Date Of Joining"),
array('first_name' => $CI->lang->line('common_first_name')),
array('last_name' => $CI->lang->line('common_last_name')),
array('email' => $CI->lang->line('common_email')),
array('phone_number' => $CI->lang->line('common_phone_number'))
);
//print_r($headers);die();
if($CI->Employee->has_grant('messages', $CI->session->userdata('person_id')))
{
$headers[] = array('messages' => '', 'sortable' => FALSE);
}
return transform_headers($headers);
}
function get_employee_data_row($person, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$created_on = date("jS M, Y", strtotime($person->join_date));
return array (
'people.person_id' => $person->person_id,
'username' => $person->username,
'created_on' => $created_on,
'first_name' => $person->first_name,
'last_name' => $person->last_name,
'email' => empty($person->email) ? '' : mailto($person->email, $person->email),
'phone_number' => $person->phone_number,
'messages' => empty($person->phone_number) ? '' : anchor("Messages/view/$person->person_id", '<span class="glyphicon glyphicon-phone"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
'edit' => anchor($controller_name."/view/$person->person_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_items_manage_table_headers()
{
$CI =& get_instance();
$headers = array(
/*array('items.item_id' => $CI->lang->line('common_id')),*/
array('product_id' => $CI->lang->line('product_id')),
array('product_name' => $CI->lang->line('product_name')),
array('category' => $CI->lang->line('items_category')),
array('vendorcompanyname' => $CI->lang->line('company_name')),
array('gst' => "GST"),
array('weight_credit' => $CI->lang->line('weight_credit')),
);
return transform_headers($headers);
}
function get_item_data_row($item, $controller)
{
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'product_id' => $item->product_id,
'product_name' => $item->product_name,
'category' => $item->cat_name,
'vendorcompanyname' => $item->vendorcompanyname,
'gst' => $item->gst,
'weight_credit' => $item->weight_credit,
'edit' => anchor($controller_name."/view/$item->product_id", '<span class="fa fa-pencil-square-o"></span>',
array('class' => 'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => $CI->lang->line($controller_name.'_update'))
));
}
function get_company_code_table_headers()
{
$CI=& get_instance();
$headers=array(
array('code_id'=>"ID"),
array('category_id'=>"Category"),
array('vendorcompanyname'=>"Vendor Company Name"),
array('company_code'=>"Company Code")
);
return transform_headers($headers);
}
function get_code_data_row($person, $controller)
{
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array(
'code_id'=>$person->code_id,
'category_id'=> $person->cat_name,
'vendorcompanyname'=>$person->vendorcompanyname,
'company_code'=>$person->company_code,
'edit' => anchor($controller_name."/view/$person->code_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_amc_headers(){
$CI =& get_instance();
$headers = array(
array('amc_id' => "ID"),
array('amc_name' => "AMC Name"),
);
return transform_headers($headers);
}
function get_amc_datarows($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'amc_id' => $person->amc_id,
'amc_name' => $person->amc_name,
'edit' => anchor($controller_name."/view/$person->amc_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update AMC"))
);
}
function get_fund_name_headers(){
$CI =& get_instance();
$headers = array(
array('fund_name_id' => "ID"),
array('amc' => "AMC Name"),
array('fund_name' => "Fund Name"),
);
return transform_headers($headers);
}
function get_fund_name_datarows($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'fund_name_id' => $person->fund_name_id,
'amc' => $person->amc_name,
'fund_name' => $person->fund_name,
'edit' => anchor($controller_name."/view/$person->fund_name_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update AMC"))
);
}
function get_mutual_fund_table_headers(){
$CI =& get_instance();
$headers = array(
array('rm_name' => "RM Name"),
array('cust_name' => "Customer"),
array('fam_name' => "Investor"),
array('cust_mobile' => "Mobile #"),
array('investment_type' => "Investment Type"),
array('mf_login_value' => "Login"),
array('entry_date' => "Entry Date"),
array('owner' => "Owner"),
array('current_control' => "Current Control"),
array('mf_status' => "Status"),
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_mutual_fund_data_row($mf_lead, $controller){
$CI =& get_instance();
$controller_name = strtolower(get_class($CI));
//print_r($mf_lead);
$entry_date = date('d-m-Y',strtotime($mf_lead->entry_date));
if($entry_date === "01-01-1970"){
$entry_date = "-";
}
$login_status = $mf_lead->login_status;
if($mf_lead->current_control === "MF"){
$cc_name = "MF";
}else{
$cc_name_info = $CI->Employee->get_info_empid($mf_lead->current_control);
$cc_name = $cc_name_info->first_name;
}
$clr = "";
if($login_status !== "Processed_Successfully"){
$clr = "style='color:#ff6f00;'";
}
$fam_name = $mf_lead->fam_name;
if(!$fam_name){
$fam_name = "-";
}
$rm_name = $mf_lead->rm_name;
if(!$rm_name){
$rm_name = "-";
}
$investment_type = $mf_lead->investment_type;
if(!$investment_type){
$investment_type = "-";
}
$row = array (
'rm_name' => "<sapn $clr>$rm_name</span>",
'cust_name' => "<sapn $clr>$mf_lead->cust_name</span>",
'fam_name' => "<sapn $clr>$fam_name</span>",
'cust_mobile' => "<sapn $clr>$mf_lead->cust_mobile</span>",
'investment_type' => "<sapn $clr>$investment_type</span>",
'mf_login_value' => "<sapn $clr>$mf_lead->mf_login_value</span>",
'entry_date' => "<sapn $clr>$entry_date</span>",
'owner' => "<sapn $clr>$mf_lead->owner</span>",
'current_control' => "<sapn $clr>$cc_name</span>",
'mf_status' => "<sapn $clr>$mf_lead->mf_status</span>",
);
$row['edit'] = anchor("mutual_fund/view/$mf_lead->mf_id", '<span class="fa fa-list-alt"></span>', array('class'=>'modal-dlg', 'title'=>"View Mutual Fund"));
return $row;
}
/**CAFS - END**/
/*
Branches
*/
function GetBranchTableHeaders()
{
$CI=& get_instance();
$headers=array(
array('branch_id'=>"Branch ID"),
array('branch_code'=>"Branch Code"),
array('branch_name'=>"Branch Name")
);
return transform_headers($headers);
}
function GetBranchDataRows($person,$controller)
{
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'branch_id' => $person->branch_id,
'branch_code' => $person->branch_code,
'branch_name' => $person->branch_name,
'edit' => anchor($controller_name."/view/$person->branch_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function transform_headers_readonly($array){
$result = array();
foreach($array as $key => $value)
{
$result[] = array('field' => $key, 'title' => $value, 'sortable' => $value != '', 'switchable' => !preg_match('(^$| )', $value));
}
return json_encode($result);
}
function transform_headers($array){
$result = array();
$array = array_merge(array(array('checkbox' => 'select', 'sortable' => FALSE)),
$array, array(array('edit' => '')));
foreach($array as $element)
{
$result[] = array('field' => key($element),
'title' => current($element),
'switchable' => isset($element['switchable']) ?
$element['switchable'] : !preg_match('(^$| )', current($element)),
'sortable' => isset($element['sortable']) ?
$element['sortable'] : current($element) != '',
'checkbox' => isset($element['checkbox']) ?
$element['checkbox'] : FALSE,
'class' => isset($element['checkbox']) || preg_match('(^$| )', current($element)) ?
'print_hide' : '');
}
//echo json_encode($result); die;
return json_encode($result);
}
function getgradeTableHeaders(){
$CI=& get_instance();
$headers=array(
array('grade_id'=>"ID"),
array('role_id'=>"Role"),
array('grade_name'=>"Grade"));
return transform_headers($headers);
}
function getgradeTabledata($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'grade_id' => $person->grade_id,
'role_id' => $person->role_name,
'grade_name' => $person->grade,
'edit' => anchor($controller_name."/view/$person->grade_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function goal_sheet_table_headers(){
$CI=& get_instance();
$headers=array(
//array('emp_id'=>"ID"),
array('emp_name'=>"Name"),
array('role'=>"Role"),
array('category'=>"Category"),
array('from_date'=>"From"),
array('to_date'=>"To"),
array('wfp'=>"WFP"),
array('nop'=>"NOP"),
array('sip'=>"SIP"),
array('premium'=>"Premium"),
array('met'=>"Met"),
//array('attrition'=>"Attrition"),
array('conversion_ratio'=>"Conversion Ratio"),
//array('renewal_persistency'=>"Renewal Persistency"),
array('other_campaign'=>"Other Campaign"));
return transform_headers($headers);
}
function goal_sheet_table_data($goal_info,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$from_date = date('d-m-Y',strtotime($goal_info->from_date));
$to_date = date('d-m-Y',strtotime($goal_info->to_date));
return array (
'goal_id' => $goal_info->goal_id,
'emp_id' => $goal_info->emp_id,
'emp_name' =>$goal_info->first_name,
'role' =>$goal_info->role_name,
'category' =>$goal_info->cat_name,
'from_date' => "<sapn $clr class='sapce_wrap'>$from_date</span>",
'to_date' => "<sapn $clr class='sapce_wrap'>$to_date</span>",
'wfp' => $goal_info->wfp,
'nop' => $goal_info->nop,
'sip' => $goal_info->sip,
'premium' => $goal_info->premium,
'met' => $goal_info->met,
'attrition' => $goal_info->attrition,
'conversion_ratio' => $goal_info->conversion_ratio,
'renewal_persistency' => $goal_info->renewal_persistency,
'other_campaign' => $goal_info->other_campaign,
'edit' => anchor($controller_name."/view/$goal_info->goal_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Goal sheet")
));
}
function incentives_table_headers(){
$CI=& get_instance();
$headers=array(
array('incentive_id'=>"ID"),
array('role_id'=>"Role"),
array('grade_name'=>"Grade"),
array('category'=>"Category"),
array('met'=>"met"),
array('value'=>"Value"),
array('convertion_ratio'=>"Convertion Ratio"),
array('credit'=>"Credit"));
return transform_headers($headers);
}
function incentives_table_data($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'incentive_id' => $person->incentive_id,
'role_id' => $person->role_name,
'grade_name' => $person->grade,
'category' => $person->cat_name,
'met' => $person->met,
'value' => $person->value,
'convertion_ratio' => $person->convertion_ratio,
'credit' => $person->credit,
'edit' => anchor($controller_name."/view/$person->incentive_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function incentives_report_table_headers(){
$CI=& get_instance();
$headers=array(
array('username'=>"Emp ID"),
array('first_name'=>"Name"),
array('role_id'=>"Role"),
array('category'=>"Category"),
array('grade_name'=>"Grade"),
array('nop'=>"NOP"),
array('value'=>"Net Premium"),
array('convertion_ratio'=>"Convertion Ratio"),
//array('credit'=>"Credit")
);
return transform_headers($headers);
}
function incentives_report_table_data($incentives,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$emp_id = $incentives['emp_id'];
return array (
'username' => $incentives['username'],
'first_name' => $incentives['first_name'],
'role_id' => $incentives['role_name'],
'category' => $incentives['cat_name'],
'grade_name' => $incentives['grade_name'],
'nop' => $incentives['nop'],
'value' => $incentives['netamount'],
'convertion_ratio' => $incentives['convertion_ratio'],
'credit' => $incentives['credit'],
// 'edit' => anchor($controller_name."/view/$emp_id", '<span class="fa fa-pencil-square-o"></span>',array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update')))
);
}
/* Bank */
function GetBankTableHeaders()
{
$CI=& get_instance();
$headers=array(
//array('bank_id'=>"Bank ID"),
array('bank_name'=>"Bank Name")
);
return transform_headers($headers);
}
function GetBankDataRows($person,$controller)
{
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'bank_id' => $person->bank_id,
'bank_name' => $person->bank_name,
'edit' => anchor($controller_name."/view/$person->bank_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
/* Target Plan*/
function target_table_headers(){
$CI=& get_instance();
$headers=array(
//array('emp_id'=>"ID"),
array('emp_name'=>"Name"),
array('role'=>"Role"),
array('category'=>"Category"),
array('from_date'=>"From"),
array('to_date'=>"To"),
array('premium'=>"Premium"),
array('met'=>"Met"),
array('nop'=>"NOP"));
return transform_headers($headers);
}
function target_table_data($target_info,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$from_date = date('d-m-Y',strtotime($target_info->from_date));
$to_date = date('d-m-Y',strtotime($target_info->to_date));
return array (
'target_id' => $target_info->target_id,
'emp_id' => $target_info->emp_id,
'emp_name' =>$target_info->first_name,
'role' =>$target_info->role_name,
'category' =>$target_info->cat_name,
'from_date' => "<span $clr class='sapce_wrap'>$from_date</span>",
'to_date' => "<span $clr class='sapce_wrap'>$to_date</span>",
'premium' => $target_info->premium,
'met' => $target_info->met,
'nop' => $target_info->nop,
'edit' => anchor($controller_name."/view/$target_info->target_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Target")
));
}
?>