<?php
/*
- Küchenbetreuer:
- E-Mail-Adresse für Kopie
- Telefonnr für Rückfragen:
+ 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
+ - Ordersatz auswählen || neuen Ordersatz erstellen || Ordersatz kopieren
+ - Ordersatz abschließen = PDF-Datei erzeugen, archivieren, per Mail, per Fax
*/
include_once($_SESSION['sys']['basedir'].'masks/metro/utils.php');
include_once($_SESSION['sys']['basedir'].'lib/mail.php');
if (substr($_SERVER["SCRIPT_FILENAME"],-10) == '/index.php' &&
- !empty($_GET['id']))
+ !empty($_GET['id'])) {
$_SESSION['ordersatz'] = $_GET['id'];
+ $done = is_done($_GET['id']);
+}
-$jscode[] = <<<EOC
+if (!$done) {
+ $jscode = <<<EOC
grid_column_edit[1] = {
default_menu: false,
width: '9em',
['8 mal bestellen', '8', 8],
['10 mal bestellen', '10', 10],
['12 mal bestellen', '12', 12],
- ['14 mal bestellen', '14', 14]
+ ['Wert eingeben', 'Bitte geben Sie die gewünschte Menge ein', 'prompt']
]
};
var source = document.getElementById('source');
if (!source) return false;
- var parms = 'source=' + source.innerHTML + '&callback=pdf&';
+ var parms = 'source=' + source.innerHTML + '&callback=pdf';
ajax_request('function', parms, build_pdf_callback);
return false;
}
+
+function finish_callback(data)
+{
+ if (data.status == true) {
+ info('Ordersatz verschickt');
+
+ confirm("Der Ordersatz wurde verschickt.");
+ window.location.href = './?mask=metro__ordersatz';
+ }
+}
+
+function finish()
+{
+ var source = document.getElementById('source');
+ if (!source) return false;
+
+ var parms = 'source=' + source.innerHTML + '&callback=send';
+ ajax_request('function', parms, finish_callback);
+ return false;
+}
+
+function import_articles_callback(data)
+{
+ if (data.status == true) {
+ info('Ordersatz aktualisiert');
+
+ if (data.count > 0)
+ grid_update(grid);
+
+ confirm(data.count + ' Artikel zum Ordersatz hinzugefügt.');
+ }
+}
+
+function import_articles()
+{
+ var source = document.getElementById('source');
+ if (!source) return false;
+
+ var parms = 'source=' + source.innerHTML + '&callback=import';
+ ajax_request('function', parms, import_articles_callback);
+ return false;
+}
+
EOC;
+ $javascript->add($jscode);
+}
$buttons = <<<EOC
<p style="margin-top: 0px; margin-bottom: 4px; text-align: center;">
-<button onclick="return build_pdf()">PDF erstellen</button>
+<button class="custom" onclick="return import_articles()">Artikel importieren</button>
+
+<button class="custom" onclick="return build_pdf()">PDF erstellen</button>
-<button onclick="return finish()">Abschließen</button>
+<button class="custom" onclick="return finish()">Abschließen</button>
<br>Bei Abschluß wird ein Fax zu Metro und eine Kopie per Mail an den Koch geschickt.
</p>
EOC;
$mask = array(
'table' => 'metro_ordersatz',
'join' => array('metro_ordersatz_pos ON ordersatz = metro_ordersatz.id',
- 'metro_artikel ON artikel = metro_artikel.id'),
+ 'metro_artikel ON artikel = metro_artikel.id AND removed = 0'),
'title' => get_title($_SESSION['ordersatz']),
- 'where' => sprintf('ordersatz = %d AND owner = %d AND done IS NULL', $_SESSION['ordersatz'], $_SESSION['sys']['uid']),
+ 'edit_title' => 'Ordersatz',
+ 'where' => sprintf('ordersatz = %d AND owner = %d', $_SESSION['ordersatz'], $_SESSION['sys']['uid']),
'list' => array(
'id' => array(
'name' => 'ID',
'anzahl' => array(
'name' => 'Anzahl',
'width' => 60,
- 'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
+ 'specs' => "ClassName: 'alignrightpad'",
),
'artnr' => array(
'name' => 'Artnr',
'width' => 60,
- 'specs' => "filterUI: 't'",
+ 'visible' => false,
),
'menge' => array(
'name' => 'Menge',
'width' => 60,
- 'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
+ 'specs' => "ClassName: 'alignrightpad', filterUI: 't2'",
),
'bezeichnung' => array(
'name' => 'Bezeichnung',
- 'width' => 260,
+ 'width' => 300,
'specs' => "filterUI: 't'",
),
+ 'preis' => array(
+ 'name' => 'Preis',
+ 'width' => 60,
+ 'type' => 'number',
+ 'specs' => "decPlaces: 2, ClassName: 'alignrightpad'",
+ 'sql' => '(SELECT preis * ((100 + steuersatz)/100) FROM metro_artikel_preis ' .
+ 'WHERE artikel = metro_artikel.id ORDER BY datum DESC LIMIT 1)',
+ ),
+ 'datum' => array(
+ 'name' => 'Datum',
+ 'width' => 85,
+ 'type' => 'text',
+ 'sql' => '(SELECT datum FROM metro_artikel_preis ' .
+ 'WHERE artikel = metro_artikel.id ORDER BY datum DESC LIMIT 1)',
+ 'visible' => false,
+ ),
'hersteller' => array(
'name' => 'Hersteller',
'width' => 80,
- 'specs' => "filterUI: 't'",
+ 'specs' => "filterUI: 't4'",
),
'vpe' => array(
'name' => 'Einheit',
'width' => 70,
'specs' => "ClassName: 'aligncenter', filterUI: 's'",
'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')",
+ 'distinct' => "SELECT DISTINCT vpe,metro_vpe.name FROM metro_artikel JOIN metro_vpe ON vpe = metro_vpe.id ORDER BY name",
),
'abteilung' => array(
'name' => 'Abteilung',
'width' => 80,
'specs' => "ClassName: 'aligncenter', filterUI: 's'",
'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')",
+ 'distinct' => "SELECT DISTINCT abteilung,metro_abteilung.name FROM metro_artikel JOIN metro_abteilung ON abteilung = metro_abteilung.id ORDER BY name",
+ 'visible' => false,
),
'gang' => array(
'name' => 'Gang',
'sql' => 'abteilung',
'specs' => "ClassName: 'aligncenter', filterUI: 's'",
'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','gang').", 0, '')",
+ 'distinct' => "SELECT DISTINCT abteilung,metro_abteilung.gang FROM metro_artikel JOIN metro_abteilung ON abteilung = metro_abteilung.id ORDER BY gang",
+ 'visible' => false,
),
),
'edit' => array(
'cellsave' => cb_cellsave,
'pdf' => cb_pdf,
'send' => cb_send,
+ 'import' => cb_import,
),
'files' => array(
'download' => process_download,
),
+ 'buttons' => array(
+ 'save' => false,
+ 'insert' => false,
+ 'delete' => false,
+ 'changes' => false,
+ ),
);
+if ($done) {
+ unset($mask['edit']);
+ $mask['join'] = str_replace(' AND removed = 0','',$mask['join']);
+}
+
function cb_cellsave()
{
global $db;
$_SESSION['ordersatz'], $_POST['id']);
$sth = $db->query($sql);
- error_log($sql);
}
$tmpdir = mk_tempdir();
$result = ordersatz_write($_SESSION['ordersatz'], $tmpdir, false);
- if ($result !== true)
+ if ($result !== true) {
+ error_log($tmpdir);
+ error_log($result);
return array('error' => $result);
+ }
return array('tmpdir' => substr($tmpdir,strlen($_SESSION['sys']['basedir'])));
}
if ($result !== true)
return array('error' => $result);
- $fname = $tmpdir . '/ordersatz.pdf';
-
rm_tempdir($tmpdir);
+
+ return array('status' => true);
+}
+
+function cb_import()
+{
+ global $db;
+
+ $sql = sprintf("SELECT count(*) AS count FROM metro_ordersatz_pos WHERE ordersatz = %d",
+ $_SESSION['ordersatz']);
+ $sth = $db->query($sql);
+ $row = $sth->fetch();
+ $old = $row['count'];
+
+ $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) " .
+ "SELECT %d,metro_artikel.id,%s,now() FROM metro_artikel " .
+ "LEFT JOIN metro_ordersatz_pos ON artikel = metro_artikel.id AND ordersatz = %d " .
+ "WHERE metro_ordersatz_pos.id IS NULL",
+ $_SESSION['ordersatz'],
+ $db->quote($_SESSION['sys']['login']),
+ $_SESSION['ordersatz']);
+ $db->query($sql);
+
+ $sql = sprintf("SELECT count(*) AS count FROM metro_ordersatz_pos WHERE ordersatz = %d",
+ $_SESSION['ordersatz']);
+ $sth = $db->query($sql);
+ $row = $sth->fetch();
+ $new = $row['count'];
+
+ return array('status' => true, 'count' => $new - $old);
}
?>
projects / misc / hallinta-metro / blobdiff