174 lines
8.2 KiB
Plaintext
174 lines
8.2 KiB
Plaintext
package templates
|
|
|
|
import (
|
|
"fmt"
|
|
"slices"
|
|
|
|
"gitea.zokki.net/zokki/uni/web43-diary/context"
|
|
"gitea.zokki.net/zokki/uni/web43-diary/internal/database"
|
|
"gitea.zokki.net/zokki/uni/web43-diary/internal/models"
|
|
"gitea.zokki.net/zokki/uni/web43-diary/internal/session"
|
|
"gitea.zokki.net/zokki/uni/web43-diary/web/templates/shared"
|
|
)
|
|
|
|
templ Index(context *context.Context) {
|
|
{{
|
|
query := context.Request.URL.Query()
|
|
queryOwners := query["owners"]
|
|
queryTags := query["tags"]
|
|
|
|
whereGroup := &database.WhereGroup{Logic: database.GetLogicFromString(query.Get("operator"))}
|
|
diariesQueryBuilder := database.NewQueryBuilder(&models.Diary{}).Distinct().Select("`diary`.*")
|
|
|
|
if len(queryOwners) > 0 {
|
|
whereGroup.AddCondition(&database.QueryCondition{Row: "OwnerID", Operator: database.In, Value: queryOwners})
|
|
}
|
|
if fromDate := query.Get("fromDate"); fromDate != "" {
|
|
whereGroup.AddCondition(&database.QueryCondition{Row: "CreationTime", Operator: database.GreaterOrEqual, Value: fromDate + " 00:00"})
|
|
}
|
|
if toDate := query.Get("toDate"); toDate != "" {
|
|
whereGroup.AddCondition(&database.QueryCondition{Row: "CreationTime", Operator: database.LessOrEqual, Value: toDate + " 23:59"})
|
|
}
|
|
if title := query.Get("title"); title != "" {
|
|
whereGroup.AddCondition(&database.QueryCondition{Row: "Title", Operator: database.Like, Value: "%" + title + "%"})
|
|
}
|
|
|
|
if len(queryTags) > 0 {
|
|
diariesQueryBuilder.Join(database.InnerJoin, &models.DiaryTags{}, "`diary`.`ID` = `diary_tags`.`DiaryId`")
|
|
|
|
switch database.GetLogicFromString(query.Get("tagsOperator")) {
|
|
case database.AND:
|
|
havingString, havingValues := database.WhereGroups{whereGroup}.Build(false)
|
|
havingValues = append([]interface{}{len(queryTags)}, havingValues...)
|
|
|
|
if havingString != "" {
|
|
havingString = string(whereGroup.Logic) + " " + havingString
|
|
}
|
|
diariesQueryBuilder.
|
|
GroupBy("`diary`.`ID`").
|
|
Having(fmt.Sprintf("COUNT(DISTINCT `diary_tags`.`TagID`) = ? %s", havingString), havingValues...)
|
|
fallthrough
|
|
default:
|
|
whereGroup.AddCondition(&database.QueryCondition{Row: "`diary_tags`.`TagID`", Operator: database.In, Value: queryTags})
|
|
}
|
|
}
|
|
|
|
diaries, err := database.GetAllWhere(context, diariesQueryBuilder.WhereGroup(whereGroup))
|
|
if err != nil {
|
|
return err
|
|
}
|
|
users, err := database.GetAll(context, &models.User{})
|
|
if err != nil {
|
|
return err
|
|
}
|
|
tags, err := database.GetAll(context, &models.Tag{})
|
|
if err != nil {
|
|
return err
|
|
}
|
|
}}
|
|
@shared.Layout(context) {
|
|
<div class="e2 h-full-grid grid-flow-col gap-8 p-6">
|
|
<div>
|
|
<h2>Filter</h2>
|
|
<form method="GET" id="filter-form" class="flex flex-col gap-4 relative" enctype="application/x-www-form-urlencoded">
|
|
/* owner/user */
|
|
<div>
|
|
<label for="owners-input" class="text-sm font-medium">Ersteller</label>
|
|
<input data-dropdown-toggle="users-dropdown" id="owners-input" class="outline-gray-400 rounded-lg w-full p-2.5 text-ellipsis" readonly/>
|
|
</div>
|
|
/* owner/user dropdown */
|
|
<div id="users-dropdown" class="z-10 hidden rounded-lg shadow w-full bg-surface-container-highest">
|
|
<ul class="max-h-64 overflow-y-auto text-sm">
|
|
for _, user := range users {
|
|
<li>
|
|
<label for={ "user-" + user.IDString() } class="flex items-center gap-2 p-2 rounded hover:bg-dark-650">
|
|
<input id={ "user-" + user.IDString() } type="checkbox" value={ user.IDString() } name="owners" class="w-4 h-4" checked?={ slices.Contains(queryOwners, user.IDString()) }/>
|
|
<span class="w-full text-sm font-medium line-clamp-2">{ user.Username }</span>
|
|
</label>
|
|
</li>
|
|
}
|
|
</ul>
|
|
</div>
|
|
/* creation date */
|
|
<div class="flex gap-4 items-center">
|
|
<div>
|
|
<label for="from-date" class="text-sm font-medium">Erstelldatum von</label>
|
|
<input type="date" id="from-date" name="fromDate" class="outline-gray-400 rounded-lg w-full p-2.5 text-ellipsis" value={ query.Get("fromDate") }/>
|
|
</div>
|
|
<div>
|
|
<label for="to-date" class="text-sm font-medium">Erstelldatum bis</label>
|
|
<input type="date" id="to-date" name="toDate" class="outline-gray-400 rounded-lg w-full p-2.5 text-ellipsis" value={ query.Get("toDate") }/>
|
|
</div>
|
|
</div>
|
|
/* title */
|
|
<div>
|
|
<label for="title-input" class="text-sm font-medium">Title</label>
|
|
<input type="text" id="title-input" name="title" class="outline-gray-400 rounded-lg w-full p-2.5 text-ellipsis" value={ query.Get("title") }/>
|
|
</div>
|
|
/* tag */
|
|
<div>
|
|
<label for="tags-input" class="text-sm font-medium">Tags</label>
|
|
<div class="flex gap-2">
|
|
<input data-dropdown-toggle="tags-dropdown" id="tags-input" class="outline-gray-400 rounded-lg w-full p-2.5 text-ellipsis" readonly/>
|
|
<select data-tooltip-target="tags-operator-tooltip" name="tagsOperator" class="outline-gray-400 rounded-lg w-fit p-2.5">
|
|
<option value="and" selected?={ query.Get("tagsOperator") == "and" }>Alle</option>
|
|
<option value="or" selected?={ query.Get("tagsOperator") == "or" }>Einer</option>
|
|
</select>
|
|
<div id="tags-operator-tooltip" role="tooltip" class="absolute z-10 invisible inline-block px-3 py-2 text-sm transition-opacity duration-300 bg-surface-variant rounded-lg shadow-sm opacity-0 tooltip">
|
|
Sollen alle ausgewählten Tags im gesuchten Tagebucheintrag sein oder nur mindestens ein Tag
|
|
</div>
|
|
</div>
|
|
</div>
|
|
/* tag dropdown */
|
|
<div id="tags-dropdown" class="z-10 hidden rounded-lg shadow w-full bg-surface-container-highest">
|
|
<ul class="max-h-64 overflow-y-auto text-sm">
|
|
for _, tag := range tags {
|
|
<li>
|
|
<label for={ "tag-" + tag.IDString() } class="flex items-center gap-2 p-2 rounded hover:bg-dark-650">
|
|
<input id={ "tag-" + tag.IDString() } type="checkbox" value={ tag.IDString() } name="tags" class="w-4 h-4" checked?={ slices.Contains(queryTags, tag.IDString()) }/>
|
|
<span class="w-full text-sm font-medium line-clamp-2">{ tag.Title }</span>
|
|
</label>
|
|
</li>
|
|
}
|
|
</ul>
|
|
</div>
|
|
<div class="flex gap-2">
|
|
<button class="text-on-bg bg-secondary hover:bg-secondary-650 font-medium rounded-lg text-sm px-5 py-2.5 w-full">Filter anwenden</button>
|
|
<select data-tooltip-target="operator-tooltip" name="operator" class="outline-gray-400 rounded-lg w-fit p-2.5">
|
|
<option value="and" selected?={ query.Get("operator") == "and" }>Und</option>
|
|
<option value="or" selected?={ query.Get("operator") == "or" }>Oder</option>
|
|
</select>
|
|
<div id="operator-tooltip" role="tooltip" class="absolute z-10 invisible inline-block px-3 py-2 text-sm transition-opacity duration-300 bg-surface-variant rounded-lg shadow-sm opacity-0 tooltip">
|
|
Sollen alle Filter auf den gesuchten Tagebucheintrag zutreffen oder nur mindestens ein Filter
|
|
</div>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
<div class="h-full-grid">
|
|
<div class="flex">
|
|
<h2>Tagebucheinträge</h2>
|
|
if user := session.GetSession(context).GetUser(); user.ID > 0 {
|
|
<a href="/diary" class="text-on-bg bg-primary hover:bg-primary-650 font-medium rounded-lg text-sm px-5 py-2.5 h-fit ml-auto">Erfassen</a>
|
|
}
|
|
</div>
|
|
<div class="h-full-grid overflow-auto grid-cols-3 gap-4">
|
|
for _, diary := range diaries {
|
|
<a href={ templ.URL(fmt.Sprintf("/diary/%d", diary.ID)) } class="overflow-hidden relative p-6 border-2 border-outline rounded-lg shadow bg-surface-container-highest hover:bg-surface-container-highest-850">
|
|
/* Just a dummy to make the anchor clickable after adding the iframe */
|
|
<div class="absolute inset-0"></div>
|
|
<h4 class="mb-1 line-clamp-2">{ diary.Title }</h4>
|
|
<div class="text-sm text-bright/75 w-full text-right mb-2 line-clamp-2">am { diary.CreationTime.Format("02.01.2006 15:04") }Uhr von { diary.Owner.Username }</div>
|
|
<div class="flex flex-wrap gap-2">
|
|
for _, tag := range diary.Tags {
|
|
<span class="line-clamp-1 w-fit bg-dark-750 text-bright/75 text-xs font-medium px-2.5 py-0.5 rounded">{ tag.Title }</span>
|
|
}
|
|
</div>
|
|
<iframe allowtransparency="true" class="preview size-full max-w-3xl bg-transparent" data-markdown={ diary.ShortContent() }></iframe>
|
|
</a>
|
|
}
|
|
</div>
|
|
</div>
|
|
</div>
|
|
}
|
|
}
|