Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 618 | Revision 620 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
233 lars 1 
<?php
2 
 
260 lars 3 
    namespace App\Console\Commands;
233 lars 4 
 
445 lars 5 
    use App\Models\Address;
260 lars 6 
    use App\Models\Directory;
600 lars 7 
    use App\Models\DirectoryTemplate;
260 lars 8 
    use App\Models\Item;
9 
    use App\Models\Action;
580 lars 10 
    use App\Models\Manufacturer;
272 lars 11 
    use App\Models\Medium;
454 lars 12 
    use App\Models\Order;
453 lars 13 
    use App\Models\OrderAddress;
507 lars 14 
    use App\Models\OrderType;
482 lars 15 
    use App\Models\PaymentMethod;
263 lars 16 
    use App\Models\Price;
551 lars 17 
    use App\Models\PriceAgency;
260 lars 18 
    use App\Models\ActionMedium;
19 
    use App\Models\ItemMedium;
619 lars 20 
    use App\Models\ItemTemplate;
260 lars 21 
    use App\Models\DirectoryMedium;
527 lars 22 
    use App\Models\SalesPortal;
540 lars 23 
    use App\Models\SalesPortalItem;
529 lars 24 
    use App\Models\SalesPortalType;
509 lars 25 
    use App\Models\Shipping;
510 lars 26 
    use App\Models\ShippingGroup;
465 lars 27 
    use App\Models\Shop;
600 lars 28 
    use App\Models\Template;
437 lars 29 
    use App\Models\User;
561 lars 30 
    use App\Models\OrderItem;
260 lars 31 
    use Illuminate\Console\Command;
32 
    use Illuminate\Support\Facades\DB;
233 lars 33 
 
260 lars 34 
    class convertDB extends Command
35 
    {
36 
        /**
37 
         * The name and signature of the console command.
38 
         *
39 
         * @var string
40 
         */
41 
        protected $signature = 'command:convertDB';
233 lars 42 
 
260 lars 43 
        /**
44 
         * The console command description.
45 
         *
46 
         * @var string
47 
         */
48 
        protected $description = 'Converts the old webanOS-DB to laravel';
233 lars 49 
 
260 lars 50 
        /**
51 
         * Execute the console command.
52 
         *
53 
         * @return void
54 
         */
55 
 
56 
        public function handle(): void
238 lars 57 
        {
294 lars 58 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung gestartet" );
496 lars 59 
            $this->migrateShops();
505 lars 60 
            $this->migrateOrderTypes();
496 lars 61 
            $this->migratePaymentMethods();
508 lars 62 
            $this->migrateShippingGroups();
517 lars 63 
            $this->migrateShippings();
580 lars 64 
            $this->migrateManufacturers();
578 lars 65 
            $this->migrateActions();
66 
            $this->migrateDirs();
67 
            $this->migrateItems();
465 lars 68 
            if ( env( 'site' ) == env( 'shop' ) )
69 
            {
538 lars 70 
                $this->migratePriceAgencies();
465 lars 71 
                $this->migrateUsers();
72 
                $this->migrateAddresses();
73 
                $this->migrateOrderAddresses();
74 
                $this->migrateOrders();
75 
                $this->migrateOrderItems();
535 lars 76 
                $this->migrateSalesPortalTypes();
465 lars 77 
            }
600 lars 78 
            $this->migrateTemplates();
536 lars 79 
            $this->migrateSalesPortals();
538 lars 80 
            $this->migrateSalesPortalItems();
578 lars 81 
            $this->migrateMedia();
82 
            $this->migrateActionMedia();
83 
            $this->migrateDirMedia();
84 
            $this->migrateItemMedia();
294 lars 85 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
234 lars 86 
        }
260 lars 87 
 
527 lars 88 
        private function migrateShops()
433 lars 89 
        {
527 lars 90 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Shops" );
486 lars 91 
            $start = 0;
527 lars 92 
            $sql = "
93 
                SELECT
486 lars 94 
                    MAX(id) AS start
95 
                FROM
527 lars 96 
                    shops
486 lars 97 
            ";
527 lars 98 
            $row = DB::connection( 'mysql' )->select( $sql );
99 
            if ( $row[0]->start )
486 lars 100 
            {
527 lars 101 
                $start = $row[0]->start;
486 lars 102 
            }
527 lars 103 
            $sql = "SELECT
433 lars 104 
                    *
105 
                FROM
527 lars 106 
                    shops
486 lars 107 
                WHERE
108 
                    id>" . $start . "
433 lars 109 
            ";
527 lars 110 
            $shops = DB::connection( 'old' )->select( $sql );
111 
            foreach ( $shops as $oldShop )
433 lars 112 
            {
527 lars 113 
                $shop = new Shop();
114 
                $shop->id = $oldShop->ID;
115 
                $shop->name = $oldShop->Name;
615 lars 116 
                $shop->short = '';
117 
                if ( isset( $oldShop->short ) && $oldShop->short )
118 
                {
119 
                    $shop->short = $oldShop->short;
120 
                }
527 lars 121 
                $shop->re_short = '';
122 
                if ( isset( $oldShop->re_short ) && $oldShop->re_short )
433 lars 123 
                {
527 lars 124 
                    $shop->re_short = $oldShop->re_short;
433 lars 125 
                }
527 lars 126 
                if ( isset( $oldShop->preisindex_ek ) && $oldShop->preisindex_ek )
433 lars 127 
                {
527 lars 128 
                    $shop->preisindex_ek = $oldShop->preisindex_ek;
433 lars 129 
                }
527 lars 130 
                $shop->ebay = $oldShop->ebay;
131 
                $shop->erfassung = $oldShop->erfassung;
132 
                if ( isset( $oldShop->status ) && $oldShop->status )
433 lars 133 
                {
527 lars 134 
                    $shop->status = $oldShop->status;
433 lars 135 
                }
527 lars 136 
                if ( isset( $oldShop->rang ) && $oldShop->rang )
137 
                {
138 
                    $shop->rank = $oldShop->rang;
139 
                }
140 
                $shop->klonziel = $oldShop->klonziel;
141 
                $shop->konroot = $oldShop->konroot;
142 
                if ( isset( $oldShop->home ) && $oldShop->home )
143 
                {
144 
                    $shop->home = $oldShop->home;
145 
                }
146 
                $shop->database = $oldShop->database;
147 
                $shop->domain = $oldShop->domain;
148 
                $shop->mail_server = $oldShop->mail_server;
149 
                $shop->mail_user = $oldShop->mail_user;
150 
                $shop->mail_password = $oldShop->mail_passwort;
151 
                $shop->save();
152 
            }
153 
 
154 
        }
155 
 
156 
        private function migrateOrderTypes()
157 
        {
158 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellarten" );
159 
            $start = 0;
160 
            $sql = "SELECT
161 
                    MAX(id) AS start
162 
                FROM
163 
                    order_types
164 
            ";
165 
            $row = DB::connection( "mysql" )->select( $sql );
166 
            if ( $row[0]->start )
167 
            {
168 
                $start = $row[0]->start;
169 
            }
170 
            $sql = "SELECT
171 
                    *
172 
                FROM
173 
                    bestellart
174 
                WHERE
175 
                    id>" . $start . "
176 
            ";
177 
            $methods = DB::connection( 'old' )->select( $sql );
178 
            foreach ( $methods as $method )
615 lars 179 
	    {
180 
		$short = '';
181 
                if ( isset( $method->short ) && $method->short )
182 
                {
183 
                    $short = $method->short;
184 
                }
185 
 
527 lars 186 
                OrderType::factory()->create( [
187 
                    "id"            => $method->id,
188 
                    "internal_name" => $method->rufname,
189 
                    "name"          => $method->name,
615 lars 190 
                    "short"         => $short,
527 lars 191 
                ] );
192 
            }
193 
        }
194 
 
195 
        private function migratePaymentMethods()
196 
        {
197 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );
198 
            $start = 0;
199 
            $sql = "SELECT
200 
                    MAX(id) AS start
201 
                FROM
202 
                    payment_methods
203 
            ";
204 
            $row = DB::connection( "mysql" )->select( $sql );
205 
            if ( $row[0]->start )
206 
            {
207 
                $start = $row[0]->start;
208 
            }
209 
            $sql = "SELECT
210 
                    *
211 
                FROM
212 
                    zahlungsarten
213 
                WHERE
214 
                    id>" . $start . "
215 
            ";
216 
            $methods = DB::connection( 'old' )->select( $sql );
217 
            foreach ( $methods as $method )
218 
            {
219 
                PaymentMethod::factory()->create( [
220 
                    "id"            => $method->id,
221 
                    "name"          => $method->name,
222 
                    "discount"      => $method->abschlag,
223 
                    "internal_name" => $method->interner_name,
224 
                    "info_in_shop"  => $method->info_im_shop,
225 
                    "shipping_text" => $method->versandtextbaustein,
226 
                ] );
227 
            }
228 
        }
