from admin.dboper import *

# 查询所有知识专题类别（前台显示）
def loadAllKnowledgeTopicType_ForeWeb (menu):
    sql =""
    if menu=="Knoledge":
        sql = "Select KTTID, KTTNameCN, KTTNameEN From KnowledgeTopicType where MenuID=7 and KTTIsShow=1 and KTTStatus=1 order by KTTOrder"
    elif menu=="ResNotes":
        sql = "Select KTTID, KTTNameCN, KTTNameEN From KnowledgeTopicType where MenuID=10 and KTTIsShow=1 and KTTStatus=1 order by KTTOrder"
    results = mySQL_Query(sql)
    return results

# 查询所有知识专题类别（后台管理）
def loadAllKnowledgeTopicType_4Manage ():
    sql = "Select * From KnowledgeTopicType Order by MenuID, KTTOrder"
    results = mySQL_Query(sql)
    # 将状态转为文字
    results2 = []
    for row in results:
        row2 = list(row)
        #所属栏目
        if row2[1] == 7:
            row2[1] = "知识库"
        elif row2[1] ==10:
            row2[1] = "科研笔记"
        # 是否显示
        if row2[4] == 0:
            row2[4] = "不显示"
        elif row2[4] == 1:
            row2[4] = "显示"
        # 状态
        if row2[6] == 1:
            row2[6] = "启用"
        elif row2[6] == 2:
            row2[6] = "禁用"
        results2.append(row2)
    # print(results2)
    return results2

# 查询所有知识专题类别（后台-专题选择）
def loadAllKnowledgeTopicType_4Topic ():
    #将“栏目名称“和”专题类别名称“进行拼接
    sql = "Select KTTID, concat(MenuNameCN, '-', KTTNameCN) as KTTNameCN From KnowledgeTopicType ktt, MenuInfo mi where ktt.MenuID=mi.MenuID Order by ktt.MenuID, KTTOrder"
    results = mySQL_Query(sql)
    return results



# 添加一个知识专题类别
def add_KnowledgeTopicType (data):
    # kttnamecn, kttnameen, kttisshow, kttorder, kttstatus
    sql = "insert into KnowledgeTopicType values (NULL,%s, '%s', '%s', %s, %s, %s) " % (
    data[0], data[1], data[2], data[3], data[4], data[5])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 编辑一个知识专题类别
def edit_KnowledgeTopicType (data):
    sql = "update KnowledgeTopicType set MenuID=%s, KTTNameCN='%s', KTTNameEN='%s', KTTIsShow=%s, KTTOrder=%s, KTTStatus=%s where KTTID=%s" % (
    data[0], data[1], data[2], data[3], data[4], data[5], data[6])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 前台, 查看一个知识专题类别
def loadKnowlegeTypeByKTTID (kttid):
    sql = "select KTTID, KTTNameCN, KTTNameEN from KnowledgeTopicType where KTTID=%s" % (kttid)
    results = mySQL_Query(sql)
    # 返回第一行
    if len(results) > 0: results = results[0]
    return results


# 删除一个知识专题类别
def del_KnowledgeTopicType (kttid):
    sql = "delete from KnowledgeTopicType where KTTID =%s" % kttid
    i, msg = mySQL_Execute(sql)
    return i, msg


# 查看一个知识专题类别
def view_KnowledgeTopicTypeByID (kttid):
    sql = "select * from KnowledgeTopicType where KTTID=%s" % (kttid)
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0]
    return results


# 查看一个知识专题类别
def view_KnowledgeTopicTypeByID2 (kttid):
    sql = "select * from KnowledgeTopicType where KTTID=%s" % (kttid)
    results = mySQL_Query(sql)
    if len(results) > 0:
        row = results[0]
        row = list(row)
        # 所属栏目
        if row[1] == 7:
            row[1] = "知识库"
        elif row[1] == 10:
            row[1] = "科研笔记"
        #是否显示
        if row[4] == 0:
            row[4] = "不显示"
        elif row[4] == 1:
            row[4] = "显示"
        # 状态
        if row[6] == 1:
            row[6] = "启用"
        elif row[6] == 2:
            row[6] = "禁用"
    return row