$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;