229 
 
230 
        private function migrateShippingGroups()
231 
        {
232 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );
233 
            $start = 0;
234 
            $sql = "SELECT
235 
                    MAX(id) AS start
236 
                FROM
237 
                    shipping_groups
238 
            ";
239 
            $row = DB::connection( "mysql" )->select( $sql );
240 
            if ( $row[0]->start )
241 
            {
242 
                $start = $row[0]->start;
243 
            }
244 
            $sql = "SELECT
245 
                    *
246 
                FROM
247 
                    versandgruppen
248 
                WHERE
249 
                    id>" . $start . "
250 
            ";
251 
            $methods = DB::connection( 'old' )->select( $sql );
252 
            foreach ( $methods as $group )
253 
            {
254 
                ShippingGroup::factory()->create( [
255 
                    "id"            => $group->id,
256 
                    "name"          => $group->name,
257 
                    "conditions"    => $group->bedingungen,
258 
                    "icon"          => $group->icon,
259 
                    "rank"          => $group->rang,
260 
                    "shipping_text" => $group->versandtextbaustein,
261 
                    "created_by"    => $group->erstellt_von,
262 
                    "updated_by"    => $group->geaendert_von,
263 
                    "updated_at"    => $group->geaendert_am,
264 
                    "created_at"    => $group->erstellt_am,
265 
                ] );
266 
            }
267 
        }
268 
 
269 
        private function migrateShippings()
270 
        {
271 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );
272 
            $start = 0;
273 
            $sql = "SELECT
274 
                    MAX(id) AS start
275 
                FROM
276 
                    shippings
277 
            ";
278 
            $row = DB::connection( "mysql" )->select( $sql );
279 
            if ( $row[0]->start )
280 
            {
281 
                $start = $row[0]->start;
282 
            }
283 
            $sql = "SELECT
284 
                    *
285 
                FROM
286 
                    versand
287 
                WHERE
288 
                    id>" . $start . "
289 
            ";
290 
            $methods = DB::connection( 'old' )->select( $sql );
291 
            foreach ( $methods as $group )
292 
            {
293 
                Shipping::factory()->create( [
294 
                    "id"                => $group->id,
295 
                    "rank"              => $group->rang,
296 
                    "shipping_group_id" => $group->versandgruppen_id,
297 
                    "name"              => $group->name,
298 
                    "info_shop"         => $group->info_shop,
299 
                    "info_mail"         => $group->info_mail,
300 
                    "info_internal"     => $group->info_intern,
301 
                    "island_shipping"   => $group->inselversand,
302 
                    "additions"         => $group->zusaetze,
303 
                    "status"            => $group->status,
304 
                    "price"             => $group->preis,
305 
                    "calc_weight_from"  => $group->berechnung_kg_von,
306 
                    "calc_weight_to"    => $group->berechnung_kg_bis,
307 
                    "calc_price_from"   => $group->berechnung_preis_von,
308 
                    "calc_price_to"     => $group->berechnung_preis_bis,
309 
                    "conditions"        => $group->bedingungen,
310 
                    "tax_rate"          => $group->steuersatz,
311 
                    "created_by"        => $group->erstellt_von,
312 
                    "updated_by"        => $group->geaendert_von,
313 
                    "updated_at"        => $group->geaendert_am,
314 
                    "created_at"        => $group->erstellt_am,
315 
                ] );
316 
            }
317 
        }
318 
 
319 
        private function migrateActions()
320 
        {
321 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
322 
            $start = 0;
323 
            $sql = "SELECT
324 
                    MAX(id) AS start
325 
                FROM
326 
                    actions
327 
            ";
328 
            $row = DB::connection( "mysql" )->select( $sql );
329 
            if ( $row[0]->start )
330 
            {
331 
                $start = $row[0]->start;
332 
            }
333 
            $sql = "
334 
                SELECT
335 
                    *
336 
                FROM
337 
                    Aktionen
338 
                WHERE
339 
                    id>" . $start . "
340 
            ";
341 
            $actions = DB::connection( 'old' )->select( $sql );
342 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
343 
            $progressbar->start();
344 
            foreach ( $actions as $action )
345 
            {
346 
                $actionDB = new Action();
347 
                $actionDB->id = $action->ID;
348 
                $actionDB->headline = $action->headline;
349 
                $actionDB->text = $action->text;
350 
                $actionDB->rang = $action->rang;
351 
                $actionDB->config = $action->config;
352 
                $actionDB->category = $action->Kategorie;
353 
                $actionDB->notes = $action->notizen;
354 
                $actionDB->valid_from = $action->von;
355 
                $actionDB->valid_to = $action->bis;
356 
                $actionDB->created_by = "WebanOS Laravel Upgrade";
357 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
358 
                $actionDB->save();
433 lars 359 
                $progressbar->advance();
360 
            }
361 
            $progressbar->finish();
362 
            $progressbar->clear();
363 
        }
364 
 
260 lars 365 
        private function migrateDirs()
366 
        {
294 lars 367 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );
591 lars 368 
            $start = -10;
486 lars 369 
            $sql = "SELECT
370 
                    MAX(id) AS start
371 
                FROM
372 
                    directories
373 
            ";
374 
            $row = DB::connection( "mysql" )->select( $sql );
527 lars 375 
            if ( $row[0]->start )
486 lars 376 
            {
527 lars 377 
                $start = $row[0]->start;
486 lars 378 
            }
260 lars 379 
            $sql = '
380 
                SELECT
381 
                    *
382 
                FROM
383 
                    directory
614 lars 384 
                WHERE
385 
                    id>' . $start . '
260 lars 386 
            ';
387 
            $dirs = DB::connection( 'old' )->select( $sql );
301 lars 388 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
615 lars 389 
	    $progressbar->start();
390 
	    DB::statement('SET FOREIGN_KEY_CHECKS=0');
260 lars 391 
            foreach ( $dirs as $row )
