public function assignEvaluationAction() { $id = $this->getSanParam('id'); $this->view->assign('id', $id); $evaluation = new Evaluation(); $rows = $evaluation->find($id); $row = $rows->current(); $this->view->assign('evaluation', $row); // restricted access?? only show trainings we have the ACL to view require_once 'views/helpers/TrainingViewHelper.php'; $orgWhere = ''; $org_allowed_ids = allowed_organizer_access($this); if ($org_allowed_ids) { // doesnt have acl 'training_organizer_option_all' $org_allowed_ids = implode(',', $org_allowed_ids); $orgWhere = " training_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 training_organizer_option_id in ({$site_orgs}) " : ""; require_once 'models/table/Training.php'; $tableObj = new Training(); $trainings = $tableObj->getTrainings($orgWhere); $assigned = $evaluation->fetchAssignments($id); foreach ($trainings as $k => $r) { $trainings[$k]['input_checkbox'] = '<input type="checkbox" name="training_ids[]" value="' . $r['training_id'] . '" ' . (array_search($r['training_id'], $assigned) !== false ? ' checked="checked" ' : '') . ' >'; } $this->view->assign('trainings', $trainings); $request = $this->getRequest(); if ($request->isPost()) { $status = ValidationContainer::instance(); $training_ids = $this->getSanParam('training_ids'); $adjusted = array(); foreach ($training_ids as $tr) { $adjusted[$tr] = $tr; } require_once 'models/table/MultiOptionList.php'; MultiOptionList::updateOptions('evaluation_to_training', 'training', 'evaluation_id', $id, 'training_id', $adjusted); $_SESSION['status'] = t('The') . ' ' . t('Trainings') . ' ' . t('have been assigned.'); $status->setStatusMessage(t('The') . ' ' . t('Trainings') . ' ' . t('have been assigned.')); $status->setRedirect('/evaluation/browse'); $this->sendData($status); } }
function allowed_org_access_full_list(&$itechthis) { $orgs = allowed_organizer_access($itechthis); return $orgs ? implode(',', $orgs) : false; }
public function evaluationsReportAction() { require_once 'models/table/Trainer.php'; require_once 'models/table/TrainingLocation.php'; $db = Zend_Db_Table_Abstract::getDefaultAdapter(); //criteria $criteria['showTrainer'] = $this->getSanParam('showTrainer'); $criteria['showCategory'] = $this->getSanParam('showCategory'); $criteria['showTitle'] = $this->getSanParam('showTitle'); $criteria['showLocation'] = $this->getSanParam('showLocation'); $criteria['showOrganizer'] = $this->getSanParam('showOrganizer'); $criteria['showMechanism'] = $this->getSanParam('showMechanism'); $criteria['showTopic'] = $this->getSanParam('showTopic'); $criteria['showLevel'] = $this->getSanParam('showLevel'); $criteria['showPepfar'] = $this->getSanParam('showPepfar'); $criteria['showMethod'] = $this->getSanParam('showMethod'); $criteria['showFunding'] = $this->getSanParam('showFunding'); $criteria['showTOT'] = $this->getSanParam('showTOT'); $criteria['showRefresher'] = $this->getSanParam('showRefresher'); $criteria['showGotCurric'] = $this->getSanParam('showGotCurric'); $criteria['showGotComment'] = $this->getSanParam('showGotComment'); $criteria['showLang1'] = $this->getSanParam('showLang1'); $criteria['showLang2'] = $this->getSanParam('showLang2'); $criteria['showCustom1'] = $this->getSanParam('showCustom1'); $criteria['showCustom2'] = $this->getSanParam('showCustom2'); $criteria['showCustom3'] = $this->getSanParam('showCustom3'); $criteria['showCustom4'] = $this->getSanParam('showCustom4'); $criteria['showCustom5'] = $this->getSanParam('showCustom5'); $criteria['showProvince'] = $this->getSanParam('showProvince'); $criteria['showDistrict'] = $this->getSanParam('showDistrict'); $criteria['showRegionC'] = $this->getSanParam('showRegionC'); $criteria['showRegionD'] = $this->getSanParam('showRegionD'); $criteria['showRegionE'] = $this->getSanParam('showRegionE'); $criteria['showRegionF'] = $this->getSanParam('showRegionF'); $criteria['showRegionG'] = $this->getSanParam('showRegionG'); $criteria['showRegionH'] = $this->getSanParam('showRegionH'); $criteria['showRegionI'] = $this->getSanParam('showRegionI'); $criteria['evaluation_id'] = $this->getSanParam('evaluation_id'); $criteria['trainer_id'] = $this->getSanParam('trainer_id'); $criteria['training_category_id'] = $this->getSanParam('training_category_id'); $criteria['training_title_id'] = $this->getSanParam('training_title_id'); $criteria['training_location_id'] = $this->getSanParam('training_location_id'); $criteria['training_organizer_id'] = $this->getSanParam('training_organizer_id'); $criteria['training_mechanism_id'] = $this->getSanParam('training_mechanism_id'); $criteria['training_topic_id'] = $this->getSanParam('training_topic_id'); $criteria['training_level_id'] = $this->getSanParam('training_level_id'); $criteria['training_pepfar_id'] = $this->getSanParam('training_pepfar_id'); $criteria['training_method_id'] = $this->getSanParam('training_method_id'); $criteria['training_funding_id'] = $this->getSanParam('training_funding_id'); $criteria['training_tot_id'] = $this->getSanParam('training_tot_id'); $criteria['training_refresher_id'] = $this->getSanParam('training_refresher_id'); $criteria['training_got_id'] = $this->getSanParam('training_got_id'); $criteria['training_gotcomment_id'] = $this->getSanParam('training_gotcomment_id'); $criteria['training_lang1_id'] = $this->getSanParam('training_lang1_id'); $criteria['training_lang2_id'] = $this->getSanParam('training_lang2_id'); $criteria['training_custom1_id'] = $this->getSanParam('training_custom1_id'); $criteria['training_custom2_id'] = $this->getSanParam('training_custom2_id'); $criteria['training_custom3_id'] = $this->getSanParam('training_custom3_id'); $criteria['training_custom4_id'] = $this->getSanParam('training_custom4_id'); $criteria['province_id'] = $this->getSanParam('province_id'); $criteria['district_id'] = $this->getSanParam('district_id'); $criteria['region_c_id'] = $this->getSanParam('region_c_id'); $criteria['region_d_id'] = $this->getSanParam('region_d_id'); $criteria['region_e_id'] = $this->getSanParam('region_e_id'); $criteria['region_f_id'] = $this->getSanParam('region_f_id'); $criteria['region_g_id'] = $this->getSanParam('region_g_id'); $criteria['region_h_id'] = $this->getSanParam('region_h_id'); $criteria['region_i_id'] = $this->getSanParam('region_i_id'); $criteria['startdate'] = $this->getSanParam('startdate'); $criteria['enddate'] = $this->getSanParam('enddate'); $criteria['has_response'] = $this->getSanParam('has_response'); $criteria['limit'] = $this->getSanParam('limit'); $criteria['go'] = $this->getSanParam('go'); if ($criteria['go']) { // fields $sql = 'SELECT pt.id as "id", ptc.pcnt, pt.training_start_date, pt.training_end_date, pt.has_known_participants '; // training fields $sql .= ',title, trainer_person_id, first_name, last_name, question_text, question_type, weight, value_text, value_int'; // evaluation fields if ($criteria['showRegionI']) { $sql .= ', pt.region_i_name '; } if ($criteria['showRegionH']) { $sql .= ', pt.region_h_name '; } if ($criteria['showRegionG']) { $sql .= ', pt.region_g_name '; } if ($criteria['showRegionF']) { $sql .= ', pt.region_f_name '; } if ($criteria['showRegionE']) { $sql .= ', pt.region_e_name '; } if ($criteria['showRegionD']) { $sql .= ', pt.region_d_name '; } if ($criteria['showRegionC']) { $sql .= ', pt.region_c_name '; } if ($criteria['showDistrict']) { $sql .= ', pt.district_name '; } if ($criteria['showProvince']) { $sql .= ', pt.province_name '; } if ($criteria['showLocation']) { $sql .= ', pt.training_location_name '; } if ($criteria['showOrganizer']) { $sql .= ', torg.training_organizer_phrase as training_organizer_phrase '; } if ($criteria['showMechanism'] && $this->setting('display_training_partner')) { $sql .= ', organizer_partners.mechanism_id '; } if ($criteria['showLevel']) { $sql .= ', tlev.training_level_phrase '; } if ($criteria['showCategory']) { $sql .= ', tcat.training_category_phrase '; } if ($criteria['showTitle']) { $sql .= ', training_title '; } if ($criteria['showPepfar'] || $criteria['training_pepfar_id'] || $criteria['training_pepfar_id'] === '0') { $sql .= ', GROUP_CONCAT(DISTINCT tpep.pepfar_category_phrase) as "pepfar_category_phrase" '; } if ($criteria['showMethod']) { $sql .= ', tmeth.training_method_phrase '; } if ($criteria['showTopic']) { $sql .= ', GROUP_CONCAT(DISTINCT ttopic.training_topic_phrase ORDER BY training_topic_phrase) AS "training_topic_phrase" '; } if ($criteria['showTOT']) { $sql .= ", IF(is_tot,'" . t('Yes') . "','" . t('No') . "') AS is_tot"; } if ($criteria['showRefresher']) { $sql .= ", IF(is_refresher,'" . t('Yes') . "','" . t('No') . "') AS is_refresher"; } if ($criteria['showLang2']) { $sql .= ', tlos.language_phrase as "secondary_language_phrase" '; } if ($criteria['showLang1']) { $sql .= ', tlop.language_phrase as "primary_language_phrase" '; } if ($criteria['showGotComment']) { $sql .= ", pt.got_comments"; } if ($criteria['showGotCurric']) { $sql .= ', tgotc.training_got_curriculum_phrase '; } if ($criteria['showFunding']) { $sql .= ', GROUP_CONCAT(DISTINCT tfund.funding_phrase ORDER BY funding_phrase) as "funding_phrase" '; } if ($criteria['showCustom1']) { $sql .= ', tqc.custom1_phrase '; } if ($criteria['showCustom2']) { $sql .= ', tqc.custom2_phrase '; } if ($criteria['showCustom3']) { $sql .= ', pt.custom_3'; } if ($criteria['showCustom4']) { $sql .= ', pt.custom_4'; } if ($criteria['showCustom5']) { $sql .= ', pt.custom_5'; } list($dontcare, $location_tier, $location_id) = $this->getLocationCriteriaValues($criteria); $num_location_tiers = $this->setting('num_location_tiers'); list($field_name, $location_sub_query) = Location::subquery($num_location_tiers, $location_tier, $location_id, true); $sql .= ' FROM (SELECT training.*, tto.training_title_phrase AS training_title,training_location.training_location_name, ' . implode(',', $field_name) . ' FROM training ' . ' LEFT JOIN training_title_option tto ON (`training`.training_title_option_id = tto.id) ' . ' LEFT JOIN training_location ON training.training_location_id = training_location.id ' . ' LEFT JOIN (' . $location_sub_query . ') as l ON training_location.location_id = l.id ' . ' WHERE training.is_deleted=0) as pt '; $sql .= ' LEFT JOIN (SELECT COUNT(id) as "pcnt",training_id FROM person_to_training GROUP BY training_id) as ptc ON ptc.training_id = pt.id '; // joins if ($criteria['trainer_id']) { $sql .= ' LEFT JOIN training_to_trainer as t2t ON (t2t.training_id = pt.id AND t2t.trainer_id = ' . $criteria['trainer_id'] . ')'; } if ($criteria['showOrganizer'] or $criteria['training_organizer_id'] || $criteria['showMechanism'] || $criteria['training_mechanism_id']) { $sql .= ' JOIN training_organizer_option as torg ON torg.id = pt.training_organizer_option_id '; } if ($criteria['showMechanism'] || $criteria['training_mechanism_id'] && @$this->setting('display_training_partner')) { $sql .= ' LEFT JOIN organizer_partners ON organizer_partners.organizer_id = torg.id'; } if ($criteria['showLevel'] || $criteria['training_level_id']) { $sql .= ' JOIN training_level_option as tlev ON tlev.id = pt.training_level_option_id '; } if ($criteria['showMethod'] || $criteria['training_method_id']) { $sql .= ' JOIN training_method_option as tmeth ON tmeth.id = pt.training_method_option_id '; } if ($criteria['showPepfar'] || $criteria['training_pepfar_id'] || $criteria['training_pepfar_id'] === '0') { $sql .= ' LEFT JOIN (SELECT training_id, ttpco.training_pepfar_categories_option_id, pepfar_category_phrase FROM training_to_training_pepfar_categories_option as ttpco JOIN training_pepfar_categories_option as tpco ON ttpco.training_pepfar_categories_option_id = tpco.id) as tpep ON tpep.training_id = pt.id '; } if ($criteria['showTopic'] || $criteria['training_topic_id']) { $sql .= ' LEFT JOIN (SELECT training_id, ttto.training_topic_option_id, training_topic_phrase FROM training_to_training_topic_option as ttto JOIN training_topic_option as tto ON ttto.training_topic_option_id = tto.id) as ttopic ON ttopic.training_id = pt.id '; } if ($criteria['showLang1'] || $criteria['training_lang1_id']) { $sql .= ' LEFT JOIN trainer_language_option as tlop ON tlop.id = pt.training_primary_language_option_id '; } if ($criteria['showLang2'] || $criteria['training_lang2_id']) { $sql .= ' LEFT JOIN trainer_language_option as tlos ON tlos.id = pt.training_secondary_language_option_id '; } if ($criteria['showFunding'] || (intval($criteria['funding_min']) or intval($criteria['funding_max']))) { $sql .= ' LEFT JOIN (SELECT training_id, ttfo.training_funding_option_id, funding_phrase, ttfo.funding_amount FROM training_to_training_funding_option as ttfo JOIN training_funding_option as tfo ON ttfo.training_funding_option_id = tfo.id) as tfund ON tfund.training_id = pt.id '; } if ($criteria['showGotCurric'] || $criteria['training_got_id']) { $sql .= ' LEFT JOIN training_got_curriculum_option as tgotc ON tgotc.id = pt.training_got_curriculum_option_id'; } if ($criteria['showCategory'] or !empty($criteria['training_category_id'])) { $sql .= 'LEFT JOIN training_category_option_to_training_title_option tcotto ON (tcotto.training_title_option_id = pt.training_title_option_id) LEFT JOIN training_category_option tcat ON (tcotto.training_category_option_id = tcat.id)'; } if ($criteria['showCustom1'] || $criteria['training_custom1_id']) { $sql .= ' LEFT JOIN training_custom_1_option as tqc ON pt.training_custom_1_option_id = tqc.id '; } if ($criteria['showCustom2'] || $criteria['training_custom2_id']) { $sql .= ' LEFT JOIN training_custom_2_option as tqc2 ON pt.training_custom_2_option_id = tqc2.id '; } #if ( $criteria['showCustom3'] || $criteria ['custom_3_id'] ) #todo$sql .= ' LEFT JOIN training_custom_3_option as custom_3 ON pt.training_custom_3_option_id = tqc3.id '; #if ( $criteria['showCustom4'] || $criteria ['custom_4_id'] ) #todo$sql .= ' LEFT JOIN training_custom_4_option as custom_4 ON pt.training_custom_4_option_id = tqc4.id '; $sql .= ' RIGHT JOIN evaluation_to_training ON pt.id = evaluation_to_training.training_id RIGHT JOIN evaluation ON evaluation_id = evaluation.id RIGHT JOIN evaluation_response ON evaluation_to_training.id = evaluation_response.evaluation_to_training_id RIGHT JOIN evaluation_question ON evaluation.id = evaluation_question.evaluation_id RIGHT JOIN evaluation_question_response ON evaluation_response.id = evaluation_question_response.evaluation_response_id AND evaluation_question.id = evaluation_question_response.evaluation_question_id LEFT JOIN person ON trainer_person_id = person.id '; // where $where = array(' pt.is_deleted=0 '); // restricted access?? only show trainings we have the ACL to view require_once 'views/helpers/TrainingViewHelper.php'; $org_allowed_ids = allowed_organizer_access($this); if ($org_allowed_ids) { // doesnt have acl 'training_organizer_option_all' $org_allowed_ids = implode(',', $org_allowed_ids); $where[] = " pt.training_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[] = " training_organizer_option_id in ({$site_orgs}) "; } if ($criteria['training_participants_type']) { if ($criteria['training_participants_type'] == 'has_known_participants') { $where[] = ' pt.has_known_participants = 1 '; } if ($criteria['training_participants_type'] == 'has_unknown_participants') { $where[] = ' pt.has_known_participants = 0 '; } } if ($criteria['evaluation_id']) { $where[] = ' evaluation.id = ' . $criteria['evaluation_id']; } if ($criteria['trainer_id']) { $where[] = ' trainer_person_id = ' . $criteria['trainer_id']; } if ($criteria['training_location_id']) { $where[] = ' pt.training_location_id = \'' . $criteria['training_location_id'] . '\''; } if ($criteria['training_title_id'] or $criteria['training_title_id'] === '0') { $where[] = ' pt.training_title_option_id = ' . $criteria['training_title_id']; } if ($criteria['training_organizer_id'] or $criteria['training_organizer_id'] === '0') { $where[] = ' pt.training_organizer_option_id = \'' . $criteria['training_organizer_id'] . '\''; } if ($criteria['training_mechanism_id'] or $criteria['training_mechanism_id'] === '0' && $this->setting('display_training_partner')) { $where[] = ' organizer_partners.mechanism_id = \'' . $criteria['training_mechanism_id'] . '\''; } if ($criteria['training_topic_id'] or $criteria['training_topic_id'] === '0') { $where[] = ' ttopic.training_topic_option_id = \'' . $criteria['training_topic_id'] . '\''; } if ($criteria['training_level_id']) { $where[] = ' pt.training_level_option_id = \'' . $criteria['training_level_id'] . '\''; } if ($criteria['training_pepfar_id'] or $criteria['training_pepfar_id'] === '0') { $where[] = ' tpep.training_pepfar_categories_option_id = \'' . $criteria['training_pepfar_id'] . '\''; } if ($criteria['training_method_id'] or $criteria['training_method_id'] === '0') { $where[] = ' tmeth.id = \'' . $criteria['training_method_id'] . '\''; } if ($criteria['training_lang1_id'] or $criteria['training_lang1_id'] === '0') { $where[] = ' pt.training_primary_language_option_id = \'' . $criteria['training_lang1_id'] . '\''; } if ($criteria['training_lang2_id'] or $criteria['training_lang2_id'] === '0') { $where[] = ' pt.training_secondary_language_option_id = \'' . $criteria['training_lang2_id'] . '\''; } if ($criteria['startdate']) { $parts = explode('/', $criteria['startdate']); $reformattedDate = implode('/', array(@$parts[1], @$parts[0], @$parts[2])); // swap month and date (reverse them) $startDate = @date('Y-m-d', @strtotime($reformattedDate)); $parts2 = explode('/', $criteria['enddate']); $reformattedDate = implode('/', array(@$parts2[1], @$parts2[0], @$parts2[2])); // swap month and date (reverse them) $endDate = @date('Y-m-d', @strtotime($reformattedDate)); if (!empty($startDate) && !empty($endDate)) { $where[] = ' training_start_date >= \'' . $startDate . '\' AND training_start_date <= \'' . $endDate . '\' '; } } if (intval($criteria['is_tot'])) { $where[] = ' is_tot = ' . $criteria['is_tot']; } // not used if ($criteria['training_funding_id'] or $criteria['training_funding_id'] === '0') { $where[] = ' tfund.training_funding_option_id = \'' . $criteria['training_funding_id'] . '\''; } if ($criteria['training_category_id'] or $criteria['training_category_id'] === '0') { $where[] = ' tcat.id = \'' . $criteria['training_category_id'] . '\''; } if ($criteria['training_got_id'] or $criteria['training_got_id'] === '0') { $where[] = ' tgotc.id = \'' . $criteria['training_got_id'] . '\''; } if ($criteria['training_custom1_id'] or $criteria['training_custom1_id'] === '0') { $where[] = ' pt.training_custom_1_option_id = \'' . $criteria['training_custom1_id'] . '\''; } if ($criteria['training_custom2_id'] or $criteria['training_custom2_id'] === '0') { $where[] = ' pt.training_custom_2_option_id = \'' . $criteria['training_custom2_id'] . '\''; } if ($criteria['training_custom3_id'] or $criteria['training_custom3_id'] === '0') { $where[] = ' pt.custom_3 = \'' . $criteria['training_custom3_id'] . '\''; } if ($criteria['training_custom4_id'] or $criteria['training_custom4_id'] === '0') { $where[] = ' pt.custom_4 = \'' . $criteria['training_custom4_id'] . '\''; } $where[] = ' evaluation.is_deleted = 0'; $where[] = ' evaluation_response.is_deleted = 0'; $where[] = ' evaluation_question.is_deleted = 0'; $where[] = ' evaluation_question_response.is_deleted = 0'; if ($criteria['has_response']) { $where[] = ' evaluation_response.evaluation_to_training_id IS NOT NULL '; } // finish if ($where) { $sql .= ' WHERE ' . implode(' AND ', $where); } $sql .= ' GROUP BY evaluation_question_response.id'; $rowArray = $db->fetchAll($sql); // end training lookup // output csv if necessary if ($this->_getParam('outputType')) { $this->sendData($this->reportHeaders(false, $rowArray)); } //done } // values for the view $this->viewAssignEscaped('results', $rowArray); $this->view->assign('count', count($rowArray)); $this->view->assign('criteria', $criteria); //evaluations drop down $evaluationsArray = OptionList::suggestionList('evaluation', 'title', false, false, false); $this->viewAssignEscaped('evaluations', $evaluationsArray); //trainers $trainersArray = $db->fetchAll('select p.id,p.first_name,p.middle_name,p.last_name from trainer left join person p on p.id = person_id order by p.first_name asc'); foreach ($trainersArray as $i => $row) { $trainersArray[$i]['fullname'] = $this->setting('display_middle_name_last') ? $row['first_name'] . ' ' . $row['last_name'] . ' ' . $row['middle_name'] : $row['first_name'] . ' ' . $row['middle_name'] . ' ' . $row['last_name']; } $this->viewAssignEscaped('trainers', $trainersArray); //locations $locations = Location::getAll(); $this->viewAssignEscaped('locations', $locations); //course $courseArray = TrainingTitleOption::suggestionList(false, 10000); $this->viewAssignEscaped('courses', $courseArray); //location drop-down $tlocations = TrainingLocation::selectAllLocations($this->setting('num_location_tiers')); $this->viewAssignEscaped('tlocations', $tlocations); //organizers $organizersArray = OptionList::suggestionList('training_organizer_option', 'training_organizer_phrase', false, false, false); $this->viewAssignEscaped('organizers', $organizersArray); //topics $topicsArray = OptionList::suggestionList('training_topic_option', 'training_topic_phrase', false, false, false); $this->viewAssignEscaped('topics', $topicsArray); //levels $levelArray = OptionList::suggestionList('training_level_option', 'training_level_phrase', false, false); $this->viewAssignEscaped('levels', $levelArray); //pepfar $organizersArray = OptionList::suggestionList('training_pepfar_categories_option', 'pepfar_category_phrase', false, false, false); $this->viewAssignEscaped('pepfars', $organizersArray); //refresher if ($this->setting('multi_opt_refresher_course')) { $refresherArray = OptionList::suggestionList('training_refresher_option', 'refresher_phrase_option', false, false, false); $this->viewAssignEscaped('refresher', $refresherArray); } //funding $fundingArray = OptionList::suggestionList('training_funding_option', 'funding_phrase', false, false, false); $this->viewAssignEscaped('funding', $fundingArray); //category $categoryArray = OptionList::suggestionList('training_category_option', 'training_category_phrase', false, false, false); $this->viewAssignEscaped('category', $categoryArray); //primary language $langArray = OptionList::suggestionList('trainer_language_option', 'language_phrase', false, false, false); $this->viewAssignEscaped('language', $langArray); //category+titles $categoryTitle = MultiAssignList::getOptions('training_title_option', 'training_title_phrase', 'training_category_option_to_training_title_option', 'training_category_option'); $this->view->assign('categoryTitle', $categoryTitle); //training methods $methodTitle = OptionList::suggestionList('training_method_option', 'training_method_phrase', false, false, false); $this->view->assign('methods', $methodTitle); //got curric $gotCuriccArray = OptionList::suggestionList('training_got_curriculum_option', 'training_got_curriculum_phrase', false, false, false); $this->viewAssignEscaped('gotcurric', $gotCuriccArray); //mechanism (organizer_partners table) $mechanismArray = array(); if ($this->setting('display_training_partner')) { $mechanismArray = OptionList::suggestionList('organizer_partners', 'mechanism_id', false, false, false, "mechanism_id != ''"); } $this->viewAssignEscaped('mechanisms', $mechanismArray); //customfields $customArray = OptionList::suggestionList('training_custom_1_option', 'custom1_phrase', false, false, false); $this->viewAssignEscaped('custom1', $customArray); $customArray2 = OptionList::suggestionList('training_custom_2_option', 'custom2_phrase', false, false, false); $this->viewAssignEscaped('custom2', $customArray2); $customArray3 = OptionList::suggestionList('training', 'custom_3', false, false, false, "custom_3 != ''"); $this->viewAssignEscaped('custom3', $customArray3); $customArray4 = OptionList::suggestionList('training', 'custom_4', false, false, false, "custom_4 != ''"); $this->viewAssignEscaped('custom4', $customArray4); $customArray5 = OptionList::suggestionList('training', 'custom_5', false, false, false, "custom_5 != ''"); $this->viewAssignEscaped('custom5', $customArray5); #$createdByArray = $db->fetchAll("select id,CONCAT(first_name, CONCAT(' ', last_name)) as name from user where is_blocked = 0"); #$this->viewAssignEscaped ( 'createdBy', $createdByArray ); #// find category based on title #$catId = NULL; #if ($criteria ['training_category_id']) { # foreach ( $categoryTitle as $r ) { # if ($r ['id'] == $criteria ['training_category_id']) { # $catId = $r ['training_category_option_id']; # break; # } # } #} #$this->view->assign ( 'catId', $catId ); //done }