FreenetIS

'entrance fee' => 'Vstupní příspěvek',

'entrance fee left' => 'Nedoplatek vstupního příspěvku',

'enumerations' => 'Výčty',

'error: parameter ID is required!' => 'Chyba: parametr ID je povinný!',

'error' => 'Chyba',

'fee' => 'Poplatek',

'netmask' => 'Maska',

'network address' => 'Síťová adresa',

'networks' => 'Síť',

'new member' => 'Nový člen',

'new password' => 'Nové heslo',

'new transfer' => 'Nová transakce',

<?php

protected $member_id= false;

protected $user_id= false;

function index()

{

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

}

function show_all($limit_results = 500, $order_by = 'id', $order_by_direction = 'ASC')

{

// parameters control

$allowed_order_type = array('name', 'street', 'street_number', 'town', 'ZIP_code', 'qos_ceil', 'qos_rate', 'entrance_fee', 'debt_payment_rate', 'entrance_fee_left', 'must_pay_regular_fee', 'current_credit', 'entrance_date', 'comment');

$data['title'] = url_lang::lang('texts.Association members');

$data['heading'] = url_lang::lang('texts.Association members');

$model_members = new Member_Model();

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

new Table_Form_Item('text','name','Name'),

new Table_Form_Item('text','town','Town'),

)

);

$url_array = explode('/', trim(url::current(), '/'));

$sql_offset = (isset($url_array[7])) ? (int) ($url_array[7] - 1) * $limit_results : 0;

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

$total_members = $query->count();

foreach ($this->input->get() as $key=>$value) $arr_gets[] = $key.'='.$value;

$query_string = '?'.implode('&',$arr_gets);

// $query = $model_members

// -> like($filter->values())

// -> orderby($order_by, $order_by_direction)

// -> limit($limit_results, $sql_offset)

// -> find_all();

$grid = new Grid(url_lang::base().'members', url_lang::lang('texts.List of all members'),array(

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

//'use_paginator' => false,

//'use_selector' => false,

'current' => $limit_results, // current selected 'records_per_page' value

'selector_max_multiplier' => 10,

'base_url' => Config::item('locale.lang').'/members/show_all/'.$limit_results.'/'.$order_by.'/'.$order_by_direction ,

'uri_segment' => 'page', // pass a string as uri_segment to trigger former 'label' functionality

'query_string' => $query_string

));

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

//$view->content->total = $total_members;

//$view->content->sql_offset = $sql_offset;

//$view->content->limit_results = $limit_results;

function users($member_id = NULL, $order_by = 'member_id', $order_by_direction = 'ASC')

{

if (isset($member_id))

{

if ($member_id == $_SESSION['member_id'])

{

}

else

{

}

$model_users = new User_Model();

$users = $model_users->orderby($order_by,$order_by_direction)->find_all_by_member_id($member_id);

$grid = new Grid(url_lang::base().'members/users/', url_lang::lang('texts.My users'),array(

if ($this->acl_check_2D('freenetis', 'new_own'))

$grid->add_new_button(url_lang::base().'users/add/'.$member_id, url_lang::lang('texts.Add new user'));

$grid->action_field('id') ->label(url_lang::lang('texts.Delete'))->url(url_lang::base().'users/delete')->action(url_lang::lang('texts.Delete'))->script('onclick="return potvrd(\''.url_lang::lang('texts.delete_user').'\');"');;

$grid->datasource( $users );

$view = new View('template');

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

}

else

{

Controller::warning(1);

}

} // end of users function

function show($member_id = NULL, $order_by = 'member_id', $order_by_direction = 'ASC')

{

if (isset($member_id))

$users = $model_users->orderby($order_by,$order_by_direction)->find_all_by_member_id($member_id);

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

if($this->acl_check_new('Users_Controller','users',$member_id))

$grid->add_new_button(url_lang::base().'users/add/'.$member_id, url_lang::lang('texts.Add new user'));

} // end of show function

function add()

{

if (!$this->acl_check_new(get_class($this),'members')) Controller::error(1);

} // end of add function

function edit($member_id = NULL)

{

if (isset($member_id))

}

} // end of edit function

function registration($limit_results = 500, $page = 1)

{

$view->render(TRUE);

}

function valid_username($input)

{

$user_model=new User_Model();

$input->add_error('required', url_lang::lang('texts.Username already exists in database.'));

}

}

function valid_phone($input)

{

$user_model=new User_Model();

}

}

function valid_email($input)

$user_model=new User_Model();

if ($user_model->email_exist($input->value,$this->user_id) || trim($input->value)=='')

{

$input->add_error('required', url_lang::lang('texts.Email already exists in database.'));

}

}

unset($form_data);

if ($device_engineer->save()) {

url::redirect(url_lang::base().'devices/show/'.$device_id);

exit;

}

}

else

{

}

}

else

unset($form_data);

if ($device_admin->save()) {

url::redirect(url_lang::base().'devices/show/'.$device_id);

exit;

}

unset($form_data);

if ($device_admin->save()) {

url::redirect(url_lang::base().'devices/show/'.$device_id);

exit;

}

}

else

{

}

}

else

<?php

protected $form;

protected $arr_mask_by_id;

protected $arr_net_by_id;

function index()

{

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

}

function show_all($limit_results = 500, $order_by = 'id', $order_by_direction = 'ASC')

