public function countryReport($country_code)
{
$asnData = [];
$allocatedAsns = $this->ipUtils->getAllocatedAsns($country_code);
// Sort out the ASN keys
foreach ($allocatedAsns as $allocatedAsn) {
$asnData[$allocatedAsn->asn] = ['asn' => $allocatedAsn->asn, 'name' => null, 'description' => null, 'date_allocated' => $allocatedAsn->date_allocated, 'ipv4_prefixes' => 0, 'ipv6_prefixes' => 0, 'ipv4_peers' => 0, 'ipv6_peers' => 0];
}
$asnArray = array_keys($asnData);
$asnMetas = ASN::whereIn('asn', $asnArray)->get();
foreach ($asnMetas as $asnMeta) {
$asnData[$asnMeta->asn]['name'] = $asnMeta->name;
$asnData[$asnMeta->asn]['description'] = $asnMeta->description;
}
$ipv4Prefixes = IPv4BgpPrefix::select(DB::raw('asn, COUNT(asn) as count'))->whereIn('asn', $asnArray)->groupBy('asn')->get();
foreach ($ipv4Prefixes as $ipv4Prefix) {
$asnData[$ipv4Prefix->asn]['ipv4_prefixes'] = $ipv4Prefix->count;
}
$ipv6Prefixes = IPv6BgpPrefix::select(DB::raw('asn, COUNT(asn) as count'))->whereIn('asn', $asnArray)->groupBy('asn')->get();
foreach ($ipv6Prefixes as $ipv6Prefix) {
$asnData[$ipv6Prefix->asn]['ipv6_prefixes'] = $ipv6Prefix->count;
}
$seenIpv4Peers = [];
$ipv4Peers = IPv4Peer::select(DB::raw('asn_1 as asn, asn_2 as peer, COUNT(asn_1) as count'))->whereIn('asn_1', $asnArray)->groupBy('asn_1')->get();
foreach ($ipv4Peers as $ipv4Peer) {
if (isset($seenIpv4Peers[$ipv4Peer->asn][$ipv4Peer->peer]) === true) {
continue;
}
$asnData[$ipv4Peer->asn]['ipv4_peers'] += $ipv4Peer->count;
$seenIpv4Peers[$ipv4Peer->asn][$ipv4Peer->peer] = true;
}
$ipv4Peers = IPv4Peer::select(DB::raw('asn_2 as asn, asn_1 as peer, COUNT(asn_2) as count'))->whereIn('asn_2', $asnArray)->groupBy('asn_2')->get();
foreach ($ipv4Peers as $ipv4Peer) {
if (isset($seenIpv4Peers[$ipv4Peer->asn][$ipv4Peer->peer]) === true) {
continue;
}
$asnData[$ipv4Peer->asn]['ipv4_peers'] += $ipv4Peer->count;
$seenIpv4Peers[$ipv4Peer->asn][$ipv4Peer->peer] = true;
}
$seenIpv6Peers = [];
$ipv6Peers = IPv6Peer::select(DB::raw('asn_1 as asn, asn_2 as peer, COUNT(asn_1) as count'))->whereIn('asn_1', $asnArray)->groupBy('asn_1')->get();
foreach ($ipv6Peers as $ipv6Peer) {
if (isset($seenIpv4Peers[$ipv6Peer->asn][$ipv6Peer->peer]) === true) {
continue;
}
$asnData[$ipv6Peer->asn]['ipv6_peers'] += $ipv6Peer->count;
}
$ipv6Peers = IPv6Peer::select(DB::raw('asn_2 as asn, asn_1 as peer, COUNT(asn_2) as count'))->whereIn('asn_2', $asnArray)->groupBy('asn_2')->get();
foreach ($ipv6Peers as $ipv6Peer) {
if (isset($seenIpv6Peers[$ipv6Peer->asn][$ipv6Peer->peer]) === true) {
continue;
}
$asnData[$ipv6Peer->asn]['ipv6_peers'] += $ipv6Peer->count;
}
return $this->sendData(array_values($asnData));
}
public static function getPeers($as_number)
{
$ipUtils = new IpUtils();
$peerSet['ipv4_peers'] = IPv4Peer::where('asn_1', $as_number)->orWhere('asn_2', $as_number)->get();
$peerSet['ipv6_peers'] = IPv6Peer::where('asn_1', $as_number)->orWhere('asn_2', $as_number)->get();
$output['ipv4_peers'] = [];
$output['ipv6_peers'] = [];
foreach ($peerSet as $ipVersion => $peers) {
foreach ($peers as $peer) {
if ($peer->asn_1 == $as_number && $peer->asn_2 == $as_number) {
continue;
}
$peerAsn = $peer->asn_1 == $as_number ? $peer->asn_2 : $peer->asn_1;
$asn = self::where('asn', $peerAsn)->first();
if (is_null($asn) === true) {
$assignment = $ipUtils->getIanaAssignmentEntry($peerAsn);
}
$peerAsnInfo['asn'] = $peerAsn;
$peerAsnInfo['name'] = is_null($asn) ? 'IANA-' . strtoupper($assignment->status) : $asn->name;
$peerAsnInfo['description'] = is_null($asn) ? $assignment->description : $asn->description;
$peerAsnInfo['country_code'] = is_null($asn) ? null : $asn->counrty_code;
$output[$ipVersion][] = $peerAsnInfo;
}
}
return $output;
}