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