<?php

/**
 * @property Qs_Db_Table $table
 */

class App_ECommerce_Promo_Admin_Obj extends App_ECommerce_Promo_Abstract_Obj
{
    const DEFAULT_CODE_LENGTH = 6;
    const CODE_GENERATION_ITERATIONS = 30;

    protected $_filterFields = array('code', 'pc' => array('title'));

    protected $_statuses = array(
        'active'   => 'Active',
        'upcoming' => 'Not Active',
        'expired'  => 'Expired',
        ''         => 'All',
    );

    public function getStatuses()
    {
        return $this->_statuses;
    }

    protected function _filter(Zend_Db_Select $select)
    {
        if (!$this->hasFilter()) {
            return $this;
        }

        parent::_filter($select);

        if (!empty($this->_filter['status'])) {
            switch ($this->_filter['status']) {
                case 'active':
                    $select->where('`startDate` <= CURRENT_DATE()');
                    $select->where('`hasNoExpirationDate` = "y" OR `endDate` >= CURRENT_DATE()');
                    break;
                case 'upcoming':
                    $select->where('`startDate` > CURRENT_DATE()');
                    break;
                case 'expired':
                    $select->where('`hasNoExpirationDate` = "n"');
                    $select->where('`endDate` < CURRENT_DATE()');
                    break;
            }
        }
        if (array_key_exists('query', $this->_filter)) {
            $this->_select->joinLeft(
                $this->_getPair($this->_tableAlias . '2ProductCategory', 'p2pc'),
                '`p2pc`.`promoId` = `Promo`.`id`',
                []
            );
            $this->_select->joinLeft(
                $this->_getPair('ProductCategory', 'pc'),
                '`pc`.`id` = `p2pc`.`categoryId`',
                []
            );
            $this->_select->group('Promo.id');
        }

        return $this;
    }

    /**
     * Return data for code
     *
     * @param string $code
     * @return array|bool
     */
    public function getDataByCode($code)
    {
        if ($promoData = $this->_getTable()->searchBy(array('code' => $code))) {
            $this->_addRelatedProductCategories($promoData);
        }
        return $promoData;

    }

    public function generateCode($iterations = self::CODE_GENERATION_ITERATIONS)
    {
        $codeValidator = new Qs_Validate_Unique(new Qs_Db_Table('Promo'), 'code', $this->getData('id'));
        $expirationWhere = '(`hasNoExpirationDate` = "y") OR (`hasNoExpirationDate` = "n" AND `endDate` < CURRENT_DATE())';
        $codeValidator->setWhere($expirationWhere);

        $iterations = (int) $iterations;
        $iterations = ($iterations > 0) ? $iterations : static::CODE_GENERATION_ITERATIONS;

        $code = '';
        $unique = false;
        while ($unique == false && $iterations > 0) {
            $code = strtoupper(substr(md5(rand().microtime(true).rand()), 0, static::DEFAULT_CODE_LENGTH));
            $code = strtoupper($code);
            if ($codeValidator->isValid($code)) {
                $unique = true;
            } else {
                $code = '';
            }
            $iterations--;
        }

        return $code;
    }

    public function getObjectInfo()
    {
        $data = parent::getObjectInfo();
        $data['itemTitle'] = strip_tags($this->_renderDescription($data));
        return $data;
    }

    protected function _renderDescription(array $data)
    {
        $text = '';

        if (empty($data)) {
            return $text;
        }

        if ($data['type'] == App_ECommerce_Promo_Admin_View::PROMO_TYPE_PERCENT) {
            require_once 'lib/Smarty/app_plugins/modifier.money.php';
            $text .= smarty_modifier_money($data['value'], 2, true) . '% ';
        } else {
            $text .= '$' . number_format($data['value'], 2, '.', ',') . ' ';
        }
        $text .= 'off ';

        if ('y' == $data['isRelated'] && $data['relatedCategories']) {
            $cateories = explode(self::CATEGORY_SEPARATOR, $data['relatedCategories']);
            $cateoriesList = '<ul style="margin: 0 0 0 25px;">';
            foreach ($cateories as $categoryTitle) {
                $cateoriesList .= '<li>' . $categoryTitle . '</li>';
            }
            $cateoriesList .= '</ul>';
            $text .= 'for products within categories: <br/>' . $cateoriesList . ' ';
        }

        if ($data['minOrderValue'] > 0) {
            $text .= 'for orders over $' . number_format($data['minOrderValue'], 2, '.', ',');
        }

        return $text;
    }

    protected function _prepareList(&$list)
    {
        if (!empty($list)) {
            foreach (array_keys($list) as $key) {
                $this->_prepareRow($list[$key]);
                $list[$key]['description'] = $this->_renderDescription($list[$key]);
            }
        }
        return $this;
    }

    protected function _updateDependency()
    {
        $this->_saveDependency();
        return parent::_updateDependency();
    }

    protected function _insertDependency()
    {
        $this->_saveDependency();
        return parent::_insertDependency();
    }

    protected function _saveDependency()
    {
        if (array_key_exists('productCategoryIds', $this->_data)) {
            $this->_updateIds(
                $this->_tableAlias . '2ProductCategory', 'promoId', 'categoryId', $this->_data['productCategoryIds']
            );
        }
        return $this;
    }

    protected function _addDependenciesFromDb(array &$data)
    {
        $this->_addRelatedProductCategories($data);
        return $this;
    }

    protected function _addRelatedProductCategories(array &$data)
    {
        $select = $this->_getDependencySelect(
            $this->_getTableName(),
            new Zend_Db_Expr('`t`.`categoryId`'),
            $this->_getTableName($this->_tableAlias . '2ProductCategory'),
            'promoId',
            ['promoId' => $data['id']]
        );
        $data['productCategoryIds'] = Qs_Array::fetchCol($select->query()->fetchAll(), 'categoryId');
        return $this;
    }
}