Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 517 Revision 527
Zeile 13... Zeile 13...
13 
    use App\Models\PaymentMethod;
 13 
    use App\Models\PaymentMethod;
14 
    use App\Models\Price;
 14 
    use App\Models\Price;
15 
    use App\Models\ActionMedium;
 15 
    use App\Models\ActionMedium;
16 
    use App\Models\ItemMedium;
 16 
    use App\Models\ItemMedium;
17 
    use App\Models\DirectoryMedium;
 17 
    use App\Models\DirectoryMedium;
- 
 
 18 
    use App\Models\SalesPortal;
18 
    use App\Models\Shipping;
 19 
    use App\Models\Shipping;
19 
    use App\Models\ShippingGroup;
 20 
    use App\Models\ShippingGroup;
20 
    use App\Models\Shop;
 21 
    use App\Models\Shop;
21 
    use App\Models\User;
 22 
    use App\Models\User;
22 
    use Illuminate\Console\Command;
 23 
    use Illuminate\Console\Command;
Zeile 70... Zeile 71...
70 
            $this->migrateShops();
 71 
            $this->migrateShops();
71 
            $this->migrateOrderTypes();
 72 
            $this->migrateOrderTypes();
72 
            $this->migratePaymentMethods();
 73 
            $this->migratePaymentMethods();
73 
            $this->migrateShippingGroups();
 74 
            $this->migrateShippingGroups();
74 
            $this->migrateShippings();
 75 
            $this->migrateShippings();
- 
 
 76 
            $this->migrateSalesPortalTypes();
- 
 
 77 
            $this->migrateSalesPortals();
75 
            if ( $migrateActions )
 78 
            if ( $migrateActions )
76 
            {
 79 
            {
77 
                $this->migrateActions();
 80 
                $this->migrateActions();
78 
            }
 81 
            }
79 
            if ( $migrateDirs )
 82 
            if ( $migrateDirs )
Zeile 100... Zeile 103...
100 
                $this->migrateOrderItems();
 103 
                $this->migrateOrderItems();
101 
            }
 104 
            }
102 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
 105 
            $this->info( date( "d.m.Y H:i:s" ) . ": Verarbeitung beendet" );
103 
        }
 106 
        }
Zeile 104... Zeile 107...
104 
 
 107 
 
105 
        public function migrateMedia()
 108 
        private function migrateShops()
