// ARS Service Management — Sample data derived from the customer list // All fields mirror the Excel structure so the prototype shows realistic state. const ARS_REGISTRATIONS = [ { id: "ARSQ-BKK-20241010-0001", registerDate: "2024-10-10", status: "active", // active | pending_approval | draft | expired poNo: "PO 1110486264", poDate: "2024-10-08", customer: { company: "Royal Thai Mint", address: "13/1 Khlong Nueng Subdistrict, Khlong Luang District", province: "Pathum Thani", zip: "12120", contact: "Mr. Thanaphon Pattanasophon", tel1: "02-273-0899", email1: "thanaphonpa@treasury.go.th", }, product: { brand: "QNAP", model: "TS-432PXU-RP-2G", serial: "QNYQ902603U" }, warranty: { package: "QNP-TS-432PXU5YBKK", start: "2024-10-10", end: "2029-10-10", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Pathum Thani", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2024-10-11 14:22", certificateIssued: true, }, { id: "ARSQ-BKK-20241010-0002", registerDate: "2024-10-10", status: "active", poNo: "PO 1110486264", poDate: "2024-10-08", customer: { company: "Bureau of Monetary Management", address: "13/1 Khlong Nueng Subdistrict, Khlong Luang District", province: "Pathum Thani", zip: "12120", contact: "Mr. Thanaphon Pattanasophon", tel1: "02-273-0899", email1: "thanaphonpa@treasury.go.th", }, product: { brand: "QNAP", model: "TS-1273AU-RP-8G", serial: "QPENX00683M" }, warranty: { package: "QNP-TS-1273AU5YBKK", start: "2024-10-10", end: "2029-10-10", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Pathum Thani", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2024-10-11 14:22", certificateIssued: true, }, { id: "ARSQ-BKK-20241010-0006", registerDate: "2024-10-10", status: "active", poNo: "PO 1110486264", poDate: "2024-10-08", customer: { company: "Bureau of Monetary Management", address: "13/1 Khlong Nueng Subdistrict, Khlong Luang District", province: "Pathum Thani", zip: "12120", contact: "Mr. Thanaphon Pattanasophon", tel1: "02-273-0899", email1: "thanaphonpa@treasury.go.th", }, product: { brand: "QNAP", model: "TS-1273AU-RP-8G", serial: "QN43E00709B" }, warranty: { package: "QNP-TS-1273AU5YBKK", start: "2024-10-10", end: "2029-10-10", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Pathum Thani", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2024-10-11 14:22", certificateIssued: true, }, { id: "ARSQ-NRT-20250114-0001", registerDate: "2025-01-14", status: "active", poNo: "PO 1110507842", poDate: "2025-01-10", customer: { company: "Sriphat Medical Center, Faculty of Medicine CMU", address: "110/392 Inthawarorot Rd., Sriphum, Muang", province: "Chiang Mai", zip: "50200", contact: "Arisara Khumtun", tel1: "086-656-8424", email1: "Arisara.k@cmu.ac.th", }, product: { brand: "QNAP", model: "TS-h886-D1602-8G", serial: "QNELK046454" }, warranty: { package: "QNP-TS-h886NRT", start: "2025-01-14", end: "2028-01-14", years: 3, zone: "Upcountry (NRT)" }, installationLocation: "Chiang Mai", remark: "Collected", payment: "Paid", createdBy: "Tee B. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2025-01-15 09:40", certificateIssued: true, }, { id: "ARSQ-BKK-20250206-0001", registerDate: "2025-02-06", status: "active", poNo: "PO 1110511494", poDate: "2025-02-04", customer: { company: "THAICOM Public Company Limited", address: "349 SJ Infinite 1 Business Complex, 28–29 Fl., Vibhavadi Rangsit Rd., Chompol, Chatuchak", province: "Bangkok", zip: "10900", contact: "K. Natakorn Tippayaratsoontorn", tel1: "02-591-0736-49", email1: "softwareadmin@thaicom.net", }, product: { brand: "QNAP", model: "TS-832PXU-RP-4G", serial: "QPWSG07480C" }, warranty: { package: "QNP-TS-832PXU5YBKK", start: "2025-02-06", end: "2030-02-06", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2025-02-07 11:08", certificateIssued: true, }, { id: "ARSQ-EST-20250408-0001", registerDate: "2025-04-28", status: "active", poNo: "PO 1110518235", poDate: "2025-04-14", customer: { company: "Innoviz Technologies Ltd.", address: "c/o Fabrinet 890/60 Moo 3, Khao Khan Song, Si Racha", province: "Chon Buri", zip: "20110", contact: "Amit Weinstein, Chewaree Phonyotha", tel1: "080-998-9226", email1: "amit.weinstein@innoviz-tech.com", email2: "chewareep@fabrinet.co.th", }, product: { brand: "QNAP", model: "TS-1273AU-RP-8G", serial: "QR3GE076946" }, warranty: { package: "QNP-TS-1273AU3YUPC", start: "2025-04-14", end: "2028-04-13", years: 3, zone: "Upcountry (EST)" }, installationLocation: "Chon Buri", remark: "Collected", payment: "Paid", createdBy: "Tee B. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2025-05-01 16:00", certificateIssued: true, }, { id: "ARSQ-BKK-20250624-0001", registerDate: "2025-06-23", status: "active", poNo: "PO 1110525296", poDate: "2025-06-16", customer: { company: "Frasers Property (Thailand) PCL", address: "944 Mitrtown Office Tower, 20F, Rama 4 Rd., Wangmai", province: "Bangkok", zip: "10330", contact: "Ukrit Yankomut", tel1: "065-942-9426", email1: "ukrit.ya@lighting.co.th", }, product: { brand: "QNAP", model: "TS-1273AU-RP", serial: "QN3NG076126" }, warranty: { package: "QNP-TS-1273AU5YBKK", start: "2025-06-16", end: "2030-06-15", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2025-06-25 10:11", certificateIssued: true, }, { id: "ARSQ-BKK-20250922-0002", registerDate: "2025-09-22", status: "active", poNo: "PO 1110539693", poDate: "2025-09-18", customer: { company: "Food Innova Trading and Services Co., Ltd.", address: "88/36 T.T.N. Avenue, Nanglinchee Rd., Chongnonsee, Yannawa", province: "Bangkok", zip: "10120", contact: "K. Dulyawat Euareechaisakul", tel1: "096-957-0097", email1: "dulyawat.t@foodinnova.co.th", }, product: { brand: "QNAP", model: "TS-464U-RP-8G", serial: "QFEPS00837S" }, warranty: { package: "QNP-TS-464U-R3YBKK", start: "2025-10-01", end: "2028-09-30", years: 3, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2025-09-23 11:50", certificateIssued: true, }, { id: "ARSQ-BKK-20251029-0001", registerDate: "2025-10-29", status: "active", poNo: "PO 1110531797", poDate: "2025-09-30", customer: { company: "TRIPLE V BROADCAST CO., LTD", address: "Building 17, Vibhavadi Rangsit Rd., Chomphon, Chatuchak", province: "Bangkok", zip: "10900", contact: "Mr. Sompop Ngamsa-ard", tel1: "02-127-1199 #2449", email1: "sompop.ng@thairath.tv", }, product: { brand: "QNAP", model: "QNP-QDA-SA-1PCS", serial: "Q19AI02808" }, warranty: { package: "QNP-QDA-SA-1PCS", start: "2025-10-01", end: "2030-09-30", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Collected — 6Gbps SAS to SATA drive adapter ×1", payment: "Paid", createdBy: "Tee B. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2025-10-30 09:15", certificateIssued: true, }, // Pending approval — submitted by sales, waiting on manager { id: "ARSQ-BKK-20260512-0001", registerDate: "2026-05-12", status: "pending_approval", poNo: "PO 1110551208", poDate: "2026-05-08", customer: { company: "Bangchak Corporation PCL", address: "2098 M-Tower, 8F, Sukhumvit Rd., Phra Khanong, Phra Khanong", province: "Bangkok", zip: "10260", contact: "Khun Praphan Wongsiri", tel1: "02-335-4555", email1: "praphan.w@bangchak.co.th", }, product: { brand: "QNAP", model: "TS-h1290FX-7232P-64G", serial: "QHX8200131A" }, warranty: { package: "QNP-TS-h1290FX5YBKK", start: "2026-05-12", end: "2031-05-11", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Awaiting approval", payment: "Pending", createdBy: "Pim S. (Sales)", submittedAt: "2026-05-12 17:43", certificateIssued: false, }, { id: "ARSQ-BKK-20260514-0001", registerDate: "2026-05-14", status: "pending_approval", poNo: "PO 1110551844", poDate: "2026-05-11", customer: { company: "SCB X Public Company Limited", address: "9 Ratchadapisek Rd., Chatuchak, Chatuchak", province: "Bangkok", zip: "10900", contact: "Khun Athit Promkaew", tel1: "02-128-2000", email1: "athit.p@scbx.com", }, product: { brand: "QNAP", model: "TS-873AeU-RP-4G", serial: "Q321F087622" }, warranty: { package: "QNP-TS-873AeU3YBKK", start: "2026-05-14", end: "2029-05-13", years: 3, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Express install requested", payment: "Pending", createdBy: "Tee B. (Sales)", submittedAt: "2026-05-14 11:08", certificateIssued: false, }, // Draft — sales started but hasn't submitted yet { id: "ARSQ-BKK-20260518-DRAFT", registerDate: "2026-05-18", status: "draft", poNo: "PO 1110552911", poDate: "2026-05-15", customer: { company: "Central Pattana PCL", address: "999/9 Rama I Rd., Pathumwan", province: "Bangkok", zip: "10330", contact: "Khun Suchada T.", tel1: "02-667-5555", email1: "suchada.t@centralpattana.co.th", }, product: { brand: "QNAP", model: "TS-1273AU-RP-8G", serial: "—" }, warranty: { package: "—", start: "—", end: "—", years: 0, zone: "—" }, installationLocation: "Bangkok", remark: "Awaiting serial attachment", payment: "Pending", createdBy: "Pim S. (Sales)", certificateIssued: false, }, // Expiring soon { id: "ARSQ-BKK-20241202-0001", registerDate: "2024-12-02", status: "active", poNo: "PO 1110503303", poDate: "2024-11-28", customer: { company: "NS-OG Energy Solutions (Thailand) Ltd.", address: "909 Ample Tower 20F, Debaratna Rd., North-Bangna, Bangna", province: "Bangkok", zip: "10260", contact: "Sunisa Ruksasook", tel1: "02-021-3782", email1: "itnset@nset.co.th", }, product: { brand: "QNAP", model: "TS-464U-RP-8G", serial: "Q245B00897G" }, warranty: { package: "QNP-TS-464U-RP-8G", start: "2025-03-14", end: "2030-03-13", years: 5, zone: "BKK and Metropolitan" }, installationLocation: "Bangkok", remark: "Collected", payment: "Paid", createdBy: "Pim S. (Sales)", approvedBy: "K. Wattana M.", approvedAt: "2024-12-03 09:00", certificateIssued: true, }, ]; // PO lookup — what the system fetches when sales "searches PO" const PO_LOOKUP = { "PO 1110551208": { customerCode: "1100098841", customerNameTh: "บางจาก คอร์ปอเรชั่น", customerNameEn: "Bangchak Corporation PCL", poDate: "2026-05-08", items: [ { article: "QNP-TS-h1290FX-7232P-64G", description: "12-Bay Xeon-D 1.9GHz 64GB DDR4 NAS", serial: "QHX8200131A" }, { article: "QNP-RAIL-B02", description: "Rack Slide Rail Kit", serial: "Q254C02401" }, { article: "QNP-CABSAS20M-8644", description: "Mini SAS cable (SFF-8644), 2.0m", serial: "QNGUE02899" }, ], }, "PO 1110551844": { customerCode: "1100100221", customerNameTh: "เอสซีบี เอกซ์", customerNameEn: "SCB X Public Company Limited", poDate: "2026-05-11", items: [ { article: "QNP-TS-873AeU-RP-4G", description: "8-Bay AnnapurnaLabs 4-core 1.7GHz 4GB", serial: "Q321F087622" }, { article: "QNP-TS-873AeU-RP-4G", description: "8-Bay AnnapurnaLabs 4-core 1.7GHz 4GB", serial: "Q321F087618" }, ], }, "PO 1110552911": { customerCode: "1100100488", customerNameTh: "เซ็นทรัลพัฒนา", customerNameEn: "Central Pattana PCL", poDate: "2026-05-15", items: [ { article: "QNP-TS-1273AU-RP-8G", description: "12-Bay Ryzen V1500B 8GB DDR4 NAS", serial: "QYE6F076901" }, { article: "QNP-TS-1273AU-RP-8G", description: "12-Bay Ryzen V1500B 8GB DDR4 NAS", serial: "QYE6F076902" }, { article: "QNP-QXP-820S-B3408", description: "2 port miniSAS, PCIe x8 SAS JBOD", serial: "QPT4H10605C" }, ], }, }; // Master data: warranty packages const PACKAGES = [ { code: "QNP-TS-432PXU5YBKK", model: "TS-432PXU-RP-2G", years: 5, zone: "BKK and Metropolitan", price: 32000 }, { code: "QNP-TS-1273AU5YBKK", model: "TS-1273AU-RP-8G", years: 5, zone: "BKK and Metropolitan", price: 78000 }, { code: "QNP-TS-1273AU3YUPC", model: "TS-1273AU-RP-8G", years: 3, zone: "Upcountry", price: 56000 }, { code: "QNP-TS-h886NRT", model: "TS-h886-D1602-8G", years: 3, zone: "Upcountry (NRT)", price: 64000 }, { code: "QNP-TS-832PXU5YBKK", model: "TS-832PXU-RP-4G", years: 5, zone: "BKK and Metropolitan", price: 48000 }, { code: "QNP-TS-832PXU3YBKK", model: "TS-832PXU-RP-4G", years: 3, zone: "BKK and Metropolitan", price: 28000 }, { code: "QNP-TS-464U-R3YBKK", model: "TS-464U-RP-8G", years: 3, zone: "BKK and Metropolitan", price: 24000 }, { code: "QNP-TS-464U-RP-8G", model: "TS-464U-RP-8G", years: 5, zone: "BKK and Metropolitan", price: 38000 }, { code: "QNP-TS-873AeU3YBKK", model: "TS-873AeU-RP-4G", years: 3, zone: "BKK and Metropolitan", price: 30000 }, { code: "QNP-TS-h1290FX5YBKK", model: "TS-h1290FX-7232P-64G", years: 5, zone: "BKK and Metropolitan", price: 142000 }, { code: "QNP-QDA-SA-1PCS", model: "QDA-SA Adapter", years: 5, zone: "BKK and Metropolitan", price: 1200 }, ]; const BRANDS = [ { name: "QNAP", category: "NAS / Storage", activePackages: 11 }, { name: "Synology", category: "NAS / Storage", activePackages: 0 }, { name: "Veeam", category: "Backup", activePackages: 0 }, ]; const USERS = [ { id: "u1", name: "K. Wattana M.", email: "wattana.m@journey-tech.co.th", role: "Admin", group: "Executive", lastLogin: "2026-05-20 18:02" }, { id: "u2", name: "K. Nattaya P.", email: "nattaya.p@journey-tech.co.th", role: "Manager", group: "Service Manager", lastLogin: "2026-05-20 17:38" }, { id: "u3", name: "Pim S.", email: "pim.s@journey-tech.co.th", role: "User", group: "Sales BKK", lastLogin: "2026-05-21 09:14" }, { id: "u4", name: "Tee B.", email: "tee.b@journey-tech.co.th", role: "User", group: "Sales Upcountry", lastLogin: "2026-05-21 08:51" }, { id: "u5", name: "Aom P.", email: "aom.p@journey-tech.co.th", role: "User", group: "Sales BKK", lastLogin: "2026-05-19 16:22" }, { id: "u6", name: "Joe K.", email: "joe.k@journey-tech.co.th", role: "Viewer", group: "Finance", lastLogin: "2026-05-18 11:00" }, ]; const GROUPS = [ { name: "Executive", users: 1, perms: ["view_all", "approve", "manage_users", "manage_master", "edit_all"] }, { name: "Service Manager", users: 1, perms: ["view_all", "approve", "manage_master", "edit_all"] }, { name: "Sales BKK", users: 2, perms: ["view_own", "create", "edit_own", "attach_po"] }, { name: "Sales Upcountry", users: 1, perms: ["view_own", "create", "edit_own", "attach_po"] }, { name: "Finance", users: 1, perms: ["view_all"] }, ]; const ACTIVITY = [ { ts: "2026-05-21 09:14", actor: "Pim S.", action: "เริ่มต้นการลงทะเบียน ARS", target: "ARSQ-BKK-20260518-DRAFT", kind: "create" }, { ts: "2026-05-20 17:43", actor: "Pim S.", action: "ส่งคำขอ approve", target: "ARSQ-BKK-20260512-0001", kind: "submit" }, { ts: "2026-05-20 11:08", actor: "Tee B.", action: "Attach PO และระบุ serial", target: "ARSQ-BKK-20260514-0001", kind: "attach" }, { ts: "2026-05-19 16:00", actor: "K. Wattana M.", action: "อนุมัติและออก Certificate", target: "ARSQ-BKK-20250922-0002", kind: "approve" }, { ts: "2026-05-19 10:30", actor: "K. Nattaya P.", action: "แก้ไข Master Data — เพิ่ม package", target: "QNP-TS-h1290FX5YBKK", kind: "master" }, { ts: "2026-05-18 14:11", actor: "K. Wattana M.", action: "สร้างกลุ่มผู้ใช้ใหม่", target: "Sales Upcountry", kind: "user" }, ]; window.ARS_DATA = { ARS_REGISTRATIONS, PO_LOOKUP, PACKAGES, BRANDS, USERS, GROUPS, ACTIVITY };