?????? ????????????? ??????? ?????????? ??????, ???????????? ?????????? ? rtf, pdf ? ???????? ?? ??????????? ?????

1

• ?????? ????????????? ??????? ?????????? ??????,
  ???????????? ?????????? ? rtf, pdf ? ???????? ??
  ??????????? ?????

????????? ???? ??????? ?????????? ??????
?????????????? ?????????? ? ???????????
????? mindiyarov_at_parus.ru
2
??????? ??????????????? ? ???????????

• ??????????? ????????????
• ????????? ? ????????? Apache FOP
• ????????? ??????? ? ??????? MS Word, RTF, PDF,
  HTML
• ???????? ??????? ?? ??????????? ?????
• ????????????? ??????? ?????????? ??????

3
??????????? ????????????

• ???????? ?????? ????????????????? ?????? ???????
  ???????

4
??????????? ????????????

• ????????? ?????????

5
??????????? ????????????

• ???????? ????? ? ??????? PDF

6
??????????? ????????????

• ??? ? ??????? RTF

7
??????????? ????????????

• ??? ? ??????? MS Word

8
??????????? ????????????

• ?????? ???????? ????????????????? ?????? Crystal
  Reports ?? ??????? ?? ????? 8
• ?????????? ???????? ???????????????? ??????????,
  ??????? ????????? ???? ?????????? ?????? ?
  ???????????? ????????? ? PDF, RTF.
• ??????????? Crystal Reports
• ??????, ??? ??????????
• ????????? ??? ????,
• ??? ????????????
• ? ?????? ????????????

9
??????????? ????????????

• ?????? ???????? ????????????????? ?????? Crystal
  Reports ?? ??????? ?? ????? 8
• ??? ????????? ??????.
• ??? ????????? mutt ? linux

10
??????????? ????????????

• ??? ???????? e-mail c ?????????? ?? ???????
  ??????? ????????? ?????????? ??????????? ???????
  ??????? ??????????, ??????? ?? ?????????
  02.12.2011.
• ?????? ?? ???????? http//www.parus.ru/docs/2_02_
  chechnev_122011.pps

11
???????????? ????????????

• ?????? ?????????? ?????? ???????
• ??? ?????? ???????????????? ??????? ?????????
  ????? ?????? ? ???????

12
??????????? ????????????

• ?????? ?????????? ?????? ???????
• ????? ?????????? ?????? ? ??????? ??????????
• ????? ? ????? ?????? ??????? ?????? ???????

13
??????????? ????????????

• ?????? ?????????? ?????? ???????
• ? ????????? ???????? ??????? ????? ? ?????? ?
  ?????????? ?????????? ????????? (???????)

14
??????????? ????????????

• ?????? ?????????? ?????? ???????
• ????? ?????? ?????

15
??????????? ????????????

• ?????? ?????????? ?????? ???????
• ?????? ?????? ????? ?????????, ??? ???????????,
  ??????? ???????? ????? ??????? MS Excel, ???????
  ????? ???????????.
• ???? ??? ????????????? ? ????????? ???????????
  ?????? ????????????????? ?????? ??????????, ?? ??
  ????? ???????? ????? ?? ???????? ?????????
  ??????????? ?????? ??????

16
????????? ? ????????? Apache FOP

• ??????? ?????????? ?????? Java SE Runtime
  Environment
• http//www.oracle.com/technetwork/java/javase/down
  loads/index.html, ????????, http//www.oracle.co
  m/technetwork/java/javase/downloads/jre7u9-downloa
  ds-1859586.html
• ??????? ?????????? ???????? ?????????? ??????
  Apache FOPhttp//xmlgraphics.apache.org/fop/downl
  oad.html, ????????, http//apache-mirror.rbc.ru/
  pub/apache/xmlgraphics/fop/binaries/fop-1.0-bin.zi
  p

17
????????? ? ????????? Apache FOP

• ?????????? JAVA
• ?????????? FOP ? ?????????? c\fop
• ????????? ????????????????? ???????? c\fop\fop.b
  at C\fop\examples\fo\basic\border.fo
  c\fop\border.pdf

18
????????? ? ????????? Apache FOP

