<?
require_once("../common.php");
require_once("../commongw.php");
$pgsql = sqlcon();
require_once("./team_base.php");


// 現在年+-5年を表示範囲とする
$maxYear = date("Y", strtotime("+5 year"));
$minYear = date("Y", strtotime("-5 year"));

// 試合分類取得
$gameSectionArr = getgamesection($pgsql);

// 表示年月取得
if ($_GET["date"]
        && preg_match("/^\d{6}$/", $_GET["date"])
        && checkdate(substr($_GET["date"], 4, 2), 1, substr($_GET["date"], 0, 4))) {
    $requestYear = substr($_GET["date"], 0, 4);
    $requestMonth = substr($_GET["date"], 4, 2);
    if ($requestYear >= $maxYear) {
        $requestYear = $maxYear;
    } else if ($requestYear <= $minYear) {
        $requestYear = $minYear;
    }

    $getymd = $requestYear . "/" . $requestMonth . "/1";
    $dbgetymd = $requestYear . "-" . $requestMonth . "-1";
    $lyear = $requestYear;
} else {
    $getymd = date("Y/m/1");
    $dbgetymd = date("Y-m-1");
    $lyear = date("Y");
}
$strymd = strtotime($getymd);
$getmon = date("n", $strymd);
$getfweek = date("w", $strymd);
$dayplus = $getfweek;
$lastday = date("t", $strymd);


// スケジュール取得
$sql = "select * from shiadt where deletion = 'f' and teamid = '" . pgesc($teamid) . "' and (eventdate >= '$dbgetymd' and eventdate < '" . date("Y-m-1", strtotime("+ 1 month", $strymd)) . "') order by startdate, section";
$result = pg_query($pgsql, $sql);
$yoteiarr = array();
if (pg_num_rows($result) > 0) {
    while ($er = pg_fetch_array($result)) {

        $exp = explode(" ", $er["startdate"]);
        $exp2 = explode("-", $exp[0]);
        $exp3 = explode(":", $exp[1]);
        $startdate = $exp3[0] . ":" . $exp3[1];
        $eventdate = str_replace("-", "/", $exp[0]);

        $exp = array();
        if (isset($er["enddate"])) {
            $exp = explode(" ", $er["enddate"]);
        }
        if (count($exp) > 1) {
            $exp2 = explode("-", $exp[0]);
            $exp3 = explode(":", $exp[1]);
            $enddate = $exp3[0] . ":" . $exp3[1];
        } else {
            $enddate = NULL;
        }

        $day = intval($exp2[2]);

        $comment = $er["comment"];
        $comment = preg_replace("/\r\n|\n/", "", $comment);

        $yoteiarr[$day][] = array(
            "id" => $er["shiaid"],
            "title" => $er["meetname"],
            "section" => $er["section"],
            "area" => $er["area"],
            "eventdate" => $eventdate,
            "startdate" => $startdate,
            "enddate" => $enddate,
            "sideteamname" => $er["sideteamname"],
            "comment" => $comment
        );
    }
}

?>
<!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>
<script src="./common/js/scriptaculous.js?load=effects" type="text/javascript"></script>
<script src="/js/umineco.js" type="text/javascript"></script>
</head>
<body id="index" onload="menumove();">

