File: //home/cafsindia/crm_cafsindia_com/application/controllers/Home.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
require_once("Secure_Controller.php");
class Home extends Secure_Controller {
public function __construct(){
parent::__construct();
$this->load->model("Homemodel");
}
public function index(){
if(!$this->Appconfig->isAppvalid()){
redirect('config');
}
$data="";
$this->load->view('home',$data);
}
public function forgetpwd(){
$this->load->view('forgetpwd');
}
public function change_password($emp_id){
$old_password = md5($this->input->post('old_password'));
$new_password = md5($this->input->post('new_password'));
$confirm_new_password = $this->input->post('confirm_new_password');
$result = $this->Homemodel->change_password($emp_id,$old_password,$new_password,$confirm_new_password);
if($result){
echo json_encode(array('success' => TRUE, 'message' => 'Password Successfully Updated'));
}else{
echo json_encode(array('success' => FALSE, 'message' => 'Old Password Mismatch'));
}
}
//MIS Charts Start SAT 09aug2018
public function mis_life_chart(){
$cat = $_REQUEST['category'];
$type = $_REQUEST['type'];
$result = $this->Homemodel->mis_life_chart($cat,$type);
$category['name'] = 'Name';
$series1['name'] = 'Value';
foreach ($result as $key => $value) {
$category['data'][] = $value['vendorcompanyname'];
$series1['data'][] = $value['tot_count'];
}
$result = array();
array_push($result,$category);
array_push($result,$series1);
print json_encode($result, JSON_NUMERIC_CHECK);
}
/*
public function mis_hl_chart(){
$result = $this->Homemodel->mis_hl_chart();
$rows['type'] = 'pie';
$rows['name'] = 'Company';
foreach ($result as $key => $value) {
$rows['data'][] = array($value['vendorcompanyname'], $value['tot_count']);
}
$rslt = array();
array_push($rslt,$rows);
print json_encode($rslt, JSON_NUMERIC_CHECK);
}
*/
public function mis_rm_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->mis_rm_chart($category,$start_date,$end_date);
print json_encode($result, JSON_NUMERIC_CHECK);
}
public function mis_health_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->mis_health_chart($category,$start_date,$end_date);
print json_encode($result, JSON_NUMERIC_CHECK);
}
public function rmm_team_chart(){
$date = $_REQUEST['date'];
$emp_id = $_REQUEST['emp_id'];
$admin = $_REQUEST['admin'];
$result = $this->Homemodel->rmm_team_chart($date,$emp_id);
print json_encode($result, JSON_NUMERIC_CHECK);
}
public function issuance_chart(){
$category = $_REQUEST['category'];
$date = $_REQUEST['date'];
$result = $this->Homemodel->issuance_chart($category,$date);
if($result){
$drill_list = array();
foreach ($result as $key => $value) {
$issuance_status = $value['issuance_status'];
$premium = $value['premium'];
if($issuance_status === "Pending For Issuance"){
$issuance_status = "Pending";
}else
if($issuance_status === "Medical Pending"){
$issuance_status = "Medical";
}else
if($issuance_status === "Medical Declined"){
$issuance_status = "Declined";
}else
if($issuance_status === "Cheque Dishonor"){
$issuance_status = "Declined";
}else
if(!$issuance_status){
$issuance_status = "Not Updated";
}
$rows['data'][] = array("name"=>$issuance_status,"y"=>$premium,"drilldown"=>$issuance_status);
$drill_result = $this->Homemodel->issuance_chart_drill($issuance_status,$category,$date);
$drill = array();
$drill['name'] = $issuance_status;
$drill['id'] = $issuance_status;
foreach ($drill_result as $key => $value) {
$document_issue_status = $value['document_issue_status'];
$doc_premium = $value['doc_premium'];
if(!$document_issue_status){
$document_issue_status = "Not Updated";
}
$drill['data'][] = array($document_issue_status,$doc_premium);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
public function renew_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->renew_chart($category,$start_date,$end_date);
if($result){
$drill_list = array();
foreach ($result as $key => $value) {
$renew_status = $value['log_renew_status'];
$premium = $value['premium'];
if(!$renew_status){
$renew_status = "Not Updated";
}
$rows['data'][] = array("name"=>$renew_status,"y"=>$premium,"drilldown"=>$renew_status);
$drill_result = $this->Homemodel->renew_chart_drill($renew_status,$category,$start_date,$end_date);
$drill = array();
$drill['name'] = $renew_status;
$drill['id'] = $renew_status;
foreach ($drill_result as $key => $value) {
$client_status = $value['log_client_status'];
$client_premium = $value['premium'];
$drill['data'][] = array("name"=>$client_status,"y"=>$client_premium,"drilldown"=>$client_status);
array_push($drill_list,$drill);
$drill2_result = $this->Homemodel->renew_chart_drill2($client_status,$category,$start_date,$end_date);
$drill2 = array();
$drill2['name'] = $client_status;
$drill2['id'] = $client_status;
foreach ($drill2_result as $key => $value) {
$premium_status = $value['log_premium_status'];
$premium_val = $value['premium'];
$drill2['data'][] = array($premium_status,$premium_val);
array_push($drill_list,$drill2);
}
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list, 'drill' => $drill),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
//MIS Charts End
//RM & RM Manager Charts Start
public function rm_ni_chart(){
$result = $this->Homemodel->rm_ni_chart();
$rows['type'] = 'pie';
$rows['name'] = 'Company';
foreach ($result as $key => $value) {
$rows['data'][] = array($value['renew_reason'], $value['notpaid']);
}
$rslt = array();
array_push($rslt,$rows);
print json_encode($rslt, JSON_NUMERIC_CHECK);
}
public function rmm_ni_chart(){
$result = $this->Homemodel->rmm_ni_chart();
$rows['type'] = 'pie';
$rows['name'] = 'Company';
foreach ($result as $key => $value) {
$rows['data'][] = array($value['renew_reason'], $value['notpaid']);
}
$rslt = array();
array_push($rslt,$rows);
print json_encode($rslt, JSON_NUMERIC_CHECK);
}
public function get_rm_val_chart(){
$type = $_REQUEST['type'];
$result = $this->Homemodel->get_rm_val_chart($type);
$drill_list = array();
foreach ($result as $key => $value) {
$lead_status = $value['lead_status'];
$statusname = $value['statusname'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$statusname,"y"=>$lead_count,"drilldown"=>$statusname);
$drill_result = $this->Homemodel->rm_chart_drill($type,$lead_status);
$drill = array();
$drill['name'] = $statusname;
$drill['id'] = $statusname;
foreach ($drill_result as $key => $value) {
$prospect_name = $value['prospect_name'];
$lead_count = $value['lead_count'];
$drill['data'][] = array($prospect_name,$lead_count);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}
public function get_rm_chart(){
$id = $this->session->userdata('emp_id');
if($this->input->post('admin')==="1")
{
$id = $this->input->post('emp_id');
}
$rm_team_qry = $this->db->query("SELECT GROUP_CONCAT(id SEPARATOR ',') as rm_ids FROM `ospos_employees` inner join ospos_people on ospos_people.person_id = ospos_employees.person_id where category = '2' and reporting in ($id) and deleted = '0'");
$rm_info = $rm_team_qry->result_array();
$rm_ids = $rm_info[0]['rm_ids'];
$type = $_REQUEST['type'];
$emp_id = $_REQUEST['emp_id'];
$emp_role = $_REQUEST['emp_role'];
$emp_cat = $_REQUEST['emp_cat'];
if(($emp_id === "ALL") || ($this->input->post('admin')==="1")){
$emp_id = $rm_ids;
}
$result = $this->Homemodel->get_rm_chart($type,$emp_id,$emp_role,$emp_cat);
$drill_list = array();
foreach ($result as $key => $value) {
$lead_status = $value['lead_status'];
$statusname = $value['statusname'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$statusname,"y"=>$lead_count,"drilldown"=>$statusname);
$drill_result = $this->Homemodel->rmm_chart_drill($type,$lead_status,$emp_id,$emp_role,$emp_cat);
$drill = array();
$drill['name'] = $statusname;
$drill['id'] = $statusname;
foreach ($drill_result as $key => $value) {
$prospect_name = $value['prospect_name'];
$lead_count = $value['lead_count'];
$drill['data'][] = array($prospect_name,$lead_count);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}
//RM & RM Manager Charts END
//CRM & AM Chart Start
public function crm_chart(){
$emp_id=$this->input->post('emp_id_all');
$emp_role=$this->input->post('role');
$emp_cat=$this->input->post('emp_cat');
$result = $this->Homemodel->crm_chart($emp_id,$emp_role,$emp_cat);
$drill_list = array();
//$rows['colorByPoint'] = false;
foreach ($result as $key => $value) {
$lead_status = $value['lead_status'];
$statusname = $value['statusname'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$statusname,"y"=>$lead_count,"drilldown"=>$statusname);
$drill_result = $this->Homemodel->crm_chart_drill($lead_status,$emp_id,$emp_role,$emp_cat);
$drill = array();
$drill['name'] = $statusname;
$drill['id'] = $statusname;
foreach ($drill_result as $key => $value) {
$prospect_name = $value['prospect_name'];
$lead_count = $value['lead_count'];
$drill['data'][] = array($prospect_name,$lead_count);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}
// MET chart for team leader 04aug2018 @GS
public function tl_crm_met_chart(){
$emp_id_all=$this->input->post('emp_id_all');
$role=$this->input->post('role');
$emp_cat=$this->input->post('emp_cat');
$result = $this->Homemodel->tl_crm_met_chart($emp_id_all,$role,$emp_cat);
foreach ($result as $key => $value) {
$lead_status = $value['crm_name'];
$crm_name = $value['crm_name'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$crm_name,"y"=>$lead_count);
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt),JSON_NUMERIC_CHECK);
}
public function tl_rm_met_chart(){
$emp_id_all=$this->input->post('emp_id_all');
$role=$this->input->post('role');
$emp_cat=$this->input->post('emp_cat');
$result = $this->Homemodel->tl_rm_met_chart($emp_id_all,$role,$emp_cat);
foreach ($result as $key => $value) {
$lead_status = $value['crm_name'];
$rm_name = $value['crm_name'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$rm_name,"y"=>$lead_count);
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt),JSON_NUMERIC_CHECK);
}
//@GS 06aug2018 healthteamperformance
public function healthteamperformance(){
$emp_id_all=$this->input->post('emp_id_all');
$role=$this->input->post('role');
$emp_cat=$this->input->post('emp_cat');
$result = $this->Homemodel->healthteamperformance($emp_id_all,$role,$emp_cat);
foreach ($result as $key => $value) {
$crm_name = $value['crm_name'];
$netamount = $value['netamount'];
$rows['data'][] = array("name"=>$crm_name,"y"=>$netamount);
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt),JSON_NUMERIC_CHECK);
}
public function am_crm_chart($emp_id,$emp_cat,$emp_role){
$emp_id = $_REQUEST['emp_id'];
$emp_cat = $_REQUEST['emp_cat'];
$emp_role = $_REQUEST['emp_role'];
$result = $this->Homemodel->am_crm_chart($emp_id,$emp_cat,$emp_role);
$drill_list = array();
foreach ($result as $key => $value) {
//$emp_id = $emp_id;
//$emp_cat = $emp_cat;
//$emp_role = $emp_role;
$lead_status = $value['lead_status'];
$statusname = $value['statusname'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$statusname,"y"=>$lead_count,"drilldown"=>$statusname);
$drill_result = $this->Homemodel->am_crm_chart_drill($lead_status,$emp_id,$emp_cat,$emp_role);
$drill = array();
$drill['name'] = $statusname;
$drill['id'] = $statusname;
foreach ($drill_result as $key => $value) {
$prospect_name = $value['prospect_name'];
$lead_count = $value['lead_count'];
$drill['data'][] = array($prospect_name,$lead_count);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}
//CRM & AM Chart End
public function logout(){
$this->Employee->logout();
}
// @GS 06aug2018 teamleader and crm
public function crmportfoliodashboard($empid){
$data="";
$data['emp_portfolio_empid'] = $empid;
$data['emp_portfolio_cat'] = "2";
$data['emp_portfolio_role'] = "3";
$data['emp_portfolio_onchange'] = "1";
$this->load->view('CrmPortfolioDashboard',$data);
}
public function teamleaderdashboard($empid){
$data="";
$data['emp_portfolio_empid'] = $this->session->userdata('emp_id');
$data['emp_portfolio_cat'] = $this->session->userdata('emp_category');
$data['emp_portfolio_role'] = "6";
$data['emp_portfolio_onchange'] = "1";
$this->load->view('TeamleaderDashboard',$data);
}
public function crmhealthdashboard($empid){
$data="";
$data['emp_health_empid'] = $empid;
$data['emp_health_cat'] = "3";
$data['emp_health_role'] = "3";
$data['emp_health_onchange'] = "1";
$this->load->view('CrmHealthDashboard',$data);
}
// @GS 06aug2018 teamleader and crm END
public function get_tl_info(){
$data="";
$data['emp_portfolio_empid'] = $this->input->post('emp_id');
$data['emp_portfolio_cat'] = $this->input->post('emp_cat');
$data['emp_portfolio_role'] = $this->input->post('emp_role');
$data['emp_portfolio_onchange'] = "1";
$this->load->view('TeamleaderDashboard',$data);
}
public function admin_call_mis(){
$data="";
$this->load->view('mis_dashboard',$data);
}
public function get_rm_admin_info(){
$data="";
$data['emp_role'] = $this->input->post('emp_role');
$data['emp_cat'] = $this->input->post('emp_cat');
if($this->input->post('admin')==="1")
{
if($this->input->post('emp_id')==="ALL")
{
$data['emp_check'] = $this->input->post('emp_id');
$data['emp_id'] = $this->input->post('rm_ids');
}
else
{
$data['emp_check'] = "ALL";
$data['emp_id'] = $this->input->post('emp_id');
}
}
else
{
$data['emp_id'] = $this->input->post('emp_id');
}
$data['emp_onchange'] = "1";
//print_r($data); die();
$this->load->view('rmdashboard',$data);
}
public function get_map_crm_info(){
$emp_id = $this->input->post('emp_id');
$team = $this->db->query("SELECT GROUP_CONCAT(teammembers SEPARATOR ',') as teammembers FROM `ospos_team` where teamleader in ($emp_id) and deleted = '0'");
$team_info = $team->result_array();
$map_crm = $team_info[0]['teammembers'];
echo $map_crm;
}
//RM Manager Dashboard
public function get_rm_info(){
$data="";
$data['emp_role'] = $this->input->post('emp_role');
$data['emp_cat'] = $this->input->post('emp_cat');
if($this->input->post('emp_id')==="ALL")
{
$data['emp_check'] = $this->input->post('emp_id');
$data['emp_id'] = $this->session->userdata('emp_id');
}
else
{
$data['emp_id'] = $this->input->post('emp_id');
}
$data['emp_onchange'] = "1";
//print_r($data); die();
$this->load->view('rmdashboard',$data);
}
public function gm_lead_portfolio_chart(){
$start_date=$this->input->post('start_date');
$end_date=$this->input->post('end_date');
$emp_cat=$this->input->post('emp_cat');
$result = $this->Homemodel->gm_lead_portfolio_chart($start_date,$end_date,$emp_cat);
$drill_list = array();
//$rows['colorByPoint'] = false;
foreach ($result as $key => $value) {
$lead_status = $value['lead_status'];
$statusname = $value['statusname'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$statusname,"y"=>$lead_count,"drilldown"=>$statusname);
$drill_result = $this->Homemodel->gm_lead_portfolio_chart_drill($lead_status,$start_date,$end_date,$emp_cat);
$drill = array();
$drill['name'] = $statusname;
$drill['id'] = $statusname;
foreach ($drill_result as $key => $value) {
$prospect_name = $value['prospect_name'];
$lead_count = $value['lead_count'];
$drill['data'][] = array($prospect_name,$lead_count);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}
public function gm_lead_portfolio_rm_chart(){
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$emp_cat = $_REQUEST['emp_cat'];
$result = $this->Homemodel->gm_lead_portfolio_rm_chart($start_date,$end_date,$emp_cat);
print json_encode($result, JSON_NUMERIC_CHECK);
}
public function gm_health_crm_chart(){
$start_date=$this->input->post('start_date');
$end_date=$this->input->post('end_date');
$emp_cat=$this->input->post('emp_cat');
$result = $this->Homemodel->gm_health_crm_chart($start_date,$end_date,$emp_cat);
$drill_list = array();
//$rows['colorByPoint'] = false;
foreach ($result as $key => $value) {
$lead_status = $value['lead_status'];
$statusname = $value['statusname'];
$lead_count = $value['lead_count'];
$rows['data'][] = array("name"=>$statusname,"y"=>$lead_count,"drilldown"=>$statusname);
$drill_result = $this->Homemodel->gm_health_crm_chart_drill($start_date,$end_date,$statusname,$emp_cat);
$drill = array();
$drill['name'] = $statusname;
$drill['id'] = $statusname;
foreach ($drill_result as $key => $value) {
$prospect_name = $value['prospect_name'];
$lead_count = $value['lead_count'];
$drill['data'][] = array($prospect_name,$lead_count);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}
public function gm_rm_avg_business_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->gm_rm_manager_avg($category,$start_date,$end_date);
//print_r($result[data]);
if($result){
$drill_list = array();
$new_result = $result[data];
foreach ($new_result as $key => $value) {
$id = $value['id'];
$name = $value['rm_manager'];
$month_count= $value['month_count'];
$premium = $value['netamount'];
if($month_count > 0){
$premium = $premium / $month_count;
}
$rows['data'][] = array("name"=>$name,"y"=>$premium,"drilldown"=>$name);
$drill_result = $this->Homemodel->gm_rm_avg($id,$category,$start_date,$end_date);
$drill = array();
$drill['name'] = $name;
$drill['id'] = $name;
$new_drill = $drill_result[data];
foreach ($new_drill as $key => $value){
$rm_name = $value['rm_name'];
$month_count = $value['month_count'];
$netamount = $value['value'];
if($month_count > 0){
$netamount = $netamount / $month_count;
}
$drill['data'][] = array($rm_name,$netamount);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
public function gm_month_wise_chart(){
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$category = $_REQUEST['category'];
$result = $this->Homemodel->gm_month_wise_chart($start_date,$end_date,$category);
//print_r($result);
print json_encode($result, JSON_NUMERIC_CHECK);
}
public function gm_health_avg_business_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->gm_health_manager_avg($category,$start_date,$end_date);
//print_r($result[data]);
if($result){
$drill_list = array();
$new_result = $result[data];
foreach ($new_result as $key => $value) {
$id = $value['id'];
$name = $value['health_manager'];
$month_count= $value['month_count'];
$premium = $value['netamount'];
if($month_count > 0){
$premium = $premium / $month_count;
}
$rows['data'][] = array("name"=>$name,"y"=>$premium,"drilldown"=>$name);
$drill_result = $this->Homemodel->gm_health_crm_avg($id,$category,$start_date,$end_date);
$drill = array();
$drill['name'] = $name;
$drill['id'] = $name;
$new_drill = $drill_result[data];
foreach ($new_drill as $key => $value){
$crm_name = $value['crm_name'];
$month_count = $value['month_count'];
$netamount = $value['value'];
if($month_count > 0){
$netamount = $netamount / $month_count;
}
$drill['data'][] = array($crm_name,$netamount);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
public function gm_health_month_wise_chart(){
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$category = $_REQUEST['category'];
$result = $this->Homemodel->gm_health_month_wise_chart($start_date,$end_date,$category);
//print_r($result);
print json_encode($result, JSON_NUMERIC_CHECK);
}
public function gm_health_business_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->gm_health_manager_bus($category,$start_date,$end_date);
if($result){
$drill_list = array();
$new_result = $result[data];
foreach ($new_result as $key => $value) {
$id = $value['id'];
$name = $value['health_manager'];
$premium = $value['netamount'];
$rows['data'][] = array("name"=>$name,"y"=>$premium,"drilldown"=>$name);
$drill_result = $this->Homemodel->gm_health_crm_bus($id,$category,$start_date,$end_date);
$drill = array();
$drill['name'] = $name;
$drill['id'] = $name;
$new_drill = $drill_result[data];
foreach ($new_drill as $key => $value){
$crm_name = $value['crm_name'];
$netamount = $value['value'];
$drill['data'][] = array($crm_name,$netamount);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
/*
public function gm_mf_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->gm_mf_chart($category,$start_date,$end_date);
if($result){
foreach ($result as $key => $value){
$rm_name = $value['first_name'];
$netamount = $value['netamount'];
$rows['data'][] = array($rm_name,$netamount);
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
*/
public function gm_mf_chart(){
$category = $_REQUEST['category'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$result = $this->Homemodel->gm_mf_manager_avg($category,$start_date,$end_date);
//print_r($result[data]);
if($result){
$drill_list = array();
$new_result = $result[data];
foreach ($new_result as $key => $value) {
$id = $value['id'];
$name = $value['rm_manager'];
$premium = $value['netamount'];
$rows['data'][] = array("name"=>$name,"y"=>$premium,"drilldown"=>$name);
$drill_result = $this->Homemodel->gm_mf_rm_avg($id,$category,$start_date,$end_date);
$drill = array();
$drill['name'] = $name;
$drill['id'] = $name;
$new_drill = $drill_result[data];
foreach ($new_drill as $key => $value){
$rm_name = $value['rm_name'];
$netamount = $value['value'];
$drill['data'][] = array($rm_name,$netamount);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
public function gm_mf_month_wise_chart(){
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$category = $_REQUEST['category'];
$result = $this->Homemodel->gm_mf_month_wise_chart($start_date,$end_date,$category);
//print_r($result);
print json_encode($result, JSON_NUMERIC_CHECK);
}
// MF Start
public function get_ewealth_chart(){
$result = $this->Homemodel->get_client_sts();
if($result){
$drill_list = array();
foreach ($result as $key => $value) {
$client_sts = $value['client_sts'];
$client_sts_count = $value['count'];
if(!$client_sts){
$client_sts = "Not Updated";
}
$rows['data'][] = array("name"=>$client_sts,"y"=>$client_sts_count,"drilldown"=>$client_sts);
$drill_result = $this->Homemodel->doc_chart_drill($client_sts);
$drill = array();
$drill['name'] = $client_sts;
$drill['id'] = $client_sts;
foreach ($drill_result as $key => $value) {
$doc_sts = $value['doc_sts'];
$doc_count = $value['count'];
$drill['data'][] = array("name"=>$doc_sts,"y"=>$doc_count,"drilldown"=>$doc_sts);
array_push($drill_list,$drill);
$drill2_result = $this->Homemodel->ewealth_sts_chart_drill2($doc_sts);
$drill2 = array();
$drill2['name'] = $doc_sts;
$drill2['id'] = $doc_sts;
foreach ($drill2_result as $key => $value) {
$ewealth_sts = $value['ewealth_sts'];
$ewealth_count = $value['count'];
$drill2['data'][] = array("name"=>$ewealth_sts,"y"=>$ewealth_count,"drilldown"=>$ewealth_sts);
array_push($drill_list,$drill2);
$drill3_result = $this->Homemodel->ewealth_reason_drill3($ewealth_sts);
$drill3 = array();
$drill3['name'] = $ewealth_sts;
$drill3['id'] = $ewealth_sts;
foreach ($drill3_result as $key => $value) {
$rejected_reason = $value['rejected_reason'];
$rejected_count = $value['count'];
if(!$rejected_reason){
$rejected_reason = "Registered";
}
$drill3['data'][] = array($rejected_reason,$rejected_count);
array_push($drill_list,$drill3);
}
}
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list, 'drill' => $drill),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
public function invest_login_chart(){
$result = $this->Homemodel->invest_login_chart();
if($result){
$drill_list = array();
foreach ($result as $key => $value) {
$login_status = $value['login_status'];
$amount = $value['amount'];
if(!$login_status){
$login_status = "Not Updated";
}
$rows['data'][] = array("name"=>$login_status,"y"=>$amount,"drilldown"=>$login_status);
$drill_result = $this->Homemodel->invest_chart_drill($login_status);
$drill = array();
$drill['name'] = $login_status;
$drill['id'] = $login_status;
foreach ($drill_result as $key => $value) {
$sip_status = $value['sip_status'];
$sip_amount = $value['amount'];
if(!$sip_status){
$sip_status = "Pending";
}
$drill['data'][] = array("name"=>$sip_status,"y"=>$sip_amount,"drilldown"=>$sip_status);
array_push($drill_list,$drill);
}
}
$rslt = array();
array_push($rslt,$rows);
echo json_encode(array('series' => $rslt, 'drill_list' => $drill_list, 'drill' => $drill),JSON_NUMERIC_CHECK);
}else{
echo json_encode(array('series' => '', 'drill_list' => ''),JSON_NUMERIC_CHECK);
}
}
public function investment_chart(){
$result = $this->Homemodel->investment_chart();
$category['name'] = 'Name';
$series1['name'] = 'Value';
//print_r($result);
foreach ($result as $key => $value) {
$invest = $value['investment_type'];
if($invest === "SIP"){
$category['data'][] = $invest;
$series1['data'][] = $value['amount'];
}else
if($invest === "LUMPSUM"){
$category['data'][] = $invest;
$series1['data'][] = $value['amount'];
}
$category['name'] = $value['login_status'];
}
$result = array();
array_push($result,$category);
array_push($result,$series1);
print json_encode($result, JSON_NUMERIC_CHECK);
}
//MF END
}
?>