Magento设置所有用户订阅新闻代码

最新推荐文章于 2021-07-14 11:43:02 发布

原创最新推荐文章于 2021-07-14 11:43:02 发布 · 418 阅读

0 ·

CC 4.0 BY-SA版权

Magento 专栏收录该内容

133 篇文章

订阅专栏

本文介绍了一种批量处理电商平台用户，确保他们订阅新闻功能的方法。通过SQL查询获取所有用户email，进一步验证用户是否已订阅新闻。对于未订阅的用户，系统自动完成订阅流程，包括设置状态和确认代码。

<?php

define('MAGENTO', realpath(dirname(__FILE__)));
require_once MAGENTO . '/app/Mage.php';
umask(0);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);


//


//1.通过SQL获取所有的用户email
$sql = "SELECT entity_id,email FROM customer_entity";
$handle = Mage::getSingleton('core/resource')->getConnection('core_write');
$query = $handle->query($sql);
while ($row = $query->fetch()) {
  	//2.根据email查询newsletter_subscriber表是否存在(用户是否订阅新闻)
  	$sql2 = "select subscriber_email from  newsletter_subscriber where subscriber_email= '".$row['email']."'";
  	$handle2 = Mage::getSingleton('core/resource')->getConnection('core_write');
  	$query2 = $handle2->query($sql2);

  	if ($query2->fetch() === false) { //如果在newsletter_subscriber表里没有查到就表示该用户没有订阅新闻
 
  		//设置用户订阅新闻
  		$subscriber = Mage::getModel('newsletter/subscriber')->loadByEmail($row['email']); 
  		$subscriber->setStatus(Mage_Newsletter_Model_Subscriber::STATUS_SUBSCRIBED); 
  		$subscriber->setSubscriberEmail($row['email']); 
  		$subscriber->setSubscriberConfirmCode($subscriber->RandomSequence()); 
  		$subscriber->setStoreId(1); //Mage::app()->getStore()->getId() 
  		$subscriber->setCustomerId($row['entity_id']); 
  		$subscriber->save();
  	}
}