[TechDaddies-Kevin]

This is a bit difficult to explain. We are using Ion Auth and GC on a new CI project. We have a simple form that allows an admin to create a record by entering a name and selecting an owner. The relation currently looks like this:

 

$crud->set_relation('owner_id','users','email');

 

The problem is that this is showing ALL of the users in from the users table. We need to filter the dropdown to show only users where the user belongs to user group ID 10. The users-->groups associations are stored in users_groups which has columns for user_id and group_id;

 

So basically for the relation, we need it to show users.email where users.id is in (SELECT user_id FROM users_groups WHERE group_id=10).

 

How can we accomplish this in GC? I believe we might have to use a custom model to do this, but I'm having trouble understanding how to implement it.

 

Thanks in advance.

[Christophe Conduché]

same type of problem for me !

I will be pleased to read how you manage this ?

[victor]

do you need to have filter on the add/edit pages?

[TechDaddies-Kevin]

Yes. When adding or editing a record from this table, we need this filter to be active.

[victor]

I think the calback_add_field/calback_edit_field functions are for you

[victor]

http://www.grocerycrud.com/documentation/options_functions/callback_add_field

[TechDaddies-Kevin]

So you're saying to use callback add_field and callback_edit_field to run my own query and generate my own code to show the dropdown?

[victor]

yes, I mean that

[davidoster]

To be honest I find it easier to build a new model and just say,

/* sample code */

//mymodel.php under application/models
<?php
class mymodel extends CI_Model  {
	
	function __construct()
	{
		parent::__construct();
		$this->load->database();
	}

        public function get_activities_by_year($table, $year)
	{
		$this->db->select('id, year, description');
		$this->db->where('year', $year);
                $this->db->order_by('id desc');
		return $this->db->get($table);
	}


}

//controller.php
...
$this->load->model('mymodel');
$activities = $this->mymodel->get_activities_by_year("activities","2013");
foreach ($activities->result() as $row)
{
 $myarray[$row->id] .= $row->description;
}
$this->grocery_crud->field_type('interest_for','multiselect',$myarray);
...

[TechDaddies-Kevin]

Ah, excellent! I had no idea that you could do it like that. That workflow fits much more with the way I do things, as well.

 

Thanks so much!

[Christophe Conduché]

thanks too ! I keep this one in my "top hints" list ;-)

[heruprambadi]

i just want to correct here.

when i copied that code, i got some error.

it toke 12 hours for me to know that there is a point (.) there, before equals.

$myarray[$row->id] .= $row->description;

just delete it.