FreenetIS

'add new contact' => 'Přidat nový kontakt',

'add new credit account' => 'Přidat nový kreditní účet',

'add new device' => 'Přidat nové zařízení',

'add new device admin' => 'Přidat nového správce zařízení',

'add new device engineer' => 'Přidat nového technika zařízení',

'add new enum type' => 'Přidat nový výčet',

'add new port' => 'Přidat nový port',

'add new project account' => 'Přidat nový projektový účet',

'add new segment' => 'Přidat nový segment',

'add new transfer' => 'Přidat nový převod',

'add new translation' => 'Přidat nový překlad',

'add new user' => 'Přidat nového uživatele',

'add new vlan interface' => 'Přidat nové VLAN rozhraní',

'add new vlan' => 'Přidat nový VLAN',

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

'add' => 'Přidat',

'additional_contacts_infotext' => 'Další kontaktní informace',

'admins' => 'Správci',

'amount' => 'Částka',

'amount have to be more than 0!' => 'Částka musí být větší než 0',

'applicant' => 'Čekatel na členství',

'arrival' => 'Příchozí',

'assign' => 'Přiřadit',

'contractual increase' => 'Smluvní navýšení',

'cookies must be enabled' => 'Musí být zapnuty cookies.',

'counteraccount' => 'Protiúčet',

'credit' => 'Kredit',

'credit accounts' => 'Kreditní účty',

'current credit' => 'Současný kredit',

'hours' => 'Hodiny',

'change' => 'Změnit',

'change password' => 'Změnit heslo',

'id' => 'ID',

'ignore' => 'Ignorovat',

'import new invoice' => 'Import nové faktury',

'in database can be only one infrastructure account' => 'V databázi může být pouze jeden účet infrastruktury.',

'message' => 'Zpráva',

'middle name' => 'Prostřední jméno',

'minimal duration of interrupt is one month' => 'Minimální délka přerušení je jeden měsíc',

'month' => 'Měsíc',

'month from' => 'Od měsíce (včetně)',

'monthly member payment' => 'Měsiční členské příspěvky',

'none' => 'žádný',

'non-member' => 'Nečlen',

'non-statutory member' => 'Člen bez statusu',

'number of months' => 'Počet měsíců',

'number of the hours' => 'počet hodin',

'old password' => 'staré heslo',

'phone' => 'Telefon',

'phone already exists in database' => 'Telefon je již v databázi',

'please fill in the form with information about your association' => 'Prosím, vyplňte formulář údaji u vašem sdružení.',

'port is successfully saved' => 'Port byl úspěšně uložen.',

'port is successfully updated' => 'Port byl úspěšně upraven.',

'port name' => 'Název portu',

'remove' => 'Odebrat',

'save changes' => 'Uložit změny',

'save' => 'Uložit',

'section' => 'Sekce',

'send' => 'Odeslat',

'segment detail' => 'Detail segmentu',

'segment name' => 'Název segmentu',

'segments list' => 'Seznam segmentů',

'segments' => 'Segmenty',

'select destination member' => 'Vyberte člena, kterému chcete peníze převést.',

'select device' => 'Vyber zařízení',

'select interface' => 'Vyber rozhraní',

'vlans list' => 'Seznam VLANů',

'vlans' => 'VLANy',

'welcome to the freenetis!' => 'Vítejte ve Freenetisu!',

'work confirmation' => 'Potvrzení práce',

'work has been successfully added' => 'Práce byla úspěšně přidána',

'work successfully deleted' => 'Práce úspěšně smazána',

return self::$db->where('device_id', $device_id)->count_records('ifaces');

}

public function count_all_ifaces()

