Guriddo » Topic: JqSuite PHP Bugs

JqSuite PHP Bugs

Guriddo
bug setautocomplete
JqSuite PHP Bugs

Tagged: bug setautocomplete

This topic has 8 replies, 2 voices, and was last updated 8 years, 6 months ago by ariadrianto.

Creator

Topic

July 20, 2016 at 10:43 am #125412

ariadrianto

Participant

Hi All,

I love this Grid, but I’d like to report bugs (improvement) when jqsuite on edit / add form :

setAutoComplete fire when exit input, not when chosen. https://s31.postimg.org/myzhg8xaz/Selection_799.png
Popup column date only fire when on enter input . When date column on the first focus entry, it won’t show up. Unless, exit and enter input box again.
When setAutoComplete column set on first focus entry. If without choosing anything and change focus, it will be set null. https://s31.postimg.org/4imskjpyz/Selection_802.png

I’m using gurrido suite 5.1.1


.........
$grid->setColProperty("ASURANSIID", array("label"=>"ID", "hidden"=>true,"frozen"=>true));
$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId","editable"=>false, "hidden"=>true, "frozen"=>true, "searchoptions"=>array("sopt"=>array('cn'))));
$grid->setColProperty("NAMA", array("label"=>"Nama","frozen"=>true, "editoptions"=>array("readonly"=>true), "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setColProperty('TGL', array("formatter" => "date",
"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),
"editoptions" => array("dataInit" =>
"js:function(elm){setTimeout(function(){
jQuery(elm).datepicker({dateFormat:'yy-m-d'});
jQuery('.ui-datepicker').css({'zIndex':'1200','font-size':'75%'});},100);}")
));

