File: /home/cafsindia/allyindian_com/sbltt/application/helpers/table_helper_OLD.php
<?php
/**CAFS - START**/
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_role = $CI->session->userdata('emp_role');
// if($emp_role === "5"){
// $append = array('expected_login' => "Premium");
// }else{
// $append = array('ncd' => "NCD");
// }
$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"),
//$append,
array('log_date' => "Login Date"),
array('expected_login' => "Premium"),
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_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;'";
}
}
}
$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_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 === "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[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('rm_name' => "RM Name"),
array('log_date' => "Login Date"),
array('expected_login' => "Premium"),
array('created_by' => "Owner"),
array('current_control' => "Current Control"),
);
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 = "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));
$log_date = "-";
$clr ="style='color:red;'";
if($all_leads->log_date){
$clr ="";
$log_date = date('d-m-Y',strtotime($all_leads->log_date));
}
$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;'";
// }
$expected_login = "-";
if($all_leads->expected_login){
$expected_login = $all_leads->expected_login;
}
if($all_leads->reName){
$name = $all_leads->reName;
}else
if($all_leads->rmName){
$name = $all_leads->rmName;
}else{
$name = $ow_name;
}
$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>",
'rm_name' => "<sapn $clr>$name</span>",
'log_date' => "<sapn $clr>$log_date</span>",
'expected_login' => "<sapn $clr>$expected_login</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 === "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('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('renewal_date' => "Renewal"),
//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_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;
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;
$renewal_date = date('d-m-Y',strtotime($all_leads->renewal_date));
$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[1] < $m) || ($chkDate[2] < $y)){
$clr ="style='color:red;'";
}
$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>",
'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>",
'renewal_date' => "<sapn $clr>$renewal_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 === "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('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,
'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'))
));
}
/**CAFS - END**/
function GetFundTableHeaders(){
$CI=& get_instance();
$headers=array(
array('id'=>"ID"),
array('fund_name'=>"Fund Name"));
return transform_headers($headers);
}
function GetFundDataRows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->fund_id,
'fund_name' => $person->fund_name,
'edit' => anchor($controller_name."/view/$person->fund_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_table_headers(){
$CI =& get_instance();
$headers = array(
array('fund_id' => "Fund Name"),
array('amc' => "AMC"),
);
return transform_headers($headers);
}
function get_amc_data_row($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->id,
'amc' => $person->amc,
'fund_id' => $person->fund_name,
'edit' => anchor($controller_name."/view/$person->id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update AMC"))
);
}
/*
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')))
);
}
?>