require("include/common.ini");
$youbi_array = array('日','月','火','水','木','金','土');
$n_list = '';
$sql = "SELECT * FROM news WHERE sflg = '1' AND s_ymd <= '".date("YmdHi")."' AND e_ymd >= '".date("YmdHi")."' ORDER BY ymd DESC,ut DESC LIMIT 0,3";
$nresult = $mysqli->query($sql);
while($ncustomer = $nresult->fetch()){
$n_no = $ncustomer['no'];
$n_ymd = $ncustomer['ymd'];
$n_name = $ncustomer['name'];
$n_link = $ncustomer['link'];
$n_det = $ncustomer['det'];
$n_cate = $ncustomer['cate'];
$n_det = $ncustomer['det'];
switch($n_link){
case 'det':
$n_link = 'topics_detail.php?no='.$n_no;
break;
case 'link':
$n_link = $n_det.'" target="_blank';
break;
case 'file':
$n_link = _HREF_MAS.$n_det.'" target="_blank';
break;
default:
}
$youbi = date("w",strtotime($n_ymd));
$n_ymd = date("Y.m.d",strtotime($n_ymd)).'('.$youbi_array[$youbi].')';
$n_list .= '
| TOPICS |
'.$n_ymd.' |
'.$n_name.' |
';
}
if(!$n_list) $n_list = '| ※現在掲載中のお知らせはありません。 |
';
$a_list = '';
$sql = "SELECT
no,
ymd,
name,
link,
det,
cate,
det,
ut
FROM
jirei
WHERE
sflg = '1'
AND s_ymd <= '".date("YmdHi")."'
AND e_ymd >= '".date("YmdHi")."'
UNION ALL
SELECT
no,
ymd,
name,
link,
det,
cate,
det,
ut
FROM
nendo
WHERE
sflg = '1'
AND s_ymd <= '".date("YmdHi")."'
AND e_ymd >= '".date("YmdHi")."'
ORDER BY
ymd DESC,
ut DESC
LIMIT
0,3
";
$aresult = $mysqli->query($sql);
while($acustomer = $aresult->fetch()){
$a_no = $acustomer['no'];
$a_ymd = $acustomer['ymd'];
$a_name = $acustomer['name'];
$a_link = $acustomer['link'];
$a_det = $acustomer['det'];
$a_cate = $acustomer['cate'];
$a_det = $acustomer['det'];
switch($a_link){
case 'det':
$a_link = 'archive_detail.php?no='.$a_no;
break;
case 'link':
$a_link = $a_det.'" target="_blank';
break;
case 'file':
$a_link = _HREF_MAS.$a_det.'" target="_blank';
break;
default:
}
$youbi = date("w",strtotime($a_ymd));
$a_ymd = date("Y.m.d",strtotime($a_ymd)).'('.$youbi_array[$youbi].')';
$a_list .= '
| 活動報告 |
'.$a_ymd.' |
'.$a_name.' |
';
}
if(!$a_list) $a_list = '| ※現在掲載中の活動報告はありません。 |
';
$html_str = HTML_IMPUT('index_tmp.html');
$html_str = str_replace('_TIME_STUMP', time(), $html_str);
$html_str = str_replace('', $n_list, $html_str);
$html_str = str_replace('', $a_list, $html_str);
print($html_str);
?>