Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 578 Revision 580
Zeile 4... Zeile 4...
4 
 
 4 
 
5 
    use App\Models\Address;
 5 
    use App\Models\Address;
6 
    use App\Models\Directory;
 6 
    use App\Models\Directory;
7 
    use App\Models\Item;
 7 
    use App\Models\Item;
- 
 
 8 
    use App\Models\Action;
8 
    use App\Models\Action;
 9 
    use App\Models\Manufacturer;
9 
    use App\Models\Medium;
 10 
    use App\Models\Medium;
10 
    use App\Models\Order;
 11 
    use App\Models\Order;
11 
    use App\Models\OrderAddress;
 12 
    use App\Models\OrderAddress;
12 
    use App\Models\OrderType;
 13 
    use App\Models\OrderType;
Zeile 55... Zeile 56...
55 
            $this->migrateShops();
 56 
            $this->migrateShops();
56 
            $this->migrateOrderTypes();
 57 
            $this->migrateOrderTypes();
57 
            $this->migratePaymentMethods();
 58 
            $this->migratePaymentMethods();
58 
            $this->migrateShippingGroups();
 59 
            $this->migrateShippingGroups();
59 
            $this->migrateShippings();
 60 
            $this->migrateShippings();
- 
 
 61 
            $this->migrateManufacturers();
60 
            $this->migrateActions();
 62 
            $this->migrateActions();
61 
            $this->migrateDirs();
 63 
            $this->migrateDirs();
62 
            $this->migrateItems();
 64 
            $this->migrateItems();
63 
            if ( env( 'site' ) == env( 'shop' ) )
 65 
            if ( env( 'site' ) == env( 'shop' ) )
