| @@ 86-97 (lines=12) @@ | ||
| 83 | { |
|
| 84 | $trimChar = ($char != false) ? (', ' . $char) : ''; |
|
| 85 | ||
| 86 | switch ($pos) { |
|
| 87 | case self::TRIM_LEADING: |
|
| 88 | $trimFn = 'LTRIM'; |
|
| 89 | break; |
|
| 90 | ||
| 91 | case self::TRIM_TRAILING: |
|
| 92 | $trimFn = 'RTRIM'; |
|
| 93 | break; |
|
| 94 | ||
| 95 | default: |
|
| 96 | $trimFn = 'TRIM'; |
|
| 97 | } |
|
| 98 | ||
| 99 | return $trimFn . '(' . $str . $trimChar . ')'; |
|
| 100 | } |
|
| @@ 1013-1024 (lines=12) @@ | ||
| 1010 | public function getTrimExpression($str, $pos = self::TRIM_UNSPECIFIED, $char = false) |
|
| 1011 | { |
|
| 1012 | if ( ! $char) { |
|
| 1013 | switch ($pos) { |
|
| 1014 | case self::TRIM_LEADING: |
|
| 1015 | $trimFn = 'LTRIM'; |
|
| 1016 | break; |
|
| 1017 | ||
| 1018 | case self::TRIM_TRAILING: |
|
| 1019 | $trimFn = 'RTRIM'; |
|
| 1020 | break; |
|
| 1021 | ||
| 1022 | default: |
|
| 1023 | return 'LTRIM(RTRIM(' . $str . '))'; |
|
| 1024 | } |
|
| 1025 | ||
| 1026 | return $trimFn . '(' . $str . ')'; |
|
| 1027 | } |
|