<?php
$page_id=27;
$mysqli=new sqlite3('admin_lgos/bdd_lgos.sq3');
include ('config.php');
include ('html1.php');
include ('topbar.php');
include ('navbar.php');
include ('header2.php');
$idl=0;
//on va chercher les infos de l'rubrique
$articles=$mysqli->query("SELECT * FROM $table_ltar WHERE id='$id'");
while($row=$articles->fetchArray()){
$idl=$row['id'];
$numera=$row['numero'];
$lifen=$row['lifen'];
$date=$row['date'];
$expediteura=$row['expediteur'];
$adresse_e=$row['adresse_e'];
$telephone_e=$row['telephone_e'];
$destinateura=$row['destinateur'];
$adresse_d=$row['adresse_d'];
$telephone_bureau=$row['telephone_bureau'];
$poidsa=$row['poids'];
$montanta=$row['montant'];
$port=$row['port'];
$situation=$row['situation'];
$observations=$row['observations'];
$date_reception=$row['date_reception'];
$nom_reception=$row['nom_reception'];
$telephone_reception=$row['telephone_reception'];
$moda_emballage=(int)$row['moda_emballage'];
$expediteura=stripslashes($expediteura);
$adresse_e=stripslashes($adresse_e);
$destinateura=stripslashes($destinateura);
$adresse_d=stripslashes($adresse_d);
$port=stripslashes($port);
$situation=stripslashes($situation);
$observations=stripslashes($observations);
$nom_reception=stripslashes($nom_reception);
}
if($idl==0){
echo "<META http-equiv=\"refresh\" content=\"0; URL=?p=lta_gestion\">";
exit;
}
echo "$page11<h3>LTA \"$numera\" <a href='tracking.php?o=$numera' title='Voir'>$img_voir</a></h3>";
if(!isset($_POST["action"])){$action="";}else{$action=$_POST["action"];}
if($action=="Ajouter" OR $action=="Modifier" OR $action=="Supprimer"){
if(!isset($_POST["idt"])){$idt=0;}else{$idt=$_POST["idt"];}
if($action=="Supprimer"){
$sql="DELETE FROM $table_track WHERE id='$idt' and colis=$idl";
//$resucolist=$mysqli->query($sql);
$noteok="Track supprim&eacute;!";
}else{
$mouvementa=$_POST["mouvement"];
$lieua=$_POST["lieu"];
$date=$_POST["date"];
$heura=$_POST["heure"];
if($mouvementa=="" || $lieua=="" || $date=="" || $heura==""){
$noteko="Vous n'avez soit pas rempli tous les champs, soit pas selectionn&eacute; lemouvement ou le lieu! 
<a href=?p=colis_voir&id=$idl>Retour</a>";
}else{
if($idt==0){
//Insertion du message
$requete="INSERT INTO $table_track (temps,  idu, colis, mouvement, lieu, date, heure) VALUES ('$temps', '$idu', '$idl', '$mouvementa', '$lieua', '$date', '$heura');";
$resucolist=$mysqli->query($requete);
$noteok="Track ajout&eacute;!";
}else{
//Modification du message
$sql="UPDATE $table_track SET mouvement='$mouvementa', lieu='$lieua', date='$date', heure='$heura' WHERE id='$idt'";
$resucolist=$mysqli->query($sql);
$noteok="Track modifi&eacute;!";
}
}
}
include ('oko.php');
echo "<META http-equiv=\"refresh\" content=\"$tempsrr; URL=?p=colis_voir&id=$idl\">";
}else{
echo "<div class='form-row'>
<div class='col-lg-6'>Life n &#176; : $lifen</div>
<div class='col-lg-6'>Date : $date</div>
<div class='col-lg-12'>Exp&eacute;diteur : $expediteura</div>
<div class='col-lg-8'>Adresse Exp&eacute;diteur : $adresse_e</div>
<div class='col-lg-4'>$Telephone Exp&eacute;diteur : $telephone_e</div>
<div class='col-lg-12'>Destinateur : $destinateura</div>
<div class='col-lg-8'>Adresse destinateur : $adresse_d</div>
<div class='col-lg-4'>$Telephone Bureau : $telephone_bureau</div>
<div class='col-lg-12'>Colis </div>";
$req_res=$mysqli->query("SELECT * FROM $table_track where colis=$idl");
echo "$table<tr>";
$lll[1]="Id";
$lll[2]="Mouvement";
$lll[3]="Lieu";
$lll[4]="Date";
$lll[5]="Heure";
for($x=2;$x<6;$x++){echo"<th align=center>$lll[$x]</th>";}
echo "<th colspan=2>Actions</th></tr>";
while($row=$req_res->fetchArray()){
$id=$row['id'];
$mouvementa= $row['mouvement'];
$lieua= $row['lieu'];
$date=$row['date'];
$heura=$row['heure'];
//On remplit le tableau
echo "<tr>
<form method=\"POST\" action=\"?id=$idl\">
<input name=\"idt\" type=\"hidden\" value=\"$id\">
<td align=right>
<select name='mouvement' style='width:100%;' required>
<option value=''>$Selectionnez</option>";
for($x=11;$x<=$mouvement_nbre;$x++){
$chk=selected($x,$mouvementa);
echo "<option value='$x' $chk>$mouvement_tab[$x]</option>"; }
echo"</select>
</td>
<td align=right>
<select name='lieu' style='width:100%;' required>
<option value=''>$Selectionnez</option>";
for($x=11;$x<=$destination_nbre;$x++){
$chk=selected($x,$lieua);
echo "<option value='$x' $chk>$Destination_tab[$x]</option>"; }
$action="<td colspan=2></td>";
if($ok==1){$action="<td align=center><input type=\"submit\" name=\"action\" value=\"Modifier\"></td>
<td align=center><input type=\"submit\" name=\"action\" value=\"Supprimer\"></td>";}
echo"</select></td>
<td align=right><input type=\"date\" name=\"date\" value=\"$date\" style='width:100%;' required></td>
<td align=right><input type=\"time\" name=\"heure\" value=\"$heura\" style='width:100%;' required></td>
$action
</tr></form>";
}
echo "<tr>
<form method=\"POST\" action=\"?id=$idl\">
<td align=right>
<select name='mouvement' style='width:100%;' required>
<option value=''>$Selectionnez</option>";
for($x=11;$x<=$mouvement_nbre;$x++){
echo "<option value='$x'>$mouvement_tab[$x]</option>"; }
echo"</select></td>
<td align=right>
<select name='lieu' style='width:100%;' required>
<option value=''>$Selectionnez</option>";
for($x=11;$x<=$destination_nbre;$x++){
echo "<option value='$x'>$Destination_tab[$x]</option>"; }
echo"</select></td>
<td align=right><input type=\"date\" name=\"date\" style='width:100%;' required></td>
<td align=right><input type=\"time\" name=\"heure\" style='width:100%;' required></td>
<td align=center colspan=2><input type=\"submit\" name=\"action\" value=\"Ajouter\"></td>
</tr></form>";
//Fermeture du tableau
echo "</table>";
}
echo"$page12";
unset($mysqli);
include ('footer.php');
include ('html2.php');
?>