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">
  
  
  <%
'*****************************************************************

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

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

'if id_lecturer="" then
'sqlall=""
'else
'end if
'sqlall="select * from lecturer where status_del="1""
'		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="all_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 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>����������ͺ<td><div align="center"><strong>����-ʡ�Ź��Ե<td><div align="center"><strong>�дѺ<td><div align="center"><strong>��ѡ�ٵ�</tr>
<%
a=0
sqlall= "select * from lecturer where statusdel=1 and id_lecturer<>000 order by id_lecturer desc"
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof Then
		orsall.movefirst
		Do While Not orsall.eof

sqlthesis="select * from committee_thesis where id_lecturer='"&orsall("id_lecturer")&"'"
		set orsthesis=server.createobject("adodb.recordset")
			orsthesis.open sqlthesis,conn,1,3
			if not orsthesis.eof then
			orsthesis.movefirst
			do while not orsthesis.eof

sqlttest="select * from thesis_test where id='"&orsthesis("id")&"' and year1>2565"
		set orsttest=server.createobject("adodb.recordset")
				orsttest.open sqlttest,conn,1,3
	if not orsttest.eof then

response.write "<tr><td>"&orsall("name_lec") '&" "&orsall("sur_lec")
		sql_po="select * from position_thesis where id_position_thesis='"&orsthesis("id_position_thesis")&"'"
		Set ors_po=server.createobject("adodb.recordset")
		ors_po.open sql_po,conn,1,3
			If Not ors_po.eof Then
			Response.write "<td>"&ors_po("position_thesis")
			End If
'������Դ�ҡ���
y=orsttest("month1")

If y > 7 Then
year2=orsttest("year1")
semeter2=1
ElseIf y<8 Then
year2=orsttest("year1")-1
semeter2=2
Else semeter2=3
End if
Response.write "<td>"&orsttest("month1")&"/"&orsttest("date1")&"/"&orsttest("year1")-543
Response.write "<td>"&year2&"<td>"&semeter2
	sql_type="select * from type_test_thesis where id_type_test='"&orsttest("id_type_test")&"'"
		Set ors_type=server.createobject("adodb.recordset")
		ors_type.open sql_type,conn,1,3
			If Not ors_type.eof Then
			Response.write "<td>"&ors_type("test_name")
			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 "<td>"&ors_("name_stu")&" "&ors_("sur_stu")
					'���Ե��ҹ���������ѡ�ٵ��˹
				sql_group="select * from student_group where id_stugroup='"&ors_("id_stugroup")&"'"
							set ors_group=server.createobject("adodb.recordset")
							ors_group.open sql_group,conn,1,3
						if not ors_group.eof Then
							sql_curri="select * from curriculum where id_curriculum='"&ors_group("id_curriculum")&"'"
							set ors_curri=server.createobject("adodb.recordset")
							ors_curri.open sql_curri,conn,1,3
							if not ors_curri.eof then
									
							response.write "<td>"&ors_curri("curriculum_sum")&"</td>"
							End If		
							
							sql_major="select * from major where id_major='"&ors_group("id_major")&"'"
							set ors_major=server.createobject("adodb.recordset")
							ors_major.open sql_major,conn,1,3
							if not ors_major.eof then
							response.write "<td>"&ors_major("major_name")&"</td>"
							End If
						End If 'ors_group.
			End If 'ors_
'��֧�ç���
		End If 'ors_stu
	end If 'orsttest
orsthesis.movenext
loop
else
response.write "<tr bgcolor=#FFFF00><td colspan=6><div align=center>����ա���ͺ "
end if 'orsstu

orsall.movenext
loop
End if'lecturer
%>

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

</table>
</body>
</html>

File Manager

Editing: all_committee_thesis.asp.bak