Insertion d'une valeur dans une table

**KIKOU94430** · 28/12/2022, 13h49

Bonjour

Je rencontre un soucis. J'ai du me tromper quelque part mais je ne trouve pas.

en fait cette fonction n'insère pas la ligne dans la table.

La première partie du code fait un update et la seconde partie doit insérer l'enregistrement si il n'existe pas mais lorsque je l'exécute cela ne marche pas.

Pouvez vous m'aider ?

Merci par avance

Code php :

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
 
 		if ($get_result = Db::getInstance()->getRow($sql_record)) {
 
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_cdiscount='.$cdiscount_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_cdiscount'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_manomano='.$manomano_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_manomano'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product='.$row['id_product']);		
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_amazon'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product='.$row['id_product']);	
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_darty='.$darty_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_darty'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_rakuten='.$rakuten_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_rakuten'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_distriartisan='.$distriartisan_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_distriartisan'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_leroymerlin='.$leroymerlin_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_leroymerlin'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$ubaldi_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_ubaldi'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product='.$row['id_product']);			
	        }
 
  	    }
 
		  else{
 
 
  			Db::getInstance()->execute("INSERT INTO `"._DB_PREFIX_."marketrepricing` (`id_product`, `price_min_cdiscount`) VALUES (".(int)$row['id_product'].", ".$cdiscount_prix_plancher." )");
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$manomano_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$darty_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$rakuten_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$distriartisan_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$leroymerlin_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$ubaldi_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
 
		}

**tatayo** · 28/12/2022, 14h12

Bonjour,
"Ca ne marche pas", c'est plus que vague.
Message d'erreur, pas de ligne créée, mauvaise(s) valeur(s) ?

Ton code n'est pas indenté, donc il est particulièrement difficile à suivre.
De plus il semble qu'il manque des accolades fermantes.
Par exemple à la ligne 6 tu as une accolade ouvrante, où est l'accolade fermante correspondante ?

Autre remarque: tu insères une ligne, puis tu lances une suite d'update sur cette ligne.
Pourquoi n'affectes tu pas ces valeurs directement au moment de l'insert ?
Si une de ces colonnes n'accepte pas les nulls, et qu'il n'y a pas de valeur par défaut, ton insert échouera systématiquement.
Et accessoirement ça fait une seule requête au lieu de 24. Une paille…

Tatayo.

**KIKOU94430** · 28/12/2022, 14h15

Je ne vais pas te mentir je suis totalement largué. Cela fait quelques jours que je suis dessus et je suis perdu. Peux tu m'aider à corriger le code si je le post ?

**KIKOU94430** · 28/12/2022, 14h29

si une personne veut bien m'aider à corriger et à optimiser ce code je suis preneur car je ne vois pas du tout comment faire.

merci par avance

Code PHP :

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
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
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
ini_set('memory_limit', '-1');
 
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
 
error_reporting(E_ALL);
set_time_limit(0);
 
include(dirname(__FILE__).'/../../config/config.inc.php');
include(dirname(__FILE__).'/../../init.php');
 
 
define('_PS_MODE_DEV_', true);
 
/**Update Cron time**/
$starttime =  date("Y-m-d H:i:s");
 
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'marketrepricing_croncheck` SET  `start_date` = "'.$starttime .'"  WHERE id=1  ');
 
/**Start**/
 
/***Update all product is_update to 0**/
Db::getInstance()->Execute("UPDATE ". _DB_PREFIX_ ."marketrepricing SET is_update = 0");
 
/**For testing Cron**/
$where = '';
if(isset($_GET['id']) && !empty($_GET['id'])){
	$ids = $_GET['id'];
	$where = " and id_product IN(".$ids.")";
}
/**End**/
$s  = $_GET['s'];
$e  = $_GET['e'];
 
 
$sql = "SELECT price, wholesale_price, special_wholesale_price, last_pa_price, shipping_cost, id_product FROM " . _DB_PREFIX_ . "product WHERE id_product BETWEEN " .$s ." AND " .$e .$where;
 
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
 
