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

$pgsql = sqlcon();

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

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

// リーグ 1～3部
if ($_POST["league"] != "") {
    $league = $_POST["league"];
} else if ($_GET["league"] != "") {
    $league = $_GET["league"];
} else {
    $league = 1;
}
if (!preg_match("/^\d$/", $league)) {
    $league = 1;
}

// 春季・秋季
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;
}

if ($league == 1) {
    $gmimg_1 = "common/img/main_con_game_first_o.gif";
    $gmimg_2 = "common/img/main_con_game_second_n.gif";
    $gmimg_3 = "common/img/main_con_game_third_n.gif";
} else if ($league == 2) {
    $gmimg_1 = "common/img/main_con_game_first_n.gif";
    $gmimg_2 = "common/img/main_con_game_second_o.gif";
    $gmimg_3 = "common/img/main_con_game_third_n.gif";
} else {
    $gmimg_1 = "common/img/main_con_game_first_n.gif";
    $gmimg_2 = "common/img/main_con_game_second_n.gif";
    $gmimg_3 = "common/img/main_con_game_third_o.gif";
}

// 連盟リーグ試合情報 から取得
$sql = "";
$sql .= "SELECT lggameid";
$sql .= " FROM renlegdt";
$sql .= " WHERE league = '" . pgesc($league) . "'";
$sql .= " AND shiainen = '" . $gamey . "'";
$sql .= " AND gamekbn = '" . pgesc($gamekbn) . "'";
$result = pg_query($pgsql, $sql);
$arrData = pg_fetch_array($result);

$lggameid = $arrData["lggameid"];

if ($lggameid != "") {
    // リーグ試合情報あり

    // チーム
    $sql = "";
    $sql .= "SELECT teammt.teamid, tmaname, COALESCE(shoritsu, 0) AS shoritsu";
    $sql .= " FROM renseidt";
    $sql .= " INNER JOIN teammt";
    $sql .= " ON teammt.teamid = renseidt.teamid";
    $sql .= " WHERE renseidt.lggameid = " . $lggameid;
    $sql .= " ORDER BY ranking, shoritsu DESC, teammt.scnamekana";
    $result = pg_query($pgsql, $sql);
    $teamCnt = pg_num_rows($result);
    $arTeam = pg_fetch_all($result);

    // 配列準備初期化
    for($i = 0; $i < $teamCnt; $i++) {
        $jteamid[$i] = $arTeam[$i]["teamid"];
        $jtmaname[$i] = $arTeam[$i]["tmaname"];
        $ateamid[$i] = $arTeam[$i]["teamid"];
        $atmaname[$i] = $arTeam[$i]["tmaname"];
        $kachisu[$arTeam[$i]["teamid"]] = "0";
        $makesu[$arTeam[$i]["teamid"]] = "0";
        $hikiwakesu[$arTeam[$i]["teamid"]] = "0";
        $shoritsu[$arTeam[$i]["teamid"]] = "0";
        $ranking[$arTeam[$i]["teamid"]] = "0";
        for ($j = 0; $j < $teamCnt; $j++) {
            if ($i == $j) {
                $hoshi[$arTeam[$i]["teamid"]][$arTeam[$j]["teamid"]] = "-";
            } else {
                $hoshi[$arTeam[$i]["teamid"]][$arTeam[$j]["teamid"]] = "";
            }
        }
    }

    // renhoshidt から取得
    $sql = "";
    $sql .= "SELECT jteamid, ateamid, hoshi";
    $sql .= " FROM renhoshidt";
    $sql .= " WHERE lggameid = " . $lggameid;
    $sql .= " ORDER BY jteamid, ateamid";
    $result = pg_query($pgsql, $sql);
    $arrData = pg_fetch_all($result);

    for ($i = 0; $i < pg_num_rows($result); $i++) {
        $hoshi[$arrData[$i]["jteamid"]][$arrData[$i]["ateamid"]] = $arrData[$i]["hoshi"];
    }

    // renseidt から取得
    $sql = "";
    $sql .= "SELECT ";
    $sql .= "teamid, kachisu, makesu, hikiwakesu, shoritsu, ranking";
    $sql .= " FROM renseidt";
    $sql .= " WHERE lggameid = " . $lggameid;
    $sql .= " ORDER BY teamid";
    $result = pg_query($pgsql, $sql);
    $arrData = pg_fetch_all($result);

    for ($i = 0; $i < pg_num_rows($result); $i++) {
        $kachisu[$arrData[$i]["teamid"]] = $arrData[$i]["kachisu"];
        $makesu[$arrData[$i]["teamid"]] = $arrData[$i]["makesu"];
        $hikiwakesu[$arrData[$i]["teamid"]] = $arrData[$i]["hikiwakesu"];
        $shoritsu[$arrData[$i]["teamid"]] = $arrData[$i]["shoritsu"];
        $ranking[$arrData[$i]["teamid"]] = $arrData[$i]["ranking"];
    }

} else {
    // 試合情報なし

    //チーム
    $sql = "";
    $sql .= "SELECT teamid, tmaname";
    $sql .= " FROM teammt";
    $sql .= " WHERE delkn = false";
    $sql .= " AND bun1id = " . pgesc($league);
    $sql .= " ORDER BY teamid";
    $result = pg_query($pgsql, $sql);
    $teamCnt = pg_num_rows($result);
    $arTeam = pg_fetch_all($result);

    // 配列準備初期化
    for ($i = 0; $i < $teamCnt; $i++) {
        $jteamid[$i] = $arTeam[$i]["teamid"];
        $jtmaname[$i] = $arTeam[$i]["tmaname"];
        $ateamid[$i] = $arTeam[$i]["teamid"];
        $atmaname[$i] = $arTeam[$i]["tmaname"];
        $kachisu[$arTeam[$i]["teamid"]] = "0";
        $makesu[$arTeam[$i]["teamid"]] = "0";
        $hikiwakesu[$arTeam[$i]["teamid"]] = "0";
        $shoritsu[$arTeam[$i]["teamid"]] = "0";
        for ($j = 0; $j < $teamCnt; $j++) {
            if ($i == $j) {
                $hoshi[$arTeam[$i]["teamid"]][$arTeam[$j]["teamid"]] = "-";
            } else {
                $hoshi[$arTeam[$i]["teamid"]][$arTeam[$j]["teamid"]] = "";
            }
        }
    }

}

