[eluser]Atrhick[/eluser]
Hello guys i ma not sure whats wrong with this but please take a look at my Model code and controller code and then error
Model Code:
Code:
class Earnings_model extends CI_Model{
function Earnings_model(){
parent::__construct();
}
function buyer_clients_names()
{
$query_str = "SELECT partner_id_buyer "
. " FROM lead_partners_pages "
. " WHERE date_year = MONTH(NOW()- INTERVAL 7 MONTH) "
. " AND partner_id_buyer IS NOT NULL AND partner_id_buyer NOT IN ('','0','1','2','3','3.3','4','5','6','7','8','9','10','11','12','13','14','15','16','CIQFY','[partner_code]') "
. " GROUP BY partner_id_buyer ";
$result = $this->db->query($query_str);
if($result->num_rows() > 0)
{
$Buyer_client_names_results = array();
foreach($result->result_array() as $Buyer_client_names_done)
{
$Buyer_client_names_results[] = $Buyer_client_names_done;
}
}
return $Buyer_client_names_results;
}
function sellers_clients_names()
{
$query_str = "SELECT afid_seller_name "
. " FROM lead_partners_pages "
. " WHERE date_year = MONTH(NOW()- INTERVAL 7 MONTH) "
. " AND afid_seller_name IS NOT NULL AND afid_seller_name NOT IN ('','0','1','2','3','3.3','4','5','6','7','8','9','10','11','12','13','14','15','16','CIQFY','[partner_code]') "
. " GROUP BY afid_seller_name ";
$result = $this->db->query($query_str);
if($result->num_rows() > 0)
{
$Sellers_client_names_results = array();
foreach($result->result_array() as $Sellers_client_names_done)
{
$Sellers_client_names_results[] = $Sellers_client_names_done;
}
}
return $Sellers_client_names_results;
}
}
Controller Code:
Code:
class Earnings extends CI_Controller{
function Earnings(){
parent::__construct();
$this->view_data['base_url'] = base_url();
}
function index(){
$this->earningsdetails();
}
function earningsdetails(){
if ($this->session->userdata('logged_in') !== FALSE)
{
$Sellers_client_names_results['Sellers_client_names_results'] = $this->Earnings_model->sellers_clients_names();
$Buyer_client_names_results['Buyer_client_names_results'] = $this->Earnings_model->buyer_clients_names();
if(!empty($Buyer_client_names_results) && !empty($Sellers_client_names_results))
{
$this->view_data['Sellers_client_names_results'] = $this->Earnings_model->sellers_clients_names();
$this->view_data['Buyer_client_names_results'] = $this->Earnings_model->buyer_clients_names();
$this->load->view('earning_report_view', $this->view_data);
}
}
else
{
$hackerror['hackerror'] = "Please Login First!";
$this->load->view('login_view', $hackerror);
}
}
}
Error Message:
Code:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: Sellers_client_names_result
Filename: models/earnings_model.php
Line Number: 52
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: Buyer_client_names_results
Filename: models/earnings_model.php
Line Number: 29