File Manager

<% On Error Resume Next %>

<script language="javascript">	
		function doSubmit()
{
	if( document.form1.command_no.value == "" )
	{
		alert("��سҡ�͡�Ţ�������")
		document.form1.command_no.focus()
			return false;
	}
if( document.form1.advisor_name.value == "" )
	{
		alert("��سҡ�͡���ͷ���֡����¹͡")
		document.form1.advisor_name.focus()
			return false;
	}
if( document.form1.date0.value == "" )
	{
		alert("��سҡ�͡�ѹ���ͧ�����")
		document.form1.date0.focus()
			return false;
	}
	}
	function clearText(thefield){
if (thefield.defaultValue==thefield.value)
thefield.value = ""
} 
		</script>
<%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">
<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="0" bordercolor="#FFFFCC" >

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

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

<%
		  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
'*****************************************************************
'  if session("tb_preview") <> 1 or session("tb_edit")=2 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

%>
	<tr><td colspan=2><strong>
            <div align="center"><br>
              <br><div align=center>
              ��䢢������Ҩ��������ԭ�ҹԾ���<br>
              <br>
			  <tr><td colspan=2>
<%
id_stu=request("ids")
session("ids")=id_stu
id_thesis=request("idth")
id_lecturer=request("idl")
sqls="select * from student where id_stu='"&id_stu&"'"
	set orss=server.createobject("adodb.recordset")
	orss.open sqls,conn,1,3
				if not orss.eof then
					response.write orss("id_stu")&"<strong> "&orss("name_stu")&" "&orss("sur_stu")&"</strong> "

set ors4=server.createobject("adodb.recordset")
									 sql4="select * from student_group where id_stugroup='"&orss("id_stugroup")&"'"
									 ors4.open sql4,Conn,1,3
									 if not ors4.eof then

sqlc="select * from curriculum where id_curriculum='"&ors4("id_curriculum")&"'"
									set orsc=server.createobject("adodb.recordset")
									orsc.open sqlc,conn,1,3
									if not orsc.eof then
										   sqlt="select * from type_curriculum where id_type_curri='"&ors4("id_type_curri")&"'"
										   set orst=server.createobject("adodb.recordset")
										   orst.open sqlt,conn,1,3
										   if not orst.eof then
										   'response.write ors4("id_stugroup")
									%>

<%  =orsc("curriculum_sum")%> Ẻ <%=orst("type_curri_th")%> ��� <%=ors4("no_stugroup")%>
										<%
										end if
								end if
								end if
								if not orsnc.eof then
								response.write "[<a href=edit_thesis_stu_form.asp?id_stu="&id_stu&"> ��ԭ�ҹԾ�������� </a>]"
								end if
end if

%>

                      <table width="100%" border="0" cellspacing="0" bordercolor="#FFCCFF">
                        <tr> 
                          <td colspan="2"><table  border="0">
                              <tr> 
                                <td width="15%" bgcolor="#FFFFCC">���ʻ�ԭ�ҹԾ���</td>
                                <td colspan="3" ><%
								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 orst("id_thesis")&"<strong> "
						if not orsnc.eof then
						response.write "[ <a href=edit_thesis_form.asp?id_thesis="&orst("id_thesis")&"&id_stu="&orss("id_stu")&">Edit</a> ] </strong>"
						end if
							%>
							[<a href=edit_abs_form.asp?id_thesis=<%=orst("id_thesis")%>&ids=<%=id_stu%>>ABS</a>]
							</td>
                              </tr>
                              <tr> 
                                <td bgcolor="#FFFFCC">���ͷի��</td>
                                <td colspan="3" ><%
							'response.write "<>orst("id_academic_semeter")&"/"&orst("academic_year")
							response.write orst("thesis_th")
							response.write "<br>- "&orst("thesis_eng")
							
								
								%></td>
                              </tr>
                              <tr> 
                                <td bgcolor="#FFFFCC">�����Ԫ�</td>
                                <td colspan=3><%
								response.write orst("id_course")
								%></td>
                              </tr>
							    <tr> 
                                <td bgcolor="#FFFFCC">�ա���֡��</td>
                                <td colspan=3><%
								response.write orst("id_academic_semeter")&"/"&orst("academic_year")
								%></td>
		<%end if%>
