/**
 * 微信用户库，即患者数据库。
 *
 * 目前，患者真实数据存在于家庭医生平台数据库，IM数据库仅是做视图。将来根据需要将通过同步机制将数据同步到IM数据库。
 *
 * author: Sand
 * since: 2016/11/18
 */
"use strict";

let ImDb = require('./db/im.db');

class PatientRepo {
    constructor() {
    }

    static findOne(patientId, handler){
        ImDb.execQuery({
            "sql": "select id, name, sex, birthdate, avatar, openid from patients where id = ? ",
            "args": [patientId],
            "handler": handler
        });
    }

    static findWechatOpenId(code, handler) {
        var sql = "select openid from patients where id = ? ";

        ImDb.execQuery({
            "sql": sql,
            "args": [code],
            "handler": handler
        });
    }

    // TODO: 不能直接访问三师库
    static getPatientDoctorConsult(patient, doctor, handler) {
        var sql = "select * from wlyy_consult_team where patient = ? and doctor = ? and status = 0 and del = '1' ";

        ImDb.execQuery({
            "sql": sql,
            "args": [patient, doctor],
            "handler": handler
        });
    };
}

module.exports = PatientRepo;