ReportExternalImportDAOImpl.java

/**
* The contents of this file are subject to the Mozilla Public License
* Version 1.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.mozilla.org/MPL/ 
* 
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations under
* the License.
* 
* The Original Code is OpenELIS code.
* 
* Copyright (C) CIRG, University of Washington, Seattle WA.  All Rights Reserved.
*
*/
package us.mn.state.health.lims.dataexchange.aggregatereporting.daoimpl;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import us.mn.state.health.lims.audittrail.dao.AuditTrailDAO;
import us.mn.state.health.lims.audittrail.daoimpl.AuditTrailDAOImpl;
import us.mn.state.health.lims.common.action.IActionConstants;
import us.mn.state.health.lims.common.daoimpl.BaseDAOImpl;
import us.mn.state.health.lims.common.exception.LIMSRuntimeException;
import us.mn.state.health.lims.dataexchange.aggregatereporting.dao.ReportExternalImportDAO;
import us.mn.state.health.lims.dataexchange.aggregatereporting.valueholder.ReportExternalImport;
import us.mn.state.health.lims.hibernate.HibernateUtil;

import java.sql.Timestamp;
import java.util.List;

public class ReportExternalImportDAOImpl extends BaseDAOImpl implements ReportExternalImportDAO {
	
	@SuppressWarnings("unchecked")
	@Override
	public List<ReportExternalImport> getReportsInDateRangeSorted(Timestamp lower, Timestamp upper) throws LIMSRuntimeException {
		String sql = "from ReportExternalImport rq where rq.eventDate >= :lower and rq.eventDate <= :upper order by rq.sendingSite";
		
		try {
			Query query = HibernateUtil.getSession().createQuery(sql);
			query.setTimestamp("lower", lower);
			query.setTimestamp("upper", upper);

			List<ReportExternalImport> reports = query.list();

			closeSession();

			return reports;
		} catch (HibernateException e) {
			handleException(e, "getReportsInDateRangeSorted");
		}

		return null;
	}

	@Override
	public void insertReportExternalImport(ReportExternalImport report) throws LIMSRuntimeException {
		try {
			String id = (String) HibernateUtil.getSession().save(report);
			report.setId(id);
			new AuditTrailDAOImpl().saveNewHistory(report, report.getSysUserId(), "REPORT_EXTERNAL_IMPORT");
			closeSession();
		} catch (HibernateException e) {
			handleException(e, "insertReportExternalImport");
		}
	}

	@Override
	public void updateReportExternalImport(ReportExternalImport report) throws LIMSRuntimeException {
		ReportExternalImport oldData = readReportExternalImport(report.getId());

		try {
			AuditTrailDAO auditDAO = new AuditTrailDAOImpl();

			auditDAO.saveHistory(report, oldData, report.getSysUserId(), IActionConstants.AUDIT_TRAIL_UPDATE, "REPORT_EXTERNAL_IMPORT");

			HibernateUtil.getSession().merge(report);
			HibernateUtil.getSession().flush();
			HibernateUtil.getSession().clear();
			HibernateUtil.getSession().evict(report);
			HibernateUtil.getSession().refresh(report);
		} catch (Exception e) {
			handleException(e, "updateReportExternalImport");
		}
	}

	public ReportExternalImport readReportExternalImport(String idString) throws LIMSRuntimeException {

		try {
			ReportExternalImport data = (ReportExternalImport) HibernateUtil.getSession().get(ReportExternalImport.class, idString);
			closeSession();
			return data;
		} catch (HibernateException e) {
			handleException(e, "readReportExternalImport");
		}
		return null;
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<String> getUniqueSites() throws LIMSRuntimeException {
		String sql = "select distinct sending_site from clinlims.report_external_import ";
		try{
			Query query = HibernateUtil.getSession().createSQLQuery(sql);
			List<String> sites = query.list();
			closeSession();
			return sites;
		}catch(HibernateException e){
			handleException(e,"getUniqueSites");
		}
		
		return null;
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<ReportExternalImport> getReportsInDateRangeSortedForSite(Timestamp lower, Timestamp upper,  String site)
			throws LIMSRuntimeException {
	String sql = "from ReportExternalImport rq where rq.eventDate >= :lower and rq.eventDate <= :upper and rq.sendingSite = :site order by rq.sendingSite"; 
		
		
		try {
			Query query = HibernateUtil.getSession().createQuery(sql);
			query.setTimestamp("lower", lower);
			query.setTimestamp("upper", upper);
			query.setString("site", site);

			List<ReportExternalImport> reports = query.list();

			closeSession();

			return reports;
		} catch (HibernateException e) {
			handleException(e, "getReportsInDateRangeSortedForSite");
		}

		return null;	}

    @SuppressWarnings( "unchecked" )
    @Override
	public ReportExternalImport  getReportByEventDateSiteType(ReportExternalImport importReport) throws LIMSRuntimeException {
		String sql = "from ReportExternalImport rei where rei.eventDate = :eventDate and rei.sendingSite = :site and rei.reportType = :type";
		
		try{
			Query query = HibernateUtil.getSession().createQuery(sql);
			query.setDate("eventDate", importReport.getEventDate());
			query.setString("site", importReport.getSendingSite());
			query.setString("type", importReport.getReportType());
			
            List<ReportExternalImport> reports = query.list();

            closeSession();

            return reports.isEmpty()  ? new ReportExternalImport() : reports.get( 0 );
			
		}catch( HibernateException e){
			handleException(e, "getReportByEventDateSiteType");
		}
		
		return null;
	}

}