Skip to content

An open-source, privacy-first, self-hosted knowledge workspace where humans and AI agents work together 开源、隐私优先、自托管的知识工作空间,让人与智能体在此协作

49.9 KB
Raw Blame
// SiYuan - https://github.com/siyuan-note/siyuan
// Copyright (c) 2020-present, b3log.org
// SPDX-License-Identifier: AGPL-3.0-or-later

package sql

import (
	"bytes"
	"fmt"
	"maps"
	"slices"
	"sort"
	"strings"
	"text/template"
	"text/template/parse"
	"time"

	"github.com/88250/lute/ast"
	"github.com/jinzhu/copier"
	"github.com/siyuan-note/logging"
	"github.com/siyuan-note/siyuan/kernel/av"
	"github.com/siyuan-note/siyuan/kernel/filesys"
	"github.com/siyuan-note/siyuan/kernel/treenode"
	"github.com/siyuan-note/siyuan/kernel/util"
)

// GroupViewRenderSource 保存分组渲染可复用的条目索引。
// 索引中的条目已经完成字段值生成和查询过滤,各分组仍会独立执行视图过滤、排序、统计和分页。
type GroupViewRenderSource struct {
	query      string
	layoutType av.LayoutType
	items      map[string]av.Item
	ordered    []av.Item
}

// AttributeViewRenderContext 收集一次属性视图渲染期间产生的模板错误。
type AttributeViewRenderContext struct {
	templateErrors             map[string]*attributeViewTemplateRenderError
	renderingRelationTemplates bool
	renderingRollupTargets     map[rollupTargetID]bool
	templateStoredValues       map[av.Collection]map[*av.Value]*av.Value // 分页前后共享原始值副本,保持 _raw 访问语义。
	ReadOnly                   bool                                      // 预览只允许修正内存副本,不保存缺失字段等订正结果。
}

type attributeViewTemplateRenderError struct {
	attributeViewID   string
	attributeViewName string
	templateFieldID   string
	templateFieldName string
	itemID            string
	itemName          string
	renderErr         string
	itemIDs           map[string]struct{}
}

// NewAttributeViewRenderContext 创建属性视图渲染上下文。
func NewAttributeViewRenderContext() *AttributeViewRenderContext {
	return &AttributeViewRenderContext{templateErrors: map[string]*attributeViewTemplateRenderError{}}
}

// HasTemplateErrors 判断本次求值是否产生模板错误,错误结果不参与跨请求复用。
func (context *AttributeViewRenderContext) HasTemplateErrors() bool {
	return context != nil && len(context.templateErrors) != 0
}

func (context *AttributeViewRenderContext) addTemplateError(attrView *av.AttributeView, templateKey *av.Key,
	item av.Item, renderErr error) {
	if nil == context || nil == attrView || nil == templateKey || nil == item || nil == renderErr {
		return
	}
	if nil == context.templateErrors {
		context.templateErrors = map[string]*attributeViewTemplateRenderError{}
	}

	itemID := item.GetID()
	itemName := ""
	if blockValue := item.GetBlockValue(); nil != blockValue && nil != blockValue.Block {
		itemName = blockValue.Block.Content
	}
	errorText := renderErr.Error()
	errorKey := attrView.ID + "\x00" + templateKey.ID + "\x00" + errorText
	templateErr := context.templateErrors[errorKey]
	if nil == templateErr {
		templateErr = &attributeViewTemplateRenderError{
			attributeViewID:   attrView.ID,
			attributeViewName: getAttrViewName(attrView),
			templateFieldID:   templateKey.ID,
			templateFieldName: templateKey.Name,
			itemID:            itemID,
			itemName:          itemName,
			renderErr:         errorText,
			itemIDs:           map[string]struct{}{},
		}
		context.templateErrors[errorKey] = templateErr
	}
	if _, ok := templateErr.itemIDs[itemID]; ok {
		return
	}
	templateErr.itemIDs[itemID] = struct{}{}
	if "" == templateErr.itemID || itemID < templateErr.itemID {
		templateErr.itemID = itemID
		templateErr.itemName = itemName
	}
}

func (context *AttributeViewRenderContext) sortedTemplateErrors() (ret []*attributeViewTemplateRenderError) {
	if nil == context {
		return
	}
	keys := make([]string, 0, len(context.templateErrors))
	for key := range context.templateErrors {
		keys = append(keys, key)
	}
	sort.Strings(keys)
	for _, key := range keys {
		ret = append(ret, context.templateErrors[key])
	}
	return
}

func (context *AttributeViewRenderContext) PushTemplateErrors() {
	for _, templateErr := range context.sortedTemplateErrors() {
		detail := fmt.Sprintf(util.Langs[util.Lang][374], templateErr.attributeViewName, templateErr.templateFieldName,
			templateErr.itemName, templateErr.itemID, len(templateErr.itemIDs), templateErr.renderErr)
		util.PushErrMsg(fmt.Sprintf(util.Langs[util.Lang][44], util.EscapeHTML(detail)), 30000)
	}
}

// NewGroupViewRenderSource 在父视图分页前建立可供所有同布局分组复用的条目索引。
func NewGroupViewRenderSource(viewable av.Viewable, query string) (ret *GroupViewRenderSource) {
	collection, ok := viewable.(av.Collection)
	if !ok {
		return
	}

	ret = &GroupViewRenderSource{
		query:      query,
		layoutType: viewable.GetType(),
		items:      make(map[string]av.Item, collection.CountItems()),
		ordered:    make([]av.Item, 0, collection.CountItems()),
	}
	for _, item := range collection.GetItems() {
		if nil != item {
			ret.items[item.GetID()] = item
			ret.ordered = append(ret.ordered, item)
		}
	}
	return
}

// GetItems 返回父视图分页前的完整有序条目列表。
func (source *GroupViewRenderSource) GetItems() (ret []av.Item) {
	if nil == source {
		return
	}
	return append(ret, source.ordered...)
}

func RenderGroupView(attrView *av.AttributeView, view, groupView *av.View, query string) (ret av.Viewable) {
	return RenderGroupViewWithSource(attrView, view, groupView, query, nil, false)
}

// RenderGroupViewWithSource 优先从父视图条目索引组装分组;布局或查询不匹配时沿用独立渲染。
func RenderGroupViewWithSource(attrView *av.AttributeView, view, groupView *av.View, query string,
	source *GroupViewRenderSource, ignoreRows bool) (ret av.Viewable) {
	context := NewAttributeViewRenderContext()
	ret = RenderGroupViewWithSourceContext(attrView, view, groupView, query, source, ignoreRows, context)
	context.PushTemplateErrors()
	return
}

