function filter model

Comments

• admin

  January 2018 edited 2:41AM

  In the model's list_items method, add a select like so:
  
  public function list_items($limit = NULL, $offset = NULL, $col = 'last_updated', $order = 'desc', $just_count = FALSE) { $this->db->select('table.id, table.field1, table.field2...'); $data = parent::list_items($limit, $offset, $col, $order, $just_count); }
• younesrc

  January 2018 edited 2:41AM

  public function filters(){
  
  if (defined('FUEL_ADMIN'))
  {
  $CI =& get_instance();
  }
  
  $ds = $this->get_articles();
  
  
  
  $sq = array();
  
  foreach ($ds as $cb)
  {
  $sq[$cb->id_type_bien] = $cb->id_type_bien;
  }
  
  $filters['id_type_bien'] = array(
  'label' => 'Filter',
  'type' => 'select',
  'options' => $sq,
  'first_option' => 'Show All'
  );
  
  return $filters;
  }
  
  it lists all the table elements
• admin

  January 2018 edited 2:41AM

  Are you referring to the select options displaying all of the items or the data result being returned by the filters? I'm not sure what I'm looking at here.
• younesrc

  January 2018 edited January 2018

  thanks ,
  that's why I ask you to correct it, please give me the exact function
• admin

  January 2018 edited 2:41AM

  Sorry, but I'm unclear as to what you are asking for. Are you wanting the data results returned from the table filtered view to not display all the columns? If so, see my post above about using the select statement.