<?
require_once("../common.php");
require_once("../commongw.php");
require_once("Pager.php");
$pgsql = sqlcon();
require_once("./team_base.php");


// 1ページの表示件数
$perPage = 5;

$nsql = "select count(*) from latestnews where teamid = '" . pgesc($teamid) . "' and delkn = 'f'";
$nresult = pg_query($pgsql, $nsql);
$ncount = pg_fetch_result($nresult, 0, 0);

// Pager
$pparams = array(
    "mode"       => "Sliding",
    "perPage"    => $perPage,
    "delta"      => 2,
    "totalItems" => $ncount,
    "prevImg" => "前ページへ",
    "nextImg" => "次ページへ",
);
$pager =& Pager::factory($pparams);

$navi = $pager->getLinks();
$currentPageID = $pager->getCurrentPageID();
$pageoffset = (($currentPageID - 1) * $perPage);


$nsql = "select *, COALESCE(regidt, modidt) AS last_update from latestnews where teamid = '" . pgesc($teamid) . "' and delkn = 'f' order by entrydt DESC, last_update DESC limit $perPage offset $pageoffset";
$nresult = pg_query($pgsql, $nsql);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?= h($r["tmname"]) ?></title>
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="content-script-type" content="text/javascript" />
<meta name="Keywords" content="" />
<meta name="Description" content="" />
<link href="common/css/import.php?t=<?=$teamid?>" rel="stylesheet" type="text/css" />
<link rel="index" href="/index.php" />
<link rel="shortcut icon" href="/favicon.ico" />
<script src="./common/js/imageswither.js" type="text/javascript" charset="utf-8"></script>
<script src="./common/js/prototype.js" type="text/javascript"></script>
</head>
<body id="index">
<div id="page">
<!-- header -->
<? include_once("./header.inc.php"); ?>
<!-- header End -->

  <div id="routeNaviNonLine">
          <p><a href="/team/?t=<?= $teamid ?>">HOME</a> &gt; 新着情報一覧</p>
  </div>

  <div id="contents">
    <div id="pageCon">
    <div id="mainCon">
    <div class="head">

    <dl class="utilityTitle">
      <dt class="title"><img src="common/img/h_infolist.gif" alt="新着情報一覧" /></dt>
      <dt class="logo"><img src="common/img/h_infolist_logo.gif" alt="新着情報一覧" /></dt>
    </dl>

    <ul class="newInfoList">
    <?
    while ($nr = pg_fetch_array($nresult)) {
        $exp = explode("-", $nr["entrydt"]);
        $vdate = $exp[0] . "年" . $exp[1] . "月" . $exp[2] . "日";
        $vendate = date("F d, Y", strtotime($exp[0] . "/" . $exp[1] . "/" . $exp[2] . " 00:00") );
    ?>
    <li class="dot">
      <dl>
        <dt class="dateJa"><span><?= $vdate ?></span><?= h($nr["newstitle"]) ?></dt>
        <dt class="dateEn"><?= $vendate ?></dt>
        <dd class="infoText"><?= nl2br(h($nr["newscontent"])) ?></dd>
        <?if ($nr["url"] != "") {?>
          <dd class="infoText"><a href="<?= h($nr["url"]) ?>"><?= h($nr["url"]) ?></a></dd>
        <?}?>
      </dl>
    </li>
    <?
    }
    ?>
    </ul>

    <dl>
      <dt class="pageGuide"><?= $navi["all"] ?></dt>
    </dl>
    <!-- / div class head-->
    </div>
   <!-- /mainCon -->
   </div>
   </div>


    <p class="pageTop"><a href="#page"><img src="common/img/pagetop.gif" alt="ページトップへ" /></a></p>

  <!-- /contents -->
  </div>

  <!-- footer Start -->
  <? include_once("./footer.inc.php"); ?>
  <!-- footer End -->

<!-- /page -->
</div>
</body>
</html>
