aboutsummaryrefslogtreecommitdiff
path: root/app/Models
diff options
context:
space:
mode:
Diffstat (limited to 'app/Models')
-rw-r--r--app/Models/BookmarkCategory.php36
-rw-r--r--app/Models/BookmarkSite.php35
-rw-r--r--app/Models/GuestbookEntry.php50
3 files changed, 0 insertions, 121 deletions
diff --git a/app/Models/BookmarkCategory.php b/app/Models/BookmarkCategory.php
deleted file mode 100644
index a8bc8d2..0000000
--- a/app/Models/BookmarkCategory.php
+++ /dev/null
@@ -1,36 +0,0 @@
-<?php
-
-namespace App\Models;
-
-use Illuminate\Database\Eloquent\Factories\HasFactory;
-use Illuminate\Database\Eloquent\Model;
-
-class BookmarkCategory extends Model
-{
- use HasFactory;
- protected $table = "bookmark__categories";
- protected $fillable = ['name'];
-
- public function sites() {
- return $this->hasMany(BookmarkSite::class, 'category');
- }
-
- public static function insertBookmarkCategory(string $name) {
- $newBookmarkCategory = new BookmarkCategory;
- $newBookmarkCategory->name = $name;
- $newBookmarkCategory->save();
- }
- public static function selectBookmarks(int $id) {
- $bookmarks = BookmarkSite::where('category', '=', $id)->firstOrFail();
- return $bookmarks;
- }
-
- public static function importBookmarkCategory(array $data) {
- foreach ($data as $category) {
- $newBookmarkCategory = new BookmarkCategory;
- $newBookmarkCategory->name = $category['name'];
- $newBookmarkCategory->priority = intval($category['priority']);
- $newBookmarkCategory->save();
- }
- }
-}
diff --git a/app/Models/BookmarkSite.php b/app/Models/BookmarkSite.php
deleted file mode 100644
index 3c9cc5d..0000000
--- a/app/Models/BookmarkSite.php
+++ /dev/null
@@ -1,35 +0,0 @@
-<?php
-
-namespace App\Models;
-
-use Illuminate\Database\Eloquent\Factories\HasFactory;
-use Illuminate\Database\Eloquent\Model;
-
-class BookmarkSite extends Model {
- use HasFactory;
- protected $table = "bookmark__sites";
- protected $fillable = ['name', 'description', 'url', 'category'];
-
- public function category() {
- return $this->belongsTo(BookmarkCategory::class, 'category');
- }
- public static function insertBookmark(string $name, string $url, int $category) {
- $category = BookmarkCategory::where('id', $category)->firstOrFail();
- $newBookmark = new BookmarkSite;
- $newBookmark->name = $name;
- $newBookmark->url = $url;
- $newBookmark->category = $category->id;
- $newBookmark->save();
- }
-
- public static function importBookmark(array $data) {
- foreach ($data as $site) {
- $newBookmark = new BookmarkSite;
- $newBookmark->name = $site['name'];
- $newBookmark->description = $site['description'];
- $newBookmark->url = $site['url'];
- $newBookmark->category = $site['category_id'];
- $newBookmark->save();
- }
- }
-}
diff --git a/app/Models/GuestbookEntry.php b/app/Models/GuestbookEntry.php
deleted file mode 100644
index f5e2de2..0000000
--- a/app/Models/GuestbookEntry.php
+++ /dev/null
@@ -1,50 +0,0 @@
-<?php
-
-namespace App\Models;
-
-use Illuminate\Http\Request;
-use Illuminate\Database\Eloquent\Factories\HasFactory;
-use Illuminate\Database\Eloquent\Model;
-
-class GuestbookEntry extends Model
-{
- use HasFactory;
- protected $table = "guestbook__entries";
- protected $fillable = ['name', 'message'];
-
- /**
- * Creates a new guestbook entry.
- *
- * @param Request $request The HTTP POST request
- * @return void
- */
- public static function insertGuestbookEntry(Request $request) {
- $newEntry = new GuestbookEntry;
- $newEntry->name = htmlspecialchars($request->get('name'));
- $newEntry->message = htmlspecialchars($request->get('message'));
- $newEntry->ip = $request->ip();
- $newEntry->agent = $request->userAgent();
- $newEntry->admin = auth()->check();
- $newEntry->save();
- }
-
- public static function selectEntries() {
- $entries = GuestbookEntry::orderBy('created_at', 'desc')->get();
- return $entries;
- }
-
- public static function importGuestbookEntry(array $data) {
- foreach ($data as $entry) {
- $dt = new \DateTime('@' . $entry['timestamp']);
- $newEntry = new GuestbookEntry;
- $newEntry->name = $entry['name'];
- $newEntry->ip = $entry['ip_address'];
- $newEntry->agent = $entry['agent'];
- $newEntry->admin = $entry['site_owner'];
- $newEntry->message = $entry['message'];
- $newEntry->created_at = $dt;
- $newEntry->updated_at = $dt;
- $newEntry->save();
- }
- }
-}