SITools2

fr.ias.sitools.converters.FileSizeConverter

fr.ias.sitools.converters.RaDecToXYZConverter

fr.ias.sitools.filters.basic.BooleanCorotAsteroAndExo

fr.ias.sitools.filters.basic.BooleanCustom

fr.ias.sitools.filters.basic.GroupCheckBoxMasterLigthCurves

fr.ias.sitools.filters.basic.NThreeVariability

fr.ias.sitools.filters.basic.TextFieldSQLLikeFilter

fr.ias.sitools.filters.basic.DateBeginEndFilter

fr.ias.sitools.filters.basic.SingleValueLikeFilter

fr.ias.sitools.filters.basic.ListBoxSpectralTypeCorot

fr.ias.sitools.filters.basic.ListBoxLumClassCorot

fr.ias.sitools.filters.basic.TextAreaCorotFilter

fr.ias.sitools.resources.spectrofits.GetFitsDataSpectroModel

fr.ias.sitools.resources.fits.ShowHeaderModel

fr.ias.sitools.astro.resolverName.CorotIdResolverModel

fr.ias.sitools.resources.vo.SimpleSpectralAccessResourceModel

fr.ias.sitools.resources.geojson.DatasetToJsonModel

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package fr.ias.sitools.astro.resolverName;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.ConstraintViolationLevel;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.plugins.resources.model.DataSetSelectionType;

import fr.cnes.sitools.plugins.resources.model.ResourceModel;

import fr.cnes.sitools.plugins.resources.model.ResourceParameter;

import fr.cnes.sitools.plugins.resources.model.ResourceParameterType;

import java.util.HashSet;

import java.util.Map;

import java.util.Set;

import java.util.logging.Level;

/**

 *

 * @author marc

 */

public class CorotIdResolverModel extends ResourceModel {

    public CorotIdResolverModel(){

        super();

        setClassAuthor("Marc NICOLAS");

        setClassOwner("IAS");

        setClassVersion("0.6.1");

        setName("Corot ID Resolver service");

        setDescription("This service provides a resolver name from corotID");

        setResourceClassName(fr.ias.sitools.astro.resolverName.CorotIdResolverResource.class.getName());

        ResourceParameter paramExo = new ResourceParameter("exoBool", "true if it's a exo dataset, false in other cases",

        ResourceParameterType.PARAMETER_USER_INPUT);

        paramExo.setValueType("xs:boolean");

        this.addParam(paramExo);

        ResourceParameter paramRaCol = new ResourceParameter("raCol", "Colum containing the right ascension.",

        ResourceParameterType.PARAMETER_INTERN);

        paramRaCol.setValueType("xs:dataset.columnAlias");

        this.addParam(paramRaCol);

        ResourceParameter paramDecCol = new ResourceParameter("decCol", "Colum containing the declination.",

        ResourceParameterType.PARAMETER_INTERN);

        paramDecCol.setValueType("xs:dataset.columnAlias");

        this.addParam(paramDecCol);

        ResourceParameter paramcorotIdCol = new ResourceParameter("corotIdCol", "Colum containing the Corot ID.",

        ResourceParameterType.PARAMETER_INTERN);

        paramcorotIdCol.setValueType("xs:dataset.columnAlias");

        this.addParam(paramcorotIdCol);

        this.setApplicationClassName(DataSetApplication.class.getName());

        this.setDataSetSelection(DataSetSelectionType.SINGLE);

        this.getParameterByName("methods").setValue("GET");

        this.completeAttachUrlWith("/corotIdResolver/EQUATORIAL/{corotID}");

    }

    @Override