<div id="page">
<!-- header -->
<? include_once("./header.inc.php"); ?>
<!-- header End -->
<? include_once("./keyvisual.inc.php"); ?>

  <div id="routeNavi">
      <p><a href="/team/?t=<?= $teamid ?>">HOME</a> &gt; スケジュール・予定</p>
  </div>

  <div id="contents">
    <div id="pageCon">
    <div id="mainCon">
    <div class="head">

        <h3 class="scheduleTitle"><img src="common/img/h_schedule.gif" alt="スケジュール・予定"/></h3>

        <dl>
            <dt class="scheduleType">
                <?foreach ($gameSectionArr as $value) {?>
                    <span style="color:<?= $value["color"] ?>; font-size:18px;">■</span><?= $value["name"] ?>&nbsp;
                <?}?>
            </dt>
       </dl>


    <div class="schedule">
    <dl>
        <dt style="text-align: left; float: left;">
            <?if ($lyear > $minYear) {?>
                <a href="/team/schedule.php?t=<?= $teamid ?>&amp;date=<?=($lyear - 1)."12"?>">&laquo;<?=($lyear - 1)?>年</a>
            <?} else {?>
                &nbsp;
            <?}?>
        </dt>
        <dt style="text-align: right; margin-right: 20px;">
            <?if ($lyear < $maxYear) {?>
                <a href="/team/schedule.php?t=<?= $teamid ?>&amp;date=<?=($lyear + 1)."01"?>"><?=($lyear + 1)?>年&raquo;</a>
            <?} else {?>
                &nbsp;
            <?}?>
        </dt>
    </dl>

    <dl>
<?
for ($i = 1; $i <= 12; $i++) {
    $lym = $lyear . sprintf("%02d", $i);
    $vmon = mb_convert_kana($i, "N", "UTF-8");
?>
        <dd class="month"><div <?if ($getmon == $i) {?>class="white4_selected"<?} else {?>class="white4"<?}?>><div class="white3"><div class="white2"><div class="white1"><p><a href="/team/schedule.php?t=<?= $teamid ?>&amp;date=<?= $lym ?>"><?= $vmon ?>月</a></p></div></div></div></div>
        </dd>
<?
}
?>

    </dl>

         <table>
                 <tr class="dayWeek">
                         <th><span class="sunday">日曜日</span></th>
                         <th>月曜日</th>
                         <th>火曜日</th>
                         <th>水曜日</th>
                         <th>木曜日</th>
                         <th>金曜日</th>
                         <th><span class="saturday">土曜日</span></th>
                 </tr>

<?
// 曜日が日曜からじゃなかったら調整
if ($getfweek != 0) {
    echo "<tr>";
    for ($j = 0; $j < $getfweek; $j++) {
        echo "<td>&nbsp;</td>";
    }
}

for ($i = 1; $i <= $lastday; $i++) {
    if (($dayplus % 7) == 0) { ?><tr><? }

    $bgclass = "";
    if (($dayplus % 7) == 0) { $bgclass = "class=\"bgSunday\""; }
    if (($dayplus % 7) == 6) { $bgclass = "class=\"bgSaturday\""; }
?>
            <td <?= $bgclass ?>>
               <dl>
                <dt class="date"><?= $i ?></dt>
<?
if (isset($yoteiarr[$i])) {
    foreach ($yoteiarr[$i] as $key => $value) {
        ?>
        <dt class="typePractice" style="background-color:<?= $gameSectionArr[$value["section"]]["color"] ?>"><? if ($value["section"] != 1 && $value["section"] != 5) { ?><a href="/team/result.php?t=<?= $teamid ?>&amp;s=<?= $value["id"] ?>" style="color:#FFF;"><? } ?><?= h($value["title"]) ?><? if ($value["section"] != 1 && $value["section"] != 5) { ?></a><? } ?></dt>
        <dt class="scheduleDate"><?= h($value["area"]) ?><br /><?= $value["startdate"] ?><? if ($value["enddate"]) { ?>〜<?= $value["enddate"] ?><? } ?><br />
        <? if ($value["section"] != 1 && $value["section"] != 5) { ?><?= h($value["sideteamname"]) ?><br /><? } ?>
        <?= h($value["comment"]) ?>
        </dt>
        <?
    }
}
?>
               </dl>
            </td>
<?
    if (($dayplus % 7) == 6) { ?></tr><? } ?>
<?

    // 曜日が土曜じゃなかったらけつ調整
    if ($i == $lastday && ($dayplus % 7) != 6) {
        for ($j = 0; $j < (6 - ($dayplus % 7)); $j++) {
            echo "<td>&nbsp;</td>";
        }
        echo "</tr>";
    }

    $dayplus++;
}
?>
            </table>
    </div>

    <!-- / 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>
