PHP zen_get_categories_name函数代码示例

function rss_feed_title($feed = false)
{
    global $current_category_id;
    if (!$feed) {
        $feed = $_GET['feed'];
    } else {
        if (($i = strpos($feed, '&')) !== false) {
            $feed_args = substr($feed, $i + 1);
            $feed = substr($feed, 0, $i);
        }
    }
    switch (true) {
        case $feed == 'news':
            $title = TEXT_RSS_NEWS;
            break;
        case $feed == 'categories':
            $title = TEXT_RSS_CATEGORIES;
            if (isset($_GET['cPath']) && $current_category_id > 0) {
                $title .= RSS_TITLE_DELIMITER2 . strip_tags(zen_get_categories_name((int) $current_category_id));
            }
            break;
        case $feed == 'specials_random':
        case $feed == 'specials':
            $title = TEXT_RSS_SPECIALS;
            break;
        case $feed == 'featured_random':
        case $feed == 'featured':
            $title = TEXT_RSS_FEATURED_PRODUCTS;
            break;
        case $feed == 'best_sellers_random':
        case $feed == 'best_sellers':
            $title = TEXT_RSS_BEST_SELLERS;
            break;
        case $feed == 'upcoming_random':
        case $feed == 'upcoming':
            $title = TEXT_RSS_UPCOMING_PRODUCTS;
            break;
        case $feed == 'new_products_random':
        case $feed == 'new_products':
            $title = TEXT_RSS_PRODUCTS_NEW;
            break;
        case $feed == 'products':
            if (isset($_GET['products_id'])) {
                $title = TEXT_RSS_PRODUCT . RSS_TITLE_DELIMITER2 . strip_tags(zen_get_products_name((int) $_GET['products_id']));
            } elseif (isset($_GET['cPath']) && $current_category_id > 0) {
                $title = TEXT_RSS_PRODUCTS . RSS_TITLE_DELIMITER2 . strip_tags(zen_get_categories_name((int) $current_category_id));
            } else {
                $title = TEXT_RSS_PRODUCTS_ALL;
            }
            break;
        default:
            $title = TEXT_RSS_FEED;
            break;
    }
    return $title;
}

$num_products_count = $new_products_query == '' ? 0 : $new_products->RecordCount();
// show only when 1 or more
if ($num_products_count > 0) {
    if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS == 0) {
        $col_width = floor(100 / $num_products_count);
    } else {
        $col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS);
    }
    while (!$new_products->EOF) {
        $products_price = zen_get_products_display_price($new_products->fields['products_id']);
        if (!isset($productsInCategory[$new_products->fields['products_id']])) {
            $productsInCategory[$new_products->fields['products_id']] = zen_get_generated_category_path_rev($new_products->fields['master_categories_id']);
        }
        $list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsNew centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"', 'text' => (($new_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $new_products->fields['products_image'], $new_products->fields['products_name'], IMAGE_PRODUCT_NEW_WIDTH, IMAGE_PRODUCT_NEW_HEIGHT) . '</a><br />') . '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']) . '">' . $new_products->fields['products_name'] . '</a><br />' . $products_price);
        $col++;
        if ($col > SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS - 1) {
            $col = 0;
            $row++;
        }
        $new_products->MoveNextRandom();
    }
    if ($new_products->RecordCount() > 0) {
        if (isset($new_products_category_id) && $new_products_category_id != 0) {
            $category_title = zen_get_categories_name((int) $new_products_category_id);
            $title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . ($category_title != '' ? ' - ' . $category_title : '') . '</h2>';
        } else {
            $title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . '</h2>';
        }
        $zc_show_new_products = true;
    }
}

