Searching

Comments

• admin

  June 2011 edited 3:33PM

  Set your display_field value for your module in your MY_fuel_modules.php file to 'text'. Additionally, you can add "filters" field names to your model. The fuel/modules/blog/models/blog_posts_model.php file has an example:
  http://www.getfuelcms.com/user_guide/libraries/base_module_model
• jplozano

  June 2011 edited 3:33PM

  Got it! Thx.
• jmobile

  July 2011 edited 3:33PM

  How do you add more UI elements for searching other than a generic text search field UI? Like several drop down lists or a combination of them? Or maybe an Advanced Search option.
• admin

  July 2011 edited 3:33PM

  You can add a filter property to your module. The property should contain an array of form_builder fields (similar to a model's form_fields method).
  The navigation module has something similar if you view the fuel/modules/fuel/config/fuel_modules.php
  
  The options for the navigation modules drop down are set in it's controller.
• jmobile

  July 2011 edited July 2011

  Ok, I tried to implement this and getting stuck. I see the Category UI filter drop down list on my list view but there's no list items being displayed.
  
  I built a controller to use an existing model.
  
  <?php
  
  require_once(FUEL_PATH.'models/module.php');
  
  class Drills extends Module {
  
  function __construct()
  {
  parent::__construct();
  }
  
  function items()
  {
  $CI =& get_instance();
  $CI->load->model('categories_model');
  if (!empty($this->filters['category_id'])) $this->filters['category_id']['options'] = $this->categories_model->options_list('id', 'name', array(), false);
  parent::items();
  }
  }
  
  What else am I missing? Can you provide a working example?
• admin

  July 2011 edited 3:33PM

  What does your module configuration parameters look like? Does it include a line like so:
  'filters' => array('category_id' => array('default' => 1, 'label' => 'Category'), 'type' => 'select'))
  Also, as an FYI, since you are in a controller, you don't need to use $CI =& get_instance() since the $CI object is the Drills controller
• jmobile

  July 2011 edited 3:33PM

  Here's my module config parms:
  
  $config['modules']['drills'] = array(
  'module_name' => 'Drills',
  'model_location' => 'drills',
  'display_field' => 'categories.name',
  'default_col' => 'categories.name',
  'default_order' => 'asc',
  'filters' => array('category_id' => array('default' => 1, 'label' => 'Category', 'type' => 'select')),
  'instructions' => 'Here you can manage your drills'
  );
• admin

  July 2011 edited 3:33PM

  Do any values appear if you do a print_r on $this->filters['category_id']['options'] in the controller?
• jmobile

  July 2011 edited 3:33PM

  none
• jmobile

  July 2011 edited 3:33PM

  I'm still stuck on how to implement drop down list box as well as customizing the search fields. Where is the best place to start my own custom search using some basic layout.
  
  Type [list box] Status [lsit box]
  Last Name [text field] First Name [text field]
  City [text field] State [list box]
  Active [checkbox]
  
  I'd like this to replace the existing one line - [text field] Search button implementation.
• admin

  July 2011 edited 3:33PM

  If $this->categories_model->options_list('id', 'name', array(), false); returns an empty array, then the options parameter will also be empty and you will not see anything in the dropdown. Do you have any categories in the database? You can further debug the query by using the debug_query method after it is called like so:
  ... if (!empty($this->filters['category_id'])) $this->filters['category_id']['options'] = $this->categories_model->options_list('id', 'name', array(), false); $this->categories_model->debug_query(); ...
• jmobile

  August 2011 edited 3:33PM

  Would it be possible to post a working example using the existing Authors, Articles and Categories module? I think it would help others than myself see a working example of customizing the search fields.
• admin

  August 2011 edited 3:33PM

  I can put it on the list, but unfortunately, it probably won't be for a while. However, in the meantime, you can send me your model(s) and SQL and I can take a look at it for you (email is in my profile).
• jmobile

  November 2011 edited 3:33PM

  Does anyone have any examples of providing multiple search fields within the admin UI?
• eriklharper

  March 2012 edited 3:33PM

  I'm trying to do a similar thing with a simple module in the Fuel admin as well. I have a field called "status" with 2 options: open and sent stored as enum and a field called "type" with multiple options stored as enum in the corresponding table that the model is associated with and would like to expose these as filters on the list view in Fuel.
  
  I have this so far in MY_fuel_modules.php configuration:
  
  $config['modules']['gift_certificates'] = array( 'module_name' => 'Gift Certificates', 'module_uri' => 'gift_certificates', 'model_name' => 'gift_certificates_model', 'model_location' => 'store', 'table_headers' => array( 'id', 'gift_certificate_number', 'type', 'status', 'transaction_id', 'transaction_date', 'customer_zip' ), 'display_field' => 'type', 'permission' => 'gift_certificates', 'instructions' => lang('module_instructions_default', 'gift certificates'), 'archivable' => FALSE, 'nav_selected' => 'gift_certificates', 'hidden' => TRUE, 'table_actions' => array('view'), 'item_actions' => array('view'), 'rows_selectable' => FALSE, 'filters' => array ( 'type' => array('default' => 0, 'label' => lang('gift_certificate_type'), 'type' => 'select'), 'status' => array('default' => 0, 'label' => lang('gift_certificate_status'), 'type' => 'select') ) );
  
  The filters look correctly defined, no? I am experiencing the same empty dropdown issue jmobile mentioned. I am NOT using a controller for the module, so do I need to add that in as demonstrated by jmobile's example or can Fuel "discover" the allowed values for the two columns and automatically populate the dropdown with those values?
  
  Thanks,
  Erik
• Lance

  March 2012 edited 3:33PM

  The select is populated if you add an options array to your config though right?
  
  For example this works for me:
  $config['modules']['posts'] = array( 'filters' => array( 'post_type' => array( 'default' => 'blog', 'label' => 'Post type', 'type' => 'select', 'options' => array( 'blog' => 'Blog', 'story' => 'Story' ) ), 'title' => array( 'default' => 'blog', 'label' => 'Post type', 'type' => 'select', 'options' => array( 'one' => 'Test one', 'two' => 'Test two' ) ) ), );
  
  Just had a quick look and I don't see anywhere that it automatically pulls values to build the options array. Maybe I missed it. I'm looking in fuel's module::items() controller method.
  Dave's comment above is setting the options in a controller with options_list(). You'll not be able to get at your model in the config files to do that there. Might be able to do it in a hook if you don't want to write a controller. I've done that with js_controller_params[] before.
• dom

  February 2014 edited 3:33PM

  Hi there,
  
  I am trying the same thing as Lance, but it only seems to work for the first filter - I get PHP errors for the 2nd filter:
  
  A PHP Error was encountered
  Severity: Warning
  Message: strtolower() expects parameter 1 to be string, array given
  Filename: models/base_module_model.php
  Line Number: 374
  
  Both fields are enums. And it only seems to work if they are in the model (not in the config file).
  
  public $filters = array( 'customer_type' => array( 'default' => 'res', 'label' => 'Customers', 'type' => 'select', 'options' => array( 'res' => 'Residential', 'sme' => 'SME' ), ), 'shape' => array( 'default' => 'flat', 'label' => 'Shape', 'type' => 'select', 'options' => array( 'flat' => 'Flat', 'bump' => 'Bumpy', 'spike' => 'Spikey', ) ) ); // filters to apply to when searching for items
  
  Any ideas?
• admin

  February 2014 edited 3:33PM

  Is there possibly an error in how your are nesting your arrays for the module version? Can you post that code as well.