Subversion-Projekte lars-tiefland.laravel_shop

<?php

    namespace Database\Seeders;

    use App\Models\Directory;
    use App\Models\Item;
    use Illuminate\Database\Console\Seeds\WithoutModelEvents;
    use Illuminate\Database\Seeder;
    use Illuminate\Support\Facades\DB;
    use Illuminate\Support\Str;

    class ItemSeeder extends Seeder
    {
        /**
         * Run the database seeds.
         *
         * @return void
         */
        public function run(): void
        {
            Item::factory()->create( [
                "id"           => 1,
                "directory_id" => -1,
                "name"         => "nicht gefundener Artikel",
            ] );
            Item::factory()->create( [
                "id"           => 680,
                "directory_id" => -5,
                "name"         => "Gutschein Aktion",
            ] );
            Item::factory()->create( [
                "id"           => 681,
                "directory_id" => -5,
                "name"         => "Gutschein",
            ] );
            Item::factory()->create( [
                "id"           => 682,
                "directory_id" => -5,
                "name"         => "Gutschein",
            ] );
            Item::factory()->create( [
                "id"           => 999,
                "directory_id" => -1,
                "name"         => "Sonderartikel",
            ] );
            Item::factory()->create( [
                "id"           => 1000,
                "directory_id" => -3,
                "name"         => "Versandkosten",
            ] );
            $sql = '
                SELECT 
                    *
                FROM
                    artikel
                WHERE
                    father>-1
            ';
            $dirs = DB::connection( 'old' )->select( $sql );
            foreach ( $dirs as $row )
            {
                $dir = new Item();
                $dir->id = $row->ID;
                $dir->directory_id = $row->Father;
                $dir->name = $row->kurzbezeichnung;
                $dir->status = $row->status;
                $dir->kennung = $row->Kennung;
                $dir->description = $row->Beschreibung;
                $dir->created_at = $row->erstellt_am;
                $dir->updated_at = $row->letzte_Aenderung_am;
                $dir->save();
            }
        }
    }