</tr> <tr> <th rowspan="2">Catégorie</th> <th rowspan="2">Type</th> <th colspan="' . $nbPeriodes . '">Période</th> </tr> <tr>'; // RECUP CATYPE 'A1' 'A3' etc + libelle type $stmtCatype = retourneStatementSelect('SELECT CONCAT(lettre, num) as catype, libelle FROM type'); while ($resultatCatype = $stmtCatype->fetch(PDO::FETCH_ASSOC)) { $catypes['ID'][] = $resultatCatype['catype']; $catypes[$resultatCatype["catype"]] = $resultatCatype['libelle']; } $stmtCatype = null; // RECUP LES ID PERIODE $stmtPeriode = retourneStatementSelect('SELECT * FROM periode'); while ($resultatPeriode = $stmtPeriode->fetch(PDO::FETCH_ASSOC)) { $lignes .= '<td>' . setDateFormatLecture($resultatPeriode['datedeb']) . ' au ' . setDateFormatLecture($resultatPeriode['datefin']) . '</td>'; $periodes[] = $resultatPeriode['idperiode']; } $stmtPeriode = null; $lignes .= ' </tr>'; // <td rowspan="3">A <span class="pc">- Passager</span></td> // <td>1 <span class="pc">- Adulte</span></td> foreach ($catypes['ID'] as $CATYP) { $lignes .= '<tr>'; switch ($CATYP) { case 'A1': $lignes .= '<td rowspan="3">A <span class="pc">- Passager</span></td> <td>1 <span class="pc">- ' . $catypes[$CATYP] . '</span></td>'; break;
<div class="form-group"> <div> <label for="select_liaison" control-label">Liaison effectuée</label> <select class="form-control" name="select_liaison" id="select_liaison">'; $stmt = retourneStatementSelect('SELECT code, idportdepart, idportarrivee FROM liaison'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignes .= ' <option value="' . $resultat['code'] . '">' . returnNomLiaison($resultat['idportdepart'], $resultat['idportarrivee']) . '</option>'; } $lignes .= ' </select> </div> </div> <div class="form-group"> <div> <label for="select_bateau" control-label">Bateau utilisé</label> <select class="form-control" name="select_bateau" id="select_bateau">'; $stmt = retourneStatementSelect('SELECT idbateau, nom FROM bateau'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignes .= ' <option value="' . $resultat['idbateau'] . '">' . $resultat['nom'] . '</option>'; } $lignes .= ' </select> </div> </div> <div> <button type="" class="btn btn-primary">Valider</button> </div> </fieldset><br> <span id="crea_traversee_msg"></span> </form>'; echo $lignes;
</div> <div class="form-group"> <div> <label for="select_periode" control-label">Période</label> <select class="form-control" name="select_periode" id="select_periode">'; $stmtPeriode = retourneStatementSelect('SELECT idperiode FROM periode'); while ($resultatPeriode = $stmtPeriode->fetch(PDO::FETCH_ASSOC)) { $lignes .= ' <option value="' . $resultatPeriode['idperiode'] . '">' . returnNomPeriode($resultatPeriode['idperiode']) . '</option>'; } $lignes .= ' </select> </div> </div>'; $stmtCategories = retourneStatementSelect('SELECT lettre, nom FROM categorie'); while ($resCategories = $stmtCategories->fetch(PDO::FETCH_ASSOC)) { $stmtTypes = retourneStatementSelect('SELECT lettre, num, libelle FROM type WHERE lettre="' . $resCategories['lettre'] . '"'); while ($resTypes = $stmtTypes->fetch(PDO::FETCH_ASSOC)) { $lignes .= '<div class="form-group"> <label for="' . $resCategories['lettre'] . '-' . $resTypes['num'] . '-input_tarif" control-label">' . $resCategories['nom'] . ' / ' . $resTypes['libelle'] . '</label> <div> <input type="number" class="form-control tarif" cat="' . $resCategories['lettre'] . '" typ="' . $resTypes['num'] . '" name = "' . $resCategories['lettre'] . '-' . $resTypes['num'] . '-input_tarif" id="' . $resCategories['lettre'] . '-' . $resTypes['num'] . '-input_tarif" value=""> </div> </div>'; } } $lignes .= ' <div> <button type="" class="btn btn-primary">Valider</button> </div> </fieldset><br> <span id="crea_tarif_msg"></span>
<input type="text" placeholder="15/06/2016" class="form-control" name = "input_datefin" id="input_datefin" value="' . setDateFormatLecture($DFIN) . '"> </div> </div> <div> <button class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_periode_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un periode à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT idperiode, datedeb, datefin FROM periode'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['idperiode'] . '">' . setDateFormatLecture($resultat['datedeb']) . ' - ' . setDateFormatLecture($resultat['datefin']) . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
$lignes .= '<div class="bloc_reservation" style="clear:both">'; $lignes .= '<br><br><span><b>' . $resultat['nom'] . '</b>, réservation du <b>' . setTimestampFormatLecture($resultat['dateEnregistrement']) . '</b></span>'; $lignes .= '<br>' . $resultat['adresse'] . ' ' . $resultat['cp'] . ' ' . $resultat['ville'] . '<br>'; $stmtTraversee = retourneStatementSelect('Select dateTraversee, heure, idliaison, idbateau From traversee WHERE num =' . $resultat['idtraversee']); while ($resultatTraversee = $stmtTraversee->fetch(PDO::FETCH_ASSOC)) { $lignes .= 'Réservation pour le ' . setDateFormatLecture($resultatTraversee['dateTraversee']) . ' à ' . $resultatTraversee['heure']; $stmtLiaison = retourneStatementSelect('Select code, idsecteur, idportdepart, idportarrivee, distance From liaison WHERE code =' . $resultatTraversee['idliaison']); while ($resultatLiaison = $stmtLiaison->fetch(PDO::FETCH_ASSOC)) { $lignes .= ' pour la liaison ' . returnNomLiaison($resultatLiaison['idportdepart'], $resultatLiaison['idportarrivee']); } } $lignes .= '<br><table class="table table-striped><thead colspan="8"><b>Places</b></thead><tbody>'; $lignes .= '<tr>'; $stmtTickettes = retourneStatementSelect('Select lettre, num, quantite From enregistrer WHERE idreservation =' . $resultat['idreservation']); while ($resultatTickettes = $stmtTickettes->fetch(PDO::FETCH_ASSOC)) { $lignes .= '<th>' . $resultatTickettes['lettre'] . $resultatTickettes['num'] . '</th>'; } $lignes .= '</tr><tr>'; $stmtTickettes = retourneStatementSelect('Select lettre, num, quantite From enregistrer WHERE idreservation =' . $resultat['idreservation']); while ($resultatTickettes = $stmtTickettes->fetch(PDO::FETCH_ASSOC)) { if ($resultatTickettes['quantite'] == 0) { $lignes .= '<td>-</td>'; } else { $lignes .= '<td>' . $resultatTickettes['quantite'] . '</td>'; } } $lignes .= '</tr>'; $lignes .= '</tbody></table>'; $lignes .= '</div>'; } echo $lignes;
<input type="text" class="form-control" name = "input_dist" id="input_dist" value="' . $Dist . '"> </div> </div> <div> <button class="btn btn-blueish">Valider</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_liaison_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un liaison à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT code, idsecteur, idportdepart, idportarrivee, distance FROM liaison'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['code'] . '">' . $resultat['code'] . ' - ' . returnNomLiaison($resultat['idportdepart'], $resultat['idportarrivee']) . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
<input type="text" class="form-control" name = "input_poidsMaxFret" id="input_poidsMaxFret" value="' . $PDSMAX . '"> </div> </div> <div> <button type="submit" class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_bateau_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un bateau à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT idbateau, nom, longueurBat, largeurBat, heritage FROM bateau'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['idbateau'] . '">' . $resultat['nom'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
<input type="text" class="form-control" name = "input_nom" id="input_nom" value="' . $NOM . '"> </div> </div> <div> <button type="" id="upd_choixSect" class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_port_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un port à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT idport, nom FROM port'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['idport'] . '">' . $resultat['nom'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
</fieldset><br> <span id="updt_bateau_cptmax"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un bateau à modifier pour une catégorie</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT idbateau, nom, longueurBat, largeurBat, heritage FROM bateau WHERE heritage=0'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['idbateau'] . '">' . $resultat['nom'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div class="form-group"> <select class="form-control" name="select_ChoixCat" id="select_ChoixCat">'; $stmt = retourneStatementSelect('SELECT lettre, nom FROM categorie'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['lettre'] . '">' . $resultat['lettre'] . ' - ' . $resultat['nom'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
</select> </div> </div> <div> <button type="" id="upd_choixTraversee" class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="crea_traversee_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez une traversee à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT num FROM traversee ORDER BY num'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['num'] . '">' . $resultat['num'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
if ($resultatAction['type_action'] == $ACTION) { $selected = 'selected="selected"'; } else { $selected = ""; } $lignesFormChoix .= ' <option ' . $selected . ' value="' . $resultatAction['type_action'] . '">' . $resultatAction['type_action'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" id="choixAction" class="btn btn-blueish" style="margin-bottom:30px;">Valider</button> </div> </fieldset> <div class="col-lg-4"></div> </form>'; $lignes = $lignesFormChoix; /****** affichage des modifications *****/ $stmt = retourneStatementSelect('SELECT idmodif, iduser, nom_prenom, table_modifiee, action, donnees, date_modif FROM modifications ' . $WHERE . ' ORDER BY idmodif DESC'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignes .= '<div class="bloc_reservation" style="clear:both">'; $lignes .= '<br><span><b>' . $resultat['nom_prenom'] . '</b>, modification du <b>' . setTimestampFormatLecture($resultat['date_modif']) . '</b></span>'; $lignes .= '<br>sur la table "' . $resultat['table_modifiee'] . '" a été opérée une action de <b>' . $resultat['action'] . '</b> avec les données suivantes :<br><br>'; // .$resultat['donnees'].'<br>' ; foreach (json_decode($resultat['donnees']) as $key => $value) { if ($key != "CHAMPS_ID") { $lignes .= '[' . $key . ']' . ' => ' . $value . '<br>'; } } $lignes .= '<br></div>'; } echo $lignes;
<input type="text" class="form-control" name = "input_libequip" id="input_libequip" value="' . $libequip . '"> </div> </div> <div> <button type="" id="upd_choixSect" class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_equipement_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un equipement à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT idequip, libequip FROM equipement'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['idequip'] . '">' . $resultat['libequip'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
<input type="text" class="form-control" name = "input_nom" id="input_nom" value="' . $NOM . '"> </div> </div> <div> <button type="" id="upd_choixSect" class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_secteur_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un secteur à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT idsecteur, nom FROM secteur'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['idsecteur'] . '">' . $resultat['nom'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }
function recupLastInsertBat($data) { $ID = ""; $sql = "SELECT idbateau From bateau WHERE nom= '" . $data['params']['nom'] . "'"; $stmt = retourneStatementSelect($sql); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $ID = $resultat['idbateau']; } $stmt = null; return $ID; }
<input type="text" class="form-control" name = "input_droit" id="input_droit" value="' . $droit . '"> </div> </div> <div> <button type="" id="upd_choixMembre" class="btn btn-blueish">Mettre à jour</button> <a id="del_choix" class="btn btn-reddish">Supprimer</a> </div> </fieldset><br> <span id="updt_membre_msg"></span> <span id="del_msg"></span> </form>'; echo $lignes; } else { /**** FORM SELECT ID ******/ $lignesFormChoix = '<form method="post" class="form-horizontal"> <legend>Choisissez un membre à modifier</legend> <fieldset class="col-lg-4"> <div class="form-group"> <select class="form-control" name="select_Choix" id="select_Choix">'; $stmt = retourneStatementSelect('SELECT id, nom, prenom FROM membre'); while ($resultat = $stmt->fetch(PDO::FETCH_ASSOC)) { $lignesFormChoix .= ' <option value="' . $resultat['id'] . '">' . $resultat['nom'] . ' ' . $resultat['prenom'] . '</option>'; } $lignesFormChoix .= ' </select> </div> <div> <button type="submit" class="btn btn-blueish">Modifier cet élément</button> </div> </form>'; echo $lignesFormChoix; }