/**
     * Page のプロセス.
     *
     * @return void
     */
    function process() {
        if (defined("MOBILE_SITE") && MOBILE_SITE) {
            $objSubView = new SC_SiteView();
        } else {
            $objSubView = new SC_MobileView();
        }	
	
	$objSiteInfo = $objView->objSiteInfo;
	
	// 基本情報を渡す
	$objSiteInfo = new SC_SiteInfo();
	$this->arrInfo = $objSiteInfo->data;
	

        //新着コメント一覧取得
        $this->arrNews = $this->lfGetReview();

        $objSubView->assignobj($this);
        $objSubView->display($this->tpl_mainpage);
		
    }

function lfGetReview(){
	$conn = new SC_DBConn();
	$objQuery = new SC_Query();
		
	$sql = "SELECT *, cast(create_date as date) as review_date_disp FROM dtb_review WHERE del_flg = '0' AND status = '1' ORDER BY create_date DESC LIMIT 5";
	$col = "DISTINCT A.*, name, price02_min, price01_min, main_list_image, main_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);
        $objQuery->setLimit(RECOMMEND_NUM);
		
        $list_data = $conn->getAll($sql);
	$arrNews = $objQuery->select($col, $from, $where);
		
	return $list_data;
	return $arrNews;
    }

<!--{section name=data loop=$arrNews}-->
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90" align="center" valign="top">
<!--{if $arrNews[data].main_list_image != ""}-->
<!--{assign var=image_path value="`$arrNews[data].main_list_image`"}-->
<!--{else}-->
<!--{assign var=image_path value="`$smarty.const.NO_IMAGE_DIR`"}-->
<!--{/if}-->
<a href="<!--{$smarty.const.URL_DIR}-->products/detail.php?product_id=<!--{$arrNews[data].product_id}-->">
<img src="<!--{$smarty.const.SITE_URL}-->resize_image.php?image=<!--{$image_path|sfRmDupSlash}-->&width=70&height=70" alt="<!--{$arrNews[data].name|escape}-->" /><br>
<font size="-2"><!--{$arrNews[data].reviewer_name|escape|nl2br}-->さん</font></a><br><font size="-2">(★<!--{$arrNews[data].recommend_level|escape|nl2br}-->つ)</font>
</td>
<td align="left" valign="top">
<!--{$arrNews[data].review_date_disp|date_format:"%Y/%m/%d"}--><br>
<strong><!--{$arrNews[data].title|escape|nl2br}--></strong>
<hr><br>
<!--{$arrNews[data].comment|escape|nl2br}-->
</td>
</tr>
</table>
<!--{/section}-->

<!--{section name=data loop=$arrNews}-->
  <dl>
    <dt><!--{$arrNews[data].review_date_disp|date_format:"%Y/%m/%d"}--></dt>
    <dd>
      <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php?product_id=<!--{$arrNews[data].product_id}-->">
        <!--{$arrNews[data].title|escape|nl2br}-->
      </a><br />
      by <!--{$arrNews[data].reviewer_name|escape|nl2br}-->さん(★<!--{$arrNews[data].recommend_level|escape|nl2br}-->つ)<br />
      <!--{$arrNews[data].comment|escape|nl2br}-->
     </dd>
  </dl>
<!--{/section}-->

$sql = "SELECT *, cast(create_date as date) as review_date_disp FROM dtb_review WHERE del_flg = '0' AND status = '1' ORDER BY create_date DESC LIMIT 5";