Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 206 | Revision 247 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
2 lars 1 
<?php
2 
 
147 lars 3 
namespace Database\Seeders;
2 lars 4 
 
147 lars 5 
use App\Models\Directory;
6 
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
7 
use Illuminate\Database\Seeder;
246 lars 8 
use Illuminate\Support\Facades\DB;
168 lars 9 
use Illuminate\Support\Str;
2 lars 10 
 
147 lars 11 
class DirectorySeeder extends Seeder
12 
{
13 
    /**
14 
     * Run the database seeds.
15 
     *
16 
     * @return void
17 
     */
18 
    public function run(): void
2 lars 19 
    {
246 lars 20 
        /*Directory::factory()->create([
147 lars 21 
            "id" => -5,
22 
            "name" => "Gutschein",
23 
            "directory_id" => NULL,
24 
        ]);
25 
        Directory::factory()->create([
26 
            "id" => -3,
27 
            "name" => "Versand",
28 
            "directory_id" => NULL,
29 
        ]);
30 
        Directory::factory()->create([
31 
            "id" => -2,
32 
            "name" => "Papierkorb",
33 
            "directory_id" => NULL,
34 
        ]);
35 
        Directory::factory()->create([
36 
            "id" => -1,
37 
            "name" => "Root",
38 
            "directory_id" => NULL,
39 
        ]);
40 
        Directory::factory()->create([
41 
            "id" => 1,
205 lars 42 
            "name" => "Nach Zoll",
147 lars 43 
            "directory_id" => -1
44 
        ]);
45 
        Directory::factory()->create([
46 
            "id" => 2,
206 lars 47 
            "name" => "Pedelecs",
147 lars 48 
            "directory_id" => -1
49 
        ]);
50 
        Directory::factory()->create([
51 
            "id" => 3,
206 lars 52 
            "name" => "E-Lastenräder",
147 lars 53 
            "directory_id" => -1
54 
        ]);
55 
        Directory::factory()->create([
56 
            "id" => 4,
206 lars 57 
            "name" => "Zubehör",
147 lars 58 
            "directory_id" => -1
59 
        ]);
60 
        Directory::factory()->create([
61 
            "id" => 5,
205 lars 62 
            "name" => "16-18 Zoll",
147 lars 63 
            "directory_id" => 1
64 
        ]);
65 
        Directory::factory()->create([
66 
            "id" => 6,
205 lars 67 
            "name" => "20-22 Zoll",
147 lars 68 
            "directory_id" => 1
69 
        ]);
168 lars 70 
        Directory::factory()->Create([
205 lars 71 
            "name" => "24-26 Zoll",
72 
            "directory_id" => 1
202 lars 73 
        ]);
205 lars 74 
        Directory::factory()->Create([
75 
            "name" => "27,5-29,5 Zoll",
76 
            "directory_id" => 1
246 lars 77 
        ]);*/
78 
        $sql = '
79 
            SELECT
80 
                *
81 
            FROM
82 
                directory
83 
        ';
84 
        $dirs = DB::connection('old')->select($sql);
85 
        foreach ($dirs as $row)
86 
        {
87 
            //var_dump($row);
88 
            Directory::factory()->createQuietly([
89 
                "id"           => $row->ID,
90 
                "directory_id" => $row->Father,
91 
                "name"         => $row->Name,
92 
                "status"       => $row->status,
93 
                "kennung"      => $row->Kennung,
94 
                "description"  => $row->Beschreibung,
95 
                "short_line_1" => $row->short_line_1,
96 
                "url"          => $row->url,
97 
                "created_at"   => $row->erstellt_am,
98 
                "updated_at"   => $row->letzte_Aenderung_am,
99 
            ]);
100 
        }
2 lars 101 
    }
147 lars 102 
}