SEEC-Portal-Front/server/model/teacher.js

const db = require('../config/db');
const getNowFormatTime = require('../util/time-processer');
const Teacher = db.import('../schema/teacher.js');

Teacher.sync();

class TeacherModel {

  static async findByUid(uid){
    return Teacher.findOne({
      where: {uid: uid}
    });
  }

  static async create({realName, organization, jobNumber, certificate = '', id, phone, email} ){
    try{
      let teacher = await Teacher.create({realName: realName, organization: organization, jobNumber: jobNumber,
        phone: phone, email: email, certificate: certificate,
        uid: id, createdTime: getNowFormatTime()});
      return true;
    }catch (e) {
      console.log(e);
      return false;
    }
  }

  static async updateInfo({realName, organization, jobNumber, certificate = '', uid} ){
    try{
      await Teacher.update({realName: realName, organization: organization, jobNumber: jobNumber, state: 'identifying'}, {where: {uid: uid}});
      return true;
    }catch (e) {
      console.log(e);
      return false;
    }
  }

  static async updateState(id, state){
    await Teacher.update({state: state}, {where: {id: id}});
    return true;
  }

  static async getApplications(){
    return Teacher.findAll({
      where: {state: 'identifying'}
    });
  }


}

module.exports = TeacherModel;