Guriddo » Topic: Problem with two "JS function"

Problem with two "JS function"

Guriddo
JS function both
Problem with two "JS function"

Tagged: JS function both

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

Creator

Topic

January 15, 2018 at 11:09 am #126575

Saroumane

Participant

Hello,

I have make a grid with two “JS function”.
– The first is “programatic group switch”.
– The second is “cell formatter” for insert a picture.

One by one, the functions are OK, but when the both functions are enabled, the “programmatic group switch” is down.

It is possible to use the both function together ?

Sorry for English,

Regards,


&lt;!--?php require_once &#039;../../TBL_connect.php&#039;; // include the jqGrid Class require_once &quot;../../php/PHPSuito/jqGrid.php&quot;; // include the driver class require_once &quot;../../php/PHPSuito/DBdrivers/jqGridPdo.php&quot;; require_once &quot;../../php/PHPSuito/External/tcpdf/config/lang/fra.php&quot;; require_once &quot;../../php/PHPSuito/External/tcpdf/config/lang/fra.php&quot;; require_once &quot;../../php/PHPSuito/jqAutocomplete.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;);&lt;/p&gt;
&lt;p&gt;			// Création d&#039;une instance jqGrid&lt;br ?--&gt; $grid = new jqGridRender($conn);

// Load de la requête SQL
$grid-&gt;SelectCommand = &quot;
SELECT &lt;code&gt;essieu_interv&lt;/code&gt;.flag, &lt;code&gt;essieu_interv&lt;/code&gt;.cle_GMAO, &lt;code&gt;essieu_interv&lt;/code&gt;.&lt;code&gt;num_ef&lt;/code&gt;, &lt;code&gt;essieu_interv&lt;/code&gt;.type_di, &lt;code&gt;essieu_interv&lt;/code&gt;.statut_interv, &lt;code&gt;essieu_interv&lt;/code&gt;.&lt;code&gt;code_op&lt;/code&gt; ,
&lt;code&gt;essieu_interv&lt;/code&gt;.&lt;code&gt;lib_interv&lt;/code&gt;, &lt;code&gt;essieu_interv&lt;/code&gt;.&lt;code&gt;dt_butee&lt;/code&gt;, &lt;code&gt;essieu_interv&lt;/code&gt;.ref_RDV, WEEK(essieu_prog.&lt;code&gt;dt_prog_inter&lt;/code&gt;,3) AS semaine
FROM &lt;code&gt;essieu_interv&lt;/code&gt; LEFT JOIN essieu_prog ON &lt;code&gt;essieu_interv&lt;/code&gt;.ref_RDV=essieu_prog.ref_RDV AND &lt;code&gt;essieu_interv&lt;/code&gt;.num_ef=essieu_prog.num_ef
WHERE &lt;code&gt;essieu_interv&lt;/code&gt;.statut_interv !=&#039;VALIDE&#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;cle_GMAO&quot;);
$grid-&gt;serialKey = false;

//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_essieu.php&#039;);