//      if ((zen_get_categories_image(zen_get_products_category_id((int)$_GET['products_id']))) !='') {
switch (true) {
    case $module_show_categories == '1':
        $align = 'left';
        break;
    case $module_show_categories == '2':
        $align = 'center';
        break;
    case $module_show_categories == '3':
        $align = 'right';
        break;
}
//echo 'I SEE ' . $cPath . ' vs ' . $current_category_id;
//$category_icon_display_name = zen_get_categories_name(zen_get_products_category_id((int)$_GET['products_id']), $_SESSION['languages_id']);
//$category_icon_display_image = zen_get_categories_image(zen_get_products_category_id((int)$_GET['products_id']));
$category_icon_display_name = zen_get_categories_name((int) $current_category_id);
$category_icon_display_image = zen_get_categories_image((int) $current_category_id);
switch (true) {
    // name only
    case PRODUCT_INFO_CATEGORIES_IMAGE_STATUS == 1:
        $category_icon_display_image = '';
        break;
        // name and image but name only when blank
    // name and image but name only when blank
    case PRODUCT_INFO_CATEGORIES_IMAGE_STATUS == 2 && $category_icon_display_image == '':
        $category_icon_display_image = '';
        break;
    default:
        // name and image always display image regardless
        $category_icon_display_image = zen_image(DIR_WS_IMAGES . $category_icon_display_image, $category_icon_display_name, CATEGORY_ICON_IMAGE_WIDTH, CATEGORY_ICON_IMAGE_HEIGHT) . '<br />';
        break;

<?php

/**
 * Module Template
 *
 * @package templateSystem
 * @copyright Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: tpl_modules_category_icon_display.php 2747 2005-12-31 06:05:37Z ajeh $
 */
require DIR_WS_MODULES . zen_get_module_directory(FILENAME_CATEGORY_ICON_DISPLAY);
?>

<div align="<?php 
echo $align;
?>
" id="categoryIcon" class="categoryIcon"><?php 
echo '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new, 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . zen_get_categories_image(zen_get_products_category_id((int) $_GET['products_id'])), zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']), CATEGORY_ICON_IMAGE_WIDTH, CATEGORY_ICON_IMAGE_HEIGHT) . '<br />' . zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']) . '</a>';
?>
</div>

 function block_xsell_products()
 {
     global $db;
     $return = array();
     $products = array();
     $title = '';
     $query = "\r\n        select distinct\r\n          p.products_id, p.products_image,\r\n          pd.products_name,\r\n          pt.type_handler,\r\n          mf.manufacturers_name\r\n        from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p\r\n          LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON p.products_type = pt.type_id\r\n          LEFT JOIN " . TABLE_MANUFACTURERS . " mf ON p.manufacturers_id = mf.manufacturers_id\r\n          ," . TABLE_PRODUCTS_DESCRIPTION . " pd\r\n        where xp.products_id = '" . (int) $_GET['products_id'] . "'\r\n          and xp.xsell_id = p.products_id\r\n          and p.products_id = pd.products_id\r\n          and pd.language_id = '" . $_SESSION['languages_id'] . "'\r\n          and p.products_status = 1\r\n        order by xp.sort_order asc limit " . (int) MODULE_CAROUSEL_UI_MAX_DISPLAY_XSELL_PRODUCTS;
     $result = $db->Execute($query);
     while (!$result->EOF) {
         $id = $result->fields['products_id'];
         $name = $result->fields['products_name'];
         $image = $result->fields['products_image'];
         $manufacturers = $result->fields['manufacturers_name'];
         if ($result->fields['type_handler'] == '') {
             $type_handler = 'product_info';
         } else {
             $type_handler = $result->fields['type_handler'] . '_info';
         }
         $link = zen_href_link($type_handler, 'products_id=' . $id);
         $price = zen_get_products_display_price($id);
         $products[] = array('id' => $id, 'name' => $name, 'image' => $image, 'link' => $link, 'price' => $price, 'manufacturers' => $manufacturers);
         $result->MoveNext();
     }
     if (count($products) > 0) {
         // 表示件数の倍になるようにする
         $visibleCount = (int) MODULE_CAROUSEL_UI_CONF_VISIBLE_XSELL_PRODUCTS;
         if ($visibleCount == 0) {
             $visibleCount = 1;
         }
         $addCount = count($products) % $visibleCount;
         if ($addCount > 0) {
             $addCount = $visibleCount - $addCount;
         }
         for ($i = 0; $i < $addCount; $i++) {
             $products[] = array('id' => 0, 'name' => '', 'image' => '', 'link' => '', 'price' => '', 'manufacturers' => '');
         }
         if (isset($parent_id) && $parent_id != 0) {
             $category_title = zen_get_categories_name((int) $parent_id);
             $title = sprintf(MODULE_CAROUSEL_UI_BLOCK_XSELL_PRODUCTS_TITLE, strftime('%B')) . ($category_title != '' ? ' - ' . $category_title : '');
         } else {
             $title = sprintf(MODULE_CAROUSEL_UI_BLOCK_XSELL_PRODUCTS_TITLE, strftime('%B'));
         }
         $return['title'] = $title;
         $return['products'] = $products;
         $return['ui_conf'] = array('auto' => (int) MODULE_CAROUSEL_UI_CONF_AUTO_XSELL_PRODUCTS, 'speed' => (int) MODULE_CAROUSEL_UI_CONF_SPEED_XSELL_PRODUCTS, 'vertical' => MODULE_CAROUSEL_UI_CONF_VERTICAL_XSELL_PRODUCTS == 'true' ? 'true' : 'false', 'circular' => MODULE_CAROUSEL_UI_CONF_CIRCULAR_XSELL_PRODUCTS == 'true' ? 'true' : 'false', 'visible' => (int) MODULE_CAROUSEL_UI_CONF_VISIBLE_XSELL_PRODUCTS, 'scroll' => (int) MODULE_CAROUSEL_UI_CONF_SCROLL_XSELL_PRODUCTS);
     }
     if ((int) MODULE_CAROUSEL_UI_CONF_VISIBLE_XSELL_PRODUCTS < count($products)) {
         $return['prevbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_PREVIOUS, BUTTON_CAROUSEL_UI_PREVIOUS_ALT, 'class="imgover"');
         $return['nextbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_NEXT, BUTTON_CAROUSEL_UI_NEXT_ALT, 'class="imgover"');
     } else {
         $return['prevbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_PREVIOUS_DISABLED, BUTTON_CAROUSEL_UI_DISABLED_ALT, '');
         $return['nextbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_NEXT_DISABLED, BUTTON_CAROUSEL_UI_DISABLED_ALT, '');
     }
     return $return;
 }

if ($num_products_count > 0) {
    $title = '';
    if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS == 0) {
        $col_width = floor(100 / $num_products_count);
    } else {
        $col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS);
    }
    while (!$new_products->EOF) {
        $the_categories_name_query = "select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id= '" . $new_products->fields['master_categories_id'] . "' and language_id= '" . $_SESSION['languages_id'] . "'";
        $the_categories_name = $db->Execute($the_categories_name_query, null, true, CACHE_TIMELIFT);
        $tpl_products['products'][$new_products->fields['products_id']] = array('id' => $new_products->fields['products_id'], 'name' => zen_get_products_name($new_products->fields['products_id']), 'href' => zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']), 'display_price' => zen_get_products_display_price($new_products->fields['products_id']), 'image' => $new_products->fields['products_image'] == '' && PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0 ? '' : $new_products->fields['products_image'], 'tax_class_id' => $new_products->fields['products_tax_class_id'], 'date_added' => $new_products->fields['products_date_added'], 'type' => $new_products->fields['products_type'], 'categories_id' => $new_products->fields['master_categories_id'], 'categories_name' => $the_categories_name->fields['categories_name'], 'categories_href' => zen_href_link(FILENAME_DEFAULT, 'cPath=' . $new_products->fields['master_categories_id']), 'is_call' => $new_products->fields['product_is_call'] ? true : false, 'is_free' => $new_products->fields['product_is_free'] == '1' ? true : false, 'display_normal_price' => get_normal_price($new_products->fields['products_id']), 'display_special_price' => get_special_price($new_products->fields['products_id']), 'display_sale_price' => get_sale_discount_price($new_products->fields['products_id']), 'content' => $new_products->fields['products_description']);
        $new_products->MoveNext();
    }
    if (!empty($show_select_product_id)) {
        //sort
        $show_select_product_id = explode(',', $show_select_product_id);
        $tpl_tmp_product = $tpl_products['products'];
        $tpl_products['products'] = array();
        foreach ($show_select_product_id as $tmp_id) {
            $tpl_products['products'][$tmp_id] = $tpl_tmp_product[$tmp_id];
        }
        unset($tpl_tmp_product, $tmp_id);
    }
    if ($new_products->RecordCount() > 0) {
        if (isset($new_products_category_id) && $new_products_category_id != 0) {
            $tpl_products['title'] = zen_get_categories_name((int) $new_products_category_id);
        } else {
        }
        $zc_show_new_products = true;
    }
}

// display order dropdown
$disp_order_default = PRODUCT_NEW_LIST_SORT_DEFAULT;
require DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER);
//var $order_by
$products_new_array = array();
// display limits
//  $display_limit = zen_get_products_new_timelimit();
//#################category filter###################
$products_new_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price,\n\t\t\t\t\t\t\t\t\t\tp.products_tax_class_id, p.products_date_added, p.products_model,\n\t\t\t\t\t\t\t\t\t\tp.products_quantity, p.products_weight, p.product_is_call,\n\t\t\t\t\t\t\t\t\t\tp.product_is_always_free_shipping, p.products_qty_box_status,\n\t\t\t\t\t\t\t\t\t\tp.master_categories_id\n\t\t\t\t\t\t\t\t FROM " . TABLE_PRODUCTS . " p\n\t\t\t\t\t\t\t\t LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n\t\t\t\t\t\t\t\t ON (p.products_id = p2c.products_id ), " . TABLE_PRODUCTS_DESCRIPTION . " pd\n\t\t\t\t\t\t\t\t WHERE p.products_status = 1\n\t\t\t\t\t\t\t\t AND   p.products_id = pd.products_id \n\t\t\t\t\t\t\t\t AND   p.master_categories_id=p2c.categories_id \n\t\t\t\t\t\t\t\t  :category_fitler_str  \t\t\t\t\t\t \n\t\t\t\t\t\t\t\t AND   pd.language_id = :languageID order by rand() limit 5";
$products_new_query_raw = $db->bindVars($products_new_query_raw, ':languageID', $_SESSION['languages_id'], 'integer');
$recommend_products_result = array();
$recommend_products_cat_name = array();
foreach ($recommend_new_products_listing_filtered_categories as $parent_cat_id) {
    $allowed_cate_sql = 'select distinct categories_id from ' . TABLE_CATEGORIES . '
						  where  categories_status=1 
						  and    parent_id = ' . $parent_cat_id . ' ';
    $allowed_cate_db = $db->Execute($allowed_cate_sql);
    $allowed_cate_id = array($parent_cat_id);
    while (!$allowed_cate_db->EOF) {
        $allowed_cate_id[] = $allowed_cate_db->fields['categories_id'];
        $allowed_cate_db->MoveNext();
    }
    $category_fitler_str = ' and p.master_categories_id in(' . implode(',', $allowed_cate_id) . ') ';
    $sql = str_replace(':category_fitler_str', $category_fitler_str, $products_new_query_raw);
    if ($_GET['test']) {
        //echo $sql.'<br><br><br>';
    }
    $check_products_all = $db->Execute($sql);
    $recommend_products_result[] = $check_products_all;
    $recommend_products_cat_name[] = array('cat_name' => zen_get_categories_name($parent_cat_id), 'link' => zen_href_link(FILENAME_DEFAULT, '&cPath=' . $parent_cat_id));
}

                case $module_show_categories == '3':
                    $align = 'right';
                    break;
            }
            if ($module_next_previous != '3') {
                ?>
  <tr>
    <td colspan="3" align="<?php 
                echo $align;
                ?>
">
      <?php 
                echo '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new, 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . zen_get_categories_image(zen_get_products_category_id((int) $_GET['products_id'])), zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']), HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT, ' align="middle"') . '</a>';
                ?>
      <?php 
                echo '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new, 'NONSSL') . '">' . zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']) . '</a>';
                ?>
    </td>
  </tr>
