adamjakab / SuiteCRM

include/generic/SugarWidgets/SugarWidgetFielddate.php

Indentation +14 added lines, -14 removed lines

@@ -54,7 +54,7 @@ 
             }
         }
         $content = $this->displayListPlain($layout_def);
-		return $content;
+        return $content;
     }
 
     function queryFilterBefore($layout_def)
@@ -88,26 +88,26 @@ 
             $this->queryDateOp($column, $end, "<=", "date").")\n";
     }
 
-	function queryFilterTP_yesterday($layout_def)
-	{
-		global $timedate;
+    function queryFilterTP_yesterday($layout_def)
+    {
+        global $timedate;
         $layout_def['input_name0'] = $timedate->asDbDate($timedate->getNow(true)->get("-1 day"));
         return $this->queryFilterOn($layout_def);
-	}
+    }
 
-	function queryFilterTP_today($layout_def)
-	{
-		global $timedate;
+    function queryFilterTP_today($layout_def)
+    {
+        global $timedate;
         $layout_def['input_name0'] = $timedate->asDbDate($timedate->getNow(true));
         return $this->queryFilterOn($layout_def);
-	}
+    }
 
-	function queryFilterTP_tomorrow(& $layout_def)
-	{
-		global $timedate;
-		$layout_def['input_name0'] = $timedate->asDbDate($timedate->getNow(true)->get("+1 day"));
+    function queryFilterTP_tomorrow(& $layout_def)
+    {
+        global $timedate;
+        $layout_def['input_name0'] = $timedate->asDbDate($timedate->getNow(true)->get("+1 day"));
         return $this->queryFilterOn($layout_def);
-	}
+    }
 
     protected function queryMonth($layout_def, $month)
     {

include/generic/SugarWidgets/SugarWidget.php

Indentation +38 added lines, -38 removed lines

@@ -49,37 +49,37 @@ 
  */
 class SugarWidget
 {
-	var $layout_manager = null;
-	var $widget_id;
+    var $layout_manager = null;
+    var $widget_id;
     protected $form_value;
     protected $parent_bean;
 
-	function SugarWidget(&$layout_manager)
-	{
-		$this->layout_manager = $layout_manager;
-	}
-	function display($layout_def)
-	{
-		return 'display class undefined';
-	}
+    function SugarWidget(&$layout_manager)
+    {
+        $this->layout_manager = $layout_manager;
+    }
+    function display($layout_def)
+    {
+        return 'display class undefined';
+    }
 
-	/**
-	 * getSubpanelWidgetId
-	 * This is a utility function to return a widget's unique id
-	 * @return id String label of the widget's unique id
-	 */
-	public function getWidgetId() {
-	   return $this->widget_id;
-	}
+    /**
+     * getSubpanelWidgetId
+     * This is a utility function to return a widget's unique id
+     * @return id String label of the widget's unique id
+     */
+    public function getWidgetId() {
+        return $this->widget_id;
+    }
 
-	/**
-	 * setSubpanelWidgetId
-	 * This is a utility function to set the id for a widget
-	 * @param id String value to set the widget's unique id
-	 */
-	public function setWidgetId($id='') {
-		$this->widget_id = $id;
-	}
+    /**
+     * setSubpanelWidgetId
+     * This is a utility function to set the id for a widget
+     * @param id String value to set the widget's unique id
+     */
+    public function setWidgetId($id='') {
+        $this->widget_id = $id;
+    }
 
     public function getDisplayName()
     {
@@ -94,20 +94,20 @@ 
     {
         $this->parent_bean = $parent_bean;
     }
-   /**
-    * getTruncatedColumnAlias
-    * This function ensures that a column alias is no more than 28 characters.  Should the column_name
-    * argument exceed 28 charcters, it creates an alias using the first 22 characters of the column_name
-    * plus an md5 of the first 6 characters of the lowercased column_name value.
-    *
-    */
+    /**
+     * getTruncatedColumnAlias
+     * This function ensures that a column alias is no more than 28 characters.  Should the column_name
+     * argument exceed 28 charcters, it creates an alias using the first 22 characters of the column_name
+     * plus an md5 of the first 6 characters of the lowercased column_name value.
+     *
+     */
     protected function getTruncatedColumnAlias($column_name)
     {
-	  	if(empty($column_name) || !is_string($column_name) || strlen($column_name) < 28)
-	  	{
-	  	   return $column_name;
-	  	}
-	    return strtoupper(substr($column_name,0,22) . substr(md5(strtolower($column_name)), 0, 6));
+            if(empty($column_name) || !is_string($column_name) || strlen($column_name) < 28)
+            {
+                return $column_name;
+            }
+        return strtoupper(substr($column_name,0,22) . substr(md5(strtolower($column_name)), 0, 6));
     }
 }
 

include/generic/SugarWidgets/SugarWidgetFieldfloat.php

Indentation +26 added lines, -26 removed lines

@@ -41,8 +41,8 @@ 
 
 class SugarWidgetFieldFloat extends SugarWidgetFieldInt
 {
- function displayList($layout_def)
- {
+    function displayList($layout_def)
+    {
  	
     $vardef = $this->getVardef($layout_def);
 
@@ -51,37 +51,37 @@ 
     } else {
         $precision = null;
     }
-	return format_number(parent::displayListPlain($layout_def), $precision, $precision);
- }
+    return format_number(parent::displayListPlain($layout_def), $precision, $precision);
+    }
 
- function displayListPlain($layout_def)
- {
-     return $this->displayList($layout_def);
- }
- function queryFilterEquals(&$layout_def)
- {	
+    function displayListPlain($layout_def)
+    {
+        return $this->displayList($layout_def);
+    }
+    function queryFilterEquals(&$layout_def)
+    {	
     return $this->_get_column_select($layout_def)."= ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n";
- }
+    }
                                                                                  
- function queryFilterNot_Equals(&$layout_def)
- {
-	return $this->_get_column_select($layout_def)."!=".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n";
- }
+    function queryFilterNot_Equals(&$layout_def)
+    {
+    return $this->_get_column_select($layout_def)."!=".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n";
+    }
                                                                                  
- function queryFilterGreater(&$layout_def)
- {
+    function queryFilterGreater(&$layout_def)
+    {
     return $this->_get_column_select($layout_def)." > ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n";
- }
+    }
                                                                                  
- function queryFilterLess(&$layout_def)
- {
-	return $this->_get_column_select($layout_def)." < ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n";
- }
+    function queryFilterLess(&$layout_def)
+    {
+    return $this->_get_column_select($layout_def)." < ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n";
+    }
 
- function queryFilterBetween(&$layout_def)
- {
-	return $this->_get_column_select($layout_def)." BETWEEN ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0'])). " AND " . $GLOBALS['db']->quote(unformat_number($layout_def['input_name1'])) . "\n";
- }
+    function queryFilterBetween(&$layout_def)
+    {
+    return $this->_get_column_select($layout_def)." BETWEEN ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0'])). " AND " . $GLOBALS['db']->quote(unformat_number($layout_def['input_name1'])) . "\n";
+    }
 
 
 }

include/generic/SugarWidgets/SugarWidgetFieldsingleenum.php

Indentation +4 added lines, -4 removed lines

@@ -51,13 +51,13 @@
                 $ops = $layout_def['options'];
             }
             elseif (isset($layout_def['options']) && isset($app_list_strings[$layout_def['options']])){ 
-            	$ops = $app_list_strings[$layout_def['options']];
+                $ops = $app_list_strings[$layout_def['options']];
                 if(array_key_exists('', $app_list_strings[$layout_def['options']])) {
-             	   unset($ops['']);
-	            }
+                    unset($ops['']);
+                }
             }
             else{
-            	$ops = array();
+                $ops = array();
             }
         }
         else {

include/generic/SugarWidgets/SugarWidgetReportField.php

Indentation +166 added lines, -166 removed lines

@@ -54,30 +54,30 @@ 
      */
     protected $reporter;
 
-	function SugarWidgetReportField(&$layout_manager) {
+    function SugarWidgetReportField(&$layout_manager) {
         parent::SugarWidgetField($layout_manager);
         $this->reporter = $this->layout_manager->getAttribute("reporter");
     }
 
-	function  getSubClass($layout_def)
-	{
-		if (! empty($layout_def['type']))
-		{
-
-			if ($layout_def['type'] == 'time') {
-				$layout_def['widget_class'] = 'Fielddate';
-			} else {
-				$layout_def['widget_class'] = 'Field'.$layout_def['type'];
-			}
-			return $this->layout_manager->getClassFromWidgetDef($layout_def);
-		} else {
-			return $this;
-		}
-	}
-
-
- function display($layout_def)
- {
+    function  getSubClass($layout_def)
+    {
+        if (! empty($layout_def['type']))
+        {
+
+            if ($layout_def['type'] == 'time') {
+                $layout_def['widget_class'] = 'Fielddate';
+            } else {
+                $layout_def['widget_class'] = 'Field'.$layout_def['type'];
+            }
+            return $this->layout_manager->getClassFromWidgetDef($layout_def);
+        } else {
+            return $this;
+        }
+    }
+
+
+    function display($layout_def)
+    {
         $obj = $this->getSubClass($layout_def);
 
         $context = $this->layout_manager->getAttribute('context');//_ppd($context);
@@ -91,51 +91,51 @@ 
         {
                 return 'display not found:'.$func_name;
         }
- }
+    }
 
- function _get_column_select_special($layout_def)
- {
- 		$alias = '';
-		 if ( ! empty($layout_def['table_alias']))
-		 {
-			$alias = $layout_def['table_alias'];
-		 }
+    function _get_column_select_special($layout_def)
+    {
+            $alias = '';
+            if ( ! empty($layout_def['table_alias']))
+            {
+            $alias = $layout_def['table_alias'];
+            }
 
     if ($layout_def['name'] == 'weighted_sum' )
     {
         return sprintf("SUM(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability","IFNULL", array(0)),
             $this->reporter->db->convert("$alias.amount_usdollar","IFNULL", array(0)));
-	}
+    }
     if ($layout_def['name'] == 'weighted_amount' )
     {
         return sprintf("AVG(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability","IFNULL", array(0)),
             $this->reporter->db->convert("$alias.amount_usdollar","IFNULL", array(0)));
-	}
- }
-
- function _get_column_select($layout_def)
- {
- 	global $reportAlias;
- 	if (!isset($reportAlias)) {
- 		$reportAlias = array();
- 	}
-
-	if ( ! empty($layout_def['table_alias'])) {
-		$alias = $layout_def['table_alias'].".".$layout_def['name'];
-	} else if (! empty($layout_def['name'])) {
-		$alias = $layout_def['name'];
-	} else {
-		$alias = "*";
-	}
-
-	if ( ! empty($layout_def['group_function']) )
-	{
-    	if ($layout_def['name'] == 'weighted_sum' || $layout_def['name'] == 'weighted_amount')
-    	{
-    			$alias = $this->_get_column_select_special($layout_def);
-    			$reportAlias[$alias] = $layout_def;
-				return $alias;
-    	}
+    }
+    }
+
+    function _get_column_select($layout_def)
+    {
+        global $reportAlias;
+        if (!isset($reportAlias)) {
+            $reportAlias = array();
+        }
+
+    if ( ! empty($layout_def['table_alias'])) {
+        $alias = $layout_def['table_alias'].".".$layout_def['name'];
+    } else if (! empty($layout_def['name'])) {
+        $alias = $layout_def['name'];
+    } else {
+        $alias = "*";
+    }
+
+    if ( ! empty($layout_def['group_function']) )
+    {
+        if ($layout_def['name'] == 'weighted_sum' || $layout_def['name'] == 'weighted_amount')
+        {
+                $alias = $this->_get_column_select_special($layout_def);
+                $reportAlias[$alias] = $layout_def;
+                return $alias;
+        }
 
         // Use IFNULL only if it's not AVG aggregate
         // because it adds NULL rows to the count when it should not, thus getting wrong result
@@ -164,66 +164,66 @@ 
             }
 
         }
