Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 204 Revision 249
Zeile 1... Zeile 1...
1
<?php
1
<?php
Zeile 2... Zeile 2...
2
 
2
 
Zeile -... Zeile 3...
-
 
3
    namespace Database\Seeders;
3
    namespace Database\Seeders;
4
 
4
 
5
    use App\Models\Directory;
5
    use App\Models\Item;
6
    use App\Models\Item;
-
 
7
    use Illuminate\Database\Console\Seeds\WithoutModelEvents;
6
    use Illuminate\Database\Console\Seeds\WithoutModelEvents;
8
    use Illuminate\Database\Seeder;
Zeile 7... Zeile 9...
7
    use Illuminate\Database\Seeder;
9
    use Illuminate\Support\Facades\DB;
8
    use Illuminate\Support\Str;
10
    use Illuminate\Support\Str;
9
 
11
 
Zeile 44... Zeile 46...
44
            Item::factory()->create( [
46
            Item::factory()->create( [
45
                "id"           => 1000,
47
                "id"           => 1000,
46
                "directory_id" => -3,
48
                "directory_id" => -3,
47
                "name"         => "Versandkosten",
49
                "name"         => "Versandkosten",
48
            ] );
50
            ] );
49
            Item::factory()->create( [
51
            $sql = '
50
                "id"           => 115000,
52
                SELECT 
51
                "directory_id" => 1,
53
                    *
52
                "name"         => "Testartikel",
-
 
53
            ] );
54
                FROM
54
            Item::factory()->create( [
55
                    artikel
55
                "directory_id" => 1,
56
                WHERE
56
                "name"         => "Testartikel 2",
57
                    father>-1
57
            ] );
58
            ';
58
            Item::factory()->create( [
59
            $dirs = DB::connection( 'old' )->select( $sql );
59
		"status"       => 1,
-
 
60
		"directory_id" => 1,
-
 
61
                "name"         => "Testartikel 3",
60
            foreach ( $dirs as $row )
62
            ] );
61
            {
63
            Item::factory()->create( [
62
                $dir = new Directory();
64
                "directory_id" => 1,
63
                $dir->id = $row->ID;
65
                "name"         => "Testartikel 4",
64
                $dir->directory_id = $row->Father;
66
            ] );
65
                $dir->name = $row->Name;
67
            Item::factory()->create( [
66
                $dir->status = $row->status;
68
                "directory_id" => 1,
67
                $dir->kennung = $row->Kennung;
69
                "name"         => "Testartikel 5",
68
                $dir->description = $row->Beschreibung;
70
            ] );
-
 
71
            Item::factory()->create( [
69
                $dir->created_at = $row->erstellt_am;
72
                "directory_id" => 8,
70
                $dir->updated_at = $row->letzte_Aenderung_am;
73
                "name"         => "Testartikel",
71
                $dir->save();
74
            ] );
72
            }
75
        }
73
        }
76
    }
74
    }