Completed
Push — master ( a75ecc...97ae17 )
by Adam
71:21 queued 52:34
created
include/generic/SugarWidgets/SugarWidgetSubPanelEditRoleButton.php 1 patch
Indentation   +21 added lines, -21 removed lines patch added patch discarded remove patch
@@ -45,33 +45,33 @@
 block discarded – undo
45 45
 
46 46
 class SugarWidgetSubPanelEditRoleButton extends SugarWidgetField
47 47
 {
48
-	function displayHeaderCell(&$layout_def)
49
-	{
50
-		return ' ';
51
-	}
48
+    function displayHeaderCell(&$layout_def)
49
+    {
50
+        return ' ';
51
+    }
52 52
 
53
-	function displayList(&$layout_def)
54
-	{
55
-		global $app_strings;
53
+    function displayList(&$layout_def)
54
+    {
55
+        global $app_strings;
56 56
         global $subpanel_item_count;
57 57
         $unique_id = $layout_def['subpanel_id']."_edit_".$subpanel_item_count; //bug 51512
58 58
 	
59
-		$href = 'index.php?module=' . $layout_def['module']
60
-			. '&action=' . 'ContactOpportunityRelationshipEdit'
61
-			. '&record=' . $layout_def['fields']['OPPORTUNITY_ROLE_ID']
62
-			. '&return_module=' . $_REQUEST['module']
63
-			. '&return_action=' . 'DetailView'
64
-			. '&return_id=' . $_REQUEST['record'];
59
+        $href = 'index.php?module=' . $layout_def['module']
60
+            . '&action=' . 'ContactOpportunityRelationshipEdit'
61
+            . '&record=' . $layout_def['fields']['OPPORTUNITY_ROLE_ID']
62
+            . '&return_module=' . $_REQUEST['module']
63
+            . '&return_action=' . 'DetailView'
64
+            . '&return_id=' . $_REQUEST['record'];
65 65
 			
66
-	//based on listview since that lets you select records
67
-	if($layout_def['ListView']){
68
-		return '<a href="' . $href . '"'
66
+    //based on listview since that lets you select records
67
+    if($layout_def['ListView']){
68
+        return '<a href="' . $href . '"'
69 69
             . "id=\"$unique_id\""
70
-			. 'class="listViewTdToolsS1">' . $app_strings['LNK_EDIT'] .'</a>&nbsp;';
71
-	}else{
72
-		return '';
73
-	}
74
-	}
70
+            . 'class="listViewTdToolsS1">' . $app_strings['LNK_EDIT'] .'</a>&nbsp;';
71
+    }else{
72
+        return '';
73
+    }
74
+    }
75 75
 }
76 76
 
77 77
 ?>
78 78
\ No newline at end of file
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetSubPanelTopCreateNoteButton.php 1 patch
Indentation   +115 added lines, -115 removed lines patch added patch discarded remove patch
@@ -45,121 +45,121 @@
 block discarded – undo
45 45
 
46 46
 class SugarWidgetSubPanelTopCreateNoteButton extends SugarWidgetSubPanelTopButtonQuickCreate
47 47
 {
48
-	function &_get_form($defines, $additionalFormFields = null, $asUrl = false)
49
-	{
50
-		global $app_strings;
51
-		global $currentModule;
52
-
53
-		$this->module="Notes";
54
-		$this->subpanelDiv = "history";
55
-
56
-		// Create the additional form fields with real values if they were not passed in
57
-		if(empty($additionalFormFields) && $this->additional_form_fields)
58
-		{
59
-			foreach($this->additional_form_fields as $key=>$value)
60
-			{
61
-				if(!empty($defines['focus']->$value))
62
-				{
63
-					$additionalFormFields[$key] = $defines['focus']->$value;
64
-				}
65
-				else
66
-				{
67
-					$additionalFormFields[$key] = '';
68
-				}
69
-			}
70
-		}
71
-
72
-		if(!empty($this->module))
73
-		{
74
-			$defines['child_module_name'] = $this->module;
75
-		}
76
-		else
77
-		{
78
-			$defines['child_module_name'] = $defines['module'];
79
-		}
80
-
81
-		if(!empty($this->subpanelDiv))
82
-		{
83
-			$defines['subpanelDiv'] = $this->subpanelDiv;
84
-		}
85
-
86
-		$defines['parent_bean_name'] = get_class( $defines['focus']);
87
-
88
-		$form = 'form' . $defines['child_module_name'];
89
-		$button = '<form onsubmit="return SUGAR.subpanelUtils.sendAndRetrieve(this.id, \'subpanel_' . strtolower($defines['subpanelDiv']) . '\', \'' . addslashes($app_strings['LBL_LOADING']) . '\');" action="index.php" method="post" name="form" id="form' . $form . "\">\n";
90
-
91
-		//module_button is used to override the value of module name
92
-		$button .= "<input type='hidden' name='target_module' value='".$defines['child_module_name']."'>\n";
93
-		$button .= "<input type='hidden' name='".strtolower($defines['parent_bean_name'])."_id' value='".$defines['focus']->id."'>\n";
94
-
95
-		if(isset($defines['focus']->name))
96
-		{
97
-			$button .= "<input type='hidden' name='".strtolower($defines['parent_bean_name'])."_name' value='".$defines['focus']->name."'>";
98
-		}
99
-
100
-		$button .= '<input type="hidden" name="to_pdf" value="true" />';
48
+    function &_get_form($defines, $additionalFormFields = null, $asUrl = false)
49
+    {
50
+        global $app_strings;
51
+        global $currentModule;
52
+
53
+        $this->module="Notes";
54
+        $this->subpanelDiv = "history";
55
+
56
+        // Create the additional form fields with real values if they were not passed in
57
+        if(empty($additionalFormFields) && $this->additional_form_fields)
58
+        {
59
+            foreach($this->additional_form_fields as $key=>$value)
60
+            {
61
+                if(!empty($defines['focus']->$value))
62
+                {
63
+                    $additionalFormFields[$key] = $defines['focus']->$value;
64
+                }
65
+                else
66
+                {
67
+                    $additionalFormFields[$key] = '';
68
+                }
69
+            }
70
+        }
71
+
72
+        if(!empty($this->module))
73
+        {
74
+            $defines['child_module_name'] = $this->module;
75
+        }
76
+        else
77
+        {
78
+            $defines['child_module_name'] = $defines['module'];
79
+        }
80
+
81
+        if(!empty($this->subpanelDiv))
82
+        {
83
+            $defines['subpanelDiv'] = $this->subpanelDiv;
84
+        }
85
+
86
+        $defines['parent_bean_name'] = get_class( $defines['focus']);
87
+
88
+        $form = 'form' . $defines['child_module_name'];
89
+        $button = '<form onsubmit="return SUGAR.subpanelUtils.sendAndRetrieve(this.id, \'subpanel_' . strtolower($defines['subpanelDiv']) . '\', \'' . addslashes($app_strings['LBL_LOADING']) . '\');" action="index.php" method="post" name="form" id="form' . $form . "\">\n";
90
+
91
+        //module_button is used to override the value of module name
92
+        $button .= "<input type='hidden' name='target_module' value='".$defines['child_module_name']."'>\n";
93
+        $button .= "<input type='hidden' name='".strtolower($defines['parent_bean_name'])."_id' value='".$defines['focus']->id."'>\n";
94
+
95
+        if(isset($defines['focus']->name))
96
+        {
97
+            $button .= "<input type='hidden' name='".strtolower($defines['parent_bean_name'])."_name' value='".$defines['focus']->name."'>";
98
+        }
99
+
100
+        $button .= '<input type="hidden" name="to_pdf" value="true" />';
101 101
         $button .= '<input type="hidden" name="tpl" value="QuickCreate.tpl" />';
102
-		$button .= '<input type="hidden" name="return_module" value="' . $currentModule . "\" />\n";
103
-		$button .= '<input type="hidden" name="return_action" value="' . $defines['action'] . "\" />\n";
104
-		$button .= '<input type="hidden" name="return_id" value="' . $defines['focus']->id . "\" />\n";
105
-		$button .= '<input type="hidden" name="record" value="" />';
106
-
107
-		// TODO: move this out and get $additionalFormFields working properly
108
-		if(empty($additionalFormFields['parent_type']))
109
-		{
110
-			if($defines['focus']->object_name=='Contact') {
111
-				$additionalFormFields['parent_type'] = 'Accounts';
112
-			}
113
-			else {
114
-				$additionalFormFields['parent_type'] = $defines['focus']->module_dir;
115
-			}
116
-		}
117
-		if(empty($additionalFormFields['parent_name']))
118
-		{
119
-			if($defines['focus']->object_name=='Contact') {
120
-				$additionalFormFields['parent_name'] = $defines['focus']->account_name;
121
-				$additionalFormFields['account_name'] = $defines['focus']->account_name;
122
-			}
123
-			else {
124
-				$additionalFormFields['parent_name'] = $defines['focus']->name;
125
-			}
126
-		}
127
-		if(empty($additionalFormFields['parent_id']))
128
-		{
129
-			if($defines['focus']->object_name=='Contact') {
130
-				$additionalFormFields['parent_id'] = $defines['focus']->account_id;
131
-				$additionalFormFields['account_id'] = $defines['focus']->account_id;
132
-			}
133
-			else {
134
-				$additionalFormFields['parent_id'] = $defines['focus']->id;
135
-			}
136
-		}
137
-
138
-		$button .= '<input type="hidden" name="action" value="SubpanelCreates" />' . "\n";
139
-		$button .= '<input type="hidden" name="module" value="Home" />' . "\n";
140
-		$button .= '<input type="hidden" name="target_action" value="QuickCreate" />' . "\n";
141
-
142
-		// fill in additional form fields for all but action
143
-		foreach($additionalFormFields as $key => $value)
144
-		{
145
-			if($key != 'action')
146
-			{
147
-				$button .= '<input type="hidden" name="' . $key . '" value="' . $value . '" />' . "\n";
148
-			}
149
-		}
150
-
151
-		return $button;
152
-	}
153
-
154
-
155
-	function display($defines, $additionalFormFields = null, $nonbutton = false)
156
-	{
157
-	    $focus = new Note;
158
-		if ( !$focus->ACLAccess('EditView') ) {
159
-		    return '';
160
-	    }
161
-
162
-		return parent::display($defines, $additionalFormFields);
163
-	}
102
+        $button .= '<input type="hidden" name="return_module" value="' . $currentModule . "\" />\n";
103
+        $button .= '<input type="hidden" name="return_action" value="' . $defines['action'] . "\" />\n";
104
+        $button .= '<input type="hidden" name="return_id" value="' . $defines['focus']->id . "\" />\n";
105
+        $button .= '<input type="hidden" name="record" value="" />';
106
+
107
+        // TODO: move this out and get $additionalFormFields working properly
108
+        if(empty($additionalFormFields['parent_type']))
109
+        {
110
+            if($defines['focus']->object_name=='Contact') {
111
+                $additionalFormFields['parent_type'] = 'Accounts';
112
+            }
113
+            else {
114
+                $additionalFormFields['parent_type'] = $defines['focus']->module_dir;
115
+            }
116
+        }
117
+        if(empty($additionalFormFields['parent_name']))
118
+        {
119
+            if($defines['focus']->object_name=='Contact') {
120
+                $additionalFormFields['parent_name'] = $defines['focus']->account_name;
121
+                $additionalFormFields['account_name'] = $defines['focus']->account_name;
122
+            }
123
+            else {
124
+                $additionalFormFields['parent_name'] = $defines['focus']->name;
125
+            }
126
+        }
127
+        if(empty($additionalFormFields['parent_id']))
128
+        {
129
+            if($defines['focus']->object_name=='Contact') {
130
+                $additionalFormFields['parent_id'] = $defines['focus']->account_id;
131
+                $additionalFormFields['account_id'] = $defines['focus']->account_id;
132
+            }
133
+            else {
134
+                $additionalFormFields['parent_id'] = $defines['focus']->id;
135
+            }
136
+        }
137
+
138
+        $button .= '<input type="hidden" name="action" value="SubpanelCreates" />' . "\n";
139
+        $button .= '<input type="hidden" name="module" value="Home" />' . "\n";
140
+        $button .= '<input type="hidden" name="target_action" value="QuickCreate" />' . "\n";
141
+
142
+        // fill in additional form fields for all but action
143
+        foreach($additionalFormFields as $key => $value)
144
+        {
145
+            if($key != 'action')
146
+            {
147
+                $button .= '<input type="hidden" name="' . $key . '" value="' . $value . '" />' . "\n";
148
+            }
149
+        }
150
+
151
+        return $button;
152
+    }
153
+
154
+
155
+    function display($defines, $additionalFormFields = null, $nonbutton = false)
156
+    {
157
+        $focus = new Note;
158
+        if ( !$focus->ACLAccess('EditView') ) {
159
+            return '';
160
+        }
161
+
162
+        return parent::display($defines, $additionalFormFields);
163
+    }
164 164
 }
