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
|
session_start ();
if ( isset( $_SESSION['id_employe']) ) {
// Recuperation pour la variable
$id_employe = $_SESSION['id_employe'];
}
if (isset($_SESSION['email_employe'] )) {
include_once('../script/connect.php');
$id_client = $client['id_client'];
$id_employe = $_SESSION['id_employe'];
$date_creation = $_POST['date_creation'];
$id_article = $_POST['id_article'];
$description_lignedevis = $_POST['description_lignedevis'];
$quantite_lignedevis = $_POST['quantite_lignedevis'];
$prixunitaire_lignedevis = $_POST['prixunitaire_lignedevis'];
$tva_lignedevis = $_POST['tva_lignedevis'];
$creationdevis = $bdd -> prepare('INSERT INTO Devis (id_client, id_employe, date_creation)
VALUES (:id_client, :id_employe, :date_creation)');
$creationdevis->execute(array(
'id_client' => $id_client,
'id_employe' => $id_employe,
'date_creation' => $date_creation));
$insertionlignedevis = $bdd -> prepare('INSERT INTO Lignedevis (id_devis, code_article, description_lignedevis, quantite_lignedevis,prixunitaire_lignedevis,tva_lignedevis)
VALUES (:code_article, :description_lignedevis, :quantite_lignedevis, :prixunitaire_lignedevis, :tva_lignedevis)');
$insertionlignedevis->execute(array(
'id_devis' => $id_client,
'code_article' => $id_client,
'description_lignedevis' => $id_client,
'quantite_lignedevis' => $id_client,
'prixunitaire_lignedevis' => $id_client,
'tva_lignedevis' => $tva_lignedevis)); |
Partager