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']);