// RenderGroupViewWithSourceContext 使用指定的渲染上下文渲染分组视图。
func RenderGroupViewWithSourceContext(attrView *av.AttributeView, view, groupView *av.View, query string,
	source *GroupViewRenderSource, ignoreRows bool, context *AttributeViewRenderContext) (ret av.Viewable) {
	var err error
	switch groupView.LayoutType {
	case av.LayoutTypeTable, av.LayoutTypeList, av.LayoutTypeCalendar:
		// 这里需要使用深拷贝,因为字段上可能会带有计算(FieldCalc),每个分组视图的计算结果都需要分别存储在不同的字段实例上
		err = copier.CopyWithOption(&groupView.GetTableLayout().Columns, &view.GetTableLayout().Columns, copier.Option{DeepCopy: true})
		groupView.GetTableLayout().ShowIcon = view.GetTableLayout().ShowIcon
		groupView.GetTableLayout().WrapField = view.GetTableLayout().WrapField
	case av.LayoutTypeGallery:
		err = copier.CopyWithOption(&groupView.Gallery.CardFields, &view.Gallery.CardFields, copier.Option{DeepCopy: true})
		groupView.Gallery.ShowIcon = view.Gallery.ShowIcon
		groupView.Gallery.WrapField = view.Gallery.WrapField

		groupView.Gallery.CoverFrom = view.Gallery.CoverFrom
		groupView.Gallery.CoverFromAssetKeyID = view.Gallery.CoverFromAssetKeyID
		groupView.Gallery.CardAspectRatio = view.Gallery.CardAspectRatio
		groupView.Gallery.CardAspectRatioValue = view.Gallery.CardAspectRatioValue
		groupView.Gallery.CardSize = view.Gallery.CardSize
		groupView.Gallery.CardWidth = view.Gallery.CardWidth
		groupView.Gallery.CardLayout = view.Gallery.CardLayout
		groupView.Gallery.FitImage = view.Gallery.FitImage
		groupView.Gallery.DisplayFieldName = view.Gallery.DisplayFieldName
		groupView.Gallery.DisplayEmptyFields = view.Gallery.DisplayEmptyFields
	case av.LayoutTypeKanban:
		err = copier.CopyWithOption(&groupView.Kanban.Fields, &view.Kanban.Fields, copier.Option{DeepCopy: true})
		groupView.Kanban.ShowIcon = view.Kanban.ShowIcon
		groupView.Kanban.WrapField = view.Kanban.WrapField

		groupView.Kanban.CoverFrom = view.Kanban.CoverFrom
		groupView.Kanban.CoverFromAssetKeyID = view.Kanban.CoverFromAssetKeyID
		groupView.Kanban.CardAspectRatio = view.Kanban.CardAspectRatio
		groupView.Kanban.CardAspectRatioValue = view.Kanban.CardAspectRatioValue
		groupView.Kanban.CardSize = view.Kanban.CardSize
		groupView.Kanban.CardWidth = view.Kanban.CardWidth
		groupView.Kanban.CardLayout = view.Kanban.CardLayout
		groupView.Kanban.FitImage = view.Kanban.FitImage
		groupView.Kanban.DisplayFieldName = view.Kanban.DisplayFieldName
		groupView.Kanban.DisplayEmptyFields = view.Kanban.DisplayEmptyFields
		groupView.Kanban.FillColBackgroundColor = view.Kanban.FillColBackgroundColor
	}
	if nil != err {
		logging.LogErrorf("copy view fields [%s] to group [%s] failed: %s", view.ID, groupView.ID, err)
		switch groupView.LayoutType {
		case av.LayoutTypeTable, av.LayoutTypeList, av.LayoutTypeCalendar:
			groupView.GetTableLayout().Columns = view.GetTableLayout().Columns
		case av.LayoutTypeGallery:
			groupView.Gallery.CardFields = view.Gallery.CardFields
		case av.LayoutTypeKanban:
			groupView.Kanban.Fields = view.Kanban.Fields
		}
	}

	groupView.Filters = view.Filters
	groupView.Sorts = view.Sorts
	reuseItems := nil != source && source.layoutType == groupView.LayoutType && source.query == query
	ret = RenderViewWithContext(attrView, groupView, query, ignoreRows || reuseItems, context)
	if ignoreRows {
		return
	}
	if !reuseItems {
		return
	}

	items := make([]av.Item, 0, len(groupView.GroupItemIDs))
	lastPositions := make(map[string]int, len(groupView.GroupItemIDs))
	for i, itemID := range groupView.GroupItemIDs {
		lastPositions[itemID] = i
	}
	for i, itemID := range groupView.GroupItemIDs {
		if lastPositions[itemID] != i {
			continue
		}
		if item := source.items[itemID]; nil != item {
			items = append(items, item)
		}
	}
	ret.(av.Collection).SetItems(items)
	return
}

func RenderView(attrView *av.AttributeView, view *av.View, query string, ignoreRows bool) (ret av.Viewable) {
	context := NewAttributeViewRenderContext()
	ret = RenderViewWithContext(attrView, view, query, ignoreRows, context)
	context.PushTemplateErrors()
	return
}

// RenderViewWithContext 使用指定的渲染上下文渲染属性视图。
func RenderViewWithContext(attrView *av.AttributeView, view *av.View, query string, ignoreRows bool,
	renderContext *AttributeViewRenderContext) (ret av.Viewable) {
	ret = renderViewWithContext(attrView, view, query, ignoreRows, false, renderContext)
	return
}

// RenderViewWithDeferredTemplatesContext 生成尚未计算模板字段的普通视图。
func RenderViewWithDeferredTemplatesContext(attrView *av.AttributeView, view *av.View, query string, ignoreRows bool,
	renderContext *AttributeViewRenderContext) (ret av.Viewable) {
	ret = renderViewWithContext(attrView, view, query, ignoreRows, true, renderContext)
	if !ignoreRows && strings.TrimSpace(query) == "" {
		if collection, ok := ret.(av.Collection); ok {
			clearAttributeViewRenderedContents(collection, nil)
			if renderContext != nil {
				delete(renderContext.templateStoredValues, collection)
			}
		}
	}
	return
}

func renderViewWithContext(attrView *av.AttributeView, view *av.View, query string, ignoreRows,
	deferTemplateValues bool, renderContext *AttributeViewRenderContext) (ret av.Viewable) {
	if nil == renderContext {
		renderContext = NewAttributeViewRenderContext()
	}
	if ignoreRows || "" != strings.TrimSpace(query) {
		deferTemplateValues = false
	}
	depth := 1
	renderedAttrViews := map[string]*av.AttributeView{}
	renderedAttrViews[attrView.ID] = attrView
	ret = renderView(attrView, view, query, &depth, renderedAttrViews, ignoreRows, deferTemplateValues, renderContext)

	// 元数据、延迟模板和日历渲染不写入缓存,避免后续渲染读取已裁剪的条目。
	if !ignoreRows && !deferTemplateValues && view.LayoutType != av.LayoutTypeCalendar {
		attrView.RenderedViewables[ret.GetID()] = ret
	}
	renderedAttrViews[attrView.ID] = attrView
	return
}

func renderView(attrView *av.AttributeView, view *av.View, query string, depth *int,
	cachedAttrViews map[string]*av.AttributeView, ignoreRows, deferTemplateValues bool,
	renderContext *AttributeViewRenderContext) (ret av.Viewable) {
	if 7 < *depth {
		return
	}

	*depth++
	switch view.LayoutType {
	case av.LayoutTypeTable:
		ret = renderAttributeViewTable(attrView, view, query, depth, cachedAttrViews, ignoreRows, deferTemplateValues,
			renderContext)
	case av.LayoutTypeCalendar:
		table := renderAttributeViewTable(attrView, view, query, depth, cachedAttrViews, ignoreRows, deferTemplateValues, renderContext)
		settings := view.Calendar.Settings
		table.Calendar = &settings
		table.Group = nil
		ret = &av.Calendar{Table: table}
	case av.LayoutTypeList:
		ret = &av.List{Table: renderAttributeViewTable(attrView, view, query, depth, cachedAttrViews, ignoreRows, deferTemplateValues, renderContext)}
	case av.LayoutTypeGallery:
		ret = renderAttributeViewGallery(attrView, view, query, depth, cachedAttrViews, ignoreRows, deferTemplateValues,
			renderContext)
	case av.LayoutTypeKanban:
		ret = renderAttributeViewKanban(attrView, view, query, depth, cachedAttrViews, ignoreRows, deferTemplateValues,
			renderContext)
	}
	return
}

