server-front/app/model/user/expert.js

"use strict";
const Schema = require("mongoose").Schema;
const moment = require("moment");
const metaPlugin = require("naf-framework-mongoose-free/lib/model/meta-plugin");
const { Secret } = require("naf-framework-mongoose-free/lib/model/schema");
const { ObjectId } = require("mongoose").Types;

// 专家表
const expert = {
  name: { type: String, required: true }, // 用户名
  phone: { type: String, required: false, maxLength: 200 }, // 电话号码
  password: { type: Secret, required: true, select: false }, // 登录密码
  code: { type: String, required: false, default: "INVESTORS" }, // 邀请码
  role: { type: String, required: false, default: "5" }, // 角色
  email: { type: String, required: false, maxLength: 200 }, // 邮箱
  addr: { type: String, required: false, maxLength: 500 }, // 地址
  office_phone: { type: String, required: false, maxLength: 500 }, // 办公电话
  profession: { type: String, required: false, maxLength: 500 }, // 所属行业
  juris: { type: String }, // 辖区

  card: { type: String, required: false, maxLength: 200 }, // 身份证号
  birthDate: { type: String, required: false, maxLength: 500 }, // 出生日期
  qqwx: { type: String, required: false, maxLength: 500 }, // qq&微信
  school: { type: String, required: false, maxLength: 500 }, // 所在院校
  education: { type: String, required: false, maxLength: 500 }, // 最高学历
  major: { type: String, required: false, maxLength: 200 }, // 所学专业
  company: { type: String, required: false, maxLength: 500 }, // 单位名称
  zwzc: { type: String, required: false, maxLength: 500 }, // 职务职称
  img_path: { type: Array, required: false }, // 头像图片
  expertise: { type: String, required: false, maxLength: 500 }, // 擅长领域
  workexperience: { type: String, required: false, maxLength: 500 }, // 工作经历
  scientific: { type: String, required: false, maxLength: 500 }, // 科研综述
  undertakingproject: { type: String, required: false, maxLength: 500 }, // 承担项目
  scienceaward: { type: String, required: false, maxLength: 500 }, // 科技奖励
  social: { type: String, required: false, maxLength: 500 }, // 社会任职
  personal_id: { type: String, required: false, maxLength: 500 }, // 升级专家个人用户关联id
  status: { type: String, required: false, default: "0", maxLength: 500 }, // 审核状态,0-注册,1-通过,2-拒绝
  openid: { type: String, required: false }, // 微信openid
  isdel: { type: String, required: false, default: "0" }, // 0=>未删除;1=>已删除
  remark: { type: String, maxLength: 200 },
  create_time: { type: String },
};
const schema = new Schema(expert, { toJSON: { virtuals: true } });
schema.index({ id: 1 });
schema.index({ name: 1 });
schema.index({ phone: 1 });
schema.index({ code: 1 });
schema.index({ status: 1 });
schema.index({ "meta.createdAt": 1 });
schema.plugin(metaPlugin);
module.exports = (app) => {
  const { mongoose } = app;
  return mongoose.model("Expert", schema, "expert");
};