<?php

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

    /**
     * List all items
     * @param string $order
     * @param boolean $byDeletedNull
     * @return array|IdiormResultSet
     */
    public  function all($order = 'id', $byDeletedNull = false)
    {
        $orm = ORM::for_table($this->table)->order_by_asc($order);

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

        return $orm->find_many();
    }

    /**
     * Return just active items
     *
     * @param string $order The field to order in result query
     * @param mixed $status The value of status to filter
     * @param bool $deletedAt Search for registers deleted or not
     * @return array|IdiormResultSet
     */
    public function findAllActives($order = 'id', $status = 1, $deletedAt = false)
    {
        $orm = ORM::for_table($this->table)
            ->where('status', $status);

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

        return $orm->order_by_asc($order)->find_many();
    }

    /**
     * Create ORM object to insert
     * @return ORM
     */
    public function create()
    {
        return ORM::for_table($this->table)->create();
    }

    /**
     * Find entity by ID
     * @param $id
     * @return bool|ORM
     */
    public function getOne($id)
    {
        return ORM::for_table($this->table)->find_one($id);
    }
}