<?php
/*
 * Copyright © 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
class LC_NewsPage {
	function LC_NewsPage() {
		/** 必ず変更する **/
		$this->tpl_mainpage = ROOT_DIR . BLOC_DIR.'news.tpl';	// メイン
	}
}

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

//新着情報取得
$objSubPage->arrNews = lfGetNews();

$objSubView->assignobj($objSubPage);
$objSubView->display($objSubPage->tpl_mainpage);
//-----------------------------------------------------------------------------------------------------------------------------------
function lfGetNews(){
	$conn = new SC_DBConn();
	$sql = "SELECT *, cast(substring(news_date,1,10) as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
	$list_data = $conn->getAll($sql);
	return $list_data;	
}
?>