// compileTemplateField 解析模板内容并返回可复用的已编译模板,避免在逐行渲染时反复解析。
func compileTemplateField(tplContent string) (tpl *template.Template, err error) {
	goTpl := template.New("").Delims(".action{", "}")
	tplFuncMap := filesys.BuiltInTemplateFuncs()
	SQLTemplateFuncs(&tplFuncMap)
	goTpl = goTpl.Funcs(tplFuncMap)
	tpl, err = goTpl.Parse(tplContent)
	if err != nil {
		logging.LogWarnf("parse template [%s] failed: %s", tplContent, err)
		return
	}
	return
}

func executeTemplateField(tpl *template.Template, ial map[string]string, keyValues []*av.KeyValues,
	storedValueCache map[*av.Value]*av.Value) (ret string, err error) {
	if "" == ial["id"] {
		block := getBlockValue(keyValues)
		if nil != block {
			if nil != block.Block {
				ial["id"] = block.Block.ID
			}
			if "" == ial["id"] {
				ial["id"] = block.BlockID
			}
		}
	}
	if "" == ial["updated"] {
		block := getBlockValue(keyValues)
		if nil != block && nil != block.Block {
			ial["updated"] = time.UnixMilli(block.Block.Updated).Format("20060102150405")
		}
	}

	buf := &bytes.Buffer{}
	dataModel := map[string]any{} // 复制一份 IAL 以避免修改原始数据
	for k, v := range ial {
		dataModel[k] = v

		// Database template column supports `created` and `updated` built-in variables https://github.com/siyuan-note/siyuan/issues/9364
		createdStr := ial["id"]
		if "" != createdStr {
			createdStr = createdStr[:len("20060102150405")]
		}
		created, parseErr := time.ParseInLocation("20060102150405", createdStr, time.Local)
		if nil == parseErr {
			dataModel["created"] = created
		} else {
			errMsg := parseErr.Error()
			//logging.LogWarnf("parse created [%s] failed: %s", createdStr, errMsg)
			if strings.Contains(errMsg, "minute out of range") {
				// parsing time "20240709158553": minute out of range
				// 将分秒部分置为 0000
				createdStr = createdStr[:len("2006010215")] + "0000"
			} else if strings.Contains(errMsg, "second out of range") {
				// parsing time "20240709154592": second out of range
				// 将秒部分置为 00
				createdStr = createdStr[:len("200601021504")] + "00"
			}
			created, parseErr = time.ParseInLocation("20060102150405", createdStr, time.Local)
		}
		if nil != parseErr {
			logging.LogWarnf("parse created [%s] failed: %s", createdStr, parseErr)
			dataModel["created"] = time.Now()
		}
		updatedStr := ial["updated"]
		updated, parseErr := time.ParseInLocation("20060102150405", updatedStr, time.Local)
		if nil == parseErr {
			dataModel["updated"] = updated
		} else {
			dataModel["updated"] = time.Now()
		}
	}

	dataModel["id_mod"] = map[string]any{}
	dataModel["id_mod_raw"] = map[string]any{}
	for _, keyValue := range keyValues {
		if 1 > len(keyValue.Values) {
			continue
		}

		v := keyValue.Values[0]
		if av.KeyTypeNumber == v.Type {
			if nil != v.Number && v.Number.IsNotEmpty {
				dataModel[keyValue.Key.Name] = v.Number.Content
			}
		} else if av.KeyTypeDate == v.Type {
			if nil != v.Date {
				if v.Date.IsNotEmpty {
					dataModel[keyValue.Key.Name] = time.UnixMilli(v.Date.Content)
				}
				if v.Date.IsNotEmpty2 {
					dataModel[keyValue.Key.Name+"_end"] = time.UnixMilli(v.Date.Content2)
				}
			}
		} else if av.KeyTypeRollup == v.Type {
			if 0 < len(v.Rollup.Contents) {
				var numbers []float64
				var contents []string
				for _, content := range v.Rollup.Contents {
					if av.KeyTypeNumber == content.Type {
						numbers = append(numbers, content.Number.Content)
					} else if av.KeyTypeMSelect == content.Type {
						for _, s := range content.MSelect {
							contents = append(contents, s.Content)
						}
					} else {
						contents = append(contents, content.String(true))
					}
				}

				if 0 < len(numbers) {
					dataModel[keyValue.Key.Name] = numbers
				} else {
					dataModel[keyValue.Key.Name] = contents
				}
			}
		} else if av.KeyTypeRelation == v.Type {
			if 0 < len(v.Relation.Contents) {
				var contents []string
				for _, content := range v.Relation.Contents {
					contents = append(contents, content.String(true))
				}
				dataModel[keyValue.Key.Name] = contents
			}
		} else if av.KeyTypeBlock == v.Type {
			dataModel[keyValue.Key.Name+"_created"] = time.Now()
			if nil != v.Block {
				dataModel["entryCreated"] = time.UnixMilli(v.Block.Created)
			}
			dataModel["entryUpdated"] = time.Now()
			if nil != v.Block {
				dataModel["entryUpdated"] = time.UnixMilli(v.Block.Updated)
			}
			dataModel[keyValue.Key.Name] = v.String(true)
		} else if av.KeyTypeMSelect == v.Type {
			dataModel[keyValue.Key.Name+"_str"] = v.String(true)
			var contents []string
			for _, s := range v.MSelect {
				contents = append(contents, s.Content)
			}
			dataModel[keyValue.Key.Name] = contents
		} else {
			dataModel[keyValue.Key.Name] = v.String(true)
		}

		// Database template fields support access to the raw value https://github.com/siyuan-note/siyuan/issues/14903
		rawValue := storedValueCache[v]
		if nil == rawValue {
			rawValue = av.CloneStoredValue(v)
			storedValueCache[v] = rawValue
		}
		dataModel[keyValue.Key.Name+"_raw"] = rawValue

		// Database template fields support access by ID https://github.com/siyuan-note/siyuan/issues/11237
		dataModel["id_mod"].(map[string]any)[keyValue.Key.ID] = dataModel[keyValue.Key.Name]
		dataModel["id_mod_raw"].(map[string]any)[keyValue.Key.ID] = rawValue
	}

	if err = tpl.Execute(buf, dataModel); err != nil {
		return
	}
	ret = buf.String()
	if ret == "<no value>" {
		ret = ""
		return
	}

	if util.HasUnclosedHtmlTag(ret) {
		ret = util.EscapeHTML(ret)
	}
	return
}

func generateAttrViewItems(attrView *av.AttributeView, view *av.View) (ret map[string][]*av.KeyValues) {
	ret = map[string][]*av.KeyValues{}
	var included map[string]bool
	if view.GroupItemIDs != nil {
		included = make(map[string]bool, len(view.GroupItemIDs))
		for _, id := range view.GroupItemIDs {
			included[id] = true
		}
	}
	for _, keyValues := range attrView.KeyValues {
		for _, val := range keyValues.Values {
			if included != nil && !included[val.BlockID] {
				continue
			}
			values := ret[val.BlockID]
			if nil == values {
				values = []*av.KeyValues{{Key: keyValues.Key, Values: []*av.Value{val}}}
			} else {
				values = append(values, &av.KeyValues{Key: keyValues.Key, Values: []*av.Value{val}})
			}
			ret[val.BlockID] = values
		}
	}

	// 如果是分组视图,则需要过滤掉不在分组中的项目
	if nil != view.GroupItemIDs {
		tmp := map[string][]*av.KeyValues{}
		for _, groupItemID := range view.GroupItemIDs {
			if _, ok := ret[groupItemID]; ok {
				tmp[groupItemID] = ret[groupItemID]
			}
		}
		ret = tmp
	}
	return
}

