function viewlocationAction()
 {
     if (!$this->hasACL('edit_course')) {
         $this->view->assign('viewonly', 'disabled="disabled"');
     }
     require_once 'models/table/TrainingLocation.php';
     $this->view->assign('id', $this->_getParam('id'));
     if ($this->_getParam('id')) {
         require_once 'views/helpers/DropDown.php';
         $rowLocation = TrainingLocation::selectLocation($this->_getParam('id'))->toArray();
         //locations
         list($cname, $prov, $dist, $regc) = Location::getCityInfo($rowLocation['location_id'], $this->setting('num_location_tiers'));
         $rowLocation['city_name'] = $cname;
         $rowLocation['region_c_id'] = $regc;
         $rowLocation['district_id'] = $dist;
         $rowLocation['province_id'] = $prov;
         $this->viewAssignEscaped('rowLocation', $rowLocation);
         //see if it is referenced anywhere
         $this->view->assign('okToDelete', !TrainingLocation::isReferenced($this->_getParam('id')));
     }
     // location drop-down
     $locations = TrainingLocation::selectAllLocations($this->setting('num_location_tiers'));
     $this->viewAssignEscaped('tlocations', $locations);
 }
 function viewlocationAction()
 {
     if (!$this->hasACL('edit_course')) {
         $this->view->assign('viewonly', 'disabled="disabled"');
     }
     require_once 'models/table/TrainingLocation.php';
     $this->view->assign('id', $this->_getParam('id'));
     if ($this->_getParam('id')) {
         require_once 'views/helpers/DropDown.php';
         $rowLocation = TrainingLocation::selectLocation($this->_getParam('id'))->toArray();
         //locations
         $this->viewAssignEscaped('locations', Location::getAll());
         $region_ids = Location::getCityInfo($rowLocation['location_id'], $this->setting('num_location_tiers'));
         $rowLocation['city_name'] = $region_ids[0];
         $region_ids = Location::regionsToHash($region_ids);
         $rowLocation = array_merge($rowLocation, $region_ids);
         $this->viewAssignEscaped('rowLocation', $rowLocation);
         //see if it is referenced anywhere
         $this->view->assign('okToDelete', !TrainingLocation::isReferenced($this->_getParam('id')));
     }
     // location drop-down
     $locations = TrainingLocation::selectAllLocations($this->setting('num_location_tiers'));
     $this->viewAssignEscaped('tlocations', $locations);
 }