Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 845 Revision 846
Zeile 362... Zeile 362...
362 
        }
 362 
        }
Zeile 363... Zeile 363...
363 
 
 363 
 
364 
        private function migrateActions()
 364 
        private function migrateActions()
365 
        {
 365 
        {
366 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
 - 
 
367 
            $start = 0;
 - 
 
368 
            $sql = "SELECT
 - 
 
369 
                    MAX(id) AS start
 - 
 
370 
                FROM
 - 
 
371 
                    actions
 - 
 
372 
            ";
 - 
 
373 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
374 
            if ( $row[0]->start )
 - 
 
375 
            {
 - 
 
376 
                $start = $row[0]->start;
 - 
 
377 
            }
 366 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
378 
            $sql = "
 367 
            $sql = "
379 
                SELECT
 368 
                SELECT
380 
                    *
 369 
                    *
381 
                FROM
 370 
                FROM
382 
                    Aktionen
 - 
 
383 
                WHERE
 - 
 
384 
                    id>" . $start . "
 371 
                    Aktionen
385 
            ";
 372 
            ";
386 
            $actions = DB::connection( 'old' )->select( $sql );
 373 
            $actions = DB::connection( 'old' )->select( $sql );
387 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
 374 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
388 
            $progressbar->start();
 375 
            $progressbar->start();
389 
            foreach ( $actions as $action )
 376 
            foreach ( $actions as $action )
- 
 
 377 
            {
- 
 
 378 
                $actionDB = Action::find( $action->ID );
- 
 
 379 
                if ( !isset( $actionDB->id ) )
390 
            {
 380 
                {
391 
                $actionDB = new Action();
 381 
                    $actionDB = new Action();
- 
 
 382 
                    $actionDB->id = $action->ID;
- 
 
 383 
                    $actionDB->created_by = "WebanOS Laravel Upgrade";
392 
                $actionDB->id = $action->ID;
 384 
                }
393 
                $actionDB->headline = $action->headline;
 385 
                $actionDB->headline = $action->headline;
394 
                $actionDB->text = $action->text;
 386 
                $actionDB->text = $action->text;
395 
                $actionDB->rang = $action->rang;
 387 
                $actionDB->rang = $action->rang;
396 
                $actionDB->config = $action->config;
 388 
                $actionDB->config = $action->config;
397 
                $actionDB->category = $action->Kategorie;
 389 
                $actionDB->category = $action->Kategorie;
398 
                $actionDB->notes = $action->notizen;
 390 
                $actionDB->notes = $action->notizen;
399 
                $actionDB->valid_from = $action->von;
 391 
                $actionDB->valid_from = $action->von;
400 
                $actionDB->valid_to = $action->bis;
 - 
 
401 
                $actionDB->created_by = "WebanOS Laravel Upgrade";
 392 
                $actionDB->valid_to = $action->bis;
402 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
 393 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
403 
                $actionDB->save();
 394 
                $actionDB->save();
404 
                $this->migrateActionMedia( $actionDB->id );
 395 
                $this->migrateActionMedia( $actionDB->id );
405 
                $progressbar->advance();
 396 
                $progressbar->advance();