Afiq Hamzah
8fe42c1d9f
- Replace hardcoded database names (online_arrahn, master_krk, kaunterpkb) with configurable values across the codebase - Rename tennant_master.php to tennant_database.php for clearer naming - Update config keys: 'database' → 'master_db', add 'kaunter_db' - Update env variables: TENNANT_MASTER_DB and TENNANT_KAUNTER_DB - Modify Helper.php to use dynamic database references in getOnlineArrahnConnection(), getActiveCawanganDbConnection(), and getInactiveCawanganDbConnection() methods - Update database JOIN queries in CustomerController and MarhunController to use config values instead of hardcoded database names - Simplify migration logic by removing redundant hardcoded database checks - Update debug messages in CawanganDebugConnections to show actual configured database name - Update bootstrap/app.php to load tennant_database config This change improves multi-environment flexibility and eliminates environment-specific hardcoded values, making the application more configurable for different deployment scenarios (KRK, KGMK, etc).
27 lines
717 B
PHP
27 lines
717 B
PHP
<?php
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
$all_active_db_keys = array_filter(array_keys(config('database.connections')), function ($connection) {
|
|
try {
|
|
DB::connection($connection)->getPdo();
|
|
return true;
|
|
} catch (\Throwable $th) {
|
|
return false;
|
|
}
|
|
});
|
|
|
|
$non_cawangan_database = ['lelong', config('tennant_database.master_db'), config('tennant_database.kaunter_db')];
|
|
|
|
$all_cawangan_db = array_filter($all_active_db_keys, function($db_key) use($non_cawangan_database){
|
|
$isNotCawangan = in_array(config('database.connections.' . $db_key . '.database'), $non_cawangan_database);
|
|
|
|
if($isNotCawangan){
|
|
return false;
|
|
}
|
|
|
|
return true;
|
|
});
|
|
|
|
return $all_cawangan_db;
|