Crits created_by

jcvieira

Hi guys, i have the following code:



			$me = CRM_ContactsCommon::get_my_record();

			$rs = new TPN_SalesManagement_BCom();

			$this->rb = $rs->create_rb_module($this, 'Completed_Business');

			$crits = array('created_by' => $me["id"]);

			$this->display_module($this->rb, array($crits));

However this does not filter my rb view, still displays all the records like it is ignoring the crits... How can i accomplish this?
Thanks

ajb

Yes, because this is a special field so you have to prepend colon ':'
Here are special fields crits

             case ':Fav' :  -- value doesn't matter

                    case ':Sub' : -- value doesn't matter

                    case ':Recent'  :  -- value doesn't matter

                    case ':Created_on'  :

                    case ':Created_by'  :

                    case ':Edited_on'

For Fav,Sub,Recent you'll get respective records for current user.
Your case (you should use user id, not contact id):



$user_id = Base_AclCommon::get_user();

$crits = array(':Created_by' => $user_id);

Regards,
Adam

jcvieira

Hi ajb! Thanks for that however when i tried to follow your example i get a sql error:

Message: mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1, f_contract_signed_date DESC LIMIT 0,20' at line 1] in EXECUTE("SELECT * FROM TPN_SM_BCom_data_1 AS r WHERE active=1 AND true ORDER BY Created_by 1, f_contract_signed_date DESC LIMIT 0,20")

Using:

			$rs = new TPN_SalesManagement_BCom();

			$this->rb = $rs->create_rb_module($this, 'Completed_Business');

			

			$this->rb->set_default_order(array(':id'=>'DESC'));

			

			$user_id = Base_AclCommon::get_user();

			$crits = array(':created_by' => $user_id);

			$this->display_module($this->rb,array($crits));

ajb

You've passed crits as order param.
It should be like that:

   $order = array();

$this->display_module($this->rb,array($order, $crits));

jcvieira

[quote="ajb":2259v1a2]You've passed crits as order param.
It should be like that:

   $order = array();

$this->display_module($this->rb,array($order, $crits));

[/quote:2259v1a2]

Ummm. Ok so if that is the case should not the tutorial at http://www.epesi.org/HelloWorld_-_part_6_addons with the example

public function company_addon($record) {

 

       $rs = new Custom_HelloWorld_Recordset();

       $this->rb = $rs->create_rb_module($this);

 

       $crits = array('text' => $record['company_name']); //set relations between fields

       $cols = array('text' => true); // set false if you do not want the field to be visible in header

       $show_data_params = array($crits, $cols);

 

       $this->display_module($this->rb, $show_data_params, 'show_data');

}

being the other way round?

ajb

Here:

       $this->display_module($this->rb, $show_data_params, 'show_data');

is used show_data function. It has crits as a first param.
Here (without third argument to display_module):

$this->display_module($this->rb,array($order, $crits));

is used body function. It has crits as a second param.

Regards,
Adam

jcvieira

[quote="ajb":2qkohnsh]Here:

       $this->display_module($this->rb, $show_data_params, 'show_data');

is used show_data function. It has crits as a first param.
Here (without third argument to display_module):

$this->display_module($this->rb,array($order, $crits));

is used body function. It has crits as a second param.

Regards,
Adam[/quote:2qkohnsh]

AAh! Hence the confusion! 🙂
Thanks to your reply and i have one more question if u dont mind:

Is it possible to something like this:

$crits = array("Client" => "in (Select id as Client from company_data_1 where created_by='$user_id')");

ajb

Unfortunately with created_by no. You could do this with any field - it hasn't been implemented for special fields

array('client[address]' => 'street 1')

It means: get all records, where client's address i street 1

In your case you should get all IDs and prepare crits with all IDs.

$recs = Utils_RecordBrowser::get_records('company', array(':Created_by' => $user_id));

$ids = array();

foreach ($recs as $r) $ids[] = $r['id'];

$crits = array('client' => $ids);

Regards,
Adam

jcvieira

[quote="ajb":nh822za7]Unfortunately with created_by no. You could do this with any field - it hasn't been implemented for special fields

array('client[address]' => 'street 1')

It means: get all records, where client's address i street 1

In your case you should get all IDs and prepare crits with all IDs.

$recs = Utils_RecordBrowser::get_records('company', array(':Created_by' => $user_id));

$ids = array();

foreach ($recs as $r) $ids[] = $r['id'];

$crits = array('client' => $ids);

Regards,
Adam[/quote:nh822za7]

Thanks adam will give this a try.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge