//news_list.php
include('../../common/db.php');
include('../../common/conf.php');
include('../../common/constant.php');
include('../../common/functions.php');
$current_year = date('Y');
$view_year = $_POST['view_year'];
$user_type = $_GET['tp'];
$sql = "SELECT n.news_id, n.title, n.contents, n.reg_date, n.category ";
$sql .= "FROM news n ";
$sql .= "WHERE n.active_flag = '1'";
$sql .= "ORDER BY n.reg_date DESC ";
$sql_x = $sql;
$sql_x .= "LIMIT 0, 10 ";
$sql .= "LIMIT 0, 1 ";
//リセットボタン押下
if(isset($_POST['res'])){
$sear = "";
}
if(isset($_POST['search'])){
$sear = $_POST["sear"];
$keyword = $_POST["keyword"];
$period = $_POST["period"];
$category = $_POST["category"];
//base sql文
$base_sql1 = "SELECT n.news_id, n.title, n.contents, n.reg_date, n.category ";
$base_sql1 .= "FROM news n ";
$base_sql1 .= "WHERE n.active_flag = '1' ";
//通常検索
$sql1 = $base_sql1 . "ORDER BY n.reg_date DESC, n.upd_date DESC ";
//キーワード検索
$sql4 = $base_sql1 . "AND title like '%" . $keyword . "%' OR n.active_flag = '1' AND contents like '%" . $keyword . "%'";
$sql4 .= "ORDER BY n.reg_date DESC, n.upd_date DESC ";
//期間検索用
$sql3 = $base_sql1 . "AND n.reg_date like '$period%'";
$sql3 .= "ORDER BY n.reg_date DESC, n.upd_date DESC ";
//カテゴリー検索振り分け用
$sql2 = $base_sql1;
$sql2 .= "AND n.category = '$category' ";
$sql2 .= "ORDER BY n.reg_date DESC, n.upd_date DESC ";
switch($sear){
case "1"://キーワード検索用
$_POST["period"] = "";
$_POST["category"] = "";
$period = "";
$category = "";
$sql = $sql4; break;
break;
case "2"://期間検索用
$_POST["keyword"] = "";
$_POST["category"] = "";
$keyword = "";
$category = "";
$sql = $sql3; break;
break;
case "3":
//カテゴリー
$_POST["period"] = "";
$_POST["keyword"] = "";
$keyword = "";
$period = "";
switch($category){
case "1": //プレアナウンス
$sql = $sql2; break;
case "2": //ニュース
$sql = $sql2; break;
case "3": //イベント
$sql = $sql2; break;
case "9": //お知らせ
$sql = $sql2; break;
default:
$sql = $sql1; break;
}
break;
default:break;
}
$sql_x = $sql;
// $sql_x .= "LIMIT 0, 10 ";
$sql .= "LIMIT 0, 1 ";
}//(issetの終了カッコ)
$rs = @mysql_query($sql);
$num_rows = @mysql_num_rows($rs);
//echo "該当レコード件数 :$num_rows
\n";
$first_news_id = "";
while ($item = @mysql_fetch_array($rs)) {
$news_id = $item[0];
$news_title = $item[1];
$news_contents = $item[2];
$upd_date = str_replace("-", "-", substr($item[3], 2, 8));
$category = $item[4];
if (strlen($news_title) > 100) {$news_title = mb_substr($news_title, 0, 100) . "...";}
if (strlen($news_contents) > 100) {$news_contents = mb_substr($news_contents, 0, 100) . "...";}
$news_contents_tagged = str_replace("\n", "
", $news_contents);
if ($first_news_id == "") {
$first_news_id = $news_id;
}
}
?>