<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<link href="style_p.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function myoffice(val, group_num)
{
if(val==true)
{
	document.getElementById("group"+group_num+"").style.display="";
}
else
{
	document.getElementById("group"+group_num+"").style.display="none";
}

}
</script>
<script language="JavaScript">

//******************************************
function checkregis() {
  
if(document.myform.chk1.checked == false && document.myform.chk2.checked == false && document.myform.chk3.checked == false  )   
{        
alert('คุณไม่ได้เลือกการปฏิบัติหน้าที่ ');       
return false;    
} 

//********************************************
}
</script>
<?
if($_GET[op] == "calendar_add"){
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
		if (!$_POST[EventDate] OR !$_POST[subject] OR !$_POST[DETAIL] OR !$_POST[ROOM]){
			echo "<script language='javascript'>" ;
			echo "alert('กรุณากรอกข้อมูลต่างๆให้ครบถ้วน')" ;
			echo "</script>" ;
			echo "<script language='javascript'>javascript:history.back()</script>";
			exit();
	}//ตรวจสอบมี user นี้หรือยัง
	$res[calendar] = $db->select_query("SELECT id FROM ".TB_CALENDAR." WHERE room='".$_POST[ROOM]."' and date_event='".$_POST[EventDate]."' and timein='".$_POST[TIMEIN]."' OR room='".$_POST[ROOM]."' and date_event='".$_POST[EventDate]."' and timeout='".$_POST[times]."' ");
	$rows[calendar] = $db->rows($res[calendar]); 
	$db->closedb ();
		if($rows[calendar]){
			$ProcessOutput .= "<BR><BR>";
			$ProcessOutput .= "<CENTER>";
			$ProcessOutput .= "<BR><BR><B>มีการจองห้องประชุม วันนี้ เวลา นี้แล้ว</B><BR><BR><INPUT TYPE=\"submit\" VALUE=\"เขียนจองห้องใหม่ \" onclick=\"window.location='?name=calendar&file=addevent'\">";
			$ProcessOutput .= "</CENTER>";
			$ProcessOutput .= "<BR><BR>";
} else {
				$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
				$db->add_db(TB_CALENDAR,array(
					"year"=>$_POST[YEAR],
					"date_event"=>"".$_POST[EventDate]."",
					"room"=>"".$_POST[ROOM]."",
					"timein"=>"".$_POST[TIMEIN]."",
					"timeout"=>"".$_POST[times]."",
					"subject"=>"".$_POST[subject]."",
					"detail"=>"".$_POST[DETAIL]."",
					"person"=>"".$_POST[PERSON]."",
					"post_date"=>"".TIMESTAMP.""
				));
			$nums=$_POST[num];
			$is=1;
			for($i=1;$i<$nums;$i++){
				$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
						$Date=date($_POST[EventDate]); // วันปัจจุบัน สมมุติว่าวันที่ 2006-01-25
						$DateUpdate =date("Y-m-d", strtotime("+$is day",strtotime($Date))); // บวกไปอีก10วัน 
						$sub=$_POST[subject];
						$id=$i+1;
						$subs="".$_POST[subject]."  (วันที่ $id)";
				$db->add_db(TB_CALENDAR,array(
					"year"=>$_POST[YEAR],
					"date_event"=>"".$DateUpdate."",
					"room"=>"".$_POST[ROOM]."",
					"timein"=>"".$_POST[TIMEIN]."",
					"timeout"=>"".$_POST[times]."",
					"subject"=>"".$subs."",
					"detail"=>"".$_POST[DETAIL]."",
					"person"=>"".$_POST[PERSON]."",
					"post_date"=>"".TIMESTAMP.""
				));
				$is++;
			} 
		
			$ProcessOutput .= "<BR><BR>";
			$ProcessOutput .= "<CENTER><A HREF=\"?name=admin&file=main\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
			$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการเพิ่ม รายการปฏิทิน เรียบร้อยแล้ว</B></FONT>";
			$ProcessOutput .= "<BR><BR><INPUT TYPE=\"submit\" VALUE=\" จองห้องประชุม \" onclick=\"window.location='?name=calendar&file=addevent'\">";
			$ProcessOutput .= "</form></CENTER>";
			$ProcessOutput .= "</CENTER>";
			$ProcessOutput .= "<BR><BR>";
} 
	echo $ProcessOutput ;
	}
}
else if($_GET[op] == ""){
//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[year] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id DESC LIMIT 1");
		$arr[year] = $db->fetch($res[year]);
?>
<script type="text/javascript" src="datepicker.js"></script>
	<TABLE cellSpacing=0 cellPadding=0 width=700 border=0 background="images/1234.jpg">
      <TBODY>
        <TR>
          <TD vAlign=top>
					<B>&nbsp;&nbsp;<IMG SRC="images/add.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp; เพิ่มรายการจองห้องประชุม </B>
					<BR><BR>
<form NAME="myform" METHOD=POST ACTION="?name=calendar&file=addevent&op=calendar_add">
<INPUT TYPE="hidden" NAME="YEAR" size="80" VALUE="<?=$arr[year][name];?>" >
<table width="700" height="438" >
  <tr> 
    <td width="200" height="20"   align="right"valign="top"><b>เลือกห้องประชุม :</b></td>
    <td  align="left" valign="top">
	<select name="ROOM"><option></option> 
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[meeting] = $db->select_query("SELECT * FROM ".TB_MEETING."  ORDER BY id ");
   while ($arr[meeting] = $db->fetch($res[meeting]))
   {
		echo "<option value=\"".$arr[meeting][name]."\">".$arr[meeting][name]."</option>";
   }
$db->closedb ();
?>
                                            </select>
	</td>

  </tr>
  <tr> 
    <td  align="right" height="20" valign="top"><b>เลือกวันที่ :</b></td>
    <td  align="left" valign="top">
	<input name="EventDate" readonly value="<?=$_GET[dates];?>"style="width=200"> <IMG SRC="images/admin/dateselect.gif" BORDER="0" ALT="เลือกวันที่" onclick="displayDatePicker('EventDate', false, 'ymd', '-');" align="absmiddle">
	</td>
  </tr>
  <tr> 
    <td  align="right" height="20" valign="top"><strong>เวลา :</strong></td>
    <td align="left" valign="top">
<select NAME="TIMEIN" style="width=100">
													<option></option> 
														<option value="08.30">08.30</option>
														<option value="13.00">13.00</option>
													</select> ถึง 
<select NAME="times" style="width=100">
													<option></option> 
														<option value="12.00">12.00</option>
													<option value="16.30">16.30</option>
													</select>
	</td>
  </tr>

  <tr> 
    <td  height="20" align="right" valign="top"><strong>เรื่อง :</strong></td>
    <td align="left" valign="top">
<textarea  cols=50 id="subject" rows="5" class="ckeditor"  name="subject" ></textarea>
	</td>
  </tr>
  <tr> 
    <td align="right" valign="top"><strong>จำนวนผู้เข้าประชุม :</strong></td>
    <td align="left" valign="top">
	<INPUT TYPE="text" name="DETAIL" style="width=100"> คน
 <?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);
?>
	<INPUT TYPE="hidden" name="PERSON" VALUE="<?=$arr[user][id];?>" style="width=350">
<BR><BR>
<input type="submit" value="บันทึกจองห้อง" name="submit">
	</td>
  </tr>
 
</table>
</form>
<?	
	echo $ProcessOutput ;
}
?>
					</TD>
				</TR>
			</TABLE>