ÈËÉú¾ÍÊDz©¡¤(Öйú)×ðÁúAGÆì½¢Ìü

ÈËÉú¾ÍÊDz©¡¤(Öйú)×ðÁúAGÆì½¢Ìü(LianLian Global)¹ÙÍøÊ×Ò³

Zen CartÊ×ҳнø²úƷչʾ

²úƷչʾZenCart²úÆ·
2024/06/12
×ÔÁ¦Õ¾ÊÕµ¥

Zen CartÊÇÒ»¿îǿʢµÄ¿ªÔ´¹ºÎï³µÈí¼þ£¬£¬£¬£¬£¬£¬ÆäÊ×ҳĬÈÏÇéÐÎÏ»áËæ»ú»ñÈ¡ËùÓÐ×î½üÌí¼ÓµÄ²úÆ·¾ÙÐÐչʾ¡£¡£¡£¡£¡£È»¶ø£¬£¬£¬£¬£¬£¬ÓÐʱϣÍûÔÚÊ×Ò³Ö»Õ¹Ê¾ÌØ¶¨·ÖÀàϵÄнø²úÆ·£¬£¬£¬£¬£¬£¬ÕâÑù¿ÉÒÔ¸üºÃµØÖ¸µ¼Óû§ä¯ÀÀ¸ÐÐËȤµÄÉÌÆ·¡£¡£¡£¡£¡£ÔÚ±¾ÎÄÖУ¬£¬£¬£¬£¬£¬½«·ÖÏíÔõÑùͨ¹ýÐÞ¸ÄZen CartÄ£°åÖеĴúÂëʵÏÖ¸öÐÔ»¯¶¨ÖÆÊ×ҳнø²úÆ·µÄչʾ·½·¨£¬£¬£¬£¬£¬£¬´Ó¶øÌá¸ßÓû§ÌåÑéºÍ¹ºÎïЧ¹û¡£¡£¡£¡£¡£

µÚÒ»²½£º·­¿ªincludes/modules/new_products.phpÎļþ¡£¡£¡£¡£¡£

Ê×ÏÈ£¬£¬£¬£¬£¬£¬ÐèÒª·­¿ªincludes/modules/new_products.phpÕâ¸öÄ£¿£¿£¿£¿ £¿£¿éÎļþ£¬£¬£¬£¬£¬£¬¸ÃÎļþÈÏÕæÔÚÊ×ҳչʾнø²úÆ·µÄ¹¦Ð§¡£¡£¡£¡£¡£½«Í¨¹ýÐÞ¸ÄÕâ¸öÎļþµÄ´úÂëÀ´ÊµÏÖ¸öÐÔ»¯µÄչʾ¡£¡£¡£¡£¡£

µÚ¶þ²½£º¶¨Î»Ð½ø²úÆ·ÅÌÎʵĴúÂë¡£¡£¡£¡£¡£

ÔÚincludes/modules/new_products.phpÎļþÖУ¬£¬£¬£¬£¬£¬ÐèÒªÕÒµ½$new_products_queryÕâ¸ö±äÁ¿£¬£¬£¬£¬£¬£¬Ëü¿ØÖÆÁËÅÌÎÊ×îвúÆ·µÄSQLÓï¾ä¡£¡£¡£¡£¡£¸Ã±äÁ¿¾öÒéÁËÊ×Ò³½«ÏÔʾÄÄЩнø²úÆ·£¬£¬£¬£¬£¬£¬ÐèÒªÔÚÆäÖмÓÈëһЩÌõ¼þÀ´Ö¸¶¨Ö»ÔÚÄ³Ð©ÌØ¶¨·ÖÀàÏÂչʾнø²úÆ·¡£¡£¡£¡£¡£

ÕÒµ½ÒÔÏ´úÂë¶Î£º

php

Copy code

