<?php

/**
 * @property array $pairFormElementProperty
 * @property array $pairFormElementPropertyValue
 * @property array $pairFormSubmissionValue
 * @property Qs_Db_Table $tableFormElementPropertyValue
 * @property Qs_Db_Table $table
 * @property array $pair
 */
class App_FormBuilder_Element_Obj extends Qs_Db_Obj
{
    const ALL_TYPE_ID = -1;
    const ALL_NONSTATIC_TYPE_ID = 0;
    const TEXT_ID = 1;               // type id for <input type="text"> element
    const TEXTAREA_ID = 2;           // type id for <textarea> element
    const STATIC_TEXT_ID = 3;        // type id for <label> element
    const SELECT_ID = 4;             // type id for <select> element
    const CHECKBOX_ID = 5;           // type id for <input type="checkbox"> element
    const RADIO_GROUP_ID = 6;        // type id for <input type="radio"> element
    const IMAGE_ID = 7;              // type id for <input type="file"> element
    const MULTI_TEXT_ID = 8;         // type id for matrix of <input type="text"> elements
    const MULTI_CHECKBOX_ID = 9;     // type id for matrix of <input type="checkbox"> elements
    const HYPERLINK_ID = 10;         // type id for <a href=""> elements
    const HORIZONTAL_LINE_ID = 11;   // type id for <a href=""> elements
    const VERTICAL_LINE_ID = 12;     // type id for <a href=""> elements
    const WIDTH_GAP = 15;            // width gap for rendering element container (include padding, margin, border, etc.
    const PROPERTY_NAME_ID = 8;      // id for property, that contains element name
    const PROPERTY_SPECIAL_ID = 41;  // id for property, that contains element special flag
    const MINIMUM_WIDTH = 50;

    public static $types = array(    // part of path to the element class - App_FormBuilder_Element_{$type}
        self::TEXT_ID => 'Text',
        self::TEXTAREA_ID => 'TextArea',
        self::STATIC_TEXT_ID => 'Label',
        self::SELECT_ID => 'Select',
        self::CHECKBOX_ID => 'CheckBox',
        self::RADIO_GROUP_ID => 'Radio',
        self::IMAGE_ID => 'Image',
        self::MULTI_TEXT_ID => 'MultiText',
        self::MULTI_CHECKBOX_ID => 'MultiCheckBox',
        self::HYPERLINK_ID => 'Hyperlink',
        self::HORIZONTAL_LINE_ID => 'HorizontalLine',
        self::VERTICAL_LINE_ID => 'VerticalLine',
    );
    public $draftFilter = null;

    protected $_tableAlias = 'FormElement';
    protected $_typeId = 1;
    protected $_elementType = 'text';
    protected $_propertiesDefaults = array(
            'labelWidth' => 150,
        'labelAlignment' => 'left',
            'fontFamily' => 'Arial',
              'fontSize' => 12,
                 'width' => 250,
                'height' => 150,
           'headerWidth' => 100,
               'options' => 'option1',
                  'size' => 1,
                  'rows' => 5,
               'columns' => 2,
             'thickness' => 2,
    );
    protected $_hasFilter = true;
    protected $_formType = 'process';

    public function save()
    {
        $this->tableFormElementPropertyValue->delete(
            $this->_db->quoteInto('elementId = ?', $this->_primaryKey, Zend_Db::INT_TYPE)
        );
        $properties= $this->getProperties();
        foreach ($properties as $property) {
            if ($this->_data[$property['alias']]) {
                $this->tableFormElementPropertyValue->insert(array(
                     'elementId' => $this->_primaryKey,
                    'propertyId' => $property['id'],
                         'value' => $this->_data[$property['alias']]
                ));
            }
        }

        return $this;
    }

    public function create($formId, $formType = null)
    {
        if ($formType) {
            $this->_formType = $formType;
        }
        $this->insert(array('typeId' => $this->_typeId, 'formId' => $formId, 'formType' => $this->_formType,
                            'draftFor' => 0));
        $this->_setDefaultProperties();
        $this->save();
        return $this->_primaryKey;
    }

