//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') { $messagebox->add("<strong>Manual Bin In Failed: UNKNOWN EAN</strong><br />Please check if correct EAN Label is used"); } else {
if ($oi['print_confirmed'] > 0) { $class_do->printConfirmAdd($item_do['depot_orders_id']); } if ($order_type == 'SP') { $class_jo->updateItemStockStatus($oiid, '0'); $class_jo->updateItemStatus($oiid, $new_status, 'auto-set'); } else { $class_o->updateProductStockStatus($oiid, '0'); $class_o->updateProductStatus($oiid, $new_status, 'auto-set'); } } } } } else { //PRODUCT AVAILABLE IN DEPOT $class_pm->stockReduce($whid_depot, $oi['products_id'], $oi['products_articles_id'], $order_qty, 'RED-FG ' . $order_type . '-' . $oiid); $products_stock[$stock_id] -= $order_qty; if ($products_stock[$stock_id] < 0) { $products_stock[$stock_id] = 0; } if (isset($products_stock_booked_instock[$stock_id])) { $products_stock_booked_instock[$stock_id] -= $order_qty; } if ($order_type == 'SP') { $class_jo->updateItemStockStatus($oiid, 'D'); if ($oi['status'] != $new_status) { //PRODUCT IS NOT YET MOVED TO IN HH TAB $class_jo->updateItemStatus($oiid, $new_status, 'auto-set'); if ($oi['status'] < 4) { $class_jo->productionTargetInReset($oi); }
$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); } $logger->close(); header("Location: ?open=rack-info&id={$rack_id}&clearnbs=true&reloadsegment=true" . ($hidemenuscript != '' ? '&hidemenu=true' : '')); exit; }
<?php global $db; require_once '../confy.php'; require_once '../functions.php'; require_once '../functions-2.php'; tep_db_connect(); use_class('products_minierp'); $class_pm = new products_minierp(); $jng_warehouses_id_fg = '7'; //7 is default warehouse for finished goods in bali $products_id = 26272; $products_stock = is_null($products_id) || $products_id == '' ? 0 : $class_pm->stockRetrieve($jng_warehouses_id_fg, $products_id); $class_pm->stockReduce($jng_warehouses_id_fg, $products_id, 1); //$row['stock_status'] = $this->updateItemStockStatus('', 'P'); echo "Product {$products_id} Stock = {$products_stock}"; tep_db_close();