net.anotheria.portalkit.services.approval.persistence.ApprovalPersistenceServiceImpl Maven / Gradle / Ivy

Go to download
package net.anotheria.portalkit.services.approval.persistence;

import java.util.List;

import net.anotheria.moskito.aop.annotation.Monitor;
import net.anotheria.portalkit.services.common.AccountId;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import jakarta.persistence.EntityManager;
import jakarta.persistence.PersistenceContext;
import jakarta.persistence.Query;
import jakarta.persistence.TypedQuery;

/**
 * JDBC implementation of ApprovalPersistenceService.
 * 
 * @author Vlad Lukjanenko
 */
@Service
@Transactional
@Monitor(subsystem = "approval", category = "portalkit-service")
public class ApprovalPersistenceServiceImpl implements ApprovalPersistenceService {

	@PersistenceContext
	private EntityManager entityManager;

	@Override
	public TicketDO createTicket(TicketDO newTicket) throws ApprovalPersistenceServiceException {
		entityManager.persist(newTicket);
		return newTicket;
	}

	@Override
	public TicketDO getTicketById(long ticketId) throws ApprovalPersistenceServiceException {

		TypedQuery q = entityManager.createNamedQuery(TicketDO.GET_TICKET_BY_ID, TicketDO.class);
		q.setParameter("ticketId", ticketId);

		List tickets = q.getResultList();

		if (tickets == null || tickets.isEmpty()) {
			throw new ApprovalPersistenceServiceException("Ticket not found");
		}

		return tickets.get(0);
	}

	@Override
	public TicketDO getTicketByReferenceId(String referenceId) throws ApprovalPersistenceServiceException {
		TypedQuery q = entityManager.createNamedQuery(TicketDO.GET_TICKET_BY_REFERENCE_ID, TicketDO.class);
		q.setParameter("referenceId", referenceId);

		List tickets = q.getResultList();

		if (tickets == null || tickets.isEmpty()) {
			throw new ApprovalPersistenceServiceException("Ticket not found");
		}

		return tickets.get(0);
	}

	@Override
	public void deleteTicketByReferenceId(String referenceId) throws ApprovalPersistenceServiceException {

		Query query = entityManager.createNamedQuery(TicketDO.DELETE_TICKET_BY_REFERENCE_ID)
				.setParameter("referenceId", referenceId);

		query.executeUpdate();
	}

	@Override
	public void updateTicket(TicketDO ticket) throws ApprovalPersistenceServiceException {
		entityManager.merge(ticket);
	}

	@Override
	public void deleteTicket(long ticketId) throws ApprovalPersistenceServiceException {

		Query query = entityManager.createNamedQuery(TicketDO.DELETE_TICKET_BY_ID)
				.setParameter("ticketId", ticketId);

		query.executeUpdate();
	}

	@Override
	public List getTickets(long referenceType, String ticketType, int limit) throws ApprovalPersistenceServiceException {
		TypedQuery q = entityManager.createNamedQuery(TicketDO.GET_TICKETS_BY_TYPE, TicketDO.class);
		q.setParameter("referenceType", referenceType);
		q.setParameter("ticketType", ticketType);
		if (limit > 0)
			q.setMaxResults(limit);

		List tickets = q.getResultList();

		if (tickets == null) {
			throw new ApprovalPersistenceServiceException("Tickets not found");
		}

		return tickets;
	}

	@Override
	public long getTicketsCount(long referenceType, String ticketType) throws ApprovalPersistenceServiceException {
		String queryStr = "select count(t.ticketId) from TicketDO t where t.referenceType = :referenceType and t.ticketType = :ticketType";
		TypedQuery q = entityManager.createQuery(queryStr, Long.class)
				.setParameter("referenceType", referenceType)
				.setParameter("ticketType", ticketType);

		Long ret = q.getSingleResult();
		if (ret == null)
			throw new ApprovalPersistenceServiceException("Count is null");

		return ret;
	}

	@Override
	public List getTickets(long referenceType, String ticketType, String locale) throws ApprovalPersistenceServiceException {
		TypedQuery q = entityManager.createNamedQuery(TicketDO.GET_TICKETS_BY_TYPE_AND_LOCALE, TicketDO.class);
		q.setParameter("referenceType", referenceType);
		q.setParameter("ticketType", ticketType);
		q.setParameter("locale", locale);

		List tickets = q.getResultList();

		if (tickets == null) {
			throw new ApprovalPersistenceServiceException("Tickets not found");
		}

		return tickets;
	}

	@Override
	public List getTickets(String locale) throws ApprovalPersistenceServiceException {

		TypedQuery q = entityManager.createNamedQuery(TicketDO.GET_TICKETS_BY_LOCALE, TicketDO.class);
		q.setParameter("locale", locale);

		List tickets = q.getResultList();

		if (tickets == null) {
			throw new ApprovalPersistenceServiceException("Tickets not found");
		}

		return tickets;
	}

	@Override
	public long getTicketsCount() throws ApprovalPersistenceServiceException {
		String queryStr = "select count(t.ticketId) from TicketDO t ";
		TypedQuery q = entityManager.createQuery(queryStr, Long.class);

		Long ret = q.getSingleResult();
		if (ret == null)
			throw new ApprovalPersistenceServiceException("Count is null");

		return ret;
	}

	@Override
	public List getTicketsByAccountId(AccountId accountId) throws ApprovalPersistenceServiceException {
		TypedQuery q = entityManager.createNamedQuery(TicketDO.GET_TICKETS_BY_ACCOUNT_ID, TicketDO.class);
		q.setParameter("accountId", accountId.getInternalId());
		List tickets = q.getResultList();
		if (tickets == null) {
			throw new ApprovalPersistenceServiceException(String.format("Tickets for %s not found", accountId.getInternalId()));
		}
		return tickets;
	}

	@Override
	public void deleteTicketsByAccountId(AccountId accountId) throws ApprovalPersistenceServiceException {
		Query query = entityManager.createNamedQuery(TicketDO.DELETE_TICKETS_BY_ACCOUNT_ID)
				.setParameter("accountId", accountId.getInternalId());
		query.executeUpdate();
	}
}