<?php
include "inc_top.php";

	$tableName = "board_schedule";
	$QUERY_PAGE  = "SELECT year,month FROM $tableName where is_secret='' and schedule_date >= '$today' GROUP BY SUBSTRING(schedule_date, 1, 7 )";
	$result= mysql_query($QUERY_PAGE);
	$total = mysql_affected_rows();

	if(!$total)
	{
		$BRD_LIST = "<article class='post' style='text-align:center;'>情報がありません。</article>";
	}
	else
	{
		for($i=0; $i<$total; $i++)
		{
			$row = mysql_fetch_array($result);
			$tmp_year =$row[year];
			$tmp_month =$row[month];

			switch ($tmp_month) {
				case "1":
					$month_name ="January";break;
				case "2":
					$month_name ="February";break;
				case "3":
					$month_name ="March";break;
				case "4":
					$month_name ="April";break;
				case "5":
					$month_name ="May";break;
				case "6":
					$month_name ="June";break;
				case "7":
					$month_name ="July";break;
				case "8":
					$month_name ="August";break;
				case "9":
					$month_name ="September";break;
				case "10":
					$month_name ="October";break;
				case "11":
					$month_name ="November";break;
				case "12":
					$month_name ="December";break;
			}

			$SUB_QUERY_PAGE  = "SELECT * FROM $tableName where is_secret='' and year='$tmp_year' and month='$tmp_month' and schedule_date >= '$today' order by schedule_date asc";
			$results= mysql_query($SUB_QUERY_PAGE);
			unset($day_list);
			while ($rows = mysql_fetch_array($results)) {
				$tmp_day = explode("-",$rows[schedule_date]);
				$sub_con	= $rows[sub_content];
				$day_list .="
				<div class='schedule-item'>
				<div class='to-do'>
				<h5><span class='day'>$tmp_day[2]</span><span class='name'>$rows[subject]</span></h5>
				<span class='time'>$sub_con &nbsp;</span>
				</div>
				</div>
				";
			}

			$SCH_LS .= "
			<div class='schedule-section'>
				<div class='schedule-y-m'>
				<h4 class='title'>$tmp_year<br>$month_name</h4></div>
				<div class='schedule-list'>
					$day_list
				</div>
			</div>
			";
		}
	}

?>
	<div class="visual-area sc">
		<div class="visual-area-in">
			<h2>SCHEDULE</h2>
		</div>
	</div>


 	<!-- S container -->
	<section>
		<article>
			<div id="container">
			<div class="content">

				<div id="schedule-list-view" style=" background:#ffffff;border: solid 1px rgba(160, 160, 160, 0.3);">
					<?=$SCH_LS?>
				</div>


			</div>
			</div>

		</article>
	</section>
	<!--E container -->
	<?
	include "inc_bottom.php";
	?>