<?php

abstract class App_School_AbstractObj extends Qs_Db_Obj
{
    const ADMINISTRATION_ID = 30;

    public $itemName = 'School';
    public $itemsName = 'Schools';
    protected $_tableAlias = 'School';
    protected $_fileFields = array('logo');

    public function getIdByName($name)
    {
        $sql = "SELECT `id` FROM `{$this->_tableName}` WHERE `name` = " . $this->db->quote($name) . " LIMIT 1";
        $id = $this->db->fetchOne($sql);
        if (!$id) {
            $id = $this->insert(array('name' => $name, 'enabled' => 'n'));
        }

        return $id;
    }
}