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
|
$export = $connexion->query("
SELECT
'Ref commande',
'ID client',
'Nom',
'Prenom',
'Adresse',
'Adresse 2',
'Ville',
'Code postal',
'Pays',
'Email',
'Telephone',
'Urgent',
'Remarques',
'Code article',
'Quantite',
'Date livraison'
UNION ALL
SELECT
ps_orders.reference,
ps_address.company,
ps_address.lastname,
ps_address.firstname,
ps_address.address1,
ps_address.address2,
ps_address.city,
ps_address.postcode,
ps_country.iso_code,
ps_customer.email,
ps_address.phone,
'',
'',
ps_product.reference,
ps_cart_product.quantity,
''
FROM ps_cart_product
LEFT JOIN ps_product ON (ps_cart_product.id_product = ps_product.id_product)
LEFT JOIN ps_orders ON (ps_orders.id_cart = ps_cart_product.id_cart)
LEFT JOIN ps_customer ON (ps_orders.id_customer = ps_customer.id_customer)
LEFT JOIN ps_cart ON (ps_cart.id_cart = ps_cart_product.id_cart)
LEFT JOIN ps_address ON (ps_cart.id_address_delivery = ps_address.id_address)
LEFT JOIN ps_country ON (ps_country.id_country = ps_address.id_country)
GROUP BY
ps_orders.reference,
ps_address.company,
ps_address.lastname,
ps_address.firstname,
ps_address.address1,
ps_address.address2,
ps_address.city,
ps_address.postcode,
ps_country.iso_code,
ps_customer.email,
ps_address.phone,
ps_product.reference,
ps_cart_product.quantity
");
$list = array();
while ($data = $export->fetch()) {
$list[] = $data['Ref commande'].';'.$data['ID client'].';'.$data['Nom'].';'.$data['Prenom'].';'.$data['Adresse'].';'.$data['Adresse 2'].';'.$data['Ville'].';'.$data['Code postal'].';'.$data['Pays'].';'.$data['Email'].';'.$data['Telephone'].';'.$data['Urgent'].';'.$data['Remarques'].';'.$data['Code article'].';'.$data['Quantite'].';'.$data['Date livraison'];
}
$file = fopen("prestashop.csv","w");
foreach ($list as $line)
{
fputcsv($file,explode(',',$line));
}
fclose($file);
}
} |
