$box_date = date('d. M', $order_date);
//Retrieve all products from the order
$items = $class_jo->retrieveItems($order['jng_sp_orders_id']);
foreach ($items as $key => $i) {
//Exclude any canceled products
$iscanceled = $class_jo->statusIsCancelled($i['status']);
if ($iscanceled) {
unset($items[$key]);
}
}
if ($item['order_item_total'] == '1' || count($items) == 1) {
//If order only consist of 1 product
$packages = $class_jp->getUsablePackages($order['jng_sp_id']);
if (count($packages) == 0) {
//If no usable package found for this SP, create 1
$package_id = $class_jp->createNew($order['jng_sp_id']);
} else {
//If usable package found fo this SP, use it
$package_id = $packages[0]['jng_sp_packages_id'];
}
//Add product to package and update product status
$sp_id = $order['jng_sp_id'];
if (in_array($sp_id, $order_show_sp_info)) {
use_class('jng_sp');
$class_sp = new jng_sp();
$sp = $class_sp->retrieveDetail($sp_id);
$sp_name = $sp['package_prefix'];
}
$class_jp->addItem($package_id, $id);
$class_jo->updateItemStatus($id, $new_status, $session_userinfo['username']);
$result .= printPackageTip('P', $box_date, '', $sp_name, $sp_class);
$result['msg_errors'] = '';
} else {
$result = array();
$result['oi_id'] = $items_id;
$result['old_status'] = $old_status;
$result['new_status'] = $item['status'];
$result['msg_sukses'] = '';
$result['msg_errors'] = oiErrorStatus($items_id, $item['status'], $old_status);
}
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'CREATENEWPACKAGE') {
$package_code = tep_db_prepare_input($_POST['package_code']);
use_class('jng_sp_packages');
$class_jp = new jng_sp_packages();
$newpackage = $class_jp->createNew($jng_sp_id, $package_code);
$usable_packages = $class_jp->getUsablePackages($jng_sp_id);
$packages = '<h3>';
$packages .= 'Package: ' . $class_jp->packageCombo($usable_packages, 'package', $newpackage, 'id="selpack" style="background:#fcc;"');
$packages .= ' <input type="button" class="actbtn" name="addall2pack" value="Add all products to this Package" title="Add all listed products to the selected package" />';
$packages .= '</h3>';
echo $packages;
exit;
} elseif ($_POST['me_action'] == 'ADDTOPACKAGE') {
$items_id = tep_db_prepare_input($_POST['oi_id']);
$package_id = tep_db_prepare_input($_POST['package_id']);
$old_status = '5';
$new_status = '6';
$item = $class_jo->retrieveItemDetail($items_id);
if ($item['status'] == $old_status) {
use_class('jng_sp_packages');
