<?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;
	}
}
