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 159 160 161 162 163 164 165 166 167 168 169 170 171 172
|
<?php
include("config.inc.php");
$nom=$_POST["nom_pers"];
$prenom=$_POST["pre_pers"];
$nom_chd=$_POST["nom_chd"];
$pre_chd=$_POST["pre_chd"];
$date=$_POST["date"];
$date2=$_POST["date2"];
$theme=$_POST["theme"];
///-------------------------case arrivée cochée---------------------------------
if (isset($_POST["choix2"])) {
$choix2=$_POST["choix2"];
$contenu_arr=$_POST["contenu"];
$sqlarr="SELECT Date_Format( date_arr, '%d/%m/%Y' ) AS DateTemp, contenu_arr, nom_pers, pre_pers, nom_chd, pre_chd, des_the, arrivee.num_arr, arrivee.num_chd, arrivee.num_pers, arrivee.num_the
FROM arrivee, personnes_tiers, charges_dossiers, theme
WHERE arrivee.num_chd = charges_dossiers.num_chd
AND arrivee.num_pers = personnes_tiers.num_pers
AND arrivee.num_the=theme.num_the";
if ($theme != ""){
$sqlarr = $sqlarr.
" AND arrivee.num_the ='$theme'";
}
if ($nom != ""){
$sqlarr = $sqlarr.
" AND nom_pers LIKE '%$nom%'";
}
if ($prenom != ""){
$sqlarr = $sqlarr.
" AND pre_pers LIKE '%$prenom%'";
}
if ($nom_chd != ""){
$sqlarr = $sqlarr.
" AND nom_chd LIKE '%$nom_chd%'";
}
if ($pre_chd != ""){
$sqlarr = $sqlarr.
" AND pre_chd LIKE '%$pre_chd%'";
}
if ($contenu_arr !=""){
$sqlarr = $sqlarr.
" AND contenu_arr LIKE '%$contenu_arr%'";
}
if ($date!=""){
$sqlarr = $sqlarr.
" AND date_arr='$date'";
}
if ($date2!=""){
$sqlarr = $sqlarr.
" AND date_arr>='$date' AND date_arr<='$date2'";
}
$resarr=mysql_query($sqlarr);
echo "<table border=1>";
echo "<tr><th colspan=5>ARRIVEE</th></tr>";
echo" <th>Date</th>";
echo" <th>Chargés du dossier</th>";
echo" <th>Contenu</th>";
echo" <th>Destinataire</th>";
echo" <th>Thème</th>";
while ($lignearr = mysql_fetch_object($resarr) or die(mysql_error()))
{
echo "<tr>";
echo "<td>".$lignearr->DateTemp."</td>";
echo "<td>".$lignearr->nom_chd."";
echo "".$lignearr->pre_chd."</td>";
echo "<td>".$lignearr->contenu_arr."</td>";
echo "<td>".$lignearr->nom_pers."";
echo "".$lignearr->pre_pers."</td>";
echo "<td>".$lignearr->des_the."</td>";
echo "<td><a href=\"modif2_arr.php?num_arr=".$lignearr->num_arr."&num_chd=".$lignearr->num_chd."&num_pers=".$lignearr->num_pers."&num_the=".$lignearr->num_the."\">modifier</a></td>";
echo "</tr>";
}
echo "</table>";
}
//-------------------------case départ cochée---------------------------------
if (isset($_POST["choix1"])) {
$choix1=$_POST["choix1"];
$contenu_dep=$_POST["contenu"];
$sqldep="SELECT Date_Format( date_envoi, '%d/%m/%Y' ) AS DateTemp, contenu_dep, recommande, nom_pers, pre_pers, nom_chd, pre_chd, des_the, depart.num_dep, depart.num_chd, envoyer.num_pers, depart.num_the
FROM depart, envoyer, personnes_tiers, charges_dossiers, theme
WHERE depart.num_dep = envoyer.num_dep
AND envoyer.num_pers = personnes_tiers.num_pers
AND depart.num_chd = charges_dossiers.num_chd
AND depart.num_the=theme.num_the";
if ($theme != ""){
$sqldep = $sqldep.
" AND depart.num_the ='$theme'";}
if ($nom != ""){
$sqldep = $sqldep.
" AND nom_pers LIKE '%$nom%'";
}
if ($prenom != ""){
$sqldep = $sqldep.
" AND pre_pers LIKE '%$prenom%'";
}
if ($nom_chd != ""){
$sqldep = $sqldep.
" AND nom_chd LIKE '%$nom_chd%'";
}
if ($pre_chd != ""){
$sqldep = $sqldep.
" AND pre_chd LIKE '%$pre_chd%'";
}
if ($contenu_dep !=""){
$sqldep = $sqldep.
" AND contenu_dep LIKE '%$contenu_dep%'";
}
if ($date!=""){
$sqldep = $sqldep.
" AND date_envoi='$date'";
}
if ($date2!=""){
$sqldep = $sqldep.
" AND date_envoi>='$date' AND date_envoi<='$date2'";
}
//echo $sqldep ;
$resdep=mysql_query($sqldep);
echo "<table border=1>";
echo "<tr><th colspan=5>DEPART</th></tr>";
echo" <th>Date</th>";
echo" <th>Chargés du dossier</th>";
echo" <th>Contenu</th>";
echo" <th>Destinataire</th>";
echo" <th>Thème</th>";
while ($lignedep = mysql_fetch_object($resdep) or die(mysql_error()))
{
echo "<tr>";
echo "<td>".$lignedep->DateTemp."</td>";
echo "<td>".$lignedep->nom_chd."";
echo "".$lignedep->pre_chd."</td>";
echo "<td>".$lignedep->contenu_dep."</td>";
echo "<td>".$lignedep->nom_pers."";
echo "".$lignedep->pre_pers."</td>";
echo "<td>".$lignedep->des_the."</td>";
echo "<td><a href=\"modif2_dep.php?num_dep=".$lignedep->num_dep."&num_chd=".$lignedep->num_chd."&num_pers=".$lignedep->num_pers."&num_the=".$lignedep->num_the."\">modifier</a></td>";
echo "</tr>";
}
echo "</table>";
}
?> |
Partager