-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdateVentes.php
227 lines (203 loc) · 12.3 KB
/
updateVentes.php
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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
<!DOCTYPE html>
<html lang="en">
<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">
<title>Gestion</title>
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap.min.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-grid.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-grid.min.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-grid.rtl.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-reboot.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-reboot.rtl.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-utilities.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-utilities.rtl.css">
<link rel="stylesheet" href="bootstrap-5.0.2-dist/css/bootstrap-utilities.rtl.min.css">
<script defer src="bootstrap-5.0.2-dist/js/bootstrap.js"></script>
<script defer src="bootstrap-5.0.2-dist/js/bootstrap.min.js"></script>
<script defer src="bootstrap-5.0.2-dist/js/bootstrap.esm.js"></script>
<script defer src="bootstrap-5.0.2-dist/js/bootstrap.esm.min.js"></script>
<script defer src="bootstrap-5.0.2-dist/js/bootstrap.bundle.js"></script>
<script defer src="navbar.js"></script>
<link rel="stylesheet" href="index.css">
<script defer src="jsfile/takeVente.js"></script>
<script defer src="./jsfile/datalist.js"></script>
</head>
<?php
function findIDVente(){
include 'connexion.php';
$sql= ("SELECT idVentes FROM Ventes order by idVentes desc limit 1");
$result = mysqli_query($db, $sql);
if(mysqli_num_rows($result)>0){
$valeur = 0;
while($row= mysqli_fetch_assoc($result)){
$valeur = $row["idVentes"];
}
return $valeur;
}else{return "Une erreur s est produite ";}
}
function data(){
include 'connexion.php';
$sql = ("SELECT * FROM `Change` order by idChange desc limit 1");
$result = mysqli_query($db, $sql);
if(mysqli_num_rows($result)>0){
while($row= mysqli_fetch_assoc($result)){
return "ID ::".$row["idChange"].":: 1$ = ::".$row["Chilling"].":: chilling = ::".$row["Rwandais"].":: rwandais= ::".$row["CDF"].":: Fc";
}
}
}
function dataProduct(){
include 'connexion.php';
$sql = ("SELECT * FROM Produit order by Nom asc");
$result = mysqli_query($db, $sql);
if(mysqli_num_rows($result)>0){
while($row= mysqli_fetch_assoc($result)){
echo"<option value='ID ::".$row["idProduit"].":: Nom ::".$row["Nom"].":: PA ::".$row["PrixAchat"].":: PV = ::".$row["PrixVente"].":: PVmin =::".$row["PrixVmin"].":: QstockMin = ::".$row["QuantiteStockMin"]."'>nom: ".$row["Nom"]." :Qstock ".$row["QuantiteStock"]."</option>";
}
}else{echo "Une erreur s est produite ";}
}
function dataPersonnel(){
include 'connexion.php';
$sql = ("SELECT * FROM Client order by idClient desc");
$result = mysqli_query($db, $sql);
if(mysqli_num_rows($result)>0){
while($row= mysqli_fetch_assoc($result)){
echo"<option value='ID ::".$row["idClient"].":: Nom ::".$row["NomClient"].":: Telephone ::".$row["Telephone"]."'> = ".$row["Nom"]."</option>";
}
}else{echo "Une erreur s est produite ";}
}
?>
<body class="back">
<main>
<div class="container bg-transparent pt-5">
<h1 class="p-2">Modifier ventes</h1>
<hr class="w-auto">
<form action="">
<input type="hidden" id="check-datalist" value="updateVentes">
<div class="input-group mb-3 mx-auto d-block">
<span class="input-group-text " id="id">Identifiant*</span>
<input required type="text" list="dataBesoin" id="identifiantM" class="form-control w-50" placeholder="entrer identifiant" aria-label="Username" aria-describedby="nom" >
<datalist id="dataBesoin"></datalist>
</div>
<div class="row border border-1 mt-3 pt-3 w-75 d-block mx-auto">
<div class="input-group mb-3" >
<div class="input-group mb-3" >
<span class="input-group-text" id="basic-addon1">Nom*</span>
<input required type="text" list="dataPersonnel" id="nomClient" class="form-control" placeholder="Nom du client" aria-label="Username" aria-describedby="basic-addon1">
<datalist id="dataPersonnel">
<?php
dataPersonnel();
?>
</datalist>
</div>
<small id="clientVide"></small>
</div>
</div>
<div class="input-group mb-3 pt-5 pb-4" id="ajoutons">
<a id="remove" href="#" class="text-decoration-none"><span class="input-group-text bg-danger text-white">✗</span></a>
<span class="input-group-text border border-primary">Nom</span>
<input id="produit" type="text" list="dataProduct" class="form-control border border-primary w-25" placeholder="Entrer nom du produit" aria-label="Username">
<datalist id="dataProduct">
<?php
dataProduct();
?>
</datalist>
<span class="input-group-text border border-success">Quantite</span>
<input id="quantite" type="float" class="form-control border border-success" placeholder="Quantite" aria-label="Server">
<span class="input-group-text">PV Unitaire</span>
<input id="pvu" type="float" class="form-control" placeholder="prix de vente" aria-label="Server">
<span class="input-group-text">$</span>
<a id="add" href="#" class="text-decoration-none"><span class="input-group-text bg-success text-white">+</span></a>
<a id="M-add" href="#" class="text-decoration-none"><span class="input-group-text bg-primary text-white">✓</span></a>
</div>
<small id="produitVide"></small>
<small id="quantiteVide"></small>
<small id="pvuVide"></small>
<small id="quantiteGrand"></small>
<p id="txtHint1"></p>
<table class="table border border-1">
<thead class="bg-transparent text-secondary">
<tr>
<th>Nom du produit</th>
<th>Quantite vendu</th>
<th>Prix de vente unitaire</th>
<th>Prix de vente total</th>
<th>Action</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<div class="row">
<div class="border border-1 p-4 col-md-4 m-2">
<div class="input-group mb-3">
<label class="input-group-text" for="inputGroupSelect01">Choisir stock</label>
<select class="form-select" id="inputGroupSelect01">
<option selected value="1">Stock 1</option>
</select>
</div>
<div class="input-group mb-3">
<span class="input-group-text" id="basic-addon1">Date*</span>
<input required type="date" name="dates" id="date-vente" class="form-control w-50" placeholder="mettre la date" aria-label="Username" aria-describedby="nom" value="<?php $d = strtotime("today"); echo date('Y-m-d',$d); ?>">
</div>
<div class="input-group mb-3 border border-1 border-warning">
<span class="input-group-text" id="basic-addon1">Quantite en stock*</span>
<input id="qstock" readonly type="float" class="form-control" aria-label="Username" aria-describedby="basic-addon1">
</div>
<small>1 commande en cours ...</small>
</div>
<div class="border border-1 m-2 col-md-4">
<h4>Status</h4>
<div class="input-group mb-3">
<label class="input-group-text" for="status">status</label>
<select class="form-select" id="status">
<option selected>en attente</option>
<option value="paid">paye</option>
<option value="dette">dette</option>
</select>
<button id="envoi" type="button" class="btn btn-primary">Valider</button>
</div>
<div class="input-group mb-3">
<span class="input-group-text">Montant</span>
<input type="float" id="montant" class="form-control" aria-label="Amount (to the nearest dollar)">
<span class="input-group-text">$</span>
</div>
<small id="montantVide"></small>
<div class="input-group mb-3 ">
<span class="input-group-text">Reste</span>
<input type="flaot" id="reste" class="form-control" aria-label="Amount (to the nearest dollar)">
<span class="input-group-text">$</span>
</div>
</div>
<div class="border border-1 col-md-3 m-2 bg-warning moinClaire">
<h4 class="text-secondary">Calcul du total</h4>
<div class="input-group mb-3">
<input type="float" id="total" readonly class="form-control" placeholder="0.00" aria-label="Recipient's username" aria-describedby="basic-addon0">
<span class="input-group-text" id="basic-addon0">$</span>
</div>
<div class="input-group mb-3">
<input type="float" id="cdf" readonly class="form-control" placeholder="0.00" aria-label="Recipient's username" aria-describedby="basic-addon1">
<span class="input-group-text" id="basic-addon">Fc</span>
</div>
<div class="input-group mb-3">
<input type="float" id="chilling" readonly class="form-control" placeholder="0.00" aria-label="Recipient's username" aria-describedby="basic-addon2">
<span class="input-group-text" id="basic-addon2">chilling</span>
</div>
<div class="input-group mb-3">
<input type="float" id="rwandais" readonly class="form-control" placeholder="0.00" aria-label="Recipient's username" aria-describedby="basic-addon2">
<span class="input-group-text" id="basic-addon2">RWD</span>
</div>
</div>
</div>
<input type="hidden" id="change" value='<?php echo data(); ?>'>
<!-- just using to make difference between add, remove, and update -->
<input type="hidden" id="state" >
<input type="hidden" id="operation" value="<?php echo findIDVente(); ?>" />
<input type="hidden" id="typeForm" value="update" />
</form>
</div>
</main>
</body>
</html>