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 function getBgpPrefixes($input)
{
$type = $this->getInputType($input);
if ($type === 'asn') {
$ipv4Prefixes = IPv4BgpPrefix::where('asn', $input)->orderBy('ip_dec_start', 'asc')->get();
$ipv6Prefixes = IPv6BgpPrefix::where('asn', $input)->orderBy('ip_dec_start', 'asc')->get();
return ['ipv4' => $ipv4Prefixes, 'ipv6' => $ipv6Prefixes];
} else {
if ($type === 4) {
$class = IPv4BgpPrefix::class;
} else {
$class = IPv6BgpPrefix::class;
}
}
$ipDec = $this->ip2dec($input);
$prefixes = $class::where('ip_dec_start', '<=', $ipDec)->where('ip_dec_end', '>=', $ipDec)->orderBy('cidr', 'asc')->get();
return $prefixes;
}