// 試合結果
// 週
$sql = "";
$sql .= "SELECT gweek, COUNT(*) AS cnt";
$sql .= " FROM renshiadt";
$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 delkn = false";
$sql .= " GROUP BY gweek";
$sql .= " ORDER BY gweek";
$result = pg_query($pgsql, $sql);
$gweekCnt = pg_num_rows($result);
$arrData = pg_fetch_all($result);
for ($i = 0; $i < $gweekCnt; $i++) {
    $gweek[$arrData[$i]["gweek"]] = $arrData[$i]["cnt"];
}

// 試合日
$sql = "";
$sql .= "SELECT gweek, gamedt, COUNT(*) AS cnt";
$sql .= " FROM renshiadt";
$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 .= " GROUP BY gweek, gamedt";
$sql .= " ORDER BY gweek, gamedt";
$result = pg_query($pgsql, $sql);
$gamedtCnt = pg_num_rows($result);
$arrData = pg_fetch_all($result);
for ($i = 0; $i < $gamedtCnt; $i++) {
    $gamedt[$arrData[$i]["gweek"]][$arrData[$i]["gamedt"]] = $arrData[$i]["cnt"];
}

$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 gweek, gamedt, gsttime";
$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_result_table.gif" alt ="" /></h3>
        <div class="leagueName"><a href="game_result_table.php?league=1&amp;gamekbn=<?=$gamekbn?>"><img src="<?=$gmimg_1?>" alt="一部リーグ" /></a></div>
        <div class="leagueName"><a href="game_result_table.php?league=2&amp;gamekbn=<?=$gamekbn?>"><img src="<?=$gmimg_2?>" alt="二部リーグ" /></a></div>
        <div class="leagueName"><a href="game_result_table.php?league=3&amp;gamekbn=<?=$gamekbn?>"><img src="<?=$gmimg_3?>" alt="三部リーグ" /></a></div>
      </div>

      <div class="gameResult">
          <table>
            <tr>
              <th>順位</th>
              <td>&nbsp;</td>
            <? for ($i = 0; $i < $teamCnt; $i++) { ?>
              <td><?= h($atmaname[$i]) ?></td>
            <? } ?>

              <td>勝数</td>
              <td>負数</td>
              <td>分数</td>
              <td>勝率</td>
            </tr>
