Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 537 Revision 538
Zeile 93... Zeile 93...
93 
                $this->migrateDirMedia();
 93 
                $this->migrateDirMedia();
94 
                $this->migrateItemMedia();
 94 
                $this->migrateItemMedia();
95 
            }
 95 
            }
96 
            if ( env( 'site' ) == env( 'shop' ) )
 96 
            if ( env( 'site' ) == env( 'shop' ) )
97 
            {
 97 
            {
- 
 
 98 
                $this->migratePriceAgencies();
98 
                $this->migrateUsers();
 99 
                $this->migrateUsers();
99 
                $this->migrateAddresses();
 100 
                $this->migrateAddresses();
100 
                $this->migrateOrderAddresses();
 101 
                $this->migrateOrderAddresses();
101 
                $this->migrateOrders();
 102 
                $this->migrateOrders();
102 
                $this->migrateOrderItems();
 103 
                $this->migrateOrderItems();
103 
                $this->migrateSalesPortalTypes();
 104 
                $this->migrateSalesPortalTypes();
104 
            }
 105 
            }
105 
            $this->migrateSalesPortals();
 106 
            $this->migrateSalesPortals();
- 
 
 107 
            $this->migrateSalesPortalItems();
106 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
 108 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
107 
        }
 109 
        }
Zeile 108... Zeile 110...
108 
 
 110 
 
109 
        private function migrateShops()
 111 
        private function migrateShops()
Zeile 1006... Zeile 1008...
1006 
                WHERE
 1008 
                WHERE
1007 
                    id>" . $start . "
 1009 
                    id>" . $start . "
1008 
            ";
 1010 
            ";
1009 
            $portals = DB::connection( 'old' )->select( $sql );
 1011 
            $portals = DB::connection( 'old' )->select( $sql );
1010 
            foreach ( $portals as $portal )
 1012 
            foreach ( $portals as $portal )
