source: branches/rel/html/frontparts/bloc/best5.php @ 12157

Revision 12157, 1.1 KB checked in by uehara, 14 years ago (diff)
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7class LC_Best5Page {
8    function LC_Best5Page() {
9        /** ɬ¤ºÊѹ¹¤¹¤ë **/
10        $this->tpl_mainpage = BLOC_PATH . 'best5.tpl';  // ¥á¥¤¥ó
11    }
12}
13
14$objSubPage = new LC_Best5Page();
15$objSubView = new SC_SiteView();
16$objSiteInfo = $objView->objSiteInfo;
17
18// ´ðËܾðÊó¤òÅϤ¹
19$objSiteInfo = new SC_SiteInfo();
20$objSubPage->arrInfo = $objSiteInfo->data;
21
22//¤ª¤¹¤¹¤á¾¦ÉÊɽ¼¨
23$objSubPage->arrBestProducts = lfGetRanking();
24
25$objSubView->assignobj($objSubPage);
26$objSubView->display($objSubPage->tpl_mainpage);
27//-----------------------------------------------------------------------------------------------------------------------------------
28//¤ª¤¹¤¹¤á¾¦Éʸ¡º÷
29function lfGetRanking(){
30    $objQuery = new SC_Query();
31   
32    $col = "A.*, name, price02_min, price01_min, main_list_image ";
33    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS allcls using(product_id)";
34    $where = "status = 1";
35    $order = "rank";
36    $objQuery->setorder($order);
37   
38    $arrBestProducts = $objQuery->select($col, $from, $where);
39       
40    return $arrBestProducts;
41}
42
43?>
Note: See TracBrowser for help on using the repository browser.