Исходный код вики HRlink. Новости об обновлениях
Последние авторы
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{velocity}} | ||
| 2 | ## ===== Настройки ===== | ||
| 3 | #set($PERPAGE = 10) | ||
| 4 | |||
| 5 | ## Родитель для постов — текущая страница категории | ||
| 6 | #set($PARENT = $doc.fullName) | ||
| 7 | |||
| 8 | ## Пагинация | ||
| 9 | #set($p = $request.get('p')) #if(!$p) #set($p = 1) #end | ||
| 10 | #set($p = $numbertool.toInteger($p)) #if($p < 1) #set($p = 1) #end | ||
| 11 | #set($offset = ($p - 1) * $PERPAGE) | ||
| 12 | |||
| 13 | ## Сколько постов у этой категории (берём только Blog.BlogPostClass) | ||
| 14 | #set($total = $services.query.hql( | ||
| 15 | "select count(d.fullName) " + | ||
| 16 | "from XWikiDocument d, BaseObject o " + | ||
| 17 | "where o.name = d.fullName and o.className = 'Blog.BlogPostClass' " + | ||
| 18 | "and d.parent = :parent" | ||
| 19 | ).bindValue("parent", $PARENT).execute().get(0)) | ||
| 20 | |||
| 21 | ## Выборка постов текущей страницы | ||
| 22 | #set($rows = $services.query.hql( | ||
| 23 | "select d.fullName " + | ||
| 24 | "from XWikiDocument d, BaseObject o " + | ||
| 25 | "where o.name = d.fullName and o.className = 'Blog.BlogPostClass' " + | ||
| 26 | "and d.parent = :parent " + | ||
| 27 | "order by d.date desc" | ||
| 28 | ).bindValue("parent", $PARENT).setLimit($PERPAGE).setOffset($offset).execute()) | ||
| 29 | |||
| 30 | ## Если вдруг посты лежат глубже (под-подкатегории) — делаем мягкий фоллбек по префиксу | ||
| 31 | #if($total == 0) | ||
| 32 | #set($full = $doc.fullName) | ||
| 33 | #set($lastDot = $full.lastIndexOf('.')) | ||
| 34 | #set($PREFIX = $full.substring(0, $lastDot) + ".") | ||
| 35 | #set($total = $services.query.hql( | ||
| 36 | "select count(d.fullName) from XWikiDocument d where d.fullName like :prefix" | ||
| 37 | ).bindValue("prefix", $PREFIX + "%").execute().get(0)) | ||
| 38 | #set($rows = $services.query.hql( | ||
| 39 | "select d.fullName from XWikiDocument d where d.fullName like :prefix order by d.date desc" | ||
| 40 | ).bindValue("prefix", $PREFIX + "%").setLimit($PERPAGE).setOffset($offset).execute()) | ||
| 41 | #end | ||
| 42 | |||
| 43 | ## Рендер ленты | ||
| 44 | #foreach($fn in $rows) | ||
| 45 | #set($d = $xwiki.getDocument($fn)) | ||
| 46 | <article style="margin:14px 0; padding-bottom:10px; border-bottom:1px solid #e5e7eb"> | ||
| 47 | <div style="color:#6b7280; font-size:.9em">$datetool.format('dd MMM yyyy', $d.date)</div> | ||
| 48 | <h3 style="margin:.2rem 0"><a href="$d.getURL('view')">$escapetool.html($d.displayTitle)</a></h3> | ||
| 49 | <div>$!d.getPlainContent().substring(0,300)…</div> | ||
| 50 | </article> | ||
| 51 | #end | ||
| 52 | |||
| 53 | ## Пагинация | ||
| 54 | #if($total > $PERPAGE) | ||
| 55 | #set($pages = ($total + $PERPAGE - 1) / $PERPAGE) | ||
| 56 | #set($base = $doc.getURL('view')) | ||
| 57 | #set($prev = $math.sub($p, 1)) | ||
| 58 | #set($next = $math.add($p, 1)) | ||
| 59 | <nav style="margin-top:1em; display:flex; gap:1em; align-items:center"> | ||
| 60 | #if($p > 1)<a href="$base?p=$prev">← Назад</a>#else<span style="opacity:.5">← Назад</span>#end | ||
| 61 | <span>Стр. $p / $pages</span> | ||
| 62 | #if($p < $pages)<a href="$base?p=$next">Далее →</a>#else<span style="opacity:.5">Далее →</span>#end | ||
| 63 | </nav> | ||
| 64 | #end | ||
| 65 | {{/velocity}} |