def operate(endtime, flowstatus, id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "update folder_dfs_flow SET flow_status=%s,end_time=%s where id=%s"
conncur.execute(connsql, (flowstatus, endtime, id))
conn.commit()
conn.close()
return 1
except Exception as e:
print(e)
def insert_management_configuration_dfs_api(dfs_api, domain):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "insert INTO management_configuration(dfs_api,domain) VALUE (%s,%s)"
conncur.execute(connsql, (dfs_api, domain))
conn.commit()
conn.close()
return True
except Exception as e:
return False
def del_management_configuration_dfs():
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "update management_configuration SET dfs_group=NULL,Basic_authority=NULL,dfs_manager=NULL,AD_time=0,dfs_relation_name=NULL,dfs_relation=NULL,dfs_relation_mail=NULL"
conncur.execute(connsql, ())
conn.commit()
conn.close()
return True
except Exception as e:
return False
def update_management_configuration_dfs_api(dfs_api):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "update management_configuration SET dfs_api=%s"
conncur.execute(connsql, (dfs_api))
conn.commit()
conn.close()
return True
except Exception as e:
return False
def update_management_configuration_changepwdremindertips(vaule):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "update management_configuration SET pwdremindertips=%s"
conncur.execute(connsql, (vaule))
conn.commit()
conn.close()
return True
except Exception as e:
return False
def show_level2name(level2_id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * from folder_level2 WHERE level2_id=%s"
conncur.execute(connsql, (level2_id))
level3dic = conncur.fetchone()
conn.commit()
conn.close()
return level3dic
except Exception as e:
return False
def getlevel2():
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "select * from folder_level2"
conncur.execute(connsql, ())
histroycounts = conncur.fetchall()
conn.commit()
conn.close()
return histroycounts
except Exception as e:
return False
def del_folder_first_choice_id(id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "delete from folder_first_choice WHERE id=%s"
conncur.execute(connsql, (id))
histroycounts = conncur.fetchall()
conn.commit()
conn.close()
return histroycounts
except Exception as e:
return False
def relationapprovaldb(relationstatus, relationtime, flowstatus, id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "update folder_dfs_flow SET relation_status=%s,relation_time=%s,flow_status=%s where id=%s"
conncur.execute(connsql,
(relationstatus, relationtime, flowstatus, id))
conn.commit()
conn.close()
return 1
except Exception as e:
print(e)
def showlevel2byusername(username):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM folder_level2 WHERE level2_manager=%s"
conncur.execute(connsql, (username))
level2namelists = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return level2namelists
def get_management_configuration_copy():
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "select * from management_configuration_copy limit1 "
conncur.execute(connsql, ())
histroycounts = conncur.fetchone()
conn.commit()
conn.close()
return histroycounts
except Exception as e:
return False
def showgroupnamebyrelation(folder_level3_id, perm_value):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM manager_dfs_group WHERE folder_level3_id=%s and perm_value=%s"
conncur.execute(connsql, (folder_level3_id, perm_value))
groupnames = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return groupnames
def directorapproval(directorstatus, directortime, flowstatus, id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "update folder_dfs_flow SET director_status=%s,director_time=%s,flow_status=%s where id=%s"
conncur.execute(connsql,
(directorstatus, directortime, flowstatus, id))
conn.commit()
conn.close()
return 1
except Exception as e:
print(e)
def get_api(title):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "select * from api where title=%s "
conncur.execute(connsql, (title))
histroycounts = conncur.fetchone()
conn.commit()
conn.close()
return histroycounts
except Exception as e:
return False
def showmyapproval(username):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = """SELECT * FROM folder_dfs_flow WHERE director_adaccount=%s AND flow_status=0"""
conncur.execute(connsql, (username))
approvelists = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return approvelists
def checkusernameissamerelation(id, flow_status):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM folder_dfs_flow where id in %(id)s and flow_status = %(flow_status)s"
conncur.execute(connsql, {"id": id, "flow_status": flow_status})
username = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return username
def getflowbygroupandusername(username, groupname):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM folder_dfs_flow WHERE username=%s and group_name=%s and flow_status=3"
conncur.execute(connsql, (username, groupname))
dictflowids = conncur.fetchall()
conn.commit()
conn.close()
return dictflowids
except Exception as e:
print(e)
return False
def showgroupname(level3id, pervalue):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT group_name from manager_dfs_group where folder_level3_id=%s and perm_value=%s "
conncur.execute(connsql, (level3id, pervalue))
groupname = conncur.fetchone()
conn.commit()
conn.close()
return groupname
except Exception as e:
print(e)
return False
def showlevel3(level2id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT DISTINCT(folder_level3.LEVEL3_id),name,(folder_level3.level3_path) from folder_tree LEFT JOIN folder_level3 ON folder_level3.level3_id=folder_tree.level3_id where level2_id=%s"
conncur.execute(connsql, (level2id))
level3 = conncur.fetchall()
conn.commit()
conn.close()
return level3
except Exception as e:
print(e)
return False
def showlevel3name(level3id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT name from folder_level3 WHERE level3_id=%s"
conncur.execute(connsql, (level3id))
level3dic = conncur.fetchone()
conn.commit()
conn.close()
level3name = level3dic['name']
except Exception as e:
print(e)
return level3name
def showlevel3names(level3_ids):
conn = dbinfo()
try:
conncur = conn.cursor()
# connsql=""SELECT name from folder_level3 where level3_id in (%s)"" % (level3_idlist)
connsql = "SELECT name from folder_level3 where level3_id in %(ids)s"
conncur.execute(connsql, {"ids": level3_ids})
level3_namelist = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return level3_namelist
def checkdiretorissamerelation(id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM folder_dfs_flow where id=%s"
conncur.execute(connsql, (id))
accounts = conncur.fetchone()
conn.commit()
conn.close()
return accounts
except Exception as e:
print(e)
return False
def checkflow(username, groupname):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT count(folder_dfs_flow.id) as counts from folder_dfs_flow where username=%s and group_name=%s AND flow_status<'3'"
conncur.execute(connsql, (username, groupname))
flowidcounts = conncur.fetchone()
conn.commit()
conn.close()
return flowidcounts
except Exception as e:
print(e)
return 0
def get_manager_dfs_group_from(level3_path):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM manager_dfs_group WHERE level3_path=%s"
conncur.execute(connsql, (level3_path))
dictflowids = conncur.fetchall()
conn.commit()
conn.close()
return dictflowids
except Exception as e:
print(e)
return False
def sel_folder_dfs_flow_id(id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM folder_dfs_flow where id = %s"
conncur.execute(connsql, (id))
dictflowids = conncur.fetchone()
conn.commit()
conn.close()
return dictflowids
except Exception as e:
print(e)
return False
def showrelationadaccountemail(relation_adaccount):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = """SELECT * FROM folder_dfs_flow
where relation_adaccount=%s and flow_status=1"""
conncur.execute(connsql, (relation_adaccount))
approvelists = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return approvelists
def sel_folder_api_log():
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT * FROM folder_api_log ORDER by folder_api_log.times DESC"
conncur.execute(connsql, ())
dictflowids = conncur.fetchall()
conn.commit()
conn.close()
return dictflowids
except Exception as e:
print(e)
return False
def showidemail(id, username):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = """SELECT * FROM folder_dfs_flow
where id in %(id)s and flow_status=3 AND username = %(username)s """
conncur.execute(connsql, {"id": id, "username": username})
approvelists = conncur.fetchall()
conn.commit()
conn.close()
except Exception as e:
print(e)
return approvelists
def dbinfo_select_global_configuration():
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "select * from global_configuration "
conncur.execute(connsql)
histroycounts = conncur.fetchall()
conn.commit()
conn.close()
return histroycounts
except Exception as e:
print(e)
return False
def showtreeid(level1id, level2id, level3id):
conn = dbinfo()
try:
conncur = conn.cursor()
connsql = "SELECT tree_id from folder_tree where level1_id=%s and level2_id=%s and level3_id=%s"
conncur.execute(connsql, (level1id, level2id, level3id))
treeid = conncur.fetchone()
conn.commit()
conn.close()
return treeid
except Exception as e:
print(e)
return False
