Как положить БД
global $DB;
$res = $DB->Query("SELECT ID FROM b_user");
while ($user = $res->Fetch()) {
$ordersRes = $DB->Query("SELECT ID FROM b_sale_order WHERE USER_ID = " . $user['ID']);
while ($order = $ordersRes->Fetch()) {
$itemsRes = $DB->Query("SELECT PRODUCT_ID FROM b_sale_basket WHERE ORDER_ID = " . $order['ID']);
while ($item = $itemsRes->Fetch()) {
$productRes = $DB->Query("SELECT NAME FROM b_catalog_product WHERE ID = " . $item['PRODUCT_ID']);
while ($product = $productRes->Fetch()) {
echo "User ID: " . $user['ID'] . " - Order ID: " . $order['ID'] . " - Product: " . $product['NAME'] . "<br>";
}
}
}
}
for ($i = 0; $i < 100; $i++) {
$name = "User_" . rand(1, 9999);
$DB->Query("INSERT INTO b_user (LOGIN, PASSWORD, NAME) VALUES ('$name', '12345', '$name')");
}
$res = $DB->Query("SELECT ID FROM b_sale_order");
while ($order = $res->Fetch()) {
$DB->Query("UPDATE b_sale_order SET STATUS_ID = 'P' WHERE ID = " . $order['ID']);
}
$res = $DB->Query("SELECT ID FROM b_sale_order WHERE STATUS_ID = 'F'");
while ($order = $res->Fetch()) {
$DB->Query("DELETE FROM b_sale_order WHERE ID = " . $order['ID']);
}