J'ai mis en place sur une page distinct une fonction que voici
fonction.mail.php
<?php
function mail_exe_ai()
{
$message = '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Action immediate</title>
<style>
body
{
margin: 10px 0 ;
padding: 0 ;
text-align: center ;
background:#FFFFF;
font: 0.8em "Trebuchet MS", helvetica, sans-serif ;
}
div#conteneur
{
width: 1000px ;
margin: 0 auto ;
text-align: left ;
border: 0px solid #0066CC;
background: #fff ;
}
h1#header
{
border: 0px solid #0066CC;
height: 100px ;
background: url(../img/header.jpg) no-repeat top ;
background-color: #41b7d4;
}
div#contenu
{
margin: 0px 0px 0 10px ;
float: left ;
display: block ;
width:770px;
border-left: 2px dashed #41b7d4;
border-bottom: 2px dashed #41b7d4;
}
div#contenu h2
{
margin: 0 10px 0 10px;
padding-left: 25px ;
line-height: 25px ;
font-size: 1.4em ;
color: #FF6600 ;
background: url(../img/bouton.jpg) no-repeat left bottom ;
border-bottom: 1px solid #41b7d4 ;
border-left: 1px solid #41b7d4 ;
}
</style>
</head>
<body>
<br>
<table id="visu">
<tr>
<td align=center> Réclamation du client:'.$row0["id_motif_reclamation"].'.</td><td bgcolor="#8000FF" align=center>'.$row0["nom_client"].'('.$row0["code_client"].')</td>
</tr>
<tr>
<td>Contact:'.$row0["contact_client"].'</td><td>Nom:'.$row0["nom_client"].'</td>
</tr>
<td>Téléphone:'.$row0["tel_client"].'</td><td>Fax:'.$row0["fax_client"].'</td>
</tr>
</table>
<br>
Probleme'.$row0["nom_motif_reclamation"].':
<table id="visu">
<td align=center colspan="2" bgcolor="#FF6600"> Réclamation du client:</td>
</tr>
<tr>
<td align="center" colspan="2">'.$row0["des_reclamation"].'</td></tr>
<tr><td align=center>Cause (si elle est connue):</td><td align="center">'.$row0["cause_reclamation"].'</td></tr>
<tr>
<td align=center> Code Produit:</td><td align=center>'.$row0["code_produit"].'
</td>
</tr>
<tr>
<td align=center> N° de lot:</td><td align=center>'.$row0["lot_reclamation"].'</td>
</td>
<tr>
<td align=center> date_fabrication:(Format JJ/MM/2008)</td><td align=center>
'.$row0["date_fabrication"].
'</td>
</tr>
<tr>
<td align=center> date_DLUO:(Format JJ/MM/2008)</td><td align=center>
'.$row0["date_dluo"].'</td>
</tr>
<tr>
<td align=center> equipe:</td><td align=center>'.$row0["equipe"].'</td>
</tr>
<tr>
<td align=center> N_carton:</td><td align=center'.$row0["N_carton"].'</td>
</tr>
<tr>
<td align=center> quantité:</td><td align=center>'.$row0["quantite"].'</td>
</tr>
<tr>
<td align="center" >N° Bl:</td><td align=center>'.$row0["n_bl"].'</td></tr>
<tr>
<td align="center" >N° facture:</td><td align=center>'.$row0["n_facture"].'</td></tr>
</table>
<a href="http://intranet/qualite/v0.3a/action_immediate.php?login='.$rosmail["login_user"].'&mdp='.$rosmail["mdp_user"].'&id_reclamation='.$row0["id_reclamation"].'">
Cliquer ICI </a>
</body>';
}
?>
Code : Tout sélectionner
<?php
include ("fonction/fonction.mail.php");
if($id_motif_reclamation == 3)
{
$resmail = mysql_query("SELECT login_user, mdp_user, email_user FROM user INNER JOIN user_groupe ON user_groupe.id_user_groupe=user.id_user_groupe WHERE user.id_user_groupe='1'; ");
while($rosmail = mysql_fetch_assoc($resmail))
{
echo 'login&mdptest';
$login_user= $rosmail["login_user"];
$mdp_user=$rosmail["mdp_user"];
$res = mysql_query("SELECT id_reclamation, heure_reclamation, reclamation.id_motif_reclamation, nom_motif_reclamation, nom_user, prenom_user, code_client, nom_client, adresse_client, ville_client, contact_client, tel_client, fax_client, des_reclamation, cause_reclamation, code_produit, n_carton, quantite, DATE_FORMAT(date_fabrication,'%d/%m/%Y') as date_fabrication, DATE_FORMAT(date_dluo,'%d%/%m/%Y') as date_dluo, equipe, n_bl, n_facture
FROM reclamation
INNER JOIN motif_reclamation ON motif_reclamation.id_motif_reclamation = reclamation.id_motif_reclamation
INNER JOIN user ON user.id_user = reclamation.id_user
INNER JOIN client ON client.id_client = reclamation.id_client
WHERE id_reclamation='$id_reclamation' ");
while($row0 = mysql_fetch_assoc($res)){
$login_user= $rosmail["login_user"];
$mdp_user=$rosmail["mdp_user"];
$id_motif_reclamation=$row0["id_motif_reclamation"];
$code_client= $row0["code_client"];
$nom_motif_reclamation= $row0["nom_motif_reclamation"];
mail_exe_ai();
echo $rosmail["login_user"];echo '<br>';
echo $rosmail["mdp_user"];echo '<br>';
}
//echo $message;
$headers ='From: "Service Réclamation"<µµµµµµµµµµ>'."\n";
$headers .='Reply-To: NNNNNNNNNNNN'."\n";
$headers .='Content-Type: text/html; charset="iso-8859-1"'."\n";
$headers .='Content-Transfer-Encoding: 8bit';
$Sujet = 'Réclamation '.$nom_motif_reclamation.' sur le client '.$code_client.'';
if(mail('NNNNNNNNNNNN', 'Sujet', $message, $headers))
{
echo 'Le message a été envoyé';
}
else
{
echo 'Le message n\'a pu être envoyé';
}
}
}
else
{
$resmail = mysql_query("SELECT login_user, mdp_user, email_user FROM user INNER JOIN user_groupe ON user_groupe.id_user_groupe=user.id_user_groupe WHERE user.id_user_groupe='2'; ");
while($rosmail = mysql_fetch_assoc($resmail))
{
$res = mysql_query("SELECT id_reclamation, heure_reclamation, reclamation.id_motif_reclamation, nom_motif_reclamation, nom_user, prenom_user, code_client, nom_client, adresse_client, ville_client, contact_client, tel_client, fax_client, des_reclamation, cause_reclamation, code_produit, n_carton, quantite, DATE_FORMAT(date_fabrication,'%d/%m/%Y') as date_fabrication, DATE_FORMAT(date_dluo,'%d%/%m/%Y') as date_dluo, equipe, n_bl, n_facture
FROM reclamation
INNER JOIN motif_reclamation ON motif_reclamation.id_motif_reclamation = reclamation.id_motif_reclamation
INNER JOIN user ON user.id_user = reclamation.id_user
INNER JOIN client ON client.id_client = reclamation.id_client
WHERE id_reclamation='$id_reclamation' ");
while($row0 = mysql_fetch_assoc($res)){
$id_motif_reclamation=$row0["id_motif_reclamation"];
$code_client= $row0["code_client"];
$nom_motif_reclamation= $row0["nom_motif_reclamation"];
mail_exe_ai();
}
$headers ='From: "Service Réclamation"<[email protected]>'."\n";
$headers .='Reply-To: XXXXXXXXXX'."\n";
$headers .='Content-Type: text/html; charset="iso-8859-1"'."\n";
$headers .='Content-Transfer-Encoding: 8bit';
$Sujet = 'Réclamation '.$nom_motif_reclamation.' sur le client '.$code_client.'';
$email=XXXXXXXXXXXXXXXXXX';
$Sujet = 'Réclamation '.$nom_motif_reclamation.' sur le client '.$code_client.'';
if(mail($email, $Sujet, $message, $headers))
{
echo 'Le message a été envoyé';
}
else
{
echo 'Le message n\'a pu être envoyé';
}
}
mysql_close();
}
?>
Merci D'avance
guigui69
)