<?php

namespace App\Committee;

/**
 * @method array() getUserCommitteeRole4Select()
 */
class AbstractObj extends \Qs_Db_Obj
{
    protected $_tableAlias = 'Committee';
    protected $_urlParseFields = array('description');

    protected static $_leadershipRolesId = array();
    /** @var AbstractObj */
    protected static $_instance = null;

    protected $_checkForeignKeyDependencies = true;

    public static function getInstance()
    {
        if (!static::$_instance) {
            static::$_instance = new static();
        }
        return static::$_instance;
    }

    public static function getLeadershipRolesId()
    {
        if (!static::$_leadershipRolesId) {
            $select = \Qs_Db::getSelect();
            $select->from(\Qs_Db::getPair('UserCommitteeRole'), 'id')
                ->where('`leadership` = "y"');
            static::$_leadershipRolesId = \Qs_Db::getInstance()->fetchCol($select);
        }
        return static::$_leadershipRolesId;
    }

    protected function _getCommitteeFiles()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair('Document'), 'fileName')
            ->where('`committeeId` = ?', $this->_primaryKey, \Qs_Db::INT_TYPE);
        return $this->_db->fetchCol($select);

    }

    protected function _deleteDependency()
    {
        $adapter = new \Qs_File_Transfer_Adapter_Db();
        $files = $this->_getCommitteeFiles();
        foreach ($files as $fileName) {
            $adapter->delete($fileName, 'fileName');
        }
        unset($adapter);
        return parent::_deleteDependency();
    }


}