$content .= ' <table border="0" cellpadding="0" cellspacing="0">';
$content .= ' <tr><th style="width:150px;">Configuration</th><th colspan="2" style="width:150px;">Value</th></tr>';
$content .= ' <tr class="o"><td>Silver Usage</td><td>' . $input72 . '</td><td>gram</td></tr>';
$content .= ' <tr class="e"><td>Antitarnish Usage</td><td>' . $input73 . '</td><td>liter</td></tr>';
$content .= ' </table>';
$content .= ' </div>';
$content .= '</div>';
//#production .draw-table
//
//Production Instruction Settings Form
use_class('jng_sp');
use_class('products_brand');
$class_sp = new jng_sp();
$class_pb = new products_brand();
$sps = $class_sp->retrieveList();
$brands = $class_pb->retrieveList('active_status=1');
$content .= '<div id="production-instruction" class="draw-table" style="clear:both;padding-top:20px;">';
$content .= ' <div style="float:left;">';
$content .= ' <h2>Production Instruction (PI) Using Red Paper</h2>';
$content .= ' <table border="0" cellpadding="0" cellspacing="0">';
$content .= ' <tr><th style="width:150px;">Configuration</th><th style="width:550px;">Value</th></tr>';
$content .= ' <tr class="o"><td>Sales Partner</td><td>';
$checked = in_array('0', $sp_using_red_paper) ? 'checked="checked"' : '';
$cbid = 'set-pi-red-sp-0';
$content .= '<div class="float-left w080 tal" style="margin:2px 0;"><input type="checkbox" id="' . $cbid . '" name="' . $cbid . '" value="0" ' . $checked . '/><label for="' . $cbid . '"> JG.DE</label></div>';
foreach ($sps as $sp_id => $dt) {
$cbid = 'set-pi-red-sp-' . $sp_id;
$checked = in_array($sp_id, $sp_using_red_paper) ? 'checked="checked"' : '';
$content .= '<div class="float-left w080 tal" style="margin:2px 0;"><input type="checkbox" id="' . $cbid . '" name="' . $cbid . '" value="' . $sp_id . '" ' . $checked . '/><label for="' . $cbid . '"> ' . $dt['package_prefix'] . '</label></div>';
}
$content .= ' </td></tr>';
function comboProductsBrand($id, $name = '', $value = '', $class = '', $html_params = '', $filter = '')
{
use_class('products_brand');
$class_pb = new products_brand();
$brands = $class_pb->retrieveList($filter, 'brand_name');
$navoptions = '<select id="' . $id . '"';
if ($name != '') {
$navoptions .= ' name="' . $name . '"';
}
if ($class != '') {
$navoptions .= ' class="' . $class . '"';
}
if ($html_params != '') {
$navoptions .= ' ' . $html_params;
}
$navoptions .= '>';
$selected = $value == '' ? 'selected="selected"' : '';
$navoptions .= '<option value="" ' . $selected . '>Please select a brand...</option>';
$navoptions .= '<option value="0" ' . ($value == '0' ? 'selected="selected"' : '') . '>No Special Brand</option>';
//$navoptions .= loadComboList('products_brand', 'products_brand_id', 'brand_name', $value, "active_status = '1'");
foreach ($brands as $brand_id => $brand_data) {
$navoptions .= '<option value="' . $brand_id . '" ' . ($value == $brand_id ? 'selected="selected"' : '') . '>' . $brand_data['brand_name'] . '</option>';
}
$navoptions .= '</select>';
return $navoptions;
}
private function renderFilter()
{
use_class('jng_sp');
use_class('products_brand');
use_class('CategoryTop');
$class_sp = new jng_sp();
$class_pb = new products_brand();
$sp_datas = $class_sp->retrieveList();
$brands = $class_pb->retrieveList("active_status='1'");
//FILTER Order Type
$order_type_selected = self::getSession(self::FILTER_ORDER_TYPE);
$order_types = array(self::ORDER_TYPE_ALL => 'All Orders', self::ORDER_TYPE_JG => 'JG Orders');
$order_type_groups['SP Orders'][self::ORDER_TYPE_SP] = 'All SP Orders';
foreach ($sp_datas as $sp_id => $sp_data) {
$order_type_groups['SP Orders'][$sp_id] = $sp_data['name'];
}
$order_type_groups['Depot Orders'] = $this->DP_ORDER_TYPES;
$filter_order_type = '<select name="' . self::FILTER_ORDER_TYPE . '" class="cbo_filters">' . loadComboListFromArray($order_types, null, $order_type_selected, true, $order_type_groups) . '</select>';
/* Filter SP now merged into Filter Order Type
array_unshift($sp_datas, array(self::FILTER_SP_ID => '0', 'name' => 'All Sales Partners'));
$filter_sp = $class_sp->drawCombo($sp_datas, $this->filters_sp_id, '', self::FILTER_SP_ID, 'cbo_filters');
*/
//FILTER Brand
$brand_options = array();
$brand_options[0] = 'Show All Brands';
foreach ($brands as $b) {
$brand_options[$b['products_brand_id']] = $b['brand_name'];
}
$filter_brand = '<select name="' . self::FILTER_BRAND_ID . '" class="cbo_filters">' . loadComboListFromArray($brand_options, null, $this->filters_brand_id, false) . '</select>';
//FILTER Category
$category_selected = self::getSession(self::FILTER_CAT_ID);
$categories = array('' => 'Show All Categories');
$category_groups = array();
while ($ct = CategoryTop::getOneByOneAsObject()) {
if ($ct->getCategoriesTotalCount() > 0) {
while ($cat = $ct->getCategoriesOneByOneAsObject()) {
if ($cat->getProductCodePrefix() != "") {
$category_groups[$ct->name][$cat->id] = $cat->getName(1);
}
}
}
}
$filter_category = '<select name="' . self::FILTER_CAT_ID . '" class="cbo_filters">' . loadComboListFromArray($categories, null, $category_selected, true, $category_groups) . '</select>';
/*
$filter_category =
comboProductsCategory(
self::FILTER_CAT_ID
, self::FILTER_CAT_ID
, $this->filters_cat_id
, 'cbo_filters'
, ''
, 'Show All Category');
*/
//FILTER Product ID/EAN
$filter_prod_search = '<input type="text" name="' . self::FILTER_LIST_EAN . '" class="txt_filters input" value="' . $this->filters_list_ean . '" />';
//FILTER Order No.
$filter_orders_no = '<input type="text" name="' . self::FILTER_LIST_ORDERS_NO . '" class="txt_filters" value="' . $this->filters_list_orders_no . '" />';
//FILTER Lead Time Start Date
$filter_leadtime = '<input name="' . self::FILTER_LEADTIME_START_DATE . '" class="date_picker" value="' . $this->filters_leadtime_date_start . '"/>' . ' to <input name="' . self::FILTER_LEADTIME_END_DATE . '" class="date_picker" value="' . $this->filters_leadtime_date_end . '"/>' . ' <input type="button" value="Go" class="btn_filters_leadtime_go" ' . 'title="Apply lead time start date filter" />' . ' <input type="button" value="Clear" class="date_range_clear" ' . 'title="Clear lead time start date filter" />';
$enter_info = '<span class="notice smallText" style="font-weight:normal;">' . '(press <em>Enter</em> to filter)</span>';
$result .= '<div style="margin-bottom:10px;">';
$result .= '<table border="0" cellpadding="0" cellspacing="0">';
$result .= '<tr>';
$result .= '<td class="bold">Order Type</td>';
//$result .= '<td class="bold">Sales Partner</td>';
$result .= '<td class="bold">Brand</td>';
$result .= '<td class="bold">Category</td>';
$result .= '<td class="bold">Product ID/EAN ' . $enter_info . '</td>';
$result .= '<td class="bold">Order No. ' . $enter_info . '</td>';
$result .= '<td class="bold">Lead Time Start Date</td>';
$result .= '</tr>';
$result .= '<tr>' . '<td>' . $filter_order_type . '</td>' . '<td>' . $filter_brand . '</td>' . '<td>' . $filter_category . '</td>' . '<td>' . $filter_prod_search . '</td>' . '<td>' . $filter_orders_no . '</td>' . '<td>' . $filter_leadtime . '</td>' . '</tr>';
$result .= '</table></div>';
return $result;
}
} else {
$button_set_1 = 'style="display:block;"';
$button_set_2 = 'style="display:none;"';
}
$cat_total_query = "SELECT count(jc.jng_sp_catalog_id) AS total FROM jng_sp_catalog jc";
if (strpos($filter_query, 'p.') !== false) {
$cat_total_query .= " LEFT JOIN products p ON p.products_id=jc.products_id";
}
$cat_total_query .= $filter_query;
$cat_total_result = tep_db_query($cat_total_query);
$cat_total = tep_db_fetch_array($cat_total_result);
//PAGING QUERY & LINKS
$offset = ($page - 1) * ROWPERPAGE;
$page_query = " LIMIT " . ROWPERPAGE . " OFFSET {$offset}";
$pagelink = tep_paging($cat_total['total'], $page, '?open=analysis-vc&page=');
$brands = $class_pb->retrieveList();
function drawBrandCombo($with_show_all, $name, $current_brand, $params = '')
{
global $brands;
$brand_combo = '<select name="' . $name . '" ' . $params . '>';
$selected = 'selected="selected"';
if ($with_show_all) {
$brand_combo .= '<option value="" ' . $sel . '>Please select a logo option...</option>';
}
$sel = $current_brand == 'N' ? $selected : '';
$brand_combo .= '<option value="N" ' . $sel . '>No Logo</option>';
$sel = $current_brand == '0' ? $selected : '';
$brand_combo .= '<option value="0" ' . $sel . '>JULIE & GRACE</option>';
foreach ($brands as $b) {
$sel = $current_brand == $b['products_brand_id'] ? $selected : '';
$brand_combo .= '<option value="' . $b['products_brand_id'] . '" ' . $sel . '>' . $b['brand_name'] . '</option>';
function retrieveListProductOverview_drawFilter($ean_list = null, $date_start = null, $date_end = null, $brand_id = null, $cat_id = null)
{
use_class('products_brand');
$class_pb = new products_brand();
$brands = $class_pb->retrieveList("active_status='1'");
$brand_options = array();
$brand_options[0] = 'Show All Brands';
foreach ($brands as $b) {
$brand_options[$b['products_brand_id']] = $b['brand_name'];
}
$filter_brand = '<select name="brand_id">' . loadComboListFromArray($brand_options, null, $brand_id, false) . '</select>';
$filter_category = comboProductsCategory('cat_id', 'cat_id', $cat_id, '', '', 'Show All Category');
$filter_prod_search = '<input type="text" name="ean_list" class="product-id input2" value="' . $ean_list . '" />';
$filter_range_date = '<input name="date_range_start" class="date_picker" value="' . $date_start . '"/>';
$filter_range_date .= ' to ';
$filter_range_date .= '<input name="date_range_end" class="date_picker" value="' . $date_end . '"/>';
$filter_range_date .= ' <input type="button" value="Go" class="date_range_go" title="Apply lead time start date filter" />';
$filter_range_date .= ' <input type="button" value="Clear" class="date_range_clear" title="Clear lead time start date filter" />';
$result .= '<div style="margin-bottom:10px;">';
$result .= '<table border="0" cellpadding="0" cellspacing="0">';
$result .= '<tr>';
$result .= '<td rowspan="2" class="w080 bold" style="v-align:middle;">Filter by:</td>';
$result .= '<td class="bold">Brand</td>';
$result .= '<td class="bold">Category</td>';
$result .= '<td class="bold">Product ID/EAN <span class="notice smallText" style="font-weight:normal;">(press <em>Enter</em> to filter)</span></td>';
$result .= '<td class="bold">Lead Time Start Date</td>';
$result .= '</tr>';
$result .= '<tr><td>' . $filter_brand . '</td><td>' . $filter_category . '</td><td>' . $filter_prod_search . '</td><td>' . $filter_range_date . '</td></tr>';
$result .= '</table></div>';
return $result;
}
function manageOrderList_drawFilter($dpo_option = 'ALL', $dpo_group = '', $ean_list = null, $date_start = null, $date_end = null, $brand_id = null, $cat_id = null)
{
$dpo_options = array();
$dpo_options['ALL'] = 'All Depot Orders';
$dpo_options['MMO'] = 'Missing Mixed Orders';
$dpo_options['MAN'] = 'Manual Refill Orders';
$dpo_options['OUT'] = 'Outsourcing Refill Orders';
$dpo_options['REF'] = 'Auto Refill Orders (ALL)';
$dpo_options['RFD'] = 'Auto Refill Orders (Daily)';
$dpo_options['RFZ'] = 'Auto Refill Orders (Zalando)';
$dpo_options['NRA'] = 'Non-Refill Orders (ALL)';
$dpo_options['NRI'] = 'Non-Refill Orders (Internal)';
$dpo_options['NRO'] = 'Non-Refill Orders (Outsourcing)';
$dpo_options['GRP'] = 'Specific Name';
$dpo_grp_options = array();
$dpo_grp_options = $this->retrieveGroupNameList();
if (count($dpo_grp_options) == 0) {
$dpo_grp_options[] = 'No Specific Name found, please use other filter';
} else {
array_unshift($dpo_grp_options, 'Select a name from the list');
}
$show_group = array('NRA', 'NRI', 'NRO', 'GRP');
$show_group_combo = in_array($dpo_option, $show_group) ? '' : ' style="display:none;"';
use_class('products_brand');
$class_pb = new products_brand();
$brands = $class_pb->retrieveList("active_status='1'");
$brand_options = array();
$brand_options[0] = 'Show All Brands';
foreach ($brands as $b) {
$brand_options[$b['products_brand_id']] = $b['brand_name'];
}
$filter_dpo = '<select class="orders-dpoo">' . loadComboListFromArray($dpo_options, null, $dpo_option, false) . '</select>';
$filter_dpo .= '<select class="orders-dpoo-group"' . $show_group_combo . '>' . loadComboListFromArray($dpo_grp_options, $dpo_group, null, false) . '</select>';
$filter_brand = '<select name="brand_id">' . loadComboListFromArray($brand_options, null, $brand_id, false) . '</select>';
$filter_category = comboProductsCategory('cat_id', 'cat_id', $cat_id, '', '', 'Show All Category');
$filter_prod_search = '<input type="text" name="ean_list" class="product-id input2" value="' . $ean_list . '" />';
$filter_range_date = '<input name="date_range_start" class="date_picker" value="' . $date_start . '"/>';
$filter_range_date .= ' to ';
$filter_range_date .= '<input name="date_range_end" class="date_picker" value="' . $date_end . '"/>';
$filter_range_date .= ' <input type="button" value="Go" class="date_range_go" title="Apply lead time start date filter" />';
$filter_range_date .= ' <input type="button" value="Clear" class="date_range_clear" title="Clear lead time start date filter" />';
$result .= '<div style="margin-bottom:10px;">';
$result .= '<table border="0" cellpadding="0" cellspacing="0">';
$result .= '<tr>';
$result .= '<td rowspan="2" class="w080 bold" style="v-align:middle;">Filter by:</td>';
$result .= '<td class="bold">Depot Order Type</td>';
$result .= '<td class="bold">Brand</td>';
$result .= '<td class="bold">Category</td>';
$result .= '<td class="bold">Product ID/EAN <span class="notice smallText" style="font-weight:normal;">(press <em>Enter</em> to filter)</span></td>';
$result .= '<td class="bold">Lead Time Start Date</td>';
$result .= '</tr>';
$result .= '<tr><td>' . $filter_dpo . '</td><td>' . $filter_brand . '</td><td>' . $filter_category . '</td><td>' . $filter_prod_search . '</td><td>' . $filter_range_date . '</td></tr>';
$result .= '</table></div>';
return $result;
}
<?php
/**
* Description of scorecardproductsmanagement
*
* @author IT TEAM BONOFACTUM
* @created Jul 8, 2013 3:28:10 PM
*/
use_class('products_brand');
use_class('scorecard');
$class_pb = new products_brand();
$brandlist = $class_pb->retrieveList();
$year_period = date('Y');
$year_previous = strval(intval($year_period) - 1);
$current_month = date('m');
$categories_active = load_config('products-categories-sorting');
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'LOADTABLES') {
$def_col_width = ' w080';
$classname_label = 'label w150';
$periods = array();
$periods_plan = array();
for ($m = 1; $m <= 12; $m++) {
$year = $year_previous;
$month = str_pad($m, 2, '0', STR_PAD_LEFT);
$p = $year . $month;
$periods[] = $p;
$periods_name[$p] = date('My', strtotime($year . '-' . $month . '-01'));
}
for ($m = 1; $m <= 12; $m++) {
$year = $year_period;
function generateBarcode($barcode_type, $barcode_id, $label_data = '', $printer_resolution = '')
{
$result = array();
$ds = $label_data == '' ? $this->retrieveData($barcode_type, $barcode_id) : $label_data;
if ($ds != "no data") {
if ($barcode_type == 'ean13') {
#$p_ean;$p_category;$p_shortname;$p_price;$order_qty;$sp_id;$p_code;$p_brand;$p_length;$p_targetaudience";
//list - split is deprecated on php 5, so we change using explode;
//list($ean13_code,$category,$products_short_name,$price,$qty,$jng_sp_id,$products_code,$products_brand,$products_length,$products_targetaudience) = split(";",$ds);
$data_source = explode(';', $ds);
$ean13_code = $data_source[0];
$category = $this->convertToGermanHex($data_source[1]);
$products_short_name = $this->convertToGermanHex($data_source[2]);
$price = $data_source[3];
$qty = $data_source[4];
$jng_sp_id = $data_source[5];
$products_code = $data_source[6];
$products_brand = $data_source[7];
$products_length = $data_source[8];
$products_targetaudience = $this->convertToGermanHex($data_source[9]);
$products_brand_id = $this->convertToGermanHex($data_source[10]);
//$amazon_label = ($jng_sp_id=='5');
$amazon_label = in_array($jng_sp_id, array_keys(getSalesPartnerUseAmazonLogistic()));
use_class('products_brand');
$class_pb = new products_brand();
$brands = $class_pb->retrieveList('need_repackaging=1');
$brands = array_keys($brands);
$need_brand_printed = in_array($products_brand_id, $brands);
//DIAMORE
if ($qty == 0) {
$qty = 1;
}
if ($ean13_code != '') {
$left_margin_amvd = 30;
//IF SUDDENLY HH PRINTED TOO MUCH TO THE RIGHT PLS CHANGE USING 5 AS BELOW
//$left_margin_amvd = 5; //IF SUDDENLY MARGIN GOING LEFT UNTIL TRUNCATE PLS USE 30 AS ABOVE
$lbcmd = "^XA";
$lbcmd .= "^CI6";
//Activate German Character
$lbcmd .= "^MTD";
//^MTD : Direct Thermal Media; ^MTT : Thermal Transfer Media
$lbcmd .= "^MD30";
$lbcmd .= "^JWH";
$lbcmd .= "^MMT";
$lbcmd .= "^MUd,300,300";
$lbcmd .= "^LH0,0";
$lbcmd .= "^MNY";
//$lbcmd .= ($jng_sp_id!='5') ? "^PW800" : "^PW900"; //IF SUDDENLY HH PRINTED TOO MUCH TO THE RIGHT PLS CHANGE USING ^PW900 AS BELOW
$lbcmd .= !$amazon_label ? "^PW800" : "^PW900";
//IF SUDDENLY HH PRINTED TOO MUCH TO THE RIGHT PLS CHANGE USING ^PW900 AS BELOW
//$lbcmd .= "^^PW900"; //Print Width //IF SUDDENLY MARGIN GOING LEFT UNTIL TRUNCATE PLS USE ^PW800 ^PW900 AS ABOVE
//$lbcmd .= "^LL149"; //Label Length, MAX LENGTH is 32000
$lbcmd .= "^JMB^FS";
//Set dots per milimeter (Big Size of Barcode)
//$lbcmd .= "^FO0,30^GB700,110^FS"; #boxes label (temporary)
//$lbcmd .= "^FO320,30^GB0,110^FS"; #vertical line / for cutting center(temporary)
//$lbcmd .= "^FO210,50^BEN,50,Y,N^FD$ean13_code^FS"; #draw barcode NON AMVD
//$lbcmd .= "^FO240,40^BEN,50,Y,N^FD$ean13_code^FS"; #draw barcode AMVD
/*
if($jng_sp_id<>3){
//FORMAT USING PRICE
$lbcmd .= "^FO0,50^ADN,1,1^FD$category^FS";
$lbcmd .= "^FO0,70^ADN,1,1^FD$material^FS";
$lbcmd .= "^FO0,100^ARN,15,4^FD$price^FS";
}else{
*/
if ($amazon_label) {
/*
//FORMAT 1
$lbcmd .= "^FO10,25^ADN,1,1^FD$products_brand^FS";
$lbcmd .= "^FO10,45^ADN,1,1^FD$products_targetaudience^FS";
$lbcmd .= "^FO10,65^ADN,1,1^FD$category $products_length^FS";
$lbcmd .= "^FO10,85^ADN,1,1^FD$products_short_name^FS";
$lbcmd .= "^FO10,105^ADN,1,1^FD$products_code^FS";
*/
/*
//FORMAT 2
$lbcmd .= "^FO10,25^ADN,1,1^FD$products_brand^FS";
$lbcmd .= "^FO10,45^ADN,1,1^FD$products_targetaudience^FS";
$lbcmd .= "^FO10,65^ADN,1,1^FD$category^FS";
$lbcmd .= "^FO10,85^ADN,1,1^FD$products_short_name^FS";
$lbcmd .= "^FO10,105^ADN,1,1^FD$products_code $products_length^FS";
*/
//FORMAT 3
$lbcmd .= "^FO240,40^BY2,3^BEN,50,Y,N^FD{$ean13_code}^FS";
//IF SUDDENLY HH PRINTED TOO MUCH TO THE RIGHT PLS CHANGE USING 210 AS BELOW
//$lbcmd .= "^FO210,40^BY2,3^BEN,50,Y,N^FD$ean13_code^FS"; #draw barcode AMVD //IF SUDDENLY MARGIN GOING LEFT UNTIL TRUNCATE PLS USE 240 AS ABOVE
$lbcmd .= "^FO{$left_margin_amvd},29^ADN,1,1^FD{$products_brand}^FS";
$lbcmd .= "^FO{$left_margin_amvd},53^ADN,1,1^FH^FD{$products_targetaudience} {$category}^FS";
$lbcmd .= "^FO{$left_margin_amvd},77^ADN,1,1^FH^FD{$products_short_name} {$products_length}^FS";
$lbcmd .= "^FO{$left_margin_amvd},101^ADN,1,1^FD{$products_code}^FS";
} else {
$lbcmd .= "^FO210,50^BEN,50,Y,N^FD{$ean13_code}^FS";
#draw barcode NON AMVD
//FORMAT NOT USING PRICE
if ($need_brand_printed) {
$lbcmd .= "^FO0,30^ADN,1,1^FH^FD{$products_brand}^FS";
$lbcmd .= "^FO0,60^ADN,1,1^FH^FD{$category} {$products_length}^FS";
$lbcmd .= "^FO0,90^ADN,1,1^FH^FD{$products_short_name}^FS";
$lbcmd .= "^FO0,120^ADN,1,1^FD{$products_code}^FS";
} else {
$lbcmd .= "^FO0,40^ADN,1,1^FH^FD{$category} {$products_length}^FS";
$lbcmd .= "^FO0,70^ADN,1,1^FH^FD{$products_short_name}^FS";
$lbcmd .= "^FO0,100^ADN,1,1^FD{$products_code}^FS";
}
}
//}
$lbcmd .= "^XZ";
$label = $lbcmd;
/*MARKED THIS >> WE ALREADY HANDLE PRINT LOOP BY QTY ON MANOBO CLIENT, AND WE NEED ONLY A SINGLE LABEL FOR EAN LOCAL CACHE
for($p=1;$p<=$qty;$p++) $label .= $lbcmd;
*/
}
$label_name = "{$ean13_code}.data";
$result['qty'] = $qty;
//number of label will be printed
} elseif ($barcode_type == 'code39') {
#date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel
//list - split is deprecated on php 5, so we change using explode;
//list($order_date,$order_num,$order_seq,$order_tag,$cust_name,$order_no,$shipment_id,$qty,$article_number,$order_product_id,$partner_type,$ean13_code,$category,$material,$price,$qty13,$jng_sp_id) = split(";",$ds);
$data_source = explode(';', $ds);
$order_date = $data_source[0];
$order_num = $data_source[1];
$order_seq = $data_source[2];
$order_tag = $data_source[3];
$cust_name = $data_source[4];
$order_no = $data_source[5];
$shipment_id = $data_source[6];
$qty = $data_source[7];
$article_number = $data_source[8];
$order_product_id = $data_source[9];
$partner_type = $data_source[10];
$ean13_code = $data_source[11];
$category = $data_source[12];
$material = $data_source[13];
$price = $data_source[14];
$qty13 = $data_source[15];
$jng_sp_id = $data_source[16];
/*
$cust_name = str_replace("ö","oe",$cust_name);
$cust_name = str_replace("ä","ae",$cust_name);
$cust_name = str_replace("ü","ue",$cust_name);
$cust_name = str_replace("ß","ss",$cust_name);
$cust_name = str_replace("Ö","Oe",$cust_name);
$cust_name = str_replace("Ä","Ae",$cust_name);
$cust_name = str_replace("Ü","Ue",$cust_name);
*
*/
$label = "^XA";
if ($printer_resolution == '300') {
$label .= "^CI6";
//Activate German Character
$label .= "^MTD";
//^MTD : Direct Thermal Media; ^MTT : Thermal Transfer Media
$label .= "^MD15";
$label .= "^JWH";
$label .= "^MMT";
$label .= "^MUd,300,300";
$label .= "^LH0,0";
//^MNY Media Tracking : non-continuous media web sensing (no need to using ^LL - Label Length);
//^MNN Media Tracking : continuous media - no label gap censor (must using ^LL - Label Length)
$label .= "^MNY";
$label .= "^PW900";
$label .= "^JMB^FS";
//Set dots per milimeter (Big Size of Barcode)
//$label .= "^LL384.5";
//$label .= "^FO50,10^ARN,30,18^FD".$order_date." - No. ".sprintf("%03s\n", $order_num)." (".$order_seq.")^FS";
$label .= "^FO20,10^APN,25,14^FD{$order_date} - No. " . sprintf("%03s\n", $order_num) . "^FS";
$label .= "^FO370,10^APN,25,14^FD{$order_tag}^FS";
$label .= "^FO20,60^BY2,3^B3N,N,50,Y,N^FD{$barcode_id}^FS";
#draw barcode
##--------------------DETAIL SECTION
#Kunde
$label .= "^FO20,160^APN,25,14^FDKunde^FS";
$label .= "^FO210,160^APN,25,14^FD:^FS";
$label .= "^FO230,160^APN,25,14^FH^FD" . $this->convertToGermanHex($cust_name) . "^FS";
#Auftragsnr
$label .= "^FO20,190^APN,25,14^FDAuftragsnr^FS";
$label .= "^FO210,190^APN,25,14^FD:^FS";
$label .= "^FO230,190^APN,25,14^FD{$order_no}^FS";
if ($shipment_id != '') {
#Lieferscheinnr
$label .= "^FO20,220^APN,25,14^FDLieferscheinnr^FS";
$label .= "^FO210,220^APN,25,14^FD:^FS";
$label .= "^FO230,220^APN,25,14^FD{$shipment_id}^FS";
#Artikel
/*
$label .= "^FO20,250^APN,25,14^FDArtikel^FS";
$label .= "^FO210,250^APN,25,14^FD:^FS";
$label .= "^FO230,250^APN,25,14^FD$article_number^FS";
*/
}
/*else{
#Artikel
$label .= "^FO20,220^APN,25,14^FDArtikel^FS";
$label .= "^FO210,220^APN,25,14^FD:^FS";
$label .= "^FO230,220^APN,25,14^FD$article_number^FS";
}*/
} else {
$label .= "^CI6";
//Activate German Character
$label .= "^MTD";
//^MTD : Direct Thermal Media; ^MTT : Thermal Transfer Media
$label .= "^MD10";
$label .= "^JWH";
$label .= "^MUd,203,203";
$label .= "^JM10000";
$label .= "^LH0,0";
//^MNY Media Tracking : non-continuous media web sensing (no need to using ^LL - Label Length);
//^MNN Media Tracking : continuous media - no label gap censor (must using ^LL - Label Length)
$label .= "^MNN";
$label .= "^LL384.5";
//$label .= "^FO50,10^ARN,30,18^FD".$order_date." - No. ".sprintf("%03s\n", $order_num)." (".$order_seq.")^FS";
$label .= "^FO50,10^ARN,30,18^FD{$order_date} - No. " . sprintf("%03s\n", $order_num) . "^FS";
$label .= "^FO500,10^ARN,30,18^FD{$order_tag}^FS";
$label .= "^FO50,60^BY3^B3N,N,100,Y,N^FD{$barcode_id}^FS";
#draw barcode
##--------------------DETAIL SECTION
#Kunde
$label .= "^FO50,210^ARN,25,14^FDKunde^FS";
$label .= "^FO240,210^ARN,25,14^FD:^FS";
$label .= "^FO260,210^ARN,25,14^FH^FD" . $this->convertToGermanHex($cust_name) . "^FS";
#Auftragsnr
$label .= "^FO50,240^ARN,25,14^FDAuftragsnr^FS";
$label .= "^FO240,240^ARN,25,14^FD:^FS";
$label .= "^FO260,240^ARN,25,14^FD{$order_no}^FS";
if ($shipment_id != '') {
#Lieferscheinnr
$label .= "^FO50,270^ARN,25,14^FDLieferscheinnr^FS";
$label .= "^FO240,270^ARN,25,14^FD:^FS";
$label .= "^FO260,270^ARN,25,14^FD{$shipment_id}^FS";
#Artikel
/*
$label .= "^FO50,300^ARN,25,14^FDArtikel^FS";
$label .= "^FO240,300^ARN,25,14^FD:^FS";
$label .= "^FO260,300^ARN,25,14^FD$article_number^FS";
*/
}
/*else{
#Artikel
$label .= "^FO50,270^ARN,25,14^FDArtikel^FS";
$label .= "^FO240,270^ARN,25,14^FD:^FS";
$label .= "^FO260,270^ARN,25,14^FD$article_number^FS";
}*/
}
$label .= "^XZ";
$file_postfix = $printer_resolution == '300' ? '' : $printer_resolution;
$label_name = strtoupper($partner_type) . "-{$order_product_id}.data{$file_postfix}";
}
$result['barcode_type'] = $barcode_type;
$result['label'] = $label;
$result['label_name'] = $label_name;
} else {
$result['label'] = $ds;
}
return $result;
}
function manageOrderList_drawFilter($jng_sp_id, $ean_list = null, $date_start = null, $date_end = null, $brand_id = null, $cat_id = null, $orders_no = '')
{
use_class('jng_sp');
use_class('products_brand');
$class_sp = new jng_sp();
$class_pb = new products_brand();
$spdata = $class_sp->retrieveList();
$brands = $class_pb->retrieveList("active_status='1'");
array_unshift($spdata, array('jng_sp_id' => '0', 'name' => 'All Sales Partners'));
$filter_sp = $class_sp->drawCombo($spdata, $jng_sp_id, '', 'jng_sp_id', 'orders-spid');
$brand_options = array();
$brand_options[0] = 'Show All Brands';
foreach ($brands as $b) {
$brand_options[$b['products_brand_id']] = $b['brand_name'];
}
$filter_brand = '<select name="brand_id">' . loadComboListFromArray($brand_options, null, $brand_id, false) . '</select>';
$filter_category = comboProductsCategory('cat_id', 'cat_id', $cat_id, '', '', 'Show All Category');
$filter_prod_search = '<input type="text" name="ean_list" class="product-id input" value="' . $ean_list . '" />';
$filter_range_date = '<input name="date_range_start" class="date_picker" value="' . $date_start . '"/>';
$filter_range_date .= ' to <input name="date_range_end" class="date_picker" value="' . $date_end . '"/>';
$filter_range_date .= ' <input type="button" value="Go" class="date_range_go" title="Apply lead time start date filter" />';
$filter_range_date .= ' <input type="button" value="Clear" class="date_range_clear" title="Clear lead time start date filter" />';
$filter_orders_no = '<input type="text" name="orders_no" class="orders-no" value="' . (is_array($orders_no) ? implode(",", $orders_no) : $orders_no) . '" />';
$enter_info = '<span class="notice smallText" style="font-weight:normal;">(press <em>Enter</em> to filter)</span>';
$result .= '<div style="margin-bottom:10px;">';
$result .= '<table border="0" cellpadding="0" cellspacing="0">';
$result .= '<tr>';
$result .= '<td rowspan="2" class="w080 bold" style="v-align:middle;">Filter by:</td>';
$result .= '<td class="bold">Sales Partner</td>';
$result .= '<td class="bold">Brand</td>';
$result .= '<td class="bold">Category</td>';
$result .= '<td class="bold">Product ID/EAN ' . $enter_info . '</td>';
$result .= '<td class="bold">Order No. ' . $enter_info . '</td>';
$result .= '<td class="bold">Lead Time Start Date</td>';
$result .= '</tr>';
$result .= '<tr><td>' . $filter_sp . '</td><td>' . $filter_brand . '</td><td>' . $filter_category . '</td><td>' . $filter_prod_search . '</td><td>' . $filter_orders_no . '</td><td>' . $filter_range_date . '</td></tr>';
$result .= '</table></div>';
return $result;
}
