Subversion-Projekte lars-tiefland.laravel_shop

    use App\Models\Order;

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

            $start = 0;

            $sql = "SELECT

                    MAX(id) AS start

                FROM

                    orders

            ";

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

            if ( $row[0]->start )

            {

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

            }

            $sql = "SELECT

                    *

                FROM

                    Bestellung

                WHERE

                    id>" . $start . "

            ";

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

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

            $progressbar->start();

            foreach ( $orders as $oldOrder )

            {

                $order = new Order();

                $order->id = $oldOrder->ID;

                $order->order_type_id = $oldOrder->bestellart;

                $order->save();

                $progressbar->advance();

            }

            $progressbar->finish();

        {

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

            $start = 0;

            $sql = "SELECT

                    MAX(id) AS start

                FROM

                    order_items

            ";

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

            if ( $row[0]->start )

            {

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

            }

            $sql = "SELECT

                    *

                FROM

                    artikel_to_Bestellung

                WHERE

                    id>" . $start . "

            ";

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

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

            $progressbar->start();

            foreach ( $orderItems as $oldOrderItem )

            {

                $progressbar->advance();

            }