• ????????? ?????? ??????? ???????
• ???????? ??????? c\fop\fonts
• ?????????? TTF ??????, ??????? ?? ??????
  ???????????? ? ??????? ? ????? c\fop\fonts.
  ???????? arial.ttf, arialbd.ttf, arialbi.ttf,
  ariali.ttf, arialn.ttf, arialnb.ttf,
  arialnbi.ttf, arialni.ttf, calibri.ttf,
  calibrib.ttf, calibrii.ttf, calibriz.ttf,
  cour.ttf, courbd.ttf, courbi.ttf, couri.ttf,
  symbol.ttf, tahoma.ttf, tahomabd.ttf, times.ttf,
  timesbd.ttf, timesbi.ttf, timesi.ttf.
• ?????????? ???? c\fop\fop.bat ?
  c\fop\makefont.bat
• ? ????????? ?????? ????? ????????
• "JAVACMD" JAVAOPTS LOGCHOICE LOGLEVEL -cp
  "LOCALCLASSPATH" FOP_OPTS org.apache.fop.cli.M
  ain FOP_CMD_LINE_ARGS
• ??
• "JAVACMD" JAVAOPTS LOGCHOICE LOGLEVEL -cp
  "LOCALCLASSPATH" FOP_OPTS org.apache.fop.fonts
  .apps.TTFReader FOP_CMD_LINE_ARGS
• ???????? ???? c\fop\makefonts.bat ??????????
  ??????????for i in (c\fop\fonts\.ttf) do
  c\fop\makefont.bat i i.xml

19
????????? ? ????????? Apache FOP

• ????????? ?????? ??????? ???????
• ????????? ???? c\fop\makefonts.bat
• ???????? ? ????????? ???? c\fop\conf\fop.xconf
  ?????? ???? ltfontsgt ???????? ???? ??? ????
  ???????
• ltfont metrics-url"c\fop\fonts\arial.ttf.xml"
• kerning"yes"
• embed-url"c\fop\fonts\arial.ttf"gt
• ltfont-triplet name"Arial"
  style"normal" weight"normal"/gt
• ltfont-triplet name"ArialMT"
  style"normal" weight"normal"/gt
• lt/fontgt

20
????????? ? ????????? Apache FOP

• ????????? ?????? ??????? ???????
• ???????? ???????????? ???????????
• ???????? ???? c\fop\test.fo
• lt?xml version"1.0" encoding"windows-1251"?gt
• ltforoot xmlnsfo"http//www.w3.org/1999/XSL/Form
  at"gt
• ltfolayout-master-setgt
• ltfosimple-page-master master-name"first"gt
• ltforegion-body/gt
• lt/fosimple-page-mastergt
• lt/folayout-master-setgt
• ltfopage-sequence master-reference"first"gt
• ltfoflow flow-name"xsl-region-body"gt
• ltfoblock text-align"start"
  font-family"Arial" gt
• ????????
• lt/foblockgt
• lt/foflowgt
• lt/fopage-sequencegt
• lt/forootgt

21
????????? ? ????????? Apache FOP

• ????????? ?????? ??????? ???????
• ????????? ???????
• C\fop\fop.bat -c c\fop\conf\fop.xconf
  c\fop\test.fo c\fop\test.pdf
• ?????????? ???? c\fop\test.pdf

22
????????? ? ????????? Apache FOP

• ???????? ??????? Apache FOP ?? ?????? Oracle
• ???????? ?????? ????????????
• CREATE USER "FOP" PROFILE "DEFAULT"
• IDENTIFIED BY "parusina" DEFAULT TABLESPACE
  "USERS"
• QUOTA UNLIMITED
• ON "USERS"
• ACCOUNT UNLOCK
• GRANT "CONNECT" TO "FOP"
• GRANT "JAVAUSERPRIV" TO "FOP"
• GRANT CREATE PROCEDURE TO "FOP
• GRANT CREATE TABLE TO "FOP
• ???????? ???? loadjars.bat ?????????? ??????????
• c\oracle\ora10\bin\loadjava -user
  fop/parusina_at_DATABASE -verbose -force -order
  -resolve -recursivejars c\fop\build\.jar
  c\fop\lib\.jar -fileout loaderrors.txt

23
????????? ? ????????? Apache FOP

