Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 256 through 270 (of 1,092 total)

← 1 2 3 … 17 18 19 … 71 72 73 →

Author

Replies

February 12, 2019 at 3:43 pm in reply to: jquery ui autocomplete question #127100

guriddo.support

Participant

Hello,

This can be achieved with two fields – one to accept the value and the another to show the label. The first field which will accept the value can be set to readonly and during showing the form it can be hidden (beforeShowForm).

In this case the logic of select can be changed to set the value of the first field and set the label of the second.

Do not forget to clear the value in first field if nothing is selected.
Here is a demo, but in php jqGrid

Another solution is to use a select2 plugin with custom defined field

Kind Regards,
Will

Guriddo Support Team

February 11, 2019 at 3:37 am in reply to: show column menu icon only on hover #127093

guriddo.support

Participant

Hello,

We will see if this can be done and will replay.

In principle it can be implemented.

Kind Regards,

Will

Guriddo Support Team

February 11, 2019 at 3:34 am in reply to: Hide Column names header row #127092

guriddo.support

Participant

Hello,

The header labels have a class ui-jqgrid-labels. So in case the grid has id jqGrid, to hide the labels row only do

...
$(&quot;.ui-jqgrid-labels&quot;,&quot;#gbox_jqGrid&quot;).hide(): 
...

...

$(".ui-jqgrid-labels","#gbox_jqGrid").hide():

...

after the grid is created.

Kind Regards,
Will

Guriddo Support Team

February 11, 2019 at 3:23 am in reply to: Scrollbar customization #127091

guriddo.support

Participant

Hello,

At the moment we do not see a way to integrate this plugin in our Guriddo jqGrid.

Kind Regards,
Will

Guriddo Support Team

February 5, 2019 at 11:23 am in reply to: Jqform #127085

guriddo.support

Participant

Hello,

Thank you for sharing your code.

Kind Regards,

Will

Guriddo Support Team

February 5, 2019 at 11:21 am in reply to: inline editing – after save to move to next row #127084

guriddo.support

Participant

Hello,

You may get the next row id using this code sniplet.


  var grid =  $(&quot;#grid&quot;);
  var selectedRow = grid.jqGrid(&#039;getGridParam&#039;,&#039;selrow&#039;);
  var ids = grid.jqGrid(&#039;getDataIDs&#039;);
  var index = grid.jqGrid(&#039;getInd&#039;,selectedRow);
  // next rowid is
  var nextid = ids[index + 1]

var grid = $("#grid");

var selectedRow = grid.jqGrid('getGridParam','selrow');

var ids = grid.jqGrid('getDataIDs');

var index = grid.jqGrid('getInd',selectedRow);

// next rowid is

var nextid = ids[index + 1]

Of course you should perform some filtering.

When you have this you can call editRow with this id, after saving the row using some events (see docs). Of course enclose this calling in setTimeout

Kind Regards,
Will

Guriddo Support Team

February 5, 2019 at 11:10 am in reply to: multiselect and preserveSelection #127083

guriddo.support

Participant

Hello,

In the current release this is supported, but very difficult. We have added a support for in operand in local searching.

This way it is easy to construct a cde. Here is a demo

Note that this feature is available only in GitHub.

Kind Regards
Will

Guriddo Support Team

February 4, 2019 at 1:22 pm in reply to: multiselect and preserveSelection #127079

guriddo.support

Participant

Hello,

What is the datatype – (xml,json) or local?

Kind Regards,

Will

Guriddo Support Team

February 4, 2019 at 12:37 pm in reply to: Jqform #127077

guriddo.support

Participant

Hello,

Not sure if thei is the problem, but in your loop you use
$i, While you initialize $I. The PHP is case sensitive regarding variables

Try to output the contents in the loop.

ie print the result within loop

...
$name = $file [&#039;name&#039;] [$i];
$size = $file [&#039;size&#039;] [$i];
$content = file_get_contents ($file [&#039;tmp_name&#039;] [$i]);
var_dump($name, $size, $content);

...

$name = $file ['name'] [$i];

$size = $file ['size'] [$i];

$content = file_get_contents ($file ['tmp_name'] [$i]);

var_dump($name, $size, $content);

Kind Regards,
Will

Guriddo Support Team

February 4, 2019 at 12:21 pm in reply to: jqGrid setGridWidth issue with Bootstrap #127076

guriddo.support

Participant

Hello,

I re post the answer from stackoverflow.”

“This problem is fixed and will be available in the next release. If this is a showstopper for you can get the fixed code from GitHub.

UPDATE: The code used in loadComplete can be avoided if you just set responsive option in jqGrid set to true. I recommend you to to consult the documentation here
”

Kind Regards,

Will

Guriddo Support Team

February 4, 2019 at 12:06 pm in reply to: Grid Expired #127075

guriddo.support

Participant

Hello,

Before download, please clear the browser cache. Restart your PHP and Web Server
The new downloaded zip file should have today time stamp.

Try to install on different directory

Kind Regards,
Will

Guriddo Support Team

February 4, 2019 at 8:41 am in reply to: Grid Expired #127073

guriddo.support

Participant

Hello,

Sorry for this inconvenience. We have fixed the problem. Please re download from the same location

Kind Regards,
Will

Guriddo Support Team

February 1, 2019 at 1:35 pm in reply to: Jqform #127068

guriddo.support

Participant

Hello,

I do not have idea why is this.

Note that all these fields should be in one table – demandes.
If the other fields are part from another table they will not be saved.

You can set a debug option in order to see what is happen:

...
$form_formulaire-&gt;debug= true;

1 2	... $form_formulaire->debug= true;

A log file is created in this directory. Also in order this to be seen, please be a sure that the directory is writable.

Kind Regards,
Will

Guriddo Support Team

February 1, 2019 at 1:22 pm in reply to: inline editing with Boolean objects #127067

guriddo.support

Participant

Hello,

For inline edit you can enable the editing, but make the field read-only like this

...
{name:&#039;some&#039;,... editable: true, editoptions: {disabled: true}...}
...

...

{name:'some',... editable: true, editoptions: {disabled: true}...}

...

Kind Regards,
Will

Guriddo Support Team

January 30, 2019 at 11:56 am in reply to: Dropdown with filter #127064

guriddo.support

Participant

Hello,

If I understand correct the requirement you are close to the solution provided in previous post.

Actually you do not need to use setSelect. The code with the setSelect

...
$grid-&gt;setColProperty(&#039;ref_RDV&#039;, array(&quot;label&quot;=&gt;&quot;Ref RDV&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true,&quot;align&quot;=&gt;&quot;center&quot;, &quot;classes&quot;=&gt;&quot;wr&quot;, &quot;editrules&quot;=&gt;array(&quot;required&quot;=&gt;false)));
$grid-&gt;setSelect(&quot;ref_RDV&quot;, &quot;SELECT ID_RDV,ID_RDV FROM drop_ref_rdv
ORDER BY ID_RDV ASC&quot;,false,true,true);
...

...

$grid->setColProperty('ref_RDV', array("label"=>"Ref RDV", "width"=>60, "editable"=>true,"align"=>"center", "classes"=>"wr", "editrules"=>array("required"=>false)));

$grid->setSelect("ref_RDV", "SELECT ID_RDV,ID_RDV FROM drop_ref_rdv

ORDER BY ID_RDV ASC",false,true,true);

...

can be replaced with this one

$grid-&gt;setColProperty(&#039;ref_RDV&#039;, array(&quot;label&quot;=&gt;&quot;Ref RDV&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true, &quot;align&quot;=&gt;&quot;center&quot;, &quot;classes&quot;=&gt;&quot;wr&quot;, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;dataUrl&quot;=&gt;&quot;js:&quot;.$select), &quot;editrules&quot;=&gt;array(&quot;required&quot;=&gt;false)));

$select = &lt;&lt;&lt;SELECT
function(rowid, value, name) {
	var srow = jQuery(&quot;#grid0&quot;).jqGrid(&#039;getGridParam&#039;,&#039;selrow&#039;);
	if(srow) {
                // get the row data based on the selected id
		var gridrow = jQuery(&quot;#grid&quot;).jqGrid(&#039;getRowData&#039;,srow);
                // pas it to the url
 		return &quot;select.php?num_ef=&quot;+gridrow.num_ef;
	}
}
SELECT;

$grid->setColProperty('ref_RDV', array("label"=>"Ref RDV", "width"=>60, "editable"=>true, "align"=>"center", "classes"=>"wr", "edittype"=>"select", "editoptions"=>array("dataUrl"=>"js:".$select), "editrules"=>array("required"=>false)));

$select = <<<SELECT

function(rowid, value, name) {

var srow = jQuery("#grid0").jqGrid('getGridParam','selrow');

if(srow) {

// get the row data based on the selected id

var gridrow = jQuery("#grid").jqGrid('getRowData',srow);

// pas it to the url

return "select.php?num_ef="+gridrow.num_ef;

}

SELECT;

and the file select.php can have the following


require_once &#039;../../jq-config.php&#039;;
// include the jqGrid Class
require_once ABSPATH.&quot;php/PHPSuito/jqGridUtils.php&quot;;
// include the driver class
require_once ABSPATH.&quot;php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
jqGridDB::query($conn,&quot;SET NAMES utf8&quot;);
$numief = jqGridUtils::GetParam(&#039;num_ef&#039;);
 
// Get details
$SQL = &quot;SELECT ID_RDV,ID_RDV FROM drop_ref_rdv WHERE /*your where here/* 
ORDER BY ID_RDV ASC&quot;;
$qres = jqGridDB::query($conn, $SQL);
// $result = jqGridDB::fetch_assoc($qres,$conn);
$s = &quot;&lt;select&gt;&quot;;
while($result = jqGridDB::fetch_assoc($qres,$conn) ) {
	$s .= &quot;&lt;option&gt;&quot;.$result[&#039;ID_RDV&#039;].&#039;&lt;/option&gt;&#039;;
}
$s .= &quot;&lt;/select&gt;&quot;;
echo $s;
jqGridDB::closeCursor($qres);
&amp;nbsp;

require_once '../../jq-config.php';

// include the jqGrid Class

require_once ABSPATH."php/PHPSuito/jqGridUtils.php";

// include the driver class

require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridPdo.php";

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Tell the db that we use utf-8

jqGridDB::query($conn,"SET NAMES utf8");

$numief = jqGridUtils::GetParam('num_ef');

// Get details

$SQL = "SELECT ID_RDV,ID_RDV FROM drop_ref_rdv WHERE /*your where here/*

ORDER BY ID_RDV ASC";

$qres = jqGridDB::query($conn, $SQL);

// $result = jqGridDB::fetch_assoc($qres,$conn);

$s = "<select>";

while($result = jqGridDB::fetch_assoc($qres,$conn) ) {

$s .= "<option>".$result['ID_RDV'].'</option>';

}

$s .= "</select>";

echo $s;

jqGridDB::closeCursor($qres);

&nbsp;

Hope I understand correct the problem

Kind Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 256 through 270 (of 1,092 total)

← 1 2 3 … 17 18 19 … 71 72 73 →