Skip to content

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

4.6 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 (
	"github.com/88250/lute/ast"
	"github.com/siyuan-note/siyuan/kernel/av"
)

func RenderAttributeViewTable(attrView *av.AttributeView, view *av.View, query string, depth *int, cachedAttrViews map[string]*av.AttributeView, ignoreRows bool) (ret *av.Table) {
	context := NewAttributeViewRenderContext()
	ret = renderAttributeViewTable(attrView, view, query, depth, cachedAttrViews, ignoreRows, false, context)
	context.PushTemplateErrors()
	return
}

func renderAttributeViewTable(attrView *av.AttributeView, view *av.View, query string, depth *int,
	cachedAttrViews map[string]*av.AttributeView, ignoreRows, deferTemplateValues bool,
	renderContext *AttributeViewRenderContext) (ret *av.Table) {
	if !ignoreRows && !deferTemplateValues && view.LayoutType != av.LayoutTypeCalendar {
		viewable := attrView.RenderedViewables[view.ID]
		if nil != viewable {
			if ret = av.TableFromViewable(viewable); nil != ret {
				return
			}
		}
	}

	ret = &av.Table{
		BaseInstance: av.NewViewBaseInstance(view),
		Columns:      []*av.TableColumn{},
		Rows:         []*av.TableRow{},
	}

	// 组装列
	for _, col := range view.GetTableLayout().Columns {
		key, getErr := attrView.GetKey(col.ID)
		if nil != getErr {
			// 找不到字段则在视图中删除(元数据查询场景不写盘)
			if !ignoreRows {
				removeMissingField(attrView, view, col.ID, renderContext)
			}
			continue
		}

		ret.Columns = append(ret.Columns, &av.TableColumn{
			BaseInstanceField: &av.BaseInstanceField{
				ID:             key.ID,
				Name:           key.Name,
				Type:           key.Type,
				Icon:           key.Icon,
				Wrap:           col.Wrap,
				Hidden:         col.Hidden && !((av.LayoutTypeList == view.LayoutType || av.LayoutTypeCalendar == view.LayoutType) && av.KeyTypeBlock == key.Type),
				Desc:           key.Desc,
				Calc:           col.Calc,
				Options:        key.Options,
				NumberFormat:   key.NumberFormat,
				DateFormat:     key.DateFormat,
				Template:       key.Template,
				RenderTemplate: key.RenderTemplate,
				Relation:       key.Relation,
				Rollup:         key.Rollup,
				Date:           key.Date,
				Created:        key.Created,
				Updated:        key.Updated,
			},
			Width: col.Width,
			Pin:   col.Pin,
			Align: col.Align,
		})
	}

	// 菜单等只需要字段/视图元数据的场景,跳过全部行处理
	if ignoreRows {
		return
	}

	rowsValues := generateAttrViewItems(attrView, view) // 生成行
	filterNotFoundAttrViewItems(rowsValues)             // 过滤掉不存在的行

	// 生成行单元格
	for rowID, rowValues := range rowsValues {
		// 按字段 ID 建索引,避免后续列循环里对每个单元格做线性查找
		kvByCol := map[string]*av.KeyValues{}
		for _, keyValues := range rowValues {
			if _, ok := kvByCol[keyValues.Key.ID]; !ok { // 同一字段存在多个值时只取第一个
				kvByCol[keyValues.Key.ID] = keyValues
			}
		}

		var tableRow av.TableRow
		for _, col := range ret.Columns {
			var tableCell *av.TableCell
			if keyValues, ok := kvByCol[col.ID]; ok {
				tableCell = &av.TableCell{
					BaseValue: &av.BaseValue{
						ID:        keyValues.Values[0].ID,
						Value:     keyValues.Values[0],
						ValueType: col.Type,
					},
				}
			}
			if nil == tableCell {
				tableCell = &av.TableCell{
					BaseValue: &av.BaseValue{
						ID:        rowID[:14] + ast.NewNodeID()[14:],
						ValueType: col.Type,
					},
				}
			}
			tableRow.ID = rowID

			filedDateIsTime := false
			if nil != col.Date {
				filedDateIsTime = col.Date.FillSpecificTime
			}
			fillAttributeViewBaseValue(tableCell.BaseValue, col.ID, rowID, col.NumberFormat, col.DateFormat, col.Template,
				filedDateIsTime)
			tableRow.Cells = append(tableRow.Cells, tableCell)
		}
		ret.Rows = append(ret.Rows, &tableRow)
	}

	// 回填补全数据
	fillAttributeViewKeyValues(attrView, ret)

	// 批量获取块属性以提升性能
	var ialIDs []string
	for _, row := range ret.Rows {
		blockVal := row.GetBlockValue()
		if nil != blockVal && !blockVal.IsDetached {
			ialIDs = append(ialIDs, blockVal.Block.ID)
		}
	}
	ials := BatchGetBlockAttrs(ialIDs)

	// 渲染自动生成的字段值,比如关联、汇总、创建时间和更新时间
	fillAttributeViewAutoGeneratedValues(attrView, ret, ials, depth, cachedAttrViews, renderContext)

	if !deferTemplateValues {
		// 最后渲染模板字段,这样模板就可以使用汇总、关联、创建时间和更新时间的值了
		fillAttributeViewTemplateValues(attrView, view, ret, ials, renderContext)
	}

	filterByQuery(query, ret)
	manualSort(view, ret)
	return
}