<?php
/**
 * Created by JetBrains PhpStorm.
 * User: riddler
 * Date: 1/3/12
 * Time: 10:17 AM
 * To change this template use File | Settings | File Templates.
 */

require_once ('class/DB/DBObj.php');
require_once('app/Event/Certificate/Obj.php');

abstract class App_Event_Form_Req_AbstractObj extends DBObj
{
    var $tableName = 'EventFormReq';
    protected $_certificateData;

    protected function _leftJoinEvent($alias = null)
    {
        return 'LEFT ' . $this->_joinEvent($alias);
    }

    protected function _joinEvent($alias = null)
    {
        return 'JOIN ' . $this->_getPair('Event', 'e') . ' '
             . '    ON `e`.`id` = ' . $this->quoteField('id_event', $alias) . ' '
             . $this->_leftJoinEventDoc();
    }

    protected function _leftJoinEventDoc()
    {
        return 'LEFT ' . $this->_joinEventDoc();
    }

    protected function _joinEventDoc()
    {
        return 'JOIN ' . $this->_getPair('EventDocumentofCommerce', 'edoc') . ' '
             . '    ON `edoc`.`doc_number` = `e`.`doc_number`';
    }

    protected function _leftJoinMember($alias = null)
    {
        return 'LEFT ' . $this->_joinMember($alias);
    }

    protected function _joinMember($alias = null)
    {
        return 'JOIN ' . $this->_getPair('Member', 'm') . ' '
             . '    ON `m`.`id` = ' . $this->quoteField('id_member', $alias);
    }

    protected function _leftJoinEventCeCreditHistory()
    {
        return "
            LEFT JOIN {$this->_getPair('EventCECreditHistory', 'ech')}
                ON `ech`.`id_event` = `{$this->tableName}`.`id_event`
                AND `ech`.`id_individual` = `{$this->tableName}`.`id_member`
        ";
    }

    public function getColumnCertificateAllowed($requestAlias, $eventAlias, $memberAlias, $ceHistoryAlias)
    {
        return App_Event_Certificate_Obj::getColumnCertificateAllowed(
            $requestAlias,
            $eventAlias,
            $memberAlias,
            $ceHistoryAlias);
    }
}