{

//---- delete session device and Iface ----

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

$ip_model = new Ip_address_Model();

// get new selector

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

$sql_offset = (isset($url_array[7])) ? (int) ($url_array[7] - 1) * $limit_results : 0;

unset($url_array);

//$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'),

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

$sql_offset = ($sql_offset>$total_ip) ? 0 : $sql_offset;

$grid = new Grid(url_lang::base().'ip_addresses', url_lang::lang('texts.IP addresses list'),array(

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

//'use_paginator' => false,

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

));

function show($ip_address_id = null)

{

$ip_address = new Ip_address_Model($ip_address_id);

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

Controller::warning(1);

}

if (!$this->acl_check_view('Devices_Controller','ip_address',$member_id)) Controller::error(1);

$view = new View('template');

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

$view->header->title = url_lang::lang('texts.IP address detail').' - '.$ip_address->IP_address;

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

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

$view->content->ip_address = $ip_address;

$view->content->headline = url_lang::lang('texts.IP address detail').' - '.$ip_address->IP_address;

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

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

$view->render(TRUE);

function add()

{

//---- Get variable for narrow selecting of selectbox ----

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

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

//----- validate form and save data -----------------------------------

if($form->validate())

{

exit;

}

}

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

if ($ssVlan_iface_id) $link_back = html::anchor(url_lang::base().'vlan_ifaces/show/'.$ssVlan_iface_id, url_lang::lang('texts.Back to VLAN interface parameters'));

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

$view->render(TRUE);

function edit($ip_address_id = null)

{

//---- Get variable for narrow selecting of selectbox ----

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

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

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

$view->render(TRUE);

function delete($acc_id = NULL)

{

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

}

}

$method=$this->form->IP_address->method; // <FORM> method = POST, GET, ...

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

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

$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 not selected - trying to guess!'));

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

}

$mask=0xffffffff<<(32-$mask) & 0xffffffff;

//printf(" ip=%lx, net=%lx, mask=%lx, AND=%lx", $ip, $net, $mask, $ip & $mask);

$input->add_error('required', url_lang::lang('texts.IP address does not match the subnet/mask.'));

else if ($ip==$net || $ip==($net | ~$mask))

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

}

/**

* Removed by dulik for SVN rev. 98 - does not work with JavaScript disabled

<?php

function index()

{

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

}

function show_all($limit_results = 500, $order_by = 'id', $order_by_direction = 'ASC')

{

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

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

$view->content->headline = url_lang::lang('texts.Devices list');*/

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

$view->render(TRUE);

function show_my($limit_results = 500, $order_by = 'id', $order_by_direction = 'ASC')

{

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

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

$view->render(TRUE);

/**

* @todo Add the acl_check calls!

*/

$grid->add_new_button(url_lang::base().'device_engineers/add', url_lang::lang('texts.Add new device engineer'));

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

$grid->field('surname')->label(url_lang::lang('texts.Surname'));

$grid->action_field('id')->label(url_lang::lang('texts.Remove')) ->url(url_lang::base().'device_engineers/remove')->action(url_lang::lang('texts.Remove'))->class('center');

$grid->datasource($query);

$grid_device_engineers = $grid;

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

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

$view->render(TRUE);

function add_whole()

{

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

if (!$this->acl_check_new(get_class($this),'devices',$ssMember_id)) Controller::error(1);

}

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

}

asort($arr_users);

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

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

$arr_engineers[$engineer->id] = $engineer->surname.' '.$engineer->name.' - '.$engineer->login;

}

asort($arr_engineers);

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

asort($types);

$subnet_model = new Subnet_Model();

$subnets = $subnet_model

->select("id","name","network_address as net_str",

->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;

$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;

$segment_model = new Segment_Model();

$segments = $segment_model->select(array('id','name'))->orderby('name')->find_all();

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

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

}

// form

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

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

$form->dropdown('type')->label(url_lang::lang('texts.Type'))->options($types)->rules('required');

$form->textarea('comment')->label(url_lang::lang('texts.comment').':')->rules('length[0,254]');

$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);

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

$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');

$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]')

->callback(array($this, 'valid_ip'));

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

->options($arr_subnets_names);

// submit button

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

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

if($form->validate())

{

$form_data = $form->as_array();

$device_model = new Device_Model();

$engineers_data[] = $form_data["first_engineer_id"];

if($form_data["second_engineer_id"]>0)

$engineers_data[] = $form_data["second_engineer_id"];

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

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

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

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

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

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

// model save

$device_saved = $device_model->save();

$device_engineer_saved = TRUE;

$device_engineer_model = new Device_engineer_Model();

$device_engineer_model->device_id = $device_model->id;

$device_engineer_model->user_id = $engineer_data;

$device_engineer_saved = $device_engineer_saved && $device_engineer_model->save();

}

$iface_model = new Iface_Model();

$iface_model->device_id = $device_model->id;

$iface_model->segment_id = $form_data["segment_id"];

$iface_model->MAC = htmlspecialchars($form_data["MAC"]);

// iface save

$iface_model_saved = $iface_model->save();

$ip_address_model = new Ip_address_Model();

$ip_address_model->iface_id = $iface_model->id;

$ip_address_model->vlan_iface_id = NULL;

$ip_address_model->subnet_id = $form_data['subnet_id'];

$ip_address_model->IP_address = $form_data['IP_address'];

$ip_address_model->dhcp = NULL;

$ip_address_saved = $ip_address_model->save();

unset($form_data);

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

{

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

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

exit;

}

$view = new View('template');

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

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

$view->content->headline = url_lang::lang('texts.Create whole new device');

}

//$method=$form->IP_address->method; // <FORM> method = POST, GET, ...

$input->add_error('required', url_lang::lang('texts.Subnet not selected - trying to guess!'));

else

return false;

}

$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);

}

$mask=0xffffffff<<(32-$mask) & 0xffffffff;

//printf(" ip=%lx, net=%lx, mask=%lx, AND=%lx", $ip, $net, $mask, $ip & $mask);