adamjakab / SuiteCRM

include/generic/SugarWidgets/SugarWidgetFieldcurrency_id.php

Spacing +3 added lines, -3 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -81,7 +81,7 @@ 
         {
             $currency = new Currency();
             $currency->retrieve($value);
-            $currencies[$value] = $currency->symbol . ' ' . $currency->iso4217;
+            $currencies[$value] = $currency->symbol.' '.$currency->iso4217;
         }
         return $currencies[$value];
     }
@@ -98,7 +98,7 @@ 
         $list = array();
         foreach ($tmpList as $bean)
         {
-            $list[$bean->id] = $bean->symbol . ' ' . $bean->iso4217;
+            $list[$bean->id] = $bean->symbol.' '.$bean->iso4217;
         }
 
         $field_def = $this->reporter->all_fields[$layout_def['column_key']];

include/generic/SugarWidgets/SugarWidgetSubPanelLoadSignedButton.php

Spacing +17 added lines, -17 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -55,27 +55,27 @@ 
 		global $app_strings;
 		
 
-		$href = 'index.php?module=' . 'Documents'
-			. '&action=' . 'EditView'
-			. '&record=' . $layout_def['fields']['ID']
-			. '&return_module=' . $_REQUEST['module']
-			. '&return_action=' . 'DetailView'
-			. '&return_id=' . $_REQUEST['record']
-			. '&load_signed_id=' . $layout_def['fields']['LINKED_ID']
-			. '&parent_id=' . $_REQUEST['record']			
-			. '&parent_name=' . $layout_def['fields']['CONTRACT_NAME']			
-			. '&parent_type=' . $_REQUEST['module']			
-			. '&selected_revision_id=' . $layout_def['fields']['SELECTED_REVISION_ID']	
+		$href = 'index.php?module='.'Documents'
+			. '&action='.'EditView'
+			. '&record='.$layout_def['fields']['ID']
+			. '&return_module='.$_REQUEST['module']
+			. '&return_action='.'DetailView'
+			. '&return_id='.$_REQUEST['record']
+			. '&load_signed_id='.$layout_def['fields']['LINKED_ID']
+			. '&parent_id='.$_REQUEST['record']			
+			. '&parent_name='.$layout_def['fields']['CONTRACT_NAME']			
+			. '&parent_type='.$_REQUEST['module']			
+			. '&selected_revision_id='.$layout_def['fields']['SELECTED_REVISION_ID']	
 			;
 
-		$edit_icon_html = SugarThemeRegistry::current()->getImage( 'loadSignedDocument','align="absmiddle" border="0"',null,null,'.gif',$app_strings['LNK_LOAD_SIGNED']);
+		$edit_icon_html = SugarThemeRegistry::current()->getImage('loadSignedDocument', 'align="absmiddle" border="0"', null, null, '.gif', $app_strings['LNK_LOAD_SIGNED']);
 		//if the contract state is executed or document is not a template hide this action.
-		if ((!empty($layout_def['fields']['CONTRACT_STATUS']) && $layout_def['fields']['CONTRACT_STATUS']=='executed') or
-			empty($layout_def['fields']['IS_TEMPLATE']) or $layout_def['fields']['IS_TEMPLATE']==0) {
+		if ((!empty($layout_def['fields']['CONTRACT_STATUS']) && $layout_def['fields']['CONTRACT_STATUS'] == 'executed') or
+			empty($layout_def['fields']['IS_TEMPLATE']) or $layout_def['fields']['IS_TEMPLATE'] == 0) {
 			return "";
 		}
-		return '<a href="' . $href . '"' . "title ='". $app_strings['LNK_LOAD_SIGNED_TOOLTIP']."'"
-			. 'class="listViewTdToolsS1">' . $edit_icon_html . '&nbsp;' . $app_strings['LNK_LOAD_SIGNED'] .'</a>&nbsp;';
+		return '<a href="'.$href.'"'."title ='".$app_strings['LNK_LOAD_SIGNED_TOOLTIP']."'"
+			. 'class="listViewTdToolsS1">'.$edit_icon_html.'&nbsp;'.$app_strings['LNK_LOAD_SIGNED'].'</a>&nbsp;';
 	}
 		
 }

