FreenetIS

'bit rate is invalid - it has to be smaller or equal to max bit rate of choosen wireless norm' => 'Rychlost přenosu je neplatná - musí být menší nebo rovna maximální rychlosti přenosu vybrané normy Wi-Fi.',

'channel width' => 'Šířka kanálu',

'circular' => 'kruhová',

'client' => 'klient',

'directional' => 'směrová',

'ethernet' => 'ethernetové',

'fiber optical multi-mode' => 'vlákno - optické vícevidové',

'fiber optical single-mode' => 'vlákno - optické jednovidové',

'horizontal' => 'horizontální',

'horizontal and vertical' => 'horizontální a vertikální',

'mode is required' => 'Mód je povinný.',

'omnidirectional' => 'všesměrová',

'port number' => 'Číslo portu',

'port number already exist' => 'Číslo portu již existuje.',

'sectional' => 'sektorová',

'segment is invalid - its medium has to in relation with type of interface' => 'Segment je neplatný - jeho médium musí odpovídat typu rozhraní.',

'select antenna' => 'Vyber anténu',

'select medium' => 'Vyber médium',

'select mode' => 'Vyber mód',

'select norm' => 'Vyber normu',

'select polarization' => 'Vyber polarizaci',

'vertical' => 'vertikální',

'wireless' => 'bezdrátové',

<method name="valid_itype" autogenerate="on">

<attributes>

<attribute name="input" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="valid_mac" autogenerate="on">

<attributes>

<attribute name="input" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="valid_subnet" autogenerate="on">

<attributes>

<attribute name="input" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="valid_segment" autogenerate="on">

<attributes>

<attribute name="input" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="valid_mode" autogenerate="on">

<attributes>

<attribute name="input" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_segments_by_iface_type" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="valid_port_nr" autogenerate="on">

<attributes>

<attribute name="input" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="remove_admins" autogenerate="on">

<attributes>

<attribute name="cloud_id" default_value="" />

<attribute name="admin_ids" default_value="" />

</attributes>

<values>

<input>

<param value="" />

<param value="" />

</input>

</values>

</method>

<method name="remove_subnets" autogenerate="on">

<attributes>

<attribute name="cloud_id" default_value="" />

<attribute name="subnet_ids" default_value="" />

</attributes>

<values>

<input>

<param value="" />

<param value="" />

</input>

</values>

</method>

<method name="get_type" autogenerate="on">

<attributes>

<attribute name="type" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_types" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_default_name" autogenerate="on">

<attributes>

<attribute name="type" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_default_names" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<model name="ip_addresses_state">

<method name="update_ip_addresses" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="update_success_avarages" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="update_success_counts" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="update_fail_counts" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="update_last_success" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="update_last_fail" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="update_availabilities" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="clean_pings" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

</model>

<method name="port_number_exists" autogenerate="on">

<attributes>

<attribute name="port_nr" default_value="" />

<attribute name="device_id" default_value="" />

</attributes>

<values>

<input>

<param value="" />

<param value="" />

</input>

</values>

</method>

<method name="get_all_segments_to_iface_dropdown" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_all_segments_to_port_dropdown" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_all_segments_by_iface_type" autogenerate="on">

<attributes>

<attribute name="type" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<model name="wireless_iface">

<method name="get_mode" autogenerate="on">

<attribute name="mode" default_value="" />

<input></input>

<param value="" />

</values>

</method>

<method name="get_modes" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_antenna" autogenerate="on">

<attributes>

<attribute name="antenna" default_value="" />

</attributes>

<values>

<input></input>

<param value="" />

</values>

</method>

<method name="get_antennas" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

</model>

<model name="wireless_segment">

<method name="get_norm" autogenerate="on">

<attributes>

<attribute name="norm" default_value="" />

</attributes>

<values>

<input></input>

<param value="" />

</method>

<method name="get_norms" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_polarization" autogenerate="on">

