/**
* Try to associate reminder rule with matched customers.
* If customer was added earlier, update is_active column.
*
* @param Bronto_Reminder_Model_Rule $rule
* @param null|Mage_SalesRule_Model_Rule $salesRule
* @param int $websiteId
* @param null $threshold
*
* @return $this
* @throws Exception
*/
public function saveMatchedCustomers(Bronto_Reminder_Model_Rule $rule, $salesRule, $websiteId, $threshold = null)
{
$select = $rule->getConditions()->getConditionsSql($rule, $websiteId);
$interval = Mage::helper('bronto_reminder')->getCronInterval();
if (!$rule->getConditionSql()) {
return $this;
}
if ($threshold) {
$select->where('c.emails_failed IS NULL OR c.emails_failed < ? ', $threshold);
}
// Only pull for reminders not already attached to an active record
$select->where('c.is_active IS NULL OR c.is_active <> 1');
// Handle Send Limit
$sendLimit = $rule->getSendLimit();
if ($sendLimit > 0) {
$subSelect = $this->createSelect()->from(array($this->getTable('bronto_reminder/log')), array('num_send' => 'count(log_id)', 'unique_id'))->group(array('unique_id'));
$select->joinLeft(array('l' => $subSelect), 'c.unique_id=l.unique_id', array())->where('l.num_send IS NULL OR l.num_send < ?', $sendLimit);
}
// Handle Send To Value
switch ($rule->getSendTo()) {
case 'user':
$select->where('`root`.`customer_id` IS NOT NULL AND `root`.`customer_id` != 0');
break;
case 'guest':
$select->where('`root`.`customer_id` IS NULL OR `root`.`customer_id` = 0');
break;
case 'both':
default:
// No need to filter
break;
}
$i = 0;
$ruleId = $rule->getId();
$adapter = $this->_getWriteAdapter();
$currentDate = $this->formatDate(time());
$dataToInsert = array();
Mage::helper('bronto_reminder')->writeDebug('ruleId: ' . $rule->getId() . ' website: ' . $websiteId, 'bronto_reminder_sql.log');
// Log the query with binds replaced
$this->logFullQuery($select, array('rule_id' => $ruleId, 'interval' => $interval));
/* @var $stmt Varien_Db_Statement_Pdo_Mysql */
$stmt = $adapter->query($select, array('rule_id' => $ruleId, 'interval' => $interval));
Mage::helper('bronto_reminder')->writeDebug('saveMatchedCustomers():', 'bronto_reminder_sql.log');
try {
$adapter->beginTransaction();
while ($row = $stmt->fetch()) {
if (empty($row['coupon_id']) && $salesRule) {
if ($salesRule->getCouponType() == Mage_SalesRule_Model_Rule::COUPON_TYPE_SPECIFIC && $salesRule->getUseAutoGeneration()) {
$coupons = $salesRule->getCoupons();
if (!$coupons) {
$coupons = array();
}
foreach ($coupons as $couponTemp) {
if ($couponTemp->getUsageLimit() > $couponTemp->getTimesUsed() && (is_null($couponTemp->getExpirationDate()) || $couponTemp->getExpirationDate() > date('Y-m-d H:i:s', mktime(0, 0, 0, date('m'), date('d'), date('Y'))))) {
$coupon = $couponTemp;
}
}
} else {
$coupon = $salesRule->acquireCoupon();
}
$couponId = $coupon !== null ? $coupon->getId() : null;
} else {
$couponId = $row['coupon_id'];
}
$dataToInsert[] = array('rule_id' => $ruleId, 'product_recommendation_id' => $rule->getProductRecommendationId(), 'coupon_id' => $couponId, 'unique_id' => $row['unique_id'], 'store_id' => $row['store_id'], 'customer_id' => $row['customer_id'], 'quote_id' => $row['quote_id'], 'wishlist_id' => $row['wishlist_id'], 'customer_email' => $row['customer_email'], 'associated_at' => $currentDate, 'is_active' => '1');
$i++;
if ($i % 1000 == 0) {
$this->_saveMatchedCustomerData($dataToInsert);
$adapter->commit();
$adapter->beginTransaction();
$dataToInsert = array();
}
}
$this->_saveMatchedCustomerData($dataToInsert);
$adapter->commit();
Mage::helper('bronto_reminder')->writeDebug(" Query Matched {$i} customers", 'bronto_reminder_sql.log');
} catch (Exception $e) {
$adapter->rollBack();
throw $e;
}
return $this;
}