  public Validator<ResourceModel> getValidator() {

      return new Validator<ResourceModel>() {

        @Override

        public Set<ConstraintViolation> validate(ResourceModel item) {

            Set<ConstraintViolation> constraints = new HashSet<ConstraintViolation>();

            Map<String, ResourceParameter> params = item.getParametersMap();

            ResourceParameter param = params.get("exoBool");

            String value = param.getValue();

            if (value == null || value.equals("")) {

                ConstraintViolation constraint = new ConstraintViolation();

                constraint.setMessage("The boolean exoBool must be set.");

                constraint.setLevel(ConstraintViolationLevel.CRITICAL);

                constraint.setValueName(param.getName());

                constraints.add(constraint);

            }

            param = params.get("raCol");

            value = param.getValue();

            if (value == null || value.equals("")) {

                ConstraintViolation constraint = new ConstraintViolation();

                constraint.setMessage("The attribute for RA must be set.");

                constraint.setLevel(ConstraintViolationLevel.CRITICAL);

                constraint.setValueName(param.getName());

                constraints.add(constraint);

            }

            param = params.get("decCol");

            value = param.getValue();

            if (value == null || value.equals("")) {

                ConstraintViolation constraint = new ConstraintViolation();

                constraint.setMessage("The attribute for DEC must be set.");

                constraint.setLevel(ConstraintViolationLevel.CRITICAL);

                constraint.setValueName(param.getName());

                constraints.add(constraint);

            }

            param = params.get("corotIdCol");

            value = param.getValue();

            if (value == null || value.equals("")) {

                ConstraintViolation constraint = new ConstraintViolation();

                constraint.setMessage("The attribute for CorotID must be set.");

                constraint.setLevel(ConstraintViolationLevel.CRITICAL);

                constraint.setValueName(param.getName());

                constraints.add(constraint);

            }

            return constraints;

        }

    };

  }

}

 /*******************************************************************************

 * Copyright 2010-2013 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 *

 * This file is part of SITools2.

 *

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * SITools2 is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.astro.resolverName;

import fr.cnes.sitools.astro.representation.GeoJsonRepresentation;

import fr.cnes.sitools.common.resource.SitoolsParameterizedResource;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.database.DatabaseRequest;

import fr.cnes.sitools.dataset.database.DatabaseRequestFactory;

import fr.cnes.sitools.dataset.database.DatabaseRequestParameters;

import fr.cnes.sitools.dataset.database.common.DataSetExplorerUtil;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Operator;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.datasource.jdbc.model.AttributeValue;

import fr.cnes.sitools.datasource.jdbc.model.Record;

import fr.cnes.sitools.extensions.astro.application.opensearch.datamodel.FeatureDataModel;

import fr.cnes.sitools.extensions.astro.application.opensearch.datamodel.FeaturesDataModel;

import fr.cnes.sitools.extensions.common.AstroCoordinate;

import fr.cnes.sitools.plugins.resources.model.ResourceParameter;

import fr.cnes.sitools.resources.order.utils.OrderResourceUtils;

import java.util.Map;

import java.util.logging.Level;

import org.restlet.Context;

import org.restlet.data.MediaType;

import org.restlet.data.Status;

import org.restlet.ext.wadl.MethodInfo;

import org.restlet.representation.Representation;

import org.restlet.representation.Variant;

import org.restlet.resource.Get;

import org.restlet.resource.ResourceException;

public class  CorotIdResolverResource extends SitoolsParameterizedResource{

    String  corotIDValueStr;

    Boolean exoBool;

    Double raValue;

    Double decValue;

    ResourceParameter corotIDParam;

    ResourceParameter raParam;

    ResourceParameter decParam;

    @Override

    public void sitoolsDescribe() {

        setName("CorotIdResolverResource");

        setDescription("Get Star coordinates from corotID");

    }

    @Override

    public void doInit() {

        super.doInit();

        this.corotIDValueStr = (String) this.getRequestAttributes().get("corotID");

        this.exoBool = Boolean.parseBoolean(getModel().getParametersMap().get("exoBool").getValue());

        try{

          int corotIdValuInt = Integer.parseInt(corotIDValueStr);

        }catch(NumberFormatException e){

            throw new ResourceException(Status.CLIENT_ERROR_BAD_REQUEST, "CorotID must be a number.");

        }

        if(this.corotIDValueStr.length() != 9 && exoBool){

            throw new ResourceException(Status.CLIENT_ERROR_BAD_REQUEST, "CorotID must be composed of 9 digits.");

        }

    }

    /**

    * Get HTML

    * 

    * @return Representation the HTML result

    */

    @Get

    public Representation getCorotIdResolver() {

        return execute();

    }

  @Override

  protected void describeGet(MethodInfo info) {

    this.addInfo(info);

    info.setIdentifier("get ra and dec coordinates from corotID");

    info.setDocumentation("Method to retrieve coordinates of a star from its corotID");

    addStandardGetRequestInfo(info);

    DataSetExplorerUtil.addDatasetExplorerGetRequestInfo(info);

    DataSetApplication application = (DataSetApplication) getApplication();

    DataSetExplorerUtil.addDatasetExplorerGetFilterInfo(info, application.getFilterChained());

    addStandardResponseInfo(info);

    addStandardInternalServerErrorInfo(info);

  }

  @Override

  protected Representation get(Variant variant) {

    Representation repr = super.get();

    if(repr == null){

        throw new ResourceException(Status.CLIENT_ERROR_NOT_FOUND,"No reccord matches with your query");

    }

    repr.setMediaType(MediaType.APPLICATION_JSON);

    return repr;

  }

  /**

   * Execute the request and return a Representation

   * 

   * @return the HTML representation

   */

  private Representation execute() {

    Representation repr = null;

    // Get context

    Context context = getContext();

    // generate the DatabaseRequest

    DataSetApplication datasetApp = (DataSetApplication) getApplication();

    DataSetExplorerUtil dsExplorerUtil = new DataSetExplorerUtil(datasetApp, getRequest(), getContext());

    this.corotIDParam = this.getModel().getParameterByName("corotIdCol");

    this.raParam = this.getModel().getParameterByName("raCol");

    this.decParam = this.getModel().getParameterByName("decCol");

    // Get request parameters

    if (datasetApp.getConverterChained() != null) {

      datasetApp.getConverterChained().getContext().getAttributes().put("REQUEST", getRequest());

    }

    // Get DatabaseRequestParameters

    DatabaseRequestParameters params = dsExplorerUtil.getDatabaseParams();

    DataSet ds = datasetApp.getDataSet();

    createQueryCorotID(params,ds);    

    DatabaseRequest databaseRequest = DatabaseRequestFactory.getDatabaseRequest(params);

      try {

          if (params.getDistinct()) {

            databaseRequest.createDistinctRequest();

        }else {

            databaseRequest.createRequest();

        }

        // Recuperation dans la base du fichiers fits

        context.getLogger().log(Level.INFO, "nbr de resultat : "+databaseRequest.getCount());

        while (databaseRequest.nextResult()) {

            Record rec = databaseRequest.getRecord();

            this.raValue = Double.parseDouble(OrderResourceUtils.getInParam(raParam, rec).getValue().toString());

            this.decValue = Double.parseDouble(OrderResourceUtils.getInParam(decParam, rec).getValue().toString());

            Map a = getDataModel();

            repr = new GeoJsonRepresentation(a);

        }

      } catch (Exception e) {

           throw new ResourceException(Status.SERVER_ERROR_INTERNAL,e.getMessage());

      }

    return repr;

  }

  public Map getDataModel(){

      final FeaturesDataModel features = new FeaturesDataModel();

      final FeatureDataModel feature = new FeatureDataModel();

      AstroCoordinate a = new AstroCoordinate(this.raValue,this.decValue);

      feature.createGeometry(String.format("[%s,%s]", this.raValue,this.decValue),"Point");

      feature.createCrs(a.getCoordinateSystem().getCrs());

      feature.addProperty("credits", "CDS");

      feature.addProperty("identifier", "CDS0");

      features.addFeature(feature);

      return features.getFeatures();

  }

  private void createQueryCorotID(DatabaseRequestParameters params, DataSet ds){

      Column corotIDCol = ds.findByColumnAlias(this.corotIDParam.getValue());

      Predicat pred = new Predicat();

      pred.setLogicOperator("AND");

      pred.setLeftAttribute(corotIDCol);

      pred.setCompareOperator(Operator.EQ);

      pred.setRightValue(this.corotIDValueStr);

      params.getPredicats().add(pred);

      if(exoBool){

        pred = new Predicat();

        Column en2WinDescCol = ds.findByColumnAlias("en2_windescriptor");

        pred.setLogicOperator("AND");

        pred.setLeftAttribute(en2WinDescCol);

        pred.setCompareOperator(Operator.EQ);

        pred.setRightValue("false");

        params.getPredicats().add(pred);

      }

  }

}

 /*******************************************************************************

 * Copyright 2010-2013 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 *

 * This file is part of SITools2.

 *

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * SITools2 is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.astro.resolverName.resource;

import fr.cnes.sitools.astro.resolver.AbstractNameResolver;

import fr.cnes.sitools.astro.resolver.NameResolverException;

import fr.cnes.sitools.astro.resolver.NameResolverResponse;

import fr.cnes.sitools.util.ClientResourceProxy;

import java.io.IOException;

import java.util.logging.Level;

import java.util.logging.Logger;

import org.json.JSONArray;

import org.json.JSONException;

import org.json.JSONObject;

import org.restlet.Client;

import org.restlet.data.Method;

import org.restlet.data.Protocol;

import org.restlet.data.Status;

import org.restlet.resource.ClientResource;

import org.restlet.resource.ResourceException;

/**

 * Queries the Corot name resolver and returns the list of coordinates for a given identifier.<br/> A CorotIdResolver lets you get a sky

 * position given a Corot identifier

 *

 * @author Marc NICOLAS <marc.nicolas@ias.u-psud.fr>

 */

