adamjakab / SuiteCRM

modules/Opportunities/metadata/searchdefs.php

Indentation +44 added lines, -44 removed lines

@@ -38,102 +38,102 @@
  ********************************************************************************/
 
 $searchdefs['Opportunities'] = array(
-  'templateMeta' => 
-  array (
+    'templateMeta' => 
+    array (
     'maxColumns' => '3',
     'maxColumnsBasic' => '4', 
     'widths' => 
     array (
-      'label' => '10',
-      'field' => '30',
+        'label' => '10',
+        'field' => '30',
+    ),
     ),
-  ),
-  'layout' => 
-  array (
+    'layout' => 
+    array (
     'basic_search' => 
     array (
-      'name' => 
-      array (
+        'name' => 
+        array (
         'name' => 'name',
         'default' => true,
         'width' => '10%',
-      ),
-      'current_user_only' => 
-      array (
+        ),
+        'current_user_only' => 
+        array (
         'name' => 'current_user_only',
         'label' => 'LBL_CURRENT_USER_FILTER',
         'type' => 'bool',
         'default' => true,
         'width' => '10%',
-      ),
-	  array ('name' => 'open_only', 'label' => 'LBL_OPEN_ITEMS', 'type' => 'bool', 'default' => false, 'width' => '10%'),
-      array ('name' => 'favorites_only','label' => 'LBL_FAVORITES_FILTER','type' => 'bool',),
+        ),
+        array ('name' => 'open_only', 'label' => 'LBL_OPEN_ITEMS', 'type' => 'bool', 'default' => false, 'width' => '10%'),
+        array ('name' => 'favorites_only','label' => 'LBL_FAVORITES_FILTER','type' => 'bool',),
 
     ),
     'advanced_search' => 
     array (
-      'name' => 
-      array (
+        'name' => 
+        array (
         'name' => 'name',
         'default' => true,
         'width' => '10%',
-      ),
-      'account_name' => 
-      array (
+        ),
+        'account_name' => 
+        array (
         'name' => 'account_name',
         'default' => true,
         'width' => '10%',
-      ),
-      'amount' => 
-      array (
+        ),
+        'amount' => 
+        array (
         'name' => 'amount',
         'default' => true,
         'width' => '10%',
-      ),
-      'assigned_user_id' => 
-      array (
+        ),
+        'assigned_user_id' => 
+        array (
         'name' => 'assigned_user_id',
         'type' => 'enum',
         'label' => 'LBL_ASSIGNED_TO',
         'function' => 
         array (
-          'name' => 'get_user_array',
-          'params' => 
-          array (
+            'name' => 'get_user_array',
+            'params' => 
+            array (
             0 => false,
-          ),
+            ),
         ),
         'default' => true,
         'width' => '10%',
-      ),
-      'sales_stage' => 
-      array (
+        ),
+        'sales_stage' => 
+        array (
         'name' => 'sales_stage',
         'default' => true,
         'width' => '10%',
-      ),
-      'lead_source' => 
-      array (
+        ),
+        'lead_source' => 
+        array (
         'name' => 'lead_source',
         'default' => true,
         'width' => '10%',
-      ),
-      'date_closed' => 
-      array (
+        ),
+        'date_closed' => 
+        array (
         'name' => 'date_closed',
         'default' => true,
         'width' => '10%',
-      ),
-      'next_step' => 
-      array (
+        ),
+        'next_step' => 
+        array (
         'type' => 'varchar',
         'label' => 'LBL_NEXT_STEP',
         'width' => '10%',
         'default' => true,
         'name' => 'next_step',
-      ),
+        ),
+    ),
     ),
-  ),
 					
 );
 ?>

modules/Opportunities/metadata/studio.php

Indentation +23 added lines, -23 removed lines

