@@ -77,9 +77,9 @@ discard block |
||
77 | 77 | /** |
78 | 78 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
79 | 79 | */ |
80 | - function AOR_Condition(){ |
|
80 | + function AOR_Condition() { |
|
81 | 81 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
82 | - if(isset($GLOBALS['log'])) { |
|
82 | + if (isset($GLOBALS['log'])) { |
|
83 | 83 | $GLOBALS['log']->deprecated($deprecatedMessage); |
84 | 84 | } |
85 | 85 | else { |
@@ -95,38 +95,38 @@ discard block |
||
95 | 95 | require_once('modules/AOW_WorkFlow/aow_utils.php'); |
96 | 96 | |
97 | 97 | $j = 0; |
98 | - foreach ($post_data[$key . 'field'] as $i => $field) { |
|
98 | + foreach ($post_data[$key.'field'] as $i => $field) { |
|
99 | 99 | |
100 | - if ($post_data[$key . 'deleted'][$i] == 1) { |
|
101 | - $this->mark_deleted($post_data[$key . 'id'][$i]); |
|
100 | + if ($post_data[$key.'deleted'][$i] == 1) { |
|
101 | + $this->mark_deleted($post_data[$key.'id'][$i]); |
|
102 | 102 | } else { |
103 | 103 | $condition = new AOR_Condition(); |
104 | 104 | foreach ($this->field_defs as $field_def) { |
105 | 105 | $field_name = $field_def['name']; |
106 | - if (isset($post_data[$key . $field_name][$i])) { |
|
107 | - if (is_array($post_data[$key . $field_name][$i])) { |
|
106 | + if (isset($post_data[$key.$field_name][$i])) { |
|
107 | + if (is_array($post_data[$key.$field_name][$i])) { |
|
108 | 108 | |
109 | 109 | switch ($condition->value_type) { |
110 | 110 | case 'Date': |
111 | - $post_data[$key . $field_name][$i] = base64_encode(serialize($post_data[$key . $field_name][$i])); |
|
111 | + $post_data[$key.$field_name][$i] = base64_encode(serialize($post_data[$key.$field_name][$i])); |
|
112 | 112 | break; |
113 | 113 | default: |
114 | - $post_data[$key . $field_name][$i] = encodeMultienumValue($post_data[$key . $field_name][$i]); |
|
114 | + $post_data[$key.$field_name][$i] = encodeMultienumValue($post_data[$key.$field_name][$i]); |
|
115 | 115 | } |
116 | - } else if ($field_name == 'value' && $post_data[$key . 'value_type'][$i] === 'Value') { |
|
117 | - $post_data[$key . $field_name][$i] = fixUpFormatting($_REQUEST['report_module'], $condition->field, $post_data[$key . $field_name][$i]); |
|
116 | + } else if ($field_name == 'value' && $post_data[$key.'value_type'][$i] === 'Value') { |
|
117 | + $post_data[$key.$field_name][$i] = fixUpFormatting($_REQUEST['report_module'], $condition->field, $post_data[$key.$field_name][$i]); |
|
118 | 118 | } else if ($field_name == 'parameter') { |
119 | - $post_data[$key . $field_name][$i] = isset($post_data[$key . $field_name][$i]); |
|
119 | + $post_data[$key.$field_name][$i] = isset($post_data[$key.$field_name][$i]); |
|
120 | 120 | } else if ($field_name == 'module_path') { |
121 | - $post_data[$key . $field_name][$i] = base64_encode(serialize(explode(":", $post_data[$key . $field_name][$i]))); |
|
121 | + $post_data[$key.$field_name][$i] = base64_encode(serialize(explode(":", $post_data[$key.$field_name][$i]))); |
|
122 | 122 | } |
123 | - if ($field_name == 'parenthesis' && $post_data[$key . $field_name][$i] == 'END') { |
|
123 | + if ($field_name == 'parenthesis' && $post_data[$key.$field_name][$i] == 'END') { |
|
124 | 124 | if (!isset($lastParenthesisStartConditionId)) { |
125 | 125 | throw new Exception('a closure parenthesis has no starter pair'); |
126 | 126 | } |
127 | 127 | $condition->parenthesis = $lastParenthesisStartConditionId; |
128 | 128 | } else { |
129 | - $condition->$field_name = $post_data[$key . $field_name][$i]; |
|
129 | + $condition->$field_name = $post_data[$key.$field_name][$i]; |
|
130 | 130 | } |
131 | 131 | } else if ($field_name == 'parameter') { |
132 | 132 | $condition->$field_name = 0; |
@@ -1,16 +1,16 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | // created: 2013-05-07 12:48:58 |
3 | 3 | global $current_user; |
4 | -$searchFields['AOS_Products'] = array ( |
|
4 | +$searchFields['AOS_Products'] = array( |
|
5 | 5 | 'name' => |
6 | - array ( |
|
6 | + array( |
|
7 | 7 | 'query_type' => 'default', |
8 | 8 | ), |
9 | 9 | 'current_user_only' => |
10 | - array ( |
|
10 | + array( |
|
11 | 11 | 'query_type' => 'default', |
12 | 12 | 'db_field' => |
13 | - array ( |
|
13 | + array( |
|
14 | 14 | 0 => 'created_by', |
15 | 15 | ), |
16 | 16 | 'my_items' => true, |
@@ -18,67 +18,67 @@ discard block |
||
18 | 18 | 'type' => 'bool', |
19 | 19 | ), |
20 | 20 | 'range_price' => |
21 | - array ( |
|
21 | + array( |
|
22 | 22 | 'query_type' => 'default', |
23 | 23 | 'enable_range_search' => true, |
24 | 24 | ), |
25 | 25 | 'start_range_price' => |
26 | - array ( |
|
26 | + array( |
|
27 | 27 | 'query_type' => 'default', |
28 | 28 | 'enable_range_search' => true, |
29 | 29 | ), |
30 | 30 | 'end_range_price' => |
31 | - array ( |
|
31 | + array( |
|
32 | 32 | 'query_type' => 'default', |
33 | 33 | 'enable_range_search' => true, |
34 | 34 | ), |
35 | 35 | 'range_cost' => |
36 | - array ( |
|
36 | + array( |
|
37 | 37 | 'query_type' => 'default', |
38 | 38 | 'enable_range_search' => true, |
39 | 39 | ), |
40 | 40 | 'start_range_cost' => |
41 | - array ( |
|
41 | + array( |
|
42 | 42 | 'query_type' => 'default', |
43 | 43 | 'enable_range_search' => true, |
44 | 44 | ), |
45 | 45 | 'end_range_cost' => |
46 | - array ( |
|
46 | + array( |
|
47 | 47 | 'query_type' => 'default', |
48 | 48 | 'enable_range_search' => true, |
49 | 49 | ), |
50 | 50 | 'range_date_entered' => |
51 | - array ( |
|
51 | + array( |
|
52 | 52 | 'query_type' => 'default', |
53 | 53 | 'enable_range_search' => true, |
54 | 54 | 'is_date_field' => true, |
55 | 55 | ), |
56 | 56 | 'start_range_date_entered' => |
57 | - array ( |
|
57 | + array( |
|
58 | 58 | 'query_type' => 'default', |
59 | 59 | 'enable_range_search' => true, |
60 | 60 | 'is_date_field' => true, |
61 | 61 | ), |
62 | 62 | 'end_range_date_entered' => |
63 | - array ( |
|
63 | + array( |
|
64 | 64 | 'query_type' => 'default', |
65 | 65 | 'enable_range_search' => true, |
66 | 66 | 'is_date_field' => true, |
67 | 67 | ), |
68 | 68 | 'range_date_modified' => |
69 | - array ( |
|
69 | + array( |
|
70 | 70 | 'query_type' => 'default', |
71 | 71 | 'enable_range_search' => true, |
72 | 72 | 'is_date_field' => true, |
73 | 73 | ), |
74 | 74 | 'start_range_date_modified' => |
75 | - array ( |
|
75 | + array( |
|
76 | 76 | 'query_type' => 'default', |
77 | 77 | 'enable_range_search' => true, |
78 | 78 | 'is_date_field' => true, |
79 | 79 | ), |
80 | 80 | 'end_range_date_modified' => |
81 | - array ( |
|
81 | + array( |
|
82 | 82 | 'query_type' => 'default', |
83 | 83 | 'enable_range_search' => true, |
84 | 84 | 'is_date_field' => true, |
@@ -89,6 +89,6 @@ discard block |
||
89 | 89 | 'subquery' => "SELECT favorites.parent_id FROM favorites |
90 | 90 | WHERE favorites.deleted = 0 |
91 | 91 | and favorites.parent_type = '".$module_name."' |
92 | - and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
|
92 | + and favorites.assigned_user_id = '" .$current_user->id."') OR NOT ({0}", |
|
93 | 93 | 'db_field'=>array('id')), |
94 | 94 | ); |
95 | 95 | \ No newline at end of file |
@@ -2,79 +2,79 @@ discard block |
||
2 | 2 | // created: 2015-02-17 15:14:28 |
3 | 3 | global $current_user; |
4 | 4 | $module_name = "Documents"; |
5 | -$searchFields['Documents'] = array ( |
|
5 | +$searchFields['Documents'] = array( |
|
6 | 6 | 'document_name' => |
7 | - array ( |
|
7 | + array( |
|
8 | 8 | 'query_type' => 'default', |
9 | 9 | ), |
10 | 10 | 'category_id' => |
11 | - array ( |
|
11 | + array( |
|
12 | 12 | 'query_type' => 'default', |
13 | 13 | 'options' => 'document_category_dom', |
14 | 14 | 'template_var' => 'CATEGORY_OPTIONS', |
15 | 15 | ), |
16 | 16 | 'subcategory_id' => |
17 | - array ( |
|
17 | + array( |
|
18 | 18 | 'query_type' => 'default', |
19 | 19 | 'options' => 'document_subcategory_dom', |
20 | 20 | 'template_var' => 'SUBCATEGORY_OPTIONS', |
21 | 21 | ), |
22 | 22 | 'active_date' => |
23 | - array ( |
|
23 | + array( |
|
24 | 24 | 'query_type' => 'default', |
25 | 25 | ), |
26 | 26 | 'exp_date' => |
27 | - array ( |
|
27 | + array( |
|
28 | 28 | 'query_type' => 'default', |
29 | 29 | ), |
30 | 30 | 'assigned_user_id' => |
31 | - array ( |
|
31 | + array( |
|
32 | 32 | 'query_type' => 'default', |
33 | 33 | ), |
34 | 34 | 'filename' => |
35 | - array ( |
|
35 | + array( |
|
36 | 36 | 'query_type' => 'format', |
37 | 37 | 'operator' => 'subquery', |
38 | 38 | 'subquery' => 'SELECT document_revisions.id FROM document_revisions |
39 | 39 | WHERE document_revisions.deleted=0 |
40 | 40 | AND document_revisions.filename LIKE \'{0}\'', |
41 | 41 | 'db_field' => |
42 | - array ( |
|
42 | + array( |
|
43 | 43 | 0 => 'document_revision_id', |
44 | 44 | ), |
45 | 45 | ), |
46 | 46 | 'range_date_entered' => |
47 | - array ( |
|
47 | + array( |
|
48 | 48 | 'query_type' => 'default', |
49 | 49 | 'enable_range_search' => true, |
50 | 50 | 'is_date_field' => true, |
51 | 51 | ), |
52 | 52 | 'start_range_date_entered' => |
53 | - array ( |
|
53 | + array( |
|
54 | 54 | 'query_type' => 'default', |
55 | 55 | 'enable_range_search' => true, |
56 | 56 | 'is_date_field' => true, |
57 | 57 | ), |
58 | 58 | 'end_range_date_entered' => |
59 | - array ( |
|
59 | + array( |
|
60 | 60 | 'query_type' => 'default', |
61 | 61 | 'enable_range_search' => true, |
62 | 62 | 'is_date_field' => true, |
63 | 63 | ), |
64 | 64 | 'range_date_modified' => |
65 | - array ( |
|
65 | + array( |
|
66 | 66 | 'query_type' => 'default', |
67 | 67 | 'enable_range_search' => true, |
68 | 68 | 'is_date_field' => true, |
69 | 69 | ), |
70 | 70 | 'start_range_date_modified' => |
71 | - array ( |
|
71 | + array( |
|
72 | 72 | 'query_type' => 'default', |
73 | 73 | 'enable_range_search' => true, |
74 | 74 | 'is_date_field' => true, |
75 | 75 | ), |
76 | 76 | 'end_range_date_modified' => |
77 | - array ( |
|
77 | + array( |
|
78 | 78 | 'query_type' => 'default', |
79 | 79 | 'enable_range_search' => true, |
80 | 80 | 'is_date_field' => true, |
@@ -85,6 +85,6 @@ discard block |
||
85 | 85 | 'subquery' => "SELECT favorites.parent_id FROM favorites |
86 | 86 | WHERE favorites.deleted = 0 |
87 | 87 | and favorites.parent_type = '".$module_name."' |
88 | - and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
|
88 | + and favorites.assigned_user_id = '" .$current_user->id."') OR NOT ({0}", |
|
89 | 89 | 'db_field'=>array('id')), |
90 | 90 | ); |
91 | 91 | \ No newline at end of file |
@@ -40,42 +40,42 @@ |
||
40 | 40 | global $current_user; |
41 | 41 | $module_name = "Meetings"; |
42 | 42 | $searchFields['Meetings'] = |
43 | - array ( |
|
44 | - 'name' => array( 'query_type'=>'default'), |
|
43 | + array ( |
|
44 | + 'name' => array( 'query_type'=>'default'), |
|
45 | 45 | 'contact_name' => array( 'query_type'=>'default','db_field'=>array('contacts.first_name','contacts.last_name')), |
46 | 46 | 'date_start' => array( 'query_type'=>'default'), |
47 | 47 | 'current_user_only'=> array('query_type'=>'default','db_field'=>array('assigned_user_id'),'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
48 | 48 | 'assigned_user_id'=> array('query_type'=>'default'), |
49 | 49 | 'status'=> array('query_type'=>'default', 'options' => 'meeting_status_dom', 'template_var' => 'STATUS_FILTER'), |
50 | 50 | |
51 | - 'open_only' => array( |
|
52 | - 'query_type'=>'default', |
|
53 | - 'db_field'=>array('status'), |
|
54 | - 'operator'=>'not in', |
|
55 | - 'closed_values' => array('Held', 'Not Held'), |
|
56 | - 'type'=>'bool', |
|
57 | - ), |
|
51 | + 'open_only' => array( |
|
52 | + 'query_type'=>'default', |
|
53 | + 'db_field'=>array('status'), |
|
54 | + 'operator'=>'not in', |
|
55 | + 'closed_values' => array('Held', 'Not Held'), |
|
56 | + 'type'=>'bool', |
|
57 | + ), |
|
58 | 58 | 'favorites_only' => array( |
59 | 59 | 'query_type'=>'format', |
60 | 60 | 'operator' => 'subquery', |
61 | - 'subquery' => "SELECT favorites.parent_id FROM favorites |
|
61 | + 'subquery' => "SELECT favorites.parent_id FROM favorites |
|
62 | 62 | WHERE favorites.deleted = 0 |
63 | 63 | and favorites.parent_type = '".$module_name."' |
64 | 64 | and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
65 | 65 | 'db_field'=>array('id')), |
66 | - //Range Search Support |
|
67 | - 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | - 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
69 | - 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
70 | - 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
71 | - 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
72 | - 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
73 | - 'range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
74 | - 'start_range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
75 | - 'end_range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
76 | - 'range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
77 | - 'start_range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
78 | - 'end_range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
79 | - //Range Search Support |
|
80 | - ); |
|
66 | + //Range Search Support |
|
67 | + 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | + 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
69 | + 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
70 | + 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
71 | + 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
72 | + 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
73 | + 'range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
74 | + 'start_range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
75 | + 'end_range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
76 | + 'range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
77 | + 'start_range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
78 | + 'end_range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
79 | + //Range Search Support |
|
80 | + ); |
|
81 | 81 | ?> |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
3 | 3 | /********************************************************************************* |
4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -40,11 +40,11 @@ discard block |
||
40 | 40 | global $current_user; |
41 | 41 | $module_name = "Meetings"; |
42 | 42 | $searchFields['Meetings'] = |
43 | - array ( |
|
44 | - 'name' => array( 'query_type'=>'default'), |
|
45 | - 'contact_name' => array( 'query_type'=>'default','db_field'=>array('contacts.first_name','contacts.last_name')), |
|
46 | - 'date_start' => array( 'query_type'=>'default'), |
|
47 | - 'current_user_only'=> array('query_type'=>'default','db_field'=>array('assigned_user_id'),'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
|
43 | + array( |
|
44 | + 'name' => array('query_type'=>'default'), |
|
45 | + 'contact_name' => array('query_type'=>'default', 'db_field'=>array('contacts.first_name', 'contacts.last_name')), |
|
46 | + 'date_start' => array('query_type'=>'default'), |
|
47 | + 'current_user_only'=> array('query_type'=>'default', 'db_field'=>array('assigned_user_id'), 'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
|
48 | 48 | 'assigned_user_id'=> array('query_type'=>'default'), |
49 | 49 | 'status'=> array('query_type'=>'default', 'options' => 'meeting_status_dom', 'template_var' => 'STATUS_FILTER'), |
50 | 50 | |
@@ -61,21 +61,21 @@ discard block |
||
61 | 61 | 'subquery' => "SELECT favorites.parent_id FROM favorites |
62 | 62 | WHERE favorites.deleted = 0 |
63 | 63 | and favorites.parent_type = '".$module_name."' |
64 | - and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
|
64 | + and favorites.assigned_user_id = '" .$current_user->id."') OR NOT ({0}", |
|
65 | 65 | 'db_field'=>array('id')), |
66 | 66 | //Range Search Support |
67 | - 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | - 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
69 | - 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
70 | - 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
71 | - 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
72 | - 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
73 | - 'range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
74 | - 'start_range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
75 | - 'end_range_date_start' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
76 | - 'range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
77 | - 'start_range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
78 | - 'end_range_date_end' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
67 | + 'range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | + 'start_range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
69 | + 'end_range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
70 | + 'range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
71 | + 'start_range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
72 | + 'end_range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
73 | + 'range_date_start' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
74 | + 'start_range_date_start' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
75 | + 'end_range_date_start' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
76 | + 'range_date_end' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
77 | + 'start_range_date_end' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
78 | + 'end_range_date_end' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
79 | 79 | //Range Search Support |
80 | 80 | ); |
81 | 81 | ?> |
@@ -45,22 +45,22 @@ discard block |
||
45 | 45 | 'last_name'=> array('query_type'=>'default'), |
46 | 46 | 'search_name'=> array('query_type'=>'default','db_field'=>array('first_name','last_name'),'force_unifiedsearch'=>true), |
47 | 47 | 'account_name'=> array('query_type'=>'default','db_field'=>array('leads.account_name')), |
48 | - /*'acc_name_from_accounts' => array('query_type'=>'default','related_field'=>'account_name'),*/ |
|
48 | + /*'acc_name_from_accounts' => array('query_type'=>'default','related_field'=>'account_name'),*/ |
|
49 | 49 | 'lead_source'=> array('query_type'=>'default','operator'=>'=', 'options'=>'lead_source_dom', 'template_var' => 'LEAD_SOURCE_OPTIONS'), |
50 | 50 | 'do_not_call'=> array('query_type'=>'default', 'operator'=>'=', 'input_type' => 'checkbox'), |
51 | 51 | 'phone'=> array('query_type'=>'default','db_field'=>array('phone_mobile','phone_work','phone_other','phone_fax','phone_home')), |
52 | - 'email'=> array( |
|
53 | - 'query_type' => 'default', |
|
54 | - 'operator' => 'subquery', |
|
55 | - 'subquery' => 'SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE', |
|
56 | - 'db_field' => array( |
|
57 | - 'id', |
|
58 | - ), |
|
59 | - ), |
|
52 | + 'email'=> array( |
|
53 | + 'query_type' => 'default', |
|
54 | + 'operator' => 'subquery', |
|
55 | + 'subquery' => 'SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE', |
|
56 | + 'db_field' => array( |
|
57 | + 'id', |
|
58 | + ), |
|
59 | + ), |
|
60 | 60 | 'favorites_only' => array( |
61 | 61 | 'query_type'=>'format', |
62 | 62 | 'operator' => 'subquery', |
63 | - 'subquery' => "SELECT favorites.parent_id FROM favorites |
|
63 | + 'subquery' => "SELECT favorites.parent_id FROM favorites |
|
64 | 64 | WHERE favorites.deleted = 0 |
65 | 65 | and favorites.parent_type = '".$module_name."' |
66 | 66 | and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
@@ -75,20 +75,20 @@ discard block |
||
75 | 75 | 'current_user_only'=> array('query_type'=>'default','db_field'=>array('assigned_user_id'),'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
76 | 76 | 'assigned_user_id'=> array('query_type'=>'default'), |
77 | 77 | 'status'=> array('query_type'=>'default', 'options'=>'lead_status_dom', 'template_var' => 'STATUS_OPTIONS'), |
78 | - 'open_only' => array( |
|
79 | - 'query_type'=>'default', |
|
80 | - 'db_field'=>array('status'), |
|
81 | - 'operator'=>'not in', |
|
82 | - 'closed_values' => array('Dead', 'Recycled', 'Converted'), |
|
83 | - 'type'=>'bool', |
|
84 | - ), |
|
85 | - //Range Search Support |
|
86 | - 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
87 | - 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
88 | - 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
89 | - 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
90 | - 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
78 | + 'open_only' => array( |
|
79 | + 'query_type'=>'default', |
|
80 | + 'db_field'=>array('status'), |
|
81 | + 'operator'=>'not in', |
|
82 | + 'closed_values' => array('Dead', 'Recycled', 'Converted'), |
|
83 | + 'type'=>'bool', |
|
84 | + ), |
|
85 | + //Range Search Support |
|
86 | + 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
87 | + 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
88 | + 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
89 | + 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
90 | + 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
91 | 91 | 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
92 | - //Range Search Support |
|
92 | + //Range Search Support |
|
93 | 93 | ); |
94 | 94 | ?> |
95 | 95 | \ No newline at end of file |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
3 | 3 | /********************************************************************************* |
4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -40,15 +40,15 @@ discard block |
||
40 | 40 | global $current_user; |
41 | 41 | $module_name = "Leads"; |
42 | 42 | $searchFields['Leads'] = |
43 | - array ( |
|
44 | - 'first_name' => array( 'query_type'=>'default'), |
|
43 | + array( |
|
44 | + 'first_name' => array('query_type'=>'default'), |
|
45 | 45 | 'last_name'=> array('query_type'=>'default'), |
46 | - 'search_name'=> array('query_type'=>'default','db_field'=>array('first_name','last_name'),'force_unifiedsearch'=>true), |
|
47 | - 'account_name'=> array('query_type'=>'default','db_field'=>array('leads.account_name')), |
|
46 | + 'search_name'=> array('query_type'=>'default', 'db_field'=>array('first_name', 'last_name'), 'force_unifiedsearch'=>true), |
|
47 | + 'account_name'=> array('query_type'=>'default', 'db_field'=>array('leads.account_name')), |
|
48 | 48 | /*'acc_name_from_accounts' => array('query_type'=>'default','related_field'=>'account_name'),*/ |
49 | - 'lead_source'=> array('query_type'=>'default','operator'=>'=', 'options'=>'lead_source_dom', 'template_var' => 'LEAD_SOURCE_OPTIONS'), |
|
49 | + 'lead_source'=> array('query_type'=>'default', 'operator'=>'=', 'options'=>'lead_source_dom', 'template_var' => 'LEAD_SOURCE_OPTIONS'), |
|
50 | 50 | 'do_not_call'=> array('query_type'=>'default', 'operator'=>'=', 'input_type' => 'checkbox'), |
51 | - 'phone'=> array('query_type'=>'default','db_field'=>array('phone_mobile','phone_work','phone_other','phone_fax','phone_home')), |
|
51 | + 'phone'=> array('query_type'=>'default', 'db_field'=>array('phone_mobile', 'phone_work', 'phone_other', 'phone_fax', 'phone_home')), |
|
52 | 52 | 'email'=> array( |
53 | 53 | 'query_type' => 'default', |
54 | 54 | 'operator' => 'subquery', |
@@ -63,16 +63,16 @@ discard block |
||
63 | 63 | 'subquery' => "SELECT favorites.parent_id FROM favorites |
64 | 64 | WHERE favorites.deleted = 0 |
65 | 65 | and favorites.parent_type = '".$module_name."' |
66 | - and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
|
66 | + and favorites.assigned_user_id = '" .$current_user->id."') OR NOT ({0}", |
|
67 | 67 | 'db_field'=>array('id')), |
68 | 68 | 'assistant'=> array('query_type'=>'default'), |
69 | 69 | 'website'=> array('query_type'=>'default'), |
70 | - 'address_street'=> array('query_type'=>'default','db_field'=>array('primary_address_street','alt_address_street')), |
|
71 | - 'address_city'=> array('query_type'=>'default','db_field'=>array('primary_address_city','alt_address_city')), |
|
72 | - 'address_state'=> array('query_type'=>'default','db_field'=>array('primary_address_state','alt_address_state')), |
|
73 | - 'address_postalcode'=> array('query_type'=>'default','db_field'=>array('primary_address_postalcode','alt_address_postalcode')), |
|
74 | - 'address_country'=> array('query_type'=>'default','db_field'=>array('primary_address_country','alt_address_country')), |
|
75 | - 'current_user_only'=> array('query_type'=>'default','db_field'=>array('assigned_user_id'),'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
|
70 | + 'address_street'=> array('query_type'=>'default', 'db_field'=>array('primary_address_street', 'alt_address_street')), |
|
71 | + 'address_city'=> array('query_type'=>'default', 'db_field'=>array('primary_address_city', 'alt_address_city')), |
|
72 | + 'address_state'=> array('query_type'=>'default', 'db_field'=>array('primary_address_state', 'alt_address_state')), |
|
73 | + 'address_postalcode'=> array('query_type'=>'default', 'db_field'=>array('primary_address_postalcode', 'alt_address_postalcode')), |
|
74 | + 'address_country'=> array('query_type'=>'default', 'db_field'=>array('primary_address_country', 'alt_address_country')), |
|
75 | + 'current_user_only'=> array('query_type'=>'default', 'db_field'=>array('assigned_user_id'), 'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
|
76 | 76 | 'assigned_user_id'=> array('query_type'=>'default'), |
77 | 77 | 'status'=> array('query_type'=>'default', 'options'=>'lead_status_dom', 'template_var' => 'STATUS_OPTIONS'), |
78 | 78 | 'open_only' => array( |
@@ -83,12 +83,12 @@ discard block |
||
83 | 83 | 'type'=>'bool', |
84 | 84 | ), |
85 | 85 | //Range Search Support |
86 | - 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
87 | - 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
88 | - 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
89 | - 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
90 | - 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
91 | - 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
86 | + 'range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
87 | + 'start_range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
88 | + 'end_range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
89 | + 'range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
90 | + 'start_range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
91 | + 'end_range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
92 | 92 | //Range Search Support |
93 | 93 | ); |
94 | 94 | ?> |
95 | 95 | \ No newline at end of file |
@@ -46,25 +46,25 @@ |
||
46 | 46 | 'favorites_only' => array( |
47 | 47 | 'query_type'=>'format', |
48 | 48 | 'operator' => 'subquery', |
49 | - 'subquery' => "SELECT favorites.parent_id FROM favorites |
|
49 | + 'subquery' => "SELECT favorites.parent_id FROM favorites |
|
50 | 50 | WHERE favorites.deleted = 0 |
51 | 51 | and favorites.parent_type = '".$module_name."' |
52 | 52 | and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
53 | 53 | 'db_field'=>array('id')), |
54 | - //Range Search Support |
|
55 | - 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
56 | - 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
57 | - 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
58 | - 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
59 | - 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
60 | - 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
54 | + //Range Search Support |
|
55 | + 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
56 | + 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
57 | + 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
58 | + 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
59 | + 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
60 | + 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
61 | 61 | |
62 | - 'range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
63 | - 'start_range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
64 | - 'end_range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
65 | - 'range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
66 | - 'start_range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
67 | - 'end_range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | - //Range Search Support |
|
62 | + 'range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
63 | + 'start_range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
64 | + 'end_range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
65 | + 'range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
66 | + 'start_range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
67 | + 'end_range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | + //Range Search Support |
|
69 | 69 | ); |
70 | 70 | ?> |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
3 | 3 | /********************************************************************************* |
4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -40,31 +40,31 @@ discard block |
||
40 | 40 | global $current_user; |
41 | 41 | $module_name = "Project"; |
42 | 42 | $searchFields['Project'] = |
43 | - array ( |
|
44 | - 'name' => array( 'query_type'=>'default'), |
|
45 | - 'current_user_only'=> array('query_type'=>'default','db_field'=>array('assigned_user_id'),'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
|
43 | + array( |
|
44 | + 'name' => array('query_type'=>'default'), |
|
45 | + 'current_user_only'=> array('query_type'=>'default', 'db_field'=>array('assigned_user_id'), 'my_items'=>true, 'vname' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool'), |
|
46 | 46 | 'favorites_only' => array( |
47 | 47 | 'query_type'=>'format', |
48 | 48 | 'operator' => 'subquery', |
49 | 49 | 'subquery' => "SELECT favorites.parent_id FROM favorites |
50 | 50 | WHERE favorites.deleted = 0 |
51 | 51 | and favorites.parent_type = '".$module_name."' |
52 | - and favorites.assigned_user_id = '" .$current_user->id . "') OR NOT ({0}", |
|
52 | + and favorites.assigned_user_id = '" .$current_user->id."') OR NOT ({0}", |
|
53 | 53 | 'db_field'=>array('id')), |
54 | 54 | //Range Search Support |
55 | - 'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
56 | - 'start_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
57 | - 'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
58 | - 'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
59 | - 'start_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
60 | - 'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
55 | + 'range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
56 | + 'start_range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
57 | + 'end_range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
58 | + 'range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
59 | + 'start_range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
60 | + 'end_range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
61 | 61 | |
62 | - 'range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
63 | - 'start_range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
64 | - 'end_range_estimated_start_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
65 | - 'range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
66 | - 'start_range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
67 | - 'end_range_estimated_end_date' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
62 | + 'range_estimated_start_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
63 | + 'start_range_estimated_start_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
64 | + 'end_range_estimated_start_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
65 | + 'range_estimated_end_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
66 | + 'start_range_estimated_end_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
67 | + 'end_range_estimated_end_date' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true), |
|
68 | 68 | //Range Search Support |
69 | 69 | ); |
70 | 70 | ?> |