db_select szűrés lapozása

function data_form($form, &$form_state){
 
  $list = array();
  // SQL select for $list ....
  // filter form ***************************
  $form['filter'] = array(
    '#type' => 'fieldset',
    '#title' => t('Filter option')
  );
 
  $form['filter']['filter_id'] = array(
    '#type' => 'select',
    '#title' => t('Filter'),
    '#options' => $list,
    '#default_value' => isset( $form_state['values']['filter_id'] )? $form_state['values']['filter_id'] : '',
  );
  $form['filter']['filter_button'] = array(
    '#type' => 'submit',
    '#value' => t('Filter'),
  );
  // **************************************
 
 
 
 
 
  // headers
  $header = array(
    array('data' => ' ID', 'field' => 'id', 'sort' => 'asc', 'width' => '120'),
    array('data' => t('Value'), 'field' => 'value'),
    );
 
  // rows
  $rows = array();
 
  // SQL ***
  db_set_active('server');
  $query = db_select('data', 'd')->extend('PagerDefault')->extend('TableSort');
  $query->fields( 'd', array('id', 'value') );
  // filter if it exists
  if ( isset($form_state['values']['filter_id']) AND !empty($form_state['values']['filter_id']) ) $query->condition('d.id', $form_state['values']['filter_id'],'=');
  // filter end
 
  $result = $query
    ->limit(50)
    ->orderByHeader($header)
    ->execute();
 
  foreach ($result as $record) {
      $rows[] = array(
          'id' => $record->id,
          'value' => $record->value,
          );
    } // foreach
  db_set_active('default');
  // ******
 
 
  // build table
  $form['title'] = array(
    '#theme' => 'table',
    '#header' => array( t('Data') ),
  );
  $form['data_table'] = array(
    '#theme' => 'table',
    '#header' => $header,
    '#rows' => $rows,
    );
  $form['data_pager'] = array(
    '#theme' => 'pager',
    );
 
  return $form;
}
 
 
 
function data_form_submit($form, &$form_state) {
  $form['filter']['filter_id'] = $form_state['values']['filter_id'];
  $form_state['rebuild'] = TRUE;
}