106 
        {
 109 
        {
107 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );
 110 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Shops" );
- 
 
 111 
            $start = 0;
108 
            $start = 0;
 112 
            $sql = "
109 
            $sql = "SELECT
 113 
                SELECT
110 
                    MAX(id) AS start
 114 
                    MAX(id) AS start
111 
                FROM
 115 
                FROM
112 
                    media
 116 
                    shops
113 
            ";
 117 
            ";
114 
            $row = DB::connection( "mysql" )->select( $sql );
 118 
            $row = DB::connection( 'mysql' )->select( $sql );
115 
            if ( $row[ 0 ]->start )
 119 
            if ( $row[0]->start )
116 
            {
 120 
            {
117 
                $start = $row[ 0 ]->start;
 121 
                $start = $row[0]->start;
118 
            }
 - 
 
119 
            $sql = "
 122 
            }
120 
                SELECT
 123 
            $sql = "SELECT
121 
                    *
 124 
                    *
122 
                FROM
 125 
                FROM
123 
                    medien
 126 
                    shops
124 
                WHERE
 127 
                WHERE
125 
                    id>" . $start . "
 128 
                    id>" . $start . "
126 
            ";
 129 
            ";
127 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
128 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 - 
 
129 
            $progressbar->start();
 130 
            $shops = DB::connection( 'old' )->select( $sql );
130 
            foreach ( $media as $medium )
 131 
            foreach ( $shops as $oldShop )
131 
            {
 132 
            {
132 
                $mediumDB = new Medium();
 133 
                $shop = new Shop();
133 
                $mediumDB->id = $medium->id;
 134 
                $shop->id = $oldShop->ID;
134 
                $mediumDB->name = $medium->name;
 135 
                $shop->name = $oldShop->Name;
135 
                $mediumDB->folder = $medium->folder;
 136 
                $shop->short = $oldShop->short;
136 
                $mediumDB->medium_type_id = $medium->typ;
 - 
 
137 
                $mediumDB->description = $medium->beschreibung;
 137 
                $shop->re_short = '';
138 
                if ( $medium->erstellt_am )
 138 
                if ( isset( $oldShop->re_short ) && $oldShop->re_short )
139 
                {
 139 
                {
140 
                    $mediumDB->created_at = date( "Y-m-d H:i:s", $medium->erstellt_am );
 140 
                    $shop->re_short = $oldShop->re_short;
141 
                }
 141 
                }
142 
                $ersteller = $medium->erstellt_von;
 - 
 
143 
                if ( !$ersteller )
 142 
                if ( isset( $oldShop->preisindex_ek ) && $oldShop->preisindex_ek )
144 
                {
 143 
                {
145 
                    $ersteller = "WebanOS Laravel Upgrade";
 144 
                    $shop->preisindex_ek = $oldShop->preisindex_ek;
146 
                }
 145 
                }
147 
                $bearbeiter = $medium->letzte_aenderung_von;
 146 
                $shop->ebay = $oldShop->ebay;
- 
 
 147 
                $shop->erfassung = $oldShop->erfassung;
148 
                if ( !$bearbeiter )
 148 
                if ( isset( $oldShop->status ) && $oldShop->status )
149 
                {
 149 
                {
150 
                    $bearbeiter = "WebanOS Laravel Upgrade";
 150 
                    $shop->status = $oldShop->status;
- 
 
 151 
                }
- 
 
 152 
                if ( isset( $oldShop->rang ) && $oldShop->rang )
- 
 
 153 
                {
- 
 
 154 
                    $shop->rank = $oldShop->rang;
- 
 
 155 
                }
- 
 
 156 
                $shop->klonziel = $oldShop->klonziel;
- 
 
 157 
                $shop->konroot = $oldShop->konroot;
- 
 
 158 
                if ( isset( $oldShop->home ) && $oldShop->home )
- 
 
 159 
                {
- 
 
 160 
                    $shop->home = $oldShop->home;
- 
 
 161 
                }
- 
 
 162 
                $shop->database = $oldShop->database;
- 
 
 163 
                $shop->domain = $oldShop->domain;
- 
 
 164 
                $shop->mail_server = $oldShop->mail_server;
- 
 
 165 
                $shop->mail_user = $oldShop->mail_user;
- 
 
 166 
                $shop->mail_password = $oldShop->mail_passwort;
- 
 
 167 
                $shop->save();
- 
 
 168 
            }
- 
 
 169 
 
- 
 
 170 
        }
- 
 
 171 
 
- 
 
 172 
        private function migrateOrderTypes()
- 
 
 173 
        {
- 
 
 174 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellarten" );
- 
 
 175 
            $start = 0;
- 
 
 176 
            $sql = "SELECT
- 
 
 177 
                    MAX(id) AS start
- 
 
 178 
                FROM
- 
 
 179 
                    order_types
- 
 
 180 
            ";
- 
 
 181 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 182 
            if ( $row[0]->start )
- 
 
 183 
            {
- 
 
 184 
                $start = $row[0]->start;
- 
 
 185 
            }
- 
 
 186 
            $sql = "SELECT
- 
 
 187 
                    *
- 
 
 188 
                FROM
- 
 
 189 
                    bestellart
- 
 
 190 
                WHERE
- 
 
 191 
                    id>" . $start . "
- 
 
 192 
            ";
- 
 
 193 
            $methods = DB::connection( 'old' )->select( $sql );
- 
 
 194 
            foreach ( $methods as $method )
- 
 
 195 
            {
- 
 
 196 
                OrderType::factory()->create( [
- 
 
 197 
                    "id"            => $method->id,
- 
 
 198 
                    "internal_name" => $method->rufname,
- 
 
 199 
                    "name"          => $method->name,
- 
 
 200 
                    "short"         => $method->short,
- 
 
 201 
                ] );
- 
 
 202 
            }
- 
 
 203 
        }
- 
 
 204 
 
- 
 
 205 
        private function migratePaymentMethods()
- 
 
 206 
        {
- 
 
 207 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );
- 
 
 208 
            $start = 0;
- 
 
 209 
            $sql = "SELECT
- 
 
 210 
                    MAX(id) AS start
- 
 
 211 
                FROM
- 
 
 212 
                    payment_methods
- 
 
 213 
            ";
- 
 
 214 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 215 
            if ( $row[0]->start )
- 
 
 216 
            {
- 
 
 217 
                $start = $row[0]->start;
- 
 
 218 
            }
- 
 
 219 
            $sql = "SELECT
- 
 
 220 
                    *
- 
 
 221 
                FROM
- 
 
 222 
                    zahlungsarten
- 
 
 223 
                WHERE
- 
 
 224 
                    id>" . $start . "
- 
 
 225 
            ";
- 
 
 226 
            $methods = DB::connection( 'old' )->select( $sql );
- 
 
 227 
            foreach ( $methods as $method )
- 
 
 228 
            {
- 
 
 229 
                PaymentMethod::factory()->create( [
- 
 
 230 
                    "id"            => $method->id,
- 
 
 231 
                    "name"          => $method->name,
- 
 
 232 
                    "discount"      => $method->abschlag,
- 
 
 233 
                    "internal_name" => $method->interner_name,
- 
 
 234 
                    "info_in_shop"  => $method->info_im_shop,
- 
 
 235 
                    "shipping_text" => $method->versandtextbaustein,
- 
 
 236 
                ] );
- 
 
 237 
            }
- 
 
 238 
        }
- 
 
 239 
 
- 
 
 240 
        private function migrateShippingGroups()
- 
 
 241 
        {
- 
 
 242 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );
- 
 
 243 
            $start = 0;
- 
 
 244 
            $sql = "SELECT
- 
 
 245 
                    MAX(id) AS start
- 
 
 246 
                FROM
- 
 
 247 
                    shipping_groups
- 
 
 248 
            ";
- 
 
 249 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 250 
            if ( $row[0]->start )
- 
 
 251 
            {
- 
 
 252 
                $start = $row[0]->start;
- 
 
 253 
            }
- 
 
 254 
            $sql = "SELECT
- 
 
 255 
                    *
- 
 
 256 
                FROM
- 
 
 257 
                    versandgruppen
- 
 
 258 
                WHERE
- 
 
 259 
                    id>" . $start . "
- 
 
 260 
            ";
- 
 
 261 
            $methods = DB::connection( 'old' )->select( $sql );
- 
 
 262 
            foreach ( $methods as $group )
- 
 
 263 
            {
- 
 
 264 
                ShippingGroup::factory()->create( [
- 
 
 265 
                    "id"            => $group->id,
- 
 
 266 
                    "name"          => $group->name,
- 
 
 267 
                    "conditions"    => $group->bedingungen,
- 
 
 268 
                    "icon"          => $group->icon,
- 
 
 269 
                    "rank"          => $group->rang,
- 
 
 270 
                    "shipping_text" => $group->versandtextbaustein,
- 
 
 271 
                    "created_by"    => $group->erstellt_von,
- 
 
 272 
                    "updated_by"    => $group->geaendert_von,
- 
 
 273 
                    "updated_at"    => $group->geaendert_am,
- 
 
 274 
                    "created_at"    => $group->erstellt_am,
- 
 
 275 
                ] );
- 
 
 276 
            }
- 
 
 277 
        }
- 
 
 278 
 
- 
 
 279 
        private function migrateShippings()
- 
 
 280 
        {
- 
 
 281 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );
- 
 
 282 
            $start = 0;
- 
 
 283 
            $sql = "SELECT
- 
 
 284 
                    MAX(id) AS start
- 
 
 285 
                FROM
- 
 
 286 
                    shippings
- 
 
 287 
            ";
- 
 
 288 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 289 
            if ( $row[0]->start )
- 
 
 290 
            {
- 
 
 291 
                $start = $row[0]->start;
- 
 
 292 
            }
- 
 
 293 
            $sql = "SELECT
- 
 
 294 
                    *
- 
 
 295 
                FROM
- 
 
 296 
                    versand
- 
 
 297 
                WHERE
- 
 
 298 
                    id>" . $start . "
- 
 
 299 
            ";
- 
 
 300 
            $methods = DB::connection( 'old' )->select( $sql );
- 
 
 301 
            foreach ( $methods as $group )
