function fn_ga_get_order_status_sign($order_status)
{
$sign = '-';
if (!empty($order_status)) {
$paid_statuses = fn_get_order_paid_statuses();
if (in_array($order_status, $paid_statuses)) {
$sign = '';
}
}
return $sign;
}
/**
* Return order/orders info after the order placing
* @param int $order_id
* @param array $response
*/
public static function returnPlacedOrders($order_id, &$response, $items_per_page, $lang_code)
{
$order = self::getOrderInfo($order_id);
$_error = false;
$status = db_get_field('SELECT status FROM ?:orders WHERE order_id=?i', $order_id);
if ($status == STATUS_PARENT_ORDER) {
$child_orders = db_get_hash_single_array("SELECT order_id, status FROM ?:orders WHERE parent_order_id = ?i", array('order_id', 'status'), $order_id);
$status = reset($child_orders);
$order['child_orders'] = array_keys($child_orders);
}
if (!in_array($status, fn_get_order_paid_statuses())) {
$_error = true;
if ($status != 'B') {
if (!empty($child_orders)) {
array_unshift($child_orders, $order_id);
} else {
$child_orders = array();
$child_orders[] = $order_id;
}
$order_id_field = $status == 'N' ? 'processed_order_id' : 'failed_order_id';
$_SESSION['cart'][$order_id_field] = $child_orders;
$cart =& $_SESSION['cart'];
if (!empty($cart['failed_order_id'])) {
$_ids = !empty($cart['failed_order_id']) ? $cart['failed_order_id'] : $cart['processed_order_id'];
$_order_id = reset($_ids);
$_payment_info = db_get_field("SELECT data\n FROM ?:order_data\n WHERE order_id = ?i AND type = 'P'", $_order_id);
if (!empty($_payment_info)) {
$_payment_info = unserialize(fn_decrypt_text($_payment_info));
}
$_msg = !empty($_payment_info['reason_text']) ? $_payment_info['reason_text'] : '';
$_msg .= empty($_msg) ? __('text_order_placed_error') : '';
$response->addError('ERROR_FAIL_POST_ORDER', $_msg);
$cart['processed_order_id'] = $cart['failed_order_id'];
unset($cart['failed_order_id']);
} elseif (!fn_twg_set_internal_errors($response, 'ERROR_FAIL_POST_ORDER')) {
$response->addError('ERROR_FAIL_POST_ORDER', __('fail_post_order', $lang_code));
}
} else {
if (!fn_twg_set_internal_errors($response, 'ERROR_ORDER_BACKORDERED')) {
$response->addError('ERROR_ORDER_BACKORDERED', __('text_order_backordered', $lang_code));
}
}
$response->returnResponse();
}
$auth =& $_SESSION['auth'];
$user = fn_get_user_info($auth['user_id']);
$profile_points = !empty($user['points']) ? $user['points'] : 0;
if (empty($order['child_orders'])) {
$response->setData(array('order' => $order, 'profile_points' => $profile_points));
} else {
$params = array();
if (empty($auth['user_id'])) {
$params['order_id'] = $auth['order_ids'];
} else {
$params['user_id'] = $auth['user_id'];
}
list($orders, , $totals) = fn_get_orders($params, $items_per_page, true);
$response->setMeta(!empty($totals['gross_total']) ? $totals['gross_total'] : 0, 'gross_total');
$response->setMeta(!empty($totals['totally_paid']) ? $totals['totally_paid'] : 0, 'totally_paid');
$response->setMeta($order, 'order');
$response->setResponseList(TwigmoOrder::getOrdersAsApiList($orders, $lang_code));
$response->setData($profile_points, 'profile_points');
$pagination_params = array('items_per_page' => !empty($items_per_page) ? $items_per_page : TWG_RESPONSE_ITEMS_LIMIT, 'page' => !empty($_REQUEST['page']) ? $_REQUEST['page'] : 1);
fn_twg_set_response_pagination($response, $pagination_params);
}
}
function fn_order_placement_routines($action = '', $order_id = 0, $force_notification = array(), $clear_cart = true, $area = AREA)
{
if (Embedded::isLeft() && !Embedded::isEnabled()) {
Embedded::enable();
}
if ($action == 'checkout_redirect') {
if ($area == 'A') {
fn_redirect("order_management.edit?order_id=" . reset($_SESSION['cart']['processed_order_id']));
} else {
fn_redirect('checkout.checkout');
}
} elseif (in_array($action, array('save', 'repay', 'route')) && !empty($order_id)) {
$order_info = fn_get_order_info($order_id, true);
$display_notification = true;
fn_set_hook('placement_routines', $order_id, $order_info, $force_notification, $clear_cart, $action, $display_notification);
if (!empty($_SESSION['cart']['placement_action'])) {
if (empty($action)) {
$action = $_SESSION['cart']['placement_action'];
}
unset($_SESSION['cart']['placement_action']);
}
if ($area == 'C' && !empty($order_info['user_id'])) {
$__fake = '';
fn_save_cart_content($__fake, $order_info['user_id']);
}
$edp_data = fn_generate_ekeys_for_edp(array(), $order_info);
fn_order_notification($order_info, $edp_data, $force_notification);
$_error = false;
if ($action == 'save') {
if ($display_notification) {
fn_set_notification('N', __('congratulations'), __('text_order_saved_successfully'));
}
} else {
if ($order_info['status'] == STATUS_PARENT_ORDER) {
$child_orders = db_get_hash_single_array("SELECT order_id, status FROM ?:orders WHERE parent_order_id = ?i", array('order_id', 'status'), $order_id);
$status = reset($child_orders);
$child_orders = array_keys($child_orders);
} else {
$status = $order_info['status'];
}
if (in_array($status, fn_get_order_paid_statuses())) {
if ($action == 'repay') {
fn_set_notification('N', __('congratulations'), __('text_order_repayed_successfully'));
} else {
fn_set_notification('N', __('order_placed'), __('text_order_placed_successfully'));
}
} elseif ($status == STATUS_BACKORDERED_ORDER) {
fn_set_notification('W', __('important'), __('text_order_backordered'));
} else {
if ($area == 'A' || $action == 'repay') {
if ($status != STATUS_CANCELED_ORDER) {
$_payment_info = db_get_field("SELECT data FROM ?:order_data WHERE order_id = ?i AND type = 'P'", $order_id);
if (!empty($_payment_info)) {
$_payment_info = unserialize(fn_decrypt_text($_payment_info));
$_msg = !empty($_payment_info['reason_text']) ? $_payment_info['reason_text'] : '';
$_msg .= empty($_msg) ? __('text_order_placed_error') : '';
fn_set_notification('E', '', $_msg);
}
}
} else {
$_error = true;
if (!empty($child_orders)) {
array_unshift($child_orders, $order_id);
} else {
$child_orders = array();
$child_orders[] = $order_id;
}
$_SESSION['cart'][$status == STATUS_INCOMPLETED_ORDER ? 'processed_order_id' : 'failed_order_id'] = $child_orders;
}
if ($status == STATUS_INCOMPLETED_ORDER || $action == 'repay' && $status == STATUS_CANCELED_ORDER) {
fn_set_notification('W', __('important'), __('text_transaction_cancelled'));
}
}
}
// Empty cart
if ($clear_cart == true && $_error == false) {
$_SESSION['cart'] = array('user_data' => !empty($_SESSION['cart']['user_data']) ? $_SESSION['cart']['user_data'] : array(), 'profile_id' => !empty($_SESSION['cart']['profile_id']) ? $_SESSION['cart']['profile_id'] : 0, 'user_id' => !empty($_SESSION['cart']['user_id']) ? $_SESSION['cart']['user_id'] : 0);
$_SESSION['shipping_rates'] = array();
unset($_SESSION['shipping_hash']);
db_query('DELETE FROM ?:user_session_products WHERE session_id = ?s AND type = ?s', Session::getId(), 'C');
}
fn_set_hook('order_placement_routines', $order_id, $force_notification, $order_info, $_error);
if ($area == 'A') {
fn_redirect("orders.details?order_id={$order_id}");
} else {
fn_redirect('checkout.' . ($_error ? 'checkout' : "complete?order_id={$order_id}"));
}
} elseif ($action == 'index_redirect') {
fn_redirect(fn_url('', 'C', 'http'));
} else {
fn_redirect(fn_url($action, 'C', 'http'));
}
}
function fn_process_paypal_ipn($order_id, $data)
{
$order_info = fn_get_order_info($order_id);
if (!empty($order_info) && !empty($data['txn_id']) && (empty($order_info['payment_info']['txn_id']) || $data['payment_status'] != 'Completed' || $data['payment_status'] == 'Completed' && $order_info['payment_info']['txn_id'] !== $data['txn_id'])) {
//Can't check refund transactions.
if (isset($data['txn_type']) && !fn_validate_paypal_order_info($data, $order_info)) {
return false;
}
$pp_settings = fn_get_paypal_settings();
fn_clear_cart($cart, true);
$customer_auth = fn_fill_auth(array(), array(), false, 'C');
fn_form_cart($order_id, $cart, $customer_auth);
if ($pp_settings['override_customer_info'] == 'Y') {
$cart['user_data'] = fn_paypal_get_customer_info($data);
}
$cart['order_id'] = $order_id;
$cart['payment_info'] = $order_info['payment_info'];
$cart['payment_info']['protection_eligibility'] = !empty($data['protection_eligibility']) ? $data['protection_eligibility'] : '';
$cart['payment_id'] = $order_info['payment_id'];
if (!empty($data['memo'])) {
//Save customer notes
$cart['notes'] = $data['memo'];
}
if ($data['payment_status'] == 'Completed') {
//save uniq ipn id to avoid double ipn processing
$cart['payment_info']['txn_id'] = $data['txn_id'];
}
if (!empty($data['payer_email'])) {
$cart['payment_info']['customer_email'] = $data['payer_email'];
}
if (!empty($data['payer_id'])) {
$cart['payment_info']['client_id'] = $data['payer_id'];
}
//Sometimes, for some reasons cart_id in product products calculated incorrectle, so we need recalculate it.
$cart['change_cart_products'] = true;
fn_calculate_cart_content($cart, $customer_auth);
$cart['payment_info']['order_status'] = $pp_settings['pp_statuses'][strtolower($data['payment_status'])];
list($order_id, ) = fn_update_order($cart, $order_id);
if ($order_id) {
fn_change_order_status($order_id, $pp_settings['pp_statuses'][strtolower($data['payment_status'])]);
if (in_array($pp_settings['pp_statuses'][strtolower($data['payment_status'])], fn_get_order_paid_statuses())) {
db_query('DELETE FROM ?:user_session_products WHERE order_id = ?i AND type = ?s', $order_id, 'C');
}
if (fn_allowed_for('MULTIVENDOR')) {
$child_order_ids = db_get_fields("SELECT order_id FROM ?:orders WHERE parent_order_id = ?i", $order_id);
if (!empty($child_order_ids)) {
foreach ($child_order_ids as $child_order_id) {
fn_update_order_payment_info($child_order_id, $cart['payment_info']);
}
}
}
}
return true;
}
}
function fn_quickbooks_export_payments($orders, &$export)
{
$exists_order_complete = false;
$payments = array();
$payments[] = "!TRNS\tTRNSTYPE\tDATE\tACCNT\tNAME\tAMOUNT\tPAYMETH\tDOCNUM";
$payments[] = "!SPL\tTRNSTYPE\tDATE\tACCNT\tNAME\tAMOUNT\tDOCNUM";
$payments[] = "!ENDTRNS\t";
$trns = "TRNS\tPAYMENT\t%s\tUndeposited Funds\t\"%s, %s\"\t%01.2f\t%s\t%d";
$spl = "SPL\tPAYMENT\t%s\tAccounts Receivable\t\"%s, %s\"\t%01.2f\t%d";
foreach ($orders as $order) {
if (in_array($order['status'], fn_get_order_paid_statuses())) {
$order_date = fn_date_format($order['timestamp'], "%m/%d/%Y");
$payments[] = sprintf($trns, $order_date, fn_quickbooks_escape_field($order['b_lastname']), fn_quickbooks_escape_field($order['b_firstname']), $order['total'], $order['payment_method']['payment'], $order['order_id']);
$payments[] = sprintf($spl, $order_date, fn_quickbooks_escape_field($order['b_lastname']), fn_quickbooks_escape_field($order['b_firstname']), -$order['total'], $order['order_id']);
$payments[] = "ENDTRNS\t";
$exists_order_complete = true;
}
}
if ($exists_order_complete) {
$payments[] = '';
$export = array_merge($export, $payments);
}
return true;
}
