| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/biotraubensaft/ansana/inc/ |
Upload File : |
<?php
require_once 'database.php';
class Saft {
/**
* get_by_id
*
* returns a single "Saft" by ID
*
* @param $id
* @return mixed
*/
public static function get_by_id($id) {
$pdo = Database::getInstance();
$query = "
SELECT s.id,
s.name,
p.name as produzent,
p.id as produzent_id,
p.url as produzent_url,
f.name as farbe,
f.colorcode as colorcode,
b.extern as extern,
s.beschreibung as beschreibung,
s.bewertung_text as bewertung_text,
s.bewertung_sterne as bewertung_sterne,
s.url as url,
b.freigestellt as freigestellt,
b.status AS bildstatus
FROM saft AS s
INNER JOIN produzent AS p ON s.produzent_id = p.id
INNER JOIN farbe AS f ON s.farbe = f.id
LEFT JOIN saft_bilder AS b ON s.id = b.saft_id
WHERE p.status = 1 AND s.status = 1 AND s.id = :id
LIMIT 1;";
$sth = $pdo->prepare($query);
$sth->bindParam(':id', $id, PDO::PARAM_INT);
$sth->execute();
$row = $sth->fetch(PDO::FETCH_ASSOC);
if ($row) {
self::add_image($row);
}
return $row;
}
/**
* get_bezuege
*
* @return mixed
*/
public static function get_bezuege_by_saft_id($id) {
$pdo = Database::getInstance();
$sth = $pdo->prepare("
SELECT
b.url AS url,
v.name AS name
FROM bezug AS b
INNER JOIN vertrieb AS v ON v.id = b.vertrieb_id
WHERE b.status=1 AND b.saft_id = :id
");
$sth->bindParam(':id', $id, PDO::PARAM_INT);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
return $rows;
}
/**
* get_by_producer
*
* @param $producer_id
* @param null $exclude_id
* @return array
*/
public static function get_by_producer($producer_id, $exclude_id = null) {
$pdo = Database::getInstance();
$query = "
SELECT s.id AS id,
s.name AS name,
f.name AS farbe,
f.colorcode AS colorcode,
b.freigestellt AS bild,
b.extern as extern,
s.beschreibung AS beschreibung,
s.bewertung_text AS bewertung_text,
s.bewertung_sterne AS bewertung_sterne,
s.url AS url,
b.freigestellt AS freigestellt
FROM saft AS s
INNER JOIN produzent AS p ON s.produzent_id = p.id
INNER JOIN farbe AS f ON s.farbe = f.id
LEFT JOIN saft_bilder AS b ON s.id = b.saft_id
WHERE p.status = 1 AND s.status = 1 AND s.id != :exclude_id AND p.id = :produzent_id
";
$sth = $pdo->prepare($query);
$sth->bindParam(':produzent_id', $producer_id, PDO::PARAM_INT);
$sth->bindParam(':exclude_id', $exclude_id, PDO::PARAM_INT);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
foreach($rows as &$row) {
self::add_image($row);
}
return $rows;
}
/**
* get
*
* Lists saefte, optionally supply a limit
*
* @param null $limit
* @return array
*/
public static function get($limit = null) {
$pdo = Database::getInstance();
$query = "
SELECT s.id AS id,
s.name AS name,
s.bewertung_sterne AS sterne,
p.name AS produzent,
p.id AS produzent_id,
f.name AS farbe,
f.colorcode AS colorcode,
b.freigestellt AS freigestellt,
b.extern AS extern,
b.status AS bildstatus
FROM saft AS s
INNER JOIN produzent AS p ON s.produzent_id = p.id
INNER JOIN farbe AS f ON s.farbe = f.id
INNER JOIN saft_bilder AS b ON b.saft_id = s.id
WHERE p.status=1 AND s.status=1
ORDER BY s.bewertung_sterne DESC, b.freigestellt DESC, b.extern DESC, s.stempel ASC";
if ($limit && is_numeric($limit)) {
$query .= "
LIMIT {$limit}";
}
$result = $pdo->query($query);
$rows = $result->fetchAll(PDO::FETCH_ASSOC);
foreach($rows as &$row) {
self::add_image($row);
}
return $rows;
}
/**
* add_image
*
* @param $data
*/
private static function add_image(&$data) {
$data['img'] = "img/biotraubensaft-flasche_anonym.png";
$data['has_img'] = false;
if (strlen($data["freigestellt"]) > 0) {
$data['img'] = sprintf("img/saefte/freigestellt/%s", $data['freigestellt']);
$data['has_img'] = true;
} else if (strlen($data["extern"]) > 0 && $data["bildstatus"] == 1) {
$data['img'] = sprintf("img/saefte/extern/%s", $data["extern"]);
$data['has_img'] = true;
}
}
}