Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 793 Revision 794
Zeile 60... Zeile 60...
60 
            $this->migrateOrderTypes();
 60 
            $this->migrateOrderTypes();
61 
            $this->migratePaymentMethods();
 61 
            $this->migratePaymentMethods();
62 
            $this->migrateShippingGroups();
 62 
            $this->migrateShippingGroups();
63 
            $this->migrateShippings();
 63 
            $this->migrateShippings();
64 
            $this->migrateManufacturers();
 64 
            $this->migrateManufacturers();
- 
 
 65 
            $this->migrateMedia();
65 
            $this->migrateActions();
 66 
            $this->migrateActions();
66 
            $this->migrateDirs();
 67 
            $this->migrateDirs();
67 
            $this->migrateItems();
 68 
            $this->migrateItems();
68 
            $this->migrateTemplates();
 69 
            $this->migrateTemplates();
69 
            $this->migrateSalesPortals();
 70 
            $this->migrateSalesPortals();
70 
            $this->migrateSalesPortalItems();
 71 
            $this->migrateSalesPortalItems();
71 
            $this->migrateMedia();
 - 
 
72 
            $this->migrateActionMedia();
 - 
 
73 
            $this->migrateDirMedia();
 - 
 
74 
            $this->migrateItemMedia();
 - 
 
75 
            if ( env( 'site' ) == env( 'shop' ) )
 72 
            if ( env( 'site' ) == env( 'shop' ) )
76 
            {
 73 
            {
77 
                $this->migratePriceAgencies();
 74 
                $this->migratePriceAgencies();
78 
                $this->migrateUsers();
 75 
                $this->migrateUsers();
79 
                $this->migrateAddresses();
 76 
                $this->migrateAddresses();
Zeile 354... Zeile 351...
354 
                $actionDB->valid_from = $action->von;
 351 
                $actionDB->valid_from = $action->von;
355 
                $actionDB->valid_to = $action->bis;
 352 
                $actionDB->valid_to = $action->bis;
356 
                $actionDB->created_by = "WebanOS Laravel Upgrade";
 353 
                $actionDB->created_by = "WebanOS Laravel Upgrade";
357 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
 354 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
358 
                $actionDB->save();
 355 
                $actionDB->save();
- 
 
 356 
                $this->migrateActionMedia( $actionDB->id );
359 
                $progressbar->advance();
 357 
                $progressbar->advance();
360 
            }
 358 
            }
361 
            $progressbar->finish();
 359 
            $progressbar->finish();
362 
            $progressbar->clear();
 360 
            $progressbar->clear();
363 
        }
 361 
        }
Zeile 364... Zeile 362...
364 
 
 362 
 
365 
        private function migrateDirs()
 363 
        private function migrateDirs()
366 
        {
 364 
        {
367 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );
 - 
 
368 
            $start = -10;
 - 
 
369 
            $sql = "SELECT
 - 
 
370 
                    MAX(id) AS start
 - 
 
371 
                FROM
 - 
 
372 
                    directories
 - 
 
373 
            ";
 - 
 
374 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
375 
            if ( $row[0]->start )
 - 
 
376 
            {
 - 
 
377 
                $start = $row[0]->start;
 - 
 
378 
            }
 365 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );
379 
            $sql = '
 366 
            $sql = '
380 
                SELECT
367 
                SELECT
381 
                    *
 368 
                    *
382 
                FROM
 369 
                FROM
383 
                    directory
 - 
 
384 
                WHERE
 - 
 
385 
                    id>' . $start . '
 370 
                    directory
386 
            ';
 371 
            ';
387 
            $dirs = DB::connection( 'old' )->select( $sql );
 372 
            $dirs = DB::connection( 'old' )->select( $sql );
388 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
 373 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
389 
            $progressbar->start();
 374 
            $progressbar->start();
390 
            DB::statement( 'SET FOREIGN_KEY_CHECKS=0' );
 375 
            DB::statement( 'SET FOREIGN_KEY_CHECKS=0' );
391 
            foreach ( $dirs as $row )
 376 
            foreach ( $dirs as $row )
