use_class('jng_sp_orders'); use_class('payone'); use_class('payone_invoice'); $class_sp = new jng_sp(); $class_jo = new jng_sp_orders(); $class_payone = new payone(); $class_pi = new payone_invoice(); $sets_of_returns = $class_payone->retrieveRefundList("status = 0"); //TODO : ALSO INCLUDE ALL OVERPAYMENT FROM payone_invoice WITH invoice_complete_status = 'O' if (count($sets_of_returns) > 0) { #echo "<pre>";var_dump($sets_of_returns); foreach ($sets_of_returns as $returns) { $joi_id = $returns['jng_sp_orders_items_id']; $amount_return = round($returns['amount']); $invoice_id = $returns['invoice_id']; $payi = $class_payone->retrieveList("invoice_id = {$invoice_id}"); #echo "<pre>";var_dump($payi); if (count($payi > 0)) { $amount = round($payi[0]['invoice_amount'] * 100); $amount_paid = round($payi[0]['invoice_amount_paid'] * 100); $amount_cancel = round($payi[0]['invoice_amount_cancel'] * 100); $amount_overpayment = round($payi[0]['invoice_amount_overpayment'] * 100); //PLEASE REPLACE BOTH LINES BELOW AND CHANGE WITH BOTH LINES ABOVE WHEN GOING LIVE #$amount_cancel = 200; #$amount_paid = 4781; } $data['return_id'] = $returns['return_id']; $data['invoice_id'] = $returns['invoice_id']; $data['invoice_no'] = $returns['invoice_no']; $data['jng_sp_orders_items_id'] = $returns['jng_sp_orders_items_id']; $data['id'] = $returns['id'];
use_class('payone'); use_class('payone_invoice'); use_class('payone_logger'); use_class('minierp_customers'); $class_sp = new jng_sp(); $class_jo = new jng_sp_orders(); $class_o = new orders(); $class_jcust = new jng_sp_customers(); $class_cust = new minierp_customers(); $class_payone = new payone(); $payi = new payone_invoice(); $pi_gift_create = array(); $cut_off_orders_id = 20363; $pi_gift_counter = 0; $process_method = 'authorization'; $sets_of_invoice = $class_payone->retrieveList("invoice_complete_status = 'R' AND invoice_id = 139163"); //$sets_of_invoice = $class_payone->retrieveList("invoice_id = 48"); //echo "<pre>";var_dump($sets_of_invoice);die(); $counter = 0; if (count($sets_of_invoice) > 0) { $success = array(); $failed = array(); foreach ($sets_of_invoice as $invoice) { $counter++; $order_id = $invoice['invoice_order_id']; $arr_joid = explode(",", $invoice['invoice_order_items_id']); $is_sp = $invoice['invoice_order_type'] == 'S' ? true : false; if ($is_sp) { $order = $class_jo->retrieveDetail($order_id); $items = $class_jo->retrieveItems($order_id); $cust = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);
$class_payone = new payone(); $class_jcust = new jng_sp_customers(); $class_cust = new minierp_customers(); $process_method = 'DEBIT'; $filter_only_auth_or_captured_preauth = "(is_captured IS NULL OR is_captured NOT IN ('0','2'))"; // 1) OVERPAYMENT PROCESS----------------------------------------------------------------------- $counter_overpayment = 0; $counter_ovp_no_bankaccount = 0; $counter_returns_no_txid = 0; $non_returned_amount_overpayment = PAYONE_MIN_NON_RETURNED_OVERPAYMENT; //5 EUR or less of overpayment won't returned /* * FOR VORKASSE PRE-AUTH, THIS CRON WILL ONLY HANDLE FOR OVERPAID THAT COMES UP "AFTER" TRANSACTION IS CAPTURED * WHILE FOR OVERPAID THAT COMES UP BEFORE CAPTURED, REFUND WILL PROCESSED WHEN CAPTURED IS SENT (payone-pre-auth-capture.php) */ $sets_of_overpayment = $class_payone->retrieveList("invoice_complete_status = 'O' AND {$filter_only_auth_or_captured_preauth}"); if (count($sets_of_overpayment) > 0) { $success = array(); $failed = array(); foreach ($sets_of_overpayment as $ovp) { if ($ovp['payone_txid'] != '') { $counter_overpayment++; $invoice_id = $ovp['invoice_id']; $order_id = $ovp['invoice_order_id']; $nextsequencenumber = intval($ovp['sequencenumber']) + 1; $amount = round($ovp['invoice_amount'] * 100); $amount_paid = round($ovp['invoice_amount_paid'] * 100); $amount_cancel = round($ovp['invoice_amount_cancel'] * 100); $class_pi = new payone_invoice("invoice_id", $invoice_id); $amount_overpayment = $class_pi->getBalance(); $is_sp = $ovp['invoice_order_type'] == 'S' ? true : false;
######################################### # Author : D3W4 & SAHAT # # Created : Feb 22, 2010 11:33:43 AM # ######################################### global $db; require_once '../confy.php'; require_once '../functions.php'; require_once '../functions-2.php'; tep_db_connect(); use_class('orders'); use_class('jng_sp_orders'); use_class('payone'); $pay = new payone(); //RETRIEVE ALL INVOICES THAT ALREADY BEEN CREATED AND NOT YET SEND TO PAYONE $sets_of_invoice = $pay->retrieveList("invoice_complete_status = '0' AND invoice_order_type IN ('S','J')"); $invoice_ids = array(); $invoice_ids_no_joid = array(); if (count($sets_of_invoice) > 0) { foreach ($sets_of_invoice as $invoice) { $invoice_id = $invoice['invoice_id']; $joid_arr = explode(",", $invoice['invoice_order_items_id']); if (count($joid_arr) > 0) { $ready_to_sent = true; foreach ($joid_arr as $joid) { if ($joid != '') { $query = $invoice['invoice_order_type'] == 'S' ? "SELECT status FROM jng_sp_orders_items WHERE jng_sp_orders_items_id = {$joid} AND status IN (9,11)" : "SELECT status FROM orders_products WHERE orders_products_id = {$joid} AND status IN (9,11)"; $cek = tep_db_query($query); //DENIED ALL STATUS EXCEPT 9/11 if (tep_db_num_rows($cek) == 0) { $ready_to_sent = false;
if ($class_jo->statusIsCancelled($item['status'])) { unset($items[$key]); break 1; } } // echo "<pre>";var_dump($order);die(); //$payi->createFromOrderJNG($order, $items, 'use_default', 'R'); $payi->createFromOrderJNG($order, $items, '+1 days', 'R'); if (tep_db_insert_id() != '') { $pi_gift_create['success'][] = $order_id; } else { $pi_gift_create['failed'][] = $order_id; } } $process_method = 'authorization'; $sets_of_invoice = $class_payone->retrieveList("invoice_complete_status = 'R'"); //$sets_of_invoice = $class_payone->retrieveList("invoice_id = 48"); //echo "<pre>";var_dump($sets_of_invoice);die(); $counter = 0; if (count($sets_of_invoice) > 0) { $success = array(); $failed = array(); foreach ($sets_of_invoice as $invoice) { $counter++; $order_id = $invoice['invoice_order_id']; $arr_joid = explode(",", $invoice['invoice_order_items_id']); $is_sp = $invoice['invoice_order_type'] == 'S' ? true : false; if ($is_sp) { $order = $class_jo->retrieveDetail($order_id); $items = $class_jo->retrieveItems($order_id); $cust = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);