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