aboutsummaryrefslogtreecommitdiff
path: root/app/Http/Controllers
diff options
context:
space:
mode:
Diffstat (limited to 'app/Http/Controllers')
-rw-r--r--app/Http/Controllers/AdminBookmarksController.php15
-rw-r--r--app/Http/Controllers/AdminGuestbookController.php34
-rw-r--r--app/Http/Controllers/AdminImportController.php69
-rw-r--r--app/Http/Controllers/BookmarksController.php15
-rw-r--r--app/Http/Controllers/CalculatorsController.php13
-rw-r--r--app/Http/Controllers/ComputersController.php13
-rw-r--r--app/Http/Controllers/GuestbookController.php49
-rw-r--r--app/Http/Controllers/HomeController.php32
-rw-r--r--app/Http/Controllers/MusicController.php69
9 files changed, 289 insertions, 20 deletions
diff --git a/app/Http/Controllers/AdminBookmarksController.php b/app/Http/Controllers/AdminBookmarksController.php
new file mode 100644
index 0000000..c7d8afd
--- /dev/null
+++ b/app/Http/Controllers/AdminBookmarksController.php
@@ -0,0 +1,15 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\BookmarkCategory;
+use Illuminate\Support\Facades\DB;
+use Illuminate\View\View;
+
+class AdminBookmarksController extends Controller
+{
+ public function show() : View {
+ $categories = BookmarkCategory::with('sites')->get();
+ return view('admin.bookmarks', compact('categories'));
+ }
+}
diff --git a/app/Http/Controllers/AdminGuestbookController.php b/app/Http/Controllers/AdminGuestbookController.php
new file mode 100644
index 0000000..5ebf451
--- /dev/null
+++ b/app/Http/Controllers/AdminGuestbookController.php
@@ -0,0 +1,34 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\GuestbookEntry;
+use Illuminate\Support\Facades\DB;
+use Illuminate\View\View;
+use UAParser\Parser;
+
+class AdminGuestbookController extends Controller
+{
+ function getGuestbookUniqueAddr(): int {
+ $uniqueIpsCount = DB::table('guestbook__entries')->distinct()->count('ip');
+ return $uniqueIpsCount;
+ }
+
+ function getGuestbookEntriesCount(): int {
+ $entryCount = DB::table('guestbook__entries')->count();
+ return $entryCount;
+ }
+ public function show() : View {
+ $guestbook_unique_addr = $this->getGuestbookUniqueAddr();
+ $guestbook_entry_count = $this->getGuestbookEntriesCount();
+ $entries = GuestbookEntry::selectEntries();
+ $parser = Parser::create();
+
+ return view('admin.guestbook', [
+ 'guestbook_unique_addr' => $guestbook_unique_addr,
+ 'guestbook_entry_count' => $guestbook_entry_count,
+ 'entries' => $entries,
+ 'parser' => $parser,
+ ]);
+ }
+}
diff --git a/app/Http/Controllers/AdminImportController.php b/app/Http/Controllers/AdminImportController.php
new file mode 100644
index 0000000..dc32cec
--- /dev/null
+++ b/app/Http/Controllers/AdminImportController.php
@@ -0,0 +1,69 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\BookmarkCategory;
+use App\Models\BookmarkSite;
+use App\Models\GuestbookEntry;
+use Exception;
+use Illuminate\Http\Request;
+use Illuminate\View\View;
+
+class AdminImportController extends Controller
+{
+ public function show() : View {
+ return view('admin.import');
+ }
+
+ public function submit(Request $request)
+ {
+ $request->validate([
+ 'data_file' => 'required|mimes:json',
+ ]);
+
+ $file = $request->file('data_file');
+ $jsonContent = file_get_contents($file->getRealPath());
+ $data = json_decode($jsonContent, true);
+ $tables = [];
+ foreach($data as $item) {
+ if ($item['type'] !== "table") continue;
+ $tables[$item['name']] = [
+ 'data' => $item['data'],
+ 'count' => count($item['data'])
+ ];
+
+ if ($item['name'] === "guestbook__entries") {
+ GuestbookEntry::importGuestbookEntry($item['data']);
+ }
+ $this->import($item['data'], $item['name']);
+ }
+ return view('admin.import-success', ['tables' => $tables]);
+ }
+
+ /**
+ * Imports the given data to the specified table
+ *
+ * @param array $data The data to import
+ * @param string $table_name The name of the table to import to
+ * @return void
+ * @throws Exception Invalid table specified, to be replaced with custom exception
+ */
+ public function import(array $data, string $table_name): void {
+ switch ($table_name) {
+ case 'guestbook__entries':
+ GuestbookEntry::importGuestbookEntry($data);
+ break;
+ case 'bookmark__categories' :
+ BookmarkCategory::importBookmarkCategory($data);
+ break;
+ case 'bookmark__sites':
+ BookmarkSite::importBookmark($data);
+ break;
+ case 'guestbook__bans':
+ break;
+ default:
+ // TODO: Replace with custom exception
+ throw new Exception("Invalid table specified ($table_name)");
+ }
+ }
+}
diff --git a/app/Http/Controllers/BookmarksController.php b/app/Http/Controllers/BookmarksController.php
new file mode 100644
index 0000000..56aacc7
--- /dev/null
+++ b/app/Http/Controllers/BookmarksController.php
@@ -0,0 +1,15 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\BookmarkSite;
+use App\Models\BookmarkCategory;
+use Illuminate\View\View;
+
+class BookmarksController extends Controller
+{
+ public function show() : View {
+ $categories = BookmarkCategory::with('sites')->get();
+ return view('bookmarks', compact('categories'));
+ }
+}
diff --git a/app/Http/Controllers/CalculatorsController.php b/app/Http/Controllers/CalculatorsController.php
new file mode 100644
index 0000000..38a7a41
--- /dev/null
+++ b/app/Http/Controllers/CalculatorsController.php
@@ -0,0 +1,13 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+use Illuminate\View\View;
+
+class CalculatorsController extends Controller
+{
+ public function show() : View {
+ return view('calculators');
+ }
+}
diff --git a/app/Http/Controllers/ComputersController.php b/app/Http/Controllers/ComputersController.php
new file mode 100644
index 0000000..e16e70d
--- /dev/null
+++ b/app/Http/Controllers/ComputersController.php
@@ -0,0 +1,13 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+use Illuminate\View\View;
+
+class ComputersController extends Controller
+{
+ public function show() : View {
+ return view('computers');
+ }
+}
diff --git a/app/Http/Controllers/GuestbookController.php b/app/Http/Controllers/GuestbookController.php
index 70707d7..df726ef 100644
--- a/app/Http/Controllers/GuestbookController.php
+++ b/app/Http/Controllers/GuestbookController.php
@@ -2,37 +2,46 @@
namespace App\Http\Controllers;
+use App\Models\GuestbookEntry;
use Illuminate\Http\Request;
-use DB;
+use Illuminate\Http\RedirectResponse;
+use Illuminate\Contracts\View\View;
+use Illuminate\Validation\ValidationException;
+use UAParser\Parser;
class GuestbookController extends Controller {
- public function guestbook() {
- return view('pages.guestbook');
+ public function show(): View {
+ $entries = GuestbookEntry::selectEntries();
+ $parser = Parser::create();
+
+ return view('guestbook')
+ ->with('entries', $entries)
+ ->with('parser', $parser);
}
- public function guestbookPost(Request $request) {
+ /**
+ * Creates a new guestbook entry
+ *
+ * @param Request $request
+ * @return RedirectResponse
+ * @throws ValidationException
+ */
+ public function addEntry(Request $request): RedirectResponse {
$this->validate($request, [
'name' => 'required',
'message' => 'required'
]);
- $matching_bans = DB::select('SELECT reason FROM guestbook__bans WHERE ip_address = ?', array($request->ip()));
-
- if (!empty($matching_bans)) {
- return view('errors.guestbook-ipban')->with('reason', $matching_bans[0]->reason);
- }
-
- DB::insert(
- 'INSERT INTO guestbook__entries (name, timestamp, ip_address, agent, message) values (?, ?, ?, ?, ?)',
- [
- htmlspecialchars($request->get('name')),
- time(),
- $request->ip(),
- $request->userAgent(),
- htmlspecialchars($request->get('message'))
- ]
- );
+ GuestbookEntry::insertGuestbookEntry($request);
return back()->with('success', 'Entry submitted successfully!');
}
+
+ public function banIP(string $addr) {
+ // TODO: Add banning system
+ // $matching_bans = DB::select('SELECT reason FROM guestbook__bans WHERE ip_address = ?', array($request->ip()));
+ // if (!empty($matching_bans)) {
+ // return view('errors.guestbook-ipban')->with('reason', $matching_bans[0]->reason);
+ // }
+ }
}
diff --git a/app/Http/Controllers/HomeController.php b/app/Http/Controllers/HomeController.php
new file mode 100644
index 0000000..3fad094
--- /dev/null
+++ b/app/Http/Controllers/HomeController.php
@@ -0,0 +1,32 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\View\View;
+use DateTime;
+
+class HomeController extends Controller
+{
+ /**
+ * Returns age based on birthday date and current date (GMT)
+ * @return int
+ */
+ function returnAge(): int
+ {
+ date_default_timezone_set('Europe/London');
+ $birthday = new DateTime("2005-06-07");
+ $currentDate = DateTime::createFromFormat("Y-m-d", date("Y-m-d"));
+ $age = $birthday->diff($currentDate);
+ return $age->y;
+ }
+
+ /**
+ * Shows home page
+ * @return View
+ */
+ public function show() : View {
+ return view('home', [
+ 'age' => $this->returnAge()
+ ]);
+ }
+}
diff --git a/app/Http/Controllers/MusicController.php b/app/Http/Controllers/MusicController.php
new file mode 100644
index 0000000..5e31d86
--- /dev/null
+++ b/app/Http/Controllers/MusicController.php
@@ -0,0 +1,69 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Support\Facades\Cache;
+use Illuminate\Support\Facades\Config;
+use Illuminate\Support\Facades\Http;
+use Illuminate\View\View;
+
+class MusicController extends Controller
+{
+ public function getCurrentTrack() {
+ // If it's already cached just return that
+ if (Cache::has('current_track')) {
+ return Cache::get('current_track');
+ }
+
+ $response = Http::withQueryParameters([
+ 'method' => 'user.getrecenttracks',
+ 'user' => Config::get('services.lastfm.user'),
+ 'format' => 'json',
+ 'nowplaying' => 'true',
+ 'api_key' => Config::get('services.lastfm.key')
+ ])->get('https://ws.audioscrobbler.com/2.0/');
+ $data = $response->json();
+ error_log($response->body());
+ $track_data = $data["recenttracks"]["track"][0];
+ $current_track = [
+ 'title' => $track_data["name"],
+ 'artist' => $track_data["artist"]["#text"],
+ 'url' => $track_data["url"],
+ ];
+ Cache::put('current_track', $current_track, now()->addSeconds(15));
+ return $current_track;
+ }
+
+ public function getTopTracks() {
+ // If it's already cached just return that
+ if (Cache::has('top_tracks')) {
+ return Cache::get('top_tracks');
+ }
+
+ $response = Http::withQueryParameters([
+ 'method' => 'user.gettoptracks',
+ 'user' => Config::get('services.lastfm.user'),
+ 'format' => 'json',
+ 'period' => '1month',
+ 'limit' => 10,
+ 'api_key' => Config::get('services.lastfm.key')
+ ])->get('https://ws.audioscrobbler.com/2.0/');
+ $data = $response->json();
+ $topTracks = [];
+ foreach ($data["toptracks"]["track"] as $track) {
+ $topTracks[] = [
+ 'title' => $track["name"],
+ 'artist' => $track["artist"]["name"],
+ 'url' => $track["url"],
+ 'plays' => $track["playcount"],
+ ];
+ }
+ Cache::put('top_tracks', $topTracks, now()->addSeconds(15));
+ return $topTracks;
+ }
+ public function show() : View {
+ return view('music')
+ ->with('current_track', $this->getCurrentTrack())
+ ->with('top_tracks', $this->getTopTracks());
+ }
+}
generated by cgit v1.2.3-54-g00ecf (git 2.39.0) at 2024-11-01 07:25:52 +0000