query("Select timestamp from timestamp")->fetch_object()->timestamp;
echo $timestamp;
}
#Countdown setzen
function setcountdown()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
$Cowntdowndate = $_POST['Cowntdowndate'];
$sql = $con->query("UPDATE timestamp SET timestamp='{$Cowntdowndate}'");
#Seite neu Laden
header('Location: '.$_SERVER['REQUEST_URI']);
}
#Bestellung für alle reseten
function reset_order()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
#Bestell history befüllen
$backup = $con->query("Insert into Bestell_history Select * from Bestellungen where Preis > 0;");
if($backup)
{
$delOrder = $con->query("DELETE FROM Bestellungen");
$reset_ordered = $con->query("update user set ordered = 0");
$reset_invite = $con->query("DELETE FROM invite");
print "";
}else{
print "";
}
}
function payed()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
if(!isset($_POST['payed'])){
$lesen= $con->query("SELECT UserID,Fname,Lname,isactive FROM user where ordered=1 order by Lname ASC");
echo "
";
echo "
";
}else{
$userID = $_POST['User'];
$backup = $con->query("Insert into Bestell_history Select * from Bestellungen where Userid_fk = $userID;");
$con->query("Update Bestellungen set Preis = 0 where Userid_fk = $userID");
header('Location: '.$_SERVER['REQUEST_URI']);
}
}
#Bestellung aller user Anzeigen
function print_order_all()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
$Produkte = $con->query("SELECT Distinct Produktid_fk from Bestellungen;");
#Ausgabe für jedes Bestellte Product
echo '
Name
';
while($row = mysqli_fetch_array($Produkte))
{
$Produktid = $row['Produktid_fk'];
$Produktname = $con->query("SELECT Name FROM produkte where ArtNr='{$Produktid}'")->fetch_object()->Name;
echo "
$Produktname
";
}
echo '
Gesamt Preis
';
#Auslesen für jeden user
$users = $con->query("Select DISTINCT Userid_fk from Bestellungen;");
while($row = mysqli_fetch_array($users))
{
#schreibt row variable in normale
$D_userid = $row['Userid_fk'];
#Deklaration arrays
$OrderNum = array();
#Userid durch name ersetzen
$name = $con->query("SELECT CONCAT(Lname, ' ',Fname) as 'Name' FROM user where UserID='{$D_userid}'")->fetch_object()->Name;
#Preis Pro user errechnen
$g_Preis = $con->query("SELECT sum(Preis) as G_Preis FROM Bestellungen where Userid_fk='{$D_userid}';")->fetch_object()->G_Preis;
$i = 0 ;
$sql = $con->query("SELECT Anzahl FROM Bestellungen where Userid_fk='{$D_userid}';");
while($ans = mysqli_fetch_array($sql))
{
$OrderNum[$i] = $ans['Anzahl'];
$i++;
}
echo "
$name
";
for($x=0;$x<$i;$x++) {echo "
$OrderNum[$x]
";}
echo "
$g_Preis
";
echo '
';
}
echo '
';
}
#Bestellung aller user Anzeigen
function print_sum_of_order_all()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
$GesOrderNum = array();
$i = 0;
$Produkte = $con->query("SELECT Distinct Produktid_fk from Bestellungen;");
$g_Preis = $con->query("SELECT sum(Preis) as G_Preis FROM Bestellungen;")->fetch_object()->G_Preis;
#$NoM = $con->query("SELECT count(distinct Userid_fk) as Summe FROM Bestellungen")>fetch_object()->Summe;
#Ausgabe für jedes Bestellte Product
echo '
';
while($row = mysqli_fetch_array($Produkte))
{
$Produktid = $row['Produktid_fk'];
$Produktname = $con->query("SELECT Name FROM produkte where ArtNr='{$Produktid}'")->fetch_object()->Name;
$GesOrderNum[$i] = $con->query("SELECT SUM(Anzahl) as 'Anzahl' from Bestellungen where Produktid_fk='{$Produktid}'")->fetch_object()->Anzahl;
echo "
$Produktname
";
$i++;
}
echo "
Preis
";
for($x=0;$x<$i;$x++) {echo "
$GesOrderNum[$x]
";}
echo "
$g_Preis
";
}
#Funktion bestellen über Mod rechte
function order()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
$Userid = $_POST['user'];
$delOrder = $con->query("DELETE FROM Bestellungen WHERE Userid_fk=$Userid;");
$reset_ordered = $con->query("update user set ordered = 0 where UserID=$Userid;");
$ordered = $con->query("select ordered from user where UserID=$Userid;")->fetch_object()->ordered;
if($ordered<1)
{
$post = $_POST;
unset($post['Bestellen']);
unset($post['user']);
print_r($post);
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 "";
}
}
#Bestellform ausgeben
function mod_order()
{
if ($_POST['User'] == 0 ){
print "";
}else{
global $con; # setzt die Variable CON für die Datenbank verbindung
$userID = $_POST['User'];
$ArtNr = array();
$ArtName = array();
$ArtPreis = array();
$ArtImage = array();
$DefaultNum = array();
$i = 0;
#Datenbank auslesen
$query = $con->query("SELECT * FROM produkte where isactive=1");
$name = $con->query("SELECT CONCAT(Lname, ' ',Fname) as 'Name' FROM user where UserID='{$userID}'")->fetch_object()->Name;
#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 '';
}
}
#bestellform für welchen user bestellt wird
function mod_order_print()
{
global $con; # setzt die Variable CON für die Datenbank verbindung
if(!isset($_POST['bearbeiten'])){
$lesen= $con->query("SELECT UserID,Fname,Lname,isactive,ordered FROM user order by Lname ASC");
echo "
";
echo "
";
}else{
mod_order();
}
}
function print_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 '';
}
}
#Buttons überprüfen
if(isset($_POST['SetCountdown'])){
setcountdown();}
if(isset($_POST['resetorder'])){
reset_order();}
if(isset($_POST['Bestellen'])){
order();}
#Setzen des Titels und der Headline für include Dateien
$webpagetitle = "Bestellungs Verwaltung";
#Header und menü einbinden
include "Includes/Header.php";
include "Includes/Menu.php";
#html Content ausgeben
?>