Ignore:
Timestamp:
11/03/11 11:13:40 (12 years ago)
Author:
wmerlotto
Message:

Ticket #2305 - Enviando alteracoes, desenvolvidas internamente na Prognus, do modulo services.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/services/class.db.php

    r5072 r5130  
    44* Copyright (C) 2011 Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br) 
    55* 
    6 * This program is free software; you can redistribute it and/or modify it under 
    7 * the terms of the GNU Affero General Public License version 3 as published by 
    8 * the Free Software Foundation with the addition of the following permission 
    9 * added to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED 
    10 * WORK IN WHICH THE COPYRIGHT IS OWNED BY FUNAMBOL, FUNAMBOL DISCLAIMS THE 
    11 * WARRANTY OF NON INFRINGEMENT  OF THIRD PARTY RIGHTS. 
    12 * 
    13 * This program is distributed in the hope that it will be useful, but WITHOUT 
    14 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 
    15 * FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more 
    16 * details. 
    17 * 
    18 * You should have received a copy of the GNU Affero General Public License 
    19 * along with this program; if not, see www.gnu.org/licenses or write to 
    20 * the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, 
    21 * MA 02110-1301 USA. 
    22 * 
    23 * This code is based on the OpenXchange Connector and on the Prognus pSync 
    24 * Connector both developed by the community and licensed under the GPL 
    25 * version 2 or above as published by the Free Software Foundation. 
     6*  This program is free software; you can redistribute it and/or 
     7*  modify it under the terms of the GNU General Public License 
     8*  as published by the Free Software Foundation; either version 2 
     9*  of the License, or (at your option) any later version. 
     10* 
     11*  This program is distributed in the hope that it will be useful, 
     12*  but WITHOUT ANY WARRANTY; without even the implied warranty of 
     13*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the 
     14*  GNU General Public License for more details. 
     15* 
     16*  You should have received a copy of the GNU General Public License 
     17*  along with this program; if not, write to the Free Software 
     18*  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.  
    2619* 
    2720* You can contact Prognus Software Livre headquarters at Av. Tancredo Neves, 
     
    2922* e-mail address prognus@prognus.com.br. 
    3023* 
    31 * Serviço de banco de dados 
    32 * 
    33 * Serviço que faz a busca no banco de dados para retornar os usuários, de acordo com o parâmetro de busca. 
    34 * 
    35 * @package    <services> 
     24* 
     25* @package    DBService 
    3626* @license    http://www.gnu.org/copyleft/gpl.html GPL 
    3727* @author     Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br) 
     28* @sponsor    Caixa Econômica Federal 
    3829* @version    1.0 
    39 * @sponsor    Caixa Econômica Federal 
     30* @since      2.4.0 
    4031*/ 
    4132 
     
    119110                                $query .= ' where ' 
    120111                                        . 'A.id_owner=' . $_SESSION['phpgw_info']['expressomail']['user']['account_id'] 
    121                                         . ' and names_ordered LIKE \'%' . $search_for . '%\'';                          
     112                                        . ' and lower(to_ascii(names_ordered)) LIKE lower(to_ascii(\'%' . $search_for . '%\'))';                          
    122113                                 
    123114        if (!$this->db->query($query)) 
Note: See TracChangeset for help on using the changeset viewer.