ErstellenBarcodeArtikel.p 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  1. DEF VAR cStrichcode1 AS CHAR NO-UNDO.
  2. DEF VAR cStrichcode2 AS CHAR NO-UNDO.
  3. DEF VAR cArtikel AS CHAR NO-UNDO.
  4. DEF VAR ii AS INT NO-UNDO.
  5. DEF VAR iLotNr AS INT NO-UNDO INIT 1000.
  6. DEF VAR dDatum AS DATE NO-UNDO INIT 12/31/2022.
  7. DEF VAR iPos AS INT NO-UNDO.
  8. DEF VAR cPdfName AS CHAR NO-UNDO
  9. INIT 'C:\Entwicklung\TEMP\Huber\Barcodes_CocaCola.pdf'.
  10. { vpr.i INIT }
  11. { vpr.i START }
  12. RUN VIPER_INIT.
  13. FOR EACH Besko NO-LOCK
  14. WHERE Besko.Firma = '1000'
  15. AND Besko.Besnr = 142712,
  16. EACH Besze NO-LOCK OF Besko,
  17. EACH ArtLief NO-LOCK
  18. WHERE ArtLief.Firma = Besko.Firma
  19. AND ArtLief.Knr = Besko.Knr
  20. AND ArtLief.Artnr = Besze.Artnr
  21. AND ArtLief.Inhalt = Besze.Inhalt
  22. AND ArtLief.Jahr = Besze.Jahr,
  23. FIRST Artbez NO-LOCK
  24. WHERE Artbez.Firma = ArtLief.Firma
  25. AND Artbez.Artnr = ArtLief.Artnr
  26. AND Artbez.Inhalt = ArtLief.Inhalt
  27. AND Artbez.Jahr = ArtLief.Jahr.
  28. cStrichcode1 = ''.
  29. cStrichcode2 = ''.
  30. IF ArtLief.Strichcode_GGeb <> '' THEN cStrichcode1 = ArtLief.Strichcode_GGeb.
  31. ELSE
  32. IF ArtLief.Strichcode_VGeb <> '' THEN cStrichcode1 = ArtLief.Strichcode_VGeb.
  33. ELSE
  34. IF ArtLief.Strichcode_KGeb <> '' THEN cStrichcode1 = ArtLief.Strichcode_KGeb.
  35. IF cStrichcode1 = '' THEN NEXT.
  36. DO WHILE LENGTH(cStrichcode1) < 14:
  37. cStrichcode1 = '0' + cStrichcode1.
  38. END.
  39. cStrichcode1 = '01'
  40. + cStrichcode1.
  41. iLotnr = iLotNr + 1.
  42. dDatum = dDatum + 1.
  43. cStrichcode1 = cStrichcode1
  44. + '15'
  45. + STRING(YEAR(dDatum) - 2000,'99')
  46. + STRING(MONTH(dDatum) ,'99')
  47. + STRING(DAY (dDatum) ,'99').
  48. cStrichcode1 = '*' + cStrichcode1 + '*'.
  49. cStrichcode2 = SUBSTITUTE('*10&1Z17&2*',
  50. SUBSTITUTE('Lot-Nr&1', STRING(iLotNr,'99999')),
  51. STRING(Besze.VGeb_Me,'9999') ).
  52. cArtikel = SUBSTITUTE('&1 &2&8&3 &4 &5 &6 &7',
  53. cStrichcode1,
  54. cStrichcode2,
  55. STRING(ArtLief.Artnr ,'999999'),
  56. STRING(ArtLief.Inhalt,'9999'),
  57. STRING(ArtLief.Jahr ,'9999'),
  58. ArtBez.Bez1,
  59. ArtBez.Bez2,
  60. CHR(10) ).
  61. RUN vpr_setCellText( 'Barcode_T1', 'Artikel', cStrichcode1 ).
  62. RUN vpr_setCellText( 'Barcode_T2', 'Artikel', cStrichcode2 ).
  63. /* RUN vpr_setCellText( 'Barcode_T', 'Artikel', '*' + STRING(ArtLief.Artnr,'999999') + '*'). */
  64. RUN vpr_setCellText( 'Artikel_T', 'Artikel', cArtikel ).
  65. RUN vpr_flushGroup ( 'Artikel' ).
  66. ii = ii + 1.
  67. IF ii >= 20 THEN LEAVE.
  68. iPos = vpr_getPageVPos( ).
  69. IF iPos > 2700 THEN RUN vpr_newPage.
  70. END.
  71. RUN vpr_EndDoc.
  72. RUN vpr_SaveDoc ( 'C:\Entwicklung\TEMP\Huber\Barcodes_CocaCola.vpr' ).
  73. RUN vpr_printDoc (0, 0 ).
  74. RUN vpr_printPDF (0, 0, INPUT-OUTPUT cPDFName ).
  75. { vpr.i STOP }
  76. PROCEDURE VIPER_INIT:
  77. RUN vpr_LoadVFR ('huber/barcode_128.vfr').
  78. RUN vpr_ActivateReport ('barcode_128').
  79. RUN vpr_ResetDoc.
  80. /* RUN vpr_SelectPrinter ('HP Color LaserJet Pro MFP M476 PCL 6'). */
  81. RUN vpr_SelectPrinter ('PDF24').
  82. RUN vpr_setPrinterAttrib('duplex=1').
  83. RUN vpr_SetPrinterAttrib('copies=1').
  84. RUN vpr_SetDocAttrib ('PAPERSIZE=A4').
  85. RUN vpr_SetPreviewMode ('Direct').
  86. RUN vpr_setDocTitle ('Barcode_128').
  87. RUN vpr_SetDelimiter (CHR(01)).
  88. RUN vpr_initGroups('').
  89. END PROCEDURE.