use_class('stock_booking');
$class_o = new orders();
$class_do = new depot_orders();
$class_jo = new jng_sp_orders();
$class_pm = new products_minierp();
$class_es = new elements_stock();
$class_ean = new products_ean();
$elements_collection = array();
$temp_order_date = array();
$temp_jng_sp_id = array();
$temp_import_timestamp = array();
$otto_prepayment = strtoupper(PAYMENT_METHOD_PREPAYMENT);
$oi_status_to_reset_stock_status = array('1', '2');
//CLEAR IDLE BINS
use_class('bins');
$class_bin = new bins();
$class_bin->clearIdleBins();
//INIT FULL ORDERS VARIABLE
$orders = array();
$orders_type = array();
$orders_total = array();
$orders_id_col = array();
$orders_allowed_to_override_booking = array();
/* ORDER PRIORITY
*
* Array key is used to set the order type
*
* Priority is set by the value of the array.
* Possible values are: A0 - Z9
* First Characters = A-Z, 2nd Characters = 0-9
* Below is priority sample list from higher to lower:
<?php
use_class('depot_orders');
use_class('bins');
$class_do = new depot_orders();
$class_bin = new bins();
$id = tep_db_prepare_input($_GET['id']);
$package = $class_do->packageDetail($id);
if (is_null($package)) {
$package_code = '';
$content .= '<h3 class="red">Package Not Found</h3>';
} else {
$package_code = $package['package_code'];
$sent_date = is_null($package['sent_date']) ? '<span class="notice">UNSET</span>' : date('d F Y', strtotime($package['sent_date']));
$received_date = is_null($package['received_date']) ? '<span class="notice">UNSET</span>' : date('d F Y', strtotime($package['received_date']));
$segment = $class_bin->retrieveSegmentDetail($package['segments_id']);
$contents = $class_do->packageGetContents($id);
$contents_table = array();
$ct = array();
$ct['d'] = 'Date';
$ct['o'] = 'Order ID';
$ct['e'] = 'Order Source';
$ct['a'] = 'Article No';
$ct['a2'] = 'EAN';
$ct['q'] = 'Quantity';
$ct['d2'] = 'Time Added';
$contents_table[] = $ct;
$counter_orders = 0;
$counter_products = 0;
foreach ($contents as $do) {
$counter_orders++;
use_class('orders');
use_class('depot_orders');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('jng_sp_packages');
use_class('minierp_packages');
use_class('products_ean');
use_class('bins');
$class_o = new orders();
$class_do = new depot_orders();
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_jp = new jng_sp_packages();
$class_mp = new minierp_packages();
$class_ean = new products_ean();
$class_bins = new bins();
$item_status = statusName();
define('EAN_MISMATCH_ERROR', 'EANMISMATCH');
$waiting_box_name = 'Waiting Box';
$packing_box_name = 'Packing Box';
$finish_box_name = 'Finish Box';
$order_show_sp_info = array('9');
//am.fr
function printPackageTip($type, $no, $info = '', $spname = '', $spclass = '')
{
global $waiting_box_name, $packing_box_name;
if ($type == EAN_MISMATCH_ERROR) {
$result = '<div class="package-tip red-bright">';
$result .= 'EAN Code<br />MISMATCH';
$result .= '</div>';
//$result .= '<div class="package-tip-info">Required EAN: '..'</div>';
<?php
//PRINT DEPOT STOCK LIST (AVAILABLE, BOOKED AND TOTAL)
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('bins');
use_class('products_minierp');
$class_bins = new bins();
$class_pm = new products_minierp();
$segment_id = isset($_GET['segments_id']) && $_GET['segments_id'] != '' ? tep_db_prepare_input($_GET['segments_id']) : '';
$rack_id = isset($_GET['rack_id']) && $_GET['rack_id'] != '' ? tep_db_prepare_input($_GET['rack_id']) : '';
if ($rack_id != '') {
$rack = $class_bins->retrieveRackDetail($rack_id);
$rack_no = $class_bins->formatRackNumber($rack['no']);
$segment_id = $rack['segment_id'];
}
$segment = $class_bins->retrieveSegmentDetail($segment_id);
if (!isset($segment['name'])) {
echo 'UNKNOWN SEGMENT!';
exit;
} else {
$whid = $segment['warehouses_id'];
}
$q = "SELECT ps.products_id, ps.articles_id, ps.stock, ps.booking_active";
$q .= ", IFNULL(pa.products_ean, p.products_ean) AS products_ean, IFNULL(pa.length, pnc.products_length) AS length, pa.text";
$q .= ", p.products_image, p.material_expenses, b.code AS bin_code";
$q .= ", cd.categories_name";
//$q .= ", SUM(op.products_quantity) AS booked_jng, SUM(joi.order_quantity) AS booked_sp";
<?php
use_class('bins');
use_class('products_minierp');
$class_bin = new bins();
$class_pm = new products_minierp();
//GET PAGE & WAREHOUSE OPTIONS
warehouseFGCombo();
$session_page = 'sp-products-manage';
$page = 1;
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
}
if (isset($_POST['keywords'])) {
$_SESSION[$session_page]['keywords'] = tep_db_prepare_input($_POST['keywords']);
}
if (!isset($_SESSION[$session_page]['keywords'])) {
$_SESSION[$session_page]['keywords'] = '';
}
$keywords = $_SESSION[$session_page]['keywords'];
$sort_options = array();
foreach ($class_pm->bestgood_periods as $p => $name) {
$sort_options[$class_pm->translateBestGoodPeriod($p)] = 'Top Selling ' . $name;
}
if (isset($_POST['sortby'])) {
$_SESSION[$session_page]['sortby'] = tep_db_prepare_input($_POST['sortby']);
}
if (!isset($_SESSION[$session_page]['sortby'])) {
$sort_options_keys = array_keys($sort_options);
$_SESSION[$session_page]['sortby'] = $sort_options_keys[1];
}
<?php
use_class('sendback');
use_class('jng_sp_orders');
use_class('orders');
use_class('products_ean');
use_class('products_minierp');
use_class('bins');
$class_sendback = new sendback();
$class_pean = new products_ean();
$class_pm = new products_minierp();
$class_bins = new bins();
$name1 = 'Sending Preparation';
$name2 = 'OTW to Bali';
$name3 = 'Receiving in Bali';
//$test = $class_sendback->getProductOnSentPackage('SB-101112-1', '4050878078294');echo "<pre>";var_dump($test);die();
//$s_lists = $class_sendback->retrievePackageContentList('SB-101202-2', "s.status='17'");$sendback_lists = $class_sendback->drawLists($s_lists);echo "<pre>";var_dump($s_lists);die();
$tc = array();
$segment_id = isset($_POST['segment_id']) && $_POST['segment_id'] != '' ? tep_db_prepare_input($_POST['segment_id']) : '1';
$sc16 = $class_sendback->statusCounter("bin_segments_id='{$segment_id}'");
$tc[] = intval($sc16['16']);
$sc = $class_sendback->statusCounter();
//$tc[] = intval($sc['16']);
$tc[] = intval($sc['17']);
$tc[] = intval($sc['18']);
//AJAX LOAD
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
$post_result = '';
if ($_POST['me_action'] == 'LOAD') {
if ($tc[0] == 0) {
$post_result .= '<h3 class="red">There is no product from this segment available for sending to Bali</h3>';
<?php
use_class('bins');
$class_bins = new bins();
use_class('products_minierp');
$class_pm = new products_minierp();
$session_page = 'bin-transfer';
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'LOADORIGINALLOCATION') {
$segment_id = tep_db_prepare_input($_POST['segment_id']);
$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']);
<?php
#########################################
# Author : D3W4 & SAHAT #
# Created : Oct 22, 2010 2:45:46 PM #
#########################################
use_class("logger");
use_class("bins");
use_class('products_minierp');
$class_bin = new bins();
$class_pm = new products_minierp();
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
$rack_id = tep_db_prepare_input($_POST['rack_id']);
$rack = $class_bin->retrieveRackDetail($rack_id);
$rack_no = $class_bin->formatRackNumber($rack['no']);
if ($_POST['me_action'] == 'UPDATESTATUS') {
$status = tep_db_prepare_input($_POST['status']);
if ($rack_id != '') {
$class_bin->updateRackStatus($rack_id, $status);
}
$img_status = $status == '1' ? '<img src="/images/icon-tick.png" title="Active" />' : '<img src="/images/icon-tick-dis.png" title="Inactive" />';
$result = array();
$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);
require_once('../../functions.php');
require_once('../../functions-2.php');
require_once(DIR_WS_FUNCTIONS.'html_output.php');
tep_db_connect();
$order_id = trim(tep_db_prepare_input($_GET['order_id']));
$sp_type = trim(tep_db_prepare_input($_GET['sp_type']));
*
*/
//Initial Required Classes and Service Objects
use_class('Order');
use_class('Product');
use_class('bins');
use_class('depot_orders');
use_class('production_target');
$class_bin = new bins();
$class_do = new depot_orders();
$pt = new production_target();
//CONFIGURATION
//only depot orders in this status will be considered for closing
//outsourcing orders can also be accepted from Outsourced (sahat - 12.09.2014)
if (!SERVER_IS_LOCAL) {
$REQUIRED_STATUS = '7';
} else {
$REQUIRED_STATUS = '2';
}
//DATA SUBMITTED BY MC
//barcode entry (ean / outsourcing order barcode)
$ean = tep_db_prepare_input($_POST['ean']);
//total qty (MC always send 1, but will be override later for outsourcing order)
$quantity = tep_db_prepare_input($_POST['quantity']);
<?php
use_class('Product');
use_class('bins');
use_class('depot_orders');
use_class('styles');
Product::loadDIOHsettings();
$class_bins = new bins();
$class_do = new depot_orders();
$class_s = new styles();
$segments_id = SEGMENT_ID_DEFAULT;
$whid_depot = WAREHOUSE_ID_FOR_HANDLING_ORDERS;
$min_status_orders = '8';
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'SEARCHFILTER') {
//var_dump($_POST);
set_time_limit(0);
$maxproducts = 100;
$filter_diohge = null;
$filter_diohle = null;
$filter_dioh2ge = null;
$filter_dioh2le = null;
$filter_refill = null;
$filter_missing = null;
$filter_stockhealth = null;
$filter_stockrefillhealth = null;
$filter_missing_al = null;
$filter_overstocking_al_ge = null;
$filter_overstocking_al_le = null;
$filter_stock_vs_stal = null;
$filter_stockrefill_vs_stal = null;
function packageCreate($segments_id, $package_code = '')
{
use_class('bins');
$class_bins = new bins();
$segment = $class_bins->retrieveSegmentDetail($segments_id);
if ($package_code == '') {
$package_code = 'DP.' . $segment['code'] . '-' . date('ymd');
}
$package_code_notfree = true;
while ($package_code_notfree) {
$c = tep_db_query("SELECT depot_packages_id FROM depot_packages WHERE depot_packages_id='{$package_code}'");
if (tep_db_num_rows($c) > 0) {
if (!isset($counter)) {
$counter = 2;
$package_code_raw = $package_code;
} else {
$counter++;
}
$package_code = $package_code_raw . '-' . $counter;
} else {
$package_code_notfree = false;
}
}
$sda = array();
$sda['package_code'] = $package_code;
$sda['segments_id'] = $segments_id;
tep_db_perform('depot_packages', $sda);
$new_id = tep_db_insert_id();
return $new_id;
}
<?php
#########################################
# Author : D3W4 & SAHAT #
# Created : Aug 20, 2010 10:48:46 AM #
#########################################
use_class('bins');
use_class('sendback');
use_class('products_ean');
use_class('products_minierp');
$class_bins = new bins();
$class_sendback = new sendback();
$class_pean = new products_ean();
$class_pm = new products_minierp();
define('NO_RACK_TEXT', 'No Rack(s) available !');
//START TEMPLATE
$segment_id = isset($_POST['segment_id']) && $_POST['segment_id'] != '' ? $_POST['segment_id'] : SEGMENT_ID_DEFAULT;
$segment = $class_bins->retrieveSegmentDetail($segment_id);
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'EXTENDRACK') {
$rack_id = tep_db_prepare_input($_POST['rack_id']);
$rack_no = tep_db_prepare_input($_POST['rack_no']);
$new_rows = tep_db_prepare_input($_POST['newrows']);
$rack = $class_bins->retrieveRackDetail($rack_id);
$bins_new = $class_bins->extendRack($rack_id, $new_rows);
$result = array();
$result['rack_id'] = $rack_id;
$result['rack_no'] = $rack_no;
$result['ext_status'] = is_array($bins_new) && count($bins_new) > 0 ? '1' : '0';
ajaxReturn($result);
exit;
<?php
#########################################
# Author : D3W4 & SAHAT #
# Created : Mar 31, 2011 3:24:47 PM #
#########################################
//Initial Required Classes and Service Objects
use_class('bins');
use_class('products_ean');
use_class('products_minierp');
use_class('depot_orders');
$class_bin = new bins();
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_do = new depot_orders();
$ean = tep_db_prepare_input($_POST['ean']);
$segments_id = tep_db_prepare_input($_POST['segments_id']);
$result = array();
$result['scanned_ean'] = $ean;
$result['status'] = 'NONE';
$result['result_ean'] = '';
$result['bin'] = '';
$is_outsourced = false;
$products_id = 0;
$articles_id = 0;
//Check if EAN scan is replace with an Outsourcing Order Barcode (DP-#####)
if (!is_numeric($ean)) {
//German scanner sometimes detect "-" as "ß" when not reconfigured
$separator = strpos($ean, 'ß') !== false ? 'ß' : '-';
$ean_to_orders_id = explode($separator, $ean);
$items_id = $ean_to_orders_id[1];
*/
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once '../functions-xml.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('xml_tools');
use_class('depot_orders');
use_class('logger');
use_class('Product');
use_class('bins');
$logger = new logger('cron', 'depot-refill-local-xml-generator');
$class_do = new depot_orders();
$class_bins = new bins();
$today_datetime = date('Y-m-d H:i:s');
$today = date('Y-m-d', strtotime($today_datetime));
$country_name = getCountryName($server_local_code);
$logger->write("PREPARE XML DEPOT REFILL - START");
//GET TODAYS DEPOT REFILL CREATED
$q = "SELECT * FROM depot_orders" . " WHERE segments_id = {$segment_id_default} " . " AND trans_type = 'AR' AND trans_id = " . depot_orders::AUTO_REFILL_ID_DAILYCRON . " AND order_date >= '{$today} 00:00:00' AND order_date <= '{$today} 23:59:59'";
$r = tep_db_query($q);
if (tep_db_num_rows($r) > 0) {
$segment = $class_bins->retrieveSegmentDetail($segment_id_default);
//PREPARE FOR CREATE XML DEPOT REFILL LOCAL
$xmlt = new xml_tools('1.0', 'UTF-8');
//DEPOT_REFILL_LOCAL
$depot_refill_local = $xmlt->drawTag($xmlt, 'DEPOT_REFILL_LOCAL');
//LOCAL_INFO
$local_info = $xmlt->drawTag($depot_refill_local, 'LOCAL_INFO');
if (!isset($_GET['segment_id']) || !isset($_GET['clearance_period'])) {
echo 'Not receiving data to generate the List';
exit;
}
use_class('orders');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('products_ean');
use_class('products_minierp');
use_class('bins');
$class_o = new orders();
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_bin = new bins();
$segment_id = $_GET['segment_id'];
$clearance_period = $_GET['clearance_period'];
$log_column = $class_pm->translateBestGoodPeriod($clearance_period);
$segment = $class_bin->retrieveSegmentDetail($segment_id);
if ($segment['used_for'] == 'P') {
$q = "SELECT b.*, ps.`products_id`, ps.`stock`, ps.`articles_id`, p.`products_image`, p.`products_model` FROM bins b INNER JOIN products_stock ps";
$q .= " ON b.`products_stock_id` = ps.`products_stock_id` AND ps.`jng_warehouses_id` = {$segment['warehouses_id']}";
$q .= " LEFT JOIN products_log pl ON pl.`products_id` = ps.`products_id`";
$q .= " LEFT JOIN products p ON p.`products_id` = ps.`products_id`";
$q .= " LEFT OUTER JOIN `jng_sp_orders_items` joi ON joi.`products_id` = pl.`products_id` AND joi.`status` IN (1, 8)";
$q .= " WHERE (pl.`{$log_column}` = 0 OR pl.`products_id` IS NULL)";
$q .= " AND joi.`jng_sp_orders_items_id` IS NULL";
$q .= " AND b.`bin_segments_id` = {$segment_id}";
$q .= " ORDER BY b.code";
} elseif ($segment['used_for'] == 'E') {
<?php
use_class('bins');
$class_bin = new bins();
$result = array();
$segments_list = $class_bin->retrieveSegmentList("status='1'", "name");
foreach ($segments_list as $key => $row) {
$result[] = $row['bin_segments_id'] . ',' . $row['name'];
}
function processReturn($bin_type, $sp_type, $order_product_id, $updater, $reason = '0', $return_date = '')
{
global $class_jo, $class_o;
use_class('payone');
use_class('products_minierp');
use_class('products_ean');
use_class("bins");
use_class("sendback");
$class_payone = new payone();
$class_pm = new products_minierp();
$class_pean = new products_ean();
$class_bins = new bins();
$class_sendback = new sendback();
$return_allowed_status = array('9', '11', '16', '20');
$is_best_product = '';
$product_barcode = '';
$returnable = 0;
$status = $bin_type == 'bin_bali' ? 'MCSHOWBINBALI' : 'MCSHOWBININ';
if ($bin_type == 'missing_product') {
$status = 'MCSHOWMISSINGPRODUCT';
}
$return_created = false;
if (strtolower($sp_type) == 's') {
//if($reason=='') {
// $order_product_id = $items_id;
// $status = 'MCSCANREASON';
// $reasons = $class_jo->returnReasonList();
// $reasons_list = array();
// foreach($reasons as $reason_id=>$val){
// $reasons_list[] = $reason_id."-".$val;
// }
// $result['reasons'] = $reasons_list;
//}else{
$item = $class_jo->retrieveItemDetail($order_product_id);
$order_id = $item['jng_sp_orders_id'];
$products_id = $item['products_id'];
$products_articles_id = $item['products_articles_id'];
$returnable = $item['order_quantity'];
$return_data = $class_jo->retrieveReturnItem($order_product_id);
//echo "<pre>";var_dump($return_data);
if (!is_null($return_data)) {
foreach ($return_data as $rd) {
$returnable -= $rd['return_quantity'];
}
}
if ($returnable > 0) {
$product_barcode = "SP-{$order_product_id}";
//CREATE RETURN
if ($return_date == '') {
$return_date = date('Y-m-d H:i:s');
}
$return_qty = 1;
$comment_customer = 'Returned via MC';
$comment_jng = '';
$shipping_paid = tep_db_prepare_input($_POST['shipping_paid']);
$return_id = $class_jo->returnItem($order_product_id, $return_date, $return_qty, $reason, $comment_customer, $comment_jng, $shipping_paid);
//CREATE PAYONE RETURN
//$return_id = '123';
if ($return_id != '') {
$return_created = true;
$class_payone->createReturnContainerSP($return_id, $return_qty, $order_product_id);
$new_status = putToBin($order_product_id, $sp_type, $bin_type, $updater);
//PREPARE SENDBACK DATA ONLY FOR status = '16'
if ($new_status == '16') {
$sendback = array();
//-------TODO: WE MUST CHANGE THIS HARDCODE segment_id VALUE TO DYNAMIC REQUESTED FROM MC-----
$segment_id = 1;
$sendback['bin_segments_id'] = $segment_id;
$bin_segment = $class_bins->retrieveSegmentDetail($segment_id);
//---------------------------------------------------------------------------------
$sendback['type'] = 'R';
$sendback['products_id'] = $products_id;
$sendback['products_articles_id'] = $products_articles_id;
$sendback['products_ean'] = $class_pean->getEAN($products_id, $products_articles_id);
$sendback['quantity_stock'] = $return_qty;
$sendback['quantity_actual'] = 0;
$class_sendback->create($sendback);
}
$items_q = tep_db_query("SELECT SUM(order_quantity) AS total FROM jng_sp_orders_items WHERE jng_sp_orders_id={$order_id} AND status NOT IN (10, 12)");
$items = tep_db_fetch_array($items_q);
$items_total = $items['total'];
$returns_total = getTotalReturnOrderSP($order_id);
$returnable = $items_total - $returns_total;
}
}
//} //BLOCK reason status
} elseif (strtolower($sp_type) == 'j') {
$item = $class_o->retrieveProductDetail($order_product_id);
$order_id = $item['orders_id'];
$products_id = $item['products_id'];
$products_articles_id = $item['products_articles_id'];
$existing_return = $class_o->productReturnTotalQty($order_product_id);
if ($existing_return < $item['products_quantity']) {
$product_barcode = "JG-{$order_product_id}";
//CREATE RETURN
$return_date = date('Y-m-d H:i:s');
$return_qty = 1;
$return_type = 'C';
$return_status = '0';
$return_comment = 'Returned via MC';
$product_received = 1;
$return_id = $class_o->addReturnProduct($order_product_id, $return_date, $return_qty, $return_type, $return_status, $return_comment, $product_received, $reason);
//CREATE PAYONE RETURN
//$return_id = '123';
if ($return_id != '') {
$return_created = true;
$class_payone->createReturnContainer($return_id, $return_qty, $order_product_id);
$new_status = putToBin($order_product_id, $sp_type, $bin_type, $updater);
//PREPARE SENDBACK DATA ONLY FOR status = '16'
if ($new_status == '16') {
$sendback = array();
//-------TODO: WE MUST CHANGE THIS HARDCODE segment_id VALUE TO DYNAMIC REQUESTED FROM MC-----
$segment_id = 1;
$sendback['bin_segments_id'] = $segment_id;
$bin_segment = $class_bins->retrieveSegmentDetail($segment_id);
//---------------------------------------------------------------------------------
$sendback['type'] = 'R';
$sendback['products_id'] = $products_id;
$sendback['products_articles_id'] = $products_articles_id;
$sendback['products_ean'] = $class_pean->getEAN($products_id, $products_articles_id);
$sendback['quantity_stock'] = $return_qty;
$sendback['quantity_actual'] = 0;
$class_sendback->create($sendback);
}
$items_q = tep_db_query("SELECT SUM(products_quantity) AS total FROM orders_products WHERE orders_id={$order_id} AND status NOT IN (10, 12)");
$items = tep_db_fetch_array($items_q);
$items_total = $items['total'];
$returns_total = getTotalReturnOrderJG($order_id);
$returnable = $items_total - $returns_total;
}
}
}
$result['product_barcode'] = $product_barcode;
$result['order_product_id'] = $order_product_id;
$result['returnable'] = $returnable;
$result['status'] = $return_created ? $status : 'CREATERETURNFAIL';
return $result;
}
<?php
/**
* This module will replace 2 previous modules:
* - products-stock-update.php
* - bin-info.php
*
* @author IT TEAM BONOFACTUM
* @created Apr 12, 2013 6:20:18 PM
*/
use_class('products_minierp');
use_class('products_articles');
use_class('products_ean');
use_class("bins");
use_class("stock_booking");
$class_bin = new bins();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_ean = new products_ean();
//GET PAGE & WAREHOUSE OPTIONS
warehouseFGCombo();
$psid = null;
$bin_id = null;
$pid = null;
$aid = null;
$history_options = array();
$history_options[0] = '2 Weeks';
$history_options[1] = '4 Weeks';
$history_options[2] = '1 Month';
$history_options[3] = '2 Months';
$history_options[4] = '3 Months';
<?php
#########################################
# Author : D3W4 & SAHAT #
# Created : Aug 20, 2010 1:51:33 PM #
#########################################
use_class('CategoryTop');
use_class("bins");
$class_bin = new bins();
if (isset($_GET['id']) && $_GET['id'] != '') {
$segment_id = tep_db_prepare_input($_GET['id']);
} else {
header('Location: ?open=bin-segments');
exit;
}
//SUBMIT ACTIONS
$attr_buttons = '';
$rdo_p_checked = '';
$rdo_e_checked = '';
$readonly = '';
$disabled = '';
$locations_arr = $class_bin->getSegmentLocationArray();
$segment_update = false;
if (isset($_POST) && count($_POST) > 0) {
if ($_POST['me_action'] == 'NUMTOCHAR') {
$res = '';
$num = $_POST['num'];
$writeto = $_POST['write_to'];
$type = $_POST['type'];
if ($type == 'rows') {
$res = $num > 1 ? "* from A to " . $class_bin->numtochar[$num] : ($num == 1 ? "* A" : "");
