/beta/cashReg/NewCashReg.asp

http://github.com/khaneh/Orders · ASP · 114 lines · 108 code · 5 blank · 1 comment · 6 complexity · f59d67683afecd7ad6034d892c4d92a4 MD5 · raw file

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1256"%><%
  2. 'CashRegister (9)
  3. PageTitle="ÏÑíÇÝÊ"
  4. SubmenuItem=5
  5. if not Auth(9 , 5) then NotAllowdToViewThisPage()
  6. %>
  7. <!--#include file="top.asp" -->
  8. <!--#include File="../include_farsiDateHandling.asp"-->
  9. <!--#include File="../include_JS_InputMasks.asp"-->
  10. <%
  11. function Link2Trace(OrderNo)
  12. Link2Trace="<A HREF='../order/orderEdit.asp?e=n&radif="& OrderNo & "' target='_balnk'>"& OrderNo & "</A>"
  13. end function
  14. %>
  15. <style>
  16. .RcpMainTable { font-family:tahoma; font-size: 9pt; border: 2px solid #000088; padding:0; direction: RTL; width:500px;}
  17. .RcpMainTable Tr {Height:25px; border: 1px solid black;}
  18. .RcpMainTable Input { font-family:tahoma; font-size: 9pt; width:120px; border: 1px solid black; text-align:right; direction: LTR;}
  19. .RcpMainTable Select { font-family:tahoma; font-size: 9pt; width:120px;}
  20. </style>
  21. <font face="tahoma">
  22. <%
  23. if request("act")="submitNew" then
  24. if request("Cashier")="" OR request("Banker")="" then
  25. response.clear
  26. conn.close
  27. response.redirect "./NewCashReg.asp?errmsg=" & server.urlencode("ÕäÏæÞÏÇÑ íÇ ãÍá ÑÇ ÇäÊÎÇÈ äßÑÏå ÇíÏ...")
  28. end if
  29. mySQL="SELECT * FROM CashRegisters WHERE (IsOpen=1) AND (Cashier='"& request("Cashier") & "')"
  30. Set RS1= conn.Execute(mySQL)
  31. if not RS1.eof then
  32. response.clear
  33. conn.close
  34. response.redirect "./NewCashReg.asp?errmsg=" & server.urlencode("Çíä ÂÞÇí ÕäÏæÞÏÇÑ ÔãÇ ÞÈáÇ íå ÕäÏæÞ ÈÇÒ ÏÇÑäÏ!<br>Çæá ÇÒ åãå ÊßáíÝ Çæä Ñæ ÑæÔä ßäíÏ.")
  35. end if
  36. OpeningAmount=text2value(request("OpeningAmount"))
  37. mySQL="INSERT INTO CashRegisters (Cashier, Banker, OpenDate, NameDate, OpenedBy, IsOpen, IsApproved, OpeningAmount, CashAmountA, CashAmountB, ChequeAmount, ChequeQtty, ShortOverAmount) VALUES ('" &_
  38. request("Cashier") & "', '"& request("Banker") & "', N'"& shamsiToday() & "', N'"& request("NameDate") & "', '"& session("ID") & "', '"& 1 & "', '"& 0 & "', '"& OpeningAmount & "', '"& OpeningAmount & "', 0,0,0,0)"
  39. conn.Execute(mySQL)
  40. %><br><br>
  41. <TABLE width='70%' align='center'>
  42. <TR>
  43. <TD align=center bgcolor=yellow style='border: solid 1pt black'><BR><b><%="Èå ÓáÇãÊí íå ÕäÏæÞ ÌÏíÏ ÇíÌÇÏ ÔÏ ÊÈÑíß ÚÑÖ ãí ßäã."%></b><BR><BR></TD>
  44. </TR>
  45. </TABLE>
  46. <%
  47. else%>
  48. <BR><BR>
  49. <FORM METHOD=POST ACTION="?act=submitNew">
  50. <TABLE class='RcpMainTable' align='center'>
  51. <TR>
  52. <TD align='left'>ÊÇÑíÎ ÕäÏæÞ:</TD>
  53. <TD><INPUT TYPE="text" style="text-align:left;" Name="NameDate" value="<%=shamsiToday()%>" onblur="acceptDate(this)"></TD>
  54. <TD align='left'>&nbsp;</TD>
  55. <TD>&nbsp;</TD>
  56. </TR>
  57. <TR>
  58. <TD align='left'>ÕäÏæÞÏÇÑ:</TD>
  59. <TD><SELECT NAME="Cashier">
  60. <option Value=""> -- ÇäÊÎÇÈ ßäíÏ -- </option>
  61. <% mySQL="SELECT * FROM Users WHERE Display=1 ORDER BY RealName"
  62. Set RS1 = conn.Execute(mySQL)
  63. do while not (RS1.eof)
  64. %> <option Value="<%=RS1("ID")%>"><%=RS1("RealName")%></option>
  65. <%
  66. RS1.movenext
  67. loop
  68. RS1.close
  69. %> </SELECT>
  70. </TD>
  71. <TD align='left'>ãÍá:</TD>
  72. <TD><SELECT NAME="Banker">
  73. <option Value=""> -- ÇäÊÎÇÈ ßäíÏ -- </option>
  74. <% mySQL="SELECT * FROM Bankers WHERE (IsBankAccount <> 1)"
  75. Set RS1 = conn.Execute(mySQL)
  76. do while not (RS1.eof)
  77. %> <option Value="<%=RS1("ID")%>"><%=RS1("Name")%></option>
  78. <%
  79. RS1.movenext
  80. loop
  81. RS1.close
  82. %> </SELECT>
  83. </TD>
  84. </TR>
  85. <TR>
  86. <TD align='left'>ãæÌæÏí Çæáíå:</TD>
  87. <TD><INPUT TYPE="text" Name="OpeningAmount" onblur="setPrice(this);" onKeyPress="return maskNumber(this);"></TD>
  88. <TD align='left'>&nbsp;</TD>
  89. <TD>&nbsp;</TD>
  90. </TR>
  91. <TR>
  92. <TD colspan="4" align='center'><INPUT style="width:70px;text-align:center;" TYPE="submit" value="ÇíÌÇÏ"></TD>
  93. </TR>
  94. </TABLE>
  95. </FORM>
  96. <SCRIPT LANGUAGE="JavaScript">
  97. <!--
  98. document.all.OpeningAmount.focus();
  99. function setPrice(src){
  100. src.value=val2txt(txt2val(src.value));
  101. }
  102. //-->
  103. </SCRIPT>
  104. <%
  105. end if
  106. conn.Close
  107. %>
  108. </font>
  109. <!--#include file="tah.asp" -->