Locs - Locs - Locs

[', '

]
', '
A
', '
B
', '
C
' , '
D
' , '
E
','
M
','
S
','
T
','
V
','
W
','
F
','
G
','
I
','
N
','
L
','
X
','
P
','
R
','
Z
','
U
','
K
','
O
','
Y
','
H
'); $essieusearch = array("'","+"); $essieureplace = array('y','z'); $attrib = array("0", "2", "3", "4", "5", "6", "7", "8", ""); $image = ""; // $conn = ""; $nbsouscat = ""; $nborigcat = ""; $hactype = 0; $haccompany = 0; $indextype = array(); $hactypeconst = 0; $indextypeconst = array(); $hacconstructeur = 0; $indexconstructeur = array(); $indexconstructeur[0] = "Unknown"; $hacetranger = 0; $indexetranger = array(); $indexetranger[0] = "Unknown"; // $req_augmenterdownload = "UPDATE download_ts SET downloaded = (downloaded+1), last_download = '".time()."' WHERE filename='locs';"; // $result = mysqli_query($conn, $req_augmenterdownload); // $requete= "INSERT INTO `rep_visitors` (`numero`, `ip`, `zoek`, `datum`) VALUES (0, '" . $_SERVER["REMOTE_ADDR"] . "', '" . $_SERVER["HTTP_USER_AGENT"] ."', CURRENT_TIMESTAMP);"; // echo $_SERVER["REMOTE_ADDR"]; // mysqli_query($conn, $requete) or die($requete.'
'.mysqli_error($conn)); $requete= "SELECT * FROM rep_machines " ; $reponse=mysqli_query( $conn, $requete); $donnees = mysqli_num_rows($reponse); echo '

Nombre d' . "'" . 'engins moteurs : ' . number_format($donnees, 0, ",", ".") . "