• ???????? ??????? Apache FOP ?? ?????? Oracle
• ????????? ??? ????????????? FOP java class
  ru.parus.foprocessor
• ?????????? ?????????? ????? ??????????
  c\fop\fonts ? c\fop\conf ?? ??????????????
  ?????????? c\fop\.fop
• ??? DBA ?????????
• call dbms_java.grant_permission('FOP',
  'java.io.FilePermission', 'c\fop\.fop',
  'read,write')
• call dbms_java.grant_permission(FOP',
  'java.io.FilePermission', 'c\fop\.fop\fop-fonts.c
  ache', 'read,write')
• call dbms_java.grant_permission(FOP',
  'java.util.PropertyPermission', 'user.dir',
  'read,write')
• call dbms_java.grant_permission(FOP',
  'java.util.PropertyPermission', 'user.home',
  'read,write')
• ??? c\fop ?????????? ?? ????? ??????? ???
  ????? ????????? ????? ????????????, ???????
  ??????? ? ???? ??????.

24
????????? ? ????????? Apache FOP

• ???????? ??????? Apache FOP ?? ?????? Oracle
• ??? ????????????? FOP ?????????.
• create or replace function GET_FOP_DOCUMENT
• (
• MIME_TYPE in varchar2, XMLFO in blob, XMLXSLT
  in blob
• ) return blob as
• language java name 'ru.parus.foprocessor.process
  Document(java.lang.String,oracle.sql.BLOB,oracle.s
  ql.BLOB)
• return oracle.sql.BLOB'
• ??? DBA ?????????
• ?reate public synonym GET_FOP_DOCUMENT for
  FOP.GET_FOP_DOCUMENT
• grant execute on GET_FOP_DOCUMENT to public

25
????????? ? ????????? Apache FOP

• ???????????? ?????????
• ???????? ?????????
• create or replace procedure UDO_P_TEST_FOP_DOCUMEN
  T
• (
• NCOMPANY in number
• ,NPROCESS in number
• ) is
• B1 blob
• B2 blob
• begin
• select R.TEMPLATE_DATA
• into B1
• from USERREPORTS R
• where R.COMPANY NCOMPANY
• and R.RN PKG_USERREPORTS.GET_REPORT()
• B2 GET_FOP_DOCUMENT(MIME_TYPE gt 'PDF'
• ,XMLFO gt B1
• ,XMLXSLT gt null)

26
????????? ? ????????? Apache FOP

• ???????????? ?????????
• ???????? ???????????????? ????? ? ????? ????????
  ??????

27
????????? ? ????????? Apache FOP

• ???????????? ?????????
• ????????? ? ???????????????? ????? ???? test.fo
• ????????? ????????? ??????. ????? ????? ???? ??
  ?????????? ???? ???????? ? ?????????????
  ????????

28
????????? ? ????????? Apache FOP

• ???????????? ?????????
• ????????? ???????? ?????? ?? ????????????????
  ??????
• ???? ????????? ?????? ???????, ?? ?????????
  ???????? PDF ? ??????? ????????

29
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ??????????
• http//msdn.microsoft.com/en-us/library/aa5371672
  8voffice.1129.aspx
• ?????????
• http//www.microsoft.com/en-us/download/details.as
  px?id16876
• ?????????? OfficeWordWordMLtoXSL-FOSample.exe

30
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ??????????
• http//msdn.microsoft.com/en-us/library/aa5371672
  8voffice.1129.aspx
• ?????????
• http//www.microsoft.com/en-us/download/details.as
  px?id16876
• ?????????? OfficeWordWordMLtoXSL-FOSample.exe

31
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ????? ????? ? ??????? WS Word
• ????????? ???????? ????? ???????? ?????-????
  ?????

32
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????? ??????????? ???????? ??? ???????? XML c
  ??????????? ??????????????

33
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????? ??????? c\fop\fop.bat -c
  c\fop\conf\fop.xconf c\fop\t1a.xml
  c\fop\t1a.pdf
• ?????????? ????????? ? c\fop\t1a.pdf
• ? ????? ??? ?????????? ????? ????? ? ???????

34
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ??????? ??????????? ???????? MS Word
• ???????? ??????? ? ????????????? ??????? ?
  ??????? ? ???

35
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ?????? (??-?????)
• ????????????? ??????? ? ??????? ? ?????

36
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????? ????????? ??? ???????? XML

37
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????? ?????????? PDF
• ????????? ?????????????? ????????? MS Word ????
  ??? ?? ??????? ?????????

38
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????? ???????????????? ?????????, ???????
  ?????????? XML-???? ? ???????, ?? ??????? ?????
  ????????????? ?????.????????
• lt?xml version"1.0" encoding"windows-1251"?gt
• ltREPORTSgt
• ltREPORTgt
• ltDOC_NUMBgt2012-2lt/DOC_NUMBgt
  ltDDOC_DATEgt24.08.2012lt/DDOC_DATEgt ltSORGNAMEgt ???
  quot?????quotlt/SORGNAMEgt
• ltSORGCODE/gt
• ltROWSgt
• ltROWgt
• ltFIOgt??????? ????? ?????????lt/FIOgt
  ltTBLNUMgtT-14lt/TBLNUMgt
• ltSDEPTNAMEgt????????lt/SDEPTNAMEgt
  ltSPOSTNAMEgt??????? ?????????lt/SPOSTNAMEgt
  ltNSUMMOKLgt90000lt/NSUMMOKLgt
• ltNSUMMNAD/gt ltSCNTR_NUMB/gt ltDCNTR_DATE/gt
  ltDBEGENGgt24.08.2012lt/DBEGENGgt ltDENDENG/gt
  ltSTESTPERIOD/gt
• lt/ROWgt
• ltROWgt
• ltFIOgt????? ??????? ????????????lt/FIOgt
  ltTBLNUMgtT-16lt/TBLNUMgt ltSDEPTNAMEgt???????????????
  ?????lt/SDEPTNAMEgt
• ltSPOSTNAMEgtTe??????lt/SPOSTNAMEgtltNSUMMOKLgt5
  000lt/NSUMMOKLgt
• ltNSUMMNAD/gtltSCNTR_NUMB/gtltDCNTR_DATE/gt
• ltDBEGENGgt26.11.2012lt/DBEGENGgtltDENDENG/gtltST
  ESTPERIOD/gt
• lt/ROWgt

39
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ???? XML ? ??????? ? c\fop\t1a_data.xml
• ??????? ?? ?????????????? ???? XML, ??????? ??
  ???????? ?? MS Word
• ? ?????? ????????? ????
• lt?xml version "1.0" encoding "WINDOWS-1251"?gt
• ltforoot font-family"TimesNewRoman"
• xmlnsfo"http//www.w3.org/1999/XSL/Format"
• xmlnsw"http//schemas.microsoft.com/office/wo
  rd/2003/wordml"gt
• ??????
• lt?xml version "1.0" encoding "WINDOWS-1251"?gt
• ltxslstylesheet
• xmlnsxsl"http//www.w3.org/1999/XSL/Transfo
  rm" version"1.0"
• xmlnsfo"http//www.w3.org/1999/XSL/Format"gt
  
• ltxsltemplate match "REPORTS"gt
• ltforoot font-family"TimesNewRoman"
• .

40
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ? ????? ????????? ????
• lt/foflowgt
• lt/fopage-sequencegt
• lt/forootgt
• ??????
• lt/foflowgt
• lt/fopage-sequencegt
• lt/forootgt
• lt/xsltemplategt
• lt/xslstylesheetgt

41
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????, ??? ?? ??? ????????? ??????? ????????
• c\fop\fop.bat -c c\fop\conf\fop.xconf -xml
  c\fop\t1a_data.xml -xsl c\fop\t1a.xml -pdf
  c\fop\t1a.pdf
• ? ?????????? ?????? ???????? ????, ??? ? ??????

42
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????? ???? t1a.xml ? ?????????
• ??????? ??? xsl-region-body

43
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????? ???? t1a.xml ? ?????????
• ??????? ??? foflow c ?????????
  flow-namexsl-region-body

44
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????? ???? t1a.xml ? ?????????
• ??????? ??? foflow c ?????????
  flow-namexsl-region-body

45
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ?????????? ???? ltfoflowgt (?? ?? ???
  ???) ? ????? ?????? ????? ltxslapply-templates/
  gt
• ??????? ??? ltxsltemplate match "REPORT"gt
  lt/xsltemplategt
• ?????????? ?????? ???? ltxsltemplate match
  "REPORT"gt ?????????? ?????????? ltfoflowgt

46
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ? ?????????? ?????? ????????

47
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ?????? ltxsltemplate match "REPORT"gt
• ? ??????? ltfoblockgt ??????? ???????
  break-before"page

48
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ??? ???????? ???????? ??? ltREPORTgt ? ?????
  c\fop\t1a_data.xml
• ????? ????????? ??????? c\fop\fop.bat -c
  c\fop\conf\fop.xconf -xml c\fop\t1a_data.xml
  -xsl c\fop\t1a.xml -pdf c\fop\t1a.pdf
• ???????? 2 ????????

49
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ?????? ?? ????? ?????????? ? ?????? ?????,
  ??????? ????? ????? ??????????? 1 ??? ?????? ????
  ltREPORTgt
• ??????? ????????, ??????? ?? ????????? ? ????? MS
  Word

50
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ????????, zzzzzzz ?? ltxslvalue-of
  select"SORGNAME"/gt
• ? ????????? ????? ???????? language"EN-US ??
  languageRU
• ?????????

51
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ?????? ???????? ??????, ??????? ????? ???????????
  ????????? ???
• ?????? ?????? ???? ltfotablegt ??? lttable-rowgt

52
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ?????? ???????? ??????, ??????? ????? ???????????
  ????????? ???
• ?????? ?????? ???? ltfotablegt ??? lttable-rowgt

53
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ????????????? ??? lttable-rowgt ?????????
• ????????? ??? lttable-rowgt ???????
• ????? ?????? ??????????? lttable-rowgt
• ltxslapply-templates/gt

54
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ????????? ????????? ???? ROWS (? ????? ?????? ???
  ??????, ????? ???? ??????? ?? ????????? ??????
  ?????)
• ??????? ????????? ???? ROW, ??? ??? ?? ?????????
  ?????? ???????????? ??????? ?????????? ??????????
  ltfotable-rowgt.
• ????????? ??????? ?????? ???? ltxslapply-template
  s/gt

55
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ???????? ??????????? ????? ??????
  ??????? ??? ???? ROW
• ????? ltxslvalue-of select"FIO"/gt ? ?.?.

56
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ? ????? ????????? ??????????? ??? ????????? ????
  ??? ??????? ?? ??????
• xslvalue-of select

57
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? PDF
• ???????? ??? ltfoblockgt
• ?? ????????? ???? ltREPORTgt ???????? ????
  ltfomarkergt ? ????????? ????? ???? foflow

58
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ??? ?????? ???? ??????? ?? ????? Apache FOP
• ?????????? XSLT ??????????????
• ???????? ??? ??????????? ???????? MS Word ???
  XML-????????, ??? ???? ?? ???????? ??????????????.

59
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ????????? XML ? ?????????

60
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ????????? ??? ???????? xslstylesheet
• ltxslstylesheet xmlnsxsl"http//www.w3.org/1999/
  XSL/Transform" version"1.0
• ???????? ????????? ???????? ?? ????
  wwordDocument
• ????????
• ltxslstylesheet xmlnsxsl"http//www.w3.org/1999/
  XSL/Transform" version"1.0" xmlnsw"http//schem
  as.microsoft.com/office/word/2003/wordml"
  xmlnsv"urnschemas-microsoft-comvml"
  xmlnsw10"urnschemas-microsoft-comofficeword"
  xmlnssl"http//schemas.microsoft.com/schemaLibra
  ry/2003/core" xmlnsaml"http//schemas.microsoft.
  com/aml/2001/core" xmlnswx"http//schemas.micros
  oft.com/office/word/2003/auxHint"
  xmlnso"urnschemas-microsoft-comofficeoffice"
  xmlnsdt"uuidC2F41010-65B3-11d1-A29F-00AA00C1488
  2" xmlnswsp"http//schemas.microsoft.com/office/
  word/2003/wordml/sp2" wmacrosPresent"no"
  wembeddedObjPresent"no" wocxPresent"no"
  xmlspace"preserve"gt

61
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ? ????????? ?????? ????? ?????????
  lt/xslstylesheetgt
• ????????

62
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ??? lt/wwordDocumentgt ????????? ?????? ????
• ltxsltemplate match "REPORTS"gt

63
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ???????? ????????????????? ????????
• c\fop\fop.bat -xml c\fop\t1a_data.xml -xsl
  c\fop\t1a_word.xml -foout c\fop\t1a_msword.doc
• ??????? c\fop\t1a_msword.doc

64
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ???????? ????????????????? ????????
• c\fop\fop.bat -xml c\fop\t1a_data.xml -xsl
  c\fop\t1a_word.xml -foout c\fop\t1a_msword.doc
• ??????? c\fop\t1a_msword.doc

65
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ???????? ????????????????? ????????
• ??????? ??? ltwbodygt
• ????? ???? ????????? ?????? ??? ltwxsectgt

66
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ???????? ????????????????? ????????
• ???????? ????????? ??? ltwxsectgt ? ????????? ????
  REPORT, ?? ???????? ??? ltxslapply-templates/gt

67
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ???????? ????????? ??? ltwxsectgt ? ????????? ????
  REPORT, ?? ???????? ??? ltxslapply-templates/gt

68
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ???????? ????????????????? ??????? ????????
• ?????? ?????????? 2 ??????, ?? ???????? ????
  ???????? ?? ????????? ???????

69
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ??????? ??????????? ????????, ??????? ???????????
  1 ??? ?? ltxslapply-templates select" lt???gt
  "/gt
• ?????! ?? ?????? ltxslvalue-of selectlt???gt"/gt
• ??? ltwtgt ? ltxslapply-templates select" lt???gt
  "/gt ?????? ??? ???????? ? ????????? ??????.
• ?? ???????? ?????? ???? ?? RU, ??? ?????????????

70
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ????????? ?????, ??????? ??????????? ?????? ltwtgt
• ???????????? ???
• ltxsltemplate match "SORGNAME"gtltxslvalue-of
  select"."/gtlt/xsltemplategt
• ??? ????????? ??????!

71
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ????? ??? ?????? ???????? ?????? ltwtgt ?????
  ???????

72
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ????????? ??????? ????????
• c\fop\fop.bat -xml c\fop\t1a_data.xml -xsl
  c\fop\t1a_word.xml -foout c\fop\t1a_msword.doc
• ?????? ??????????

73
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ?? ??????????? ?????????, ???????? aaa ???????
  ????????? ???
• ltwtcgt - ??? ??????
• ????? ?????? ????????? ltwtrgt - ??? ??????
  ???????
• ??????? ????????? ltwtrgt ? ?????? ???????

74
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ?????? ????????? ltwtrgt ????????? ? ??????????
  ROW.
• ?????????? ROWS ??????? ?????? ?? ???????? ?
  ????????? ?????? ????? (?? ????? ?????? ???
  ???????).
• ?????? ??????????? ltwtrgt ???????
  ltxslapply-templates/gt

75
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ??????? ??????? ???????
• ? ??????????? REPORTS ?????? ltxslapply-templates/
  gt

76
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ??????? ??????? ???????
• ???????
• ltxslfor-each select"./REPORT"gt
• ltxslapply-templates select"."/gt
• ltxslif test"position()!last()"gt
• ltwbr wtype"page"/gt
• lt/xslifgt
• lt/xslfor-eachgt

77
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? MS Word
• ??????? ??????? ???????
• ??? ????????, ??? ?????????? ???????? ltwbr
  wtype"page"/gt
• ????? ????????? ??????? ???? REPORT, ?????
  ??????????.

78
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? HTML
• ????? ????? ???????????? ???????? XSLT
  ??????????????, ? ????? ???????? ????????????
  CLOB. ???? ?????? ????? ????? ???????? .xls, ??
  ???? ????????? ? MS Excel
• ??????? ??????? ?????????
• create or replace procedure UDO_P_HTML_PRORDERS
• (
• NCOMPANY in number
• ,NRN in number
• ,NIDENT in number
• ) is
• C clob
• SFILENAME FILE_BUFFER.FILENAMEtype
• --
• procedure WRITELN(S in varchar2) as
• begin
• DBMS_LOB.WRITEAPPEND(C,LENGTH(S CR, S
  CR)
• end
• begin
• SFILENAME '.htm'

79
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? HTML
• WRITELN('lttable border"1" cellspacing"1"
  cellpadding"1" width"300"gt')
• WRITELN('lttr height"40" valign"center"
  align"center" ')
• WRITELN(' cellspacing0 cellpadding0 gt')
• WRITELN('lttd bgcolor"CCCCCC"
  width"150"gtltfont color"101010"gt???
  ?????????lt/fontgtlt/tdgt')
• WRITELN('lttd bgcolor"CCCCCC" width"75"gtltfont
  color"101010"gt???????lt/fontgtlt/tdgt')
• WRITELN('lttd bgcolor"CCCCCC" width"75"gtltfont
  color"101010"gt?????lt/fontgtlt/tdgt')
• WRITELN('lt/trgt')
• for REC in (select P.SDOC_TYPE, P.SDOC_PREF
  ,P.SDOC_NUMB from V_PRORDER P ,SELECTLIST S
• where S.IDENT
  UDO_P_HTML_PRORDERS.NR and S.AUTHID UTILIZER
• and P.NRN S.DOCUMENT)
• loop
• WRITELN('lttr bgcolor"FFFFFF" cellspacing1
  cellpadding1gt')
• WRITELN('lttd align"left"gt' REC.SDOC_TYPE
  'lt/tdgt')
• WRITELN('lttd align"right"gt' REC.SDOC_PREF
  'lt/tdgt')
• WRITELN('lttd align"right"gt' REC.SDOC_NUMB
  'lt/tdgt')
• WRITELN('lt/trgt')
• end loop

80
?????? ? ??????? MS Word, RTF, PDF, HTML

• ?????? ? ??????? HTML
• ????????? ??????

81
???????? ??????? ?? ??????????? ?????

• ?????????????? ???????? e-mail ?? ??????? ???????
• ??????? ????????? blat http//sourceforge.net/pr
  ojects/blat/files/
• ??????????? ? ??????? c\blat
• ?????????
• C\blat.exe -install 192.168.122.1
  president_at_parus.ru
• ??? 192.168.122.1 ????? ?????? SMTP-???????
• ?????? president_at_parus.ru ???????? ????? ??
  ????? ????? ????? ??????????? ???????? ??????.

82
???????? ??????? ?? ??????????? ?????

• ?????????????? ???????? e-mail ?? ??????? ???????
• ???????? ???? c\blat\blat.bat
• c\blat\blat.exe c\blat\message.txt -sf
  c\blat\subject.txt -to 1 -charset cp1251
  -attach 2 gtc\blat\message.log
• ???????? ????? c\blat\message.txt ???????? ?
  ???? ????? ??????
• ???????? ????? c\blat\subject.txt ???????? ?
  ???? ???? ??????

83
???????? ??????? ?? ??????????? ?????

• ?????????????? ???????? e-mail ?? ??????? ???????
• ?????? ????????????? ? ????????????????
  ??????????
• ??? ?????? ??????? e-mail ? ??? ????? ???
  ????????

84
?????? ?????????? ??????

• ???????? ????????????
• Create user PRINT_TEST identified by parusina
• Grant connect to PRINT_TEST
• ???????? ???? ?????? ??????

85
?????? ?????????? ??????

• ?????????? ???? ???????
• ????????? ???? ?????????? ?????? ??????????
  ?????? ???????
• ????????? ???? ??????????? , ???? lt???????gt
  ?????? ???? ???????????

86
?????? ?????????? ??????

• ?????????? ???? ???????
• ????????? ???? ????? ??????? ? ???????

87
?????? ?????????? ??????

• ?????????? ???? ???????
• ????????? ???? ????? ??????? ? ???????????

88
?????? ?????????? ??????

• ?????????????? ??????
• ???????? ????? ?? ?????? p8application.exe ??
  ??????? ??????? ????
• p8application.exe /b?????????? /aPrintServer
  /u???????????? /c???????????
• ????????
• "C\Program Files\?????-???????????
  8.5.6.1\p8application.exe" /bSTUDY
  /aPrintServer /uPRINT_TEST /c???????????
• ???????? ????? ? ???????????? ?????? ???????, ??
  ??????????? ??????? ? ORACLE.

89
?????? ?????????? ??????

• ?????????????? ??????
• ????????? ?????
• ??????? ??????
• ?????????? ????? ????????? ??????

90
???????