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