" . "\n" ; echo '
LOCS - LOCS - LOCS
'; echo 'Rechercher' . "\n" ; echo '
' . "\n" ; echo '
'; echo ''; echo '
' . "\n" ; $requete= "SELECT distinct `rep_relations`.`N_Type` FROM rep_relations ORDER BY `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indextypeconst[$hactypeconst] = trim(utf8($donnees['N_Type'])); $hactypeconst = $hactypeconst + 1 ; } // $requete= "SELECT distinct `rep_relations`.`N_Company`, `rep_relations`.`N_Type` FROM rep_relations WHERE `rep_relations`.`N_Company` <> 'Exportations' and `rep_relations`.`N_Company` <> 'Industrie' and `rep_relations`.`N_Company` <> '" . encodeToUtf8('Chaudière') . "' and `rep_relations`.`N_Company` <> '" . encodeToUtf8('Etranger') . "' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company`, `rep_relations`.`N_Type` FROM rep_relations WHERE `rep_relations`.`N_Category` = 'Belgique' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $company=""; echo '
'; while ($donnees = mysqli_fetch_array($reponse) ) { if ($company != utf8($donnees['N_Company']) ) { echo '
' . "\n" ; $company = utf8($donnees['N_Company']); $haccompany = $haccompany + 1; $hactype = 0; echo '
Tout ' . utf8($donnees['N_Company']) . '' . "\n" ; } $indextype[$haccompany . '@' . $hactype] = utf8($donnees['N_Company']) . '@' . utf8($donnees['N_Type']); // echo '
' . utf8($donnees['N_Company']) . ' - ' . utf8($donnees['N_Type']) . '' . "\n" ; // echo '
' . utf8($donnees['N_Company']) . ' - ' . utf8($donnees['N_Type']) . '' . "\n" ; echo '
' . utf8($donnees['N_Type']) . '' . "\n" ; $hactype = $hactype + 1 ; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`Constructeur` FROM rep_machines ORDER BY `rep_machines`.`Constructeur` ASC" ; $requete= "SELECT `Test2`.`Constructeur` FROM (SELECT DISTINCT `rep_machines`.`Constructeur`, '" . utf8_none('Chaudière') . "' as `Type_FR` FROM rep_machines UNION SELECT DISTINCT `Test`.`Type_NL`, `Test`.`Type_FR` FROM rep_events AS `Test`) AS `Test2` WHERE `Test2`.`Type_FR` LIKE 'Chaudi%' and `Test2`.`Constructeur` <>'' ORDER BY `Test2`.`Constructeur`ASC;" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['Constructeur']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; // echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`Constructeur` FROM rep_machines WHERE `rep_machines`.`K_Company` = 'Etranger' ORDER BY `rep_machines`.`Constructeur` ASC" ; // $reponse=mysqli_query($conn, $requete); // test_requete($reponse,$conn); // while ($donnees = mysqli_fetch_array($reponse) ) // { // $indexetranger[$hacetranger] = utf8($donnees['Constructeur']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; // $hacetranger = $hacetranger + 1; // } // echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = 'Industrie' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = 'Vicinal' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = 'Urbain' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = '" . utf8_none('Musée') . "' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = '" . utf8_none('Musées') . "' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = '" . utf8_none('Private') . "' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = '" . utf8_none('Chaudière') . "' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Exportations' ORDER BY `rep_machines`.`N_Type` ASC" ; // $requete= "SELECT distinct `rep_relations`.`K_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`K_Category` = 'Exportation' ORDER BY `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`K_Category`, `rep_relations`.`K_Company` FROM rep_relations WHERE `rep_relations`.`K_Category` = 'Exportation' ORDER BY `rep_relations`.`K_Company` ASC;" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['K_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['K_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = 'Etranger' ORDER BY `rep_relations`.`N_Company` ASC;" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; echo '
' . "\n" ; // $requete= "SELECT distinct `rep_machines`.`N_Type` FROM rep_machines WHERE `rep_machines`.`N_Company` = 'Industrie' ORDER BY `rep_machines`.`N_Type` ASC" ; $requete= "SELECT distinct `rep_relations`.`N_Category`, `rep_relations`.`N_Company` FROM rep_relations WHERE `rep_relations`.`N_Category` = 'Inconnu' ORDER BY `rep_relations`.`N_Company` ASC;" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexconstructeur[$hacconstructeur] = utf8($donnees['N_Company']); // echo '
' . utf8($donnees['Constructeur']) . '' . "\n" ; echo '
' . utf8($donnees['N_Company']) . '' . "\n" ; $hacconstructeur = $hacconstructeur + 1; } echo '
'; // echo '
';
//					print_r($indexconstructeur);
//					echo '
'; echo '
' . "\n" ; echo '
Accidents / Incendies / Actes criminels par date' . "\n" ; echo '
Accidents / Incendies / Actes criminels par localisation' . "\n" ; echo '
Affectation des locomotives en 1914-1918' . "\n" ; echo '
Attribution Série 13' . "\n" ; echo '
Attribution Série 77' . "\n" ; echo '
Blanc-Misseron' . "\n" ; echo '
Cabines Type 40' . "\n" ; echo '
Codes-Radio' . "\n" ; echo '
Commission Alliée des Réparations' . "\n" ; echo '
Concours' . "\n" ; echo '
Constructeurs par Type/Constructeur' . "\n" ; echo '
Convention Eupen-Malmedy' . "\n" ; echo '
Decauville' . "\n" ; echo '
Disposition des essieux' . "\n" ; echo '
Echappement Giesl' . "\n" ; echo '
Essais' . "\n" ; echo '
Expositions' . "\n" ; echo '
Faits de guerre' . "\n" ; echo '
Festivals' . "\n" ; echo '
Inaugurations' . "\n" ; echo '
Livrées Série 62' . "\n" ; echo '
Locomotives classées Monument Historique (France)' . "\n" ; echo '
Locomotives dans le cinéma' . "\n" ; echo '
Locomotives dédiées par l'Armée Américaine en 1945' . "\n" ; echo '
Locomotives emmenées lors de la retraite de septembre 1944' . "\n" ; echo '
Locomotive emmenée lors de l'offensive des Ardennes en décembre 1944' . "\n" ; echo '
Locomotives identifiées en France en 1945, 1946 et 1947' . "\n" ; echo '
Locomotives non-identifiées' . "\n" ; echo '
Locomotives prêtées à l'Allemagne (Leihloks)' . "\n" ; echo '
Leihloks retrouvées aux Pays-Bas' . "\n" ; echo '
Locomotives restituées en 1950 à la DB' . "\n" ; echo '
Locomotives restituées en 1950 par la DB' . "\n" ; echo '
Machines préservées' . "\n" ; echo '
Mise hors écriture vapeurs de 1946 à 1967' . "\n" ; echo '
Moteurs Diesel' . "\n" ; echo '
Numéros d'agrément' . "\n" ; echo '
Noms des premières locomotives' . "\n" ; echo '
Pelliculage' . "\n" ; echo '
Plaques constructeur (et autres)' . "\n" ; echo '
Prises de guerre' . "\n" ; echo '
PV de radiation' . "\n" ; echo '
Recensement du 20 septembre 1944' . "\n" ; echo '
Records' . "\n" ; echo '
Registre des épreuves' . "\n" ; echo '
Remises' . "\n" ; echo '
Répartition par remise en 1951' . "\n" ; echo '
Répartition par remise en 1956' . "\n" ; echo '
Schöma' . "\n" ; echo '
Statistiques Exportations par pourcentage' . "\n" ; echo '
Statistiques Exportations par pays' . "\n" ; echo '
Surnoms' . "\n" ; echo '
Surnoms des TRAXX' . "\n" ; echo '
Tableaux par remise' . "\n" ; echo '
Tableaux par série/type' . "\n" ; echo '
' . "\n" ; if (isset($_POST['cherche']) and ($_POST['cherche'] != "")) { $post_cherche=preg_replace('/[^0-9 \.\-]/', '', $_POST['cherche']); // echo $post_cherche; // $post_cherche=intval(validate_data($_POST['cherche'])); $requete= "INSERT INTO `rep_visitors` (`numero`, `ip`, `zoek`, `datum`) VALUES (0, '" . $_SERVER["REMOTE_ADDR"] . "', '" . $post_cherche ."', CURRENT_TIMESTAMP);"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); // if (is_numeric($post_cherche)) // { // recherche numero machine $requete= "SELECT * FROM rep_relations WHERE (`rep_relations`.`N_Number` like '%" . $post_cherche . "%') order by `rep_relations`.`N_Category` ASC, `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Number` ASC, `rep_relations`.`N_Identifier` ASC, `rep_relations`.`N_Type` ASC ;" ; // $requete= "SELECT * FROM rep_relations WHERE (`rep_relations`.`N_Number` like '%" . $post_cherche . "%') and (`rep_relations`.`N_Company` <> '" . encodeToUtf8('Chaudière') . "') order by `rep_relations`.`N_Company` ASC, `rep_relations`.`N_Number` ASC, `rep_relations`.`N_Identifier` ASC, `rep_relations`.`N_Type` ASC ;" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $company=""; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ( (strlen(utf8($donnees['N_Number'])) <= strlen($post_cherche)) or (utf8($donnees['N_Number']) == '(' . $post_cherche . ')') or (utf8($donnees['N_Number']) == '[' . $post_cherche . ']') or (utf8($donnees['N_Number']) == 'WD ' . $post_cherche) or (utf8($donnees['N_Number']) == 'WD [' . $post_cherche . ']') or (utf8($donnees['N_Number']) == 'ES ' . $post_cherche) or (utf8($donnees['N_Number']) == 'VV ' . $post_cherche) ) { if (utf8($donnees['N_Category']) <> $company) { echo '' . "\n"; $company=utf8($donnees['N_Category']); } $requete1= 'SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = "' . $donnees['K_Company'] . '" and `rep_machines`.`K_Number` = "' . $donnees['K_Number'] . '" and `rep_machines`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") ;' ; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); echo '' . "\n" ; // $nblignes = $nblignes + 1; } } // recherche numero constructeur // $requete= "SELECT * FROM rep_machines WHERE (`rep_machines`.`Fab_Number` like '%" . $post_cherche . "%') order by `rep_machines`.`Constructeur` ASC, `rep_machines`.`Fab_Number` ASC ;" ; // $requete= 'SELECT * FROM (SELECT `rep_machines`.`Constructeur`, `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_machines`.`Fab_Number`, "' . encodeToUtf8("Chaudière") . '" as `Chaud` FROM rep_machines UNION select `rep_events`.`Type_NL`, `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Event`,`rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE (`Test`.`Chaud` = "' . encodeToUtf8("Chaudière") . '" and `Test`.`Fab_Number` like "%' . $post_cherche . '%") ORDER BY `Test`.`Constructeur` ASC ;' ; // $requete= 'SELECT * FROM (SELECT `rep_machines`.`Constructeur`, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_machines`.`Fab_Number`, "' . encodeToUtf8("Chaudière") . '" as `Chaud` FROM rep_machines UNION select `rep_events`.`K_Company`,`rep_events`.`Type_NL`, `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Event`,`rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE (`Test`.`Chaud` = "' . encodeToUtf8("Chaudière") . '" and `Test`.`Fab_Number` like "%' . $post_cherche . '%") ORDER BY `Test`.`Constructeur` ASC ;' ; $requete= 'SELECT * FROM (SELECT `rep_machines`.`Constructeur`, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_machines`.`Fab_Number`, "' . encodeToUtf8("Chaudière") . '" as `Chaud` FROM rep_machines UNION select `rep_events`.`K_Company`,`rep_events`.`Type_NL`, `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Event`,`rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE ((`Test`.`Chaud` = "' . utf8_PC_none("Chaudière") . '" or `Test`.`Chaud` = "' . utf8_PC_none("Numéro de Construction") . '") and `Test`.`Fab_Number` like "%' . $post_cherche . '%") ORDER BY `Test`.`Constructeur` ASC ;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = 0; $constructeur=""; while ($donnees = mysqli_fetch_array($reponse) ) { if ( (strlen(utf8($donnees['Fab_Number'])) <= strlen($post_cherche)) or (utf8($donnees['Fab_Number']) == '(' . $post_cherche . ')') ) { if ($nblignes == 0) { echo '' . "\n"; echo ''; $nblignes = 1; } if (utf8($donnees['Constructeur_Reel']) <> $constructeur) { echo '' . "\n"; $constructeur=utf8($donnees['Constructeur_Reel']); } echo '' . "\n" ; } } // recherche numero tender $requete= "SELECT * FROM rep_machines_tenders WHERE (`rep_machines_tenders`.`T_Number` like '%" . $post_cherche . "%') ;" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = 0; while ($donnees = mysqli_fetch_array($reponse) ) { if ( (strlen(utf8($donnees['T_Number'])) <= strlen($post_cherche)) or (utf8($donnees['T_Number']) == '(' . $post_cherche . ')') ) { if ($nblignes == 0) { echo '' . "\n"; echo ''; $nblignes = 1; } echo '' . "\n" ; } } // recherche registre des épreuves $requete= "SELECT * FROM rep_events WHERE (`rep_events`.`Event` like '%" . $post_cherche . "%' and `rep_events`.`Type_FR` = '" . utf8_PC_none('Registre des épreuves') . "') order by `rep_events`.`Type_NL` ASC, `rep_events`.`Event` ASC ;" ; // $requete= 'SELECT * FROM (SELECT `rep_machines`.`Constructeur`, `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_machines`.`Fab_Number`, "' . encodeToUtf8("Chaudière") . '" as `Chaud` FROM rep_machines UNION select `rep_events`.`Type_NL`, `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Event`,`rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE (`Test`.`Chaud` = "' . encodeToUtf8("Chaudière") . '" and `Test`.`Fab_Number` like "%' . $post_cherche . '%") ORDER BY `Test`.`Constructeur` ASC ;' ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = 0; $province=""; while ($donnees = mysqli_fetch_array($reponse) ) { if ( (strlen(utf8($donnees['Event'])) <= strlen($post_cherche)) or (utf8($donnees['Event']) == '(' . $post_cherche . ')') ) { if ($nblignes == 0) { echo '' . "\n"; echo ''; $nblignes = 1; } if (utf8($donnees['Type_NL']) <> $province) { echo '' . "\n"; $province=utf8($donnees['Type_NL']); } echo '' . "\n" ; } } // recherche locomotives non identifiées // // $requete= "SELECT * FROM rep_unindentified WHERE (`rep_unindentified`.`K_Number` like '%" . $post_cherche . "%') order by `rep_unindentified`.`K_Company` ASC, `rep_unindentified`.`K_Number` ASC, `rep_unindentified`.`K_identifier` ASC ;" ; // $reponse=mysqli_query($conn, $requete); // test_requete($reponse,$conn); // $nblignes = mysqli_num_rows($reponse); // if ($nblignes > 0) { // echo '' . "\n"; // echo ''; // } // $nblignes = 0; // $constructeur=""; // while ($donnees = mysqli_fetch_array($reponse) ) // { // if ( (strlen(utf8($donnees['N_Number'])) <= strlen($post_cherche)) or (utf8($donnees['N_Number']) == '(' . $post_cherche . ')') or (utf8($donnees['N_Number']) == '[' . $post_cherche . ']') or (utf8($donnees['N_Number']) == 'WD ' . $post_cherche) or (utf8($donnees['N_Number']) == 'WD [' . $post_cherche . ']') or (utf8($donnees['N_Number']) == 'ES ' . $post_cherche) ) { // echo '' . "\n" ; // } // } echo ''; echo '
Recherche : ' . $post_cherche . '
' . $company . ' - ' . utf8($donnees['N_Company']) . '' . utf8($donnees1['Axes']) . '' . utf8($donnees1['Constructeur']) . '' . utf8($donnees1['Usine']) . ''; if ( $company == "Exportation" ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == "Vicinal" ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == "Urbain" ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == encodeToUtf8('Musée') ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == encodeToUtf8('Musées') ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == "Private" ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == encodeToUtf8('Chaudière') ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == "Industrie" ) { echo '' . utf8($donnees['N_Type']) . ''; } elseif ( $company == "NOLOCO" ) { echo utf8($donnees['N_Type']); } elseif ( ($company == "Etranger") or ($company == encodeToUtf8('Chaudière')) ) { // echo '' . utf8($donnees['N_Type']) . ''; // echo '' . utf8($donnees['N_Type']) . ''; echo '' . utf8($donnees['N_Type']) . ''; // echo utf8($donnees['N_Type']) ; } else { $valuetype = utf8($donnees['N_Company']) .'@' . utf8($donnees['N_Type']); echo '' . utf8($donnees['N_Type']) . ''; } echo '' . utf8($donnees['N_Number']); if (!in_array($donnees['N_Identifier'], $attrib)) { echo '' . utf8($donnees['N_Identifier']); } else { switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; } echo '' ; } echo '
Constructeurs
' . utf8($donnees['Constructeur_Reel']) . '    ' . utf8($donnees['Fab_Number']) . ' 
Tenders
' . utf8($donnees['K_Company']) . '' . utf8($donnees['K_Number']); if (!in_array($donnees['K_Identifier'], $attrib)) { echo '' . utf8($donnees['K_Identifier']); } else { switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; } echo '' ; } $requete= "SELECT * FROM rep_relations_tenders WHERE (`rep_relations_tenders`.`N_Company` = '" . $donnees['T_Company'] . "' and `rep_relations_tenders`.`N_Number` = '" . $donnees['T_Number'] . "' and `rep_relations_tenders`.`N_Identifier` = '" . $donnees['T_Identifier'] . "') ;" ; $reponseT=mysqli_query($conn, $requete); test_requete($reponseT,$conn); $donneesT = mysqli_fetch_array($reponseT); echo '   ' . utf8($donnees['T_Number']); switch($donnees['T_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['T_Identifier'] . ")"; } echo ' 
Registre des épreuves
' . utf8($donnees['Type_NL']) . '    ' . utf8($donnees['Event']) . ' 
Locomotives non identifiées
' . utf8($donnees['K_Type']) . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // switch($donnees['K_Identifier']) { // case "0": // break; // case "2": // case "3": // case "4": // case "5": // case "6": // echo "(" . $donnees['K_Identifier'] . ")"; // break; // } // echo '' . utf8($donnees['Source']) . '
'; // } else { // echo 'Search Term must be numeric'; // } echo '
' . "\n" ; } elseif (isset($_GET['UNK']) OR isset($_GET['Etranger']) OR isset($_GET['Museum']) OR isset($_GET['Museums']) OR isset($_GET['Vicinal']) OR isset($_GET['Urbain']) OR isset($_GET['Boiler']) OR isset($_GET['Private']) OR isset($_GET['Export']) OR isset($_GET['Industrie'])) { if (isset($_GET['UNK'])) { $get_const=validate_data($_GET['UNK']); $categorie = 'Inconnu'; } elseif (isset($_GET['Etranger'])) { $get_const=validate_data($_GET['Etranger']); $categorie = 'Etranger'; } elseif (isset($_GET['Museums'])) { $get_const=validate_data($_GET['Museums']); $categorie = utf8_none('Musées'); } elseif (isset($_GET['Museum'])) { $get_const=validate_data($_GET['Museum']); $categorie = utf8_none('Musée'); } elseif (isset($_GET['Vicinal'])) { $get_const=validate_data($_GET['Vicinal']); $categorie = 'Vicinal'; } elseif (isset($_GET['Urbain'])) { $get_const=validate_data($_GET['Urbain']); $categorie = 'Urbain'; } elseif (isset($_GET['Boiler'])) { $get_const=validate_data($_GET['Boiler']); $categorie = utf8_none('Chaudière'); } elseif (isset($_GET['Private'])) { $get_const=validate_data($_GET['Private']); $categorie = 'Private'; } elseif (isset($_GET['Export'])) { $get_const=validate_data($_GET['Export']); $categorie = 'Etranger'; } elseif (isset($_GET['Industrie'])) { $get_const=validate_data($_GET['Industrie']); $categorie = 'Industrie'; } $recherche= intval($get_const); $requete= 'SELECT *, CASE WHEN `rep_relations`.`N_Number`+0 > 0 THEN LPAD(`rep_relations`.`N_Number`,8,"0") ELSE `rep_relations`.`N_Number` END AS `Number_Sort` FROM rep_relations WHERE (`rep_relations`.`N_Category` = "' . $categorie . '" and `rep_relations`.`N_Company` = "' . utf8_inverse($indexconstructeur[$recherche]) . '") ORDER BY `Number_Sort` ASC, `rep_relations`.`N_Identifier`' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); // echo $nblignes; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= 'SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = "' . $donnees['K_Company'] . '" and `rep_machines`.`K_Number` = "' . $donnees['K_Number'] . '" and `rep_machines`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") ;' ; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); echo '' . "\n" ; } echo '
' . $categorie . ' - ' . $indexconstructeur[$recherche] . ' ['. $nblignes . ']
' . utf8($donnees['N_Company']) . '' . utf8($donnees['N_Type']) . '' . utf8($donnees1['Axes']) . '' . utf8($donnees1['Constructeur']) . '' . utf8($donnees1['Usine']) . ''; // echo utf8($donnees1['Fab_Number']); if ($donnees1['Fab_Number'] == "0") { } elseif (is_numeric($donnees1['Fab_Number'])) { echo number_format($donnees1['Fab_Number'], 0, ",", "."); } else { echo utf8($donnees1['Fab_Number']); } echo '' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; default: echo '' . utf8($donnees['N_Identifier']); } echo '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
'; echo '' . "\n" ; } elseif (isset($_GET['type'])) { // $get_type=validate_data($_GET['type']); $recherche=explode("@", $_GET['type']); $company = intval($recherche[0]); $type = intval($recherche[1]); // echo $indextype[$company . '@' . $type]; $recherche=explode("@", $indextype[$company . '@' . $type]); $company = $recherche[0]; $type = $recherche[1]; $requete= 'SELECT *, CASE WHEN `rep_relations`.`N_Number`+0 > 0 THEN LPAD(`rep_relations`.`N_Number`,8,"0") ELSE `rep_relations`.`N_Number` END AS `Number_Sort` FROM rep_relations WHERE (`rep_relations`.`N_Company` = "' . utf8_inverse($company) . '" and `rep_relations`.`N_Type` = "' . utf8_inverse($type) . '") ORDER BY `Number_Sort` ASC, `rep_relations`.`N_Identifier`' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); // echo $nblignes; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= 'SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = "' . $donnees['K_Company'] . '" and `rep_machines`.`K_Number` = "' . $donnees['K_Number'] . '" and `rep_machines`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") ;' ; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); echo '' . "\n" ; } echo '
' . $company . ' - ' . $type . ' ['. $nblignes . ']
' . utf8($donnees['N_Company']) . '' . utf8($donnees['N_Type']) . '' . utf8($donnees1['Axes']) . '' . utf8($donnees1['Constructeur']) . '' . utf8($donnees1['Usine']) . ''; // echo utf8($donnees1['Fab_Number']); if ($donnees1['Fab_Number'] == "0") { } elseif (is_numeric($donnees1['Fab_Number'])) { echo number_format($donnees1['Fab_Number'], 0, ",", "."); } else { echo utf8($donnees1['Fab_Number']); } echo '' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; default: echo '' . utf8($donnees['N_Identifier']); } echo '' . date8($donnees1['Date_In']) . ' - ' . date8($donnees1['Date_Out']) . ' / ' . date8($donnees1['Write-off']) . '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
'; echo '' . "\n" ; } elseif (isset($_GET['listcomp'])) { $company = intval($_GET['listcomp']); // echo $indextype[$company . '@' . $type]; $recherche=explode("@", $indextype[$company . '@0']); $company = $recherche[0]; $requete= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`N_Company` = "' . utf8_inverse($company) . '" ) ORDER BY `rep_relations`.`N_Number`+0 ASC, `rep_relations`.`N_Identifier` ASC' ; $requete= 'SELECT *, CASE WHEN `rep_relations`.`N_Number`+0 > 0 THEN LPAD(`rep_relations`.`N_Number`,8,"0") ELSE `rep_relations`.`N_Number` END AS `Number_Sort` FROM rep_relations WHERE (`rep_relations`.`N_Company` = "' . utf8_inverse($company) . '" ) ORDER BY `Number_Sort` ASC, `rep_relations`.`N_Identifier`' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $immatdiff = array(); while ($donnees = mysqli_fetch_array($reponse) ) { $keydiff = utf8($donnees['N_Company']) .'@' . utf8($donnees['N_Number']) .'@' . utf8($donnees['N_Identifier']); if (! (array_key_exists($keydiff,$immatdiff))) { $immatdiff[$keydiff] = $keydiff ; } } echo ''; echo ''; $immatdiff = array(); $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $keydiff = utf8($donnees['N_Company']) .'@' . utf8($donnees['N_Number']) .'@' . utf8($donnees['N_Identifier']); if (! (array_key_exists($keydiff,$immatdiff))) { $immatdiff[$keydiff] = $keydiff ; $requete1= 'SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = "' . $donnees['K_Company'] . '" and `rep_machines`.`K_Number` = "' . $donnees['K_Number'] . '" and `rep_machines`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") ;' ; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); echo '' . "\n" ; } else { if ($_SERVER["REMOTE_ADDR"] == "127.0.0.1") { echo '' . "\n" ; } } } echo '
' . $company . ' ['. number_format(count($immatdiff), 0, ",", ".") . ']
' . utf8($donnees['N_Company']) . '' . utf8($donnees1['Type']) . '' . utf8($donnees1['Axes']) . '' . utf8($donnees1['Constructeur']) . '' . utf8($donnees1['Usine']) . ''; // echo utf8($donnees1['Fab_Number']); if ($donnees1['Fab_Number'] == "0") { } elseif (is_numeric($donnees1['Fab_Number'])) { echo number_format($donnees1['Fab_Number'], 0, ",", "."); } else { echo utf8($donnees1['Fab_Number']); } echo '' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; default: echo '' . utf8($donnees['N_Identifier']); } echo '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
DOUBLON : ' . $keydiff . '
'; echo '' . "\n" ; } elseif (isset($_GET['typeconst'])) { $type = intval($_GET['typeconst']); $requete= 'SELECT * FROM rep_machines WHERE (TRIM(`rep_machines`.`K_Type`) = "' . utf8_inverse($indextypeconst[$type]) . '") ORDER BY `rep_machines`.`K_Number`+0 ASC, `rep_machines`.`K_Identifier` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; // echo '' . "\n" ; } echo '
' . $indextypeconst[$type] . ' ['. $nblignes . ']
'; } elseif (is_numeric($donnees['Fab_Number'])) { $Fab_Number=number_format($donnees['Fab_Number'], 0, ",", "."); } else { $Fab_Number=$donnees['Fab_Number']; } echo '
' . utf8($donnees['Constructeur']) . '' . $Fab_Number . '    ' . utf8($donnees['Axes']) . '' . utf8($donnees['K_Company']) . '' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; default: echo '' . utf8($donnees['K_Identifier']); } echo '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
'; echo '' . "\n" ; } elseif (isset($_GET['Comp'])) { $get_comp=validate_data($_GET['Comp']); $recherche= str_replace("@"," ",$get_comp); $requete= "SELECT * FROM rep_relations WHERE (`rep_relations`.`N_Company` = '" . $recherche . "') ORDER BY `rep_relations`.`N_Number` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
' . $recherche . '
' . utf8($donnees['N_Company']) . '' . utf8($donnees['N_Number']) . '' . utf8($donnees['N_Identifier']) . '
'; echo '' . "\n" ; } elseif (isset($_GET['Const'])) { $get_const=validate_data($_GET['Const']); $recherche= intval($get_const); $requete= "SELECT * FROM (SELECT `rep_machines`.`Type`,`rep_machines`.`Constructeur`, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`Fab_Number`, `rep_machines`.`Date_In`,`rep_machines`.`Usine`, `rep_machines`.`K_Company`, `rep_machines`.`Axes`,`rep_machines`.`Voie`, `rep_machines`.`K_Type`,`rep_machines`.`K_Number`, `rep_machines`.`K_Identifier` FROM rep_machines WHERE `rep_machines`.`Fab_Number` != 0 UNION select '' as `Type`,`rep_events`.`Type_NL`,`rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'cd' as `Axes`, 0 as `Voie`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events WHERE `rep_events`.`Type_FR` = '" . utf8_none('Chaudière') . "' UNION select '' as `Type`,`rep_events`.`Type_NL`,`rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'comp' as `Axes`, 0 as `Voie`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events WHERE `rep_events`.`Type_FR` = '" . utf8_none('Composants') . "' UNION select '' as `Type`,`rep_events`.`Type_NL`,`rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'nc' as `Axes`, 0 as `Voie`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events WHERE `rep_events`.`Type_FR` = '" . utf8_none('Numéro de Construction') . "' UNION select '' as `Type`,`rep_tenders`.`Constructeur`,`rep_tenders`.`Constructeur`,`rep_tenders`.`Fab_Number`,`rep_tenders`.`Date_in`, `rep_tenders`.`Usine`, `rep_tenders`.`K_Company`, 'tender' as `Axes`,`rep_tenders`.`Voie`, `rep_tenders`.`K_Type`, `rep_tenders`.`K_Number`, `rep_tenders`.`K_Identifier` FROM rep_tenders WHERE `rep_tenders`.`Fab_Number` != '0' ) AS `Test` WHERE (`Test`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "') ORDER BY `Test`.`Fab_Number`+0 ASC, `Test`.`Date_In` ;"; // $requete= "SELECT * FROM (SELECT `rep_machines`.`Type`,`rep_machines`.`Constructeur`, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`Fab_Number`, `rep_machines`.`Date_In`,`rep_machines`.`Usine`, `rep_machines`.`K_Company`, `rep_machines`.`Axes`, `rep_machines`.`K_Type`,`rep_machines`.`K_Number`, `rep_machines`.`K_Identifier` FROM rep_machines UNION select '' as `Type`,`rep_events`.`Type_NL`,`rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'cd' as `Axes`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events WHERE `rep_events`.`Type_FR` = '" . utf8_none('Chaudière') . "' UNION select '' as `Type`,`rep_events`.`Type_NL`,`rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'nc' as `Axes`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events WHERE `rep_events`.`Type_FR` = '" . utf8_none('Numéro de Construction') . "') AS `Test` WHERE (`Test`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "') ORDER BY `Test`.`Fab_Number`+0 ASC, `Test`.`Date_In` ;"; // $requete= "SELECT * FROM (SELECT `rep_machines`.`Constructeur`, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`Fab_Number`, `rep_machines`.`Date_In`,`rep_machines`.`Usine`, `rep_machines`.`K_Company`, `rep_machines`.`Axes`, `rep_machines`.`K_Type`,`rep_machines`.`K_Number`, `rep_machines`.`K_Identifier` FROM rep_machines UNION select `rep_events`.`Type_NL`,`rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'cd' as `Axes`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events WHERE `rep_events`.`Type_FR` = '" . utf8_none('Chaudière') . "') AS `Test` WHERE (`Test`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "') ORDER BY `Test`.`Fab_Number`+0 ASC, `Test`.`Date_In` ;"; // $requete= "SELECT * FROM (SELECT `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_machines`.`Date_In`,`rep_machines`.`Usine`, `rep_machines`.`K_Company`, `rep_machines`.`Axes`, `rep_machines`.`K_Type`,`rep_machines`.`K_Number`, `rep_machines`.`K_Identifier` FROM rep_machines UNION select `rep_events`.`Type_NL`,`rep_events`.`Event`,`rep_events`.`Date_in`, '' as `Usine`, `rep_events`.`K_Company`, 'cd' as `Axes`, `rep_events`.`Type_FR`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier` FROM rep_events) AS `Test` WHERE (`Test`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "') ORDER BY `Test`.`Fab_Number`+0 ASC, `Test`.`Date_In` ;"; // $requete= "SELECT * FROM rep_machines WHERE (`rep_machines`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "') ORDER BY `rep_machines`.`Fab_Number`+0 ASC, `rep_machines`.`Date_In` ASC;" ; // $requete= "SELECT distinct `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_machines`.`Fab_Number` FROM rep_machines WHERE (`rep_machines`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "') ORDER BY `rep_machines`.`Fab_Number` ASC" ; // echo $requete; $fabnumberdouble=array(); $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $previous_fab_number=0; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; echo ''; break; default: echo ''; } } } else { $Fab_Number=$donnees['Fab_Number']; } if ($Fab_Number <> "") { if (array_key_exists($Fab_Number,$fabnumberdouble)) { echo '' . "\n" ; $previous_fab_number=$donnees['Fab_Number']; } $requete= "SELECT `rep_machines`.`Type`,`rep_machines`.`Constructeur`, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`Fab_Number`, `rep_machines`.`Date_In`,`rep_machines`.`Usine`, `rep_machines`.`K_Company`, `rep_machines`.`Axes`,`rep_machines`.`Voie`, `rep_machines`.`K_Type`,`rep_machines`.`K_Number`, `rep_machines`.`K_Identifier` FROM rep_machines WHERE `rep_machines`.`Fab_Number` = 0 AND `rep_machines`.`Constructeur` = '" . utf8_inverse($indexconstructeur[$recherche]) . "' ORDER BY `rep_machines`.`Date_In` ;"; // echo $requete; $fabnumberdouble=array(); $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $Fab_Number=""; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
' . $indexconstructeur[$recherche] . ' ['. $nblignes . ']
' . utf8($donnees['Constructeur_Reel']) . ''; } elseif (is_numeric($donnees['Fab_Number'])) { $Fab_Number=number_format($donnees['Fab_Number'], 0, ",", "."); if ($previous_fab_number <>0) { $combien = ($donnees['Fab_Number'] - $previous_fab_number); switch($combien) { case 0: break; case 1: break; case 2: echo '
' . utf8($donnees['Constructeur']) . ''; echo number_format(($donnees['Fab_Number'] - 1), 0, ",", ".") . '/0000
' . utf8($donnees['Constructeur']) . ''; echo number_format(($previous_fab_number + 1), 0, ",", ".") . '/0000 à ' . number_format(($donnees['Fab_Number'] - 1), 0, ",", ".") . '
' . utf8($donnees['Constructeur_Reel']) . ''; } else { echo '
' . utf8($donnees['Constructeur_Reel']) . ''; $fabnumberdouble[$Fab_Number] = $Fab_Number; } } if ($donnees['Date_In'] == 0) { $Date_In="0000"; } else { $Date_In=number_format($donnees['Date_In']/10000, 0, "", ""); } echo $Fab_Number . '/'. $Date_In . ''; if ($donnees['Usine'] == "Blanc-Misseron") { echo '' . utf8($donnees['Usine']) . ''; } else { echo utf8($donnees['Usine']); } echo '' . utf8($donnees['Type']) . '' . utf8($donnees['K_Company']) . '' . utf8($donnees['Axes']) . ''; if ($donnees['Voie'] != 0) { echo number_format(($donnees['Voie']/1000), 3, ",", ".") . ' m' ; } echo ''; if ($donnees['Axes'] == 'cd' OR $donnees['Axes'] == 'nc' OR $donnees['Axes'] == 'comp' OR $donnees['Axes'] == 'tender') { echo utf8($donnees['K_Type']); } else { echo '' . utf8($donnees['K_Type']) . ''; } if ($donnees['Axes'] == 'tender') { echo '' . utf8($donnees['K_Number']) ; switch($donnees['K_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo '(' . $donnees['K_Identifier'] . ')'; break; default: echo '' . utf8($donnees['K_Identifier']); } set_time_limit(20); echo '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
' . utf8($donnees['Constructeur_Reel']) . ''; if ($donnees['Date_In'] == 0) { $Date_In="0000"; } else { $Date_In=number_format($donnees['Date_In']/10000, 0, "", ""); } echo $Fab_Number . '/'. $Date_In . ''; if ($donnees['Usine'] == "Blanc-Misseron") { echo '' . utf8($donnees['Usine']) . ''; } else { echo utf8($donnees['Usine']); } echo '' . utf8($donnees['Type']) . '' . utf8($donnees['K_Company']) . '' . utf8($donnees['Axes']) . ''; if ($donnees['Voie'] != 0) { echo number_format(($donnees['Voie']/1000), 3, ",", ".") . ' m' ; } echo ''; if ($donnees['Axes'] == 'cd' OR $donnees['Axes'] == 'nc' OR $donnees['Axes'] == 'comp' OR $donnees['Axes'] == 'tender') { echo utf8($donnees['K_Type']); } else { echo '' . utf8($donnees['K_Type']) . ''; } if ($donnees['Axes'] == 'tender') { echo '' . utf8($donnees['K_Number']) ; switch($donnees['K_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo '(' . $donnees['K_Identifier'] . ')'; break; default: echo '' . utf8($donnees['K_Identifier']); } set_time_limit(20); echo '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
'; echo '' . "\n" ; } elseif (isset($_GET['ten'])) { $get_ten=validate_data($_GET['ten']); $recherche=explode("@", $get_ten); $company = $recherche[0]; $number = $recherche[1]; $identifier = $recherche[2]; echo ''; echo ''; $requete= "SELECT * FROM rep_tenders WHERE (`rep_tenders`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_tenders`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_tenders`.`K_Identifier` = '" . utf8_inverse($identifier) . "') ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; } else { $Fab_Number=$donnees['Fab_Number']; } if (utf8($donnees['Usine']) == "Blanc-Misseron") { $Plaque_Number=trim(substr($donnees['Comment'],-3)); } elseif ($donnees['Fab_Number'] == "0") { $Plaque_Number=""; } else { $Plaque_Number=$donnees['Fab_Number']; } if ($donnees['Voie'] == 0) { $Voie=""; } else { $Voie=number_format(($donnees['Voie']/1000), 3, ",", ".") . ' m.'; } // $valuetype = $company .'@' . utf8($donnees['Type']); echo ''; $constructusine=$donnees['Constructeur'] . $donnees['Usine']; echo ''; echo ''; echo ''; echo ''; echo ''; echo "\n" ; } echo '
' . str_replace($normsearch,$normreplace,"TENDER") . " : " . str_replace($normsearch,$normreplace,utf8_none($number)); switch($identifier) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $identifier . ")"; break; default: echo '
' . $identifier . '
' ; } echo '
Caractéristiques
Constructeur :' . utf8($donnees['Constructeur']) . 'Type :' . utf8($donnees['K_Type']) . '
' . $Plaque_Number . '
Numéro de constructeur :' . $Fab_Number . 'Essieux :' . utf8($donnees['Axes']) . '
Voie :' . $Voie . 'Mise en service :' . date8(utf8($donnees['Date_In'])) . '
Mise hors service :' . date8(utf8($donnees['Date_Out'])) . 'Sortie d' . "'" . 'écriture :' . date8(utf8($donnees['Write-off'])) . '
Commentaires :' . utf8($donnees['Comment']) . '
'; $requete= "SELECT * FROM rep_relations_tenders WHERE (`rep_relations_tenders`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_relations_tenders`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_relations_tenders`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `rep_relations_tenders`.`N_Date` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo ''; echo ''; echo '' ."\n" ; } } echo '
Renumérotations
' . utf8($donnees['N_Company']) . '' . utf8($donnees['N_Type']) . '' . utf8($donnees['N_Number']) ; switch(utf8($donnees['N_Identifier'])) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . utf8($donnees['N_Identifier']) . ")"; break; } echo '' . date8(utf8($donnees['N_Date'])) . '' . utf8($donnees['Comment_FR']) . '
' . "\n" ; $requete= 'select * from `rep_machines_tenders` where concat(`rep_machines_tenders`.`T_Company`, `rep_machines_tenders`.`T_Number`, `rep_machines_tenders`.`T_Identifier`) IN (SELECT concat(`rep_relations_tenders`.`N_Company`, `rep_relations_tenders`.`N_Number`, `rep_relations_tenders`.`N_Identifier`) as essai FROM `rep_relations_tenders` WHERE `rep_relations_tenders`.`K_Company` = "' . utf8_inverse($company) . '" and `rep_relations_tenders`.`K_Number` = "' . utf8_inverse($number) . '" and `rep_relations_tenders`.`K_Identifier` = "' . utf8_inverse($identifier) . '") ORDER by `rep_machines_tenders`.`Date_in` asc, `rep_machines_tenders`.`Date_Out` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $compteur=0; $in = array(); $out = array(); $K_Company = array(); $K_Number = array(); $K_Identifier = array(); if ($nblignes > 0) { echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $compteur = $compteur + 1; $in[$compteur]=$donnees['Date_in']; $out[$compteur]=$donnees['Date_Out']; $K_Company[$compteur]=utf8($donnees['K_Company']); $K_Number[$compteur]=utf8($donnees['K_Number']); $K_Identifier[$compteur]=utf8($donnees['K_Identifier']); } for ($j = 1; $j < $compteur; $j++) { for ($i = 1; $i < (($compteur - $j) + 1); $i++) { if (($out[$i] > $in[$i + 1]) and ($in[$i + 1] !=0)) { $K_Companytemp = $K_Company[$i]; $K_Numbertemp = $K_Number[$i]; $K_Identifiertemp = $K_Identifier[$i]; $intemp = $in[$i]; $outtemp = $out[$i]; $K_Company[$i] = $K_Company[$i + 1]; $K_Number[$i] = $K_Number[$i + 1]; $K_Identifier[$i] = $K_Identifier[$i + 1]; $in[$i] = $in[$i + 1]; $out[$i] = $out[$i + 1]; $K_Company[$i + 1] = $K_Companytemp; $K_Number[$i + 1] = $K_Numbertemp; $K_Identifier[$i + 1] = $K_Identifiertemp; $in[$i + 1] = $intemp; $out[$i + 1] = $outtemp; } } } for ($i = 1; $i <= $compteur; $i++) { $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $K_Company[$i] . '" AND `rep_relations`.`K_Number` = "' . $K_Number[$i] . '" AND `rep_relations`.`K_Identifier` = "' . $K_Identifier[$i] . '") ORDER BY `rep_relations`.`N_Follow` DESC, `rep_relations`.`N_Date` DESC LIMIT 1;' ; // echo $requete2; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' ."\n" ; } } echo '
Accouplé aux locomotives
' . utf8($donnees2['N_Company']) . ' - ' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; } echo '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . "\n" ; echo '' . "\n" ; } elseif (isset($_GET['mac'])) { $get_mac=validate_data($_GET['mac']); $recherche=explode("@", $get_mac); $company = $recherche[0]; $number = $recherche[1]; $identifier = $recherche[2]; $requete= "SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_machines`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_machines`.`K_Identifier` = '" . utf8_inverse($identifier) . "') ;" ; // $requete= "SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = " . '"' . $company . '"' . " and `rep_machines`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_machines`.`K_Identifier` = '" . utf8_inverse($identifier) . "') ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; } else { $Fab_Number=$donnees['Fab_Number']; } if (utf8($donnees['Usine']) == "Blanc-Misseron") { $Plaque_Number=trim(substr($donnees['Comment'],-3)); } elseif ($donnees['Fab_Number'] == "0") { $Plaque_Number=""; } else { $Plaque_Number=$donnees['Fab_Number']; } if ($donnees['Voie'] == 0) { $Voie=""; } else { $Voie=number_format(($donnees['Voie']/1000), 3, ",", ".") . ' m.'; } $valuetype = $company .'@' . utf8($donnees['Type']); echo '' . "\n"; echo '' . "\n"; } else { echo '' . "\n"; } echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; } echo '
' . normchar(utf8($number)); // echo '
' . str_replace($normsearch,$normreplace,utf8($number)); switch($identifier) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $identifier . ")"; break; default: echo '
' . $identifier . '
' ; } echo '
Caractéristiques
Constructeur :' . utf8($donnees['Constructeur_Reel']) . 'Type :'; // if ( (utf8($donnees['K_Company']) <> 'Exportations') and (utf8($donnees['K_Company']) <> 'Industrie') ) { if ( in_array($valuetype,$indextype) ) { echo '' . utf8($donnees['Type']) . ''; } else { echo utf8($donnees['Type']); } $constructusine=$donnees['Constructeur_Reel'] . $donnees['Usine']; if ($donnees['Usine'] <> "") { echo '
' . $Plaque_Number . '
Usine :' . $donnees['Usine'] . '
' . $Plaque_Number . '
Numéro de constructeur :' . $Fab_Number . 'Essieux :' . utf8($donnees['Axes']) . '
Voie :' . $Voie . ''; if ($donnees['Litteral'] <> "") { echo 'Littéral :'; } echo '' . $donnees['Litteral'] . '
Mise en service :' . date8(utf8($donnees['Date_In'])) . 'Mise hors service :' . date8(utf8($donnees['Date_Out'])) . '
Nom/Surnom :' . utf8($donnees['Surname']) . 'Sortie d' . "'" . 'écriture :' . date8(utf8($donnees['Write-off'])) . '
Commentaires :' . utf8($donnees['Comment']) . '
' . "\n"; $requete= "SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_relations`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_relations`.`K_Identifier` = '" . utf8_inverse($identifier) . "') ORDER BY `rep_relations`.`N_Follow` ASC, `rep_relations`.`N_Date` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); echo '' . "\n"; echo '' . "\n"; while ($donnees = mysqli_fetch_array($reponse) ) { $valuetype = utf8($donnees['N_Company']) .'@' . utf8($donnees['N_Type']); echo '' ."\n" ; } echo '
Numérotation
' . date8(utf8($donnees['N_Date'])) . '' . str_replace(' ',' ',utf8($donnees['N_Company'])) . ''; if (utf8($donnees['N_Category']) == 'Belgique') { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == "Industrie" ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == "Private" ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == "Etranger" ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == "Vicinal" ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == "Urbain" ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == "NOLOCO" ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == encodeToUtf8('Musée') ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == encodeToUtf8('Musées') ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } elseif ( utf8($donnees['N_Category']) == encodeToUtf8('Chaudière') ) { echo '' . str_replace(' ',' ',utf8($donnees['N_Type'])) . '' . ''; } else { echo str_replace(' ',' ',utf8($donnees['N_Type'])) . ''; } echo normchar(utf8($donnees['N_Number'])) ; // echo str_replace($normsearch,$normreplace,utf8($donnees['N_Number'])) ; if (!in_array($donnees['N_Identifier'], $attrib)) { echo '' . utf8($donnees['N_Identifier']); } else { switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' ; } echo '' . utf8($donnees['Comment_FR']) . '
' . "\n" ; $requete= "SELECT * FROM rep_mutations WHERE (`rep_mutations`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_mutations`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_mutations`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `rep_mutations`.`Ordre` ASC,`rep_mutations`.`Date_in` ASC, `rep_mutations`.`Date_Out` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $compteur=0; $in = array(); $out = array(); $ordre = array(); $depot = array(); $commenta = array(); if ($nblignes > 0) { echo '' . "\n"; echo '' . "\n"; while ($donnees = mysqli_fetch_array($reponse) ) { $compteur = $compteur + 1; $in[$compteur]=$donnees['Date_in']; $out[$compteur]=$donnees['Date_Out']; $depot[$compteur]=utf8($donnees['Depot']); $commenta[$compteur]=utf8($donnees['Comment']); $ordre[$compteur]=$donnees['Ordre']; // echo '' ."\n" ; } if ($ordre[$compteur] == 0) { for ($j = 1; $j < $compteur; $j++) { for ($i = 1; $i < (($compteur - $j) + 1); $i++) { if (($out[$i] > $in[$i + 1]) and ($in[$i + 1] !=0) ) { // if (($out[$i] > $in[$i + 1]) and ($in[$i + 1] !=0) and ($in[$i + 1] != $out[$i + 1]) ) { $depottemp = $depot[$i]; $intemp = $in[$i]; $outtemp = $out[$i]; $commenttemp = $commenta[$i]; $depot[$i] = $depot[$i + 1]; $in[$i] = $in[$i + 1]; $out[$i] = $out[$i + 1]; $commenta[$i] = $commenta[$i + 1]; $depot[$i + 1] = $depottemp; $in[$i + 1] = $intemp; $out[$i + 1] = $outtemp; $commenta[$i + 1] = $commenttemp; } // echo "The number is: $i
"; } } } for ($i = 1; $i <= $compteur; $i++) { echo '' . "\n" ; } echo '
Mutations / Garages / Divers
' . utf8($donnees['Depot']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '' . utf8($donnees['Comment']) . '
'; $requete1= "SELECT * FROM rep_telegraphe WHERE `rep_telegraphe`.`Remise` = '" . utf8_inverse($depot[$i]) . "' ;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); $nblignes1 = mysqli_num_rows($reponse1); if ($nblignes1 == 0 OR $in[$i] == 0 OR $out[$i] == 0) { echo $depot[$i]; } else { echo '' . $depot[$i] . ''; } echo '' . date8($in[$i]) . '' . date8($out[$i]) . '' . $commenta[$i] . '
' . "\n"; } $requete= "SELECT * FROM rep_machines_tenders WHERE (`rep_machines_tenders`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_machines_tenders`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_machines_tenders`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `rep_machines_tenders`.`Date_in` ASC, `rep_machines_tenders`.`Date_Out` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $compteur=0; $in = array(); $out = array(); $T_Company = array(); $T_Number = array(); $T_Identifier = array(); if ($nblignes > 0) { echo '' . "\n"; echo '' . "\n"; while ($donnees = mysqli_fetch_array($reponse) ) { $compteur = $compteur + 1; $in[$compteur]=$donnees['Date_in']; $out[$compteur]=$donnees['Date_Out']; $T_Company[$compteur]=utf8($donnees['T_Company']); $T_Number[$compteur]=utf8($donnees['T_Number']); $T_Identifier[$compteur]=utf8($donnees['T_Identifier']); // echo '' ."\n" ; } for ($j = 1; $j < $compteur; $j++) { for ($i = 1; $i < (($compteur - $j) + 1); $i++) { if (($out[$i] > $in[$i + 1]) and ($in[$i + 1] !=0)) { $T_Companytemp = $T_Company[$i]; $T_Numbertemp = $T_Number[$i]; $T_Identifiertemp = $T_Identifier[$i]; $intemp = $in[$i]; $outtemp = $out[$i]; $T_Company[$i] = $T_Company[$i + 1]; $T_Number[$i] = $T_Number[$i + 1]; $T_Identifier[$i] = $T_Identifier[$i + 1]; $in[$i] = $in[$i + 1]; $out[$i] = $out[$i + 1]; $T_Company[$i + 1] = $T_Companytemp; $T_Number[$i + 1] = $T_Numbertemp; $T_Identifier[$i + 1] = $T_Identifiertemp; $in[$i + 1] = $intemp; $out[$i + 1] = $outtemp; } // echo "The number is: $i
"; } } for ($i = 1; $i <= $compteur; $i++) { $requete= "SELECT * FROM rep_relations_tenders WHERE (`rep_relations_tenders`.`N_Company` = '" . $T_Company[$i] . "' and `rep_relations_tenders`.`N_Number` = '" . $T_Number[$i] . "' and `rep_relations_tenders`.`N_Identifier` = '" . $T_Identifier[$i] . "') ;" ; $reponseT=mysqli_query($conn, $requete); test_requete($reponseT,$conn); $donneesT = mysqli_fetch_array($reponseT); echo '' ."\n" ; } echo '
Tenders
' . utf8($donnees['T_Number']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '
' . $T_Number[$i]; switch($T_Identifier[$i]) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $T_Identifier[$i] . ")"; break; } echo '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . "\n"; } $requete= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_events`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_events`.`K_Identifier` = '" . utf8_inverse($identifier) . "' and (`rep_events`.`Type_FR` <> 'Source' AND `rep_events`.`Type_FR` <> 'Attention')) order by `rep_events`.`Date_in` ASC, `rep_events`.`Date_Out` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $firstligne = 0; $compteur=0; $in = array(); $out = array(); $Type_FR = array(); $Type_NL = array(); $Event = array(); $Year_PV = array(); if ($nblignes > 0) { while ($donnees = mysqli_fetch_array($reponse) ) { $compteur = $compteur + 1; $in[$compteur]=$donnees['Date_in']; $out[$compteur]=$donnees['Date_Out']; $Type_FR[$compteur]=utf8($donnees['Type_FR']); $Type_NL[$compteur]=utf8($donnees['Type_NL']); $Event[$compteur]=utf8($donnees['Event']); $Year_PV[$compteur]=utf8($donnees['Year_PV']); // echo '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '' ."\n" ; } for ($j = 1; $j < $compteur; $j++) { for ($i = 1; $i < (($compteur - $j) + 1); $i++) { if (($out[$i] > $in[$i + 1]) and ($in[$i + 1] !=0)) { // if (($out[$i] > $in[$i + 1]) and ($in[$i] ==0)) { $type_frtemp = $Type_FR[$i]; $type_nltemp = $Type_NL[$i]; $eventtemp = $Event[$i]; $intemp = $in[$i]; $outtemp = $out[$i]; $Year_PVtemp = $Year_PV[$i]; $Type_FR[$i] = $Type_FR[$i + 1]; $Type_NL[$i] = $Type_NL[$i + 1]; $Event[$i] = $Event[$i + 1]; $in[$i] = $in[$i + 1]; $out[$i] = $out[$i + 1]; $Year_PV[$i] = $Year_PV[$i + 1]; $Type_FR[$i + 1] = $type_frtemp; $Type_NL[$i + 1] = $type_nltemp; $Event[$i + 1] = $eventtemp; $in[$i + 1] = $intemp; $out[$i + 1] = $outtemp; $Year_PV[$i + 1] = $Year_PVtemp; } // echo "The number is: $i
"; } } for ($i = 1; $i <= $compteur; $i++) { if ($firstligne == 0) { echo '' . "\n"; echo '' . "\n"; $firstligne = 1; } switch($Type_FR[$i]) { case encodeToUtf8("Attention"): case encodeToUtf8("Deceased"): case encodeToUtf8("Buried"): case encodeToUtf8("Source"): break; case encodeToUtf8("Accident"): case encodeToUtf8("Incendie"): echo '' ."\n" ; break; case encodeToUtf8("Avis"): echo '' ."\n" ; break; case encodeToUtf8("Blanc-Misseron"): echo '' ."\n" ; break; case encodeToUtf8("CAR"): echo '' ."\n" ; break; case encodeToUtf8("Chaudière"): case encodeToUtf8("Composants"): echo '' ."\n" ; break; case encodeToUtf8("Cinéma"): echo '' ."\n" ; break; case encodeToUtf8("Classement MH"): echo '' ."\n" ; break; case encodeToUtf8("Code Radio"): echo '' ."\n" ; break; case encodeToUtf8("Commanditaire"): echo '' ."\n" ; break; case encodeToUtf8("Decauville"): echo '' ."\n" ; break; case encodeToUtf8("Dedicated"): echo '' ."\n" ; break; case encodeToUtf8("Démolition"): if ( $out[$i] == 0) { echo '' ."\n" ; } else { echo '' ."\n" ; } break; case encodeToUtf8("Dossier Constructeur"): echo '' ."\n" ; break; case encodeToUtf8("Essais"): echo '' ."\n" ; break; case encodeToUtf8("Exposition"): echo '' ."\n" ; break; case encodeToUtf8("Faits de guerre"): echo '' ."\n" ; break; case encodeToUtf8("Festival"): $requete3= 'SELECT * FROM rep_associations WHERE `rep_associations`.`Nom` = "' . $Type_NL[$i] . '" ;' ; $reponse3=mysqli_query($conn, $requete3); test_requete($reponse3,$conn); $donnees3 = mysqli_fetch_array($reponse3); // echo '' . utf8($donnees['Type_NL']) . ' - ' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' ."\n" ; break; case encodeToUtf8("Générateur de vapeur"): echo '' ."\n" ; break; case encodeToUtf8("Inauguration"): echo '' ."\n" ; break; case encodeToUtf8("Info"): echo ''; if ( $in[$i] == 0) { echo '' . "\n"; } else { echo '' . "\n"; } break; case encodeToUtf8("Livrée"): echo '' ."\n" ; break; case encodeToUtf8("MGDB"): echo '' ."\n" ; break; case encodeToUtf8("Moteur"): if ( $Year_PV[$i] == 0) { echo '' ."\n" ; } else { echo '' ."\n" ; } break; case encodeToUtf8("Numéro de Construction"): echo '' ."\n" ; break; case encodeToUtf8("Parc"): echo '' ."\n" ; break; case encodeToUtf8("Pelliculage"): echo '' ."\n" ; break; case encodeToUtf8("Préservation"): echo '' ."\n" ; break; case encodeToUtf8("PV de radiation"): echo '' ."\n" ; break; case encodeToUtf8("Record"): echo '' ."\n" ; break; case encodeToUtf8("Registre des épreuves"): echo '' ."\n" ; break; case encodeToUtf8("Révision"): echo '' ."\n" ; break; case encodeToUtf8("Surnom"): echo '' ."\n" ; break; case encodeToUtf8("Schöma"): echo '' ."\n" ; break; case encodeToUtf8("Transformation"): if ($Event[$i] == "Cabines flottantes") { echo '' ."\n" ; } else { echo '' ."\n" ; } break; case encodeToUtf8("Vente"): echo '' ."\n" ; break; default: echo '' ."\n" ; } } echo '
Infos
' . $Type_FR[$i] . ''; if ($Type_NL[$i] <> '') { echo '' . $Type_NL[$i] . ''; } echo '' . $Event[$i] . '' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . ' du ' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '
Commission Alliée des Réparations' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '
' . $Type_FR[$i] . '' . $Event[$i] . '
Dédiée à ' . $Event[$i] . '' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i]; if ($Type_NL[$i] <> "") { echo ' (' . $Type_NL[$i] . ')'; } echo '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '
' . $Type_NL[$i] . 'Consulté le : ' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
Affectation 1914/1918' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . ' type ' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . ' type ' . $Event[$i] . ' no ' . $Year_PV[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . ' HS' . date8($out[$i]) . ' HE
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Type_NL[$i] . ''; switch($Event[$i]) { case encodeToUtf8("RG"): echo 'Révision générale'; break; case encodeToUtf8("RI"): echo 'Révision intermédiaire'; break; case encodeToUtf8("THK"): echo 'Révision intermédiaire'; break; default: echo $Event[$i]; } echo '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '
' . $Type_FR[$i] . '' . $Event[$i] . '' . date8($in[$i]) . '' . date8($out[$i]) . '
' . "\n"; } $cirm=false; $requete= "SELECT * FROM cirm WHERE (`cirm`.`K_Company` = '" . utf8_inverse($company) . "' and `cirm`.`K_Number` = '" . utf8_inverse($number) . "' and `cirm`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `cirm`.`ind` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { $cirm=true; echo '' . "\n"; echo '' . "\n"; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM russell WHERE (`russell`.`K_Company` = '" . utf8_inverse($company) . "' and `russell`.`K_Number` = '" . utf8_inverse($number) . "' and `russell`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `russell`.`ind` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Description']) . '
' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM drawings WHERE (`drawings`.`K_Company` = '" . utf8_inverse($company) . "' and `drawings`.`K_Number` = '" . utf8_inverse($number) . "' and `drawings`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `drawings`.`ind` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Description']) . '
' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM catalogues WHERE (`catalogues`.`K_Company` = '" . utf8_inverse($company) . "' and `catalogues`.`K_Number` = '" . utf8_inverse($number) . "' and `catalogues`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `catalogues`.`Nom` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles

' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM dieudonne WHERE (`dieudonne`.`K_Company` = '" . utf8_inverse($company) . "' and `dieudonne`.`K_Number` = '" . utf8_inverse($number) . "' and `dieudonne`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `dieudonne`.`Nom` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Description']) . '
' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM niels WHERE (`niels`.`K_Company` = '" . utf8_inverse($company) . "' and `niels`.`K_Number` = '" . utf8_inverse($number) . "' and `niels`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `niels`.`Nom` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Description']) . '
' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM welzel WHERE (`welzel`.`K_Company` = '" . utf8_inverse($company) . "' and `welzel`.`K_Number` = '" . utf8_inverse($number) . "' and `welzel`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `welzel`.`Nom` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Description']) . '
' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' ."\n" ; } } $requete= "SELECT * FROM rep_photos WHERE (`rep_photos`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_photos`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_photos`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `rep_photos`.`Date_photo` ASC, `rep_photos`.`Repertoire` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Description']) . '
' . utf8($donnees['Description']) . '
Source : ' . utf8($donnees['Source']) . '
' . "\n"; echo '' . "\n"; } $cirm=true; while ($donnees = mysqli_fetch_array($reponse) ) { // echo '' ."\n" ; echo '' ."\n" ; } } $requete= "SET SQL_BIG_SELECTS=1"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $hacrevue=0; $indexrevue=array(); $requete= "SELECT distinct `photo_ts`.`revue` FROM photo_ts ORDER BY `photo_ts`.`revue` ASC" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $indexrevue[$hacrevue] = utf8($donnees['revue']); $hacrevue = $hacrevue + 1; } $requete= "SELECT `photo_ts`.`Revue`, `photo_ts`.`Numero`, count(`photo_ts`.`Titre`) as combien FROM rep_machines INNER JOIN photo_ts ON (`rep_machines`.`K_Company` = `photo_ts`.`K_Company`) and (`rep_machines`.`K_Number` = `photo_ts`.`K_Number`) and (`rep_machines`.`K_Identifier` = `photo_ts`.`K_Identifier`) WHERE (`rep_machines`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_machines`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_machines`.`K_Identifier` = '" . utf8_inverse($identifier) . "') GROUP BY `photo_ts`.`Revue`, `photo_ts`.`Numero` ;" ; // $requete= "SELECT * FROM photo_ts WHERE (`photo_ts`.`K_Company` = '" . $company . "' and `photo_ts`.`K_Number` = '" . $number . "' and `photo_ts`.`K_Identifier` = '" . $identifier . "') order by `photo_ts`.`revue` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '
Photos/Articles
' . utf8($donnees['Comment_FR']) . '
' . utf8($donnees['Comment_FR']) . '

