Guriddo » Topic: autocomplete with multi target field

autocomplete with multi target field

Guriddo
autocomplete multi target
autocomplete with multi target field

Tagged: autocomplete multi target

This topic has 2 replies, 2 voices, and was last updated 9 years, 1 month ago by guriddo.support.

Creator

Topic

April 26, 2017 at 6:03 am #126009

ariadrianto

Participant

Hi,

How to implement multi target field of jqAutocomplete ?
When user choose product, #PRICE column would be filled with default price from products.


.....
$grid-&gt;setColProperty(&quot;PRODUCTID&quot;, array(&quot;label&quot;=&gt;&quot;productid&quot;, &quot;hidden&quot;=&gt;true   ));

$grid-&gt;setColProperty(&quot;PRODUCT&quot;, array(&quot;label&quot;=&gt;&quot;Obat / Produk&quot;,&quot;width&quot;=&gt;200,&quot;editable&quot;=&gt;true,  &quot;searchoptions&quot;=&gt;array(&quot;sopt&quot;=&gt;array(&#039;cn&#039;, &#039;nc&#039;))));
$grid-&gt;setAutocomplete(&quot;PRODUCT&quot;,&quot;#PRODUCTID&quot;,&quot;
        select o.product , o.product, o.productid, o.price
        from products o
        where upper(o.product) like &#039;%&#039; || upper( ? ) || &#039;%&#039;
        order by o.product&quot;,array(&quot;itemLength&quot;=&gt;50), true, true);

$grid-&gt;setColProperty(&quot;PRICE&quot;, array(&quot;label&quot;=&gt;&quot;Price&quot;,&quot;width&quot;=&gt;85,&quot;editable&quot;=&gt;true,&quot;formatter&quot;=&gt;&quot;number&quot;, &quot;align&quot;=&gt;&quot;right&quot;));
....

.....

$grid->setColProperty("PRODUCTID", array("label"=>"productid", "hidden"=>true ));

$grid->setColProperty("PRODUCT", array("label"=>"Obat / Produk","width"=>200,"editable"=>true, "searchoptions"=>array("sopt"=>array('cn', 'nc'))));

$grid->setAutocomplete("PRODUCT","#PRODUCTID","

select o.product , o.product, o.productid, o.price

from products o

where upper(o.product) like '%' || upper( ? ) || '%'

order by o.product",array("itemLength"=>50), true, true);

$grid->setColProperty("PRICE", array("label"=>"Price","width"=>85,"editable"=>true,"formatter"=>"number", "align"=>"right"));

....

Thank you

Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

April 26, 2017 at 9:13 am #126010

ariadrianto

Participant

I’ve found it using js…
But… maybe you can cange setAutocomplete with multi product… just maybe…



....
$grid-&gt;setColProperty(&quot;PRODUCTID&quot;, array(&quot;label&quot;=&gt;&quot;PRODUCTID&quot;, &quot;hidden&quot;=&gt;true ));

// autocomplete javascript code
$prod = &lt;&lt;&lt;CUSTOM
function (elem) {
$(elem).autocomplete({
source: &quot;../lookup/loProduct.php&quot;,
select: function(event, ui) {
$(&quot;#PRODUCTID&quot;).val(ui.item.PRODUCTID);
$(&quot;#PRICE&quot;).val(ui.item.PRICE);
}
});
jQuery(&#039;.ui-autocomplete&#039;).css({&#039;zIndex&#039;:&#039;1200&#039;,&#039;font-size&#039;:&#039;75%&#039;});
}
CUSTOM;

// attaching the autocomplete function

$grid-&gt;setColProperty(&#039;PRODUCT&#039;,array(&quot;editoptions&quot;=&gt;array(&quot;dataInit&quot;=&gt;&quot;js:&quot;.$prod)));

&amp;nbsp;

....

$grid->setColProperty("PRODUCTID", array("label"=>"PRODUCTID", "hidden"=>true ));

// autocomplete javascript code

$prod = <<<CUSTOM

function (elem) {

$(elem).autocomplete({

source: "../lookup/loProduct.php",

select: function(event, ui) {

$("#PRODUCTID").val(ui.item.PRODUCTID);

$("#PRICE").val(ui.item.PRICE);

}

});

jQuery('.ui-autocomplete').css({'zIndex':'1200','font-size':'75%'});

}

CUSTOM;

// attaching the autocomplete function

$grid->setColProperty('PRODUCT',array("editoptions"=>array("dataInit"=>"js:".$prod)));

&nbsp;

This reply was modified 9 years, 1 month ago by ariadrianto. Reason: bad format

April 27, 2017 at 9:37 am #126012

guriddo.support

Participant

Hello,

Thank you for the code and solution provided.

We think that maybe there is no need to add many and many options, but rather

to get a developer a freedom to solve with little experience the most of problem.

autocomplete with multi target field

Search Forum

Recent Replies

Forum Statistics

UserOnline