Multi Select

jcvieira

Hi Guys,

I have the following code:

		$field = new RBO_Field_MultiSelect('Clients');

		$field->from('company')->fields('company_name')->set_visible();

		$fields[] = $field;

Which works just fine, but it only gives me my records, but i need to get all the company's weathr they are private or not, is this possible?

Thank you

ajb

With that type of field - no.
It can only show values that you're able to see with your permissions.
If you wish to select all companies, you'll have to write your own field (with custom QFfield_callback), and fill values by yourself:
1. requesting database for all companies. Omit RB.
2. use Utils_RecordBrowserCommon::get_records with $admin = true;

    public static function get_records( $tab, $crits = array(), $cols = array(), $order = array(), $limit = array(), $admin = false) {

Regards,
Adam

jcvieira

[quote="ajb":1mcoa07q]With that type of field - no.
It can only show values that you're able to see with your permissions.
If you wish to select all companies, you'll have to write your own field (with custom QFfield_callback), and fill values by yourself:
1. requesting database for all companies. Omit RB.
2. use Utils_RecordBrowserCommon::get_records with $admin = true;

    public static function get_records( $tab, $crits = array(), $cols = array(), $order = array(), $limit = array(), $admin = false) {

Regards,
Adam[/quote:1mcoa07q]

Thanks Adam. What type of field should i use? Calculated? Hence it needs to support multiple entries...
And also how can i tell it is multiple using :

$form->addElement('select', $field, $label, $array_of_options);

ghristov

Hi jcvieira,

You should associate a QFfield callback to the field:



$field->set_QFfield_callback(array('Custom_MyModuleCommon', 'QFfield_companies'));

and add code to the callback method (placed in your Custom_MyModuleCommon in the case of this example).
Code should be similar to below:



public static function QFfield_companies(&$form, $field, $label, $mode, $default, $desc, $rb_obj){

		if ($mode=='add' || $mode=='edit') {

			$companies_select_list = self::get_companies_select_list();

				

			$form->addElement('multiselect', $field, $label, $companies_select_list, array('id'=>$field));

					

			$form->setDefaults(array($field=>$default));

		}

		else {

			if (isset($display_callbacks[$desc['name']]))

				$callback = $display_callbacks[$desc['name']];

			else

				$callback = array('CRM_ContactCommon','display_company');

	

			$form->addElement('static', $field, $label, call_user_func($callback, $rb_obj->record, false, $desc));

		}

	}

Best regard,
Georgi

jcvieira

[quote="ghristov":wwg8ciim]Hi jcvieira,

You should associate a QFfield callback to the field:



$field->set_QFfield_callback(array('Custom_MyModuleCommon', 'QFfield_companies'));

and add code to the callback method (placed in your Custom_MyModuleCommon in the case of this example).
Code should be similar to below:



public static function QFfield_companies(&$form, $field, $label, $mode, $default, $desc, $rb_obj){

		if ($mode=='add' || $mode=='edit') {

			$companies_select_list = self::get_companies_select_list();

				

			$form->addElement('multiselect', $field, $label, $companies_select_list, array('id'=>$field));

					

			$form->setDefaults(array($field=>$default));

		}

		else {

			if (isset($display_callbacks[$desc['name']]))

				$callback = $display_callbacks[$desc['name']];

			else

				$callback = array('CRM_ContactCommon','display_company');

	

			$form->addElement('static', $field, $label, call_user_func($callback, $rb_obj->record, false, $desc));

		}

	}

Best regard,
Georgi[/quote:wwg8ciim]

Thanks Georgi... Its almost there with your answer but it does not store the values proprerly on the database. What field type should i use for the record browser? At the moment is putting "Array" as stored value on the db... 🙁

ghristov

You are using the correct field type - multiselect.
Check if your get_companies_select_list() method returns proper company id => company name pairs.



public static function get_companies_select_list() {

	$companies = CRM_ContactsCommon::get_companies();

	

	$ret = array(null=>'---');

	foreach ($companies as $id=>$c) {

		$ret[$id] = CRM_ContactsCommon::company_format_default($c, true);

	}

	

	return $ret;

}

best regards

ajb

Use multiselect field type, then it should be stored properly. Multiselect QF field returns array. RB will handle it to serialized form only if it'll be of multiselect type. If I've got it right.

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

Help Me! | Download from SourceForge