gemma: pkg/xlsx/templater.go annotate

annotate pkg/xlsx/templater.go @ 5597:163f38c69a07

Removed unused variable found by staticcheck.

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Fri, 05 Aug 2022 12:25:24 +0200
parents	5f47eeea988d
children	1222b777f51f

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

Mercurial > gemma

annotate pkg/xlsx/templater.go @ 5597:163f38c69a07