Subversion-Projekte lars-tiefland.laravel_shop

        public function migrateMedia()

        {

            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );

            $sql = "

                SELECT

                    *

                FROM

                    medien

            ";

            $media = DB::connection( 'old' )->select( $sql );

            $progressbar = $this->output->createProgressBar( count( $media ) );

            $progressbar->start();

            foreach ( $media as $medium )

            {

                $mediumDB = new Medium();

                $mediumDB->id = $medium->id;

                $mediumDB->name = $medium->name;

                $mediumDB->folder = $medium->folder;

                $mediumDB->medium_type_id = $medium->typ;

                $mediumDB->description = $medium->beschreibung;

                if ( $medium->erstellt_am )

                {

                    $mediumDB->created_at = date( "Y-m-d H:i:s", $medium->erstellt_am );

                }

                $ersteller = $medium->erstellt_von;

                if ( !$ersteller )

                {

                    $ersteller = "WebanOS Laravel Upgrade";

                }

                $bearbeiter = $medium->letzte_aenderung_von;

                if ( !$bearbeiter )

                {

                    $bearbeiter = "WebanOS Laravel Upgrade";

                }

                $mediumDB->created_by = $ersteller;

                $mediumDB->updated_by = $bearbeiter;

                $mediumDB->save();

                $progressbar->advance();

            }

            $progressbar->finish();

            $progressbar->clear();

        }

        public function migrateDirMedia()

        {

            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );

            $sql = "SELECT

                    *

                FROM

                    directory_medien

            ";

            $media = DB::connection( 'old' )->select( $sql );

            $progressbar = $this->output->createProgressBar( count( $media ) );

            $progressbar->start();

            foreach ( $media as $row )

            {

                $medium = new DirectoryMedium();

                $medium->directory_id = $row->directory_id;

                $medium->medium_id = $row->medien_id;

                $medium->rank = $row->rang;

                $medium->similar = $row->aehnlich;

                $medium->created_at = $row->zugeordnet_am;

                $medium->updated_at = $row->zugeordnet_am;

                $medium->created_by = "WebanOS Laravel Upgrade";

                $medium->updated_by = "WebanOS Laravel Upgrade";

                $medium->save();

                $progressbar->advance();

            }

            $progressbar->finish();

            $progressbar->clear();

        }

        public function migrateItemMedia()

        {

            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );

            $sql = "SELECT

                    *

                FROM

                    artikel_medien

            ";

            $media = DB::connection( 'old' )->select( $sql );

            $progressbar = $this->output->createProgressBar( count( $media ) );

            $progressbar->start();

            foreach ( $media as $row )

            {

                $medium = new ItemMedium();

                $medium->item_id = $row->artikel_id;

                $medium->medium_id = $row->medien_id;

                $medium->rank = $row->rang;

                $medium->similar = $row->aehnlich;

                $medium->created_at = $row->zugeordnet_am;

                $medium->updated_at = $row->zugeordnet_am;

                $medium->created_by = "WebanOS Laravel Upgrade";

                $medium->updated_by = "WebanOS Laravel Upgrade";

                $medium->save();

                $progressbar->advance();

            }

            $progressbar->finish();

            $progressbar->clear();

        }

        {

            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );

            $start = 0;

            $sql = "SELECT

                    MAX(id) AS start

                FROM

                    orders

            ";

            $row = DB::connection( "order" )->select( $sql );

            if ( $row )

            {

                $start = $row[0]["start"];

            }

            $sql = "SELECT

                    *

                FROM

                    Bestellungen

                WHERE

                    id>" . $start . "

            ";

            $orders = DB::connection( "orderOld" )->select( $sql );

            foreach ( $orders as $oldOrder )

            {

                var_dump( $oldOrder );