File Manager

<script language="javascript">	
function doSubmit()

{

if( document.form3.id_table.value == "00" )
	{
		alert("��س����͡ࡳ���è�����֡��")
		document.form3.id_table.focus()
			return false;
	}	 
if( document.form3.expect_result.value == "00" )
	{
		alert("��س����͡�Ԩ�������з�")
		document.form3.expect_result.focus()
			return false;
	}

if( document.form10.activity_name.value == "" )
	{
		alert("��سҡ�͡��������´�Ԩ����")
		document.form10.activity_name.focus()
			return false;
	}

if( document.form10.id_progress_report.value == "00" )
	{
		alert("��س����͡�ա���֡��")
		document.form10.id_progress_report.focus()
			return false;
	}
	}
		</script>
<style> 
input[type=submit], input[type=reset] {
  background-color: #ff9999;
  border: none;
  color: white;
  padding: 16px 32px;
  text-decoration: none;
  margin: 4px 2px;
  cursor: pointer;
}
</style>
		<script src="ckeditor/ckeditor.js" type="text/javascript"></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 rel="stylesheet" href="./css/icomoon.css">
	<link rel="stylesheet" href="./css/style.css">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
<link href="./css/bootstrap.min.css" rel="stylesheet">
<link href="./css/templatemo-style.css" rel="stylesheet">
</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">
    <tr>

<td width="892" align="left" valign="top">
<%
'*****************************************************************

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

<%
id_stu=request("id_stu")
If id_stu="" Then
id_stu=request.form("id_stu")
End if
'response.write session("id_stu1") &"aaa"
'response.write "bbb"&id_stu

'*****************************************************************
  'if session("tb_preview") =2 or session("id_stu1") = id_stu  then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ
 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
		  
%>
	
	<div align="left">
	<%'if session("tb_edit")	= 2 then %>
	
	<%'end if%><br>

<table  border="0" align="center" cellpadding="0" cellspacing="0" width="100%">
            <tr > <td>
             <table border=0 width="100%"> 
			  <%
	
			  id_stu=request("id_stu")
			  if id_stu="" then
			  id_stu=session("id_stu1")
			  end If

sql_data="select * from student where id_stu='"&id_stu&"' "
	 set ors_data=server.createobject("adodb.recordset")
	 ors_data.open sql_data,conn,1,3
	 if not ors_data.eof then
%>
              <tr>   <td colspan=3>        
			    <div class="col-1">
<div class="templatemo-content-widget white-bg">
               
                <div class="media">
                  
                  </div>
                  <div class="media-body">
                    <h2 class="media-heading text-uppercase"><%=id_stu%>&#160;&#160;<%=ors_data("name_stu")%>
&#160;&#160;<%=ors_data("sur_stu")%> 
            (<%=ors_data("name_eng")%>&#160; 
            <%=ors_data("sur_eng")%>)</h2><p>
            
<% 
id_status_edu=ors_data("id_status_edu")
			  set ors3=server.createobject("adodb.recordset")
	 sql3="select * from status_edu where id_status_edu='"&id_status_edu&"'"
	 ors3.open sql3,Conn,1,3
			if not ors3.eof then
		response.write ors3("status_edu")
			end if

