spip /
SPIP
| @@ 657-669 (lines=13) @@ | ||
| 654 | ||
| 655 | ||
| 656 | // http://doc.spip.org/@calculer_pg_expression |
|
| 657 | function calculer_pg_expression($expression, $v, $join = 'AND'){ |
|
| 658 | if (empty($v)) |
|
| 659 | return ''; |
|
| 660 | ||
| 661 | $exp = "\n$expression "; |
|
| 662 | ||
| 663 | if (!is_array($v)) $v = array($v); |
|
| 664 | ||
| 665 | if (strtoupper($join) === 'AND') |
|
| 666 | return $exp . join("\n\t$join ", array_map('calculer_pg_where', $v)); |
|
| 667 | else |
|
| 668 | return $exp . join($join, $v); |
|
| 669 | } |
|
| 670 | ||
| 671 | // http://doc.spip.org/@spip_pg_select_as |
|
| 672 | function spip_pg_select_as($args) |
|
| @@ 1185-1199 (lines=15) @@ | ||
| 1182 | ||
| 1183 | // renvoie grosso modo "$expression join($join, $v)" |
|
| 1184 | // http://doc.spip.org/@_sqlite_calculer_expression |
|
| 1185 | function _sqlite_calculer_expression($expression, $v, $join = 'AND'){ |
|
| 1186 | if (empty($v)) |
|
| 1187 | return ''; |
|
| 1188 | ||
| 1189 | $exp = "\n$expression "; |
|
| 1190 | ||
| 1191 | if (!is_array($v)) { |
|
| 1192 | return $exp . $v; |
|
| 1193 | } else { |
|
| 1194 | if (strtoupper($join) === 'AND') |
|
| 1195 | return $exp . join("\n\t$join ", array_map('_sqlite_calculer_where', $v)); |
|
| 1196 | else |
|
| 1197 | return $exp . join($join, $v); |
|
| 1198 | } |
|
| 1199 | } |
|
| 1200 | ||
| 1201 | ||
| 1202 | ||
| @@ 421-435 (lines=15) @@ | ||
| 418 | * @param string $join Si les données sont un tableau, elles seront groupées par cette jointure |
|
| 419 | * @return string Texte de l'expression, une partie donc, du texte la requête. |
|
| 420 | */ |
|
| 421 | function calculer_mysql_expression($expression, $v, $join = 'AND'){ |
|
| 422 | if (empty($v)) |
|
| 423 | return ''; |
|
| 424 | ||
| 425 | $exp = "\n$expression "; |
|
| 426 | ||
| 427 | if (!is_array($v)) { |
|
| 428 | return $exp . $v; |
|
| 429 | } else { |
|
| 430 | if (strtoupper($join) === 'AND') |
|
| 431 | return $exp . join("\n\t$join ", array_map('calculer_mysql_where', $v)); |
|
| 432 | else |
|
| 433 | return $exp . join($join, $v); |
|
| 434 | } |
|
| 435 | } |
|
| 436 | ||
| 437 | ||
| 438 | /** |
|
