MessageStore.java

/*
 * Copyright © 2023-2025 The CTAN Team and individual licenses
 *
 * This file is distributed under the 3-clause BSD license.
 * See file LICENSE for details.
 */
package org.ctan.site.stores;

import java.sql.Date;
import java.time.Instant;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

import org.ctan.site.domain.site.Message;
import org.ctan.site.stores.base.AbstractStore;
import org.hibernate.SessionFactory;

import jakarta.persistence.criteria.CriteriaBuilder;
import jakarta.persistence.criteria.CriteriaQuery;
import jakarta.persistence.criteria.Root;

/**
 * The class <code>MessageStore</code> contains the repository for system
 * messages.
 *
 * @author <a href="mailto:gene@ctan.org">Gerd Neugebauer</a>
 */
public class MessageStore extends AbstractStore<Message> {

    /**
     * This is the constructor for the <code>MessageStore</code>.
     *
     * @param sessionFactory the session factory
     */
    public MessageStore(SessionFactory sessionFactory) {

        super(sessionFactory);
    }

    /**
     * The method <code>findAllCurent</code> provides means to retrieve the
     * currently valid messages.
     *
     * @return the list of current messages
     */
    public List<Message> findAllCurrent() {

        var now = Date.from(Instant.now());
        var query = criteriaQuery();
        CriteriaBuilder cb = currentSession().getCriteriaBuilder();
        Root<Message> mess = query.from(Message.class);
        query.where(
            cb.and(
                cb.lessThanOrEqualTo(mess.get("validFrom"), now),
                cb.greaterThanOrEqualTo(mess.get("validTo"), now)))
            .orderBy(cb.asc(mess.get("validFrom")));
        return list(query);
    }

    /**
     * {@inheritDoc}
     *
     * @see org.ctan.site.stores.base.AbstractStore#listQuery(java.lang.String,
     *     jakarta.persistence.criteria.CriteriaBuilder,
     *     jakarta.persistence.criteria.CriteriaQuery)
     */
    @Override
    protected Root<Message> listQuery(String term, CriteriaBuilder cb,
        CriteriaQuery<Message> query) {

        Root<Message> root = query.from(Message.class);
        if (term != null && !term.isBlank()) {
            var t = "%" + term.toLowerCase() + "%";
            query.where(cb.like(cb.lower(root.get("title_en")), t));
        }
        return root;
    }

    /**
     * {@inheritDoc}
     *
     * @see org.ctan.site.stores.base.AbstractStore#map(java.util.List)
     */
    @Override
    protected List<Map<String, Object>> map(List<Message> list) {

        return list.stream()
            .map(it -> it.toMap())
            .collect(Collectors.toList());
    }
}