#!/bin/bash
cd ~/fan.deliva.ma/fantastic-catalog

while true; do
    PENDING=$(sqlite3 catalog.db "SELECT COUNT(*) FROM products p LEFT JOIN download_state d ON d.product_id = p.id WHERE p.image IS NOT NULL AND p.image != '' AND d.product_id IS NULL")
    OK=$(sqlite3 catalog.db "SELECT COUNT(*) FROM download_state WHERE status = 'ok'" 2>/dev/null || echo 0)

    if [ "$PENDING" -eq 0 ]; then
        echo "[$(date +%H:%M:%S)] ✅ TERMINÉ - $OK images téléchargées" >> /tmp/dl_status.log
        break
    fi

    echo "[$(date +%H:%M:%S)] ▶ Lot : $PENDING restants (OK: $OK)" >> /tmp/dl_status.log
    php download_images.php --resume --limit=2000 >> /tmp/dl_php.log 2>&1
    sleep 5
done