X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-metro;a=blobdiff_plain;f=ordersatz.php;h=01b5c09dc718fb54cbc03ae6df5e42550d585243;hp=34104b080625481abad17530c4b55f9dabc7ed3c;hb=46379cd58c55e50a93bf6667d8f8471f87ec753a;hpb=95b81ae3034f5ab80bfdb913d415fa11d57a11f0 diff --git a/ordersatz.php b/ordersatz.php index 34104b0..01b5c09 100644 --- a/ordersatz.php +++ b/ordersatz.php @@ -11,17 +11,6 @@ */ -function get_title($id) -{ - global $db; - - $query = sprintf('SELECT name FROM metro_ordersatz WHERE id = %d', $id); - $sth = $db->query($query); - $row = $sth->fetch(); - if ($row) return 'Ordersatz für ' . $row['name']; - else return 'Unbekannter Ordersatz'; -} - $href = "new Rico.TableColumn.link('./?mask=metro__ordersatz_pos&id={0}')"; # INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT ORDERID,id,'joey',now() FROM metro_artikel; @@ -37,22 +26,22 @@ $mask = array( ), 'erstellt' => array( 'name' => 'Erstellt', - 'width' => 70, - 'specs' => "ClassName: 'alignrightpad', filterUI: 't'", + 'width' => 85, ), 'name' => array( 'name' => 'Name', - 'width' => 250, + 'width' => 290, 'specs' => "filterUI: 't'", ), 'koch' => array( 'name' => 'Kochbetreuer', 'width' => 100, 'specs' => "filterUI: 't'", + 'visible' => false, ), 'datum' => array( 'name' => 'Einkauf am', - 'width' => 110, + 'width' => 130, 'sql' => "datum || ' ' || uhrzeit || ' Uhr'", ), 'link' => array( @@ -78,25 +67,25 @@ $mask = array( 'name' => array( 'name' => 'Name', 'type' => 'text', - 'size' => 25, + 'size' => 21, 'required' => true, ), 'koch' => array( 'name' => 'Kochbetreuer', 'type' => 'text', - 'size' => 25, + 'size' => 21, 'required' => true, ), 'email' => array( 'name' => 'E-Mail', 'type' => 'text', - 'size' => 25, + 'size' => 21, 'null' => true, ), 'telefon' => array( 'name' => 'Telefon für Rückfragen', 'type' => 'text', - 'size' => 25, + 'size' => 21, 'required' => true, ), 'datum' => array( @@ -107,11 +96,12 @@ $mask = array( ), 'uhrzeit' => array( 'name' => 'Ungefähre Uhrzeit der Abholung', - 'type' => 'number', + 'type' => 'text', 'size' => 3, 'required' => true, ), ), + 'buttons' => array('delete' => false), 'postinsert' => ordersatz_insert, );