public class CorotIdResolverAstero extends AbstractNameResolver {

  /**

   * Logger.

   */

  private static final Logger LOG = Logger.getLogger(CorotIdResolverAstero.class.getName());

  /**

   * Credits to return for CDS.

   */

  private static final String CREDITS_NAME = "IAS Astero/CNES";

  /**

   * Template URL for the Corot identifier resolver service.

   */

  private static final String TEMPLATE_NAME_RESOLVER = "http://idoc-corotn2-public-v2.ias.u-psud.fr/ds/astero/plugin/corotIdResolver/EQUATORIAL/<corotid>";

  /**

   * Corot service response.

   */

  private String corotId;

  /**

   * Empty constructor.

   */

  protected CorotIdResolverAstero() {

  }

  /**

   * Constructs a new CorotId resolver.

   *

   * @param corotIdVal Corot ID

   */

  public CorotIdResolverAstero(final String corotIdVal) {

    setCorotId(corotIdVal);

    checkInputParameters();      

  }

  /**

   * Sets the Corot Id.

   * @param corotIdVal the Corot ID to set

   */

  protected final void setCorotId(final String corotIdVal) {

      this.corotId = corotIdVal;

  }

  /**

   * Returns the Corot ID.

   * @return the Corot ID

   */

  protected final String getCorotId() {

      return this.corotId;

  }

  /**

   * Tests if the coroID is set.

   *

   * <p>

   * Returns IllegalArgumentException if <code>corotId</code> is <code>null</code> or empty.

   * </p>

   */

  protected final void checkInputParameters() {

    if (getCorotId() == null || getCorotId().isEmpty()) {

      throw new IllegalArgumentException("corotId must be set.");

    }

  }

  @Override

  public final NameResolverResponse getResponse() {

    NameResolverResponse response = new NameResolverResponse(CREDITS_NAME);

    LOG.log(Level.SEVERE, "JE RENTRE DANS LE NAMERESOLVERRESPONSE de l'Astero !!");

    try {

      final String query = TEMPLATE_NAME_RESOLVER.replace("<corotid>", corotId);   

      final JSONObject json = parseResponse(query);

      final String[] coordinates = parseCoordinates(json);

      final double rightAscension = Double.valueOf(coordinates[0]);

      final double declination = Double.valueOf(coordinates[1]);

      response.addAstroCoordinate(rightAscension, declination);

    } catch (NameResolverException ex) {

      if (getSuccessor() == null) {

        response.setError(ex);        

      } else {

        response = getSuccessor().getResponse();

      }

    } finally {

      return response;

    }

  }

