I am using Codeignitor code, the code works fine and show output on localhost fine but the same code when run on live server gives an error as:
A PHP Error was encountered
Severity: Notice
Message: Undefined property: Welcome::$data
Filename: controllers/Welcome.php
Line Number: 49
Backtrace:
File: /application/controllers/Welcome.php
Line: 49
Function: _error_handler
The code is as follows
- application/controllers/Welcome.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Welcome extends CI_Controller
{
public function __construct()
{
parent::__construct();
if (!$this->ion_auth->logged_in() || empty($this->session->name))
{
redirect('/login');
}
$this->load->helper('url');
$this->load->model('BasicModel', 'basic');
$this->load->model('LabelModel', 'label');
}
public function index()
{
//if candidate, go to basic details
if($this->ion_auth->in_group('candidate'))
{
redirect('basic/edit/'.$this->session->basic_id);
}
if($_SESSION['org']==1)
{
//Get MIS count
$this->getMISCount();
}
else
{
//Get Vericraft count without integration
$this->getCount();
}
if($this->ion_auth->in_group('admin'))
{
//Get Client list
$this->getClientList();
}
else if($this->ion_auth->in_group('dev'))
{
$this->getDevData();
}
$this->load->view('welcome_message', $this->data);
}
public function candidate()
{
$this->data['label_data'] = $this->label->view_label();
$query = $this->db->query("SELECT id, CONCAT(CAST(AES_DECRYPT(fname,'".encrypted_key."') AS CHAR) AS fname,' ',CAST(AES_DECRYPT(mname,'".encrypted_key."') AS CHAR) AS mname, ' ',CAST(AES_DECRYPT(sname,'".encrypted_key."') AS CHAR) AS sname) as name,Refno, gender, CAST(AES_DECRYPT(dob,'".encrypted_key."') AS CHAR) AS dob, CAST(AES_DECRYPT(email,'".encrypted_key."') AS CHAR) AS email, CAST(AES_DECRYPT(contact,'".encrypted_key."') AS CHAR) AS contact, CAST(AES_DECRYPT(empid,'".encrypted_key."') AS CHAR) AS empid, CAST(AES_DECRYPT(location,'".encrypted_key."') AS CHAR) AS location, CAST(AES_DECRYPT(report,'".encrypted_key."') AS CHAR) AS report FROM basic WHERE user_id =".$this->session->user_id);
$this->data['show_data'] = $query->result_array();
//to get total document label
$label_query = $this->db->select('id, label')->from('components')->get();
$this->data['labels'] = array_column($label_query->result_array(), 'label');
$query =$this->db->select('COUNT(vlink.id) as num_doc, vlink.file_name, vlink.created_at, vlink.updated_at, vlabel.label')
->from('document_links as vlink')
->join('components as vlabel', 'vlink.comp_id = vlabel.id', 'full outer')
->where('vlink.user_id', $this->session->user_id)
->group_by('vlink.comp_id')
->get();
$this->data['count_data'] = array_column($query->result_array(), 'num_doc', 'label');
$this->session->set_flashdata('message', 'Details updated successfully!');
return redirect($this->agent->referrer());
}
public function logout()
{
$this->ion_auth->logout();
redirect('login/index', 'refresh');
}
public function getMISCount()
{
if($this->ion_auth->in_group('admin'))
{
//MIS Total cases
$this->data['mis_total']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as total FROM ichek_database WHERE ichek_database.Refno NOT LIKE '%test%' AND ichek_database.reasonpending NOT LIKE '%dup%';")->row();
//MIS Pending Cases
$this->data['mis_pending']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as pending FROM ichek_database WHERE ichek_database.Refno NOT LIKE '%test%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate='' OR ichek_database.reportdate=0 OR ichek_database.reportdate IS NULL);")->row();
//MIS Green Cases
$this->data['mis_green']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as green FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno NOT LIKE '%test%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND ichek_database.reportdate!='' AND ichek_database.reportdate!=0 AND ichek_database.reportdate IS NOT NULL AND (ichek_remark.negdedupcolor='' OR ichek_remark.negdedupcolor IS NULL OR ichek_remark.negdedupcolor='Green');")->row();
//MIS Amber Cases
$this->data['mis_amber']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as yellow FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno NOT LIKE '%test%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate!='' AND ichek_database.reportdate!=0 AND ichek_database.reportdate IS NOT NULL) AND ichek_remark.negdedupcolor='Amber';")->row();
//MIS Red Cases
$this->data['mis_red']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as red FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno NOT LIKE '%test%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate!='' AND ichek_database.reportdate!=0 AND ichek_database.reportdate IS NOT NULL) AND ichek_remark.negdedupcolor='Red';")->row();
//MIS Stop Cases
$this->data['mis_stop']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as stop FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno NOT LIKE '%test%' AND ichek_database.reasonpending LIKE '%stop%';")->row();
}
else if($this->ion_auth->in_group('client'))
{
//MIS Total cases
$this->data['mis_total']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as total FROM ichek_database WHERE ichek_database.Refno LIKE '%".$_SESSION['client_code']."%' AND ichek_database.reasonpending NOT LIKE '%dup%';")->row();
//MIS Pending Cases
$this->data['mis_pending']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as pending FROM ichek_database WHERE ichek_database.Refno LIKE '%".$_SESSION['client_code']."%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate='' OR ichek_database.reportdate=0 OR ichek_database.reportdate IS NULL);")->row();
//MIS Green Cases
$this->data['mis_green']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as green FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno LIKE '%".substr($_SESSION['client_code'], 0, 4)."%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate!='' AND ichek_database.reportdate!=0 AND ichek_database.reportdate IS NOT NULL) AND (ichek_remark.negdedupcolor='' OR ichek_remark.negdedupcolor IS NULL OR ichek_remark.negdedupcolor='Green');")->row();
//MIS Amber Cases
$this->data['mis_amber']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as yellow FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno LIKE '%".substr($_SESSION['client_code'], 0, 4)."%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate!='' AND ichek_database.reportdate!=0 AND ichek_database.reportdate IS NOT NULL) AND ichek_remark.negdedupcolor='Amber';")->row();
//MIS Red Cases
$this->data['mis_red']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as red FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno LIKE '%".substr($_SESSION['client_code'], 0, 4)."%' AND (ichek_database.reasonpending NOT LIKE '%dup%' AND ichek_database.reasonpending NOT LIKE '%stop%') AND (ichek_database.reportdate!='' AND ichek_database.reportdate!=0 AND ichek_database.reportdate IS NOT NULL) AND ichek_remark.negdedupcolor='Red';")->row();
//MIS Stop Cases
$this->data['mis_stop']=$this->load->database('mis',TRUE)->query("SELECT COUNT(*) as stop FROM ichek_database INNER JOIN ichek_remark ON ichek_database.Refno=ichek_remark.Refno WHERE ichek_database.Refno LIKE '%".substr($_SESSION['client_code'], 0, 4)."%' AND ichek_database.reasonpending LIKE '%stop%';")->row();
}
}
public function getCount()
{
if($this->ion_auth->in_group('admin'))
{
$query=$this->db->query("select count(vbasic.id) as num, vbasic.status from basic as vbasic inner join users on vbasic.user_id=users.id WHERE users.org=".$this->session->org." group by vbasic.status;");
}
else if($this->ion_auth->in_group('client'))
{
$query=$this->db->query("select count(vbasic.id) as num, vbasic.status from basic as vbasic inner join users on vbasic.user_id=users.id where vbasic.Refno like '%".$this->session->client_code."%' and users.org=".$this->session->org." group by vbasic.status;");
}
else if($this->ion_auth->in_group('dev'))
{
$query=$this->db->query("select count(vbasic.id) as num, vbasic.status from basic as vbasic inner join users on vbasic.user_id=users.id WHERE users.org=".$this->session->org." group by vbasic.status;");
}
$this->data['countData'] = array_column($query->result_array(), 'num', 'status');
}
public function getClientList()
{
if($_SESSION['org']==1)
{
$this->data['mis_clients']=$this->load->database('mis',TRUE)->query("SELECT DISTINCT(temp.full_name) as full_name, temp.client FROM temp INNER JOIN ichek_basic ON temp.client=ichek_basic.client INNER JOIN ichek_database ON ichek_basic.Refno=ichek_database.Refno WHERE temp.client NOT LIKE '%test%' AND ichek_database.reasonpending NOT LIKE '%dup%' ORDER BY temp.full_name")->result();
}
else
{
$this->data['clients'] = $this->db->query("SELECT DISTINCT(users.company), users.client_code FROM `users` INNER JOIN users_groups on users.id=users_groups.user_