File Manager

<%response.cachecontrol="private"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>�к����ʹ�����͡�ú�����</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

// �óյ�ͧ�����軯ԷԹŧ��ҡ���� 1 �ѹ���˹�� ����������� Code ����÷Ѵ��ҹ��ҧ���¤�Ѻ (1 �ش = 1 ��ԷԹ)

$("#datepicker-th").datepicker({ dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay, dayNames: ['�ҷԵ��', '�ѹ���', '�ѧ���', '�ظ', '����ʺ��', '�ء��', '�����'],
              dayNamesMin: ['��.','�.','�.','�.','��.','�.','�.'],
              monthNames: ['���Ҥ�','����Ҿѹ��','�չҤ�','����¹','����Ҥ�','�Զع�¹','�á�Ҥ�','�ԧ�Ҥ�','�ѹ��¹','���Ҥ�','��Ȩԡ�¹','�ѹ�Ҥ�'],
              monthNamesShort: ['�.�.','�.�.','��.�.','��.�.','�.�.','��.�.','�.�.','�.�.','�.�.','�.�.','�.�.','�.�.']});

$("#datepicker-th-2").datepicker({ changeMonth: true, changeYear: true,dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay,dayNames: ['�ҷԵ��','�ѹ���','�ѧ���','�ظ','����ʺ��','�ء��','�����'],
              dayNamesMin: ['��.','�.','�.','�.','��.','�.','�.'],
              monthNames: ['���Ҥ�','����Ҿѹ��','�չҤ�','����¹','����Ҥ�','�Զع�¹','�á�Ҥ�','�ԧ�Ҥ�','�ѹ��¹','���Ҥ�','��Ȩԡ�¹','�ѹ�Ҥ�'],
              monthNamesShort: ['�.�.','�.�.','��.�.','��.�.','�.�.','��.�.','�.�.','�.�.','�.�.','�.�.','�.�.','�.�.']});

$("#datepicker-en").datepicker({ dateFormat: 'dd/mm/yy'});

$("#inline").datepicker({ dateFormat: 'dd/mm/yy', inline: true });

});
		</script>
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0">
  <tr> 
    <td colspan="2"><div align="right"><img src="Image/head1.gif" width="800" height="61"></div></td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif"><div align="right"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong>| 
        <a href="http://www.swu.ac.th" target=_blank>SWU</a> | <a href="http://bsri.swu.ac.th" target=_blank>BSRI</a> 
        |<a href="chaPW.asp"><strong>Change 
        Password</strong></a>|<a href="log_out.asp">Log Out </a></strong></font>|</div></td>
  </tr>
  <tr> 
    <td width="20%" align="left" valign="top" bgcolor="#FFCCCC">
	</td>
    <td width="77%" align="left" valign="top">
      <table width="100%"  border="0" cellspacing="0" bordercolor="#FFFFCC" >

<%
'*****************************************************************

session("tb_name")="thesis"
%>


<%
		  pern=session("username")
		  per="2"
		  tb="student"
		  sqlnc="select * from tb_permission where id_staff='"&pern&"' and tb_edit='"&per&"' and tb_name='"&tb&"'"
		  set orsnc=server.createobject("adodb.recordset")
		  orsnc.open sqlnc,conn,1,3
'*****************************************************************
'  if session("tb_preview") <> 1 or session("tb_edit")=2 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ
id_stu=session("ids")
id_thesis=request("id_thesis")
idt=request("id")
%>
<tr><td colspan=2><a href=edit_thesis_stu_form.asp?id_stu=<%=id_stu%>> ��ԭ�ҹԾ�������� </a>>

<tr><td colspan=2><strong>
            
              <br><div align=center>
              ��䢢����š�èͧ��ͧ�ͺ<br>
              <br>
			  <tr><td colspan=2>
<%

sqls="select * from student where id_stu='"&id_stu&"'"
	set orss=server.createobject("adodb.recordset")
	orss.open sqls,conn,1,3
		if not orss.eof then
			response.write orss("id_stu")&"<strong> "&orss("name_stu")&" "&orss("sur_stu")&"</strong> "

set ors4=server.createobject("adodb.recordset")
			sql4="select * from student_group where id_stugroup='"&orss("id_stugroup")&"'"
			ors4.open sql4,Conn,1,3
			if not ors4.eof then

sqlc="select * from curriculum where id_curriculum='"&ors4("id_curriculum")&"'"
				set orsc=server.createobject("adodb.recordset")
				orsc.open sqlc,conn,1,3
				if not orsc.eof then
					sqlt="select * from type_curriculum where id_type_curri='"&ors4("id_type_curri")&"'"
					set orst=server.createobject("adodb.recordset")
					orst.open sqlt,conn,1,3
					if not orst.eof then
		'response.write ors4("id_stugroup")
									%>

<%  =orsc("curriculum_sum")%> Ẻ <%=orst("type_curri_th")%> ��� <%=ors4("no_stugroup")%>
										<%
										end if
								end if
								end if
		'if not orsnc.eof then
		'response.write "[<a href=edit_thesis_stu_form.asp?id_stu="&id_stu&"> ��ԭ�ҹԾ�������� </a>]"
								'end if
