<?php

namespace App\Training\Result;

use Qs_Db;
use Qs_Db_Obj;
use Zend_Db_Select;

class AbstractObj extends Qs_Db_Obj
{
    protected function _joinTest(Zend_Db_Select $select, array $columns = ['*'])
    {
        $select->joinLeft(
            Qs_Db::getPair('Test'),
            'Test.id = Result.testId',
            $columns
        );
        return $this;
    }

    protected function _joinCertificate(Zend_Db_Select $select, array $columns = ['*'])
    {
        $select->joinLeft(
            Qs_Db::getPair('Certificate'),
            'Certificate.id = ResultAttempt.certificateId',
            $columns
        );
        return $this;
    }

    protected function _joinUser(Zend_Db_Select $select, array $columns = ['*'])
    {
        $select->joinLeft(
            Qs_Db::getPair('User'),
            'User.id = Result.userId',
            $columns
        );
        return $this;
    }

}