392 
            {
284 lars 393 
                $ersteller = $row->erstellt_von;
394 
                if ( !$ersteller )
395 
                {
396 
                    $ersteller = "WebanOS Laravel Upgrade";
397 
                }
285 lars 398 
                $bearbeiter = $row->letzte_Aenderung_von;
284 lars 399 
                if ( !$bearbeiter )
400 
                {
401 
                    $bearbeiter = "WebanOS Laravel Upgrade";
402 
                }
303 lars 403 
                $dir = new Directory();
404 
                $dir->id = $row->ID;
304 lars 405 
                $dir->directory_id = $row->Father;
303 lars 406 
                $dir->name = $row->Name;
432 lars 407 
                $dir->articlemaster = $row->Artikelstamm;
304 lars 408 
                $dir->status = $row->status;
303 lars 409 
                $dir->kennung = $row->Kennung;
304 lars 410 
                $dir->description = $row->Beschreibung;
411 
                $dir->short_line_1 = $row->short_line_1;
303 lars 412 
                $dir->url = $row->url;
413 
                $dir->created_at = $row->erstellt_am;
414 
                $dir->created_by = $ersteller;
415 
                $dir->updated_by = $bearbeiter;
416 
                $dir->updated_at = $row->letzte_Aenderung_am;
417 
                $dir->save();
301 lars 418 
                $progressbar->advance();
260 lars 419 
            }
301 lars 420 
            $progressbar->finish();
615 lars 421 
	    $progressbar->clear();
422 
	    DB::statement('SET FOREIGN_KEY_CHECKS=1');
260 lars 423 
        }
424 
 
425 
        private function migrateItems()
426 
        {
294 lars 427 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
486 lars 428 
            $start = 0;
429 
            $sql = "SELECT
430 
                    MAX(id) AS start
431 
                FROM
432 
                    items
433 
            ";
434 
            $row = DB::connection( "mysql" )->select( $sql );
527 lars 435 
            if ( $row[0]->start )
486 lars 436 
            {
527 lars 437 
                $start = $row[0]->start;
486 lars 438 
            }
260 lars 439 
            $sql = '
440 
                SELECT
441 
                    *
442 
                FROM
443 
                    artikel
444 
                WHERE
491 lars 445 
                    father >= -1
486 lars 446 
                AND
490 lars 447 
                    id>' . $start . '
260 lars 448 
            ';
449 
            $dirs = DB::connection( 'old' )->select( $sql );
301 lars 450 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
451 
            $progressbar->start();
260 lars 452 
            foreach ( $dirs as $row )
453 
            {
284 lars 454 
                $item = new Item();
455 
                $item->id = $row->ID;
456 
                $item->directory_id = $row->Father;
590 lars 457 
                $item->manufacturer_id = $row->hersteller;
284 lars 458 
                $item->name = $row->kurzbezeichnung;
459 
                $item->status = $row->status;
460 
                $item->kennung = $row->kennung;
461 
                $item->description = $row->beschreibung;
462 
                $item->created_at = $row->erstellt_am;
463 
                $item->updated_at = $row->letzte_Aenderung_am;
283 lars 464 
                $ersteller = $row->erstellt_von;
282 lars 465 
                if ( !$ersteller )
281 lars 466 
                {
282 lars 467 
                    $ersteller = "WebanOS Laravel Upgrade";
281 lars 468 
                }
287 lars 469 
                $bearbeiter = $row->letzte_Aenderung_von;
282 lars 470 
                if ( !$bearbeiter )
281 lars 471 
                {
282 lars 472 
                    $bearbeiter = "WebanOS Laravel Upgrade";
281 lars 473 
                }
284 lars 474 
                $item->created_by = $ersteller;
475 
                $item->updated_by = $bearbeiter;
476 
                $item->save();
301 lars 477 
                $progressbar->advance();
260 lars 478 
            }
301 lars 479 
            $progressbar->finish();
302 lars 480 
            $progressbar->clear();
294 lars 481 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );
494 lars 482 
            $start = 0;
492 lars 483 
            $sql = "SELECT
484 
                    MAX(id) AS start
485 
                FROM
486 
                    prices
487 
            ";
488 
            $row = DB::connection( "mysql" )->select( $sql );
527 lars 489 
            if ( $row[0]->start )
492 lars 490 
            {
527 lars 491 
                $start = $row[0]->start;
492 lars 492 
            }
260 lars 493 
            $sql = "
494 
                SELECT
495 
                    p.*
496 
                FROM
497 
                    preise p
498 
                JOIN
499 
                    artikel a
500 
                ON
501 
                    a.id=p.artikel_id
502 
                WHERE
503 
                    a.father >=-1
492 lars 504 
                AND
505 
                    p.id>" . $start . "
260 lars 506 
            ";
507 
            $prices = DB::connection( 'old' )->select( $sql );
301 lars 508 
            $progressbar = $this->output->createProgressBar( count( $prices ) );
509 
            $progressbar->start();
260 lars 510 
            foreach ( $prices as $price )
511 
            {
512 
                Price::factory()->createQuietly( [
493 lars 513 
                    "id"          => $price->id,
260 lars 514 
                    "item_id"     => $price->artikel_id,
515 
                    "preis_index" => $price->preis_index,
516 
                    "preis"       => $price->preis,
517 
                    "staffel"     => $price->staffel,
518 
                    "created_at"  => $price->geaendert_am,
288 lars 519 
                    "created_by"  => $price->geaendert_von,
520 
                    "updated_by"  => $price->geaendert_von,
260 lars 521 
                    "updated_at"  => $price->geaendert_am
522 
                ] );
301 lars 523 
                $progressbar->advance();
260 lars 524 
            }
301 lars 525 
            $progressbar->finish();
302 lars 526 
            $progressbar->clear();
260 lars 527 
        }
528 
 
527 lars 529 
        public function migrateMedia()
433 lars 530 
        {
527 lars 531 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );
486 lars 532 
            $start = 0;
433 lars 533 
            $sql = "SELECT
527 lars 534 
                    MAX(id) AS start
486 lars 535 
                FROM
527 lars 536 
                    media
486 lars 537 
            ";
538 
            $row = DB::connection( "mysql" )->select( $sql );
527 lars 539 
            if ( $row[0]->start )
486 lars 540 
            {
527 lars 541 
                $start = $row[0]->start;
486 lars 542 
            }
527 lars 543 
            $sql = "
544 
                SELECT
545 
                    *
546 
                FROM
547 
                    medien
548 
                WHERE
549 
                    id>" . $start . "
550 
            ";
551 
            $media = DB::connection( 'old' )->select( $sql );
552 
            $progressbar = $this->output->createProgressBar( count( $media ) );
553 
            $progressbar->start();
554 
            foreach ( $media as $medium )
555 
            {
556 
                $mediumDB = new Medium();
557 
                $mediumDB->id = $medium->id;
558 
                $mediumDB->name = $medium->name;
559 
                $mediumDB->folder = $medium->folder;
560 
                $mediumDB->medium_type_id = $medium->typ;
561 
                $mediumDB->description = $medium->beschreibung;
562 
                if ( $medium->erstellt_am )
563 
                {
564 
                    $mediumDB->created_at = date( "Y-m-d H:i:s", $medium->erstellt_am );
565 
                }
566 
                $ersteller = $medium->erstellt_von;
567 
                if ( !$ersteller )
568 
                {
569 
                    $ersteller = "WebanOS Laravel Upgrade";
570 
                }
571 
                $bearbeiter = $medium->letzte_aenderung_von;
572 
                if ( !$bearbeiter )
573 
                {
574 
                    $bearbeiter = "WebanOS Laravel Upgrade";
575 
                }
576 
                $mediumDB->created_by = $ersteller;
577 
                $mediumDB->updated_by = $bearbeiter;
578 
                $mediumDB->save();
579 
                $progressbar->advance();
580 
            }
581 
            $progressbar->finish();
582 
            $progressbar->clear();
583 
        }
584 
 
585 
        public function migrateActionMedia()