  /**

   * Queries the SITools2 service at IAS and stores the result in <code>json</code>.

   *

   * @param query query the Corot service

   * @return the response from the server

   * @throws NameResolverException if a problem occurs while the response is being parsed

   */

  private JSONObject parseResponse(final String query) throws NameResolverException {

    assert query != null;

    LOG.log(Level.INFO, "Call IAS name resolver: {0}", query);

    final ClientResourceProxy proxy = new ClientResourceProxy(query, Method.GET);

    final ClientResource client = proxy.getClientResource();

    //client.setChallengeResponse(new ChallengeResponse(ChallengeScheme.HTTP_BASIC, "guest", "sitools2public"));

    final Client clientHTTP = new Client(Protocol.HTTP);

    clientHTTP.setConnectTimeout(AbstractNameResolver.SERVER_TIMEOUT);

    client.setNext(clientHTTP);

    final Status status = client.getStatus();

    if (status.isSuccess()) {

      JSONObject json;

      try {

        json = new JSONObject(client.get().getText());

      } catch (IOException ex) {

        throw new NameResolverException(Status.SERVER_ERROR_INTERNAL, ex);

      } catch (JSONException ex) {

        LOG.log(Level.WARNING, "the response of Corot server may changed");

        throw new NameResolverException(Status.CLIENT_ERROR_NOT_ACCEPTABLE, ex);

      } catch (ResourceException ex) {

        throw new NameResolverException(Status.SERVER_ERROR_SERVICE_UNAVAILABLE, ex);

      }

      return json;

    } else {

      throw new NameResolverException(status, status.getThrowable());

    }

  }

  /**

   * Parses the coordinates from CDS response and return them.

   * @param json the server's response

   * @return the following array [rightAscension,declination]

   * @throws NameResolverException - if empty response from Corot

   */

  private String[] parseCoordinates(final JSONObject json) throws NameResolverException {

    try {

      //final JSONArray jsonArray = json.getJSONArray("data");

      final JSONArray jsonArray = json.getJSONArray("features");

      final JSONArray coords  = jsonArray.getJSONObject(0).getJSONObject("geometry").getJSONArray("coordinates");

      if (jsonArray.length() != 1) {

        throw new NameResolverException(Status.CLIENT_ERROR_NOT_FOUND, "Not found");

      }

      if (coords.get(0).equals("") || coords.get(1).toString().equals("")) {

        throw new NameResolverException(Status.CLIENT_ERROR_NOT_FOUND, "Not found");

      }

      return new String[]{coords.get(0).toString(),coords.get(1).toString()};

    } catch (JSONException ex) {

      throw new NameResolverException(Status.SERVER_ERROR_INTERNAL, "cannot parse the coordinates");

    }

  }

}

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package fr.ias.sitools.converters;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.ConstraintViolationLevel;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.converter.business.AbstractConverter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameterType;

import fr.cnes.sitools.datasource.jdbc.model.AttributeValue;

import fr.cnes.sitools.datasource.jdbc.model.Record;

import java.util.HashSet;

import java.util.Map;

import java.util.Set;

import java.util.logging.Level;

import java.util.logging.Logger;

/**

 *

 * @author Marc

 */

public class FileSizeConverter extends AbstractConverter {

    /** Class logger */

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

    public FileSizeConverter() {

        this.setName("FileSizeConverter");

        this.setDescription("A converter applying an unit conversion from bytes into Kb or Mb or Gb");

        this.setClassAuthor("Marc NICOLAS");

        this.setClassOwner("IAS");

        this.setClassVersion("0.1");

        ConverterParameter colFileSize = new ConverterParameter("colFileSizeInBytes", "row of dataset with the filesize in bytes",ConverterParameterType.CONVERTER_PARAMETER_IN);

        ConverterParameter colFileSizeConvert = new ConverterParameter("colFileSizeConvert", "File Size converted", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        this.addParam(colFileSize);

        this.addParam(colFileSizeConvert);

        LOGGER.log(Level.INFO, "Converter :{0} version {1}", new Object[] { this.getName(), this.getClassVersion() });

    }   

    @Override

    public Record getConversionOf(Record record) throws Exception {

        Record out = record;

        String result = "";

        AttributeValue attrOut = this.getOutParam("colFileSizeConvert", out); 

        AttributeValue attrIn = this.getInParam("colFileSizeInBytes", out);

        if (!isNull(attrIn) && !isNull(attrOut)) {

            try{

                double input = Double.parseDouble(attrIn.getValue().toString());

                if(input>0 && input<1024){

                    result = (double)Math.round(input*10)/10 +" o";

                }else if(input >= 1024 && input < Math.pow(1024, 2) ){

                   result = (double)Math.round((input/1024)*10)/10+" Ko"; 

                }else if(input >=Math.pow(1024, 2) && input < Math.pow(1024, 3)){

                    result = (double)Math.round((input/Math.pow(1024, 2))*10)/10+" Mo" ;

                }else if( input >= Math.pow(1024, 3) && input < Math.pow(1024, 4)){

                    result = (double)Math.round((input/Math.pow(1024, 3))*10)/10+" Go" ;

                }

                if(!result.isEmpty()){

                    attrOut.setValue(result);

                }

            }catch (Exception e) {

                attrOut.setValue(Double.NaN);

            }

        }

        return out;

    }

   @Override

  public Validator<AbstractConverter> getValidator() {

    // TODO Auto-generated method stub

    return new Validator<AbstractConverter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractConverter item) {

        Set<ConstraintViolation> constraints = new HashSet<ConstraintViolation>();

        Map<String, ConverterParameter> params = item.getParametersMap();

        ConverterParameter param = params.get("colFileSizeInBytes");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the column with filesize in bytes data");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }

        param = params.get("colFileSizeConvert");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the output column");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }

        return constraints;

      }

    };

  }

}

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package fr.ias.sitools.converters;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.ConstraintViolationLevel;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.converter.business.AbstractConverter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameterType;