func filterNotFoundAttrViewItems(keyValuesMap map[string][]*av.KeyValues) {
	var notFound []string
	var toCheckBlockIDs []string
	for blockID, keyValues := range keyValuesMap {
		blockValue := getBlockValue(keyValues)
		if nil == blockValue || nil == blockValue.Block {
			notFound = append(notFound, blockID)
			continue
		}

		if blockValue.IsDetached {
			continue
		}

		if "" == blockValue.Block.ID {
			notFound = append(notFound, blockID)
			continue
		}

		toCheckBlockIDs = append(toCheckBlockIDs, blockValue.Block.ID)
	}
	checkRet := treenode.ExistBlockTrees(toCheckBlockIDs)
	for blockID, exist := range checkRet {
		if !exist {
			notFound = append(notFound, blockID)
		}
	}
	for _, blockID := range notFound {
		delete(keyValuesMap, blockID)
	}
}

func fillAttributeViewBaseValue(baseValue *av.BaseValue, fieldID, itemID string, fieldNumberFormat av.NumberFormat,
	fieldDateFormat av.DateDisplayFormat, fieldTemplate string, fieldDateIsTime bool) {
	switch baseValue.ValueType {
	case av.KeyTypeNumber: // 格式化数字
		if nil != baseValue.Value && nil != baseValue.Value.Number && baseValue.Value.Number.IsNotEmpty {
			baseValue.Value.Number.Format = fieldNumberFormat
			baseValue.Value.Number.FormatNumber()
		}
	case av.KeyTypeDate: // 格式化日期
		if nil != baseValue.Value && nil != baseValue.Value.Date {
			baseValue.Value.Date.FormatDate(fieldDateFormat)
		}
	case av.KeyTypeTemplate: // 渲染模板字段
		baseValue.Value = &av.Value{ID: baseValue.ID, KeyID: fieldID, BlockID: itemID, Type: av.KeyTypeTemplate, Template: &av.ValueTemplate{Content: fieldTemplate}}
	case av.KeyTypeCreated: // 填充创建时间字段值,后面再渲染
		baseValue.Value = &av.Value{ID: baseValue.ID, KeyID: fieldID, BlockID: itemID, Type: av.KeyTypeCreated}
	case av.KeyTypeUpdated: // 填充更新时间字段值,后面再渲染
		baseValue.Value = &av.Value{ID: baseValue.ID, KeyID: fieldID, BlockID: itemID, Type: av.KeyTypeUpdated}
	}

	if nil == baseValue.Value {
		baseValue.Value = av.GetAttributeViewDefaultValue(baseValue.ID, fieldID, itemID, baseValue.ValueType, fieldDateIsTime)
	} else {
		FillAttributeViewNilValue(baseValue.Value, baseValue.ValueType)
	}
}

func fillAttributeViewBlockRefSubtypes(attrView *av.AttributeView, attrs map[string]map[string]string) map[string]map[string]string {
	if nil == attrs {
		attrs = map[string]map[string]string{}
	}
	blockValues := attrView.GetBlockKeyValues()
	if nil == blockValues {
		return attrs
	}

	var missingBlockIDs []string
	addedBlockIDs := map[string]bool{}
	for _, value := range blockValues.Values {
		if nil == value || nil == value.Block || value.IsDetached || "" == value.Block.ID || value.Block.RefSubtype.IsValid() {
			continue
		}
		if _, loaded := attrs[value.Block.ID]; !loaded && !addedBlockIDs[value.Block.ID] {
			missingBlockIDs = append(missingBlockIDs, value.Block.ID)
			addedBlockIDs[value.Block.ID] = true
		}
	}
	maps.Copy(attrs, BatchGetBlockAttrs(missingBlockIDs))
	for _, value := range blockValues.Values {
		if nil == value || nil == value.Block {
			continue
		}
		value.NormalizeBlockRefSubtype(attrView.ID, attrs[value.Block.ID])
	}
	return attrs
}

