Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 283 Revision 284
Zeile 53... Zeile 53...
53 
                    directory
 53 
                    directory
54 
            ';
 54 
            ';
55 
            $dirs = DB::connection( 'old' )->select( $sql );
 55 
            $dirs = DB::connection( 'old' )->select( $sql );
56 
            foreach ( $dirs as $row )
 56 
            foreach ( $dirs as $row )
57 
            {
 57 
            {
- 
 
 58 
                $ersteller = $row->erstellt_von;
58 
                //var_dump($row);
 59 
                if ( !$ersteller )
- 
 
 60 
                {
- 
 
 61 
                    $ersteller = "WebanOS Laravel Upgrade";
- 
 
 62 
                }
- 
 
 63 
                $bearbeiter = $row->letzte_aenderung_von;
- 
 
 64 
                if ( !$bearbeiter )
- 
 
 65 
                {
- 
 
 66 
                    $bearbeiter = "WebanOS Laravel Upgrade";
- 
 
 67 
                }
59 
                Directory::factory()->createQuietly( [
 68 
                Directory::factory()->createQuietly( [
60 
                    "id"           => $row->ID,
 69 
                    "id"           => $row->ID,
61 
                    "directory_id" => $row->Father,
 70 
                    "directory_id" => $row->Father,
62 
                    "name"         => $row->Name,
 71 
                    "name"         => $row->Name,
63 
                    "status"       => $row->status,
 72 
                    "status"       => $row->status,
64 
                    "kennung"      => $row->Kennung,
 73 
                    "kennung"      => $row->Kennung,
65 
                    "description"  => $row->Beschreibung,
 74 
                    "description"  => $row->Beschreibung,
66 
                    "short_line_1" => $row->short_line_1,
 75 
                    "short_line_1" => $row->short_line_1,
67 
                    "url"          => $row->url,
 76 
                    "url"          => $row->url,
68 
                    "created_at"   => $row->erstellt_am,
 77 
                    "created_at"   => $ersteller,
69 
                    "created_by"   => $row->erstellt_von,
 78 
                    "created_by"   => $row->erstellt_von,
70 
                    "updated_by"   => $row->letzte_Aenderung_von,
 79 
                    "updated_by"   => $bearbeiter,
71 
                    "updated_at"   => $row->letzte_Aenderung_am,
 80 
                    "updated_at"   => $row->letzte_Aenderung_am,
72 
                ] );
 81 
                ] );
73 
            }
 82 
            }
74 
        }
 83 
        }
Zeile 85... Zeile 94...
85 
                    father>=-1
 94 
                    father>=-1
86 
            ';
 95 
            ';
87 
            $dirs = DB::connection( 'old' )->select( $sql );
 96 
            $dirs = DB::connection( 'old' )->select( $sql );
88 
            foreach ( $dirs as $row )
 97 
            foreach ( $dirs as $row )
89 
            {
 98 
            {
90 
                $dir = new Item();
 99 
                $item = new Item();
91 
                $dir->id = $row->ID;
 100 
                $item->id = $row->ID;
92 
                $dir->directory_id = $row->Father;
 101 
                $item->directory_id = $row->Father;
93 
                $dir->name = $row->kurzbezeichnung;
 102 
                $item->name = $row->kurzbezeichnung;
94 
                $dir->status = $row->status;
 103 
                $item->status = $row->status;
95 
                $dir->kennung = $row->kennung;
 104 
                $item->kennung = $row->kennung;
96 
                $dir->description = $row->beschreibung;
 105 
                $item->description = $row->beschreibung;
97 
                $dir->created_at = $row->erstellt_am;
 106 
                $item->created_at = $row->erstellt_am;
98 
                $dir->updated_at = $row->letzte_Aenderung_am;
 107 
                $item->updated_at = $row->letzte_Aenderung_am;
99 
                $ersteller = $row->erstellt_von;
 108 
                $ersteller = $row->erstellt_von;
100 
                if ( !$ersteller )
 109 
                if ( !$ersteller )
101 
                {
 110 
                {
102 
                    $ersteller = "WebanOS Laravel Upgrade";
 111 
                    $ersteller = "WebanOS Laravel Upgrade";
103 
                }
 112 
                }
104 
                $bearbeiter = $row->letzte_aenderung_von;
 113 
                $bearbeiter = $row->letzte_aenderung_von;
105 
                if ( !$bearbeiter )
 114 
                if ( !$bearbeiter )
106 
                {
 115 
                {
107 
                    $bearbeiter = "WebanOS Laravel Upgrade";
 116 
                    $bearbeiter = "WebanOS Laravel Upgrade";
108 
                }
 117 
                }
109 
                $dir->created_by = $ersteller;
 118 
                $item->created_by = $ersteller;
110 
                $dir->updated_by = $bearbeiter;
 119 
                $item->updated_by = $bearbeiter;
111 
                $dir->save();
 120 
                $item->save();
112 
            }
 121 
            }
113 
            $sql = "
 122 
            $sql = "
114 
                SELECT
 123 
                SELECT
115 
                    p.*
 124 
                    p.*
116 
                FROM
 125 
                FROM