/** * 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; }
/** * Determine if the coupon on quote is one of the generated coupon code * for this passed salesrule/rule object. Returns null when no coupon is found * matching the coupon on the quote. * * @param Mage_SalesRule_Model_Rule * @param string * @return string | null */ protected function getCodeFromCouponPool(Mage_SalesRule_Model_Rule $rule, $codeAppliedToQuote) { /** @var Mage_SalesRule_Model_Coupon[] */ $coupons = $rule->getCoupons(); foreach ($coupons as $coupon) { if ($coupon->getCode() === $codeAppliedToQuote) { return $codeAppliedToQuote; } } return null; }