From 0db1d4862fd9036777fa56929cc682437a3f1204 Mon Sep 17 00:00:00 2001 From: Vincent Vanwaelscappel Date: Tue, 12 Jul 2022 11:15:40 +0200 Subject: [PATCH] wip #4209 @0.25 --- app/Console/Commands/WorkshopMigration.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/app/Console/Commands/WorkshopMigration.php b/app/Console/Commands/WorkshopMigration.php index f7ab06506..66a3b3b4f 100644 --- a/app/Console/Commands/WorkshopMigration.php +++ b/app/Console/Commands/WorkshopMigration.php @@ -111,7 +111,7 @@ class WorkshopMigration extends CubistCommand // } FluidbookPublication::truncate(); - foreach (DB::table($this->_oldDB . '.books')->get() as $e) { + foreach (DB::table($this->_oldDB . '.books')->orderBy('book_id', 'desc')->get() as $e) { $this->line('Import ' . $e->book_id); $oldRoot = $this->_oldRoot . 'books/working/' . $e->book_id . '/'; $c = new FluidbookPublication(); @@ -157,7 +157,7 @@ class WorkshopMigration extends CubistCommand // Composition $composition = []; - foreach (DB::table($this->_oldDB . '.books_pages')->where('book_id', $e->book_id)->get() as $p) { + foreach (DB::table($this->_oldDB . '.book_pages')->where('book_id', $e->book_id)->get() as $p) { $composition[$p->book_page] = [$p->document_id, $p->document_page]; } $c->setAttribute('composition', $composition); -- 2.39.5