if ( (($manufacturers_id > 0 && $_GET['filter_id'] == 0) || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0) || (!isset($new_products_category_id) || $new_products_category_id == ¡¯0¡ä) ) {

    $new_products_query = ¡°select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,

    p.products_date_added, p.products_price, p.products_type, p.master_categories_id

    from ¡± . TABLE_PRODUCTS . ¡± p, ¡± . TABLE_PRODUCTS_DESCRIPTION . ¡± pd

    where p.products_id = pd.products_id

    and pd.language_id = ¡®¡± . (int)$_SESSION['languages_id'] . ¡°¡®

    and p.products_status = 1 ¡± . $display_limit;

} else {

    // get all products and cPaths in this subcat tree

    $productsInCategory = zen_get_categories_products_list( (($manufacturers_id > 0 && $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath), false, true, 0, $display_limit);

 

    if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {

        // build products-list string to insert into SQL query

        foreach($productsInCategory as $key => $value) {

            $list_of_products .= $key . ¡®, ¡®;

        }

        $list_of_products = substr($list_of_products, 0, -2); // remove trailing comma

 

        $new_products_query = ¡°select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,

        p.products_date_added, p.products_price, p.products_type, p.master_categories_id

        from ¡± . TABLE_PRODUCTS . ¡± p, ¡± . TABLE_PRODUCTS_DESCRIPTION . ¡± pd

        where p.products_id = pd.products_id

        and pd.language_id = ¡®¡± . (int)$_SESSION['languages_id'] . ¡°¡®

        and p.products_status = 1

        and p.products_id in (¡± . $list_of_products . ¡°)¡±;

    }

}

µÚÈý²½£ºÐ޸ĴúÂëʵÏÖ¸öÐÔ»¯¶¨ÖÆ¡£¡£¡£¡£¡£

ΪÁËʵÏÖÖ»ÔÚÌØ¶¨·ÖÀàÏÂչʾнø²úÆ·£¬£¬£¬£¬£¬£¬ÐèÒªÔÚ´úÂëÖмÓÈëÌõ¼þ¡£¡£¡£¡£¡£Ïêϸ°ì·¨ÈçÏ£º

ÔÚ´úÂëÖÐÌí¼ÓеıäÁ¿$filter_cate=¡±;£¬£¬£¬£¬£¬£¬¸Ã±äÁ¿ÓÃÓÚ´æ´¢ÒªÏÔʾµÄÌØ¶¨·ÖÀàID¡£¡£¡£¡£¡£

ÔÚ$filter_cate±äÁ¿ºóÃæÌí¼Ó$cate_IDS=¡±22¡å;µÄ´úÂ룬£¬£¬£¬£¬£¬½«22Ìæ»»ÎªÒªÏÔʾµÄÌØ¶¨·ÖÀàID¡£¡£¡£¡£¡£ÈôÊÇÓжà¸ö·ÖÀ࣬£¬£¬£¬£¬£¬ÇëÓöººÅÍÑÀ룬£¬£¬£¬£¬£¬ÀýÈ磺$cate_IDS=¡±22, 25, 30¡å;¡£¡£¡£¡£¡£

ÔÚifÌõ¼þÅжÏÓï¾äÖУ¬£¬£¬£¬£¬£¬Ìí¼Ó´úÂë¿é£ºif($this_is_home_page){ $filter_cate=¡± and p.master_categories_id in($cate_IDS) ¡°; }¡£¡£¡£¡£¡£Õâ¶Î´úÂ뽫ÔÚÊ×Ò³ÏÔʾнø²úƷʱÉúЧ¡£¡£¡£¡£¡£

×îºó£¬£¬£¬£¬£¬£¬½«$filter_cate±äÁ¿Ìí¼Óµ½$new_products_queryµÄSQLÓï¾äºóÃæ£¬£¬£¬£¬£¬£¬ÒÔʵÏÖÖ»ÔÚÖ¸¶¨·ÖÀàÏÂÏÔʾнø²úÆ·¡£¡£¡£¡£¡£

´úÂëÐ޸ĺóÈçÏ£º

php

Copy code

$filter_cate=¡±;

$cate_IDS=¡±22¡å; // ÒªÏÔʾµÄ·ÖÀàID£¬£¬£¬£¬£¬£¬ÈôÊÇÓи¸·ÖÀ࣬£¬£¬£¬£¬£¬ÇëÊäÈë×Ó·ÖÀàµÄID

if($this_is_home_page){

    $filter_cate=¡± and p.master_categories_id in($cate_IDS) ¡°;

}

if ( (($manufacturers_id > 0 && $_GET['filter_id'] == 0) || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0) || (!isset($new_products_category_id) || $new_products_category_id == ¡¯0¡ä) ) {

    $new_products_query = ¡°select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,

    p.products_date_added, p.products_price, p.products_type, p.master_categories_id

    from ¡± . TABLE_PRODUCTS . ¡± p, ¡± . TABLE_PRODUCTS_DESCRIPTION . ¡± pd

    where p.products_id = pd.products_id

    and pd.language_id = ¡®¡± . (int)$_SESSION['languages_id'] . ¡°¡®

    and p.products_status = 1 ¡± . $display_limit . $filter_cate; ///Ìí¼Óµ½SQLÓï¾äºóÃæ

} else {

    // get all products and cPaths in this subcat tree

    $productsInCategory = zen_get_categories_products_list( (($manufacturers_id > 0 && $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath), false, true, 0, $display_limit);

 

    if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {

        // build products-list string to insert into SQL query

        foreach($productsInCategory as $key => $value) {

            $list_of_products .= $key . ¡®, ¡®;

        }

        $list_of_products = substr($list_of_products, 0, -2); // remove trailing comma

 

        $new_products_query = ¡°select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,

        p.products_date_added, p.products_price, p.products_type, p.master_categories_id

        from ¡± . TABLE_PRODUCTS . ¡± p, ¡± . TABLE_PRODUCTS_DESCRIPTION . ¡± pd

        where p.products_id = pd.products_id

        and pd.language_id = ¡®¡± . (int)$_SESSION['languages_id'] . ¡°¡®

        and p.products_status = 1

        and p.products_id in (¡± . $list_of_products . ¡°)¡± . $filter_cate; ///Ìí¼Óµ½SQLÓï¾äºóÃæ

    }

}

µÚËIJ½£ºÉúÑIJ¢²âÊÔЧ¹û¡£¡£¡£¡£¡£

Íê³ÉÒÔÉÏ´úÂëÐ޸ĺ󣬣¬£¬£¬£¬£¬ÇëÉúÑÄÎļþ²¢ÖØÐ¼ÓÔØÍøÕ¾Ê×Ò³£¬£¬£¬£¬£¬£¬Éó²éÊÇ·ñÀÖ³ÉʵÏÖ¸öÐÔ»¯¶¨ÖÆÊ×ҳнø²úÆ·µÄչʾ¡£¡£¡£¡£¡£È·±£Ìض¨·ÖÀàID׼ȷ£¬£¬£¬£¬£¬£¬ÒÔ¼°Ê×ҳչʾµÄнø²úÆ·ÇкÏÔ¤ÆÚ¡£¡£¡£¡£¡£

½áÓ

ͨ¹ý±¾ÎĵÄÖ¸µ¼£¬£¬£¬£¬£¬£¬ÒѾ­Ñ§»áÁËÔõÑùͨ¹ýÐÞ¸ÄZen CartÄ£°åÖеĴúÂ룬£¬£¬£¬£¬£¬ÊµÏÖ¸öÐÔ»¯¶¨ÖÆÊ×ҳнø²úÆ·µÄչʾ¡£¡£¡£¡£¡£Í¨¹ý½öÔÚÖ¸¶¨·ÖÀàÏÂչʾнø²úÆ·£¬£¬£¬£¬£¬£¬¿ÉÒÔ¸üºÃµØÖ¸µ¼Óû§£¬£¬£¬£¬£¬£¬Ìá¸ßÓû§ÌåÑ飬£¬£¬£¬£¬£¬ÔöÌíÍøÕ¾Á÷Á¿ºÍת»¯ÂÊ¡£¡£¡£¡£¡£Çë¼ÇµÃ±¸·ÝÎļþ²¢×ÐϸºË¶Ô´úÂ룬£¬£¬£¬£¬£¬ÒÔÈ·±£ÐÞ¾À׼ȷÎÞÎ󡣡£¡£¡£¡£Ï£Íû±¾ÎĶԶ¨ÖÆ»¯Zen CartÊ×ҳչʾµÄнø²úÆ·ÓÐËù×ÊÖú£¬£¬£¬£¬£¬£¬ÈÃÍøÕ¾Ô½·¢¸öÐÔ»¯£¬£¬£¬£¬£¬£¬ÎüÒý¸ü¶àµÄÄ¿µÄÊÜÖÚ¡£¡£¡£¡£¡£

¸ü¶à
¡¾ÍøÕ¾µØÍ¼¡¿¡¾sitemap¡¿