from admin.dboper import *
import datetime


# 查看一个知识专题的所有笔记信息（前台,）
def loadKnowledgeNoteByKTID (ktid):
    sql = "select kn.KNID, kt.KTID, kt.KTName, kn.KNTitle, KNAbstract, kn.CoAuthors, KNImage, KNUpdateDate from KnowledgeNote kn, KnowledgeTopic kt where kn.KTID = kt.KTID and kt.KTID=%s order by KNOrder" % ktid
    results = mySQL_Query(sql)
    return results


# 查看一个笔记信息（前台）
def loadKnowledgeNoteByKNID_Web (knid):
    sql = "select kn.KNID, kt.KTID, kt.KTName, KNTitle, IsOriginal, Source, OrigLink, CoAuthors, KNCreateDate, KNUpdateDate,  KNcontent, FileLink, PPTLink, VideoLink, CodeLink, DataLink from KnowledgeNote kn, KnowledgeTopic kt where kn.KTID = kt.KTID and kn.KNID=%s" % knid
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0]
    return results


def loadAllKnowledgeNote ():
    sql = "select kn.KNID, kt.KTName, kn.KNTitle, kn.Author, kn.KNUpdateDate, kn.KNStatus from KnowledgeNote kn, KnowledgeTopic kt where kn.KTID = kt.KTID order by kn.KNUpdateDate"
    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] = "显示"
            results2.append(row2)
    return results2


# 加载所有笔记信息
def loadKnowledgeNote_Top6 ():
    sql = "select kn.KNID, kt.KTName, kn.KNTitle, kn.Author, kn.KNUpdateDate, kn.KNStatus from KnowledgeNote kn, KnowledgeTopic kt where kn.KTID = kt.KTID order by kn.KNUpdateDate limit 0,6;"
    results = mySQL_Query(sql)  # 共6列

    # 将状态转为文字
    results2 = []
    for row in results:
        row2 = list(row)
        if row2[5] == 1:
            row2[5] = "正常"
        elif row2[5] == 2:
            row2[5] = "草稿"
        elif row2[5] == 3:
            row2[5] = "隐藏"
        results2.append(row2)
    return results2

#显示一个笔记(后台)
def loadKnowledgeNoteByKNID (knid):
    sql = "Select KNID, KTID, KNTitle, IsOriginal, Source, OrigLink, KNImage, CoAuthors, KNAbstract, KNcontent, FileLink, PPTLink, VideoLink, CodeLink, DataLink, KNIsShow From KnowledgeNote where KNID=%s" % knid
    results = mySQL_Query(sql)
    results = results[0]
    return results


# 根据CID查询一个课程信息
def loadKnowledgeNotewithKTNameByKNID (knid):
    sql = "select KNID, kt.KTName, KNTitle, IsOriginal, Source, OrigLink, KNImage, CoAuthors, KNAbstract, KNcontent, FileLink, PPTLink, VideoLink, CodeLink, DataLink, KNIsShow from KnowledgeNote kn, KnowledgeTopic kt where kn.KTID = kt.KTID and KNID=%s" % knid
    results = mySQL_Query(sql)
    if len(results) > 0:
        results = list(results[0])
        if results[14] == 1:
            results[14] = "正常"
        elif results[14] == 2:
            results[14] = "草稿"
        elif results[14] == 3:
            results[14] = "隐藏"
    return results


# KNID, KTID, KNTitle, IsOriginal, Source, OrigLink, KNImage, KNAbstract, KNcontent, KNCreateDate, KNUpdateDate
# FileLink, PPTLink, VideoLink, CodeLink, DataLink, Author, CoAuthors, KNIsShow, KNOrder, KNStatus
def add_KnowledgeNote (data):
    current_time = datetime.datetime.now()  # 将更新时间都设置为当前时间
    sql = "insert into KnowledgeNote values (NULL, %s, '%s', %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s','%s','%s','%s','%s','%s','%s', %s, 1, 1) " \
          % (
          data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7], current_time, current_time, data[8],
          data[9], data[10], data[11], data[12], data[13], data[13], data[14])
    i, msg = mySQL_Execute(sql)
    return i, msg


def del_KnowledgeNote (knid):
    sql = "delete from KnowledgeNote where KNID =%s" % knid
    i, msg = mySQL_Execute(sql)
    return i, msg


def edit_KnowledgeNote (data):
    current_time = datetime.datetime.now()  # 将更新时间都设置为当前时间
    sql = "update KnowledgeNote set KTID=%s, KNTitle='%s', IsOriginal=%s, Source='%s', OrigLink='%s', KNImage='%s', KNAbstract='%s', KNcontent='%s', KNUpdateDate='%s', FileLink='%s', PPTLink='%s', VideoLink='%s', CodeLink='%s', DataLink='%s', CoAuthors='%s', KNIsShow=%s where KNID=%s" \
          % (data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7], current_time, data[8], data[9],
             data[10], data[11], data[12], data[13], data[14], data[15])
    # print(sql)
    i, msg = mySQL_Execute(sql)
    return i, msg