Subversion-Projekte lars-tiefland.laravel_shop

        private function migrateShippings()

        {

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

            $start = 0;

            $sql = "SELECT

                    MAX(id) AS start

                FROM

                    shippings

            ";

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

            if ( $row[ 0 ]->start )

            {

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

            }

            $sql = "SELECT

                    *

                FROM

                    versand

                WHERE

                    id>" . $start . "

            ";

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

            foreach ( $methods as $group )

            {

                ShippingGroup::factory()->create( [

                    "id"                => $group->id,

                    "rank"              => $group->rang,

                    "shipping_group_id" => $group->versandgruppen_id,

                    "name"              => $group->name,

                    "info_shop"         => $group->info_shop,

                    "info_mail"         => $group->info_mail,

                    "info_internal"     => $group->info_intern,

                    "island_shipping"   => $group->inselversand,

                    "additions"         => $group->zusaetze,

                    "status"            => $group->status,

                    "price"             => $group->preis,

                    "calc_weight_from"  => $group->berechnung_kg_von,

                    "calc_weight_to"    => $group->berechnung_kg_bis,

                    "calc_price_from"   => $group->berechnung_preis_von,

                    "calc_price_to"     => $group->berechnung_preis_bis,

                    "conditions"        => $group->bedingungen,

                    "tax_rate"          => $group->steuersatz,

                    "created_by"        => $group->erstellt_von,

                    "updated_by"        => $group->geaendert_von,

                    "updated_at"        => $group->geaendert_am,

                    "created_at"        => $group->erstellt_am,

                ] );

            }

        }