import fr.cnes.sitools.datasource.jdbc.model.AttributeValue;

import fr.cnes.sitools.datasource.jdbc.model.Record;

import java.util.HashSet;

import java.util.Map;

import java.util.Set;

import java.util.logging.Level;

import java.util.logging.Logger;

/**

 *

 * @author marc

 */

public class RaDecToXYZConverter extends AbstractConverter {

    /*

        Formule de changement de coordonée : 

            X=cos(DEC)*cos(RA)

            Y=cos(DEC)*sin(RA)

            Z=sin(DEC) 

    */

    /** Class logger */

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

    public RaDecToXYZConverter() {

        this.setName("RaDecToXYZConverter");

        this.setDescription("A converter applying an unit conversion from Ra and Dec into X, Y and Z coordinates");

        this.setClassAuthor("Marc NICOLAS");

        this.setClassOwner("IAS");

        this.setClassVersion("0.1");

        ConverterParameter colRa = new ConverterParameter("colRa", "row of dataset with the ra coordinate",ConverterParameterType.CONVERTER_PARAMETER_IN);

        ConverterParameter colDec = new ConverterParameter("colDec", "row of dataset with the dec coordinate",ConverterParameterType.CONVERTER_PARAMETER_IN);

        ConverterParameter colX = new ConverterParameter("colX", "Column for coordiante X", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        ConverterParameter colY = new ConverterParameter("colY", "Column for coordiante Y", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        ConverterParameter colZ = new ConverterParameter("colZ", "Column for coordiante Z", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        this.addParam(colRa);

        this.addParam(colDec);

        this.addParam(colX);

        this.addParam(colY);

        this.addParam(colZ);

        LOGGER.log(Level.INFO, "Converter :{0} version {1}", new Object[] { this.getName(), this.getClassVersion() });

    }

    @Override

    public Record getConversionOf(Record record) throws Exception {

        Record out = record;

        Double x, y, z;

        AttributeValue attrOutX = this.getOutParam("colX", out); 

        AttributeValue attrOutY = this.getOutParam("colY", out); 

        AttributeValue attrOutZ = this.getOutParam("colZ", out); 

        AttributeValue attrInRa = this.getInParam("colRa", out);

        AttributeValue attrInDec = this.getInParam("colDec", out);

        if(!isNull(attrInRa) && !isNull(attrInRa)/* && !isNull(attrOutX) && !isNull(attrOutY) && !isNull(attrOutZ)*/){

            try{

                Double ra = Double.parseDouble(attrInRa.getValue().toString());

                Double dec = Double.parseDouble(attrInDec.getValue().toString());

                x = Math.cos(dec)*Math.cos(ra);

                y = Math.cos(dec)*Math.sin(ra);

                z = Math.sin(dec);

               if(!x.isNaN()){

                   attrOutX.setValue(x);

               }

               if(!y.isNaN()){

                   attrOutY.setValue(y);

               }

               if(!z.isNaN()){

                   attrOutZ.setValue(z);

               }

            }catch(NumberFormatException e){

            }

        }

        return out;

    }

    @Override

    public Validator<?> getValidator() {

        // TODO Auto-generated method stub

    return new Validator<AbstractConverter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractConverter item) {

        Set<ConstraintViolation> constraints = new HashSet<ConstraintViolation>();

        /*Map<String, ConverterParameter> params = item.getParametersMap();

        ConverterParameter param = params.get("colFileSizeInBytes");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the column with filesize in bytes data");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }

        param = params.get("colFileSizeConvert");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the output column");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }*/

        return constraints;

      }

    };

    }

}

package fr.ias.sitools.filters.basic;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

//import java.util.logging.Logger;

import org.restlet.Request;

import org.restlet.data.Form;

import org.restlet.ext.wadl.ParameterInfo;

import org.restlet.ext.wadl.ParameterStyle;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.database.common.RequestFactory;

import fr.cnes.sitools.dataset.database.jdbc.RequestSql;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.dataset.plugins.filters.core.AbstractFormFilter;

import fr.cnes.sitools.datasource.jdbc.business.SitoolsSQLDataSource;

import fr.cnes.sitools.datasource.jdbc.business.SitoolsSQLDataSourceFactory;

import fr.cnes.sitools.util.SQLUtils;

public class BooleanCorotAsteroAndExo extends AbstractFormFilter {

  /**

   * The index of TYPE

   */

  private static final int TYPE = 0;

  /**

   * The index of COLUMN

   */

  private static final int COLUMN = 1;

  /**

   * The index of Values

   */

  private static final int VALUES = 2;

  /**

   * The number of values

   */

  private static final int NUMBER_OF_VALUES = 4;

  private String[] values;

  private enum TYPE_COMPONENT {

    /** DefaultType */

