simple module - best way to show JOINed data

Comments

• admin

  November 2013 edited 7:59PM

  Normally this is handled by having an "add / edit" button next to the field. This can be done in .93 by doing the following:
  $fields['my_field']['class'] = 'add_edit my_module';
  In 1.0, there is actually an "inline_edit" field type (http://docs.getfuelcms.com/general/forms#inline_edit) you can use. However, it sounds like you are wanting to flatten it into one set of fields for both. If so, there are a few things you may want to do:
  
  1. For modifying the list view of data of your module, you can do something like the following:
  // in locations_model function list_items($limit = NULL, $offset = NULL, $col = 'filename', $order = 'asc', $just_count = FALSE) { $this->db->select('locations.id, images.filename, lat,long, published'); // I added published just because FUEL will automatically not display those that aren't published $this->db->join('images', 'images.location_id = locations.id', 'left'); $data = parent::list_items($limit, $offset, $col, $order, $just_count); return $data; }
  
  2. For modifying the form fields of the module, you will need to add those additional fields in your model's form_fields method and save them to the database in an on_after_save model hook (http://docs.getfuelcms.com/general/models#hooks). You can access all the posted data through the model property of "normalized_save_data" (as opposed to the $values array passed to the hook which only has the values associated with that particular model). below is an example:
  // in locations_model
function on_after_save($values)
{
// call the parent
$values = parent::on_after_save($values);

// if no category is selected, then we set it to the Uncategorized
$saved_data = $this->normalized_save_data;
if (!empty($saved_data['filename']))
{
$model = $this->load_model('images'); // 1.0 syntax... otherwise you'll need to use $this->load->model(...)
$images_save['filename'] = $saved_data['filename'];
$images_save['location_id'] = $values['id']; // this would be the location ID since this is the locations model.
$model->save($images_save);
}
return $values;
}
• __croaker

  November 2013 edited 7:59PM

  Thanks.
  
  It was the joined data for the form_fields() method I was having trouble loading until I noticed _common_query() (from the "The Categories to Articles Lookup Model" section of http://getfuelcms.com/user_guide/modules/tutorial) and realised I needed to put the select() and join() in there too.
  
  Works a treat.
• admin

  November 2013 edited 7:59PM

  Ah yes. _common_query will work for all find_{method}s and retrieving the data to edit for a record in the CMS uses the find_all_array method by default.