@@ -42,28 +42,28 @@
 
 
 $GLOBALS['studioDefs']['Opportunities'] = array(
-	'LBL_DETAILVIEW'=>array(
-				'template'=>'xtpl',
-				'template_file'=>'modules/Opportunities/DetailView.html',
-				'php_file'=>'modules/Opportunities/DetailView.php',
-				'type'=>'DetailView',
-				),
-	'LBL_EDITVIEW'=>array(
-				'template'=>'xtpl',
-				'template_file'=>'modules/Opportunities/EditView.html',
-				'php_file'=>'modules/Opportunities/EditView.php',
-				'type'=>'EditView',
-				),
-	'LBL_LISTVIEW'=>array(
-				'template'=>'listview',
-				'meta_file'=>'modules/Opportunities/listviewdefs.php',
-				'type'=>'ListView',
-				),
-	'LBL_SEARCHFORM'=>array(
-				'template'=>'xtpl',
-				'template_file'=>'modules/Opportunities/SearchForm.html',
-				'php_file'=>'modules/Opportunities/ListView.php',
-				'type'=>'SearchForm',
-				),
+    'LBL_DETAILVIEW'=>array(
+                'template'=>'xtpl',
+                'template_file'=>'modules/Opportunities/DetailView.html',
+                'php_file'=>'modules/Opportunities/DetailView.php',
+                'type'=>'DetailView',
+                ),
+    'LBL_EDITVIEW'=>array(
+                'template'=>'xtpl',
+                'template_file'=>'modules/Opportunities/EditView.html',
+                'php_file'=>'modules/Opportunities/EditView.php',
+                'type'=>'EditView',
+                ),
+    'LBL_LISTVIEW'=>array(
+                'template'=>'listview',
+                'meta_file'=>'modules/Opportunities/listviewdefs.php',
+                'type'=>'ListView',
+                ),
+    'LBL_SEARCHFORM'=>array(
+                'template'=>'xtpl',
+                'template_file'=>'modules/Opportunities/SearchForm.html',
+                'php_file'=>'modules/Opportunities/ListView.php',
+                'type'=>'SearchForm',
+                ),
 
 );

modules/Opportunities/metadata/SearchFields.php

Indentation +33 added lines, -33 removed lines

@@ -40,24 +40,24 @@ 
 global $current_user;
 $module_name = "Opportunities";
 $searchFields['Opportunities'] = 
-	array (
-		'name' => array( 'query_type'=>'default'),
-		'account_name'=> array('query_type'=>'default','db_field'=>array('accounts.name')),
-		'amount'=> array('query_type'=>'default'),
-		'next_step'=> array('query_type'=>'default'),
-		'probability'=> array('query_type'=>'default'),
-		'lead_source'=> array('query_type'=>'default', 'operator'=>'=', 'options' => 'lead_source_dom', 'template_var' => 'LEAD_SOURCE_OPTIONS'),
-		'opportunity_type'=> array('query_type'=>'default', 'operator'=>'=', 'options' => 'opportunity_type_dom', 'template_var' => 'TYPE_OPTIONS'),
-		'sales_stage'=> array('query_type'=>'default', 'operator'=>'=', 'options' => 'sales_stage_dom', 'template_var' => 'SALES_STAGE_OPTIONS', 'options_add_blank' => true),
-		'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'),
-		'open_only' => array(
-			'query_type'=>'default',
-			'db_field'=>array('sales_stage'),
-			'operator'=>'not in',
-			'closed_values' => array('Closed Won', 'Closed Lost'),
-			'type'=>'bool',
-		),
+    array (
+        'name' => array( 'query_type'=>'default'),
+        'account_name'=> array('query_type'=>'default','db_field'=>array('accounts.name')),
+        'amount'=> array('query_type'=>'default'),
+        'next_step'=> array('query_type'=>'default'),
+        'probability'=> array('query_type'=>'default'),
+        'lead_source'=> array('query_type'=>'default', 'operator'=>'=', 'options' => 'lead_source_dom', 'template_var' => 'LEAD_SOURCE_OPTIONS'),
+        'opportunity_type'=> array('query_type'=>'default', 'operator'=>'=', 'options' => 'opportunity_type_dom', 'template_var' => 'TYPE_OPTIONS'),
+        'sales_stage'=> array('query_type'=>'default', 'operator'=>'=', 'options' => 'sales_stage_dom', 'template_var' => 'SALES_STAGE_OPTIONS', 'options_add_blank' => true),
+        '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'),
+        'open_only' => array(
+            'query_type'=>'default',
+            'db_field'=>array('sales_stage'),
+            'operator'=>'not in',
+            'closed_values' => array('Closed Won', 'Closed Lost'),
+            'type'=>'bool',
+        ),
         'favorites_only' => array(
             'query_type'=>'format',
             'operator' => 'subquery',
@@ -67,21 +67,21 @@ 
 			                        and favorites.assigned_user_id = "' .$current_user->id . '") OR NOT ({0}',
             'db_field'=>array('id')),
 
-		//Range Search Support 
-	   'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
-	   'start_range_date_entered' => array ('query_type' => 'default',  'enable_range_search' => true, 'is_date_field' => true),
-	   'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
-	   'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
-	   'start_range_date_modified' => array ('query_type' => 'default',  'enable_range_search' => true, 'is_date_field' => true),
-       'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),	
+        //Range Search Support 
+        'range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
+        'start_range_date_entered' => array ('query_type' => 'default',  'enable_range_search' => true, 'is_date_field' => true),
+        'end_range_date_entered' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
+        'range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
+        'start_range_date_modified' => array ('query_type' => 'default',  'enable_range_search' => true, 'is_date_field' => true),
+        'end_range_date_modified' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),	
 	   
