Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 551 Revision 552
Zeile 970... Zeile 970...
970 
                    vportale_art
 970 
                    vportale_art
971 
                WHERE
 971 
                WHERE
972 
                    id>" . $start . "
 972 
                    id>" . $start . "
973 
            ";
 973 
            ";
974 
            $portals = DB::connection( 'cms' )->select( $sql );
 974 
            $portals = DB::connection( 'cms' )->select( $sql );
- 
 
 975 
            $progressbar = $this->output->createProgressBar( count( $portals ) );
- 
 
 976 
            $progressbar->start();
975 
            foreach ( $portals as $portal )
 977 
            foreach ( $portals as $portal )
976 
            {
 978 
            {
977 
                SalesPortalType::factory()->create( [
 979 
                SalesPortalType::factory()->create( [
978 
                    "id"                   => $portal->id,
 980 
                    "id"                   => $portal->id,
979 
                    "type"                 => $portal->art,
 981 
                    "type"                 => $portal->art,
Zeile 984... Zeile 986...
984 
                    "script"               => $portal->skript,
 986 
                    "script"               => $portal->skript,
985 
                    "script_folder"        => $portal->script_folder,
 987 
                    "script_folder"        => $portal->script_folder,
986 
                    "commit_possibilities" => $portal->commit_posibilities,
 988 
                    "commit_possibilities" => $portal->commit_posibilities,
987 
                    "revokeable"           => $portal->stornierbar,
 989 
                    "revokeable"           => $portal->stornierbar,
988 
                ] );
 990 
                ] );
- 
 
 991 
                $progressbar->advance();
989 
            }
 992 
            }
- 
 
 993 
            $progressbar->finish();
- 
 
 994 
            $progressbar->clear();
990 
        }
 995 
        }
Zeile 991... Zeile 996...
991 
 
 996 
 
992 
        private function migrateSalesPortals()
 997 
        private function migrateSalesPortals()
993 
        {
 998 
        {
Zeile 1009... Zeile 1014...
1009 
                    vportale
 1014 
                    vportale
1010 
                WHERE
 1015 
                WHERE
1011 
                    id>" . $start . "
 1016 
                    id>" . $start . "
1012 
            ";
 1017 
            ";
1013 
            $portals = DB::connection( 'old' )->select( $sql );
 1018 
            $portals = DB::connection( 'old' )->select( $sql );
- 
 
 1019 
            $progressbar = $this->output->createProgressBar( count( $portals ) );
- 
 
 1020 
            $progressbar->start();
1014 
            foreach ( $portals as $portal )
 1021 
            foreach ( $portals as $portal )
1015 
            {
 1022 
            {
1016 
                $max_preis = 0;
 1023 
                $max_preis = 0;
1017 
                $anrede = 1;
 1024 
                $anrede = 1;
1018 
                if ( isset( $portal->anrede ) )
 1025 
                if ( isset( $portal->anrede ) )
Zeile 1048... Zeile 1055...
1048 
                    "created_by"           => $portal->erstellt_von,
 1055 
                    "created_by"           => $portal->erstellt_von,
1049 
                    "updated_by"           => $portal->geaendert_von,
 1056 
                    "updated_by"           => $portal->geaendert_von,
1050 
                    "created_at"           => $portal->erstellt_am,
 1057 
                    "created_at"           => $portal->erstellt_am,
1051 
                    "updated_at"           => $portal->geaendert_am,
 1058 
                    "updated_at"           => $portal->geaendert_am,
1052 
                ] );
 1059 
                ] );
- 
 
 1060 
                $progressbar->advance();
1053 
            }
 1061 
            }
- 
 
 1062 
            $progressbar->finish();
- 
 
 1063 
            $progressbar->clear();
1054 
        }
 1064 
        }
Zeile 1055... Zeile 1065...
1055 
 
 1065 
 
1056 
        private function migrateSalesPortalItems()
 1066 
        private function migrateSalesPortalItems()
1057 
        {
 1067 
        {
Zeile 1073... Zeile 1083...
1073 
                    artikel_vportale
 1083 
                    artikel_vportale
1074 
                WHERE
 1084 
                WHERE
1075 
                    id>" . $start . "
 1085 
                    id>" . $start . "
1076 
            ";
 1086 
            ";
1077 
            $items = DB::connection( 'old' )->select( $sql );
 1087 
            $items = DB::connection( 'old' )->select( $sql );
- 
 
 1088 
            $progressbar = $this->output->createProgressBar( count( $items ) );
- 
 
 1089 
            $progressbar->start();
1078 
            foreach ( $items as $item )
 1090 
            foreach ( $items as $item )
1079 
            {
 1091 
            {
1080 
                $pickup = 0;
 1092 
                $pickup = 0;
1081 
                if ( isset( $item->pickup ) )
 1093 
                if ( isset( $item->pickup ) )
1082 
                {
 1094 
                {
Zeile 1156... Zeile 1168...
1156 
                    "created_by"                      => $item->erstellt_von,
 1168 
                    "created_by"                      => $item->erstellt_von,
1157 
                    "updated_by"                      => $item->geaendert_von,
 1169 
                    "updated_by"                      => $item->geaendert_von,
1158 
                    "created_at"                      => $erstellt_am,
 1170 
                    "created_at"                      => $erstellt_am,
1159 
                    "updated_at"                      => $geaendert_am,
 1171 
                    "updated_at"                      => $geaendert_am,
1160 
                ] );
 1172 
                ] );
- 
 
 1173 
                $progressbar->advance();
1161 
            }
 1174 
            }
