public function execute()
{
$order_id = waRequest::request('order_id', 0, 'int');
$id = waRequest::request('id', 0, 'int');
$to = waRequest::request('to');
$nm = new shopNotificationModel();
$n = $nm->getById($id);
if (!$n) {
$this->errors = sprintf_wp('%s entry not found', _w('Notification'));
return;
}
$om = new shopOrderModel();
$o = $om->getById($order_id);
if (!$o) {
$this->errors = _w('Order not found');
return;
}
shopHelper::workupOrders($o, true);
$opm = new shopOrderParamsModel();
$o['params'] = $opm->get($order_id);
try {
$contact = $o['contact_id'] ? new shopCustomer($o['contact_id']) : wa()->getUser();
$contact->getName();
} catch (Exception $e) {
$contact = new shopCustomer(wa()->getUser()->getId());
}
$cm = new shopCustomerModel();
$customer = $cm->getById($contact->getId());
if (!$customer) {
$customer = $cm->getEmptyRow();
}
$workflow = new shopWorkflow();
// send notifications
shopNotifications::sendOne($id, array('order' => $o, 'customer' => $contact, 'status' => $workflow->getStateById($o['state_id'])->getName()), $to);
}
public function postExecute($order_id = null, $result = null)
{
$data = parent::postExecute($order_id, $result);
if ($order_id != null) {
$log_model = new waLogModel();
$log_model->add('order_restore', $order_id);
$order_model = new shopOrderModel();
$app_settings_model = new waAppSettingsModel();
if ($this->state_id != 'refunded') {
// for logging changes in stocks
shopProductStocksLogModel::setContext(shopProductStocksLogModel::TYPE_ORDER, 'Order %s was restored', array('order_id' => $order_id));
$update_on_create = $app_settings_model->get('shop', 'update_stock_count_on_create_order');
if ($update_on_create) {
$order_model->reduceProductsFromStocks($order_id);
} else {
if (!$update_on_create && $this->state_id != 'new') {
$order_model->reduceProductsFromStocks($order_id);
}
}
shopProductStocksLogModel::clearContext();
}
$order = $order_model->getById($order_id);
if ($order && $order['paid_date']) {
shopAffiliate::applyBonus($order_id);
shopCustomers::recalculateTotalSpent($order['contact_id']);
}
}
return $data;
}
public function postExecute($order_id = null, $result = null)
{
$data = parent::postExecute($order_id, $result);
$log_model = new waLogModel();
$log_model->add('order_complete', $order_id);
$order_model = new shopOrderModel();
if (is_array($order_id)) {
$order = $order_id;
$order_id = $order['id'];
} else {
$order = $order_model->getById($order_id);
}
shopCustomers::recalculateTotalSpent($order['contact_id']);
if ($order !== null) {
$log_model = new shopOrderLogModel();
$state_id = $log_model->getPreviousState($order_id);
$app_settings_model = new waAppSettingsModel();
$update_on_create = $app_settings_model->get('shop', 'update_stock_count_on_create_order');
if (!$update_on_create && $state_id == 'new') {
// jump through 'processing' state - reduce
// for logging changes in stocks
shopProductStocksLogModel::setContext(shopProductStocksLogModel::TYPE_ORDER, 'Order %s was completed', array('order_id' => $order_id));
$order_model = new shopOrderModel();
$order_model->reduceProductsFromStocks($order_id);
shopProductStocksLogModel::clearContext();
}
$order_model->recalculateProductsTotalSales($order_id);
}
return $data;
}
public function postExecute($order_id = null, $result = null)
{
$data = parent::postExecute($order_id, $result);
if ($order_id != null) {
$log_model = new waLogModel();
$log_model->add('order_delete', $order_id);
$order_model = new shopOrderModel();
$app_settings_model = new waAppSettingsModel();
if ($data['before_state_id'] != 'refunded') {
$update_on_create = $app_settings_model->get('shop', 'update_stock_count_on_create_order');
// for logging changes in stocks
shopProductStocksLogModel::setContext(shopProductStocksLogModel::TYPE_ORDER, 'Order %s was deleted', array('order_id' => $order_id));
if ($update_on_create) {
$order_model->returnProductsToStocks($order_id);
} else {
if (!$update_on_create && $data['before_state_id'] != 'new') {
$order_model->returnProductsToStocks($order_id);
}
}
shopProductStocksLogModel::clearContext();
}
$order = $order_model->getById($order_id);
if ($order && $order['paid_date']) {
// Remember paid_date in log params for Restore action
$olpm = new shopOrderLogParamsModel();
$olpm->insert(array('name' => 'paid_date', 'value' => $order['paid_date'], 'order_id' => $order_id, 'log_id' => $data['id']));
// Empty paid_date and update stats so that deleted orders do not affect reports
$order_model->updateById($order_id, array('paid_date' => null, 'paid_year' => null, 'paid_month' => null, 'paid_quarter' => null));
$order_model->recalculateProductsTotalSales($order_id);
shopCustomers::recalculateTotalSpent($order['contact_id']);
}
}
return $data;
}
public function postExecute($order_id = null, $result = null)
{
if (!$result) {
return;
}
$order_model = new shopOrderModel();
if (is_array($order_id)) {
$order = $order_id;
$order_id = $order['id'];
} else {
$order = $order_model->getById($order_id);
}
$data = is_array($result) ? $result : array();
$data['order_id'] = $order_id;
$data['action_id'] = $this->getId();
$data['before_state_id'] = $order['state_id'];
if ($this->state_id) {
$data['after_state_id'] = $this->state_id;
} else {
$data['after_state_id'] = $order['state_id'];
}
$order_log_model = new shopOrderLogModel();
$data['id'] = $order_log_model->add($data);
$update = isset($result['update']) ? $result['update'] : array();
$update['update_datetime'] = date('Y-m-d H:i:s');
$data['update'] = $update;
if ($this->state_id) {
$update['state_id'] = $this->state_id;
}
$order_model->updateById($order['id'], $update);
$order_params_model = new shopOrderParamsModel();
if (isset($update['params'])) {
$order_params_model->set($order['id'], $update['params'], false);
}
$order['params'] = $order_params_model->get($order_id);
// send notifications
shopNotifications::send('order.' . $this->getId(), array('order' => $order, 'customer' => new waContact($order['contact_id']), 'status' => $this->getWorkflow()->getStateById($data['after_state_id'])->getName(), 'action_data' => $data));
/**
* @event order_action.callback
* @event order_action.pay
* @event order_action.ship
* @event order_action.process
* @event order_action.delete
* @event order_action.restore
* @event order_action.complete
* @event order_action.comment
*
* @param array[string]mixed $data
* @param array[string]int $data['order_id']
* @param array[string]int $data['action_id']
* @param array[string]int $data['before_state_id']
* @param array[string]int $data['after_state_id']
* @param array[string]int $data['id'] Order log record id
*/
wa('shop')->event('order_action.' . $this->getId(), $data);
return $data;
}
public function execute()
{
$items = waRequest::post('items');
$product_ids = array();
foreach ($items as $i) {
$product_ids[] = $i['product_id'];
}
$product_ids = array_unique($product_ids);
$feature_model = new shopFeatureModel();
$f = $feature_model->getByCode('weight');
if (!$f) {
$values = array();
} else {
$values_model = $feature_model->getValuesModel($f['type']);
$values = $values_model->getProductValues($product_ids, $f['id']);
}
$contact = $this->getContact();
$shipping_address = $contact->getFirst('address.shipping');
if ($shipping_address) {
$shipping_address = $shipping_address['data'];
}
$shipping_items = array();
foreach ($items as $i) {
if (isset($values['skus'][$i['sku_id']])) {
$w = $values['skus'][$i['sku_id']];
} else {
$w = isset($values[$i['product_id']]) ? $values[$i['product_id']] : 0;
}
$shipping_items[] = array('name' => '', 'price' => $i['price'], 'quantity' => $i['quantity'], 'weight' => $w);
}
$order_id = waRequest::post('order_id');
if ($order_id) {
$order_model = new shopOrderModel();
$order_info = $order_model->getById($order_id);
$currency = $order_info['currency'];
} else {
$currency = $this->getConfig()->getCurrency();
}
$total = waRequest::post('subtotal') - waRequest::post('discount');
$order = array('currency' => $currency, 'contact' => $contact, 'items' => $items, 'total' => waRequest::post('subtotal'));
if ($order_id) {
$order['id'] = $order_info['id'];
}
$this->response['discount'] = shopDiscounts::calculate($order_info);
$this->response['shipping_methods'] = shopHelper::getShippingMethods($shipping_address, $shipping_items, array('currency' => $currency, 'total_price' => $total));
// for saving order in js
$this->response['shipping_method_ids'] = array_keys($this->response['shipping_methods']);
}
public function execute()
{
$order_id = waRequest::request('order_id', 0, 'int');
$followup_id = waRequest::request('followup_id', 0, 'int');
$email = waRequest::request('email');
$fm = new shopFollowupModel();
$f = $fm->getById($followup_id);
if (!$f) {
$this->errors = sprintf_wp('%s entry not found', _w('Follow-up'));
return;
}
$om = new shopOrderModel();
$o = $om->getById($order_id);
if (!$o) {
$this->errors = _w('Order not found');
return;
}
shopHelper::workupOrders($o, true);
$opm = new shopOrderParamsModel();
$o['params'] = $opm->get($order_id);
try {
$contact = $o['contact_id'] ? new shopCustomer($o['contact_id']) : wa()->getUser();
$contact->getName();
} catch (Exception $e) {
$contact = new shopCustomer(wa()->getUser()->getId());
}
$cm = new shopCustomerModel();
$customer = $cm->getById($contact->getId());
if (!$customer) {
$customer = $cm->getEmptyRow();
}
$to = array($email => $contact->getName());
if (!shopFollowupCli::sendOne($f, $o, $customer, $contact, $to)) {
$this->errors = "Unable to send follow-up #{$f['id']} for order #{$o['id']}: waMessage->send() returned FALSE.";
return;
}
$this->response = 'ok';
}
public function postExecute($order_id = null, $result = null)
{
$data = parent::postExecute($order_id, $result);
$order_model = new shopOrderModel();
if (is_array($order_id)) {
$order = $order_id;
$order_id = $order['id'];
} else {
$order = $order_model->getById($order_id);
}
shopCustomers::recalculateTotalSpent($order['contact_id']);
if ($order_id != null) {
$log_model = new waLogModel();
$log_model->add('order_refund', $order_id);
$order_model = new shopOrderModel();
$order_model->updateById($order_id, array('paid_date' => null, 'paid_year' => null, 'paid_month' => null, 'paid_quarter' => null));
// for logging changes in stocks
shopProductStocksLogModel::setContext(shopProductStocksLogModel::TYPE_ORDER, 'Order %s was refunded', array('order_id' => $order_id));
$order_model->returnProductsToStocks($order_id);
shopAffiliate::cancelBonus($order_id);
$order_model->recalculateProductsTotalSales($order_id);
}
return $data;
}
public function execute($data = null)
{
$order_model = new shopOrderModel();
$order = $order_model->getById($data['id']);
$subtotal = 0;
$services = $products = array();
foreach ($data['items'] as $item) {
if ($item['service_id']) {
$services[] = $item['service_id'];
} else {
$products[] = $item['product_id'];
}
}
$service_model = new shopServiceModel();
$product_model = new shopProductModel();
$services = $service_model->getById($services);
$products = $product_model->getById($products);
foreach ($data['items'] as &$item) {
$item['currency'] = $order['currency'];
$item['price'] = $this->price($item['price']);
if ($item['service_id']) {
$item['service'] = $services[$item['service_id']];
} else {
$item['product'] = $products[$item['product_id']];
}
$subtotal += $item['price'] * $item['quantity'];
}
unset($item);
foreach (array('shipping', 'discount') as $k) {
if (!isset($data[$k])) {
$data[$k] = 0;
}
}
$contact = new waContact($order['contact_id']);
$shipping_address = $contact->getFirst('address.shipping');
if (!$shipping_address) {
$shipping_address = $contact->getFirst('address');
}
$shipping_address = $shipping_address ? $shipping_address['data'] : array();
$billing_address = $contact->getFirst('address.billing');
if (!$billing_address) {
$billing_address = $contact->getFirst('address');
}
$billing_address = $billing_address ? $billing_address['data'] : array();
$discount_rate = $subtotal ? $data['discount'] / $subtotal : 0;
$taxes = shopTaxes::apply($data['items'], array('shipping' => $shipping_address, 'billing' => $billing_address, 'discount_rate' => $discount_rate), $order['currency']);
$tax = $tax_included = 0;
foreach ($taxes as $t) {
if (isset($t['sum'])) {
$tax += $t['sum'];
}
if (isset($t['sum_included'])) {
$tax_included += $t['sum_included'];
}
}
$data['tax'] = $tax_included + $tax;
$data['total'] = $subtotal + $tax + $this->price($data['shipping']) - $this->price($data['discount']);
// for logging changes in stocks
shopProductStocksLogModel::setContext(shopProductStocksLogModel::TYPE_ORDER, 'Order %s was edited', array('order_id' => $data['id']));
// update
$order_model->update($data, $data['id']);
$log_model = new waLogModel();
$log_model->add('order_edit', $data['id']);
shopProductStocksLogModel::clearContext();
if (!empty($data['params'])) {
$params_model = new shopOrderParamsModel();
$params_model->set($data['id'], $data['params'], false);
}
return true;
}
public function postExecute($order_id = null, $result = null)
{
$order_id = $result['order_id'];
$data = is_array($result) ? $result : array();
$data['order_id'] = $order_id;
$data['action_id'] = $this->getId();
$data['before_state_id'] = '';
$data['after_state_id'] = 'new';
$order_log_model = new shopOrderLogModel();
$order_log_model->add($data);
/**
* @event order_action.create
*/
wa('shop')->event('order_action.create', $data);
$order_model = new shopOrderModel();
$order = $order_model->getById($order_id);
$params_model = new shopOrderParamsModel();
$order['params'] = $params_model->get($order_id);
// send notifications
shopNotifications::send('order.' . $this->getId(), array('order' => $order, 'customer' => new waContact($order['contact_id']), 'status' => $this->getWorkflow()->getStateById($data['after_state_id'])->getName(), 'action_data' => $data));
// Update stock count, but take into account 'update_stock_count_on_create_order'-setting
$app_settings_model = new waAppSettingsModel();
if ($app_settings_model->get('shop', 'update_stock_count_on_create_order')) {
// for logging changes in stocks
shopProductStocksLogModel::setContext(shopProductStocksLogModel::TYPE_ORDER, 'Order %s was placed', array('order_id' => $order_id));
$order_model->reduceProductsFromStocks($order_id);
shopProductStocksLogModel::clearContext();
}
return $order_id;
}
private function _getOrderData($order_id)
{
$order_model = new shopOrderModel();
$order = $order_model->getById($order_id);
if (!$order) {
return false;
}
$order_items_model = new shopOrderItemsModel();
$items_res = $order_items_model->getByField('order_id', $order_id, true);
$items = array();
$total_price = 0;
$sku_model = new shopProductSkusModel();
$ret = new stdClass();
foreach ($items_res as $product) {
$skus = $sku_model->getDataByProductId($product['product_id']);
$product['product'] = reset($skus);
$product_id = $product['product_id'];
if ($product['sku_id'] != $product['product']['id']) {
$product_id .= 's' . $product['sku_id'];
}
$items[] = array('product_id' => $product_id, 'qnt' => $product['quantity'], 'price' => $product['price'], 'product_name' => $product['name']);
$total_price = $total_price + $product['price'] * $product['quantity'];
}
$ret->order_id = $order_id;
$ret->items = $items;
$ret->revenue = $total_price;
$ret->state = $this->_switchState($order['state_id']);
$ret->order = $order;
return $ret;
}
public function execute()
{
$steps = $this->getConfig()->getCheckoutSettings();
$current_step = waRequest::param('step', waRequest::request('step'));
if (!$current_step) {
$current_step = key($steps);
}
$title = _w('Checkout');
if ($current_step == 'success') {
$order_id = waRequest::get('order_id');
if (!$order_id) {
$order_id = wa()->getStorage()->get('shop/order_id');
$payment_success = false;
} else {
$payment_success = true;
$this->view->assign('payment_success', true);
}
if (!$order_id) {
wa()->getResponse()->redirect(wa()->getRouteUrl('shop/frontend'));
}
$order_model = new shopOrderModel();
$order = $order_model->getById($order_id);
if ($order) {
$order['_id'] = $order['id'];
}
if (!$payment_success) {
$order_params_model = new shopOrderParamsModel();
$order['params'] = $order_params_model->get($order_id);
$order_items_model = new shopOrderItemsModel();
$order['items'] = $order_items_model->getByField('order_id', $order_id, true);
$payment = '';
if (!empty($order['params']['payment_id'])) {
try {
/**
* @var waPayment $plugin
*/
$plugin = shopPayment::getPlugin(null, $order['params']['payment_id']);
$payment = $plugin->payment(waRequest::post(), shopPayment::getOrderData($order, $plugin), true);
} catch (waException $ex) {
$payment = $ex->getMessage();
}
}
$order['id'] = shopHelper::encodeOrderId($order_id);
$this->getResponse()->addGoogleAnalytics($this->getGoogleAnalytics($order));
} else {
$order['id'] = shopHelper::encodeOrderId($order_id);
}
$this->view->assign('order', $order);
if (isset($payment)) {
$this->view->assign('payment', $payment);
}
} else {
$cart = new shopCart();
if (!$cart->count() && $current_step != 'error') {
$current_step = 'error';
$this->view->assign('error', _w('Your shopping cart is empty. Please add some products to cart, and then proceed to checkout.'));
}
if ($current_step != 'error') {
if (waRequest::method() == 'post') {
if (waRequest::post('wa_auth_login')) {
$login_action = new shopLoginAction();
$login_action->run();
} else {
$redirect = false;
foreach ($steps as $step_id => $step) {
if ($step_id == $current_step) {
$step_instance = $this->getStep($step_id);
if ($step_instance->execute()) {
$redirect = true;
}
} elseif ($redirect) {
$this->redirect(wa()->getRouteUrl('/frontend/checkout', array('step' => $step_id)));
}
}
// last step
if ($redirect) {
if ($this->createOrder()) {
$this->redirect(wa()->getRouteUrl('/frontend/checkout', array('step' => 'success')));
}
}
}
} else {
$this->view->assign('error', '');
}
$title .= ' - ' . $steps[$current_step]['name'];
$steps[$current_step]['content'] = $this->getStep($current_step)->display();
$this->view->assign('checkout_steps', $steps);
}
}
$this->getResponse()->setTitle($title);
$this->view->assign('checkout_current_step', $current_step);
/**
* @event frontend_checkout
* @return array[string]string $return[%plugin_id%] html output
*/
$event_params = array('step' => $current_step);
$this->view->assign('frontend_checkout', wa()->event('frontend_checkout', $event_params));
if (waRequest::isXMLHttpRequest()) {
$this->setThemeTemplate('checkout.' . $current_step . '.html');
} else {
$this->setLayout(new shopFrontendLayout());
$this->setThemeTemplate('checkout.html');
}
}
/**
* @param array $transaction_data
* @return array
*/
public function callbackConfirmationHandler($transaction_data)
{
$result = $this->workflowAction('callback', $transaction_data);
if (empty($result['error'])) {
$order_model = new shopOrderModel();
$order = $order_model->getById($transaction_data['order_id']);
$result['result'] = true;
$total = $transaction_data['amount'];
if ($transaction_data['currency_id'] != $order['currency']) {
$total = shop_currency($total, $transaction_data['currency_id'], $order['currency'], false);
}
if (abs($order['total'] - $total) > 0.01) {
$result['result'] = false;
$result['error'] = sprintf('Invalid order amount: expect %f, but get %f', $order['total'], $total);
} else {
$workflow = new shopWorkflow();
$workflow->getActionById('process')->run($transaction_data['order_id']);
}
}
return $result;
}
/**
* Update items of order
* Also update stock counts if it's necessary
*
* @param array $items
* @param int $order_id
*/
public function update($items, $order_id)
{
$old_items = $this->getByField('order_id', $order_id, 'id');
$add = array();
$update = array();
$sku_stock = array();
$parent_id = null;
foreach ($items as $item) {
// new item insert
if (empty($item['id']) || empty($old_items[$item['id']])) {
$item['order_id'] = $order_id;
if ($item['type'] == 'product') {
$parent_id = $this->insert($item);
} else {
$item['parent_id'] = $parent_id;
$add[] = $item;
}
// stock count
if ($item['type'] == 'product') {
if (!isset($sku_stock[$item['sku_id']][$item['stock_id']])) {
$sku_stock[$item['sku_id']][$item['stock_id']] = 0;
}
$sku_stock[$item['sku_id']][$item['stock_id']] -= $item['quantity'];
}
} else {
// edit old item
$item_id = $item['id'];
$old_item = $old_items[$item_id];
if ($old_item['type'] == 'product') {
$parent_id = $item_id;
} else {
$item['parent_id'] = $parent_id;
}
$item['price'] = $this->castValue('float', $item['price']);
$old_item['price'] = (double) $old_item['price'];
$diff = array_diff_assoc($item, $old_item);
// check stock changes
if ($item['type'] == 'product') {
if (isset($diff['stock_id']) || isset($diff['sku_id'])) {
if (!isset($sku_stock[$old_item['sku_id']][$old_item['stock_id']])) {
$sku_stock[$old_item['sku_id']][$old_item['stock_id']] = 0;
$sku_stock[$item['sku_id']][$item['stock_id']] = 0;
}
$sku_stock[$old_item['sku_id']][$old_item['stock_id']] += $old_item['quantity'];
$sku_stock[$item['sku_id']][$item['stock_id']] -= $item['quantity'];
} else {
if (isset($diff['quantity'])) {
if (!isset($sku_stock[$item['sku_id']][$item['stock_id']])) {
$sku_stock[$item['sku_id']][$item['stock_id']] = 0;
}
$sku_stock[$item['sku_id']][$item['stock_id']] += $old_item['quantity'] - $item['quantity'];
}
}
}
if (!empty($diff)) {
$update[$item_id] = $diff;
}
unset($old_items[$item_id]);
}
}
foreach ($update as $item_id => $item) {
$this->updateById($item_id, $item);
}
if ($add) {
$this->multipleInsert($add);
}
if ($old_items) {
foreach ($old_items as $old_item) {
$sku_stock[$old_item['sku_id']][$old_item['stock_id']] = $old_item['quantity'];
}
$this->deleteById(array_keys($old_items));
}
// Update stock count, but take into account 'update_stock_count_on_create_order'-setting and order state
$order_model = new shopOrderModel();
$order = $order_model->getById($order_id);
$app_settings_model = new waAppSettingsModel();
$update_on_create = $app_settings_model->get('shop', 'update_stock_count_on_create_order');
if ($order['state_id'] != 'new' || $update_on_create) {
$this->updateStockCount($sku_stock);
}
}