-       'range_date_closed' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
-	   'start_range_date_closed' => array ('query_type' => 'default',  'enable_range_search' => true, 'is_date_field' => true),
-       'end_range_date_closed' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),	
+        'range_date_closed' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
+        'start_range_date_closed' => array ('query_type' => 'default',  'enable_range_search' => true, 'is_date_field' => true),
+        'end_range_date_closed' => array ('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),	
 
-       'range_amount' => array ('query_type' => 'default', 'enable_range_search' => true),
-	   'start_range_amount' => array ('query_type' => 'default',  'enable_range_search' => true),
-       'end_range_amount' => array ('query_type' => 'default', 'enable_range_search' => true),
-		//Range Search Support 			
-	);
+        'range_amount' => array ('query_type' => 'default', 'enable_range_search' => true),
+        'start_range_amount' => array ('query_type' => 'default',  'enable_range_search' => true),
+        'end_range_amount' => array ('query_type' => 'default', 'enable_range_search' => true),
+        //Range Search Support 			
+    );
 ?>

modules/Opportunities/metadata/detailviewdefs.php

Indentation +56 added lines, -56 removed lines

@@ -39,117 +39,117 @@
 
 $viewdefs ['Opportunities'] = 
 array (
-  'DetailView' => 
-  array (
+    'DetailView' => 
+    array (
     'templateMeta' => 
     array (
-      'form' => 
-      array (
+        'form' => 
+        array (
         'buttons' => 
         array (
-          0 => 'EDIT',
-          1 => 'DUPLICATE',
-          2 => 'DELETE',
-          3 => 'FIND_DUPLICATES',
+            0 => 'EDIT',
+            1 => 'DUPLICATE',
+            2 => 'DELETE',
+            3 => 'FIND_DUPLICATES',
         ),
-      ),
-      'maxColumns' => '2',
-      'widths' => 
-      array (
+        ),
+        'maxColumns' => '2',
+        'widths' => 
+        array (
         0 => 
         array (
-          'label' => '10',
-          'field' => '30',
+            'label' => '10',
+            'field' => '30',
         ),
         1 => 
         array (
-          'label' => '10',
-          'field' => '30',
+            'label' => '10',
+            'field' => '30',
         ),
-      ),
-      'useTabs' => true,
-      'tabDefs' => 
-      array (
+        ),
+        'useTabs' => true,
+        'tabDefs' => 
+        array (
         'DEFAULT' => 
         array (
-          'newTab' => true,
-          'panelDefault' => 'expanded',
+            'newTab' => true,
+            'panelDefault' => 'expanded',
         ),
         'LBL_PANEL_ASSIGNMENT' => 
         array (
-          'newTab' => true,
-          'panelDefault' => 'expanded',
+            'newTab' => true,
+            'panelDefault' => 'expanded',
+        ),
         ),
-      ),
     ),
     'panels' => 
     array (
-      'default' => 
-      array (
+        'default' => 
+        array (
         0 => 
         array (
-          0 => 'name',
-          1 => 'account_name',
+            0 => 'name',
+            1 => 'account_name',
         ),
         1 => 
         array (
-          0 => 
-          array (
+            0 => 
+            array (
             'name' => 'amount',
             'label' => '{$MOD.LBL_AMOUNT} ({$CURRENCY})',
-          ),
-          1 => 'date_closed',
+            ),
+            1 => 'date_closed',
         ),
         2 => 
         array (
-          0 => 'sales_stage',
-          1 => 'opportunity_type',
+            0 => 'sales_stage',
+            1 => 'opportunity_type',
         ),
         3 => 
         array (
-          0 => 'probability',
-          1 => 'lead_source',
+            0 => 'probability',
+            1 => 'lead_source',
         ),
         4 => 
         array (
-          0 => 'next_step',
-          1 => 'campaign_name',
+            0 => 'next_step',
+            1 => 'campaign_name',
         ),
         5 => 
         array (
-          0 => 
-          array (
+            0 => 
+            array (
             'name' => 'description',
             'nl2br' => true,
-          ),
+            ),
         ),
         6 => 
         array (
-          0 => 
-          array (
+            0 => 
+            array (
             'name' => 'assigned_user_name',
             'label' => 'LBL_ASSIGNED_TO',
-          ),
+            ),
+        ),
         ),
-      ),
-      'LBL_PANEL_ASSIGNMENT' => 
-      array (
+        'LBL_PANEL_ASSIGNMENT' => 
+        array (
         0 => 
         array (
-          0 => 
-          array (
+            0 => 
+            array (
             'name' => 'date_modified',
             'label' => 'LBL_DATE_MODIFIED',
             'customCode' => '{$fields.date_modified.value} {$APP.LBL_BY} {$fields.modified_by_name.value}',
-          ),
-          1 =>
-          array (
+            ),
+            1 =>
+            array (
             'name' => 'date_entered',
             'customCode' => '{$fields.date_entered.value} {$APP.LBL_BY} {$fields.created_by_name.value}',
-          ),
+            ),
+        ),
         ),
-      ),
     ),
-  ),
+    ),
 );
 ?>

