from admin.dboper import *


# 查询网站菜单信息
def loadMenuInfo ():
    sql = "Select * From MenuInfo Order by MOrder"
    results = mySQL_Query(sql)
    return results


# 查询所有类别
def allmenu ():
    sql = "select * from menuinfo Order by MOrder"
    results = mySQL_Query(sql)
    return results


# #添加一个类别
# def add_menu(user):
#     sql = "insert into menuinfo values (NULL, '%s', '%s', %d) " % (user[0], user[1], int(user[2]))
#     results = mySQL_Execute(sql)
#     return results
#
# #更新一个类别
# def update_menu(user):
#     sql = "update menuinfo set PTNameCN='%s', PTNameEN='%s', PTOrder=%d where PTID='%s'" % (user[1], user[2], int(user[3]),user[0])
#     results = mySQL_Execute(sql)
#     return results

# 加载一个成果类别
def edit_menu (PTID):
    sql = "select *  from menuinfo where PTID=%s;" % PTID
    results = mySQL_Query(sql)
    return results


# 删除一个类别
def del_menu (userid):
    sql = "delete from menuinfo where PTID =%d" % int(userid)
    i, msg = mySQL_Execute(sql)
    return i, msg


# 查询网站菜单信息
def selectMenuInfo ():
    sql = "Select * From MenuInfo"
    results = mySQL_Query(sql)
    return results


# 添加一个菜单项
def add_menuUnit (Unit):
    # 中文名称, 英文名称, 菜单链接, 父级菜单, 排序
    sql = "insert into menuInfo values (NULL, '%s', '%s', '%s', 0, %d, %d) " % (
    Unit[0], Unit[1], Unit[2], int(Unit[3]), int(Unit[4]))
    i, msg = mySQL_Execute(sql)
    return i, msg


# 删除一个菜单项
def del_menuUnit (Unitid):
    sql = "delete from menuinfo where MenuID =%s" % Unitid
    i, msg = mySQL_Execute(sql)
    return i, msg


# 更新一个菜单项
def edit_menuUnit (Unit):
    # Unit = [Menuid, CNname, ENname, Link, Garde, Order]
    Menuid = Unit[0]
    CNname = Unit[1]
    ENname = Unit[2]
    Link = Unit[3]
    Garde = Unit[4]
    Order = Unit[5]
    sql = "update menuinfo set MenuNameCN='%s',MenuNameEN='%s',MURL='%s',ParentID='%s',MOrder='%s' where MenuID='%s'" % (
    CNname, ENname, Link, Garde, Order, Menuid)
    i, msg = mySQL_Execute(sql)
    return i, msg


# 加载一个菜单项
def loadMenuUnitbyID (Unitid):
    sql = "select *  from menuinfo where MenuID=%s;" % Unitid
    # print("sql:", sql)
    results = mySQL_Query(sql)
    return results