-	}
+    }
 
-	$reportAlias[$alias] = $layout_def;
-	return $alias;
- }
+    $reportAlias[$alias] = $layout_def;
+    return $alias;
+    }
 
- function querySelect(&$layout_def)
- {
+    function querySelect(&$layout_def)
+    {
     return $this->_get_column_select($layout_def)." ".$this->_get_column_alias($layout_def)."\n";
- }
+    }
 
- function queryGroupBy($layout_def)
- {
-	return $this->_get_column_select($layout_def)." \n";
- }
+    function queryGroupBy($layout_def)
+    {
+    return $this->_get_column_select($layout_def)." \n";
+    }
 
 
- function queryOrderBy($layout_def)
- {
-     $field_def = array();
-	if(!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']];
+    function queryOrderBy($layout_def)
+    {
+        $field_def = array();
+    if(!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']];
 
     if (!empty($layout_def['group_function']))
     {
         $order_by = $this->_get_column_alias($layout_def);
     }
     elseif (!empty($field_def['sort_on']))
-	{
-			$order_by = $layout_def['table_alias'].".".$field_def['sort_on'];
+    {
+            $order_by = $layout_def['table_alias'].".".$field_def['sort_on'];
             if(!empty($field_def['sort_on2']))
                 $order_by .= ', ' . $layout_def['table_alias'].".".$field_def['sort_on2'];
     }
-	else {
-		$order_by = $this->_get_column_alias($layout_def)." \n";
-	}
+    else {
+        $order_by = $this->_get_column_alias($layout_def)." \n";
+    }
 
-     //use sugar db function convert on order by string to convert to varchar.  This is mainly for db's
-     //that do not allow sorting on clob/text fields
+        //use sugar db function convert on order by string to convert to varchar.  This is mainly for db's
+        //that do not allow sorting on clob/text fields
     if ($this->reporter->db->isTextType($this->reporter->db->getFieldType($field_def))) {
         $order_by = $this->reporter->db->convert($order_by,'text2char', array(10000)); // array(10000) is for db2 only
     }
 
-			if ( empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a')
-			{
-				return $order_by." ASC";
-			} else {
-				return $order_by." DESC";
-			}
- }
+            if ( empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a')
+            {
+                return $order_by." ASC";
+            } else {
+                return $order_by." DESC";
+            }
+    }
 
 
- function queryFilter($layout_def)
- {
-	$method_name = "queryFilter".$layout_def['qualifier_name'];
-	return $this->$method_name($layout_def);
- }
+    function queryFilter($layout_def)
+    {
+    $method_name = "queryFilter".$layout_def['qualifier_name'];
+    return $this->$method_name($layout_def);
+    }
 
-	function displayHeaderCell($layout_def)
-	{
-				global $start_link_wrapper,$end_link_wrapper;
+    function displayHeaderCell($layout_def)
+    {
+                global $start_link_wrapper,$end_link_wrapper;
 
 
                 // don't show sort links if name isn't defined
@@ -237,22 +237,22 @@ 
 
                 $sort_by ='';
                 if ( ! empty($layout_def['table_key']) && ! empty($layout_def['name']) ) {
-                	if (! empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') {
+                    if (! empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') {
                         $sort_by = $layout_def['table_key'].":".'count';
-                	} else {
-                    	$sort_by = $layout_def['table_key'].":".$layout_def['name'];
+                    } else {
+                        $sort_by = $layout_def['table_key'].":".$layout_def['name'];
                         if ( ! empty($layout_def['column_function'])) {
-                        	$sort_by .= ':'.$layout_def['column_function'];
-                		} else if ( ! empty($layout_def['group_function']) ) {
-                        	$sort_by .= ':'.$layout_def['group_function'];
-                		}
-                	}
+                            $sort_by .= ':'.$layout_def['column_function'];
+                        } else if ( ! empty($layout_def['group_function']) ) {
+                            $sort_by .= ':'.$layout_def['group_function'];
+                        }
+                    }
                 } else {
-                	return $this->displayHeaderCellPlain($layout_def);
+                    return $this->displayHeaderCellPlain($layout_def);
                 }
 
                 $start = empty($start_link_wrapper) ? '': $start_link_wrapper;
-				$end = empty($end_link_wrapper) ? '': $end_link_wrapper;
+                $end = empty($end_link_wrapper) ? '': $end_link_wrapper;
 
                 // unable to retrieve the vardef here, exclude columns of type clob/text from being sortable
 
@@ -262,40 +262,40 @@ 
                     $objListView = new ListView();
                     $header_cell .= $objListView->getArrowUpDownStart(isset($layout_def['sort']) ? $layout_def['sort'] : '');
                     $header_cell .= $objListView->getArrowUpDownEnd(isset($layout_def['sort']) ? $layout_def['sort'] : '');
-		            $header_cell .= "</a>";
-					return $header_cell;
-				}
+                    $header_cell .= "</a>";
+                    return $header_cell;
+                }
 
-		        return $this->displayHeaderCellPlain($layout_def);
+                return $this->displayHeaderCellPlain($layout_def);
     }
 
-	function query($layout_def)
- 	{
-       		 $obj = $this->getSubClass($layout_def);
+    function query($layout_def)
+        {
+                $obj = $this->getSubClass($layout_def);
 
-        	$context = $this->layout_manager->getAttribute('context');
-       	 	$func_name = 'query'.$context;
+            $context = $this->layout_manager->getAttribute('context');
+                $func_name = 'query'.$context;
 
-        	if ( ! empty($context) && method_exists($obj,$func_name))
-       		 {
-               		 return  $obj->$func_name($layout_def);
-        	} else
-        	{
-                	return '';
-		}
- 	}
+            if ( ! empty($context) && method_exists($obj,$func_name))
+                {
+                        return  $obj->$func_name($layout_def);
+            } else
+            {
+                    return '';
+        }
+        }
 
- function _get_column_alias($layout_def)
- {
+    function _get_column_alias($layout_def)
+    {
         $alias_arr = array();
 
-	if (!empty($layout_def['table_key']) && $layout_def['table_key'] == 'self' && !empty($layout_def['name']) && $layout_def['name'] == 'id')
-	{
-		return 'primaryid';
-	}
+    if (!empty($layout_def['table_key']) && $layout_def['table_key'] == 'self' && !empty($layout_def['name']) && $layout_def['name'] == 'id')
+    {
+        return 'primaryid';
+    }
 
-     // Bug: 44605
-     // this comment is being added to trigger the upgrade package
+        // Bug: 44605
+        // this comment is being added to trigger the upgrade package
         if ( ! empty($layout_def['group_function']) && $layout_def['group_function']=='count')
         {
                 return $layout_def['table_alias'] . '__count';
@@ -322,49 +322,49 @@ 
                 array_push($alias_arr,$layout_def['name']);
         }
 
-		global $used_aliases, $alias_map;
+        global $used_aliases, $alias_map;
 
         $alias = strtolower(implode("_",$alias_arr));
 
         $short_alias = $this->getTruncatedColumnAlias($alias);
 
-		if ( empty($used_aliases[$short_alias]))
-		{
-			$alias_map[$alias] = $short_alias;
-		    $used_aliases[$short_alias] = 1;
-          	return $short_alias;
-		} else if ( ! empty($alias_map[$alias]) )
-		{
-			return $alias_map[$alias];
-		} else {
-			$alias_map[$alias] = $short_alias.'_'.$used_aliases[$short_alias];
-		  $used_aliases[$short_alias]++;
-			return $alias_map[$alias];
-		}
- }
-
- function queryFilterEmpty($layout_def)
- {
-     $column = $this->_get_column_select($layout_def);
-     return "($column IS NULL OR $column = ".$this->reporter->db->emptyValue($layout_def['type']).")";
- }
-
- function queryFilterIs($layout_def)
- {
- 	return '( '.$this->_get_column_select($layout_def)."='".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n";
- }
-
- function queryFilteris_not($layout_def)
- {
- 	return '( '.$this->_get_column_select($layout_def)."<>'".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n";
- }
-
- function queryFilterNot_Empty($layout_def)
- {
-     /** @var $db DBManager */
-     $db = $this->reporter->db;
-     $column = $this->_get_column_select($layout_def);
-     return "(coalesce(" . $db->convert($column, "length") . ",0) > 0)\n";
- }
+        if ( empty($used_aliases[$short_alias]))
+        {
+            $alias_map[$alias] = $short_alias;
+            $used_aliases[$short_alias] = 1;
+                return $short_alias;
+        } else if ( ! empty($alias_map[$alias]) )
+        {
+            return $alias_map[$alias];
+        } else {
+            $alias_map[$alias] = $short_alias.'_'.$used_aliases[$short_alias];
+            $used_aliases[$short_alias]++;
+            return $alias_map[$alias];
+        }
+    }
+
+    function queryFilterEmpty($layout_def)
+    {
+        $column = $this->_get_column_select($layout_def);
+        return "($column IS NULL OR $column = ".$this->reporter->db->emptyValue($layout_def['type']).")";
+    }
+
+    function queryFilterIs($layout_def)
+    {
+        return '( '.$this->_get_column_select($layout_def)."='".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n";
+    }
+
+    function queryFilteris_not($layout_def)
+    {
+        return '( '.$this->_get_column_select($layout_def)."<>'".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n";
+    }
+
+    function queryFilterNot_Empty($layout_def)
+    {
+        /** @var $db DBManager */
+        $db = $this->reporter->db;
+        $column = $this->_get_column_select($layout_def);
+        return "(coalesce(" . $db->convert($column, "length") . ",0) > 0)\n";
+    }
 
 }

include/generic/SugarWidgets/SugarWidgetSubPanelTopMessage.php

Indentation +3 added lines, -3 removed lines

@@ -46,8 +46,8 @@
 
 class SugarWidgetSubPanelTopMessage extends SugarWidgetSubPanelTopButton
 {
-	function display($defines)
-	{
+    function display($defines)
+    {
         return $defines['message'];
-	}
+    }
 }
\ No newline at end of file

include/generic/SugarWidgets/SugarWidgetFieldenum.php

Indentation +104 added lines, -104 removed lines

@@ -58,39 +58,39 @@ 
     }
 
     public function queryFilteris($layout_def) {
-		$input_name0 = $layout_def['input_name0'];
-		if (is_array($layout_def['input_name0'])) {
-			$input_name0 = $layout_def['input_name0'][0];
-		}
-		return $this->_get_column_select($layout_def)." = ".$this->reporter->db->quoted($input_name0)."\n";
-	}
-
-	public function queryFilteris_not($layout_def) {
-		$input_name0 = $layout_def['input_name0'];
-		if (is_array($layout_def['input_name0'])) {
-			$input_name0 = $layout_def['input_name0'][0];
-		}
-		return $this->_get_column_select($layout_def)." <> ".$this->reporter->db->quoted($input_name0)."\n";
-	}
-
-	public function queryFilterone_of($layout_def) {
-		$arr = array ();
-		foreach ($layout_def['input_name0'] as $value) {
-			$arr[] = $this->reporter->db->quoted($value);
-		}
-		$str = implode(",", $arr);
-		return $this->_get_column_select($layout_def)." IN (".$str.")\n";
-	}
-
-	public function queryFilternot_one_of($layout_def) {
-		$arr = array ();
-		foreach ($layout_def['input_name0'] as $value) {
-			$arr[] = $this->reporter->db->quoted($value);
-		}
-	    $reporter = $this->layout_manager->getAttribute("reporter");
-		$str = implode(",", $arr);
-		return $this->_get_column_select($layout_def)." NOT IN (".$str.")\n";
-	}
+        $input_name0 = $layout_def['input_name0'];
+        if (is_array($layout_def['input_name0'])) {
+            $input_name0 = $layout_def['input_name0'][0];
+        }
+        return $this->_get_column_select($layout_def)." = ".$this->reporter->db->quoted($input_name0)."\n";
+    }
+
+    public function queryFilteris_not($layout_def) {
+        $input_name0 = $layout_def['input_name0'];
+        if (is_array($layout_def['input_name0'])) {
+            $input_name0 = $layout_def['input_name0'][0];
+        }
+        return $this->_get_column_select($layout_def)." <> ".$this->reporter->db->quoted($input_name0)."\n";
+    }
+
+    public function queryFilterone_of($layout_def) {
+        $arr = array ();
+        foreach ($layout_def['input_name0'] as $value) {
+            $arr[] = $this->reporter->db->quoted($value);
+        }
+        $str = implode(",", $arr);
+        return $this->_get_column_select($layout_def)." IN (".$str.")\n";
+    }
+
+    public function queryFilternot_one_of($layout_def) {
+        $arr = array ();
+        foreach ($layout_def['input_name0'] as $value) {
+            $arr[] = $this->reporter->db->quoted($value);
+        }
+        $reporter = $this->layout_manager->getAttribute("reporter");
+        $str = implode(",", $arr);
+        return $this->_get_column_select($layout_def)." NOT IN (".$str.")\n";
+    }
 
     function & displayList($layout_def) {
         if(!empty($layout_def['column_key'])){
@@ -116,84 +116,84 @@ 
                 $field_type = $field_def['type'];
                 $div_id = $field_def['module'] ."&$record&$field_name";
                 $str = "<div id='$div_id'>" . $cell . "&nbsp;"
-                     . SugarThemeRegistry::current()->getImage(
+                        . SugarThemeRegistry::current()->getImage(
                         "edit_inline",
                         "border='0' alt='Edit Layout' align='bottom' onClick='SUGAR.reportsInlineEdit.inlineEdit(" .
                         "\"$div_id\",\"$cell\",\"$module\",\"$record\",\"$field_name\",\"$field_type\");'"
-                       )
-                     . "</div>";
+                        )
+                        . "</div>";
             }
         }
         return $str;
     }
