@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -43,7 +43,7 @@ discard block |
||
| 43 | 43 | |
| 44 | 44 | class SugarWidgetFieldDateTimecombo extends SugarWidgetFieldDateTime { |
| 45 | 45 | var $reporter; |
| 46 | - var $assigned_user=null; |
|
| 46 | + var $assigned_user = null; |
|
| 47 | 47 | |
| 48 | 48 | function __construct(&$layout_manager) { |
| 49 | 49 | parent::__construct($layout_manager); |
@@ -53,9 +53,9 @@ discard block |
||
| 53 | 53 | /** |
| 54 | 54 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 55 | 55 | */ |
| 56 | - function SugarWidgetFieldDateTimecombo(&$layout_manager){ |
|
| 56 | + function SugarWidgetFieldDateTimecombo(&$layout_manager) { |
|
| 57 | 57 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 58 | - if(isset($GLOBALS['log'])) { |
|
| 58 | + if (isset($GLOBALS['log'])) { |
|
| 59 | 59 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 60 | 60 | } |
| 61 | 61 | else { |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | //If there is requirement, we can modify report.js::addFilterInputDatetimesBetween and this function |
| 69 | 69 | function queryFilterBetween_Datetimes(& $layout_def) { |
| 70 | 70 | global $timedate; |
| 71 | - if($this->getAssignedUser()) { |
|
| 71 | + if ($this->getAssignedUser()) { |
|
| 72 | 72 | $begin = $timedate->handle_offset($layout_def['input_name0'], $timedate->get_db_date_time_format(), false, $this->assigned_user); |
| 73 | 73 | $end = $timedate->handle_offset($layout_def['input_name2'], $timedate->get_db_date_time_format(), false, $this->assigned_user); |
| 74 | 74 | } |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -57,8 +59,7 @@ discard block |
||
| 57 | 59 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 58 | 60 | if(isset($GLOBALS['log'])) { |
| 59 | 61 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 60 | - } |
|
| 61 | - else { |
|
| 62 | + } else { |
|
| 62 | 63 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 63 | 64 | } |
| 64 | 65 | self::__construct($layout_manager); |
@@ -71,8 +72,7 @@ discard block |
||
| 71 | 72 | if($this->getAssignedUser()) { |
| 72 | 73 | $begin = $timedate->handle_offset($layout_def['input_name0'], $timedate->get_db_date_time_format(), false, $this->assigned_user); |
| 73 | 74 | $end = $timedate->handle_offset($layout_def['input_name2'], $timedate->get_db_date_time_format(), false, $this->assigned_user); |
| 74 | - } |
|
| 75 | - else { |
|
| 75 | + } else { |
|
| 76 | 76 | $begin = $layout_def['input_name0']; |
| 77 | 77 | $end = $layout_def['input_name1']; |
| 78 | 78 | } |
@@ -43,8 +43,8 @@ discard block |
||
| 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 __construct($layout_manager) |
| 50 | 50 | { |
@@ -66,31 +66,31 @@ discard block |
||
| 66 | 66 | } |
| 67 | 67 | |
| 68 | 68 | |
| 69 | - // get the reporter attribute |
|
| 69 | + // get the reporter attribute |
|
| 70 | 70 | // deprecated, now called in the constructor |
| 71 | 71 | /** |
| 72 | 72 | * @deprecated |
| 73 | 73 | */ |
| 74 | - function getReporter() { |
|
| 75 | - } |
|
| 74 | + function getReporter() { |
|
| 75 | + } |
|
| 76 | 76 | |
| 77 | - // get the assigned user of the report |
|
| 78 | - function getAssignedUser() |
|
| 79 | - { |
|
| 80 | - $json_obj = getJSONobj(); |
|
| 77 | + // get the assigned user of the report |
|
| 78 | + function getAssignedUser() |
|
| 79 | + { |
|
| 80 | + $json_obj = getJSONobj(); |
|
| 81 | 81 | |
| 82 | - $report_def_str = $json_obj->decode($this->reporter->report_def_str); |
|
| 82 | + $report_def_str = $json_obj->decode($this->reporter->report_def_str); |
|
| 83 | 83 | |
| 84 | - if(empty($report_def_str['assigned_user_id'])) return null; |
|
| 84 | + if(empty($report_def_str['assigned_user_id'])) return null; |
|
| 85 | 85 | |
| 86 | - $this->assigned_user = new User(); |
|
| 87 | - $this->assigned_user->retrieve($report_def_str['assigned_user_id']); |
|
| 88 | - return $this->assigned_user; |
|
| 89 | - } |
|
| 86 | + $this->assigned_user = new User(); |
|
| 87 | + $this->assigned_user->retrieve($report_def_str['assigned_user_id']); |
|
| 88 | + return $this->assigned_user; |
|
| 89 | + } |
|
| 90 | 90 | |
| 91 | - function queryFilterOn($layout_def) |
|
| 92 | - { |
|
| 93 | - global $timedate; |
|
| 91 | + function queryFilterOn($layout_def) |
|
| 92 | + { |
|
| 93 | + global $timedate; |
|
| 94 | 94 | $begin = $layout_def['input_name0']; |
| 95 | 95 | $hasTime = $this->hasTime($begin); |
| 96 | 96 | $date = $timedate->fromString($begin); |
@@ -108,7 +108,7 @@ discard block |
||
| 108 | 108 | '=', |
| 109 | 109 | "datetime" |
| 110 | 110 | ); |
| 111 | - } |
|
| 111 | + } |
|
| 112 | 112 | |
| 113 | 113 | /** |
| 114 | 114 | * expandDate |
@@ -123,61 +123,61 @@ discard block |
||
| 123 | 123 | * @param bool $end Boolean value indicating whether or not this is for an end time period or not |
| 124 | 124 | * @return $date TimeDate object with time value applied |
| 125 | 125 | */ |
| 126 | - protected function expandDate($date, $end = false) |
|
| 127 | - { |
|
| 128 | - global $timedate; |
|
| 129 | - if($this->hasTime($date)) { |
|
| 130 | - return $date; |
|
| 131 | - } |
|
| 126 | + protected function expandDate($date, $end = false) |
|
| 127 | + { |
|
| 128 | + global $timedate; |
|
| 129 | + if($this->hasTime($date)) { |
|
| 130 | + return $date; |
|
| 131 | + } |
|
| 132 | 132 | |
| 133 | 133 | //C.L. Bug 48616 - If the $date is set to the Today macro, then adjust accordingly |
| 134 | 134 | if(strtolower($date) == 'today') |
| 135 | 135 | { |
| 136 | - $startEnd = $timedate->getDayStartEndGMT($timedate->getNow(true)); |
|
| 137 | - return $end ? $startEnd['end'] : $startEnd['start']; |
|
| 136 | + $startEnd = $timedate->getDayStartEndGMT($timedate->getNow(true)); |
|
| 137 | + return $end ? $startEnd['end'] : $startEnd['start']; |
|
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | $parsed = $timedate->fromDbDate($date); |
| 141 | 141 | $date = $timedate->tzUser(new SugarDateTime()); |
| 142 | 142 | $date->setDate($parsed->year, $parsed->month, $parsed->day); |
| 143 | 143 | |
| 144 | - if($end) { |
|
| 145 | - return $date->setTime(23, 59, 59); |
|
| 146 | - } else { |
|
| 147 | - return $date->setTime(0, 0, 0); |
|
| 148 | - } |
|
| 149 | - } |
|
| 144 | + if($end) { |
|
| 145 | + return $date->setTime(23, 59, 59); |
|
| 146 | + } else { |
|
| 147 | + return $date->setTime(0, 0, 0); |
|
| 148 | + } |
|
| 149 | + } |
|
| 150 | 150 | |
| 151 | - function queryFilterBefore($layout_def) |
|
| 152 | - { |
|
| 151 | + function queryFilterBefore($layout_def) |
|
| 152 | + { |
|
| 153 | 153 | $begin = $this->expandDate($layout_def['input_name0']); |
| 154 | 154 | return $this->queryDateOp($this->_get_column_select($layout_def), $begin, '<', "datetime"); |
| 155 | - } |
|
| 155 | + } |
|
| 156 | 156 | |
| 157 | - function queryFilterAfter($layout_def) |
|
| 158 | - { |
|
| 157 | + function queryFilterAfter($layout_def) |
|
| 158 | + { |
|
| 159 | 159 | $begin = $this->expandDate($layout_def['input_name0'], true); |
| 160 | 160 | return $this->queryDateOp($this->_get_column_select($layout_def), $begin, '>', "datetime"); |
| 161 | - } |
|
| 161 | + } |
|
| 162 | 162 | |
| 163 | - function queryFilterBetween_Dates($layout_def) |
|
| 164 | - { |
|
| 163 | + function queryFilterBetween_Dates($layout_def) |
|
| 164 | + { |
|
| 165 | 165 | $begin = $this->expandDate($layout_def['input_name0']); |
| 166 | - $end = $this->expandDate($layout_def['input_name1'], true); |
|
| 166 | + $end = $this->expandDate($layout_def['input_name1'], true); |
|
| 167 | 167 | $column = $this->_get_column_select($layout_def); |
| 168 | - return "(".$this->queryDateOp($column, $begin, ">=", "datetime")." AND ". |
|
| 168 | + return "(".$this->queryDateOp($column, $begin, ">=", "datetime")." AND ". |
|
| 169 | 169 | $this->queryDateOp($column, $end, "<=", "datetime").")\n"; |
| 170 | - } |
|
| 170 | + } |
|
| 171 | 171 | |
| 172 | - function queryFilterNot_Equals_str($layout_def) |
|
| 173 | - { |
|
| 174 | - global $timedate; |
|
| 172 | + function queryFilterNot_Equals_str($layout_def) |
|
| 173 | + { |
|
| 174 | + global $timedate; |
|
| 175 | 175 | |
| 176 | 176 | $column = $this->_get_column_select($layout_def); |
| 177 | 177 | $begin = $layout_def['input_name0']; |
| 178 | 178 | $hasTime = $this->hasTime($begin); |
| 179 | 179 | if(!$hasTime){ |
| 180 | - $end = $this->expandDate($begin, true); |
|
| 180 | + $end = $this->expandDate($begin, true); |
|
| 181 | 181 | $begin = $this->expandDate($begin); |
| 182 | 182 | $cond = $this->queryDateOp($column, $begin, "<", "datetime")." OR ". |
| 183 | 183 | $this->queryDateOp($column, $end, ">", "datetime"); |
@@ -185,45 +185,45 @@ discard block |
||
| 185 | 185 | $cond = $this->queryDateOp($column, $begin, "!=", "datetime"); |
| 186 | 186 | } |
| 187 | 187 | return "($column IS NULL OR $cond)"; |
| 188 | - } |
|
| 188 | + } |
|
| 189 | 189 | |
| 190 | 190 | /** |
| 191 | 191 | * Get assigned or logged in user's current date and time value. |
| 192 | 192 | * @param boolean $timestamp Format of return value, if set to true, return unix like timestamp , else a formatted date. |
| 193 | 193 | */ |
| 194 | - function get_users_current_date_time($timestamp=false) |
|
| 195 | - { |
|
| 196 | - global $current_user; |
|
| 194 | + function get_users_current_date_time($timestamp=false) |
|
| 195 | + { |
|
| 196 | + global $current_user; |
|
| 197 | 197 | global $timedate; |
| 198 | 198 | |
| 199 | 199 | $begin = TimeDate::getInstance()->nowDb(); |
| 200 | 200 | //kbrill bug #13884 |
| 201 | - //$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user); |
|
| 202 | - $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user); |
|
| 201 | + //$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user); |
|
| 202 | + $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user); |
|
| 203 | 203 | |
| 204 | 204 | if (!$timestamp) { |
| 205 | - return $begin; |
|
| 205 | + return $begin; |
|
| 206 | 206 | } else { |
| 207 | - $begin_parts = explode(' ', $begin); |
|
| 208 | - $date_parts=explode('-', $begin_parts[0]); |
|
| 209 | - $time_parts=explode(':', $begin_parts[1]); |
|
| 210 | - $curr_timestamp=mktime($time_parts[0],$time_parts[1],0,$date_parts[1], $date_parts[2],$date_parts[0]); |
|
| 211 | - return $curr_timestamp; |
|
| 212 | - } |
|
| 213 | - |
|
| 214 | - } |
|
| 215 | - /** |
|
| 216 | - * Get specified date and time for a particalur day, in current user's timezone. |
|
| 217 | - * @param int $days Adjust date by this number of days, negative values are valid. |
|
| 218 | - * @param time string falg for desired time value, start: minimum time, end: maximum time, default: current time |
|
| 219 | - */ |
|
| 220 | - function get_db_date($days,$time) { |
|
| 207 | + $begin_parts = explode(' ', $begin); |
|
| 208 | + $date_parts=explode('-', $begin_parts[0]); |
|
| 209 | + $time_parts=explode(':', $begin_parts[1]); |
|
| 210 | + $curr_timestamp=mktime($time_parts[0],$time_parts[1],0,$date_parts[1], $date_parts[2],$date_parts[0]); |
|
| 211 | + return $curr_timestamp; |
|
| 212 | + } |
|
| 213 | + |
|
| 214 | + } |
|
| 215 | + /** |
|
| 216 | + * Get specified date and time for a particalur day, in current user's timezone. |
|
| 217 | + * @param int $days Adjust date by this number of days, negative values are valid. |
|
| 218 | + * @param time string falg for desired time value, start: minimum time, end: maximum time, default: current time |
|
| 219 | + */ |
|
| 220 | + function get_db_date($days,$time) { |
|
| 221 | 221 | global $timedate; |
| 222 | 222 | |
| 223 | 223 | $begin = date($GLOBALS['timedate']->get_db_date_time_format(), time()+(86400 * $days)); //gmt date with day adjustment applied. |
| 224 | 224 | //kbrill bug #13884 |
| 225 | 225 | //$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user); |
| 226 | - $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user); |
|
| 226 | + $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user); |
|
| 227 | 227 | |
| 228 | 228 | if ($time=='start') { |
| 229 | 229 | $begin_parts = explode(' ', $begin); |
@@ -240,38 +240,38 @@ discard block |
||
| 240 | 240 | $begin = $timedate->handle_offset($be, $timedate->get_db_date_time_format(), false, $this->assigned_user); |
| 241 | 241 | |
| 242 | 242 | return $begin; |
| 243 | - } |
|
| 244 | - |
|
| 245 | - /** |
|
| 246 | - * Get filter string for a date field. |
|
| 247 | - * @param array layout_def field def for field being filtered |
|
| 248 | - * @param string $begin start date value (in DB format) |
|
| 249 | - * @param string $end End date value (in DB format) |
|
| 250 | - */ |
|
| 251 | - function get_start_end_date_filter(& $layout_def, $begin,$end) |
|
| 252 | - { |
|
| 253 | - if (isset ($layout_def['rel_field'])) { |
|
| 254 | - $field_name = $this->reporter->db->convert( |
|
| 255 | - $this->reporter->db->convert($this->_get_column_select($layout_def), 'date_format', '%Y-%m-%d'), |
|
| 256 | - "CONCAT", |
|
| 257 | - array("' '", $this->reporter->db->convert($layout_def['rel_field'], 'time_format')) |
|
| 258 | - ); |
|
| 259 | - } else { |
|
| 260 | - $field_name = $this->_get_column_select($layout_def); |
|
| 261 | - } |
|
| 262 | - return $field_name.">=".$this->reporter->db->quoted($begin)." AND ".$field_name."<=".$this->reporter->db->quoted($end)."\n"; |
|
| 263 | - } |
|
| 264 | - |
|
| 265 | - /** |
|
| 266 | - * Create query for binary operation of field of certain type |
|
| 267 | - * Produces query like: |
|
| 268 | - * arg1 op to_date(arg2), e.g.: |
|
| 269 | - * date_closed < '2009-12-01' |
|
| 270 | - * @param string $arg1 1st arg - column name |
|
| 271 | - * @param string|DateTime $arg2 2nd arg - value to be converted |
|
| 272 | - * @param string $op |
|
| 273 | - * @param string $type |
|
| 274 | - */ |
|
| 243 | + } |
|
| 244 | + |
|
| 245 | + /** |
|
| 246 | + * Get filter string for a date field. |
|
| 247 | + * @param array layout_def field def for field being filtered |
|
| 248 | + * @param string $begin start date value (in DB format) |
|
| 249 | + * @param string $end End date value (in DB format) |
|
| 250 | + */ |
|
| 251 | + function get_start_end_date_filter(& $layout_def, $begin,$end) |
|
| 252 | + { |
|
| 253 | + if (isset ($layout_def['rel_field'])) { |
|
| 254 | + $field_name = $this->reporter->db->convert( |
|
| 255 | + $this->reporter->db->convert($this->_get_column_select($layout_def), 'date_format', '%Y-%m-%d'), |
|
| 256 | + "CONCAT", |
|
| 257 | + array("' '", $this->reporter->db->convert($layout_def['rel_field'], 'time_format')) |
|
| 258 | + ); |
|
| 259 | + } else { |
|
| 260 | + $field_name = $this->_get_column_select($layout_def); |
|
| 261 | + } |
|
| 262 | + return $field_name.">=".$this->reporter->db->quoted($begin)." AND ".$field_name."<=".$this->reporter->db->quoted($end)."\n"; |
|
| 263 | + } |
|
| 264 | + |
|
| 265 | + /** |
|
| 266 | + * Create query for binary operation of field of certain type |
|
| 267 | + * Produces query like: |
|
| 268 | + * arg1 op to_date(arg2), e.g.: |
|
| 269 | + * date_closed < '2009-12-01' |
|
| 270 | + * @param string $arg1 1st arg - column name |
|
| 271 | + * @param string|DateTime $arg2 2nd arg - value to be converted |
|
| 272 | + * @param string $op |
|
| 273 | + * @param string $type |
|
| 274 | + */ |
|
| 275 | 275 | protected function queryDateOp($arg1, $arg2, $op, $type) |
| 276 | 276 | { |
| 277 | 277 | global $timedate; |
@@ -291,7 +291,7 @@ discard block |
||
| 291 | 291 | return $timedate->tzUser($timedate->getNow(), $this->getAssignedUser()); |
| 292 | 292 | } |
| 293 | 293 | |
| 294 | - /** |
|
| 294 | + /** |
|
| 295 | 295 | * Create query from the beginning to the end of certain day |
| 296 | 296 | * @param array $layout_def |
| 297 | 297 | * @param SugarDateTime $day |
@@ -303,43 +303,43 @@ discard block |
||
| 303 | 303 | return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
| 304 | 304 | } |
| 305 | 305 | |
| 306 | - function queryFilterTP_yesterday($layout_def) |
|
| 307 | - { |
|
| 308 | - global $timedate; |
|
| 309 | - return $this->queryDay($layout_def, $this->now()->get("-1 day")); |
|
| 310 | - } |
|
| 306 | + function queryFilterTP_yesterday($layout_def) |
|
| 307 | + { |
|
| 308 | + global $timedate; |
|
| 309 | + return $this->queryDay($layout_def, $this->now()->get("-1 day")); |
|
| 310 | + } |
|
| 311 | 311 | |
| 312 | - function queryFilterTP_today($layout_def) |
|
| 313 | - { |
|
| 314 | - global $timedate; |
|
| 315 | - return $this->queryDay($layout_def, $this->now()); |
|
| 316 | - } |
|
| 312 | + function queryFilterTP_today($layout_def) |
|
| 313 | + { |
|
| 314 | + global $timedate; |
|
| 315 | + return $this->queryDay($layout_def, $this->now()); |
|
| 316 | + } |
|
| 317 | 317 | |
| 318 | - function queryFilterTP_tomorrow(& $layout_def) |
|
| 319 | - { |
|
| 320 | - global $timedate; |
|
| 321 | - return $this->queryDay($layout_def, $this->now()->get("+1 day")); |
|
| 322 | - } |
|
| 318 | + function queryFilterTP_tomorrow(& $layout_def) |
|
| 319 | + { |
|
| 320 | + global $timedate; |
|
| 321 | + return $this->queryDay($layout_def, $this->now()->get("+1 day")); |
|
| 322 | + } |
|
| 323 | 323 | |
| 324 | - function queryFilterTP_last_7_days($layout_def) |
|
| 325 | - { |
|
| 326 | - global $timedate; |
|
| 324 | + function queryFilterTP_last_7_days($layout_def) |
|
| 325 | + { |
|
| 326 | + global $timedate; |
|
| 327 | 327 | |
| 328 | - $begin = $this->now()->get("-6 days")->get_day_begin(); |
|
| 329 | - $end = $this->now()->get_day_end(); |
|
| 328 | + $begin = $this->now()->get("-6 days")->get_day_begin(); |
|
| 329 | + $end = $this->now()->get_day_end(); |
|
| 330 | 330 | |
| 331 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 332 | - } |
|
| 331 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 332 | + } |
|
| 333 | 333 | |
| 334 | - function queryFilterTP_next_7_days($layout_def) |
|
| 335 | - { |
|
| 336 | - global $timedate; |
|
| 334 | + function queryFilterTP_next_7_days($layout_def) |
|
| 335 | + { |
|
| 336 | + global $timedate; |
|
| 337 | 337 | |
| 338 | - $begin = $this->now()->get_day_begin(); |
|
| 339 | - $end = $this->now()->get("+6 days")->get_day_end(); |
|
| 338 | + $begin = $this->now()->get_day_begin(); |
|
| 339 | + $end = $this->now()->get("+6 days")->get_day_end(); |
|
| 340 | 340 | |
| 341 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 342 | - } |
|
| 341 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 342 | + } |
|
| 343 | 343 | |
| 344 | 344 | /** |
| 345 | 345 | * Create query from the beginning to the end of certain month |
@@ -350,20 +350,20 @@ discard block |
||
| 350 | 350 | { |
| 351 | 351 | $begin = $month->setTime(0, 0, 0); |
| 352 | 352 | $end = clone($begin); |
| 353 | - $end->setDate($begin->year, $begin->month, $begin->days_in_month)->setTime(23, 59, 59); |
|
| 353 | + $end->setDate($begin->year, $begin->month, $begin->days_in_month)->setTime(23, 59, 59); |
|
| 354 | 354 | return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
| 355 | 355 | } |
| 356 | 356 | |
| 357 | 357 | function queryFilterTP_last_month($layout_def) |
| 358 | - { |
|
| 359 | - global $timedate; |
|
| 360 | - $month = $this->now(); |
|
| 361 | - return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month-1, 1)); |
|
| 362 | - } |
|
| 358 | + { |
|
| 359 | + global $timedate; |
|
| 360 | + $month = $this->now(); |
|
| 361 | + return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month-1, 1)); |
|
| 362 | + } |
|
| 363 | 363 | |
| 364 | - function queryFilterTP_this_month($layout_def) |
|
| 365 | - { |
|
| 366 | - global $timedate; |
|
| 364 | + function queryFilterTP_this_month($layout_def) |
|
| 365 | + { |
|
| 366 | + global $timedate; |
|
| 367 | 367 | |
| 368 | 368 | //Bug 62414 - take timezone into account when determining current month |
| 369 | 369 | $now = $this->now(); |
@@ -372,30 +372,30 @@ discard block |
||
| 372 | 372 | $now->modify($timezoneOffset); |
| 373 | 373 | |
| 374 | 374 | return $this->queryMonth($layout_def, $now->get_day_by_index_this_month(0)); |
| 375 | - } |
|
| 376 | - |
|
| 377 | - function queryFilterTP_next_month($layout_def) |
|
| 378 | - { |
|
| 379 | - global $timedate; |
|
| 380 | - $month = $this->now(); |
|
| 381 | - return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month+1, 1)); |
|
| 382 | - } |
|
| 383 | - |
|
| 384 | - function queryFilterTP_last_30_days($layout_def) |
|
| 385 | - { |
|
| 386 | - global $timedate; |
|
| 387 | - $begin = $this->now()->get("-29 days")->get_day_begin(); |
|
| 388 | - $end = $this->now()->get_day_end(); |
|
| 389 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 390 | - } |
|
| 391 | - |
|
| 392 | - function queryFilterTP_next_30_days($layout_def) |
|
| 393 | - { |
|
| 394 | - global $timedate; |
|
| 395 | - $begin = $this->now()->get_day_begin(); |
|
| 396 | - $end = $this->now()->get("+29 days")->get_day_end(); |
|
| 397 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 398 | - } |
|
| 375 | + } |
|
| 376 | + |
|
| 377 | + function queryFilterTP_next_month($layout_def) |
|
| 378 | + { |
|
| 379 | + global $timedate; |
|
| 380 | + $month = $this->now(); |
|
| 381 | + return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month+1, 1)); |
|
| 382 | + } |
|
| 383 | + |
|
| 384 | + function queryFilterTP_last_30_days($layout_def) |
|
| 385 | + { |
|
| 386 | + global $timedate; |
|
| 387 | + $begin = $this->now()->get("-29 days")->get_day_begin(); |
|
| 388 | + $end = $this->now()->get_day_end(); |
|
| 389 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 390 | + } |
|
| 391 | + |
|
| 392 | + function queryFilterTP_next_30_days($layout_def) |
|
| 393 | + { |
|
| 394 | + global $timedate; |
|
| 395 | + $begin = $this->now()->get_day_begin(); |
|
| 396 | + $end = $this->now()->get("+29 days")->get_day_end(); |
|
| 397 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 398 | + } |
|
| 399 | 399 | |
| 400 | 400 | /** |
| 401 | 401 | * Return the between WHERE query for Quarter filter |
@@ -468,59 +468,59 @@ discard block |
||
| 468 | 468 | return $this->getQuarterFilter($layout_def, '+3 month'); |
| 469 | 469 | } |
| 470 | 470 | |
| 471 | - function queryFilterTP_last_year($layout_def) |
|
| 472 | - { |
|
| 473 | - global $timedate; |
|
| 474 | - $begin = $this->now(); |
|
| 475 | - $begin->setDate($begin->year-1, 1, 1)->setTime(0, 0); |
|
| 476 | - $end = clone $begin; |
|
| 477 | - $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
|
| 478 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 479 | - } |
|
| 480 | - |
|
| 481 | - function queryFilterTP_this_year($layout_def) |
|
| 482 | - { |
|
| 483 | - global $timedate; |
|
| 484 | - $begin = $this->now(); |
|
| 485 | - $begin->setDate($begin->year, 1, 1)->setTime(0, 0); |
|
| 486 | - $end = clone $begin; |
|
| 487 | - $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
|
| 488 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 489 | - } |
|
| 490 | - |
|
| 491 | - function queryFilterTP_next_year(& $layout_def) |
|
| 492 | - { |
|
| 493 | - global $timedate; |
|
| 494 | - $begin = $this->now(); |
|
| 495 | - $begin->setDate($begin->year+1, 1, 1)->setTime(0, 0); |
|
| 496 | - $end = clone $begin; |
|
| 497 | - $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
|
| 498 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 499 | - } |
|
| 500 | - |
|
| 501 | - function queryGroupBy($layout_def) |
|
| 502 | - { |
|
| 503 | - // i guess qualifier and column_function are the same.. |
|
| 504 | - if (!empty ($layout_def['qualifier'])) { |
|
| 505 | - $func_name = 'queryGroupBy'.$layout_def['qualifier']; |
|
| 506 | - if (method_exists($this, $func_name)) { |
|
| 507 | - return $this-> $func_name ($layout_def)." \n"; |
|
| 508 | - } |
|
| 509 | - } |
|
| 510 | - return parent :: queryGroupBy($layout_def)." \n"; |
|
| 511 | - } |
|
| 512 | - |
|
| 513 | - function queryOrderBy($layout_def) |
|
| 514 | - { |
|
| 471 | + function queryFilterTP_last_year($layout_def) |
|
| 472 | + { |
|
| 473 | + global $timedate; |
|
| 474 | + $begin = $this->now(); |
|
| 475 | + $begin->setDate($begin->year-1, 1, 1)->setTime(0, 0); |
|
| 476 | + $end = clone $begin; |
|
| 477 | + $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
|
| 478 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 479 | + } |
|
| 480 | + |
|
| 481 | + function queryFilterTP_this_year($layout_def) |
|
| 482 | + { |
|
| 483 | + global $timedate; |
|
| 484 | + $begin = $this->now(); |
|
| 485 | + $begin->setDate($begin->year, 1, 1)->setTime(0, 0); |
|
| 486 | + $end = clone $begin; |
|
| 487 | + $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
|
| 488 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 489 | + } |
|
| 490 | + |
|
| 491 | + function queryFilterTP_next_year(& $layout_def) |
|
| 492 | + { |
|
| 493 | + global $timedate; |
|
| 494 | + $begin = $this->now(); |
|
| 495 | + $begin->setDate($begin->year+1, 1, 1)->setTime(0, 0); |
|
| 496 | + $end = clone $begin; |
|
| 497 | + $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
|
| 498 | + return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 499 | + } |
|
| 500 | + |
|
| 501 | + function queryGroupBy($layout_def) |
|
| 502 | + { |
|
| 503 | + // i guess qualifier and column_function are the same.. |
|
| 504 | + if (!empty ($layout_def['qualifier'])) { |
|
| 505 | + $func_name = 'queryGroupBy'.$layout_def['qualifier']; |
|
| 506 | + if (method_exists($this, $func_name)) { |
|
| 507 | + return $this-> $func_name ($layout_def)." \n"; |
|
| 508 | + } |
|
| 509 | + } |
|
| 510 | + return parent :: queryGroupBy($layout_def)." \n"; |
|
| 511 | + } |
|
| 512 | + |
|
| 513 | + function queryOrderBy($layout_def) |
|
| 514 | + { |
|
| 515 | 515 | if (!empty ($layout_def['qualifier'])) { |
| 516 | - $func_name ='queryOrderBy'.$layout_def['qualifier']; |
|
| 517 | - if (method_exists($this, $func_name)) { |
|
| 518 | - return $this-> $func_name ($layout_def)."\n"; |
|
| 519 | - } |
|
| 520 | - } |
|
| 521 | - $order_by = parent :: queryOrderBy($layout_def)."\n"; |
|
| 522 | - return $order_by; |
|
| 523 | - } |
|
| 516 | + $func_name ='queryOrderBy'.$layout_def['qualifier']; |
|
| 517 | + if (method_exists($this, $func_name)) { |
|
| 518 | + return $this-> $func_name ($layout_def)."\n"; |
|
| 519 | + } |
|
| 520 | + } |
|
| 521 | + $order_by = parent :: queryOrderBy($layout_def)."\n"; |
|
| 522 | + return $order_by; |
|
| 523 | + } |
|
| 524 | 524 | |
| 525 | 525 | function displayListPlain($layout_def) { |
| 526 | 526 | global $timedate; |
@@ -566,39 +566,39 @@ discard block |
||
| 566 | 566 | return $timedate->to_display_date_time($content); |
| 567 | 567 | } |
| 568 | 568 | |
| 569 | - function querySelect(& $layout_def) { |
|
| 570 | - // i guess qualifier and column_function are the same.. |
|
| 571 | - if (!empty ($layout_def['column_function'])) { |
|
| 572 | - $func_name = 'querySelect'.$layout_def['column_function']; |
|
| 573 | - if (method_exists($this, $func_name)) { |
|
| 574 | - return $this-> $func_name ($layout_def)." \n"; |
|
| 575 | - } |
|
| 576 | - } |
|
| 577 | - return parent :: querySelect($layout_def)." \n"; |
|
| 578 | - } |
|
| 579 | - function & displayListday(& $layout_def) { |
|
| 569 | + function querySelect(& $layout_def) { |
|
| 570 | + // i guess qualifier and column_function are the same.. |
|
| 571 | + if (!empty ($layout_def['column_function'])) { |
|
| 572 | + $func_name = 'querySelect'.$layout_def['column_function']; |
|
| 573 | + if (method_exists($this, $func_name)) { |
|
| 574 | + return $this-> $func_name ($layout_def)." \n"; |
|
| 575 | + } |
|
| 576 | + } |
|
| 577 | + return parent :: querySelect($layout_def)." \n"; |
|
| 578 | + } |
|
| 579 | + function & displayListday(& $layout_def) { |
|
| 580 | + $value = parent:: displayListPlain($layout_def); |
|
| 581 | + return $value; |
|
| 582 | + } |
|
| 583 | + |
|
| 584 | + function & displayListyear(& $layout_def) { |
|
| 585 | + global $app_list_strings; |
|
| 580 | 586 | $value = parent:: displayListPlain($layout_def); |
| 581 | 587 | return $value; |
| 582 | - } |
|
| 583 | - |
|
| 584 | - function & displayListyear(& $layout_def) { |
|
| 585 | - global $app_list_strings; |
|
| 586 | - $value = parent:: displayListPlain($layout_def); |
|
| 587 | - return $value; |
|
| 588 | - } |
|
| 589 | - |
|
| 590 | - function displayListmonth($layout_def) |
|
| 591 | - { |
|
| 592 | - global $app_list_strings; |
|
| 593 | - $display = ''; |
|
| 594 | - $match = array(); |
|
| 588 | + } |
|
| 589 | + |
|
| 590 | + function displayListmonth($layout_def) |
|
| 591 | + { |
|
| 592 | + global $app_list_strings; |
|
| 593 | + $display = ''; |
|
| 594 | + $match = array(); |
|
| 595 | 595 | if (preg_match('/(\d{4})-(\d\d)/', $this->displayListPlain($layout_def), $match)) { |
| 596 | - $match[2] = preg_replace('/^0/', '', $match[2]); |
|
| 597 | - $display = $app_list_strings['dom_cal_month_long'][$match[2]]." {$match[1]}"; |
|
| 598 | - } |
|
| 599 | - return $display; |
|
| 596 | + $match[2] = preg_replace('/^0/', '', $match[2]); |
|
| 597 | + $display = $app_list_strings['dom_cal_month_long'][$match[2]]." {$match[1]}"; |
|
| 598 | + } |
|
| 599 | + return $display; |
|
| 600 | 600 | |
| 601 | - } |
|
| 601 | + } |
|
| 602 | 602 | |
| 603 | 603 | /** |
| 604 | 604 | * Returns part of query for select |
@@ -721,32 +721,32 @@ discard block |
||
| 721 | 721 | return $this->reporter->db->convert($return, "date_format", array('%Y')) . "\n"; |
| 722 | 722 | } |
| 723 | 723 | |
| 724 | - function querySelectquarter($layout_def) |
|
| 725 | - { |
|
| 726 | - $column = $this->_get_column_select($layout_def); |
|
| 727 | - return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')), |
|
| 728 | - 'CONCAT', |
|
| 729 | - array("'-'", $this->reporter->db->convert($column, "quarter"))) |
|
| 730 | - ." ".$this->_get_column_alias($layout_def)."\n"; |
|
| 731 | - } |
|
| 724 | + function querySelectquarter($layout_def) |
|
| 725 | + { |
|
| 726 | + $column = $this->_get_column_select($layout_def); |
|
| 727 | + return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')), |
|
| 728 | + 'CONCAT', |
|
| 729 | + array("'-'", $this->reporter->db->convert($column, "quarter"))) |
|
| 730 | + ." ".$this->_get_column_alias($layout_def)."\n"; |
|
| 731 | + } |
|
| 732 | 732 | |
| 733 | - function displayListquarter(& $layout_def) { |
|
| 734 | - $match = array(); |
|
| 733 | + function displayListquarter(& $layout_def) { |
|
| 734 | + $match = array(); |
|
| 735 | 735 | if (preg_match('/(\d{4})-(\d)/', $this->displayListPlain($layout_def), $match)) { |
| 736 | - return "Q".$match[2]." ".$match[1]; |
|
| 737 | - } |
|
| 738 | - return ''; |
|
| 736 | + return "Q".$match[2]." ".$match[1]; |
|
| 737 | + } |
|
| 738 | + return ''; |
|
| 739 | 739 | |
| 740 | - } |
|
| 740 | + } |
|
| 741 | 741 | |
| 742 | - function queryGroupByQuarter($layout_def) |
|
| 743 | - { |
|
| 744 | - $this->getReporter(); |
|
| 742 | + function queryGroupByQuarter($layout_def) |
|
| 743 | + { |
|
| 744 | + $this->getReporter(); |
|
| 745 | 745 | $column = $this->_get_column_select($layout_def); |
| 746 | - return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')), |
|
| 747 | - 'CONCAT', |
|
| 748 | - array("'-'", $this->reporter->db->convert($column, "quarter"))); |
|
| 749 | - } |
|
| 746 | + return $this->reporter->db->convert($this->reporter->db->convert($column, "date_format", array('%Y')), |
|
| 747 | + 'CONCAT', |
|
| 748 | + array("'-'", $this->reporter->db->convert($column, "quarter"))); |
|
| 749 | + } |
|
| 750 | 750 | |
| 751 | 751 | /** |
| 752 | 752 | * For oracle we have to return order by string like group by string instead of return field alias |
@@ -775,23 +775,23 @@ discard block |
||
| 775 | 775 | } |
| 776 | 776 | |
| 777 | 777 | function displayInput(&$layout_def) { |
| 778 | - global $timedate, $current_language, $app_strings; |
|
| 778 | + global $timedate, $current_language, $app_strings; |
|
| 779 | 779 | $home_mod_strings = return_module_language($current_language, 'Home'); |
| 780 | 780 | $filterTypes = array(' ' => $app_strings['LBL_NONE'], |
| 781 | - 'TP_today' => $home_mod_strings['LBL_TODAY'], |
|
| 782 | - 'TP_yesterday' => $home_mod_strings['LBL_YESTERDAY'], |
|
| 783 | - 'TP_tomorrow' => $home_mod_strings['LBL_TOMORROW'], |
|
| 784 | - 'TP_this_month' => $home_mod_strings['LBL_THIS_MONTH'], |
|
| 785 | - 'TP_this_year' => $home_mod_strings['LBL_THIS_YEAR'], |
|
| 786 | - 'TP_last_30_days' => $home_mod_strings['LBL_LAST_30_DAYS'], |
|
| 787 | - 'TP_last_7_days' => $home_mod_strings['LBL_LAST_7_DAYS'], |
|
| 788 | - 'TP_last_month' => $home_mod_strings['LBL_LAST_MONTH'], |
|
| 789 | - 'TP_last_year' => $home_mod_strings['LBL_LAST_YEAR'], |
|
| 790 | - 'TP_next_30_days' => $home_mod_strings['LBL_NEXT_30_DAYS'], |
|
| 791 | - 'TP_next_7_days' => $home_mod_strings['LBL_NEXT_7_DAYS'], |
|
| 792 | - 'TP_next_month' => $home_mod_strings['LBL_NEXT_MONTH'], |
|
| 793 | - 'TP_next_year' => $home_mod_strings['LBL_NEXT_YEAR'], |
|
| 794 | - ); |
|
| 781 | + 'TP_today' => $home_mod_strings['LBL_TODAY'], |
|
| 782 | + 'TP_yesterday' => $home_mod_strings['LBL_YESTERDAY'], |
|
| 783 | + 'TP_tomorrow' => $home_mod_strings['LBL_TOMORROW'], |
|
| 784 | + 'TP_this_month' => $home_mod_strings['LBL_THIS_MONTH'], |
|
| 785 | + 'TP_this_year' => $home_mod_strings['LBL_THIS_YEAR'], |
|
| 786 | + 'TP_last_30_days' => $home_mod_strings['LBL_LAST_30_DAYS'], |
|
| 787 | + 'TP_last_7_days' => $home_mod_strings['LBL_LAST_7_DAYS'], |
|
| 788 | + 'TP_last_month' => $home_mod_strings['LBL_LAST_MONTH'], |
|
| 789 | + 'TP_last_year' => $home_mod_strings['LBL_LAST_YEAR'], |
|
| 790 | + 'TP_next_30_days' => $home_mod_strings['LBL_NEXT_30_DAYS'], |
|
| 791 | + 'TP_next_7_days' => $home_mod_strings['LBL_NEXT_7_DAYS'], |
|
| 792 | + 'TP_next_month' => $home_mod_strings['LBL_NEXT_MONTH'], |
|
| 793 | + 'TP_next_year' => $home_mod_strings['LBL_NEXT_YEAR'], |
|
| 794 | + ); |
|
| 795 | 795 | |
| 796 | 796 | $cal_dateformat = $timedate->get_cal_date_format(); |
| 797 | 797 | $str = "<select name='type_{$layout_def['name']}'>"; |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | class SugarWidgetFieldDateTime extends SugarWidgetReportField |
| 45 | 45 | { |
| 46 | 46 | var $reporter; |
| 47 | - var $assigned_user=null; |
|
| 47 | + var $assigned_user = null; |
|
| 48 | 48 | |
| 49 | 49 | function __construct($layout_manager) |
| 50 | 50 | { |
@@ -54,9 +54,9 @@ discard block |
||
| 54 | 54 | /** |
| 55 | 55 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 56 | 56 | */ |
| 57 | - function SugarWidgetFieldDateTime($layout_manager){ |
|
| 57 | + function SugarWidgetFieldDateTime($layout_manager) { |
|
| 58 | 58 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 59 | - if(isset($GLOBALS['log'])) { |
|
| 59 | + if (isset($GLOBALS['log'])) { |
|
| 60 | 60 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 61 | 61 | } |
| 62 | 62 | else { |
@@ -81,7 +81,7 @@ discard block |
||
| 81 | 81 | |
| 82 | 82 | $report_def_str = $json_obj->decode($this->reporter->report_def_str); |
| 83 | 83 | |
| 84 | - if(empty($report_def_str['assigned_user_id'])) return null; |
|
| 84 | + if (empty($report_def_str['assigned_user_id'])) return null; |
|
| 85 | 85 | |
| 86 | 86 | $this->assigned_user = new User(); |
| 87 | 87 | $this->assigned_user->retrieve($report_def_str['assigned_user_id']); |
@@ -126,12 +126,12 @@ discard block |
||
| 126 | 126 | protected function expandDate($date, $end = false) |
| 127 | 127 | { |
| 128 | 128 | global $timedate; |
| 129 | - if($this->hasTime($date)) { |
|
| 129 | + if ($this->hasTime($date)) { |
|
| 130 | 130 | return $date; |
| 131 | 131 | } |
| 132 | 132 | |
| 133 | 133 | //C.L. Bug 48616 - If the $date is set to the Today macro, then adjust accordingly |
| 134 | - if(strtolower($date) == 'today') |
|
| 134 | + if (strtolower($date) == 'today') |
|
| 135 | 135 | { |
| 136 | 136 | $startEnd = $timedate->getDayStartEndGMT($timedate->getNow(true)); |
| 137 | 137 | return $end ? $startEnd['end'] : $startEnd['start']; |
@@ -141,7 +141,7 @@ discard block |
||
| 141 | 141 | $date = $timedate->tzUser(new SugarDateTime()); |
| 142 | 142 | $date->setDate($parsed->year, $parsed->month, $parsed->day); |
| 143 | 143 | |
| 144 | - if($end) { |
|
| 144 | + if ($end) { |
|
| 145 | 145 | return $date->setTime(23, 59, 59); |
| 146 | 146 | } else { |
| 147 | 147 | return $date->setTime(0, 0, 0); |
@@ -176,13 +176,13 @@ discard block |
||
| 176 | 176 | $column = $this->_get_column_select($layout_def); |
| 177 | 177 | $begin = $layout_def['input_name0']; |
| 178 | 178 | $hasTime = $this->hasTime($begin); |
| 179 | - if(!$hasTime){ |
|
| 179 | + if (!$hasTime) { |
|
| 180 | 180 | $end = $this->expandDate($begin, true); |
| 181 | 181 | $begin = $this->expandDate($begin); |
| 182 | 182 | $cond = $this->queryDateOp($column, $begin, "<", "datetime")." OR ". |
| 183 | 183 | $this->queryDateOp($column, $end, ">", "datetime"); |
| 184 | 184 | } else { |
| 185 | - $cond = $this->queryDateOp($column, $begin, "!=", "datetime"); |
|
| 185 | + $cond = $this->queryDateOp($column, $begin, "!=", "datetime"); |
|
| 186 | 186 | } |
| 187 | 187 | return "($column IS NULL OR $cond)"; |
| 188 | 188 | } |
@@ -191,7 +191,7 @@ discard block |
||
| 191 | 191 | * Get assigned or logged in user's current date and time value. |
| 192 | 192 | * @param boolean $timestamp Format of return value, if set to true, return unix like timestamp , else a formatted date. |
| 193 | 193 | */ |
| 194 | - function get_users_current_date_time($timestamp=false) |
|
| 194 | + function get_users_current_date_time($timestamp = false) |
|
| 195 | 195 | { |
| 196 | 196 | global $current_user; |
| 197 | 197 | global $timedate; |
@@ -205,9 +205,9 @@ discard block |
||
| 205 | 205 | return $begin; |
| 206 | 206 | } else { |
| 207 | 207 | $begin_parts = explode(' ', $begin); |
| 208 | - $date_parts=explode('-', $begin_parts[0]); |
|
| 209 | - $time_parts=explode(':', $begin_parts[1]); |
|
| 210 | - $curr_timestamp=mktime($time_parts[0],$time_parts[1],0,$date_parts[1], $date_parts[2],$date_parts[0]); |
|
| 208 | + $date_parts = explode('-', $begin_parts[0]); |
|
| 209 | + $time_parts = explode(':', $begin_parts[1]); |
|
| 210 | + $curr_timestamp = mktime($time_parts[0], $time_parts[1], 0, $date_parts[1], $date_parts[2], $date_parts[0]); |
|
| 211 | 211 | return $curr_timestamp; |
| 212 | 212 | } |
| 213 | 213 | |
@@ -217,23 +217,23 @@ discard block |
||
| 217 | 217 | * @param int $days Adjust date by this number of days, negative values are valid. |
| 218 | 218 | * @param time string falg for desired time value, start: minimum time, end: maximum time, default: current time |
| 219 | 219 | */ |
| 220 | - function get_db_date($days,$time) { |
|
| 220 | + function get_db_date($days, $time) { |
|
| 221 | 221 | global $timedate; |
| 222 | 222 | |
| 223 | - $begin = date($GLOBALS['timedate']->get_db_date_time_format(), time()+(86400 * $days)); //gmt date with day adjustment applied. |
|
| 223 | + $begin = date($GLOBALS['timedate']->get_db_date_time_format(), time() + (86400 * $days)); //gmt date with day adjustment applied. |
|
| 224 | 224 | //kbrill bug #13884 |
| 225 | 225 | //$begin = $timedate->to_display_date_time($begin,true,true,$this->assigned_user); |
| 226 | 226 | $begin = $timedate->handle_offset($begin, $timedate->get_db_date_time_format(), false, $this->assigned_user); |
| 227 | 227 | |
| 228 | - if ($time=='start') { |
|
| 228 | + if ($time == 'start') { |
|
| 229 | 229 | $begin_parts = explode(' ', $begin); |
| 230 | - $be = $begin_parts[0] . ' 00:00:00'; |
|
| 230 | + $be = $begin_parts[0].' 00:00:00'; |
|
| 231 | 231 | } |
| 232 | - else if ($time=='end') { |
|
| 232 | + else if ($time == 'end') { |
|
| 233 | 233 | $begin_parts = explode(' ', $begin); |
| 234 | - $be = $begin_parts[0] . ' 23:59:59'; |
|
| 234 | + $be = $begin_parts[0].' 23:59:59'; |
|
| 235 | 235 | } else { |
| 236 | - $be=$begin; |
|
| 236 | + $be = $begin; |
|
| 237 | 237 | } |
| 238 | 238 | |
| 239 | 239 | //convert date to db format without converting to GMT. |
@@ -248,7 +248,7 @@ discard block |
||
| 248 | 248 | * @param string $begin start date value (in DB format) |
| 249 | 249 | * @param string $end End date value (in DB format) |
| 250 | 250 | */ |
| 251 | - function get_start_end_date_filter(& $layout_def, $begin,$end) |
|
| 251 | + function get_start_end_date_filter(& $layout_def, $begin, $end) |
|
| 252 | 252 | { |
| 253 | 253 | if (isset ($layout_def['rel_field'])) { |
| 254 | 254 | $field_name = $this->reporter->db->convert( |
@@ -275,7 +275,7 @@ discard block |
||
| 275 | 275 | protected function queryDateOp($arg1, $arg2, $op, $type) |
| 276 | 276 | { |
| 277 | 277 | global $timedate; |
| 278 | - if($arg2 instanceof DateTime) { |
|
| 278 | + if ($arg2 instanceof DateTime) { |
|
| 279 | 279 | $arg2 = $timedate->asDbType($arg2, $type); |
| 280 | 280 | } |
| 281 | 281 | return "$arg1 $op ".$this->reporter->db->convert($this->reporter->db->quoted($arg2), $type)."\n"; |
@@ -300,7 +300,7 @@ discard block |
||
| 300 | 300 | { |
| 301 | 301 | $begin = $day->get_day_begin(); |
| 302 | 302 | $end = $day->get_day_end(); |
| 303 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 303 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 304 | 304 | } |
| 305 | 305 | |
| 306 | 306 | function queryFilterTP_yesterday($layout_def) |
@@ -328,7 +328,7 @@ discard block |
||
| 328 | 328 | $begin = $this->now()->get("-6 days")->get_day_begin(); |
| 329 | 329 | $end = $this->now()->get_day_end(); |
| 330 | 330 | |
| 331 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 331 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 332 | 332 | } |
| 333 | 333 | |
| 334 | 334 | function queryFilterTP_next_7_days($layout_def) |
@@ -338,7 +338,7 @@ discard block |
||
| 338 | 338 | $begin = $this->now()->get_day_begin(); |
| 339 | 339 | $end = $this->now()->get("+6 days")->get_day_end(); |
| 340 | 340 | |
| 341 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 341 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 342 | 342 | } |
| 343 | 343 | |
| 344 | 344 | /** |
@@ -351,14 +351,14 @@ discard block |
||
| 351 | 351 | $begin = $month->setTime(0, 0, 0); |
| 352 | 352 | $end = clone($begin); |
| 353 | 353 | $end->setDate($begin->year, $begin->month, $begin->days_in_month)->setTime(23, 59, 59); |
| 354 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 354 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 355 | 355 | } |
| 356 | 356 | |
| 357 | 357 | function queryFilterTP_last_month($layout_def) |
| 358 | 358 | { |
| 359 | 359 | global $timedate; |
| 360 | 360 | $month = $this->now(); |
| 361 | - return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month-1, 1)); |
|
| 361 | + return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month - 1, 1)); |
|
| 362 | 362 | } |
| 363 | 363 | |
| 364 | 364 | function queryFilterTP_this_month($layout_def) |
@@ -378,7 +378,7 @@ discard block |
||
| 378 | 378 | { |
| 379 | 379 | global $timedate; |
| 380 | 380 | $month = $this->now(); |
| 381 | - return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month+1, 1)); |
|
| 381 | + return $this->queryMonth($layout_def, $month->setDate($month->year, $month->month + 1, 1)); |
|
| 382 | 382 | } |
| 383 | 383 | |
| 384 | 384 | function queryFilterTP_last_30_days($layout_def) |
@@ -386,7 +386,7 @@ discard block |
||
| 386 | 386 | global $timedate; |
| 387 | 387 | $begin = $this->now()->get("-29 days")->get_day_begin(); |
| 388 | 388 | $end = $this->now()->get_day_end(); |
| 389 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 389 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 390 | 390 | } |
| 391 | 391 | |
| 392 | 392 | function queryFilterTP_next_30_days($layout_def) |
@@ -394,7 +394,7 @@ discard block |
||
| 394 | 394 | global $timedate; |
| 395 | 395 | $begin = $this->now()->get_day_begin(); |
| 396 | 396 | $end = $this->now()->get("+29 days")->get_day_end(); |
| 397 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 397 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 398 | 398 | } |
| 399 | 399 | |
| 400 | 400 | /** |
@@ -472,10 +472,10 @@ discard block |
||
| 472 | 472 | { |
| 473 | 473 | global $timedate; |
| 474 | 474 | $begin = $this->now(); |
| 475 | - $begin->setDate($begin->year-1, 1, 1)->setTime(0, 0); |
|
| 475 | + $begin->setDate($begin->year - 1, 1, 1)->setTime(0, 0); |
|
| 476 | 476 | $end = clone $begin; |
| 477 | 477 | $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
| 478 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 478 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 479 | 479 | } |
| 480 | 480 | |
| 481 | 481 | function queryFilterTP_this_year($layout_def) |
@@ -485,17 +485,17 @@ discard block |
||
| 485 | 485 | $begin->setDate($begin->year, 1, 1)->setTime(0, 0); |
| 486 | 486 | $end = clone $begin; |
| 487 | 487 | $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
| 488 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 488 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 489 | 489 | } |
| 490 | 490 | |
| 491 | 491 | function queryFilterTP_next_year(& $layout_def) |
| 492 | 492 | { |
| 493 | 493 | global $timedate; |
| 494 | 494 | $begin = $this->now(); |
| 495 | - $begin->setDate($begin->year+1, 1, 1)->setTime(0, 0); |
|
| 495 | + $begin->setDate($begin->year + 1, 1, 1)->setTime(0, 0); |
|
| 496 | 496 | $end = clone $begin; |
| 497 | 497 | $end->setDate($end->year, 12, 31)->setTime(23, 59, 59); |
| 498 | - return $this->get_start_end_date_filter($layout_def,$begin->asDb(),$end->asDb()); |
|
| 498 | + return $this->get_start_end_date_filter($layout_def, $begin->asDb(), $end->asDb()); |
|
| 499 | 499 | } |
| 500 | 500 | |
| 501 | 501 | function queryGroupBy($layout_def) |
@@ -504,7 +504,7 @@ discard block |
||
| 504 | 504 | if (!empty ($layout_def['qualifier'])) { |
| 505 | 505 | $func_name = 'queryGroupBy'.$layout_def['qualifier']; |
| 506 | 506 | if (method_exists($this, $func_name)) { |
| 507 | - return $this-> $func_name ($layout_def)." \n"; |
|
| 507 | + return $this-> $func_name($layout_def)." \n"; |
|
| 508 | 508 | } |
| 509 | 509 | } |
| 510 | 510 | return parent :: queryGroupBy($layout_def)." \n"; |
@@ -513,9 +513,9 @@ discard block |
||
| 513 | 513 | function queryOrderBy($layout_def) |
| 514 | 514 | { |
| 515 | 515 | if (!empty ($layout_def['qualifier'])) { |
| 516 | - $func_name ='queryOrderBy'.$layout_def['qualifier']; |
|
| 516 | + $func_name = 'queryOrderBy'.$layout_def['qualifier']; |
|
| 517 | 517 | if (method_exists($this, $func_name)) { |
| 518 | - return $this-> $func_name ($layout_def)."\n"; |
|
| 518 | + return $this-> $func_name($layout_def)."\n"; |
|
| 519 | 519 | } |
| 520 | 520 | } |
| 521 | 521 | $order_by = parent :: queryOrderBy($layout_def)."\n"; |
@@ -526,15 +526,15 @@ discard block |
||
| 526 | 526 | global $timedate; |
| 527 | 527 | $content = parent:: displayListPlain($layout_def); |
| 528 | 528 | // awu: this if condition happens only in Reports where group by month comes back as YYYY-mm format |
| 529 | - if (count(explode('-',$content)) == 2){ |
|
| 529 | + if (count(explode('-', $content)) == 2) { |
|
| 530 | 530 | return $content; |
| 531 | 531 | // if date field |
| 532 | - }elseif(substr_count($layout_def['type'], 'date') > 0){ |
|
| 532 | + }elseif (substr_count($layout_def['type'], 'date') > 0) { |
|
| 533 | 533 | // if date time field |
| 534 | - if(substr_count($layout_def['type'], 'time') > 0 && $this->get_time_part($content)!= false){ |
|
| 534 | + if (substr_count($layout_def['type'], 'time') > 0 && $this->get_time_part($content) != false) { |
|
| 535 | 535 | $td = $timedate->to_display_date_time($content); |
| 536 | 536 | return $td; |
| 537 | - }else{// if date only field |
|
| 537 | + } else {// if date only field |
|
| 538 | 538 | $td = $timedate->to_display_date($content, false); // Avoid PHP notice of returning by reference. |
| 539 | 539 | return $td; |
| 540 | 540 | } |
@@ -545,7 +545,7 @@ discard block |
||
| 545 | 545 | { |
| 546 | 546 | global $timedate; |
| 547 | 547 | |
| 548 | - $date_parts=$timedate->split_date_time($date_time_value); |
|
| 548 | + $date_parts = $timedate->split_date_time($date_time_value); |
|
| 549 | 549 | if (count($date_parts) > 1) { |
| 550 | 550 | return $date_parts[1]; |
| 551 | 551 | } else { |
@@ -559,7 +559,7 @@ discard block |
||
| 559 | 559 | if (!empty ($layout_def['column_function'])) { |
| 560 | 560 | $func_name = 'displayList'.$layout_def['column_function']; |
| 561 | 561 | if (method_exists($this, $func_name)) { |
| 562 | - return $this-> $func_name ($layout_def); |
|
| 562 | + return $this-> $func_name($layout_def); |
|
| 563 | 563 | } |
| 564 | 564 | } |
| 565 | 565 | $content = parent :: displayListPlain($layout_def); |
@@ -571,7 +571,7 @@ discard block |
||
| 571 | 571 | if (!empty ($layout_def['column_function'])) { |
| 572 | 572 | $func_name = 'querySelect'.$layout_def['column_function']; |
| 573 | 573 | if (method_exists($this, $func_name)) { |
| 574 | - return $this-> $func_name ($layout_def)." \n"; |
|
| 574 | + return $this-> $func_name($layout_def)." \n"; |
|
| 575 | 575 | } |
| 576 | 576 | } |
| 577 | 577 | return parent :: querySelect($layout_def)." \n"; |
@@ -613,7 +613,7 @@ discard block |
||
| 613 | 613 | { |
| 614 | 614 | $return = $this->reporter->db->convert($return, 'add_tz_offset'); |
| 615 | 615 | } |
| 616 | - return $this->reporter->db->convert($return, "date_format", array('%Y-%m')) . ' ' . $this->_get_column_alias($layout_def) . "\n"; |
|
| 616 | + return $this->reporter->db->convert($return, "date_format", array('%Y-%m')).' '.$this->_get_column_alias($layout_def)."\n"; |
|
| 617 | 617 | } |
| 618 | 618 | |
| 619 | 619 | /** |
@@ -629,7 +629,7 @@ discard block |
||
| 629 | 629 | { |
| 630 | 630 | $return = $this->reporter->db->convert($return, 'add_tz_offset'); |
| 631 | 631 | } |
| 632 | - return $this->reporter->db->convert($return, "date_format", array('%Y-%m')) . "\n"; |
|
| 632 | + return $this->reporter->db->convert($return, "date_format", array('%Y-%m'))."\n"; |
|
| 633 | 633 | } |
| 634 | 634 | |
| 635 | 635 | /** |
@@ -649,11 +649,11 @@ discard block |
||
| 649 | 649 | |
| 650 | 650 | if (empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
| 651 | 651 | { |
| 652 | - return $orderBy . " ASC\n"; |
|
| 652 | + return $orderBy." ASC\n"; |
|
| 653 | 653 | } |
| 654 | 654 | else |
| 655 | 655 | { |
| 656 | - return $orderBy . " DESC\n"; |
|
| 656 | + return $orderBy." DESC\n"; |
|
| 657 | 657 | } |
| 658 | 658 | } |
| 659 | 659 | |
@@ -670,7 +670,7 @@ discard block |
||
| 670 | 670 | { |
| 671 | 671 | $return = $this->reporter->db->convert($return, 'add_tz_offset'); |
| 672 | 672 | } |
| 673 | - return $this->reporter->db->convert($return, "date_format", array('%Y-%m-%d')) . ' ' . $this->_get_column_alias($layout_def) . "\n"; |
|
| 673 | + return $this->reporter->db->convert($return, "date_format", array('%Y-%m-%d')).' '.$this->_get_column_alias($layout_def)."\n"; |
|
| 674 | 674 | } |
| 675 | 675 | |
| 676 | 676 | /** |
@@ -686,7 +686,7 @@ discard block |
||
| 686 | 686 | { |
| 687 | 687 | $return = $this->reporter->db->convert($return, 'add_tz_offset'); |
| 688 | 688 | } |
| 689 | - return $this->reporter->db->convert($return, "date_format", array('%Y-%m-%d')) . "\n"; |
|
| 689 | + return $this->reporter->db->convert($return, "date_format", array('%Y-%m-%d'))."\n"; |
|
| 690 | 690 | } |
| 691 | 691 | |
| 692 | 692 | /** |
@@ -702,7 +702,7 @@ discard block |
||
| 702 | 702 | { |
| 703 | 703 | $return = $this->reporter->db->convert($return, 'add_tz_offset'); |
| 704 | 704 | } |
| 705 | - return $this->reporter->db->convert($return, "date_format", array('%Y')) . ' ' . $this->_get_column_alias($layout_def) . "\n"; |
|
| 705 | + return $this->reporter->db->convert($return, "date_format", array('%Y')).' '.$this->_get_column_alias($layout_def)."\n"; |
|
| 706 | 706 | } |
| 707 | 707 | |
| 708 | 708 | /** |
@@ -718,7 +718,7 @@ discard block |
||
| 718 | 718 | { |
| 719 | 719 | $return = $this->reporter->db->convert($return, 'add_tz_offset'); |
| 720 | 720 | } |
| 721 | - return $this->reporter->db->convert($return, "date_format", array('%Y')) . "\n"; |
|
| 721 | + return $this->reporter->db->convert($return, "date_format", array('%Y'))."\n"; |
|
| 722 | 722 | } |
| 723 | 723 | |
| 724 | 724 | function querySelectquarter($layout_def) |
@@ -766,11 +766,11 @@ discard block |
||
| 766 | 766 | |
| 767 | 767 | if (empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
| 768 | 768 | { |
| 769 | - return $orderBy . " ASC\n"; |
|
| 769 | + return $orderBy." ASC\n"; |
|
| 770 | 770 | } |
| 771 | 771 | else |
| 772 | 772 | { |
| 773 | - return $orderBy . " DESC\n"; |
|
| 773 | + return $orderBy." DESC\n"; |
|
| 774 | 774 | } |
| 775 | 775 | } |
| 776 | 776 | |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -58,8 +60,7 @@ discard block |
||
| 58 | 60 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 59 | 61 | if(isset($GLOBALS['log'])) { |
| 60 | 62 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 61 | - } |
|
| 62 | - else { |
|
| 63 | + } else { |
|
| 63 | 64 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 64 | 65 | } |
| 65 | 66 | self::__construct($layout_manager); |
@@ -81,7 +82,9 @@ discard block |
||
| 81 | 82 | |
| 82 | 83 | $report_def_str = $json_obj->decode($this->reporter->report_def_str); |
| 83 | 84 | |
| 84 | - if(empty($report_def_str['assigned_user_id'])) return null; |
|
| 85 | + if(empty($report_def_str['assigned_user_id'])) { |
|
| 86 | + return null; |
|
| 87 | + } |
|
| 85 | 88 | |
| 86 | 89 | $this->assigned_user = new User(); |
| 87 | 90 | $this->assigned_user->retrieve($report_def_str['assigned_user_id']); |
@@ -228,8 +231,7 @@ discard block |
||
| 228 | 231 | if ($time=='start') { |
| 229 | 232 | $begin_parts = explode(' ', $begin); |
| 230 | 233 | $be = $begin_parts[0] . ' 00:00:00'; |
| 231 | - } |
|
| 232 | - else if ($time=='end') { |
|
| 234 | + } else if ($time=='end') { |
|
| 233 | 235 | $begin_parts = explode(' ', $begin); |
| 234 | 236 | $be = $begin_parts[0] . ' 23:59:59'; |
| 235 | 237 | } else { |
@@ -529,12 +531,12 @@ discard block |
||
| 529 | 531 | if (count(explode('-',$content)) == 2){ |
| 530 | 532 | return $content; |
| 531 | 533 | // if date field |
| 532 | - }elseif(substr_count($layout_def['type'], 'date') > 0){ |
|
| 534 | + } elseif(substr_count($layout_def['type'], 'date') > 0){ |
|
| 533 | 535 | // if date time field |
| 534 | 536 | if(substr_count($layout_def['type'], 'time') > 0 && $this->get_time_part($content)!= false){ |
| 535 | 537 | $td = $timedate->to_display_date_time($content); |
| 536 | 538 | return $td; |
| 537 | - }else{// if date only field |
|
| 539 | + } else{// if date only field |
|
| 538 | 540 | $td = $timedate->to_display_date($content, false); // Avoid PHP notice of returning by reference. |
| 539 | 541 | return $td; |
| 540 | 542 | } |
@@ -650,8 +652,7 @@ discard block |
||
| 650 | 652 | if (empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
| 651 | 653 | { |
| 652 | 654 | return $orderBy . " ASC\n"; |
| 653 | - } |
|
| 654 | - else |
|
| 655 | + } else |
|
| 655 | 656 | { |
| 656 | 657 | return $orderBy . " DESC\n"; |
| 657 | 658 | } |
@@ -767,8 +768,7 @@ discard block |
||
| 767 | 768 | if (empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
| 768 | 769 | { |
| 769 | 770 | return $orderBy . " ASC\n"; |
| 770 | - } |
|
| 771 | - else |
|
| 771 | + } else |
|
| 772 | 772 | { |
| 773 | 773 | return $orderBy . " DESC\n"; |
| 774 | 774 | } |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | */ |
| 55 | 55 | protected $reporter; |
| 56 | 56 | |
| 57 | - function __construct(&$layout_manager) { |
|
| 57 | + function __construct(&$layout_manager) { |
|
| 58 | 58 | parent::__construct($layout_manager); |
| 59 | 59 | $this->reporter = $this->layout_manager->getAttribute("reporter"); |
| 60 | 60 | } |
@@ -74,25 +74,25 @@ discard block |
||
| 74 | 74 | } |
| 75 | 75 | |
| 76 | 76 | |
| 77 | - function getSubClass($layout_def) |
|
| 78 | - { |
|
| 79 | - if (! empty($layout_def['type'])) |
|
| 80 | - { |
|
| 77 | + function getSubClass($layout_def) |
|
| 78 | + { |
|
| 79 | + if (! empty($layout_def['type'])) |
|
| 80 | + { |
|
| 81 | 81 | |
| 82 | - if ($layout_def['type'] == 'time') { |
|
| 83 | - $layout_def['widget_class'] = 'Fielddate'; |
|
| 84 | - } else { |
|
| 85 | - $layout_def['widget_class'] = 'Field'.$layout_def['type']; |
|
| 86 | - } |
|
| 87 | - return $this->layout_manager->getClassFromWidgetDef($layout_def); |
|
| 88 | - } else { |
|
| 89 | - return $this; |
|
| 90 | - } |
|
| 91 | - } |
|
| 82 | + if ($layout_def['type'] == 'time') { |
|
| 83 | + $layout_def['widget_class'] = 'Fielddate'; |
|
| 84 | + } else { |
|
| 85 | + $layout_def['widget_class'] = 'Field'.$layout_def['type']; |
|
| 86 | + } |
|
| 87 | + return $this->layout_manager->getClassFromWidgetDef($layout_def); |
|
| 88 | + } else { |
|
| 89 | + return $this; |
|
| 90 | + } |
|
| 91 | + } |
|
| 92 | 92 | |
| 93 | 93 | |
| 94 | - function display($layout_def) |
|
| 95 | - { |
|
| 94 | + function display($layout_def) |
|
| 95 | + { |
|
| 96 | 96 | $obj = $this->getSubClass($layout_def); |
| 97 | 97 | |
| 98 | 98 | $context = $this->layout_manager->getAttribute('context');//_ppd($context); |
@@ -106,51 +106,51 @@ discard block |
||
| 106 | 106 | { |
| 107 | 107 | return 'display not found:'.$func_name; |
| 108 | 108 | } |
| 109 | - } |
|
| 109 | + } |
|
| 110 | 110 | |
| 111 | - function _get_column_select_special($layout_def) |
|
| 112 | - { |
|
| 113 | - $alias = ''; |
|
| 114 | - if ( ! empty($layout_def['table_alias'])) |
|
| 115 | - { |
|
| 116 | - $alias = $layout_def['table_alias']; |
|
| 117 | - } |
|
| 111 | + function _get_column_select_special($layout_def) |
|
| 112 | + { |
|
| 113 | + $alias = ''; |
|
| 114 | + if ( ! empty($layout_def['table_alias'])) |
|
| 115 | + { |
|
| 116 | + $alias = $layout_def['table_alias']; |
|
| 117 | + } |
|
| 118 | 118 | |
| 119 | 119 | if ($layout_def['name'] == 'weighted_sum' ) |
| 120 | 120 | { |
| 121 | 121 | return sprintf("SUM(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability","IFNULL", array(0)), |
| 122 | 122 | $this->reporter->db->convert("$alias.amount_usdollar","IFNULL", array(0))); |
| 123 | - } |
|
| 123 | + } |
|
| 124 | 124 | if ($layout_def['name'] == 'weighted_amount' ) |
| 125 | 125 | { |
| 126 | 126 | return sprintf("AVG(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability","IFNULL", array(0)), |
| 127 | 127 | $this->reporter->db->convert("$alias.amount_usdollar","IFNULL", array(0))); |
| 128 | - } |
|
| 129 | - } |
|
| 130 | - |
|
| 131 | - function _get_column_select($layout_def) |
|
| 132 | - { |
|
| 133 | - global $reportAlias; |
|
| 134 | - if (!isset($reportAlias)) { |
|
| 135 | - $reportAlias = array(); |
|
| 136 | - } |
|
| 137 | - |
|
| 138 | - if ( ! empty($layout_def['table_alias'])) { |
|
| 139 | - $alias = $layout_def['table_alias'].".".$layout_def['name']; |
|
| 140 | - } else if (! empty($layout_def['name'])) { |
|
| 141 | - $alias = $layout_def['name']; |
|
| 142 | - } else { |
|
| 143 | - $alias = "*"; |
|
| 144 | - } |
|
| 145 | - |
|
| 146 | - if ( ! empty($layout_def['group_function']) ) |
|
| 147 | - { |
|
| 148 | - if ($layout_def['name'] == 'weighted_sum' || $layout_def['name'] == 'weighted_amount') |
|
| 149 | - { |
|
| 150 | - $alias = $this->_get_column_select_special($layout_def); |
|
| 151 | - $reportAlias[$alias] = $layout_def; |
|
| 152 | - return $alias; |
|
| 153 | - } |
|
| 128 | + } |
|
| 129 | + } |
|
| 130 | + |
|
| 131 | + function _get_column_select($layout_def) |
|
| 132 | + { |
|
| 133 | + global $reportAlias; |
|
| 134 | + if (!isset($reportAlias)) { |
|
| 135 | + $reportAlias = array(); |
|
| 136 | + } |
|
| 137 | + |
|
| 138 | + if ( ! empty($layout_def['table_alias'])) { |
|
| 139 | + $alias = $layout_def['table_alias'].".".$layout_def['name']; |
|
| 140 | + } else if (! empty($layout_def['name'])) { |
|
| 141 | + $alias = $layout_def['name']; |
|
| 142 | + } else { |
|
| 143 | + $alias = "*"; |
|
| 144 | + } |
|
| 145 | + |
|
| 146 | + if ( ! empty($layout_def['group_function']) ) |
|
| 147 | + { |
|
| 148 | + if ($layout_def['name'] == 'weighted_sum' || $layout_def['name'] == 'weighted_amount') |
|
| 149 | + { |
|
| 150 | + $alias = $this->_get_column_select_special($layout_def); |
|
| 151 | + $reportAlias[$alias] = $layout_def; |
|
| 152 | + return $alias; |
|
| 153 | + } |
|
| 154 | 154 | |
| 155 | 155 | // Use IFNULL only if it's not AVG aggregate |
| 156 | 156 | // because it adds NULL rows to the count when it should not, thus getting wrong result |
@@ -179,66 +179,66 @@ discard block |
||
| 179 | 179 | } |
| 180 | 180 | |
| 181 | 181 | } |
| 182 | - } |
|
| 182 | + } |
|
| 183 | 183 | |
| 184 | - $reportAlias[$alias] = $layout_def; |
|
| 185 | - return $alias; |
|
| 186 | - } |
|
| 184 | + $reportAlias[$alias] = $layout_def; |
|
| 185 | + return $alias; |
|
| 186 | + } |
|
| 187 | 187 | |
| 188 | - function querySelect(&$layout_def) |
|
| 189 | - { |
|
| 188 | + function querySelect(&$layout_def) |
|
| 189 | + { |
|
| 190 | 190 | return $this->_get_column_select($layout_def)." ".$this->_get_column_alias($layout_def)."\n"; |
| 191 | - } |
|
| 191 | + } |
|
| 192 | 192 | |
| 193 | - function queryGroupBy($layout_def) |
|
| 194 | - { |
|
| 195 | - return $this->_get_column_select($layout_def)." \n"; |
|
| 196 | - } |
|
| 193 | + function queryGroupBy($layout_def) |
|
| 194 | + { |
|
| 195 | + return $this->_get_column_select($layout_def)." \n"; |
|
| 196 | + } |
|
| 197 | 197 | |
| 198 | 198 | |
| 199 | - function queryOrderBy($layout_def) |
|
| 200 | - { |
|
| 201 | - $field_def = array(); |
|
| 202 | - if(!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
|
| 199 | + function queryOrderBy($layout_def) |
|
| 200 | + { |
|
| 201 | + $field_def = array(); |
|
| 202 | + if(!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
|
| 203 | 203 | |
| 204 | 204 | if (!empty($layout_def['group_function'])) |
| 205 | 205 | { |
| 206 | 206 | $order_by = $this->_get_column_alias($layout_def); |
| 207 | 207 | } |
| 208 | 208 | elseif (!empty($field_def['sort_on'])) |
| 209 | - { |
|
| 210 | - $order_by = $layout_def['table_alias'].".".$field_def['sort_on']; |
|
| 209 | + { |
|
| 210 | + $order_by = $layout_def['table_alias'].".".$field_def['sort_on']; |
|
| 211 | 211 | if(!empty($field_def['sort_on2'])) |
| 212 | 212 | $order_by .= ', ' . $layout_def['table_alias'].".".$field_def['sort_on2']; |
| 213 | 213 | } |
| 214 | - else { |
|
| 215 | - $order_by = $this->_get_column_alias($layout_def)." \n"; |
|
| 216 | - } |
|
| 214 | + else { |
|
| 215 | + $order_by = $this->_get_column_alias($layout_def)." \n"; |
|
| 216 | + } |
|
| 217 | 217 | |
| 218 | - //use sugar db function convert on order by string to convert to varchar. This is mainly for db's |
|
| 219 | - //that do not allow sorting on clob/text fields |
|
| 218 | + //use sugar db function convert on order by string to convert to varchar. This is mainly for db's |
|
| 219 | + //that do not allow sorting on clob/text fields |
|
| 220 | 220 | if ($this->reporter->db->isTextType($this->reporter->db->getFieldType($field_def))) { |
| 221 | 221 | $order_by = $this->reporter->db->convert($order_by,'text2char', array(10000)); // array(10000) is for db2 only |
| 222 | 222 | } |
| 223 | 223 | |
| 224 | - if ( empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
|
| 225 | - { |
|
| 226 | - return $order_by." ASC"; |
|
| 227 | - } else { |
|
| 228 | - return $order_by." DESC"; |
|
| 229 | - } |
|
| 230 | - } |
|
| 224 | + if ( empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
|
| 225 | + { |
|
| 226 | + return $order_by." ASC"; |
|
| 227 | + } else { |
|
| 228 | + return $order_by." DESC"; |
|
| 229 | + } |
|
| 230 | + } |
|
| 231 | 231 | |
| 232 | 232 | |
| 233 | - function queryFilter($layout_def) |
|
| 234 | - { |
|
| 235 | - $method_name = "queryFilter".$layout_def['qualifier_name']; |
|
| 236 | - return $this->$method_name($layout_def); |
|
| 237 | - } |
|
| 233 | + function queryFilter($layout_def) |
|
| 234 | + { |
|
| 235 | + $method_name = "queryFilter".$layout_def['qualifier_name']; |
|
| 236 | + return $this->$method_name($layout_def); |
|
| 237 | + } |
|
| 238 | 238 | |
| 239 | - function displayHeaderCell($layout_def) |
|
| 240 | - { |
|
| 241 | - global $start_link_wrapper,$end_link_wrapper; |
|
| 239 | + function displayHeaderCell($layout_def) |
|
| 240 | + { |
|
| 241 | + global $start_link_wrapper,$end_link_wrapper; |
|
| 242 | 242 | |
| 243 | 243 | |
| 244 | 244 | // don't show sort links if name isn't defined |
@@ -252,22 +252,22 @@ discard block |
||
| 252 | 252 | |
| 253 | 253 | $sort_by =''; |
| 254 | 254 | if ( ! empty($layout_def['table_key']) && ! empty($layout_def['name']) ) { |
| 255 | - if (! empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') { |
|
| 255 | + if (! empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') { |
|
| 256 | 256 | $sort_by = $layout_def['table_key'].":".'count'; |
| 257 | - } else { |
|
| 258 | - $sort_by = $layout_def['table_key'].":".$layout_def['name']; |
|
| 257 | + } else { |
|
| 258 | + $sort_by = $layout_def['table_key'].":".$layout_def['name']; |
|
| 259 | 259 | if ( ! empty($layout_def['column_function'])) { |
| 260 | - $sort_by .= ':'.$layout_def['column_function']; |
|
| 261 | - } else if ( ! empty($layout_def['group_function']) ) { |
|
| 262 | - $sort_by .= ':'.$layout_def['group_function']; |
|
| 263 | - } |
|
| 264 | - } |
|
| 260 | + $sort_by .= ':'.$layout_def['column_function']; |
|
| 261 | + } else if ( ! empty($layout_def['group_function']) ) { |
|
| 262 | + $sort_by .= ':'.$layout_def['group_function']; |
|
| 263 | + } |
|
| 264 | + } |
|
| 265 | 265 | } else { |
| 266 | - return $this->displayHeaderCellPlain($layout_def); |
|
| 266 | + return $this->displayHeaderCellPlain($layout_def); |
|
| 267 | 267 | } |
| 268 | 268 | |
| 269 | 269 | $start = empty($start_link_wrapper) ? '': $start_link_wrapper; |
| 270 | - $end = empty($end_link_wrapper) ? '': $end_link_wrapper; |
|
| 270 | + $end = empty($end_link_wrapper) ? '': $end_link_wrapper; |
|
| 271 | 271 | |
| 272 | 272 | // unable to retrieve the vardef here, exclude columns of type clob/text from being sortable |
| 273 | 273 | |
@@ -277,40 +277,40 @@ discard block |
||
| 277 | 277 | $objListView = new ListView(); |
| 278 | 278 | $header_cell .= $objListView->getArrowUpDownStart(isset($layout_def['sort']) ? $layout_def['sort'] : ''); |
| 279 | 279 | $header_cell .= $objListView->getArrowUpDownEnd(isset($layout_def['sort']) ? $layout_def['sort'] : ''); |
| 280 | - $header_cell .= "</a>"; |
|
| 281 | - return $header_cell; |
|
| 282 | - } |
|
| 280 | + $header_cell .= "</a>"; |
|
| 281 | + return $header_cell; |
|
| 282 | + } |
|
| 283 | 283 | |
| 284 | - return $this->displayHeaderCellPlain($layout_def); |
|
| 284 | + return $this->displayHeaderCellPlain($layout_def); |
|
| 285 | 285 | } |
| 286 | 286 | |
| 287 | - function query($layout_def) |
|
| 288 | - { |
|
| 289 | - $obj = $this->getSubClass($layout_def); |
|
| 287 | + function query($layout_def) |
|
| 288 | + { |
|
| 289 | + $obj = $this->getSubClass($layout_def); |
|
| 290 | 290 | |
| 291 | - $context = $this->layout_manager->getAttribute('context'); |
|
| 292 | - $func_name = 'query'.$context; |
|
| 291 | + $context = $this->layout_manager->getAttribute('context'); |
|
| 292 | + $func_name = 'query'.$context; |
|
| 293 | 293 | |
| 294 | - if ( ! empty($context) && method_exists($obj,$func_name)) |
|
| 295 | - { |
|
| 296 | - return $obj->$func_name($layout_def); |
|
| 297 | - } else |
|
| 298 | - { |
|
| 299 | - return ''; |
|
| 300 | - } |
|
| 301 | - } |
|
| 294 | + if ( ! empty($context) && method_exists($obj,$func_name)) |
|
| 295 | + { |
|
| 296 | + return $obj->$func_name($layout_def); |
|
| 297 | + } else |
|
| 298 | + { |
|
| 299 | + return ''; |
|
| 300 | + } |
|
| 301 | + } |
|
| 302 | 302 | |
| 303 | - function _get_column_alias($layout_def) |
|
| 304 | - { |
|
| 303 | + function _get_column_alias($layout_def) |
|
| 304 | + { |
|
| 305 | 305 | $alias_arr = array(); |
| 306 | 306 | |
| 307 | - if (!empty($layout_def['table_key']) && $layout_def['table_key'] == 'self' && !empty($layout_def['name']) && $layout_def['name'] == 'id') |
|
| 308 | - { |
|
| 309 | - return 'primaryid'; |
|
| 310 | - } |
|
| 307 | + if (!empty($layout_def['table_key']) && $layout_def['table_key'] == 'self' && !empty($layout_def['name']) && $layout_def['name'] == 'id') |
|
| 308 | + { |
|
| 309 | + return 'primaryid'; |
|
| 310 | + } |
|
| 311 | 311 | |
| 312 | - // Bug: 44605 |
|
| 313 | - // this comment is being added to trigger the upgrade package |
|
| 312 | + // Bug: 44605 |
|
| 313 | + // this comment is being added to trigger the upgrade package |
|
| 314 | 314 | if ( ! empty($layout_def['group_function']) && $layout_def['group_function']=='count') |
| 315 | 315 | { |
| 316 | 316 | return $layout_def['table_alias'] . '__count'; |
@@ -337,49 +337,49 @@ discard block |
||
| 337 | 337 | array_push($alias_arr,$layout_def['name']); |
| 338 | 338 | } |
| 339 | 339 | |
| 340 | - global $used_aliases, $alias_map; |
|
| 340 | + global $used_aliases, $alias_map; |
|
| 341 | 341 | |
| 342 | 342 | $alias = strtolower(implode("_",$alias_arr)); |
| 343 | 343 | |
| 344 | 344 | $short_alias = $this->getTruncatedColumnAlias($alias); |
| 345 | 345 | |
| 346 | - if ( empty($used_aliases[$short_alias])) |
|
| 347 | - { |
|
| 348 | - $alias_map[$alias] = $short_alias; |
|
| 349 | - $used_aliases[$short_alias] = 1; |
|
| 350 | - return $short_alias; |
|
| 351 | - } else if ( ! empty($alias_map[$alias]) ) |
|
| 352 | - { |
|
| 353 | - return $alias_map[$alias]; |
|
| 354 | - } else { |
|
| 355 | - $alias_map[$alias] = $short_alias.'_'.$used_aliases[$short_alias]; |
|
| 356 | - $used_aliases[$short_alias]++; |
|
| 357 | - return $alias_map[$alias]; |
|
| 358 | - } |
|
| 359 | - } |
|
| 360 | - |
|
| 361 | - function queryFilterEmpty($layout_def) |
|
| 362 | - { |
|
| 363 | - $column = $this->_get_column_select($layout_def); |
|
| 364 | - return "($column IS NULL OR $column = ".$this->reporter->db->emptyValue($layout_def['type']).")"; |
|
| 365 | - } |
|
| 366 | - |
|
| 367 | - function queryFilterIs($layout_def) |
|
| 368 | - { |
|
| 369 | - return '( '.$this->_get_column_select($layout_def)."='".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n"; |
|
| 370 | - } |
|
| 371 | - |
|
| 372 | - function queryFilteris_not($layout_def) |
|
| 373 | - { |
|
| 374 | - return '( '.$this->_get_column_select($layout_def)."<>'".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n"; |
|
| 375 | - } |
|
| 376 | - |
|
| 377 | - function queryFilterNot_Empty($layout_def) |
|
| 378 | - { |
|
| 379 | - /** @var $db DBManager */ |
|
| 380 | - $db = $this->reporter->db; |
|
| 381 | - $column = $this->_get_column_select($layout_def); |
|
| 382 | - return "(coalesce(" . $db->convert($column, "length") . ",0) > 0)\n"; |
|
| 383 | - } |
|
| 346 | + if ( empty($used_aliases[$short_alias])) |
|
| 347 | + { |
|
| 348 | + $alias_map[$alias] = $short_alias; |
|
| 349 | + $used_aliases[$short_alias] = 1; |
|
| 350 | + return $short_alias; |
|
| 351 | + } else if ( ! empty($alias_map[$alias]) ) |
|
| 352 | + { |
|
| 353 | + return $alias_map[$alias]; |
|
| 354 | + } else { |
|
| 355 | + $alias_map[$alias] = $short_alias.'_'.$used_aliases[$short_alias]; |
|
| 356 | + $used_aliases[$short_alias]++; |
|
| 357 | + return $alias_map[$alias]; |
|
| 358 | + } |
|
| 359 | + } |
|
| 360 | + |
|
| 361 | + function queryFilterEmpty($layout_def) |
|
| 362 | + { |
|
| 363 | + $column = $this->_get_column_select($layout_def); |
|
| 364 | + return "($column IS NULL OR $column = ".$this->reporter->db->emptyValue($layout_def['type']).")"; |
|
| 365 | + } |
|
| 366 | + |
|
| 367 | + function queryFilterIs($layout_def) |
|
| 368 | + { |
|
| 369 | + return '( '.$this->_get_column_select($layout_def)."='".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n"; |
|
| 370 | + } |
|
| 371 | + |
|
| 372 | + function queryFilteris_not($layout_def) |
|
| 373 | + { |
|
| 374 | + return '( '.$this->_get_column_select($layout_def)."<>'".$GLOBALS['db']->quote($layout_def['input_name0'])."')\n"; |
|
| 375 | + } |
|
| 376 | + |
|
| 377 | + function queryFilterNot_Empty($layout_def) |
|
| 378 | + { |
|
| 379 | + /** @var $db DBManager */ |
|
| 380 | + $db = $this->reporter->db; |
|
| 381 | + $column = $this->_get_column_select($layout_def); |
|
| 382 | + return "(coalesce(" . $db->convert($column, "length") . ",0) > 0)\n"; |
|
| 383 | + } |
|
| 384 | 384 | |
| 385 | 385 | } |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -62,9 +62,9 @@ discard block |
||
| 62 | 62 | /** |
| 63 | 63 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 64 | 64 | */ |
| 65 | - function SugarWidgetReportField(&$layout_manager){ |
|
| 65 | + function SugarWidgetReportField(&$layout_manager) { |
|
| 66 | 66 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 67 | - if(isset($GLOBALS['log'])) { |
|
| 67 | + if (isset($GLOBALS['log'])) { |
|
| 68 | 68 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 69 | 69 | } |
| 70 | 70 | else { |
@@ -76,7 +76,7 @@ discard block |
||
| 76 | 76 | |
| 77 | 77 | function getSubClass($layout_def) |
| 78 | 78 | { |
| 79 | - if (! empty($layout_def['type'])) |
|
| 79 | + if (!empty($layout_def['type'])) |
|
| 80 | 80 | { |
| 81 | 81 | |
| 82 | 82 | if ($layout_def['type'] == 'time') { |
@@ -95,11 +95,11 @@ discard block |
||
| 95 | 95 | { |
| 96 | 96 | $obj = $this->getSubClass($layout_def); |
| 97 | 97 | |
| 98 | - $context = $this->layout_manager->getAttribute('context');//_ppd($context); |
|
| 98 | + $context = $this->layout_manager->getAttribute('context'); //_ppd($context); |
|
| 99 | 99 | $func_name = 'display'.$context; |
| 100 | 100 | |
| 101 | 101 | |
| 102 | - if ( ! empty($context) && method_exists($obj,$func_name)) |
|
| 102 | + if (!empty($context) && method_exists($obj, $func_name)) |
|
| 103 | 103 | { |
| 104 | 104 | return $obj->$func_name($layout_def); |
| 105 | 105 | } else |
@@ -111,20 +111,20 @@ discard block |
||
| 111 | 111 | function _get_column_select_special($layout_def) |
| 112 | 112 | { |
| 113 | 113 | $alias = ''; |
| 114 | - if ( ! empty($layout_def['table_alias'])) |
|
| 114 | + if (!empty($layout_def['table_alias'])) |
|
| 115 | 115 | { |
| 116 | 116 | $alias = $layout_def['table_alias']; |
| 117 | 117 | } |
| 118 | 118 | |
| 119 | - if ($layout_def['name'] == 'weighted_sum' ) |
|
| 119 | + if ($layout_def['name'] == 'weighted_sum') |
|
| 120 | 120 | { |
| 121 | - return sprintf("SUM(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability","IFNULL", array(0)), |
|
| 122 | - $this->reporter->db->convert("$alias.amount_usdollar","IFNULL", array(0))); |
|
| 121 | + return sprintf("SUM(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability", "IFNULL", array(0)), |
|
| 122 | + $this->reporter->db->convert("$alias.amount_usdollar", "IFNULL", array(0))); |
|
| 123 | 123 | } |
| 124 | - if ($layout_def['name'] == 'weighted_amount' ) |
|
| 124 | + if ($layout_def['name'] == 'weighted_amount') |
|
| 125 | 125 | { |
| 126 | - return sprintf("AVG(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability","IFNULL", array(0)), |
|
| 127 | - $this->reporter->db->convert("$alias.amount_usdollar","IFNULL", array(0))); |
|
| 126 | + return sprintf("AVG(%s * %s * 0.01)", $this->reporter->db->convert("$alias.probability", "IFNULL", array(0)), |
|
| 127 | + $this->reporter->db->convert("$alias.amount_usdollar", "IFNULL", array(0))); |
|
| 128 | 128 | } |
| 129 | 129 | } |
| 130 | 130 | |
@@ -135,15 +135,15 @@ discard block |
||
| 135 | 135 | $reportAlias = array(); |
| 136 | 136 | } |
| 137 | 137 | |
| 138 | - if ( ! empty($layout_def['table_alias'])) { |
|
| 138 | + if (!empty($layout_def['table_alias'])) { |
|
| 139 | 139 | $alias = $layout_def['table_alias'].".".$layout_def['name']; |
| 140 | - } else if (! empty($layout_def['name'])) { |
|
| 140 | + } else if (!empty($layout_def['name'])) { |
|
| 141 | 141 | $alias = $layout_def['name']; |
| 142 | 142 | } else { |
| 143 | 143 | $alias = "*"; |
| 144 | 144 | } |
| 145 | 145 | |
| 146 | - if ( ! empty($layout_def['group_function']) ) |
|
| 146 | + if (!empty($layout_def['group_function'])) |
|
| 147 | 147 | { |
| 148 | 148 | if ($layout_def['name'] == 'weighted_sum' || $layout_def['name'] == 'weighted_amount') |
| 149 | 149 | { |
@@ -168,7 +168,7 @@ discard block |
||
| 168 | 168 | if ($layout_def['group_function'] != 'avg') { |
| 169 | 169 | $alias = "{$layout_def['group_function']}($alias/{$query})*{$currency->conversion_rate}"; |
| 170 | 170 | } else { |
| 171 | - $alias = $this->reporter->db->convert("$alias/$query", "AVG") . " * {$currency->conversion_rate}"; |
|
| 171 | + $alias = $this->reporter->db->convert("$alias/$query", "AVG")." * {$currency->conversion_rate}"; |
|
| 172 | 172 | } |
| 173 | 173 | } else { |
| 174 | 174 | // We need to use convert() for AVG because of Oracle |
@@ -199,7 +199,7 @@ discard block |
||
| 199 | 199 | function queryOrderBy($layout_def) |
| 200 | 200 | { |
| 201 | 201 | $field_def = array(); |
| 202 | - if(!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
|
| 202 | + if (!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
|
| 203 | 203 | |
| 204 | 204 | if (!empty($layout_def['group_function'])) |
| 205 | 205 | { |
@@ -208,8 +208,8 @@ discard block |
||
| 208 | 208 | elseif (!empty($field_def['sort_on'])) |
| 209 | 209 | { |
| 210 | 210 | $order_by = $layout_def['table_alias'].".".$field_def['sort_on']; |
| 211 | - if(!empty($field_def['sort_on2'])) |
|
| 212 | - $order_by .= ', ' . $layout_def['table_alias'].".".$field_def['sort_on2']; |
|
| 211 | + if (!empty($field_def['sort_on2'])) |
|
| 212 | + $order_by .= ', '.$layout_def['table_alias'].".".$field_def['sort_on2']; |
|
| 213 | 213 | } |
| 214 | 214 | else { |
| 215 | 215 | $order_by = $this->_get_column_alias($layout_def)." \n"; |
@@ -218,10 +218,10 @@ discard block |
||
| 218 | 218 | //use sugar db function convert on order by string to convert to varchar. This is mainly for db's |
| 219 | 219 | //that do not allow sorting on clob/text fields |
| 220 | 220 | if ($this->reporter->db->isTextType($this->reporter->db->getFieldType($field_def))) { |
| 221 | - $order_by = $this->reporter->db->convert($order_by,'text2char', array(10000)); // array(10000) is for db2 only |
|
| 221 | + $order_by = $this->reporter->db->convert($order_by, 'text2char', array(10000)); // array(10000) is for db2 only |
|
| 222 | 222 | } |
| 223 | 223 | |
| 224 | - if ( empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
|
| 224 | + if (empty($layout_def['sort_dir']) || $layout_def['sort_dir'] == 'a') |
|
| 225 | 225 | { |
| 226 | 226 | return $order_by." ASC"; |
| 227 | 227 | } else { |
@@ -238,27 +238,27 @@ discard block |
||
| 238 | 238 | |
| 239 | 239 | function displayHeaderCell($layout_def) |
| 240 | 240 | { |
| 241 | - global $start_link_wrapper,$end_link_wrapper; |
|
| 241 | + global $start_link_wrapper, $end_link_wrapper; |
|
| 242 | 242 | |
| 243 | 243 | |
| 244 | 244 | // don't show sort links if name isn't defined |
| 245 | 245 | $no_sort = $this->layout_manager->getAttribute('no_sort'); |
| 246 | - if(empty($layout_def['name']) || ! empty($no_sort) || ! empty($layout_def['no_sort'])) |
|
| 246 | + if (empty($layout_def['name']) || !empty($no_sort) || !empty($layout_def['no_sort'])) |
|
| 247 | 247 | { |
| 248 | 248 | return $layout_def['label']; |
| 249 | 249 | } |
| 250 | 250 | |
| 251 | 251 | |
| 252 | 252 | |
| 253 | - $sort_by =''; |
|
| 254 | - if ( ! empty($layout_def['table_key']) && ! empty($layout_def['name']) ) { |
|
| 255 | - if (! empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') { |
|
| 253 | + $sort_by = ''; |
|
| 254 | + if (!empty($layout_def['table_key']) && !empty($layout_def['name'])) { |
|
| 255 | + if (!empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') { |
|
| 256 | 256 | $sort_by = $layout_def['table_key'].":".'count'; |
| 257 | 257 | } else { |
| 258 | 258 | $sort_by = $layout_def['table_key'].":".$layout_def['name']; |
| 259 | - if ( ! empty($layout_def['column_function'])) { |
|
| 259 | + if (!empty($layout_def['column_function'])) { |
|
| 260 | 260 | $sort_by .= ':'.$layout_def['column_function']; |
| 261 | - } else if ( ! empty($layout_def['group_function']) ) { |
|
| 261 | + } else if (!empty($layout_def['group_function'])) { |
|
| 262 | 262 | $sort_by .= ':'.$layout_def['group_function']; |
| 263 | 263 | } |
| 264 | 264 | } |
@@ -266,12 +266,12 @@ discard block |
||
| 266 | 266 | return $this->displayHeaderCellPlain($layout_def); |
| 267 | 267 | } |
| 268 | 268 | |
| 269 | - $start = empty($start_link_wrapper) ? '': $start_link_wrapper; |
|
| 270 | - $end = empty($end_link_wrapper) ? '': $end_link_wrapper; |
|
| 269 | + $start = empty($start_link_wrapper) ? '' : $start_link_wrapper; |
|
| 270 | + $end = empty($end_link_wrapper) ? '' : $end_link_wrapper; |
|
| 271 | 271 | |
| 272 | 272 | // unable to retrieve the vardef here, exclude columns of type clob/text from being sortable |
| 273 | 273 | |
| 274 | - if(!in_array($layout_def['name'], array('description', 'account_description', 'lead_source_description', 'status_description', 'to_addrs', 'cc_addrs', 'bcc_addrs', 'work_log', 'objective', 'resolution'))) { |
|
| 274 | + if (!in_array($layout_def['name'], array('description', 'account_description', 'lead_source_description', 'status_description', 'to_addrs', 'cc_addrs', 'bcc_addrs', 'work_log', 'objective', 'resolution'))) { |
|
| 275 | 275 | $header_cell = "<a class=\"listViewThLinkS1\" href=\"".$start.$sort_by.$end."\">"; |
| 276 | 276 | $header_cell .= $this->displayHeaderCellPlain($layout_def); |
| 277 | 277 | $objListView = new ListView(); |
@@ -291,7 +291,7 @@ discard block |
||
| 291 | 291 | $context = $this->layout_manager->getAttribute('context'); |
| 292 | 292 | $func_name = 'query'.$context; |
| 293 | 293 | |
| 294 | - if ( ! empty($context) && method_exists($obj,$func_name)) |
|
| 294 | + if (!empty($context) && method_exists($obj, $func_name)) |
|
| 295 | 295 | { |
| 296 | 296 | return $obj->$func_name($layout_def); |
| 297 | 297 | } else |
@@ -311,44 +311,44 @@ discard block |
||
| 311 | 311 | |
| 312 | 312 | // Bug: 44605 |
| 313 | 313 | // this comment is being added to trigger the upgrade package |
| 314 | - if ( ! empty($layout_def['group_function']) && $layout_def['group_function']=='count') |
|
| 314 | + if (!empty($layout_def['group_function']) && $layout_def['group_function'] == 'count') |
|
| 315 | 315 | { |
| 316 | - return $layout_def['table_alias'] . '__count'; |
|
| 316 | + return $layout_def['table_alias'].'__count'; |
|
| 317 | 317 | } |
| 318 | 318 | |
| 319 | - if ( ! empty($layout_def['table_alias'])) |
|
| 319 | + if (!empty($layout_def['table_alias'])) |
|
| 320 | 320 | { |
| 321 | - array_push($alias_arr,$layout_def['table_alias']); |
|
| 321 | + array_push($alias_arr, $layout_def['table_alias']); |
|
| 322 | 322 | } |
| 323 | 323 | |
| 324 | - if ( ! empty($layout_def['group_function']) && $layout_def['group_function'] != 'weighted_amount' && $layout_def['group_function'] != 'weighted_sum') |
|
| 324 | + if (!empty($layout_def['group_function']) && $layout_def['group_function'] != 'weighted_amount' && $layout_def['group_function'] != 'weighted_sum') |
|
| 325 | 325 | { |
| 326 | - array_push($alias_arr,$layout_def['group_function']); |
|
| 327 | - } else if ( ! empty($layout_def['column_function'])) |
|
| 326 | + array_push($alias_arr, $layout_def['group_function']); |
|
| 327 | + } else if (!empty($layout_def['column_function'])) |
|
| 328 | 328 | { |
| 329 | - array_push($alias_arr,$layout_def['column_function']); |
|
| 330 | - } else if ( ! empty($layout_def['qualifier'])) |
|
| 329 | + array_push($alias_arr, $layout_def['column_function']); |
|
| 330 | + } else if (!empty($layout_def['qualifier'])) |
|
| 331 | 331 | { |
| 332 | - array_push($alias_arr,$layout_def['qualifier']); |
|
| 332 | + array_push($alias_arr, $layout_def['qualifier']); |
|
| 333 | 333 | } |
| 334 | 334 | |
| 335 | - if ( ! empty($layout_def['name'])) |
|
| 335 | + if (!empty($layout_def['name'])) |
|
| 336 | 336 | { |
| 337 | - array_push($alias_arr,$layout_def['name']); |
|
| 337 | + array_push($alias_arr, $layout_def['name']); |
|
| 338 | 338 | } |
| 339 | 339 | |
| 340 | 340 | global $used_aliases, $alias_map; |
| 341 | 341 | |
| 342 | - $alias = strtolower(implode("_",$alias_arr)); |
|
| 342 | + $alias = strtolower(implode("_", $alias_arr)); |
|
| 343 | 343 | |
| 344 | 344 | $short_alias = $this->getTruncatedColumnAlias($alias); |
| 345 | 345 | |
| 346 | - if ( empty($used_aliases[$short_alias])) |
|
| 346 | + if (empty($used_aliases[$short_alias])) |
|
| 347 | 347 | { |
| 348 | 348 | $alias_map[$alias] = $short_alias; |
| 349 | 349 | $used_aliases[$short_alias] = 1; |
| 350 | 350 | return $short_alias; |
| 351 | - } else if ( ! empty($alias_map[$alias]) ) |
|
| 351 | + } else if (!empty($alias_map[$alias])) |
|
| 352 | 352 | { |
| 353 | 353 | return $alias_map[$alias]; |
| 354 | 354 | } else { |
@@ -379,7 +379,7 @@ discard block |
||
| 379 | 379 | /** @var $db DBManager */ |
| 380 | 380 | $db = $this->reporter->db; |
| 381 | 381 | $column = $this->_get_column_select($layout_def); |
| 382 | - return "(coalesce(" . $db->convert($column, "length") . ",0) > 0)\n"; |
|
| 382 | + return "(coalesce(".$db->convert($column, "length").",0) > 0)\n"; |
|
| 383 | 383 | } |
| 384 | 384 | |
| 385 | 385 | } |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -66,8 +68,7 @@ discard block |
||
| 66 | 68 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 67 | 69 | if(isset($GLOBALS['log'])) { |
| 68 | 70 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 69 | - } |
|
| 70 | - else { |
|
| 71 | + } else { |
|
| 71 | 72 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 72 | 73 | } |
| 73 | 74 | self::__construct($layout_manager); |
@@ -199,19 +200,20 @@ discard block |
||
| 199 | 200 | function queryOrderBy($layout_def) |
| 200 | 201 | { |
| 201 | 202 | $field_def = array(); |
| 202 | - if(!empty($this->reporter->all_fields[$layout_def['column_key']])) $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
|
| 203 | + if(!empty($this->reporter->all_fields[$layout_def['column_key']])) { |
|
| 204 | + $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
|
| 205 | + } |
|
| 203 | 206 | |
| 204 | 207 | if (!empty($layout_def['group_function'])) |
| 205 | 208 | { |
| 206 | 209 | $order_by = $this->_get_column_alias($layout_def); |
| 207 | - } |
|
| 208 | - elseif (!empty($field_def['sort_on'])) |
|
| 210 | + } elseif (!empty($field_def['sort_on'])) |
|
| 209 | 211 | { |
| 210 | 212 | $order_by = $layout_def['table_alias'].".".$field_def['sort_on']; |
| 211 | - if(!empty($field_def['sort_on2'])) |
|
| 212 | - $order_by .= ', ' . $layout_def['table_alias'].".".$field_def['sort_on2']; |
|
| 213 | - } |
|
| 214 | - else { |
|
| 213 | + if(!empty($field_def['sort_on2'])) { |
|
| 214 | + $order_by .= ', ' . $layout_def['table_alias'].".".$field_def['sort_on2']; |
|
| 215 | + } |
|
| 216 | + } else { |
|
| 215 | 217 | $order_by = $this->_get_column_alias($layout_def)." \n"; |
| 216 | 218 | } |
| 217 | 219 | |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -48,9 +48,9 @@ discard block |
||
| 48 | 48 | /** |
| 49 | 49 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 50 | 50 | */ |
| 51 | - public function SugarWidgetFieldEnum($layout_manager){ |
|
| 51 | + public function SugarWidgetFieldEnum($layout_manager) { |
|
| 52 | 52 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 53 | - if(isset($GLOBALS['log'])) { |
|
| 53 | + if (isset($GLOBALS['log'])) { |
|
| 54 | 54 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 55 | 55 | } |
| 56 | 56 | else { |
@@ -63,13 +63,13 @@ discard block |
||
| 63 | 63 | public function queryFilterEmpty($layout_def) |
| 64 | 64 | { |
| 65 | 65 | $column = $this->_get_column_select($layout_def); |
| 66 | - return "(coalesce(" . $this->reporter->db->convert($column, "length") . ",0) = 0 OR $column = '^^')"; |
|
| 66 | + return "(coalesce(".$this->reporter->db->convert($column, "length").",0) = 0 OR $column = '^^')"; |
|
| 67 | 67 | } |
| 68 | 68 | |
| 69 | 69 | public function queryFilterNot_Empty($layout_def) |
| 70 | 70 | { |
| 71 | 71 | $column = $this->_get_column_select($layout_def); |
| 72 | - return "(coalesce(" . $this->reporter->db->convert($column, "length") . ",0) > 0 AND $column != '^^' )\n"; |
|
| 72 | + return "(coalesce(".$this->reporter->db->convert($column, "length").",0) > 0 AND $column != '^^' )\n"; |
|
| 73 | 73 | } |
| 74 | 74 | |
| 75 | 75 | public function queryFilteris($layout_def) { |
@@ -89,7 +89,7 @@ discard block |
||
| 89 | 89 | } |
| 90 | 90 | |
| 91 | 91 | public function queryFilterone_of($layout_def) { |
| 92 | - $arr = array (); |
|
| 92 | + $arr = array(); |
|
| 93 | 93 | foreach ($layout_def['input_name0'] as $value) { |
| 94 | 94 | $arr[] = $this->reporter->db->quoted($value); |
| 95 | 95 | } |
@@ -98,7 +98,7 @@ discard block |
||
| 98 | 98 | } |
| 99 | 99 | |
| 100 | 100 | public function queryFilternot_one_of($layout_def) { |
| 101 | - $arr = array (); |
|
| 101 | + $arr = array(); |
|
| 102 | 102 | foreach ($layout_def['input_name0'] as $value) { |
| 103 | 103 | $arr[] = $this->reporter->db->quoted($value); |
| 104 | 104 | } |
@@ -108,9 +108,9 @@ discard block |
||
| 108 | 108 | } |
| 109 | 109 | |
| 110 | 110 | function & displayList($layout_def) { |
| 111 | - if(!empty($layout_def['column_key'])){ |
|
| 111 | + if (!empty($layout_def['column_key'])) { |
|
| 112 | 112 | $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
| 113 | - }else if(!empty($layout_def['fields'])){ |
|
| 113 | + } else if (!empty($layout_def['fields'])) { |
|
| 114 | 114 | $field_def = $layout_def['fields']; |
| 115 | 115 | } |
| 116 | 116 | $cell = $this->displayListPlain($layout_def); |
@@ -129,11 +129,11 @@ discard block |
||
| 129 | 129 | $record = $layout_def['fields'][$key]; |
| 130 | 130 | $field_name = $field_def['name']; |
| 131 | 131 | $field_type = $field_def['type']; |
| 132 | - $div_id = $field_def['module'] ."&$record&$field_name"; |
|
| 133 | - $str = "<div id='$div_id'>" . $cell . " " |
|
| 132 | + $div_id = $field_def['module']."&$record&$field_name"; |
|
| 133 | + $str = "<div id='$div_id'>".$cell." " |
|
| 134 | 134 | . SugarThemeRegistry::current()->getImage( |
| 135 | 135 | "edit_inline", |
| 136 | - "border='0' alt='Edit Layout' align='bottom' onClick='SUGAR.reportsInlineEdit.inlineEdit(" . |
|
| 136 | + "border='0' alt='Edit Layout' align='bottom' onClick='SUGAR.reportsInlineEdit.inlineEdit(". |
|
| 137 | 137 | "\"$div_id\",\"$cell\",\"$module\",\"$record\",\"$field_name\",\"$field_type\");'" |
| 138 | 138 | ) |
| 139 | 139 | . "</div>"; |
@@ -142,25 +142,25 @@ discard block |
||
| 142 | 142 | return $str; |
| 143 | 143 | } |
| 144 | 144 | function & displayListPlain($layout_def) { |
| 145 | - if(!empty($layout_def['column_key'])){ |
|
| 145 | + if (!empty($layout_def['column_key'])) { |
|
| 146 | 146 | $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
| 147 | - }else if(!empty($layout_def['fields'])){ |
|
| 147 | + } else if (!empty($layout_def['fields'])) { |
|
| 148 | 148 | $field_def = $layout_def['fields']; |
| 149 | 149 | } |
| 150 | 150 | |
| 151 | - if (!empty($layout_def['table_key'] ) &&( empty ($field_def['fields']) || empty ($field_def['fields'][0]) || empty ($field_def['fields'][1]))){ |
|
| 151 | + if (!empty($layout_def['table_key']) && (empty ($field_def['fields']) || empty ($field_def['fields'][0]) || empty ($field_def['fields'][1]))) { |
|
| 152 | 152 | $value = $this->_get_list_value($layout_def); |
| 153 | - }else if(!empty($layout_def['name']) && !empty($layout_def['fields'])){ |
|
| 153 | + } else if (!empty($layout_def['name']) && !empty($layout_def['fields'])) { |
|
| 154 | 154 | $key = strtoupper($layout_def['name']); |
| 155 | 155 | $value = $layout_def['fields'][$key]; |
| 156 | 156 | } |
| 157 | 157 | $cell = ''; |
| 158 | 158 | |
| 159 | - if(isset($field_def['options'])){ |
|
| 159 | + if (isset($field_def['options'])) { |
|
| 160 | 160 | $cell = translate($field_def['options'], $field_def['module'], $value); |
| 161 | - }else if(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])){ |
|
| 161 | + } else if (isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])) { |
|
| 162 | 162 | global $beanFiles; |
| 163 | - if(empty($beanFiles)) { |
|
| 163 | + if (empty($beanFiles)) { |
|
| 164 | 164 | include('include/modules.php'); |
| 165 | 165 | } |
| 166 | 166 | $bean_name = get_singular_bean_name($field_def['module']); |
@@ -172,14 +172,14 @@ discard block |
||
| 172 | 172 | |
| 173 | 173 | //#22632 |
| 174 | 174 | $value = unencodeMultienum($value); |
| 175 | - $cell=array(); |
|
| 176 | - foreach($value as $val){ |
|
| 177 | - $returnVal = translate($field_def['options'],$field_def['module'],$val); |
|
| 178 | - if(!is_array($returnVal)){ |
|
| 179 | - array_push( $cell, translate($field_def['options'],$field_def['module'],$val)); |
|
| 175 | + $cell = array(); |
|
| 176 | + foreach ($value as $val) { |
|
| 177 | + $returnVal = translate($field_def['options'], $field_def['module'], $val); |
|
| 178 | + if (!is_array($returnVal)) { |
|
| 179 | + array_push($cell, translate($field_def['options'], $field_def['module'], $val)); |
|
| 180 | 180 | } |
| 181 | 181 | } |
| 182 | - $cell = implode(", ",$cell); |
|
| 182 | + $cell = implode(", ", $cell); |
|
| 183 | 183 | } |
| 184 | 184 | return $cell; |
| 185 | 185 | } |
@@ -192,11 +192,11 @@ discard block |
||
| 192 | 192 | $order_by = $this->_get_column_select($layout_def); |
| 193 | 193 | } |
| 194 | 194 | $list = array(); |
| 195 | - if(isset($field_def['options'])) { |
|
| 195 | + if (isset($field_def['options'])) { |
|
| 196 | 196 | $list = translate($field_def['options'], $field_def['module']); |
| 197 | - } elseif(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])) { |
|
| 197 | + } elseif (isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])) { |
|
| 198 | 198 | global $beanFiles; |
| 199 | - if(empty($beanFiles)) { |
|
| 199 | + if (empty($beanFiles)) { |
|
| 200 | 200 | include('include/modules.php'); |
| 201 | 201 | } |
| 202 | 202 | $bean_name = get_singular_bean_name($field_def['module']); |
@@ -214,17 +214,17 @@ discard block |
||
| 214 | 214 | public function displayInput($layout_def) { |
| 215 | 215 | global $app_list_strings; |
| 216 | 216 | |
| 217 | - if(!empty($layout_def['remove_blank']) && $layout_def['remove_blank']) { |
|
| 218 | - if ( isset($layout_def['options']) && is_array($layout_def['options']) ) { |
|
| 217 | + if (!empty($layout_def['remove_blank']) && $layout_def['remove_blank']) { |
|
| 218 | + if (isset($layout_def['options']) && is_array($layout_def['options'])) { |
|
| 219 | 219 | $ops = $layout_def['options']; |
| 220 | 220 | } |
| 221 | - elseif (isset($layout_def['options']) && isset($app_list_strings[$layout_def['options']])){ |
|
| 221 | + elseif (isset($layout_def['options']) && isset($app_list_strings[$layout_def['options']])) { |
|
| 222 | 222 | $ops = $app_list_strings[$layout_def['options']]; |
| 223 | - if(array_key_exists('', $app_list_strings[$layout_def['options']])) { |
|
| 223 | + if (array_key_exists('', $app_list_strings[$layout_def['options']])) { |
|
| 224 | 224 | unset($ops['']); |
| 225 | 225 | } |
| 226 | 226 | } |
| 227 | - else{ |
|
| 227 | + else { |
|
| 228 | 228 | $ops = array(); |
| 229 | 229 | } |
| 230 | 230 | } |
@@ -232,7 +232,7 @@ discard block |
||
| 232 | 232 | $ops = $app_list_strings[$layout_def['options']]; |
| 233 | 233 | } |
| 234 | 234 | |
| 235 | - $str = '<select multiple="true" size="3" name="' . $layout_def['name'] . '[]">'; |
|
| 235 | + $str = '<select multiple="true" size="3" name="'.$layout_def['name'].'[]">'; |
|
| 236 | 236 | $str .= get_select_options_with_id($ops, $layout_def['input_name0']); |
| 237 | 237 | $str .= '</select>'; |
| 238 | 238 | return $str; |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -52,8 +54,7 @@ discard block |
||
| 52 | 54 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 53 | 55 | if(isset($GLOBALS['log'])) { |
| 54 | 56 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 55 | - } |
|
| 56 | - else { |
|
| 57 | + } else { |
|
| 57 | 58 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 58 | 59 | } |
| 59 | 60 | self::__construct($layout_manager); |
@@ -110,7 +111,7 @@ discard block |
||
| 110 | 111 | function & displayList($layout_def) { |
| 111 | 112 | if(!empty($layout_def['column_key'])){ |
| 112 | 113 | $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
| 113 | - }else if(!empty($layout_def['fields'])){ |
|
| 114 | + } else if(!empty($layout_def['fields'])){ |
|
| 114 | 115 | $field_def = $layout_def['fields']; |
| 115 | 116 | } |
| 116 | 117 | $cell = $this->displayListPlain($layout_def); |
@@ -144,13 +145,13 @@ discard block |
||
| 144 | 145 | function & displayListPlain($layout_def) { |
| 145 | 146 | if(!empty($layout_def['column_key'])){ |
| 146 | 147 | $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
| 147 | - }else if(!empty($layout_def['fields'])){ |
|
| 148 | + } else if(!empty($layout_def['fields'])){ |
|
| 148 | 149 | $field_def = $layout_def['fields']; |
| 149 | 150 | } |
| 150 | 151 | |
| 151 | 152 | if (!empty($layout_def['table_key'] ) &&( empty ($field_def['fields']) || empty ($field_def['fields'][0]) || empty ($field_def['fields'][1]))){ |
| 152 | 153 | $value = $this->_get_list_value($layout_def); |
| 153 | - }else if(!empty($layout_def['name']) && !empty($layout_def['fields'])){ |
|
| 154 | + } else if(!empty($layout_def['name']) && !empty($layout_def['fields'])){ |
|
| 154 | 155 | $key = strtoupper($layout_def['name']); |
| 155 | 156 | $value = $layout_def['fields'][$key]; |
| 156 | 157 | } |
@@ -158,7 +159,7 @@ discard block |
||
| 158 | 159 | |
| 159 | 160 | if(isset($field_def['options'])){ |
| 160 | 161 | $cell = translate($field_def['options'], $field_def['module'], $value); |
| 161 | - }else if(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])){ |
|
| 162 | + } else if(isset($field_def['type']) && $field_def['type'] == 'enum' && isset($field_def['function'])){ |
|
| 162 | 163 | global $beanFiles; |
| 163 | 164 | if(empty($beanFiles)) { |
| 164 | 165 | include('include/modules.php'); |
@@ -217,18 +218,15 @@ discard block |
||
| 217 | 218 | if(!empty($layout_def['remove_blank']) && $layout_def['remove_blank']) { |
| 218 | 219 | if ( isset($layout_def['options']) && is_array($layout_def['options']) ) { |
| 219 | 220 | $ops = $layout_def['options']; |
| 220 | - } |
|
| 221 | - elseif (isset($layout_def['options']) && isset($app_list_strings[$layout_def['options']])){ |
|
| 221 | + } elseif (isset($layout_def['options']) && isset($app_list_strings[$layout_def['options']])){ |
|
| 222 | 222 | $ops = $app_list_strings[$layout_def['options']]; |
| 223 | 223 | if(array_key_exists('', $app_list_strings[$layout_def['options']])) { |
| 224 | 224 | unset($ops['']); |
| 225 | 225 | } |
| 226 | - } |
|
| 227 | - else{ |
|
| 226 | + } else{ |
|
| 228 | 227 | $ops = array(); |
| 229 | 228 | } |
| 230 | - } |
|
| 231 | - else { |
|
| 229 | + } else { |
|
| 232 | 230 | $ops = $app_list_strings[$layout_def['options']]; |
| 233 | 231 | } |
| 234 | 232 | |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -48,13 +48,13 @@ discard block |
||
| 48 | 48 | |
| 49 | 49 | function get_currency() |
| 50 | 50 | { |
| 51 | - global $current_user,$global_currency_obj; |
|
| 51 | + global $current_user, $global_currency_obj; |
|
| 52 | 52 | if (empty($global_currency_obj)) |
| 53 | 53 | { |
| 54 | 54 | $global_currency_obj = new Currency(); |
| 55 | 55 | // $global_currency_symbol = '$'; |
| 56 | 56 | |
| 57 | - if($current_user->getPreference('currency') ) |
|
| 57 | + if ($current_user->getPreference('currency')) |
|
| 58 | 58 | { |
| 59 | 59 | $global_currency_obj->retrieve($current_user->getPreference('currency')); |
| 60 | 60 | } |
@@ -77,9 +77,9 @@ discard block |
||
| 77 | 77 | /** |
| 78 | 78 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 79 | 79 | */ |
| 80 | - function SugarWidgetFieldCurrency(&$layout_manager){ |
|
| 80 | + function SugarWidgetFieldCurrency(&$layout_manager) { |
|
| 81 | 81 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 82 | - if(isset($GLOBALS['log'])) { |
|
| 82 | + if (isset($GLOBALS['log'])) { |
|
| 83 | 83 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 84 | 84 | } |
| 85 | 85 | else { |
@@ -97,9 +97,9 @@ discard block |
||
| 97 | 97 | $currency_id = $locale->getPrecedentPreference('currency'); |
| 98 | 98 | |
| 99 | 99 | // If it's not grouped, or if it's grouped around a system currency column, look up the currency symbol so we can display it next to the amount |
| 100 | - if ( empty($layout_def['group_function']) || $this->isSystemCurrency($layout_def) ) { |
|
| 100 | + if (empty($layout_def['group_function']) || $this->isSystemCurrency($layout_def)) { |
|
| 101 | 101 | $c = $this->getCurrency($layout_def); |
| 102 | - if(!empty($c['currency_id']) && !empty($c['currency_symbol'])) |
|
| 102 | + if (!empty($c['currency_id']) && !empty($c['currency_symbol'])) |
|
| 103 | 103 | { |
| 104 | 104 | $symbol = $c['currency_symbol']; |
| 105 | 105 | $currency_id = $c['currency_id']; |
@@ -109,15 +109,15 @@ discard block |
||
| 109 | 109 | $layout_def['currency_id'] = $currency_id; |
| 110 | 110 | $display = $this->displayListPlain($layout_def); |
| 111 | 111 | |
| 112 | - if(!empty($layout_def['column_key'])){ |
|
| 112 | + if (!empty($layout_def['column_key'])) { |
|
| 113 | 113 | $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
| 114 | - }else if(!empty($layout_def['fields'])){ |
|
| 114 | + } else if (!empty($layout_def['fields'])) { |
|
| 115 | 115 | $field_def = $layout_def['fields']; |
| 116 | 116 | } |
| 117 | 117 | $record = ''; |
| 118 | 118 | if ($layout_def['table_key'] == 'self' && isset($layout_def['fields']['PRIMARYID'])) |
| 119 | 119 | $record = $layout_def['fields']['PRIMARYID']; |
| 120 | - else if (isset($layout_def['fields'][strtoupper($layout_def['table_alias']."_id")])){ |
|
| 120 | + else if (isset($layout_def['fields'][strtoupper($layout_def['table_alias']."_id")])) { |
|
| 121 | 121 | $record = $layout_def['fields'][strtoupper($layout_def['table_alias']."_id")]; |
| 122 | 122 | } |
| 123 | 123 | if (!empty($record)) { |
@@ -125,11 +125,11 @@ discard block |
||
| 125 | 125 | $field_type = $field_def['type']; |
| 126 | 126 | $module = $field_def['module']; |
| 127 | 127 | |
| 128 | - $div_id = $module ."&$record&$field_name"; |
|
| 128 | + $div_id = $module."&$record&$field_name"; |
|
| 129 | 129 | $str = "<div id='$div_id'>".$display; |
| 130 | 130 | global $sugar_config; |
| 131 | 131 | if (isset ($sugar_config['enable_inline_reports_edit']) && $sugar_config['enable_inline_reports_edit']) { |
| 132 | - $str .= " " .SugarThemeRegistry::current()->getImage("edit_inline","border='0' alt='Edit Layout' align='bottom' onClick='SUGAR.reportsInlineEdit.inlineEdit(\"$div_id\",\"$value\",\"$module\",\"$record\",\"$field_name\",\"$field_type\",\"$currency_id\",\"$symbol\");'"); |
|
| 132 | + $str .= " ".SugarThemeRegistry::current()->getImage("edit_inline", "border='0' alt='Edit Layout' align='bottom' onClick='SUGAR.reportsInlineEdit.inlineEdit(\"$div_id\",\"$value\",\"$module\",\"$record\",\"$field_name\",\"$field_type\",\"$currency_id\",\"$symbol\");'"); |
|
| 133 | 133 | } |
| 134 | 134 | $str .= "</div>"; |
| 135 | 135 | return $str; |
@@ -170,13 +170,13 @@ discard block |
||
| 170 | 170 | return $this->_get_column_select($layout_def)." < ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))."\n"; |
| 171 | 171 | } |
| 172 | 172 | |
| 173 | - function queryFilterBetween(&$layout_def){ |
|
| 174 | - return $this->_get_column_select($layout_def)." > ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0'])). " AND ". $this->_get_column_select($layout_def)." < ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name1']))."\n"; |
|
| 173 | + function queryFilterBetween(&$layout_def) { |
|
| 174 | + return $this->_get_column_select($layout_def)." > ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name0']))." AND ".$this->_get_column_select($layout_def)." < ".$GLOBALS['db']->quote(unformat_number($layout_def['input_name1']))."\n"; |
|
| 175 | 175 | } |
| 176 | 176 | |
| 177 | 177 | function isSystemCurrency(&$layout_def) |
| 178 | 178 | { |
| 179 | - if (strpos($layout_def['name'],'_usdoll') === false) { |
|
| 179 | + if (strpos($layout_def['name'], '_usdoll') === false) { |
|
| 180 | 180 | return false; |
| 181 | 181 | } else { |
| 182 | 182 | return true; |
@@ -187,8 +187,8 @@ discard block |
||
| 187 | 187 | { |
| 188 | 188 | // add currency column to select |
| 189 | 189 | $table = $this->getCurrencyIdTable($layout_def); |
| 190 | - if($table) { |
|
| 191 | - return $this->_get_column_select($layout_def)." ".$this->_get_column_alias($layout_def)." , ".$table.".currency_id ". $this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency") . "\n"; |
|
| 190 | + if ($table) { |
|
| 191 | + return $this->_get_column_select($layout_def)." ".$this->_get_column_alias($layout_def)." , ".$table.".currency_id ".$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")."\n"; |
|
| 192 | 192 | } |
| 193 | 193 | return $this->_get_column_select($layout_def)." ".$this->_get_column_alias($layout_def)."\n"; |
| 194 | 194 | } |
@@ -197,7 +197,7 @@ discard block |
||
| 197 | 197 | { |
| 198 | 198 | // add currency column to group by |
| 199 | 199 | $table = $this->getCurrencyIdTable($layout_def); |
| 200 | - if($table) { |
|
| 200 | + if ($table) { |
|
| 201 | 201 | return $this->_get_column_select($layout_def)." , ".$table.".currency_id \n"; |
| 202 | 202 | } |
| 203 | 203 | return $this->_get_column_select($layout_def)." \n"; |
@@ -206,9 +206,9 @@ discard block |
||
| 206 | 206 | function getCurrencyIdTable($layout_def) |
| 207 | 207 | { |
| 208 | 208 | // We need to fetch the currency id as well |
| 209 | - if ( !$this->isSystemCurrency($layout_def) && empty($layout_def['group_function'])) { |
|
| 209 | + if (!$this->isSystemCurrency($layout_def) && empty($layout_def['group_function'])) { |
|
| 210 | 210 | |
| 211 | - if ( !empty($layout_def['table_alias']) ) { |
|
| 211 | + if (!empty($layout_def['table_alias'])) { |
|
| 212 | 212 | $table = $layout_def['table_alias']; |
| 213 | 213 | } else { |
| 214 | 214 | $table = ''; |
@@ -219,16 +219,16 @@ discard block |
||
| 219 | 219 | $real_table = $this->reporter->all_fields[$layout_def['column_key']]['real_table']; |
| 220 | 220 | |
| 221 | 221 | $add_currency_id = false; |
| 222 | - if(!empty($table)) { |
|
| 222 | + if (!empty($table)) { |
|
| 223 | 223 | $cols = $GLOBALS['db']->getHelper()->get_columns($real_table); |
| 224 | 224 | $add_currency_id = isset($cols['currency_id']) ? true : false; |
| 225 | 225 | |
| 226 | - if(!$add_currency_id && preg_match('/.*?_cstm$/i', $real_table)) { |
|
| 226 | + if (!$add_currency_id && preg_match('/.*?_cstm$/i', $real_table)) { |
|
| 227 | 227 | $table = str_replace('_cstm', '', $table); |
| 228 | 228 | $cols = $GLOBALS['db']->getHelper()->get_columns($table); |
| 229 | 229 | $add_currency_id = isset($cols['currency_id']) ? true : false; |
| 230 | 230 | } |
| 231 | - if($add_currency_id) { |
|
| 231 | + if ($add_currency_id) { |
|
| 232 | 232 | return $table; |
| 233 | 233 | } |
| 234 | 234 | } |
@@ -245,7 +245,7 @@ discard block |
||
| 245 | 245 | { |
| 246 | 246 | $currency_id = false; |
| 247 | 247 | $currency_symbol = false; |
| 248 | - if(isset($layout_def['currency_symbol']) && isset($layout_def['currency_id'])) |
|
| 248 | + if (isset($layout_def['currency_symbol']) && isset($layout_def['currency_id'])) |
|
| 249 | 249 | { |
| 250 | 250 | $currency_symbol = $layout_def['currency_symbol']; |
| 251 | 251 | $currency_id = $layout_def['currency_id']; |
@@ -253,7 +253,7 @@ discard block |
||
| 253 | 253 | else |
| 254 | 254 | { |
| 255 | 255 | $key = strtoupper(isset($layout_def['varname']) ? $layout_def['varname'] : $this->_get_column_alias($layout_def)); |
| 256 | - if ( $this->isSystemCurrency($layout_def) ) |
|
| 256 | + if ($this->isSystemCurrency($layout_def)) |
|
| 257 | 257 | { |
| 258 | 258 | $currency_id = '-99'; |
| 259 | 259 | } |
@@ -261,14 +261,14 @@ discard block |
||
| 261 | 261 | { |
| 262 | 262 | $currency_id = $layout_def['fields'][$key.'_CURRENCY']; |
| 263 | 263 | } |
| 264 | - elseif(isset($layout_def['fields'][$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")])) |
|
| 264 | + elseif (isset($layout_def['fields'][$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")])) |
|
| 265 | 265 | { |
| 266 | 266 | $currency_id = $layout_def['fields'][$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")]; |
| 267 | 267 | } |
| 268 | - if($currency_id) |
|
| 268 | + if ($currency_id) |
|
| 269 | 269 | { |
| 270 | 270 | $currency = BeanFactory::getBean('Currencies', $currency_id); |
| 271 | - if(!empty($currency ->symbol)) |
|
| 271 | + if (!empty($currency ->symbol)) |
|
| 272 | 272 | { |
| 273 | 273 | $currency_symbol = $currency ->symbol; |
| 274 | 274 | } |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -57,8 +59,7 @@ discard block |
||
| 57 | 59 | if($current_user->getPreference('currency') ) |
| 58 | 60 | { |
| 59 | 61 | $global_currency_obj->retrieve($current_user->getPreference('currency')); |
| 60 | - } |
|
| 61 | - else |
|
| 62 | + } else |
|
| 62 | 63 | { |
| 63 | 64 | $global_currency_obj->retrieve('-99'); |
| 64 | 65 | } |
@@ -81,8 +82,7 @@ discard block |
||
| 81 | 82 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 82 | 83 | if(isset($GLOBALS['log'])) { |
| 83 | 84 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 84 | - } |
|
| 85 | - else { |
|
| 85 | + } else { |
|
| 86 | 86 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 87 | 87 | } |
| 88 | 88 | self::__construct($layout_manager); |
@@ -111,13 +111,13 @@ discard block |
||
| 111 | 111 | |
| 112 | 112 | if(!empty($layout_def['column_key'])){ |
| 113 | 113 | $field_def = $this->reporter->all_fields[$layout_def['column_key']]; |
| 114 | - }else if(!empty($layout_def['fields'])){ |
|
| 114 | + } else if(!empty($layout_def['fields'])){ |
|
| 115 | 115 | $field_def = $layout_def['fields']; |
| 116 | 116 | } |
| 117 | 117 | $record = ''; |
| 118 | - if ($layout_def['table_key'] == 'self' && isset($layout_def['fields']['PRIMARYID'])) |
|
| 119 | - $record = $layout_def['fields']['PRIMARYID']; |
|
| 120 | - else if (isset($layout_def['fields'][strtoupper($layout_def['table_alias']."_id")])){ |
|
| 118 | + if ($layout_def['table_key'] == 'self' && isset($layout_def['fields']['PRIMARYID'])) { |
|
| 119 | + $record = $layout_def['fields']['PRIMARYID']; |
|
| 120 | + } else if (isset($layout_def['fields'][strtoupper($layout_def['table_alias']."_id")])){ |
|
| 121 | 121 | $record = $layout_def['fields'][strtoupper($layout_def['table_alias']."_id")]; |
| 122 | 122 | } |
| 123 | 123 | if (!empty($record)) { |
@@ -133,9 +133,9 @@ discard block |
||
| 133 | 133 | } |
| 134 | 134 | $str .= "</div>"; |
| 135 | 135 | return $str; |
| 136 | + } else { |
|
| 137 | + return $display; |
|
| 136 | 138 | } |
| 137 | - else |
|
| 138 | - return $display; |
|
| 139 | 139 | } |
| 140 | 140 | |
| 141 | 141 | function displayListPlain($layout_def) { |
@@ -215,8 +215,9 @@ discard block |
||
| 215 | 215 | } |
| 216 | 216 | |
| 217 | 217 | $real_table = ''; |
| 218 | - if (!empty($this->reporter->all_fields[$layout_def['column_key']]['real_table'])) |
|
| 219 | - $real_table = $this->reporter->all_fields[$layout_def['column_key']]['real_table']; |
|
| 218 | + if (!empty($this->reporter->all_fields[$layout_def['column_key']]['real_table'])) { |
|
| 219 | + $real_table = $this->reporter->all_fields[$layout_def['column_key']]['real_table']; |
|
| 220 | + } |
|
| 220 | 221 | |
| 221 | 222 | $add_currency_id = false; |
| 222 | 223 | if(!empty($table)) { |
@@ -249,19 +250,16 @@ discard block |
||
| 249 | 250 | { |
| 250 | 251 | $currency_symbol = $layout_def['currency_symbol']; |
| 251 | 252 | $currency_id = $layout_def['currency_id']; |
| 252 | - } |
|
| 253 | - else |
|
| 253 | + } else |
|
| 254 | 254 | { |
| 255 | 255 | $key = strtoupper(isset($layout_def['varname']) ? $layout_def['varname'] : $this->_get_column_alias($layout_def)); |
| 256 | 256 | if ( $this->isSystemCurrency($layout_def) ) |
| 257 | 257 | { |
| 258 | 258 | $currency_id = '-99'; |
| 259 | - } |
|
| 260 | - elseif (isset($layout_def['fields'][$key.'_CURRENCY'])) |
|
| 259 | + } elseif (isset($layout_def['fields'][$key.'_CURRENCY'])) |
|
| 261 | 260 | { |
| 262 | 261 | $currency_id = $layout_def['fields'][$key.'_CURRENCY']; |
| 263 | - } |
|
| 264 | - elseif(isset($layout_def['fields'][$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")])) |
|
| 262 | + } elseif(isset($layout_def['fields'][$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")])) |
|
| 265 | 263 | { |
| 266 | 264 | $currency_id = $layout_def['fields'][$this->getTruncatedColumnAlias($this->_get_column_alias($layout_def)."_currency")]; |
| 267 | 265 | } |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -46,17 +46,17 @@ discard block |
||
| 46 | 46 | class SugarWidgetSubPanelTopSelectUsersButton extends SugarWidgetSubPanelTopSelectButton |
| 47 | 47 | { |
| 48 | 48 | //button_properties is a collection of properties associated with the widget_class definition. layoutmanager |
| 49 | - function __construct($button_properties=array()) |
|
| 49 | + function __construct($button_properties = array()) |
|
| 50 | 50 | { |
| 51 | - $this->button_properties=$button_properties; |
|
| 51 | + $this->button_properties = $button_properties; |
|
| 52 | 52 | } |
| 53 | 53 | |
| 54 | 54 | /** |
| 55 | 55 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 56 | 56 | */ |
| 57 | - function SugarWidgetSubPanelTopSelectUsersButton($button_properties=array()){ |
|
| 57 | + function SugarWidgetSubPanelTopSelectUsersButton($button_properties = array()) { |
|
| 58 | 58 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 59 | - if(isset($GLOBALS['log'])) { |
|
| 59 | + if (isset($GLOBALS['log'])) { |
|
| 60 | 60 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 61 | 61 | } |
| 62 | 62 | else { |
@@ -83,32 +83,32 @@ discard block |
||
| 83 | 83 | $this->module_name = 'Users'; |
| 84 | 84 | |
| 85 | 85 | if (is_array($this->button_properties)) { |
| 86 | - if( isset($this->button_properties['title'])) { |
|
| 86 | + if (isset($this->button_properties['title'])) { |
|
| 87 | 87 | $this->title = $app_strings[$this->button_properties['title']]; |
| 88 | 88 | } |
| 89 | - if( isset($this->button_properties['accesskey'])) { |
|
| 89 | + if (isset($this->button_properties['accesskey'])) { |
|
| 90 | 90 | //$this->accesskey = $app_strings[$this->button_properties['accesskey']]; |
| 91 | 91 | } |
| 92 | - if( isset($this->button_properties['form_value'])) { |
|
| 92 | + if (isset($this->button_properties['form_value'])) { |
|
| 93 | 93 | $this->value = $app_strings[$this->button_properties['form_value']]; |
| 94 | 94 | } |
| 95 | - if( isset($this->button_properties['module'])) { |
|
| 95 | + if (isset($this->button_properties['module'])) { |
|
| 96 | 96 | $this->module_name = $this->button_properties['module']; |
| 97 | 97 | } |
| 98 | 98 | } |
| 99 | 99 | |
| 100 | 100 | $focus = $widget_data['focus']; |
| 101 | - if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){ |
|
| 102 | - $button = ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n" |
|
| 103 | - . ' title="' . $this->title . '"' |
|
| 104 | - . ' value="' . $this->value . "\"\n" |
|
| 101 | + if (ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)) { |
|
| 102 | + $button = ' <input type="button" name="'.$this->getWidgetId().'" id="'.$this->getWidgetId().'" class="button"'."\"\n" |
|
| 103 | + . ' title="'.$this->title.'"' |
|
| 104 | + . ' value="'.$this->value."\"\n" |
|
| 105 | 105 | .' disabled />'; |
| 106 | 106 | return $button; |
| 107 | 107 | } |
| 108 | 108 | |
| 109 | 109 | //refresh the whole page after end of action? |
| 110 | 110 | $refresh_page = 0; |
| 111 | - if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){ |
|
| 111 | + if (!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])) { |
|
| 112 | 112 | $refresh_page = 1; |
| 113 | 113 | } |
| 114 | 114 | |
@@ -120,43 +120,43 @@ discard block |
||
| 120 | 120 | $this->module_name = $subpanel_name; |
| 121 | 121 | } |
| 122 | 122 | |
| 123 | - if ($subpanel_name == 'Project'){ |
|
| 123 | + if ($subpanel_name == 'Project') { |
|
| 124 | 124 | $link_field_name = 'project_users_1'; |
| 125 | 125 | } |
| 126 | - else{ |
|
| 126 | + else { |
|
| 127 | 127 | $link_field_name = $subpanel_definition->get_data_source_name(true); |
| 128 | 128 | } |
| 129 | 129 | |
| 130 | - $popup_mode='Single'; |
|
| 131 | - if(isset($widget_data['mode'])){ |
|
| 132 | - $popup_mode=$widget_data['mode']; |
|
| 130 | + $popup_mode = 'Single'; |
|
| 131 | + if (isset($widget_data['mode'])) { |
|
| 132 | + $popup_mode = $widget_data['mode']; |
|
| 133 | 133 | } |
| 134 | - if(isset($widget_data['initial_filter_fields'])){ |
|
| 134 | + if (isset($widget_data['initial_filter_fields'])) { |
|
| 135 | 135 | if (is_array($widget_data['initial_filter_fields'])) { |
| 136 | 136 | foreach ($widget_data['initial_filter_fields'] as $value=>$alias) { |
| 137 | 137 | if (isset($focus->$value) and !empty($focus->$value)) { |
| 138 | - $initial_filter.="&".$alias . '='.urlencode($focus->$value); |
|
| 138 | + $initial_filter .= "&".$alias.'='.urlencode($focus->$value); |
|
| 139 | 139 | } |
| 140 | 140 | } |
| 141 | 141 | } |
| 142 | 142 | } |
| 143 | 143 | |
| 144 | 144 | if (!empty($widget_data['filter_out_is_admin'])) { |
| 145 | - $initial_filter.="&is_admin_advanced=0"; |
|
| 145 | + $initial_filter .= "&is_admin_advanced=0"; |
|
| 146 | 146 | } |
| 147 | 147 | |
| 148 | - $create="true"; |
|
| 149 | - if(isset($widget_data['create'])){ |
|
| 150 | - $create=$widget_data['create']; |
|
| 148 | + $create = "true"; |
|
| 149 | + if (isset($widget_data['create'])) { |
|
| 150 | + $create = $widget_data['create']; |
|
| 151 | 151 | } |
| 152 | 152 | $return_module = $_REQUEST['module']; |
| 153 | 153 | $return_action = 'SubPanelViewer'; |
| 154 | 154 | $return_id = $_REQUEST['record']; |
| 155 | 155 | |
| 156 | 156 | //field_to_name_array |
| 157 | - $fton_array= array('id' => 'subpanel_id'); |
|
| 158 | - if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){ |
|
| 159 | - $fton_array=array_merge($fton_array,$widget_data['field_to_name_array']); |
|
| 157 | + $fton_array = array('id' => 'subpanel_id'); |
|
| 158 | + if (isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])) { |
|
| 159 | + $fton_array = array_merge($fton_array, $widget_data['field_to_name_array']); |
|
| 160 | 160 | } |
| 161 | 161 | |
| 162 | 162 | $return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1"; |
@@ -175,21 +175,21 @@ discard block |
||
| 175 | 175 | ); |
| 176 | 176 | |
| 177 | 177 | if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data'])) { |
| 178 | - $popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']); |
|
| 178 | + $popup_request_data['passthru_data'] = array_merge($popup_request_data['passthru_data'], $this->button_properties['add_to_passthru_data']); |
|
| 179 | 179 | } |
| 180 | 180 | |
| 181 | 181 | if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) { |
| 182 | 182 | |
| 183 | - if ($this->button_properties['add_to_passthru_data']['return_type']=='report') { |
|
| 184 | - $initial_filter = "&module_name=". urlencode($widget_data['module']); |
|
| 183 | + if ($this->button_properties['add_to_passthru_data']['return_type'] == 'report') { |
|
| 184 | + $initial_filter = "&module_name=".urlencode($widget_data['module']); |
|
| 185 | 185 | } |
| 186 | 186 | } |
| 187 | 187 | $json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data); |
| 188 | 188 | |
| 189 | - return '<form action="index.php">' . "\n" |
|
| 190 | - . ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n" |
|
| 191 | - . ' title="' . $this->title . '"' |
|
| 192 | - . ' value="' . $this->value . "\"\n" |
|
| 189 | + return '<form action="index.php">'."\n" |
|
| 190 | + . ' <input type="button" name="'.$this->getWidgetId().'" id="'.$this->getWidgetId().'" class="button"'."\"\n" |
|
| 191 | + . ' title="'.$this->title.'"' |
|
| 192 | + . ' value="'.$this->value."\"\n" |
|
| 193 | 193 | . " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' /></form>\n"; |
| 194 | 194 | } |
| 195 | 195 | } |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -58,8 +60,7 @@ discard block |
||
| 58 | 60 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 59 | 61 | if(isset($GLOBALS['log'])) { |
| 60 | 62 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 61 | - } |
|
| 62 | - else { |
|
| 63 | + } else { |
|
| 63 | 64 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 64 | 65 | } |
| 65 | 66 | self::__construct($button_properties); |
@@ -123,8 +124,7 @@ discard block |
||
| 123 | 124 | |
| 124 | 125 | if ($subpanel_name == 'Project'){ |
| 125 | 126 | $link_field_name = 'project_contacts_1'; |
| 126 | - } |
|
| 127 | - else{ |
|
| 127 | + } else{ |
|
| 128 | 128 | $link_field_name = $subpanel_definition->get_data_source_name(true); |
| 129 | 129 | } |
| 130 | 130 | |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -58,9 +58,9 @@ discard block |
||
| 58 | 58 | /** |
| 59 | 59 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 60 | 60 | */ |
| 61 | - function SugarWidgetFieldLong(&$layout_manager){ |
|
| 61 | + function SugarWidgetFieldLong(&$layout_manager) { |
|
| 62 | 62 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 63 | - if(isset($GLOBALS['log'])) { |
|
| 63 | + if (isset($GLOBALS['log'])) { |
|
| 64 | 64 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 65 | 65 | } |
| 66 | 66 | else { |
@@ -43,7 +43,9 @@ discard block |
||
| 43 | 43 | * Date: 06/03/15 |
| 44 | 44 | * Comments |
| 45 | 45 | */ |
| 46 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 46 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 47 | + die('Not A Valid Entry Point'); |
|
| 48 | +} |
|
| 47 | 49 | |
| 48 | 50 | class CasesController extends SugarController { |
| 49 | 51 | |
@@ -90,8 +92,7 @@ discard block |
||
| 90 | 92 | $count++; |
| 91 | 93 | } |
| 92 | 94 | echo '</table>'; |
| 93 | - } |
|
| 94 | - else { |
|
| 95 | + } else { |
|
| 95 | 96 | echo $mod_strings['LBL_NO_SUGGESTIONS']; |
| 96 | 97 | } |
| 97 | 98 | die(); |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | /********************************************************************************* |
| 4 | 4 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 5 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -46,17 +46,17 @@ discard block |
||
| 46 | 46 | class SugarWidgetSubPanelTopSelectContactsButton extends SugarWidgetSubPanelTopSelectButton |
| 47 | 47 | { |
| 48 | 48 | //button_properties is a collection of properties associated with the widget_class definition. layoutmanager |
| 49 | - function __construct($button_properties=array()) |
|
| 49 | + function __construct($button_properties = array()) |
|
| 50 | 50 | { |
| 51 | - $this->button_properties=$button_properties; |
|
| 51 | + $this->button_properties = $button_properties; |
|
| 52 | 52 | } |
| 53 | 53 | |
| 54 | 54 | /** |
| 55 | 55 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 56 | 56 | */ |
| 57 | - function SugarWidgetSubPanelTopSelectContactsButton($button_properties=array()){ |
|
| 57 | + function SugarWidgetSubPanelTopSelectContactsButton($button_properties = array()) { |
|
| 58 | 58 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 59 | - if(isset($GLOBALS['log'])) { |
|
| 59 | + if (isset($GLOBALS['log'])) { |
|
| 60 | 60 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 61 | 61 | } |
| 62 | 62 | else { |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | |
| 69 | 69 | public function getWidgetId($buttonSuffix = true) |
| 70 | 70 | { |
| 71 | - return parent::getWidgetId() . '_select_button'; |
|
| 71 | + return parent::getWidgetId().'_select_button'; |
|
| 72 | 72 | } |
| 73 | 73 | |
| 74 | 74 | //widget_data is the collection of attributes associated with the button in the layout_defs file. |
@@ -84,32 +84,32 @@ discard block |
||
| 84 | 84 | $this->module_name = 'Contacts'; |
| 85 | 85 | |
| 86 | 86 | if (is_array($this->button_properties)) { |
| 87 | - if( isset($this->button_properties['title'])) { |
|
| 87 | + if (isset($this->button_properties['title'])) { |
|
| 88 | 88 | $this->title = $app_strings[$this->button_properties['title']]; |
| 89 | 89 | } |
| 90 | - if( isset($this->button_properties['accesskey'])) { |
|
| 90 | + if (isset($this->button_properties['accesskey'])) { |
|
| 91 | 91 | //$this->accesskey = $app_strings[$this->button_properties['accesskey']]; |
| 92 | 92 | } |
| 93 | - if( isset($this->button_properties['form_value'])) { |
|
| 93 | + if (isset($this->button_properties['form_value'])) { |
|
| 94 | 94 | $this->value = $app_strings[$this->button_properties['form_value']]; |
| 95 | 95 | } |
| 96 | - if( isset($this->button_properties['module'])) { |
|
| 96 | + if (isset($this->button_properties['module'])) { |
|
| 97 | 97 | $this->module_name = $this->button_properties['module']; |
| 98 | 98 | } |
| 99 | 99 | } |
| 100 | 100 | |
| 101 | 101 | $focus = $widget_data['focus']; |
| 102 | - if(ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)){ |
|
| 103 | - $button = ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n" |
|
| 104 | - . ' title="' . $this->title . '"' |
|
| 105 | - . ' value="' . $this->value . "\"\n" |
|
| 102 | + if (ACLController::moduleSupportsACL($widget_data['module']) && !ACLController::checkAccess($widget_data['module'], 'list', true)) { |
|
| 103 | + $button = ' <input type="button" name="'.$this->getWidgetId().'" id="'.$this->getWidgetId().'" class="button"'."\"\n" |
|
| 104 | + . ' title="'.$this->title.'"' |
|
| 105 | + . ' value="'.$this->value."\"\n" |
|
| 106 | 106 | .' disabled />'; |
| 107 | 107 | return $button; |
| 108 | 108 | } |
| 109 | 109 | |
| 110 | 110 | //refresh the whole page after end of action? |
| 111 | 111 | $refresh_page = 0; |
| 112 | - if(!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])){ |
|
| 112 | + if (!empty($widget_data['subpanel_definition']->_instance_properties['refresh_page'])) { |
|
| 113 | 113 | $refresh_page = 1; |
| 114 | 114 | } |
| 115 | 115 | |
@@ -121,38 +121,38 @@ discard block |
||
| 121 | 121 | $this->module_name = $subpanel_name; |
| 122 | 122 | } |
| 123 | 123 | |
| 124 | - if ($subpanel_name == 'Project'){ |
|
| 124 | + if ($subpanel_name == 'Project') { |
|
| 125 | 125 | $link_field_name = 'project_contacts_1'; |
| 126 | 126 | } |
| 127 | - else{ |
|
| 127 | + else { |
|
| 128 | 128 | $link_field_name = $subpanel_definition->get_data_source_name(true); |
| 129 | 129 | } |
| 130 | 130 | |
| 131 | - $popup_mode='Single'; |
|
| 132 | - if(isset($widget_data['mode'])){ |
|
| 133 | - $popup_mode=$widget_data['mode']; |
|
| 131 | + $popup_mode = 'Single'; |
|
| 132 | + if (isset($widget_data['mode'])) { |
|
| 133 | + $popup_mode = $widget_data['mode']; |
|
| 134 | 134 | } |
| 135 | - if(isset($widget_data['initial_filter_fields'])){ |
|
| 135 | + if (isset($widget_data['initial_filter_fields'])) { |
|
| 136 | 136 | if (is_array($widget_data['initial_filter_fields'])) { |
| 137 | 137 | foreach ($widget_data['initial_filter_fields'] as $value=>$alias) { |
| 138 | 138 | if (isset($focus->$value) and !empty($focus->$value)) { |
| 139 | - $initial_filter.="&".$alias . '='.urlencode($focus->$value); |
|
| 139 | + $initial_filter .= "&".$alias.'='.urlencode($focus->$value); |
|
| 140 | 140 | } |
| 141 | 141 | } |
| 142 | 142 | } |
| 143 | 143 | } |
| 144 | - $create="true"; |
|
| 145 | - if(isset($widget_data['create'])){ |
|
| 146 | - $create=$widget_data['create']; |
|
| 144 | + $create = "true"; |
|
| 145 | + if (isset($widget_data['create'])) { |
|
| 146 | + $create = $widget_data['create']; |
|
| 147 | 147 | } |
| 148 | 148 | $return_module = $_REQUEST['module']; |
| 149 | 149 | $return_action = 'SubPanelViewer'; |
| 150 | 150 | $return_id = $_REQUEST['record']; |
| 151 | 151 | |
| 152 | 152 | //field_to_name_array |
| 153 | - $fton_array= array('id' => 'subpanel_id'); |
|
| 154 | - if(isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])){ |
|
| 155 | - $fton_array=array_merge($fton_array,$widget_data['field_to_name_array']); |
|
| 153 | + $fton_array = array('id' => 'subpanel_id'); |
|
| 154 | + if (isset($widget_data['field_to_name_array']) && is_array($widget_data['field_to_name_array'])) { |
|
| 155 | + $fton_array = array_merge($fton_array, $widget_data['field_to_name_array']); |
|
| 156 | 156 | } |
| 157 | 157 | |
| 158 | 158 | $return_url = "index.php?module=$return_module&action=$return_action&subpanel=$subpanel_name&record=$return_id&sugar_body_only=1"; |
@@ -171,21 +171,21 @@ discard block |
||
| 171 | 171 | ); |
| 172 | 172 | |
| 173 | 173 | if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data'])) { |
| 174 | - $popup_request_data['passthru_data']= array_merge($popup_request_data['passthru_data'],$this->button_properties['add_to_passthru_data']); |
|
| 174 | + $popup_request_data['passthru_data'] = array_merge($popup_request_data['passthru_data'], $this->button_properties['add_to_passthru_data']); |
|
| 175 | 175 | } |
| 176 | 176 | |
| 177 | 177 | if (is_array($this->button_properties) && !empty($this->button_properties['add_to_passthru_data']['return_type'])) { |
| 178 | 178 | |
| 179 | - if ($this->button_properties['add_to_passthru_data']['return_type']=='report') { |
|
| 180 | - $initial_filter = "&module_name=". urlencode($widget_data['module']); |
|
| 179 | + if ($this->button_properties['add_to_passthru_data']['return_type'] == 'report') { |
|
| 180 | + $initial_filter = "&module_name=".urlencode($widget_data['module']); |
|
| 181 | 181 | } |
| 182 | 182 | } |
| 183 | 183 | $json_encoded_php_array = $this->_create_json_encoded_popup_request($popup_request_data); |
| 184 | 184 | |
| 185 | - return '<form action="index.php">' . "\n" |
|
| 186 | - . ' <input type="button" name="' .$this->getWidgetId() . '" id="' .$this->getWidgetId() . '" class="button"' . "\"\n" |
|
| 187 | - . ' title="' . $this->title . '"' |
|
| 188 | - . ' value="' . $this->value . "\"\n" |
|
| 185 | + return '<form action="index.php">'."\n" |
|
| 186 | + . ' <input type="button" name="'.$this->getWidgetId().'" id="'.$this->getWidgetId().'" class="button"'."\"\n" |
|
| 187 | + . ' title="'.$this->title.'"' |
|
| 188 | + . ' value="'.$this->value."\"\n" |
|
| 189 | 189 | . " onclick='open_popup(\"$this->module_name\",600,400,\"$initial_filter\",true,true,$json_encoded_php_array,\"$popup_mode\",$create);' /></form>\n"; |
| 190 | 190 | } |
| 191 | 191 | } |
@@ -1,5 +1,7 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 3 | + die('Not A Valid Entry Point'); |
|
| 4 | +} |
|
| 3 | 5 | /********************************************************************************* |
| 4 | 6 | * SugarCRM Community Edition is a customer relationship management program developed by |
| 5 | 7 | * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
@@ -58,8 +60,7 @@ discard block |
||
| 58 | 60 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 59 | 61 | if(isset($GLOBALS['log'])) { |
| 60 | 62 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 61 | - } |
|
| 62 | - else { |
|
| 63 | + } else { |
|
| 63 | 64 | trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
| 64 | 65 | } |
| 65 | 66 | self::__construct($button_properties); |
@@ -123,8 +124,7 @@ discard block |
||
| 123 | 124 | |
| 124 | 125 | if ($subpanel_name == 'Project'){ |
| 125 | 126 | $link_field_name = 'project_contacts_1'; |
| 126 | - } |
|
| 127 | - else{ |
|
| 127 | + } else{ |
|
| 128 | 128 | $link_field_name = $subpanel_definition->get_data_source_name(true); |
| 129 | 129 | } |
| 130 | 130 | |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 2 | +if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 3 | 3 | class SugarWidgetFieldCronSchedule extends SugarWidgetFieldVarchar |
| 4 | 4 | { |
| 5 | 5 | public function __construct($layout_manager) { |
@@ -9,9 +9,9 @@ discard block |
||
| 9 | 9 | /** |
| 10 | 10 | * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
| 11 | 11 | */ |
| 12 | - public function SugarWidgetFieldCronSchedule($layout_manager){ |
|
| 12 | + public function SugarWidgetFieldCronSchedule($layout_manager) { |
|
| 13 | 13 | $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
| 14 | - if(isset($GLOBALS['log'])) { |
|
| 14 | + if (isset($GLOBALS['log'])) { |
|
| 15 | 15 | $GLOBALS['log']->deprecated($deprecatedMessage); |
| 16 | 16 | } |
| 17 | 17 | else { |
@@ -43,7 +43,9 @@ discard block |
||
| 43 | 43 | * Date: 06/03/15 |
| 44 | 44 | * Comments |
| 45 | 45 | */ |
| 46 | -if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
|
| 46 | +if(!defined('sugarEntry') || !sugarEntry) { |
|
| 47 | + die('Not A Valid Entry Point'); |
|
| 48 | +} |
|
| 47 | 49 | |
| 48 | 50 | class CasesController extends SugarController { |
| 49 | 51 | |
@@ -90,8 +92,7 @@ discard block |
||
| 90 | 92 | $count++; |
| 91 | 93 | } |
| 92 | 94 | echo '</table>'; |
| 93 | - } |
|
| 94 | - else { |
|
| 95 | + } else { |
|
| 95 | 96 | echo $mod_strings['LBL_NO_SUGGESTIONS']; |
| 96 | 97 | } |
| 97 | 98 | die(); |