func fillAttributeViewAutoGeneratedValues(attrView *av.AttributeView, collection av.Collection,
	ials map[string]map[string]string, depth *int, cachedAttrViews map[string]*av.AttributeView,
	renderContext *AttributeViewRenderContext) {
	// 渲染主键、创建时间、更新时间
	ials = fillAttributeViewBlockRefSubtypes(attrView, ials)

	for _, item := range collection.GetItems() {
		for _, value := range item.GetValues() {
			itemID := item.GetID()

			switch value.Type {
			case av.KeyTypeBlock: // 对于主键可能需要填充静态锚文本 Database-bound block primary key supports setting static anchor text https://github.com/siyuan-note/siyuan/issues/10049
				if nil != value.Block && av.BlockRefSubtypeStatic == value.Block.RefSubtype {
					if staticText := ials[value.Block.ID][av.NodeAttrViewStaticText+"-"+attrView.ID]; "" != staticText {
						value.Block.Content = staticText
					}
				}
			case av.KeyTypeCreated: // 渲染创建时间
				key, _ := attrView.GetKey(value.KeyID)
				isNotTime := false
				dateFormat := av.DateDisplayFormatDefault
				if nil != key {
					dateFormat = key.DateFormat
					if nil != key.Created {
						isNotTime = !key.Created.IncludeTime
					}
				}

				ial := map[string]string{}
				block := item.GetBlockValue()
				if nil != block {
					ial = ials[block.Block.ID]
				}
				if nil == ial {
					ial = map[string]string{}
				}
				id := itemID
				if "" != ial["id"] {
					id = ial["id"]
				}
				createdStr := id[:len("20060102150405")]
				created, parseErr := time.ParseInLocation("20060102150405", createdStr, time.Local)
				if nil == parseErr {
					value.Created = av.NewFormattedValueCreated(created.UnixMilli(), 0, av.CreatedFormatNone, isNotTime)
				} else {
					value.Created = av.NewFormattedValueCreated(time.Now().UnixMilli(), 0, av.CreatedFormatNone, isNotTime)
				}
				value.Created.FormatDate(dateFormat, isNotTime)
			case av.KeyTypeUpdated: // 渲染更新时间
				key, _ := attrView.GetKey(value.KeyID)
				isNotTime := false
				dateFormat := av.DateDisplayFormatDefault
				if nil != key {
					dateFormat = key.DateFormat
					if nil != key.Updated {
						isNotTime = !key.Updated.IncludeTime
					}
				}

				ial := map[string]string{}
				block := item.GetBlockValue()
				if nil != block {
					ial = ials[block.Block.ID]
				}
				if nil == ial {
					ial = map[string]string{}
				}
				updatedStr := ial["updated"]
				if "" == updatedStr && nil != block {
					value.Updated = av.NewFormattedValueUpdated(block.Block.Updated, 0, av.UpdatedFormatNone, isNotTime)
				} else {
					updated, parseErr := time.ParseInLocation("20060102150405", updatedStr, time.Local)
					if nil == parseErr {
						value.Updated = av.NewFormattedValueUpdated(updated.UnixMilli(), 0, av.UpdatedFormatNone, isNotTime)
					} else {
						value.Updated = av.NewFormattedValueUpdated(time.Now().UnixMilli(), 0, av.UpdatedFormatNone, isNotTime)
					}
				}
				value.Updated.FormatDate(dateFormat, isNotTime)
			}
		}
	}

	// 渲染关联
	blocksCache := map[string]map[string]*av.Value{}
	relationValues := map[string][]*av.Value{}
	normalizedBlockRefSubtypes := map[string]bool{attrView.ID: true}
	for _, item := range collection.GetItems() {
		for _, value := range item.GetValues() {
			if av.KeyTypeRelation != value.Type {
				continue
			}

			value.Relation.Contents = nil
			relKey, _ := attrView.GetKey(value.KeyID)
			if nil != relKey && nil != relKey.Relation {
				destAv := loadRelatedAttributeView(attrView, relKey.Relation.AvID, cachedAttrViews)
				if nil != destAv {
					relationValues[destAv.ID] = append(relationValues[destAv.ID], value)
					if !normalizedBlockRefSubtypes[destAv.ID] {
						fillAttributeViewBlockRefSubtypes(destAv, nil)
						normalizedBlockRefSubtypes[destAv.ID] = true
					}
					blocks := blocksCache[destAv.ID]
					if nil == blocks {
						blocks = map[string]*av.Value{}
						blockValues := destAv.GetBlockKeyValues()
						if nil != blockValues {
							for _, blockValue := range blockValues.Values {
								blocks[blockValue.BlockID] = blockValue
							}
						}
						blocksCache[destAv.ID] = blocks
					}
					for _, blockID := range value.Relation.BlockIDs {
						if val := blocks[blockID]; nil != val {
							value.Relation.Contents = append(value.Relation.Contents, val)
						}
					}
				}
			}
		}
	}

	// 在目标行上下文中计算关联主键显示,模板读取的关联值仍保持原始内容。
	if !renderContext.renderingRelationTemplates {
		for destAvID, values := range relationValues {
			fillRelationPrimaryTemplates(cachedAttrViews[destAvID], values, depth, cachedAttrViews, renderContext)
		}
	}

	// 渲染汇总
	rollupRenderContexts := map[string]*av.RollupRenderContext{}
	for _, field := range collection.GetFields() {
		if av.KeyTypeRollup != field.GetType() {
			continue
		}

		rollupKey, _ := attrView.GetKey(field.GetID())
		if nil == rollupKey || nil == rollupKey.Rollup {
			continue
		}

		relKey, _ := attrView.GetKey(rollupKey.Rollup.RelationKeyID)
		if nil == relKey || nil == relKey.Relation {
			continue
		}

		destAv := loadRelatedAttributeView(attrView, relKey.Relation.AvID, cachedAttrViews)
		if nil == destAv {
			continue
		}
		if !normalizedBlockRefSubtypes[destAv.ID] {
			fillAttributeViewBlockRefSubtypes(destAv, nil)
			normalizedBlockRefSubtypes[destAv.ID] = true
		}

		destKey, _ := destAv.GetKey(rollupKey.Rollup.KeyID)
		if nil == destKey {
			continue
		}

		isSameAv := destAv.ID == attrView.ID
		var furtherCollection av.Collection
		if av.KeyTypeRollup == destKey.Type {
			furtherCollection = renderRollupTarget(destAv, destKey, depth, cachedAttrViews, renderContext)
		} else if av.NeedsRollupTargetRender(destKey.Type, isSameAv) {
			viewable := renderView(destAv, destAv.Views[0], "", depth, cachedAttrViews, false, false, renderContext)
			if nil != viewable {
				furtherCollection = viewable.(av.Collection)
			} else {
				fillAttributeViewTemplateValues(destAv, destAv.Views[0], collection, ials, renderContext)
				furtherCollection = collection
			}
		}
		context := &av.RollupRenderContext{FurtherCollection: furtherCollection}
		if hasFilterConditions(rollupKey.Rollup.Filters) {
			filterDepth := *depth
			context.EligibleItemIDs = filterAttributeViewItemIDs(destAv, rollupKey.Rollup.Filters, &filterDepth,
				cachedAttrViews, renderContext)
		}
		rollupRenderContexts[rollupKey.ID] = context
	}

	for _, item := range collection.GetItems() {
		for _, value := range item.GetValues() {
			if av.KeyTypeRollup != value.Type {
				continue
			}

			rollupKey, _ := attrView.GetKey(value.KeyID)
			if nil == rollupKey || nil == rollupKey.Rollup {
				break
			}

			relKey, _ := attrView.GetKey(rollupKey.Rollup.RelationKeyID)
			if nil == relKey || nil == relKey.Relation {
				break
			}

			relVal := attrView.GetValue(relKey.ID, item.GetID())
			if nil == relVal || nil == relVal.Relation {
				break
			}

			destAv := loadRelatedAttributeView(attrView, relKey.Relation.AvID, cachedAttrViews)
			if nil == destAv {
				break
			}

			destKey, _ := destAv.GetKey(rollupKey.Rollup.KeyID)
			if nil == destKey {
				break
			}

			context := rollupRenderContexts[rollupKey.ID]
			value.Rollup.BuildContents(destAv, destKey, relVal, rollupKey.Rollup.Calc, context)
		}
	}
}

func hasFilterConditions(filters []*av.ViewFilter) bool {
	for _, filter := range filters {
		if nil == filter {
			continue
		}
		if filter.IsGroup() {
			if hasFilterConditions(filter.Filters) {
				return true
			}
			continue
		}
		return true
	}
	return false
}

// loadRelatedAttributeView 为历史和仓库快照渲染绑定请求级调色板,同时保持关联数据库的字段和值来源不变。
func loadRelatedAttributeView(source *av.AttributeView, avID string, cachedAttrViews map[string]*av.AttributeView) (ret *av.AttributeView) {
	if ret = cachedAttrViews[avID]; nil != ret {
		return
	}

	ret, _ = av.ParseAttributeView(avID)
	if nil == ret {
		return
	}
	applyRelatedCustomColorRenderContext(source, ret)
	cachedAttrViews[avID] = ret
	return
}

func applyRelatedCustomColorRenderContext(source, target *av.AttributeView) {
	if nil == source {
		return
	}
	source.ApplyRelatedCustomColorRenderContext(target)
}

func filterAttributeViewItemIDs(attrView *av.AttributeView, filters []*av.ViewFilter, depth *int,
	cachedAttrViews map[string]*av.AttributeView, renderContext *AttributeViewRenderContext) (ret map[string]bool) {
	ret = map[string]bool{}
	if nil == attrView || !hasFilterConditions(filters) {
		return
	}

	view := &av.View{
		ID:         ast.NewNodeID(),
		Filters:    av.CloneFilters(filters),
		Sorts:      []*av.ViewSort{},
		PageSize:   av.ViewDefaultPageSize,
		LayoutType: av.LayoutTypeTable,
		Table:      av.NewLayoutTable(),
	}
	added := map[string]bool{}
	if blockKey := attrView.GetBlockKey(); nil != blockKey {
		view.Table.Columns = append(view.Table.Columns, &av.ViewTableColumn{BaseField: &av.BaseField{ID: blockKey.ID}})
		added[blockKey.ID] = true
	}
	for _, keyValues := range attrView.KeyValues {
		if nil == keyValues || nil == keyValues.Key || added[keyValues.Key.ID] {
			continue
		}
		view.Table.Columns = append(view.Table.Columns, &av.ViewTableColumn{
			BaseField: &av.BaseField{ID: keyValues.Key.ID},
		})
		added[keyValues.Key.ID] = true
	}

	viewable := renderView(attrView, view, "", depth, cachedAttrViews, false, false, renderContext)
	if nil == viewable {
		return
	}
	collection := viewable.(av.Collection)
	av.Filter(viewable, attrView, getFurtherCollections(attrView, cachedAttrViews, depth, renderContext), cachedAttrViews)
	for _, item := range collection.GetItems() {
		ret[item.GetID()] = true
	}
	return
}

