Guriddo » Topic: setAutocomplete with parameter

setAutocomplete with parameter

Guriddo
setAutocomplete
setAutocomplete with parameter

Tagged: setAutocomplete

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

Creator

Topic
January 8, 2022 at 3:28 am #127806
ariadrianto
Participant
Hi,

How to passing parameter into setAutocomplete ? I’ve tried but no luck

....

$grid->setColProperty("BANK", array("label" => "Kasbank", "searchoptions" => array("sopt" => array('cn', 'nc'))));

$grid->setAutocomplete("BANK", "#KASBANKID", "

select

ct.BANK,

ct.BANK,

ct.KASBANKID

from KASBANK ct

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = ".$_SESSION['companyid']."

order by ct.bank ", null, true, true);

.....

Thank you
- This topic was modified 2 years, 9 months ago by ariadrianto. Reason: code
- This topic was modified 2 years, 9 months ago by ariadrianto. Reason: code x... forget
Creator

Topic

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

Author

Replies

January 10, 2022 at 11:47 am #127812

guriddo.support

Participant

Hello,

This query should work. Maybe the problem is in the query and your settings for strict comparing the names when you write the SQL.

I suggest you first to try to use only like:



...

where ( upper(ct.bank ) LIKE upper( ? ) )

...

...

where ( upper(ct.bank ) LIKE upper( ? ) )

...

if you want to use LIKE %word% operator, maybe you can try with concat function that is used your database.

you can try to use ct.BANK instead of ~~ct.bank~~ in your query

The Autocomplete docs are here

Kind Regards,

Will

This reply was modified 2 years, 9 months ago by guriddo.support.

Guriddo Support Team

January 13, 2022 at 9:09 am #127830

ariadrianto

Participant

Hi,

Thanks. But what I meant is $_session filter.

...

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = ".$_SESSION['companyid']."

...

”
<p style=”padding-left: 40px;”>where ( upper(ct.bank ) LIKE ‘%’ || upper( ? ) || ‘%’ )’</p>

and CT.companyid = “.$_SESSION[‘companyid’].”

“

it’s not working to filter when I change Session…

Regards,

nb. sorry, i don’t know how to copy paste a code …

This reply was modified 2 years, 9 months ago by ariadrianto.
This reply was modified 2 years, 9 months ago by ariadrianto. Reason: how to copy paste a code ??

January 13, 2022 at 10:50 am #127833

guriddo.support

Participant

Hello,

Sorry, but I do not understand.

Which database driver do you use?

To publish code – ensure that this is a pure text and enclose it with ” ` ”

Kind Regards

Will

Guriddo Support Team

January 14, 2022 at 5:04 am #127837

ariadrianto

Participant

Here’s the code :



...
$search = jqGridUtils::GetParam('_search','true');
if($search == 'true')
{
$from = jqGridUtils::GetParam('from',date('m/d/Y'));
$to = jqGridUtils::GetParam('to',date('m/d/Y'));
$companyid = jqGridUtils::GetParam('companyid', '');

$_SESSION['from'] = $from;
$_SESSION['to'] = $to;

}

$table = 'BK';
$grid->SelectCommand = "
SELECT BK.NO_BK,
BK.BKID,
BK.TGL,
BK.URAIAN,
BK.KASBANKID,K.BANK,
BK.TYPES,
bk.companyid
FROM BK
LEFT JOIN KASBANK K ON (BK.KASBANKID = K.KASBANKID)

where bk.tgl between '".$from."' and '".$to."'
and bk.companyid = $companyid

";
$grid->dataType = 'json';

$grid->setColModel();
$grid->table = $table;
$grid->setUrl( 'bk_.php');

$grid->setColProperty("BKID", array("label" => "ID", "hidden" => true));
$grid->setColProperty("KASBANKID", array("label" => "ID", "hidden" => true));
$grid->setColProperty("COMPANYID", array("label" => "ID", "hidden" => true,
"editoptions" => array("defaultValue"=>$companyid )));
$grid->setAutocomplete("BANK", "#KASBANKID", "
select
ct.BANK,
ct.BANK,
ct.KASBANKID
from KASBANK ct
where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )
and CT.companyid = $companyid
order by ct.bank ", null, true, true);
...

...

$search = jqGridUtils::GetParam('_search','true');

if($search == 'true')

{

$from = jqGridUtils::GetParam('from',date('m/d/Y'));

$to = jqGridUtils::GetParam('to',date('m/d/Y'));

$companyid = jqGridUtils::GetParam('companyid', '');

$_SESSION['from'] = $from;

$_SESSION['to'] = $to;

}

$table = 'BK';

$grid->SelectCommand = "

SELECT BK.NO_BK,

BK.BKID,

BK.TGL,

BK.URAIAN,

BK.KASBANKID,K.BANK,

BK.TYPES,

bk.companyid

FROM BK

LEFT JOIN KASBANK K ON (BK.KASBANKID = K.KASBANKID)

where bk.tgl between '".$from."' and '".$to."'

and bk.companyid = $companyid

$grid->dataType = 'json';

$grid->setColModel();

$grid->table = $table;

$grid->setUrl( 'bk_.php');

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

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

$grid->setColProperty("COMPANYID", array("label" => "ID", "hidden" => true,

"editoptions" => array("defaultValue"=>$companyid )));

$grid->setAutocomplete("BANK", "#KASBANKID", "

select

ct.BANK,

ct.KASBANKID

from KASBANK ct

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = $companyid

order by ct.bank ", null, true, true);

...

let’s focus on setAutocomplete



$grid->setAutocomplete("BANK", "#KASBANKID", "
select
ct.BANK,
ct.BANK,
ct.KASBANKID
from KASBANK ct
where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )
and CT.companyid = $companyid
order by ct.bank ", null, true, true);

&nbsp;

$grid->setAutocomplete("BANK", "#KASBANKID", "

select

ct.BANK,

ct.KASBANKID

from KASBANK ct

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = $companyid

order by ct.bank ", null, true, true);

if I change companyid, it won’t filter companyid …

Regards,

January 14, 2022 at 1:40 pm #127839

guriddo.support

Participant

Hello,

You do not explain too much.

Maybe I understand what you try to do.

Yes this way it won’t work.

Your way to do this using session is ok, The only thing is that if you change the companyid with some value you should change the session to.

Example:

We have success doing this. Imagine you use our demo. In the demo we use jq-config.php file which in included every where grid.php.

In the config file we use



session_start();

...

if(!isset($_SESSION['companyid'])) {
$_SESSION['companyid'] = 1;
} else {
$test = jqGridUtils::GetParam('companyid', false);
if($test) {
$_SESSION['companyid'] = $test;
}
}

session_start();

...

if(!isset($_SESSION['companyid'])) {

$_SESSION['companyid'] = 1;

} else {

$test = jqGridUtils::GetParam('companyid', false);

if($test) {

$_SESSION['companyid'] = $test;

}

Now if you change the companyid be a sure to call jq-config.php with

jq-config.php?companyid=newvalue

This way our autocomplete works with the $_SESSION array

This reply was modified 2 years, 9 months ago by guriddo.support.

Guriddo Support Team

Author

Replies

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

You must be logged in to reply to this topic.

Registered Users: 12,249
Forums: 7
Topics: 10,947
Replies: 23,146
Topic Tags: 324
Empty Topic Tags: 9

3 Users Online

Users: 1 Guest, 2 Bots

Stay connected with us in your favorite flavor!

setAutocomplete with parameter

Search Forum

Recent Replies

Forum Statistics

UserOnline