$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;
}
break;
$sp_id = $o["jng_sp_id"];
#table jng_sp
$jngsp = $class_sp->retrieveDetail($sp_id);
$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 = $class_ordersrder_no == '' ? "-" : $class_ordersrder_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;
if (in_array($sp_id, $partners_need_ean13)) {
if (count($oi) > 0) {
$cats = $class_jo->getCategories($reqid);
$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;{$oi_order_qty};{$o['jng_sp_id']}";
}
}
}
echo $return_label;
break;
case 'ean13':
if (count($oi) > 0) {
echo getEANReturnResult($partnertype, $oi, $sp_id);
} else {
$jngsp = $o_jngsp->retrieveDetail($o_jngspid);
$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;
if (in_array($o_jngspid, $sp_need_ean13_per_product)) {
if (count($oi) > 0) {
use_class('products_ean');
$o_pean = new products_ean();
$cats = $o_jngspo->getCategories($reqid);
$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 != '') {
$label_material = "925er SILBER";
$return_label .= ";" . $ean . ";" . strtoupper($cats['categories_name']) . ";" . $label_material . ";" . $oi['price'] . " EUR;{$oi_order_qty};{$o['jng_sp_id']}";
}
}
}
echo $return_label;
break;
case 'ean13':
if (count($oi) > 0) {
use_class('products_ean');
$o_pean = new products_ean();
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;
}
