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
| <?php
// Connexion master sur $connexion2
try {
$connexion = new PDO('mysql:host=xxxxxx;dbname=xxxxx', 'xxxx', 'xxxxx');
$connexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
echo $e->getMessage();
}
$file_name = 'prestashop.csv';
$stmt = $connexion->query("SELECT * FROM ps_orders");
$count = $stmt->rowCount();
$stmt_dsp = $stmt->fetch(PDO::FETCH_OBJ);
if(!empty($count)){
if (file_exists($file_name))
{
unlink($file_name);
$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,
''
INTO OUTFILE '$file_name'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
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
");
}
} |
Partager