<?php

namespace Qs\Db;

use Qs\AbstractModel;
use Qs\Db\Model\TableAwareTrait;
use Qs_Db;
use Zend_Db_Adapter_Pdo_Mysql;
use Zend_Db_Expr;

class Model extends AbstractModel
{
    use TableAwareTrait;

    /**
     * @var Zend_Db_Adapter_Pdo_Mysql
     */
    protected $db;

    public function __construct($db, $tableAlias)
    {
        $this->setDb($db);
        $this->setTableAlias($tableAlias);
    }

    protected function setDb(Zend_Db_Adapter_Pdo_Mysql $db)
    {
        $this->db = $db;
        return $this;
    }

    public function find(array $key)
    {
        return $this->getTable()->searchBy($key);
    }

    public function isUnique($field, $value, array $key = [])
    {
        $select = $this->db->select();
        $select->from(Qs_Db::getPair($this->tableAlias), new Zend_Db_Expr('1'));
        $select->where('`' . $field . '` = ?', $value);
        if ($key) {
            foreach ($key as $field => $value) {
                if (is_null($value)) {
                    $select->where("`{$field}` IS NOT NULL");
                } else {
                    $select->where("`{$field}` != ?", $value);
                }
            }
        }
        $select->limit(1);
        return '1' !== $this->db->fetchOne($select);
    }
}