| Server IP : 104.20.45.2 / Your IP : 172.16.20.3 Web Server : Apache/2.4.25 (Debian) System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : application ( 1000) PHP Version : 5.6.40 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /app/classes/user/ |
Upload File : |
<?php
/**
* @file classes/user/UserDAO.inc.php
*
* Copyright (c) 2013-2019 Simon Fraser University
* Copyright (c) 2003-2019 John Willinsky
* Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
*
* @class UserDAO
* @ingroup user
* @see PKPUserDAO
*
* @brief Basic class describing users existing in the system.
*/
import('classes.user.User');
import('lib.pkp.classes.user.PKPUserDAO');
class UserDAO extends PKPUserDAO {
/**
* Renew a membership to dateEnd + 1 year
* if the was expired, renew to current date + 1 year
* @param $user User
*/
function renewMembership(&$user){
$dateEnd = $user->getSetting('dateEndMembership', 0);
if (!$dateEnd) $dateEnd = 0;
// if the membership is expired, extend it to today + 1 year
$time = time();
if ($dateEnd < $time ) $dateEnd = $time;
$dateEnd = mktime(23, 59, 59, date("m", $dateEnd), date("d", $dateEnd), date("Y", $dateEnd)+1);
$user->updateSetting('dateEndMembership', $dateEnd, 'date', 0);
}
/**
* Retrieve an array of journal users matching a particular field value.
* @param $field string the field to match on
* @param $match string "is" for exact match, otherwise assume "like" match
* @param $value mixed the value to match
* @param $allowDisabled boolean
* @param $journalId int optional, return only user from this journal
* @param $dbResultRange object The desired range of results to return
* @return array matching Users
*/
function &getJournalUsersByField($field = USER_FIELD_NONE, $match = null, $value = null, $allowDisabled = true, $journalId = null, $dbResultRange = null) {
$sql = 'SELECT * FROM users u WHERE 1=1';
if ($journalId) $sql = 'SELECT u.* FROM users u LEFT JOIN roles r ON u.user_id=r.user_id WHERE (r.journal_id='.$journalId.' or r.role_id IS NULL)';
switch ($field) {
case USER_FIELD_USERID:
$sql .= ' AND u.user_id = ?';
$var = $value;
break;
case USER_FIELD_USERNAME:
$sql .= ' AND LOWER(u.username) ' . ($match == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$var = $match == 'is' ? $value : "%$value%";
break;
case USER_FIELD_INITIAL:
$sql .= ' AND LOWER(u.last_name) LIKE LOWER(?)';
$var = "$value%";
break;
case USER_FIELD_EMAIL:
$sql .= ' AND LOWER(u.email) ' . ($match == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$var = $match == 'is' ? $value : "%$value%";
break;
case USER_FIELD_URL:
$sql .= ' AND LOWER(u.url) ' . ($match == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$var = $match == 'is' ? $value : "%$value%";
break;
case USER_FIELD_FIRSTNAME:
$sql .= ' AND LOWER(u.first_name) ' . ($match == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$var = $match == 'is' ? $value : "%$value%";
break;
case USER_FIELD_LASTNAME:
$sql .= ' AND LOWER(u.last_name) ' . ($match == 'is' ? '=' : 'LIKE') . ' LOWER(?)';
$var = $match == 'is' ? $value : "%$value%";
break;
}
$groupSql = ' GROUP BY u.user_id';
$orderSql = ' ORDER BY u.last_name, u.first_name'; // FIXME Add "sort field" parameter?
if ($field != USER_FIELD_NONE)
$result =& $this->retrieveRange($sql . ($allowDisabled?'':' AND u.disabled = 0') . $groupSql . $orderSql, $var, $dbResultRange);
else
$result =& $this->retrieveRange($sql . ($allowDisabled?'':' AND u.disabled = 0') . $groupSql . $orderSql, false, $dbResultRange);
$returner = new DAOResultFactory($result, $this, '_returnUserFromRowWithData');
return $returner;
}
function getAdditionalFieldNames() {
return array_merge(parent::getAdditionalFieldNames(), array('orcid'));
}
}
?>