Guriddo » Topic: Dropdown with filter

Dropdown with filter

Guriddo
dropdown query filter
Dropdown with filter

Tagged: dropdown query filter

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

Creator

Topic
January 21, 2019 at 2:18 pm #127047

Saroumane
Participant

Hi,

I would like to make a dropdown menu with a WHERE clause. The dropdown is populate by a SQL query and the value come from another cell in the row.

How I can keep this value in my query ?

This menu is only used in EDIT mode and the value of the WHERE clause is fixed for each row.

Sorry from my poor english ( I’m french)

Kind Regards

Thierry

Jqgrid PHP 5.1.0
Creator

Topic

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

Author

Replies

January 22, 2019 at 12:44 pm #127048

guriddo.support

Participant

Hello,

As far as I understand the problem you can use dataUrl option as function. In this case you can get the value from the other cell and pass it as parameter to the datUrl.

Here is a demo of this

Look at file detail.php. The related code is like this:


$select = &lt;&lt;&lt;SELECT
function(rowid, value, name) {
	var srow = jQuery(&quot;#grid&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?id_emp=&quot;+gridrow.EmployeeID;
	}
}
SELECT;
$grid-&gt;setColProperty(&quot;EmployeeID&quot;,array(&quot;edittype&quot;=&gt;&quot;select&quot;, &quot;hidden&quot;=&gt;false,&quot;width&quot;=&gt;20,&quot;editoptions&quot;=&gt;array(&quot;dataUrl&quot;=&gt;&quot;js:&quot;.$select)));

$select = <<<SELECT

function(rowid, value, name) {

var srow = jQuery("#grid").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?id_emp="+gridrow.EmployeeID;

}

SELECT;

$grid->setColProperty("EmployeeID",array("edittype"=>"select", "hidden"=>false,"width"=>20,"editoptions"=>array("dataUrl"=>"js:".$select)));

The select.php look like this:

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;);
$empid = jqGridUtils::GetParam(&#039;id_emp&#039;);

// Get details
$SQL = &quot;SELECT * FROM employees WHERE EmployeeID &lt;=&quot;.(int)$empid;
$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;FirstName&#039;].&quot; &quot;.$result[&#039;LastName&#039;].&#039;&lt;/option&gt;&#039;;
}
$s .= &quot;&lt;/select&gt;&quot;;
echo $s;
jqGridDB::closeCursor($qres);

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");

$empid = jqGridUtils::GetParam('id_emp');

// Get details

$SQL = "SELECT * FROM employees WHERE EmployeeID <=".(int)$empid;

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

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

$s = "<select>";

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

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

}

$s .= "</select>";

echo $s;

jqGridDB::closeCursor($qres);

Please let us know if this solves your problem.

Kind Regards,
Will

This reply was modified 7 years, 3 months ago by guriddo.support.

Guriddo Support Team

January 30, 2019 at 7:49 am #127063

Saroumane

Participant

Hello,

I’ve tried to use your solution, but I don’t understand how I need to use it.
Maybe I’ve not correctly explain my problem. I try to explain differently.
Usually with some coffee I pass to solve my problem with your good advice.

My grid is only in EDIT mode, no ADD. When I open the modal EDIT windows, I want to keep the value of the ‘num_ef’ cell. And I want to use this value in the
WHERE clause in the query who populate a dropdown. Below the essential of my actual code.

Thanks for your help,


&lt;!--?php // Load des parametres de connexion require_once &#039;../../tb_l_connect.php&#039;; // Load des Class jqGrid require_once &quot;../../php/PHPSuito/jqGrid.php&quot;; // Load des paramétres PDO pour jqGrid require_once &quot;../../php/PHPSuito/DBdrivers/jqGridPdo.php&quot;; // Connexion au serveur $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); // Déclaration du format UTF-8 de la BDD $conn-&gt;query(&quot;SET NAMES utf8&quot;);&lt;br ?--&gt; // Déclaration de la Class de Datepicker
require_once &quot;../../php/PHPSuito/jqCalendar.php&quot;;
// Tell the db that we use utf-8

