diff options
Diffstat (limited to 'app/Models')
-rw-r--r-- | app/Models/BookmarkCategory.php | 36 | ||||
-rw-r--r-- | app/Models/BookmarkSite.php | 35 | ||||
-rw-r--r-- | app/Models/GuestbookEntry.php | 50 |
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(); - } - } -} |