/* * eGov suite of products aim to improve the internal efficiency,transparency, * accountability and the service delivery of the government organizations. * * Copyright (C) <2015> eGovernments Foundation * * The updated version of eGov suite of products as by eGovernments Foundation * is available at http://www.egovernments.org * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * 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 General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see http://www.gnu.org/licenses/ or * http://www.gnu.org/licenses/gpl.html . * * In addition to the terms of the GPL license to be adhered to in using this * program, the following additional terms are to be complied with: * * 1) All versions of this program, verbatim or modified must carry this * Legal Notice. * * 2) Any misrepresentation of the origin of the material is prohibited. It * is required that all modified versions of this material be marked in * reasonable ways as different from the original version. * * 3) This license does not grant any rights to any user of the program * with regards to rights under trademark law for use of the trade names * or trademarks of eGovernments Foundation. * * In case of any queries, you can reach eGovernments Foundation at contact@egovernments.org. */ package org.egov.lcms.masters.service; import java.util.ArrayList; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.TypedQuery; import javax.persistence.criteria.CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery; import javax.persistence.criteria.Predicate; import javax.persistence.criteria.Root; import javax.persistence.metamodel.Metamodel; import org.egov.lcms.masters.entity.InterimOrder; import org.egov.lcms.masters.repository.InterimOrderRepository; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Sort; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @Service @Transactional(readOnly = true) public class InterimOrderService { private final InterimOrderRepository interimOrderRepository; @PersistenceContext private EntityManager entityManager; @Autowired public InterimOrderService(final InterimOrderRepository interimOrderRepository) { this.interimOrderRepository = interimOrderRepository; } @Transactional public InterimOrder create(final InterimOrder interimOrder) { return interimOrderRepository.save(interimOrder); } @Transactional public InterimOrder update(final InterimOrder interimOrder) { return interimOrderRepository.save(interimOrder); } public List<InterimOrder> findAll() { return interimOrderRepository.findAll(new Sort(Sort.Direction.ASC, "interimOrderType")); } public InterimOrder findByCode(final String code) { return interimOrderRepository.findByCode(code); } public InterimOrder findOne(final Long id) { return interimOrderRepository.findOne(id); } public List<InterimOrder> getActiveInterimOrder() { return interimOrderRepository.findByActiveTrueOrderByInterimOrderTypeAsc(); } public List<InterimOrder> search(final InterimOrder interimOrder) { final CriteriaBuilder cb = entityManager.getCriteriaBuilder(); final CriteriaQuery<InterimOrder> createQuery = cb.createQuery(InterimOrder.class); final Root<InterimOrder> interimorder = createQuery.from(InterimOrder.class); createQuery.select(interimorder); final Metamodel m = entityManager.getMetamodel(); final javax.persistence.metamodel.EntityType<InterimOrder> InterimOrder = m.entity(InterimOrder.class); final List<InterimOrder> resultList; final List<Predicate> predicates = new ArrayList<Predicate>(); if (interimOrder.getInterimOrderType() == null && interimOrder.getCode() == null && interimOrder.getActive() == null) resultList = findAll(); else { if (interimOrder.getInterimOrderType() != null) { final String interimOrderType = "%" + interimOrder.getInterimOrderType().toLowerCase() + "%"; predicates.add(cb.isNotNull(interimorder.get("interimOrderType"))); predicates.add(cb.like( cb.lower(interimorder .get(InterimOrder.getDeclaredSingularAttribute("interimOrderType", String.class))), interimOrderType)); } if (interimOrder.getCode() != null) { final String code = "%" + interimOrder.getCode().toLowerCase() + "%"; predicates.add(cb.isNotNull(interimorder.get("code"))); predicates.add(cb.like( cb.lower(interimorder.get(InterimOrder.getDeclaredSingularAttribute("code", String.class))), code)); } if (interimOrder.getActive() != null) if (interimOrder.getActive()) predicates.add(cb.equal( interimorder.get(InterimOrder.getDeclaredSingularAttribute("active", Boolean.class)), true)); else predicates.add(cb.equal( interimorder.get(InterimOrder.getDeclaredSingularAttribute("active", Boolean.class)), false)); createQuery.where(predicates.toArray(new Predicate[] {})); final TypedQuery<InterimOrder> query = entityManager.createQuery(createQuery); resultList = query.getResultList(); } return resultList; } }