Guriddo » Topic: Problem with dependent dropdown.

Problem with dependent dropdown.

Guriddo
Problem with dependent dropdown.

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

Creator

Topic

August 18, 2015 at 2:08 pm #124221

Saroumane

Participant

Hello,

I use a grid with one dependent dropdowns in a form edit mode. The dropdowns works very well, and it’s OK in the create mode . But a I have a problem in edit mode. When my users come back to the grid for modify a row, in the edit form , the second dropdown (the dependent) do not reload the previous value. The second dropdown displayed “Select”.
How I can force the reload the previous value for the second dropdown ? or it’s a limit of jqgrid ?

(sorry for my english, I’m french)

Thank,

Kind Regard

THE PRINCIPAL GRID:

&lt;!--?php// Load des parametres de connexion require_once &#039;../rex_at-config.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;; require_once &quot;../../php/PHPSuito/External/tcpdf/config/lang/fra.php&quot;; 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;);&lt;/p&gt; &lt;p&gt; // Création d&#039;une instance jqGrid&lt;br ?--&gt; $grid = new jqGridRender($conn);

// Parametrage de l&#039;export CSV
$grid-&gt;setCsvOptions(array(&quot;separator&quot; =&gt;&quot;,&quot;,&quot;file&quot; =&gt;&quot;mycsvfile.csv&quot;));

// Activation du mode debug
$grid-&gt;debug = false;

// Load de la requête SQL
$grid-&gt;SelectCommand = &quot; SELECT id_at, type, date_at, uo_poles, unites, description, commentaires, nom, prenom, CP, jeune_embauche, arret, duree_arret, code1, code2, lesion, siege, epi, DPA_trait, DPA_valid FROM rex_at&quot;;

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

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

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