165 165
 ?>
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetFieldtext.php 1 patch
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -50,7 +50,7 @@
 block discarded – undo
50 50
     function queryFilterEquals($layout_def)
51 51
     {
52 52
         return $this->reporter->db->convert($this->_get_column_select($layout_def), "text2char").
53
-        	" = ".$this->reporter->db->quoted($layout_def['input_name0']);
53
+            " = ".$this->reporter->db->quoted($layout_def['input_name0']);
54 54
     }
55 55
 
56 56
     function queryFilterNot_Equals_Str($layout_def)
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetSubPanelTopSelectContactsButton.php 1 patch
Indentation   +122 added lines, -122 removed lines patch added patch discarded remove patch
@@ -45,133 +45,133 @@
 block discarded – undo
45 45
 
46 46
 class SugarWidgetSubPanelTopSelectContactsButton extends SugarWidgetSubPanelTopSelectButton
47 47
 {
48
-	//button_properties is a collection of properties associated with the widget_class definition. layoutmanager
49
-	function SugarWidgetSubPanelTopSelectContactsButton($button_properties=array())
50
-	{
51
-		$this->button_properties=$button_properties;
52
-	}
48
+    //button_properties is a collection of properties associated with the widget_class definition. layoutmanager
49
+    function SugarWidgetSubPanelTopSelectContactsButton($button_properties=array())
50
+    {
51
+        $this->button_properties=$button_properties;
52
+    }
53 53
 
54 54
     public function getWidgetId($buttonSuffix = true)
55 55
     {
56 56
         return parent::getWidgetId() . '_select_button';
57 57
     }
58 58
 
59
-	//widget_data is the collection of attributes associated with the button in the layout_defs file.
60
-	function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
61
-	{
62
-		global $app_strings;
63
-		$initial_filter = '';
64
-
65
-		$this->title = $app_strings['LBL_SELECT_CONTACT_BUTTON_TITLE'];
66
-		//$this->accesskey = $app_strings['LBL_SELECT_CONTACT_BUTTON_KEY'];
67
-		$this->value = $app_strings['LBL_SELECT_CONTACT_BUTTON_LABEL'];
68
-
69
-		$this->module_name = 'Contacts';
70
-
71
-		if (is_array($this->button_properties)) {
72
-			if( isset($this->button_properties['title'])) {
73
-				$this->title = $app_strings[$this->button_properties['title']];
74
-			}
75
-			if( isset($this->button_properties['accesskey'])) {
76
-				//$this->accesskey = $app_strings[$this->button_properties['accesskey']];
77
-			}
78
-			if( isset($this->button_properties['form_value'])) {
79
-				$this->value = $app_strings[$this->button_properties['form_value']];
80
-			}
81
-			if( isset($this->button_properties['module'])) {
82
-				$this->module_name = $this->button_properties['module'];
83
-			}
84
-		}
85
-
86
-		$focus = $widget_data['focus'];
87
-		if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){
88
-			$button = ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
89
-			. ' title="' . $this->title . '"'
90
-			. ' value="' . $this->value . "\"\n"
91
-			.' disabled />';
92
-			return $button;
93
-		}
94
-
95
-		//refresh the whole page after end of action?
96
-		$refresh_page = 0;
97
-		if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){
98
-			$refresh_page = 1;
99
-		}
100
-
101
-		$subpanel_definition = $widget_data['subpanel_definition'];
102
-
103
-		$button_definition = $subpanel_definition->get_buttons();
104
-		$subpanel_name = $subpanel_definition->get_module_name();
105
-		if (empty($this->module_name)) {
106
-			$this->module_name = $subpanel_name;
107
-		}
108
-
109
-		if ($subpanel_name == 'Project'){
110
-			$link_field_name = 'project_contacts_1';
111
-		}
112
-		else{
113
-			$link_field_name = $subpanel_definition->get_data_source_name(true);
114
-		}
115
-
116
-		$popup_mode='Single';
117
-		if(isset($widget_data['mode'])){
118
-			$popup_mode=$widget_data['mode'];
119
-		}
120
-		if(isset($widget_data['initial_filter_fields'])){
121
-			if (is_array($widget_data['initial_filter_fields'])) {
122
-				foreach ($widget_data['initial_filter_fields'] as $value=>$alias) {
123
-					if (isset($focus->$value) and !empty($focus->$value)) {
124
-						$initial_filter.="&".$alias . '='.urlencode($focus->$value);
125
-					}
126
-				}
127
-			}
128
-		}
129
-		$create="true";
130
-		if(isset($widget_data['create'])){
131
-			$create=$widget_data['create'];
132
-		}
133
-		$return_module = $_REQUEST['module'];
134
-		$return_action = 'SubPanelViewer';
135
-		$return_id = $_REQUEST['record'];
136
-
137
-		//field_to_name_array
138
-		$fton_array= array('id' => 'subpanel_id');
139
-		if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){
140
-			$fton_array=array_merge($fton_array,$widget_data['field_to_name_array']);
141
-		}
142
-
143
-		$return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1";
144
-
145
-		$popup_request_data = array(
146
-			'call_back_function' => 'set_return_and_save_background',
147
-			'form_name' => 'DetailView',
148
-			'field_to_name_array' => $fton_array,
149
-			'passthru_data' => array(
150
-				'child_field' => $this->module_name,
151
-				'return_url' => urlencode($return_url),
152
-				'link_field_name' => $link_field_name,
153
-				'module_name' => $this->module_name,
154
-				'refresh_page' => 1,
155
-			),
156
-		);
157
-
158
-		if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data'])) {
159
-			$popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']);
160
-		}
161
-
162
-		if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) {
163
-
164
-			if ($this->button_properties['add_to_passthru_data']['return_type']=='report') {
165
-				$initial_filter = "&module_name=". urlencode($widget_data['module']);
166
-			}
167
-		}
168
-		$json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data);
169
-
170
-		return '<form action="index.php">' . "\n"
171
-			. ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
172
-				. ' title="' . $this->title . '"'
173
-			. ' value="' . $this->value . "\"\n"
174
-			. " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' /></form>\n";
175
-	}
59
+    //widget_data is the collection of attributes associated with the button in the layout_defs file.
60
+    function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
61
+    {
62
+        global $app_strings;
63
+        $initial_filter = '';
64
+
65
+        $this->title = $app_strings['LBL_SELECT_CONTACT_BUTTON_TITLE'];
66
+        //$this->accesskey = $app_strings['LBL_SELECT_CONTACT_BUTTON_KEY'];
67
+        $this->value = $app_strings['LBL_SELECT_CONTACT_BUTTON_LABEL'];
68
+
69
+        $this->module_name = 'Contacts';
70
+
71
+        if (is_array($this->button_properties)) {
72
+            if( isset($this->button_properties['title'])) {
73
+                $this->title = $app_strings[$this->button_properties['title']];
74
+            }
75
+            if( isset($this->button_properties['accesskey'])) {
76
+                //$this->accesskey = $app_strings[$this->button_properties['accesskey']];
77
+            }
78
+            if( isset($this->button_properties['form_value'])) {
79
+                $this->value = $app_strings[$this->button_properties['form_value']];
80
+            }
81
+            if( isset($this->button_properties['module'])) {
82
+                $this->module_name = $this->button_properties['module'];
83
+            }
84
+        }
85
+
86
+        $focus = $widget_data['focus'];
87
+        if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){
88
+            $button = ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
89
+            . ' title="' . $this->title . '"'
90
+            . ' value="' . $this->value . "\"\n"
91
+            .' disabled />';
92
+            return $button;
93
+        }
94
+
95
+        //refresh the whole page after end of action?
96
+        $refresh_page = 0;
97
+        if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){
98
+            $refresh_page = 1;
99
+        }
100
+
101
+        $subpanel_definition = $widget_data['subpanel_definition'];
102
+
103
+        $button_definition = $subpanel_definition->get_buttons();
104
+        $subpanel_name = $subpanel_definition->get_module_name();
105
+        if (empty($this->module_name)) {
106
+            $this->module_name = $subpanel_name;
107
+        }
108
+
109
+        if ($subpanel_name == 'Project'){
110
+            $link_field_name = 'project_contacts_1';
111
+        }
112
+        else{
113
+            $link_field_name = $subpanel_definition->get_data_source_name(true);
114
+        }
115
+
116
+        $popup_mode='Single';
117
+        if(isset($widget_data['mode'])){
118
+            $popup_mode=$widget_data['mode'];
119
+        }
120
+        if(isset($widget_data['initial_filter_fields'])){
121
+            if (is_array($widget_data['initial_filter_fields'])) {
122
+                foreach ($widget_data['initial_filter_fields'] as $value=>$alias) {
123
+                    if (isset($focus->$value) and !empty($focus->$value)) {
124
+                        $initial_filter.="&".$alias . '='.urlencode($focus->$value);
125
+                    }
126
+                }
127
+            }
128
+        }
129
+        $create="true";
130
+        if(isset($widget_data['create'])){
131
+            $create=$widget_data['create'];
132
+        }
133
+        $return_module = $_REQUEST['module'];
134
+        $return_action = 'SubPanelViewer';
135
+        $return_id = $_REQUEST['record'];
136
+
137
+        //field_to_name_array
138
+        $fton_array= array('id' => 'subpanel_id');
139
+        if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){
140
+            $fton_array=array_merge($fton_array,$widget_data['field_to_name_array']);
141
+        }
142
+
143
+        $return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1";
144
+
145
+        $popup_request_data = array(
146
+            'call_back_function' => 'set_return_and_save_background',
147
+            'form_name' => 'DetailView',
148
+            'field_to_name_array' => $fton_array,
149
+            'passthru_data' => array(
150
+                'child_field' => $this->module_name,
151
+                'return_url' => urlencode($return_url),
152
+                'link_field_name' => $link_field_name,
153
+                'module_name' => $this->module_name,
154
+                'refresh_page' => 1,
155
+            ),
156
+        );
157
+
158
+        if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data'])) {
159
+            $popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']);
160
+        }
161
+
162
+        if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) {
163
+
164
+            if ($this->button_properties['add_to_passthru_data']['return_type']=='report') {
165
+                $initial_filter = "&module_name=". urlencode($widget_data['module']);
166
+            }
167
+        }
168
+        $json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data);
169
+
170
+        return '<form action="index.php">' . "\n"
171
+            . ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n"
172
+                . ' title="' . $this->title . '"'
173
+            . ' value="' . $this->value . "\"\n"
174
+            . " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' /></form>\n";
175
+    }
176 176
 }
