org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java Source code

Introduction

Here is the source code for org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.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 org.openmrs.module.accessmonitor.api.db.hibernate;

import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Random;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Criteria;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.openmrs.module.accessmonitor.VisitServiceAccess;
import org.openmrs.module.accessmonitor.api.db.VisitAccessDAO;

/**
 *
 * @author Ray
 */
public class HibernateVisitAccessDAO implements VisitAccessDAO {

    protected final Log log = LogFactory.getLog(this.getClass());

    private SessionFactory sessionFactory;

    /**
      * @param sessionFactory the sessionFactory to set
      */
    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    /**
      * @return the sessionFactory
      */
    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    // New methods added on 5/13/2015
    public List<VisitServiceAccess> getVisitAccessesByAccessDateOrderByPatientId(Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.addOrder(Order.asc("patientId"));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    // New methods added on 5/4/2015
    public List<VisitServiceAccess> getVisitServiceAccessesByAccessorId(Integer accessorId, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("accessorId", accessorId));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByPatientId(Integer patientId, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("patientId", patientId));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByVisitId(Integer visitId, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitId", visitId));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByVisitType(String visitType, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitType", visitType));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByAccessType(String accessType, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("accessType", accessType));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByVisitUuid(String visitUuid, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitUuid", visitUuid));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByVoidReason(String voidReason, Date from, Date to) {

        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("voidReason", voidReason));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByAccessDate(Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByVisitStartDate(Date visitStartDate, Date from,
            Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitStartDate", visitStartDate));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    public List<VisitServiceAccess> getVisitServiceAccessesByVisitEndDate(Date visitEndDate, Date from, Date to) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitEndDate", visitEndDate));
        if (from != null || to != null) {
            if (from == null) {
                crit.add(Restrictions.le("accessDate", to));
            } else if (to == null) {
                crit.add(Restrictions.ge("accessDate", from));
            } else {
                crit.add(Restrictions.between("accessDate", from, to));
            }
        }
        return crit.list();
    }

    // old
    @Override
    public VisitServiceAccess getVisitServiceAccessById(Integer id) {
        return (VisitServiceAccess) sessionFactory.getCurrentSession().get(VisitServiceAccess.class, id);
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByAccessorId(Integer accessorId) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("accessorId", accessorId));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByPatientId(Integer patientId) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("patienId", patientId));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByVisitId(Integer visitId) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitId", visitId));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByVisitType(String visitType) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitType", visitType));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByAccessType(String accessType) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("accessType", accessType));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByVisitUuid(String visitUuid) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitUuid", visitUuid));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByVoidReason(String voidReason) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("accessorId", voidReason));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByAccessDate(Date accessDate) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("accessDate", accessDate));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByVisitStartDate(Date visitStartDate) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitStartDate", visitStartDate));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getVisitServiceAccessesByVisitEndDate(Date visitEndDate) {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        crit.add(Restrictions.eq("visitEndDate", visitEndDate));
        return crit.list();
    }

    @Override
    public List<VisitServiceAccess> getAllVisitServiceAccesses() {
        Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
        return crit.list();
    }

    @Override
    public VisitServiceAccess saveVisitServiceAccess(VisitServiceAccess visitServiceAccess) {
        sessionFactory.getCurrentSession().saveOrUpdate(visitServiceAccess);
        return visitServiceAccess;
    }

    //    @Override
    //    public void generateData() {
    //        Random r = new Random();
    //        
    //        Calendar c = Calendar.getInstance();
    //        r.setSeed(c.getTimeInMillis());
    //        long end = c.getTimeInMillis();
    //        c.set(2013, 0, 1);
    //        long start = c.getTimeInMillis();
    //        for (int i = 0; i < 10000; i++) {
    //            VisitServiceAccess o = new VisitServiceAccess();
    //            long date = start + r.nextLong() % (end - start);
    //            c.setTimeInMillis(date);
    //            o.setAccessDate(c.getTime());
    //            o.setAccessorId(r.nextInt(10));
    //            o.setPatientId(r.nextInt(8000)+1000);
    //            saveVisitServiceAccess(o);
    //        }
    //    }

}