public function execute()
{
$form = shopHelper::getCustomerForm();
if ($form->post()) {
$customer_validation_disabled = wa()->getSetting('disable_backend_customer_form_validation');
if ($customer_validation_disabled || $form->isValid()) {
$c = new waContact();
if ($customer_validation_disabled) {
$errors = array();
$c->save($form->post());
} else {
$errors = $c->save($form->post(), true);
}
if (!$errors) {
$scm = new shopCustomerModel();
$scm->createFromContact($c->getId());
echo '<script>$.customers.reloadSidebar(); window.location.hash = "#/id/' . $c->getId() . '"</script>';
exit;
}
// Show errors that waContact returned, e.g. email must be unique.
foreach ($errors as $fld => $list) {
foreach ($list as $err) {
$form->errors($fld, $err);
}
}
}
}
$this->view->assign('form', $form);
$this->view->assign('customer_validation_disabled', wa()->getSetting('disable_backend_customer_form_validation'));
}
public function execute(&$params)
{
$master_id = $params['id'];
$merge_ids = $params['contacts'];
$all_ids = array_merge($merge_ids, array($master_id));
$m = new waModel();
//
// All the simple cases: update contact_id in tables
//
foreach (array(array('shop_cart_items', 'contact_id'), array('shop_checkout_flow', 'contact_id'), array('shop_order', 'contact_id'), array('shop_order_log', 'contact_id'), array('shop_product', 'contact_id'), array('shop_product_reviews', 'contact_id'), array('shop_affiliate_transaction', 'contact_id')) as $pair) {
list($table, $field) = $pair;
$sql = "UPDATE {$table} SET {$field} = :master WHERE {$field} in (:ids)";
$m->exec($sql, array('master' => $master_id, 'ids' => $merge_ids));
}
//
// shop_affiliate_transaction
//
$balance = 0.0;
$sql = "SELECT * FROM shop_affiliate_transaction WHERE contact_id=? ORDER BY id";
foreach ($m->query($sql, $master_id) as $row) {
$balance += $row['amount'];
if ($row['balance'] != $balance) {
$m->exec("UPDATE shop_affiliate_transaction SET balance=? WHERE id=?", $balance, $row['id']);
}
}
$affiliate_bonus = $balance;
//
// shop_customer
//
// Make sure it exists
$cm = new shopCustomerModel();
$cm->createFromContact($master_id);
$sql = "SELECT SUM(number_of_orders) FROM shop_customer WHERE contact_id IN (:ids)";
$number_of_orders = $m->query($sql, array('ids' => $all_ids))->fetchField();
$sql = "SELECT MAX(last_order_id) FROM shop_customer WHERE contact_id IN (:ids)";
$last_order_id = $m->query($sql, array('ids' => $all_ids))->fetchField();
$sql = "UPDATE shop_customer SET number_of_orders=?, last_order_id=?, affiliate_bonus=? WHERE contact_id=?";
$m->exec($sql, ifempty($number_of_orders, 0), ifempty($last_order_id, null), ifempty($affiliate_bonus, 0), $master_id);
if ($number_of_orders) {
shopCustomers::recalculateTotalSpent($master_id);
}
wa('shop')->event('customers_merge', $params);
return null;
}
