﻿MANIFEST OUTLET 01 - 2026-07-07 09:45
Database: dbsimfokop_outlet_01 | OUTLET_ID=1 | kode=MRT01
Token: spx_outlet_01_sk7v9m2pLqXwR3nT

=== URUTAN IMPORT SQL (instal baru) ===
  1. database/install_dbsimfokop_outlet_01.sql
  2. database/bootstrap_outlet_01.sql
  3. database/008_outlet_anggota_cache.sql
  4. database/010_kasir_master_tables.sql
  5. database/011_mart_items_backoff_columns.sql
  6. database/012_mart_penjualan_cash_fix.sql
  7. database/013_outlet_rbac_profile.sql
  8. database/014_outlet_piutang_rbac.sql
  9. database/018_upgrade_outlet_aplikasi.sql  (penjualan/pembelian tahunan, konsinyasi, RBAC, m_counter)
  (legacy) 015, 017 â€” sudah digabung di 018
  (opsional) patch_schema_compat.sql, 006_opening_balance_enum.sql

=== UPDATE instalasi lama ===
  powershell -ExecutionPolicy Bypass -File .\APPLY-OUTLET.ps1
  powershell -ExecutionPolicy Bypass -File .\APPLY-OPTION-A.ps1 -TargetDir "path\mart-01V45"

=== PERBAIKAN PEMBELIAN (versi ini) ===
  mart/backoff/purchase/purchase.php         form + modal cari barang/supplier
  mart/backoff/purchase/ajax_search_items.php  tanpa filter supplier
  mart/backoff/purchase/ajax_purchase_save.php insert tabel tahunan aman skema
  mart/includes/MartPembelianService.php     insert kolom dinamis
  mart/includes/MartPembelianTables.php      self-heal kolom source/created_by

  mart/pos/cash_register.php       POS (3 jalur: cash_fast / member / kupon)
  mart/includes/PosSaleRoute.php   Klasifikasi jalur simpan
  mart/includes/MartPenjualanTables.php  Tabel penjualan per tahun
  mart/includes/MartPembelianTables.php  Tabel pembelian per tahun
  mart/includes/MartPembelianService.php Import rekap pembelian CASH
  mart/backoff/purchase/purchase_rekap_import.php  Import Excel pembelian
  mart/includes/SimpananPostingService.php  Antrian SHU/Voucher ke webhost
  mart/includes/TranKasirMartService.php    Buku kas outlet
  mart/includes/KuponNomorService.php       Kupon undian lokal
  mart/sync/pull_master.php        Pull master anggota + saldo
  config.php, .env                 Bootstrap outlet

=== TABEL DATABASE LOKAL (inti) ===
  master_outlet, master_anggota, master_simpanan, users, settings
  mart_items, mart_kategori, mart_supplier, mart_penjualan_YYYY
  mart_penjualan_detail_YYYY, mart_penjualan_pembayaran_YYYY
  r_stok_YYYY, tran_kasir_mart, tran_shu, tran_voucher, mart_piutang
  mart_kupon_undian, mart_kupon_undian_nomor, shu_snapshot_lokal
  voucher_snapshot_lokal, mart_outlet_profile, app_config
  mart_sync_queue, simpanan_sync_queue (antrian webhost)

=== WEBHOST (wajib update sebelum go-live) ===
  deploy_new/deploy_webhost/ + SQL 026-032
  API: mart_get_anggota, mart_post_simpanan, mart_piutang_list, sync_pull_master
