<?php

namespace App\Models;

use CodeIgniter\Database\ResultInterface;
use CodeIgniter\Model;
use Config\OSPOS;
use ReflectionException;

/**
 * Appconfig class
 *
 *
 */
class Appconfig extends Model
{
    protected $table = 'app_config';
    protected $primaryKey = 'key';
    protected $useAutoIncrement = false;
    protected $useSoftDeletes = false;
    protected $allowedFields = [
        'key',
        'value'
    ];

    /**
     * Checks to see if a given configuration exists in the database.
     *
     * @param string $key Key name to be searched.
     * @return bool True if the key is found in the database or false if it does not exist.
     */
    public function exists(string $key): bool
    {
        $builder = $this->db->table('app_config');
        $builder->where('key', $key);

        return ($builder->get()->getNumRows() === 1);
    }

    /**
     * Get all OpenSourcePOS configuration values from the database.
     *
     * @return ResultInterface
     */
    public function get_all(): ResultInterface
    {
        $builder = $this->db->table('app_config');
        $builder->orderBy('key', 'asc');

        return $builder->get();
    }

    /**
     * @param string $key
     * @param string $default
     * @return string
     */
    public function get_value(string $key, string $default = ''): string
    {
        $builder = $this->db->table('app_config');
        $query = $builder->getWhere(['key' => $key], 1);

        if ($query->getNumRows() === 1) {
            return $query->getRow()->value;
        }

        return $default;
    }

    /**
     * Calls the parent save() from BaseModel and updates the cached reference.
     *
     * @param array|object $data
     * @return bool true when the save was successful and false if the save failed.
     * @throws ReflectionException
     */
    public function save($data): bool
    {
        $key = array_keys($data)[0];
        $value = $data[$key];
        $save_data = ['key' => $key, 'value' => $value];

        $success = parent::save($save_data);

        if ($success) {
            config(OSPOS::class)->update_settings();
        }

        return $success;
    }

    /**
     * @throws ReflectionException
     */
    public function batch_save(array $data): bool
    {
        $success = true;

        $this->db->transStart();

        foreach ($data as $key => $value) {
            $success &= $this->save([$key => $value]);
        }

        $this->db->transComplete();

        $success &= $this->db->transStatus();

        return $success;
    }

    /**
     * Deletes a row from the Appconfig table given the name of the setting to delete.
     *
     * @param ?string $id The field name to be deleted in the Appconfig table.
     * @param bool $purge A hard delete is conducted if true and soft delete on false.
     * @return bool Result of the delete operation.
     */
    public function delete($id = null, bool $purge = false): bool
    {
        $builder = $this->db->table('app_config');
        return $builder->delete(['key' => $id]);
    }


    /**
     * @return bool
     */
    public function delete_all(): bool    // TODO: This function is never used in the code. Consider removing it.
    {
        $builder = $this->db->table('app_config');
        return $builder->emptyTable();
    }

    /**
     * @throws ReflectionException
     */
    public function acquire_next_invoice_sequence(bool $save = true): string
    {
        $config = config(OSPOS::class)->settings;
        $last_used = (int)$config['last_used_invoice_number'] + 1;

        if ($save) {
            $this->save(['last_used_invoice_number' => $last_used]);
        }

        return $last_used;
    }

    /**
     * @throws ReflectionException
     */
    public function acquire_next_quote_sequence(bool $save = true): string
    {
        $config = config(OSPOS::class)->settings;
        $last_used = (int)$config['last_used_quote_number'] + 1;

        if ($save) {
            $this->save(['last_used_quote_number' => $last_used]);
        }

        return $last_used;
    }

    /**
     * @throws ReflectionException
     */
    public function acquire_next_work_order_sequence(bool $save = true): string
    {
        $config = config(OSPOS::class)->settings;
        $last_used = (int)$config['last_used_work_order_number'] + 1;

        if ($save) {
            $this->save(['last_used_work_order_number' => $last_used]);
        }

        return $last_used;
    }
}