<?php

namespace App\Test;

use Zend_Db_Select;

class AbstractObj extends \Qs_Db_Obj
{
    protected $_tableAlias = 'Test';
    protected $_tableShortAlias = 't';

    public function getListSelect()
    {
        if (null === $this->_select) {
            $select = parent::getListSelect();
            $this->joinCertificate($select);
        }
        return $this->_select;
    }

    protected function joinCertificate(Zend_Db_Select $select)
    {
        $select->join(
            $this->_getPair('Certificate', 'c'),
            '`c`.`id` = `t`.`certificateId`',
            [
                'certificateTitle' => 'title',
            ]
        );
        return $this;
    }
}