// MUDEER OMAN ERP — Relational Repair Ticket Schema & WhatsApp Invoice Generator
// Built to handle bilingual (AR/EN) repair workflows, IMEI tracking, and QR receipts.

CREATE TABLE repair_tickets (
    ticket_id      VARCHAR(16) PRIMARY KEY,
    shop_branch_id INT NOT NULL,
    customer_name  VARCHAR(120) NOT NULL,
    device_model   VARCHAR(120) NOT NULL,
    imei_serial    VARCHAR(15) NOT NULL,
    fault_summary  TEXT NOT NULL,
    ticket_status  ENUM('diagnostics', 'in_repair', 'ready', 'delivered') DEFAULT 'diagnostics',
    total_omr      DECIMAL(10, 3) NOT NULL,
    qr_token       VARCHAR(64) UNIQUE NOT NULL,
    created_at     TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

function buildWhatsAppInvoiceLink(ticket, customerPhone) {
    const verificationUrl = `https://mudeeroman.com/verify/${encodeURIComponent(ticket.qr_token)}`;
    const message = [
        `*Mudeer Oman — Repair Invoice (${ticket.ticket_id})*`,
        `Device: ${ticket.device_model} (IMEI: ${ticket.imei_serial})`,
        `Status: ${ticket.ticket_status.toUpperCase()}`,
        `Total: ${ticket.total_omr} OMR`,
        `Digital QR Receipt: ${verificationUrl}`
    ].join('\n');

    return `https://wa.me/${customerPhone}?text=${encodeURIComponent(message)}`;
}