tax report prob solved.(Amit Patel)
[odoo/odoo.git] / addons / hr_timesheet_invoice / report / account_analytic_profit.rml
index 0fc27c8..897bb26 100644 (file)
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
     </blockTableStyle>
-    <blockTableStyle id="Table5">
+    <blockTableStyle id="Table_Title">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
     </blockTableStyle>
-    <blockTableStyle id="Table1">
+    <blockTableStyle id="Table_header_Date">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
@@ -28,7 +28,7 @@
       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
     </blockTableStyle>
-    <blockTableStyle id="Table3">
+    <blockTableStyle id="Table_Content_Date">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
@@ -42,7 +42,7 @@
       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
     </blockTableStyle>
-    <blockTableStyle id="Table8">
+    <blockTableStyle id="Table_Header_Employee">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
       <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
-      <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
     </blockTableStyle>
-    <blockTableStyle id="Table4">
+    <blockTableStyle id="Table_Final_Total">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
-      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
-      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="22,-1" stop="22,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
     </blockTableStyle>
-    <blockTableStyle id="Table2">
+    <blockTableStyle id="Table_Journal_Total_detail">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
     </blockTableStyle>
-    <blockTableStyle id="Table6">
+    <blockTableStyle id="Table_Journal_title">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
     </blockTableStyle>
-    <blockTableStyle id="Table7">
+    <blockTableStyle id="Table_Move_line">
       <blockAlignment value="LEFT"/>
       <blockValign value="TOP"/>
     </blockTableStyle>
     <initialize>
       <paraStyle name="all" alignment="justify"/>
     </initialize>
-    <paraStyle name="P1" fontName="Times-Roman" fontSize="10.0" leading="13"/>
-    <paraStyle name="P2" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT"/>
-    <paraStyle name="P3" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT"/>
-    <paraStyle name="P4" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="RIGHT"/>
-    <paraStyle name="P5" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT"/>
-    <paraStyle name="P6" fontName="Times-Roman" alignment="LEFT"/>
-    <paraStyle name="P7" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT"/>
-    <paraStyle name="P8" fontName="Times-Roman" alignment="LEFT"/>
     <paraStyle name="Standard" fontName="Times-Roman"/>
     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
     <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
@@ -92,7 +90,6 @@
     <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
     <paraStyle name="Index" fontName="Times-Roman"/>
     <paraStyle name="Preformatted Text" fontName="Courier" fontSize="10.0" leading="13" spaceBefore="0.0" spaceAfter="0.0"/>
-    <paraStyle name="Untitled1" fontName="Times-Roman"/>
     <paraStyle name="Footer" fontName="Times-Roman"/>
     <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
-    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9_bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
     <paraStyle name="terp_default_centre_bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9_bold_U" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
   </stylesheet>
   <images/>
   <story>
-    <blockTable colWidths="175.0,175.0,175.0" repeatRows="1" style="Table5">
+    <blockTable colWidths="175.0,175.0,175.0" repeatRows="1" style="Table_Title">
       <tr>
         <td>
-          <para style="terp_default_9">
+          <para style="terp_default_8">
             <font color="white"> </font>
           </para>
         </td>
           <para style="terp_header_Centre">Invoice rate by user</para>
         </td>
         <td>
-          <para style="P4">
+          <para style="terp_default_8">
             <font color="white"> </font>
           </para>
-          <para style="P3">
+          <para style="terp_default_8">
             <font color="white"> </font>
           </para>
         </td>
       </tr>
     </blockTable>
-    <para style="P6">
+    <para style="terp_default_8">
       <font color="white"> </font>
     </para>
-    <blockTable colWidths="175.0,175.0,175.0" style="Table1">
+    <blockTable colWidths="175.0,175.0,175.0" style="Table_header_Date">
       <tr>
         <td>
-          <para style="terp_default_centre_bold_9">Period from startdate</para>
+          <para style="terp_tblheader_General_Centre">Period from startdate</para>
         </td>
         <td>
-          <para style="terp_default_centre_bold_9">Period to enddate</para>
+          <para style="terp_tblheader_General_Centre">Period to enddate</para>
         </td>
         <td>
-          <para style="terp_default_centre_bold_9">Currency</para>
+          <para style="terp_tblheader_General_Centre">Currency</para>
         </td>
       </tr>
     </blockTable>
-    <blockTable colWidths="175.0,175.0,175.0" style="Table3">
+    <blockTable colWidths="175.0,175.0,175.0" style="Table_Content_Date">
       <tr>
         <td>
-          <para style="terp_default_Centre_9">[[ data['form']['date_from'] ]]</para>
+          <para style="terp_default_Centre_8">[[ data['form']['date_from'] ]]</para>
         </td>
         <td>
-          <para style="terp_default_Centre_9">[[ data['form']['date_to'] ]]</para>
+          <para style="terp_default_Centre_8">[[ data['form']['date_to'] ]]</para>
         </td>
         <td>
