Hey everyone,
I'm trying to generate a list of employees and in that list I want to
show the customer which that employee belongs to. In my db I have an
employees table and a customers table and each employee has a
customer_id field. The problem is, I want to show the customer.name
field, not the customer_id.
How do I run a select statement that joins these two tables on the
customer_id and retrieves only the customer_name from the customers
table.
I need to do this from inside the employees controller. Here's my
models and controller code.
class EmployeeModel extends AppModel
{
var $name = "Employee";
var $belongsTo = "Customer";
var $recursive = 1;
}
class Customer extends AppModel
{
var $name = "Customer";
var $primaryKey = 'id';
var $hasMany = array('Employee','Transaction');
var $recursive = 2;
}
class EmployeesController extends AppController
{
var $name = "employees";
var $helpers = array('DatePicker');
var $uses =array('Employee','Customer');
var $paginate = array(
'limit' => 25,
'order' => array('Employee.id' => 'DESC')
);
/*
*
*
*
*/
function index(){
//retrieve all of the customers for drop down box and set the
data
$customerList =
$this->Customer->findAll(NULL,array('id','name'));
foreach ($customerList as $customer)
$customers[$customer['Customer']['id']] =
$customer['Customer']
['name'];
$this->set('customers', $customers);
//if data is posted, retrieve all employees specific to the
customer
id
if(!empty($this->data)){
$this->layout = 'default';
$dataSet =
$this->paginate('Employee',array('customer_id' => $this-
>data['Employee']['customer_id']));
$this->set(compact('dataSet'));
}
//if no data is posted, retrieve all employees
else{
$this->layout = 'default';
$dataSet = $this->paginate('Employee');
$this->set(compact('dataSet'));
}
}
Thanks for the help.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
