如何在 Laravel 5.7 中使用 Cron Job 将经纬度从邮政编码更新到数据库

debugcn 发表于 Dev

艾姆格鲁特

使用作业/事件创建一个 cron 脚本，以使用注册页面上提供的邮政编码更新用户位置详细信息，如城市、州、经度、纬度等。

// app/console/commands/Zipcron.php
public function handle()
{
    try {
        $test = new User()
        $test->latitude = $latitude;
        $test->longitude = $longitude;
        $test->save();
        return $this->info('successfully added');

    } catch (exception $e) {
        return $this->warning('successfully added');
    }
}

// app/console/kernel.php
protected function schedule(Schedule $schedule)
{
    $schedule->command(Commands\ZipCron::class)->everyMinute()
        ->appendOutputTo(storage_path('logs/scheduler.log'));
}

用户11408553

public function handle()
    {      
        $trial = Trial::whereNull('lat')->whereNull('lng')->whereNull('address')->get();
        foreach ($trial as $tr)
        {
            $response = Geocode::make()->address($tr->zipcode);
            if ($response){
                $lat     = $response->latitude();
                $lng     = $response->longitude();  
                $city    = $response->raw()->address_components[1]->long_name;
                $state   = $response->raw()->address_components[2]->long_name;
                $address = $response->formattedAddress();
                echo $response->locationType();   
                DB::table('trial')->where('id', $tr->id)->update(['lat' => $lat, 'lng' => $lng, 'city' => $city, 'state' => $state, 'address' => $address]);          
            }
        }exit;         
    }

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。