/**
* Get vip status of customer from an order
* @param String $type
* @param Int $orders_id
* @return Boolean
*/
function checkCustomerIsVIP($type, $orders_id)
{
$type = strtoupper($type);
$is_vip = false;
if ($type == 'SP') {
use_class('jng_sp_orders');
use_class('jng_sp_customers');
use_class('jng_sp_customers_special');
$class_jo = new jng_sp_orders();
$class_jc = new jng_sp_customers();
$class_jcs = new jng_sp_customers_special();
$o = $class_jo->retrieveDetail($orders_id);
//GET CUSTOMER DETAIL VIP OR NOT
$cust_data = $class_jc->retrieveDetail(null, $o['jng_sp_id'], $o['customer_billing_id']);
if (is_array($cust_data) && $cust_data['jng_sp_customers_id'] > 0) {
$cust_detail = $class_jcs->getCustomerDetail($cust_data['jng_sp_customers_id']);
}
$is_vip = $cust_detail['list_type'] == 'V';
} elseif ($type == 'JG') {
use_class('orders');
use_class('customers_special_list');
$class_o = new orders();
$class_csl = new customers_special_list();
$o = $class_o->retrieveDetail($orders_id);
//GET CUSTOMER DETAIL VIP OR NOT
$cust_detail = $class_csl->getCustomerDetail($o['customers_id']);
$is_vip = $cust_detail['list_type'] == 'V';
} elseif ($type == 'DP') {
use_class('depot_orders');
$class_do = new depot_orders();
$do = $class_do->retrieveDetail($orders_id);
if ($do['trans_type'] == 'SP' || $do['trans_type'] == 'JG') {
if ($do['trans_type'] == 'SP') {
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
$it = $class_jo->retrieveItemDetail($do['trans_id']);
$orders_id = $it['jng_sp_orders_id'];
} elseif ($do['trans_type'] == 'JG') {
use_class('orders');
$class_o = new orders();
$it = $class_o->retrieveProductDetail($do['trans_id']);
$orders_id = $it['orders_id'];
}
$is_vip = checkCustomerIsVIP($do['trans_type'], $orders_id);
}
}
return $is_vip;
}
case 'reminder':
$level = $request['reminderlevel'];
$payi->addReminder($tx_time, $level, $received);
$black_lists = array('5', 'A');
//BLACK LIST FOR CUSTOMERS THAT ALREADY RECEIVE reminder_level 5 and A
if (in_array($level, $black_lists)) {
switch ($payi->detail['invoice_order_type']) {
case 'S':
use_class('jng_sp_customers_special');
$class_jcs = new jng_sp_customers_special();
if (isset($request['userid']) && $request['userid'] != '') {
$q = tep_db_query("SELECT jng_sp_customers_id FROM jng_sp_customers WHERE payone_userid=" . $request['userid']);
if (tep_db_num_rows($q) > 0) {
$cust = tep_db_fetch_array($q);
$jng_sp_customers_id = $cust['jng_sp_customers_id'];
if (is_null($class_jcs->getCustomerDetail($jng_sp_customers_id))) {
$class_jcs->addCustomer('B', $jng_sp_customers_id);
} else {
$class_jcs->updateCustomer($jng_sp_customers_id, 'list_type', 'B');
}
}
}
break;
case 'J':
use_class('customers_special_list');
$class_cs = new customers_special_list();
if (isset($request['userid']) && $request['userid'] != '') {
$q = tep_db_query("SELECT customers_id FROM customers WHERE payone_userid=" . $request['userid']);
if (tep_db_num_rows($q) > 0) {
$cust = tep_db_fetch_array($q);
$customers_id = $cust['customers_id'];
if ($customers_id == '') {
exit;
}
//SUBMIT ACTION
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'SETSPECIALLIST') {
$submit = tep_db_prepare_input($_POST['submit']);
$type = strpos($submit, 'VIP') === false ? 'B' : 'V';
$customers_id = tep_db_prepare_input($_POST['customer_id']);
$class_jcs->addCustomer($type, $customers_id);
$openspeciallistdetail = true;
}
}
//START TEMPLATE
$customer = $class_jcust->retrieveDetail($customers_id);
$customer_special = $class_jcs->getCustomerDetail($customers_id);
$order_sl_type = '';
$order_sl_icon = '';
if (!is_null($customer_special)) {
$crown_img = $class_jcs->getTypeSymbol($customer_special['list_type'], $customers_id);
$order_sl_icon = $crown_img . ' ';
$order_sl_type = $class_jcs->getTypeName($customer_special['list_type']);
if ($order_sl_type != '') {
$order_sl_type = ' (' . $order_sl_type . ')';
}
}
$sp_detail = $class_sp->retrieveDetail($customer['jng_sp_id']);
$addresses = $class_jcust->getAddresses($customers_id);
$phones = $class_jcust->getPhones($customers_id);
$fullname = $customer['customer_firstname'];
if ($customer['customer_lastname'] != '') {
<?php
use_class('jng_sp');
$class_sp = new jng_sp();
use_class('jng_sp_customers_special');
$class_jcs = new jng_sp_customers_special();
use_class('jng_sp_customers');
$class_jcust = new jng_sp_customers();
$jng_sp_customers_id = isset($_GET['id']) ? tep_db_prepare_input($_GET['id']) : '';
if ($jng_sp_customers_id == '') {
exit;
}
$detail = $class_jcs->getCustomerDetail($jng_sp_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_jcs->insertComment($customer_id, $comment, $comment_by);
// $comment = $class_jcs->retrieveCommentDetail($comment_id);
// $comments = array($comment);
// $result = $class_jcs->drawComments($comments, true);
$result = drawSingleComment($comment_id, $comment_by, time(), $comment);
echo utf8_encode($result);
}
$javascript .= '
$("input.iwbutton:eq(0)").focus();
';
$title = 'Sales Partner Order Detail';
} else {
$order = $class_jo->retrieveDetail($order_id);
$buttons = '';
if (count($order) > 1) {
$order_int_comments = $class_jo->retrieveComments($order_id);
$sp_detail = $class_sp->retrieveDetail($order['jng_sp_id']);
$customer = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);
if (is_null($customer)) {
$customer_ids = $class_jcust->getFromOrder($order['jng_sp_orders_id']);
$customer = $class_jcust->retrieveDetail($customer_ids['customer_billing_id']);
}
$customer_sl = $class_jcs->getCustomerDetail($customer['jng_sp_customers_id']);
$order_sl_type = '';
$order_sl_icon = '';
if ($customer_sl['list_type'] != '') {
$crown_img = $class_jcs->getTypeSymbol($customer_sl['list_type'], $customer['jng_sp_customers_id']);
$order_sl_icon = $crown_img . ' ';
$order_sl_type = $class_jcs->getTypeName($customer_sl['list_type']);
if ($order_sl_type != '') {
$order_sl_type = ' (' . $order_sl_type . ')';
}
}
//GET ORDER DETAIL
$sp_order_id = $order['order_id'];
if ($sp_order_id == '') {
$sp_order_id = '<span style="color:#ccc;">Not online order</span>';
}