func getFurtherCollections(attrView *av.AttributeView, cachedAttrViews map[string]*av.AttributeView,
	depth *int, renderContext *AttributeViewRenderContext) (ret map[string]*av.RollupRenderContext) {
	ret = map[string]*av.RollupRenderContext{}
	for _, kv := range attrView.KeyValues {
		if av.KeyTypeRollup != kv.Key.Type {
			continue
		}

		if nil == kv.Key.Rollup {
			continue
		}

		relKey, _ := attrView.GetKey(kv.Key.Rollup.RelationKeyID)
		if nil == relKey || nil == relKey.Relation {
			continue
		}

		destAv := loadRelatedAttributeView(attrView, relKey.Relation.AvID, cachedAttrViews)
		if nil == destAv {
			continue
		}

		destKey, _ := destAv.GetKey(kv.Key.Rollup.KeyID)
		if nil == destKey {
			continue
		}
		isSameAv := destAv.ID == attrView.ID

		var furtherCollection av.Collection
		if av.KeyTypeRollup == destKey.Type {
			furtherCollection = renderRollupTarget(destAv, destKey, depth, cachedAttrViews, renderContext)
		} else if av.NeedsRollupTargetRender(destKey.Type, isSameAv) {
			viewable := renderView(destAv, destAv.Views[0], "", depth, cachedAttrViews, false, false, renderContext)
			if nil != viewable {
				furtherCollection = viewable.(av.Collection)
			}
		}
		context := &av.RollupRenderContext{FurtherCollection: furtherCollection}
		if hasFilterConditions(kv.Key.Rollup.Filters) {
			filterDepth := *depth
			context.EligibleItemIDs = filterAttributeViewItemIDs(destAv, kv.Key.Rollup.Filters, &filterDepth,
				cachedAttrViews, renderContext)
		}
		ret[kv.Key.ID] = context
	}
	return
}

func GetFurtherCollections(attrView *av.AttributeView,
	cachedAttrViews map[string]*av.AttributeView) map[string]*av.RollupRenderContext {
	renderContext := NewAttributeViewRenderContext()
	ret := GetFurtherCollectionsWithContext(attrView, cachedAttrViews, renderContext)
	renderContext.PushTemplateErrors()
	return ret
}

// GetFurtherCollectionsWithContext 使用指定的渲染上下文获取后续集合。
func GetFurtherCollectionsWithContext(attrView *av.AttributeView, cachedAttrViews map[string]*av.AttributeView,
	renderContext *AttributeViewRenderContext) map[string]*av.RollupRenderContext {
	depth := 1
	return getFurtherCollections(attrView, cachedAttrViews, &depth, renderContext)
}

// FillAttributeViewTemplateValuesWithContext 计算集合中当前条目的模板字段值和显示模板结果。
func FillAttributeViewTemplateValuesWithContext(attrView *av.AttributeView, view *av.View, collection av.Collection,
	renderContext *AttributeViewRenderContext) {
	FillAttributeViewTemplateValuesForKeysWithContext(attrView, view, collection, nil, renderContext)
}

// FillAttributeViewTemplateValuesForKeysWithContext 只求值指定字段,保留其他字段已计算的显示结果。
// keys 为 nil 时求值全部模板,非 nil 的空集合不执行模板。
func FillAttributeViewTemplateValuesForKeysWithContext(attrView *av.AttributeView, view *av.View, collection av.Collection,
	keys map[string]bool, renderContext *AttributeViewRenderContext) {
	if keys != nil && len(keys) == 0 {
		return
	}
	var ialIDs []string
	for _, item := range collection.GetItems() {
		blockValue := item.GetBlockValue()
		if nil == blockValue || nil == blockValue.Block || blockValue.IsDetached {
			continue
		}
		ialIDs = append(ialIDs, blockValue.Block.ID)
	}
	fillAttributeViewTemplateValuesForKeys(attrView, view, collection, BatchGetBlockAttrs(ialIDs), renderContext, keys)
}

func fillAttributeViewTemplateValues(attrView *av.AttributeView, view *av.View, collection av.Collection,
	ials map[string]map[string]string, renderContext *AttributeViewRenderContext) {
	fillAttributeViewTemplateValuesForKeys(attrView, view, collection, ials, renderContext, nil)
}

func clearAttributeViewRenderedContents(collection av.Collection, keys map[string]bool) {
	for _, item := range collection.GetItems() {
		for _, value := range item.GetValues() {
			if value != nil && (keys == nil || keys[value.KeyID]) {
				value.RenderedContent = ""
				value.HasRenderTemplate = false
			}
		}
	}
}

func fillAttributeViewTemplateValuesForKeys(attrView *av.AttributeView, view *av.View, collection av.Collection,
	ials map[string]map[string]string, renderContext *AttributeViewRenderContext, keys map[string]bool) {
	timing := util.BeginPerformance("database.templates")
	var evaluated int64
	defer func() { timing.Count("values", evaluated); timing.Finish() }()
	items := generateAttrViewItems(attrView, view)
	existTemplateField := false
	for _, kVals := range attrView.KeyValues {
		if av.KeyTypeTemplate == kVals.Key.Type || "" != strings.TrimSpace(kVals.Key.RenderTemplate) {
			existTemplateField = true
			break
		}
	}
	clearAttributeViewRenderedContents(collection, keys)
	if !existTemplateField {
		return
	}

	templateKeys, _ := GetTemplateKeysByResolutionOrder(attrView)
	// 按模板内容缓存已编译模板,避免逐行重复 Parse。坏内容缓存为 nil,逐行设置 err 并继续渲染其余行。
	tplCache := map[string]*template.Template{}
	compileErrCache := map[string]error{}
	storedValueCache := map[*av.Value]*av.Value{}
	if keys != nil && renderContext != nil {
		if renderContext.templateStoredValues == nil {
			renderContext.templateStoredValues = map[av.Collection]map[*av.Value]*av.Value{}
		}
		storedValueCache = renderContext.templateStoredValues[collection]
		if storedValueCache == nil {
			storedValueCache = map[*av.Value]*av.Value{}
			renderContext.templateStoredValues[collection] = storedValueCache
		}
	}
	timing.Stage("evaluate")
	for _, templateKey := range templateKeys {
		if keys != nil && !keys[templateKey.ID] {
			continue
		}
		templateContent := templateKey.Template
		isRenderTemplate := av.KeyTypeTemplate != templateKey.Type
		if isRenderTemplate {
			templateContent = templateKey.RenderTemplate
		}
		for _, item := range collection.GetItems() {
			value := item.GetValue(templateKey.ID)
			if nil == value || (!isRenderTemplate && nil == value.Template) {
				continue
			}
			evaluated++

			keyValues := items[item.GetID()]
			var ial map[string]string
			blockVal := item.GetBlockValue()
			if nil != blockVal {
				ial = ials[blockVal.Block.ID]
			}
			if nil == ial {
				ial = map[string]string{}
			}

			var content string
			var renderErr error
			tpl, tried := tplCache[templateContent]
			if !tried {
				compiled, compileErr := compileTemplateField(templateContent)
				tplCache[templateContent] = compiled // 坏内容时 compiled 为 nil,仍写入缓存
				if nil != compileErr {
					compileErrCache[templateContent] = compileErr
					renderErr = compileErr
				} else {
					tpl = compiled
				}
			} else if nil == tpl {
				renderErr = compileErrCache[templateContent] // 复用首次解析的错误
			}
			if nil == renderErr {
				content, renderErr = executeTemplateField(tpl, ial, keyValues, storedValueCache)
			}
			if nil != renderErr {
				renderContext.addTemplateError(attrView, templateKey, item, renderErr)
			}

			if isRenderTemplate {
				value.RenderedContent = content
				value.HasRenderTemplate = true
			} else {
				value.Template.Content = content
				items[item.GetID()] = append(keyValues, &av.KeyValues{Key: templateKey, Values: []*av.Value{value}})
			}
		}
	}
}

