File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>e-JOURNAL System's BSRI</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="style.css" rel="stylesheet" type="text/css">

<link href="../Templates/style.css" rel="stylesheet" type="text/css">

</head>

<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#660066"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
          <td valign="top" bgcolor="#7c0974"><div align="left"><img src="images/jbshead2.gif" width="100" height="80"></div></td>
          <td valign="top" bgcolor="#7c0974"><div align="right"><img src="images/jbshead1.gif" width="400" height="80"></div></td>
  </tr>
</table>
</td>
  </tr>
  <tr>
    <td bgcolor="#CC99FF"><div align="right">[<a href="index.asp">HOME</a>][<a href="http://www.swu.ac.th">SWU</a>][<a href="http://bsri.swu.ac.th">BSRI</a>]</div></td>
  </tr>
  <tr>
    <td bgcolor="#E0C1FF"></td>
  </tr>
  <tr>
    <td valign="top" bgcolor="#E0C1FF"><div align="right"></div>
      
      <div align="center">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr bgcolor="#9966CC"> 
            <td width="85%"><div align="center"><font color="#FFFFFF">��óҸԡ�� 
                (Editor )</font></div></td>
            <td width="15%"><div align="right"><font color="#FFFFFF">[<a href="editor_journal.asp">˹�Һ�óҸԡ��</a>][<a href="logout.asp">Logout</a>]</font></div></td>
          </tr>
        </table>
      </div>
      <%
		'id_editor=request("id_editor")
		id_lecturer=session("id_lecturer1")
		sqll="select * from lecturer where id_lecturer='"&id_lecturer&"'"
		Set orsl = Server.CreateObject("ADODB.Recordset")
		orsl.Open sqll, Conn, 1, 3
		if not orsl.eof then
				stat=3
						sqlc="select * from manuscript where id_status='"&stat&"'"
						set orsc=server.createobject("adodb.recordset")
						orsc.open sqlc,conn,1,3
						if not orsc.eof then
							c3=0
							orsc.movefirst
											do while not orsc.eof
								c3=c3+1
							orsc.movenext
							loop
						end if
				response.write "[<a href=editor_journal.asp?stat="&stat&">�������͡�þԨ�ó�PEER REVIEW("&c3&")</a>]"
								stat=4
						sqlc4="select * from manuscript where id_status='"&stat&"'"
						set orsc4=server.createobject("adodb.recordset")
						orsc4.open sqlc4,conn,1,3
						if not orsc4.eof then
							orsc4.movefirst
							c4=0
							do while not orsc4.eof
								c4=c4+1
							orsc4.movenext
							loop
						end if
				response.write "[�š�þԨ�óҢͧPeer REview("&c4&")]"
stat=5
						sqlc5="select * from manuscript where id_status='"&stat&"'"
						set orsc5=server.createobject("adodb.recordset")
						orsc5.open sqlc5,conn,1,3
						if not orsc5.eof then
							orsc5.movefirst
							c5=0
							do while not orsc5.eof
								c5=c5+1
							orsc5.movenext
							loop
						end if
				response.write "[�͡����䢡�Ѻ�ͧ Author("&c5&")]"
stat=8
						sqlc8="select * from manuscript where id_status='"&stat&"'"
						set orsc8=server.createobject("adodb.recordset")
						orsc8.open sqlc8,conn,1,3
						'response.write sqlc8
						c8=0
						if not orsc8.eof then
							
							
							orsc8.movefirst
							do while not orsc8.eof
								c8=c8+1
							orsc8.movenext
							loop
						end if

response.write "[<a href=editor_journal.asp?stat="&stat&">͹��ѵ����վ������("&c8&")</a>]"
		editor_journal=orsl("editor_journal")
if editor_journal="1" then
response.write "[<a href=journal_all.asp?id_editor="&editor_journal&">�����÷��������վ��������</a>]"
end if		
				'**������ʴ��š�ä���ʶҹТͧ������������ٴ�ҹ�� ���� case
sstus=request("stat")
		'select case sstus
			'	case 3
					
			%>	
      <table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#E0C1FF" bgcolor="#F2CCFF">
        <tr bgcolor="#CC99FF"> 
          <td colspan="6"><div align="center">��������´������</div></td>
        </tr>
        <tr bgcolor="#CC66FF"> 
          <td width="7%"><div align="center"><font color="#FFFFFF">���ʺ�����</font></div></td>
          <td width="30%"><div align="center"><font color="#FFFFFF">���������� 
              </font></div></td>
          <td width="30%"><div align="center"><font color="#FFFFFF">Manu Script 
              Name</font></div></td>
          <td width="16%"><div align="center"><font color="#FFFFFF">File Name</font></div></td>
          <td width="9%"><div align="center"><font color="#FFFFFF">Status</font></div></td>
		  <td width="17%"><div align="center"><font color="#FFFFFF">������</font></div></td>
        </tr>
        <%
			sqlc="select * from manuscript where id_status='"&sstus&"'"
						set orsc=server.createobject("adodb.recordset")
						orsc.open sqlc,conn,1,3
						if not orsc.eof then
							orsc.movefirst
							c11=1
							do while not orsc.eof
								c11=c11+1
								
        '********************* 
		%>
        <tr> 
          <td><div align="center"><%=orsc("id_manu")%></div></td>
          <td width="32%"><%=orsc("title_thai")%></td>
          <td><%=orsc("title_eng")%></td>
          <td><%=orsc("filename1")%> [<a href=../journal/upload/<%=orsc("filename1")%> target="_blank">File</a>]</td>
          <td><%
			 sqls="select * from manu_status where id_status='"&orsc("id_status")&"'"
		set orss=server.createobject("adodb.recordset")
		orss.open sqls,conn,1,3
		if not orss.eof then
		id_status=orss("id_status")
		%> <%=orss("id_status")%>.<%=orss("status_e")%><%
				end if
				if sstus=8 then
				response.write "<td>"&orsc("id_journal")&"[<a href=detail_manu.asp?idmanu="&orsc("id_manu")&">��</a>]</td>"
				end if
								'*********************
							orsc.movenext
							loop
						end if
			
				%> </td>
        </tr>
        <tr> 
      </table>
      <%
		else
		response.write "��辺����繺�óҸԡ��"
		end if

%>
      </td>
  </tr>
  <tr>
    <td bgcolor="#CC99FF">&nbsp;</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: journal/editor_journal.asp.bak