コード例 #1
0
/**
 * Translate
 *
 * @param str $string
 * @return str
 */
function t($string)
{
    //first check our label list for the phrase
    $t = ITechController::translations();
    //see if the label has been modified in country settings
    $label_change = null;
    if ($t && isset($t[$string])) {
        $label_change = $t[$string];
    }
    //translate using the original label
    $translated = "";
    if (ITechTranslate::$instance) {
        $translated = ITechTranslate::$instance->translate($string);
    }
    if (!$translated) {
        return $string;
    }
    //if we didn't translate anything then return the label
    if ($translated == $string && $label_change) {
        return $label_change;
    }
    //otherwise return translated
    if ($translated) {
        return $translated;
    }
    return $string;
}
コード例 #2
0
 public function preDispatch()
 {
     parent::preDispatch();
     if (!$this->isLoggedIn()) {
         $this->doNoAccessError();
     }
 }
コード例 #3
0
 public function preDispatch()
 {
     parent::preDispatch();
     if (!$this->isLoggedIn()) {
         $this->doNoAccessError();
     }
     if (empty($this->view->title)) {
         $this->view->assign('title', $this->view->translation['Application Name']);
     }
 }
コード例 #4
0
 public function preDispatch()
 {
     $rtn = parent::preDispatch();
     if (!$this->isLoggedIn()) {
         $this->doNoAccessError();
     }
     if (!$this->hasACL('view_create_reports')) {
         $this->doNoAccessError();
     }
     return $rtn;
 }
コード例 #5
0
 public function preDispatch()
 {
     require_once 'models/table/User.php';
     //add identity to view variables
     $auth = Zend_Auth::getInstance();
     $identity = null;
     if ($auth->hasIdentity()) {
         //get ACLs and add to identity
         $acls = User::getACLs($auth->getIdentity()->id);
         $identity = $auth->getIdentity();
         $identity->acls = $acls;
         $auth->getStorage()->write($identity);
         $this->view->assign('identity', $identity);
     }
     //set up localization
     //get country default locale, then check user settings
     if (isset($_COOKIE['locale']) and array_key_exists($_COOKIE['locale'], ITechTranslate::getLanguages())) {
         $locale = $_COOKIE['locale'];
     } else {
         $locale = $this->_countrySettings['locale'];
     }
     if (!$locale) {
         $locale = 'en_EN.UTF-8';
     }
     if ($auth->hasIdentity() and $auth->getIdentity()->locale) {
         $locale = $auth->getIdentity()->locale;
     }
     //set up localization
     ITechTranslate::init($locale);
     // get Country-specific phrases for fields
     self::$_translations = Translation::getAll();
     $this->view->assign('translation', self::translations());
     //look for any status messages in the session and put the validation container in the view scope
     $statusObj = ValidationContainer::instance();
     if (isset($_SESSION['status'])) {
         $statusObj->setStatusMessage($_SESSION['status']);
         unset($_SESSION['status']);
     }
     $this->view->assign('status', $statusObj);
 }
コード例 #6
0
 public function __construct($request, $response, $invokeArgs = array())
 {
     parent::__construct($request, $response, $invokeArgs = array());
 }
コード例 #7
0
 public function preDispatch()
 {
     $rtn = parent::preDispatch();
     return $rtn;
 }
コード例 #8
0
 public function __construct(Zend_Controller_Request_Abstract $request, Zend_Controller_Response_Abstract $response, array $invokeArgs = array())
 {
     parent::__construct($request, $response, $invokeArgs);
 }
コード例 #9
0
 public function __construct(&$parentController)
 {
     $this->controller = $parentController;
     $this->view = $parentController->view;
     parent::__construct($parentController->getRequest(), $parentController->getResponse());
 }
