git.infodrom.org Git - misc/hallinta-metro/blob - ordersatz.php

   1 <?php
   2   /*
   3    Küchenbetreuer:
   4    E-Mail-Adresse für Kopie
   5    Telefonnr für Rückfragen:
   6    Abholung am:
   7    Abholung um Uhrzeit:
   8
   9    - Ordersatz auswählen || neuen Ordersatz erstellen || Ordersatz kopieren
  10    - Ordersatz abschließen = PDF-Datei erzeugen, archivieren, per Mail, per Fax
  11    */
  12
  13
  14 function get_title($id)
  15 {
  16   global $db;
  17
  18   $query = sprintf('SELECT name FROM metro_ordersatz WHERE id = %d', $id);
  19   $sth = $db->query($query);
  20   $row = $sth->fetch();
  21   if ($row) return 'Ordersatz für ' . $row['name'];
  22   else return 'Unbekannter Ordersatz';
  23 }
  24
  25 $href = "new Rico.TableColumn.link('./?mask=metro__ordersatz_pos&id={0}')";
  26
  27 # INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT ORDERID,id,'joey',now() FROM metro_artikel;
  28 # DELETE FROM metro_ordersatz_pos WHERE ordersatz = ORDERID AND anzahl IS NULL
  29 $mask = array(
  30               'table' => 'metro_ordersatz',
  31               'title' => 'Ordersatz auswählen / erstellen',
  32               'where' => sprintf('owner = %d AND done IS NULL', $_SESSION['sys']['uid']),
  33               'list' => array(
  34                               'id' => array(
  35                                             'name' => 'ID',
  36                                             'visible' => false,
  37                                             ),
  38                               'erstellt' => array(
  39                                             'name' => 'Erstellt',
  40                                             'width' => 85,
  41                                             ),
  42                               'name' => array(
  43                                             'name' => 'Name',
  44                                             'width' => 290,
  45                                             'specs' => "filterUI: 't'",
  46                                             ),
  47                               'koch' => array(
  48                                             'name' => 'Kochbetreuer',
  49                                             'width' => 100,
  50                                             'specs' => "filterUI: 't'",
  51                                             'visible' => false,
  52                                             ),
  53                               'datum' => array(
  54                                             'name' => 'Einkauf am',
  55                                             'width' => 130,
  56                                             'sql' => "datum || ' ' || uhrzeit || ' Uhr'",
  57                                             ),
  58                               'link' => array(
  59                                             'name' => 'Aktion',
  60                                             'width' => 90,
  61                                             'control' => $href,
  62                                             'specs' => "ClassName: 'aligncenter'",
  63                                             'sql' => "'bearbeiten'",
  64                                             ),
  65                               ),
  66               'edit' => array(
  67                               'owner' => array(
  68                                             'type' => 'hidden',
  69                                             'default' => $_SESSION['sys']['uid'],
  70                                             'required' => true,
  71                                             ),
  72                               'erstellt' => array(
  73                                             'type' => 'hidden',
  74                                             'subtype' => 'string',
  75                                             'default' => date('Y-m-d'),
  76                                             'required' => true,
  77                                             ),
  78                               'name' => array(
  79                                             'name' => 'Name',
  80                                             'type' => 'text',
  81                                             'size' => 21,
  82                                             'required' => true,
  83                                             ),
  84                               'koch' => array(
  85                                             'name' => 'Kochbetreuer',
  86                                             'type' => 'text',
  87                                             'size' => 21,
  88                                             'required' => true,
  89                                             ),
  90                               'email' => array(
  91                                             'name' => 'E-Mail',
  92                                             'type' => 'text',
  93                                             'size' => 21,
  94                                             'null' => true,
  95                                             ),
  96                               'telefon' => array(
  97                                             'name' => 'Telefon für Rückfragen',
  98                                             'type' => 'text',
  99                                             'size' => 21,
 100                                             'required' => true,
 101                                             ),
 102                               'datum' => array(
 103                                             'name' => 'Abholdatum',
 104                                             'type' => 'date',
 105                                             'size' => 8,
 106                                             'required' => true,
 107                                             ),
 108                               'uhrzeit' => array(
 109                                             'name' => 'Ungefähre Uhrzeit der Abholung',
 110                                             'type' => 'text',
 111                                             'size' => 3,
 112                                             'required' => true,
 113                                             ),
 114                               ),
 115               'buttons' => array('delete' => false),
 116               'postinsert' => ordersatz_insert,
 117               );
 118
 119 function ordersatz_insert($id)
 120 {
 121   global $db;
 122
 123   $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() FROM metro_artikel",
 124                  $id, $db->quote($_SESSION['sys']['login']));
 125
 126   $sth = $db->query($sql);
 127 }
 128
 129 ?>