- 
 
 302 
            {
- 
 
 303 
                Shipping::factory()->create( [
- 
 
 304 
                    "id"                => $group->id,
- 
 
 305 
                    "rank"              => $group->rang,
- 
 
 306 
                    "shipping_group_id" => $group->versandgruppen_id,
- 
 
 307 
                    "name"              => $group->name,
- 
 
 308 
                    "info_shop"         => $group->info_shop,
- 
 
 309 
                    "info_mail"         => $group->info_mail,
- 
 
 310 
                    "info_internal"     => $group->info_intern,
- 
 
 311 
                    "island_shipping"   => $group->inselversand,
- 
 
 312 
                    "additions"         => $group->zusaetze,
- 
 
 313 
                    "status"            => $group->status,
- 
 
 314 
                    "price"             => $group->preis,
- 
 
 315 
                    "calc_weight_from"  => $group->berechnung_kg_von,
- 
 
 316 
                    "calc_weight_to"    => $group->berechnung_kg_bis,
- 
 
 317 
                    "calc_price_from"   => $group->berechnung_preis_von,
- 
 
 318 
                    "calc_price_to"     => $group->berechnung_preis_bis,
- 
 
 319 
                    "conditions"        => $group->bedingungen,
- 
 
 320 
                    "tax_rate"          => $group->steuersatz,
- 
 
 321 
                    "created_by"        => $group->erstellt_von,
- 
 
 322 
                    "updated_by"        => $group->geaendert_von,
- 
 
 323 
                    "updated_at"        => $group->geaendert_am,
- 
 
 324 
                    "created_at"        => $group->erstellt_am,
- 
 
 325 
                ] );
- 
 
 326 
            }
- 
 
 327 
        }
- 
 
 328 
 
- 
 
 329 
        private function migrateSalesPortalTypes()
- 
 
 330 
        {
- 
 
 331 
            $start = 0;
- 
 
 332 
            $sql = "SELECT
- 
 
 333 
                    MAX(id) start
- 
 
 334 
                FROM
- 
 
 335 
                    sales_portal_types
- 
 
 336 
            ";
- 
 
 337 
            $row = DB::connection( 'cms' )->select( $sql );
- 
 
 338 
            if ( $row[0]->start )
- 
 
 339 
            {
- 
 
 340 
                $start = $row[0]->start;
- 
 
 341 
            }
- 
 
 342 
            $sql = "SELECT
- 
 
 343 
                    *
- 
 
 344 
                FROM
- 
 
 345 
                    vportale_art
- 
 
 346 
                WHERE
- 
 
 347 
                    id>" . $start . "
- 
 
 348 
            ";
- 
 
 349 
            $portals = DB::connection( 'old' )->select( $sql );
- 
 
 350 
            foreach ( $portals as $portal )
- 
 
 351 
            {
- 
 
 352 
                SalesPortalType::factory()->create( [
- 
 
 353 
                    "id"                   => $portal->id,
- 
 
 354 
                    "type"                 => $portal->art,
- 
 
 355 
                    "name"                 => $portal->bezeichnung,
- 
 
 356 
                    "max_categories"       => $portal->max_categories,
- 
 
 357 
                    "min_category_depth"   => $portal->min_category_depth,
- 
 
 358 
                    "only_end_category"    => $portal->only_end_category,
- 
 
 359 
                    "script"               => $portal->skript,
- 
 
 360 
                    "script_folder"        => $portal->script_folder,
- 
 
 361 
                    "commit_possibilities" => $portal->commit_posibilities,
- 
 
 362 
                    "revokeable"           => $portal->stornierbar,
- 
 
 363 
                ] );
- 
 
 364 
            }
- 
 
 365 
        }
- 
 
 366 
 
- 
 
 367 
        private function migrateSalesPortals()
- 
 
 368 
        {
- 
 
 369 
            $start = 0;
- 
 
 370 
            $sql = "SELECT
- 
 
 371 
                    MAX(id) start
- 
 
 372 
                FROM
- 
 
 373 
                    sales_portals
- 
 
 374 
            ";
- 
 
 375 
            $row = DB::connection( 'mysql' )->select( $sql );
- 
 
 376 
            if ( $row[0]->start )
- 
 
 377 
            {
- 
 
 378 
                $start = $row[0]->start;
- 
 
 379 
            }
- 
 
 380 
            $sql = "SELECT
- 
 
 381 
                    *
- 
 
 382 
                FROM
- 
 
 383 
                    verkaufsportale
- 
 
 384 
                WHERE
- 
 
 385 
                    id>" . $start . "
- 
 
 386 
            ";
- 
 
 387 
            $portals = DB::connection( 'old' )->select( $sql );
- 
 
 388 
            foreach ( $portals as $portal )
- 
 
 389 
            {
- 
 
 390 
                SalesPortal::factory()->create( [
- 
 
 391 
 
- 
 
 392 
                ] );
- 
 
 393 
            }
- 
 
 394 
        }
- 
 
 395 
 
- 
 
 396 
        private function migrateActions()
- 
 
 397 
        {
- 
 
 398 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
- 
 
 399 
            $start = 0;
- 
 
 400 
            $sql = "SELECT
- 
 
 401 
                    MAX(id) AS start
- 
 
 402 
                FROM
- 
 
 403 
                    actions
- 
 
 404 
            ";
- 
 
 405 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 406 
            if ( $row[0]->start )
- 
 
 407 
            {
- 
 
 408 
                $start = $row[0]->start;
- 
 
 409 
            }
- 
 
 410 
            $sql = "
- 
 
 411 
                SELECT
- 
 
 412 
                    *
- 
 
 413 
                FROM
- 
 
 414 
                    Aktionen
- 
 
 415 
                WHERE
- 
 
 416 
                    id>" . $start . "
- 
 
 417 
            ";
- 
 
 418 
            $actions = DB::connection( 'old' )->select( $sql );
- 
 
 419 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
- 
 
 420 
            $progressbar->start();
- 
 
 421 
            foreach ( $actions as $action )
- 
 
 422 
            {
- 
 
 423 
                $actionDB = new Action();
- 
 
 424 
                $actionDB->id = $action->ID;
- 
 
 425 
                $actionDB->headline = $action->headline;
- 
 
 426 
                $actionDB->text = $action->text;
- 
 
 427 
                $actionDB->rang = $action->rang;
- 
 
 428 
                $actionDB->config = $action->config;
- 
 
 429 
                $actionDB->category = $action->Kategorie;
- 
 
 430 
                $actionDB->notes = $action->notizen;
- 
 
 431 
                $actionDB->valid_from = $action->von;
151 
                }
 432 
                $actionDB->valid_to = $action->bis;
152 
                $mediumDB->created_by = $ersteller;
 433 
                $actionDB->created_by = "WebanOS Laravel Upgrade";
153 
                $mediumDB->updated_by = $bearbeiter;
 434 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
154 
                $mediumDB->save();
 435 
                $actionDB->save();
155 
                $progressbar->advance();
 436 
                $progressbar->advance();
156 
            }
 437 
            }
