Example usage for org.hibernate.criterion Restrictions between

List of usage examples for org.hibernate.criterion Restrictions between

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. between

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions between.

Prototype

public static Criterion between(String propertyName, Object low, Object high)

Source Link

Document

Apply a "between" constraint to the named property

Usage

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * /*from www. j a  va2s  .com*/
 * get List of OpenViolations By its inspectionTimestamp and SeverityLevelId
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param startDate
 * @param endDate
 * @param severityLevelId
 * @return List<VsdViolation>
 * @throws VSDException
 */
public List<VsdViolation> getOpenViolationsByUpdatedTimestampAndSeverityLevelId(
        final DataServiceContext dsContext, boolean retrieveArabicData, Date startDate, Date endDate,
        Long severityLevelId) throws VSDDataAccessException {
    logger.info("getOpenViolationsByUpdatedTimestampAndSeverityLevelId -- START");
    List<VsdViolation> violations = null;
    try {
        //         Calendar startDate = Calendar.getInstance();
        //         startDate.setTime(inspectionDate);
        //         startDate.set(Calendar.HOUR_OF_DAY, 0);
        //         startDate.set(Calendar.MINUTE, 0);
        //         startDate.set(Calendar.SECOND, 0);         
        //         startDate.set(Calendar.MILLISECOND, 0);
        //         
        //         Calendar endDate = Calendar.getInstance();
        //         endDate.setTime(inspectionDate);
        //         endDate.set(Calendar.HOUR_OF_DAY, 23);
        //         endDate.set(Calendar.MINUTE, 59);
        //         endDate.set(Calendar.SECOND, 59);
        //         endDate.set(Calendar.MILLISECOND, 999);

        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.between("v.upatedTimestamp", startDate, endDate))
                .createCriteria("v.vsdViolationStatus", "vs", Criteria.LEFT_JOIN,
                        Restrictions.eq("vs.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("vs.violationStatusId", Constant.VIOLATION_STATUS_OPEN))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdPlateConditionByFrontPlateConditionId", "fpc", Criteria.LEFT_JOIN,
                        Restrictions.eq("fpc.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdPlateConditionByRearPlateConditionId", "rpc", Criteria.LEFT_JOIN,
                        Restrictions.eq("rpc.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdDriverInfos", "di", Criteria.LEFT_JOIN,
                        Restrictions.eq("di.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.LEFT_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdChannelDefects", "cd", Criteria.LEFT_JOIN,
                        Restrictions.eq("cd.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdSeverityLevel", "sl", Criteria.LEFT_JOIN,
                        Restrictions.eq("sl.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("sl.severityLevelId", severityLevelId))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (Exception ex) {
        logger.error("An error occured in getOpenViolationsByUpdatedTimestampAndSeverityLevelId()");
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
    logger.info("getOpenViolationsByUpdatedTimestampAndSeverityLevelId -- END");
    return violations;
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * /*  ww  w.  j  a v  a2 s .c  om*/
 * get List of cancel Violations By InspectionDate and SeverityLevelId
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param startDate
 * @param endDate
 * @param severityLevelId
 * @return List<VsdViolation>
 * @throws VSDException
 */
public List<VsdViolation> getCancelViolationsByInspectionDateAndSeverityLevelId(
        final DataServiceContext dsContext, boolean retrieveArabicData, Date startDate, Date endDate,
        Long severityLevelId) throws VSDDataAccessException {
    logger.info("getCancelViolationsByInspectionDateAndSeverityLevelId -- START");
    List<VsdViolation> violations = null;
    try {

        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdViolationStatus", "vs", Criteria.LEFT_JOIN,
                        Restrictions.eq("vs.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("vs.violationStatusId", Constant.VIOLATION_STATUS_CANCELLED))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.between("i.inspectionTimestamp", startDate, endDate))
                .createCriteria("i.vsdPlateConditionByFrontPlateConditionId", "fpc", Criteria.LEFT_JOIN,
                        Restrictions.eq("fpc.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdPlateConditionByRearPlateConditionId", "rpc", Criteria.LEFT_JOIN,
                        Restrictions.eq("rpc.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdDriverInfos", "di", Criteria.LEFT_JOIN,
                        Restrictions.eq("di.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.LEFT_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdChannelDefects", "cd", Criteria.LEFT_JOIN,
                        Restrictions.eq("cd.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdSeverityLevel", "sl", Criteria.LEFT_JOIN,
                        Restrictions.eq("sl.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("sl.severityLevelId", severityLevelId))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (Exception ex) {
        logger.error("An error occured in getCancelViolationsByInspectionDateAndSeverityLevelId()");
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
    logger.info("getCancelViolationsByInspectionDateAndSeverityLevelId -- END");
    return violations;
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * /*from   ww w.  j a  v  a2 s.  com*/
 * get List of cancel Violations By its updated timestamp and SeverityLevelId
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param startDate
 * @param endDate
 * @return List<VsdViolation>
 * @throws VSDException
 */
public List<VsdViolation> getCancelViolationsByUpdatedTimestamp(final DataServiceContext dsContext,
        boolean retrieveArabicData, Date startDate, Date endDate) throws VSDDataAccessException {
    logger.info("getCancelViolationsByUpdatedTimestamp -- START");
    List<VsdViolation> violations = null;
    try {

        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.between("v.upatedTimestamp", startDate, endDate))
                .createCriteria("v.vsdViolationStatus", "vs", Criteria.LEFT_JOIN,
                        Restrictions.eq("vs.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("vs.violationStatusId", Constant.VIOLATION_STATUS_CANCELLED))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdPlateConditionByFrontPlateConditionId", "fpc", Criteria.LEFT_JOIN,
                        Restrictions.eq("fpc.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdPlateConditionByRearPlateConditionId", "rpc", Criteria.LEFT_JOIN,
                        Restrictions.eq("rpc.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdDriverInfos", "di", Criteria.LEFT_JOIN,
                        Restrictions.eq("di.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.LEFT_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdChannelDefects", "cd", Criteria.LEFT_JOIN,
                        Restrictions.eq("cd.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdSeverityLevel", "sl", Criteria.LEFT_JOIN,
                        Restrictions.eq("sl.isDeleted", IDataService.BOOL_FALSE))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (Exception ex) {
        logger.error("An error occured in getCancelViolationsByUpdatedTimestamp()");
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
    logger.info("getCancelViolationsByUpdatedTimestamp -- END");
    return violations;
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * //from   w w w. j a  v a2 s  . c om
 * Gets a list of violations by the violation status ids, test status and test date provided. 
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param testStatus
 * @param startDate
 * @param endDate
 * @param violationStatusIds
 * @return List<VsdViolation>
 * @throws VSDDataAccessException
 */
public List<VsdViolation> getViolationsByTestStatusTestDateAndViolationStatusId(DataServiceContext dsContext,
        boolean retrieveArabicData, String testStatus, Date startDate, Date endDate,
        List<Long> violationStatusIds) throws VSDDataAccessException {
    logger.info("getViolationsByTestStatusTestDateAndViolationStatusId -- START");
    List<VsdViolation> violations = null;
    try {
        //         Calendar startDate = Calendar.getInstance();
        //         startDate.setTime(testDate);
        //         startDate.set(Calendar.HOUR_OF_DAY, 0);
        //         startDate.set(Calendar.MINUTE, 0);
        //         startDate.set(Calendar.SECOND, 0);         
        //         startDate.set(Calendar.MILLISECOND, 0);
        //         
        //         Calendar endDate = Calendar.getInstance();
        //         endDate.setTime(testDate);
        //         endDate.set(Calendar.HOUR_OF_DAY, 23);
        //         endDate.set(Calendar.MINUTE, 59);
        //         endDate.set(Calendar.SECOND, 59);
        //         endDate.set(Calendar.MILLISECOND, 999);

        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdViolationStatus", "vs", Criteria.LEFT_JOIN,
                        Restrictions.eq("vs.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.in("vs.violationStatusId", violationStatusIds))
                .createCriteria("v.vsdViolationTestFees", "vtf", Criteria.LEFT_JOIN,
                        Restrictions.eq("vtf.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vtf.vsdTestFee", "tf", Criteria.LEFT_JOIN,
                        Restrictions.eq("tf.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("tf.vsdChannelTests", "ct", Criteria.LEFT_JOIN,
                        Restrictions.eq("ct.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("ct.testStatus", testStatus))
                .add(Restrictions.between("ct.createdTimestamp", startDate, endDate))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.LEFT_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdSeverityLevel", "svl", Criteria.LEFT_JOIN,
                        Restrictions.eq("svl.isDeleted", IDataService.BOOL_FALSE))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();

        logger.info("getViolationsByTestStatusTestDateAndViolationStatusId -- END");
        return violations;
    } catch (Exception ex) {
        logger.error("An error occured in getViolationsByTestStatusTestDateAndViolationStatusId()");
        logger.error(ex);
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * //from  ww w.  j  a v  a2 s .  c  om
 * Gets a list of violations for those vehicles whose plate has been confiscated and the violation has the status provided and the inspection occurred on the specified date.
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param violationStatusIds
 * @param startDate
 * @param endDate
 * @return List<VsdViolation>
 * @throws VSDDataAccessException
 */
public List<VsdViolation> getPlateConfiscatedViolationsByViolationStatusIdAndInspectionDate(
        DataServiceContext dsContext, boolean retrieveArabicData, List<Long> violationStatusIds,
        Long severityLevelId, Date startDate, Date endDate) throws VSDDataAccessException {
    logger.info("getPlateConfiscatedViolationsByViolationStatusIdAndInspectionDate -- START");
    List<VsdViolation> violations = null;
    try {
        //         Calendar startDate = Calendar.getInstance();
        //         startDate.setTime(inspectionDate);
        //         startDate.set(Calendar.HOUR_OF_DAY, 0);
        //         startDate.set(Calendar.MINUTE, 0);
        //         startDate.set(Calendar.SECOND, 0);         
        //         startDate.set(Calendar.MILLISECOND, 0);
        //         
        //         Calendar endDate = Calendar.getInstance();
        //         endDate.setTime(inspectionDate);
        //         endDate.set(Calendar.HOUR_OF_DAY, 23);
        //         endDate.set(Calendar.MINUTE, 59);
        //         endDate.set(Calendar.SECOND, 59);
        //         endDate.set(Calendar.MILLISECOND, 999);
        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdSeverityLevel", "sl", Criteria.LEFT_JOIN,
                        Restrictions.eq("sl.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("sl.severityLevelId", severityLevelId))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.between("i.inspectionTimestamp", startDate, endDate))
                .add(Restrictions.eq("i.isPlateConfiscated", IDataService.BOOL_TRUE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.LEFT_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdViolationStatus", "vs", Criteria.LEFT_JOIN,
                        Restrictions.eq("vs.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.in("vs.violationStatusId", violationStatusIds))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
        logger.info("getPlateConfiscatedViolationsByViolationStatusIdAndInspectionDate -- END");
        return violations;
    } catch (Exception ex) {
        logger.error("An error occured in getPlateConfiscatedViolationsByViolationStatusIdAndInspectionDate()");
        logger.error(ex);
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * /*from  w  w  w .  java  2  s.  c  om*/
 * Gets a list of violations which have the specified block status and occured on the provided date. 
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param blockStatus
 * @param startDate
 * @param endDate
 * @return List<VsdViolation>
 * @throws VSDDataAccessException
 */
public List<VsdViolation> getViolationsByBlockStatusAndBlockDate(DataServiceContext dsContext,
        boolean retrieveArabicData, Character blockStatus, Date startDate, Date endDate)
        throws VSDDataAccessException {
    logger.info("getViolationsByBlockStatusAndBlockDate -- START");
    List<VsdViolation> violations = null;
    try {
        //         Calendar startDate = Calendar.getInstance();
        //         startDate.setTime(blockDate);
        //         startDate.set(Calendar.HOUR_OF_DAY, 0);
        //         startDate.set(Calendar.MINUTE, 0);
        //         startDate.set(Calendar.SECOND, 0);         
        //         startDate.set(Calendar.MILLISECOND, 0);
        //         
        //         Calendar endDate = Calendar.getInstance();
        //         endDate.setTime(blockDate);
        //         endDate.set(Calendar.HOUR_OF_DAY, 23);
        //         endDate.set(Calendar.MINUTE, 59);
        //         endDate.set(Calendar.SECOND, 59);
        //         endDate.set(Calendar.MILLISECOND, 999);
        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("v.vsdViolServiceBlocks", "vsb", Criteria.LEFT_JOIN,
                        Restrictions.eq("vsb.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("vsb.blockStatus", blockStatus))
                .add(Restrictions.between("vsb.blockedTimestamp", startDate, endDate))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
        logger.info("getViolationsByBlockStatusAndBlockDate -- END");
        return violations;
    } catch (Exception ex) {
        logger.error("An error occured in getViolationsByBlockStatusAndBlockDate()");
        logger.error(ex);
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * /*  w  ww  .  jav  a  2  s .c  o m*/
 * Gets a list of violations that occurred between the given dates for the specified vehicle plate details
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param plateDetails
 * @param startDate
 * @param endDate
 * @return List<VsdViolation>
 * @throws VSDDataAccessException
 */
public List<VsdViolation> getViolationsByVehiclePlateAndReportedDate(DataServiceContext dsContext,
        boolean retrieveArabicData, VehiclePlate plateDetails, Date startDate, Date endDate)
        throws VSDDataAccessException {
    logger.info("getViolationsByVehiclePlateAndDate -- START");
    List<VsdViolation> violations = null;
    try {

        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.between("v.reportedDate", startDate, endDate))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("vi.vehiclePlateCategory", plateDetails.getPlateCategory()).ignoreCase())
                .add(Restrictions.eq("vi.vehiclePlateCode", plateDetails.getPlateCode()).ignoreCase())
                .add(Restrictions.eq("vi.vehiclePlateSource", plateDetails.getPlateSource()).ignoreCase())
                .add(Restrictions.eq("vi.vehiclePlateNumber", plateDetails.getPlateNumber()).ignoreCase())
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
        logger.info("getViolationsByVehiclePlateAndDate -- END");
        return violations;
    } catch (Exception ex) {
        logger.error("An error occured in getViolationsByVehiclePlateAndDate()");
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
}

From source file:com.rta.vsd.data.service.impl.ViolationDataServiceImpl.java

/**
 * /*from ww  w .  j  a v a 2  s.  c o  m*/
 * Get a list of violations by the status id provided and the start and end date provided
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param startDate
 * @param endDate
 * @param violationStatusIds
 * @return List<VsdViolation>
 * @throws VSDDataAccessException
 */
public List<VsdViolation> getViolationsByViolationStatusIdAndUpdatedTimestamp(
        final DataServiceContext dsContext, boolean retrieveArabicData, Date startDate, Date endDate,
        List<Long> violationStatusIds) throws VSDDataAccessException {
    logger.info("getViolationsByViolationStatusIdAndUpdatedTimestamp -- START");
    List<VsdViolation> violations = null;
    try {
        //         Calendar sDate = Calendar.getInstance();
        //         sDate.setTime(startDate);
        //         sDate.set(Calendar.HOUR_OF_DAY, 0);
        //         sDate.set(Calendar.MINUTE, 0);
        //         sDate.set(Calendar.SECOND, 0);         
        //         sDate.set(Calendar.MILLISECOND, 0);
        //         
        //         Calendar eDate = Calendar.getInstance();
        //         eDate.setTime(endDate);
        //         eDate.set(Calendar.HOUR_OF_DAY, 23);
        //         eDate.set(Calendar.MINUTE, 59);
        //         eDate.set(Calendar.SECOND, 59);
        //         eDate.set(Calendar.MILLISECOND, 999);

        Session session = (Session) dsContext.getInternalContext();
        violations = session.createCriteria(VsdViolation.class, "v")
                .add(Restrictions.eq("v.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.between("v.upatedTimestamp", startDate, endDate))
                .createCriteria("v.vsdViolationStatus", "vs", Criteria.LEFT_JOIN,
                        Restrictions.eq("vs.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.in("vs.violationStatusId", violationStatusIds))
                .createCriteria("v.vsdInspections", "i", Criteria.LEFT_JOIN,
                        Restrictions.eq("i.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("i.vsdVehicleInfo", "vi", Criteria.LEFT_JOIN,
                        Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.LEFT_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (Exception ex) {
        logger.error("An error occured in getViolationsByViolationStatusIdAndUpdatedTimestamp()");
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
    logger.info("getViolationsByViolationStatusIdAndUpdatedTimestamp -- END");
    return violations;
}

From source file:com.sccl.attech.modules.sys.service.LogService.java

License:Open Source License

public Page<Log> find(Page<Log> page, Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    //      Long createById = StringUtils.toLong(paramMap.get("createById"));
    //      if (createById > 0){
    //         dc.add(Restrictions.eq("createBy.id", createById));
    //      }/*ww  w. ja  v  a 2  s.c  o  m*/
    String type = ObjectUtils.toString(paramMap.get("type"));
    if ("0".equals(type)) {//???
        dc.add(Restrictions.eq("type", type));
    } else {
        String manageName = ObjectUtils.toString(paramMap.get("manageName"));
        if (StringUtils.isNotBlank(manageName)) {
            dc.createAlias("createBy", "createBy");
            dc.add(Restrictions.like("createBy.name", "%" + EncodedUtil.decodeValue(manageName) + "%"));
        }
        dc.createAlias("company", "company");
        String companyId = ObjectUtils.toString(paramMap.get("companyId"));
        if (StringUtils.isNotBlank(companyId)) {

            dc.add(Restrictions.eq("company.id", companyId));
        }

        String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
        if (StringUtils.isNotBlank(requestUri)) {
            dc.add(Restrictions.like("requestUri", "%" + requestUri + "%"));
        }

        String exception = ObjectUtils.toString(paramMap.get("exception"));
        if (StringUtils.isNotBlank(exception)) {
            dc.add(Restrictions.eq("type", Log.TYPE_EXCEPTION));
        }

        if (StringUtils.isNotBlank(type)) {
            dc.add(Restrictions.eq("type", type));
        }

        Date beginDate = DateUtils.parseDate(paramMap.get("start"));
        if (beginDate == null) {
            beginDate = DateUtils.setDays(new Date(), 1);
            paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
        }
        Date endDate = DateUtils.parseDate(paramMap.get("end"));
        if (endDate == null) {
            endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
            paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
        }
        dc.createAlias("office", "office");
        User currentUser = UserUtils.getUser();
        dc.add(Restrictions.or(dataScopeFilter(currentUser, "office", "createBy"),
                Restrictions.eq("type", "0")));
        dc.add(Restrictions.between("createDate", beginDate, endDate));
    }
    dc.addOrder(Order.desc("createDate"));
    return logDao.find(page, dc);
}

From source file:com.sccl.attech.modules.sys.service.LogService.java

License:Open Source License

/**
 * ?// w  w  w .  j a  v a2 s .c o  m
 * @param paramMap
 * @return
 */
public List<Log> getList(Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    Long createById = StringUtils.toLong(paramMap.get("createById"));
    if (createById > 0) {
        dc.add(Restrictions.eq("createBy.id", createById));
    }
    String manageName = ObjectUtils.toString(paramMap.get("manageName"));
    if (StringUtils.isNotBlank(manageName)) {
        dc.createAlias("createBy", "createBy");
        dc.add(Restrictions.like("createBy.name", EncodedUtil.decodeValue(manageName)));
    }

    String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
    if (StringUtils.isNotBlank(requestUri)) {
        dc.add(Restrictions.like("requestUri", "%" + requestUri + "%"));
    }

    String exception = ObjectUtils.toString(paramMap.get("exception"));
    if (StringUtils.isNotBlank(exception)) {
        dc.add(Restrictions.eq("type", Log.TYPE_EXCEPTION));
    }

    Date beginDate = DateUtils.parseDate(paramMap.get("start"));
    if (beginDate == null) {
        beginDate = DateUtils.setDays(new Date(), 1);
        paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
    }
    Date endDate = DateUtils.parseDate(paramMap.get("end"));
    if (endDate == null) {
        endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
        paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
    }
    dc.add(Restrictions.between("createDate", beginDate, endDate));

    dc.addOrder(Order.desc("createDate"));
    return logDao.find(dc);
}