{

return self::$db->count_records('ifaces');

class Enum_type_Model extends ORM {

protected $belongs_to = array('enum_type_name');

/**

* enum_types array supplements a database table, holding the names for

* all enumeration types for dropdown fields.

* @var array of integers, where index is a string

*/

private static $enum_types=array(

);

/**

* @author Jiri Svitak

* @param $value

* @return unknown_type

*/

public function get_all_transfers($limit_from = 0, $limit_results = 20, $order_by = 'id', $order_by_direction = 'desc')

{

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

t.text, t.amount, t.datetime

FROM transfers t

LEFT JOIN accounts oa ON oa.id = t.origin_id

Controller::error(1);

$enum_types = new Enum_type_Model();

//$types[0] = '----- '.url_lang::lang('texts.select type').' -----';

asort($types);

// regular member by default

if ($this->acl_check_edit(get_class($this),'type',$member_id))

{

$enum_types = new Enum_type_Model();

$form->dropdown('type')->label(url_lang::lang('texts.Type').':')

->options($types)

->selected($member_data->typem);

function index()

{

url::redirect(url_lang::base().'ifaces/show_all');

}

function show_all($limit_results = 200, $order_by = 'id', $order_by_direction = 'asc', $page_word = null, $page = 1)

{

$this->session->del('ssDevice_id');

$this->session->del('ssIface_id');

// get new selector

if (is_numeric($this->input->get('record_per_page'))) $limit_results = (int) $this->input->get('record_per_page');

$iface_model = new Iface_Model();

$total_ifaces = $iface_model->count_all_ifaces();

if (($sql_offset = ($page - 1) * $limit_results) > $total_ifaces)

$sql_offset = 0;

$grid = new Grid(url_lang::base().'ifaces', null,array(

//'separator' => '<br />-----------',

//'use_paginator' => false,

//'use_selector' => false,

'selector_min' => 200, // minimum where selector start

'selector_max_multiplier' => 10,

'items_per_page' => $limit_results, // it may be handy to set defaults for stuff like this in config/pagination.php

'order_by' => $order_by,

'order_by_direction' => $order_by_direction,

'limit_results' => $limit_results

));

function show($iface_id = null)

{

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

$iface = new Iface_Model($iface_id);

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

Controller::warning(1);

$this->session->set('ssIface_id',$iface->id);

$this->session->del('ssVlan_iface_id');

//----------- list of IP ADDRESSES ---------------

$ip_model = new Ip_address_Model();

//$query = $iface_model->select(array('devices.name as device_name', 'segments.name as segment_name', 'ifaces.*'))->join('devices', 'devices.id = ifaces.device_id')->join('segments', 'segments.id = ifaces.segment_id')->orderby('id','ASC')->find_all_by_device_id($iface_id);

$query = $ip_model->select(array('ip_addresses.id','ip_addresses.IP_address','subnets.name as subnet_name'))

->join('subnets','subnets.id=ip_addresses.subnet_id', NULL, 'LEFT')

'use_paginator' => false,

'use_selector' => false

));

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

$grid_ip_addresses->add_new_button(url_lang::base().'ip_addresses/add', url_lang::lang('texts.Add new IP address'));

$grid_ip_addresses->field('id')->label('ID')->class('center');

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

$grid_ip_addresses->action_field('id')->label(url_lang::lang('texts.Delete')) ->url(url_lang::base().'ip_addresses/delete') ->action(url_lang::lang('texts.Delete'))->class('center');

$grid_ip_addresses->datasource( $query );

$VLAN_iface_model = new Vlan_iface_Model();

$query = $VLAN_iface_model->select(array('id','name'))

->orderby('id','ASC')

->find_all_by_iface_id($iface_id);

$grid_VLAN_ifaces = new Grid(url_lang::base().'ifaces', null,array(

'use_paginator' => false,

'use_selector' => false

));

if ($this->acl_check_new('Devices_Controller','vlan_iface',$member_id))

$grid_VLAN_ifaces->add_new_button(url_lang::base().'vlan_ifaces/add', url_lang::lang('texts.Add new VLAN interface'));

$grid_VLAN_ifaces->field('id')->label('ID')->class('center');

$grid_VLAN_ifaces->action_field('id')->label(url_lang::lang('texts.Edit')) ->url(url_lang::base().'vlan_ifaces/edit') ->action(url_lang::lang('texts.Edit'))->class('center');

//$grid_VLAN_ifaces->action_field('id')->label(url_lang::lang('texts.Delete')) ->url('delete') ->action(url_lang::lang('texts.Delete'))->class('center');

$grid_VLAN_ifaces->datasource( $query );

$view = new View('template');

$view->content->headline = url_lang::lang('texts.Interface detail').' - '.$iface->name;

$view->content->table_ip_addresses = $grid_ip_addresses;

$view->content->table_VLAN_ifaces = $grid_VLAN_ifaces;

$view->content->link_back = $link_back;

function add()

{

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

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

$form->dropdown('segment_id')->label(url_lang::lang('texts.Segment name'))->options($arr_segments)->rules('required');

if($form->validate())

{

$form_data = $form->as_array();

$iface = new Iface_Model();

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

{

$iface->$key = htmlspecialchars($value);

}

unset($form_data);

$this->session->set_flash('message', url_lang::lang('texts.Interface is successfully saved.'));

url::redirect(url_lang::base().'ifaces/show/'.$iface->id);

}

}

$view = new View('template');

$view->content = new View('form');

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

$view->content->link_back = $link_back;

function edit($iface_id = null)

{

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

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

$iface = new Iface_Model($iface_id);

Controller::warning(1);

}

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

if($form->validate())

{

$form_data = $form->as_array();

$iface = new Iface_Model($iface_id);

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

{

$iface->$key = htmlspecialchars($value);

}

unset($form_data);

$this->session->set_flash('message', url_lang::lang('texts.Interface is successfully updated.'));

url::redirect(url_lang::base().'ifaces/show/'.$iface->id);

}

}

$view = new View('template');

$view->content = new View('form');

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

$view->content->link_back = $link_back;

$view->content->headline = url_lang::lang('texts.Edit interface').' - '.$iface->name;

/**

* vlan interfaces assigned to this interface.

* still not functional...

* @param $iface_id id of interface to delete

$enum_type_model = new Enum_type_Model();

$arr_keys = array();

foreach($contact_types as $key => $contact_type) {

$arr_keys[] = $key;

$grid->add_new_button(url_lang::base().'transfers/deduct_fees', url_lang::lang('texts.Deduction of membership fees'));

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

$grid->order_field('origin')->label(url_lang::lang('texts.Origin account'));

$grid->order_field('destination')->label(url_lang::lang('texts.Destination account'));

$grid->order_field('datetime')->label(url_lang::lang('texts.Date and time'));

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

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

$view->content = new View('form');

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

$view->content->link_back = $link_back;

$view->footer = new View('base/footer');

$view->header->menu = Controller::render_menu();

$view->render(TRUE);

}

$view = new View('template');

$view->header = new View('base/header');

$view->header->menu = Controller::render_menu();

$view->content = new View('form');

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

$view->content->link_back = $link_back;

$view->footer = new View('base/footer');

$view = new View('template');

$view->header = new View('base/header');

$view->header->menu = Controller::render_menu();

$view->content = new View('form');

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

$view->content->link_back = html::anchor(url_lang::base().'vlans/show_all/', url_lang::lang('texts.Back to vlans list'));

$view->footer = new View('base/footer');

$view = new View('template');

$view->header = new View('base/header');

$view->header->menu = Controller::render_menu();

$view->content = new View('form');

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

$view->content->link_back = html::anchor(url_lang::base().'subnets/show_all/', url_lang::lang('texts.Back to all subnets'));

$view->footer = new View('base/footer');

function index()

{

}

//=============================================================================

//----- ADD -------------------------------------------------------------------

//=============================================================================

function add()

$contact_type_names = Array();

$enum_type_model = new Enum_type_Model();

$translation_model = new Translation_Model();

foreach ($contact_types as $contact_type)

{

$contact_type_names[$contact_type->id] = $translation_model->get_translation($contact_type->value);

$view = new View('template');

$view->header = new View('base/header');

$view->header->menu = Controller::render_menu();

$view->content = new View('form');

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

$view->content->link_back = $link_back;

$view->footer = new View('base/footer');

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

Controller::error(1);

$enum_type_model = new Enum_type_Model();

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

asort($arr_types);

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

asort($arr_engineers);

$enum_type_model = new Enum_type_Model();

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

asort($types);

if($ssMember_id)

{

$view->content->link_back = html::anchor(url_lang::base().'devices/show_by_member/'.$ssMember_id, url_lang::lang('texts.Back to devices list of this member'));

}

else

{

$view->content->link_back = html::anchor(url_lang::base().'devices/show_all/', url_lang::lang('texts.Back to devices list'));

}

$view->footer = new View('base/footer');

$view->header->title = url_lang::lang('texts.Add new device');

*/

$enum_type_model = new Enum_type_Model();

$form->dropdown('user_id')->label(url_lang::lang('texts.user'))->options($arr_users)->rules('required')->selected($device->user_id);

$form->input('name')->label(url_lang::lang('texts.Device name').':')->rules('required|length[3,250]')->value($device->name);

asort($arr_engineers);

$enum_type_model = new Enum_type_Model();

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

asort($types);

$subnet_model = new Subnet_Model();

$subnets = $subnet_model

$form->dropdown('first_engineer_id')->label(url_lang::lang('texts.engineer').' 1:')->options($arr_engineers)->rules('required')->selected($this->session->get('user_id'));

$form->dropdown('second_engineer_id')->label(url_lang::lang('texts.engineer').' 2:')->options($arr_engineers);

// adding interface

$form->input('MAC')->label(url_lang::lang('texts.MAC').':')->rules('required|length[3,250]');

$form->dropdown('segment_id')->label(url_lang::lang('texts.Segment name'))->options($arr_segments)->rules('required');

// adding ip address

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

$form->input('IP_address')->label(url_lang::lang('texts.IP address').':')->rules('required|length[7,15]')

// has been everything saved successfully?

if ($device_saved && $device_engineer_saved && $iface_model_saved && $ip_address_saved)

{

url::redirect(url_lang::base().'devices/show/'.$device_model->id);

exit;

}

if($ssMember_id)

{

$view->content->link_back = html::anchor(url_lang::base().'devices/show_by_member/'.$ssMember_id, url_lang::lang('texts.Back to devices list of this member'));

}

else

{

$view->content->link_back = html::anchor(url_lang::base().'devices/show_all/', url_lang::lang('texts.Back to devices list'));

}

$view->footer = new View('base/footer');

$view->header->menu = Controller::render_menu();

$view->render(TRUE);

} // end of function add_whole

$view = new View('template');

$view->header = new View('base/header');

$view->header->menu = Controller::render_menu();

$view->content = new View('form');

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

$view->content->link_back = html::anchor(url_lang::base().'segments/show_all/', url_lang::lang('texts.Back to segments list'));

$view->footer = new View('base/footer');