break;
case 2:
if ($_POST['action']) {
include_once "modules/seating/class_seat.php";
$seat2 = new seat2();
$time = time();
$totprice = 0;
foreach ($_POST["action"] as $item => $val) {
if ($_GET["status"] == 6 | $_GET["status"] == 7) {
$db->qry("UPDATE %prefix%food_ordering SET status = %string%, lastchange = %string%, supplytime = %string% WHERE id = %string%", $_GET["status"], $time, $time, $item);
//sitzplan popup einbinden
//change by jan für sitzplatz popup $item = id in food_ordering table
//unit food_option (größe)
$abfrage = $db->qry_first("SELECT %prefix%food_ordering.userid AS userid,%prefix%food_ordering.pice AS pice,unit, %prefix%food_product.caption AS caption, username, name, firstname\n\t\t\t\tFROM %prefix%food_ordering,%prefix%food_option, %prefix%food_product, %prefix%user\n\t\t\t\tWHERE %prefix%food_ordering.id = " . $item . " \n\t\t\t\tAND lastchange=" . $time . " \n\t\t\t\tAND supplytime=" . $time . " \n\t\t\t\tAND %prefix%food_product.id = %prefix%food_option.parentid \n\t\t\t\tAND %prefix%food_ordering.productid = %prefix%food_product.id\n\t\t\t\tAND %prefix%user.userid = %prefix%food_ordering.userid");
//$dsp->AddDoubleRow('Ergebnis', $seat2->SeatOfUser($abfrage['userid'], 0, 2));
$dsp->AddDoubleRow('Was -> Wohin', $abfrage['pice'] . ' x ' . $abfrage['caption'] . ' (' . $abfrage['unit'] . ') -> ' . $abfrage['username'] . ' (' . $abfrage['firstname'] . ' ' . $abfrage['name'] . ') ' . $seat2->SeatOfUser($abfrage['userid'], 0, 2));
//change ende
} elseif ($_GET["status"] == 8) {
$totprice = 0;
$prodrow = $db->qry_first("SELECT * FROM %prefix%food_ordering WHERE id = %string%", $item);
unset($account);
$account = new accounting($prodrow['userid']);
$price = 0;
$tempdesc = "";
if (stristr($prodrow['opts'], "/")) {
$values = explode("/", $prodrow['opts']);
foreach ($values as $number) {
if (is_numeric($number)) {
$optrow = $db->qry_first("SELECT price, caption FROM %prefix%food_option WHERE id = %int%", $number);
$price += $optrow['price'];
$tempdesc .= $optrow['caption'];
$party_row .= ' ' . $dsp->AddIcon('not_out', $link, t('Nicht ausgecheckt'));
}
if (IsAuthorizedAdmin() and $user_party['checkin'] > 0 and $user_party['checkout'] > 0) {
$party_row .= $dsp->AddIcon('delete', 'index.php?mod=guestlist&step=22&userid=' . $_GET['userid'], 'Reset Checkin');
}
$dsp->AddDoubleRow("Party '<i>" . $_SESSION['party_info']['name'] . "</i>'", $party_row);
}
// Seating
if ($func->isModActive('seating')) {
include_once "modules/seating/class_seat.php";
$seat2 = new seat2();
$user_data_seating = $seat2->SeatOfUserArray($_GET['userid']);
if ($user_data_seating['block'] == '') {
$seat = t('Kein Sitzplatz ausgewählt / zugeteilt.');
} else {
$seat = $seat2->SeatOfUser($_GET['userid'], 0, 2);
if (IsAuthorizedAdmin()) {
$seat .= ' ' . $dsp->AddIcon('delete', "index.php?mod=seating&action=seatadmin&step=20&blockid={$user_data_seating['block']}&row={$user_data_seating['row']}&col={$user_data_seating['col']}&userid={$user_data['userid']}", t('Löschen'));
}
}
if (IsAuthorizedAdmin()) {
$seat .= ' ' . $dsp->AddIcon('edit', 'index.php?mod=seating&action=seatadmin&step=2&userid=' . $_GET['userid'], t('Editieren'));
}
if ($cfg['sys_internet'] == 0 and $user_data_seating['ip']) {
$seat .= ' IP:' . $user_data_seating['ip'];
}
$dsp->AddDoubleRow(t('Sitzplatz'), $seat);
}
//kontostand
if ($func->isModActive('foodcenter')) {
$result = $db->qry_first("SELECT SUM(movement) AS total FROM %prefix%food_accounting WHERE userid = %int%", $_GET['userid']);