Adding a Category dropdown to an advanced module

geestring · January 2014

I started working with FuelCMS a week ago, and now I'm trying to add the category feature to my module.

I added public $foreign_keys = array('category_id' => array(FUEL_FOLDER => 'fuel_categories_model')); at the top of my model class. It appears it is working as I now have a dropdown with my categories, however when I hit save the dropdown reverts back to the default "select one" option. I have no idea if the category was saved, and I don't see anything in the database as well.

Is there something I must do in the form_fields method?

admin · January 2014

Does your database table for you model have a field of "category_id" in it?

geestring · January 2014

No, I don't. So I must create a category_id column in the table I want to use categories?

geestring · January 2014

Ok thanks it worked.

My next question is about displaying the category name in the list display. Currently it'll just show the category_id. Can I do a join query in the list_items method?

admin · January 2014

Sure. You can use any normal CI active record you want.


function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'desc', $just_count = FALSE)
{
     $this->db->join('fuel_categories', 'fuel_categories.id = category_id', 'left');
     $this->db->select('my_table.id fuel_categories.name as category, my_table.publish);
     return parent::data($limit, $offset, $col, $order, $just_count);
}

Howdy, Stranger!

Categories

Adding a Category dropdown to an advanced module

Comments