From 9e8949e73ea94e40d84cc83e2cacf2f08a6bd11f Mon Sep 17 00:00:00 2001
From: Zach DeCook <zachdecook@librem.one>
Date: Thu, 6 Feb 2025 17:27:44 +0000
Subject: Songs page: seed the random order for suggestions

---
 laravel/app/Song.php | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'laravel/app/Song.php')

diff --git a/laravel/app/Song.php b/laravel/app/Song.php
index b8d2e4c..ed2bf25 100644
--- a/laravel/app/Song.php
+++ b/laravel/app/Song.php
@@ -3,6 +3,7 @@
 namespace App;
 
 use Illuminate\Database\Eloquent\Model;
+use Illuminate\Support\Facades\DB;
 use App\Http\Controllers\SongController;
 use TechWilk\BibleVerseParser\BiblePassageParser;
 
@@ -13,6 +14,11 @@ class Song extends Model
     {
         return $this->belongsToMany('App\Playlist');
     }
+    public function scopeInRandomOrderSeeded($query, $id = 0) {
+        $seed = ((intval(now()->unix()/600) . $id)%100000)/100000;
+        DB::query()->selectRaw("SETSEED($seed)")->get();
+        $query->inRandomOrder();
+    }
     public static function whereVerse($passage)
     {
     	$parser = new BiblePassageParser();
-- 
cgit 1.4.1