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
| <div id="gros_titre_service_admin">
<h3><span>Administration.</span></h3>
</div>
<div id=titre_service>Synonymes mot_clefs sans reponses</div>
<div id=sous_titre_service>- Periode du <?php
print($_REQUEST['jour1']."/".$_REQUEST['mois1']."/".$_REQUEST['annee1']); ?> au <?php print($_REQUEST['jour2']."/".$_REQUEST['mois2']."/".$_REQUEST['annee2']); ?></div>
<?php
$date1=$_REQUEST['annee1'].$_REQUEST['mois1'].$_REQUEST['jour1'];
$date2=$_REQUEST['annee2'].$_REQUEST['mois2'].$_REQUEST['jour2'];
?>
<?php
include ("../fonctions.php");?>
<div id=texte_service>
<p class="p2"> Ci dessous vous pouvez consulter les mot_clefs ayant ete recus et n'ayant pas généré de reponse dans dem_env_ms.</p>
<?php
$sql="select ref_msg,date_recep,heure_recep,num_expediteur,num_dest,message from recep_msg where categorie_msg='' and message<>'' and (date_recep between '".$_REQUEST['annee1'].$_REQUEST['mois1'].$_REQUEST['jour1']."' and '".$_REQUEST['annee2'].$_REQUEST['mois2'].$_REQUEST['jour2']."') order by num_dest ";
$sql="select ref_msg,date_recep,heure_recep,num_expediteur,num_dest,message from recep_msg_sav where categorie_msg='' and message<>'' and (date_recep between '".$_REQUEST['annee1'].$_REQUEST['mois1'].$_REQUEST['jour1']."' and '".$_REQUEST['annee2'].$_REQUEST['mois2'].$_REQUEST['jour2']."') order by num_dest";
$menu_nav="";
$var=array('nom'=>"ref_msg","date_recep","heure_recep","num_expediteur","num_dest","message",'valeur'=>"ref_msg","date_recep","heure_recep","num_expediteur","num_dest","message");
$menu_nav=menu_page($sql,$resultat,$_GET['page'],20,$var);
if ($menu_nav!="")
{
?>
<table width='85%' border='0' align="center" cellpadding='0' cellspacing='0'>
<tr><td align="center"><? echo $menu_nav; ?></td></tr>
</table>
<?php
}
?>
<div id=stats>
<?php
print("<table><thead><tr><td>Ref msg</td><td>Date</td><td>Heure</td><td>Num exp</td><td>Num dest</td><td>Message</td></tr></thead><tr>");
$sql="select ref_msg,date_recep,heure_recep,num_expediteur,num_dest,message from recep_msg where categorie_msg=''and (date_recep between '".$_REQUEST['annee1'].$_REQUEST['mois1'].$_REQUEST['jour1']."' and '".$_REQUEST['annee2'].$_REQUEST['mois2'].$_REQUEST['jour2']."') order by num_dest LIMIT 30";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
print("<tr><td>".$data['ref_msg']."</td><td>".$data['date_recep']."</td><td>".$data['heure_recep']."</td><td>".$data['num_expediteur']."</td><td>".$data['num_dest']."</td><td>".substr($data['message'],0,20)."</td></tr>");
}
$sql="select ref_msg,date_recep,heure_recep,num_expediteur,num_dest,message from recep_msg_sav where categorie_msg='' and (date_recep between '".$_REQUEST['annee1'].$_REQUEST['mois1'].$_REQUEST['jour1']."' and '".$_REQUEST['annee2'].$_REQUEST['mois2'].$_REQUEST['jour2']."') order by num_dest LIMIT 30";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
print("<tr><td>".$data['ref_msg']."</td><td>".$data['date_recep']."</td><td>".$data['heure_recep']."</td><td>".$data['num_expediteur']."</td><td>".$data['num_dest']."</td><td>".substr($data['message'],0,20)."</td></tr>");
}
print("</table>"); |
Partager