File Manager

<script language="javascript">	
		function doSubmit()
{
	if( document.form1.noofreport.value == "" )
	{
		alert("��س��ͺ�����§ҹ")
		document.form1.noofreport.focus()
			return false;
	}

if( document.form1.year_edu.value == "" )
	{
		alert("��سҡ�͡�ա���֡��")
		document.form1.year_edu.focus()
			return false;
	}
if( document.form1.semeter.value == "" )
	{
		alert("��سҡ�͡�Ҥ���¹")
		document.form1.semeter.focus()
			return false;
	}
	if( document.form1.id_curriculum.value == "" )
	{
		alert("��سҡ�͡��ѡ�ٵ�")
		document.form1.id_curriculum.focus()
			return false;
	}
if( document.form1.id_type_curri.value == "" )
	{
		alert("��سҡ�͡�ٻẺ����֡��")
		document.form1.id_type_curri.focus()
			return false;
	}
if( document.form1.id_major.value == "" )
	{
		alert("��سҡ�͡�Ң��Ԫ�")
		document.form1.id_major.focus()
			return false;
	}
if( document.form1.datebegin.value == "" )
	{
		alert("��سҡ�͡�ѹ���������§ҹ")
		document.form1.datebegin.focus()
			return false;
	}
if( document.form1.dateend.value == "" )
	{
		alert("��سҡ�͡�ѹ�ش���¢ͧ�����§ҹ")
		document.form1.dateend.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-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="1">

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

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

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

%><tr><td>[<a href=thesis_progress_lecturer.asp>�����Ź��Ե��§ҹ��������˹��</a>][<a href=http://bsris.swu.ac.th/thesis_progress.asp>�ͺ��§ҹ��������˹��</a>][<a href=http://bsris.swu.ac.th/criteria_edu.asp>ࡳ���è�����֡��</a>]

<tr> 
        <td width="892" align="left" valign="top"><div align="center">
<br>
 
	  <form name="form1" method="post" action="add_criteria_edu_form.asp">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr bgcolor=#FFFFCC><td colspan=2 align=center>�Ѵ���ࡳ���è�����֡��</td></tr>
<%
id_major=request.form("id_major1")
id_curriculum=request.form("id_curriculum1")
id_type_curri=request.form("id_type_curri1")
id_table=request.form("id_table")
Response.write id_major&"major<br>"
Response.write id_curriculum&"curriculum<br>"
Response.write id_type_curri
%>
                  <tr> 
                    <td height="20"><div align="right">ࡳ��</div></td>
                    <td> <select name="id_table" style="font-size:16px">
<%

set ors_cr=server.createobject("adodb.recordset")
	sqlmark_cr="select * from rp_table where id_status=1"
	ors_cr.open sqlmark_cr,Conn,1,3
	ors_cr.movefirst
	do while not ors_cr.eof
	%> <option <%
		If CInt(ors_cr("id_table")) =CInt(id_table) Then %> value=<%=id_table%> 
		selected
		<%else%> value=<%=ors_cr("id_table")%>
		
		<%End if%>><%=ors_cr("id_table")%>.
		
		<%=ors_cr("table_detail")%></option>
		<%
		ors_cr.movenext
		loop
		%>
			  </select>
			  </td>
                  </tr>

<tr> 
              <td><div align="right">�Ң�</div></td><td>
			  <select name="id_major1" style="font-size:16px"">
<% 
			  set ors5=server.createobject("adodb.recordset")
	sql5="select * from major where own='1'"
	ors5.open sql5,Conn,1,3
	If Not ors5.eof then
	ors5.movefirst
	do while not ors5.eof
		%> <option <%
		If CInt(ors5("id_major")) =CInt(id_major) Then %> value=<%=id_major%> 
		selected
		<%else%> value=<%=ors5("id_major")%>
		
		<%End if%>>
		
		<%=ors5("major_th")%></option>
		<%
		ors5.movenext
		Loop
	End if
		%>
			  </select>

</tr>
<tr>
			<tr> 
              <td><div align="right">��ѡ�ٵ�</div></td><td>
			  <select name="id_curriculum1" style="font-size:16px">
<% 
			  set ors_o=server.createobject("adodb.recordset")
	 sqlmark_o="select * from curriculum"
	 ors_o.open sqlmark_o,Conn,1,3
	ors_o.movefirst
	do while not ors_o.eof
	%>

<option 
	<%if cint(ors_o("id_curriculum"))=cint(id_curriculum) then%> 
	
		value = <%=cint(id_curriculum)%> 
				selected
	<%else%>
		value =  <%=ors_o("id_curriculum") %>
		<%end if%>> 
		<%=ors_o("curriculum_full")%>
	</option>
				<%
			'response.write "<option value="&ors_o("id_curriculum")&">"&ors_o("curriculum_full")&" </option>"
		ors_o.movenext
		loop
		%>
			  </select>
			  
            </tr>
	       <tr> 
              <td><div align="right">Ẻ</div></td><td>
			  <select name="id_type_curri1" style="font-size:16px"">
<% 
			  set ors_tc=server.createobject("adodb.recordset")
	 sqlmark_tc="select * from type_curriculum"
	 ors_tc.open sqlmark_tc,Conn,1,3
	ors_tc.movefirst
	do while not ors_tc.eof
%>
<option 
	<%if cint(ors_tc("id_type_curri"))=cint(id_type_curri) then%> 
	
		value = <%=cint(id_type_curri)%> 
				selected
	<%else%>
		value =  <%=ors_tc("id_type_curri") %>
		<%end if%>> 
		<%=ors_tc("type_curri_th")%>
	</option>

<%
		'response.write "<option value="&ors_tc("id_type_curri")&">"&ors_tc("type_curri_th")&" </option>"
		ors_tc.movenext
		loop
		%>
			  </select>
 <tr> 
                    <td>&nbsp;</td>
                    <td><input type="submit" name="Submit" value="��Ǩ�ͺ" onmousedown="doSubmit();"> 
                      </td>
                  </tr>
				  </form>
<form name="form1" method="post" action="add_criteria_edu.asp">
<tr><td>���á��� <td>
<%
'major=request.form("id_major")
'curriculum=request.form("id_curriculum")
'type_curri=request.form("id_type_curri")

sql_group="select * from student_group where id_curriculum='"&id_curriculum&"' and id_type_curri='"&id_type_curri&"' and id_major='"&id_major&"' order by id_begin_year asc"
set ors_group=server.createobject("adodb.recordset")
ors_group.open sql_group,conn,1,3
if not ors_group.eof then

ors_group.movefirst
	do while not ors_group.eof

stug=ors_group("id_stugroup")
	sql="select * from student where id_status_edu=1 and id_stugroup='"&stug&"'  order by id_stugroup desc"

set ors=server.createobject("adodb.recordset")
	ors.open sql,conn,1,3
		if not ors.eof Then
			
			'do while not ors.eof
			sql_rp="select * from rp_table_stugroup where id_table='"&id_table&"'and id_stugroup='"&stug&"'"
			Set ors_rp=server.createobject("adodb.recordset")
			ors_rp.open sql_rp,conn,1,3
			If Not ors_rp.eof Then
				response.write "<input type=checkbox name=id_stugroup readonly value="&ors_group("id_stugroup")&" checked disabled>"&ors_group("id_begin_year")
			Else
				response.write "<input type=checkbox name=id_stu_group value="&ors_group("id_stugroup")&">"&ors_group("id_begin_year")
			End if

'orsl.movenext
			'loop
		
		end if
			
		
ors_group.movenext
Loop
Else
				Response.write "���Ե���¹�������"
End if

%>
</tr>
                  </tr>
 <tr> 
                    <td>&nbsp;</td>
                    <td><input type="submit" name="Submit" value="Register" onmousedown="doSubmit();"> 
					<input type="hidden" name="id_table" value=<%=id_table%>>
					<input type="hidden" name="id_major" value=<%=id_major%>>
					<input type="hidden" name="id_curriculum" value=<%=id_curriculum%>>
					<input type="hidden" name="id_type_curri" value=<%=id_type_curri%>>
                      <input type="reset" name="Submit2" value="Reset"></td>
                  </tr>
                 
                </table>

</form>

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

%>
</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: add_criteria_edu_form.asp.bak