func fillAttributeViewKeyValues(attrView *av.AttributeView, collection av.Collection) {
	fieldValues := map[string][]*av.Value{}
	for _, item := range collection.GetItems() {
		for _, val := range item.GetValues() {
			keyID := val.KeyID
			fieldValues[keyID] = append(fieldValues[keyID], val)
		}
	}
	for keyID, values := range fieldValues {
		keyValues, _ := attrView.GetKeyValues(keyID)
		if nil == keyValues {
			logging.LogWarnf("attribute view [%s] key [%s] not found while filling values", attrView.ID, keyID)
			continue
		}
		if av.HasKeyGroup(keyValues.Key.Type, av.KeyGroupRenderAutoFill) {
			renderedBlockIDs := map[string]bool{}
			for _, val := range values {
				val.IsRenderAutoFill = true
				renderedBlockIDs[val.BlockID] = true
			}

			retained := keyValues.Values[:0]
			for _, val := range keyValues.Values {
				if !renderedBlockIDs[val.BlockID] {
					retained = append(retained, val)
				}
			}
			keyValues.Values = append(retained, values...)
			continue
		}

		existingIDs := map[string]bool{}
		for _, kv := range keyValues.Values {
			existingIDs[kv.ID] = true
		}
		for _, val := range values {
			if !existingIDs[val.ID] {
				val.IsRenderAutoFill = true
				keyValues.Values = append(keyValues.Values, val)
				existingIDs[val.ID] = true
			}
		}
	}
}

func FillAttributeViewNilValue(value *av.Value, typ av.KeyType) {
	value.Type = typ
	switch typ {
	case av.KeyTypeText:
		if nil == value.Text {
			value.Text = &av.ValueText{}
		}
	case av.KeyTypeNumber:
		if nil == value.Number {
			value.Number = &av.ValueNumber{}
		}
	case av.KeyTypeDate:
		if nil == value.Date {
			value.Date = &av.ValueDate{}
		}
	case av.KeyTypeSelect:
		if 1 > len(value.MSelect) {
			value.MSelect = []*av.ValueSelect{}
		}
	case av.KeyTypeMSelect:
		if 1 > len(value.MSelect) {
			value.MSelect = []*av.ValueSelect{}
		}
	case av.KeyTypeURL:
		if nil == value.URL {
			value.URL = &av.ValueURL{}
		}
	case av.KeyTypeEmail:
		if nil == value.Email {
			value.Email = &av.ValueEmail{}
		}
	case av.KeyTypeLocation:
		if nil == value.Location {
			value.Location = &av.ValueLocation{}
		}
	case av.KeyTypePhone:
		if nil == value.Phone {
			value.Phone = &av.ValuePhone{}
		}
	case av.KeyTypeMAsset:
		if 1 > len(value.MAsset) {
			value.MAsset = []*av.ValueAsset{}
		}
	case av.KeyTypeTemplate:
		if nil == value.Template {
			value.Template = &av.ValueTemplate{}
		}
	case av.KeyTypeCreated:
		if nil == value.Created {
			value.Created = &av.ValueCreated{}
		}
	case av.KeyTypeUpdated:
		if nil == value.Updated {
			value.Updated = &av.ValueUpdated{}
		}
	case av.KeyTypeCheckbox:
		if nil == value.Checkbox {
			value.Checkbox = &av.ValueCheckbox{}
		}
	case av.KeyTypeRelation:
		if nil == value.Relation {
			value.Relation = &av.ValueRelation{}
		}
	case av.KeyTypeRollup:
		if nil == value.Rollup {
			value.Rollup = &av.ValueRollup{}
		}
	}
}

func getBlockValue(keyValues []*av.KeyValues) (ret *av.Value) {
	for _, kv := range keyValues {
		if av.KeyTypeBlock == kv.Key.Type && 0 < len(kv.Values) {
			ret = kv.Values[0]
			break
		}
	}
	return
}

func getAttrViewName(attrView *av.AttributeView) string {
	ret := strings.TrimSpace(attrView.Name)
	if "" == ret {
		ret = util.Langs[util.Lang][105]
	}
	return ret
}

func removeMissingField(attrView *av.AttributeView, view *av.View, missingKeyID string, context *AttributeViewRenderContext) {
	logging.LogWarnf("key [%s] is missing", missingKeyID)

	changed := false
	for _, layout := range []*av.LayoutTable{view.Table, view.List} {
		if nil == layout {
			continue
		}
		for i, column := range layout.Columns {
			if column.ID == missingKeyID {
				layout.Columns = append(layout.Columns[:i], layout.Columns[i+1:]...)
				changed = true
				break
			}
		}
	}

	if nil != view.Gallery {
		for i, cardField := range view.Gallery.CardFields {
			if cardField.ID == missingKeyID {
				view.Gallery.CardFields = append(view.Gallery.CardFields[:i], view.Gallery.CardFields[i+1:]...)
				changed = true
				break
			}
		}
	}

	if nil != view.Kanban {
		for i, kanbanField := range view.Kanban.Fields {
			if kanbanField.ID == missingKeyID {
				view.Kanban.Fields = append(view.Kanban.Fields[:i], view.Kanban.Fields[i+1:]...)
				changed = true
				break
			}
		}
	}

	if changed && (nil == context || !context.ReadOnly) {
		av.SaveAttributeView(attrView)
	}
}

// filterByQuery 根据搜索条件过滤
func filterByQuery(query string, collection av.Collection) {
	query = strings.TrimSpace(query)
	if "" != query {
		query = strings.Join(strings.Fields(query), " ") // 将连续空格转换为一个空格
		keywords := strings.Split(query, " ")            // 按空格分割关键字

		// 使用 AND 逻辑 https://github.com/siyuan-note/siyuan/issues/11535
		var hitItems []av.Item
		for _, item := range collection.GetItems() {
			hit := false
			for _, cell := range item.GetValues() {
				allKeywordsHit := true
				for _, keyword := range keywords {
					if !util.SearchCaseSensitive.Load() {
						if !strings.Contains(strings.ToLower(cell.String(true)), strings.ToLower(keyword)) {
							allKeywordsHit = false
							break
						}
					} else {
						if !strings.Contains(cell.String(true), keyword) {
							allKeywordsHit = false
							break
						}
					}
				}
				if allKeywordsHit {
					hit = true
					break
				}
			}
			if hit {
				hitItems = append(hitItems, item)
			}
		}
		collection.SetItems(hitItems)
		if 1 > len(collection.GetItems()) {
			collection.SetItems([]av.Item{})
		}
	}
}

