@Entity
@Table(name = "myisam_product_article", catalog = "forestsurf", schema = "")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "MyisamProductArticle.findAll", query = "SELECT m FROM MyisamProductArticle m"),
    @NamedQuery(name = "MyisamProductArticle.findByArticleId", query = "SELECT m FROM MyisamProductArticle m WHERE m.articleId = :articleId"),
    @NamedQuery(name = "MyisamProductArticle.findByProductId", query = "SELECT m FROM MyisamProductArticle m WHERE m.productId = :productId"),
    @NamedQuery(name = "MyisamProductArticle.findByHeader", query = "SELECT m FROM MyisamProductArticle m WHERE m.header = :header")})

//@Spatial(spatialMode = SpatialMode.GRID, name="location")
@Spatial(name="location")
//This annotation tells hibernate search that this class has to be indexed
@Indexed(index = "MyisamProductArticle")
@Analyzer(impl = org.apache.lucene.analysis.standard.StandardAnalyzer.class)
@AnalyzerDef(name = "customanalyzer", tokenizer = @TokenizerDef(factory = StandardTokenizerFactory.class),
        filters = {@TokenFilterDef(factory = LowerCaseFilterFactory.class),
                    @TokenFilterDef(factory = SnowballPorterFilterFactory.class, params = {
                        @Parameter(name = "language", value = "English"),
                    }),
                    @TokenFilterDef(factory = SynonymFilterFactory.class, params = {
                        @Parameter(name = "ignoreCase", value = "true"),
                        @Parameter(name = "expand", value = "true"),
                        @Parameter(name = "synonyms", value="synonyms.txt")}),
    })
public class MyisamProductArticle implements Serializable, Coordinates, Comparable<MyisamProductArticle> {
    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    @NotNull
    @Column(name = "article_id")
    private Integer articleId;
    @Basic(optional = false)
    @NotNull
    @Column(name = "product_id")
    private int productId;
    @Lob
    @Size(max = 65535)
    @Column(name = "a_desc")
    @Analyzer(definition = "customanalyzer")
@Field(index = Index.YES, store = Store.YES)
    private String aDesc;
    @Size(max = 255)
    @Column(name = "header")
@Field(index = Index.YES, store = Store.YES)
    @Analyzer(definition = "customanalyzer")
    private String header;
    @Size(max = 64)
    @Column(name = "parent_category_name")
    @Analyzer(definition = "customanalyzer")
    @Field(index = Index.YES, store = Store.YES)
    private String parentCategoryName;
    @Size(max = 64)
    @Column(name = "sub_category_name")
    @Analyzer(definition = "customanalyzer")
    @Field(index = Index.YES, store = Store.YES)
    private String subCategoryName;
    @Size(max = 5)
    @Column(name = "postcode")
    @Analyzer(definition = "customanalyzer")
    @Field(index = Index.YES, store = Store.YES)
    private String postcode;
   
    @Size(max = 50)
    @Column(name = "state")
    @Analyzer(definition = "customanalyzer")
    @Field(index = Index.YES, store = Store.YES)
    private String state;
//    @Size(max = 50)
    @Column(name = "latitude")
//    @Latitude(of="location")
    private Double latitude;
//    @Size(max = 50)
    @Column(name = "longitude")
//    @Longitude(of="location")
    private Double longitude;
    @Column(name = "creation_date")
    @Temporal(TemporalType.DATE)
    @Boost(2.0f)
    @Field(index = Index.YES, store = Store.YES)
    @DateBridge(resolution=Resolution.DAY)
    private Date creationDate;
   
   
    public MyisamProductArticle() {
    }

    public MyisamProductArticle(Integer articleId) {
        this.articleId = articleId;
    }

    public MyisamProductArticle(Integer articleId, int productId) {
        this.articleId = articleId;
        this.productId = productId;
    }

    public Integer getArticleId() {
        return articleId;
    }

    public void setArticleId(Integer articleId) {
        this.articleId = articleId;
    }

    public int getProductId() {
        return productId;
    }

    public void setProductId(int productId) {
        this.productId = productId;
    }

    public String getADesc() {
        return aDesc;
    }

    public void setADesc(String aDesc) {
        this.aDesc = aDesc;
    }

    public String getHeader() {
        return header;
    }

    public void setHeader(String header) {
        this.header = header;
    }

    public String getParentCategoryName() {
        return parentCategoryName;
    }

    public void setParentCategoryName(String parentCategoryName) {
        this.parentCategoryName = parentCategoryName;
    }

    public String getSubCategoryName() {
        return subCategoryName;
    }

    public void setSubCategoryName(String subCategoryName) {
        this.subCategoryName = subCategoryName;
    }

    public String getPostcode() {
        return postcode;
    }
    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

   
    public void setPostcode(String postcode) {
        this.postcode = postcode;
    }

    @Override
    public Double getLatitude() {
        return latitude;
    }

    public void setLatitude(Double lat) {
        this.latitude = lat;
    }

    @Override
    public Double getLongitude() {
        return longitude;
    }
public void setLongitude(Double lon) {
        this.longitude = lon;
    }

    public Date getCreationDate() {
        return creationDate;
    }

    public void setCreationDate(Date creationDate) {
        this.creationDate = creationDate;
    }

.must(qb.spatial()
                                .onCoordinates( "location" )
                                .within( radius, Unit.KM )
                                .ofLatitude( lat )
                                .andLongitude( lon ).createQuery()