<?php 
            }
            // don't show when top and bottom
        }
    }
    ?>
  <tr>
    <td align="center" class="smallText" colspan="3"><?php 
    echo PREV_NEXT_PRODUCT;
    echo $position + 1 . "/" . $counter;
    ?>
</td>

        if (!$this_is_home_page && $categories_displayTypes == 1) {
            if (zen_has_category_subcategories($current_category_id)) {
                $topSelling_subcategories = array();
                zen_get_subcategories($topSelling_subcategories, $current_category_id);
                $topSelling_subcategories_str = implode(' or pt.categories_id = ', $topSelling_subcategories);
                $suffix_sql = ' AND ( pt.categories_id =' . $topSelling_subcategories_str . ')';
            } else {
                $suffix_sql = ' AND pt.categories_id = \'' . $current_category_id . '\'';
            }
            $topSellingQuery = "SELECT p.`products_id`,p.`products_image`, pd.`products_name` \n                      FROM products p, products_description pd,products_to_categories pt\n                      WHERE pd.`language_id` = {$_SESSION['languages_id']} AND p.`products_status` = 1 AND pt.products_id=p.products_id AND pd.products_id=p.products_id " . $suffix_sql . "\n                      ORDER BY p.`products_ordered` DESC LIMIT 5";
            $topSelling = $db->Execute($topSellingQuery);
            if ($topSelling->RecordCount() > 0) {
                ?>
<div class="allborder pad_10px">
<h2 class="red"><?php 
                echo BASE_COMMON_TEXT_TOPSELLINGIN . zen_get_categories_name($current_category_id);
                ?>
</h2>
<ul class="top_selling">
<?php 
                while (!$topSelling->EOF) {
                    ?>
    <li>
  <a title="<?php 
                    echo $topSelling->fields['products_name'];
                    ?>
" href="<?php 
                    echo zen_href_link(zen_get_info_page($topSelling->fields['products_id']), 'products_id=' . $topSelling->fields['products_id']);
                    ?>
"><?php 
                    echo zen_image_OLD(DIR_WS_IMAGES . $topSelling->fields['products_image'], $topSelling->fields['products_name'], 42, 42, 'class="fl"');