pluf/shop

<?php

class Shop_OrderMetafield extends Pluf_Model
{

    /**
     *
     * @brief مدل داده‌ای را بارگذاری می‌کند.
     *
     * @see Pluf_Model::init()
     */
    function init()
    {
        $this->_a['table'] = 'shop_order_metafields';
        $this->_a['verbose'] = 'Shop_OrderMetafield';
        $this->_a['cols'] = array(
            'id' => array(
                'type' => 'Sequence',
                'is_null' => false,
                'editable' => false
            ),
            'key' => array(
                'type' => 'Varchar',
                'is_null' => false,
                'size' => 250,
                'editable' => true
            ),
            'value' => array(
                'type' => 'Varchar',
                'is_null' => false,
                'size' => 256,
                'editable' => true
            ),
            'namespace' => array(
                'type' => 'Varchar',
                'is_null' => true,
                'size' => 128,
                'editable' => true
            ),
            /*
             * Relations
             */
            'order_id' => array(
                'type' => 'Foreignkey',
                'model' => 'Shop_Order',
                'name' => 'order',
                'graphql_name' => 'order',
                'relate_name' => 'metafields',
                'is_null' => false,
                'editable' => false
            )
        );

        $this->_a['idx'] = array(
            'metafield_idx' => array(
                'col' => 'key, order_id',
                'type' => 'unique', // normal, unique, fulltext, spatial
                'index_type' => '', // hash, btree
                'index_option' => '',
                'algorithm_option' => '',
                'lock_option' => ''
            )
        );
    }

    /**
     * Extract information of metafield and returns it.
     *
     * @param string $key
     * @param long $orderId
     * @return Shop_OrderMetafield
     */
    public static function getMetafield($key, $orderId)
    {
        $model = new Shop_OrderMetafield();
        $where = new Pluf_SQL('`key`=%s AND `order_id`=%s', array(
            $model->_toDb($key, 'key'),
            $model->_toDb($orderId, 'order_id')
        ));
        $metas = $model->getList(array(
            'filter' => $where->gen()
        ));
        if ($metas === false or count($metas) !== 1) {
            return false;
        }
        return $metas[0];
    }
}