include/generic/SugarWidgets/SugarWidgetFieldbool.php

Spacing +4 added lines, -4 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -51,7 +51,7 @@ 
 			return "(".$this->_get_column_select($layout_def)." LIKE 'on' OR ".$this->_get_column_select($layout_def)."='1')\n";
 		} else {
 			//return "(".$this->_get_column_select($layout_def)." is null OR ".$this->_get_column_select($layout_def)."='0' OR ".$this->_get_column_select($layout_def)."='off')\n";
-            return "(".$this->_get_column_select($layout_def)." is null OR ". $this->_get_column_select($layout_def)."='0')\n";            
+            return "(".$this->_get_column_select($layout_def)." is null OR ".$this->_get_column_select($layout_def)."='0')\n";            
 		}
  }
 
@@ -63,7 +63,7 @@ 
         $key = $this->_get_column_alias($layout_def);
         $key = strtoupper($key);
         
-        if(empty($layout_def['fields'][$key]))
+        if (empty($layout_def['fields'][$key]))
         {
             $layout_def['name'] = $name;
             global $app_list_strings;
@@ -77,7 +77,7 @@ 
         }
 
         $on_or_off = 'CHECKED';
-        if ( empty($value) ||  $value == 'off')
+        if (empty($value) || $value == 'off')
         {
             $on_or_off = '';
         }

include/generic/SugarWidgets/SugarWidgetSubPanelTopCreateAccountNameButton.php

Spacing +8 added lines, -8 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -59,23 +59,23 @@ 
 		//$accesskey = $app_strings['LBL_NEW_BUTTON_KEY'];
 		$value = $app_strings['LBL_NEW_BUTTON_LABEL'];
 		$this->module = 'Contacts';