586 
        {
587 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
588 
            $start = 0;
486 lars 589 
            $sql = "SELECT
527 lars 590 
                    MAX(id) AS start
591 
                FROM
592 
                    action_media
593 
            ";
594 
            $row = DB::connection( "mysql" )->select( $sql );
595 
            if ( $row[0]->start )
596 
            {
597 
                $start = $row[0]->start;
598 
            }
599 
            $sql = "SELECT
433 lars 600 
                    *
601 
                FROM
527 lars 602 
                    aktionen_medien
486 lars 603 
                WHERE
527 lars 604 
                    id>" . $start . "
433 lars 605 
            ";
606 
            $media = DB::connection( 'old' )->select( $sql );
607 
            $progressbar = $this->output->createProgressBar( count( $media ) );
608 
            $progressbar->start();
609 
            foreach ( $media as $row )
610 
            {
527 lars 611 
                $medium = new ActionMedium();
612 
                $medium->action_id = $row->aktionen_id;
433 lars 613 
                $medium->medium_id = $row->medien_id;
614 
                $medium->rank = $row->rang;
615 
                $medium->created_by = "WebanOS Laravel Upgrade";
616 
                $medium->updated_by = "WebanOS Laravel Upgrade";
617 
                $medium->save();
618 
                $progressbar->advance();
619 
            }
620 
            $progressbar->finish();
621 
            $progressbar->clear();
622 
        }
623 
 
527 lars 624 
        public function migrateDirMedia()
260 lars 625 
        {
527 lars 626 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
486 lars 627 
            $start = 0;
628 
            $sql = "SELECT
527 lars 629 
                    MAX(medium_id) AS start
486 lars 630 
                FROM
527 lars 631 
                    directory_media
486 lars 632 
            ";
633 
            $row = DB::connection( "mysql" )->select( $sql );
527 lars 634 
            if ( $row[0]->start )
486 lars 635 
            {
527 lars 636 
                $start = $row[0]->start;
486 lars 637 
            }
527 lars 638 
            $sql = "SELECT
260 lars 639 
                    *
640 
                FROM
527 lars 641 
                    directory_medien
486 lars 642 
                WHERE
527 lars 643 
                    medien_id>" . $start . "
260 lars 644 
            ";
527 lars 645 
            $media = DB::connection( 'old' )->select( $sql );
646 
            $progressbar = $this->output->createProgressBar( count( $media ) );
301 lars 647 
            $progressbar->start();
527 lars 648 
            foreach ( $media as $row )
260 lars 649 
            {
527 lars 650 
                $medium = new DirectoryMedium();
651 
                $medium->directory_id = $row->directory_id;
652 
                $medium->medium_id = $row->medien_id;
653 
                $medium->rank = $row->rang;
654 
                $medium->similar = $row->aehnlich;
655 
                $medium->created_at = $row->zugeordnet_am;
656 
                $medium->updated_at = $row->zugeordnet_am;
657 
                $medium->created_by = "WebanOS Laravel Upgrade";
658 
                $medium->updated_by = "WebanOS Laravel Upgrade";
659 
                $medium->save();
301 lars 660 
                $progressbar->advance();
260 lars 661 
            }
301 lars 662 
            $progressbar->finish();
302 lars 663 
            $progressbar->clear();
260 lars 664 
        }
272 lars 665 
 
527 lars 666 
        public function migrateItemMedia()
272 lars 667 
        {
527 lars 668 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
486 lars 669 
            $start = 0;
433 lars 670 
            $sql = "SELECT
527 lars 671 
                    MAX(medium_id) AS start
486 lars 672 
                FROM
527 lars 673 
                    item_media
486 lars 674 
            ";
675 
            $row = DB::connection( "mysql" )->select( $sql );
527 lars 676 
            if ( $row[0]->start )
486 lars 677 
            {
527 lars 678 
                $start = $row[0]->start;
486 lars 679 
            }
680 
            $sql = "SELECT
272 lars 681 
                    *
682 
                FROM
527 lars 683 
                    artikel_medien
486 lars 684 
                WHERE
527 lars 685 
                    medien_id>" . $start . "
272 lars 686 
            ";
687 
            $media = DB::connection( 'old' )->select( $sql );
301 lars 688 
            $progressbar = $this->output->createProgressBar( count( $media ) );
689 
            $progressbar->start();
433 lars 690 
            foreach ( $media as $row )
272 lars 691 
            {
527 lars 692 
                $medium = new ItemMedium();
693 
                $medium->item_id = $row->artikel_id;
433 lars 694 
                $medium->medium_id = $row->medien_id;
695 
                $medium->rank = $row->rang;
527 lars 696 
                $medium->similar = $row->aehnlich;
697 
                $medium->created_at = $row->zugeordnet_am;
698 
                $medium->updated_at = $row->zugeordnet_am;
433 lars 699 
                $medium->created_by = "WebanOS Laravel Upgrade";
700 
                $medium->updated_by = "WebanOS Laravel Upgrade";
701 
                $medium->save();
301 lars 702 
                $progressbar->advance();
272 lars 703 
            }
301 lars 704 
            $progressbar->finish();
302 lars 705 
            $progressbar->clear();
272 lars 706 
        }
304 lars 707 
 
708 
        private function migrateUsers()
709 
        {
710 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );
433 lars 711 
            $start = 0;
712 
            $sql = "SELECT
713 
                    MAX(id) AS start
714 
                FROM
434 lars 715 
                    users
433 lars 716 
            ";
717 
            $row = DB::connection( "order" )->select( $sql );
527 lars 718 
            if ( $row[0]->start )
433 lars 719 
            {
527 lars 720 
                $start = $row[0]->start;
433 lars 721 
            }
722 
            $sql = "SELECT
723 
                    *
724 
                FROM
434 lars 725 
                    Logins
433 lars 726 
                WHERE
727 
                    id>" . $start . "
728 
            ";
437 lars 729 
            $users = DB::connection( "oldOrder" )->select( $sql );
730 
            $progressbar = $this->output->createProgressBar( count( $users ) );
448 lars 731 
            $progressbar->start();
437 lars 732 
            foreach ( $users as $oldUser )
433 lars 733 
            {
443 lars 734 
                $ersteller = $oldUser->erstellt_von;
442 lars 735 
                if ( !$ersteller )
736 
                {
737 
                    $ersteller = "WebanOS Laravel Upgrade";
738 
                }
443 lars 739 
                $bearbeiter = $oldUser->letzte_Aenderung_von;
442 lars 740 
                if ( !$bearbeiter )
741 
                {
742 
                    $bearbeiter = "WebanOS Laravel Upgrade";
743 
                }
437 lars 744 
                $user = new User();
438 lars 745 
                $user->id = $oldUser->ID;
437 lars 746 
                $user->email = $oldUser->E_Mail;
747 
                $user->created_at = $oldUser->erstellt_am;
442 lars 748 
                $user->created_by = $ersteller;
749 
                $user->updated_by = $bearbeiter;
437 lars 750 
                $user->updated_at = $oldUser->letzte_Aenderung_am;
751 
                $user->save();
441 lars 752 
                $progressbar->advance();
433 lars 753 
            }
441 lars 754 
            $progressbar->finish();
755 
            $progressbar->clear();
304 lars 756 
        }
757 
 
445 lars 758 
        private function migrateAddresses( bool $isOrder = false )