end if

<table width="100%" border="0" cellspacing="0" bordercolor="#FFCCFF">
                        <tr> 
                          <td colspan="2"><table  border="0">
                              <tr> 
                                
                                <td colspan="4" ><%
				sqlt="select * from thesis where id_thesis='"&id_thesis&"'"
				set orst=server.createobject("adodb.recordset")
				orst.open sqlt,conn,1,3
				if not orst.eof then
				'����ջ�ԭ�ҹԾ���
						'response.write orst("id_thesis")&" "
						if not orsnc.eof then
								'response.write "<strong>[ <a href=edit_thesis_form.asp?id_thesis="&orst("id_thesis")&"&id_stu="&orss("id_stu")&">Edit</a> ] </strong>"
						end if
							%>
							
							</td>
                              </tr>
                              <tr> 
                                <td bgcolor="#FFFFCC">���ͻ�ԭ�ҹԾ���</td>
                                <td colspan="3" ><%
							'response.write "<>orst("id_academic_semeter")&"/"&orst("academic_year")
							response.write orst("thesis_th")
							response.write "<br>- "&orst("thesis_eng")
							
								
								%></td>
                              </tr>
   
				<%end if%>

<tr> 
       <td colspan="4" bgcolor="#e0a8fd"><div align="left"><strong>��䢢����š�èͧ��ͧ�ͺ</div></td>
</tr>
<tr><td colspan=4><%if not orsnc.eof or id_stu=session("id_stu1") then%><form action="reserve_room_save.asp" method="post" onsubmit="return doSubmit();" name="form1"><table width="100%" border="0">
  <tr>
    <td width="20%" colspan=2>���ʷի��</td><td  colspan=2>
	<INPUT TYPE="text" NAME="id_test_thesis" value =<%=id_thesis%> readonly style=font-size=16px></td></tr>
	<tr bgcolor=#E5E5E5><td colspan=2>����������ͺ</td><td colspan=2>
<% 
	sqlall="select * from thesis_test where id='"&idt&"'"
	Set orsall=server.createobject("adodb.recordset")
	orsall.open sqlall,conn,1,3
	
	If Not orsall.eof then
	
	sqlpo="select * from type_test_thesis where id_type_test='"&orsall("id_type_test")&"'"
	set orspo=server.createobject("adodb.recordset")
	orspo.open sqlpo,conn,1,3
			if not orspo.eof then
	response.write orspo("test_name")
		
									 
			end if
	%>
                                    </td></tr>
<tr><td colspan=2>�ѹ/��͹/�� (�����)</td><td colspan=2>
	<%
  numday=Array("01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31")
				  i=lbound(numday)
dayleft=orsall("date1")
				  %>

<select name="date1" style="font-size:16px">
				  <% 				  do while i<=ubound(numday)
				  %>
				  <option <% if numday(i)=dayleft then %>
				  value=<%=dayleft%> selected <%else%>
				  value=<%=numday(i)%><%end if%>><%=numday(i)%></option>
				<%  i=i+1
				  loop
				  %>
                  </select>
				    ��͹ 
				   <%
				  monthmid=orsall("month1")
				  'response.write monthmid
				  nummonth=array("01","02","03","04","05","06","07","08","09","10","11","12")
				  nummonthth=array("���Ҥ�","����Ҿѹ��","�չҤ�","����¹","����Ҥ�","�Զع�¹","�á�Ҥ�","�ԧ�Ҥ�","�ѹ��¹","���Ҥ�","��Ȩԡ�¹","�ѹ�Ҥ�")
				  ii=lbound(nummonth)
				  iii=lbound(nummonthth)%>
                  <select name="month1" style="font-size:16px">
				    <%
				do while ii<=ubound(nummonth)
  %>
  <option <% if nummonth(ii)=monthmid then%>
  value=<%=monthmid%> selected <%else%>
  value=<%=nummonth(ii)%><%end if%>><%=nummonthth(iii)%></option>
  <%ii=ii+1
        iii=iii+1
		loop
	%>
                  </select> �.�.
<input type="text" name="year1" maxlength="4" onkeypress='if (event.keyCode < 46 || event.keyCode >57 ) event.returnValue=false;' value=<%=orsall("year1")%> style="font-size:16px">

