← Back to branch summary

~unifield-team/unifield-wm/us-927

« back to all changes in this revision

Viewing changes to msf_supply_doc_export/report/report_internal_request_xls.mako

  • Committer: duy.vo at msf
  • Date: 2012-09-18 21:16:31 UTC
  • mto: This revision was merged to the branch mainline in revision 1188.
  • Revision ID: duy.vo@geneva.msf.org-20120918211631-t5e7fjeumxobhcma
UF-1055: Merged with trunk 1175

Show diffs side-by-side

added added

removed removed

Lines of Context:
msf_supply_doc_export/report/report_internal_request_xls.mako
 
1
<?xml version="1.0"?>
 
2
<?mso-application progid="Excel.Sheet"?>
 
3
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 
4
 xmlns:o="urn:schemas-microsoft-com:office:office"
 
5
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 
6
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 
7
 xmlns:html="http://www.w3.org/TR/REC-html40">
 
8
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
 
9
  <Author>MSFUser</Author>
 
10
  <LastAuthor>MSFUser</LastAuthor>
 
11
  <Created>2012-06-18T15:46:09Z</Created>
 
12
  <Company>Medecins Sans Frontieres</Company>
 
13
  <Version>11.9999</Version>
 
14
 </DocumentProperties>
 
15
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
 
16
  <WindowHeight>13170</WindowHeight>
 
17
  <WindowWidth>19020</WindowWidth>
 
18
  <WindowTopX>120</WindowTopX>
 
19
  <WindowTopY>60</WindowTopY>
 
20
  <ProtectStructure>False</ProtectStructure>
 
21
  <ProtectWindows>False</ProtectWindows>
 
22
 </ExcelWorkbook>
 
23
<Styles>
 
24
    <Style ss:ID="header">
 
25
        <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
 
26
        <Interior ss:Color="#ffcc99" ss:Pattern="Solid"/>
 
27
        <Borders>
 
28
          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
 
29
          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
 
30
          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
 
31
          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
 
32
        </Borders>
 
33
    </Style>
 
34
    <Style ss:ID="line">
 
35
        <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
 
36
        <Borders>
 
37
          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
 
38
          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
 
39
          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
 
40
          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
 
41
        </Borders>
 
42
    </Style>
 
43
</Styles>
 
44
## we loop over the sale_order so "objects" == sale_order
 
45
% for o in objects:
 
46
## we loop over the sale_order_line
 
47
<ss:Worksheet ss:Name="Internal Request">
 
48
## definition of the columns' size
 
49
<% nb_of_columns = 6 %>
 
50
<Table x:FullColumns="1" x:FullRows="1">
 
51
<Column ss:AutoFitWidth="1" ss:Width="120" />
 
52
<Column ss:AutoFitWidth="1" ss:Width="320" />
 
53
% for x in range(2,nb_of_columns - 1):
 
54
<Column ss:AutoFitWidth="1" ss:Width="70" />
 
55
% endfor
 
56
<Column ss:AutoFitWidth="1" ss:Width="250" />
 
57
    <Row>
 
58
        <Cell ss:StyleID="header" ><Data ss:Type="String">Product Code</Data></Cell>
 
59
        <Cell ss:StyleID="header" ><Data ss:Type="String">Product Description</Data></Cell>
 
60
        <Cell ss:StyleID="header" ><Data ss:Type="String">Quantity</Data></Cell>
 
61
        <Cell ss:StyleID="header" ><Data ss:Type="String">UoM</Data></Cell>
 
62
        <Cell ss:StyleID="header" ><Data ss:Type="String">Currency</Data></Cell>
 
63
        <Cell ss:StyleID="header" ><Data ss:Type="String">Comment</Data></Cell>
 
64
    </Row>
 
65
    % for line in o.order_line:
 
66
    <Row>
 
67
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.product_id.default_code or '')|x}</Data></Cell>
 
68
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.product_id.name or '')|x}</Data></Cell>
 
69
        <Cell ss:StyleID="line" ><Data ss:Type="Number">${(line.product_uom_qty or '')|x}</Data></Cell>
 
70
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.product_uom.name or '')|x}</Data></Cell>
 
71
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.functional_currency_id.name or '')|x}</Data></Cell>
 
72
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.comment or '')|x}</Data></Cell>
 
73
    </Row>
 
74
    % endfor
 
75
% endfor
 
76
</Table>
 
77
<x:WorksheetOptions/></ss:Worksheet></Workbook>
 
 
b'\\ No newline at end of file'