コード例 #10
0
 /**
  * Import a training
  */
 public function importAction()
 {
     //ini_set('max_execution_time','300');
     $errs = array();
     $this->view->assign('pageTitle', t('Import a training'));
     // template redirect
     if ($this->getSanParam('download')) {
         return $this->importTrainingTemplateAction();
     }
     if (!$this->hasACL('import_training')) {
         $this->doNoAccessError();
     }
     //CSV STUFF
     $filename = $_FILES['upload']['tmp_name'];
     if ($filename) {
         require_once 'models/table/TrainingLocation.php';
         require_once 'models/table/Person.php';
         require_once 'models/table/TrainingToTrainer.php';
         require_once 'models/table/PersonToTraining.php';
         $trainingObj = new Training();
         $personToTraining = new PersonToTraining();
         while ($row = $this->_csv_get_row($filename)) {
             $cntz++;
             // todo remove
             $values = array();
             if (!is_array($row)) {
                 continue;
             }
             if (!isset($cols)) {
                 $cols = $row;
                 // first row is headers (fieldnames)
                 continue;
             }
             if (!empty($row)) {
                 // add
                 $countValidFields = 0;
                 foreach ($row as $i => $v) {
                     if (empty($v) && $v !== '0') {
                         continue;
                     }
                     if ($v == 'n/a') {
                         // has to be able to process values from a data export
                         $v = NULL;
                     }
                     $countValidFields++;
                     if (strpos($v, "\n")) {
                         // explode by newline then comma to give us arrays
                         $v = explode("\n", $v);
                         foreach ($v as $key => $value) {
                             $delimiter = strpos($value, ',');
                             if ($delimiter && $value[$delimiter - 1] != '\\') {
                                 // todo this doesnt really work, explode will still break it (supposed to be a \, handler (escaped comma), so you can use commas in fields)
                                 $values[$cols[$i]][] = explode(',', $this->sanitize($value));
                             } else {
                                 $values[$cols[$i]][] = $this->sanitize($value);
                             }
                         }
                     } else {
                         $delimiter = strpos($v, ',');
                         if ($delimiter && $v[$delimiter - 1] != '\\') {
                             $values[$cols[$i]] = explode(',', $this->sanitize($v));
                         } else {
                             $values[$cols[$i]] = $this->sanitize($v);
                         }
                     }
                 }
             }
             // all values are now in a hash ex: $values['training_id']
             if ($countValidFields) {
                 //validate
                 if (isset($values['uuid'])) {
                     unset($values['uuid']);
                 }
                 if (isset($values['id'])) {
                     unset($values['id']);
                 }
                 if (isset($values['is_deleted'])) {
                     unset($values['is_deleted']);
                 }
                 if (isset($values['created_by'])) {
                     unset($values['created_by']);
                 }
                 if (isset($values['modified_by'])) {
                     unset($values['modified_by']);
                 }
                 if (isset($values['timestamp_created'])) {
                     unset($values['timestamp_created']);
                 }
                 if (isset($values['timestamp_updated'])) {
                     unset($values['timestamp_updated']);
                 }
                 if (!$this->hasACL('approve_trainings')) {
                     $values['is_approved'] = 0;
                 }
                 if (!$this->setting('module_approvals_enabled') == 0) {
                     $values['is_approved'] = 1;
                 }
                 if ($values['training_start_date']) {
                     $values['training_start_date'] = $this->_date_to_sql($values['training_start_date']);
                 }
                 if ($values['training_end_date']) {
                     $values['training_end_date'] = $this->_date_to_sql($values['training_end_date']);
                 }
                 if ($values['training_length_interval'] == 'days') {
                     $values['training_length_interval'] = 'day';
                 }
                 if ($values['training_length_interval'] == 'weeks') {
                     $values['training_length_interval'] = 'week';
                 }
                 if ($values['training_length_interval'] == 'hours') {
                     $values['training_length_interval'] = 'hour';
                 }
                 // remap fields (field names differ vs actual column names on export/template for readibility thanks to some function in iTechTranslate)
                 if ($values['training_title_phrase']) {
                     $values['training_title_option_id'] = $values['training_title_phrase'];
                 }
                 if ($values['training_title']) {
                     $values['training_title_option_id'] = $values['training_title'];
                 }
                 if ($values['custom3_phrase']) {
                     $values['custom_3'] = $values['custom3_phrase'];
                 }
                 if ($values['custom4_phrase']) {
                     $values['custom_4'] = $values['custom4_phrase'];
                 }
                 if ($values['custom5_phrase']) {
                     $values['custom_5'] = $values['custom5_phrase'];
                 }
                 if ($values['refresher_phrase_option']) {
                     $values['training_refresher_phrase'] = $values['refresher_phrase_option'];
                 }
                 if ($values['training_refresher_option_id']) {
                     $values['training_refresher_phrase'] = $values['training_refresher_option_id'];
                 }
                 if ($values['language_phrase']) {
                     $values['training_primary_language_option_id'] = $values['language_phrase'];
                 }
                 // required fields
                 if (!$values['training_title_option_id']) {
                     $values['training_title_option_id'] = 0;
                 }
                 if (!$values['comments']) {
                     $values['comments'] = '';
                 }
                 if (!$values['got_comments']) {
                     $values['got_comments'] = '';
                 }
                 if (!$values['objectives']) {
                     $values['objectives'] = '';
                 }
                 // training location
                 $num_location_tiers = $this->setting('num_location_tiers');
                 $bSuccess = true;
                 if (!isset($regionNames)) {
                     $regionNames = array('', t('Region A (Province)'), t('Region B (Health District)'), t('Region C (Local Region)'), t('Region D'), t('Region E'), t('Region F'), t('Region G'), t('Region H'), t('Region I'), t('City'));
                 }
                 $location_id = 0;
                 $training_location_id = $values['training_location_id'] ? $values['training_location_id'] : 0;
                 // training_location_id and a default
                 // validity check location name
                 if ($training_location_id && $values['training_location_name']) {
                     $dupe = new TrainingLocation();
                     $select = $dupe->select()->where('id =' . $training_location_id . ' and training_location_name = "' . $values['training_location_name'] . '"');
                     $training_location_id = ($a = $dupe->fetchRow($select)) ? $a->id : 0;
                     // valid or doesnt match lets reset it and insert a new one this record was imported from another site
                 }
                 // insert new location
                 $tier = 1;
                 if (!$training_location_id && $values['training_location_name']) {
                     for ($i = 1; $i < $num_location_tiers + 1; $i++) {
                         // insert/find locations
                         $location_name = $i == $num_location_tiers ? @$values[t('City')] : @$values[$regionNames[$i]];
                         // last one?
                         if ($regionNames[$i] != t('City') && (empty($location_name) || $bSuccess == false)) {
                             $bSuccess = false;
                             continue;
                         } else {
                             // insert
                             $location_id = Location::insertIfNotFound($location_name, $location_id, $tier);
                             if (!$location_id) {
                                 $bSuccess = false;
                                 $errs[] = t('Error locating/creating region or city:') . ' ' . $location_name . ' ' . t('Training Location') . ': ' . $values['training_location_name'];
                                 break;
                             }
                         }
                         $tier++;
                     }
                     if ($bSuccess && $location_id) {
                         // we have a region id (location id), now save training_location
                         // dupecheck
                         $dupe = new TrainingLocation();
                         $select = $dupe->select()->where('location_id =' . $location_id . ' and training_location_name = "' . $values['training_location_name'] . '"');
                         if ($a = $dupe->fetchRow($select)) {
                             $training_location_id = $a->id;
                         } else {
                             // save
                             try {
                                 $trainingLocModel = new TrainingLocation();
                                 $trainingLocationObj = $trainingLocModel->createRow();
                                 $trainingLocationObj->training_location_name = $values['training_location_name'];
                                 $trainingLocationObj->location_id = $location_id;
                                 $training_location_id = $trainingLocationObj->save();
                             } catch (Exception $e) {
                                 $errored = 1;
                                 $errs[] = nl2br($e->getMessage()) . space . t('ERROR: The training location could not be saved.') . space . '"' . $values['training_location_name'] . '"';
                             }
                             if (!$training_location_id) {
                                 $errored = 1;
                             }
                         }
                     }
                     if ($errored || !$bSuccess) {
                         // couldn't save location
                         $errs[] = t('Error locating/creating') . space . t('Training Location') . space . ': ' . $location_name . ' ' . t('Training Location') . ': ' . $values['training_location_name'];
                         $errored = 0;
                         $bSuccess = true;
                     }
                 }
                 if ($training_location_id) {
                     $values['training_location_id'] = $training_location_id;
                 }
                 // done, saved training location.
                 // save
                 try {
                     // option tables / lookup tables // insert or get id, and remap col names from csv template name to actual column name, asdf_phrase to asdf_option_id
                     // the logic is: if ($values['title_phrase']) $training->title_option_id = findOrCreate('training_title', $values['title_phrase']) );
                     if (isset($values['training_title_option_id'])) {
                         $values['training_title_option_id'] = $this->_importHelperFindOrCreate('training_title_option', 'training_title_phrase', $values['training_title_option_id']);
                     }
                     if (isset($values['training_got_curriculum_phrase'])) {
                         $values['training_got_curriculum_option_id'] = $this->_importHelperFindOrCreate('training_got_curriculum_option', 'training_got_curriculum_phrase', $values['training_got_curriculum_phrase']);
                     }
                     if (isset($values['training_level_phrase'])) {
                         $values['training_level_option_id'] = $this->_importHelperFindOrCreate('training_level_option', 'training_level_phrase', $values['training_level_phrase']);
                     }
                     if (isset($values['custom1_phrase'])) {
                         $values['training_custom_1_option_id'] = $this->_importHelperFindOrCreate('training_custom_1_option', 'custom1_phrase', $values['custom1_phrase']);
                     }
                     if (isset($values['custom2_phrase'])) {
                         $values['training_custom_2_option_id'] = $this->_importHelperFindOrCreate('training_custom_2_option', 'custom2_phrase', $values['custom2_phrase']);
                     }
                     if (isset($values['training_organizer_phrase'])) {
                         $values['training_organizer_option_id'] = $this->_importHelperFindOrCreate('training_organizer_option', 'training_organizer_phrase', $values['training_organizer_phrase']);
                     }
                     if (isset($values['training_method_phrase'])) {
                         $values['training_method_option_id'] = $this->_importHelperFindOrCreate('training_method_option', 'training_method_phrase', $values['training_method_phrase']);
                     }
                     if (isset($values['training_primary_language_option_id'])) {
                         $values['training_primary_language_option_id'] = $this->_importHelperFindOrCreate('trainer_language_option', 'language_phrase', $values['training_primary_language_option_id']);
                     }
                     if (isset($values['training_refresher_phrase']) && !is_array($values['training_refresher_phrase'])) {
                         $values['training_refresher_option_id'] = $this->_importHelperFindOrCreate('training_refresher_option', 'refresher_phrase_option', $values['training_refresher_phrase']);
                     }
                     // participants, trainers
                     $tableObj = $trainingObj->createRow();
                     $tableObj = ITechController::fillFromArray($tableObj, $values);
                     $row_id = $tableObj->save();
                     // done save - we have a training id now
                     // linked tables
                     if ($row_id > 0) {
                         $training_id = $row_id;
                         $success[] = t('Successfully imported training #') . space . '<a href="' . Settings::$COUNTRY_BASE_URL . '/training/view/id/' . $training_id . '">' . $training_id . '</a>';
                         // multiOptionList tables
                         if ($values['funding_phrase']) {
                             $bSuccess = $this->_importHelperFindOrCreateMOLT('training_funding_option', 'funding_phrase', $values['funding_phrase'], 'funding', $training_id, $values['funding_amount']);
                             if (!$bSuccess) {
                                 $errs[] = t('Training') . space . "#{$training_id} " . t('Some Data not imported') . " (funding)";
                             }
                         }
                         if ($values['pepfar_category_phrase']) {
                             $bSuccess = $this->_importHelperFindOrCreateMOLT('training_pepfar_categories_option', 'pepfar_category_phrase', $values['pepfar_category_phrase'], 'pepfar', $training_id, $values['pepfar_duration_days']);
                             if (!$bSuccess) {
                                 $errs[] = t('Training') . space . "#{$training_id} " . t('Some Data not imported') . " (PEPFAR)";
                             }
                         }
                         if ($values['training_refresher_phrase']) {
                             $bSuccess = $this->_importHelperFindOrCreateMOLT('training_refresher_option', 'refresher_phrase_option', $values['training_refresher_phrase'], 'refresher', $training_id);
                             if (!$bSuccess) {
                                 $errs[] = t('Training') . space . "#{$training_id} " . t('Some Data not imported') . " (refresher course)";
                             }
                         }
                         if ($values['training_topic_phrase']) {
                             $bSuccess = $this->_importHelperFindOrCreateMOLT('training_topic_option', 'training_topic_phrase', $values['training_topic_phrase'], 'topic', $training_id);
                             if (!$bSuccess) {
                                 $errs[] = t('Training') . space . "#{$training_id} " . t('Some Data not imported') . " (training topic)";
                             }
                         }
                         //unknown participants
                         if (!empty($values['unknown participants'])) {
                             $upTable = new ITechTable(array('name' => 'training_to_person_qualification_option'));
                             foreach ($values['unknown participants'] as $i => $data) {
                                 if (empty($data) || $data == 'n/a') {
                                     continue;
                                 }
                                 try {
                                     # (this row is $data) row format: array( "2(na)"," 2(male)"," 2(female)"," "QualificationPhrase")
                                     $qual_id = $data[count($data) - 1];
                                     $qual_id = trim($qual_id);
                                     if (!is_int($qual_id) && strpos($qual_id, '(na)') === false && strpos($qual_id, '(female)') === false && strpos($qual_id, '(male)') === false) {
                                         $qual_id = $this->_importHelperFindOrCreate('person_qualification_option', 'qualification_phrase', $qual_id);
                                     } else {
                                         $errs[] = 'Training #' . $row_id . space . t('You did not set a qualification for a group of unknown participants.');
                                         $qual_id = 0;
                                     }
                                     $tablerow = $upTable->createRow();
                                     $tablerow->id = null;
                                     $tablerow->training_id = $row_id;
                                     $tablerow->person_qualification_option_id = $qual_id ? $qual_id : 0;
                                     $tablerow->age_range_option_id = 0;
                                     // todo age_range_option_id
                                     #reference: $age_opts = OptionList::suggestionList('age_range_option',array('id','age_range_phrase'), false, 100, false);
                                     $tablerow->person_count_na = 0;
                                     $tablerow->person_count_male = 0;
                                     $tablerow->person_count_female = 0;
                                     foreach ($data as $v) {
                                         if (strpos($v, '(na)')) {
                                             $tablerow->person_count_na = trim(str_replace('(na)', '', $v));
                                         }
                                         if (strpos($v, '(male)')) {
                                             $tablerow->person_count_male = trim(str_replace('(male)', '', $v));
                                         }
                                         if (strpos($v, '(female)')) {
                                             $tablerow->person_count_female = trim(str_replace('(female)', '', $v));
                                         }
                                     }
                                     if (!$tablerow->person_count_na && !$tablerow->person_count_male && !$tablerow->person_count_female) {
                                         continue;
                                     }
                                     //empty
                                     $tablerow->save();
                                 } catch (Exception $e) {
                                     $errs[] = t('Error saving unknown participant information.') . space . 'Training #' . $row_id . space . 'Error: ' . $e->getMessage();
                                 }
                             }
                         }
                         //training_to_trainer
                         foreach (array($values['trainers'], $values['participants']) as $imode => $personArr) {
                             $persons = explode("\n", $personArr);
                             if (empty($personArr)) {
                                 continue;
                             }
                             if (!is_array($personArr)) {
                                 $personArr = array($personArr);
                             }
                             foreach ($personArr as $tRow) {
                                 $tRow = trim($tRow);
                                 if ($tRow == '' || $tRow == 'n/a') {
                                     continue;
                                 }
                                 echo '<br>' . PHP_EOL . 'trainer [t|p]' . $imode . ' row @ training id #training_id: ' . print_r($tRow, true) . "<Br>" . PHP_EOL;
                                 if (is_array($tRow)) {
                                     if (count($tRow) == 4 && is_numeric($tRow[0])) {
                                         // some handling if it has a middle name or ID # attached or exported from training search
                                         $trainer_id = $tRow[0];
                                     } else {
                                         if (count($tRow) == 3 && $this->setting('display_middle_name') == 0 && is_numeric($tRow[0])) {
                                             $trainer_id = $tRow[0];
                                         } else {
                                             list($trainer_first, $trainer_middle, $trainer_last) = $tRow;
                                         }
                                     }
                                     // expects comma seperated list of names...
                                 } else {
                                     list($trainer_first, $trainer_middle, $trainer_last) = explode(' ', $tRow);
                                 }
                                 if ($trainer_middle && !$trainer_last) {
                                     $trainer_last = $trainer_middle;
                                     $trainer_middle = '';
                                 }
                                 echo "trainer_first, trainer_middle, trainer_last = {$trainer_first}, {$trainer_middle}, {$trainer_last}";
                                 $trainer_id = Person::tryFind($trainer_first, $trainer_middle, $trainer_last);
                                 echo " and trainer_id = {$trainer_id} <br>\n";
                                 if (!$trainer_id) {
                                     $errs[] = t("Could not add user to training because they were not found in the system.") . space . t('Training') . " #{$training_id}: '{$trainer_first} {$trainer_middle} {$trainer_last}'";
                                     continue;
                                 }
                                 echo " and trainer found, addTrainerToTraining({$trainer_id}, {$training_id},0)<br>\n";
                                 if ($imode == 0) {
                                     TrainingToTrainer::addTrainerToTraining($trainer_id, $training_id, 0);
                                 } elseif ($imode == 1) {
                                     $personToTraining->addPersonToTraining($trainer_id, $training_id);
                                 }
                             }
                         }
                     }
                 } catch (Exception $e) {
                     $errored = 1;
                     $errs[] = nl2br($e->getMessage()) . ' ' . t('ERROR: The training data could not be saved.') . space . ($training_id ? t('Training') . space . "#{$training_id}" . space . t('Warning: Some data imported.') . space . t('Check Funding, PEPFAR, Topic, Refresher options and Participants and Trainers Data; or delete the training and try again.') : '');
                 }
                 if (!$row_id) {
                     $errored = 1;
                 }
             }
         }
         // done processing rows
         $_POST['redirect'] = null;
         $status = ValidationContainer::instance();
         if (empty($errored) && empty($errs)) {
             $stat = t('Your changes have been saved.');
         } else {
             $stat = t('Error importing data. Some data may have been imported and some may not have.');
         }
         foreach ($success as $errmsg) {
             $stat .= '<br>' . $errmsg;
         }
         foreach ($errs as $errmsg) {
             $stat .= '<br>' . 'Error: ' . htmlspecialchars($errmsg, ENT_QUOTES);
         }
         $status->setStatusMessage($stat);
         $this->view->assign('status', $status);
     }
     // done with import
 }
