Ejemplo n.º 1
0
     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'];
Ejemplo n.º 2
0
         $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']);