$culmn,'order' => $order);
$limit = array(
'offset' => 0,
'limit' => 4
);
$y = date('Y');
$m = date('m');
$dates = '';
$topics = '';
$new_topics = '';
$icon = '';
if($_SERVER['REQUEST_METHOD'] == 'GET')
{
if(isset($_GET['seq']))
{
$no = $_GET['seq'];
array_push($where,"no=$no");
}
if(isset($_GET['y']))
{
$months = sprintf('%04d-%02d',$_GET['y'],$_GET['m']);
$where = array(
"publish=1",
"updtime>='".$GLOBALS['SQLOUS'] -> escape($months.'-1 00:00:00')."'",
"updtime<='".$GLOBALS['SQLOUS'] -> escape($months.'-31 23:59:59')."'"
);
}
}
if($GLOBALS['SQLOUS'] -> chktables($db))
{
$GLOBALS['SQLOUS'] -> select($db,$where,true,$orders,$limit);
if($GLOBALS['SQLOUS'] -> getRow() > 0)
{
while($row = $GLOBALS['SQLOUS'] -> fetch())
{
//日付
$dates = explode('-',date('Y-m-d',strtotime($row['updtime'])));
//詳細
$content = $maglous -> html_entity_decode($row['content']);
$topics .= '
'.$row['title'].'
'.$dates[0].'年'.$dates[1].'月'.$dates[2].'日
'.$content.'
';
}
}
else
{
$topics = '';
}
}
//一覧(アーカイブス)
$archives = array();
$latestdate = $GLOBALS['SQLOUS'] -> max($db,'updtime');
$latestdate == 1 ? date('Y-m-d'):$latestdate;
list($latestyear,$latestmonth) = explode('-',substr($latestdate,0,10));
$latestmonth = intval($latestmonth);
$j = 0;
for($i = $latestmonth;$i > $latestmonth-6;$i--)
{
$archivemonth = $i;
$archiveyear = $latestyear;
if($archivemonth < 1)
{
$archivemonth = $archivemonth+12;
$archiveyear = $latestyear-1;
}
$months = sprintf('%04d-%02d',$archiveyear,$archivemonth);
$where = array(
"publish='".$GLOBALS['SQLOUS'] -> escape(1)."'",
"updtime>='".$GLOBALS['SQLOUS'] -> escape($months.'-1 00:00:00')."'",
"updtime<='".$GLOBALS['SQLOUS'] -> escape($months.'-31 23:59:59')."'"
);
$GLOBALS['SQLOUS'] -> select($db,$where,true,$orders);
//件数
$cnt = $GLOBALS['SQLOUS'] -> getRow();
if($j ==0)
{
$res = ''.sprintf('%04d月%02d年',$archiveyear,$archivemonth).'('.$cnt.')';
}
else
{
$res = ''.sprintf('%04d月%02d年',$archiveyear,$archivemonth).'('.$cnt.')';
}
$now = $y.'-'.$m;
if($now == $months)
{
$archives_now = $res;
}
array_push($archives,$res);
$j += 1;
}
if(count($archives) > 0)
{
array_unshift($archives,'');
}
$archives = join('',$archives);
/*
//最新のニュース
$month = sprintf('%04d-%02d',$y,$m);
$where = array(
"publish='".$GLOBALS['SQLOUS'] -> escape(1)."'",
"updtime>='".$GLOBALS['SQLOUS'] -> escape($month.'-1 00:00:00')."'",
"updtime<='".$GLOBALS['SQLOUS'] -> escape($month.'-31 23:59:59')."'",
);
$limit = array(
'offset' => 0,
'limit' => 2
);
if($GLOBALS['SQLOUS'] -> chktables($db))
{
$GLOBALS['SQLOUS'] -> select($db,$where,true,$orders,$limit);
if($GLOBALS['SQLOUS'] -> getrow() > 0)
{
while($row = $GLOBALS['SQLOUS'] -> fetch())
{
$row['title'] = mb_strlen($row['title']) > 12 ? mb_substr($row['title'],0,12).'...':$row['title'];
$new_topics .= ''.$row['title'].'';
}
}
}
*/
?>
新着情報|青洲会グループ
長崎県・福岡県・熊本県を中心に地域の医療・福祉・介護の中核を担う 青洲会グループ

