X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=blobdiff_plain;f=lib%2Fgeneral.php;h=3f82f4a7f499208dfe59d544a36ef0d3d563dc70;hp=278501ecde546bb7a9069d5d4dc1507d494ac9af;hb=162cb09efc77d87f8d05a9c3f9d8f6520bea7600;hpb=a19c85f249af5dd5db7b0cc62f3ba45243bbb82d diff --git a/lib/general.php b/lib/general.php index 278501e..3f82f4a 100644 --- a/lib/general.php +++ b/lib/general.php @@ -1,7 +1,18 @@ $data) { + if (array_key_exists('sql', $data)) + $fields[] = $data['sql'] . ' AS ' . $field; + else + $fields[] = $field; + } + + $_SESSION['grid_' . $name] = sprintf("SELECT %s FROM %s", + implode(',', $fields), $mask['table']); + if (array_key_exists('join', $mask)) $_SESSION['grid_' . $name] .= ' JOIN ' . join(' JOIN ', $mask['join']); + if (array_key_exists('where', $mask)) $_SESSION['grid_' . $name] .= ' WHERE ' . $mask['where']; +} + ?>