    BOOLEAN_CHECKBOX_COROT,

    CHECKBOX_COROT_ASTERO

  } 

 // private static final Logger LOGGER = Logger.getLogger(BooleanCorot.class.getName());

  public BooleanCorotAsteroAndExo() {

    super();

    this.setName("BooleanCorotAsteroAndExo");

    this.setDescription("Required when using BooleanCorot for exo or astero data checkbox");

    this.setClassAuthor("MNICOLAS");

    this.setClassOwner("IAS");

    this.setClassVersion("0.1");

    this.setDefaultFilter(true);

    HashMap<String, ParameterInfo> rpd = new HashMap<String, ParameterInfo>();

     ParameterInfo param1 = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY, "BOOLEAN_CHECKBOX_COROT|columnAlias1,columnAlias2" +

     		",columnAlias3,columnAlias4|long|short|center|anticenter");

     rpd.put("0", param1);

     ParameterInfo param2 = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY, "CHECKBOX_COROT_ASTERO|columnAlias1,columnAlias2" +

     		",columnAlias3,columnAlias4|long|short|center|anticenter");

     rpd.put("1", param2);

     this.setRequestParamsDescription(rpd);

  }

  @Override

  public List<Predicat> createPredicats(Request request, List<Predicat> predicats) throws Exception {

    DataSetApplication dsApplication = (DataSetApplication) getContext().getAttributes().get("DataSetApplication");

    DataSet ds =  dsApplication.getDataSet();

    Form params = request.getResourceRef().getQueryAsForm();

    boolean filterExists = true;

    int i = 0;

    while (filterExists) {

      String index = TEMPLATE_PARAM.replace("#", Integer.toString(i++));

      String formParam = params.getFirstValue(index);

      if (formParam != null) {

        String[] parameters = formParam.split("\\|");

        TYPE_COMPONENT[] types = TYPE_COMPONENT.values();

        Boolean trouve = false;

        for (TYPE_COMPONENT typeCmp : types) {

          if (typeCmp.name().equals(parameters[TYPE])) {

            trouve = true;

          }

        }

        if (trouve) {

          if (checkValues(parameters)) {

            String[] columnsAlias = parameters[COLUMN].split(",");

            ArrayList<Column> columns = new ArrayList<Column>();

            for (String columnAlias : columnsAlias) {

              Column col = ds.findByColumnAlias(columnAlias);

              if (col != null) {

                columns.add(col);

              }

            }

            SitoolsSQLDataSource dsource = SitoolsSQLDataSourceFactory.getDataSource(ds.getDatasource().getId());

            RequestSql requestSql = RequestFactory.getRequest(dsource.getDsModel().getDriverClass());

            String longRunColStr = requestSql.convertColumnToString(columns.get(0));

            String shortRunColStr = requestSql.convertColumnToString(columns.get(1));

            String centerColStr = requestSql.convertColumnToString(columns.get(2));

            String anticenterColStr = requestSql.convertColumnToString(columns.get(3));

            boolean longRunValue = Boolean.valueOf(SQLUtils.escapeString(values[0]));

            boolean shortRunValue = Boolean.valueOf(SQLUtils.escapeString(values[1]));

            boolean centerValue = Boolean.valueOf(SQLUtils.escapeString(values[2]));

            boolean anticenterValue = Boolean.valueOf(SQLUtils.escapeString(values[3]));

            Predicat predicat = new Predicat();

            predicat.setStringDefinition(" AND ("+longRunColStr+" = "+longRunValue+" OR "+shortRunColStr+" = "+shortRunValue+")"+" AND ("+centerColStr+ " = "+ centerValue+" OR "+anticenterColStr+" = "+anticenterValue+")");

            predicats.add(predicat);

          }

        }

      }else {

        filterExists = false;

      }

    }

   return predicats;

  }

  /**

   * Check the number of values

   * 

   * @param parameters

   *          the values

   * @return true if the number of values is correct

   */

  private boolean checkValues(String[] parameters) {

    values = Arrays.copyOfRange(parameters, VALUES, VALUES + NUMBER_OF_VALUES);

    if (values.length == NUMBER_OF_VALUES) {

      return true;

    }

    return false;

  }

  @Override

  public Validator<?> getValidator() {

    // TODO Auto-generated method stub

    return null;

  }

}

/*******************************************************************************

 * Copyright 2011 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 * 

 * This file is part of SITools2.

 * 

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 * 

 * SITools2 is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.filters.basic;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Set;

import java.util.logging.Logger;

import org.restlet.Request;

import org.restlet.data.Form;

import org.restlet.ext.wadl.ParameterInfo;

import org.restlet.ext.wadl.ParameterStyle;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.filter.business.AbstractFilter;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Operator;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.util.SQLUtils;

/**

 * Filter defined for Single Value Component

 * 

 * 

 * @author d.arpin

 */

public final class BooleanCustom extends AbstractFilter {

  /**

   * The index of TYPE

   */

  private static final int TYPE = 0;

  /**

   * The index of COLUMN

   */

  private static final int COLUMN = 1;

  /**

   * The index of Values

   */

  private static final int VALUES = 2;

  /**

   * The number of values

   */

  private static final int NUMBER_OF_VALUES = 1;

  /**

   * The list of component that uses this filter

   */

  private enum TYPE_COMPONENT {

    /** Boolean Custom type */

    BOOLEAN_CUSTOM

  }