/* this column should be hidden, but I need to show you
$grid->setColProperty("IDASURANSI", array("label"=>"IdAsuransi", "hidden"=>false));
$grid->setAutocomplete("ASURANSI_","#IDASURANSI","SELECT ss.ASURANSI , ss.ASURANSI, ss.asuransiid
FROM vwASURANSI ss WHERE upper(ss.ASURANSI) LIKE upper( ? )
ORDER BY ss.ASURANSI ",null, true, true);
........

.........

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

$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId","editable"=>false, "hidden"=>true, "frozen"=>true, "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setColProperty("NAMA", array("label"=>"Nama","frozen"=>true, "editoptions"=>array("readonly"=>true), "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setColProperty('TGL', array("formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),

"editoptions" => array("dataInit" =>

"js:function(elm){setTimeout(function(){

jQuery(elm).datepicker({dateFormat:'yy-m-d'});

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

));

/* this column should be hidden, but I need to show you

$grid->setColProperty("IDASURANSI", array("label"=>"IdAsuransi", "hidden"=>false));

$grid->setAutocomplete("ASURANSI_","#IDASURANSI","SELECT ss.ASURANSI , ss.ASURANSI, ss.asuransiid

FROM vwASURANSI ss WHERE upper(ss.ASURANSI) LIKE upper( ? )

ORDER BY ss.ASURANSI ",null, true, true);

........

Creator

Topic

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

Author

Replies

July 21, 2016 at 11:05 am #125419

guriddo.support

Participant

Hello,

1.Yes this is true and is caused by autocomplet plugin itself and some problem in search dialog. In order to make your custom autocomplete you may pickup your own using dataInit event.

2. Not sure that I understand the question. Did you mean that if the date is the first column the datepicker does not popup. Can you please demostarte the problem. You may want to look here

3. Sorry I do not understand the problem. Casn you please make a simple demo with description step by step.

Kind Regards,

Will

Guriddo Support Team

July 22, 2016 at 4:23 am #125423

ariadrianto

Participant

Hello,

I’ve made a demonstration of this…

http://multidayacipta.com/demos/hrd/info/coba.php

Thank you very much…

July 22, 2016 at 9:17 am #125427

guriddo.support

Participant

Hello,

Thank you for the test case.

1. Yes the autcomplete fire on blur. Currently this is the default behaviour.
We use the autocomplete change event . Normally ww should use the select event, but as I say in my previous post it causes problems in some modules.

We will change the code so that you can select which event to use change or select – but this will be maybe in the next release. Alternatively you you can use your own dataInit fiunction for that field where the autocomplete use select event.

2. It seems you have not look at the demo carefully. Use the datepicker option showOn : focus in dataInit function

..
jQuery(elm).datepicker({
   dateFormat:'yy-m-d',
   showOn : 'focus'
});
...

jQuery(elm).datepicker({

dateFormat:'yy-m-d',

showOn : 'focus'

});

...

3. We need to lock the full source code related to this field.
(It seems you have bind some on change events )

Kind Regards,
Will

Guriddo Support Team

July 22, 2016 at 10:04 am #125431

ariadrianto

Participant

Hi ,

Thanks for your quick response.

3. source :


$grid = new jqGridRender($conn);
$table = 'COBA';
$grid->SelectCommand ="select k.nama, c.tgl, c.karyawanid, c.desc
from coba c
left join karyawan k on c.karyawanid = k.karyawanid
";

$grid->dataType = 'json';
$grid->setPrimaryKeyId("COBAID");
$grid->setColModel();
$grid->table = $table;

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

$grid->setDbTime('Y-m-d');
$grid->setDbDate('Y-m-d');
$grid->setUserDate('Y-m-d');
$grid->setUserTime('Y-m-d');

$grid->setColProperty("COBAID", array("label"=>"ID", "hidden"=>true));
$grid->setColProperty('TGL', array("formatter" => "date",
"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),
"editoptions" => array("dataInit" =>
"js:function(elm){setTimeout(function(){
jQuery(elm).datepicker({dateFormat:'yy-m-d', showOn : 'focus'});
jQuery('.ui-datepicker').css({'zIndex':'1200','font-size':'75%'});},100);}")
));
$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId (should be hidden)","hidden"=>false, "editable"=>true, "searchoptions"=>array("sopt"=>array('cn'))));
$grid->setColProperty("NAMA", array("label"=>"Name", "searchoptions"=>array("sopt"=>array('cn'))));
$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT kk.NAMA, kk.NAMA, kk.KARYAWANID FROM KARYAWAN kk WHERE NAMA LIKE upper(?)"
. " ORDER BY kk.NAMA ",null, true, true);

$grid->setColProperty("DESC", array("label"=>"Description", "width"=>85, "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"TGL", "height"=>'150',
"caption"=>"AutoComplete Column on first",
"footerrow"=>true,
"userDataOnFooter"=>true,
"grouping"=>false,
"shrinkToFit"=>false,
"width"=>600
));
// Enable toolbar searching
$grid->ignoreCaseSearch = true;
$grid->setSearchOptions( array ( "sqlfunc" => "UPPER", "phpfunc" => "strtoupper" ));
$grid->toolbarfilter = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>false,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$_POST = array_map("strtoupper", $_POST);
$grid->renderGrid('#grid3','#pager3',true, null, null, true,true);

$grid = new jqGridRender($conn);

$table = 'COBA';

$grid->SelectCommand ="select k.nama, c.tgl, c.karyawanid, c.desc

from coba c

left join karyawan k on c.karyawanid = k.karyawanid

$grid->dataType = 'json';

$grid->setPrimaryKeyId("COBAID");

$grid->setColModel();

$grid->table = $table;

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

$grid->setDbTime('Y-m-d');

$grid->setDbDate('Y-m-d');

$grid->setUserDate('Y-m-d');

$grid->setUserTime('Y-m-d');

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

$grid->setColProperty('TGL', array("formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),

"editoptions" => array("dataInit" =>

"js:function(elm){setTimeout(function(){

jQuery(elm).datepicker({dateFormat:'yy-m-d', showOn : 'focus'});

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

));

$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId (should be hidden)","hidden"=>false, "editable"=>true, "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setColProperty("NAMA", array("label"=>"Name", "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT kk.NAMA, kk.NAMA, kk.KARYAWANID FROM KARYAWAN kk WHERE NAMA LIKE upper(?)"

. " ORDER BY kk.NAMA ",null, true, true);

$grid->setColProperty("DESC", array("label"=>"Description", "width"=>85, "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"TGL", "height"=>'150',

"caption"=>"AutoComplete Column on first",

"footerrow"=>true,

"userDataOnFooter"=>true,

"grouping"=>false,

"shrinkToFit"=>false,

"width"=>600

));

// Enable toolbar searching

$grid->ignoreCaseSearch = true;

$grid->setSearchOptions( array ( "sqlfunc" => "UPPER", "phpfunc" => "strtoupper" ));

$grid->toolbarfilter = true;

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>false,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$_POST = array_map("strtoupper", $_POST);

$grid->renderGrid('#grid3','#pager3',true, null, null, true,true);

2. just like number 3… but modify on sql command :


.............

$grid->SelectCommand ="select c.tgl, c.karyawanid, k.nama, c.desc
from coba c
left join karyawan k on c.karyawanid = k.karyawanid
";

............
$grid->setColProperty('TGL', array("formatter" => "date",
"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),
"editoptions" => array("dataInit" =>
"js:function(elm){setTimeout(function(){
jQuery(elm).datepicker({dateFormat:'yy-m-d', showOn : 'focus'});
jQuery('.ui-datepicker').css({'zIndex':'1200','font-size':'75%'});},100);}")
));

............

.............

$grid->SelectCommand ="select c.tgl, c.karyawanid, k.nama, c.desc

from coba c

left join karyawan k on c.karyawanid = k.karyawanid

............

$grid->setColProperty('TGL', array("formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),

"editoptions" => array("dataInit" =>

"js:function(elm){setTimeout(function(){

jQuery(elm).datepicker({dateFormat:'yy-m-d', showOn : 'focus'});

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

));

............

Already added “showOn : ‘focus’ ” but nothing shown up.

Already update this link.
Thanks

July 22, 2016 at 10:15 am #125432

ariadrianto

Participant

Hi,

2. solved … I just delete settimeout… It works… even without showOn : focus


.....
$grid->setColProperty('TGL', array("formatter" => "date",
"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),
"editoptions" => array("dataInit" =>
"js:function(elm){
jQuery(elm).datepicker({dateFormat:'yy-m-d'});
jQuery('.ui-datepicker').css({'zIndex':'1200','font-size':'75%'});}")
));

.....

.....

$grid->setColProperty('TGL', array("formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),

"editoptions" => array("dataInit" =>

"js:function(elm){

jQuery(elm).datepicker({dateFormat:'yy-m-d'});

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

));

.....

Thanks

July 26, 2016 at 9:47 am #125433

guriddo.support

Participant

Hello,

Actually you can use the

setDatepicker PHP method – see demos.

Kind Regards,

Will

Guriddo Support Team

October 21, 2016 at 8:49 am #125613

ariadrianto

Participant

Hi,

I’m still waiting solution for number 3 issue. Actually, it’s not happen when edit with inline Edit. This is what I did on all my grid when there’s autocomplete field on it, to solve the problem for while.

Best Regards,

October 21, 2016 at 9:28 am #125614

ariadrianto

Participant

Hi,

I’ve found temporary solution… do not put autocomplete in first field. And everything will works fine.

Thanks.