177 177
 ?>
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetSubPanelTopSelectAccountButton.php 1 patch
Indentation   +9 added lines, -9 removed lines patch added patch discarded remove patch
@@ -44,21 +44,21 @@
 block discarded – undo
44 44
 
45 45
 
46 46
 class SugarWidgetSubPanelTopSelectAccountButton extends SugarWidgetSubPanelTopSelectButton {
47
-	function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
48
-	{
49
-		/*
47
+    function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
48
+    {
49
+        /*
50 50
 		* i.dymovsky
51 51
 		* Because when user role can't edit Accounts, it also can't edit Membership Organizations. Select button leads to change MO list
52 52
 		* See bug 25633
53 53
 		* Bug25633 code change start
54 54
 		*/
55
-		if (!ACLController::checkAccess($widget_data["module"], "edit", true)) {
56
-			return ;
57
-		}
58
-		/*
55
+        if (!ACLController::checkAccess($widget_data["module"], "edit", true)) {
56
+            return ;
57
+        }
58
+        /*
59 59
 		* Bug25633 code change end
60 60
 		*/
61 61
 		
62
-		return parent::display($widget_data);
63
-	}
62
+        return parent::display($widget_data);
63
+    }
64 64
 }
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetSubPanelTopSelectButton.php 1 patch
Indentation   +105 added lines, -105 removed lines patch added patch discarded remove patch
@@ -45,11 +45,11 @@  discard block
 block discarded – undo
45 45
 
46 46
 class SugarWidgetSubPanelTopSelectButton extends SugarWidgetSubPanelTopButton
47 47
 {
48
-	//button_properties is a collection of properties associated with the widget_class definition. layoutmanager
49
-	function SugarWidgetSubPanelTopSelectButton($button_properties=array())
50
-	{
51
-		$this->button_properties=$button_properties;
52
-	}
48
+    //button_properties is a collection of properties associated with the widget_class definition. layoutmanager
49
+    function SugarWidgetSubPanelTopSelectButton($button_properties=array())
50
+    {
51
+        $this->button_properties=$button_properties;
52
+    }
53 53
 
54 54
     public function getWidgetId($buttonSuffix = true)
55 55
     {
@@ -60,96 +60,96 @@  discard block
 block discarded – undo
60 60
     {
61 61
         return $GLOBALS['app_strings']['LBL_SELECT_BUTTON_LABEL'];
62 62
     }
63
-	//widget_data is the collection of attributes associated with the button in the layout_defs file.
64
-	function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
65
-	{
66
-		global $app_strings;
67
-		$initial_filter = '';
63
+    //widget_data is the collection of attributes associated with the button in the layout_defs file.
64
+    function display($widget_data, $additionalFormFields = NULL, $nonbutton = false)
65
+    {
66
+        global $app_strings;
67
+        $initial_filter = '';
68 68
 
69
-	    $this->title     = $this->getTitle();
69
+        $this->title     = $this->getTitle();
70 70
         $this->accesskey = $this->getAccesskey();
71 71
         $this->value     = $this->getDisplayName();
72 72
 
73
-		if (is_array($this->button_properties)) {
74
-			if( isset($this->button_properties['title'])) {
75
-				$this->title = $app_strings[$this->button_properties['title']];
76
-			}
77
-			if( isset($this->button_properties['accesskey'])) {
78
-				$this->accesskey = $app_strings[$this->button_properties['accesskey']];
79
-			}
80
-			if( isset($this->button_properties['form_value'])) {
81
-				$this->value = $app_strings[$this->button_properties['form_value']];
82
-			}
83
-			if( isset($this->button_properties['module'])) {
84
-				$this->module_name = $this->button_properties['module'];
85
-			}
86
-		}
87
-
88
-
89
-		$focus = $widget_data['focus'];
90
-		if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){
91
-			$button = ' <input type="button" name="' . $this->getWidgetId() . '" id="' . $this->getWidgetId() . '" class="button"' . "\n"
92
-			. ' title="' . $this->title . '"'
93
-			. ' value="' . $this->value . "\"\n"
94
-			.' disabled />';
95
-			return $button;
96
-		}
97
-
98
-		//refresh the whole page after end of action?
99
-		$refresh_page = 0;
100
-		if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){
101
-			$refresh_page = 1;
102
-		}
103
-
104
-		$subpanel_definition = $widget_data['subpanel_definition'];
105
-		$button_definition = $subpanel_definition->get_buttons();
73
+        if (is_array($this->button_properties)) {
74
+            if( isset($this->button_properties['title'])) {
75
+                $this->title = $app_strings[$this->button_properties['title']];
76
+            }
77
+            if( isset($this->button_properties['accesskey'])) {
78
+                $this->accesskey = $app_strings[$this->button_properties['accesskey']];
79
+            }
80
+            if( isset($this->button_properties['form_value'])) {
81
+                $this->value = $app_strings[$this->button_properties['form_value']];
82
+            }
83
+            if( isset($this->button_properties['module'])) {
84
+                $this->module_name = $this->button_properties['module'];
85
+            }
86
+        }
87
+
88
+
89
+        $focus = $widget_data['focus'];
90
+        if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){
91
+            $button = ' <input type="button" name="' . $this->getWidgetId() . '" id="' . $this->getWidgetId() . '" class="button"' . "\n"
92
+            . ' title="' . $this->title . '"'
93
+            . ' value="' . $this->value . "\"\n"
94
+            .' disabled />';
95
+            return $button;
96
+        }
97
+
98
+        //refresh the whole page after end of action?
99
+        $refresh_page = 0;
100
+        if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){
101
+            $refresh_page = 1;
102
+        }
103
+
104
+        $subpanel_definition = $widget_data['subpanel_definition'];
105
+        $button_definition = $subpanel_definition->get_buttons();
106 106
 
107 107
         $subpanel_name = $subpanel_definition->get_name();
