PHP products_minierp::retrieveCategoryName方法代码示例

        $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 .= '&nbsp;';
    }
    $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)) {