public function editAction()
{
if (!$this->hasACL('edit_employee')) {
$this->doNoAccessError();
}
$db = $this->dbfunc();
$status = ValidationContainer::instance();
$params = $this->getAllParams();
$id = $params['id'];
#// restricted access?? only show partners by organizers that we have the ACL to view
#$org_allowed_ids = allowed_org_access_full_list($this);
#if ($org_allowed_ids && $this->view->mode != 'add') { // doesnt have acl 'training_organizer_option_all'
# $validID = $db->fetchCol("SELECT partner.id FROM partner WHERE partner.id = $id AND partner.organizer_option_id in ($org_allowed_ids)"); // check for both
# if(empty($validID))
# $this->doNoAccessError ();
#}
if ($this->getRequest()->isPost()) {
//validate then save
$params['location_id'] = regionFiltersGetLastID('', $params);
$params['dob'] = $this->_date_to_sql($params['dob']);
$params['agreement_end_date'] = $this->_date_to_sql($params['agreement_end_date']);
$params['transition_date'] = $this->_date_to_sql($params['transition_date']);
$params['transition_complete_date'] = $this->_date_to_sql($params['transition_complete_date']);
$params['site_id'] = $params['facilityInput'];
$params['option_nationality_id'] = $params['lookup_nationalities_id'];
$params['facility_type_option_id'] = $params['employee_site_type_option_id'];
$status->checkRequired($this, 'first_name', t('Frist Name'));
$status->checkRequired($this, 'last_name', t('Last Name'));
$status->checkRequired($this, 'last_name', t('Name'));
$status->checkRequired($this, 'dob', t('Name'));
if ($this->setting('display_employee_nationality')) {
$status->checkRequired($this, 'lookup_nationalities_id', t('Employee Nationality'));
}
$status->checkRequired($this, 'employee_qualification_option_id', t('Staff Cadre'));
if ($this->setting('display_employee_salary')) {
$status->checkRequired($this, 'salary', t('Salary'));
}
if ($this->setting('display_employee_benefits')) {
$status->checkRequired($this, 'benefits', t('Benefits'));
}
if ($this->setting('display_employee_additional_expenses')) {
$status->checkRequired($this, 'additional_expenses', t('Additional Expenses'));
}
if ($this->setting('display_employee_stipend')) {
$status->checkRequired($this, 'stipend', t('Stipend'));
}
if ($this->setting('display_employee_partner')) {
$status->checkRequired($this, 'partner_id', t('Partner'));
}
if ($this->setting('display_employee_sub_partner')) {
$status->checkRequired($this, 'subpartner_id', t('Sub Partner'));
}
if ($this->setting('display_employee_intended_transition')) {
$status->checkRequired($this, 'employee_transition_option_id', t('Intended Transition'));
}
if ($this->setting('display_employee_base') && !$params['employee_base_option_id'] || !$this->setting('display_employee_base')) {
// either one is OK, javascript disables regions if base is on & has a value choice
$status->checkRequired($this, 'province_id', t('Region A (Province)'));
}
if ($this->setting('display_employee_base')) {
$status->checkRequired($this, 'employee_base_option_id', t('Employee Based at'));
}
if (!$status->hasError()) {
$id = $this->_findOrCreateSaveGeneric('employee', $params);
if (!$id) {
$status->setStatusMessage(t('That person could not be saved.'));
} else {
# converted to optionlist, link table not needed TODO. marking for removal.
#MultiOptionList::updateOptions ( 'employee_to_role', 'employee_role_option', 'employee_id', $id, 'employee_role_option_id', $params['employee_role_option_id'] );
$status->setStatusMessage(t('The person was saved.'));
$this->_redirect("employee/edit/id/{$id}");
}
} else {
$status->setStatusMessage(t('That person could not be saved.'));
}
}
if ($id && !$status->hasError()) {
// read data from db
$sql = 'SELECT * FROM employee WHERE employee.id = ' . $id;
$row = $db->fetchRow($sql);
if ($row) {
$params = $row;
} else {
$status->setStatusMessage(t('Error finding that record in the database.'));
}
$region_ids = Location::getCityInfo($params['location_id'], $this->setting('num_location_tiers'));
$region_ids = Location::regionsToHash($region_ids);
$params = array_merge($params, $region_ids);
#$params['roles'] = $db->fetchCol("SELECT employee_role_option_id FROM employee_to_role WHERE employee_id = $id");
}
// assign form drop downs
$params['dob'] = formhelperdate($params['dob']);
$params['agreement_end_date'] = formhelperdate($params['agreement_end_date']);
$params['transition_date'] = formhelperdate($params['transition_date']);
$params['transition_complete_date'] = formhelperdate($params['transition_complete_date']);
$params['courses'] = $this->getCourses($id);
$params['lookup_nationalities_id'] = $params['option_nationality_id'];
$params['employee_site_type_option_id'] = $params['facility_type_option_id'];
$this->viewAssignEscaped('employee', $params);
$validCHWids = $db->fetchCol("select id from employee_qualification_option qual\r\n\t\t\t\t\t\t\t\t\t\tinner join (select id as success from employee_qualification_option where qualification_phrase in ('Community Based Worker','Community Health Worker','NC02 -Community health workers')) parentIDs\r\n\t\t\t\t\t\t\t\t\t\ton (parentIDs.success = qual.id)");
$this->view->assign('validCHWids', $validCHWids);
$this->view->assign('expandCHWFields', !(array_search($params['employee_qualification_option_id'], $validCHWids) === false));
// i.e $validCHWids.contains($employee[qualification])
$this->view->assign('status', $status);
$this->view->assign('pageTitle', $this->view->mode == 'add' ? t('Add Employee') : t('Edit Employee'));
$this->viewAssignEscaped('locations', Location::getAll());
$titlesArray = OptionList::suggestionList('person_title_option', 'title_phrase', false, 9999);
$this->view->assign('titles', DropDown::render('title_option_id', $this->translation['Title'], $titlesArray, 'title_phrase', 'id', $params['title_option_id']));
$this->view->assign('partners', DropDown::generateHtml('partner', 'partner', $params['partner_id'], false, $this->view->viewonly, false));
$this->view->assign('subpartners', DropDown::generateHtml('partner', 'partner', $params['subpartner_id'], false, $this->view->viewonly, false, false, array('name' => 'subpartner_id'), true));
$this->view->assign('bases', DropDown::generateHtml('employee_base_option', 'base_phrase', $params['employee_base_option_id']));
$this->view->assign('site_types', DropDown::generateHtml('employee_site_type_option', 'site_type_phrase', $params['facility_type_option_id']));
$this->view->assign('cadres', DropDown::generateHtml('employee_qualification_option', 'qualification_phrase', $params['employee_qualification_option_id']));
$this->view->assign('categories', DropDown::generateHtml('employee_category_option', 'category_phrase', $params['employee_category_option_id'], false, $this->view->viewonly, false));
$this->view->assign('fulltime', DropDown::generateHtml('employee_fulltime_option', 'fulltime_phrase', $params['employee_fulltime_option_id'], false, $this->view->viewonly, false));
$this->view->assign('roles', DropDown::generateHtml('employee_role_option', 'role_phrase', $params['employee_role_option_id'], false, $this->view->viewonly, false));
#$this->view->assign ( 'roles', CheckBoxes::generateHtml ( 'employee_role_option', 'role_phrase', $this->view, $params['roles'] ) );
$this->view->assign('transitions', DropDown::generateHtml('employee_transition_option', 'transition_phrase', $params['employee_transition_option_id'], false, $this->view->viewonly, false));
$this->view->assign('transitions_complete', DropDown::generateHtml('employee_transition_option', 'transition_phrase', $params['employee_transition_complete_option_id'], false, $this->view->viewonly, false, false, array('name' => 'employee_transition_complete_option_id'), true));
$helper = new Helper();
$this->viewAssignEscaped('facilities', $helper->getFacilities());
$this->view->assign('relationships', DropDown::generateHtml('employee_relationship_option', 'relationship_phrase', $params['employee_relationship_option_id'], false, $this->view->viewonly, false));
$this->view->assign('referrals', DropDown::generateHtml('employee_referral_option', 'referral_phrase', $params['employee_referral_option_id'], false, $this->view->viewonly, false));
$this->view->assign('provided', DropDown::generateHtml('employee_training_provided_option', 'training_provided_phrase', $params['employee_training_provided_option_id'], false, $this->view->viewonly, false));
$employees = OptionList::suggestionList('employee', array('first_name', 'CONCAT(first_name, CONCAT(" ", last_name)) as name'), false, 99999);
$this->view->assign('supervisors', DropDown::render('supervisor_id', $this->translation['Supervisor'], $employees, 'name', 'id', $params['supervisor_id']));
$this->view->assign('nationality', DropDown::generateHtml('lookup_nationalities', 'nationality', $params['lookup_nationalities_id'], false, $this->view->viewonly, false));
$this->view->assign('race', DropDown::generateHtml('person_race_option', 'race_phrase', $params['race_option_id'], false, $this->view->viewonly, false));
}
public function editAction()
{
if (!$this->hasACL('edit_employee')) {
$this->doNoAccessError();
}
$db = $this->dbfunc();
$status = ValidationContainer::instance();
$params = $this->getAllParams();
$id = $params['id'];
#// restricted access?? only show partners by organizers that we have the ACL to view // - removed 5/1/13, they dont want this, its used by site-rollup (datashare), and user-restrict by org.
#$org_allowed_ids = allowed_org_access_full_list($this); // doesnt have acl 'training_organizer_option_all'
#$site_orgs = allowed_organizer_in_this_site($this); // for sites to host multiple training organizers on one domain
#$siteOrgsClause = $site_orgs ? " AND partner.organizer_option_id IN ($site_orgs)" : "";
#if ($org_allowed_ids && $this->view->mode != 'add') {
# $validID = $db->fetchCol("SELECT partner.id FROM partner WHERE partner.id = $id AND partner.organizer_option_id in ($org_allowed_ids) $siteOrgsClause");
# if(empty($validID))
# $this->doNoAccessError ();
#
#}
if ($this->getRequest()->isPost()) {
//validate then save
$status->checkRequired($this, 'partner', t('Partner'));
if ($this->setting('display_partner_type')) {
$status->checkRequired($this, 'partner_type_option_id', t('Type of Partner'));
}
$status->checkRequired($this, 'address1', t('Address 1'));
$status->checkRequired($this, 'address2', t('Address 2'));
$status->checkRequired($this, 'province_id', t('Region A (Province)'));
$status->checkRequired($this, 'phone', t('Phone'));
$status->checkRequired($this, 'fax', t('Fax'));
if ($this->setting('display_employee_funder')) {
$status->checkRequired($this, 'partner_funder_option_id[]', t('Funder'));
}
#$status->checkRequired ( $this, 'funding_end_date[]', t ( 'Funding End Date' ) );
#if ($this->setting('display_employee_intended_transition'))
# $status->checkRequired ( $this, 'employee_transition_option_id', t ( 'Intended Transition' ) );
if ($this->setting('display_employee_agreement_end_date')) {
$status->checkRequired($this, 'agreement_end_date', t('Agreement End Date'));
}
if ($this->setting('display_employee_importance')) {
$status->checkRequired($this, 'partner_importance_option_id', t('Importance'));
}
#$status->checkRequired ( $this, 'comments', t ( 'Partner Comments' ) );
#$status->checkRequired ( $this, 'subpartner_id[]', t ( 'Sub Partner' ) );
$params['funding_end_date'] = $this->_array_me($params['funding_end_date']);
foreach ($params['funding_end_date'] as $i => $value) {
$params['funding_end_date'][$i] = $this->_date_to_sql($value);
}
$params['transition_confirmed'] = $params['transition_confirmed'] == 'on' ? 1 : 0;
$params['agreement_end_date'] = $this->_date_to_sql($params['agreement_end_date']);
$params['subpartner_id'] = $this->_array_me($params['subpartner_id']);
foreach ($params['subpartner_id'] as $i => $value) {
// strip empty values (it breaks MultiOptionList apparently)
if (empty($value)) {
unset($params['subpartner_id'][$i]);
}
}
//location save stuff
$params['location_id'] = regionFiltersGetLastID(null, $params);
// formprefix, criteria
if ($params['city']) {
$params['location_id'] = Location::insertIfNotFound($params['city'], $params['location_id'], $this->setting('num_location_tiers'));
}
if (!$status->hasError()) {
$id = $this->_findOrCreateSaveGeneric('partner', $params);
if (!$id) {
$status->setStatusMessage(t('That partner could not be saved.'));
} else {
MultiOptionList::updateOptions('partner_to_funder', 'partner_funder_option', 'partner_id', $id, 'partner_funder_option_id', $params['partner_funder_option_id'], 'funder_end_date', $params['funding_end_date']);
$db->query("DELETE FROM partner_to_subpartner WHERE partner_id = {$id}");
// updateOptions is not clearing the old options, I dont know why... todo
MultiOptionList::updateOptions('partner_to_subpartner', 'partner', 'partner_id', $id, 'subpartner_id', $params['subpartner_id']);
$status->setStatusMessage(t('The partner was saved.'));
$this->_redirect("partner/edit/id/{$id}");
}
}
}
if ($id) {
// read data from db
#// restricted access?? only show partners by organizers that we have the ACL to view
#$org_allowed_ids = allowed_org_access_full_list($this); // doesnt have acl 'training_organizer_option_all'
#$orgWhere = ($org_allowed_ids) ? " AND partner.organizer_option_id in ($org_allowed_ids) " : "";
#// restricted access?? only show organizers that belong to this site if its a multi org site
#$site_orgs = allowed_organizer_in_this_site($this); // for sites to host multiple training organizers on one domain
#$allowedWhereClause .= $site_orgs ? " AND partner.organizer_option_id in ($site_orgs) " : "";
// continue reading data
$sql = 'SELECT * FROM partner WHERE id = ' . $id . space . $orgWhere;
$row = $db->fetchRow($sql);
if (!$row) {
$status->setStatusMessage(t('Error finding that record in the database.'));
} else {
$params = $row;
// reassign form data
$region_ids = Location::getCityInfo($params['location_id'], $this->setting('num_location_tiers'));
$params['city'] = $region_ids[0];
$region_ids = Location::regionsToHash($region_ids);
$params = array_merge($params, $region_ids);
//get linked table data from option tables
$sql = "SELECT partner_funder_option_id,funder_end_date FROM partner_to_funder WHERE partner_id = {$id}";
$params['funder'] = $db->fetchAll($sql);
$sql = "SELECT subpartner_id FROM partner_to_subpartner WHERE partner_id = {$id}";
$params['subpartners'] = $db->fetchCol($sql);
}
}
// make sure form data is valid for display
if (empty($params['funder'])) {
$params['funder'] = array(array());
}
if (empty($params['subpartners'])) {
$params['subpartners'] = array(' ');
}
// assign form drop downs
$this->view->assign('status', $status);
$this->view->assign('pageTitle', $this->view->mode == 'add' ? t('Add Partner') : t('View Partner'));
$this->viewAssignEscaped('partner', $params);
$this->viewAssignEscaped('locations', Location::getAll());
$this->view->assign('partners', DropDown::generateHtml('partner', 'partner', $params['partner_type_option_id'], false, $this->view->viewonly, false));
//table, col, selected_value
$this->view->assign('subpartners', DropDown::generateHtml('partner', 'partner', 0, false, $this->view->viewonly, false, true, array('name' => 'subpartner_id[]'), true));
$this->view->assign('types', DropDown::generateHtml('partner_type_option', 'type_phrase', $params['partner_type_option_id'], false, $this->view->viewonly, false));
$this->view->assign('importance', DropDown::generateHtml('partner_importance_option', 'importance_phrase', $params['partner_importance_option_id'], false, $this->view->viewonly, false));
$this->view->assign('transitions', DropDown::generateHtml('employee_transition_option', 'transition_phrase', $params['employee_transition_option_id'], false, $this->view->viewonly, false));
$this->view->assign('incomingPartners', DropDown::generateHtml('partner', 'partner', $params['incoming_partner'], false, $this->view->viewonly, false, true, array('name' => 'incoming_partner'), true));
$this->view->assign('organizers', DropDown::generateHtml('training_organizer_option', 'training_organizer_phrase', $params['organizer_option_id'], false, $this->view->viewonly, false, true, array('name' => 'organizer_option_id'), true));
$helper = new Helper();
$this->viewAssignEscaped('facilities', $helper->getFacilities());
}
public function partnersAction()
{
require_once 'models/table/Helper.php';
require_once 'views/helpers/FormHelper.php';
require_once 'views/helpers/DropDown.php';
require_once 'views/helpers/Location.php';
require_once 'views/helpers/CheckBoxes.php';
require_once 'views/helpers/TrainingViewHelper.php';
$criteria = $this->getAllParams();
if ($criteria['go']) {
$where = array();
$criteria['last_selected_rgn'] = regionFiltersGetLastID('', $criteria);
list($a, $location_tier, $location_id) = $this->getLocationCriteriaValues($criteria);
list($locationFlds, $locationsubquery) = Location::subquery($this->setting('num_location_tiers'), $location_tier, $location_id);
$sql = "SELECT\r\n\t\t\t\t\tpartner.*,\r\n\t\t\t\t\tpartner.id,partner.partner,partner.location_id," . implode(',', $locationFlds) . "\r\n\t\t\t\t\t,GROUP_CONCAT(distinct facility.facility_name) as facilities\r\n\t\t\t\t\t,CASE WHEN annual_cost REGEXP '[^!0-9,\\.][0-9\\.,]+' THEN SUBSTRING(annual_cost, 2) ELSE annual_cost END AS 'annual_cost_to_compare'\r\n\t\t\t\t\t,COUNT(e.id) AS pcnt\r\n\t\t\t\t\tFROM partner LEFT JOIN ({$locationsubquery}) as l ON l.id = partner.location_id\r\n\t\t\t\t\tLEFT JOIN partner_to_funder funders ON partner.id = funders.partner_id\r\n\t\t\t\t\tLEFT JOIN partner_funder_option funderopt ON funders.partner_funder_option_id = funderopt.id\r\n\t\t\t\t\tLEFT JOIN partner_to_subpartner subpartners ON subpartners.partner_id = partner.id\r\n\t\t\t\t\tLEFT JOIN employee e on e.partner_id = partner.id\r\n\t\t\t\t\tLEFT JOIN facility ON e.site_id = facility.id\r\n\t\t\t\t\t";
if ($criteria['facility_type_option_id']) {
$sql .= " LEFT JOIN facility_type_option fto ON fto.id = facility.type_option_id ";
}
// restricted access?? only show partners by organizers that we have the ACL to view
#$org_allowed_ids = allowed_org_access_full_list($this); // doesnt have acl 'training_organizer_option_all'
#if ($org_allowed_ids) $where[] = "partner.organizer_option_id in ($org_allowed_ids)";
// restricted access?? only show organizers that belong to this site if its a multi org site
$site_orgs = allowed_organizer_in_this_site($this);
// for sites to host multiple training organizers on one domain
if ($site_orgs) {
$where[] = "partner.organizer_option_id in ({$site_orgs})";
}
// criteria
if ($criteria['partner_id']) {
$where[] = 'partner.id = ' . $criteria['partner_id'];
}
if ($criteria['last_selected_rgn']) {
$where[] = 'province_name is not null';
}
// bugfix - location subquery is not working like a inner join or where, not sure why
if ($criteria['facilityInput']) {
$where[] = 'facility.id = ' . $criteria['facilityInput'];
}
if ($criteria['facility_type_option_id']) {
$where[] = 'facility.type_option_id = ' . $criteria['facility_type_option_id'];
}
if ($criteria['employee_qualification_option_id']) {
$where[] = 'employee_qualification_option_id = ' . $criteria['employee_qualification_option_id'];
}
if ($criteria['employee_category_option_id']) {
$where[] = 'employee_category_option_id = ' . $criteria['employee_category_option_id'];
}
if ($criteria['hours_min']) {
$where[] = 'e.funded_hours_per_week >=' . $criteria['hours_min'];
}
if ($criteria['hours_max']) {
$where[] = 'e.funded_hours_per_week <=' . $criteria['hours_min'];
}
if ($criteria['cost_min']) {
$where[] = 'e.annual_cost_to_compare >=' . $criteria['cost_min'];
}
if ($criteria['cost_max']) {
$where[] = 'e.annual_cost_to_compare <=' . $criteria['cost_max'];
}
if ($criteria['employee_role_option_id']) {
$where[] = 'funder_end_date >= \'' . $this->_date_to_sql($criteria['start_date']) . ' 00:00:00\'';
}
if ($criteria['partner_importance_option_id']) {
$where[] = 'partner_importance_option_id = ' . $criteria['partner_importance_option_id'];
}
if ($criteria['start_date']) {
$where[] = 'funder_end_date >= \'' . $this->_date_to_sql($criteria['start_date']) . ' 00:00:00\'';
}
if ($criteria['end_date']) {
$where[] = 'funder_end_date <= \'' . $this->_date_to_sql($criteria['end_date']) . ' 23:59:59\'';
}
if ($criteria['employee_transition_option_id']) {
$where[] = 'employee_transition_option_id = ' . $criteria['employee_transition_option_id'];
}
if ($criteria['transition_confirmed']) {
$where[] = 'transition_confirmed = 1';
}
if (count($where)) {
$sql .= ' WHERE ' . implode(' AND ', $where);
}
$sql .= ' GROUP BY partner.id ';
$db = $this->dbfunc();
$rowArray = $db->fetchAll($sql);
$this->viewAssignEscaped('results', $rowArray);
$this->view->assign('count', count($rowArray));
if ($criteria['outputType']) {
$this->sendData($this->reportHeaders(false, $rowArray));
}
}
// assign form drop downs
$this->view->assign('status', $status);
$this->view->assign('criteria', $criteria);
$this->view->assign('pageTitle', t('Reports'));
$this->viewAssignEscaped('locations', Location::getAll());
$this->view->assign('partners', DropDown::generateHtml('partner', 'partner', $criteria['partner_id'], false, $this->view->viewonly, false));
//table, col, selected_value
$this->view->assign('subpartners', DropDown::generateHtml('partner', 'partner', $criteria['subpartner_id'], false, $this->view->viewonly, false, true, array('name' => 'subpartner_id'), true));
$this->view->assign('importance', DropDown::generateHtml('partner_importance_option', 'importance_phrase', $criteria['partner_importance_option_id'], false, $this->view->viewonly, false));
$this->view->assign('transitions', DropDown::generateHtml('employee_transition_option', 'transition_phrase', $criteria['employee_transition_option_id'], false, $this->view->viewonly, false));
$this->view->assign('incomingPartners', DropDown::generateHtml('partner', 'partner', $criteria['incoming_partner'], false, $this->view->viewonly, false, true, array('name' => 'incoming_partner'), true));
$helper = new Helper();
$this->viewAssignEscaped('facilities', $helper->getFacilities());
$this->view->assign('facilitytypes', DropDown::generateHtml('facility_type_option', 'facility_type_phrase', $criteria['facility_type_option_id'], false, $this->view->viewonly, false));
$this->view->assign('cadres', DropDown::qualificationsDropDown('employee_qualification_option_id', $criteria['employee_qualification_option_id']));
$this->view->assign('categories', DropDown::generateHtml('employee_category_option', 'category_phrase', $criteria['employee_category_option_id'], false, $this->view->viewonly, false));
$this->view->assign('roles', DropDown::generateHtml('employee_role_option', 'role_phrase', $criteria['employee_role_option_id'], false, $this->view->viewonly, false));
$this->view->assign('transitions', DropDown::generateHtml('employee_transition_option', 'transition_phrase', $criteria['employee_transition_option_id'], false, $this->view->viewonly, false));
}
public function doAddEditView()
{
try {
//validate
$status = ValidationContainer::instance();
require_once 'models/table/OptionList.php';
require_once 'models/table/MultiOptionList.php';
require_once 'models/table/Location.php';
$request = $this->getRequest();
$validateOnly = $request->isXmlHttpRequest();
$person_id = $this->getSanParam('id');
$personObj = new Person();
$personrow = $personObj->findOrCreate($person_id);
$personArray = $personrow->toArray();
$helper = new Helper();
$ssl = $helper->getSkillSmartLookups();
$this->view->assign('skillsmart', $ssl);
// nationality dropdown data
$this->view->assign('lookupnationalities', $helper->getNationalities());
$train = $helper->getPersonTraining($person_id);
$this->view->assign('persontraining', $train);
//locations
$locations = Location::getAll();
$this->viewAssignEscaped('locations', $locations);
if ($validateOnly) {
$this->setNoRenderer();
}
// Figure out reason code "Other" for checking posted data,
// and for enabling/disabling reason_other field
$other_reason_option_id = -1;
$db = Zend_Db_Table_Abstract::getDefaultAdapter();
$sql = "SELECT * FROM person_attend_reason_option where LCASE(attend_reason_phrase) LIKE '%other%'";
$rowArray = $db->fetchAll($sql);
if ($rowArray) {
$other_reason_option_id = $rowArray[0]['id'];
}
$this->viewAssignEscaped('other_reason_option_id', $other_reason_option_id);
if ($request->isPost()) {
$errortext = "";
if ($dupe_id = $this->getSanParam('dupe_id')) {
if ($this->getSanParam('maketrainer')) {
// require user to add trainer info
$status->setRedirect('/person/edit/id/' . $dupe_id . '/trainingredirect/' . $this->getSanParam('trainingredirect') . '/maketrainer/1');
} else {
if ($this->_getParam('trainingredirect')) {
$status->setStatusMessage(t('The person was saved. Refreshing history...'));
$_SESSION['status'] = t('The person was saved.');
$this->trainingRedirect($dupe_id);
} else {
$status->setRedirect('/person/edit/id/' . $dupe_id);
}
}
return;
}
$status->checkRequired($this, 'first_name', $this->tr('First Name'));
$status->checkRequired($this, 'last_name', $this->tr('Last Name'));
$status->checkRequired($this, 'primary_qualification_option_id', t('Professional qualification'));
if ($this->setting('display_gender') != '0') {
$status->checkRequired($this, 'gender', t('Gender'));
}
if ($this->setting('display_mod_skillsmart')) {
//$status->checkRequired ( $this, 'occupational_category_id', t ( 'Occupational category' ) );
if ($this->getSanParam('govemp_option_id')) {
//$status->checkRequired ( $this, 'govemp_option_id', t ( 'Government Employee' ) );
//$status->checkRequired ( $this, 'occupational_category_id', t ( 'Occupational category' ) );
$status->checkRequired($this, 'persal_number', t('Persal Number'));
}
} else {
$status->checkRequired($this, 'primary_qualification_option_id', t('Professional qualification'));
}
$birthParam = @$this->getSanParam('birth-year') . '-' . @$this->getSanParam('birth-month') . '-' . @$this->getSanParam('birth-day');
if ($birthParam !== '--' and $birthParam !== '0000-00-00') {
$status->isValidDate($this, 'birth-day', t('Birthdate'), $birthParam);
}
//trainer only
if ($this->getSanParam('is_trainer') || $this->getSanParam('active_trainer_option_id') || $this->getSanParam('trainer_type_option_id')) {
$status->checkRequired($this, 'trainer_type_option_id', t('Trainer') . ' ' . t('type'));
// 10/02/2011 Sean Smith: Removed at client request.
//if ($this->setting ( 'display_trainer_affiliations' )) {
// $status->checkRequired ( $this, 'trainer_affiliation_option_id', t ( 'Trainer').' '.t('affiliation' ) );
//}
//at least one skill
$status->checkRequired($this, 'trainer_skill_id', t('Trainer') . ' ' . t('skill'));
}
// Check for manual reason for attending entry (if pulldown reason is 'other')
if ($this->setting('display_attend_reason')) {
//if ($status->checkRequired ( $this, 'attend_reason_option_id', t ( 'Reason For Attending' ))) {
$reason_id = $this->getSanParam('attend_reason_option_id');
$other_reason = $this->getSanParam('attend_reason_other');
if (($reason_id || $reason_id == 0) && $other_reason_option_id >= 0) {
if ($reason_id == $other_reason_option_id) {
if ($other_reason == "") {
$status->addError('attend_reason_other', t('Enter a reason, or select a different reason above.'));
$errortext .= "Enter a reason, or select a different reason above.<br>";
error_log("Enter a reason, or select a different reason above.");
}
} else {
if ($other_reason != "") {
$status->addError('attend_reason_other', t('You can not type in a reason with the reason selected above.'));
$errortext .= "You can not type in a reason with the reason selected above.<br>";
error_log("You can not type in a reason with the reason selected above.");
}
}
}
//}
}
//check facility
if ($status->checkRequired($this, 'facilityInput', t('Facility'))) {
$facility_id = $this->getSanParam('facilityInput');
if (is_array($facility_id)) {
$fac_arr = array();
foreach ($facility_id as $fac_id) {
if ($strrpos = strrpos($fac_id, '_')) {
$fac_arr[] = substr($fac_id, $strrpos + 1);
}
}
$personrow->multi_facility_ids = json_encode($fac_arr);
$facility_id = current($facility_id);
} else {
$personrow->multi_facility_ids = '';
}
if ($strrpos = strrpos($facility_id, '_')) {
$facility_id = array_pop(explode('_', $facility_id));
}
//find by name
if ($facility_id) {
$facilityByName = new Facility();
$row = $facilityByName->fetchRow('id = ' . $facility_id);
//$row = $facilityByName->fetchRow($facilityByName->select()->where('facility_name = ?', $this->getSanParam('facilityInput')));
}
if (@$row->id) {
$personrow->facility_id = $row->id;
} else {
$status->addError('facilityInput', t('That facility name could not be found.'));
$errortext .= "That facility name could not be found.<br>";
error_log("That facility name could not be found.");
}
}
//get home city name
$city_id = false;
$criteria = $this->_getAllParams();
require_once 'views/helpers/Location.php';
$home_city_parent_id = regionFiltersGetLastID('home', $criteria);
if ($criteria['home_city'] && !$criteria['is_new_home_city']) {
$city_id = Location::verifyHierarchy($criteria['home_city'], $home_city_parent_id, $this->setting('num_location_tiers'));
if ($city_id === false) {
$status->addError('home_city', t("That city does not appear to be located in the chosen region. If you want to create a new city, check the new city box."));
$errortext .= "That city does not appear to be located in the chosen region. If you want to create a new city, check the new city box.<br>";
error_log("That city does not appear to be located in the chosen region. If you want to create a new city, check the new city box.");
}
}
if ($status->hasError()) {
foreach ($status->messages as $k => $v) {
$errortext .= $v . "<br>";
}
$status->setStatusMessage(t('The person could not be saved. <br>' . $errortext));
} else {
$personrow = self::fillFromArray($personrow, $this->_getAllParams());
if ($city_id === false && $this->getSanParam('is_new_home_city')) {
$city_id = Location::insertIfNotFound($criteria['home_city'], $home_city_parent_id, $this->setting('num_location_tiers'));
if ($city_id === false) {
$status->addError('home_city', t('Could not save that city.'));
}
}
if ($city_id) {
$personrow->home_location_id = $city_id;
} else {
$home_location_id = Location::verifyHierarchy($criteria['home_city'], $home_city_parent_id, $this->setting('num_location_tiers'));
if ($home_location_id) {
$personrow->home_location_id = $home_location_id;
}
}
//these are transitionary database fields, will go away soon
// $personrow->home_district_id = null;
// $personrow->home_province_id = null;
if (!$personrow->home_city) {
$personrow->home_city = '';
}
// bugfix, field cannot be null.
if ($this->getSanParam('active')) {
$personrow->active = 'active';
} else {
$personrow->active = 'inactive';
}
$personrow->birthdate = @$this->getSanParam('birth-year') . '-' . @$this->getSanParam('birth-month') . '-' . @$this->getSanParam('birth-day');
//lookup custom 1 and 2
if ($this->getSanParam('custom1Input')) {
$id = OptionList::insertIfNotFound('person_custom_1_option', 'custom1_phrase', $this->getSanParam('custom1Input'));
$personrow->person_custom_1_option_id = $id;
} else {
$personrow->person_custom_1_option_id = null;
}
if ($this->getSanParam('custom2Input')) {
$id = OptionList::insertIfNotFound('person_custom_2_option', 'custom2_phrase', $this->getSanParam('custom2Input'));
$personrow->person_custom_2_option_id = $id;
} else {
$personrow->person_custom_2_option_id = null;
}
if ($this->setting('display_mod_skillsmart')) {
$personrow->govemp_option_id = $this->getSanParam('govemp_option_id');
$personrow->occupational_category_id = $this->getSanParam('occupational_category_id');
$personrow->persal_number = $this->getSanParam('persal_number');
$personrow->bodies_id = $this->getSanParam('professionalbodies_id');
$personrow->race_option_id = $this->getSanParam('race_option_id');
$personrow->disability_option_id = $this->getSanParam('disability_option_id');
$personrow->professional_reg_number = $this->getSanParam('professional_reg_number');
$personrow->nationality_id = $this->getSanParam('nationality_id');
$personrow->nurse_training_id = $this->getSanParam('nurse_training_id');
$personrow->care_start_year = $this->getSanParam('care_start_year');
$personrow->timespent_rank_pregnant = $this->getSanParam('timespent_rank_pregnant');
$personrow->timespent_rank_adults = $this->getSanParam('timespent_rank_adults');
$personrow->timespent_rank_children = $this->getSanParam('timespent_rank_children');
$personrow->timespent_rank_pregnant_pct = $this->getSanParam('timespent_rank_pregnant_pct');
$personrow->timespent_rank_adults_pct = $this->getSanParam('timespent_rank_adults_pct');
$personrow->timespent_rank_children_pct = $this->getSanParam('timespent_rank_children_pct');
$personrow->supervised_id = $this->getSanParam('supervised_id');
$personrow->supervision_frequency_id = $this->getSanParam('supervision_frequency_id');
$personrow->supervisors_profession = $this->getSanParam('supervisors_profession');
$personrow->facilitydepartment_id = $this->getSanParam('facilitydepartment_id');
$training_recieved_arr = array();
$training_recieved_data = '';
$training_recieved_results = array();
foreach ($ssl['training'] as $trainingnode) {
$training_recieved_arr[$trainingnode['id']] = $trainingnode['label'];
}
// build and insert training recieved vars in json
foreach ($_POST as $postvar => $postval) {
if (strstr($postvar, 'trainingrecieved_') && (isset($_POST[$postvar]) && $_POST[$postvar] != '')) {
$recv_str = '';
$recv_num = explode('_', $postvar);
if (isset($training_recieved_arr[intval($recv_num[1])])) {
$recv_str = $training_recieved_arr[intval($recv_num[1])];
$training_recieved_results[$recv_str][$recv_num[2]] = $postval;
}
}
}
if (!empty($training_recieved_results)) {
$training_recieved_data = json_encode($training_recieved_results);
}
$personrow->training_recieved_data = $training_recieved_data;
//$personrow->comments_skillsmart = $this->getSanParam('govemp_option_id');//0
/*
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('custom1Input');//1
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('race_option_id');//2
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('disability_option_id');//3
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('disability');//4
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('custom2Input');//5
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('rank1_option_id');//6
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('rank2_option_id');//7
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('rank3_option_id');//8
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('percent1');//9
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('percent2');//10
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('percent3');//11
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('supervised_option_id');//12
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('sfreq_option_id');//13
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('specifyfreqinput');//14
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('svoccu');//15
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother');//16
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother');//17
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother');//18
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother');//19
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('specifyoccupationinput');//20
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('trainer_type_option_id1');//21
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother0');//22
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother0');//23
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother0');//24
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother0');//25
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother1');//26
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother1');//27
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother1');//28
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother1');//29
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother2');//30
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother2');//31
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother2');//32
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother2');//33
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother3');//34
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother3');//35
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother3');//36
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother3');//37
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother4');//38
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother4');//39
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother4');//40
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother4');//41
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother5');//42
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother5');//43
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother5');//44
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother5');//45
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother6');//46
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother6');//47
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother6');//48
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother6');//49
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother7');//50
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother7');//51
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother7');//52
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother7');//53
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainother8');//54
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('checktrainother8');//55
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('selecttrainother8');//56
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('texttrainotherother8');//57
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('bodies_id');//58
$personrow->comments_skillsmart = $personrow->comments_skillsmart."§".$this->getSanParam('nationality_id');//59
*/
if ($person_id) {
$trainsaved = array();
$train = $this->getSanParam('train');
foreach ($train as $key => $t) {
if (isset($t['check'])) {
if ($t['originalid'] != 0) {
// UPDATING EXISTING // moving this - cant really use $person_id before $personrow->save on adding a new user... probably should happen later or only on edits... im not sure
$trainid = $t['originalid'];
$query = "UPDATE link_person_training SET\n\t\t\t\t\t\t\t\t\tpersonid = '" . $person_id . "',\n\t\t\t\t\t\t\t\t\tyear = '" . addslashes($t['year']) . "',\n\t\t\t\t\t\t\t\t\tinstitution = '" . addslashes($t['text']) . "',\n\t\t\t\t\t\t\t\t\tothername = '' WHERE id = " . $trainid;
error_log($query);
$db->query($query);
} else {
// ADDING NEW
$query = "INSERT INTO link_person_training SET\n\t\t\t\t\t\t\t\t\t\t\tpersonid = '" . $person_id . "',\n\t\t\t\t\t\t\t\t\t\t\ttrainingid = '" . addslashes($key) . "',\n\t\t\t\t\t\t\t\t\t\t\tyear = '" . addslashes($t['year']) . "',\n\t\t\t\t\t\t\t\t\t\t\tinstitution = '" . addslashes($t['text']) . "',\n\t\t\t\t\t\t\t\t\t\t\tothername = ''";
error_log($query);
$db->query($query);
$trainid = $db->lastInsertId();
}
$trainsaved[] = $trainid;
}
}
if (count($trainsaved) > 0) {
// REMOVE ALL NON-SAVED TRAINING IDS FOR PERSON
$query = "DELETE FROM link_person_training WHERE personid = " . $person_id . " AND id NOT IN (" . implode(",", $trainsaved) . ")";
error_log($query);
$db->query($query);
} else {
// REMOVE ALL TRAINING IDS FOR PERSON
$query = "DELETE FROM link_person_training WHERE personid = " . $person_id;
error_log($query);
$db->query($query);
}
}
}
if ($personrow->save()) {
$status->setStatusMessage(t('The person was saved. Refreshing change history...'));
$_SESSION['status'] = t('The person was saved.');
$person_id = $personrow->id;
if ($this->setting('display_mod_skillsmart')) {
if (strlen($this->getSanParam('Facilities')) > 0) {
$db->query('UPDATE `facs` SET `Active`=\'N\' WHERE `person`=' . $person_id . ' AND `Active`=\'Y\';');
$Facs = split('\\$', $this->getSanParam('Facilities'));
foreach ($Facs as $kys => $vls) {
$Locs = split("~", $vls);
$Fac = $Locs[0];
if ($strrpos = strrpos($Fac, '_')) {
$Fac = substr($Fac, $strrpos + 1);
}
$db->query('INSERT INTO `facs` ( `person`, `facility`, `facstring`, `active`) VALUES (' . $person_id . ', ' . $Fac . ', \'' . $vls . '\', \'Y\');');
}
}
$co = 0;
for ($co = 1; $co <= 20; $co++) {
$db->query('UPDATE `trans` SET `Active`=\'N\' WHERE `person`=' . $person_id . ' AND `id`=' . $co . ' AND `Active`=\'Y\';');
if ($this->getSanParam('checktrain' . $co) == 'on') {
$db->query('INSERT INTO `trans` ( `person`, `id`, `chk`, `yr`, `transstring`, `active`) VALUES (' . $person_id . ', ' . $co . ', \'' . $this->getSanParam('checktrain' . $co) . '\', \'' . $this->getSanParam('selecttrain' . $co) . '\', \'' . $this->getSanParam('texttrain' . $co) . '\', \'Y\');');
}
}
}
//get trainer information
$trainerTable = new Trainer();
$trainerRow = $trainerTable->fetchRow('person_id = ' . $person_id);
if (!$trainerRow and ($this->getSanParam('active_trainer_option_id') or $this->getSanParam('trainer_type_option_id'))) {
// add trainer
$trainerRow = $trainerTable->createRow();
$trainerRow->person_id = $personrow->id;
}
if ($trainerRow) {
//trainer info
$trainerRow->is_active = 1;
//deprecated //($this->getSanParam ( 'is_trainer' ) ? 1 : 0);
$trainerRow->active_trainer_option_id = $this->getSanParam('active_trainer_option_id');
$trainerRow->type_option_id = $this->getSanParam('trainer_type_option_id');
$trainerRow->affiliation_option_id = $this->setting('display_trainer_affiliations') ? $this->getSanParam('trainer_affiliation_option_id') ? $this->getSanParam('trainer_affiliation_option_id') : 0 : 0;
if (!$trainerRow->save()) {
$status->setStatusMessage(t('The') . ' ' . t('trainer') . ' ' . t('information could not be saved.'));
} else {
MultiOptionList::updateOptions('trainer_to_trainer_skill_option', 'trainer_skill_option', 'trainer_id', $person_id, 'trainer_skill_option_id', $this->getSanParam('trainer_skill_id'));
$language_ids = $this->getSanParam('trainer_language_id');
$planguage_id = $this->getSanParam('primary_language_id');
$primary_settings = array();
$found = false;
if ($language_ids) {
foreach ($language_ids as $lid) {
if ($lid == $planguage_id) {
$primary_settings[] = 1;
$found = true;
} else {
$primary_settings[] = 0;
}
}
}
if (!$found) {
$primary_settings[] = 1;
$language_ids[] = $planguage_id;
}
MultiOptionList::updateOptions('trainer_to_trainer_language_option', 'trainer_language_option', 'trainer_id', $person_id, 'trainer_language_option_id', $language_ids, 'is_primary', $primary_settings);
}
}
TrainingRecommend::saveRecommendedforPerson($person_id, $this->getSanParam('training_recommend'));
if ($this->_getParam('redirectUrl')) {
$status->redirect = $this->_getParam('redirectUrl');
} else {
if ($this->_getParam('trainingredirect')) {
// redirect back to training session
$this->trainingRedirect($person_id);
} else {
//if it's an add then redirect to the view page
if ($this->setting('display_mod_skillsmart')) {
//$status->setRedirect ( '/person/view/id/' . $person_id );
$qs = OptionList::suggestionListHierarchical('person_qualification_option', 'qualification_phrase', false, false, array('0 AS is_default', 'child.is_default'));
$parent_id = $this->getSanParam('primary_qualification_option_id');
foreach ($qs as $k => $v) {
if ($v['id'] == $parent_id) {
$parent_id = $v['parent_id'];
break;
}
}
$comps = $helper->getPersonCompetenciesDetailed($person_id);
// Disabled redirect to competency page as per Robert's request, 11/19/2012, CDL
// if (count($comps) > 0){
// $status->setRedirect ( '/person/editcompetency/id/' . $person_id );
// } else {
$status->setRedirect('/person/edit/id/' . $person_id);
// }
/*
if($parent_id=="6")
{
$status->setRedirect ( '/person/addcomc/id/' . $person_id );
}
if($parent_id=="7")
{
$status->setRedirect ( '/person/addcomd/id/' . $person_id );
}
if($parent_id=="8")
{
$status->setRedirect ( '/person/addcomn/id/' . $person_id );
}
if($parent_id=="9")
{
$status->setRedirect ( '/person/addcomp/id/' . $person_id );
}
*/
} else {
$status->setRedirect('/person/edit/id/' . $person_id);
}
}
}
} else {
$status->setStatusMessage(t('ERROR: The person could not be saved. ' . __LINE__));
}
}
if ($validateOnly) {
$this->sendData($status);
} else {
$this->view->assign('status', $status);
}
}
if ($this->setting('display_mod_skillsmart')) {
if ($person_id) {
$rows = $db->fetchAll('SELECT `facstring` FROM `facs` INNER JOIN `facility` ON `facs`.`facility` = `facility`.`id` WHERE `facility`.`is_deleted`=0 AND `facs`.`person`=' . $person_id . ' AND `facs`.`Active`=\'Y\' ORDER BY `facs`.`sno` ASC;');
$Fcs = "";
foreach ($rows as $rw) {
$Fcs = $Fcs . $rw['facstring'] . '$';
}
$Fcs = trim($Fcs, '$');
$this->view->assign('Fcs', $Fcs);
$rows = $db->fetchAll('SELECT `id`, `chk`, `yr`, `transstring` FROM `trans` WHERE `person`=' . $person_id . ' AND `Active`=\'Y\' ORDER BY sno ASC;');
$Trs = array();
$c*k = 0;
for ($c*k = 1; $c*k <= 20; $c*k++) {
$Trs[$c*k] = NULL;
}
foreach ($rows as $rw) {
$Trs[$rw['id']] = $rw;
}
$this->view->assign('Trs', $Trs);
}
}
//view it
$facilityObj = new Facility();
$facilityrow = $facilityObj->findOrCreate($personrow->facility_id);
$personArray['facility'] = $facilityrow->toArray();
//facility location
$region_ids = Location::getCityInfo($facilityrow->location_id, $this->setting('num_location_tiers'));
$region_ids = Location::regionsToHash($region_ids, 'person_facility');
$personArray = array_merge($personArray, $region_ids);
//audit history
$creatorObj = new User();
$updaterObj = new User();
$creatorrow = $creatorObj->findOrCreate($personrow->created_by);
$personArray['creator'] = addslashes($creatorrow->first_name . ' ' . $creatorrow->last_name);
$updaterrow = $updaterObj->findOrCreate($personrow->modified_by);
$personArray['updater'] = addslashes($updaterrow->first_name . ' ' . $updaterrow->last_name);
$personArray['birthdate-year'] = '';
$personArray['birthdate-month'] = '';
$personArray['birthdate-day'] = '';
//split birthdate fields
if ($person_id and $personrow->birthdate) {
$parts = explode(' ', $personrow->birthdate);
$parts = explode('-', $parts[0]);
$personArray['birthdate-year'] = $parts[0];
$personArray['birthdate-month'] = $parts[1];
$personArray['birthdate-day'] = $parts[2];
}
//custom fields
if ($person_id) {
$personArray['custom1'] = ITechTable::getCustomValue('person_custom_1_option', 'custom1_phrase', $personArray['person_custom_1_option_id']);
$personArray['custom2'] = ITechTable::getCustomValue('person_custom_2_option', 'custom2_phrase', $personArray['person_custom_2_option_id']);
}
//qualifications
$qualificationsArray = OptionList::suggestionListHierarchical('person_qualification_option', 'qualification_phrase', false, false, array('0 AS is_default', 'child.is_default'));
$personQualificationId = $personArray['primary_qualification_option_id'];
// get parent qualification id, if user has sub qualification selected
$personArray['primary_qualification_option_id_parent'] = $personQualificationId;
foreach ($qualificationsArray as $k => $qualArray) {
if ($qualArray['parent_phrase'] == 'unknown') {
unset($qualificationsArray[$k]);
//remove unknown as an option
}
if ($qualArray['id'] == $personQualificationId) {
$personArray['primary_qualification_option_id_parent'] = $qualArray['parent_id'];
}
}
$this->viewAssignEscaped('qualifications', $qualificationsArray);
// occupational categories
$occupationalsArray = OptionList::suggestionListHierarchical('occupational_categories', 'category_phrase', false, false, array('0 AS is_default', 'child.is_default'));
$personQualificationId = $personArray['primary_qualification_option_id'];
// get parent occupational category id, if user has sub qualification selected
$personArray['occupational_category_id_parent'] = $personQualificationId;
foreach ($occupationalsArray as $k => $catArray) {
if ($catArray['category_phrase'] == 'unknown') {
unset($qualificationsArray[$k]);
//remove unknown as an option
}
if ($catArray['id'] == $personQualificationId) {
$personArray['occupational_category_id'] = $catArray['parent_id'];
}
}
$this->viewAssignEscaped('occupationalcats', $occupationalsArray);
// get recommended trainings class topics
$training_recommend = TrainingRecommend::getRecommendedTrainingTopics($personArray['primary_qualification_option_id_parent']);
$this->viewAssignEscaped('training_recommend', $training_recommend);
// get saved recommended trainings class titles
$training_recommend_saved = TrainingRecommend::getRecommendedforPerson($person_id);
$this->viewAssignEscaped('training_recommend_saved', $training_recommend_saved);
//$classes = TrainingRecommend::getRecommendedClassesforPerson ( $person_id );
//responsibilities
if ($this->setting('display_mod_skillsmart')) {
$responsibilitiesArray = OptionList::suggestionList('person_responsibility_option', 'responsibility_phrase', false, false);
$this->viewAssignEscaped('responsibilities', $responsibilitiesArray);
}
$primaryResponsibilitiesArray = OptionList::suggestionList('person_primary_responsibility_option', 'responsibility_phrase', false, false);
$this->viewAssignEscaped('primaryResponsibilities', $primaryResponsibilitiesArray);
$secondaryResponsibilitiesArray = OptionList::suggestionList('person_secondary_responsibility_option', 'responsibility_phrase', false, false);
$this->viewAssignEscaped('secondaryResponsibilities', $secondaryResponsibilitiesArray);
$educationlevelsArray = OptionList::suggestionList('person_education_level_option', 'education_level_phrase', false, false);
$this->viewAssignEscaped('educationlevels', $educationlevelsArray);
$attendreasonsArray = OptionList::suggestionList('person_attend_reason_option', 'attend_reason_phrase', false, false);
$this->viewAssignEscaped('attendreasons', $attendreasonsArray);
$activeTrainerArray = OptionList::suggestionList('person_active_trainer_option', 'active_trainer_phrase', false, false);
$this->viewAssignEscaped('active_trainer', $activeTrainerArray);
$titlesArray = OptionList::suggestionList('person_title_option', 'title_phrase', false, false);
$this->viewAssignEscaped('titles', $titlesArray);
$suffixesArray = OptionList::suggestionList('person_suffix_option', 'suffix_phrase', false, false);
$this->viewAssignEscaped('suffixes', $suffixesArray);
//training types
//attach Trainer attributes
$trainerTable = new Trainer();
$trainerrow = $trainerTable->findOrCreate($person_id);
$personArray['trainer_is_active'] = $this->getSanParam('maketrainer') ? 1 : $trainerrow->is_active;
$personArray['active_trainer_option_id'] = $trainerrow->active_trainer_option_id;
$personArray['trainer_type_option_id'] = $trainerrow->type_option_id;
$personArray['trainer_affiliation_option_id'] = $trainerrow->affiliation_option_id;
$titlesArray = OptionList::suggestionList('person_title_option', 'title_phrase', false, false);
$this->viewAssignEscaped('titles', $titlesArray);
$trainerTypesArray = OptionList::suggestionList('trainer_type_option', 'trainer_type_phrase', false, false);
$this->viewAssignEscaped('trainer_types', $trainerTypesArray);
$trainerAffiliationArray = OptionList::suggestionList('trainer_affiliation_option', 'trainer_affiliation_phrase', false, false);
$this->viewAssignEscaped('trainer_affiliations', $trainerAffiliationArray);
$trainerSkillsArray = MultiOptionList::choicesList('trainer_to_trainer_skill_option', 'trainer_id', $person_id, 'trainer_skill_option', 'trainer_skill_phrase');
$this->viewAssignEscaped('trainer_skills', $trainerSkillsArray);
$trainerLanguagesArray = MultiOptionList::choicesList('trainer_to_trainer_language_option', 'trainer_id', $person_id, 'trainer_language_option', 'language_phrase', 'is_primary');
$this->viewAssignEscaped('trainer_languages', $trainerLanguagesArray);
foreach ($trainerLanguagesArray as $lang) {
if ($lang['is_primary']) {
$personArray['primary_language_id'] = $lang['id'];
}
}
//has training history
$hasTrainerHistory = false;
if ($trainerrow->person_id) {
$hasTrainerHistory = true;
//we could also look up any history now, but we'll be lazy
}
$this->view->assign('hasTrainerHistory', $hasTrainerHistory);
//facility types
$typesArray = OptionList::suggestionList('facility_type_option', 'facility_type_phrase', false, false);
$this->viewAssignEscaped('facility_types', $typesArray);
//get home city name
if ($personrow->home_location_id) {
$region_ids = Location::getCityInfo($personrow->home_location_id, $this->setting('num_location_tiers'));
$personArray['home_city'] = $region_ids[0];
$region_ids = Location::regionsToHash($region_ids, 'home');
$personArray = array_merge($personArray, $region_ids);
}
//sponsor types
$sponsorsArray = OptionList::suggestionList('facility_sponsor_option', 'facility_sponsor_phrase', false, false);
$this->viewAssignEscaped('facility_sponsors', $sponsorsArray);
$this->viewAssignEscaped('person', $personArray);
//facilities list
//$rowArray = OptionList::suggestionList('facility',array('facility_name','id'),false,9999);
$rowArray = Facility::selectAllFacilities($this->setting('num_location_tiers'));
$this->viewAssignEscaped('facilities', $rowArray);
if ($this->hasACL('edit_facility')) {
$this->view->assign('insertFacilityLink', '<a href="#" id="show">' . str_replace(' ', ' ', t('Insert new facility')) . '</a>');
}
//see if it is referenced anywhere
$this->view->assign('okToDelete', !$person_id or !Person::isReferenced($person_id));
// create reference for GET paramaters
if ($this->_getParam('trainingredirect')) {
$this->view->assign('trainingredirect', $this->_getParam('trainingredirect'));
}
if ($this->_getParam('maketrainer')) {
$this->view->assign('maketrainer', $this->_getParam('maketrainer'));
}
if ($this->_getParam('days')) {
$this->view->assign('days', $this->_getParam('days'));
}
} catch (Exception $e) {
print $e->getMessage();
}
}
protected function validateAndSave($facilityRow, $checkName = true)
{
$districtText = $this->tr('Region B (Health District)');
$provinceText = $this->tr('Region A (Province)');
$localRegionText = $this->tr('Region C (Local Region)');
//validate
$status = ValidationContainer::instance();
//check for required fields
if ($checkName) {
$status->checkRequired($this, 'facility_name', 'Facility name');
//check for unique
if ($this->_getParam('facility_name') and !Facility::isUnique($this->_getParam('facility_name'), $this->_getParam('id'))) {
$status->addError('facility_name', t('That name already exists.'));
}
}
// validate lat & long
require_once 'Zend/Validate/Float.php';
require_once 'Zend/Validate/Between.php';
$lat = $this->getSanParam('facility_latitude');
$long = $this->getSanParam('facility_longitude');
$validator = new Zend_Validate_Float();
$validbetween = new Zend_Validate_Between('-180', '180');
if ($lat && (!$validator->isValid($lat) || !$validbetween->isValid($lat))) {
$status->addError('facility_latitude', t('That latitude and longitude does not appear to be valid.'));
}
if ($long && (!$validator->isValid($long) || !$validbetween->isValid($long))) {
$status->addError('facility_longitude', t('That latitude and longitude does not appear to be valid.'));
}
$status->checkRequired($this, 'facility_type_id', t('Facility type'));
$status->checkRequired($this, 'facility_province_id', $provinceText);
if ($this->setting('display_region_b')) {
$status->checkRequired($this, 'facility_district_id', $districtText);
}
if ($this->setting('display_region_c')) {
$status->checkRequired($this, 'facility_region_c_id', $localRegionText);
}
if ($this->setting('display_region_d')) {
$status->checkRequired($this, 'facility_region_d_id', $this->tr('Region D'));
}
if ($this->setting('display_region_e')) {
$status->checkRequired($this, 'facility_region_e_id', $this->tr('Region E'));
}
if ($this->setting('display_region_f')) {
$status->checkRequired($this, 'facility_region_f_id', $this->tr('Region F'));
}
if ($this->setting('display_region_g')) {
$status->checkRequired($this, 'facility_region_g_id', $this->tr('Region G'));
}
if ($this->setting('display_region_h')) {
$status->checkRequired($this, 'facility_region_h_id', $this->tr('Region H'));
}
if ($this->setting('display_region_i')) {
$status->checkRequired($this, 'facility_region_i_id', $this->tr('Region I'));
}
//$status->checkRequired ( $this, 'facility_city', t ( "City is required." ) );
$city_id = false;
$values = $this->_getAllParams();
require_once 'views/helpers/Location.php';
$facility_city_parent_id = regionFiltersGetLastID('facility', $values);
if ($values['facility_city'] && !$this->getSanParam('is_new_city')) {
$city_id = Location::verifyHierarchy($values['facility_city'], $facility_city_parent_id, $this->setting('num_location_tiers'));
if ($city_id === false) {
$status->addError('facility_city', t("That city does not appear to be located in the chosen region. If you want to create a new city, check the new city box."));
}
}
$sponsor_date_array = $this->getSanParam('sponsor_start_date');
// may or may not be array
$sponsor_end_date_array = $this->getSanParam('sponsor_end_date');
$sponsor_id = $this->getSanParam('facility_sponsor_id') ? $this->getSanParam('facility_sponsor_id') : null;
if (is_array($sponsor_id)) {
$sponsor_array = $sponsor_id;
$sponsor_id = $sponsor_id[0];
}
// todo case where multip array and no_allow_multi
if (@$this->setting('require_sponsor_dates')) {
#$status->checkRequired ( $this, 'facility_sponsor_id', t('Sponsor dates are required.')."\n" );
if ($this->setting('allow_multi_sponsors')) {
// and multiple sponsors option
if (!is_array($this->getSanParam('facility_sponsor_id'))) {
$status->addError('sponsor_end_date', t('Sponsor dates are required.') . "\n");
}
foreach ($sponsor_array as $i => $val) {
if (empty($sponsor_date_array[$i]) && !empty($val)) {
$status->addError('sponsor_start_date', t('Sponsor dates are required.') . "\n");
}
if (empty($sponsor_end_date_array[$i]) && !empty($val)) {
$status->addError('sponsor_end_date', t('Sponsor dates are required.') . "\n");
}
}
}
}
// end validation
if ($status->hasError()) {
$status->setStatusMessage(t('The facility could not be saved.'));
} else {
$location_id = null;
// save location
if ($city_id === false && $values['is_new_city']) {
$location_id = Location::insertIfNotFound($values['facility_city'], $facility_city_parent_id, $this->setting('num_location_tiers'));
if ($location_id === false) {
$status->addError('facility_city', t('Could not save that city.'));
}
} else {
if ($city_id) {
$location_id = $city_id;
} else {
$location_id = regionFiltersGetLastID('facility', $values);
}
if (strstr($location_id, '_')) {
$parts = explode('_', $location_id);
$location_id = $parts[count($parts) - 1];
}
}
// save row
if ($location_id) {
//map db field names to FORM field names
$facilityRow->facility_name = $this->getSanParam('facility_name');
$facilityRow->location_id = $location_id;
$facilityRow->type_option_id = $this->getSanParam('facility_type_id') ? $this->getSanParam('facility_type_id') : null;
$facilityRow->facility_comments = $this->_getParam('facility_comments');
$facilityRow->address_1 = $this->getSanParam('facility_address1');
$facilityRow->address_2 = $this->getSanParam('facility_address2');
$facilityRow->lat = $lat;
$facilityRow->long = $long;
$facilityRow->postal_code = $this->getSanParam('facility_postal_code');
$facilityRow->phone = $this->getSanParam('facility_phone');
$facilityRow->fax = $this->getSanParam('facility_fax');
$facilityRow->sponsor_option_id = $sponsor_id;
//dupecheck
$dupe = new Facility();
$select = $dupe->select()->where('location_id =' . $facilityRow->location_id . ' and facility_name = "' . $facilityRow->facility_name . '"');
if (!$facilityRow->id && $dupe->fetchRow($select)) {
$status->status = '';
$status->setStatusMessage(t('The facility could not be saved. A facility with this name already exists in that location.'));
return false;
}
$obj_id = $facilityRow->save();
$_SESSION['status'] = t('The facility was saved.');
if ($obj_id && $this->setting('display_facility_sponsor')) {
if (!Facility::saveSponsors($obj_id, $sponsor_array, $sponsor_date_array, $sponsor_end_date_array)) {
$status->setStatusMessage(t('There was an error saving sponsor data though.'));
return false;
}
$status->setStatusMessage(t('The facility was saved.'));
$status->setRedirect('/facility/view/id/' . $obj_id);
return $obj_id;
} else {
unset($_SESSION['status']);
$status->setStatusMessage(t('ERROR: The facility could not be saved.'));
}
}
}
return false;
}
