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); }
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); }