Guest User

Untitled

a guest
Feb 18th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. lExportSlozka = 'zz.export'
  2. IF !DIRECTORY(SYS(5) + ADDBS(SYS(2003)) + ADDBS(lExportSlozka)) THEN
  3. WAIT WINDOW 'Vytvarim export slozku...' TIMEOUT 1
  4. MD (SYS(5) + ADDBS(SYS(2003)) + ADDBS(lExportSlozka))
  5. ENDIF
  6.  
  7. lcFile = SYS(5) + ADDBS(SYS(2003)) + ADDBS(lExportSlozka)+"exp"+SYS(2015)+".html"
  8.  
  9. fSaveKrokHtml(alias k ulozeni,lcFile,'nadpis tabulky')
  10. fSaveKrokHtml(dalsi alias k ulozeni,lcFile,'nadpis tabulky')
  11.  
  12. fPrintHtml2(lcFile)
  13.  
  14.  
  15. FUNCTION fSaveKrokHtml(tcAlias,lcFile,lNazev)
  16. LOCAL lhtml
  17. lHtml = cursorToHtml(tcAlias,lNazev)
  18. STRTOFILE(lHtml,lcFile,.t.)
  19. ENDFUNC
  20.  
  21.  
  22. FUNCTION fPrintHtml2(lFile)
  23. DECLARE INTEGER ShellExecute IN shell32.dll ;
  24. INTEGER hndWin, STRING cAction, STRING cFileName, ;
  25. STRING cParams, STRING cDir, INTEGER nShowWin
  26.  
  27. =ShellExecute(0,"OPEN",lFile,"","",1)
  28. ENDFUNC
  29.  
  30. FUNCTION CursorToHTML(tcAlias,lNazev)
  31. LOCAL lcRetVal, lnI, lcColHead, lcCell
  32. LOCAL lcFontSize,lcBorder
  33. SELECT (tcAlias)
  34.  
  35. lRetVal = ""
  36. lcFont = 'font-size: 8pt;'
  37. lcBorder = 'border:1px solid black;'
  38. lcRetVal = '<h4 style="margin:0">'+lNazev+'</h4>'+CHR(10)
  39. lcRetVal = lcRetVal + '<TABLE style="border-collapse:collapse" >'+CHR(10)
  40.  
  41. *hlavicka
  42. lcRetVal = lcRetVal + '<TR style="'+lcFont+lcBorder+'">'
  43. FOR lnI = 1 to FCOUNT()
  44. lcColHead = PROPER(STRTRAN(FIELD(lnI),"_"," "))
  45. lcRetVal = lcRetVal +'<TH style="'+lcFont+lcBorder+'"><b>'+lcColHead + '</b></TH>'
  46. ENDFOR
  47. lcRetVal = lcRetVal + "</TR>"
  48.  
  49. *data
  50. SCAN
  51. lcRetVal = lcRetVal + "<TR>"
  52. FOR lnI = 1 TO FCOUNT()
  53. lcCell = TRANSFORM(EVALUATE(FIELDS(lnI)))+" "
  54. lcRetVal = lcRetVal + '<TD style="'+lcFont+lcBorder+'">'+lcCell + '</TD>'
  55. ENDFOR
  56. lcRetVal = lcRetVal + "</TR>"+CHR(10)
  57. ENDSCAN
  58.  
  59. *konec
  60. lcRetVal = lcRetVal + "</TABLE><br>"+CHR(10)+CHR(10)
  61. RETURN lcRetVal
  62. ENDFUNC
Add Comment
Please, Sign In to add comment