304 lars 759 
        {
445 lars 760 
            $typ = "Adressen";
761 
            $table = "addresses";
762 
            $oldTable = "adresse";
763 
            if ( $isOrder === true )
764 
            {
765 
                $typ = "Bestelladressen";
766 
                $table = "order_addresses";
767 
                $oldTable = "bestelladresse";
768 
            }
769 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere " . $typ );
770 
            $start = 0;
771 
            $sql = "SELECT
772 
                    MAX(id) AS start
773 
                FROM
774 
                    " . $table . "
775 
            ";
776 
            $row = DB::connection( "order" )->select( $sql );
527 lars 777 
            if ( $row[0]->start )
445 lars 778 
            {
527 lars 779 
                $start = $row[0]->start;
445 lars 780 
            }
781 
            $sql = "SELECT
782 
                    *
783 
                FROM
784 
                    " . $oldTable . "
785 
                WHERE
786 
                    id>" . $start . "
787 
            ";
788 
            $addresses = DB::connection( "oldOrder" )->select( $sql );
789 
            $progressbar = $this->output->createProgressBar( count( $addresses ) );
447 lars 790 
            $progressbar->start();
445 lars 791 
            foreach ( $addresses as $oldAddress )
792 
            {
793 
                $ersteller = "WebanOS Laravel Upgrade";
794 
                $bearbeiter = "WebanOS Laravel Upgrade";
458 lars 795 
                if ( $isOrder === true )
452 lars 796 
                {
797 
                    $address = new OrderAddress();
798 
                }
799 
                else
800 
                {
801 
                    $address = new Address();
802 
                }
445 lars 803 
                $address->id = $oldAddress->id;
804 
                $address->user_id = $oldAddress->logins_id;
805 
                $address->salutation = $oldAddress->anrede;
806 
                $address->pro_title = $oldAddress->pro_title;
807 
                $address->name = $oldAddress->vorname;
808 
                $address->lastname = $oldAddress->nachname;
809 
                $address->company = $oldAddress->firma;
810 
                $address->company2 = $oldAddress->firma2;
811 
                $address->street = $oldAddress->strasse1;
812 
                $address->houseno = $oldAddress->str_nr1;
813 
                $address->street2 = $oldAddress->strasse2;
814 
                $address->zip = $oldAddress->plz;
815 
                $address->city = $oldAddress->ort;
816 
                $address->country_id = $oldAddress->land;
817 
                $address->state_id = $oldAddress->state;
818 
                $address->phone = $oldAddress->telefon;
819 
                $address->fax = $oldAddress->fax;
820 
                $address->email = $oldAddress->email;
821 
                $address->nettocalculation = $oldAddress->nettoberechnung;
450 lars 822 
                $address->hr_nr = $oldAddress->hr_nr;
445 lars 823 
                $address->vat_id = $oldAddress->vat_id;
824 
                $address->vat_free = $oldAddress->mwst_befreiung;
825 
                $address->legal_form = $oldAddress->legal_form;
826 
                $address->comment = $oldAddress->comment;
451 lars 827 
                $address->created_at = $oldAddress->letzte_aenderung_am;
445 lars 828 
                $address->created_by = $ersteller;
829 
                $address->updated_by = $bearbeiter;
830 
                $address->updated_at = $oldAddress->letzte_aenderung_am;
831 
                $address->save();
832 
                $progressbar->advance();
833 
            }
834 
            $progressbar->finish();
835 
            $progressbar->clear();
304 lars 836 
        }
837 
 
838 
        private function migrateOrderAddresses()
839 
        {
445 lars 840 
            $this->migrateAddresses( true );
304 lars 841 
        }
842 
 
843 
        private function migrateOrders()
844 
        {
845 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellungen" );
454 lars 846 
            $start = 0;
847 
            $sql = "SELECT
848 
                    MAX(id) AS start
849 
                FROM
850 
                    orders
851 
            ";
852 
            $row = DB::connection( "order" )->select( $sql );
527 lars 853 
            if ( $row[0]->start )
454 lars 854 
            {
527 lars 855 
                $start = $row[0]->start;
454 lars 856 
            }
857 
            $sql = "SELECT
858 
                    *
859 
                FROM
860 
                    Bestellung
861 
                WHERE
862 
                    id>" . $start . "
863 
            ";
864 
            $orders = DB::connection( "oldOrder" )->select( $sql );
865 
            $progressbar = $this->output->createProgressBar( count( $orders ) );
866 
            $progressbar->start();
867 
            foreach ( $orders as $oldOrder )
868 
            {
501 lars 869 
                $paidAt = $oldOrder->bezahlt_am;
870 
                if ( $paidAt == "0000-00-00 00:00:00" )
871 
                {
502 lars 872 
                    $paidAt = null;
501 lars 873 
                }
454 lars 874 
                $order = new Order();
875 
                $order->id = $oldOrder->ID;
481 lars 876 
                $order->shop_id = $oldOrder->shops_ID;
459 lars 877 
                $order->order_type_id = $oldOrder->bestellart_id;
458 lars 878 
                $order->payment_method_id = $oldOrder->zahlart_id;
879 
                $order->user_id = $oldOrder->Login;
880 
                $order->ship_addr_id = $oldOrder->ship_addr_id;
881 
                $order->bill_addr_id = $oldOrder->bill_addr_id;
882 
                $order->paid = $oldOrder->bezahlt;
501 lars 883 
                $order->paid_at = $paidAt;
458 lars 884 
                $order->paid_comment = $oldOrder->bezahlt_bemerkung;
885 
                $order->foreign_id = $oldOrder->fremd_id;
886 
                $order->foreign_payment_id = $oldOrder->bezahlt_fremdid;
887 
                $order->status = $oldOrder->status;
888 
                $order->total_amount_buffer = $oldOrder->gesamtsumme_buffer;
889 
                $order->item_status_buffer = $oldOrder->artikelstatus_buffer;
890 
                $order->invoice_status_buffer = $oldOrder->rechnungsstatus_buffer;
504 lars 891 
                $order->delivery_note_status_buffer = $oldOrder->lieferscheinStatus_buffer;
458 lars 892 
                $order->tax = $oldOrder->tax;
893 
                $order->comment = $oldOrder->Bemerkung;
894 
                $order->external_comment = $oldOrder->Bemerkung_extern;
895 
                $order->note = $oldOrder->notiz;
460 lars 896 
                $order->additional_info = $oldOrder->zusatzInfo;
458 lars 897 
                $order->shipping_group_id = $oldOrder->versandgruppen_id;
898 
                $order->kk_info = $oldOrder->kk_info;
899 
                $order->created_by = $oldOrder->erstellt_von;
900 
                $order->updated_by = $oldOrder->letzte_Aenderung_von;
901 
                $order->updated_at = $oldOrder->letzte_Aenderung_am;
902 
                $order->created_at = $oldOrder->erstellt_am;
454 lars 903 
                $order->save();
904 
                $progressbar->advance();
905 
            }
906 
            $progressbar->finish();
907 
            $progressbar->clear();
304 lars 908 
        }
909 
 
910 
        private function migrateOrderItems()
