Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 258 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 258 Revision 260
Zeile 46... Zeile 46...
46
            Item::factory()->create( [
46
            Item::factory()->create( [
47
                "id"           => 1000,
47
                "id"           => 1000,
48
                "directory_id" => -3,
48
                "directory_id" => -3,
49
                "name"         => "Versandkosten",
49
                "name"         => "Versandkosten",
50
            ] );
50
            ] );
51
            $sql = '
-
 
52
                SELECT 
-
 
53
                    *
-
 
54
                FROM
-
 
55
                    artikel
-
 
56
                WHERE
-
 
57
                    father>=-1
-
 
58
            ';
-
 
59
            $dirs = DB::connection( 'old' )->select( $sql );
-
 
60
            foreach ( $dirs as $row )
-
 
61
            {
-
 
62
                $dir = new Item();
-
 
63
                $dir->id = $row->ID;
-
 
64
                $dir->directory_id = $row->Father;
-
 
65
                $dir->name = $row->kurzbezeichnung;
-
 
66
                $dir->status = $row->status;
-
 
67
                $dir->kennung = $row->kennung;
-
 
68
                $dir->description = $row->beschreibung;
-
 
69
                $dir->created_at = $row->erstellt_am;
-
 
70
                $dir->updated_at = $row->letzte_Aenderung_am;
-
 
71
                $dir->save();
-
 
72
            }
-
 
73
        }
51
        }
74
    }
52
    }