function retrieveData($barcode_type, $barcode_id)
{
use_class('jng_sp');
use_class('orders');
use_class('jng_sp_orders');
use_class('depot_orders');
use_class('products_ean');
use_class('products_minierp');
$class_sp = new jng_sp();
$class_orders = new orders();
$class_jo = new jng_sp_orders();
$class_do = new depot_orders();
$class_pean = new products_ean();
$class_pm = new products_minierp();
$result = '';
//list($partner_type,$order_product_id) = split("-",$barcode_id);
//$partner_type = strtolower($partner_type);
$tmp_bcid = explode('-', $barcode_id);
$partner_type = strtolower($tmp_bcid[0]);
$order_product_id = $tmp_bcid[1];
if (is_numeric($partner_type)) {
$order_product_id = $partner_type;
$partner_type = 'sp';
}
//all id without prefix JG or SP indicates as SP
if (!empty($order_product_id) && $order_product_id != '') {
$partners_need_ean13 = array('3');
#switch partner prefix
switch ($partner_type) {
case 'jg':
$products = $class_orders->retrieveProductDetail($order_product_id);
#header("Content-Type: text/plain; charset=utf-8");
switch ($barcode_type) {
case 'code39':
if (count($products) > 0) {
#table orders,products,dll.
$order_id = $products["orders_id"];
$article_number = $products["products_model"];
$order_item_count = $products["order_item_count"];
$order_item_total = $products["order_item_total"];
$order_qty = $products["products_quantity"];
#table orders
$orders = $class_orders->retrieveDetail($order_id);
$order_no = $orders["orders_no"];
$order_date = strtotime($orders["date_purchased"]);
$day = date("d", $order_date);
$month = date("M", $order_date);
$daily_count = $orders["daily_count"];
#format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel
$label_date = $day . ". " . $month;
$label_order_seq = $order_item_count . "/" . $order_item_total;
$label_cust_name = $orders["delivery_name"];
$qcountry = "SELECT countries_iso_code_2 FROM countries WHERE countries_name = '{$orders['delivery_country']}'";
$dbqcountry = tep_db_query($qcountry);
$rescountry = tep_db_fetch_array($dbqcountry);
$label_suffix = $rescountry['countries_iso_code_2'] != '' ? ".{$rescountry['countries_iso_code_2']}" : "";
$label_numtag = "JG" . $label_suffix;
$label_auftragsnr = $order_no == '' ? "-" : $order_no;
$label_lieferscheinnr = '';
$return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name;
$return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number . ";" . $order_product_id . ";" . $partner_type;
$result = $return_label;
} else {
$result = "no data";
}
break;
case 'ean13':
if (count($products) > 0) {
$result = $this->getEANReturnResult($partner_type, $products);
} else {
$result = "no data";
}
break;
}
break;
case 'sp':
$oi = $class_jo->retrieveItemDetail($order_product_id);
$order_id = $oi["jng_sp_orders_id"];
$o = $class_jo->retrieveDetail($order_id);
$sp_id = $o["jng_sp_id"];
#header("Content-Type: text/plain; charset=utf-8");
switch ($barcode_type) {
case 'code39':
if (count($oi) > 0) {
#table jng_sp_orders_items
// $order_qty = $oi["order_quantity"] * 1;
$article_number = $oi["article_number"];
$order_item_count = $oi["order_item_count"];
$order_item_total = $oi["order_item_total"];
$order_qty = intval($oi["order_quantity"]);
#table jng_sp_orders
$order_no = $o["order_id"];
$class_ordersrder_date = strtotime($o["order_date"]);
$day = date("d", $class_ordersrder_date);
$month = date("M", $class_ordersrder_date);
$daily_count = $o["daily_count"];
$shipment_id = $o["shipment_id"];
$cust_fname = $o["customer_shipping_firstname"];
$cust_lname = $o["customer_shipping_lastname"];
#table jng_sp
$jngsp = $class_sp->retrieveDetail($sp_id);
$prefix_num = $jngsp["package_prefix"];
#format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel
$label_date = $day . ". " . $month;
$label_order_seq = $order_item_count . "/" . $order_item_total;
$label_cust_name = $cust_fname . " " . $cust_lname;
$label_numtag = $prefix_num == '' ? "-" : $prefix_num;
$label_auftragsnr = $order_no == '' ? "-" : $order_no;
$label_lieferscheinnr = $shipment_id;
$return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name;
$return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number . ";" . $order_product_id . ";" . $partner_type;
if (in_array($sp_id, $partners_need_ean13)) {
if (count($oi) > 0) {
$cats = $class_jo->getCategories($order_id);
$oi_product_id = $oi["products_id"];
$oi_product_article_id = $oi["products_articles_id"];
$ean = $oi_product_article_id != '' ? $class_pean->getEAN($oi_product_id, $oi_product_article_id) : $class_pean->getEAN($oi_product_id);
if ($ean != '') {
$label_material = "925er SILBER";
$return_label .= ";" . $ean . ";" . strtoupper($cats['categories_name']) . ";" . $label_material . ";" . $oi['price'] . " EUR;{$order_qty};{$o['jng_sp_id']}";
}
}
}
$result = $return_label;
} else {
$result = "no data";
}
break;
case 'ean13':
if (count($oi) > 0) {
$result = $this->getEANReturnResult($partner_type, $oi, $sp_id);
} else {
$result = "no data";
}
break;
}
break;
case 'dp':
//ONLY PRODUCT LABEL / ean13
$do = $class_do->retrieveDetail($order_product_id);
switch ($barcode_type) {
case 'code39':
$article_number = $do["products_ean"];
$order_item_count = '1';
$order_item_total = '1';
$order_qty = intval($do["quantity"]);
$daily_count = $order_qty . 'x';
#format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel
$label_date = "Quantity: ";
$label_order_seq = "{$order_item_count}/{$order_item_total}";
$label_cust_name = 'Outsourcing';
$label_numtag = '-';
$label_auftragsnr = '-';
$label_lieferscheinnr = '-';
$return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name;
$return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number . ";" . $order_product_id . ";" . $partner_type;
$result = $return_label;
break;
case 'ean13':
default:
if (count($do) > 0) {
$do['products_articles_id'] = $do['articles_id'];
$result = $this->getEANReturnResult($partner_type, $do);
} else {
$result = "no data";
}
}
break;
}
} else {
$result = "no data";
}
return $result;
}
$eanlist[]='4050878242626';
$eanlist[]='4050878240257';
$eanlist[]='4050878314194';
$eanlist[]='4050878342357';
$eanlist[]='4050878126858';
$eanlist[]='4050878373382';
$eanlist[]='4050878456580';
$eanlist[]='4050878469740';
$eanlist[]='4050878047429';
$eanlist[]='4050878145514';
*/
$sp_specsets = load_config('sp-specific-settings');
use_class('products_ean');
use_class('products_minierp');
use_class('jng_sp_orders');
$class_pe = new products_ean();
$class_pm = new products_minierp();
$class_jo = new jng_sp_orders();
$ean_pid = array();
$orders = array();
$products = array();
foreach ($eanlist as $ean) {
$p_info = $class_pe->getProductArticle($ean);
$pid = $p_info['products_id'];
$ean_pid[$ean] = $pid;
if (!isset($products[$pid])) {
$pdata = $class_pm->retrieveDetail($pid, 'sp');
$products[$pid] = $pdata['sp']['5'];
}
}
$ean_detail_info = $class_jo->getAMVD_AutoCancelSupportingData($ean_pid);
/**
* Handle POST/GET Action that related to products_articles
*/
function processAction()
{
if (isset($_POST['me_action']) && $_POST['me_action'] == 'PRODUCTSARTICLES') {
switch ($_POST['act']) {
case 'ADDEANTOPRODUCT':
$products_id = tep_db_prepare_input($_POST['products_id']);
use_class('products_ean');
$class_ean = new products_ean();
$result = $class_ean->attachToProduct($products_id);
break;
case 'ADDEANTOARTICLE':
$article_id = tep_db_prepare_input($_POST['article_id']);
use_class('products_ean');
$class_ean = new products_ean();
$ean_no = $class_ean->attactToArticle($article_id);
$result = "{$article_id},{$ean_no}";
break;
case 'ADD':
$products_id = tep_db_prepare_input($_POST['products_id']);
$price = tep_db_prepare_input($_POST['new_price']);
$price_old = tep_db_prepare_input($_POST['new_price_old']);
$length = tep_db_prepare_input($_POST['new_length']);
$options = array();
$options['length'] = $length;
$prepared = true;
$products_articles_id = $this->add($products_id, $price, $price_old, $options, $prepared);
if ($products_articles_id == 0) {
$result .= '0';
} else {
//$result = '<tr><td>Other Length <sup class="red">new</sup></td><td>'.$length.'cm = '.$price.' EUR</td>';
$result .= '<tr>';
$result .= '<td class="green">New</td>';
$result .= '<td class="notice">Unset</td>';
$result .= '<td>' . $length . '</td>';
//$result .= '<td>'.$price.'</td>';
//$result .= '<td>'.$price_old.'</td>';
$result .= '<td colspan="2"><a href="">Refresh Page</a> for action links</td>';
$result .= '</tr>';
}
break;
case 'UPDATE':
$options = array();
$options['length'] = $_POST['new_length'];
$result = $this->update($_POST['products_articles_id'], $_POST['new_price'], $_POST['new_price_old'], $options);
break;
case 'REMOVE':
$result = $this->remove($_POST['products_articles_id']);
break;
case 'ARTICLEACTIVATION':
$paid = tep_db_prepare_input($_POST['paid']);
$status = tep_db_prepare_input($_POST['status']);
$this->setActiveStatus($paid, $status);
$result = array();
$result['paid'] = $paid;
$result['status'] = $status;
$result['success'] = '1';
ajaxReturn($result);
exit;
break;
}
echo utf8_encode($result);
exit;
}
}
//AJAX ACTION
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>';
} else {
$daily_counter[$dateonly] += 1;
}
$order['daily_count'] = $daily_counter[$dateonly];
$order_id = $class_jo->importOrder($order);
if (!is_null($order_id) && $order_id != '') {
$orders_created_collection[] = $order_id;
$orders_created++;
$leadtime_start_date = $import_date;
foreach ($xml_parser[$xfc]->orders_items[$oc] as $ic => $item) {
if (count($item) > 0) {
$item['jng_sp_orders_id'] = $order_id;
$item['order_item_total'] = count($xml_parser[$xfc]->orders_items[$oc]);
if (!isset($class_ean)) {
use_class('products_ean');
$class_ean = new products_ean();
}
$pdata = $class_ean->getProductArticle($item['products_ean']);
$item['products_id'] = $pdata['products_id'];
$item['products_articles_id'] = $pdata['products_articles_id'];
if (!isset($item['price']) && isset($item['price_received'])) {
//AT VAT = 20%
$at_vat = 0.2;
$real_commission = round($sp_detail['provision_rate'] * (1 + $at_vat), 2);
$net_price = $item['price_received'] / (1 - $real_commission);
$item['price'] = (1 + $at_vat) * $net_price;
}
$item['delivery_time'] = $sp_detail['delivery_time'];
$item['delivery_replacement_time'] = 'null';
$item['confirm_order_time'] = date('Y-m-d H:i:s');
$item_id = $class_jo->addItem($order_id, $item);
<?php
set_time_limit(0);
ini_set('memory_limit', '512M');
use_class('jng_sp');
use_class('jng_sp_upload');
use_class('jng_sp_orders');
use_class('products_ean');
$class_sp = new jng_sp();
$class_ju = new jng_sp_upload();
$class_jo = new jng_sp_orders();
$class_ean = new products_ean();
$runinlocal = DB_SERVER == 'localhost';
function stockStatusStrength($stock_status)
{
switch ($stock_status) {
case 'D':
$sss = 1;
break;
case 'P':
case 'R':
$sss = 2;
break;
default:
$sss = 3;
}
return $sss;
}
$content = '';
$jng_sp_active = $class_sp->retrieveList("active_status=1");
foreach ($jng_sp_active as $temp_sp) {
* @author IT TEAM BONOFACTUM
* @created Nov 20, 2013 10:33:28 AM
*/
use_class('logger');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('jng_sp_download');
use_class('jng_sp_catalog');
use_class('products_minierp');
use_class('products_ean');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_jd = new jng_sp_download();
$class_jc = new jng_sp_catalog();
$class_pm = new products_minierp();
$class_ean = new products_ean();
$whid = WAREHOUSE_ID_PRODUCTS_HAMBURG;
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'UPDATEOVERVIEW') {
$jng_sp_id = tep_db_prepare_input($_POST['jng_sp_id']);
$order_date = generateMysqlDateFromGerman($_POST['order_date']);
$q = "SELECT SUM(joi.order_quantity) AS total_orders";
$q .= ", SUM(IF(joi.status NOT IN (10,12), joi.order_quantity, 0)) AS total_confirmed";
$q .= ", SUM(IF(joi.status IN (10,12), joi.order_quantity, 0)) AS total_cancels";
$q .= " FROM jng_sp_orders jo";
$q .= " INNER JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_id=jo.jng_sp_orders_id";
$q .= " WHERE jo.jng_sp_id={$jng_sp_id} AND jo.order_date LIKE '{$order_date}%' AND jo.confirm_status='0'";
$r = tep_db_query($q);
$row = tep_db_fetch_array($r);
$ajaxResult = array();
$ajaxResult['total_orders'] = intval($row['total_orders']);
define('FPDF_FONTPATH', FPDF_IMGPATH . 'fonts/');
require_once DIR_WS_CLASSES . 'fpdf.php';
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}";
$products_ean[] = $i['products_ean'];
}
}
}
} else {
$result['status'] = 'ERROR';
$result['message'] = $statusName[$item['status']];
}
}
} else {
$result['status'] = 'ERROR';
$result['message'] = 'Order not found, please rescan!';
}
} elseif ($type == 'JG') {
$class_o = new orders();
$class_ean = new products_ean();
$item = $class_o->retrieveProductDetail($item_id);
if (isset($item['orders_id']) && $item['orders_id'] > 0) {
$order = $class_o->retrieveDetail($item['orders_id']);
//check if logistic process is alread flagged
if (!is_null($order['logistic_process'])) {
$lp_time = date('d.m.Y H:i:s', strtotime($order['logistic_process']));
$result['status'] = 'ERROR';
$result['message'] = 'already processed on ' . $lp_time;
$result['message'] .= "\n\n" . 'Please check order detail in Manobo for detail information about preventing double sendings!';
} else {
if ($item['status'] == $inhh_status || statusIsCancelled($item['status'])) {
$products_found = true;
$items = $class_o->retrieveProducts($item['orders_id']);
foreach ($items as $i) {
if ($i['status'] == $inhh_status) {
function transferFromRealOrder($segments_id, $type, $item_id)
{
$item = $this->retrieveDetailTransmigran($type, $item_id);
if (is_null($item)) {
$order_date = date('Y-m-d H:i:s');
if ($type == 'JG') {
use_class('orders');
$class_o = new orders();
use_class('products_ean');
$class_ean = new products_ean();
$i = $class_o->retrieveProductDetail($item_id);
$products_ean = $class_ean->getEAN($i['products_id'], $i['products_articles_id']);
$this->newOrder($segments_id, $i['products_id'], $i['products_articles_id'], $products_ean, $i['products_quantity'], $order_date, $type, $item_id);
} elseif ($type == 'SP') {
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
$i = $class_jo->retrieveItemDetail($item_id);
$this->newOrder($segments_id, $i['products_id'], $i['products_articles_id'], $i['products_ean'], $i['order_quantity'], $order_date, $type, $item_id);
}
$stock_status = $i['stock_status'] == 'D' ? $i['status'] < 4 ? '0' : 'P' : $i['stock_status'];
$item = $this->retrieveDetailTransmigran($type, $item_id);
$this->updateStockStatus($item['depot_orders_id'], $stock_status);
}
return $item;
}
function receivedProductsDifferent($package_id, $new_ean, $received_status = '', $create_received_data = true)
{
global $session_userinfo;
$result = '';
$package = $this->retrievePackageList("sendback_package_id='{$package_id}'");
$package_contents = $this->retrievePackageContentList($package_id, "s.products_ean='{$new_ean}' AND s.type='X' AND s.status='18'");
$sendback = array();
if (count($package_contents) > 0) {
$sendback_id = $package_contents[0]['sendback_id'];
$qty_received = $create_received_data ? $package_contents[0]['quantity_received'] + 1 : $package_contents[0]['quantity_received'];
$qty_stock = !$create_received_data ? $package_contents[0]['quantity_stock'] + 1 : $package_contents[0]['quantity_stock'];
$sendback['quantity_received'] = $qty_received;
$sendback['quantity_stock'] = $qty_stock;
tep_db_perform('sendback', $sendback, 'update', "sendback_id='{$sendback_id}'");
} else {
use_class('products_ean');
$class_pean = new products_ean();
$articles = $class_pean->getProductArticle($new_ean);
$qty_received = $create_received_data ? 1 : 0;
$sendback['type'] = 'X';
$sendback['bin_segments_id'] = $package[0]['segments_id'];
$sendback['products_id'] = $articles['products_id'];
$sendback['products_articles_id'] = $articles['products_articles_id'];
$sendback['products_ean'] = $new_ean;
if (!$create_received_data) {
$sendback['quantity_stock'] = 1;
}
$sendback['quantity_received'] = $qty_received;
$sendback['status'] = '18';
tep_db_perform('sendback', $sendback);
$sendback_id = tep_db_insert_id();
$this->addItem($package_id, $sendback_id);
}
if ($create_received_data) {
//CREATE SENDBACK RECEIVED DATA
$rcv = array();
$rcv['sendback_id'] = $sendback_id;
$rcv['received_date'] = date("Y-m-d H:i:s");
$rcv['received_by'] = $session_userinfo['username'];
if ($received_status != '') {
$rcv['status'] = $received_status;
}
tep_db_perform('sendback_received', $rcv);
$sendback_received_id = tep_db_insert_id();
$result = "{$sendback_received_id};{$sendback_id};{$qty_received}";
} else {
$result = "{$sendback_id};{$qty_received}";
}
return $result;
}
/**
* Description of tempamazonavailability
*
* @author IT TEAM BONOFACTUM
* @created Jul 10, 2013 11:18:53 PM
*/
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('jng_sp_orders');
use_class('products_ean');
$class_jo = new jng_sp_orders();
$class_ean = new products_ean();
$sp_specsets = load_config('sp-specific-settings');
$eans = array();
$eans[] = '4050878374242';
$eans[] = '4050878412517';
$eans[] = '4050878383336';
$eans[] = '4050878374235';
$eans[] = '4050878403409';
$eans[] = '4050878403393';
$eans[] = '4050878403218';
$eans[] = '4050878403225';
$eans[] = '4050878380274';
$eans[] = '4050878383268';
$eans[] = '4050878373719';
$eans[] = '4050878373498';
$eans[] = '4050878373702';
function saveLength($products_id, $def_length, $add_length)
{
use_class('products_articles');
use_class('products_ean');
$class_pa = new products_articles();
$class_ean = new products_ean();
$sda = array('products_length' => $def_length);
$product = $this->retrieveDetail($products_id, 'cat,pnc');
if (!is_array($product['pnc'])) {
$sda['products_id'] = $products_id;
tep_db_perform('products_non_configurator', $sda);
} else {
tep_db_perform('products_non_configurator', $sda, 'update', "products_id={$products_id}");
}
$sda = array('length' => $def_length);
tep_db_perform('jng_sp_catalog', $sda, 'update', "products_id={$products_id}");
$p_ean = $class_ean->getEAN($products_id);
if ($p_ean == '') {
$class_ean->attachToProduct($products_id);
}
if (is_array($add_length) && count($add_length) > 0) {
foreach ($add_length as $l) {
$paid = $class_pa->add($products_id, 0, 0, array('length' => $l), true);
$class_ean->attactToArticle($paid);
}
}
}
}
if (isset($do['products_id'])) {
$products_id = $do['products_id'];
}
} elseif (strlen($entry) == 13) {
$isean = false;
foreach ($EAN_PREFIX as $ep) {
$prefix_length = strlen($ep);
if (substr($entry, 0, $prefix_length) == $ep) {
$isean = true;
break 1;
}
}
if ($isean) {
use_class('products_ean');
$class_ean = new products_ean();
$ean_info = $class_ean->getProductArticle($entry);
if (isset($ean_info['products_id'])) {
$products_id = $ean_info['products_id'];
}
}
}
if (is_null($products_id)) {
$is_code = false;
if (!is_numeric($entry)) {
$is_code = true;
} elseif ((strlen($entry) == 8 || strlen($entry) == 10) && substr($entry, 0, 1) == '0') {
$is_code = true;
}
if ($is_code) {
$q = tep_db_query("SELECT products_id FROM products WHERE products_model='{$entry}'");
setTradebyteNeedReupload($products_id);
}
}
//START TEMPLATE
$products_entry = '';
if (isset($_GET['products_id'])) {
$products_id = tep_db_prepare_input($_GET['products_id']);
$product_data = $class_pm->retrieveDetail($products_id, 'p,pc,pnc,cat,pci,pl');
} elseif (isset($_POST['products_id'])) {
//REDIRECT LINK IF AN ORDER IS FOUND BY POST
if (isset($_POST['products_id'])) {
$products_entry = tep_db_prepare_input($_POST['products_id']);
}
if (strlen($products_entry) == 13) {
use_class('products_ean');
$class_ean = new products_ean();
$ean_pinfo = $class_ean->getProductArticle($products_entry);
$products_id = $ean_pinfo['products_id'];
} else {
$products_query = tep_db_query("SELECT products_id FROM products WHERE products_model='{$products_entry}'");
if (tep_db_num_rows($products_query) > 0) {
$products = tep_db_fetch_array($products_query);
$products_id = $products['products_id'];
} else {
$products_id = $products_entry;
}
}
if ($products_id != '') {
header("Location: ?open=product-detail&products_id={$products_id}");
exit;
} else {
function getBinByEAN($segment_id, $ean_code)
{
use_class('products_ean');
$class_ean = new products_ean();
$pinfo = $class_ean->getProductArticle($ean_code);
$bin = $this->getBinByProduct($segment_id, $pinfo['products_id'], $pinfo['products_articles_id']);
return $bin;
}
<?php
use_class('Product');
use_class('depot_orders');
use_class('products_ean');
use_class('elements_suppliers');
$class_do = new depot_orders();
$class_ean = new products_ean();
$forecasting_conf = load_config('forecasting');
//PAGE OPTIONS
//if (isset($_POST['segments_id']))
$special_mode = '';
if (isset($_GET['mode'])) {
$special_mode = tep_db_prepare_input($_GET['mode']);
}
//SUBMIT ACTION
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
if ($_POST['me_action'] == 'LOADOUTSOURCELATESTPRICES') {
$products_id = tep_db_prepare_input($_POST['products_id']);
$articles_id = tep_db_prepare_input($_POST['articles_id']);
$price = $class_do->getOutsourceLatestPrice($products_id, $articles_id);
ajaxReturn($price);
exit;
} elseif ($_POST['me_action'] == "CREATEOUTSOURCINGORDER") {
$segments_id = tep_db_prepare_input($_POST['segments_id']);
$products_id = tep_db_prepare_input($_POST['params']['pid']);
$articles_id = tep_db_prepare_input($_POST['params']['aid']);
$products_ean = tep_db_prepare_input($_POST['params']['ean']);
$qty_full = tep_db_prepare_input($_POST['params']['qty_full']);
$qty_batch = tep_db_prepare_input($_POST['params']['qty_batch']);
$suppliers_id = tep_db_prepare_input($_POST['params']['suppliers_id']);
function processReturnOld($sp_type, $order_id, $ean_code, $reason = '0')
{
global $class_jo;
global $class_o;
use_class('payone');
use_class('products_minierp');
$class_payone = new payone();
$class_pm = new products_minierp();
$return_allowed_status = array('9', '11', '16', '20');
$is_best_product = '';
$order_product_id = '';
$product_barcode = '';
$status = 'RETURNNOTALLOWED';
if (strtolower($sp_type) == 's') {
$items = $class_jo->retrieveItems($order_id);
foreach ($items as $key => $item) {
$items_id = $item['jng_sp_orders_items_id'];
$product_code = $item['products_model'];
$product_name = $item['products_name'];
// echo $item['products_ean']." | ".$item['status']."<br/>";
if ($item['products_ean'] == $ean_code && in_array($item['status'], $return_allowed_status)) {
$products_id = $item['products_id'];
// 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{
$returnable = $item['order_quantity'];
$return_data = $class_jo->retrieveReturnItem($items_id);
// echo "<pre>";var_dump($return_data);
if (!is_null($return_data)) {
foreach ($return_data as $rd) {
$returnable -= $rd['return_quantity'];
}
}
if ($returnable > 0) {
$order_product_id = $items_id;
$product_barcode = "SP-{$order_product_id}";
$is_best_product = $class_pm->isBestProduct($item['products_id']);
$status = $is_best_product ? 'MCBINORRETURN' : 'MCRETURNTOBALI';
//CREATE RETURN
$return_date = date('Y-m-d H:i:s');
$return_qty = 1;
$comment_customer = '';
$comment_jng = '';
$shipping_paid = tep_db_prepare_input($_POST['shipping_paid']);
$return_id = $class_jo->returnItem($items_id, $return_date, $return_qty, $reason, $comment_customer, $comment_jng, $shipping_paid);
//CREATE PAYONE RETURN
// $return_id = '123';
if ($return_id != '') {
$class_payone->createReturnContainerSP($return_id, $return_qty, $items_id);
$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') {
use_class('products_ean');
$class_pean = new products_ean();
$items = $class_o->retrieveProducts($order_id);
foreach ($items as $key => $item) {
$ean = $class_pean->getEAN($item['products_id'], $item['products_articles_id']);
$opid = $item['orders_products_id'];
$product_code = $item['products_model'];
$product_name = $item['products_name'];
// echo $ean." | ".$item['status']."<br/>";
if ($ean == $ean_code && in_array($item['status'], $return_allowed_status)) {
$products_id = $item['products_id'];
$existing_return = $class_o->productReturnTotalQty($opid);
if ($existing_return < $item['products_quantity']) {
$order_product_id = $opid;
$product_barcode = "JG-{$order_product_id}";
$is_best_product = $class_pm->isBestProduct($item['products_id']);
$status = $is_best_product ? 'MCBINORRETURN' : 'MCRETURNTOBALI';
//CREATE RETURN
$opid = $item['orders_products_id'];
$return_date = date('Y-m-d H:i:s');
$return_qty = 1;
$return_type = 'C';
$return_status = '0';
$return_comment = '';
$product_received = 1;
$return_id = $class_o->addReturnProduct($opid, $return_date, $return_qty, $return_type, $return_status, $return_comment, $product_received);
//CREATE PAYONE RETURN
// $return_id = '123';
if ($return_id != '') {
$class_payone->createReturnContainer($return_id, $return_qty, $opid);
$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['eancode'] = $ean_code;
if ($products_id != '') {
$result['product_id'] = $products_id;
$qp = "SELECT p.*, pd.products_name FROM products p INNER JOIN products_description pd ON p.products_id = pd.products_id\n WHERE p.products_id = {$products_id} AND pd.language_id = 2";
$dbqp = tep_db_query($qp);
$rp = tep_db_fetch_array($dbqp);
$result['product_code'] = $rp['products_model'];
$result['product_name'] = $rp['products_name'];
$result['product_image'] = webImageSource($rp['products_image'], '80');
//'http://www.julie-grace.de/images/imagecache/500x500_03601033.jpg';
}
$result['returnable'] = $returnable;
$result['status'] = $status;
return $result;
}
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
tep_db_connect();
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
use_class('products_articles');
$class_pa = new products_articles();
use_class('products_ean');
$class_ean = new products_ean();
$jng_sp_id = '1';
$products = $class_jc->retrieveCatalogForUpload($jng_sp_id);
$counter_p = 0;
$counter_a = 0;
foreach ($products as $p) {
if ($p['products_ean'] == '') {
$class_ean->attachToProduct($p['products_id']);
$counter_p++;
}
$articles = $class_pa->retrieveList($p['products_id']);
foreach ($articles as $a) {
if ($a['length'] != $p['length']) {
if ($a['products_ean'] == '') {
$class_ean->attactToArticle($a['products_articles_id']);
$counter_a++;
}
}
}
echo '.';
echo utf8_encode("UPDATED");
exit;
} elseif ($_POST['me_action'] == 'SAVEBRAND') {
$products_id = tep_db_prepare_input($_POST['products_id']);
$brand_id = tep_db_prepare_input($_POST['brand_id']);
$class_pb->updateProductBrand($products_id, $brand_id);
echo utf8_encode("UPDATED");
exit;
} elseif ($_POST['me_action'] == 'LOADLENGTHS') {
$products_id = tep_db_prepare_input($_POST['products_id']);
$result = drawLengthsForm($products_id);
echo utf8_encode($result);
exit;
} elseif ($_POST['me_action'] == 'SAVELENGTHS') {
use_class('products_ean');
$class_ean = new products_ean();
$products_id = tep_db_prepare_input($_POST['products_id']);
$def_length = tep_db_prepare_input($_POST['def_length']);
$add_length = tep_db_prepare_input($_POST['add_length']);
$upd_length = tep_db_prepare_input($_POST['upd_length']);
$class_pm->saveLength($products_id, $def_length, $add_length);
if (is_array($upd_length) && count($upd_length) > 0) {
foreach ($upd_length as $paid => $l) {
if ($l > 0 && $l != 'NaN') {
$class_pa->update($paid, 0, 0, array('length' => $l), true);
} else {
$a_ean = $class_ean->getEAN($products_id, $paid);
if ($a_ean != '') {
$class_ean->setAsFree($a_ean);
}
$class_pa->remove($paid, true);
$jngsp_prefix_num = $jngsp["package_prefix"];
#format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel
$label_date = $day . ". " . $month;
$label_order_seq = $oi_order_item_count . "/" . $oi_order_item_total;
$label_cust_name = $o_cust_fname . " " . $o_cust_lname;
$label_numtag = $jngsp_prefix_num == '' ? "-" : $jngsp_prefix_num;
$label_auftragsnr = $o_order_no == '' ? "-" : $o_order_no;
$label_lieferscheinnr = $o_shipment_id;
$return_label = $label_date . ";" . $o_daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name;
$return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . oi_order_qty . ";" . $oi_article_number;
echo $return_label;
break;
case 'ean13':
if (count($oi) > 0) {
use_class('products_ean');
$o_pean = new products_ean();
$products_id = $oi['products_id'];
$cats = $o_jngspo->getCategories($products_id);
$oi_product_id = $oi["products_id"];
$oi_product_article_id = $oi["products_articles_id"];
$ean = $oi_product_article_id != '' ? $o_pean->getEAN($oi_product_id, $oi_product_article_id) : $o_pean->getEAN($oi_product_id);
if ($ean != '') {
$return_label = $ean . ";" . $oi['price'] . ";" . $cats['categories_name'];
echo $ean;
} else {
echo "no data";
}
} else {
echo "no data";
}
break;
<?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
#########################################
# Author : D3W4 & SAHAT #
# Created : Nov 23, 2010 11:07:08 AM #
#########################################
use_class('sendback');
use_class('products_minierp');
use_class('products_ean');
$class_sendback = new sendback();
$class_pm = new products_minierp();
$class_pean = new products_ean();
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
$post_result = '';
if ($_POST['me_action'] == 'SHOWBIN') {
$type = $_POST['type'];
if ($type == 'bin_in') {
list($products_id, $products_articles_id) = split("-", $_POST['ids']);
$query = "SELECT * FROM sendback ";
$query .= " WHERE products_id = '{$products_id}' AND products_articles_id = '{$products_articles_id}'";
$query .= " AND status = '16' AND type='D' AND quantity_actual > 0 LIMIT 1";
$dbq = tep_db_query($query);
if (tep_db_num_rows($dbq) > 0) {
$r = tep_db_fetch_array($dbq);
if ($r['quantity_actual'] > 1) {
tep_db_query("UPDATE sendback SET quantity_actual = " . ($r['quantity_actual'] - 1) . " WHERE sendback_id = '{$r['sendback_id']}'");
} else {
tep_db_query("DELETE FROM sendback_package_contents WHERE sendback_id = '{$r['sendback_id']}'");
tep_db_query("DELETE FROM sendback WHERE sendback_id = '{$r['sendback_id']}'");
}
} else {
<?php
$product_input = tep_db_prepare_input($_POST['product_input']);
$counter_on = !isset($_POST['counter_on']) ? true : tep_db_prepare_input($_POST['counter_on']) == 'true';
use_class('products_minierp');
use_class('products_articles');
use_class('products_ean');
use_class('logger');
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$logger = new logger('mc_functions', 'mod05_get_product_detail');
$logger->write("POST product_input = {$product_input}");
function cleanOiidFromPrefix($oiid)
{
/* Sometimes when user scan so fast, id scanned would be like this SP-12345SP-12345
* So this makes oiid taken is 12345SP, this function to clean it from unwanted prefix */
$oiid = strtoupper($oiid);
$oiid = str_replace('SP', '', $oiid);
$oiid = str_replace('JG', '', $oiid);
$oiid = str_replace('DP', '', $oiid);
return $oiid;
}
$barcode_id = '';
$spid = '';
$pid = 0;
$aid = '-';
$ean = '';
$qty = 1;
$cancel = false;
$result = array();
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'tradebyte-orders-downloader');
use_class('Order');
use_class('tradebyte');
use_class('xml_tools');
use_class('products_ean');
use_class('jng_sp');
use_class('jng_sp_download');
use_class('jng_sp_orders');
use_class('jng_sp_customers');
use_class('logger');
$tb = new tradebyte();
$xmlt = new xml_tools();
$class_ean = new products_ean();
$class_sp = new jng_sp();
$class_jd = new jng_sp_download();
$class_jo = new jng_sp_orders();
$class_jcust = new jng_sp_customers();
$zade_prepayment_need_refreshed = false;
function logThis($logdata)
{
global $logger;
$logger->write($logdata);
echo "{$logdata}<br />\n";
}
/////////////////////////////
// STEP 1: DOWNLOAD ORDERS //
/////////////////////////////
logThis('STEP 1: DOWNLOAD ORDERS');
<?php
use_class('products_articles');
use_class('products_ean');
use_class('products_minierp');
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'GETPRODUCTDETAIL') {
$product_input = tep_db_prepare_input($_POST['product_input']);
$result = false;
$elements_datas = array();
$jng_warehouses_id = 1;
if (strlen($product_input) == 13) {
$ean = $product_input;
$product_info = $class_ean->getProductArticle($ean);
if (!empty($product_info['products_id']) && !is_null($product_info['products_id'])) {
$products_id = $product_info['products_id'];
$articles_id = $product_info['products_articles_id'];
$product_data = $class_pm->retrieveDetail($products_id, 'p');
$elements_used = $class_pm->retrieveElementsUsage($products_id, $articles_id);
foreach ($elements_used as $element) {
$element_stock_query = "SELECT es.stock";
$element_stock_query .= " FROM elements_stock es";
$element_stock_query .= " WHERE es.jng_warehouses_id={$jng_warehouses_id}";
$element_stock_query .= " AND es.elements_id=" . $element['elements_id'];
$element_stock_result = tep_db_query($element_stock_query);
if (tep_db_num_rows($element_stock_result) > 0) {
$element_stock = tep_db_fetch_array($element_stock_result);
$el_stock = $element_stock[stock];
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
define('FPDF_IMGPATH', DIR_WS_IMAGES . 'pdf/');
define('FPDF_FONTPATH', FPDF_IMGPATH . 'fonts/');
require_once DIR_WS_CLASSES . 'fpdf.php';
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('orders');
use_class('products_ean');
use_class('bins');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_o = new orders();
$class_ean = new products_ean();
$class_bin = new bins();
$PRINT_RETAILS = isset($_GET['type']) && $_GET['type'] == 'retails';
$ean_collection = array();
$orders = array();
$orders_barcode = array();
$inhh_status = '8';
$oi_printed_sp = array();
$oi_printed_jg = array();
$total_products_picked = 0;
$bin_location_qty_collection = array();
//GET FLAG INCLUDE REPACKAGE
$ir = tep_db_prepare_input($_GET['ir']);
$need_repackage = $ir == 1 ? true : false;
$filter_ir_sp = " AND " . ($need_repackage ? 'jo.need_repackaging=1' : 'jo.need_repackaging!=1');
$filter_ir_jg = $need_repackage ? 'o.need_repackaging=1' : 'o.need_repackaging!=1';
echo $result['label'];
} else {
//ACCESSED FROM MC
use_class('barcode_label');
use_class('jng_sp');
use_class('orders');
use_class('jng_sp_orders');
use_class('depot_orders');
use_class('products_ean');
use_class('products_minierp');
$class_bl = new barcode_label();
$class_sp = new jng_sp();
$class_orders = new orders();
$class_jo = new jng_sp_orders();
$class_do = new depot_orders();
$class_pean = new products_ean();
$class_pm = new products_minierp();
//Barcode ID: SP-XXXX / JG-XXXX / PO XXX
$barcode_id = trim(tep_db_prepare_input($_POST['bcid']));
//Barcode Type: ean13 / code39
$barcode_type = trim(tep_db_prepare_input($_POST['bctype']));
//Label Type: jewelboxlabel / elementorderlabel / label_product_ottob2b
$label_type = tep_db_prepare_input($_POST['ltype']);
$product_id = tep_db_prepare_input($_POST['pid']);
$article_id = tep_db_prepare_input($_POST['aid']);
$sp_id = tep_db_prepare_input($_POST['spid']);
$productean = tep_db_prepare_input($_POST['ean']);
$printer_resolution = tep_db_prepare_input($_POST['pres']);
if ($label_type == 'label_product_tag' || $label_type == 'label_producttag') {
$ean = null;
$pi_barcode = null;
$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 {
$segment = $class_bin->retrieveSegmentDetail($bin['bin_segments_id']);
$jng_warehouses_id = $segment['warehouses_id'];
$products_id = $article['products_id'];
$articles_id = $article['products_articles_id'];
$stock = $class_pm->stockRetrieveDetail($jng_warehouses_id, $products_id, $articles_id);
$bin_current = $class_bin->getBinProductStock($stock['products_stock_id']);
if (is_null($bin_current)) {
$class_pm->stockAdd($jng_warehouses_id, $products_id, $articles_id, $qty, "MANUAL BIN-IN by {$session_userinfo['username']}");
$class_bin->bookBinForProduct($bins_id, $stock['products_stock_id']);
header("Location: ?open=products-stock-detail&id={$stock['products_stock_id']}" . ($hidemenuscript != '' ? '&hidemenu=true' : ''));
exit;
}
if (!isset($_SESSION[$session_page]['viewall'])) {
$_SESSION[$session_page]['viewall'] = '1';
}
$view_all = $_SESSION[$session_page]['viewall'];
//PAGING QUERY & LINKS
if ($view_all == '1') {
$filter_query = " WHERE (p.products_status='1' OR ps.stock>0)";
} else {
$filter_query = " WHERE ps.stock>0";
}
if ($keywords != '') {
if (is_numeric($keywords)) {
if (strlen($keywords) == 13) {
use_class('products_ean');
$class_ean = new products_ean();
$pinfo = $class_ean->getProductArticle($keywords);
if ($pinfo['products_id'] > 0) {
unset($_SESSION[$session_page]['keywords']);
header("Location: ?open=products-stock-detail&product=" . $keywords);
exit;
}
}
$filter_query .= " AND (p.products_id IN ({$keywords}) OR p.products_model LIKE '%{$keywords}%')";
} else {
$filter_query_products_name = " AND pd.products_name LIKE '%{$keywords}%'";
$tmp_keywords = explode(',', $keywords);
if (count($tmp_keywords) > 0) {
if (is_numeric($tmp_keywords[0])) {
$filter_query .= " AND p.products_id IN ({$keywords})";
} else {
