X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-metro;a=blobdiff_plain;f=ordersatz.php;h=e099839e1b739e163ef5ca29d3e6fdd18fce6513;hp=1c2cc6fc47967c330ca039e7aac94c09a565c673;hb=d2e50bdcbddd9ab8c7b43f92b2cc9434fb98b0c6;hpb=98b8577deb8303963dcc84e1ef9b2c0513c5cc4e

diff --git a/ordersatz.php b/ordersatz.php
index 1c2cc6f..e099839 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,30 +26,30 @@ $mask = array(
 					    ),
 			      'erstellt' => array(
 					    'name' => 'Erstellt',
-					    'width' => 70,
-					    'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
+					    'width' => 85,
 					    ),
 			      'name' => array(
 					    'name' => 'Name',
-					    'width' => 250,
-					    'specs' => "filterUI: 't'",
+					    'width' => 290,
+					    'filter' => 't',
 					    ),
 			      'koch' => array(
 					    'name' => 'Kochbetreuer',
 					    'width' => 100,
-					    'specs' => "filterUI: 't'",
+					    'filter' => 't',
+					    'visible' => false,
 					    ),
 			      'datum' => array(
 					    'name' => 'Einkauf am',
-					    'width' => 110,
+					    'width' => 130,
 					    'sql' => "datum || ' ' || uhrzeit || ' Uhr'",
 					    ),
 			      'link' => array(
-					    'name' => 'auswählen',
+					    'name' => 'Aktion',
 					    'width' => 90,
 					    'control' => $href,
-					    'specs' => "ClassName: 'aligncenter'",
-					    'sql' => "'auswählen'",
+					    'specs' => array('ClassName' => 'aligncenter'),
+					    'sql' => "'bearbeiten'",
 					    ),
 			      ),
 	      'edit' => 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,
 	      );
 
@@ -119,9 +109,9 @@ function ordersatz_insert($id)
 {
   global $db;
 
-  $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() FROM metro_artikel",
+  $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() " .
+		 "FROM metro_artikel WHERE removed = 0",
 		 $id, $db->quote($_SESSION['sys']['login']));
-  error_log($sql);
 
   $sth = $db->query($sql);
 }