File Manager

<%response.cachecontrol="private"%>
<script language="javascript">	
		function doSubmit()
{
	if( document.form1.date0.value == "" )
	{
		alert("��سҡ�͡�ѹ���������ͺ")
		document.form1.date0.focus()
			return false;
	}

if( document.form1.date1.value == "" )
	{
		alert("��سҡ�͡�ѹ�������ش����")
		document.form1.date1.focus()
			return false;
	}
if( document.form1.date0.value > document.form1.date1.value )
	{
		alert("�ѹ�����������ҡ�����ѹ����ش������")
		document.form1.date0.focus()
			return false;
	}
	}
		</script>
<!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">

<link href="bsri2006.css" rel="stylesheet" type="text/css">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
<link type="text/css" href="css/ui-lightness/jquery-ui-1.8.10.custom.css" rel="stylesheet" />

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

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

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

<%
'*****************************************************************
  if session("tb_preview") <> 1 or session("id_lecturer1") = id_lecturer then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

%><br><a href=commitee_thesis.asp>˹���á�����š���ͺ��ԭ�ҹԾ���></a>
<table border="1" cellspacing="0" bordercolor="#FFffcc" align=center><tr><td>

<table align=center >
<tr><td colspan=5><strong><div align=center>��������´����繤�С�������ͺ��ԭ�ҹԾ���</strong><br>
<%
id_lecturer=request("id_lecturer")

id_lecs=request.form("id_lecturer")
idc=request.form("idc")
if id_lecturer="" then
id_lecturer=session("id_lecturer1")
end if
'if id_lecturer="" then
'sqlall=""
'else
'end if
sqlall="select * from lecturer where id_lecturer="&id_lecturer&""
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		response.write orsall("name_lec")&"  "&orsall("sur_lec")
		end if

<form name="form1" method="post" action="detail_committee_thesis.asp"  onsubmit="return doSubmit();"> ���Ҩҡ�ѹ���
<input type="text" size="15" id="datepicker-th" name="date0" />�֧�ѹ���
<input type="text" size="15" id="datepicker-th1" name="date1" /> 
<input type="hidden" name="id_lecturer" value=<%=id_lecturer%>>
<input type="hidden" name="idc" value=0>
  <input type="submit" name="Submit" value="Go!">
  </form>
  </td></tr><tr><td colspan=6 align=right>[<a href=detail_committee_thesis.asp?id_lecturer=<%=id_lecturer%>>�ٷ�����</a>]
<tr bgcolor="#FFccCC"><td><div align="center"><strong>�ӴѺ���<td><div align="center"><strong>����-ʡ�Ź��Ե<td><div align="center"><strong>���˹�<td><div align="center"><strong>�����Ԫ� <td><div align="center"><strong>����������ͺ<td><div align="center"><strong>�ѹ����ͺ</tr>
<%
a=0

if idc="0" then
date0=request.form("date0")
cd=left(date0,2)
cm=mid(date0,4,2)
cy=right(date0,4)
date00=cy+cm+cd
date1=request.form("date1")
cd1=left(date1,2)
cm1=mid(date1,4,2)
cy1=right(date1,4)
date11=cy1+cm1+cd1
sqlttest="select * from thesis_test where dtest between '"&date00&"' and '"&date11&"' order by dtest desc"
'response.write sqlttest
response.write "<tr bgcolor=#FFFFCC><td colspan=6 align=center>����ͺ�����ҧ�ѹ��� "&date0&" �֧ "&date1&"<br>"
else
sqlttest="select * from thesis_test order by dtest desc" '����繡óչ�� �����������Ťú�� ����੾�з���Ң��ͺ��ҹ������
end if
set orsttest=server.createobject("adodb.recordset")
orsttest.open sqlttest,conn,1,3
if not orsttest.eof then
		orsttest.movefirst
		do while not orsttest.eof

sqlthesis="select * from committee_thesis where id_lecturer='"&id_lecturer&"' and  id='"&orsttest("id")&"' order by id desc"
			set orsthesis=server.createobject("adodb.recordset")
			orsthesis.open sqlthesis,conn,1,3
			if not orsthesis.eof then
			orsthesis.movefirst
			do while not orsthesis.eof 
			a=a+1
			b=a mod 2
			if b = 0 then
			bg="#E5E5E5"
			else bg="#FFFFFF"
			end if
                    sqlstu="select * from thesis where id_thesis='"&orsttest("id_thesis")&"'"
					set orsstu=server.createobject("adodb.recordset")
					orsstu.open sqlstu,conn,1,3
					if not orsstu.eof then
					orsstu.movefirst
					do while not orsstu.eof
							sql_="select * from student where id_stu='"&orsstu("id_stu")&"'"
							set ors_=server.createobject("adodb.recordset")
							ors_.open sql_,conn,1,3
							if not ors_.eof then

response.write "<tr bgcolor="&bg&"><td align=center>"&a&"</td><td>[<a href=add_advisor_thesis_form.asp?id_stu="&orsstu("id_stu")&"&id_thesis="&orsthesis("id_thesis")&">"&ors_("name_stu")&" "&ors_("sur_stu")&"</a>]"'<td>&ors_("name_stu")&" "&ors_("sur_stu")

sqlpo="select * from position_thesis where id_position_thesis='"&orsthesis("id_position_thesis")&"'"
										set orspo=server.createobject("adodb.recordset")
										orspo.open sqlpo,conn,1,3
										if not orspo.eof then

response.write "<td>"&orspo("position_thesis")&"<td>"&orsstu("id_course")'&"<td>"&orsstu("id_academic_semeter")&"/"&orsstu("academic_year")

'�֧��Ң������ѹ����ͺ�ҡ��èͧ��ͧ�ͺ thesis_test
'-----------------------------
													    sqltype="select * from type_test_thesis where id_type_test='"&orsttest("id_type_test")&"'"
													set orstype=server.createobject("adodb.recordset")
													orstype.open sqltype,conn,1,3
															if not orstype.eof then
response.write "<td align=center>"&orstype("test_name")&"<td>"&orsttest("date1")&"-"&orsttest("month1")&"-"&orsttest("year1")
																		end if
															
															
													end if
										end if
										orsstu.movenext
										loop
							end if

orsthesis.movenext
			loop
			end if

orsttest.movenext
loop
else
response.write "<tr bgcolor=#FFFF00><td colspan=6><div align=center>����ա���ͺ "
end if 'orsstu
%>

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

</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: detail_committee_thesis.asp