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
|
$order_id = 146;
mysql_select_db($database_xxx, $xxx);
$query_num = sprintf("SELECT ligne_commande.*, produit.*
FROM ligne_commande
INNER JOIN produit
ON produit.id = ligne_commande.produit
WHERE ligne_commande.num_commande = ". $order_id ."
ORDER BY ligne_commande.id ASC");
$num = mysql_query($query_num, $xxx) or die(mysql_error());
$row_num = mysql_fetch_assoc($num);
$totalRows_num = mysql_num_rows($num);
echo ' nombres darticles ';
echo $totalRows_num ;
$compteurlignes = 0;
while ($compteurlignes < $totalRows_num) {
echo ' nb compteur ';
echo $compteurlignes ;
if ($row_num['taille'] == "unique"){
$stock_tu = $row_num['taille_unique'] - $row_num['quantite'];
$prdt_tu = $row_num['id'];
$query_tu = sprintf("UPDATE produit SET taille_unique=%s WHERE id=%s",
GetSQLValueString($stock_tu, "int"),
GetSQLValueString($prdt_tu, "int"));
mysql_select_db($database_xxx, $xxx);
$Result2 = mysql_query($query_tu, $xxx) or die(mysql_error());
echo 'TU ok <br>';
}
if ($row_num['taille'] == "36 (XS"){
$stock_36 = $row_num['36_XS'] - $row_num['quantite'];
$prdt_36 = $row_num['id'];
$query_36 = sprintf("UPDATE produit SET 36_XS=%s WHERE id=%s",
GetSQLValueString($stock_36, "int"),
GetSQLValueString($prdt_36, "int"));
mysql_select_db($database_xxx, $xxx);
$Result3 = mysql_query($query_36, $xxx) or die(mysql_error());
echo '36 ok <br>';
}
if ($row_num['taille'] == "38 (S)"){
$stock_38 = $row_num['38_S'] - $row_num['quantite'];
echo 'npuveau stock en 38';
echo $stock_38 ;
$prdt_38 = $row_num['id'];
$query_38 = sprintf("UPDATE produit SET 38_S=%s WHERE id=%s",
GetSQLValueString($stock_38, "int"),
GetSQLValueString($prdt_38, "int"));
mysql_select_db($database_xxx, $xxx);
$Result4 = mysql_query($query_38, $xxx) or die(mysql_error());
echo '38 ok <br>';
}
if ($row_num['taille'] == "40 (M)"){
$stock_40 = $row_num['40_M'] - $row_num['quantite'];
$prdt_40 = $row_num['id'];
$query_40 = sprintf("UPDATE produit SET 40_M=%s WHERE id=%s",
GetSQLValueString($stock_40, "int"),
GetSQLValueString($prdt_40, "int"));
mysql_select_db($database_xxx, $xxx);
$Result5 = mysql_query($query_40, $xxx) or die(mysql_error());
echo '40 ok <br>';
}
if ($row_num['taille'] == "42 (L)"){
$stock_42 = $row_num['42_L'] - $row_num['quantite'];
$prdt_42 = $row_num['id'];
$query_42 = sprintf("UPDATE produit SET 42_L=%s WHERE id=%s",
GetSQLValueString($stock_42, "int"),
GetSQLValueString($prdt_42, "int"));
mysql_select_db($database_xxx, $xxx);
$Result6 = mysql_query($query_42, $xxx) or die(mysql_error());
echo '42 ok <br>';
}
if ($row_num['taille'] == "44 (XL"){
$stock_44 = $row_num['44_XL'] - $row_num['quantite'];
$prdt_44 = $row_num['id'];
$query_44 = sprintf("UPDATE produit SET 44_XL=%s WHERE id=%s",
GetSQLValueString($stock_44, "int"),
GetSQLValueString($prdt_44, "int"));
mysql_select_db($database_xxxk, $xxx);
$Result7 = mysql_query($query_44, $xxx) or die(mysql_error());
echo '44 ok <br>';
}
$compteurlignes = $compteurlignes+1;
} |
