Server : Apache/2.4.41 (Ubuntu) System : Linux journalup 5.4.0-198-generic #218-Ubuntu SMP Fri Sep 27 20:18:53 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory : /var/www/html/classes/article/
Upload File :
Current File : /var/www/html/classes/article/AuthorDAO.inc.php
<?php
/**
* @file classes/article/AuthorDAO.inc.php
*
* Copyright (c) 2014-2020 Simon Fraser University
* Copyright (c) 2003-2020 John Willinsky
* Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
*
* @class AuthorDAO
* @ingroup article
* @see Author
*
* @brief Operations for retrieving and modifying Author objects.
*/
import('classes.article.Author');
import('classes.submission.Submission');
import('lib.pkp.classes.submission.PKPAuthorDAO');
class AuthorDAO extends PKPAuthorDAO {
/**
* Retrieve all published authors for a journal by the first letter of the family name.
* Authors will be sorted by (family, given). Note that if journalId is null,
* alphabetized authors for all enabled journals are returned.
* If authors have the same given names, first names and affiliations in all journal locales,
* as well as country and email (otional), they are considered to be the same.
* @param $journalId int Optional journal ID to restrict results to
* @param $initial An initial a family name must begin with, "-" for authors with no family names
* @param $rangeInfo Range information
* @param $includeEmail boolean Whether or not to include the email in the select distinct
* @return DAOResultFactory Authors ordered by last name, given name
*/
function getAuthorsAlphabetizedByJournal($journalId = null, $initial = null, $rangeInfo = null, $includeEmail = false) {
$locale = AppLocale::getLocale();
$params = array(
IDENTITY_SETTING_GIVENNAME, $locale,
IDENTITY_SETTING_GIVENNAME,
IDENTITY_SETTING_FAMILYNAME, $locale,
IDENTITY_SETTING_FAMILYNAME,
'issueId',
);
if (isset($journalId)) $params[] = $journalId;
$supportedLocales = array();
if ($journalId !== null) {
$journalDao = DAORegistry::getDAO('JournalDAO'); /* @var $journalDao JournalDAO */
$journal = $journalDao->getById($journalId);
$supportedLocales = $journal->getSupportedLocales();
} else {
$site = Application::get()->getRequest()->getSite();
$supportedLocales = $site->getSupportedLocales();
}
$supportedLocalesCount = count($supportedLocales);
$sqlJoinAuthorSettings = $sqlColumnsAuthorSettings = $initialSql = '';
if (isset($initial)) {
$initialSql = ' AND (';
}
$index = 0;
foreach ($supportedLocales as $locale) {
$localeStr = str_replace('@', '_', $locale);
$sqlColumnsAuthorSettings .= ",
COALESCE(asg$index.setting_value, ''), ' ',
COALESCE(asf$index.setting_value, ''), ' ',
COALESCE(SUBSTRING(asa$index.setting_value FROM 1 FOR 255), ''), ' '
";
$sqlJoinAuthorSettings .= "
LEFT JOIN author_settings asg$index ON (asg$index.author_id = aa.author_id AND asg$index.setting_name = '" . IDENTITY_SETTING_GIVENNAME . "' AND asg$index.locale = '$locale')
LEFT JOIN author_settings asf$index ON (asf$index.author_id = aa.author_id AND asf$index.setting_name = '" . IDENTITY_SETTING_FAMILYNAME . "' AND asf$index.locale = '$locale')
LEFT JOIN author_settings asa$index ON (asa$index.author_id = aa.author_id AND asa$index.setting_name = 'affiliation' AND asa$index.locale = '$locale')
";
if (isset($initial)) {
if ($initial == '-') {
$initialSql .= "(asf$index.setting_value IS NULL OR asf$index.setting_value = '')";
if ($index < $supportedLocalesCount - 1) {
$initialSql .= ' AND ';
}
} else {
$params[] = PKPString::strtolower($initial) . '%';
$initialSql .= "LOWER(asf$index.setting_value) LIKE LOWER(?)";
if ($index < $supportedLocalesCount - 1) {
$initialSql .= ' OR ';
}
}
}
$index++;
}
if (isset($initial)) {
$initialSql .= ')';
}
$result = $this->retrieveRange(
'SELECT a.*, ug.show_title, p.locale,
COALESCE(agl.setting_value, agpl.setting_value) AS author_given,
CASE WHEN agl.setting_value <> \'\' THEN afl.setting_value ELSE afpl.setting_value END AS author_family
FROM authors a
JOIN user_groups ug ON (a.user_group_id = ug.user_group_id)
JOIN publications p ON (p.publication_id = a.publication_id)
JOIN submissions s ON (s.current_publication_id = p.publication_id)
LEFT JOIN author_settings agl ON (a.author_id = agl.author_id AND agl.setting_name = ? AND agl.locale = ?)
LEFT JOIN author_settings agpl ON (a.author_id = agpl.author_id AND agpl.setting_name = ? AND agpl.locale = p.locale)
LEFT JOIN author_settings afl ON (a.author_id = afl.author_id AND afl.setting_name = ? AND afl.locale = ?)
LEFT JOIN author_settings afpl ON (a.author_id = afpl.author_id AND afpl.setting_name = ? AND afpl.locale = p.locale)
JOIN (
SELECT
MIN(aa.author_id) as author_id,
CONCAT(
' . ($includeEmail ? 'aa.email, \' \', ' : '') . '
ac.setting_value,
\' \'
' . $sqlColumnsAuthorSettings . '
) as names
FROM authors aa
JOIN publications pp ON (pp.publication_id = aa.publication_id)
LEFT JOIN publication_settings ppss ON (ppss.publication_id = pp.publication_id)
JOIN submissions ss ON (ss.submission_id = pp.submission_id AND ss.current_publication_id = pp.publication_id AND ss.status = ' . STATUS_PUBLISHED . ')
JOIN journals j ON (ss.context_id = j.journal_id)
JOIN issues i ON (ppss.setting_name = ? AND ppss.setting_value = CAST(i.issue_id AS CHAR(20)) AND i.published = 1)
LEFT JOIN author_settings ac ON (ac.author_id = aa.author_id AND ac.setting_name = \'country\')
' . $sqlJoinAuthorSettings . '
WHERE j.enabled = 1
' . (isset($journalId) ? ' AND j.journal_id = ?' : '')
. $initialSql . '
GROUP BY names
) as t1 ON (t1.author_id = a.author_id)
ORDER BY author_family, author_given',
$params,
$rangeInfo
);
return new DAOResultFactory($result, $this, '_fromRow');
}
}