157 
            $progressbar->finish();
 438 
            $progressbar->finish();
158 
            $progressbar->clear();
 439 
            $progressbar->clear();
Zeile 166... Zeile 447...
166 
                    MAX(id) AS start
 447 
                    MAX(id) AS start
167 
                FROM
 448 
                FROM
168 
                    directories
 449 
                    directories
169 
            ";
 450 
            ";
170 
            $row = DB::connection( "mysql" )->select( $sql );
 451 
            $row = DB::connection( "mysql" )->select( $sql );
171 
            if ( $row[ 0 ]->start )
 452 
            if ( $row[0]->start )
172 
            {
 453 
            {
173 
                $start = $row[ 0 ]->start;
 454 
                $start = $row[0]->start;
174 
            }
 455 
            }
175 
            $sql = '
 456 
            $sql = '
176 
                SELECT
457 
                SELECT
177 
                    *
 458 
                    *
178 
                FROM
 459 
                FROM
Zeile 213... Zeile 494...
213 
            }
 494 
            }
214 
            $progressbar->finish();
 495 
            $progressbar->finish();
215 
            $progressbar->clear();
 496 
            $progressbar->clear();
216 
        }
 497 
        }
Zeile 217... Zeile -...
217 
 
 - 
 
218 
        public function migrateDirMedia()
 - 
 
219 
        {
 - 
 
220 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
 - 
 
221 
            $start = 0;
 - 
 
222 
            $sql = "SELECT
 - 
 
223 
                    MAX(medium_id) AS start
 - 
 
224 
                FROM
 - 
 
225 
                    directory_media
 - 
 
226 
            ";
 - 
 
227 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
228 
            if ( $row[ 0 ]->start )
 - 
 
229 
            {
 - 
 
230 
                $start = $row[ 0 ]->start;
 - 
 
231 
            }
 - 
 
232 
            $sql = "SELECT
 - 
 
233 
                    *
 - 
 
234 
                FROM
 - 
 
235 
                    directory_medien
 - 
 
236 
                WHERE
 - 
 
237 
                    medien_id>" . $start . "
 - 
 
238 
            ";
 - 
 
239 
            $media = DB::connection( 'old' )->select( $sql );
 - 
 
240 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 - 
 
241 
            $progressbar->start();
 - 
 
242 
            foreach ( $media as $row )
 - 
 
243 
            {
 - 
 
244 
                $medium = new DirectoryMedium();
 - 
 
245 
                $medium->directory_id = $row->directory_id;
 - 
 
246 
                $medium->medium_id = $row->medien_id;
 - 
 
247 
                $medium->rank = $row->rang;
 - 
 
248 
                $medium->similar = $row->aehnlich;
 - 
 
249 
                $medium->created_at = $row->zugeordnet_am;
 - 
 
250 
                $medium->updated_at = $row->zugeordnet_am;
 - 
 
251 
                $medium->created_by = "WebanOS Laravel Upgrade";
 - 
 
252 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 - 
 
253 
                $medium->save();
 - 
 
254 
                $progressbar->advance();
 - 
 
255 
            }
 - 
 
256 
            $progressbar->finish();
 - 
 
257 
            $progressbar->clear();
 - 
 
258 
        }
 - 
 
259 
 
 498 
 
260 
        private function migrateItems()
 499 
        private function migrateItems()
261 
        {
 500 
        {
262 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
 501 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
263 
            $start = 0;
 502 
            $start = 0;
264 
            $sql = "SELECT
 503 
            $sql = "SELECT
265 
                    MAX(id) AS start
 504 
                    MAX(id) AS start
266 
                FROM
 505 
                FROM
267 
                    items
 506 
                    items
268 
            ";
 507 
            ";
269 
            $row = DB::connection( "mysql" )->select( $sql );
 508 
            $row = DB::connection( "mysql" )->select( $sql );
270 
            if ( $row[ 0 ]->start )
 509 
            if ( $row[0]->start )
271 
            {
 510 
            {
272 
                $start = $row[ 0 ]->start;
 511 
                $start = $row[0]->start;
273 
            }
 512 
            }
274 
            $sql = '
 513 
            $sql = '
275 
                SELECT
514 
                SELECT
276 
                    *
 515 
                    *
Zeile 318... Zeile 557...
318 
                    MAX(id) AS start
 557 
                    MAX(id) AS start
319 
                FROM
 558 
                FROM
320 
                    prices
 559 
                    prices
321 
            ";
 560 
            ";
322 
            $row = DB::connection( "mysql" )->select( $sql );
 561 
            $row = DB::connection( "mysql" )->select( $sql );
323 
            if ( $row[ 0 ]->start )
 562 
            if ( $row[0]->start )
324 
            {
 563 
            {
325 
                $start = $row[ 0 ]->start;
 564 
                $start = $row[0]->start;
326 
            }
 565 
            }
327 
            $sql = "
 566 
            $sql = "
328 
                SELECT
 567 
                SELECT
329 
                    p.*
 568 
                    p.*
330 
                FROM
 569 
                FROM
Zeile 358... Zeile 597...
358 
            }
 597 
            }
359 
            $progressbar->finish();
 598 
            $progressbar->finish();
360 
            $progressbar->clear();
 599 
            $progressbar->clear();
361 
        }
 600 
        }
Zeile 362... Zeile 601...
362 
 
 601 
 
363 
        public function migrateItemMedia()
 602 
        public function migrateMedia()
