FreenetIS

<?php

class Ip_address_Model extends ORM {

public $arr_sql = array('segment_name'=>'s.name','device_name'=>'d.name','user'=>'concat(u.name,\' \',u.surname)');

public function count_all_ip_addresses($filter_values = array())

{

$where = '';

if(count($filter_values)>0) $where .= 'where ';

foreach ($filter_values as $key => $value)

{

if($key!='submit')

{

if($where!='where ') $where .= ' and ';

$where .= $this->get_sql($key).' like \'%'.trim($value).'%\' collate utf8_general_ci';

}

}

$ip_addresses = self::$db->query('select ip.id, ip.IP_address, f.MAC, s.name as segment_name, d.name as device_name, concat(u.name,\' \',u.surname) as user_name from ip_addresses ip

left join ifaces f on ip.iface_id = f.id

left join segments s on f.segment_id = s.id

left join devices d on f.device_id = d.id

left join users u on d.user_id = u.id '.$where);

return count($ip_addresses);

}

public function get_all_ip_addresses($limit_from = 0, $limit_results = 50, $order_by = 'ip_addresses.id', $order_by_direction = 'ASC', $filter_values = array())

$where = '';

if(count($filter_values)>0) $where .= 'where ';

foreach ($filter_values as $key => $value)

{

if($key!='submit')

{

if($where!='where ') $where .= ' and ';

$where .= $this->get_sql($key).' like \'%'.trim($value).'%\' collate utf8_general_ci';

}

}

if ($order_by=='IP_address') $order_by = 'str2ip(IP_address)';

return self::$db->query('select ip.id, ip.IP_address, f.MAC, s.name as segment_name, d.name as device_name, concat(u.name,\' \',u.surname) as user_name from ip_addresses ip

left join ifaces f on ip.iface_id = f.id

left join segments s on f.segment_id = s.id

left join devices d on f.device_id = d.id

left join users u on d.user_id = u.id '

.$where.' order by '.$this->get_sql($order_by).' '.$order_by_direction.' limit '.$limit_from.','.$limit_results);

private function get_sql($key = NULL)

{

return (isset($this->arr_sql[$key])) ? $this->arr_sql[$key] : $key;

}

/**

* Returns count of records matching the given ip address. Used for test of existing ip address.

* @param $ip ip address

* @return unknown_type count of found ip addresses

*/

public function get_count($ip)

{

return self::$db->where('ip_address', $ip)->count_records('ip_addresses');

}

}

?>

?>

//$query = $ip_model->select(array('ifaces.name as iface_name', 'vlan_ifaces.name as vlan_iface_name', 'ip_addresses.*'))->join('ifaces', 'ifaces.id = ip_addresses.iface_id')->join('vlan_ifaces', 'vlan_ifaces.id = ip_addresses.VLAN_iface_id')->orderby($order_by,$order_by_direction)->limit($limit_results,$sql_offset)->find_all();

/*$db = new Database;

$query = $db->query('SELECT ifaces.name AS iface_name, vlan_ifaces.name AS vlan_iface_name, ip_addresses.* FROM ip_addresses LEFT JOIN ifaces ON ifaces.id = ip_addresses.iface_id LEFT JOIN vlan_ifaces ON vlan_ifaces.id = ip_addresses.VLAN_iface_id ORDER BY id ASC LIMIT 0, 50');

*/

$filter=new Table_Form(url_lang::base()."ip_addresses/show_all", "get", array(

new Table_Form_Item('text','IP_address','IP address'),

new Table_Form_Item('text','MAC','MAC'),

"tr",

new Table_Form_Item('text','segment_name','Segment name'),

new Table_Form_Item('text','device_name','Device name'),

"tr",

new Table_Form_Item('text','user','User'),

"tr",

"td",

new Table_Form_Item('submit','submit','Filter')

)

);

$query = $ip_model->get_all_ip_addresses($sql_offset, (int)$limit_results, $order_by, $order_by_direction, $filter->values());

$total_ip = $ip_model->count_all_ip_addresses($filter->values());

'query_string' => $this->input->get()

$grid->order_field('id')->label('ID')->class('center');

$grid->order_field('IP_address')->label(url_lang::lang('texts.ip addresses'));

//$grid->order_field('subnet_name')->label(url_lang::lang('texts.Subnet name'));

$grid->order_field('MAC')->label(url_lang::lang('texts.MAC'));

$grid->order_field('segment_name')->label(url_lang::lang('texts.Segment name'));

$grid->order_field('device_name')->label(url_lang::lang('texts.Device name'));

$grid->order_field('user_name')->label(url_lang::lang('texts.User'));

//$grid->order_field('vlan_iface_name')->label(url_lang::lang('texts.VLAN interface name'));

// to do - set access control

$view->content->table = $filter->view.$grid;

$member_id = $ip_address->iface->device->user->member_id;

$ssDevice_id = $this->session->get('ssDevice_id');

$ssIface_id = $this->session->get('ssIface_id');

$ssVlan_iface_id = $this->session->get('ssVlan_iface_id');

//---- Set global parameters for valid callback function ----

$this->iface_type = $this->input->post('iface_type');

$this->subnet_id = $this->input->post('subnet_id');

$this->form=$form = new Forge(url_lang::base()."ip_addresses/add/", '', 'POST', array('id' => 'article_form'));

$form->set_attr('class', 'form_class')->set_attr('method', 'post');

if ($ssVlan_iface_id) {

$ifaces = $vlan_iface_model->select('id','name')->orderby('name')->find_all_by_id($ssVlan_iface_id);

$default = 'VLAN';

elseif ($ssIface_id) {

$ifaces = $iface_model->orderby('name')->find_all_by_id($ssIface_id);

$default = 'iface';

foreach($ifaces as $iface) $member_id = $iface->device->user->member_id;

else {

$ifaces = $iface_model->select('id','name')->orderby('name')->find_all();

->orderby('name')->find_all();

$arr_subnets_netnames[]=$arr_subnets_names[] = '----- '.url_lang::lang('texts.select subnet').' -----';

$arr_subnets_ids[]=$arr_subnets_masks[]=$arr_subnets_nets[]=0;

foreach ($subnets as $subnet) {

$arr_subnets_names[$subnet->id] = $subnet->name . ": ". $subnet->net_str."/".$subnet->mask;

$this->arr_mask_by_id[$subnet->id]=$subnet->mask;

$this->arr_net_by_id[$subnet->id]=$subnet->net;

$arr_subnets_nets[] = $subnet->net;

$arr_subnets_masks[] = $subnet->mask;

$arr_subnets_netnames[] = $subnet->net_str."/".$subnet->mask.": ".$subnet->name ;

$arr_subnets_ids[]=$subnet->id;

array_multisort($arr_subnets_nets, SORT_NUMERIC, SORT_ASC,

$arr_subnets_masks, SORT_NUMERIC, SORT_ASC,

$arr_subnets_ids, SORT_NUMERIC, SORT_ASC,

$arr_subnets_netnames, SORT_STRING, SORT_ASC);

$arr_subnets_ips=array_combine($arr_subnets_ids, $arr_subnets_netnames);

//$form->group('')->label(url_lang::lang('texts.IP addresses'));

//$form->radio('iface_type')->label(url_lang::lang('texts.IP address').':')->rules('required|length[3,250]');

if (!$ssIface_id && !$ssVlan_iface_id) {

$form->radio('iface_type')->label(url_lang::lang('texts.Interface type').':')->options(array('iface'=>url_lang::lang('texts.Basic').' &nbsp; ','VLAN'=>url_lang::lang('texts.VLAN')))->default('iface')->onchange('ajax_get_ifaces(this.value)');

}

else {

$form->hidden('iface_type')->value($default);

}

$form->dropdown('iface_id')->label(url_lang::lang('texts.Interface name').':')

->options($arr_ifaces)

->rules('required');

//->class('ajax')->callback(array($this, 'callback_iface_selected'));

$form->input('IP_address')->label(url_lang::lang('texts.IP address').':')

$form->dropdown('subnet_id')->label(url_lang::lang('texts.Select subnet name').':')

->options($arr_subnets_names);

$form->group('')->label(url_lang::lang('texts.or'));

$form->dropdown('subnet_id2')->label(url_lang::lang('texts.Select subnet IP').':')

->options($arr_subnets_ips);

$form->submit('submit')->value(url_lang::lang('texts.Save'));

special::required_forge_style($form, ' *', 'required');

if($form->validate())

$form_data = $form->as_array();

if ($form_data['iface_type'] == 'iface') {

$ip->vlan_iface_id = null;

}

else {

$ip->iface_id = null;

$ip->vlan_iface_id = $form_data['iface_id'];

}

if ($subnet_id = $form_data['subnet_id']) {

$ip->subnet_id = $subnet_id;

}

if ((bool)$ip->vlan_iface_id) url::redirect(url_lang::base().'vlan_ifaces/show/'.$ip->vlan_iface_id);

elseif ($ssIface_id) url::redirect(url_lang::base().'ifaces/show/'.$ip->iface_id);

$view->content->form = $form->html();

function edit($ip_address_id = null)

$form = new Forge(url_lang::base()."ip_addresses/edit/".$ip_address_id, '', 'POST', array('id' => 'article_form'));

$arr_ifaces[0] = '----- '.url_lang::lang('texts.select interface').' -----';

$subnet_model = new Subnet_Model();

$subnets = $subnet_model->select('id','name')->orderby('name')->find_all();

$arr_subnets[0] = '----- '.url_lang::lang('texts.select subnet').' -----';

$form->input('IP_address')->label(url_lang::lang('texts.IP address').':')->rules('required|valid_ip')->value($ip_address->IP_address)->callback(array($this, 'valid_ip'));

//$form->input('IP_address')->label(url_lang::lang('texts.IP address').':')->value($ip_address->IP_address)->rules('required|valid_ip');

$form->dropdown('subnet_id')->label(url_lang::lang('texts.Select subnet name'))->options($arr_subnets)->rules('required')->selected($ip_address->subnet_id);

*/

} else { //not valid

//----- end validate --------------------------------------------------

function delete($acc_id = NULL)

// to do - correct access control for this action

//if (!$this->gacl_class->acl_check('freenetis', 'delete_own', 'all', $_SESSION['username'],get_class($this),'delete_accounts')) Controller::error(1);

if (isset($acc_id))

$model_ip = new Ip_address_Model($acc_id);

$iface = $model_ip->iface_id;

$model_ip->delete();

//url::redirect(url_lang::base().'ifaces/show/'.(int)$iface);

$ip=ip2long($this->input->$method('IP_address')); // Submitted values

$subnet_id2=$this->input->$method('subnet_id2');

if ($subnet_id==0 && $subnet_id2==0) { // subnet was not selected

if ($ip > 0) // try to find a subnet matching to the ip

$input->add_error('required', url_lang::lang('texts.Subnet has not been selected.'));

else

$input->add_error('required', url_lang::lang('texts.Invalid IP address'));

} else if ($subnet_id==0) $subnet_id=$subnet_id2;

else if ($subnet_id2==0);

else if ($subnet_id != $subnet_id2)

$input->add_error('required', url_lang::lang('texts.Select only one subnet.'));

$subnet=$this->arr_net_by_id[$subnet_id];

$mask=$this->arr_mask_by_id[$subnet_id];

if ($ip > 0 )

$this->check_ip($ip, $subnet, $mask, $input);

else

$input->add_error('required', url_lang::lang('texts.IP address is required.'));

if ($ip_model->get_count($this->input->$method('IP_address')) > 0)

$input->add_error('required', url_lang::lang('texts.IP address already exists.'));

if (($ip & $mask) != $net)

* Function checks access rights for

* -currently logged user (stored in $_SESSION['username'])

* -view operation in controller name passed in $axo_section, identified by $axo_value.

* @param $axo_section

* @param $axo_value

* @param $member_id

* @return unknown_type

$this->where[] = $this->driver->like($field, $match, 'AND ', count($this->where));