Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 204 Revision 257
Zeile 3... Zeile 3...
3 
    namespace Database\Seeders;
 3 
    namespace Database\Seeders;
Zeile 4... Zeile 4...
4 
 
 4 
 
5 
    use App\Models\Price;
 5 
    use App\Models\Price;
6 
    use Illuminate\Database\Console\Seeds\WithoutModelEvents;
 6 
    use Illuminate\Database\Console\Seeds\WithoutModelEvents;
- 
 
 7 
    use Illuminate\Database\Seeder;
Zeile 7... Zeile 8...
7 
    use Illuminate\Database\Seeder;
 8 
    use Illuminate\Support\Facades\DB;
8 
 
 9 
 
9 
    class PriceSeeder extends Seeder
 10 
    class PriceSeeder extends Seeder
10 
    {
 11 
    {
11 
        /**
 12 
        /**
12 
         * Run the database seeds.
 13 
         * Run the database seeds.
13 
         *
 14 
         *
14 
         * @return void
 15 
         * @return void
15 
         */
 16 
         */
16 
        public function run(): void
 17 
        public function run(): void
17 
        {
 18 
        {
18 
            Price::factory()->create( [
 19 
            /*Price::factory()->create( [
19 
                "item_id"     => 115000,
 20 
                "item_id"     => 115000,
20 
                "preis_index" => 1,
 21 
                "preis_index" => 1,
21 
                "preis"       => 10.00,
 22 
                "preis"       => 10.00,
Zeile 42... Zeile 43...
42 
            Price::factory()->create( [
 43 
            Price::factory()->create( [
43 
                "item_id"     => 115005,
 44 
                "item_id"     => 115005,
44 
                "preis_index" => 1,
 45 
                "preis_index" => 1,
45 
                "preis"       => 50.00,
 46 
                "preis"       => 50.00,
46 
                "staffel"     => 'a:5:{s:5:"preis";a:1:{i:0;i:50;}s:5:"menge";a:1:{i:0;s:1:"0";}s:8:"preisneu";a:1:{i:0;i:0;}s:8:"datefrom";a:1:{i:0;s:0:"";}s:6:"dateto";a:1:{i:0;s:0:"";}}'
 47 
                "staffel"     => 'a:5:{s:5:"preis";a:1:{i:0;i:50;}s:5:"menge";a:1:{i:0;s:1:"0";}s:8:"preisneu";a:1:{i:0;i:0;}s:8:"datefrom";a:1:{i:0;s:0:"";}s:6:"dateto";a:1:{i:0;s:0:"";}}'
47 
            ] );
 48 
            ] );*/
- 
 
 49 
            $sql = "
- 
 
 50 
                SELECT
- 
 
 51 
                    *
- 
 
 52 
                FROM
- 
 
 53 
                    preise
- 
 
 54 
            ";
- 
 
 55 
            $prices = DB::connection( 'old' )->select( $sql );
- 
 
 56 
            foreach ( $prices as $price )
- 
 
 57 
            {
- 
 
 58 
                Price::factory()->createQuietly( [
- 
 
 59 
                    "item_id"     => $price->artikel_id,
- 
 
 60 
                    "preis_index" => $price->preis_index,
- 
 
 61 
                    "preis"       => $price->preis,
- 
 
 62 
                    "staffel"     => $price->staffel,
- 
 
 63 
                    "created_at"  => $price->geaendert_am,
- 
 
 64 
                    "updated_at"  => $price->geaendert_am
- 
 
 65 
                ] );
- 
 
 66 
            }
- 
 
 67 
 
48 
        }
 68 
        }
49 
    }
 69 
    }