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

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

$objSubPage = new LC_Best5Page();
$objSubView = new SC_SiteView();
$objSiteInfo = $objView->objSiteInfo;

// ´ðËܾðÊó¤òÅϤ¹
$objSiteInfo = new SC_SiteInfo();
$objSubPage->arrInfo = $objSiteInfo->data;

//¤ª¤¹¤¹¤á¾¦ÉÊɽ¼¨
$objSubPage->arrBestProducts = lfGetRanking();

$objSubView->assignobj($objSubPage);
$objSubView->display($objSubPage->tpl_mainpage);
//-----------------------------------------------------------------------------------------------------------------------------------
//¤ª¤¹¤¹¤á¾¦Éʸ¡º÷
function lfGetRanking(){
    $objQuery = new SC_Query();
    
    $col = "A.*, name, price02_min, price01_min, main_list_image ";
    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS allcls using(product_id)";
    $where = "status = 1";
    $order = "rank";
    $objQuery->setorder($order);
    
    $arrBestProducts = $objQuery->select($col, $from, $where);
        
    return $arrBestProducts;
}

?>