<table>
     <tr> 
        <td colspan="7" bgcolor="#e0a8fd"><div align="left"><strong>�Ҩ����Ǻ�����ԭ�ҹԾ���
		<% sqlfile="select cid,id_stu,cfile from commando where id_stu='"&orss("id_stu")&"' and id_type_command='1'"
		set orsfile=server.createobject("adodb.recordset")
		orsfile.open sqlfile,conn,1,3
			if not orsfile.eof then
				if orsfile("cfile")="0" then
				else
					response.write "[<a href=command/"&orsfile("cfile")&">�����</a>]"
				end if
				end if
		%>
</div>
	</td></tr>
    <tr bgcolor=#FFFFCC> 
							    <td><div align="center"><strong></strong>���</div></td>
                                <td><div align="center"><strong></strong>���˹�</div></td>
                                <td ><div align="left"><strong>����-ʡ��(����)</strong></div></td>
								<td ><div align="left"><strong>����-ʡ��(��¹͡)</strong></div></td>
								<td ><div align="left"><strong>�Ţ�������</strong></div></td>
								<td ><div align="left"><strong>����� �ѹ-��͹-��</strong></div></td>
								<td ><div align="left"><strong>�Ҥ���¹</strong></div></td>
								<td ><div align="left"><strong>Action</strong></div></td>
                              </tr>
 <form name="form1" method="post" action="save_edit_advisor_thesis.asp"  onsubmit="return doSubmit();">                            
<%
	sqla="select * from advisor_thesis where id_stu='"&id_stu&"' and id_thesis='"&id_thesis&"' and id_lecturer ='"&id_lecturer&"' "
	set orsa=server.createobject("adodb.recordset")
		orsa.open sqla,conn,1,3
			if not orsa.eof then

response.write "<tr><td>"&orsa("id_num")
	sqlp="select * from position_advice where id_position='"&orsa("id_position_thesis")&"'"
	set orsp=server.createobject("adodb.recordset")
	orsp.open sqlp,conn,1,3
		if not orsp.eof then
			response.write "<td >"&orsp("position_advice")
		end if
		sqll="select * from lecturer where id_lecturer='"&orsa("id_lecturer")&"' "
		set orsl=server.createobject("adodb.recordset")
		orsl.open sqll,conn,1,3
		if not orsl.eof then
		response.write "<td>"&orsl("name_lec")&"  "&orsl("sur_lec")
														
		end if
	response.write "<td >"&orsa("advisor_out")
	response.write "<td><INPUT TYPE=text NAME=command_no  size=10 value="&orsa("command_no")&">"
	response.write "<td>"
	%>
	<input type="text" size="15" id="datepicker-th" name="date0" value = <%=orsa("command_date")%>/<%=orsa("command_month")%>/<%=orsa("command_year")%> />
	<%
	response.write "<td><INPUT TYPE=text NAME=command_no  size=10 value="&orsa("command_sem")&">"

if not orsnc.eof or id_stu=session("id_stu1") then
														%>
		
<%	end if

'response.write "</tr>"
	idn=orsa("id_num")

else
	response.write "<tr><td colspan=4>No Advisor</tr>"
	idn=0
	end if
'							  response.write "<tr><td>a<td>a"
	%>

<%
'/////////////////
if id_stu=orss("id_stu") then 
  if 1=orss("id_status_edu") then
chk_stu_edit=1
end if
end if
'///////////////////

if not orsnc.eof or chk_stu_edit=1 then%>

<%
	if idn=0 then
	idn=1
	else idn=idn+1 end if
	
	%>
	
	
  <input type="hidden" name="id_stu" value=<%=id_stu%>>
  <input type="hidden" name="id_thesis" value=<%=id_thesis%>>
	<input type="hidden" name="id_lecturer" value=<%=id_lecturer%>>
  <td><input type="submit" name="Submit" value="Save">

</form><%end if%>
</table>
</td>
                        </tr>
                      </table>

</div></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_advisor_thesis_form.asp.bak