Einfache Packliste / Pickliste für Mobilgeräte

ü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);