911 
        {
578 lars 912 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel in Bestellungen" );
454 lars 913 
            $start = 0;
914 
            $sql = "SELECT
915 
                    MAX(id) AS start
916 
                FROM
917 
                    order_items
918 
            ";
919 
            $row = DB::connection( "order" )->select( $sql );
527 lars 920 
            if ( $row[0]->start )
454 lars 921 
            {
527 lars 922 
                $start = $row[0]->start;
454 lars 923 
            }
924 
            $sql = "SELECT
925 
                    *
926 
                FROM
927 
                    artikel_to_Bestellung
928 
                WHERE
929 
                    id>" . $start . "
930 
            ";
931 
            $orderItems = DB::connection( "oldOrder" )->select( $sql );
932 
            $progressbar = $this->output->createProgressBar( count( $orderItems ) );
933 
            $progressbar->start();
934 
            foreach ( $orderItems as $oldOrderItem )
935 
            {
573 lars 936 
                $exported = $oldOrderItem->exported;
937 
                if ( $exported == "0000-00-00 00:00:00" )
938 
                {
939 
                    $exported = null;
940 
                }
941 
                $exported_invoice = $oldOrderItem->exported_rechnung;
942 
                if ( $exported_invoice == "0000-00-00 00:00:00" )
943 
                {
944 
                    $exported_invoice = null;
945 
                }
946 
                $exported_delivery_note = $oldOrderItem->exported_lieferschein;
947 
                if ( $exported_delivery_note == "0000-00-00 00:00:00" )
948 
                {
949 
                    $exported_delivery_note = null;
950 
                }
561 lars 951 
                OrderItem::factory()->create( [
567 lars 952 
                    "id"                     => $oldOrderItem->ID,
953 
                    "item_id"                => $oldOrderItem->artikel,
954 
                    "order_id"               => $oldOrderItem->Bestellung,
568 lars 955 
                    "name"                   => $oldOrderItem->Bezeichnung,
567 lars 956 
                    "amount"                 => $oldOrderItem->Menge,
957 
                    "price"                  => $oldOrderItem->Preis_pro_Stueck,
958 
                    "father"                 => $oldOrderItem->father,
959 
                    "status"                 => $oldOrderItem->status,
960 
                    "delivery_status"        => $oldOrderItem->lieferstatus,
569 lars 961 
                    "invoice_status"         => $oldOrderItem->rechnungStatus,
567 lars 962 
                    "delivery_note_status"   => $oldOrderItem->lieferscheinStatus,
963 
                    "foreign_id"             => $oldOrderItem->fremd_id,
570 lars 964 
                    "option_input"           => $oldOrderItem->option_eingabe,
567 lars 965 
                    "description"            => $oldOrderItem->beschreibung,
569 lars 966 
                    "rank"                   => $oldOrderItem->Rang,
567 lars 967 
                    "tax"                    => $oldOrderItem->mwst,
968 
                    "orig_value"             => $oldOrderItem->orig_value,
969 
                    "orig_currency"          => $oldOrderItem->orig_currency,
970 
                    "hash"                   => $oldOrderItem->hash,
573 lars 971 
                    "exported"               => $exported,
574 lars 972 
                    "exported_invoice"       => $exported_invoice,
973 
                    "exported_delivery_note" => $exported_delivery_note,
567 lars 974 
 
561 lars 975 
                ] );
454 lars 976 
                $progressbar->advance();
977 
            }
978 
            $progressbar->finish();
979 
            $progressbar->clear();
304 lars 980 
        }
535 lars 981 
 
982 
        private function migrateSalesPortalTypes()
983 
        {
984 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalarten" );
985 
            $start = 0;
986 
            $sql = "SELECT
987 
                    MAX(id) start
988 
                FROM
989 
                    sales_portal_types
990 
            ";
991 
            $row = DB::connection( 'cms' )->select( $sql );
992 
            if ( $row[0]->start )
993 
            {
994 
                $start = $row[0]->start;
995 
            }
996 
            $sql = "SELECT
997 
                    *
998 
                FROM
999 
                    vportale_art
1000 
                WHERE
1001 
                    id>" . $start . "
1002 
            ";
1003 
            $portals = DB::connection( 'cms' )->select( $sql );
552 lars 1004 
            $progressbar = $this->output->createProgressBar( count( $portals ) );
1005 
            $progressbar->start();
535 lars 1006 
            foreach ( $portals as $portal )
1007 
            {
1008 
                SalesPortalType::factory()->create( [
1009 
                    "id"                   => $portal->id,
1010 
                    "type"                 => $portal->art,
1011 
                    "name"                 => $portal->bezeichnung,
1012 
                    "max_categories"       => $portal->max_categories,
1013 
                    "min_depth_category"   => $portal->min_depth_category,
1014 
                    "only_end_category"    => $portal->only_end_category,
1015 
                    "script"               => $portal->skript,
1016 
                    "script_folder"        => $portal->script_folder,
1017 
                    "commit_possibilities" => $portal->commit_posibilities,
1018 
                    "revokeable"           => $portal->stornierbar,
1019 
                ] );
552 lars 1020 
                $progressbar->advance();
535 lars 1021 
            }
552 lars 1022 
            $progressbar->finish();
1023 
            $progressbar->clear();
535 lars 1024 
        }
1025 
 
1026 
        private function migrateSalesPortals()
1027 
        {
1028 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportale" );
1029 
            $start = 0;
1030 
            $sql = "SELECT
1031 
                    MAX(id) start
1032 
                FROM
1033 
                    sales_portals
1034 
            ";
1035 
            $row = DB::connection( 'mysql' )->select( $sql );
1036 
            if ( $row[0]->start )
1037 
            {
1038 
                $start = $row[0]->start;
1039 
            }
1040 
            $sql = "SELECT
1041 
                    *
1042 
                FROM
1043 
                    vportale
1044 
                WHERE
1045 
                    id>" . $start . "
1046 
            ";
1047 
            $portals = DB::connection( 'old' )->select( $sql );
552 lars 1048 
            $progressbar = $this->output->createProgressBar( count( $portals ) );
1049 
            $progressbar->start();
535 lars 1050 
            foreach ( $portals as $portal )
538 lars 1051 
            {
1052 
                $max_preis = 0;
1053 
                $anrede = 1;
1054 
                if ( isset( $portal->anrede ) )
1055 
                {
1056 
                    $anrede = $portal->anrede;
1057 
                }
1058 
                if ( isset( $portal->max_preis ) )
1059 
                {
1060 
                    $max_preis = $portal->max_preis;
1061 
                }
535 lars 1062 
                SalesPortal::factory()->create( [
538 lars 1063 
                    "id"                   => $portal->id,
1064 
                    "name"                 => $portal->name,
1065 
                    "template"             => $portal->template,
1066 
                    "sales_portal_type_id" => $portal->art,
1067 
                    "sku_prefix"           => $portal->sku_prefix,
1068 
                    "price_number"         => $portal->preis_nummer,
1069 
                    "base_price"           => $portal->basis_preis,
1070 
                    "min_price"            => $portal->min_preis,
1071 
                    "max_price"            => $max_preis,
1072 
                    "digits"               => $portal->runden,
1073 
                    "standard_amount"      => $portal->standard_menge,
1074 
                    "item_url"             => $portal->artikel_url,
1075 
                    "currency"             => $portal->currency,
1076 
                    "shipping_state"       => $portal->lieferstatus,
1077 
                    "delivery"             => $portal->delivery,
1078 
                    "shipping_cost"        => $portal->shipping_cost,
1079 
                    "afterbuy"             => $portal->afterbuy,
1080 
                    "salutation"           => $anrede,
1081 
                    "commit_fields"        => $portal->commit_fields,
1082 
                    "zip"                  => $portal->plz,
1083 
                    "location"             => $portal->location,
1084 
                    "created_by"           => $portal->erstellt_von,
1085 
                    "updated_by"           => $portal->geaendert_von,
1086 
                    "created_at"           => $portal->erstellt_am,
1087 
                    "updated_at"           => $portal->geaendert_am,
535 lars 1088 
                ] );
552 lars 1089 
                $progressbar->advance();
535 lars 1090 
            }
552 lars 1091 
            $progressbar->finish();
1092 
            $progressbar->clear();
535 lars 1093 
        }
538 lars 1094 
 
1095 
        private function migrateSalesPortalItems()
1096 
        {
1097 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );
1098 
            $start = 0;
1099 
            $sql = "SELECT
1100 
                    MAX(id) start
1101 
                FROM
1102 
                    sales_portal_items
1103 
            ";
1104 
            $row = DB::connection( 'mysql' )->select( $sql );
1105 
            if ( $row[0]->start )
1106 
            {
1107 
                $start = $row[0]->start;
1108 
            }
1109 
            $sql = "SELECT
1110 
                    *
1111 
                FROM
1112 
                    artikel_vportale
1113 
                WHERE
1114 
                    id>" . $start . "
1115 
            ";
