/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$path = $this->best->downloadDictionaryToFile('DestinationPlace');
$importer = new DestinationPoints();
$count = $importer->truncate()->importFile($path);
$importer->swapTempAndMainTables();
$this->info('Imported ' . $count . ' destination points');
DB::table('destination_points')->join('agent_points', 'destination_points.point_id', '=', 'agent_points.id')->update(['destination_points.name' => DB::raw('agent_points.name'), 'destination_points.address' => DB::raw('agent_points.address'), 'destination_points.address_crc' => DB::raw('agent_points.address_crc')]);
DestinationPoint::whereNull('address')->delete();
DestinationPoint::where('address', '')->delete();
DestinationPoint::where('address', '.')->delete();
DestinationPoint::where('address', '-')->delete();
DestinationPoint::where('name', 'LIKE', '%PayDirect%')->delete();
//Временно оставляем только unistream
//DestinationPoint::where('system_id', '<>', 19)->delete();
}
