$role->delete();
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
} elseif ($_POST['date_registration_possible'] == 0 && $date->getValue('dat_rol_id') > 0) {
// date participation was deselected -> delete flag in event and than delete role
$role = new TableRoles($gDb, $date->getValue('dat_rol_id'));
$date->setValue('dat_rol_id', '');
$date->save();
$role->delete();
} elseif ($_POST['date_registration_possible'] == 1 && $date->getValue('dat_rol_id') > 0) {
// if event exists and you could register to this event then we must check
// if the data of the role must be changed
$role = new TableRoles($gDb, $date->getValue('dat_rol_id'));
$roleName = $gL10n->get('DAT_DATE') . ' ' . $date->getValue('dat_begin', 'Y-m-d H:i') . ' - ' . $date->getValue('dat_id');
if ($role->getValue('rol_max_members') != $date->getValue('dat_max_members') || $role->getValue('role_name' != $roleName)) {
$role->setValue('rol_name', $roleName);
$role->setValue('rol_max_members', $date->getValue('dat_max_members'));
$role->save();
}
}
// check if flag is set that current user wants to participate as leader to the date
if (isset($_POST['date_current_user_assigned']) && $_POST['date_current_user_assigned'] == 1 && $gCurrentUser->isLeaderOfRole($date->getValue('dat_rol_id')) == false) {
// user wants to participate -> add him to date
$member = new TableMembers($gDb);
$member->startMembership($role->getValue('rol_id'), $gCurrentUser->getValue('usr_id'), 1);
} elseif (isset($_POST['date_current_user_assigned']) == false && $gCurrentUser->isMemberOfRole($date->getValue('dat_rol_id')) == true) {
// user does't want to participate as leader -> remove his participation as leader from the event,
// dont remove the participation itself!
$member = new TableMembers($gDb);
$member->readDataByColumns(array('mem_rol_id' => $role->getValue('rol_id'), 'mem_usr_id' => $gCurrentUser->getValue('usr_id')));
$member->setValue('mem_leader', 0);
/** Creates all necessary data for a new organization. This method can only be
* called once for an organization. It will create the basic categories, lists,
* roles, systemmails etc.
* @param $userId The id of the webmaster who creates the new organization.
* This will be the first valid user of the new organization.
*/
public function createBasicData($userId)
{
global $gL10n, $gProfileFields;
// read id of system user from database
$sql = 'SELECT usr_id FROM ' . TBL_USERS . '
WHERE usr_login_name LIKE \'' . $gL10n->get('SYS_SYSTEM') . '\' ';
$this->db->query($sql);
$row = $this->db->fetch_array();
$systemUserId = $row['usr_id'];
// create all systemmail texts and write them into table adm_texts
$systemmailsTexts = array('SYSMAIL_REGISTRATION_USER' => $gL10n->get('SYS_SYSMAIL_REGISTRATION_USER'), 'SYSMAIL_REGISTRATION_WEBMASTER' => $gL10n->get('SYS_SYSMAIL_REGISTRATION_WEBMASTER'), 'SYSMAIL_REFUSE_REGISTRATION' => $gL10n->get('SYS_SYSMAIL_REFUSE_REGISTRATION'), 'SYSMAIL_NEW_PASSWORD' => $gL10n->get('SYS_SYSMAIL_NEW_PASSWORD'), 'SYSMAIL_ACTIVATION_LINK' => $gL10n->get('SYS_SYSMAIL_ACTIVATION_LINK'));
$text = new TableText($this->db);
foreach ($systemmailsTexts as $key => $value) {
// convert <br /> to a normal line feed
$value = preg_replace('/<br[[:space:]]*\\/?[[:space:]]*>/', chr(13) . chr(10), $value);
$text->clear();
$text->setValue('txt_org_id', $this->getValue('org_id'));
$text->setValue('txt_name', $key);
$text->setValue('txt_text', $value);
$text->save();
}
// create default category for roles, events and weblinks
$sql = 'INSERT INTO ' . TBL_CATEGORIES . ' (cat_org_id, cat_type, cat_name_intern, cat_name, cat_hidden, cat_default, cat_sequence, cat_usr_id_create, cat_timestamp_create)
VALUES (' . $this->getValue('org_id') . ', \'ROL\', \'COMMON\', \'SYS_COMMON\', 0, 1, 1, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')';
$this->db->query($sql);
$categoryCommon = $this->db->insert_id();
$sql = 'INSERT INTO ' . TBL_CATEGORIES . ' (cat_org_id, cat_type, cat_name_intern, cat_name, cat_hidden, cat_default, cat_system, cat_sequence, cat_usr_id_create, cat_timestamp_create)
VALUES (' . $this->getValue('org_id') . ', \'ROL\', \'GROUPS\', \'INS_GROUPS\', 0, 0, 0, 2, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'ROL\', \'COURSES\', \'INS_COURSES\', 0, 0, 0, 3, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'ROL\', \'TEAMS\', \'INS_TEAMS\', 0, 0, 0, 4, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'LNK\', \'COMMON\', \'SYS_COMMON\', 0, 1, 0, 1, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'LNK\', \'INTERN\', \'INS_INTERN\', 1, 0, 0, 2, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'DAT\', \'COMMON\', \'SYS_COMMON\', 0, 1, 0, 1, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'DAT\', \'TRAINING\',\'INS_TRAINING\', 0, 0, 0, 2, ' . $systemUserId . ',\'' . DATETIME_NOW . '\')
, (' . $this->getValue('org_id') . ', \'DAT\', \'COURSES\', \'INS_COURSES\', 0, 0, 0, 3, ' . $systemUserId . ',\'' . DATETIME_NOW . '\') ';
$this->db->query($sql);
// create default folder for download module in database
$sql = 'INSERT INTO ' . TBL_FOLDERS . ' (fol_org_id, fol_type, fol_name, fol_path,
fol_locked, fol_public, fol_timestamp)
VALUES (' . $this->getValue('org_id') . ', \'DOWNLOAD\', \'download\', \'/adm_my_files\',
0,1,\'' . DATETIME_NOW . '\')';
$this->db->query($sql);
// now create default roles
// Create role webmaster
$roleWebmaster = new TableRoles($this->db);
$roleWebmaster->setValue('rol_cat_id', $categoryCommon);
$roleWebmaster->setValue('rol_name', $gL10n->get('SYS_WEBMASTER'));
$roleWebmaster->setValue('rol_description', $gL10n->get('INS_DESCRIPTION_WEBMASTER'));
$roleWebmaster->setValue('rol_assign_roles', 1);
$roleWebmaster->setValue('rol_approve_users', 1);
$roleWebmaster->setValue('rol_announcements', 1);
$roleWebmaster->setValue('rol_dates', 1);
$roleWebmaster->setValue('rol_download', 1);
$roleWebmaster->setValue('rol_guestbook', 1);
$roleWebmaster->setValue('rol_guestbook_comments', 1);
$roleWebmaster->setValue('rol_photo', 1);
$roleWebmaster->setValue('rol_weblinks', 1);
$roleWebmaster->setValue('rol_edit_user', 1);
$roleWebmaster->setValue('rol_mail_to_all', 1);
$roleWebmaster->setValue('rol_mail_this_role', 3);
$roleWebmaster->setValue('rol_profile', 1);
$roleWebmaster->setValue('rol_this_list_view', 1);
$roleWebmaster->setValue('rol_all_lists_view', 1);
$roleWebmaster->setValue('rol_webmaster', 1);
$roleWebmaster->setValue('rol_inventory', 1);
$roleWebmaster->save();
// Create role member
$roleMember = new TableRoles($this->db);
$roleMember->setValue('rol_cat_id', $categoryCommon);
$roleMember->setValue('rol_name', $gL10n->get('SYS_MEMBER'));
$roleMember->setValue('rol_description', $gL10n->get('INS_DESCRIPTION_MEMBER'));
$roleMember->setValue('rol_mail_this_role', 2);
$roleMember->setValue('rol_profile', 1);
$roleMember->setValue('rol_this_list_view', 1);
$roleMember->setValue('rol_default_registration', 1);
$roleMember->save();
// Create role board
$roleManagement = new TableRoles($this->db);
$roleManagement->setValue('rol_cat_id', $categoryCommon);
$roleManagement->setValue('rol_name', $gL10n->get('INS_BOARD'));
$roleManagement->setValue('rol_description', $gL10n->get('INS_DESCRIPTION_BOARD'));
$roleManagement->setValue('rol_announcements', 1);
$roleManagement->setValue('rol_dates', 1);
$roleManagement->setValue('rol_weblinks', 1);
$roleManagement->setValue('rol_edit_user', 1);
$roleManagement->setValue('rol_mail_to_all', 1);
$roleManagement->setValue('rol_mail_this_role', 2);
$roleManagement->setValue('rol_profile', 1);
$roleManagement->setValue('rol_this_list_view', 1);
$roleManagement->setValue('rol_all_lists_view', 1);
$roleManagement->save();
// Create membership for user in role 'Webmaster' and 'Members'
$member = new TableMembers($this->db);
$member->startMembership($roleWebmaster->getValue('rol_id'), $userId);
$member->startMembership($roleMember->getValue('rol_id'), $userId);
// create object with current user field structure
$gProfileFields = new ProfileFields($this->db, $this->getValue('org_id'));
// create default list configurations
$addressList = new ListConfiguration($this->db);
$addressList->setValue('lst_name', $gL10n->get('INS_ADDRESS_LIST'));
$addressList->setValue('lst_org_id', $this->getValue('org_id'));
$addressList->setValue('lst_global', 1);
$addressList->setValue('lst_default', 1);
$addressList->addColumn(1, $gProfileFields->getProperty('LAST_NAME', 'usf_id'), 'ASC');
$addressList->addColumn(2, $gProfileFields->getProperty('FIRST_NAME', 'usf_id'), 'ASC');
$addressList->addColumn(3, $gProfileFields->getProperty('BIRTHDAY', 'usf_id'));
$addressList->addColumn(4, $gProfileFields->getProperty('ADDRESS', 'usf_id'));
$addressList->addColumn(5, $gProfileFields->getProperty('POSTCODE', 'usf_id'));
$addressList->addColumn(6, $gProfileFields->getProperty('CITY', 'usf_id'));
$addressList->save();
$phoneList = new ListConfiguration($this->db);
$phoneList->setValue('lst_name', $gL10n->get('INS_PHONE_LIST'));
$phoneList->setValue('lst_org_id', $this->getValue('org_id'));
$phoneList->setValue('lst_global', 1);
$phoneList->addColumn(1, $gProfileFields->getProperty('LAST_NAME', 'usf_id'), 'ASC');
$phoneList->addColumn(2, $gProfileFields->getProperty('FIRST_NAME', 'usf_id'), 'ASC');
$phoneList->addColumn(3, $gProfileFields->getProperty('PHONE', 'usf_id'));
$phoneList->addColumn(4, $gProfileFields->getProperty('MOBILE', 'usf_id'));
$phoneList->addColumn(5, $gProfileFields->getProperty('EMAIL', 'usf_id'));
$phoneList->addColumn(6, $gProfileFields->getProperty('FAX', 'usf_id'));
$phoneList->save();
$contactList = new ListConfiguration($this->db);
$contactList->setValue('lst_name', $gL10n->get('SYS_CONTACT_DETAILS'));
$contactList->setValue('lst_org_id', $this->getValue('org_id'));
$contactList->setValue('lst_global', 1);
$contactList->addColumn(1, $gProfileFields->getProperty('LAST_NAME', 'usf_id'), 'ASC');
$contactList->addColumn(2, $gProfileFields->getProperty('FIRST_NAME', 'usf_id'), 'ASC');
$contactList->addColumn(3, $gProfileFields->getProperty('BIRTHDAY', 'usf_id'));
$contactList->addColumn(4, $gProfileFields->getProperty('ADDRESS', 'usf_id'));
$contactList->addColumn(5, $gProfileFields->getProperty('POSTCODE', 'usf_id'));
$contactList->addColumn(6, $gProfileFields->getProperty('CITY', 'usf_id'));
$contactList->addColumn(7, $gProfileFields->getProperty('PHONE', 'usf_id'));
$contactList->addColumn(8, $gProfileFields->getProperty('MOBILE', 'usf_id'));
$contactList->addColumn(9, $gProfileFields->getProperty('EMAIL', 'usf_id'));
$contactList->save();
$formerList = new ListConfiguration($this->db);
$formerList->setValue('lst_name', $gL10n->get('INS_MEMBERSHIP'));
$formerList->setValue('lst_org_id', $this->getValue('org_id'));
$formerList->setValue('lst_global', 1);
$formerList->addColumn(1, $gProfileFields->getProperty('LAST_NAME', 'usf_id'));
$formerList->addColumn(2, $gProfileFields->getProperty('FIRST_NAME', 'usf_id'));
$formerList->addColumn(3, $gProfileFields->getProperty('BIRTHDAY', 'usf_id'));
$formerList->addColumn(4, 'mem_begin');
$formerList->addColumn(5, 'mem_end', 'DESC');
$formerList->save();
}
if ($getRoleId > 0) {
$role->readDataById($getRoleId);
// Pruefung, ob die Rolle zur aktuellen Organisation gehoert
if ($role->getValue('cat_org_id') != $gCurrentOrganization->getValue('org_id') && $role->getValue('cat_org_id') > 0) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// Rolle Webmaster darf nur vom Webmaster selber erstellt oder gepflegt werden
if ($role->getValue('rol_webmaster') == 1 && !$gCurrentUser->isWebmaster()) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// hidden roles can also see hidden categories
if ($role->getValue('cat_system') == 1) {
$showSystemCategory = true;
}
} else {
$role->setValue('rol_this_list_view', '1');
$role->setValue('rol_mail_this_role', '2');
}
if (isset($_SESSION['roles_request'])) {
// durch fehlerhafte Eingabe ist der User zu diesem Formular zurueckgekehrt
// nun die vorher eingegebenen Inhalte ins Objekt schreiben
$role->setArray($_SESSION['roles_request']);
unset($_SESSION['roles_request']);
}
// holt eine Liste der ausgewaehlten abhaengigen Rolen
$childRoles = RoleDependency::getChildRoles($gDb, $getRoleId);
$childRoleObjects = array();
// create html page object
$page = new HtmlPage($headline);
$page->addJavascript('
checkMaxMemberCount();
$_POST['rol_start_time'] = $validFromTime->format('H:i:s');
}
}
if (strlen($_POST['rol_end_time']) > 0) {
$validToTime = DateTime::createFromFormat('Y-m-d ' . $gPreferences['system_time'], DATE_NOW . ' ' . $_POST['rol_end_time']);
if (!$validToTime) {
$gMessage->show($gL10n->get('SYS_TIME_INVALID', $gL10n->get('ROL_TIME_TO'), $gPreferences['system_time']));
} else {
// now write date and time with database format to date object
$_POST['rol_end_time'] = $validToTime->format('H:i:s');
}
}
// Kontrollieren ob bei nachtraeglicher Senkung der maximalen Mitgliederzahl diese nicht bereits ueberschritten wurde
if ($getRoleId > 0 && $_POST['rol_max_members'] != $role->getValue('rol_max_members')) {
// Zaehlen wieviele Leute die Rolle bereits haben, ohne Leiter
$role->setValue('rol_max_members', $_POST['rol_max_members']);
$num_free_places = $role->countVacancies();
if ($num_free_places < 0) {
$gMessage->show($gL10n->get('SYS_ROLE_MAX_MEMBERS', $role->getValue('rol_name')));
}
}
// POST Variablen in das Role-Objekt schreiben
foreach ($_POST as $key => $value) {
if (strpos($key, 'rol_') === 0) {
$returnCode = $role->setValue($key, $value);
// at least one role must have this flag otherwise show error
if (!$returnCode && $key === 'rol_default_registration') {
$gMessage->show($gL10n->get('ROL_NO_DEFAULT_ROLE', $gL10n->get('ROL_DEFAULT_REGISTRATION')));
}
}
}
