<?php

namespace App\WideSlide\Admin;

use App\WideSlide\AbstractObj;

class Obj extends AbstractObj
{
    protected $_filterFields = ['title', 'description'];
    protected $_nullableFields = ['linkType'];
    protected $_reorderTitleColumn = 'reorderTitle';

    protected function _getReorderSelect()
    {
        $select = parent::_getReorderSelect();
        $reorderTitle = $this->_db->quoteInto(
            'IF(title != "", title, IF(slideType = ?, image, REPLACE(REPLACE(video, "{BASE_URL}/userfiles/ckfiles/media/", ""), "%20", " ")))',
            self::SLIDE_TYPE_IMAGE
        );
        $select->columns(['reorderTitle' => new \Zend_Db_Expr($reorderTitle)]);

        return $select;
    }
}