1011 
	    {
 1013 
            {
1012 
		$max_preis = 0;
 1014 
                $max_preis = 0;
1013 
		$anrede = 1;
 1015 
                $anrede = 1;
1014 
		if( isset( $portal->anrede ) )
 1016 
                if ( isset( $portal->anrede ) )
1015 
		{
 1017 
                {
1016 
		    $anrede = $portal->anrede;
 1018 
                    $anrede = $portal->anrede;
1017 
		}
 1019 
                }
1018 
		if( isset( $portal->max_preis ) )
 1020 
                if ( isset( $portal->max_preis ) )
1019 
		{
 1021 
                {
1020 
		    $max_preis = $portal->max_preis;
 1022 
                    $max_preis = $portal->max_preis;
1021 
		}
 1023 
                }
1022 
                SalesPortal::factory()->create( [
 1024 
                SalesPortal::factory()->create( [
1023 
		    "id"                   => $portal->id,
 1025 
                    "id"                   => $portal->id,
1024 
		    "name"                 => $portal->name,
 1026 
                    "name"                 => $portal->name,
1025 
		    "template"             => $portal->template,
 1027 
                    "template"             => $portal->template,
1026 
		    "sales_portal_type_id" => $portal->art,
 1028 
                    "sales_portal_type_id" => $portal->art,
1027 
		    "sku_prefix"           => $portal->sku_prefix,
 1029 
                    "sku_prefix"           => $portal->sku_prefix,
1028 
		    "price_number"         => $portal->preis_nummer,
 1030 
                    "price_number"         => $portal->preis_nummer,
1029 
		    "base_price"           => $portal->basis_preis,
 1031 
                    "base_price"           => $portal->basis_preis,
1030 
		    "min_price"            => $portal->min_preis,
 1032 
                    "min_price"            => $portal->min_preis,
1031 
		    "max_price"            => $max_preis,
 1033 
                    "max_price"            => $max_preis,
1032 
		    "digits"               => $portal->runden,
 1034 
                    "digits"               => $portal->runden,
1033 
		    "standard_amount"      => $portal->standard_menge,
 1035 
                    "standard_amount"      => $portal->standard_menge,
1034 
		    "item_url"             => $portal->artikel_url,
 1036 
                    "item_url"             => $portal->artikel_url,
1035 
		    "currency"             => $portal->currency,
 1037 
                    "currency"             => $portal->currency,
1036 
		    "shipping_state"       => $portal->lieferstatus,
 1038 
                    "shipping_state"       => $portal->lieferstatus,
1037 
		    "delivery"             => $portal->delivery,
 1039 
                    "delivery"             => $portal->delivery,
1038 
		    "shipping_cost"        => $portal->shipping_cost,
 1040 
                    "shipping_cost"        => $portal->shipping_cost,
1039 
		    "afterbuy"             => $portal->afterbuy,
 1041 
                    "afterbuy"             => $portal->afterbuy,
1040 
		    "salutation"           => $anrede,
 1042 
                    "salutation"           => $anrede,
1041 
		    "commit_fields"        => $portal->commit_fields,
 1043 
                    "commit_fields"        => $portal->commit_fields,
1042 
		    "zip"                  => $portal->plz,
 1044 
                    "zip"                  => $portal->plz,
1043 
		    "location"             => $portal->location,
 1045 
                    "location"             => $portal->location,
1044 
		    "created_by"           => $portal->erstellt_von,
 1046 
                    "created_by"           => $portal->erstellt_von,
1045 
		    "updated_by"           => $portal->geaendert_von,
 1047 
                    "updated_by"           => $portal->geaendert_von,
1046 
		    "created_at"           => $portal->erstellt_am,
 1048 
                    "created_at"           => $portal->erstellt_am,
1047 
		    "updated_at"           => $portal->geaendert_am,
 1049 
                    "updated_at"           => $portal->geaendert_am,
- 
 
 1050 
                ] );
- 
 
 1051 
            }
- 
 
 1052 
        }
- 
 
 1053 
 
- 
 
 1054 
        private function migrateSalesPortalItems()
- 
 
 1055 
        {
- 
 
 1056 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );
- 
 
 1057 
            $start = 0;
- 
 
 1058 
            $sql = "SELECT
- 
 
 1059 
                    MAX(id) start
- 
 
 1060 
                FROM
- 
 
 1061 
                    sales_portal_items
- 
 
 1062 
            ";
- 
 
 1063 
            $row = DB::connection( 'mysql' )->select( $sql );
- 
 
 1064 
            if ( $row[0]->start )
- 
 
 1065 
            {
- 
 
 1066 
                $start = $row[0]->start;
- 
 
 1067 
            }
- 
 
 1068 
            $sql = "SELECT
- 
 
 1069 
                    *
- 
 
 1070 
                FROM
- 
 
 1071 
                    artikel_vportale
- 
 
 1072 
                WHERE
- 
 
 1073 
                    id>" . $start . "
- 
 
 1074 
            ";
- 
 
 1075 
            $items = DB::connection( 'old' )->select( $sql );
- 
 
 1076 
            foreach ( $items as $item )
- 
 
 1077 
            {
- 
 
 1078 
                SalesPortalItem::factory()->create( [
- 
 
 1079 
                    "id"                              => $item->id,
- 
 
 1080 
                    "sales_portal_id"                 => $item->vportale_id,
- 
 
 1081 
                    "item_id"                         => $item->artikel_id,
- 
 
 1082 
                    "sales_portal_template_id"        => $item->template_id,
- 
 
 1083 
                    "sku"                             => $item->sku,
- 
 
 1084 
                    "additions"                       => $item->zusaetze,
- 
 
 1085 
                    "foreign_item_id"                 => $item->fremdartikel_id,
- 
 
 1086 
                    "name"                            => $item->name,
- 
 
 1087 
                    "autochange_name"                 => $item->autochange_name,
- 
 
 1088 
                    "name_bold"                       => $item->name_fett,
- 
 
 1089 
                    "highlight"                       => $item->highlight,
- 
 
 1090 
                    "sub_name"                        => $item->sub_name,
- 
 
 1091 
                    "manufacturer"                    => $item->hersteller,
- 
 
 1092 
                    "autochange_manufacturer"         => $item->autochange_hersteller,
- 
 
 1093 
                    "ean"                             => $item->ean,
- 
 
 1094 
                    "autochange_ean"                  => $item->autochange_ean,
- 
 
 1095 
                    "mpn"                             => $item->mpn,
- 
 
 1096 
                    "autochange_mpn"                  => $item->autochange_mpn,
- 
 
 1097 
                    "description"                     => $item->beschreibung,
- 
 
 1098 
                    "autochange_description"          => $item->autochange_beschreibung,
- 
 
 1099 
                    "description_addition"            => $item->beschreibung_zusazt,
- 
 
 1100 
                    "autochange_description_addition" => $item->autochange_beschreibung_zusazt,
- 
 
 1101 
                    "price"                           => $item->preis,
- 
 
 1102 
                    "autochange_price"                => $item->autochange_preis,
- 
 
 1103 
                    "currency"                        => $item->urrency,
- 
 
 1104 
                    "tax"                             => $item->tax,
- 
 
 1105 
                    "price_type"                      => $item->preisart,
- 
 
 1106 
                    "amount"                          => $item->menge,
- 
 
 1107 
                    "carrier"                         => $item->carrier,
- 
 
 1108 
                    "carrier_cost"                    => $item->carrier_cost,
- 
 
 1109 
                    "start"                           => $item->start,
- 
 
 1110 
                    "duration"                        => $item->dauer,
- 
 
 1111 
                    "category_1"                      => $item->kategorie_1,
- 
 
 1112 
                    "category_2"                      => $item->kategorie_2,
- 
 
 1113 
                    "category_3"                      => $item->kategorie_3,
- 
 
 1114 
                    "bp1"                             => $item->bp1,
- 
 
 1115 
                    "bp2"                             => $item->bp2,
- 
 
 1116 
                    "bp3"                             => $item->bp3,
- 
 
 1117 
                    "bp4"                             => $item->bp4,
- 
 
 1118 
                    "bp5"                             => $item->bp5,
- 
 
 1119 
                    "platin_search_1"                 => $item->platin_search_1,
- 
 
 1120 
                    "platin_search_2"                 => $item->platin_search_2,
- 
 
 1121 
                    "platin_search_3"                 => $item->platin_search_3,
- 
 
 1122 
                    "platin_search_4"                 => $item->platin_search_4,
- 
 
 1123 
                    "platin_search_5"                 => $item->platin_search_5,
- 
 
 1124 
                    "search_1"                        => $item->search_1,
- 
 
 1125 
                    "search_2"                        => $item->search_2,
- 
 
 1126 
                    "search_3"                        => $item->search_3,
- 
 
 1127 
                    "search_4"                        => $item->search_4,
- 
 
 1128 
                    "search_5"                        => $item->search_5,
- 
 
 1129 
                    "status"                          => $item->status,
- 
 
 1130 
                    "online_status"                   => $item->online_status,
- 
 
 1131 
                    "delivery_time"                   => $item->lieferzeit,
- 
 
 1132 
                    "pickup"                          => $item->pickup,
- 
 
 1133 
                    "last_feedback"                   => $item->last_feedback,
- 
 
 1134 
                    "created_by"                      => $item->erstellt_von,
- 
 
 1135 
                    "updated_by"                      => $item->geaendert_von,
- 
 
 1136 
                    "created_at"                      => $item->erstellt_am,
- 
 
 1137 
                    "updated_at"                      => $item->geaendert_am,
1048 
                ] );
 1138 
                ] );
1049 
            }
 1139 
            }
1050 
        }
 1140 
        }
1051 
    }
 1141 
    }