<attributes>

<attribute name="polarization" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_polarizations" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

<method name="get_max_bitrate" autogenerate="on">

<attributes>

<attribute name="norm" default_value="" />

</attributes>

<values>

<input></input>

<input>

<param value="" />

</input>

</values>

</method>

<method name="get_max_bitrates" autogenerate="on">

<attributes></attributes>

<values>

<input></input>

</values>

</method>

</model>

const TYPE_PC = 7;

const TYPE_CLIENT = 8;

const TYPE_AP = 62;

* Function tries to find subnet of user. Used in devices/add.

* @property Wireless_iface_Model $wireless

protected $has_one = array('wireless' => 'wireless_iface');

const TYPE_WIRELESS = 1;

const TYPE_ETHERNET = 2;

private static $types = array

(

self::TYPE_WIRELESS => 'Wireless',

self::TYPE_ETHERNET => 'Ethernet'

);

private static $default_names = array

(

self::TYPE_WIRELESS => 'wlan',

self::TYPE_ETHERNET => 'eth'

);

/**

* Returns type of current interface

*

* @author Michal Kliment

* @param integer $type

* @return string

*/

public function get_type ($type = NULL)

{

if (!$type)

$type = $this->type;

if (array_key_exists($type, self::$types))

return __(self::$types[$type]);

else

return NULL;

}

/**

* Returns all types of interfaces

*

* @author Michal Kliment

* @return array

*/

public function get_types ()

{

$types = array();

foreach (self::$types as $key => $value)

$types[$key] = __($value);

return $types;

}

/**

* Returns default name of current type of interface

*

* @author Michal Kliment

* @param integer $type

* @return string

*/

public function get_default_name ($type = NULL)

{

if (!$type)

$type = $this->type;

if (array_key_exists($type, self::$default_names))

return self::$default_names[$type];

else

return NULL;

}

/**

* Returns all default names of interfaces

*

* @author Michal Kliment

* @return array

*/

public function get_default_names ()

{

return self::$default_names;

}

* Used in devices/add to prefill engineer field.

<?php defined('SYSPATH') or die('No direct script access.');

/*

* This file is part of open source system FreeNetIS

* and it is released under GPLv3 licence.

*

* More info about licence can be found:

* http://www.gnu.org/licenses/gpl-3.0.html

*

* More info about project can be found:

* http://www.freenetis.org/

*

*/

/**

* @package Model

* @author Michal Kliment

*

* @property Segment_Model $segment

* @property string $ssid

* @property integer $norm

* @property integer $frequence

* @property integer $channel

* @property integer $channel_width

* @property integer $polarization

*/

class Wireless_segment_Model extends ORM

