<?
require_once("./common.php");
require_once("./commongw.php");

$pgsql = sqlcon();

// 連盟情報の取得
$renarry = getRenmeiInfo();

// 連盟試合情報として登録されている最新の年、季を取得
$latest_season = getLatestRenmeiShiaiSeason();

// リーグ 7:プレーオフ
$league = 7;

// 春季・秋季
if ($_POST["gamekbn"] != "") {
   $gamekbn = $_POST["gamekbn"];
} else if ($_GET["gamekbn"] != "") {
   $gamekbn = $_GET["gamekbn"];
} else {
   $gamekbn = $latest_season["gamekbn"];
}
if (!preg_match("/^\d$/", $gamekbn)) {
    $gamekbn = 1;
}

// 表示する試合情報の対象日付
if ($latest_season["year"] == date("Y")) {
    $gamey = date("Y");
    $gamem = date("m");
} else {
    $gamey = $latest_season["year"];
    $gamem = 12;
}

// 連盟側試合結果 から取得
$sql = "";
$sql .= "SELECT gameid, steamid, kteamid, gamedt, gsttime";
$sql .= ", gweek, round, gamekbn, ground, stscore, ttscore";
$sql .= ", tm1.tmaname AS stmname, tm2.tmaname AS ttmname";
$sql .= " FROM renshiadt";
$sql .= " INNER JOIN teammt AS tm1";
$sql .= " ON tm1.teamid = renshiadt.steamid";
$sql .= " INNER JOIN teammt AS tm2";
$sql .= " ON tm2.teamid = renshiadt.kteamid";
$sql .= " WHERE EXTRACT(YEAR FROM gamedt) = " . $gamey;
$sql .= " AND EXTRACT(MONTH FROM gamedt) <= " . $gamem;
$sql .= " AND league = '" . pgesc($league) . "'";
$sql .= " AND gamekbn = '" . pgesc($gamekbn) . "'";
$sql .= " AND renshiadt.delkn = false";
$sql .= " ORDER BY gamedt DESC, gsttime DESC";
$result = pg_query($pgsql, $sql);
$GameCnt = pg_num_rows($result);
$arrGame = pg_fetch_all($result);

$weekday = getweek();


?>
<!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($renarry["renkeywd"]) ?></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.css" 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>
<script src="./common/js/scriptaculous.js" type="text/javascript"></script>
</head>

<body id="index">
<div id="page">

<?$selectedMenuNo = 2;?>
<?include_once("./header.inc.php");?>

  <div id="contents">

<!-- サイドメニュー -->
<?include_once("./game_menu.inc.php");?>
<!-- サイドメニュー -->

    <div id="mainpart">
      <div class="gameHeader">
        <h3 class="gameTitle"><img src="common/img/h_game_playoff.gif" alt="" /></h3>
      </div>

      <div class="gameNews">
        <table>
          <tr class="color">
            <th class="date">試合日</th>
            <th class="fighting" colspan="2">対戦カード</th>
            <th class="time">開始時間</th>
            <th class="ground">球場</th>
          </tr>
          <?
          for ($i = 0; $i < $GameCnt; $i++) {
            $datename = date("m/d", strtotime($arrGame[$i]["gamedt"])) . "(" . $weekday[date("w", strtotime($arrGame[$i]["gamedt"]))] . ")";
            $gcard = h($arrGame[$i]["stmname"]) . " " . $arrGame[$i]["stscore"] . " - " . $arrGame[$i]["ttscore"] . " " . h($arrGame[$i]["ttmname"]);
            $gsttime = date("H:i", strtotime($arrGame[$i]["gsttime"]));
          ?>
            <tr>
              <td class="date"><?=$datename?></td>
              <td class="fighting"><?=$gcard?></td>
              <td class="detail"><a href="result.php?gameid=<?=$arrGame[$i]["gameid"]?>">詳細</a></td>
              <td class="time"><?=$gsttime?></td>
              <td class="ground"><?=$arrGame[$i]["ground"]?></td>
            </tr>
          <?}?>
        </table>
      </div>

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

  <div id="lowerSide">
  <!-- lowerSide --></div>

<?include_once("./footer.inc.php");?>

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