364 
        {
 603 
        {
365 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
 604 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );
366 
            $start = 0;
 605 
            $start = 0;
367 
            $sql = "SELECT
 606 
            $sql = "SELECT
368 
                    MAX(medium_id) AS start
 607 
                    MAX(id) AS start
- 
 
 608 
                FROM
- 
 
 609 
                    media
- 
 
 610 
            ";
- 
 
 611 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 612 
            if ( $row[0]->start )
- 
 
 613 
            {
- 
 
 614 
                $start = $row[0]->start;
- 
 
 615 
            }
- 
 
 616 
            $sql = "
- 
 
 617 
                SELECT
- 
 
 618 
                    *
- 
 
 619 
                FROM
- 
 
 620 
                    medien
- 
 
 621 
                WHERE
- 
 
 622 
                    id>" . $start . "
- 
 
 623 
            ";
- 
 
 624 
            $media = DB::connection( 'old' )->select( $sql );
- 
 
 625 
            $progressbar = $this->output->createProgressBar( count( $media ) );
- 
 
 626 
            $progressbar->start();
- 
 
 627 
            foreach ( $media as $medium )
- 
 
 628 
            {
- 
 
 629 
                $mediumDB = new Medium();
- 
 
 630 
                $mediumDB->id = $medium->id;
- 
 
 631 
                $mediumDB->name = $medium->name;
- 
 
 632 
                $mediumDB->folder = $medium->folder;
- 
 
 633 
                $mediumDB->medium_type_id = $medium->typ;
- 
 
 634 
                $mediumDB->description = $medium->beschreibung;
- 
 
 635 
                if ( $medium->erstellt_am )
- 
 
 636 
                {
- 
 
 637 
                    $mediumDB->created_at = date( "Y-m-d H:i:s", $medium->erstellt_am );
- 
 
 638 
                }
- 
 
 639 
                $ersteller = $medium->erstellt_von;
- 
 
 640 
                if ( !$ersteller )
- 
 
 641 
                {
- 
 
 642 
                    $ersteller = "WebanOS Laravel Upgrade";
- 
 
 643 
                }
- 
 
 644 
                $bearbeiter = $medium->letzte_aenderung_von;
- 
 
 645 
                if ( !$bearbeiter )
- 
 
 646 
                {
- 
 
 647 
                    $bearbeiter = "WebanOS Laravel Upgrade";
- 
 
 648 
                }
- 
 
 649 
                $mediumDB->created_by = $ersteller;
- 
 
 650 
                $mediumDB->updated_by = $bearbeiter;
- 
 
 651 
                $mediumDB->save();
- 
 
 652 
                $progressbar->advance();
- 
 
 653 
            }
- 
 
 654 
            $progressbar->finish();
- 
 
 655 
            $progressbar->clear();
- 
 
 656 
        }
- 
 
 657 
 
- 
 
 658 
        public function migrateActionMedia()
- 
 
 659 
        {
- 
 
 660 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
- 
 
 661 
            $start = 0;
- 
 
 662 
            $sql = "SELECT
- 
 
 663 
                    MAX(id) AS start
369 
                FROM
 664 
                FROM
370 
                    item_media
 665 
                    action_media
371 
            ";
 666 
            ";
372 
            $row = DB::connection( "mysql" )->select( $sql );
 667 
            $row = DB::connection( "mysql" )->select( $sql );
373 
            if ( $row[ 0 ]->start )
 668 
            if ( $row[0]->start )
374 
            {
 669 
            {
375 
                $start = $row[ 0 ]->start;
 670 
                $start = $row[0]->start;
376 
            }
 671 
            }
377 
            $sql = "SELECT
 672 
            $sql = "SELECT
378 
                    *
 673 
                    *
379 
                FROM
 674 
                FROM
380 
                    artikel_medien
 675 
                    aktionen_medien
381 
                WHERE
 676 
                WHERE
382 
                    medien_id>" . $start . "
 677 
                    id>" . $start . "
383 
            ";
 678 
            ";
384 
            $media = DB::connection( 'old' )->select( $sql );
 679 
            $media = DB::connection( 'old' )->select( $sql );
385 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 680 
            $progressbar = $this->output->createProgressBar( count( $media ) );
386 
            $progressbar->start();
 681 
            $progressbar->start();
387 
            foreach ( $media as $row )
 682 
            foreach ( $media as $row )
388 
            {
 683 
            {
389 
                $medium = new ItemMedium();
 684 
                $medium = new ActionMedium();
390 
                $medium->item_id = $row->artikel_id;
 685 
                $medium->action_id = $row->aktionen_id;
391 
                $medium->medium_id = $row->medien_id;
 686 
                $medium->medium_id = $row->medien_id;
392 
                $medium->rank = $row->rang;
 - 
 
393 
                $medium->similar = $row->aehnlich;
 - 
 
394 
                $medium->created_at = $row->zugeordnet_am;
 - 
 
395 
                $medium->updated_at = $row->zugeordnet_am;
 687 
                $medium->rank = $row->rang;
396 
                $medium->created_by = "WebanOS Laravel Upgrade";
 688 
                $medium->created_by = "WebanOS Laravel Upgrade";
397 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 689 
                $medium->updated_by = "WebanOS Laravel Upgrade";
398 
                $medium->save();
 690 
                $medium->save();
399 
                $progressbar->advance();
 691 
                $progressbar->advance();
400 
            }
 692 
            }
401 
            $progressbar->finish();
 693 
            $progressbar->finish();
402 
            $progressbar->clear();
 694 
            $progressbar->clear();
Zeile 403... Zeile 695...
403 
        }
 695 
        }
404 
 
 696 
 
405 
        private function migrateActions()
 697 
        public function migrateDirMedia()
