Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 615 Revision 618
Zeile 1378... Zeile 1378...
1378
            $progressbar->clear();
1378
            $progressbar->clear();
1379
            $start = 0;
1379
            $start = 0;
1380
            $sql = "SELECT
1380
            $sql = "SELECT
1381
                    MAX(id) start
1381
                    MAX(id) start
1382
                FROM
1382
                FROM
-
 
1383
                    item_templates
-
 
1384
            ";
-
 
1385
            $row = DB::connection( 'mysql' )->select( $sql );
-
 
1386
            if ( $row[0]->start )
-
 
1387
            {
-
 
1388
                $start = $row[0]->start;
-
 
1389
            }
-
 
1390
            $sql = "SELECT
-
 
1391
                    *
-
 
1392
                FROM
-
 
1393
                    templates_to_artikel
-
 
1394
                WHERE
-
 
1395
                    id>" . $start . "
-
 
1396
            ";
-
 
1397
            $templates = DB::connection( 'old' )->select( $sql );
-
 
1398
            $progressbar = $this->output->createProgressBar( count( $templates ) );
-
 
1399
            $progressbar->start();
-
 
1400
            foreach ( $templates as $template )
-
 
1401
            {
-
 
1402
                DirectoryTemplate::factory()->create( [
-
 
1403
                    "id"           => $template->id,
-
 
1404
                    "item_id"      => $template->directory_ID,
-
 
1405
                    "template_id"  => $template->templates_ID,
-
 
1406
                ] );
-
 
1407
                $progressbar->advance();
-
 
1408
            }
-
 
1409
            $progressbar->finish();
-
 
1410
            $progressbar->clear();
-
 
1411
            $start = 0;
-
 
1412
            $sql = "SELECT
-
 
1413
                    MAX(id) start
-
 
1414
                FROM
1383
                    directory_templates
1415
                    directory_templates
1384
            ";
1416
            ";
1385
            $row = DB::connection( 'mysql' )->select( $sql );
1417
            $row = DB::connection( 'mysql' )->select( $sql );
1386
            if ( $row[0]->start )
1418
            if ( $row[0]->start )
1387
            {
1419
            {
Zeile 1406... Zeile 1438...
1406
                ] );
1438
                ] );
1407
                $progressbar->advance();
1439
                $progressbar->advance();
1408
            }
1440
            }
1409
            $progressbar->finish();
1441
            $progressbar->finish();
1410
            $progressbar->clear();
1442
            $progressbar->clear();
1411
 
-
 
1412
        }
1443
        }
1413
    }
1444
    }