<?php

class App_People_AdminObj extends App_People_AbstractObj
{
    protected $_hasFilter = true;
    protected $_filterFields = array('name', 'jobTitle', 'shortBio');

    protected function _addDependenciesFromDb(&$data)
    {
        $select = $this->_db->select();
        $select->from($this->_getTableName($this->_tableAlias . '2Area'), 'areaId')
               ->where('`peopleId` = ?', $data['id'], Qs_Db::INT_TYPE);
        $data['areaId'] = $this->_db->fetchCol($select);
        return $this;
    }

    protected function _insertDependency()
    {
        $this->_updateDependency();
    }

    protected function _updateDependency()
    {
        $this->_updateIds(
            $this->_getTableName($this->_tableAlias . '2Area'),
            'peopleId',
            'areaId',
            $this->_data['areaId']
        );
        return $this;
    }

    public function delete()
    {
        $this->_deleteIds($this->_getTableName($this->_tableAlias . '2Area'), 'peopleId');
        return parent::delete();
    }
}