function execute($options = array()) { $options = array_merge($this->getOptions(), $options); require_once 'AMP/UserData/Lookups.inc.php'; $index_title = AMP_pluralize($this->udm->name) . " By " . $options['index_name']; $index_set =& FormLookup_Variant::instance($options['index_field'], $this->udm->instance); #$index['state']['sql'].="SELECT count(userdata.id) as qty, userdata.State as item_key, states.statename as item_name from userdata, states WHERE userdata.State=states.state and modin=".$_REQUEST['modin']." GROUP BY userdata.State "; $translated_values = isset($this->_region_lookups[$options['index_field']]) ? AMPSystem_Lookup::locate($this->_region_lookups[$options['index_field']]) : AMPSystem_Lookup::locate(array('instance' => AMP_pluralize($options['index_field']))); require_once 'AMP/Content/Display/HTML.inc.php'; $renderer = new AMPDisplay_HTML(); $output = $renderer->bold($index_title) . $renderer->newline(); foreach ($index_set as $index_value => $index_count) { $display_value = $translated_values && isset($translated_values[$index_value]) ? $translated_values[$index_value] : $index_value; $display_value .= ' (' . $index_count . ')'; $link_value = AMP_URL_AddVars($_SERVER['PHP_SELF'], array($options['index_field'] => strtolower($options['index_field']) . '=' . $index_value, 'modin' => 'modin=' . $this->udm->instance)); $output .= $renderer->link($link_value, $display_value) . $renderer->newline(); #$output .= '<a href="'.$_SERVER['PHP_SELF'].'?'.$options['index_field'].'='.$index_value.'&modin='.$_REQUEST['modin'].'">'.$index_item['item_name'].'</a> ('.$index_item['qty'].')<BR>'; } return $output; }
function AMP_evalLookup($lookup_def) { if (is_object($lookup_def)) { return $lookup_def->dataset; } if (!is_array($lookup_def)) { return AMP_lookup($lookup_def); } if (isset($lookup_def['name']) && isset($lookup_def['var'])) { return AMP_lookup($lookup_def['name'], $lookup_def['var']); } if (isset($lookup_def['instance'])) { return AMPSystem_Lookup::locate($lookup_def); } return array(); }
function _mapLists() { foreach ($this->menuset as $menu_id => $menu_def) { if (!isset($menu_def['list'])) { continue; } if (!isset($menu_def['list']['lookup'])) { continue; } if (!is_array($menu_def['list']['lookup'])) { $itemset =& AMPSystem_Lookup::instance($menu_def['list']['lookup']); } else { $itemset =& AMPSystem_Lookup::locate($menu_def['list']['lookup']); } if (!$itemset) { continue; } $sep = isset($menu_def['list']['separator']) ? $menu_def['list']['separator'] : false; foreach ($itemset as $id => $name) { $this->_addListItem($id, $name, $menu_id, $menu_def['list']['href'], $sep); $sep = false; } } return true; }