X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=blobdiff_plain;f=lib%2Fgeneral.php;h=9ec2941a77609dfa61870391e305c0c8063d4b28;hp=278501ecde546bb7a9069d5d4dc1507d494ac9af;hb=84a5dafd242fa23773c0bb8f7961c8bb0cf2f9ed;hpb=a19c85f249af5dd5db7b0cc62f3ba45243bbb82d diff --git a/lib/general.php b/lib/general.php index 278501e..9ec2941 100644 --- a/lib/general.php +++ b/lib/general.php @@ -1,8 +1,20 @@ $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']; +} + ?>