gemma: pkg/xlsx/templater.go annotate

annotate pkg/xlsx/templater.go @ 5694:3bc15e38c7e8 sr-v2

Typo fix

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Mon, 12 Feb 2024 14:43:31 +0100
parents	1222b777f51f
children	6270951dda28

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"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 "os"
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	24 "strconv"
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 "strings"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26
5478 699048c86848 Updated 3rd-party libs of the gemma server to the latest bug fix release. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5364 diff changeset	27 "github.com/xuri/excelize/v2"
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 "gopkg.in/yaml.v2"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 "github.com/PaesslerAG/gval"
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	31
5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	32 "gemma.intevation.de/gemma/pkg/log"
5321 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
5601 1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	35 // Action defines what to do.
1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	36 // It can contain sub actions.
1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	37 // Depending on the type a specific action is performed.
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 type Action struct {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 Type string `yaml:"type"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	40 Actions []*Action `yaml:"actions"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 Location []string `yaml:"location"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42 Source string `yaml:"source"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 Destination string `yaml:"destination"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 Statement string `yaml:"statement"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 Vars []string `yaml:"vars"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 Name string `yaml:"name"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	47 Expr string `yaml:"expr"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	48 }
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 type frame struct {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51 res *sqlResult
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	52 index int
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	53 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	54
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	55 type sheetAxis struct {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	56 sheet string
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	57 axis string
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	58 }
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	59
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	60 type cellValue struct {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	61 value string
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	62 err error
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	63 }
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	64
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 type executor struct {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66 ctx context.Context
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	67 tx *sql.Tx
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	68 template *excelize.File
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	69 keep map[string]bool
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	70 expressions map[string]gval.Evaluable
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	71 sourceSheet string
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72 destinationSheet string
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	73 frames []frame
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	74 // Fetching formulas out of cells is very expensive so we cache them.
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	75 formulaCache map[sheetAxis]cellValue
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	78 type area struct {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	79 x1 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	80 y1 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	81 x2 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	82 y2 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	83 mc excelize.MergeCell
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	84 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	85
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	86 func mergeCellToArea(mc excelize.MergeCell) (area, error) {
5346 72469b713705 XLSX templater: Cosmetics Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5344 diff changeset	87 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	88 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	89 return area{}, err
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	90 }
5346 72469b713705 XLSX templater: Cosmetics Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5344 diff changeset	91 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	92 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	93 return area{}, err
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	94 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	95 return area{
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	96 x1: x1,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	97 y1: y1,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	98 x2: x2,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	99 y2: y2,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	100 mc: mc,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	101 }, nil
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	102 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	103
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	104 func (a *area) contains(x, y int) bool {
5346 72469b713705 XLSX templater: Cosmetics Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5344 diff changeset	105 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	106 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	107
5601 1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	108 // ActionFromFile reads an action from file.
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 func ActionFromFile(filename string) (*Action, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 f, err := os.Open(filename)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	114 defer f.Close()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	115 return ActionFromReader(f)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117
5601 1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	118 // ActionFromReader reads an action from a reader.
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	119 func ActionFromReader(r io.Reader) (*Action, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	120 action := new(Action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 err := yaml.NewDecoder(bufio.NewReader(r)).Decode(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	122 return action, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	124
5601 1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	125 // Execute executes an action in a given database transaction
1222b777f51f Made golint finally happy. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5597 diff changeset	126 // an a template as a basis.
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127 func (a *Action) Execute(
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	128 ctx context.Context,
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	129 tx *sql.Tx,
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 template *excelize.File,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131 ) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	133 //if f, err := os.Create("cpu.prof"); err == nil {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	134 // pprof.StartCPUProfile(f)
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	135 // defer pprof.StopCPUProfile()
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	136 //}
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	137
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	138 e := executor{
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	139 ctx: ctx,
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	140 tx: tx,
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	141 template: template,
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	142 keep: map[string]bool{},
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	143 expressions: map[string]gval.Evaluable{},
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	144 formulaCache: map[sheetAxis]cellValue{},
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	145 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	146
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	147 oldSheets := template.GetSheetList()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	148
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	149 if err := e.dispatch(a); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	150 return err
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	153 for _, sheet := range oldSheets {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	154 if !e.keep[sheet] {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	155 template.DeleteSheet(sheet)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	156 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	157 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	161 func (e *executor) getCellFormula(sheet, axis string) (string, error) {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	162 var (
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	163 k = sheetAxis{sheet: sheet, axis: axis}
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	164 v cellValue
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	165 ok bool
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	166 )
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	167 if v, ok = e.formulaCache[k]; !ok {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	168 v.value, v.err = e.template.GetCellFormula(sheet, axis)
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	169 e.formulaCache[k] = v
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	170 }
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	171 return v.value, v.err
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	172 }
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	173
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	174 func (e *executor) setCellFormula(sheet, axis, formula string) {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	175 e.formulaCache[sheetAxis{sheet: sheet, axis: axis}] = cellValue{value: formula}
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	176 e.template.SetCellFormula(sheet, axis, formula)
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	177 }
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	178
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	179 func (e executor) dispatch(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	180 if len(action.Vars) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	181 e.pushVars(action.Vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	182 defer e.popFrame()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	183 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	184 switch action.Type {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	185 case "sheet":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	186 return e.sheet(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	187 case "copy":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	188 return e.copy(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	189 case "select":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	190 return e.sel(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	191 case "assign":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	192 return e.assign(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	193 case "":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	194 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	195 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	196 return fmt.Errorf("unknown type '%s'", action.Type)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	197 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	198
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	199 func (e *executor) pushVars(vars []string) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	200 e.frames = append(e.frames, frame{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	201 res: &sqlResult{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	202 columns: vars,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	203 rows: [][]interface{}{make([]interface{}, len(vars))},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	204 },
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	205 })
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	206 }
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 func (e *executor) popFrame() {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	209 n := len(e.frames)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	210 e.frames[n-1].res = nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	211 e.frames = e.frames[:n-1]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	212 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	213
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	214 func (e executor) assign(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	215 if action.Name == "" {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	216 return errors.New("missing name in assign")
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 if action.Expr == "" {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	219 return errors.New("missing expr in assign")
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	220 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	221
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	222 for i := len(e.frames) - 1; i >= 0; i-- {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	223 fr := &e.frames[i]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	224 if idx := fr.res.find(action.Name); idx >= 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	225 f, err := e.expr(action.Expr)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	226 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	227 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	228 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	229 value, err := f(e.ctx, e.vars())
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	230 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	231 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	232 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	233 fr.res.rows[fr.index][idx] = value
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	234 break
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	235 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	236 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	237 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	238 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	239
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	240 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	241 if a < b {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	242 return a, b
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	243 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	244 return b, a
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	245 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	246
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	247 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	248 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	249 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	250 len(action.Location))
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	251 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	252
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	253 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	254
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	255 var err error
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	256 expand := func(s string) string {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	257 if err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	258 s, err = e.expand(s, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	259 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	260 return s
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	261 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	262 split := func(s string) (int, int) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	263 var x, y int
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	264 if err == nil {
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	265 x, y, err = excelize.CellNameToCoordinates(s)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	266 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	267 return x, y
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	268 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	269
5325 313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	270 var location []string
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	271 if len(action.Location) == 1 {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	272 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	273 } else {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	274 location = action.Location
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	275 }
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	276
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	277 var destination string
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	278 if action.Destination == "" {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	279 destination = location[0]
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	280 } else {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	281 destination = action.Destination
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	282 }
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	283
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	284 var (
5325 313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	285 s1 = expand(location[0])
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	286 s2 = expand(location[1])
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	287 d1 = expand(destination)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	288 sx1, sy1 = split(s1)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	289 sx2, sy2 = split(s2)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	290 dx1, dy1 = split(d1)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	291 )
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	292 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	293 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	294 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	295 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	296 sy1, sy2 = order(sy1, sy2)
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 var areas []area
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	299
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	300 //log.Debugln("merged cells")
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	301 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	302 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	303 for _, mc := range mcs {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	304 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	305 areas = append(areas, a)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	306 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	307 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	308 }
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	309
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	310 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	311 nextX:
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	312 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	313
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	314 // 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	315 for k := range areas {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	316 area := &areas[k]
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 if area.contains(x, y) {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	319 ofsX := x - area.x1
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	320 ofsY := y - area.y1
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	321
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	322 sx := dx1 + j - ofsX
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	323 sy := dy1 + i - ofsY
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	324 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	325 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	326
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	327 // Copy over attributes
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	328 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	329 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	330 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	331 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	332 if err1 != nil \|\| err2 != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	333 continue
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 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	336 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	337 }
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	338 if s, err := e.getCellFormula(e.sourceSheet, src); err == nil {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	339 e.setCellFormula(e.destinationSheet, dst, s)
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	340 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	341 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	342 }
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 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	345 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	346 continue nextX
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	347 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	348
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	349 // 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	350 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	351 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	352 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	353
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	354 // Finally merge the cells
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	355 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	356 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	357 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	358
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	359 continue nextX
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	360 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	361 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	362
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	363 // Regular cell
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	364
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	365 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	366 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	367 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	368 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	369 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	370 if err != nil {
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	371 continue
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	372 }
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	373
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	374 cn, err := excelize.ColumnNumberToName(x)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	375 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	376 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	377 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	378
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	379 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	380 if err != nil {
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	381 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	382 }
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	383
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	384 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	385 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	386 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	387 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	388
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	389 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	390 if err != nil {
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	391 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	392 }
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	393
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	394 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	395 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	396 }
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	397
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	398 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	399 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	400 }
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	401
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	402 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	403 e.template.SetCellStyle(e.destinationSheet, dst, dst, s)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	404 }
5364 1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	405 if s, err := e.getCellFormula(e.sourceSheet, src); err == nil {
1adbd6a5f849 XLSX templater: Cache cell formulas for performance. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5363 diff changeset	406 e.setCellFormula(e.destinationSheet, dst, s)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	407 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	408 if s, err := e.template.GetCellValue(e.sourceSheet, src); err == nil {
5362 f733bb327b9b XLSX template: Fixed copy & paste errors from the toy tool. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5361 diff changeset	409 if v, err := e.typedExpand(s, vars); err == nil {
5354 6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	410 e.template.SetCellValue(e.destinationSheet, dst, v)
5321 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 }
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	416 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	417 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	418
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	419 func (e executor) sel(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	420 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	421
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	422 eval := func(x string) (interface{}, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	423 f, err := e.expr(x)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	424 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	425 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	426 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	427 return f(e.ctx, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	428 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	429
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	430 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	431 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	432 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	433 }
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 e.frames = append(e.frames, frame{res: res})
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	436 defer e.popFrame()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	437
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	438 for i := range res.rows {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	439 e.frames[len(e.frames)-1].index = i
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	440 if err := e.actions(action); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	441 return err
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	445 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	446 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	447
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	448 func (e executor) actions(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	449 for _, a := range action.Actions {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	450 if err := e.dispatch(a); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	451 return err
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 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	454 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	455 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	456
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	457 func (e executor) sheet(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	458
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	459 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	460 source, err := e.expand(action.Source, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	461 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	462 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	463 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	464
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	465 srcIdx := e.template.GetSheetIndex(source)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	466 if srcIdx == -1 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	467 return fmt.Errorf("sheet '%s' not found", source)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	468 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	469
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	470 destination := action.Destination
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	471 if destination == "" { // same as source
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	472 e.keep[source] = true
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	473 destination = source
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	474 } else { // new sheet
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	475 destination, err = e.expand(destination, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	476 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	477 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	478 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	479 dstIdx := e.template.NewSheet(destination)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	480 if len(action.Actions) == 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	481 // Only copy if there are no explicit instructions.
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	482 if err := e.template.CopySheet(srcIdx, dstIdx); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	483 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	484 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	485 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	486 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	487
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	488 if len(action.Actions) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	489 pSrc, pDst := e.sourceSheet, e.destinationSheet
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	490 defer func() {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	491 e.sourceSheet, e.destinationSheet = pSrc, pDst
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	492 }()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	493 e.sourceSheet, e.destinationSheet = source, destination
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	494 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	495 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	496
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	497 // Simple filling
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	498
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	499 // "{{" only as a quick filter
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	500 result, err := e.template.SearchSheet(destination, "{{", true)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	501 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	502 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	503 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	504 for _, axis := range result {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	505 value, err := e.template.GetCellValue(destination, axis)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	506 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	507 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	508 }
5362 f733bb327b9b XLSX template: Fixed copy & paste errors from the toy tool. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5361 diff changeset	509 nvalue, err := e.typedExpand(value, vars)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	510 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	511 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	512 }
5362 f733bb327b9b XLSX template: Fixed copy & paste errors from the toy tool. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5361 diff changeset	513 if err := e.template.SetCellValue(destination, axis, nvalue); err != nil {
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	514 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	515 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	516 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	517
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	518 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	519 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	520
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	521 func columnToNum(col interface{}) interface{} {
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	522 var name string
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	523 switch v := col.(type) {
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	524 case string:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	525 name = v
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	526 default:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	527 name = fmt.Sprintf("%v", col)
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	528 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	529 num, err := excelize.ColumnNameToNumber(name)
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	530 if err != nil {
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	531 log.Errorf("invalid column name '%v'\n", col)
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	532 return 1
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	533 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	534 return num
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
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	537 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	538 switch v := i.(type) {
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	539 case int:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	540 return v, nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	541 case int8:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	542 return int(v), nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	543 case int16:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	544 return int(v), nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	545 case int32:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	546 return int(v), nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	547 case int64:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	548 return int(v), nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	549 case float32:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	550 return int(v), nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	551 case float64:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	552 return int(v), nil
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	553 case string:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	554 return strconv.Atoi(v)
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	555 default:
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	556 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	557 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	558 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	559
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	560 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	561 x, err := asInt(ix)
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	562 if err != nil {
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	563 log.Errorf("invalid x value: %v\n", err)
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	564 return "A1"
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	565 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	566 y, err := asInt(iy)
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	567 if err != nil {
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	568 log.Errorf("invalid y value: %v\n", err)
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	569 return "A1"
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	570 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	571
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	572 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	573 if err != nil {
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	574 log.Errorf("invalid cell coord (%d, %d)\n", x, y)
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	575 return "A1"
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	576 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	577 return cell
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	578 }
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	579
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	580 var templateLang = gval.Full(
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	581 gval.Function("column2num", columnToNum),
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	582 gval.Function("coord2cell", coord2cell),
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	583 )
a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	584
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	585 func (e *executor) expr(x string) (gval.Evaluable, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	586 if f := e.expressions[x]; f != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	587 return f, nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	588 }
5349 a352a695b69c XLSX templater: Added column to coord conversions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5346 diff changeset	589 f, err := templateLang.NewEvaluable(x)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	590 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	591 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	592 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	593 e.expressions[x] = f
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	594 return f, nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	595 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	596
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	597 func (e *executor) vars() map[string]interface{} {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	598 vars := map[string]interface{}{}
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	599 if len(e.frames) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	600 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	601 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	602 for i := len(e.frames) - 1; i >= 0; i-- {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	603 fr := &e.frames[i]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	604 for j, n := range fr.res.columns {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	605 if _, found := vars[n]; !found {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	606 vars[n] = fr.res.rows[fr.index][j]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	607 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	608 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	609 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	610 return vars
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	611 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	612
5363 04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	613 func (e *executor) expand(
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	614 str string,
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	615 vars map[string]interface{},
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	616 ) (string, error) {
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	617
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	618 var err error
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	619
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	620 replace := func(s string) string {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	621 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	622 return ""
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	623 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	624 var eval gval.Evaluable
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	625 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	626 return ""
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	627 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	628 s, err = eval.EvalString(e.ctx, vars)
5362 f733bb327b9b XLSX template: Fixed copy & paste errors from the toy tool. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5361 diff changeset	629 if err != nil {
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	630 log.Errorf("'%s' '%s' %v\n", str, s, err)
5362 f733bb327b9b XLSX template: Fixed copy & paste errors from the toy tool. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5361 diff changeset	631 }
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	632 return s
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	633 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	634
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	635 str = handlebars(str, replace)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	636 return str, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	637 }
5354 6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	638
5363 04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	639 func (e *executor) typedExpand(
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	640 str string,
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	641 vars map[string]interface{},
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	642 ) (interface{}, error) {
5354 6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	643
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	644 var (
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	645 err error
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	646 repCount int
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	647 last interface{}
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	648 )
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	649
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	650 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	651 if err != nil {
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	652 return ""
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	653 }
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	654 var eval gval.Evaluable
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	655 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	656 return ""
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	657 }
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	658 repCount++
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	659 last, err = eval(e.ctx, vars)
5363 04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	660 if err != nil {
5490 5f47eeea988d Use own logging package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5478 diff changeset	661 log.Errorf("'%s' '%s' %v\n", str, s, err)
5363 04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	662 }
5354 6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	663 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	664 }
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	665
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	666 nstr := handlebars(str, replace)
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	667
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	668 if err != nil {
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	669 return nil, err
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	670 }
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	671
5363 04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	672 if repCount == 1 &&
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	673 strings.HasPrefix(str, "{{") &&
04b3fb35910c XLSX templater: More logging in case of expression eval errors. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5362 diff changeset	674 strings.HasSuffix(str, "}}") {
5354 6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	675 return last, nil
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	676 }
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	677 return nstr, nil
6a94ab82eaaa XLSX templater: Added type support for cell expansion. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5349 diff changeset	678 }

Mercurial > gemma

annotate pkg/xlsx/templater.go @ 5694:3bc15e38c7e8 sr-v2