108
-		if (empty($this->module_name)) {
109
-			$this->module_name = $subpanel_definition->get_module_name();
110
-		}
111
-		$link_field_name = $subpanel_definition->get_data_source_name(true);
112
-		$popup_mode='Single';
113
-		if(isset($widget_data['mode'])){
114
-			$popup_mode=$widget_data['mode'];
115
-		}
116
-		if(isset($widget_data['initial_filter_fields'])){
117
-			if (is_array($widget_data['initial_filter_fields'])) {
118
-				foreach ($widget_data['initial_filter_fields'] as $value=>$alias) {
119
-					if (isset($focus->$value) and !empty($focus->$value)) {
120
-						$initial_filter.="&".$alias . '='.urlencode($focus->$value);
121
-					}
122
-				}
123
-			}
124
-		}
125
-		$create="true";
126
-		if(isset($widget_data['create'])){
127
-			$create=$widget_data['create'];
128
-		}
129
-		$return_module = $_REQUEST['module'];
130
-		$return_action = 'SubPanelViewer';
131
-		$return_id = $_REQUEST['record'];
132
-
133
-		//field_to_name_array
134
-		$fton_array= array('id' => 'subpanel_id');
135
-		if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){
136
-			$fton_array=array_merge($fton_array,$widget_data['field_to_name_array']);
137
-		}
138
-
139
-		$return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1";
140
-
141
-		$popup_request_data = array(
142
-			'call_back_function' => 'set_return_and_save_background',
143
-			'form_name' => 'DetailView',
144
-			'field_to_name_array' => $fton_array,
145
-			'passthru_data' => array(
146
-				'child_field' => $subpanel_name,
147
-				'return_url' => urlencode($return_url),
148
-				'link_field_name' => $link_field_name,
149
-				'module_name' => $subpanel_name,
150
-				'refresh_page'=>$refresh_page,
151
-			),
152
-		);
108
+        if (empty($this->module_name)) {
109
+            $this->module_name = $subpanel_definition->get_module_name();
110
+        }
111
+        $link_field_name = $subpanel_definition->get_data_source_name(true);
112
+        $popup_mode='Single';
113
+        if(isset($widget_data['mode'])){
114
+            $popup_mode=$widget_data['mode'];
115
+        }
116
+        if(isset($widget_data['initial_filter_fields'])){
117
+            if (is_array($widget_data['initial_filter_fields'])) {
118
+                foreach ($widget_data['initial_filter_fields'] as $value=>$alias) {
119
+                    if (isset($focus->$value) and !empty($focus->$value)) {
120
+                        $initial_filter.="&".$alias . '='.urlencode($focus->$value);
121
+                    }
122
+                }
123
+            }
124
+        }
125
+        $create="true";
126
+        if(isset($widget_data['create'])){
127
+            $create=$widget_data['create'];
128
+        }
129
+        $return_module = $_REQUEST['module'];
130
+        $return_action = 'SubPanelViewer';
131
+        $return_id = $_REQUEST['record'];
132
+
133
+        //field_to_name_array
134
+        $fton_array= array('id' => 'subpanel_id');
135
+        if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){
136
+            $fton_array=array_merge($fton_array,$widget_data['field_to_name_array']);
137
+        }
138
+
139
+        $return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1";
140
+
141
+        $popup_request_data = array(
142
+            'call_back_function' => 'set_return_and_save_background',
143
+            'form_name' => 'DetailView',
144
+            'field_to_name_array' => $fton_array,
145
+            'passthru_data' => array(
146
+                'child_field' => $subpanel_name,
147
+                'return_url' => urlencode($return_url),
148
+                'link_field_name' => $link_field_name,
149
+                'module_name' => $subpanel_name,
150
+                'refresh_page'=>$refresh_page,
151
+            ),
152
+        );
153 153
 
154 154
                 // bugfix #57850 add marketing_id to the request data to allow filtering based on it
155 155
                 if (!empty($_REQUEST['mkt_id']))
@@ -162,35 +162,35 @@  discard block
 block discarded – undo
162 162
                     $popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']);
163 163
                 }
164 164
 
165
-		if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) {
165
+        if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) {
166 166
 
167
-			if ($this->button_properties['add_to_passthru_data']['return_type']=='report') {
168
-				$initial_filter = "&module_name=". urlencode($widget_data['module']);
169
-			}
170
-		}
167
+            if ($this->button_properties['add_to_passthru_data']['return_type']=='report') {
168
+                $initial_filter = "&module_name=". urlencode($widget_data['module']);
169
+            }
170
+        }
171 171
         //acl_roles_users_selectuser_button
172 172
 
173 173
         $json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data);
174
-		return ' <input type="button" name="' . $this->getWidgetId() . '" id="' . $this->getWidgetId() . '" class="button"' . "\n"
175
-				. ' title="' . $this->title . '"'
176
-			. ' value="' . $this->value . "\"\n"
177
-			. " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' />\n";
178
-	}
174
+        return ' <input type="button" name="' . $this->getWidgetId() . '" id="' . $this->getWidgetId() . '" class="button"' . "\n"
175
+                . ' title="' . $this->title . '"'
176
+            . ' value="' . $this->value . "\"\n"
177
+            . " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' />\n";
178
+    }
179 179
 
180 180
     /**
181
-    * @return string
182
-    */
181
+     * @return string
182
+     */
183 183
     protected function getTitle()
184 184
     {
185
-       return translate('LBL_SELECT_BUTTON_TITLE');
185
+        return translate('LBL_SELECT_BUTTON_TITLE');
186 186
     }
187 187
 
188 188
     /**
189
-    * @return string
190
-    */
189
+     * @return string
190
+     */
191 191
     protected function getAccesskey()
192 192
     {
193
-       return translate('LBL_SELECT_BUTTON_KEY');
193
+        return translate('LBL_SELECT_BUTTON_KEY');
194 194
     }
195 195
 
196 196
 }
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetFielddatetime.php 1 patch
Indentation   +280 added lines, -280 removed lines patch added patch discarded remove patch
@@ -43,39 +43,39 @@  discard block
 block discarded – undo
43 43
 
44 44
 class SugarWidgetFieldDateTime extends SugarWidgetReportField
45 45
 {
46
-	var $reporter;
47
-	var $assigned_user=null;
46
+    var $reporter;
47
+    var $assigned_user=null;
48 48
 
49 49
     function SugarWidgetFieldDateTime($layout_manager)
50 50
     {
51 51
         parent::SugarWidgetReportField($layout_manager);
52 52
     }
53 53
 
54
-	// get the reporter attribute
54
+    // get the reporter attribute
55 55
     // deprecated, now called in the constructor
56 56
     /**
57 57
      * @deprecated
58 58
      */
59
-	function getReporter() {
60
-	}
59
+    function getReporter() {
60
+    }
61 61
 
62
-	// get the assigned user of the report
63
-	function getAssignedUser()
64
-	{
65
-		$json_obj = getJSONobj();
62
+    // get the assigned user of the report
63
+    function getAssignedUser()
64
+    {
65
+        $json_obj = getJSONobj();
66 66
 
67
-		$report_def_str = $json_obj->decode($this->reporter->report_def_str);
67
+        $report_def_str = $json_obj->decode($this->reporter->report_def_str);
68 68
 
69
-		if(empty($report_def_str['assigned_user_id'])) return null;
69
+        if(empty($report_def_str['assigned_user_id'])) return null;
70 70
 
71
-		$this->assigned_user = new User();
72
-		$this->assigned_user->retrieve($report_def_str['assigned_user_id']);
73
-		return $this->assigned_user;
74
-	}
71
+        $this->assigned_user = new User();
72
+        $this->assigned_user->retrieve($report_def_str['assigned_user_id']);
73
+        return $this->assigned_user;
74
+    }
75 75
 
76
-	function queryFilterOn($layout_def)
77
-	{
78
-		global $timedate;
76
+    function queryFilterOn($layout_def)
77
+    {
78
+        global $timedate;
79 79
         $begin = $layout_def['input_name0'];
80 80
         $hasTime = $this->hasTime($begin);
81 81
         $date = $timedate->fromString($begin);
@@ -93,7 +93,7 @@  discard block
 block discarded – undo
93 93
             '=',
94 94
             "datetime"
95 95
         );
96
-	}
96
+    }
97 97
 
98 98
     /**
99 99
      * expandDate
@@ -108,61 +108,61 @@  discard block
 block discarded – undo
108 108
      * @param bool $end Boolean value indicating whether or not this is for an end time period or not
109 109
      * @return $date TimeDate object with time value applied
110 110
      */
111
-	protected function expandDate($date, $end = false)
112
-	{
113
-	    global $timedate;
114
-	    if($this->hasTime($date)) {
115
-	        return $date;
116
-	    }
111
+    protected function expandDate($date, $end = false)
112
+    {
113
+        global $timedate;
114
+        if($this->hasTime($date)) {
115
+            return $date;
116
+        }
117 117
 
118 118
         //C.L. Bug 48616 - If the $date is set to the Today macro, then adjust accordingly
119 119
         if(strtolower($date) == 'today')
120 120
         {
121
-           $startEnd = $timedate->getDayStartEndGMT($timedate->getNow(true));
122
-           return $end ? $startEnd['end'] : $startEnd['start'];
121
+            $startEnd = $timedate->getDayStartEndGMT($timedate->getNow(true));
122
+            return $end ? $startEnd['end'] : $startEnd['start'];
123 123
         }
124 124
 
125 125
         $parsed = $timedate->fromDbDate($date);
126 126
         $date = $timedate->tzUser(new SugarDateTime());
127 127
         $date->setDate($parsed->year, $parsed->month, $parsed->day);
128 128
 
129
-	    if($end) {
130
-	        return $date->setTime(23, 59, 59);
131
-	    } else {
132
-	        return $date->setTime(0, 0, 0);
133
-	    }
134
-	}
129
+        if($end) {
130
+            return $date->setTime(23, 59, 59);
131
+        } else {
132
+            return $date->setTime(0, 0, 0);
133
+        }
134
+    }
135 135
 
136
-	function queryFilterBefore($layout_def)
137
-	{
136
+    function queryFilterBefore($layout_def)
137
+    {
138 138
         $begin = $this->expandDate($layout_def['input_name0']);
139 139
         return $this->queryDateOp($this->_get_column_select($layout_def), $begin, '<', "datetime");
140
-	}
140
+    }
141 141
 
142
-	function queryFilterAfter($layout_def)
143
-	{
142
+    function queryFilterAfter($layout_def)
143
+    {
144 144
         $begin = $this->expandDate($layout_def['input_name0'], true);
145 145
         return $this->queryDateOp($this->_get_column_select($layout_def), $begin, '>', "datetime");
146
-	}
146
+    }
147 147
 
