import json
import os
from http.server import SimpleHTTPRequestHandler, ThreadingHTTPServer
from urllib.parse import urlparse
import database as db

BASE_DIR = os.path.dirname(os.path.abspath(__file__))
PUBLIC_DIR = os.path.join(BASE_DIR, "public")


class PosApiHandler(SimpleHTTPRequestHandler):
    def __init__(self, *args, **kwargs):
        super().__init__(*args, directory=PUBLIC_DIR, **kwargs)

    def _send_json(self, code, payload):
        body = json.dumps(payload).encode("utf-8")
        self.send_response(code)
        self.send_header("Content-Type", "application/json; charset=utf-8")
        self.send_header("Content-Length", str(len(body)))
        self.send_header("Access-Control-Allow-Origin", "*")
        self.send_header("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS")
        self.send_header("Access-Control-Allow-Headers", "Content-Type")
        self.end_headers()
        self.wfile.write(body)

    def _read_json(self):
        length = int(self.headers.get("Content-Length", "0"))
        if length <= 0:
            return {}
        return json.loads(self.rfile.read(length).decode("utf-8"))

    def do_OPTIONS(self):
        self._send_json(200, {"ok": True})

    def do_GET(self):
        path = urlparse(self.path).path
        if path == "/api/backup/db":
            with open(db.DB_PATH, "rb") as f:
                raw = f.read()
            self.send_response(200)
            self.send_header("Content-Type", "application/octet-stream")
            self.send_header("Content-Disposition", "attachment; filename=birrah_pos_backup.db")
            self.send_header("Content-Length", str(len(raw)))
            self.end_headers()
            self.wfile.write(raw)
            return
        if path == "/api/health":
            return self._send_json(200, {"status": "ok", "database": "SQLite3", "db_file": os.path.basename(db.DB_PATH)})
        if path == "/api/state":
            return self._send_json(200, db.export_full_state())
        if path == "/api/products":
            return self._send_json(200, db.export_full_state()["products"])
        if path == "/api/contacts":
            return self._send_json(200, db.export_full_state()["customers"])
        if path == "/api/users":
            return self._send_json(200, db.export_full_state()["staff"])
        if path == "/api/invoices":
            return self._send_json(200, db.export_full_state()["invoices"])
        if path == "/api/bills":
            return self._send_json(200, db.export_full_state()["bills"])
        if path == "/api/quotations":
            return self._send_json(200, db.export_full_state()["draftQuotes"])
        if path == "/api/template":
            return self._send_json(200, db.export_full_state()["standardTemplate"])
        if path.startswith("/api/reports/customer/"):
            cid = path.split("/")[-1]
            rep = db.get_customer_report(cid)
            return self._send_json(200 if rep else 404, rep or {"error": "Customer not found"})
        if path == "/":
            self.path = "/index.html"
        return super().do_GET()

    def do_POST(self):
        path = urlparse(self.path).path
        if path == "/api/restore/db":
            length = int(self.headers.get("Content-Length", "0"))
            raw = self.rfile.read(length)
            if not raw.startswith(b"SQLite format 3"):
                return self._send_json(400, {"error": "Invalid SQLite database file"})
            with open(db.DB_PATH, "wb") as f:
                f.write(raw)
            return self._send_json(200, {"ok": True, "bytes": len(raw)})
        data = self._read_json()
        try:
            if path == "/api/sync":
                return self._send_json(200, db.sync_full_state(data))
            if path == "/api/products":
                return self._send_json(201, db.create_product(data))
            if path == "/api/contacts":
                return self._send_json(201, db.create_contact(data))
            if path == "/api/users":
                return self._send_json(201, db.create_user(data))
            if path == "/api/invoices":
                return self._send_json(201, db.create_invoice_tx(data))
            return self._send_json(404, {"error": "Endpoint not found"})
        except Exception as exc:
            return self._send_json(400, {"error": str(exc)})

    def do_PUT(self):
        path = urlparse(self.path).path
        if path == "/api/restore/db":
            length = int(self.headers.get("Content-Length", "0"))
            raw = self.rfile.read(length)
            if not raw.startswith(b"SQLite format 3"):
                return self._send_json(400, {"error": "Invalid SQLite database file"})
            with open(db.DB_PATH, "wb") as f:
                f.write(raw)
            return self._send_json(200, {"ok": True, "bytes": len(raw)})
        data = self._read_json()
        try:
            if path.startswith("/api/products/"):
                out = db.update_product(path.split("/")[-1], data)
                return self._send_json(200 if out else 404, out or {"error": "Not found"})
            if path.startswith("/api/contacts/"):
                out = db.update_contact(path.split("/")[-1], data)
                return self._send_json(200 if out else 404, out or {"error": "Not found"})
            if path.startswith("/api/users/"):
                out = db.update_user(path.split("/")[-1], data)
                return self._send_json(200 if out else 404, out or {"error": "Not found"})
            if path == "/api/template":
                conn = db.get_conn()
                conn.execute("INSERT OR REPLACE INTO standard_template (id, template_json, updated_at) VALUES (1, ?, datetime('now'))", (json.dumps(data),))
                conn.commit()
                conn.close()
                return self._send_json(200, {"ok": True, "template": data})
            return self._send_json(404, {"error": "Endpoint not found"})
        except Exception as exc:
            return self._send_json(400, {"error": str(exc)})

    def do_DELETE(self):
        path = urlparse(self.path).path
        if path.startswith("/api/products/"):
            ok = db.delete_product(path.split("/")[-1])
            return self._send_json(200 if ok else 404, {"deleted": ok})
        if path.startswith("/api/contacts/"):
            ok = db.delete_contact(path.split("/")[-1])
            return self._send_json(200 if ok else 404, {"deleted": ok})
        if path.startswith("/api/users/"):
            ok = db.delete_user(path.split("/")[-1])
            return self._send_json(200 if ok else 404, {"deleted": ok})
        return self._send_json(404, {"error": "Endpoint not found"})

    def log_message(self, format, *args):
        pass


def run_server(port=8080):
    db.init_db()
    server = ThreadingHTTPServer(("0.0.0.0", port), PosApiHandler)
    print(f"Birrah Universal AI-POS ERP running at http://localhost:{port}")
    print(f"SQLite Database linked at: {db.DB_PATH}")
    server.serve_forever()


if __name__ == "__main__":
    run_server(int(os.environ.get("PORT", "8080")))
