$total_products_picked += $oi['order_quantity'];
$prev_oid = $oid;
}
//GET FOR JnG ORDERS
if (!$PRINT_RETAILS && count($orders) < $trolley_capacity) {
$jg_orders = $class_o->retrieveOrdersItemsFromDepo($inhh_status, WAREHOUSE_ID_PRODUCTS_HAMBURG, '', $filter_ir_jg);
$prev_oid = '';
foreach ($jg_orders as $oiid => $oi) {
$oid = 'JGO' . $oi['orders_id'];
$ean_id = $oi['products_id'] . '-' . $oi['products_articles_id'];
$oi['order_quantity'] = intval($oi['products_quantity']);
if ($prev_oid != $oid && count($orders) >= $trolley_capacity) {
break;
}
if (!isset($ean_collection[$ean_id])) {
$ean_collection[$ean_id] = $class_ean->getEAN($oi['products_id'], $oi['products_articles_id']);
}
$oi['products_ean'] = $ean_collection[$ean_id];
if (!isset($orders[$oid])) {
$orders[$oid] = array();
$orders_barcode[$oid] = 'JG-' . $oiid;
}
if (!isset($bin_location_qty_collection[$oi['bin_code']])) {
$bin_location_qty_collection[$oi['bin_code']] = 0;
}
$bin_location_qty_collection[$oi['bin_code']] += $oi['order_quantity'];
if (!isset($pick_from_racks[$oi['bin_code']])) {
$pick_from_racks[$oi['bin_code']] = array();
}
if (!isset($pick_from_racks[$oi['bin_code']][$oid])) {
$pick_from_racks[$oi['bin_code']][$oid] = array();
$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;
}
break;
}
tep_db_close();
} else {
}
$result .= printPackageTip('P', '', '', $sp_name, $sp_class);
} else {
//If product is already sent
$errinfo = sprintf($template_error_status, $item_status[$item['status']]);
$result .= printPackageTip('E', $box_date, $errinfo, $sp_name);
}
}
}
} elseif ($type == 'JG') {
//FOR JULIE & GRACE ORDER
//$sp_name = 'J&G';
$sp_name = 'Orders';
$sp_class = 'pink';
$item = $class_o->retrieveProductDetail($id);
$item['products_ean'] = $class_ean->getEAN($item['products_id'], $item['products_articles_id']);
if (count($item) == 0) {
//If no product found
$errinfo = $template_error_not_found;
$result .= printPackageTip('E', $box_date, $errinfo, $sp_name, $sp_class);
} else {
//If product is found
if (strtoupper($ean_scan) != 'SKIP' && $ean_scan != $item['products_ean']) {
$result .= printPackageTip(EAN_MISMATCH_ERROR, $item['products_ean'], $ean_scan);
} else {
if ($item['status'] < intval($old_status)) {
//If product status is not yet finish
$errinfo = $template_error_not_finish;
$result .= printPackageTip('E', $box_date, $errinfo, $sp_name, $sp_class);
} elseif ($item['status'] == $old_status) {
//If product status is finish
$ean = $item['products_ean'];
$qty = $item['order_quantity'];
$ean_printed = $item['ean_printed'];
$barcode_id = "SP-{$oiid}";
break;
case 'JG':
use_class('orders');
$class_o = new orders();
$item = $class_o->retrieveProductDetail($oiid);
if ($counter_on || is_null($item['ean_printed']) || $item['ean_printed'] == '') {
$class_o->printConfirmAdd($oiid);
$class_o->eanPrintedSet($order['orders_id']);
}
$pid = $item['products_id'];
$aid = $item['products_articles_id'];
$ean = $class_ean->getEAN($pid, $aid);
$qty = $item['products_quantity'];
$ean_printed = $item['ean_printed'];
$barcode_id = "JG-{$oiid}";
break;
case 'DP':
use_class('depot_orders');
$class_do = new depot_orders();
$item = $class_do->retrieveDetail($oiid);
if ($counter_on || is_null($item['ean_printed']) || $item['ean_printed'] == '') {
$class_do->printConfirmAdd($oiid);
$class_do->eanPrintedSet($oiid);
}
$pid = $item['products_id'];
$aid = $item['articles_id'];
$ean = $item['products_ean'];
for ($x = 1; $x <= $total_qty; $x++) {
$items_id = $class_do->newOrder($segments_id, $products_id, $articles_id, $products_ean, 1, null, '', depot_orders::MANUAL_REFILL_LTF, depot_orders::GROUP_NAME_LTF_INTERNAL);
$ids_created[] = $items_id;
}
$ajaxResult = array();
$ajaxResult['total_qty'] = $total_qty;
$ajaxResult['ids_created'] = implode(',', $ids_created);
ajaxReturn($ajaxResult);
exit;
} elseif ($_POST['me_action'] == "CREATEORDER") {
$segments_id = tep_db_prepare_input($_POST['segments_id']);
$products_id = tep_db_prepare_input($_POST['products_id']);
$articles_id = tep_db_prepare_input($_POST['articles_id']);
$order_qty = tep_db_prepare_input($_POST['order_qty']);
$group_name = tep_db_prepare_input($_POST['group_name']);
$product_ean = $class_ean->getEAN($products_id, $articles_id);
for ($x = 1; $x <= $order_qty; $x++) {
$class_do->newOrder($segments_id, $products_id, $articles_id, $product_ean, 1, null, null, null, $group_name);
}
$ajaxResult = array();
$ajaxResult['qty_id'] = 'qty-' . $products_id . '-' . $articles_id;
$ajaxResult['qty_order'] = $order_qty;
ajaxReturn($ajaxResult);
} elseif ($_POST['me_action'] == 'LOADDAILYLTFORDERS') {
$year = date('Y');
$period_start = "{$year}-01-01 00:00:00";
$period_end = "{$year}-12-31 23:59:59";
$dl_icon_template = '<span id="%s" class="ui-icon ui-icon-disk pointer" style="float:right;" title="Click here to download PO for this order"></span>';
$trans_id_filter = depot_orders::MANUAL_REFILL_OUTSOURCED . ',' . depot_orders::MANUAL_REFILL_LTF;
$q = "SELECT SUM(do.quantity) AS qty, DATE(do.order_date) AS daily_period" . ", IFNULL(doo.suppliers_id, 0) AS suppliers_id" . ", IFNULL(es.suppliers_name, 'Internal') AS suppliers_name" . " FROM depot_orders do" . " LEFT JOIN depot_orders_outsourced doo ON doo.depot_orders_id=do.depot_orders_id" . " LEFT JOIN elements_suppliers es ON es.elements_suppliers_id=doo.suppliers_id" . " WHERE do.order_date >= '{$period_start}' AND do.order_date <= '{$period_end}'" . " AND do.trans_type='' AND do.trans_id IN ({$trans_id_filter})" . " AND do.status NOT IN (10,12)" . " GROUP BY daily_period, suppliers_id" . " ORDER BY daily_period, suppliers_id";
$r = tep_db_query($q);
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;
}
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);
}
}
}
//$result = drawLengthsForm($products_id);
$result = 'UPDATED';
echo utf8_encode($result);
exit;
// TODO: remove this after freetext switch to attach
// } elseif($_POST['me_action']=='SAVEMANPI') {
// $products_id = tep_db_prepare_input($_POST['products_id']);
// $manual_pi = tep_db_prepare_input($_POST['manpi']);
$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') {
}
$clean_picklists = array();
$dbq = tep_db_query($q);
if (tep_db_num_rows($dbq) > 0) {
while ($row = tep_db_fetch_array($dbq)) {
$products_ean = $class_ean->getEAN($row['products_id'], $row['articles_id']);
$row['products_ean'] = $products_ean;
$clean_picklists[$row['code']] = $row;
}
class PDF extends FPDF
{
var $header_date;
//Page header
function Header()
{
}
//Page footer
function Footer()
{
if ($this->header_date == '') {
$this->header_date = date('d.m.Y H:i');
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) {
if (statusIsCancelled($item['status']) && $barcode_new == '') {
$barcode_new = 'JG-' . $i['orders_products_id'];
}
$qty = intval($i['products_quantity']);
$ean_code = $class_ean->getEAN($i['products_id'], $i['products_articles_id']);
for ($x = 1; $x <= $qty; $x++) {
$products_ean[] = $ean_code;
}
}
}
} else {
$result['status'] = 'ERROR';
$result['message'] = $statusName[$item['status']];
}
}
} else {
$result['status'] = 'ERROR';
$result['message'] = 'Order not found, please rescan!';
}
} elseif ($type_length == 5 || $type == 'AM' || $type == 'BV' || $type == 'OT') {
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 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);
}
}
}
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;
}
function amazonVDTemplateXML($xml_type, $data_type, $data)
{
$xml_templ = '';
if ($xml_type == 'variations') {
$ean = $data_type == 'P' ? '' : $data['EAN'];
$protype = $data_type == 'P' ? $data['ProductTypeName'] : '';
$vartype = $data_type == 'P' ? $data['VariationThemeID'] : '';
$ringsize = $data_type == 'P' ? '' : $data['RingSize'];
$chainlen = $data_type == 'P' ? '' : $data['ItemDisplayLength'];
$eannames = $data_type == 'P' ? $data['ParentName'] : $data['ChildName'];
$eancodes = $data_type == 'P' ? $data['ParentCode'] : $data['ChildCode'];
$xml_templ = "\n" . ' <Row>' . "\n";
$xml_templ .= ' ' . amazonVDXMLCell($data_type);
$xml_templ .= ' ' . amazonVDXMLCell($ean);
$xml_templ .= ' ' . amazonVDXMLCell($protype);
$xml_templ .= ' ' . amazonVDXMLCell($vartype);
//$xml_templ .= ' '.amazonVDXMLCell('');
$xml_templ .= ' ' . amazonVDXMLCell($ringsize);
$xml_templ .= ' ' . amazonVDXMLCell($chainlen);
$xml_templ .= ' ' . amazonVDXMLCell($eannames);
$xml_templ .= ' ' . amazonVDXMLCell($eancodes);
$xml_templ .= ' ' . amazonVDXMLCell($data['BrandName']);
$xml_templ .= ' </Row>';
} elseif ($xml_type == 'descriptions') {
$xml_templ = "\n" . ' <Row>' . "\n";
$xml_templ .= ' ' . amazonVDXMLCell($data_type);
$xml_templ .= ' ' . amazonVDXMLCell('');
$xml_templ .= ' ' . amazonVDXMLCell($data);
$xml_templ .= ' </Row>';
} elseif ($xml_type == 'accessories') {
use_class('products_ean');
$class_pean = new products_ean();
foreach ($data as $acc_pid) {
$xml_templ = "\n" . ' <Row>' . "\n";
$xml_templ .= ' ' . amazonVDXMLCell($data_type);
$xml_templ .= ' ' . amazonVDXMLCell($class_pean->getEAN($acc_pid['links_id']));
$xml_templ .= ' </Row>';
}
}
return $xml_templ;
}
function getReturnedProducts($sp_type, $order_id)
{
$result = array();
$returns = array();
if (strtolower($sp_type) == 's') {
// $ret_query = "SELECT joi.jng_sp_orders_items_id AS order_product_id, p.products_id, p.products_image, p.products_model, p.products_ean, pd.products_name";
// $ret_query .= " FROM jng_sp_orders jo";
// $ret_query .= " LEFT JOIN jng_sp sp ON sp.jng_sp_id=jo.jng_sp_id";
// $ret_query .= " LEFT JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_id=jo.jng_sp_orders_id";
// $ret_query .= " LEFT JOIN products p ON p.products_id=joi.products_id";
// $ret_query .= " LEFT JOIN products_description pd ON pd.products_id = p.products_id";
// $ret_query .= " WHERE jo.jng_sp_orders_id = $order_id AND joi.status IN (9,11) AND pd.language_id = 2";
// $ret_query .= " ORDER BY jo.order_date DESC, jo.jng_sp_orders_id DESC, joi.order_item_count ASC";
$ret_query = "SELECT joi.jng_sp_orders_items_id AS order_product_id, joi.order_quantity AS qty_order, p.products_id, p.products_image, p.products_model, joi.products_ean, pd.products_name";
$ret_query .= " FROM jng_sp_orders_items joi";
$ret_query .= " LEFT JOIN products p ON p.products_id=joi.products_id";
$ret_query .= " LEFT JOIN products_description pd ON pd.products_id = p.products_id";
$ret_query .= " WHERE joi.jng_sp_orders_id = {$order_id} AND joi.status IN (9,11,16,17,18,19,20,21) AND pd.language_id = 2";
$ret_query .= " ORDER BY joi.jng_sp_orders_items_id";
$ret_result = tep_db_query($ret_query);
while ($row = tep_db_fetch_array($ret_result)) {
$qty_order = 0;
$total_return = 0;
$joi_id = $row['order_product_id'];
$qty_order = $row['qty_order'];
$c_ret = tep_db_query("SELECT COUNT(*) AS total_return FROM jng_sp_orders_items_return WHERE jng_sp_orders_items_id = {$joi_id}");
$r_ret = tep_db_fetch_array($c_ret);
$total_return = $r_ret['total_return'];
if ($qty_order > $total_return) {
$image = webImageSource($row['products_image'], '80');
//'http://www.julie-grace.de/images/imagecache/500x500_03601033.jpg';
$returns[] = $joi_id . "|" . $image . "|" . $row['products_id'] . " / " . $row['products_model'] . "\n" . $row['products_name'] . "|" . $row['products_ean'] . "|" . $sp_type . "|" . $order_id;
}
}
} elseif (strtolower($sp_type) == 'j') {
use_class('products_ean');
$class_pean = new products_ean();
// $ret_query = "SELECT op.orders_products_id AS order_product_id, p.products_id, p.products_image, p.products_model, p.products_ean, pd.products_name";
// $ret_query .= " FROM orders_products op";
// $ret_query .= " LEFT JOIN orders o ON o.orders_id=op.orders_id";
// $ret_query .= " LEFT JOIN products p ON p.products_id=op.products_id";
// $ret_query .= " LEFT JOIN products_description pd ON pd.products_id = p.products_id";
// $ret_query .= " WHERE o.orders_id = $order_id AND op.status>0 AND op.status IN (9,11) AND pd.language_id = 2";
// $ret_query .= " ORDER BY o.date_purchased ASC, o.orders_id ASC, op.order_item_count";
$ret_query = "SELECT op.orders_products_id AS order_product_id, op.products_articles_id, op.products_quantity AS qty_order, p.products_id, p.products_image, p.products_model, pd.products_name";
$ret_query .= " FROM orders_products op";
$ret_query .= " LEFT JOIN orders o ON o.orders_id=op.orders_id";
$ret_query .= " LEFT JOIN products p ON p.products_id=op.products_id";
$ret_query .= " LEFT JOIN products_description pd ON pd.products_id = p.products_id";
$ret_query .= " WHERE op.orders_id = {$order_id} AND op.status>0 AND op.status IN (9,11,16,17,18,19,20,21) AND pd.language_id = 2";
$ret_query .= " ORDER BY op.orders_products_id";
$ret_result = tep_db_query($ret_query);
while ($row = tep_db_fetch_array($ret_result)) {
$qty_order = 0;
$total_return = 0;
$op_id = $row['order_product_id'];
$article_id = $row['products_articles_id'] != '' ? $row['products_articles_id'] : null;
$ean = $class_pean->getEAN($row['products_id'], $article_id);
$qty_order = $row['qty_order'];
$c_ret = tep_db_query("SELECT COUNT(*) AS total_return FROM orders_products_return WHERE orders_products_id = {$op_id}");
$r_ret = tep_db_fetch_array($c_ret);
$total_return = $r_ret['total_return'];
if ($qty_order > $total_return) {
$image = webImageSource($row['products_image'], '80');
//'http://www.julie-grace.de/images/imagecache/500x500_03601033.jpg';
$returns[] = $row['order_product_id'] . "|" . $image . "|" . $row['products_id'] . " / " . $row['products_model'] . "\n " . $row['products_name'] . "|" . $ean . "|" . $sp_type . "|" . $order_id;
}
}
}
$result['returns'] = $returns;
return $result;
}
