mirror of
https://github.com/salesagility/SuiteCRM.git
synced 2024-11-14 12:26:41 +00:00
74 lines
4.1 KiB
PHP
Executable File
74 lines
4.1 KiB
PHP
Executable File
<?php
|
|
/*
|
|
* Created on Aug 2, 2007
|
|
*
|
|
* To change the template for this generated file go to
|
|
* Window - Preferences - PHPeclipse - PHP - Code Templates
|
|
*/
|
|
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
/**
|
|
* Products, Quotations & Invoices modules.
|
|
* Extensions to SugarCRM
|
|
* @package Advanced OpenSales for SugarCRM
|
|
* @subpackage Products
|
|
* @copyright SalesAgility Ltd http://www.salesagility.com
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE as published by
|
|
* the Free Software Foundation; either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* 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 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
|
|
*
|
|
* @author SalesAgility Ltd <support@salesagility.com>
|
|
*/
|
|
$searchFields['AOS_Invoices'] =
|
|
array(
|
|
'name' => array( 'query_type'=>'default'),
|
|
'account_type'=> array('query_type'=>'default', 'options' => 'account_type_dom', 'template_var' => 'ACCOUNT_TYPE_OPTIONS'),
|
|
'industry'=> array('query_type'=>'default', 'options' => 'industry_dom', 'template_var' => 'INDUSTRY_OPTIONS'),
|
|
'annual_revenue'=> array('query_type'=>'default'),
|
|
'address_street'=> array('query_type'=>'default','db_field'=>array('billing_address_street','shipping_address_street')),
|
|
'address_city'=> array('query_type'=>'default','db_field'=>array('billing_address_city','shipping_address_city')),
|
|
'address_state'=> array('query_type'=>'default','db_field'=>array('billing_address_state','shipping_address_state')),
|
|
'address_postalcode'=> array('query_type'=>'default','db_field'=>array('billing_address_postalcode','shipping_address_postalcode')),
|
|
'address_country'=> array('query_type'=>'default','db_field'=>array('billing_address_country','shipping_address_country')),
|
|
'rating'=> array('query_type'=>'default'),
|
|
'phone'=> array('query_type'=>'default','db_field'=>array('phone_office')),
|
|
'email'=> array('query_type'=>'default','db_field'=>array('email1','email2')),
|
|
'website'=> array('query_type'=>'default'),
|
|
'ownership'=> array('query_type'=>'default'),
|
|
'employees'=> array('query_type'=>'default'),
|
|
'ticker_symbol'=> array('query_type'=>'default'),
|
|
'current_user_only'=> array('query_type'=>'default','db_field'=>array('assigned_user_id'),'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'),
|
|
'assigned_user_id'=> array('query_type'=>'default'),
|
|
'favorites_only' => array(
|
|
'query_type'=>'format',
|
|
'operator' => 'subquery',
|
|
'checked_only' => true,
|
|
'subquery' => "SELECT favorites.parent_id FROM favorites
|
|
WHERE favorites.deleted = 0
|
|
and favorites.parent_type = 'AOS_Invoices'
|
|
and favorites.assigned_user_id = '{1}'",
|
|
'db_field'=>array('id')),
|
|
//Range Search Support
|
|
'range_total_amount' => array('query_type' => 'default', 'enable_range_search' => true),
|
|
'start_range_total_amount' => array('query_type' => 'default', 'enable_range_search' => true),
|
|
'end_range_total_amount' => array('query_type' => 'default', 'enable_range_search' => true),
|
|
'range_due_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
|
|
'start_range_due_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
|
|
'end_range_due_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
|
|
|
|
);
|