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
|
<?php session_start();
include ("fonction/fonction.login.php");
reclamation_acces($_SESSION);
?>
<!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>
<title>Service réclamation</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Language" content="fr" />
<title>fiche réclamation</title>
<SCRIPT LANGUAGE="Javascript" SRC="javascript/action_menu.js"> </SCRIPT>
<SCRIPT LANGUAGE="Javascript" SRC="javascript/fonction.divers.js"> </SCRIPT>
<SCRIPT LANGUAGE="Javascript" SRC="javascript/fonction.reclamation.js"> </SCRIPT>
<link rel="stylesheet" type="text/css" href="css/site.css" media="screen" />
<link rel="stylesheet" type="text/css" href="css/print.css" media="print" />
</head>
<body>
<div id="conteneur">
<h1 id="header"><a href="etape1.html" title="Colored Design - Accueil"></a></h1>
<?php include ("fonction/fonction.menu.php");
menu_classique();
?>
<div id="contenu">
<h2>Un titre</h2>
<?php
If (isset($_POST['ajouter']))
{
include ("fonction/fonction.bdd.php");
connexion_mysql();
$id_user=$_SESSION['id_user'];
// On commence par récupérer les champs
////////////////////////////////////
include ("fonction/fonction.bdd.reclamation.php");
insert_reclamation();
////////////////////////////
if(empty($id_client) OR empty($id_motif_reclamation) OR empty($des_reclamation))
{
echo '<font color="red">Attention, <b>tout les champs doivent etre remplis</b> !</font>';
echo '<INPUT TYPE="BUTTON" VALUE=" Retour "onClick="history.back()">';
echo '<br>';
}
else
{
$date = date("Y-m-d");
$heure = date("H:i");
$requetefinal = "INSERT INTO reclamation (id_reclamation, date_reclamation, heure_reclamation, id_user, id_client, id_motif_reclamation, des_reclamation, cause_reclamation, date_fabrication, date_dluo, equipe, n_carton, quantite, n_bl, n_facture, code_produit, lot_reclamation) VALUE ('', '$date', '$heure', '$id_user', '$id_client', '$id_motif_reclamation', '$des_reclamation', '$cause_reclamation', '$date_fabrication', '$date_dluo', '$equipe', '$n_carton', '$quantite', '$n_bl', '$n_facture', '$code_produit', '$lot_reclamation');";
$query2=mysql_query($requetefinal) or die('Erreur SQL !'.$requetefinal.'<br>'.mysql_error());
echo 'Vos infos on été ajoutées.<br>';
$id_reclamation = mysql_insert_id();
echo 'Le code la réclamation est le:<span="important">'.$id_reclamation.'</span><br>';
include "exe_ai.php";
}
}
else
{
$id_user=$_SESSION['id_user'];
$id_client=$_POST["id_client"];
include ("fonction/fonction.bdd.php");
connexion_mysql();
$sql= "SELECT id_client, nom_client, code_client, adresse_client, tel_client, fax_client FROM client WHERE id_client='$id_client';";
$query = mysql_query($sql) or die('erreur!!');
echo '<form action="reclamation1.php" method="post" id="reclamation" ><table id="visu_reclamation">
<tr><td colspan="2" align=center bgcolor="#FF6600"> Information client</td></tr>';
while ($list = mysql_fetch_assoc($query)){
?>
<td align=center><input type="hidden" name="id_user" value="<?php echo $id_user; ?>"><input type="hidden" name="id_client" value="<?echo $list["id_client"];?>"><?echo $list["code_client"];?></td><td align=center><?echo $list["nom_client"];?></td>
<tr><td align=center>tél:<?echo $list["tel_client"];?></td><td align=center>fax:<?echo $list["fax_client"];?></td></tr>
<tr><td align=center>Adresse:<?echo $row["adresse_client"];?></td><td colspan="2" align=center>Contact:<?echo $row["contact_client"];?></td></tr>
<?php
}
$sqlmotif="SELECT id_motif_reclamation, nom_motif_reclamation FROM motif_reclamation ORDER BY nom_motif_reclamation;";
$query = mysql_query($sqlmotif) or die('erreur!!');
echo '<tr><td colspan="2"><SELECT name="id_motif_reclamation" id="id_motif_reclamation" onchange="motif()"><option value="-1"> Choix</option>';
while ($listmotif = mysql_fetch_assoc($query)){
echo '<option value="'.$listmotif["id_motif_reclamation"].'">'.$listmotif["nom_motif_reclamation"].'</option>';
}
echo '</select></td></tr>';
echo '</table>';
?>
<div id="information">
</div>
</table>
<input type="submit" name="ajouter" id="ajouter" value="Valider" />
</form>
<?php
mysql_close();
}
print_r($_POST);
?>
</div>
<p id="footer">Essai pour le service Qualité section reclamation cliente</p>
</div>
</body>
</html> |
