1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158
| //récupération des variables
$dpt = $_POST['dpt'];
$ville = $_POST['ville'];
$delegation = $_POST['delegation'];
$etat = $_POST['etat'];
$nom_candidat = $_POST['nom_candidat'];
$dossier = $_POST['dossier'];
$tri_autorises = array('nom','dpt_souhait1','ville_souh1','remun_souhait','id_etat','dossier');
$order_by = in_array($_GET['order'],$tri_autorises) ? $_GET['order'] : 'nom';
// Sens du tri
$order_dir = isset($_GET['inverse']) ? 'DESC' : 'ASC';
IF ( isset($_POST['dpt']) && $dpt != "0")
{
$sql.= "SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) WHERE dpt_souhait1 = '".$dpt."' ";
}
else if ( isset($_POST['ville']) && ($ville != "*") )
{
$sql.= "SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) WHERE ville_souh1 = '".$ville."' ";
}
else if ( isset($_POST['delegation']) && ($delegation != "0") )
{
$sql.= "SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) WHERE id_delegation_ratache = '".$delegation."'";
}
else if ( isset($_POST['etat']) && ($etat != "*") )
{
$sql.= "SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) WHERE id_etat = '".$etat."'";
}
else if ( isset($_POST['nom_candidat']) && ($nom != "*") )
{
$sql.= "SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) WHERE nom= '".$nom_candidat."' ";
}
else if ( isset($_POST['dossier']) && ($dossier != "*") )
{
$sql.= "SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) WHERE dossier ='".$dossier."' ";
}
else
{
$sql.="SELECT nom, remun_souhait, d.denomination dpt, e.denomination etat, v.ville ville FROM candidats c
JOIN dpt d
ON (c.dpt_souhait1=d.id)
JOIN etat e
ON (c.id_etat=e.id)
JOIN ville v
ON (c.ville_souh1=v.ville) ORDER BY {$order_by} {$order_dir} ";
}
$result=mysql_query($sql)or die(mysql_error());
// Notre fonction qui affiche les liens
function sort_link($text, $order=false)
{
global $order_by, $order_dir;
if(!$order)
$order = $text;
$link = '<a href="?page=affiche&order=' . $order;
if($order_by==$order && $order_dir=='ASC')
$link .= '&inverse=true';
$link .= '"';
if($order_by==$order && $order_dir=='ASC')
$link .= ' class="order_asc"';
elseif($order_by==$order && $order_dir=='DESC')
$link .= ' class="order_desc"';
$link .= '>' . $text . '</a>';
return $link;
}
// Affichage
?>
<style type="text/css">
a.order_asc,
a.order_desc:hover {
padding-right:15px;
background:transparent url(s_asc.png) right no-repeat;
}
a.order_desc,
a.order_asc:hover {
padding-right:15px;
background:transparent url(s_desc.png) right no-repeat;
}
</style>
<table class="petit_tableau" style="width:600px" >
<tr>
<th><?php echo sort_link('Noms', 'nom') ?></th>
<th><?php echo sort_link('DPT', 'dpt_souhait1') ?></th>
<th><?php echo sort_link('Ville', 'ville_souh1') ?></th>
<th><?php echo sort_link('Remun', 'remun_souhait') ?></th>
<th><?php echo sort_link('Etat', 'id_etat') ?></th>
<!--<th><?php// echo sort_link('Dossier', 'dossier') ?></th>-->
<!--<th><?php //echo ('Lettre') ?></th>-->
<th><?php echo ('Modif') ?></th>
<th><?php echo ('Suppr') ?></th>
</tr>
<?php while( $row=mysql_fetch_assoc($result) ) : ?>
<tr>
<td><?php echo $row['nom'] ?></td>
<td><?php echo $row['dpt'] ?></td>
<td><?php echo $row['ville'] ?></td>
<td><?php echo $row['remun_souhait'] ?></td>
<td><?php echo $row['etat'] ?></td>
<!--<td><?php // echo $row['adressea'] ?></td> -->
<!--<td><?php //echo $row['portefeuille']?></td>-->
<!--<td><?php// echo $row['dossier'] ?></td> -->
<?php
#bouton pour la modification du candidat on appele la page de modification et on lui passe l'id
// echo '<td><a href="principale.php?page=lettre&nom='.$row['nom_candidat'].'"><img src="images/lettre4.jpg"height="30px" width="20px"background="transparent" /></a></td>';
#bouton pour la modification du candidat on appele la page de modification et on lui passe l'id
echo '<td><a href="principale.php?page=fiche&type_action=reload&nom='.$row['nom'].'"><img src="images/icon_edit.gif"height="30px" width="21px"background="transparent" /></a></td>';
#bouton pour la supression du candidat, on appele la page de modification en lui passant l'id
echo "<td><input type='button' value='Suppr.' onClick='if(confirm(\"Etes-vous sûr de vouloir supprimer ce candidat ?\")) submit();'/></form></td>";
//echo '<td><a href="principale.php?page=liste&type_action=del&nom='.$data['nom'].'"><img src="images/suppr.jpg"height="20px" width="20px"background="transparent" /></a></td>';
echo '</tr>';//fin ligne
?> |
Partager