- 
 
 377 
            {
- 
 
 378 
                $dir = Directory::find( $row->ID );
- 
 
 379 
                if ( isset( $dir->id ) )
- 
 
 380 
                {
- 
 
 381 
                    $progressbar->advance();
- 
 
 382 
                    continue;
392 
            {
 383 
                }
393 
                $ersteller = $row->erstellt_von;
 384 
                $ersteller = $row->erstellt_von;
394 
                if ( !$ersteller )
 385 
                if ( !$ersteller )
395 
                {
 386 
                {
396 
                    $ersteller = "WebanOS Laravel Upgrade";
 387 
                    $ersteller = "WebanOS Laravel Upgrade";
Zeile 413... Zeile 404...
413 
                $dir->created_at = $row->erstellt_am;
 404 
                $dir->created_at = $row->erstellt_am;
414 
                $dir->created_by = $ersteller;
 405 
                $dir->created_by = $ersteller;
415 
                $dir->updated_by = $bearbeiter;
 406 
                $dir->updated_by = $bearbeiter;
416 
                $dir->updated_at = $row->letzte_Aenderung_am;
 407 
                $dir->updated_at = $row->letzte_Aenderung_am;
417 
                $dir->save();
 408 
                $dir->save();
- 
 
 409 
                $this->migrateDirMedia( $dir->id );
418 
                $progressbar->advance();
 410 
                $progressbar->advance();
419 
            }
 411 
            }
420 
            $progressbar->finish();
 412 
            $progressbar->finish();
421 
            $progressbar->clear();
 413 
            $progressbar->clear();
422 
            DB::statement( 'SET FOREIGN_KEY_CHECKS=1' );
 414 
            DB::statement( 'SET FOREIGN_KEY_CHECKS=1' );
Zeile 465... Zeile 457...
465 
                    $bearbeiter = "WebanOS Laravel Upgrade";
 457 
                    $bearbeiter = "WebanOS Laravel Upgrade";
466 
                }
 458 
                }
467 
                $item->created_by = $ersteller;
 459 
                $item->created_by = $ersteller;
468 
                $item->updated_by = $bearbeiter;
 460 
                $item->updated_by = $bearbeiter;
469 
                $item->save();
 461 
                $item->save();
- 
 
 462 
                $this->migrateItemMedia( $item->id );
470 
                $progressbar->advance();
 463 
                $progressbar->advance();
471 
            }
 464 
            }
472 
            $progressbar->finish();
 465 
            $progressbar->finish();
473 
            $progressbar->clear();
 466 
            $progressbar->clear();
474 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );
 467 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );
Zeile 573... Zeile 566...
573 
            }
 566 
            }
574 
            $progressbar->finish();
 567 
            $progressbar->finish();
575 
            $progressbar->clear();
 568 
            $progressbar->clear();
576 
        }
 569 
        }
Zeile 577... Zeile 570...
577 
 
 570 
 
578 
        public function migrateActionMedia()
 571 
        public function migrateActionMedia( $aktionId )
579 
        {
 - 
 
580 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
 - 
 
581 
            $start = 0;
 - 
 
582 
            $sql = "SELECT
 - 
 
583 
                    MAX(id) AS start
 - 
 
584 
                FROM
 - 
 
585 
                    action_media
 - 
 
586 
            ";
 - 
 
587 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
588 
            if ( $row[0]->start )
 - 
 
589 
            {
 - 
 
590 
                $start = $row[0]->start;
 - 
 
591 
            }
 572 
        {
592 
            $sql = "SELECT
 573 
            $sql = "SELECT
593 
                    *
 574 
                    *
594 
                FROM
 575 
                FROM
595 
                    aktionen_medien
 576 
                    aktionen_medien
596 
                WHERE
 577 
                WHERE
597 
                    id>" . $start . "
 578 
                    id=" . $aktionId . "
598 
            ";
 579 
            ";
599 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
600 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 - 
 
601 
            $progressbar->start();
 580 
            $media = DB::connection( 'old' )->select( $sql );
602 
            foreach ( $media as $row )
 581 
            foreach ( $media as $row )
- 
 
 582 
            {
- 
 
 583 
                $medium = new ActionMedium( $row->ID );
- 
 
 584 
                if ( isset( $medium->id ) )
- 
 
 585 
                {
- 
 
 586 
                    continue;
603 
            {
 587 
                }
604 
                $medium = new ActionMedium();
 588 
                $medium = new ActionMedium();
605 
                $medium->action_id = $row->aktionen_id;
 589 
                $medium->action_id = $row->aktionen_id;
606 
                $medium->medium_id = $row->medien_id;
 590 
                $medium->medium_id = $row->medien_id;
607 
                $medium->rank = $row->rang;
 591 
                $medium->rank = $row->rang;
608 
                $medium->created_by = "WebanOS Laravel Upgrade";
 592 
                $medium->created_by = "WebanOS Laravel Upgrade";
609 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 593 
                $medium->updated_by = "WebanOS Laravel Upgrade";
610 
                $medium->save();
 - 
 
611 
                $progressbar->advance();
 594 
                $medium->save();
612 
            }
 - 
 
613 
            $progressbar->finish();
 - 
 
614 
            $progressbar->clear();
 595 
            }
Zeile 615... Zeile 596...
615 
        }
 596 
        }
616 
 
 597 
 
617 
        public function migrateDirMedia()
 - 
 
