# models.py
import sqlite3

DB_PATH = r"Z:/pos_hipermarket/db/beta_sb_pos_sqlite.db"

def verify_user(username, password_hash):
    conn = sqlite3.connect(DB_PATH)
    conn.row_factory = sqlite3.Row
    cursor = conn.cursor()
    cursor.execute("SELECT id, nama, password FROM per_employee WHERE nama = ?", (username,))
    user = cursor.fetchone()
    conn.close()
    return user

def load_customer_list():
    conn = sqlite3.connect(DB_PATH)
    cursor = conn.cursor()
    cursor.execute("SELECT id, nama, alamat_1, tlp_1 FROM per_customers")
    rows = cursor.fetchall()
    conn.close()
    return [{"id": row[0], "nama": row[1], "alamat_1": row[2], "tlp_1": row[3]} for row in rows]