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

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