public function getUserPasswordExpiredSoonByContextID($cid, $portal_item = NULL)
{
$days_before_expiring_sendmail = $portal_item->getDaysBeforeExpiringPasswordSendMail();
if (isset($days_before_expiring_sendmail)) {
$date = getCurrentDateTimePlusDaysInMySQL($days_before_expiring_sendmail);
} else {
$date = getCurrentDateTimePlusDaysInMySQL('14');
}
$user = NULL;
$query = "SELECT * FROM " . $this->addDatabasePrefix("user") . " WHERE " . $this->addDatabasePrefix("user") . ".expire_date IS NOT NULL AND " . $this->addDatabasePrefix("user") . ".context_id = '" . encode(AS_DB, $cid) . "' AND " . $this->addDatabasePrefix("user") . ".deletion_date IS NULL AND " . $this->addDatabasePrefix("user") . ".expire_date BETWEEN now() AND '" . encode(AS_DB, $date) . "'";
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems selecting list of ' . $this->_type . ' items.', E_USER_WARNING);
} else {
foreach ($result as $rs) {
$user_array[] = $this->_buildItem($rs);
}
unset($result);
unset($query);
}
return $user_array;
}
function setDaysForLoginAs($days)
{
$this->_addExtra('LOGIN_AS_TMSP', getCurrentDateTimePlusDaysInMySQL($days));
}
