überarbeitete Version für Shopware 5.6 auf PHP 7.x
";
$result = mysqli_query($db, "SELECT * FROM `s_order` WHERE `status` = 0 LIMIT 50");
while( $order = mysqli_fetch_array($result) )
{
$result_user = mysqli_query($db, "SELECT * FROM `s_order_shippingaddress` WHERE `orderID` = ".$order['id']);
$user = mysqli_fetch_array($result_user);
$result_country = mysqli_query($db, "SELECT * FROM `s_core_countries` WHERE `id` = ".$user['countryID']);
$country = mysqli_fetch_array($result_country);
print "";
print $order['ordernumber']." - ";
print $user['firstname']." ";
print $user['lastname']." - ";
print $user['city'].", ";
print $country['countryiso']."";
print " ";
print "";
if ($order['cleared']=="17") print " O "; //Zahlung Offen
$result_magna = mysqli_query($db, "SELECT * FROM `magnalister_orders` WHERE `current_orders_id` = ".$order['id']);
$magna = mysqli_fetch_array($result_magna);
if ($magna['platform']) print " ".strtoupper(substr($magna['platform'],0,1))." "; //Platform Import
print "";
$result_orders = mysqli_query($db, "SELECT * FROM `s_order_details` WHERE `orderID` = ".$order['id']);
while($orders = mysqli_fetch_array($result_orders) )
{
print " • ".$orders['quantity']." x ";
print $orders['articleordernumber']." ";
print $orders['name']." ";
print "";
// echo ""; print_r($magna); echo "";
}
print "";
}
print "
"; mysqli_close($db);