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();