148
-	function queryFilterBetween_Dates($layout_def)
149
-	{
148
+    function queryFilterBetween_Dates($layout_def)
149
+    {
150 150
         $begin = $this->expandDate($layout_def['input_name0']);
151
-     	$end = $this->expandDate($layout_def['input_name1'], true);
151
+            $end = $this->expandDate($layout_def['input_name1'], true);
152 152
         $column = $this->_get_column_select($layout_def);
153
-	    return "(".$this->queryDateOp($column, $begin, ">=", "datetime")." AND ".
153
+        return "(".$this->queryDateOp($column, $begin, ">=", "datetime")." AND ".
154 154
             $this->queryDateOp($column, $end, "<=", "datetime").")\n";
155
-	}
155
+    }
156 156
 
157
-	function queryFilterNot_Equals_str($layout_def)
158
-	{
159
-		global $timedate;
157
+    function queryFilterNot_Equals_str($layout_def)
158
+    {
159
+        global $timedate;
160 160
 
161 161
         $column = $this->_get_column_select($layout_def);
162 162
         $begin = $layout_def['input_name0'];
163 163
         $hasTime = $this->hasTime($begin);
164 164
         if(!$hasTime){
165
-     	    $end = $this->expandDate($begin, true);
165
+                $end = $this->expandDate($begin, true);
166 166
             $begin = $this->expandDate($begin);
167 167
             $cond = $this->queryDateOp($column, $begin, "<", "datetime")." OR ".
168 168
                 $this->queryDateOp($column, $end, ">", "datetime");
@@ -170,45 +170,45 @@  discard block
 block discarded – undo
170 170
             $cond =  $this->queryDateOp($column, $begin, "!=", "datetime");
171 171
         }
172 172
         return "($column IS NULL OR $cond)";
173
-	}
173
+    }
174 174
 
175 175
     /**
176 176
      * Get assigned or logged in user's current date and time value.
177 177
      * @param boolean $timestamp Format of return value, if set to true, return unix like timestamp , else a formatted date.
178 178
      */
179
-	function get_users_current_date_time($timestamp=false)
180
-	{
181
-	 	global $current_user;
179
+    function get_users_current_date_time($timestamp=false)
180
+    {
181
+            global $current_user;
182 182
         global $timedate;
183 183
 
184 184
         $begin = TimeDate::getInstance()->nowDb();
185 185
         //kbrill bug #13884
186
-       	//$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user);
187
-		$begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user);
186
+            //$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user);
187
+        $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user);
188 188
 
189 189
         if (!$timestamp) {
190
-        	return $begin;
190
+            return $begin;
191 191
         } else {
192
-        	$begin_parts = explode(' ', $begin);
193
-        	$date_parts=explode('-', $begin_parts[0]);
194
-        	$time_parts=explode(':', $begin_parts[1]);
195
-        	$curr_timestamp=mktime($time_parts[0],$time_parts[1],0,$date_parts[1], $date_parts[2],$date_parts[0]);
196
-        	return $curr_timestamp;
192
+            $begin_parts = explode(' ', $begin);
193
+            $date_parts=explode('-', $begin_parts[0]);
194
+            $time_parts=explode(':', $begin_parts[1]);
195
+            $curr_timestamp=mktime($time_parts[0],$time_parts[1],0,$date_parts[1], $date_parts[2],$date_parts[0]);
196
+            return $curr_timestamp;
197 197
         }
198 198
 
199
-	}
200
-	/**
201
-	 * Get specified date and time for a particalur day, in current user's timezone.
202
-	 * @param int $days Adjust date by this number of days, negative values are valid.
203
-	 * @param time string falg for desired time value, start: minimum time, end: maximum time, default: current time
204
-	 */
205
-	function get_db_date($days,$time) {
199
+    }
200
+    /**
201
+     * Get specified date and time for a particalur day, in current user's timezone.
202
+     * @param int $days Adjust date by this number of days, negative values are valid.
203
+     * @param time string falg for desired time value, start: minimum time, end: maximum time, default: current time
204
+     */
205
+    function get_db_date($days,$time) {
206 206
         global $timedate;
207 207
 
208 208
         $begin = date($GLOBALS['timedate']->get_db_date_time_format(), time()+(86400 * $days));  //gmt date with day adjustment applied.
209 209
         //kbrill bug #13884
210 210
         //$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user);
211
-		$begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user);
211
+        $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user);
212 212
 
213 213
         if ($time=='start') {
214 214
             $begin_parts = explode(' ', $begin);
@@ -225,38 +225,38 @@  discard block
 block discarded – undo
225 225
         $begin = $timedate->handle_offset($be, $timedate->get_db_date_time_format(), false, $this->assigned_user);
226 226
 
227 227
         return $begin;
228
-	}
229
-
230
-	/**
231
-	 * Get filter string for a date field.
232
-	 * @param array layout_def field def for field being filtered
233
-	 * @param string $begin start date value (in DB format)
234
-	 * @param string $end End date value (in DB format)
235
-	 */
236
-	function get_start_end_date_filter(& $layout_def, $begin,$end)
237
-	{
238
-	    if (isset ($layout_def['rel_field'])) {
239
-	        $field_name = $this->reporter->db->convert(
240
-	            $this->reporter->db->convert($this->_get_column_select($layout_def), 'date_format', '%Y-%m-%d'),
241
-	            "CONCAT",
242
-	            array("' '", $this->reporter->db->convert($layout_def['rel_field'], 'time_format'))
243
-	        );
244
-	    } else {
245
-	       $field_name = $this->_get_column_select($layout_def);
246
-	    }
247
-	    return $field_name.">=".$this->reporter->db->quoted($begin)." AND ".$field_name."<=".$this->reporter->db->quoted($end)."\n";
248
-	}
249
-
250
-	/**
251
-	 * Create query for binary operation of field of certain type
252
-	 * Produces query like:
253
-	 * arg1 op to_date(arg2), e.g.:
254
-	 * 		date_closed < '2009-12-01'
255
-	 * @param string $arg1 1st arg - column name
256
-	 * @param string|DateTime $arg2 2nd arg - value to be converted
257
-	 * @param string $op
258
-	 * @param string $type
259
-	 */
228
+    }
229
+
230
+    /**
231
+     * Get filter string for a date field.
232
+     * @param array layout_def field def for field being filtered
233
+     * @param string $begin start date value (in DB format)
234
+     * @param string $end End date value (in DB format)
235
+     */
236
+    function get_start_end_date_filter(& $layout_def, $begin,$end)
237
+    {
238
+        if (isset ($layout_def['rel_field'])) {
239
+            $field_name = $this->reporter->db->convert(
240
+                $this->reporter->db->convert($this->_get_column_select($layout_def), 'date_format', '%Y-%m-%d'),
241
+                "CONCAT",
242
+                array("' '", $this->reporter->db->convert($layout_def['rel_field'], 'time_format'))
243
+            );
244
+        } else {
245
+            $field_name = $this->_get_column_select($layout_def);
246
+        }
247
+        return $field_name.">=".$this->reporter->db->quoted($begin)." AND ".$field_name."<=".$this->reporter->db->quoted($end)."\n";
248
+    }
249
+
250
+    /**
251
+     * Create query for binary operation of field of certain type
252
+     * Produces query like:
253
+     * arg1 op to_date(arg2), e.g.:
254
+     * 		date_closed < '2009-12-01'
255
+     * @param string $arg1 1st arg - column name
256
+     * @param string|DateTime $arg2 2nd arg - value to be converted
257
+     * @param string $op
258
+     * @param string $type
259
+     */
260 260
     protected function queryDateOp($arg1, $arg2, $op, $type)
261 261
     {
262 262
         global $timedate;
@@ -276,7 +276,7 @@  discard block
 block discarded – undo
276 276
         return $timedate->tzUser($timedate->getNow(), $this->getAssignedUser());
277 277
     }
278 278
 
