#!/bin/bash
# WEVIA Daily Report — cron 0 6 * * *
LOG="/var/log/wevia-daily-report.log"
REPORT="/var/www/html/api/wevia-daily-report.json"

DISK=$(df -h / | awk "NR==2{print \$5}")
RAM=$(free -h | grep Mem | awk "{print \$3\"/\"\$2}")
DOCKER=$(docker ps -q 2>/dev/null | wc -l)
OLLAMA=$(curl -sf http://127.0.0.1:11434/api/tags 2>/dev/null | python3 -c "import json,sys;print(len(json.load(sys.stdin).get(\"models\",[])))" 2>/dev/null)
CRONS=$(crontab -l 2>/dev/null | grep -c .)
APIS=$(ls /var/www/html/api/wevia-*.php 2>/dev/null | wc -l)
WIKI=$(ls /opt/weval-l99/wiki/*.json 2>/dev/null | wc -l)
BLADE=$(cat /var/www/html/api/wevia-blade-status.json 2>/dev/null | python3 -c "import json,sys;d=json.load(sys.stdin);print(d.get(\"status\",\"?\"))" 2>/dev/null)
BLADE_CPU=$(cat /var/www/html/api/wevia-blade-status.json 2>/dev/null | python3 -c "import json,sys;d=json.load(sys.stdin);print(d.get(\"cpu\",\"?\"))" 2>/dev/null)
HCPs=$(PGPASSWORD=admin123 psql -h 10.1.0.3 -U admin -d adx_system -t -c "SELECT count(*) FROM ethica.medecins_validated" 2>/dev/null | tr -d " ")
GIT=$(cd /var/www/html && git log --oneline -1 2>/dev/null)
UPTIME=$(uptime -p)

cat > $REPORT << EOJSON
{
  "date": "$(date +%Y-%m-%d)",
  "s204": {"disk":"$DISK","ram":"$RAM","docker":$DOCKER,"ollama":$OLLAMA,"uptime":"$UPTIME"},
  "blade": {"status":"$BLADE","cpu":"$BLADE_CPU"},
  "data": {"apis":$APIS,"crons":$CRONS,"wiki":$WIKI,"hcps":"$HCPs"},
  "git": "$GIT",
  "cost": "0EUR"
}
EOJSON

echo "$(date +%Y-%m-%d) Report generated" >> $LOG