// Déclaration du model du grid
$grid-&gt;setColModel();
// Déclaration du fichier de chargement de données
$grid-&gt;setUrl(&#039;grid_rex_at.php&#039;);

// Déclaration d&#039;autres options
$grid-&gt;setGridOptions(array(
&quot;caption&quot;=&gt;&quot;Saisie REX des AT TMV&quot;, // Titre du tableau
&quot;rowNum&quot;=&gt;15, // Nombre de lignes par défaut à afficher
&quot;rowList&quot;=&gt;array(20,35,50), // Déclaration du nombres de lignes affichables
&quot;sortname&quot;=&gt;&quot;date_at&quot;, // Déclaration du tri par défaut
&quot;sortorder&quot;=&gt;&quot;desc&quot;,
&quot;width&quot;=&gt;1900,
&quot;height&quot;=&gt;&quot;Auto&quot;, // Hauteur automatique du tableau
&quot;hoverrows&quot;=&gt;true // highlight la ligne survolée
));

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

// Règle d&#039;édition des champs par défaut

$grid-&gt;setColProperty(&#039;id_at&#039;, array(&quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;type&#039;, array(&quot;label&quot;=&gt;&quot;Type&quot;, &quot;width&quot;=&gt;70, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;uo_poles&#039;, array(&quot;label&quot;=&gt;&quot;UO/Pôles&quot;, &quot;width&quot;=&gt;90, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;unites&#039;, array(&quot;label&quot;=&gt;&quot;Unités&quot;, &quot;width&quot;=&gt;90, &quot;align&quot;=&gt;&quot;left&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;nom&#039;, array(&quot;label&quot;=&gt;&quot;Nom&quot;, &quot;width&quot;=&gt;90, &quot;align&quot;=&gt;&quot;left&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;prenom&#039;, array(&quot;label&quot;=&gt;&quot;Prénom&quot;, &quot;width&quot;=&gt;70, &quot;align&quot;=&gt;&quot;left&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;CP&#039;, array(&quot;label&quot;=&gt;&quot;Num CP&quot;, &quot;width&quot;=&gt;60, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;jeune_embauche&#039;, array(&quot;label&quot;=&gt;&quot;J-emb&quot;, &quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;40, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;arret&#039;, array(&quot;label&quot;=&gt;&quot;Arrêt&quot;, &quot;width&quot;=&gt;25, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;lesion&#039;, array(&quot;label&quot;=&gt;&quot;Lésion&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;duree_arret&#039;,array(&quot;label&quot;=&gt;&quot;Durée arrêt&quot;, &quot;width&quot;=&gt;60, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true,&quot;formatter&quot;=&gt;&quot;integer&quot;, &quot;formatoptions&quot;=&gt;array(&quot;suffix&quot;=&gt;&quot; jours&quot;)));
$grid-&gt;setColProperty(&#039;siege&#039;, array(&quot;label&quot;=&gt;&quot;Siège&quot;, &quot;width&quot;=&gt;40, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;epi&#039;, array(&quot;label&quot;=&gt;&quot;EPI&quot;, &quot;width&quot;=&gt;20, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;code1&#039;, array(&quot;label&quot;=&gt;&quot;Codage N1&quot;, &quot;width&quot;=&gt;110, &quot;align&quot;=&gt;&quot;left&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;code2&#039;, array(&quot;label&quot;=&gt;&quot;Codage N2&quot;, &quot;width&quot;=&gt;110, &quot;align&quot;=&gt;&quot;left&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;DPA_trait&#039;, array(&quot;label&quot;=&gt;&quot;Traite DPA&quot;, &quot;width&quot;=&gt;50, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true, &quot;formatter&quot;=&gt;&quot;integer&quot;, &quot;formatoptions&quot;=&gt;array(&quot;suffix&quot;=&gt;&quot; jours&quot;)));
$grid-&gt;setColProperty(&#039;DPA_valid&#039;, array(&quot;label&quot;=&gt;&quot;Valid DPA&quot;, &quot;width&quot;=&gt;50, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true, &quot;formatter&quot;=&gt;&quot;integer&quot;, &quot;formatoptions&quot;=&gt;array(&quot;suffix&quot;=&gt;&quot; jours&quot;)));
$grid-&gt;setColProperty(&#039;code2&#039;, array(&quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot; :Select&quot;)));

// &quot;editoptions&quot;=&gt;array(&quot;size&quot;=&gt;15), Nb de lignes affichées simultanément

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

// Champ en zone de texte

$grid-&gt;setColProperty(&#039;description&#039;, array(&quot;label&quot;=&gt;&quot;Description&quot;, &quot;edittype&quot;=&gt; &#039;textarea&#039;,&quot;editoptions&quot;=&gt;array(&quot;rows&quot;=&gt;4, &quot;cols&quot;=&gt;50, &quot;maxlength&quot;=&gt;255, &quot;width&quot;=&gt;120), &quot;width&quot;=&gt;200, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;commentaires&#039;, array(&quot;label&quot;=&gt;&quot;Commentaires&quot;, &quot;edittype&quot;=&gt; &#039;textarea&#039;,&quot;editoptions&quot;=&gt;array(&quot;rows&quot;=&gt;4, &quot;cols&quot;=&gt;50, &quot;maxlength&quot;=&gt;255, &quot;width&quot;=&gt;120), &quot;width&quot;=&gt;100, &quot;editable&quot;=&gt;true));

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

// règle d&#039;édition des champs dropdown
$grid-&gt;setSelect(&quot;type&quot;, &quot;SELECT champ_type, champ_type FROM drop_type_at ORDER BY champ_type ASC&quot;,false,true,true);
//$grid-&gt;setSelect(&quot;uo_poles&quot;, &quot;SELECT &lt;code&gt;code_N1&lt;/code&gt;,&lt;code&gt;code_N1&lt;/code&gt; FROM &lt;code&gt;drop_cause_at_n1&lt;/code&gt; ORDER BY &lt;code&gt;code_N1&lt;/code&gt; ASC&quot;,false,true,true);
$grid-&gt;setSelect(&quot;uo_poles&quot;, &quot;SELECT pole, pole FROM menu_pole ORDER BY pole ASC&quot;,false,true,true);

$grid-&gt;setSelect(&quot;unites&quot;, &quot;SELECT unite, unite FROM &lt;code&gt;menu_unite&lt;/code&gt; ORDER BY &lt;code&gt;unite&lt;/code&gt; ASC &quot;,false,true,true);
$grid-&gt;setSelect(&quot;code1&quot;, &quot;SELECT &lt;code&gt;code_N1&lt;/code&gt;,&lt;code&gt;code_N1&lt;/code&gt; FROM &lt;code&gt;drop_cause_at_n1&lt;/code&gt; ORDER BY &lt;code&gt;code_N1&lt;/code&gt; ASC &quot;,false,true,true);
$grid-&gt;setSelect(&quot;lesion&quot;, &quot;SELECT &lt;code&gt;lesion&lt;/code&gt;,&lt;code&gt;lesion&lt;/code&gt; FROM &lt;code&gt;drop_lesion&lt;/code&gt; ORDER BY &lt;code&gt;lesion&lt;/code&gt; ASC&quot;,false,true,true);
$grid-&gt;setSelect(&quot;siege&quot;, &quot;SELECT &lt;code&gt;siege&lt;/code&gt;,&lt;code&gt;siege&lt;/code&gt; FROM &lt;code&gt;drop_siege&lt;/code&gt; ORDER BY &lt;code&gt;siege&lt;/code&gt; ASC&quot;,false,true,true);

$grid-&gt;setSelect(&quot;jeune_embauche&quot;, &quot;SELECT Choix,Choix FROM drop_choix_o_n ORDER BY Choix ASC&quot;,false,true,true);
$grid-&gt;setSelect(&quot;arret&quot;, &quot;SELECT Choix,Choix FROM drop_choix_o_n ORDER BY Choix ASC&quot;,false,true,true);
$grid-&gt;setSelect(&quot;epi&quot;, &quot;SELECT Choix,Choix FROM drop_choix_o_n ORDER BY Choix ASC&quot;,false,true,true);

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

// Option d&#039;édition Time datepicker
$grid-&gt;setColProperty(&#039;date_at&#039;,
array(&quot;label&quot;=&gt;&quot;Date événement&quot;,&quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;100,&quot;formatter&quot;=&gt;&quot;date&quot;,
&quot;formatoptions&quot;=&gt;array(&quot;reformatAfterEdit&quot;=&gt;true, &quot;srcformat&quot;=&gt;&quot;Y-m-d H:i:s&quot;, &quot;newformat&quot;=&gt;&quot;d/m/Y H:i&quot;),
// Ok. We use some trick here to create the datepicker on dataInit event
// when the element is created. Note the js: before the function.
// this instruct the grid to put a javascript code without additional formating
&quot;editoptions&quot;=&gt;array(&quot;dataInit&quot;=&gt;
&quot;js:function(elm){setTimeout(function(){
jQuery(elm).datetimepicker({dateFormat:&#039;dd/mm/yy&#039;});
jQuery(&#039;.ui-datepicker&#039;).css({&#039;font-size&#039;:&#039;75%&#039;});
},0);}&quot;)
));
$grid-&gt;setDbTime(&#039;Y-m-d H:i:s&#039;);
$grid-&gt;setUserTime(&quot;d/m/Y H:i&quot;);

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

// Fonction de génération des menus déroulants en cascade

$beforeshow = &lt;&lt;&lt; BEFORESHOW
function(formid)
{
// recupère la valeur du premier dropdown

var cntryval = $(&quot;#code1&quot;,formid).val();
jQuery(&quot;#code2&quot;,formid).html(&quot;Select&quot;);
if(cntryval) {
//
// associe au résultat du fichier JSON JSON_codeN2.php
//
jQuery.ajax({
url: &#039;JSON_codeN2.php&#039;,
dataType: &#039;json&#039;,
data: {q:cntryval},
success : function(response)
{
var t=&quot;&quot;, sv=&quot;&quot;;
var sr = jQuery(&quot;#grid&quot;).jqGrid(&#039;getGridParam&#039;,&#039;selrow&#039;);
if(sr)
{
// sélectionne les causes présente dans le tableau

sv = jQuery(&quot;#code2&quot;).jqGrid(&#039;getCell&#039;,sr,&#039;code1&#039;);
jQuery.each(response, function(i,item) {
t += &quot;&quot;+item.value+&quot;&quot;;
});

// vide le select et remplace par la nouvelle selection

jQuery(&quot;#code2&quot;,formid).html(&quot;&quot;).append(t);
if(sv)
{

// recupere la valeur du second dropdown

jQuery(&quot;#code2&quot;,formid).val(sv).removeAttr(&quot;disabled&quot;);
}
}
}
});
} else {
jQuery(&quot;#code2&quot;,formid).attr(&quot;disabled&quot;,&quot;disabled&quot;);
}
}
BEFORESHOW;

// Avec cet événement nous lions un changement au niveau du premier dropdown
// Si une nouvelle valeur est choisi, nous faisons un appel AJAX pour avoir les valeurs du second dropdown lié au premier
// Notez que cet événement doit être exécutée une seule fois si le formulaire est construit.

$initform = &lt;&lt;&lt; INITFORM
function(formid)
{
jQuery(&quot;#code1&quot;,formid).change(function(e) {
var cntryval = $(this).val();
if(cntryval) {
jQuery(&quot;#code2&quot;,formid).html(&quot;&quot;);
jQuery.ajax({
url: &#039;JSON_codeN2.php&#039;,
dataType: &#039;json&#039;,
data: {q:cntryval},
success : function(response)
{
var t=&quot;&quot;;
jQuery.each(response, function(i,item) {
t += &quot;&quot;+item.value+&quot;&quot;;
});
jQuery(&quot;#code2&quot;,formid).append(t).removeAttr(&quot;disabled&quot;);
}
});
}
});
}
INITFORM;

// ***************** Fin du script des menus en cascade ***********************

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

// Configuration du navigateur
$grid-&gt;navigator = true; // Activer le navigateur CRUD
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;pdf&quot;=&gt;true,&quot;add&quot;=&gt;true,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;true, &quot;search&quot;=&gt;true)); // Déclaration des options de la barre des tâches CRUD
$grid-&gt;setNavOptions(&#039;edit&#039;, array(&quot;height&quot;=&gt;&#039;auto&#039;,&quot;dataheight&quot;=&gt;&quot;auto&quot;,&quot;width&quot;=&gt;&#039;auto&#039;,&quot;closeAfterEdit&quot; =&gt; true)); // Paramètre du formulaire d&#039;édition
$grid-&gt;setNavOptions(&#039;add&#039;, array(&quot;addCaption&quot;=&gt;&quot;Nouvelle fiche retard&quot;,&quot;closeAfterAdd&quot;=&gt;true,&quot;height&quot;=&gt;&#039;auto&#039;,&quot;dataheight&quot;=&gt;&quot;auto&quot;,&quot;width&quot;=&gt;&#039;auto&#039;)); // Paramètre du formulaire de création

// Initialisation des fonctions des menu en cascade.

// Lie la fonction &quot;$beforeshow&quot; à l&#039;événement &quot;avant l&#039;ouverture du formulaire&quot; en mode ajout et modif
$grid-&gt;setNavEvent(&#039;edit&#039;, &#039;beforeShowForm&#039;, $beforeshow);
$grid-&gt;setNavEvent(&#039;add&#039;, &#039;beforeShowForm&#039;, $beforeshow);
// Lie la fonction &quot;$initform&quot; à l&#039;événement &quot;à l&#039;initialisation du formulaire&quot; en mode ajout et modif
$grid-&gt;setNavEvent(&#039;edit&#039;, &#039;onInitializeForm&#039;, $initform);
$grid-&gt;setNavEvent(&#039;add&#039;, &#039;onInitializeForm&#039;, $initform);

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

// Parametrage des export Excel et PDF
$grid-&gt;exportfile = &#039;Export_retard_tmv.xls&#039;; // Définition du nom du fichier d&#039;export Excel

$oper = jqGridUtils::GetParam(&quot;oper&quot;); // Parametre d&#039;exportation PDF
if($oper == &quot;pdf&quot;) {
$grid-&gt;setPdfOptions(array(

&quot;page_orientation&quot;=&gt;&quot;L&quot;, // Orientation de la page en paysage &quot;L&quot; ou portrait &quot;P&quot;
&quot;header&quot;=&gt;true, // Activation d&#039;un entête
&quot;margin_top&quot;=&gt;20, // Déclaration d&#039;une en-tete de haut de page
&quot;margin_bottom&quot;=&gt;0, // Déclaration d&#039;une en-tete de bas de page
&quot;margin_footer&quot;=&gt;5,
&quot;header_logo&quot;=&gt;&quot;logo.gif&quot;, // Nom d&#039;un logo dans répertioire PDF php/ tcpdf
&quot;header_logo_width&quot;=&gt;20, //Déclaration de la largeur du logo
&quot;header_title&quot;=&gt;&quot;Export retard sortie de site&quot;, // Titre de l&#039;en-tête
&quot;shrink_cell&quot;=&gt;false, // Activation/Desactivation du tassement des valeurs
&quot;encoding&quot; =&gt; &quot;UTF-8&quot;, // Encodage UTF-8
&quot;reprint_grid_header&quot;=&gt;true, // Affichage des titres de colonnes sur chaque page
&quot;header_string&quot;=&gt;&quot;Technicentre de Villeneuve&quot; // Texte d&#039;en-tête à imprimer

));
}
//*********************************

// Paramètre de rendu du Grid
$grid-&gt;renderGrid(&#039;#test1&#039;,&#039;#pager&#039;,true, null, null, true,true);

?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

$grid = new jqGridRender($conn);

// Parametrage de l'export CSV

$grid->setCsvOptions(array("separator" =>",","file" =>"mycsvfile.csv"));

// Activation du mode debug

$grid->debug = false;

// Load de la requête SQL

$grid->SelectCommand = " SELECT id_at, type, date_at, uo_poles, unites, description, commentaires, nom, prenom, CP, jeune_embauche, arret, duree_arret, code1, code2, lesion, siege, epi, DPA_trait, DPA_valid FROM rex_at";

// Déclaration de la table MaJ

$grid->table = 'rex_at';

// Définition d'une clé primaire

$grid->setPrimaryKeyId('id_at');

$grid->serialKey = false;

//Déclaration du format d'échange

$grid->dataType = 'json';

// Déclaration du model du grid

$grid->setColModel();

// Déclaration du fichier de chargement de données

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

// Déclaration d'autres options

$grid->setGridOptions(array(

"caption"=>"Saisie REX des AT TMV", // Titre du tableau

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

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

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

"sortorder"=>"desc",

"width"=>1900,

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

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

));

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

// Règle d'édition des champs par défaut

$grid->setColProperty('id_at', array("hidden"=>true));

$grid->setColProperty('type', array("label"=>"Type", "width"=>70, "align"=>"center", "editable"=>true));

$grid->setColProperty('uo_poles', array("label"=>"UO/Pôles", "width"=>90, "align"=>"center", "editable"=>true));

$grid->setColProperty('unites', array("label"=>"Unités", "width"=>90, "align"=>"left", "editable"=>true));

$grid->setColProperty('nom', array("label"=>"Nom", "width"=>90, "align"=>"left", "editable"=>true));

$grid->setColProperty('prenom', array("label"=>"Prénom", "width"=>70, "align"=>"left", "editable"=>true));

$grid->setColProperty('CP', array("label"=>"Num CP", "width"=>60, "align"=>"center", "editable"=>true));

$grid->setColProperty('jeune_embauche', array("label"=>"J-emb", "align"=>"center", "width"=>40, "editable"=>true));

$grid->setColProperty('arret', array("label"=>"Arrêt", "width"=>25, "align"=>"center", "editable"=>true));

$grid->setColProperty('lesion', array("label"=>"Lésion", "width"=>60, "editable"=>true));

$grid->setColProperty('duree_arret',array("label"=>"Durée arrêt", "width"=>60, "align"=>"center", "editable"=>true,"formatter"=>"integer", "formatoptions"=>array("suffix"=>" jours")));

$grid->setColProperty('siege', array("label"=>"Siège", "width"=>40, "align"=>"center", "editable"=>true));

$grid->setColProperty('epi', array("label"=>"EPI", "width"=>20, "align"=>"center", "editable"=>true));

$grid->setColProperty('code1', array("label"=>"Codage N1", "width"=>110, "align"=>"left", "editable"=>true));

$grid->setColProperty('code2', array("label"=>"Codage N2", "width"=>110, "align"=>"left", "editable"=>true));

$grid->setColProperty('DPA_trait', array("label"=>"Traite DPA", "width"=>50, "align"=>"center", "editable"=>true, "formatter"=>"integer", "formatoptions"=>array("suffix"=>" jours")));

$grid->setColProperty('DPA_valid', array("label"=>"Valid DPA", "width"=>50, "align"=>"center", "editable"=>true, "formatter"=>"integer", "formatoptions"=>array("suffix"=>" jours")));

$grid->setColProperty('code2', array("edittype"=>"select", "editoptions"=>array("value"=>" :Select")));

// "editoptions"=>array("size"=>15), Nb de lignes affichées simultanément

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

// Champ en zone de texte

$grid->setColProperty('description', array("label"=>"Description", "edittype"=> 'textarea',"editoptions"=>array("rows"=>4, "cols"=>50, "maxlength"=>255, "width"=>120), "width"=>200, "editable"=>true));

$grid->setColProperty('commentaires', array("label"=>"Commentaires", "edittype"=> 'textarea',"editoptions"=>array("rows"=>4, "cols"=>50, "maxlength"=>255, "width"=>120), "width"=>100, "editable"=>true));

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

// règle d'édition des champs dropdown

$grid->setSelect("type", "SELECT champ_type, champ_type FROM drop_type_at ORDER BY champ_type ASC",false,true,true);

//$grid->setSelect("uo_poles", "SELECT <code>code_N1</code>,<code>code_N1</code> FROM <code>drop_cause_at_n1</code> ORDER BY <code>code_N1</code> ASC",false,true,true);

$grid->setSelect("uo_poles", "SELECT pole, pole FROM menu_pole ORDER BY pole ASC",false,true,true);

$grid->setSelect("unites", "SELECT unite, unite FROM <code>menu_unite</code> ORDER BY <code>unite</code> ASC ",false,true,true);

$grid->setSelect("code1", "SELECT <code>code_N1</code>,<code>code_N1</code> FROM <code>drop_cause_at_n1</code> ORDER BY <code>code_N1</code> ASC ",false,true,true);

$grid->setSelect("lesion", "SELECT <code>lesion</code>,<code>lesion</code> FROM <code>drop_lesion</code> ORDER BY <code>lesion</code> ASC",false,true,true);

$grid->setSelect("siege", "SELECT <code>siege</code>,<code>siege</code> FROM <code>drop_siege</code> ORDER BY <code>siege</code> ASC",false,true,true);

$grid->setSelect("jeune_embauche", "SELECT Choix,Choix FROM drop_choix_o_n ORDER BY Choix ASC",false,true,true);

$grid->setSelect("arret", "SELECT Choix,Choix FROM drop_choix_o_n ORDER BY Choix ASC",false,true,true);

$grid->setSelect("epi", "SELECT Choix,Choix FROM drop_choix_o_n ORDER BY Choix ASC",false,true,true);

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

// Option d'édition Time datepicker

$grid->setColProperty('date_at',

array("label"=>"Date événement","align"=>"center", "width"=>100,"formatter"=>"date",

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

// Ok. We use some trick here to create the datepicker on dataInit event

// when the element is created. Note the js: before the function.

// this instruct the grid to put a javascript code without additional formating

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

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

jQuery(elm).datetimepicker({dateFormat:'dd/mm/yy'});

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

},0);}")

));

$grid->setDbTime('Y-m-d H:i:s');

$grid->setUserTime("d/m/Y H:i");

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

// Fonction de génération des menus déroulants en cascade

$beforeshow = <<< BEFORESHOW

function(formid)

{

// recupère la valeur du premier dropdown

var cntryval = $("#code1",formid).val();

jQuery("#code2",formid).html("Select");

if(cntryval) {

// associe au résultat du fichier JSON JSON_codeN2.php

jQuery.ajax({

url: 'JSON_codeN2.php',

dataType: 'json',

data: {q:cntryval},

success : function(response)

{

var t="", sv="";

var sr = jQuery("#grid").jqGrid('getGridParam','selrow');

if(sr)

{

// sélectionne les causes présente dans le tableau

sv = jQuery("#code2").jqGrid('getCell',sr,'code1');

jQuery.each(response, function(i,item) {

t += ""+item.value+"";

});

// vide le select et remplace par la nouvelle selection

jQuery("#code2",formid).html("").append(t);

if(sv)

{

// recupere la valeur du second dropdown

jQuery("#code2",formid).val(sv).removeAttr("disabled");

}

});

} else {

jQuery("#code2",formid).attr("disabled","disabled");

}

BEFORESHOW;

// Avec cet événement nous lions un changement au niveau du premier dropdown

// Si une nouvelle valeur est choisi, nous faisons un appel AJAX pour avoir les valeurs du second dropdown lié au premier

// Notez que cet événement doit être exécutée une seule fois si le formulaire est construit.

$initform = <<< INITFORM

function(formid)

{

jQuery("#code1",formid).change(function(e) {

var cntryval = $(this).val();

if(cntryval) {

jQuery("#code2",formid).html("");

jQuery.ajax({

url: 'JSON_codeN2.php',

dataType: 'json',

data: {q:cntryval},

success : function(response)

{

var t="";

jQuery.each(response, function(i,item) {

t += ""+item.value+"";

});

jQuery("#code2",formid).append(t).removeAttr("disabled");

}

});

}

});

}

INITFORM;

// ***************** Fin du script des menus en cascade ***********************

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

// Configuration du navigateur

$grid->navigator = true; // Activer le navigateur CRUD

$grid->setNavOptions('navigator', array("excel"=>true,"pdf"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true, "search"=>true)); // Déclaration des options de la barre des tâches CRUD

$grid->setNavOptions('edit', array("height"=>'auto',"dataheight"=>"auto","width"=>'auto',"closeAfterEdit" => true)); // Paramètre du formulaire d'édition

$grid->setNavOptions('add', array("addCaption"=>"Nouvelle fiche retard","closeAfterAdd"=>true,"height"=>'auto',"dataheight"=>"auto","width"=>'auto')); // Paramètre du formulaire de création

// Initialisation des fonctions des menu en cascade.

// Lie la fonction "$beforeshow" à l'événement "avant l'ouverture du formulaire" en mode ajout et modif

$grid->setNavEvent('edit', 'beforeShowForm', $beforeshow);

$grid->setNavEvent('add', 'beforeShowForm', $beforeshow);

// Lie la fonction "$initform" à l'événement "à l'initialisation du formulaire" en mode ajout et modif

$grid->setNavEvent('edit', 'onInitializeForm', $initform);

$grid->setNavEvent('add', 'onInitializeForm', $initform);

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

// Parametrage des export Excel et PDF

$grid->exportfile = 'Export_retard_tmv.xls'; // Définition du nom du fichier d'export Excel

$oper = jqGridUtils::GetParam("oper"); // Parametre d'exportation PDF

if($oper == "pdf") {

$grid->setPdfOptions(array(

"page_orientation"=>"L", // Orientation de la page en paysage "L" ou portrait "P"

"header"=>true, // Activation d'un entête

"margin_top"=>20, // Déclaration d'une en-tete de haut de page

"margin_bottom"=>0, // Déclaration d'une en-tete de bas de page

"margin_footer"=>5,

"header_logo"=>"logo.gif", // Nom d'un logo dans répertioire PDF php/ tcpdf

"header_logo_width"=>20, //Déclaration de la largeur du logo

"header_title"=>"Export retard sortie de site", // Titre de l'en-tête

"shrink_cell"=>false, // Activation/Desactivation du tassement des valeurs

"encoding" => "UTF-8", // Encodage UTF-8

"reprint_grid_header"=>true, // Affichage des titres de colonnes sur chaque page

"header_string"=>"Technicentre de Villeneuve" // Texte d'en-tête à imprimer

));

}

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

// Paramètre de rendu du Grid

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

THE JSON PHP PAGE:

&lt;?php
header(&#039;Content-Type: text/html; charset=utf-8&#039;);
require_once &#039;../rex_at-config.php&#039;;
// Load des Class jqGrid
//require_once &quot;php/jqGrid.php&quot;;
// Load des paramétres PDO pour jqGrid
require_once &quot;../../php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;

//$country = &quot;Manipulation d&#039;objets au cours du travail&quot;;
$country = $_GET[&#039;q&#039;];
if($country){
try {
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
$SQL = &quot;SELECT DISTINCT(cause_detail) id, cause_detail value FROM menu_cause WHERE Imputation=&#039;&quot;.$country.&quot;&#039; ORDER BY cause_detail&quot;;

//$SQL = &quot;SELECT DISTINCT(City) id, City value FROM customers WHERE Country=&#039;&quot;.$country.&quot;&#039; ORDER BY City&quot;;
$collation = jqGridDB::query($conn, &quot;SET NAMES utf8&quot;);
$city = jqGridDB::query($conn, $SQL);
$result = jqGridDB::fetch_object($city, true, $conn);
echo json_encode($result);
} catch (Exception $e) {
echo $e-&gt;getMessage();
}
}
?&gt;

<?php

header('Content-Type: text/html; charset=utf-8');

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

// Load des Class jqGrid

//require_once "php/jqGrid.php";

// Load des paramétres PDO pour jqGrid

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

//$country = "Manipulation d'objets au cours du travail";

$country = $_GET['q'];

if($country){

try {

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

$SQL = "SELECT DISTINCT(cause_detail) id, cause_detail value FROM menu_cause WHERE Imputation='".$country."' ORDER BY cause_detail";

//$SQL = "SELECT DISTINCT(City) id, City value FROM customers WHERE Country='".$country."' ORDER BY City";

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

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

$result = jqGridDB::fetch_object($city, true, $conn);

echo json_encode($result);

} catch (Exception $e) {

echo $e->getMessage();

}

This topic was modified 10 years, 8 months ago by Saroumane.
This topic was modified 10 years, 8 months ago by Saroumane.
This topic was modified 10 years, 8 months ago by tony. Reason: formatting code

Jqgrid PHP 5.1.0

Creator

Topic

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

Author

Replies

August 20, 2015 at 4:42 pm #124260

tony

Keymaster

Hello,

Sorry for the late answer.

Please check what you have with this line in the code in beforeShow

...
sv = jQuery(&quot;#code2&quot;).jqGrid(&#039;getCell&#039;,sr,&#039;code1&#039;);
..

...

sv = jQuery("#code2").jqGrid('getCell',sr,'code1');

This is true since:

if(sv)
{
   // recupere la valeur du second dropdown
   jQuery(&quot;#code2&quot;,formid).val(sv).removeAttr(&quot;disabled&quot;);
}
...

if(sv)

{

// recupere la valeur du second dropdown

jQuery("#code2",formid).val(sv).removeAttr("disabled");

}

...

Before the if(sv) you can

console.log(sv);
if(sv)

1 2	console.log(sv); if(sv)

to see the variable. You can then compare it with what you have in the select

Kind Regards,

August 21, 2015 at 10:34 am #124278

Saroumane

Participant

Hello Tony,

Thank for your answer.
I verified my code with your indications. I added the line


console.log(sv);
if(sv)

console.log(sv);

if(sv)

and the log file give this information:

log file:


Executed 1 query(s) - 2015-08-21 10:15:03
Array
(
[0] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:03
[query] =&gt; SELECT * FROM rex_at WHERE 1=2
[data] =&gt;
[types] =&gt;
[fields] =&gt;
[primary] =&gt;
[input] =&gt;
)

)
Executed 2 query(s) - 2015-08-21 10:15:03
Array
(
[0] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:03
[query] =&gt; SELECT * FROM rex_at WHERE 1=2
[data] =&gt;
[types] =&gt;
[fields] =&gt;
[primary] =&gt;
[input] =&gt;
)

[1] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:03
[query] =&gt; UPDATE rex_at SET date_at = ?, type = ?, uo_poles = ?, unites = ?, description = ?, commentaires = ?, nom = ?, prenom = ?, CP = ?, jeune_embauche = ?, arret = ?, duree_arret = ?, code1 = ?, code2 = ?, lesion = ?, siege = ?, epi = ?, DPA_trait = ?, DPA_valid = ? WHERE id_at = ?
[data] =&gt; Array
(
[0] =&gt; 2014-04-01 09:10:00
[1] =&gt; Refusé
[2] =&gt; Tous UO/Pôles
[3] =&gt; Informatique local
[4] =&gt; test
[5] =&gt; test
[6] =&gt; BARJOT
[7] =&gt; THIERRY
[8] =&gt; 7008095v
[9] =&gt; Non
[10] =&gt; Non
[11] =&gt; 0jours
[12] =&gt; Accessoires de levage, amarrage et préhension
[13] =&gt; Cordage textile
[14] =&gt;
[15] =&gt;
[16] =&gt;
[17] =&gt; 0jours
[18] =&gt; 0jours
[19] =&gt; 187
)

[types] =&gt; Array
(
[0] =&gt; datetime
[1] =&gt; string
[2] =&gt; string
[3] =&gt; string
[4] =&gt; string
[5] =&gt; string
[6] =&gt; string
[7] =&gt; string
[8] =&gt; string
[9] =&gt; blob
[10] =&gt; blob
[11] =&gt; numeric
[12] =&gt; string
[13] =&gt; string
[14] =&gt; string
[15] =&gt; string
[16] =&gt; blob
[17] =&gt; numeric
[18] =&gt; numeric
[19] =&gt; int
)

[fields] =&gt; Array
(
[id_at] =&gt; Array
(
[type] =&gt; int
)

[date_at] =&gt; Array
(
[type] =&gt; datetime
)

[type] =&gt; Array
(
[type] =&gt; string
)

[uo_poles] =&gt; Array
(
[type] =&gt; string
)

[unites] =&gt; Array
(
[type] =&gt; string
)

[description] =&gt; Array
(
[type] =&gt; string
)

[commentaires] =&gt; Array
(
[type] =&gt; string
)

[nom] =&gt; Array
(
[type] =&gt; string
)

[prenom] =&gt; Array
(
[type] =&gt; string
)

[CP] =&gt; Array
(
[type] =&gt; string
)

[jeune_embauche] =&gt; Array
(
[type] =&gt; blob
)

[arret] =&gt; Array
(
[type] =&gt; blob
)

[duree_arret] =&gt; Array
(
[type] =&gt; numeric
)

[code1] =&gt; Array
(
[type] =&gt; string
)

[code2] =&gt; Array
(
[type] =&gt; string
)

[lesion] =&gt; Array
(
[type] =&gt; string
)

[siege] =&gt; Array
(
[type] =&gt; string
)

[epi] =&gt; Array
(
[type] =&gt; blob
)

[DPA_trait] =&gt; Array
(
[type] =&gt; numeric
)

[DPA_valid] =&gt; Array
(
[type] =&gt; numeric
)

)

[primary] =&gt; id_at
[input] =&gt; Array
(
[id_at] =&gt; 187
[type] =&gt; Refusé
[date_at] =&gt; 01/04/2014 09:10
[uo_poles] =&gt; Tous UO/Pôles
[unites] =&gt; Informatique local
[description] =&gt; test
[commentaires] =&gt; test
[nom] =&gt; BARJOT
[prenom] =&gt; THIERRY
[CP] =&gt; 7008095v
[jeune_embauche] =&gt; Non
[arret] =&gt; Non
[duree_arret] =&gt; 0jours
[code1] =&gt; Accessoires de levage, amarrage et préhension
[code2] =&gt; Cordage textile
[lesion] =&gt;
[siege] =&gt;
[epi] =&gt;
[DPA_trait] =&gt; 0jours
[DPA_valid] =&gt; 0jours
[oper] =&gt; edit
)

)

)
Executed 2 query(s) - 2015-08-21 10:15:03
Array
(
[0] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:03
[query] =&gt; SELECT COUNT(*) AS COUNTR FROM rex_at
[data] =&gt;
[types] =&gt;
[fields] =&gt;
[primary] =&gt;
[input] =&gt;
)

[1] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:03
[query] =&gt; SELECT id_at, type, date_at, uo_poles, unites, description, commentaires, nom, prenom, CP, jeune_embauche, arret, duree_arret, code1, code2, lesion, siege, epi, DPA_trait, DPA_valid FROM rex_at ORDER BY date_at desc LIMIT 75, 15
[data] =&gt;
[types] =&gt;
[fields] =&gt;
[primary] =&gt;
[input] =&gt;
)

)
Executed 2 query(s) - 2015-08-21 10:15:45
Array
(
[0] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:45
[query] =&gt; SELECT COUNT(*) AS COUNTR FROM rex_at
[data] =&gt;
[types] =&gt;
[fields] =&gt;
[primary] =&gt;
[input] =&gt;
)

[1] =&gt; Array
(
[time] =&gt; 2015-08-21 10:15:45
[query] =&gt; SELECT id_at, type, date_at, uo_poles, unites, description, commentaires, nom, prenom, CP, jeune_embauche, arret, duree_arret, code1, code2, lesion, siege, epi, DPA_trait, DPA_valid FROM rex_at ORDER BY date_at desc LIMIT 0, 15
[data] =&gt;
[types] =&gt;
[fields] =&gt;
[primary] =&gt;
[input] =&gt;
)

)

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

Executed 1 query(s) - 2015-08-21 10:15:03

Array

(

[0] => Array

(

[time] => 2015-08-21 10:15:03

[query] => SELECT * FROM rex_at WHERE 1=2

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

Executed 2 query(s) - 2015-08-21 10:15:03

Array

(

[0] => Array

(

[time] => 2015-08-21 10:15:03

[query] => SELECT * FROM rex_at WHERE 1=2

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2015-08-21 10:15:03

[query] => UPDATE rex_at SET date_at = ?, type = ?, uo_poles = ?, unites = ?, description = ?, commentaires = ?, nom = ?, prenom = ?, CP = ?, jeune_embauche = ?, arret = ?, duree_arret = ?, code1 = ?, code2 = ?, lesion = ?, siege = ?, epi = ?, DPA_trait = ?, DPA_valid = ? WHERE id_at = ?

[data] => Array

(

[0] => 2014-04-01 09:10:00

[1] => Refusé

[2] => Tous UO/Pôles

[3] => Informatique local

[4] => test

[5] => test

[6] => BARJOT

[7] => THIERRY

[8] => 7008095v

[9] => Non

[10] => Non

[11] => 0jours

[12] => Accessoires de levage, amarrage et préhension

[13] => Cordage textile

[14] =>

[15] =>

[16] =>

[17] => 0jours

[18] => 0jours

[19] => 187

)

[types] => Array

(

[0] => datetime

[1] => string

[2] => string

[3] => string

[4] => string

[5] => string

[6] => string

[7] => string

[8] => string

[9] => blob

[10] => blob

[11] => numeric

[12] => string

[13] => string

[14] => string

[15] => string

[16] => blob

[17] => numeric

[18] => numeric

[19] => int

)

[fields] => Array

(

[id_at] => Array

(

[type] => int

)

[date_at] => Array

(

[type] => datetime

)

[type] => Array

(

[type] => string

)

[uo_poles] => Array

(

[type] => string

)

[unites] => Array

(

[type] => string

)

[description] => Array

(

[type] => string

)

[commentaires] => Array

(

[type] => string

)

[nom] => Array

(

[type] => string

)

[prenom] => Array

(

[type] => string

)

[CP] => Array

(

[type] => string

)

[jeune_embauche] => Array

(

[type] => blob

)

[arret] => Array

(

[type] => blob

)

[duree_arret] => Array

(

[type] => numeric

)

[code1] => Array

(

[type] => string

)

[code2] => Array

(

[type] => string

)

[lesion] => Array

(

[type] => string

)

[siege] => Array

(

[type] => string

)

[epi] => Array

(

[type] => blob

)

[DPA_trait] => Array

(

[type] => numeric

)

[DPA_valid] => Array

(

[type] => numeric

)

[primary] => id_at

[input] => Array

(

[id_at] => 187

[type] => Refusé

[date_at] => 01/04/2014 09:10

[uo_poles] => Tous UO/Pôles

[unites] => Informatique local

[description] => test

[commentaires] => test

[nom] => BARJOT

[prenom] => THIERRY

[CP] => 7008095v

[jeune_embauche] => Non

[arret] => Non

[duree_arret] => 0jours

[code1] => Accessoires de levage, amarrage et préhension

[code2] => Cordage textile

[lesion] =>

[siege] =>

[epi] =>

[DPA_trait] => 0jours

[DPA_valid] => 0jours

[oper] => edit

)

Executed 2 query(s) - 2015-08-21 10:15:03

Array

(

[0] => Array

(

[time] => 2015-08-21 10:15:03

[query] => SELECT COUNT(*) AS COUNTR FROM rex_at

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2015-08-21 10:15:03

[query] => SELECT id_at, type, date_at, uo_poles, unites, description, commentaires, nom, prenom, CP, jeune_embauche, arret, duree_arret, code1, code2, lesion, siege, epi, DPA_trait, DPA_valid FROM rex_at ORDER BY date_at desc LIMIT 75, 15

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

Executed 2 query(s) - 2015-08-21 10:15:45

Array

(

[0] => Array

(

[time] => 2015-08-21 10:15:45

[query] => SELECT COUNT(*) AS COUNTR FROM rex_at

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2015-08-21 10:15:45

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

If I see correctly the log, the value of dependent dropdown are loaded, but no displayed. It’s right ? but I don’t understand why.

Thanks for your help,

Kind Regards

This reply was modified 10 years, 8 months ago by Saroumane.

Jqgrid PHP 5.1.0

August 21, 2015 at 11:03 am #124280

Saroumane

Participant

In fact, if I modify my form without update my depndent dropdown, I have this log:


Executed 1 query(s) - 2015-08-21 10:57:04
Array
(
    [0] =&gt; Array
        (
            [time] =&gt; 2015-08-21 10:57:04
            [query] =&gt; SELECT * FROM rex_at WHERE 1=2
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

)
Executed 2 query(s) - 2015-08-21 10:57:04
Array
(
    [0] =&gt; Array
        (
            [time] =&gt; 2015-08-21 10:57:04
            [query] =&gt; SELECT * FROM rex_at WHERE 1=2
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

    [1] =&gt; Array
        (
            [time] =&gt; 2015-08-21 10:57:04
            [query] =&gt; UPDATE rex_at SET date_at = ?, type = ?, uo_poles = ?, unites = ?, description = ?, commentaires = ?, nom = ?, prenom = ?, CP = ?, jeune_embauche = ?, arret = ?, duree_arret = ?, code1 = ?, code2 = ?, lesion = ?, siege = ?, epi = ?, DPA_trait = ?, DPA_valid = ? WHERE id_at = ?
            [data] =&gt; Array
                (
                    [0] =&gt; 2014-04-01 09:10:00
                    [1] =&gt; Refusé
                    [2] =&gt; Tous UO/Pôles
                    [3] =&gt; Informatique local
                    [4] =&gt; test
                    [5] =&gt; test2
                    [6] =&gt; BARJOT
                    [7] =&gt; THIERRY
                    [8] =&gt; 7008095v
                    [9] =&gt; Non
                    [10] =&gt; Non
                    [11] =&gt; 0jours
                    [12] =&gt; Accessoires de levage, amarrage et préhension
                    [13] =&gt; Select
                    [14] =&gt; 
                    [15] =&gt; 
                    [16] =&gt; 
                    [17] =&gt; 0jours
                    [18] =&gt; 0jours
                    [19] =&gt; 187
                )

            [types] =&gt; Array
                (
                    [0] =&gt; datetime
                    [1] =&gt; string
                    [2] =&gt; string
                    [3] =&gt; string
                    [4] =&gt; string
                    [5] =&gt; string
                    [6] =&gt; string
                    [7] =&gt; string
                    [8] =&gt; string
                    [9] =&gt; blob
                    [10] =&gt; blob
                    [11] =&gt; numeric
                    [12] =&gt; string
                    [13] =&gt; string
                    [14] =&gt; string
                    [15] =&gt; string
                    [16] =&gt; blob
                    [17] =&gt; numeric
                    [18] =&gt; numeric
                    [19] =&gt; int
                )

            [fields] =&gt; Array
                (
                    [id_at] =&gt; Array
                        (
                            [type] =&gt; int
                        )

                    [date_at] =&gt; Array
                        (
                            [type] =&gt; datetime
                        )

                    [type] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [uo_poles] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [unites] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [description] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [commentaires] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [nom] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [prenom] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [CP] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [jeune_embauche] =&gt; Array
                        (
                            [type] =&gt; blob
                        )

                    [arret] =&gt; Array
                        (
                            [type] =&gt; blob
                        )

                    [duree_arret] =&gt; Array
                        (
                            [type] =&gt; numeric
                        )

                    [code1] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [code2] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [lesion] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [siege] =&gt; Array
                        (
                            [type] =&gt; string
                        )

                    [epi] =&gt; Array
                        (
                            [type] =&gt; blob
                        )

                    [DPA_trait] =&gt; Array
                        (
                            [type] =&gt; numeric
                        )

                    [DPA_valid] =&gt; Array
                        (
                            [type] =&gt; numeric
                        )

                )

            [primary] =&gt; id_at
            [input] =&gt; Array
                (
                    [id_at] =&gt; 187
                    [type] =&gt; Refusé
                    [date_at] =&gt; 01/04/2014 09:10
                    [uo_poles] =&gt; Tous UO/Pôles
                    [unites] =&gt; Informatique local
                    [description] =&gt; test
                    [commentaires] =&gt; test2
                    [nom] =&gt; BARJOT
                    [prenom] =&gt; THIERRY
                    [CP] =&gt; 7008095v
                    [jeune_embauche] =&gt; Non
                    [arret] =&gt; Non
                    [duree_arret] =&gt; 0jours
                    [code1] =&gt; Accessoires de levage, amarrage et préhension
                    [code2] =&gt; Select
                    [lesion] =&gt; 
                    [siege] =&gt; 
                    [epi] =&gt; 
                    [DPA_trait] =&gt; 0jours
                    [DPA_valid] =&gt; 0jours
                    [oper] =&gt; edit
                )

        )

)
Executed 2 query(s) - 2015-08-21 10:57:04
Array
(
    [0] =&gt; Array
        (
            [time] =&gt; 2015-08-21 10:57:04
            [query] =&gt; SELECT COUNT(*) AS COUNTR  FROM rex_at
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

    [1] =&gt; Array
        (
            [time] =&gt; 2015-08-21 10:57:04
            [query] =&gt;  SELECT  id_at, type, date_at, uo_poles, unites, description, commentaires, nom, prenom, CP, jeune_embauche, arret, duree_arret, code1, code2, lesion, siege, epi, DPA_trait, DPA_valid FROM rex_at ORDER BY date_at desc LIMIT 75, 15
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

Executed 1 query(s) - 2015-08-21 10:57:04

Array

(

[0] => Array

(

[time] => 2015-08-21 10:57:04

[query] => SELECT * FROM rex_at WHERE 1=2

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

Executed 2 query(s) - 2015-08-21 10:57:04

Array

(

[0] => Array

(

[time] => 2015-08-21 10:57:04

[query] => SELECT * FROM rex_at WHERE 1=2

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2015-08-21 10:57:04

[data] => Array

(

[0] => 2014-04-01 09:10:00

[1] => Refusé

[2] => Tous UO/Pôles

[3] => Informatique local

[4] => test

[5] => test2

[6] => BARJOT

[7] => THIERRY

[8] => 7008095v

[9] => Non

[10] => Non

[11] => 0jours

[12] => Accessoires de levage, amarrage et préhension

[13] => Select

[14] =>

[15] =>

[16] =>

[17] => 0jours

[18] => 0jours

[19] => 187

)

[types] => Array

(

[0] => datetime

[1] => string

[2] => string

[3] => string

[4] => string

[5] => string

[6] => string

[7] => string

[8] => string

[9] => blob

[10] => blob

[11] => numeric

[12] => string

[13] => string

[14] => string

[15] => string

[16] => blob

[17] => numeric

[18] => numeric

[19] => int

)

[fields] => Array

(

[id_at] => Array

(

[type] => int

)

[date_at] => Array

(

[type] => datetime

)

[type] => Array

(

[type] => string

)

[uo_poles] => Array

(

[type] => string

)

[unites] => Array

(

[type] => string

)

[description] => Array

(

[type] => string

)

[commentaires] => Array

(

[type] => string

)

[nom] => Array

(

[type] => string

)

[prenom] => Array

(

[type] => string

)

[CP] => Array

(

[type] => string

)

[jeune_embauche] => Array

(

[type] => blob

)

[arret] => Array

(

[type] => blob

)

[duree_arret] => Array

(

[type] => numeric

)

[code1] => Array

(

[type] => string

)

[code2] => Array

(

[type] => string

)

[lesion] => Array

(

[type] => string

)

[siege] => Array

(

[type] => string

)

[epi] => Array

(

[type] => blob

)

[DPA_trait] => Array

(

[type] => numeric

)

[DPA_valid] => Array

(

[type] => numeric

)

[primary] => id_at

[input] => Array

(

[id_at] => 187

[type] => Refusé

[date_at] => 01/04/2014 09:10

[uo_poles] => Tous UO/Pôles

[unites] => Informatique local

[description] => test

[commentaires] => test2

[nom] => BARJOT

[prenom] => THIERRY

[CP] => 7008095v

[jeune_embauche] => Non

[arret] => Non

[duree_arret] => 0jours

[code1] => Accessoires de levage, amarrage et préhension

[code2] => Select

[lesion] =>

[siege] =>

[epi] =>

[DPA_trait] => 0jours

[DPA_valid] => 0jours

[oper] => edit

)

Executed 2 query(s) - 2015-08-21 10:57:04

Array

(

[0] => Array

(

[time] => 2015-08-21 10:57:04

[query] => SELECT COUNT(*) AS COUNTR FROM rex_at

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2015-08-21 10:57:04

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

Jqgrid PHP 5.1.0

August 24, 2015 at 8:10 am #124296

tony

Keymaster

Hello,

Sorry that I do not explain good what I mean.

Please of place of console.log write

alert(sv);

and try this in edit mode.

This way you will see what is the value sv and what is actually in grid so that the select does not select the right value.

Kind Regards,

August 25, 2015 at 7:48 am #124300

Saroumane

Participant

Hello Tony,

I’m sorry for my confusion about the log.

I’m used the console log from firebug, and I have this result when I edit a row:


q	Objets, masses, particules en mouvement accidentel

1 2	q Objets, masses, particules en mouvement accidentel


[{&quot;id&quot;:&quot;Autre particule (sauf projection de produit chimiq&quot;,&quot;value&quot;:&quot;Autre particule (sauf projection de produit chimiq&quot;},{&quot;id&quot;:&quot;Effondrement de mati\u00e8res stock\u00e9es ou empil\u00e9es&quot;,&quot;value&quot;:&quot;Effondrement de mati\u00e8res stock\u00e9es ou empil\u00e9es&quot;},{&quot;id&quot;:&quot;El\u00e9ment de v\u00e9hicule ferroviaire&quot;,&quot;value&quot;:&quot;El\u00e9ment de v\u00e9hicule ferroviaire&quot;},{&quot;id&quot;:&quot;El\u00e9ment mobile&quot;,&quot;value&quot;:&quot;El\u00e9ment mobile&quot;},{&quot;id&quot;:&quot;Non class\u00e9 ci-dessous&quot;,&quot;value&quot;:&quot;Non class\u00e9 ci-dessous&quot;},{&quot;id&quot;:&quot;Objet, masse&quot;,&quot;value&quot;:&quot;Objet, masse&quot;},{&quot;id&quot;:&quot;Particule imputable au tranchage ou \u00e0 la frappe&quot;,&quot;value&quot;:&quot;Particule imputable au tranchage ou \u00e0 la frappe&quot;},{&quot;id&quot;:&quot;Particule imputable aux autres machines&quot;,&quot;value&quot;:&quot;Particule imputable aux autres machines&quot;},{&quot;id&quot;:&quot;Particule imputable aux meules&quot;,&quot;value&quot;:&quot;Particule imputable aux meules&quot;},{&quot;id&quot;:&quot;Produit d&#039;\u00e9boulement ou d&#039;effondrement&quot;,&quot;value&quot;:&quot;Produit d&#039;\u00e9boulement ou d&#039;effondrement&quot;},{&quot;id&quot;:&quot;Produits caustique, corrosif, toxique&quot;,&quot;value&quot;:&quot;Produits caustique, corrosif, toxique&quot;}]

[{"id":"Autre particule (sauf projection de produit chimiq","value":"Autre particule (sauf projection de produit chimiq"},{"id":"Effondrement de mati\u00e8res stock\u00e9es ou empil\u00e9es","value":"Effondrement de mati\u00e8res stock\u00e9es ou empil\u00e9es"},{"id":"El\u00e9ment de v\u00e9hicule ferroviaire","value":"El\u00e9ment de v\u00e9hicule ferroviaire"},{"id":"El\u00e9ment mobile","value":"El\u00e9ment mobile"},{"id":"Non class\u00e9 ci-dessous","value":"Non class\u00e9 ci-dessous"},{"id":"Objet, masse","value":"Objet, masse"},{"id":"Particule imputable au tranchage ou \u00e0 la frappe","value":"Particule imputable au tranchage ou \u00e0 la frappe"},{"id":"Particule imputable aux autres machines","value":"Particule imputable aux autres machines"},{"id":"Particule imputable aux meules","value":"Particule imputable aux meules"},{"id":"Produit d'\u00e9boulement ou d'effondrement","value":"Produit d'\u00e9boulement ou d'effondrement"},{"id":"Produits caustique, corrosif, toxique","value":"Produits caustique, corrosif, toxique"}]

If I’m understand the log, the ‘q’ value’ is ok, the function load the result of the query for the second dropdown, but don’t fill this, or don’t bind the result.

A problem with the JSON file ?

Thanks for your answer.

This reply was modified 10 years, 8 months ago by Saroumane.

Jqgrid PHP 5.1.0

August 25, 2015 at 9:41 am #124302

guriddo.support

Participant

Hello,

For me the problem is in the building the select.

In your code you have:

jQuery.each(response, function(i,item) {
   t += &quot;&quot;+item.value+&quot;&quot;;
});

jQuery.each(response, function(i,item) {

t += ""+item.value+"";

});

IMHO it should be:

jQuery.each(response, function(i,item) {
    t += &quot;&lt;option value=&#039;&quot;+item.id+&quot;&#039;&gt;&quot;+item.value+&quot;&lt;/option&gt;&quot;;
});

jQuery.each(response, function(i,item) {

t += "<option value='"+item.id+"'>"+item.value+"</option>";

});

Kind Regards,
Will

Guriddo Support Team

August 25, 2015 at 11:36 am #124303

Saroumane

Participant

Hello Will,

I changed my code by following your advice, but I have no change. The second dropdown is empty in the edit form. The field is not filled by the value, and the dropdown is empty. I need to choose again a value in the first dropdown for populate again the second dropdown.

My code with change:

  sv = jQuery(&quot;#test1&quot;).jqGrid(&#039;getCell&#039;,sr,&#039;code1&#039;);
                    jQuery.each(response, function(i,item) {
                        t += &quot;&lt;option value=&#039;&quot;+item.id+&quot;&#039;&gt;&quot;+item.value+&quot;&lt;/option&gt;&quot;;
                    });

sv = jQuery("#test1").jqGrid('getCell',sr,'code1');

jQuery.each(response, function(i,item) {

t += "<option value='"+item.id+"'>"+item.value+"</option>";

});

Thanks for your help.

Kind Regards,

Jqgrid PHP 5.1.0

August 25, 2015 at 3:34 pm #124304

guriddo.support

Participant

Hello,

The idea is to compare the value sv with those from the response.

This mean you get a value sv from the grid

...
sv = jQuery(&quot;#test1&quot;).jqGrid(&#039;getCell&#039;,sr,&#039;code1&#039;);

1 2	... sv = jQuery("#test1").jqGrid('getCell',sr,'code1');

and then you have this:

jQuery.each(response, function(i,item) {
     t += &quot;&lt;option value=&#039;&quot;+item.id+&quot;&#039;&gt;&quot;+item.value+&quot;&lt;/option&gt;&quot;;
});

jQuery.each(response, function(i,item) {

t += "<option value='"+item.id+"'>"+item.value+"</option>";

});

The question is: Is the value sv contained in the string with

Look especially in the item.id, sinsce to select the value the following condition must be meeted

sv should be in the options value which are filled with item.id (if I understand the question correct)

By the way could you please prepare a some test data for the table and data from the json response?

Problem with dependent dropdown.

Search Forum

Recent Replies

Forum Statistics

UserOnline