/beta/CRM/include_CRM_Cash.asp

http://github.com/khaneh/Orders · ASP · 98 lines · 89 code · 9 blank · 0 comment · 10 complexity · 132eab15793f190522d6d66f0b421b5e MD5 · raw file

  1. <Tr><Td colspan="3" height="10px">
  2. <STYLE>
  3. .GetCustTbl {font-family:tahoma; background-color: #DDDDDD; width:630; direction: RTL; }
  4. .GetCustTbl td {padding:2; font-size: 9pt; height:25;}
  5. .GetCustInp { font-family:tahoma; font-size: 9pt;}
  6. .CusTableHeader {background-color: #33AACC; text-align: center; font-weight:bold;}
  7. .CustContactTable {font-family:tahoma; width:100%; border:1 solid black; direction: RTL; background-color:#CCCCCC;}
  8. .CustContactTable td {padding:5;}
  9. .CustTable {font-family:tahoma; width:80%; border:1 solid black; direction: RTL; background-color:black;}
  10. .CustTable td {padding:5;}
  11. .CustTable a {text-decoration:none;color:#000088}
  12. .CustTable a:hover {text-decoration:underline;}
  13. .CusTD1 {background-color: #CCCC66; text-align: left; font-weight:bold;}
  14. .CusTD2 {background-color: #DDDDDD; direction: LTR; text-align: right; font-size:9pt;}
  15. .CusTD3 {background-color: #DDDDDD; direction: LTR; text-align: center; font-size:9pt;}
  16. .CusTD4 {background-color: #CCCC66; direction: LTR; text-align: center; font-size:9pt;}
  17. </STYLE>
  18. &nbsp;</Td></Tr>
  19. <Tr>
  20. <Td colspan="3" valign="top" align="center">
  21. <% if Auth(9 , 1) then %><input class="GenButton" type="Button" value=" "onclick="window.open('../cashReg/ReceiptInput.asp?act=getReceipt&selectedCustomer=<%=cusID%>');" <% if AccountIsDisabled then %> disabled <% end if %>> <% end if %>
  22. <% if Auth("A" , 4) then %><input class="GenButton" type="Button" value=" "onclick="window.open('../bank/submitDraft.asp?selectedCustomer=<%=cusID%>');" <% if AccountIsDisabled then %> disabled <% end if %>> <% end if %>
  23. <% if Auth(9 , 2) then %><input class="GenButton" type="button" value=" " onclick="window.open('../cashReg/CashPaymentInput.asp?act=getPayment&selectedCustomer=<%=cusID%>');" <% if AccountIsDisabled then %> disabled <% end if %>> <% end if %>
  24. <% if Auth("A" , 1) then %><input class="GenButton" type="button" value=" " onclick="window.open('../bank/cheq.asp?act=enterCheque&selectedCustomer=<%=cusID%>');" <% if AccountIsDisabled then %> disabled <% end if %>> <% end if %>
  25. <BR><BR><BR>
  26. </Td>
  27. </Tr>
  28. <Tr>
  29. <Td valign="top" align="left">
  30. </Td>
  31. <Td valign="top" align="center">
  32. <table class="CustTable" cellspacing='1'>
  33. <tr>
  34. <td colspan="2" class="CusTableHeader">ʝ</td>
  35. </tr>
  36. <%
  37. mySQL="SELECT Payments.ID, Payments.CreationDate, Users.RealName Creator FROM Payments INNER JOIN Users ON Payments.CreatedBy = Users.ID WHERE (Payments.Account='"& cusID & "') ORDER BY CreationDate DESC, Payments.ID"
  38. Set RS1 = conn.execute(mySQL)
  39. if RS1.eof then
  40. %>
  41. <tr>
  42. <td class="CusTD3"></td>
  43. </tr>
  44. <%
  45. end if
  46. tmpCounter=0
  47. while not RS1.eof
  48. tmpCounter=tmpCounter+1
  49. %>
  50. <tr class="<%if (tmpCounter MOD 2) = 1 then response.write "CusTD3" else response.write "CusTD4" %>">
  51. <td><%=tmpCounter%></td>
  52. <td><a href='../AO/AccountReport.asp?act=showPayment&Payment=<%=RS1("ID")%>' target='_blank'><%=RS1("ID")%><br><%=RS1("Creator")%><br><%=RS1("CreationDate")%></a></td>
  53. </tr>
  54. <%
  55. RS1.moveNext
  56. wend
  57. %>
  58. </table>
  59. </Td>
  60. <Td valign="top" align="center">
  61. <table class="CustTable" cellspacing='1'>
  62. <tr>
  63. <td colspan="2" class="CusTableHeader">ʝ</td>
  64. </tr>
  65. <%
  66. mySQL="SELECT Receipts.ID, Receipts.SYS, Receipts.CreatedDate, Users.RealName AS Creator FROM Receipts INNER JOIN Users ON Receipts.CreatedBy = Users.ID WHERE (Customer='"& cusID & "') ORDER BY Receipts.CreatedDate DESC, Receipts.ID"
  67. Set RS1 = conn.execute(mySQL)
  68. if RS1.eof then
  69. %>
  70. <tr>
  71. <td class="CusTD3"></td>
  72. </tr>
  73. <%
  74. end if
  75. tmpCounter=0
  76. while not RS1.eof
  77. tmpCounter=tmpCounter+1
  78. %>
  79. <tr class="<%if (tmpCounter MOD 2) = 1 then response.write "CusTD3" else response.write "CusTD4" %>">
  80. <td><%=tmpCounter%></td>
  81. <td><a href='../<%=RS1("SYS")%>/AccountReport.asp?act=showReceipt&receipt=<%=RS1("ID")%>' target='_blank'><%=RS1("ID")%><br><%=RS1("Creator")%><br><%=RS1("CreatedDate")%></a></td>
  82. </tr>
  83. <%
  84. RS1.moveNext
  85. wend
  86. %>
  87. </table>
  88. </Td>
  89. </Tr>