Subversion-Projekte lars-tiefland.laravel_shop

Revision

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

Revision 552 Revision 555
Zeile 1172... Zeile 1172...
1172 
                ] );
 1172 
                ] );
1173 
                $progressbar->advance();
 1173 
                $progressbar->advance();
1174 
            }
 1174 
            }
1175 
            $progressbar->finish();
 1175 
            $progressbar->finish();
1176 
            $progressbar->clear();
 1176 
            $progressbar->clear();
1177 
	}
 1177 
        }
Zeile 1178... Zeile 1178...
1178 
 
 1178 
 
1179 
	private function migratePriceAgencies()
 1179 
        private function migratePriceAgencies()
1180 
	{
 1180 
        {
1181 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );
 1181 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preisagenturen" );
1182 
            $start = 0;
 1182 
            $start = 0;
1183 
            $sql = "SELECT
 1183 
            $sql = "SELECT
1184 
                    MAX(id) start
 1184 
                    MAX(id) start
Zeile 1195... Zeile 1195...
1195 
                FROM
 1195 
                FROM
1196 
                    Preisagentur
 1196 
                    Preisagentur
1197 
                WHERE
 1197 
                WHERE
1198 
                    id>" . $start . "
 1198 
                    id>" . $start . "
1199 
            ";
 1199 
            ";
1200 
	    $agencies = DB::connection( 'old' )->select( $sql );
 1200 
            $agencies = DB::connection( 'old' )->select( $sql );
1201 
            $progressbar = $this->output->createProgressBar( count( $agencies ) );
 1201 
            $progressbar = $this->output->createProgressBar( count( $agencies ) );
1202 
            $progressbar->start();
 1202 
            $progressbar->start();
1203 
	    foreach($agencies as $agency)
 1203 
            foreach ( $agencies as $agency )
1204 
	    {
 1204 
            {
1205 
		    $letzter_Abruf_am = $agency->letzter_Abruf_am;
 1205 
                $letzter_Abruf_am = $agency->letzter_Abruf_am;
1206 
		    if( $letzter_Abruf_am == "0000-00-00 00:00:00" )
 1206 
                if ( $letzter_Abruf_am == "0000-00-00 00:00:00" )
1207 
		    {
 1207 
                {
1208 
			    $letzter_Abruf_am = null;
 1208 
                    $letzter_Abruf_am = null;
1209 
		    }
 1209 
                }
1210 
		    $letzte_Aktualisierung_am = $agency->letzte_Aktualisierung_am;
 1210 
                $letzte_Aktualisierung_am = $agency->letzte_Aktualisierung_am;
1211 
		    if( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
 1211 
                if ( $letzte_Aktualisierung_am == "0000-00-00 00:00:00" )
1212 
		    {
 1212 
                {
1213 
			    $letzte_Aktualisierung_am = null;
 1213 
                    $letzte_Aktualisierung_am = null;
1214 
		    }
 1214 
                }
1215 
		    PriceAgency::factory()->create([
 1215 
                PriceAgency::factory()->create( [
1216 
			    "id"                   => $agency->ID,
 1216 
                    "id"                   => $agency->ID,
1217 
			    "shop_id"              => $agency->shops_ID,
 1217 
                    "shop_id"              => $agency->shops_ID,
1218 
			    "name"                 => $agency->Titel,
 1218 
                    "name"                 => $agency->Titel,
1219 
			    "logo_url"             => $agency->logo_url,
 1219 
                    "logo_url"             => $agency->logo_url,
1220 
			    "home_url"             => $agency->home_url,
 1220 
                    "home_url"             => $agency->home_url,
1221 
			    "csv_url"              => $agency->csv_url,
 1221 
                    "csv_url"              => $agency->csv_url,
1222 
			    "trigger_url"          => $agency->trigger_URL,
 1222 
                    "trigger_url"          => $agency->trigger_URL,
1223 
			    "voting_url"           => $agency->bewertungs_URL,
 1223 
                    "voting_url"           => $agency->bewertungs_URL,
1224 
			    "records"              => $agency->datensaetze,
 1224 
                    "records"              => $agency->datensaetze,
1225 
			    "access_url"           => $agency->Zugang_URL,
 1225 
                    "access_url"           => $agency->Zugang_URL,
1226 
			    "access_user"          => $agency->Zugang_Benutzer,
 1226 
                    "access_user"          => $agency->Zugang_Benutzer,
1227 
			    "access_password"      => $agency->Zugang_Passwort,
 1227 
                    "access_password"      => $agency->Zugang_Passwort,
1228 
			    "comment"              => $agency->Bemerkung,
 1228 
                    "comment"              => $agency->Bemerkung,
1229 
			    "locked_manufacturers" => $agency->gesperrte_hersteller,
 1229 
                    "locked_manufacturers" => $agency->gesperrte_hersteller,
1230 
			    "config"               => $agency->config,
 1230 
                    "config"               => $agency->config,
1231 
			    "status"               => $agency->status,
 1231 
                    "status"               => $agency->status,
1232 
			    "only_deliverable"     => $agency->nur_lieferbar,
 1232 
                    "only_deliverable"     => $agency->nur_lieferbar,
1233 
			    "min_price"            => $agency->min_preis,
 1233 
                    "min_price"            => $agency->min_preis,
1234 
			    "last_updated_at"      => $letzte_Aktualisierung_am,
 1234 
                    "last_updated_at"      => $letzte_Aktualisierung_am,
1235 
			    "last_access_at"       => $letzter_Abruf_am,
 1235 
                    "last_access_at"       => $letzter_Abruf_am,
1236 
			    "last_access_by"       => $agency->letzter_Abruf_von,
 1236 
                    "last_access_by"       => $agency->letzter_Abruf_von,
1237 
			    "updated_at"           => $agency->letzte_Aenderung_am,
 1237 
                    "updated_at"           => $agency->letzte_Aenderung_am,
1238 
			    "updated_by"           => $agency->letzte_Aenderung_von,
 1238 
                    "updated_by"           => $agency->letzte_Aenderung_von,
1239 
		    ]);
 1239 
                ] );
1240 
                $progressbar->advance();
 1240 
                $progressbar->advance();
1241 
            }
 1241 
            }
1242 
            $progressbar->finish();
 1242 
            $progressbar->finish();
1243 
            $progressbar->clear();
 1243 
            $progressbar->clear();
1244 
	}
 1244 
        }
1245 
    }
 1245 
    }