238 lines
7.5 KiB
PHP
238 lines
7.5 KiB
PHP
<?php
|
|
#Datenbank Verbindung einbinden
|
|
require 'Connections/Connections.php';
|
|
#Include datei für Loginüberprüfung
|
|
include "Includes/Session.php";
|
|
|
|
#Funktion gibt Gesamt namen zurück
|
|
function map_name()
|
|
{
|
|
global $con; # setzt die Variable CON für die Datenbank verbindung
|
|
global $Userid;
|
|
#Liest die Namen aus der Datenbank aus und packt sie in ein Dropdown menü
|
|
$name = $con->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 '<div class="mediacenter"><div class="table-container"><table>';
|
|
echo '<tr>';
|
|
for($x=0;$x<$i;$x++) { echo '<td><img src='.$ArtImage[$x].' width="120" height="82"/></td>'; }
|
|
echo '</tr><tr>';
|
|
for($x=0;$x<$i;$x++) { echo "<td>$ArtName[$x]</td>"; }
|
|
echo '</tr><tr>';
|
|
for($x=0;$x<$i;$x++) { echo '<td>'.$ArtPreis[$x].'€</td>'; }
|
|
echo '</tr><tr>';
|
|
for($x=0;$x<$i;$x++) {
|
|
echo '<td><input name="'.$ArtNr[$x].'" type="text" required="required" class="NField" value="'.$DefaultNum[$x].'" /></td>';
|
|
}
|
|
echo '</tr></table></div></div>';
|
|
}
|
|
|
|
#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 "<script type='text/javascript' langeuage='javascript'>
|
|
alert('Du hast die Bestellung verpasst!');window.location = 'Bestellen.php';</script>";
|
|
}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 "<script type='text/javascript' langeuage='javascript'>
|
|
alert('Du hast bereits Bestellt!');window.location = 'Bestellen.php';</script>";
|
|
}
|
|
}
|
|
}
|
|
|
|
#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 '<div class="mediacenter"><div class="table-container"><table class="Print_table"><tr>';
|
|
echo "<td>Name</td>";
|
|
for($x=0;$x<$i;$x++) {echo "<td>$OrderProdName[$x]</td>";}
|
|
echo "<td>Gesamt Preis</td>";
|
|
echo '</tr><tr>';
|
|
echo "<td>$name</td>";
|
|
for($x=0;$x<$i;$x++) {echo "<td>$OrderNum[$x]</td>";}
|
|
echo "<td>$g_Preis</td>";
|
|
echo '</tr></table></div></div>';
|
|
}
|
|
|
|
#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 "<script type='text/javascript' langeuage='javascript'>
|
|
alert('Deine Bestellung wurde gelöscht!');</script>";
|
|
header('Location: '.$_SERVER['REQUEST_URI']);
|
|
}else{
|
|
print "<script type='text/javascript' langeuage='javascript'>
|
|
alert('Deine Bestellung konnte nicht gelöscht werden bitte kontaktieren sie ihren Beauftragen!');</script>";
|
|
}
|
|
}
|
|
|
|
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 '<span class="invite">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 '</span>';
|
|
}
|
|
}
|
|
|
|
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
|
|
?>
|
|
<div class="content">
|
|
<div class="Rahmen">
|
|
<div class="center">
|
|
<h1>Du kannst </h1>
|
|
<div class="Countdown">
|
|
<h2 id="c1"></h2>
|
|
<h4 id="c2">nicht mehr</h4>
|
|
<p>...bestellen!</p>
|
|
<script type="text/javascript">
|
|
countdown("<?php get_countdown(); ?>");
|
|
</script>
|
|
</div>
|
|
|
|
<?php check_invite();?>
|
|
<br/><br />
|
|
<?php print_order(); ?>
|
|
<form action="" method="post" name="Bestellen">
|
|
<?php load_product(); ?>
|
|
<input name="Bestellen" type="submit" class="button" id="" Value="Bestellen">
|
|
<input name="delete" type="submit" class="button" id="" Value="Löschen">
|
|
<br/>
|
|
<h4>Durch drücken dieses Buttons geht die Weißwurst Runde auf euch. Gedacht für Geburtstagseinladungen/ Einstand/ Ausstand oder zu viel Geld auf dem Konto</h4>
|
|
<input name="invite" type="submit" class="button" id="" Value="Ausgeben">
|
|
</form>
|
|
</div>
|
|
<?php include "Includes/showorder.php";?>
|
|
</div>
|
|
</div>
|
|
<?php
|
|
#Footer einbinden
|
|
include "Includes/Footer.php";
|
|
?>
|