user.js 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. /**
  2. * 用户数据结构
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/6/28
  6. * @version
  7. */
  8. let mongoose = require("mongoose");
  9. let Schema = mongoose.Schema;
  10. // 表名
  11. let collectionName = 'user';
  12. const invalidSchema = new Schema({
  13. invalid: Boolean,
  14. invalidDate: String,
  15. invalidBy: String //管理者名
  16. });
  17. const versionSchema = new Schema({
  18. compilationId: String,
  19. activateCode: String,
  20. activatedDate: String,
  21. activatedBy: String,
  22. invalidInfo: [invalidSchema]
  23. });
  24. let upgrade = mongoose.Schema({
  25. compilationID:String,//编办ID
  26. upgrade_time:Number,
  27. isUpgrade:Boolean,
  28. remark:String//描述:广东办刘飞 2018-06-17 启用/关闭
  29. }, { _id: false })
  30. const userdList = mongoose.Schema({
  31. compilationId: String
  32. }, {_id: false});
  33. // 表结构
  34. let schema = {
  35. ssoId: Number,
  36. username: String,
  37. email: String,
  38. mobile: String,
  39. qq: {
  40. type: String,
  41. default: ''
  42. },
  43. real_name: {
  44. type: String,
  45. default: ''
  46. },
  47. company: {
  48. type: String,
  49. default: ''
  50. },
  51. province: {
  52. type: Number,
  53. default: -1
  54. },
  55. version: {
  56. type: [versionSchema],
  57. default: []
  58. },
  59. company_type: {
  60. type: Number,
  61. default: -1,
  62. },
  63. company_scale: {
  64. type: Number,
  65. default: -1
  66. },
  67. // 最后登录时间
  68. latest_login: {
  69. type: Number,
  70. default: 0
  71. },
  72. //最近使用编办
  73. latest_used:String,
  74. create_time: Number,
  75. upgrade_list:[upgrade],
  76. user_type:{
  77. type:String,
  78. default:'normal'// normal : 普通用户,test:测试用户
  79. },
  80. //使用过的费用定额,主要目的拷贝用户在该费用定额下的一些数据模板 eg:用户第一次进入该费用定额的补充定额库时,拷贝补充定额的章节树
  81. used_list: {
  82. type: [userdList],
  83. default: []
  84. },
  85. // 联系人
  86. contacts: {
  87. type: Array,
  88. default: []
  89. },
  90. // 是否邮箱已通过验证
  91. isUserActive: Number,
  92. // 是否只允许短信登录
  93. isSmsLogin: {
  94. type: Number,
  95. default: 0
  96. },
  97. // 登录异常短信通知
  98. isLoginValid: {
  99. type: Number,
  100. default: 0
  101. },
  102. welcomeShowTime:String
  103. };
  104. mongoose.model(collectionName, new Schema(schema, {versionKey: false}));