406 
        {
 698 
        {
407 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
 699 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
408 
            $start = 0;
 700 
            $start = 0;
409 
            $sql = "SELECT
 701 
            $sql = "SELECT
410 
                    MAX(id) AS start
 702 
                    MAX(medium_id) AS start
411 
                FROM
 703 
                FROM
412 
                    actions
 704 
                    directory_media
413 
            ";
 705 
            ";
414 
            $row = DB::connection( "mysql" )->select( $sql );
 706 
            $row = DB::connection( "mysql" )->select( $sql );
415 
            if ( $row[ 0 ]->start )
 707 
            if ( $row[0]->start )
416 
            {
 708 
            {
417 
                $start = $row[ 0 ]->start;
 - 
 
418 
            }
 709 
                $start = $row[0]->start;
419 
            $sql = "
 710 
            }
420 
                SELECT
 711 
            $sql = "SELECT
421 
                    *
 712 
                    *
422 
                FROM
 713 
                FROM
423 
                    Aktionen
 714 
                    directory_medien
424 
                WHERE
 715 
                WHERE
425 
                    id>" . $start . "
 716 
                    medien_id>" . $start . "
426 
            ";
 717 
            ";
427 
            $actions = DB::connection( 'old' )->select( $sql );
 718 
            $media = DB::connection( 'old' )->select( $sql );
428 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
 719 
            $progressbar = $this->output->createProgressBar( count( $media ) );
429 
            $progressbar->start();
 720 
            $progressbar->start();
430 
            foreach ( $actions as $action )
 721 
            foreach ( $media as $row )
431 
            {
 722 
            {
432 
                $actionDB = new Action();
 723 
                $medium = new DirectoryMedium();
433 
                $actionDB->id = $action->ID;
 - 
 
434 
                $actionDB->headline = $action->headline;
 724 
                $medium->directory_id = $row->directory_id;
435 
                $actionDB->text = $action->text;
 725 
                $medium->medium_id = $row->medien_id;
436 
                $actionDB->rang = $action->rang;
 726 
                $medium->rank = $row->rang;
437 
                $actionDB->config = $action->config;
 - 
 
438 
                $actionDB->category = $action->Kategorie;
 - 
 
439 
                $actionDB->notes = $action->notizen;
 727 
                $medium->similar = $row->aehnlich;
440 
                $actionDB->valid_from = $action->von;
 728 
                $medium->created_at = $row->zugeordnet_am;
441 
                $actionDB->valid_to = $action->bis;
 729 
                $medium->updated_at = $row->zugeordnet_am;
442 
                $actionDB->created_by = "WebanOS Laravel Upgrade";
 730 
                $medium->created_by = "WebanOS Laravel Upgrade";
443 
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
 731 
                $medium->updated_by = "WebanOS Laravel Upgrade";
444 
                $actionDB->save();
 732 
                $medium->save();
445 
                $progressbar->advance();
 733 
                $progressbar->advance();
446 
            }
 734 
            }
447 
            $progressbar->finish();
 735 
            $progressbar->finish();
Zeile 448... Zeile 736...
448 
            $progressbar->clear();
 736 
            $progressbar->clear();
449 
        }
 737 
        }
450 
 
 738 
 
451 
        public function migrateActionMedia()
 739 
        public function migrateItemMedia()
452 
        {
 740 
        {
453 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
 741 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
454 
            $start = 0;
 742 
            $start = 0;
455 
            $sql = "SELECT
 743 
            $sql = "SELECT
456 
                    MAX(id) AS start
 744 
                    MAX(medium_id) AS start
457 
                FROM
 745 
                FROM
458 
                    action_media
 746 
                    item_media
459 
            ";
 747 
            ";
460 
            $row = DB::connection( "mysql" )->select( $sql );
 748 
            $row = DB::connection( "mysql" )->select( $sql );
461 
            if ( $row[ 0 ]->start )
 749 
            if ( $row[0]->start )
462 
            {
 750 
            {
463 
                $start = $row[ 0 ]->start;
 751 
                $start = $row[0]->start;
464 
            }
 752 
            }
465 
            $sql = "SELECT
 753 
            $sql = "SELECT
466 
                    *
 754 
                    *
467 
                FROM
 755 
                FROM
468 
                    aktionen_medien
 756 
                    artikel_medien
469 
                WHERE
 757 
                WHERE
470 
                    id>" . $start . "
 758 
                    medien_id>" . $start . "
471 
            ";
 759 
            ";
472 
            $media = DB::connection( 'old' )->select( $sql );
 760 
            $media = DB::connection( 'old' )->select( $sql );
473 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 761 
            $progressbar = $this->output->createProgressBar( count( $media ) );
474 
            $progressbar->start();
 762 
            $progressbar->start();
475 
            foreach ( $media as $row )
 763 
            foreach ( $media as $row )
476 
            {
 764 
            {
477 
                $medium = new ActionMedium();
 765 
                $medium = new ItemMedium();
- 
 
 766 
                $medium->item_id = $row->artikel_id;
- 
 
 767 
                $medium->medium_id = $row->medien_id;
- 
 
 768 
                $medium->rank = $row->rang;
478 
                $medium->action_id = $row->aktionen_id;
 769 
                $medium->similar = $row->aehnlich;
479 
                $medium->medium_id = $row->medien_id;
 770 
                $medium->created_at = $row->zugeordnet_am;
480 
                $medium->rank = $row->rang;
 771 
                $medium->updated_at = $row->zugeordnet_am;
481 
                $medium->created_by = "WebanOS Laravel Upgrade";
 772 
                $medium->created_by = "WebanOS Laravel Upgrade";
482 
                $medium->updated_by = "WebanOS Laravel Upgrade";
 773 
                $medium->updated_by = "WebanOS Laravel Upgrade";
Zeile 495... Zeile 786...
495 
                    MAX(id) AS start
 786 
                    MAX(id) AS start
496 
                FROM
 787 
                FROM
497 
                    users
 788 
                    users
498 
            ";
 789 
            ";
499 
            $row = DB::connection( "order" )->select( $sql );
 790 
            $row = DB::connection( "order" )->select( $sql );
500 
            if ( $row[ 0 ]->start )
 791 
            if ( $row[0]->start )
501 
            {
 792 
            {
502 
                $start = $row[ 0 ]->start;
 793 
                $start = $row[0]->start;
503 
            }
 794 
            }
504 
            $sql = "SELECT
 795 
            $sql = "SELECT
505 
                    *
 796 
                    *
506 
                FROM
 797 
                FROM
507 
                    Logins
 798 
                    Logins
Zeile 554... Zeile 845...
554 
                    MAX(id) AS start
 845 
                    MAX(id) AS start
555 
                FROM
 846 
                FROM
556 
                    " . $table . "
 847 
                    " . $table . "
557 
            ";
 848 
            ";
558 
            $row = DB::connection( "order" )->select( $sql );
 849 
            $row = DB::connection( "order" )->select( $sql );
559 
            if ( $row[ 0 ]->start )
 850 
            if ( $row[0]->start )
560 
            {
 851 
            {
561 
                $start = $row[ 0 ]->start;
 852 
                $start = $row[0]->start;
562 
            }
 853 
            }
563 
            $sql = "SELECT
 854 
            $sql = "SELECT
564 
                    *
 855 
                    *
565 
                FROM
 856 
                FROM
566 
                    " . $oldTable . "
 857 
                    " . $oldTable . "
Zeile 630... Zeile 921...
630 
                    MAX(id) AS start
 921 
                    MAX(id) AS start
631 
                FROM
 922 
                FROM
632 
                    orders
 923 
                    orders
633 
            ";
 924 
            ";
634 
            $row = DB::connection( "order" )->select( $sql );
 925 
            $row = DB::connection( "order" )->select( $sql );
635 
            if ( $row[ 0 ]->start )
 926 
            if ( $row[0]->start )
636 
            {
 927 
            {
637 
                $start = $row[ 0 ]->start;
 928 
                $start = $row[0]->start;
638 
            }
 929 
            }
639 
            $sql = "SELECT
 930 
            $sql = "SELECT
640 
                    *
 931 
                    *
641 
                FROM
 932 
                FROM
642 
                    Bestellung
 933 
                    Bestellung
Zeile 697... Zeile 988...
697 
                    MAX(id) AS start
 988 
                    MAX(id) AS start
698 
                FROM
 989 
                FROM
699 
                    order_items
 990 
                    order_items
700 
            ";
 991 
            ";
701 
            $row = DB::connection( "order" )->select( $sql );
 992 
            $row = DB::connection( "order" )->select( $sql );
702 
            if ( $row[ 0 ]->start )
 993 
            if ( $row[0]->start )
703 
            {
 994 
            {
704 
                $start = $row[ 0 ]->start;
 995 
                $start = $row[0]->start;
705 
            }
 996 
            }
706 
            $sql = "SELECT
 997 
            $sql = "SELECT
707 
                    *
 998 
                    *
708 
                FROM
 999 
                FROM
709 
                    artikel_to_Bestellung
 1000 
                    artikel_to_Bestellung
Zeile 718... Zeile 1009...
718 
                $progressbar->advance();
 1009 
                $progressbar->advance();
719 
            }
 1010 
            }
720 
            $progressbar->finish();
 1011 
            $progressbar->finish();
721 
            $progressbar->clear();
 1012 
            $progressbar->clear();
722 
        }
 1013 
        }