$i=0;
if($result){
foreach ($result as $row) {
 
 
	set_time_limit(0);
/**Start of update min max price in marketrepricing**/
		$product= new Product($row['id_product']);
  		$last_pa_price=$row['last_pa_price'];
  		$special_wholesale_price=$row['special_wholesale_price'];
  		$last_pa_price=$row['wholesale_price'];
  		$shipping_price = $row['shipping_cost']/1.200;
  		$product_finalprice = round(($product->getPrice(false, false)+$shipping_price)*1.6, 2);
 
          $cdiscount_prix_plancher =0;
		  $manomano_prix_plancher =0;
		  $amazon_prix_plancher =0;
		  $darty_prix_plancher =0;
		  $rakuten_prix_plancher =0;
		  $distriartisan_prix_plancher =0;
		  $leroymerlin_prix_plancher =0;
		  $ubaldi_prix_plancher =0;
 
          $sql_record = "SELECT * FROM " . _DB_PREFIX_ . "marketrepricing  WHERE id_product=".$row['id_product'];
 
// // calcul du coef : marge de secu 7% soit coef 1.10 x une com de 12.5% soit 1 coef de 1.18 x coef tva 1.200 = 1.554
 
          if ($row['last_pa_price']==0 || $row['last_pa_price']==0.01) {
  	         if ($row['special_wholesale_price']!=0) {
  	            $cdiscount_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.554, 2);
				$manomano_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
				$amazon_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.493, 2);
				$darty_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.554, 2);
				$rakuten_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
				$distriartisan_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
				$leroymerlin_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.530, 2);
				$ubaldi_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
  	         } else {
  	            $cdiscount_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.554, 2);
				$manomano_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.543, 2);
				$amazon_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.493, 2);
				$darty_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.554, 2);
				$rakuten_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.543, 2);
				$distriartisan_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.543, 2);
				$leroymerlin_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.530, 2);
				$ubaldi_prix_plancher =round(($row['wholesale_price']+$shipping_price)*1.543, 2);
  	         }    				
  	     } else {
              $cdiscount_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.554, 2);
			  $manomano_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
			  $amazon_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.493, 2);
			  $darty_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.554, 2);
			  $rakuten_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
			  $rakuten_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
			  $distriartisan_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.530, 2);
			  $ubaldi_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
  	     }
 
//on obtient le calcul du prix minimum de vente en TTC qu'on ins?re dans la table ps_marketrepricing. Meilleur prix d'achat x Coef de vente (voir calcul du coef plus haut)
 
  		if ($get_result = Db::getInstance()->getRow($sql_record)) {
 
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_cdiscount='.$cdiscount_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_cdiscount'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_manomano='.$manomano_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_manomano'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product='.$row['id_product']);		
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_amazon'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product='.$row['id_product']);	
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_darty='.$darty_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_darty'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_rakuten='.$rakuten_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_rakuten'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_distriartisan='.$distriartisan_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_distriartisan'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_leroymerlin='.$leroymerlin_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_leroymerlin'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$ubaldi_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_ubaldi'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product='.$row['id_product']);			
	        }
 
  	    }
 
		  else{
 
 
  			Db::getInstance()->execute("INSERT INTO `"._DB_PREFIX_."marketrepricing` (`id_product`, `price_min_cdiscount`) VALUES (".(int)$row['id_product'].", ".$cdiscount_prix_plancher." )");
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$manomano_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$darty_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$rakuten_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$distriartisan_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$leroymerlin_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$ubaldi_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
 
		}
 
		// digiwised 
		$sql_recordchild = "SELECT * FROM " . _DB_PREFIX_ . "product_attribute  WHERE id_product =".$row['id_product'];
 
		$resultchild = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql_recordchild);
		foreach ($resultchild as $rowchild) {
 
			$product= new Product($row['id_product']);
			$last_pa_price=$row['last_pa_price'];
			$special_wholesale_price=$row['special_wholesale_price'];
			$last_pa_price=$rowchild['wholesale_price'];
			$shipping_price = $row['shipping_cost']/1.200;
			$product_finalprice = round(($product->getPrice(false, false)+$shipping_price)*1.6, 2);
 
          $cdiscount_prix_plancher =0;
		  $manomano_prix_plancher =0;
		  $amazon_prix_plancher =0;
		  $darty_prix_plancher =0;
		  $rakuten_prix_plancher =0;
		  $distriartisan_prix_plancher =0;
		  $leroymerlin_prix_plancher =0;
		  $ubaldi_prix_plancher =0;
 
			$sql_record2 = "SELECT * FROM " . _DB_PREFIX_ . "marketrepricing  WHERE id_product_attribute=".$rowchild['id_product_attribute'] ;
 
  // // calcul du coef : marge de secu 7% soit coef 1.10 x une com de 12.5% soit 1 coef de 1.18 x coef tva 1.200 = 1.554
 
			if ($row['last_pa_price']==0 || $row['last_pa_price']==0.01) {
				 if ($row['special_wholesale_price']!=0) {
					$cdiscount_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.554, 2);
					$manomano_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
					$amazon_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.493, 2);
					$darty_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.554, 2);
					$rakuten_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
					$distriartisan_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
					$leroymerlin_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.530, 2);
					$ubaldi_prix_plancher =round(($row['special_wholesale_price']+$shipping_price)*1.543, 2);
				 } else {
					$cdiscount_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.554, 2);
					$manomano_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.543, 2);
					$amazon_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.493, 2);
					$darty_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.554, 2);
					$rakuten_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.543, 2);
					$distriartisan_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.543, 2);
					$leroymerlin_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.530, 2);
					$ubaldi_prix_plancher =round(($rowchild['wholesale_price']+$shipping_price)*1.543, 2);
 
				 }    				
			 } else {
				$cdiscount_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.554, 2);
				$manomano_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
				$amazon_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.493, 2);
				$darty_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.554, 2);
				$rakuten_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
				$distriartisan_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
				$leroymerlin_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.530, 2);
				$ubaldi_prix_plancher =round(($row['last_pa_price']+$shipping_price)*1.543, 2);
			 }
 
  //on obtient le calcul du prix minimum de vente en TTC qu'on ins?re dans la table ps_marketrepricing. Meilleur prix d'achat x Coef de vente (voir calcul du coef plus haut)
 
			if ($get_result = Db::getInstance()->getRow($sql_record2)) {
 
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_cdiscount='.$cdiscount_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_cdiscount'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_manomano='.$manomano_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_manomano'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_amazon'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_darty='.$darty_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_darty'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_rakuten='.$rakuten_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_rakuten'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_distriartisan='.$distriartisan_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_distriartisan'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_leroymerlin='.$leroymerlin_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_leroymerlin'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$ubaldi_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				if($get_result['alignment_lock_ubaldi'] == 0){
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
			  }
 
			}
 
			else{
 
 
				Db::getInstance()->execute("INSERT INTO `"._DB_PREFIX_."marketrepricing` (`id_product`,`id_product_attribute`, `price_min_cdiscount`) VALUES (".(int)$row['id_product'].",".(int)$rowchild['id_product_attribute'].", ".$cdiscount_prix_plancher." )");
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$manomano_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$amazon_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$darty_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$rakuten_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$distriartisan_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$leroymerlin_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
			}	
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$ubaldi_prix_plancher.'  WHERE id_product_attribute='.$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);
				Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product_attribute='.(int)$rowchild['id_product_attribute']);				
 
		  }
 
		}
