0
0
mirror of https://github.com/salesagility/SuiteCRM.git synced 2024-11-14 12:26:41 +00:00
salesagility_SuiteCRM/modules/AOS_Invoices/metadata/SearchFields.php

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),
);