1116 
            $items = DB::connection( 'old' )->select( $sql );
552 lars 1117 
            $progressbar = $this->output->createProgressBar( count( $items ) );
1118 
            $progressbar->start();
538 lars 1119 
            foreach ( $items as $item )
1120 
            {
544 lars 1121 
                $pickup = 0;
1122 
                if ( isset( $item->pickup ) )
1123 
                {
1124 
                    $pickup = $item->pickup;
1125 
                }
549 lars 1126 
                $start = $item->start;
1127 
                if ( $start == "0000-00-00 00:00:00" )
1128 
                {
1129 
                    $start = null;
1130 
                }
547 lars 1131 
                $erstellt_am = $item->erstellt_am;
1132 
                if ( $erstellt_am == "0000-00-00 00:00:00" )
1133 
                {
1134 
                    $erstellt_am = null;
1135 
                }
548 lars 1136 
                $geaendert_am = $item->geaendert_am;
1137 
                if ( $geaendert_am == "0000-00-00 00:00:00" )
547 lars 1138 
                {
548 lars 1139 
                    $geaendert_am = null;
547 lars 1140 
                }
538 lars 1141 
                SalesPortalItem::factory()->create( [
1142 
                    "id"                              => $item->id,
1143 
                    "sales_portal_id"                 => $item->vportale_id,
1144 
                    "item_id"                         => $item->artikel_id,
1145 
                    "sales_portal_template_id"        => $item->template_id,
1146 
                    "sku"                             => $item->sku,
1147 
                    "additions"                       => $item->zusaetze,
1148 
                    "foreign_item_id"                 => $item->fremdartikel_id,
1149 
                    "name"                            => $item->name,
1150 
                    "autochange_name"                 => $item->autochange_name,
1151 
                    "name_bold"                       => $item->name_fett,
1152 
                    "highlight"                       => $item->highlight,
1153 
                    "sub_name"                        => $item->sub_name,
1154 
                    "manufacturer"                    => $item->hersteller,
1155 
                    "autochange_manufacturer"         => $item->autochange_hersteller,
1156 
                    "ean"                             => $item->ean,
1157 
                    "autochange_ean"                  => $item->autochange_ean,
1158 
                    "mpn"                             => $item->mpn,
1159 
                    "autochange_mpn"                  => $item->autochange_mpn,
1160 
                    "description"                     => $item->beschreibung,
1161 
                    "autochange_description"          => $item->autochange_beschreibung,
541 lars 1162 
                    "description_addition"            => $item->beschreibung_zusatz,
542 lars 1163 
                    "autochange_description_addition" => $item->autochange_beschreibung_zusatz,
538 lars 1164 
                    "price"                           => $item->preis,
1165 
                    "autochange_price"                => $item->autochange_preis,
543 lars 1166 
                    "currency"                        => $item->currency,
538 lars 1167 
                    "tax"                             => $item->tax,
1168 
                    "price_type"                      => $item->preisart,
1169 
                    "amount"                          => $item->menge,
1170 
                    "carrier"                         => $item->carrier,
1171 
                    "carrier_cost"                    => $item->carrier_cost,
549 lars 1172 
                    "start"                           => $start,
538 lars 1173 
                    "duration"                        => $item->dauer,
1174 
                    "category_1"                      => $item->kategorie_1,
1175 
                    "category_2"                      => $item->kategorie_2,
1176 
                    "category_3"                      => $item->kategorie_3,
1177 
                    "bp1"                             => $item->bp1,
1178 
                    "bp2"                             => $item->bp2,
1179 
                    "bp3"                             => $item->bp3,
1180 
                    "bp4"                             => $item->bp4,
1181 
                    "bp5"                             => $item->bp5,
1182 
                    "platin_search_1"                 => $item->platin_search_1,
1183 
                    "platin_search_2"                 => $item->platin_search_2,
1184 
                    "platin_search_3"                 => $item->platin_search_3,
1185 
                    "platin_search_4"                 => $item->platin_search_4,
1186 
                    "platin_search_5"                 => $item->platin_search_5,
1187 
                    "search_1"                        => $item->search_1,
1188 
                    "search_2"                        => $item->search_2,
1189 
                    "search_3"                        => $item->search_3,
1190 
                    "search_4"                        => $item->search_4,
1191 
                    "search_5"                        => $item->search_5,
1192 
                    "status"                          => $item->status,
1193 
                    "online_status"                   => $item->online_status,
1194 
                    "delivery_time"                   => $item->lieferzeit,
544 lars 1195 
                    "pickup"                          => $pickup,
538 lars 1196 
                    "last_feedback"                   => $item->last_feedback,
1197 
                    "created_by"                      => $item->erstellt_von,
1198 
                    "updated_by"                      => $item->geaendert_von,
547 lars 1199 
                    "created_at"                      => $erstellt_am,
1200 
                    "updated_at"                      => $geaendert_am,
538 lars 1201 
                ] );
552 lars 1202 
                $progressbar->advance();
538 lars 1203 
            }
552 lars 1204 
            $progressbar->finish();
1205 
            $progressbar->clear();
555 lars 1206 
        }
551 lars 1207 
 
555 lars 1208 
        private function migratePriceAgencies()
1209 
        {
552 lars 1210 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );
551 lars 1211 
            $start = 0;
1212 
            $sql = "SELECT
1213 
                    MAX(id) start
1214 
                FROM
1215 
                    price_agencies
1216 
            ";
1217 
            $row = DB::connection( 'mysql' )->select( $sql );
1218 
            if ( $row[0]->start )
1219 
            {
1220 
                $start = $row[0]->start;
1221 
            }
1222 
            $sql = "SELECT
1223 
                    *
1224 
                FROM
1225 
                    Preisagentur
1226 
                WHERE
1227 
                    id>" . $start . "
1228 
            ";
555 lars 1229 
            $agencies = DB::connection( 'old' )->select( $sql );
552 lars 1230 
            $progressbar = $this->output->createProgressBar( count( $agencies ) );
1231 
            $progressbar->start();
580 lars 1232 
            foreach ( $agencies as $manufacturer )
555 lars 1233 
            {
580 lars 1234 
                $letzter_Abruf_am = $manufacturer->letzter_Abruf_am;
555 lars 1235 
                if ( $letzter_Abruf_am == "0000-00-00 00:00:00" )
1236 
                {
1237 
                    $letzter_Abruf_am = null;
1238 
                }
580 lars 1239 
                $letzte_Aktualisierung_am = $manufacturer->letzte_Aktualisierung_am;
555 lars 1240 
                if ( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
1241 
                {
1242 
                    $letzte_Aktualisierung_am = null;
1243 
                }
1244 
                PriceAgency::factory()->create( [
580 lars 1245 
                    "id"                   => $manufacturer->ID,
1246 
                    "shop_id"              => $manufacturer->shops_ID,
1247 
                    "name"                 => $manufacturer->Titel,
1248 
                    "logo_url"             => $manufacturer->logo_url,
1249 
                    "home_url"             => $manufacturer->home_url,
1250 
                    "csv_url"              => $manufacturer->csv_url,
1251 
                    "trigger_url"          => $manufacturer->trigger_URL,
1252 
                    "voting_url"           => $manufacturer->bewertungs_URL,
1253 
                    "records"              => $manufacturer->datensaetze,
1254 
                    "access_url"           => $manufacturer->Zugang_URL,
1255 
                    "access_user"          => $manufacturer->Zugang_Benutzer,
1256 
                    "access_password"      => $manufacturer->Zugang_Passwort,
1257 
                    "comment"              => $manufacturer->Bemerkung,
1258 
                    "locked_manufacturers" => $manufacturer->gesperrte_hersteller,
1259 
                    "config"               => $manufacturer->config,
1260 
                    "status"               => $manufacturer->status,
1261 
                    "only_deliverable"     => $manufacturer->nur_lieferbar,
1262 
                    "min_price"            => $manufacturer->min_preis,
555 lars 1263 
                    "last_updated_at"      => $letzte_Aktualisierung_am,
1264 
                    "last_access_at"       => $letzter_Abruf_am,
580 lars 1265 
                    "last_access_by"       => $manufacturer->letzter_Abruf_von,
1266 
                    "updated_at"           => $manufacturer->letzte_Aenderung_am,
1267 
                    "updated_by"           => $manufacturer->letzte_Aenderung_von,
555 lars 1268 
                ] );
552 lars 1269 
                $progressbar->advance();
1270 
            }
1271 
            $progressbar->finish();
1272 
            $progressbar->clear();
555 lars 1273 
        }
