$data_return_cod = array();
//-----------HAVE RETURN (FULL) WITHOUT RETURN CONTAINER
$query = "SELECT d.shipping_costs,d.cod_costs,d.`payment_method`,a.`return_id`, a.return_quantity, c.payone_txid, c.invoice_id, b.jng_sp_orders_id, b.`jng_sp_orders_items_id`, b.article_number,b.billing_text,b.price\nFROM jng_sp_orders_items_return a,`jng_sp_orders_items` b, payone_invoice c, `jng_sp_orders` d\nWHERE a.jng_sp_orders_items_id\nIN (\nSELECT invoice_order_items_id\nFROM payone_invoice\nWHERE invoice_order_id\nIN ( 17334, 17237, 16476, 17038, 16819, 16486, 16672, 16473, 16732, 16581, 16493, 17250, 16854, 16483, 16582, 16508, 17182, 17045, 16766, 16513, 16666, 16836, 16757, 16485, 16866, 16583, 16490 )\n)\nand a.`jng_sp_orders_items_id` = b.jng_sp_orders_items_id\nand c.invoice_order_id = b.jng_sp_orders_id\nand d.`jng_sp_orders_id` = b.`jng_sp_orders_id`";
$res = tep_db_query($query);
$result = array();
if (tep_db_num_rows($res) > 0) {
while ($row = tep_db_fetch_array($res)) {
$result[] = $row;
}
}
//echo"<pre>";var_dump($result);die();
foreach ($result as $data) {
// echo"<pre>";var_dump($data);die();
$invoice_id = $data['invoice_id'];
$class_pi = new payone_invoice("invoice_id", $invoice_id);
$customer = $class_jcust->retrieveDetailByInvoice($invoice_id);
$customer_bankdata = $class_jcust->getBankAccountData($customer['jng_sp_customers_id']);
$order = $class_jo->retrieveDetail($data['jng_sp_orders_id']);
$data_por = array();
$data_por['return_id'] = $data['return_id'];
$data_por['jng_sp_orders_items_id'] = $data['jng_sp_orders_items_id'];
$data_por['jng_sp_customers_id'] = $customer['jng_sp_customers_id'];
$data_por['amount'] = round($data['return_quantity'] * ($data['price'] * 100));
$data_por['txid'] = $data['payone_txid'];
$data_por['invoice_id'] = $class_pi->detail['invoice_id'];
$data_por['invoice_no'] = $class_pi->detail['invoice_no'];
$data_por['id'] = $data['article_number'];
$data_por['pr'] = round($data['price'] * 100);
$data_por['no'] = $data['return_quantity'];
$data_por['de'] = $data['billing_text'];
$data_por['va'] = 0;