{

// constants of norms

const NORM_802_11_A = 1;

const NORM_802_11_B = 2;

const NORM_802_11_G = 3;

const NORM_802_11_N = 4;

const NORM_802_11_B_G = 5;

// constants of polarizations

const POLARIZATION_HORIZONTAL = 1;

const POLARIZATION_VERTICAL = 2;

const POLARIZATION_CIRCULAR = 3;

const POLARIZATION_BOTH = 4;

const POLARIZATION_HORIZONTAL_VERTICAL = 5;

/**

* Array of norms, keys of array are equal to constants of norms

* @var array

*/

private static $norms = array

(

self::NORM_802_11_A => '802.11a',

self::NORM_802_11_B => '802.11b',

self::NORM_802_11_G => '802.11g',

self::NORM_802_11_N => '802.11n',

self::NORM_802_11_B_G => '802.11b/g'

);

/**

* Array of polarizations, keys of array are equal to constants of polarizations

* @var array

*/

private static $polarizations = array

(

self::POLARIZATION_HORIZONTAL => 'horizontal',

self::POLARIZATION_VERTICAL => 'vertical',

self::POLARIZATION_CIRCULAR => 'circular',

self::POLARIZATION_BOTH => 'both',

self::POLARIZATION_HORIZONTAL_VERTICAL => 'horizontal and vertical'

);

private static $max_bitrates = array

(

self::NORM_802_11_A => 54,

self::NORM_802_11_B => 11,

self::NORM_802_11_G => 54,

self::NORM_802_11_N => 600,

self::NORM_802_11_B_G => 54

);

/**

* Returns norm name by given norm id

*

* @author

* @param integer $norm

* @return string

*/

public function get_norm ($norm = NULL)

{

if (!$norm)

$norm = $this->norm;

if (array_key_exists($norm, self::$norms))

return self::$norms[$norm];

else

return NULL;

}

/**

* Returns all norm names

*

* @author Michal Kliment

* @return array

*/

public function get_norms ()

{

return self::$norms;

}

/**

* Returns polarization name by given polarization id

*

* @author Michal Kliment

* @param integer $polarization

* @return string

*/

public function get_polarization ($polarization = NULL)

{

if (!$polarization)

$polarization = $this->polarization;

if (array_key_exists($polarization, self::$polarizations))

return url_lang::lang('texts.'.self::$polarizations[$polarization]);

else

return NULL;

}

/**

* Returns all polarization names

*

* @author Michal Kliment

* @return array

*/

public function get_polarizations ()

{

$polarizations = array();

foreach (self::$polarizations as $key => $value)

$polarizations[$key] = url_lang::lang('texts.'.$value);

return $polarizations;

}

/**

* Returns max bitrate of norm

*

* @author Michal Kliment

* @param integer $norm

* @return integer

*/

public function get_max_bitrate ($norm = NULL)

{

if (!$norm)

$norm = $this->norm;

if (array_key_exists($norm, self::$max_bitrates))

return self::$max_bitrates[$norm];

else

return NULL;

}

/**

* Returns all max bitrates of norms

*

* @author Michal Kliment

* @param integer $norm

* @return integer

*/

public function get_max_bitrates ()

{

return self::$max_bitrates;

}

}

?>

protected $has_one = array('state' => 'ip_addresses_state');

SELECT IFNULL(AVG(upload),0) AS upload, IFNULL(AVG(download),0) AS download, IFNULL(AVG(upload+download),0) AS total

SELECT mt.*, upload+download AS total

FROM members_traffics mt

WHERE member_id IN

(

SELECT member_id FROM

(

SELECT mt.*, upload+download AS total

FROM members_traffics mt

) mt

WHERE ".$this->db->escape_column(Settings::get('ulogd_active_type'))." > ?

)

*

* @property Wireless_segment_Model $wireless

protected $has_one = array('wireless' => 'wireless_segment');

self::SINGLE_FIBER => 'fiber optical single-mode',

self::MULTI_FIBER => 'fiber optical multi-mode'

* Function tries to find segment where user's device is connected to. Used in devices/add.

* Returns all segments to dropdown as array

*

* @author Michal Kliment

* @return array

*/

public function get_all_segments_to_iface_dropdown ()

{

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

SELECT s.id, s.name

FROM segments s

WHERE medium_id = ? OR medium_id = ? OR medium_id = ?

ORDER BY s.name

", array(self::AIR, self::CABLE, self::ROAMING));

$arr_segments = array();

foreach ($segments as $segment)

$arr_segments[$segment->id] = $segment->name;

return $arr_segments;

}

/**

* Returns all segments to dropdown as array

*

* @author Michal Kliment

* @return array

*/

public function get_all_segments_to_port_dropdown ()

{

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

SELECT s.id, s.name

FROM segments s

WHERE medium_id = ? OR medium_id = ?

OR medium_id = ? OR medium_id = ?

ORDER BY s.name

", array(self::SINGLE_FIBER, self::MULTI_FIBER,

self::CABLE, self::ROAMING));

$arr_segments = array();

foreach ($segments as $segment)

$arr_segments[$segment->id] = $segment->name;