// digiwised 
 
 	}
 
 	$endtime =  date("Y-m-d H:i:s");
 	Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'marketrepricing_croncheck` SET `end_date` = "'.$endtime .'"   WHERE id=1  ');
 
 	 echo 'Cron updated successfully'; echo '<br>';
 	 $row = Db::getInstance()->getRow('SELECT count(is_update) as total FROM `'._DB_PREFIX_.'marketrepricing` WHERE is_update=1'); 	
 	 echo 'Total product updated:'.$row['total'];
 
}
/**end**/

**tatayo** · 28/12/2022, 14h32

Je ne connais pas le langage utilisé, donc je ne sais pas si je pourrai t'aider.

Mais comme je l'indiquais, tu peux commencer par indenter le code, il sera déjà plus facile à suivre.
Et si tu ajoutes une gestion des erreurs, tu sauras si c'et un problème d'accolade (ton code n'est pas exécuté), un rejet de la base (une valeur obligatoire qui n'est pas renseignée), etc...

Bref tu auras des débuts de piste.

Tatayo.

**KIKOU94430** · 28/12/2022, 14h33

je pense ne pas être assez calé pour cela malheureusement.

J'espère que quelqu'un pourra m'aider.

merci pour ton intervention

**escartefigue** · 28/12/2022, 14h54

Personne ne pourra vous aider si vous ne communiquez pas le message d'erreur exact s'il y en a un, ou bien le résultat attendu par comparaison au résultat obtenu s'il n'y a aucun message d'erreur.

Par ailleurs, pourquoi faire autant d'ordres UPDATE qu'il y a de colonnes dans la table marketrepricing

C'est contre performant et inutile, un seul ordre UPDATE suffit dans lequel on alimentera toutes les colonnes de cette table à modifier !

EDIT il y a au moins une erreur dans le code :
Ligne 30, on trouve $where = " and id_product IN(".$ids.")";.
et ligne 37, on trouve "SELECT price [...] WHERE id_product BETWEEN " .$s ." AND " .$e .$where;
Ce faisant, la restriction WHERE va présenter deux AND consécutifs

Insertion d'une valeur dans une table

Langage SQL

Vue hybride

Discussions similaires

Partager

Partager