FreenetIS

'additional contacts have been successfully updated' => 'Další kontakty úspěšně uloženy',

'are you sure you want to deduct all entrance fees' => 'Jste si jistí, že chcete strhnout všechny vstupní příspěvky',

'do you want to delete this device' => 'Chcete smazat toto zařízení',

'do you want to delete this interface' => 'Chcete smazat toto rozhraní',

'do you want to delete this ip address' => 'Chcete smazat tuto IP adresu',

'do you want to delete this port' => 'Chcete smazat tento port',

'do you want to delete this user' => 'Chcete smazat tohoto uživatele',

'do you want to delete this vlan interface' => 'Chcete smazat toto VLAN rozhraní',

'export to xls' => 'Exportovat do XLS',

'export to csv' => 'Exportovat do CSV',

'primary user of member cannot be deleted' => 'Primárního uživatele člena nelze smazat.',

'user cannot be deleted, he has some dependent items in database' => 'Uživatel nelze smazat, má závislé objekty v databázi.',

'user identification' => 'Identifikace uživatele',

'user has been successfully added' => 'Uživatel byl úspěšně přidán.',

'user has been successfully deleted' => 'Uživatel byl úspěšně smazán.',

'user has been successfully updated' => 'Uživatel byl úspěšně upraven.',

'vlan interface still has at least one ip address' => 'VLAN rozhraní má ještě nejméně jednu IP adresu.',

protected $has_many = array('contacts', 'jobs', 'devices');

/**

* Function searches for items dependent on given user. Used for deleting user.

* @param $user_id

* @return unknown_type

*/

public function count_dependent_items($user_id)

{

return self::$db->query("

SELECT COUNT(*) AS total FROM

(

SELECT d.id

FROM devices d

WHERE d.user_id = $user_id

UNION

SELECT j.id

FROM jobs j

WHERE j.user_id = $user_id

UNION

SELECT da.id

FROM device_admins da

WHERE da.user_id = $user_id

UNION

SELECT de.id

FROM device_engineers de

WHERE de.user_id = $user_id

UNION

SELECT c.id

FROM contacts c

WHERE c.user_id = $user_id

) di

")->current()->total;

}

$grid->add_new_button(url_lang::base().'members/xls_export', url_lang::lang('texts.Export to XLS'));

// csv export of members

if ($this->acl_check_view(get_class($this), 'members'))

$grid->add_new_button(url_lang::base().'members/csv_export', url_lang::lang('texts.Export to CSV'));

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

$user_grid->action_field('id') ->label(url_lang::lang('texts.User'))->url(url_lang::base().'users/delete')->action(url_lang::lang('texts.Delete'))->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this user').'\');"');

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

* @author Jiri Svitak

/**

* @author Jiri Svitak

* Function exports list of members to csv file. Rows are separated by newlines and it columns by semicolon.

* @return unknown_type

*/

function csv_export()

{

// access rights

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

Controller::Error(1);

// creates database member model

$member_model = new Member_Model();

$members = $member_model->get_all_members_to_export();

// set content header

header('Content-type: application/csv');

$filename = url_lang::lang('texts.Members').'.csv';

header('Content-Disposition: attachment; filename="'.$filename.'"');

$first = true;

// yes and no for registration

$yes = url_lang::lang('texts.yes');

$no = url_lang::lang('texts.no');

// this foreach goes through rows

foreach ($members as $line)

{

// first headers of columns will be written

if ($first)

{

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

{

$title = url_lang::lang('texts.'.$key);

if ($title == 'ID')

$title = 'Číslo';

echo '"'.$title.'";';

//echo $key.';';

}

echo "\n";

$first = false;

}

// this foreach writes line

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

{

// special case - registration

if ($key == 'registration')

{

if ($value == 1)

$value = $yes;

else

$value = $no;

}

echo '"'.$value.'";';

}

echo "\n";

}

}

$grid->action_field('id')->label(url_lang::lang('texts.Interface'))->url(url_lang::base().'ifaces/delete') ->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this interface').'\');"');

$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_VLAN_ifaces->action_field('id')->label(url_lang::lang('texts.VLAN interface'))->url(url_lang::base().'vlan_ifaces/delete') ->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this vlan interface').'\');"');

/**

* Function shows all users.

* @param $limit_results

* @param $order_by

* @param $order_by_direction

* @param $page_word

* @param $page

* @return unknown_type

*/

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

'selector_increace' => 500, // increace

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

//if ($this->acl_check_delete(get_class($this),'users'))

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

/**

* Function shows users of member.

* @param $member_id

* @param $limit_results

* @param $order_by

* @param $order_by_direction

* @param $page_word

* @param $page

* @return unknown_type

*/

if ($this->acl_check_delete(get_class($this),'users',$member_id))

/**

* Function deletes user.

* @param $user_id

* @return unknown_type

*/

// access rights

if (!$this->acl_check_delete(get_class($this), 'users', $member_id))

Controller::error(1);

// link to location after delete

$linkback = url_lang::base()."members/show/$member_id";

// user of "member" type cannot be deleted

if ($user_model->type == User_Model::$member)

{

$this->session->set_flash('message', url_lang::lang('texts.Primary user of member cannot be deleted.'));

url::redirect($linkback);

}

if ($user_model->count_dependent_items($user_id) > 0)

{

$this->session->set_flash('message', url_lang::lang('texts.User cannot be deleted, he has some dependent items in database.'));

url::redirect($linkback);

}

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

url::redirect($linkback);

/**

* Function edits user.

* @param $user_id

* @return unknown_type

*/

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

/**

* Function shows user.

* @param $user_id

* @return unknown_type

*/

/**

* Function adds user.

* @param $member_id

* @return unknown_type

*/

$user_data->application_password = security::generate_password();

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

$this->session->set_flash('message', url_lang::lang('texts.Additional contacts have been successfully updated'));

$grid->action_field('id')->label(url_lang::lang('texts.Port'))->url(url_lang::base().'ports/delete')->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this port').'\');"');

$grid->add_new_button(url_lang::base().'transfers/deduct_entrance_fees', url_lang::lang('texts.Deduction of entrance fees'), array('onclick' => 'return potvrd(\''.url_lang::lang('texts.Are you sure you want to deduct all entrance fees').'\')'));

$ca = $account_model->get_credit_account_of_member($member_id);

$transfer->origin_id = $ca->id;

$grid->action_field('id')->label(url_lang::lang('texts.VLAN interface'))->url(url_lang::base().'vlan_ifaces/delete') ->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this vlan interface').'\');"');

$grid->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->action_field('id')->label(url_lang::lang('texts.Device'))->url(url_lang::base().'devices/delete') ->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this device').'\');"');

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

$grid->action_field('id')->label(url_lang::lang('texts.Interface')) ->url(url_lang::base().'ifaces/delete')->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this interface').'\');"');

$grid->action_field('id')->label(url_lang::lang('texts.Port'))->url(url_lang::base().'ports/delete')->action(url_lang::lang('texts.Delete'))->class('center')->script('onclick="return potvrd(\''.url_lang::lang('texts.Do you want to delete this port').'\');"');

public function add_new_button($uri, $label, $options = array())

$this->template->add_button .= html::anchor($uri, $label, $options).'&nbsp;</span>';