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

$pgsql = sqlcon();

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

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

// リーグ 6:東北地区大学野球選手権大会
// 外部ページへのリンクの場合あり
$league = 6;

// 表示する試合情報の対象日付
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 .= ", game_regist_kbn, senkou_name, senkou_score, koukou_name, koukou_score, url";
$sql .= ", tm1.tmaname AS stmname, tm2.tmaname AS ttmname";
$sql .= " FROM renshiadt";
$sql .= " LEFT OUTER JOIN teammt AS tm1";
$sql .= " ON tm1.teamid = renshiadt.steamid";
$sql .= " LEFT OUTER 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 = '" . $league . "'";
$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_tohoku_area.gif" alt="" /></h3>
      </div>

      <div class="gameNews">
        <table>
          <tr class="color">
            <th class="date">試合日</th>
            <th class="fighting" colspan="2">対戦カード</th>
            <th class="day">開始時間</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"]))] . ")";

              if ($arrGame[$i]["game_regist_kbn"] == 1) {
                  $gcard = h($arrGame[$i]["stmname"]) . " " . $arrGame[$i]["stscore"] . " - " . $arrGame[$i]["ttscore"] . " " . h($arrGame[$i]["ttmname"]);
              } else if ($arrGame[$i]["game_regist_kbn"] == 2) {
                  $gcard = h($arrGame[$i]["senkou_name"]) . " " . $arrGame[$i]["senkou_score"] . " - " . $arrGame[$i]["koukou_score"] . " " . h($arrGame[$i]["koukou_name"]);
              }

              $gsttime = date("H:i", strtotime($arrGame[$i]["gsttime"]));
          ?>
              <tr>
                <td class="date"><?=$datename?></td>
                <td class="fighting"><?=$gcard?></td>
                <td class="detail">
                <?if ($arrGame[$i]["game_regist_kbn"] == 1) {?>
                  <a href="result.php?gameid=<?=$arrGame[$i]["gameid"]?>">詳細</a>
                <?} else if ($arrGame[$i]["game_regist_kbn"] == 2) {?>
                  <a href="<?=h($arrGame[$i]["url"])?>">詳細</a>
                <?}?>
                </td>
                <td class="time"><?=$gsttime?></td>
                <td class="ground"><?=h($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>