-		if( ACLController::moduleSupportsACL($defines['module'])  && !ACLController::checkAccess($defines['module'], 'edit', true)){
+		if (ACLController::moduleSupportsACL($defines['module']) && !ACLController::checkAccess($defines['module'], 'edit', true)) {
 			$button = "<input title='$title'class='button' type='button' name='button' value='  $value  ' disabled/>\n";
 			return $button;
 		}
 		
 		$additionalFormFields = array();
-		if(isset($defines['focus']->billing_address_street)) 
+		if (isset($defines['focus']->billing_address_street)) 
 			$additionalFormFields['primary_address_street'] = $defines['focus']->billing_address_street;
-		if(isset($defines['focus']->billing_address_city)) 
+		if (isset($defines['focus']->billing_address_city)) 
 			$additionalFormFields['primary_address_city'] = $defines['focus']->billing_address_city;						  		
-		if(isset($defines['focus']->billing_address_state)) 
+		if (isset($defines['focus']->billing_address_state)) 
 			$additionalFormFields['primary_address_state'] = $defines['focus']->billing_address_state;
-		if(isset($defines['focus']->billing_address_country)) 
+		if (isset($defines['focus']->billing_address_country)) 
 			$additionalFormFields['primary_address_country'] = $defines['focus']->billing_address_country;
-		if(isset($defines['focus']->billing_address_postalcode)) 
+		if (isset($defines['focus']->billing_address_postalcode)) 
 			$additionalFormFields['primary_address_postalcode'] = $defines['focus']->billing_address_postalcode;
-		if(isset($defines['focus']->phone_office)) 
+		if (isset($defines['focus']->phone_office)) 
 			$additionalFormFields['phone_work'] = $defines['focus']->phone_office;
 		
 		

include/generic/SugarWidgets/SugarWidgetSubPanelRemoveButtonMeetings.php

Spacing +10 added lines, -10 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -67,12 +67,12 @@ 
 		$return_id = $_REQUEST['record'];
 		
 		
-		if(isset($GLOBALS['FOCUS'])) {	
+		if (isset($GLOBALS['FOCUS'])) {	
 			$focus = $GLOBALS['FOCUS'];
 		}
 		
         /* Handle case where we generate subpanels from MySettings/LoadTabSubpanels.php */
-        else if($return_module == 'MySettings') {
+        else if ($return_module == 'MySettings') {
         	global $beanList, $beanFiles;
             $return_module = $_REQUEST['loadModule'];
             
@@ -86,12 +86,12 @@ 
 		//if($focus->assigned_user_id == $record) return '';
 		
 		if (isset($layout_def['linked_field_set']) && !empty($layout_def['linked_field_set'])) {
-			$linked_field= $layout_def['linked_field_set'] ;
+			$linked_field = $layout_def['linked_field_set'];
 		} else {
 			$linked_field = $layout_def['linked_field'];
 		}
 		$refresh_page = 0;
-		if(!empty($layout_def['refresh_page'])){
+		if (!empty($layout_def['refresh_page'])) {
 			$refresh_page = 1;
 		}
 		$return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel&record=$return_id&sugar_body_only=1";
@@ -103,15 +103,15 @@ 
 			. "&record=$parent_record_id"
 			. "&linked_field=$linked_field"
 			. "&linked_id=$record"
-			. "&return_url=" . urlencode(urlencode($return_url))
+			. "&return_url=".urlencode(urlencode($return_url))
 			. "&refresh_page=$refresh_page"
 			. $layout_def['end_link_wrapper'];
 		$remove_confirmation_text = $app_strings['NTC_REMOVE_CONFIRMATION'];
 		//based on listview since that lets you select records
-		if($layout_def['ListView']) {
-            return "<a href=\"javascript:sub_p_rem('$subpanel', '$linked_field'" .", '$record', $refresh_page);\""
-			        . ' class="listViewTdToolsS1"' . " onclick=\"return sp_rem_conf();\"" . ">$icon_remove_text</a>";
-		}else{
+		if ($layout_def['ListView']) {
+            return "<a href=\"javascript:sub_p_rem('$subpanel', '$linked_field'".", '$record', $refresh_page);\""
+			        . ' class="listViewTdToolsS1"'." onclick=\"return sp_rem_conf();\"".">$icon_remove_text</a>";
+		} else {
 			return '';
 		}
 	}

include/generic/SugarWidgets/SugarWidgetFielduser_name.php

Spacing +2 added lines, -2 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -46,7 +46,7 @@ 
  function displayInput(&$layout_def) 
  {
         $selected_users = empty($layout_def['input_name0']) ? '' : $layout_def['input_name0'];
- 		$str = '<select multiple="true" size="3" name="' . $layout_def['name'] . '[]">' . get_select_options_with_id(get_user_array(false), $selected_users) . '</select>';
+ 		$str = '<select multiple="true" size="3" name="'.$layout_def['name'].'[]">'.get_select_options_with_id(get_user_array(false), $selected_users).'</select>';
  		return $str;
  }
 }

include/generic/SugarWidgets/SugarWidgetSubPanelIcon.php

Spacing +27 added lines, -27 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -56,7 +56,7 @@ 
 		global $app_list_strings;
 		global $current_user;
 
-		if(isset($layout_def['varname']))
+		if (isset($layout_def['varname']))
 		{
 			$key = strtoupper($layout_def['varname']);
 		}
@@ -67,14 +67,14 @@ 
 		}
 //add module image
 		//add module image
-		if(!empty($layout_def['target_module_key'])) {
+		if (!empty($layout_def['target_module_key'])) {
 			if (!empty($layout_def['fields'][strtoupper($layout_def['target_module_key'])])) {
-				$module=$layout_def['fields'][strtoupper($layout_def['target_module_key'])];
+				$module = $layout_def['fields'][strtoupper($layout_def['target_module_key'])];
 			}
 		}
 
         if (empty($module)) {
-			if(empty($layout_def['target_module']))
+			if (empty($layout_def['target_module']))
 			{
 				$module = $layout_def['module'];
 			}
@@ -84,7 +84,7 @@ 
 			}
 		}
 		$action = 'DetailView';
-		if(empty($layout_def['target_record_key']))
+		if (empty($layout_def['target_record_key']))
 		{
 			$record = $layout_def['fields']['ID'];
 		}
@@ -94,70 +94,70 @@ 
 			$record = $layout_def['fields'][$record_key];
 		}
 		$action_access = false;
-		if(!empty($record) &&
+		if (!empty($record) &&
 			($layout_def[$action] && !$layout_def['owner_module']
 			||  $layout_def[$action] && !ACLController::moduleSupportsACL($layout_def['owner_module'])
 			|| ACLController::checkAccess($layout_def['owner_module'], 'view', $layout_def['owner_id'] == $current_user->id))) {
 			$action_access = true;
 		}
-		$icon_img_html = SugarThemeRegistry::current()->getImage( $module . '', 'border="0"',null,null,'.gif',$app_list_strings['moduleList'][$module]);
+		$icon_img_html = SugarThemeRegistry::current()->getImage($module.'', 'border="0"', null, null, '.gif', $app_list_strings['moduleList'][$module]);
 		if (!empty($layout_def['attachment_image_only']) && $layout_def['attachment_image_only'] == true) {
-			$ret="";
+			$ret = "";
 		} else {
 			if ($action_access) {
-				$ret = '<a href="index.php?module=' . $module . '&action=' . $action . '&record=' . $record	. '" >' . $icon_img_html . "</a>";
+				$ret = '<a href="index.php?module='.$module.'&action='.$action.'&record='.$record.'" >'.$icon_img_html."</a>";
 			} else {
 				$ret = $icon_img_html;
 			}
 		}
 
-		if(!empty($layout_def['image2']) &&  !empty($layout_def['image2_ext_url_field'])){
+		if (!empty($layout_def['image2']) && !empty($layout_def['image2_ext_url_field'])) {
 
 			if (!empty($layout_def['fields'][strtoupper($layout_def['image2_ext_url_field'])])) {
-				$link_url  = $layout_def['fields'][strtoupper($layout_def['image2_ext_url_field'])];
+				$link_url = $layout_def['fields'][strtoupper($layout_def['image2_ext_url_field'])];
 			}
 
             $imagePath = '';
-            if ( $layout_def['image2'] == '__VARIABLE' ) {
-                if ( !empty($layout_def['fields'][$key.'_ICON']) ) {
+            if ($layout_def['image2'] == '__VARIABLE') {
+                if (!empty($layout_def['fields'][$key.'_ICON'])) {
                     $imagePath = $layout_def['fields'][$key.'_ICON'];
                 }
             } else {
                 $imagePath = $layout_def['image2'];
             }
 
-            if ( !empty($imagePath) ) {
-                $icon_img_html = SugarThemeRegistry::current()->getImage( $imagePath . '', 'border="0"',null,null,'.gif',$imagePath);
-                $ret.= (empty($link_url)) ? '' : '&nbsp;<a href="' . $link_url. '" TARGET = "_blank">' . "$icon_img_html</a>";
+            if (!empty($imagePath)) {
+                $icon_img_html = SugarThemeRegistry::current()->getImage($imagePath.'', 'border="0"', null, null, '.gif', $imagePath);
+                $ret .= (empty($link_url)) ? '' : '&nbsp;<a href="'.$link_url.'" TARGET = "_blank">'."$icon_img_html</a>";
             }
         }
 //if requested, add attachment icon.
-		if(!empty($layout_def['image2']) && !empty($layout_def['image2_url_field'])){
+		if (!empty($layout_def['image2']) && !empty($layout_def['image2_url_field'])) {
 
 			if (is_array($layout_def['image2_url_field'])) {
 				//Generate file url.
 				if (!empty($layout_def['fields'][strtoupper($layout_def['image2_url_field']['id_field'])])
-				and !empty($layout_def['fields'][strtoupper($layout_def['image2_url_field']['filename_field'])]) ) {
+				and !empty($layout_def['fields'][strtoupper($layout_def['image2_url_field']['filename_field'])])) {
 
-					$key=$layout_def['fields'][strtoupper($layout_def['image2_url_field']['id_field'])];
-                    $file=$layout_def['fields'][strtoupper($layout_def['image2_url_field']['filename_field'])];
-                    $filepath="index.php?entryPoint=download&id=".$key."&type=".$layout_def['module'];
+					$key = $layout_def['fields'][strtoupper($layout_def['image2_url_field']['id_field'])];
+                    $file = $layout_def['fields'][strtoupper($layout_def['image2_url_field']['filename_field'])];
+                    $filepath = "index.php?entryPoint=download&id=".$key."&type=".$layout_def['module'];
 				}
 			} else {
 				if (!empty($layout_def['fields'][strtoupper($layout_def['image2_url_field'])])) {
-					$filepath="index.php?entryPoint=download&id=".$layout_def['fields']['ID']."&type=".$layout_def['module'];
+					$filepath = "index.php?entryPoint=download&id=".$layout_def['fields']['ID']."&type=".$layout_def['module'];
 				}
 			}
-			$icon_img_html = SugarThemeRegistry::current()->getImage( $layout_def['image2'] . '', 'border="0"',null,null,'.gif',$layout_def['image2']);
+			$icon_img_html = SugarThemeRegistry::current()->getImage($layout_def['image2'].'', 'border="0"', null, null, '.gif', $layout_def['image2']);
 			if ($action_access && !empty($filepath)) {
-				$ret .= '<a href="' . $filepath. '" >' . "$icon_img_html</a>";
+				$ret .= '<a href="'.$filepath.'" >'."$icon_img_html</a>";
 			} elseif (!empty($filepath)) {
 				$ret .= $icon_img_html;
 			}
 		}
 		// now handle attachments for Emails
-		else if(!empty($layout_def['module']) && $layout_def['module'] == 'Emails' && !empty($layout_def['fields']['ATTACHMENT_IMAGE'])) {
-			$ret.= $layout_def['fields']['ATTACHMENT_IMAGE'];
+		else if (!empty($layout_def['module']) && $layout_def['module'] == 'Emails' && !empty($layout_def['fields']['ATTACHMENT_IMAGE'])) {
+			$ret .= $layout_def['fields']['ATTACHMENT_IMAGE'];
 		}
 		return $ret;
 	}

include/generic/SugarWidgets/SugarWidgetSubPanelConcat.php

Spacing +4 added lines, -4 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -47,15 +47,15 @@ 
 {
 	function displayList(&$layout_def)
 	{
-		$value='';
+		$value = '';
 		if (isset($layout_def['source']) and is_array($layout_def['source']) and isset($layout_def['fields']) and is_array($layout_def['fields'])) {
 			
 			foreach ($layout_def['source'] as $field) {
 			
 				if (isset($layout_def['fields'][strtoupper($field)])) {
-					$value.=$layout_def['fields'][strtoupper($field)];
+					$value .= $layout_def['fields'][strtoupper($field)];
 				} else {
-					$value.=$field;
+					$value .= $field;
 				}	
 			}
 		}

include/generic/DeleteRelationship.php

Spacing +20 added lines, -20 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
+if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 /*********************************************************************************
  * SugarCRM Community Edition is a customer relationship management program developed by
  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
@@ -66,18 +66,18 @@ 
 
 require_once('include/formbase.php');
 
- global $beanFiles,$beanList;
+ global $beanFiles, $beanList;
  $bean_name = $beanList[$_REQUEST['module']];
  require_once($beanFiles[$bean_name]);
  $focus = new $bean_name();
- if (  empty($_REQUEST['linked_id']) || empty($_REQUEST['linked_field'])  || empty($_REQUEST['record']))
+ if (empty($_REQUEST['linked_id']) || empty($_REQUEST['linked_field']) || empty($_REQUEST['record']))
  {
 	die("need linked_field, linked_id and record fields");
  }
  $linked_field = $_REQUEST['linked_field'];
  $record = $_REQUEST['record'];
  $linked_id = $_REQUEST['linked_id'];
- if($bean_name == 'Team')
+ if ($bean_name == 'Team')
  {
  	$focus->retrieve($record);
  	$focus->remove_user_from_team($linked_id);
@@ -86,21 +86,21 @@ 
  {
  	// cut it off:
  	$focus->load_relationship($linked_field);
- 	if($focus->$linked_field->_relationship->relationship_name == 'quotes_contacts_shipto')
+ 	if ($focus->$linked_field->_relationship->relationship_name == 'quotes_contacts_shipto')
  		unset($focus->$linked_field->_relationship->relationship_role_column);
- 	$focus->$linked_field->delete($record,$linked_id);
+ 	$focus->$linked_field->delete($record, $linked_id);
  }
- if ($bean_name == 'Campaign' and $linked_field=='prospectlists' ) {
+ if ($bean_name == 'Campaign' and $linked_field == 'prospectlists') {
 
- 	$query="SELECT email_marketing_prospect_lists.id from email_marketing_prospect_lists ";
- 	$query.=" left join email_marketing on email_marketing.id=email_marketing_prospect_lists.email_marketing_id";
-	$query.=" where email_marketing.campaign_id='$record'";
- 	$query.=" and email_marketing_prospect_lists.prospect_list_id='$linked_id'";
+ 	$query = "SELECT email_marketing_prospect_lists.id from email_marketing_prospect_lists ";
+ 	$query .= " left join email_marketing on email_marketing.id=email_marketing_prospect_lists.email_marketing_id";
+	$query .= " where email_marketing.campaign_id='$record'";
+ 	$query .= " and email_marketing_prospect_lists.prospect_list_id='$linked_id'";
 
- 	$result=$focus->db->query($query);
-	while (($row=$focus->db->fetchByAssoc($result)) != null) {
-			$del_query =" update email_marketing_prospect_lists set email_marketing_prospect_lists.deleted=1, email_marketing_prospect_lists.date_modified=".$focus->db->convert("'".TimeDate::getInstance()->nowDb()."'",'datetime');
- 			$del_query.=" WHERE  email_marketing_prospect_lists.id='{$row['id']}'";
+ 	$result = $focus->db->query($query);
+	while (($row = $focus->db->fetchByAssoc($result)) != null) {
+			$del_query = " update email_marketing_prospect_lists set email_marketing_prospect_lists.deleted=1, email_marketing_prospect_lists.date_modified=".$focus->db->convert("'".TimeDate::getInstance()->nowDb()."'", 'datetime');
+ 			$del_query .= " WHERE  email_marketing_prospect_lists.id='{$row['id']}'";
 		 	$focus->db->query($del_query);
 	}
  	$focus->db->query($query);
@@ -111,7 +111,7 @@ 
     $user->retrieve($linked_id);
     if (!empty($user->id)) {  //make sure that record exists. we may have a contact on our hands.
 
-    	if($focus->update_vcal)
+    	if ($focus->update_vcal)
     	{
         	vCal::cache_sugar_vcal($user);
     	}
@@ -122,11 +122,11 @@ 
     $eapm->mark_deleted($linked_id);
 }
 
-if(!empty($_REQUEST['return_url'])){
-	$_REQUEST['return_url'] =urldecode($_REQUEST['return_url']);
+if (!empty($_REQUEST['return_url'])) {
+	$_REQUEST['return_url'] = urldecode($_REQUEST['return_url']);
 }
-$GLOBALS['log']->debug("deleted relationship: bean: $bean_name, linked_field: $linked_field, linked_id:$linked_id" );
-if(empty($_REQUEST['refresh_page'])){
+$GLOBALS['log']->debug("deleted relationship: bean: $bean_name, linked_field: $linked_field, linked_id:$linked_id");
+if (empty($_REQUEST['refresh_page'])) {
 	handleRedirect();
 }