WARNING: THIS IS AN AUTO-GENERATED FILE
This file should generally not be edited by hand except in special circumstances.
Add any custom business logic to the Model class which is extended from this DAO class.
Leaving this file alone will allow easy re-generation of all DAOs in the event of schema changes
function executeChange($currUser, $userid, $newrole)
{
if ($newrole !== "1" && $newrole !== "2" && $newrole !== "3" && $newrole !== "4") {
return "Invalid status!";
}
$userDAO = new UserDAO();
$userChan = $userDAO->getUserByID($userid);
$userCurr = $userDAO->getUserByID($currUser);
//get current session user
if ($userCurr->getRole()->getRoleID() !== "1" && $userCurr->getRole()->getRoleID() !== "2") {
return "You have no right to change user status!";
}
if ($userChan === null) {
//database
return "Could not find this user!";
}
if ($userChan->getRole()->getRoleID() === $newrole) {
//type
return "Old status is equal to new status, don't need to change!";
}
if ($userCurr->getRole()->getRoleID() === "2") {
if ($newrole === "1" || $newrole === "2") {
return "You have no right to set an advanced user.";
}
}
$roleDAO = new RoleDAO();
$newroleObj = $roleDAO->getRoleByID($newrole);
$userChan->setRole($newroleObj);
$userDAO->updateUser($userChan);
return true;
}
function execSignup($username, $password, $confirmpw, $firstname, $lastname, $gender)
{
if ($username == "" || !isValidUsername($username)) {
return "Username is empty or invalid!";
}
if ($password == "" || !isValidPassword($password)) {
return "Password is empty or invalid!";
}
if ($confirmpw == "" || !isValidPassword($confirmpw)) {
return "Confirm Password is empty or invalid!";
}
if ($firstname == "" || !isValidName($firstname)) {
return "First Name is empty or invalid!";
}
if ($lastname == "" || !isValidName($lastname)) {
return "Last Name is empty or invalid!";
}
if ($gender == "" || !isValidGender($gender)) {
return "Gender is empty or invalid!";
}
$userDAO = new UserDAO();
//verify username exist
$result = $userDAO->getUserByUsername($username);
if ($result !== null) {
return "Username exists, please change to another one!";
}
//verify $password == $confirmpw
if ($password != $confirmpw) {
return "Password and Confirm Password must be same!";
}
$roleDAO = new RoleDAO();
$role = $roleDAO->getRoleByID(3);
//normal user
$departmentDAO = new DepartmentDAO();
$depart = $departmentDAO->getDepartmentByID(1);
//root department
$encryptPW = encryptPassword($password);
$photoURL = "photo/default.png";
$user = new User($role, $depart, $username, $encryptPW, $firstname, $lastname, $gender, $photoURL);
if ($userDAO->insertUser($user) === true) {
return true;
} else {
return "Insert user into table error, please contact administrator!";
}
}
/**
* Override default validation
* @see Phreezable::Validate()
*/
public function Validate()
{
// example of custom validation
// $this->ResetValidationErrors();
// $errors = $this->GetValidationErrors();
// if ($error == true) $this->AddValidationError('FieldName', 'Error Information');
// return !$this->HasValidationErrors();
return parent::Validate();
}
/**
* @see GridHandler::renderFilter()
*/
function renderFilter($request)
{
// Get filter data.
import('classes.security.RoleDAO');
$roleOptions = array(0 => 'grid.user.allPermissionLevels') + RoleDAO::getRoleNames(true);
// Reader roles are not important for stage assignments.
if (array_key_exists(ROLE_ID_READER, $roleOptions)) {
unset($roleOptions[ROLE_ID_READER]);
}
$filterData = array('roleOptions' => $roleOptions);
$workflowStages = array(0 => 'grid.userGroup.allStages') + WorkflowStageDAO::getWorkflowStageTranslationKeys();
$filterData['stageOptions'] = $workflowStages;
return parent::renderFilter($request, $filterData);
}
/**
* Retrieve a list of all copyeditors not assigned to the specified article.
* @param $journalId int
* @param $articleId int
* @return array matching Users
*/
function &getCopyeditorsNotAssignedToArticle($journalId, $articleId, $searchType = null, $search = null, $searchMatch = null)
{
$users = array();
$paramArray = array('interests', $articleId, ASSOC_TYPE_ARTICLE, 'SIGNOFF_COPYEDITING_INITIAL', $journalId, RoleDAO::getRoleIdFromPath('copyeditor'));
$searchSql = '';
$searchTypeMap = array(USER_FIELD_FIRSTNAME => 'u.first_name', USER_FIELD_LASTNAME => 'u.last_name', USER_FIELD_USERNAME => 'u.username', USER_FIELD_EMAIL => 'u.email', USER_FIELD_INTERESTS => 's.setting_value');
if (isset($search) && isset($searchTypeMap[$searchType])) {
$fieldName = $searchTypeMap[$searchType];
switch ($searchMatch) {
case 'is':
$searchSql = "AND LOWER({$fieldName}) = LOWER(?)";
$paramArray[] = $search;
break;
case 'contains':
$searchSql = "AND LOWER({$fieldName}) LIKE LOWER(?)";
$paramArray[] = '%' . $search . '%';
break;
case 'startsWith':
$searchSql = "AND LOWER({$fieldName}) LIKE LOWER(?)";
$paramArray[] = $search . '%';
break;
}
} elseif (isset($search)) {
switch ($searchType) {
case USER_FIELD_USERID:
$searchSql = 'AND user_id=?';
$paramArray[] = $search;
break;
case USER_FIELD_INITIAL:
$searchSql = 'AND (LOWER(last_name) LIKE LOWER(?) OR LOWER(username) LIKE LOWER(?))';
$paramArray[] = $search . '%';
$paramArray[] = $search . '%';
break;
}
}
$result =& $this->retrieve('SELECT u.*
FROM users u
LEFT JOIN user_settings s ON (u.user_id = s.user_id AND s.setting_name = ?)
LEFT JOIN roles r ON (r.user_id = u.user_id)
LEFT JOIN signoffs sci ON (sci.user_id = u.user_id AND sci.assoc_id = ? AND sci.assoc_type = ? AND sci.symbolic = ?)
WHERE r.journal_id = ? AND
r.role_id = ? AND
sci.assoc_id IS NULL
' . $searchSql . '
ORDER BY last_name, first_name', $paramArray);
while (!$result->EOF) {
$users[] =& $this->userDao->_returnUserFromRowWithData($result->GetRowAssoc(false));
$result->moveNext();
}
$result->Close();
unset($result);
return $users;
}
function changeUserRole($adminID, $userID, $roleID)
{
$userDAO = new UserDAO();
$roleDAO = new RoleDAO();
$admin = $userDAO->getUserByID($adminID);
$user = $userDAO->getUserByID($userID);
$role = $roleDAO->getRoleByID($roleID);
if ($user === null) {
return "User: "******" doesn't exist!";
}
if ($role === null) {
return "Role: " . $userID . " doesn't exist!";
}
if ($admin->getRole()->getRoleID() == 0 || $admin->getRole()->getRoleID() == 3) {
return "You do not have the right to change user role!";
}
if ($user->getRole()->getRoleID() === $roleID) {
return "The role has already been set!";
}
if ($admin->getRoleID() == 1) {
$user->setRole($role);
$userDAO->updateUser($user);
}
if ($admin->getRole()->getRoleID() == 2) {
if ($roleID == 1 || $roleID() == 2) {
return "You do not have the right to change user role!";
}
$user->setRole($role);
$userDAO->updateUser($user);
echo "<br>You have successfully changed " . $user->getUsername() . "\\'s role to " . $role->getRoleName();
}
}
<?php
require_once "RoleDAO.php";
$name = str_replace('"', "'", trim($_GET["name"]));
$code = $_GET["code"];
try {
$role = new Role();
$role->name = trim($name);
$role->code = $code;
$roleDAO = new RoleDAO();
$roles = $roleDAO->update($role);
echo "Updated";
} catch (Exception $exception) {
echo $exception->getMessage();
}
/**
* Assigns the selected director to the submission.
*/
function assignDirector($args, $request)
{
$this->validate($request);
Locale::requireComponents(array(LOCALE_COMPONENT_PKP_MANAGER));
// manager.people.noneEnrolled
$schedConf =& $request->getSchedConf();
$paperId = $request->getUserVar('paperId');
$directorId = $request->getUserVar('directorId');
$roleDao =& DAORegistry::getDAO('RoleDAO');
$isDirector = $roleDao->userHasRole($schedConf->getConferenceId(), $schedConf->getId(), $directorId, ROLE_ID_DIRECTOR) || $roleDao->userHasRole($schedConf->getConferenceId(), 0, $directorId, ROLE_ID_DIRECTOR);
$isTrackDirector = $roleDao->userHasRole($schedConf->getConferenceId(), $schedConf->getId(), $directorId, ROLE_ID_TRACK_DIRECTOR) || $roleDao->userHasRole($schedConf->getConferenceId(), 0, $directorId, ROLE_ID_TRACK_DIRECTOR);
if (isset($directorId) && $directorId != null && ($isDirector || $isTrackDirector)) {
// A valid track director has already been chosen;
// either prompt with a modifiable email or, if this
// has been done, send the email and store the director
// selection.
$this->setupTemplate($request, DIRECTOR_TRACK_SUBMISSIONS, $paperId, 'summary');
// FIXME: Prompt for due date.
if (DirectorAction::assignDirector($paperId, $directorId, $isDirector, $request->getUserVar('send'))) {
$request->redirect(null, null, null, 'submission', $paperId);
}
} else {
// Allow the user to choose a track director or director.
$this->setupTemplate($request, DIRECTOR_TRACK_SUBMISSIONS, $paperId, 'summary');
$searchType = null;
$searchMatch = null;
$search = $request->getUserVar('search');
$searchInitial = $request->getUserVar('searchInitial');
if (!empty($search)) {
$searchType = $request->getUserVar('searchField');
$searchMatch = $request->getUserVar('searchMatch');
} elseif (!empty($searchInitial)) {
$searchInitial = String::strtoupper($searchInitial);
$searchType = USER_FIELD_INITIAL;
$search = $searchInitial;
}
$forDirectors = isset($args[0]) && $args[0] === 'director';
$rangeInfo =& Handler::getRangeInfo('directors', array($forDirectors, (string) $searchType, (string) $search, (string) $searchMatch));
$directorSubmissionDao =& DAORegistry::getDAO('DirectorSubmissionDAO');
if ($forDirectors) {
$roleName = 'user.role.director';
$rolePath = 'director';
while (true) {
$directors =& $directorSubmissionDao->getUsersNotAssignedToPaper($schedConf->getId(), $paperId, RoleDAO::getRoleIdFromPath('director'), $searchType, $search, $searchMatch, $rangeInfo);
if ($directors->isInBounds()) {
break;
}
unset($rangeInfo);
$rangeInfo =& $directors->getLastPageRangeInfo();
unset($directors);
}
} else {
$roleName = 'user.role.trackDirector';
$rolePath = 'trackDirector';
while (true) {
$directors =& $directorSubmissionDao->getUsersNotAssignedToPaper($schedConf->getId(), $paperId, RoleDAO::getRoleIdFromPath('trackDirector'), $searchType, $search, $searchMatch, $rangeInfo);
if ($directors->isInBounds()) {
break;
}
unset($rangeInfo);
$rangeInfo =& $directors->getLastPageRangeInfo();
unset($directors);
}
}
$templateMgr =& TemplateManager::getManager();
$templateMgr->assign_by_ref('directors', $directors);
$templateMgr->assign('roleName', $roleName);
$templateMgr->assign('rolePath', $rolePath);
$templateMgr->assign('paperId', $paperId);
$trackDao =& DAORegistry::getDAO('TrackDAO');
$trackDirectorTracks =& $trackDao->getDirectorTracks($schedConf->getId());
$editAssignmentDao =& DAORegistry::getDAO('EditAssignmentDAO');
$directorStatistics = $editAssignmentDao->getDirectorStatistics($schedConf->getId());
$templateMgr->assign_by_ref('directorTracks', $trackDirectorTracks);
$templateMgr->assign('directorStatistics', $directorStatistics);
$templateMgr->assign('searchField', $searchType);
$templateMgr->assign('searchMatch', $searchMatch);
$templateMgr->assign('search', $search);
$templateMgr->assign('searchInitial', $request->getUserVar('searchInitial'));
$templateMgr->assign('fieldOptions', array(USER_FIELD_FIRSTNAME => 'user.firstName', USER_FIELD_LASTNAME => 'user.lastName', USER_FIELD_USERNAME => 'user.username', USER_FIELD_EMAIL => 'user.email'));
$templateMgr->assign('alphaList', explode(' ', Locale::translate('common.alphaList')));
$templateMgr->assign('helpTopicId', 'editorial.directorsRole.summaryPage.submissionManagement');
$templateMgr->display('director/selectTrackDirector.tpl');
}
}
/**
* Retrieve a list of all reviewers not assigned to the specified paper.
* @param $schedConfId int
* @param $paperId int
* @return array matching Users
*/
function &getReviewersNotAssignedToPaper($schedConfId, $paperId)
{
$users = array();
$result =& $this->retrieve('SELECT u.* FROM users u NATURAL JOIN roles r LEFT JOIN review_assignments a ON (a.reviewer_id = u.user_id AND a.paper_id = ?) WHERE r.sched_conf_id = ? AND r.role_id = ? AND a.paper_id IS NULL ORDER BY last_name, first_name', array($paperId, $schedConfId, RoleDAO::getRoleIdFromPath('reviewer')));
while (!$result->EOF) {
$users[] =& $this->userDao->_returnUserFromRowWithData($result->GetRowAssoc(false));
$result->moveNext();
}
$result->Close();
unset($result);
return $users;
}
/**
* Retrieve a list of all reviewers along with information about their current status with respect to an article's current decision.
* @param $journalId int
* @param $decisionId int
* @param $extReviewer bool indicate if the kind of reviewers
* @param $searchType int USER_FIELD_...
* @param $search string
* @param $searchMatch string "is" or "contains" or "startsWith"
* @param $rangeInfo RangeInfo optional
* @return DAOResultFactory containing matching Users
* Last Modified: EL on Febraury 16th 2013
* Separation of External Reviewers
*/
function &getReviewersForArticle($journalId, $decisionId, $sectionId, $extReviewer = false, $searchType = null, $search = null, $searchMatch = null, $rangeInfo = null, $sortBy = 'reviewerName', $sortDirection = SORT_DIRECTION_ASC)
{
$paramArray = array($decisionId, ASSOC_TYPE_USER, 'interest', $journalId, RoleDAO::getRoleIdFromPath('reviewer'));
if ($extReviewer == true) {
$searchSql = ' AND er.section_id = 0 ';
} else {
$searchSql = ' AND er.section_id = ? ';
$paramArray[] = $sectionId;
}
$searchTypeMap = array(USER_FIELD_FIRSTNAME => 'u.first_name', USER_FIELD_LASTNAME => 'u.last_name', USER_FIELD_USERNAME => 'u.username', USER_FIELD_EMAIL => 'u.email', USER_FIELD_INTERESTS => 'cves.setting_value');
if (isset($search) && isset($searchTypeMap[$searchType])) {
$fieldName = $searchTypeMap[$searchType];
switch ($searchMatch) {
case 'is':
$searchSql .= "AND LOWER({$fieldName}) = LOWER(?)";
$paramArray[] = $search;
break;
case 'contains':
$searchSql .= "AND LOWER({$fieldName}) LIKE LOWER(?)";
$paramArray[] = '%' . $search . '%';
break;
case 'startsWith':
$searchSql .= "AND LOWER({$fieldName}) LIKE LOWER(?)";
$paramArray[] = $search . '%';
break;
}
} elseif (isset($search)) {
switch ($searchType) {
case USER_FIELD_USERID:
$searchSql .= ' AND user_id=?';
$paramArray[] = $search;
break;
case USER_FIELD_INITIAL:
$searchSql .= ' AND (LOWER(last_name) LIKE LOWER(?) OR LOWER(username) LIKE LOWER(?))';
$paramArray[] = $search . '%';
$paramArray[] = $search . '%';
break;
}
}
$result =& $this->retrieveRange('SELECT DISTINCT
u.user_id,
u.last_name,
ar.review_id,
AVG(ra.quality) AS average_quality,
COUNT(ac.review_id) AS completed,
COUNT(ai.review_id) AS incomplete,
MAX(ac.date_notified) AS latest,
AVG(ac.date_completed-ac.date_notified) AS average
FROM users u
LEFT JOIN review_assignments ra ON (ra.reviewer_id = u.user_id)
LEFT JOIN review_assignments ac ON (ac.reviewer_id = u.user_id AND ac.date_completed IS NOT NULL)
LEFT JOIN review_assignments ai ON (ai.reviewer_id = u.user_id AND ai.date_completed IS NULL)
LEFT JOIN review_assignments ar ON (ar.reviewer_id = u.user_id AND ar.cancelled = 0 AND ar.decision_id = ?)
LEFT JOIN roles r ON (r.user_id = u.user_id)
LEFT JOIN section_decisions sd ON (ra.decision_id = sd.section_decision_id)
LEFT JOIN controlled_vocabs cv ON (cv.assoc_type = ? AND cv.assoc_id = u.user_id AND cv.symbolic = ?)
LEFT JOIN controlled_vocab_entries cve ON (cve.controlled_vocab_id = cv.controlled_vocab_id)
LEFT JOIN controlled_vocab_entry_settings cves ON (cves.controlled_vocab_entry_id = cve.controlled_vocab_entry_id)
LEFT JOIN erc_reviewers er ON (er.user_id = u.user_id)
WHERE u.user_id = r.user_id AND
r.journal_id = ? AND
r.role_id = ? ' . $searchSql . ' GROUP BY u.user_id, u.last_name, ar.review_id' . ($sortBy ? ' ORDER BY ' . $this->getSortMapping($sortBy) . ' ' . $this->getDirectionMapping($sortDirection) : ''), $paramArray, $rangeInfo);
$returner = new DAOResultFactory($result, $this, '_returnReviewerUserFromRow');
return $returner;
}
/**
* @copydoc Form::fetch()
*/
function fetch($request)
{
$templateMgr = TemplateManager::getManager($request);
import('classes.security.RoleDAO');
$roleOptions = RoleDAO::getRoleNames(true);
$templateMgr->assign('roleOptions', $roleOptions);
// Users can't edit the role once user group is created.
// userGroupId is 0 for new User Groups because it is cast to int in UserGroupGridHandler.
$disableRoleSelect = $this->getUserGroupId() > 0 ? true : false;
$templateMgr->assign('disableRoleSelect', $disableRoleSelect);
$templateMgr->assign('selfRegistrationRoleIds', $this->getPermitSelfRegistrationRoles());
return parent::fetch($request);
}
/**
* Retrieve a list of all reviewers not assigned to the specified article.
* @param $journalId int
* @param $articleId int
* @return array matching Users
*/
function &getReviewersNotAssignedToArticle($journalId, $articleId)
{
$users = array();
$result =& $this->retrieve('SELECT u.*
FROM users u
LEFT JOIN roles r ON (r.user_id = u.user_id)
LEFT JOIN review_assignments a ON (a.reviewer_id = u.user_id AND a.article_id = ?)
WHERE r.journal_id = ? AND
r.role_id = ? AND
a.article_id IS NULL
ORDER BY last_name, first_name', array($articleId, $journalId, RoleDAO::getRoleIdFromPath('reviewer')));
while (!$result->EOF) {
$users[] =& $this->userDao->_returnUserFromRowWithData($result->GetRowAssoc(false));
$result->moveNext();
}
$result->Close();
unset($result);
return $users;
}
public static function GetAllRole()
{
return RoleDAO::GetAllRole();
}
/**
* @see Form::fetch()
*/
function fetch($request)
{
$templateMgr =& TemplateManager::getManager();
import('classes.security.RoleDAO');
$roleOptions = RoleDAO::getRoleNames(true);
$templateMgr->assign('roleOptions', $roleOptions);
$userGroupDao =& DAORegistry::getDAO('UserGroupDAO');
$stages = $userGroupDao->getWorkflowStageTranslationKeys();
$templateMgr->assign('stageOptions', $stages);
// Users can't edit the role once user group is created.
$disableRoleSelect = !is_null($this->getUserGroupId()) ? true : false;
$templateMgr->assign('disableRoleSelect', $disableRoleSelect);
return parent::fetch($request);
}
<?php
require_once "RoleDAO.php";
$code = $_GET["code"];
try {
$roleDAO = new RoleDAO();
$roleDAO->delete($code);
echo "Successfully Deleted";
} catch (Exception $exception) {
echo $exception->getMessage();
}
/**
* Assigns the selected editor to the submission.
*/
function assignEditor($args, $request)
{
$this->validate();
AppLocale::requireComponents(LOCALE_COMPONENT_PKP_MANAGER);
// manager.people.noneEnrolled
$journal =& $request->getJournal();
$articleId = $request->getUserVar('articleId');
$editorId = $request->getUserVar('editorId');
$roleDao =& DAORegistry::getDAO('RoleDAO');
$isSectionEditor = $roleDao->userHasRole($journal->getId(), $editorId, ROLE_ID_SECTION_EDITOR);
$isEditor = $roleDao->userHasRole($journal->getId(), $editorId, ROLE_ID_EDITOR);
if (isset($editorId) && $editorId != null && ($isEditor || $isSectionEditor)) {
// A valid section editor has already been chosen;
// either prompt with a modifiable email or, if this
// has been done, send the email and store the editor
// selection.
$this->setupTemplate(EDITOR_SECTION_SUBMISSIONS, $articleId, 'summary');
// FIXME: Prompt for due date.
if (EditorAction::assignEditor($articleId, $editorId, $isEditor, $request->getUserVar('send'), $request)) {
Request::redirect(null, null, 'submission', $articleId);
}
} else {
// Allow the user to choose a section editor or editor.
$this->setupTemplate(EDITOR_SECTION_SUBMISSIONS, $articleId, 'summary');
$searchType = null;
$searchMatch = null;
$search = $request->getUserVar('search');
$searchInitial = $request->getUserVar('searchInitial');
if (!empty($search)) {
$searchType = $request->getUserVar('searchField');
$searchMatch = $request->getUserVar('searchMatch');
} elseif (!empty($searchInitial)) {
$searchInitial = String::strtoupper($searchInitial);
$searchType = USER_FIELD_INITIAL;
$search = $searchInitial;
}
$rangeInfo =& $this->getRangeInfo('editors');
$editorSubmissionDao =& DAORegistry::getDAO('EditorSubmissionDAO');
if (isset($args[0]) && $args[0] === 'editor') {
$roleName = 'user.role.editor';
$rolePath = 'editor';
$editors =& $editorSubmissionDao->getUsersNotAssignedToArticle($journal->getId(), $articleId, RoleDAO::getRoleIdFromPath('editor'), $searchType, $search, $searchMatch, $rangeInfo);
} else {
$roleName = 'user.role.sectionEditor';
$rolePath = 'sectionEditor';
$editors =& $editorSubmissionDao->getUsersNotAssignedToArticle($journal->getId(), $articleId, RoleDAO::getRoleIdFromPath('sectionEditor'), $searchType, $search, $searchMatch, $rangeInfo);
}
$templateMgr =& TemplateManager::getManager();
$templateMgr->assign_by_ref('editors', $editors);
$templateMgr->assign('roleName', $roleName);
$templateMgr->assign('rolePath', $rolePath);
$templateMgr->assign('articleId', $articleId);
$sectionDao =& DAORegistry::getDAO('SectionDAO');
$sectionEditorSections =& $sectionDao->getEditorSections($journal->getId());
$editAssignmentDao =& DAORegistry::getDAO('EditAssignmentDAO');
$editorStatistics = $editAssignmentDao->getEditorStatistics($journal->getId());
$templateMgr->assign_by_ref('editorSections', $sectionEditorSections);
$templateMgr->assign('editorStatistics', $editorStatistics);
$templateMgr->assign('searchField', $searchType);
$templateMgr->assign('searchMatch', $searchMatch);
$templateMgr->assign('search', $search);
$templateMgr->assign('searchInitial', Request::getUserVar('searchInitial'));
$templateMgr->assign('fieldOptions', array(USER_FIELD_FIRSTNAME => 'user.firstName', USER_FIELD_LASTNAME => 'user.lastName', USER_FIELD_USERNAME => 'user.username', USER_FIELD_EMAIL => 'user.email'));
$templateMgr->assign('alphaList', explode(' ', __('common.alphaList')));
$templateMgr->assign('helpTopicId', 'editorial.editorsRole.submissionSummary.submissionManagement');
$templateMgr->display('editor/selectSectionEditor.tpl');
}
}
/**
* Get the URL path associated with this role's operations.
* @return String the path
*/
function getRolePath()
{
return RoleDAO::getRolePath($this->getData('roleId'));
}
<?php
require_once "RoleDAO.php";
$name = str_replace('"', "'", trim($_GET["name"]));
try {
$role = new Role();
$role->name = trim($name);
$roleDAO = new RoleDAO();
$roles = $roleDAO->add($role);
echo "Added";
} catch (Exception $exception) {
echo $exception->getMessage();
}
function display(&$args)
{
$templateMgr =& TemplateManager::getManager();
parent::display($args);
$templateMgr->assign('roleOptions', array('' => 'manager.people.doNotEnroll', 'manager' => 'user.role.manager', 'director' => 'user.role.director', 'trackDirector' => 'user.role.trackDirector', 'reviewer' => 'user.role.reviewer', 'author' => 'user.role.author', 'reader' => 'user.role.reader'));
$roleDao =& DAORegistry::getDAO('RoleDAO');
$schedConf =& Request::getSchedConf();
switch (array_shift($args)) {
case 'confirm':
$this->import('UserXMLParser');
$templateMgr->assign('helpTopicId', 'conference.currentConference.importExport');
$sendNotify = (bool) Request::getUserVar('sendNotify');
$continueOnError = (bool) Request::getUserVar('continueOnError');
import('file.FileManager');
if (($userFile = FileManager::getUploadedFilePath('userFile')) !== false) {
// Import the uploaded file
$parser = new UserXMLParser($schedConf->getConferenceId(), $schedConf->getId());
$users =& $parser->parseData($userFile);
$i = 0;
$usersRoles = array();
foreach ($users as $user) {
$usersRoles[$i] = array();
foreach ($user->getRoles() as $role) {
array_push($usersRoles[$i], $role->getRoleName());
}
$i++;
}
$templateMgr->assign_by_ref('users', $users);
$templateMgr->assign_by_ref('usersRoles', $usersRoles);
$templateMgr->assign('sendNotify', $sendNotify);
$templateMgr->assign('continueOnError', $continueOnError);
$templateMgr->assign('errors', $parser->errors);
// Show confirmation form
$templateMgr->display($this->getTemplatePath() . 'importUsersConfirm.tpl');
}
break;
case 'import':
$this->import('UserXMLParser');
$userKeys = Request::getUserVar('userKeys');
if (!is_array($userKeys)) {
$userKeys = array();
}
$sendNotify = (bool) Request::getUserVar('sendNotify');
$continueOnError = (bool) Request::getUserVar('continueOnError');
$users = array();
foreach ($userKeys as $i) {
$newUser = new ImportedUser();
$newUser->setFirstName(Request::getUserVar($i . '_firstName'));
$newUser->setMiddleName(Request::getUserVar($i . '_middleName'));
$newUser->setLastName(Request::getUserVar($i . '_lastName'));
$newUser->setUsername(Request::getUserVar($i . '_username'));
$newUser->setEmail(Request::getUserVar($i . '_email'));
$locales = array();
if (Request::getUserVar($i . '_locales') != null || is_array(Request::getUserVar($i . '_locales'))) {
foreach (Request::getUserVar($i . '_locales') as $locale) {
array_push($locales, $locale);
}
}
$newUser->setLocales($locales);
$newUser->setSignature(Request::getUserVar($i . '_signature'), null);
$newUser->setBiography(Request::getUserVar($i . '_biography'), null);
$newUser->setInterests(Request::getUserVar($i . '_interests'), null);
$newUser->setCountry(Request::getUserVar($i . '_country'));
$newUser->setMailingAddress(Request::getUserVar($i . '_mailingAddress'));
$newUser->setFax(Request::getUserVar($i . '_fax'));
$newUser->setPhone(Request::getUserVar($i . '_phone'));
$newUser->setUrl(Request::getUserVar($i . '_url'));
$newUser->setAffiliation(Request::getUserVar($i . '_affiliation'));
$newUser->setGender(Request::getUserVar($i . '_gender'));
$newUser->setInitials(Request::getUserVar($i . '_initials'));
$newUser->setSalutation(Request::getUserVar($i . '_salutation'));
$newUser->setPassword(Request::getUserVar($i . '_password'));
$newUser->setMustChangePassword(Request::getUserVar($i . '_mustChangePassword'));
$newUser->setUnencryptedPassword(Request::getUserVar($i . '_unencryptedPassword'));
$newUserRoles = Request::getUserVar($i . '_roles');
if (is_array($newUserRoles) && count($newUserRoles) > 0) {
foreach ($newUserRoles as $newUserRole) {
if ($newUserRole != '') {
$role = new Role();
$role->setRoleId(RoleDAO::getRoleIdFromPath($newUserRole));
$newUser->AddRole($role);
}
}
}
array_push($users, $newUser);
}
$parser = new UserXMLParser($schedConf->getConferenceId(), $schedConf->getId());
$parser->setUsersToImport($users);
if (!$parser->importUsers($sendNotify, $continueOnError)) {
// Failures occurred
$templateMgr->assign('isError', true);
$templateMgr->assign('errors', $parser->getErrors());
}
$templateMgr->assign('importedUsers', $parser->getImportedUsers());
$templateMgr->display($this->getTemplatePath() . 'importUsersResults.tpl');
break;
case 'exportAll':
$this->import('UserExportDom');
$users =& $roleDao->getUsersBySchedConfId($schedConf->getId());
$users =& $users->toArray();
$doc =& UserExportDom::exportUsers($schedConf, $users);
header("Content-Type: application/xml");
header("Cache-Control: private");
header("Content-Disposition: attachment; filename=\"users.xml\"");
echo XMLCustomWriter::getXML($doc);
break;
case 'exportByRole':
$this->import('UserExportDom');
$users = array();
$rolePaths = array();
foreach (Request::getUserVar('roles') as $rolePath) {
$roleId = $roleDao->getRoleIdFromPath($rolePath);
$thisRoleUsers =& $roleDao->getUsersByRoleId($roleId, $schedConf->getId());
foreach ($thisRoleUsers->toArray() as $user) {
$users[$user->getId()] = $user;
}
$rolePaths[] = $rolePath;
}
$users = array_values($users);
$doc =& UserExportDom::exportUsers($schedConf, $users, $rolePaths);
header("Content-Type: application/xml");
header("Cache-Control: private");
header("Content-Disposition: attachment; filename=\"users.xml\"");
echo XMLCustomWriter::getXML($doc);
break;
default:
$this->setBreadcrumbs();
$templateMgr->display($this->getTemplatePath() . 'index.tpl');
}
}
/**
* Retrieve a list of all copyeditors not assigned to the specified article.
* @param $journalId int
* @param $articleId int
* @return array matching Users
*/
function &getCopyeditorsNotAssignedToArticle($journalId, $articleId, $searchType = null, $search = null, $searchMatch = null)
{
$users = array();
$paramArray = array('interests', $articleId, $journalId, RoleDAO::getRoleIdFromPath('copyeditor'));
$searchSql = '';
if (isset($search)) {
switch ($searchType) {
case USER_FIELD_USERID:
$searchSql = 'AND user_id=?';
$paramArray[] = $search;
break;
case USER_FIELD_FIRSTNAME:
$searchSql = 'AND LOWER(first_name) ' . ($searchMatch == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$paramArray[] = $searchMatch == 'is' ? $search : '%' . $search . '%';
break;
case USER_FIELD_LASTNAME:
$searchSql = 'AND LOWER(last_name) ' . ($searchMatch == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$paramArray[] = $searchMatch == 'is' ? $search : '%' . $search . '%';
break;
case USER_FIELD_USERNAME:
$searchSql = 'AND LOWER(username) ' . ($searchMatch == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$paramArray[] = $searchMatch == 'is' ? $search : '%' . $search . '%';
break;
case USER_FIELD_EMAIL:
$searchSql = 'AND LOWER(email) ' . ($searchMatch == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$paramArray[] = $searchMatch == 'is' ? $search : '%' . $search . '%';
break;
case USER_FIELD_INTERESTS:
$searchSql = 'AND LOWER(setting_value) ' . ($searchMatch == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$paramArray[] = $searchMatch == 'is' ? $search : '%' . $search . '%';
break;
case USER_FIELD_INITIAL:
$searchSql = 'AND (LOWER(last_name) LIKE LOWER(?) OR LOWER(username) LIKE LOWER(?))';
$paramArray[] = $search . '%';
$paramArray[] = $search . '%';
break;
}
}
$result =& $this->retrieve('SELECT u.*
FROM users u
LEFT JOIN user_settings s ON (u.user_id = s.user_id AND s.setting_name = ?)
LEFT JOIN roles r ON (r.user_id = u.user_id)
LEFT JOIN copyed_assignments a ON (a.copyeditor_id = u.user_id AND a.article_id = ?)
WHERE r.journal_id = ? AND
r.role_id = ? AND
a.article_id IS NULL
' . $searchSql . '
ORDER BY last_name, first_name', $paramArray);
while (!$result->EOF) {
$users[] =& $this->userDao->_returnUserFromRowWithData($result->GetRowAssoc(false));
$result->moveNext();
}
$result->Close();
unset($result);
return $users;
}
/**
* @see GridHandler::renderFilter()
*/
function renderFilter($request)
{
// Get filter data.
import('classes.security.RoleDAO');
$roleOptions = array(0 => 'grid.user.allRoles') + RoleDAO::getRoleNames(true);
$filterData = array('roleOptions' => $roleOptions);
return parent::renderFilter($request, $filterData);
}
<input type="text" class="form-control"
id="EditMemberAddress" />
</div>
<div class="form-group">
<label for="EditMemberInstitution">Institution</label>
<input type="text" class="form-control"
id="EditMemberInstitution" />
</div>
<br/>
<div class="form-group">
<label for="EditMemberRole">Role : </label>
<select id="EditMemberRole" >
<?php
require_once "RoleDAO.php";
$roleDAO = new RoleDAO();
try {
$roles = $roleDAO->getAll();
foreach ($roles as $role) {
echo '<option value="' . $role->code . '">' . $role->name . '</option>';
}
} catch (Exception $exception) {
echo $exception->getMessage();
}
?>
</select>
</div>
<div class="form-group">
<label for="EditMemberGender">Gender</label>
