<?php

require_once __DIR__ . '/../../../autoload/My_Model.php';
require_once __DIR__ . '/../factories/WebservicesfieldsFactory.php';

/**
 *
 */
class WebservicesfieldsModel extends My_Model
{
	/**
	 * @var string
	 */
	public $table = 'module_forms_webservices_fields';

	/**
	 * @var string
	 */
	public $factory;

	/**
	 * WebservicesModel constructor.
	 */
	public function __construct()
	{
		$this->factory = WebservicesFieldsFactory::class;
	}

    /**
     * List all items
     * @param string $order
     * @param boolean $byDeletedNull
     * @return array|IdiormResultSet
     */
    public  function all($order = 'id', $byDeletedNull = false, $returnType = 'object')
    {
        $orm = ORM::for_table($this->table)
            ->table_alias('wsf')
            ->join('module_forms_webservices', 'wsf.webservice_id = ws.id', 'ws')
            ->select('wsf.*')
            ->select('ws.title')
            ->order_by_asc($order);

        if ($byDeletedNull) {
            $orm->where_null('deleted_at');
        }

        if ($returnType == 'object') {
			return $orm->find_many();
		}

		if ($returnType == 'array') {
			return $orm->find_array();
		}
    }

	/**
	 * @param $data
	 * @return ORM
	 */
	public function createWebserviceField($data)
	{
		$model = parent::create();
        WebservicesFieldsFactory::create($data, $model);
		$model->save();

		return $model;
	}

	/**
	 *
	 */
	public function update($data, $model)
	{
		ORM::for_table($this->table)->create($model);
        WebservicesFieldsFactory::create($data, $model);
		$model->save();

		return $model;
	}

	/**
	 * @param $id
	 */
	public function delete($id)
	{
		$registry = ORM::for_table($this->table)->find_one($id);
		if ($registry) {
			$registry->delete();
		}
	}
}