<?php

namespace App\Gallery;

use Qs_Db_Obj;

class AbstractObj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Gallery';
    protected $_tableShortAlias = 'g';

    protected $_fileFields = array('image');
    protected $_urlParseFields = array('description');

    /**
     * @param bool $visible [OPTIONAL]
     * @return \Zend_Db_Select
     */
    protected function _getImagesCountSelect($visible = null)
    {
        $select = $this->_db->select();
        $select->from($this->_getPair('GalleryImage', 'gi'), 'COUNT(`gi`.`id`)');
        $select->where('`gi`.`galleryId` = `g`.`id`');
        if (null !== $visible) {
            $select->where('`gi`.`enabled` = ?', ($visible) ? 'y' : 'n');
        }

        return $select;
    }

    protected function _getVisibleImagesCountSelect()
    {
        return $this->_getImagesCountSelect(true);
    }

}