g-nichtgedruckte.w 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. */
  5. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  6. &Scoped-define FRAME-NAME gnichtgedruckt
  7. {adecomm/appserv.i}
  8. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gnichtgedruckt
  9. /*------------------------------------------------------------------------
  10. File:
  11. Description: from cntnrdlg.w - ADM2 SmartDialog Template
  12. Input Parameters:
  13. <none>
  14. Output Parameters:
  15. <none>
  16. Author:
  17. Created:
  18. ------------------------------------------------------------------------*/
  19. /* This .W file was created with the Progress AppBuilder. */
  20. /*----------------------------------------------------------------------*/
  21. /* Create an unnamed pool to store all the widgets created
  22. by this procedure. This is a good default which assures
  23. that this procedure's triggers and internal procedures
  24. will execute in this procedure's storage, and that proper
  25. cleanup will occur on deletion of the procedure. */
  26. CREATE WIDGET-POOL.
  27. /* *************************** Definitions ************************** */
  28. /* Parameters Definitions --- */
  29. DEFINE INPUT PARAMETER iphAufko AS HANDLE.
  30. /* Local Variable Definitions --- */
  31. DEFINE VARIABLE hQuery AS HANDLE NO-UNDO.
  32. DEFINE VARIABLE hBrowse AS HANDLE NO-UNDO.
  33. DEFINE VARIABLE hCol AS HANDLE NO-UNDO.
  34. DEFINE VARIABLE hBuffer AS HANDLE NO-UNDO.
  35. DEFINE VARIABLE hFeld AS HANDLE NO-UNDO.
  36. DEFINE TEMP-TABLE xAufko NO-UNDO
  37. FIELD Aufnr AS INTEGER LABEL 'Aufnr' FORMAT ' 9999999'
  38. FIELD Knr AS INTEGER LABEL 'Knr' FORMAT ' 999999'
  39. FIELD cKunde AS CHARACTER LABEL 'Kunde' FORMAT 'x(50)'
  40. FIELD Fak_Art AS INTEGER LABEL 'FakArt' FORMAT '99'
  41. FIELD Auf_Sta AS INTEGER LABEL 'Status' FORMAT '99'
  42. FIELD Lief_Datum AS DATE LABEL 'Lieferdatum' FORMAT '99.99.9999'
  43. FIELD Fahrer AS INTEGER LABEL 'Fahrer' FORMAT '999'
  44. INDEX xAufko-k1 AS PRIMARY
  45. Auf_Sta
  46. Fak_Art
  47. Aufnr.
  48. { incl/dlgdefinition.i }
  49. { src/adm2/widgetprto.i }
  50. /* _UIB-CODE-BLOCK-END */
  51. &ANALYZE-RESUME
  52. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  53. /* ******************** Preprocessor Definitions ******************** */
  54. &Scoped-define PROCEDURE-TYPE SmartDialog
  55. &Scoped-define DB-AWARE no
  56. &Scoped-define ADM-CONTAINER DIALOG-BOX
  57. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  58. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  59. &Scoped-define FRAME-NAME gnichtgedruckt
  60. &Scoped-define BROWSE-NAME Br_nichtGedruckt
  61. /* Internal Tables (found by Frame, Query & Browse Queries) */
  62. &Scoped-define INTERNAL-TABLES xAufko
  63. /* Definitions for BROWSE Br_nichtGedruckt */
  64. &Scoped-define FIELDS-IN-QUERY-Br_nichtGedruckt
  65. &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_nichtGedruckt
  66. &Scoped-define SELF-NAME Br_nichtGedruckt
  67. &Scoped-define QUERY-STRING-Br_nichtGedruckt FOR EACH xAufko
  68. &Scoped-define OPEN-QUERY-Br_nichtGedruckt OPEN QUERY {&SELF-NAME} FOR EACH xAufko.
  69. &Scoped-define TABLES-IN-QUERY-Br_nichtGedruckt xAufko
  70. &Scoped-define FIRST-TABLE-IN-QUERY-Br_nichtGedruckt xAufko
  71. /* Definitions for DIALOG-BOX gnichtgedruckt */
  72. /* Standard List Definitions */
  73. &Scoped-Define ENABLED-OBJECTS RECT-2 Br_nichtGedruckt Btn_Cancel Btn_OK
  74. /* Custom List Definitions */
  75. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  76. /* _UIB-PREPROCESSOR-BLOCK-END */
  77. &ANALYZE-RESUME
  78. /* *********************** Control Definitions ********************** */
  79. /* Define a dialog box */
  80. /* Definitions of the field level widgets */
  81. DEFINE BUTTON Btn_Cancel AUTO-END-KEY
  82. LABEL "abbrechen"
  83. SIZE 15 BY 1.
  84. DEFINE BUTTON Btn_OK AUTO-GO
  85. LABEL "Drucken"
  86. SIZE 15 BY 1.
  87. DEFINE RECTANGLE RECT-2
  88. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  89. SIZE 122 BY 13.1.
  90. /* Query definitions */
  91. &ANALYZE-SUSPEND
  92. DEFINE QUERY Br_nichtGedruckt FOR
  93. xAufko SCROLLING.
  94. &ANALYZE-RESUME
  95. /* Browse definitions */
  96. DEFINE BROWSE Br_nichtGedruckt
  97. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_nichtGedruckt gnichtgedruckt _FREEFORM
  98. QUERY Br_nichtGedruckt DISPLAY
  99. /* _UIB-CODE-BLOCK-END */
  100. &ANALYZE-RESUME
  101. WITH NO-ROW-MARKERS SEPARATORS SIZE 114 BY 11.67.
  102. /* ************************ Frame Definitions *********************** */
  103. DEFINE FRAME gnichtgedruckt
  104. Br_nichtGedruckt AT ROW 2.19 COL 7 WIDGET-ID 200
  105. Btn_Cancel AT ROW 15 COL 70
  106. Btn_OK AT ROW 15.05 COL 42
  107. RECT-2 AT ROW 1.48 COL 3 WIDGET-ID 2
  108. SPACE(1.19) SKIP(3.32)
  109. WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER
  110. SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE
  111. TITLE "nicht gedruckte Lieferscheine"
  112. CANCEL-BUTTON Btn_Cancel WIDGET-ID 100.
  113. /* *********************** Procedure Settings ************************ */
  114. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  115. /* Settings for THIS-PROCEDURE
  116. Type: SmartDialog
  117. Allow: Basic,Browse,DB-Fields,Query,Smart
  118. Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  119. Design Page: 1
  120. Other Settings: COMPILE APPSERVER
  121. */
  122. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  123. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gnichtgedruckt
  124. /* ************************* Included-Libraries *********************** */
  125. {src/adm2/containr.i}
  126. /* _UIB-CODE-BLOCK-END */
  127. &ANALYZE-RESUME
  128. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  129. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  130. /* SETTINGS FOR DIALOG-BOX gnichtgedruckt
  131. FRAME-NAME */
  132. /* BROWSE-TAB Br_nichtGedruckt RECT-2 gnichtgedruckt */
  133. ASSIGN
  134. FRAME gnichtgedruckt:SCROLLABLE = FALSE
  135. FRAME gnichtgedruckt:HIDDEN = TRUE.
  136. /* _RUN-TIME-ATTRIBUTES-END */
  137. &ANALYZE-RESUME
  138. /* Setting information for Queries and Browse Widgets fields */
  139. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_nichtGedruckt
  140. /* Query rebuild information for BROWSE Br_nichtGedruckt
  141. _START_FREEFORM
  142. OPEN QUERY {&SELF-NAME} FOR EACH xAufko
  143. _END_FREEFORM
  144. _Query is NOT OPENED
  145. */ /* BROWSE Br_nichtGedruckt */
  146. &ANALYZE-RESUME
  147. &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gnichtgedruckt
  148. /* Query rebuild information for DIALOG-BOX gnichtgedruckt
  149. _Options = "SHARE-LOCK"
  150. _Query is NOT OPENED
  151. */ /* DIALOG-BOX gnichtgedruckt */
  152. &ANALYZE-RESUME
  153. /* ************************ Control Triggers ************************ */
  154. &Scoped-define SELF-NAME gnichtgedruckt
  155. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gnichtgedruckt gnichtgedruckt
  156. ON END-ERROR OF FRAME gnichtgedruckt /* nicht gedruckte Lieferscheine */
  157. DO:
  158. RUN ENDE.
  159. RETURN NO-APPLY.
  160. END.
  161. /* _UIB-CODE-BLOCK-END */
  162. &ANALYZE-RESUME
  163. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gnichtgedruckt gnichtgedruckt
  164. ON WINDOW-CLOSE OF FRAME gnichtgedruckt /* nicht gedruckte Lieferscheine */
  165. DO:
  166. RUN ENDE.
  167. RETURN NO-APPLY.
  168. END.
  169. /* _UIB-CODE-BLOCK-END */
  170. &ANALYZE-RESUME
  171. &Scoped-define SELF-NAME Btn_Cancel
  172. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gnichtgedruckt
  173. ON CHOOSE OF Btn_Cancel IN FRAME gnichtgedruckt /* abbrechen */
  174. DO:
  175. RUN ENDE.
  176. RETURN NO-APPLY.
  177. END.
  178. /* _UIB-CODE-BLOCK-END */
  179. &ANALYZE-RESUME
  180. &Scoped-define SELF-NAME Btn_OK
  181. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gnichtgedruckt
  182. ON CHOOSE OF Btn_OK IN FRAME gnichtgedruckt /* Drucken */
  183. DO:
  184. DEFINE VARIABLE cParam AS CHARACTER NO-UNDO.
  185. DEFINE VARIABLE cRetVal AS CHARACTER NO-UNDO.
  186. DEFINE VARIABLE iAufnr AS INTEGER NO-UNDO.
  187. DEFINE BUFFER bAufko FOR Aufko.
  188. btnOK = TRUE.
  189. BROWSE Br_nichtgedruckt:FETCH-SELECTED-ROW(1).
  190. iAufnr = iphAufko::Aufnr.
  191. FIND bAufko NO-LOCK
  192. WHERE bAufko.Firma = Firma
  193. AND bAufko.Aufnr = iAufnr NO-ERROR.
  194. PUBLISH 'DRUCKEN' ( RECID(bAufko), bAufko.Aufnr, cParam, OUTPUT cRetVal ).
  195. IF cRetVal = '' THEN Br_nichtgedruckt:DELETE-SELECTED-ROW(1).
  196. RETURN NO-APPLY.
  197. END.
  198. /* _UIB-CODE-BLOCK-END */
  199. &ANALYZE-RESUME
  200. &Scoped-define BROWSE-NAME Br_nichtGedruckt
  201. &UNDEFINE SELF-NAME
  202. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gnichtgedruckt
  203. /* *************************** Main Block *************************** */
  204. { incl/dlgmainblock.i }
  205. {src/adm2/dialogmn.i}
  206. /* _UIB-CODE-BLOCK-END */
  207. &ANALYZE-RESUME
  208. /* ********************** Internal Procedures *********************** */
  209. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gnichtgedruckt _ADM-CREATE-OBJECTS
  210. PROCEDURE adm-create-objects :
  211. /*------------------------------------------------------------------------------
  212. Purpose: Create handles for all SmartObjects used in this procedure.
  213. After SmartObjects are initialized, then SmartLinks are added.
  214. Parameters: <none>
  215. ------------------------------------------------------------------------------*/
  216. END PROCEDURE.
  217. /* _UIB-CODE-BLOCK-END */
  218. &ANALYZE-RESUME
  219. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gnichtgedruckt _DEFAULT-DISABLE
  220. PROCEDURE disable_UI :
  221. /*------------------------------------------------------------------------------
  222. Purpose: DISABLE the User Interface
  223. Parameters: <none>
  224. Notes: Here we clean-up the user-interface by deleting
  225. dynamic widgets we have created and/or hide
  226. frames. This procedure is usually called when
  227. we are ready to "clean-up" after running.
  228. ------------------------------------------------------------------------------*/
  229. /* Hide all frames. */
  230. HIDE FRAME gnichtgedruckt.
  231. END PROCEDURE.
  232. /* _UIB-CODE-BLOCK-END */
  233. &ANALYZE-RESUME
  234. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gnichtgedruckt
  235. PROCEDURE enableObject :
  236. /*------------------------------------------------------------------------------
  237. Purpose: Super Override
  238. Parameters:
  239. Notes:
  240. ------------------------------------------------------------------------------*/
  241. hBuffer = TEMP-TABLE xAufko:DEFAULT-BUFFER-HANDLE.
  242. CREATE QUERY hQuery.
  243. hQuery:SET-BUFFERS(iphAufko).
  244. hQuery:QUERY-PREPARE('FOR EACH xAufko NO-LOCK').
  245. hBrowse = BROWSE Br_nichtGedruckt:HANDLE.
  246. BROWSE Br_nichtGedruckt:QUERY = hQuery.
  247. hBrowse:ADD-COLUMNS-FROM(iphAufko).
  248. { incl/dlgenableobject.i }
  249. hQuery:QUERY-OPEN().
  250. END PROCEDURE.
  251. /* _UIB-CODE-BLOCK-END */
  252. &ANALYZE-RESUME
  253. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gnichtgedruckt _DEFAULT-ENABLE
  254. PROCEDURE enable_UI :
  255. /*------------------------------------------------------------------------------
  256. Purpose: ENABLE the User Interface
  257. Parameters: <none>
  258. Notes: Here we display/view/enable the widgets in the
  259. user-interface. In addition, OPEN all queries
  260. associated with each FRAME and BROWSE.
  261. These statements here are based on the "Other
  262. Settings" section of the widget Property Sheets.
  263. ------------------------------------------------------------------------------*/
  264. ENABLE RECT-2 Br_nichtGedruckt Btn_Cancel Btn_OK
  265. WITH FRAME gnichtgedruckt.
  266. VIEW FRAME gnichtgedruckt.
  267. {&OPEN-BROWSERS-IN-QUERY-gnichtgedruckt}
  268. END PROCEDURE.
  269. /* _UIB-CODE-BLOCK-END */
  270. &ANALYZE-RESUME
  271. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gnichtgedruckt
  272. PROCEDURE ENDE :
  273. /*------------------------------------------------------------------------------
  274. Purpose:
  275. Parameters: <none>
  276. Notes:
  277. ------------------------------------------------------------------------------*/
  278. IF btnOK THEN
  279. DO:
  280. END.
  281. IF hQuery:IS-OPEN THEN hQuery:QUERY-CLOSE ().
  282. DELETE OBJECT hQuery.
  283. { incl/dlgende.i }
  284. END PROCEDURE.
  285. /* _UIB-CODE-BLOCK-END */
  286. &ANALYZE-RESUME