user.js 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295
  1. const graphHelper = require('../../helpers/graph')
  2. const _ = require('lodash')
  3. /* global WIKI */
  4. module.exports = {
  5. Query: {
  6. /**
  7. * FETCH ALL USERS
  8. */
  9. async users (obj, args, context, info) {
  10. // -> Sanitize limit
  11. let limit = args.pageSize ?? 20
  12. if (limit < 1 || limit > 1000) {
  13. limit = 1000
  14. }
  15. // -> Sanitize offset
  16. let offset = args.page ?? 1
  17. if (offset < 1) {
  18. offset = 1
  19. }
  20. // -> Fetch Users
  21. return WIKI.models.users.query()
  22. .select('id', 'email', 'name', 'isSystem', 'isActive', 'createdAt', 'lastLoginAt')
  23. .where(builder => {
  24. if (args.filter) {
  25. builder.where('email', 'like', `%${args.filter}%`)
  26. .orWhere('name', 'like', `%${args.filter}%`)
  27. }
  28. })
  29. .orderBy(args.orderBy ?? 'name', args.orderByDirection ?? 'asc')
  30. .offset((offset - 1) * limit)
  31. .limit(limit)
  32. },
  33. /**
  34. * FETCH A SINGLE USER
  35. */
  36. async userById (obj, args, context, info) {
  37. const usr = await WIKI.models.users.query().findById(args.id)
  38. if (!usr) {
  39. throw new Error('Invalid User')
  40. }
  41. // const str = _.get(WIKI.auth.strategies, usr.providerKey)
  42. // str.strategy = _.find(WIKI.data.authentication, ['key', str.strategyKey])
  43. // usr.providerName = str.displayName
  44. // usr.providerIs2FACapable = _.get(str, 'strategy.useForm', false)
  45. usr.auth = _.mapValues(usr.auth, (auth, providerKey) => {
  46. if (auth.password) {
  47. auth.password = '***'
  48. }
  49. auth.module = providerKey === '00910749-8ab6-498a-9be0-f4ca28ea5e52' ? 'google' : 'local'
  50. auth._moduleName = providerKey === '00910749-8ab6-498a-9be0-f4ca28ea5e52' ? 'Google' : 'Local'
  51. return auth
  52. })
  53. return usr
  54. },
  55. // async profile (obj, args, context, info) {
  56. // if (!context.req.user || context.req.user.id < 1 || context.req.user.id === 2) {
  57. // throw new WIKI.Error.AuthRequired()
  58. // }
  59. // const usr = await WIKI.models.users.query().findById(context.req.user.id)
  60. // if (!usr.isActive) {
  61. // throw new WIKI.Error.AuthAccountBanned()
  62. // }
  63. // const providerInfo = _.get(WIKI.auth.strategies, usr.providerKey, {})
  64. // usr.providerName = providerInfo.displayName || 'Unknown'
  65. // usr.lastLoginAt = usr.lastLoginAt || usr.updatedAt
  66. // usr.password = ''
  67. // usr.providerId = ''
  68. // usr.tfaSecret = ''
  69. // return usr
  70. // },
  71. async lastLogins (obj, args, context, info) {
  72. return WIKI.models.users.query()
  73. .select('id', 'name', 'lastLoginAt')
  74. .whereNotNull('lastLoginAt')
  75. .orderBy('lastLoginAt', 'desc')
  76. .limit(10)
  77. }
  78. },
  79. Mutation: {
  80. async createUser (obj, args) {
  81. try {
  82. await WIKI.models.users.createNewUser({ ...args, passwordRaw: args.password, isVerified: true })
  83. return {
  84. operation: graphHelper.generateSuccess('User created successfully')
  85. }
  86. } catch (err) {
  87. return graphHelper.generateError(err)
  88. }
  89. },
  90. async deleteUser (obj, args) {
  91. try {
  92. if (args.id <= 2) {
  93. throw new WIKI.Error.UserDeleteProtected()
  94. }
  95. await WIKI.models.users.deleteUser(args.id, args.replaceId)
  96. WIKI.auth.revokeUserTokens({ id: args.id, kind: 'u' })
  97. WIKI.events.outbound.emit('addAuthRevoke', { id: args.id, kind: 'u' })
  98. return {
  99. operation: graphHelper.generateSuccess('User deleted successfully')
  100. }
  101. } catch (err) {
  102. if (err.message.indexOf('foreign') >= 0) {
  103. return graphHelper.generateError(new WIKI.Error.UserDeleteForeignConstraint())
  104. } else {
  105. return graphHelper.generateError(err)
  106. }
  107. }
  108. },
  109. async updateUser (obj, args) {
  110. try {
  111. await WIKI.models.users.updateUser(args.id, args.patch)
  112. return {
  113. operation: graphHelper.generateSuccess('User updated successfully')
  114. }
  115. } catch (err) {
  116. return graphHelper.generateError(err)
  117. }
  118. },
  119. async verifyUser (obj, args) {
  120. try {
  121. await WIKI.models.users.query().patch({ isVerified: true }).findById(args.id)
  122. return {
  123. operation: graphHelper.generateSuccess('User verified successfully')
  124. }
  125. } catch (err) {
  126. return graphHelper.generateError(err)
  127. }
  128. },
  129. async activateUser (obj, args) {
  130. try {
  131. await WIKI.models.users.query().patch({ isActive: true }).findById(args.id)
  132. return {
  133. operation: graphHelper.generateSuccess('User activated successfully')
  134. }
  135. } catch (err) {
  136. return graphHelper.generateError(err)
  137. }
  138. },
  139. async deactivateUser (obj, args) {
  140. try {
  141. if (args.id <= 2) {
  142. throw new Error('Cannot deactivate system accounts.')
  143. }
  144. await WIKI.models.users.query().patch({ isActive: false }).findById(args.id)
  145. WIKI.auth.revokeUserTokens({ id: args.id, kind: 'u' })
  146. WIKI.events.outbound.emit('addAuthRevoke', { id: args.id, kind: 'u' })
  147. return {
  148. operation: graphHelper.generateSuccess('User deactivated successfully')
  149. }
  150. } catch (err) {
  151. return graphHelper.generateError(err)
  152. }
  153. },
  154. async enableUserTFA (obj, args) {
  155. try {
  156. await WIKI.models.users.query().patch({ tfaIsActive: true, tfaSecret: null }).findById(args.id)
  157. return {
  158. operation: graphHelper.generateSuccess('User 2FA enabled successfully')
  159. }
  160. } catch (err) {
  161. return graphHelper.generateError(err)
  162. }
  163. },
  164. async disableUserTFA (obj, args) {
  165. try {
  166. await WIKI.models.users.query().patch({ tfaIsActive: false, tfaSecret: null }).findById(args.id)
  167. return {
  168. operation: graphHelper.generateSuccess('User 2FA disabled successfully')
  169. }
  170. } catch (err) {
  171. return graphHelper.generateError(err)
  172. }
  173. },
  174. resetUserPassword (obj, args) {
  175. return false
  176. },
  177. async updateProfile (obj, args, context) {
  178. try {
  179. if (!context.req.user || context.req.user.id === WIKI.auth.guest.id) {
  180. throw new WIKI.Error.AuthRequired()
  181. }
  182. const usr = await WIKI.models.users.query().findById(context.req.user.id)
  183. if (!usr.isActive) {
  184. throw new WIKI.Error.AuthAccountBanned()
  185. }
  186. if (!usr.isVerified) {
  187. throw new WIKI.Error.AuthAccountNotVerified()
  188. }
  189. if (args.dateFormat && !['', 'DD/MM/YYYY', 'DD.MM.YYYY', 'MM/DD/YYYY', 'YYYY-MM-DD', 'YYYY/MM/DD'].includes(args.dateFormat)) {
  190. throw new WIKI.Error.InputInvalid()
  191. }
  192. if (args.appearance && !['site', 'light', 'dark'].includes(args.appearance)) {
  193. throw new WIKI.Error.InputInvalid()
  194. }
  195. await WIKI.models.users.query().findById(usr.id).patch({
  196. name: args.name?.trim() ?? usr.name,
  197. meta: {
  198. ...usr.meta,
  199. location: args.location?.trim() ?? usr.meta.location,
  200. jobTitle: args.jobTitle?.trim() ?? usr.meta.jobTitle,
  201. pronouns: args.pronouns?.trim() ?? usr.meta.pronouns
  202. },
  203. prefs: {
  204. ...usr.prefs,
  205. timezone: args.timezone || usr.prefs.timezone,
  206. dateFormat: args.dateFormat ?? usr.prefs.dateFormat,
  207. timeFormat: args.timeFormat ?? usr.prefs.timeFormat,
  208. appearance: args.appearance || usr.prefs.appearance
  209. }
  210. })
  211. return {
  212. operation: graphHelper.generateSuccess('User profile updated successfully')
  213. }
  214. } catch (err) {
  215. return graphHelper.generateError(err)
  216. }
  217. },
  218. async changePassword (obj, args, context) {
  219. try {
  220. if (!context.req.user || context.req.user.id < 1 || context.req.user.id === 2) {
  221. throw new WIKI.Error.AuthRequired()
  222. }
  223. const usr = await WIKI.models.users.query().findById(context.req.user.id)
  224. if (!usr.isActive) {
  225. throw new WIKI.Error.AuthAccountBanned()
  226. }
  227. if (!usr.isVerified) {
  228. throw new WIKI.Error.AuthAccountNotVerified()
  229. }
  230. if (usr.providerKey !== 'local') {
  231. throw new WIKI.Error.AuthProviderInvalid()
  232. }
  233. try {
  234. await usr.verifyPassword(args.current)
  235. } catch (err) {
  236. throw new WIKI.Error.AuthPasswordInvalid()
  237. }
  238. await WIKI.models.users.updateUser({
  239. id: usr.id,
  240. newPassword: args.new
  241. })
  242. const newToken = await WIKI.models.users.refreshToken(usr)
  243. return {
  244. responseResult: graphHelper.generateSuccess('Password changed successfully'),
  245. jwt: newToken.token
  246. }
  247. } catch (err) {
  248. return graphHelper.generateError(err)
  249. }
  250. }
  251. },
  252. User: {
  253. groups (usr) {
  254. return usr.$relatedQuery('groups')
  255. }
  256. }
  257. // UserProfile: {
  258. // async groups (usr) {
  259. // const usrGroups = await usr.$relatedQuery('groups')
  260. // return usrGroups.map(g => g.name)
  261. // },
  262. // async pagesTotal (usr) {
  263. // const result = await WIKI.models.pages.query().count('* as total').where('creatorId', usr.id).first()
  264. // return _.toSafeInteger(result.total)
  265. // }
  266. // }
  267. }