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 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136
| <!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="sortie.css">
<title >Formulaire de sortie</title>
</head>
<?php
include ('class/connection.php');
$connection=new connection();
$users =$connection->user();
$categorie='';
$reference='';
?>
<body>
<div class=formsortie >
<h1 id=titre>Formulaire de sortie</h1>
<ul class="sortie">
<div class="categorie, selection">
<li id=titre><strong>Catégorie</strong> </li>
<ul class="result">
<?php $sql = "SELECT categorie FROM achat";
$stmt = $users->query($sql); ?>
<li> <?php while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
<ul>
<li class="deroulant">
<form action="form-sortie.php" method="get">
<input type="submit" name="categorie" value=<?php echo htmlspecialchars($row['categorie']); ?>>
<?php if(isset($_GET['categorie'])){ $categorie= $_GET['categorie'];}?>
</form>
</li>
</ul>
<?php endwhile; ?>
</li>
</ul>
</div>
<?php
$sql="SELECT reference FROM achat WHERE categorie= '$categorie' ";
$stmt = $users->query($sql);?>
<div class="reference, selection">
<li id=titre><strong>Reference</strong> </li>
<ul class="result">
<li> <?php while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
<ul>
<li class="deroulant">
<form action="form-sortie.php" method="get">
<input type="submit" name="reference" value=<?php echo htmlspecialchars($row['reference']); ?>>
<?php if(isset($_GET['reference'])){ $reference= $_GET['reference'];
echo $reference ;} ?>
</form>
</li>
</ul>
<?php endwhile; ?>
</li>
</ul>
</div>
<?php
echo $reference;
?>
<?php $sql = "SELECT designation FROM achat WHERE categorie='$categorie' AND reference='$reference'";
$stmt = $users->query($sql);?>
<div class="designation, selection">
<li id=titre><strong>Designation</strong></li>
<ul class="result">
<li> <?php while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
<ul>
<li class="deroulant">
<form action="form-sortie.php" method="get">
<input type="submit" name="designation" value=<?php echo htmlspecialchars($row['designation']); ?>>
</form>
</li>
</ul>
<?php endwhile; ?>
</li>
</ul>
</div>
<form action="sortiebdb.php" methode="post">
<div class=quantite>
<li><strong id=titre>Quantité:</strong></li>
<label for="quantite"></label>
<input type="text" id="quantite" placeholder="Quantité:" name="Quantité" >
<input type="submit" value="ok">
</div>
</ul>
</form>
</div>
<div class="bande_horizontale"></div>
<div class="stock-grid">
<div class=col-gauche>
<div><img src="img/img1.jpg"> </div>
<div><img src="img/img2.jpg"></div>
<div><img src="img/img3.jpg"></div>
</div>
<div class=col-stock>
<h1>Liste des perles utiliser</h1>
</div>
<div class=col-prix>
<h1>Prix de vente</h1>
<form>
</div>
<div class=col-droite>
<div><img src="img/img4.jpg"></div>
<div><img src="img/img6.jpg"></div>
<div><img src="img/img7.jpg"></div>
</div>
</div>
<div id=navigation>
<button type="submit" name="insert" class="open-button border">Valider</button></br>
<a class="open-button border" href="index.php">Fermer</a>
<!--<button type="button" class="open-button border" onclick="closeForm()">Fermer</button>-->
</div>
<script>
function sortieForm() {
document.getElementById("formsortie").style.display="block";
}
function closeForm() {
document.getElementById("formsortie").style.display="none";
}
</script>
</div>
</body>
</html> |
Partager