$reference = $order['shipment_id'];
$cod_value = $order['payment_method'] == 'CASH_ON_DELIVERY' ? number_format($invoice->detail['invoice_amount'], 2, ',', '') : 0;
break;
}
if ($order['customer_shipping_address2'] != '') {
$shipping_address .= ' ' . $order['customer_shipping_address2'];
}
$mc_order = mc_orderDetail($order['jng_sp_id'], $reference, $display_counter, $shipping_name, $shipping_address, $order['customer_shipping_city'], $order['customer_shipping_postcode'], $cod_value);
}
}
} elseif ($order_type == 'JG') {
use_class('orders');
$class_o = new orders();
$i_temporary = $class_o->retrieveProductDetail($item_id);
if (isset($i_temporary['status']) && $i_temporary['status'] != $REQUIRED_STATUS) {
$i_status = $class_o->productStatusName();
$result['status'] = 'BADSTATUS';
$result['badstatus'] = $i_status[$i_temporary['status']];
} else {
$order_id = $i_temporary['orders_id'];
$order = $class_o->retrieveDetail($order_id);
if (isset($order['orders_id'])) {
$display_counter = dailyCounterNo($order['date_purchased'], $order['daily_count']);
$mc_order = mc_orderDetail('0', 'JG' . $order['orders_id'], $display_counter, $order['delivery_name'], $order['delivery_street_address'], $order['delivery_city'], $order['delivery_postcode'], 0);
}
}
} else {
$order_id = '';
$result['status'] = 'BADREQUEST';
}
$result['id'] = $order_id;
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_o = new orders();
$class_do = new depot_orders();
//use_class('minierp_todos');
//$class_td = new minierp_todos();
//AJAX LOADING
if (isset($_GET['week-sum']) && $_GET['week-sum'] != '') {
$weekly_days = 7;
$weekly_sum = array();
$periods = array();
$result = '';
//QUERY WEEKLY SUMMARY
$weekly_sum_date = array();
if ($_GET['week-sum'] == 'JNGAK') {
$statusName = $class_o->productStatusName();
$statusGet = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 11);
$q = tep_db_query("SELECT status, SUM(products_quantity) AS total FROM orders_products WHERE products_id=55724 GROUP BY status");
$ak_counter = array();
while ($row = tep_db_fetch_array($q)) {
$ak_counter[$row['status']] = $row['total'];
}
$q = tep_db_query("SELECT status, SUM(order_quantity) AS total FROM jng_sp_orders_items WHERE products_id=55724 GROUP BY status");
$ak_counter_sp = array();
while ($row = tep_db_fetch_array($q)) {
$ak_counter_sp[$row['status']] = $row['total'];
}
$total = 0;
$total_sp = 0;
$total_jg = 0;
$table = array();
<?php
use_class('orders');
$class_o = new orders();
//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']));
$orders = $class_o->searchOrders($search_field, $search_keywords, "op.status NOT IN (9,10,11,12)");
$result = '';
if (count($orders) > 0) {
$itemStatus = $class_o->productStatusName();
$table = array();
$t = array();
$t['c'] = 'Order Info';
$t['a'] = 'Product Code';
$t['r'] = 'Cancel by';
$t['t'] = 'Action';
$table[] = $t;
foreach ($orders as $row) {
$order_date = strtotime($row['date_purchased']);
$item_count = "{$row['order_item_count']}/{$row['order_item_total']}";
$t = array();
$info = array();
$info[] = 'No: <a href="?open=order&id=' . $row['orders_id'] . '" target="_blank" title="View Order Detail">' . $row['orders_no'] . '</a> <span class="notice">(' . $item_count . ')</span>';
$info[] = 'Date: ' . date('d-M-y', $order_date);
$info[] = 'Cust: <a href="?open=customer&id=' . $row['customers_id'] . '" target="_blank" title="View Customer Detail" >' . $row['customers_name'] . '</a> <span class="notice">(' . $row['customers_order_count'] . ')</span>';
$info[] = 'Product: <a href="?open=product-detail&products_id=' . $row['products_id'] . '" target="_blank" title="View product detail">' . $row['products_model'] . '</a>';
$info[] = 'Qty: ' . $row['products_quantity'];
$info[] = 'Price: ' . $row['final_price'];
