$pimg = webImage($item['products_image'], '120', '120', '', 'img-border img-padding');
}
$content .= '<div style="float:left;">' . $pimg . '</div>';
$content .= '<div style="margin-left:150px;">';
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$order_id = $order['order_id'] == '' ? 'J&G ID: ' . $order['jng_sp_orders_id'] : $order['order_id'];
if ($return['confirm_return'] == '1') {
$return_reason = $class_jo->returnReasonText($return['return_reason']);
$return_qty = $return['return_quantity'];
$comment_c = nl2br($return['return_comment_customer']);
$comment_j = nl2br($return['return_comment_jng']);
$shipping_status = $return['shipping_paid'] == '1' ? 'Paid' : 'Unpaid';
} else {
$return_reason = $class_jo->returnReasonCombo('', 'input2', 'return_reason', $return['return_reason']);
$returnable = $item['order_quantity'];
$return_data = $class_jo->retrieveReturnItem($item['jng_sp_orders_items_id']);
if (!is_null($return_data)) {
foreach ($return_data as $rd) {
if ($rd['return_id'] != $return_id) {
$returnable -= $rd['return_quantity'];
}
}
}
$return_qty = '<select id="return_qty">';
for ($q = 1; $q <= $returnable; $q++) {
$sel = $q == $return['return_quantity'] ? 'selected="selected"' : '';
$return_qty .= '<option value="' . $q . '" ' . $sel . '>' . $q . '</option>';
}
$return_qty .= '</select>';
$comment_c = '<textarea id="comment-c" class="input2">' . $return['return_comment_customer'] . '</textarea>';
$comment_j = '<textarea id="comment-j" class="input2">' . $return['return_comment_jng'] . '</textarea>';
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('payone_invoice');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_pi = new payone_invoice();
$items_id_returned = array('28801', '28806');
foreach ($items_id_returned as $items_id) {
$o_oi = $class_jo->retrieveItemDetail($items_id);
$o_ri_arr = $class_jo->retrieveReturnItem($items_id);
$o_ri = $o_ri_arr[0];
$class_pi->retrieveDetail("S", $o_oi['jng_sp_orders_id']);
//ONLY QUEING JUST FOR TRANSACTION THAT HAVE payone_txid (FIRST GET FROM SUBMITTING INVOICE)
if ($class_pi->detail['payone_txid'] != '') {
$data_por = array();
$data_por['return_id'] = $o_ri['return_id'];
$data_por['invoice_id'] = $o_oi['jng_sp_orders_id'];
$data_por['jng_sp_orders_items_id'] = $items_id;
$data_por['id'] = $o_oi['article_number'];
$data_por['pr'] = intval($o_oi['price'] * 100);
$data_por['no'] = $o_ri['return_quantity'];
$data_por['de'] = $o_oi['billing_text'];
$data_por['va'] = 0;
$data_por['amount'] = $data_por['pr'] * $data_por['no'];
$payone_txid = $class_pi->detail['payone_txid'];
$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'];
}
}
}
$order_source_name = $sp_detail['name'];
$customer_name = '<a href="?open=sp-customer&id=' . $customer['jng_sp_customers_id'] . '&hidemenu=true" class="view_webpage" title="' . $sop_mouse_over['link_customer_detail'] . '">' . $order['customer_billing_firstname'] . ' ' . $order['customer_billing_lastname'] . '</a>';
$customer_email = $order['jng_sp_id'] == '8' ? $text_encrypted : $order['customer_billing_email'];
$order_date_timestamp = strtotime($order['order_date']);
$address_shipping .= '<strong>' . ($order['customer_shipping_title'] != '' ? $order['customer_shipping_title'] . ' ' : '') . $order['customer_shipping_firstname'] . ' ' . $order['customer_shipping_lastname'] . '</strong>';
$address_shipping .= '<br />' . $order['customer_shipping_address'];
if ($order['customer_shipping_address2'] != '') {
$address_shipping .= '<br />' . $order['customer_shipping_address2'];
}
$op_total_product += $row['order_quantity'];
$op_total_price += $qty_price;
}
/*
$cancel = $class_jo->retreiveCancelQtyItem($items_id);
if(!is_null($cancel)) {
$has_cancel = true;
if(!isset($op_saver[$items_id])) {
$op_saver[$items_id] = $row;
$op_saver[$items_id]['promod'] = $promod;
$op_saver[$items_id]['proname'] = $proname;
}
foreach($cancel as $c) $cancels[] = $c;
}
*/
$return = $class_jo->retrieveReturnItem($items_id);
if (!is_null($return)) {
if (!isset($op_saver[$items_id])) {
$op_saver[$items_id] = $row;
$op_saver[$items_id]['promod'] = $promod;
$op_saver[$items_id]['proname'] = $proname;
}
foreach ($return as $r) {
$returns[] = $r;
}
}
if ($row['confirm_delivery'] == '1') {
$show_reconfirm_button = true;
}
if ($class_jo->statusIsCancelled($row['status'])) {
$has_cancel = true;
