Guriddo » Topic: custom rows detail

custom rows detail

Guriddo
custom rows detail ID
custom rows detail

Tagged: custom rows detail ID

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

Creator

Topic

February 6, 2016 at 5:39 pm #124801

Saroumane

Participant

Hello,

I have new problem. 😉
I try to use the “custom rows detail” function.

I can’t bind my master table and the “detail” table. The two tables use the same ID (“Matricule”) . The “Matricule” field is the primary key for the two tables, and is an unique varchar like: 1234678A.

How I can define this field in the WHERE property in detail.php query ?

PS: Sorry for my bad english.

King regards,

grid.php

&lt;!--?php require_once &#039;../GK_connex.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;; // 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;); // Create the jqGrid instance $grid = new jqGridRender($conn); // Write the SQL Query $grid-&gt;SelectCommand = &#039;SELECT Matricule,date_eff, Agent_ID, Nom, Prenom, Genre, Code_Etb, lib_Etb, Division_geo, lib_RG, RG, dep_compt, Statut, Contrat, Type_contrat, Empl_repere, Qualif, CEGOS, Position, Grade, College FROM effectif&#039;;&lt;br ?--&gt; // Set output format to json
$grid-&gt;dataType = &#039;json&#039;;
// Let the grid create the model
$grid-&gt;setColModel();
// Set the url from where we obtain the data
$grid-&gt;setUrl(&#039;grid2.php&#039;);
// Set some grid options
$grid-&gt;setGridOptions(array(
&quot;rowNum&quot;=&gt;10,
&quot;height&quot;=&gt;&quot;auto&quot;,
&quot;rowList&quot;=&gt;array(10,20,30),
&quot;sortname&quot;=&gt;&quot;Matricule&quot;
));
$grid-&gt;setUserDate(&quot;d-m-Y&quot;);
$grid-&gt;setColProperty(&#039;date_eff&#039;, array(&quot;label&quot;=&gt;&quot;date&quot;,&quot;align&quot;=&gt;&quot;center&quot;, &quot;width&quot;=&gt;40,&quot;formatter&quot;=&gt;&quot;date&quot;,
&quot;formatoptions&quot;=&gt;array(&quot;srcformat&quot;=&gt;&quot;Y-m-d&quot;,&quot;newformat&quot;=&gt;&quot;d/m/Y&quot;), // Défini le format d&#039;affichage en jj/mm/aaaa
&quot;search&quot;=&gt;true));

// Set the url from where we get the data
$grid-&gt;setSubGridGrid(&#039;details.php&#039;);
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&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));

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

// Set output format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel();

// Set the url from where we obtain the data

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

// Set some grid options

$grid->setGridOptions(array(

"rowNum"=>10,

"height"=>"auto",

"rowList"=>array(10,20,30),

"sortname"=>"Matricule"

));

$grid->setUserDate("d-m-Y");

$grid->setColProperty('date_eff', array("label"=>"date","align"=>"center", "width"=>40,"formatter"=>"date",

"formatoptions"=>array("srcformat"=>"Y-m-d","newformat"=>"d/m/Y"), // Défini le format d'affichage en jj/mm/aaaa

"search"=>true));

// Set the url from where we get the data

$grid->setSubGridGrid('details.php');

$grid->navigator = true;

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

// Enjoy

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

detail.php



&lt;!--?php &lt;br ?--&gt; require_once &#039;../GK_connex.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;;
// 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;);
$rowid = jqGridUtils::Strip($_REQUEST[&quot;rowid&quot;]);
//if(!$rowid) die(&quot;Missed parameters&quot;);
// Get details
$SQL = &quot;SELECT Matricule, DDN_viseo, date_dispo_init, Note_EIA, Pot_valide, mobilite_structu
FROM coca_viseo WHERE Matricule=&#039;8406226G&#039;&quot;;
$qres = jqGridDB::query($conn, $SQL);
$result = jqGridDB::fetch_assoc($qres,$conn);
$s = &quot;&lt;table&gt;&lt;tbody&gt;&quot;;
$s .= &quot;&lt;tr&gt;&lt;td&gt;&lt;b&gt; Date de naissance&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&quot;.$result[&quot;DDN_viseo&quot;];
//$s .= &quot;&lt;td rowspan=&#039;9&#039; valign=&#039;top&#039;&gt;&lt;img src=&#039;images/&quot;.trim($result[&quot;EmployeeID&quot;]).&quot;.jpg&#039;/&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;
$s .= &quot;&lt;td&gt;&lt;b&gt;Date de dispo initiale&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&quot;.$result[&quot;date_dispo_init&quot;].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;
$s .= &quot;&lt;tr&gt;&lt;td&gt;&lt;b&gt;Note de l&#039;EIA&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&quot;.$result[&quot;Note_EIA&quot;].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;
$s .= &quot;&lt;tr&gt;&lt;td&gt;&lt;b&gt;Potentiel validé&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&quot;.$result[&quot;Pot_valide&quot;].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;
$s .= &quot;&lt;tr&gt;&lt;td&gt;&lt;b&gt;Mobilié structurelle&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&quot;.$result[&quot;mobilite_structu&quot;].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;

