public function peopleNewPeopleAction()
{
$db = Zend_Db_Table_Abstract::getDefaultAdapter();
$rows = $db->fetchAll('select
person.*,qualification_phrase,facility.facility_name,location.location_name,user.username as created_by from person
left join person_qualification_option on person_qualification_option.id = primary_qualification_option_id
left join facility on facility_id = facility.id
left join location on facility.location_id = location.id
left join user on user.id=person.created_by
where person.approved is null and person.is_deleted = 0');
$this->viewAssignEscaped('primary_results', $rows);
$go = $this->getSanParam('go');
if ($go) {
require_once 'PersonController.php';
$c = new PersonController($this->getRequest(), $this->getResponse());
$c->searchAction();
$this->viewAssignEscaped('primary_results', $rows);
}
// fill form dropdowns
$this->viewAssignEscaped('locations', Location::getAll());
//training titles
require_once 'models/table/TrainingTitleOption.php';
$titleArray = TrainingTitleOption::suggestionList(false, 10000);
$this->viewAssignEscaped('courses', $titleArray);
//types
$qualificationsArray = OptionList::suggestionListHierarchical('person_qualification_option', 'qualification_phrase', false, false);
$this->viewAssignEscaped('qualifications', $qualificationsArray);
//facilities list
$rowArray = OptionList::suggestionList('facility', array('facility_name', 'id'), false, 9999);
$facilitiesArray = array();
foreach ($rowArray as $key => $val) {
if ($val['id'] != 0) {
$facilitiesArray[] = $val;
}
}
$this->viewAssignEscaped('facilities', $facilitiesArray);
}
