//TODO: new method using new email template
//or maybe it is not needed after using new email template
//(already inform open amount)
}
//QUERY ORDERS
$query = "SELECT '" . Order::ORDER_TYPE_JULIE_GRACE . "' AS order_type" . ", o.customers_name, o.customers_email_address" . ", o.orders_id, o.orders_no, o.currency, o.date_purchased AS order_date" . ", op.status, ope.status AS last_status" . ", MAX(ope.last_sent_date) AS last_sent_date" . ", MAX(ope.sent_count) AS sent_count" . " FROM orders o" . " INNER JOIN orders_products op ON op.orders_id = o.orders_id" . " LEFT JOIN orders_products_email ope" . " ON ope.orders_products_id = op.orders_products_id AND ope.type = 'J'" . " WHERE o.payment_method LIKE '" . PAYMENT_METHOD_BANK_TRANSFER . "'" . " AND o.paid_status = 0 AND op.status = 1" . " GROUP BY o.orders_id" . " UNION ALL" . " SELECT '" . Order::ORDER_TYPE_SALES_PARTNER . "' AS order_type" . ", CONCAT(" . " jo.customer_billing_firstname, ' ', jo.customer_billing_lastname" . " ) AS customers_name" . ", jo.customer_billing_email AS customers_email_address" . ", jo.jng_sp_orders_id AS orders_id, jo.order_id AS orders_no" . ", 'EUR' AS currency, jo.order_date" . ", joi.status, ope.status AS last_status" . ", MAX(ope.last_sent_date) AS last_sent_date" . ", MAX(ope.sent_count) AS sent_count" . " FROM jng_sp_orders jo" . " INNER JOIN jng_sp_orders_items joi" . " ON joi.jng_sp_orders_id = jo.jng_sp_orders_id" . " LEFT JOIN orders_products_email ope" . " ON ope.orders_products_id = joi.jng_sp_orders_items_id" . " AND ope.type = 'S'" . " WHERE jo.jng_sp_id IN (" . implode(',', $sp_need_reminder) . ")" . " AND jo.payment_method LIKE '" . PAYMENT_METHOD_PREPAYMENT . "'" . " AND IFNULL(jo.payment_status,0) = 0 AND joi.status = 1" . " GROUP BY jo.jng_sp_orders_id";
$logger->write('Query orders');
$dbq = tep_db_query($query);
while ($o = tep_db_fetch_array($dbq)) {
$orders_id = $o['orders_id'];
$logger_oid = $o['order_type'] . 'O' . $orders_id;
$order_date_timestamp = strtotime($o['order_date']);
$last_sent_date_timestamp = strtotime($o['last_sent_date']);
$invoice_order_type = substr($o['order_type'], 0, 1);
$invoice = new payone_invoice('invoice_order_type', $invoice_order_type, "invoice_order_id='{$orders_id}'");
$open_amount = $invoice->getBalance();
$reminder_not_yet_sent = is_null($o['sent_count']);
$need_resend = $last_sent_date_timestamp < strtotime('-' . PAYMENT_METHOD_BANK_TRANSFER_OVERDUE);
$order = new Order($o['order_type'], $orders_id);
$items_id = $order->getIDItems();
//CHECK INVOICE STATUS
if ($invoice->detail['invoice_complete_status'] == 'U') {
//HANDLE UNDERPAID PREPAYMENT ORDERS
//TODO: use new email template
if ($reminder_not_yet_sent || $need_resend) {
sendUnderpaidReminder($o, $open_amount, $languages[2]['path']);
$logger->write('sent underpaid reminder ' . $logger_oid);
}
} elseif ($invoice->detail['invoice_complete_status'] == 'A') {
//HANDLE UNPAID PREPAYMENT ORDERS
if ($reminder_not_yet_sent) {
function conditionPrepaymentIsPaid($detail, $is_sp = true, $return_sql = false)
{
/* -----------------------------------------------------------------------------------------
* !!!!!! PLEASE UPDATE ON BOTH CONDITION IF THERES ANY CHANGES ON LOGIC !!!!!!
* rule1 : all preauth-uncaptured that balance indicates overpaid, paid, and small amount
* rule2 : all auth-submitted, preauth-captured that status is overpaid, paid, or complete
* rule3 : all auth-submitted, preauth-captured that payment_status is paid
------------------------------------------------------------------------------------------- */
//TODO : CHANGED BY USING payment_status = 1 (FOR NOW STILL USE 3 rules, PLEASE MAKE SURE FIRST FOR ALL ALLOWED SMALL PAYMENT ALSO APPLIED FOR CHANGE payment_status TO 1
if ($return_sql) {
use_class('payone_invoice');
$cond = "(";
$cond .= $is_sp ? "UPPER(jo.payment_method) = '" . strtoupper(PAYMENT_METHOD_PREPAYMENT) . "'" : "UPPER(o.payment_method) = '" . strtoupper(PAYMENT_METHOD_BANK_TRANSFER) . "'";
$cond .= " AND (";
//rule1
$cond .= " ( pi.is_captured IN ('0','2') AND pi.invoice_amount_paid > 0 AND (" . payone_invoice::calcBalance('', true) . "*100 <= " . PAYONE_MAX_RETURNED_OPEN_PAYMENT . ") )";
$cond .= " OR";
//rule2
$cond .= " ( (pi.is_captured IS NULL OR pi.is_captured NOT IN ('0','2')) AND pi.invoice_complete_status IN ('P','O','1') )";
$cond .= " OR";
//rule3
$cond .= $is_sp ? " ( jo.payment_status = 1 )" : " ( o.paid_status = '1' )";
$cond .= "))";
} else {
if ($is_sp) {
$is_vorkasse = strtoupper($detail['payment_method']) == strtoupper(PAYMENT_METHOD_PREPAYMENT);
$oid = $detail['jng_sp_orders_id'];
$otype = 'S';
} else {
$is_vorkasse = strtoupper($detail['payment_method']) == strtoupper(PAYMENT_METHOD_BANK_TRANSFER);
$oid = $detail['orders_id'];
$detail['payment_status'] = $detail['paid_status'];
$otype = 'J';
}
if (!$is_vorkasse) {
return;
}
if (isset($detail['invoice_current_balance'])) {
//PLEASE CONSIDER ADD "invoice_current_balance" AS SELECTION FIELD ON QUERY TO POSSIBLE USED THIS
$current_balance = $detail['invoice_current_balance'];
} else {
use_class('payone_invoice');
$inv = new payone_invoice("invoice_order_id", "{$oid}", "invoice_order_type='{$otype}'");
$current_balance = $inv->getBalance();
}
$is_captured = $detail['is_captured'];
/* disabled $rule1, we also set as Paid / payment_status = 1 for vorkasse with small payment <= PAYONE_MAX_RETURNED_OPEN_PAYMENT
* so it would be handled by rule3
$rule1 = (in_array($is_captured, array('0', '2')) && $detail['invoice_amount_paid']>0 && $current_balance<=PAYONE_MAX_RETURNED_OPEN_PAYMENT);
*/
$rule2 = (!in_array($is_captured, array('0', '2')) || is_null($is_captured) || $is_captured == '') && in_array($detail['invoice_complete_status'], array('P', 'O', '1'));
$rule3 = $detail['payment_status'] == 1;
//$cond = $is_vorkasse && ($rule1 || $rule2 || $rule3);
$cond = $is_vorkasse && ($rule2 || $rule3);
//var_dump("$is_vorkasse | $rule1 | $rule2 | $cond");die();
}
return $cond;
}
$request["de"][$item_counter] = 'Nachnahmegebühren';
$request["va"][$item_counter] = 0;
}
if (!$is_sp && $order['amount_discount'] > 0) {
//Voucher & Coupon
$item_counter++;
$amount_disc = $order['amount_discount'] * -100;
$request["id"][$item_counter] = 'Vouchers';
$request["pr"][$item_counter] = $amount_disc;
$request["no"][$item_counter] = 1;
$request["de"][$item_counter] = 'Gutscheine';
$request["va"][$item_counter] = 0;
}
//CHECK FOR SMALL PAYMENT (UNDERPAID ADJUSTMENT)
$is_small_payment = false;
$current_balance = $inv->getBalance();
if ($inv->detail['invoice_amount_paid'] > 0 && ($current_balance > 0 && $current_balance <= PAYONE_MAX_RETURNED_OPEN_PAYMENT)) {
$item_counter++;
$is_small_payment = true;
$amount_small_payment = $current_balance * -100;
$request['id'][$item_counter] = 'Underpaid Adjusment';
$request['pr'][$item_counter] = $amount_small_payment;
$request['no'][$item_counter] = 1;
$request['de'][$item_counter] = 'Fehlbetrag Ausgleich';
$request['va'][$item_counter] = 0;
$request['amount'] += $amount_small_payment;
}
}
// echo "<pre>";var_dump($request);die();
if ($txid != '') {
// echo "<pre>";var_dump($request);echo"<br/>";die();
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('payone_invoice');
$res = tep_db_query("SELECT invoice_id FROM payone_invoice");
while ($row = tep_db_fetch_array($res)) {
$payi = new payone_invoice("invoice_id", $row['invoice_id']);
$query = "UPDATE payone_invoice SET payone_saldo = " . $payi->getBalance() . " WHERE invoice_id = " . $row['invoice_id'];
echo $query . " ";
var_dump(tep_db_query($query));
echo "<br/>";
}
$month = date('n');
$yearnow = date('Y');
$yearbefore = $yearnow - 1;
$pmilink = 'https://pmi.pay1.de/merchants/txmanager.popup.php?navi=&ebene=1&operation=1&b_id=&u_id=&sort_col=&sort_order=&e_operation=0&userid=';
$pmilink .= '&plusminus%5B1%5D=%5Bweitere_Filterbedingung%5D&list_pos=0&search_kat%5B1%5D=buchungsid';
$pmilink .= '&field%5B1%5D=' . $invoice->detail['payone_txid'];
$pmilink .= '&startday=1&startmonth=' . $month . '&startyear=' . $yearbefore;
$pmilink .= '&endday=' . date('j') . '&endmonth=' . $month . '&endyear=' . $yearnow;
$pmilink .= '&selectedRadioMode=live';
//$txid = ($invoice->detail['payone_txid']=='') ? '<span class="red">Not connected yet</span>' : '<a href="'.$pmilink.'" class="view_webpage" title="'.$sop_mouse_over['payone_link'].'">'.$invoice->detail['payone_txid'].'</a>';
$txid = $invoice->detail['payone_txid'] == '' ? '<span class="red">Not connected yet</span>' : payoneWebLink($invoice->detail['payone_txid'], $sop_mouse_over['payone_link']);
$content .= '<div><table border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td style="width:120px;">Payone TXID</td><td>:</td><td style="width:122px;">' . $txid . '</td></tr>';
$content .= '<tr><td>Manobo Invoice ID</td><td>:</td><td>' . $invoice->detail['invoice_id'] . '</td></tr>';
$content .= '</table></div>';
$open_balance = $invoice->getBalance();
$content .= '<div style="margin-top:10px;">';
if ($open_balance == 0) {
$content .= '<h3 class="green">Invoice is Closed <span class="notice" style="font-weight:normal;">(No Open Payment/Refund)</span></h3>';
} elseif ($open_balance > 0) {
$content .= '<h3 class="red">Open Amount: ' . displayCurrency($order_currency, $open_balance) . '</h3>';
} else {
$content .= '<h3 class="red">Open Refund: ' . displayCurrency($order_currency, abs($open_balance)) . '</h3>';
}
$content .= '</div>';
} else {
if (!$is_handled_by_payone) {
$content .= '<div class="red">This payment method is not managed by Payone</div>';
} elseif (in_array($invoice->detail['invoice_complete_status'], array('2', '3', 'C'))) {
$content .= '<div>Invoice is Canceled</div>';
} elseif ($all_products_canceled) {
break;
case 'capture':
$payi->confirmCaptured();
if ($request['balance'] <= 0) {
if ($request['balance'] == 0) {
if ($payi->detail['invoice_complete_status'] == 'F') {
//set as refund processed for refund
$status = 'D';
} elseif ($payi->detail['invoice_complete_status'] == 'A') {
//if user not paid yet then returned all products, set as invoice cancelled
$status = '3';
} else {
//set as paid for non-refund
$status = 'P';
}
if ($payi->getBalance() < 0) {
/* If refund was processed on captured while invoice_amount_paid > invoice_amount
* (means we not prepared return container for this),
* after we received captured from payone: balance = 0, getBalance < 0
* so we need to save the difference as overPaymentAmount
*/
$payi->overPaymentAmount($payi->getBalance());
} elseif ($payi->getBalance() > 0) {
/* If there any adjusted to closed small amount on capture,
* after received captured from payone: balance = 0, getBalance > 0
* so we need to save the difference as reduceAmount
*/
$payi->reduceAmount($payi->getBalance());
}
} else {
$status = 'O';
}
$class_plog->add('S', $process_time, $process_method, $request, $response);
}
}
} else {
$logger->write("NO INVOICES READY TO BE SENT TO PAYONE");
}
//TODO: Send notification direclty per order after sending to payone
$logger->write("SENDING MAIL PREPAYMENT INFO");
if (count($success) > 0) {
foreach ($success as $sp => $dts) {
foreach ($dts as $dt) {
$order_type = $sp == 'sp' ? Order::ORDER_TYPE_SALES_PARTNER : Order::ORDER_TYPE_JULIE_GRACE;
list($invoice_id, $order_id) = explode('|', $dt);
$inv = new payone_invoice('invoice_id', $invoice_id);
$unpaid_amount = $inv->getBalance();
$order = new Order($order_type, $order_id);
if ($order->sendPrepaymentInformation($unpaid_amount)) {
$mail_send_status = 'sent';
} else {
$mail_send_status = 'sent failed';
}
$logger->write($l_order_type . 'O' . $order_id . " {$mail_send_status}");
}
}
} else {
$logger->write("no orders ready");
}
$msg = "TOTAL INVOICES JG CREATED: " . $pi_create_counter['jg'];
echo "{$msg} \n";
$logger->write($msg);
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'CHECKCURRENTBALANCE') {
$current_balance = 0;
$info_balance = '';
$id = $_POST['id'];
$dbq = tep_db_query("SELECT * FROM payone_invoice WHERE payone_txid = '{$id}' OR invoice_id = '{$id}'");
if (tep_db_num_rows($dbq) > 0) {
$info_balance = '<div align="center"><table border="0" cellpadding="0" cellspacing="0" style="background-color:#fff;width:300px;">';
$info_balance .= '<th>Invoice ID</th><th>Payone txid</th><th>Current Balance</th>';
while ($r = tep_db_fetch_array($dbq)) {
$cur_balance = 0;
$invoice_id = $r['invoice_id'];
$txid = $r['payone_txid'];
$payi = new payone_invoice('invoice_id', $invoice_id);
$cur_balance = $payi->getBalance();
$info_balance .= '<tr><td align="center">' . $invoice_id . '</td><td align="center">' . $txid . '</td><td align="center">' . $cur_balance . ' EUR</td></tr>';
}
$info_balance .= '</table></div>';
}
$result = array();
$result['info-balance'] = $info_balance;
ajaxReturn($result);
exit;
}
}
$sort = isset($_GET['sort']) && $_GET['sort'] != '' ? tep_db_prepare_input($_GET['sort']) : 'asc';
if (isset($_POST['paging_page_clicked'])) {
if (isset($_SESSION['vars']['paging_page_clicked'])) {
$paging_page_clicked = $_SESSION['vars']['paging_page_clicked'];
}
function updateProductStatus($items_id, $new_status, $updater = '', $cancelby = 'J', $add_to_prod_target = true)
{
/*==============================================================
* PURPOSE : TO CHANGE PROCESS STATUS ORDER OF PRODUCTS
* PARAMS : $items_id (NUMBER) >> e.g: 1234
* $new_status (NUMBER) >> e.g: 1
* $updater (STRING) "OPTIONAL" >> e.g: 'mbosse'
* $cancelby (STRING) "OPTIONAL" >> e.g: 'S'
===============================================================*/
use_class('production_target');
$pt = new production_target();
list($new_status, $sub_status) = explode('-', $new_status);
$item = $this->retrieveProductDetail($items_id);
$itemMode = modeName($item['mode']);
$timestamp = date('Y-m-d H:i:s');
$is_reviving = statusIsCancelled($item['status']) && !statusIsCancelled($new_status);
//Revive Item should move to in HH directly if other items are already in HH
if ($is_reviving) {
$item_others = $this->retrieveProducts($item['orders_id']);
$others_in_hh = false;
//If there's other items are already in HH set new status directly to HH
foreach ($item_others as $io) {
if ($io['status'] == '8') {
$new_status = '8';
$others_in_hh = true;
break;
}
}
//If there's no items are already in HH (Full MTO)
if (!$others_in_hh) {
use_class('depot_orders');
$class_do = new depot_orders();
$item_do = $class_do->retrieveDetailTransmigran('JG', $items_id);
if (!is_null($item_do)) {
if ($item_do['status'] < 6) {
/* Order status is before in Package, do below steps:
1) Set real status same with last status of DP
2) Consider also set sub production status "only" when main status is in production
3) Cancel "directly" DP order, means we not use doCancelOrder
*/
$new_status = $item_do['status'];
$sub_status = $new_status == '4' ? $item_do['prod_status'] : '';
$class_do->updateStatus($item_do['depot_orders_id'], '12', 'auto-set');
$reviving_need_next_update = true;
$revived_stock_status = $item_do['stock_status'];
$revived_mode = 'MTO';
} else {
/* Order status is >= "in Package"
1) Set real status to New
*/
$new_status = '1';
}
}
}
}
//Only "Sent" and "Complete" status can be updated to "Returned"
if ($new_status == '14' && !($item['status'] == '9' || $item['status'] == '11')) {
return false;
}
//KPI Logging
if ($add_to_prod_target) {
if ($new_status == '5') {
$pt->addDataToField($timestamp, 'finish', $item['products_quantity']);
}
if ($new_status == '6') {
$pt->addDataToField($timestamp, 'package', $item['products_quantity']);
}
if ($new_status == '7') {
$pt->addDataToField($timestamp, 'sent', $item['products_quantity']);
}
if ($new_status == '16') {
$pt->addDataToField($timestamp, 'log_return_to_bali', $item['products_quantity']);
}
if ($new_status == '19') {
$pt->addDataToField($timestamp, 'log_return_missing', $item['products_quantity']);
}
if ($new_status == '20') {
$pt->addDataToField($timestamp, 'log_return_to_bin_in', $item['products_quantity']);
}
if ($new_status == '9') {
$pt->addDataToField($timestamp, 'log_products_sent_b2c', $item['products_quantity']);
if ($itemMode == 'DSO') {
$pt->addDataToField($timestamp, 'log_products_sent_full_dso', $item['products_quantity']);
} elseif ($itemMode == 'MTO') {
$pt->addDataToField($timestamp, 'log_products_sent_full_mto', $item['products_quantity']);
} elseif ($itemMode == 'WMO' || $itemMode == 'MMO') {
$pt->addDataToField($timestamp, 'log_products_sent_mo', $item['products_quantity']);
}
}
}
//Update Status and create Status History
$sda_op = array('status' => $new_status);
$sda_op['status'] = $new_status;
if ($new_status == '10') {
$sda_op['products_problem'] = $cancelby;
} elseif ($this->productStatusIsCancelled($item['status']) && !$this->productStatusIsCancelled($new_status)) {
$sda_op['products_problem'] = '0';
}
$sub_status = trim(strtoupper($sub_status));
if ($new_status == '4' && $sub_status != '') {
$sda_op['prod_status'] = $sub_status;
}
//PS: please don't set empty prod_status when it updated to status > 4,
//since this will used for check whether order could transferred to DP or not
//when real order taken over by HH when it from production
tep_db_perform('orders_products', $sda_op, 'update', "orders_products_id={$items_id}");
$save_main_status_history = true;
if (in_array($item['status'], array('3', '4', '5')) && $new_status == '4' && ($sub_status != '' && trim(strtoupper($item['prod_status'])) != $sub_status) || $is_reviving && $new_status == '4') {
$psh = array();
$psh['orders_items_id'] = $items_id;
$psh['type'] = 'JG';
$psh['status'] = $sub_status;
$psh['status_quantity'] = $item['products_quantity'];
$psh['status_date'] = $timestamp;
$psh['update_by'] = $updater;
saveProductionStatusHistory($psh);
if ($item['status'] == '4') {
$save_main_status_history = false;
}
}
if ($save_main_status_history) {
$sda = array();
$sda['orders_products_id'] = $items_id;
$sda['status'] = $new_status;
$sda['status_quantity'] = $item['products_quantity'];
$sda['status_date'] = $timestamp;
$sda['update_by'] = $updater;
tep_db_perform('orders_products_status_history', $sda);
}
//Revive Additional Action
if ($is_reviving) {
//Revive Items from Cancel Request Status
$this->recalcProductsCounter($item['orders_id']);
if ($new_status == '8') {
$this->printCountReset($items_id);
$this->updateOrderItemMode($items_id, 'MMO');
use_class('depot_orders');
$class_do = new depot_orders();
$item_do = $class_do->transferFromRealOrder(SEGMENT_ID_HAMBURG, 'JG', $items_id);
if ($item_do['status'] > 7) {
$class_do->updateStatus($item_do['depot_orders_id'], '1');
$class_do->printCountReset($item_do['depot_orders_id']);
}
}
if ($reviving_need_next_update) {
$this->updateProductStockStatus($items_id, $revived_stock_status);
if ($revived_mode != '') {
$this->updateOrderItemMode($items_id, $revived_mode);
}
}
//Set need repackaging flag if needed
use_class('products_minierp');
$class_pm = new products_minierp();
$p_data = $class_pm->retrieveDetail($item['products_id'], 'p');
if ($p_data['p']['need_repackaging'] == 1) {
$this->setNeedRepackaging($item['orders_id']);
}
}
//Check other available products of this order which need repackage "nr" on cancel
if ($new_status == '10') {
use_class('products_minierp');
$class_pm = new products_minierp();
$need_repackaging = false;
$nr_q = "SELECT products_id FROM orders_products WHERE orders_id = {$item['orders_id']} AND status NOT IN (10, 12)" . " AND orders_products_id != {$items_id}";
$nr_dbq = tep_db_query($nr_q);
while ($nr_r = tep_db_fetch_array($nr_dbq)) {
$p_data = $class_pm->retrieveDetail($nr_r['products_id'], 'p');
if ($p_data['p']['need_repackaging'] == 1) {
$need_repackaging = true;
break;
}
}
if (!$need_repackaging) {
$this->resetNeedRepackaging($item['orders_id']);
}
}
//Recalculate Orders Total, Products Counter on cancellation and reviving
if ($new_status == '10' || $is_reviving) {
$this->recalcTotals($item['orders_id']);
$this->recalcProductsCounter($item['orders_id']);
$this->recalcVouchersAndShippingCost($item['orders_id'], false);
}
//Update Stock Status and Elements Stock if necessary
if ($new_status == '2' && $item['stock_status'] != 'S') {
$this->updateProductStockStatus($items_id, false);
$this->prodStatusReset($items_id);
$this->eanPrintedReset($items_id);
//$this->printCountReset($items_id); //now we don't need to reset print_count for reprint pi when move to ready again.
} elseif ($new_status == '3' && $item['stock_status'] == 'S' || $new_status == '4' && $item['stock_status'] == 'W') {
$eu = $this->countElementsUsage($item['products_id'], $item['products_articles_id']);
$jng_warehouses_id = '1';
use_class('elements_stock');
$class_es = new elements_stock();
foreach ($eu as $elements_id => $euqty) {
$reduce_amount = $item['products_quantity'] * $euqty;
$class_es->reduceStockByPieces($jng_warehouses_id, $elements_id, $reduce_amount, 'RED JG-' . $items_id);
}
$this->updateProductStockStatus($items_id, 'R');
} elseif ($new_status == '1') {
//IF THERES ORDERS NEEDS RESET BACK TO NEW
$this->printCountReset($items_id);
$this->printConfirmReset($items_id);
$this->prodStatusReset($items_id);
$this->eanPrintedReset($items_id);
$this->updateProductStockStatus($items_id, 0);
$this->updateOrderItemMode($items_id, 'UNSET');
}
//Production Target Flag Counter
if ($item['status'] == '1' && ($new_status == '2' || $new_status == '3')) {
$this->productionTargetIn($timestamp, $item);
} elseif ($new_status == '6') {
$this->productionTargetOut($timestamp, $item);
} elseif ($new_status == '10') {
$this->productionTargetInReset($item);
}
//Auto Print PI rules
if ($new_status == '3' || $new_status == '12') {
$orders_id = $item['orders_id'];
//$q_pi_status = tep_db_query("SELECT COUNT(1)=order_item_total AS pi_ready_to_print FROM orders_products WHERE orders_id = $orders_id AND status = 3 AND print_count = 0 GROUP BY orders_id");
//ALSO CONSIDER GIFT/VOUCHER THAT DIRECTLY SET AS "SENT TO CUSTOMER" BUT print_count still zero
$q_pi_status = tep_db_query("SELECT COUNT(1)=order_item_total AS pi_ready_to_print FROM orders_products WHERE orders_id = {$orders_id} AND status IN (3, 9) AND print_count = 0 GROUP BY orders_id");
$pi_status = tep_db_fetch_array($q_pi_status);
if ($pi_status['pi_ready_to_print'] == 1) {
//PI PRINTED FOR THE FIRST TIME
/* HANDLED BY BATCH PRINTING CRON cron/print-pi.php
use_class('production_instruction_pdf');
$class_pi = new production_instruction_pdf();
$class_pi->addOrder('JG', $orders_id);
$class_pi->createPDF(false, 'F', true);
*/
} else {
if ($item['print_count'] > 0 && $item['print_confirmed'] > 0) {
//SECOND OR MORE PI PRINTED, could happen when there product by stock_status is "OK" but in real stock is "0" so this will set back to "NS". And when ready this will reprinted by using this block
$this->printConfirmReset($item['orders_products_id']);
$this->printCountReset($item['orders_products_id']);
/*
use_class('production_instruction_pdf');
$class_pi = new production_instruction_pdf();
$class_pi->addItem('JG', $item['orders_products_id']);
$class_pi->createPDF(false, 'F', false); //not add to daily statistic, we consider this as not "NEW"
*/
}
}
}
$q = tep_db_query("SELECT o.orders_id, o.orders_status, o.payment_method FROM orders_products op LEFT JOIN orders o ON o.orders_id=op.orders_id WHERE op.orders_products_id={$items_id}");
$order = tep_db_fetch_array($q);
if ($new_status == '12' || $item['products_problem'] == '0') {
$status_to_update_orders = array('2' => '6', '4' => '5', '13' => '6', '5' => '7', '7' => '8', '9' => '10', '12' => '12');
//cancelled
if (array_key_exists($new_status, $status_to_update_orders)) {
$changeorderstatus = true;
if ($new_status == '12') {
//dont update order status if not all products are cancelled
if (!$this->isAllProductsCancelled($order['orders_id'])) {
$changeorderstatus = false;
}
}
if ($changeorderstatus) {
$order_new_status = $status_to_update_orders[$new_status];
if ($order['orders_status'] < $order_new_status) {
$this->updateOrderStatus($order['orders_id'], $order_new_status);
}
}
}
if ($new_status == '12' && (strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_BANK_TRANSFER) || strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_PAYPAL))) {
/*----------------------------------------------------------------------------------------
* MAKE RETURN ENTRY FOR "PREPAYMENT ONLY" ON "CANCEL CONFIRM", SINCE FOR NON-PREPAYMENT,
* PAYONE INVOICE WILL CREATED WHEN PRODUCTS IS SENT,
* SO NO NEED TO ADJUST IT OR CREATE RETURN CONTAINER WHEN CANCEL CONFIRM PROCESS
-----------------------------------------------------------------------------------------*/
use_class('payone');
use_class('payone_invoice');
$class_payone = new payone();
$payi = new payone_invoice('invoice_order_id', $order['orders_id'], "invoice_order_type = 'J'");
if ($payi->isUncapturedPrePayment()) {
//UNCAPTURED PREAUTH VORKASSE NEED TO RECALCULATE INVOICE
$payi->recalculate();
//SET AS PAID WHEN OPEN BALANCE LEAVE SMALL AMOUNT OR THIS CANCEL PROCESS MAKES UNDERPAID BALANCE BECOMES PAID/OVERPAID
if ($payi->getBalance() * 100 <= PAYONE_MAX_RETURNED_OPEN_PAYMENT) {
$this->updatePaymentStatus($item['orders_id'], '1', 'auto-set');
}
} else {
//AUTH VORKASSE, CAPTURED PREAUTH VORKASSE, PAYPAL ORDER WILL ADD TO RETURN CONTAINER
$class_payone->createReturnContainer('NULL', $item['products_quantity'], $items_id);
}
}
}
//NEED TO RECALCULATE INVOICE WHEN REVIVING UNCAPTURED PREAUTH VORKASSE
if ($is_reviving && strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_PREPAYMENT)) {
use_class('payone_invoice');
$payi = new payone_invoice('invoice_order_id', $order['jng_sp_orders_id'], "invoice_order_type = 'S'");
if ($payi->isUncapturedPrePayment()) {
$payi->recalculate();
}
}
//SET READY TO CAPTURED FOR PREPAYMENT PREAUTH THAT ALREADY SENT
if ($new_status == '9' && strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_BANK_TRANSFER)) {
use_class('payone_invoice');
$payi = new payone_invoice('invoice_order_id', $item['orders_id'], "invoice_order_type = 'J'");
$payi->setIsCaptured('2');
}
return $new_status;
}
$rid_arr[] = '0';
$id_arr[] = 'Underpaid Adjusment';
$pr_arr[] = $amount_uadj;
$no_arr[] = 1;
$de_arr[] = 'Fehlbetrag Ausgleich';
$va_arr[] = 0;
$amount_return_arr[] = $amount_uadj;
$return_hist['amount_return_submitted'] += $amount_uadj;
}
}
//ONLY FOR NON VORKASSE CANCEL ORDERS
if ($data_return['return_id'] != null && $data_return['return_id'] != '') {
$amount_check_2 = 0;
// $amount_check_2 = $return_hist['amount_return_submitted'] + $return_hist['amount_paid'];
// $amount_check_2 = $return_hist['amount_return_submitted'] + ($class_pi->getBalance()*100); //PHP ISSUE > CHANGE BY USING bcadd AS BELOW
$last_cust_balance = $class_pi->getBalance() * 100;
$amount_check_2 = bcadd($return_hist['amount_return_submitted'], $last_cust_balance);
if ($amount_check_2 < 0 && $last_cust_balance != 0 && ($amount_paid > 0 && !in_array($class_pi->detail['invoice_complete_status'], $status_paid_complete))) {
//CUSTOMER NOT PAID ALL (LEFT SMALL PAYMENT AMOUNT) >> NEED ADJUSTMENT
$amount_return_total += $amount_check_2;
$amount_adj = intval(abs($amount_check_2));
$item_counter++;
$request['id'][$item_counter] = 'Adjustment';
$request['pr'][$item_counter] = $amount_adj;
$request['no'][$item_counter] = 1;
$request['de'][$item_counter] = 'Anpassung';
$request['va'][$item_counter] = 0;
$rid_arr[] = '0';
$id_arr[] = 'Adjustment';
$pr_arr[] = $amount_adj;
$no_arr[] = 1;
}
$class_payone->payoneReturnItemHistory($return_hist);
if ($return_hist['amount_return_submitted'] == 0) {
/* This process handled on payone_status_updates.php
$class_pi->overPaymentAmount($amount_return_total/100);
#notes: $amount_return_total is on negative value
*/
} else {
/* We need to do debitAmount here,
* this needed to handle when receiving debit from payone on gateway
* which payone returning balance = 0, so we could still have a chance
* whether to save different amount to invoice_amount_overpayment or not.
*/
$class_pi->debitAmount($request['amount'] / 100 * -1);
#notes: $request['amount'] = round($return_hist['amount_return_submitted']);
$last_balance = $class_pi->getBalance();
if ($last_balance < 0) {
//Confirm refund value which successfully processed by payone >> This process handled on payone_status_updates.php
//$class_pi->overPaymentAmount($last_balance);
$class_pi->updateCompleteStatus('F');
//F = REFUND SUBMITTED
}
}
} else {
$failed[] = $return_id;
}
}
} else {
//$counter_is_refund++;
$counter_is_refund[] = $request['txid'];
}
$oi_content .= '<tr><td class="label">Invoice Id</td><td>' . $invoice->detail['invoice_id'] . '</td></tr>';
$oi_content .= '<tr><td>Payone TXID</td><td>' . $invoice->detail['payone_txid'] . '</td></tr>';
$oi_content .= '<tr><td>Create Date</td><td>' . date('d.m.Y', strtotime($invoice->detail['invoice_date'])) . '</td></tr>';
$oi_content .= '<tr><td>Due Date</td><td>' . date('d.m.Y', strtotime($invoice->detail['invoice_due_date'])) . '</td></tr>';
$oi_content .= '<tr><td>Status</td><td>' . payone_invoice_status($invoice->detail['invoice_complete_status']) . '</td></tr>';
$oi_content .= '</table></div>';
$oi_content .= '<h3>Invoice Amount<h3>';
$oi_content .= '<div><table class="form" border="0" cellpadding="0" cellspacing="0">';
$oi_content .= '<tr><td class="label">Amount Total</td><td class="price">' . displayCurrency($order_currency, $invoice->detail['invoice_amount']) . '</td></tr>';
$oi_content .= '<tr><td>Amount Returns</td><td class="price">' . displayCurrency($order_currency, $invoice->detail['invoice_amount_canceled']) . '</td></tr>';
$oi_content .= '<tr><td>Amount Paid</td><td class="price">' . displayCurrency($order_currency, $invoice->detail['invoice_amount_paid']) . '</td></tr>';
$oi_content .= '<tr><td>Amount Refund</td><td class="price">' . displayCurrency($order_currency, $amount_refund) . '</td></tr>';
$oi_content .= '<tr><td>Amount Fines</td><td class="price">' . displayCurrency($order_currency, $amount_fines) . '</td></tr>';
//$oi_content .= '<tr><td>Overpaid</td><td class="price">'.displayCurrency($order_currency, $invoice->detail['invoice_amount_overpayment']).'</td></tr>';
//$oi_content .= '<tr><td>VAT</td><td class="price">'.displayCurrency($order_currency, $invoice->detail['invoice_vat']).'</td></tr>';
$oi_content .= '<tr><td>Saldo</td><td class="price">' . displayCurrency($order_currency, $invoice->getBalance()) . '</td></tr>';
if (in_array($session_userinfo['username'], $DEBUGER_USERNAME)) {
$oi_content .= '<tr><td>Payone Saldo</td><td class="price">' . displayCurrency($order_currency, $invoice->detail['payone_saldo']) . '</td></tr>';
}
$oi_content .= '</table></div>';
$oi_content .= '</div>';
$oi_content .= '<div style="padding-left:300px;">';
$invoice_sh = $invoice->retrieveStatusHistory();
$oi_content .= '<h3>Status History</h3>';
if (count($invoice_sh) == 0) {
$oi_content .= '<strong class="red">No status history found</strong>';
} else {
$stahis = array();
$sh = array();
$sh['sort'] = 'No';
$sh['date_add'] = 'Status Date';
function updateItemStatus($items_id, $new_status, $updater = '', $cancelby = 'J', $add_to_prod_target = true)
{
use_class('production_target');
$pt = new production_target();
list($new_status, $sub_status) = explode('-', $new_status);
$item = $this->retrieveItemDetail($items_id);
$itemMode = modeName($item['mode']);
$timestamp = date('Y-m-d H:i:s');
$is_reviving = statusIsCancelled($item['status']) && !statusIsCancelled($new_status);
$reviving_need_next_update = false;
//Revive Item should move to in HH directly if other items are already in HH
if ($is_reviving) {
$item_others = $this->retrieveItems($item['jng_sp_orders_id']);
$others_in_hh = false;
//If there's other items are already in HH set new status directly to HH
foreach ($item_others as $io) {
if ($io['status'] == '8') {
$new_status = '8';
$others_in_hh = true;
break;
}
}
//If there's no items are already in HH (Full MTO)
if (!$others_in_hh) {
use_class('depot_orders');
$class_do = new depot_orders();
$item_do = $class_do->retrieveDetailTransmigran('SP', $items_id);
if (!is_null($item_do)) {
if ($item_do['status'] < 6) {
/* Order status is before in Package, do below steps:
1) Set real status same with last status of DP
2) Consider also set sub production status "only" when main status is in production
3) Cancel "directly" DP order, means we not use doCancelOrder
*/
$new_status = $item_do['status'];
$sub_status = $new_status == '4' ? $item_do['prod_status'] : '';
$class_do->updateStatus($item_do['depot_orders_id'], '12', 'auto-set');
$reviving_need_next_update = true;
$revived_stock_status = $item_do['stock_status'];
$revived_mode = 'MTO';
} else {
/* Order status is >= "in Package"
1) Set real status to New
*/
$new_status = '1';
}
}
}
}
//Only "Sent" and "Complete" status can be updated to "Returned"
if ($new_status == '14' && !($item['status'] == '9' || $item['status'] == '11')) {
return false;
}
//KPI Logging
if ($add_to_prod_target) {
if ($new_status == '5') {
$pt->addDataToField($timestamp, 'finish', $item['order_quantity']);
}
if ($new_status == '6') {
$pt->addDataToField($timestamp, 'package', $item['order_quantity']);
}
if ($new_status == '7') {
$pt->addDataToField($timestamp, 'sent', $item['order_quantity']);
}
if ($new_status == '16') {
$pt->addDataToField($timestamp, 'log_return_to_bali', $item['order_quantity']);
}
if ($new_status == '19') {
$pt->addDataToField($timestamp, 'log_return_missing', $item['order_quantity']);
}
if ($new_status == '20') {
$pt->addDataToField($timestamp, 'log_return_to_bin_in', $item['order_quantity']);
}
if ($new_status == '9') {
use_class('jng_sp');
$class_jsp = new jng_sp();
//Get Sales Partner B2B
$sp_b2b = array_keys($class_jsp->retrieveList("sp_type = 1"));
$item_orders = $this->retrieveDetail($item['jng_sp_orders_id']);
if (in_array($item_orders['jng_sp_id'], $sp_b2b)) {
$pt->addDataToField($timestamp, 'log_products_sent_b2b', $item['order_quantity']);
} else {
$pt->addDataToField($timestamp, 'log_products_sent_b2c', $item['order_quantity']);
}
if ($itemMode == 'DSO') {
$pt->addDataToField($timestamp, 'log_products_sent_full_dso', $item['order_quantity']);
} elseif ($itemMode == 'MTO') {
$pt->addDataToField($timestamp, 'log_products_sent_full_mto', $item['order_quantity']);
} elseif ($itemMode == 'WMO' || $itemMode == 'MMO') {
$pt->addDataToField($timestamp, 'log_products_sent_mo', $item['order_quantity']);
}
}
}
$sub_status = trim(strtoupper($sub_status));
if ($updater != 'new-import') {
$setcancelation = $item['status'] == '10' && $new_status != '12' ? ", cancel_status=NULL" : '';
if ($new_status == '10') {
$setcancelation = ", cancel_status='{$cancelby}'";
}
$set_prod_status = $new_status == '4' && $sub_status != '' ? ", prod_status = '" . $sub_status . "'" : '';
//PS: please don't set empty prod_status when it updated to status > 4,
//since this will used for check whether order could transferred to DP or not
//when real order taken over by HH when it from production
tep_db_query("UPDATE jng_sp_orders_items SET status='{$new_status}' {$setcancelation} {$set_prod_status} WHERE jng_sp_orders_items_id={$items_id}");
}
$save_main_status_history = true;
if (in_array($item['status'], array('3', '4', '5')) && $new_status == '4' && ($sub_status != '' && trim(strtoupper($item['prod_status'])) != $sub_status) || $is_reviving && $new_status == '4') {
$psh = array();
$psh['orders_items_id'] = $items_id;
$psh['type'] = 'SP';
$psh['status'] = $sub_status;
$psh['status_quantity'] = $item['order_quantity'];
$psh['status_date'] = $timestamp;
$psh['update_by'] = $updater;
saveProductionStatusHistory($psh);
if ($item['status'] == '4') {
$save_main_status_history = false;
}
}
if ($save_main_status_history) {
$sda = array();
$sda['jng_sp_orders_items_id'] = $items_id;
$sda['status'] = $new_status;
$sda['status_quantity'] = $item['order_quantity'];
$sda['status_date'] = $timestamp;
$sda['update_by'] = $updater;
tep_db_perform('jng_sp_orders_items_status_history', $sda);
}
if ($is_reviving) {
//Revive Items from Cancel Request Status
$this->recalculateOrderItemCount(null, $items_id);
if ($new_status == '8') {
$this->printCountReset($items_id);
$this->updateOrderItemMode($items_id, 'MMO');
use_class('depot_orders');
$class_do = new depot_orders();
$item_do = $class_do->transferFromRealOrder(SEGMENT_ID_HAMBURG, 'SP', $items_id);
$do_close_status = explode(',', depot_orders::FILTER_STATUS_CLOSE);
if (in_array($item_do['status'], $do_close_status)) {
$class_do->updateStatus($item_do['depot_orders_id'], '1');
$class_do->printCountReset($item_do['depot_orders_id']);
}
}
if ($reviving_need_next_update) {
$this->updateItemStockStatus($items_id, $revived_stock_status);
if ($revived_mode != '') {
$this->updateOrderItemMode($items_id, $revived_mode);
}
}
//Set need repackaging flag if needed
$class_pm = new products_minierp();
$p_data = $class_pm->retrieveDetail($item['products_id'], 'p');
if ($p_data['p']['need_repackaging'] == 1) {
$this->setNeedRepackaging($item['jng_sp_orders_id']);
}
}
//Check other available products of this order which need repackage "nr" on cancel
if ($new_status == '10') {
$class_pm = new products_minierp();
$need_repackaging = false;
$nr_q = "SELECT products_id FROM jng_sp_orders_items WHERE jng_sp_orders_id = {$item['jng_sp_orders_id']} AND status NOT IN (10, 12)" . " AND jng_sp_orders_items_id != {$items_id}";
$nr_dbq = tep_db_query($nr_q);
while ($nr_r = tep_db_fetch_array($nr_dbq)) {
$p_data = $class_pm->retrieveDetail($nr_r['products_id'], 'p');
if ($p_data['p']['need_repackaging'] == 1) {
$need_repackaging = true;
break;
}
}
if (!$need_repackaging) {
$this->resetNeedRepackaging($item['jng_sp_orders_id']);
}
}
//Update Stock Status and Elements Stock if necessary
if ($new_status == '2' && $item['stock_status'] != 'S' && $item['stock_status'] != 'W') {
//Set stock status to need sourcing if item is move to sourcing tab
$this->updateItemStockStatus($items_id, false);
$this->prodStatusReset($items_id);
$this->eanPrintedReset($items_id);
//$this->printCountReset($items_id); //now we don't need to reset print_count for reprint pi when move to ready again.
//TODO: Ceck if above statement is still true with new batch pi printing
} elseif ($new_status == '3' && $item['stock_status'] == 'S' || $new_status == '4' && $item['stock_status'] == 'W') {
//Reduce elements stock when products are forced to move to ready/production before approved by elements stock check
$eu = $this->countElementsUsage($item['products_id'], $item['products_articles_id']);
if (count($eu) > 0) {
$jng_warehouses_id = '1';
use_class('elements_stock');
$class_es = new elements_stock();
foreach ($eu as $elements_id => $euqty) {
$reduce_amount = $item['order_quantity'] * $euqty;
$class_es->reduceStockByPieces($jng_warehouses_id, $elements_id, $reduce_amount, 'RED SP-' . $items_id);
}
}
$this->updateItemStockStatus($items_id, 'R');
} elseif ($new_status == '1') {
//IF THERES ORDERS NEEDS RESET BACK TO NEW
$this->printCountReset($items_id);
$this->printConfirmReset($items_id);
$this->prodStatusReset($items_id);
$this->eanPrintedReset($items_id);
$this->updateItemStockStatus($items_id, 0);
$this->updateOrderItemMode($items_id, 'UNSET');
}
//Production Target Flag Counter
if ($item['status'] == '1' && ($new_status == '2' || $new_status == '3')) {
//TODO: Move TARGET IN TO WHEN PI IS CONFIRMED BY SCANNING IT FOR EAN LABEL
$this->productionTargetIn($timestamp, $item);
} elseif ($new_status == '6') {
$this->productionTargetOut($timestamp, $item);
} elseif ($new_status == '10') {
$this->productionTargetInReset($item);
}
//Auto Print PI rules
if ($new_status == '3' || $new_status == '12') {
/* e.g. :
5 items ordered > 4 to ready, 1 to sourcing ( PI not printed yet )
so this block is for handling PI not printed when "1 sourcing" is cancelled, while print_count flag is still "0"
* !!!ABOVE SAMPLE PROCESS ISN'T RELIABLE AGAIN, SINCE WE NOW CHANGE PRINT PI DIRECTLY WHEN IT MOVES TO READY TAB VIA CRON cron/print-pi.php!!!
*/
$jng_sp_orders_id = $item['jng_sp_orders_id'];
$q_pi_status = tep_db_query("SELECT COUNT(1)=order_item_total AS pi_ready_to_print FROM jng_sp_orders_items WHERE jng_sp_orders_id = {$jng_sp_orders_id} AND status = 3 AND print_count = 0 GROUP BY jng_sp_orders_id");
$pi_status = tep_db_fetch_array($q_pi_status);
if ($pi_status['pi_ready_to_print'] == 1) {
//PI PRINTED FOR THE FIRST TIME
/* HANDLED BY BATCH PRINTING CRON cron/print-pi.php
use_class('production_instruction_pdf');
$class_pi = new production_instruction_pdf();
$class_pi->addOrder('SP', $jng_sp_orders_id);
$class_pi->createPDF(false, 'F', true);
*/
} else {
if ($item['print_count'] > 0 && $item['print_confirmed'] > 0) {
//SECOND OR MORE PI PRINTED, could happen when there product by stock_status is "OK" but in real stock is "0" so this will set back to "NS". And when ready this will reprinted by using this block
//reset print_count and print_confirmed to include this order again on next print-pi scheduler
$this->printConfirmReset($item['jng_sp_orders_items_id']);
$this->printCountReset($item['jng_sp_orders_items_id']);
/*
use_class('production_instruction_pdf');
$class_pi = new production_instruction_pdf();
$class_pi->addItem('SP', $item['jng_sp_orders_items_id']);
$class_pi->createPDF(false, 'F', false); //not add to daily statistic, we consider this as not "NEW"
*/
}
}
}
$q = tep_db_query("SELECT jo.jng_sp_orders_id, UPPER(jo.payment_method) AS payment_method FROM jng_sp_orders_items joi LEFT JOIN jng_sp_orders jo ON jo.jng_sp_orders_id=joi.jng_sp_orders_id WHERE joi.jng_sp_orders_items_id={$items_id}");
$order = tep_db_fetch_array($q);
if ($new_status == '12' && strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_PREPAYMENT)) {
/*----------------------------------------------------------------------------------------
* MAKE RETURN ENTRY FOR "PREPAYMENT ONLY" ON "CANCEL CONFIRM", SINCE FOR NON-PREPAYMENT,
* PAYONE INVOICE WILL CREATED WHEN PRODUCTS IS SENT,
* SO NO NEED TO ADJUST IT OR CREATE RETURN CONTAINER WHEN CANCEL CONFIRM PROCESS
-----------------------------------------------------------------------------------------*/
use_class('payone');
use_class('payone_invoice');
$class_payone = new payone();
$payi = new payone_invoice('invoice_order_id', $order['jng_sp_orders_id'], "invoice_order_type = 'S'");
if ($payi->isUncapturedPrePayment()) {
//UNCAPTURED PREAUTH PREPAYMENT NEED TO RECALCULATE INVOICE
$payi->recalculate();
//SET AS PAID WHEN OPEN BALANCE LEAVE SMALL AMOUNT OR THIS CANCEL PROCESS MAKES UNDERPAID BALANCE BECOMES PAID/OVERPAID
if ($payi->getBalance() * 100 <= PAYONE_MAX_RETURNED_OPEN_PAYMENT) {
$this->updatePaymentStatus($item['jng_sp_orders_id'], '1', 'auto-set');
}
} else {
//AUTH PREPAYMENT, CAPTURED PREAUTH PREPAYMENT (ADD TO RETURN CONTAINER)
$class_payone->createReturnContainerSP('NULL', $item['order_quantity'], $items_id);
}
}
//NEED TO RECALCULATE INVOICE WHEN REVIVING UNCAPTURED PREAUTH PREPAYMENT
if ($is_reviving && strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_PREPAYMENT)) {
use_class('payone_invoice');
$payi = new payone_invoice('invoice_order_id', $order['jng_sp_orders_id'], "invoice_order_type = 'S'");
if ($payi->isUncapturedPrePayment()) {
$payi->recalculate();
}
}
//SET READY TO CAPTURED FOR PREPAYMENT PREAUTH THAT ALREADY SENT
if ($new_status == '9' && strtoupper($order['payment_method']) == strtoupper(PAYMENT_METHOD_PREPAYMENT)) {
use_class('payone_invoice');
$payi = new payone_invoice('invoice_order_id', $item['jng_sp_orders_id'], "invoice_order_type = 'S'");
$payi->setIsCaptured('2');
}
return $new_status;
}
