3 function passwd($login,$pass)
5 return md5(md5($pass).$login);
8 function check_session()
10 if (!empty($_SESSION['sys']['login']) && !empty($_GET['logout'])) {
12 header('Location: ./?login=true');
16 if (substr($_SERVER["SCRIPT_FILENAME"],-10) == '/index.php' &&
17 !empty($_POST['login']) && !empty($_POST['passwd'])) {
18 require_once('lib/login.php');
20 header('Location: ./');
25 if (empty($_SESSION['sys']['login']) && empty($_GET['login'])) {
26 header('Location: ./?login=true');
31 function sanitise_filename($file)
33 return str_replace('./','x',$file);
36 function load_mask($name)
41 $name = sanitise_filename($name);
42 $file = $_SESSION['sys']['basedir'] . 'masks/' . $name . '.php';
44 if (!file_exists($file))
54 $dsn = sprintf('host=%s dbname=%s user=%s password=%s',DBHOST,DBNAME,DBUSER,DBPASS);
58 function query_db($sql)
60 $sth = pg_query($sql);
62 if ($sth === false) return false;
65 while ($row = pg_fetch_assoc($sth))
71 function load_js($jsfiles, $jscode)
74 foreach ($jsfiles as $file)
75 $ret .= sprintf('<script type="text/javascript" src="%s"></script>'."\n", $file);
78 $ret .= sprintf('<script type="text/javascript">'."\n%s\n</script>\n", implode("\n",$jscode));
85 if (!empty($_GET['login'])) {
86 require_once('lib/login.php');
90 if (!empty($_GET['mask'])) {
91 require_once('lib/mask.php');
92 return mask($_GET['mask']);
95 $masks = array('sys_user','sys_group','sys_mask',
96 'anbaugeraete','arbeitsarten','personal','materialien','gebiet','geraete',
97 'kostenstellen','materialverbrauch','einsatz');
99 foreach ($masks as $m)
100 $ret .= sprintf('<a href="index.php?mask=%s">%s</a><br>', $m, $m);
105 function debug_log($text)
109 $debug_info .= '<br>' . $text;
112 function debug_info()
117 if (DEBUG !== true) return '';
119 $jsfiles[] = 'lib/debug_joey.js';
121 $html = '<div style="background: #DDD; margin: 5px; padding-left: 4px; border: 1px solid #AAA;clear:both;">';
122 $html .= "\n<pre>\n\$_SESSION = " . var_export($_SESSION,true) . "\n";
123 $html .= "\n\$_COOKIE = " . var_export($_COOKIE,true) . "\n</pre>\n";
124 $html .= $debug_info;
129 function grid_sql($name, $mask)
132 foreach ($mask['list'] as $field => $data) {
133 if (array_key_exists('sql', $data))
134 $fields[] = $data['sql'] . ' AS ' . $field;
139 $_SESSION['grid_' . $name] = sprintf("SELECT %s FROM %s",
140 implode(',', $fields), $mask['table']);
141 if (array_key_exists('join', $mask)) $_SESSION['grid_' . $name] .= ' JOIN ' . join(' JOIN ', $mask['join']);
142 if (array_key_exists('where', $mask)) $_SESSION['grid_' . $name] .= ' WHERE ' . $mask['where'];