Bonjour à Tous,
Lorsque je récupère mon tableau pour le modifier le calcul en rapport à mes quantités ne se fait que sur la première ligne, sur les autre mon total reste inchangé si je modifie mes quantités.
Côté Php
Code html : Sélectionner tout - Visualiser dans une fenêtre à part
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 <div class='row'> <div class='col-xs-12 col-sm-12 col-md-12 col-lg-12'> <table class="table table-bordered table-hover" > <thead> <tr> <th width="2%"><input id="id" class="formcontrol" type="checkbox"/></th> <th width="15%">Ref</th> <th width="38%">Produits</th> <th width="15%">Prix</th> <th width="15%">Qtt</th> <th width="15%">Total</th> </tr> </thead> <?php $query = "select * from subsciption WHERE invoice='$memid'"; $result = mysqli_query($con,$query); if(mysqli_affected_rows($con)!=0){ while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){ ?> <tbody> <td><input class="case" name="id[]" type="checkbox" value="<?php echo $row['id'];?>" /></td> <td><input type="text" data-type="productCode" name="itemNo[]" id="itemNo_1" class="form-control autocomplete_txt" autocomplete="off" value="<?php echo $row['sub_type'];?>"></td> <td><input type="text" data-type="productName" name="itemName[]" id="itemName_1" class="form-control autocomplete_txt" autocomplete="off" value="<?php echo $row['name_produit'];?>"></td> <td><input type="number" name="price[]" id="price_1" class="form-control changesNo" value="<?php echo $row['prix_produit'];?>" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;" ></td> <td><input type="number" name="quantity[]" id="quantity_1" class="form-control changesNo" value="<?php echo $row['qtt'];?>" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;" ></td> <td><input type="number" name="total[]" id="total_1" class="form-control totalLinePrice" value="<?php echo $row['total_produit']?>" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;" ></td> </tbody> <?php } } ?> </table> <div class='row' style="margin-left: 10px; margin-top: 10px;"> <div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'> <button class="btn btn-danger delete" type="button">- Supprimer</button> <button class="btn btn-success addmore" type="button">+ Ajout produit</button> </div> <?php $query = "select * from invoices WHERE invoice='$memid'"; $result = mysqli_query($con,$query); if(mysqli_affected_rows($con)!=0){ while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){ ?> <div class='col-xs-12 col-sm-offset-4 col-md-offset-4 col-lg-offset-4 col-sm-5 col-md-5 col-lg-5'> <form class="form-inline"> <div class="form-group"> <label>Sous Total: </label> <div class="input-group"> <input type="number" class="form-control" name="subtotal" id="subTotal" placeholder="Sous Total" onkeypress="return IsNumeric(event);" ondrop="return false;" value="<?php echo $row['sous_total'];?>" onpaste="return false;"> <div class="input-group-addon"></div> </div> </div> <div class="form-group"> <label>TVA: </label> <div class="input-group"> <div class="input-group-addon">%</div> <input type="number" class="form-control" id="tax" placeholder="TVA" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"> </div> </div> <div class="form-group"> <label>Total TVA: </label> <div class="input-group"> <input type="number" class="form-control" name="taxAmount" id="taxAmount" placeholder="TVA" onkeypress="return IsNumeric(event);" ondrop="return false;" value="<?php echo $row['tva'];?>" onpaste="return false;"> <div class="input-group-addon"></div> </div> </div> <div class="form-group"> <label>Total: </label> <div class="input-group"> <input type="number" class="form-control" name="totalAftertax" id="totalAftertax" placeholder="Total" value="<?php echo $row['total'];?>" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"> <div class="input-group-addon"></div> </div> </div> <div class="form-group"> <label>Paiement: </label> <div class="input-group"> <input type="number" class="form-control" name="amountPaid" id="amountPaid" placeholder="Paiement" onkeypress="return IsNumeric(event);" ondrop="return false;" value="<?php echo $row['paid'];?>" onpaste="return false;"> <div class="input-group-addon"></div> </div> </div> <div class="form-group"> <label>Solde: </label> <div class="input-group"> <input type="number" class="form-control amountDue" name="amountDue" id="amountDue" placeholder="Solde" onkeypress="return IsNumeric(event);" ondrop="return false;" value="<?php echo $row['bal'];?>" onpaste="return false;"> <div class="input-group-addon"></div> </div> </div> <div class="form-group"> <div class="controls"><span id="spryselect2"> <select name="m" id="id" data-rule-required="true" required> <option value=""><?php echo $row['reglement'];?></option> <option value="CB">CB</option> <option value="Chèque">Chèque</option> <option value="Espèces ">Espèces </option> </select> </div> </div> <?php } } ?> <div class="form-actions"> <button type="submit" class="btn btn-primary">Enregistrer</button> </div> </form> </div> </div>
Côté js
J'ai bien toutes les lignes correspondantes à mon enregistrement dans ma bdd mais lors de changements dans la quantité l'action ne se fait que pour la première ligne.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 //autocomplete script $(document).on('focus','.autocomplete_txt',function(){ type = $(this).data('type'); if(type =='productCode' )autoTypeNo=0; if(type =='productName' )autoTypeNo=1; $(this).autocomplete({ source: function( request, response ) { var array = $.map(prices, function (item) { var code = item.split("|"); return { label: code[autoTypeNo], value: code[autoTypeNo], data : item } }); //appel au filtre response($.ui.autocomplete.filter(array, request.term)); }, autoFocus: true, minLength: 2, select: function( event, ui ) { var names = ui.item.data.split("|"); id_arr = $(this).attr('id'); id = id_arr.split("_"); $('#itemNo_'+id[1]).val(names[0]); $('#itemName_'+id[1]).val(names[1]); $('#quantity_'+id[1]).val(1); $('#price_'+id[1]).val(names[2]); $('#total_'+id[1]).val( 1*names[2] ); calculateTotal(); } }); }); //Changement du prix $(document).on('change keyup blur','.changesNo',function(){ id_arr = $(this).attr('id'); id = id_arr.split("_"); quantity = $('#quantity_'+id[1]).val(); price = $('#price_'+id[1]).val(); if( quantity!='' && price !='' ) $('#total_'+id[1]).val( (parseFloat(price)*parseFloat(quantity)).toFixed(2) ); calculateTotal(); }); $(document).on('change keyup blur','#tax',function(){ calculateTotal(); }); //calcul du prix function calculateTotal(){ subTotal = 0 ; total = 0; $('.totalLinePrice').each(function(){ if($(this).val() != '' )subTotal += parseFloat( $(this).val() ); }); $('#subTotal').val( subTotal.toFixed(2) ); tax = $('#tax').val(); if(tax != '' && typeof(tax) != "undefined" ){ taxAmount = subTotal * ( parseFloat(tax) /100 ); $('#taxAmount').val(taxAmount.toFixed(2)); total = subTotal + taxAmount; }else{ $('#taxAmount').val(0); total = subTotal; } $('#totalAftertax').val( total.toFixed(2) ); calculateAmountDue(); } $(document).on('change keyup blur','#amountPaid',function(){ calculateAmountDue(); }); //calcul du solde function calculateAmountDue(){ amountPaid = $('#amountPaid').val(); total = $('#totalAftertax').val(); if(amountPaid != '' && typeof(amountPaid) != "undefined" ){ amountDue = parseFloat(total) - parseFloat( amountPaid ); $('.amountDue').val( amountDue.toFixed(2) ); }else{ total = parseFloat(total).toFixed(2); $('.amountDue').val( total); } } //restriction non-chifre var specialKeys = new Array(); specialKeys.push(8,46); //Backspace function IsNumeric(e) { var keyCode = e.which ? e.which : e.keyCode; console.log( keyCode ); var ret = ((keyCode >= 48 && keyCode <= 57) || specialKeys.indexOf(keyCode) != -1); return ret; }
Merci pour votre aide
Partager