from admin.dboper import *


# 前台, 加载所有专利信息
def loadAllPatentInfo ():
    sql = "select * from patentinfo"
    results = mySQL_Query(sql)
    return results


# 直接加载专利信息
def loadPatentList_Top6 ():
    sql = "Select * From PatentInfo limit 0,6"
    results = mySQL_Query(sql)
    return results


# 查询所有专利信息
def loadallpatents ():
    sql = "select p.PatentID, rt.RTNameCN, p.PatentName, p.AppNo, p.PubNo, p.AppDate, p.PatentStatus  from patentinfo p, researchtopic rt where p.RTID = rt.RTID;"
    results = mySQL_Query(sql)
    results2 = []
    for row in results:
        row = list(row)
        row[2] = row[2][0:10] + "..."  # 标题

        if (row[6] == 1):
            row[6] = "进入审核"
        elif (row[6] == 2):
            row[6] = "已公开"

        results2.append(row)
    return results2


# PatentID, RTID, PatentName, AppNo, PubNo, PatentAbstract, PatentImage, PatentConent, PatentType, AppDate, PubDate, Patentee, Authors, PatentStatus, PStatus
# 添加专利信息
def add_patentinfo (data):
    sql = "insert into patentinfo values (NULL, %s, '%s', '%s', '%s', '%s', '%s', '%s', %s, '%s', '%s', '%s', '%s', %s, %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],
    data[12], data[13])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 根据专利编号查询一条专利信息
def loadPaperbyID (pid):
    sql = "select *  from patentinfo where PatentID =" + pid
    results = mySQL_Query(sql)
    if len(results) > 0:
        results = results[0]
    return results


# 根据PID查询一个专利信息
def loadPatentwithRTNamebyID (pid):
    sql = "select PatentID, RTNameCN, PatentName, AppNo, PubNo, PatentAbstract, PatentImage, PatentConent, PatentType, AppDate, PubDate, Patentee, Authors, PatentStatus, PStatus  from PatentInfo p, ResearchTopic rt where p.RTID = rt.RTID and p.PatentID=" + pid
    results = mySQL_Query(sql)
    if len(results) > 0:
        results = list(results[0])
        if results[13] == 1:
            results[13] = "进入实审"
        elif results[13] == 2:
            results[13] = "已公开"

        if results[14] == 1:
            results[14] = "显示"
        elif results[14] == 2:
            results[14] = "不显示"
    return results


# 添加专利信息
def update_patentinfo (data):
    sql = "update patentinfo set RTID=%s, PatentName='%s', AppNo='%s', PubNo='%s', PatentAbstract='%s', PatentImage='%s', PatentConent='%s', PatentType=%s, AppDate='%s', PubDate='%s', Patentee='%s', Authors='%s', PatentStatus=%s, PStatus=%s where PatentID=%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],
    data[12], data[13], data[14])
    #   print(sql)
    i, msg = mySQL_Execute(sql)
    return i, msg


# 删除一个专利信息
def del_patent (pid):
    sql = "delete from PatentInfo where PatentID=%s;" % pid
    # print("sql语句:", sql)
    i, msg = mySQL_Execute(sql)
    return i, msg


# 前台, 查看一个专利信息
def loadPatentInfoByID (pid):
    sql = "select *  from PatentInfo where PatentID=%s" % pid
    results = mySQL_Query(sql)
    results = results[0]
    return results