Beispiel #1
0
function viewDVDList()
{
    $dbh = new Database();
    $sth = $dbh->prepare("SELECT id FROM " . DB_PREFIX . "dvds WHERE status = 1 OR status = 2 AND show_frontpage = true ORDER BY id DESC");
    $sth->execute();
    $dvdCount = 0;
    while ($id = $sth->fetchColumn()) {
        $dvdCount++;
        $dvd = new DVD();
        $dvd->load($id);
        include '../views/frontpage/singleDVD.php';
    }
    if ($dvdCount == 0) {
        include '../views/frontpage/noDVDs.php';
    }
}
<?php

$catalog = new DVD();
$id = abs((int) $_GET['id']);
$band = trim(strip_tags($_GET['band']));
$title = trim(strip_tags($_GET['title']));
$result = $catalog->showAlbum($id);
if (!is_array($result)) {
    $errMsg = $result;
} else {
    echo "<p>Всего треков: " . count($result) . "</p>";
    ?>
	<form action="catalog.php" method="post">
	<input type="hidden" name="action" value="list"/>
	<table border="1" width="100%">
	<tr align="center"><th>Исполнитель: <?php 
    echo $band;
    ?>
. Альбом: <?php 
    echo $title;
    ?>
</th></tr>
	<tr>
		<th>Трек</th>
	</tr>
<?php 
    foreach ($result as $item) {
        $id = $item['id'];
        $track = $item['title'];
        echo <<<LABEL
\t\t<tr>
<?php

switch ($_POST['action']) {
    case 'order':
        $titles = $_POST['order'];
        foreach ($titles as $title) {
            $dvd = new DVD($title);
            $dvd->buy();
        }
        break;
    case 'anthology':
        $band = trim(strip_tags($_POST['band']));
        $type = (int) $_POST['bonus'] ? 'bonus' : '';
        $tracks = array_map(function ($val) {
            return (int) $val;
        }, $_POST['order']);
        // $dvd = new DVD();
        $dvd = DVDFactory::create($type);
        $dvd->setBand($band);
        foreach ($tracks as $track) {
            $dvd->addTrack($track);
        }
        break;
    case 'list':
        $id = abs((int) $_POST['id']);
        $type = (int) $_POST['format'];
        $band = trim(strip_tags($_POST['band']));
        $title = trim(strip_tags($_POST['title']));
        // $dvd = new DVD();
        $dvd = new DVDStrategy();
        if ($type) {
Beispiel #4
0
if (empty($data['author'])) {
    $errors[] = 'DVD:n tekijä on pakollinen.';
}
if (!filter_var($data['email'], FILTER_VALIDATE_EMAIL)) {
    $errors[] = 'Email on virheellinen.';
}
if (!empty($data['publishDate']) && !preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])\$/", $data['publishDate'])) {
    $errors[] = 'Julkaisupäivämäärän muoto tulee olla YYYY-MM-DD';
}
if (!empty($data['deadlineDate']) && !preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])\$/", $data['deadlineDate'])) {
    $errors[] = 'Ehdotusten deadlinen muoto tulee olla YYYY-MM-DD';
}
if (!empty($errors)) {
    include '../controllers/viewFrontpage.php';
} else {
    $dvd = new DVD();
    $dvd->title = htmlspecialchars($data['title']);
    $dvd->author = htmlspecialchars($data['author']);
    $dvd->email = htmlspecialchars($data['email']);
    $dvd->publishDate = empty($data['publishDate']) ? null : $data['publishDate'];
    $dvd->deadlineDate = empty($data['deadlineDate']) ? null : $data['deadlineDate'];
    $dvd->description = empty($data['description']) ? null : htmlspecialchars($data['description']);
    if (!empty($data['status']) && $data['status'] == 'active') {
        $dvd->status = 1;
    } else {
        $dvd->status = 0;
    }
    if (!empty($data['showFrontpage']) && $data['showFrontpage'] == 'show') {
        $dvd->showFrontpage = 1;
    } else {
        $dvd->showFrontpage = 0;
Beispiel #5
0
 function __construct($id = 0)
 {
     parent::__construct();
     $this->_tracks[] = -1;
 }
<?php

$catalog = new DVD();
$band = trim(strip_tags($_GET['band']));
$result = $catalog->showBand($band);
if (!is_array($result)) {
    $errMsg = $result;
} else {
    echo "<p>Всего треков: " . count($result) . "</p>";
    ?>
	<form action="catalog.php" method="post">
	<input type="hidden" name="action" value="anthology"/>
	<table border="1" width="100%">
	<tr align="center"><th colspan="4">Исполнитель: <?php 
    echo $band;
    ?>
</th></tr>
	<tr>
		<th>Альбом</th>
		<th>Трек</th>
		<th>Выбрать для заказа</th>
	</tr>
<?php 
    foreach ($result as $item) {
        $id = $item['id'];
        $title = $item['title'];
        $track = $item['track'];
        echo <<<LABEL
\t\t<tr>
\t\t\t<td>{$title}</td>
\t\t\t<td>{$track}</td>
Beispiel #7
0
<?php

$dvd = (int) $URL[0];
$url = urlencode($URL[1]);
$adminHash = $URL[2];
$dbh = new Database();
$sth = $dbh->prepare("SELECT id FROM " . DB_PREFIX . "dvds WHERE id = ? AND admin_hash = ?");
$sth->execute(array($dvd, $adminHash));
$result = $sth->fetchColumn();
if (empty($result)) {
    header('Location: ' . SITE_URL);
}
$publicUrl = SITE_URL . '/' . $dvd . '/' . $url;
$adminUrl = SITE_URL . '/' . $dvd . '/' . $url . '/' . $adminHash;
$currentDVD = new DVD();
$currentDVD->load($dvd);
if (empty($_POST)) {
    $data = array('title' => $currentDVD->title, 'author' => $currentDVD->author, 'email' => $currentDVD->email, 'description' => $currentDVD->description);
    if (!empty($currentDVD->publishDate)) {
        $data['publishDate'] = date("Y-m-d", strtotime($currentDVD->publishDate));
    }
    if (!empty($currentDVD->deadlineDate)) {
        $data['deadlineDate'] = date("Y-m-d", strtotime($currentDVD->deadlineDate));
    }
    switch ($currentDVD->status) {
        case 1:
            $data['status'] = 'active';
        case 2:
            $data['status'] = 'published';
        default:
            $data['status'] = 'inactive';
Beispiel #8
0
 function __construct($dispositivo)
 {
     $this->tipoDispositivo = "Dvd";
     parent::__construct($dispositivo);
     echo $this->ip . "-" . $this->modeloIPLT . "-" . $this->strMarca . "-" . $this->strModelo . "-" . $this->id_disp . "-" . $this->tipoPuerto . "-" . $this->numeroPuerto . "-" . $this->baudRate . "-" . $this->timeOut . "-" . $this->puerto . "-" . $this->password;
 }
<?php

$catalog = new DVD();
$result = $catalog->showCatalog();
if (!is_array($result)) {
    $errMsg = $result;
} else {
    echo "<p>Всего записей в каталоге: " . count($result) . "</p>";
    ?>
	<form action="catalog.php" method="post">
	<input type="hidden" name="action" value="order"/>
	<table border="1" width="100%">
	<tr>
		<th>Название</th>
		<th>Исполнитель</th>
		<th>Количество</th>
		<th>Выбрать для заказа</th>
	</tr>
<?php 
    foreach ($result as $item) {
        $id = $item['id'];
        $title = $item['title'];
        $band = $item['band'];
        $quantity = $item['quantity'];
        echo <<<LABEL
\t\t<tr>
\t\t\t<td><a href="catalog.php?action=list&id={$id}&band={$band}&title={$title}">{$title}</a></td>
\t\t\t<td><a href="catalog.php?action=anthology&band={$band}">{$band}</a></td>
\t\t\t<td>{$quantity}</td>
\t\t\t<td><input type="checkbox" name="order[]" value="{$id}"></td>
\t\t</tr>
Beispiel #10
0
if (empty($data['author'])) {
    $errors[] = 'DVD:n tekijä on pakollinen.';
}
if (!filter_var($data['email'], FILTER_VALIDATE_EMAIL)) {
    $errors[] = 'Email on virheellinen.';
}
if (!empty($data['publishDate']) && !preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])\$/", $data['publishDate'])) {
    $errors[] = 'Julkaisupäivämäärän muoto tulee olla YYYY-MM-DD';
}
if (!empty($data['deadlineDate']) && !preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])\$/", $data['deadlineDate'])) {
    $errors[] = 'Ehdotusten deadlinen muoto tulee olla YYYY-MM-DD';
}
if (!empty($errors)) {
    include '../controllers/admin.php';
} else {
    $dvd = new DVD();
    $dvd->load($dvdID);
    $dvd->title = htmlspecialchars($data['title']);
    $dvd->author = htmlspecialchars($data['author']);
    $dvd->email = htmlspecialchars($data['email']);
    $dvd->publishDate = empty($data['publishDate']) ? null : $data['publishDate'];
    $dvd->deadlineDate = empty($data['deadlineDate']) ? null : $data['deadlineDate'];
    $dvd->description = empty($data['description']) ? null : htmlspecialchars($data['description']);
    if (!empty($data['status']) && $data['status'] == 'active') {
        $dvd->status = 1;
    } else {
        $dvd->status = 0;
    }
    if (!empty($data['showFrontpage']) && $data['showFrontpage'] == 'show') {
        $dvd->showFrontpage = 1;
    } else {