Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

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