user.js 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724
  1. /* eslint-disable no-use-before-define */
  2. import loggerFactory from '~/utils/logger';
  3. const debug = require('debug')('growi:models:user');
  4. const mongoose = require('mongoose');
  5. const mongoosePaginate = require('mongoose-paginate-v2');
  6. const uniqueValidator = require('mongoose-unique-validator');
  7. const md5 = require('md5');
  8. const ObjectId = mongoose.Schema.Types.ObjectId;
  9. const crypto = require('crypto');
  10. const { listLocaleIds, migrateDeprecatedLocaleId } = require('~/utils/locale-utils');
  11. const { omitInsecureAttributes } = require('./serializers/user-serializer');
  12. const logger = loggerFactory('growi:models:user');
  13. module.exports = function(crowi) {
  14. const STATUS_REGISTERED = 1;
  15. const STATUS_ACTIVE = 2;
  16. const STATUS_SUSPENDED = 3;
  17. const STATUS_DELETED = 4;
  18. const STATUS_INVITED = 5;
  19. const USER_FIELDS_EXCEPT_CONFIDENTIAL = '_id image isEmailPublished isGravatarEnabled googleId name username email introduction'
  20. + ' status lang createdAt lastLoginAt admin imageUrlCached';
  21. const PAGE_ITEMS = 50;
  22. let userEvent;
  23. // init event
  24. if (crowi != null) {
  25. userEvent = crowi.event('user');
  26. userEvent.on('activated', userEvent.onActivated);
  27. }
  28. const userSchema = new mongoose.Schema({
  29. userId: String,
  30. image: String,
  31. imageAttachment: { type: ObjectId, ref: 'Attachment' },
  32. imageUrlCached: String,
  33. isGravatarEnabled: { type: Boolean, default: false },
  34. isEmailPublished: { type: Boolean, default: true },
  35. googleId: String,
  36. name: { type: String },
  37. username: { type: String, required: true, unique: true },
  38. email: { type: String, unique: true, sparse: true },
  39. // === Crowi settings
  40. // username: { type: String, index: true },
  41. // email: { type: String, required: true, index: true },
  42. // === crowi-plus (>= 2.1.0, <2.3.0) settings
  43. // email: { type: String, required: true, unique: true },
  44. introduction: String,
  45. password: String,
  46. apiToken: { type: String, index: true },
  47. lang: {
  48. type: String,
  49. enum: listLocaleIds(),
  50. default: 'en_US',
  51. },
  52. status: {
  53. type: Number, required: true, default: STATUS_ACTIVE, index: true,
  54. },
  55. createdAt: { type: Date, default: Date.now },
  56. lastLoginAt: { type: Date },
  57. admin: { type: Boolean, default: 0, index: true },
  58. isInvitationEmailSended: { type: Boolean, default: false },
  59. }, {
  60. toObject: {
  61. transform: (doc, ret, opt) => {
  62. return omitInsecureAttributes(ret);
  63. },
  64. },
  65. });
  66. // eslint-disable-next-line prefer-arrow-callback
  67. userSchema.pre('validate', function() {
  68. this.lang = migrateDeprecatedLocaleId(this.lang);
  69. });
  70. userSchema.plugin(mongoosePaginate);
  71. userSchema.plugin(uniqueValidator);
  72. function validateCrowi() {
  73. if (crowi == null) {
  74. throw new Error('"crowi" is null. Init User model with "crowi" argument first.');
  75. }
  76. }
  77. function decideUserStatusOnRegistration() {
  78. validateCrowi();
  79. const { configManager, aclService } = crowi;
  80. const isInstalled = configManager.getConfig('crowi', 'app:installed');
  81. if (!isInstalled) {
  82. return STATUS_ACTIVE; // is this ok?
  83. }
  84. // status decided depends on registrationMode
  85. const registrationMode = configManager.getConfig('crowi', 'security:registrationMode');
  86. switch (registrationMode) {
  87. case aclService.labels.SECURITY_REGISTRATION_MODE_OPEN:
  88. return STATUS_ACTIVE;
  89. case aclService.labels.SECURITY_REGISTRATION_MODE_RESTRICTED:
  90. case aclService.labels.SECURITY_REGISTRATION_MODE_CLOSED: // 一応
  91. return STATUS_REGISTERED;
  92. default:
  93. return STATUS_ACTIVE; // どっちにすんのがいいんだろうな
  94. }
  95. }
  96. function generateRandomEmail() {
  97. const randomstr = generateRandomTempPassword();
  98. return `change-it-${randomstr}@example.com`;
  99. }
  100. function generateRandomTempPassword() {
  101. const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789!=-_';
  102. let password = '';
  103. const len = 12;
  104. for (let i = 0; i < len; i++) {
  105. const randomPoz = Math.floor(Math.random() * chars.length);
  106. password += chars.substring(randomPoz, randomPoz + 1);
  107. }
  108. return password;
  109. }
  110. function generatePassword(password) {
  111. validateCrowi();
  112. const hasher = crypto.createHash('sha256');
  113. hasher.update(crowi.env.PASSWORD_SEED + password);
  114. return hasher.digest('hex');
  115. }
  116. function generateApiToken(user) {
  117. const hasher = crypto.createHash('sha256');
  118. hasher.update((new Date()).getTime() + user._id);
  119. return hasher.digest('base64');
  120. }
  121. userSchema.methods.isPasswordSet = function() {
  122. if (this.password) {
  123. return true;
  124. }
  125. return false;
  126. };
  127. userSchema.methods.isPasswordValid = function(password) {
  128. return this.password === generatePassword(password);
  129. };
  130. userSchema.methods.setPassword = function(password) {
  131. this.password = generatePassword(password);
  132. return this;
  133. };
  134. userSchema.methods.isEmailSet = function() {
  135. if (this.email) {
  136. return true;
  137. }
  138. return false;
  139. };
  140. userSchema.methods.updateLastLoginAt = function(lastLoginAt, callback) {
  141. this.lastLoginAt = lastLoginAt;
  142. this.save((err, userData) => {
  143. return callback(err, userData);
  144. });
  145. };
  146. userSchema.methods.updateIsGravatarEnabled = async function(isGravatarEnabled) {
  147. this.isGravatarEnabled = isGravatarEnabled;
  148. await this.updateImageUrlCached();
  149. const userData = await this.save();
  150. return userData;
  151. };
  152. userSchema.methods.updatePassword = async function(password) {
  153. this.setPassword(password);
  154. const userData = await this.save();
  155. return userData;
  156. };
  157. userSchema.methods.canDeleteCompletely = function(creatorId) {
  158. const pageCompleteDeletionAuthority = crowi.configManager.getConfig('crowi', 'security:pageCompleteDeletionAuthority');
  159. if (this.admin) {
  160. return true;
  161. }
  162. if (pageCompleteDeletionAuthority === 'anyOne' || pageCompleteDeletionAuthority == null) {
  163. return true;
  164. }
  165. if (pageCompleteDeletionAuthority === 'adminAndAuthor') {
  166. return (this._id.equals(creatorId));
  167. }
  168. return false;
  169. };
  170. userSchema.methods.updateApiToken = async function() {
  171. const self = this;
  172. self.apiToken = generateApiToken(this);
  173. const userData = await self.save();
  174. return userData;
  175. };
  176. // TODO: create UserService and transplant this method because image uploading depends on AttachmentService
  177. userSchema.methods.updateImage = async function(attachment) {
  178. this.imageAttachment = attachment;
  179. await this.updateImageUrlCached();
  180. return this.save();
  181. };
  182. // TODO: create UserService and transplant this method because image deletion depends on AttachmentService
  183. userSchema.methods.deleteImage = async function() {
  184. validateCrowi();
  185. // the 'image' field became DEPRECATED in v3.3.8
  186. this.image = undefined;
  187. if (this.imageAttachment != null) {
  188. const { attachmentService } = crowi;
  189. attachmentService.removeAttachment(this.imageAttachment._id);
  190. }
  191. this.imageAttachment = undefined;
  192. this.updateImageUrlCached();
  193. return this.save();
  194. };
  195. userSchema.methods.updateImageUrlCached = async function() {
  196. this.imageUrlCached = await this.generateImageUrlCached();
  197. };
  198. userSchema.methods.generateImageUrlCached = async function() {
  199. if (this.isGravatarEnabled) {
  200. const email = this.email || '';
  201. const hash = md5(email.trim().toLowerCase());
  202. return `https://gravatar.com/avatar/${hash}`;
  203. }
  204. if (this.image != null) {
  205. return this.image;
  206. }
  207. if (this.imageAttachment != null && this.imageAttachment._id != null) {
  208. const Attachment = crowi.model('Attachment');
  209. const imageAttachment = await Attachment.findById(this.imageAttachment);
  210. return imageAttachment.filePathProxied;
  211. }
  212. return '/images/icons/user.svg';
  213. };
  214. userSchema.methods.updateGoogleId = function(googleId, callback) {
  215. this.googleId = googleId;
  216. this.save((err, userData) => {
  217. return callback(err, userData);
  218. });
  219. };
  220. userSchema.methods.deleteGoogleId = function(callback) {
  221. return this.updateGoogleId(null, callback);
  222. };
  223. userSchema.methods.activateInvitedUser = async function(username, name, password) {
  224. this.setPassword(password);
  225. this.name = name;
  226. this.username = username;
  227. this.status = STATUS_ACTIVE;
  228. this.isEmailPublished = crowi.configManager.getConfig('crowi', 'customize:isEmailPublishedForNewUser');
  229. this.save((err, userData) => {
  230. userEvent.emit('activated', userData);
  231. if (err) {
  232. throw new Error(err);
  233. }
  234. return userData;
  235. });
  236. };
  237. userSchema.methods.removeFromAdmin = async function() {
  238. debug('Remove from admin', this);
  239. this.admin = 0;
  240. return this.save();
  241. };
  242. userSchema.methods.makeAdmin = async function() {
  243. debug('Admin', this);
  244. this.admin = 1;
  245. return this.save();
  246. };
  247. userSchema.methods.asyncMakeAdmin = async function(callback) {
  248. this.admin = 1;
  249. return this.save();
  250. };
  251. userSchema.methods.statusActivate = async function() {
  252. debug('Activate User', this);
  253. this.status = STATUS_ACTIVE;
  254. const userData = await this.save();
  255. return userEvent.emit('activated', userData);
  256. };
  257. userSchema.methods.statusSuspend = async function() {
  258. debug('Suspend User', this);
  259. this.status = STATUS_SUSPENDED;
  260. if (this.email === undefined || this.email === null) { // migrate old data
  261. this.email = '-';
  262. }
  263. if (this.name === undefined || this.name === null) { // migrate old data
  264. this.name = `-${Date.now()}`;
  265. }
  266. if (this.username === undefined || this.usename === null) { // migrate old data
  267. this.username = '-';
  268. }
  269. return this.save();
  270. };
  271. userSchema.methods.statusDelete = async function() {
  272. debug('Delete User', this);
  273. const now = new Date();
  274. const deletedLabel = `deleted_at_${now.getTime()}`;
  275. this.status = STATUS_DELETED;
  276. this.username = deletedLabel;
  277. this.password = '';
  278. this.name = '';
  279. this.email = `${deletedLabel}@deleted`;
  280. this.googleId = null;
  281. this.isGravatarEnabled = false;
  282. this.image = null;
  283. return this.save();
  284. };
  285. userSchema.statics.getUserStatusLabels = function() {
  286. const userStatus = {};
  287. userStatus[STATUS_REGISTERED] = 'Approval Pending';
  288. userStatus[STATUS_ACTIVE] = 'Active';
  289. userStatus[STATUS_SUSPENDED] = 'Suspended';
  290. userStatus[STATUS_DELETED] = 'Deleted';
  291. userStatus[STATUS_INVITED] = 'Invited';
  292. return userStatus;
  293. };
  294. userSchema.statics.isEmailValid = function(email, callback) {
  295. validateCrowi();
  296. const whitelist = crowi.configManager.getConfig('crowi', 'security:registrationWhiteList');
  297. if (Array.isArray(whitelist) && whitelist.length > 0) {
  298. return whitelist.some((allowedEmail) => {
  299. const re = new RegExp(`${allowedEmail}$`);
  300. return re.test(email);
  301. });
  302. }
  303. return true;
  304. };
  305. userSchema.statics.findUsers = function(options, callback) {
  306. const sort = options.sort || { status: 1, createdAt: 1 };
  307. this.find()
  308. .sort(sort)
  309. .skip(options.skip || 0)
  310. .limit(options.limit || 21)
  311. .exec((err, userData) => {
  312. callback(err, userData);
  313. });
  314. };
  315. userSchema.statics.findAllUsers = function(option) {
  316. // eslint-disable-next-line no-param-reassign
  317. option = option || {};
  318. const sort = option.sort || { createdAt: -1 };
  319. const fields = option.fields || {};
  320. let status = option.status || [STATUS_ACTIVE, STATUS_SUSPENDED];
  321. if (!Array.isArray(status)) {
  322. status = [status];
  323. }
  324. return this.find()
  325. .or(status.map((s) => { return { status: s } }))
  326. .select(fields)
  327. .sort(sort);
  328. };
  329. userSchema.statics.findUsersByIds = function(ids, option) {
  330. // eslint-disable-next-line no-param-reassign
  331. option = option || {};
  332. const sort = option.sort || { createdAt: -1 };
  333. const status = option.status || STATUS_ACTIVE;
  334. const fields = option.fields || {};
  335. return this.find({ _id: { $in: ids }, status })
  336. .select(fields)
  337. .sort(sort);
  338. };
  339. userSchema.statics.findAdmins = async function() {
  340. return this.find({ admin: true });
  341. };
  342. userSchema.statics.findUserByUsername = function(username) {
  343. if (username == null) {
  344. return Promise.resolve(null);
  345. }
  346. return this.findOne({ username });
  347. };
  348. userSchema.statics.findUserByApiToken = function(apiToken) {
  349. if (apiToken == null) {
  350. return Promise.resolve(null);
  351. }
  352. return this.findOne({ apiToken });
  353. };
  354. userSchema.statics.findUserByGoogleId = function(googleId, callback) {
  355. if (googleId == null) {
  356. callback(null, null);
  357. }
  358. this.findOne({ googleId }, (err, userData) => {
  359. callback(err, userData);
  360. });
  361. };
  362. userSchema.statics.findUserByUsernameOrEmail = function(usernameOrEmail, password, callback) {
  363. this.findOne()
  364. .or([
  365. { username: usernameOrEmail },
  366. { email: usernameOrEmail },
  367. ])
  368. .exec((err, userData) => {
  369. callback(err, userData);
  370. });
  371. };
  372. userSchema.statics.findUserByEmailAndPassword = function(email, password, callback) {
  373. const hashedPassword = generatePassword(password);
  374. this.findOne({ email, password: hashedPassword }, (err, userData) => {
  375. callback(err, userData);
  376. });
  377. };
  378. userSchema.statics.isUserCountExceedsUpperLimit = async function() {
  379. const { configManager } = crowi;
  380. const userUpperLimit = configManager.getConfig('crowi', 'security:userUpperLimit');
  381. const activeUsers = await this.countListByStatus(STATUS_ACTIVE);
  382. if (userUpperLimit <= activeUsers) {
  383. return true;
  384. }
  385. return false;
  386. };
  387. userSchema.statics.countListByStatus = async function(status) {
  388. const User = this;
  389. const conditions = { status };
  390. // TODO count は非推奨。mongoose のバージョンアップ後に countDocuments に変更する。
  391. return User.count(conditions);
  392. };
  393. userSchema.statics.isRegisterableUsername = async function(username) {
  394. let usernameUsable = true;
  395. const userData = await this.findOne({ username });
  396. if (userData) {
  397. usernameUsable = false;
  398. }
  399. return usernameUsable;
  400. };
  401. userSchema.statics.isRegisterableEmail = async function(email) {
  402. let isEmailUsable = true;
  403. const userData = await this.findOne({ email });
  404. if (userData) {
  405. isEmailUsable = false;
  406. }
  407. return isEmailUsable;
  408. };
  409. userSchema.statics.isRegisterable = function(email, username, callback) {
  410. const User = this;
  411. let emailUsable = true;
  412. let usernameUsable = true;
  413. // username check
  414. this.findOne({ username }, (err, userData) => {
  415. if (userData) {
  416. usernameUsable = false;
  417. }
  418. // email check
  419. User.findOne({ email }, (err, userData) => {
  420. if (userData) {
  421. emailUsable = false;
  422. }
  423. if (!emailUsable || !usernameUsable) {
  424. return callback(false, { email: emailUsable, username: usernameUsable });
  425. }
  426. return callback(true, {});
  427. });
  428. });
  429. };
  430. userSchema.statics.resetPasswordByRandomString = async function(id) {
  431. const user = await this.findById(id);
  432. if (!user) {
  433. throw new Error('User not found');
  434. }
  435. const newPassword = generateRandomTempPassword();
  436. user.setPassword(newPassword);
  437. await user.save();
  438. return newPassword;
  439. };
  440. userSchema.statics.createUserByEmail = async function(email) {
  441. const configManager = crowi.configManager;
  442. const User = this;
  443. const newUser = new User();
  444. /* eslint-disable newline-per-chained-call */
  445. const tmpUsername = `temp_${Math.random().toString(36).slice(-16)}`;
  446. const password = Math.random().toString(36).slice(-16);
  447. /* eslint-enable newline-per-chained-call */
  448. newUser.username = tmpUsername;
  449. newUser.email = email;
  450. newUser.setPassword(password);
  451. newUser.createdAt = Date.now();
  452. newUser.status = STATUS_INVITED;
  453. const globalLang = configManager.getConfig('crowi', 'app:globalLang');
  454. if (globalLang != null) {
  455. newUser.lang = globalLang;
  456. }
  457. try {
  458. const newUserData = await newUser.save();
  459. return {
  460. email,
  461. password,
  462. user: newUserData,
  463. };
  464. }
  465. catch (err) {
  466. return {
  467. email,
  468. };
  469. }
  470. };
  471. userSchema.statics.createUsersByEmailList = async function(emailList) {
  472. const User = this;
  473. // check exists and get list of try to create
  474. const existingUserList = await User.find({ email: { $in: emailList }, userStatus: { $ne: STATUS_DELETED } });
  475. const existingEmailList = existingUserList.map((user) => { return user.email });
  476. const creationEmailList = emailList.filter((email) => { return existingEmailList.indexOf(email) === -1 });
  477. const createdUserList = [];
  478. const failedToCreateUserEmailList = [];
  479. for (const email of creationEmailList) {
  480. try {
  481. // eslint-disable-next-line no-await-in-loop
  482. const createdUser = await this.createUserByEmail(email);
  483. createdUserList.push(createdUser);
  484. }
  485. catch (err) {
  486. logger.error(err);
  487. failedToCreateUserEmailList.push({
  488. email,
  489. reason: err.message,
  490. });
  491. }
  492. }
  493. return { createdUserList, existingEmailList, failedToCreateUserEmailList };
  494. };
  495. userSchema.statics.createUserByEmailAndPasswordAndStatus = async function(name, username, email, password, lang, status, callback) {
  496. const User = this;
  497. const newUser = new User();
  498. // check user upper limit
  499. const isUserCountExceedsUpperLimit = await User.isUserCountExceedsUpperLimit();
  500. if (isUserCountExceedsUpperLimit) {
  501. const err = new UserUpperLimitException();
  502. return callback(err);
  503. }
  504. // check email duplication because email must be unique
  505. const count = await this.count({ email });
  506. if (count > 0) {
  507. // eslint-disable-next-line no-param-reassign
  508. email = generateRandomEmail();
  509. }
  510. newUser.name = name;
  511. newUser.username = username;
  512. newUser.email = email;
  513. if (password != null) {
  514. newUser.setPassword(password);
  515. }
  516. const configManager = crowi.configManager;
  517. // Default email show/hide is up to the administrator
  518. newUser.isEmailPublished = configManager.getConfig('crowi', 'customize:isEmailPublishedForNewUser');
  519. const globalLang = configManager.getConfig('crowi', 'app:globalLang');
  520. if (globalLang != null) {
  521. newUser.lang = globalLang;
  522. }
  523. if (lang != null) {
  524. newUser.lang = lang;
  525. }
  526. newUser.createdAt = Date.now();
  527. newUser.status = status || decideUserStatusOnRegistration();
  528. newUser.save((err, userData) => {
  529. if (err) {
  530. logger.error('createUserByEmailAndPasswordAndStatus failed: ', err);
  531. return callback(err);
  532. }
  533. if (userData.status === STATUS_ACTIVE) {
  534. userEvent.emit('activated', userData);
  535. }
  536. return callback(err, userData);
  537. });
  538. };
  539. /**
  540. * A wrapper function of createUserByEmailAndPasswordAndStatus with callback
  541. *
  542. */
  543. userSchema.statics.createUserByEmailAndPassword = function(name, username, email, password, lang, callback) {
  544. this.createUserByEmailAndPasswordAndStatus(name, username, email, password, lang, undefined, callback);
  545. };
  546. /**
  547. * A wrapper function of createUserByEmailAndPasswordAndStatus
  548. *
  549. * @return {Promise<User>}
  550. */
  551. userSchema.statics.createUser = function(name, username, email, password, lang, status) {
  552. const User = this;
  553. return new Promise((resolve, reject) => {
  554. User.createUserByEmailAndPasswordAndStatus(name, username, email, password, lang, status, (err, userData) => {
  555. if (err) {
  556. return reject(err);
  557. }
  558. return resolve(userData);
  559. });
  560. });
  561. };
  562. userSchema.statics.getUsernameByPath = function(path) {
  563. let username = null;
  564. const match = path.match(/^\/user\/([^/]+)\/?/);
  565. if (match) {
  566. username = match[1];
  567. }
  568. return username;
  569. };
  570. userSchema.statics.updateIsInvitationEmailSended = async function(id) {
  571. const user = await this.findById(id);
  572. if (user == null) {
  573. throw new Error('User not found');
  574. }
  575. if (user.status !== 5) {
  576. throw new Error('The status of the user is not "invited"');
  577. }
  578. user.isInvitationEmailSended = true;
  579. user.save();
  580. };
  581. class UserUpperLimitException {
  582. constructor() {
  583. this.name = this.constructor.name;
  584. }
  585. }
  586. userSchema.statics.STATUS_REGISTERED = STATUS_REGISTERED;
  587. userSchema.statics.STATUS_ACTIVE = STATUS_ACTIVE;
  588. userSchema.statics.STATUS_SUSPENDED = STATUS_SUSPENDED;
  589. userSchema.statics.STATUS_DELETED = STATUS_DELETED;
  590. userSchema.statics.STATUS_INVITED = STATUS_INVITED;
  591. userSchema.statics.USER_FIELDS_EXCEPT_CONFIDENTIAL = USER_FIELDS_EXCEPT_CONFIDENTIAL;
  592. userSchema.statics.PAGE_ITEMS = PAGE_ITEMS;
  593. return mongoose.model('User', userSchema);
  594. };