Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 421 | Revision 432 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 421 Revision 422
Zeile 36... Zeile 36...
36 
         */
 36 
         */
Zeile 37... Zeile 37...
37 
 
 37 
 
38 
        public function handle(): void
 38 
        public function handle(): void
39 
        {
 39 
        {
- 
 
 40 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung gestartet" );
- 
 
 41 
            $migrateDirs = true;
- 
 
 42 
            if ( !$this->confirm( "Kategorien migrieren?" ) )
- 
 
 43 
            {
- 
 
 44 
                $migrateDirs = false;
- 
 
 45 
            }
- 
 
 46 
            $migrateItems = true;
- 
 
 47 
            if ( !$this->confirm( "Artikel migrieren?" ) )
- 
 
 48 
            {
- 
 
 49 
                $migrateItems = false;
- 
 
 50 
            }
- 
 
 51 
            $migrateActions = true;
- 
 
 52 
            if ( !$this->confirm( "Aktionen migrieren?" ) )
- 
 
 53 
            {
- 
 
 54 
                $migrateActions = false;
- 
 
 55 
            }
- 
 
 56 
            $migrateMedia = true;
- 
 
 57 
            if ( !$this->confirm( "Medien migrieren?" ) )
- 
 
 58 
            {
- 
 
 59 
                $migrateMedia = false;
- 
 
 60 
            }
- 
 
 61 
            if ( $migrateActions )
40 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung gestartet" );
 62 
            {
- 
 
 63 
                $this->migrateMedia();
- 
 
 64 
            }
- 
 
 65 
            if ( $migrateDirs )
41 
            $this->migrateMedia();
 66 
            {
- 
 
 67 
                $this->migrateDirs();
- 
 
 68 
                if ( $migrateMedia )
- 
 
 69 
                {
- 
 
 70 
                    $this->migrateDirMedia();
- 
 
 71 
                }
- 
 
 72 
            }
- 
 
 73 
            if ( $migrateItems )
42 
            $this->migrateDirs();
 74 
            {
- 
 
 75 
                $this->migrateItems();
- 
 
 76 
                if ( $migrateMedia )
- 
 
 77 
                {
- 
 
 78 
                    $this->migrateItemMedia();
- 
 
 79 
                }
- 
 
 80 
            }
- 
 
 81 
            if ( $migrateActions )
43 
            $this->migrateItems();
 82 
            {
- 
 
 83 
                $this->migrateActions();
- 
 
 84 
                if ( $migrateMedia )
- 
 
 85 
                {
- 
 
 86 
                    $this->migrateActionMedia();
- 
 
 87 
                }
44 
            $this->migrateActions();
 88 
            }
45 
            $this->migrateUsers();
 89 
            $this->migrateUsers();
46 
            $this->migrateAddresses();
 90 
            $this->migrateAddresses();
47 
            $this->migrateOrderAddresses();
 91 
            $this->migrateOrderAddresses();
48 
            $this->migrateOrders();
 92 
            $this->migrateOrders();
Zeile 90... Zeile 134...
90 
                $dir->save();
 134 
                $dir->save();
91 
                $progressbar->advance();
 135 
                $progressbar->advance();
92 
            }
 136 
            }
93 
            $progressbar->finish();
 137 
            $progressbar->finish();
94 
            $progressbar->clear();
 138 
            $progressbar->clear();
95 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
 - 
 
96 
            $sql = "SELECT
 - 
 
97 
                    *
 - 
 
98 
                FROM
 - 
 
99 
                    directory_medien
 - 
 
100 
            ";
 - 
 
101 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
102 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 - 
 
103 
            $progressbar->start();
 - 
 
104 
            foreach ( $media as $row )
 - 
 
105 
            {
 - 
 
106 
                $medium = new DirectoryMedium();
 - 
 
107 
                $medium->directory_id = $row->directory_id;
 - 
 
108 
                $medium->medium_id = $row->medien_id;
 - 
 
109 
                $medium->rank = $row->rang;
 - 
 
110 
                $medium->similar = $row->aehnlich;
 - 
 
111 
                $medium->created_at = $row->zugeordnet_am;
 - 
 
112 
                $medium->updated_at = $row->zugeordnet_am;
 - 
 
113 
                $medium->created_by = "WebanOS Laravel Upgrade";
 - 
 
114 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 - 
 
115 
                $medium->save();
 - 
 
116 
                $progressbar->advance();
 - 
 
117 
            }
 - 
 
