public function add_delegate(int $account_id, $org_unit_id, $org_name)
{
$config = CreateObject('phpgwapi.config', 'rental');
$config->read();
$use_fellesdata = $config->config_data['use_fellesdata'];
if (!isset($account_id) || $account_id == '' && $use_fellesdata) {
//User is only registered in Fellesdata
$username = phpgw::get_var('username');
$firstname = phpgw::get_var('firstname');
$lastname = phpgw::get_var('lastname');
$password = '******';
$account_id = frontend_bofrontend::create_delegate_account($username, $firstname, $lastname, $password);
if (isset($account_id) && !is_numeric($account_id)) {
return false;
}
}
$success = frontend_bofrontend::add_delegate($account_id, null, $org_unit_id, $org_name);
if ($success) {
//Retrieve the usernames
$user_account = $GLOBALS['phpgw']->accounts->get($account_id);
$owner_account = $GLOBALS['phpgw']->accounts->get($GLOBALS['phpgw_info']['user']['account_id']);
$user_name = $user_account->__get('lid');
$owner_name = $owner_account->__get('lid');
$org_name_string = $org_name;
//If the usernames are set retrieve account data from Fellesdata
if (isset($user_name) && $user_name != '' && $owner_name && $owner_name != '' && $use_fellesdata) {
$fellesdata_user = frontend_bofellesdata::get_instance()->get_user($user_name);
$fellesdata_owner = frontend_bofellesdata::get_instance()->get_user($owner_name);
if ($fellesdata_user && $fellesdata_owner) {
//Send email notification to delegate
$email = $fellesdata_user['email'];
if (isset($email) && $email != '') {
$title = lang('email_add_delegate_title');
$message = lang('email_add_delegate_message', $fellesdata_user['firstname'], $fellesdata_user['lastname'], $fellesdata_owner['firstname'], $fellesdata_owner['lastname'], $org_name_string);
frontend_bofrontend::send_system_message($email, $title, $message);
return true;
}
}
}
}
return false;
}
public function index()
{
$config = CreateObject('phpgwapi.config', 'rental');
$config->read();
$use_fellesdata = $config->config_data['use_fellesdata'];
if (isset($_POST['search'])) {
$username = phpgw::get_var('username');
if (!isset($username)) {
$msglog['error'][] = array('msg' => lang('lacking_username'));
} else {
if ($username == $GLOBALS['phpgw_info']['user']['account_lid']) {
$msglog['error'][] = array('msg' => lang('searching_for_self'));
} else {
$account_id = frontend_bofrontend::delegate_exist($username);
if ($account_id) {
$search = frontend_bofrontend::get_account_info($account_id);
$msglog['message'][] = array('msg' => lang('user_found_in_PE'));
} else {
if ($use_fellesdata) {
$fellesdata_user = frontend_bofellesdata::get_instance()->get_user($username);
if ($fellesdata_user) {
$search = $fellesdata_user;
$msglog['message'][] = array('msg' => lang('user_found_in_Fellesdata'));
}
} else {
$msglog['error'][] = array('msg' => lang('no_hits'));
}
}
}
}
} else {
if (isset($_POST['add'])) {
$account_id = phpgw::get_var('account_id');
$success = false;
if ($use_fellesdata) {
$org_units = frontend_bofellesdata::get_instance()->get_result_units($GLOBALS['phpgw_info']['user']['account_lid']);
//Parameter to delegate access to only a single organisational unit
$org_unit_id = $this->header_state['selected_org_unit'];
$success = true;
foreach ($org_units as $org_unit) {
if ($org_unit_id == 'all' || $org_unit['ORG_UNIT_ID'] == $org_unit_id) {
//$curr_success = true;
$res = $this->add_delegate($account_id, $org_unit['ORG_UNIT_ID'], $org_unit['ORG_NAME']);
if ($res) {
//$mail_contents[] = $res;
$org_unit_names[] = $org_unit['ORG_NAME'];
} else {
$msglog['error'][] = array('msg' => lang('error_delegating_unit', $org_unit['ORG_NAME']));
}
$success = $success && $res;
}
}
}
if ($success) {
//Retrieve the usernames
$user_account = $GLOBALS['phpgw']->accounts->get($account_id);
$owner_account = $GLOBALS['phpgw']->accounts->get($GLOBALS['phpgw_info']['user']['account_id']);
$user_name = $user_account->__get('lid');
$owner_name = $owner_account->__get('lid');
$org_name_string = implode(',', $org_unit_names);
//If the usernames are set retrieve account data from Fellesdata
if (isset($user_name) && $user_name != '' && $owner_name && $owner_name != '') {
$fellesdata_user = frontend_bofellesdata::get_instance()->get_user($user_name);
$fellesdata_owner = frontend_bofellesdata::get_instance()->get_user($owner_name);
if ($fellesdata_user && $fellesdata_owner) {
//Send email notification to delegate
$email = $fellesdata_user['email'];
if (isset($email) && $email != '') {
$title = lang('email_add_delegate_title');
$message = lang('email_add_delegate_message', $fellesdata_user['firstname'], $fellesdata_user['lastname'], $fellesdata_owner['firstname'], $fellesdata_owner['lastname'], $org_name_string);
frontend_bofrontend::send_system_message($email, $title, $message);
}
}
}
$msglog['message'][] = array('msg' => lang('delegation_successful'));
/*
//send e-mail to user
$user_account = $GLOBALS['phpgw']->accounts->get($account_id);
$user_name = $user_account->__get('lid');
$fellesdata_user = frontend_bofellesdata::get_instance()->get_user($user_name);
if($fellesdata_user)
{
$email = $fellesdata_user['email'];
if(isset($email) && $email != '')
{
$title = lang('email_add_delegate_title');
$mail_content = implode(',',$mail_contents);
frontend_bofrontend::send_system_message($email,$title,$mail_content);
}
}*/
} else {
$msglog['error'][] = array('msg' => lang('delegation_error'));
}
} else {
if (isset($_POST['remove'])) {
$account_id = phpgw::get_var('account_id');
$result = frontend_bofrontend::remove_delegate($account_id, null, null);
if ($result) {
$msglog['message'][] = array('msg' => lang('remove_delegate_successful'));
} else {
$msglog['error'][] = array('msg' => lang('remove_delegate_error'));
}
} else {
if (isset($_POST['remove_specific'])) {
$account_id = phpgw::get_var('account_id');
//Parameter to delegate access to only a single organisational unit
$org_unit_id = $this->header_state['selected_org_unit'];
$result = frontend_bofrontend::remove_delegate($account_id, null, $org_unit_id);
if ($result) {
$msglog['message'][] = array('msg' => lang('remove_delegate_successful'));
} else {
$msglog['error'][] = array('msg' => lang('remove_delegate_error'));
}
}
}
}
}
$form_action = $GLOBALS['phpgw']->link('/index.php', array('menuaction' => 'frontend.uidelegates.index'));
$delegates_per_org_unit = frontend_bofrontend::get_delegates($this->header_state['selected_org_unit']);
$delegates_per_user = frontend_bofrontend::get_delegates(null, true);
$number_of_delegates = count($delegates_per_org_unit);
$number_of_user_delegates = count($delegates_per_user);
$config = CreateObject('phpgwapi.config', 'frontend');
$config->read();
$delegateLimit = $config->config_data['delegate_limit'];
if (!is_numeric($delegateLimit)) {
$delegateLimit = 3;
}
$error_message = lang('max_x_delegates', $delegateLimit);
$data = array('header' => $this->header_state, 'tabs' => $this->tabs, 'delegate_data' => array('form_action' => $form_action, 'delegate' => $delegates_per_org_unit, 'user_delegate' => $delegates_per_user, 'number_of_delegates' => isset($number_of_delegates) ? $number_of_delegates : 0, 'number_of_user_delegates' => isset($number_of_user_delegates) ? $number_of_user_delegates : 0, 'search' => isset($search) ? $search : array(), 'msgbox_data' => $GLOBALS['phpgw']->common->msgbox($GLOBALS['phpgw']->common->msgbox_data($msglog)), 'delegate_limit' => $delegateLimit, 'error_message' => $error_message));
$GLOBALS['phpgw']->xslttpl->set_var('phpgw', array('app_data' => $data));
$GLOBALS['phpgw']->xslttpl->add_file(array('frontend', 'delegate'));
}
/**
* Remove a delegate
* @param $account_id the delegate
* @param $owner_id the person who has delegated
* @param $org_unit_id the organisational unit in question
*/
public static function remove_delegate(int $account_id, int $owner_id, int $org_unit_id)
{
if (!isset($owner_id)) {
$owner_id = $GLOBALS['phpgw_info']['user']['account_id'];
}
// The location
$location_id = $GLOBALS['phpgw']->locations->get_id('frontend', '.');
// If a specific organisational unit
if (isset($org_unit_id)) {
$sql = "DELETE FROM phpgw_account_delegates WHERE account_id = {$account_id} AND data = '{$org_unit_id}' AND location_id = {$location_id}";
} else {
// The owner id is the current user if not set
$sql = "DELETE FROM phpgw_account_delegates WHERE account_id = {$account_id} AND owner_id = {$owner_id} AND location_id = {$location_id}";
}
$db = clone $GLOBALS['phpgw']->db;
$db->Halt_On_Error = 'no';
$result = $db->query($sql, __LINE__, __FILE__);
if ($result && $db->affected_rows() > 0) {
$user_account = $GLOBALS['phpgw']->accounts->get($account_id);
$owner_account = $GLOBALS['phpgw']->accounts->get($owner_id);
$user_name = $user_account->__get('lid');
$owner_name = $owner_account->__get('lid');
if (isset($user_name) && $user_name != '' && $owner_name && $owner_name != '') {
$fellesdata_user = frontend_bofellesdata::get_instance()->get_user($user_name);
$fellesdata_owner = frontend_bofellesdata::get_instance()->get_user($owner_name);
if ($fellesdata_user && $fellesdata_owner) {
$email = $fellesdata_user['email'];
if (isset($email) && $email != '') {
$title = lang('email_remove_delegate_title');
$message = lang('email_remove_delegate_message', $fellesdata_user['firstname'], $fellesdata_user['lastname'], $fellesdata_owner['firstname'], $fellesdata_owner['lastname']);
frontend_bofrontend::send_system_message($email, $title, $message);
}
}
}
return true;
}
return false;
}
