Searching

jplozano · June 2011

Why does the search work only on some of the tables?
I need it to work on a table where its main field is named "text" (not "name"). Where do I set that?
Thanks.

admin · June 2011

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

Got it! Thx.

jmobile · July 2011

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

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

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

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

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

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

jmobile · July 2011

none

jmobile · July 2011

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

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

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

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

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

eriklharper · March 2012

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

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

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

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

Howdy, Stranger!

Categories

Searching

Comments