$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();