-	function & displayListPlain($layout_def) {
-		if(!empty($layout_def['column_key'])){
-			$field_def = $this->reporter->all_fields[$layout_def['column_key']];
-		}else if(!empty($layout_def['fields'])){
-			$field_def = $layout_def['fields'];
-		}
-
-		if (!empty($layout_def['table_key'] ) &&( empty ($field_def['fields']) || empty ($field_def['fields'][0]) || empty ($field_def['fields'][1]))){
-			$value = $this->_get_list_value($layout_def);
-		}else if(!empty($layout_def['name']) && !empty($layout_def['fields'])){
-			$key = strtoupper($layout_def['name']);
-			$value = $layout_def['fields'][$key];
-		}
-		$cell = '';
-
-			if(isset($field_def['options'])){
-				$cell = translate($field_def['options'], $field_def['module'], $value);
-			}else if(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])){
-	            global $beanFiles;
-	            if(empty($beanFiles)) {
-	                include('include/modules.php');
-	            }
-	            $bean_name = get_singular_bean_name($field_def['module']);
-	            require_once($beanFiles[$bean_name]);
-	            $list = $field_def['function']();
-	            $cell = $list[$value];
-	        }
-		if (is_array($cell)) {
-
-			//#22632
-			$value = unencodeMultienum($value);
-			$cell=array();
-			foreach($value as $val){
-				$returnVal = translate($field_def['options'],$field_def['module'],$val);
-				if(!is_array($returnVal)){
-					array_push( $cell, translate($field_def['options'],$field_def['module'],$val));
-				}
-			}
-			$cell = implode(", ",$cell);
-		}
-		return $cell;
-	}
-
-	public function queryOrderBy($layout_def) {
-		$field_def = $this->reporter->all_fields[$layout_def['column_key']];
-		if (!empty ($field_def['sort_on'])) {
-			$order_by = $layout_def['table_alias'].".".$field_def['sort_on'];
-		} else {
-			$order_by = $this->_get_column_select($layout_def);
-		}
-		$list = array();
+    function & displayListPlain($layout_def) {
+        if(!empty($layout_def['column_key'])){
+            $field_def = $this->reporter->all_fields[$layout_def['column_key']];
+        }else if(!empty($layout_def['fields'])){
+            $field_def = $layout_def['fields'];
+        }
+
+        if (!empty($layout_def['table_key'] ) &&( empty ($field_def['fields']) || empty ($field_def['fields'][0]) || empty ($field_def['fields'][1]))){
+            $value = $this->_get_list_value($layout_def);
+        }else if(!empty($layout_def['name']) && !empty($layout_def['fields'])){
+            $key = strtoupper($layout_def['name']);
+            $value = $layout_def['fields'][$key];
+        }
+        $cell = '';
+
+            if(isset($field_def['options'])){
+                $cell = translate($field_def['options'], $field_def['module'], $value);
+            }else if(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])){
+                global $beanFiles;
+                if(empty($beanFiles)) {
+                    include('include/modules.php');
+                }
+                $bean_name = get_singular_bean_name($field_def['module']);
+                require_once($beanFiles[$bean_name]);
+                $list = $field_def['function']();
+                $cell = $list[$value];
+            }
+        if (is_array($cell)) {
+
+            //#22632
+            $value = unencodeMultienum($value);
+            $cell=array();
+            foreach($value as $val){
+                $returnVal = translate($field_def['options'],$field_def['module'],$val);
+                if(!is_array($returnVal)){
+                    array_push( $cell, translate($field_def['options'],$field_def['module'],$val));
+                }
+            }
+            $cell = implode(", ",$cell);
+        }
+        return $cell;
+    }
+
+    public function queryOrderBy($layout_def) {
+        $field_def = $this->reporter->all_fields[$layout_def['column_key']];
+        if (!empty ($field_def['sort_on'])) {
+            $order_by = $layout_def['table_alias'].".".$field_def['sort_on'];
+        } else {
+            $order_by = $this->_get_column_select($layout_def);
+        }
+        $list = array();
         if(isset($field_def['options'])) {
-		    $list = translate($field_def['options'], $field_def['module']);
+            $list = translate($field_def['options'], $field_def['module']);
         } elseif(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])) {
-	        global $beanFiles;
-		    if(empty($beanFiles)) {
-		        include('include/modules.php');
-		    }
-		    $bean_name = get_singular_bean_name($field_def['module']);
-		    require_once($beanFiles[$bean_name]);
+            global $beanFiles;
+            if(empty($beanFiles)) {
+                include('include/modules.php');
+            }
+            $bean_name = get_singular_bean_name($field_def['module']);
+            require_once($beanFiles[$bean_name]);
             $list = $field_def['function']();
         }
