<?php

class App_Leadership_Category_Admin_Obj extends App_Leadership_Category_Abstract_Obj
{
    const MSG_HAS_PERSONS= 'Leadership Category has questions tied to it, that is why this category cannot be deleted. Please make sure to untie or remove the  tied questions to this category before deleting it.';

    protected $_filterFields = array('title');

    public function hasPersons()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair('Leadership'), 'id');
        $select->where('`Leadership`.`categoryId` = ?', $this->getPrimaryKey(), Zend_Db::INT_TYPE);
        $select->limit(1);
        return (bool) $this->_db->fetchOne($select);
    }

    public function delete()
    {
        $this->_clearErrors();
        if (null === $this->getData()) {
            $this->_addError(static::MSG_INVALID_RECORD_ID);
            return false;
        } else if ($this->hasPersons()) {
            $this->_addError(static::MSG_HAS_PERSONS);
            return false;
        }
        $this->_deleteDependency();
        $this->_deleteFiles();
        return $this->_getTable()->deleteByKey($this->_primaryKey);
    }
}