bereinigen_batchdruck.p 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. DEF VAR iRecid AS RECID NO-UNDO.
  2. DEF BUFFER bASMutation FOR ASMutation.
  3. FOR EACH ASMutation NO-LOCK
  4. WHERE ASMutation.cStatus = 'A':
  5. iRecid = RECID(ASMutation).
  6. CASE ASMutation.MutArt:
  7. WHEN 'RUESTDRUCK' THEN RUN BEREINIGEN_RUESTDRUCK ( iRecid ).
  8. WHEN 'wsLADEPAPIER' THEN RUN BEREINIGEN_LADEPAPIER ( iRecid ).
  9. WHEN 'wsPALETT' THEN RUN BEREINIGEN_PALETTENDOKUMENT ( iRecid ).
  10. WHEN 'wsLIEFERSCHEIN' THEN RUN BEREINIGEN_LIEFERSCHEIN ( iRecid ).
  11. END.
  12. REPEAT TRANSACTION:
  13. FIND bASMutation EXCLUSIVE-LOCK
  14. WHERE RECID(bASMutation) = iRecid NO-WAIT NO-ERROR.
  15. IF LOCKED bASMutation THEN DO:
  16. MESSAGE 'ASMutation ist locked' VIEW-AS ALERT-BOX.
  17. NEXT.
  18. END.
  19. IF NOT AVAILABLE bASMutation THEN LEAVE.
  20. DELETE bASMutation.
  21. LEAVE.
  22. END.
  23. END.
  24. PROCEDURE BEREINIGEN_RUESTDRUCK:
  25. DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  26. DEF VAR iAufnr AS INT NO-UNDO.
  27. DEF VAR cBenutzer AS CHAR NO-UNDO.
  28. DEF VAR iRuestArt AS INT NO-UNDO.
  29. DEF VAR cFirma AS CHAR NO-UNDO.
  30. DEF BUFFER bAS FOR ASMutation.
  31. DEF BUFFER bTabel FOR Tabel.
  32. FIND bAS NO-LOCK WHERE RECID(bAS) = ipRecid NO-ERROR.
  33. IF NOT AVAILABLE bAS THEN RETURN.
  34. IF bAS.cStatus = 'E' THEN RETURN.
  35. ASSIGN cBenutzer = bAS.cFeld_2
  36. iAufnr = bAS.iKey_1
  37. iRuestArt = bAS.iKey_2
  38. cFirma = bAS.Firma.
  39. FIND FIRST bTabel
  40. WHERE bTabel.Firma = cFirma
  41. AND bTabel.RecArt = 'AUFDRUCK'
  42. AND bTabel.Sprcd = 1
  43. AND bTabel.Int_1 = iAufnr
  44. AND bTabel.Int_3 = iRuestArt NO-ERROR.
  45. IF NOT AVAILABLE bTabel THEN RETURN.
  46. DELETE bTabel.
  47. RETURN.
  48. END.
  49. PROCEDURE BEREINIGEN_LADEPAPIER:
  50. DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  51. DEF VAR iAufnr AS INT NO-UNDO.
  52. DEF VAR cBenutzer AS CHAR NO-UNDO.
  53. DEF VAR iRuestArt AS INT NO-UNDO.
  54. DEF VAR cFirma AS CHAR NO-UNDO.
  55. DEF BUFFER bAS FOR ASMutation.
  56. DEF BUFFER bTabel FOR Tabel.
  57. FIND bAS NO-LOCK WHERE RECID(bAS) = ipRecid NO-ERROR.
  58. IF NOT AVAILABLE bAS THEN RETURN.
  59. IF bAS.cStatus = 'E' THEN RETURN.
  60. ASSIGN cBenutzer = bAS.cFeld_2
  61. iAufnr = bAS.iKey_1
  62. iRuestArt = bAS.iKey_2
  63. cFirma = bAS.Firma.
  64. FIND FIRST bTabel
  65. WHERE bTabel.Firma = cFirma
  66. AND bTabel.RecArt = 'wsLADEPAPIER'
  67. AND bTabel.Sprcd = 1
  68. AND bTabel.Int_1 = iAufnr
  69. AND bTabel.Int_3 = iRuestArt NO-ERROR.
  70. IF NOT AVAILABLE bTabel THEN RETURN.
  71. DELETE bTabel.
  72. RETURN.
  73. END.
  74. PROCEDURE BEREINIGEN_LIEFERSCHEIN:
  75. DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  76. DEF VAR iAufnr AS INT NO-UNDO.
  77. DEF VAR cBenutzer AS CHAR NO-UNDO.
  78. DEF VAR iRuestArt AS INT NO-UNDO.
  79. DEF VAR cFirma AS CHAR NO-UNDO.
  80. DEF BUFFER bAS FOR ASMutation.
  81. DEF BUFFER bTabel FOR Tabel.
  82. FIND bAS NO-LOCK WHERE RECID(bAS) = ipRecid NO-ERROR.
  83. IF NOT AVAILABLE bAS THEN RETURN.
  84. IF bAS.cStatus = 'E' THEN RETURN.
  85. ASSIGN cBenutzer = bAS.cFeld_2
  86. iAufnr = bAS.iKey_1
  87. iRuestArt = bAS.iKey_2
  88. cFirma = bAS.Firma.
  89. FIND FIRST bTabel
  90. WHERE bTabel.Firma = cFirma
  91. AND bTabel.RecArt = 'wsLIEFERSCHEIN'
  92. AND bTabel.Sprcd = 1
  93. AND bTabel.Int_1 = iAufnr
  94. AND bTabel.Int_3 = iRuestArt NO-ERROR.
  95. IF NOT AVAILABLE bTabel THEN RETURN.
  96. DELETE bTabel.
  97. RETURN.
  98. END.
  99. PROCEDURE BEREINIGEN_PALETTENDOKUMENT:
  100. DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  101. DEF VAR iAufnr AS INT NO-UNDO.
  102. DEF VAR cBenutzer AS CHAR NO-UNDO.
  103. DEF VAR iRuestArt AS INT NO-UNDO.
  104. DEF VAR cFirma AS CHAR NO-UNDO.
  105. DEF BUFFER bAS FOR ASMutation.
  106. DEF BUFFER bTabel FOR Tabel.
  107. FIND bAS NO-LOCK WHERE RECID(bAS) = ipRecid NO-ERROR.
  108. IF NOT AVAILABLE bAS THEN RETURN.
  109. IF bAS.cStatus = 'E' THEN RETURN.
  110. ASSIGN cBenutzer = bAS.cFeld_2
  111. iAufnr = bAS.iKey_1
  112. iRuestArt = bAS.iKey_2
  113. cFirma = bAS.Firma.
  114. FIND FIRST bTabel
  115. WHERE bTabel.Firma = cFirma
  116. AND bTabel.RecArt = 'wsPALETT'
  117. AND bTabel.Sprcd = 1
  118. AND bTabel.Int_1 = iAufnr
  119. AND bTabel.Int_3 = iRuestArt NO-ERROR.
  120. IF NOT AVAILABLE bTabel THEN RETURN.
  121. DELETE bTabel.
  122. RETURN.
  123. END.