Revize 484
Přidáno uživatelem Michal Kliment před asi 15 roky(ů)
freenetis/trunk/kohana/application/models/subnet.php | ||
---|---|---|
$where .= ' AND '.$key.' LIKE \'%'.$value.'%\' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
||
return self::$db->query("SELECT s.*, se.name as segment
|
||
return self::$db->query("SELECT s.*
|
||
FROM subnets s
|
||
LEFT JOIN segments se ON s.segment_id = se.id
|
||
$where
|
||
ORDER BY $order_by $order_by_direction
|
||
LIMIT $limit_from, $limit_results
|
freenetis/trunk/kohana/application/controllers/subnets.php | ||
---|---|---|
$grid->order_field('netmask')->label(url_lang::lang('texts.Netmask'));
|
||
$grid->order_field('redirect')->label(url_lang::lang('texts.Redir').'.')->bool(array(url_lang::lang('texts.No'),url_lang::lang('texts.Yes')))->class('center');
|
||
//$grid->order_field('OSPF_area_id')->label(url_lang::lang('texts.OSPF area ID'));
|
||
$grid->order_field('segment')->label(url_lang::lang('texts.Segment'));
|
||
//$grid->order_field('segment')->label(url_lang::lang('texts.Segment'));
|
||
if ($this->acl_check_view('Devices_Controller', 'subnet'))
|
||
$grid->action_field('id')->label(url_lang::lang('texts.Subnet')) ->url(url_lang::base().'subnets/show') ->action(url_lang::lang('texts.Show'))->class('center');
|
||
if ($this->acl_check_edit('Devices_Controller', 'subnet'))
|
||
... | ... | |
$subnet = new Subnet_Model();
|
||
if (!$this->acl_check_new('Devices_Controller', 'subnet'))
|
||
Controller::error(ACCESS);
|
||
|
||
$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').' -----';
|
||
foreach ($segments as $segment)
|
||
{
|
||
$arr_segments[$segment->id] = $segment->name;
|
||
}
|
||
|
||
$redirect[0] = url_lang::lang('texts.No');
|
||
$redirect[1] = url_lang::lang('texts.Yes');
|
||
... | ... | |
$form->input('OSPF_area_id')->label(url_lang::lang('texts.OSPF area ID').':')->rules('valid_digit');
|
||
if ($this->acl_check_new('Devices_Controller', 'redirect'))
|
||
$form->dropdown('redirect')->label(url_lang::lang('texts.Redirect'))->options($redirect)->selected(0);
|
||
$form->dropdown('segment_id')->label(url_lang::lang('texts.Segment name'))->options($arr_segments)->rules('required');
|
||
$form->submit('submit')->value(url_lang::lang('texts.Save'));
|
||
special::required_forge_style($form, ' *', 'required');
|
||
|
||
... | ... | |
$subnet->OSPF_area_id = $form_data['OSPF_area_id'];
|
||
if ($this->acl_check_new('Devices_Controller', 'redirect'))
|
||
$subnet->redirect = $form_data['redirect'];
|
||
|
||
$subnet->segment_id = $form_data['segment_id'];
|
||
|
||
unset($form_data);
|
||
|
||
... | ... | |
if (!$this->acl_check_edit('Devices_Controller', 'subnet'))
|
||
Controller::error(ACCESS);
|
||
|
||
$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').' -----';
|
||
foreach ($segments as $segment)
|
||
{
|
||
$arr_segments[$segment->id] = $segment->name;
|
||
}
|
||
|
||
$redirect[0] = url_lang::lang('texts.No');
|
||
$redirect[1] = url_lang::lang('texts.Yes');
|
||
$this->form = $form = new Forge(url_lang::base()."subnets/edit/".$subnet_id, '', 'POST', array('id' => 'article_form'));
|
||
... | ... | |
$form->input('OSPF_area_id')->label(url_lang::lang('texts.OSPF area ID').':')->rules('valid_digit')->value($subnet->OSPF_area_id);
|
||
if ($this->acl_check_edit('Devices_Controller', 'redirect'))
|
||
$form->dropdown('redirect')->label(url_lang::lang('texts.Redirect'))->options($redirect)->selected($subnet->redirect);
|
||
$form->dropdown('segment_id')->label(url_lang::lang('texts.Segment name'))->options($arr_segments)->rules('required')->selected($subnet->segment_id);
|
||
$form->submit('submit')->value(url_lang::lang('texts.update'));
|
||
special::required_forge_style($form, ' *', 'required');
|
||
|
||
... | ... | |
$subnet->OSPF_area_id = $form_data['OSPF_area_id'];
|
||
if ($this->acl_check_edit('Devices_Controller', 'redirect'))
|
||
$subnet->redirect = $form_data['redirect'];
|
||
|
||
$subnet->segment_id = $form_data['segment_id'];
|
||
|
||
unset($form_data);
|
||
|
freenetis/trunk/kohana/application/controllers/ip_addresses.php | ||
---|---|---|
->select("id","name","network_address as net_str",
|
||
"inet_aton(network_address) as net",
|
||
"32-log2((~inet_aton(netmask) & 0xffffffff) + 1) as mask")
|
||
->orderby('net')->find_all_by_segment_id($iface->segment_id);
|
||
->orderby('net')->find_all();
|
||
|
||
$arr_subnets[0] = '----- '.url_lang::lang('texts.select subnet').' -----';
|
||
|
||
... | ... | |
|
||
|
||
$subnet_model = new Subnet_Model();
|
||
if ($ip_address->iface_id)
|
||
{
|
||
|
||
$subnets = $subnet_model
|
||
->select("id","name","network_address as net_str",
|
||
"inet_aton(network_address) as net",
|
||
"32-log2((~inet_aton(netmask) & 0xffffffff) + 1) as mask")
|
||
->orderby('net')->find_all_by_segment_id($ip_address->iface->segment_id);
|
||
}
|
||
else
|
||
{
|
||
$subnets = $subnet_model
|
||
->select("id","name","network_address as net_str",
|
||
"inet_aton(network_address) as net",
|
||
"32-log2((~inet_aton(netmask) & 0xffffffff) + 1) as mask")
|
||
->orderby('net')->find_all();
|
||
}
|
||
|
||
foreach ($subnets as $subnet)
|
||
{
|
freenetis/trunk/kohana/application/controllers/devices.php | ||
---|---|---|
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_netnames, SORT_STRING, SORT_ASC);
|
||
|
||
// segments
|
||
$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').' -----';
|
||
foreach ($segments as $segment)
|
||
{
|
||
$arr_segments[$segment->id] = $segment->name;
|
||
}
|
||
|
||
// streets
|
||
$street_model = new Street_Model();
|
||
$streets = $street_model->orderby('street')->find_all();
|
||
... | ... | |
// adding interface
|
||
$form->group('')->label(url_lang::lang('texts.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');
|
||
$form->dropdown('segment_id')->label(url_lang::lang('texts.Segment name').':')->options($arr_segments)->rules('required');
|
||
// wireless settings of interface
|
||
$form->checkbox('add_wireless')->label(url_lang::lang('texts.Save wireless setting'))->value(1);
|
||
$form->dropdown('wmode')->label(url_lang::lang('texts.Mode').':')->options($arr_modes)->callback(array($this, 'valid_mode'));
|
||
... | ... | |
$device_engineer->user_id = $form_data["first_engineer_id"];
|
||
$device_engineer_saved = $device_engineer->save();
|
||
|
||
$subnet = new Subnet_Model($form_data['subnet_id']);
|
||
|
||
// interface model
|
||
$iface_model = new Iface_Model();
|
||
$iface_model->device_id = $device_model->id;
|
||
$iface_model->segment_id = $subnet->segment_id;
|
||
$iface_model->segment_id = $form_data['segment_id'];
|
||
$iface_model->mac = htmlspecialchars($form_data["mac"]);
|
||
$iface_model->name = $device_model->name;
|
||
$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 = $subnet->id;
|
||
$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();
|
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
---|---|---|
|
||
// array of sql queries that upgrade database
|
||
$upgrade_sql[get_SVN_rev()] = array(
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'48', 'menu', 'address_points'
|
||
), (
|
||
'50', 'menu', 'address_points'
|
||
);",
|
||
"ALTER TABLE `subnets` DROP `segment_id`;",
|
||
|
||
"INSERT INTO `axo_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'59', 'Address_points_Controller', 'address_point'
|
||
), (
|
||
'59', 'Address_points_Controller', 'street'
|
||
), (
|
||
'59', 'Address_points_Controller', 'town'
|
||
), (
|
||
'51', 'Address_points_Controller', 'address_point'
|
||
), (
|
||
'51', 'Address_points_Controller', 'street'
|
||
), (
|
||
'51', 'Address_points_Controller', 'town'
|
||
);",
|
||
|
||
"UPDATE `aco` SET `name` = 'Viewing of all records' WHERE `aco`.`id` =14 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Editing of all records' WHERE `aco`.`id` =15 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Creating of all records' WHERE `aco`.`id` =16 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Viewing of own records' WHERE `aco`.`id` =17 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Editing of own records' WHERE `aco`.`id` =18 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Creating of own records' WHERE `aco`.`id` =19 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Deleting of all records' WHERE `aco`.`id` =20 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Deleting of own records' WHERE `aco`.`id` =21 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Accounts, transfers, bank accounts, bank transfers' WHERE `aco`.`id` =27 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Send email' WHERE `aco`.`id` =33 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Confirming of all records' WHERE `aco`.`id` =34 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Confirming of own records' WHERE `aco`.`id` =35 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Address points' WHERE `aco`.`id` =37 LIMIT 1 ;",
|
||
|
||
"UPDATE `axo` SET `name` = 'Name' WHERE `axo`.`id` =15 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Surname' WHERE `axo`.`id` =16 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Comment' WHERE `axo`.`id` =20 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Entrance date' WHERE `axo`.`id` =21 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Street' WHERE `axo`.`id` =17 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Invoices' WHERE `axo`.`id` =55 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Members' WHERE `axo`.`id` =91 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Additional contacts' WHERE `axo`.`id` =92 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Users' WHERE `axo`.`id` =93 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Transfers' WHERE `axo`.`id` =95 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Accounts' WHERE `axo`.`id` =96 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Name' WHERE `axo`.`id` =98 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Type' WHERE `axo`.`id` =100 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Name' WHERE `axo`.`id` =101 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Surname' WHERE `axo`.`id` =102 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Address' WHERE `axo`.`id` =103 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Phone' WHERE `axo`.`id` =104 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Current credit' WHERE `axo`.`id` =106 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Entrance fee' WHERE `axo`.`id` =107 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Entrance fee left' WHERE `axo`.`id` =108 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Debit' WHERE `axo`.`id` =109 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Work' WHERE `axo`.`id` =111 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Comment' WHERE `axo`.`id` =112 LIMIT 1 ;",
|
||
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 38 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 51 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 56 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo` WHERE `axo`.`id` = 110 LIMIT 1",
|
||
|
||
"UPDATE `axo` SET `name` = 'Password' WHERE `axo`.`id` =113 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Devices' WHERE `axo`.`id` =115 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Admin' WHERE `axo`.`id` =116 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Interface' WHERE `axo`.`id` =117 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'IP address' WHERE `axo`.`id` =119 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'VLAN interface' WHERE `axo`.`id` =120 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Subnet' WHERE `axo`.`id` =123 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Registration' WHERE `axo`.`id` =124 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Translation' WHERE `axo`.`id` =126 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'System' WHERE `axo`.`id` =127 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Member' WHERE `axo`.`id` =128 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Membership interrupts' WHERE `axo`.`id` =129 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Fees' WHERE `axo`.`id` =130 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Enum types' WHERE `axo`.`id` =131 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Organization identifier' WHERE `axo`.`id` =132 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Leaving date' WHERE `axo`.`id` =133 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Bank transfers' WHERE `axo`.`id` =134 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Bank accounts' WHERE `axo`.`id` =135 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Unidentified transfers' WHERE `axo`.`id` =136 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Wireless setting' WHERE `axo`.`id` =137 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Main engineer' WHERE `axo`.`id` =138 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Engineer' WHERE `axo`.`id` =139 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Address point' WHERE `axo`.`id` =140 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Variable symbol' WHERE `axo`.`id` =141 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Town' WHERE `axo`.`id` =142 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Street' WHERE `axo`.`id` =143 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Redirection of member' WHERE `axo`.`id` =144 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Redirection of subnet' WHERE `axo`.`id` =145 LIMIT 1 ;",
|
||
|
||
"TRUNCATE TABLE `axo_groups`",
|
||
|
||
"UPDATE `axo_sections` SET `name` = 'Self-registration of a new member' WHERE `axo_sections`.`id` =10 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Regular members' WHERE `axo_sections`.`id` =13 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Users of regular members' WHERE `axo_sections`.`id` =14 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Accounts, transfers, bank accounts and bank transfers' WHERE `axo_sections`.`id` =16 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Devices and other dependent objects' WHERE `axo_sections`.`id` =17 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Translations' WHERE `axo_sections`.`id` =18 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Settings' WHERE `axo_sections`.`id` =19 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Address points' WHERE `axo_sections`.`id` =20 LIMIT 1 ;",
|
||
|
||
"INSERT INTO `aro_groups` (
|
||
`id` ,
|
||
`parent_id` ,
|
||
`lft` ,
|
||
`rgt` ,
|
||
`name` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'34', '29', '12', '13', 'VoIP admins', 'voip_admins');",
|
||
|
||
"INSERT INTO `acl` (
|
||
`id` ,
|
||
`section_value` ,
|
||
`allow` ,
|
||
`enabled` ,
|
||
`return_value` ,
|
||
`note` ,
|
||
`updated_date`
|
||
)
|
||
VALUES (
|
||
'67', 'user', '1', '1', NULL , 'Voip admins are allowed to administrate Voips.', '1248160179'
|
||
);",
|
||
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'67', 'freenetis', 'view_all'
|
||
), (
|
||
'67', 'freenetis', 'edit_all'
|
||
), (
|
||
'67', 'freenetis', 'new_all'
|
||
), (
|
||
'67', 'freenetis', 'delete_all'
|
||
);",
|
||
|
||
"UPDATE `aro_groups_map` SET `group_id` = '34' WHERE `aro_groups_map`.`acl_id` =67 AND `aro_groups_map`.`group_id` =29 LIMIT 1 ;",
|
||
|
||
"INSERT INTO `axo_sections` (
|
||
`id` ,
|
||
`value` ,
|
||
`order_value` ,
|
||
`name` ,
|
||
`hidden`
|
||
)
|
||
VALUES (
|
||
'21', 'VoIP_Controller', '1', 'Voip', '0'
|
||
);",
|
||
|
||
"INSERT INTO `axo` (
|
||
`id` ,
|
||
`section_value` ,
|
||
`value` ,
|
||
`order_value` ,
|
||
`name` ,
|
||
`hidden`
|
||
)
|
||
VALUES (
|
||
'146', 'VoIP_Controller', 'voip', '0', 'VoIP', '0'
|
||
), (
|
||
'147', 'VoIP_Controller', 'voip_password', '0', 'VoIP password', '0'
|
||
), (
|
||
'148', 'Devices_Controller', 'tools', '0', 'Tools', '0'
|
||
);",
|
||
|
||
"INSERT INTO `axo_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'67', 'VoIP_Controller', 'voip'
|
||
), (
|
||
'67', 'VoIP_Controller', 'voip_password'
|
||
), (
|
||
'38', 'VoIP_Controller', 'voip'
|
||
), (
|
||
'38', 'VoIP_Controller', 'voip_password'
|
||
), (
|
||
'38', 'Devices_Controller', 'tools'
|
||
), (
|
||
'49', 'Devices_Controller', 'tools'
|
||
), (
|
||
'40', 'VoIP_Controller', 'voip'
|
||
), (
|
||
'44', 'VoIP_Controller', 'voip_password'
|
||
);",
|
||
|
||
"UPDATE `axo_map` SET acl_id =43 WHERE acl_id =46",
|
||
"DELETE FROM `aco_map` WHERE `aco_map`.`acl_id` = 46 AND `aco_map`.`section_value` = 'freenetis' AND `aco_map`.`value` = 'view_own' LIMIT 1",
|
||
"DELETE FROM `aro_groups_map` WHERE `aro_groups_map`.`acl_id` = 46 AND `aro_groups_map`.`group_id` = 22 LIMIT 1",
|
||
"DELETE FROM `acl` WHERE `acl`.`id` = 46 LIMIT 1",
|
||
|
||
"UPDATE `axo_map` SET acl_id =40 WHERE acl_id =45",
|
||
"DELETE FROM `aco_map` WHERE `aco_map`.`acl_id` = 45 AND `aco_map`.`section_value` = 'freenetis' AND `aco_map`.`value` = 'new_own' LIMIT 1",
|
||
"DELETE FROM `aro_groups_map` WHERE `aro_groups_map`.`acl_id` = 45 AND `aro_groups_map`.`group_id` = 22 LIMIT 1",
|
||
"DELETE FROM `acl` WHERE `acl`.`id` = 45 LIMIT 1",
|
||
|
||
);
|
||
|
||
?>
|
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_478.php | ||
---|---|---|
<?php
|
||
|
||
// array of sql queries that upgrade database
|
||
$upgrade_sql[478] = array(
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'48', 'menu', 'address_points'
|
||
), (
|
||
'50', 'menu', 'address_points'
|
||
);",
|
||
|
||
"INSERT INTO `axo_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'59', 'Address_points_Controller', 'address_point'
|
||
), (
|
||
'59', 'Address_points_Controller', 'street'
|
||
), (
|
||
'59', 'Address_points_Controller', 'town'
|
||
), (
|
||
'51', 'Address_points_Controller', 'address_point'
|
||
), (
|
||
'51', 'Address_points_Controller', 'street'
|
||
), (
|
||
'51', 'Address_points_Controller', 'town'
|
||
);",
|
||
|
||
"UPDATE `aco` SET `name` = 'Viewing of all records' WHERE `aco`.`id` =14 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Editing of all records' WHERE `aco`.`id` =15 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Creating of all records' WHERE `aco`.`id` =16 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Viewing of own records' WHERE `aco`.`id` =17 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Editing of own records' WHERE `aco`.`id` =18 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Creating of own records' WHERE `aco`.`id` =19 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Deleting of all records' WHERE `aco`.`id` =20 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Deleting of own records' WHERE `aco`.`id` =21 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Accounts, transfers, bank accounts, bank transfers' WHERE `aco`.`id` =27 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Send email' WHERE `aco`.`id` =33 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Confirming of all records' WHERE `aco`.`id` =34 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Confirming of own records' WHERE `aco`.`id` =35 LIMIT 1 ;",
|
||
"UPDATE `aco` SET `name` = 'Address points' WHERE `aco`.`id` =37 LIMIT 1 ;",
|
||
|
||
"UPDATE `axo` SET `name` = 'Name' WHERE `axo`.`id` =15 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Surname' WHERE `axo`.`id` =16 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Comment' WHERE `axo`.`id` =20 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Entrance date' WHERE `axo`.`id` =21 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Street' WHERE `axo`.`id` =17 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Invoices' WHERE `axo`.`id` =55 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Members' WHERE `axo`.`id` =91 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Additional contacts' WHERE `axo`.`id` =92 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Users' WHERE `axo`.`id` =93 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Transfers' WHERE `axo`.`id` =95 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Accounts' WHERE `axo`.`id` =96 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Name' WHERE `axo`.`id` =98 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Type' WHERE `axo`.`id` =100 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Name' WHERE `axo`.`id` =101 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Surname' WHERE `axo`.`id` =102 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Address' WHERE `axo`.`id` =103 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Phone' WHERE `axo`.`id` =104 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Current credit' WHERE `axo`.`id` =106 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Entrance fee' WHERE `axo`.`id` =107 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Entrance fee left' WHERE `axo`.`id` =108 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Debit' WHERE `axo`.`id` =109 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Work' WHERE `axo`.`id` =111 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Comment' WHERE `axo`.`id` =112 LIMIT 1 ;",
|
||
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 38 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 51 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 56 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",
|
||
"DELETE FROM `axo` WHERE `axo`.`id` = 110 LIMIT 1",
|
||
|
||
"UPDATE `axo` SET `name` = 'Password' WHERE `axo`.`id` =113 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Devices' WHERE `axo`.`id` =115 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Admin' WHERE `axo`.`id` =116 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Interface' WHERE `axo`.`id` =117 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'IP address' WHERE `axo`.`id` =119 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'VLAN interface' WHERE `axo`.`id` =120 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Subnet' WHERE `axo`.`id` =123 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Registration' WHERE `axo`.`id` =124 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Translation' WHERE `axo`.`id` =126 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'System' WHERE `axo`.`id` =127 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Member' WHERE `axo`.`id` =128 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Membership interrupts' WHERE `axo`.`id` =129 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Fees' WHERE `axo`.`id` =130 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Enum types' WHERE `axo`.`id` =131 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Organization identifier' WHERE `axo`.`id` =132 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Leaving date' WHERE `axo`.`id` =133 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Bank transfers' WHERE `axo`.`id` =134 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Bank accounts' WHERE `axo`.`id` =135 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Unidentified transfers' WHERE `axo`.`id` =136 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Wireless setting' WHERE `axo`.`id` =137 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Main engineer' WHERE `axo`.`id` =138 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Engineer' WHERE `axo`.`id` =139 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Address point' WHERE `axo`.`id` =140 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Variable symbol' WHERE `axo`.`id` =141 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Town' WHERE `axo`.`id` =142 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Street' WHERE `axo`.`id` =143 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Redirection of member' WHERE `axo`.`id` =144 LIMIT 1 ;",
|
||
"UPDATE `axo` SET `name` = 'Redirection of subnet' WHERE `axo`.`id` =145 LIMIT 1 ;",
|
||
|
||
"TRUNCATE TABLE `axo_groups`",
|
||
|
||
"UPDATE `axo_sections` SET `name` = 'Self-registration of a new member' WHERE `axo_sections`.`id` =10 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Regular members' WHERE `axo_sections`.`id` =13 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Users of regular members' WHERE `axo_sections`.`id` =14 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Accounts, transfers, bank accounts and bank transfers' WHERE `axo_sections`.`id` =16 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Devices and other dependent objects' WHERE `axo_sections`.`id` =17 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Translations' WHERE `axo_sections`.`id` =18 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Settings' WHERE `axo_sections`.`id` =19 LIMIT 1 ;",
|
||
"UPDATE `axo_sections` SET `name` = 'Address points' WHERE `axo_sections`.`id` =20 LIMIT 1 ;",
|
||
|
||
"INSERT INTO `aro_groups` (
|
||
`id` ,
|
||
`parent_id` ,
|
||
`lft` ,
|
||
`rgt` ,
|
||
`name` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'34', '29', '12', '13', 'VoIP admins', 'voip_admins');",
|
||
|
||
"INSERT INTO `acl` (
|
||
`id` ,
|
||
`section_value` ,
|
||
`allow` ,
|
||
`enabled` ,
|
||
`return_value` ,
|
||
`note` ,
|
||
`updated_date`
|
||
)
|
||
VALUES (
|
||
'67', 'user', '1', '1', NULL , 'Voip admins are allowed to administrate Voips.', '1248160179'
|
||
);",
|
||
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'67', 'freenetis', 'view_all'
|
||
), (
|
||
'67', 'freenetis', 'edit_all'
|
||
), (
|
||
'67', 'freenetis', 'new_all'
|
||
), (
|
||
'67', 'freenetis', 'delete_all'
|
||
);",
|
||
|
||
"UPDATE `aro_groups_map` SET `group_id` = '34' WHERE `aro_groups_map`.`acl_id` =67 AND `aro_groups_map`.`group_id` =29 LIMIT 1 ;",
|
||
|
||
"INSERT INTO `axo_sections` (
|
||
`id` ,
|
||
`value` ,
|
||
`order_value` ,
|
||
`name` ,
|
||
`hidden`
|
||
)
|
||
VALUES (
|
||
'21', 'VoIP_Controller', '1', 'Voip', '0'
|
||
);",
|
||
|
||
"INSERT INTO `axo` (
|
||
`id` ,
|
||
`section_value` ,
|
||
`value` ,
|
||
`order_value` ,
|
||
`name` ,
|
||
`hidden`
|
||
)
|
||
VALUES (
|
||
'146', 'VoIP_Controller', 'voip', '0', 'VoIP', '0'
|
||
), (
|
||
'147', 'VoIP_Controller', 'voip_password', '0', 'VoIP password', '0'
|
||
), (
|
||
'148', 'Devices_Controller', 'tools', '0', 'Tools', '0'
|
||
);",
|
||
|
||
"INSERT INTO `axo_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'67', 'VoIP_Controller', 'voip'
|
||
), (
|
||
'67', 'VoIP_Controller', 'voip_password'
|
||
), (
|
||
'38', 'VoIP_Controller', 'voip'
|
||
), (
|
||
'38', 'VoIP_Controller', 'voip_password'
|
||
), (
|
||
'38', 'Devices_Controller', 'tools'
|
||
), (
|
||
'49', 'Devices_Controller', 'tools'
|
||
), (
|
||
'40', 'VoIP_Controller', 'voip'
|
||
), (
|
||
'44', 'VoIP_Controller', 'voip_password'
|
||
);",
|
||
|
||
"UPDATE `axo_map` SET acl_id =43 WHERE acl_id =46",
|
||
"DELETE FROM `aco_map` WHERE `aco_map`.`acl_id` = 46 AND `aco_map`.`section_value` = 'freenetis' AND `aco_map`.`value` = 'view_own' LIMIT 1",
|
||
"DELETE FROM `aro_groups_map` WHERE `aro_groups_map`.`acl_id` = 46 AND `aro_groups_map`.`group_id` = 22 LIMIT 1",
|
||
"DELETE FROM `acl` WHERE `acl`.`id` = 46 LIMIT 1",
|
||
|
||
"UPDATE `axo_map` SET acl_id =40 WHERE acl_id =45",
|
||
"DELETE FROM `aco_map` WHERE `aco_map`.`acl_id` = 45 AND `aco_map`.`section_value` = 'freenetis' AND `aco_map`.`value` = 'new_own' LIMIT 1",
|
||
"DELETE FROM `aro_groups_map` WHERE `aro_groups_map`.`acl_id` = 45 AND `aro_groups_map`.`group_id` = 22 LIMIT 1",
|
||
"DELETE FROM `acl` WHERE `acl`.`id` = 45 LIMIT 1",
|
||
|
||
);
|
||
|
||
?>
|
freenetis/trunk/kohana/application/views/subnets_show.php | ||
---|---|---|
<th><?php echo url_lang::lang('texts.Redirect') ?></th>
|
||
<td><?php echo ($subnet->redirect == 1) ? url_lang::lang('texts.Yes') : url_lang::lang('texts.No') ?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?php echo url_lang::lang('texts.Segment') ?></th>
|
||
<td><?php echo $subnet->segment->name ?></td>
|
||
</tr>
|
||
</table>
|
||
|
||
|
Také k dispozici: Unified diff
Segment_id ostraneno. Tomas Dulik vam povi proc...