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
| <?php
//connexion SQL
require_once('mysql/connexion_sql.php');
//requête création devis
$c_ID_client = $_POST['c_ID_client'];
$c_Date = $_POST['c_Date'];
$c_Nom_Societe = $_POST['c_Nom_Societe'];
$c_Nom = $_POST['c_Nom'];
$c_Prenom = $_POST['c_Prenom'];
$c_Adresse = $_POST['c_Adresse'];
$c_CP = $_POST['c_CP'];
$c_Ville = $_POST['c_Ville'];
$c_Telephone_Fixe = $_POST['c_Telephone_Fixe'];
$c_Telephone_Mobile = $_POST['c_Telephone_Mobile'];
$c_E_Mail = $_POST['c_E_Mail'];
$p_ID_prestation = $_POST['p_ID_prestation'];
$p_Nom_Lieu = $_POST['p_Nom_Lieu'];
$p_Adresse = $_POST['p_Adresse'];
$p_CP = $_POST['p_CP'];
$p_Ville = $_POST['p_Ville'];
$p_Type_Prestation = $_POST['p_Type_Prestation'];
$p_Date = $_POST['p_Date'];
$p_H_Arrive = $_POST['p_H_Arrive'];
$p_H_Fin = $_POST['p_H_Fin'];
$p_Nombre_Personne = $_POST['p_Nombre_Personne'];
$p_Moyenne_Age = $_POST['p_Moyenne_Age'];
//Créer le devis ou afficher le devis - SQL
$reponse = mysql_query("SELECT * FROM t_devis WHERE (d_ID_prestation = '".$p_ID_prestation."')") or die (mysql_error());
if(mysql_num_rows($reponse) == 0)
{
?>
<SCRIPT LANGUAGE="JavaScript">
if(!confirm('Aucun devis n\'a été généré pour ce client. Voulez vous générer le devis ?'))
{
location.href = "client.php";
}
</SCRIPT>
<?php
echo "créer un formulaire";
//date
$c_Date1 = date("m");
$c_Date2 = date("Y");
$c_Date = $c_Date2.$c_Date1."DEV";
//SQL
$query = "INSERT INTO t_devis VALUES ('','$c_Date','$p_ID_prestation')";
mysql_query($query);
}
else
{
echo "$c_ID_client";
echo "$c_Date";
echo "$c_Nom_Societe";
echo "$c_Nom";
echo "$c_Prenom";
echo "$c_Adresse";
echo "$c_CP";
echo "$c_Ville";
echo "$c_Telephone_Fixe";
echo "$c_Telephone_Mobile";
echo "$c_E_Mail";
echo "$p_Nom_Lieu";
echo "$p_Adresse";
echo "$p_CP";
echo "$p_Ville";
echo "$p_Type_Prestation";
echo "$p_Date";
echo "$p_H_Arrive";
echo "$p_H_Fin";
echo "$p_Nombre_Personne";
echo "$p_Moyenne_Age";
}
?> |
Partager