/beta/admin/top.asp

http://github.com/khaneh/Orders · ASP · 218 lines · 186 code · 21 blank · 11 comment · 19 complexity · 0d627ea51ea7a2840f95541bf5d69456 MD5 · raw file

  1. <%
  2. 'menuItem = request ("menuItem")
  3. 'Response.CacheControl="no-cache"
  4. Response.AddHeader "pragma", "no-cache"
  5. Response.Expires= -1
  6. if (session("AID")="") then
  7. ' session.abandon
  8. response.redirect "login.asp?err= "
  9. end if
  10. 'conStr="DRIVER={SQL Server};SERVER=(local);DATABASE=sefareshat;UID=sefadmin; PWD=5tgb;"
  11. conStr = "Provider=SQLNCLI10.1;Persist Security Info=False;User ID=sefadmin;Initial Catalog=jame;Data Source=.\sqlexpress;PWD=5tgb;"
  12. Set conn = Server.CreateObject("ADODB.Connection")
  13. conn.ConnectionTimeout = 6000
  14. conn.open conStr
  15. AppBgColor = "#BBBBBB" 'Bala:"#99AACC"
  16. AppFgColor = "#C3DBEB" '"#DEEBD9"
  17. SelectedMenuColor = "#0E5499"
  18. UnSelectedMenuColor = "#309261"
  19. SelectedSubMenuColor = "#DEEBD9" '"#C3DBEB"
  20. UnSelectedSubMenuColor = "#0E5499" ' "#609250"
  21. TabWidth=66
  22. ImgTabSelected="/images/tab-1.gif"
  23. ImgTabNotSelected="/images/tab-2.gif"
  24. const CONST_MSG_NONE = -1
  25. const CONST_MSG_INFORM = 0
  26. const CONST_MSG_ALERT = 1
  27. const CONST_MSG_ERROR = 2
  28. '---------------------------------------------
  29. '-------------------------- SHOW ALERT MESSAGE
  30. '---------------------------------------------
  31. sub showAlert( alertMsg , msgStatus )
  32. select case msgStatus
  33. case -1:
  34. response.write "<TABLE width=45% align='center' bgcolor=ffffff style='border: dashed 1px Black'>"
  35. case 0:
  36. response.write "<TABLE width=45% align='center' bgcolor=ffffff style='border: dashed 1px Blue'>"
  37. case 1:
  38. response.write "<TABLE width=45% align='center' bgcolor=ffffdd style='border: dashed 1px Red'>"
  39. case 2:
  40. response.write "<TABLE width=45% align='center' bgcolor=ffeeee style='border: dashed 1px Red'>"
  41. case else:
  42. response.write "<TABLE width=45% align='center' bgcolor=ffffff style='border: dashed 1px Black'>"
  43. end select
  44. response.write "<TR>"
  45. response.write "<td align=center width='10%'>"
  46. response.write "<IMG SRC='../images/alertIcon"& trim(msgStatus) & ".gif' >"
  47. response.write "</td>"
  48. response.write "<TD align=center><BR>"
  49. response.write alertMsg
  50. response.write "<BR><BR></TD>"
  51. response.write "</TR>"
  52. response.write "</TABLE>"
  53. end sub
  54. function sqlSafe (inpStr)
  55. tmpStr=inpStr
  56. tmpStr=replace(tmpStr,"'","`")
  57. tmpStr=replace(tmpStr,"""","`")
  58. sqlsafe=tmpStr
  59. end function
  60. '---------------------------------------------
  61. '---------------------------- Check GL Routine
  62. '---------------------------------------------
  63. dim OpenGL
  64. if Session("OpenGL")="" then
  65. response.write "! ."
  66. response.end
  67. else
  68. OpenGL = Session("OpenGL")
  69. OpenGLName = Session("OpenGLName")
  70. FiscalYear = Session("FiscalYear")
  71. end if
  72. 'Session.Timeout = 300
  73. %>
  74. <HTML>
  75. <HEAD>
  76. <meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
  77. <meta http-equiv="Content-Language" content="fa">
  78. <TITLE> <%=PageTitle%> </TITLE>
  79. <style>
  80. body { font-family: tahoma; font-size: 8pt;}
  81. Input { font-family: tahoma; font-size: 9pt;}
  82. td { font-family: tahoma; font-size: 8pt;}
  83. .tt { font-family: tahoma; font-size: 8pt; color:yellow;}
  84. .tt2 { font-family: tahoma; font-size: 8pt; color:yellow;}
  85. .inputBut { font-family: tahoma; font-size: 8pt; richness: 10}
  86. .t7pt { font-size: 8pt;}
  87. .t8pt { font-size: 10pt;}
  88. .alak a { color: #cccccc; text-decoration: none; font-size: 8pt;}
  89. .alak2 a { color: black; text-decoration: none; font-size: 8pt; }
  90. .GenButton { font-family:tahoma; font-size: 9pt; border: 1px solid black; }
  91. </style>
  92. </HEAD>
  93. <%
  94. CSRName = session("CSRName")
  95. %>
  96. <BODY bgcolor=<%=AppBgColor%> topmargin=0 leftmargin=0><!<% if onunload<>"" then %> onunload="<%=onunload%>"<% end if %> >
  97. <BR>
  98. <TABLE cellspacing=0 cellpadding=0 width=760 border=0 dir=rtl align=center>
  99. <TR >
  100. <TD>
  101. <TABLE cellspacing=0 cellpadding=0>
  102. <TR height=30 class="alak">
  103. <%if SubmenuItem=0 then %>
  104. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  105. <%else %>
  106. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A HREF='default.asp'> </A></TD>
  107. <%end if %>
  108. <%if SubmenuItem=1 then %>
  109. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'><A HREF='userManager.asp' style="color:yellow;"> <BR></A></TD>
  110. <%else %>
  111. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A HREF='userManager.asp'> <BR></A></TD>
  112. <%end if %>
  113. <!--
  114. <%if SubmenuItem=2 then %>
  115. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> <br> </TD>
  116. <%else %>
  117. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A HREF='#'> <br> </A></TD>
  118. <%end if %>
  119. <%if SubmenuItem=3 then %>
  120. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> <BR></TD>
  121. <%else %>
  122. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A HREF='#'> <BR></A></TD>
  123. <%end if %>
  124. <%if SubmenuItem=4 then %>
  125. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  126. <%else %>
  127. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='#'> </A></TD>
  128. <%end if %>
  129. -->
  130. <%if SubmenuItem=5 then %>
  131. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  132. <%else %>
  133. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='sysLock.asp'> </A></TD>
  134. <%end if %>
  135. <%if SubmenuItem=6 then %>
  136. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  137. <%else %>
  138. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='InvItemMng.asp'> </A></TD>
  139. <%end if %>
  140. <%if SubmenuItem=7 then %>
  141. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  142. <%else %>
  143. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='BankerMng.asp'> </A></TD>
  144. <%end if %>
  145. <%if SubmenuItem=8 then %>
  146. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  147. <%else %>
  148. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='Reports.asp'> </A></TD>
  149. <%end if %>
  150. <%if SubmenuItem=9 then %>
  151. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  152. <%else %>
  153. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='AccountInfo.asp'> </A></TD>
  154. <%end if %>
  155. <%if SubmenuItem=10 then %>
  156. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'>ϐ </TD>
  157. <%else %>
  158. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='errorHandler.asp'>ϐ </A></TD>
  159. <%end if %>
  160. <%if SubmenuItem=11 then %>
  161. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabSelected%>'> </TD>
  162. <%else %>
  163. <TD class=tt2 width="<%=TabWidth%>" align=center background='<%=ImgTabNotSelected%>' ><A style='font-size:8pt;' HREF='costs.asp'> </A></TD>
  164. <%end if %>
  165. </TR>
  166. </TABLE>
  167. </TD>
  168. </TR>
  169. <TR BGCOLOR="<%=SelectedMenuColor%>">
  170. <TD height=20 align=left class=alak>
  171. <%
  172. set tmpRS=Conn.Execute ("SELECT Users.RealName FROM Messages INNER JOIN Users ON Messages.MsgFrom = Users.ID WHERE (Messages.MsgTo = "& session("AID") & ") AND (Messages.Urgent = 2) AND (Messages.IsSmall = 0) AND (Messages.IsRead = 0)")
  173. if not tmpRS.EOF then%>
  174. <span style='font-size:12pt;font-weight:bold;align:center;color:yellow;'><marquee dir=rtl width=100%> ! <%=tmpRS("RealName")%> ! </marquee></span>
  175. <%else%>
  176. &nbsp;
  177. <%end if%>
  178. <A HREF="logout.asp"> </A>&nbsp;&nbsp;&nbsp;
  179. </TD>
  180. </TR>
  181. <TR >
  182. <TD >
  183. <TABLE cellspacing=0 cellpadding=0 width=100% height=450 style='border:4px solid <%=SelectedMenuColor%>;' dir=rtl align=center>
  184. <TR>
  185. <TD colspan=2 valign=top bgcolor=<%=AppFgColor%>>
  186. <%
  187. if request.queryString("errmsg")<>"" then
  188. response.write "<br>"
  189. call showAlert (request.queryString("errmsg"),CONST_MSG_ERROR)
  190. response.write "<br>"
  191. end if
  192. if request.queryString("msg")<>"" then
  193. response.write "<br>"
  194. call showAlert (request.queryString("msg"),CONST_MSG_INFORM)
  195. response.write "<br>"
  196. end if
  197. %>