  private String[] values;

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

  /** The TEMPLATE_PARAM */

  private static final String TEMPLATE_PARAM = "p[#]";

  /**

   * Default constructor

   */

  public BooleanCustom() {

    super();

    this.setName("BooleanCustom");

    this.setDescription("Required when using Boolean Custom Component");

    this.setClassAuthor("Marc NICOLAS");

    this.setClassOwner("IAS");

    this.setClassVersion("0.9");

    this.setDefaultFilter(true);

    HashMap<String, ParameterInfo> rpd = new HashMap<String, ParameterInfo>();

    ParameterInfo paramInfo;

    paramInfo = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY, "BOOLEAN_CUSTOM|columnAlias|value");

    rpd.put("0", paramInfo);

    this.setRequestParamsDescription(rpd);

  }

  @Override

  public List<Predicat> createPredicats(Request request, List<Predicat> predicats) throws Exception {

    DataSetApplication dsApplication = (DataSetApplication) getContext().getAttributes().get("DataSetApplication");

    DataSet ds = dsApplication.getDataSet();

    Form params = request.getResourceRef().getQueryAsForm();

    boolean filterExists = true;

    int i = 0;

    // Build predicat for filters param

    while (filterExists) {

      String index = TEMPLATE_PARAM.replace("#", Integer.toString(i++));

      String formParam = params.getFirstValue(index);

      if (formParam != null) {

        String[] parameters = formParam.split("\\|");

        TYPE_COMPONENT[] types = TYPE_COMPONENT.values();

        Boolean trouve = false;

        for (TYPE_COMPONENT typeCmp : types) {

          if (typeCmp.name().equals(parameters[TYPE])) {

            trouve = true;

          }

        }

        if (trouve) {

          if (checkValues(parameters)) {

            String columnAlias = null;

            if (parameters.length >= VALUES) {

              columnAlias = parameters[COLUMN];

              Column col = ds.findByColumnAlias(columnAlias);

              if (col != null && col.getFilter() != null && col.getFilter()) {

                // get the value and escape it to avoid SQL injection

                String value = SQLUtils.escapeString(parameters[VALUES]);

                Predicat predicat = new Predicat();

                if (value != null) {

                  predicat.setLeftAttribute(col);

                  predicat.setNbOpenedParanthesis(0);

                  predicat.setNbClosedParanthesis(0);

                  predicat.setCompareOperator(Operator.EQ);

                  predicat.setRightValue("'" + value + "'");

                  if(value.equalsIgnoreCase("false")){

                    predicats.add(predicat);

                  }

                }

              }

            }

          }

        }

      }

      else {

        filterExists = false;

      }

    }

    return predicats;

  }

  /**

   * Check the number of values

   * 

   * @param parameters

   *          the values

   * @return true if the number of values is correct

   */

  private boolean checkValues(String[] parameters) {

    if(parameters.length >= 3){ 

      values = Arrays.copyOfRange(parameters, VALUES, VALUES + NUMBER_OF_VALUES);

      if (values.length == NUMBER_OF_VALUES) {

        return true;

      }

      return false;

    }else{

      return false;

    }

  }

  /**

   * Gets the validator for this Filter

   * 

   * @return the validator for the filter

   */

  @Override

  public Validator<AbstractFilter> getValidator() {

    return new Validator<AbstractFilter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractFilter item) {

        // TODO Auto-generated method stub

        return null;

      }

    };

  }

}

/*******************************************************************************

 * Copyright 2011 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 * 

 * This file is part of SITools2.

 * 

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 * 

 * SITools2 is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.filters.basic;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Set;

import org.restlet.Request;

import org.restlet.data.Form;

import org.restlet.ext.wadl.ParameterInfo;

import org.restlet.ext.wadl.ParameterStyle;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.filter.business.AbstractFilter;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Operator;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.util.SQLUtils;

/**

 * Filter defined for Date Between Component

 * 

 * 

 * @author d.arpin

 * <a href="https://sourceforge.net/tracker/?func=detail&atid=2158259&aid=3411383&group_id=531341">[3411383]</a><br/>

 * 2011/09/19 d.arpin {add quotes arround date Value}

 */

public final class DateBeginEndFilter extends AbstractFilter {

  /**

   * The index of TYPE

   */

  private static final int TYPE = 0;

  /**

   * The index of COLUMN

   */

  private static final int COLUMN = 1;

  /**

   * The index of Values

   */

  private static final int VALUES = 2;

  /** The TEMPLATE_PARAM */

  private static final String TEMPLATE_PARAM = "p[#]";

  /**

   * the values from to

   */

  private String[] values;

  /**

   * The list of component that uses this filter

   */

  private enum TYPE_COMPONENT {

    /** DefaultType */

    DATE_BEGIN_END

  }

  /**

   * Default constructor

   */

  public DateBeginEndFilter() {

    super();

    this.setName("DateBeginEndFilter");

    this.setDescription("Required when using Date Between Components between 2 columns");

    this.setClassAuthor("HUSSON@IAS");

    this.setClassAuthor("HUSSON@IAS");

    this.setClassOwner("IAS");

    this.setClassVersion("0.1");

    this.setDefaultFilter(true);

    HashMap<String, ParameterInfo> rpd = new HashMap<String, ParameterInfo>();

    ParameterInfo paramInfo;

    paramInfo = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY,

    "DATE_BEGIN_END|columnFrom,columnTo|valueFrom|valueTo");

