Relations between fields.

contel

Hello Epesi Team.

I have some problems with relations between fields in addons.
I have noticed if you want make one field have one relation with another field of another module, this field must be a RBO_Field_Text. This is for me one problem because I want that this field be a RBO_Field_Select. In this case I can restrict the information in this field with data I wish. But when I make this type of field and configure the relation, this doesn't works.
For example: I have one recordset in my module. In this, there are some fields. One field is a RBO_Field_Select that take "first name" data from contact. In my module I make an addon and I make the relation with this field with the field "first_name" of contact. Ok, this doesn't work.
But if in the same case changing the type RBO_Field_Select to RBO_Field_Text. This works perfectly whith the problem that I can put in this field of the addon any information (doesn't matter that the contact introduced doesn't exists). How I can resolve this?

The other problem is relationated too with relation between fields. I have one recordset with some fields and in there. Three of this fields must contain information about first name of a contact (in this moment are RBO_Field_Text). Again I make the module and the addon with relations between fields. Then when I make a record in this module and I put the information of three existing contacts and I go to CRM/Contact page I view the record information of any contact introduced before I can't see the record saved before in the addon. How I can make a relation between one record with anothers?

Thank you very much for all. A greeting!!! :D

ajb

Hi,
If I've properly understood, what you want to do, then you don't get the idea of the Select field and addons.

