require_once '../functions-2.php';
tep_db_connect();
use_class('payone/financegateConnect');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('orders');
use_class('jng_sp_customers');
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++;
function createReturnContainer($return_id, $return_qty, $opid)
{
use_class('orders');
use_class('payone_invoice');
use_class('minierp_customers');
$class_o = new orders();
$class_pi = new payone_invoice();
$class_cust = new minierp_customers();
$insert_id = '';
$op = $class_o->retrieveProductDetail($opid);
$order_id = $op['orders_id'];
$order = $class_o->retrieveDetail($order_id, true);
$customers_id = $order['customers_id'];
$item = $class_o->retrieveProductDetail($opid);
$final_price = $item['final_price'];
//CHECK WHETHER CUSTOMER USING COUPON DISCOUNT OR NOT (ONLY ON JNG ORDERS)
$qcheck_disc = "SELECT c.* FROM `coupon_redeem_track` crt INNER JOIN `coupons` c\n ON crt.`coupon_id` = c.`coupon_id`\n WHERE crt.`order_id` = {$order_id}";
$dbq_disc = tep_db_query($qcheck_disc);
if (tep_db_num_rows($dbq_disc) > 0) {
$r_disc = tep_db_fetch_array($dbq_disc);
$disc = $r_disc['coupon_amount'];
if ($disc > 0 && $disc < 1) {
$final_price = $final_price - $final_price * $disc;
$final_price = ceil($final_price * 100) / 100;
//take only 2 digits decimals ex: 21.165 became 21.16
}
}
$customer = $class_cust->retrieveDetail($customers_id);
$customer_bankdata = $class_cust->getBankAccountData($order_id);
$class_pi->retrieveDetail("J", $order_id);
//ONLY QUEING JUST FOR TRANSACTION THAT HAVE payone_txid (FIRST GET FROM SUBMITTING INVOICE)
if ($class_pi->detail['payone_txid'] != '') {
$payone_txid = $class_pi->detail['payone_txid'];
$payment_method = $order['payment_method'];
$data_por = array();
$data_por['return_id'] = $return_id;
$data_por['jng_sp_orders_items_id'] = $item['orders_products_id'];
$data_por['jng_sp_customers_id'] = $customer['customers_id'];
$data_por['amount'] = round($return_qty * ($final_price * 100));
$data_por['txid'] = $payone_txid;
$data_por['invoice_id'] = $class_pi->detail['invoice_id'];
$data_por['invoice_no'] = $class_pi->detail['invoice_no'];
$data_por['id'] = $item['products_model'];
$data_por['pr'] = round($final_price * 100);
$data_por['no'] = $return_qty;
$data_por['de'] = strlen($item['products_name']) > 32 ? substr($item['products_name'], 0, 32) : $item['products_name'];
$data_por['va'] = 0;
$data_por['payment_method'] = $payment_method;
$data_por['currency'] = 'EUR';
if (!is_null($customer_bankdata)) {
$data_por['bankcode'] = $customer_bankdata['banktransfer_blz'];
$data_por['bankcountry'] = 'DE';
$data_por['bankaccount'] = $customer_bankdata['banktransfer_number'];
$data_por['bankaccountholder'] = $customer_bankdata['banktransfer_owner'];
}
// echo "<pre>";var_dump($data_por);
$insert_id = $this->payoneReturnItemContainer($data_por);
$items_q = tep_db_query("SELECT SUM(products_quantity) AS total FROM orders_products WHERE orders_id={$order_id} AND status NOT IN (10, 12)");
$items = tep_db_fetch_array($items_q);
$items_total = $items['total'];
$returns_q = "SELECT SUM(opr.return_qty) AS total" . " FROM orders_products op" . " LEFT JOIN orders_products_return opr" . " ON opr.orders_products_id = op.orders_products_id" . " WHERE op.orders_id={$order_id}" . " AND op.status NOT IN (10, 12)";
$returns_r = tep_db_query($returns_q);
$returns = tep_db_fetch_array($returns_r);
$returns_total = $returns['total'];
if ($items_total == $returns_total) {
$amount_paid = $class_pi->detail['invoice_amount_paid'];
$total_costs = $order['shipping_costs'] + $order['cod_costs'];
if ($order['shipping_costs'] > 0) {
// if((($amount_paid*1)==0)||(($amount_paid<>$order['shipping_costs'])&&($amount_paid<>$total_costs))){
if ($amount_paid * 1 == 0 || $amount_paid > $total_costs) {
$q_check = "SELECT * FROM payone_orders_return WHERE txid = '{$payone_txid}' AND id = 'Shipping'";
$dbc = tep_db_query($q_check);
if (tep_db_num_rows($dbc) == 0) {
//HANDLE DOUBLE OR MORE SHIPING RETURN CONTAINER
$amount = round($order['shipping_costs'] * 100);
$data_por = array();
$data_por['return_id'] = 0;
$data_por['jng_sp_orders_items_id'] = 0;
$data_por['jng_sp_customers_id'] = $customer['customers_id'];
$data_por['amount'] = $amount;
$data_por['txid'] = $payone_txid;
$data_por['invoice_id'] = $class_pi->detail['invoice_id'];
$data_por['invoice_no'] = $class_pi->detail['invoice_no'];
$data_por['id'] = 'Shipping';
$data_por['pr'] = $amount;
$data_por['no'] = 1;
$data_por['de'] = 'Verpackung & Versand';
$data_por['va'] = 0;
$data_por['payment_method'] = $payment_method;
$data_por['currency'] = 'EUR';
$insert_id = $this->payoneReturnItemContainer($data_por);
}
}
}
}
} else {
//ORDER NOT SUBMITTED YET TO PAYONE, SO NO TXID CREATED YET. JUST NEED TO EXCLUDE ITEM FROM payone_invoice TABLE COLUMN 'invoice_order_items_id'
$oids_arr = explode(',', $class_pi->detail['invoice_order_items_id']);
if (is_array($oids_arr)) {
$new_amount = $class_pi->detail['invoice_amount'] - $return_qty * $final_price;
foreach ($oids_arr as $key => $value) {
if ($value == $opid) {
unset($oids_arr[$key]);
}
}
$oids = implode(',', $oids_arr);
if (count($oids_arr) == 0) {
//ALL PRODUCTS RETURNED
$new_amount = 0;
$class_pi->updateCompleteStatus('3');
//INVOICE CANCELLED
}
tep_db_perform('payone_invoice', array('invoice_amount' => $new_amount, 'invoice_order_items_id' => $oids), 'update', "invoice_id = '" . $class_pi->detail['invoice_id'] . "'");
}
}
return $insert_id;
}
<?php
use_class('customers_special_list');
$class_csl = new customers_special_list();
use_class('minierp_customers');
$class_mc = new minierp_customers();
$customers_id = isset($_GET['id']) ? tep_db_prepare_input($_GET['id']) : '';
if ($customers_id == '') {
exit;
}
$detail = $class_csl->getCustomerDetail($customers_id);
if (is_null($detail)) {
exit;
}
//AJAX ACTION
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'ADDNEWCOMMENT') {
$customer_id = tep_db_prepare_input($_POST['customer_id']);
$comment = tep_db_prepare_input(utf8_decode($_POST['comment']));
$comment = trim($comment);
if ($comment != "") {
$comment_by = $session_userinfo['username'];
$comment_id = $class_csl->insertComment($customer_id, $comment, $comment_by);
// $comment = $class_csl->retrieveCommentDetail($comment_id);
// $comments = array($comment);
// $result = $class_csl->drawComments($comments, true);
$result = drawSingleComment($comment_id, $comment_by, time(), $comment);
echo utf8_encode($result);
}
exit;
} elseif ($_POST['me_action'] == 'DELETECOMMENT') {
tep_db_connect();
use_class('payone/financegateConnect');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('orders');
use_class('jng_sp_customers');
use_class('minierp_customers');
use_class('payone');
use_class('payone_invoice');
use_class('payone_logger');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_o = new orders();
$class_payone = new payone();
$class_jcust = new jng_sp_customers();
$class_cust = new minierp_customers();
$process_method = 'DEBIT';
//$sets_of_returns = $class_payone->retrieveRefundSubmitReadyList("status = 0");
$pkey_ids = explode(',', tep_db_prepare_input($_GET['pkey_id']));
if (count($pkey_ids) > 0) {
$pkey_ids = implode(',', $pkey_ids);
$sets_of_returns = $class_payone->retrieveRefundList("status = 0 AND pkey_id IN (" . $pkey_ids . ")");
$counter = 0;
$counter_returns = 0;
$counter_returns_no_txid = 0;
$status_paid_complete = array('P', '1');
//$counter_is_refund = 0;
$counter_is_refund = array();
if (count($sets_of_returns) > 0) {
//echo "<pre>";var_dump($sets_of_returns);die();
$success = array();
<?php
use_class('minierp_customers');
$class_mc = new minierp_customers();
use_class('customers_special_list');
$class_csl = new customers_special_list();
//SUBMIT ACTION
$customer_deleted = false;
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'DELETECUSTOMERDATA') {
$customer_id = tep_db_prepare_input($_POST['customer_id']);
$customer_name = tep_db_prepare_input($_POST['customers_firstname']) . " " . tep_db_prepare_input($_POST['customers_lastname']);
$orders_query = tep_db_query("SELECT COUNT(o.orders_id) AS count, SUM(ot.value) AS total FROM orders o INNER JOIN orders_total ot ON ot.orders_id=o.orders_id AND ot.class='ot_total' WHERE o.customers_id={$customer_id} GROUP BY o.customers_id");
$orders = tep_db_fetch_array($orders_query);
$has_orders = is_array($orders) && isset($orders['count']);
if (!$has_orders) {
//DELETE CUSTOMER
$backup_q = "INSERT INTO customers_backup (customers_id, customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_default_address_id, customers_telephone, customers_fax, customers_password, customers_newsletter, customers_activation_code, customers_active_status, customers_referrer_id, customers_status, rent_status, ambassador_id, ambassador_date)";
$backup_q .= " SELECT customers_id, customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_default_address_id, customers_telephone, customers_fax, customers_password, customers_newsletter, customers_activation_code, customers_active_status, customers_referrer_id, customers_status, rent_status, ambassador_id, ambassador_date FROM customers WHERE customers_id={$customer_id}";
tep_db_query($backup_q);
tep_db_query("DELETE FROM customers WHERE customers_id={$customer_id}");
$messagebox->add("Customer <strong>{$customer_name}</strong> ID {$customer_id} is successfully deleted", 'green');
$customer_deleted = true;
}
} elseif ($_POST['me_action'] == 'UPDATECUSTOMERDATA') {
$customer_id = tep_db_prepare_input($_POST['customer_id']);
$sql_data_array = array();
if (isset($_POST['customers_gender'])) {
$sql_data_array['customers_gender'] = tep_db_prepare_input($_POST['customers_gender']);
}
$sql_data_array['customers_firstname'] = tep_db_prepare_input($_POST['customers_firstname']);