コード例 #11
0
 /**
  * Import a person
  */
 public function importAction()
 {
     $this->view->assign('pageTitle', t('Import a person'));
     require_once 'models/table/TrainingToTrainer.php';
     // template redirect
     if ($this->getSanParam('download')) {
         return $this->importTrainingTemplateAction();
     }
     if (!$this->hasACL('import_person')) {
         $this->doNoAccessError();
     }
     //CSV STUFF
     $filename = $_FILES['upload']['tmp_name'];
     if ($filename) {
         $personObj = new Person();
         $errs = array();
         while ($row = $this->_csv_get_row($filename)) {
             $values = array();
             if (!is_array($row)) {
                 continue;
             }
             // sanity?
             if (!isset($cols)) {
                 // set headers (field names)
                 $cols = $row;
                 // first row is headers (field names)
                 continue;
             }
             $countValidFields = 0;
             if (!empty($row)) {
                 // add
                 foreach ($row as $i => $v) {
                     // proccess each column
                     if (empty($v) && $v !== '0') {
                         continue;
                     }
                     if ($v == 'n/a') {
                         // has to be able to process values from a data export
                         $v = NULL;
                     }
                     $countValidFields++;
                     $delimiter = strpos($v, ',');
                     // is this field a comma seperated list too (or array)?
                     if ($delimiter && $v[$delimiter - 1] != '\\') {
                         // handle arrays as field values(Export), and comma seperated values(import manual entry), and strings or int
                         $values[$cols[$i]] = explode(',', $this->sanitize($v));
                     } else {
                         $values[$cols[$i]] = $this->sanitize($v);
                     }
                 }
             }
             // done now all fields are named and in $values[my_field]
             if ($countValidFields) {
                 //validate
                 if (isset($values['uuid'])) {
                     unset($values['uuid']);
                 }
                 if (isset($values['id'])) {
                     unset($values['id']);
                 }
                 if (isset($values['is_deleted'])) {
                     unset($values['is_deleted']);
                 }
                 if (isset($values['created_by'])) {
                     unset($values['created_by']);
                 }
                 if (isset($values['modified_by'])) {
                     unset($values['modified_by']);
                 }
                 if (isset($values['timestamp_created'])) {
                     unset($values['timestamp_created']);
                 }
                 if (isset($values['timestamp_updated'])) {
                     unset($values['timestamp_updated']);
                 }
                 if (!$this->hasACL('approve_trainings')) {
                     unset($values['approved']);
                 }
                 #if ( $values['sponsor_option_id'] ) {
                 #	$sponsors = $this->_array_me($values['sponsor_option_id']); // could be an array, we dont want one
                 #	$values['sponsor_option_id'] = $sponsors[0];
                 #}
                 //locations
                 $num_location_tiers = $this->setting('num_location_tiers');
                 $bSuccess = true;
                 $location_id = null;
                 if ($values['facility_name']) {
                     if (!$values['facility_id']) {
                         if (is_array($values['facility_name'])) {
                             $values['facility_id'] = $values['facility_name'][0];
                         } else {
                             if (is_numeric($values['facility_name'])) {
                                 $values['facility_id'] = $values['facility_name'];
                             }
                         }
                         //else
                         //$errs[] = t ('Not able to set facility location for: ').$values['first_name'].space.$values['last_name'];
                     }
                 }
                 if (!$bSuccess) {
                     $errs[] = t('Error locating/creating region or city:') . ' ' . $row[$r] . ' ' . t('Facility') . ': ' . $values['facility_name'];
                     continue;
                     // couldnt save location
                 }
                 //dupecheck
                 $dupe = new Person();
                 $select = $dupe->select()->where('facility_id = "' . $values['facility_id'] . '" and first_name = "' . $values['first_name'] . '" and last_name = "' . $values['last_name'] . '"');
                 if ($dupe->fetchRow($select)) {
                     $errs[] = t('A person with this name already exists in the database, the user was not added.') . space . t('Name') . ': ' . $values['first_name'] . space . $values['last_name'];
                     $bSuccess = false;
                 }
                 if (!$bSuccess) {
                     continue;
                 }
                 //field mapping (Export vs import)
                 if (isset($values["qualification_phrase"])) {
                     $values["primary_qualification_option_id"] = $values["qualification_phrase"];
                 }
                 if (isset($values["primary_qualification_phrase"])) {
                     $values["primary_qualification_option_id"] = $values["primary_qualification_phrase"];
                 }
                 if (isset($values["primary_responsibility_phrase"])) {
                     $values["primary_responsibility_option_id"] = $values["primary_responsibility_phrase"];
                 }
                 if (isset($values["secondary_responsibility_phrase"])) {
                     $values["secondary_responsibility_option_id"] = $values["secondary_responsibility_phrase"];
                 }
                 if (isset($values["highest_edu_level_phrase"])) {
                     $values["highest_edu_level_option_id"] = $values["highest_edu_level_phrase"];
                 }
                 if (isset($values["attend_reason_phrase"])) {
                     $values["attend_reason_option_id"] = $values["attend_reason_phrase"];
                 }
                 if (isset($values["custom_1"])) {
                     $values["person_custom_1_option_id"] = $values["custom_1"];
                 }
                 if (isset($values["custom_2"])) {
                     $values["person_custom_2_option_id"] = $values["custom_2"];
                 }
                 //save
                 try {
                     //$values['title_option_id']                    = $this->_importHelperFindOrCreate('person_title_option',           'title_phrase',           $values['title_option_id']); //title_option_id multiAssign (insert via helper)
                     //$values['suffix_option_id']                   = $this->_importHelperFindOrCreate('person_suffix_option',          'suffix_phrase',          $values['suffix_option_id']);
                     $values['primary_qualification_option_id'] = $this->_importHelperFindOrCreate('person_qualification_option', 'qualification_phrase', $values['primary_qualification_option_id']);
                     $values['primary_responsibility_option_id'] = $this->_importHelperFindOrCreate('person_responsibility_option', 'responsibility_phrase', $values['primary_responsibility_option_id']);
                     $values['secondary_responsibility_option_id'] = $this->_importHelperFindOrCreate('person_secondary_responsibility_option', 'responsibility_phrase', $values['secondary_responsibility_option_id']);
                     $values['attend_reason_option_id'] = $this->_importHelperFindOrCreate('person_attend_reason_option', 'attend_reason_phrase', $values['attend_reason_option_id']);
                     $values['person_custom_1_option_id'] = $this->_importHelperFindOrCreate('person_custom_1_option', 'custom1_phrase', $values['person_custom_1_option_id']);
                     $values['person_custom_2_option_id'] = $this->_importHelperFindOrCreate('person_custom_2_option', 'custom2_phrase', $values['person_custom_2_option_id']);
                     $values['highest_level_option_id'] = $this->_importHelperFindOrCreate('person_education_level_option', 'education_level_phrase', $values['highest_level_option_id']);
                     //$values['courses']                            = $this->_importHelperFindOrCreate('facility_type_option',         'facility_type_phrase', null, $values['courses']);
                     $personrow = $personObj->createRow();
                     $personrow = ITechController::fillFromArray($personrow, $values);
                     $row_id = $personrow->save();
                 } catch (Exception $e) {
                     $errored = 1;
                     $errs[] = nl2br($e->getMessage()) . ' ' . t('ERROR: The person could not be saved.');
                 }
                 if (!$row_id) {
                     $errored = 1;
                     $errs[] = t('That person could not be saved.') . space . t("Name") . ": " . $values['first_name'] . space . $values['last_name'];
                 }
                 //sucess - done
             }
             //loop
         }
         // done processing rows
         $_POST['redirect'] = null;
         if (empty($errored) && empty($errs)) {
             $stat = t('Your changes have been saved.');
         } else {
             $stat = t('Error importing data. Some data rows have not been imported.');
         }
         foreach ($errs as $errmsg) {
             $stat .= '<br>' . 'Error: ' . htmlspecialchars($errmsg, ENT_QUOTES);
         }
         $status = ValidationContainer::instance();
         $status->setStatusMessage($stat);
         $this->view->assign('status', $status);
     }
     // done with import
 }
