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
| if (!empty($enterTake) && $enterTake == "take"){
$req_count_enter = $bdd -> prepare("
SELECT
COUNT(DISTINCT st_idEnter) AS count_enter
FROM (
SELECT st_idEnter
FROM `stock`
WHERE
st_idTool = 1
AND
st_stock = 3
ORDER BY st_id ASC LIMIT ".$quantity."
) AS T1
");
$req_count_enter ->execute();
$data = $req_count_enter->fetch(PDO::FETCH_ASSOC);
$req_count_enter -> closeCursor();
$req_count_enter = NULL;
$count_enter = $data['count_enter'];
/*------- il faut que je bloucle ici------*/
for ($i=0; $i < $count_enter; $i++){
$req_idEnter = $bdd -> prepare('
SELECT
MAX(idEnter) AS maxIdEnter
FROM (
SELECT idEnter FROM `enter`
UNION ALL
SELECT idEnter FROM `take`
) AS t
');
$req_idEnter ->execute();
$data_idEnter = $req_idEnter -> fetch(PDO::FETCH_ASSOC);
$req_idEnter -> closeCursor();
$req_idEnter = NULL;
$idEnter = $data_idEnter['maxIdEnter'] + 1;
$req_price = $bdd -> prepare('
SELECT SUM(st_price) AS price
FROM (
SELECT st_price
FROM `stock`
WHERE
st_idTool = ?
AND
st_stock = ?
AND
st_wear IS NULL
ORDER BY st_date ASC LIMIT '.$quantity.'
) AS t1
');
$req_price ->execute(
array(
$idTool,
$us_idLocation
)
);
$data = $req_price -> fetch(PDO::FETCH_ASSOC);
$req_price -> closeCursor();
$req_price = NULL;
$sumPrice = $data['price'];
$req_dateMove = $bdd -> prepare('
SELECT st_idEnter, st_date
FROM `stock`
WHERE st_idTool = ?
AND
st_stock = ?
AND
st_wear IS NULL
ORDER BY st_date ASC LIMIT '.$quantity
);
$req_dateMove ->execute(
array(
$idTool,
$us_idLocation
)
);
$data = $req_dateMove -> fetch(PDO::FETCH_ASSOC);
$req_dateMove -> closeCursor();
$req_dateMove = NULL;
$idEnterMove = $data['st_idEnter'];
$dateMove = $data['st_date'];
$req_delete = $bdd -> prepare('
DELETE
FROM `stock`
WHERE
st_idTool = ?
AND
st_stock = ?
AND
st_wear IS NULL
ORDER BY st_date ASC LIMIT '.$quantity
);
$req_delete ->execute(
array(
$idTool,
$us_idLocation
)
);
$req_delete -> closeCursor();
$req_delete = NULL;
$req_quantity_taken = $bdd->prepare(
'INSERT INTO `take` (
idTool,
idEnter,
idEnterMove,
idUser,
idProvider,
quantity,
idLocation,
sumPrice,
price,
fabricationOrder,
itemNumber,
dateMove,
date
)VALUES(
:idTool,
:idEnter,
:idEnterMove,
:idUser,
:idProvider,
:quantity,
:idLocation,
:sumPrice,
:price,
:fabricationOrder,
:itemNumber,
:dateMove,
:date
)'
);
$req_quantity_taken -> execute(
array(
'idTool' => $idTool,
'idEnter' => $idEnter,
'idEnterMove' => $idEnterMove,
'idUser' => $idUser,
'idProvider' => $pr_id,
'quantity' => $quantity,
'idLocation' => $location,
'sumPrice' => $sumPrice,
'price' => $price,
'fabricationOrder' => $fabricationOrder,
'itemNumber' => $itemNumber,
'dateMove' => $dateMove,
'date' => $date,
)
);
$req_quantity_taken -> closeCursor();
$req_quantity_taken = NULL;
} |