-          <para style="terp_default_Centre_9">[[ company.currency_id.name ]]</para>
+          <para style="terp_default_Centre_8">[[ company.currency_id.name ]]</para>
         </td>
       </tr>
     </blockTable>
-    <para style="P6">
+    <para style="terp_default_8">
       <font color="white"> </font>
     </para>
-    <para style="terp_default_9">
+    <para style="terp_default_8">
       <font color="white"> </font>
     </para>
-    <blockTable colWidths="118.0,44.0,55.0,67.0,71.0,66.0,52.0,50.0" style="Table8">
+    <blockTable colWidths="159.0,62.0,63.0,68.0,65.0,53.0,52.0" style="Table_Header_Employee">
       <tr>
         <td>
-          <para style="terp_tblheader_Details">Employee</para>
+          <para style="terp_tblheader_Details">Employee or Journal Name</para>
         </td>
         <td>
-          <para style="terp_default_Bold_9">
-            <font color="white"> </font>
-          </para>
+          <para style="terp_tblheader_Details_Right">Units</para>
         </td>
         <td>
-          <para style="terp_tblheader_Details">Units</para>
+          <para style="terp_tblheader_Details_Right">Theorical</para>
         </td>
         <td>
-          <para style="terp_tblheader_Details">Theorical</para>
+          <para style="terp_tblheader_Details_Right">Income</para>
         </td>
         <td>
-          <para style="terp_tblheader_Details">Income</para>
+          <para style="terp_tblheader_Details_Right">Cost</para>
         </td>
         <td>
-          <para style="terp_tblheader_Details">Cost</para>
+          <para style="terp_tblheader_Details_Right">Profit</para>
         </td>
         <td>
-          <para style="terp_tblheader_Details">Profit</para>
-        </td>
-        <td>
-          <para style="terp_tblheader_Details">Eff.</para>
+          <para style="terp_tblheader_Details_Right">Eff.</para>
         </td>
       </tr>
     </blockTable>
-    <para style="P6">
+    <para style="terp_default_2">
       <font color="white"> </font>
     </para>
