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">

<link href="bsri2006.css" rel="stylesheet" type="text/css">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
</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 '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

%>
<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")
if id_lecturer="" then
id_lecturer=session("id_lecturer1")
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
%>

<br><br></td></tr>
<tr bgcolor="#FFccCC"><td><div align="center"><strong>�ӴѺ���</td><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>�ѹ����ͺ <br>����ç</td><td><div align="center"><strong>�ѹ����ͺ<br>�ҡ����</td></tr>
<%

sqlthesis="select * from advisor_thesis where id_lecturer='"&id_lecturer&"' order by id_thesis"
set orsthesis=server.createobject("adodb.recordset")
orsthesis.open sqlthesis,conn,1,3
a=0
if not orsthesis.eof then
orsthesis.movefirst
do while not orsthesis.eof

if a mod 2 = 0 then
bg1="#EFEFEF"
else
bg1="#FDFDFD"
end if
			sqlstu="select * from thesis where id_thesis='"&orsthesis("id_thesis")&"'"
			set orsstu=server.createobject("adodb.recordset")
			orsstu.open sqlstu,conn,1,3
			if not orsstu.eof then
							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
										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 "<tr bgcolor="&bg1&"><td>"&a&"</td><td>[<a href=add_advisor_thesis_form.asp?id_stu="&orsstu("id_stu")&"&id_thesis="&orsthesis("id_thesis")&">"&orsthesis("id_thesis")&"</a>]<td>"&ors_("name_stu")&" "&ors_("sur_stu")&"<td>"&orspo("position_thesis")&"<td>"&orsstu("id_academic_semeter")&"/"&orsstu("academic_year")
sqldate="select * from thesis_test where id_thesis='"&orsthesis("id_thesis")&"' and id_type_test='1'"
set orsdate=server.createobject("adodb.recordset")
orsdate.open sqldate,conn,1,3
if not orsdate.eof then
		orsdate.movefirst
		do while not orsdate.eof
				response.write "<td>"&orsdate("date1")&"-"&orsdate("month1")&"-"&orsdate("year1")
		orsdate.movenext
		loop
		else response.write "<td>-"
end if
sqldate2="select * from thesis_test where id_thesis='"&orsthesis("id_thesis")&"' and id_type_test='2'"
set orsdate2=server.createobject("adodb.recordset")
orsdate2.open sqldate2,conn,1,3
if not orsdate2.eof then
		orsdate2.movefirst
		do while not orsdate2.eof
				response.write "<td>"&orsdate2("date1")&"-"&orsdate2("month1")&"-"&orsdate2("year1")
		orsdate2.movenext
		loop
	else response.write "<td>-"
end if

end if
							end if
			end if
			a=a+1
orsthesis.movenext
loop
else
response.write "<tr><td colspan=4><div align=center>No Student Advisor"
end if
%>

</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_advisor_thesis_backup.asp