Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 271 Revision 272
Zeile 3... Zeile 3...
3 
    namespace App\Console\Commands;
 3 
    namespace App\Console\Commands;
Zeile 4... Zeile 4...
4 
 
 4 
 
5 
    use App\Models\Directory;
 5 
    use App\Models\Directory;
6 
    use App\Models\Item;
 6 
    use App\Models\Item;
- 
 
 7 
    use App\Models\Action;
7 
    use App\Models\Action;
 8 
    use App\Models\Medium;
8 
    use App\Models\Price;
 9 
    use App\Models\Price;
9 
    use App\Models\ActionMedium;
 10 
    use App\Models\ActionMedium;
10 
    use App\Models\ItemMedium;
 11 
    use App\Models\ItemMedium;
11 
    use App\Models\DirectoryMedium;
 12 
    use App\Models\DirectoryMedium;
Zeile 34... Zeile 35...
34 
         * @return void
 35 
         * @return void
35 
         */
 36 
         */
Zeile 36... Zeile 37...
36 
 
 37 
 
37 
        public function handle(): void
 38 
        public function handle(): void
- 
 
 39 
        {
38 
        {
 40 
            $this->migrateMedia();
39 
            $this->migrateDirs();
 41 
            $this->migrateDirs();
40 
            $this->migrateItems();
 42 
            $this->migrateItems();
41 
            $this->migrateActions();
 43 
            $this->migrateActions();
Zeile 121... Zeile 123...
121 
 
 123 
 
Zeile 122... Zeile 124...
122 
        }
 124 
        }
123 
 
 125 
 
124 
        private function migrateActions()
 126 
        private function migrateActions()
125 
        {
 127 
        {
126 
            $this->info("Migriere Aktionen");
 128 
            $this->info( "Migriere Aktionen" );
127 
            $sql = "
 129 
            $sql = "
128 
                SELECT
 130 
                SELECT
129 
                    *
 131 
                    *
Zeile 144... Zeile 146...
144 
                $actionDB->valid_from = $action->von;
 146 
                $actionDB->valid_from = $action->von;
145 
                $actionDB->valid_to = $action->bis;
 147 
                $actionDB->valid_to = $action->bis;
146 
                $actionDB->save();
 148 
                $actionDB->save();
147 
            }
 149 
            }
148 
        }
 150 
        }
- 
 
 151 
 
- 
 
 152 
        public function migrateMedia()
- 
 
 153 
        {
- 
 
 154 
            $this->info( "Migriere Medien" );
- 
 
 155 
            $sql = "
- 
 
 156 
                SELECT
- 
 
 157 
                    *
- 
 
 158 
                FROM
- 
 
 159 
                    medien
- 
 
 160 
            ";
- 
 
 161 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 162 
            foreach ( $media as $medium )
- 
 
 163 
            {
- 
 
 164 
                $mediumDB = new Medium();
- 
 
 165 
                $mediumDB->id = $medium->id;
- 
 
 166 
                $mediumDB->name = $medium->name;
- 
 
 167 
                $mediumDB->folder = $medium->folder;
- 
 
 168 
                $mediumDB->medium_type_id = $medium->tpy;
- 
 
 169 
                $mediumDB->description = $medium->beschreibung;
- 
 
 170 
                $mediumDB->created_at = $medium->erstellt_am;
- 
 
 171 
                $mediumDB->updated_at = $medium->letzte_aenderung_am;
- 
 
 172 
                $mediumDB->save();
- 
 
 173 
            }
- 
 
 174 
        }
149 
    }
 175 
    }