Guriddo » Topic: Subgrid

Subgrid

Guriddo
Subgrid

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

Creator

Topic
October 18, 2016 at 6:42 am #125598

Fcstefoy
Participant

Hello,
Is it possible to insert a sql sequence in a subgrid ?
It’s OK for grid
When I integrates a sql sequence, the update does not work anymore (submit)
Herewith some code
best regards
……
$grid->navigator = true;
$grid->setNavOptions(‘navigator’, array(“excel”=>false,”add”=>false,”edit”=>true,”del”=>false,”view”=>false,”refresh”=>false,”search”=>false));
$grid->setNavOptions(‘edit’,array(“closeAfterEdit”=>true,”reloadAfterSubmit”=>true,”width”=>$width_edit,”height”=>”auto”,”dataheight”=>”auto”, “top”=>$height_intra, “left”=>$left_intra,”editCaption”=>”Mettre à jour le volet Paiement”));
// NavEvent
$grid->setNavEvent(‘edit’, ‘beforeShowForm’, $beforeshow);
$grid->setNavEvent(‘edit’, ‘onInitializeForm’, $initform);
// Enjoy
$subtable = $subtable.”_t”;
$pager = $subtable.”_p”;
//
$sql=$conn->query(“SELECT top_verse, attestation FROM paiement WHERE clef_p = $rowid”);
$sql->setFetchMode(PDO::FETCH_BOTH);
$resultat=$sql->fetch();
$attestation_b=$resultat[‘attestation’];
$top_verse_b=$resultat[‘top_verse’];
if ($top_verse_b == “O” && $attestation_b == 1) {
$form_attestation = <<< FORMATTESTATION
function(){
document.getElementById(‘ID_licencie’).action=’./e_attestation_pdf.php?ed=$rowid’;
document.getElementById(‘ID_licencie’).method=”POST”;
document.getElementById(‘ID_licencie’).target=”_blank”;
document.getElementById(‘ID_licencie’).submit();
}
FORMATTESTATION;
$buttonattestation = array($pager,
array(
“caption”=>”Attestation”,
“onClickButton”=>”js:”.$form_attestation,
“title”=>”Attestation Paiement Pdf”
)
);
$grid->callGridMethod($subtable, “navButtonAdd”, $buttonattestation); }
Creator

Topic

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

Author

Replies

October 18, 2016 at 10:07 am #125599

Fcstefoy

Participant

With debug true :

