<?php

class TM_NavigationPro_Model_Resource_Sibling extends Mage_Core_Model_Mysql4_Abstract
{
    protected function _construct()
    {
        $this->_init('navigationpro/sibling', 'sibling_id');
    }

    /**
     * Process column data before saving
     *
     * @param Mage_Core_Model_Abstract $object
     * @return TM_NavigationPro_Model_Resource_Column
     */
    protected function _beforeSave(Mage_Core_Model_Abstract $object)
    {
        $jsonFields = array(
            'is_active_exception'
        );
        $data = array();
        foreach ($jsonFields as $key) {
            if (!$object->hasData($key)) {
                continue;
            }
            $data[$key] = $object->getData($key);

            if ('is_active_exception' === $key && is_array($data[$key])) {
                foreach (array_keys($data[$key]) as $i) {
                    if (!empty($data[$key][$i]['is_delete'])) {
                        unset($data[$key][$i]);
                    } else {
                        unset($data[$key][$i]['is_delete']);
                    }

                    if (empty($data[$key][$i]['expression'])) {
                        unset($data[$key][$i]);
                    }
                }
                $data[$key] = array_values($data[$key]);
            }
        }

        $object->setConfiguration(Mage::helper('core')->jsonEncode($data));

        return $this;
    }

    /**
     * Assign sibling content to store views
     *
     * @param Mage_Core_Model_Abstract $object
     * @return TM_NavigationPro_Model_Resource_Sibling
     */
    protected function _afterSave(Mage_Core_Model_Abstract $object)
    {
        $table = $this->getTable('navigationpro/sibling_content');
        $where = array(
            'sibling_id = ?' => (int) $object->getId(),
            'store_id = ?'   => (int) $object->getStoreId()
        );
        $this->_getWriteAdapter()->delete($table, $where);

        if (null !== $object->getContent() || null !== $object->getDropdownContent()) {
            $this->_getWriteAdapter()->insert($table, array(
                'sibling_id'        => (int) $object->getId(),
                'store_id'         => (int) $object->getStoreId(),
                'content'          => $object->getContent(),
                'dropdown_content' => $object->getDropdownContent()
            ));
        }

        return parent::_afterSave($object);
    }
}