mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2026-05-27 18:00:32 -04:00
b0dddc22a3
* Bugfixes to get Migration working on MySQL Signed-off-by: objec <objecttothis@gmail.com> * MariaDB compatibility fixes - Drop foreign key constraints before making charset changes - Fix dropAllForeignKeyConstraints helper function. - Added `IF EXISTS` to DROP statements - Do not try to readd FK constraints for tables which were dropped. - MariaDB 11.8.x changes the default implicit collation to uca1400 which breaks the IndiaGST migration, et. al. Explicitly declare utf8_general_ci in affected migrations. Signed-off-by: objec <objecttothis@gmail.com> * Fix changes which break MySQL migrations - MySQL does not support IF EXISTS in foreign key constraints. Since the PHP is now handling dropping those constraints, these lines are redundant. Remove them. Signed-off-by: objec <objecttothis@gmail.com> * Resolve code review recommendations - Add try/catch around DB connect statement - Heed result of execute_script function and throw an exception on failure. Signed-off-by: objec <objecttothis@gmail.com> * Refactor out duplicate code Signed-off-by: objec <objecttothis@gmail.com> * Initialize array variable causing potential issues Signed-off-by: objec <objecttothis@gmail.com> --------- Signed-off-by: objec <objecttothis@gmail.com>
77 lines
2.0 KiB
PHP
77 lines
2.0 KiB
PHP
<?php
|
|
|
|
namespace Config;
|
|
|
|
use App\Models\Appconfig;
|
|
use CodeIgniter\Cache\CacheInterface;
|
|
use CodeIgniter\Config\BaseConfig;
|
|
use Config\Database;
|
|
|
|
/**
|
|
* This class holds the configuration options stored from the database so that on launch those settings can be cached
|
|
* once in memory. The settings are referenced frequently, so there is a significant performance hit to not storing
|
|
* them.
|
|
*/
|
|
class OSPOS extends BaseConfig
|
|
{
|
|
public array $settings = [];
|
|
public string $commit_sha1 = 'dev'; // TODO: Travis scripts need to be updated to replace this with the commit hash on build
|
|
private CacheInterface $cache;
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->cache = Services::cache();
|
|
$this->set_settings();
|
|
}
|
|
|
|
/**
|
|
* @return void
|
|
*/
|
|
public function set_settings(): void
|
|
{
|
|
$cache = $this->cache->get('settings');
|
|
|
|
if ($cache) {
|
|
$this->settings = decode_array($cache);
|
|
return;
|
|
}
|
|
|
|
try {
|
|
$db = Database::connect();
|
|
|
|
if (!$db->tableExists('app_config')) {
|
|
$this->settings = $this->getDefaultSettings();
|
|
return;
|
|
}
|
|
|
|
$appconfig = model(Appconfig::class);
|
|
foreach ($appconfig->get_all()->getResult() as $app_config) {
|
|
$this->settings[$app_config->key] = $app_config->value;
|
|
}
|
|
$this->cache->save('settings', encode_array($this->settings));
|
|
} catch (\Exception $e) {
|
|
$this->settings = $this->getDefaultSettings();
|
|
}
|
|
}
|
|
|
|
private function getDefaultSettings(): array
|
|
{
|
|
return [
|
|
'language' => 'english',
|
|
'language_code' => 'en',
|
|
'company' => 'Home',
|
|
'barcode_type' => 'Code39'
|
|
];
|
|
}
|
|
|
|
/**
|
|
* @return void
|
|
*/
|
|
public function update_settings(): void
|
|
{
|
|
$this->cache->delete('settings');
|
|
$this->set_settings();
|
|
}
|
|
}
|