$comment_id = $class_o->insertComment($order_id, $comment, $comment_by);
//$comment = $class_o->retrieveCommentDetail($comment_id);
//$comments = array($comment);
$result = drawSingleComment($comment_id, $comment_by, time(), $comment);
echo utf8_encode($result);
exit;
} elseif ($_POST['me_action'] == 'DELETECOMMENT') {
$order_id = tep_db_prepare_input($_POST['order_id']);
$comment_id = tep_db_prepare_input($_POST['comment_id']);
$class_o->deleteComment($order_id, $comment_id);
echo utf8_encode($comment_id);
exit;
} elseif ($_POST['me_action'] == 'UPDATEPAIDSTATUS') {
$order_id = tep_db_prepare_input($_POST['order_id']);
$paid_status = tep_db_prepare_input($_POST['paid_status']);
$class_o->updatePaymentStatus($order_id, $paid_status, $session_userinfo['username']);
$result = array();
if ($paid_status == '1') {
$result['class'] = 'paid';
$result['status'] = 'ORDER PAID';
} else {
$result['class'] = 'unpaid';
$result['status'] = 'ORDER UNPAID';
}
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'REVIVEORDER') {
$result = '';
$order_id = tep_db_prepare_input($_POST['order_id']);
$order = $class_o->retrieveDetail($order_id);
if ($order['paid_status'] != '1') {
$response = "";
break;
case 'J':
/*NOTE:
* notification email already sent by payone, also change bankeinzug (direct debit) method become banktransfer
*/
//RESET BACK TO UNPAID STATUS
//old logic >> $amount_bank_fines = round(($payi->detail['invoice_amount'] - $request['balance']) * 100);
$amount_bank_fines = round(($request['balance'] - $payi->getBalance()) * 100);
$payi->bankFinesAmount($amount_bank_fines / 100 * -1);
$payi->updatePaidAmount(0);
$payi->updateCompleteStatus('A');
use_class("orders");
$class_o = new orders();
$orders_id = $payi->detail['invoice_order_id'];
$class_o->updatePaymentStatus($orders_id, '2', 'auto-set');
//cancelpaid because of withdrawal back
$payi->payoneSaldo($request['balance']);
$data = array();
$data['orders_id'] = $orders_id;
$data['date_withdrawal'] = $tx_time;
$data['description'] = 'cancelation';
//$data['additional_charge'] = ($amount_bank_fines/100)*-1;
$data['additional_charge'] = $payi->detail['invoice_amount_bank_fines'] / 100 * -1;
$data['repayment_amount'] = $request['balance'];
$data['repayment_status'] = 'N';
$class_o->banktransferWithdrawalReport($orders_id, $data);
break;
}
break;
case 'refund':
<?php
use_class('orders');
$class_o = new orders();
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
if ($_POST['me_action'] == 'SETPAYMENTSTATUS') {
$orders_id = tep_db_prepare_input($_POST['orders_id']);
$class_o->updatePaymentStatus($orders_id, '1', $session_userinfo['username']);
echo utf8_encode($orders_id);
}
exit;
}
$csvformat = isset($_GET['format']) && $_GET['format'] == 'csv';
$orders_query = "SELECT o.orders_id, o.customers_name, o.orders_no, o.currency, bt.*, ot.value AS order_amount FROM orders o";
$orders_query .= " INNER JOIN banktransfer bt ON bt.orders_id=o.orders_id";
$orders_query .= " LEFT JOIN orders_total ot ON ot.orders_id=o.orders_id AND ot.class='ot_total'";
$orders_query .= " WHERE o.paid_status='0'";
$orders_query .= " AND o.orders_status IN (8,9,10)";
$orders_result = tep_db_query($orders_query);
$orders = array();
$orders[0]['name'] = 'Customer';
$orders[0]['bt_own'] = 'Account Owner';
$orders[0]['bt_number'] = 'Account No';
$orders[0]['bt_name'] = 'Bank Name';
$orders[0]['bt_bankno'] = 'Bank Number (BLZ)';
$orders[0]['o_number'] = 'Bestell-Nr.';
$orders[0]['price'] = 'Order Amount';
$orders[0]['i_number'] = 'Rechnungs-Nr.';
if ($csvformat) {
$orders[0]['jgcol'] = 'Company';
}
