type = 'stormorganization';
$header = array(
array(
'data' => t('Name'),
'field' => 'n.title',
'sort' => 'ASC',
),
array(
'data' => t('Country'),
'field' => 'sor.country',
'sort' => '',
),
array(
'data' => storm_icon_add_node($i, $_GET),
'class' => 'storm_list_operations',
),
);
$s = "SELECT n.*, sor.* FROM {node} AS n INNER JOIN {stormorganization} AS sor ON n.vid=sor.vid WHERE n.status=1 AND n.type='stormorganization'";
$where = array();
$args = array();
if ($_SESSION['stormorganization_list_filter']['country']) {
$where[] = "sor.country='%s'";
$args[] = $_SESSION['stormorganization_list_filter']['country'];
}
if ($_SESSION['stormorganization_list_filter']['name']) {
$where[] = "LOWER(n.title) LIKE LOWER('%s')";
$args[] = $_SESSION['stormorganization_list_filter']['name'];
}
$itemsperpage = $_SESSION['stormorganization_list_filter']['itemsperpage'];
$s = stormorganization_access_sql($s, $where);
$s = db_rewrite_sql($s);
$tablesort = tablesort_sql($header);
$r = pager_query($s . $tablesort, $itemsperpage, 0, NULL, $args);
$organizations = array();
while ($organization = db_fetch_object($r)) {
$organizations[] = $organization;
}
$o .= theme('stormorganization_list', $header, $organizations);
$o .= theme('pager', NULL, $itemsperpage, 0);
print theme('page', $o);
}
function stormorganization_list_filter() {
$country = $_SESSION['stormorganization_list_filter']['country'];
$name = $_SESSION['stormorganization_list_filter']['name'];
$itemsperpage = $_SESSION['stormorganization_list_filter']['itemsperpage'];
if (!$itemsperpage) {
$itemsperpage = 10;
$_SESSION['stormorganization_list_filter']['itemsperpage'] = $itemsperpage;
}
$form = array();
$form['filter'] = array(
'#type' => 'fieldset',
'#title' => t('Filter'),
'#collapsible' => TRUE,
'#collapsed' => TRUE,
'#weight' => -20,
);
$form['filter']['country'] = array(
'#type' => 'select',
'#title' => t('Country'),
'#default_value' => $country,
'#options' => array(0 => t('All')) + stormattribute_attributes_bydomain('Country'),
);
$form['filter']['name'] = array(
'#type' => 'textfield',
'#title' => t('Name'),
'#default_value' => $name,
'#autocomplete_path' => 'storm/organizations/autocomplete',
);
$qs = '';
foreach (range(0, 9) as $n) {
$qs .= '- '. l($n, 'storm/organizations', array(), 'name='. $n .'%') .'
';
}
$form['filter']['name_quick_shortcuts_numbers'] = array(
'#type' => 'markup',
'#value' => $qs,
);
$qs .= '
';
foreach (range('A', 'Z') as $l) {
$qs .= '- '. l($l, 'storm/organizations', array(), 'name='. $l .'%') .'
';
}
$qs .= '
',
'#suffix' => '
',
);
return $form;
}
function stormorganization_list_filter_submit($form_id, $form_values) {
if ($form_values['op'] == t('Filter')) {
stormorganization_list_filter_filter($form_id, $form_values);
}
else if ($form_values['op'] == t('Reset')) {
stormorganization_list_filter_reset($form_id, $form_values);
}
}
function stormorganization_list_filter_filter($form_id, $form_values) {
$_SESSION['stormorganization_list_filter']['country'] = $form_values['country'];
$_SESSION['stormorganization_list_filter']['name'] = $form_values['name'];
$_SESSION['stormorganization_list_filter']['itemsperpage'] = $form_values['itemsperpage'];
}
function stormorganization_list_filter_reset($form_id, &$form_values) {
unset($_SESSION['stormorganization_list_filter']);
}
function stormorganization_autocomplete($string = '') {
$matches = array();
if ($string) {
$s = "SELECT title FROM {node} AS n WHERE n.type='stormorganization' AND LOWER(title) LIKE LOWER('%s%%')";
$s = stormorganization_access_sql($s);
$s = db_rewrite_sql($s);
$result = db_query_range($s, $string, 0, 10);
while ($org = db_fetch_object($result)) {
$matches[$org->title] = check_plain($org->title);
}
}
print drupal_to_js($matches);
exit();
}