Diagnostik Hotel POS

Halaman ini memeriksa kondisi sistem. Jalankan setiap kali ada masalah setelah update.

1. Lingkungan Server

ItemNilaiStatus
Versi PHP8.3.35OK
Ekstensi pdo_mysqlAktifOK
Ekstensi zip (untuk export Excel)AktifOK
Ekstensi curl (untuk Firebase)AktifOK

2. Koneksi Database

BERHASIL — API terhubung ke MySQL.

3. Tabel Database

TabelStatus
usersADA
login_sessionsADA
settingsADA
categoriesADA
subcategoriesADA
room_statusADA
room_logsADA
transactionsADA
cash_transfersADA
room_typesADA
room_transfersADA
store_categoriesADA
store_subcategoriesADA
store_employeesADA
store_stock_gudangADA
store_stock_etalaseADA
store_stock_movesADA
store_transactionsADA
store_bonsADA
store_bon_paymentsADA
admin_device_tokensADA
backup_logsADA
withdrawalsADA
invoice_countersADA
store_stock_logsADA
store_cash_transfersADA
balance_adjustmentsADA
activity_logsADA
room_billsADA
room_bill_itemsADA
room_bill_paymentsADA
payrollsADA
invoice_groupsADA
hotel_group_membersADA
damage_reportsADA
damage_itemsADA

4. Kolom dari Migration v4 / v5 / v6

TabelKolomMigrationStatus
transactionsinvoice_numberv5ADA
role_permissionspermission_keyv30ADA
laundry_entriesunit_pricev31ADA
store_transactionsinvoice_numberv5ADA
categoriessort_orderv5ADA
subcategoriessort_orderv5ADA
store_categoriessort_orderv5ADA
store_subcategoriessort_orderv5ADA
store_transactionscart_idv50ADA
store_transactionsis_bonv6ADA
store_transactionsemployee_idv6ADA
store_bonsorigin_transaction_idv6ADA
store_transactionscash_sourcev8ADA
transactionsdaysv9ADA
store_categoriesis_bon_paymentv10ADA
usersbase_salaryv12ADA
usersphonev12ADA
categoriesis_kasbonv13ADA
withdrawalsewallet_amountv14ADA
backup_logsbackup_typev15ADA
usersdeduct_store_bonv16ADA
payrollsstore_bonv16ADA
transactionsguest_namev17ADA
room_statusbill_idv22ADA
room_statuscheckout_duev23ADA
room_statushalf_day_creditv27ADA
room_billscheckout_duev23ADA
login_sessionslast_seenv19ADA
room_typeshalf_day_pricev20ADA
transactionsis_half_dayv20ADA
transactionsstay_fromv45ADA
transactionsstay_untilv45ADA
transactionsstay_nightsv45ADA
transactionsearly_checkin_amountv46ADA
withdrawalsewallet_qris_amountv47ADA
withdrawalsewallet_transfer_amountv47ADA
transactionsextrabed_totalv48ADA
room_bill_itemsextrabed_partv48ADA
usersboleh_roomboyv53ADA
login_sessionsmodev53ADA

Semua migration sudah lengkap.

5. Isi Data

DataJumlahCatatan
Akun pengguna6Minimal 1 (admin)
Kategori Hotel10Diisi lewat Master Data
Subkategori Hotel47Diisi lewat Master Data
Transaksi Hotel548-
Kategori Toko7-
Subkategori Toko41-
Transaksi Toko381-
Karyawan Toko5Untuk fitur Bon
Data Bon84-
Baris pengaturan61Minimal 10 baris

6. Pengaturan Sistem

KunciNilaiStatus
payment_tunai_active1ADA
payment_transfer_active0ADA
payment_qris_active1ADA
multi_login_enabled0ADA
letterhead_titleHOTEL TELAGA BIRUADA
app_nameTelaga Biru Cash FlowADA
print_bluetooth_enabled1ADA
fcm_enabled1ADA
rtdb_enabled1ADA
store_bon_payment_category_id1ADA
app_timezoneAsia/MakassarADA
app_version5.3.3ADA
show_balance_cards_to_staff0ADA
cron_secrethaninajadehADA
backup_auto_enabled1ADA
guest_name_enabled1ADA
guest_name_required1ADA
stay_rules_enabled1ADA
checkout_time12:00ADA
checkout_warning_minutes120ADA
checkout_alarm_enabled1ADA

7. Nomor Transaksi

ModulNomor Berikutnya
bill00082
hotel00476
store00396

8. Ringkasan

Semua pemeriksaan lolos. Sistem siap digunakan.

Keamanan: Setelah semua beres, disarankan hapus file api/diagnostic.php ini dari server.