<?php
use_class('orders');
$class_o = new orders();
use_class('customers_special_list');
$class_csl = new customers_special_list();
$search_days = 60;
//AJAX ACTION
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
if ($_POST['me_action'] == 'SEARCHORDERS') {
$search_field = tep_db_prepare_input($_POST['search_field']);
$search_keywords = tep_db_prepare_input(utf8_decode($_POST['search_keywords']));
$date_filter = date('Y-m-d', strtotime("-{$search_days} day"));
$orders = $class_o->searchBanktransferOrders($search_field, $search_keywords, "o.date_purchased>DATE('{$date_filter}')");
$result = '';
$table = array();
if (count($orders) > 0) {
$t = array();
$t['d'] = 'Date';
$t['c'] = 'Customer';
$t['o'] = 'Order No';
$t['i'] = 'Bank Info';
$t['p'] = 'Order Value';
$t['t'] = 'Withdrawal Date';
$table[] = $t;
foreach ($orders as $row) {
$order_date = strtotime($row['date_purchased']);
$customer_special = $class_csl->getCustomerDetail($row['customers_id']);
$crown_img = is_null($customer_special) ? '' : $class_csl->getTypeSymbol($customer_special['list_type'], $row['customers_id']);
$t = array();
$t['d'] = date('d-M-y', $order_date);
/**
* 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;
}
<?php
use_class('customers_special_list');
$class_csl = new customers_special_list();
$type = isset($_GET['type']) ? tep_db_prepare_input($_GET['type']) : '';
if ($type == '') {
exit;
}
$typename = $class_csl->getTypeName($type);
//AJAX ACTION
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'SEARCHCUSTOMER') {
$keywords = tep_db_prepare_input(utf8_decode($_POST['keywords']));
$keywords = strtolower(trim($keywords));
$result = '';
if ($keywords == '') {
$result .= '<h3 class="red">Please enter keywords</h3>';
} else {
$customers = $class_csl->getCustomersToAdd($keywords);
if (count($customers) == 0) {
$result .= '<h3 class="red">No Customers found for this keywords</h3>';
} else {
$table = array();
$t = array();
$t['d'] = 'ID';
$t['c'] = 'Name';
$t['a'] = 'Action';
$table[] = $t;
$keywords_array = explode(' ', $keywords);
foreach ($customers as $c) {
$cname = strtolower($c['customers_name']);
<?php
use_class('customers_special_list');
$class_csl = new customers_special_list();
//GET PAGE
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
//GET FILTER OPTION
$paging = true;
$filter_query = '';
if (isset($_POST['filterbytype']) && $_POST['filterbytype'] == '') {
$_SESSION['orders_filterbytype'] = '';
$_SESSION['orders_filterbyvalue'] = '';
} else {
if (isset($_POST['filterbytype']) && isset($_POST['filterbyvalue'])) {
$_SESSION['orders_filterbytype'] = tep_db_prepare_input($_POST['filterbytype']);
$_SESSION['orders_filterbyvalue'] = tep_db_prepare_input($_POST['filterbyvalue']);
} else {
if (!isset($_SESSION['orders_filterbytype'])) {
$_SESSION['orders_filterbytype'] = '';
}
if (!isset($_SESSION['orders_filterbyvalue'])) {
$_SESSION['orders_filterbyvalue'] = '';
}
}
}
$filtertype = $_SESSION['orders_filterbytype'];
$filtervalue = $_SESSION['orders_filterbyvalue'];
if ($filtertype != '' && $filtervalue != '') {
<?php
use_class('payone_invoice');
use_class('Order');
use_class('orders');
use_class('depot_orders');
use_class('minierp_customers');
use_class('customers_special_list');
$class_o = new orders();
$class_do = new depot_orders();
$class_mc = new minierp_customers();
$class_csl = new customers_special_list();
$default_order_status_comment = 'Comment for new status';
$order_language = 2;
function drawOrderTotalBox($order_id, $order_total = null)
{
global $class_o;
$order = $class_o->retrieveDetail($order_id);
if (is_null($order_total)) {
$order_total = $class_o->retrieveTotals($order_id);
}
//ORDER TOTAL
$ot_box = '<div class="draw-table">';
$ot_box .= '<table class="order-total" cellpadding="0" cellspacing="0">';
$ot_box .= '<tr>';
$ot_box .= '<th colspan="2">ORDER TOTAL</th>';
$ot_box .= '</tr>';
$ot_box .= '<tr>';
$ot_box .= '<td class="text">' . $order_total['ot_subtotal']['title'] . '</td>';
$ot_box .= '<td class="price">' . $order_total['ot_subtotal']['text'] . '</td>';
$ot_box .= '</tr>';
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 (is_null($class_cs->getCustomerDetail($customers_id))) {
$class_cs->addCustomer('B', $customers_id);
} else {
$class_cs->updateCustomer($customers_id, 'list_type', 'B');
}
}
}
break;
}
}
function drawOrderDisplay($order_type, $order_id, $displaypart = 'ALL', $excludecurrentorderinhistory = true)
{
//$displaypart = 'ALL' / 'NEW' / 'HISTORY'
global $class_do, $class_pm, $class_pa, $class_mc, $class_jo, $class_jc, $class_o, $sp_list;
//ORDERED PRODUCTS DISPLAY SETTING
$col_limit = 5;
//max no of columns
$row_limit = 5;
//max no of rows
$border = '1';
//border width
$imgsize = '80';
//image size
$padding = '5';
//box padding
$margin = '10';
//box margin
$po_limit = $col_limit * $row_limit;
//max no of products - auto calc
$powidth = ceil($col_limit * ($imgsize + 2 * ($border + $padding) + $margin) / 10) * 10;
$total_price = 0;
if ($order_type == 'SP') {
use_class('jng_sp_customers_special');
$csl = new jng_sp_customers_special();
$order = $class_jo->retrieveDetail($order_id);
$order_source = $sp_list[$order['jng_sp_id']]['name'];
$order_products = $class_jo->retrieveItems($order_id);
$customer = $class_jc->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);
$list_type = $csl->getListType($customer['jng_sp_customers_id']);
$cust_crown = $csl->getTypeSymbol($list_type, $customer['jng_sp_customers_id']);
$customer_name = $cust_crown . $order['customer_billing_firstname'] . ' ' . $order['customer_billing_lastname'];
$customer_address = $order['customer_billing_address'];
if ($order['customer_billing_address2'] != '') {
$customer_address .= ', ' . $order['customer_billing_address2'];
}
$customer_address .= ', ' . $order['customer_billing_postcode'];
$customer_address .= ' ' . $order['customer_billing_city'];
$customer_address .= ', ' . $order['customer_billing_country'];
$products_ordered = $class_jc->retrieveOrdersItems($customer['jng_sp_customers_id']);
$colname_order_id = 'jng_sp_orders_id';
$colname_items_id = 'jng_sp_orders_items_id';
$colname_order_date = 'order_date';
$colname_order_qty = 'order_quantity';
$colname_return_qty = 'return_quantity';
$colname_products_id = 'products_id';
$colname_products_code = 'article_number';
$colname_articles_id = 'products_articles_id';
$colname_custom_text1 = null;
$colname_custom_text2 = null;
$colname_custom_image = null;
$order_history_display = null;
$total_price = getTotalOrderAmount('S', $order_id);
} elseif ($order_type == 'JG') {
use_class('customers_special_list');
$csl = new customers_special_list();
$order = $class_o->retrieveDetail($order_id);
$order_source = 'JULIE&GRACE';
$total_price = getTotalOrderAmount('J', $order_id, $order['currency']);
$order_products = $class_o->retrieveProducts($order_id);
//$customer = $class_mc->retrieveDetail($order['customers_id']);
$list_type = $csl->getListType($order['customers_id']);
$cust_crown = $csl->getTypeSymbol($list_type, $order['customers_id']);
$customer_name = $cust_crown . $order['customers_name'];
$customer_address = '';
if ($order['customers_company'] != '') {
$customer_address .= $order['customers_company'] . ', ';
}
$customer_address .= $order['customers_street_address'];
$customer_address .= ', ' . $order['customers_postcode'];
$customer_address .= ' ' . $order['customers_city'];
$customer_address .= ', ' . $order['customers_country'];
$products_ordered = $class_mc->retrieveOrdersProducts($order['customers_id'], 'op.status>0');
$colname_order_id = 'orders_id';
$colname_items_id = 'orders_products_id';
$colname_order_date = 'date_purchased';
$colname_order_qty = 'products_quantity';
$colname_return_qty = 'return_quantity';
$colname_products_id = 'products_id';
$colname_products_code = 'products_model';
$colname_articles_id = 'products_articles_id';
$colname_custom_text1 = 'customers_text_line1';
$colname_custom_text2 = 'customers_text_line2';
$colname_custom_image = 'customers_image';
$order_history_display = null;
} elseif ($order_type == 'DP') {
$order = $class_do->retrieveDetail($order_id);
$product_detail = $class_pm->retrieveDetail($order['products_id'], 'p');
$order['products_image'] = $product_detail['p']['products_image'];
$order['products_model'] = $product_detail['p']['products_model'];
$order['order_item_count'] = '1';
$order['order_item_total'] = '1';
$order_products = array();
$order_products[] = $order;
$colname_order_id = 'depot_orders_id';
$colname_items_id = 'depot_orders_id';
$colname_order_date = 'order_date';
$colname_order_qty = 'quantity';
$colname_return_qty = '';
$colname_products_id = 'products_id';
$colname_products_code = 'products_model';
$colname_articles_id = 'articles_id';
$colname_custom_text1 = null;
$colname_custom_text2 = null;
$colname_custom_image = null;
if ($order['trans_type'] == 'SP' || $order['trans_type'] == 'JG') {
if ($order['trans_type'] == 'SP') {
$item = $class_jo->retrieveItemDetail($order['trans_id']);
//if ($item['jng_sp_id'] != '2') {
//echo "<pre>";
//var_dump($item);
//die("ttt");
if ($item['stock_status'] == '0') {
$order_history_display = drawOrderDisplay($order['trans_type'], $item['jng_sp_orders_id'], 'HISTORY', false);
}
$total_price = getTotalOrderAmount('S', $item['jng_sp_orders_id']);
//}
} else {
//die("test");
$item = $class_o->retrieveProductDetail($order['trans_id']);
$total_price = getTotalOrderAmount('J', $item['orders_id']);
if ($item['stock_status'] == '0') {
$order_history_display = drawOrderDisplay($order['trans_type'], $item['orders_id'], 'HISTORY', false);
}
}
}
}
$result = '';
if ($displaypart == 'ALL' || $displaypart == 'NEW') {
//NEW ORDER
$result .= '<h2 style="position:fixed;top:0;left:0;line-height:20px;width:480px;padding:5px 10px;background:#ccc;border-right:1px inset #666;">New ' . $order_type . ' Order ' . $order_id . ' (' . $total_price . ')</h2>';
//$result .= '<div style="position:fixed;top:30;bottom:0;left:0;width:480px;padding:10px;background:#efefef;border-right:1px inset #666;overflow:auto;">';
$result .= '<div id="box-order-items" style="position:fixed;top:30;bottom:0;height:93%;left:0;width:480px;padding:10px;background:#efefef;border-right:1px inset #666;overflow:auto;">';
$neworder = array();
$no = array();
$no['l'] = 'No';
$no['d'] = 'Image';
$no['t2'] = 'Info';
$no['q'] = 'Order<br/>Qty.';
$no['r'] = 'Stock Status<br /> and Actions';
$neworder[] = $no;
foreach ($order_products as $op) {
if ($op[$colname_articles_id] > 0) {
$article = $class_pa->retrieveDetail($op[$colname_articles_id]);
$prolength = $article['length'];
} else {
$product_detail = $class_pm->retrieveDetail($op[$colname_products_id], 'pnc');
$prolength = $product_detail['pnc']['products_length'];
}
$customize_info = '';
if (!is_null($colname_custom_text1) && !is_null($colname_custom_text2)) {
if ($op[$colname_custom_text1] != '' || $op[$colname_custom_text2] != '') {
$customize_info .= '<div style="margin-top:10px;">';
if ($op[$colname_custom_text1] != '') {
$customize_info .= $op[$colname_custom_text1];
}
if ($op[$colname_custom_text2] != '') {
$customize_info .= '<br />' . $op[$colname_custom_text2];
}
$customize_info .= '</div>';
}
}
if (!is_null($colname_custom_image) && $op[$colname_custom_image] != '') {
$customize_info .= webImage($op[$colname_custom_image], '80', '80', 'Custom Image');
}
$length_text = $prolength > 0 ? 'Length: ' . textLength($prolength) : '<span class="notice">No Length</span>';
//$tooltip_data = getTooltipThumbData($op[$colname_products_id], $op[$colname_articles_id], 0);
$pdata = $class_pm->retrieveDetail($op[$colname_products_id], 'pl,sp');
$tooltip_text = '<table class="tiny" border="0" cellpadding="0" cellspacing="0" align="center">';
$tooltip_text .= '<tr><td width="80" title="Sold Last 30 Days">Sold L30D</td><td>' . intval($pdata['pl']['sold_monthly_1']) . ' products</td></tr>';
$tooltip_text .= '<tr><td>Total sold</td><td>' . intval($pdata['sp']['0']['total_sold']) . ' products</td></tr>';
$tooltip_text .= '<tr><td>Return Rate</td><td>' . number_format($pdata['sp']['0']['returned_rate'], 1) . '%</td></tr>';
$tooltip_text .= '<tr><td>Product Age</td><td>' . $pdata['sp']['0']['active_age'] . ' days</td></tr>';
$tooltip_text .= '</table>';
$info = array();
//var_dump($order_type);
$info[] = $order_type . '-' . $op[$colname_items_id];
$info[] = $op['products_ean'];
$info[] = $op[$colname_products_id] . ' / ' . $op[$colname_products_code];
$info[] = $length_text;
$info[] = ' ';
$info[] = '<strong>All SP Summary</strong>';
$info[] = $tooltip_text;
$action_hidden = '<input type="hidden" id="' . $order_type . '-' . $op[$colname_items_id] . '" name="oiid" value="' . $op[$colname_items_id] . '" />';
$action_hidden .= '<input type="hidden" name="type" value="' . $order_type . '" />';
$action = array();
$action[] = stockStatusDisplay($op['stock_status'], $op['status'], $op[$colname_products_id], $op[$colname_articles_id], $op[$colname_order_qty], null);
$action[] = ' ';
if ($op['stock_status'] == 'S') {
$action[] = '<input type="button" name="2" value="» Sourcing" class="bl green" />';
} elseif ($op['stock_status'] == 'R' || $op['stock_status'] == 'P' || $op['stock_status'] == 'W') {
$action[] = '<input type="button" name="3" value="» Ready" class="bl green" />';
//$action[] = '<input type="button" name="test" value="» Sourcing" class="bl red" />';
}
$action[] = '<input type="button" name="10" value="× Cancel" class="bl red" />';
$no = array();
$no['l'] = $op['order_item_count'] . '/' . $op['order_item_total'];
$no['d'] = webImage($op['products_image'], '80', '80', 'Product Image') . $customize_info;
$no['t2'] = implode('<br />', $info);
if (isset($op['order_quantity'])) {
$order_quantity = $op['order_quantity'];
} elseif (isset($op['products_quantity'])) {
$order_quantity = $op['products_quantity'];
} else {
$order_quantity = $op['quantity'];
}
$no['q'] = $order_quantity;
$no['r'] = $action_hidden . implode('<br />', $action);
$neworder[] = $no;
}
$result .= tep_draw_table('spo', $neworder);
$result .= '<div class="buttons"><input type="button" name="nextorder" value="Next Order" class="button" /></div>';
$result .= '</div>';
//NEW ORDER - CLOSER
}
if (!is_null($order_history_display)) {
$result .= $order_history_display;
} elseif ($displaypart == 'ALL' || $displaypart == 'HISTORY') {
$result .= '<div style="margin-left:510px;color:#666;" >';
//HISTORICAL INFO
if ($order_type == 'DP') {
$result .= '<h2>DEPOT ' . ($order['trans_type'] == 'AR' ? 'REFILL' : 'MANUAL ORDER') . '</h2>';
} else {
//var_dump($order_type);
$result .= '<h2>Customer Detail</h2>';
// $result .= '<table border="0" cellpadding="0" cellspacing="0">';
// $result .= '<tr><td width="150">Customer From</td><td>'.$order_source.'</td></tr>';
// $result .= '<tr><td>Customer Name</td><td>'.$customer_name.'</td></tr>';
// $result .= '<tr><td>Customer Address</td><td>'.$customer_address.'</td></tr>';
// $result .= '<tr><td></td><td></td></tr>';
// $result .= '</table>';
$result .= '<div class="bold">' . $order_source . '</div>';
$result .= '<div>' . $customer_name . '</div>';
$result .= '<div>' . $customer_address . '</div>';
$result .= '<div> </div>';
$orders_collection = array();
$products_ordered_total = 0;
$products_returned_total = 0;
$products_canceled_total = 0;
$products_inprocess_total = 0;
foreach ($products_ordered as $pok => $pov) {
if ($excludecurrentorderinhistory && $pov[$colname_order_id] == $order[$colname_order_id]) {
unset($products_ordered[$pok]);
} else {
if (!in_array($pov[$colname_order_id], $orders_collection)) {
$orders_collection[] = $pov[$colname_order_id];
}
$products_ordered_total += $pov[$colname_order_qty];
$products_returned_total += $pov[$colname_return_qty];
if (statusIsCancelled($pov['status'])) {
$products_canceled_total += $pov[$colname_order_qty];
}
if ($pov['status'] < 9) {
$products_inprocess_total += $pov[$colname_order_qty];
}
}
}
$result .= '<h2>Customer Historical Info</h2>';
if ($products_ordered_total > 0) {
$products_success_total = $products_ordered_total - ($products_inprocess_total + $products_canceled_total);
$return_rate = $products_returned_total == 0 ? 0 : $products_returned_total / $products_success_total * 100;
$process_class = $products_inprocess_total > 0 ? 'red' : 'green';
$success_class = $products_success_total > 0 ? 'green' : 'red';
$return_class = $products_returned_total > 0 ? 'red' : 'green';
$return_rate_class = $return_rate <= 10 ? 'green' : 'red';
$prevtext = $excludecurrentorderinhistory ? 'Previous' : '';
$result .= '<h3>» Customer ' . $prevtext . ' Orders Total = ' . count($orders_collection) . '</h3>';
$result .= '<h3>» Ordered Products Total = ' . $products_ordered_total . '</h3>';
$result .= '<h3>» Ordered Products Canceled = ' . $products_canceled_total . '</h3>';
$result .= '<h3 class="' . $process_class . '">» Ordered Products in Progress = ' . $products_inprocess_total . '</h3>';
$result .= '<h3 class="' . $success_class . '">» Ordered Products Received = ' . $products_success_total . '</h3>';
$result .= '<h3 class="' . $return_class . '">» Ordered Products Returns = ' . $products_returned_total . '</h3>';
$result .= '<h3 class="' . $return_rate_class . '">» Customer Return Rate = ' . number_format($return_rate, 1) . '%</h3>';
$result .= '<h3>» Recent Ordered Products List (Showing Max ' . $po_limit . ' Products): ' . '</h3>';
$result .= '<div style="width:' . $powidth . 'px;">';
$pocount = 0;
foreach ($products_ordered as $po) {
$pocount++;
if ($pocount <= $po_limit) {
if ($po[$colname_articles_id] > 0) {
$article = $class_pa->retrieveDetail($po[$colname_articles_id]);
$prolength = $article['length'];
} else {
$product_detail = $class_pm->retrieveDetail($po[$colname_products_id], 'pnc');
$prolength = $product_detail['pnc']['products_length'];
}
$length_text = $prolength > 0 ? textLength($prolength) : '<span class="notice">No Length</span>';
$status = $po['status'] == '8' ? modeName($po['mode']) : statusNameShort($po['status'], true);
$status_class = $po['status'] < 9 ? 'red' : 'notice';
$qty_class = statusIsCancelled($po['status']) > 0 ? 'notice' : 'green';
$result .= '<div style="float:left;border:' . $border . 'px solid #ccc;text-align:center;margin:0 ' . $margin . 'px ' . $margin . 'px 0;padding:' . $padding . 'px;">';
$result .= webImage($po['products_image'], $imgsize, $imgsize);
$result .= '<br />';
$result .= $length_text;
$result .= '<br />';
$result .= '<span title="Order Date">' . date('d.m.Y', strtotime($po[$colname_order_date])) . '</span>';
$result .= '<br />';
$result .= '<span class="' . $status_class . '" title="Current Status">' . $status . '</span>';
$result .= '<br />';
$result .= '<strong class="' . $qty_class . '" title="Order Quantity">+' . intval($po[$colname_order_qty]) . '</strong>';
$result .= ' ';
$returns = intval($po[$colname_return_qty]);
$retclas = $returns > 0 ? 'red' : 'notice';
$result .= '<strong class="' . $retclas . '" title="Return Quantity">-' . $returns . '</strong>';
$result .= '</div>';
}
}
$result .= '</div>';
$result .= '<div style="clear:both;"> </div>';
} else {
$result .= '<h3>» No Order Historical info, a New Customer</h3>';
}
}
$result .= '</div>';
//HISTORICAL INFO - CLOSER
}
return $result;
}
$old_status = tep_db_prepare_input($_POST['op_status']);
$new_status = '12';
$useAltContent = true;
$product = $class_o->retrieveProductDetail($opid);
if ($product['status'] == $old_status) {
$products = $class_o->retrieveProducts($product['orders_id']);
$opids = array();
foreach ($products as $p) {
$class_o->updateProductStatus($p['orders_products_id'], $new_status, $session_userinfo['username']);
$opids[] = $p['orders_products_id'];
}
$class_o->sendProductStatusNotification($opids, $new_status, $languages[2]['path'], $useAltContent);
//Auto Blacklist Customer
$order = $class_o->retrieveDetail($product['orders_id']);
use_class('customers_special_list');
$class_csl = new customers_special_list();
$class_csl->addCustomer('B', $order['customers_id']);
$comment_text = 'Customer is added to blacklist automatically because of Unpaid Vorkasse Cancellation';
$class_csl->insertComment($order['customers_id'], $comment_text, 'System');
$result = array();
$result['op_id'] = implode(',', $opids);
$result['old_status'] = $old_status;
$result['new_status'] = $new_status;
ajaxReturn($result);
}
} elseif ($_POST['me_action'] == 'ONHOLDNOTIFICATION') {
$status = '13';
$opid = tep_db_prepare_input($_POST['op_id']);
$product = $class_o->retrieveProductDetail($opid);
if ($product['status'] == $status) {
$products = $class_o->retrieveProducts($product['orders_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') {
<?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']);
<?php
use_class('customers_special_list');
$class_csl = new customers_special_list();
//AJAX ACTION
if (isset($_GET['type'])) {
$type = tep_db_prepare_input($_GET['type']);
$list = $class_csl->retrieveList($type);
$result = '';
$result .= '<h2>';
$result .= $class_csl->getTypeSymbol($type) . ' ';
$result .= $class_csl->getTypeName($type) . ' Customers';
$result .= '</h2>';
$result .= '<div style="margin:10px 0 20px 0;">';
if ($type != 'N') {
$result .= '<a href="?open=customers-special-list-add&type=' . $type . '&hidemenu=true" class="view_webpage"></a>';
$result .= '<input type="button" class="button" name="addnew" value="Add Customer" onclick="$(this).siblings(\'a\').click();" />';
} else {
$result .= '<span class="notice">When removed from Blacklist/VIP list, customer will be moved here so all historical information is not lost</span>';
}
$result .= '</div>';
if (count($list) == 0) {
$result .= '<h3 class="red">No customer is found</h3>';
} else {
$table = array();
$t = array();
$t['d'] = 'ID';
$t['c'] = 'Name';
$t['a'] = 'Action';
$table[] = $t;
foreach ($list as $l) {
