Display expanded customer name

diff --git a/src/InfoCon/stempel/common.inc b/src/InfoCon/stempel/common.inc
index 9d10db0..bcfa427 100644 (file)
--- a/src/InfoCon/stempel/common.inc
+++ b/src/InfoCon/stempel/common.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 
   function min2hour($minutes)
   {
@@ -33,4 +33,16 @@
     return $a;
   }
 
+  function load_customers()
+  {
+    global $dbh;
+    $info = array();
+
+    $sth = pg_exec ($dbh, 'SELECT short,name FROM stempel_customer');
+    while ($row = pg_fetch_array ($sth))
+      $info[$row['short']] = $row['name'];
+
+    return $info;
+  }
+
 ?>

diff --git a/src/InfoCon/stempel/index.wml b/src/InfoCon/stempel/index.wml
index 5006347..0ab3996 100644 (file)
--- a/src/InfoCon/stempel/index.wml
+++ b/src/InfoCon/stempel/index.wml
@@ -27,6 +27,8 @@
 <page func=InfoCon title="Stempeluhr">
 
 <?
+  $name = load_customers();
+
   $table_head = '<h3 class="bar">Kunde: %s</h3>
 <table class="smallfont border" width="100%%" cellpadding=0 cellspacing=1>
 <tr class="head">
@@ -54,7 +56,9 @@
        printf($table_sum, $color, min2hour($sum));
         echo($table_foot);
       }
-      printf($table_head, $row['customer']);
+      $cname = $name[$row['customer']];
+      if (!strlen($cname)) $cname = ucfirst($row['customer']);
+      printf($table_head, $cname);
       $customer = $row['customer'];
       $sum = 0;
       $color = 0;

diff --git a/src/InfoCon/stempel/status.wml b/src/InfoCon/stempel/status.wml
index b7e548d..dd84a6f 100644 (file)
--- a/src/InfoCon/stempel/status.wml
+++ b/src/InfoCon/stempel/status.wml
@@ -21,18 +21,6 @@
     return sprintf("<br>%d records updated.", $count);
   }
 
-  function load_customers()
-  {
-    global $dbh;
-    $info = array();
-
-    $sth = pg_exec ($dbh, 'SELECT short,name FROM stempel_customer');
-    while ($row = pg_fetch_array ($sth))
-      $info[$row['short']] = $row['name'];
-
-    return $info;
-  }
-
   $stati = false;
   function display_tables()
   {