$atds = true; //PLEASE USE FALSE WHEN DEBUGGING FOR ERRORS, SO IT WONT ADDED TO DAILY STATISTIC } //MAKE TROLLEY ARRAY DIMENSIONS $trolley = array(); for ($tbox = 1; $tbox <= $trolley_box; $tbox++) { for ($tbins = 1; $tbins <= $trolley_bins_per_box; $tbins++) { $trolley["{$tbox}-{$tbins}"] = null; } } current($trolley); //echo "<pre>";var_dump($trolley[key($trolley)]);die(); $filter = $PRINT_RETAILS ? 'jo.jng_sp_id=6' : 'jo.jng_sp_id NOT IN (5,6,7,9)'; $filter .= $filter_ir_sp; $barcode_prefix = $PRINT_RETAILS ? 'JR' : 'SP'; $sp_orders = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG, "", $filter); $pick_from_racks = array(); $prev_oid = ''; foreach ($sp_orders as $oiid => $oi) { $oid = $barcode_prefix . 'O' . $oi['jng_sp_orders_id']; $ean_id = $oi['products_id'] . '-' . $oi['products_articles_id']; $oi['order_quantity'] = intval($oi['order_quantity']); if ($prev_oid != $oid && count($orders) >= $trolley_capacity) { break; } if (!isset($orders[$oid])) { $orders[$oid] = array(); $orders_barcode[$oid] = $barcode_prefix . '-' . $oiid; } if (!isset($bin_location_qty_collection[$oi['bin_code']])) { $bin_location_qty_collection[$oi['bin_code']] = 0;
if ($tc == '') { $tc = '8;9'; } //DEFAULT TROLLEY BINS DIMENSION (8 box, 9 bins per box) list($trolley_box, $trolley_bins_per_box) = split(';', $tc); $trolley_capacity = $trolley_box * $trolley_bins_per_box; //MAKE TROLLEY ARRAY DIMENSIONS $trolley = array(); for ($tbox = 1; $tbox <= $trolley_box; $tbox++) { for ($tbins = 1; $tbins <= $trolley_bins_per_box; $tbins++) { $trolley["{$tbox}-{$tbins}"] = null; } } current($trolley); //echo "<pre>";var_dump($trolley[key($trolley)]);die(); $sp_orders = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG, 'jo.order_date ASC, jo.order_id ASC, joi.products_ean ASC', "jo.jng_sp_id={$jng_sp_id} {$filter_ir}"); $pick_from_racks = array(); $prev_oid = ''; foreach ($sp_orders as $oiid => $oi) { $oid = 'SPO' . $oi['order_id']; $ean = $oi['products_ean']; $ean_id = $oi['products_id'] . '-' . $oi['products_articles_id']; $oi['order_quantity'] = intval($oi['order_quantity']); if ($prev_oid != $oid && count($orders) >= $trolley_capacity) { break; } if (!isset($orders[$oid])) { $orders[$oid] = array(); //$orders_barcode[$oid] = 'SP-'.$oiid; $orders_barcode[$oid] = $prefix . '-' . $oi['order_id']; }
//end .kpi-infobox $result .= '<div style="padding-bottom:10px;"><strong>Query Date </strong><input type="text" id="kpiprod" title="select date to load statistic on graph" class="date_picker input" readonly="readonly" value="' . $date_id_userformat . '"/></div>'; $result .= '<div id="kpi-prod-content">'; $result .= '<div id="kpi-prod-graph"></div>'; $result .= '<div style="margin-top:10px;"><input id="btn-show-fullscreen" type="button" class="button" value="Show Fullscreen for Production LCD Display"/>'; $result .= '<div id="kpi-prod-tables" style="margin-top:20px;">'; $result .= $kpi_prod_daily_output; $result .= '</div>'; //end #kpi-prod-tables $result .= '</div>'; //end #kpi-prod-content $result .= '</div>'; } } elseif ($_GET['week-sum'] == 'KPI-LOG') { $inhh_status = '8'; $sp_orders_main = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG, "", "jo.jng_sp_id!='5'"); $sp_orders_amvd = $class_jo->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG, "", "jo.jng_sp_id='5'"); $sp_orders_amvd_total = count($sp_orders_amvd); $jg_orders = $class_o->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG); $orders = array(); $products = count($sp_orders_main) + $sp_orders_amvd_total + count($jg_orders); $products_qty = 0; foreach ($sp_orders_main as $oiid => $oi) { $products_qty += $oi['order_quantity']; $oid = 'SPO' . $oi['jng_sp_orders_id']; if (!in_array($oid, $orders)) { $orders[] = $oid; } } foreach ($sp_orders_amvd as $oiid => $oi) { $products_qty += $oi['order_quantity'];
use_class('orders'); 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);