$s .= &quot;&lt;/tbody&gt;&lt;/table&gt;&quot;;
&quot;;
echo $s;
jqGridDB::closeCursor($qres);

require_once '../GK_connex.php';

// include the jqGrid Class

require_once "../php/PHPSuito/jqGrid.php";

// include the driver class

require_once "../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");

$rowid = jqGridUtils::Strip($_REQUEST["rowid"]);

//if(!$rowid) die("Missed parameters");

// Get details

$SQL = "SELECT Matricule, DDN_viseo, date_dispo_init, Note_EIA, Pot_valide, mobilite_structu

FROM coca_viseo WHERE Matricule='8406226G'";

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

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

$s = "<table><tbody>";

$s .= "<tr><td><b> Date de naissance</b></td><td>".$result["DDN_viseo"];

//$s .= "<td rowspan='9' valign='top'><img src='images/".trim($result["EmployeeID"]).".jpg'/></td></tr>";

$s .= "<td><b>Date de dispo initiale</b></td><td>".$result["date_dispo_init"]."</td></tr>";

$s .= "<tr><td><b>Note de l'EIA</b></td><td>".$result["Note_EIA"]."</td></tr>";

$s .= "<tr><td><b>Potentiel validé</b></td><td>".$result["Pot_valide"]."</td></tr>";

$s .= "<tr><td><b>Mobilié structurelle</b></td><td>".$result["mobilite_structu"]."</td></tr>";

$s .= "</tbody></table>";

echo $s;

jqGridDB::closeCursor($qres);

This topic was modified 10 years, 2 months ago by Saroumane.
This topic was modified 10 years, 2 months ago by Saroumane.
This topic was modified 10 years, 2 months ago by Saroumane.

Jqgrid PHP 5.1.0

Creator

Topic

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

Author

Replies

February 8, 2016 at 11:36 am #124805

guriddo.support

Participant

Hello,

I think that the missed setting is in the master table.

In master table you will need to set the primary key so that the grid know what to pass to the subgrid.

in your case you will need to do this in your master php file

....
$grid-&gt;setPrimaryKeyId(&quot;Matricule&quot;);
...

....

$grid->setPrimaryKeyId("Matricule");

...

After this the $rowid variable contain the needed value of Matricule.

So you can

$rowid = jqGridUtils::Strip($_REQUEST[&quot;rowid&quot;]);
$SQL = &quot;SELECT Matricule, DDN_viseo, date_dispo_init, Note_EIA, Pot_valide, mobilite_structu FROM coca_viseo WHERE Matricule=&#039;&quot;.$rowid.&quot;&#039;&quot;;
$qres = jqGridDB::query($conn, $SQL);
$result = jqGridDB::fetch_assoc($qres,$conn);

$rowid = jqGridUtils::Strip($_REQUEST["rowid"]);

$SQL = "SELECT Matricule, DDN_viseo, date_dispo_init, Note_EIA, Pot_valide, mobilite_structu FROM coca_viseo WHERE Matricule='".$rowid."'";

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

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

IMHO the better approach is to use prepared statement like

$rowid = jqGridUtils::Strip($_REQUEST[&quot;rowid&quot;]);
$SQL = &quot;SELECT Matricule, DDN_viseo, date_dispo_init, Note_EIA, Pot_valide, mobilite_structu FROM coca_viseo WHERE Matricule = ?&quot;;

$prep = jqGridDB::prepare($conn, $SQL, array($rowid));
$qres = jqGridDB::execute( $prep );
$result = jqGridDB::fetch_assoc($qres,$conn);

$rowid = jqGridUtils::Strip($_REQUEST["rowid"]);

$SQL = "SELECT Matricule, DDN_viseo, date_dispo_init, Note_EIA, Pot_valide, mobilite_structu FROM coca_viseo WHERE Matricule = ?";

$prep = jqGridDB::prepare($conn, $SQL, array($rowid));

$qres = jqGridDB::execute( $prep );

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

Kind Regards
Will

Guriddo Support Team

February 8, 2016 at 10:21 pm #124808

Saroumane

Participant

Hello,

Thanks. Your proposition work very well when I declare the “primary key” in the master php file.

Kind Regards,

Saroumane.

Jqgrid PHP 5.1.0

February 9, 2016 at 10:25 am #124814

custom rows detail

Search Forum

Recent Replies

Forum Statistics

UserOnline