Cody Cook
8f3061ab99
Some checks failed
SonarQube Scan / SonarQube Trigger (push) Failing after 5m39s
279 lines
8.9 KiB
PHP
279 lines
8.9 KiB
PHP
<?php
|
|
|
|
namespace DJMixHosting;
|
|
|
|
use DateTime;
|
|
use Exception;
|
|
|
|
class Mix
|
|
{
|
|
private int $id = -1;
|
|
private bool $enabled = false;
|
|
private string $name = "";
|
|
private string $slug = "";
|
|
private $db;
|
|
private string $description = "";
|
|
private string $cover = "";
|
|
private string $url = "";
|
|
private int $seconds = 0;
|
|
private bool $download_only = true;
|
|
private array $djs = [];
|
|
private array $genres = [];
|
|
private ?string $recorded = null;
|
|
private int $downloads = 0;
|
|
private ?string $created = null;
|
|
private ?string $updated = null;
|
|
private int $playcount = 0;
|
|
private $tracklist = [];
|
|
private bool $loadDJs = true;
|
|
private array $related_mixes = [];
|
|
private array $duration = [];
|
|
private array $mixshow = [];
|
|
|
|
/**
|
|
* Construct a Mix object using either an ID or slug.
|
|
*
|
|
* @param mixed $value The mix identifier (ID or slug).
|
|
* @param mixed $db Database connection.
|
|
* @param bool $loadDJs Whether to load DJ objects.
|
|
*/
|
|
public function __construct($value, $db, bool $loadDJs = true)
|
|
{
|
|
$this->db = $db;
|
|
$this->loadDJs = $loadDJs;
|
|
|
|
if (ctype_digit((string)$value)) {
|
|
$this->id = (int)$value;
|
|
$loaded = $this->loadById();
|
|
} else {
|
|
$this->slug = $value;
|
|
$loaded = $this->loadBySlug();
|
|
}
|
|
|
|
if (!$loaded) {
|
|
throw new Exception("Mix not found.");
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Loads mix data by its ID.
|
|
*/
|
|
private function loadById(): bool
|
|
{
|
|
$mix = $this->getMixById();
|
|
if ($mix && !empty($mix['title'])) {
|
|
return $this->buildMix($mix);
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Loads mix data by its slug.
|
|
*/
|
|
private function loadBySlug(): bool
|
|
{
|
|
$mix = $this->getMixBySlug();
|
|
if ($mix && !empty($mix['title'])) {
|
|
return $this->buildMix($mix);
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Retrieve mix data by ID.
|
|
*/
|
|
private function getMixById(): ?array
|
|
{
|
|
// If the current user is admin, show all mixes;
|
|
// Otherwise, only return mixes with pending = 0.
|
|
$isAdmin = isset($_SESSION['user']) &&
|
|
isset($_SESSION['user']['role']) &&
|
|
$_SESSION['user']['role'] === 'admin';
|
|
$query = $isAdmin
|
|
? "SELECT * FROM mix WHERE id = ?"
|
|
: "SELECT * FROM mix WHERE id = ? AND pending = 0";
|
|
|
|
$stmt = $this->db->prepare($query);
|
|
$stmt->bind_param("i", $this->id);
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
$mix = $result->fetch_assoc();
|
|
$stmt->close();
|
|
return $mix ?: null;
|
|
}
|
|
|
|
/**
|
|
* Retrieve mix data by slug.
|
|
*/
|
|
private function getMixBySlug(): ?array
|
|
{
|
|
$isAdmin = isset($_SESSION['user']) &&
|
|
isset($_SESSION['user']['role']) &&
|
|
$_SESSION['user']['role'] === 'admin';
|
|
$query = $isAdmin
|
|
? "SELECT * FROM mix WHERE slug = ?"
|
|
: "SELECT * FROM mix WHERE slug = ? AND pending = 0";
|
|
|
|
$stmt = $this->db->prepare($query);
|
|
$stmt->bind_param("s", $this->slug);
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
$mix = $result->fetch_assoc();
|
|
$stmt->close();
|
|
return $mix ?: null;
|
|
}
|
|
|
|
/**
|
|
* Build the mix object from database data.
|
|
*/
|
|
private function buildMix(array $mix): bool
|
|
{
|
|
$this->id = (int)$mix['id'];
|
|
$this->name = $mix['title'] ?? "";
|
|
$this->slug = $mix['slug'] ?? "";
|
|
$this->description = $mix['description'] ?? "";
|
|
$this->cover = $this->legacyFix($mix['cover'] ?? "");
|
|
$this->url = $this->legacyFix($mix['url'] ?? "");
|
|
$this->seconds = (int)($mix['seconds'] ?? 0);
|
|
$this->duration = $this->configureDuration();
|
|
$this->download_only = (bool)($mix['mediaplayer'] ?? true);
|
|
$this->recorded = $mix['recorded'] ?? null;
|
|
$this->created = $mix['created'] ?? null;
|
|
$this->updated = $mix['lastupdated'] ?? null;
|
|
$this->enabled = (bool)($mix['pending'] ?? false);
|
|
|
|
if ($this->loadDJs) {
|
|
require_once 'DJ.php';
|
|
$this->djs[] = new DJ($mix['dj1'], $this->db);
|
|
if (!empty($mix['dj2'])) {
|
|
$this->djs[] = new DJ($mix['dj2'], $this->db);
|
|
}
|
|
if (!empty($mix['dj3'])) {
|
|
$this->djs[] = new DJ($mix['dj3'], $this->db);
|
|
}
|
|
$this->djs = array_filter($this->djs);
|
|
}
|
|
|
|
$this->loadMixMeta();
|
|
$this->tracklist = $this->evaluateTracklist();
|
|
return true;
|
|
}
|
|
|
|
/**
|
|
* Fix legacy URL paths.
|
|
*/
|
|
private function legacyFix(string $item): string
|
|
{
|
|
if (str_starts_with($item, "/djs/")) {
|
|
return "https://cdn.utahsdjs.com" . substr($item, 4);
|
|
}
|
|
return $item;
|
|
}
|
|
|
|
/**
|
|
* Configure a formatted duration based on seconds.
|
|
*/
|
|
private function configureDuration(): array
|
|
{
|
|
$seconds = $this->seconds;
|
|
$hours = floor($seconds / 3600);
|
|
$minutes = floor(($seconds / 60) % 60);
|
|
$secs = $seconds % 60;
|
|
$time = ($hours > 0)
|
|
? sprintf("%02d:%02d:%02d", $hours, $minutes, $secs)
|
|
: sprintf("%02d:%02d", $minutes, $secs);
|
|
return [
|
|
'h' => $hours,
|
|
'm' => $minutes,
|
|
's' => $secs,
|
|
't' => $time,
|
|
'S' => $this->seconds
|
|
];
|
|
}
|
|
|
|
/**
|
|
* Load mix meta data.
|
|
*/
|
|
private function loadMixMeta(): void
|
|
{
|
|
$stmt = $this->db->prepare("SELECT attribute, value FROM mix_meta WHERE mix_id = ?");
|
|
$stmt->bind_param("i", $this->id);
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
$meta = $result->fetch_all(MYSQLI_ASSOC);
|
|
$stmt->close();
|
|
|
|
foreach ($meta as $entry) {
|
|
switch ($entry['attribute']) {
|
|
case "genre":
|
|
$this->genres[] = $entry['value'];
|
|
break;
|
|
case "related":
|
|
$this->related_mixes[] = $entry['value'];
|
|
break;
|
|
case "playcount":
|
|
$this->playcount = (int)$entry['value'];
|
|
break;
|
|
case "downloads":
|
|
$this->downloads = (int)$entry['value'];
|
|
break;
|
|
case "tracklist":
|
|
$this->tracklist = $entry['value'];
|
|
break;
|
|
case "mixshow":
|
|
$this->mixshow[] = $entry['value'];
|
|
break;
|
|
default:
|
|
// Handle additional meta attributes if needed.
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Evaluate the tracklist data.
|
|
*/
|
|
private function evaluateTracklist()
|
|
{
|
|
if (empty($this->tracklist)) {
|
|
return [];
|
|
}
|
|
if (is_array($this->tracklist)) {
|
|
return $this->tracklist;
|
|
}
|
|
return explode("\n", (string)$this->tracklist);
|
|
}
|
|
|
|
// Getter methods for mix properties.
|
|
|
|
public function getId(): int { return $this->id; }
|
|
public function getName(): string { return $this->name; }
|
|
public function getSlug(): string { return $this->slug; }
|
|
public function getDescription(): string { return $this->description; }
|
|
public function getCover(): string { return $this->cover; }
|
|
public function getUrl(): string { return $this->url; }
|
|
public function getSeconds(): int { return $this->seconds; }
|
|
public function isDownloadOnly(): bool { return $this->download_only; }
|
|
public function getDJs(): array { return $this->djs; }
|
|
public function getGenres(): array { return $this->genres; }
|
|
public function getRecorded(): ?string { return $this->recorded; }
|
|
public function getDownloads(): int { return $this->downloads; }
|
|
public function getCreated(): ?string { return $this->created; }
|
|
public function getUpdated(): ?string { return $this->updated; }
|
|
public function getPlaycount(): int { return $this->playcount; }
|
|
public function getTracklist(): array { return $this->evaluateTracklist(); }
|
|
public function getRelatedMixes(): array { return $this->related_mixes; }
|
|
public function getDuration(): array { return $this->duration; }
|
|
public function getMixshow(): array { return $this->mixshow; }
|
|
|
|
public function getDownloadUrl(): string
|
|
{
|
|
return "https://beta.utahsdjs.com/mix/{$this->slug}/download";
|
|
}
|
|
|
|
public function getPageUrl(): string
|
|
{
|
|
return "https://beta.utahsdjs.com/mix/{$this->slug}";
|
|
}
|
|
}
|