}
}
}
if ($col == 1) {
print "</tr></table>\n";
}
print "</div>";
#print $vs_occ_search_text;
$o_db = new Db();
$q_date_element = $o_db->query("SELECT element_id FROM ca_metadata_elements WHERE element_code = 'parsed_date'");
if ($q_date_element->numRows() > 0) {
$q_date_element->nextRow();
$vn_parsed_date_element_id = $q_date_element->get("element_id");
}
$t_occ = new ca_occurrences();
$vn_occ_tablenum = $t_occ->tableNum();
if ($vn_parsed_date_element_id) {
//$q_date_element->numRows();
$q_occs = $o_db->query("SELECT o.occurrence_id, o.type_id, av.value_decimal1\n\t\t\t\t\t\t\t\t\tFROM ca_occurrences o\n\t\t\t\t\t\t\t\t\tINNER JOIN ca_objects_x_occurrences AS oxo ON oxo.occurrence_id = o.occurrence_id\n\t\t\t\t\t\t\t\t\tINNER JOIN ca_attributes AS a ON a.row_id = o.occurrence_id\n\t\t\t\t\t\t\t\t\tINNER JOIN ca_attribute_values AS av ON a.attribute_id = av.attribute_id\n\t\t\t\t\t\t\t\t\tWHERE oxo.object_id IN (" . join(", ", $va_child_artworks) . ") AND o.access=1 AND a.table_num = " . $vn_occ_tablenum . " AND av.element_id = " . $vn_parsed_date_element_id . "\n\t\t\t\t\t\t\t\t\tORDER BY av.value_decimal1\n\t\t\t\t\t\t\t\t\t");
}
$va_sorted_occurrences = array();
#$va_occurrences = $t_object->get("ca_occurrences", array("returnAsArray" => 1, 'checkAccess' => $va_access_values, 'sort' => array('ca_occurrences.date.parsed_date')));
if ($q_occs->numRows()) {
$va_item_types = $t_occ->getTypeList();
while ($q_occs->nextRow()) {
# --- get the objects associated to each record to list out after bib or exhibition listing
$q_obj = $o_db->query("SELECT o.idno\n\t\t\t\t\t\t\t\t\tFROM ca_objects_x_occurrences oxo\n\t\t\t\t\t\t\t\t\tINNER JOIN ca_objects AS o ON oxo.object_id = o.object_id\n\t\t\t\t\t\t\t\t\tWHERE oxo.occurrence_id = ? AND o.access=1 AND o.object_id IN (" . join(", ", $va_child_artworks) . ")\n\t\t\t\t\t\t\t\t\tORDER BY o.idno_sort\n\t\t\t\t\t\t\t\t\t", $q_occs->get("ca_occurrences.occurrence_id"));
$va_related_obj_idnos = array();
if ($q_obj->numRows()) {
while ($q_obj->nextRow()) {
$va_related_obj_idnos[] = $q_obj->get("ca_objects.idno");
