gemma: pkg/xlsx/templater.go annotate

annotate pkg/xlsx/templater.go @ 5344:7df6062a1371 extented-report

XLSX: Implemented correct handling of merged cells.

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Fri, 18 Jun 2021 21:27:41 +0200
parents	bb6761abd81d
children	72469b713705

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"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24 "strings"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 "github.com/360EntSecGroup-Skylar/excelize/v2"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	27 "gopkg.in/yaml.v2"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29 "github.com/PaesslerAG/gval"
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 )
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	31
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32 type Action struct {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	33 Type string `yaml:"type"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	34 Actions []*Action `yaml:"actions"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	35 Location []string `yaml:"location"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	36 Source string `yaml:"source"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	37 Destination string `yaml:"destination"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 Statement string `yaml:"statement"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 Vars []string `yaml:"vars"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	40 Name string `yaml:"name"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 Expr string `yaml:"expr"`
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 type frame struct {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 res *sqlResult
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 index int
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	47 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	48
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	49 type executor struct {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	50 ctx context.Context
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	51 tx *sql.Tx
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	52 template *excelize.File
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	53 keep map[string]bool
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	54 expressions map[string]gval.Evaluable
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	55 sourceSheet string
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	56 destinationSheet string
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57 frames []frame
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	58 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	59
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	60 type area struct {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	61 x1 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	62 y1 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	63 x2 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	64 y2 int
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	65 mc excelize.MergeCell
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	66 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	67
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	68 func mergeCellToArea(mc excelize.MergeCell) (area, error) {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	69 sa := mc.GetStartAxis()
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	70 x1, y1, err := excelize.CellNameToCoordinates(sa)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	71 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	72 return area{}, err
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	73 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	74 ea := mc.GetEndAxis()
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	75 x2, y2, err := excelize.CellNameToCoordinates(ea)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	76 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	77 return area{}, err
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	78 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	79 return area{
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	80 x1: x1,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	81 y1: y1,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	82 x2: x2,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	83 y2: y2,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	84 mc: mc,
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	85 }, nil
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	86 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	87
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	88 func (a *area) contains(x, y int) bool {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	89 return x >= a.x1 && x <= a.x2 && y >= a.y1 && y <= a.y2
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	90 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	91
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 func ActionFromFile(filename string) (*Action, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93 f, err := os.Open(filename)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97 defer f.Close()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 return ActionFromReader(f)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 func ActionFromReader(r io.Reader) (*Action, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 action := new(Action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 err := yaml.NewDecoder(bufio.NewReader(r)).Decode(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 return action, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107 func (a *Action) Execute(
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 ctx context.Context,
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	109 tx *sql.Tx,
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 template *excelize.File,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111 ) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113 e := executor{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	114 ctx: ctx,
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	115 tx: tx,
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 template: template,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117 keep: map[string]bool{},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118 expressions: map[string]gval.Evaluable{},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	119 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	120
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 oldSheets := template.GetSheetList()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	122
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 if err := e.dispatch(a); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	124 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	125 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127 for _, sheet := range oldSheets {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	128 if !e.keep[sheet] {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	129 template.DeleteSheet(sheet)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	134
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	135 func (e executor) dispatch(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	136 if len(action.Vars) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	137 e.pushVars(action.Vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	138 defer e.popFrame()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	139 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	140 switch action.Type {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	141 case "sheet":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	142 return e.sheet(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	143 case "copy":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	144 return e.copy(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	145 case "select":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	146 return e.sel(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	147 case "assign":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	148 return e.assign(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	149 case "":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	150 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	151 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	152 return fmt.Errorf("unknown type '%s'", action.Type)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	153 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	154
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	155 func (e *executor) pushVars(vars []string) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	156 e.frames = append(e.frames, frame{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	157 res: &sqlResult{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158 columns: vars,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 rows: [][]interface{}{make([]interface{}, len(vars))},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160 },
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	161 })
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	162 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	163
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	164 func (e *executor) popFrame() {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	165 n := len(e.frames)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	166 e.frames[n-1].res = nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	167 e.frames = e.frames[:n-1]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	168 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	169
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	170 func (e executor) assign(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	171 if action.Name == "" {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	172 return errors.New("missing name in assign")
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	173 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	174 if action.Expr == "" {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	175 return errors.New("missing expr in assign")
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	176 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	177
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	178 for i := len(e.frames) - 1; i >= 0; i-- {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	179 fr := &e.frames[i]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	180 if idx := fr.res.find(action.Name); idx >= 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	181 f, err := e.expr(action.Expr)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	182 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	183 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	184 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	185 value, err := f(e.ctx, e.vars())
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	186 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	187 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	188 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	189 fr.res.rows[fr.index][idx] = value
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	190 break
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	191 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	192 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	193 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	194 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	195
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	196 func order(a, b int) (int, int) {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	197 if a < b {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	198 return a, b
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	199 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	200 return b, a
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	201 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	202
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	203 func (e executor) copy(action Action) error {
5325 313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	204 if n := len(action.Location); !(n == 1 \|\| n == 2) {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	205 return fmt.Errorf("length location = %d (expect 1 or 2)",
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	206 len(action.Location))
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	207 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	208
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	209 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	210
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	211 var err error
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	212 expand := func(s string) string {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	213 if err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	214 s, err = e.expand(s, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	215 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	216 return s
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	217 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	218 split := func(s string) (int, int) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	219 var x, y int
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	220 if err == nil {
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	221 x, y, err = excelize.CellNameToCoordinates(s)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	222 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	223 return x, y
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	224 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	225
5325 313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	226 var location []string
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	227 if len(action.Location) == 1 {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	228 location = []string{action.Location[0], action.Location[0]}
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	229 } else {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	230 location = action.Location
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	231 }
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	232
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	233 var destination string
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	234 if action.Destination == "" {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	235 destination = location[0]
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	236 } else {
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	237 destination = action.Destination
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	238 }
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	239
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	240 var (
5325 313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	241 s1 = expand(location[0])
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	242 s2 = expand(location[1])
313bf3f3a8b1 XLSX templater: Simplify copy action. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5321 diff changeset	243 d1 = expand(destination)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	244 sx1, sy1 = split(s1)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	245 sx2, sy2 = split(s2)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	246 dx1, dy1 = split(d1)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	247 )
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	248 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	249 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	250 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	251 sx1, sx2 = order(sx1, sx2)
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	252 sy1, sy2 = order(sy1, sy2)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	253
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	254 var areas []area
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	255
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	256 //log.Println("merged cells")
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	257 if mcs, err := e.template.GetMergeCells(e.sourceSheet); err == nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	258 areas = make([]area, 0, len(mcs))
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	259 for _, mc := range mcs {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	260 if a, err := mergeCellToArea(mc); err == nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	261 areas = append(areas, a)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	262 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	263 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	264 }
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	265
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	266 for y, i := sy1, 0; y <= sy2; y, i = y+1, i+1 {
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	267 nextX:
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	268 for x, j := sx1, 0; x <= sx2; x, j = x+1, j+1 {
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	269
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	270 // check if cell is part of a merged cell
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	271 for k := range areas {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	272 area := &areas[k]
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	273
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	274 if area.contains(x, y) {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	275 ofsX := x - area.x1
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	276 ofsY := y - area.y1
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	277
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	278 sx := dx1 + j - ofsX
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	279 sy := dy1 + i - ofsY
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	280 ex := sx + (area.x2 - area.x1)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	281 ey := sy + (area.y2 - area.y1)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	282
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	283 // Copy over attributes
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	284 for l := 0; l <= area.x2-area.x1; l++ {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	285 for m := 0; m <= area.y2-area.y1; m++ {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	286 src, err1 := excelize.CoordinatesToCellName(area.x1+l, area.y1+m)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	287 dst, err2 := excelize.CoordinatesToCellName(sx+l, sy+m)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	288 if err1 != nil \|\| err2 != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	289 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	290 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	291 if s, err := e.template.GetCellStyle(e.sourceSheet, src); err == nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	292 e.template.SetCellStyle(e.destinationSheet, dst, dst, s)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	293 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	294 if s, err := e.template.GetCellFormula(e.sourceSheet, src); err == nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	295 e.template.SetCellFormula(e.destinationSheet, dst, s)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	296 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	297 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	298 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	299
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	300 dst, err := excelize.CoordinatesToCellName(sx, sy)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	301 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	302 continue nextX
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	303 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	304
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	305 // Copy over expanded text
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	306 if s, err := e.expand(area.mc.GetCellValue(), vars); err == nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	307 e.template.SetCellStr(e.destinationSheet, dst, s)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	308 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	309
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	310 // Finally merge the cells
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	311 if end, err := excelize.CoordinatesToCellName(ex, ey); err == nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	312 e.template.MergeCell(e.destinationSheet, dst, end)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	313 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	314
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	315 continue nextX
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	316 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	317 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	318
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	319 // Regular cell
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	320
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	321 src, err := excelize.CoordinatesToCellName(x, y)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	322 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	323 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	324 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	325 dst, err := excelize.CoordinatesToCellName(dx1+j, dy1+i)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	326 if err != nil {
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	327 continue
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	328 }
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	329
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	330 cn, err := excelize.ColumnNumberToName(x)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	331 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	332 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	333 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	334
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	335 cw, err := e.template.GetColWidth(e.sourceSheet, cn)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	336 if err != nil {
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	337 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	338 }
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	339
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	340 rh, err := e.template.GetRowHeight(e.sourceSheet, y)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	341 if err != nil {
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	342 continue
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	343 }
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	344
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	345 dc, err := excelize.ColumnNumberToName(dx1 + j)
7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	346 if err != nil {
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	347 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	348 }
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	349
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	350 if e.template.SetColWidth(e.destinationSheet, dc, dc, cw) != nil {
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	351 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	352 }
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	353
5344 7df6062a1371 XLSX: Implemented correct handling of merged cells. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5343 diff changeset	354 if e.template.SetRowHeight(e.destinationSheet, dy1+i, rh) != nil {
5343 bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	355 continue
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	356 }
bb6761abd81d XLSX template: Copy column and row height explicitly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5333 diff changeset	357
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	358 if s, err := e.template.GetCellStyle(e.sourceSheet, src); err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	359 e.template.SetCellStyle(e.destinationSheet, dst, dst, s)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	360 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	361 if s, err := e.template.GetCellFormula(e.sourceSheet, src); err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	362 e.template.SetCellFormula(e.destinationSheet, dst, s)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	363 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	364 if s, err := e.template.GetCellValue(e.sourceSheet, src); err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	365 if s, err = e.expand(s, vars); err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	366 e.template.SetCellStr(e.destinationSheet, dst, s)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	367 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	368 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	369 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	370 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	371
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	372 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	373 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	374
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	375 func (e executor) sel(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	376 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	377
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	378 eval := func(x string) (interface{}, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	379 f, err := e.expr(x)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	380 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	381 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	382 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	383 return f(e.ctx, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	384 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	385
5333 6c0f40676984 Run xlsx templating in a read-only transaction. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 5325 diff changeset	386 res, err := query(e.ctx, e.tx, action.Statement, eval)
5321 0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	387 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	388 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	389 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	390
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	391 e.frames = append(e.frames, frame{res: res})
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	392 defer e.popFrame()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	393
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	394 for i := range res.rows {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	395 e.frames[len(e.frames)-1].index = i
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	396 if err := e.actions(action); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	397 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	398 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	399 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	400
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	401 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	402 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	403
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	404 func (e executor) actions(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	405 for _, a := range action.Actions {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	406 if err := e.dispatch(a); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	407 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	408 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	409 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	410 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	411 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	412
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	413 func (e executor) sheet(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	414
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	415 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	416 source, err := e.expand(action.Source, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	417 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	418 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	419 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	420
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	421 srcIdx := e.template.GetSheetIndex(source)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	422 if srcIdx == -1 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	423 return fmt.Errorf("sheet '%s' not found", source)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	424 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	425
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	426 destination := action.Destination
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	427 if destination == "" { // same as source
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	428 e.keep[source] = true
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	429 destination = source
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	430 } else { // new sheet
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	431 destination, err = e.expand(destination, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	432 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	433 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	434 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	435 dstIdx := e.template.NewSheet(destination)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	436 if len(action.Actions) == 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	437 // Only copy if there are no explicit instructions.
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	438 if err := e.template.CopySheet(srcIdx, dstIdx); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	439 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	440 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	441 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	442 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	443
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	444 if len(action.Actions) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	445 pSrc, pDst := e.sourceSheet, e.destinationSheet
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	446 defer func() {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	447 e.sourceSheet, e.destinationSheet = pSrc, pDst
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	448 }()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	449 e.sourceSheet, e.destinationSheet = source, destination
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	450 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	451 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	452
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	453 // Simple filling
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	454
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	455 // "{{" only as a quick filter
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	456 result, err := e.template.SearchSheet(destination, "{{", true)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	457 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	458 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	459 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	460 for _, axis := range result {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	461 value, err := e.template.GetCellValue(destination, axis)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	462 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	463 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	464 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	465 value, err = e.expand(value, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	466 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	467 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	468 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	469 if err := e.template.SetCellStr(destination, axis, value); 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 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	473
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	474 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	475 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	476
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	477 func (e *executor) expr(x string) (gval.Evaluable, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	478 if f := e.expressions[x]; f != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	479 return f, nil
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 f, err := gval.Full().NewEvaluable(x)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	482 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	483 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	484 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	485 e.expressions[x] = f
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	486 return f, nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	487 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	488
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	489 func (e *executor) vars() map[string]interface{} {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	490 vars := map[string]interface{}{}
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	491 if len(e.frames) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	492 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	493 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	494 for i := len(e.frames) - 1; i >= 0; i-- {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	495 fr := &e.frames[i]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	496 for j, n := range fr.res.columns {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	497 if _, found := vars[n]; !found {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	498 vars[n] = fr.res.rows[fr.index][j]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	499 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	500 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	501 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	502 return vars
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	503 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	504
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	505 func (e *executor) expand(str string, vars map[string]interface{}) (string, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	506
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	507 var err error
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 replace := func(s string) string {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	510 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	511 return ""
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 var eval gval.Evaluable
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	514 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	515 return ""
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	516 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	517 s, err = eval.EvalString(e.ctx, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	518 return s
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	519 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	520
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	521 str = handlebars(str, replace)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	522 return str, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	523 }

Mercurial > gemma

annotate pkg/xlsx/templater.go @ 5344:7df6062a1371 extented-report