+    <blockTable colWidths="154.0,65.0,60.0,72.0,66.0,52.0,51.0" style="Table_Final_Total">
+      <tr>
+        <td>
+          <para style="terp_default_Bold_9">Totals:</para>
+        </td>
+        <td>
+          <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['unit_amount'], line(data['form'], data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</u></para>
+        </td>
+        <td>
+          <para style="terp_default_Right_9_bold">
+            <font color="white"> </font>
+          </para>
+        </td>
+        <td>
+          <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['amount'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</u></para>
+        </td>
+        <td>
+          <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['cost'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</u></para>
+        </td>
+        <td>
+          <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['profit'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</u></para>
+        </td>
+        <td>
+          <para style="terp_default_Right_9_bold_U"><u>[[ round(reduce(lambda x, y: x+y['amount'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0)/reduce(lambda x, y: x+y['cost'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0)* -100, 2)]] %</u></para>
+        </td>
+      </tr>
+    </blockTable>
+    <para style="terp_default_2"/>
     <section>
-      <para style="terp_default_9">[[ repeatIn(user_ids(lines(data['form'])), 'e') ]]</para>
-      <blockTable colWidths="521.0,4.0" style="Table4">
+      <para style="terp_default_8">[[ repeatIn(user_ids(lines(data['form'])), 'e') ]]</para>
+      <blockTable colWidths="137.0,16.0,65.0,61.0,71.0,66.0,52.0,51.0" style="Table_Journal_Total_detail">
         <tr>
           <td>
-            <para style="terp_header">[[ e.name ]]</para>
+            <para style="terp_default_Bold_9">[[ e.name ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_8">[[ repeatIn(journal_ids(data['form'], e.id), 'j') ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['unit_amount'], line(data['form'], [j.id], [e.id]), 0) ]]</u></para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['amount_th'], line(data['form'], [j.id], [e.id]), 0) ]]</u></para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['amount'], line(data['form'], [j.id], [e.id]), 0) ]]</u></para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['cost'], line(data['form'], [j.id], [e.id]), 0) ]]</u></para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9_bold_U"><u>[[ reduce(lambda x, y: x+y['profit'], line(data['form'], [j.id], [e.id]), 0) ]]</u></para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9_bold_U"><u>[[ '%d' % (reduce(lambda x, y: x+y['amount'], line(data['form'], [j.id], [e.id]), 0) / reduce(lambda x, y: x+y['cost'], line(data['form'], [j.id], [e.id]), 0) * 100.0,)]] %</u></para>
           </td>
         </tr>
+      </blockTable>
+      <blockTable colWidths="154.0,65.0,61.0,71.0,66.0,52.0,51.0" style="Table_Journal_title">
         <tr>
           <td>
-            <para style="P1">[[ repeatIn(journal_ids(data['form'], e.id), 'j') ]]</para>
             <para style="terp_default_9">[[ j.name ]]</para>
-            <blockTable colWidths="160.0,57.0,66.0,61.0,68.0,52.0,334.0" style="Table2">
-              <tr>
-                <td>
-                  <para style="P7">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ reduce(lambda x, y: x+y['unit_amount'], line(data['form'], [j.id], [e.id]), 0) ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ reduce(lambda x, y: x+y['amount_th'], line(data['form'], [j.id], [e.id]), 0) ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ reduce(lambda x, y: x+y['amount'], line(data['form'], [j.id], [e.id]), 0)  ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ reduce(lambda x, y: x+y['cost'], line(data['form'], [j.id], [e.id]), 0) ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ reduce(lambda x, y: x+y['profit'], line(data['form'], [j.id], [e.id]), 0) ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ '%d' % (reduce(lambda x, y: x+y['amount'], line(data['form'], [j.id], [e.id]), 0) / reduce(lambda x, y: x+y['cost'], line(data['form'], [j.id], [e.id]), 0) * 100.0,)]] % </para>
-                </td>
-              </tr>
-              <tr>
-                <td>
-                  <para style="terp_default_9">[[ repeatIn(line(data['form'], [j.id], [e.id]), 'l') ]]</para>
-                  <para style="terp_default_9">[[ l['name'] ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ l['unit_amount'] ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ l['amount_th'] ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ l['amount'] ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ l['cost'] ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ l['profit'] ]]</para>
-                </td>
-                <td>
-                  <para style="terp_default_9">[[ l['eff'] ]] %</para>
-                </td>
-              </tr>
-              <tr>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-                <td>
-                  <para style="P5">
-                    <font color="white"> </font>
-                  </para>
-                </td>
-              </tr>
-            </blockTable>
+          </td>
+          <td>
+            <para style="terp_default_9">
+              <font color="white"> </font>
+            </para>
+          </td>
+          <td>
             <para style="terp_default_9">
               <font color="white"> </font>
             </para>
           </td>
           <td>
-            <para style="Standard">
+            <para style="terp_default_9">
               <font color="white"> </font>
             </para>
           </td>
+          <td>
+            <para style="terp_default_9">
+              <font color="white"> </font>
+            </para>
+          </td>
+          <td>
+            <para style="terp_default_9">
+              <font color="white"> </font>
+            </para>
+          </td>
+          <td>
+            <para style="terp_default_9">
+              <font color="white"> </font>
+            </para>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="terp_default_8">[[ repeatIn(line(data['form'], [j.id],[e.id]), 'l') ]] </para>
+      <blockTable colWidths="155.0,64.0,61.0,71.0,66.0,52.0,50.0" style="Table_Move_line">
+        <tr>
+          <td>
+            <para style="terp_default_8">[[ l['name'] ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ l['unit_amount'] ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ l['amount_th'] ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ l['amount'] ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ l['cost'] ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ l['profit'] ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ l['eff'] ]] %</para>
+          </td>
         </tr>
       </blockTable>
-      <section>
-        <blockTable colWidths="103.0,422.0" style="Table6">
-          <tr>
-            <td>
-              <para style="terp_default_Bold_9">Totals</para>
-            </td>
-            <td>
-              <blockTable colWidths="59.0,56.0,67.0,62.0,67.0,55.0,55.0" style="Table7">
-                <tr>
-                  <td>
-                    <para style="P2">
-                      <font color="white"> </font>
-                    </para>
-                  </td>
-                  <td>
-                    <para style="terp_default_Bold_9">[[ reduce(lambda x, y: x+y['unit_amount'], line(data['form'], data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</para>
-                  </td>
-                  <td>
-                    <para style="P2">
-                      <font color="white"> </font>
-                    </para>
-                  </td>
-                  <td>
-                    <para style="terp_default_Bold_9">[[ reduce(lambda x, y: x+y['amount'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</para>
-                  </td>
-                  <td>
-                    <para style="terp_default_Bold_9">[[ reduce(lambda x, y: x+y['cost'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</para>
-                  </td>
-                  <td>
-                    <para style="terp_default_Bold_9">[[ reduce(lambda x, y: x+y['profit'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0) ]]</para>
-                  </td>
-                  <td>
-                    <para style="terp_default_Bold_9">[[ round(reduce(lambda x, y: x+y['amount'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0)/reduce(lambda x, y: x+y['cost'], line(data['form'],data['form']['journal_ids'][0][2], data['form']['employee_ids'][0][2]), 0)* -100, 2)]] %</para>
-                  </td>
-                </tr>
-              </blockTable>
-              <para style="Table Contents">
-                <font color="white"> </font>
-              </para>
-            </td>
-          </tr>
-        </blockTable>
-        <para style="Standard">
-          <font color="white"> </font>
-        </para>
-      </section>
+      <para style="terp_default_9">
+        <font color="white"> </font>
+      </para>
     </section>
+    <para style="terp_default_8">
+      <font color="white"> </font>
+    </para>
   </story>
-</document>
+</document>
\ No newline at end of file