Order by Array | Rex's Personal Site

Sample

        $prods = $prods->orderBy(DB::raw('field(a.id, ' . implode(', ', $final_arr) . ')'))
            ->skip($skip)
            ->take($take)
            ->get();

$prods = $prods->orderBy(DB::raw('field(a.id, ' . implode(', ', $final_arr) . ')'))

->skip($skip)

->take($take)

->get();

Reference

https://stackoverflow.com/questions/8055138/mysql-sort-order-by-array-value
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_field
Could be replaced with orderRaw()
https://laravel.com/docs/8.x/queries

M	T	W	T	F	S	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30