Completed
Push — master ( a833c2...4c7587 )
by Adam
18:52
created
modules/AOR_Conditions/AOR_Condition.php 1 patch
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -77,9 +77,9 @@  discard block
 block discarded – undo
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
 block discarded – undo
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;
Please login to merge, or discard this patch.
modules/AOS_Products/metadata/SearchFields.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -1,16 +1,16 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
modules/Documents/metadata/SearchFields.php 1 patch
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -2,79 +2,79 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
modules/Meetings/metadata/SearchFields.php 2 patches
Indentation   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -40,42 +40,42 @@
 block discarded – undo
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
 ?>
Please login to merge, or discard this patch.
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 ?>
Please login to merge, or discard this patch.
modules/Leads/metadata/SearchFields.php 2 patches
Indentation   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -45,22 +45,22 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
modules/Project/metadata/SearchFields.php 2 patches
Indentation   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -46,25 +46,25 @@
 block discarded – undo
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
 ?>
Please login to merge, or discard this patch.
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 ?>
Please login to merge, or discard this patch.