← 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_tender_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_tender_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
  <Style ss:ID="short_date">
 
44
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
 
45
   <Borders>
 
46
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
 
47
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
 
48
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
 
49
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
 
50
   </Borders>
 
51
   <NumberFormat ss:Format="Short Date"/>
 
52
  </Style>
 
53
</Styles>
 
54
## ==================================== we loop over the purchase_order "objects" == purchase_order  ====================================================
 
55
% for o in objects:
 
56
<ss:Worksheet ss:Name="Tender">
 
57
 
 
58
## definition of the columns' size
 
59
<% nb_of_columns = 6 %>
 
60
<Table x:FullColumns="1" x:FullRows="1">
 
61
<Column ss:AutoFitWidth="1" ss:Width="120" />
 
62
<Column ss:AutoFitWidth="1" ss:Width="320" />
 
63
% for x in range(2,nb_of_columns):
 
64
<Column ss:AutoFitWidth="1" ss:Width="70" />
 
65
% endfor
 
66
    
 
67
## we loop over the tender_line_ids
 
68
    <Row>
 
69
        <Cell ss:StyleID="header" ><Data ss:Type="String">Product Code</Data></Cell>
 
70
        <Cell ss:StyleID="header" ><Data ss:Type="String">Product Description</Data></Cell>
 
71
        <Cell ss:StyleID="header" ><Data ss:Type="String">Quantity</Data></Cell>
 
72
        <Cell ss:StyleID="header" ><Data ss:Type="String">UoM</Data></Cell>
 
73
        <Cell ss:StyleID="header" ><Data ss:Type="String">Price</Data></Cell>
 
74
        <Cell ss:StyleID="header" ><Data ss:Type="String">Delivery requested date</Data></Cell>
 
75
    </Row>
 
76
    % for line in o.tender_line_ids:
 
77
    <Row>
 
78
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.product_id.default_code or '')|x}</Data></Cell>
 
79
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.product_id.name or '')|x}</Data></Cell>
 
80
        <Cell ss:StyleID="line" ><Data ss:Type="Number">${(line.qty or '')|x}</Data></Cell>
 
81
        <Cell ss:StyleID="line" ><Data ss:Type="String">${(line.product_uom.name or '')|x}</Data></Cell>
 
82
        <Cell ss:StyleID="line" ><Data ss:Type="Number">${(line.price_unit or '')|x}</Data></Cell>
 
83
        % if o.requested_date :
 
84
        <Cell ss:StyleID="short_date" ><Data ss:Type="DateTime">${o.requested_date|n}T00:00:00.000</Data></Cell>
 
85
        %endif
 
86
    </Row>
 
87
    % endfor
 
88
% endfor
 
89
</Table>
 
90
<x:WorksheetOptions/></ss:Worksheet></Workbook>
 
 
b'\\ No newline at end of file'