723 
 
 - 
 
724 
        private function migrateShops()
 - 
 
725 
        {
 - 
 
726 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Shops" );
 - 
 
727 
            $start = 0;
 - 
 
728 
            $sql = "
 - 
 
729 
                SELECT
 - 
 
730 
                    MAX(id) AS start
 - 
 
731 
                FROM
 - 
 
732 
                    shops
 - 
 
733 
            ";
 - 
 
734 
            $row = DB::connection( 'mysql' )->select( $sql );
 - 
 
735 
            if ( $row[ 0 ]->start )
 - 
 
736 
            {
 - 
 
737 
                $start = $row[ 0 ]->start;
 - 
 
738 
            }
 - 
 
739 
            $sql = "SELECT
 - 
 
740 
                    *
 - 
 
741 
                FROM
 - 
 
742 
                    shops
 - 
 
743 
                WHERE
 - 
 
744 
                    id>" . $start . "
 - 
 
745 
            ";
 - 
 
746 
            $shops = DB::connection( 'old' )->select( $sql );
 - 
 
747 
            foreach ( $shops as $oldShop )
 - 
 
748 
            {
 - 
 
749 
                $shop = new Shop();
 - 
 
750 
                $shop->id = $oldShop->ID;
 - 
 
751 
                $shop->name = $oldShop->Name;
 - 
 
752 
                $shop->short = $oldShop->short;
 - 
 
753 
                $shop->re_short = '';
 - 
 
754 
                if ( isset( $oldShop->re_short ) && $oldShop->re_short )
 - 
 
755 
                {
 - 
 
756 
                    $shop->re_short = $oldShop->re_short;
 - 
 
757 
                }
 - 
 
758 
                if ( isset( $oldShop->preisindex_ek ) && $oldShop->preisindex_ek )
 - 
 
759 
                {
 - 
 
760 
                    $shop->preisindex_ek = $oldShop->preisindex_ek;
 - 
 
761 
                }
 - 
 
762 
                $shop->ebay = $oldShop->ebay;
 - 
 
763 
                $shop->erfassung = $oldShop->erfassung;
 - 
 
764 
                if ( isset( $oldShop->status ) && $oldShop->status )
 - 
 
765 
                {
 - 
 
766 
                    $shop->status = $oldShop->status;
 - 
 
767 
                }
 - 
 
768 
                if ( isset( $oldShop->rang ) && $oldShop->rang )
 - 
 
769 
                {
 - 
 
770 
                    $shop->rank = $oldShop->rang;
 - 
 
771 
                }
 - 
 
772 
                $shop->klonziel = $oldShop->klonziel;
 - 
 
773 
                $shop->konroot = $oldShop->konroot;
 - 
 
774 
                if ( isset( $oldShop->home ) && $oldShop->home )
 - 
 
775 
                {
 - 
 
776 
                    $shop->home = $oldShop->home;
 - 
 
777 
                }
 - 
 
778 
                $shop->database = $oldShop->database;
 - 
 
779 
                $shop->domain = $oldShop->domain;
 - 
 
780 
                $shop->mail_server = $oldShop->mail_server;
 - 
 
781 
                $shop->mail_user = $oldShop->mail_user;
 - 
 
782 
                $shop->mail_password = $oldShop->mail_passwort;
 - 
 
783 
                $shop->save();
 - 
 
784 
            }
 - 
 
785 
 
 - 
 
786 
        }
 - 
 
787 
 
 - 
 
788 
        private function migratePaymentMethods()
 - 
 
789 
        {
 - 
 
790 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );
 - 
 
791 
            $start = 0;
 - 
 
792 
            $sql = "SELECT
 - 
 
793 
                    MAX(id) AS start
 - 
 
794 
                FROM
 - 
 
795 
                    payment_methods
 - 
 
796 
            ";
 - 
 
797 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
798 
            if ( $row[ 0 ]->start )
 - 
 
799 
            {
 - 
 
800 
                $start = $row[ 0 ]->start;
 - 
 
801 
            }
 - 
 
802 
            $sql = "SELECT
 - 
 
803 
                    *
 - 
 
804 
                FROM
 - 
 
805 
                    zahlungsarten
 - 
 
806 
                WHERE
 - 
 
807 
                    id>" . $start . "
 - 
 
808 
            ";
 - 
 
809 
            $methods = DB::connection( 'old' )->select( $sql );
 - 
 
810 
            foreach ( $methods as $method )
 - 
 
811 
            {
 - 
 
812 
                PaymentMethod::factory()->create( [
 - 
 
813 
                    "id"            => $method->id,
 - 
 
814 
                    "name"          => $method->name,
 - 
 
815 
                    "discount"      => $method->abschlag,
 - 
 
816 
                    "internal_name" => $method->interner_name,
 - 
 
817 
                    "info_in_shop"  => $method->info_im_shop,
 - 
 
818 
                    "shipping_text" => $method->versandtextbaustein,
 - 
 
819 
                ] );
 - 
 
820 
            }
 - 
 
