query("order_items", "SELECT DISTINCT order_id FROM order_items WHERE 1 ORDER BY record_id DESC");
while ($order_ids = $order_ids_res->fetch_assoc()) {
$order_id = $order_ids['order_id'];
$roder_res = $db->query("orders","SELECT * FROM orders WHERE record_id = '$order_id'");
$order = $roder_res->fetch_assoc();
// Query to find duplicate stock_ids within THIS specific order
$dupe_query = "SELECT stock_id, COUNT(*) as qty ,`name`
FROM order_items
WHERE order_id = '$order_id' AND stock_type = 2
GROUP BY stock_id
HAVING COUNT(*) > 1";
$dupe_res = $db->query("order_items", $dupe_query);
if ($dupe_res->num_rows > 0) {
echo "ORDER ID: " . $order_id . " - " . $order['po_number'] . "
";
echo "";
while ($dupe = $dupe_res->fetch_assoc()) {
echo "- Duplicate Stock ID: " . $dupe['stock_id'] . " (Found " . $dupe['qty'] . " times) as " . $dupe['name'] . "
";
}
echo "
";
} else {
// echo "No duplicate stock IDs found for this order.
";
}
}