018 - FnB pickup time settings

• Tanggal: 2026-08-11
• DB: mpcdb
• Ringkas: Config range/interval pick up FnB di store_settings; simpan waktu ambil di transactions.fnb_pickup_time.

ALTER (jalankan di DB server)

ALTER TABLE store_settings
  ADD COLUMN IF NOT EXISTS fnb_pickup_before_minutes int NOT NULL DEFAULT 30,
  ADD COLUMN IF NOT EXISTS fnb_pickup_interval_minutes int NOT NULL DEFAULT 15;

ALTER TABLE transactions
  ADD COLUMN IF NOT EXISTS fnb_pickup_time timestamptz NULL;

Rollback (opsional tapi disarankan)

ALTER TABLE transactions DROP COLUMN IF EXISTS fnb_pickup_time;
ALTER TABLE store_settings
  DROP COLUMN IF EXISTS fnb_pickup_before_minutes,
  DROP COLUMN IF EXISTS fnb_pickup_interval_minutes;

Catatan

• Default: pickup dari 30 menit sebelum start booking sampai end booking, interval 15 menit.
• Dipakai mpc-be (GET /settings/fnb-pickup, validasi POST /orders) + admin Settings form.
• mpc-be-pos / POS belum menampilkan field ini di v1.