modules/Opportunities/metadata/quickcreatedefs.php

Indentation +35 added lines, -35 removed lines

@@ -46,69 +46,69 @@
  ********************************************************************************/
 
 $viewdefs = array (
-  'Opportunities' => 
-  array (
+    'Opportunities' => 
+    array (
     'QuickCreate' => 
     array (
-      'templateMeta' => 
-      array (
+        'templateMeta' => 
+        array (
         'maxColumns' => '2',
         'widths' => 
         array (
-          0 => 
-          array (
+            0 => 
+            array (
             'label' => '10',
             'field' => '30',
-          ),
-          1 => 
-          array (
+            ),
+            1 => 
+            array (
             'label' => '10',
             'field' => '30',
-          ),
+            ),
         ),
         'javascript' => '{$PROBABILITY_SCRIPT}',
-      ),
-      'panels' => 
-      array (
+        ),
+        'panels' => 
+        array (
         'DEFAULT' => 
         array (
-          array (
             array (
-              'name' => 'name',
-              'displayParams'=>array('required'=>true),
+            array (
+                'name' => 'name',
+                'displayParams'=>array('required'=>true),
             ),
             array (
-              'name' => 'account_name',
+                'name' => 'account_name',
+            ),
             ),
-          ),
-          array (
             array (
-              'name' => 'currency_id',
+            array (
+                'name' => 'currency_id',
             ),
             array (
-              'name' => 'opportunity_type',
+                'name' => 'opportunity_type',
             ),            
-          ),
-          array (
+            ),
+            array (
             'amount',
             'date_closed'          
-          ),
-          array (
-             'next_step',
-             'sales_stage',
-          ),
-          array (
-             'lead_source',
-             'probability',
-          ),
+            ),
+            array (
+                'next_step',
+                'sales_stage',
+            ),
+            array (
+                'lead_source',
+                'probability',
+            ),
         array (
             array (
-              'name' => 'assigned_user_name',
+                'name' => 'assigned_user_name',
             ),
         ),
         ),
-      ),
+        ),
+    ),
     ),
-  ),
 );
 ?>

modules/Opportunities/metadata/metafiles.php

Indentation +8 added lines, -8 removed lines

@@ -43,13 +43,13 @@
  * To change the template for this generated file go to
  * Window - Preferences - PHPeclipse - PHP - Code Templates
  */
- $metafiles['Opportunities'] = array(
-	'detailviewdefs'  => 	'modules/Opportunities/metadata/detailviewdefs.php', 	
-	'editviewdefs'    => 	'modules/Opportunities/metadata/editviewdefs.php',
- 	'listviewdefs'    => 	'modules/Opportunities/metadata/listviewdefs.php',
- 	'searchdefs'      =>    'modules/Opportunities/metadata/searchdefs.php',
- 	'popupdefs'	      =>    'modules/Opportunities/metadata/popupdefs.php',
- 	'searchfields'	  =>    'modules/Opportunities/metadata/SearchFields.php',
+    $metafiles['Opportunities'] = array(
+    'detailviewdefs'  => 	'modules/Opportunities/metadata/detailviewdefs.php', 	
+    'editviewdefs'    => 	'modules/Opportunities/metadata/editviewdefs.php',
+        'listviewdefs'    => 	'modules/Opportunities/metadata/listviewdefs.php',
+        'searchdefs'      =>    'modules/Opportunities/metadata/searchdefs.php',
+        'popupdefs'	      =>    'modules/Opportunities/metadata/popupdefs.php',
+        'searchfields'	  =>    'modules/Opportunities/metadata/SearchFields.php',
 
- );
+    );
 ?>

modules/Opportunities/metadata/listviewdefs.php

Indentation +34 added lines, -34 removed lines

