$items_array[$articles_id]['qty'] = 0;
}
$items_array[$articles_id]['qty'] += $i['products_quantity'];
$items_array[$articles_id]['pri'] += $i['products_quantity'] * (calculateCurrency($i['material_expenses'], 'USD')/4);
}
*/
use_class("sendback");
use_class("products_minierp");
$class_sendback = new sendback();
$class_pm = new products_minierp();
$items = $class_sendback->retrieveList('16');
$items_array = array();
foreach ($items as $i) {
$articles_id = $i['products_id'] . '-' . $i['products_articles_id'];
if (!isset($items_array[$articles_id])) {
$desc = $class_pm->retrieveCategoryName($i['categories_id'], '1');
$items_array[$articles_id]['desc'] = $desc;
$items_array[$articles_id]['code'] = $i['products_model'];
$items_array[$articles_id]['pri'] = 0;
$items_array[$articles_id]['qty'] = 0;
}
$qty = $i['type'] == 'R' ? $i['quantity_stock'] : $i['quantity_actual'];
$items_array[$articles_id]['qty'] += $qty;
$items_array[$articles_id]['pri'] += $qty * (calculateCurrency($i['material_expenses'], 'USD') / 4);
}
class PDF extends FPDF
{
var $left_margin;
var $page_width;
var $page_height;
var $font_size;
$nos_align = 'C';
$no_counter = 0;
foreach ($contents as $page => $data) {
$nos[$page] = array();
foreach ($data as $no => $c) {
$no_counter++;
$nos[$page][$no] = $no_counter;
}
}
$desc = array();
$desc_width = 70;
$desc_align = 'L';
foreach ($contents as $page => $data) {
$desc[$page] = array();
foreach ($data as $no => $c) {
$desc[$page][$no] = $class_pm->retrieveCategoryName($c['categories_id'], '1');
$spaceinbiltxt = strpos($c['billing_text'], ' ');
if ($spaceinbiltxt !== false) {
$desc[$page][$no] .= strtolower(substr($c['billing_text'], $spaceinbiltxt));
}
}
}
$code = array();
$code_width = 70;
$code_align = 'C';
foreach ($contents as $page => $data) {
$code[$page] = array();
foreach ($data as $no => $c) {
$code[$page][$no] = $c['article_number'];
}
}
function getEANReturnResult($partner_type, $products_data, $sp_id = '0')
{
use_class('jng_sp');
use_class('orders');
use_class('jng_sp_orders');
use_class('Product');
use_class('products_ean');
use_class('products_minierp');
use_class('products_articles');
use_class('products_brand');
$class_sp = new jng_sp();
$class_orders = new orders();
$class_jo = new jng_sp_orders();
$class_pean = new products_ean();
$class_pm = new products_minierp();
$class_pa = new products_articles();
$class_pb = new products_brand();
$result = "no data";
$product_id = $products_data["products_id"];
$product_article_id = $products_data["products_articles_id"];
if ($product_article_id > 0) {
$articles_data = $class_pa->retrieveDetail($product_article_id);
}
$p_ean = $class_pean->getEAN($product_id, $product_article_id);
$p = $class_pm->retrieveDetail($product_id, 'p,pd,cat,pnc');
//GETTING BRAND NAME
$p_brand_id = $p['p']['products_brand_id'];
$brand_data = $class_pb->retrieveDetail($p_brand_id);
$brand_name = strtoupper(trim($brand_data['brand_name']));
$p_brand = $brand_name == '' ? 'JULIE & GRACE' : $brand_name;
$p_code = $p['p']['products_model'];
$p_category = mb_strtoupper($class_pm->retrieveCategoryName($p['categories_id'], 2));
//$p_shortname = "925 SILBER"; //it was $label_material
//$p_shortname = ($sp_id=='5') ? strtoupper($p['pd']['2']['products_short_name']) : "925 SILBER";
$sp_used_am_logistic = array_keys(getSalesPartnerUseAmazonLogistic());
if (in_array($sp_id, $sp_used_am_logistic)) {
$p_shortname = strtoupper($p['pd']['2']['products_short_name']);
} else {
$obj_product = new product($product_id);
$metal_stamp_code = $obj_product->metal_stamp_code;
$metal_stamp_info = $metal_stamp_code == 925 ? 'SILBER' : $obj_product->metal_stamp_info;
$metal_stamp_info = $this->convertToGermanHex($metal_stamp_info);
$p_shortname = strtoupper("{$metal_stamp_code} {$metal_stamp_info}");
}
$p_length = $product_article_id > 0 ? $articles_data['length'] : $p['pnc']['products_length'];
$p_length = $p_length > 0 ? strtoupper(str_replace(' ', '', textLength($p_length))) : '';
$p_targetaudience = strtoupper(LABEL_TARGET_AUDIENCE);
//FOR TEMPORARY WE USING ONLY DAMEN
if ($partner_type == 'sp') {
$order_qty = intval($products_data["order_quantity"]);
$p_price = $products_data['price'];
} elseif ($partner_type == 'jg') {
$order_qty = $products_data["products_quantity"];
$p_price = $products_data['final_price'];
} elseif ($partner_type == 'dp') {
$order_qty = $products_data["quantity"];
$p_price = '0';
} else {
$order_qty = '';
$p_price = '';
}
if ($p_ean != '') {
$return_label = $p_ean . ";" . $p_category . ";" . $p_shortname . ";" . $p_price . " EUR;{$order_qty};{$sp_id};{$p_code};{$p_brand};{$p_length};{$p_targetaudience};{$p_brand_id}";
$result = $return_label;
}
return $result;
}
$content .= '</div>';
}
if (is_array($product['pei']) && count($product['pei']) > 0) {
$content .= '<div style="margin-top:10px;" align="center">';
$content .= '<h3>Additional Images</h3>';
foreach ($product['pei'] as $img) {
$content .= webImageWithDetailLink($img, IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Product ' . $products_id . ' Additional Image', 'img-border');
$content .= ' ';
}
$content .= '</div>';
}
$content .= '</div>';
$content .= '<div id="sop-list" class="draw-table spo">';
$content .= '<div id="prodcat-box" class="float-box ui-corner-all tac" style="margin:70px 0 0 100px;">';
if ($product['categories_id'] > 0) {
$prod_cat = $class_pm->retrieveCategoryName($product['categories_id'], 1);
$content .= '<div>Please confirm Category</div>';
$content .= '<h3>' . $prod_cat . '</h3>';
$content .= '<div style="margin-top:10px;"><input type="button" id="btn-confirm-prodcat" value="Confirm" /></div>';
} else {
$content .= '<h3 class="red">Product Category not yet set!</h3>';
}
$content .= '</div>';
$content .= '<div id="step-processes" style="display:none;">';
$content .= '<div style="margin-bottom:10px;">';
$content .= '<span style="font-size:18px;" class="bold">' . $prod_cat . '</span>';
$content .= '</div>';
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$sop_count = 0;
$content .= '<tr><th>No</th><th>Process</th><th>Action</th><th>Checklist</th></tr>';
foreach ($sops as $sop) {
$class_jc->updateField($catalog_id, $sda);
}
}
//disabled this, now its already handled on class products_minierp on each functions that possible need image reupload
//reupload changes to ot.de and am.vd
//tep_db_query("UPDATE jng_sp_catalog SET image_uploaded='0' WHERE jng_sp_id IN (2,5) AND products_id=$products_id");
$pdata = $class_pm->retrieveDetail($products_id, 'p,cat');
$products_colors = $class_pm->loadColorPatternNames($products_id, $languages_id);
use_class('products_brand');
$class_pb = new products_brand();
$products_brand = $class_pb->retrieveDetail($pdata['p']['products_brand_id']);
$result = array();
$result['languages_id'] = $languages_id;
$result['keywords'] = $keywords;
$result['autokw-amvd'] = addAutoKeywords($keywords, 188, $name, $products_colors);
$result['autokw-otde'] = otdeAutoKeywords($name, strtoupper($products_brand['brand_name']), $class_pm->retrieveCategoryName($pdata['categories_id'], '2'));
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == "SAVECOLORS") {
$color_pattern_id = $_POST['colors'] == '' ? array() : explode(',', $_POST['colors']);
$class_pm->setColorPattern($products_id, $color_pattern_id);
$q = tep_db_query("SELECT jng_sp_catalog_id, jng_sp_id FROM jng_sp_catalog WHERE products_id={$products_id}");
$sp_list = array();
while ($row = tep_db_fetch_array($q)) {
$sp_list[$row['jng_sp_catalog_id']] = $row['jng_sp_id'];
}
foreach ($sp_list as $catalog_id => $jng_sp_id) {
$sp_params_raw = $class_jcp->load($jng_sp_id, 'C');
$sp_params = array();
foreach ($sp_params_raw as $spr) {
if (in_array($spr['param_id'], $color_pattern_id)) {
