public function findByName($name, $addressBook = null)
{
$select = $this->getDbTable()->select()->where('CONCAT(first_name, \' \', last_name) LIKE ?', '%' . $name . '%');
if ($addressBook != null) {
$select->where('address_book_id = ?', $addressBook);
}
$resultSet = $this->getDbTable()->fetchAll($select);
$entries = array();
foreach ($resultSet as $row) {
$entry = new Default_Model_Contact();
$entry->setId($row->id)->setAddressBookId($row->address_book_id)->setFirstName($row->first_name)->setLastName($row->last_name)->setAddress1($row->address_1)->setAddress2($row->address_2)->setTown($row->town)->setCounty($row->county)->setCountry($row->country)->setPostCode($row->post_code)->setHomeTel($row->home_tel)->setWorkTel($row->work_tel)->setMobileTel($row->mobile_tel)->setFax($row->fax)->setEmail($row->email)->setMapper($this);
$entries[] = $entry;
}
return $entries;
}
public function findContacts($id)
{
$result = $this->getDbTable()->find($id);
if (0 == count($result)) {
return array();
}
$row = $result->current();
$resultSet = $row->findDependentRowset('Default_Model_DbTable_Contacts');
$contacts = array();
foreach ($resultSet as $row) {
$contact = new Default_Model_Contact();
$contact->setId($row->id)->setAddressBookId($row->address_book_id)->setFirstName($row->first_name)->setLastName($row->last_name)->setAddress1($row->address_1)->setAddress2($row->address_2)->setCounty($row->county)->setCountry($row->country)->setPostCode($row->post_code)->setHomeTel($row->home_tel)->setWorkTel($row->work_tel)->setMobileTel($row->mobile_tel)->setFax($row->fax)->setEmail($row->email);
$contacts[] = $contact;
}
return $contacts;
}
public function viewAction()
{
$id = (int) $this->getRequest()->getParam('id');
$contact = new Default_Model_Contact();
$request = $this->getRequest();
$form = new Default_Form_Contact();
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
$model = new Default_Model_Contact($form->getValues());
$model->setId($id);
$model->save();
return $this->_helper->redirector('index', 'index');
}
} else {
$form->populate($contact->getOptions($id));
}
$this->view->headTitle($this->view->escape($contact->getFirstName() . ' ' . $contact->getLastName()));
$this->view->form = $form;
}