@@ -42,43 +42,43 @@ 
 
 
 $listViewDefs['Opportunities'] = array(
-	'NAME' => array(
-		'width'   => '30',  
-		'label'   => 'LBL_LIST_OPPORTUNITY_NAME', 
-		'link'    => true,
+    'NAME' => array(
+        'width'   => '30',  
+        'label'   => 'LBL_LIST_OPPORTUNITY_NAME', 
+        'link'    => true,
         'default' => true),
-	'ACCOUNT_NAME' => array(
-		'width'   => '20', 
-		'label'   => 'LBL_LIST_ACCOUNT_NAME', 
-		'id'      => 'ACCOUNT_ID',
+    'ACCOUNT_NAME' => array(
+        'width'   => '20', 
+        'label'   => 'LBL_LIST_ACCOUNT_NAME', 
+        'id'      => 'ACCOUNT_ID',
         'module'  => 'Accounts',
-		'link'    => true,
+        'link'    => true,
         'default' => true,
         'sortable'=> true,
         'ACLTag' => 'ACCOUNT',
         'contextMenu' => array('objectType' => 'sugarAccount', 
-                               'metaData' => array('return_module' => 'Contacts', 
-                                                   'return_action' => 'ListView', 
-                                                   'module' => 'Accounts',
-                                                   'return_action' => 'ListView', 
-                                                   'parent_id' => '{$ACCOUNT_ID}', 
-                                                   'parent_name' => '{$ACCOUNT_NAME}', 
-                                                   'account_id' => '{$ACCOUNT_ID}', 
-                                                   'account_name' => '{$ACCOUNT_NAME}',
-                                                   ),
-                              ),
+                                'metaData' => array('return_module' => 'Contacts', 
+                                                    'return_action' => 'ListView', 
+                                                    'module' => 'Accounts',
+                                                    'return_action' => 'ListView', 
+                                                    'parent_id' => '{$ACCOUNT_ID}', 
+                                                    'parent_name' => '{$ACCOUNT_NAME}', 
+                                                    'account_id' => '{$ACCOUNT_ID}', 
+                                                    'account_name' => '{$ACCOUNT_NAME}',
+                                                    ),
+                                ),
         'related_fields' => array('account_id')),
-	'SALES_STAGE' => array(
-		'width'   => '10',  
-		'label'   => 'LBL_LIST_SALES_STAGE',
+    'SALES_STAGE' => array(
+        'width'   => '10',  
+        'label'   => 'LBL_LIST_SALES_STAGE',
         'default' => true), 
-	'AMOUNT_USDOLLAR' => array(
-		'width'   => '10', 
-		'label'   => 'LBL_LIST_AMOUNT_USDOLLAR',
+    'AMOUNT_USDOLLAR' => array(
+        'width'   => '10', 
+        'label'   => 'LBL_LIST_AMOUNT_USDOLLAR',
         'align'   => 'right',
         'default' => true,
         'currency_format' => true,
-	),  
+    ),  
     'OPPORTUNITY_TYPE' => array(
         'width' => '15', 
         'label' => 'LBL_TYPE'),
@@ -91,17 +91,17 @@ 
     'PROBABILITY' => array(
         'width' => '10', 
         'label' => 'LBL_PROBABILITY'),
-	'DATE_CLOSED' => array(
-		'width' => '10', 
-		'label' => 'LBL_LIST_DATE_CLOSED',
+    'DATE_CLOSED' => array(
+        'width' => '10', 
+        'label' => 'LBL_LIST_DATE_CLOSED',
         'default' => true),
     'CREATED_BY_NAME' => array(
         'width' => '10', 
         'label' => 'LBL_CREATED'),
-	'ASSIGNED_USER_NAME' => array(
-		'width' => '5', 
-		'label' => 'LBL_LIST_ASSIGNED_USER',
-		'module' => 'Employees',
+    'ASSIGNED_USER_NAME' => array(
+        'width' => '5', 
+        'label' => 'LBL_LIST_ASSIGNED_USER',
+        'module' => 'Employees',
         'id' => 'ASSIGNED_USER_ID',
         'default' => true),
     'MODIFIED_BY_NAME' => array(
@@ -110,7 +110,7 @@ 
     'DATE_ENTERED' => array(
         'width' => '10', 
         'label' => 'LBL_DATE_ENTERED',
-		'default' => true)
+        'default' => true)
 );
 
 ?>

modules/Opportunities/OpportunityFormBase.php

Indentation +129 added lines, -129 removed lines

@@ -45,97 +45,97 @@ 
 
 
 function checkForDuplicates($prefix){
-	require_once('include/formbase.php');
+    require_once('include/formbase.php');
 	
-	$focus = new Opportunity();
-	$query = '';
-	$baseQuery = 'select id, name, sales_stage,amount, date_closed  from opportunities where deleted!=1 and (';
-
-	if(isset($_POST[$prefix.'name']) && !empty($_POST[$prefix.'name'])){
-		$query = $baseQuery ."  name like '%".$_POST[$prefix.'name']."%'";
-		$query .= getLikeForEachWord('name', $_POST[$prefix.'name']);
-	}
-
-	if(!empty($query)){
-		$rows = array();
-		global $db;
-		$result = $db->query($query.')');
-		$i=-1;
-		while(($row=$db->fetchByAssoc($result)) != null) {
-			$i++;
-			$rows[$i] = $row;
-		}
-		if ($i==-1) return null;
+    $focus = new Opportunity();
+    $query = '';
+    $baseQuery = 'select id, name, sales_stage,amount, date_closed  from opportunities where deleted!=1 and (';
+
+    if(isset($_POST[$prefix.'name']) && !empty($_POST[$prefix.'name'])){
+        $query = $baseQuery ."  name like '%".$_POST[$prefix.'name']."%'";
+        $query .= getLikeForEachWord('name', $_POST[$prefix.'name']);
+    }
+
+    if(!empty($query)){
+        $rows = array();
+        global $db;
+        $result = $db->query($query.')');
+        $i=-1;
+        while(($row=$db->fetchByAssoc($result)) != null) {
+            $i++;
+            $rows[$i] = $row;
+        }
+        if ($i==-1) return null;
 		
-		return $rows;		
-	}
-	return null;
+        return $rows;		
+    }
+    return null;
 }
 
 
 function buildTableForm($rows, $mod='Opportunities'){
-	if(!empty($mod)){
-	global $current_language;
-	$mod_strings = return_module_language($current_language, $mod);
-	}else global $mod_strings;
-	global $app_strings;
-	$cols = sizeof($rows[0]) * 2 + 1;
-	$form = '<table width="100%"><tr><td>'.$mod_strings['MSG_DUPLICATE']. '</td></tr><tr><td height="20"></td></tr></table>';
-
-	$form .= "<form action='index.php' method='post' name='dupOpps'><input type='hidden' name='selectedOpportunity' value=''>";
-	$form .= "<table width='100%' cellpadding='0' cellspacing='0' class='list view'>";
-	$form .= "<tr class='pagination'><td colspan='$cols'><table width='100%' cellspacing='0' cellpadding='0' border='0'><tr><td><input type='submit' class='button' name='ContinueOpportunity' value='${mod_strings['LNK_NEW_OPPORTUNITY']}'></td></tr></table></td></tr><tr>";
-	$form .= "<tr><td scope='col'>&nbsp;</td>";
+    if(!empty($mod)){
+    global $current_language;
+    $mod_strings = return_module_language($current_language, $mod);
+    }else global $mod_strings;
+    global $app_strings;
+    $cols = sizeof($rows[0]) * 2 + 1;
+    $form = '<table width="100%"><tr><td>'.$mod_strings['MSG_DUPLICATE']. '</td></tr><tr><td height="20"></td></tr></table>';
+
+    $form .= "<form action='index.php' method='post' name='dupOpps'><input type='hidden' name='selectedOpportunity' value=''>";
+    $form .= "<table width='100%' cellpadding='0' cellspacing='0' class='list view'>";
+    $form .= "<tr class='pagination'><td colspan='$cols'><table width='100%' cellspacing='0' cellpadding='0' border='0'><tr><td><input type='submit' class='button' name='ContinueOpportunity' value='${mod_strings['LNK_NEW_OPPORTUNITY']}'></td></tr></table></td></tr><tr>";
+    $form .= "<tr><td scope='col'>&nbsp;</td>";
     require_once('include/formbase.php');
-	$form .= getPostToForm();
-	if(isset($rows[0])){
-		foreach ($rows[0] as $key=>$value){
-			if($key != 'id'){
-					$form .= "<td scope='col'>". $mod_strings[$mod_strings['db_'.$key]]. "</td>";
-		}}
-		$form .= "</tr>";
-	}
-
-	$rowColor = 'oddListRowS1';
-	foreach($rows as $row){
-
-		$form .= "<tr class='$rowColor'>";
-
-		$form .= "<td width='1%' nowrap='nowrap'><a href='#' onclick='document.dupOpps.selectedOpportunity.value=\"${row['id']}\";document.dupOpps.submit();'>[${app_strings['LBL_SELECT_BUTTON_LABEL']}]</a>&nbsp;&nbsp;</td>";
-		$wasSet = false;
-		foreach ($row as $key=>$value){
-				if($key != 'id'){
-					if(!$wasSet){
-					$form .= "<td scope='row'><a target='_blank' href='index.php?module=Opportunities&action=DetailView&record=${row['id']}'>$value</a></td>";
-					$wasSet = true;
-					}else{
-					$form .= "<td><a target='_blank' href='index.php?module=Opportunities&action=DetailView&record=${row['id']}'>$value</a></td>";
-					}
-				}}
-
-		if($rowColor == 'evenListRowS1'){
-			$rowColor = 'oddListRowS1';
-		}else{
-			 $rowColor = 'evenListRowS1';
-		}
-		$form .= "</tr>";
-	}
+    $form .= getPostToForm();
+    if(isset($rows[0])){
+        foreach ($rows[0] as $key=>$value){
+            if($key != 'id'){
+                    $form .= "<td scope='col'>". $mod_strings[$mod_strings['db_'.$key]]. "</td>";
+        }}
+        $form .= "</tr>";
+    }
+
+    $rowColor = 'oddListRowS1';
+    foreach($rows as $row){
+
+        $form .= "<tr class='$rowColor'>";
+
+        $form .= "<td width='1%' nowrap='nowrap'><a href='#' onclick='document.dupOpps.selectedOpportunity.value=\"${row['id']}\";document.dupOpps.submit();'>[${app_strings['LBL_SELECT_BUTTON_LABEL']}]</a>&nbsp;&nbsp;</td>";
+        $wasSet = false;
+        foreach ($row as $key=>$value){
+                if($key != 'id'){
+                    if(!$wasSet){
+                    $form .= "<td scope='row'><a target='_blank' href='index.php?module=Opportunities&action=DetailView&record=${row['id']}'>$value</a></td>";
+                    $wasSet = true;
+                    }else{
+                    $form .= "<td><a target='_blank' href='index.php?module=Opportunities&action=DetailView&record=${row['id']}'>$value</a></td>";
+                    }
+                }}
+
+        if($rowColor == 'evenListRowS1'){
+            $rowColor = 'oddListRowS1';
+        }else{
+                $rowColor = 'evenListRowS1';
+        }
+        $form .= "</tr>";
+    }
     $form .= "<tr class='pagination'><td colspan='$cols'><table width='100%' cellspacing='0' cellpadding='0' border='0'><tr><td><input type='submit' class='button' name='ContinueOpportunity' value='${mod_strings['LNK_NEW_OPPORTUNITY']}'></td></tr></table></td></tr><tr>";
-	$form .= "</table><BR></form>";
+    $form .= "</table><BR></form>";
 
-	return $form;
+    return $form;
 
 
 
 }
 
 function getForm($prefix, $mod='Opportunities'){
-	if(!ACLController::checkAccess('Opportunities', 'edit', true)){
-		return '';
-	}
+    if(!ACLController::checkAccess('Opportunities', 'edit', true)){
+        return '';
+    }
 if(!empty($mod)){
-	global $current_language;
-	$mod_strings = return_module_language($current_language, $mod);
+    global $current_language;
+    $mod_strings = return_module_language($current_language, $mod);
 }else global $mod_strings;
 global $app_strings;
 global $sugar_version, $sugar_config;
@@ -165,18 +165,18 @@ 
 }
 
 function getWideFormBody($prefix, $mod='Opportunities', $formname='', $lead='', $showaccount = true){
-	if(!ACLController::checkAccess('Opportunities', 'edit', true)){
-		return '';
-	}
-	if(empty($lead)){
-		$lead = new Lead();
-	}
+    if(!ACLController::checkAccess('Opportunities', 'edit', true)){
+        return '';
+    }
+    if(empty($lead)){
+        $lead = new Lead();
+    }
 global $mod_strings, $sugar_config;
 $showaccount = $showaccount && $sugar_config['require_accounts'];
 $temp_strings = $mod_strings;
 if(!empty($mod)){
-	global $current_language;
-	$mod_strings = return_module_language($current_language, $mod);
+    global $current_language;
+    $mod_strings = return_module_language($current_language, $mod);
 }
 
 global $app_strings;
@@ -215,9 +215,9 @@ 
 $ntc_date_format = $timedate->get_user_date_format();
 $cal_dateformat = $timedate->get_cal_date_format();
 if (isset($lead->assigned_user_id)) {
-	$user_id=$lead->assigned_user_id;
+    $user_id=$lead->assigned_user_id;
 } else {
-	$user_id = $current_user->id;
+    $user_id = $current_user->id;
 }
 
 
@@ -229,9 +229,9 @@ 
 
 
 if (isset($lead->opportunity_amount)) {
-	$opp_amount=$lead->opportunity_amount;
+    $opp_amount=$lead->opportunity_amount;
 } else {
- 	$opp_amount='';
+        $opp_amount='';
 }
 $jsCalendarImage = SugarThemeRegistry::current()->getImageURL('jscalendar.gif');
 $the_form .= <<<EOQ
@@ -257,7 +257,7 @@ 
 </tr>
 EOQ;
 if($showaccount){
-	$the_form .= <<<EOQ
+    $the_form .= <<<EOQ
 <tr>
     <td scope="row">${mod_strings['LBL_ACCOUNT_NAME']}&nbsp;<span class="required">${lbl_required_symbol}</span></td>
 </tr>
@@ -285,9 +285,9 @@ 
 </tr>
 EOQ;
 //carry forward custom lead fields to opportunities during Lead Conversion
-	$tempOpp = new Opportunity();
-	if (method_exists($lead, 'convertCustomFieldsForm')) $lead->convertCustomFieldsForm($the_form, $tempOpp, $prefix);
-	unset($tempOpp);
+    $tempOpp = new Opportunity();
+    if (method_exists($lead, 'convertCustomFieldsForm')) $lead->convertCustomFieldsForm($the_form, $tempOpp, $prefix);
+    unset($tempOpp);
 
 $the_form .= <<<EOQ
 
@@ -315,12 +315,12 @@ 
 } // end getWideFormBody
 
 function getFormBody($prefix, $mod='Opportunities', $formname=''){
-	if(!ACLController::checkAccess('Opportunities', 'edit', true)){
-		return '';
-	}
+    if(!ACLController::checkAccess('Opportunities', 'edit', true)){
+        return '';
+    }
 if(!empty($mod)){
-	global $current_language;
-	$mod_strings = return_module_language($current_language, $mod);
+    global $current_language;
+    $mod_strings = return_module_language($current_language, $mod);
 }else global $mod_strings;
 global $app_strings;
 global $app_list_strings;
@@ -363,13 +363,13 @@ 
 /// SETUP ACCOUNT POPUP
 
 $popup_request_data = array(
-	'call_back_function' => 'set_return',
-	'form_name' => "{$prefix}OppSave",
-	'field_to_name_array' => array(
-		'id' => 'account_id',
-		'name' => 'account_name',
-		),
-	);
+    'call_back_function' => 'set_return',
+    'form_name' => "{$prefix}OppSave",
+    'field_to_name_array' => array(
+        'id' => 'account_id',
+        'name' => 'account_name',
+        ),
+    );
 
 $json = getJSONobj();
 $encoded_popup_request_data = $json->encode($popup_request_data);
@@ -429,12 +429,12 @@ 
     global $current_user;
 	
 	
-	require_once('include/formbase.php');
+    require_once('include/formbase.php');
 	
-	$focus = new Opportunity();
-	if($useRequired &&  !checkRequired($prefix, array_keys($focus->required_fields))){
-		return null;
-	}
+    $focus = new Opportunity();
+    if($useRequired &&  !checkRequired($prefix, array_keys($focus->required_fields))){
+        return null;
+    }
 
     if(empty($_POST['currency_id'])){
         $currency_id = $current_user->getPreference('currency');
@@ -442,28 +442,28 @@ 
             $focus->currency_id =   $currency_id;
         }
     }
-	$focus = populateFromPost($prefix, $focus);
-	if( !ACLController::checkAccess($focus->module_dir, 'edit', $focus->isOwner($current_user->id))){
-		ACLController::displayNoAccess(true);
-	}
-	$check_notify = FALSE;
-	if (isset($GLOBALS['check_notify'])) {
-		$check_notify = $GLOBALS['check_notify'];
-	}
-
-	$focus->save($check_notify);
-
-	if(!empty($_POST['duplicate_parent_id'])){
-		clone_relationship($focus->db, array('opportunities_contacts'),'opportunity_id',  $_POST['duplicate_parent_id'], $focus->id);
-	}
-	$return_id = $focus->id;
+    $focus = populateFromPost($prefix, $focus);
+    if( !ACLController::checkAccess($focus->module_dir, 'edit', $focus->isOwner($current_user->id))){
+        ACLController::displayNoAccess(true);
+    }
+    $check_notify = FALSE;
+    if (isset($GLOBALS['check_notify'])) {
+        $check_notify = $GLOBALS['check_notify'];
+    }
+
+    $focus->save($check_notify);
+
+    if(!empty($_POST['duplicate_parent_id'])){
+        clone_relationship($focus->db, array('opportunities_contacts'),'opportunity_id',  $_POST['duplicate_parent_id'], $focus->id);
+    }
+    $return_id = $focus->id;
 	
-	$GLOBALS['log']->debug("Saved record with id of ".$return_id);
-	if($redirect){
-		handleRedirect($return_id,"Opportunities" );
-	}else{
-		return $focus;
-	}
+    $GLOBALS['log']->debug("Saved record with id of ".$return_id);
+    if($redirect){
+        handleRedirect($return_id,"Opportunities" );
+    }else{
+        return $focus;
+    }
 }
 
 }

modules/ProspectLists/field_arrays.php

Indentation +8 added lines, -8 removed lines

@@ -46,15 +46,15 @@
  * Contributor(s): ______________________________________..
  ********************************************************************************/
 $fields_array['ProspectList'] = array ('column_fields' => array(
-				"id", "date_entered",
-				"date_modified", "modified_user_id",
-				"assigned_user_id", "created_by",
-				"name", "description",'list_type','domain_name',
-	),
+                "id", "date_entered",
+                "date_modified", "modified_user_id",
+                "assigned_user_id", "created_by",
+                "name", "description",'list_type','domain_name',
+    ),
         'list_fields' =>  array(
-				'id', 'name', 'description','list_type',
-				'assigned_user_id','assigned_user_name',
-	),
+                'id', 'name', 'description','list_type',
+                'assigned_user_id','assigned_user_name',
+    ),
     'required_fields' =>  array('name'=>1,'list_type'=>2),
 );
 ?>
\ No newline at end of file