$history_options[5] = '6 Months';
$history_options[6] = '1 Year';
$history_options[7] = 'Hide History';
$history_options_2 = array();
$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']);
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);
$bins_cleared = array();
$logger->write('Clearing NBS for Rack ' . $rack_no);
foreach ($rack_bins as $bin) {
if ($bin['is_bestselling'] != '1') {
$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 NBS RACK by {$session_userinfo['username']}");
}
$bins_cleared[] = $bin['code'];
$logger->write('BIN:' . $bin['code'] . ' > PID-AID:' . $products_id . '-' . $articles_id . ' > STOCK:' . $bin['products_stock']);
}
}
}
}
if (count($bins_cleared) > 0) {
$_SESSION['bins_cleared_rack_no'] = $rack_no;
$_SESSION['bins_cleared'] = serialize($bins_cleared);
}
$total_qty_total = 0;
$total_matexp_tot = 0;
while ($row = tep_db_fetch_array($r)) {
$pid = $row['products_id'];
$aid = $row['products_id'] . ' - ' . $row['articles_id'];
if (!in_array($pid, $products)) {
$products[] = $pid;
}
if (!in_array($aid, $articles)) {
$articles[] = $aid;
}
$stocks[] = $row;
//if($row['booked_jng']>0 || $row['booked_sp']>0) var_dump($row);
$stock_database = $row['stock'];
$bookmanual = $row['booking_active'];
$stock_on_and_bookedbyrealorder = $class_pm->productsBookedCount($whid, $row['products_id'], $row['articles_id']);
$stock_on_and_bookedmanually = $bookmanual > $stock_database ? $stock_database : $bookmanual;
$stock_available = $stock_database - $stock_on_and_bookedmanually;
$stock_on_total = $stock_database + $stock_on_and_bookedbyrealorder;
$matexp = $row['material_expenses'];
$matexp_tot = $stock_on_total * $matexp;
if ($row['bin_code'] != '') {
$total_bins++;
} else {
$total_bins_unknown++;
}
$total_qty_stock += $stock_available;
$total_qty_booked_m += $stock_on_and_bookedmanually;
$total_qty_booked_r += $stock_on_and_bookedbyrealorder;
$total_qty_total += $stock_on_total;
$total_matexp_tot += $matexp_tot;
function transferBin($bin_id_old, $bin_id_new)
{
use_class('products_minierp');
$class_pm = new products_minierp();
$bin_old = $this->retrieveBinDetail($bin_id_old);
$bin_new = $this->retrieveBinDetail($bin_id_new);
$segment = $this->retrieveSegmentDetail($bin_old['bin_segments_id']);
$booked = $class_pm->productsBookedCount($segment['warehouses_id'], $bin_old['products_id'], $bin_old['articles_id'], true);
if ($booked == 0 && is_null($bin_new['products_stock_id'])) {
$sda = array('products_stock_id' => 'null');
tep_db_perform('bins', $sda, 'update', "bins_id={$bin_id_old}");
$sda = array('products_stock_id' => $bin_old['products_stock_id']);
tep_db_perform('bins', $sda, 'update', "bins_id={$bin_id_new}");
$this->binLogger("Transfer PID {$bin_old['products_id']} AID {$bin_old['articles_id']} from BIN {$bin_old['code_clean']} (ID {$bin_id_old}) to BIN {$bin_new['code_clean']} (ID {$bin_id_new})");
$result = true;
} else {
$result = false;
}
return $result;
}
$ean = tep_db_prepare_input($_POST['ean']);
if ($_SESSION[$session_page]['last_scan'] == "{$segment_id}|{$ean}") {
$_SESSION[$session_page]['last_scan_count']++;
} else {
$_SESSION[$session_page]['last_scan'] = "{$segment_id}|{$ean}";
$_SESSION[$session_page]['last_scan_count'] = 1;
}
$bin = $class_bins->getBinByEAN($segment_id, $ean);
$bin['scanned3times'] = $_SESSION[$session_page]['last_scan_count'] >= 3 ? '1' : '0';
ajaxReturn($bin);
exit;
} elseif ($_POST['me_action'] == 'CHECKBOOKEDCONDITION') {
$bin_id = tep_db_prepare_input($_POST['bin_id']);
$bin = $class_bins->retrieveBinDetail($bin_id);
$segment = $class_bins->retrieveSegmentDetail($bin['bin_segments_id']);
$booked = $class_pm->productsBookedCount($segment['warehouses_id'], $bin['products_id'], $bin['articles_id'], true);
$result = $booked > 0 ? 'REJECT' : 'OK';
echo utf8_encode($result);
exit;
} elseif ($_POST['me_action'] == 'LOADRACKS') {
$segment_id = tep_db_prepare_input($_POST['segment_id']);
$racks = $class_bins->retrieveRacks($segment_id);
$rack_combo_options = array();
$rack_combo_options[0] = '';
foreach ($racks as $rack) {
$rack_combo_options[$rack['bin_racks_id']] = 'Rack ' . $class_bins->formatRackNumber($rack['no']) . ' (' . $class_bins->rack_flag_options[$rack['rack_flag']] . ')';
}
echo utf8_encode('<select>' . loadComboListFromArray($rack_combo_options) . '</select>');
exit;
} elseif ($_POST['me_action'] == 'LOADBIN') {
$segment_id = tep_db_prepare_input($_POST['segment_id']);
$t['st w040 tac'] = 'Stock Total';
$t['pid w080 tac'] = 'Product ID';
$t['pco w080 tac'] = 'Product Code';
$t['length w080 tac'] = 'Length';
$table[] = $t;
$q = "SELECT ps.*, b.code, IFNULL(pa.products_ean, p.products_ean) AS products_ean";
$q .= ", p.products_model, pa.length FROM products_stock ps";
$q .= " INNER JOIN bins b ON b.products_stock_id = ps.products_stock_id";
$q .= " LEFT JOIN products p ON p.products_id = ps.products_id";
$q .= " LEFT JOIN products_articles pa ON pa.products_articles_id = ps.articles_id";
$q .= " WHERE ps.jng_warehouses_id = " . WAREHOUSE_ID_PRODUCTS_HAMBURG . " AND ps.products_id IN ({$pids})";
$q .= " ORDER BY b.code ASC";
$r = tep_db_query($q);
$no = 0;
while ($row = tep_db_fetch_array($r)) {
$stock_book_by_real_order = $class_pm->productsBookedCount(WAREHOUSE_ID_PRODUCTS_HAMBURG, $row['products_id'], $row['articles_id']);
$stock_database = $row['stock'];
$book_manual = $row['booking_active'];
$stock_on_and_booked_manually = $book_manual > $stock_database ? $stock_database : $book_manual;
$stock_available = $stock_database - $stock_on_and_booked_manually;
$stock_on_total = $stock_database + $stock_book_by_real_order;
$no++;
$t = array();
$t['no w040 tac'] = $no;
$t['bin w100 tac'] = $row['code'];
$t['ean w100 tac'] = $row['products_ean'];
$t['stock w040 tac'] = $stock_available == '' ? "0" : $stock_available;
$t['sb_manual w100 tac'] = $book_manual;
$t['sb_real_order w100 tac'] = $stock_book_by_real_order == '' ? "0" : $stock_book_by_real_order;
$t['st w040 tac'] = $stock_on_total;
$t['pid w080 tac'] = $row['products_id'];
