Hibernate Order extension sample

gistfile1.java

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.criterion.CriteriaQuery;
import org.hibernate.criterion.Order;

public class PostgisDistanceOrder extends Order {

    private boolean ascending;
    private String propertyName;
    private double fromLatitude;
    private double fromLongitude;

    public PostgisDistanceOrder(
            double fromLatitude,
            double fromLongitude,
            String propertyName,
            boolean ascending) {
        super(propertyName, ascending);
        this.fromLatitude = fromLatitude;
        this.fromLongitude = fromLongitude;
        this.ascending = ascending;
        this.propertyName = propertyName;
    }

    @Override
    public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery)
            throws HibernateException {
        return "(ST_Distance(" +
            criteriaQuery.getSQLAlias(criteria) + "." + propertyName + "," +
            "ST_GeomFromText('POINT(" + fromLongitude + " " + fromLatitude + ")', 4326))) " +
            (ascending ? " asc" : " desc");
    }

}