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) {
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;
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>
<?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';
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>
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 {