query("SELECT CONCAT(Lname, ' ',Fname) as 'Name' FROM user where UserID='{$Userid}'")->fetch_object()->Name;
return $name;
}
#Funktion lad Produkte aus datenbank
function load_product()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
global $Userid;
$ArtNr = array();
$ArtName = array();
$ArtPreis = array();
$ArtImage = array();
$DefaultNum = array();
$i = 0;
#Datenbank auslesen
$query = $con->query("SELECT * FROM produkte where isactive=1");
#Datensätze in array schreiben
while($row = mysqli_fetch_array($query))
{
$ArtNr[$i] = $row['ArtNr'];
$DefaultNum[$i] = $sql = $con->query("SELECT Anzahl FROM standard_bestellung where userid_fk='$Userid' and produktid_fk='$ArtNr[$i]'")->fetch_object()->Anzahl;
$ArtName[$i] = $row['Name'];
$ArtPreis[$i] = $row['Preis'];
$ArtImage[$i] = $row['produkt_image'];
$i++;
}
echo '';
}
#Bestellfunktion
function order()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
global $Userid;
$jetzt = date('Y-m-d H:i:s');
$timestamp = $con->query("Select timestamp from timestamp")->fetch_object()->timestamp;
$dtime = new DateTime($timestamp);
$dtime->modify('-1 day');
$bestelldate = $dtime->format("Y-m-d H:i:s");
if($jetzt > $bestelldate){
print "";
}else{
$ordered = $con->query("select ordered from user where UserID=$Userid;")->fetch_object()->ordered;
if($ordered<1)
{
$post = $_POST;
unset($post['Bestellen']);
foreach ($post as $key => $entry)
{
$preis = $con->query("select Preis from produkte where ArtNr=$key")->fetch_object()->Preis;
$g_preis = (float)$preis * (float)$entry;
$con->query("insert into Bestellungen (Userid_fk,Produktid_fk,Anzahl,Preis) VALUES ('$Userid','$key','$entry','$g_preis');");
}
$sql = $con->query("update user set ordered = 1 where UserID=$Userid;");
}else{
print "";
}
}
}
#Bestellung drucken
function print_order()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
global $Userid;
$OrderProdName = array();
$OrderNum = array();
$g_Preis = $con->query("SELECT sum(Preis) as G_Preis FROM Bestellungen where Userid_fk=$Userid;")->fetch_object()->G_Preis;
$name = map_name();
$sql = $con->query("SELECT Name,Anzahl FROM `Bestellungen`, produkte where Produktid_fk = ArtNr and Userid_fk=$Userid;");
$i = 0 ;
while($row = mysqli_fetch_array($sql))
{
$OrderNum[$i] = $row['Anzahl'];
$OrderProdName[$i] = $row['Name'];
$i++;
}
echo '';
}
#Bestellung löschen
function del_order()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
global $Userid;
$delOrder = $con->query("DELETE FROM Bestellungen WHERE Userid_fk=$Userid;");
$check = $con->query("Select * FROM Bestellungen WHERE Userid_fk=$Userid;");
if (mysqli_num_rows($check)==0) {
$reset_ordered = $con->query("update user set ordered = 0 where UserID=$Userid;");
print "";
header('Location: '.$_SERVER['REQUEST_URI']);
}else{
print "";
}
}
function invite()
{
global $con;
global $Userid;
$query = $con->query("Select userid_fk from invite;");
$einlader = mysqli_num_rows($query);
if($einlader == 0 ){
$invite = $con->query("Insert into invite (userid_fk,invite) VALUES ($Userid,1);");
}else{
$exists = 0;
while($row = mysqli_fetch_array($query))
{
$userid = $row['userid_fk'];
if($userid == $Userid){
$exists = 1;
}
}
if($exists == 0){
$invite = $con->query("Insert into invite (userid_fk,invite) VALUES ($Userid,1);");
}
}
}
function check_invite()
{
global $con;
$query = $con->query("Select userid_fk from invite;");
$einlader = mysqli_num_rows($query);
if($einlader != 0 ){
echo 'Eingeladen von ';
while($row = mysqli_fetch_array($query))
{
$userid = $row['userid_fk'];
$name = $con->query("SELECT CONCAT(Lname, ' ',Fname) as 'Name' FROM user where UserID='{$userid}'")->fetch_object()->Name;
echo "$name";
if($einlader > 1){
echo ' und ';
$einlader--;
}
}
echo '';
}
}
function get_countdown(){
global $con;
$timestamp = $con->query("Select timestamp from timestamp")->fetch_object()->timestamp;
$dtime = new DateTime($timestamp);
$dtime->modify('-1 day');
echo $dtime->format("Y-m-d H:i:s");
}
#Buttons prüfen
if(isset($_POST['Bestellen'])){
order();
}
if(isset($_POST['delete'])){
del_order();
}
if(isset($_POST['invite'])){
invite();
}
#Setzen des Titels und der Headline für include Dateien
$webpagetitle = "Weißwurst-Bestellung";
#Header und menü einbinden
include "Includes/Header.php";
include "Includes/Menu.php";
#html Content ausgeben
?>