279
-	/**
279
+    /**
280 280
      * Create query from the beginning to the end of certain day
281 281
      * @param array $layout_def
282 282
      * @param SugarDateTime $day
@@ -288,43 +288,43 @@  discard block
 block discarded – undo
288 288
         return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
289 289
     }
290 290
 
291
-	function queryFilterTP_yesterday($layout_def)
292
-	{
293
-		global $timedate;
294
-		return $this->queryDay($layout_def, $this->now()->get("-1 day"));
295
-	}
291
+    function queryFilterTP_yesterday($layout_def)
292
+    {
293
+        global $timedate;
294
+        return $this->queryDay($layout_def, $this->now()->get("-1 day"));
295
+    }
296 296
 
297
-	function queryFilterTP_today($layout_def)
298
-	{
299
-		global $timedate;
300
-		return $this->queryDay($layout_def, $this->now());
301
-	}
297
+    function queryFilterTP_today($layout_def)
298
+    {
299
+        global $timedate;
300
+        return $this->queryDay($layout_def, $this->now());
301
+    }
302 302
 
303
-	function queryFilterTP_tomorrow(& $layout_def)
304
-	{
305
-		global $timedate;
306
-		return $this->queryDay($layout_def, $this->now()->get("+1 day"));
307
-	}
303
+    function queryFilterTP_tomorrow(& $layout_def)
304
+    {
305
+        global $timedate;
306
+        return $this->queryDay($layout_def, $this->now()->get("+1 day"));
307
+    }
308 308
 
309
-	function queryFilterTP_last_7_days($layout_def)
310
-	{
311
-		global $timedate;
309
+    function queryFilterTP_last_7_days($layout_def)
310
+    {
311
+        global $timedate;
312 312
 
313
-		$begin = $this->now()->get("-6 days")->get_day_begin();
314
-		$end = $this->now()->get_day_end();
313
+        $begin = $this->now()->get("-6 days")->get_day_begin();
314
+        $end = $this->now()->get_day_end();
315 315
 
316
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
317
-	}
316
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
317
+    }
318 318
 
319
-	function queryFilterTP_next_7_days($layout_def)
320
-	{
321
-		global $timedate;
319
+    function queryFilterTP_next_7_days($layout_def)
320
+    {
321
+        global $timedate;
322 322
 
323
-		$begin = $this->now()->get_day_begin();
324
-		$end = $this->now()->get("+6 days")->get_day_end();
323
+        $begin = $this->now()->get_day_begin();
324
+        $end = $this->now()->get("+6 days")->get_day_end();
325 325
 
326
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
327
-	}
326
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
327
+    }
328 328
 
329 329
     /**
330 330
      * Create query from the beginning to the end of certain month
@@ -335,20 +335,20 @@  discard block
 block discarded – undo
335 335
     {
336 336
         $begin = $month->setTime(0, 0, 0);
337 337
         $end = clone($begin);
338
-		$end->setDate($begin->year, $begin->month, $begin->days_in_month)->setTime(23, 59, 59);
338
+        $end->setDate($begin->year, $begin->month, $begin->days_in_month)->setTime(23, 59, 59);
339 339
         return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
340 340
     }
341 341
 
342 342
     function queryFilterTP_last_month($layout_def)
343
-	{
344
-		global $timedate;
345
-		$month = $this->now();
346
-		return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month-1, 1));
347
-	}
343
+    {
344
+        global $timedate;
345
+        $month = $this->now();
346
+        return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month-1, 1));
347
+    }
348 348
 
349
-	function queryFilterTP_this_month($layout_def)
350
-	{
351
-		global $timedate;
349
+    function queryFilterTP_this_month($layout_def)
350
+    {
351
+        global $timedate;
352 352
 
353 353
         //Bug 62414 - take timezone into account when determining current month
354 354
         $now = $this->now();
@@ -357,30 +357,30 @@  discard block
 block discarded – undo
357 357
         $now->modify($timezoneOffset);
358 358
 
359 359
         return $this->queryMonth($layout_def, $now->get_day_by_index_this_month(0));
360
-	}
361
-
362
-	function queryFilterTP_next_month($layout_def)
363
-	{
364
-		global $timedate;
365
-		$month = $this->now();
366
-		return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month+1, 1));
367
-	}
368
-
369
-	function queryFilterTP_last_30_days($layout_def)
370
-	{
371
-		global $timedate;
372
-		$begin = $this->now()->get("-29 days")->get_day_begin();
373
-		$end = $this->now()->get_day_end();
374
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
375
-	}
376
-
377
-	function queryFilterTP_next_30_days($layout_def)
378
-	{
379
-		global $timedate;
380
-		$begin = $this->now()->get_day_begin();
381
-		$end = $this->now()->get("+29 days")->get_day_end();
382
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
383
-	}
360
+    }
361
+
362
+    function queryFilterTP_next_month($layout_def)
363
+    {
364
+        global $timedate;
365
+        $month = $this->now();
366
+        return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month+1, 1));
367
+    }
368
+
369
+    function queryFilterTP_last_30_days($layout_def)
370
+    {
371
+        global $timedate;
372
+        $begin = $this->now()->get("-29 days")->get_day_begin();
373
+        $end = $this->now()->get_day_end();
374
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
375
+    }
376
+
377
+    function queryFilterTP_next_30_days($layout_def)
378
+    {
379
+        global $timedate;
380
+        $begin = $this->now()->get_day_begin();
381
+        $end = $this->now()->get("+29 days")->get_day_end();
382
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
383
+    }
384 384
 
385 385
     /**
386 386
      * Return the between WHERE query for Quarter filter
@@ -453,59 +453,59 @@  discard block
 block discarded – undo
453 453
         return $this->getQuarterFilter($layout_def, '+3 month');
454 454
     }
455 455
 
456
-	function queryFilterTP_last_year($layout_def)
457
-	{
458
-		global $timedate;
459
-		$begin = $this->now();
460
-		$begin->setDate($begin->year-1, 1, 1)->setTime(0, 0);
461
-		$end = clone $begin;
462
-		$end->setDate($end->year, 12, 31)->setTime(23, 59, 59);
463
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
464
-	}
465
-
466
-	function queryFilterTP_this_year($layout_def)
467
-	{
468
-		global $timedate;
469
-		$begin = $this->now();
470
-		$begin->setDate($begin->year, 1, 1)->setTime(0, 0);
471
-		$end = clone $begin;
472
-		$end->setDate($end->year, 12, 31)->setTime(23, 59, 59);
473
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
474
-	}
475
-
476
-	function queryFilterTP_next_year(& $layout_def)
477
-	{
478
-		global $timedate;
479
-		$begin = $this->now();
480
-		$begin->setDate($begin->year+1, 1, 1)->setTime(0, 0);
481
-		$end = clone $begin;
482
-		$end->setDate($end->year, 12, 31)->setTime(23, 59, 59);
483
-		return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
484
-	}
485
-
486
-	function queryGroupBy($layout_def)
487
-	{
488
-		// i guess qualifier and column_function are the same..
489
-		if (!empty ($layout_def['qualifier'])) {
490
-			$func_name = 'queryGroupBy'.$layout_def['qualifier'];
491
-			if (method_exists($this, $func_name)) {
492
-				return $this-> $func_name ($layout_def)." \n";
493
-			}
494
-		}
495
-		return parent :: queryGroupBy($layout_def)." \n";
496
-	}
497
-
498
-	function queryOrderBy($layout_def)
499
-	{
456
+    function queryFilterTP_last_year($layout_def)
457
+    {
458
+        global $timedate;
459
+        $begin = $this->now();
460
+        $begin->setDate($begin->year-1, 1, 1)->setTime(0, 0);
461
+        $end = clone $begin;
462
+        $end->setDate($end->year, 12, 31)->setTime(23, 59, 59);
463
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
464
+    }
465
+
466
+    function queryFilterTP_this_year($layout_def)
467
+    {
468
+        global $timedate;
469
+        $begin = $this->now();
470
+        $begin->setDate($begin->year, 1, 1)->setTime(0, 0);
471
+        $end = clone $begin;
472
+        $end->setDate($end->year, 12, 31)->setTime(23, 59, 59);
473
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
474
+    }
475
+
476
+    function queryFilterTP_next_year(& $layout_def)
477
+    {
478
+        global $timedate;
479
+        $begin = $this->now();
480
+        $begin->setDate($begin->year+1, 1, 1)->setTime(0, 0);
481
+        $end = clone $begin;
482
+        $end->setDate($end->year, 12, 31)->setTime(23, 59, 59);
483
+        return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb());
484
+    }
485
+
486
+    function queryGroupBy($layout_def)
487
+    {
488
+        // i guess qualifier and column_function are the same..
500 489
         if (!empty ($layout_def['qualifier'])) {
501
-			$func_name ='queryOrderBy'.$layout_def['qualifier'];
502
-			if (method_exists($this, $func_name)) {
503
-				return $this-> $func_name ($layout_def)."\n";
504
-			}
505
-		}
506
-		$order_by = parent :: queryOrderBy($layout_def)."\n";
507
-		return $order_by;
508
-	}
490
+            $func_name = 'queryGroupBy'.$layout_def['qualifier'];
491
+            if (method_exists($this, $func_name)) {
492
+                return $this-> $func_name ($layout_def)." \n";
493
+            }
494
+        }
495
+        return parent :: queryGroupBy($layout_def)." \n";
496
+    }
497
+
498
+    function queryOrderBy($layout_def)
499
+    {
500
+        if (!empty ($layout_def['qualifier'])) {
501
+            $func_name ='queryOrderBy'.$layout_def['qualifier'];
502
+            if (method_exists($this, $func_name)) {
503
+                return $this-> $func_name ($layout_def)."\n";
504
+            }
505
+        }
506
+        $order_by = parent :: queryOrderBy($layout_def)."\n";
507
+        return $order_by;
508
+    }
509 509
 
510 510
     function displayListPlain($layout_def) {
511 511
         global $timedate;
@@ -551,39 +551,39 @@  discard block
 block discarded – undo
551 551
         return $timedate->to_display_date_time($content);
552 552
     }
553 553
 
554
-	function querySelect(& $layout_def) {
555
-		// i guess qualifier and column_function are the same..
556
-		if (!empty ($layout_def['column_function'])) {
557
-			$func_name = 'querySelect'.$layout_def['column_function'];
558
-			if (method_exists($this, $func_name)) {
559
-				return $this-> $func_name ($layout_def)." \n";
560
-			}
561
-		}
562
-		return parent :: querySelect($layout_def)." \n";
563
-	}
564
-	function & displayListday(& $layout_def) {
554
+    function querySelect(& $layout_def) {
555
+        // i guess qualifier and column_function are the same..
556
+        if (!empty ($layout_def['column_function'])) {
557
+            $func_name = 'querySelect'.$layout_def['column_function'];
558
+            if (method_exists($this, $func_name)) {
559
+                return $this-> $func_name ($layout_def)." \n";
560
+            }
561
+        }
562
+        return parent :: querySelect($layout_def)." \n";
563
+    }
564
+    function & displayListday(& $layout_def) {
565 565
         $value = parent:: displayListPlain($layout_def);
566 566
         return $value;
567
-	}
568
-
569
-	function & displayListyear(& $layout_def) {
570
-		global $app_list_strings;
571
-    	$value = parent:: displayListPlain($layout_def);
572
-    	return $value;
573
-	}
574
-
575
-	function displayListmonth($layout_def)
576
-	{
577
-		global $app_list_strings;
578
-		$display = '';
579
-		$match = array();
567
+    }
568
+
569
+    function & displayListyear(& $layout_def) {
570
+        global $app_list_strings;
571
+        $value = parent:: displayListPlain($layout_def);
572
+        return $value;
573
+    }
574
+
575
+    function displayListmonth($layout_def)
576
+    {
577
+        global $app_list_strings;
578
+        $display = '';
579
+        $match = array();
580 580
         if (preg_match('/(\d{4})-(\d\d)/', $this->displayListPlain($layout_def), $match)) {
581
-			$match[2] = preg_replace('/^0/', '', $match[2]);
582
-			$display = $app_list_strings['dom_cal_month_long'][$match[2]]." {$match[1]}";
583
-		}
584
-		return $display;
581
+            $match[2] = preg_replace('/^0/', '', $match[2]);
582
+            $display = $app_list_strings['dom_cal_month_long'][$match[2]]." {$match[1]}";
583
+        }
584
+        return $display;
585 585
 
586
-	}
586
+    }
587 587
 
588 588
     /**
589 589
      * Returns part of query for select
@@ -706,32 +706,32 @@  discard block
 block discarded – undo
706 706
         return $this->reporter->db->convert($return, "date_format", array('%Y')) . "\n";
707 707
     }
708 708
 
709
-	function querySelectquarter($layout_def)
710
-	{
711
-	    $column = $this->_get_column_select($layout_def);
712
-	    return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')),
713
-	        	'CONCAT',
714
-	            array("'-'", $this->reporter->db->convert($column, "quarter")))
715
-	        ." ".$this->_get_column_alias($layout_def)."\n";
716
-	}
709
+    function querySelectquarter($layout_def)
710
+    {
711
+        $column = $this->_get_column_select($layout_def);
712
+        return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')),
713
+                'CONCAT',
714
+                array("'-'", $this->reporter->db->convert($column, "quarter")))
715
+            ." ".$this->_get_column_alias($layout_def)."\n";
716
+    }
717 717
 
718
-	function displayListquarter(& $layout_def) {
719
-		$match = array();
718
+    function displayListquarter(& $layout_def) {
719
+        $match = array();
720 720
         if (preg_match('/(\d{4})-(\d)/', $this->displayListPlain($layout_def), $match)) {
721
-			return "Q".$match[2]." ".$match[1];
722
-		}
723
-		return '';
721
+            return "Q".$match[2]." ".$match[1];
722
+        }
723
+        return '';
724 724
 
725
-	}
725
+    }
726 726
 
727
-	function queryGroupByQuarter($layout_def)
728
-	{
729
-		$this->getReporter();
727
+    function queryGroupByQuarter($layout_def)
728
+    {
729
+        $this->getReporter();
730 730
         $column = $this->_get_column_select($layout_def);
731
-	    return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')),
732
-	        	'CONCAT',
733
-	            array("'-'", $this->reporter->db->convert($column, "quarter")));
734
-	}
731
+        return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')),
732
+                'CONCAT',
733
+                array("'-'", $this->reporter->db->convert($column, "quarter")));
734
+    }
735 735
 
736 736
     /**
737 737
      * For oracle we have to return order by string like group by string instead of return field alias
@@ -760,23 +760,23 @@  discard block
 block discarded – undo
760 760
     }
761 761
 
762 762
     function displayInput(&$layout_def) {
763
-    	global $timedate, $current_language, $app_strings;
763
+        global $timedate, $current_language, $app_strings;
764 764
         $home_mod_strings = return_module_language($current_language, 'Home');
765 765
         $filterTypes = array(' '                 => $app_strings['LBL_NONE'],
766
-                             'TP_today'         => $home_mod_strings['LBL_TODAY'],
767
-                             'TP_yesterday'     => $home_mod_strings['LBL_YESTERDAY'],
768
-                             'TP_tomorrow'      => $home_mod_strings['LBL_TOMORROW'],
769
-                             'TP_this_month'    => $home_mod_strings['LBL_THIS_MONTH'],
770
-                             'TP_this_year'     => $home_mod_strings['LBL_THIS_YEAR'],
771
-                             'TP_last_30_days'  => $home_mod_strings['LBL_LAST_30_DAYS'],
772
-                             'TP_last_7_days'   => $home_mod_strings['LBL_LAST_7_DAYS'],
773
-                             'TP_last_month'    => $home_mod_strings['LBL_LAST_MONTH'],
774
-                             'TP_last_year'     => $home_mod_strings['LBL_LAST_YEAR'],
775
-                             'TP_next_30_days'  => $home_mod_strings['LBL_NEXT_30_DAYS'],
776
-                             'TP_next_7_days'   => $home_mod_strings['LBL_NEXT_7_DAYS'],
777
-                             'TP_next_month'    => $home_mod_strings['LBL_NEXT_MONTH'],
778
-                             'TP_next_year'     => $home_mod_strings['LBL_NEXT_YEAR'],
779
-                             );
766
+                                'TP_today'         => $home_mod_strings['LBL_TODAY'],
767
+                                'TP_yesterday'     => $home_mod_strings['LBL_YESTERDAY'],
768
+                                'TP_tomorrow'      => $home_mod_strings['LBL_TOMORROW'],
769
+                                'TP_this_month'    => $home_mod_strings['LBL_THIS_MONTH'],
770
+                                'TP_this_year'     => $home_mod_strings['LBL_THIS_YEAR'],
771
+                                'TP_last_30_days'  => $home_mod_strings['LBL_LAST_30_DAYS'],
772
+                                'TP_last_7_days'   => $home_mod_strings['LBL_LAST_7_DAYS'],
773
+                                'TP_last_month'    => $home_mod_strings['LBL_LAST_MONTH'],
774
+                                'TP_last_year'     => $home_mod_strings['LBL_LAST_YEAR'],
775
+                                'TP_next_30_days'  => $home_mod_strings['LBL_NEXT_30_DAYS'],
776
+                                'TP_next_7_days'   => $home_mod_strings['LBL_NEXT_7_DAYS'],
777
+                                'TP_next_month'    => $home_mod_strings['LBL_NEXT_MONTH'],
778
+                                'TP_next_year'     => $home_mod_strings['LBL_NEXT_YEAR'],
779
+                                );
780 780
 
781 781
         $cal_dateformat = $timedate->get_cal_date_format();
782 782
         $str = "<select name='type_{$layout_def['name']}'>";
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetFielddatetimecombo.php 1 patch
Indentation   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -42,28 +42,28 @@
 block discarded – undo
42 42
 
43 43
 
44 44
 class SugarWidgetFieldDateTimecombo extends SugarWidgetFieldDateTime {
45
-	var $reporter;
46
-	var $assigned_user=null;
45
+    var $reporter;
46
+    var $assigned_user=null;
47 47
 
48 48
     function SugarWidgetFieldDateTimecombo(&$layout_manager) {
49 49
         parent::SugarWidgetFieldDateTime($layout_manager);
50 50
         $this->reporter = $this->layout_manager->getAttribute('reporter');
51 51
     }
52
-	//TODO:now for date time field , we just search from date start to date end. The time is from 00:00:00 to 23:59:59
53
-	//If there is requirement, we can modify report.js::addFilterInputDatetimesBetween and this function
54
-	function queryFilterBetween_Datetimes(& $layout_def) {
55
-		global $timedate;
56
-		if($this->getAssignedUser()) {
57
-			$begin = $timedate->handle_offset($layout_def['input_name0'], $timedate->get_db_date_time_format(), false, $this->assigned_user);
58
-			$end = $timedate->handle_offset($layout_def['input_name2'], $timedate->get_db_date_time_format(), false, $this->assigned_user);
59
-		}
60
-		else {
61
-			$begin = $layout_def['input_name0'];
62
-			$end = $layout_def['input_name1'];
63
-		}
64
-		return "(".$this->_get_column_select($layout_def).">=".$this->reporter->db->convert($this->reporter->db->quoted($begin), "datetime").
65
-			" AND\n ".$this->_get_column_select($layout_def)."<=".$this->reporter->db->convert($this->reporter->db->quoted($end), "datetime").
66
-			")\n";
67
-	}
52
+    //TODO:now for date time field , we just search from date start to date end. The time is from 00:00:00 to 23:59:59
53
+    //If there is requirement, we can modify report.js::addFilterInputDatetimesBetween and this function
54
+    function queryFilterBetween_Datetimes(& $layout_def) {
55
+        global $timedate;
56
+        if($this->getAssignedUser()) {
57
+            $begin = $timedate->handle_offset($layout_def['input_name0'], $timedate->get_db_date_time_format(), false, $this->assigned_user);
58
+            $end = $timedate->handle_offset($layout_def['input_name2'], $timedate->get_db_date_time_format(), false, $this->assigned_user);
59
+        }
60
+        else {
61
+            $begin = $layout_def['input_name0'];
62
+            $end = $layout_def['input_name1'];
63
+        }
64
+        return "(".$this->_get_column_select($layout_def).">=".$this->reporter->db->convert($this->reporter->db->quoted($begin), "datetime").
65
+            " AND\n ".$this->_get_column_select($layout_def)."<=".$this->reporter->db->convert($this->reporter->db->quoted($end), "datetime").
66
+            ")\n";
67
+    }
68 68
 
69 69
 }
Please login to merge, or discard this patch.
include/generic/SugarWidgets/SugarWidgetSubPanelTopButton.php 1 patch
Indentation   +97 added lines, -97 removed lines patch added patch discarded remove patch
@@ -46,60 +46,60 @@  discard block
 block discarded – undo
46 46
 class SugarWidgetSubPanelTopButton extends SugarWidget
47 47
 {
48 48
     var $module;
49
-	var $title;
50
-	var $access_key;
51
-	var $form_value;
52
-	var $additional_form_fields;
53
-	var $acl;
49
+    var $title;
50
+    var $access_key;
51
+    var $form_value;
52
+    var $additional_form_fields;
53
+    var $acl;
54 54
 
55 55
 //TODO rename defines to layout defs and make it a member variable instead of passing it multiple layers with extra copying.
56 56
 
57
-	/** Take the keys for the strings and look them up.  Module is literal, the rest are label keys
58
-	*/
59
-	function SugarWidgetSubPanelTopButton($module='', $title='', $access_key='', $form_value='')
60
-	{
61
-		global $app_strings;
62
-
63
-		if(is_array($module))
64
-		{
65
-			// it is really the class details from the mapping
66
-			$class_details = $module;
67
-
68
-			// If keys were passed into the constructor, translate them from keys to values.
69
-			if(!empty($class_details['module']))
70
-				$this->module = $class_details['module'];
71
-			if(!empty($class_details['title']))
72
-				$this->title = $app_strings[$class_details['title']];
73
-			if(!empty($class_details['access_key']))
74
-				$this->access_key = $app_strings[$class_details['access_key']];
75
-			if(!empty($class_details['form_value']))
76
-				$this->form_value = translate($class_details['form_value'], $this->module);
77
-			if(!empty($class_details['additional_form_fields']))
78
-				$this->additional_form_fields = $class_details['additional_form_fields'];
79
-			if(!empty($class_details['ACL'])){
80
-				$this->acl = $class_details['ACL'];
81
-			}
82
-		}
83
-		else
84
-		{
85
-			$this->module = $module;
86
-
87
-			// If keys were passed into the constructor, translate them from keys to values.
88
-			if(!empty($title))
89
-				$this->title = $app_strings[$title];
90
-			if(!empty($access_key))
91
-				$this->access_key = $app_strings[$access_key];
92
-			if(!empty($form_value))
93
-				$this->form_value = translate($form_value, $module);
94
-		}
95
-	}
57
+    /** Take the keys for the strings and look them up.  Module is literal, the rest are label keys
58
+     */
59
+    function SugarWidgetSubPanelTopButton($module='', $title='', $access_key='', $form_value='')
60
+    {
61
+        global $app_strings;
62
+
63
+        if(is_array($module))
64
+        {
65
+            // it is really the class details from the mapping
66
+            $class_details = $module;
67
+
68
+            // If keys were passed into the constructor, translate them from keys to values.
69
+            if(!empty($class_details['module']))
70
+                $this->module = $class_details['module'];
71
+            if(!empty($class_details['title']))
72
+                $this->title = $app_strings[$class_details['title']];
73
+            if(!empty($class_details['access_key']))
74
+                $this->access_key = $app_strings[$class_details['access_key']];
75
+            if(!empty($class_details['form_value']))
76
+                $this->form_value = translate($class_details['form_value'], $this->module);
77
+            if(!empty($class_details['additional_form_fields']))
78
+                $this->additional_form_fields = $class_details['additional_form_fields'];
79
+            if(!empty($class_details['ACL'])){
80
+                $this->acl = $class_details['ACL'];
81
+            }
82
+        }
83
+        else
84
+        {
85
+            $this->module = $module;
86
+
87
+            // If keys were passed into the constructor, translate them from keys to values.
88
+            if(!empty($title))
89
+                $this->title = $app_strings[$title];
90
+            if(!empty($access_key))
91
+                $this->access_key = $app_strings[$access_key];
92
+            if(!empty($form_value))
93
+                $this->form_value = translate($form_value, $module);
94
+        }
95
+    }
96 96
 