<% 
id_stugroup=ors_data("id_stugroup")
			  sql_all="select * from student_group where id_stugroup='"&ors_data("id_stugroup")&"' "
		set ors_all=server.createobject("adodb.recordset")
		ors_all.open  sql_all,Conn,1,3
		if not ors_all.eof Then
		id_curriculum=ors_all("id_curriculum")
		id_type_curri=ors_all("id_type_curri")
		id_major=ors_all("id_major")
		response.write ""
			sql_curri="select * from curriculum where id_curriculum='"&ors_all("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  ors_curri("curriculum_full")&" "
				end if
			sqlt="select * from type_curriculum where id_type_curri='"&ors_all("id_type_curri")&"'"
		   set orst=server.createobject("adodb.recordset")
		   orst.open sqlt,conn,1,3
				if not orst.eof Then
				
				response.write orst("type_curri_th")
				end if
					response.write  "  ���  "&ors_all("no_stugroup")&"&#160;"
					id_major=ors_all("id_major")
				sql_major="select * from major  where id_major='"&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 ors_major("major_th")
					end if
		end if
		%>
	             
            </td></tr>
<%
response.write "<tr >"
'���ͻ�ԭ�ҹԾ��� 
id_thesis=request.form("id")
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 "<td>"&orst("id_thesis")
		'response.write "<td><strong>���ͻ�ԭ�ҹԾ���::<strong>"&orst("thesis_th")&"<br>Thesis name::"&orst("thesis_eng")
	Else
'response.write "<td>����բ�����"&id_thesis		
	End if

%>
			<tr><td align=right>
<form name="form12" method="post" action="javascript:history.go(-1)" enctype="multipart/form-data">

<input type="hidden" name="id_thesis" value=<%=id_thesis%>>
	<input type="hidden" name="id_stu" value=<%=id_stu%>>
	<div class="col-xs-12">
	<button class="btn-oth" type="submit" role="button" style="margin-left:10px;">Previous Page</button></div>
				</form>

</td></tr>
           </table>
		   <div class="templatemo-content-widget orange-bg">
                              
                <div class="media">
                  
                  <div class="media-body">
                    <h2 class="media-heading text-uppercase">���Ἱ������¹/�ӻ�ԭ�ҹԾ���</h2>
                    
                  </div>        
                </div>                
              </div>
			  
			  <tr ><td  >
<%
year_edu=request.form("year_edu")
semeter=request.form("semeter")
id_activity=request.form("id_activity")
'Response.write id_activity
id_thesis=request.form("id_thesis")

sql="select * from thesis_plan_activity where id_activity='"&id_activity&"'"
Set ors=server.createobject("adodb.recordset")
ors.open sql,conn,1,3
If Not ors.eof then
%>

<form name="form3" method="post" action="save_thesis_progress_student-1.asp">
<div class="table-responsive">
<table class="table table-striped table-bordered">

<%
'sqlrp="select * from rp_table_stugroup where id_stugroup='"&id_stugroup&"' and id_status=1 order by id_order"
'Set orsrp=server.createobject("adodb.recordset")
'orsrp.open sqlrp,conn,1,3
'Response.write sqlrp
'If Not orsrp.eof Then
'numu=0
%>

<%
'orsrp.movefirst
	
	'Do While Not orsrp.eof 
	'numu=numu+1
	'id_table=orsrp("id_table")
	'Response.write id_table	
	sqlrpt="select * from rp_table where id_table='"&ors("id_table")&"'"
	Set orsrpt=server.createobject("adodb.recordset")
	orsrpt.open sqlrpt,conn,1,3
	If Not orsrpt.eof Then
	%>
		<option value = <%=orsrpt("id_table") %>
			readonly> 
			<%=orsrpt("table_sum")%>
		</option>

<%
	End If
	
'End if

%>
</select>

sqlrpl="select * from rp_activity_relate where id_activity_r='"&ors("id_activity_r")&"'"
Set orsrpl=server.createobject("adodb.recordset")
orsrpl.open sqlrpl,conn,1,3
'Response.write sqlrpl
If Not orsrpl.eof Then

%>
		
		<option value = <%=orsrpl("id_activity_r")%> readonly> 
			<%=orsrpl("activity_name")%>
		</option>
	<%
	'End If
	
End If

%>
</select>

'If id_table1=1 then
%>

	
	
	
	<tr><td align=right width=30%>��������´�Ԩ����<font color="#ff0000">*</font><td align=left valign="top"><textarea rows="4" cols="50" name="activity_name" style="font-size:16px" required><%=ors("activity_name")%></textarea>
	
	<script type="text/javascript">  
  
 CKEDITOR.replace('activity_name', {  
  
 skin   : 'kama', //��˹��ٻẺ˹�ҵ�  
  
 height   : 130, //��˹������٧  
  
 width    : 500,//��˹��������ҧ  
  
 toolbar: 'Minick' //���¡��ҹ ckeditor �ҡ��� config.js  
  
 });  
  
 </script>  
	<tr ><td align=right>���͡�ͺ��§ҹ<font color="#ff0000">*</font>
	<td>
<%
'���ѹ���
date1=datepart("d",date)
			month1=month(now())
			y=year(now())
			y=543+y
y=right(y,4)
y1=right(y,2)
			if date1=1 then
							date1="01" 
							elseif date1=2 then
							date1="02"
							elseif date1=3 then
							date1="03"
							elseif date1=4 then
							date1="04"
							elseif date1=5 then
							date1="05"
							elseif date1=6 then
							date1="06"
							elseif date1=7 then
							date1="07"
							elseif date1=8 then
							date1="08"
							elseif date1=9 then
							date1="09"
							end if
		if month1=1 then
							month1="01" 
							elseif month1=2 then
							month1="02"
							elseif month1=3 then
							month1="03"
							elseif month1=4 then
							month1="04"
							elseif month1=5 then
							month1="05"
							elseif month1=6 then
							month1="06"
							elseif month1=7 then
							month1="07"
							elseif month1=8 then
							month1="08"
							elseif month1=9 then
							month1="09"
							end if
			dateend=y1&""&month1&""&date1
			datebegin=y1&""&month1&""&date1
'���ѹ���
'sql_round="select * from progress_report_thesis where id_curriculum='"&id_curriculum&"' and id_type_curri='"&id_type_curri&"' and id_major='"&id_major&"' and date_plan_end >='"&dateend&"' and datebegin < '"&datebegin&"' order by year_edu, semeter"
sql_round="select * from progress_report_thesis where id_progress_report='"&ors("id_progress_report")&"'"
Set ors_round=server.createobject("adodb.recordset")
ors_round.open sql_round,conn,1,3
'Response.write sql_round

If Not ors_round.eof Then
	 ' idchecktime=1
		%>
<select name="id_progress_report" id="id_progress_report" style="font-size:16px">

<% 'ors_round.movefirst
'Response.write ors_round("id_progress_report")
'do while not ors_round.eof

sql_o_po="select * from curriculum where id_curriculum='"&ors_round("id_curriculum")&"'"
	 set ors_o_po=server.createobject("adodb.recordset")
	 'Response.write sql_o_po
	 ors_o_po.open sql_o_po,conn,1,3
If Not ors_o_po.eof then
	  curriculum_sum= ors_o_po("curriculum_sum")
Else curriculum_sum= "-/"
End if

set ors_tc=server.createobject("adodb.recordset")
	 sqlmark_tc="select * from type_curriculum where id_type_curri='"&ors_round("id_type_curri")&"'"
	 ors_tc.open sqlmark_tc,Conn,1,3
If Not ors_tc.eof then
	 type_curri_th=ors_tc("type_curri_th")
Else type_curri_th= "-/"
End if	
		      			 
     sql_sta="select * from major where id_major='"&ors_round("id_major")&"'"
	  set ors_sta=server.createobject("adodb.recordset")
	  ors_sta.open sql_sta,conn,1,3
	  If Not ors_sta.eof then
			major_name=ors_sta("major_name")
		End if

<option value=<%=ors_round("id_progress_report")%> readonly>������ <%'=curriculum_sum%> <%'=type_curri_th%> <%'=major_name%> <%=ors_round("semeter")%>/<%=ors_round("year_edu")%> ��Ἱ��֧�ѹ��� 
			<%
			'Response.write ors_round("date_begin")&"/"&ors_round("month_begin")&"/"&ors_round("year_begin")&"-"&ors_round("date_end")&"/"&ors_round("month_end")&"/"&ors_round("year_end")
			Response.write ors_round("d_plan_end")&"/"&ors_round("m_plan_end")&"/"&ors_round("y_plan_end")
			%>
		</option>	<%'=ors_round("id_progress_report")%>><%'=curriculum_sum%> <%'=type_curri_th%> (<%'=major_name%>)
<%
'ors_round.movenext
'loop

%>
</select>

<%
		'Else
		'idchecktime=0
End if
%>

<%
			end If
End if
			%>
    
      </div></td>
    
	</tr>
           </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: edit_thesis_progress_student.asp