#!/bin/bash
echo "=== ALL POSSIBLE ORDERS (Last 30 days) ==="

cd /home/fslptqho/public_html || exit 1

for dir in */; do
    [ -d "$dir" ] || continue
    site=${dir%/}
    wpconfig="${dir}wp-config.php"
    
    if [ -f "$wpconfig" ]; then
        db=$(grep -oP "DB_NAME['\"]\s*,\s*['\"]\K[^'\"]+" "$wpconfig" | head -1)
        user=$(grep -oP "DB_USER['\"]\s*,\s*['\"]\K[^'\"]+" "$wpconfig" | head -1)
        pass=$(grep -oP "DB_PASSWORD['\"]\s*,\s*['\"]\K[^'\"]+" "$wpconfig" | head -1)
        
        if [ ! -z "$db" ] && [ ! -z "$user" ]; then
            echo -e "\n=== $site ==="
            echo " DB: $db"
            
            # Try common prefixes
            for pref in "wpif_" "wp_" ""; do
                count=$(mysql -u"$user" -p"$pass" "$db" -e "
                    SELECT COUNT(*) FROM ${pref}posts 
                    WHERE post_type = 'shop_order' 
                    AND post_date >= DATE_SUB(NOW(), INTERVAL 30 DAY);
                " 2>/dev/null | tail -1)
                
                if [ "$count" != "0" ] && [ ! -z "$count" ]; then
                    echo " Prefix used: ${pref:-unknown}"
                    echo " ✅ Recent orders (30 days): $count"
                    break
                fi
            done
            
            if [ -z "$count" ] || [ "$count" = "0" ]; then
                echo " Recent orders (30 days): 0"
            fi
        fi
    fi
done

echo -e "\n=== Scan completed ==="