/** * Indexes single row in a table; this is the public call when one needs to index content. * indexRow() will analyze the dependencies of the row being indexed and automatically * apply the indexing of the row to all dependent rows in other tables. (Note that while I call this * a "public" call in fact you shouldn't need to call this directly. BaseModel.php does this for you * during insert() and update().) * * For example, if you are indexing a row in table 'entities', then indexRow() * will automatically apply the indexing not just to the entities record, but also * to all objects, place_names, occurrences, lots, etc. that reference the entity. * The dependencies are configured in the search_indices.conf configuration file. * * "subject" tablenum/row_id refer to the row **to which the indexing is being applied**. This may be the row being indexed * or it may be a dependent row. The "content" tablenum/fieldnum/row_id parameters define the specific row and field being indexed. * This is always the actual row being indexed. $pm_content is the content to be indexed and $pa_options is an optional associative * array of indexing options passed through from the search_indices.conf (no options are defined yet - but will be soon) */ public function indexRow($pn_subject_tablenum, $pn_subject_row_id, $pa_field_data, $pb_reindex_mode = false, $pa_exclusion_list = null, $pa_changed_fields = null, $pa_old_values = null, $pa_options = null) { if (!$pb_reindex_mode && is_array($pa_changed_fields) && !sizeof($pa_changed_fields)) { return; } // don't bother indexing if there are no changed fields $vs_subject_tablename = $this->opo_datamodel->getTableName($pn_subject_tablenum); $t_subject = $this->getTableInstance($vs_subject_tablename, true); // Prevent endless recursive reindexing if (is_array($pa_exclusion_list[$pn_subject_tablenum]) && isset($pa_exclusion_list[$pn_subject_tablenum][$pn_subject_row_id])) { return; } $vb_reindex_children = false; $vs_subject_pk = $t_subject->primaryKey(); if (!is_array($pa_changed_fields)) { $pa_changed_fields = array(); } foreach ($pa_changed_fields as $vs_k => $vb_bool) { if (!isset($pa_field_data[$vs_k])) { $pa_field_data[$vs_k] = null; } } $vb_can_do_incremental_indexing = $this->opo_engine->can('incremental_reindexing') ? true : false; // can the engine do incremental indexing? Or do we need to reindex the entire row every time? foreach ($this->opo_search_config->get('search_indexing_replacements') as $vs_to_replace => $vs_replacement) { foreach ($pa_field_data as $vs_k => &$vs_value) { if ($vs_replacement == "nothing") { $vs_replacement = ""; } $vs_value = str_replace($vs_to_replace, $vs_replacement, $vs_value); } } if (!$pa_exclusion_list) { $pa_exclusion_list = array(); } $pa_exclusion_list[$pn_subject_tablenum][$pn_subject_row_id] = true; // // index fields in subject table itself // $va_fields_to_index = $this->getFieldsToIndex($pn_subject_tablenum); if (is_array($va_fields_to_index)) { foreach ($va_fields_to_index as $vs_k => $va_data) { if (preg_match('!^ca_attribute_(.*)$!', $vs_k, $va_matches)) { if (!is_numeric($va_matches[1])) { if ($vn_x = $this->_getElementID($va_matches[1])) { $va_matches[1] = $vn_x; } else { unset($va_fields_to_index[$vs_k]); continue; } } unset($va_fields_to_index[$vs_k]); if ($va_data['DONT_INDEX']) { // remove attribute from indexing list unset($va_fields_to_index['_ca_attribute_' . $va_matches[1]]); } else { $va_fields_to_index['_ca_attribute_' . $va_matches[1]] = $va_data; } } } } // // If location in hierarchy has changed we need to reindex this record and all of its children // if ($t_subject->isHierarchical() && isset($pa_changed_fields['parent_id']) && $pa_changed_fields['parent_id'] && method_exists($t_subject, "makeSearchResult")) { $pb_reindex_mode = true; $vb_reindex_children = true; } $vb_started_indexing = false; if (is_array($va_fields_to_index)) { $this->opo_engine->startRowIndexing($pn_subject_tablenum, $pn_subject_row_id); $vb_started_indexing = true; foreach ($va_fields_to_index as $vs_field => $va_data) { if (substr($vs_field, 0, 14) === '_ca_attribute_') { // // Is attribute // $vs_v = $pa_field_data[$vs_field]; if (!preg_match('!^_ca_attribute_(.*)$!', $vs_field, $va_matches)) { continue; } if ($vb_can_do_incremental_indexing && !$pb_reindex_mode && (!isset($pa_changed_fields[$vs_field]) || !$pa_changed_fields[$vs_field])) { continue; // skip unchanged attribute value } if ($va_data['DONT_INDEX'] && is_array($va_data['DONT_INDEX'])) { $vb_cont = false; foreach ($va_data["DONT_INDEX"] as $vs_exclude_type) { if ($this->_getElementID($vs_exclude_type) == intval($va_matches[1])) { $vb_cont = true; break; } } if ($vb_cont) { continue; } // skip excluded attribute type } $va_data['datatype'] = (int) $this->_getElementDataType($va_matches[1]); switch ($va_data['datatype']) { case 0: // container // index components of complex multi-value attributes $va_attributes = $t_subject->getAttributesByElement($va_matches[1], array('row_id' => $pn_subject_row_id)); if (sizeof($va_attributes)) { foreach ($va_attributes as $vo_attribute) { /* index each element of the container */ foreach ($vo_attribute->getValues() as $vo_value) { $vn_list_id = $this->_getElementListID($vo_value->getElementID()); $this->opo_engine->indexField($pn_subject_tablenum, 'A' . $vo_value->getElementID(), $vo_attribute->getAttributeID(), $vo_value->getDisplayValue($vn_list_id), $va_data); } } } else { // we are deleting a container so cleanup existing sub-values $va_sub_elements = $this->opo_metadata_element->getElementsInSet($va_matches[1]); foreach ($va_sub_elements as $vn_i => $va_element_info) { $this->opo_engine->indexField($pn_subject_tablenum, 'A' . $va_element_info['element_id'], $va_element_info['element_id'], '', $va_data); } } break; case 3: // list // We pull the preferred labels of list items for indexing here. We do so for all languages. Note that // this only done for list attributes that are standalone and not a sub-element in a container. Perhaps // we should also index the text of sub-element lists, but it's not clear that it is a good idea yet. The list_id's of // sub-elements *are* indexed however, so advanced search forms passing ids instead of text will work. $va_tmp = array(); if (is_array($va_attributes = $t_subject->getAttributesByElement($va_matches[1], array('row_id' => $pn_subject_row_id)))) { foreach ($va_attributes as $vo_attribute) { foreach ($vo_attribute->getValues() as $vo_value) { $va_tmp[$vo_attribute->getAttributeID()] = $vo_value->getDisplayValue(); } } } $va_new_values = array(); $t_item = new ca_list_items(); $va_labels = $t_item->getPreferredDisplayLabelsForIDs($va_tmp, array('returnAllLocales' => true)); foreach ($va_labels as $vn_row_id => $va_labels_per_row) { foreach ($va_labels_per_row as $vn_locale_id => $va_label_list) { foreach ($va_label_list as $vs_label) { $va_new_values[$vn_row_id][$vs_label] = true; } } } foreach ($va_tmp as $vn_attribute_id => $vn_item_id) { if (!$vn_item_id) { continue; } if (!isset($va_new_values[$vn_item_id]) || !is_array($va_new_values[$vn_item_id])) { continue; } $vs_v = join(' ; ', array_merge(array($vn_item_id), array_keys($va_new_values[$vn_item_id]))); $this->opo_engine->indexField($pn_subject_tablenum, 'A' . $va_matches[1], $vn_attribute_id, $vs_v, $va_data); } break; default: $va_attributes = $t_subject->getAttributesByElement($va_matches[1], array('row_id' => $pn_subject_row_id)); if (!is_array($va_attributes)) { break; } foreach ($va_attributes as $vo_attribute) { foreach ($vo_attribute->getValues() as $vo_value) { //if the field is a daterange type get content from start and end fields $va_field_list = $t_subject->getFieldsArray(); if (in_array($va_field_list[$vs_field]['FIELD_TYPE'], array(FT_DATERANGE, FT_HISTORIC_DATERANGE))) { $start_field = $va_field_list[$vs_field]['START']; $end_field = $va_field_list[$vs_field]['END']; $pn_content = $pa_field_data[$start_field] . " - " . $pa_field_data[$end_field]; } else { $pn_content = $vo_value->getDisplayValue(); } $this->opo_engine->indexField($pn_subject_tablenum, 'A' . $va_matches[1], $vo_attribute->getAttributeID(), $pn_content, $va_data); } } break; } } else { // // Plain old field // if ($vb_can_do_incremental_indexing && !$pb_reindex_mode && !isset($pa_changed_fields[$vs_field]) && $vs_field != $vs_subject_pk) { // skip unchanged continue; } if (!($vn_fld_num = $t_subject->fieldNum($vs_field))) { continue; } // // Hierarchical indexing in primary table // if (isset($va_data['INDEX_ANCESTORS']) && $va_data['INDEX_ANCESTORS'] || in_array('INDEX_ANCESTORS', $va_data)) { if ($t_subject && $t_subject->isHierarchical()) { $vn_fld_num = $t_subject->fieldNum($vs_field); if ($va_hier_values = $this->_genHierarchicalPath($pn_subject_row_id, $vs_field, $t_subject, $va_data)) { $this->opo_engine->indexField($pn_subject_tablenum, 'I' . $vn_fld_num, $pn_subject_row_id, join(" ", $va_hier_values['values']), $va_data); if (caGetOption('INDEX_ANCESTORS_AS_PATH_WITH_DELIMITER', $va_data, false) !== false) { $this->opo_engine->indexField($pn_subject_tablenum, 'I' . $vn_fld_num, $pn_subject_row_id, $va_hier_values['path'], array_merge($va_data, array('DONT_TOKENIZE' => 1))); } } $va_children_ids = $t_subject->getHierarchyAsList($pn_subject_row_id, array('idsOnly' => true)); if (!$pb_reindex_mode && is_array($va_children_ids) && sizeof($va_children_ids) > 0) { // trigger reindexing of children $o_indexer = new SearchIndexer($this->opo_db); $qr_children_res = $t_subject->makeSearchResult($vs_subject_tablename, $va_children_ids); while ($qr_children_res->nextHit()) { $o_indexer->indexRow($pn_subject_tablenum, $vn_id = $qr_children_res->get($vs_subject_pk), array($vs_subject_pk => $vn_id, 'parent_id' => $qr_children_res->get('parent_id'), $vs_field => $qr_children_res->get($vs_field)), false, $pa_exclusion_list, array($vs_field => true), null); } } continue; } } // specialized identifier (idno) processing; used IDNumbering plugin to generate searchable permutations of identifier if ((isset($va_data['INDEX_AS_IDNO']) && $va_data['INDEX_AS_IDNO'] || in_array('INDEX_AS_IDNO', $va_data)) && method_exists($t_subject, "getIDNoPlugInInstance") && ($o_idno = $t_subject->getIDNoPlugInInstance())) { $va_values = $o_idno->getIndexValues($pa_field_data[$vs_field]); $vn_fld_num = $t_subject->fieldNum($vs_field); $this->opo_engine->indexField($pn_subject_tablenum, 'I' . $vn_fld_num, $pn_subject_row_id, join(" ", $va_values), $va_data); continue; } $va_field_list = $t_subject->getFieldsArray(); if (in_array($va_field_list[$vs_field]['FIELD_TYPE'], array(FT_DATERANGE, FT_HISTORIC_DATERANGE))) { // if the field is a daterange type get content from start and end fields $start_field = $va_field_list[$vs_field]['START']; $end_field = $va_field_list[$vs_field]['END']; $pn_content = $pa_field_data[$start_field] . " - " . $pa_field_data[$end_field]; } else { $va_content = array(); if (isset($va_field_list[$vs_field]['LIST_CODE']) && $va_field_list[$vs_field]['LIST_CODE']) { // Is reference to list item so index preferred label values $t_item = new ca_list_items((int) $pa_field_data[$vs_field]); $va_labels = $t_item->getPreferredDisplayLabelsForIDs(array((int) $pa_field_data[$vs_field]), array('returnAllLocales' => true)); foreach ($va_labels as $vn_label_row_id => $va_labels_per_row) { foreach ($va_labels_per_row as $vn_locale_id => $va_label_list) { foreach ($va_label_list as $vs_label) { $va_content[$vs_label] = true; } } } $va_content[$t_item->get('idno')] = true; } else { // is this field related to something? if (is_array($va_rels = $this->opo_datamodel->getManyToOneRelations($vs_subject_tablename)) && $va_rels[$vs_field]) { if (isset($va_rels[$vs_field])) { if ($pa_changed_fields[$vs_field]) { $pb_reindex_mode = true; // trigger full reindex of record so it reflects text of related item (if so indexed) } } $this->opo_engine->indexField($pn_subject_tablenum, 'I' . $vn_fld_num, $pn_subject_row_id, $pn_content, $va_data); } } $va_content[$pa_field_data[$vs_field]] = true; $this->opo_engine->indexField($pn_subject_tablenum, 'I' . $vn_fld_num, $pn_subject_row_id, join(" ", array_keys($va_content)), $va_data); continue; } $this->opo_engine->indexField($pn_subject_tablenum, 'I' . $vn_fld_num, $pn_subject_row_id, $pn_content, $va_data); } } } // ------------------------------------- // // index related fields // // Here's where we generate indexing on the subject from content in related rows (data stored externally to the subject row) // If the underlying engine doesn't support incremental indexing (if it can't change existing indexing for a row in-place, in other words) // then we need to do this every time we update the indexing for a row; if the engine *does* support incremental indexing then // we can just update the existing indexing with content from the changed fields. // // We also do this indexing if we're in "reindexing" mode. When reindexing is indicated it means that we need to act as if // we're indexing this row for the first time, and all indexing should be performed. if (!$vb_can_do_incremental_indexing || $pb_reindex_mode) { if (is_array($va_related_tables = $this->getRelatedIndexingTables($pn_subject_tablenum))) { if (!$vb_started_indexing) { $this->opo_engine->startRowIndexing($pn_subject_tablenum, $pn_subject_row_id); $vb_started_indexing = true; } foreach ($va_related_tables as $vs_related_table) { $vn_related_tablenum = $this->opo_datamodel->getTableNum($vs_related_table); $vs_related_pk = $this->opo_datamodel->getTablePrimaryKeyName($vn_related_tablenum); $t_rel = $this->opo_datamodel->getInstanceByTableNum($vn_related_tablenum, true); $va_fields_to_index = $this->getFieldsToIndex($pn_subject_tablenum, $vs_related_table); $va_table_info = $this->getTableIndexingInfo($pn_subject_tablenum, $vs_related_table); $va_field_list = array_keys($va_fields_to_index); $va_table_list_list = array(); //$va_table_info['tables']; $va_table_key_list = array(); //$va_table_info['keys']; if (isset($va_table_info['key']) && $va_table_info['key']) { $va_table_list_list = array('key' => array($vs_related_table)); $va_table_key_list = array(); } else { if ($pb_reindex_mode || !$vb_can_do_incremental_indexing) { $va_table_list_list = isset($va_table_info['tables']) ? $va_table_info['tables'] : null; $va_table_key_list = isset($va_table_info['keys']) ? $va_table_info['keys'] : null; } } if (!is_array($va_table_list_list) || !sizeof($va_table_list_list)) { continue; } //$va_table_list_list = array($vs_related_table => array()); } foreach ($va_table_list_list as $vs_list_name => $va_linking_tables) { array_push($va_linking_tables, $vs_related_table); $vs_left_table = $vs_subject_tablename; $va_joins = array(); foreach ($va_linking_tables as $vs_right_table) { if (is_array($va_table_key_list) && (isset($va_table_key_list[$vs_list_name][$vs_right_table][$vs_left_table]) || isset($va_table_key_list[$vs_list_name][$vs_left_table][$vs_right_table]))) { // are the keys for this join specified in the indexing config? if (isset($va_table_key_list[$vs_list_name][$vs_left_table][$vs_right_table])) { $va_key_spec = $va_table_key_list[$vs_list_name][$vs_left_table][$vs_right_table]; $vs_join = 'INNER JOIN ' . $vs_right_table . ' ON (' . $vs_right_table . '.' . $va_key_spec['right_key'] . ' = ' . $vs_left_table . '.' . $va_key_spec['left_key']; if ($va_key_spec['left_table_num'] || $va_key_spec['right_table_num']) { if ($va_key_spec['right_table_num']) { $vs_join .= ' AND ' . $vs_right_table . '.' . $va_key_spec['right_table_num'] . ' = ' . $this->opo_datamodel->getTableNum($vs_left_table); } else { $vs_join .= ' AND ' . $vs_left_table . '.' . $va_key_spec['left_table_num'] . ' = ' . $this->opo_datamodel->getTableNum($vs_right_table); } } $vs_join .= ")"; } else { $va_key_spec = $va_table_key_list[$vs_list_name][$vs_right_table][$vs_left_table]; $vs_join = 'INNER JOIN ' . $vs_right_table . ' ON (' . $vs_right_table . '.' . $va_key_spec['left_key'] . ' = ' . $vs_left_table . '.' . $va_key_spec['right_key']; if ($va_key_spec['left_table_num'] || $va_key_spec['right_table_num']) { if ($va_key_spec['right_table_num']) { $vs_join .= ' AND ' . $vs_left_table . '.' . $va_key_spec['right_table_num'] . ' = ' . $this->opo_datamodel->getTableNum($vs_right_table); } else { $vs_join .= ' AND ' . $vs_right_table . '.' . $va_key_spec['left_table_num'] . ' = ' . $this->opo_datamodel->getTableNum($vs_left_table); } } $vs_join .= ")"; } $va_joins[] = $vs_join; } else { if ($va_rel = $this->opo_datamodel->getOneToManyRelations($vs_left_table, $vs_right_table)) { $va_joins[] = 'INNER JOIN ' . $va_rel['many_table'] . ' ON ' . $va_rel['one_table'] . '.' . $va_rel['one_table_field'] . ' = ' . $va_rel['many_table'] . '.' . $va_rel['many_table_field']; } else { if ($va_rel = $this->opo_datamodel->getOneToManyRelations($vs_right_table, $vs_left_table)) { $va_joins[] = 'INNER JOIN ' . $va_rel['one_table'] . ' ON ' . $va_rel['one_table'] . '.' . $va_rel['one_table_field'] . ' = ' . $va_rel['many_table'] . '.' . $va_rel['many_table_field']; } } } $vs_left_table = $vs_right_table; } $va_proc_field_list = array(); $vn_field_list_count = sizeof($va_field_list); for ($vn_i = 0; $vn_i < $vn_field_list_count; $vn_i++) { if ($va_field_list[$vn_i] == '_count') { continue; } if (substr($va_field_list[$vn_i], 0, 14) === '_ca_attribute_') { continue; } if (!trim($va_field_list[$vn_i])) { continue; } $va_proc_field_list[$vn_i] = $vs_related_table . '.' . $va_field_list[$vn_i]; } $va_proc_field_list[] = $vs_related_table . '.' . $vs_related_pk; if (isset($va_rel['many_table']) && $va_rel['many_table']) { $va_proc_field_list[] = $va_rel['many_table'] . '.' . $va_rel['many_table_field']; } $vs_sql = "\n\t\t\t\t\t\tSELECT " . join(",", $va_proc_field_list) . "\n\t\t\t\t\t\tFROM " . $vs_subject_tablename . "\n\t\t\t\t\t\t" . join("\n", $va_joins) . "\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t(" . $vs_subject_tablename . '.' . $vs_subject_pk . ' = ?) '; $qr_res = $this->opo_db->query($vs_sql, $pn_subject_row_id); if ($this->opo_db->numErrors()) { // Shouldn't ever happen throw new Exception(_t("SQL error while getting content for index of related fields: %1; SQL was %2", $this->opo_db->getErrors(), $vs_sql)); } while ($qr_res->nextRow()) { $va_field_data = $qr_res->getRow(); $vn_row_id = $qr_res->get($vs_related_pk); foreach ($va_fields_to_index as $vs_rel_field => $va_rel_field_info) { // // BEGIN: Index attributes in related tables // $vb_is_attr = false; if (substr($vs_rel_field, 0, 14) === '_ca_attribute_') { if (!preg_match('!^_ca_attribute_(.*)$!', $vs_rel_field, $va_matches)) { continue; } if ($va_rel_field_info['DONT_INDEX'] && is_array($va_rel_field_info['DONT_INDEX'])) { $vb_cont = false; foreach ($va_rel_field_info["DONT_INDEX"] as $vs_exclude_type) { if ($this->_getElementID($vs_exclude_type) == intval($va_matches[1])) { $vb_cont = true; break; } } if ($vb_cont) { continue; } // skip excluded attribute type } $vb_is_attr = true; $va_rel_field_info['datatype'] = (int) $this->_getElementDataType($va_matches[1]); switch ($va_rel_field_info['datatype']) { case 0: // container // index components of complex multi-value attributes $va_attributes = $t_rel->getAttributesByElement($va_matches[1], array('row_id' => $vn_row_id)); if (sizeof($va_attributes)) { foreach ($va_attributes as $vo_attribute) { foreach ($vo_attribute->getValues() as $vo_value) { $vn_list_id = $this->_getElementListID($vo_value->getElementID()); $this->opo_engine->indexField($vn_related_tablenum, 'A' . $vo_value->getElementID(), $vo_attribute->getAttributeID(), $vo_value->getDisplayValue($vn_list_id), $va_rel_field_info); // 4 = ca_attributes } } } else { // we are deleting a container so cleanup existing sub-values $va_sub_elements = $this->opo_metadata_element->getElementsInSet($va_matches[1]); foreach ($va_sub_elements as $vn_i => $va_element_info) { $this->opo_engine->indexField($vn_related_tablenum, 'A' . $va_element_info['element_id'], $va_element_info['element_id'], '', $va_rel_field_info); } } break; case 3: // list // We pull the preferred labels of list items for indexing here. We do so for all languages. Note that // this only done for list attributes that are standalone and not a sub-element in a container. Perhaps // we should also index the text of sub-element lists, but it's not clear that it is a good idea yet. The list_id's of // sub-elements *are* indexed however, so advanced search forms passing ids instead of text will work. $va_tmp = array(); if (is_array($va_attributes = $t_rel->getAttributesByElement($va_matches[1], array('row_id' => $vn_row_id)))) { foreach ($va_attributes as $vo_attribute) { foreach ($vo_attribute->getValues() as $vo_value) { $va_tmp[$vo_attribute->getAttributeID()] = $vo_value->getDisplayValue(); } } } $va_new_values = array(); $t_item = new ca_list_items(); $va_labels = $t_item->getPreferredDisplayLabelsForIDs($va_tmp, array('returnAllLocales' => true)); foreach ($va_labels as $vn_label_row_id => $va_labels_per_row) { foreach ($va_labels_per_row as $vn_locale_id => $va_label_list) { foreach ($va_label_list as $vs_label) { $va_new_values[$vn_label_row_id][$vs_label] = true; } } } foreach ($va_tmp as $vn_attribute_id => $vn_item_id) { if (!$vn_item_id) { continue; } if (!isset($va_new_values[$vn_item_id]) || !is_array($va_new_values[$vn_item_id])) { continue; } $vs_v = join(' ; ', array_merge(array($vn_item_id), array_keys($va_new_values[$vn_item_id]))); $this->opo_engine->indexField($vn_related_tablenum, 'A' . $va_matches[1], $vn_attribute_id, $vs_v, $va_rel_field_info); } break; default: $va_attributes = $t_rel->getAttributesByElement($va_matches[1], array('row_id' => $vn_row_id)); if (!is_array($va_attributes)) { break; } foreach ($va_attributes as $vo_attribute) { foreach ($vo_attribute->getValues() as $vo_value) { $pn_content = $vo_value->getDisplayValue(); $this->opo_engine->indexField($vn_related_tablenum, 'A' . $va_matches[1], $vo_attribute->getAttributeID(), $pn_content, $va_rel_field_info); } } break; } } $vs_fld_data = trim($va_field_data[$vs_rel_field]); // // Hierarchical indexing in related tables // if (isset($va_rel_field_info['INDEX_ANCESTORS']) && $va_rel_field_info['INDEX_ANCESTORS'] || in_array('INDEX_ANCESTORS', $va_rel_field_info)) { // is this current field a label? $t_hier_rel = $t_rel; $vn_fld_num = $t_rel->fieldNum($vs_rel_field); $vn_id = $vn_row_id; $vb_is_label = false; if (is_subclass_of($t_hier_rel, "BaseLabel")) { $t_hier_rel->load($vn_row_id); $t_hier_rel = $t_hier_rel->getSubjectTableInstance(); $vn_id = $t_hier_rel->getPrimaryKey(); $vb_is_label = true; } if ($t_hier_rel && $t_hier_rel->isHierarchical()) { // get hierarchy if ($va_hier_values = $this->_genHierarchicalPath($vn_id, $vb_is_label ? "preferred_labels." . $vs_rel_field : $vs_rel_field, $t_hier_rel, $va_rel_field_info)) { $this->opo_engine->indexField($vn_related_tablenum, 'I' . $vn_fld_num, $vn_id, $vs_fld_data . ' ' . join(" ", $va_hier_values['values']), $va_rel_field_info); if (caGetOption('INDEX_ANCESTORS_AS_PATH_WITH_DELIMITER', $va_rel_field_info, false) !== false) { $this->opo_engine->indexField($vn_related_tablenum, 'I' . $vn_fld_num, $vn_id, $va_hier_values['path'], array_merge($va_rel_field_info, array('DONT_TOKENIZE' => 1))); } } $va_children_ids = $t_hier_rel->getHierarchyAsList($vn_row_id, array('idsOnly' => true)); if (!$pb_reindex_mode && is_array($va_children_ids) && sizeof($va_children_ids) > 0) { // trigger reindexing of children $o_indexer = new SearchIndexer($this->opo_db); $qr_children_res = $t_hier_rel->makeSearchResult($t_hier_rel->tableName(), $va_children_ids); $vs_pk = $t_hier_rel->primaryKey(); $vn_table_num = $t_hier_rel->tableNum(); while ($qr_children_res->nextHit()) { $vn_id = $qr_children_res->get($vs_pk); if ($vn_id == $vn_row_id) { continue; } $o_indexer->indexRow($vn_table_num, $vn_id, array($vs_pk => $vn_id, 'parent_id' => $qr_children_res->get('parent_id'), $vs_rel_field => $qr_children_res->get($vs_rel_field)), false, $pa_exclusion_list, array($vs_rel_field => true), null); } } continue; } } switch ($vs_rel_field) { case '_count': // noop break; default: if ($vb_is_attr) { $this->opo_engine->indexField($vn_related_tablenum, 'A' . $va_matches[1], $qr_res->get($vs_related_pk), $vs_fld_data, $va_rel_field_info); } else { $this->opo_engine->indexField($vn_related_tablenum, 'I' . $this->opo_datamodel->getFieldNum($vs_related_table, $vs_rel_field), $qr_res->get($vs_related_pk), $vs_fld_data, $va_rel_field_info); } break; } // // END: Index attributes in related tables // } } //if (isset($va_fields_to_index['_count'])) { //$this->opo_engine->indexField($pn_subject_tablenum, '_count', $pn_subject_row_id, $qr_res->numRows(), array()); //} } } } } // save indexing on subject if ($vb_started_indexing) { $this->opo_engine->commitRowIndexing(); } if (!$pb_reindex_mode && sizeof($pa_changed_fields) > 0) { // // When not reindexing then we consider the effect of the change on this row upon related rows that use it // in their indexing. This means figuring out which related tables have indexing that depend upon the subject row. // // We deal with this by pulling up a dependency map generated from the search_indexing.conf file and then reindexing // those rows // $va_deps = $this->getDependencies($vs_subject_tablename); $va_changed_field_nums = array(); foreach (array_keys($pa_changed_fields) as $vs_f) { if ($t_subject->hasField($vs_f)) { $va_changed_field_nums[$vs_f] = 'I' . $t_subject->fieldNum($vs_f); } else { if (preg_match('!^_ca_attribute_([\\d]+)$!', $vs_f, $va_matches)) { $va_changed_field_nums[$vs_f] = 'A' . $this->_getElementListCode($va_matches[1]); } } } // // reindex rows in dependent tables that use the subject_row_id // $va_rows_to_reindex = $this->_getDependentRowsForSubject($pn_subject_tablenum, $pn_subject_row_id, $va_deps, $va_changed_field_nums); if ($vb_can_do_incremental_indexing) { $va_rows_to_reindex_by_row_id = array(); foreach ($va_rows_to_reindex as $vs_key => $va_row_to_reindex) { foreach ($va_row_to_reindex['field_nums'] as $vs_fld_name => $vn_fld_num) { $vs_new_key = $va_row_to_reindex['table_num'] . '/' . $va_row_to_reindex['field_table_num'] . '/' . $vn_fld_num . '/' . $va_row_to_reindex['field_row_id']; if (!isset($va_rows_to_reindex_by_row_id[$vs_new_key])) { $va_rows_to_reindex_by_row_id[$vs_new_key] = array('table_num' => $va_row_to_reindex['table_num'], 'row_ids' => array(), 'field_table_num' => $va_row_to_reindex['field_table_num'], 'field_num' => $vn_fld_num, 'field_name' => $vs_fld_name, 'field_row_id' => $va_row_to_reindex['field_row_id'], 'field_values' => $va_row_to_reindex['field_values'], 'indexing_info' => $va_row_to_reindex['indexing_info'][$vs_fld_name]); } $va_rows_to_reindex_by_row_id[$vs_new_key]['row_ids'][] = $va_row_to_reindex['row_id']; } } $o_indexer = new SearchIndexer($this->opo_db); foreach ($va_rows_to_reindex_by_row_id as $va_row_to_reindex) { if ($va_row_to_reindex['field_table_num'] === 4) { // is attribute $va_row_to_reindex['indexing_info']['datatype'] = $this->_getElementDataType($va_row_to_reindex['field_num']); } if (isset($va_row_to_reindex['indexing_info']['INDEX_ANCESTORS']) && $va_row_to_reindex['indexing_info']['INDEX_ANCESTORS'] || in_array('INDEX_ANCESTORS', $va_row_to_reindex['indexing_info'])) { if (!is_array($va_row_to_reindex['row_ids'])) { continue; } $va_content = $this->_genHierarchicalPath($va_row_to_reindex['field_row_id'], $va_row_to_reindex['field_name'], $this->opo_datamodel->getInstanceByTableNum($va_row_to_reindex['field_table_num'], true), array()); $vs_content = is_array($va_content['values']) ? join(" ", $va_content['values']) : ""; $this->opo_engine->updateIndexingInPlace($va_row_to_reindex['table_num'], $va_row_to_reindex['row_ids'], $va_row_to_reindex['field_table_num'], $va_row_to_reindex['field_num'], $va_row_to_reindex['field_row_id'], $vs_content, array_merge($va_row_to_reindex['indexing_info'], array('literalContent' => $va_content['path']))); // // THE FOLLOWING CODE IS TOO SLOW - updateIndexingInPlace() call following the commented-out block of code // replaces this and is much faster... but we need to validate that it works reliably // // foreach($va_row_to_reindex['row_ids'] as $vn_row_to_reindex_id) { // if ($t_dep = $this->getTableInstance($va_row_to_reindex['table_num'], true)) { // $va_dep_ids = $t_dep->getHierarchyAsList($vn_row_to_reindex_id, array('idsOnly' => true, 'includeSelf' => true)); // // $va_dep_values = BaseModel::getFieldValueArraysForIDs($va_dep_ids, $t_dep->tableName()); // // foreach($va_dep_values as $vn_dep_id => $va_dep_value) { // $o_indexer->indexRow($va_row_to_reindex['table_num'], $vn_dep_id, $va_dep_value, true, $pa_exclusion_list, null, null); // } // } // } } else { $this->opo_engine->updateIndexingInPlace($va_row_to_reindex['table_num'], $va_row_to_reindex['row_ids'], $va_row_to_reindex['field_table_num'], $va_row_to_reindex['field_num'], $va_row_to_reindex['field_row_id'], $va_row_to_reindex['field_values'][$va_row_to_reindex['field_name']], $va_row_to_reindex['indexing_info']); } } } else { // // If the underlying engine doesn't support incremental indexing then // we fall back to reindexing each dependenting row completely and independently. // This can be *really* slow for subjects with many dependent rows (for example, a ca_list_item value used as a type for many ca_objects rows) // and we need to think about how to optimize this for such engines; ultimately since no matter how you slice it in such // engines you're going to have a lot of reindexing going on, we may just have to construct a facility to handle large // indexing tasks in a separate process when the number of dependent rows exceeds a certain threshold // $o_indexer = new SearchIndexer($this->opo_db); foreach ($va_rows_to_reindex as $va_row_to_reindex) { if (!$t_dep || $t_dep->tableNum() != $va_row_to_reindex['table_num']) { $t_dep = $this->opo_datamodel->getInstanceByTableNum($va_row_to_reindex['table_num']); } $vb_support_attributes = is_subclass_of($t_dep, 'BaseModelWithAttributes') ? true : false; if (is_array($pa_exclusion_list[$va_row_to_reindex['table_num']]) && isset($pa_exclusion_list[$va_row_to_reindex['table_num']][$va_row_to_reindex['row_id']])) { continue; } // trigger reindexing if ($vb_support_attributes) { if ($t_dep->load($va_row_to_reindex['row_id'])) { // $o_indexer->indexRow($va_row_to_reindex['table_num'], $va_row_to_reindex['row_id'], $t_dep->getFieldValuesArray(), true, $pa_exclusion_list); } } else { $o_indexer->indexRow($va_row_to_reindex['table_num'], $va_row_to_reindex['row_id'], $va_row_to_reindex['field_values'], true, $pa_exclusion_list); } } $o_indexer = null; } } if ($vb_reindex_children && method_exists($t_subject, "makeSearchResult")) { // // Force reindexing of children of this record, typically because the record has shifted location in the hierarchy and is hierarchically indexed // $va_children_ids = $t_subject->getHierarchyAsList($pn_subject_row_id, array('idsOnly' => true)); if (is_array($va_children_ids) && sizeof($va_children_ids) > 0) { // trigger reindexing of children $o_indexer = new SearchIndexer($this->opo_db); $qr_children_res = $t_subject->makeSearchResult($vs_subject_tablename, $va_children_ids); while ($qr_children_res->nextHit()) { $o_indexer->indexRow($pn_subject_tablenum, $vn_id = $qr_children_res->get($vs_subject_pk), array($vs_subject_pk => $vn_id, 'parent_id' => $qr_children_res->get('parent_id')), true, $pa_exclusion_list, array(), null); } } } }
/** * Returns list of types present for items in set * * @param array $pa_options * user_id = Restricts access to sets accessible by the current user. If omitted then all sets, regardless of access are returned. * checkAccess = Restricts returned sets to those with an public access level with the specified values. If omitted sets are returned regardless of public access (ca_sets.access) value. Can be a single value or array if you wish to filter on multiple public access values. * includeParents = Include parent types in the returned type list. [Default is false] * @return array List of types. Keys are integer type_ids, values are plural type names for the current locale */ public function getTypesForItems($pa_options = null) { if (!($vn_set_id = $this->getPrimaryKey())) { return null; } if (!is_array($pa_options)) { $pa_options = array(); } if ($pa_options['user_id'] && !$this->haveAccessToSet($pa_options['user_id'], __CA_SET_READ_ACCESS__)) { return false; } $o_db = $this->getDb(); $o_dm = $this->getAppDatamodel(); if (!($t_rel_table = $o_dm->getInstanceByTableNum($this->get('table_num'), true))) { return null; } if (!($vs_type_id_fld = $t_rel_table->getTypeFieldName())) { return array(); } // get set items $vs_access_sql = ''; if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_rel_table->hasField('access')) { $vs_access_sql = ' AND rel.access IN (' . join(',', $pa_options['checkAccess']) . ')'; } $vs_deleted_sql = ''; if ($t_rel_table->hasField('deleted')) { $vs_deleted_sql = ' AND rel.deleted = 0'; } $va_type_list = method_exists($t_rel_table, "getTypeList") ? $t_rel_table->getTypeList() : array(); $qr_res = $o_db->query("\n\t\t\tSELECT distinct rel.{$vs_type_id_fld}\n\t\t\tFROM ca_set_items casi\n\t\t\tINNER JOIN " . $t_rel_table->tableName() . " AS rel ON rel." . $t_rel_table->primaryKey() . " = casi.row_id\n\t\t\tWHERE\n\t\t\t\tcasi.set_id = ? {$vs_access_sql} {$vs_deleted_sql}\n\t\t", array($vn_set_id)); $va_type_ids = array(); while ($qr_res->nextRow()) { $va_type_ids[$vn_type_id = $qr_res->get($vs_type_id_fld)] = $va_type_list[$vn_type_id]['name_plural']; } if (caGetOption('includeParents', $pa_options, false)) { $t_item = new ca_list_items(); $va_expanded_types = $va_type_ids; $va_labels = $t_item->getPreferredDisplayLabelsForIDs($va_type_ids); foreach ($va_type_ids as $vn_type_id => $vs_type) { if (is_array($va_parents = $t_item->getHierarchyAncestors($vn_type_id, array('idsOnly' => true)))) { foreach ($va_parents as $vn_parent_id) { $va_expanded_types[$vn_parent_id] = $va_labels[$vn_parent_id]; } } } $va_type_ids = $va_expanded_types; } return $va_type_ids; }
/** * Return list of items from the specified table that are related to the current browse set. This is the method that actually * pulls the facet content, regardless of whether the facet is cached yet or not. If you want to use the facet cache, call * BrowseEngine::getFacet() * * @see BrowseEngine::getFacet() * Options: * checkAccess = array of access values to filter facets that have an 'access' field by * checkAvailabilityOnly = if true then content is not actually fetch - only the availablility of content is verified * user_id = If set item level access control is performed relative to specified user_id, otherwise defaults to logged in user */ public function getFacetContent($ps_facet_name, $pa_options = null) { global $AUTH_CURRENT_USER_ID; $vs_browse_table_name = $this->ops_browse_table_name; $vs_browse_table_num = $this->opn_browse_table_num; $vn_user_id = isset($pa_options['user_id']) && (int) $pa_options['user_id'] ? (int) $pa_options['user_id'] : (int) $AUTH_CURRENT_USER_ID; $vb_show_if_no_acl = (bool) ($this->opo_config->get('default_item_access_level') > __CA_ACL_NO_ACCESS__); $t_user = new ca_users($vn_user_id); if (is_array($va_groups = $t_user->getUserGroups()) && sizeof($va_groups)) { $va_group_ids = array_keys($va_groups); } else { $va_group_ids = array(); } if (!is_array($this->opa_browse_settings)) { return null; } if (!isset($this->opa_browse_settings['facets'][$ps_facet_name])) { return null; } if (!is_array($pa_options)) { $pa_options = array(); } $vb_check_availability_only = isset($pa_options['checkAvailabilityOnly']) ? (bool) $pa_options['checkAvailabilityOnly'] : false; $va_all_criteria = $this->getCriteria(); $va_criteria = $this->getCriteria($ps_facet_name); $va_facet_info = $this->opa_browse_settings['facets'][$ps_facet_name]; $t_subject = $this->getSubjectInstance(); if ($va_facet_info['relative_to']) { $vs_browse_table_name = $va_facet_info['relative_to']; $vs_browse_table_num = $this->opo_datamodel->getTableNum($vs_browse_table_name); } $vs_browse_type_limit_sql = ''; if (($va_browse_type_ids = $this->getTypeRestrictionList()) && sizeof($va_browse_type_ids)) { // type restrictions $vs_browse_type_limit_sql = '(' . $t_subject->tableName() . '.' . $t_subject->getTypeFieldName() . ' IN (' . join(', ', $va_browse_type_ids) . ')' . ($t_subject->getFieldInfo('type_id', 'IS_NULL') ? " OR (" . $this->ops_browse_table_name . '.' . $t_subject->getTypeFieldName() . " IS NULL)" : '') . ')'; if (is_array($va_facet_info['type_restrictions'])) { // facet type restrictions bind a facet to specific types; we check them here $va_restrict_to_types = $this->_convertTypeCodesToIDs($va_facet_info['type_restrictions']); $vb_is_ok_to_browse = false; foreach ($va_browse_type_ids as $vn_type_id) { if (in_array($vn_type_id, $va_restrict_to_types)) { $vb_is_ok_to_browse = true; break; } } if (!$vb_is_ok_to_browse) { return array(); } } } // Values to exclude from list attributes and authorities; can be idnos or ids $va_exclude_values = caGetOption('exclude_values', $va_facet_info, array(), array('castTo' => 'array')); $va_results = $this->opo_ca_browse_cache->getResults(); $vb_single_value_is_present = false; $vs_single_value = isset($va_facet_info['single_value']) ? $va_facet_info['single_value'] : null; $va_wheres = array(); switch ($va_facet_info['type']) { # ----------------------------------------------------- case 'has': $vn_state = null; if (isset($va_all_criteria[$ps_facet_name])) { break; } // only one instance of this facet allowed per browse if (!($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true))) { break; } $vs_yes_text = isset($va_facet_info['label_yes']) && $va_facet_info['label_yes'] ? $va_facet_info['label_yes'] : _t('Yes'); $vs_no_text = isset($va_facet_info['label_no']) && $va_facet_info['label_no'] ? $va_facet_info['label_no'] : _t('No'); $va_facet_values = array('yes' => array('id' => 1, 'label' => $vs_yes_text), 'no' => array('id' => 0, 'label' => $vs_no_text)); // Actually check that both yes and no values will result in something if ($va_facet_info['element_code']) { $t_element = new ca_metadata_elements(); if (!$t_element->load(array('element_code' => $va_facet_info['element_code']))) { break; } $vs_element_code = $va_facet_info['element_code']; $va_facet = array(); $va_counts = array(); foreach ($va_facet_values as $vs_state_name => $va_state_info) { $va_wheres = array(); $va_joins = array(); if (!(bool) $va_state_info['id']) { // no option $va_wheres[] = $this->ops_browse_table_name . '.' . $t_item->primaryKey() . " NOT IN (select row_id from ca_attributes where table_num = " . $t_item->tableNum() . " AND element_id = " . $t_element->getPrimaryKey() . ")"; } else { // yes option $va_joins[] = "LEFT JOIN ca_attributes AS caa ON " . $this->ops_browse_table_name . '.' . $t_item->primaryKey() . " = caa.row_id AND " . $t_item->tableNum() . " = caa.table_num"; $va_wheres[] = "caa.element_id = " . $t_element->getPrimaryKey(); } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $t_item->tableName() . ".deleted = 0)"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if (sizeof($va_results)) { $va_wheres[] = $vs_browse_table_name . "." . $t_item->primaryKey() . " IN (" . join(",", $va_results) . ")"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); $vs_where_sql = ''; if (sizeof($va_wheres) > 0) { $vs_where_sql = ' WHERE ' . join(' AND ', $va_wheres); } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t\tLIMIT 2\n\t\t\t\t\t\t\t\t"; //print "$vs_sql<hr>"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->nextRow()) { $va_counts[$vs_state_name] = (int) $qr_res->numRows(); } } else { $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT " . $vs_browse_table_name . '.' . $t_item->primaryKey() . "\n\t\t\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t"; //print "$vs_sql<hr>"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->numRows() > 0) { $va_facet[$vs_state_name] = $va_state_info; } else { return array(); // if either option in a "has" facet fails then don't show the facet } } } } else { $vs_rel_table_name = $va_facet_info['table']; if (!is_array($va_restrict_to_relationship_types = $va_facet_info['restrict_to_relationship_types'])) { $va_restrict_to_relationship_types = array(); } $va_restrict_to_relationship_types = $this->_getRelationshipTypeIDs($va_restrict_to_relationship_types, $va_facet_info['relationship_table']); if (!is_array($va_exclude_relationship_types = $va_facet_info['exclude_relationship_types'])) { $va_exclude_relationship_types = array(); } $va_exclude_relationship_types = $this->_getRelationshipTypeIDs($va_exclude_relationship_types, $va_facet_info['relationship_table']); $vn_table_num = $this->opo_datamodel->getTableNum($vs_rel_table_name); $vs_rel_table_pk = $this->opo_datamodel->getTablePrimaryKeyName($vn_table_num); switch (sizeof($va_path = array_keys($this->opo_datamodel->getPath($vs_browse_table_name, $vs_rel_table_name)))) { case 3: $t_item_rel = $this->opo_datamodel->getInstanceByTableName($va_path[1], true); $t_rel_item = $this->opo_datamodel->getInstanceByTableName($va_path[2], true); $vs_key = 'relation_id'; break; case 2: $t_item_rel = null; $t_rel_item = $this->opo_datamodel->getInstanceByTableName($va_path[1], true); $vs_key = $t_rel_item->primaryKey(); break; default: // bad related table return null; break; } $vs_cur_table = array_shift($va_path); $va_joins_init = array(); foreach ($va_path as $vs_join_table) { $va_rel_info = $this->opo_datamodel->getRelationships($vs_cur_table, $vs_join_table); $va_joins_init[] = ($vn_state ? 'INNER' : 'LEFT') . ' JOIN ' . $vs_join_table . ' ON ' . $vs_cur_table . '.' . $va_rel_info[$vs_cur_table][$vs_join_table][0][0] . ' = ' . $vs_join_table . '.' . $va_rel_info[$vs_cur_table][$vs_join_table][0][1] . "\n"; $vs_cur_table = $vs_join_table; } $va_facet = array(); $va_counts = array(); foreach ($va_facet_values as $vs_state_name => $va_state_info) { $va_wheres = array(); $va_joins = $va_joins_init; if (!(bool) $va_state_info['id']) { // no option $va_wheres[] = "(" . $t_rel_item->tableName() . "." . $t_rel_item->primaryKey() . " IS NULL)"; if ($t_rel_item->hasField('deleted')) { $va_wheres[] = "((" . $t_rel_item->tableName() . ".deleted = 0) OR (" . $t_rel_item->tableName() . ".deleted IS NULL))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_rel_item->hasField('access')) { $va_wheres[] = "((" . $t_rel_item->tableName() . ".access NOT IN (" . join(',', $pa_options['checkAccess']) . ")) OR (" . $t_rel_item->tableName() . ".access IS NULL))"; } if (sizeof($va_restrict_to_relationship_types) > 0 && is_object($t_item_rel)) { $va_wheres[] = "((" . $t_item_rel->tableName() . ".type_id NOT IN (" . join(',', $va_restrict_to_relationship_types) . ")) OR (" . $t_item_rel->tableName() . ".type_id IS NULL))"; } if (sizeof($va_exclude_relationship_types) > 0 && is_object($t_item_rel)) { $va_wheres[] = "(" . $t_item_rel->tableName() . ".type_id IN (" . join(',', $va_exclude_relationship_types) . "))"; } } else { // yes option $va_wheres[] = "(" . $t_rel_item->tableName() . "." . $t_rel_item->primaryKey() . " IS NOT NULL)"; if ($t_rel_item->hasField('deleted')) { $va_wheres[] = "(" . $t_rel_item->tableName() . ".deleted = 0)"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_rel_item->hasField('access')) { $va_wheres[] = "(" . $t_rel_item->tableName() . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if (sizeof($va_restrict_to_relationship_types) > 0 && is_object($t_item_rel)) { $va_wheres[] = "(" . $t_item_rel->tableName() . ".type_id IN (" . join(',', $va_restrict_to_relationship_types) . "))"; } if (sizeof($va_exclude_relationship_types) > 0 && is_object($t_item_rel)) { $va_wheres[] = "(" . $t_item_rel->tableName() . ".type_id NOT IN (" . join(',', $va_exclude_relationship_types) . "))"; } } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $t_item->tableName() . ".deleted = 0)"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if (sizeof($va_results)) { $va_wheres[] = $vs_browse_table_name . "." . $t_item->primaryKey() . " IN (" . join(",", $va_results) . ")"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); $vs_where_sql = ''; if (sizeof($va_wheres) > 0) { $vs_where_sql = ' WHERE ' . join(' AND ', $va_wheres); } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t\tLIMIT 2\n\t\t\t\t\t\t\t\t"; //print "$vs_sql<hr>"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->nextRow()) { $va_counts[$vs_state_name] = (int) $qr_res->numRows(); } } else { $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT " . $vs_browse_table_name . '.' . $t_item->primaryKey() . "\n\t\t\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t"; //print "$vs_sql<hr>"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->numRows() > 0) { $va_facet[$vs_state_name] = $va_state_info; } else { return array(); // if either option in a "has" facet fails then don't show the facet } } } } if ($vb_check_availability_only) { return sizeof($va_counts) > 1 ? true : false; } return $va_facet; break; # ----------------------------------------------------- # ----------------------------------------------------- case 'label': if (!($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true))) { break; } if (!($t_label = $t_item->getLabelTableInstance())) { break; } if (!is_array($va_restrict_to_types = $va_facet_info['restrict_to_types'])) { $va_restrict_to_types = array(); } $vs_item_pk = $t_item->primaryKey(); $vs_label_table_name = $t_label->tableName(); $vs_label_pk = $t_label->primaryKey(); $vs_label_display_field = $t_item->getLabelDisplayField(); $vs_label_sort_field = $t_item->getLabelSortField(); $vs_where_sql = $vs_join_sql = ''; $vb_needs_join = false; $va_where_sql = array(); $va_joins = array(); if ($vs_browse_type_limit_sql) { $va_where_sql[] = $vs_browse_type_limit_sql; } if (isset($va_facet_info['preferred_labels_only']) && $va_facet_info['preferred_labels_only'] && $t_label->hasField('is_preferred')) { $va_where_sql[] = "l.is_preferred = 1"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_where_sql[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($t_item->hasField('deleted')) { $va_where_sql[] = "(" . $vs_browse_table_name . ".deleted = 0)"; $vb_needs_join = true; } if (sizeof($va_restrict_to_types)) { $va_restrict_to_type_ids = caMakeTypeIDList($vs_browse_table_name, $va_restrict_to_types, array('dont_include_subtypes_in_type_restriction' => true)); if (sizeof($va_restrict_to_type_ids)) { $va_where_sql[] = "(" . $vs_browse_table_name . "." . $t_item->getTypeFieldName() . " IN (" . join(", ", $va_restrict_to_type_ids) . ")" . ($t_item->getFieldInfo('type_id', 'IS_NULL') ? " OR (" . $vs_browse_table_name . '.' . $t_item->getTypeFieldName() . " IS NULL)" : '') . ")"; $vb_needs_join = true; } } if (sizeof($va_exclude_types)) { $va_exclude_type_ids = caMakeTypeIDList($vs_browse_table_name, $va_exclude_types, array('dont_include_subtypes_in_type_restriction' => true)); if (sizeof($va_exclude_type_ids)) { $va_where_sql[] = "(" . $vs_browse_table_name . "." . $t_item->getTypeFieldName() . " NOT IN (" . join(", ", $va_exclude_type_ids) . ")" . ($t_item->getFieldInfo('type_id', 'IS_NULL') ? " OR (" . $vs_browse_table_name . '.' . $t_item->getTypeFieldName() . " IS NULL)" : '') . ")"; $vb_needs_join = true; } } if ($vb_needs_join) { $va_joins[] = "INNER JOIN " . $vs_browse_table_name . " ON " . $vs_browse_table_name . "." . $t_item->primaryKey() . " = l." . $t_item->primaryKey(); } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_where_sql[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_where_sql = array_merge($va_where_sql, $va_relative_sql_data['wheres']); } } if (sizeof($va_results)) { if ($va_facet_info['relative_to']) { $va_where_sql[] = $this->ops_browse_table_name . "." . $t_subject->primaryKey() . " IN (" . join(",", $va_results) . ")"; } else { $va_where_sql[] = "l.{$vs_item_pk} IN (" . join(",", $va_results) . ")"; } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_where_sql[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (sizeof($va_where_sql)) { $vs_where_sql = "WHERE " . join(" AND ", $va_where_sql); } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM {$vs_label_table_name} l\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t\t"; $qr_res = $this->opo_db->query($vs_sql); return (int) $qr_res->numRows() > 0 ? true : false; } else { $vs_parent_fld = $t_item->getProperty('HIERARCHY_PARENT_ID_FLD'); $vs_sql = "\n\t\t\t\t\t\t\tSELECT l.* " . ($vs_parent_fld ? ", " . $vs_browse_table_name . "." . $vs_parent_fld : '') . " \n\t\t\t\t\t\t\tFROM {$vs_label_table_name} l\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t"; $qr_res = $this->opo_db->query($vs_sql); $va_values = array(); $va_child_counts = array(); $vn_parent_id = null; while ($qr_res->nextRow()) { $vn_id = $qr_res->get($t_item->primaryKey()); if ($vs_parent_fld) { $vn_parent_id = $qr_res->get($vs_parent_fld); if ($vn_parent_id) { $va_child_counts[$vn_parent_id]++; } } $va_values[$vn_id][$qr_res->get('locale_id')] = array_merge($qr_res->getRow(), array('id' => $vn_id, 'parent_id' => $vn_parent_id, 'label' => $qr_res->get($vs_label_display_field))); if (!is_null($vs_single_value) && $vn_id == $vs_single_value) { $vb_single_value_is_present = true; } } if ($vs_parent_fld) { foreach ($va_values as $vn_id => $va_values_by_locale) { foreach ($va_values_by_locale as $vn_locale_id => $va_value) { $va_values[$vn_id][$vn_locale_id]['child_count'] = (int) $va_child_counts[$vn_id]; } } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } $va_values = caExtractValuesByUserLocale($va_values); return $va_values; } break; # ----------------------------------------------------- # ----------------------------------------------------- case 'attribute': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); $t_element = new ca_metadata_elements(); if (!$t_element->load(array('element_code' => $va_facet_info['element_code']))) { return array(); } $vn_element_type = $t_element->get('datatype'); $vn_element_id = $t_element->getPrimaryKey(); $va_joins = array('INNER JOIN ca_attribute_values ON ca_attributes.attribute_id = ca_attribute_values.attribute_id', 'INNER JOIN ' . $vs_browse_table_name . ' ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_attributes.row_id AND ca_attributes.table_num = ' . intval($vs_browse_table_num)); $va_wheres = array(); if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = ' AND (' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { // exclude criteria values $vs_criteria_exclude_sql = ''; if (is_array($va_criteria) && sizeof($va_criteria)) { $vs_criteria_exclude_sql = ' AND (ca_attribute_values.value_longtext1 NOT IN (' . join(", ", caQuoteList(array_keys($va_criteria))) . ')) '; } $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t(ca_attribute_values.element_id = ?) {$vs_criteria_exclude_sql} {$vs_where_sql}\n\t\t\t\t\t\t\tLIMIT 2"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); return (int) $qr_res->numRows() > 1 ? true : false; } else { $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT value_longtext1, value_decimal1, value_longtext2, value_integer1\n\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tca_attribute_values.element_id = ? {$vs_where_sql}"; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); $va_values = array(); $va_list_items = null; $va_suppress_values = null; if ($va_facet_info['suppress'] && !is_array($va_facet_info['suppress'])) { $va_facet_info['suppress'] = array($va_facet_info['suppress']); } if (!is_array($va_suppress_values = caGetOption('suppress', $va_facet_info, null))) { $va_suppress_values = caGetOption('exclude_values', $va_facet_info, null); } switch ($vn_element_type) { case __CA_ATTRIBUTE_VALUE_LIST__: $va_values = $qr_res->getAllFieldValues('value_longtext1'); $qr_res->seek(0); $t_list_item = new ca_list_items(); $va_list_item_cache = $t_list_item->getFieldValuesForIDs($va_values, array('idno', 'item_value', 'parent_id', 'access')); $va_list_child_count_cache = array(); if (is_array($va_list_item_cache)) { foreach ($va_list_item_cache as $vn_id => $va_item) { if (!($vn_parent_id = $va_item['parent_id'])) { continue; } if (is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && !in_array($va_item['access'], $pa_options['checkAccess'])) { continue; } $va_list_child_count_cache[$vn_parent_id]++; } } $va_list_label_cache = $t_list_item->getPreferredDisplayLabelsForIDs($va_values); // Translate value idnos to ids if (is_array($va_suppress_values)) { $va_suppress_values = ca_lists::getItemIDsFromList($t_element->get('list_id'), $va_suppress_values); } $va_facet_list = array(); foreach ($va_values as $vn_val) { if (!$vn_val) { continue; } if (is_array($va_suppress_values) && in_array($vn_val, $va_suppress_values)) { continue; } if (is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && !in_array($va_item['access'], $pa_options['checkAccess'])) { continue; } if ($va_criteria[$vn_val]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on $vn_child_count = isset($va_list_child_count_cache[$vn_val]) ? $va_list_child_count_cache[$vn_val] : 0; $va_facet_list[$vn_val] = array('id' => $vn_val, 'label' => html_entity_decode($va_list_label_cache[$vn_val]), 'parent_id' => isset($va_list_item_cache[$vn_val]['parent_id']) ? $va_list_item_cache[$vn_val]['parent_id'] : null, 'child_count' => $vn_child_count); } // preserve order of list $va_values_sorted_by_list_order = array(); if (is_array($va_list_item_cache)) { foreach ($va_list_item_cache as $vn_item_id => $va_item) { if (isset($va_facet_list[$vn_item_id])) { $va_values_sorted_by_list_order[$vn_item_id] = $va_facet_list[$vn_item_id]; } } } return caSortArrayByKeyInValue($va_values_sorted_by_list_order, array('label')); break; case __CA_ATTRIBUTE_VALUE_OBJECTS__: case __CA_ATTRIBUTE_VALUE_ENTITIES__: case __CA_ATTRIBUTE_VALUE_PLACES__: case __CA_ATTRIBUTE_VALUE_OCCURRENCES__: case __CA_ATTRIBUTE_VALUE_COLLECTIONS__: case __CA_ATTRIBUTE_VALUE_LOANS__: case __CA_ATTRIBUTE_VALUE_MOVEMENTS__: case __CA_ATTRIBUTE_VALUE_STORAGELOCATIONS__: case __CA_ATTRIBUTE_VALUE_OBJECTLOTS__: if ($t_rel_item = AuthorityAttributeValue::elementTypeToInstance($vn_element_type)) { $va_ids = $qr_res->getAllFieldValues('value_integer1'); $va_auth_items = $t_rel_item->getPreferredDisplayLabelsForIDs($va_ids); $qr_res->seek(0); } break; default: if (isset($va_facet_info['suppress']) && is_array($va_facet_info['suppress'])) { $va_suppress_values = $va_facet_info['suppress']; } break; } while ($qr_res->nextRow()) { $o_attr = Attribute::getValueInstance($vn_element_type, $qr_res->getRow(), true); if (!($vs_val = trim($o_attr->getDisplayValue()))) { continue; } if (is_array($va_suppress_values) && in_array($vs_val, $va_suppress_values)) { continue; } if ($va_criteria[$vs_val]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on switch ($vn_element_type) { case __CA_ATTRIBUTE_VALUE_LIST__: $vn_child_count = 0; if ($va_list_parent_ids[$vs_val]) { $vn_child_count++; } $va_values[$vs_val] = array('id' => str_replace('/', '/', $vs_val), 'label' => html_entity_decode($va_list_items[$vs_val]['name_plural'] ? $va_list_items[$vs_val]['name_plural'] : $va_list_items[$vs_val]['item_value']), 'parent_id' => $va_list_items[$vs_val]['parent_id'], 'child_count' => $vn_child_count); break; case __CA_ATTRIBUTE_VALUE_OBJECTS__: case __CA_ATTRIBUTE_VALUE_ENTITIES__: case __CA_ATTRIBUTE_VALUE_PLACES__: case __CA_ATTRIBUTE_VALUE_OCCURRENCES__: case __CA_ATTRIBUTE_VALUE_COLLECTIONS__: case __CA_ATTRIBUTE_VALUE_LOANS__: case __CA_ATTRIBUTE_VALUE_MOVEMENTS__: case __CA_ATTRIBUTE_VALUE_STORAGELOCATIONS__: case __CA_ATTRIBUTE_VALUE_OBJECTLOTS__: $va_values[$vs_val] = array('id' => $vn_id, 'label' => html_entity_decode($va_auth_items[$vn_id] ? $va_auth_items[$vn_id] : $vs_val)); break; case __CA_ATTRIBUTE_VALUE_CURRENCY__: $va_values[sprintf("%014.2f", preg_replace("![\\D]+!", "", $vs_val))] = array('id' => str_replace('/', '/', $vs_val), 'label' => $vs_val); break; default: $va_values[$vs_val] = array('id' => str_replace('/', '/', $vs_val), 'label' => $vs_val); break; } if (!is_null($vs_single_value) && $vs_val == $vs_single_value) { $vb_single_value_is_present = true; } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } ksort($va_values); return $va_values; } break; # ----------------------------------------------------- # ----------------------------------------------------- case 'location': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); $vs_sort_field = null; if ($t_item->getProperty('ID_NUMBERING_ID_FIELD') == $vs_field_name) { $vs_sort_field = $t_item->getProperty('ID_NUMBERING_SORT_FIELD'); } $va_joins = array(); $va_wheres = array(); $vs_where_sql = ''; $va_wheres[] = "({$vs_browse_table_name}.current_loc_class IS NOT NULL)"; if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = '(' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { if (sizeof($va_criteria) > 0) { return false; } // only one current location criteria allowed $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\tLIMIT 2"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->nextRow()) { return (int) $qr_res->numRows() > 0 ? true : false; } return false; } else { if (sizeof($va_criteria) > 0) { return array(); } // only one current location criteria allowed $vs_pk = $t_item->primaryKey(); $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT {$vs_browse_table_name}.current_loc_class, {$vs_browse_table_name}.current_loc_subclass, {$vs_browse_table_name}.current_loc_id\n\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t{$vs_where_sql}"; if ($vs_sort_field) { $vs_sql .= " ORDER BY {$vs_sort_field}"; } $qr_res = $this->opo_db->query($vs_sql); $va_collapse_map = $this->getCollapseMapForLocationFacet($va_facet_info); $va_values = $va_values_by_table = array(); while ($qr_res->nextRow()) { if (!($vs_loc_class = trim($qr_res->get('current_loc_class')))) { continue; } if (!($vs_loc_subclass = trim($qr_res->get('current_loc_subclass')))) { continue; } if (!($vs_loc_id = trim($qr_res->get('current_loc_id')))) { continue; } $vs_val = "{$vs_loc_class}:{$vs_loc_subclass}:{$vs_loc_id}"; if ($va_criteria[$vs_val]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on $va_values_by_table[$vs_loc_class][$vs_loc_subclass][$vs_loc_id] = true; } foreach ($va_values_by_table as $vs_loc_class => $va_loc_id_by_subclass) { foreach ($va_loc_id_by_subclass as $vs_loc_subclass => $va_loc_ids) { if (sizeof($va_tmp = array_keys($va_loc_ids))) { $vs_loc_table_name = $this->opo_datamodel->getTableName($vs_loc_class); if (($vs_table_name = $vs_loc_table_name) == 'ca_objects_x_storage_locations') { $vs_table_name = 'ca_storage_locations'; } $qr_res = caMakeSearchResult($vs_table_name, $va_tmp); if (isset($va_collapse_map[$vs_table_name]) && isset($va_collapse_map[$vs_table_name]['*']) && $va_collapse_map[$vs_table_name]['*']) { $va_values[$vs_id = "{$vs_loc_class}"] = array('id' => $vs_id, 'label' => $va_collapse_map[$vs_table_name]['*']); continue; } while ($qr_res->nextHit()) { $vn_id = $qr_res->getPrimaryKey(); $va_config = ca_objects::getConfigurationForCurrentLocationType($vs_table_name, $vs_loc_subclass, array('facet' => isset($va_facet_info['display']) ? $va_facet_info['display'] : null)); $vs_template = isset($va_config['template']) ? $va_config['template'] : "^{$vs_table_name}.preferred_labels"; if (isset($va_collapse_map[$vs_table_name]) && isset($va_collapse_map[$vs_table_name][$vs_loc_subclass]) && $va_collapse_map[$vs_table_name][$vs_loc_subclass]) { $va_values[$vs_id = "{$vs_loc_class}:{$vs_loc_subclass}"] = array('id' => $vs_id, 'label' => $va_collapse_map[$vs_table_name][$vs_loc_subclass]); continue; } $va_values[$vs_id = "{$vs_loc_class}:{$vs_loc_subclass}:{$vn_id}"] = array('id' => $vs_id, 'label' => $qr_res->getWithTemplate($vs_template)); } } } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return caSortArrayByKeyInValue($va_values, array('label')); } return array(); break; # ----------------------------------------------------- # ----------------------------------------------------- case 'fieldList': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); $vs_field_name = $va_facet_info['field']; $va_field_info = $t_item->getFieldInfo($vs_field_name); $t_list = new ca_lists(); $t_list_item = new ca_list_items(); $va_joins = array(); $va_wheres = array(); $vs_where_sql = ''; if (isset($va_field_info['LIST_CODE']) && ($vs_list_name = $va_field_info['LIST_CODE'])) { // Handle fields containing ca_list_item.item_id's $va_joins = array('INNER JOIN ' . $vs_browse_table_name . ' ON ' . $vs_browse_table_name . '.' . $vs_field_name . ' = li.item_id', 'INNER JOIN ca_lists ON ca_lists.list_id = li.list_id'); if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; $va_wheres[] = "(li.access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if (is_array($va_criteria) && sizeof($va_criteria)) { $va_wheres[] = "(li.item_id NOT IN (" . join(",", array_keys($va_criteria)) . "))"; } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = ' AND (' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\tFROM ca_list_items li\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tca_lists.list_code = ? {$vs_where_sql}\n\t\t\t\t\t\t\t\tLIMIT 2"; $qr_res = $this->opo_db->query($vs_sql, $vs_list_name); return (int) $qr_res->numRows() > 1 ? true : false; } else { // Get label ordering fields $va_ordering_fields_to_fetch = isset($va_facet_info['order_by_label_fields']) && is_array($va_facet_info['order_by_label_fields']) ? $va_facet_info['order_by_label_fields'] : array(); $va_orderbys = array(); $t_rel_item_label = new ca_list_item_labels(); foreach ($va_ordering_fields_to_fetch as $vs_sort_by_field) { if (!$t_rel_item_label->hasField($vs_sort_by_field)) { continue; } $va_orderbys[] = $va_label_selects[] = 'lil.' . $vs_sort_by_field; } $vs_order_by = sizeof($va_orderbys) ? "ORDER BY " . join(', ', $va_orderbys) : ''; $vs_sql = "\n\t\t\t\t\t\t\t\tSELECT DISTINCT lil.item_id, lil.name_singular, lil.name_plural, lil.locale_id\n\t\t\t\t\t\t\t\tFROM ca_list_items li\n\t\t\t\t\t\t\t\tINNER JOIN ca_list_item_labels AS lil ON lil.item_id = li.item_id\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tca_lists.list_code = ? AND lil.is_preferred = 1 {$vs_where_sql} {$vs_order_by}"; //print $vs_sql." [$vs_list_name]"; $qr_res = $this->opo_db->query($vs_sql, $vs_list_name); $va_values = array(); while ($qr_res->nextRow()) { $vn_id = $qr_res->get('item_id'); if ($va_criteria[$vn_id]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on $va_values[$vn_id][$qr_res->get('locale_id')] = array('id' => $vn_id, 'label' => $qr_res->get('name_plural')); if (!is_null($vs_single_value) && $vn_id == $vs_single_value) { $vb_single_value_is_present = true; } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return caExtractValuesByUserLocale($va_values); } } else { if ($vs_list_name = $va_field_info['LIST']) { $va_list_items_by_value = array(); // fields with values set according to ca_list_items (not a foreign key ref) if ($va_list_items = caExtractValuesByUserLocale($t_list->getItemsForList($vs_list_name))) { foreach ($va_list_items as $vn_id => $va_list_item) { $va_list_items_by_value[$va_list_item['item_value']] = $va_list_item['name_plural']; } } else { foreach ($va_field_info['BOUNDS_CHOICE_LIST'] as $vs_val => $vn_id) { $va_list_items_by_value[$vn_id] = $vs_val; } } if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t\t\t)"; } } if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = '(' . $vs_where_sql . ')'; } $vs_join_sql = join("\n", $va_joins); if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t" . ($vs_where_sql ? 'WHERE' : '') . "\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t\tLIMIT 2"; $qr_res = $this->opo_db->query($vs_sql); return (int) $qr_res->numRows() > 1 ? true : false; } else { $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT DISTINCT " . $vs_browse_table_name . '.' . $vs_field_name . "\n\t\t\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t" . ($vs_where_sql ? 'WHERE' : '') . "\n\t\t\t\t\t\t\t\t\t\t{$vs_where_sql}"; //print $vs_sql." [$vs_list_name]"; $qr_res = $this->opo_db->query($vs_sql); $va_values = array(); while ($qr_res->nextRow()) { $vn_id = $qr_res->get($vs_field_name); if ($va_criteria[$vn_id]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if (isset($va_list_items_by_value[$vn_id])) { $va_values[$vn_id] = array('id' => $vn_id, 'label' => $va_list_items_by_value[$vn_id]); if (!is_null($vs_single_value) && $vn_id == $vs_single_value) { $vb_single_value_is_present = true; } } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return $va_values; } } else { if ($t_browse_table = $this->opo_datamodel->getInstanceByTableName($vs_facet_table = $va_facet_info['table'], true)) { // Handle fields containing ca_list_item.item_id's $va_joins = array('INNER JOIN ' . $vs_browse_table_name . ' ON ' . $vs_browse_table_name . '.' . $vs_field_name . ' = ' . $vs_facet_table . '.' . $t_browse_table->primaryKey()); $vs_display_field_name = null; if (method_exists($t_browse_table, 'getLabelTableInstance')) { $t_label_instance = $t_browse_table->getLabelTableInstance(); $vs_display_field_name = isset($va_facet_info['display']) && $va_facet_info['display'] ? $va_facet_info['display'] : $t_label_instance->getDisplayField(); $va_joins[] = 'INNER JOIN ' . $t_label_instance->tableName() . " AS lab ON lab." . $t_browse_table->primaryKey() . ' = ' . $t_browse_table->tableName() . '.' . $t_browse_table->primaryKey(); } if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = 'WHERE (' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\t\t\tFROM {$vs_facet_table}\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t\t\tLIMIT 1"; $qr_res = $this->opo_db->query($vs_sql); return (int) $qr_res->numRows() > 0 ? true : false; } else { $vs_sql = "\n\t\t\t\t\t\t\t\t\t\tSELECT DISTINCT *\n\t\t\t\t\t\t\t\t\t\tFROM {$vs_facet_table}\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t\t{$vs_where_sql}"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql); $va_values = array(); $vs_pk = $t_browse_table->primaryKey(); while ($qr_res->nextRow()) { $vn_id = $qr_res->get($vs_pk); if ($va_criteria[$vn_id]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on $va_values[$vn_id][$qr_res->get('locale_id')] = array('id' => $vn_id, 'label' => $qr_res->get($vs_display_field_name)); if (!is_null($vs_single_value) && $vn_id == $vs_single_value) { $vb_single_value_is_present = true; } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return caExtractValuesByUserLocale($va_values); } } } } return array(); break; # ----------------------------------------------------- # ----------------------------------------------------- case 'field': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); if (!is_array($va_restrict_to_types = $va_facet_info['restrict_to_types'])) { $va_restrict_to_types = array(); } if (!is_array($va_restrict_to_types = $this->_convertTypeCodesToIDs($va_restrict_to_types, array('instance' => $t_item, 'dontExpandHierarchically' => true)))) { $va_restrict_to_types = array(); } $va_restrict_to_types_expanded = $this->_convertTypeCodesToIDs($va_restrict_to_types, array('instance' => $t_item)); $vs_field_name = $va_facet_info['field']; $va_field_info = $t_item->getFieldInfo($vs_field_name); $vs_sort_field = null; if ($t_item->getProperty('ID_NUMBERING_ID_FIELD') == $vs_field_name) { $vs_sort_field = $vs_browse_table_name . '.' . $t_item->getProperty('ID_NUMBERING_SORT_FIELD'); } $t_list = new ca_lists(); $t_list_item = new ca_list_items(); $va_joins = array(); $va_wheres = array(); $vs_where_sql = ''; $va_facet_values = null; if ($vb_is_bit = $va_field_info['FIELD_TYPE'] == FT_BIT) { $vs_yes_text = caGetOption('label_yes', $va_facet_info, _t('Yes')); $vs_no_text = caGetOption('label_no', $va_facet_info, _t('No')); $va_facet_values = array(1 => array('id' => 1, 'label' => $vs_yes_text), 0 => array('id' => 0, 'label' => $vs_no_text)); } if (is_array($va_restrict_to_types) && sizeof($va_restrict_to_types) > 0 && method_exists($t_rel_item, "getTypeList")) { $va_wheres[] = "{$va_restrict_to_types_expanded}.type_id IN (" . join(',', caGetOption('dont_include_subtypes', $va_facet_info, false) ? $va_restrict_to_types : $va_restrict_to_types_expanded) . ")"; $va_selects[] = "{$va_restrict_to_types_expanded}.type_id"; } if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = '(' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT {$vs_browse_table_name}.{$vs_field_name}\n\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\tLIMIT 2"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->numRows() > 1) { return true; } return false; } else { $vs_pk = $t_item->primaryKey(); $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT {$vs_browse_table_name}.{$vs_field_name}\n\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t{$vs_where_sql}"; if ($vs_sort_field) { $vs_sql .= " ORDER BY {$vs_sort_field}"; } $qr_res = $this->opo_db->query($vs_sql); $va_values = array(); while ($qr_res->nextRow()) { if (!($vs_val = trim($qr_res->get($vs_field_name))) && !$vb_is_bit) { continue; } if ($va_criteria[$vs_val]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if ($vb_is_bit && isset($va_facet_values[$vs_val])) { $va_values[$vs_val] = $va_facet_values[$vs_val]; } else { $va_values[$vs_val] = array('id' => str_replace('/', '/', $vs_val), 'label' => $vs_val); } if (!is_null($vs_single_value) && $vs_val == $vs_single_value) { $vb_single_value_is_present = true; } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return $va_values; } return array(); break; # ----------------------------------------------------- # ----------------------------------------------------- case 'violations': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); $vs_field_name = $va_facet_info['field']; $va_field_info = $t_item->getFieldInfo($vs_field_name); $va_joins = array(); $va_wheres = array(); $vs_where_sql = ''; $va_facet_values = null; if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = '(' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\tINNER JOIN ca_metadata_dictionary_rule_violations ON ca_metadata_dictionary_rule_violations.row_id = {$vs_browse_table_name}." . $t_item->primaryKey() . " AND ca_metadata_dictionary_rule_violations.table_num = {$vs_browse_table_num}\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\tLIMIT 2"; $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->nextRow()) { return (int) $qr_res->numRows() > 0 ? true : false; } return false; } else { $vs_pk = $t_item->primaryKey(); $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT ca_metadata_dictionary_rules.rule_id\n\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\tINNER JOIN ca_metadata_dictionary_rule_violations ON ca_metadata_dictionary_rule_violations.row_id = {$vs_browse_table_name}." . $t_item->primaryKey() . " AND ca_metadata_dictionary_rule_violations.table_num = {$vs_browse_table_num}\n\t\t\t\t\t\t\tINNER JOIN ca_metadata_dictionary_rules ON ca_metadata_dictionary_rules.rule_id = ca_metadata_dictionary_rule_violations.rule_id\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t{$vs_where_sql}"; $qr_res = $this->opo_db->query($vs_sql); $va_values = array(); $t_rule = new ca_metadata_dictionary_rules(); while ($qr_res->nextRow()) { if ($t_rule->load($qr_res->get('rule_id'))) { if (!($vs_val = trim($t_rule->getSetting('label')))) { continue; } $vs_code = $t_rule->get('rule_code'); if ($va_criteria[$vs_val]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if (isset($va_facet_values[$vs_code])) { $va_values[$vs_code] = $va_facet_values[$vs_code]; } else { $va_values[$vs_code] = array('id' => $vs_code, 'label' => $vs_val); } if (!is_null($vs_single_value) && $vs_code == $vs_single_value) { $vb_single_value_is_present = true; } } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return $va_values; } return array(); break; # ----------------------------------------------------- # ----------------------------------------------------- case 'checkouts': if ($vs_browse_table_name != 'ca_objects') { return array(); } $t_item = new ca_objects(); $va_joins = array(); $va_wheres = array(); $vs_where_sql = ''; $va_facet_values = null; if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } $vs_checkout_join_sql = "INNER JOIN ca_object_checkouts ON ca_object_checkouts.object_id = ca_objects.object_id"; $vn_current_time = time(); switch ($va_facet_info['status']) { case 'overdue': $va_wheres[] = "((ca_object_checkouts.checkout_date <= {$vn_current_time}) AND (ca_object_checkouts.return_date IS NULL) AND (ca_object_checkouts.due_date <= {$vn_current_time}))"; break; case 'reserved': $va_wheres[] = "((ca_object_checkouts.checkout_date IS NULL) AND (ca_object_checkouts.return_date IS NULL))"; break; case 'available': $vs_checkout_join_sql = ''; $va_wheres[] = "(ca_objects.object_id NOT IN (SELECT object_id FROM ca_object_checkouts WHERE (ca_object_checkouts.checkout_date <= {$vn_current_time}) AND (ca_object_checkouts.return_date IS NULL)))"; break; default: case 'out': $va_wheres[] = "((ca_object_checkouts.checkout_date <= {$vn_current_time}) AND (ca_object_checkouts.return_date IS NULL))"; break; } if ($vs_checkout_join_sql) { $va_joins[] = $vs_checkout_join_sql; $va_joins[] = "INNER JOIN ca_users ON ca_object_checkouts.user_id = ca_users.user_id"; } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = '(' . $vs_where_sql . ')'; } if ($vb_check_availability_only) { switch ($va_facet_info['mode']) { case 'user': $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\t\tFROM ca_objects\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t{$vs_where_sql} AND ca_objects.deleted = 0\n\t\t\t\t\t\t\t\t\tLIMIT 2"; break; default: case 'all': $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\t\tFROM ca_objects\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tca_objects.deleted = 0 " . (sizeof($va_results) ? "AND (" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tLIMIT 2"; break; } $qr_res = $this->opo_db->query($vs_sql); if ($qr_res->nextRow()) { return (int) $qr_res->numRows() > 0 ? true : false; } return false; } else { $va_values = array(); $vs_pk = $t_item->primaryKey(); switch ($va_facet_info['mode']) { case 'user': $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT DISTINCT ca_object_checkouts.user_id, ca_users.fname, ca_users.lname, ca_users.email\n\t\t\t\t\t\t\t\t\tFROM ca_objects\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t{$vs_where_sql} " . (sizeof($va_results) ? " AND (" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))" : ""); $qr_res = $this->opo_db->query($vs_sql); while ($qr_res->nextRow()) { $vn_user_id = $qr_res->get('user_id'); $vs_val = $qr_res->get('fname') . ' ' . $qr_res->get('lname') . (($vs_email = $qr_res->get('email')) ? "({$vs_email})" : ''); if ($va_criteria[$vs_val]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if (isset($va_facet_values[$vn_user_id])) { $va_values[$vn_user_id] = $va_facet_values[$vn_user_id]; } else { $va_values[$vn_user_id] = array('id' => $vn_user_id, 'label' => $vs_val); } if (!is_null($vs_single_value) && $vn_user_id == $vs_single_value) { $vb_single_value_is_present = true; } } break; case 'all': default: foreach (array(_t('Available') => 'available', _t('Out') => 'out', _t('Reserved') => 'reserved', _t('Overdue') => 'overdue') as $vs_status_text => $vs_status) { $vs_join_sql = "INNER JOIN ca_object_checkouts ON ca_object_checkouts.object_id = ca_objects.object_id"; switch ($vs_status) { case 'overdue': $vs_where = "((ca_object_checkouts.checkout_date <= {$vn_current_time}) AND (ca_object_checkouts.return_date IS NULL) AND (ca_object_checkouts.due_date <= {$vn_current_time}))"; break; case 'reserved': $vs_where = "((ca_object_checkouts.checkout_date IS NULL) AND (ca_object_checkouts.return_date IS NULL))"; break; case 'available': $vs_join_sql = ''; $vs_where = "(ca_objects.object_id NOT IN (SELECT object_id FROM ca_object_checkouts WHERE (ca_object_checkouts.checkout_date <= {$vn_current_time}) AND (ca_object_checkouts.return_date IS NULL)))"; break; default: case 'out': $vs_where = "((ca_object_checkouts.checkout_date <= {$vn_current_time}) AND (ca_object_checkouts.return_date IS NULL))"; break; } if (sizeof($va_results) && $this->numCriteria() > 0) { $vs_where .= " AND (" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } $vs_sql = "\n\t\t\t\t\t\t\t\t\t\tSELECT count(*) c\n\t\t\t\t\t\t\t\t\t\tFROM ca_objects\n\t\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t{$vs_where}\n\t\t\t\t\t\t\t\t\t"; $qr_res = $this->opo_db->query($vs_sql); $qr_res->nextRow(); if (!$qr_res->get('c')) { continue; } $va_values[$vs_status] = array('id' => $vs_status, 'label' => $vs_status_text); if (!is_null($vs_single_value) && $vs_status == $vs_single_value) { $vb_single_value_is_present = true; } } break; } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return $va_values; } return array(); break; # ----------------------------------------------------- # ----------------------------------------------------- case 'normalizedDates': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); $t_element = new ca_metadata_elements(); $vb_is_element = $vb_is_field = false; if (!($vb_is_element = $t_element->load(array('element_code' => $va_facet_info['element_code']))) && !($vb_is_field = $t_item->hasField($va_facet_info['element_code']) && $t_item->getFieldInfo($va_facet_info['element_code'], 'FIELD_TYPE') === FT_HISTORIC_DATERANGE)) { return array(); } if ($vb_is_element) { $va_joins = array('INNER JOIN ca_attribute_values ON ca_attributes.attribute_id = ca_attribute_values.attribute_id', 'INNER JOIN ' . $vs_browse_table_name . ' ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_attributes.row_id AND ca_attributes.table_num = ' . intval($vs_browse_table_num)); } else { $va_joins = array(); } $va_wheres = array(); $vs_normalization = $va_facet_info['normalization']; // how do we construct the date ranges presented to uses. In other words - how do we want to allow users to browse dates? By year, decade, century? if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_where_sql = ''; if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = ' AND (' . $vs_where_sql . ')'; } $vs_join_sql = join("\n", $va_joins); if ($vb_is_element) { $vn_element_id = $t_element->getPrimaryKey(); $vs_dir = strtoupper($va_facet_info['sort']) === 'DESC' ? "DESC" : "ASC"; $o_tep = new TimeExpressionParser(); $vn_min_date = $vn_max_date = null; $vs_min_sql = $vs_max_sql = ''; if (isset($va_facet_info['minimum_date'])) { if ($o_tep->parse($va_facet_info['minimum_date'])) { $va_tmp = $o_tep->getHistoricTimestamps(); $vn_min_date = (double) $va_tmp['start']; $vs_min_sql = " AND (ca_attribute_values.value_decimal1 >= {$vn_min_date})"; } } if (isset($va_facet_info['maximum_date'])) { if ($o_tep->parse($va_facet_info['maximum_date'])) { $va_tmp = $o_tep->getHistoricTimestamps(); $vn_max_date = (double) $va_tmp['end']; $vs_max_sql = " AND (ca_attribute_values.value_decimal2 <= {$vn_max_date})"; } } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tca_attribute_values.element_id = ? \n\t\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t\tLIMIT 1"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); return (int) $qr_res->numRows() > 0 ? true : false; } else { $vs_sql = "\n\t\t\t\t\t\t\t\tSELECT DISTINCT ca_attribute_values.value_decimal1, ca_attribute_values.value_decimal2\n\t\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tca_attribute_values.element_id = ? \n\t\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); $vn_current_year = (int) date("Y"); $va_values = array(); $vb_include_unknown = (bool) caGetOption('include_unknown', $va_facet_info, false); $vb_unknown_is_set = false; while ($qr_res->nextRow()) { $vn_start = $qr_res->get('value_decimal1'); $vn_end = $qr_res->get('value_decimal2'); if (!($vn_start && $vn_end)) { if ($vb_include_unknown) { $vb_unknown_is_set = true; } continue; } if ($vn_end > $vn_current_year + 50) { continue; } // bad years can make for large facets that cause timeouts so cut it off 50 years into the future $va_normalized_values = $o_tep->normalizeDateRange($vn_start, $vn_end, $vs_normalization); foreach ($va_normalized_values as $vn_sort_value => $vs_normalized_value) { if ($va_criteria[$vs_normalized_value]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if (is_numeric($vs_normalized_value) && (int) $vs_normalized_value === 0) { continue; } // don't include year=0 $va_values[$vn_sort_value][$vs_normalized_value] = array('id' => $vs_normalized_value, 'label' => $vs_normalized_value); if (!is_null($vs_single_value) && $vs_normalized_value == $vs_single_value) { $vb_single_value_is_present = true; } } } if ($vb_include_unknown && !$vb_unknown_is_set) { // Check for rows where no data is set at all as opposed to null dates $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT DISTINCT ca_attributes.row_id\n\t\t\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tca_attribute_values.element_id = ? \n\t\t\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); if ($qr_res->numRows() < sizeof($va_results)) { $vb_unknown_is_set = true; } } if ($vb_unknown_is_set && sizeof($va_values) > 0) { $va_values['999999999'][_t('Date unknown')] = array('id' => 'null', 'label' => _t('Date unknown')); } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } ksort($va_values); if ($vs_dir == 'DESC') { $va_values = array_reverse($va_values); } $va_sorted_values = array(); foreach ($va_values as $vn_sort_value => $va_values_for_sort_value) { $va_sorted_values = array_merge($va_sorted_values, $va_values_for_sort_value); } return $va_sorted_values; } } else { // is intrinsic $vs_dir = strtoupper($va_facet_info['sort']) === 'DESC' ? "DESC" : "ASC"; $vs_browse_start_fld = $t_item->getFieldInfo($va_facet_info['element_code'], 'START'); $vs_browse_end_fld = $t_item->getFieldInfo($va_facet_info['element_code'], 'END'); $o_tep = new TimeExpressionParser(); $vn_min_date = $vn_max_date = null; $vs_min_sql = $vs_max_sql = ''; if (isset($va_facet_info['minimum_date'])) { if ($o_tep->parse($va_facet_info['minimum_date'])) { $va_tmp = $o_tep->getHistoricTimestamps(); $vn_min_date = (double) $va_tmp['start']; $vs_min_sql = " AND ({$vs_browse_table_name}.{$vs_browse_start_fld} >= {$vn_min_date})"; } } if (isset($va_facet_info['maximum_date'])) { if ($o_tep->parse($va_facet_info['maximum_date'])) { $va_tmp = $o_tep->getHistoricTimestamps(); $vn_max_date = (double) $va_tmp['end']; $vs_max_sql = " AND ({$vs_browse_table_name}.{$vs_browse_end_fld} <= {$vn_max_date})"; } } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t1 = 1\n\t\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\t\tLIMIT 1"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql); return (int) $qr_res->numRows() > 0 ? true : false; } else { $vs_sql = "\n\t\t\t\t\t\t\t\tSELECT DISTINCT {$vs_browse_table_name}.{$vs_browse_start_fld}, {$vs_browse_table_name}.{$vs_browse_end_fld}\n\t\t\t\t\t\t\t\tFROM {$vs_browse_table_name}\n\t\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t1 = 1\n\t\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql); $va_values = array(); while ($qr_res->nextRow()) { $vn_start = $qr_res->get($vs_browse_start_fld); $vn_end = $qr_res->get($vs_browse_end_fld); if (!($vn_start && $vn_end)) { continue; } $va_normalized_values = $o_tep->normalizeDateRange($vn_start, $vn_end, $vs_normalization); foreach ($va_normalized_values as $vn_sort_value => $vs_normalized_value) { if ($va_criteria[$vs_normalized_value]) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if (is_numeric($vs_normalized_value) && (int) $vs_normalized_value === 0) { continue; } // don't include year=0 $va_values[$vn_sort_value][$vs_normalized_value] = array('id' => $vs_normalized_value, 'label' => $vs_normalized_value); if (!is_null($vs_single_value) && $vs_normalized_value == $vs_single_value) { $vb_single_value_is_present = true; } } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } ksort($va_values); if ($vs_dir == 'DESC') { $va_values = array_reverse($va_values); } $va_sorted_values = array(); foreach ($va_values as $vn_sort_value => $va_values_for_sort_value) { $va_sorted_values = array_merge($va_sorted_values, $va_values_for_sort_value); } return $va_sorted_values; } } break; # ----------------------------------------------------- # ----------------------------------------------------- case 'normalizedLength': $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); $t_element = new ca_metadata_elements(); $vb_is_element = $vb_is_field = false; if (!($vb_is_element = $t_element->load(array('element_code' => $va_facet_info['element_code']))) && !($vb_is_field = $t_item->hasField($va_facet_info['element_code']) && $t_item->getFieldInfo($va_facet_info['element_code'], 'FIELD_TYPE') === FT_HISTORIC_DATERANGE)) { return array(); } if ($vb_is_element) { $va_joins = array('INNER JOIN ca_attribute_values ON ca_attributes.attribute_id = ca_attribute_values.attribute_id', 'INNER JOIN ' . $vs_browse_table_name . ' ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_attributes.row_id AND ca_attributes.table_num = ' . intval($vs_browse_table_num)); } else { $va_joins = array(); } $va_wheres = array(); $vs_normalization = $va_facet_info['normalization']; // how do we construct the dimensions ranges presented to users. In other words - what increments do we can to use to browse measurments? if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_item->hasField('access')) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($t_item->hasField('deleted')) { $va_wheres[] = "(" . $vs_browse_table_name . ".deleted = 0)"; } if ($va_facet_info['relative_to']) { if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_where_sql = ''; if (is_array($va_wheres) && sizeof($va_wheres) && ($vs_where_sql = join(' AND ', $va_wheres))) { $vs_where_sql = ' AND (' . $vs_where_sql . ')'; } $vs_join_sql = join("\n", $va_joins); $vn_element_id = $t_element->getPrimaryKey(); $vs_dir = strtoupper($va_facet_info['sort']) === 'DESC' ? "DESC" : "ASC"; $vs_min_sql = $vs_max_sql = ''; $vo_minimum_dimension = caParseLengthDimension(caGetOption('minimum_dimension', $va_facet_info, "0 in")); $vo_maximum_dimension = caParseLengthDimension(caGetOption('maximum_dimension', $va_facet_info, "0 in")); if ($vo_minimum_dimension) { $vn_tmp = (double) $vo_minimum_dimension->convertTo('METER', 6, 'en_US'); $vs_min_sql = " AND (ca_attribute_values.value_decimal1 >= {$vn_tmp})"; } if (caGetOption('maximum_dimension', $va_facet_info, null) && $vo_maximum_dimension) { $vn_tmp = (double) $vo_maximum_dimension->convertTo('METER', 6, 'en_US'); $vs_max_sql = " AND (ca_attribute_values.value_decimal1 <= {$vn_tmp})"; } if ($vb_check_availability_only) { $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tca_attribute_values.element_id = ? \n\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t\t\tLIMIT 1"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); return (int) $qr_res->numRows() > 0 ? true : false; } else { $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT ca_attribute_values.value_decimal1, ca_attribute_values.value_decimal2, ca_attribute_values.value_longtext1, ca_attribute_values.value_longtext2\n\t\t\t\t\t\t\tFROM ca_attributes\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tca_attribute_values.element_id = ? \n\t\t\t\t\t\t\t\t{$vs_min_sql}\n\t\t\t\t\t\t\t\t{$vs_max_sql}\n\t\t\t\t\t\t\t\t{$vs_where_sql}\n\t\t\t\t\t\t"; //print $vs_sql; $qr_res = $this->opo_db->query($vs_sql, $vn_element_id); $va_values = array(); if (!($vs_output_units = caGetLengthUnitType($vs_units = caGetOption('units', $va_facet_info, 'm')))) { $vs_output_units = Zend_Measure_Length::METER; } $vs_increment = caGetOption('increment', $va_facet_info, '1 m'); $vo_increment = caParseLengthDimension($vs_increment); $vn_increment_in_current_units = (double) $vo_increment->convertTo($vs_output_units, 6, 'en_US'); while ($qr_res->nextRow()) { $vn_meters = $qr_res->get('value_decimal1'); // measurement in meters // convert to target dimensions // normalize $vo_dim = new Zend_Measure_Length($vn_meters, Zend_Measure_Length::METER, 'en_US'); $vs_dim = $vo_dim->convertTo($vs_output_units, 6, 'en_US'); $vn_dim = (double) $vs_dim; $vn_normalized = floor($vn_dim / $vn_increment_in_current_units) * $vn_increment_in_current_units; if (isset($va_criteria[$vn_normalized])) { continue; } $vs_normalized_range_with_units = "{$vn_normalized} {$vs_units} - " . ($vn_normalized + $vn_increment_in_current_units) . " {$vs_units}"; $va_values[$vn_normalized][$vn_normalized] = array('id' => $vn_normalized, 'label' => $vs_normalized_range_with_units); if (!is_null($vs_single_value) && $vn_normalized == $vs_single_value) { $vb_single_value_is_present = true; } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } ksort($va_values); if ($vs_dir == 'DESC') { $va_values = array_reverse($va_values); } $va_sorted_values = array(); foreach ($va_values as $vn_sort_value => $va_values_for_sort_value) { $va_sorted_values = array_merge($va_sorted_values, $va_values_for_sort_value); } return $va_sorted_values; } break; # ----------------------------------------------------- # ----------------------------------------------------- case 'authority': $vs_rel_table_name = $va_facet_info['table']; $va_params = $this->opo_ca_browse_cache->getParameters(); // Make sure we honor type restrictions for the related authority $va_user_type_restrictions = caGetTypeRestrictionsForUser($vs_rel_table_name); $va_restrict_to_types = $va_facet_info['restrict_to_types']; if (is_array($va_user_type_restrictions)) { if (!is_array($va_restrict_to_types)) { $va_restrict_to_types = $va_user_type_restrictions; } else { $va_restrict_to_types = array_intersect($va_restrict_to_types, $va_user_type_restrictions); } } if (!is_array($va_exclude_types = $va_facet_info['exclude_types'])) { $va_exclude_types = array(); } if (!is_array($va_restrict_to_relationship_types = $va_facet_info['restrict_to_relationship_types'])) { $va_restrict_to_relationship_types = array(); } if (!is_array($va_exclude_relationship_types = $va_facet_info['exclude_relationship_types'])) { $va_exclude_relationship_types = array(); } $t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true); if ($vs_browse_table_name == $vs_rel_table_name) { // browsing on self-relations not supported break; } else { switch (sizeof($va_path = array_keys($this->opo_datamodel->getPath($vs_browse_table_name, $vs_rel_table_name)))) { case __CA_ATTRIBUTE_VALUE_LIST__: $t_item_rel = $this->opo_datamodel->getInstanceByTableName($va_path[1], true); $t_rel_item = $this->opo_datamodel->getInstanceByTableName($va_path[2], true); $vs_key = 'relation_id'; break; case __CA_ATTRIBUTE_VALUE_DATERANGE__: $t_item_rel = null; $t_rel_item = $this->opo_datamodel->getInstanceByTableName($va_path[1], true); $vs_key = $t_rel_item->primaryKey(); break; default: // bad related table return null; break; } } $vb_rel_is_hierarchical = (bool) $t_rel_item->isHierarchical(); // // Convert related item type_code specs in restrict_to_types and exclude_types lists to numeric type_ids we need for the query // if (!is_array($va_restrict_to_types = $this->_convertTypeCodesToIDs($va_restrict_to_types, array('instance' => $t_rel_item, 'dontExpandHierarchically' => true)))) { $va_restrict_to_types = array(); } if (!is_array($va_exclude_types = $this->_convertTypeCodesToIDs($va_exclude_types, array('instance' => $t_rel_item, 'dontExpandHierarchically' => true)))) { $va_exclude_types = array(); } $va_restrict_to_types_expanded = $this->_convertTypeCodesToIDs($va_restrict_to_types, array('instance' => $t_rel_item)); $va_exclude_types_expanded = $this->_convertTypeCodesToIDs($va_exclude_types, array('instance' => $t_rel_item)); // look up relationship type restrictions $va_restrict_to_relationship_types = $this->_getRelationshipTypeIDs($va_restrict_to_relationship_types, $va_facet_info['relationship_table']); $va_exclude_relationship_types = $this->_getRelationshipTypeIDs($va_exclude_relationship_types, $va_facet_info['relationship_table']); $va_joins = array(); $va_selects = array(); $va_wheres = array(); $va_orderbys = array(); if (!$va_facet_info['show_all_when_first_facet'] || $this->numCriteria() > 0) { $vs_cur_table = array_shift($va_path); foreach ($va_path as $vs_join_table) { $va_rel_info = $this->opo_datamodel->getRelationships($vs_cur_table, $vs_join_table); $va_joins[] = 'INNER JOIN ' . $vs_join_table . ' ON ' . $vs_cur_table . '.' . $va_rel_info[$vs_cur_table][$vs_join_table][0][0] . ' = ' . $vs_join_table . '.' . $va_rel_info[$vs_cur_table][$vs_join_table][0][1] . "\n"; $vs_cur_table = $vs_join_table; } } else { if ($va_facet_info['show_all_when_first_facet']) { $va_path = array_reverse($va_path); // in "show_all" mode we turn the browse on it's head and grab records by the "subject" table, rather than the browse table $vs_cur_table = array_shift($va_path); $vs_join_table = $va_path[0]; $va_rel_info = $this->opo_datamodel->getRelationships($vs_cur_table, $vs_join_table); $va_joins[] = 'LEFT JOIN ' . $vs_join_table . ' ON ' . $vs_cur_table . '.' . $va_rel_info[$vs_cur_table][$vs_join_table][0][0] . ' = ' . $vs_join_table . '.' . $va_rel_info[$vs_cur_table][$vs_join_table][0][1] . "\n"; } } if (sizeof($va_results) && $this->numCriteria() > 0) { $va_wheres[] = "(" . $t_subject->tableName() . '.' . $t_subject->primaryKey() . " IN (" . join(',', $va_results) . "))"; } if (!is_array($va_restrict_to_lists = $va_facet_info['restrict_to_lists'])) { $va_restrict_to_lists = array(); } if (is_array($va_restrict_to_lists) && sizeof($va_restrict_to_lists) > 0 && $t_rel_item->tableName() == 'ca_list_items') { $va_list_ids = array(); foreach ($va_restrict_to_lists as $vm_list) { if (is_numeric($vm_list)) { $vn_list_id = (int) $vm_list; } else { $vn_list_id = (int) ca_lists::getListID($vm_list); } if ($vn_list_id) { $va_list_ids[] = $vn_list_id; } } if (sizeof($va_list_ids) > 0) { $va_wheres[] = "{$vs_rel_table_name}.list_id IN (" . join(',', $va_list_ids) . ")"; } } if (is_array($va_restrict_to_types) && sizeof($va_restrict_to_types) > 0 && method_exists($t_rel_item, "getTypeList")) { $va_wheres[] = "{$vs_rel_table_name}.type_id IN (" . join(',', caGetOption('dont_include_subtypes', $va_facet_info, false) ? $va_restrict_to_types : $va_restrict_to_types_expanded) . ")" . ($t_rel_item->getFieldInfo('type_id', 'IS_NULL') ? " OR ({$vs_rel_table_name}.type_id IS NULL)" : ''); $va_selects[] = "{$vs_rel_table_name}.type_id"; } if (is_array($va_exclude_types) && sizeof($va_exclude_types) > 0 && method_exists($t_rel_item, "getTypeList")) { $va_wheres[] = "{$vs_rel_table_name}.type_id NOT IN (" . join(',', caGetOption('dont_include_subtypes', $va_facet_info, false) ? $va_exclude_types : $va_exclude_types_expanded) . ")"; } if (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_rel_item->hasField('access')) { $va_wheres[] = "(" . $t_rel_item->tableName() . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; // exclude non-accessible authority items if (!$va_facet_info['show_all_when_first_facet'] || $this->numCriteria() > 0) { $va_wheres[] = "(" . $vs_browse_table_name . ".access IN (" . join(',', $pa_options['checkAccess']) . "))"; // exclude non-accessible browse items } } if ($t_item->hasField('deleted') && !$va_facet_info['show_all_when_first_facet']) { $va_wheres[] = "(" . $t_item->tableName() . ".deleted = 0)"; } if ($t_rel_item->hasField('deleted')) { $va_wheres[] = "(" . $t_rel_item->tableName() . ".deleted = 0)"; } $vs_rel_pk = $t_rel_item->primaryKey(); $va_rel_attr_elements = $t_rel_item->getApplicableElementCodes(null, true, false); $va_attrs_to_fetch = array(); if (!$va_facet_info['show_all_when_first_facet'] || $this->numCriteria() > 0) { //$va_selects[] = $t_item->tableName().'.'.$t_item->primaryKey(); // get primary key of subject } $va_selects[] = $t_rel_item->tableName() . '.' . $vs_rel_pk; // get primary key of related $vs_hier_parent_id_fld = $vs_hier_id_fld = null; if ($vb_rel_is_hierarchical) { $vs_hier_parent_id_fld = $t_rel_item->getProperty('HIERARCHY_PARENT_ID_FLD'); $va_selects[] = $t_rel_item->tableName() . '.' . $vs_hier_parent_id_fld; if ($vs_hier_id_fld = $t_rel_item->getProperty('HIERARCHY_ID_FLD')) { $va_selects[] = $t_rel_item->tableName() . '.' . $vs_hier_id_fld; } } // analyze group_fields (if defined) and add them to the query $va_groupings_to_fetch = array(); if (isset($va_facet_info['groupings']) && is_array($va_facet_info['groupings']) && sizeof($va_facet_info['groupings'])) { foreach ($va_facet_info['groupings'] as $vs_grouping => $vs_grouping_name) { // is grouping type_id? if ($vs_grouping === 'type' && $t_rel_item->hasField('type_id')) { $va_selects[] = $t_rel_item->tableName() . '.type_id'; $va_groupings_to_fetch[] = 'type_id'; } // is group field a relationship type? if ($vs_grouping === 'relationship_types') { $va_selects[] = $va_facet_info['relationship_table'] . '.type_id rel_type_id'; $va_groupings_to_fetch[] = 'rel_type_id'; } // is group field an attribute? if (preg_match('!^ca_attribute_([^:]*)!', $vs_grouping, $va_matches)) { if ($vn_element_id = array_search($va_matches[1], $va_rel_attr_elements)) { $va_attrs_to_fetch[] = $vn_element_id; } } } } if ($va_facet_info['relative_to']) { // TODO: do this everywhere $va_restrict_to_relationship_types = array(); $vs_browse_type_limit_sql = ''; if ($t_subject->hasField('deleted')) { $va_wheres[] = "(" . $t_subject->tableName() . ".deleted = 0)"; } if ($va_relative_sql_data = $this->_getRelativeFacetSQLData($va_facet_info['relative_to'], $pa_options)) { $va_joins = array_merge($va_joins, $va_relative_sql_data['joins']); $va_wheres = array_merge($va_wheres, $va_relative_sql_data['wheres']); } } if (sizeof($va_restrict_to_relationship_types) > 0 && is_object($t_item_rel)) { $va_wheres[] = $t_item_rel->tableName() . ".type_id IN (" . join(',', $va_restrict_to_relationship_types) . ")"; } if (sizeof($va_exclude_relationship_types) > 0 && is_object($t_item_rel)) { $va_wheres[] = $t_item_rel->tableName() . ".type_id NOT IN (" . join(',', $va_exclude_relationship_types) . ")"; } if ($vs_browse_type_limit_sql) { $va_wheres[] = $vs_browse_type_limit_sql; } if ($this->opo_config->get('perform_item_level_access_checking')) { if ($t_item = $this->opo_datamodel->getInstanceByTableName($vs_browse_table_name, true)) { // Join to limit what browse table items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl ON ' . $vs_browse_table_name . '.' . $t_item->primaryKey() . ' = ca_acl.row_id AND ca_acl.table_num = ' . $t_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(ca_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(ca_acl.user_id IS NULL and ca_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND ca_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR ca_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; // Join to limit what related items are used to generate facet $va_joins[] = 'LEFT JOIN ca_acl AS rel_acl ON ' . $t_rel_item->tableName() . '.' . $t_rel_item->primaryKey() . ' = rel_acl.row_id AND rel_acl.table_num = ' . $t_rel_item->tableNum() . "\n"; $va_wheres[] = "(\n\t\t\t\t\t\t\t\t((\n\t\t\t\t\t\t\t\t\t(rel_acl.user_id = " . (int) $vn_user_id . ")\n\t\t\t\t\t\t\t\t\t" . (sizeof($va_group_ids) > 0 ? "OR\n\t\t\t\t\t\t\t\t\t(rel_acl.group_id IN (" . join(",", $va_group_ids) . "))" : "") . "\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t(rel_acl.user_id IS NULL and rel_acl.group_id IS NULL)\n\t\t\t\t\t\t\t\t) AND rel_acl.access >= " . __CA_ACL_READONLY_ACCESS__ . ")\n\t\t\t\t\t\t\t\t" . ($vb_show_if_no_acl ? "OR rel_acl.acl_id IS NULL" : "") . "\n\t\t\t\t\t\t\t)"; } } $vs_join_sql = join("\n", $va_joins); if ($vb_check_availability_only) { if (!$va_facet_info['show_all_when_first_facet'] || $this->numCriteria() > 0) { $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t" . (sizeof($va_wheres) ? ' WHERE ' : '') . join(" AND ", $va_wheres) . " LIMIT 1"; } else { $vs_sql = "\n\t\t\t\t\t\t\tSELECT 1\n\t\t\t\t\t\t\tFROM " . $t_rel_item->tableName() . "\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t" . (sizeof($va_wheres) ? ' WHERE ' : '') . join(" AND ", $va_wheres) . " LIMIT 1"; } $qr_res = $this->opo_db->query($vs_sql); //print "<hr>$vs_sql<hr>\n"; return (int) $qr_res->numRows() > 0 ? true : false; } else { if (!$va_facet_info['show_all_when_first_facet'] || $this->numCriteria() > 0) { $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT " . join(', ', $va_selects) . "\n\t\t\t\t\t\t\tFROM " . $vs_browse_table_name . "\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t" . (sizeof($va_wheres) ? ' WHERE ' : '') . join(" AND ", $va_wheres) . "\n\t\t\t\t\t\t\t\t" . (sizeof($va_orderbys) ? "ORDER BY " . join(', ', $va_orderbys) : ''); } else { $vs_sql = "\n\t\t\t\t\t\t\tSELECT DISTINCT " . join(', ', $va_selects) . "\n\t\t\t\t\t\t\tFROM " . $t_rel_item->tableName() . "\n\t\t\t\t\t\t\t{$vs_join_sql}\n\t\t\t\t\t\t\t\t" . (sizeof($va_wheres) ? ' WHERE ' : '') . join(" AND ", $va_wheres) . "\n\t\t\t\t\t\t\t\t" . (sizeof($va_orderbys) ? "ORDER BY " . join(', ', $va_orderbys) : ''); } //print "<hr>$vs_sql<hr>\n"; $qr_res = $this->opo_db->query($vs_sql); $va_facet = $va_facet_items = array(); $vs_rel_pk = $t_rel_item->primaryKey(); // First get related ids with type and relationship type values // (You could get all of the data we need for the facet in a single query but it turns out to be faster for very large facets to // do it in separate queries, one for the primary ids and another for the labels; a third is done if attributes need to be fetched. // There appears to be a significant [~10%] performance for smaller facets and a larger one [~20-25%] for very large facets) $vn_max_level = caGetOption('maximum_levels', $va_facet_info, null); while ($qr_res->nextRow()) { $va_fetched_row = $qr_res->getRow(); $vn_id = $va_fetched_row[$vs_rel_pk]; //if (isset($va_facet_items[$vn_id])) { continue; } --- we can't do this as then we don't detect items that have multiple rel_type_ids... argh. if (isset($va_criteria[$vn_id])) { continue; } // skip items that are used as browse critera - don't want to browse on something you're already browsing on if (!$va_facet_items[$va_fetched_row[$vs_rel_pk]]) { // if(!is_null($vn_max_level)) { // if (sizeof($va_ancestors) + 1 > $vn_max_level) { // if ($va_tmp = $va_ancestors[sizeof($va_ancestors) - $vn_max_level]) { // $va_ancestors = array(); // $va_fetched_row = $va_tmp['NODE']; // } // } // } if (is_array($va_restrict_to_types) && sizeof($va_restrict_to_types) && $va_fetched_row['type_id'] && !in_array($va_fetched_row['type_id'], $va_restrict_to_types)) { continue; } $va_facet_items[$va_fetched_row[$vs_rel_pk]] = array('id' => $va_fetched_row[$vs_rel_pk], 'type_id' => array(), 'parent_id' => $vb_rel_is_hierarchical ? $va_fetched_row[$vs_hier_parent_id_fld] : null, 'hierarchy_id' => $vb_rel_is_hierarchical ? $va_fetched_row[$vs_hier_id_fld] : null, 'rel_type_id' => array(), 'child_count' => 0); if (!is_null($vs_single_value) && $va_fetched_row[$vs_rel_pk] == $vs_single_value) { $vb_single_value_is_present = true; } } if ($va_fetched_row['type_id']) { $va_facet_items[$va_fetched_row[$vs_rel_pk]]['type_id'][] = $va_fetched_row['type_id']; } if ($va_fetched_row['rel_type_id']) { $va_facet_items[$va_fetched_row[$vs_rel_pk]]['rel_type_id'][] = $va_fetched_row['rel_type_id']; } } if (!isset($va_facet_info['dont_expand_hierarchically']) || !$va_facet_info['dont_expand_hierarchically']) { $qr_res->seek(0); $va_ids = $qr_res->getAllFieldValues($vs_rel_pk); $qr_ancestors = call_user_func($t_rel_item->tableName() . '::getHierarchyAncestorsForIDs', $va_ids, array('returnAs' => 'SearchResult')); $vs_rel_table = $t_rel_item->tableName(); $vs_rel_pk = $t_rel_item->primaryKey(); $vb_check_ancestor_access = (bool) (isset($pa_options['checkAccess']) && is_array($pa_options['checkAccess']) && sizeof($pa_options['checkAccess']) && $t_rel_item->hasField('access')); if ($qr_ancestors) { while ($qr_ancestors->nextHit()) { $vn_parent_type_id = $qr_ancestors->get('type_id'); if (sizeof($va_exclude_types) > 0 && in_array($vn_parent_type_id, $va_exclude_types)) { continue; } if (sizeof($va_restrict_to_types) > 0 && !in_array($vn_parent_type_id, $va_restrict_to_types)) { continue; } if ($vb_check_ancestor_access && !in_array($qr_ancestors->get('access'), $pa_options['checkAccess'])) { continue; } $va_facet_items[$vn_ancestor_id = (int) $qr_ancestors->get("{$vs_rel_pk}")] = array('id' => $vn_ancestor_id, 'type_id' => array(), 'parent_id' => $vb_rel_is_hierarchical ? $qr_ancestors->get("{$vs_hier_parent_id_fld}") : null, 'hierarchy_id' => $vb_rel_is_hierarchical && $vs_hier_id_fld ? $qr_ancestors->get($vs_hier_id_fld) : null, 'rel_type_id' => array(), 'child_count' => 0); } } } // Set child counts foreach ($va_facet_items as $vn_i => $va_item) { if ($va_item['parent_id'] && isset($va_facet_items[$va_item['parent_id']])) { $va_facet_items[$va_item['parent_id']]['child_count']++; } } // Get labels for facet items if (sizeof($va_row_ids = array_keys($va_facet_items))) { if ($vs_label_table_name = $t_rel_item->getLabelTableName()) { $t_rel_item_label = $this->opo_datamodel->getInstanceByTableName($vs_label_table_name, true); $vs_label_display_field = $t_rel_item_label->getDisplayField(); $vs_rel_pk = $t_rel_item->primaryKey(); $va_label_wheres = array(); if ($t_rel_item_label->hasField('is_preferred')) { $va_label_wheres[] = "({$vs_label_table_name}.is_preferred = 1)"; } $va_label_wheres[] = "({$vs_label_table_name}.{$vs_rel_pk} IN (" . join(",", $va_row_ids) . "))"; $va_label_selects[] = "{$vs_label_table_name}.{$vs_rel_pk}"; $va_label_selects[] = "{$vs_label_table_name}.locale_id"; $va_label_fields = $t_rel_item->getLabelUIFields(); foreach ($va_label_fields as $vs_label_field) { $va_label_selects[] = "{$vs_label_table_name}.{$vs_label_field}"; } // Get label ordering fields $va_ordering_fields_to_fetch = isset($va_facet_info['order_by_label_fields']) && is_array($va_facet_info['order_by_label_fields']) ? $va_facet_info['order_by_label_fields'] : array(); $va_orderbys = array(); foreach ($va_ordering_fields_to_fetch as $vs_sort_by_field) { if (!$t_rel_item_label->hasField($vs_sort_by_field)) { continue; } $va_orderbys[] = $va_label_selects[] = $vs_label_table_name . '.' . $vs_sort_by_field; } // get labels $vs_sql = "\n\t\t\t\t\t\t\t\t\tSELECT " . join(', ', $va_label_selects) . "\n\t\t\t\t\t\t\t\t\tFROM " . $vs_label_table_name . "\n\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_label_wheres) ? ' WHERE ' : '') . join(" AND ", $va_label_wheres) . "\n\t\t\t\t\t\t\t\t\t\t" . (sizeof($va_orderbys) ? "ORDER BY " . join(', ', $va_orderbys) : '') . ""; //print $vs_sql; $qr_labels = $this->opo_db->query($vs_sql); while ($qr_labels->nextRow()) { $va_fetched_row = $qr_labels->getRow(); $va_facet_item = array_merge($va_facet_items[$va_fetched_row[$vs_rel_pk]], array('label' => $va_fetched_row[$vs_label_display_field])); foreach ($va_ordering_fields_to_fetch as $vs_to_fetch) { $va_facet_item[$vs_to_fetch] = $va_fetched_row[$vs_to_fetch]; } $va_facet[$va_fetched_row[$vs_rel_pk]][$va_fetched_row['locale_id']] = $va_facet_item; } } // get attributes for facet items if (sizeof($va_attrs_to_fetch)) { $qr_attrs = $this->opo_db->query("\n\t\t\t\t\t\t\t\t\tSELECT c_av.*, c_a.locale_id, c_a.row_id\n\t\t\t\t\t\t\t\t\tFROM ca_attributes c_a\n\t\t\t\t\t\t\t\t\tINNER JOIN ca_attribute_values c_av ON c_a.attribute_id = c_av.attribute_id\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tc_av.element_id IN (" . join(',', $va_attrs_to_fetch) . ")\n\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\tc_a.table_num = ? \n\t\t\t\t\t\t\t\t\t\tAND \n\t\t\t\t\t\t\t\t\t\tc_a.row_id IN (" . join(',', $va_row_ids) . ")\n\t\t\t\t\t\t\t\t", $t_rel_item->tableNum()); while ($qr_attrs->nextRow()) { $va_fetched_row = $qr_attrs->getRow(); $vn_id = $va_fetched_row['row_id']; // if no locale is set for the attribute default it to whatever the locale for the item is if (!($vn_locale_id = $va_fetched_row['locale_id'])) { $va_tmp = array_keys($va_facet[$vn_id]); $vn_locale_id = $va_tmp[0]; } $va_facet[$vn_id][$vn_locale_id]['ca_attribute_' . $va_fetched_row['element_id']][] = $va_fetched_row; } } } if (!is_null($vs_single_value) && !$vb_single_value_is_present) { return array(); } return caExtractValuesByUserLocale($va_facet); } break; # ----------------------------------------------------- # ----------------------------------------------------- default: return null; break; # ----------------------------------------------------- } }
$va_template_tags[] = "{$vn_element_id}_label"; $va_initial_values[$vn_attr_id]["{$vn_element_id}_label"] = ''; $va_item_ids[] = (int) $vs_display_val; } } $va_initial_values[$o_attr->getAttributeID()]['locale_id'] = $o_attr->getLocaleID(); // set errors for attribute if (is_array($va_action_errors = $this->request->getActionErrors($vs_error_source_code, $o_attr->getAttributeID()))) { foreach ($va_action_errors as $o_error) { $va_errors[$o_attr->getAttributeID()][] = array('errorDescription' => $o_error->getErrorDescription(), 'errorCode' => $o_error->getErrorNumber()); } } } if (sizeof($va_item_ids)) { $t_list_item = new ca_list_items(); $va_labels = $t_list_item->getPreferredDisplayLabelsForIDs($va_item_ids); foreach ($va_initial_values as $vn_attr_id => $va_values) { foreach ($va_values as $vn_element_id => $vs_value) { $va_initial_values[$vn_attr_id][$vn_element_id . '_label'] = $va_labels[$va_initial_values[$vn_attr_id][$vn_element_id]]; } } } } else { // set labels for replacement in blank lookups if (is_array($va_element_ids)) { foreach ($va_element_ids as $vn_element_id) { $va_template_tags[] = "{$vn_element_id}_label"; } } } // bundle settings