55 lines
1.5 KiB
PHP
55 lines
1.5 KiB
PHP
<?php
|
|
// Parametry połączenia z bazą danych
|
|
$servername = '67806.m.tld.pl';
|
|
$username = 'admin67806_newwalls_ps';
|
|
$password = '3WzV}620CC';
|
|
$dbname = 'baza67806_newwalls_ps';
|
|
$prefix = "ps_"; // Prefiks tabel PrestaShop
|
|
|
|
// Tworzenie połączenia
|
|
$conn = new mysqli($servername, $username, $password, $dbname);
|
|
|
|
// Sprawdzenie połączenia
|
|
if ($conn->connect_error) {
|
|
die("Connection failed: " . $conn->connect_error);
|
|
}
|
|
|
|
// Zapytanie SQL do pobrania danych o zamówieniach z ostatnich 3 miesięcy
|
|
$sql = "SELECT o.id_order AS ORDER_ID,
|
|
c.email AS EMAIL,
|
|
c.firstname AS FIRST_NAME,
|
|
c.lastname AS LAST_NAME,
|
|
od.product_id AS PRODUCT_ID,
|
|
od.product_name AS PRODUCT_NAME
|
|
FROM {$prefix}orders o
|
|
JOIN {$prefix}customer c ON o.id_customer = c.id_customer
|
|
JOIN {$prefix}order_detail od ON o.id_order = od.id_order
|
|
WHERE o.date_add >= DATE_SUB(CURDATE(), INTERVAL 10 MONTH)";
|
|
|
|
$result = $conn->query($sql);
|
|
|
|
if ($result->num_rows > 0) {
|
|
// Otworzenie pliku CSV do zapisu
|
|
$fp = fopen('orders.csv', 'w');
|
|
|
|
// Nagłówki kolumn
|
|
$headers = array('ORDER_ID', 'EMAIL', 'FIRST_NAME', 'LAST_NAME', 'PRODUCT_ID', 'PRODUCT_NAME');
|
|
fputcsv($fp, $headers);
|
|
|
|
// Przetwarzanie każdego wiersza
|
|
while($row = $result->fetch_assoc()) {
|
|
fputcsv($fp, $row);
|
|
}
|
|
|
|
// Zamknięcie pliku CSV
|
|
fclose($fp);
|
|
|
|
echo "Plik CSV został wygenerowany.";
|
|
} else {
|
|
echo "Brak danych.";
|
|
}
|
|
|
|
// Zamknięcie połączenia
|
|
$conn->close();
|
|
?>
|