YetiForceCompany/YetiForceCRM

<?php

/**
 * Record Model.
 *
 * @package Settings.Model
 *
 * @copyright YetiForce S.A.
 * @license YetiForce Public License 6.5 (licenses/LicenseEN.txt or yetiforce.com)
 * @author Tomasz Kur <t.kur@yetiforce.com>
 * @author Mariusz Krzaczkowski <m.krzaczkowski@yetiforce.com>
 * @author Radosław Skrzypczak <r.skrzypczak@yetiforce.com>
 */
class Settings_WebserviceApps_Record_Model extends Settings_Vtiger_Record_Model
{
    /**
     * Length key.
     */
    const KEY_LENGTH = 32;

    /**
     * Function to get id.
     *
     * @return int
     */
    public function getId()
    {
        return $this->get('id');
    }

    /**
     * Return name server.
     *
     * @return type
     */
    public function getName()
    {
        return $this->get('name');
    }

    /**
     * Function to get instance without data.
     *
     * @return \self
     */
    public static function getCleanInstance()
    {
        return new self();
    }

    /**
     * Static function to get model.
     *
     * @param int $recordId
     *
     * @return bool|\self
     */
    public static function getInstanceById($recordId)
    {
        if (empty($recordId)) {
            return false;
        }
        $model = self::getCleanInstance();
        if ($data = \App\Fields\ServerAccess::get($recordId)) {
            $model->setData($data);
        }
        return $model;
    }

    /**
     * Delete the record.
     */
    public function delete()
    {
        \App\Db::getInstance('webservice')->createCommand()
            ->delete('w_#__servers', ['id' => $this->getId()])
            ->execute();
        \App\Cache::delete('App\Fields\ServerAccess::get', $this->getId());
    }

    /**
     * Checks if duplicates.
     *
     * @return bool
     */
    private function checkDuplicate(): bool
    {
        $where = ['and'];
        $where[] = ['type' => $this->get('type'), 'name' => $this->get('name')];
        if (!$this->isEmpty('id')) {
            $where[] = ['<>', 'id', $this->getId()];
        }
        return (new App\Db\Query())->from('w_#__servers')->where($where)->exists();
    }

    /**
     * Save record.
     */
    public function save()
    {
        $db = \App\Db::getInstance('webservice');
        if ($this->checkDuplicate()) {
            throw new \App\Exceptions\IllegalValue('ERR_DUPLICATE_LOGIN', 406);
        }
        $data = [
            'status' => $this->get('status') ? 1 : 0,
            'name' => $this->get('name'),
            'url' => (string) $this->get('url'),
            'ips' => (string) $this->get('ips'),
            'pass' => $this->get('pass') ? App\Encryption::getInstance()->encrypt($this->get('pass')) : '',
        ];
        if ($this->isEmpty('id')) {
            $data['type'] = $this->get('type');
            $data['api_key'] = App\Encryption::getInstance()->encrypt(\App\Encryption::generatePassword(self::KEY_LENGTH));
            $db->createCommand()->insert('w_#__servers', $data)->execute();
            $this->set('id', $db->getLastInsertID('w_#__servers_id_seq'));
        } else {
            $db->createCommand()->update('w_#__servers', $data, ['id' => $this->getId()])->execute();
        }
        \App\Cache::delete('App\Fields\ServerAccess::get', $this->getId());
    }
}