618 
        {
 - 
 
619 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
 - 
 
620 
            $start = 0;
 - 
 
621 
            $sql = "SELECT
 - 
 
622 
                    MAX(medium_id) AS start
 - 
 
623 
                FROM
 - 
 
624 
                    directory_media
 - 
 
625 
            ";
 - 
 
626 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
627 
            if ( $row[0]->start )
 - 
 
628 
            {
 - 
 
629 
                $start = $row[0]->start;
 598 
        public function migrateDirMedia( $dir )
630 
            }
 599 
        {
631 
            $sql = "SELECT
 600 
            $sql = "SELECT
632 
                    *
 601 
                    *
633 
                FROM
 602 
                FROM
634 
                    directory_medien
 603 
                    directory_medien
635 
                WHERE
 604 
                WHERE
636 
                    medien_id>" . $start . "
 605 
                    directory_id=" . $dir . "
637 
            ";
 - 
 
638 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
639 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 606 
            ";
640 
            $progressbar->start();
 607 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 608 
            foreach ( $media as $row )
- 
 
 609 
            {
- 
 
 610 
                $medium = DirectoryMedium::find( $row->medium_id );
- 
 
 611 
                if ( isset( $medium->medium_id ) )
- 
 
 612 
                {
641 
            foreach ( $media as $row )
 613 
                    continue;
642 
            {
 614 
                }
643 
                $medium = new DirectoryMedium();
 615 
                $medium = new DirectoryMedium();
644 
                $medium->directory_id = $row->directory_id;
 616 
                $medium->directory_id = $row->directory_id;
645 
                $medium->medium_id = $row->medien_id;
 617 
                $medium->medium_id = $row->medien_id;
646 
                $medium->rank = $row->rang;
 618 
                $medium->rank = $row->rang;
647 
                $medium->similar = $row->aehnlich;
 619 
                $medium->similar = $row->aehnlich;
648 
                $medium->created_at = $row->zugeordnet_am;
 620 
                $medium->created_at = $row->zugeordnet_am;
649 
                $medium->updated_at = $row->zugeordnet_am;
 621 
                $medium->updated_at = $row->zugeordnet_am;
650 
                $medium->created_by = "WebanOS Laravel Upgrade";
 622 
                $medium->created_by = "WebanOS Laravel Upgrade";
651 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 - 
 
652 
                $medium->save();
 623 
                $medium->updated_by = "WebanOS Laravel Upgrade";
653 
                $progressbar->advance();
 - 
 
654 
            }
 - 
 
655 
            $progressbar->finish();
 624 
                $medium->save();
Zeile 656... Zeile 625...
656 
            $progressbar->clear();
 625 
            }
657 
        }
 626 
        }
658 
 
 - 
 
659 
        public function migrateItemMedia()
 - 
 
660 
        {
 - 
 
661 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
 - 
 
662 
            $start = 0;
 - 
 
663 
            $sql = "SELECT
 - 
 
664 
                    MAX(medium_id) AS start
 - 
 
665 
                FROM
 - 
 
666 
                    item_media
 - 
 
667 
            ";
 - 
 
668 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
669 
            if ( $row[0]->start )
 - 
 
670 
            {
 627 
 
671 
                $start = $row[0]->start;
 628 
        public function migrateItemMedia( $item )
672 
            }
 629 
        {
673 
            $sql = "SELECT
 630 
            $sql = "SELECT
674 
                    *
 631 
                    *
675 
                FROM
 632 
                FROM
676 
                    artikel_medien
 633 
                    artikel_medien
677 
                WHERE
 634 
                WHERE
678 
                    medien_id>" . $start . "
 - 
 
679 
            ";
 - 
 
680 
            $media = DB::connection( 'old' )->select( $sql );
 635 
                    item_id=" . $item . "
681 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 636 
            ";
- 
 
 637 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 638 
            foreach ( $media as $row )
- 
 
 639 
            {
- 
 
 640 
                $medium = ItemMedium::find( $row->medium_id );
- 
 
 641 
                if ( isset( $medium->medium_id ) )
682 
            $progressbar->start();
 642 
                {
683 
            foreach ( $media as $row )
 643 
                    continue;
684 
            {
 644 
                }
685 
                $medium = new ItemMedium();
 645 
                $medium = new ItemMedium();
686 
                $medium->item_id = $row->artikel_id;
 646 
                $medium->item_id = $row->artikel_id;
687 
                $medium->medium_id = $row->medien_id;
 647 
                $medium->medium_id = $row->medien_id;
688 
                $medium->rank = $row->rang;
 648 
                $medium->rank = $row->rang;
689 
                $medium->similar = $row->aehnlich;
 649 
                $medium->similar = $row->aehnlich;
690 
                $medium->created_at = $row->zugeordnet_am;
 650 
                $medium->created_at = $row->zugeordnet_am;
691 
                $medium->updated_at = $row->zugeordnet_am;
 651 
                $medium->updated_at = $row->zugeordnet_am;
692 
                $medium->created_by = "WebanOS Laravel Upgrade";
 - 
 
693 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 652 
                $medium->created_by = "WebanOS Laravel Upgrade";
694 
                $medium->save();
 - 
 
695 
                $progressbar->advance();
 - 
 
696 
            }
 653 
                $medium->updated_by = "WebanOS Laravel Upgrade";
Zeile 697... Zeile 654...
697 
            $progressbar->finish();
 654 
                $medium->save();
698 
            $progressbar->clear();
 655 
            }
699 
        }
 656 
        }