    /**
     * @return Zend_Db_Select
     */
    protected function _getPropertiesSelect()
    {
        $typeIds = array($this->_typeId);
        if (!in_array($this->_typeId, array(self::HORIZONTAL_LINE_ID, self::VERTICAL_LINE_ID))) {
            $typeIds[] = self::ALL_TYPE_ID;
            if ($this->_typeId != self::STATIC_TEXT_ID) {
                $typeIds[] = self::ALL_NONSTATIC_TYPE_ID;
            }
        }
        $select = $this->select->reset()
            ->from($this->pairFormElementProperty)
            ->where('elementTypeId IN (?)', $typeIds, Zend_Db::INT_TYPE)
            ->order('sorter');

        return $select;
    }

    public function getProperties()
    {
        return $this->_prepareElementProperties($this->_getPropertiesSelect()->query()->fetchAll());
    }

    protected function  _prepareElementProperties($list)
    {
        foreach ($list as &$row) {
            if ($row['alias'] == 'name') {
                $row['alias'] = 'propertyName';
            }
        }
        return $list;
    }

    protected function _getFromDb($key, $field = false)
    {
        $row = parent::_getFromDb($key);
        $joinCondition = $this->_db->quoteInto(
            'FormElementProperty.id = FormElementPropertyValue.propertyId
                AND FormElementPropertyValue.elementId = ?',
            $this->_primaryKey,
            Zend_Db::INT_TYPE);
        $select = $this->_getPropertiesSelect()
            ->reset(Zend_Db_Select::COLUMNS)
            ->columns('alias')
            ->joinLeft($this->pairFormElementPropertyValue, $joinCondition, 'value');

        $row = (array)$row + $this->_db->fetchPairs($select);
        $this->prepareProperties($row);

        return Qs_Array::get($row, $field);
    }

    public function prepareProperties(&$data)
    {
        if ($data['label']) {
            if ($data['labelPlacement'] == 'top') {
                $data['totalWidth'] = max($data['width'], $data['labelWidth']) + self::WIDTH_GAP;
            } else {
                $data['totalWidth'] = $data['width'] + $data['labelWidth'] + self::WIDTH_GAP;
            }
        } else {
            $data['totalWidth'] = $data['width'] + self::WIDTH_GAP;
        }
        $data['propertyName'] = $data['name'];

        return $this;
    }

    public function savePosition($positionData)
    {
        foreach ($positionData as &$value) {
            $value = (int)$value;
        }

        return $this->update($positionData);
    }

    protected function _filterWhere(Zend_Db_Select $select)
    {
        $select = parent::_filterWhere($select);
        if (!is_null($this->draftFilter)) {
            $select->where('draftFor IS ' . ($this->draftFilter ? 'NOT ' : '') . 'NULL');
        }
        return $select;
    }

    public function delete()
    {
        $this->tableFormElementPropertyValue->delete('elementId = ' . $this->_db->quote($this->_primaryKey));
        return parent::delete();
    }

    /**
     * @param int $propertyId
     * @param mixed $value
     * @return App_FormBuilder_Element_Obj
     */
    protected function _savePropertyValue($propertyId, $value)
    {
        $this->tableFormElementPropertyValue->deleteByKey(array($this->_primaryKey, $propertyId));
        $this->tableFormElementPropertyValue->insert(array(
             'elementId' => $this->_primaryKey,
            'propertyId' => $propertyId,
                 'value' => $value
        ));

        return $this;
    }

    protected function _setDefaultProperties()
    {
        $no = $this->select->reset()
            ->from($this->pair, array('totalType' => 'COUNT(*)'))
            ->where('formId = ?', $this->_data['formId'], Zend_Db::INT_TYPE)
            ->where('formType = ?', $this->_formType)
            ->where('typeId = ?', $this->_data['typeId'], Zend_Db::INT_TYPE)
            ->where('draftFor IS NOT NULL')
            ->query()->fetchColumn();

        $this->_propertiesDefaults['propertyName'] = strtolower(self::$types[$this->_data['typeId']]) . $no;
        $this->_propertiesDefaults['label'] = self::$types[$this->_data['typeId']] . ' ' . $no;
        $this->_data = array_merge($this->_data, $this->_propertiesDefaults);

        return $this;
    }