' . utf8($donnees['Comment_FR']); if ($donnees['Date_photo'] <>0) { echo '
(' . date8($donnees['Date_photo']) . ')'; } if ($donnees['Comment_NL'] <> '') { echo '
' . utf8($donnees['Comment_NL']) ; } echo '
' . "\n"; echo '' . "\n"; } $cirm=true; echo ''; // if ($cirm==true) { // echo '
Photos/Articles
'; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . utf8($donnees['Revue']) . ' : ' . utf8($donnees['Numero']) . '  [' . utf8($donnees['combien']) . ']
' ."\n" ; } echo '
'; // } } $requete= "SELECT `photo_ts`.`City`, `photo_ts`.`Revue`, `photo_ts`.`Numero`, count(`photo_ts`.`Titre`) as combien FROM rep_machines INNER JOIN photo_ts ON (`rep_machines`.`K_Company` = `photo_ts`.`K_Company`) and (`rep_machines`.`K_Number` = `photo_ts`.`K_Number`) and (`rep_machines`.`K_Identifier` = `photo_ts`.`K_Identifier`) WHERE (`rep_machines`.`K_Company` = '" . utf8_inverse($company) . "' and `rep_machines`.`K_Number` = '" . utf8_inverse($number) . "' and `rep_machines`.`K_Identifier` = '" . utf8_inverse($identifier) . "' and `photo_ts`.`City` != '') GROUP BY `photo_ts`.`City` ;" ; // $requete= "SELECT * FROM photo_ts WHERE (`photo_ts`.`K_Company` = '" . $company . "' and `photo_ts`.`K_Number` = '" . $number . "' and `photo_ts`.`K_Identifier` = '" . $identifier . "') order by `photo_ts`.`revue` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($cirm!=true) { echo '' . "\n"; echo '' . "\n"; } $cirm=true; echo ''; } if ($cirm==true) { echo '
Photos/Articles
'; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . utf8($donnees['City']) . '  [' . utf8($donnees['combien']) . ']
' ."\n" ; // echo utf8($donnees['City']) . '  [' . utf8($donnees['combien']) . ']
' ."\n" ; // echo '' . utf8($donnees['City']) . '  [' . utf8($donnees['combien']) . ']
' ."\n" ; } echo '
'; } $requete= "SELECT * FROM base_h0_ts WHERE (`base_h0_ts`.`K_Company` = '" . utf8_inverse($company) . "' and `base_h0_ts`.`K_Number` = '" . utf8_inverse($number) . "' and `base_h0_ts`.`K_Identifier` = '" . utf8_inverse($identifier) . "') order by `base_h0_ts`.`marque` ASC, `base_h0_ts`.`debut` ASC ;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { echo '' . "\n"; echo '' . "\n"; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Miniatures
' . utf8($donnees['marque']) . ' de ' . date8($donnees['debut']) . ' numéro : ' . $donnees['numero'] . '
' . "\n"; } echo '' . "\n" ; } elseif (isset($_GET['Liste'])) { $get_const=validate_data($_GET['Liste']); switch($get_const) { case "13": $requete= 'SELECT * FROM `rep_relations` as `T1` inner join (select `rep_relations`.`K_Number`, MAX(`rep_relations`.`N_Date`) as maxdat from `rep_relations` group by `rep_relations`.`K_Number`) as `T2` on `T1`.`K_Number` = `T2`.`K_Number` and `T1`.`N_Date` = maxdat and `T1`.`K_Type` like "%rie 13" order by `T1`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` like 'Livr%' order by `rep_events`.`Date_in` DESC;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); $requete2= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` = 'Pelliculage' order by `rep_events`.`Date_in` DESC;" ; // echo $requete2; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $nblignes2 = mysqli_num_rows($reponse2); $requete3= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` like 'Particularit%' order by `rep_events`.`Date_in` DESC;" ; // echo $requete3; $reponse3=mysqli_query($conn, $requete3); test_requete($reponse3,$conn); $nblignes3 = mysqli_num_rows($reponse3); echo ''; if ($nblignes1 <> 0) { $donnees1 = mysqli_fetch_array($reponse1); echo '' ; } else { echo '' ; } // if ($nblignes2 <> 0) { // $donnees2 = mysqli_fetch_array($reponse2); // echo '' ; // } // else { // echo '' ; // } if ($nblignes3 <> 0) { $donnees3 = mysqli_fetch_array($reponse3); echo '' ; } else { echo '' ; } echo '' . "\n" ; } echo '
Attributions Série 13
' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['N_Company']) . 'Livrée : ' . utf8($donnees1['Event']) . ' Pelliculage : ' . utf8($donnees2['Event']) . ' ' . utf8($donnees3['Event']) . ' 
'; echo '' . "\n" ; break; case "62": $requete= 'SELECT * FROM `rep_relations` as `T1` inner join (select `rep_relations`.`K_Number`, MAX(`rep_relations`.`N_Date`) as maxdat from `rep_relations` group by `rep_relations`.`K_Number`) as `T2` on `T1`.`K_Number` = `T2`.`K_Number` and `T1`.`N_Date` = maxdat and `T1`.`K_Type` = "Type 212.1" order by `T1`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` like 'Livr%' order by `rep_events`.`Date_in` DESC;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); echo ''; if ($nblignes1 <> 0) { $donnees1 = mysqli_fetch_array($reponse1); echo '' ; } else { echo '' ; } echo '' . "\n" ; } echo '
Livrées Série 62
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . utf8($donnees['N_Company']) . '' . utf8($donnees1['Event']) . ' 
'; echo '' . "\n" ; break; case "77": $requete= 'SELECT * FROM `rep_relations` as `T1` inner join (select `rep_relations`.`K_Number`, MAX(`rep_relations`.`N_Date`) as maxdat from `rep_relations` group by `rep_relations`.`K_Number`) as `T2` on `T1`.`K_Number` = `T2`.`K_Number` and `T1`.`N_Date` = maxdat and `T1`.`K_Type` like "%rie 77" order by `T1`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` like 'Livr%' order by `rep_events`.`Date_in` DESC;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); $requete2= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` = 'Pelliculage' order by `rep_events`.`Date_in` DESC;" ; // echo $requete2; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $nblignes2 = mysqli_num_rows($reponse2); $requete3= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` like 'Particularit%' order by `rep_events`.`Date_in` DESC;" ; // echo $requete3; $reponse3=mysqli_query($conn, $requete3); test_requete($reponse3,$conn); $nblignes3 = mysqli_num_rows($reponse3); echo ''; if ($nblignes1 <> 0) { $donnees1 = mysqli_fetch_array($reponse1); echo '' ; // echo '' ; } else { echo '' ; } if ($nblignes2 <> 0) { $donnees2 = mysqli_fetch_array($reponse2); echo '' ; } else { echo '' ; } if ($nblignes3 <> 0) { $donnees3 = mysqli_fetch_array($reponse3); echo '' ; } else { echo '' ; } echo '' . "\n" ; } echo '
Attributions Série 77
' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['N_Company']) . '' . utf8($donnees1['Event']) . 'Livrée : ' . utf8($donnees1['Event']) . ' Pelliculage : ' . utf8($donnees2['Event']) . ' ' . utf8($donnees3['Event']) . ' 
'; echo '' . "\n" ; break; case "AC": $requete= 'SELECT * FROM rep_events WHERE (`rep_events`.`Type_FR` = "Accident" OR `rep_events`.`Type_FR` = "Incendie" OR `rep_events`.`Type_FR` = "Acte criminel") ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { // $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB" OR `rep_relations`.`N_Company` ="ETAT BELGE" OR `rep_relations`.`N_Company` ="ACTS" OR `rep_relations`.`N_Company` ="SNCV" OR `rep_relations`.`N_Company` ="Sjaellandske Jernbane Selskab" OR `rep_relations`.`N_Company` ="USA/TC" OR `rep_relations`.`N_Company` ="Bruxelles-Tervueren" OR `rep_relations`.`N_Company` ="CFL" OR `rep_relations`.`N_Company` ="CFV3V" OR `rep_relations`.`N_Company` ="LINEAS") AND `rep_relations`.`N_Type` <> "Type A621" AND `rep_relations`.`N_Type` NOT LIKE "ES%" ORDER BY `rep_relations`.`N_Date` DESC;' ; if ($donnees['Date_in'] == 0) { $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") ORDER BY `rep_relations`.`N_Date` DESC;' ; } else { $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND `rep_relations`.`N_Date` < ' . $donnees['Date_in'] . ' ORDER BY `rep_relations`.`N_Date` DESC;' ; } $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; } echo '
Accidents / Incendies
' . utf8($donnees2['N_Company']) . ' - ' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; default: echo '
' . $donnees2['N_Identifier'] . '
' ; } echo '		' . date8($donnees['Date_in']) . ''; if ($donnees['Type_NL'] <> '') { echo ''. utf8($donnees['Type_NL']) .''; } echo '' . utf8($donnees['Event']) . '

Ps.: seuls les accidents / incendies dont le matériel moteur est identifié sont repris dans cette liste.'; echo '' . "\n" ; break; case "ACL": if (isset($_GET['loc'])) { $get_location=validate_data($_GET['loc']); $requete= 'SELECT * FROM rep_events WHERE (`rep_events`.`Type_FR` = "Accident" OR `rep_events`.`Type_FR` = "Incendie" OR `rep_events`.`Type_FR` = "Acte criminel") AND `rep_events`.`Type_NL` = "' . $get_location . '" ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { // $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB" OR `rep_relations`.`N_Company` ="ETAT BELGE" OR `rep_relations`.`N_Company` ="SNCV" OR `rep_relations`.`N_Company` ="Sjaellandske Jernbane Selskab" OR `rep_relations`.`N_Company` ="USA/TC" OR `rep_relations`.`N_Company` ="Bruxelles-Tervueren" OR `rep_relations`.`N_Company` ="CFL" OR `rep_relations`.`N_Company` ="CFV3V" OR `rep_relations`.`N_Company` ="LINEAS") AND `rep_relations`.`N_Type` <> "Type A621" AND `rep_relations`.`N_Type` NOT LIKE "ES%" ORDER BY `rep_relations`.`N_Date` DESC;' ; $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB" OR `rep_relations`.`N_Company` ="ETAT BELGE" OR `rep_relations`.`N_Company` ="ACTS" OR `rep_relations`.`N_Company` ="SNCV" OR `rep_relations`.`N_Company` ="Sjaellandske Jernbane Selskab" OR `rep_relations`.`N_Company` ="USA/TC" OR `rep_relations`.`N_Company` ="Bruxelles-Tervueren" OR `rep_relations`.`N_Company` ="CFL" OR `rep_relations`.`N_Company` ="CFV3V" OR `rep_relations`.`N_Company` ="LINEAS") AND `rep_relations`.`N_Type` <> "Type A621" ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; } echo '
Accidents / Incendies à ' . $get_location . '
' . utf8($donnees2['N_Company']) . ' - ' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; } echo '' . date8($donnees['Date_in']) . ''; if ($donnees['Type_NL'] <> '') { echo $donnees['Type_NL'] ; } else { echo 'INCONNU'; } echo '' . utf8($donnees['Event']) . '

Ps.: seuls les accidents / incendies dont le matériel moteur est identifié sont repris dans cette liste.'; echo '' . "\n" ; } else { $requete1= "SELECT `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_events` WHERE (`rep_events`.`Type_FR` = 'Accident' OR `rep_events`.`Type_FR` = 'Incendie') AND `rep_events`.`Type_NL` <> '' GROUP BY `rep_events`.`Type_NL` ;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); echo ''; echo '
Tableaux par localisation Accident / Incendie
' . "\n" ; echo '' . "\n" ; } break; case "1951": $requete= 'SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_in`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) WHERE (((`rep_mutations`.`Date_in`) < 19520000) AND ((`rep_mutations`.`Date_in`) <> 0) AND ((`rep_mutations`.`Date_Out`) >= 19510000) AND ((`rep_mutations`.`Date_Out`) <> 0) AND ((`rep_relations`.`N_Date`) >= 19451229) AND ((`rep_relations`.`N_Date`) < 19520000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE "%Chimay%") AND ((`rep_relations`.`N_Type`) <> "2-050 TB") AND ((`rep_relations`.`N_Type`) <> "BR 55") AND ((`rep_relations`.`N_Type`) <> "Type 30") AND ((`rep_relations`.`N_Type`) <> "WD 70.000") AND ((`rep_relations`.`N_Number`) <> "81.581") AND (((`rep_relations`.`N_Type`) LIKE "Type%") OR ((`rep_relations`.`N_Type`) LIKE "WD%"))) ORDER BY `rep_mutations`.`Depot` ASC, `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC;' ; // $requete= 'SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_in`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) WHERE (((`rep_mutations`.`Date_in`) < 19520000) AND ((`rep_mutations`.`Date_in`) <> 0) AND ((`rep_mutations`.`Date_Out`) >= 19510000) AND ((`rep_mutations`.`Date_Out`) <> 0) AND ((`rep_relations`.`N_Date`) >= 19451229) AND ((`rep_relations`.`N_Date`) < 19520000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE "%Chimay%") AND ((`rep_relations`.`N_Type`) <> "2-050 TB") AND ((`rep_relations`.`N_Type`) <> "BR 55") AND ((`rep_relations`.`N_Number`) <> "81.581") AND ((`rep_relations`.`N_Number`) <> "30.060") AND ((`rep_relations`.`N_Number`) <> "30.054") AND (((`rep_relations`.`N_Type`) LIKE "Type%") OR ((`rep_relations`.`N_Type`) LIKE "WD%"))) ORDER BY `rep_mutations`.`Depot` ASC, `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $depot = 'Brol'; $type = 'Brol'; echo ''; echo '' . "\n" ; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Depot'] <> $depot) { echo '' . "\n" ; $depot = $donnees['Depot']; $type = 'Brol'; } if ($donnees['N_Type'] <> $type) { echo '' . "\n" ; $type = $donnees['N_Type']; } echo '' ; echo '' . "\n" ; } echo '
1951
' . utf8($donnees['Depot']) . '
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Comment']) . '
'; echo '' . "\n" ; break; case "1956": $requete= 'SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_in`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) WHERE (((`rep_mutations`.`Date_in`) < 19570000) AND ((`rep_mutations`.`Date_in`) <> 0) AND ((`rep_mutations`.`Date_Out`) >= 19560000) AND ((`rep_mutations`.`Date_Out`) <> 0) AND ((`rep_relations`.`N_Date`) >= 19451229) AND ((`rep_relations`.`N_Date`) < 19570000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE "%Chimay%") AND ((`rep_relations`.`N_Type`) <> "2-050 TB") AND ((`rep_relations`.`N_Type`) <> "BR 55") AND ((`rep_relations`.`N_Type`) <> "Type 30") AND ((`rep_relations`.`N_Type`) <> "WD 70.000") AND ((`rep_relations`.`N_Number`) <> "81.581") AND (((`rep_relations`.`N_Type`) LIKE "Type%") OR ((`rep_relations`.`N_Type`) LIKE "WD%"))) ORDER BY `rep_mutations`.`Depot` ASC, `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); $depot = 'Brol'; $type = 'Brol'; echo ''; echo '' . "\n" ; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Depot'] <> $depot) { echo '' . "\n" ; $depot = $donnees['Depot']; $type = 'Brol'; } if ($donnees['N_Type'] <> $type) { echo '' . "\n" ; $type = $donnees['N_Type']; } echo '' ; echo '' . "\n" ; } echo '
1956
' . utf8($donnees['Depot']) . '
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Comment']) . '
'; echo '' . "\n" ; break; case "BM": $requete= 'SELECT `rep_machines`.`K_Identifier`, `rep_machines`.`K_Number`, `rep_machines`.`K_Company`, `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_events`.`Event`, `rep_events`.`Date_in`, `rep_events`.`Date_Out`, `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE `rep_events`.`Type_FR` = "Blanc-Misseron" ORDER BY `rep_events`.`Event`+0 ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Exposition" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; // echo '' . "\n" ; } echo '
Blanc-Misseron ['. $nblignes . ']
'; } elseif (is_numeric($donnees['Fab_Number'])) { $Fab_Number=number_format($donnees['Fab_Number'], 0, ",", "."); } else { $Fab_Number=$donnees['Fab_Number']; } echo '
Blanc-Misseron N° ' . utf8($donnees['Event']) . '' . utf8($donnees['Constructeur']) . ' N° ' . $Fab_Number . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
'; echo '' . "\n" ; break; case "CA": $requete= 'select * from `rep_events` `e` inner join (SELECT `a`.`K_Company` ,`a`.`N_Type` ,`a`.`K_Number`,`a`.`K_Identifier`,`a`.`N_Number`,`a`.`N_Identifier`,`Dat` FROM `rep_relations` `a` inner join (select `K_Company`,`K_Number`,`K_Identifier`, max(`N_Date`) `Dat` FROM `rep_relations` `c` group by `K_Company`, `K_Number`,`K_Identifier`) `b` on `a`.`K_Company` = `b`.`K_Company` and`a`.`K_Number` = `b`.`K_Number` and`a`.`K_Identifier` = `b`.`K_Identifier` and`a`.`N_Date` = `b`.`Dat` and `a`.`N_Type` = "Type 40") `d` on `e`.`K_Company` = `d`.`K_Company` and`e`.`K_Number` = `d`.`K_Number` and`e`.`K_Identifier` = `d`.`K_Identifier` and `e`.`Event` like "Cabine%" ORDER BY `d`.`N_Number` ASC;' ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo ''; } echo '
Cabines Type 40 ['. $nblignes . ']
' . utf8($donnees['N_Number']) ; switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . utf8($donnees['Event']) . '
'; echo '' . "\n" ; break; case "CAR": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "CAR" ORDER BY SUBSTRING(`rep_events`.`Event`, 1, 13) ASC, `rep_events`.`K_Number`+0 ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Commission Alliée des Réparations
MachineCARDossier, industriel allemandDossierApprobation
' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Type_NL']) . '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '
' . "\n" ; echo '' . "\n" ; break; case "CH": $requete= 'SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = "' . utf8_PC_none('Chaudière') . '") ORDER BY `rep_machines`.`Constructeur` ASC, `rep_machines`.`Usine` ASC, `rep_machines`.`Fab_Number` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; // echo ''; } echo '
Chaudières de rechange ['. $nblignes . ']
'; } elseif (is_numeric($donnees['Fab_Number'])) { $Fab_Number=number_format($donnees['Fab_Number'], 0, ",", "."); } else { $Fab_Number=$donnees['Fab_Number']; } echo '
' . utf8($donnees['K_Type']) . '' . utf8($donnees['Constructeur']) . '' . utf8($donnees['Fab_Number']) . '' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
'; echo '' . "\n" ; break; case "CIN": $requete= 'SELECT * FROM rep_events WHERE (`rep_events`.`Type_FR` = "' . utf8_PC_none("Cinéma") . '") ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND `rep_relations`.`N_Date` < ' . $donnees['Date_in'] . ' ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; } echo '
Locomotives dans le cinéma
' . utf8($donnees2['N_Company']) . ' - ' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; default: echo '
' . $donnees2['N_Identifier'] . '
' ; } echo '		' . $donnees['Event'] . '' . $donnees['Type_NL'] . '' . date8($donnees['Date_in']) . '
'; echo '' . "\n" ; break; case "CO": $requete= 'SELECT `rep_machines`.`K_Identifier`, `rep_machines`.`K_Number`, `rep_machines`.`K_Company`, `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_events`.`Event`, `rep_events`.`Date_in`, `rep_events`.`Date_Out`, `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE `rep_events`.`Type_FR` = "Concours" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Company` ASC, `rep_events`.`K_Number` ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Exposition" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo '
Concours
'; $expo=""; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['Event']) <> $expo) { if ($expo <> "") { echo ''; } echo '' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . "\n" ; echo ' (' . utf8($donnees['Constructeur']); if (utf8($donnees['Fab_Number']) <> 0) { echo ' ' . utf8($donnees['Fab_Number']); } echo ')'; if (utf8($donnees['Type_NL']) <> "") { echo ' (' . utf8($donnees['Type_NL']) . ')'; } } echo '
' . "\n" ; echo '' . "\n" ; break; case "CR": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Code Radio" ORDER BY `rep_events`.`Event` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Codes Radio
' . utf8($donnees['Event']) . '' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
' . "\n" ; echo '' . "\n" ; break; case "DB": $requete= "SELECT `rep_machines`.`K_Company`,`rep_machines`.`K_Number`,`rep_machines`.`K_Identifier`,`rep_relations`.`N_Type`, `rep_relations`.`N_Number`,`rep_mutations`.`Date_Out`,`rep_mutations`.`Date_in`,`rep_mutations`.`Comment` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_mutations`.`Date_Out`)>19500000) and ((`rep_mutations`.`Depot`) = 'Allemagne') and ((`rep_relations`.`Comment_FR`) ='Restitution') and ((`rep_relations`.`N_Date`) > 19500000)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC"; // echo $requete . "\n" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $type = ""; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } echo '
Locomotives restituées par la DB en 1950
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '' . utf8($donnees['Comment']) . '
' . "\n" ; echo '' . "\n" ; break; case "DBR": $requete= "SELECT `rep_machines`.`K_Company`,`rep_machines`.`K_Number`,`rep_machines`.`K_Identifier`,`rep_relations`.`N_Type`, `rep_relations`.`N_Number` FROM (`rep_machines` INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`)) WHERE (((`rep_relations`.`Comment_FR`) = '" . utf8_PC_none('Restituée à la DB') . "') and ((`rep_relations`.`N_Date`) > 19500000)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC"; // $requete= "SELECT `rep_machines`.`K_Company`,`rep_machines`.`K_Number`,`rep_machines`.`K_Identifier`,`rep_relations`.`N_Type`, `rep_relations`.`N_Number`,`rep_mutations`.`Date_Out`,`rep_mutations`.`Comment` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`Comment_FR`) = '" . utf8_PC_none('Restituée à la DB') . "') and ((`rep_relations`.`N_Date`) > 19500000)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC"; // echo $requete . "\n" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $type = ""; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } echo '
Locomotives restituées à DB en 1950
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']) . '
' . "\n" ; echo '' . "\n" ; break; case "DC": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('Dossier Constructeur') . '" ORDER BY `rep_events`.`Type_NL` ASC, `rep_events`.`Event` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); // echo $nblignes; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Dossiers Constructeurs
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Type_NL']) . '' . utf8($donnees['Event']) . '
' . "\n" ; echo '' . "\n" ; break; case "DEC": $requete= 'SELECT `rep_machines`.`K_Identifier`, `rep_machines`.`K_Number`, `rep_machines`.`K_Company`, `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_events`.`Event`, `rep_events`.`Date_in`, `rep_events`.`Date_Out`, `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE `rep_events`.`Type_FR` = "Decauville" ORDER BY `rep_events`.`Event`+0 ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Exposition" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; // echo '' . "\n" ; } echo '
Decauville ['. $nblignes . ']
'; } elseif (is_numeric($donnees['Fab_Number'])) { $Fab_Number=number_format($donnees['Fab_Number'], 0, ",", "."); } else { $Fab_Number=$donnees['Fab_Number']; } echo '
Decauville N° ' . utf8($donnees['Event']) . '' . utf8($donnees['Constructeur']) . ' N° ' . $Fab_Number . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
'; echo '' . "\n" ; break; case "DED": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Dedicated" ORDER BY `rep_events`.`K_Number` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` = 'Deceased' order by `rep_events`.`Date_in` DESC;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); $requete2= "SELECT * FROM rep_events WHERE (`rep_events`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_events`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_events`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') AND `rep_events`.`Type_FR` = 'Buried' order by `rep_events`.`Date_in` DESC;" ; // echo $requete1; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $nblignes2 = mysqli_num_rows($reponse2); echo '' . "\n" ; } echo '' . "\n" ; echo '
Locomotives dédiées en 1945 / Locomotives dedicated in 1945
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo 'dédiée à ' . utf8($donnees['Type_NL']) . ' le '. date8($donnees['Date_in']) . ' à ' . utf8($donnees['Event']) . ''; if ($nblignes1 <> 0) { $donnees1 = mysqli_fetch_array($reponse1); echo ', décédé à '. utf8($donnees1['Type_NL']) . ' le '. date8($donnees1['Date_in']); } if ($nblignes2 <> 0) { $donnees2 = mysqli_fetch_array($reponse2); echo ', inhumé à '. utf8($donnees2['Type_NL']) . ' le '. date8($donnees2['Date_in']); } echo '

