$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 : Saviem SC 10 U
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 |
|
401 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
402 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
403 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
404 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1983 |
|
|
405 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
406 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
407 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
408 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
409 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
410 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
411 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1983 |
|
|
412 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
413 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1987 |
|
|
414 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
415 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
416 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
417 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
418 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
419 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1984 |
|
|
420 |
|
Saviem |
SC 10 U |
1967 |
2 |
|
SEMITAN |
|
1967 |
1987 |
|
|
421 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
Gautier |
|
1983 |
? |
|
|
422 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1984 |
|
|
423 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1984 |
|
|
425 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
Gautier |
|
1983 |
? |
|
|
426 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1987 |
|
|
427 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1987 |
|
|
428 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1987 |
|
|
429 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1986 |
|
|
430 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1985 |
|
|
431 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1987 |
|
|
432 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1985 |
|
|
433 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1986 |
|
|
434 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1983 |
|
|
435 |
|
Saviem |
SC 10 U |
1973 |
2 |
|
SEMITAN |
|
1973 |
1985 |
|
|
436 |
|
Saviem |
SC 10 U |
1974 |
2 |
|
SEMITAN |
|
1974 |
1986 |
|
|
437 |
|
Saviem |
SC 10 U |
1974 |
2 |
|
SEMITAN |
|
1974 |
? |
|
|
438 |
|
Saviem |
SC 10 U |
1974 |
2 |
|
SEMITAN |
|
1974 |
1987 |
|
|
439 |
|
Saviem |
SC 10 U |
1974 |
2 |
|
SEMITAN |
|
1974 |
1987 |
|
|
440 |
|
Saviem |
SC 10 U |
1974 |
2 |
|
SEMITAN |
|
1974 |
? |
|
|
441 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
442 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
443 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
444 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
445 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
446 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1985 |
|
|
447 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
448 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
Vertonne |
1975 |
|
|
|
449 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
450 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
SEMITAN |
|
1975 |
1987 |
|
|
451 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
452 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
453 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
454 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
455 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
456 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
457 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
458 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
459 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
460 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
461 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
462 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
463 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1987 |
|
|
464 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
465 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
466 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
467 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
468 |
|
Saviem |
SC 10 U |
1976 |
2 |
|
SEMITAN |
|
1976 |
1988 |
|
|
469 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1987 |
|
|
470 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1987 |
|
|
471 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
472 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
473 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
474 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
475 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
476 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
477 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
478 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
479 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1987 |
|
|
480 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
481 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1987 |
|
|
482 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1987 |
|
|
483 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
484 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
485 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
486 |
|
Saviem |
SC 10 U |
1977 |
2 |
|
SEMITAN |
|
1977 |
1988 |
|
|
1776 |
424 |
Saviem |
SC 10 U |
1973 |
2 |
|
Brounais |
|
1984 |
? |
|
|
|
|
Saviem |
SC 10 U |
? |
2 |
|
CTA |
|
1987 |
? |
|
|
9001 |
|
Saviem |
SC 10 U |
1975 |
2 |
|
CTA |
|
1987 |
1994 |
|
|