com.sample.serviceImpl.DonarsServiceImpl.java Source code

Introduction

Here is the source code for com.sample.serviceImpl.DonarsServiceImpl.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.sample.serviceImpl;

import com.sample.business.DonorsBusiness;
import com.sample.entities.Donars;
import com.sample.repositories.DonarsRepository;
import com.sample.services.DonarsService;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.UUID;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;
import javax.persistence.metamodel.EntityType;
import javax.persistence.metamodel.Metamodel;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class DonarsServiceImpl implements DonarsService {

    @Autowired
    DonarsRepository donarsRepository;

    @PersistenceContext(unitName = "dw")
    private EntityManager entityManager;

    public List<Donars> findAll() {
        return donarsRepository.findAll();
    }

    @Override
    public void save(Donars donar) {
        if (donar.getId() == null) {
            donar.setId(UUID.randomUUID() + "");
        }
        donarsRepository.save(donar);
    }

    @Override
    public Donars findById(String id) {
        return donarsRepository.findOne(id);
    }

    @Override
    public List<Donars> findWithLimitAndOffset(int length, int start) {
        return donarsRepository.findWithLimitAndOffset(length, start);
    }

    @Override
    public List<Donars> findByFilterParameter(String mobile, String name, String address) {

        HashMap<String, String> paramMap = new HashMap<>();

        StringBuilder query = new StringBuilder("select * from donars d where");

        query.append(" d.status != :status");
        paramMap.put("status", "Deleted");

        if (!(mobile == null || mobile.equals(""))) {
            query.append(" and d.mobile LIKE :mobile");
            paramMap.put("mobile", "%" + mobile + "%");
        }

        if (!(name == null || name.equals(""))) {
            String[] combineName = name.split("\\s");
            if (combineName.length > 1) {
                query.append(" and UPPER(d.name) LIKE :fname");
                paramMap.put("fname", "%" + combineName[0].toUpperCase() + "%");
            } else {
                query.append(" and UPPER(d.name) LIKE :sname ");
                paramMap.put("sname", "%" + name.toUpperCase() + "%");
            }
        }

        if (!(address == null || address.equals(""))) {
            query.append(" and UPPER(d.address) LIKE :address");
            paramMap.put("address", "%" + address.toUpperCase() + "%");
        }

        query.append(" order by d.createddate desc");

        Query q = entityManager.createNativeQuery(query.toString(), Donars.class);
        for (Map.Entry pair : paramMap.entrySet()) {
            q.setParameter(pair.getKey().toString(), pair.getValue());
        }

        return q.getResultList();
    }

    @Override
    public List<Donars> commonFindByFilterParameter(HashMap<String, String> paramMap, int limit, int offset) {

        HashMap<String, String> queryParamMap = new HashMap<>();
        //        paramMap.put("mobile", mobile);
        //        paramMap.put("donarname",name);

        StringBuilder query = new StringBuilder("select * from donars d where");

        query.append(" d.status != :status");
        queryParamMap.put("status", "Deleted");

        if (!(paramMap.get("mobile") == null || paramMap.get("mobile").equals(""))) {
            query.append(" and d.mobile LIKE :mobile");
            queryParamMap.put("mobile", "%" + paramMap.get("mobile") + "%");
        }

        if (!(paramMap.get("donorname") == null || paramMap.get("donorname").equals(""))) {
            String[] combineName = paramMap.get("donorname").split("\\s");
            if (combineName.length > 1) {
                query.append(" and UPPER(d.name) LIKE :fname");
                queryParamMap.put("fname", "%" + combineName[0].toUpperCase() + "%");
            } else {
                query.append(" and UPPER(d.name) LIKE :sname ");
                queryParamMap.put("sname", "%" + paramMap.get("donorname").toUpperCase() + "%");
            }
        }

        if (!(paramMap.get("address") == null || paramMap.get("address").equals(""))) {
            query.append(" and UPPER(d.address) LIKE :address");
            queryParamMap.put("address", "%" + paramMap.get("address").toUpperCase() + "%");
        }

        query.append(" order by d.createddate desc LIMIT ").append(limit).append(" OFFSET ").append(offset);

        Query q = entityManager.createNativeQuery(query.toString(), Donars.class);
        for (Map.Entry pair : queryParamMap.entrySet()) {
            q.setParameter(pair.getKey().toString(), pair.getValue());
        }

        return q.getResultList();
    }

    @Override
    public long findCount() {
        return donarsRepository.findCount();
    }

    @Override
    public List<Donars> findCountByFilterParameter(HashMap<String, String> paramMap) {
        HashMap<String, String> queryParamMap = new HashMap<>();
        StringBuilder query = new StringBuilder("select * from donars where");

        query.append(" status != :status");
        queryParamMap.put("status", "Deleted");

        if (!(paramMap.get("mobile") == null || paramMap.get("mobile").equals(""))) {
            query.append(" and mobile LIKE :mobile");
            queryParamMap.put("mobile", "%" + paramMap.get("mobile") + "%");
        }

        if (!(paramMap.get("donorname") == null || paramMap.get("donorname").equals(""))) {
            String[] combineName = paramMap.get("donorname").split("\\s");
            if (combineName.length > 1) {
                query.append(" and UPPER(name) LIKE :fname");
                queryParamMap.put("fname", "%" + combineName[0].toUpperCase() + "%");
            } else {
                query.append(" and UPPER(name) LIKE :sname ");
                queryParamMap.put("sname", "%" + paramMap.get("donorname").toUpperCase() + "%");
            }
        }

        if (!(paramMap.get("address") == null || paramMap.get("address").equals(""))) {
            query.append(" and UPPER(address) LIKE :address");
            queryParamMap.put("address", "%" + paramMap.get("address").toUpperCase() + "%");
        }

        query.append(" order by createddate desc");

        Query q = entityManager.createNativeQuery(query.toString(), Donars.class);
        for (Map.Entry pair : queryParamMap.entrySet()) {
            q.setParameter(pair.getKey().toString(), pair.getValue());
        }

        return q.getResultList();

    }
}