$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'];
$data_por['txid'] = $payone_txid;
$data_por['currency'] = 'EUR';
$data_por['bankcountry'] = 'DE';
//TODO: FILL THIS WITH CUST. DATA (WHEN COD)
$data_por['bankaccount'] = '161610100';
//TODO: FILL THIS WITH CUST. DATA (WHEN COD)
var_dump($payone_txid);
$nextsequencenumber = $class_pi->getNextSequenceNumber($payone_txid);
var_dump($nextsequencenumber);
$data_por['sequencenumber'] = $nextsequencenumber;
echo "UPDATE payone_invoice SET refund = {$nextsequencenumber} WHERE payone_txid = {$payone_txid}";
tep_db_query("UPDATE payone_invoice SET refund = {$nextsequencenumber} WHERE payone_txid = {$payone_txid}");
$class_jo->payoneReturnItemContainer($data_por);
}
}
tep_db_close();
