Magento更改默认付款方式

DJames 发表于 Dev

杰姆斯

我有一个功能，可以对Magento中的数据库运行原始SQL查询。该功能的作用是将客户的默认信用卡更改为传递给该功能的值。我的问题是如何使用Magento模型重写函数。当前函数有效，但我们不希望它不直接与SQL接口。

这是函数：

public function setDefaultPayment($value)
{
    $customerId = $this->_getSession()->getCustomer()->getId();
    $write = Mage::getSingleton('core/resource')->getConnection('core_write');

    $read = $write->query("SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code='customer'");
    $row = $read->fetch();
    $entity_type_id = $row['entity_type_id'];

    $read = $write->query("SELECT attribute_id FROM eav_attribute WHERE attribute_code='default_payment' AND entity_type_id = $entity_type_id");
    $row = $read->fetch();
    $attribute_id = $row['attribute_id'];

    $read = $write->query("SELECT * FROM customer_entity_int WHERE entity_type_id='$entity_type_id' AND attribute_id='$attribute_id' AND entity_id='$customerId'");
    if ($row = $read->fetch()) {
        $write->update(
            'customer_entity_int',
            array('value' => $value),
            "entity_type_id='$entity_type_id' AND attribute_id='$attribute_id' AND entity_id='$customerId'"
        );
    } else {
        $write->insert(
            'customer_entity_int',
            array(
                'entity_type_id' => $entity_type_id,
                'attribute_id' => $attribute_id,
                'entity_id' => $customerId,
                'value' => $value
            )
        );
    }
}

编码

如果我没看错代码，就想default_payment用给定的值更新客户属性。

为此，您需要：

通过ID加载客户
为客户属性设置新值 default_payment
保存客户

public function setDefaultPayment($value)
{
    $customerId = $this->_getSession()->getCustomer()->getId();
    $write = Mage::getSingleton('core/resource')->getConnection('core_write');

    $customer = Mage::getModel('customer/customer')->load($customerId);
    $oldValue = $customer->getDefaultPayment(); // optional, just for checking
    $customer->setDefaultPayment($value);
    $customer->save();

}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。