#!/usr/bin/env python3
from pathlib import Path
import sys
ROOT = Path(r"c:\laragon\www\light-otantik-nux")
sys.path.insert(0, str(ROOT / "scripts"))
from deploy_remote import connect, sudo  # noqa: E402

script = r'''
echo === APACHE ===
tail -n 100 /var/log/apache2/error.log
echo === PHP FPM LOG ===
ls /var/log/php* /var/log/apache2/ 2>/dev/null
echo === NUX PAGE ERROR ===
ls -lt /var/www/phpnuxbill/system/uploads /var/www/phpnuxbill/pages 2>/dev/null | head
find /var/www/phpnuxbill -name "*error*" -mtime -1 2>/dev/null | head
echo === LAST PAYMENTS ===
python3 - <<'PY'
from pathlib import Path
import subprocess
env={}
for line in Path("/root/woyla.env").read_text().splitlines():
    if "=" in line:
        k,v=line.split("=",1); env[k]=v
sql="SELECT id, username, plan_name, status, payment_channel, created_date, paid_date FROM tbl_payment_gateway ORDER BY id DESC LIMIT 10"
print(subprocess.check_output(["mysql","-N","-u","nuxbill","-p"+env["DB_PASS"],"phpnuxbill","-e",sql], text=True, stderr=subprocess.STDOUT))
PY
echo === WAIT TPL ===
ls -l /var/www/phpnuxbill/ui/ui/portal/
'''

client = connect()
sftp = client.open_sftp()
with sftp.file("/tmp/dbg_portal.sh", "w") as f:
    f.write(script.replace("\r\n", "\n"))
sftp.close()
code, out = sudo(client, "bash /tmp/dbg_portal.sh", timeout=30)
print(out)
print("CODE", code)
client.close()