64 
            {
 66 
            {
Zeile 1207... Zeile 1209...
1207 
                    id>" . $start . "
 1209 
                    id>" . $start . "
1208 
            ";
 1210 
            ";
1209 
            $agencies = DB::connection( 'old' )->select( $sql );
 1211 
            $agencies = DB::connection( 'old' )->select( $sql );
1210 
            $progressbar = $this->output->createProgressBar( count( $agencies ) );
 1212 
            $progressbar = $this->output->createProgressBar( count( $agencies ) );
1211 
            $progressbar->start();
 1213 
            $progressbar->start();
1212 
            foreach ( $agencies as $agency )
 1214 
            foreach ( $agencies as $manufacturer )
1213 
            {
 1215 
            {
1214 
                $letzter_Abruf_am = $agency->letzter_Abruf_am;
 1216 
                $letzter_Abruf_am = $manufacturer->letzter_Abruf_am;
1215 
                if ( $letzter_Abruf_am == "0000-00-00 00:00:00" )
 1217 
                if ( $letzter_Abruf_am == "0000-00-00 00:00:00" )
1216 
                {
 1218 
                {
1217 
                    $letzter_Abruf_am = null;
 1219 
                    $letzter_Abruf_am = null;
1218 
                }
 1220 
                }
1219 
                $letzte_Aktualisierung_am = $agency->letzte_Aktualisierung_am;
 1221 
                $letzte_Aktualisierung_am = $manufacturer->letzte_Aktualisierung_am;
1220 
                if ( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
 1222 
                if ( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
1221 
                {
 1223 
                {
1222 
                    $letzte_Aktualisierung_am = null;
 1224 
                    $letzte_Aktualisierung_am = null;
1223 
                }
 1225 
                }
1224 
                PriceAgency::factory()->create( [
 1226 
                PriceAgency::factory()->create( [
1225 
                    "id"                   => $agency->ID,
 1227 
                    "id"                   => $manufacturer->ID,
1226 
                    "shop_id"              => $agency->shops_ID,
 1228 
                    "shop_id"              => $manufacturer->shops_ID,
1227 
                    "name"                 => $agency->Titel,
 1229 
                    "name"                 => $manufacturer->Titel,
1228 
                    "logo_url"             => $agency->logo_url,
 1230 
                    "logo_url"             => $manufacturer->logo_url,
1229 
                    "home_url"             => $agency->home_url,
 1231 
                    "home_url"             => $manufacturer->home_url,
1230 
                    "csv_url"              => $agency->csv_url,
 1232 
                    "csv_url"              => $manufacturer->csv_url,
1231 
                    "trigger_url"          => $agency->trigger_URL,
 1233 
                    "trigger_url"          => $manufacturer->trigger_URL,
1232 
                    "voting_url"           => $agency->bewertungs_URL,
 1234 
                    "voting_url"           => $manufacturer->bewertungs_URL,
1233 
                    "records"              => $agency->datensaetze,
 1235 
                    "records"              => $manufacturer->datensaetze,
1234 
                    "access_url"           => $agency->Zugang_URL,
 1236 
                    "access_url"           => $manufacturer->Zugang_URL,
1235 
                    "access_user"          => $agency->Zugang_Benutzer,
 1237 
                    "access_user"          => $manufacturer->Zugang_Benutzer,
1236 
                    "access_password"      => $agency->Zugang_Passwort,
 1238 
                    "access_password"      => $manufacturer->Zugang_Passwort,
1237 
                    "comment"              => $agency->Bemerkung,
 1239 
                    "comment"              => $manufacturer->Bemerkung,
1238 
                    "locked_manufacturers" => $agency->gesperrte_hersteller,
 1240 
                    "locked_manufacturers" => $manufacturer->gesperrte_hersteller,
1239 
                    "config"               => $agency->config,
 1241 
                    "config"               => $manufacturer->config,
1240 
                    "status"               => $agency->status,
 1242 
                    "status"               => $manufacturer->status,
1241 
                    "only_deliverable"     => $agency->nur_lieferbar,
 1243 
                    "only_deliverable"     => $manufacturer->nur_lieferbar,
1242 
                    "min_price"            => $agency->min_preis,
 1244 
                    "min_price"            => $manufacturer->min_preis,
1243 
                    "last_updated_at"      => $letzte_Aktualisierung_am,
 1245 
                    "last_updated_at"      => $letzte_Aktualisierung_am,
1244 
                    "last_access_at"       => $letzter_Abruf_am,
 1246 
                    "last_access_at"       => $letzter_Abruf_am,
1245 
                    "last_access_by"       => $agency->letzter_Abruf_von,
 1247 
                    "last_access_by"       => $manufacturer->letzter_Abruf_von,
1246 
                    "updated_at"           => $agency->letzte_Aenderung_am,
 1248 
                    "updated_at"           => $manufacturer->letzte_Aenderung_am,
1247 
                    "updated_by"           => $agency->letzte_Aenderung_von,
 1249 
                    "updated_by"           => $manufacturer->letzte_Aenderung_von,
1248 
                ] );
 1250 
                ] );
1249 
                $progressbar->advance();
 1251 
                $progressbar->advance();
1250 
            }
 1252 
            }
1251 
            $progressbar->finish();
 1253 
            $progressbar->finish();
1252 
            $progressbar->clear();
 1254 
            $progressbar->clear();
1253 
        }
 1255 
        }
- 
 
 1256 
 
- 
 
 1257 
        private function migrateManufacturers()
- 
 
 1258 
        {
- 
 
 1259 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Hersteller" );
- 
 
 1260 
            $start = 0;
- 
 
 1261 
            $sql = "SELECT
- 
 
 1262 
                    MAX(id) start
- 
 
 1263 
                FROM
- 
 
 1264 
                    manufacturers
- 
 
 1265 
            ";
- 
 
 1266 
            $row = DB::connection( 'mysql' )->select( $sql );
- 
 
 1267 
            if ( $row[0]->start )
- 
 
 1268 
            {
- 
 
 1269 
                $start = $row[0]->start;
- 
 
 1270 
            }
- 
 
 1271 
            $sql = "SELECT
- 
 
 1272 
                    *
- 
 
 1273 
                FROM
- 
 
 1274 
                    Herstellerkatalog
- 
 
 1275 
                WHERE
- 
 
 1276 
                    id>" . $start . "
- 
 
 1277 
            ";
- 
 
 1278 
            $manufacturers = DB::connection( 'old' )->select( $sql );
- 
 
 1279 
            $progressbar = $this->output->createProgressBar( count( $manufacturers ) );
- 
 
 1280 
            $progressbar->start();
- 
 
 1281 
            foreach ( $manufacturers as $manufacturer )
- 
 
 1282 
            {
- 
 
 1283 
                $letzte_Aktualisierung_am = $manufacturer->letzte_Aktualisierung_am;
- 
 
 1284 
                if ( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
- 
 
 1285 
                {
- 
 
 1286 
                    $letzte_Aktualisierung_am = null;
- 
 
 1287 
                }
- 
 
 1288 
                Manufacturer::factory()->create( [
- 
 
 1289 
                    "id"          => $manufacturer->ID,
- 
 
 1290 
                    "name"        => $manufacturer->Name,
- 
 
 1291 
                    "description" => $manufacturer->Text,
- 
 
 1292 
                    "logo1"       => $manufacturer->logo1,
- 
 
 1293 
                    "logo1_href"  => $manufacturer->logo1_href,
- 
 
 1294 
                    "logo2"       => $manufacturer->logo2,
- 
 
 1295 
                    "logo2_href"  => $manufacturer->logo2_href,
- 
 
 1296 
                    "property1"   => $manufacturer->Eigenschaft_1,
- 
 
 1297 
                    "property2"   => $manufacturer->Eigenschaft_2,
- 
 
 1298 
                    "property3"   => $manufacturer->Eigenschaft_2,
- 
 
 1299 
                    "calculation" => $manufacturer->abw_kalkulation,
- 
 
 1300 
                    "created_at"  => $manufacturer->erstellt_am,
- 
 
 1301 
                    "created_by"  => $manufacturer->erstellt_von,
- 
 
 1302 
                    "updated_at"  => $manufacturer->letzte_Aenderung_am,
- 
 
 1303 
                    "updated_by"  => $manufacturer->letzte_Aenderung_von,
- 
 
 1304 
                ] );
- 
 
 1305 
                $progressbar->advance();
- 
 
 1306 
            }
- 
 
 1307 
            $progressbar->finish();
- 
 
 1308 
            $progressbar->clear();
- 
 
 1309 
 
- 
 
 1310 
        }
1254 
    }
 1311 
    }