Mercurial > gemma
annotate pkg/xlsx/templater.go @ 5361:ce1fe22bda5a extented-report
Backed out changeset f845c3b7b68e
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 22 Jun 2021 17:12:17 +0200 |
parents | f845c3b7b68e |
children | f733bb327b9b |
rev | line source |
---|---|
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
1 // This is Free Software under GNU Affero General Public License v >= 3.0 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
2 // without warranty, see README.md and license for details. |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
3 // |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
4 // SPDX-License-Identifier: AGPL-3.0-or-later |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
5 // License-Filename: LICENSES/AGPL-3.0.txt |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
6 // |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
7 // Copyright (C) 2021 by via donau |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
8 // – Österreichische Wasserstraßen-Gesellschaft mbH |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
9 // Software engineering by Intevation GmbH |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
10 // |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
11 // Author(s): |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
12 // * Sascha L. Teichmann <sascha.teichmann@intevation.de> |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
13 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
14 package xlsx |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
15 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
16 import ( |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
17 "bufio" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
18 "context" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
19 "database/sql" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
20 "errors" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
21 "fmt" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
22 "io" |
5349
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
23 "log" |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
24 "os" |
5349
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
25 "strconv" |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
26 "strings" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
27 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
28 "github.com/360EntSecGroup-Skylar/excelize/v2" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
29 "gopkg.in/yaml.v2" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
30 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
31 "github.com/PaesslerAG/gval" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
32 ) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
33 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
34 type Action struct { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
35 Type string `yaml:"type"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
36 Actions []*Action `yaml:"actions"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
37 Location []string `yaml:"location"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
38 Source string `yaml:"source"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
39 Destination string `yaml:"destination"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
40 Statement string `yaml:"statement"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
41 Vars []string `yaml:"vars"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
42 Name string `yaml:"name"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
43 Expr string `yaml:"expr"` |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
44 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
45 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
46 type frame struct { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
47 res *sqlResult |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
48 index int |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
49 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
50 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
51 type executor struct { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
52 ctx context.Context |
5333
6c0f40676984
Run xlsx templating in a read-only transaction.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5325
diff
changeset
|
53 tx *sql.Tx |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
54 template *excelize.File |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
55 keep map[string]bool |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
56 expressions map[string]gval.Evaluable |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
57 sourceSheet string |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
58 destinationSheet string |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
59 frames []frame |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
60 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
61 |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
62 type area struct { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
63 x1 int |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
64 y1 int |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
65 x2 int |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
66 y2 int |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
67 mc excelize.MergeCell |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
68 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
69 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
70 func mergeCellToArea(mc excelize.MergeCell) (area, error) { |
5346
72469b713705
XLSX templater: Cosmetics
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5344
diff
changeset
|
71 x1, y1, err := excelize.CellNameToCoordinates(mc.GetStartAxis()) |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
72 if err != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
73 return area{}, err |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
74 } |
5346
72469b713705
XLSX templater: Cosmetics
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5344
diff
changeset
|
75 x2, y2, err := excelize.CellNameToCoordinates(mc.GetEndAxis()) |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
76 if err != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
77 return area{}, err |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
78 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
79 return area{ |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
80 x1: x1, |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
81 y1: y1, |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
82 x2: x2, |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
83 y2: y2, |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
84 mc: mc, |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
85 }, nil |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
86 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
87 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
88 func (a *area) contains(x, y int) bool { |
5346
72469b713705
XLSX templater: Cosmetics
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5344
diff
changeset
|
89 return a.x1 <= x && x <= a.x2 && a.y1 <= y && y <= a.y2 |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
90 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
91 |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
92 func ActionFromFile(filename string) (*Action, error) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
93 f, err := os.Open(filename) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
94 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
95 return nil, err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
96 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
97 defer f.Close() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
98 return ActionFromReader(f) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
99 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
100 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
101 func ActionFromReader(r io.Reader) (*Action, error) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
102 action := new(Action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
103 err := yaml.NewDecoder(bufio.NewReader(r)).Decode(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
104 return action, err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
105 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
106 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
107 func (a *Action) Execute( |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
108 ctx context.Context, |
5333
6c0f40676984
Run xlsx templating in a read-only transaction.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5325
diff
changeset
|
109 tx *sql.Tx, |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
110 template *excelize.File, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
111 ) error { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
112 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
113 e := executor{ |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
114 ctx: ctx, |
5333
6c0f40676984
Run xlsx templating in a read-only transaction.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5325
diff
changeset
|
115 tx: tx, |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
116 template: template, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
117 keep: map[string]bool{}, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
118 expressions: map[string]gval.Evaluable{}, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
119 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
120 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
121 oldSheets := template.GetSheetList() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
122 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
123 if err := e.dispatch(a); err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
124 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
125 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
126 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
127 for _, sheet := range oldSheets { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
128 if !e.keep[sheet] { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
129 template.DeleteSheet(sheet) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
130 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
131 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
132 return nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
133 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
134 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
135 func (e *executor) dispatch(action *Action) error { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
136 if len(action.Vars) > 0 { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
137 e.pushVars(action.Vars) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
138 defer e.popFrame() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
139 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
140 switch action.Type { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
141 case "sheet": |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
142 return e.sheet(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
143 case "copy": |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
144 return e.copy(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
145 case "select": |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
146 return e.sel(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
147 case "assign": |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
148 return e.assign(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
149 case "": |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
150 return e.actions(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
151 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
152 return fmt.Errorf("unknown type '%s'", action.Type) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
153 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
154 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
155 func (e *executor) pushVars(vars []string) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
156 e.frames = append(e.frames, frame{ |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
157 res: &sqlResult{ |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
158 columns: vars, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
159 rows: [][]interface{}{make([]interface{}, len(vars))}, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
160 }, |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
161 }) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
162 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
163 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
164 func (e *executor) popFrame() { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
165 n := len(e.frames) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
166 e.frames[n-1].res = nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
167 e.frames = e.frames[:n-1] |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
168 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
169 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
170 func (e *executor) assign(action *Action) error { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
171 if action.Name == "" { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
172 return errors.New("missing name in assign") |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
173 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
174 if action.Expr == "" { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
175 return errors.New("missing expr in assign") |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
176 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
177 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
178 for i := len(e.frames) - 1; i >= 0; i-- { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
179 fr := &e.frames[i] |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
180 if idx := fr.res.find(action.Name); idx >= 0 { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
181 f, err := e.expr(action.Expr) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
182 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
183 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
184 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
185 value, err := f(e.ctx, e.vars()) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
186 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
187 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
188 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
189 fr.res.rows[fr.index][idx] = value |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
190 break |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
191 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
192 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
193 return e.actions(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
194 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
195 |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
196 func order(a, b int) (int, int) { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
197 if a < b { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
198 return a, b |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
199 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
200 return b, a |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
201 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
202 |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
203 func (e *executor) copy(action *Action) error { |
5325
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
204 if n := len(action.Location); !(n == 1 || n == 2) { |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
205 return fmt.Errorf("length location = %d (expect 1 or 2)", |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
206 len(action.Location)) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
207 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
208 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
209 vars := e.vars() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
210 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
211 var err error |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
212 expand := func(s string) string { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
213 if err == nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
214 s, err = e.expand(s, vars) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
215 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
216 return s |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
217 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
218 split := func(s string) (int, int) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
219 var x, y int |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
220 if err == nil { |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
221 x, y, err = excelize.CellNameToCoordinates(s) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
222 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
223 return x, y |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
224 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
225 |
5325
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
226 var location []string |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
227 if len(action.Location) == 1 { |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
228 location = []string{action.Location[0], action.Location[0]} |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
229 } else { |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
230 location = action.Location |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
231 } |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
232 |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
233 var destination string |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
234 if action.Destination == "" { |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
235 destination = location[0] |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
236 } else { |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
237 destination = action.Destination |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
238 } |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
239 |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
240 var ( |
5325
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
241 s1 = expand(location[0]) |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
242 s2 = expand(location[1]) |
313bf3f3a8b1
XLSX templater: Simplify copy action.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5321
diff
changeset
|
243 d1 = expand(destination) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
244 sx1, sy1 = split(s1) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
245 sx2, sy2 = split(s2) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
246 dx1, dy1 = split(d1) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
247 ) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
248 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
249 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
250 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
251 sx1, sx2 = order(sx1, sx2) |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
252 sy1, sy2 = order(sy1, sy2) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
253 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
254 var areas []area |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
255 |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
256 //log.Println("merged cells") |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
257 if mcs, err := e.template.GetMergeCells(e.sourceSheet); err == nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
258 areas = make([]area, 0, len(mcs)) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
259 for _, mc := range mcs { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
260 if a, err := mergeCellToArea(mc); err == nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
261 areas = append(areas, a) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
262 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
263 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
264 } |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
265 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
266 for y, i := sy1, 0; y <= sy2; y, i = y+1, i+1 { |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
267 nextX: |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
268 for x, j := sx1, 0; x <= sx2; x, j = x+1, j+1 { |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
269 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
270 // check if cell is part of a merged cell |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
271 for k := range areas { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
272 area := &areas[k] |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
273 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
274 if area.contains(x, y) { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
275 ofsX := x - area.x1 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
276 ofsY := y - area.y1 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
277 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
278 sx := dx1 + j - ofsX |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
279 sy := dy1 + i - ofsY |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
280 ex := sx + (area.x2 - area.x1) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
281 ey := sy + (area.y2 - area.y1) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
282 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
283 // Copy over attributes |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
284 for l := 0; l <= area.x2-area.x1; l++ { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
285 for m := 0; m <= area.y2-area.y1; m++ { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
286 src, err1 := excelize.CoordinatesToCellName(area.x1+l, area.y1+m) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
287 dst, err2 := excelize.CoordinatesToCellName(sx+l, sy+m) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
288 if err1 != nil || err2 != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
289 continue |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
290 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
291 if s, err := e.template.GetCellStyle(e.sourceSheet, src); err == nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
292 e.template.SetCellStyle(e.destinationSheet, dst, dst, s) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
293 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
294 if s, err := e.template.GetCellFormula(e.sourceSheet, src); err == nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
295 e.template.SetCellFormula(e.destinationSheet, dst, s) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
296 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
297 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
298 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
299 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
300 dst, err := excelize.CoordinatesToCellName(sx, sy) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
301 if err != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
302 continue nextX |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
303 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
304 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
305 // Copy over expanded text |
5354
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
306 if v, err := e.typedExpand(area.mc.GetCellValue(), vars); err == nil { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
307 e.template.SetCellValue(e.destinationSheet, dst, v) |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
308 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
309 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
310 // Finally merge the cells |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
311 if end, err := excelize.CoordinatesToCellName(ex, ey); err == nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
312 e.template.MergeCell(e.destinationSheet, dst, end) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
313 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
314 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
315 continue nextX |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
316 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
317 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
318 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
319 // Regular cell |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
320 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
321 src, err := excelize.CoordinatesToCellName(x, y) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
322 if err != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
323 continue |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
324 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
325 dst, err := excelize.CoordinatesToCellName(dx1+j, dy1+i) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
326 if err != nil { |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
327 continue |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
328 } |
5343
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
329 |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
330 cn, err := excelize.ColumnNumberToName(x) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
331 if err != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
332 continue |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
333 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
334 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
335 cw, err := e.template.GetColWidth(e.sourceSheet, cn) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
336 if err != nil { |
5343
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
337 continue |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
338 } |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
339 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
340 rh, err := e.template.GetRowHeight(e.sourceSheet, y) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
341 if err != nil { |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
342 continue |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
343 } |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
344 |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
345 dc, err := excelize.ColumnNumberToName(dx1 + j) |
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
346 if err != nil { |
5343
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
347 continue |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
348 } |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
349 |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
350 if e.template.SetColWidth(e.destinationSheet, dc, dc, cw) != nil { |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
351 continue |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
352 } |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
353 |
5344
7df6062a1371
XLSX: Implemented correct handling of merged cells.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5343
diff
changeset
|
354 if e.template.SetRowHeight(e.destinationSheet, dy1+i, rh) != nil { |
5343
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
355 continue |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
356 } |
bb6761abd81d
XLSX template: Copy column and row height explicitly.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5333
diff
changeset
|
357 |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
358 if s, err := e.template.GetCellStyle(e.sourceSheet, src); err == nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
359 e.template.SetCellStyle(e.destinationSheet, dst, dst, s) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
360 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
361 if s, err := e.template.GetCellFormula(e.sourceSheet, src); err == nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
362 e.template.SetCellFormula(e.destinationSheet, dst, s) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
363 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
364 if s, err := e.template.GetCellValue(e.sourceSheet, src); err == nil { |
5354
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
365 if v, err := e.expand(s, vars); err == nil { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
366 e.template.SetCellValue(e.destinationSheet, dst, v) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
367 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
368 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
369 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
370 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
371 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
372 return nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
373 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
374 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
375 func (e *executor) sel(action *Action) error { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
376 vars := e.vars() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
377 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
378 eval := func(x string) (interface{}, error) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
379 f, err := e.expr(x) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
380 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
381 return nil, err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
382 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
383 return f(e.ctx, vars) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
384 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
385 |
5333
6c0f40676984
Run xlsx templating in a read-only transaction.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5325
diff
changeset
|
386 res, err := query(e.ctx, e.tx, action.Statement, eval) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
387 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
388 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
389 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
390 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
391 e.frames = append(e.frames, frame{res: res}) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
392 defer e.popFrame() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
393 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
394 for i := range res.rows { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
395 e.frames[len(e.frames)-1].index = i |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
396 if err := e.actions(action); err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
397 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
398 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
399 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
400 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
401 return nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
402 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
403 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
404 func (e *executor) actions(action *Action) error { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
405 for _, a := range action.Actions { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
406 if err := e.dispatch(a); err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
407 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
408 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
409 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
410 return nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
411 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
412 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
413 func (e *executor) sheet(action *Action) error { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
414 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
415 vars := e.vars() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
416 source, err := e.expand(action.Source, vars) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
417 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
418 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
419 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
420 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
421 srcIdx := e.template.GetSheetIndex(source) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
422 if srcIdx == -1 { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
423 return fmt.Errorf("sheet '%s' not found", source) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
424 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
425 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
426 destination := action.Destination |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
427 if destination == "" { // same as source |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
428 e.keep[source] = true |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
429 destination = source |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
430 } else { // new sheet |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
431 destination, err = e.expand(destination, vars) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
432 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
433 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
434 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
435 dstIdx := e.template.NewSheet(destination) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
436 if len(action.Actions) == 0 { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
437 // Only copy if there are no explicit instructions. |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
438 if err := e.template.CopySheet(srcIdx, dstIdx); err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
439 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
440 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
441 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
442 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
443 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
444 if len(action.Actions) > 0 { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
445 pSrc, pDst := e.sourceSheet, e.destinationSheet |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
446 defer func() { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
447 e.sourceSheet, e.destinationSheet = pSrc, pDst |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
448 }() |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
449 e.sourceSheet, e.destinationSheet = source, destination |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
450 return e.actions(action) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
451 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
452 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
453 // Simple filling |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
454 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
455 // "{{" only as a quick filter |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
456 result, err := e.template.SearchSheet(destination, "{{", true) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
457 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
458 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
459 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
460 for _, axis := range result { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
461 value, err := e.template.GetCellValue(destination, axis) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
462 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
463 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
464 } |
5361
ce1fe22bda5a
Backed out changeset f845c3b7b68e
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5360
diff
changeset
|
465 value, err = e.expand(value, vars) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
466 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
467 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
468 } |
5361
ce1fe22bda5a
Backed out changeset f845c3b7b68e
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5360
diff
changeset
|
469 if err := e.template.SetCellStr(destination, axis, value); err != nil { |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
470 return err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
471 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
472 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
473 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
474 return nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
475 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
476 |
5349
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
477 func columnToNum(col interface{}) interface{} { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
478 var name string |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
479 switch v := col.(type) { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
480 case string: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
481 name = v |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
482 default: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
483 name = fmt.Sprintf("%v", col) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
484 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
485 num, err := excelize.ColumnNameToNumber(name) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
486 if err != nil { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
487 log.Printf("error: invalid column name '%v'\n", col) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
488 return 1 |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
489 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
490 return num |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
491 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
492 |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
493 func asInt(i interface{}) (int, error) { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
494 switch v := i.(type) { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
495 case int: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
496 return v, nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
497 case int8: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
498 return int(v), nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
499 case int16: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
500 return int(v), nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
501 case int32: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
502 return int(v), nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
503 case int64: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
504 return int(v), nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
505 case float32: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
506 return int(v), nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
507 case float64: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
508 return int(v), nil |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
509 case string: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
510 return strconv.Atoi(v) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
511 default: |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
512 return 0, fmt.Errorf("invalid int '%v'", i) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
513 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
514 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
515 |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
516 func coord2cell(ix, iy interface{}) interface{} { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
517 x, err := asInt(ix) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
518 if err != nil { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
519 log.Printf("error: invalid x value: %v\n", err) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
520 return "A1" |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
521 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
522 y, err := asInt(iy) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
523 if err != nil { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
524 log.Printf("error: invalid y value: %v\n", err) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
525 return "A1" |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
526 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
527 |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
528 cell, err := excelize.CoordinatesToCellName(x, y) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
529 if err != nil { |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
530 log.Printf("error: invalid cell coord (%d, %d)\n", x, y) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
531 return "A1" |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
532 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
533 return cell |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
534 } |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
535 |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
536 var templateLang = gval.Full( |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
537 gval.Function("column2num", columnToNum), |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
538 gval.Function("coord2cell", coord2cell), |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
539 ) |
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
540 |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
541 func (e *executor) expr(x string) (gval.Evaluable, error) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
542 if f := e.expressions[x]; f != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
543 return f, nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
544 } |
5349
a352a695b69c
XLSX templater: Added column to coord conversions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5346
diff
changeset
|
545 f, err := templateLang.NewEvaluable(x) |
5321
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
546 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
547 return nil, err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
548 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
549 e.expressions[x] = f |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
550 return f, nil |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
551 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
552 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
553 func (e *executor) vars() map[string]interface{} { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
554 vars := map[string]interface{}{} |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
555 if len(e.frames) > 0 { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
556 vars["row_number"] = e.frames[len(e.frames)-1].index |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
557 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
558 for i := len(e.frames) - 1; i >= 0; i-- { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
559 fr := &e.frames[i] |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
560 for j, n := range fr.res.columns { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
561 if _, found := vars[n]; !found { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
562 vars[n] = fr.res.rows[fr.index][j] |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
563 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
564 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
565 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
566 return vars |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
567 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
568 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
569 func (e *executor) expand(str string, vars map[string]interface{}) (string, error) { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
570 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
571 var err error |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
572 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
573 replace := func(s string) string { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
574 if err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
575 return "" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
576 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
577 var eval gval.Evaluable |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
578 if eval, err = e.expr(strings.TrimSpace(s)); err != nil { |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
579 return "" |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
580 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
581 s, err = eval.EvalString(e.ctx, vars) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
582 return s |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
583 } |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
584 |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
585 str = handlebars(str, replace) |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
586 return str, err |
0919946f624b
Added a report controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
587 } |
5354
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
588 |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
589 func (e *executor) typedExpand(str string, vars map[string]interface{}) (interface{}, error) { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
590 |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
591 var ( |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
592 err error |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
593 repCount int |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
594 last interface{} |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
595 ) |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
596 |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
597 replace := func(s string) string { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
598 if err != nil { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
599 return "" |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
600 } |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
601 var eval gval.Evaluable |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
602 if eval, err = e.expr(strings.TrimSpace(s)); err != nil { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
603 return "" |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
604 } |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
605 repCount++ |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
606 last, err = eval(e.ctx, vars) |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
607 return fmt.Sprintf("%v", last) |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
608 } |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
609 |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
610 nstr := handlebars(str, replace) |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
611 |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
612 if err != nil { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
613 return nil, err |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
614 } |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
615 |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
616 if repCount == 1 && strings.HasPrefix(str, "{{") && strings.HasSuffix(str, "}}") { |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
617 // log.Printf("typed eval: %T\n", last) |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
618 return last, nil |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
619 } |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
620 return nstr, nil |
6a94ab82eaaa
XLSX templater: Added type support for cell expansion.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5349
diff
changeset
|
621 } |