118 
            $progressbar->finish();
 - 
 
119 
            $progressbar->clear();
 - 
 
120 
        }
 139 
        }
Zeile 121... Zeile 140...
121 
 
 140 
 
122 
        private function migrateItems()
 141 
        private function migrateItems()
123 
        {
 142 
        {
Zeile 191... Zeile 210...
191 
                ] );
 210 
                ] );
192 
                $progressbar->advance();
 211 
                $progressbar->advance();
193 
            }
 212 
            }
194 
            $progressbar->finish();
 213 
            $progressbar->finish();
195 
            $progressbar->clear();
 214 
            $progressbar->clear();
196 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
 - 
 
197 
            $sql = "SELECT
 - 
 
198 
                    *
 - 
 
199 
                FROM
 - 
 
200 
                    artikel_medien
 - 
 
201 
            ";
 - 
 
202 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
203 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 - 
 
204 
            $progressbar->start();
 - 
 
205 
            foreach ( $media as $row )
 - 
 
206 
            {
 - 
 
207 
                $medium = new ItemMedium();
 - 
 
208 
                $medium->item_id = $row->artikel_id;
 - 
 
209 
                $medium->medium_id = $row->medien_id;
 - 
 
210 
                $medium->rank = $row->rang;
 - 
 
211 
                $medium->similar = $row->aehnlich;
 - 
 
212 
                $medium->created_at = $row->zugeordnet_am;
 - 
 
213 
                $medium->updated_at = $row->zugeordnet_am;
 - 
 
214 
                $medium->created_by = "WebanOS Laravel Upgrade";
 - 
 
215 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 - 
 
216 
                $medium->save();
 - 
 
217 
                $progressbar->advance();
 - 
 
218 
            }
 - 
 
219 
            $progressbar->finish();
 - 
 
220 
            $progressbar->clear();
 - 
 
221 
        }
 215 
        }
Zeile 222... Zeile 216...
222 
 
 216 
 
223 
        private function migrateActions()
 217 
        private function migrateActions()
224 
        {
 218 
        {
Zeile 249... Zeile 243...
249 
                $actionDB->save();
 243 
                $actionDB->save();
250 
                $progressbar->advance();
 244 
                $progressbar->advance();
251 
            }
 245 
            }
252 
            $progressbar->finish();
 246 
            $progressbar->finish();
253 
            $progressbar->clear();
 247 
            $progressbar->clear();
254 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
 - 
 
255 
            $sql = "SELECT
 - 
 
256 
                    *
 - 
 
257 
                FROM
 - 
 
258 
                    aktionen_medien
 - 
 
259 
            ";
 - 
 
260 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
261 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 - 
 
262 
            $progressbar->start();
 - 
 
263 
            foreach ( $media as $row )
 - 
 
264 
            {
 - 
 
265 
                $medium = new ActionMedium();
 - 
 
266 
                $medium->action_id = $row->aktionen_id;
 - 
 
267 
                $medium->medium_id = $row->medien_id;
 - 
 
268 
                $medium->rank = $row->rang;
 - 
 
269 
                $medium->created_by = "WebanOS Laravel Upgrade";
 - 
 
270 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 - 
 
271 
                $medium->save();
 - 
 
272 
                $progressbar->advance();
 - 
 
273 
            }
 - 
 
274 
            $progressbar->finish();
 - 
 
275 
            $progressbar->clear();
 - 
 
276 
        }
 248 
        }
Zeile 277... Zeile 249...
277 
 
 249 
 
278 
        public function migrateMedia()
 250 
        public function migrateMedia()
