function getGrossPriceAfterCommission($selling_price, $jng_sp_id, $sp_detail = null)
{
//we can also send sp_detail in jng_sp_id
if (is_null($sp_detail)) {
use_class('jng_sp');
$class_sp = new jng_sp();
$sp_detail = $class_sp->retrieveDetail($jng_sp_id);
}
$commission = $sp_detail['provision_rate'] * $selling_price;
$gross_price_after_commission = $selling_price - $commission;
return round($gross_price_after_commission, 2);
}
<?php
if (!class_exists('jng_sp')) {
use_class('jng_sp');
$class_sp = new jng_sp();
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
use_class('products_brand');
$class_pb = new products_brand();
$jng_sp_id = tep_db_prepare_input($_GET['sp']);
$products_id = tep_db_prepare_input($_GET['id']);
$sp_info = $class_sp->retrieveDetail($jng_sp_id);
$catalog = $class_jc->retrieveDetail(null, $jng_sp_id, $products_id);
$title = "Total VC Prediction";
}
$SCENARIO_STEP_MARGIN = 3;
$SCENARIO_STEP_PRICE = 5;
$SCENARIO_STEP_RETURN_RATE = 10;
$cat_query = "SELECT p.products_image";
$cat_query .= ", MAX(jo.order_date) AS latest_date";
$cat_query .= ", IFNULL(AVG(joi.price), 0) AS selling_price";
$cat_query .= ", IFNULL(SUM(joi.order_quantity),0) AS total_sold";
$cat_query .= ", IFNULL(SUM(joi.return_quantity),0) AS total_returns";
$cat_query .= ", IFNULL(SUM(joi.order_quantity-joi.return_quantity),0) AS total_net_sold";
$cat_query .= ", IFNULL(SUM((joi.order_quantity-joi.return_quantity)*joi.net_sales),0) AS total_net_sales";
$cat_query .= ", IFNULL(AVG(joi.net_sales),0) AS average_net_sales";
$cat_query .= ", IFNULL(SUM((joi.order_quantity-joi.return_quantity)*joi.material_expenses),0) AS total_material_expenses";
$cat_query .= ", IFNULL(AVG(joi.material_expenses),0) AS average_material_expenses";
$cat_query .= ", IFNULL(SUM(joi.order_quantity*joi.cost_logistic),0) AS total_cost_logistic";
$cat_query .= ", IFNULL(AVG(joi.cost_logistic),0) AS average_cost_logistic";
$cat_query .= ", IFNULL(SUM(joi.order_quantity*joi.cost_distribution),0) AS total_cost_distribution";
<?php
use_class('jng_sp');
$class_sp = new jng_sp();
//SP SETTING
$jng_sp_id = '2';
$sp_detail = $class_sp->retrieveDetail($jng_sp_id);
$commission_excl_tax = round($sp_detail['provision_rate'] * (1 + VAT), 2);
$currency = 'EUR';
$session_page = 'otto-commissions';
$year_now = date('Y');
$month_prev = date('m', strtotime("-1 month"));
if (isset($_POST['year']) && $_POST['year'] != '') {
$year = tep_db_prepare_input($_POST['year']);
} elseif (isset($_SESSION[$session_page]['year-period']) && $_SESSION[$session_page]['year-period'] != '') {
$year = $_SESSION[$session_page]['year-period'];
} else {
$year = $year_now;
}
if (isset($_POST['month']) && $_POST['month'] != '') {
$month = tep_db_prepare_input($_POST['month']);
} elseif (isset($_SESSION[$session_page]['month-period']) && $_SESSION[$session_page]['month-period'] != '') {
$month = $_SESSION[$session_page]['month-period'];
} else {
$month = $month_prev;
}
$_SESSION[$session_page]['year-period'] = $year;
$_SESSION[$session_page]['month-period'] = $month;
$year_options = array();
$month_options = array();
for ($y = 2010; $y <= $year_now; $y++) {
/**
* Get default selling price of a specific B2B sales partner
* @param Float $price_uvp Product original price (UVP)
* @param Int $sales_partner_id Sales Partner ID
* @return Float
*/
public function getPriceSellingDefaultB2B($price_uvp, $sales_partner_id)
{
use_class('jng_sp');
$class_sp = new jng_sp();
$sp_detail = $class_sp->retrieveDetail($sales_partner_id);
$provision = $sp_detail['provision_rate'] * $price_uvp;
$default_price = $price_uvp - $provision;
return round($default_price, 2);
}
function getOrderDetail($barcode = '', $idcode_ret = '')
{
//die("$barcode | $idcode_ret");
$result = array();
$result['status'] = 'MCORDERNOTFOUND';
use_class('jng_sp');
use_class('jng_sp_orders');
if ($barcode != '') {
list($type, $order_product_id) = split('-', strtoupper($barcode));
//GET order_id
$order_id = '';
if ($type == 'SP' || $type == 'JR') {
$status = 'MCSCANPRODUCT';
use_class('jng_sp_customers');
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_jc = new jng_sp_customers();
$item = $class_jo->retrieveItemDetail($order_product_id);
$order_id = $item['jng_sp_orders_id'];
$order = $class_jo->retrieveDetail($order_id);
if (count($order) > 0) {
$sp = $class_sp->retrieveDetail($order['jng_sp_id']);
$customer = $class_jc->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);
$customer_name = $order['customer_billing_firstname'] . ' ' . $order['customer_billing_lastname'];
$customers_street_address = $order['customer_billing_address'] . ' ' . $order['customer_billing_address2'];
$order_type = $sp['name'] . ' Order ' . $order['order_id'];
$result = setOrderResult($status, 'S', $order_id, $order_type, $customer['jng_sp_customers_id'], $customer_name, $order['customer_billing_email'], $order['customer_billing_phone'], $customers_street_address, $order['customer_billing_postcode'], $order['customer_billing_city'], $order['customer_billing_country']);
}
} elseif ($type == 'JG') {
$status = 'MCSCANPRODUCT';
use_class('orders');
$class_o = new orders();
$item = $class_o->retrieveProductDetail($order_product_id);
$order_id = $item['orders_id'];
$order = $class_o->retrieveDetail($order_id);
if (count($order) > 0) {
$order_type = 'J&G Order ' . $order['orders_no'];
$result = setOrderResult($status, 'J', $order_id, $order_type, $order['customers_id'], $order['customers_name'], $order['customers_email_address'], $order['customers_telephone'], $order['customers_street_address'], $order['customers_postcode'], $order['customers_city'], $order['customers_country']);
}
}
} elseif ($idcode_ret != '') {
//1 idcode_ret utk 1 order
$qsp = "SELECT j.name AS sp_name, jo.* FROM jng_sp_orders jo INNER JOIN jng_sp j ON j.jng_sp_id = jo.jng_sp_id";
$qsp .= " WHERE idcode_ret = '{$idcode_ret}' ORDER BY jo.order_date DESC LIMIT 1";
$rsp = tep_db_query($qsp);
$dsp = tep_db_num_rows($rsp) > 0 ? tep_db_fetch_array($rsp) : null;
if (is_null($dsp)) {
/* 12.05.2015:
* If not found, try to search using order number.
* So far at this time, returns from LZ.ID, ZR.ID, ZR.BR used order number barcode
*/
$qsp = "SELECT j.name AS sp_name, jo.* FROM jng_sp_orders jo INNER JOIN jng_sp j ON j.jng_sp_id = jo.jng_sp_id";
$qsp .= " WHERE jo.order_id = '{$idcode_ret}' ORDER BY jo.order_date DESC LIMIT 1";
$rsp = tep_db_query($qsp);
$dsp = tep_db_num_rows($rsp) > 0 ? tep_db_fetch_array($rsp) : null;
}
$qjg = "SELECT * FROM orders WHERE idcode_ret='{$idcode_ret}' ORDER BY date_purchased DESC LIMIT 1";
$rjg = tep_db_query($qjg);
$djg = tep_db_num_rows($rjg) > 0 ? tep_db_fetch_array($rjg) : null;
if (!is_null($dsp) || !is_null($djg)) {
$status = 'MCSCANPRODUCT';
if (!is_null($dsp) && !is_null($djg)) {
$dsp_time = strtotime($dsp['order_date']);
$djg_time = strtotime($djg['date_purchased']);
$use_data = $dsp_time >= $djg_time ? 'sp' : 'jg';
} else {
$use_data = !is_null($dsp) ? 'sp' : 'jg';
}
if ($use_data == 'sp') {
$order_id = $dsp['jng_sp_orders_id'];
use_class('jng_sp_customers');
$class_jc = new jng_sp_customers();
$customer = $class_jc->retrieveDetail(null, $dsp['jng_sp_id'], $dsp['customer_billing_id']);
$customer_name = $dsp['customer_billing_firstname'] . ' ' . $dsp['customer_billing_lastname'];
$customers_street_address = $dsp['customer_billing_address'] . ' ' . $dsp['customer_billing_address2'];
$order_type = $dsp['sp_name'] . ' Order ' . $dsp['order_id'];
$result = setOrderResult($status, 'S', $order_id, $order_type, $customer['jng_sp_customers_id'], $customer_name, $dsp['customer_billing_email'], $dsp['customer_billing_phone'], $customers_street_address, $dsp['customer_billing_postcode'], $dsp['customer_billing_city'], $dsp['customer_billing_country']);
} else {
$order_id = $djg['orders_id'];
$order_type = 'J&G Order ' . $djg['orders_no'];
$result = setOrderResult($status, 'J', $order_id, $order_type, $djg['customers_id'], $djg['customers_name'], $djg['customers_email_address'], $djg['customers_telephone'], $djg['customers_street_address'], $djg['customers_postcode'], $djg['customers_city'], $djg['customers_country']);
}
}
}
return $result;
}
$oi_article_number = $oi["article_number"];
$oi_order_item_count = $oi["order_item_count"];
$oi_order_item_total = $oi["order_item_total"];
#table jng_sp_orders
$o = $o_jngspo->retrieveDetail($oi_o_id);
$o_order_no = $o["order_id"];
$o_order_date = strtotime($o["order_date"]);
$day = date("d", $o_order_date);
$month = date("M", $o_order_date);
$o_daily_count = $o["daily_count"];
$o_shipment_id = $o["shipment_id"];
$o_cust_fname = $o["customer_shipping_firstname"];
$o_cust_lname = $o["customer_shipping_lastname"];
$o_jngspid = $o["jng_sp_id"];
#table jng_sp
$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;
echo $return_label;
break;
case 'ean13':
if (count($oi) > 0) {
use_class('products_ean');
$order_trans = array();
if ($item['trans_type'] == 'SP') {
$item_trans = $class_jo->retrieveItemDetail($item['trans_id']);
$order_trans = $class_jo->retrieveDetail($item_trans['jng_sp_orders_id']);
} elseif ($item['trans_type'] == 'JG') {
$item_trans = $class_o->retrieveProductDetail($item['trans_id']);
$order_trans = $class_o->retrieveDetail($item_trans['orders_id']);
}
if (count($item_trans) > 0 && $item_trans['status'] == '8' && $item_trans['stock_status'] != 'D') {
$sp_name = 'Missing MO';
$sp_class = 'blue';
$sp_id = $order_trans['jng_sp_id'];
if (in_array($sp_id, $order_show_sp_info)) {
use_class('jng_sp');
$class_sp = new jng_sp();
$sp = $class_sp->retrieveDetail($sp_id);
$sp_name = $sp['package_prefix'];
}
} elseif ($is_outsourced) {
$sp_name = 'Outsourcing';
$info = '<h3 style="margin:20px 0 0 0;">Bag/Label must have text</h3><h2>DP-' . $id . '<br />Quantity: ' . $item['quantity'] . 'x</h2>';
} elseif ($item['group_name'] != '') {
//$sp_name .= ' Manual';
$sp_name .= ' ' . strtoupper($segment['location']);
$info = '<h3 style="margin:20px 0 0 0;">Please group with Label</h3><h2>"' . $item['group_name'] . '"</h2>';
}
$result .= printPackageTip('P', $box_date, $info, $sp_name, $sp_class);
if ($is_outsourced) {
saveIDforPrintingOrderLabel($id_raw);
$result .= '<input type="hidden" id="print_order_id" value="' . $id_raw . '" />';
}
//$q .= " ON joir.jng_sp_orders_items_id=joi.jng_sp_orders_items_id";
$q .= " WHERE joi.shipping_window_open>='$period_start' AND joi.shipping_window_open<='$period_end'";
$q .= " AND joi.status NOT IN (10,12)";
$q .= " AND joi.products_id IN ($products)";
$q .= " GROUP BY joi.products_id";
}
$r = tep_db_query($q);
while($row=tep_db_fetch_array($r)) {
$ajaxResult['row-'.$row['products_id']] = intval($row['solds']);
}
*/
//TRY SWITCHING TO REPORT COGS TABLE
if ($spid == 0) {
$sp_detail = array('package_prefix' => 'JG.DE');
} else {
$sp_detail = $class_sp->retrieveDetail($spid);
}
if (!is_array($products)) {
$products = explode(',', $products);
}
$ajaxResult = array();
$ajaxResult['period'] = 'p-' . $period;
$ajaxResult['period_text'] = $sp_detail['package_prefix'] . '<br />' . substr($period_start_raw, 0, 5) . ' - ' . substr($period_end_raw, 0, 5);
if ($level == 'p') {
$cogs_result = ReportCOGS::retrieveSummaryByProducts($products, $spid, $period_start, $period_end);
foreach ($products as $pid) {
$ajaxResult['row-' . $pid] = intval($cogs_result[$pid]['total_quantity']);
}
} else {
$cogs_result = ReportCOGS::retrieveSummaryByArticles($products, $spid, $period_start, $period_end);
$palist = $class_pa->retrieveAllArticlesByProducts($products);
$voucher_result = tep_db_query($voucher_query);
$voucher_used = tep_db_num_rows($voucher_result);
if ($voucher_used > 0) {
while ($row = tep_db_fetch_array($voucher_result)) {
$vouchers[] = $row;
}
}
}
} elseif ($source == Order::ORDER_TYPE_SALES_PARTNER) {
use_class('jng_sp');
use_class('jng_sp_customers');
$class_sp = new jng_sp();
$class_jcust = new jng_sp_customers();
$order_object = new Order(Order::ORDER_TYPE_SALES_PARTNER, $order_id);
$order = $class_jo->retrieveDetail($order_id);
$sp_detail = $class_sp->retrieveDetail($order['jng_sp_id']);
$customer = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']);
if (is_null($customer)) {
$customer_ids = $class_jcust->getFromOrder($order['jng_sp_orders_id']);
$customer = $class_jcust->retrieveDetail($customer_ids['customer_billing_id']);
}
$order['amount_discount'] = 0;
$order_int_comments = $class_jo->retrieveComments($order_id);
$comments = $class_jo->drawComments($order_int_comments, 'Internal Comments', 'h2');
$items = $class_jo->retrieveItems($order_id);
$items_colname_id = 'jng_sp_orders_items_id';
$items_colname_price = 'price';
$items_colname_qty = 'order_quantity';
foreach ($items as $ikey => $i) {
$items[$ikey]['return_qty'] = 0;
$returns = $class_jo->retrieveReturnItem($i['jng_sp_orders_items_id']);
$class_jcs->deleteComment($customer_id, $comment_id);
echo utf8_encode($comment_id);
exit;
} elseif ($_POST['me_action'] == 'SAVETEXTALERT') {
$text_alert = tep_db_prepare_input(utf8_decode($_POST['text_alert']));
$result = $class_jcs->updateCustomer($jng_sp_customers_id, 'text_alert', $text_alert);
exit;
} elseif ($_POST['me_action'] == 'CHANGELISTTYPE') {
$new_type = tep_db_prepare_input(utf8_decode($_POST['new_type']));
$result = $class_jcs->updateCustomer($jng_sp_customers_id, 'list_type', $new_type);
exit;
}
}
//START TEMPLATE
$customer = $class_jcust->retrieveDetail($jng_sp_customers_id);
$sp_detail = $class_sp->retrieveDetail($customer['jng_sp_id']);
$total_orders = $class_jcust->retrieveTotalOrders($jng_sp_customers_id);
$total_products_ordered = $class_jcust->retrieveTotalProductsOrdered($jng_sp_customers_id);
$typeimg = $class_jcs->getTypeSymbol($detail['list_type']);
$typename = $class_jcs->getTypeName($detail['list_type']);
$content = '';
$content .= '<div style="float:left;width:330px;">';
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td colspan="2"><h2 style="margin:0;"><a href="?open=sp-customer&id=' . $jng_sp_customers_id . '" title="View Customer Detail">' . $customer['customer_firstname'] . ' ' . $customer['customer_lastname'] . '</a></h2></td></tr>';
//$content .= '<tr><td width="110">Partner</td><td>'.$sp_detail['name'].'</td></tr>';
//$content .= '<tr><td width="110">Email Address</td><td>'.$customer['customer_email'].'</td></tr>';
$content .= '<tr><td colspan="2"><div id="btn-mover">';
if ($detail['list_type'] == 'N') {
$content .= '<input type="button" class="red" name="B" Value="Add to Blacklist" title="Add Customer to Blacklist" />';
$content .= '<input type="button" class="red" name="V" Value="Upgrade as VIP" title="Upgrade Customer as VIP" />';
} else {
}
}
//START TEMPLATE
if (isset($_GET['action'])) {
$post_action_run = true;
if ($_GET['action'] == 'insert') {
$messagebox->add('New Sales Partner is added.', 'green');
} elseif ($_GET['action'] == 'update') {
$messagebox->add('Changes is successfully saved.', 'green');
}
} else {
$post_action_run = false;
}
if ($salespartner_id != 'new') {
$salespartner_query = tep_db_query("SELECT * FROM jng_sp WHERE jng_sp_id={$salespartner_id}");
$spdetail = $class_sp->retrieveDetail($salespartner_id);
if (isset($spdetail['jng_sp_id']) && $spdetail['jng_sp_id'] > 0) {
$jng_sp_id = $spdetail['jng_sp_id'];
$active_status = $spdetail['active_status'];
$use_in_forecast = $spdetail['use_in_forecast'];
$tb_channel = $spdetail['tb_channel'];
$jng_id = $spdetail['jng_id'];
$name = $spdetail['name'];
$website = $spdetail['website'];
$contact_person = $spdetail['contact_person'];
$email = $spdetail['email'];
$provision = $spdetail['provision'];
$provision_rate = $spdetail['provision_rate'];
$brand_id = $spdetail['brand_id'];
$delivery_time = $spdetail['delivery_time'];
$package_prefix = $spdetail['package_prefix'];
ini_set('memory_limit', '512M');
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');
use_class('products_minierp');
use_class('products_articles');
use_class('stock_booking');
use_class('ReportCOGS');
$class_sp = new jng_sp();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$amazon = $class_sp->retrieveDetail('5');
//ACTIVATE BELOW LINES FOR AMAZON, COMMENT TO GRAB ALL ARTICLES
//$category_ignore_articles = array('2', '3', '30');
$show_image = isset($_POST['show_image']) && $_POST['show_image'] == '1';
$this_year = date('Y');
$this_year_start = $this_year . '-01-01';
$this_year_end = $this_year . '-12-31';
$last_year_spid = '5';
$last_year_sp = $class_sp->retrieveDetail($last_year_spid);
$last_year = date('Y', strtotime('last year'));
$last_year_start = $last_year . '-01-01';
$last_year_end = $last_year . '-12-31';
$hn = array();
if ($show_image) {
$hn['image'] = 'Product Image';
}
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 nmdePCLfilename($shipment_id)
{
if (!isset($this->nmde_pcl_suffix) || $this->nmde_pcl_suffix == '') {
use_class('jng_sp');
$class_sp = new jng_sp();
$sp_detail = $class_sp->retrieveDetail('1');
$this->nmde_pcl_suffix = substr($sp_detail['jng_id'], -3);
}
$pcl_filename = $shipment_id . '_' . $this->nmde_pcl_suffix . '.afp.pcl';
return $pcl_filename;
}