mysql_set_charset(&#039;utf8&#039;);
// Connexion au serveur
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Déclaration du format UTF-8 de la BDD
$conn-&gt;query(&quot;SET NAMES utf8&quot;);

// Création d&#039;une instance jqGrid
$grid = new jqGridRender($conn);

// Load de la requête SQL
$grid-&gt;SelectCommand = &quot;
SELECT
&lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;num_interv&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;flag&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;cle_GMAO&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;flotte&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;num_ef&lt;/code&gt;,
&lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;type_di&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;statut_interv&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;lib_interv&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;pos&lt;/code&gt;,
&lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;defaut&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;cote_def&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;ref_RDV&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;semaine&lt;/code&gt;, &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;dt_butee&lt;/code&gt;,
&lt;code&gt;essieu_bte&lt;/code&gt;.num_ef_bte, &lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;WR_bte&lt;/code&gt;, &lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;statut_bte&lt;/code&gt;, &lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;Notes_bte&lt;/code&gt;, &lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;dt_creat&lt;/code&gt;, &lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;dt_gmao&lt;/code&gt;, &lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;dt_real&lt;/code&gt;,
IF(essieu_bte.WR_bte!=&#039;&#039;,&#039;0&#039;,&#039;1&#039;) AS CTRL
FROM &lt;code&gt;grid_essieu_prog&lt;/code&gt; LEFT JOIN &lt;code&gt;essieu_bte&lt;/code&gt; ON &lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;lib_interv&lt;/code&gt;=&lt;code&gt;essieu_bte&lt;/code&gt;.&lt;code&gt;WR_bte&lt;/code&gt; AND (&lt;code&gt;grid_essieu_prog&lt;/code&gt;.&lt;code&gt;num_ef&lt;/code&gt;=&lt;code&gt;essieu_bte&lt;/code&gt;.num_ef_bte)
WHERE essieu_bte.statut_bte =&#039;Confirmé / Initialisé&#039; OR essieu_bte.statut_bte =&#039;En cours&#039; OR essieu_bte.statut_bte =&#039;Ouvert&#039;)
&quot;;

// Déclaration de la table MaJ
$grid-&gt;table = &#039;essieu_interv&#039;;

// Définition d&#039;une clé primaire
$grid-&gt;setPrimaryKeyId(&quot;num_interv&quot;);
$grid-&gt;serialKey = true;

//Déclaration du format d&#039;échange en json
$grid-&gt;dataType = &#039;json&#039;;

// Déclaration du model du grid
$grid-&gt;setColModel();

// Déclaration du fichier origine des données
$grid-&gt;setUrl(&#039;grid_prog.php&#039;);

// Déclaration d&#039;autres options
$grid-&gt;setGridOptions(array(
&quot;caption&quot;=&gt;&quot;programmation&quot;, // Titre du tableau
&quot;rowNum&quot;=&gt;10, // Nombre de lignes par défaut à afficher
&quot;rowList&quot;=&gt;array(20,35,50,70,120), // Déclaration du nombres de lignes affichables
&quot;sortname&quot;=&gt;&quot;num_interv&quot;, // Déclaration du tri par défaut
&quot;sortorder&quot;=&gt;&quot;desc&quot;, // Ordre de tri des lignes
&quot;width&quot;=&gt;&quot;1650&quot;, // Largeur du tableau en px
&quot;loadonce&quot; =&gt;false,
&quot;toppager&quot;=&gt;true,
// &quot;colMenu&quot;=&gt;true,
&quot;height&quot;=&gt;&quot;auto&quot;, // Hauteur automatique du tableau

&quot;hoverrows&quot;=&gt;true // highlight la ligne survolée
));

//*********************************
$grid-&gt;setColProperty(&#039;cle_GMAO&#039;, array( &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;85, &quot;align&quot;=&gt;&quot;center&quot;, &quot;classes&quot;=&gt;&quot;wr&quot;, &quot;editable&quot;=&gt;false));
//$grid-&gt;setColProperty(&#039;flag&#039;, array( &quot;hidden&quot;=&gt;false, &quot;label&quot;=&gt;&quot;Etat&quot;,&quot;width&quot;=&gt;55, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;false));
$grid-&gt;setColProperty(&#039;num_interv&#039;, array( &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;85, &quot;align&quot;=&gt;&quot;center&quot;, &quot;classes&quot;=&gt;&quot;wr&quot;, &quot;editable&quot;=&gt;false));

//$grid-&gt;setColProperty(&#039;num_ef&#039;, array(&quot;label&quot;=&gt;&quot;Engin&quot;, &quot;width&quot;=&gt;50, &quot;align&quot;=&gt;&quot;center&quot;, &quot;classes&quot;=&gt;&quot;wr&quot;, &quot;editoptions&quot;=&gt;array(&quot;readonly&quot;=&gt;true)));
$grid-&gt;setColProperty(&#039;flotte&#039;, array(&quot;label&quot;=&gt;&quot;Flotte&quot;, &quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;50));

$grid-&gt;setColProperty(&#039;num_ef&#039;, array(&quot;label&quot;=&gt;&quot;N° EF&quot;, &quot;width&quot;=&gt;55));

// ****************************************
// --Propriété Champ dropdown
$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 &lt;code&gt;ID_RDV&lt;/code&gt;,&lt;code&gt;ID_RDV&lt;/code&gt; FROM &lt;code&gt;drop_ref_rdv&lt;/code&gt;
ORDER BY &lt;code&gt;ID_RDV&lt;/code&gt; ASC&quot;,false,true,true);

$grid-&gt;setColProperty(&#039;defaut&#039;, array(&quot;label&quot;=&gt;&quot;Déf origine&quot;, &quot;width&quot;=&gt;90, &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;setAutocomplete(&quot;defaut&quot;,false,&quot;SELECT DISTINCT lib_def FROM drop_essieu_def WHERE num_ef LIKE ? ORDER BY lib_def&quot;,null,true,false);

// ****************************************

// --Regroupement de colonnes
$grid-&gt;callGridMethod(&quot;#grid0&quot;, &quot;setGroupHeaders&quot;, array(array(
&quot;useColSpanStyle&quot;=&gt;true,
&quot;groupHeaders&quot;=&gt;array(
array(
&quot;startColumnName&quot;=&gt;&#039;flag&#039;,
&quot;numberOfColumns&quot;=&gt;12,
&quot;titleText&quot;=&gt;&#039;Extract Works Report&#039;
),
array(
&quot;startColumnName&quot;=&gt;&#039;WR_bte&#039;,
&quot;numberOfColumns&quot;=&gt;6,
&quot;titleText&quot;=&gt;&#039;Extract BTE&#039;
)
)
)));

// ****************************************

$grid-&gt;debug = false;
// Configuration du navigateur
$grid-&gt;navigator = true;
// Activation des options d&#039;édition
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true, &quot;pdf&quot;=&gt;true, &quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;true, &quot;search&quot;=&gt;true, &quot;cloneToTop&quot;=&gt;true));
// Fermeture de la fenetre d&#039;édition apres validation
//$grid-&gt;setNavOptions(&#039;add&#039;,array(&quot;closeAfterAdd&quot;=&gt;true, &quot;width&quot;=&gt;600, &quot;left&quot;=&gt;300, &quot;dataheight&quot;=&gt;375, &quot;height&quot;=&gt;450, &quot;top&quot;=&gt;250, &quot;editCaption&quot;=&gt;&quot;Ajout&quot;,&quot;bSubmit&quot;=&gt;&quot;Ajouter&quot;, &quot;viewPagerButtons&quot;=&gt;false));

$grid-&gt;setNavOptions(&#039;edit&#039;,array(&quot;closeAfterEdit&quot;=&gt;true,&quot;width&quot;=&gt;600, &quot;left&quot;=&gt;300, &quot;dataheight&quot;=&gt;475, &quot;height&quot;=&gt;550, &quot;top&quot;=&gt;250, &quot;editCaption&quot;=&gt;&quot;Modification&quot;,&quot;bSubmit&quot;=&gt;&quot;MAJ&quot;, &quot;viewPagerButtons&quot;=&gt;false));
$grid-&gt;setNavOptions(&#039;search&#039;,array(&quot;multipleSearch&quot;=&gt;true, &quot;uniqueSearch&quot;=&gt;true, &quot;uniqueSearchFields&quot;=&gt;true));

$grid-&gt;renderGrid(&#039;#grid0&#039;,&#039;#pager&#039;,true, null, null, true,true);

$conn = null;

?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

// Déclaration de la Class de Datepicker

require_once "../../php/PHPSuito/jqCalendar.php";

// Tell the db that we use utf-8

mysql_set_charset('utf8');

// Connexion au serveur

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

// Déclaration du format UTF-8 de la BDD

$conn->query("SET NAMES utf8");

// Création d'une instance jqGrid

$grid = new jqGridRender($conn);

// Load de la requête SQL

$grid->SelectCommand = "

SELECT

<code>grid_essieu_prog</code>.<code>num_interv</code>, <code>grid_essieu_prog</code>.<code>flag</code>, <code>grid_essieu_prog</code>.<code>cle_GMAO</code>, <code>grid_essieu_prog</code>.<code>flotte</code>, <code>grid_essieu_prog</code>.<code>num_ef</code>,

<code>grid_essieu_prog</code>.<code>type_di</code>, <code>grid_essieu_prog</code>.<code>statut_interv</code>, <code>grid_essieu_prog</code>.<code>lib_interv</code>, <code>grid_essieu_prog</code>.<code>pos</code>,

<code>grid_essieu_prog</code>.<code>defaut</code>, <code>grid_essieu_prog</code>.<code>cote_def</code>, <code>grid_essieu_prog</code>.<code>ref_RDV</code>, <code>grid_essieu_prog</code>.<code>semaine</code>, <code>grid_essieu_prog</code>.<code>dt_butee</code>,

<code>essieu_bte</code>.num_ef_bte, <code>essieu_bte</code>.<code>WR_bte</code>, <code>essieu_bte</code>.<code>statut_bte</code>, <code>essieu_bte</code>.<code>Notes_bte</code>, <code>essieu_bte</code>.<code>dt_creat</code>, <code>essieu_bte</code>.<code>dt_gmao</code>, <code>essieu_bte</code>.<code>dt_real</code>,

IF(essieu_bte.WR_bte!='','0','1') AS CTRL

FROM <code>grid_essieu_prog</code> LEFT JOIN <code>essieu_bte</code> ON <code>grid_essieu_prog</code>.<code>lib_interv</code>=<code>essieu_bte</code>.<code>WR_bte</code> AND (<code>grid_essieu_prog</code>.<code>num_ef</code>=<code>essieu_bte</code>.num_ef_bte)

WHERE essieu_bte.statut_bte ='Confirmé / Initialisé' OR essieu_bte.statut_bte ='En cours' OR essieu_bte.statut_bte ='Ouvert')

// Déclaration de la table MaJ

$grid->table = 'essieu_interv';

// Définition d'une clé primaire

$grid->setPrimaryKeyId("num_interv");

$grid->serialKey = true;

//Déclaration du format d'échange en json

$grid->dataType = 'json';

// Déclaration du model du grid

$grid->setColModel();

// Déclaration du fichier origine des données

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

// Déclaration d'autres options

$grid->setGridOptions(array(

"caption"=>"programmation", // Titre du tableau

"rowNum"=>10, // Nombre de lignes par défaut à afficher

"rowList"=>array(20,35,50,70,120), // Déclaration du nombres de lignes affichables

"sortname"=>"num_interv", // Déclaration du tri par défaut

"sortorder"=>"desc", // Ordre de tri des lignes

"width"=>"1650", // Largeur du tableau en px

"loadonce" =>false,

"toppager"=>true,

// "colMenu"=>true,

"height"=>"auto", // Hauteur automatique du tableau

"hoverrows"=>true // highlight la ligne survolée

));

//*********************************

$grid->setColProperty('cle_GMAO', array( "hidden"=>true, "width"=>85, "align"=>"center", "classes"=>"wr", "editable"=>false));

//$grid->setColProperty('flag', array( "hidden"=>false, "label"=>"Etat","width"=>55, "align"=>"center", "editable"=>false));

$grid->setColProperty('num_interv', array( "hidden"=>true, "width"=>85, "align"=>"center", "classes"=>"wr", "editable"=>false));

//$grid->setColProperty('num_ef', array("label"=>"Engin", "width"=>50, "align"=>"center", "classes"=>"wr", "editoptions"=>array("readonly"=>true)));

$grid->setColProperty('flotte', array("label"=>"Flotte", "align"=>"center", "width"=>50));

$grid->setColProperty('num_ef', array("label"=>"N° EF", "width"=>55));

// ****************************************

// --Propriété Champ dropdown

$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 <code>ID_RDV</code>,<code>ID_RDV</code> FROM <code>drop_ref_rdv</code>

ORDER BY <code>ID_RDV</code> ASC",false,true,true);

$grid->setColProperty('defaut', array("label"=>"Déf origine", "width"=>90, "editable"=>true,"align"=>"center", "classes"=>"wr", "editrules"=>array("required"=>false)));

$grid->setAutocomplete("defaut",false,"SELECT DISTINCT lib_def FROM drop_essieu_def WHERE num_ef LIKE ? ORDER BY lib_def",null,true,false);

// ****************************************

// --Regroupement de colonnes

$grid->callGridMethod("#grid0", "setGroupHeaders", array(array(

"useColSpanStyle"=>true,

"groupHeaders"=>array(

array(

"startColumnName"=>'flag',

"numberOfColumns"=>12,

"titleText"=>'Extract Works Report'

array(

"startColumnName"=>'WR_bte',

"numberOfColumns"=>6,

"titleText"=>'Extract BTE'

)

)));

// ****************************************

$grid->debug = false;

// Configuration du navigateur

$grid->navigator = true;

// Activation des options d'édition

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

// Fermeture de la fenetre d'édition apres validation

//$grid->setNavOptions('add',array("closeAfterAdd"=>true, "width"=>600, "left"=>300, "dataheight"=>375, "height"=>450, "top"=>250, "editCaption"=>"Ajout","bSubmit"=>"Ajouter", "viewPagerButtons"=>false));

$grid->setNavOptions('edit',array("closeAfterEdit"=>true,"width"=>600, "left"=>300, "dataheight"=>475, "height"=>550, "top"=>250, "editCaption"=>"Modification","bSubmit"=>"MAJ", "viewPagerButtons"=>false));

$grid->setNavOptions('search',array("multipleSearch"=>true, "uniqueSearch"=>true, "uniqueSearchFields"=>true));

$grid->renderGrid('#grid0','#pager',true, null, null, true,true);

$conn = null;

Jqgrid PHP 5.1.0

January 30, 2019 at 11:56 am #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 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Dropdown with filter

Search Forum

Recent Replies

Forum Statistics

UserOnline