$table = $_GET['table'];
$marque = $_POST['marque'];
$modele = $_GET['modele'];
$numero = $_POST['numero'];
$num_proprio = $_POST['num_proprio'];
$ancien_numero = $_POST['ancien_numero'];
$etat = $_POST['etat'];
$premiere_mes = $_POST['premiere_mes'];
$fin_service = $_POST['fin_service'];
$origine = $_POST['origine'];
$depot = $_POST['depot'];
$girouettes = $_POST['girouettes'];
$proprietaire = $_POST['proprietaire'];
$siv = $_POST['siv'];
$sae = $_POST['sae'];
$livree = $_POST['livree'];
$proprietaire = $_POST['proprietaire'];
$observations = $_POST['observations'];
$immatriculation_ancien = $_POST['immatriculation_ancien'];
$immatriculation_siv = $_POST['immatriculation_siv'];
/*
On liste les champs echercher
*/
$liste_des_champs_a_rechercher = array(
'id',
'marque',
'modele',
'numero',
'ancien_numero',
'etat',
'fin_service',
'origine',
'depot',
'girouettes',
'proprietaire',
'immatriculation_ancien',
'immatriculation_siv'
);
$requete = NULL;
/*
On fait une boucle sur les champs echercher, si un champ est existant on ajoute "AND" au dt car on peut rechercher plusieurs champs
*/
foreach($liste_des_champs_a_rechercher as $champ_a_rechercher) {
if(isset($_POST[$champ_a_rechercher]) AND !empty($_POST[$champ_a_rechercher])) {
$requete .= ' AND '.$champ_a_rechercher.' = "'.$_POST[$champ_a_rechercher].'"';
}
}
/*
On supprimer le premier "AND" pour ne pas faire planter la requ¥
*/
if(!empty($requete)) {
$requete = substr($requete, 5);
}
?>
OMNIBUS NANTES - Parc : Chausson APH2.522
include("$_SERVER[DOCUMENT_ROOT]/fichiers/requete.php");
?>
include("$_SERVER[DOCUMENT_ROOT]/fichiers/requete.php");
?>
___________________
___________________
Omnibus
Nantes, avec
le
soutien
technique
et
financier
___________________
Omnibus
Nantes,
adhérente
au CAPTC
include("$_SERVER[DOCUMENT_ROOT]/fichiers/requete.php");
?>
include("$_SERVER[DOCUMENT_ROOT]/fichiers/requete.php");
?>
include("$_SERVER[DOCUMENT_ROOT]/fichiers/requete.php");
?>
include("$_SERVER[DOCUMENT_ROOT]/fichiers/requete.php");
?>
|
Liste
du parc |
Etat |
N° |
Ex n° |
Constructeur |
Modèle |
1ère MES |
Portes |
Norme
|
Exploitant |
Dépôt théorique |
Achat |
Fin de service |
Equipements |
|
101 |
366 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
102 |
364 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
103 |
361 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
104 |
358 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
105 |
357 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
106 |
356 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
107 |
353 |
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1980 |
|
|
108 |
350 |
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1980 |
|
|
109 |
349 |
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1980 |
|
|
110 |
335 |
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1980 |
|
|
111 |
333 |
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1980 |
|
|
112 |
331 |
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1980 |
|
|
113 |
328 |
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1980 |
|
|
114 |
326 |
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1980 |
|
|
115 |
325 |
Chausson |
APH2.522 |
1960 |
3 |
|
SEMITAN |
Vertonne |
1961 |
|
|
|
263 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1976 |
|
|
264 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1976 |
|
|
265 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1976 |
|
|
266 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1976 |
|
|
267 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
268 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
269 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
270 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
271 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
272 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
273 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
274 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
275 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
276 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
277 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
278 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
279 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
280 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
281 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
282 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1976 |
|
|
283 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
284 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
285 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
286 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
287 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1987 |
|
|
288 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
289 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1978 |
|
|
290 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
291 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
292 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
293 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
294 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
295 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1977 |
|
|
296 |
|
Chausson |
APH2.522 |
1957 |
3 |
|
CNTC |
|
1957 |
1976 |
|
|
297 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1977 |
|
|
298 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1978 |
|
|
299 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1977 |
|
|
300 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1977 |
|
|
301 |
|
Chausson |
APH2.522 |
1958 |
2 |
|
SEMITAN |
Vertonne |
1991 |
|
|
|
302 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1977 |
|
|
303 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1977 |
|
|
304 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1978 |
|
|
305 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1978 |
|
|
306 |
|
Chausson |
APH2.522 |
1958 |
3 |
|
CNTC |
|
1958 |
1978 |
|
|
307 |
|
Chausson |
APH2.522 |
1959 |
3 |
|
CNTC |
|
1959 |
1977 |
|
|
308 |
|
Chausson |
APH2.522 |
1959 |
3 |
|
CNTC |
|
1959 |
1977 |
|
|
309 |
|
Chausson |
APH2.522 |
1959 |
3 |
|
CNTC |
|
1959 |
1979 |
|
|
310 |
|
Chausson |
APH2.522 |
1959 |
3 |
|
CNTC |
|
1959 |
1977 |
|
|
311 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1978 |
|
|
312 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1977 |
|
|
313 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1978 |
|
|
314 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1979 |
|
|
315 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1979 |
|
|
316 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1977 |
|
|
317 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1977 |
|
|
318 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1977 |
|
|
319 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1979 |
|
|
320 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1980 |
|
|
321 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1979 |
|
|
322 |
|
Chausson |
APH2.522 |
1960 |
3 |
|
CNTC |
|
1960 |
1978 |
|
|
323 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
324 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
327 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
329 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1979 |
|
|
330 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
332 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
334 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
336 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
337 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
338 |
|
Chausson |
APH2.522 |
1961 |
3 |
|
CNTC |
|
1961 |
1978 |
|
|
339 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1978 |
|
|
340 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
341 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
342 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
343 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1978 |
|
|
344 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
345 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
346 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
347 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
348 |
|
Chausson |
APH2.522 |
1962 |
3 |
|
CNTC |
|
1962 |
1979 |
|
|
351 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1977 |
|
|
352 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1978 |
|
|
354 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1979 |
|
|
355 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1979 |
|
|
359 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1979 |
|
|
360 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1979 |
|
|
362 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
SEMITAN |
Vertonne |
1963 |
|
|
|
363 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1979 |
|
|
365 |
|
Chausson |
APH2.522 |
1963 |
3 |
|
CNTC |
|
1963 |
1979 |
|
|