// manualSort 处理用户手动排序。
func manualSort(view *av.View, collection av.Collection) {
	itemIDs := view.ItemIDs
	// 如果是分组视图,则需要根据分组项的顺序进行排序
	if 0 < len(view.GroupItemIDs) {
		itemIDs = view.GroupItemIDs
	}

	sortItemIDs := map[string]int{}
	for i, itemID := range itemIDs {
		sortItemIDs[itemID] = i
	}

	items := collection.GetItems()
	sort.Slice(items, func(i, j int) bool {
		iv := sortItemIDs[items[i].GetID()]
		jv := sortItemIDs[items[j].GetID()]
		if iv == jv {
			return items[i].GetID() < items[j].GetID()
		}
		return iv < jv
	})
	collection.SetItems(items)
}

func GetTemplateKeysByResolutionOrder(attrView *av.AttributeView) (ret []*av.Key, resolved bool) {
	ret = []*av.Key{}

	resolvedTemplateKeys := map[string]bool{}
	for range 7 {
		templateKeyCount := 0
		for _, keyValues := range attrView.KeyValues {
			if av.KeyTypeTemplate != keyValues.Key.Type {
				continue
			}

			templateKeyCount++
			if resolvedTemplateKeys[keyValues.Key.ID] {
				continue
			}
			vars, err := getTemplateVars(keyValues.Key.Template)
			if nil != err {
				resolvedTemplateKeys[keyValues.Key.ID] = true
				ret = append(ret, keyValues.Key)
				continue
			}

			currentTemplateKeyResolved := true
			for _, kValues := range attrView.KeyValues {
				if templateVarsReferenceKey(vars, kValues.Key) {
					if av.KeyTypeTemplate == kValues.Key.Type {
						if _, ok := resolvedTemplateKeys[kValues.Key.ID]; !ok {
							currentTemplateKeyResolved = false
							break
						}
					}
				}
			}
			if currentTemplateKeyResolved {
				resolvedTemplateKeys[keyValues.Key.ID] = true
				ret = append(ret, keyValues.Key)
			}
		}

		resolved = len(resolvedTemplateKeys) == templateKeyCount
		if resolved {
			break
		}
	}
	for _, keyValues := range attrView.KeyValues {
		if av.KeyTypeTemplate != keyValues.Key.Type && "" != strings.TrimSpace(keyValues.Key.RenderTemplate) {
			ret = append(ret, keyValues.Key)
		}
	}
	return
}

func GetTemplateKeyRelevantKeys(attrView *av.AttributeView, templateKey *av.Key) (ret []*av.Key) {
	ret = []*av.Key{}
	if nil == templateKey {
		return
	}

	templateContent := templateKey.Template
	if av.KeyTypeTemplate != templateKey.Type {
		templateContent = templateKey.RenderTemplate
	}
	if "" == strings.TrimSpace(templateContent) {
		return
	}

	vars, err := getTemplateVars(templateContent)
	if nil != err {
		return
	}
	dynamicDependency := slices.Contains(vars, dynamicTemplateKeyVar)
	if dynamicDependency {
		for _, keyValues := range attrView.KeyValues {
			if nil != keyValues && nil != keyValues.Key {
				ret = append(ret, keyValues.Key)
			}
		}
		return
	}

	for _, kValues := range attrView.KeyValues {
		if templateVarsReferenceKey(vars, kValues.Key) {
			ret = append(ret, kValues.Key)
		}
	}

	if 1 > len(ret) {
		// 没有相关字段情况下直接尝试解析模板,如果能解析成功则返回模板字段本身 https://github.com/siyuan-note/siyuan/issues/15560#issuecomment-3182691193
		goTpl := template.New("").Delims(".action{", "}")
		tplFuncMap := filesys.BuiltInTemplateFuncs()
		SQLTemplateFuncs(&tplFuncMap)
		goTpl = goTpl.Funcs(tplFuncMap)
		_, parseErr := goTpl.Funcs(tplFuncMap).Parse(templateContent)
		if nil != parseErr {
			return
		}
		ret = append(ret, templateKey)
	}
	return
}

func templateVarsReferenceKey(vars []string, key *av.Key) bool {
	if nil == key {
		return false
	}
	for _, variable := range vars {
		if variable == key.ID || variable == key.Name || variable == key.Name+"_raw" ||
			variable == key.Name+"_end" || variable == key.Name+"_created" || variable == key.Name+"_str" {
			return true
		}
	}
	return false
}

func getTemplateVars(tplContent string) ([]string, error) {
	goTpl := template.New("").Delims(".action{", "}")
	tplFuncMap := filesys.BuiltInTemplateFuncs()
	SQLTemplateFuncs(&tplFuncMap)
	goTpl = goTpl.Funcs(tplFuncMap)
	tpl, parseErr := goTpl.Funcs(tplFuncMap).Parse(tplContent)
	if parseErr != nil {
		return nil, parseErr
	}
	vars := make(map[string]struct{})
	collectVars(tpl.Tree.Root, vars)
	var result []string
	for v := range vars {
		result = append(result, v)
	}
	return result, nil
}

const dynamicTemplateKeyVar = "\x00dynamic-id-mod"

func isTemplateIDModField(node parse.Node) bool {
	field, ok := node.(*parse.FieldNode)
	return ok && 0 < len(field.Ident) && ("id_mod" == field.Ident[0] || "id_mod_raw" == field.Ident[0])
}

func collectVars(node parse.Node, vars map[string]struct{}) {
	switch n := node.(type) {
	case *parse.ListNode:
		for _, child := range n.Nodes {
			collectVars(child, vars)
		}
	case *parse.ActionNode:
		collectVars(n.Pipe, vars)
	case *parse.PipeNode:
		for _, cmd := range n.Cmds {
			collectVars(cmd, vars)
		}
	case *parse.CommandNode:
		isIndex := 0 < len(n.Args) && n.Args[0].Type() == parse.NodeIdentifier && "index" == n.Args[0].String()
		if isIndex && 2 <= len(n.Args) && isTemplateIDModField(n.Args[1]) {
			for i, arg := range n.Args {
				if 1 != i {
					collectVars(arg, vars)
				}
			}
			if 3 <= len(n.Args) && n.Args[2].Type() == parse.NodeString {
				vars[n.Args[2].(*parse.StringNode).Text] = struct{}{}
			} else {
				vars[dynamicTemplateKeyVar] = struct{}{}
			}
			return
		}
		for _, arg := range n.Args {
			collectVars(arg, vars)
		}

		if isIndex && 3 <= len(n.Args) && n.Args[1].Type() == parse.NodeDot && n.Args[2].Type() == parse.NodeString {
			vars[n.Args[2].(*parse.StringNode).Text] = struct{}{}
		}

	case *parse.FieldNode:
		if len(n.Ident) > 0 {
			if "id_mod" == n.Ident[0] || "id_mod_raw" == n.Ident[0] {
				if 1 < len(n.Ident) {
					vars[n.Ident[1]] = struct{}{}
				} else {
					vars[dynamicTemplateKeyVar] = struct{}{}
				}
			} else {
				vars[n.Ident[0]] = struct{}{}
			}
		}
	case *parse.VariableNode:
		if len(n.Ident) > 0 {
			vars[n.Ident[0]] = struct{}{}
		}
	}
}