279 
        {
 251 
        {
Zeile 340... Zeile 312...
340 
 
 312 
 
341 
        private function migrateOrderItems()
 313 
        private function migrateOrderItems()
342 
        {
 314 
        {
343 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel in Besetllungen" );
 315 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel in Besetllungen" );
- 
 
 316 
        }
- 
 
 317 
 
- 
 
 318 
        public function migrateDirMedia()
- 
 
 319 
        {
- 
 
 320 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
- 
 
 321 
            $sql = "SELECT
- 
 
 322 
                    *
- 
 
 323 
                FROM
- 
 
 324 
                    directory_medien
- 
 
 325 
            ";
- 
 
 326 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 327 
            $progressbar = $this->output->createProgressBar( count( $media ) );
- 
 
 328 
            $progressbar->start();
- 
 
 329 
            foreach ( $media as $row )
- 
 
 330 
            {
- 
 
 331 
                $medium = new DirectoryMedium();
- 
 
 332 
                $medium->directory_id = $row->directory_id;
- 
 
 333 
                $medium->medium_id = $row->medien_id;
- 
 
 334 
                $medium->rank = $row->rang;
- 
 
 335 
                $medium->similar = $row->aehnlich;
- 
 
 336 
                $medium->created_at = $row->zugeordnet_am;
- 
 
 337 
                $medium->updated_at = $row->zugeordnet_am;
- 
 
 338 
                $medium->created_by = "WebanOS Laravel Upgrade";
- 
 
 339 
                $medium->updated_by = "WebanOS Laravel Upgrade";
- 
 
 340 
                $medium->save();
- 
 
 341 
                $progressbar->advance();
- 
 
 342 
            }
- 
 
 343 
            $progressbar->finish();
- 
 
 344 
            $progressbar->clear();
- 
 
 345 
        }
- 
 
 346 
 
- 
 
 347 
        public function migrateItemMedia()
- 
 
 348 
        {
- 
 
 349 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
- 
 
 350 
            $sql = "SELECT
- 
 
 351 
                    *
- 
 
 352 
                FROM
- 
 
 353 
                    artikel_medien
- 
 
 354 
            ";
- 
 
 355 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 356 
            $progressbar = $this->output->createProgressBar( count( $media ) );
- 
 
 357 
            $progressbar->start();
- 
 
 358 
            foreach ( $media as $row )
- 
 
 359 
            {
- 
 
 360 
                $medium = new ItemMedium();
- 
 
 361 
                $medium->item_id = $row->artikel_id;
- 
 
 362 
                $medium->medium_id = $row->medien_id;
- 
 
 363 
                $medium->rank = $row->rang;
- 
 
 364 
                $medium->similar = $row->aehnlich;
- 
 
 365 
                $medium->created_at = $row->zugeordnet_am;
- 
 
 366 
                $medium->updated_at = $row->zugeordnet_am;
- 
 
 367 
                $medium->created_by = "WebanOS Laravel Upgrade";
- 
 
 368 
                $medium->updated_by = "WebanOS Laravel Upgrade";
- 
 
 369 
                $medium->save();
- 
 
 370 
                $progressbar->advance();
- 
 
 371 
            }
- 
 
 372 
            $progressbar->finish();
- 
 
 373 
            $progressbar->clear();
- 
 
 374 
        }
- 
 
 375 
 
- 
 
 376 
        public function migrateActionMedia()
- 
 
 377 
        {
- 
 
 378 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
- 
 
 379 
            $sql = "SELECT
- 
 
 380 
                    *
- 
 
 381 
                FROM
- 
 
 382 
                    aktionen_medien
- 
 
 383 
            ";
- 
 
 384 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 385 
            $progressbar = $this->output->createProgressBar( count( $media ) );
- 
 
 386 
            $progressbar->start();
- 
 
 387 
            foreach ( $media as $row )
- 
 
 388 
            {
- 
 
 389 
                $medium = new ActionMedium();
- 
 
 390 
                $medium->action_id = $row->aktionen_id;
- 
 
 391 
                $medium->medium_id = $row->medien_id;
- 
 
 392 
                $medium->rank = $row->rang;
- 
 
 393 
                $medium->created_by = "WebanOS Laravel Upgrade";
- 
 
 394 
                $medium->updated_by = "WebanOS Laravel Upgrade";
- 
 
 395 
                $medium->save();
- 
 
 396 
                $progressbar->advance();
- 
 
 397 
            }
- 
 
 398 
            $progressbar->finish();
- 
 
 399 
            $progressbar->clear();
- 
 
 400 
        }
344 
        }
 401