git.plutz.net Git - invoices/blob - odtgen.sh

   1 #!/bin/zsh
   2
   3 odt_manifest(){
   4   cat <<-EOF
   5         <?xml version="1.0" encoding="UTF-8"?>
   6         <manifest:manifest xmlns:manifest="urn:oasis:names:tc:opendocument:xmlns:manifest:1.0" manifest:version="1.2">
   7           <manifest:file-entry manifest:full-path="/" manifest:version="1.2" manifest:media-type="application/vnd.oasis.opendocument.text"/>
   8           <manifest:file-entry manifest:full-path="styles.xml" manifest:media-type="text/xml"/>
   9           <manifest:file-entry manifest:full-path="content.xml" manifest:media-type="text/xml"/>
  10         </manifest:manifest>
  11         EOF
  12 }
  13
  14 odt_stylesheet(){
  15   local iban="$1" bic="$2"
  16
  17   cat <<-EOF
  18         <?xml version="1.0" encoding="UTF-8"?>
  19         <office:document-styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:officeooo="http://openoffice.org/2009/office" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2">
  20           <office:styles>
  21             <style:style style:name="Standard" style:family="paragraph" style:class="text">
  22               <style:paragraph-properties fo:text-align="start" style:justify-single-word="false"/>
  23               <style:text-properties style:font-name="DejaVu Sans" fo:font-family="'DejaVu Sans'" style:font-family-generic="swiss" style:font-pitch="variable" style:font-size-asian="10.5pt" style:font-weight-asian="normal"/>
  24             </style:style>
  25           </office:styles>
  26           <office:automatic-styles>
  27             <style:style style:name="MP1" style:family="paragraph">
  28               <style:paragraph-properties fo:text-align="center" style:justify-single-word="false"/>
  29               <style:text-properties style:font-name="DejaVu Sans" fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
  30             </style:style>
  31             <style:style style:name="MT1" style:family="text">
  32               <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
  33             </style:style>
  34             <style:page-layout style:name="Mpm1">
  35               <style:page-layout-properties fo:page-width="8.2681in" fo:page-height="11.6929in" style:num-format="1" style:print-orientation="portrait" fo:margin-top="0.7874in" fo:margin-bottom="0.7874in" fo:margin-left="0.7874in" fo:margin-right="0.7874in" style:writing-mode="lr-tb" style:footnote-max-height="0in">
  36                 <style:footnote-sep style:width="0.0071in" style:distance-before-sep="0.0398in" style:distance-after-sep="0.0398in" style:line-style="solid" style:adjustment="left" style:rel-width="25%" style:color="#000000"/>
  37               </style:page-layout-properties>
  38               <style:header-style/>
  39               <style:footer-style>
  40                 <style:header-footer-properties fo:min-height="0in" fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0.1965in"/>
  41               </style:footer-style>
  42             </style:page-layout>
  43           </office:automatic-styles>
  44           <office:master-styles>
  45             <style:master-page style:name="Standard" style:page-layout-name="Mpm1">
  46               <style:footer>
  47                 <text:p text:style-name="MP1">
  48                   <text:span text:style-name="MT1">Bankverbindung - IBAN:</text:span>
  49                   <text:span>${iban}</text:span>
  50                   <text:span text:style-name="MT1">| BIC:</text:span>
  51                   <text:span>${bic}</text:span>
  52                 </text:p>
  53               </style:footer>
  54             </style:master-page>
  55           </office:master-styles>
  56         </office:document-styles>
  57         EOF
  58 }
  59
  60 odt_content(){
  61   local id="$1" sender="$2" client="$3" date="$4" number="$5" vat="$6" vatrate="$7" hourly="$8" \
  62         taxtype nett tax gross
  63   read -r taxtype nett tax gross <<-EOF
  64         $(invoice_total "$id")
  65         EOF
  66
  67   cat <<-EOF
  68         <?xml version="1.0" encoding="UTF-8"?>
  69         <office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:officeooo="http://openoffice.org/2009/office" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2">
  70           <office:automatic-styles>
  71             <style:style style:name="Table1" style:family="table">
  72               <style:table-properties style:width="6.7in" fo:margin-top="0in" fo:margin-bottom="0in" table:align="margins"/>
  73             </style:style>
  74             <style:style style:name="Table1.A" style:family="table-column">
  75               <style:table-column-properties style:column-width="1.2in" style:rel-column-width="12000*"/>
  76             </style:style>
  77             <style:style style:name="Table1.B" style:family="table-column">
  78               <style:table-column-properties style:column-width="3.4in" style:rel-column-width="34000*"/>
  79             </style:style>
  80             <style:style style:name="Table1.C" style:family="table-column">
  81               <style:table-column-properties style:column-width="1.1in" style:rel-column-width="11000*"/>
  82             </style:style>
  83             <style:style style:name="Table1.D" style:family="table-column">
  84               <style:table-column-properties style:column-width="1.0in" style:rel-column-width="10000*"/>
  85             </style:style>
  86             <style:style style:name="Table1.1" style:family="table-cell">
  87               <style:table-cell-properties fo:padding="0.0201in" fo:border-left="none" fo:border-right="none" fo:border-top="none" fo:border-bottom="0.05pt solid #000000"/>
  88             </style:style>
  89             <style:style style:name="Table1.2" style:family="table-cell">
  90               <style:table-cell-properties fo:padding="0.0201in" fo:border="none"/>
  91             </style:style>
  92             <style:style style:name="Table1.6" style:family="table-cell">
  93               <style:table-cell-properties fo:padding="0.0201in" fo:border-left="none" fo:border-right="none" fo:border-top="0.05pt solid #000000" fo:border-bottom="none"/>
  94             </style:style>
  95             <style:style style:name="P3" style:family="paragraph" style:parent-style-name="Standard">
  96               <style:text-properties style:font-name="DejaVu Sans" fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
  97             </style:style>
  98             <style:style style:name="P4" style:family="paragraph" style:parent-style-name="Standard">
  99               <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
 100               <style:text-properties style:font-name="DejaVu Sans" fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
 101             </style:style>
 102             <style:style style:name="P5" style:family="paragraph" style:parent-style-name="Standard">
 103               <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
 104               <style:text-properties fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
 105             </style:style>
 106             <style:style style:name="P6" style:family="paragraph" style:parent-style-name="Standard">
 107               <style:paragraph-properties fo:text-align="start" style:justify-single-word="false"/>
 108               <style:text-properties fo:font-weight="bold" fo:font-size="10.5pt" style:font-size-complex="10.5pt"/>
 109             </style:style>
 110             <style:style style:name="P7" style:family="paragraph" style:parent-style-name="Standard">
 111               <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
 112               <style:text-properties fo:font-weight="bold" fo:font-size="10.5pt" style:font-size-complex="10.5pt"/>
 113             </style:style>
 114             <style:style style:name="T3" style:family="text">
 115               <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 116             </style:style>
 117             <style:style style:name="fr1" style:family="graphic" style:parent-style-name="Standard">
 118               <style:graphic-properties fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0in" fo:margin-bottom="0in" style:wrap="none" style:vertical-pos="from-top" style:vertical-rel="page-content" style:horizontal-pos="right" style:horizontal-rel="page-content" fo:padding="0in" fo:border="none" style:shadow="none" draw:shadow-opacity="100%"/>
 119             </style:style>
 120             <style:style style:name="fr2" style:family="graphic" style:parent-style-name="Standard">
 121               <style:graphic-properties fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0in" fo:margin-bottom="0in" style:wrap="none" style:vertical-pos="top" style:vertical-rel="page-content" style:horizontal-pos="right" style:horizontal-rel="page-content" fo:padding="0in" fo:border="none" style:shadow="none" draw:shadow-opacity="100%"/>
 122             </style:style>
 123             <style:style style:name="fr3" style:family="graphic" style:parent-style-name="Standard">
 124               <style:graphic-properties fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0in" fo:margin-bottom="0in" style:wrap="none" style:vertical-pos="from-top" style:vertical-rel="page-content" style:horizontal-pos="left" style:horizontal-rel="page-content" fo:padding="0in" fo:border="none" style:shadow="none" draw:shadow-opacity="100%"/>
 125             </style:style>
 126           </office:automatic-styles>
 127           <office:body>
 128             <office:text>
 129               <text:p text:style-name="P3">
 130                 <draw:frame draw:style-name="fr1" draw:name="Rahmen4" text:anchor-type="paragraph" svg:y="2.7598in" svg:width="1.7283in">
 131                   <draw:text-box fo:min-height="0.2528in">
 132                     <text:p text:style-name="P5">$(date -d @${date} +%d.%m.%Y)</text:p>
 133                   </draw:text-box>
 134                 </draw:frame><draw:frame draw:style-name="fr2" draw:name="Rahmen2" text:anchor-type="paragraph" svg:width="1.8228in">
 135                   <draw:text-box fo:min-height="1.8992in">
 136                     <text:p text:style-name="P5"><!--
 137                  -->$(HTML "$sender" |sed -r 's;(&#13\;)?&#10\;|(&#x0?[Dd]\;)?&#x0?[aA]\;|\r?$;<text:line-break/>;g')<!--
 138                  --></text:p>
 139                   </draw:text-box>
 140                 </draw:frame><draw:frame draw:style-name="fr3" draw:name="Rahmen1" text:anchor-type="paragraph" svg:y="1.3799in" svg:width="3.4398in">
 141                   <draw:text-box fo:min-height="1.3311in">
 142                     <text:p text:style-name="P3"><!--
 143                    -->$(HTML "$client" |sed -r 's;(&#13\;)?&#10\;|(&#x0?[Dd]\;)?&#x0?[aA]\;|\r?$;<text:line-break/>;g')<!--
 144                    --></text:p>
 145                   </draw:text-box>
 146                 </draw:frame><text:span text:style-name="T3">Rechnung ${number}</text:span>
 147               </text:p>
 148               <text:p text:style-name="P3"/>
 149               <text:p text:style-name="P3"/>
 150               <text:p text:style-name="P3">Vergütung: ${hourly} € / Std.<!--
 151              -->$(case $vat in
 152                   (smallbusiness)
 153                     printf '<text:line-break/>Gemäß Kleinunternehmerregelung (§19 Umsatzsteuergesetz) wird keine Umsatzsteuer berechnet.';;
 154                   (nett)  printf 'zuzüglich %i%% MwSt.' "$vatrate";;
 155                   (gross) printf '(einschließlich %i%% MwSt.)' "$vatrate";;
 156                  esac)<!--
 157            --></text:p>
 158               <text:p text:style-name="P3"/>
 159               <table:table table:name="Table1" table:style-name="Table1">
 160                 <table:table-column table:style-name="Table1.A"/>
 161                 <table:table-column table:style-name="Table1.B"/>
 162                 <table:table-column table:style-name="Table1.C"/>
 163                 <table:table-column table:style-name="Table1.D"/>
 164                 <table:table-header-rows>
 165                   <table:table-row>
 166                     <table:table-cell table:style-name="Table1.1" office:value-type="string">
 167                       <text:p text:style-name="P6">Datum</text:p>
 168                     </table:table-cell>
 169                     <table:table-cell table:style-name="Table1.1" office:value-type="string">
 170                       <text:p text:style-name="P6">Art der Leistung</text:p>
 171                     </table:table-cell>
 172                     <table:table-cell table:style-name="Table1.1" office:value-type="string">
 173                       <text:p text:style-name="P7">Stundenzahl</text:p>
 174                     </table:table-cell>
 175                     <table:table-cell table:style-name="Table1.1" office:value-type="string">
 176                       <text:p text:style-name="P7">Betrag</text:p>
 177                     </table:table-cell>
 178                   </table:table-row>
 179                 </table:table-header-rows>
 180                 $(sed 1d "invoices/$id" |while read -r time work hours; do
 181                    time="$(UNSTRING "${time#time=}" |sed -r 's;(&#13\;)?&#10\;|(&#x0?[Dd]\;)?&#x0?[aA]\;|\r?$;<text:line-break/>;g')"
 182                    work="$(UNSTRING "${work#work=}" |sed -r 's;(&#13\;)?&#10\;|(&#x0?[Dd]\;)?&#x0?[aA]\;|\r?$;<text:line-break/>;g')"
 183                   hours="$(UNSTRING "${hours#hours=}")"
 184                   cat <<-TROW
 185                         <table:table-row>
 186                           <table:table-cell table:style-name="Table1.2" office:value-type="string">
 187                             <text:p text:style-name="P4">${time} </text:p>
 188                           </table:table-cell>
 189                           <table:table-cell table:style-name="Table1.2" office:value-type="string">
 190                             <text:p text:style-name="P3">${work}</text:p>
 191                           </table:table-cell>
 192                           <table:table-cell table:style-name="Table1.2" office:value-type="string">
 193                             <text:p text:style-name="P5">$( awk "BEGIN {
 194                                                                  if ( int(${hours}) == ${hours} )
 195                                                                     printf \"%i\", ${hours};
 196                                                                  else
 197                                                                     printf \"%i:%i\", int(${hours}), int((${hours} - int(${hours})) * 60);
 198                                                                  }"
 199                                                            )</text:p>
 200                           </table:table-cell>
 201                           <table:table-cell table:style-name="Table1.2" office:value-type="string">
 202                             <text:p text:style-name="P5">$(awk "BEGIN { printf \"%.2f\", ${hourly} * ${hours}; }" ) €</text:p>
 203                           </table:table-cell>
 204                         </table:table-row>
 205                         TROW
 206                 done)
 207                 <table:table-row>
 208                   <table:table-cell table:style-name="Table1.6" office:value-type="string">
 209                     <text:p text:style-name="P6"/>
 210                   </table:table-cell>
 211                   $(case $taxtype in
 212                     (nett) cat <<-TCELL
 213                         <table:table-cell table:style-name="Table1.6" table:number-columns-spanned="2" office:value-type="string">
 214                           <text:p text:style-name="P5">
 215                           Zwischensumme:<text:line-break/>
 216                           zzgl. ${vatrate}% MwSt.:<text:line-break/>
 217                           </text:p>
 218                           <text:p text:style-name="P7">zu zahlender Betrag:</text:p>
 219                         </table:table-cell>
 220                         <table:table-cell table:style-name="Table1.6" office:value-type="string">
 221                           <text:p text:style-name="P5">
 222                           ${nett} €<text:line-break/>
 223                           ${tax} €<text:line-break/>
 224                           </text:p>
 225                           <text:p text:style-name="P7">${gross} €</text:p>
 226                         </table:table-cell>
 227                         TCELL
 228                         ;;
 229                     (gross) cat <<-TCELL
 230                         <table:table-cell table:style-name="Table1.6" table:number-columns-spanned="2" office:value-type="string">
 231                           <text:p text:style-name="P7">zu zahlender Betrag:</text:p>
 232                           <text:p text:style-name="P5">
 233                           <text:line-break/>
 234                           enthaltene MwSt (${vatrate}%):<text:line-break/>
 235                           enthaltener Netto-Betrag:<!--
 236                         --></text:p>
 237                         </table:table-cell>
 238                         <table:table-cell table:style-name="Table1.6" office:value-type="string">
 239                           <text:p text:style-name="P7">${gross} €</text:p>
 240                           <text:p text:style-name="P5">
 241                           <text:line-break/>
 242                           ${tax} €<text:line-break/>
 243                           ${nett} €<!--
 244                         --></text:p>
 245                         </table:table-cell>
 246                         TCELL
 247                         ;;
 248                     (*) cat <<-TCELL
 249                         <table:table-cell table:style-name="Table1.6" table:number-columns-spanned="2" office:value-type="string">
 250                           <text:p text:style-name="P7">zu zahlender Betrag:</text:p>
 251                         </table:table-cell>
 252                         <table:table-cell table:style-name="Table1.6" office:value-type="string">
 253                           <text:p text:style-name="P7">${gross} €</text:p>
 254                         </table:table-cell>
 255                         TCELL
 256                         ;;
 257                   esac)
 258                 </table:table-row>
 259               </table:table>
 260             </office:text>
 261           </office:body>
 262         </office:document-content>
 263         EOF
 264 }
 265
 266 genodt(){
 267   local id="$1" exdir="export/$1"
 268   [ -d "$exdir" ] && {
 269     rm "$exdir/content.xml" "$exdir/styles.xml" "$exdir/META-INF/manifest.xml"
 270     rmdir "$exdir/META-INF/" "$exdir/"
 271   }
 272
 273   read -r sender client date number vat vatrate hourly x<<-EOF
 274         $(sed q "invoices/$id")
 275         EOF
 276   read -r sender iban bic x<"senders/${sender#sender=}"
 277   read -r client chourly x<"clients/${client#client=}"
 278
 279   mkdir -p "$exdir/META-INF"
 280   odt_manifest >"$exdir/META-INF/manifest.xml"
 281   odt_stylesheet "$(UNSTRING "${iban#iban=}")" "$(UNSTRING "${bic#bic=}")" >"$exdir/styles.xml"
 282   odt_content "$id" \
 283     "$(UNSTRING "${sender#address=}")" \
 284     "$(UNSTRING "${client#address=}")" \
 285     "${date#date=}" \
 286     "$(UNSTRING "${number#number=}")" \
 287     "${vat#vat=}" "${vatrate#vatrate=}" \
 288     "${hourly#hourly=}" \
 289   >"$exdir/content.xml"
 290
 291   [ -f "export/${id}.odt" ] && rm "export/${id}.odt"
 292   ( cd "$exdir"
 293     zip -q "../${id}.odt" content.xml styles.xml META-INF/manifest.xml
 294   )
 295   rm "$exdir/content.xml" "$exdir/styles.xml" "$exdir/META-INF/manifest.xml"
 296   rmdir "$exdir/META-INF/" "$exdir/"
 297 }
 298
 299 genpdf(){
 300   local id="$1"
 301   genodt "$id"
 302   lowriter --convert-to pdf --outdir "export/" "export/${id}.odt" >/dev/null
 303   rm "export/${id}.odt"
 304 }
 305