Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / main / java / org / gvsig / sqlite / dal / expressionbuilderformatter / ST_Overlaps.java @ 47606

History | View | Annotate | Download (1.85 KB)

1
package org.gvsig.sqlite.dal.expressionbuilderformatter;
2

    
3
import java.text.MessageFormat;
4
import java.util.List;
5
import org.apache.commons.lang3.StringUtils;
6
import org.gvsig.expressionevaluator.ExpressionBuilder;
7
import org.gvsig.expressionevaluator.ExpressionBuilder.Function;
8
import org.gvsig.expressionevaluator.ExpressionBuilder.Value;
9
import org.gvsig.expressionevaluator.Formatter;
10
import org.gvsig.fmap.dal.SQLBuilder;
11
import static org.gvsig.sqlite.dal.expressionbuilderformatter.ST_Intersects.getBBoxIntersectsFilter;
12

    
13
/**
14
 *
15
 * @author jjdelcerro
16
 */
17
public class ST_Overlaps implements Formatter<Value> {
18
    
19
    private final SQLBuilder sqlbuilder;
20
    private final Formatter<Value> formatter;
21
    
22
    public ST_Overlaps(SQLBuilder sqlbuilder, Formatter<Value> formatter) {
23
        this.sqlbuilder = sqlbuilder;
24
        this.formatter = formatter;
25
    }
26
    @Override
27
    public boolean canApply(ExpressionBuilder.Value value) {
28
        if (value instanceof ExpressionBuilder.Function) {
29
            return StringUtils.equalsIgnoreCase("ST_Overlaps", ((Function) value).name());
30
        }
31
        return false;
32
    }
33

    
34
    @Override
35
    public String format(Value function) {
36
        List<Value> parameters = ((Function) function).parameters();
37
        Value p1 = parameters.get(0);
38
        Value p2 = parameters.get(1);
39
        String p1s = p1.toString(formatter);
40
        String p2s = p2.toString(formatter);
41

    
42
        String filter = getBBoxIntersectsFilter(formatter, p1, p2);
43
        if (filter == null ) {         
44
            filter = getBBoxIntersectsFilter(formatter, p2, p1);
45
        }
46
        String r;
47
        if( filter == null ) {
48
            r = MessageFormat.format("ST_Overlaps(({0}),({1}))", p1s, p2s);
49
        } else {
50
            r = MessageFormat.format("( ({2}) AND ST_Overlaps(({0}),({1}) ))", p1s, p2s, filter);
51
        }
52
        return r;
53
    }
54
    
55
}