source: branches/dev/html/frontparts/bloc/category.php @ 17

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
class LC_CatPage {
    function LC_CatPage() {
        /** ɬ¤ºÊѹ¹¤¹¤ë **/
        $this->tpl_mainpage = BLOC_PATH . 'category.tpl';   // ¥á¥¤¥ó
    }
}

$objSubPage = new LC_CatPage();
$objSubView = new SC_SiteView();

// ÁªÂòÃæ¤Î¥«¥Æ¥´¥êID¤òȽÄꤹ¤ë
$category_id = sfGetCategoryId($_GET['product_id'], $_GET['category_id']);

// ÁªÂòÃæ¤Î¥«¥Æ¥´¥êID
$objSubPage->tpl_category_id = $category_id;
$objSubPage = lfGetCatTree($category_id, true, $objSubPage);

$objSubView->assignobj($objSubPage);
$objSubView->display($objSubPage->tpl_mainpage);
//-----------------------------------------------------------------------------------------------------------------------------------
// ¥«¥Æ¥´¥ê¥Ä¥ê¡¼¤Î¼èÆÀ
function lfGetCatTree($parent_category_id, $count_check = false, $objSubPage) {
    $objQuery = new SC_Query();
    $col = "*";
    $from = "dtb_category left join dtb_category_total_count using (category_id)";
    // ÅÐÏ¿¾¦ÉÊ¿ô¤Î¥Á¥§¥Ã¥¯
    if($count_check) {
        $where = "del_flg = 0 AND product_count > 0";
    } else {
        $where = "del_flg = 0";
    }
    $objQuery->setoption("ORDER BY rank DESC");
    $arrRet = $objQuery->select($col, $from, $where);
    
    $arrParentID = sfGetParents($objQuery, 'dtb_category', 'parent_category_id', 'category_id', $parent_category_id);
    $arrBrothersID = sfGetBrothersArray($arrRet, 'parent_category_id', 'category_id', $arrParentID);
    $arrChildrenID = sfGetUnderChildrenArray($arrRet, 'parent_category_id', 'category_id', $parent_category_id);
    
    $objSubPage->root_parent_id = $arrParentID[0];
    
    $arrDispID = array_merge($arrBrothersID, $arrChildrenID);
    
    foreach($arrRet as $key => $array) {
        foreach($arrDispID as $val) {
            if($array['category_id'] == $val) {
                $arrRet[$key]['display'] = 1;
                break;
            }
        }
    }
    
    $objSubPage->arrTree = $arrRet;
    return $objSubPage;
}
?>