Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 953 Revision 954
Zeile 227... Zeile 227...
227 
        }
 227 
        }
Zeile 228... Zeile 228...
228 
 
 228 
 
229 
        private function migrateShippingGroups()
 229 
        private function migrateShippingGroups()
230 
        {
 230 
        {
231 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );
 - 
 
232 
            $start = 0;
 - 
 
233 
            $sql = "SELECT
 - 
 
234 
                    MAX(id) AS start
 - 
 
235 
                FROM
 - 
 
236 
                    shipping_groups
 - 
 
237 
            ";
 - 
 
238 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
239 
            if ( $row[0]->start )
 - 
 
240 
            {
 - 
 
241 
                $start = $row[0]->start;
 - 
 
242 
            }
 231 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );
243 
            $sql = "SELECT
 232 
            $sql = "SELECT
244 
                    *
 233 
                    *
245 
                FROM
 234 
                FROM
246 
                    versandgruppen
 - 
 
247 
                WHERE
 - 
 
248 
                    id>" . $start . "
 235 
                    versandgruppen
249 
            ";
 236 
            ";
- 
 
 237 
            $methods = DB::connection( 'old' )->select( $sql );
- 
 
 238 
            $progressbar = $this->output->createProgressBar( count( $methods ) );
250 
            $methods = DB::connection( 'old' )->select( $sql );
 239 
            $progressbar->start();
251 
            foreach ( $methods as $group )
 240 
            foreach ( $methods as $group )
- 
 
 241 
            {
- 
 
 242 
                $item = ShippingGroup::find( $group->id );
- 
 
 243 
                if ( !isset( $item->id ) )
252 
            {
 244 
                {
253 
                ShippingGroup::factory()->create( [
 245 
                    ShippingGroup::factory()->create( [
254 
                    "id"            => $group->id,
 246 
                        "id"            => $group->id,
255 
                    "name"          => $group->name,
 247 
                        "name"          => $group->name,
256 
                    "conditions"    => $group->bedingungen,
 248 
                        "conditions"    => $group->bedingungen,
257 
                    "icon"          => $group->icon,
 249 
                        "icon"          => $group->icon,
258 
                    "rank"          => $group->rang,
 250 
                        "rank"          => $group->rang,
259 
                    "shipping_text" => $group->versandtextbaustein,
 251 
                        "shipping_text" => $group->versandtextbaustein,
260 
                    "created_by"    => $group->erstellt_von,
 252 
                        "created_by"    => $group->erstellt_von,
261 
                    "updated_by"    => $group->geaendert_von,
 253 
                        "updated_by"    => $group->geaendert_von,
262 
                    "updated_at"    => $group->geaendert_am,
 254 
                        "updated_at"    => $group->geaendert_am,
263 
                    "created_at"    => $group->erstellt_am,
 255 
                        "created_at"    => $group->erstellt_am,
- 
 
 256 
                    ] );
- 
 
 257 
                }
- 
 
 258 
                else
- 
 
 259 
                {
- 
 
 260 
                    $item->name = $group->name;
- 
 
 261 
                    $item->conditions = $group->bedingungen;
- 
 
 262 
                    $item->icon = $group->icon;
- 
 
 263 
                    $item->rank = $group->rang;
- 
 
 264 
                    $item->shipping_text = $group->versandtextbaustein;
- 
 
 265 
                    $item->updated_by = $group->geaendert_von;
- 
 
 266 
                    $item->updated_at = $group->geaendert_am;
- 
 
 267 
                    $item->save();
- 
 
 268 
                }
264 
                ] );
 269 
                $progressbar->advance();
- 
 
 270 
            }
- 
 
 271 
            $progressbar->finish();
265 
            }
 272 
            $progressbar->clear();
Zeile 266... Zeile 273...
266 
        }
 273 
        }
267 
 
 274 
 
268 
        private function migrateShippings()
 275 
        private function migrateShippings()
269 
        {
 - 
 
270 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );
 276 
        {
271 
            $start = 0;
 277 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );
272 
            $sql = "SELECT
 278 
            $sql = "SELECT
273 
                    *
 279 
                    *
274 
                FROM
 280 
                FROM