// Déclaration d&#039;autres options
$grid-&gt;setGridOptions(array(
&quot;caption&quot;=&gt;&quot;programmation des essieux&quot;, // Titre du tableau
&quot;rowNum&quot;=&gt;20, // 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;cle_GMAO&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;1100&quot;, // Largeur du tableau en px
&quot;loadonce&quot; =&gt;false,
// &quot;colMenu&quot;=&gt;true,
&quot;height&quot;=&gt;&quot;auto&quot;, // Hauteur automatique du tableau
&quot;groupingView&quot;=&gt;array(
&quot;groupField&quot; =&gt; array(&quot;sem&quot;), // group by par la variable &quot;SEM&quot; avec le décompte
&quot;groupOrder&quot; =&gt; array(&quot;desc&quot;), // ordre de regroupement desc ou asc
&quot;groupColumnShow&quot; =&gt; array(true), // montrer la colonne regroupée
&quot;groupText&quot; =&gt;array(&#039;&lt;b&gt;&lt;i&gt;{0} ({1})&lt;/i&gt;&lt;/b&gt;&#039;), // texte d&#039;entête en gras et italique
&quot;groupSummary&quot; =&gt; array(false), // Active/desactive la somme en bas des regroupements
&quot;groupCollapse&quot;=&gt;false, // Active/desactive le pliage/dépliage des regroupements
&quot;groupDataSorted&quot; =&gt; true
),
&quot;hoverrows&quot;=&gt;true // highlight la ligne survolée
));

// script du champ de recherche à la volée.
$code = &lt;&lt;&lt;code&gt;setJSCode($code);
// fin du code de recherche à la volée.&lt;/code&gt;

//*********************************
$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;editable&quot;=&gt;false));
$grid-&gt;setColProperty(&#039;flag&#039;, array( &quot;hidden&quot;=&gt;false, &quot;width&quot;=&gt;40, &quot;align&quot;=&gt;&quot;center&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;75, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editoptions&quot;=&gt;array(&quot;readonly&quot;=&gt;true)));
$grid-&gt;setColProperty(&#039;semaine&#039;, array(&quot;label&quot;=&gt;&quot;Semaine&quot;, &quot;width&quot;=&gt;50, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editoptions&quot;=&gt;array(&quot;readonly&quot;=&gt;true)));

$grid-&gt;setColProperty(&#039;code_op&#039;, array(&quot;label&quot;=&gt;&quot;Code opération&quot;, &quot;width&quot;=&gt;80, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;occurence&#039;, array(&quot;label&quot;=&gt;&quot;Occurence&quot;, &quot;width&quot;=&gt;90, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;statut_interv&#039;, array(&quot;label&quot;=&gt;&quot;Statut intervention&quot;, &quot;width&quot;=&gt;100, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;type_di&#039;, array(&quot;label&quot;=&gt;&quot;Statut opérationnel&quot;, &quot;width&quot;=&gt;100, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;true));

$grid-&gt;setColProperty(&#039;lib_interv&#039;, array(&quot;label&quot;=&gt;&quot;Libellé intervention&quot;, &quot;width&quot;=&gt;250, &quot;align&quot;=&gt;&quot;left&quot;, &quot;editable&quot;=&gt;true));

$grid-&gt;setColProperty(&#039;link&#039;, array(&quot;label&quot;=&gt;&quot;PDF&quot;, &quot;width&quot;=&gt;180, &quot;align&quot;=&gt;&quot;center&quot;, &quot;editable&quot;=&gt;false, &quot;formatter&quot;=&gt;&quot;link&quot;));

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

// --Propriété Champ text-area
$grid-&gt;setColProperty(&#039;libelle&#039;, array(&quot;label&quot;=&gt;&quot;Libellé&quot;, &quot;width&quot;=&gt;350, &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;220), &quot;editable&quot;=&gt;true));

// ****************************************
// --Propriété Champ dropdown
$grid-&gt;setColProperty(&#039;ref_RDV&#039;, array(&quot;label&quot;=&gt;&quot;Ref RDV&quot;, &quot;width&quot;=&gt;50, &quot;editable&quot;=&gt;true,&quot;align&quot;=&gt;&quot;center&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);

// ****************************************
// définition champ type: datetimepicker
$grid-&gt;setColProperty(&#039;dt_butee&#039;,
array(&quot;formatter&quot;=&gt;&quot;date&quot;,
&quot;label&quot;=&gt;&quot;Date butée&quot;,&quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;150, &quot;editable&quot;=&gt;true,
&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;),
&quot;searchoptions&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;85%&#039;});
},200);}&quot;
)));

$grid-&gt;setDbTime(&#039;Y-m-d H:i:s&#039;);
$grid-&gt;setUserTime(&quot;d/m/Y H:i&quot;);

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

// ****************************************
// définition champ type: datetimepicker
$grid-&gt;setColProperty(&#039;dt_prog_inter&#039;,
array(&quot;formatter&quot;=&gt;&quot;date&quot;,
&quot;label&quot;=&gt;&quot;Début date RDV&quot;,&quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;150, &quot;editable&quot;=&gt;true,
&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;),
&quot;searchoptions&quot;=&gt;array(&quot;dataInit&quot;=&gt;
&quot;js:function(elm){setTimeout(function(){
jQuery(elm).datepicker({dateFormat:&#039;dd/mm/yy&#039;});
jQuery(&#039;.ui-datepicker&#039;).css({&#039;font-size&#039;:&#039;85%&#039;});
},0);}&quot;),
&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;85%&#039;});
},0);}&quot;)
));
$grid-&gt;setDbTime(&#039;Y-m-d H:i:s&#039;);
$grid-&gt;setUserTime(&quot;d/m/Y H:i&quot;);

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

// ****************************************
// définition champ type: datetimepicker
$grid-&gt;setColProperty(&#039;dt_fin_inter&#039;,
array(&quot;formatter&quot;=&gt;&quot;date&quot;,
&quot;label&quot;=&gt;&quot;Fin date RDV&quot;,&quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;150, &quot;editable&quot;=&gt;true,
&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;),
&quot;searchoptions&quot;=&gt;array(&quot;dataInit&quot;=&gt;
&quot;js:function(elm){setTimeout(function(){
jQuery(elm).datepicker({dateFormat:&#039;dd/mm/yy&#039;});
jQuery(&#039;.ui-datepicker&#039;).css({&#039;font-size&#039;:&#039;85%&#039;});
},0);}&quot;),
&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;85%&#039;});
},0);}&quot;)
));
$grid-&gt;setDbTime(&#039;Y-m-d H:i:s&#039;);
$grid-&gt;setUserTime(&quot;d/m/Y H:i&quot;);

// Champ d &#039;affichage des voyants de conformité.
$grid-&gt;setColProperty(&#039;flag&#039;, array(&quot;formatter&quot;=&gt;&quot;js:formatImage&quot;, &quot;label&quot;=&gt;&quot;Nouveau&quot;,&quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;40, &quot;editable&quot;=&gt;false));
// ***********************************

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

//$val1= jqGridUtils::GetParam(&#039;cle_GMAO&#039;);
$val2= jqGridUtils::GetParam(&#039;num_ef&#039;);
$val3= jqGridUtils::GetParam(&#039;ref_RDV&#039;);
// $val4= jqGridUtils::GetParam(&#039;lib_interv&#039;);
// $val5= jqGridUtils::GetParam(&#039;dt_prog_inter&#039;);
// $val6= jqGridUtils::GetParam(&#039;dt_fin_inter&#039;);
// $val7= jqGridUtils::GetParam(&#039;site_prog&#039;);
// $val8= jqGridUtils::GetParam(&#039;justif&#039;);

// $grid-&gt;setAfterCrudAction(&#039;add&#039;, &quot;UPDATE &lt;code&gt;visa&lt;/code&gt; SET &lt;code&gt;ID_visa&lt;/code&gt;=? WHERE &lt;code&gt;MR&lt;/code&gt;=? AND di=?&quot; , array($val1,$val2,$val3));
$grid-&gt;setAfterCrudAction(&#039;edit&#039;, &quot;
DELETE FROM &lt;code&gt;essieu_prog&lt;/code&gt; WHERE ref_RDV=? AND num_ef=?
&quot;, array($val3,$val2));

$grid-&gt;setAfterCrudAction(&#039;edit&#039;, &quot;
INSERT INTO
&lt;code&gt;essieu_prog&lt;/code&gt;(&lt;code&gt;cle_GMAO&lt;/code&gt;, &lt;code&gt;num_ef&lt;/code&gt;, &lt;code&gt;type_di&lt;/code&gt;, &lt;code&gt;code_op&lt;/code&gt;, &lt;code&gt;lib_interv&lt;/code&gt;, justif, ref_RDV)
SELECT &lt;code&gt;cle_GMAO&lt;/code&gt;, &lt;code&gt;num_ef&lt;/code&gt;, &lt;code&gt;type_di&lt;/code&gt;, &lt;code&gt;code_op&lt;/code&gt;, GROUP_CONCAT(&lt;code&gt;lib_interv&lt;/code&gt; SEPARATOR &#039; ### &#039;) AS lib_interv, &lt;code&gt;justif&lt;/code&gt;, ref_RDV
FROM &lt;code&gt;essieu_interv&lt;/code&gt; WHERE num_ef=? AND ref_RDV=? GROUP BY num_ef, ref_RDV
&quot;, array($val2,$val3));

// ***************************************
// Fonction de gestion des vignettes de conformités
$custom = &lt;&lt;&lt;CUSTOM
function formatImage(cellValue, options, rowObject) {
var imageHtml = &quot;&lt;img src=&quot;images/&amp;quot; + cellValue +&amp;quot;.png&amp;quot;+ &amp;quot;&quot; /&gt;&quot;;
return imageHtml;
}
function unformatImage(cellValue, options, cellObject) {
return $(cellObject.html()).attr(&quot;originalValue&quot;);
}

CUSTOM;
// *****************************************

// ******************** Script de regroupement dynamique. ********************

$dynamic = &lt;&lt;exportfile = &#039;Export_prog_essieu.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;page_format&quot;=&gt;&quot;A3&quot;,
&quot;margin_left&quot;=&gt;5,
&quot;margin_right&quot;=&gt;5,
&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_visagraphe_loc&quot;, // Titre de l&#039;en-tête
&quot;shrink_cell&quot;=&gt;true, // Activation/Desactivation du tassement des valeurs
&quot;encoding&quot; =&gt; &quot;UTF-8&quot;, // Encodage UTF-8
&quot;font_size_main&quot;=&gt;8, // taille de la police de l&#039;entete
&quot;font_size_data&quot;=&gt;8, // taille de la police des données
&quot;grid_alternate_rows&quot;=&gt;true,
&quot;reprint_grid_header&quot;=&gt;true, // Affichage des titres de colonnes sur chaque page
&quot;header_string&quot;=&gt;&quot;STF VIC&quot; // Texte d&#039;en-tête à imprimer

));
}
//*********************************
$grid-&gt;setJSCode($dynamic);
$grid-&gt;setJSCode($custom);

$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;true,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;true, &quot;search&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;375, &quot;height&quot;=&gt;450, &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

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

<!--?php require_once '../../TBL_connect.php'; // include the jqGrid Class require_once "../../php/PHPSuito/jqGrid.php"; // include the driver class require_once "../../php/PHPSuito/DBdrivers/jqGridPdo.php"; require_once "../../php/PHPSuito/External/tcpdf/config/lang/fra.php"; require_once "../../php/PHPSuito/External/tcpdf/config/lang/fra.php"; require_once "../../php/PHPSuito/jqAutocomplete.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>essieu_interv</code>.flag, <code>essieu_interv</code>.cle_GMAO, <code>essieu_interv</code>.<code>num_ef</code>, <code>essieu_interv</code>.type_di, <code>essieu_interv</code>.statut_interv, <code>essieu_interv</code>.<code>code_op</code> ,

<code>essieu_interv</code>.<code>lib_interv</code>, <code>essieu_interv</code>.<code>dt_butee</code>, <code>essieu_interv</code>.ref_RDV, WEEK(essieu_prog.<code>dt_prog_inter</code>,3) AS semaine

FROM <code>essieu_interv</code> LEFT JOIN essieu_prog ON <code>essieu_interv</code>.ref_RDV=essieu_prog.ref_RDV AND <code>essieu_interv</code>.num_ef=essieu_prog.num_ef

WHERE <code>essieu_interv</code>.statut_interv !='VALIDE'

// Déclaration de la table MaJ

$grid->table = 'essieu_interv';

// Définition d'une clé primaire

$grid->setPrimaryKeyId("cle_GMAO");

$grid->serialKey = false;

//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_essieu.php');

// Déclaration d'autres options

$grid->setGridOptions(array(

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

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

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

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

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

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

"loadonce" =>false,

// "colMenu"=>true,

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

"groupingView"=>array(

"groupField" => array("sem"), // group by par la variable "SEM" avec le décompte

"groupOrder" => array("desc"), // ordre de regroupement desc ou asc

"groupColumnShow" => array(true), // montrer la colonne regroupée

"groupText" =>array('{0} ({1})'), // texte d'entête en gras et italique

"groupSummary" => array(false), // Active/desactive la somme en bas des regroupements

"groupCollapse"=>false, // Active/desactive le pliage/dépliage des regroupements

"groupDataSorted" => true

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

));

// script du champ de recherche à la volée.

$code = <<<code>setJSCode($code);

// fin du code de recherche à la volée.</code>

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

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

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

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

$grid->setColProperty('semaine', array("label"=>"Semaine", "width"=>50, "align"=>"center", "editoptions"=>array("readonly"=>true)));

$grid->setColProperty('code_op', array("label"=>"Code opération", "width"=>80, "align"=>"center", "editable"=>true));

$grid->setColProperty('occurence', array("label"=>"Occurence", "width"=>90, "align"=>"center", "editable"=>true));

$grid->setColProperty('statut_interv', array("label"=>"Statut intervention", "width"=>100, "align"=>"center", "editable"=>true));

$grid->setColProperty('type_di', array("label"=>"Statut opérationnel", "width"=>100, "align"=>"center", "editable"=>true));

$grid->setColProperty('lib_interv', array("label"=>"Libellé intervention", "width"=>250, "align"=>"left", "editable"=>true));

$grid->setColProperty('link', array("label"=>"PDF", "width"=>180, "align"=>"center", "editable"=>false, "formatter"=>"link"));

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

// --Propriété Champ text-area

$grid->setColProperty('libelle', array("label"=>"Libellé", "width"=>350, "edittype"=> 'textarea',"editoptions"=>array("rows"=>4, "cols"=>50, "maxlength"=>255, "width"=>220), "editable"=>true));

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

// --Propriété Champ dropdown

$grid->setColProperty('ref_RDV', array("label"=>"Ref RDV", "width"=>50, "editable"=>true,"align"=>"center","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);

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

// définition champ type: datetimepicker

$grid->setColProperty('dt_butee',

array("formatter"=>"date",

"label"=>"Date butée","align"=>"center", "width"=>150, "editable"=>true,

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

"searchoptions"=>array("dataInit"=>

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

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

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

},200);}"

)));

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

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

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

// définition champ type: datetimepicker

$grid->setColProperty('dt_prog_inter',

array("formatter"=>"date",

"label"=>"Début date RDV","align"=>"center", "width"=>150, "editable"=>true,

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

"searchoptions"=>array("dataInit"=>

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

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

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

},0);}"),

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

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

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

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

},0);}")

));

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

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

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

