<?php
  /*
   Küchenbetreuer:
   E-Mail-Adresse für Kopie
   Telefonnr für Rückfragen:
   Abholung am:
   Abholung um Uhrzeit:

   - Ordersatz auswählen || neuen Ordersatz erstellen || Ordersatz kopieren
   - Ordersatz abschließen = PDF-Datei erzeugen, archivieren, per Mail, per Fax
   */


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;
# DELETE FROM metro_ordersatz_pos WHERE ordersatz = ORDERID AND anzahl IS NULL
$mask = array(
	      'table' => 'metro_ordersatz',
	      'title' => 'Ordersatz auswÃ¤hlen / erstellen',
	      'where' => sprintf('owner = %d AND done IS NULL', $_SESSION['sys']['uid']),
	      'list' => array(
			      'id' => array(
					    'name' => 'ID',
					    'visible' => false,
					    ),
			      'erstellt' => array(
					    'name' => 'Erstellt',
					    'width' => 100,
					    'specs' => "ClassName: 'alignrightpad'",
					    ),
			      'name' => array(
					    'name' => 'Name',
					    'width' => 290,
					    'specs' => "filterUI: 't'",
					    ),
			      'koch' => array(
					    'name' => 'Kochbetreuer',
					    'width' => 100,
					    'specs' => "filterUI: 't'",
					    'visible' => false,
					    ),
			      'datum' => array(
					    'name' => 'Einkauf am',
					    'width' => 100,
					    'sql' => "datum || ' ' || uhrzeit || ' Uhr'",
					    ),
			      'link' => array(
					    'name' => 'Aktion',
					    'width' => 90,
					    'control' => $href,
					    'specs' => "ClassName: 'aligncenter'",
					    'sql' => "'bearbeiten'",
					    ),
			      ),
	      'edit' => array(
			      'owner' => array(
					    'type' => 'hidden',
					    'default' => $_SESSION['sys']['uid'],
					    'required' => true,
					    ),
			      'erstellt' => array(
					    'type' => 'hidden',
					    'subtype' => 'string',
					    'default' => date('Y-m-d'),
					    'required' => true,
					    ),
			      'name' => array(
					    'name' => 'Name',
					    'type' => 'text',
					    'size' => 21,
					    'required' => true,
					    ),
			      'koch' => array(
					    'name' => 'Kochbetreuer',
					    'type' => 'text',
					    'size' => 21,
					    'required' => true,
					    ),
			      'email' => array(
					    'name' => 'E-Mail',
					    'type' => 'text',
					    'size' => 21,
					    'null' => true,
					    ),
			      'telefon' => array(
					    'name' => 'Telefon fÃ¼r RÃ¼ckfragen',
					    'type' => 'text',
					    'size' => 21,
					    'required' => true,
					    ),
			      'datum' => array(
					    'name' => 'Abholdatum',
					    'type' => 'date',
					    'size' => 8,
					    'required' => true,
					    ),
			      'uhrzeit' => array(
					    'name' => 'UngefÃ¤hre Uhrzeit der Abholung',
					    'type' => 'text',
					    'size' => 3,
					    'required' => true,
					    ),
			      ),
	      'buttons' => array('delete' => false),
	      'postinsert' => ordersatz_insert,
	      );

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",
		 $id, $db->quote($_SESSION['sys']['login']));

  $sth = $db->query($sql);
}

?>