97 97
     public function getWidgetId($buttonSuffix = true)
98 98
     {
99
-    	$widgetID = parent::getWidgetId() . '_'.preg_replace('[ ]', '', mb_strtolower($this->form_value, 'UTF-8'));
100
-    	if($buttonSuffix){
101
-    		$widgetID .= '_button';
102
-    	}
99
+        $widgetID = parent::getWidgetId() . '_'.preg_replace('[ ]', '', mb_strtolower($this->form_value, 'UTF-8'));
100
+        if($buttonSuffix){
101
+            $widgetID .= '_button';
102
+        }
103 103
         return $widgetID;
104 104
     }
105 105
 
@@ -125,7 +125,7 @@  discard block
 block discarded – undo
125 125
         }
126 126
 
127 127
 
128
-		if(!empty($this->module))
128
+        if(!empty($this->module))
129 129
         {
130 130
             $defines['child_module_name'] = $this->module;
131 131
         }
@@ -135,7 +135,7 @@  discard block
 block discarded – undo
135 135
         }
136 136
 
137 137
         $defines['parent_bean_name'] = get_class( $defines['focus']);
138
-		$relationship_name = $this->get_subpanel_relationship_name($defines);
138
+        $relationship_name = $this->get_subpanel_relationship_name($defines);
139 139
 
