Something went wrong. Try again.
A privacy-first, self-hosted, fully open source personal knowledge management software, written in typescript and golang. (PERSONAL FORK)
Something went wrong. Try again.
Go
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477// SiYuan - Refactor your thinking// Copyright (c) 2020-present, b3log.org//// This program is free software: you can redistribute it and/or modify// it under the terms of the GNU Affero General Public License as published by// the Free Software Foundation, either version 3 of the License, or// (at your option) any later version.//// This program is distributed in the hope that it will be useful,// but WITHOUT ANY WARRANTY; without even the implied warranty of// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the// GNU Affero General Public License for more details.//// You should have received a copy of the GNU Affero General Public License// along with this program. If not, see <https://www.gnu.org/licenses/>.
package av
import ( "bytes" "sort" "strings" "time"
"github.com/siyuan-note/siyuan/kernel/util")
// ViewSort 描述了视图排序规则的结构。type ViewSort struct { Column string `json:"column"` // 字段（列）ID Order SortOrder `json:"order"` // 排序顺序}
type SortOrder string
const ( SortOrderAsc SortOrder = "ASC" SortOrderDesc SortOrder = "DESC")
func Sort(viewable Viewable, attrView *AttributeView) { collection := viewable.(Collection) sorts := collection.GetSorts() if 1 > len(sorts) { return }
type FieldIndexSort struct { Index int Order SortOrder }
var fieldIndexSorts []*FieldIndexSort for _, s := range sorts { for i, c := range collection.GetFields() { if c.GetID() == s.Column { fieldIndexSorts = append(fieldIndexSorts, &FieldIndexSort{Index: i, Order: s.Order}) break } } }
items := collection.GetItems() editedValItems := map[string]bool{} for i, item := range items { for _, fieldIndexSort := range fieldIndexSorts { val := items[i].GetValues()[fieldIndexSort.Index] if KeyTypeCheckbox == val.Type { if block := item.GetBlockValue(); nil != block && block.IsEdited() { // 如果主键编辑过，则复选框也算作编辑过，参与排序 https://github.com/siyuan-note/siyuan/issues/11016 editedValItems[item.GetID()] = true break } }
if val.IsEdited() { // 如果该项目某字段的值已经编辑过，则该项目可参与排序 editedValItems[item.GetID()] = true break } } }
// 将未编辑的项目和已编辑的项目分开排序 var uneditedItems, editedItems []Item for _, item := range items { if _, ok := editedValItems[item.GetID()]; ok { editedItems = append(editedItems, item) } else { uneditedItems = append(uneditedItems, item) } }
sort.Slice(uneditedItems, func(i, j int) bool { val1 := uneditedItems[i].GetBlockValue() if nil == val1 { return true } val2 := uneditedItems[j].GetBlockValue() if nil == val2 { return false } return val1.CreatedAt < val2.CreatedAt })
sort.Slice(editedItems, func(i, j int) bool { sorted := true for _, fieldIndexSort := range fieldIndexSorts { val1 := editedItems[i].GetValues()[fieldIndexSort.Index] val2 := editedItems[j].GetValues()[fieldIndexSort.Index] if nil == val1 || val1.IsEmpty() { if nil != val2 && !val2.IsEmpty() { return false } sorted = false continue } else { if nil == val2 || val2.IsEmpty() { return true } }
result := val1.Compare(val2, attrView) if 0 == result { sorted = false continue } sorted = true
if fieldIndexSort.Order == SortOrderAsc { return 0 > result } return 0 < result }
if !sorted { key1 := editedItems[i].GetBlockValue() if nil == key1 { return false } key2 := editedItems[j].GetBlockValue() if nil == key2 { return false } return key1.CreatedAt < key2.CreatedAt } return false })
// 将包含未编辑的项目放在最后 collection.SetItems(append(editedItems, uneditedItems...)) if 1 > len(collection.GetItems()) { collection.SetItems([]Item{}) }}
func (value *Value) Compare(other *Value, attrView *AttributeView) int { switch value.Type { case KeyTypeBlock: if nil != value.Block && nil != other.Block { if 0 == strings.Compare(value.Block.Content, other.Block.Content) { return 0 }
if util.PinYinCompare(value.Block.Content, other.Block.Content) { return -1 } return 1 } case KeyTypeText: if nil != value.Text && nil != other.Text { if "" == value.Text.Content { if "" == other.Text.Content { return 0 } return 1 } else if "" == other.Text.Content { return -1 }
if 0 == strings.Compare(value.Text.Content, other.Text.Content) { return 0 }
if util.EmojiPinYinCompare(value.Text.Content, other.Text.Content) { return -1 } return 1 } case KeyTypeNumber: if nil != value.Number && nil != other.Number { if value.Number.IsNotEmpty { if !other.Number.IsNotEmpty { return -1 }
if value.Number.Content > other.Number.Content { return 1 } if value.Number.Content < other.Number.Content { return -1 } return 0 } else { if !other.Number.IsNotEmpty { return 1 } return 0 } } case KeyTypeDate: if nil != value.Date && nil != other.Date { if value.Date.IsNotEmpty { if !other.Date.IsNotEmpty { return -1 }
valueContent := value.Date.Content otherContent := other.Date.Content
if value.Date.IsNotTime { v := time.UnixMilli(valueContent) valueContent = time.Date(v.Year(), v.Month(), v.Day(), 0, 0, 0, 0, time.Local).UnixMilli() } if other.Date.IsNotTime { o := time.UnixMilli(otherContent) otherContent = time.Date(o.Year(), o.Month(), o.Day(), 0, 0, 0, 0, time.Local).UnixMilli() }
if valueContent > otherContent { return 1 } if valueContent < otherContent { return -1 } return 0 } else { if !other.Date.IsNotEmpty { return 1 } return 0 } } case KeyTypeCreated: if nil != value.Created && nil != other.Created { if value.Created.Content > other.Created.Content { return 1 } if value.Created.Content < other.Created.Content { return -1 } return 0 } case KeyTypeUpdated: if nil != value.Updated && nil != other.Updated { if value.Updated.Content > other.Updated.Content { return 1 } if value.Updated.Content < other.Updated.Content { return -1 } return 0 } case KeyTypeSelect, KeyTypeMSelect: if nil != value.MSelect && nil != other.MSelect { // 按设置的选项顺序排序 key, _ := attrView.GetKey(value.KeyID) optionSort := map[string]int{} if nil != key { for i, op := range key.Options { optionSort[op.Name] = i } }
vLen := len(value.MSelect) oLen := len(other.MSelect) if vLen <= oLen { for i := 0; i < vLen; i++ { v := value.MSelect[i].Content o := other.MSelect[i].Content vSort := optionSort[v] oSort := optionSort[o] if vSort != oSort { return vSort - oSort } s := strings.Compare(v, o) if 0 != s { return s } } return 0 } else { for i := 0; i < oLen; i++ { v := value.MSelect[i].Content o := other.MSelect[i].Content vSort := optionSort[v] oSort := optionSort[o] if vSort != oSort { return vSort - oSort } s := strings.Compare(v, o) if 0 != s { return s } } return 0 } } case KeyTypeURL: if nil != value.URL && nil != other.URL { if "" == value.URL.Content { if "" == other.URL.Content { return 0 } return 1 } else if "" == other.URL.Content { return -1 } return strings.Compare(value.URL.Content, other.URL.Content) } case KeyTypeEmail: if nil != value.Email && nil != other.Email { if "" == value.Email.Content { if "" == other.Email.Content { return 0 } return 1 } else if "" == other.Email.Content { return -1 } return strings.Compare(value.Email.Content, other.Email.Content) } case KeyTypePhone: if nil != value.Phone && nil != other.Phone { if "" == value.Phone.Content { if "" == other.Phone.Content { return 0 } return 1 } else if "" == other.Phone.Content { return -1 } return strings.Compare(value.Phone.Content, other.Phone.Content) } case KeyTypeMAsset: if nil != value.MAsset && nil != other.MAsset { var v1 string for _, v := range value.MAsset { v1 += v.Content } var v2 string for _, v := range other.MAsset { v2 += v.Content }
if 0 == strings.Compare(v1, v2) { return 0 }
if util.EmojiPinYinCompare(v1, v2) { return -1 } return 1 } case KeyTypeTemplate: if nil != value.Template && nil != other.Template { v1, ok1 := util.Convert2Float(value.Template.Content) v2, ok2 := util.Convert2Float(other.Template.Content) if ok1 && ok2 { if v1 > v2 { return 1 } if v1 < v2 { return -1 } return 0 }
if 0 == strings.Compare(value.Template.Content, other.Template.Content) { return 0 }
if util.EmojiPinYinCompare(value.Template.Content, other.Template.Content) { return -1 } return 1 } case KeyTypeCheckbox: if nil != value.Checkbox && nil != other.Checkbox { if value.Checkbox.Checked && !other.Checkbox.Checked { return 1 } if !value.Checkbox.Checked && other.Checkbox.Checked { return -1 } return 0 } case KeyTypeRelation: if nil != value.Relation && nil != other.Relation { if 0 < len(value.Relation.Contents) && 0 < len(other.Relation.Contents) && KeyTypeNumber == value.Relation.Contents[0].Type && KeyTypeNumber == other.Relation.Contents[0].Type { v1, ok1 := util.Convert2Float(value.Relation.Contents[0].String(false)) v2, ok2 := util.Convert2Float(other.Relation.Contents[0].String(false)) if ok1 && ok2 { if v1 > v2 { return 1 } if v1 < v2 { return -1 } return 0 } }
vContentBuf := bytes.Buffer{} for _, c := range value.Relation.Contents { vContentBuf.WriteString(c.String(true)) vContentBuf.WriteByte(' ') } vContent := strings.TrimSpace(vContentBuf.String()) oContentBuf := bytes.Buffer{} for _, c := range other.Relation.Contents { oContentBuf.WriteString(c.String(true)) oContentBuf.WriteByte(' ') } oContent := strings.TrimSpace(oContentBuf.String())
if 0 == strings.Compare(vContent, oContent) { return 0 }
if util.EmojiPinYinCompare(vContent, oContent) { return -1 } return 1 } case KeyTypeRollup: if nil != value.Rollup && nil != other.Rollup { if 0 < len(value.Rollup.Contents) && 0 < len(other.Rollup.Contents) && KeyTypeNumber == value.Rollup.Contents[0].Type && KeyTypeNumber == other.Rollup.Contents[0].Type { v1, ok1 := util.Convert2Float(value.Rollup.Contents[0].String(false)) v2, ok2 := util.Convert2Float(other.Rollup.Contents[0].String(false)) if ok1 && ok2 { if v1 > v2 { return 1 } if v1 < v2 { return -1 } return 0 } }
vContentBuf := bytes.Buffer{} for _, c := range value.Rollup.Contents { vContentBuf.WriteString(c.String(true)) vContentBuf.WriteByte(' ') } vContent := strings.TrimSpace(vContentBuf.String()) oContentBuf := bytes.Buffer{} for _, c := range other.Rollup.Contents { oContentBuf.WriteString(c.String(true)) oContentBuf.WriteByte(' ') } oContent := strings.TrimSpace(oContentBuf.String())
if 0 == strings.Compare(vContent, oContent) { return 0 }
if util.EmojiPinYinCompare(vContent, oContent) { return -1 } return 1 } } return 0}