public function Get($pa_additional_query_params = null, $pa_options = null) { $ps_query = $this->request->getParameter('term', pString); $ps_bundle = $this->request->getParameter('bundle', pString); $va_tmp = explode('.', $ps_bundle); $o_dm = Datamodel::load(); if (!($t_table = $o_dm->getInstanceByTableName($va_tmp[0], true))) { // bad table name print _t("Invalid table name"); return null; } $t_element = new ca_metadata_elements(); if (!$t_element->load(array('element_code' => $va_tmp[1]))) { print _t("Invalid element code"); return null; } if ((int) $t_element->getSetting('suggestExistingValues') !== 1) { print _t("Value suggestion is not supported for this metadata element"); return null; } if ($this->request->user->getBundleAccessLevel($va_tmp[0], $va_tmp[1]) == __CA_BUNDLE_ACCESS_NONE__) { print _t("You do not have access to this bundle"); return null; } $va_type_restrictions = $t_element->getTypeRestrictions($t_table->tableNum()); if (!$va_type_restrictions || !is_array($va_type_restrictions) || !sizeof($va_type_restrictions)) { print _t("Element code is not bound to the specified table"); return null; } $o_db = new Db(); switch ($t_element->getSetting('suggestExistingValueSort')) { case 'recent': // date/time entered $vs_sort_field = 'value_id DESC'; $vn_max_returned_values = 10; break; default: // alphabetically $vs_sort_field = 'value_longtext1 ASC'; $vn_max_returned_values = 50; break; } $qr_res = $o_db->query("\n\t\t\t\tSELECT DISTINCT value_longtext1\n\t\t\t\tFROM ca_attribute_values\n\t\t\t\tWHERE\n\t\t\t\t\telement_id = ?\n\t\t\t\t\tAND\n\t\t\t\t\t(value_longtext1 LIKE ?)\n\t\t\t\tORDER BY\n\t\t\t\t\t{$vs_sort_field}\n\t\t\t\tLIMIT {$vn_max_returned_values}\n\t\t\t", (int) $t_element->getPrimaryKey(), (string) $ps_query . '%'); $this->view->setVar('attribute_value_list', $qr_res->getAllFieldValues('value_longtext1')); return $this->render('ajax_attribute_value_list_html.php'); }
public function getElementsAsDOM() { $t_list = new ca_lists(); $vo_elements = $this->opo_dom->createElement("elementSets"); $qr_elements = $this->opo_db->query("SELECT * FROM ca_metadata_elements WHERE parent_id IS NULL ORDER BY element_id"); $t_element = new ca_metadata_elements(); while ($qr_elements->nextRow()) { $vo_element = $this->opo_dom->createElement("metadataElement"); $vo_element->setAttribute("code", $this->makeIDNO($qr_elements->get("element_code"))); $vo_element->setAttribute("datatype", ca_metadata_elements::getAttributeNameForTypeCode($qr_elements->get("datatype"))); if ($qr_elements->get("list_id")) { $t_list->load($qr_elements->get("list_id")); $vo_element->setAttribute("list", $t_list->get("list_code")); } $vo_labels = $this->opo_dom->createElement("labels"); $qr_element_labels = $this->opo_db->query("SELECT * FROM ca_metadata_element_labels WHERE element_id=?", $qr_elements->get("element_id")); while ($qr_element_labels->nextRow()) { $vo_label = $this->opo_dom->createElement("label"); $vo_label->setAttribute("locale", $this->opt_locale->localeIDToCode($qr_element_labels->get("locale_id"))); $vo_label->appendChild($this->opo_dom->createElement("name", caEscapeForXML($qr_element_labels->get("name")))); if (strlen(trim($qr_element_labels->get("description"))) > 0) { $vo_label->appendChild($this->opo_dom->createElement("description", caEscapeForXML($qr_element_labels->get("description")))); } $vo_labels->appendChild($vo_label); } $vo_element->appendChild($vo_labels); $t_element->load($qr_elements->get("element_id")); $va_settings = $t_element->getSettings(); $va_available_settings = $t_element->getAvailableSettings(); if (is_array($va_settings)) { $vo_settings = $this->opo_dom->createElement("settings"); $vb_append_settings_element = false; foreach ($t_element->getSettings() as $vs_setting => $vs_value) { if ($t_element->isValidSetting($vs_setting) && $vs_value != $va_available_settings[$vs_setting]["default"]) { $vo_setting = $this->opo_dom->createElement("setting", $vs_value); $vo_setting->setAttribute("name", $vs_setting); $vo_settings->appendChild($vo_setting); $vb_append_settings_element = true; } } if ($vb_append_settings_element) { $vo_element->appendChild($vo_settings); } } $vo_sub_elements = $this->getElementAsDOM($qr_elements->get("element_id")); if ($vo_sub_elements) { $vo_element->appendChild($vo_sub_elements); } $vo_restrictions = $this->opo_dom->createElement("typeRestrictions"); foreach ($t_element->getTypeRestrictions() as $va_restriction) { /** @var ca_metadata_type_restrictions $t_restriction */ $t_restriction = new ca_metadata_type_restrictions($va_restriction["restriction_id"]); $vs_table_name = $this->opo_dm->getTableName($t_restriction->get("table_num")); if (!(strlen($vs_table_name) > 0)) { continue; } // there could be lingering restrictions for tables that have since been removed. don't export those. $vo_restriction = $this->opo_dom->createElement("restriction"); $vo_table = $this->opo_dom->createElement("table", $vs_table_name); $vo_restriction->appendChild($vo_table); if ($t_restriction->get("type_id")) { /** @var BaseRelationshipModel $t_instance */ $t_instance = $this->opo_dm->getInstanceByTableNum($t_restriction->get("table_num")); $vs_type_code = $t_instance->getTypeListCode(); $va_item = $t_list->getItemFromListByItemID($vs_type_code, $t_restriction->get("type_id")); $vo_type = $this->opo_dom->createElement("type", $va_item["idno"]); $vo_restriction->appendChild($vo_type); } if (isset($va_restriction['include_subtypes']) && (bool) $va_restriction['include_subtypes']) { $vo_include_subtypes = $this->opo_dom->createElement('includeSubtypes', '1'); $vo_restriction->appendChild($vo_include_subtypes); } if (is_array($va_restriction_settings = $t_restriction->getSettings())) { $vo_settings = $this->opo_dom->createElement("settings"); foreach ($va_restriction_settings as $vs_setting => $vs_value) { $vo_setting = $this->opo_dom->createElement("setting", $vs_value); $vo_setting->setAttribute("name", $vs_setting); $vo_settings->appendChild($vo_setting); } $vo_restriction->appendChild($vo_settings); } $vo_restrictions->appendChild($vo_restriction); } $vo_element->appendChild($vo_restrictions); $vo_elements->appendChild($vo_element); } return $vo_elements; }
public function getAvailableSettings($pa_element_info = null) { global $_ca_attribute_settings, $g_request; $va_element_settings = $_ca_attribute_settings['ListAttributeValue']; /* * For the dependent field visibility feature we need to add a select-able list of all applicable * UI bundle placements here ... for each item in that list! */ if (Configuration::load()->get('enable_dependent_field_visibility') && is_array($pa_element_info) && isset($pa_element_info['list_id']) && (!$pa_element_info['settings']['render'] || in_array($pa_element_info['settings']['render'], array('select', 'radio_buttons', 'yes_no_checkboxes'))) && $g_request && $g_request instanceof RequestHTTP) { $va_options_for_settings = array(); $t_mde = new ca_metadata_elements($pa_element_info['element_id']); $va_restrictions = $t_mde->getTypeRestrictions(); $va_tables = array(); if (is_array($va_restrictions) && sizeof($va_restrictions)) { foreach ($va_restrictions as $va_restriction) { $va_tables[] = $va_restriction['table_num']; } } $t_ui = new ca_editor_uis(); foreach (array_unique($va_tables) as $vn_table_num) { // get UIs $va_ui_list = ca_editor_uis::getAvailableUIs($vn_table_num, $g_request); foreach ($va_ui_list as $vn_ui_id => $vs_ui_name) { $t_ui->load($vn_ui_id); // get screens foreach ($t_ui->getScreens() as $va_screen) { // get placements foreach ($t_ui->getScreenBundlePlacements($va_screen['screen_id']) as $va_placement) { $va_options_for_settings[$t_ui->get('editor_code') . '/' . $va_screen['idno'] . '/' . $va_placement['placement_code']] = $t_ui->get('editor_code') . '/' . $va_screen['idno'] . '/' . $va_placement['placement_code']; } } } } $t_list = new ca_lists(); foreach ($t_list->getItemsForList($pa_element_info['list_id']) as $va_items_by_locale) { foreach ($va_items_by_locale as $vn_locale_id => $va_item) { $va_element_settings['hideIfSelected_' . $va_item['idno']] = array('formatType' => FT_TEXT, 'displayType' => DT_SELECT, 'options' => $va_options_for_settings, 'takesLocale' => false, 'default' => '', 'width' => "400px", 'height' => 10, 'label' => _t('Hide bundles if "%1" is selected', $va_item['name_singular']), 'description' => _t('Select bundles from the list below')); } } } elseif (defined('__CollectiveAccess_Installer__') && Configuration::load()->get('enable_dependent_field_visibility')) { // when installing, UIs, screens and placements are not yet available when we process elementSets, so // we just add the hideIfSelected_* as available settings (without actual settings) so that the validation doesn't fail $t_list = new ca_lists(); foreach ($t_list->getItemsForList($pa_element_info['list_id']) as $va_items_by_locale) { foreach ($va_items_by_locale as $vn_locale_id => $va_item) { $va_element_settings['hideIfSelected_' . $va_item['idno']] = true; } } } return $va_element_settings; }