d-mwst-ansatz.w 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. anadat PROGRESS
  5. */
  6. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  7. {adecomm/appserv.i}
  8. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS dTables
  9. /*------------------------------------------------------------------------
  10. File:
  11. Description: from DATA.W - Template For SmartData objects in the ADM
  12. Input Parameters:
  13. <none>
  14. Output Parameters:
  15. <none>
  16. Modified: February 24, 1999
  17. ------------------------------------------------------------------------*/
  18. /* This .W file was created with the Progress AppBuilder. */
  19. /*----------------------------------------------------------------------*/
  20. /* Create an unnamed pool to store all the widgets created
  21. by this procedure. This is a good default which assures
  22. that this procedure's triggers and internal procedures
  23. will execute in this procedure's storage, and that proper
  24. cleanup will occur on deletion of the procedure. */
  25. CREATE WIDGET-POOL.
  26. /* *************************** Definitions ************************** */
  27. /* Parameters Definitions --- */
  28. /* Local Variable Definitions --- */
  29. DEF VAR xWhere AS CHAR NO-UNDO.
  30. DEF VAR xSort AS CHAR NO-UNDO.
  31. DEF VAR Firma AS CHAR NO-UNDO.
  32. DEF VAR SAktiv AS LOG NO-UNDO INIT FALSE.
  33. /* _UIB-CODE-BLOCK-END */
  34. &ANALYZE-RESUME
  35. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  36. /* ******************** Preprocessor Definitions ******************** */
  37. &Scoped-define PROCEDURE-TYPE SmartDataObject
  38. &Scoped-define DB-AWARE yes
  39. &Scoped-define ADM-SUPPORTED-LINKS Data-Source,Data-Target,Navigation-Target,Update-Target,Commit-Target,Filter-Target
  40. /* Db-Required definitions. */
  41. &IF DEFINED(DB-REQUIRED) = 0 &THEN
  42. &GLOBAL-DEFINE DB-REQUIRED TRUE
  43. &ENDIF
  44. &GLOBAL-DEFINE DB-REQUIRED-START &IF {&DB-REQUIRED} &THEN
  45. &GLOBAL-DEFINE DB-REQUIRED-END &ENDIF
  46. &Scoped-define QUERY-NAME Query-Main
  47. /* Internal Tables (found by Frame, Query & Browse Queries) */
  48. &Scoped-define INTERNAL-TABLES MWSTAns
  49. /* Definitions for QUERY Query-Main */
  50. &Scoped-Define ENABLED-FIELDS MWST_Cd Datum Bez Ansatz Incl Konto
  51. &Scoped-define ENABLED-FIELDS-IN-MWSTAns MWST_Cd Datum Bez Ansatz Incl ~
  52. Konto
  53. &Scoped-Define DATA-FIELDS MWST_Cd Datum Bez Ansatz Incl Konto
  54. &Scoped-define DATA-FIELDS-IN-MWSTAns MWST_Cd Datum Bez Ansatz Incl Konto
  55. &Scoped-Define MANDATORY-FIELDS
  56. &Scoped-Define APPLICATION-SERVICE
  57. &Scoped-Define ASSIGN-LIST
  58. &Scoped-Define DATA-FIELD-DEFS "d-mwst-ansatz.i"
  59. &Scoped-define QUERY-STRING-Query-Main FOR EACH MWSTAns NO-LOCK ~
  60. BY MWSTAns.MWST_Cd ~
  61. BY MWSTAns.Datum INDEXED-REPOSITION
  62. {&DB-REQUIRED-START}
  63. &Scoped-define OPEN-QUERY-Query-Main OPEN QUERY Query-Main FOR EACH MWSTAns NO-LOCK ~
  64. BY MWSTAns.MWST_Cd ~
  65. BY MWSTAns.Datum INDEXED-REPOSITION.
  66. {&DB-REQUIRED-END}
  67. &Scoped-define TABLES-IN-QUERY-Query-Main MWSTAns
  68. &Scoped-define FIRST-TABLE-IN-QUERY-Query-Main MWSTAns
  69. /* Custom List Definitions */
  70. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  71. /* _UIB-PREPROCESSOR-BLOCK-END */
  72. &ANALYZE-RESUME
  73. /* ************************ Function Prototypes ********************** */
  74. {&DB-REQUIRED-START}
  75. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD openQuery dTables _DB-REQUIRED
  76. FUNCTION openQuery RETURNS LOGICAL
  77. ( /* parameter-definitions */ ) FORWARD.
  78. /* _UIB-CODE-BLOCK-END */
  79. &ANALYZE-RESUME
  80. {&DB-REQUIRED-END}
  81. /* *********************** Control Definitions ********************** */
  82. {&DB-REQUIRED-START}
  83. /* Query definitions */
  84. &ANALYZE-SUSPEND
  85. DEFINE QUERY Query-Main FOR
  86. MWSTAns SCROLLING.
  87. &ANALYZE-RESUME
  88. {&DB-REQUIRED-END}
  89. /* ************************ Frame Definitions *********************** */
  90. /* *********************** Procedure Settings ************************ */
  91. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  92. /* Settings for THIS-PROCEDURE
  93. Type: SmartDataObject
  94. Allow: Query
  95. Frames: 0
  96. Add Fields to: Neither
  97. Other Settings: PERSISTENT-ONLY COMPILE APPSERVER DB-AWARE
  98. */
  99. /* This procedure should always be RUN PERSISTENT. Report the error, */
  100. /* then cleanup and return. */
  101. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  102. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  103. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  104. RETURN.
  105. END.
  106. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  107. /* ************************* Create Window ************************** */
  108. &ANALYZE-SUSPEND _CREATE-WINDOW
  109. /* DESIGN Window definition (used by the UIB)
  110. CREATE WINDOW dTables ASSIGN
  111. HEIGHT = 1.62
  112. WIDTH = 46.6.
  113. /* END WINDOW DEFINITION */
  114. */
  115. &ANALYZE-RESUME
  116. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB dTables
  117. /* ************************* Included-Libraries *********************** */
  118. {src/adm2/data.i}
  119. /* _UIB-CODE-BLOCK-END */
  120. &ANALYZE-RESUME
  121. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  122. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  123. /* SETTINGS FOR WINDOW dTables
  124. VISIBLE,,RUN-PERSISTENT */
  125. /* _RUN-TIME-ATTRIBUTES-END */
  126. &ANALYZE-RESUME
  127. /* Setting information for Queries and Browse Widgets fields */
  128. &ANALYZE-SUSPEND _QUERY-BLOCK QUERY Query-Main
  129. /* Query rebuild information for SmartDataObject Query-Main
  130. _TblList = "AnaDat.MWSTAns"
  131. _Options = "NO-LOCK INDEXED-REPOSITION"
  132. _OrdList = "AnaDat.MWSTAns.MWST_Cd|yes,AnaDat.MWSTAns.Datum|yes"
  133. _FldNameList[1] > AnaDat.MWSTAns.MWST_Cd
  134. "MWST_Cd" "MWST_Cd" "Code" ? "integer" ? ? ? ? ? ? yes ? no 10.6 yes ""
  135. _FldNameList[2] > AnaDat.MWSTAns.Datum
  136. "Datum" "Datum" "gültig ab" ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ""
  137. _FldNameList[3] > AnaDat.MWSTAns.Bez
  138. "Bez" "Bez" "Bezeichnung" "x(30)" "character" ? ? ? ? ? ? yes ? no 30 yes ""
  139. _FldNameList[4] > AnaDat.MWSTAns.Ansatz
  140. "Ansatz" "Ansatz" ? ? "decimal" ? ? ? ? ? ? yes ? no 6.4 yes ""
  141. _FldNameList[5] > AnaDat.MWSTAns.Incl
  142. "Incl" "Incl" ? ? "logical" ? ? ? ? ? ? yes ? no 3.4 yes ?
  143. _FldNameList[6] > AnaDat.MWSTAns.Konto
  144. "Konto" "Konto" ? ? "character" ? ? ? ? ? ? yes ? no 12 yes ?
  145. _Design-Parent is WINDOW dTables @ ( 1.14 , 2.6 )
  146. */ /* QUERY Query-Main */
  147. &ANALYZE-RESUME
  148. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK dTables
  149. /* *************************** Main Block *************************** */
  150. SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
  151. IF SAktiv THEN DO:
  152. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  153. END.
  154. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  155. RUN initializeObject.
  156. &ENDIF
  157. /* _UIB-CODE-BLOCK-END */
  158. &ANALYZE-RESUME
  159. /* ********************** Internal Procedures *********************** */
  160. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI dTables _DEFAULT-DISABLE
  161. PROCEDURE disable_UI :
  162. /*------------------------------------------------------------------------------
  163. Purpose: DISABLE the User Interface
  164. Parameters: <none>
  165. Notes: Here we clean-up the user-interface by deleting
  166. dynamic widgets we have created and/or hide
  167. frames. This procedure is usually called when
  168. we are ready to "clean-up" after running.
  169. ------------------------------------------------------------------------------*/
  170. /* Hide all frames. */
  171. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  172. END PROCEDURE.
  173. /* _UIB-CODE-BLOCK-END */
  174. &ANALYZE-RESUME
  175. /* ************************ Function Implementations ***************** */
  176. {&DB-REQUIRED-START}
  177. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION openQuery dTables _DB-REQUIRED
  178. FUNCTION openQuery RETURNS LOGICAL
  179. ( /* parameter-definitions */ ) :
  180. /*------------------------------------------------------------------------------
  181. Purpose: Super Override
  182. Notes:
  183. ------------------------------------------------------------------------------*/
  184. /* xWhere = ''. */
  185. /* DYNAMIC-FUNCTION('setQueryWhere':U, INPUT xWhere). */
  186. /* xSort = ''. */
  187. /* DYNAMIC-FUNCTION('setQuerySort':U, INPUT xSort). */
  188. /* xWhere = ''. */
  189. /* DYNAMIC-FUNCTION('setQueryString':U, INPUT xWhere). */
  190. RETURN SUPER( ).
  191. END FUNCTION.
  192. /* _UIB-CODE-BLOCK-END */
  193. &ANALYZE-RESUME
  194. {&DB-REQUIRED-END}