YetiForceCompany/YetiForceCRM

<?php

/**
 * @copyright YetiForce S.A.
 * @license YetiForce Public License 6.5 (licenses/LicenseEN.txt or yetiforce.com)
 * @author Radosław Skrzypczak <r.skrzypczak@yetiforce.com>
 */
class Settings_Inventory_Module_Model extends \App\Base
{
    public static $picklist = [
        'aggregation' => ['LBL_CANNOT_BE_COMBINED', 'LBL_IN_TOTAL', 'LBL_CASCADE'],
        'discounts' => ['LBL_GLOBAL', 'LBL_GROUP', 'LBL_INDIVIDUAL', 'LBL_ADDITIONAL'],
        'taxs' => ['LBL_GLOBAL', 'LBL_GROUP', 'LBL_INDIVIDUAL', 'LBL_REGIONAL'],
    ];

    public static function getCleanInstance()
    {
        return new self();
    }

    public static function getPicklistValues($type)
    {
        return self::$picklist[$type];
    }

    private static $tablename = ['DiscountConfiguration' => 'a_#__discounts_config', 'TaxConfiguration' => 'a_#__taxes_config'];

    public static function getTableNameFromType($type)
    {
        return static::$tablename[$type];
    }

    public static function getConfig($type, $name = false)
    {
        \App\Log::trace('Start ' . __METHOD__ . ' | Type: ' . print_r($type, true) . ' | Name: ' . print_r($name, true));
        $tableName = self::getTableNameFromType($type);
        $query = (new \App\Db\Query())->from($tableName);
        if ($name && !\is_array($name)) {
            $name = [$name];
        }
        if ($name) {
            $query->where(['param' => $name]);
        }
        $output = [];
        $dataReader = $query->createCommand()->query();
        while ($row = $dataReader->read()) {
            $output[$row['param']] = $row['value'];
        }
        $dataReader->close();
        \App\Log::trace('End ' . __METHOD__);

        return $output;
    }

    /**
     * Function saves configuration data to database.
     *
     * @param string $type
     * @param array  $param
     *
     * @return bool
     */
    public function setConfig($type, $param)
    {
        \App\Log::trace('Start ' . __METHOD__);
        $tableName = self::getTableNameFromType($type);
        \App\Db::getInstance()->createCommand()
            ->update($tableName, ['value' => $param['value']], ['param' => $param['param']])
            ->execute();
        \App\Cache::delete('Inventory', $type);
        \App\Log::trace('End ' . __METHOD__);

        return true;
    }
}