FreenetIS

'add new whole device for user' => 'Přidat nové celé zařízení pro uživatele',

'add new work' => 'Přidat novou práci',

'add new work report' => 'Přidat nový pracovní výkaz',

'add smokeping menu item' => 'Přidat položku menu smokepingu',

'add smokeping record' => 'Přidat záznam smokepingu',

'add voip account' => 'Přidat VoIP účet',

return self::$db->query("SELECT

d.id, IFNULL(f.translated_term,e.value) as type, d.name,

CONCAT(u.name, ' ', u.surname) AS u_name,

FROM devices d

JOIN users u ON d.user_id = u.id

LEFT JOIN enum_types e ON d.type = e.id

*/

public function get_ip_addresses_of_member($member_id)

{

FROM ip_addresses ip

JOIN ifaces i ON i.id = ip.iface_id

JOIN devices d ON d.id = i.device_id

"); */

return self::$db->query("SELECT

FROM ip_addresses ip

LEFT JOIN ifaces ic1 ON ip.iface_id = ic1.id

LEFT JOIN vlan_ifaces vic ON ip.vlan_iface_id = vic.id

LEFT JOIN ifaces ic2 ON vic.iface_id = ic2.id

LEFT JOIN devices d ON q.device_id = d.id

LEFT JOIN users u ON d.user_id = u.id

LEFT JOIN members m ON u.member_id = m.id

echo $redirstr;

}

/**

* Shows details of member.

* @param $member_id id of member to show

$user_grid->action_field('id') ->label(url_lang::lang('texts.Devices'))->url(url_lang::base().'devices/show_by_user')->action(url_lang::lang('texts.Show'));

if ($this->acl_check_edit('Users_Controller', 'work', $member_id))

$user_grid->action_field('id') ->label(url_lang::lang('texts.Works'))->url(url_lang::base().'works/show_by_user')->action(url_lang::lang('texts.Show'));

// membership interrupts

$mi_model = new Membership_interrupt_Model();

$mis = $mi_model->where('member_id', $member_id)->orderby('from')->find_all();

$mi_grid->action_field('id') ->label(url_lang::lang('texts.Membership interrupts'))->url(url_lang::base().'membership_interrupts/delete')->action(url_lang::lang('texts.Delete'));

$mi_grid->datasource($mis);

$billing = new Billing();

$has_driver = $billing->has_driver();

$b_account = $billing->get_account($member_id);

$voip_sip = new Voip_sip_Model();

$voip = $voip_sip->get_all_record_by_member_limited($member_id);

$voip_grid = new Grid(url_lang::base().'members', null, array(

$voip_grid->action_field('user_id')->label(url_lang::lang('texts.Account'))->url(url_lang::base().'voip/show')->action(url_lang::lang('texts.Show'));

$voip_grid->action_field('user_id')->label(url_lang::lang('texts.User'))->url(url_lang::base().'users/show')->action(url_lang::lang('texts.Show'));

$voip_grid->datasource($voip);

if ($has_driver && ($b_account != null))

{

$voip_grid->add_new_button(url_lang::base().'voip_calls/show_by_member/'.$member_id, url_lang::lang('texts.List of all calls'));

if ($member_data->member_id != 1)

$voip_grid->add_new_button(url_lang::base().'transfers/add_voip/'.$account->id, url_lang::lang('texts.Recharge VoIP credit'));

}

// view

$view = new View('main');

$view->title = url_lang::lang('texts.Display member');

$view->content->billing_has_driver = $has_driver;

$view->content->billing_account = $b_account;

$view->content->mis = $mi_grid;

foreach($member_data as $key=>$val)

{

// IE dont render TD border if content is NULL, so we must put nbsp into empty fields.

} // end of show function

/**

* Function adds new member to database. Creates user of type member assigned to this member.

* @return unknown_type

*/

$grid_ip_addresses->action_field('id')->label(url_lang::lang('texts.IP address')) ->url(url_lang::base().'ip_addresses/edit') ->action(url_lang::lang('texts.Edit'))->class('center');

if ($this->acl_check_delete('Devices_Controller','ip_address',$member_id))

$grid_ip_addresses->action_field('id')->label(url_lang::lang('texts.IP address')) ->url(url_lang::base().'ip_addresses/delete') ->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this ip address').'\');"');

$grid_ip_addresses->datasource( $query );

// vlan interfaces

// if necessary update synchronization status in Freenetis

if (isset($synchronized))

{

}

// if central router has not set anything, then this method returns synchronization status of Freenetis

else

*/

function already_seen()

{

}

/**

*/

function redirect_content($ip_address = null)

{

// load contact information from database

$contact = '';

$contact_information = ORM::factory('message')->where(array('type' => Message_Model::$contact_information))->find();

// load message

$content = '';

$footer = '';

if ($ip_address == 'unknown_device_message')

{

$message = ORM::factory('message')->where(array('type' => Message_Model::$unknown_device_message))->find();

$ip_address = server::remote_addr();

}

elseif ($ip_address == 'cancel_message')

{

$message = ORM::factory('message')->where(array('type' => Message_Model::$cancel_message))->find();

$ip_address = server::remote_addr();

}

else

{

$message = $this->db->query("

}

}

}

// replace contact and content

$contact = Redirect_Controller::replace($contact, $ip_address);

$content = Redirect_Controller::replace($content, $ip_address);

static function subnet_field($item, $name)

{

}

/**

'use_paginator' => false,

'use_selector' => false

));

$grid->datasource($ips);

$headline = url_lang::lang('texts.Subnet').' '.$subnet->name;

$message_array[$message->id] = $message->name;

}

}

if (empty($message_array))

{

$this->session->set_flash('message', url_lang::lang('texts.No redirection is possible to set for this IP address.'));

* @param $message_id

* @return unknown_type

*/

{

$array['ip_address_id'] = $ip_address_id;

$array['message_id'] = $message_id;

$db = new Database();

$db->delete('messages_ip_addresses', $array);

$ip = new Ip_address_Model($ip_address_id);

self::update($ip->ip_address);

$this->session->set_flash('message', url_lang::lang('texts.Redirection has been successfully canceled.'));

}

/**

* Updates static html file with redirection message.

* @param $ip_address

* @return unknown_type

{

$member_name = '???';

$variable_symbol = '???';

}

else

{

$member_name = $ip->iface->device->user->member->name;

$variable_symbol = $ip->iface->device->user->member->variable_symbol;

}

// subnet name

$subnet_model = new Subnet_Model();

$text = str_replace('{member_name}', $member_name, $text);

// variable symbol of member

$text = str_replace('{variable_symbol}', $variable_symbol, $text);

return $text;

}

static function ip_address_field($item, $name)

{

}

/**

'use_selector' => false

));

$grid->field('name')->label(url_lang::lang('texts.Redirection'));

$grid->datasource($messages);

$view = new View('main');

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

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

$grid->order_callback_field('mac')->label(url_lang::lang('texts.MAC address'))->callback('Ifaces_Controller::iface_field');

$grid->order_callback_field('ip_address')->label(url_lang::lang('texts.IP address'))->callback('Ip_addresses_Controller::ip_address_field');

if ($this->acl_check_view(get_class($this),'devices',$user->member_id))

$grid->action_field('id')->label(url_lang::lang('texts.Device'))->url(url_lang::base().'devices/show')->action(url_lang::lang('texts.Show'))->class('center');

//if ($this->acl_check_edit(get_class($this),'devices',$user->member_id))

$grid_ips->field('subnet_name')->label(url_lang::lang('texts.Subnet name'));

if ($this->acl_check_view('Devices_Controller', 'ip_address', $member_id))

$grid_ips->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_ips->action_field('id')->label(url_lang::lang('texts.IP address'))->url(url_lang::base().'redirect/add')->action(url_lang::lang('texts.Redirect'));

$grid_ips->datasource($ips);

if (!isset($user_id))

$user = new User_Model($device_model->user_id);

if (!$this->acl_check_new(get_class($this), 'devices', $user->member_id))

$device_model->trade_name = htmlspecialchars($form_data["trade_name"]);

$device_model->type = htmlspecialchars($form_data["type"]);

$device_model->PPPoE_logging_in = htmlspecialchars($form_data["PPPoE_logging_in"]);

* and new ip address assigned to this interface.

* @return unknown_type

*/

$user_model = new User_Model();

// if the device is added to given user, then only one user will be to select

$selected_segment = 0;

if(isset($user_id))

{

$user = new User_Model($user_id);

$selected_GPS = $user->member->address_point->GPS;

$selected_street_id = $user->member->address_point->street_id;

$selected_street_number = $user->member->address_point->street_number;

if ($found_engineer)

$selected_engineer = $found_engineer->id;

$arr_users[$user->id] = $user->surname.' '.$user->name.' - '.$user->login;

if (!$this->acl_check_new('Devices_Controller', 'devices'))

Controller::error(ACCESS);

$users = $user_model->select('id','name','surname','login')->orderby('id')->find_all();

$form_data = $form->as_array();

// device model

$device_model->user_id = $form_data["user_id"];

// access rights

if (!isset($user_id))

$user = new User_Model($device_model->user_id);

if (!$this->acl_check_new(get_class($this), 'devices', $user->member_id))

Controller::error(ACCESS);

$device_model->trade_name = htmlspecialchars($form_data["trade_name"]);

$device_model->type = htmlspecialchars($form_data["type"]);

$device_model->PPPoE_logging_in = htmlspecialchars($form_data["PPPoE_logging_in"]);

// going through interfaces

foreach($ifaces as $iface)

{

// ORM doesn't work in this case (1:0 relation), so number of wireless settings has to be detected manually

// only solution seems to be upgrading to higher version of kohana

$ws_count = $iface->count_ws_of_iface($iface->id);

{

// before deleting IP address it is necessary to delete redirection from junction table first

$db = new Database();

// delete IP address

$ip->delete();

$deleted_ips++;

<br class = "clear" />

<br />

<h3><?php echo url_lang::lang('texts.Users')?></h3>

<?php echo $users ?>

<br />

<h3><?php echo url_lang::lang('texts.VoIP')?></h3>

<?php echo $voip ?>

<br />

<h3><?php echo url_lang::lang('texts.Membership interrupts')?></h3>

<?php echo $mis ?>