140 140
 
141 141
         $formValues = array();
@@ -150,10 +150,10 @@  discard block
 block discarded – undo
150 150
             // #26451,add these fields for custom one-to-many relate field.
151 151
             if(!empty($defines['child_module_name'])){
152 152
                 $formValues[$relationship_name."_name"] = $defines['focus']->name;
153
-            	$childFocusName = !empty($GLOBALS['beanList'][$defines['child_module_name']]) ? $GLOBALS['beanList'][$defines['child_module_name']] : "";
154
-            	if(!empty($GLOBALS['dictionary'][ $childFocusName ]["fields"][$relationship_name .'_name']['id_name'])){
155
-            		$formValues[$GLOBALS['dictionary'][ $childFocusName ]["fields"][$relationship_name .'_name']['id_name']] = $defines['focus']->id;
156
-            	}
153
+                $childFocusName = !empty($GLOBALS['beanList'][$defines['child_module_name']]) ? $GLOBALS['beanList'][$defines['child_module_name']] : "";
154
+                if(!empty($GLOBALS['dictionary'][ $childFocusName ]["fields"][$relationship_name .'_name']['id_name'])){
155
+                    $formValues[$GLOBALS['dictionary'][ $childFocusName ]["fields"][$relationship_name .'_name']['id_name']] = $defines['focus']->id;
156
+                }
157 157
             }
158 158
         }
159 159
 
@@ -216,7 +216,7 @@  discard block
 block discarded – undo
216 216
                 $additionalFormFields['parent_id'] = $defines['focus']->account_id;
217 217
                 $additionalFormFields['account_id'] = $defines['focus']->account_id;
218 218
             } else if($defines['focus']->object_name=='Contract') {
219
-            	$additionalFormFields['contract_id'] = $defines['focus']->id;
219
+                $additionalFormFields['contract_id'] = $defines['focus']->id;
220 220
             } else {
221 221
                 $additionalFormFields['parent_id'] = $defines['focus']->id;
222 222
             }
@@ -266,17 +266,17 @@  discard block
 block discarded – undo
266 266
         }
267 267
     }
268 268
 
269
-	/** This default function is used to create the HTML for a simple button */
270
-	function display($defines, $additionalFormFields = null, $nonbutton = false)
271
-	{
272
-		$temp='';
273
-		$inputID = $this->getWidgetId();
269
+    /** This default function is used to create the HTML for a simple button */
270
+    function display($defines, $additionalFormFields = null, $nonbutton = false)
271
+    {
272
+        $temp='';
273
+        $inputID = $this->getWidgetId();
274 274
 
275
-		if(!empty($this->acl) && ACLController::moduleSupportsACL($defines['module'])  &&  !ACLController::checkAccess($defines['module'], $this->acl, true)){
276
-			return $temp;
277
-		}
275
+        if(!empty($this->acl) && ACLController::moduleSupportsACL($defines['module'])  &&  !ACLController::checkAccess($defines['module'], $this->acl, true)){
276
+            return $temp;
277
+        }
278 278
 
279
-		global $app_strings;
279
+        global $app_strings;
280 280
 
281 281
         if ( isset($_REQUEST['layout_def_key']) && $_REQUEST['layout_def_key'] == 'UserEAPM' ) {
282 282
             // Subpanels generally don't go on the editview, so we have to handle this special
@@ -291,39 +291,39 @@  discard block
 block discarded – undo
291 291
             $button = "<a onclick=''>$this->form_value";
292 292
         }
293 293
         return $button;
294
-	}
295
-
296
-	/**
297
-	 * Returns a string that is the JSON encoded version of the popup request.
298
-	 * Perhaps this function should be moved to a more globally accessible location?
299
-	 */
300
-	function _create_json_encoded_popup_request($popup_request_data)
301
-	{
302
-	    return json_encode($popup_request_data);
303
-	}
304
-
305
-	/**
306
-	 * get_subpanel_relationship_name
307
-	 * Get the relationship name based on the subapnel definition
308
-	 * @param mixed $defines The subpanel definition
309
-	 */
310
-	function get_subpanel_relationship_name($defines) {
311
-		 $relationship_name = '';
312
-		 if(!empty($defines)) {
313
-		 	$relationship_name = isset($defines['module']) ? $defines['module'] : '';
314
-	     	$dataSource = $defines['subpanel_definition']->get_data_source_name(true);
315
-         	if (!empty($dataSource)) {
316
-				$relationship_name = $dataSource;
317
-				//Try to set the relationship name to the real relationship, not the link.
318
-				if (!empty($defines['subpanel_definition']->parent_bean->field_defs[$dataSource])
319
-				 && !empty($defines['subpanel_definition']->parent_bean->field_defs[$dataSource]['relationship']))
320
-				{
321
-					$relationship_name = $defines['subpanel_definition']->parent_bean->field_defs[$dataSource]['relationship'];
322
-				}
323
-			}
324
-		 }
325
-		 return $relationship_name;
326
-	}
294
+    }
295
+
296
+    /**
297
+     * Returns a string that is the JSON encoded version of the popup request.
298
+     * Perhaps this function should be moved to a more globally accessible location?
299
+     */
300
+    function _create_json_encoded_popup_request($popup_request_data)
301
+    {
302
+        return json_encode($popup_request_data);
303
+    }
304
+
305
+    /**
306
+     * get_subpanel_relationship_name
307
+     * Get the relationship name based on the subapnel definition
308
+     * @param mixed $defines The subpanel definition
309
+     */
310
+    function get_subpanel_relationship_name($defines) {
311
+            $relationship_name = '';
312
+            if(!empty($defines)) {
313
+                $relationship_name = isset($defines['module']) ? $defines['module'] : '';
314
+                $dataSource = $defines['subpanel_definition']->get_data_source_name(true);
315
+                if (!empty($dataSource)) {
316
+                $relationship_name = $dataSource;
317
+                //Try to set the relationship name to the real relationship, not the link.
318
+                if (!empty($defines['subpanel_definition']->parent_bean->field_defs[$dataSource])
319
+                 && !empty($defines['subpanel_definition']->parent_bean->field_defs[$dataSource]['relationship']))
320
+                {
321
+                    $relationship_name = $defines['subpanel_definition']->parent_bean->field_defs[$dataSource]['relationship'];
322
+                }
323
+            }
324
+            }
325
+            return $relationship_name;
326
+    }
327 327
 
328 328
 }
329 329
 ?>
Please login to merge, or discard this patch.