/beta/accounting/sood.asp

http://github.com/khaneh/Orders · ASP · 246 lines · 207 code · 26 blank · 13 comment · 14 complexity · 02fdf2c22d7d4e6173bb33cebae241ed MD5 · raw file 

    

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1256"%><%

    2. 

  2. 'Accounting (8)

    3. 

  3. PageTitle= ""

    4. 

  4. SubmenuItem=4

    5. 

  5. if not Auth(8 , 4) then NotAllowdToViewThisPage()

    6. 

  6. 

    7. 

  7. %>

    8. 

  8. <!--#include file="top.asp" -->

    9. 

  9. <!--#include File="../include_farsiDateHandling.asp"-->

    10. 

  10. 

    11. 

  11. <%

    12. 

  12. 

    13. 

  13. '-----------------------------------------------------------------------------------------------------

    14. 

  14. '-------------------------------------------------------------------------------- List GL Super Groups

    15. 

  15. '-----------------------------------------------------------------------------------------------------

    16. 

  16. if request("act")="" then

    17. 

  17. %><BR><BR>

    18. 

  18. 

    19. 

  19. <TABLE dir=rtl align=center width=400 border=0>

    20. 

  20. <TR>

    21. 

  21. 	<TD   align=right><A HREF="AccountInfo.asp">  </A>>   

    22. 

  22. 	</TD>

    23. 

  23. </TR>

    24. 

  24. <TR  bgcolor="eeeeee" >

    25. 

  25. 	<TD  align=center>  

    26. 

  26. 	</TD>

    27. 

  27. </TR>

    28. 

  28. <TR>

    29. 

  29. 	<TD bgcolor="#FFFFFF" width=50%><!----Right---->

    30. 

  30. 	<TABLE width=70% align=center>

    31. 

  31. 	<%

    32. 

  32. 	set RSS=Conn.Execute ("SELECT GLAccountSuperGroups.Name, ISNULL(DERIVEDTBL.total, 0) AS total, GLAccountSuperGroups.ID, GLAccountSuperGroups.Type FROM (SELECT SUM(DERIVEDTBL.Total) AS total, GLAccountGroups.GLSuperGroup FROM (SELECT SUM(DERIVEDTBL.total) AS Total, GLAccounts.GLGroup FROM (SELECT SUM((CONVERT(tinyint, IsCredit) - .5) * 2 * Amount) AS total, GLAccount FROM GLDocs inner join GLRows on GLDocs.id=GLRows.GLDoc where ((GLDocs.IsTemporary=1 or GLDocs.IsChecked=1 or  GLDocs.IsFinalized=1) and GLDocs.deleted=0)  GROUP BY GLAccount, GL HAVING (GL = "& OpenGL&")) DERIVEDTBL INNER JOIN GLAccounts ON DERIVEDTBL.GLAccount = GLAccounts.ID WHERE (GLAccounts.GL = "& OpenGL&") GROUP BY GLAccounts.GLGroup) DERIVEDTBL INNER JOIN GLAccountGroups ON DERIVEDTBL.GLGroup = GLAccountGroups.ID WHERE (GLAccountGroups.GL = "& OpenGL&") GROUP BY GLAccountGroups.GLSuperGroup) DERIVEDTBL RIGHT OUTER JOIN GLAccountSuperGroups ON DERIVEDTBL.GLSuperGroup = GLAccountSuperGroups.ID WHERE (GLAccountSuperGroups.GL = "& OpenGL&" and GLAccountSuperGroups.Type=4) ")

    33. 

  33. 

    34. 

  34. 	Do while not RSS.eof

    35. 

  35. 		%>

    36. 

  36. 		<TR>

    37. 

  37. 		<TD><A HREF="sood.asp?act=groups&SuperGroupID=<%=RSS("ID")%>"><%=RSS("name")%></a></TD>

    38. 

  38. 		<TD><span dir=ltr><%=RSS("total")%></span><br></TD>

    39. 

  39. 		</TR>

    40. 

  40. 		<%

    41. 

  41. 		totalRight = totalRight + clng(RSS("total"))

    42. 

  42. 		RSS.moveNext

    43. 

  43. 	Loop

    44. 

  44. 	%>	

    45. 

  45. 	</TABLE>

    46. 

  46. 	</TD>

    47. 

  47. </TR>

    48. 

  48. <TR>

    49. 

  49. 	<TD bgcolor="#DDDDDD" width=50%><!----left---->

    50. 

  50. 	<TABLE width=70% align=center>

    51. 

  51. 	<%

    52. 

  52. 	set RSS=Conn.Execute ("SELECT GLAccountSuperGroups.Name, ISNULL(DERIVEDTBL.total, 0) AS total, GLAccountSuperGroups.ID, GLAccountSuperGroups.Type FROM (SELECT SUM(DERIVEDTBL.Total) AS total, GLAccountGroups.GLSuperGroup FROM (SELECT SUM(DERIVEDTBL.total) AS Total, GLAccounts.GLGroup FROM (SELECT SUM((CONVERT(tinyint, IsCredit) - .5) * 2 * Amount) AS total, GLAccount FROM GLDocs inner join GLRows on GLDocs.id=GLRows.GLDoc where ((GLDocs.IsTemporary=1 or GLDocs.IsChecked=1 or  GLDocs.IsFinalized=1) and GLDocs.deleted=0)  GROUP BY GLAccount, GL HAVING (GL = "& OpenGL&")) DERIVEDTBL INNER JOIN GLAccounts ON DERIVEDTBL.GLAccount = GLAccounts.ID WHERE (GLAccounts.GL = "& OpenGL&") GROUP BY GLAccounts.GLGroup) DERIVEDTBL INNER JOIN GLAccountGroups ON DERIVEDTBL.GLGroup = GLAccountGroups.ID WHERE (GLAccountGroups.GL = "& OpenGL&") GROUP BY GLAccountGroups.GLSuperGroup) DERIVEDTBL RIGHT OUTER JOIN GLAccountSuperGroups ON DERIVEDTBL.GLSuperGroup = GLAccountSuperGroups.ID WHERE (GLAccountSuperGroups.GL = "& OpenGL&" and GLAccountSuperGroups.Type=5) ")

    53. 

  53. 

    54. 

  54. 	Do while not RSS.eof

    55. 

  55. 		%>

    56. 

  56. 		<TR>

    57. 

  57. 		<TD><A HREF="sood.asp?act=groups&SuperGroupID=<%=RSS("ID")%>"><%=RSS("name")%></a></TD>

    58. 

  58. 		<TD><span dir=ltr><%=RSS("total")%></span><br></TD>

    59. 

  59. 		</TR>

    60. 

  60. 		<%

    61. 

  61. 		totalLeft = totalLeft + clng(RSS("total"))

    62. 

  62. 		RSS.moveNext

    63. 

  63. 	Loop

    64. 

  64. 	%>	

    65. 

  65. 		</TABLE>

    66. 

  66. 	</TD>

    67. 

  67. </TR>

    68. 

  68. <TR  bgcolor="eeeeee" >

    69. 

  69. 	<TD align=center> :  <span dir=ltr><%=totalLeft+totalRight%></span>  

    70. 

  70. 	</TD>

    71. 

  71. </TR>

    72. 

  72. </TABLE>

    73. 

  73. 

    74. 

  74. <% 

    75. 

  75. response.end

    76. 

  76. 

    77. 

  77. 

    78. 

  78. '-----------------------------------------------------------------------------------------------------

    79. 

  79. '------------------------------------------------------------------ List GL Groups under a super group

    80. 

  80. '-----------------------------------------------------------------------------------------------------

    81. 

  81. elseif request("act")="groups" then

    82. 

  82. SuperGroupID = request("SuperGroupID")

    83. 

  83. 

    84. 

  84. set RSS=Conn.Execute ("SELECT SUM(ISNULL(DERIVEDTBL.Total, 0)) AS total, GLAccountGroups.GLSuperGroup, SUM(DERIVEDTBL.accountsCount) AS accountsCount, GLAccountGroups.Name, GLAccountGroups.ID FROM (SELECT SUM(DERIVEDTBL.total) AS Total, GLAccounts.GLGroup, COUNT(GLAccounts.ID) AS accountsCount FROM (SELECT SUM((CONVERT(tinyint, IsCredit) - .5) * 2 * Amount) AS total, GLAccount FROM GLDocs inner join GLRows on GLDocs.id=GLRows.GLDoc where ((GLDocs.IsTemporary=1 or GLDocs.IsChecked=1 or  GLDocs.IsFinalized=1) and GLDocs.deleted=0)  GROUP BY GLAccount, GL HAVING (GL = "& OpenGL & ")) DERIVEDTBL RIGHT OUTER JOIN GLAccounts ON DERIVEDTBL.GLAccount = GLAccounts.ID WHERE (GLAccounts.GL = "& OpenGL & ") GROUP BY GLAccounts.GLGroup) DERIVEDTBL INNER JOIN GLAccountGroups ON DERIVEDTBL.GLGroup = GLAccountGroups.ID WHERE (GLAccountGroups.GL = "& OpenGL & ") AND (GLAccountGroups.GLSuperGroup = "& SuperGroupID & ") GROUP BY GLAccountGroups.GLSuperGroup, GLAccountGroups.Name, GLAccountGroups.ID ")	

    85. 

  85. 

    86. 

  86. %><BR><BR>

    87. 

  87. <TABLE dir=rtl align=center width=600>

    88. 

  88. <TR >

    89. 

  89. 	<TD colspan=4>

    90. 

  90. 		<%

    91. 

  91. 		set RSS2=Conn.Execute ("SELECT *, GLs.ID AS GLID ,GLs.Name AS GLname FROM GLs INNER JOIN GLAccountSuperGroups ON GLs.ID = GLAccountSuperGroups.GL WHERE (GLAccountSuperGroups.GL = "& OpenGL & ") AND (GLAccountSuperGroups.ID = "& SuperGroupID & ")")

    92. 

  92. 		%><A HREF="AccountInfo.asp">  </A>> <A HREF="sood.asp?OpenGL=<%=RSS2("GLID")%>">  </A> > <%=RSS2("name")%>

    93. 

  93. 		<BR><hR>

    94. 

  94. 	</TD>

    95. 

  95. </TR>

    96. 

  96. <TR bgcolor="eeeeee" >

    97. 

  97. 	<TD><!A HREF="default.asp?s=1"><SMALL></SMALL></A></TD>

    98. 

  98. 	<TD><!A HREF="default.asp?s=2"><SMALL>  </SMALL></A></TD>

    99. 

  99. 	<TD><!A HREF="default.asp?s=4"><SMALL>  </SMALL></A></TD>

    100. 

  100. 	<TD><!A HREF="default.asp?s=4"><SMALL>  ()</SMALL></A></TD>

    101. 

  101. </TR>

    102. 

  102. <%

    103. 

  103. tmpCounter=0

    104. 

  104. Do while not RSS.eof

    105. 

  105. 	tmpCounter = tmpCounter + 1

    106. 

  106. 	if tmpCounter mod 2 = 1 then

    107. 

  107. 		tmpColor="#FFFFFF"

    108. 

  108. 		tmpColor2="#FFFFBB"

    109. 

  109. 	Else

    110. 

  110. 		tmpColor="#DDDDDD"

    111. 

  111. 		tmpColor2="#EEEEBB"

    112. 

  112. 	End if 

    113. 

  113. 

    114. 

  114. %>

    115. 

  115. <TR bgcolor="<%=tmpColor%>" >

    116. 

  116. 	<TD><A HREF="sood.asp?act=account&GroupID=<%=RSS("id")%>"><%=RSS("id")%></A></TD>

    117. 

  117. 	<TD><A HREF="sood.asp?act=account&GroupID=<%=RSS("id")%>"><%=RSS("Name")%></A></TD>

    118. 

  118. 	<TD><%=RSS("accountsCount")%></TD>

    119. 

  119. 	<TD><span dir=ltr><%=RSS("total")%></span></TD>

    120. 

  120. </TR>

    121. 

  121. 	  

    122. 

  122. <% 

    123. 

  123. RSS.moveNext

    124. 

  124. Loop

    125. 

  125. %>

    126. 

  126. </TABLE><br>

    127. 

  127. <%

    128. 

  128. 

    129. 

  129. '-----------------------------------------------------------------------------------------------------

    130. 

  130. '---------------------------------------------------------------------- List GL Accounts under a group

    131. 

  131. '-----------------------------------------------------------------------------------------------------

    132. 

  132. elseif request("act")="account" then

    133. 

  133. GroupID = request("GroupID")

    134. 

  134. 

    135. 

  135. set RSS=Conn.Execute ("SELECT GLs.Name AS GLName, GLs.ID AS GLID, GLAccountSuperGroups.ID AS SuperGroupID, GLAccountSuperGroups.Name AS SuperGroupName, GLAccountGroups.ID AS GroupID, GLAccountGroups.Name AS GroupName FROM GLAccountGroups INNER JOIN GLAccountSuperGroups ON GLAccountGroups.GLSuperGroup = GLAccountSuperGroups.ID INNER JOIN GLs ON GLAccountSuperGroups.GL = GLs.ID WHERE (GLAccountSuperGroups.GL = "& OpenGL & ") AND (GLAccountGroups.GL = "& OpenGL & ") AND (GLAccountGroups.ID = "& GroupID & ")")

    136. 

  136. %><BR><BR>

    137. 

  137. <TABLE dir=rtl align=center width=600>

    138. 

  138. <TR >

    139. 

  139. 	<TD colspan=5>

    140. 

  140. 		<%

    141. 

  141. 		set RSS2=Conn.Execute ("SELECT GLAccounts.Name, DERIVEDTBL.totalDebit AS totalDebit, DERIVEDTBL.totalCredit AS totalCredit, GLAccounts.ID FROM (SELECT SUM(CONVERT(tinyint, IsCredit) * Amount) AS totalCredit, SUM((CONVERT(tinyint, IsCredit) - 1) * (- 1) * Amount) AS totalDebit, GLAccount FROM GLDocs inner join GLRows on GLDocs.id=GLRows.GLDoc where ((GLDocs.IsTemporary=1 or GLDocs.IsChecked=1 or  GLDocs.IsFinalized=1) and GLDocs.deleted=0)  GROUP BY GLAccount, GL HAVING (GL = "& OpenGL & ")) DERIVEDTBL RIGHT OUTER JOIN GLAccounts ON DERIVEDTBL.GLAccount = GLAccounts.ID WHERE (GLAccounts.GL = "& OpenGL & ") AND (GLAccounts.GLGroup = "& GroupID & ")")

    142. 

  142. 		

    143. 

  143. 		%><A HREF="AccountInfo.asp">  </A>> <A HREF="sood.asp?OpenGL=<%=RSS("GLID")%>">  </A> > <A HREF="sood.asp?act=groups&SuperGroupID=<%=RSS("SuperGroupID")%>"><%=RSS("SuperGroupName")%></a>  > <%=RSS("GroupName")%>

    144. 

  144. 		<BR><hR>

    145. 

  145. 	</TD>

    146. 

  146. </TR>

    147. 

  147. <TR bgcolor="eeeeee" >

    148. 

  148. 	<TD><!A HREF="default.asp?s=1"><SMALL></SMALL></A></TD>

    149. 

  149. 	<TD><!A HREF="default.asp?s=2"><SMALL> </SMALL></A></TD>

    150. 

  150. 	<TD><!A HREF="default.asp?s=2"><SMALL> </SMALL></A></TD>

    151. 

  151. 	<TD><!A HREF="default.asp?s=2"><SMALL> </SMALL></A></TD>

    152. 

  152. </TR>

    153. 

  153. <%

    154. 

  154. tmpCounter=0

    155. 

  155. Do while not RSS2.eof

    156. 

  156. 	tmpCounter = tmpCounter + 1

    157. 

  157. 	if tmpCounter mod 2 = 1 then

    158. 

  158. 		tmpColor="#FFFFFF"

    159. 

  159. 		tmpColor2="#FFFFBB"

    160. 

  160. 	Else

    161. 

  161. 		tmpColor="#DDDDDD"

    162. 

  162. 		tmpColor2="#EEEEBB"

    163. 

  163. 	End if 

    164. 

  164. 

    165. 

  165. %>

    166. 

  166. <TR bgcolor="<%=tmpColor%>" >

    167. 

  167. 	<TD><A HREF="sood.asp?act=accountRows&accountID=<%=RSS2("id")%>"><%=RSS2("id")%></A></TD>

    168. 

  168. 	<TD><A HREF="sood.asp?act=accountRows&accountID=<%=RSS2("id")%>"><%=RSS2("Name")%></A></TD>

    169. 

  169. 	<TD><span dir=ltr><%=RSS2("totalDebit")%></span></TD>

    170. 

  170. 	<TD><span dir=ltr><%=RSS2("totalCredit")%></span></TD>

    171. 

  171. </TR>

    172. 

  172. 	  

    173. 

  173. <% 

    174. 

  174. RSS2.moveNext

    175. 

  175. Loop

    176. 

  176. %>

    177. 

  177. </TABLE><br>

    178. 

  178. <%

    179. 

  179. 

    180. 

  180. '-----------------------------------------------------------------------------------------------------

    181. 

  181. '-------------------------------------------------------------------------- List Rows of a GL Accounts 

    182. 

  182. '-----------------------------------------------------------------------------------------------------

    183. 

  183. elseif request("act")="accountRows" then

    184. 

  184. account = request("accountID")

    185. 

  185. 

    186. 

  186. set RSS=Conn.Execute ("SELECT * FROM GLDocs inner join GLRows on GLDocs.id=GLRows.GLDoc where ((GLDocs.IsTemporary=1 or GLDocs.IsChecked=1 or  GLDocs.IsFinalized=1) and GLDocs.deleted=0) AND (GL = "& OpenGL & ") AND (GLaccount = "& account & ")")	

    187. 

  187. %><BR><BR>

    188. 

  188. <TABLE dir=rtl align=center width=600>

    189. 

  189. <TR >

    190. 

  190. 	<TD colspan=6>

    191. 

  191. 		<%

    192. 

  192. 		set RSS2=Conn.Execute ("SELECT *, GLAccountGroups.ID AS GroupID, GLAccountGroups.Name AS GroupName, GLAccountSuperGroups.ID AS SuperGroupID, GLAccountSuperGroups.Name AS SuperGroupName, GLs.ID AS GLID, GLs.Name AS GLname, GLAccounts.Name AS name FROM GLs INNER JOIN GLAccountSuperGroups ON GLs.ID = GLAccountSuperGroups.GL INNER JOIN GLAccountGroups ON GLs.ID = GLAccountGroups.GL AND GLAccountSuperGroups.ID = GLAccountGroups.GLSuperGroup INNER JOIN GLAccounts ON GLs.ID = GLAccounts.GL AND GLAccountGroups.ID = GLAccounts.GLGroup WHERE (GLAccounts.GL = "& OpenGL & ") AND (GLAccounts.ID = "& account & ")")

    193. 

  193. 		

    194. 

  194. 		%><A HREF="AccountInfo.asp">  </A>> <A HREF="sood.asp?OpenGL=<%=RSS2("GLID")%>">  </A> > <A HREF="sood.asp?act=groups&SuperGroupID=<%=RSS2("SuperGroupID")%>"><%=RSS2("SuperGroupName")%></a>  > <A HREF="sood.asp?act=account&GroupID=<%=RSS2("GroupID")%>"><%=RSS2("GroupName")%></a>  >  <%=RSS2("Name")%>

    195. 

  195. 		<BR><hR>

    196. 

  196. 	</TD>

    197. 

  197. </TR>

    198. 

  198. <TR bgcolor="eeeeee" >

    199. 

  199. 	<TD><!A HREF="default.asp?s=1"><SMALL></SMALL></A></TD>

    200. 

  200. 	<TD><!A HREF="default.asp?s=2"><SMALL></SMALL></A></TD>

    201. 

  201. 	<TD><!A HREF="default.asp?s=2"><SMALL> </SMALL></A></TD>

    202. 

  202. 	<TD><!A HREF="default.asp?s=2"><SMALL> </SMALL></A></TD>

    203. 

  203. 	<TD><!A HREF="default.asp?s=5"><SMALL></SMALL></A></TD>

    204. 

  204. 	<TD><!A HREF="default.asp?s=5"><SMALL></SMALL></A></TD>

    205. 

  205. </TR>

    206. 

  206. <%

    207. 

  207. tmpCounter=0

    208. 

  208. Do while not RSS.eof

    209. 

  209. 	tmpCounter = tmpCounter + 1

    210. 

  210. 	if tmpCounter mod 2 = 1 then

    211. 

  211. 		tmpColor="#FFFFFF"

    212. 

  212. 		tmpColor2="#FFFFBB"

    213. 

  213. 	Else

    214. 

  214. 		tmpColor="#DDDDDD"

    215. 

  215. 		tmpColor2="#EEEEBB"

    216. 

  216. 	End if 

    217. 

  217. 	

    218. 

  218. 	debit = ""

    219. 

  219. 	credit = ""

    220. 

  220. 	if RSS("IsCredit") then

    221. 

  221. 		credit = RSS("Amount")

    222. 

  222. 	else

    223. 

  223. 		debit = RSS("Amount")

    224. 

  224. 	end if

    225. 

  225. %>

    226. 

  226. <TR bgcolor="<%=tmpColor%>" >

    227. 

  227. 	<TD><!A HREF="sood.asp?act=accountRows&accountID=<%=RSS("id")%>"><%=RSS("id")%></A></TD>

    228. 

  228. 	<TD><!A HREF="sood.asp?act=accountRows&accountID=<%=RSS("id")%>"><%=RSS("Description")%></A></TD>

    229. 

  229. 	<TD><A HREF="javascript:void(0);" onclick="window.open('GLMemoDocShow.asp?id=<%=RSS("GLDoc")%>',null,'menubars=no')"><%=RSS("GLDocID")%></A></TD>

    230. 

  230. 	<TD><%=RSS("GLDocDate")%></TD>

    231. 

  231. 	<TD><%=debit%></TD>

    232. 

  232. 	<TD><%=credit%></TD>

    233. 

  233. </TR>

    234. 

  234. 	  

    235. 

  235. <% 

    236. 

  236. RSS.moveNext

    237. 

  237. Loop

    238. 

  238. %>

    239. 

  239. </TABLE><br>

    240. 

  240. <%

    241. 

  241. end if

    242. 

  242. 

    243. 

  243. 

    244. 

  244. %>

    245. 

  245. 

    246. 

  246. <!--#include file="tah.asp" -->
    247.