Revize 1351
Přidáno uživatelem Michal Kliment před více než 12 roky(ů)
freenetis/branches/device_control/application/controllers/filter_queries.php | ||
---|---|---|
<?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/
|
||
*
|
||
*/
|
||
|
||
/**
|
||
* Controller performs actions over filter queries.
|
||
*
|
||
* @package Controller
|
||
*/
|
||
class Filter_queries_Controller extends Controller
|
||
{
|
||
/**
|
||
* Redirect to list of all filter queries
|
||
*/
|
||
public function index()
|
||
{
|
||
url::redirect(url_lang::base().'filter_queries/show_all');
|
||
}
|
||
|
||
/**
|
||
* Show all filter queries
|
||
* @param type $limit_results
|
||
* @param type $order_by
|
||
* @param type $order_by_direction
|
||
* @param type $page_word
|
||
* @param type $page
|
||
*/
|
||
public function show_all(
|
||
$limit_results = 100, $order_by = 'id',
|
||
$order_by_direction = 'ASC', $page_word = 'page', $page = 1)
|
||
{
|
||
$filter_query_model = new Filter_query_Model();
|
||
|
||
$filter_queries = $filter_query_model->get_all_queries();
|
||
|
||
$title = __('List of all filter queries');
|
||
|
||
// path to form
|
||
$path = Config::get('lang') . '/members/show_all/' . $limit_results . '/'
|
||
. $order_by . '/' . $order_by_direction.'/'.$page_word.'/'
|
||
. $page;
|
||
|
||
$grid = new Grid('members', null, array
|
||
(
|
||
'current' => $limit_results,
|
||
'selector_increace' => 200,
|
||
'selector_min' => 200,
|
||
'selector_max_multiplier' => 25,
|
||
'base_url' => $path,
|
||
'uri_segment' => 'page',
|
||
'total_items' => count($filter_queries),
|
||
'items_per_page' => $limit_results,
|
||
'style' => 'classic',
|
||
'order_by' => $order_by,
|
||
'order_by_direction' => $order_by_direction,
|
||
'limit_results' => $limit_results,
|
||
//'filter' => $filter_form
|
||
));
|
||
|
||
$grid->order_field('id')
|
||
->label(__('ID'));
|
||
|
||
$grid->order_field('name');
|
||
|
||
$grid->order_field('url')
|
||
->label(__('URL'));
|
||
|
||
$grid->order_callback_field('default')
|
||
->callback(
|
||
'callback::enabled_field',
|
||
'filter_queries/set_default/'
|
||
)->class('center');
|
||
|
||
$actions = $grid->grouped_action_field();
|
||
|
||
$actions->add_action('id')
|
||
->icon_action('delete')
|
||
->url('filter_queries/delete')
|
||
->label('Delete')
|
||
->class('delete_link');
|
||
|
||
$grid->datasource($filter_queries);
|
||
|
||
$view = new View('main');
|
||
$view->breadcrumbs = __('Filter queries');
|
||
$view->title = $title;
|
||
$view->content = new View('show_all');
|
||
$view->content->headline = $title;
|
||
$view->content->table = $grid;
|
||
$view->render(TRUE);
|
||
}
|
||
|
||
/**
|
||
* Adds new filter query
|
||
*
|
||
* @author Michal Kliment
|
||
*/
|
||
public function add()
|
||
{
|
||
// load data from GET
|
||
$get = $_GET;
|
||
|
||
// load URL from data
|
||
$url = arr::remove("url", $get);
|
||
|
||
// URL is missing
|
||
if ($url == '' || !isset($get['values']))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$form = new Forge();
|
||
|
||
$form->input('name')
|
||
->rules('required');
|
||
|
||
$form->checkbox('default')
|
||
->label('Set as default for this URL');
|
||
|
||
$form->submit('Save');
|
||
|
||
// form is validate
|
||
if ($form->validate())
|
||
{
|
||
$form_data = $form->as_array();
|
||
|
||
$data = array();
|
||
$offset = 0;
|
||
for ($i=0;$i<=max(array_keys($get["values"]));$i++)
|
||
{
|
||
if (isset($get["on"][$i]))
|
||
{
|
||
foreach ($get as $key => $value)
|
||
{
|
||
if (is_array($value) && isset($value[$i]))
|
||
$data[$key][$i-$offset] = $value[$i];
|
||
}
|
||
}
|
||
else
|
||
$offset++;
|
||
}
|
||
|
||
$data['tables'] = $get['tables'];
|
||
|
||
try
|
||
{
|
||
$filter_query = new Filter_query_Model();
|
||
$filter_query->transaction_start();
|
||
|
||
$filter_query->name = $form_data["name"];
|
||
$filter_query->url = $url;
|
||
$filter_query->values = json_encode($data);
|
||
$filter_query->default = $form_data["default"];
|
||
|
||
$filter_query->save_throwable();
|
||
|
||
if ($filter_query->default)
|
||
$filter_query->repair_default();
|
||
|
||
$filter_query->transaction_commit();
|
||
|
||
status::success('Filter query has been successfully added.');
|
||
|
||
$this->redirect($url."?query", $filter_query->id, '=');
|
||
}
|
||
catch (Exception $e)
|
||
{
|
||
$filter_query->transaction_rollback();
|
||
|
||
status::error('Error - cannot add new filter query.');
|
||
|
||
$this->redirect($url);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
$title = __('Save new filter query');
|
||
|
||
$view = new View('main');
|
||
$view->title = $title;
|
||
$view->content = new View('form');
|
||
$view->content->headline = $title;
|
||
$view->content->form = $form;
|
||
$view->render(TRUE);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* Update default flag for query
|
||
*
|
||
* @author Michal Kliment
|
||
* @param integer $filter_query_id
|
||
*/
|
||
public function set_default($filter_query_id = NULL)
|
||
{
|
||
// bad paremeter
|
||
if (!$filter_query_id || !is_numeric($filter_query_id))
|
||
Controller::warning (PARAMETER);
|
||
|
||
$filter_query = new Filter_query_Model($filter_query_id);
|
||
|
||
// record doesn't exis
|
||
if (!$filter_query->id)
|
||
Controller::error(RECORD);
|
||
|
||
$filter_query->transaction_start();
|
||
|
||
$is_default = $filter_query->default;
|
||
|
||
// prevent database exception
|
||
try
|
||
{
|
||
$filter_query->default = !$is_default;
|
||
$filter_query->save_throwable();
|
||
|
||
if (!$is_default)
|
||
$filter_query->repair_default();
|
||
|
||
$filter_query->transaction_commit();
|
||
|
||
if ($is_default)
|
||
status::success('Filter query has been successfully unset as default.');
|
||
else
|
||
status::success('Filter query has been successfully set as default.');
|
||
}
|
||
catch (Exception $e)
|
||
{
|
||
$filter_query->transaction_rollback();
|
||
|
||
if ($is_default)
|
||
status::error('Error - Cannot unset filter query as default.');
|
||
else
|
||
status::error('Error - Cannot set filter query as default.');
|
||
}
|
||
|
||
url::redirect($this->url('show_all'));
|
||
}
|
||
|
||
/**
|
||
* Delete query
|
||
*
|
||
* @author Michal Kliment
|
||
* @param type $filter_query_id
|
||
*/
|
||
public function delete($filter_query_id = NULL)
|
||
{
|
||
// bad paremeter
|
||
if (!$filter_query_id || !is_numeric($filter_query_id))
|
||
Controller::warning (PARAMETER);
|
||
|
||
$filter_query = new Filter_query_Model($filter_query_id);
|
||
|
||
// record doesn't exis
|
||
if (!$filter_query->id)
|
||
Controller::error(RECORD);
|
||
|
||
// prevent database exception
|
||
try
|
||
{
|
||
$filter_query->delete_throwable();
|
||
|
||
status::success('Filter query has been successfully deleted.');
|
||
}
|
||
catch (Exception $e)
|
||
{
|
||
status::error('Error - Cannot delete filter query.');
|
||
}
|
||
|
||
url::redirect($this->url('show_all'));
|
||
}
|
||
}
|
||
|
||
?>
|
freenetis/branches/device_control/application/controllers/setup_config.php | ||
---|---|---|
<?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/
|
||
*
|
||
*/
|
||
|
||
/**
|
||
* Setup config controller.
|
||
* Configure database connection and .htaccess file before installation.
|
||
*
|
||
* @author Michal Kliment
|
||
* @package Controller
|
||
*/
|
||
class Setup_config_Controller extends Controller
|
||
{
|
||
/**
|
||
* Introductory page of setup config, only some information about setup config
|
||
*
|
||
* @author Michal Kliment
|
||
*/
|
||
public function index()
|
||
{
|
||
// check if the database is empty
|
||
if ($this->settings->get('db_schema_version'))
|
||
{
|
||
url::redirect('members/show/'.$this->session->get('member_id'));
|
||
}
|
||
|
||
// new form
|
||
$form = new Forge('setup_config/setup');
|
||
|
||
$form->submit(__('Next step') . ' >>>');
|
||
|
||
$view = new View('setup_config/main');
|
||
$view->content = new View('setup_config/index');
|
||
$view->content->form = $form->html();
|
||
$view->render(TRUE);
|
||
}
|
||
|
||
/**
|
||
* This method create config file (if root directory is writable)
|
||
* or generate code to create it by user
|
||
*
|
||
* @author Michal Kliment
|
||
*/
|
||
public function setup()
|
||
{
|
||
// check if the database is empty
|
||
if ($this->settings->get('db_schema_version'))
|
||
{
|
||
url::redirect('members/show/'.$this->session->get('member_id'));
|
||
}
|
||
|
||
// new form
|
||
$form = new Forge('setup_config/setup');
|
||
|
||
$form->group('Database information');
|
||
|
||
$form->input('db_name')
|
||
->label('Database name')
|
||
->value('freenetis')
|
||
->help('The name of the database you want to run FreeNetIS in.');
|
||
|
||
$form->input('db_user')
|
||
->label('User name')
|
||
->value('freenetis')
|
||
->help('Your MySQL username');
|
||
|
||
$form->input('db_password')
|
||
->label('Password')
|
||
->value('password')
|
||
->help('Your MySQL password');
|
||
|
||
$form->input('db_host')
|
||
->label('Database host')
|
||
->value('localhost')
|
||
->help('99% chance you won\'t need to change this value.');
|
||
|
||
$form->submit('Submit');
|
||
|
||
// form is valid
|
||
if ($form->validate())
|
||
{
|
||
// convert object to array
|
||
$form_data = $form->as_array();
|
||
|
||
// test connection to database
|
||
$con = @mysql_connect(
|
||
$form_data['db_host'],
|
||
$form_data['db_user'],
|
||
$form_data['db_password']
|
||
);
|
||
|
||
$db = @mysql_select_db($form_data['db_name'], $con);
|
||
|
||
$view = new View('setup_config/main');
|
||
$view->content = new View('setup_config/setup');
|
||
|
||
// cannot connect to database => form data are bad
|
||
if (!$con OR !$db)
|
||
{
|
||
$view->content->error = TRUE;
|
||
}
|
||
// successfully connect to database, we can create config file
|
||
else
|
||
{
|
||
// load config-sample
|
||
$config_file = file('config-sample' . EXT);
|
||
|
||
foreach ($config_file as $line_num => $line)
|
||
{
|
||
// find only config lines (no comments or blank lines)
|
||
if (preg_match("/^\\\$config\['(.+)'\]/", $line, $matches))
|
||
{
|
||
// this config line is one from database config
|
||
if (isset($form_data[$matches[1]]))
|
||
{
|
||
// set value from form
|
||
$value = $form_data[$matches[1]];
|
||
$config_file[$line_num] = preg_replace(
|
||
"/^(\\\$config\[')(.+)('\] = ')(.+)(';)/",
|
||
'${1}${2}${3}' . $value . '${5}', $line
|
||
);
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
// root directory is not writable, only generate code and
|
||
// howto to create config file by user
|
||
if (!is_writable('.'))
|
||
{
|
||
$textarea = '';
|
||
|
||
foreach ($config_file as $line)
|
||
{
|
||
$textarea .= htmlentities($line);
|
||
}
|
||
|
||
$view->content->textarea = '<textarea cols="90" rows="15">'
|
||
. $textarea . '</textarea>';
|
||
}
|
||
// root directory is writable, create config
|
||
else
|
||
{
|
||
$handle = fopen('config.php', 'w');
|
||
|
||
foreach ($config_file as $line)
|
||
{
|
||
fwrite($handle, $line);
|
||
}
|
||
|
||
fclose($handle);
|
||
chmod('config.php', 0666);
|
||
}
|
||
}
|
||
$view->render(TRUE);
|
||
}
|
||
else
|
||
{
|
||
$view = new View('setup_config/main');
|
||
$view->content = $form->html();
|
||
$view->render(TRUE);
|
||
}
|
||
}
|
||
|
||
}
|
freenetis/branches/device_control/application/controllers/users.php | ||
---|---|---|
<?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/
|
||
*
|
||
*/
|
||
|
||
/**
|
||
* Users controller manages user profile settings, list of users, login logs,
|
||
* applicant password, user contacts, etc.
|
||
*
|
||
* @package Controller
|
||
*/
|
||
class Users_Controller extends Controller
|
||
{
|
||
|
||
protected $_user_id = false;
|
||
|
||
/**
|
||
* Redirects to show all
|
||
*/
|
||
public function index()
|
||
{
|
||
url::redirect('users/show_all');
|
||
}
|
||
|
||
/**
|
||
* Function shows all users.
|
||
*
|
||
* @param integer $limit_results
|
||
* @param string $order_by
|
||
* @param string $order_by_direction
|
||
* @param integer $page_word
|
||
* @param integer $page
|
||
*/
|
||
public function show_all(
|
||
$limit_results = 500, $order_by = 'id', $order_by_direction = 'asc',
|
||
$page_word = null, $page = 1)
|
||
{
|
||
if (!$this->acl_check_view(get_class($this), 'users'))
|
||
Controller::error(ACCESS);
|
||
|
||
$filter_form = new Filter_form('u');
|
||
|
||
$filter_form->add('id')
|
||
->type('number');
|
||
|
||
$filter_form->add('name')
|
||
->callback('json/user_name');
|
||
|
||
$filter_form->add('surname')
|
||
->callback('json/user_surname');
|
||
|
||
$filter_form->add('login')
|
||
->label(__('Login name'))
|
||
->callback('json/user_login');
|
||
|
||
$filter_form->add('member_name')
|
||
->type('combo')
|
||
->callback('json/member_name');
|
||
|
||
$filter_form->add('type')
|
||
->type('select')
|
||
->values(array
|
||
(
|
||
User_Model::MAIN_USER => __('Main'),
|
||
User_Model::USER => __('Collateral')
|
||
));
|
||
|
||
$filter_form->add('email')
|
||
->callback('json/user_email');
|
||
|
||
$filter_form->add('phone')
|
||
->callback('json/user_phone');
|
||
|
||
$filter_form->add('icq')
|
||
->label('ICQ')
|
||
->callback('json/user_icq');
|
||
|
||
$filter_form->add('jabber')
|
||
->callback('json/user_jabber');
|
||
|
||
$filter_form->add('birthday')
|
||
->type('date');
|
||
|
||
// get new selector
|
||
if (is_numeric($this->input->get('record_per_page')))
|
||
$limit_results = (int) $this->input->get('record_per_page');
|
||
|
||
// parameters control
|
||
$allowed_order_type = array
|
||
(
|
||
'id', 'name', 'surname', 'login', 'member_name'
|
||
);
|
||
|
||
if (!in_array(strtolower($order_by), $allowed_order_type))
|
||
$order_by = 'id';
|
||
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
$order_by_direction = 'asc';
|
||
|
||
$model_users = new User_Model();
|
||
|
||
$total_users = $model_users->count_all_users($filter_form->as_sql());
|
||
|
||
if (($sql_offset = ($page - 1) * $limit_results) > $total_users)
|
||
$sql_offset = 0;
|
||
|
||
$query = $model_users->get_all_users(
|
||
$sql_offset, (int)$limit_results, $order_by,
|
||
$order_by_direction, $filter_form->as_sql()
|
||
);
|
||
|
||
$grid = new Grid('users', __('List of all users'), array
|
||
(
|
||
'current' => $limit_results,
|
||
'selector_increace' => 500,
|
||
'selector_min' => 500,
|
||
'selector_max_multiplier' => 10,
|
||
'base_url' => Config::get('lang').'/users/show_all/'
|
||
. $limit_results.'/'.$order_by.'/'.$order_by_direction ,
|
||
'uri_segment' => 'page',
|
||
'total_items' => $total_users,
|
||
'items_per_page' => $limit_results,
|
||
'style' => 'classic',
|
||
'order_by' => $order_by,
|
||
'order_by_direction' => $order_by_direction,
|
||
'limit_results' => $limit_results,
|
||
'filter' => $filter_form
|
||
));
|
||
|
||
$grid->order_field('id')
|
||
->label('ID');
|
||
|
||
$grid->order_field('name')
|
||
->label(__('Name'));
|
||
|
||
$grid->order_field('surname')
|
||
->label(__('Surname'));
|
||
|
||
$grid->order_field('login')
|
||
->label(__('Username'));
|
||
|
||
$grid->order_callback_field('member_name')
|
||
->label(__('Member'))
|
||
->callback('callback::member_field');
|
||
|
||
$actions = $grid->grouped_action_field();
|
||
|
||
if ($this->acl_check_view(get_class($this), 'users'))
|
||
{
|
||
$actions->add_action('id')
|
||
->icon_action('member')
|
||
->url('users/show')
|
||
->label('Show user');
|
||
}
|
||
|
||
if ($this->acl_check_view('Devices_Controller', 'devices'))
|
||
{
|
||
$actions->add_action('id')
|
||
->icon_action('devices')
|
||
->url('devices/show_by_user')
|
||
->label('Show devices');
|
||
}
|
||
if ($this->acl_check_view('Users_Controller', 'work'))
|
||
{
|
||
$actions->add_action('id')
|
||
->icon_action('work')
|
||
->url('works/show_by_user')
|
||
->label('Show works');
|
||
}
|
||
|
||
$grid->datasource($query);
|
||
|
||
$view = new View('main');
|
||
$view->breadcrumbs = __('Users');
|
||
$view->title = __('List of all users');
|
||
$view->content = $grid;
|
||
$view->render(TRUE);
|
||
} // end of show_all function
|
||
|
||
/**
|
||
* Function shows users of member.
|
||
*
|
||
* @param integer $member_id
|
||
* @param integer $limit_results
|
||
* @param string $order_by
|
||
* @param string $order_by_direction
|
||
* @param integer $page_word
|
||
* @param integer $page
|
||
* @return unknown_type
|
||
*/
|
||
public function show_by_member(
|
||
$member_id = NULL, $limit_results = 200, $order_by = 'id',
|
||
$order_by_direction = 'ASC', $page_word = null, $page = 1)
|
||
{
|
||
// bad parameter
|
||
if (!$member_id || !is_numeric($member_id))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$member = new Member_Model($member_id);
|
||
|
||
// member doesn't exist
|
||
if (!$member->id)
|
||
Controller::error(RECORD);
|
||
|
||
// access control
|
||
if (!$this->acl_check_view(get_class($this), 'users', $member->id))
|
||
Controller::error(ACCESS);
|
||
|
||
// get new selector
|
||
if (is_numeric($this->input->get('record_per_page')))
|
||
$limit_results = (int) $this->input->get('record_per_page');
|
||
|
||
// parameters control
|
||
$allowed_order_type = array
|
||
(
|
||
'street', 'street_number', 'town', 'ZIP_code', 'type', 'name',
|
||
'surname', 'login', 'birthday', 'comment', 'phone', 'email', 'id',
|
||
'members_id'
|
||
);
|
||
|
||
if (!in_array(strtolower($order_by), $allowed_order_type))
|
||
$order_by = 'id';
|
||
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
$order_by_direction = 'asc';
|
||
|
||
$model_users = new User_Model();
|
||
|
||
$total_users = $model_users->count_all_users_by_member($member_id);
|
||
|
||
if (($sql_offset = ($page - 1) * $limit_results) > $total_users)
|
||
$sql_offset = 0;
|
||
|
||
$query = $model_users->get_all_users_of_member(
|
||
$member_id, $sql_offset, (int) $limit_results, $order_by,
|
||
$order_by_direction
|
||
);
|
||
|
||
$grid = new Grid('users',__('List of users of member') . ' ' . $member->name, array
|
||
(
|
||
'current' => $limit_results,
|
||
'selector_increace' => 200,
|
||
'selector_min' => 200,
|
||
'selector_max_multiplier' => 10,
|
||
'base_url' => Config::get('lang') . '/users/show_by_member/'
|
||
. $member_id . '/' . $limit_results . '/'
|
||
. $order_by . '/' . $order_by_direction,
|
||
'uri_segment' => 'page',
|
||
'total_items' => $total_users,
|
||
'items_per_page' => $limit_results,
|
||
'style' => 'classic',
|
||
'order_by' => $order_by,
|
||
'order_by_direction' => $order_by_direction,
|
||
'limit_results' => $limit_results,
|
||
'variables' => $member_id . '/',
|
||
'url_array_ofset' => 1,
|
||
'query_string' => $this->input->get(),
|
||
));
|
||
|
||
if ($this->acl_check_new(get_class($this), 'users', $member_id))
|
||
{
|
||
$grid->add_new_button('users/add/' . $member_id, __('Add new user'));
|
||
}
|
||
|
||
$grid->order_field('id')
|
||
->label('ID');
|
||
|
||
$grid->order_field('name');
|
||
|
||
$grid->order_field('surname');
|
||
|
||
$grid->order_field('login')
|
||
->label(__('Username'));
|
||
|
||
$actions = $grid->grouped_action_field();
|
||
|
||
if ($this->acl_check_view(get_class($this), 'users', $member_id))
|
||
{
|
||
$actions->add_action('id')
|
||
->icon_action('show')
|
||
->url('users/show');
|
||
}
|
||
|
||
if ($this->acl_check_edit(get_class($this), 'users', $member_id))
|
||
{
|
||
$actions->add_action('id')
|
||
->icon_action('edit')
|
||
->url('users/edit');
|
||
}
|
||
|
||
$grid->datasource($query);
|
||
|
||
// breadcrumbs navigation
|
||
$breadcrumbs = breadcrumbs::add()
|
||
->link('members/show_all', 'Members',
|
||
$this->acl_check_view('Members_Controller', 'members'))
|
||
->disable_translation()
|
||
->link('members/show/' . $member->id,
|
||
"ID $member->id - $member->name",
|
||
$this->acl_check_view(
|
||
'Members_Controller', 'members', $member->id
|
||
)
|
||
)->enable_translation()
|
||
->text('Users');
|
||
|
||
$view = new View('main');
|
||
$view->breadcrumbs = $breadcrumbs->html();
|
||
$view->title = __('List of users of member') . ' ' . $member->name;
|
||
$view->content = $grid;
|
||
$view->render(TRUE);
|
||
}
|
||
|
||
/**
|
||
* Function deletes user.
|
||
*
|
||
* @param integer $user_id
|
||
*/
|
||
public function delete($user_id = NULL)
|
||
{
|
||
if (!isset($user_id))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$user_model = new User_Model($user_id);
|
||
|
||
if (!$user_model || !$user_model->id)
|
||
Controller::error(RECORD);
|
||
|
||
$member_id = $user_model->member_id;
|
||
|
||
// access rights
|
||
if (!$this->acl_check_delete(get_class($this), 'users', $member_id))
|
||
Controller::error(ACCESS);
|
||
|
||
// 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::MAIN_USER)
|
||
{
|
||
status::warning('Primary user of member cannot be deleted.');
|
||
url::redirect($linkback);
|
||
}
|
||
|
||
if ($user_model->count_dependent_items($user_id) > 0)
|
||
{
|
||
status::warning('User cannot be deleted, he has some dependent items in database.');
|
||
url::redirect($linkback);
|
||
}
|
||
|
||
if ($user_model->delete())
|
||
{
|
||
status::success('User has been successfully deleted.');
|
||
}
|
||
else
|
||
{
|
||
status::error('Error - cant delete user.');
|
||
}
|
||
|
||
url::redirect($linkback);
|
||
} // end of delete function
|
||
|
||
/**
|
||
* Function edits user.
|
||
*
|
||
* @param integer $user_id
|
||
*/
|
||
public function edit($user_id = NULL)
|
||
{
|
||
if (!isset($user_id))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$user = new User_Model($user_id);
|
||
|
||
if (!$user->id)
|
||
Controller::error(RECORD);
|
||
|
||
$this->_user_id = $user_id;
|
||
|
||
//check if logged user have access right to edit this user
|
||
if(!$this->acl_check_edit(get_class($this),'users',$user->member_id))
|
||
Controller::error(ACCESS);
|
||
|
||
// check if user is not member-type and logged user have access right
|
||
// to edit member of user
|
||
if ($user->type != User_Model::MAIN_USER &&
|
||
$this->acl_check_edit(get_class($this),'member', $user->member_id))
|
||
{
|
||
$arr_members = ORM::factory('member')->select_list('id', 'name');
|
||
}
|
||
else
|
||
{
|
||
$arr_members[$user->member_id] = $user->member->name;
|
||
}
|
||
|
||
$form = new Forge('users/edit/'.$user_id);
|
||
|
||
$form->group('Basic information');
|
||
|
||
$form->dropdown('member_id')
|
||
->label(__('Member name').':')
|
||
->options($arr_members)
|
||
->selected($user->member_id);
|
||
|
||
if ($this->acl_check_edit(get_class($this),'login',$user->member_id))
|
||
{
|
||
$form->input('username')
|
||
->label(__('username').':')
|
||
->rules('required|length[3,50]')
|
||
->callback(array($this, 'valid_username'))
|
||
->value($user->login);
|
||
}
|
||
|
||
$form->input('pre_title')
|
||
->label(__('pre title').':')
|
||
->rules('length[3,40]')
|
||
->value($user->pre_title);
|
||
|
||
$form->input('name')
|
||
->label(__('name').':')
|
||
->rules('required|length[3,30]')
|
||
->value($user->name);
|
||
|
||
$form->input('middle_name')
|
||
->label(__('middle name').':')
|
||
->rules('length[3,30]')
|
||
->value($user->middle_name);
|
||
|
||
$form->input('surname')
|
||
->label(__('surname').':')
|
||
->rules('required|length[3,60]')
|
||
->value($user->surname);
|
||
|
||
$form->input('post_title')
|
||
->label(__('post title').':')
|
||
->rules('length[3,30]')
|
||
->value($user->post_title);
|
||
|
||
$form->group('Additional information');
|
||
|
||
$form->date('birthday')
|
||
->label(__('birthday').':')
|
||
->years(date('Y')-100, date('Y'))
|
||
->rules('required')
|
||
->value(strtotime($user->birthday));
|
||
|
||
if ($this->acl_check_edit(get_class($this),'comment',$user->member_id))
|
||
{
|
||
$form->textarea('comment')
|
||
->label(__('Comment').':')
|
||
->rules('length[0,250]')
|
||
->value($user->comment);
|
||
}
|
||
|
||
$form->submit('Edit');
|
||
|
||
special::required_forge_style($form, ' *', 'required');
|
||
|
||
if($form->validate())
|
||
{
|
||
$form_data = $form->as_array();
|
||
foreach($form_data as $key => $value)
|
||
{
|
||
$form_data[$key] = htmlspecialchars($value);
|
||
}
|
||
$user_data = new User_Model;
|
||
$user_data->find($user_id);
|
||
|
||
if ($this->acl_check_edit(get_class($this),'login',$user_data->member_id))
|
||
{
|
||
$user_data->login = $form_data['username'];
|
||
}
|
||
$user_data->birthday = date("Y-m-d",$form_data['birthday']);
|
||
$user_data->pre_title = $form_data['pre_title'];
|
||
$user_data->name = $form_data['name'];
|
||
$user_data->middle_name = $form_data['middle_name'];
|
||
$user_data->surname = $form_data['surname'];
|
||
$user_data->post_title = $form_data['post_title'];
|
||
|
||
if ($this->acl_check_edit(get_class($this),'comment',$user->member_id))
|
||
$user_data->comment = $form_data['comment'];
|
||
|
||
if ($user_data->save())
|
||
{
|
||
status::success('User has been successfully updated.');
|
||
}
|
||
else
|
||
{
|
||
status::error('Error - cant update user.');
|
||
}
|
||
$this->redirect('users/show/'.$user_id);
|
||
}
|
||
else
|
||
{
|
||
// breadcrumbs navigation
|
||
$breadcrumbs = breadcrumbs::add()
|
||
->link('members/show_all', 'Members',
|
||
$this->acl_check_view('Members_Controller','members'))
|
||
->disable_translation()
|
||
->link('members/show/' . $user->member->id,
|
||
"ID ".$user->member->id." - ".$user->member->name,
|
||
$this->acl_check_view(
|
||
'Members_Controller','members', $user->member->id
|
||
)
|
||
)->enable_translation()
|
||
->link('users/show_by_member/' . $user->member_id, 'Users',
|
||
$this->acl_check_view(
|
||
get_class($this), 'users', $user->member_id
|
||
)
|
||
)->disable_translation()
|
||
->link('users/show/'.$user->id,
|
||
"$user->name $user->surname ($user->login)",
|
||
$this->acl_check_view(
|
||
get_class($this),'users', $user->member_id
|
||
)
|
||
)->enable_translation()
|
||
->text('Edit');
|
||
|
||
$view = new View('main');
|
||
$view->title = __('Editing of user');
|
||
$view->breadcrumbs = $breadcrumbs->html();
|
||
$view->content = new View('form');
|
||
$view->content->headline = __('Editing of user').' '.$user->pre_title.
|
||
' '.$user->name.' '.$user->middle_name.
|
||
' '.$user->surname.' '.$user->post_title;
|
||
$view->content->form = $form->html();
|
||
$view->render(TRUE);
|
||
}
|
||
} // end of edit function
|
||
|
||
/**
|
||
* Function shows user.
|
||
*
|
||
* @param integer $user_id
|
||
*/
|
||
public function show($user_id = NULL)
|
||
{
|
||
if (!isset($user_id))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$user = new User_Model($user_id);
|
||
|
||
if (!$user->id)
|
||
Controller::error(RECORD);
|
||
|
||
if (!$this->acl_check_view(get_class($this), 'users', $user->member_id))
|
||
Controller::error(ACCESS);
|
||
|
||
$model_contacts = new Contact_Model();
|
||
$contacts = $model_contacts->find_all_users_contacts($user_id);
|
||
$enum_type_model = new Enum_type_Model();
|
||
$arr_contact_types = array();
|
||
|
||
foreach($contacts as $i => $contact)
|
||
{
|
||
$arr_contact_types[$i] = $enum_type_model->get_value($contact->type);
|
||
}
|
||
|
||
$voip_sip = new Voip_sip_Model();
|
||
$voip = $voip_sip->get_record_by_user_limited($user_id);
|
||
|
||
if ($voip->count() == 0)
|
||
{
|
||
$voip = '<span style="color:red;">'.__('Nonactive').'</span> - '
|
||
.html::anchor('voip/add/'.$user_id, __('Activate'));
|
||
}
|
||
else
|
||
{
|
||
$voip = html::anchor(
|
||
'voip/show/'.$voip->current()->user_id,
|
||
$voip->current()->name
|
||
);
|
||
}
|
||
|
||
$aro_groups = $user->get_aro_groups_of_user($user_id);
|
||
|
||
// grid with lis of users
|
||
$admin_devices_grid = new Grid('members', null, array
|
||
(
|
||
'separator' => '<br /><br />',
|
||
'use_paginator' => false,
|
||
'use_selector' => false,
|
||
));
|
||
|
||
if ($this->acl_check_new('Devices_Controller', 'admin'))
|
||
{
|
||
$admin_devices_grid->add_new_button(
|
||
'device_admins/edit_user/'.$user_id, __('Edit')
|
||
);
|
||
}
|
||
|
||
$admin_devices_grid->callback_field('device_id')
|
||
->label(__('Device'))
|
||
->callback('callback::device_field');
|
||
|
||
$admin_devices_grid->link_field('user_id')
|
||
->link('users/show', 'user_name')
|
||
->label('User');
|
||
|
||
if ($this->acl_check_delete('Devices_Controller', 'admin'))
|
||
{
|
||
$admin_devices_grid->grouped_action_field()
|
||
->add_action()
|
||
->icon_action('delete')
|
||
->url('device_admins/delete')
|
||
->label('Remove')
|
||
->class('delete_link');
|
||
}
|
||
|
||
$admin_devices_grid->datasource(
|
||
ORM::factory('device_admin')->get_all_devices_by_admin($user->id)
|
||
);
|
||
|
||
// grid with lis of users
|
||
$engineer_devices_grid = new Grid(url_lang::base().'members', null, array
|
||
(
|
||
'separator' => '<br /><br />',
|
||
'use_paginator' => false,
|
||
'use_selector' => false,
|
||
));
|
||
|
||
$engineer_devices_grid->callback_field('device_id')
|
||
->label(__('Device'))
|
||
->callback('callback::device_field');
|
||
|
||
$engineer_devices_grid->link_field('user_id')
|
||
->link('users/show', 'user_name')
|
||
->label('User');
|
||
|
||
if ($this->acl_check_delete('Devices_Controller', 'admin'))
|
||
{
|
||
$engineer_devices_grid->grouped_action_field()
|
||
->add_action()
|
||
->icon_action('delete')
|
||
->url('device_engineers/delete')
|
||
->label('Remove')
|
||
->class('delete_link');
|
||
}
|
||
|
||
$engineer_devices_grid->datasource(
|
||
ORM::factory('device_engineer')->get_all_devices_by_engineer($user->id)
|
||
);
|
||
|
||
// grid with lis of users
|
||
$comments_grid = new Grid('members', null, array
|
||
(
|
||
'separator' => '<br /><br />',
|
||
'use_paginator' => false,
|
||
'use_selector' => false,
|
||
));
|
||
|
||
$comments_grid->field('text')
|
||
->label(__('Comment'))
|
||
->class('comment');
|
||
|
||
$comments_grid->field('datetime')
|
||
->label(__('Time'));
|
||
|
||
$comments_grid->callback_field('type')
|
||
->label(__('To'))
|
||
->callback('callback::comment_to_field');
|
||
|
||
$actions = $comments_grid->grouped_action_field();
|
||
|
||
$actions->add_conditional_action()
|
||
->icon_action('edit')
|
||
->url('comments/edit')
|
||
->condition('is_own');
|
||
|
||
$actions->add_conditional_action()
|
||
->icon_action('delete')
|
||
->url('comments/delete')
|
||
->condition('is_own')
|
||
->class('delete_link');
|
||
|
||
$comments_grid->datasource(
|
||
ORM::factory('comment')->get_all_comments_by_user($user->id)
|
||
);
|
||
|
||
|
||
// breadcrumbs navigation
|
||
$breadcrumbs = breadcrumbs::add()
|
||
->link('members/show_all', 'Members',
|
||
$this->acl_check_view('Members_Controller','members'))
|
||
->disable_translation()
|
||
->link('members/show/' . $user->member->id,
|
||
"ID ".$user->member->id." - ".$user->member->name,
|
||
$this->acl_check_view(
|
||
'Members_Controller','members', $user->member->id
|
||
)
|
||
)->enable_translation()
|
||
->link('users/show_by_member/' . $user->member_id, 'Users',
|
||
$this->acl_check_view(
|
||
get_class($this), 'users', $user->member_id
|
||
)
|
||
)->text("$user->name $user->surname ($user->login)");
|
||
|
||
$view = new View('main');
|
||
$view->title = __('Display user');
|
||
$view->breadcrumbs = $breadcrumbs->html();
|
||
$view->content = new View('users/show');
|
||
$view->content->user_data = $user;
|
||
$view->content->contacts = $contacts;
|
||
$view->content->contact_types = $arr_contact_types;
|
||
$view->content->voip = $voip;
|
||
$view->content->aro_groups = $aro_groups;
|
||
$view->content->admin_devices_grid = $admin_devices_grid;
|
||
$view->content->engineer_devices_grid = $engineer_devices_grid;
|
||
$view->content->comments_grid = $comments_grid;
|
||
$view->render(TRUE);
|
||
} // end of show function
|
||
|
||
/**
|
||
* Function adds user.
|
||
*
|
||
* @param integer $member_id
|
||
*/
|
||
public function add($member_id = null)
|
||
{
|
||
if (!$member_id)
|
||
Controller::warning(PARAMETER);
|
||
|
||
if (!$this->acl_check_new(get_class($this),'users',$member_id))
|
||
Controller::error(ACCESS);
|
||
|
||
$member = new Member_Model($member_id);
|
||
|
||
$form = new Forge('users/add/'.$member_id);
|
||
|
||
$form->group('Basic information');
|
||
|
||
if ($this->acl_check_new(get_class($this), 'login', $member_id))
|
||
{
|
||
$form->input('username')
|
||
->label(__('username').':')
|
||
->rules('required|length[3,50]')
|
||
->callback(array($this, 'valid_username'));
|
||
}
|
||
|
||
$form->input('pre_title')
|
||
->label(__('pre title').':')
|
||
->rules('length[3,40]');
|
||
|
||
$form->input('name')
|
||
->label(__('name').':')
|
||
->rules('required|length[3,30]');
|
||
|
||
$form->input('middle_name')
|
||
->label(__('middle name').':')
|
||
->rules('length[3,30]');
|
||
|
||
$form->input('surname')
|
||
->label(__('surname').':')
|
||
->rules('required|length[3,60]');
|
||
|
||
$form->input('post_title')
|
||
->label(__('post title').':')
|
||
->rules('length[3,30]');
|
||
|
||
$form->group('')
|
||
->label(__('Password'));
|
||
|
||
$form->password('password')
|
||
->label(__('password').':')
|
||
->rules('required|length[3,50]')
|
||
->class('password');
|
||
|
||
$form->password('confirm_password')
|
||
->label(__('confirm password').':')
|
||
->rules('required|length[3,50]')
|
||
->matches($form->password);
|
||
|
||
$form->group('Additional information');
|
||
|
||
$form->date('birthday')
|
||
->label(__('birthday').':')
|
||
->years(date('Y')-100, date('Y'))
|
||
->rules('required');
|
||
|
||
if ($this->acl_check_new(get_class($this),'comment',$member_id))
|
||
{
|
||
$form->textarea('comment')
|
||
->label(__('Comment').':')
|
||
->rules('length[0,250]');
|
||
}
|
||
|
||
$form->submit('Add');
|
||
|
||
special::required_forge_style($form, ' *', 'required');
|
||
|
||
if ($form->validate())
|
||
{
|
||
$form_data = array_map('htmlspecialchars', $form->as_array());
|
||
|
||
$user_data = new User_Model;
|
||
$user_data->birthday = date("Y-m-d",$form_data['birthday']);
|
||
$user_data->login = $form_data['username'];
|
||
$user_data->password = sha1($form_data['password']);
|
||
$user_data->pre_title = $form_data['pre_title'];
|
||
$user_data->name = $form_data['name'];
|
||
$user_data->middle_name = $form_data['middle_name'];
|
||
$user_data->surname = $form_data['surname'];
|
||
$user_data->post_title = $form_data['post_title'];
|
||
|
||
if (isset($form_data['comment']))
|
||
$user_data->comment = $form_data['comment'];
|
||
|
||
$user_data->type = User_Model::USER;
|
||
$user_data->member_id = $member_id;
|
||
$user_data->application_password = security::generate_password();
|
||
$saved = $user_data->save();
|
||
|
||
// insert users access rights
|
||
$groups_aro_map = new Groups_aro_map_Model();
|
||
$groups_aro_map->aro_id = $user_data->id;
|
||
$groups_aro_map->group_id = Aro_group_Model::REGULAR_MEMBERS;
|
||
$saved = $saved && $groups_aro_map->save();
|
||
|
||
unset($form_data);
|
||
|
||
if ($saved)
|
||
{
|
||
// send welcome message to user
|
||
$mail_message = new Mail_message_Model();
|
||
$mail_message->from_id = 1;
|
||
$mail_message->to_id = $user_data->id;
|
||
$mail_message->subject = mail_message::format('welcome_subject');
|
||
$mail_message->body = mail_message::format('welcome');
|
||
$mail_message->time = date('Y-m-d H:i:s');
|
||
$mail_message->from_deleted = 1;
|
||
$mail_message->save();
|
||
|
||
status::success('User has been successfully added.');
|
||
}
|
||
else
|
||
{
|
||
status::error('Error - cant add new user.');
|
||
}
|
||
url::redirect('members/show/'.$member_id);
|
||
}
|
||
else
|
||
{
|
||
// breadcrumbs navigation
|
||
$breadcrumbs = breadcrumbs::add()
|
||
->link('members/show_all', 'Members',
|
||
$this->acl_check_view('Members_Controller','members'))
|
||
->disable_translation()
|
||
->link('members/show/' . $member->id,
|
||
"ID ".$member->id." - ".$member->name,
|
||
$this->acl_check_view(
|
||
'Members_Controller','members', $member->id
|
||
)
|
||
)->enable_translation()
|
||
->link('users/show_by_member/' . $member_id, 'Users',
|
||
$this->acl_check_view(
|
||
get_class($this), 'users', $member_id
|
||
)
|
||
)->text('Add');
|
||
|
||
$view = new View('main');
|
||
$view->title = __('Add new user');
|
||
$view->breadcrumbs = $breadcrumbs->html();
|
||
$view->content = new View('form');
|
||
$view->content->headline = __('Add new user');
|
||
$view->content->link_back = '';
|
||
$view->content->form = $form->html();
|
||
$view->render(TRUE);
|
||
}
|
||
|
||
} // end of add function
|
||
|
||
/**
|
||
* Shows works of user
|
||
*
|
||
* @author Michal Kliment
|
||
* @param integer $work_id
|
||
*/
|
||
public function show_work ($work_id = NULL)
|
||
{
|
||
Works_Controller::show ($work_id);
|
||
}
|
||
|
||
/**
|
||
* Callback for type field
|
||
*
|
||
* @author Ondřej Fibich
|
||
* @staticvar string $enum_type_model
|
||
* @param Contact_Model $item
|
||
* @param string $name
|
||
*/
|
||
protected static function additional_contacts_type_callback($item, $name)
|
||
{
|
||
static $enum_type_model = NULL;
|
||
|
||
if ($enum_type_model == NULL)
|
||
{
|
||
$enum_type_model = new Enum_type_Model();
|
||
}
|
||
|
||
echo $enum_type_model->get_value($item->type);
|
||
}
|
||
|
||
/**
|
||
* Function changes password of user.
|
||
*
|
||
* @param integer $user_id
|
||
*/
|
||
public function change_password($user_id = null)
|
||
{
|
||
if (!isset($user_id))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$user = new User_Model($user_id);
|
||
|
||
if (!$user->id)
|
||
Controller::error(RECORD);
|
||
|
||
// access control
|
||
if (!$this->acl_check_edit(get_class($this), 'password', $user->member_id))
|
||
Controller::error(ACCESS);
|
||
|
||
$this->_user_id = $user_id;
|
||
|
||
$form = new Forge('users/change_password/' . $user_id);
|
||
|
||
// check if logged user has right to edit all passwords except his own
|
||
if (!$this->acl_check_edit(get_class($this), 'password') ||
|
||
$user->id == $this->session->get('user_id'))
|
||
{
|
||
$form->password('oldpassword')
|
||
->label(__('Old password') . ':')
|
||
->rules('required|length[3,50]')
|
||
->callback(array($this, 'check_password'));
|
||
}
|
||
|
||
$form->password('password')
|
||
->label(__('New password') . ': ' . help::hint('password'))
|
||
->rules('required|length[6,50]')
|
||
->class('password');
|
||
|
||
$form->password('confirm_password')
|
||
->label(__('Confirm new password') . ':')
|
||
->rules('required|length[6,50]')
|
||
->matches($form->password);
|
||
|
||
$form->submit('submit')
|
||
->value(__('Change'));
|
||
|
||
special::required_forge_style($form, ' *', 'required');
|
||
|
||
if ($form->validate())
|
||
{
|
||
$form_data = $form->as_array();
|
||
$user = new User_Model($user_id);
|
||
$user->set_logger(FALSE);
|
||
$user->password = sha1($form_data['password']);
|
||
|
||
if ($user->save())
|
||
{
|
||
status::success('Password has been successfully changed.');
|
||
}
|
||
else
|
||
{
|
||
status::error('Error - cant change password.');
|
||
}
|
||
|
||
$this->redirect('users/change_password/' . $user->id);
|
||
}
|
||
else
|
||
{
|
||
// breadcrumbs navigation
|
||
$breadcrumbs = breadcrumbs::add()
|
||
->link('members/show_all', 'Members',
|
||
$this->acl_check_view('Members_Controller','members'))
|
||
->disable_translation()
|
||
->link('members/show/' . $user->member->id,
|
||
"ID ".$user->member->id." - ".$user->member->name,
|
||
$this->acl_check_view(
|
||
'Members_Controller','members',
|
||
$user->member->id
|
||
)
|
||
)->enable_translation()
|
||
->link('users/show_by_member/' . $user->member_id, 'Users',
|
||
$this->acl_check_view(
|
||
get_class($this), 'users', $user->member_id
|
||
)
|
||
)->disable_translation()
|
||
->link('users/show/'.$user->id,
|
||
"$user->name $user->surname ($user->login)",
|
||
$this->acl_check_view(
|
||
get_class($this),'users', $user->member_id
|
||
)
|
||
)->enable_translation()
|
||
->text('Change password');
|
||
|
||
$view = new View('main');
|
||
$view->title = __('Change password');
|
||
$view->breadcrumbs = $breadcrumbs->html();
|
||
$view->content = new View('form');
|
||
$view->content->headline = __('Change password');
|
||
$view->content->link_back = '';
|
||
$view->content->form = $form->html();
|
||
$view->render(TRUE);
|
||
}
|
||
} // end of change password function
|
||
|
||
/**
|
||
* Function changes application password of user.
|
||
*
|
||
* @param integer $user_id
|
||
*/
|
||
public function change_application_password($user_id = null)
|
||
{
|
||
if (!isset($user_id))
|
||
Controller::warning(PARAMETER);
|
||
|
||
$user = new User_Model($user_id);
|
||
|
||
if (!$user->id)
|
||
Controller::error(RECORD);
|
||
|
||
// access control
|
||
if (!$this->acl_check_edit(
|
||
get_class($this), 'application_password', $user->member_id
|
||
))
|
Také k dispozici: Unified diff
Zalozeni pokusne vetve pro budouci ovladani zarizeni. Mam tady nejake pokusy - potrebuji to nekam commitnout at to neztratim...