580 lars 1274 
 
1275 
        private function migrateManufacturers()
1276 
        {
1277 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Hersteller" );
1278 
            $start = 0;
1279 
            $sql = "SELECT
1280 
                    MAX(id) start
1281 
                FROM
1282 
                    manufacturers
1283 
            ";
1284 
            $row = DB::connection( 'mysql' )->select( $sql );
1285 
            if ( $row[0]->start )
1286 
            {
1287 
                $start = $row[0]->start;
1288 
            }
1289 
            $sql = "SELECT
1290 
                    *
1291 
                FROM
1292 
                    Herstellerkatalog
1293 
                WHERE
1294 
                    id>" . $start . "
1295 
            ";
1296 
            $manufacturers = DB::connection( 'old' )->select( $sql );
1297 
            $progressbar = $this->output->createProgressBar( count( $manufacturers ) );
1298 
            $progressbar->start();
1299 
            foreach ( $manufacturers as $manufacturer )
1300 
            {
1301 
                Manufacturer::factory()->create( [
1302 
                    "id"          => $manufacturer->ID,
1303 
                    "name"        => $manufacturer->Name,
1304 
                    "description" => $manufacturer->Text,
586 lars 1305 
                    "logo1"       => $manufacturer->Logo1,
1306 
                    "logo1_href"  => $manufacturer->Logo1_href,
587 lars 1307 
                    "logo2"       => $manufacturer->Logo2,
586 lars 1308 
                    "logo2_href"  => $manufacturer->Logo2_href,
589 lars 1309 
                    "property_1"  => $manufacturer->Eigenschaft_1,
1310 
                    "property_2"  => $manufacturer->Eigenschaft_2,
1311 
                    "property_3"  => $manufacturer->Eigenschaft_2,
588 lars 1312 
                    "calculation" => $manufacturer->abwKalkulation,
580 lars 1313 
                    "created_at"  => $manufacturer->erstellt_am,
1314 
                    "created_by"  => $manufacturer->erstellt_von,
1315 
                    "updated_at"  => $manufacturer->letzte_Aenderung_am,
1316 
                    "updated_by"  => $manufacturer->letzte_Aenderung_von,
1317 
                ] );
1318 
                $progressbar->advance();
1319 
            }
1320 
            $progressbar->finish();
1321 
            $progressbar->clear();
600 lars 1322 
        }
580 lars 1323 
 
600 lars 1324 
        private function migrateTemplates()
1325 
        {
1326 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Templates" );
1327 
            $start = 0;
1328 
            $sql = "SELECT
1329 
                    MAX(id) start
1330 
                FROM
1331 
                    templates
1332 
            ";
1333 
            $row = DB::connection( 'mysql' )->select( $sql );
1334 
            if ( $row[0]->start )
1335 
            {
1336 
                $start = $row[0]->start;
1337 
            }
1338 
            $sql = "SELECT
1339 
                    *
1340 
                FROM
1341 
                    templates
1342 
                WHERE
1343 
                    id>" . $start . "
1344 
            ";
1345 
            $templates = DB::connection( 'old' )->select( $sql );
1346 
            $progressbar = $this->output->createProgressBar( count( $templates ) );
1347 
            $progressbar->start();
1348 
            foreach ( $templates as $template )
1349 
            {
603 lars 1350 
                switch ( $template->Typ )
1351 
                {
1352 
                    case "Aktionen":
1353 
                        $typ = "action";
1354 
                        break;
1355 
                    case "artikel":
1356 
                        $typ = "item";
1357 
                        break;
1358 
                    case "directory":
1359 
                        $typ = "directory";
1360 
                        break;
1361 
                    case "Artikelstamm":
1362 
                        $typ = "articlemaster";
1363 
                        break;
1364 
                    default:
1365 
                        $typ = "";
1366 
                }
600 lars 1367 
                Template::factory()->create( [
1368 
                    "id"             => $template->ID,
1369 
                    "shop_id"        => $template->shops_ID,
1370 
                    "name"           => $template->Name,
1371 
                    "description"    => $template->Beschreibung,
1372 
                    "template_key"   => $template->templateKey,
601 lars 1373 
                    "template_value" => $template->templateValue,
603 lars 1374 
                    "type"           => $typ,
600 lars 1375 
                ] );
1376 
                $progressbar->advance();
1377 
            }
1378 
            $progressbar->finish();
1379 
            $progressbar->clear();
1380 
            $start = 0;
1381 
            $sql = "SELECT
1382 
                    MAX(id) start
1383 
                FROM
618 lars 1384 
                    item_templates
1385 
            ";
1386 
            $row = DB::connection( 'mysql' )->select( $sql );
1387 
            if ( $row[0]->start )
1388 
            {
1389 
                $start = $row[0]->start;
1390 
            }
1391 
            $sql = "SELECT
1392 
                    *
1393 
                FROM
1394 
                    templates_to_artikel
1395 
                WHERE
1396 
                    id>" . $start . "
1397 
            ";
1398 
            $templates = DB::connection( 'old' )->select( $sql );
1399 
            $progressbar = $this->output->createProgressBar( count( $templates ) );
1400 
            $progressbar->start();
1401 
            foreach ( $templates as $template )
1402 
            {
619 lars 1403 
                ItemTemplate::factory()->create( [
618 lars 1404 
                    "id"           => $template->id,
619 lars 1405 
                    "item_id"      => $template->artikel_ID,
618 lars 1406 
                    "template_id"  => $template->templates_ID,
1407 
                ] );
1408 
                $progressbar->advance();
1409 
            }
1410 
            $progressbar->finish();
1411 
            $progressbar->clear();
1412 
            $start = 0;
1413 
            $sql = "SELECT
1414 
                    MAX(id) start
1415 
                FROM
600 lars 1416 
                    directory_templates
1417 
            ";
1418 
            $row = DB::connection( 'mysql' )->select( $sql );
1419 
            if ( $row[0]->start )
1420 
            {
1421 
                $start = $row[0]->start;
1422 
            }
1423 
            $sql = "SELECT
1424 
                    *
1425 
                FROM
606 lars 1426 
                    templates_to_directory
600 lars 1427 
                WHERE
1428 
                    id>" . $start . "
1429 
            ";
1430 
            $templates = DB::connection( 'old' )->select( $sql );
1431 
            $progressbar = $this->output->createProgressBar( count( $templates ) );
1432 
            $progressbar->start();
1433 
            foreach ( $templates as $template )
1434 
            {
1435 
                DirectoryTemplate::factory()->create( [
604 lars 1436 
                    "id"           => $template->id,
605 lars 1437 
                    "directory_id" => $template->directory_ID,
1438 
                    "template_id"  => $template->templates_ID,
600 lars 1439 
                ] );
1440 
                $progressbar->advance();
1441 
            }
1442 
            $progressbar->finish();
1443 
            $progressbar->clear();
580 lars 1444 
        }
233 lars 1445 
    }