}
$member = new TableMembers($gDb);
$sql = 'SELECT mem_id, mem_rol_id, mem_usr_id, mem_begin, mem_end, mem_leader
FROM ' . TBL_ROLES . ', ' . TBL_CATEGORIES . ', ' . TBL_MEMBERS . '
WHERE rol_valid = 1
AND rol_cat_id = cat_id
AND ( cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
OR cat_org_id IS NULL )
AND mem_rol_id = rol_id
AND mem_begin <= \'' . DATE_NOW . '\'
AND mem_end > \'' . DATE_NOW . '\'
AND mem_usr_id = ' . $getUserId;
$mglStatement = $gDb->query($sql);
while ($row = $mglStatement->fetch()) {
// alle Rollen der aktuellen Gliedgemeinschaft auf ungueltig setzen
$member->setArray($row);
$member->stopMembership($row['mem_rol_id'], $row['mem_usr_id']);
}
$gMessage->setForwardUrl($gNavigation->getUrl(), 2000);
$gMessage->show($gL10n->get('MEM_REMOVE_MEMBERSHIP_OK', $gCurrentOrganization->getValue('org_longname')));
} elseif ($getMode === 3) {
// User aus der Datenbank loeschen
// nur Webmaster duerfen dies
if (!$gCurrentUser->isWebmaster()) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// User darf in keiner anderen Orga aktiv sein
// kein Suizid ermoeglichen
if ($other_orga > 0 || $gCurrentUser->getValue('usr_id') == $getUserId) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
/**
* Create a new membership to a role for the current user. If the date range contains
* a future or past membership of the same role then the two memberships will be merged.
* In opposite to setRoleMembership this method can't be used to end a membership earlier!
* @param int $roleId Id of the role for which the membership should be set.
* @param string $startDate Start date of the membership. Default will be @b DATE_NOW.
* @param string $endDate End date of the membership. Default will be @b 31.12.9999
* @param bool|string $leader If set to @b 1 then the member will be leader of the role and
* might get more rights for this role.
* @return bool Return @b true if the membership was successfully added.
*/
public function setRoleMembership($roleId, $startDate = DATE_NOW, $endDate = '9999-12-31', $leader = '')
{
$minStartDate = $startDate;
$maxEndDate = $endDate;
$member = new TableMembers($this->db);
if ($startDate === '' || $endDate === '') {
return false;
}
$this->db->startTransaction();
// subtract 1 day from start date so that we find memberships that ends yesterday
// these memberships can be continued with new date
$oneDayDateInterval = new DateInterval('P1D');
$startDate = DateTime::createFromFormat('Y-m-d', $startDate)->sub($oneDayDateInterval)->format('Y-m-d');
// add 1 to max date because we subtract one day if a membership ends
if ($endDate !== '9999-12-31') {
$endDate = DateTime::createFromFormat('Y-m-d', $endDate)->add($oneDayDateInterval)->format('Y-m-d');
}
// search for membership with same role and user and overlapping dates
$sql = 'SELECT *
FROM ' . TBL_MEMBERS . '
WHERE mem_rol_id = ' . $roleId . '
AND mem_usr_id = ' . $this->getValue('usr_id') . '
AND mem_begin <= \'' . $endDate . '\'
AND mem_end >= \'' . $startDate . '\'
ORDER BY mem_begin ASC';
$membershipStatement = $this->db->query($sql);
if ($membershipStatement->rowCount() === 1) {
// one record found than update this record
$row = $membershipStatement->fetch();
$member->setArray($row);
// save new start date if an earlier date exists
if (strcmp($minStartDate, $member->getValue('mem_begin', 'Y-m-d')) > 0) {
$minStartDate = $member->getValue('mem_begin', 'Y-m-d');
}
// save new end date if an later date exists
// but only if end date is greater than the begin date otherwise the membership should be deleted
if (strcmp($member->getValue('mem_end', 'Y-m-d'), $maxEndDate) > 0 && strcmp($member->getValue('mem_begin', 'Y-m-d'), $maxEndDate) < 0) {
$maxEndDate = $member->getValue('mem_end', 'Y-m-d');
}
} elseif ($membershipStatement->rowCount() > 1) {
// several records found then read min and max date and delete all records
while ($row = $membershipStatement->fetch()) {
$member->clear();
$member->setArray($row);
// save new start date if an earlier date exists
if (strcmp($minStartDate, $member->getValue('mem_begin', 'Y-m-d')) > 0) {
$minStartDate = $member->getValue('mem_begin', 'Y-m-d');
}
// save new end date if an later date exists
if (strcmp($member->getValue('mem_end', 'Y-m-d'), $maxEndDate) > 0) {
$maxEndDate = $member->getValue('mem_end', 'Y-m-d');
}
// delete existing entry because a new overlapping entry will be created
$member->delete();
}
$member->clear();
}
if (strcmp($minStartDate, $maxEndDate) > 0) {
// if start date is greater than end date than delete membership
if ($member->getValue('mem_id') > 0) {
$member->delete();
}
$returnStatus = true;
} else {
// save membership to database
$member->setValue('mem_rol_id', $roleId);
$member->setValue('mem_usr_id', $this->getValue('usr_id'));
$member->setValue('mem_begin', $minStartDate);
$member->setValue('mem_end', $maxEndDate);
if ($leader !== '') {
$member->setValue('mem_leader', $leader);
}
$returnStatus = $member->save();
}
$this->db->endTransaction();
$this->renewRoleData();
return $returnStatus;
}
function getRoleMemberships($htmlListId, $user, $result_role, $count_role, $directOutput)
{
global $gDb, $gL10n, $gCurrentUser, $gPreferences, $g_root_path, $gProfileFields;
$countShowRoles = 0;
$member = new TableMembers($gDb);
$role = new TableRoles($gDb);
$roleMemHTML = '<ul class="list-group admidio-list-roles-assign" id="' . $htmlListId . '">';
while ($row = $gDb->fetch_array($result_role)) {
if ($gCurrentUser->hasRightViewRole($row['mem_rol_id']) && $row['rol_visible'] == 1) {
$formerMembership = false;
$futureMembership = false;
$showRoleEndDate = false;
$deleteMode = 'pro_role';
$member->clear();
$member->setArray($row);
$role->clear();
$role->setArray($row);
// if membership will not end, then don't show end date
if (strcmp($member->getValue('mem_end', 'Y-m-d'), '9999-12-31') != 0) {
$showRoleEndDate = true;
}
// check if membership ends in the past
if (strcmp(DATE_NOW, $member->getValue('mem_end', 'Y-m-d')) > 0) {
$formerMembership = true;
$deleteMode = 'pro_former';
}
// check if membership starts in the future
if (strcmp($member->getValue('mem_begin', 'Y-m-d'), DATE_NOW) > 0) {
$futureMembership = true;
$deleteMode = 'pro_future';
}
// create list entry for one role
$roleMemHTML .= '
<li class="list-group-item" id="role_' . $row['mem_rol_id'] . '">
<ul class="list-group admidio-list-roles-assign-pos">
<li class="list-group-item">
<span>' . $role->getValue('cat_name') . ' - ';
if ($gCurrentUser->hasRightViewRole($member->getValue('mem_rol_id'))) {
$roleMemHTML .= '<a href="' . $g_root_path . '/adm_program/modules/lists/lists_show.php?mode=html&rol_id=' . $member->getValue('mem_rol_id') . '" title="' . $role->getValue('rol_description') . '">' . $role->getValue('rol_name') . '</a>';
} else {
echo $role->getValue('rol_name');
}
if ($member->getValue('mem_leader') == 1) {
$roleMemHTML .= ' - ' . $gL10n->get('SYS_LEADER');
}
$roleMemHTML .= '
</span>
<span class="pull-right text-right">';
if ($showRoleEndDate == true) {
$roleMemHTML .= $gL10n->get('SYS_SINCE_TO', $member->getValue('mem_begin', $gPreferences['system_date']), $member->getValue('mem_end', $gPreferences['system_date']));
} elseif ($futureMembership == true) {
$roleMemHTML .= $gL10n->get('SYS_FROM', $member->getValue('mem_begin', $gPreferences['system_date']));
} else {
$roleMemHTML .= $gL10n->get('SYS_SINCE', $member->getValue('mem_begin', $gPreferences['system_date']));
}
if ($role->allowedToAssignMembers($gCurrentUser)) {
// You are not allowed to delete your own webmaster membership, other roles could be deleted
if ($role->getValue('rol_webmaster') == 1 && $gCurrentUser->getValue('usr_id') != $user->getValue('usr_id') || $role->getValue('rol_webmaster') == 0) {
$roleMemHTML .= '
<a class="admidio-icon-link" data-toggle="modal" data-target="#admidio_modal"
href="' . $g_root_path . '/adm_program/system/popup_message.php?type=' . $deleteMode . '&element_id=role_' . $role->getValue('rol_id') . '&database_id=' . $member->getValue('mem_id') . '&name=' . urlencode($role->getValue('rol_name')) . '"><img
src="' . THEME_PATH . '/icons/delete.png" alt="' . $gL10n->get('PRO_CANCEL_MEMBERSHIP') . '" title="' . $gL10n->get('PRO_CANCEL_MEMBERSHIP') . '" /></a>';
} else {
$roleMemHTML .= '
<a class="admidio-icon-link"><img src="' . THEME_PATH . '/icons/dummy.png" alt=""/></a>';
}
// do not edit webmaster role
if ($row['rol_webmaster'] == 0) {
$roleMemHTML .= '<a class="admidio-icon-link" style="cursor:pointer;" onclick="profileJS.toggleDetailsOn(' . $member->getValue('mem_id') . ')"><img
src="' . THEME_PATH . '/icons/edit.png" alt="' . $gL10n->get('PRO_CHANGE_DATE') . '" title="' . $gL10n->get('PRO_CHANGE_DATE') . '" /></a>';
} else {
$roleMemHTML .= '<a class="admidio-icon-link"><img src="' . THEME_PATH . '/icons/dummy.png" alt=""/></a>';
}
}
// only show info if system setting is activated
if ($gPreferences['system_show_create_edit'] > 0) {
$roleMemHTML .= '<a class="admidio-icon-link admMemberInfo" id="member_info_' . $member->getValue('mem_id') . '" href="javascript:"><img src="' . THEME_PATH . '/icons/info.png" alt="' . $gL10n->get('SYS_INFORMATIONS') . '" title="' . $gL10n->get('SYS_INFORMATIONS') . '"/></a>';
}
$roleMemHTML .= '</span>
</li>
<li class="list-group-item" id="membership_period_' . $member->getValue('mem_id') . '" style="visibility: hidden; display: none;"><div class="collapse navbar-collapse">';
$form = new HtmlForm('membership_period_form_' . $member->getValue('mem_id'), $g_root_path . '/adm_program/modules/profile/profile_function.php?mode=7&user_id=' . $user->getValue('usr_id') . '&mem_id=' . $row['mem_id'], null, array('type' => 'navbar', 'setFocus' => false, 'class' => 'admidio-form-membership-period'));
$form->addInput('membership_start_date_' . $member->getValue('mem_id'), $gL10n->get('SYS_START'), $member->getValue('mem_begin', $gPreferences['system_date']), array('type' => 'date', 'maxLength' => 10));
$form->addInput('membership_end_date_' . $member->getValue('mem_id'), $gL10n->get('SYS_END'), $member->getValue('mem_end', $gPreferences['system_date']), array('type' => 'date', 'maxLength' => 10));
$form->addSubmitButton('btn_send_' . $member->getValue('mem_id'), $gL10n->get('SYS_OK'));
$roleMemHTML .= $form->show(false);
$roleMemHTML .= '</div></li>
<li class="list-group-item" id="member_info_' . $member->getValue('mem_id') . '_Content" style="display: none;">';
// show informations about user who creates the recordset and changed it
$roleMemHTML .= admFuncShowCreateChangeInfoById($member->getValue('mem_usr_id_create'), $member->getValue('mem_timestamp_create'), $member->getValue('mem_usr_id_change'), $member->getValue('mem_timestamp_change')) . '
</li>
</ul>
</li>';
$countShowRoles++;
}
}
if ($countShowRoles == 0) {
$roleMemHTML = '<div class="block-padding">' . $gL10n->get('PRO_NO_ROLES_VISIBLE') . '</div>';
} else {
$roleMemHTML .= '</ul>';
}
if ($directOutput) {
echo $roleMemHTML;
return '';
} else {
return $roleMemHTML;
}
}
