IP4Net.php
No OneTemporary
Actions

Authored By

Unknown

Size

737 B

Referenced Files

None

Subscribers

None

IP4Net.php
View Options

	<?php

	namespace App;

	use Illuminate\Database\Eloquent\Model;
	use Illuminate\Support\Facades\DB;

	class IP4Net extends Model
	{
	protected $table = "ip4nets";

	/** @var array<int, string> The attributes that are mass assignable */
	protected $fillable = [
	'rir_name',
	'net_number',
	'net_mask',
	'net_broadcast',
	'country',
	'serial',
	'created_at',
	'updated_at'
	];

	public static function getNet($ip)
	{
	$where = 'INET_ATON(net_number) <= INET_ATON(?) and INET_ATON(net_broadcast) >= INET_ATON(?)';
	return IP4Net::whereRaw($where, [$ip, $ip])
	->orderByRaw('INET_ATON(net_number), net_mask DESC')
	->first();
	}
	}