spip /
SPIP
| @@ 487-507 (lines=21) @@ | ||
| 484 | * @param array $args |
|
| 485 | * @return string Sélection de colonnes pour une clause SELECT |
|
| 486 | */ |
|
| 487 | function spip_mysql_select_as($args) { |
|
| 488 | $res = ''; |
|
| 489 | foreach ($args as $k => $v) { |
|
| 490 | if (substr($k, -1) == '@') { |
|
| 491 | // c'est une jointure qui se refere au from precedent |
|
| 492 | // pas de virgule |
|
| 493 | $res .= ' ' . $v; |
|
| 494 | } else { |
|
| 495 | if (!is_numeric($k)) { |
|
| 496 | $p = strpos($v, " "); |
|
| 497 | if ($p) { |
|
| 498 | $v = substr($v, 0, $p) . " AS `$k`" . substr($v, $p); |
|
| 499 | } else { |
|
| 500 | $v .= " AS `$k`"; |
|
| 501 | } |
|
| 502 | } |
|
| 503 | $res .= ', ' . $v; |
|
| 504 | } |
|
| 505 | } |
|
| 506 | ||
| 507 | return substr($res, 2); |
|
| 508 | } |
|
| 509 | ||
| 510 | ||
| @@ 2091-2110 (lines=20) @@ | ||
| 2088 | * @param array $args |
|
| 2089 | * @return string Sélection de colonnes pour une clause SELECT |
|
| 2090 | */ |
|
| 2091 | function _sqlite_calculer_select_as($args) { |
|
| 2092 | $res = ''; |
|
| 2093 | foreach ($args as $k => $v) { |
|
| 2094 | if (substr($k, -1) == '@') { |
|
| 2095 | // c'est une jointure qui se refere au from precedent |
|
| 2096 | // pas de virgule |
|
| 2097 | $res .= ' ' . $v; |
|
| 2098 | } else { |
|
| 2099 | if (!is_numeric($k)) { |
|
| 2100 | $p = strpos($v, " "); |
|
| 2101 | if ($p) { |
|
| 2102 | $v = substr($v, 0, $p) . " AS '$k'" . substr($v, $p); |
|
| 2103 | } else { |
|
| 2104 | $v .= " AS '$k'"; |
|
| 2105 | } |
|
| 2106 | } |
|
| 2107 | $res .= ', ' . $v; |
|
| 2108 | } |
|
| 2109 | } |
|
| 2110 | ||
| 2111 | return substr($res, 2); |
|
| 2112 | } |
|
| 2113 | ||
