while ($row = tep_db_fetch_array($voucher_result)) {
$vouchers[] = $row;
}
}
}
} elseif ($source == Order::ORDER_TYPE_SALES_PARTNER) {
use_class('jng_sp');
use_class('jng_sp_customers');
$class_sp = new jng_sp();
$class_jcust = new jng_sp_customers();
$order_object = new Order(Order::ORDER_TYPE_SALES_PARTNER, $order_id);
$order = $class_jo->retrieveDetail($order_id);
$sp_detail = $class_sp->retrieveDetail($order['jng_sp_id']);
$customer = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);
if (is_null($customer)) {
$customer_ids = $class_jcust->getFromOrder($order['jng_sp_orders_id']);
$customer = $class_jcust->retrieveDetail($customer_ids['customer_billing_id']);
}
$order['amount_discount'] = 0;
$order_int_comments = $class_jo->retrieveComments($order_id);
$comments = $class_jo->drawComments($order_int_comments, 'Internal Comments', 'h2');
$items = $class_jo->retrieveItems($order_id);
$items_colname_id = 'jng_sp_orders_items_id';
$items_colname_price = 'price';
$items_colname_qty = 'order_quantity';
foreach ($items as $ikey => $i) {
$items[$ikey]['return_qty'] = 0;
$returns = $class_jo->retrieveReturnItem($i['jng_sp_orders_items_id']);
if (!is_null($returns)) {
foreach ($returns as $r) {
$items[$ikey]['return_qty'] += $r['return_quantity'];
$subject = 'IMPORTANT & URGENT: Import Order from Tradebyte Failed';
$send_message = 'Manobo FAILED TO LOCATE BELOW FILE: ';
$send_message .= '<br />' . $xml_filename;
$send_message .= '<br /><br />Please check root cause and make sure new orders are imported!';
tep_mail(EMAIL_NAME_DEBUGR, EMAIL_ADDRESS_DEBUGR, $subject, $send_message, FROM_EMAIL_NAME, FROM_EMAIL_ADDRESS, false);
$file_not_exist[] = $xml_filename;
}
$orders_created_total = count($orders_created);
if ($orders_created_total > 0) {
//SP handle by Tradebyte needs no confirmation,
//so mark orders as confirmed directly
$class_jo->confirmOrders($orders_created, $import_date);
logThis(" = Auto confirm new orders");
//Grab customers data from new orders and sync to existing SP customers data
foreach ($orders_created as $orders_id) {
$class_jcust->getFromOrder($orders_id);
}
}
}
$orders_prepayment_paid_total = count($orders_prepayment_paid);
$orders_canceled_total = count($orders_canceled);
if (!$zade_prepayment_need_refreshed) {
$zade_prepayment_need_refreshed = $orders_prepayment_paid_total > 0 || $orders_canceled_total > 0;
}
//REFRESH STOCK BOOKING FOR ZALANDO PREPAYMENT ORDERS
if ($zade_prepayment_need_refreshed) {
zadeRefreshPrepaymentBooking();
logThis("Zalando Prepayment Booking is refreshed!");
}
//log summary of import process
logThis('SUMMARY:');
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('jng_sp_customers');
$class_jcust = new jng_sp_customers();
$last_order_processed = 0;
$q = tep_db_query("SELECT jng_sp_orders_id FROM jng_sp_orders WHERE jng_sp_orders_id>{$last_order_processed}");
while ($row = tep_db_fetch_array($q)) {
$last_order_id = $row['jng_sp_orders_id'];
$class_jcust->getFromOrder($last_order_id);
}
echo 'Last order id processed is <strong>' . $last_order_id . '</strong>';
tep_db_close();
