protected function getCriteriaStringQuery($searchFilter)
  {
    $query = "";
    $c = $this->getCriteria($searchFilter);
     //type de transactions
   $type = array();
    if (is_array($searchFilter['transaction_type']) && in_array('location',$searchFilter['transaction_type']) && !in_array('vente',$searchFilter['transaction_type']))
    {
      $query=$query.'AND (location = true AND vente = false) ';
    }
    if (is_array($searchFilter['transaction_type']) && in_array('vente',$searchFilter['transaction_type']) && !in_array('location',$searchFilter['transaction_type']))
    {
      $query=$query.'AND (vente = true AND location = false) ';
    }
    if (is_array($searchFilter['transaction_type']) && in_array('vente',$searchFilter['transaction_type']) && in_array('location',$searchFilter['transaction_type']))
    {
      $query=$query.'AND (vente = true AND location = true) ';
    }

    //natures
    if (isset($searchFilter['natures']) && $searchFilter['natures'])
    {
      $query=$query.'AND (ref_property_nature_id_array && \'{'.implode(',',$searchFilter['natures']).'}\') ';
    }

    $query = $query.'AND ('.personalizedHelper::retrieveWhereFromCriteria($c).') ';

    return $query;
  }