sql = " . $sql); $sql_materiel = "select * from materiel order by id_materiel"; $rez_materiel = mysql_query($sql_materiel) or die(mysql_error()); while ($row_mat = mysql_fetch_row($rez_materiel)){ $id_mat = $row_mat[0]; $materiel[$id_mat] = $row_mat[2]; } // tout les contrats, while($row = mysql_fetch_row($result)){ // echo "
"; // var_dump($row); // echo "
"; $id_commande = $row[9]; $id_vendeur = $row[27]; $id_contrat = $row[13]; $mat_cuisine = $row[19]; $mat_van1 = $row[22]; $mat_van2 = $row[25]; $prix = $row[15]; $sql1 = "select * from commande_etapes_production, etapes_production where id_commande = '$id_commande' and commande_etapes_production.id_etape = etapes_production.id_etape order by commande_etapes_production.date_changement desc"; // les etapes de production ... $result1 = mysql_query($sql1) or die(mysql_error . "
sql1 = " . $sql1); // on sort toutes les etapes ... while($row1 = mysql_fetch_assoc($result1)){ //echo "

";
	//var_dump($row1);
	//echo "

"; //exit; $etape = $row1['nom']; $id_etape = $row1['id_etape']; $etat = $row1['etat']; $state[$etape] = $etat; } // echo " = " . $sql1; echo "

";
 var_dump($state);
 echo "

"; // echo ""; // AFFICHAGE // TD Abbrev . vendeur abbrev_vendeur($row); // var_dump($row); // contrat echo case_contrat($id_commande,$id_contrat); // client echo ""; }else{ echo ""; } // # de cuisine if($row[18] > 0){ echo ""; }else{ echo ""; } // materiel cuisne if($row[19] != "Matériel"){ echo ""; }else{ echo ""; } // vanite 1 if($row[21] == "on"){ echo ""; }else{ echo ""; } // materiel vanite 1 if($row[22] != "Matériel"){ echo ""; }else{ echo ""; } // vanite 2 if($row[24] == "on"){ echo ""; }else{ echo ""; } // materiel vanité 2 if($row[25] != "Matériel"){ echo ""; }else{ echo ""; } // date de livraison $date_installation = $row[17]; //format the date for mktime() function -- you need day, month, year $year = substr($date_installation, 0,4); $month = substr($date_installation, 5, 2); $day = substr($date_installation, 8, 2); $jour = date("D", mktime(0, 0, 0, $month, $day, $year)); $mois = date("F", mktime(0, 0, 0, $month, $day, $year)); $jour = getJour($jour); $mois = getMois($mois); $ladate = $jour . ", " . $day . " " . $mois; // $new_date = date("D, Y-m-d", mktime(0, 0, 0, $month, $day, $year)); echo ""; // echo "id_commande = " .$id_commande; // etape commande ... // Get current state of commande, for this job echo ""; // etape stock_en_main ... // Get current state of commande, for this job echo ""; // etape débitage ... // Get current state of commande, for this job echo ""; // etape edgage ... // Get current state of commande, for this job echo ""; // etape special ... // Get current state of commande, for this job echo ""; // etape peinture ... // Get current state of commande, for this job echo ""; // etape montage ... // Get current state of commande, for this job echo ""; // etape preparation echo ""; // etape livraison echo ""; // etape installation $sqlv = "select installeur.id_installeur, installeur.nom, installeur.abbrev from commandes, installeur where id_commande = '$id_commande' and installeur.id_installeur = commandes.id_installeur"; $rezv = mysql_query($sqlv); $rowv = mysql_fetch_assoc($rezv); if($rowv['id_installeur'] > 1){ $html_installation = $rowv['abbrev']; }else{ $html_installation = ""; } echo ""; // etape service echo ""; echo ""; echo ""; } ?>

V e n d e u r	Contrat	Client	C u i s i n e	M a t é r i e l	V a n i t é (l)	M a t e r i e l	V a n i t é (2)	M a t e r i e l	Livraison	C o m m a n d e	A r r i v é	N e s t a g e	D é b i t a g e	E d g a g e	S p é c i a l	P e i n t u r e	M o n t a g e	P r e p a r a t i o n	L i v r a i s o n	I n s t a l l a t i o n	S e r v i c e	P a y e r	Couleur/Teint.	Prix
".$row[1]. " " . $row[2]; if($row[3] != ""){ echo " ( " . $row[3]. ")	".$row[18]."		".$materiel[$mat_cuisine]."				".$materiel[$mat_van1]."				".$materiel[$mat_van2]."		".$ladate."	"; echo "	"; // etape nestage ... // Get current state of commande, for this job // -> $sqlz = "select nesteur.id_nesteur, nesteur.nom, nesteur.abbrev from commandes, nesteur where id_commande = '$id_commande' and nesteur.id_nesteur = commandes.id_nesteur"; $rezz = mysql_query($sqlz); $rowz = mysql_fetch_assoc($rezz); if($rowz['id_nesteur'] > 1){ $html_nesteur = $rowz['abbrev']; }else{ $html_nesteur = ""; } echo "	".$html_nesteur."								".$html_installation."	"; // etape paiement echo "	"; // couleurs echo "	"; if($row[20] !=""){ echo "Cuisine "; } if($row[23] !=""){ echo "Van 1 "; } if($row[26] !=""){ echo "Van 2 "; } echo "	".$prix."