gemma: pkg/xlsx/templater.go annotate

annotate pkg/xlsx/templater.go @ 5321:0919946f624b extented-report

Added a report controller.

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Thu, 27 May 2021 01:22:10 +0200
parents
children	313bf3f3a8b1

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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51 db *sql.Conn
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	60 func ActionFromFile(filename string) (*Action, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61 f, err := os.Open(filename)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 defer f.Close()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66 return ActionFromReader(f)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	67 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	68
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	69 func ActionFromReader(r io.Reader) (*Action, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	70 action := new(Action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	71 err := yaml.NewDecoder(bufio.NewReader(r)).Decode(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72 return action, err
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 func (a *Action) Execute(
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 ctx context.Context,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77 db *sql.Conn,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78 template *excelize.File,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 ) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 e := executor{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 ctx: ctx,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 db: db,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 template: template,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	85 keep: map[string]bool{},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	86 expressions: map[string]gval.Evaluable{},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	88
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	89 oldSheets := template.GetSheetList()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	90
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	91 if err := e.dispatch(a); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 for _, sheet := range oldSheets {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 if !e.keep[sheet] {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97 template.DeleteSheet(sheet)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 }
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 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 func (e executor) dispatch(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 if len(action.Vars) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 e.pushVars(action.Vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106 defer e.popFrame()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 switch action.Type {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 case "sheet":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 return e.sheet(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111 case "copy":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112 return e.copy(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113 case "select":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	114 return e.sel(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	115 case "assign":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 return e.assign(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117 case "":
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118 return e.actions(action)
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 return fmt.Errorf("unknown type '%s'", action.Type)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 }
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 func (e *executor) pushVars(vars []string) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	124 e.frames = append(e.frames, frame{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	125 res: &sqlResult{
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126 columns: vars,
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127 rows: [][]interface{}{make([]interface{}, len(vars))},
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	128 },
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	129 })
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 func (e *executor) popFrame() {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133 n := len(e.frames)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	134 e.frames[n-1].res = nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	135 e.frames = e.frames[:n-1]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	136 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	137
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	138 func (e executor) assign(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	139 if action.Name == "" {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	140 return errors.New("missing name in assign")
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 action.Expr == "" {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	143 return errors.New("missing expr in assign")
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 i := len(e.frames) - 1; i >= 0; i-- {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	147 fr := &e.frames[i]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	148 if idx := fr.res.find(action.Name); idx >= 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	149 f, err := e.expr(action.Expr)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	150 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	151 return err
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 value, err := f(e.ctx, e.vars())
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	154 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	155 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	156 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	157 fr.res.rows[fr.index][idx] = value
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158 break
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	161 return e.actions(action)
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) copy(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	165 if len(action.Location) != 2 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	166 return fmt.Errorf("length location = %d (expect 2)",
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	167 len(action.Source))
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 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	171
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	172 var err error
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	173 expand := func(s string) string {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	174 if err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	175 s, err = e.expand(s, vars)
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 return s
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	178 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	179 split := func(s string) (int, int) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	180 var x, y int
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	181 if err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	182 var cell string
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	183 if cell, y, err = excelize.SplitCellName(s); err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	184 x, err = excelize.ColumnNameToNumber(cell)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	185 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	186 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	187 return x, y
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 order := func(a, b int) (int, int) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	190 if a > b {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	191 return b, a
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 a, b
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	196 var (
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	197 s1 = expand(action.Location[0])
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	198 s2 = expand(action.Location[1])
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	199 d1 = expand(action.Destination)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	200 sx1, sy1 = split(s1)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	201 sx2, sy2 = split(s2)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	202 dx1, dy1 = split(d1)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	203 )
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	204 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	205 return err
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 sx1, sx2 = order(sx1, sx2)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	208 sy1, sy1 = order(sy1, sy2)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	209
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	210 //log.Printf("%s/%s -> %s\n", sFrom, sTo, dTo)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	211
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	212 for y, i := sy1, 0; y <= sy2; y, i = y+1, i+1 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	213 for x, j := sx1, 0; x <= sx2; x, j = x+1, j+1 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	214 src, err1 := excelize.CoordinatesToCellName(x, y)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	215 dst, err2 := excelize.CoordinatesToCellName(dx1+j, dy1+i)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	216 if err1 != nil \|\| err2 != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	217 continue
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	218 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	219 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	220 e.template.SetCellStyle(e.destinationSheet, dst, dst, s)
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 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	223 e.template.SetCellFormula(e.destinationSheet, dst, s)
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 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	226 if s, err = e.expand(s, vars); err == nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	227 e.template.SetCellStr(e.destinationSheet, dst, s)
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 }
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	233 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	234 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	235
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	236 func (e executor) sel(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	237 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	238
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	239 eval := func(x string) (interface{}, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	240 f, err := e.expr(x)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	241 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	242 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	243 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	244 return f(e.ctx, vars)
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	247 res, err := query(e.ctx, e.db, action.Statement, eval)
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
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	252 e.frames = append(e.frames, frame{res: res})
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	253 defer e.popFrame()
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 for i := range res.rows {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	256 e.frames[len(e.frames)-1].index = i
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	257 if err := e.actions(action); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	258 return err
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 }
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 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	263 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	264
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	265 func (e executor) actions(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	266 for _, a := range action.Actions {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	267 if err := e.dispatch(a); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	268 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	269 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	270 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	271 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	272 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	273
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	274 func (e executor) sheet(action Action) error {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	275
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	276 vars := e.vars()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	277 source, err := e.expand(action.Source, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	278 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	279 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	280 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	281
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	282 srcIdx := e.template.GetSheetIndex(source)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	283 if srcIdx == -1 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	284 return fmt.Errorf("sheet '%s' not found", source)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	285 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	286
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	287 destination := action.Destination
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	288 if destination == "" { // same as source
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	289 e.keep[source] = true
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	290 destination = source
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	291 } else { // new sheet
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	292 destination, err = e.expand(destination, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	293 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	294 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	295 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	296 dstIdx := e.template.NewSheet(destination)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	297 if len(action.Actions) == 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	298 // Only copy if there are no explicit instructions.
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	299 if err := e.template.CopySheet(srcIdx, dstIdx); err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	300 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	301 }
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 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	304
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	305 if len(action.Actions) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	306 pSrc, pDst := e.sourceSheet, e.destinationSheet
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	307 defer func() {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	308 e.sourceSheet, e.destinationSheet = pSrc, pDst
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	309 }()
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	310 e.sourceSheet, e.destinationSheet = source, destination
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	311 return e.actions(action)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	312 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	313
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	314 // Simple filling
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	315
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	316 // "{{" only as a quick filter
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	317 result, err := e.template.SearchSheet(destination, "{{", true)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	318 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	319 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	320 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	321 for _, axis := range result {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	322 value, err := e.template.GetCellValue(destination, axis)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	323 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	324 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	325 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	326 value, err = e.expand(value, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	327 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	328 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	329 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	330 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	331 return err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	332 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	333 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	334
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	335 return nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	336 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	337
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	338 func (e *executor) expr(x string) (gval.Evaluable, error) {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	339 if f := e.expressions[x]; f != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	340 return f, nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	341 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	342 f, err := gval.Full().NewEvaluable(x)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	343 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	344 return nil, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	345 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	346 e.expressions[x] = f
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	347 return f, nil
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	348 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	349
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	350 func (e *executor) vars() map[string]interface{} {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	351 vars := map[string]interface{}{}
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	352 if len(e.frames) > 0 {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	353 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	354 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	355 for i := len(e.frames) - 1; i >= 0; i-- {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	356 fr := &e.frames[i]
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	357 for j, n := range fr.res.columns {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	358 if _, found := vars[n]; !found {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	359 vars[n] = fr.res.rows[fr.index][j]
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 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	362 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	363 return vars
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	364 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	365
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	366 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	367
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	368 var err error
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 replace := func(s string) string {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	371 if err != nil {
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	372 return ""
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 var eval gval.Evaluable
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	375 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	376 return ""
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 s, err = eval.EvalString(e.ctx, vars)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	379 return s
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	380 }
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	381
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	382 str = handlebars(str, replace)
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	383 return str, err
0919946f624b Added a report controller. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	384 }

Mercurial > gemma

annotate pkg/xlsx/templater.go @ 5321:0919946f624b extented-report