Revize 540
Přidáno uživatelem Jiří Sviták před téměř 15 roky(ů)
| freenetis/trunk/kohana/application/models/ip_address.php | ||
|---|---|---|
|
");
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Function gets ip addresses of subnet.
|
||
|
* @param $subnet_id
|
||
|
* @return unknown_type
|
||
|
*/
|
||
|
public function get_ip_addresses_of_subnet($subnet_id)
|
||
|
{
|
||
|
return self::$db->query("SELECT
|
||
|
ip.id, ip.ip_address, m.name, m.id AS mid
|
||
|
FROM ip_addresses ip
|
||
|
JOIN ifaces i ON i.id = ip.iface_id
|
||
|
JOIN devices d ON d.id = i.device_id
|
||
|
JOIN users u ON u.id = d.user_id
|
||
|
JOIN members m ON m.id = u.member_id
|
||
|
WHERE ip.subnet_id = $subnet_id
|
||
|
");
|
||
|
|
||
|
}
|
||
|
|
||
|
}
|
||
|
|
||
|
?>
|
||
| freenetis/trunk/kohana/application/controllers/subnets.php | ||
|---|---|---|
|
Controller::error(RECORD);
|
||
|
if (!$this->acl_check_view('Devices_Controller', 'subnet'))
|
||
|
Controller::error(ACCESS);
|
||
|
|
||
|
// ip addresses of subnet
|
||
|
$ip_model = new Ip_address_Model();
|
||
|
$ips = $ip_model->get_ip_addresses_of_subnet($subnet_id);
|
||
|
$grid = new Grid(url_lang::base().'subnets/show/'.$subnet_id, url_lang::lang('texts.IP addresses'), array(
|
||
|
'use_paginator' => false,
|
||
|
'use_selector' => false
|
||
|
));
|
||
|
$grid->field('id')->label(url_lang::lang('texts.ID'));
|
||
|
$grid->field('ip_address')->label(url_lang::lang('texts.IP address'));
|
||
|
$grid->action_field('id')->label(url_lang::lang('texts.IP address'))->url(url_lang::base().'ip_addresses/show')->action(url_lang::lang('texts.Show'))->class('center');
|
||
|
$grid->field('name')->label(url_lang::lang('texts.Member'));
|
||
|
$grid->action_field('mid')->label(url_lang::lang('texts.Member'))->url(url_lang::base().'members/show')->action(url_lang::lang('texts.Show'))->class('center');
|
||
|
$grid->datasource($ips);
|
||
|
|
||
|
$headline = url_lang::lang('texts.Subnet').' '.$subnet->name;
|
||
|
$view = new View('main');
|
||
|
$view->title = $headline;
|
||
|
$view->content = new View('subnets_show');
|
||
|
$view->content->subnet = $subnet;
|
||
|
$view->content->grid = $grid;
|
||
|
$view->content->link_back = html::anchor(url_lang::base().'subnets/show_all', url_lang::lang('texts.Back to all subnets'));
|
||
|
$view->content->headline = $headline;
|
||
|
$view->render(TRUE);
|
||
| freenetis/trunk/kohana/application/views/subnets_show.php | ||
|---|---|---|
|
<td><?php echo ($subnet->redirect == 1) ? url_lang::lang('texts.Yes') : url_lang::lang('texts.No') ?></td>
|
||
|
</tr>
|
||
|
</table>
|
||
|
<br /><br />
|
||
|
<?php echo $grid ?>
|
||
|
|
||
|
|
||
|
|
||
Také k dispozici: Unified diff
V podsiti pridano zobrazeni ip adres dane podsite.