<?php

namespace App\Gallery\Admin;

use App\Gallery\AbstractObj;
use Qs_Db;
use Zend_Db_Expr;

class Obj extends AbstractObj
{
    protected $_filterFields = ['title', 'description'];
    protected $_rawDataFields = ['description'];

    protected function _getFromColumns()
    {
        $columns = parent::_getFromColumns();
        $columns['imageCount'] = new Zend_Db_Expr('(' . $this->_getImagesCountSelect() . ')');
        $columns['visibleImageCount'] = new Zend_Db_Expr('(' . $this->_getImagesCountSelect(true) . ')');
        return $columns;
    }

    protected function _getFromDbColumns()
    {
        $columns = parent::_getFromColumns();
        $columns['visibleImageCount'] = new Zend_Db_Expr('(' . $this->_getImagesCountSelect(true) . ')');
        return $columns;
    }

    protected function _getImages()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair('GalleryImage'), ['image']);
        $select->where('`galleryId` = ?', $this->getPrimaryKey(), Qs_Db::INT_TYPE);
        return $this->_db->fetchCol($select);
    }

    protected function _deleteDependency()
    {
        $this->_deleteImages();
        return $this;
    }

    protected function _deleteImages()
    {
        $this->_dependedFields = array_merge($this->_dependedFields, $this->_getImages());
        return $this;
    }
}