<?php

namespace App\Gallery;

use Qs_Db_Obj;

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

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

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

        return $select;
    }
}