from admin.dboper import *
import datetime


# 查询所有知识专题(前台显示)
def loadAllKnowledgeTopicWithKTTName_Show ():
    sql = "Select kt.KTID, ktt.KTTID, ktt.KTTNameCN, KTName, KTImage,KTIntro From KnowledgeTopic kt, KnowledgeTopicType ktt where kt.KTTID = ktt.KTTID and KTIsShow=1 and KTStatus=1 order by KTOrder"
    results = mySQL_Query(sql)
    results2 = []
    for row in results:
        row = list(row)
        if len(row[5]) >40:
            row[5] = row[5][0:40] +"..."
        results2.append(row)
    return results2

#根据专题ID查询专题名称(前台显示)
def getKTNameByKTID(ktid):
    sql = "Select KTName From KnowledgeTopic where KTID = %s" % ktid
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0][0]
    return results


# 前台, 查看一个类别的所有知识库信息
def loadKnowlegeTopicByKTTID (kttid):
    sql = "Select kt.*, ktt.KTTName From KnowledgeTopic kt, KnowledgeTopicType ktt where kt.KTTID = ktt.KTTID and ktt.KTTID=%s" % (
        kttid)
    results = mySQL_Query(sql)
    return results


# 前台, 查看一个知识库的信息
def loadKTNameByKTID (ktid):
    sql = "Select KTName From KnowledgeTopic where KTID =%s" % (ktid)
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0]
    return results


# 查询所有知识专题
def loadAllKnowledgeTopic ():
    sql = "Select * From KnowledgeTopic where KTStatus=1 order by KTOrder"
    results = mySQL_Query(sql)
    return results


# 查询所有知识专题
def loadKnowledgeTopic_Top6 ():
    sql = "Select * From KnowledgeTopic limit 0,6"
    results = mySQL_Query(sql)
    return results


# 查询所有知识专题
def loadAllKnowledgeTopicWithKTTName ():
    sql = "Select kt.KTID, ktt.KTTNameCN, KTName, KTImage, KTIsShow, KTOrder, KTStatus From KnowledgeTopic kt, KnowledgeTopicType ktt where kt.KTTID = ktt.KTTID"
    results = mySQL_Query(sql)  # 共9列
    # 将状态转为文字
    results2 = []
    if len(results) > 0:
        for row in results:
            row2 = list(row)
            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


# 根据CID查询一个知识专题
def loadKnowledgeTopicbyID (ktid):
    sql = "Select * From KnowledgeTopic where KTID=%s" % ktid
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0]
    return results


# 根据CID查询一个知识专题
def loadKnowledgeTopicwithKTTNamebyID (ktid):
    sql = "Select kt.KTID, ktt.KTTNameCN, KTName, KTIntro, KTImage, KTIsShow, KTOrder, KTStatus From KnowledgeTopic kt, KnowledgeTopicType ktt where kt.KTTID = ktt.KTTID and kt.KTID=%s" % ktid
    results = mySQL_Query(sql)
    # 将状态转为文字
    results2 = []
    if len(results) > 0:
        for row in results:
            row2 = list(row)
            if row2[5] == 0:
                row2[5] = "不显示"
            elif row2[5] == 1:
                row2[5] = "显示"

            if row2[7] == 1:
                row2[7] = "启用"
            elif row2[7] == 2:
                row2[7] = "禁用"
            results2.append(row2)
    # print(len(results2))
    return results2[0]


# 添加一个知识专题
def add_KnowledgeTopic (data):
    # KTID, KTTID, KTName, KTIntro, KTImage, KTIsShow, KTOrder, KTStatus
    sql = "insert into KnowledgeTopic values (NULL, %s, '%s', '%s', '%s', %s, %s, %s) " % (
    data[0], data[1], data[2], data[3], data[4], data[5], data[6])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 修改一个知识专题
def update_KnowledgeTopic (data):
    current_time = datetime.datetime.now()  # 修改时,创建时间不动, 将更新时间设置为当前时间
    sql = "update KnowledgeTopic set KTTID=%s, KTName='%s', KTIntro='%s', KTImage='%s', KTIsShow=%s, KTOrder=%s, KTStatus=%s where KTID=%s" % (
    data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 删除一个知识专题
def del_KnowledgeTopic (ktid):
    sql = "delete from KnowledgeTopic where KTID =%s" % ktid
    i, msg = mySQL_Execute(sql)
    return i, msg