With SQL sequence
Executed 2 query(s) – 2016-10-18 09:50:19
Array
(
[0] => Array
(
[time] => 2016-10-18 09:50:19
[query] => SELECT COUNT(*) AS COUNTR FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef
[data] => Array
(
[0] => 14377
)
[types] =>
[fields] =>
[primary] =>
[input] =>
)
[1] => Array
(
[time] => 2016-10-18 09:50:19
[query] => SELECT t1.cout_licence, t1.montant_demande, t1.montant_verse, t1.top_mra, t1.date_mra, t1.top_remise, t1.attestation, t1.cout_pass, t1.cout_ancv, t1.cout_autre, t1.versement_1, t1.versement_2, t1.versement_3, t1.versement_4, t1.versement_5, t1.mois_1, t1.mois_2, t1.mois_3, t1.mois_4, t1.mois_5, t1.cheque_1, t1.cheque_2, t1.cheque_3, t1.cheque_4, t1.cheque_5, t1.code_banque, t1.clef_p, t2.clef, t1.annee, t2.codejoueur AS code_licencie, t1.top_verse, t1.forf_mra, t1.forf_pass, t1.forf_ancv, t1.cout_remise, t1.montant_ligue FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef LIMIT 0, 20
[data] => Array
(
[0] => 14377
)[types] =>
[fields] =>
[primary] =>
[input] =>
)
)
Executed 2 query(s) – 2016-10-18 09:50:28
Array
(
[0] => Array
(
[time] => 2016-10-18 09:50:28
[query] => SELECT COUNT(*) AS COUNTR FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef
[data] => Array
(
[0] => 14377
)
[types] =>
[fields] =>
[primary] =>
[input] =>
)
[1] => Array
(
[time] => 2016-10-18 09:50:28
[query] => SELECT t1.cout_licence, t1.montant_demande, t1.montant_verse, t1.top_mra, t1.date_mra, t1.top_remise, t1.attestation, t1.cout_pass, t1.cout_ancv, t1.cout_autre, t1.versement_1, t1.versement_2, t1.versement_3, t1.versement_4, t1.versement_5, t1.mois_1, t1.mois_2, t1.mois_3, t1.mois_4, t1.mois_5, t1.cheque_1, t1.cheque_2, t1.cheque_3, t1.cheque_4, t1.cheque_5, t1.code_banque, t1.clef_p, t2.clef, t1.annee, t2.codejoueur AS code_licencie, t1.top_verse, t1.forf_mra, t1.forf_pass, t1.forf_ancv, t1.cout_remise, t1.montant_ligue FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef LIMIT 0, 20
[data] => Array
(
[0] => 14377
)
[types] =>
[fields] =>
[primary] =>
[input] =>
)
)
Without SQL sequence
Executed 2 query(s) – 2016-10-18 09:54:26
Array
(
[0] => Array
(
[time] => 2016-10-18 09:54:26
[query] => SELECT COUNT(*) AS COUNTR FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef
[data] => Array
(
[0] => 14377
)[types] =>
[fields] =>
[primary] =>
[input] =>
)

[1] => Array
(
[time] => 2016-10-18 09:54:26
[query] => SELECT t1.cout_licence, t1.montant_demande, t1.montant_verse, t1.top_mra, t1.date_mra, t1.top_remise, t1.attestation, t1.cout_pass, t1.cout_ancv, t1.cout_autre, t1.versement_1, t1.versement_2, t1.versement_3, t1.versement_4, t1.versement_5, t1.mois_1, t1.mois_2, t1.mois_3, t1.mois_4, t1.mois_5, t1.cheque_1, t1.cheque_2, t1.cheque_3, t1.cheque_4, t1.cheque_5, t1.code_banque, t1.clef_p, t2.clef, t1.annee, t2.codejoueur AS code_licencie, t1.top_verse, t1.forf_mra, t1.forf_pass, t1.forf_ancv, t1.cout_remise, t1.montant_ligue FROM paiement AS t1, joueur AS t2 WHERE clef_p = ? AND t1.clef_p = t2.clef LIMIT 0, 20
[data] => Array
(
[0] => 14377
)

[types] =>
[fields] =>
[primary] =>
[input] =>
)

)
Executed 1 query(s) – 2016-10-18 09:54:39
Array
(
[0] => Array
(
[time] => 2016-10-18 09:54:39
[query] => SELECT * FROM paiement WHERE 1=2
[data] =>
[types] =>
[fields] =>
[primary] =>
[input] =>
)

)
Executed 2 query(s) – 2016-10-18 09:54:39
Array
(
[0] => Array
(
[time] => 2016-10-18 09:54:39
[query] => SELECT * FROM paiement WHERE 1=2
[data] =>
[types] =>
[fields] =>
[primary] =>
[input] =>
)

[1] => Array
(
[time] => 2016-10-18 09:54:39
[query] => UPDATE paiement SET annee = ?, top_remise = ?, cout_remise = ?, cout_pass = ?, forf_pass = ?, cout_ancv = ?, forf_ancv = ?, cout_autre = ?, top_mra = ?, date_mra = ?, forf_mra = ?, code_banque = ?, versement_1 = ?, versement_2 = ?, versement_3 = ?, versement_4 = ?, versement_5 = ?, cheque_1 = ?, cheque_2 = ?, cheque_3 = ?, cheque_4 = ?, cheque_5 = ?, mois_1 = ?, mois_2 = ?, mois_3 = ?, mois_4 = ?, mois_5 = ?, top_verse = ?, montant_verse = ?, montant_demande = ?, cout_licence = ?, montant_ligue = ?, attestation = ? WHERE clef_p = ?
[data] => Array
(
[0] => 2016
[1] => 0
[2] => 0
[3] => 60
…………..

</form>

October 18, 2016 at 11:30 am #125602

guriddo.support

Participant

Hello,

Check your code again. See the errors setting at top of the php script

ini_set("display_errors",1);
...

ini_set("display_errors",1);

...

Maybe when update is in action some variable in your script are not set causing the update to stop.

My suggestion is to check if your variables from the sentence are set

...
resultat=$sql->fetch();
$attestation_b= isset($resultat[‘attestation’]) ? $resultat[‘attestation’] : "";
$top_verse_b=isset($resultat[‘top_verse’]) ? $resultat[‘top_verse’] : "";
if ($top_verse_b == “O” && $attestation_b == 1) {
...

...

resultat=$sql->fetch();

$attestation_b= isset($resultat[‘attestation’]) ? $resultat[‘attestation’] : "";

$top_verse_b=isset($resultat[‘top_verse’]) ? $resultat[‘top_verse’] : "";

if ($top_verse_b == “O” && $attestation_b == 1) {

...

Hope you get the point.

Kind Regards,
Will

Guriddo Support Team

October 18, 2016 at 3:43 pm #125605

Fcstefoy

Participant

Hello,

Thank you for your reply.

I simply changed the syntax of the query :

$sql=$conn->query(“SELECT top_verse, attestation FROM paiement WHERE clef_p = $rowid”);

replaced by

$sql=$conn->query(“SELECT top_verse, attestation FROM paiement WHERE clef_p = ‘$rowid'”);

And now it’s OK.

Best regards

Author

Replies

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

You must be logged in to reply to this topic.

Registered Users: 12,249
Forums: 7
Topics: 10,947
Replies: 23,146
Topic Tags: 324
Empty Topic Tags: 9

12 Users Online

Users: 1 Guest, 11 Bots

Stay connected with us in your favorite flavor!

Subgrid

Search Forum

Recent Replies

Forum Statistics

UserOnline