821 
        }
 - 
 
822 
 
 - 
 
823 
        private function migrateOrderTypes()
 - 
 
824 
        {
 - 
 
825 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Bestellarten" );
 - 
 
826 
            $start = 0;
 - 
 
827 
            $sql = "SELECT
 - 
 
828 
                    MAX(id) AS start
 - 
 
829 
                FROM
 - 
 
830 
                    order_types
 - 
 
831 
            ";
 - 
 
832 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
833 
            if ( $row[ 0 ]->start )
 - 
 
834 
            {
 - 
 
835 
                $start = $row[ 0 ]->start;
 - 
 
836 
            }
 - 
 
837 
            $sql = "SELECT
 - 
 
838 
                    *
 - 
 
839 
                FROM
 - 
 
840 
                    bestellart
 - 
 
841 
                WHERE
 - 
 
842 
                    id>" . $start . "
 - 
 
843 
            ";
 - 
 
844 
            $methods = DB::connection( 'old' )->select( $sql );
 - 
 
845 
            foreach ( $methods as $method )
 - 
 
846 
            {
 - 
 
847 
                OrderType::factory()->create( [
 - 
 
848 
                    "id"            => $method->id,
 - 
 
849 
                    "internal_name" => $method->rufname,
 - 
 
850 
                    "name"          => $method->name,
 - 
 
851 
                    "short"         => $method->short,
 - 
 
852 
                ] );
 - 
 
853 
            }
 - 
 
854 
        }
 - 
 
855 
 
 - 
 
856 
        private function migrateShippingGroups()
 - 
 
857 
        {
 - 
 
858 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandgruppen" );
 - 
 
859 
            $start = 0;
 - 
 
860 
            $sql = "SELECT
 - 
 
861 
                    MAX(id) AS start
 - 
 
862 
                FROM
 - 
 
863 
                    shipping_groups
 - 
 
864 
            ";
 - 
 
865 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
866 
            if ( $row[ 0 ]->start )
 - 
 
867 
            {
 - 
 
868 
                $start = $row[ 0 ]->start;
 - 
 
869 
            }
 - 
 
870 
            $sql = "SELECT
 - 
 
871 
                    *
 - 
 
872 
                FROM
 - 
 
873 
                    versandgruppen
 - 
 
874 
                WHERE
 - 
 
875 
                    id>" . $start . "
 - 
 
876 
            ";
 - 
 
877 
            $methods = DB::connection( 'old' )->select( $sql );
 - 
 
878 
            foreach ( $methods as $group )
 - 
 
879 
            {
 - 
 
880 
                ShippingGroup::factory()->create( [
 - 
 
881 
                    "id"            => $group->id,
 - 
 
882 
                    "name"          => $group->name,
 - 
 
883 
                    "conditions"    => $group->bedingungen,
 - 
 
884 
                    "icon"          => $group->icon,
 - 
 
885 
                    "rank"          => $group->rang,
 - 
 
886 
                    "shipping_text" => $group->versandtextbaustein,
 - 
 
887 
                    "created_by"    => $group->erstellt_von,
 - 
 
888 
                    "updated_by"    => $group->geaendert_von,
 - 
 
889 
                    "updated_at"    => $group->geaendert_am,
 - 
 
890 
                    "created_at"    => $group->erstellt_am,
 - 
 
891 
                ] );
 - 
 
892 
            }
 - 
 
893 
        }
 - 
 
894 
 
 - 
 
895 
        private function migrateShippings()
 - 
 
896 
        {
 - 
 
897 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Versandoptionen" );
 - 
 
898 
            $start = 0;
 - 
 
899 
            $sql = "SELECT
 - 
 
900 
                    MAX(id) AS start
 - 
 
901 
                FROM
 - 
 
902 
                    shippings
 - 
 
903 
            ";
 - 
 
904 
            $row = DB::connection( "mysql" )->select( $sql );
 - 
 
905 
            if ( $row[ 0 ]->start )
 - 
 
906 
            {
 - 
 
907 
                $start = $row[ 0 ]->start;
 - 
 
908 
            }
 - 
 
909 
            $sql = "SELECT
 - 
 
910 
                    *
 - 
 
911 
                FROM
 - 
 
912 
                    versand
 - 
 
913 
                WHERE
 - 
 
914 
                    id>" . $start . "
 - 
 
915 
            ";
 - 
 
916 
            $methods = DB::connection( 'old' )->select( $sql );
 - 
 
917 
            foreach ( $methods as $group )
 - 
 
918 
            {
 - 
 
919 
                Shipping::factory()->create( [
 - 
 
920 
                    "id"                => $group->id,
 - 
 
921 
                    "rank"              => $group->rang,
 - 
 
922 
                    "shipping_group_id" => $group->versandgruppen_id,
 - 
 
923 
                    "name"              => $group->name,
 - 
 
924 
                    "info_shop"         => $group->info_shop,
 - 
 
925 
                    "info_mail"         => $group->info_mail,
 - 
 
926 
                    "info_internal"     => $group->info_intern,
 - 
 
927 
                    "island_shipping"   => $group->inselversand,
 - 
 
928 
                    "additions"         => $group->zusaetze,
 - 
 
929 
                    "status"            => $group->status,
 - 
 
930 
                    "price"             => $group->preis,
 - 
 
931 
                    "calc_weight_from"  => $group->berechnung_kg_von,
 - 
 
932 
                    "calc_weight_to"    => $group->berechnung_kg_bis,
 - 
 
933 
                    "calc_price_from"   => $group->berechnung_preis_von,
 - 
 
934 
                    "calc_price_to"     => $group->berechnung_preis_bis,
 - 
 
935 
                    "conditions"        => $group->bedingungen,
 - 
 
936 
                    "tax_rate"          => $group->steuersatz,
 - 
 
937 
                    "created_by"        => $group->erstellt_von,
 - 
 
938 
                    "updated_by"        => $group->geaendert_von,
 - 
 
939 
                    "updated_at"        => $group->geaendert_am,
 - 
 
940 
                    "created_at"        => $group->erstellt_am,
 - 
 
941 
                ] );
 - 
 
942 
            }
 - 
 
943 
        }
 - 
 
944 
    }
 1014 
    }