<?PHP
/*********************************************************************************
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program 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 Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/

/**
 * THIS CLASS IS FOR DEVELOPERS TO MAKE CUSTOMIZATIONS IN
 */
require_once('modules/COMM1_communications/COMM1_communications_sugar.php');
class COMM1_communications extends COMM1_communications_sugar {
	
    function COMM1_communications(){	
        parent::COMM1_communications_sugar();
    }
    

    
    function create_new_list_query(){
        if(isset($_REQUEST['action']) && $_REQUEST['action']  == 'quicksearchQuery'){
            //decho print_r($_REQUEST,true);exit;
            $objS = new SugarBean();
            $objS->table_name = "comm1_communications";
            return $objS->create_new_list_query("name","comm1_communications.name LIKE '%".$_REQUEST['query']."%' ");
        }
        $return_array = Array();
/*Inicio Traer clientes de campañas feb 22 diego*/		
        $return_array['select'] = "SELECT con.id";                  
        $return_array['from'] = " FROM contacts con

                             LEFT JOIN contacts_cstm cstm ON con.id = cstm.id_c ";
                                      
        $return_array['where'] = " WHERE 1=1  
                                     AND con.do_not_call = 0 
                                     AND con.deleted = 0 ";

        $return_array['order_by'] = "";

        return  $return_array;
/*Final Traer clientes de campañas feb 22 diego*/	
    }
}		
	
       /* $return_array['select'] = "SELECT con.*,
                                          con.first_name,
                                            (
                                            SELECT
                                                tiend.name
                                            FROM
                                                stu_tiendas_contacts_c stu
                                                    INNER JOIN
                                                        stu_tiendas tiend ON
                                                            tiend.id = stu.stu_tiendas_contactsstu_tiendas_ida
                                            WHERE
                                                stu.stu_tiendas_contactscontacts_idb = con.id
                                            LIMIT 1
                                           )as name_tienda,                    
                                          
                                          cstm.cedula_nit_c,ema.email_address,'' AS CUSTOM_Q ";
        $return_array['from'] = " FROM 
                                    contacts con
                                        LEFT JOIN
                                            contacts_cstm cstm ON
                                                con.id = cstm.id_c
                                        LEFT JOIN
                                            (
                                                (SELECT id,bean_id,email_address_id FROM email_addr_bean_rel WHERE primary_address = 1 AND deleted = 0) bean 
                                                    INNER JOIN
                                                        email_addresses ema ON
                                                            bean.email_address_id = ema.id
                                            )
                                            ON
                                            con.id = bean.bean_id 
                                            
                                ";
        $return_array['where'] = " where 1=1 AND con.do_not_call = 0 AND con.deleted = 0 ";
        $return_array['order_by'] = "";

        return  $return_array;
		}
}*/
?>	