- 
 
 1175 
            $progressbar->finish();
- 
 
 1176 
            $progressbar->clear();
1162 
	}
 1177 
	}
Zeile 1163... Zeile 1178...
1163 
 
 1178 
 
1164 
	private function migratePriceAgencies()
 1179 
	private function migratePriceAgencies()
1165 
	{
 1180 
	{
1166 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Verkaufsportalartikel" );
 1181 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );
1167 
            $start = 0;
 1182 
            $start = 0;
1168 
            $sql = "SELECT
 1183 
            $sql = "SELECT
1169 
                    MAX(id) start
 1184 
                    MAX(id) start
1170 
                FROM
 1185 
                FROM
Zeile 1181... Zeile 1196...
1181 
                    Preisagentur
 1196 
                    Preisagentur
1182 
                WHERE
 1197 
                WHERE
1183 
                    id>" . $start . "
 1198 
                    id>" . $start . "
1184 
            ";
 1199 
            ";
1185 
	    $agencies = DB::connection( 'old' )->select( $sql );
 1200 
	    $agencies = DB::connection( 'old' )->select( $sql );
- 
 
 1201 
            $progressbar = $this->output->createProgressBar( count( $agencies ) );
- 
 
 1202 
            $progressbar->start();
1186 
	    foreach($agencies as $agency)
 1203 
	    foreach($agencies as $agency)
1187 
	    {
 1204 
	    {
- 
 
 1205 
		    $letzter_Abruf_am = $agency->letzter_Abruf_am;
- 
 
 1206 
		    if( $letzter_Abruf_am == "0000-00-00 00:00:00" )
- 
 
 1207 
		    {
- 
 
 1208 
			    $letzter_Abruf_am = null;
- 
 
 1209 
		    }
- 
 
 1210 
		    $letzte_Aktualisierung_am = $agency->letzte_Aktualisierung_am;
- 
 
 1211 
		    if( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
- 
 
 1212 
		    {
- 
 
 1213 
			    $letzte_Aktualisierung_am = null;
- 
 
 1214 
		    }
1188 
		    PriceAgency::factory()->create([
 1215 
		    PriceAgency::factory()->create([
1189 
			    "id"                   => $agency->ID,
 1216 
			    "id"                   => $agency->ID,
1190 
			    "shop_id"              => $agency->shopsID,
 1217 
			    "shop_id"              => $agency->shops_ID,
1191 
			    "name"                 => $agency->Titel,
 1218 
			    "name"                 => $agency->Titel,
1192 
			    "logo_url"             => $agency->logo_url,
 1219 
			    "logo_url"             => $agency->logo_url,
1193 
			    "home_url"             => $agency->home_url,
 1220 
			    "home_url"             => $agency->home_url,
1194 
			    "csv_url"              => $agency->csv_url,
 1221 
			    "csv_url"              => $agency->csv_url,
1195 
			    "trigger_url"          => $agency->trigger_url,
 1222 
			    "trigger_url"          => $agency->trigger_URL,
1196 
			    "voting_url"           => $agency->bewertungs_URL,
 1223 
			    "voting_url"           => $agency->bewertungs_URL,
1197 
			    "records"              => $agency->datensaetze,
 1224 
			    "records"              => $agency->datensaetze,
1198 
			    "access_url"           => $agency->Zugang_URL,
 1225 
			    "access_url"           => $agency->Zugang_URL,
1199 
			    "access_user"          => $agency->Zugang_Benutzer,
 1226 
			    "access_user"          => $agency->Zugang_Benutzer,
1200 
			    "access_password"      => $agency->Zugang_Passwort,
 1227 
			    "access_password"      => $agency->Zugang_Passwort,
Zeile 1202... Zeile 1229...
1202 
			    "locked_manufacturers" => $agency->gesperrte_hersteller,
 1229 
			    "locked_manufacturers" => $agency->gesperrte_hersteller,
1203 
			    "config"               => $agency->config,
 1230 
			    "config"               => $agency->config,
1204 
			    "status"               => $agency->status,
 1231 
			    "status"               => $agency->status,
1205 
			    "only_deliverable"     => $agency->nur_lieferbar,
 1232 
			    "only_deliverable"     => $agency->nur_lieferbar,
1206 
			    "min_price"            => $agency->min_preis,
 1233 
			    "min_price"            => $agency->min_preis,
1207 
			    "last_updated_at"      => $agency->letzte_Aktualisierung_am,
 1234 
			    "last_updated_at"      => $letzte_Aktualisierung_am,
1208 
			    "last_access_at"       => $agecny->letzter_Abruf_am,
 1235 
			    "last_access_at"       => $letzter_Abruf_am,
1209 
			    "last_access_by"       => $agency->letzter_Abruf_von,
 1236 
			    "last_access_by"       => $agency->letzter_Abruf_von,
1210 
			    "updated_at"           => $agency->letzte_Aenderung_am,
 1237 
			    "updated_at"           => $agency->letzte_Aenderung_am,
1211 
			    "updated_by"           => $agency->letzte_Aenderung_von,
 1238 
			    "updated_by"           => $agency->letzte_Aenderung_von,
1212 
		    ]);
 1239 
		    ]);
- 
 
 1240 
                $progressbar->advance();
1213 
	    }
 1241 
            }
- 
 
 1242 
            $progressbar->finish();
- 
 
 1243 
            $progressbar->clear();
1214 
	}
 1244 
	}
1215 
    }
 1245 
    }