-		if (empty ($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') {
-			$order_dir = "ASC";
-		} else {
-			$order_dir = "DESC";
-		}
-		return $this->reporter->db->orderByEnum($order_by, $list, $order_dir);
+        if (empty ($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') {
+            $order_dir = "ASC";
+        } else {
+            $order_dir = "DESC";
+        }
+        return $this->reporter->db->orderByEnum($order_by, $list, $order_dir);
     }
 
     public function displayInput($layout_def) {
@@ -204,13 +204,13 @@ 
                 $ops = $layout_def['options'];
             }
             elseif (isset($layout_def['options']) && isset($app_list_strings[$layout_def['options']])){
-            	$ops = $app_list_strings[$layout_def['options']];
+                $ops = $app_list_strings[$layout_def['options']];
                 if(array_key_exists('', $app_list_strings[$layout_def['options']])) {
-             	   unset($ops['']);
-	            }
+                    unset($ops['']);
+                }
             }
             else{
-            	$ops = array();
+                $ops = array();
             }
         }
         else {

include/generic/SugarWidgets/SugarWidgetSubPanelTopSelectUsersButton.php

Indentation +124 added lines, -124 removed lines

@@ -45,137 +45,137 @@
 
 class SugarWidgetSubPanelTopSelectUsersButton extends SugarWidgetSubPanelTopSelectButton
 {
-	//button_properties is a collection of properties associated with the widget_class definition. layoutmanager
-	function SugarWidgetSubPanelTopSelectUsersButton($button_properties=array())
-	{
-		$this->button_properties=$button_properties;
-	}
+    //button_properties is a collection of properties associated with the widget_class definition. layoutmanager
+    function SugarWidgetSubPanelTopSelectUsersButton($button_properties=array())
+    {
+        $this->button_properties=$button_properties;
+    }
 
     function getDisplayName()
     {
         return $GLOBALS['app_strings']['LBL_SELECT_USER_BUTTON_LABEL'];
     }
-	//widget_data is the collection of attributes associated with the button in the layout_defs file.
-	function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
-	{
-		global $app_strings;
-		$initial_filter = '';
-
-		$this->title = $app_strings['LBL_SELECT_USER_BUTTON_TITLE'];
-		//$this->accesskey = $app_strings['LBL_SELECT_USER_BUTTON_KEY'];
-		$this->value = $this->getDisplayName();
-
-		$this->module_name = 'Users';
-
-		if (is_array($this->button_properties)) {
-			if( isset($this->button_properties['title'])) {
-				$this->title = $app_strings[$this->button_properties['title']];
-			}
-			if( isset($this->button_properties['accesskey'])) {
-				//$this->accesskey = $app_strings[$this->button_properties['accesskey']];
-			}
-			if( isset($this->button_properties['form_value'])) {
-				$this->value = $app_strings[$this->button_properties['form_value']];
-			}
-			if( isset($this->button_properties['module'])) {
-				$this->module_name = $this->button_properties['module'];
-			}
-		}
-
-		$focus = $widget_data['focus'];
-		if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){
-			$button = ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
-			. ' title="' . $this->title . '"'
-			. ' value="' . $this->value . "\"\n"
-			.' disabled />';
-			return $button;
-		}
-
-		//refresh the whole page after end of action?
-		$refresh_page = 0;
-		if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){
-			$refresh_page = 1;
-		}
-
-		$subpanel_definition = $widget_data['subpanel_definition'];
-
-		$button_definition = $subpanel_definition->get_buttons();
-		$subpanel_name = $subpanel_definition->get_module_name();
-		if (empty($this->module_name)) {
-			$this->module_name = $subpanel_name;
-		}
-
-		if ($subpanel_name == 'Project'){
-			$link_field_name = 'project_users_1';
-		}
-		else{
-			$link_field_name = $subpanel_definition->get_data_source_name(true);
-		}
-
-		$popup_mode='Single';
-		if(isset($widget_data['mode'])){
-			$popup_mode=$widget_data['mode'];
-		}
-		if(isset($widget_data['initial_filter_fields'])){
-			if (is_array($widget_data['initial_filter_fields'])) {
-				foreach ($widget_data['initial_filter_fields'] as $value=>$alias) {
-					if (isset($focus->$value) and !empty($focus->$value)) {
-						$initial_filter.="&".$alias . '='.urlencode($focus->$value);
-					}
-				}
-			}
-		}
-
-		if (!empty($widget_data['filter_out_is_admin'])) {
+    //widget_data is the collection of attributes associated with the button in the layout_defs file.
+    function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
+    {
+        global $app_strings;
+        $initial_filter = '';
+
+        $this->title = $app_strings['LBL_SELECT_USER_BUTTON_TITLE'];
+        //$this->accesskey = $app_strings['LBL_SELECT_USER_BUTTON_KEY'];
+        $this->value = $this->getDisplayName();
+
+        $this->module_name = 'Users';
+
+        if (is_array($this->button_properties)) {
+            if( isset($this->button_properties['title'])) {
+                $this->title = $app_strings[$this->button_properties['title']];
+            }
+            if( isset($this->button_properties['accesskey'])) {
+                //$this->accesskey = $app_strings[$this->button_properties['accesskey']];
+            }
+            if( isset($this->button_properties['form_value'])) {
+                $this->value = $app_strings[$this->button_properties['form_value']];
+            }
+            if( isset($this->button_properties['module'])) {
+                $this->module_name = $this->button_properties['module'];
+            }
+        }
+
+        $focus = $widget_data['focus'];
+        if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){
+            $button = ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
+            . ' title="' . $this->title . '"'
+            . ' value="' . $this->value . "\"\n"
+            .' disabled />';
+            return $button;
+        }
+
+        //refresh the whole page after end of action?
+        $refresh_page = 0;
+        if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){
+            $refresh_page = 1;
+        }
+
+        $subpanel_definition = $widget_data['subpanel_definition'];
+
+        $button_definition = $subpanel_definition->get_buttons();
+        $subpanel_name = $subpanel_definition->get_module_name();
+        if (empty($this->module_name)) {
+            $this->module_name = $subpanel_name;
+        }
+
+        if ($subpanel_name == 'Project'){
+            $link_field_name = 'project_users_1';
+        }
+        else{
+            $link_field_name = $subpanel_definition->get_data_source_name(true);
+        }
+
+        $popup_mode='Single';
+        if(isset($widget_data['mode'])){
+            $popup_mode=$widget_data['mode'];
+        }
+        if(isset($widget_data['initial_filter_fields'])){
+            if (is_array($widget_data['initial_filter_fields'])) {
+                foreach ($widget_data['initial_filter_fields'] as $value=>$alias) {
+                    if (isset($focus->$value) and !empty($focus->$value)) {
+                        $initial_filter.="&".$alias . '='.urlencode($focus->$value);
+                    }
+                }
+            }
+        }
+
+        if (!empty($widget_data['filter_out_is_admin'])) {
             $initial_filter.="&is_admin_advanced=0";
         }
 
-		$create="true";
-		if(isset($widget_data['create'])){
-			$create=$widget_data['create'];
-		}
-		$return_module = $_REQUEST['module'];
-		$return_action = 'SubPanelViewer';
-		$return_id = $_REQUEST['record'];
-
-		//field_to_name_array
-		$fton_array= array('id' => 'subpanel_id');
-		if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){
-			$fton_array=array_merge($fton_array,$widget_data['field_to_name_array']);
-		}
-
-		$return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1";
-
-		$popup_request_data = array(
-			'call_back_function' => 'set_return_and_save_background',
-			'form_name' => 'DetailView',
-			'field_to_name_array' => $fton_array,
-			'passthru_data' => array(
-				'child_field' => $this->module_name,
-				'return_url' => urlencode($return_url),
-				'link_field_name' => $link_field_name,
-				'module_name' => $this->module_name,
-				'refresh_page' => 1,
-			),
-		);
-
-		if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data'])) {
-			$popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']);
-		}
-
-		if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) {
-
-			if ($this->button_properties['add_to_passthru_data']['return_type']=='report') {
-				$initial_filter = "&module_name=". urlencode($widget_data['module']);
-			}
-		}
-		$json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data);
-
-		return '<form action="index.php">' . "\n"
-			. ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
-				. ' title="' . $this->title . '"'
-			. ' value="' . $this->value . "\"\n"
-			. " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' /></form>\n";
-	}
+        $create="true";
+        if(isset($widget_data['create'])){
+            $create=$widget_data['create'];
+        }
+        $return_module = $_REQUEST['module'];
+        $return_action = 'SubPanelViewer';
+        $return_id = $_REQUEST['record'];
+
+        //field_to_name_array
+        $fton_array= array('id' => 'subpanel_id');
+        if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){
+            $fton_array=array_merge($fton_array,$widget_data['field_to_name_array']);
+        }
+
+        $return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1";
+
+        $popup_request_data = array(
+            'call_back_function' => 'set_return_and_save_background',
+            'form_name' => 'DetailView',
+            'field_to_name_array' => $fton_array,
+            'passthru_data' => array(
+                'child_field' => $this->module_name,
+                'return_url' => urlencode($return_url),
+                'link_field_name' => $link_field_name,
+                'module_name' => $this->module_name,
+                'refresh_page' => 1,
+            ),
+        );
+
+        if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data'])) {
+            $popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']);
+        }
+
+        if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) {
+
+            if ($this->button_properties['add_to_passthru_data']['return_type']=='report') {
+                $initial_filter = "&module_name=". urlencode($widget_data['module']);
+            }
+        }
+        $json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data);
+
+        return '<form action="index.php">' . "\n"
+            . ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
+                . ' title="' . $this->title . '"'
+            . ' value="' . $this->value . "\"\n"
+            . " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' /></form>\n";
+    }
 }
 ?>

