X-Git-Url: http://git.plutz.net/?a=blobdiff_plain;f=odtgen.sh;h=177065a9c9a0fd10f92cba31058aceacc51f1b98;hb=026cd2e0fc6081c19d681a40720f7a70b449f3d8;hp=5efbcc2887dfb70a346cd1871f5a8dfa07fe79f9;hpb=3eeb4b1c0767895b834494361cfeb9d32dc9e414;p=invoices

diff --git a/odtgen.sh b/odtgen.sh
index 5efbcc2..177065a 100755
--- a/odtgen.sh
+++ b/odtgen.sh
@@ -72,14 +72,17 @@ odt_content(){
 	      <style:table-properties style:width="6.7in" fo:margin-top="0in" fo:margin-bottom="0in" table:align="margins"/>
 	    </style:style>
 	    <style:style style:name="Table1.A" style:family="table-column">
-	      <style:table-column-properties style:column-width="1.1in" style:rel-column-width="11000*"/>
+	      <style:table-column-properties style:column-width="1.2in" style:rel-column-width="12000*"/>
 	    </style:style>
 	    <style:style style:name="Table1.B" style:family="table-column">
 	      <style:table-column-properties style:column-width="3.4in" style:rel-column-width="34000*"/>
 	    </style:style>
-	    <style:style style:name="Table1.CD" style:family="table-column">
+	    <style:style style:name="Table1.C" style:family="table-column">
 	      <style:table-column-properties style:column-width="1.1in" style:rel-column-width="11000*"/>
 	    </style:style>
+	    <style:style style:name="Table1.D" style:family="table-column">
+	      <style:table-column-properties style:column-width="1.0in" style:rel-column-width="10000*"/>
+	    </style:style>
 	    <style:style style:name="Table1.1" style:family="table-cell">
 	      <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"/>
 	    </style:style>
@@ -92,6 +95,10 @@ odt_content(){
 	    <style:style style:name="P3" style:family="paragraph" style:parent-style-name="Standard">
 	      <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"/>
 	    </style:style>
+	    <style:style style:name="P4" style:family="paragraph" style:parent-style-name="Standard">
+	      <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
+	      <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"/>
+	    </style:style>
 	    <style:style style:name="P5" style:family="paragraph" style:parent-style-name="Standard">
 	      <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
 	      <style:text-properties fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
@@ -127,13 +134,13 @@ odt_content(){
 	        </draw:frame><draw:frame draw:style-name="fr2" draw:name="Rahmen2" text:anchor-type="paragraph" svg:width="1.8228in">
 	          <draw:text-box fo:min-height="1.8992in">
 	            <text:p text:style-name="P5"><!--
-                 -->$(HTML "$sender" |sed -r 's;(&#13\;)?&#10\;;<text:line-break/>;g')<!--
+                 -->$(HTML "$sender" |sed -r 's;(&#13\;)?&#10\;|(&#x0?[Dd]\;)?&#x0?[aA]\;|\r?$;<text:line-break/>;g')<!--
 	         --></text:p>
 	          </draw:text-box>
 	        </draw:frame><draw:frame draw:style-name="fr3" draw:name="Rahmen1" text:anchor-type="paragraph" svg:y="1.3799in" svg:width="3.4398in">
 	          <draw:text-box fo:min-height="1.3311in">
 	            <text:p text:style-name="P3"><!--
-                   -->$(HTML "$client" |sed -r 's;(&#13\;)?&#10\;;<text:line-break/>;g')<!--
+                   -->$(HTML "$client" |sed -r 's;(&#13\;)?&#10\;|(&#x0?[Dd]\;)?&#x0?[aA]\;|\r?$;<text:line-break/>;g')<!--
 	           --></text:p>
 	          </draw:text-box>
 	        </draw:frame><text:span text:style-name="T3">Rechnung ${number}</text:span>
@@ -152,8 +159,8 @@ odt_content(){
 	      <table:table table:name="Table1" table:style-name="Table1">
 	        <table:table-column table:style-name="Table1.A"/>
 	        <table:table-column table:style-name="Table1.B"/>
-	        <table:table-column table:style-name="Table1.CD"/>
-	        <table:table-column table:style-name="Table1.CD"/>
+	        <table:table-column table:style-name="Table1.C"/>
+	        <table:table-column table:style-name="Table1.D"/>
 	        <table:table-header-rows>
 	          <table:table-row>
 	            <table:table-cell table:style-name="Table1.1" office:value-type="string">
@@ -171,13 +178,13 @@ odt_content(){
 	          </table:table-row>
 	        </table:table-header-rows>
 		$(sed 1d "invoices/$id" |while read -r time work hours; do
-                   time="$(UNSTRING "${time#time=}")"
-                   work="$(UNSTRING "${work#work=}")"
+                   time="$(UNSTRING "${time#time=}" |sed 's;\r;<text:line-break/>;g')"
+                   work="$(UNSTRING "${work#work=}" |sed 's;\r;<text:line-break/>;g')"
                   hours="$(UNSTRING "${hours#hours=}")"
 		  cat <<-TROW
 			<table:table-row>
 			  <table:table-cell table:style-name="Table1.2" office:value-type="string">
-			    <text:p text:style-name="P3">${time}</text:p>
+			    <text:p text:style-name="P4">${time} </text:p>
 			  </table:table-cell>
 			  <table:table-cell table:style-name="Table1.2" office:value-type="string">
 			    <text:p text:style-name="P3">${work}</text:p>