    /**
     * @param string $options
     * @return array
     */
    public function prepareOptions($options)
    {
        $options = $options ? array_map('trim', explode("\n", $options)) : array();

        return $options;
    }

    /**
     * @param null|Zend_Db_Select $select
     * @return Zend_Db_Select
     */
    protected function _join(Zend_Db_Select $select = null)
    {
        $select = parent::_join($select);
        $select->joinLeft(
            $this->pairFormElementPropertyValue,
            'FormElementPropertyValue.elementId = FormElement.id
                AND FormElementPropertyValue.propertyId = ' . self::PROPERTY_NAME_ID,
            array('name' => 'value')
        );
        $select->joinLeft(
            array('fepv' => $this->_getTableName('FormElementPropertyValue')),
            'fepv.elementId = FormElement.id
                AND fepv.propertyId = ' . self::PROPERTY_SPECIAL_ID,
            array('special' => 'value')
        );
        if (array_key_exists('submissionId', $this->_filter)) {
            $joinCondition = $this->_db->quoteInto(
                'FormSubmissionValue.elementId = FormElement.id AND FormSubmissionValue.submissionId = ?',
                $this->_filter['submissionId']
            );
            $select->joinLeft($this->pairFormSubmissionValue, $joinCondition, 'value');
        }
        return $select;
    }

    /**
     * @param Qs_Form $form
     * @return App_FormBuilder_Element_Obj
     */
    public function bindField(Qs_Form $form)
    {
        $prefix =  $this->getData('formType') != App_FormBuilder_Obj::DEFAULT_FORM_TYPE ? $this->getData('formType')
                                                                                        : '';
        $form->addElement($this->_elementType, $prefix . $this->getData('name'));
        return $this;
    }

    public function getList($options = array())
    {
        $select = $this->getListSelect($options);
        $list = $this->_db->fetchAssoc($select);
        $this->_prepareList($list);
        return $list;
    }

    /**
     * return map for old and new elements
     *  array(
     *     array(
     *       'oldElementId' => newElementId,
     *       'newElementId' => newElementId,
     *     ),
     *     ...
     *  )
     * @param int $oldFormId
     * @param int $newFormId
     * @param string $formType "part" or "process"
     * @return array
     */
    public function duplicateElements($oldFormId, $newFormId, $formType)
    {
        if (!$oldFormId || !$newFormId || !$formType) {
            return array();
        }

        $select = $this->_db->select();
        $select->from($this->_getPair('FormElement'), array('*'));
        $select->where('FormElement.formId = ?', $oldFormId, Qs_Db::INT_TYPE);
        $select->where('FormElement.formType = ?', $formType);
        $select->where('FormElement.formType = ?', $formType);
        $elements = $this->_db->fetchAll($select);
        if (!$elements) {
            return array();
        }
        $elements = array_combine(Qs_Array::fetchCol($elements, 'id'), $elements);

        $select->reset();
        $select->from($this->_getPair('FormElementPropertyValue'), array('elementId', '*'));
        $select->where('FormElementPropertyValue.elementId IN (?)', Qs_Array::fetchCol($elements, 'id'), Qs_Db::INT_TYPE);
        $propertyValues = $this->_db->fetchAll($select, array(), Qs_Db::FETCH_GROUP);

        $map = array();
        $formElementTable = $this->_getTable('FormElement');
        $propertyValueTable = $this->_getTable('FormElementPropertyValue');
        foreach ($elements as $oldElementId => $elementData) {
            unset($elementData['id'], $elementData['draftFor'], $elementData['added'], $elementData['changed']);
            $elementData['formId'] = $newFormId;
            $newElementId = $formElementTable->insert($elementData);

            if (!empty($propertyValues[$oldElementId])) {
                foreach ($propertyValues[$oldElementId] as $propertyData) {
                    $propertyData['elementId'] = $newElementId;
                    $propertyValueTable->insert($propertyData);
                }
            }

            $map[] = array(
                'oldElementId' => $oldElementId,
                'newElementId' => $newElementId,
            );
        }

        return $map;
    }
}