<?
               $trf = 0;
               $rank = 0;
               $rankshift = 1;
               $writsu = -1;
               for ($i = 0; $i < $teamCnt; $i++) {
                 if ($writsu != $shoritsu[$jteamid[$i]]) {
                   $rank = $rank + $rankshift;
                   $writsu = $shoritsu[$jteamid[$i]];
                   $rankshift = 1;
                 } else {
                   $rankshift++;
                 }
                 if ($trf == 0) {
                   $trf = 1;
?>
            <tr class="st">
              <? } else { ?>
                <? $trf = 0; ?>
            <tr>
              <? } ?>
              <th><?= ($ranking[$jteamid[$i]] != "") ? $ranking[$jteamid[$i]] : $rank?></th>
              <td><?= h($jtmaname[$i]) ?></td>
              <? for ($j = 0; $j < $teamCnt; $j++) { ?>
                <? if ($jteamid[$i] == $ateamid[$j]) { ?>
              <td>-</td>
                <? } else { ?>
              <td><?=$hoshi[$jteamid[$i]][$ateamid[$j]]?></td>
                <? } ?>
              <? } ?>
              <td><?=$kachisu[$jteamid[$i]]?></td>
              <td><?=$makesu[$jteamid[$i]]?></td>
              <td><?=$hikiwakesu[$jteamid[$i]]?></td>
              <td><?=$shoritsu[$jteamid[$i]]?></td>
            </tr>
            <? } ?>

          </table>
      </div>
<!-- 日程表-->
      <div class="gameHeader">
        <h3 class="gameTitle"><img src="common/img/h_schedule_table.gif" alt="" /></h3>
      </div>

      <div class="gameNews">

        <table>
          <tr class="color">
            <th class="week">週</th>
            <th class="time">試合日</th>
            <th class="fighting" colspan="2">対戦カード</th>
            <th class="time">開始時間</th>
            <th class="ground">球場</th>
          </tr>

<?
            $tmpwk = "";
            $tmpdt = "";
            $shwWeek = false;
            $shwDate = false;
            for ($i = 0; $i < $GameCnt; $i++) {
              if ($tmpwk != $arrGame[$i]["gweek"]) {
                // 週
                $tmpwk = $arrGame[$i]["gweek"];
                $wkrowspan = $gweek[$arrGame[$i]["gweek"]];
                $weekname = "第" . mb_convert_kana($arrGame[$i]["gweek"], "R", "utf-8") . "週";
                $shwWeek = true;
              }
              if ($shwWeek == true  // 同じ日なのに週が違うデータが登録されている場合に表示が崩れる為に条件追加。そういうデータが登録出来てしまう。
                  || $tmpdt != $arrGame[$i]["gamedt"]) {
                // 試合日
                $tmpdt = $arrGame[$i]["gamedt"];
                $dtrowspan = $gamedt[$arrGame[$i]["gweek"]][$arrGame[$i]["gamedt"]];
                $datename = date("m/d", strtotime($arrGame[$i]["gamedt"])) . "(" . $weekday[date("w", strtotime($arrGame[$i]["gamedt"]))] . ")";
                $shwDate = true;
              }
              $gcard = h($arrGame[$i]["stmname"]) . " " . $arrGame[$i]["stscore"] . " - " . $arrGame[$i]["ttscore"] . " " . h($arrGame[$i]["ttmname"]);
              $gsttime = date("H:i", strtotime($arrGame[$i]["gsttime"]));
?>
          <tr>
<?
              if ($shwWeek) {
                $shwWeek = false;
?>
            <td class="week" rowspan="<?=$wkrowspan?>"><?=$weekname?></td>
<?
              }
              if ($shwDate) {
                $shwDate = false;
?>
            <td class="time" rowspan="<?=$dtrowspan?>"><?=$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>

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

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