    rpd.put("0", paramInfo);

    this.setRequestParamsDescription(rpd);

    //

  }

  @Override

  public List<Predicat> createPredicats(Request request, List<Predicat> predicats) throws Exception {

    // Get the dataset

    DataSetApplication dsApplication = null;

    DataSet ds = null;

    Form params = request.getResourceRef().getQueryAsForm();

    boolean filterExists = true;

    int i = 0;

    // Build predicat for filters param

    while (filterExists) {

      String index = TEMPLATE_PARAM.replace("#", Integer.toString(i++));

      String formParam = params.getFirstValue(index);

      if (formParam != null) {

        String[] parameters = formParam.split("\\|");

        TYPE_COMPONENT[] types = TYPE_COMPONENT.values();

        Boolean trouve = false;

        for (TYPE_COMPONENT typeCmp : types) {

          if (typeCmp.name().equals(parameters[TYPE])) {

            trouve = true;

          }

        }

        if (trouve) {

          if (dsApplication == null) {

            dsApplication = (DataSetApplication) getContext().getAttributes().get("DataSetApplication");

            ds = dsApplication.getDataSet();

          }

          String columnfrom = null;

          String columnto = null;

          if (parameters.length >= VALUES) {

            columnfrom = parameters[COLUMN].split(",")[0];

            columnto = parameters[COLUMN].split(",")[1];

            Column colfrom = ds.findByColumnAlias(columnfrom);

            Column colto = ds.findByColumnAlias(columnto);

            if (colfrom != null && colfrom.getFilter() != null && colfrom.getFilter() && checkValues(parameters) && colto != null && colto.getFilter() != null && colto.getFilter()) {

              // escape the values to avoid SQL injection

              String valuefrom = "'" + SQLUtils.escapeString(values[0]) + "'";

              String valueto = "'" + SQLUtils.escapeString(values[1]) + "'";

              Predicat predicat = new Predicat();

              predicat.setLeftAttribute(colfrom);

              predicat.setNbOpenedParanthesis(1);

              predicat.setNbClosedParanthesis(0);

              predicat.setCompareOperator(Operator.GTE);

              predicat.setRightValue(valuefrom);

              predicats.add(predicat);

              predicat = new Predicat();

              predicat.setLeftAttribute(colto);

              predicat.setNbOpenedParanthesis(0);

              predicat.setNbClosedParanthesis(1);

              predicat.setCompareOperator(Operator.LTE);

              predicat.setRightValue(valueto);

              predicats.add(predicat);

            }

          }

        }

      }

      else {

        filterExists = false;

      }

    }

    return predicats;

  }

  /**

   * Check values of the form

   * 

   * @param parameters

   *          the parameters of the filter

   * @return true if values agree

   */

  private boolean checkValues(String[] parameters) {

    values = Arrays.copyOfRange(parameters, VALUES, parameters.length);

    if (values.length == 2) {

      return true;

    }

    return false;

  }

  /**

   * Gets the validator for this Filter

   * 

   * @return the validator for the filter

   */

  @Override

  public Validator<AbstractFilter> getValidator() {

    return new Validator<AbstractFilter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractFilter item) {

        return null;

      }

    };

  }

}

package fr.ias.sitools.filters.basic;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import org.restlet.Request;

import org.restlet.data.Form;

import org.restlet.ext.wadl.ParameterInfo;

import org.restlet.ext.wadl.ParameterStyle;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Operator;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.dataset.plugins.filters.core.AbstractFormFilter;

import fr.cnes.sitools.util.SQLUtils;

public class GroupCheckBoxMasterLigthCurves extends AbstractFormFilter {

  /**

   * The index of TYPE

   */

  private static final int TYPE = 0;

  /**

   * The index of COLUMN

   */

  private static final int COLUMN = 1;

  /**

   * The index of Values

   */

  private static final int VALUES = 2;

  /**

   * The number of values

   */

  private static final int NUMBER_OF_VALUES = 4;

  private String[] values;

  private enum TYPE_COMPONENT {

    /** DefaultType */

    GROUP_CHECKBOX_LIGHTCURVES_COROT

  } 

  //private static final Logger LOGGER = Logger.getLogger(GroupCheckBoxMasterLigthCurves.class.getName());

  public GroupCheckBoxMasterLigthCurves() {

    super();

    this.setName("GroupCheckBoxLightCurves");

    this.setDescription("Required when using the LightCurves checkbox component");

    this.setClassAuthor("MNICOLAS");

    this.setClassOwner("IAS");

    this.setClassVersion("0.1");

    this.setDefaultFilter(true);

    HashMap<String, ParameterInfo> rpd = new HashMap<String, ParameterInfo>();

     ParameterInfo param1 = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY, "GROUP_CHECKBOX_LIGHTCURVES_COROT|columnAlias1,columnAlias2" +

     		",columnAlias3,columnAlias4|starChr|starMon|star512|star32");

     rpd.put("0", param1);

     this.setRequestParamsDescription(rpd);

  }

  @Override

  public List<Predicat> createPredicats(Request request, List<Predicat> predicats) throws Exception {

    DataSetApplication dsApplication = (DataSetApplication) getContext().getAttributes().get("DataSetApplication");

    DataSet ds =  dsApplication.getDataSet();

    Form params = request.getResourceRef().getQueryAsForm();

    boolean filterExists = true;