$result['rack_id'] = $rack_id; $result['new_status'] = $status; $result['img_status'] = $img_status; $result['segment_id'] = $rack['segment_id']; ajaxReturn($result); } elseif ($_POST['me_action'] == 'CLEARRACK') { $segment = $class_bin->retrieveSegmentDetail($rack['segment_id']); $jng_warehouses_id = $segment['warehouses_id']; $rack_bins = $class_bin->retrieveBins($rack['segment_id'], $rack_id); foreach ($rack_bins as $bin) { $products_id = $bin['products_id']; $articles_id = $bin['articles_id']; if ($products_id > 0) { $booked = $class_pm->productsBookedCount($jng_warehouses_id, $products_id, $articles_id); if ($booked === 0) { $class_bin->removeProductFromBox($bin['bins_id']); if ($bin['products_stock'] > 0) { $class_pm->stockReduce($jng_warehouses_id, $products_id, $articles_id, $bin['products_stock'], "CLEAR RACK by {$session_userinfo['username']}"); } } } } header("Location: ?open=rack-info&id={$rack_id}&reloadsegment=true" . ($hidemenuscript != '' ? '&hidemenu=true' : '')); exit; } elseif ($_POST['me_action'] == 'CLEARRACKNBS') { $logger = new logger('modules', 'rack-info'); use_class('products_minierp'); $class_pm = new products_minierp(); $segment = $class_bin->retrieveSegmentDetail($rack['segment_id']); $jng_warehouses_id = $segment['warehouses_id']; $rack_bins = $class_bin->retrieveBins($rack['segment_id'], $rack_id);
$history_options_2[0] = 'in Details'; $history_options_2[1] = 'Daily Summary'; //POST ACTION if (isset($_POST['me_action']) && $_POST['me_action'] != '') { if ($_POST['me_action'] == 'CLEARBIN') { $bins_id = tep_db_prepare_input($_POST['bins_id']); $bin = $class_bin->retrieveBinDetail($bins_id); $segment = $class_bin->retrieveSegmentDetail($bin['bin_segments_id']); $jng_warehouses_id = $segment['warehouses_id']; $products_id = $bin['products_id']; $articles_id = $bin['articles_id']; $booked = $class_pm->productsBookedCount($jng_warehouses_id, $products_id, $articles_id); if ($booked > 0) { $messagebox->add("<strong>Clear Bin Failed</strong><br />Clear Bin is not allowed if On Stock and Booked by Real Order > 0"); } else { $class_bin->removeProductFromBox($bins_id); if ($bin['p_stock'] > 0) { $class_pm->stockReduce($jng_warehouses_id, $products_id, $articles_id, $bin['p_stock'], "REDUCE by {$session_userinfo['username']}"); } header("Location: ?open=products-stock-detail&binid={$bin['bins_id']}" . ($hidemenuscript != '' ? '&hidemenu=true' : '')); exit; } } elseif ($_POST['me_action'] == 'SETBIN') { $bins_id = tep_db_prepare_input($_POST['bins_id']); $bin = $class_bin->retrieveBinDetail($bins_id); $ean = tep_db_prepare_input($_POST['ean']); $qty = tep_db_prepare_input($_POST['qty']); use_class('products_ean'); $class_ean = new products_ean(); $article = $class_ean->getProductArticle($ean); if ($article['products_id'] == '0') {
//PREPARE SENDBACK DATA $sendback = array(); $clear_success = array(); $total_product_clear = 0; while ($row = tep_db_fetch_array($dbq)) { if ($segment['used_for'] == 'P') { $sendback['bin_segments_id'] = $segment_id; $sendback['type'] = 'D'; $sendback['products_id'] = $row['products_id']; $sendback['products_articles_id'] = $row['articles_id']; $sendback['products_ean'] = $class_pean->getEAN($row['products_id'], $row['articles_id']); $sendback['quantity_stock'] = intval($row['stock']); $sendback['quantity_actual'] = isset($qty_changes[$row['bins_id']]['qty_actual']) && $qty_changes[$row['bins_id']]['qty_actual'] != $row['stock'] ? $qty_changes[$row['bins_id']]['qty_actual'] : $row['stock']; $sendback_id = $class_sendback->create($sendback); //CLEAR CONNECTION ON BOX $class_bins->removeProductFromBox($row['bins_id']); $clear_success[$sendback_id] = "{$row['products_id']}-{$row['articles_id']}"; } elseif ($segment['used_for'] == 'E') { } $total_product_clear += $sendback['quantity_actual']; } $msg = 'Success clearing ' . $total_product_clear . ' product(s) from ' . count($clear_success) . ' box(es)'; echo utf8_encode($msg); } else { $total_clear = tep_db_num_rows($dbq); $clean_lists = '<fieldset id="clearance-lists" style="background:#fff;padding:20px 30px 30px 30px; width:600px;" class="ui-corner-all">'; $clean_lists .= '<legend style="font-size:16px;font-weight:bold;">Results of "' . ($clearance_period == 30 ? 'Monthly' : ($clearance_period == 60 ? 'Monthly' : ($clearance_period == 90 ? 'Trimonthly' : 'Weekly'))) . ' Sold = 0" Clearance (' . $total_clear . ' articles)</legend>'; $clean_lists .= '<h2 class="blue">Please do clearance on box and confirm actual stock below !</h2>'; $clean_lists .= '<div style="margin:10px 0 10px 0;float:left;">'; $table = array(); $clean_picklists = array();