<select name="date2" style="font-size:16px">
				  <% 				  do while i<=ubound(numday)
				  %>
				  <option <% if numday(i)=dayleft then %>
				  value=<%=dayleft%> selected <%else%>
				  value=<%=numday(i)%><%end if%>><%=numday(i)%></option>
				<%  i=i+1
				  loop
				  %>
                  </select>
				    ��͹ 
				   <%
				  monthmid=orsall("month2")
				  'response.write monthmid
				  nummonth=array("01","02","03","04","05","06","07","08","09","10","11","12")
				  nummonthth=array("���Ҥ�","����Ҿѹ��","�չҤ�","����¹","����Ҥ�","�Զع�¹","�á�Ҥ�","�ԧ�Ҥ�","�ѹ��¹","���Ҥ�","��Ȩԡ�¹","�ѹ�Ҥ�")
				  ii=lbound(nummonth)
				  iii=lbound(nummonthth)%>
                  <select name="month2" style="font-size:16px">
				    <%
				do while ii<=ubound(nummonth)
  %>
  <option <% if nummonth(ii)=monthmid then%>
  value=<%=monthmid%> selected <%else%>
  value=<%=nummonth(ii)%><%end if%>><%=nummonthth(iii)%></option>
  <%ii=ii+1
        iii=iii+1
		loop
	%>
                  </select> �.�.
<input type="text" name="year2" maxlength="4" onkeypress='if (event.keyCode < 46 || event.keyCode >57 ) event.returnValue=false;' value=<%=orsall("year2")%> style="font-size:16px"></tr>

<tr bgcolor=#E5E5E5><td colspan=2>����</td><td colspan=2>
<select name="time1" style="font-size=16px">
	<% sqlt="select * from time_test"
			set orst=server.createobject("adodb.recordset")
			orst.open sqlt,conn,1,3
			if not orst.eof then
			orst.movefirst
			do while not orst.eof
         %>
    <option <%	
	if cint(orst("id_time"))=cint(orsall("id_time")) then 
			  %>
		value=<%=orsall("id_time")%>
		selected
		<%else%> 
		value=<%=orst("id_time")%>	
		<%end if%>> 
		<%=orst("time_name")%> <%'=id_type_res%><%'=orst("id_time")%>	</option>
		<%

'value="&orst("id_time")&">"&orst("time_name")&"
		
		
		orst.movenext
		loop
			end if
	%>
      </select> �֧ 
<select name="time2" style="font-size=16px">
	<% sqlt2="select * from time_test"
			set orst2=server.createobject("adodb.recordset")
			orst2.open sqlt2,conn,1,3
			if not orst2.eof then
			orst2.movefirst
			do while not orst2.eof
         %>
    <option <%	
	if cint(orst2("id_time"))=cint(orsall("id_time_end")) then 
			  %>
		value=<%=orsall("id_time_end")%>
		selected
		<%else%> 
		value=<%=orst2("id_time")%>	
		<%end if%>> 
		<%=orst2("time_name")%> <%'=id_type_res%><%'=orst("id_time")%>	</option>
		<%

'value="&orst("id_time")&">"&orst("time_name")&"
		
		
		orst2.movenext
		loop
			end if
	%>
      </select>
	  
	  </td></tr>

<tr><td colspan=2>��ͧ</td><td colspan=2>
<select name="room" style="font-size=16px">
	<% sqlt="select * from room"
			set orst=server.createobject("adodb.recordset")
			orst.open sqlt,conn,1,3
			if not orst.eof then
			orst.movefirst
			do while not orst.eof
       %>
    <option <%	
	if cint(orst("id_room"))=cint(orsall("id_room")) then 
			  %>
		value=<%=orsall("id_room")%>
		selected
		<%else%> 
		value=<%=orst("id_room")%>	
		<%end if%>> 
		<%=orst("room")%> <%'=id_type_res%><%'=orst("id_time")%>	</option>
		<%' value="&orst("id_room")&">"&orst("room")&"</option>"
		orst.movenext
			loop
			end if
	%>
      </select></td></tr>
	<tr><td colspan=2>�š���ͺ</td><td colspan=2>
<select name="id_result" style="font-size=16px">
	<% sqltr="select * from result_thesis"
			set orstr=server.createobject("adodb.recordset")
			orstr.open sqltr,conn,1,3
			if not orstr.eof then
			orstr.movefirst
			do while not orstr.eof
       %>
    <option <%	
	if cint(orstr("id_result"))=cint(orsall("id_result")) then 
			  %>
		value=<%=orsall("id_result")%>
		selected
		<%else%> 
		value=<%=orstr("id_result")%>	
		<%end if%>> 
		<%=orstr("result_t")%> <%'=id_type_res%><%'=orst("id_time")%>	</option>
		<%' value="&orst("id_room")&">"&orst("room")&"</option>"
		orstr.movenext
			loop
			end if
	%>
      </select></td></tr>
  
  <tr bgcolor=#E5E5E5><td colspan=4>
  <input type="hidden" name="id_stuc" value=<%=id_stu%>>
  <input type="hidden" name="idt" value=<%=idt%>>
    <input type="hidden" name="id_thesisc" value=<%=id_thesis%>>
  <input type="submit" name="Submit" value="SaveEdit"></td></tr>
<%End if%>

</table>
</form><%end if%>
</td></tr>
</table>

</td></tr>

</tr>
                            </table></td>
                        </tr>

<%
			  
			  'else '���Է�
	'response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
'response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է�
	'end if '���Է�

%>
            </div></table>	
      </td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif">Contact Admin:: wassanaw@swu.ac.th 
      tel.02-649-5000 ext 17600</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: reserve_room_edit_form.asp.bak