Let me explain this by example.
1. You want to add some custom recordset, that will be visible as an addon to the contact. Of course your data is somehow related to the contact (e.g. Owned Cars)
2. You have to create new recordset "Owned Cars" with a "Owner" field of CRM_Contacts_RBO_Contact type (it's a shortcut for the old way 'crm_contact' datatype). Of course you can use here RBO_Field_Select ->from('contact')->fields('First Name', 'Last Name')
3. Now you can add cars with defined owner, but you don't see the list of cars under a contact.
4. Add addon. Now your function will get contact record as a parameter.
Here is a clue: Your selected "Owner" in the Cars recordset is stored by contact's id. 'First Name', 'Last name' are used only to create a label. You have to filter with "where Owner = <contact_id>"
Your addon code:



public function contact_addon($contact) {

    $rs = new My_Recordset();

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

    $crits = array('owner' => $contact['id']);

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

}

I hope that's the problem you've described 🙂

Regards,
Adam

contel

Perfect!!! This resolve part of my problem, I am very grateful for that. But I need too the second part of the problem. Continuing with the cars example, let us imagine that in addition of owner, we have too a vendor and a buyer. (This module may be a history of car sales and we want have all information related with a sale).
We want see the information information of sale in every each record of type contact that is related with the sale.

I had thought something like this...



public function contact_addon($contact) {

    $rs = new My_Recordset();

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

    $crits = array('owner' => $contact['id'],

                        'vendor' => $contact['id'],

                        'buyer' => $contact['id']);

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

}

But this doesn't works because the contact['id'] must be all roles. Internaly appears to be three AND conditions (I think).

I need "OR" conditions. In moment that one contact takes one of the roles, then show the record in addon.
I hope I have explained this well.

Thank you very much again!! 🙂

ajb

public function contact_addon($contact) {

    $rs = new My_Recordset();

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

    $crits = array('(owner' => $contact['id'],

                        '|vendor' => $contact['id'],

                        '|buyer' => $contact['id']);

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

}

🙂
some explanation - some parts of that page may be outdated. I have to review it.

And of course you could create several addon methods and install several addons, each for the one of relation type - with label e.g. "Owned cars", "Sold cars", "Purchased cars".

contel

Perfect!!! It's working!!! Thank you 🙂

The solution that makes one addon for each relation seems interesting, but this could do cluttered the representation of web page because more than this addons will be empty and this not seems logical.

One example more specific, we have 3 type of CRM/contact: "Employee", "Student" and "Professor" (differentiate by type field). One enrolment addon will be only visible for a student type contact, or subject coordinator addon will be only visible for a professor type contact.

Then, how I can make an addon only be visible for one type of contact?

ajb

Yes of course 🙂
During addon "installation" you can define a label. But instead of a text you can use a callback, to the function.
Install file

        Utils_RecordBrowserCommon::new_addon('contact', 'Custom/MyModule', 'contacts_addon', array('Custom_MyModuleCommon','contacts_addon_label'));

Now in Common file:

    public static function contacts_addon_label($record) {

		$show = true; // or false, to some checks here

		if (!$show)

			return array('show'=>false);

		return array('label'=>__('Category#Label'), 'show'=>true);

    }

Here is one interesting thing. You can group your addons under Category. Just use a hash to separate category and label. 🙂

Regards,
Adam

contel

I have tried this solution and works all perfectly! Thank you very much!!! 😃

PS: Sorry for answering so late, I could work all this before.

krusso

Hi Epesi,

how to make select field which can select from both companies name and contact lastname firstname? I'm trying to make product addon which can hold products sold to individuals and companies, since both of them could be customers. Thanks in advance.

krusso

tell my why, tell me why, you do not post answer to my question? Is it stupid enough for ya attention?

ajb

[quote="Krusso":31fadqol]tell my why, tell me why, you do not post answer to my question? Is it stupid enough for ya attention?[/quote:31fadqol]No it's not. Just because you can't read or you're too lazy to read :evil: Every new user's first post need to be approved and you've been informed about this. But we don't get any notifications about new user's post from existing topics - such forum engine.

Answer: use CRM_Contacts_RBO_CompanyOrContact class for field definition.
Then in addon you have to prepend 'C:' or 'P:' for company (C) contact (P like person) in the crits.

addon_contact($r) { $crits = array('your_field' => "P:" . $r['id']); ... }

addon_company($r) { $crits = array('your_field' => "C:" . $r['id']); ... }

Regards,
Adam

krusso

Thank you. I'm not lazy to read 🙂 Just didn't find where. I'll try to find.

krusso

[quote="ajb":1w6e36vc][quote="Krusso":1w6e36vc]tell my why, tell me why, you do not post answer to my question? Is it stupid enough for ya attention?[/quote:1w6e36vc]No it's not. Just because you can't read or you're too lazy to read :evil: Every new user's first post need to be approved and you've been informed about this. But we don't get any notifications about new user's post from existing topics - such forum engine.

Answer: use CRM_Contacts_RBO_CompanyOrContact class for field definition.
Then in addon you have to prepend 'C:' or 'P:' for company (C) contact (P like person) in the crits.

addon_contact($r) { $crits = array('your_field' => "P:" . $r['id']); ... }

addon_company($r) { $crits = array('your_field' => "C:" . $r['id']); ... }

Regards,
Adam[/quote:1w6e36vc]

Excuse my impatience, Adam. Since I'm not php genius (as you can see) I still have troubles no matter how much I read developer's tutorial. I've created custom module with all 4 files ( Products_0, ProductsCommon, ProductsInstall and Recordset) according to Hello World tutorial. It was installed and working. Fine. But when it comes to this "Select" field which should select customers from both Contact and Company I'm lost. In Recordset.php I have fields array. "Customer" field is
$Select = new RBO_Field_Select(_M('Customer'));
$Select->from ('Company')->fields('company_name')->set_visible();
$fields[] = $Select;
Everything works. You gave me hint how to set field definition, but I still do not get idea. Can You help me?

jasiek

You should use: CRM_Contacts_RBO_CompanyOrContact field type to get Company or Contact as in Adam's post. Example:

$customer = new CRM_Contacts_RBO_CompanyOrContact(_M('Customer'));

http://www.epesi.org/Utils/RecordBrowser/RBO

krusso

[quote="Jasiek":1zmf7mmn]You should use: CRM_Contacts_RBO_CompanyOrContact field type to get Company or Contact as in Adam's post. Example:

$customer = new CRM_Contacts_RBO_CompanyOrContact(_M('Customer'));

http://www.epesi.org/Utils/RecordBrowser/RBO[/quote:1zmf7mmn]

Thank You. I've got an idea, at least for this case. Working. Thanks a lot.

krusso

[quote="Krusso":2xslhc1r][quote="Jasiek":2xslhc1r]You should use: CRM_Contacts_RBO_CompanyOrContact field type to get Company or Contact as in Adam's post. Example:

$customer = new CRM_Contacts_RBO_CompanyOrContact(_M('Customer'));

http://www.epesi.org/Utils/RecordBrowser/RBO[/quote:2xslhc1r]

Thank You. I've got an idea, at least for this case. Working. Thanks a lot.[/quote:2xslhc1r]
Thank you for previous help, but I cannot tame this: addon_contact($r) { $crits = array('your_field' => "P:" . $r['id']); ... }
Addon shows all products for all contacts and companies.

ajb

Maybe you should paste your code here to get some help? I'm bored with this kind of posts: "It doesn't work. Guess what I've done wrong."

krusso

Cannot find solution, sorry:
I have recordset's field:

function fields() {
$fields = array();
$vendor= new RBO_Field_Select(_M('Vendor'));
$vendor->from('company')->fields('company_name')->set_visible()->set_required();
$fields[] = $vendor;
...
return $fields;
}

What is the solution that this select field selects values from 'company' where 'group' is 'vendor' ?

ajb

function fields() {

$fields = array();

$vendor= new RBO_Field_Select(_M('Vendor'));

// use 'Company Name' instead of 'company_name'

$vendor->from('company')->fields('Company Name')->set_visible()->set_required()->set_crits_callback(array(__CLASS__, 'vendor_crits'));

$fields[] = $vendor;

...

return $fields;

}

public static function vendor_crits() {

  return array('group' => 'vendor'); // array( <field id in company recordset> => <value in that field> )

}

krusso

[quote="ajb":3uh5zias]

function fields() {

$fields = array();

$vendor= new RBO_Field_Select(_M('Vendor'));

// use 'Company Name' instead of 'company_name'

$vendor->from('company')->fields('Company Name')->set_visible()->set_required()->set_crits_callback(array(__CLASS__, 'vendor_crits'));

$fields[] = $vendor;

...

return $fields;

}

public static function vendor_crits() {

  return array('group' => 'vendor'); // array( <field id in company recordset> => <value in that field> )

}

[/quote:3uh5zias]

Thank You. Works fine. Just one moment: if I need to translate to another language, how could I change 'vendor' without changing code?

jasiek

All labels should be done in English and then use the translation tool to translate it to other languages:
http://www.epesi.org/Translating_EPESI
http://www.epesi.org/Base/Lang

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

Help Me! | Download from SourceForge