コード例 #12
0
 /**
  * Import a facility
  */
 public function importAction()
 {
     $this->view->assign('pageTitle', t('Import a facility'));
     require_once 'models/table/Location.php';
     require_once 'models/table/Facility.php';
     // template redirect
     if ($this->getSanParam('download')) {
         return $this->importFacilityTemplateAction();
     }
     if (!$this->hasACL('import_facility')) {
         $this->doNoAccessError();
     }
     //CSV STUFF
     $filename = $_FILES['upload']['tmp_name'];
     if ($filename) {
         $facilityObj = new Facility();
         $errs = array();
         while ($row = $this->_csv_get_row($filename)) {
             $values = array();
             if (!is_array($row)) {
                 continue;
             }
             // sanity?
             if (!isset($cols)) {
                 // set headers (field names)
                 $cols = $row;
                 // first row is headers (field names)
                 continue;
             }
             $countValidFields = 0;
             if (!empty($row)) {
                 // add
                 foreach ($row as $i => $v) {
                     // proccess each column
                     if (empty($v) && $v !== '0') {
                         continue;
                     }
                     if ($v == 'n/a') {
                         // has to be able to process values from a data export
                         $v = NULL;
                     }
                     $countValidFields++;
                     $delimiter = strpos($v, ',');
                     // is this field a comma seperated list too (or array)?
                     if ($delimiter && $v[$delimiter - 1] != '\\') {
                         // handle arrays as field values(Export), and comma seperated values(import manual entry), and strings or int
                         $values[$cols[$i]] = explode(',', $this->sanitize($v));
                     } else {
                         $values[$cols[$i]] = $this->sanitize($v);
                     }
                 }
             }
             // done now all fields are named and in $values[my_field]
             if ($countValidFields) {
                 //validate
                 if (isset($values['uuid'])) {
                     unset($values['uuid']);
                 }
                 if (isset($values['id'])) {
                     unset($values['id']);
                 }
                 if (isset($values['is_deleted'])) {
                     unset($values['is_deleted']);
                 }
                 if (isset($values['created_by'])) {
                     unset($values['created_by']);
                 }
                 if (isset($values['modified_by'])) {
                     unset($values['modified_by']);
                 }
                 if (isset($values['timestamp_created'])) {
                     unset($values['timestamp_created']);
                 }
                 if (isset($values['timestamp_updated'])) {
                     unset($values['timestamp_updated']);
                 }
                 if (!$this->hasACL('approve_trainings')) {
                     unset($values['approved']);
                 }
                 if ($values['sponsor_option_id']) {
                     $sponsors = $this->_array_me($values['sponsor_option_id']);
                     // could be an array, we dont want one
                     $values['sponsor_option_id'] = $sponsors[0];
                 }
                 //required
                 if (empty($values['facility_name'])) {
                     $errs[] = t('Error adding facility, Facility name cannot be empty.');
                     continue;
                 }
                 if (empty($values['address_1'])) {
                     $values['address_1'] = '';
                 }
                 if (empty($values['address_2'])) {
                     $values['address_2'] = '';
                 }
                 //locations
                 $num_location_tiers = $this->setting('num_location_tiers');
                 $bSuccess = true;
                 $location_id = null;
                 if ($values['location_id']) {
                     $location_id = $values['location_id'];
                 }
                 $tier = 1;
                 if (!$location_id) {
                     for ($i = 0; $i <= $num_location_tiers; $i++) {
                         // insert/find locations
                         $r = 11 + $i;
                         // first location field in csv row // could use this too: $values[t('Region A (Province)')]
                         if (empty($row[$r]) || $bSuccess == false) {
                             continue;
                         }
                         $location_id = Location::insertIfNotFound($row[$r], $location_id, $tier);
                         if (!$location_id) {
                             $bSuccess = false;
                             break;
                         }
                         $tier++;
                     }
                 }
                 if (!$bSuccess) {
                     $errs[] = t('Error locating/creating region or city:') . ' ' . $row[$r] . ' ' . t('Facility') . ': ' . $values['facility_name'];
                     continue;
                     // couldnt save location
                 }
                 $values['location_id'] = $location_id;
                 //dupecheck
                 $dupe = new Facility();
                 $select = $dupe->select()->where('location_id =' . $location_id . ' and facility_name = "' . $values['facility_name'] . '"');
                 if ($dupe->fetchRow($select)) {
                     $errs[] = t('The facility could not be saved. A facility with this name already exists in that location.') . ' ' . t('Facility') . ': ' . $values['facility_name'];
                     $bSuccess = false;
                 }
                 //save
                 if ($bSuccess) {
                     try {
                         $tableObj = $facilityObj->createRow();
                         $tableObj = ITechController::fillFromArray($tableObj, $values);
                         $tableObj->type_option_id = $this->_importHelperFindOrCreate('facility_type_option', 'facility_type_phrase', $tableObj->type_option_id);
                         if ($values['type_option_id'] && !$tableObj->type_option_id) {
                             $errs[] = t("Couldn't save facility type for facility:") . ' ' . $tableObj->facility_name;
                         }
                         $row_id = $tableObj->save();
                     } catch (Exception $e) {
                         $errored = 1;
                         $errs[] = nl2br($e->getMessage()) . ' ' . t('ERROR: The facility could not be saved.');
                     }
                     if (!$row_id) {
                         $errored = 1;
                     }
                     //save linked tables
                     if ($row_id && $this->setting('allow_multi_sponsors')) {
                         if ($sponsors || $values['sponsor_start_date'] || $values['sponsor_end_date']) {
                             $dates1 = $this->_array_me($values['sponsor_start_date']);
                             $dates2 = $this->_array_me($values['sponsor_end_date']);
                             foreach ($sponsors as $i => $phrase) {
                                 // insert or get id
                                 $sponsors[$i] = $this->_importHelperFindOrCreate('facility_sponsor_option', 'facility_sponsor_phrase', $phrase);
                             }
                             //facility_type_option_id multiAssign (insert via helper)
                             if (!Facility::saveSponsors($row_id, $sponsors, $dates1, $dates2)) {
                                 // save
                                 $errs[] = t('There was an error saving sponsor data though.') . ' ' . t('Facility') . ': ' . $tableObj->facility_name;
                             }
                         }
                     }
                 }
                 //sucess - done
             }
             //loop
         }
         // done processing rows
         $_POST['redirect'] = null;
         $status = ValidationContainer::instance();
         if (empty($errored) && empty($errs)) {
             $stat = t('Your changes have been saved.');
         } else {
             $stat = t('Error importing data. Some data may have been imported and some may not have.');
         }
         foreach ($errs as $errmsg) {
             $stat .= '<br>' . 'Error: ' . htmlspecialchars($errmsg, ENT_QUOTES);
         }
         $status->setStatusMessage($stat);
         $this->view->assign('status', $status);
     }
     // done with import
 }