Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 549 Revision 551
Zeile 10... Zeile 10...
10 
    use App\Models\Order;
 10 
    use App\Models\Order;
11 
    use App\Models\OrderAddress;
 11 
    use App\Models\OrderAddress;
12 
    use App\Models\OrderType;
 12 
    use App\Models\OrderType;
13 
    use App\Models\PaymentMethod;
 13 
    use App\Models\PaymentMethod;
14 
    use App\Models\Price;
 14 
    use App\Models\Price;
- 
 
 15 
    use App\Models\PriceAgency;
15 
    use App\Models\ActionMedium;
 16 
    use App\Models\ActionMedium;
16 
    use App\Models\ItemMedium;
 17 
    use App\Models\ItemMedium;
17 
    use App\Models\DirectoryMedium;
 18 
    use App\Models\DirectoryMedium;
18 
    use App\Models\SalesPortal;
 19 
    use App\Models\SalesPortal;
19 
    use App\Models\SalesPortalItem;
 20 
    use App\Models\SalesPortalItem;
Zeile 1156... Zeile 1157...
1156 
                    "updated_by"                      => $item->geaendert_von,
 1157 
                    "updated_by"                      => $item->geaendert_von,
1157 
                    "created_at"                      => $erstellt_am,
 1158 
                    "created_at"                      => $erstellt_am,
1158 
                    "updated_at"                      => $geaendert_am,
 1159 
                    "updated_at"                      => $geaendert_am,
1159 
                ] );
 1160 
                ] );
1160 
            }
 1161 
            }
- 
 
 1162 
	}
- 
 
 1163 
 
- 
 
 1164 
	private function migratePriceAgencies()
- 
 
 1165 
	{
- 
 
 1166 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );
- 
 
 1167 
            $start = 0;
- 
 
 1168 
            $sql = "SELECT
- 
 
 1169 
                    MAX(id) start
- 
 
 1170 
                FROM
- 
 
 1171 
                    price_agencies
- 
 
 1172 
            ";
- 
 
 1173 
            $row = DB::connection( 'mysql' )->select( $sql );
- 
 
 1174 
            if ( $row[0]->start )
- 
 
 1175 
            {
- 
 
 1176 
                $start = $row[0]->start;
1161 
        }
 1177 
            }
- 
 
 1178 
            $sql = "SELECT
- 
 
 1179 
                    *
- 
 
 1180 
                FROM
- 
 
 1181 
                    Preisagentur
- 
 
 1182 
                WHERE
- 
 
 1183 
                    id>" . $start . "
- 
 
 1184 
            ";
- 
 
 1185 
	    $agencies = DB::connection( 'old' )->select( $sql );
- 
 
 1186 
	    foreach($agencies as $agency)
- 
 
 1187 
	    {
- 
 
 1188 
		    PriceAgency::factory()->create([
- 
 
 1189 
			    "id"                   => $agency->ID,
- 
 
 1190 
			    "shop_id"              => $agency->shopsID,
- 
 
 1191 
			    "name"                 => $agency->Titel,
- 
 
 1192 
			    "logo_url"             => $agency->logo_url,
- 
 
 1193 
			    "home_url"             => $agency->home_url,
- 
 
 1194 
			    "csv_url"              => $agency->csv_url,
- 
 
 1195 
			    "trigger_url"          => $agency->trigger_url,
- 
 
 1196 
			    "voting_url"           => $agency->bewertungs_URL,
- 
 
 1197 
			    "records"              => $agency->datensaetze,
- 
 
 1198 
			    "access_url"           => $agency->Zugang_URL,
- 
 
 1199 
			    "access_user"          => $agency->Zugang_Benutzer,
- 
 
 1200 
			    "access_password"      => $agency->Zugang_Passwort,
- 
 
 1201 
			    "comment"              => $agency->Bemerkung,
- 
 
 1202 
			    "locked_manufacturers" => $agency->gesperrte_hersteller,
- 
 
 1203 
			    "config"               => $agency->config,
- 
 
 1204 
			    "status"               => $agency->status,
- 
 
 1205 
			    "only_deliverable"     => $agency->nur_lieferbar,
- 
 
 1206 
			    "min_price"            => $agency->min_preis,
- 
 
 1207 
			    "last_updated_at"      => $agency->letzte_Aktualisierung_am,
- 
 
 1208 
			    "last_access_at"       => $agecny->letzter_Abruf_am,
- 
 
 1209 
			    "last_access_by"       => $agency->letzter_Abruf_von,
- 
 
 1210 
			    "updated_at"           => $agency->letzte_Aenderung_am,
- 
 
 1211 
			    "updated_by"           => $agency->letzte_Aenderung_von,
- 
 
 1212 
		    ]);
- 
 
 1213 
	    }
- 
 
 1214 
	}
1162 
    }
 1215 
    }