/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package usda.weru.gis.data;

import org.apache.log4j.Logger;
import org.geotools.data.FeatureSource;
import org.geotools.factory.Hints;
import org.geotools.filter.text.cql2.CQL;
import org.geotools.filter.text.cql2.CQLException;
import org.opengis.feature.Feature;
import org.opengis.filter.Filter;
import org.opengis.filter.FilterFactory2;
import usda.weru.weps.location.Site;

/**
 *
 * @author Joseph Levin <joelevin@weru.ksu.edu>
 */
public class SiteCountyLookup extends AbstractLookup<Site.CountyEquivalent>{

    private static final Logger LOGGER = Logger.getLogger(SiteCountyLookup.class);

    public static final String COLUMN_COUNTY_D00_= "CO99_D00_";
    public static final String COLUMN_COUNTY_D00_I= "CO99_D00_I";
    public static final String COLUMN_COUNTY_NAME= "NAME";
    public static final String COLUMN_COUNTY_LSAD = "LSAD_TRANS";
    public static final String COLUMN_COUNTY_STATE = "STATE";
    public static final String COLUMN_COUNTY_COUNTY = "COUNTY";

    @Override
    protected Site.CountyEquivalent create(FeatureSource source, Feature feature) {
        String stateFips = getValue(feature, COLUMN_COUNTY_STATE, String.class);
        String countyFips = getValue(feature, COLUMN_COUNTY_COUNTY, String.class);

        if(stateFips == null){
            return null;
        }
        
        
        stateFips = stateFips.trim();
        countyFips = countyFips.trim();

        assert stateFips.length() == 2;

        String fips = "US" + stateFips;

        Site.StateEquivalent state  = (Site.StateEquivalent) Site.valueOfFIPS(fips);

        return state.getSubDivision(countyFips);
       
        
    }

    @Override
    protected Filter createFilter(final Hints hints, final FilterFactory2 factory, final FeatureSource source, final Site.CountyEquivalent county){
        try{
            //assume the parent is the state
            Site state = county.getParent();
            String stateCode = state.getFIPS();


            String countyCode = county.getPrimaryKey();

            //returns features that match the state and county
            String cql = COLUMN_COUNTY_STATE + " = '" + stateCode + "' AND " + COLUMN_COUNTY_COUNTY + " = '" + countyCode + "'";
            Filter filter = CQL.toFilter(cql);
            return filter;
        }
        catch(CQLException ce){
            LOGGER.warn("Unable to create CQL query.", ce);
            return null;
        }
    }



    @Override
    protected Class<Site.CountyEquivalent> getSupportedClass() {
        return Site.CountyEquivalent.class;
    }

    @Override
    protected boolean supports(FeatureSource source) {
        if(hasColumn(source, COLUMN_COUNTY_COUNTY, String.class) && hasColumn(source, COLUMN_COUNTY_D00_, Long.class) && hasColumn(source, COLUMN_COUNTY_D00_I, Long.class)){
            return true;
        }
        else{
            return false;
        }
    }
}