Subversion-Projekte lars-tiefland.laravel_shop

    namespace App\Console\Commands;

        {

            $typ = "Adressen";

            $table = "addresses";

            $oldTable = "adresse";

            if ( $isOrder === true )

            {

                $typ = "Bestelladressen";

                $table = "order_addresses";

                $oldTable = "bestelladresse";

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

            $start = 0;

            $sql = "SELECT

                    MAX(id) AS start

                FROM

                    " . $table . "

            ";

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

            if ( $row )

            {

                $start = $row[0]->start;

            }

            $sql = "SELECT

                    *

                FROM

                    " . $oldTable . "

                WHERE

                    id>" . $start . "

            ";

            $addresses = DB::connection( "oldOrder" )->select( $sql );

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

            $progressbar->star  t();

            foreach ( $addresses as $oldAddress )

            {

                $ersteller = "WebanOS Laravel Upgrade";

                $bearbeiter = "WebanOS Laravel Upgrade";

                $address = new Address();

                $address->id = $oldAddress->id;

                $address->user_id = $oldAddress->logins_id;

                $address->salutation = $oldAddress->anrede;

                $address->pro_title = $oldAddress->pro_title;

                $address->name = $oldAddress->vorname;

                $address->lastname = $oldAddress->nachname;

                $address->company = $oldAddress->firma;

                $address->company2 = $oldAddress->firma2;

                $address->street = $oldAddress->strasse1;

                $address->houseno = $oldAddress->str_nr1;

                $address->street2 = $oldAddress->strasse2;

                $address->zip = $oldAddress->plz;

                $address->city = $oldAddress->ort;

                $address->country_id = $oldAddress->land;

                $address->state_id = $oldAddress->state;

                $address->phone = $oldAddress->telefon;

                $address->fax = $oldAddress->fax;

                $address->email = $oldAddress->email;

                $address->nettocalculation = $oldAddress->nettoberechnung;

                $address->h_nr = $oldAddress->h_nr;

                $address->vat_id = $oldAddress->vat_id;

                $address->vat_free = $oldAddress->mwst_befreiung;

                $address->legal_form = $oldAddress->legal_form;

                $address->comment = $oldAddress->comment;

                $address->created_at = $oldAddress->letze_aenderung_am;

                $address->created_by = $ersteller;

                $address->updated_by = $bearbeiter;

                $address->updated_at = $oldAddress->letzte_aenderung_am;

                $address->save();

                $progressbar->advance();

            }

            $progressbar->finish();