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; }