Created Module, how to implement javascript?

jjjj12212

Hi Everyone,

I have a module which is an add-on to the Sales Opportunity which interfaces another module of ours.
The issue we are having is that we need to show 2 fields from the other module when entering the data in this module.

We got 1 field working as follows: (in the _install.php)
array('name'=>'Serial No',
'type'=>'select',
'visible'=>true,
'extra'=>true,
'param'=>"module_ic::Serial No;::")

Now if we enter the Serial Number, we want it to immediately fetch the Item Description that is related to the serial number.

array('name'=>'Description',
'type'=>'select',
'visible'=>true,
'extra'=>true,
'param'=>"module_ic:?escription;::"),

We got it programmed so that when the serial number is added, it will automatically fill this field. However, we need this to respond faster than that and we need it to fill in as soon as the serial number is selected which I assume that javascript will need to be resolved.

I'm currently using 1.8.2 and using the Utils/RecordBrowser.

Note that I did looked at the EPESI wiki and could not find any documentation on how to get started using javascript with epesi.

Thanks,
jjjj12212

P.S. If Jasiek and Adam are still around, this old veteran says hi ;D

jasiek

jjjj12212
Nice to hear that!
Hello to you too ?

ghristov

Hi jjjj12212,

I believe I can help you with this challenge.

First of all you can add jscript to EPESI page as simple as using the load_js',eval_jsoreval_js_once` functions depending on how and when you want to load the script. First one loads it from file, the other two implement it from the string. You can search EPESI code and see many examples of these functions.

Second - in your case an implementation of chained select field is a straight forward way to implement immediate change of a select option list based on selection of another select. It is as simple as adding call to the Utils_ChainedSelectCommon::create method in your custom QFfield callback for the field that needs to be chained (in your case Description). EPESI takes care of the jscript part. What is needed is a small php file that returns the option list depending on the selected value. An example is used in CRM_ContactsCommon

But as Serial No and Description are always directly linked (actually representing same record in module_ic tab) in your case I consider a proper solution in your case that you simply use the following param for the Serial No field module_ic::Serial No|Description;::. You do not need the Description field.
This will list the description in both the select options and when field is displayed (if no custom display method).

I hope this helps. Let me know if you need more guidance.

Brgds,
Georgi

jjjj12212

Georgi,

You are amazing!!! I completely forgot that I can display 2 fields in 1 field.

Obviously, the module_ic::Serial No|Description;:: worked like a charm.

Also thank you for educating me on the ChainedSelect method and the load_js as I didn't know until now.

Thanks Again,

jjjj12212

ghristov

Happy that I could help.

One more thing - if you need a custom format for the select options you can define the third callback in the param (e.g. module_ic::Serial No|Description;::;Custom_MyModule::select_properties_callback and within that callback return an array having key format_callback. This will be the callback used to format each option.
Otherwise the default format is used which is a concatenated string with space in between.

The callback can also return cols and order keys as described here:
http://www.epesi.org/Utils/RecordBrowser#Select.2Fmultiselect_parameter

Brgds,
Georgi

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

Help Me! | Download from SourceForge