On February 27, 1945 (and in the following weeks), 16 USA/TC locomotives were dedicated in Liège in memory of soldiers/railroaders who gave their lives for our freedom.
Some information can be found in the Pictorial Handbook of Military Transportation on page 34 (PDF 36). Unfortunately the resolution of the PDF does not allow any conclusion to be drawn (Request to the Bangor Public Library tell us that the resolution of the original book is of the same poor quality).

Still searching missing information.
'; echo '' . "\n" ; break; case "EM": $requete= 'SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `relations_1`.`N_Number`, `relations_1`.`N_Type`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM ((`rep_machines` INNER JOIN `rep_relations` ON (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`)) INNER JOIN `rep_relations` AS `relations_1` ON (`rep_machines`.`K_Company` = `relations_1`.`K_Company`) AND (`rep_machines`.`K_Number` = `relations_1`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `relations_1`.`K_Identifier`)) INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) WHERE ((`rep_relations`.`Comment_FR`) = "Convention Eupen-Malmedy") AND ((`relations_1`.`N_Date`) = 19260901 OR (`relations_1`.`N_Date`) = 19400800) AND (((`rep_mutations`.`Depot`) = "Allemagne")) ORDER BY `relations_1`.`N_Number` ASC;'; // echo $requete . "\n" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $type=""; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } echo '
Locomotives emmenées suite à la convention Eupen-Malmedy - date de restitution
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']) . ''; if ($donnees['Date_Out'] == 0) { echo 'Perdue'; } else { echo (date8($donnees['Date_Out'])); } echo '
' . "\n" ; echo '' . "\n" ; break; case "ES": if (isset($_GET['es'])) { $test_table=0; $get_essieux=validate_data($_GET['es']); $requete1= 'SELECT * FROM (SELECT `rep_machines`.`Axes`, "Transformation" as `Trans` FROM rep_machines UNION select `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE (`Test`.`Axes` <> "" AND `Test`.`Trans` = "Transformation" ) ORDER BY `Test`.`Axes` ASC;' ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); while ($donnees1 = mysqli_fetch_array($reponse1) ) { if (utf8($donnees1['Axes']) == str_replace($essieureplace,$essieusearch,($get_essieux))) { $requete= 'SELECT * FROM rep_machines WHERE `rep_machines`.`Axes` = "'. str_replace($essieureplace,$essieusearch,($get_essieux)) . '" ORDER BY `rep_machines`.`Date_In` ASC,`rep_machines`.`Constructeur` ASC,`rep_machines`.`Fab_Number`+0 ASC;' ; // $requete= 'SELECT * FROM rep_machines WHERE `rep_machines`.`Axes` = "'. str_replace($essieureplace,$essieusearch,($get_essieux)) . '" ORDER BY `rep_machines`.`K_Company` ASC,`rep_machines`.`K_Number` ASC,`rep_machines`.`K_Identifier` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { $test_table=1; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } } $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Transformation" AND `rep_events`.`Type_NL` = "'. str_replace($essieureplace,$essieusearch,($get_essieux)) . '" ORDER BY `rep_events`.`Date_in` ASC,`rep_events`.`K_Company` ASC,`rep_events`.`K_Number` ASC,`rep_events`.`K_Identifier` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); if ($nblignes > 0) { if ($test_table ==0) { echo '
Disposition des essieux : ' . str_replace($essieureplace,$essieusearch,($get_essieux)) . '
' . utf8($donnees['K_Company']) . '' . utf8($donnees['Type']) . '' . utf8($donnees['Constructeur']) . '' . utf8($donnees['Usine']) . ''; if ($donnees['Fab_Number'] == "0") { $numfab =""; } elseif (is_numeric($donnees['Fab_Number'])) { $numfab = number_format($donnees['Fab_Number'], 0, ",", "."); } else { $numfab = utf8($donnees['Fab_Number']); } if ($donnees['Date_In'] == "0") { $numfab = $numfab . '/0000'; } else { $numfab = $numfab . '/' . number_format($donnees['Date_In'] /10000, 0, "", ""); } echo $numfab . '' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
'; } echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete2= 'SELECT * FROM rep_machines WHERE `rep_machines`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_machines`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_machines`.`K_Identifier` = "' . $donnees['K_Identifier'] . '" ;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; } } echo '
Machines transformées en ' . str_replace($essieureplace,$essieusearch,($get_essieux)) . '
' . utf8($donnees['K_Company']) . '' . utf8($donnees2['Type']) . '' . utf8($donnees2['Constructeur']) . '' . utf8($donnees2['Usine']) . ''; if ($donnees2['Fab_Number'] == "0") { $numfab =""; } elseif (is_numeric($donnees2['Fab_Number'])) { $numfab = number_format($donnees2['Fab_Number'], 0, ",", "."); } else { $numfab = utf8($donnees2['Fab_Number']); } if ($donnees['Date_in'] == "0") { $numfab = $numfab . '/0000'; } else { $numfab = $numfab . '/' . number_format($donnees['Date_in'] /10000, 0, "", ""); } echo $numfab . '' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
' . "\n" ; echo '' . "\n" ; } } } else { $requete= 'SELECT * FROM (SELECT `rep_machines`.`Axes`, "Transformation" as `Trans` FROM rep_machines UNION select `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE (`Test`.`Axes` <> "" AND `Test`.`Axes` <> "cdR" AND `Test`.`Trans` = "Transformation" ) ORDER BY `Test`.`Axes` ASC;' ; // $requete= 'SELECT distinct `rep_machines`.`Axes` FROM rep_machines WHERE `rep_machines`.`Axes` <> "" ORDER BY `rep_machines`.`Axes` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo '
Disposition des essieux
' . "\n" ; echo '' . "\n" ; } break; case "ESS": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Essais" ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Essais
' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '' . utf8($donnees['Event']) . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
' . "\n" ; echo '' . "\n" ; break; case "EX": $requete= 'SELECT `rep_machines`.`K_Identifier`, `rep_machines`.`K_Number`, `rep_machines`.`K_Company`, `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_events`.`Event`, `rep_events`.`Date_in`, `rep_events`.`Date_Out`, `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE `rep_events`.`Type_FR` = "Exposition" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Company` ASC, `rep_events`.`K_Number` ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Exposition" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo '
Expositions
'; $expo=0; $expotxt=""; while ($donnees = mysqli_fetch_array($reponse) ) { if (($donnees['Date_in'] <> $expo) or ($donnees['Event'] <> $expotxt)) { if ($expo <> 0) { echo ''; } echo '' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')
' . "\n" ; echo '' . "\n" ; break; case "EXP": case "EXPA": if (isset($_GET['exp'])) { $get_exportation=validate_data($_GET['exp']); $requete= "SELECT DISTINCT `rep_machines`.`K_Country` FROM `rep_machines`;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $exportation="NOK"; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['K_Country'] == $_GET['exp']) { $exportation="OK"; } } // echo 'test : ' . $exportation; if ($exportation <> "NOK") { $requete= 'SELECT * FROM rep_machines WHERE `rep_machines`.`K_Category` = "Exportation" AND `rep_machines`.`K_Country` = "' . $_GET['exp'] . '" ORDER BY `rep_machines`.`K_Company` ASC, `rep_machines`.`K_Number`+0 ASC, `rep_machines`.`K_Identifier`+0 ASC ;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Exportations' . ' - ' . $_GET['exp'] . ' ['. $nblignes . ']
' . utf8($donnees['K_Company']) . '' . utf8($donnees['Type']) . '' . utf8($donnees['Axes']) . '' . utf8($donnees['Constructeur']) . '' . utf8($donnees['Usine']) . ''; if ($donnees['Fab_Number'] == "0") { } elseif (is_numeric($donnees['Fab_Number'])) { echo number_format($donnees['Fab_Number'], 0, ",", "."); } else { echo utf8($donnees['Fab_Number']); } echo '' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": echo ""; break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; default: echo '' . utf8($donnees['K_Identifier']); } echo '' . "\n" ; echo photo($conn, $donnees['K_Company'] , $donnees['K_Number'] , $donnees['K_Identifier']); echo '
' . "\n" ; } } else { $requete= 'SELECT COUNT(*) as total FROM rep_machines WHERE `rep_machines`.`K_Category` = "Exportation" ;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $donnees = mysqli_fetch_array($reponse); $total = $donnees['total']; // echo $total; if ($get_const == 'EXP') { $requete= 'SELECT `rep_machines`.`K_Country`, COUNT(*) as nombre FROM rep_machines WHERE `rep_machines`.`K_Category` = "Exportation" GROUP BY `rep_machines`.`K_Country` ORDER BY COUNT(*) DESC;' ; } else { $requete= 'SELECT `rep_machines`.`K_Country`, COUNT(*) as nombre FROM rep_machines WHERE `rep_machines`.`K_Category` = "Exportation" GROUP BY `rep_machines`.`K_Country` ORDER BY `rep_machines`.`K_Country` ASC;' ; } // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $expo=""; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '' . "\n" ; echo '
Statistiques exportations
' . utf8($donnees['K_Country']) . '' . $donnees['nombre'] . '' . number_format(round($donnees['nombre']/$total,4)*100,2) . ' %

Les listes constructeurs n'étant pas complètes, ces statistiques ne sont qu'indicatives.
' . "\n" ; echo '' . "\n" ; } break; case "FES": $requete= 'SELECT `rep_machines`.`K_Identifier`, `rep_machines`.`K_Number`, `rep_machines`.`K_Company`, `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_events`.`Event`, `rep_events`.`Date_in`, `rep_events`.`Date_Out`, `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE `rep_events`.`Type_FR` = "Festival" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Company` ASC, `rep_events`.`K_Number` ASC;' ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo '
Festivals
'; $festival=""; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['Event']) <> $festival) { if ($festival <> "") { echo ''; } $requete3= 'SELECT * FROM rep_associations WHERE `rep_associations`.`Nom` = "' . $donnees['Type_NL'] . '" ;' ; $reponse3=mysqli_query($conn, $requete3); test_requete($reponse3,$conn); $donnees3 = mysqli_fetch_array($reponse3); echo '' . utf8($donnees['Type_NL']) . ' - ' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')
' . "\n" ; echo '' . "\n" ; break; case "FG": $requete= 'SELECT * FROM rep_events WHERE (`rep_events`.`Type_FR` = "Faits de guerre") ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Faits de guerre
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . date8($donnees['Date_in']) . '' . utf8($donnees['Event']) . '
'; echo '' . "\n" ; break; case "GI": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Event` LIKE "%' . encodeToUtf8('Giesl') . '%" ORDER BY `rep_events`.`Date_in` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Echappement Giesl
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '
' . "\n" ; echo '' . "\n" ; break; case "INA": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Inauguration" ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Inaugurations
' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '' . utf8($donnees['Event']) . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
' . "\n" ; echo '' . "\n" ; break; case "LI": $requete= "SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`) <> 'Type 23' and (`rep_relations`.`N_Type`) <> 'Type 62' and (`rep_relations`.`N_Type`) <> 'Type 64' and (`rep_relations`.`N_Type`) <> 'Type 71' and (`rep_relations`.`N_Type`) <> 'Type 72' and (`rep_relations`.`N_Type`) <> 'Type 80' and (`rep_relations`.`N_Type`) <> 'Type 81' and (`rep_relations`.`N_Type`) <> 'Type 90' and (`rep_relations`.`N_Type`) <> 'Type 93' and (`rep_relations`.`N_Type`) <> 'Type 96' and (`rep_relations`.`N_Type`) <> 'Type 97' and (`rep_relations`.`N_Type`) <> 'Type 98') and ((`rep_mutations`.`Comment`) like '" . utf8_PC_none('%Identifiée par la SNCF%') . "') and ((`rep_relations`.`N_Date`) = 19311001 or (`rep_relations`.`N_Date`) = 19260901 or (`rep_relations`.`N_Date`) = 19250101)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC;"; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; $type=""; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; } echo '
Locomotives identifiées en France en 1945, 1946 et 1947
' . utf8($donnees['N_Type']) . '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . date8(substr($donnees['Comment'],-24,8)) . '
' . "\n" ; echo '' . "\n" ; break; case "LL": $requete= "SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Date_in`, `rep_mutations`.`Comment`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`) <> 'Type 23' and (`rep_relations`.`N_Type`) <> 'Type 61' and (`rep_relations`.`N_Type`) <> 'Type 62' and (`rep_relations`.`N_Type`) <> 'Type 64' and (`rep_relations`.`N_Type`) <> 'Type 71' and (`rep_relations`.`N_Type`) <> 'Type 72' and (`rep_relations`.`N_Type`) <> 'Type 80' and (`rep_relations`.`N_Type`) <> 'Type 81' and (`rep_relations`.`N_Type`) <> 'Type 90' and (`rep_relations`.`N_Type`) <> 'Type 93' and (`rep_relations`.`N_Type`) <> 'Type 96' and (`rep_relations`.`N_Type`) <> 'Type 97' and (`rep_relations`.`N_Type`) <> 'Type 98') and ((`rep_mutations`.`Comment`) like 'Leihlok%') and ((`rep_relations`.`N_Date`) = 19311001 or (`rep_relations`.`N_Date`) = 19260901 or (`rep_relations`.`N_Date`) = 19250101)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC;"; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; $type=""; echo '"; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } echo '
Liste des locomotives prêtées à l'. "'Allemagne (Leihloks)
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . date8($donnees['Date_in']) . '' . substr(utf8($donnees['Comment']),9); $requete1 = "SELECT `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment` from `rep_mutations` WHERE `rep_mutations`.`K_Company` = '" . $donnees['K_Company'] . "' AND `rep_mutations`.`K_Number` = '" . $donnees['K_Number'] . "' AND `rep_mutations`.`K_Identifier` = '" . $donnees['K_Identifier'] . "' AND `rep_mutations`.`Depot` = 'Pays-Bas';"; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); if ($nblignes1 == 0) { if ($donnees['Date_Out'] == 0) { echo '' . 'Perdue'; } else { echo '' . (date8($donnees['Date_Out'])); } } else { $donnees1 = mysqli_fetch_array($reponse1); if (substr(utf8($donnees['Comment']),9) != "") { echo '. '; } echo utf8($donnees1['Comment']); echo '' . (date8($donnees1['Date_Out'])); } echo '
' . "\n" ; echo '' . "\n" ; break; case "MGDB": $requete= "SELECT `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_relations`.`N_Company`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_events`.`Type_NL`, `rep_events`.`Event`, `rep_events`.`Date_in` FROM (`rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Company`)='MGDB') AND ((`rep_events`.`Type_FR`)='MGDB')) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Affectation des locomotives en 1914-1918
' . utf8($donnees['N_Type']) . '' . utf8($donnees['N_Number']) . '' . utf8($donnees['Type_NL']) . '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '
' . "\n" ; echo '' . "\n" ; break; case "MH": $requete= 'SELECT * FROM rep_events WHERE (`rep_events`.`Type_FR` = "Classement MH") ORDER BY `rep_events`.`Date_in` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND `rep_relations`.`N_Date` < ' . $donnees['Date_in'] . ' ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; } echo '
Locomotives classées Monument Historique (France)
' . utf8($donnees2['N_Company']) . ' - ' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; default: echo '
' . $donnees2['N_Identifier'] . '
' ; } echo '		' . $donnees['Event'] . ' le : ' . date8($donnees['Date_in']) . ' sous la notice : ' . $donnees['Type_NL'] . '
'; echo '' . "\n" ; break; case "MOT": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('Moteur') . '" and `rep_events`.`Year_PV` <> 0 ORDER BY `rep_events`.`Type_NL` ASC, `rep_events`.`Year_PV`, `rep_events`.`Date_in` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $Marque="brol"; $Mot=0; while ($donnees = mysqli_fetch_array($reponse) ) { $requete2= 'SELECT * FROM rep_relations WHERE `rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '" AND `rep_relations`.`N_Company` ="SNCB" AND `rep_relations`.`N_Type` <> "Type A621" AND `rep_relations`.`N_Type` NOT LIKE "ES%" ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); if ($Marque <> $donnees['Type_NL'] ) { echo '' . "\n" ; $Mot = 0; $Marque = $donnees['Type_NL']; } if ($Mot <> $donnees['Year_PV'] ) { echo '' . "\n" ; $Mot = $donnees['Year_PV']; } echo '' . "\n" ; } echo '
Moteurs
' . utf8($donnees['Type_NL']) . '
' . utf8($donnees['Year_PV']); if ($donnees['Event'] <>"" ) { echo ' (' . utf8($donnees['Event']) . ')'; } echo '
' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; } echo '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '
' . "\n" ; echo '' . "\n" ; break; case "NA": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('Numéro d agrément') . '" ORDER BY `rep_events`.`Event` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Numéros d' . "'" . 'agrément
' . utf8($donnees['Event']) . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
' . "\n" ; echo '' . "\n" ; break; case "NI": $requete= 'SELECT * FROM rep_unindentified ORDER BY `rep_unindentified`.`K_Type` ASC, `rep_unindentified`.`K_Company` ASC, `rep_unindentified`.`K_Number` ASC, `rep_unindentified`.`K_Identifier` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo '' . "\n" ; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Locomotives non-identifiées
' . utf8($donnees['K_Type']) . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Source']) . '
' . "\n" ; echo '' . "\n" ; break; case "NO": $requete= 'SELECT * FROM rep_machines WHERE `rep_machines`.`K_Company` = "' . utf8_PC_none('Etat Belge') . '" AND `rep_machines`.`Surname` <> "" AND `rep_machines`.`Date_in` < 18500000 ORDER BY `rep_machines`.`K_Number`+0 ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Noms des premières Locomotives
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Surname']) . '
' . "\n" ; echo '' . "\n" ; break; case "OA": $requete= "SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Number`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment`, `rep_relations`.`N_Type`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_mutations`.`Comment`) LIKE 'Offensive des Ardennes%') and ((`rep_relations`.`N_Type`) <> 'Type 37' and (`rep_relations`.`N_Type`) <> 'Type 37' and (`rep_relations`.`N_Type`) <> 'Type 32' and (`rep_relations`.`N_Type`) <> 'Type 31 ancien') and ((`rep_relations`.`N_Date`) =19311001 or (`rep_relations`.`N_Date`) = 19380610 or (`rep_relations`.`N_Date`) = 19380616 or (`rep_relations`.`N_Date`) = 19260901 or (`rep_relations`.`N_Date`) = 19410205) AND ((`rep_mutations`.`Depot`) = 'Allemagne')) ORDER BY `rep_relations`.`N_Number` ASC, `rep_relations`.`N_Type` ASC , `rep_relations`.`N_Date` DESC;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo '"; $immatdiff = array(); $type=""; while ($donnees = mysqli_fetch_array($reponse) ) { $keydiff = utf8($donnees['K_Company']) .'@' . utf8($donnees['K_Number']) .'@' . utf8($donnees['K_Identifier']); if (! (array_key_exists($keydiff,$immatdiff))) { $immatdiff[$keydiff] = $keydiff ; echo '' . "\n" ; } } echo '
Locomotive emmenée lors de l' . "'offensive des Ardennes en décembre 1944
'; if (utf8($donnees['N_Type']) <> $type) { echo '' . utf8($donnees['N_Type']) . ''; $type = utf8($donnees['N_Type']); } echo '' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo ''; if ($donnees['Date_Out'] == 0) { echo 'Perdue'; } else { echo (date8($donnees['Date_Out'])); } echo '
' . "\n" ; echo '' . "\n" ; break; case "PB": $requete= "SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Date_in`, `rep_mutations`.`Comment`, `rep_mutations`.`Depot`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`) <> 'Type 23' and (`rep_relations`.`N_Type`) <> 'Type 61' and (`rep_relations`.`N_Type`) <> 'Type 62' and (`rep_relations`.`N_Type`) <> 'Type 64' and (`rep_relations`.`N_Type`) <> 'Type 71' and (`rep_relations`.`N_Type`) <> 'Type 72' and (`rep_relations`.`N_Type`) <> 'Type 80' and (`rep_relations`.`N_Type`) <> 'Type 81' and (`rep_relations`.`N_Type`) <> 'Type 90' and (`rep_relations`.`N_Type`) <> 'Type 93' and (`rep_relations`.`N_Type`) <> 'Type 96' and (`rep_relations`.`N_Type`) <> 'Type 97' and (`rep_relations`.`N_Type`) <> 'Type 98') and ((`rep_mutations`.`Depot`) = 'Pays-Bas') and ((`rep_relations`.`N_Date`) = 19311001 or (`rep_relations`.`N_Date`) = 19260901 or (`rep_relations`.`N_Date`) = 19250101)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC;"; // $requete= 'SELECT * FROM rep_mutations WHERE (`rep_mutations`.`Depot` = "Pays-Bas" AND `rep_mutations`.`Date_Out` > 19450000 AND `rep_mutations`.`Date_Out` < 19460000) ORDER BY `rep_mutations`.`K_Company` ASC, `rep_mutations`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { // $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB" OR `rep_relations`.`N_Company` ="ETAT BELGE" OR `rep_relations`.`N_Company` ="SNCV" OR `rep_relations`.`N_Company` ="Sjaellandske Jernbane Selskab" OR `rep_relations`.`N_Company` ="USA/TC" OR `rep_relations`.`N_Company` ="Bruxelles-Tervueren" OR `rep_relations`.`N_Company` ="CFL" OR `rep_relations`.`N_Company` ="CFV3V" OR `rep_relations`.`N_Company` ="LINEAS") AND `rep_relations`.`N_Type` <> "Type A621" AND `rep_relations`.`N_Type` NOT LIKE "ES%" ORDER BY `rep_relations`.`N_Date` DESC;' ; $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB") AND `rep_relations`.`N_Date` < 19460000 ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo ''; echo '' . "\n" ; } echo '
Leihloks retrouvées aux Pays-Bas [' . $nblignes . ']
' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; } echo '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '' . utf8($donnees['Comment']) . '
'; echo '' . "\n" ; break; case "PE": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Pelliculage" ORDER BY `rep_events`.`K_Number` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Pelliculage
' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '' . date8($donnees['Date_Out']) . '
' . "\n" ; echo '' . "\n" ; break; case "PG": $requete= 'SELECT * FROM rep_relations WHERE `rep_relations`.`Comment_FR` = "Prise de guerre" ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; $type=""; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } echo '
Prises de guerre
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . date8($donnees['N_Date']) . '
' . "\n" ; echo '' . "\n" ; break; case "PLA": $requete= "SELECT `rep_machines`.`K_Company`,`rep_machines`.`K_Number`,`rep_machines`.`K_Identifier`,`rep_photos`.`Image`, `rep_photos`.`repertoire`, `rep_photos`.`Comment_FR`,`rep_machines`.`Fab_Number`,`rep_machines`.`Constructeur` FROM (`rep_machines` INNER JOIN `rep_photos` ON (`rep_machines`.`K_Identifier` = `rep_photos`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_photos`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_photos`.`K_Company`)) WHERE (((`rep_photos`.`Image`) not like '228.%') and ((`rep_photos`.`Repertoire`) like '0000-00 Plaques%') and ((`rep_machines`.`Fab_Number`) <> '0')) ORDER BY `rep_machines`.`Constructeur` ASC, `rep_machines`.`Fab_Number` ASC"; // echo $requete . "\n" ; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Plaques constructeur

