phpgrid.desk.com :: General Questions https://phpgrid.desk.com/customer/en/portal/topics/377958-general-questions General Questions articles problem in serach option Hi abu I store value in database Y,N But in grid i Display Like Yes,No Problem is : When I search Yes It Shows Empty Row How i Rectify This problem Fri, 24 Nov 2017 15:13:02 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17195487 Unserialize data Hello, I have a table where one field as the data serialized with php. Is it possible to unserialized the data before displaying it? Thanks, Cedric Tue, 21 Nov 2017 16:26:58 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17193858 No such method: groupingCalculations.handler I use a persist-settings on reports and am now trying to add a Group Summary field. Grouping works fine, but when I add the Summary Type: $col["summaryType"] = "sum"; I get an error reported: jqGrid.state.js:379 - Uncaught jqGrid - No such method: groupingCalculations.handler Do I need to download/buy a new update? It looks to be by design of the jqGrid.state.js where-by it's halting the script and throwing an error if it can't find the object it's trying to save the state-of. In my case - I would never need to save the state of the grouping list - but I can't find a way around this. Any suggestions? I can remove the persist settings section and jqgrid.state.js but then the report is not as useful (with persist settings). Thanks for any assistance. Mike Tue, 21 Nov 2017 19:13:40 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17193150 phpgrid and Codeigniter problem Hi, I'm using phpgrid and codeigniter like http://www.phpgrid.org/faqs/#1 and have a problem. Codeigniter run fine but images not show (nex, back, add, delete, edit...). You can view here: http://www.aiguesmoia.cat/cpresencia/index.php/grid2. Thanks. Sun, 19 Nov 2017 19:02:24 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17192651 Problem with add dialog box with 2 date fields ONLY IF the date is the first field in the dialog box This code works perfectly (date field not in first position): $g = new jqgrid($db_conf); $g->table = "test"; $opt = array(); $opt["caption"] = "Test"; $g->set_options($opt); $cols = array(); $col = array(); $col["title"] = "ID"; $col["name"] = "ID_test"; $cols[] = $col; $col = array(); $col["title"] = "Text"; $col["name"] = "Text"; $col["editable"] = true; $cols[] = $col; $col = array(); $col["title"] = "Data1"; $col["name"] = "Data1"; $col["editable"] = true; $col["formatter"] = "date"; $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d/m/Y'); $cols[] = $col; $col = array(); $col["title"] = "Data2"; $col["name"] = "Data2"; $col["editable"] = true; $col["formatter"] = "date"; $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d/m/Y'); $cols[] = $col; $g->set_columns($cols); $out_grid_1 = $g->render("list1_1"); and this not (date field in first position): // grid_1 (Test) $g = new jqgrid($db_conf); $g->table = "test"; $opt = array(); $opt["caption"] = "Test"; $g->set_options($opt); $cols = array(); $col = array(); $col["title"] = "ID"; $col["name"] = "ID_test"; $cols[] = $col; $col = array(); $col["title"] = "Data1"; $col["name"] = "Data1"; $col["editable"] = true; $col["formatter"] = "date"; $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d/m/Y'); $cols[] = $col; $col = array(); $col["title"] = "Text"; $col["name"] = "Text"; $col["editable"] = true; $cols[] = $col; $col = array(); $col["title"] = "Data2"; $col["name"] = "Data2"; $col["editable"] = true; $col["formatter"] = "date"; $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d/m/Y'); $cols[] = $col; $g->set_columns($cols); $out_grid_1 = $g->render("list1_1"); Fri, 17 Nov 2017 17:39:10 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17191896 Records are listed twice When I enter search criteria, the records are listed twice. Get all the right records once, and then they are repeated. The strange thing is that this doesn't happen every time. Any suggestion? Fri, 17 Nov 2017 12:44:25 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17191538 sum colums How can I insert the value of a+b into c? $col = array(); $col["title"] = "LOG"; // caption of column $col["name"] = "a"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias) $col["width"] = "200"; $col["align"] = "center"; $col["editable"] = FALSE; $col["hidden"] = False; $col["search"] = true; $cols[] = $col; $col = array(); $col["title"] = "LOG"; // caption of column $col["name"] = "b"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias) $col["width"] = "200"; $col["align"] = "center"; $col["editable"] = FALSE; $col["hidden"] = False; $col["search"] = true; $cols[] = $col; $col = array(); $col["title"] = "LOG"; // caption of column $col["name"] = "c"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias) $col["width"] = "200"; $col["align"] = "center"; $col["editable"] = FALSE; $col["hidden"] = False; $col["search"] = true; $cols[] = $col; Tue, 14 Nov 2017 03:17:32 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17188853 Library PhpGrid How PhpGrid can called from library codeigniter, for example in controller $this->load->library('phpgrid'); ? Thu, 09 Nov 2017 16:18:03 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17186473 Library in codeigniter (phpgrid) How make library in codeigniter for Phpgrid ? Thu, 09 Nov 2017 16:14:40 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17185762 Multiple Select dropdown issue Hi Abu, I'm trying to implement a field which allows multiple values to be selected. The below code using Select2 allows me to add a new record and select multiples as well as edit an existing record with a single value in it. However when I edit a record with multiple values already in the field it doesn't bring up those values, it just puts a blank in the field. I checked in the backend table and the comma separated list of values is saved in the table so the data is there, it's just how do I get it to pull through as separate values when loading the field with Select2? $col = array(); $col["title"] = "Asset"; // caption of column $col["name"] = "AssetID"; // field name, must be exactly same as with SQL prefix or db field $col["width"] = "70"; $col["fixed"] = true; $col["align"] = "center"; $col["editable"] = true; $str = $g->get_dropdown_values("select DISTINCT AssetNumber as k, AssetNumber as v from mexassets ORDER BY AssetNumber"); $str = ':;' . $str; $col["stype"] = "select"; $col["edittype"] = "select"; $col["searchoptions"] = array("value" => $str, "separator" => ":", "delimiter" => ";"); $col["editoptions"] = array("value" => $str, "separator" => ":", "delimiter" => ";"); $col["editoptions"]["multiple"] = "true"; $col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ $('select[name=AssetID]').select2({width:'80%', dropdownCssClass: 'ui-widget ui-jqdialog'}); },200); }"; $cols[] = $col; Tue, 14 Nov 2017 03:11:53 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17185604 Error Exporting dates to excel Hi. I'm exporting to excel my grid. I have a column with date formatting. In my database i have dates like this: 0000-00-00. in the screen no display in that columns. thats ok.. but if i export to excel, i'm getting this date: "-0001-11-30" in the 0000-00-00 fields.. how can i do to make empty cells when a date 0000-00-00 was found? Wed, 08 Nov 2017 16:56:53 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17184687 Inline add, four movement keys and auto save Hello, Will be possible to implement inline add moving with the four scroll arrows in the keyboard, so when move auto save data entered. Thank you! Thu, 16 Nov 2017 22:31:12 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17184374 Jqgrid - Column menu with actions Hi, Does it support jqgrids column menu with actions? The person can choose to hide/show columns, filter, and group individual columns. http://www.guriddo.net/demo/demos/jqgrid/functionality/column_menu/default.php Mon, 06 Nov 2017 15:34:34 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17182039 Your Js virus trigger a linux virus scan The files jquery.jqGrid.min.js jquery.jqGrid2.min.js show as a virus when using Linux Malware Detect v1.6.2 just so you know what is the current verison of phpgrid, i may need to upgrade thanks Thu, 02 Nov 2017 19:11:46 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17180245 Export Export function is not working in Firefox 56.0.2 64 bit. Please give some solutions Thu, 02 Nov 2017 05:35:57 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17180132 Autocomplete Hello. In the sql on formatoptions, can I use the where clause? $col["formatter"] = "autocomplete"; // autocomplete $col["formatoptions"] = array("sql"=>"SELECT codProfesional AS k, nombre AS v FROM gen_profesional ORDER BY nombre", "search_on"=>"matricula", "update_field"=>"codProfesional"); Wed, 01 Nov 2017 21:20:47 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17179886 Country/State/City - No onload countrywise selection of state Dear Abu, if you edit a record in the demo all states appear in the state dropdown although Pakistan is selected as country. If you change the country and then change back everything is ok. Is there a chance to filter "onload"? THX in advance :-) Regards, K. Mon, 30 Oct 2017 18:03:09 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17178129 search Hello! It looks like some problems exist for search. When I using search function (typing keywords in the field) this error occuers: "undefined searchField in php_dist, next row:" $fld = $this->escape_string($_REQUEST['searchField']); var_dump($_REQUEST); array(8) { ["grid_id"]=> string(5) "list2" ["_search"]=> string(4) "true" ["nd"]=> string(13) "1506591962755" ["rows"]=> string(2) "20" ["jqgrid_page"]=> string(1) "1" ["sidx"]=> string(8) "id_image" ["sord"]=> string(4) "desc" ["filters"]=> string(123) "{"groupOp":"AND", "rules":[ {"field":"IMG_FILE", "op":"cn", "data":"00114"}, {"field":"HEADER_TEXT_DOC", "op":"cn", "data":"Abu"} ] }" } script works when changing code to: //$fld = $this->escape_string($_REQUEST['searchField']); $past = json_decode ($_REQUEST['filters'],true); $fld = $past['rules'][0]['field']; + //$fldata = $this->escape_string($_REQUEST['searchString']); //undefined searchString $fldata = $past['rules'][0]['data']; + // $foper = $this->strip($_REQUEST['searchOper']); // undefined searchOper $foper = $past['rules'][0]['op']; Mon, 30 Oct 2017 18:11:27 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17176068 Multiple File Icons Hi Abu, Love the product and I just wanted to share some code. I had previously implemented displaying icons in the grid for uploaded files which worked well. I have now enabled the multiple file upload option and wanted to maintain the icon display feature, only this time display 1 icon per uploaded file. Here's the solution I came up with adding another array to your original solution: function display_icon($data) { $filelist = $data["attachment"]; $filearray = explode(",",$filelist); $filecount = count($filearray); $result = ""; for($x=0; $x ; } return $result; } Mon, 30 Oct 2017 18:08:10 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17175998 Inline edit certain columns there's a way in the inline edit to show a columns in a "readonly" way??? show but not edit in line? thanks Thu, 26 Oct 2017 07:50:12 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17175959 non-database dropdown I have a dropdown (for regions) in an include member. It's an array. How can I get it to display the data in a dropdown? I have the 'member' included and it works in other programs that don't use this grid quite well. I'm also able to successfully use a database table for a 'select'. But how do I get the data from this "include" member into my dropdown. Here is what I've tried (stateList['US'] is in the included code): $col = array(); //$states_arr = arrayToSelect($stateList['US'], $remitToState); $col["title"] = "AP State"; // caption of column, can use HTML tags too $col["name"] = "remitToState"; // grid column name, same as db field or alias from sql $col["dbname"] = "remitToState"; $col["width"] = "35"; $col["search"] = true; $col["editable"] = true; $col["edittype"] = "select"; // render as select //$str = $g->get_dropdown_values(arrayToSelect($stateList['US'], $remitToState)); $str = $g->get_dropdown_values(array(arrayToSelect($stateList['US']))); //$col["editoptions"] = arrayToSelect($stateList['US'], $remitToState); //$col["editoptions"] = array($stateList['US']); $col["editoptions"] = array("value"=>":;".$str); //$col["formatter"] = "select"; // display label, not value //$col["stype"] = "select"; $cols[] = $col; Thu, 26 Oct 2017 04:11:08 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17175887 master-detail-fancy inside subgrid Hi, It's possible to have a master-detail-fancy inside a subgrid? I have a master grid with: - subgrid (+) and also - I define a cols link with fancybox (like master-detail-fancy.php from demos): $col["default"] = "View Details"; and work perfectly.. I also use the same code (maser-detail-fancy) into subgrid (subgrid_detail.php) but $lid_d = $_GET["id"]; return the master grid id not subgrid id and into fancybox I get wrong results ($grids_d->select_command = "SELECT * FROM cnpp_log WHERE idtabela = $lid_d";) How send correct to second id Please help, Adrian Thu, 26 Oct 2017 07:58:04 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17175398 Error while using Search Hi Error while using Search Couldn't execute query. Column 'id' in where clause is ambiguous - SELECT count(*) as c FROM (SELECT t.id ,t.title, rr.s_no, rr.henkyakuyotei FROM tosho as t INNER JOIN (SELECT r.id,s_no,henkyakuyotei,r.status FROM rent as r WHERE r.status ='2') AS rr WHERE t.status = '2' AND ( `id` LIKE '%2%' )) pg_tmp SQL is follow.This can run in phpMyAdmin . SELECT t.id ,t.title, rr.s_no, rr.henkyakuyotei FROM tosho as t INNER JOIN (SELECT r.id,s_no,henkyakuyotei,r.status FROM rent as r WHERE r.status ='2') AS rr WHERE t.status = '2' Mon, 23 Oct 2017 17:05:48 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17167969 Installation keep installing Demo not my DB Hello, Just purchased the full copy. I followed the instructions by renaming and modifying config.php with my hosted MySQL database. After running "install.php" I am taken to the demo site instead of my own database. Can you please provide clear instructions on how to prevent the demo and get to my own database defined in the config.php? Thank you, Sun, 22 Oct 2017 05:24:14 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17167534 jquery is not working on phpgrid why?? i complete read the documentation and install adminlte with laravel integration but one error is phpgrid is not calls jquery what happend with it i dnt knw please rply me fast. Sat, 21 Oct 2017 17:40:01 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17167389 Send email on_delete Is there a way I cand send an email when I delete a record from db? I mean I want to show what was erased, actually I can send the email but empty $e["on_after_insert"] = array("manda_correo", null, true); $e["on_delete"] = array("correo_borrado", null, true); $g->set_events($e); "some part of the emaail" {$data["params"]["id_supervisor"]} btw when I insert a record the email shows the values inserted Fri, 20 Oct 2017 18:01:18 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17167033 Multi virtual/math column Hi, it is possible to create more than one virtual/math column? I'm trying to do that, only the last one appears. $col = array(); $col["title"] = "col1v"; $col["name"] = "col1-virtual"; $col["width"] = "40"; $col["editable"] = false; $col["hidden"] = false; $col["on_data_display"] = array("do_mathmm",""); $cols[] = $col; $col = array(); $col["title"] = "col2v"; $col["name"] = "col2-virtual"; $col["width"] = "40"; $col["editable"] = false; $col["hidden"] = false; $col["on_data_display"] = array("do_mathss",""); $cols[] = $col; function do_mathss($data){ return $data["wholesale_price"] * $data["diff_order_ps"] * 2; } function do_mathmm($data){ return $data["wholesale_price"] * $data["diff_order_ps"] * 1; } Thu, 09 Nov 2017 20:47:55 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17166954 Data crossing between table and imported file Hello Abu, There is a way to implement module for Data crossing to compare Cols data as when you´re searching yo select All or Any then compare symbol as (Contains, equal, etc). So I compare it with the other Col from uploaded file. This is to implement with module Export - Import 2, this is to compare to the flight between data col into file imported and data col into table. Thank you, regards! Mon, 23 Oct 2017 17:10:07 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17166429 Bulk Edit custom behavior I followed the code in the bulk-edit example. It seems to me that if you use that, then it does what is in the update_data function and does not do its normal bulk edit functionality. I would like it to first do the normal bulk edit functionality and then do some extra code, is there a setting for that? Fri, 20 Oct 2017 11:06:47 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17165800 Excel-Export don't work correct in version 2.2 Hallo Abu, my Excelexport works not correct. After download the file i can't open the excel-sheet. I got a filename "my-file.xlsx.xls" and i can't open it with excel. Please check your demo "http://www.phpgrid.org/demo/demos/export/export-all.php" the results there are the same. Gerd PS: Please have a look to your homepage there is no menu !!! Fri, 20 Oct 2017 04:16:04 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17165034 integration with codeigneiter Best regard, I need your help by integrating phpdatagrid into codeigneiter. It's possible? Thank you very much Fri, 20 Oct 2017 18:01:24 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17164978 drop down select Hi sir, Required message is not shown for the Drop down fields. How to define the message . Thu, 05 Oct 2017 03:21:56 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17158431 How do I get Data before updating I am trying the code below. When I add the line: $datab4=$data; it prevents saving the update-probably a code error in do_onselect? function do_onselect(id) { var rd = jQuery('#list1').jqGrid('getCell', id, 'company'); // where invdate is column name jQuery("#span_extra").html(rd); $datab4=$data; } then (to log only fields changed): function update_log($data) { global $g,$THISTABLE,$resultbefore,$datab4; foreach($data[params] as $k=>$d) { //global $StringID; //global $user; //$achgs2=$achgs2."(`action`,`attribute_name`,`new_value`, `updated_by`) VALUES ('Update', '$k','$d', '$user')"; $db4=$data["params"]["$k"]; if ($db4<>$d and $k<>"LastUpdated" and $k<>"seqnum") { $achgs2=$achgs2."[$k][$db4[$i]] to [$d]"; } $i++; } Sun, 01 Oct 2017 19:25:54 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17149345 How can I set up the hover effect on rows How can I set up the hover effect on rows? Sat, 30 Sep 2017 01:34:48 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17148750 Export csv, xls with template Dear Mr Abu, Is PHP Grid support export with file template? Regards, Samsun Sat, 30 Sep 2017 01:42:32 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17147478 set_col_default I have not been able to get $g->set_col_default('jobdate', '2017-02-03'); to work and it's not even as complicated as I need it to be. What I need is THIS during an "ADD RECORD operation". $g->set_col_default('jobdate', insert todays date into the record); Every time I put this statement into the code and launch the page, I get a blank white screen. $g = new jqgrid($db_conf); $grid["caption"] = "JOBS"; $grid["toolbar"] = "bottom"; $grid["pgbuttons"] = false; $grid["pgtext"] = null; $grid["width"] = "1080"; $grid["sortable"] = true; $grid["sortname"] = "done"; $grid["rowNum"] = 999; // or any of your desired rec/page FINALLY! this works! $grid["rowList"] = array(); $g->set_options($grid); $g->table = "jobs"; $col = array(); $col["name"] = "jobid"; $col["title"] = "JobID"; $col["fixed"] = true; $col["width"] = "60"; $col["editable"] = false; $cols[] = $col; $col = array(); $col["name"] = "custid"; $col["title"] = "CustID"; $col["fixed"] = true; $col["width"] = "60"; $col["editable"] = false; $cols[] = $col; $col = array(); $col["name"] = "jobdate"; $col["title"] = "Date"; $col["fixed"] = true; $col["width"] = "94"; $col["formatter"] = "date"; $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'m/d/Y'); $col["align"] = "right"; $cols[] = $col; $col = array(); $col["name"] = "year"; $col["title"] = "Year"; $col["fixed"] = true; $col["width"] = "60"; $col["align"] = "right"; $cols[] = $col; $col = array(); $col["name"] = "make"; $col["title"] = "Make"; $col["fixed"] = true; $col["width"] = "100"; $cols[] = $col; $col = array(); $col["name"] = "model"; $col["title"] = "Model"; $col["fixed"] = true; $col["width"] = "174"; $cols[] = $col; $col = array(); $col["name"] = "engine"; $col["title"] = "Engine"; $col["fixed"] = true; $col["width"] = "110"; $cols[] = $col; $col = array(); $col["name"] = "mileage"; $col["title"] = "Mileage"; $col["align"] = "right"; $col["fixed"] = true; $col["width"] = "80"; $cols[] = $col; $col = array(); $col["name"] = "license"; $col["title"] = "License"; $col["align"] = "right"; $col["fixed"] = true; $col["width"] = "90"; $cols[] = $col; $col = array(); $col["name"] = "done"; $col["title"] = "Done"; $col["search"] = false; $col["align"] = "center"; $col["fixed"] = true; $col["width"] = "60"; $cols[] = $col; $col = array(); $col["name"] = "memo"; $col["title"] = "Memo"; $col["fixed"] = true; $col["width"] = "90"; $col["sortable"] = false; $cols[] = $col; $col = array(); $col["name"] = "staxrate"; $col["hidden"] = true; $cols[] = $col; $col = array(); $col["name"] = "vin"; $col["hidden"] = true; $cols[] = $col; $col = array(); $col["title"] = "Action"; $col["name"] = "act"; $col["fixed"] = true; $col["width"] = "70"; $col["align"] = "center"; $cols[] = $col; $g->set_columns($cols,true); $outjobs = $g->render("list1"); //$g->set_col_default('jobdate', '2017-02-03'); // supposed to be used only for add record // End of JOBS grid definition Sat, 30 Sep 2017 01:36:56 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17146532 Grouping Toggle / Untoggle All Hi Abu, I've got a grid with 2 nested layers of grouped items which is working fine: $grid["groupingView"]["groupField"] = array("name","coupon"); What I would like to do is have a "+" button either in the header or in the buttons at the bottom of the table that will collapse or expand all the grouped rows. I've searched in the forum and found the code for a similar thing for SubGrids however can't make it work for Groups. https://phpgrid.desk.com/customer/portal/questions/6970287-subgrid-expand-all I can see the code that runs when clicked the +/- is: onclick="jQuery('#list1').jqGrid('groupingToggle','list1ghead_1_516');return false; I want to get all the 'list1ghead_#####' items and loop through them to collapse/expand. Ideally as well since it is nested is there a way to have a collapse/expand all option inside the nesting, i.e when I click the first "+" to show the sub grouped items there is an option inside there to only expand all those under the first layer of the nest? Thanks mate, Matt Fri, 20 Oct 2017 11:06:53 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17146052 Hiding currency formatted values if null / empty Hi there, I currently have columns setup with the following format: $col["formatter"] = "currency"; $col["formatoptions"] = array("prefix" => "$", "suffix" => '', "thousandsSeparator" => ",", "decimalSeparator" => ".", "decimalPlaces" => 0); But if the value is empty or null, it shows on the grid as 0.00 How can I make it show these as empty instead? Thanks Sun, 24 Sep 2017 20:17:11 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17145062 Multiselect filter doesn't work in search dialog box This can be viewed also in your demo (Integration > Multiselect filter). When I open the search dialog box and select Client, the multiselect filter appears in the background, but is non possible to check any checkbox. Thu, 02 Nov 2017 07:03:06 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17144806 custom property for editoption function updateddet(data) { $("#agtcode").attr('required', true); } this is not working.How to make this to work.Help is need very urgently Sun, 24 Sep 2017 19:35:30 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17144756 Disable header/footer-rwo Hello Mr Abu, is it possible to hide the header/footer-row with the options "Add new row, Edit selected row, ..."? I can't find it anywhere. Thanks a lot for your help. Sat, 30 Sep 2017 01:37:02 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17144121 inliene edit Sir, How to make some fields to be non editable after calling some custom calculation functions. ie. function calculatekgfat() { var kgqty= (($("input[name=kgqty].editable").val()*$("input[name=fat].editable").val())/100); $("input[name=kgfat].editable").val(parseFloat(kgqty).toFixed(2)) ; $("#kgfat").attr("disabled", "disabled"); calculatekgts() ; } Fri, 22 Sep 2017 18:55:19 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17144044 default value in colums Hi, how can i set a default value for a colum? I mean // --------------------------------------- NOMBRE $col = array(); $col["title"] = "NAME"; $col["name"] = "nombre"; $col["width"] = "15"; $col["editable"] = true; $col["align"] = "center"; $col["search"] = true; $cols[] = $col; I would like to set a default value for this colum when I open the add record option this colum should show the default value I want to set Fri, 22 Sep 2017 19:01:11 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17143653 Case Insensitive Search with Array as data source Hi Abu, I have a grid with an array set as the data source. When I try to use the inline search to filter the grid, it is Case Sensitive and I would like it to be case insensitive. I had set the column up as: $col["name"] = 'column_name'; $col["dbname"] = 'LOWER(column_name)'; This was to try to search the column in lower case, but it did not work. Could you please advise on how to get this inline search working Case Insensitive for a grid with an array as the data source? Thanks Fri, 22 Sep 2017 19:00:58 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17143578 function lower(numeric) not found on postgresql Hi Abu, I already bought the new library, and its working fine. except when I declare the following and try to search a numeric field, i am getting a postgresql error that $col = array(); $col["title"] = isset($lang['HIGH']) ? $lang['HIGH'] : 'High'; $col["name"] = "px_high"; $col["dbname"] = "h.px_high"; $col["width"] = "80"; $col["fixed"]=true; $col["sorttype"] = int; $col["editable"] = false; $col["align"] = "right"; $cols[] = $col; SELECT count(*) as c FROM (SELECT a.px_date as Date, ROUND(a.px_open,2) AS open, ROUND(a.px_high,2) AS high, ROUND(a.px_low,2) AS low, ROUND(a.px_close,2) AS close, ROUND(a.adj_px_close,2) AS adj_close, a.volume, a.ex_dividend as dividend, a.split_factor as split FROM historical_prices a WHERE a.figi = 'BBG000C2V3D6' AND ( LOWER(a.px_open) LIKE LOWER('%1%') )) pg_tmp this coming under postgresql query site ERROR: function lower(numeric) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 326 Can you help? Thanks Tue, 19 Sep 2017 15:02:16 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17142020 Bootstrap 4 including Hallo, i want to ask for the plans in near future to include bootsap 4 in phpgrid. Regards Gerd Thu, 21 Sep 2017 10:10:23 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17141142 Uncheck row of recently added record. Hi, Is there a way to unhighlight and uncheck a row after it has been saved/updated? Thanks - Greg Tue, 19 Sep 2017 23:18:25 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17140780 custom-grid-button Hi Abu, i try set a custom button, having this: here there's no problem, this invoke the funcionality of the edit button of the toolbar. But if i have a custom button in the toolbar and i want to do the same with that... first add in js the button: jQuery(document).ready(function(){ jQuery('#list1').jqGrid('navButtonAdd', '#list1_pager', {'caption' : 'Generar Pago', 'buttonicon' : 'ui-icon-extlink', 'onClickButton': function() { var selectedRows = jQuery('#list1').jqGrid('getGridParam','selarrrow'); window.open("facturar.php?id="+selectedRows,'_self') }, 'position': 'last' }); The question is: how to do for invoke the behavor in my custom button like the edit button of the toolbar??? what value set instead of #edit_list1??? i try this without luck... thanks... Fri, 15 Sep 2017 17:20:59 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17140243 aucomplete contry, like Dropdown Dear Mr Abu, Would you like to gime example Autocomplete to Select Coontry->State->City like example Dropdown Country? Regards, Samsun Fri, 15 Sep 2017 11:34:45 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17140000 Date Range Picker work with autofilter but not with search options Hi Abu, I use "daterange" for search. This is my code: $col["isnull"] = true; $col["width"] = "120"; $col["formatter"] = "date"; $col["stype"] = "daterange"; $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.Y', "opts" => array("showOn"=>"none")); $col["align"] = "center"; $col["editrules"] = array("custom"=>true,"custom_func"=>"function(val,label){return dataValidate(val,label);}"); Work perfectly in autofilter (the result is correct), but same filter in advance search (same in simple search) does not filter at all. Please help! Thanks! Adrian Wed, 13 Sep 2017 23:06:42 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17138708 select_statement I have conditional select statements. One returns columns a, b, and c. Another returns columns c, d, e, and f. The query is dependent on a master grid selection. The selection action happens with no errors but the grid does not change. Do I need to refresh the grid so that it picks up the query change? Thanks in advance. Wed, 13 Sep 2017 20:16:13 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17138169 Master-detail Hello, i want to set a dropdown control which has the same type dependency of the grid's source this is the detail: $id = intval($_GET["rowid"]); $g->select_command ="SELECT * FROM pagos WHERE idemp = $id"; $g->table = "pagos"; $col = array(); $col["title"] = "Id"; $col["name"] = "idpag"; $col["fixed"] = true; $col["width"] = "33"; $col["align"] = "center"; $col["show"] = array("list"=>false,"edit"=>false,"add"=>false,"view"=>false); $cols[] = $col; $col = array(); $col["title"] = "Alumno"; $col["name"] = "idalu"; $col["fixed"] = true; $col["width"] = "44"; $col["align"] = "center"; $str2 = $g->get_dropdown_values("select distinct id as k, name as v from alumns where idemp = $id"); the dependency of this last line no works.... any ideas???? Tue, 12 Sep 2017 02:03:56 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17136243 Master-detail Hello, i want to set a dropdown control which has the same type dependency of the grid's source this is the detail: $id = intval($_GET["rowid"]); $g->select_command ="SELECT * FROM pagos WHERE idemp = $id"; $g->table = "pagos"; $col = array(); $col["title"] = "Id"; $col["name"] = "idpag"; $col["fixed"] = true; $col["width"] = "33"; $col["align"] = "center"; $col["show"] = array("list"=>false,"edit"=>false,"add"=>false,"view"=>false); $cols[] = $col; $col = array(); $col["title"] = "Alumno"; $col["name"] = "idalu"; $col["fixed"] = true; $col["width"] = "44"; $col["align"] = "center"; $str2 = $g->get_dropdown_values("select distinct id as k, name as v from alumns where idemp = $id"); the dependency of this last line no works.... any ideas???? Tue, 12 Sep 2017 02:02:42 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17136219 Preserve grid view when updating Hi. Is there a way to keep track of changes in a grid? That is, when hiding columns or moving the width of the same remain the same as updating the page. Fri, 08 Sep 2017 13:07:03 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17135616 Autofill field I want to autofill a colum but i cant i dunno what´s wrong $col = array(); $col["title"] = "direccion"; $col["name"] = "direccion"; $col["width"] = "4"; $col["editable"] = true; $col["align"] = "center"; $col["search"] = true; $col["formatoptions"] = array( "sql"=>"SELECT direccion as k, nombre as v FROM supervisores","update_field"=>"direccion"); $col["formatoptions"] = array( "sql"=>"SELECT *, nombre as v FROM supervisores", "search_on"=>"concat(nombre,'-',id)", "callback"=>"fill_form"); function fill_form(data) { jQuery("input[nombre=direccion].FormElement").val(data.direccion); jQuery("input[nombre=direccion].editable").val(data.direccion); } When i do the insert (nombre) on grid i want to autofill the direccion field Thu, 07 Sep 2017 18:16:45 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17135211 POSTGRES Free Version 2.0 for test Hi, Do you support POSTGRES on free version 2.0, Latest download available ? Actually i get this message : You must have PostgreSQL installed for this demo. Also set database crendentials in this demo. Click on Code tab for source. I update, the credentials, but always the same problem ! Tue, 19 Sep 2017 23:16:43 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17135106 Loading Image Hi, Refer to https://gist.github.com/gridphp/915d2e0834354913fdfd338d47d50a53 Loader is not showing when i just click on the submit, loader.gif shows when it come to complete. Any suggestion? Thu, 07 Sep 2017 18:14:29 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17134159 Limit a (inline) input to 4 digits Hi Abu I have 2 Questions 1. I have a 4-digits code coloumn in my record, and I want to limit the input to exactely 4 digits, when adding a new record. I don't see a specific limit command, how can i now peform this check ? 2. Is the serverside validation only avaiable in the popup mode ? I'd like to avoid the popup mode and prefer the inline add method. Thanks for any help Mon, 04 Sep 2017 20:59:14 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17132596 Aliased columns on JOIN This software seems to have a hell of a hard time dealing with aliased columns on a JOIN. I can't get them to show on the grid about half the time, even though my code between php programs is very similar -- just the query part is different. Example: $g->select_command = "SELECT prim_key, a.file_name , a.sign_date, CONCAT(b.firstname, ' ', b.lastname) AS person FROM vdocs a JOIN vmems b ON b.groupId = a.vendor_id AND b.member_id = a.vdoc_mem_id " The field "person" will not show up in the grid, even though it looks like pretty simple code to display it. And yeah, it DOES show up in my phpmyadmin when I do a query. The grid 'definition' is this: $col = array(); $col["title"] = "Signed By"; $col["name"] = "person"; // grid column name, same as db field or alias $col["width"] = "40"; $col["editable"] = false; $col["search"] = false; $cols[] = $col; It doesn't work when I prefix the field with the table name, when I use it as "b.person", when I use it as "person" AND it doesn't even work if I just select 'lastname' and use that in '$col["name"]'. It doesn't show up in the JSON Response, so yeah I see that. But I don't care -- I'm not the one who wrote the JSON; I'm just trying to save time writing reports and I seem to be wasting it instead of saving it. So what's the deal here? I've had the same issues with almost EVERY OTHER alias I've used with phpgrid. I've poured over the forums and the documentation and nothing I see answers this. Tue, 12 Sep 2017 02:01:51 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17130981 conditional edit/delete by row We have an older version and are looking to have a conditional edit/delete by row. It looks like the newer versions can do this as shown in demos/editing/column-access.php The version I have does not include this example file. Is a conditional edit/delete by row avaivable in version 1.4.8.3? Tue, 29 Aug 2017 20:35:57 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17129380 Add second grill Hi Abu. I would like to know if you can add, edit or delete records of the second grid, depending on the value of the field of the first grid. Example: If the state of the first grid is "O" open, I can add, modify, and unsubscribe. If the state of the first grid is "C" closed, I can not make any changes in the second grid. Thank you Wed, 30 Aug 2017 01:24:23 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17129157 MS SQL DB special characters umlauts Hi, we have a problem to save special characters (german umlauts) in our database by the Grid. Grid: äüö@€ DB: äüö@€ Could you help me please ? Thanks Best regards. Markus Mon, 28 Aug 2017 19:14:33 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17128446 Hiding Blank Columns Per https://phpgrid.desk.com/customer/portal/questions/14415489-hidding-empty-columns what is the syntax to 1. check for blank columns and 2. hide those columns. Mon, 28 Aug 2017 19:08:21 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17127026 New daterangepicker example code Licensed user, V2.2 code. The demo video ( http://www.phpgrid.org/date-range-picker-supported/ ) on the new support for the daterangepicker is exactly what I'm looking for in my grid. Where can I find example code to make it work exactly like the video? Thanks! Thu, 24 Aug 2017 19:28:14 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17126675 Exporting just currently visible columns Is there a way to restrict exported data just to the columns that the user made visible? I know that there is a possibility to always prevent a column from being exported ($col["export"]=false;) and there's a demo (export-selected.php) that, judging by the grid's header ("Export Selected Rows/Columns"), is supposed to do just what I'm looking for - but unfortunately the demo only honors selection of rows, and always exports all columns (regardless of which are selected/visible.) Mon, 28 Aug 2017 19:00:00 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17126210 session on Mouse over hi sir, Session is not working in grid while trying to use my own session function. For Example var timoutWarning = 84000; // Display warning in 14 Mins. var timoutNow = 84000; // Timeout in 15 mins. //var timoutWarning = 30000; // Display warning in 14 Mins. //var timoutNow = 31000; // Timeout in 15 mins. var logoutUrl = 'logout.php'; // URL to logout page. var warningTimer; var timeoutTimer; // Start timers. function StartTimers() { warningTimer = setTimeout("IdleWarning()", timoutWarning); timeoutTimer = setTimeout("IdleTimeout()", timoutNow); //alert(warningTimer); //alert(timeoutTimer); } // Reset timers. function ResetTimers() { clearTimeout(warningTimer); clearTimeout(timeoutTimer); StartTimers(); $("#timeout").dialog('close'); //alert(warningTimer); //alert(timeoutTimer); } // Show idle timeout warning dialog. function IdleWarning() { $("#timeout").dialog({ modal: true }); } // Logout the user. function IdleTimeout() { window.top.location.href = logoutUrl; } Thank you Thu, 24 Aug 2017 20:51:57 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17125996 Horizontal Scroll Bar Is there a way to place the horizontal scroll bar at the top of the grid? Tue, 22 Aug 2017 19:00:04 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17124967 Export to excel and pdf does not work in my script in version 2.2 Hi, Abud, I try for hours that my grid is exported to excel. It has always worked, but in Phpgrid version 2.2, the xlsx file can not be read by Excel. The same goes for exporting to PDF. It says: "TCPDF ERROR: Some data has already been output, can not send PDF file" In the demos it works. Here is my script: https://pastebin.com/9k3gFA66 Thank you Sun, 20 Aug 2017 19:11:03 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17124136 Colon in an array for a dropdown Good evening, I'd like to insert a value with a colon in an array for a dropdown. But unfortunately this is already used as syntax. Is there a possibility? Best regards Markus Sun, 20 Aug 2017 09:26:47 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17122852 Concurrency In edit mode, how does phpgrid handle concurrency? I am guessing that last change in overrides previous changes? Or does phpgrid check for a changed record and deny the update? Thanks! Wed, 16 Aug 2017 15:15:52 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17122613 image hi sir, how to scan image using web camera? and upload to the site by using the web camera. instead of Browsing and uploading the image Thank you Wed, 30 Aug 2017 01:19:53 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17122459 Integrating latex javascript library Hi, I need to display data with some mathematical symbols like \theta \gamma etc. Can I integrate latex java script libraries to phpgrid to display mathematical symbols in in the grid which can be edited? Many thanks. Mon, 14 Aug 2017 20:10:44 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17120727 adding upload field prevents save/adding of record? I have an edit form of about 40 fields. All of them are working as expected now. Unfortunately, when I add an upload field, it shows up OK, but clicking "save" in edit form does not save the data (the form closes, no error message is displayed, but any changes made simply do not save); also, "new record" form is affected - clicking on "Submit" button has no effect at all (form does not close, new record is not created, no error message is displayed.) Here's the upload field configuration: $col["title"]="Upload Picture"; $col["name"]="PictureFileName"; $col["editable"]=true; $col["edittype"]="file"; $col["upload_dir"]="peoplepictures"; $col["editrules"]=array("ifexist"=>"rename"); $col["show"]=array("list"=>false,"edit"=>true,"add"=>true); $col["formoptions"]=array("rowpos"=>"17", "colpos"=>"1"); As soon as I remove the field, both the "new" and "edit" forms start working perfectly again. Actually, I had the upload field (as described above) work perfectly before - it seems that perhaps removing ",true" from my "$g->set_columns($cols,true);" broke the behavior? (can't use ",true" right now as I have some "select"-type lookup columns that the grid insists on saving when ",true" is added) Although I can't be sure that this is what broke the behavior, as I have also made a lot of other customizations to the form. Please let me know if any further information is necessary to diagnose the issue - thank you in advance for your assistance! Fri, 11 Aug 2017 12:27:22 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17120081 autowidth and column selection? I've recently bough full version of PHP Grid - thank you for such a wonderful tool! That said, I'm having an issue - I use "autowidth" setting for my grid. Unfortunately, when I use Column Select button and select different columns for viewing, the grid does not resize to fit the browser window afterwards. Is there a way to force the autowidth resize after new set of columns is selected by the user? Thank you in advance for your help. Tue, 08 Aug 2017 20:44:15 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17118223 Filter columns icons disapears Hi, I have a grid with 12 columns, If I filter those columns to show only 2 columns, the grid resizes and I can't export the info because the EXPORT button is not visible. Wed, 09 Aug 2017 11:06:58 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17117541 Insert Multiple Values into Table on Submit Dear Abu Ghufran, I have the a table which contains the following columns: 1. ID - AutoID 2. ClientID 3. CourierID 4. Date What I'm looking for is how to insert multiple Data into Table at once. Example: I Fill: clientID with: 2,3,4,7,9 CourierID: 1 Date: 3 Aug 2017 When I click submit, the data inserted into Table like this: ID ClientID CourierID Date 1 2 1 3 Aug 2017 2 3 1 3 Aug 2017 3 4 1 3 Aug 2017 4 7 1 3 Aug 2017 5 9 1 3 Aug 2017 Its Like the Insert into Mysql statement: INSERT INTO tableName (column1,column2,column3,column4) VALUES ('value1' , 'value2', 'value3','value4'), ('value1' , 'value2', 'value3','value4'), ('value1' , 'value2', 'value3','value4'); Is this scenario doable in phpgrid. Looking forward to your reply. Best regards, Azhar Sun, 06 Aug 2017 18:19:54 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17116363 DB2 Error Come sir how to solve the below issues syntax error, unexpected 'new' (T_NEW) in /phpgrid/lib/inc/adodb/drivers/adodb-db2.inc.php on line 514. its very urgent. thank you Thu, 03 Aug 2017 10:53:31 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17116355 Php 7 php grid is not working in php 7 how to solve this issue ? Mon, 07 Aug 2017 18:32:24 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17116349 The tree does not work correctly Good afternoon. In tree mode, when you add a branch, it branches randomly into a random branch, not into the selected branch. It also happens in demo-examples. How do I make an added branch add to the selected item? Thu, 03 Aug 2017 11:57:18 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17116079 PHP Grid Free Version Postgresql Hi All, I was trying to do the automatic installation for phpgrid. There seem to be no option for me to connect to Postgresql. The installer only give choices to connect to mysql and mysqli. After installing (connect to mysql), I realised in the 'DEMO' section, in the 'Loading' tab, there is an option to connect to Db Layer Pgsql I modified the credentials in the corresponding code, and is able to connect to Postgresql. However, when the grid tries to load my table, it shows this message: "You must have PostgreSQL installed for this demo. Also set database crendentials in this demo. Click on Code tab for source. {"page":1,"total":1,"records":"2","rows":[{"Name":"Charles","Gender":"M","Age":"24"},{"Name":"Erik","Gender":"M","Age":"25"}]}" Notice that row 3 to 5 of the message is actually the content of my table. Can anyone advise on what's the issue here? Thank you! Mon, 31 Jul 2017 07:30:02 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17114167 Search on other field Hi Abu, Using the inline search, is it possible to show the search results based on the values in a hidden column? I was thinking there might be something similar to $col["sortname"] for the search? Thanks Fri, 28 Jul 2017 18:12:26 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17113299 SEARCH_JSON OR option Greetings! I am using this construct: "groupOp":"OR" but when the query is generated it still contains an AND not an OR. Example from this https://phpgrid.desk.com/customer/portal/questions/1126469-is-it-possible-to-filter-phpgrid-data-with-more-than-one-field-search-json- post: "groupOp":"OR", "rules":[ {"field":"mk_id","op":"ne","data":"102"}, {"field":"mk_id","op":"eq","data":"A"} Thu, 27 Jul 2017 06:22:22 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17112158 Cutting Grid Load Time in Half I have some resource intensive queries that run and populate in the grid (30+ seconds). When the user click on the link to load these pages, it takes nearly 30 seconds for the grid to even show up, and another 30 seconds of it saying "Loading" before it displays data. I eventually discovered that the source code issues the same query I have, with a "LIMIT 1" on the end; and it looks like this is done to get the column names and data types. If this is the case, why not use "LIMIT 0" so it will return instantly? I change my jqgrid_dist.php to this and the grid loads and displays in 1/2 the time (30 seconds!). Is this not viable for other DB's or something? Why not do this all the time? Thu, 27 Jul 2017 05:31:12 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17111232 Forbidden error When I try to use filter on column (type word in box) I get popup with message: Forbidden You don't have permission to access /data/index.php on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Any idea how to solve this? Thu, 27 Jul 2017 06:17:13 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17111032 Dropdown and inline editing Hi Abu, I've a column with dropdown select like this: $col = array(); $col["title"] = "Risk"; $col["name"] = "Risk"; $col["editable"] = true; $col["edittype"] = "select"; $col["editoptions"] = array("value"=>'1:Pro1/Ris1;4:Pro2/Ris2;16:Pro4/Ris4'); $cols[] = $col; I didn't inserted the $col["formatter"] = select; because I want that keys are displayed in the grid and values only in the dropdown menu. When I update a record using the inline editing, after clicking the save button the grid show values instead of keys and I need to refresh the grid to show correct keys. If I edit the record with the dialog edit it works fine. At the moment I solved this by using the $opt["reloadedit"] = true; in order to force the grid to reload, but I wanted to report you this problem. Thanks Thu, 27 Jul 2017 06:13:44 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17110442 Dropdown and autocomplete Hi Abu. Mix some dropdown and autocomplete on line 202, but it would not be working. Do you have any idea what it might be? The diagnostico field depends on the chosen value in patologia. Thank you Https://pastebin.com/LQsC2Ggc Fri, 21 Jul 2017 19:54:43 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17108879 Error with phpgrid 2.2 and mysql Hi Abu, As soon as I update the file "jqgrid_dist.php" all my tables using mysql stop working. Code I'm using for testing: https://hastebin.com/jibuxadojo.xml When I swap the mysql table for an array it works just fine, when I try this code with the 2.1.2 grid version of jqgrid_dist.php it works. The error I'm getting: Mixed Content: The page at 'https://www.domain.com/system/agenda/test' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint 'http://www.domain.com/home/'. This request has been blocked; the content must be served over HTTPS. Kind regards, Michael Thu, 27 Jul 2017 19:57:42 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17108871 Possibel to change the order of the search operands? Hi, need to change the order of the search operands, is this possible? Ideally would like "contains" at the top of the list instead of "equal". Thanks, Nell Fri, 21 Jul 2017 09:17:56 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17108767 Order By in edittype = select does not work Hello, I have a column with edittype = select The SQL for the select uses an Order By stmt which brings back the data in the incorrect order. The SQL resolves correctly in phpmyadmin. code: $col["edittype"] = "select"; $str = $detailGrid->get_dropdown_values("(SELECT ListID as k, name as v FROM iteminventory WHERE name = 'Special Instructions' LIMIT 1) UNION (SELECT i.ListID as k, CONCAT_WS(' ',name, IF( `QuantityOnHand`>=(`QuantityOnSalesOrder`+1),'','Not in Stock' ) ) as v FROM pal_pd_products p JOIN (SELECT name, ListID, QuantityOnHand, QuantityOnSalesOrder FROM iteminventory) i ON i.name = CONCAT(p.model,'-',p.color_code) WHERE p.status IN ('A','D','PR','RI','S') ORDER BY p.model, p.color_code LIMIT 2000)"); $col["formatter"] = "select"; $col["editoptions"] = array("value" => $str); (p.model and p.color_code are varchars) Result in phpmyadmin: 604-35 Not in Stock ** Correct order 604-76 604-95 6043-1 Result in Select dropdown: 604-76 604-95 6043-1 6047-3 ... 604-35 Not in Stock ** This should show before 604-76 Everything else works just fine. (If I remove the UNION it makes no difference) Thanks in advance Wed, 19 Jul 2017 19:34:08 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17108434 Add Abu, when I add a record and I choose a client, I have to show the address, postal code and locality, but these last three data should not be able to be modified, only informative. How can it be done? Thank you Wed, 19 Jul 2017 19:04:54 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17108231 Disable Delete & Replace option in the new importing feature Hello Abu, in the new importing feature, there is the possibility (or eventually can you add in the future) to disable the Delete & Replace option? If a customer select this by mistake, can be very dangerous because he can delete all table's records!!! Thank you very much! Alexander Wed, 19 Jul 2017 18:50:22 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17107946 multi-user application record locking - best method? Ask Hi, I am building a web-app that allows several users to perform read and write-operations on the same table. What is the smartest way of preventing that a record in the table is simultaneously edited by different users (ie. changes from user A get overwritten by user B without any of users noticing the conflicting behaviour)? Thanks! C Mon, 31 Jul 2017 08:03:12 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17106944 date picker sir, Date picker is not working correctly when we use two date columns in the first row. ie.date1 at row 1 and column 1 . while selecting the second date it points to the first date Help me to resolve the issue. Thank you Sat, 15 Jul 2017 01:08:01 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17105702 3 Nested dropdowns I'm trying to implement 3 nested dropdowns and I can not get it to work properly. the onchange event works fine but for example where I want to edit the onload event of the third nested doesn't work as it depends on the second dropdown and it depends on the first. Is it possible to do it? Thanks a lot. Best regards Thu, 13 Jul 2017 15:57:01 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17104263 column ["link"] return empty when data loaded not from mysql Hello, i loaded data not from mysql: $url="http://example.com/ip/func_iks.php"; $response = file_get_contents($url, false,stream_context_create($arrContextOptions)); $obj=json_decode($response,true); $g->table = $obj; $col = array(); $col["title"] = "Testtesttest"; $col["name"]="tab_id"; $col["width"]="40"; $col["editable"] = false; $cols[] = $col; This work perfectly. But when i try add : $col["link"] = "http://example.com/ip/sphinx.php?tabid={tab_id}"; i have empty value at {tab_id} column. Thu, 13 Jul 2017 15:57:23 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17104232 calculated fields in custom export Hi Abu, can you perhaps give a short example how to bring a calculated column value into an exported xls or pdf? I found nothing in the demos. regards Michael Wed, 12 Jul 2017 05:39:24 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17103440 Bulk Add Dear Abu Ghufran, Good day, Do you have an example for Adding Bulk data. I have invoices grid and would like to add bulk data for selected invoices which add status "Paid" or "unpaid". Thank you for your cooperation. Best regards, Tue, 11 Jul 2017 01:08:23 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17103011 Problem with readonly-when Hi Abu, I just spent few hours on this and i can't understand where i make wrong ... I have a problem with the feature "readonly-when". My field is the following: $col = array(); $col["title"] = "Description"; // caption of column $col["name"] = "description"; $col["align"] = "center"; $col["editable"] = True; $col["editrules"] = array("required"=>true, "readonly"=>true, "readonly-when"=>"check_invoice"); $col["show"] = array("list"=>true, "add"=>true, "edit"=>true, "view"=>true); $cols[] = $col; The JS function check_invoice: function check_invoice(formid) { invoice_id = jQuery("input[name=invoice_id]:last, select[name=invoice_id]:last",formid).val(); alert(invoice_id); console.log(formid); return true; } The key of the grid invoice_id. The alert is alway returning undefined. I tried to log the formid object but i'm not sure about the what i should have. Right now i have this: https://pastebin.com/fEdSvf1V Can you give any suggestion on where can i search for my problem ? Thanks Mofel Tue, 11 Jul 2017 04:20:26 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17102507 Custom Export Sir, how to Export the Amount field inorder to make some calculations in the exported file. But the file is exported as a text fields . Help me to solve this issue in the custom export. thank you Wed, 12 Jul 2017 05:08:29 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17102324 Confirm dialog with clone function Hi, there is a way to have a confirm dialog when a user click the clone button (in the Action column or in the buttons bar), exactly like with the delete function? Thanks Sat, 08 Jul 2017 10:13:07 +0000 https://phpgrid.desk.com/customer/en/portal/questions/17100843