public function storeData()
{
$conqStations = $this->getEVEData(0);
ConqStations::Model()->deleteAll('1=1');
foreach ($conqStations->result->rowset->row as $station) {
$apistation = new ConqStations();
$apistation->stationID = $station->attributes()->stationID;
$apistation->stationName = $station->attributes()->stationName;
$apistation->stationTypeID = $station->attributes()->stationTypeID;
$apistation->solarSystemID = $station->attributes()->solarSystemID;
$apistation->corporationID = $station->attributes()->corporationID;
$apistation->corporationName = $station->attributes()->corporationName;
$apistation->save();
}
}
public function getLocationName($locationID)
{
$locationName = "Space";
switch ($locationID) {
case 66000000 < $locationID && $locationID < 66014933:
$stationID = $locationID - 6000001;
$station = StaStations::Model()->findByPk($stationID);
$locationName = $station->stationName;
break;
case 66014934 < $locationID && $locationID < 67999999:
$stationID = $locationID - 6000000;
$station = ConqStations::Model()->findByPk($stationID);
$locationName = $station->stationName;
break;
case 60014861 < $locationID && $locationID < 60014928:
$stationID = $locationID;
$station = ConqStations::Model()->findByPk($stationID);
$locationName = $station->stationName;
break;
case 60000000 < $locationID && $locationID < 61000000:
$stationID = $locationID;
$station = StaStations::Model()->findByPk($stationID);
$locationName = $station->stationName;
break;
case $locationID >= 61000000:
$stationID = $locationID;
$station = ConqStations::Model()->findByPk($stationID);
$locationName = $station->stationName;
break;
default:
$map = MapDenormalize::Model()->findByPk($locationID);
$locationName = $map->itemName;
break;
}
return $locationName;
}
