from admin.dboper import *

# 查询所有教师（前台显示）
def loadAllTeacher_Show ():
    sql = "select * from TeacherInfo where TIsShow=1 and TStatus=1 order by TOrder"
    results = mySQL_Query(sql)
    return results

# 根据教师编号查询教师信息(前台显示)
def loadTeacherInfoByID_Show (Tid):
    sql = "Select TID, TNameCN, TNameEN, TUniversityNameCN, TUniversityNameEN, TTitle, Email, TImage, ResearchArea, TIntro, MainWeb, GoogleWeb, AuthorID From TeacherInfo where TID=" + Tid
    results = mySQL_Query(sql)
    return results




# 查询所有教师
def loadAllTeacher ():
    sql = "select * from TeacherInfo"
    results = mySQL_Query(sql)
    return results



# 查询教师信息
def loadTeacherInfo ():
    sql = "Select * From TeacherInfo "  # where Teacherstatus=1
    results = mySQL_Query(sql)
    return results


# 根据教师编号查询教师信息
def loadTeacherInfoByID (Tid):
    sql = "Select * From TeacherInfo where TID=" + Tid
    results = mySQL_Query(sql)
    return results


# 添加一个教师
# TID, TNameCN, TNameEN, TUniversityNameCN, TUniversityNameEN, TTitle, Email, TImage, ResearchArea, TIntro, MainWeb, GoogleWeb, AuthorID, TIsShow, TOrder, TStatus
def add_TeacherInfo (data):
    sql = "insert into TeacherInfo values (NULL, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',NULL, 1, 1, 1) " % (
    data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7], data[8], data[9], data[10])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 更新一个教师
# TID,AuthorID, TName, TUniversityName, TCollegeName, TImage, TTitle, Email, ResearchArea, MainWeb, GoogleWeb, TIntro, TIsShow, TOrder, TStatus
def update_Teacher (data):
    sql = "update Teacherinfo set TNameCN='%s', TNameEN='%s', TUniversityNameCN='%s', TUniversityNameEN='%s', TTitle='%s', Email='%s', TImage='%s', ResearchArea='%s', TIntro='%s', MainWeb='%s', GoogleWeb='%s'  where TID=%s" % (
    data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7], data[8], data[9], data[10], data[11])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 查询一个教师
def loadTeacherByID (Tid):
    sql = "select * from Teacherinfo where TID=%s" % Tid
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0]
    return results


# 删除一个教师
def del_Teacher (Tid):
    sql = "delete from Teacherinfo where TID =%s" % Tid
    i, msg = mySQL_Execute(sql)
    return i, msg