APP_NAME="HMH Dashboard"
APP_ENV=local
APP_DEBUG=true
APP_URL=http://ddb.local
APP_TIMEZONE=Asia/Riyadh

USE_REVENUE_MV=0

# مهم: لا تستخدم 127.0.0.1 إلا لو Oracle Database موجود فعليًا على نفس سيرفر XAMPP.
# حسب tnsnames.ora المرفق، ORANJC_HP يستخدم HOST=10.10.12.10 و SID=ORANJC.
DB_NJCH_CONNECT_TYPE=sid
DB_NJCH_HOST=10.10.12.10
DB_NJCH_PORT=1521
DB_NJCH_SERVICE=ORANJC
DB_NJCH_SID=ORANJC
DB_NJCH_USER=WATANY
DB_NJCH_PASS=NjcPro2013
DB_NJCH_SCHEMA=WATANY

# اتركها كما هي مؤقتًا إذا لم تكن تستخدم JCKH/MNH الآن.
# بعد معرفة TNS الصحيح لكل مستشفى، اضبط HOST + SERVICE/SID بنفس الطريقة.
DB_JCKH_CONNECT_TYPE=sid
DB_JCKH_HOST=10.11.42.10
DB_JCKH_PORT=1521
DB_JCKH_SERVICE=orajck
DB_JCKH_SID=orajck
DB_JCKH_USER=WATANY
DB_JCKH_PASS=NjcPro2013
DB_JCKH_SCHEMA=WATANY

DB_MNH_CONNECT_TYPE=sid
DB_MNH_HOST=10.20.104.20
DB_MNH_PORT=1521
DB_MNH_SERVICE=oramnh
DB_MNH_SID=oramnh
DB_MNH_USER=WATANY
DB_MNH_PASS=NjcPro2013
DB_MNH_SCHEMA=WATANY

 

# Optional later testing only. Do not enable in production before Performance Layer.
 # EXECUTIVE_DASHBOARD_MODE=live
  
EXECUTIVE_DASHBOARD_MODE=summary
EXECUTIVE_SUMMARY_MAX_AGE_MINUTES=180
EXECUTIVE_REFRESH_TOKEN=hmh-refresh-2026-strong-token


EXECUTIVE_REFRESH_HOSPITALS=njch
EXECUTIVE_REFRESH_LOCK_MINUTES=30
EXECUTIVE_OPERATIONAL_DAY_START_HOUR=7


EXEC_ALERT_OCCUPANCY_WATCH=85
EXEC_ALERT_OCCUPANCY_CRITICAL=95
EXEC_ALERT_AVAILABLE_BEDS_WATCH=15
EXEC_ALERT_AVAILABLE_BEDS_CRITICAL=5
EXEC_ALERT_ER_WATCH=35
EXEC_ALERT_ER_CRITICAL=60
EXEC_ALERT_ADMISSION_DISCHARGE_GAP_WATCH=8
EXEC_ALERT_OR_GAP_WATCH=1
EXEC_ALERT_BLOCKED_BEDS_WATCH=10
EXEC_ALERT_LOW_OCCUPANCY_OPPORTUNITY=50
EXEC_ALERT_REVENUE_PACE_RATIO_WATCH=0.25
EXEC_ALERT_REVENUE_PACE_AFTER_HOUR=10
 
EXEC_ALERT_REVENUE_PACE_MIN_ELAPSED_HOURS=6
EXEC_ALERT_REVENUE_PACE_MIN_FLOW=50
EXEC_ALERT_REVENUE_PACE_TIME_WEIGHT_FLOOR=0.12 

EXEC_ACTION_REVIEW_QA_TOKEN=H1063_PRIVATE_TEST_TOKEN

EXEC_ACTION_GOVERNANCE_QA_TOKEN=H1066_PRIVATE_TEST_TOKEN