include/generic/SugarWidgets/SugarWidgetSubPanelEditRoleButton.php

Indentation +21 added lines, -21 removed lines

@@ -45,33 +45,33 @@
 
 class SugarWidgetSubPanelEditRoleButton extends SugarWidgetField
 {
-	function displayHeaderCell(&$layout_def)
-	{
-		return ' ';
-	}
+    function displayHeaderCell(&$layout_def)
+    {
+        return ' ';
+    }
 
-	function displayList(&$layout_def)
-	{
-		global $app_strings;
+    function displayList(&$layout_def)
+    {
+        global $app_strings;
         global $subpanel_item_count;
         $unique_id = $layout_def['subpanel_id']."_edit_".$subpanel_item_count; //bug 51512
 	
-		$href = 'index.php?module=' . $layout_def['module']
-			. '&action=' . 'ContactOpportunityRelationshipEdit'
-			. '&record=' . $layout_def['fields']['OPPORTUNITY_ROLE_ID']
-			. '&return_module=' . $_REQUEST['module']
-			. '&return_action=' . 'DetailView'
-			. '&return_id=' . $_REQUEST['record'];
+        $href = 'index.php?module=' . $layout_def['module']
+            . '&action=' . 'ContactOpportunityRelationshipEdit'
+            . '&record=' . $layout_def['fields']['OPPORTUNITY_ROLE_ID']
+            . '&return_module=' . $_REQUEST['module']
+            . '&return_action=' . 'DetailView'
+            . '&return_id=' . $_REQUEST['record'];
 			
-	//based on listview since that lets you select records
-	if($layout_def['ListView']){
-		return '<a href="' . $href . '"'
+    //based on listview since that lets you select records
+    if($layout_def['ListView']){
+        return '<a href="' . $href . '"'
             . "id=\"$unique_id\""
-			. 'class="listViewTdToolsS1">' . $app_strings['LNK_EDIT'] .'</a>&nbsp;';
-	}else{
-		return '';
-	}
-	}
+            . 'class="listViewTdToolsS1">' . $app_strings['LNK_EDIT'] .'</a>&nbsp;';
+    }else{
+        return '';
+    }
+    }
 }
 
 ?>
\ No newline at end of file