Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 460 Revision 465
Zeile 11... Zeile 11...
11
    use App\Models\OrderAddress;
11
    use App\Models\OrderAddress;
12
    use App\Models\Price;
12
    use App\Models\Price;
13
    use App\Models\ActionMedium;
13
    use App\Models\ActionMedium;
14
    use App\Models\ItemMedium;
14
    use App\Models\ItemMedium;
15
    use App\Models\DirectoryMedium;
15
    use App\Models\DirectoryMedium;
-
 
16
    use App\Models\Shop;
16
    use App\Models\User;
17
    use App\Models\User;
17
    use Illuminate\Console\Command;
18
    use Illuminate\Console\Command;
18
    use Illuminate\Support\Facades\DB;
19
    use Illuminate\Support\Facades\DB;
Zeile 19... Zeile 20...
19
 
20
 
Zeile 40... Zeile 41...
40
         */
41
         */
Zeile 41... Zeile 42...
41
 
42
 
42
        public function handle(): void
43
        public function handle(): void
43
        {
44
        {
44
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung gestartet" );
45
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung gestartet" );
45
            /*$migrateDirs = true;
46
            $migrateDirs = true;
46
            if ( !$this->confirm( "Kategorien migrieren?" ) )
47
            if ( !$this->confirm( "Kategorien migrieren?" ) )
47
            {
48
            {
48
                $migrateDirs = false;
49
                $migrateDirs = false;
49
            }
50
            }
Zeile 87... Zeile 88...
87
                $this->migrateActions();
88
                $this->migrateActions();
88
                if ( $migrateMedia )
89
                if ( $migrateMedia )
89
                {
90
                {
90
                    $this->migrateActionMedia();
91
                    $this->migrateActionMedia();
91
                }
92
                }
92
            }*/
93
            }
-
 
94
            $this->migrateShops();
-
 
95
            if ( env( 'site' ) == env( 'shop' ) )
-
 
96
            {
93
            $this->migrateUsers();
97
                $this->migrateUsers();
94
            $this->migrateAddresses();
98
                $this->migrateAddresses();
95
            $this->migrateOrderAddresses();
99
                $this->migrateOrderAddresses();
96
            $this->migrateOrders();
100
                $this->migrateOrders();
97
            $this->migrateOrderItems();
101
                $this->migrateOrderItems();
-
 
102
            }
98
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
103
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
99
        }
104
        }
Zeile 100... Zeile 105...
100
 
105
 
101
        public function migrateMedia()
106
        public function migrateMedia()
Zeile 606... Zeile 611...
606
            }
611
            }
607
            $progressbar->finish();
612
            $progressbar->finish();
608
            $progressbar->clear();
613
            $progressbar->clear();
609
        }
614
        }
Zeile -... Zeile 615...
-
 
615
 
-
 
616
        private function migrateShops()
-
 
617
        {
-
 
618
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellungen" );
-
 
619
            $sql="SELECT
-
 
620
                    *
-
 
621
                FROM
-
 
622
                    shops
-
 
623
            ";
-
 
624
            $shops = DB::connection('old')->select($sql);
-
 
625
            foreach ( $shops as $oldShop )
-
 
626
            {
-
 
627
                $shop = new Shop();
-
 
628
                $shop->id=$oldShop->ID;
-
 
629
                $shop->name=$oldShop->Name;
-
 
630
                $shop->short=$oldShop->short;
-
 
631
                $shop->re_sort='';
-
 
632
                if(isset($oldShop->re_short)&&$oldShop->re_short)
-
 
633
                {
-
 
634
                    $shop->re_sort=$oldShop->re_short;
-
 
635
                }
-
 
636
                $shop->preisindex_ek=$oldShop->preisindex_ek;
-
 
637
                $shop->ebay=$oldShop->ebay;
-
 
638
                $shop->erfassung=$oldShop->erfassung;
-
 
639
                $shop->status=$oldShop->status;
-
 
640
                $shop->rank=$oldShop->rang;
-
 
641
                $shop->klonziel=$oldShop->klonziel;
-
 
642
                $shop->konroot=$oldShop->konroot;
-
 
643
                $shop->home=$oldShop->home;
-
 
644
                $shop->database=$oldShop->database;
-
 
645
                $shop->domain=$oldShop->domain;
-
 
646
                $shop->mail_server=$oldShop->mail_server;
-
 
647
                $shop->mail_user=$oldShop->mail_user;
-
 
648
                $shop->mail_password=$oldShop->mail_passwortr;
-
 
649
                $shop->save();
-
 
650
            }
-
 
651
        }
610
 
652