import subprocess
from playwright.sync_api import sync_playwright
TOK=open('/tmp/ztok.txt').read().strip()
url="https://seaside.pacim.de/day-list.php?t="+TOK
def db(sql):
    code='require_once("/var/www/seaside.pacim.de/web/includes/config.inc.php");$d=new MysqliDb(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,MYSQL_DB);$d->rawQuery("'+sql+'");'
    subprocess.run(["php","-r",code],check=True,capture_output=True)
with sync_playwright() as p:
    b=p.chromium.launch(); pg=b.new_context(viewport={"width":440,"height":820}).new_page()
    pg.goto(url, wait_until="networkidle"); pg.wait_for_timeout(500)
    oid=pg.eval_on_selector('#dl-body tr:not(.st-in)','e=>e.getAttribute("data-id")')
    before=pg.eval_on_selector('#dl-body tr[data-id="%s"] .tcell'%oid,'e=>e?e.textContent:null')
    db("UPDATE pacim_booking SET booking_checkin='2026-06-27 09:30:00' WHERE booking_id="+oid)
    pg.evaluate("document.dispatchEvent(new Event('visibilitychange'))"); pg.wait_for_timeout(2200)
    after_cls=pg.eval_on_selector('#dl-body tr[data-id="%s"]'%oid,'e=>e.className')
    after_t=pg.eval_on_selector('#dl-body tr[data-id="%s"] .tcell'%oid,'e=>e?e.textContent:null')
    print("live external check-in id=%s: time %r -> %r | st-in=%s"%(oid,before,after_t,'st-in' in after_cls))
    db("UPDATE pacim_booking SET booking_checkin=NULL WHERE booking_id="+oid)
    b.close()