WebSVN – lars-tiefland.laravel_shop – Diff – /trunk/app/Console/Commands/convertDB.php



                $this->migrateOrderItems();
            }
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
        }

 
        private function migrateShops(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Shops" );
            $start = 0;
            $sql = "

                $shop->save();
            }

 

        }
 
        private function migrateOrderTypes(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellarten" );
            $start = 0;

                    "short"         => $short,
                ] );
            }
        }

 
        private function migratePaymentMethods(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );
            $start = 0;
            $sql = "SELECT

                    "shipping_text" => $method->versandtextbaustein,
                ] );
            }
        }

 
        private function migrateShippingGroups(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );
            $sql = "SELECT
                    *

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateShippings(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );
            $sql = "SELECT
                    *

                    }
                }
            }
        }

 
        private function migrateActions(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
            $sql = "
                SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateDirs(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );
            $sql = '
                SELECT 

                $dir->name = $row->Name;
                $dir->articlemaster = $row->Artikelstamm;
                $dir->status = $row->status;
                $dir->kennung = $row->Kennung;
                $dir->description = $row->Beschreibung;
                $dir->description2 = $row->Beschreibung2;
                $dir->short_line_1 = $row->short_line_1;
                $dir->url = $row->url;
                $dir->created_at = $row->erstellt_am;
                $dir->created_by = $ersteller;
                $dir->updated_by = $bearbeiter;

            $progressbar->finish();
            $progressbar->clear();
            DB::statement( 'SET FOREIGN_KEY_CHECKS=1' );
        }

 
        private function migrateItems(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
            $sql = '
                SELECT 

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        public function migrateMedia(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        public function migrateActionMedia( $aktionId ): void
        {
            $sql = "SELECT
                    *
                FROM

                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
            }
        }

 
        public function migrateDirMedia( $dir ): void
        {
            $sql = "SELECT
                    *
                FROM

                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
            }
        }

 
        public function migrateItemMedia( $item ): void
        {
            $sql = "SELECT
                    *
                FROM

                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
            }
        }

 
        private function migrateUsers(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateAddresses( bool $isOrder = false ): void
        {
            $typ = "Adressen";
            $table = "addresses";
            $oldTable = "adresse";

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateOrderAddresses(): void
        {
            $this->migrateAddresses( true );

        }
 
        private function migrateOrders(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellungen" );
            $start = 0;

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateOrderItems(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel in Bestellungen" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateSalesPortalTypes(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalarten" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateSalesPortals(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportale" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateSalesPortalItems(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migratePriceAgencies(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateManufacturers(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Hersteller" );
            $start = 0;
            $sql = "SELECT

            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateTempl2ates(): void
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Templates" );
            $start = 0;
            $sql = "SELECT

Revision 1463	Revision 1601
Zeile 87...	Zeile 87...
87	`$this->migrateOrderItems();`	87	`$this->migrateOrderItems();`
88	`}`	88	`}`
89	`$this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );`	89	`$this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );`
90	`}`	90	`}`
Zeile 91...	Zeile 91...
91		91
92	`private function migrateShops()`	92	`private function migrateShops(): void`
93	`{`	93	`{`
94	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Shops" );`	94	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Shops" );`
95	`$start = 0;`	95	`$start = 0;`
96	`$sql = "`	96	`$sql = "`
Zeile 155...	Zeile 155...
155	`$shop->save();`	155	`$shop->save();`
156	`}`	156	`}`
Zeile 157...	Zeile 157...
157		157
Zeile 158...	Zeile 158...
158	`}`	158	`}`
159		159
160	`private function migrateOrderTypes()`	160	`private function migrateOrderTypes(): void`
161	`{`	161	`{`
162	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellarten" );`	162	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellarten" );`
163	`$start = 0;`	163	`$start = 0;`
Zeile 194...	Zeile 194...
194	`"short" => $short,`	194	`"short" => $short,`
195	`] );`	195	`] );`
196	`}`	196	`}`
197	`}`	197	`}`
Zeile 198...	Zeile 198...
198		198
199	`private function migratePaymentMethods()`	199	`private function migratePaymentMethods(): void`
200	`{`	200	`{`
201	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );`	201	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );`
202	`$start = 0;`	202	`$start = 0;`
203	`$sql = "SELECT`	203	`$sql = "SELECT`
Zeile 229...	Zeile 229...
229	`"shipping_text" => $method->versandtextbaustein,`	229	`"shipping_text" => $method->versandtextbaustein,`
230	`] );`	230	`] );`
231	`}`	231	`}`
232	`}`	232	`}`
Zeile 233...	Zeile 233...
233		233
234	`private function migrateShippingGroups()`	234	`private function migrateShippingGroups(): void`
235	`{`	235	`{`
236	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );`	236	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );`
237	`$sql = "SELECT`	237	`$sql = "SELECT`
238	`*`	238	`*`
Zeile 275...	Zeile 275...
275	`}`	275	`}`
276	`$progressbar->finish();`	276	`$progressbar->finish();`
277	`$progressbar->clear();`	277	`$progressbar->clear();`
278	`}`	278	`}`
Zeile 279...	Zeile 279...
279		279
280	`private function migrateShippings()`	280	`private function migrateShippings(): void`
281	`{`	281	`{`
282	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );`	282	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );`
283	`$sql = "SELECT`	283	`$sql = "SELECT`
284	`*`	284	`*`
Zeile 370...	Zeile 370...
370	`}`	370	`}`
371	`}`	371	`}`
372	`}`	372	`}`
373	`}`	373	`}`
Zeile 374...	Zeile 374...
374		374
375	`private function migrateActions()`	375	`private function migrateActions(): void`
376	`{`	376	`{`
377	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );`	377	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );`
378	`$sql = "`	378	`$sql = "`
379	`SELECT`	379	`SELECT`
Zeile 408...	Zeile 408...
408	`}`	408	`}`
409	`$progressbar->finish();`	409	`$progressbar->finish();`
410	`$progressbar->clear();`	410	`$progressbar->clear();`
411	`}`	411	`}`
Zeile 412...	Zeile 412...
412		412
413	`private function migrateDirs()`	413	`private function migrateDirs(): void`
414	`{`	414	`{`
415	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );`	415	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );`
416	`$sql = '`	416	`$sql = '`
417	`SELECT`	417	`SELECT`
Zeile 447...	Zeile 447...
447	`$dir->name = $row->Name;`	447	`$dir->name = $row->Name;`
448	`$dir->articlemaster = $row->Artikelstamm;`	448	`$dir->articlemaster = $row->Artikelstamm;`
449	`$dir->status = $row->status;`	449	`$dir->status = $row->status;`
450	`$dir->kennung = $row->Kennung;`	450	`$dir->kennung = $row->Kennung;`
451	`$dir->description = $row->Beschreibung;`	451	`$dir->description = $row->Beschreibung;`
-		452	`$dir->description2 = $row->Beschreibung2;`
452	`$dir->short_line_1 = $row->short_line_1;`	453	`$dir->short_line_1 = $row->short_line_1;`
453	`$dir->url = $row->url;`	454	`$dir->url = $row->url;`
454	`$dir->created_at = $row->erstellt_am;`	455	`$dir->created_at = $row->erstellt_am;`
455	`$dir->created_by = $ersteller;`	456	`$dir->created_by = $ersteller;`
456	`$dir->updated_by = $bearbeiter;`	457	`$dir->updated_by = $bearbeiter;`
Zeile 462...	Zeile 463...
462	`$progressbar->finish();`	463	`$progressbar->finish();`
463	`$progressbar->clear();`	464	`$progressbar->clear();`
464	`DB::statement( 'SET FOREIGN_KEY_CHECKS=1' );`	465	`DB::statement( 'SET FOREIGN_KEY_CHECKS=1' );`
465	`}`	466	`}`
Zeile 466...	Zeile 467...
466		467
467	`private function migrateItems()`	468	`private function migrateItems(): void`
468	`{`	469	`{`
469	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );`	470	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );`
470	`$sql = '`	471	`$sql = '`
471	`SELECT`	472	`SELECT`
Zeile 560...	Zeile 561...
560	`}`	561	`}`
561	`$progressbar->finish();`	562	`$progressbar->finish();`
562	`$progressbar->clear();`	563	`$progressbar->clear();`
563	`}`	564	`}`
Zeile 564...	Zeile 565...
564		565
565	`public function migrateMedia()`	566	`public function migrateMedia(): void`
566	`{`	567	`{`
567	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );`	568	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );`
568	`$start = 0;`	569	`$start = 0;`
569	`$sql = "SELECT`	570	`$sql = "SELECT`
Zeile 616...	Zeile 617...
616	`}`	617	`}`
617	`$progressbar->finish();`	618	`$progressbar->finish();`
618	`$progressbar->clear();`	619	`$progressbar->clear();`
619	`}`	620	`}`
Zeile 620...	Zeile 621...
620		621
621	`public function migrateActionMedia( $aktionId )`	622	`public function migrateActionMedia( $aktionId ): void`
622	`{`	623	`{`
623	`$sql = "SELECT`	624	`$sql = "SELECT`
624	`*`	625	`*`
625	`FROM`	626	`FROM`
Zeile 643...	Zeile 644...
643	`$medium->updated_by = "WebanOS Laravel Upgrade";`	644	`$medium->updated_by = "WebanOS Laravel Upgrade";`
644	`$medium->save();`	645	`$medium->save();`
645	`}`	646	`}`
646	`}`	647	`}`
Zeile 647...	Zeile 648...
647		648
648	`public function migrateDirMedia( $dir )`	649	`public function migrateDirMedia( $dir ): void`
649	`{`	650	`{`
650	`$sql = "SELECT`	651	`$sql = "SELECT`
651	`*`	652	`*`
652	`FROM`	653	`FROM`
Zeile 673...	Zeile 674...
673	`$medium->updated_by = "WebanOS Laravel Upgrade";`	674	`$medium->updated_by = "WebanOS Laravel Upgrade";`
674	`$medium->save();`	675	`$medium->save();`
675	`}`	676	`}`
676	`}`	677	`}`
Zeile 677...	Zeile 678...
677		678
678	`public function migrateItemMedia( $item )`	679	`public function migrateItemMedia( $item ): void`
679	`{`	680	`{`
680	`$sql = "SELECT`	681	`$sql = "SELECT`
681	`*`	682	`*`
682	`FROM`	683	`FROM`
Zeile 703...	Zeile 704...
703	`$medium->updated_by = "WebanOS Laravel Upgrade";`	704	`$medium->updated_by = "WebanOS Laravel Upgrade";`
704	`$medium->save();`	705	`$medium->save();`
705	`}`	706	`}`
706	`}`	707	`}`
Zeile 707...	Zeile 708...
707		708
708	`private function migrateUsers()`	709	`private function migrateUsers(): void`
709	`{`	710	`{`
710	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );`	711	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );`
711	`$start = 0;`	712	`$start = 0;`
712	`$sql = "SELECT`	713	`$sql = "SELECT`
Zeile 753...	Zeile 754...
753	`}`	754	`}`
754	`$progressbar->finish();`	755	`$progressbar->finish();`
755	`$progressbar->clear();`	756	`$progressbar->clear();`
756	`}`	757	`}`
Zeile 757...	Zeile 758...
757		758
758	`private function migrateAddresses( bool $isOrder = false )`	759	`private function migrateAddresses( bool $isOrder = false ): void`
759	`{`	760	`{`
760	`$typ = "Adressen";`	761	`$typ = "Adressen";`
761	`$table = "addresses";`	762	`$table = "addresses";`
762	`$oldTable = "adresse";`	763	`$oldTable = "adresse";`
Zeile 833...	Zeile 834...
833	`}`	834	`}`
834	`$progressbar->finish();`	835	`$progressbar->finish();`
835	`$progressbar->clear();`	836	`$progressbar->clear();`
836	`}`	837	`}`
Zeile 837...	Zeile 838...
837		838
838	`private function migrateOrderAddresses()`	839	`private function migrateOrderAddresses(): void`
839	`{`	840	`{`
840	`$this->migrateAddresses( true );`	841	`$this->migrateAddresses( true );`
Zeile 841...	Zeile 842...
841	`}`	842	`}`
842		843
843	`private function migrateOrders()`	844	`private function migrateOrders(): void`
844	`{`	845	`{`
845	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellungen" );`	846	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellungen" );`
846	`$start = 0;`	847	`$start = 0;`
Zeile 905...	Zeile 906...
905	`}`	906	`}`
906	`$progressbar->finish();`	907	`$progressbar->finish();`
907	`$progressbar->clear();`	908	`$progressbar->clear();`
908	`}`	909	`}`
Zeile 909...	Zeile 910...
909		910
910	`private function migrateOrderItems()`	911	`private function migrateOrderItems(): void`
911	`{`	912	`{`
912	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel in Bestellungen" );`	913	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel in Bestellungen" );`
913	`$start = 0;`	914	`$start = 0;`
914	`$sql = "SELECT`	915	`$sql = "SELECT`
Zeile 977...	Zeile 978...
977	`}`	978	`}`
978	`$progressbar->finish();`	979	`$progressbar->finish();`
979	`$progressbar->clear();`	980	`$progressbar->clear();`
980	`}`	981	`}`
Zeile 981...	Zeile 982...
981		982
982	`private function migrateSalesPortalTypes()`	983	`private function migrateSalesPortalTypes(): void`
983	`{`	984	`{`
984	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalarten" );`	985	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalarten" );`
985	`$start = 0;`	986	`$start = 0;`
986	`$sql = "SELECT`	987	`$sql = "SELECT`
Zeile 1021...	Zeile 1022...
1021	`}`	1022	`}`
1022	`$progressbar->finish();`	1023	`$progressbar->finish();`
1023	`$progressbar->clear();`	1024	`$progressbar->clear();`
1024	`}`	1025	`}`
Zeile 1025...	Zeile 1026...
1025		1026
1026	`private function migrateSalesPortals()`	1027	`private function migrateSalesPortals(): void`
1027	`{`	1028	`{`
1028	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportale" );`	1029	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportale" );`
1029	`$start = 0;`	1030	`$start = 0;`
1030	`$sql = "SELECT`	1031	`$sql = "SELECT`
Zeile 1090...	Zeile 1091...
1090	`}`	1091	`}`
1091	`$progressbar->finish();`	1092	`$progressbar->finish();`
1092	`$progressbar->clear();`	1093	`$progressbar->clear();`
1093	`}`	1094	`}`
Zeile 1094...	Zeile 1095...
1094		1095
1095	`private function migrateSalesPortalItems()`	1096	`private function migrateSalesPortalItems(): void`
1096	`{`	1097	`{`
1097	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );`	1098	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );`
1098	`$start = 0;`	1099	`$start = 0;`
1099	`$sql = "SELECT`	1100	`$sql = "SELECT`
Zeile 1203...	Zeile 1204...
1203	`}`	1204	`}`
1204	`$progressbar->finish();`	1205	`$progressbar->finish();`
1205	`$progressbar->clear();`	1206	`$progressbar->clear();`
1206	`}`	1207	`}`
Zeile 1207...	Zeile 1208...
1207		1208
1208	`private function migratePriceAgencies()`	1209	`private function migratePriceAgencies(): void`
1209	`{`	1210	`{`
1210	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );`	1211	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );`
1211	`$start = 0;`	1212	`$start = 0;`
1212	`$sql = "SELECT`	1213	`$sql = "SELECT`
Zeile 1270...	Zeile 1271...
1270	`}`	1271	`}`
1271	`$progressbar->finish();`	1272	`$progressbar->finish();`
1272	`$progressbar->clear();`	1273	`$progressbar->clear();`
1273	`}`	1274	`}`
Zeile 1274...	Zeile 1275...
1274		1275
1275	`private function migrateManufacturers()`	1276	`private function migrateManufacturers(): void`
1276	`{`	1277	`{`
1277	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Hersteller" );`	1278	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Hersteller" );`
1278	`$start = 0;`	1279	`$start = 0;`
1279	`$sql = "SELECT`	1280	`$sql = "SELECT`
Zeile 1319...	Zeile 1320...
1319	`}`	1320	`}`
1320	`$progressbar->finish();`	1321	`$progressbar->finish();`
1321	`$progressbar->clear();`	1322	`$progressbar->clear();`
1322	`}`	1323	`}`
Zeile 1323...	Zeile 1324...
1323		1324
1324	`private function migrateTemplates()`	1325	`private function migrateTempl2ates(): void`
1325	`{`	1326	`{`
1326	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Templates" );`	1327	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Templates" );`
1327	`$start = 0;`	1328	`$start = 0;`
1328	`$sql = "SELECT`	1329	`$sql = "SELECT`

Subversion-Projekte lars-tiefland.laravel_shop

(root)/trunk/app/Console/Commands/convertDB.php – Revision 1463 → 1601