// définition champ type: datetimepicker

$grid->setColProperty('dt_fin_inter',

array("formatter"=>"date",

"label"=>"Fin date RDV","align"=>"center", "width"=>150, "editable"=>true,

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

"searchoptions"=>array("dataInit"=>

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

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

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

},0);}"),

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

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

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

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

},0);}")

));

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

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

// Champ d 'affichage des voyants de conformité.

$grid->setColProperty('flag', array("formatter"=>"js:formatImage", "label"=>"Nouveau","align"=>"center", "width"=>40, "editable"=>false));

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

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

//$val1= jqGridUtils::GetParam('cle_GMAO');

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

$val3= jqGridUtils::GetParam('ref_RDV');

// $val4= jqGridUtils::GetParam('lib_interv');

// $val5= jqGridUtils::GetParam('dt_prog_inter');

// $val6= jqGridUtils::GetParam('dt_fin_inter');

// $val7= jqGridUtils::GetParam('site_prog');

// $val8= jqGridUtils::GetParam('justif');

// $grid->setAfterCrudAction('add', "UPDATE <code>visa</code> SET <code>ID_visa</code>=? WHERE <code>MR</code>=? AND di=?" , array($val1,$val2,$val3));

$grid->setAfterCrudAction('edit', "

DELETE FROM <code>essieu_prog</code> WHERE ref_RDV=? AND num_ef=?

", array($val3,$val2));

$grid->setAfterCrudAction('edit', "

INSERT INTO

<code>essieu_prog</code>(<code>cle_GMAO</code>, <code>num_ef</code>, <code>type_di</code>, <code>code_op</code>, <code>lib_interv</code>, justif, ref_RDV)

SELECT <code>cle_GMAO</code>, <code>num_ef</code>, <code>type_di</code>, <code>code_op</code>, GROUP_CONCAT(<code>lib_interv</code> SEPARATOR ' ### ') AS lib_interv, <code>justif</code>, ref_RDV

FROM <code>essieu_interv</code> WHERE num_ef=? AND ref_RDV=? GROUP BY num_ef, ref_RDV

", array($val2,$val3));

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

// Fonction de gestion des vignettes de conformités

$custom = <<<CUSTOM

function formatImage(cellValue, options, rowObject) {

var imageHtml = "<img src="images/&quot; + cellValue +&quot;.png&quot;+ &quot;" />";

return imageHtml;

}

function unformatImage(cellValue, options, cellObject) {

return $(cellObject.html()).attr("originalValue");

}

CUSTOM;

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

// ******************** Script de regroupement dynamique. ********************

$dynamic = <<exportfile = 'Export_prog_essieu.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

"page_format"=>"A3",

"margin_left"=>5,

"margin_right"=>5,

"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_visagraphe_loc", // Titre de l'en-tête

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

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

"font_size_main"=>8, // taille de la police de l'entete

"font_size_data"=>8, // taille de la police des données

"grid_alternate_rows"=>true,

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

"header_string"=>"STF VIC" // Texte d'en-tête à imprimer

));

}

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

$grid->setJSCode($dynamic);

$grid->setJSCode($custom);

$grid->debug = false;

// Configuration du navigateur

$grid->navigator = true;

// Activation des options d'édition

$grid->setNavOptions('navigator', array("excel"=>true, "pdf"=>true, "add"=>true,"edit"=>true,"del"=>true,"view"=>true, "search"=>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"=>375, "height"=>450, "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

Creator

Topic

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

Author

Replies
January 15, 2018 at 1:42 pm #126576

guriddo.support
Participant

Hello,

The setJSCode method should be called only once. If you call it more than one time (like you do) the last code will be executed only.

To work this you should put all your javascript code in one variable and call setJSCode.

Kind Regards,

Will

Guriddo Support Team

January 16, 2018 at 8:19 am #126577

Saroumane
Participant

Hello,

Thanks, it’s all right !!! With your solution, the both functions work fine.

Kind Regards,

Saroumane

Jqgrid PHP 5.1.0
Author

Replies

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

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Problem with two "JS function"

Search Forum

Recent Replies

Forum Statistics

UserOnline