Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 963 Revision 973
Zeile 1437... Zeile 1437...
1437
            }
1437
            }
1438
            $progressbar->finish();
1438
            $progressbar->finish();
1439
            $progressbar->clear();
1439
            $progressbar->clear();
1440
        }
1440
        }
Zeile 1441... Zeile 1441...
1441
 
1441
 
1442
        private function migrateWebSettings()
1442
        private function migrateWebSettings(): void
1443
        {
1443
        {
1444
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
1444
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
1445
            $sql = '
1445
            $sql = '
1446
                SELECT 
1446
                SELECT 
1447
                    *
1447
                    *
1448
                FROM
1448
                FROM
1449
                    web_settings
1449
                    web_settings
1450
            ';
1450
            ';
1451
            $websettings = DB::connection( 'old' )->select( $sql );
1451
            $webSettings = DB::connection( 'old' )->select( $sql );
1452
            $progressbar = $this->output->createProgressBar( count( $items ) );
1452
            $progressbar = $this->output->createProgressBar( count( $webSettings ) );
1453
            $progressbar->start();
1453
            $progressbar->start();
1454
            foreach ( $websettings as $row )
1454
            foreach ( $webSettings as $row )
1455
            {
1455
            {
1456
                $websetting = Item::find( $row->ID );
1456
                $webSetting = Item::find( $row->ID );
1457
                if ( !isset( $websetting->id ) )
1457
                if ( !isset( $webSetting->id ) )
1458
                {
1458
                {
1459
                    $websetting = new Item();
1459
                    $webSetting = new Item();
1460
                    $websetting->id = $row->ID;
1460
                    $webSetting->id = $row->ID;
1461
                    $websetting->created_at = time();
1461
                    $webSetting->created_at = time();
1462
                    $websetting->created_by = "";
1462
                    $webSetting->created_by = "";
1463
                }
1463
                }
1464
                $websetting->update_at = $row->letzte_Aenderiung_am;
1464
                $webSetting->update_at = $row->letzte_Aenderiung_am;
1465
                $websetting->update_by = $row->letzte_Aenderung_von;
1465
                $webSetting->update_by = $row->letzte_Aenderung_von;
1466
                $websetting->rank = $row->Rang;
1466
                $webSetting->rank = $row->Rang;
1467
                $websetting->name = $row->Name;
1467
                $webSetting->name = $row->Name;
1468
                $websetting->type = $row->Typ;
1468
                $webSetting->type = $row->Typ;
1469
                $websetting->content = $row->Inhalt;
1469
                $webSetting->content = $row->Inhalt;
1470
                $websetting->fallback = $row->FallbackU;
1470
                $webSetting->fallback = $row->FallbackU;
1471
                $websetting->save();
1471
                $webSetting->save();
1472
                $progressbar->advance();
1472
                $progressbar->advance();
1473
            }
1473
            }
1474
            $progressbar->finish();
1474
            $progressbar->finish();
1475
            $progressbar->clear();
1475
            $progressbar->clear();