/**
* @param int[] $params Deleted contact_id
* @see waEventHandler::execute()
* @return void
*/
public function execute(&$params)
{
$contact_ids = $params;
// We need some info about (not yet) deleted contacts to save into order params.
// The idea is to pretend that orders were created by guests with no auth.
$c = new waContactsCollection('id/' . implode(',', $contact_ids));
$contacts = $c->getContacts('name,phone,email');
foreach ($contacts as &$contact) {
if (is_array($contact['phone'])) {
$phone = reset($contact['phone']);
if (is_array($phone)) {
if (isset($phone['value'])) {
$phone = $phone['value'];
} else {
$phone = '';
}
}
$contact['phone'] = $phone;
}
if (is_array($contact['email'])) {
$email = reset($contact['email']);
$contact['email'] = $email;
}
}
$order_model = new shopOrderModel();
$order_params_model = new shopOrderParamsModel();
$product_reviews_model = new shopProductReviewsModel();
foreach ($contacts as $contact) {
// Insert customer info into params of their orders
$order_ids = array_keys($order_model->select('id')->where('contact_id=:contact_id', array('contact_id' => $contact['id']))->fetchAll('id'));
$order_params_model->set($order_ids, $this->extractContactInfo($contact), false);
// Insert contact name into their reviews
$product_reviews_model->updateByField('contact_id', $contact['id'], array('contact_id' => 0, 'name' => $contact['name'], 'auth_provider' => null));
}
// Update orders as if they were created by guests with no auth
$order_model->updateByField('contact_id', $contact_ids, array('contact_id' => null));
// Forget the customer
$scm = new shopCustomerModel();
$scm->deleteById($contact_ids);
// Forget that this user created coupons
$coupm = new shopCouponModel();
$coupm->updateByField('create_contact_id', $contact_ids, array('create_contact_id' => 0));
// !!! TODO: take a look to other models related with contacts
}
public function execute()
{
$fm = new shopFollowupModel();
$opm = new shopOrderParamsModel();
$asm = new waAppSettingsModel();
$olm = new shopOrderLogModel();
$cm = new shopCustomerModel();
$om = new shopOrderModel();
$asm->set('shop', 'last_followup_cli', time());
$view = wa()->getView();
$empty_customer = $cm->getEmptyRow();
$general = wa('shop')->getConfig()->getGeneralSettings();
foreach ($fm->getAllEnabled() as $f) {
$between_from = date('Y-m-d', strtotime($f['last_cron_time']) - 24 * 3600);
$between_to = date('Y-m-d 23:59:59', time() - $f['delay'] - 10 * 3600);
$orders = $om->where('paid_date >= ? AND paid_date < ?', $between_from, $between_to)->fetchAll('id');
if ($orders) {
$f_param_key = 'followup_' . $f['id'];
// Params for all orders with one query
$params = $opm->get(array_keys($orders));
// Customer data for all orders with one query
$cids = array();
foreach ($orders as $o) {
$cids[] = $o['contact_id'];
}
$customers = $cm->getById($cids);
$sent_count = 0;
foreach ($orders as $o) {
try {
// Is there a recipient in the first place?
if (empty($o['contact_id'])) {
if (waSystemConfig::isDebug()) {
waLog::log("Unable to send follow-up #{$f['id']} for order #{$o['id']}: no contact_id");
}
continue;
}
// Check that this is the first order of this customer
if ($f['first_order_only']) {
$first_order_id = $om->select('MIN(id)')->where('contact_id=? AND paid_date IS NOT NULL', $o['contact_id'])->fetchField();
if ($first_order_id != $o['id']) {
if (waSystemConfig::isDebug()) {
waLog::log("Skipping follow-up #{$f['id']} for order #{$o['id']}: not the first order of a customer.");
}
continue;
}
}
$o['params'] = ifset($params[$o['id']], array());
$source = 'backend';
if (!empty($o['params']['storefront'])) {
$source = rtrim($o['params']['storefront'], '/') . '/*';
}
if ($f['source'] && $f['source'] != $source) {
continue;
}
// Make sure we have not send follow-up for this order yet
if (isset($o['params'][$f_param_key])) {
if (waSystemConfig::isDebug()) {
waLog::log("Skipping follow-up #{$f['id']} for order #{$o['id']}: already sent before.");
}
continue;
}
shopHelper::workupOrders($o, true);
// Recipient info
$customer = ifset($customers[$o['contact_id']], $empty_customer);
$contact = new shopCustomer($o['contact_id']);
$email = $contact->get('email', 'default');
// this with throw exception if contact does not exist; that's ok
if (!$email) {
if (waSystemConfig::isDebug()) {
waLog::log("Unable to send follow-up #{$f['id']} for order #{$o['id']}: contact has no email");
}
continue;
}
$to = array($email => $contact->getName());
if (self::sendOne($f, $o, $customer, $contact, $to, $view, $general)) {
$sent_count++;
// Write to order log
$olm->add(array('order_id' => $o['id'], 'contact_id' => null, 'action_id' => '', 'text' => sprintf_wp("Follow-up <strong>%s</strong> (%s) sent to customer.", htmlspecialchars($f['name']), $f['id']), 'before_state_id' => $o['state_id'], 'after_state_id' => $o['state_id']));
// Write to order params
$opm->insert(array('order_id' => $o['id'], 'name' => $f_param_key, 'value' => date('Y-m-d H:i:s')));
} else {
waLog::log("Unable to send follow-up #{$f['id']} for order #{$o['id']}: waMessage->send() returned FALSE.");
}
} catch (Exception $e) {
waLog::log("Unable to send follow-up #{$f['id']} for order #{$o['id']}:\n" . $e);
}
}
/**
* Notify plugins about sending followup
* @event followup_send
* @param array[string]int $params['sent_count'] number of emails successfully sent
* @param array[string]int $params['id'] followup_id
* @return void
*/
$event_params = $f;
$event_params['sent_count'] = $sent_count;
wa()->event('followup_send', $event_params);
}
$fm->updateById($f['id'], array('last_cron_time' => $between_to));
}
}
