$trolley[key($trolley)] = $oid;
} elseif ($trolley[key($trolley)] != $oid) {
next($trolley);
$trolley[key($trolley)] = $oid;
}
if (!isset($ean_collection[$ean_id])) {
$ean_collection[$ean_id] = $oi['products_ean'];
}
$orders[$oid][$oiid] = $oi;
$oi_printed_sp[] = $oiid;
$total_products_picked += $oi['order_quantity'];
$prev_oid = $oid;
}
//GET FOR JnG ORDERS
if (!$PRINT_RETAILS && count($orders) < $trolley_capacity) {
$jg_orders = $class_o->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG, '', $filter_ir_jg);
$prev_oid = '';
foreach ($jg_orders as $oiid => $oi) {
$oid = 'JGO' . $oi['orders_id'];
$ean_id = $oi['products_id'] . '-' . $oi['products_articles_id'];
$oi['order_quantity'] = intval($oi['products_quantity']);
if ($prev_oid != $oid && count($orders) >= $trolley_capacity) {
break;
}
if (!isset($ean_collection[$ean_id])) {
$ean_collection[$ean_id] = $class_ean->getEAN($oi['products_id'], $oi['products_articles_id']);
}
$oi['products_ean'] = $ean_collection[$ean_id];
if (!isset($orders[$oid])) {
$orders[$oid] = array();
$orders_barcode[$oid] = 'JG-' . $oiid;
use_class('jng_sp_orders');
$class_o = new orders();
$class_jo = new jng_sp_orders();
$inhh_status = '8';
$whid_fg_hh = '5';
//exclude order which product need repackaged by HH team
$filter_exclude_repackage_sp = ' AND jo.need_repackaging != 1';
$filter_exclude_repackage_jg = 'o.need_repackaging != 1';
//include order which product need repackaged by HH team
$filter_include_repackage_sp = ' AND jo.need_repackaging = 1';
$filter_include_repackage_jg = 'o.need_repackaging = 1';
//------------------------------------------------------------------------------
//SP NORMAL ORDERS
$sp_orders = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, $whid_fg_hh, "", "jo.jng_sp_id NOT IN (5,6,7,9) {$filter_exclude_repackage_sp}");
//JG NORMAL ORDERS
$jg_orders = $class_o->retrieveOrdersItemsFromDepo($inhh_status, $whid_fg_hh, "", $filter_exclude_repackage_jg);
$orders_total = count($sp_orders) + count($jg_orders);
//SP NEED REPACKAGE
$sp_orders_r = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, $whid_fg_hh, "", "jo.jng_sp_id NOT IN (5,6,7,9) {$filter_include_repackage_sp}");
//JG NEED REPACKAGE
$jg_orders_r = $class_o->retrieveOrdersItemsFromDepo($inhh_status, $whid_fg_hh, "", $filter_include_repackage_jg);
$orders_total_r = count($sp_orders_r) + count($jg_orders_r);
//------------------------------------------------------------------------------
//AMAZON VENDOR NORMAL ORDERS
$sp_orders_amvd = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, $whid_fg_hh, "", "jo.jng_sp_id = 5 {$filter_exclude_repackage_sp}");
$orders_total_amvd = count($sp_orders_amvd);
//AMAZON VENDOR NEED REPACKAGE
$sp_orders_amvd_r = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, $whid_fg_hh, "", "jo.jng_sp_id = 5 {$filter_include_repackage_sp}");
$orders_total_amvd_r = count($sp_orders_amvd_r);
//------------------------------------------------------------------------------
//JEWELRY RETAILS NORMAL ORDERS