return $arr_segments;

}

/**

/**

* Returns all segments according to given type of iface

*

* @author Michal Kliment

* @param integer $type

* @return array

*/

public function get_all_segments_by_iface_type ($type)

{

$arr_segments = array();

switch ($type)

{

case Iface_Model::TYPE_WIRELESS:

$medium_id = self::AIR;

break;

case Iface_Model::TYPE_ETHERNET:

$medium_id = self::CABLE;

break;

default:

return $arr_segments;

break;

}

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

SELECT * FROM segments s

WHERE medium_id = ? OR medium_id = ?

ORDER BY s.name

", array($medium_id, self::ROAMING));

foreach ($segments as $segment)

$arr_segments[$segment->id] = $segment->name;

return $arr_segments;

}

IFNULL(ports_vlans.vlan_count,0) AS vlan_count, ports.id,ports.name,

ports.port_nr

IFNULL(ports_vlans.vlan_count,0) AS vlan_count, ports.id,ports.name,

ports.port_nr

ORDER BY port_nr ASC

/**

* Checks whether exists port number in device

*

* @author Michal Kliment

* @param integer $port_nr

* @param integer $device_id

* @return boolean

*/

public function port_number_exists ($port_nr, $device_id)

{

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

SELECT COUNT(*) AS total

FROM ports p

WHERE p.port_nr = ? AND p.device_id = ?

", array($port_nr, $device_id));

if ($result && $result->current())

return (bool) $result->current()->total;

else

return false;

}

<?php defined('SYSPATH') or die('No direct script access.');

/*

* This file is part of open source system FreeNetIS

* and it is release under GPLv3 licence.

*

* More info about licence can be found:

* http://www.gnu.org/licenses/gpl-3.0.html

*

* More info about project can be found:

* http://www.freenetis.org/

*

*/

/**

* @package Model

* @author Michal Kliment

*

* @property integer $wmode

* @property integer $antenna

* @property Iface_Model $iface

*/

class Wireless_iface_Model extends ORM

{

protected $belongs_to = array('iface');

const MODE_AP = 1;

const MODE_CLIENT = 2;

private static $modes = array

(

self::MODE_AP => 'AP',

self::MODE_CLIENT => 'client'

);

const ANTENNA_DIRECTIONAL = 1;

const ANTENNA_OMNIDIRECTIONAL = 2;

const ANTENNA_SECTIONAL = 3;

private static $antennas = array

(

self::ANTENNA_DIRECTIONAL => 'Directional',

self::ANTENNA_OMNIDIRECTIONAL => 'Omnidirectional',

self::ANTENNA_SECTIONAL => 'Sectional'

);

/**

* Returns mode of current wireless interface

*

* @author Michal Kliment

* @param integer $mode

* @return string

*/

public function get_mode ($mode = NULL)

{

if (!$mode)

$mode = $this->wmode;

if (array_key_exists($mode, self::$modes))

return __(self::$modes[$mode]);

else

return NULL;

}

/**

* Returns all modes of wireless interfaces

*

* @author Michal Kliment

* @param integer $mode

* @return string

*/

public function get_modes ()

{

$modes = array();

foreach (self::$modes as $key => $value)

$modes[$key] = __($value);

return $modes;

}

/**

* Returns antenna of current wireless interface

*

* @author Michal Kliment

* @param integer $mode

* @return string

*/

public function get_antenna ($antenna = NULL)

{

if (!$antenna)

$antenna = $this->antenna;

if (array_key_exists($antenna, self::$antennas))

return __(self::$antennas[$antenna]);

else

return NULL;

}

/**

* Returns all antennas of wireless interfaces

*

* @author Michal Kliment

* @param integer $mode

* @return string

*/

public function get_antennas ()

{

$antennas = array();

foreach (self::$antennas as $key => $value)

$antennas[$key] = __($value);

return $antennas;

}

}