' . $donnees['Comment_FR'] . '
' . "\n" ; echo '' . "\n" ; break; case "PR": $requete= 'SELECT `rep_events`.*, `rep_machines`.`Constructeur_Reel`, `rep_machines`.`Fab_Number` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('Préservation') . '" ORDER BY `rep_machines`.`Constructeur_Reel`, `rep_machines`.`Fab_Number`+0, `rep_machines`.`K_Number`, `rep_events`.`Date_in` DESC ;'; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $compagnie='brol'; $numero='brol'; $ident='brol'; while ($donnees = mysqli_fetch_array($reponse) ) { if ( (utf8($donnees['K_Company']) <> $compagnie) OR (utf8($donnees['K_Number']) <> $numero) OR (utf8($donnees['K_Identifier']) <> $ident) ) { $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") ORDER BY `rep_relations`.`N_Follow` DESC, `rep_relations`.`N_Date` DESC LIMIT 1;' ; // echo $requete2; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; $compagnie=utf8($donnees['K_Company']); $numero=utf8($donnees['K_Number']); $ident=utf8($donnees['K_Identifier']); } } echo '
Locomotives préservées
' . utf8($donnees2['N_Company']) . ' - ' . utf8($donnees2['N_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; } echo '' . utf8($donnees['Constructeur_Reel']); if (utf8($donnees['Fab_Number']) <> 0) { echo ' (' . utf8($donnees['Fab_Number']) . ')'; } echo '' . utf8($donnees['Type_NL']) . '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '
' . "\n" ; echo '' . "\n" ; break; case "PV": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('PV de radiation') . '" ORDER BY `rep_events`.`Year_PV` ASC, `rep_events`.`Event`+0 ASC, `rep_events`.`K_Company` ASC, `rep_events`.`K_Number` ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('PV de radiation') . '" and `rep_events`.`Event` <> "" ORDER BY `rep_events`.`Year_PV` ASC, `rep_events`.`Event`+0 ASC, `rep_events`.`K_Company` ASC, `rep_events`.`K_Number` ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('PV de radiation') . '" and `rep_events`.`Date_in` <> 0 and `rep_events`.`Date_Out` <> 0 ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Company` ASC, `rep_events`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $num=0; $Ye=0; while ($donnees = mysqli_fetch_array($reponse) ) { $requete2= 'SELECT * FROM rep_relations WHERE `rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '" AND `rep_relations`.`N_Company` ="SNCB" AND `rep_relations`.`N_Type` <> "Type A621" AND `rep_relations`.`N_Type` NOT LIKE "ES%" ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); if ($Ye <> $donnees['Year_PV'] ) { echo '' . "\n" ; $num = 0; $Ye = $donnees['Year_PV']; } if ($num <> $donnees['Event'] ) { echo '' . "\n" ; $num = $donnees['Event']; } echo '' . "\n" ; } echo '
PV de radiation
' . utf8($donnees['Year_PV']) . '
' . utf8($donnees['Event']); if ($donnees['Type_NL'] <>"" ) { echo ' (' . utf8($donnees['Type_NL']) . ')'; } echo '
' . utf8($donnees2['N_Number']); switch($donnees2['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees2['N_Identifier'] . ")"; break; } echo '
' . "\n" ; echo '' . "\n" ; break; case "R1": // $requete= "SELECT `rep_mutations`.`K_Company`, `rep_mutations`.`K_Number`, `rep_mutations`.`K_Identifier`, `rep_mutations`.`Date_in`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Depot`, `rep_mutations`.`Comment`, `rep_relations`.`N_Company`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_relations`.`N_Identifier`,`rep_relations`.`N_Date` FROM `rep_mutations` INNER JOIN `rep_relations` ON (`rep_mutations`.`K_Company`=`rep_relations`.`K_Company`) AND (`rep_mutations`.`K_Number`=`rep_relations`.`K_Number`) AND (`rep_mutations`.`K_Identifier`=`rep_relations`.`K_Identifier`) WHERE (((`rep_mutations`.`Date_in`)=19440920) AND ((`rep_mutations`.`Date_Out`) = 19440920) AND ((`rep_relations`.`N_Company`)='SNCB') AND ((`rep_relations`.`N_Date`) < 19440920)) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC, `rep_relations`.`N_Date` DESC;" ; $requete= "SELECT `rep_mutations`.`K_Company`, `rep_mutations`.`K_Number`, `rep_mutations`.`K_Identifier`, `rep_mutations`.`Date_in`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Depot`, `rep_mutations`.`Comment`, `rep_relations`.`N_Company`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_relations`.`N_Identifier`,`rep_relations`.`N_Date` FROM `rep_mutations` INNER JOIN `rep_relations` ON (`rep_mutations`.`K_Company`=`rep_relations`.`K_Company`) AND (`rep_mutations`.`K_Number`=`rep_relations`.`K_Number`) AND (`rep_mutations`.`K_Identifier`=`rep_relations`.`K_Identifier`) WHERE (((`rep_mutations`.`Date_in`)=19440920) AND ((`rep_mutations`.`Date_Out`) = 19440920) AND (((`rep_relations`.`N_Company`)='SNCB') OR ((`rep_relations`.`N_Company`)='Compagnie de Chimay')) AND ((`rep_relations`.`N_Date`) < 19440920) AND ((`rep_relations`.`N_Number`) NOT LIKE '(%')) ORDER BY `rep_relations`.`N_Type` ASC, `rep_relations`.`N_Number` ASC, `rep_relations`.`N_Date` DESC;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $immatdiff = array(); $company="brol"; $type="brol"; while ($donnees = mysqli_fetch_array($reponse) ) { $keydiff = utf8($donnees['K_Company']) .'@' . utf8($donnees['K_Number']) .'@' . utf8($donnees['K_Identifier']); if (! (array_key_exists($keydiff,$immatdiff))) { $immatdiff[$keydiff] = $donnees['N_Date'] ; } elseif ($immatdiff[$keydiff] < $donnees['N_Date']) { $immatdiff[$keydiff] = $donnees['N_Date'] ; } } $reponse=mysqli_query($conn, $requete); while ($donnees = mysqli_fetch_array($reponse) ) { $keydiff = utf8($donnees['K_Company']) .'@' . utf8($donnees['K_Number']) .'@' . utf8($donnees['K_Identifier']); if ($immatdiff[$keydiff] == $donnees['N_Date']) { if (utf8($donnees['N_Company']) <> $company) { echo '' . "\n" ; $company = utf8($donnees['N_Company']); } if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } } echo '
Recensement du 20 septembre 1944
' . utf8($donnees['N_Company']) . '
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . utf8($donnees['Depot']) . '' . utf8($donnees['Comment']) . '
' . "\n" ; echo '' . "\n" ; break; case "RAD": if (isset($_GET['rad'])) { $test_table=0; $get_rad=validate_data($_GET['rad']); if ($get_rad < 1946 or $get_rad > 1967) {$get_rad = 1946;} switch($get_rad) { case "1946": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19460000 And (`rep_mutations`.`Date_Out`)<19470000) And ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19460700) And ((`rep_machines`.`Date_Out`)>19460000 And (`rep_machines`.`Date_Out`)<19470000) And ((`rep_relations`.`N_Type`)<>'Série 56')) Or ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19460000 And (`rep_mutations`.`Date_Out`)<19470000) And ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19460700) And ((`rep_machines`.`Write-off`)>19460000 And (`rep_machines`.`Write-off`)<19470000) And ((`rep_relations`.`N_Type`)<>'Série 56')) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1947": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)= `rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`) = ( `rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19470000 AND (`rep_mutations`.`Date_Out`) < 19480000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19461000) AND ((`rep_machines`.`Date_Out`) > 19470000 AND (`rep_machines`.`Date_Out`) < 19480000)) OR ((((`rep_mutations`.`Date_Out`) = `rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`) = (`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19470000 AND (`rep_mutations`.`Date_Out`) < 19480000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19461000) AND ((`rep_machines`.`Write-off`) > 19470000 AND (`rep_machines`.`Write-off`) < 19480000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1948": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19480000 AND (`rep_mutations`.`Date_Out`) < 19490000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Date_Out`) > 19480000 AND (`rep_machines`.`Date_Out`) < 19490000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19480000 AND (`rep_mutations`.`Date_Out`) < 19490000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19480000 AND (`rep_machines`.`Date_Out`) < 19490000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19480000 AND (`rep_mutations`.`Date_Out`) < 19490000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Write-off`) > 19480000 AND (`rep_machines`.`Write-off`) < 19490000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19480000 AND (`rep_mutations`.`Date_Out`) < 19490000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19480000 AND (`rep_machines`.`Write-off`) < 19490000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1949": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19490000 AND (`rep_mutations`.`Date_Out`) < 19500000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Date_Out`) > 19490000 AND (`rep_machines`.`Date_Out`) < 19500000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19490000 AND (`rep_mutations`.`Date_Out`) < 19500000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19490000 AND (`rep_machines`.`Date_Out`) < 19500000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19490000 AND (`rep_mutations`.`Date_Out`) < 19500000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Write-off`) > 19490000 AND (`rep_machines`.`Write-off`) < 19500000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19490000 AND (`rep_mutations`.`Date_Out`) < 19500000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19490000 AND (`rep_machines`.`Write-off`) < 19500000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1950": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19500000 AND (`rep_mutations`.`Date_Out`) < 19510000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Date_Out`) > 19500000 AND (`rep_machines`.`Date_Out`) < 19510000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19500000 AND (`rep_mutations`.`Date_Out`) < 19510000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19500000 AND (`rep_machines`.`Date_Out`) < 19510000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19500000 AND (`rep_mutations`.`Date_Out`) < 19510000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Write-off`) > 19500000 AND (`rep_machines`.`Write-off`) < 19510000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19500000 AND (`rep_mutations`.`Date_Out`) < 19510000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19500000 AND (`rep_machines`.`Write-off`) < 19510000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1951": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19510000 AND (`rep_mutations`.`Date_Out`) < 19520000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Date_Out`) > 19510000 AND (`rep_machines`.`Date_Out`) < 19520000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19510000 AND (`rep_mutations`.`Date_Out`) < 19520000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19510000 AND (`rep_machines`.`Date_Out`) < 19520000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19510000 AND (`rep_mutations`.`Date_Out`) < 19520000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Write-off`) > 19510000 AND (`rep_machines`.`Write-off`) < 19520000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19510000 AND (`rep_mutations`.`Date_Out`) < 19520000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19510000 AND (`rep_machines`.`Write-off`) < 19520000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1952": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19520000 AND (`rep_mutations`.`Date_Out`) < 19530000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Date_Out`) > 19520000 AND (`rep_machines`.`Date_Out`) < 19530000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19520000 AND (`rep_mutations`.`Date_Out`) < 19530000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19520000 AND (`rep_machines`.`Date_Out`) < 19530000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19520000 AND (`rep_mutations`.`Date_Out`) < 19530000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Write-off`) > 19520000 AND (`rep_machines`.`Write-off`) < 19530000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19520000 AND (`rep_mutations`.`Date_Out`) < 19530000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19520000 AND (`rep_machines`.`Write-off`) < 19530000) AND ((`rep_relations`.`Comment_FR`) NOT LIKE '%Chimay')) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1953": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19530000 AND (`rep_mutations`.`Date_Out`) < 19540000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Date_Out`) > 19530000 AND (`rep_machines`.`Date_Out`) < 19540000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19530000 AND (`rep_mutations`.`Date_Out`) < 19540000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19530000 AND (`rep_machines`.`Date_Out`) < 19540000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19530000 AND (`rep_mutations`.`Date_Out`) < 19540000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19470800) AND ((`rep_machines`.`Write-off`) > 19530000 AND (`rep_machines`.`Write-off`) < 19540000)) OR ((((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19530000 AND (`rep_mutations`.`Date_Out`) < 19540000) AND ((`rep_relations`.`N_Date`) > 19500300 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19530000 AND (`rep_machines`.`Write-off`) < 19540000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1954": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19540000 AND (`rep_mutations`.`Date_Out`) < 19550000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19540000 AND (`rep_machines`.`Date_Out`) < 19550000)) OR (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19540000 AND (`rep_mutations`.`Date_Out`) < 19550000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19540000 AND (`rep_machines`.`Date_Out`) < 19550000)) OR (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19540000 AND (`rep_mutations`.`Date_Out`) < 19550000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19540000 AND (`rep_machines`.`Write-off`) < 19550000)) OR (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19540000 AND (`rep_mutations`.`Date_Out`) < 19550000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19540000 AND (`rep_machines`.`Write-off`) < 19550000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1955": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19550000 AND (`rep_mutations`.`Date_Out`) < 19560000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19550000 AND (`rep_machines`.`Date_Out`) < 19560000)) OR (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19550000 AND (`rep_mutations`.`Date_Out`) < 19560000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Date_Out`) > 19550000 AND (`rep_machines`.`Date_Out`) < 19560000)) OR (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19550000 AND (`rep_mutations`.`Date_Out`) < 19560000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19550000 AND (`rep_machines`.`Write-off`) < 19560000)) OR (((`rep_relations`.`N_Type`) <> 'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` OR (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) AND (`rep_mutations`.`Date_Out`) <> 0 AND (`rep_mutations`.`Date_Out`) > 19550000 AND (`rep_mutations`.`Date_Out`) < 19560000) AND ((`rep_relations`.`N_Date`) > 19460100 AND (`rep_relations`.`N_Date`) < 19500800) AND ((`rep_machines`.`Write-off`) > 19550000 AND (`rep_machines`.`Write-off`) < 19560000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1956": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`Rep_relations`.`N_Type`)<>'Type 30') AND (((`Rep_mutations`.`Date_Out`)=`Rep_machines`.`Date_Out` Or (`Rep_mutations`.`Date_Out`) = (`Rep_machines`.`Write-off`)) And (`Rep_mutations`.`Date_Out`)<>0 And (`Rep_mutations`.`Date_Out`)>19560000 And (`Rep_mutations`.`Date_Out`)<19570000) AND ((`Rep_relations`.`N_Date`)>19460100 And (`Rep_relations`.`N_Date`)<19500800) AND ((`Rep_machines`.`Date_Out`)>19560000 And (`Rep_machines`.`Date_Out`)<19570000)) OR (((`Rep_relations`.`N_Type`)<>'Type 30') AND (((`Rep_mutations`.`Date_Out`)=`Rep_machines`.`Date_Out` Or (`Rep_mutations`.`Date_Out`)=(`Rep_machines`.`Write-off`)) And (`Rep_mutations`.`Date_Out`)<>0 And (`Rep_mutations`.`Date_Out`)>19560000 And (`Rep_mutations`.`Date_Out`)<19570000) AND ((`Rep_relations`.`N_Date`)>19460100 And (`Rep_relations`.`N_Date`)<19500800) AND ((`Rep_machines`.`Date_Out`)>19560000 And (`Rep_machines`.`Date_Out`)<19570000)) OR (((`Rep_relations`.`N_Type`)<>'Type 30') AND (((`Rep_mutations`.`Date_Out`)=`Rep_machines`.`Date_Out` Or (`Rep_mutations`.`Date_Out`)=(`Rep_machines`.`Write-off`)) And (`Rep_mutations`.`Date_Out`)<>0 And (`Rep_mutations`.`Date_Out`)>19560000 And (`Rep_mutations`.`Date_Out`)<19570000) AND ((`Rep_relations`.`N_Date`)>19460100 And (`Rep_relations`.`N_Date`)<19500800) AND ((`Rep_machines`.`Write-off`)>19560000 And (`Rep_machines`.`Write-off`)<19570000)) OR (((`Rep_relations`.`N_Type`)<>'Type 30') AND (((`Rep_mutations`.`Date_Out`)=`Rep_machines`.`Date_Out` Or (`Rep_mutations`.`Date_Out`)=(`Rep_machines`.`Write-off`)) And (`Rep_mutations`.`Date_Out`)<>0 And (`Rep_mutations`.`Date_Out`)>19560000 And (`Rep_mutations`.`Date_Out`)<19570000) AND ((`Rep_relations`.`N_Date`)>19460100 And (`Rep_relations`.`N_Date`)<19500800) AND ((`Rep_machines`.`Write-off`)>19560000 And (`Rep_machines`.`Write-off`)<19570000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`;"; break; case "1957": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19570000 And (`rep_mutations`.`Date_Out`)<19580000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19570000 And (`rep_machines`.`Date_Out`)<19580000) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%')) OR (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19570000 And (`rep_mutations`.`Date_Out`)<19580000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19570000 And (`rep_machines`.`Date_Out`)<19580000) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%')) OR (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19570000 And (`rep_mutations`.`Date_Out`)<19580000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%') AND ((`rep_machines`.`Write-off`)>19570000 And (`rep_machines`.`Write-off`)<19580000)) OR (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19570000 And (`rep_mutations`.`Date_Out`)<19580000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%') AND ((`rep_machines`.`Write-off`)>19570000 And (`rep_machines`.`Write-off`)<19580000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1958": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19580000 And (`rep_mutations`.`Date_Out`)<19590000) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%') AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19580000 And (`rep_machines`.`Date_Out`)<19590000)) OR (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19580000 And (`rep_mutations`.`Date_Out`)<19590000) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%') AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19580000 And (`rep_machines`.`Date_Out`)<19590000)) OR (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19580000 And (`rep_mutations`.`Date_Out`)<19590000) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%') AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19580000 And (`rep_machines`.`Write-off`)<19590000)) OR (((`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19580000 And (`rep_mutations`.`Date_Out`)<19590000) AND ((`rep_relations`.`Comment_FR`) Not Like '%Chimay%') AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19580000 And (`rep_machines`.`Write-off`)<19590000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1959": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19590000 And (`rep_mutations`.`Date_Out`)<19600000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19590000 And (`rep_machines`.`Date_Out`)<19600000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19590000 And (`rep_mutations`.`Date_Out`)<19600000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19590000 And (`rep_machines`.`Date_Out`)<19600000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19590000 And (`rep_mutations`.`Date_Out`)<19600000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19590000 And (`rep_machines`.`Write-off`)<19600000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19590000 And (`rep_mutations`.`Date_Out`)<19600000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19590000 And (`rep_machines`.`Write-off`)<19600000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1960": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'2-050 TB') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19600000 And (`rep_mutations`.`Date_Out`)<19610000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19600000 And (`rep_machines`.`Date_Out`)<19610000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'2-050 TB') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19600000 And (`rep_mutations`.`Date_Out`)<19610000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19600000 And (`rep_machines`.`Date_Out`)<19610000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'2-050 TB') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19600000 And (`rep_mutations`.`Date_Out`)<19610000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19600000 And (`rep_machines`.`Write-off`)<19610000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'2-050 TB') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19600000 And (`rep_mutations`.`Date_Out`)<19610000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19600000 And (`rep_machines`.`Write-off`)<19610000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1961": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19610000 And (`rep_mutations`.`Date_Out`)<19620000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19610000 And (`rep_machines`.`Date_Out`)<19620000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19610000 And (`rep_mutations`.`Date_Out`)<19620000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19610000 And (`rep_machines`.`Date_Out`)<19620000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19610000 And (`rep_mutations`.`Date_Out`)<19620000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19610000 And (`rep_machines`.`Write-off`)<19620000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19610000 And (`rep_mutations`.`Date_Out`)<19620000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19610000 And (`rep_machines`.`Write-off`)<19620000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1962": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19620000 And (`rep_mutations`.`Date_Out`)<19630000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19620000 And (`rep_machines`.`Date_Out`)<19630000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19620000 And (`rep_mutations`.`Date_Out`)<19630000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19620000 And (`rep_machines`.`Date_Out`)<19630000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19620000 And (`rep_mutations`.`Date_Out`)<19630000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19620000 And (`rep_machines`.`Write-off`)<19630000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19620000 And (`rep_mutations`.`Date_Out`)<19630000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19620000 And (`rep_machines`.`Write-off`)<19630000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1963": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19630000 And (`rep_mutations`.`Date_Out`)<19640000) AND ((`rep_relations`.`N_Date`)>19451228 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19630000 And (`rep_machines`.`Date_Out`)<19640000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19630000 And (`rep_mutations`.`Date_Out`)<19640000) AND ((`rep_relations`.`N_Date`)>19451228 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19630000 And (`rep_machines`.`Date_Out`)<19640000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19630000 And (`rep_mutations`.`Date_Out`)<19640000) AND ((`rep_relations`.`N_Date`)>19451228 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19630000 And (`rep_machines`.`Write-off`)<19640000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19630000 And (`rep_mutations`.`Date_Out`)<19640000) AND ((`rep_relations`.`N_Date`)>19451228 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19630000 And (`rep_machines`.`Write-off`)<19640000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1964": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19640000 And (`rep_mutations`.`Date_Out`)<19650000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19640000 And (`rep_machines`.`Date_Out`)<19650000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19640000 And (`rep_mutations`.`Date_Out`)<19650000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19640000 And (`rep_machines`.`Date_Out`)<19650000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19640000 And (`rep_mutations`.`Date_Out`)<19650000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19640000 And (`rep_machines`.`Write-off`)<19650000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 601' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19640000 And (`rep_mutations`.`Date_Out`)<19650000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19640000 And (`rep_machines`.`Write-off`)<19650000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1965": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19650000 And (`rep_mutations`.`Date_Out`)<19660000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19650000 And (`rep_machines`.`Date_Out`)<19660000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19650000 And (`rep_mutations`.`Date_Out`)<19660000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19650000 And (`rep_machines`.`Date_Out`)<19660000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19650000 And (`rep_mutations`.`Date_Out`)<19660000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19650000 And (`rep_machines`.`Write-off`)<19660000)) OR (((`rep_relations`.`N_Type`)<>'Type 551' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19650000 And (`rep_mutations`.`Date_Out`)<19660000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19650000 And (`rep_machines`.`Write-off`)<19660000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1966": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19660000 And (`rep_mutations`.`Date_Out`)<19670000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19660000 And (`rep_machines`.`Date_Out`)<19670000)) OR (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19660000 And (`rep_mutations`.`Date_Out`)<19670000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Date_Out`)>19660000 And (`rep_machines`.`Date_Out`)<19670000)) OR (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19660000 And (`rep_mutations`.`Date_Out`)<19670000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19660000 And (`rep_machines`.`Write-off`)<19670000)) OR (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19660000 And (`rep_mutations`.`Date_Out`)<19670000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19500800) AND ((`rep_machines`.`Write-off`)>19660000 And (`rep_machines`.`Write-off`)<19670000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; case "1967": $requete="SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Type`, `rep_relations`.`N_Number`, `rep_mutations`.`Depot`, `rep_mutations`.`Date_Out` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND ((`rep_relations`.`N_Number`)<>'81.581' And (`rep_relations`.`N_Number`)<>'55 5693') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19670000 And (`rep_mutations`.`Date_Out`)<19680000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19501000) AND ((`rep_machines`.`Date_Out`)>19670000 And (`rep_machines`.`Date_Out`)<19680000)) OR (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND ((`rep_relations`.`N_Number`)<>'81.581' And (`rep_relations`.`N_Number`)<>'55 5693') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19670000 And (`rep_mutations`.`Date_Out`)<19680000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19501000) AND ((`rep_machines`.`Date_Out`)>19670000 And (`rep_machines`.`Date_Out`)<19680000)) OR (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND ((`rep_relations`.`N_Number`)<>'81.581' And (`rep_relations`.`N_Number`)<>'55 5693') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19670000 And (`rep_mutations`.`Date_Out`)<19680000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19501000) AND ((`rep_machines`.`Write-off`)>19670000 And (`rep_machines`.`Write-off`)<19680000)) OR (((`rep_relations`.`N_Type`)<>'Type 671' And (`rep_relations`.`N_Type`)<>'Type 670' And (`rep_relations`.`N_Type`)<>'Type 30' And (`rep_relations`.`N_Type`)<>'WD 70.000') AND ((`rep_relations`.`N_Number`)<>'81.581' And (`rep_relations`.`N_Number`)<>'55 5693') AND (((`rep_mutations`.`Date_Out`)=`rep_machines`.`Date_Out` Or (`rep_mutations`.`Date_Out`)=(`rep_machines`.`Write-off`)) And (`rep_mutations`.`Date_Out`)<>0 And (`rep_mutations`.`Date_Out`)>19670000 And (`rep_mutations`.`Date_Out`)<19680000) AND ((`rep_relations`.`N_Date`)>19460100 And (`rep_relations`.`N_Date`)<19501000) AND ((`rep_machines`.`Write-off`)>19670000 And (`rep_machines`.`Write-off`)<19680000)) ORDER BY `rep_relations`.`N_Type`, `rep_relations`.`N_Number`; "; break; } // echo $requete1; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $type="brol"; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['N_Type'] <> $type) { echo '' . "\n" ; $type = $donnees['N_Type']; } echo '' ; echo '' . "\n" ; } } else { echo '
Mise hors écriture des locomotives à vapeur en ' . $get_rad . ' [' . $nblignes . ']
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']) . ''; $requete1= "SELECT * FROM rep_telegraphe WHERE `rep_telegraphe`.`Remise` = '" . utf8_inverse($donnees['Depot']) . "' ;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); $nblignes1 = mysqli_num_rows($reponse1); if ($nblignes1 == 0) { echo utf8($donnees['Depot']); } else { echo '' . utf8($donnees['Depot']) . ''; } echo '' . date8($donnees['Date_Out']) . '
'; echo ''; } echo '
Années de mise hors écriture des locomotives à vapeur
    ' . "\n"; for ($j = 1946; $j < 1968; $j++) { echo '
  • ' . $j . '' . "\n" ; } echo '
' . "\n" ; echo '' . "\n" ; break; case "RE": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . encodeToUtf8('Record') . '" ORDER BY `rep_events`.`Date_in` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Records
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . date8($donnees['Date_in']) . '' . utf8($donnees['Event']) . '
' . "\n" ; echo '' . "\n" ; break; case "REM": if (isset($_GET['rem'])) { ?> 0 and `rep_mutations`.`Date_out` <> 0 and `rep_mutations`.`Date_in` <> `rep_mutations`.`Date_Out`;"; $requete= "SELECT MAX(`rep_mutations`.`Date_out`) as maximum FROM `rep_mutations` WHERE `rep_mutations`.`Depot`='" . $choix . "' and `rep_mutations`.`Date_in` <> 0 and `rep_mutations`.`Date_out` <> 0 and `rep_mutations`.`Date_in` <> 19440920;"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $donnees = mysqli_fetch_array($reponse); $maximum = intval($donnees['maximum']/10000); // echo $maximum . "\n"; // $requete= "SELECT MIN(`rep_mutations`.`Date_in`) as minimum FROM `rep_mutations` WHERE `rep_mutations`.`Depot`='" . $choix . "' and `rep_mutations`.`Date_in` <> 0 and `rep_mutations`.`Date_out` <> 0 and `rep_mutations`.`Date_in` <> `rep_mutations`.`Date_Out`;"; $requete= "SELECT MIN(`rep_mutations`.`Date_in`) as minimum FROM `rep_mutations` WHERE `rep_mutations`.`Depot`='" . $choix . "' and `rep_mutations`.`Date_in` <> 0 and `rep_mutations`.`Date_out` <> 0;"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $donnees = mysqli_fetch_array($reponse); $minimum = intval($donnees['minimum']/10000); // echo $minimum . "\n"; echo ''; echo ''; echo ''; for ($i = $minimum; $i < $maximum+1; $i++) { echo ''; } echo '' . "\n"; $remise=array(); $relation=array(); // $requete= "SELECT * FROM `rep_mutations` WHERE `rep_mutations`.`Depot`='" . $choix . "' and `rep_mutations`.`Date_in` <> 0 and `rep_mutations`.`Date_Out` <> 0 and `rep_mutations`.`Date_in` <> `rep_mutations`.`Date_Out` order by `rep_mutations`.`Date_in` ASC;"; $requete= "SELECT * FROM `rep_mutations` WHERE `rep_mutations`.`Depot`='" . $choix . "' and `rep_mutations`.`Date_in` <> 0 and `rep_mutations`.`Date_Out` <> 0 and `rep_mutations`.`Date_in` <> 19440920 order by `rep_mutations`.`Date_in` ASC;"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= "SELECT * FROM rep_machines WHERE (`rep_machines`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_machines`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_machines`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') ;" ; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); $machimini = intval($donnees1['Date_In']/10000); $requete4= "SELECT MAX(`rep_relations`.`N_Date`) as maximum FROM `rep_relations` WHERE (`rep_relations`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_relations`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_relations`.`K_Identifier` = '" . $donnees['K_Identifier'] . "');"; $reponse4=mysqli_query($conn, $requete4); test_requete($reponse4,$conn); $donnees4 = mysqli_fetch_array($reponse4); $machimaxi = max(intval($donnees1['Date_Out']/10000),intval($donnees1['Write-off']/10000),intval($donnees4['maximum']/10000),$maximum); $machine = utf8($donnees['K_Company']) . '@' . utf8($donnees['K_Number']) . '@' . utf8($donnees['K_Identifier']); if (! (array_key_exists($machine,$relation))) { $relation[$machine][0] = $machine; for ($i = $machimini; $i < $machimaxi+1; $i++) { $relation[$machine][$i] = ''; } $requete2= "SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_relations`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_relations`.`K_Identifier` = '" . $donnees['K_Identifier'] . "') and `rep_relations`.`N_Company` <> 'MaschineAmbt' and `rep_relations`.`N_Company` <> 'SNCF' and `rep_relations`.`N_Company` <> 'Alpha Trains Belgium' order by `rep_relations`.`N_Date` ASC;" ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); while ($donnees2 = mysqli_fetch_array($reponse2) ) { $datenumerot = intval($donnees2['N_Date']/10000); $relation[$machine][$datenumerot] = utf8($donnees2['N_Number']) . '@' . utf8($donnees2['N_Identifier']); } } if (! (array_key_exists($machine,$remise))) { $remise[$machine][0] = $machine; for ($i = $minimum; $i < $maximum+1; $i++) { $remise[$machine][$i] = ''; } } $mini = intval($donnees['Date_in']/10000); $maxi = intval($donnees['Date_Out']/10000); for ($i = $mini; $i < $maxi+1; $i++) { $remise[$machine][$i] = ' 
X
 '; } $minijour = substr($donnees['Date_in'],6,2) .'/' . substr($donnees['Date_in'],4,2); $maxijour = substr($donnees['Date_Out'],6,2) .'/' . substr($donnees['Date_Out'],4,2); $remise[$machine][$mini] = ' ' . $minijour . $remise[$machine][$mini]; $remise[$machine][$maxi] = $remise[$machine][$maxi] . $maxijour . ' '; } ksort($relation); foreach ($relation as &$rel) { ksort($rel); } foreach ($relation as $kekerel => &$rel) { foreach ($rel as $krel1 => $rel1) { if ($rel1 == '' and $krel1 <> 0) { $k = $krel1 - 1; $relation[$kekerel][$krel1]=$relation[$kekerel][$k]; } } } foreach ($remise as $keke => &$v1) { $premier = 0; $lastone =''; for ($i = $minimum; $i < $maximum+1; $i++) { if ($v1[$i] != '') { if ($premier == 0) { $premier = $i; $v1[0] = $relation[$keke][$i]; $lastone = $v1[0]; } else { if ($lastone != $relation[$keke][$i]) { $lastone = $relation[$keke][$i]; $recherche=explode("@", $lastone); $enfin = $recherche[0]; switch($recherche[1]) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": $enfin = $enfin . "(" . $recherche[1] . ")"; break; } $v1[$i] = '' . $enfin . '
' . $v1[$i]; } } } } } $compteligne = 0; foreach ($remise as $kr1 => $vr1) { if ($compteligne > 10) { echo ''; for ($i = $minimum; $i < $maximum+1; $i++) { echo ''; } echo '' . "\n"; $compteligne = 0; } $compteligne = $compteligne + 1; echo ''; foreach ($vr1 as $kr2 => $vr2) { if ($kr2 == 0) { $recherche=explode("@", $vr2); echo '' ; // echo ''; } else { echo ''; } } echo '' . "\n"; } echo '
' . utf8($choix) . '
' . $i . '
' . $i . '
' . $recherche[0]; switch($recherche[1]) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $recherche[1] . ")"; break; } echo '' . $vr2 . ' - ' . $kr1 . '' . $vr2 . '
'; // echo '
';
//					print_r($remise);
//					echo '
'; // echo '
';
//					print_r($relation);
//					echo '
'; echo '' . "\n" ; } ?> '; echo 'Tableaux par remise' . "\n" ; echo '' . "\n" ; } break; case "REMI": $requete= 'SELECT * FROM rep_remise ORDER BY `rep_remise`.`Remise` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo ''; } echo '
Remises
' . utf8($donnees['Remise']) . '' . utf8($donnees['Code']) . '' . date8($donnees['Ouverture']) . '' . date8($donnees['Fermeture']) . '' . utf8($donnees['Comment']) . '
' . "\n" ; echo '' . "\n" ; break; case "RP": $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none('Registre des épreuves') . '" ORDER BY `rep_events`.`Type_NL` ASC, `rep_events`.`Event` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); // echo $nblignes; echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Registre des épreuves
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); // echo '
' . utf8($donnees['Event']) . ' (' . date8($donnees['Date_in']) . ' - ' . date8($donnees['Date_Out']) . ')' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . utf8($donnees['Type_NL']) . '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '
' . "\n" ; echo '' . "\n" ; break; case "RT": $requete= "SELECT `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, `rep_relations`.`N_Number`, `rep_mutations`.`Date_Out`, `rep_mutations`.`Comment`, `rep_relations`.`N_Type`, `rep_relations`.`N_Identifier` FROM (`rep_machines` INNER JOIN `rep_mutations` ON (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`)) INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) WHERE (((`rep_mutations`.`Comment`) LIKE 'Retraite de septembre 1944%') and ((`rep_relations`.`N_Type`) <> 'Type 37' and (`rep_relations`.`N_Type`) <> 'Type 37' and (`rep_relations`.`N_Type`) <> 'Type 32' and (`rep_relations`.`N_Type`) <> 'Type 31 ancien') and ((`rep_relations`.`N_Date`) =19311001 or (`rep_relations`.`N_Date`) = 19380610 or (`rep_relations`.`N_Date`) = 19380616 or (`rep_relations`.`N_Date`) = 19260901 or (`rep_relations`.`N_Date`) = 19410205 or (`rep_relations`.`N_Date`) = 19410500) AND ((`rep_mutations`.`Depot`) = 'Allemagne')) ORDER BY `rep_relations`.`N_Number` ASC, `rep_relations`.`N_Type` ASC , `rep_relations`.`N_Date` DESC;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $immatdiff = array(); $type=""; while ($donnees = mysqli_fetch_array($reponse) ) { $keydiff = utf8($donnees['K_Company']) .'@' . utf8($donnees['K_Number']) .'@' . utf8($donnees['K_Identifier']); if (! (array_key_exists($keydiff,$immatdiff))) { $immatdiff[$keydiff] = $keydiff ; if (utf8($donnees['N_Type']) <> $type) { echo '' . "\n" ; $type = utf8($donnees['N_Type']); } echo '' . "\n" ; } } echo '
Locomotives emmenées lors de la retraite de septembre 1944
' . utf8($donnees['N_Type']) . '
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo ''; if ($donnees['Date_Out'] == 0) { echo 'Perdue'; } else { echo (date8($donnees['Date_Out'])); } echo '
' . "\n" ; echo '' . "\n" ; break; case "SC": $requete= 'SELECT `rep_machines`.`K_Identifier`, `rep_machines`.`K_Number`, `rep_machines`.`K_Company`, `rep_machines`.`Constructeur`, `rep_machines`.`Fab_Number`, `rep_events`.`Event`, `rep_events`.`Date_in`, `rep_events`.`Date_Out`, `rep_events`.`Type_NL`, `rep_events`.`Type_FR` FROM `rep_machines` INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE `rep_events`.`Type_FR` = "' . utf8_PC_none("Schöma") . '" ORDER BY `rep_events`.`Event`+0 ASC;' ; // $requete= 'SELECT * FROM rep_events WHERE `rep_events`.`Type_FR` = "Exposition" ORDER BY `rep_events`.`Date_in` ASC, `rep_events`.`Event` ASC, `rep_events`.`K_Number` ASC;' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { if ($donnees['Fab_Number'] == "0") { $Fab_Number=""; // echo '' . "\n" ; } echo '
Schöma ['. $nblignes . ']
'; } elseif (is_numeric($donnees['Fab_Number'])) { $Fab_Number=number_format($donnees['Fab_Number'], 0, ",", "."); } else { $Fab_Number=$donnees['Fab_Number']; } echo '
Schöma N° ' . utf8($donnees['Event']) . '' . utf8($donnees['Constructeur']) . ' N° ' . $Fab_Number . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
'; echo '' . "\n" ; break; case "SN": $requete= 'SELECT * FROM (SELECT `rep_machines`.`Surname`, `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, "Surnom" AS `Event` FROM rep_machines UNION select `rep_events`.`Event`, `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Type_FR` FROM rep_events) AS `Test` WHERE (`Test`.`Event` = "Surnom" AND `Test`.`Surname` <> "" AND `Test`.`Surname` NOT LIKE "%nomination%") ORDER BY `Test`.`Surname` ASC' ; // $requete= 'SELECT `rep_machines`.`Surname`, `rep_machines`.`K_Company`, `rep_machines`.`K_Number`, `rep_machines`.`K_Identifier`, "Machine" AS `Event` FROM rep_machines UNION select `rep_events`.`Event`, `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Type_FR` from rep_events ORDER BY `Surname` DESC' ; // $requete= 'SELECT * FROM rep_machines WHERE (`rep_machines`.`Surname` <> "") ORDER BY `rep_machines`.`Surname` ASC' ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Surnoms ['. $nblignes . ']
' . utf8($donnees['Surname']) . '' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '
'; echo '' . "\n" ; break; case "TC": if (isset($_GET['const'])) { $get_const=validate_data($_GET['const']); $requete1= "SELECT * FROM `rep_type_constructeur` WHERE `rep_type_constructeur`.`Constructeur` = '" . $get_const . "';" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $donnees1 = mysqli_fetch_array($reponse1); $requete= "SELECT * FROM rep_machines WHERE (`rep_machines`.`Constructeur` = '" . $donnees1['Constructeur'] . "' AND `rep_machines`.`Type` LIKE '" . $donnees1['Type'] . "%') ORDER BY " . $donnees1['Tri'] . ", `rep_machines`.`Fab_Number` ASC; " ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; while ($donnees = mysqli_fetch_array($reponse) ) { // $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB" OR `rep_relations`.`N_Company` ="ETAT BELGE" OR `rep_relations`.`N_Company` ="SNCV" OR `rep_relations`.`N_Company` ="Sjaellandske Jernbane Selskab" OR `rep_relations`.`N_Company` ="USA/TC" OR `rep_relations`.`N_Company` ="Bruxelles-Tervueren" OR `rep_relations`.`N_Company` ="CFL" OR `rep_relations`.`N_Company` ="CFV3V" OR `rep_relations`.`N_Company` ="LINEAS") AND `rep_relations`.`N_Type` <> "Type A621" AND `rep_relations`.`N_Type` NOT LIKE "ES%" ORDER BY `rep_relations`.`N_Date` DESC;' ; $requete2= 'SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = "' . $donnees['K_Company'] . '" AND `rep_relations`.`K_Number` = "' . $donnees['K_Number'] . '" AND `rep_relations`.`K_Identifier` = "' . $donnees['K_Identifier'] . '") AND (`rep_relations`.`N_Company` ="SNCB" OR `rep_relations`.`N_Company` ="ETAT BELGE" OR `rep_relations`.`N_Company` ="SNCV" OR `rep_relations`.`N_Company` ="Sjaellandske Jernbane Selskab" OR `rep_relations`.`N_Company` ="USA/TC" OR `rep_relations`.`N_Company` ="Bruxelles-Tervueren" OR `rep_relations`.`N_Company` ="CFL" OR `rep_relations`.`N_Company` ="CFV3V" OR `rep_relations`.`N_Company` ="LINEAS") AND `rep_relations`.`N_Type` <> "Type A621" ORDER BY `rep_relations`.`N_Date` DESC;' ; $reponse2=mysqli_query($conn, $requete2); test_requete($reponse2,$conn); $donnees2 = mysqli_fetch_array($reponse2); echo '' . "\n" ; } echo '
' . $get_const . ' par Type Constructeur
' . utf8($donnees['K_Company']) . ' - ' . utf8($donnees['K_Number']); switch($donnees['K_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['K_Identifier'] . ")"; break; } echo '' . $donnees['Type'] . '' . $donnees['Axes'] . ''; if ($donnees['Voie'] != 0) { echo number_format($donnees['Voie']/1000, 3, ",", "."); } echo '
' . "\n" ; } else { $requete1= "SELECT * FROM `rep_type_constructeur` ORDER BY `rep_type_constructeur`.`Constructeur` ;" ; // echo $requete1; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $nblignes1 = mysqli_num_rows($reponse1); echo ''; echo '
Listes Constructeurs par Type Constructeur
' . "\n" ; echo '' . "\n" ; } break; case "TRA": $requete= "SELECT `rep_events`.`K_Company`, `rep_events`.`K_Number`, `rep_events`.`K_Identifier`, `rep_events`.`Event`, `rep_relations`.`N_Number`, `rep_relations`.`N_Identifier`, `rep_events`.`Date_in` FROM (`rep_machines` INNER JOIN `rep_relations` ON (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`)) INNER JOIN `rep_events` ON (`rep_machines`.`K_Identifier` = `rep_events`.`K_Identifier`) AND (`rep_machines`.`K_Number` = `rep_events`.`K_Number`) AND (`rep_machines`.`K_Company` = `rep_events`.`K_Company`) WHERE (((`rep_events`.`Type_FR`) = 'Surnom') and ((`rep_relations`.`N_Company`) = 'SNCB') and ((`rep_relations`.`K_Type`) = 'TRAXX F140 MS')) ORDER BY `rep_relations`.`N_Number` ASC;" ; // echo $requete; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $nblignes = mysqli_num_rows($reponse); echo ''; echo ''; $type=""; while ($donnees = mysqli_fetch_array($reponse) ) { echo '' . "\n" ; } echo '
Surnoms des TRAXX
' . utf8($donnees['N_Number']); switch($donnees['N_Identifier']) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $donnees['N_Identifier'] . ")"; break; } echo '' . utf8($donnees['Event']) . '' . date8($donnees['Date_in']) . '
' . "\n" ; echo '' . "\n" ; break; case "TY": if (isset($_GET['ty'])) { ?> 0) AND ((`rep_mutations`.`Date_Out`) <> 0) AND ((`rep_mutations`.`Date_in`) <> `rep_mutations`.`Date_Out`));"; $requete= "SELECT MAX(`rep_mutations`.`Date_Out`) AS maximum FROM `rep_telegraphe` INNER JOIN (`rep_mutations` INNER JOIN `rep_relations` ON (`rep_mutations`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_mutations`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_mutations`.`K_Identifier` = `rep_relations`.`K_Identifier`)) ON `rep_telegraphe`.`Remise` = `rep_mutations`.`Depot` WHERE (((`rep_relations`.`N_Company`)='" . $recherche[0] . "') AND ((`rep_relations`.`N_Type`) = '" . utf8_inverse($recherche[1]) . "') AND ((`rep_mutations`.`Date_in`) <> 0) AND ((`rep_mutations`.`Date_Out`) <> 0) );"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $donnees = mysqli_fetch_array($reponse); // $requete9= "SELECT MAX(`rep_machines`.`Date_Out`) as maximum9 FROM `rep_machines` WHERE `rep_machines`.`K_Company`='" . $recherche[0] . "' and `rep_machines`.`K_Type` ='" . utf8_inverse($recherche[1]) . "';"; // $requete9= "SELECT MAX(`rep_machines`.`Date_Out`) AS maximum9 FROM `rep_machines` INNER JOIN `rep_relations` ON (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) WHERE (((`rep_relations`.`N_Company`)='" . $recherche[0] . "') AND ((`rep_relations`.`N_Type`) = '" . utf8_inverse($recherche[1]) . "'));"; // $reponse9=mysqli_query($conn, $requete9); // test_requete($reponse9,$conn); // $donnees9 = mysqli_fetch_array($reponse9); // $maximum = max(intval($donnees['maximum']/10000), intval($donnees9['maximum9']/10000)); $maximum = intval($donnees['maximum']/10000); // echo $maximum . "\n"; // $requete= "SELECT MIN(`rep_machines`.`Date_in`) as minimum FROM `rep_machines` WHERE `rep_machines`.`K_Company`='" . $recherche[0] . "' and `rep_machines`.`K_Type` ='" . utf8_inverse($recherche[1]) . "' and `rep_machines`.`K_Number` NOT LIKE '[%';"; // $requete= "SELECT MIN(`rep_mutations`.`Date_in`) as minimum FROM `rep_machines` INNER JOIN (`rep_mutations` INNER JOIN `rep_telegraphe` ON `rep_mutations`.`Depot` = `rep_telegraphe`.`Remise`) ON (`rep_machines`.`K_Company` = `rep_mutations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_mutations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_mutations`.`K_Identifier`) WHERE (((`rep_machines`.`K_Company`)='" . $recherche[0] . "') AND ((`rep_machines`.`K_Type`)='" . utf8_inverse($recherche[1]) . "') AND ((`rep_mutations`.`Date_in`)<>0) AND ((`rep_mutations`.`Date_Out`)<>0) AND ((`rep_mutations`.`Date_in`)<>`rep_mutations`.`Date_Out`) AND ((`rep_machines`.`K_Number`) NOT LIKE '[%'));"; // $requete= "SELECT MIN(`rep_mutations`.`Date_in`) AS minimum FROM `rep_telegraphe` INNER JOIN (`rep_mutations` INNER JOIN `rep_relations` ON (`rep_mutations`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_mutations`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_mutations`.`K_Identifier` = `rep_relations`.`K_Identifier`)) ON `rep_telegraphe`.`Remise` = `rep_mutations`.`Depot` WHERE (((`rep_relations`.`N_Company`)='" . $recherche[0] . "') AND ((`rep_relations`.`N_Type`) = '" . utf8_inverse($recherche[1]) . "') AND ((`rep_mutations`.`Date_in`) <> 0) AND ((`rep_mutations`.`Date_Out`) <> 0) AND ((`rep_mutations`.`Date_in`) <> `rep_mutations`.`Date_Out`));"; $requete= "SELECT MIN(`rep_mutations`.`Date_in`) AS minimum FROM `rep_telegraphe` INNER JOIN (`rep_mutations` INNER JOIN `rep_relations` ON (`rep_mutations`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_mutations`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_mutations`.`K_Identifier` = `rep_relations`.`K_Identifier`)) ON `rep_telegraphe`.`Remise` = `rep_mutations`.`Depot` WHERE (((`rep_relations`.`N_Company`)='" . $recherche[0] . "') AND ((`rep_relations`.`N_Type`) = '" . utf8_inverse($recherche[1]) . "') AND ((`rep_mutations`.`Date_in`) <> 0) AND ((`rep_mutations`.`Date_Out`) <> 0) AND ((`rep_mutations`.`Date_in`) <> 19440920));"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); $donnees = mysqli_fetch_array($reponse); $minimum = intval($donnees['minimum']/10000); // echo $minimum . "\n"; echo ''; echo ''; echo ''; for ($i = $minimum; $i < $maximum+1; $i++) { echo ''; } echo '' . "\n"; $type=array(); $relation=array(); // $requete= "SELECT * FROM `rep_machines` WHERE `rep_machines`.`K_Company`='" . $recherche[0] . "' and `rep_machines`.`K_Type`='" . utf8_inverse($recherche[1]) . "' and `rep_machines`.`K_Number` NOT LIKE '[%' order by `rep_machines`.`K_Number` ASC;"; $requete= "SELECT `rep_machines`.* FROM `rep_machines` INNER JOIN `rep_relations` ON (`rep_machines`.`K_Company` = `rep_relations`.`K_Company`) AND (`rep_machines`.`K_Number` = `rep_relations`.`K_Number`) AND (`rep_machines`.`K_Identifier` = `rep_relations`.`K_Identifier`) WHERE (((`rep_relations`.`N_Company`)='" . $recherche[0]. "') AND ((`rep_relations`.`N_Type`) = '". utf8_inverse($recherche[1]). "')) ORDER BY `rep_machines`.`K_Number` ASC;"; $reponse=mysqli_query($conn, $requete); test_requete($reponse,$conn); while ($donnees = mysqli_fetch_array($reponse) ) { $requete1= "SELECT * FROM rep_relations WHERE (`rep_relations`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_relations`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_relations`.`K_Identifier` = '" . $donnees['K_Identifier'] . "' and `rep_relations`.`N_Company` <> 'MaschineAmbt') order by `rep_relations`.`N_Date` ASC ;" ; $reponse1=mysqli_query($conn, $requete1); test_requete($reponse1,$conn); $machine = utf8($donnees['K_Company']) . '@' . utf8($donnees['K_Number']) . '@' . utf8($donnees['K_Identifier']); while ($donnees1 = mysqli_fetch_array($reponse1) ) { if (! (array_key_exists($machine,$relation))) { $relation[$machine][0] = $machine; for ($i = intval($donnees['Date_In']/10000); $i < $maximum+1; $i++) { $relation[$machine][$i] = ''; } } $datenumerot = intval($donnees1['N_Date']/10000); $relation[$machine][$datenumerot] = utf8($donnees1['N_Number']) . '@' . utf8($donnees1['N_Identifier']); } // $requete4= "SELECT * FROM rep_mutations WHERE (`rep_mutations`.`K_Company` = '" . $donnees['K_Company'] . "' and `rep_mutations`.`K_Number` = '" . $donnees['K_Number'] . "' and `rep_mutations`.`K_Identifier` = '" . $donnees['K_Identifier'] . "' and `rep_mutations`.`Date_in` <> 0 and `rep_mutations`.`Date_out` <> 0 and `rep_mutations`.`Date_in` <> `rep_mutations`.`Date_Out`) order by `rep_mutations`.`Date_in`;" ; // $requete4= "SELECT * FROM `rep_mutations` INNER JOIN `rep_telegraphe` ON `rep_mutations`.`Depot` = `rep_telegraphe`.`Remise` WHERE (((`rep_mutations`.`K_Company`)='" . $donnees['K_Company'] . "') AND ((`rep_mutations`.`K_Number`)='" . $donnees['K_Number'] . "') AND ((`rep_mutations`.`K_Identifier`)='" . $donnees['K_Identifier'] . "') AND ((`rep_mutations`.`Date_in`)<>0) AND ((`rep_mutations`.`Date_Out`)<>0) AND ((`rep_mutations`.`Date_in`)<>`rep_mutations`.`Date_Out`)) ORDER BY `rep_mutations`.`Ordre` ASC, `rep_mutations`.`Date_in` ASC;" ; $requete4= "SELECT * FROM `rep_mutations` INNER JOIN `rep_telegraphe` ON `rep_mutations`.`Depot` = `rep_telegraphe`.`Remise` WHERE (((`rep_mutations`.`K_Company`)='" . $donnees['K_Company'] . "') AND ((`rep_mutations`.`K_Number`)='" . $donnees['K_Number'] . "') AND ((`rep_mutations`.`K_Identifier`)='" . $donnees['K_Identifier'] . "') AND ((`rep_mutations`.`Date_in`)<>0) AND ((`rep_mutations`.`Date_Out`)<>0) AND ((`rep_mutations`.`Date_in`)<> 19440920)) ORDER BY `rep_mutations`.`Ordre` ASC, `rep_mutations`.`Date_in` ASC;" ; $reponse4=mysqli_query($conn, $requete4); test_requete($reponse4,$conn); while ($donnees4 = mysqli_fetch_array($reponse4) ) { if (! (array_key_exists($machine,$type))) { $type[$machine][0] = $machine; for ($i = $minimum; $i < $maximum+1; $i++) { $type[$machine][$i] = ''; } } $mini = intval($donnees4['Date_in']/10000); $maxi = intval($donnees4['Date_Out']/10000); for ($i = $mini; $i < $maxi+1; $i++) { $type[$machine][$i] = ' 
X
 '; } $minijour = substr($donnees4['Date_in'],6,2) .'/' . substr($donnees4['Date_in'],4,2); // $maxijour = substr($donnees4['Date_Out'],6,2) .'/' . substr($donnees4['Date_Out'],4,2); $requete5= "SELECT * FROM rep_telegraphe WHERE `rep_telegraphe`.`Remise` = '" . $donnees4['Depot'] . "' ;" ; $reponse5=mysqli_query($conn, $requete5); test_requete($reponse5,$conn); $donnees5 = mysqli_fetch_array($reponse5); $type[$machine][$mini] = ' ' . $minijour . $type[$machine][$mini] . '
' . $donnees5['Code'] . '
'; // $type[$machine][$maxi] = $type[$machine][$maxi] . $maxijour . ' '; } } ksort($relation); foreach ($relation as &$rel) { ksort($rel); } foreach ($relation as $kekerel => &$rel) { foreach ($rel as $krel1 => $rel1) { // if ($rel1 == '' and $krel1 <> 0 and $krel1 > $minimum) { if ($rel1 == '' and $krel1 <> 0 ) { $k = $krel1 - 1; $relation[$kekerel][$krel1]=$relation[$kekerel][$k]; } } } foreach ($type as $keke => &$v1) { $premier = 0; $lastone =''; for ($i = $minimum; $i < $maximum+1; $i++) { if ($v1[$i] != '') { if ($premier == 0) { $premier = $i; $v1[0] = $relation[$keke][$i]; $lastone = $v1[0]; } else { if ($lastone != $relation[$keke][$i]) { $lastone = $relation[$keke][$i]; $recherche=explode("@", $lastone); $enfin = $recherche[0]; switch($recherche[1]) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": $enfin = $enfin . "(" . $recherche[1] . ")"; break; } $v1[$i] = '' . $enfin . '
' . $v1[$i]; } } } } } $compteligne = 0; foreach ($type as $kr1 => $vr1) { if ($compteligne > 10) { echo ''; for ($i = $minimum; $i < $maximum+1; $i++) { echo ''; } echo '' . "\n"; $compteligne = 0; } $compteligne = $compteligne + 1; echo ''; foreach ($vr1 as $kr2 => $vr2) { if ($kr2 == 0) { $recherche=explode("@", $vr2); echo '' ; // echo ''; } else { echo ''; } } echo '' . "\n"; } echo '
' . utf8($donnees1['Type']) . '
' . $i . '
' . $i . '
' . $recherche[0]; switch($recherche[1]) { case "0": break; case "2": case "3": case "4": case "5": case "6": case "7": case "8": echo "(" . $recherche[1] . ")"; break; } echo '' . $vr2 . ' - ' . $kr1 . '' . $vr2 . '
'; // echo '
';
//					print_r($type);
//					echo '
'; // echo '
';
//					print_r($relation);
//					echo '
'; echo '' . "\n" ; } ?> '; echo 'Tableaux par type' . "\n" ; echo '' . "\n" ; } break; } } else { echo ''; echo '' . "\n" ; echo '
Sources
'; echo 'Base de données documentaire et historique - Train World - Erfgoeddatabank
'. "\n" ; echo 'Grenier Ferroviaire - Spoorse Zolder
'. "\n" ; echo 'Museums Victoria Collections
'. "\n" ; echo 'Galerie Fabrikschilder
'. "\n" ; echo 'dampflokomotivarchiv.de
'. "\n" ; echo 'Signalwald - Eisenbahnsammlung Sigi Liechti
'. "\n" ; echo 'The Locomotive Database
'. "\n" ; echo 'Patrimoine Ferroviaire Touristique
'. "\n" ; echo 'Patrimoine Industriel de Tubize
'. "\n" ; echo 'Leeds Engine Builders
'. "\n" ; echo 'F. Loisel, Annuaire spécial des Chemins de Fer Belges, t. 1 1835-1865, t. 2, 1866-1867, Bruxelles - Paris, 1867 et 1869
'. "\n" ; echo 'André Dagant, Cent vingt-cinq ans de construction de locomotives à vapeur en Belgique, Bulletin de l' . "'" . 'institut archéologique liégeois, t. LXXXVI, 1974, p. 22-246
'. "\n" ; echo 'André Dagant, La société de Saint-Léonard à Liège, Bulletin de l' . "'" . 'institut archéologique liégeois, t. XCII, 1980, p. 26-99
'. "\n" ; echo 'Lok-datenbank
'. "\n" ; echo 'Lokstatistik
'. "\n" ; echo 'Rail.LU
'. "\n" ; echo 'SMU Libraries
'. "\n" ; echo "Et l'aide inestimable de Philippe Pirnay (+)
". "\n" ; echo '
Remarques
'; echo "(Numéro) = renumérotation sur papier / administrative
" . "\n" ; echo "[Numéro] = numéro inconnu => numéro plausible afin d'identifier la machine de manière unique
" . "\n" ; echo "(Remise) = dates d'entrée et de sortie inconnues (=> dates plausibles)
" . "\n" ; echo "
"; echo ' = il existe des photos dans des livres ou des revues
' . "\n" ; echo ' = des photos se trouvent sur la fiche de la locomotive
' . "\n" ; echo ' = il y a des liens sur la fiche de la locomotive
' . "\n" ; echo ' = la locomotive a été reproduite en miniature
' . "\n" ; echo ' = renvoie vers la fiche de la locomotive réelle (depuis les index et Traintamarre)
' . "\n" ; echo '
' . "\n" ; } mysqli_close($conn); ?>

© 2019 - ". "\n" ; ?> dgrr (at) skynet (dot/punt/point) be
Created 21 Apr 2019
Last Updated ". "\n" ; ?> Firefox' . "\n" ; } ?>