<?php
require_once('sitemanage/common.php');
//require_once('Model/Thumbnail.php');

define('RECENT_COUNT', 5);
define('NOIMG_PATH', '/assets/images/noimg.jpg');
$db = new Model_DB();
$common = new Common($db, $smarty);
//$thumbnail = new Model_Thumbnail();
$column = array();
$news = array();
///////////////////////////////////////////////////////////////////////////////////////////////////
//sql
$w_status = " WHERE status_pub = 1 ";
$table = " M_NEWS_WORK ";
$st_ed = " AND (st_time <= '" . $common->getDate() . "' OR st_time IS NULL)" . ' AND' . " ( ed_time >= '" . $common->getDate() . "' OR ed_time IS NULL) ";
$full_code = $_GET["cate"];
//新着のニュースのみ
$sql = "SELECT full_code FROM M_CATEGORY WHERE level = 2";
$db->query($sql);
while( $row = $db->fetch() ){
	$codeid[] = $row['full_code'];
}
$codeid = implode(',', (array)$codeid);
///////////////////////////////////////////////////////////////////////////////////////////////////
//最近の活動報告
$sql = "SELECT id,date,title FROM " . $table . $w_status . $st_ed . " AND category IN (" . $codeid . ") ORDER BY date DESC, u_date DESC limit " . RECENT_COUNT;
$db->query($sql);
while( $row = $db->fetch() ){
	$news[] = $row;
}

///////////////////////////////////////////////////////////////////////////////////////////////////
//コラム
$sql = "SELECT full_code FROM M_CATEGORY WHERE name = 'サポーターコラム'";
$catcode = $db->fetchResult($sql);
$sql = "SELECT id,date,owner,title FROM " . $table . $w_status . $st_ed . " AND category = " . $catcode['full_code'] . " ORDER BY date DESC, u_date DESC limit " . RECENT_COUNT;
$db->query($sql);
while( $row = $db->fetch() ){
	$column[] = $row;
}
//投稿者の取得
foreach ($column as $k => $v) {
	$sql = "SELECT name FROM M_PROVIDER WHERE staff = " . $v['owner'];
	$name = $db->fetchResult($sql);
	$column[$k]['name'] = $name['name'];
}

///////////////////////////////////////////////////////////////////////////////////////////////////
//set
$smarty->assign('column', $column);
$smarty->assign('news', $news);
$smarty->display('index.html');
?>