Esempio n. 1
0
function fn_exim_get_product_feature_categories($data, $lang_code, $category_delimiter)
{
    $categories = '';
    if (empty($data['Group']) && !empty($data['Categories'])) {
        $set_delimiter = ', ';
        $categories = explode(',', $data['Categories']);
        foreach ($categories as $category_id) {
            $result[] = fn_get_category_path($category_id, $lang_code, $category_delimiter);
        }
        $categories = implode($set_delimiter, $result);
    }
    return $categories;
}
/**
 * Export product categories
 *
 * @param int $product_id product ID
 * @param string $link_type M - main category, A - additional
 * @param string $category_delimiter path delimiter
 * @param string $lang_code 2 letters language code
 * @return string
 */
function fn_exim_get_product_categories($product_id, $link_type, $category_delimiter, $lang_code = '')
{
    $set_delimiter = '; ';
    $conditions = '';
    if (fn_allowed_for('ULTIMATE')) {
        $store_delimiter = ':';
        $conditions = fn_get_company_condition('?:categories.company_id');
    }
    $joins = ' JOIN ?:categories ON ?:categories.category_id = ?:products_categories.category_id ';
    $category_ids = db_get_fields("SELECT ?:products_categories.category_id FROM ?:products_categories {$joins} WHERE product_id = ?i AND link_type = ?s {$conditions}", $product_id, $link_type);
    $result = array();
    foreach ($category_ids as $c_id) {
        if (fn_allowed_for('ULTIMATE')) {
            if ($link_type == 'A' && !Registry::get('runtime.company_id')) {
                $company_id = fn_get_company_id('categories', 'category_id', $c_id);
                $company_name = fn_get_company_name($company_id);
                $result[] = $company_name . $store_delimiter . fn_get_category_path($c_id, $lang_code, $category_delimiter);
            } else {
                $result[] = fn_get_category_path($c_id, $lang_code, $category_delimiter);
            }
        }
        if (!fn_allowed_for('ULTIMATE')) {
            $result[] = fn_get_category_path($c_id, $lang_code, $category_delimiter);
        }
    }
    return implode($set_delimiter, $result);
}
Esempio n. 3
0
 function fn_exim_get_product_categories($product_id, $link_type, $category_delimiter, $lang_code = '')
 {
     $set_delimiter = '; ';
     $category_ids = db_get_fields("SELECT category_id FROM ?:products_categories WHERE product_id = ?i AND link_type = ?s", $product_id, $link_type);
     $result = array();
     foreach ($category_ids as $c_id) {
         $result[] = fn_get_category_path($c_id, $lang_code, $category_delimiter);
     }
     return implode($set_delimiter, $result);
 }