API tools faq
paste
Guest User

Untitled

a guest
Jan 20th, 2019
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.75 KB | None | 0 0
raw download clone embed print report
  1. <%
  2. if Rs.eof then
  3. response.write "<tr><td colspan=""9"">&nbsp;"
  4. call displayNotFoundRecord
  5. response.write "</td></tr>"
  6. Else
  7.  
  8. Do while Rs.AbsolutePage = strPageCurrent And Not Rs.EOF
  9. dim color
  10.  
  11. y = n mod 2
  12. if y > 0 then
  13. color = "EFF4FA"
  14. else
  15. color = "ffffff"
  16. end if
  17.  
  18. if rs.fields.item("if_social_sec") = "True" then
  19. displaytxt = ""
  20. soc_sec_v = soc_sec
  21. else
  22. displaytxt = "none"
  23. soc_sec_v = 0
  24. end if
  25.  
  26. wage_v = rs.fields.item("Total")
  27. salary_v = rs.fields.item("lb_salary")
  28.  
  29. if rs.fields.item("lb_type") = "perunit" then
  30. salary_wage = wage_v
  31. displaytxt_w = "readonly class=""bgdisable"""
  32. displaytxt_lb = "readonly class=""bgdisable"""
  33. else
  34. salary_wage = salary_v
  35. displaytxt_w = ""
  36. displaytxt_lb = ""
  37. end if
  38.  
  39. if_pm = request.form("if_pm")
  40.  
  41. pm_pay = rs.fields.item("lb_pmPay")
  42. if if_pm <> "" then
  43. if_pm_v = pm_pay
  44. disable_txt_pm = "readonly"
  45. else
  46. if_pm_v = 0
  47. disable_txt_pm = "readonly class=""bgdisable"""
  48. end if
  49.  
  50.  
  51.  
  52. %>
  53. <form name="myform2_<%=n%>" action="salary_action.asp" method="POST">
  54. <tr bgcolor="#<%=color%>">
  55. <td class="btline difcursor" nowrap width="7%">&nbsp;<%=rs.fields.item("lb_name")%></td>
  56. <td class="btline center" nowrap width="8%"><input type="text" name="working_day" id="working_day" value="<%=rs.fields.item("MaxOfdays")%>" size="7" <%=displaytxt_w%> onFocus="startCalc(this);" onBlur="stopCalc(this);"></td>
  57. <td class="btline " nowrap width="10%"><input type="text" name="wage" id="wage" value="<%=salary_wage%>" onFocus="startCalc(this);" onBlur="stopCalc(this);"></td>
  58. <td class="btline center" nowrap width="8%"><input type="text" name="OT" id="OT" size="7" value="<%=if_OT_v%>" onFocus="startCalc(this);" onBlur="stopCalc(this);" <%=disabled_ot%>></td>
  59. <td class="btline center" nowrap width="6%" ><input type="text" name="OT_rate" id="OT_rate" size="5" value="<%=rs.fields.item("lbOT")%>" <%'=disabled_txt%> readonly class="bgdisable"></td>
  60. <td class="btline center" nowrap width="6%" ><input type="text" name="OT_amt" id="OT_amt" size="5" value="" <%'=disabled_txt%> readonly class="bgdisable"></td>
  61. <td class="btline center" nowrap width="8%" ><input type="text" name="soc_sec" id="soc_sec" size="7" value="<%=soc_sec_v%>" <%=disable_txt_soc%> onFocus="startCalc(this);" onBlur="stopCalc(this);"></td>
  62. <td class="btline center" nowrap width="8%"><input type="text" name="pmPay" id="pmPay" size="7" value="<%=if_pm_v%>" onFocus="startCalc(this);" onBlur="stopCalc(this);" <%'=disable_txt_pm%> readonly class="bgdisable"></td>
  63. <td class="btline" nowrap style="padding-left: 10px" width="8%" ><input type="text" name="ex_pay" id="ex_pay" size="7" onFocus="startCalc(this);" onBlur="stopCalc(this);"></td>
  64. <td class="btline bold " width="10%"><input type="text" name="net_wage" id="net_wage" size="7" readonly class="bgdisable">
  65. <input type="hidden" name="lb_type" id="lb_type" size="7" value="<%=rs.fields.item("lb_type")%>">
  66. <input type="hidden" name="date_from" id="date_from" size="7" value="<%=date_from_txt%>">
  67. <input type="hidden" name="date_to" id="date_to" size="7" value="<%=date_to_txt%>">
  68. <input type="hidden" name="lb_id" id="lb_id" size="7" value="<%=rs.fields.item("lb_id")%>">
  69. <input type="hidden" value="N" name="edit_salary">
  70. </td>
  71. <td class="btline"><input type="text" name="sar_note" value="" size="14"></td>
  72. <td class="btline" > <input type="submit" value="Save1"></td>
  73. </tr>
  74.  
  75.  
  76. </form>
  77. <%
  78. Rs.movenext
  79. n = n + 1
  80. Loop
  81. End if
  82. Rs.close
  83.  
  84. set Rs=nothing
  85. Call DBConnClose()
  86. %>
  87.  
  88. <tr>
  89. <td colspan="12" align="center" style="padding:10px;">
  90. <input type="submit" value="Save2">
  91. </td>
  92. </tr>
  93.  
  94. <script>
  95. var intervals = {};
  96. function startCalc(sender){
  97. var key = sender.form.name;
  98. intervals[key] = setInterval(function() {
  99. calc(key);
  100. },1);
  101. }
  102. function calc(key){
  103. var oForm = document.forms[key];
  104.  
  105. working_day = oForm.working_day.value;
  106.  
  107. wage = oForm.wage.value;
  108. lb_type_v = oForm.lb_type.value;
  109.  
  110. if (lb_type_v == "daily")
  111. {
  112. wage = wage * working_day;
  113. }
  114. else
  115. {
  116. wage = wage;
  117. }
  118.  
  119. OT_rate = oForm.OT_rate.value;
  120. OT = oForm.OT.value;
  121. OT_amt = OT_rate * OT;
  122. soc_sec = oForm.soc_sec.value;
  123. ex_pay= oForm.ex_pay.value;
  124. pmPay = oForm.pmPay.value;
  125.  
  126. net_wage = (wage * 1) + (OT_amt * 1) - (soc_sec * 1) + (ex_pay * 1) + (pmPay * 1);
  127.  
  128. oForm.OT_amt.value = OT_amt;
  129. oForm.net_wage.value = net_wage.toFixed(2);
  130. }
  131.  
  132. function stopCalc(sender){
  133. var key = sender.form.name;
  134. clearInterval(intervals[key]);
  135. }
  136. </script>
  137.  
  138. <td class="btline center" nowrap width="8%"><input type="text" name="OT" id="OT" size="7" value="<%=if_OT_v%>" onFocus="startCalc(this);" onBlur="stopCalc(this);" <%=disabled_ot%>></td>
  139.  
  140. <td class="btline center" nowrap width="8%"><input type="text" name="OT_<%=rs.fields.item("lb_id")%>" id="OT_<%=rs.fields.item("lb_id")%>" size="7" value="<%=if_OT_v%>" onFocus="startCalc(this);" onBlur="stopCalc(this);" <%=disabled_ot%>></td>
  141.  
  142. 'Open your recordset
  143. Do while Rs.AbsolutePage = strPageCurrent And Not Rs.EOF
  144. x = Request("OT_" & Rs("lb_id"))
  145. '....all your other requests here
  146. 'save to database here etc etc
  147. Loop
  148.  
  149. <!--move form tag outside of table-->
  150. <form name="myform2" action="salary_action.asp" method="POST">
  151. <%
  152. if Rs.eof then
  153. response.write "<tr><td colspan=""9"">&nbsp;"
  154. call displayNotFoundRecord
  155. response.write "</td></tr>"
  156. Else
  157.  
  158. Do while Rs.AbsolutePage = strPageCurrent And Not Rs.EOF
  159. dim color
  160.  
  161. y = n mod 2
  162. if y > 0 then
  163. color = "EFF4FA"
  164. else
  165. color = "ffffff"
  166. end if
  167.  
  168. if rs.fields.item("if_social_sec") = "True" then
  169. displaytxt = ""
  170. soc_sec_v = soc_sec
  171. else
  172. displaytxt = "none"
  173. soc_sec_v = 0
  174. end if
  175.  
  176. wage_v = rs.fields.item("Total")
  177. salary_v = rs.fields.item("lb_salary")
  178.  
  179. if rs.fields.item("lb_type") = "perunit" then
  180. salary_wage = wage_v
  181. displaytxt_w = "readonly class=""bgdisable"""
  182. displaytxt_lb = "readonly class=""bgdisable"""
  183. else
  184. salary_wage = salary_v
  185. displaytxt_w = ""
  186. displaytxt_lb = ""
  187. end if
  188.  
  189. if_pm = request.form("if_pm")
  190.  
  191. pm_pay = rs.fields.item("lb_pmPay")
  192. if if_pm <> "" then
  193. if_pm_v = pm_pay
  194. disable_txt_pm = "readonly"
  195. else
  196. if_pm_v = 0
  197. disable_txt_pm = "readonly class=""bgdisable"""
  198. end if
  199.  
  200.  
  201.  
  202. %>
  203. <!--form tag moved outside of table-->
  204. <tr bgcolor="#<%=color%>">
  205. <td class="btline difcursor" nowrap width="7%">&nbsp;<%=rs.fields.item("lb_name")%></td>
  206. <td class="btline center" nowrap width="8%"><input type="text" name="working_day_<%=rs.fields.item("lb_id")%>" id="working_day_<%=rs.fields.item("lb_id")%>" value="<%=rs.fields.item("MaxOfdays")%>" size="7" <%=displaytxt_w%> onFocus="startCalc(<%=rs.fields.item("lb_id")%>);" onBlur="stopCalc(<%=rs.fields.item("lb_id")%>);"></td>
  207. <td class="btline " nowrap width="10%"><input type="text" name="wage_<%=rs.fields.item("lb_id")%>" id="wage_<%=rs.fields.item("lb_id")%>" value="<%=salary_wage%>" onFocus="startCalc(<%=rs.fields.item("lb_id")%>);" onBlur="stopCalc(<%=rs.fields.item("lb_id")%>);"></td>
  208. <td class="btline center" nowrap width="8%"><input type="text" name="OT_<%=rs.fields.item("lb_id")%>" id="OT_<%=rs.fields.item("lb_id")%>" size="7" value="<%=if_OT_v%>" onFocus="startCalc(<%=rs.fields.item("lb_id")%>);" onBlur="stopCalc(<%=rs.fields.item("lb_id")%>);" <%=disabled_ot%>></td>
  209. <td class="btline center" nowrap width="6%" ><input type="text" name="OT_rate_<%=rs.fields.item("lb_id")%>" id="OT_rate_<%=rs.fields.item("lb_id")%>" size="5" value="<%=rs.fields.item("lbOT")%>" <%'=disabled_txt%> readonly class="bgdisable"></td>
  210. <td class="btline center" nowrap width="6%" ><input type="text" name="OT_amt_<%=rs.fields.item("lb_id")%>" id="OT_amt_<%=rs.fields.item("lb_id")%>" size="5" value="" <%'=disabled_txt%> readonly class="bgdisable"></td>
  211. <td class="btline center" nowrap width="8%" ><input type="text" name="soc_sec_<%=rs.fields.item("lb_id")%>" id="soc_sec_<%=rs.fields.item("lb_id")%>" size="7" value="<%=soc_sec_v%>" <%=disable_txt_soc%> onFocus="startCalc(<%=rs.fields.item("lb_id")%>);" onBlur="stopCalc(<%=rs.fields.item("lb_id")%>);"></td>
  212. <td class="btline center" nowrap width="8%"><input type="text" name="pmPay_<%=rs.fields.item("lb_id")%>" id="pmPay_<%=rs.fields.item("lb_id")%>" size="7" value="<%=if_pm_v%>" onFocus="startCalc(<%=rs.fields.item("lb_id")%>);" onBlur="stopCalc(<%=rs.fields.item("lb_id")%>);" <%'=disable_txt_pm%> readonly class="bgdisable"></td>
  213. <td class="btline" nowrap style="padding-left: 10px" width="8%" ><input type="text" name="ex_pay_<%=rs.fields.item("lb_id")%>" id="ex_pay_<%=rs.fields.item("lb_id")%>" size="7" onFocus="startCalc(<%=rs.fields.item("lb_id")%>);" onBlur="stopCalc(<%=rs.fields.item("lb_id")%>);"></td>
  214. <td class="btline bold " width="10%"><input type="text" name="net_wage_<%=rs.fields.item("lb_id")%>" id="net_wage_<%=rs.fields.item("lb_id")%>" size="7" readonly class="bgdisable">
  215. <input type="hidden" name="lb_type_<%=rs.fields.item("lb_id")%>" id="lb_type_<%=rs.fields.item("lb_id")%>" size="7" value="<%=rs.fields.item("lb_type")%>">
  216. <input type="hidden" name="date_from_<%=rs.fields.item("lb_id")%>" id="date_from_<%=rs.fields.item("lb_id")%>" size="7" value="<%=date_from_txt%>">
  217. <input type="hidden" name="date_to_<%=rs.fields.item("lb_id")%>" id="date_to_<%=rs.fields.item("lb_id")%>" size="7" value="<%=date_to_txt%>">
  218. <input type="hidden" name="lb_id_<%=rs.fields.item("lb_id")%>" id="lb_id_<%=rs.fields.item("lb_id")%>" size="7" value="<%=rs.fields.item("lb_id")%>">
  219. <input type="hidden" value="N" name="edit_salary_<%=rs.fields.item("lb_id")%>">
  220. </td>
  221. <td class="btline"><input type="text" name="sar_note" value="" size="14"></td>
  222. <td class="btline" > <!--submit button removed--></td>
  223. </tr>
  224.  
  225.  
  226. <!--form tag removed-->
  227. <%
  228. Rs.movenext
  229. n = n + 1
  230. Loop
  231. End if
  232. Rs.close
  233.  
  234. set Rs=nothing
  235. Call DBConnClose()
  236. %>
  237.  
  238. <tr>
  239. <td colspan="12" align="center" style="padding:10px;">
  240. <input type="submit" value="Save2">
  241. </td>
  242. </tr>
  243.  
  244. <!--move form tag after end of table-->
  245. </form>
  246.  
  247. <script>
  248. var intervals = {};
  249. function startCalc(key){
  250. intervals[key] = setInterval(function() {
  251. calc(key);
  252. },1);
  253. }
  254. function calc(key){
  255. // var oForm = document.forms[key];
  256.  
  257. working_day = document.getElementById("working_day_" + key).value; //oForm.working_day.value;
  258.  
  259. wage = document.getElementById("wage_" + key).value; //oForm.wage.value;
  260. lb_type_v = document.getElementById("lb_type_" + key).value; //oForm.lb_type.value;
  261.  
  262. if (lb_type_v == "daily")
  263. {
  264. wage = wage * working_day;
  265. }
  266. else
  267. {
  268. wage = wage;
  269. }
  270.  
  271. OT_rate = document.getElementById("OT_rate_" + key).value; //oForm.OT_rate.value;
  272. OT = document.getElementById("OT_" + key).value; //oForm.OT.value;
  273. OT_amt = OT_rate * OT;
  274. soc_sec = document.getElementById("soc_sec_" + key).value; //oForm.soc_sec.value;
  275. ex_pay= document.getElementById("ex_pay_" + key).value; //oForm.ex_pay.value;
  276. pmPay = document.getElementById("pmPay_" + key).value; //oForm.pmPay.value;
  277.  
  278. net_wage = (wage * 1) + (OT_amt * 1) - (soc_sec * 1) + (ex_pay * 1) + (pmPay * 1);
  279.  
  280. document.getElementById("OT_amt_" + key).value = OT_amt; //oForm.OT_amt.value = OT_amt;
  281. document.getElementById("net_wage_" + key).value = net_wage.toFixed(2); //oForm.net_wage.value = net_wage.toFixed(2);
  282. }
  283.  
  284. function stopCalc(key){
  285. clearInterval(intervals[key]);
  286. }
  287. </script>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!