dropdown linked to a function

aaandy

Hello, i am trying to link a dropdown field to a function but it does not work, the dropdown works, but there are no options to select..

here is the function i am trying to add to the dropdown:

public static function QFfield_klant_type(&$form, $field, $label, $mode, $default) {
if ($mode == 'add' || $mode == 'edit') {
$data = Utils_CommonDataCommon::get_value('bedrijf/typeklant');
if (!is_array($data))
$data = array();
$form->addElement('commondata', $field, $label, $data, array('id' => $field));
if ($mode == 'edit')
$form->setDefaults(array($field => $default));
}
}

can someone help me with this?

ajb

You should use

Utils_CommonDataCommon::get_array('bedrijf/typeklant');

Utils_CommonDataCommon::get_translated_array('bedrijf/typeklant');

instead of

Utils_CommonDataCommon::get_value('bedrijf/typeklant');

Of course in install file you should create this array with

Utils_CommonDataCommon::new_array('bedrijf/typeklant', array('Opt 1', 'Opt 2');

Utils_CommonDataCommon::new_array('bedrijf/typeklant', array('opt1' => 'Opt 1', 'opt2' => 'Opt 2');

array keys are used as values. It's better to hold some more descriptive value than just 0, 1, 2 etc

Best regards,
Adam

aaandy

Thanks for your reply,

Is it also possible to get the array out of the database if i made the array in "administration->commondata" ?

Because that is the way i was trying to do it.

I know how to get it with a simple mysql select, but just wondering if there is a function for it

Greetings,
Andy

jasiek

Aaandy,

Here is a post explaining how to use Common Data as a select field:
viewtopic.php?f=8&t=1312&p=4469&hilit=select#p4469

ajb

[quote="Aaandy":3jdp2zlu]Is it also possible to get the array out of the database if i made the array in "administration->commondata" ?[/quote:3jdp2zlu]

Of course. "administration->commondata" is just interface to database entries. But when you're writing about "simple sql query", then i'm little confused, because commondata is hold as tree and in my opinion it won't be just simple sql query 😉

This not so simple sql query

select value from utils_commondata_tree where parent_id = (select id from utils_commondata_tree where akey = 'Foo')

is the same as

Utils_CommonDataCommon::get_array('Foo');

But if you want to get 'Foo/Bar' array it gets one more nested select.

Best regards,
Adam

aaandy

it worked.

And i have another question, is it possible to get all the contacts wich are in a group?

for example, you can add groups in administrator->commondata->contacts_groups and wat i want is to connect a field with a datatype wich i can create with a function called "Utils_RecordBrowserCommon::register_datatype" where the field only has to find the users wich are inside of the group "employee" , how can i do that?

ajb

Field types of select or multiselect have criteria callback. Look at the documentation. Also look at method CRM_ContactsCommon::crm_contact_datatype to see how it works. Datatype callback just makes some transformation of array to basic RecordBrowser field definitions.

This crits method put in some class:

public static function employee_crits() {

        return array('group' => '<yourgroup>');

    }

In fact there is something like access: Employee. You can set this in user management and don't create own group. Then use this crits callback:

public static function employee_crits() {

        return array('access' => 'employee');

    }

Do it in your favor.
Good look!

Regards,
Adam

aaandy

hello, i got it to work but i want the dropdown to be a search field when does it become a search field instead of a dropdown?

jasiek

EPESI CRUD engine - Record Browser - automatically manages select and multiselect fields based on a number of choices.

For multiselect field you will see on the left hand side possible choices and on the right side selected choices:

Short list multiselect

Selection for multiselect field may come from a Common Data list or another recordset. If the list is very long (for example it could come from CRM Companies containing thousands of records) selection will become cumbersome and difficult to navigate. Moreover the entire list has to be loaded and this will cause additional performance problem. Therefore once it reaches a certain limit (I think we set it up to 50) it will automatically show a box where you can type a string and search for a record/selection. It is Ajax based, therefore the entire list is not loaded but search criteria are sent to the server and only a short list of matches is returned. Please not that you can type just fragments of a searched phrase, for example instead of "ABC Company" you can type: "Co A" (fraction of ABC and Company):

Large list multiselect

The same behavior applies to SELECT list - a short list displays all possible choices, long list will automatically become "searchable" select.

This feature, as many others, is a part of EPESI framework freeing the developer from redundant programming tasks.

aaandy

Thank you for your answer thats just wat i had to know.

aaandy

so now i added items to the dropdown unti there are more than 50 and it is not working.. is there something wrong with my code?



//in the 'install' function i have:

        Utils_RecordBrowserCommon::register_datatype('sku', 'Test_RapportCommon', 'sku_datatype');

//and this is the dropdown in the '$fields' array:

            array('name' => _M('Artikelnr'), 'type' => 'sku', 'param' => array('field_type' => 'select'), 'required' => true, 'extra' => false, 'visible' => true ,'filter' => true),

//and in the function 'sku_datatype' i have this:

    public static function sku_datatype($field = array()) {

        $field['type'] = $field['param']['field_type'];

        $param = 'premium_warehouse_items::SKU';

        if (isset($field['param']['format']))

            $param .= ';' . implode('::', $field['param']['format']);

        else

            $param .= ';::';

        if (isset($field['param']['crits']))

            $param .= ';' . implode('::', $field['param']['crits']);

        else

            $param .= ';::';

        $field['param'] = $param;

        return $field;

    }

jasiek

Hi,

The RecordBrowser limit for autoselect is 50:
public static $options_limit = 50;
from modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

class Utils_RecordBrowserCommon extends ModuleCommon {

    private static $del_or_a = '';

    public static $table_rows = array();

    public static $hash = array();

    public static $admin_access = false;

    public static $cols_order = array();

    public static $options_limit = 50;

therefore it should work.

aaandy

Hello,

i have set '$options_limit' to 10; and i am still getting a dropdown with 50+ items into it..

and i also have some more questions..

is it possible to make the first field in this pic hidden, or disabled?

also note the dropdown wich contains more than 50 items..

ajb

Do you get select with more than 50 in "fullscreen edit" mode? I mean not inline edit, but normal edit.

aaandy

Hello,

I tested that but that did not work, but i found wat the problem was, i wil explain here.

I have put the field type on 'select' and it does not automatically change to 'autoselect' , you need some code for that here is an example of a piece from my QFfield callback function:

So basically, changing the field type to autoselect solved the problem.

Greetings,
Andy

ajb

Hi,

Or you haven't mentioned, or I haven't found that you have custom QFfield callback. Code like your snippets is already in RecordBrowser_0.php, line 1661. It should work when you don't set custom QFfield callback. If you use custom it's up to you to take care about field type 😉

Regards,
Adam

aaandy

The title says "dropdown linked to a function" wich applies to the questions i have asked here, and i need the QFfield for the javascript.

But ok, it works fine now, thanks for answering some of my questions with helpfull information.

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

Help Me! | Download from SourceForge